User.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | [ WE CAN DO IT MORE SIMPLE ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2018-2020 rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Author: TABLE ME
  8. // +----------------------------------------------------------------------
  9. // | Date: 2020-08-25 17:23
  10. // +----------------------------------------------------------------------
  11. declare (strict_types=1);
  12. namespace app\api\controller;
  13. use app\BaseController;
  14. use app\model\api\User as UserModel;
  15. use app\model\api\UserDetail as UserDetailModel;
  16. use app\model\api\ServiceType as ServiceTypeModel;
  17. use app\model\api\InfoAudit;
  18. use app\model\api\TypeAudit;
  19. use app\model\api\UserAudit;
  20. use app\model\api\ServiceType;
  21. use app\model\api\ServiceTimeType;
  22. use app\model\api\City as CityModel;
  23. use app\model\api\Sys as SysModel;
  24. use app\model\api\ShowTemplate;
  25. use app\model\api\ShowTemplateOrder;
  26. use app\model\api\UserShowTemplate;
  27. use app\model\api\PayTrade as PayTradeModel;
  28. use app\Request;
  29. use library\services\UtilService;
  30. use library\utils\QRcodeComm;
  31. use library\utils\IdentityCard;
  32. use library\utils\WxpayV2 as wxpayApi;
  33. use think\db\exception\DbException;
  34. use library\lib\weixina;
  35. use think\facade\Db;
  36. use think\Image;
  37. use think\Route;
  38. class User extends BaseController
  39. {
  40. /**
  41. * 获取用户详情
  42. * @param Request $request
  43. */
  44. public function userInfo(Request $request){
  45. //资料审核信息
  46. $infoAuditData = (new InfoAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  47. $userAuditData = (new UserAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  48. $typeAuditData = (new TypeAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  49. $data = [];
  50. $data['nickname'] = $request->user['nickname'];
  51. $data['mobile'] = $request->user['mobile'];
  52. $data['avatar'] = $request->user['avatar'];
  53. $data['name'] = $request->user['name'];
  54. $data['sex'] = $request->user['sex'];
  55. $data['info_audit_status'] = empty($infoAuditData)?-2:$infoAuditData["status"];
  56. $data['user_audit_status'] = empty($userAuditData)?-2:$userAuditData["status"];
  57. $data['type_audit_status'] = empty($typeAuditData)?-2:$typeAuditData["status"];
  58. return app('json')->success($data);
  59. }
  60. /**
  61. * 设置用户信息
  62. * @param Request $request
  63. */
  64. public function setUserInfo(Request $request){
  65. $post = UtilService::getMore([
  66. ['avatar',''],
  67. ['nickname',''],
  68. ['name',''],
  69. // ['mobile',''],
  70. ['sex', ''],
  71. ],$request);
  72. $save=[];
  73. if(!empty($post["avatar"])){
  74. $save["avatar"] = $post["avatar"];
  75. }
  76. if(!empty($post["nickname"])){
  77. $save["nickname"] = $post["nickname"];
  78. }
  79. if(!empty($post["name"])){
  80. $save["name"] = $post["name"];
  81. }
  82. // if(!empty($post["mobile"])){
  83. // if(is_mobile($post["mobile"])){
  84. // return app("json")->fail("请输入正确的手机号码");
  85. // }
  86. // $save["mobile"] = $post["mobile"];
  87. // }
  88. if(in_array((string)$post["sex"],["0","1","2"])){
  89. $save["sex"] = (int)$post["sex"];
  90. }
  91. if(empty($save)){
  92. return app("json")->fail("提交数据为空");
  93. }
  94. //是否需要审核
  95. $isInfoAudit = 0;
  96. if($isInfoAudit==0){
  97. $r = (new UserModel)->where("uid",$request->user["uid"])->update($save);
  98. if(!$r){
  99. return app("json")->fail("提交数据为空");
  100. }
  101. }else{
  102. $data = (new UserAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  103. if(!empty($data) && $data["status"]==0){
  104. return app('json')->fail("资料审核中,请勿重复提交");
  105. }
  106. $save["uid"] = $request->user["uid"];
  107. $save["status"] = 0;
  108. $r = (new UserAudit)->insert($save);
  109. if(!$r){
  110. return app("json")->fail("提交数据为空");
  111. }
  112. }
  113. return app("json")->success("提交成功");
  114. }
  115. /**
  116. * 绑定手机号
  117. * @param Request $request
  118. */
  119. public function bindMobile(Request $request){
  120. [$code] = UtilService::getMore([
  121. ['code', '', 'empty', 'code参数错误'],
  122. ], $request, true);
  123. if(!empty($request->user['mobile'])){
  124. return app('json')->fail("当前账户已绑定过手机号码");
  125. }
  126. $weixinA = new weixina();
  127. $data=$weixinA->getPhoneNumber($code);//新版
  128. if(empty($data) || empty($data['purePhoneNumber'])) {
  129. return app('json')->fail("绑定失败,请重新绑定01".$weixinA->error);
  130. }
  131. $save=[
  132. "countryCode"=>empty($data['countryCode'])?"":$data['countryCode'],
  133. "mobile"=>$data['purePhoneNumber'],
  134. ];
  135. $r = (new UserModel)->where('uid', $request->user['uid'])->update($save);
  136. if(!$r){
  137. return app('json')->fail("绑定失败,请重新绑定02");
  138. }
  139. $result = [];
  140. $result['nickname'] = $request->user['nickname'];
  141. $result['avatar'] = $request->user['avatar'];
  142. $result['token'] = $request->user['token'];
  143. $result['uip'] = $request->user['uip'];
  144. $result['is_mobile'] = 1;
  145. return app('json')->success($result);
  146. }
  147. /**
  148. * 获取名片信息
  149. * @param Request $request
  150. */
  151. public function getUserCardInfo(Request $request){
  152. $data = (new InfoAudit)->where("uid",$request->user["uid"])->where("status",1)->order("id","desc")->find();
  153. if(empty($data)){
  154. return app('json')->fail("您还没有通过名片信息审核");
  155. }
  156. $data = $data->toArray();
  157. $serviceTypeModel = new ServiceTypeModel();
  158. $data["birthday"] = empty($data["birthday"]) ?"":date("Y-m-d",$data["birthday"]);
  159. $data["time"] = date("Y-m-d H:i:s",$data["time"]);
  160. $data["service_audit_imgs"] = getImageAr($data["service_audit_imgs"]);
  161. $data["service_intro_imgs"] = getImageAr($data["service_intro_imgs"]);
  162. //服务区域
  163. $data["service_area"] = getImageAr($data["service_area"]);
  164. $data["service_area_all"] = [];
  165. foreach($data["service_area"] as $k2=>$v2){
  166. $data["service_area_all"][]=getAreaItemAr($v2);
  167. }
  168. //服务内容
  169. $data["service_project"] = getImageAr($data["service_project"]);
  170. $data["service_project_ar"] = [];
  171. if(!empty($data["service_project"])){
  172. $data["service_project_ar"] = $serviceTypeModel->where("id","in",$data["service_project"])->select();
  173. }
  174. $data["service_type_name"] = (new ServiceTimeType)->where("code",$data["service_type"])->value("title");
  175. unset($data["admin_id"]);
  176. unset($data["admin_mono"]);
  177. unset($data["admin_time"]);
  178. unset($data["uid"]);
  179. unset($data["id"]);
  180. unset($data["service_price"]);
  181. unset($data["service_area"]);
  182. unset($data["service_project"]);
  183. unset($data["service_audit_imgs"]);
  184. $typeData = (new TypeAudit)->where("uid",$request->user["uid"])->order("id","desc")->find();
  185. $data["is_type_audit"] = (empty($typeData) || $typeData["status"]!=1)?0:1;
  186. return app('json')->success($data);
  187. }
  188. /**
  189. * 提交资料审核
  190. * @param Request $request
  191. */
  192. public function subInfoAudit(Request $request){
  193. $data = (new InfoAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  194. if(!empty($data) && $data["status"]==0){
  195. return app('json')->fail("资料审核中,请勿重复提交");
  196. }
  197. $post = UtilService::getMore([
  198. ['avatar',''],
  199. ['name','','empty','请输入真实姓名'],
  200. ['mobile','','is_moblie','请输入正确的手机号码'],
  201. ['idcard','','empty','请输入正确的身份证号码'],
  202. ['birthday',''],
  203. ['service_type',''],
  204. ['service_price',''],
  205. ['service_min_price',''],
  206. ['service_max_price',''],
  207. ['service_area',[]],
  208. ['service_project',[]],
  209. ['service_intro_content',''],
  210. ['service_intro_imgs',[]],
  211. ['service_audit_imgs',[]],
  212. ['work_year',''],
  213. ['ancestral_place',''],
  214. ['education',''],
  215. ['minority',''],
  216. ],$request);
  217. if(!IdentityCard::isValid($post["idcard"])){
  218. return app('json')->fail("请输入正确的身份证号码");
  219. }
  220. $save=[];
  221. $save["avatar"] = empty($post["avatar"]) ? "" : $post["avatar"];
  222. $save["name"] = empty($post["name"]) ? "" : $post["name"];
  223. $save["mobile"] = empty($post["mobile"]) ? "" : $post["mobile"];
  224. $save["idcard"] = empty($post["idcard"]) ? "" : $post["idcard"];
  225. // $save["birthday"] = empty($post["birthday"])? 0 : strtotime($post["birthday"]);
  226. $save["constellation"] = IdentityCard::get_starsign($post["idcard"]);//星座
  227. $save["twelve"] = IdentityCard::get_zodiac($post["idcard"]);//星座
  228. $save["birthday"] = strtotime(IdentityCard::get_birthday($post["idcard"]));
  229. //服务类型
  230. if(!empty($post["service_type"])){
  231. $timeTypeData = (new ServiceTimeType)->where("code",$post["service_type"])->where("status",1)->select();
  232. if(empty($timeTypeData)){
  233. return app('json')->fail("服务时长类型不存在");
  234. }
  235. $save["service_type"] = $post["service_type"];
  236. }
  237. //服务价格区间
  238. $save["service_price"] = empty($post["service_price"]) ? "" : $post["service_price"];
  239. $save["service_min_price"] = empty($post["service_min_price"]) ? 0 : $post["service_min_price"];
  240. $save["service_max_price"] = empty($post["service_max_price"]) ? 0 : $post["service_max_price"];
  241. //服务区域
  242. $cityModel = new CityModel();
  243. if(!empty($post["service_area"]) && is_array($post["service_area"])){
  244. $saveAre=[];
  245. foreach($post["service_area"] as $k=>$v){
  246. if(empty(trim($v))){
  247. continue;
  248. }
  249. $itemData = $cityModel->where("name",trim($v))->where("level",2)->find();
  250. if(!empty($itemData)){
  251. $saveAre[]=$itemData["id"];
  252. }
  253. }
  254. if(!empty($saveAre)){
  255. $save["service_area"] = implode(",", $saveAre);
  256. }
  257. }
  258. //服务内容
  259. $serviceTypeModel = new ServiceTypeModel();
  260. if(!empty($post["service_project"]) && is_array($post["service_project"])){
  261. $saveCon=[];
  262. foreach($post["service_project"] as $k=>$v){
  263. if(empty(trim($v))){
  264. continue;
  265. }
  266. $itemData = $serviceTypeModel->where("id",(int)$v)->where("status",1)->find();
  267. if(!empty($itemData)){
  268. $saveCon[]=$itemData["id"];
  269. }
  270. }
  271. if(!empty($saveCon)){
  272. $save["service_project"] = implode(",", $saveCon);
  273. }
  274. }
  275. $save["service_intro_content"] = empty($post["service_intro_content"])?"": $post["service_intro_content"];
  276. $save["service_intro_imgs"] = empty($post["service_intro_imgs"]) ?"": implode(",", $post["service_intro_imgs"]);
  277. $save["service_audit_imgs"] = empty($post["service_audit_imgs"]) ?"": implode(",", $post["service_audit_imgs"]);
  278. $save['work_year'] = empty($post["work_year"]) ?"": $post["work_year"];
  279. $save['ancestral_place'] = empty($post["ancestral_place"])?"": $post["ancestral_place"];
  280. $save['education'] = empty($post["education"]) ?"": $post["education"];
  281. $save['minority'] = empty($post["minority"]) ?"": $post["minority"];
  282. $save["status"] = 0;
  283. $save["time"] = time();
  284. $save["uid"] = $request->user["uid"];
  285. $r = (new InfoAudit)->insertGetId($save);
  286. if(!$r){
  287. return app('json')->fail("系统错误");
  288. }
  289. $no = "CARD-".date("YmdHis")."-".$r;
  290. (new InfoAudit)->where("id",$r)->update(["no"=>$no]);
  291. return app('json')->success("提交成功,请耐心等待审核");
  292. }
  293. /**
  294. * 企业认证
  295. * @param Request $request
  296. */
  297. public function subTypeAudit(Request $request){
  298. $data = (new TypeAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  299. if(!empty($data) && $data["status"]==0){
  300. return app('json')->fail("平台审核中,请勿重复提交");
  301. }
  302. $post = UtilService::getMore([
  303. ['service_audit_imgs',[],"empty","请上传服务认证截图"],
  304. ],$request);
  305. $save=[];
  306. $save["service_audit_imgs"] = empty($post["service_audit_imgs"]) ?"": implode(",", $post["service_audit_imgs"]);
  307. $save["status"] = 0;
  308. $save["time"] = time();
  309. $save["uid"] = $request->user["uid"];
  310. if(empty($save["service_audit_imgs"])){
  311. return app('json')->fail("请上传服务认证截图");
  312. }
  313. $r = (new TypeAudit)->insertGetId($save);
  314. if(!$r){
  315. return app('json')->fail("系统错误");
  316. }
  317. $no = "CERT-".date("YmdHis")."-".$r;
  318. (new TypeAudit)->where("id",$r)->update(["no"=>$no]);
  319. return app('json')->success("提交成功,请耐心等待审核");
  320. }
  321. /**
  322. * 模板订单提交[第一步]
  323. * @param Request $request
  324. */
  325. public function subShowTemplateOrder(Request $request){
  326. [$id,$pay_type] = UtilService::getMore([
  327. ['id','','empty','参数错误'],
  328. ['pay_type','','empty','请选择支付方式'],
  329. ],$request,true);
  330. if(!in_array($pay_type,["wxpay","balance"])){
  331. return app('json')->fail('不支持该支付方式!');
  332. }
  333. //缓存
  334. $redis = \think\facade\Cache::store('redis');
  335. $key = 'show_template_order_sub_' . $request->user['uid'];
  336. $bool = $redis->handler()->exists($key);
  337. if ($bool) {
  338. return app('json')->fail('请务重复操作,请稍等在重试!');
  339. }
  340. $redis->set($key,1,5);//5秒缓存
  341. $proData = (new ShowTemplate)->where("id",$id)->where("status",1)->find();
  342. if(empty($proData)){
  343. return app('json')->fail("当前模板已下架");
  344. }
  345. $proData = $proData->toArray();
  346. $count = (new UserShowTemplate)->where("uid",$request->user['uid'])->where("show_template_id",$id)->count();
  347. if($count>0){
  348. return app('json')->fail("您已购买过当前模板");
  349. }
  350. //验证
  351. $orderCount = (new ShowTemplateOrder)->where("uid",$request->user['uid'])->where("show_template_id",$id)->where("status",1)->count();
  352. if($orderCount>0){
  353. return app('json')->fail("您已下单该模板,请勿重复下单");
  354. }
  355. $price = floatval($proData["price"]);
  356. // if($price<0.01){
  357. // return app('json')->fail("模板信息错误");
  358. // }
  359. $allMoney = $price;//订单商品费用
  360. $total_money = $allMoney;//订单总费用
  361. $payMoney = $total_money;//订单需支付费用
  362. $payMoney = $payMoney <= 0 ? 0 : $payMoney;
  363. $nowTime = time();
  364. //余额支付验证
  365. if($pay_type=="balance" && $payMoney > $request->user["money"]){
  366. return app('json')->fail("当前余额不足");
  367. }
  368. //主订单数据
  369. $save=[];
  370. $save['uid'] = $request->user['uid'];
  371. $save['order_id'] = makeOrderId($request->user['uid'],"ST");
  372. $save['pay_type'] = $pay_type;//
  373. $save['total_money'] = $total_money;//订单总金额
  374. $save['all_money'] = $allMoney;//商品中金额
  375. $save['pay_money'] = $payMoney;//实际支付金额
  376. $save['balance'] = 0;//余额支付了多少(目前不用)
  377. $save['status'] = $payMoney <= 0 ? 1 : 0;
  378. $save['pay_time'] = $payMoney <= 0 ? time() : 0;
  379. $save['time'] = $nowTime;
  380. $save['show_template_id'] = $proData["id"];
  381. $save['show_template_title'] = $proData["title"];;
  382. $save['show_template_price'] = $proData["price"];
  383. $save['show_template_img'] = empty($proData["imgs"]) ? "" : explode(",", $proData["imgs"])[0];
  384. $save['show_template_code'] = $proData["code"];
  385. //余额实时支付
  386. if($pay_type=="balance"){
  387. $save['status'] = 1;
  388. $save['pay_time'] = time();
  389. }
  390. try{
  391. Db::startTrans();
  392. $o_id = (new ShowTemplateOrder)->insertGetId($save);
  393. if(empty($o_id)){
  394. return app('json')->fail("订单提交失败");
  395. }
  396. //不需要支付
  397. if($payMoney<=0 && $save['status']==1){
  398. //验证并绑定当前模板
  399. (new UserShowTemplate)->userBindTemp($save["show_template_id"],$save['uid']);
  400. Db::commit();
  401. return app("json")->success(["order_id"=>$save['order_id'],"money"=>$payMoney,"status"=>$save['status']]);
  402. }
  403. //余额支付
  404. if($pay_type=="balance"){
  405. //验证并绑定当前模板
  406. (new UserShowTemplate)->userBindTemp($save["show_template_id"],$save['uid']);
  407. //修改用户余额
  408. $res = (new UserDetailModel)->balancePay($request->user["uid"],$payMoney,"show_temp_pay",["to_id"=>$o_id]);
  409. if(!$res){
  410. Db::rollback();
  411. return app('json')->fail("余额支付失败");
  412. }
  413. Db::commit();
  414. return app("json")->success(["order_id"=>$save['order_id'],"money"=>$payMoney,"status"=>$save['status']]);
  415. }
  416. //微信支付
  417. if(empty($request->user['openid'])){
  418. Db::rollback();
  419. return app('json')->fail('用户还未绑定微信!');
  420. }
  421. //清理之前支付凭证 || 防止重复购买
  422. $payTrade = (new PayTradeModel)
  423. ->where("uid",$request->user["uid"])
  424. ->where("o_id",$o_id)
  425. ->where("type","temp")
  426. ->where("status",0)
  427. ->where("time","<",time() - 7*24*60*60)
  428. ->select()
  429. ->toArray();
  430. $wxpay = new wxpayApi();
  431. foreach ($payTrade as $v) {
  432. // if($v['pay_type'] == 'wxpay') {
  433. // $result = $wxpay->closeOrder($v['pay_no']);
  434. // }
  435. (new PayTradeModel)->where("id",$v['id'])->where("status",0)->delete();
  436. }
  437. $mtime = microtime(true)*10000;
  438. $payOn = "T".date("Ymd").$mtime .rand(100,999) . $request->user['uid'];
  439. $out_trade_no="";
  440. $payType = $save["pay_type"];
  441. //添加交易记录
  442. $trade = [
  443. 'uid' => $request->user['uid'],
  444. 'o_id' => $o_id,
  445. 'order_id' =>$save["order_id"],
  446. 'pay_no' => $payOn,
  447. 'out_trade_no' => empty($out_trade_no) ? $payOn : $out_trade_no,
  448. 'pay_type' => $payType,
  449. 'money' => $payMoney,
  450. 'type' => 'temp',
  451. 'd_json' => serialize(['orderId'=>$save["order_id"],"give_score"=>0]),
  452. 'time' => time(),
  453. 'status' => 0,
  454. ];
  455. $r=(new PayTradeModel)->insert($trade);
  456. if(!$r){
  457. Db::rollback();
  458. return app('json')->fail('支付信息获取失败!');
  459. }
  460. $clictip = get_client_ip();
  461. if(empty($clictip)){
  462. $clictip = $request->ip();
  463. }
  464. $payData = $wxpay->wxmpPay([
  465. 'body' => "微信小程序购买模板",
  466. 'out_trade_no' => $payOn,
  467. 'total' => $payMoney,
  468. 'openid' => $request->user['openid'],
  469. 'payer_client_ip' => $clictip,
  470. ]);
  471. if(empty($payData)){
  472. Db::rollback();
  473. return app('json')->fail($wxpay->errorMsg);
  474. }
  475. Db::commit();
  476. $redis->delete($key);
  477. return app('json')->success([
  478. 'jsApiParameters'=> $payData,
  479. 'pay_no' => $payOn,
  480. 'order_id' => $save["order_id"],
  481. "status" => $save['status'],
  482. "money" => $payMoney,
  483. ]);
  484. } catch (DbException $db){
  485. Db::rollback();
  486. return app('json')->fail("订单生成失败");
  487. }
  488. }
  489. /**
  490. * 获取模板购买订单详情
  491. * @param Request $request
  492. */
  493. public function payShowTemplateOrderInfo(Request $request){
  494. [$order_id] = UtilService::getMore([
  495. ['order_id','','empty','参数错误'],
  496. ],$request,true);
  497. $data = (new ShowTemplateOrder)
  498. ->field("order_id,total_money,all_money,pay_money,status,time")
  499. ->where("order_id",$order_id)
  500. ->where("uid",$request->user["uid"])
  501. ->find();
  502. if(empty($data)){
  503. return app('json')->fail('信息不存在!');
  504. }
  505. $data=$data->toArray();
  506. if($data["status"]==0 && $data["time"]<time() - 30*60){
  507. (new ShowTemplateOrder)->where("id",$data["id"])->where("uid",$request->user["uid"])->update(["status"=>-1]);
  508. $data["status"]==-1;
  509. }
  510. $data["time"] = date("Y-m-d H:i:s",$data["time"]);
  511. return app('json')->success($data);
  512. }
  513. /**
  514. * 用户模板列表
  515. * @param Request $request
  516. */
  517. public function userShowTemplateList(Request $request){
  518. $post = UtilService::getMore([
  519. ['page', 1],
  520. ['pageSize', 50],
  521. ], $request);
  522. $post["pageSize"] = $post["pageSize"]>50 ? 50 : (int)$post["pageSize"];
  523. $post["page"] = $post["page"]<=0 ? 1 : (int)$post["page"];
  524. $where=[];
  525. $where[]=["ut.uid","=",$request->user["uid"]];
  526. $totalCount = (new UserShowTemplate)->alias("ut")->where($where)->count();
  527. $data=null;
  528. if($totalCount>0){
  529. $data = (new UserShowTemplate)
  530. ->field("ut.id,t.id as show_template_id,t.title,t.price,t.old_price,t.status,t.imgs,t.is_hot,t.is_recommend,t.code,look_count,t.real_sales,t.unreal_sales,ut.is_default")
  531. ->alias("ut")
  532. ->join("show_template t", "t.id = ut.show_template_id","left")
  533. ->where($where)
  534. ->order("ut.is_default", "desc")
  535. ->order("ut.id", "desc")
  536. ->page($post["page"], $post["pageSize"])
  537. ->select();
  538. foreach($data as $k=>$v){
  539. $data[$k]["is_use"] = 1;//是否已经购买或者可以使用
  540. $data[$k]["imgs"] = getImageAr($v["imgs"]);
  541. $data[$k]["img"] = empty($data[$k]["imgs"]) ? "" : $data[$k]["imgs"][0];
  542. $data[$k]["sales_count"] = $data[$k]["real_sales"] + $data[$k]["unreal_sales"];
  543. unset($data[$k]["real_sales"]);
  544. unset($data[$k]["unreal_sales"]);
  545. }
  546. }
  547. $data = empty($data)?[]:$data;
  548. return app('json')->success(["list" => $data, "pageSize" => $post["pageSize"],"page"=>$post["page"],"totalCount"=>$totalCount]);
  549. }
  550. /**
  551. * 设置默认模板
  552. * @param Request $request
  553. */
  554. public function setShowTemplate(Request $request){
  555. [$show_template_id] = UtilService::getMore([
  556. ['show_template_id','','empty','参数错误'],
  557. ],$request,true);
  558. (new UserShowTemplate)->where("uid",$request->user["uid"])->where("is_default",0)->update(["is_default"=>0]);
  559. (new UserShowTemplate)->where("uid",$request->user["uid"])->where("show_template_id",$show_template_id)->update(["is_default"=>1]);
  560. return app('json')->success("设置成功");
  561. }
  562. /**
  563. * 发布圈子
  564. * @param Request $request
  565. */
  566. public function upCircle(Request $request){
  567. $post = UtilService::getMore([
  568. ['id',''],
  569. ['title',''],
  570. ['content','','empty','请输入动态内容'],
  571. ['imgs',[]],
  572. ['video',''],
  573. ['video_img',''],
  574. ['video_time',0],
  575. ['pro_id',''],
  576. ],$request);
  577. $post["status"]=0;
  578. $post["imgs"] = empty($post["imgs"]) ? "" : $post["imgs"];
  579. $post["update_time"] = time();
  580. if(empty($post["imgs"]) && empty($post["video"])){
  581. return app('json')->fail("请至少上传一张主图");
  582. }
  583. if(!empty($post["imgs"])){
  584. $post["video"]="";
  585. $post["video_img"]="";
  586. $post["video_time"]=0;
  587. }
  588. if(!empty($post["video"])){
  589. $post["imgs"]="";
  590. if(empty($post["video_img"])){
  591. return app('json')->fail("视频封面错误");
  592. }
  593. if(empty($post["video_time"]) || (int)$post["video_time"]<=0){
  594. return app('json')->fail("视频时长错误");
  595. }
  596. }
  597. if(!empty($post["pro_id"])){
  598. $proData = (new Goods)->where("id",$post["pro_id"])->where("status",1)->find();
  599. if(empty($proData)){
  600. return app('json')->fail("当前商品不可选中");
  601. }
  602. }else{
  603. $post["pro_id"]=0;
  604. }
  605. $id = $post["id"];
  606. unset($post["id"]);
  607. $r=0;
  608. if(empty($id) || $id=="0"){
  609. $post["time"] = time();
  610. $post["uid"] = $request->user["uid"];
  611. $r = (new UserCircle)->insert($post);
  612. }else{
  613. $r = (new UserCircle)->where("id",$id)->update($post);
  614. }
  615. if($r){
  616. return app('json')->success("发布成功,等待客服审核。");
  617. }else{
  618. return app('json')->fail("数据保存失败");
  619. }
  620. }
  621. /**
  622. * 图片上传
  623. * @param Request $request
  624. * @return type
  625. */
  626. public function upload(Request $request){
  627. $sysData = (new SysModel())->where("id",1)->find();
  628. $file = $request->file('file');
  629. $code = $request->post("code","image");
  630. if(empty($file)) {
  631. return app('json')->fail("未上传文件");
  632. }
  633. if(!in_array($code, ["avatar","video","image","circle","advert","goods","activity"])){
  634. return app('json')->fail("上传路径错误");
  635. }
  636. $ext = $file->extension();
  637. if(!in_array($ext, array("png","jpeg","gif","jpg"))){
  638. return app('json')->fail("图片类型错误");
  639. }
  640. $upPath = \think\facade\Filesystem::disk('resource')->putFile( $code, $file);
  641. if(!$upPath){
  642. return app('json')->fail("上传失败01");
  643. }
  644. $savePath = $sysData['file_url'].'/resource/' . $upPath;
  645. $imgUrl = str_replace("\\", "/", $savePath);
  646. return app('json')->success(['img'=>$imgUrl]);
  647. }
  648. /**
  649. * 视频上传
  650. * @param Request $request
  651. * @return type
  652. */
  653. public function uploadVideo(Request $request){
  654. $sysData = (new SysModel())->where("id",1)->find();
  655. $file = $request->file('file');
  656. $code = $request->post("code","video");
  657. if(empty($file)) {
  658. return app('json')->fail("未上传文件");
  659. }
  660. if(!in_array($code, ["video"])){
  661. return app('json')->fail("上传路径错误");
  662. }
  663. $ext = $file->extension();
  664. if(!in_array($ext, array("mp4","megp4"))){
  665. return app('json')->fail("视频类型错误");
  666. }
  667. $upPath = \think\facade\Filesystem::disk('resource')->putFile( $code, $file);
  668. if(!$upPath){
  669. return app('json')->fail("上传失败01");
  670. }
  671. $savePath = $sysData['system_url'].'/resource/' . $upPath;
  672. $imgUrl = str_replace("\\", "/", $savePath);
  673. return app('json')->success(['video'=>$imgUrl]);
  674. }
  675. }