User.php 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993
  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\ServiceLabel as ServiceLabelModel;
  22. use app\model\api\ServiceTimeType;
  23. use app\model\api\City as CityModel;
  24. use app\model\api\Sys as SysModel;
  25. use app\model\api\ShowTemplate;
  26. use app\model\api\ShowTemplateOrder;
  27. use app\model\api\UserShowTemplate;
  28. use app\model\api\UserWorkType;
  29. use app\model\api\PayTrade as PayTradeModel;
  30. use app\Request;
  31. use library\services\UtilService;
  32. use library\utils\QRcodeComm;
  33. use library\utils\Qiniu;
  34. use library\utils\IdentityCard;
  35. use library\utils\WxpayV2 as wxpayApi;
  36. use think\db\exception\DbException;
  37. use library\lib\weixina;
  38. use think\facade\Db;
  39. use think\Image;
  40. use think\Route;
  41. class User extends BaseController
  42. {
  43. /**
  44. * 获取用户详情
  45. * @param Request $request
  46. */
  47. public function userInfo(Request $request){
  48. //资料审核信息
  49. $infoAuditData = (new InfoAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  50. $userAuditData = (new UserAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  51. $typeAuditData = (new TypeAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  52. $data = [];
  53. $data['uid'] = $request->user['uid'];
  54. $data['nickname'] = $request->user['nickname'];
  55. $data['mobile'] = $request->user['mobile'];
  56. $data['avatar'] = $request->user['avatar'];
  57. $data['name'] = $request->user['name'];
  58. $data['sex'] = $request->user['sex'];
  59. $data['type'] = $request->user['type'];//用户类型
  60. $data['type_name'] = "";//用户类型名称
  61. $data['work_type_id'] = $request->user['work_type_id'];//用户职称类型
  62. $data['work_type_title'] = $request->user['work_type_title'];//用户职称类型名称
  63. $data['card_look_count'] = $request->user['card_look_count'];//用户名片浏览次数
  64. $data['info_audit_status'] = empty($infoAuditData)?-2:$infoAuditData["status"];
  65. $data['user_audit_status'] = empty($userAuditData)?-2:$userAuditData["status"];
  66. $data['type_audit_status'] = empty($typeAuditData)?-2:$typeAuditData["status"];
  67. //资料通过需要重新提交认证
  68. if(!empty($infoAuditData) && !empty($typeAuditData)){
  69. if($infoAuditData["status"]==1 && $typeAuditData["status"]==1 && $infoAuditData["admin_time"]>$typeAuditData["admin_time"]){
  70. $data['type_audit_status'] = -3;
  71. }
  72. }
  73. $data['show_template_code'] = "";
  74. $data['show_template_id'] = "";
  75. $tmpData = (new UserShowTemplate)
  76. ->field("t.id,t.code,t.title,t.is_init,b.is_default")
  77. ->alias("b")
  78. ->join("show_template t","t.id = b.show_template_id","left")
  79. ->where("b.uid",$request->user['uid'])
  80. ->order("b.is_default","desc")
  81. ->order("b.id","desc")
  82. ->find();
  83. if(!empty($tmpData)){
  84. $data['show_template_code'] = $tmpData["code"];
  85. $data['show_template_id'] = $tmpData["id"];
  86. $data['show_template_init'] = $tmpData["is_init"];
  87. $data['show_template_default'] = $tmpData["is_default"];
  88. }
  89. return app('json')->success($data);
  90. }
  91. /**
  92. * 获取用户子级列表
  93. * @param Request $request
  94. */
  95. public function getChildList(Request $request){
  96. $post = UtilService::getMore([
  97. ['page', 1],
  98. ['pageSize', 50],
  99. ], $request);
  100. $post["pageSize"] = $post["pageSize"]>50 ? 50 : (int)$post["pageSize"];
  101. $post["page"] = $post["page"]<=0 ? 1 : (int)$post["page"];
  102. $post["parent_uid"]= $request->user["uid"];
  103. $data = (new UserModel)->getDataList($post,"u.uid,u.mobile,u.nickname,u.avatar");
  104. return app('json')->success($data);
  105. }
  106. /**
  107. * 设置用户信息
  108. * @param Request $request
  109. */
  110. public function setUserInfo(Request $request){
  111. $post = UtilService::getMore([
  112. ['avatar',''],
  113. ['nickname',''],
  114. ['name',''],
  115. // ['mobile',''],
  116. ['sex', ''],
  117. ],$request);
  118. $save=[];
  119. if(!empty($post["avatar"])){
  120. $save["avatar"] = $post["avatar"];
  121. }
  122. if(!empty($post["nickname"])){
  123. $save["nickname"] = $post["nickname"];
  124. }
  125. if(!empty($post["name"])){
  126. $save["name"] = $post["name"];
  127. }
  128. // if(!empty($post["mobile"])){
  129. // if(is_mobile($post["mobile"])){
  130. // return app("json")->fail("请输入正确的手机号码");
  131. // }
  132. // $save["mobile"] = $post["mobile"];
  133. // }
  134. if(in_array((string)$post["sex"],["0","1","2"])){
  135. $save["sex"] = (int)$post["sex"];
  136. }
  137. if(empty($save)){
  138. return app("json")->fail("提交数据为空");
  139. }
  140. //是否需要审核
  141. $isInfoAudit = 0;
  142. if($isInfoAudit==0){
  143. $r = (new UserModel)->where("uid",$request->user["uid"])->update($save);
  144. if(!$r){
  145. return app("json")->fail("提交数据为空");
  146. }
  147. }else{
  148. $data = (new UserAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  149. if(!empty($data) && $data["status"]==0){
  150. return app('json')->fail("资料审核中,请勿重复提交");
  151. }
  152. $save["uid"] = $request->user["uid"];
  153. $save["status"] = 0;
  154. $r = (new UserAudit)->insert($save);
  155. if(!$r){
  156. return app("json")->fail("提交数据为空");
  157. }
  158. }
  159. return app("json")->success("提交成功");
  160. }
  161. /**
  162. * 绑定手机号
  163. * @param Request $request
  164. */
  165. public function bindMobile(Request $request){
  166. [$code] = UtilService::getMore([
  167. ['code', '', 'empty', 'code参数错误'],
  168. ], $request, true);
  169. if(!empty($request->user['mobile'])){
  170. return app('json')->fail("当前账户已绑定过手机号码");
  171. }
  172. $weixinA = new weixina();
  173. $data=$weixinA->getPhoneNumber($code);//新版
  174. if(empty($data) || empty($data['purePhoneNumber'])) {
  175. return app('json')->fail("绑定失败,请重新绑定01".$weixinA->error);
  176. }
  177. $save=[
  178. // "countryCode"=>empty($data['countryCode'])?"":$data['countryCode'],
  179. "mobile"=>$data['purePhoneNumber'],
  180. ];
  181. // if($request->user["nickname"]=="微信用户"){
  182. // $save["nickname"] = $data['purePhoneNumber'];
  183. // }
  184. $r = (new UserModel)->where('uid', $request->user['uid'])->update($save);
  185. if(!$r){
  186. return app('json')->fail("绑定失败,请重新绑定02");
  187. }
  188. $result = [];
  189. $result['nickname'] = $request->user['nickname'];
  190. $result['avatar'] = $request->user['avatar'];
  191. return app('json')->success($result);
  192. }
  193. /**
  194. * 获取名片信息
  195. * @param Request $request
  196. */
  197. public function getUserCardInfo(Request $request){
  198. $data = (new InfoAudit)->getItem(["uid"=>$request->user["uid"],"status"=>1]);
  199. if(empty($data)){
  200. return app('json')->fail("您还没有通过名片信息审核");
  201. }
  202. $typeData = (new TypeAudit)->where("uid",$request->user["uid"])->order("id","desc")->find();
  203. $data["is_type_audit"] = (empty($typeData) || $typeData["status"]!=1)?0:1;
  204. return app('json')->success($data);
  205. }
  206. /**
  207. * 提交资料审核
  208. * @param Request $request
  209. */
  210. public function subInfoAudit(Request $request){
  211. $data = (new InfoAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  212. if(!empty($data) && $data["status"]==0){
  213. return app('json')->fail("资料审核中,请勿重复提交");
  214. }
  215. $post = UtilService::getMore([
  216. ['avatar',''],
  217. ['name','','empty','请输入真实姓名'],
  218. ['mobile','','is_moblie','请输入正确的手机号码'],
  219. ['idcard','','empty','请输入正确的身份证号码'],
  220. ['birthday',''],
  221. ['service_type',''],
  222. ['service_price',''],
  223. ['service_min_price',''],
  224. ['service_max_price',''],
  225. ['service_area',[]],
  226. ['service_project',[]],
  227. ['service_intro_content',''],
  228. ['service_intro_imgs',[]],
  229. ['service_audit_imgs',[]],//此处为我的证书
  230. ['service_imgs',[]],//我的服务照片
  231. ['work_year',''],
  232. ['ancestral_place',''],
  233. ['education',''],
  234. ['minority',''],
  235. ['user_work_type_id','0'],//服务职称
  236. ['service_label',[]],//服务标签
  237. ],$request);
  238. if(!IdentityCard::isValid($post["idcard"])){
  239. return app('json')->fail("请输入正确的身份证号码");
  240. }
  241. $save=[];
  242. $save["avatar"] = empty($post["avatar"]) ? "" : $post["avatar"];
  243. $save["name"] = empty($post["name"]) ? "" : $post["name"];
  244. $save["mobile"] = empty($post["mobile"]) ? "" : $post["mobile"];
  245. $save["idcard"] = empty($post["idcard"]) ? "" : $post["idcard"];
  246. // $save["birthday"] = empty($post["birthday"])? 0 : strtotime($post["birthday"]);
  247. $save["constellation"] = IdentityCard::get_starsign($post["idcard"]);//星座
  248. $save["twelve"] = IdentityCard::get_zodiac($post["idcard"]);//星座
  249. $save["birthday"] = strtotime(IdentityCard::get_birthday($post["idcard"]));
  250. //服务类型
  251. if(!empty($post["service_type"])){
  252. $timeTypeData = (new ServiceTimeType)->where("code",$post["service_type"])->where("status",1)->select();
  253. if(empty($timeTypeData)){
  254. return app('json')->fail("服务时长类型不存在");
  255. }
  256. $save["service_type"] = $post["service_type"];
  257. }
  258. //服务价格区间
  259. // $save["service_price"] = empty($post["service_price"]) ? "" : $post["service_price"];
  260. $save["service_min_price"] = empty($post["service_min_price"]) ? 0 : $post["service_min_price"];
  261. $save["service_max_price"] = empty($post["service_max_price"]) ? 0 : $post["service_max_price"];
  262. //服务区域
  263. $cityModel = new CityModel();
  264. if(!empty($post["service_area"]) && is_array($post["service_area"])){
  265. $saveAre=[];
  266. foreach($post["service_area"] as $k=>$v){
  267. if(empty(trim($v))){
  268. continue;
  269. }
  270. $itemData = $cityModel->where("name",trim($v))->where("level",2)->find();
  271. if(!empty($itemData)){
  272. $saveAre[]=$itemData["id"];
  273. }
  274. }
  275. if(!empty($saveAre)){
  276. $save["service_area"] = implode(",", $saveAre);
  277. }
  278. }
  279. //服务内容
  280. $serviceTypeModel = new ServiceTypeModel();
  281. if(!empty($post["service_project"]) && is_array($post["service_project"])){
  282. $saveCon=[];
  283. foreach($post["service_project"] as $k=>$v){
  284. if(empty(trim($v))){
  285. continue;
  286. }
  287. $itemData = $serviceTypeModel->where("id",(int)$v)->where("status",1)->find();
  288. if(!empty($itemData)){
  289. $saveCon[]=$itemData["id"];
  290. }
  291. }
  292. if(!empty($saveCon)){
  293. $save["service_project"] = implode(",", $saveCon);
  294. }
  295. }
  296. //服务标签
  297. $save["service_label"]="";
  298. $labelData = (new ServiceLabelModel)->getColumnList("id","id",$post["service_label"]);
  299. if(!empty($labelData)){
  300. $save["service_label"] = implode(",", $labelData);
  301. }
  302. $save["service_intro_content"] = empty($post["service_intro_content"])? "" : $post["service_intro_content"];
  303. $save["service_intro_imgs"] = empty($post["service_intro_imgs"]) ? "" : implode(",", $post["service_intro_imgs"]);
  304. $save["service_audit_imgs"] = empty($post["service_audit_imgs"]) ? "" : implode(",", $post["service_audit_imgs"]);
  305. $save["service_imgs"] = empty($post["service_imgs"]) ? "" : implode(",", $post["service_imgs"]);//我的服务展示
  306. $save['work_year'] = empty($post["work_year"]) ? "": $post["work_year"];
  307. $save['ancestral_place'] = empty($post["ancestral_place"])? "": $post["ancestral_place"];
  308. $save['education'] = empty($post["education"]) ? "": $post["education"];
  309. $save['minority'] = empty($post["minority"]) ? "": $post["minority"];
  310. $save["status"] = 0;
  311. $save["time"] = time();
  312. $save["uid"] = $request->user["uid"];
  313. //服务职称
  314. $save["user_work_type_id"] = empty($post["user_work_type_id"]) ? 0: (int)$post["user_work_type_id"];
  315. if($save["user_work_type_id"]>0 && (new UserWorkType)->where("id",$post["user_work_type_id"])->where("status",1)->count()<=0){
  316. return app('json')->fail("当前类型不能选择");
  317. }
  318. $r = (new InfoAudit)->insertGetId($save);
  319. if(!$r){
  320. return app('json')->fail("系统错误");
  321. }
  322. $no = "MYJ".date("Ymd").$r;
  323. (new InfoAudit)->where("id",$r)->update(["no"=>$no]);
  324. return app('json')->success("提交成功,请耐心等待审核");
  325. }
  326. /**
  327. * 平台认证
  328. * @param Request $request
  329. */
  330. public function subTypeAudit(Request $request){
  331. $data = (new TypeAudit)->where("uid",$request->user["uid"])->order("id desc")->find();
  332. if(!empty($data) && $data["status"]==0){
  333. return app('json')->fail("平台审核中,请勿重复提交");
  334. }
  335. $post = UtilService::getMore([
  336. ['service_audit_imgs',[],"empty","请上传服务认证截图"],
  337. ],$request);
  338. $save=[];
  339. $save["service_audit_imgs"] = empty($post["service_audit_imgs"]) ?"": implode(",", $post["service_audit_imgs"]);
  340. $save["status"] = 0;
  341. $save["time"] = time();
  342. $save["uid"] = $request->user["uid"];
  343. if(empty($save["service_audit_imgs"])){
  344. return app('json')->fail("请上传服务认证截图");
  345. }
  346. $r = (new TypeAudit)->insertGetId($save);
  347. if(!$r){
  348. return app('json')->fail("系统错误");
  349. }
  350. $no = "CERT-".date("YmdHis")."-".$r;
  351. (new TypeAudit)->where("id",$r)->update(["no"=>$no]);
  352. return app('json')->success("提交成功,请耐心等待审核");
  353. }
  354. /**
  355. * 模板订单提交[第一步]
  356. * @param Request $request
  357. */
  358. public function subShowTemplateOrder(Request $request){
  359. [$id,$pay_type] = UtilService::getMore([
  360. ['id','','empty','参数错误'],
  361. ['pay_type','','empty','请选择支付方式'],
  362. ],$request,true);
  363. if(!in_array($pay_type,["wxpay","balance"])){
  364. return app('json')->fail('不支持该支付方式!');
  365. }
  366. $weixinConfig = (new SysModel)->getWeixinConfig();
  367. // if(empty($weixinConfig)){
  368. // return app('json')->fail('支付配置为空!');
  369. // }
  370. //缓存
  371. $redis = \think\facade\Cache::store('redis');
  372. $key = 'show_template_order_sub_' . $request->user['uid'];
  373. $bool = $redis->handler()->exists($key);
  374. if ($bool) {
  375. return app('json')->fail('请务重复操作,请稍等在重试!');
  376. }
  377. $redis->set($key,1,5);//5秒缓存
  378. $proData = (new ShowTemplate)->where("id",$id)->where("status",1)->find();
  379. if(empty($proData)){
  380. return app('json')->fail("当前模板已下架");
  381. }
  382. $proData = $proData->toArray();
  383. $count = (new UserShowTemplate)->where("uid",$request->user['uid'])->where("show_template_id",$id)->count();
  384. if($count>0){
  385. return app('json')->fail("您已购买过当前模板");
  386. }
  387. //验证
  388. $orderCount = (new ShowTemplateOrder)->where("uid",$request->user['uid'])->where("show_template_id",$id)->where("status",1)->count();
  389. if($orderCount>0){
  390. return app('json')->fail("您已下单该模板,请勿重复下单");
  391. }
  392. $price = floatval($proData["price"]);
  393. // if($price<0.01){
  394. // return app('json')->fail("模板信息错误");
  395. // }
  396. $allMoney = $price;//订单商品费用
  397. $total_money = $allMoney;//订单总费用
  398. $payMoney = $total_money;//订单需支付费用
  399. $payMoney = $payMoney <= 0 ? 0 : $payMoney;
  400. $nowTime = time();
  401. //余额支付验证
  402. if($pay_type=="balance" && $payMoney > $request->user["money"]){
  403. return app('json')->fail("当前余额不足");
  404. }
  405. //主订单数据
  406. $save=[];
  407. $save['uid'] = $request->user['uid'];
  408. $save['order_id'] = makeOrderId($request->user['uid'],"ST");
  409. $save['pay_type'] = $pay_type;//
  410. $save['total_money'] = $total_money;//订单总金额
  411. $save['all_money'] = $allMoney;//商品中金额
  412. $save['pay_money'] = $payMoney;//实际支付金额
  413. $save['balance'] = 0;//余额支付了多少(目前不用)
  414. $save['status'] = $payMoney <= 0 ? 1 : 0;
  415. $save['pay_time'] = $payMoney <= 0 ? time() : 0;
  416. $save['time'] = $nowTime;
  417. $save['show_template_id'] = $proData["id"];
  418. $save['show_template_title'] = $proData["title"];;
  419. $save['show_template_price'] = $proData["price"];
  420. $save['show_template_img'] = empty($proData["imgs"]) ? "" : explode(",", $proData["imgs"])[0];
  421. $save['show_template_code'] = $proData["code"];
  422. //余额实时支付
  423. if($pay_type=="balance"){
  424. $save['status'] = 1;
  425. $save['pay_time'] = time();
  426. }
  427. try{
  428. Db::startTrans();
  429. $o_id = (new ShowTemplateOrder)->insertGetId($save);
  430. if(empty($o_id)){
  431. return app('json')->fail("订单提交失败");
  432. }
  433. //不需要支付
  434. if($payMoney<=0 && $save['status']==1){
  435. //验证并绑定当前模板
  436. (new UserShowTemplate)->userBindTemp($save["show_template_id"],$save['uid']);
  437. Db::commit();
  438. return app("json")->success(["order_id"=>$save['order_id'],"money"=>$payMoney,"status"=>$save['status']]);
  439. }
  440. //余额支付
  441. if($pay_type=="balance"){
  442. //验证并绑定当前模板
  443. (new UserShowTemplate)->userBindTemp($save["show_template_id"],$save['uid']);
  444. //修改用户余额
  445. $res = (new UserDetailModel)->balancePay($request->user["uid"],$payMoney,"show_temp_pay",["to_id"=>$o_id]);
  446. if(!$res){
  447. Db::rollback();
  448. return app('json')->fail("余额支付失败");
  449. }
  450. Db::commit();
  451. return app("json")->success(["order_id"=>$save['order_id'],"money"=>$payMoney,"status"=>$save['status']]);
  452. }
  453. //微信支付
  454. if(empty($request->user['openid'])){
  455. Db::rollback();
  456. return app('json')->fail('用户还未绑定微信!');
  457. }
  458. //清理之前支付凭证 || 防止重复购买
  459. $payTrade = (new PayTradeModel)
  460. ->where("uid",$request->user["uid"])
  461. ->where("o_id",$o_id)
  462. ->where("type","temp")
  463. ->where("status",0)
  464. ->where("time","<",time() - 7*24*60*60)
  465. ->select()
  466. ->toArray();
  467. $wxpay = new wxpayApi();
  468. // $wxpay = new wxpayApi($weixinConfig);
  469. foreach ($payTrade as $v) {
  470. // if($v['pay_type'] == 'wxpay') {
  471. // $result = $wxpay->closeOrder($v['pay_no']);
  472. // }
  473. (new PayTradeModel)->where("id",$v['id'])->where("status",0)->delete();
  474. }
  475. $mtime = microtime(true)*10000;
  476. $payOn = "T".date("Ymd").$mtime .rand(100,999) . $request->user['uid'];
  477. $out_trade_no="";
  478. $payType = $save["pay_type"];
  479. //添加交易记录
  480. $trade = [
  481. 'uid' => $request->user['uid'],
  482. 'o_id' => $o_id,
  483. 'order_id' =>$save["order_id"],
  484. 'pay_no' => $payOn,
  485. 'out_trade_no' => empty($out_trade_no) ? $payOn : $out_trade_no,
  486. 'pay_type' => $payType,
  487. 'money' => $payMoney,
  488. 'type' => 'temp',
  489. 'd_json' => serialize(['orderId'=>$save["order_id"],"give_score"=>0]),
  490. 'time' => time(),
  491. 'status' => 0,
  492. ];
  493. $r=(new PayTradeModel)->insert($trade);
  494. if(!$r){
  495. Db::rollback();
  496. return app('json')->fail('支付信息获取失败!');
  497. }
  498. $clictip = get_client_ip();
  499. if(empty($clictip)){
  500. $clictip = $request->ip();
  501. }
  502. $payData = $wxpay->wxmpPay([
  503. 'body' => "微信小程序购买模板",
  504. 'out_trade_no' => $payOn,
  505. 'total' => $payMoney,
  506. 'openid' => $request->user['openid'],
  507. 'payer_client_ip' => $clictip,
  508. ]);
  509. if(empty($payData)){
  510. Db::rollback();
  511. return app('json')->fail($wxpay->errorMsg);
  512. }
  513. Db::commit();
  514. $redis->delete($key);
  515. return app('json')->success([
  516. 'jsApiParameters'=> $payData,
  517. 'pay_no' => $payOn,
  518. 'order_id' => $save["order_id"],
  519. "status" => $save['status'],
  520. "money" => $payMoney,
  521. ]);
  522. } catch (DbException $db){
  523. Db::rollback();
  524. return app('json')->fail("订单生成失败");
  525. }
  526. }
  527. /**
  528. * 获取模板购买订单详情
  529. * @param Request $request
  530. */
  531. public function payShowTemplateOrderInfo(Request $request){
  532. [$order_id] = UtilService::getMore([
  533. ['order_id','','empty','参数错误'],
  534. ],$request,true);
  535. $data = (new ShowTemplateOrder)
  536. ->field("order_id,total_money,all_money,pay_money,status,time")
  537. ->where("order_id",$order_id)
  538. ->where("uid",$request->user["uid"])
  539. ->find();
  540. if(empty($data)){
  541. return app('json')->fail('信息不存在!');
  542. }
  543. $data=$data->toArray();
  544. if($data["status"]==0 && $data["time"]<time() - 30*60){
  545. (new ShowTemplateOrder)->where("id",$data["id"])->where("uid",$request->user["uid"])->update(["status"=>-1]);
  546. $data["status"]==-1;
  547. }
  548. $data["time"] = date("Y-m-d H:i:s",$data["time"]);
  549. return app('json')->success($data);
  550. }
  551. /**
  552. * 用户模板列表
  553. * @param Request $request
  554. */
  555. public function userShowTemplateList(Request $request){
  556. $post = UtilService::getMore([
  557. ['page', 1],
  558. ['pageSize', 50],
  559. ], $request);
  560. $post["pageSize"] = $post["pageSize"]>50 ? 50 : (int)$post["pageSize"];
  561. $post["page"] = $post["page"]<=0 ? 1 : (int)$post["page"];
  562. $where=[];
  563. $where[]=["ut.uid","=",$request->user["uid"]];
  564. $totalCount = (new UserShowTemplate)->alias("ut")->where($where)->count();
  565. $data=null;
  566. if($totalCount>0){
  567. $data = (new UserShowTemplate)
  568. ->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")
  569. ->alias("ut")
  570. ->join("show_template t", "t.id = ut.show_template_id","left")
  571. ->where($where)
  572. ->order("ut.is_default", "desc")
  573. ->order("ut.id", "desc")
  574. ->page($post["page"], $post["pageSize"])
  575. ->select();
  576. foreach($data as $k=>$v){
  577. $data[$k]["is_use"] = 1;//是否已经购买或者可以使用
  578. $data[$k]["imgs"] = getImageAr($v["imgs"]);
  579. $data[$k]["img"] = empty($data[$k]["imgs"]) ? "" : $data[$k]["imgs"][0];
  580. $data[$k]["sales_count"] = $data[$k]["real_sales"] + $data[$k]["unreal_sales"];
  581. unset($data[$k]["real_sales"]);
  582. unset($data[$k]["unreal_sales"]);
  583. }
  584. }
  585. $data = empty($data)?[]:$data;
  586. return app('json')->success(["list" => $data, "pageSize" => $post["pageSize"],"page"=>$post["page"],"totalCount"=>$totalCount]);
  587. }
  588. /**
  589. * 设置默认模板
  590. * @param Request $request
  591. */
  592. public function setShowTemplate(Request $request) {
  593. [$show_template_id] = UtilService::getMore([
  594. ['show_template_id', '', 'empty', '参数错误'],
  595. ], $request, true);
  596. (new UserShowTemplate)->where("uid", $request->user["uid"])->where("is_default", 1)->update(["is_default" => 0]);
  597. (new UserShowTemplate)->where("uid", $request->user["uid"])->where("show_template_id", $show_template_id)->update(["is_default" => 1]);
  598. return app('json')->success("设置成功");
  599. }
  600. /**
  601. * 获取邀请海报小程序码
  602. * @param Request $request
  603. */
  604. public function getWxmpInviteQrcode(Request $request){
  605. $inviteData = (new SysModel)->getDataInfo("invite");
  606. $bgimg = $inviteData["img"];
  607. if(!empty($request->user["invite_img"])){
  608. return app('json')->success(["qrcode"=>$request->user["invite_img"],"bgimg"=>$bgimg]);
  609. }
  610. $weixinA = new weixina();
  611. // $data = $weixinA->getUnlimitedQRCode("pages/index/index","scene=".$request->user["uid"]);
  612. $data = $weixinA->getUnlimitedQRCode("pages/index/index",$request->user["uid"]);
  613. // var_dump($data);
  614. if(empty($data)){
  615. return app('json')->fail("小程序码获取失败".$weixinA->error);
  616. }
  617. $base64 = 'data:'.$data['contentType'].';base64,'.base64_encode($data['buffer']);
  618. $res = $this->uploadImageBase64("wximg",$base64,1);
  619. if($res["code"]!=1){
  620. return app('json')->fail($res["msg"]);
  621. }
  622. (new UserModel)->where("uid",$request->user["uid"])->update(["invite_img"=>$res["url"]]);
  623. return app('json')->success(["qrcode"=>$res["url"],"bgimg"=>$bgimg]);
  624. }
  625. // public function getWxmpInviteQrcode2(Request $request){
  626. //
  627. // //获取小程序码
  628. // $weixinA = new weixina();
  629. // $data = $weixinA->getUnlimitedQRCode("pages/index/index","scene=".$request->user["uid"]);
  630. // if(empty($data)){
  631. // return app('json')->fail("小程序码获取失败".$weixinA->error);
  632. // }
  633. // $base64 = 'data:'.$data['contentType'].';base64,'.base64_encode($data['buffer']);
  634. // $code = "temp";
  635. // $sysData = (new SysModel())->where("id",1)->find();
  636. // $uploadConfig = config('filesystem');
  637. // //验证base64格式
  638. // preg_match('/^(data:\s*image\/(\w+);base64,)/',$base64, $result);
  639. // if(!$result){
  640. // return ["code"=>-1,"msg"=>"base64格式格式错误"];
  641. // }
  642. // //验证图片后缀
  643. // if (!in_array($result[2], $uploadConfig['image']['ext'], true)) {
  644. // return ["code"=>-1,"msg"=>"不支持的图片格式"];
  645. // }
  646. // $rootPath = config('filesystem.disks.resource.root');
  647. // $hashName = $code.DIRECTORY_SEPARATOR.date('Ymd') . DIRECTORY_SEPARATOR . md5((string) microtime(true)).".".$result[2];
  648. // $filePath = $rootPath. DIRECTORY_SEPARATOR .$hashName;
  649. // $path = dirname($filePath);
  650. // // 检测目录
  651. // if (!is_dir($path)) {
  652. // if (!mkdir($path, 0777, true)) {
  653. // return ["code"=>-1,"msg"=>"生成目录失败"];
  654. // }
  655. // return ["code"=>-1,"msg"=>"上传目录不存在"];
  656. // }
  657. // //重名文件验证
  658. // if (is_file($filePath)) {
  659. // return ["code"=>-1,"msg"=>"文件已存在"];
  660. // }
  661. // if(!file_put_contents($filePath, base64_decode(str_replace($result[1], '', $base64)))){
  662. // return ["code"=>-1,"msg"=>"文件报错失败"];
  663. // }
  664. //
  665. // //获取海报背景
  666. // $inviteData = (new SysModel)->getDataInfo("invite");
  667. // if(empty($inviteData["img"])){
  668. // return ["code"=>-1,"msg"=>"海报背景不存在"];
  669. // }
  670. // $bgimg =explode("resource", $inviteData["img"])[1];
  671. // if(empty($bgimg)){
  672. // return ["code"=>-1,"msg"=>"海报背景不存在"];
  673. // }
  674. //
  675. // $savePath = $rootPath. DIRECTORY_SEPARATOR .$code.DIRECTORY_SEPARATOR.date('Ymd') . DIRECTORY_SEPARATOR . md5((string) microtime(true))."b".".jpg";
  676. //
  677. //
  678. //
  679. //
  680. // $bg = $rootPath.$bgimg;
  681. // $bgSize = getimagesize($bg);
  682. // $qrcodeSize = getimagesize($filePath);
  683. // $handle = Image::open($bg);
  684. // $handle->water($filePath,[($bgSize[0]-$qrcodeSize[0])/2,($bgSize[1]-$qrcodeSize[1])/2]);
  685. // $handle->save($savePath,"jpg",80);
  686. // $qiniu = new Qiniu;
  687. // $img_url = $qiniu->updateFile('img', $savePath, $savePath);
  688. // if (empty($img_url['url'])) {
  689. // return ["code"=>-1,"msg"=>"文件报错失败:".$qiniu->getError()];
  690. // }
  691. // @unlink($filePath);
  692. // @unlink($savePath);
  693. // return ["code"=>1,"url"=>str_replace("\\", "/", $img_url['url'])];
  694. // }
  695. //
  696. // public function checkImgPath(){
  697. //
  698. // }
  699. /**
  700. * 图片合成
  701. * @param type $bg
  702. * @param type $qrcode
  703. * @param type $savePath
  704. */
  705. public function createPosterImg($bg,$qrcode,$savePath){
  706. }
  707. /**
  708. * 获取小程序码
  709. * @param Request $request
  710. */
  711. public function getWxmpQrcode(Request $request){
  712. $weixinA = new weixina();
  713. $data = $weixinA->getUnlimitedQRCode("pages/index/index","a=1");
  714. if(empty($data)){
  715. return app('json')->fail("小程序码获取失败".$weixinA->error);
  716. }
  717. $base64 = 'data:'.$data['contentType'].';base64,'.base64_encode($data['buffer']);
  718. $res = $this->uploadImageBase64("wximg",$base64);
  719. if($res["code"]!=1){
  720. return app('json')->fail($res["msg"]);
  721. }
  722. return app('json')->success(["img"=>$res["data"]]);
  723. }
  724. /**
  725. *
  726. * @param Request $request
  727. */
  728. public function uploadBase64(Request $request){
  729. [$img,$code] = UtilService::getMore([
  730. ['img', '','empty',"请上传图片"],
  731. ['code', 'image'],
  732. ], $request,true);
  733. // $imgAr = explode("base64,",$img);
  734. // if(empty($imgAr)){
  735. // return app("json")->fail("请上传base64图片");
  736. // }
  737. // $imgBase64 = count($imgAr)==1?$imgAr[0]:$imgAr[1];
  738. // //判断字符串是否经过编码方法
  739. // if($imgBase64!=base64_encode(base64_decode($imgBase64))){
  740. // return app("json")->fail("请上传base64图片");
  741. // }
  742. // $base64 = "data:application/octet-stream;base64,".$imgBase64;//七牛
  743. $res = $this->uploadImageBase64($code,$img);
  744. if($res["code"]!=1){
  745. return app('json')->fail($res["msg"]);
  746. }
  747. return app('json')->success(["img"=>$res["data"]]);
  748. }
  749. /**
  750. * 图片上传
  751. * @param Request $request
  752. * @return type
  753. */
  754. public function upload(Request $request){
  755. $uploadConfig = config('filesystem');
  756. $sysData = (new SysModel())->where("id",1)->find();
  757. $file = $request->file('file');
  758. $code = $request->post("code","image");
  759. if(empty($file)) {
  760. return app('json')->fail("未上传文件");
  761. }
  762. $size = $file->getSize();
  763. if(!empty($size) && $size>$uploadConfig["image"]["size"]*1024*1024){
  764. return app('json')->fail("图片不能超过{$uploadConfig["image"]["size"]}M");
  765. }
  766. if(!in_array($code, $uploadConfig['image']['path'])){
  767. return app('json')->fail("上传路径错误");
  768. }
  769. $ext = $file->extension();
  770. if(!in_array($ext, $uploadConfig['image']['ext'])){
  771. return app('json')->fail("图片类型错误");
  772. }
  773. $upPath = \think\facade\Filesystem::disk('resource')->putFile( $code, $file);
  774. if(!$upPath){
  775. return app('json')->fail("上传失败01");
  776. }
  777. $savePath = $sysData['system_url'].'/resource/' . $upPath;
  778. $imgUrl = str_replace("\\", "/", $savePath);
  779. return app('json')->success(['img'=>$imgUrl,'size'=>$size]);
  780. }
  781. /**
  782. * 视频上传
  783. * @param Request $request
  784. * @return type
  785. */
  786. public function uploadVideo(Request $request){
  787. $uploadConfig = config('filesystem');
  788. $sysData = (new SysModel())->where("id",1)->find();
  789. $file = $request->file('file');
  790. $code = $request->post("code","video");
  791. if(empty($file)) {
  792. return app('json')->fail("未上传文件");
  793. }
  794. if(!in_array($code, $uploadConfig['video']['path'])){
  795. return app('json')->fail("上传路径错误");
  796. }
  797. $ext = $file->extension();
  798. if(!in_array($ext, $uploadConfig['video']['ext'])){
  799. return app('json')->fail("视频类型错误");
  800. }
  801. $upPath = \think\facade\Filesystem::disk('resource')->putFile( $code, $file);
  802. if(!$upPath){
  803. return app('json')->fail("上传失败01");
  804. }
  805. $savePath = $sysData['system_url'].'/resource/' . $upPath;
  806. $imgUrl = str_replace("\\", "/", $savePath);
  807. return app('json')->success(['video'=>$imgUrl]);
  808. }
  809. /**
  810. * base64文件上传
  811. * @param type $code
  812. * @param type $base64
  813. */
  814. public function uploadImageBase64($code,$base64,$isQiniu=0){
  815. $sysData = (new SysModel())->where("id",1)->find();
  816. $uploadConfig = config('filesystem');
  817. //验证base64格式
  818. preg_match('/^(data:\s*image\/(\w+);base64,)/',$base64, $result);
  819. if(!$result){
  820. return ["code"=>-1,"msg"=>"base64格式格式错误"];
  821. }
  822. //验证图片后缀
  823. if (!in_array($result[2], $uploadConfig['image']['ext'], true)) {
  824. return ["code"=>-1,"msg"=>"不支持的图片格式"];
  825. }
  826. $rootPath = config('filesystem.disks.resource.root');
  827. $hashName = $code.DIRECTORY_SEPARATOR.date('Ymd') . DIRECTORY_SEPARATOR . md5((string) microtime(true)).".".$result[2];
  828. $filePath = $rootPath. DIRECTORY_SEPARATOR .$hashName;
  829. $path = dirname($filePath);
  830. // 检测目录
  831. if (!is_dir($path)) {
  832. if (!mkdir($path, 0777, true)) {
  833. return ["code"=>-1,"msg"=>"生成目录失败"];
  834. }
  835. return ["code"=>-1,"msg"=>"上传目录不存在"];
  836. }
  837. //重名文件验证
  838. if (is_file($filePath)) {
  839. return ["code"=>-1,"msg"=>"文件已存在"];
  840. }
  841. if(!file_put_contents($filePath, base64_decode(str_replace($result[1], '', $base64)))){
  842. return ["code"=>-1,"msg"=>"文件报错失败"];
  843. }
  844. //七牛上传
  845. if($isQiniu==1){
  846. $qiniu = new Qiniu;
  847. $img_url = $qiniu->updateFile('img', $filePath, $filePath);
  848. if (empty($img_url['url'])) {
  849. return ["code"=>-1,"msg"=>"文件报错失败:".$qiniu->getError()];
  850. }
  851. @unlink($filePath);
  852. return ["code"=>1,"url"=>str_replace("\\", "/", $img_url['url'])];
  853. }
  854. $savePath = $sysData['system_url'].config('filesystem.disks.resource.url').DIRECTORY_SEPARATOR.$hashName;
  855. return ["code"=>1,"url"=>str_replace("\\", "/", $savePath)];
  856. }
  857. /**
  858. * 七牛上传图片
  859. * @param Request $request
  860. */
  861. public function qiniuUpload(Request $request)
  862. {
  863. $file = $request->file('file');
  864. if (empty($file)) {
  865. return app('json')->fail("未上传文件");
  866. }
  867. $rootTmp = config('filesystem.disks.local.root') . '/' . \think\facade\Filesystem::putFile('tmp', $file);
  868. $image_size = @getimagesize($rootTmp);
  869. if ($image_size[0] > 1000) {
  870. $imgS = Image::open($rootTmp);
  871. $imgS->thumb(1000, $image_size[1]);
  872. $imgS->save($rootTmp);
  873. } else {
  874. if ($image_size[1] > 1000) {
  875. $imgS = Image::open($rootTmp);
  876. $imgS->thumb($image_size[0], 1000);
  877. $imgS->save($rootTmp);
  878. }
  879. }
  880. $qiniu = new Qiniu;
  881. $img_url = $qiniu->updateFile('img', $rootTmp, $rootTmp);
  882. if (empty($img_url['url'])) {
  883. return app('json')->fail($qiniu->getError());
  884. }
  885. @unlink($rootTmp);
  886. return app('json')->success(['img' => $img_url['url']]);
  887. }
  888. /**
  889. * 七牛上传token
  890. * @param Request $request
  891. */
  892. public function qiniuUploadToken(Request $request){
  893. [$bucket] = UtilService::getMore([
  894. ['bucket', ''],
  895. ], $request,true);
  896. $qiniu = new Qiniu;
  897. $token = $qiniu->createUploadToken($bucket);
  898. return app('json')->success(['token' => $token]);
  899. }
  900. /**
  901. * 获取用户总邀请人数
  902. * @param int $uid 用户ID
  903. * @return int 总邀请人数
  904. */
  905. public function getTotalInvites($uid)
  906. {
  907. return (new UserModel)->where('parent_uid', $uid)->count();
  908. }
  909. }