User.php 29 KB

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