User.php 41 KB

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