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