User.php 85 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189
  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\v1;
  13. use app\BaseController;
  14. use app\model\api\Sys as SysModel;
  15. use app\model\api\User as UserModel;
  16. use app\model\api\Bank as BankModel;
  17. use app\model\api\UserLove as UserLoveModel;
  18. use app\model\api\UserCircle;
  19. use app\model\api\UserCircleLove;
  20. use app\model\api\Goods;
  21. use app\model\api\GoodsLove;
  22. use app\model\api\Order;
  23. use app\model\api\OrderInfo;
  24. use app\model\api\OrderMono;
  25. use app\model\api\Activity;
  26. use app\model\api\ActivityOrder;
  27. use app\model\api\Tx as TxModel;
  28. use app\lib\OrderLib;
  29. use app\model\api\PayTrade as PayTradeModel;
  30. use app\model\api\UserDetail as UserDetailModel;
  31. use app\model\api\UserScoreDetail as UserScoreDetailModel;
  32. use app\model\api\UserAddress;
  33. use app\model\api\UserShop;
  34. use app\model\api\Coupon as CouponModel;
  35. use app\model\api\UserCoupon as UserCouponModel;
  36. use app\Request;
  37. use library\services\UtilService;
  38. use library\utils\QRcodeComm;
  39. use library\utils\weixinPay as wxpayApi;
  40. use think\db\exception\DbException;
  41. use library\lib\weixina;
  42. use think\facade\Db;
  43. use think\Image;
  44. use think\Route;
  45. class User extends BaseController
  46. {
  47. /**
  48. * 获取用户基本数据
  49. * @param Request $request
  50. */
  51. public function init(Request $request)
  52. {
  53. $result = [];
  54. $result['nickname'] = $request->user['nickname'];
  55. $result['avatar'] = $request->user['avatar'];
  56. $result['uip'] = $request->user['uip'];//用户UUID
  57. $result['is_bind_parent'] = $request->user['parent_uid']>0?1:0;//是否绑定父级
  58. $result['is_mobile'] = empty($request->user['mobile'])?0:1;//是否绑定手机号
  59. return app('json')->success($result);
  60. }
  61. /**
  62. * 会员中心信息
  63. * @param Request $request
  64. */
  65. public function info(Request $request)
  66. {
  67. $result = [];
  68. //基础信息
  69. $result['nickname'] = $request->user['nickname'];
  70. $result['avatar'] = $request->user['avatar'];
  71. $result['uip'] = $request->user['uip'];//用户UIP
  72. $result['score'] = $request->user['score'];
  73. $result['money'] = $request->user['money'];
  74. $result['is_bind_parent'] = $request->user['parent_uid']>0?1:0;//是否绑定父级
  75. $result['is_mobile'] = empty($request->user['mobile'])?0:1;//是否绑定手机号
  76. //动态发布信息
  77. $result['loveCount'] = (new UserLoveModel)->where("uid",$request->user["uid"])->count();//关注数
  78. $result['diaryCount'] = (new UserCircle)->where("uid",$request->user["uid"])->where("status",">",0)->count();//动态数
  79. $result['fansCount'] = (new UserLoveModel)->where("love_uid",$request->user["uid"])->count();//粉丝数
  80. $result['lookCount'] = $request->user['look_count'];;//观看量
  81. $result['hotCount'] = $result['diaryCount']+$result['fansCount']+$result['lookCount'];//热度=发布量+粉丝数+观看量
  82. //订单信息
  83. $result['waitPayCount'] = (new Order)->where("uid",$request->user["uid"])->where("status",0)->count(); //待付款
  84. $result['waitSendCount'] = (new Order)->where("uid",$request->user["uid"])->where("status",1)->count();//待发货
  85. $result['waitAcceptCount'] = (new Order)->where("uid",$request->user["uid"])->where("status",2)->count();//待收货
  86. $result['waitCommentCount'] = (new Order)->where("uid",$request->user["uid"])->where("status",3)->count();//待评价
  87. //其他信息
  88. $result['couponCount'] = (new UserCouponModel)->where("uid",$request->user["uid"])->where("status",0)->where("end_time",">",time())->count();//消费券数
  89. // $result['logistics']=array(
  90. // "img"=>"/static/image/test/test1.png",
  91. // "title"=>"最新物流进展",
  92. // "content"=>"您的订单已到达杭州转运中心,已入库",
  93. // );
  94. $orderList = (new Order)
  95. ->field("id,order_id,name,tel,address,time,pay_time,fa_time,ok_time,status")
  96. ->where("uid",$request->user["uid"])
  97. ->where("status",1)
  98. ->order("id","desc")
  99. ->limit(2)
  100. ->select()
  101. ->toArray();
  102. $orderList = empty($orderList) ? [] : $orderList;
  103. $orderInfoModel=new OrderInfo();
  104. foreach($orderList as $k=>$v){
  105. $orderList[$k]["time"] = date("Y-m-d H:i:s",$v["time"]);
  106. $orderList[$k]["pay_time"] = empty($v["pay_time"]) ? "" : date("Y-m-d H:i:s",$v["pay_time"]);
  107. $orderList[$k]["fa_time"] = empty($v["fa_time"]) ? "" : date("Y-m-d H:i:s",$v["fa_time"]);
  108. $orderList[$k]["ok_time"] = empty($v["ok_time"]) ? "" : date("Y-m-d H:i:s",$v["ok_time"]);
  109. $orderList[$k]["info"] = $orderInfoModel->field("id,p_id,img,title,is_ip_buy,price,count")->where("o_id",$v["id"])->where("uid",$request->user["uid"])->select()->toArray();
  110. }
  111. $result['orderList'] = $orderList;
  112. $result['shop_id'] = 0;
  113. $result['shop_name'] = "";
  114. $shopData = (new UserShop)->field("id,area, address,name,tel,lx_name,longitude,latitude")->where("is_show",1)->where("uid",$request->user["uid"])->find();
  115. if(!empty($shopData)){
  116. $result['shop_id'] = $shopData["id"];
  117. $result['shop_name'] = $shopData["name"];
  118. }
  119. //收益记录数
  120. $result['incomeCount'] = (new UserDetailModel)->where("uid",$request->user["uid"])->where("type",1)->count();
  121. //下级分成记录数
  122. $result['treeIncomeCount'] = (new UserDetailModel)->where("uid",$request->user["uid"])->where("type",1)->where("code","tree_per_income")->count();
  123. return app('json')->success($result);
  124. }
  125. /**
  126. * 保存个人资料
  127. * @param Request $request
  128. */
  129. public function saveInfo(Request $request)
  130. {
  131. $post = UtilService::getMore([
  132. ['nickname', '', 'empty', '昵称不存在'],
  133. ['avatar', '', 'empty', '头像不存在'],
  134. ], $request);
  135. $save['nickname'] = $post['nickname'];
  136. $save['avatar'] = $post['avatar'];
  137. (new UserModel)->where('uid', $request->user['uid'])->save($save);
  138. return app('json')->success('保存成功');
  139. }
  140. /**
  141. * 绑定手机号
  142. * @param Request $request
  143. */
  144. public function bindMobile(Request $request){
  145. [$code] = UtilService::getMore([
  146. ['code', '', 'empty', 'code参数错误'],
  147. ], $request, true);
  148. if(!empty($request->user['mobile'])){
  149. return app('json')->fail("当前账户已绑定过手机号码");
  150. }
  151. $weixinA = new weixina();
  152. $data=$weixinA->getPhoneNumber($code);//新版
  153. if(empty($data) || empty($data['purePhoneNumber'])) {
  154. return app('json')->fail("绑定失败,请重新绑定01".$weixinA->error);
  155. }
  156. $save=[
  157. "countryCode"=>empty($data['countryCode'])?"":$data['countryCode'],
  158. "mobile"=>$data['purePhoneNumber'],
  159. ];
  160. $r = (new UserModel)->where('uid', $request->user['uid'])->update($save);
  161. if(!$r){
  162. return app('json')->fail("绑定失败,请重新绑定02");
  163. }
  164. $result = [];
  165. $result['nickname'] = $request->user['nickname'];
  166. $result['avatar'] = $request->user['avatar'];
  167. $result['token'] = $request->user['token'];
  168. $result['uip'] = $request->user['uip'];
  169. $result['is_mobile'] = 1;
  170. return app('json')->success($result);
  171. }
  172. /**
  173. * 收藏商品
  174. * @param Request $request
  175. */
  176. public function loveGoods(Request $request){
  177. $post = UtilService::getMore([
  178. ['id', '', 'empty', '参数错误'],
  179. ], $request);
  180. $data = (new Goods)->where("id",$post["id"])->where("status",1)->find();
  181. if(empty($data)){
  182. return app('json')->fail("当前商品已下架");
  183. }
  184. $count = (new GoodsLove)
  185. ->where("uid",$request->user['uid'])
  186. ->where("goods_id",$data["id"])
  187. ->count();
  188. $r=0;
  189. $msg=$count > 0 ? "取消喜欢" : "喜欢";
  190. if($count>0){
  191. //取消喜欢
  192. $r=(new GoodsLove)->where("uid",$request->user['uid'])->where("goods_id",$data["id"])->delete();
  193. }else{
  194. //点赞
  195. $r=(new GoodsLove)->insert(array("uid"=>$request->user['uid'],"goods_id"=>$data["id"]));
  196. }
  197. if(empty($r)){
  198. return app('json')->fail("{$msg}失败");
  199. }
  200. return app('json')->success("{$msg}成功");
  201. }
  202. /**
  203. * 点赞圈子
  204. * @param Request $request
  205. */
  206. public function loveCircle(Request $request){
  207. $post = UtilService::getMore([
  208. ['id', '', 'empty', '参数错误'],
  209. ], $request);
  210. $data = (new UserCircle)->where("id",$post["id"])->where("status",1)->find();
  211. if(empty($data) || $data["uid"] == $request->user['uid']){
  212. return app('json')->fail("当前动态不能点赞");
  213. }
  214. $count = (new UserCircleLove)
  215. ->where("uid",$request->user['uid'])
  216. ->where("circle_id",$data["id"])
  217. ->count();
  218. $r=0;
  219. $msg=$count > 0 ? "取消点赞" : "点赞";
  220. if($count>0){
  221. //取消点赞
  222. $r=(new UserCircleLove)->where("uid",$request->user['uid'])->where("circle_id",$data["id"])->delete();
  223. }else{
  224. //点赞
  225. $r=(new UserCircleLove)->insert(array("uid"=>$request->user['uid'],"circle_id"=>$data["id"]));
  226. }
  227. if(empty($r)){
  228. return app('json')->fail("{$msg}失败");
  229. }
  230. $love_count = (new UserCircleLove)->where("circle_id",$data["id"])->count();
  231. (new UserCircle)->where('id', $data["id"])->update(["love_count"=>$love_count]);
  232. return app('json')->success("{$msg}成功");
  233. }
  234. /**
  235. * 添加关注
  236. * @param Request $request
  237. */
  238. public function loveUser(Request $request){
  239. $post = UtilService::getMore([
  240. ['uip', '', 'empty', '用户不存在'],
  241. ], $request);
  242. $data = (new UserModel())->where("uip",$post["uip"])->find();
  243. if(empty($data) || $data["uip"] == $request->user['uip']){
  244. return app('json')->fail("用户不存在");
  245. }
  246. $count = (new UserLoveModel())
  247. ->where("uid",$request->user['uid'])
  248. ->where("love_uid",$data["uid"])
  249. ->count();
  250. $r=0;
  251. $msg=$count > 0 ? "取消关注" : "关注";
  252. if($count>0){
  253. //取消关注
  254. $r=(new UserLoveModel())->where("uid",$request->user['uid'])->where("love_uid",$data["uid"])->delete();
  255. }else{
  256. //关注
  257. $r=(new UserLoveModel())->insert(array("uid"=>$request->user['uid'],"love_uid"=>$data["uid"],"time"=>time()));
  258. }
  259. if(empty($r)){
  260. return app('json')->fail("{$msg}失败");
  261. }
  262. return app('json')->success("{$msg}成功");
  263. }
  264. /**
  265. * 获取用户绑定
  266. * @param Request $request
  267. */
  268. public function bankInfo(Request $request){
  269. $data = [
  270. "bank_type"=>$request->user["bank_type"],
  271. "bank_num"=>$request->user["bank_num"],
  272. "bank_name"=>$request->user["bank_name"],
  273. "bank_ad"=>$request->user["bank_ad"],
  274. ];
  275. return app('json')->success($data);
  276. }
  277. /**
  278. * 获取提现信息
  279. * @param Request $request
  280. */
  281. public function tixianInfo(Request $request){
  282. $sysData = (new SysModel)->where("id",1)->find();
  283. $data = [
  284. "bank_type"=>$request->user["bank_type"],
  285. "bank_num"=>$request->user["bank_num"],
  286. "bank_name"=>$request->user["bank_name"],
  287. "bank_ad"=>$request->user["bank_ad"],
  288. "money"=>$request->user["money"],
  289. "tx_limit_money"=>$sysData["tx_limit_money"]
  290. ];
  291. return app('json')->success($data);
  292. }
  293. /**
  294. * 获取提现类型
  295. * @param Request $request
  296. * @return type
  297. */
  298. public function getBankType(Request $request){
  299. $data=(new BankModel)
  300. ->where("status",1)
  301. ->order("seq","desc")
  302. ->order("id","desc")
  303. ->select()
  304. ->toArray();
  305. $data = empty($data)?[]:$data;
  306. return app('json')->success($data);
  307. }
  308. /**
  309. * 编辑绑定
  310. * @param Request $request
  311. * @return type
  312. */
  313. public function editBank(Request $request){
  314. [$bank_type,$bank_name, $bank_num,$bank_ad] = UtilService::getMore([
  315. ['bank_type', '', 'empty', '请选择提现方式'],
  316. ['bank_name', '', 'empty', '请输入真实姓名'],
  317. ['bank_num', '', 'empty', '请输入账号'],
  318. ['bank_ad', ''],
  319. ], $request, true);
  320. if($bank_type!="alipay" && empty($bank_ad)){
  321. return app('json')->fail("请输入开户行");
  322. }
  323. if($bank_type=="alipay"){
  324. $bank_ad = "支付宝";
  325. }
  326. $typeCount=(new BankModel)->where("code",$bank_type)->count();
  327. if($typeCount<=0){
  328. return app('json')->fail("请选择正确的提现方式");
  329. }
  330. $save=[
  331. "bank_type"=>$bank_type,
  332. "bank_name"=>$bank_name,
  333. "bank_num"=>$bank_num,
  334. "bank_ad"=>$bank_ad,
  335. ];
  336. (new UserModel)->where("uid",$request->user['uid'])->update($save);
  337. return app('json')->success("绑定成功");
  338. }
  339. /**
  340. * 提现申请
  341. * @param Request $request
  342. */
  343. public function tixianApply(Request $request){
  344. [$money] = UtilService::getMore([
  345. ['money', 0, 'is_numeric', '请输入正确的提现金额'],
  346. ], $request, true);
  347. //缓存
  348. $redis = \think\facade\Cache::store('redis');
  349. $key = 'user_tixian_' . $request->user['uid'];
  350. $bool = $redis->handler()->exists($key);
  351. if ($bool) {
  352. return app('json')->fail('您的操作过于频繁,请稍等再重试!');
  353. }
  354. $redis->set($key,1,10);//30秒缓存
  355. $user = $request->user;
  356. if(empty($user["openid"])){
  357. return app('json')->fail('您还未绑定微信');
  358. }
  359. if(floatval($money)<=0){
  360. return app('json')->fail('请输入正确的提现金额');
  361. }
  362. if(floatval($money)>$user["money"]){
  363. return app('json')->fail('您的余额不足,无法提现');
  364. }
  365. if(empty($user["bank_type"]) || empty($user["bank_num"]) || empty($user["bank_name"])){
  366. return app('json')->fail('您还未绑定提现账户');
  367. }
  368. if($user["bank_type"]!="alipay" && empty($user["bank_ad"])){
  369. return app('json')->fail('您还未绑定提现开户行');
  370. }
  371. $sysData = (new SysModel)->where("id",1)->find();
  372. if(floatval($user["money"])<floatval($sysData["tx_limit_money"]) || floatval($money)<floatval($sysData["tx_limit_money"])){
  373. return app('json')->fail("满{$sysData['tx_limit_money']}元,才可提现");
  374. }
  375. //提现手续费
  376. $hand_money = $sysData["tx_process_per"] > 0 ? floatval($money) * $sysData["tx_process_per"] / 100 : 0;
  377. $hand_money = num_min_format($hand_money);
  378. $save=[];
  379. $save["uid"] = $user["uid"];
  380. $save["bank_type"] = $user["bank_type"];
  381. $save["bank_num"] = $user["bank_num"];
  382. $save["bank_name"] = $user["bank_name"];
  383. $save["bank_ad"] = $user["bank_ad"];
  384. $save["money"] = floatval($money);
  385. $save["hand_money"] = ($sysData["tx_process_max"] > 0 && $hand_money > $sysData["tx_process_max"]) ? $sysData["tx_process_max"] : $hand_money;
  386. $save["tx_money"] = $save["money"] - $save["hand_money"];
  387. $save["status"] = 0;
  388. $save["time"] = time();
  389. try{
  390. Db::startTrans();
  391. //插入提现申请
  392. $tx_id = (new TxModel)->insertGetId($save);
  393. if(empty($tx_id)){
  394. return app('json')->fail('提交失败');
  395. }
  396. //更新提现账户余额并添加明细
  397. $r= (new UserDetailModel)->txApplyMoney($user["uid"],floatval($money),$tx_id);
  398. if(!$r){
  399. (new TxModel)->where("id",$tx_id)->delete();
  400. return app('json')->fail('提交失败');
  401. }
  402. Db::commit();
  403. $redis->delete($key);
  404. return app('json')->success('提交成功,等待客服处理');
  405. } catch (DbException $db){
  406. Db::rollback();
  407. return app('json')->fail("订单生成失败");
  408. }
  409. }
  410. /**
  411. * 关注列表
  412. * @param Request $request
  413. */
  414. public function loveList(Request $request)
  415. {
  416. $pageSize = 20;
  417. [$page] = UtilService::getMore([
  418. ['page', 1],
  419. ], $request, true);
  420. $data = (new UserLoveModel)
  421. ->field("u.id,u2.uip,u2.nickname,u2.avatar")
  422. ->alias("u")
  423. ->join("user u2", "u2.uid = u.love_uid")
  424. ->where("u.uid", $request->user['uid'])
  425. ->order("id", "desc")
  426. ->page((int)$page, $pageSize)
  427. ->select();
  428. $loveCount = (new UserLoveModel)->alias("u")->where("u.uid", $request->user['uid'])->count();
  429. $tAr = UtilService::getParam([
  430. 'id','uip', 'nickname', 'avatar'
  431. ], $data);
  432. return app('json')->success(['list' => $tAr, 'pageSize' => $pageSize,'loveCount'=>$loveCount]);
  433. }
  434. /**
  435. * 我的粉丝
  436. * @param Request $request
  437. */
  438. public function fansList(Request $request)
  439. {
  440. $pageSize = 20;
  441. [$page] = UtilService::getMore([
  442. ['page', 1],
  443. ], $request, true);
  444. $data = (new UserLoveModel)
  445. ->field("u.id,u2.uip,u2.nickname,u2.avatar")
  446. ->alias("u")
  447. ->join("user u2", "u2.uid = u.uid")
  448. ->where("u.love_uid", $request->user['uid'])
  449. ->order("id", "desc")
  450. ->page((int)$page, $pageSize)
  451. ->select();
  452. $fansCount = (new UserLoveModel)->alias("u")->where("u.love_uid", $request->user['uid'])->count();
  453. $tAr = UtilService::getParam([
  454. 'id', 'uip', 'nickname', 'avatar'
  455. ], $data);
  456. return app('json')->success(['list' => $tAr, 'pageSize' => $pageSize,'fansCount'=>$fansCount]);
  457. }
  458. /**
  459. * 获取门店信息
  460. * @param Request $request
  461. * @return type
  462. */
  463. public function userShopInfo(Request $request){
  464. $shopData = (new UserShop)->field("id,area, address,name,tel,lx_name,longitude,latitude")->where("is_show",1)->where("uid",$request->user["uid"])->find();
  465. if(empty($shopData)){
  466. return app('json')->fail("您还没有绑定店铺");
  467. }
  468. return app('json')->success($shopData->toArray());
  469. }
  470. /**
  471. * 获取门店列表
  472. * @param Request $request
  473. */
  474. public function getShopList(Request $request){
  475. [$longitude,$latitude] = UtilService::getMore([
  476. ['longitude', ""],
  477. ['latitude', ""],
  478. ], $request, true);
  479. //经纬度排序
  480. $lbsOrder="id desc";
  481. if(!empty($longitude) && !empty($latitude)){
  482. $lng = $longitude;
  483. $lat = $latitude;
  484. $lbsOrder = 'ACOS(SIN(('.$lat.' * 3.1415) / 180 ) *SIN((latitude * 3.1415) / 180 ) +COS(('.$lat.' * 3.1415) / 180 ) * COS((latitude * 3.1415) / 180 ) *COS(('.$lng.' * 3.1415) / 180 - (longitude * 3.1415) / 180 ) ) * 6380';
  485. }
  486. $data = (new UserShop)
  487. ->field("id,area, address,name,tel,lx_name,longitude,latitude")
  488. ->where("is_show",1)
  489. ->orderRaw($lbsOrder)
  490. ->select();
  491. $data = empty($data)?[]:$data->toArray();
  492. return app('json')->success(['list' =>$data, 'pageSize' => 100]);
  493. }
  494. /**
  495. * 我的地址列表
  496. * @param Request $request
  497. */
  498. public function addressList(Request $request){
  499. $pageSize = 20;
  500. [$page] = UtilService::getMore([
  501. ['page', 1],
  502. ], $request, true);
  503. $data = (new UserAddress)
  504. ->where("uid", $request->user['uid'])
  505. ->order("time", "desc")
  506. ->page((int)$page, $pageSize)
  507. ->select();
  508. $tAr = UtilService::getParam([
  509. 'id','area', 'address', 'name', 'tel', 'defalut'
  510. ], $data);
  511. return app('json')->success(['list' => $tAr, 'pageSize' => $pageSize]);
  512. }
  513. /**
  514. * 删除地址
  515. * @param Request $request
  516. */
  517. public function addressDel(Request $request){
  518. $post = UtilService::getMore([
  519. ['id','','empty','参数错误'],
  520. ],$request);
  521. $r = (new UserAddress)->where("id",$post["id"])->where("uid",$request->user["uid"])->delete();
  522. if($r){
  523. return app('json')->success("删除成功");
  524. }else{
  525. return app('json')->fail("删除失败");
  526. }
  527. }
  528. /**
  529. * 获取用户券列表
  530. * @param Request $request
  531. */
  532. public function couponList(Request $request){
  533. $pageSize = 20;
  534. [$page,$type] = UtilService::getMore([
  535. ['page', 1],
  536. ['type',''],
  537. ], $request, true);
  538. //清除失效的券
  539. (new UserCouponModel)->where("uid", $request->user['uid'])->where("status",0)->where("end_time","<",time())->update(["status"=>-1]);
  540. //条件
  541. $where=[];
  542. $where[] = ["uid","=",$request->user['uid']];
  543. //未使用
  544. if($type=="using"){
  545. $where[] = ["status","=",0];
  546. }
  547. //已经使用
  548. if($type=="used"){
  549. $where[] = ["status","=",1];
  550. }
  551. //已过期
  552. if($type=="nouser"){
  553. $where[] = ["status","=",-1];
  554. }
  555. $data = (new UserCouponModel)
  556. ->where($where)
  557. ->order("time", "desc")
  558. ->page((int)$page, $pageSize)
  559. ->select()
  560. ->toArray();
  561. foreach($data as $k=>$v){
  562. $data[$k]["start_time"] = date("Y.m.d",$v["start_time"]);
  563. $data[$k]["end_time"] = date("Y.m.d",$v["end_time"]);
  564. }
  565. $data = empty($data)?[]:$data;
  566. return app('json')->success(['list' => $data, 'pageSize' => $pageSize]);
  567. }
  568. /**
  569. * 用户领券
  570. * @param Request $request
  571. */
  572. public function gainCoupon(Request $request){
  573. $post = UtilService::getMore([
  574. ['coupon_id','','empty','参数错误'],
  575. ],$request);
  576. $data = (new CouponModel)->where("id",$post["coupon_id"])->where("status",1)->find();
  577. if(empty($data)){
  578. return app('json')->fail("当前优惠券不支持领取");
  579. }
  580. $userCouponData = (new UserCouponModel)->where("coupon_id",$post["coupon_id"])->where("uid",$request->user["uid"])->find();
  581. if(!empty($userCouponData)){
  582. return app('json')->fail("您已经领取过该优惠券了");
  583. }
  584. $ntime = time();
  585. $save=[
  586. "uid"=>$request->user["uid"],
  587. "coupon_id"=>$data["id"],
  588. "title"=>$data["title"],
  589. "price"=>$data["price"],
  590. "limit_price"=>$data["limit_price"],
  591. "day"=>$data["day"],
  592. "status"=>0,
  593. "time"=>$ntime,
  594. "start_time"=>strtotime(date("Y-m-d",$ntime)),
  595. "end_time"=>$ntime+$data["day"]*24*60*60,
  596. ];
  597. $r = (new UserCouponModel)->insert($save);
  598. if($r){
  599. return app('json')->success("领取成功");
  600. }else{
  601. return app('json')->fail("领取失败");
  602. }
  603. }
  604. /**
  605. * 添加编辑地址
  606. * @param Request $request
  607. */
  608. public function addressAdd(Request $request){
  609. $post = UtilService::getMore([
  610. ['id',''],
  611. ['area','','empty','请选择省市区'],
  612. ['address','','empty','请填写详细地址'],
  613. ['name','','empty','请填写姓名'],
  614. ['tel','','empty','请填写电话'],
  615. ],$request);
  616. $post["time"] = time();
  617. $id = $post["id"];
  618. unset($post["id"]);
  619. $r=0;
  620. if(empty($id) || $id=="0"){
  621. $post["uid"]=$request->user["uid"];
  622. $r = (new UserAddress)->insert($post);
  623. }else{
  624. $r = (new UserAddress)->where("id",$id)->update($post);
  625. }
  626. if($r){
  627. return app('json')->success("数据保存成功");
  628. }else{
  629. return app('json')->fail("数据保存失败");
  630. }
  631. }
  632. /**
  633. * 获取用户二维码
  634. * @param Request $request
  635. */
  636. public function getUipErcode(Request $request){
  637. $sysData = (new SysModel)->where("id",1)->find();
  638. //二维码生成器
  639. $QRcodeComm = new QRcodeComm();
  640. $url=$sysData['system_url']."/pushurl/".$request->user['uip'];
  641. $urlPath = $QRcodeComm->getPngErcode($url);
  642. $savePath = $sysData['system_url'] . $urlPath;
  643. if(!empty($request->user["ercode"])){
  644. $rootPath = app()->getRootPath()."/public/resource".explode("resource",$request->user["ercode"])[1];
  645. if(file_exists($rootPath)){
  646. unlink($rootPath);
  647. }
  648. }
  649. (new UserModel)->where("uid",$request->user["uid"])->update(array("ercode"=>$savePath));
  650. return app('json')->success(['url' => $savePath]);
  651. }
  652. /**
  653. * 获取下单初始信息
  654. * @param Request $request
  655. */
  656. public function getProBuyInfo(Request $request){
  657. [$p_id,$is_ip_buy,$longitude,$latitude] = UtilService::getMore([
  658. ['p_id','','empty','商品参数错误'],
  659. ['is_ip_buy','0'],
  660. ['longitude',''],
  661. ['latitude',''],
  662. ],$request,true);
  663. $is_ip_buy = (int)$is_ip_buy==0?0:1;
  664. $proData = (new Goods)->where("id",(int)$p_id)->where("status",1)->find();
  665. if(empty($proData)){
  666. return app('json')->fail("当前商品已下架");
  667. }
  668. $proData=$proData->toArray();
  669. if($proData["limit"]<=0){
  670. return app('json')->fail("当前商品限购不可购买");
  671. }
  672. if($is_ip_buy==1 && ($proData["is_ip"]==0 || !empty($proData["uid"]))){
  673. return app('json')->fail("当前商品不可买断");
  674. }
  675. $price = floatval($proData["price"]);
  676. if($is_ip_buy==1){
  677. $price = floatval($proData["ip_price"]);
  678. }
  679. $img = explode(",", $proData["imgs"])[0];
  680. $data=[
  681. "score"=> $is_ip_buy == 1 ? 0 : $request->user["score"],
  682. "use_score"=>0,
  683. "is_score"=>1,
  684. "proMoney"=>0,
  685. "allMoney"=>0,
  686. "couponMoney"=>0,
  687. "coupon"=>[
  688. "id"=>"",
  689. "limit"=>0,//满多少可用
  690. "price"=>0,//金额
  691. ],
  692. "mono"=>"",
  693. "address"=>[
  694. "id"=>"",
  695. "address"=>"",
  696. "name"=>"",
  697. "tel"=>"",
  698. ],
  699. "shop"=>[
  700. "id"=>"",
  701. "address"=>"",
  702. "name"=>"",
  703. "tel"=>"",
  704. ],
  705. "pro"=>[],
  706. ];
  707. //商品信息
  708. $data["pro"][]=[
  709. "id"=>$proData["id"],
  710. "img"=>$img,
  711. "count"=>1,
  712. "status"=>$proData["status"],
  713. "title"=>$proData["title"],
  714. "price"=>$price,
  715. "ip_income_per"=>$proData["ip_income_per"],
  716. "is_ip_buy"=>$is_ip_buy,
  717. "limit"=>$is_ip_buy==1 ? 1 : $proData["limit"],
  718. "data"=>empty($proData["data"])?[]:unserialize($proData["data"])
  719. ];
  720. //默认地址信息
  721. $addressData = (new UserAddress)->where("uid", $request->user['uid'])->order("time", "desc")->find();
  722. if(!empty($addressData)){
  723. $data["address"]["id"] = $addressData["id"];
  724. $data["address"]["address"] = $addressData["area"].$addressData["address"];
  725. $data["address"]["name"] = $addressData["name"];
  726. $data["address"]["tel"] = $addressData["tel"];
  727. $data["address"]["lx_name"] = "";
  728. }
  729. //默认店铺地址经纬度排序
  730. $lbsOrder="id desc";
  731. if(!empty($longitude) && !empty($latitude)){
  732. $lng = $longitude;
  733. $lat = $latitude;
  734. $lbsOrder = 'ACOS(SIN(('.$lat.' * 3.1415) / 180 ) *SIN((latitude * 3.1415) / 180 ) +COS(('.$lat.' * 3.1415) / 180 ) * COS((latitude * 3.1415) / 180 ) *COS(('.$lng.' * 3.1415) / 180 - (longitude * 3.1415) / 180 ) ) * 6380';
  735. }
  736. $shopData = (new UserShop)->where("is_show",1)->orderRaw($lbsOrder)->find();
  737. if(!empty($shopData)){
  738. $data["shop"]["id"] = $shopData["id"];
  739. $data["shop"]["address"] = $shopData["address"];
  740. $data["shop"]["name"] = $shopData["name"];
  741. $data["shop"]["tel"] = $shopData["tel"];
  742. $data["shop"]["lx_name"] = $shopData["lx_name"];
  743. }
  744. $data["buyTypeData"]=[["id"=>0,"title"=>"商家配送","is_show"=>0,"is_default"=>0],["id"=>1,"title"=>"门店自提","is_show"=>1,"is_default"=>1]];
  745. return app('json')->success($data);
  746. }
  747. /**
  748. * 获取报名表单信息
  749. * @param Request $request
  750. */
  751. public function activityFromInfo(Request $request){
  752. $post = UtilService::getMore([
  753. ['id', '','empty','参数错误'],
  754. ], $request);
  755. $data = (new Activity)->where('is_show', 1)->where('id', $post["id"])->find();
  756. if(empty($data)){
  757. return app('json')->fail("数据获取失败");
  758. }
  759. $data = $data->toArray();
  760. $acData=[];
  761. $acData["id"] = $data["id"];
  762. $acData["img"] = empty($data["imgs"]) ? "" : explode(",",$data["imgs"])[0];
  763. $acData["title"] = $data["title"];
  764. $acData["status"] = $data["time"] > time() ? 1 : 0;
  765. $acData["time"] = date("Y.m.d",$data["time"]);
  766. $acData["deposits_price"] = floatval($data["deposits_price"]);
  767. $acData["data"] = empty($data["data"]) ? [] : unserialize($data["data"]);
  768. $acData["mono"] = "";
  769. foreach($acData["data"] as $k=>$v){
  770. $acData["data"][$k]["value"]="";
  771. if(!empty($v["parms"])){
  772. $acData["data"][$k]["index"]=0;
  773. $acData["data"][$k]["parms"] = array_merge(["选择{$v['title']}"],$v["parms"]);
  774. }
  775. }
  776. return app('json')->success($acData);
  777. }
  778. /**
  779. * 活动报名订单提交[第一步]
  780. * @param Request $request
  781. */
  782. public function subActivityOrder(Request $request){
  783. [$id,$data] = UtilService::getMore([
  784. ['id','','empty','请选择要报名的活动'],
  785. ['data','','empty','请填写报名信息'],
  786. ],$request,true);
  787. //缓存
  788. $redis = \think\facade\Cache::store('redis');
  789. $key = 'order_sub_' . $request->user['uid'];
  790. $bool = $redis->handler()->exists($key);
  791. if ($bool) {
  792. return app('json')->fail('请务重复操作,请稍等在重试!');
  793. }
  794. $redis->set($key,1,5);//5秒缓存
  795. if(empty($id) || empty($data)){
  796. return app('json')->fail('提交参数有误01');
  797. }
  798. $data = json_decode($data,true);
  799. if(!is_array($data)){
  800. return app('json')->fail('提交参数有误02');
  801. }
  802. $activityData = (new Activity)->where("id",(int)$id)->where("is_show",1)->find();
  803. if(empty($activityData)){
  804. return app('json')->fail("当前活动已下架");
  805. }
  806. $activityData=$activityData->toArray();
  807. if($activityData["time"]<=time()){
  808. return app('json')->fail("当前活动已经结束");
  809. }
  810. $price = floatval($activityData["deposits_price"]);
  811. // if($price<=0){
  812. // return app('json')->fail("活动报名费用错误");
  813. // }
  814. $img = explode(",", $activityData["imgs"])[0];
  815. $allMoney = $price;//订单商品费用
  816. $total_money = $allMoney;//订单总费用
  817. $payMoney = $total_money;//订单需支付费用
  818. $payMoney = $payMoney <= 0 ? 0 : $payMoney;
  819. $nowTime = time();
  820. //验证报名参数提交
  821. $parmData = empty($activityData["data"]) ? [] : unserialize($activityData["data"]);
  822. if(empty($parmData)){
  823. return app('json')->fail("系统参数错误");
  824. }
  825. $newData = [];
  826. foreach($parmData as $k=>$v){
  827. $itemData=[
  828. "title"=>trim($v["title"]),
  829. "value"=>"",
  830. ];
  831. $check = false;
  832. foreach($data as $dk=>$dv){
  833. if($dv["title"]==$v["title"]){
  834. //验证必填项
  835. if((int)$v["required"]==1 && empty($dv["value"])){
  836. return app('json')->fail("{$v['title']}为必填项");
  837. }
  838. //下拉框验证
  839. if(!empty($dv["value"]) && $v["type"]=="select" && !in_array($dv["value"],$v["parms"])){
  840. return app('json')->fail("{$v['title']}选项不存在");
  841. }
  842. $itemData["value"]=trim($dv["value"]);
  843. $check = true;
  844. break;
  845. }
  846. }
  847. if(!$check){
  848. return app('json')->fail("请填写{$v['title']}");
  849. }
  850. $newData[]=$itemData;
  851. }
  852. if(empty($newData)){
  853. return app('json')->fail("参数整合错误");
  854. }
  855. //主订单数据
  856. $save=[];
  857. $save['uid'] = $request->user['uid'];
  858. $save['order_id'] = makeOrderId($request->user['uid'],"A");
  859. $save['pay_type'] = 'wxpay';//目前只支持微信支付
  860. $save['total_money'] = $total_money;//订单总金额
  861. $save['all_money'] = $allMoney;//商品中金额
  862. $save['pay_money'] = $payMoney;//实际支付金额
  863. $save['balance'] = 0;//余额支付了多少(目前没有余额支付)
  864. $save['status'] = $payMoney <= 0 ? 1 : 0;
  865. $save['pay_time'] = $payMoney <= 0 ? time() : 0;
  866. $save['time'] = $nowTime;
  867. $save['activity_id'] = $activityData["id"];
  868. $save['data'] = serialize($newData);
  869. $save['activity_data']= serialize([
  870. "id"=>$activityData["id"],
  871. "img"=>$img,
  872. "title"=>$activityData["title"],
  873. "address"=>$activityData["address"],
  874. "deposits_price"=>$activityData["deposits_price"],
  875. "time_str"=>$activityData["time_str"],
  876. "time"=>date("Y-m-d H:i:s",$activityData["time"]),
  877. ]);
  878. try{
  879. Db::startTrans();
  880. $o_id = (new ActivityOrder)->insertGetId($save);
  881. if(empty($o_id)){
  882. return app('json')->fail("报名订单提交失败");
  883. }
  884. //不需要支付
  885. if($save['status']==1){
  886. Db::commit();
  887. return app("json")->success(["order_id"=>$save['order_id'],"money"=>$payMoney,"status"=>$save['status']]);
  888. }
  889. if(empty($request->user['openid'])){
  890. return app('json')->fail('用户还未绑定微信!');
  891. }
  892. //清理之前支付凭证 || 防止重复购买
  893. $payTrade = (new PayTradeModel)
  894. ->where("uid",$request->user["uid"])
  895. ->where("o_id",$o_id)
  896. ->where("type","activity")
  897. ->where("status",0)
  898. ->where("time","<",time() - 7*24*60*60)
  899. ->select()
  900. ->toArray();
  901. $wxpay = new wxpayApi();
  902. foreach ($payTrade as $v) {
  903. // if($v['pay_type'] == 'wxpay') {
  904. // $result = $wxpay->closeOrder($v['pay_no']);
  905. // }
  906. (new PayTradeModel)->where("id",$v['id'])->where("status",0)->delete();
  907. }
  908. $mtime = microtime(true)*10000;
  909. $payOn = "A".date("Ymd").$mtime .rand(1000,9000) . $request->user['uid'];
  910. $out_trade_no="";
  911. $payType = $save["pay_type"];
  912. //添加交易记录
  913. $trade = [
  914. 'uid' => $request->user['uid'],
  915. 'o_id' => $o_id,
  916. 'order_id' =>$save["order_id"],
  917. 'pay_no' => $payOn,
  918. 'out_trade_no' => empty($out_trade_no) ? $payOn : $out_trade_no,
  919. 'pay_type' => $payType,
  920. 'money' => $payMoney,
  921. 'type' => 'activity',
  922. 'd_json' => serialize(['orderId'=>$save["order_id"],"give_score"=>0]),
  923. 'time' => time(),
  924. 'status' => 0,
  925. ];
  926. $r=(new PayTradeModel)->insert($trade);
  927. if(!$r){
  928. return app('json')->fail('支付信息获取失败!');
  929. }
  930. $clictip = get_client_ip();
  931. if(empty($clictip)){
  932. $clictip = $request->ip();
  933. }
  934. $payData = $wxpay->wxmpPay([
  935. 'description' =>"微信小程序活动报名",
  936. 'out_trade_no' => $payOn,
  937. 'total' => $payMoney,
  938. 'openid' => $request->user['openid'],
  939. 'payer_client_ip'=>$clictip,
  940. ]);
  941. if(empty($payData)){
  942. return app('json')->fail($wxpay->errorMsg);
  943. }
  944. Db::commit();
  945. $redis->delete($key);
  946. return app('json')->success([
  947. 'jsApiParameters'=> $payData,
  948. 'pay_no' => $payOn,
  949. 'order_id' => $save["order_id"],
  950. "status" => $save['status'],
  951. "money" => $payMoney,
  952. ]);
  953. } catch (DbException $db){
  954. Db::rollback();
  955. return app('json')->fail("订单生成失败");
  956. }
  957. }
  958. /**
  959. * 获取支付报名订单详情
  960. * @param Request $request
  961. */
  962. public function payActivityOrderInfo(Request $request){
  963. [$order_id] = UtilService::getMore([
  964. ['order_id','','empty','参数错误'],
  965. ],$request,true);
  966. $data = (new ActivityOrder)
  967. ->field("order_id,total_money,all_money,pay_money,status,time")
  968. ->where("order_id",$order_id)
  969. ->where("uid",$request->user["uid"])
  970. ->find();
  971. if(empty($data)){
  972. return app('json')->fail('信息不存在!');
  973. }
  974. $data=$data->toArray();
  975. if($data["status"]==0 && $data["time"]<time() - 30*60){
  976. (new ActivityOrder)->where("id",$data["id"])->where("uid",$request->user["uid"])->update(["status"=>-1]);
  977. $data["status"]==-1;
  978. }
  979. $data["time"] = date("Y-m-d H:i:s",$data["time"]);
  980. return app('json')->success($data);
  981. }
  982. /**
  983. * 提交订单[第一步]
  984. * @param Request $request
  985. */
  986. public function subOrder(Request $request){
  987. [$p_id,$address_id,$shop_id,$count,$mono,$coupon_id,$is_ip_buy,$is_score,$type] = UtilService::getMore([
  988. ['p_id','','empty','请选择要购买的商品'],
  989. ['address_id',''],
  990. ['shop_id',''],
  991. ['count','','is_numeric','请选择购买数量'],
  992. ['mono',''],
  993. ['coupon_id',''],
  994. ['is_ip_buy','0'],
  995. ['is_score','0'],
  996. ['type','send'],
  997. ],$request,true);
  998. if(!in_array($type,["shop","send"])){
  999. return app('json')->fail('参数错误!');
  1000. }
  1001. if($type=="shop"){
  1002. $address_id = "";
  1003. }else{
  1004. $shop_id = "";
  1005. }
  1006. if((int)$is_ip_buy==1){
  1007. $address_id = "";
  1008. $shop_id = "";
  1009. }
  1010. if((int)$is_ip_buy==0 && $type=="send" && empty($address_id)){
  1011. return app('json')->fail('请选择收货地址');
  1012. }
  1013. if((int)$is_ip_buy==0 && $type=="shop" && empty($shop_id)){
  1014. return app('json')->fail('请选择自提门店!');
  1015. }
  1016. if($type=="shop" && $is_ip_buy==1){
  1017. return app('json')->fail('买断不可选择门店自提!');
  1018. }
  1019. //用户缓存
  1020. $redis = \think\facade\Cache::store('redis');
  1021. $key = 'order_sub_' . $request->user['uid'];
  1022. $bool = $redis->handler()->exists($key);
  1023. if ($bool) {
  1024. return app('json')->fail('请务重复操作,请稍等在重试!');
  1025. }
  1026. $redis->set($key,1,5);//5秒缓存
  1027. $is_ip_buy = (int)$is_ip_buy == 1 ? 1 : 0;
  1028. $is_score = (int)$is_score == 1 && $is_ip_buy==0 ? 1 : 0;//普通购买才可以使用积分
  1029. $is_ip_buy = (int)$is_ip_buy == 0 ? 0 : 1;
  1030. $coupon_id = $is_ip_buy == 1 ? 0 : (int)$coupon_id;
  1031. $count = $is_ip_buy == 1 ? 1 : (int)$count;
  1032. $proData = (new Goods)->where("id",(int)$p_id)->where("status",1)->find();
  1033. if(empty($proData)){
  1034. return app('json')->fail("当前商品已下架");
  1035. }
  1036. $proData=$proData->toArray();
  1037. if($proData["limit"]<=0 || $count>$proData['limit']){
  1038. return app('json')->fail("当前商品单次限购".$proData['limit']."件");
  1039. }
  1040. if($is_ip_buy==1 && ($proData["is_ip"]==0 || !empty($proData["uid"]))){
  1041. return app('json')->fail("当前商品不可买断");
  1042. }
  1043. //IP商品缓存
  1044. if($is_ip_buy==1){
  1045. $ipkey = 'order_sub_ip_' . $p_id;
  1046. $ipbool = $redis->handler()->exists($ipkey);
  1047. if($ipbool){
  1048. return app('json')->fail('当前购买人数太多,请稍等再尝试!');
  1049. }
  1050. $redis->set($ipkey,1,5);//5秒缓存
  1051. }
  1052. $price = floatval($proData["price"]);
  1053. if($is_ip_buy==1){
  1054. $price = floatval($proData["ip_price"]);
  1055. }
  1056. if($price<=0){
  1057. if($is_ip_buy==1){
  1058. $redis->delete($ipkey);
  1059. }
  1060. return app('json')->fail("商品价格错误");
  1061. }
  1062. $img = explode(",", $proData["imgs"])[0];
  1063. //优惠券
  1064. $couponData=null;
  1065. $couponMoney=0;
  1066. if(!empty($coupon_id)){
  1067. $couponData = (new UserCouponModel)->where("id",$coupon_id)->where("uid",$request->user["uid"])->where("status",0)->where("end_time",">",time())->find();
  1068. if(empty($couponData)){
  1069. if($is_ip_buy==1){
  1070. $redis->delete($ipkey);
  1071. }
  1072. return app('json')->fail("当前优惠券不可用");
  1073. }
  1074. $couponMoney = $couponData["price"];
  1075. }
  1076. //收货地址
  1077. $addressData=null;
  1078. if(!empty($address_id)){
  1079. $addressData = (new UserAddress)->where("id",$address_id)->where("uid",$request->user["uid"])->find();
  1080. if(empty($addressData)){
  1081. return app('json')->fail("请选择收货地址02");
  1082. }
  1083. }
  1084. //门店地址
  1085. $shopData=null;
  1086. if(!empty($shop_id)){
  1087. $shopData = (new UserShop)->where("id",$shop_id)->where("is_show",1)->find();
  1088. if(empty($shopData)){
  1089. return app('json')->fail("请选择自提门店");
  1090. }
  1091. }
  1092. $nowTime = time();
  1093. //订单详情数据
  1094. $infoData=[];
  1095. $info=[];
  1096. $info["o_id"] = "";
  1097. $info["uid"] = $request->user['uid'];
  1098. $info["p_id"] = $proData["id"];
  1099. $info["title"] = $proData["title"];
  1100. $info["img"] = $img;
  1101. $info["count"] = $count;
  1102. $info["price"] = $price;
  1103. $info["money"] = $price*$count;
  1104. $info["give_score"]= $is_ip_buy == 1 ? 0 : (int)$proData["give_score"] * $count;
  1105. $info["is_ip_buy"] = $is_ip_buy;
  1106. $info["add_time"] = $nowTime;
  1107. $infoData[]=$info;
  1108. $give_score = 0;
  1109. $allMoney = 0;
  1110. $postageMoney = 0;
  1111. foreach($infoData as $k=>$v){
  1112. $allMoney+=$v["money"];
  1113. $give_score+=$v["give_score"];
  1114. }
  1115. if(!empty($couponData) && $allMoney<$couponData["limit_price"]){
  1116. if($is_ip_buy==1){
  1117. $redis->delete($ipkey);
  1118. }
  1119. return app('json')->fail("当前优惠券满{$couponData['limit_price']}可用");
  1120. }
  1121. $total_money = $allMoney + $postageMoney;
  1122. $payMoney = $total_money - $couponMoney;
  1123. $payMoney = $payMoney <= 0 ? 0 : $payMoney;
  1124. //使用积分1:1元
  1125. $score=0;
  1126. if($payMoney>0 && $request->user["score"]>0 && $is_score==1){
  1127. $score = $request->user["score"] > $payMoney ? (int)$payMoney : (int)$request->user["score"];
  1128. }
  1129. $payMoney = $payMoney - $score;
  1130. //目前先不能支付0元
  1131. // if($payMoney<=0){
  1132. // return app('json')->fail("订单金额错误");
  1133. // }
  1134. //主订单数据
  1135. $save=[];
  1136. $save['uid'] = $request->user['uid'];
  1137. $save['order_id'] = makeOrderId($request->user['uid']);
  1138. $save['pay_type'] = 'wxpay';//目前只支持微信支付
  1139. $save['total_money'] = $total_money;//订单总金额
  1140. $save['all_money'] = $allMoney;//商品中金额
  1141. $save['pay_money'] = $payMoney;//实际支付金额
  1142. $save['balance'] = 0;//余额支付了多少(目前没有余额支付)
  1143. $save['postage'] = $postageMoney;//邮费(目前不需要)
  1144. $save['name'] = empty($addressData) ? "" : $addressData["name"];
  1145. $save['tel'] = empty($addressData) ? "" : $addressData["tel"];
  1146. $save['address'] = empty($addressData) ? "" : $addressData["area"].$addressData["address"];
  1147. $save['shop_id'] = empty($shopData) ? 0 : $shopData["id"];
  1148. $save['type'] = $type;
  1149. $save['coupon_id'] = $coupon_id;
  1150. $save['coupon_money'] = $couponMoney;
  1151. $save['is_ip_buy'] = $is_ip_buy;
  1152. $save['status'] = $payMoney <= 0 ? 1 : 0;
  1153. $save['pay_time'] = $payMoney <= 0 ? time() : 0;
  1154. $save['score'] = $score;//使用积分
  1155. $save["mono"] = $mono;//订单备注
  1156. $save['time'] = $nowTime;
  1157. $save['give_score'] = $give_score;//赠送积分
  1158. try{
  1159. Db::startTrans();
  1160. $o_id = (new Order)->insertGetId($save);
  1161. if(empty($o_id)){
  1162. if($is_ip_buy==1){
  1163. $redis->delete($ipkey);
  1164. }
  1165. return app('json')->fail("订单生成失败");
  1166. }
  1167. foreach($infoData as $k=>$v){
  1168. $infoData[$k]["o_id"] = $o_id;
  1169. }
  1170. (new OrderInfo)->insertAll($infoData);
  1171. //消费券
  1172. if(!empty($couponData)) {
  1173. (new UserCouponModel)->where("id",$couponData["id"])->update(["status"=>1]);
  1174. }
  1175. //积分
  1176. if($score>0){
  1177. $mono = "商城购买使用积分抵扣";
  1178. (new UserScoreDetailModel)->payScore($request->user["uid"],$score,"outcome_score",$mono,["o_id"=>$o_id]);
  1179. }
  1180. //如果支付为0则直接送积分
  1181. if($save['status']==1 && $give_score>0){
  1182. (new UserScoreDetailModel)->incomeScore($request->user["uid"], $give_score, "","income_score",["o_id"=>$o_id]);
  1183. }
  1184. //系统信息
  1185. $sysData = (new SysModel)->where("id",1)->find();
  1186. //普通购买
  1187. if($save['status']==1 && $payMoney>0 && $save["is_ip_buy"]==0){
  1188. //上级用户
  1189. if($request->user["parent_uid"]>0){
  1190. $parentData = (new UserModel)->where("uid",$request->user["parent_uid"])->where("status",1)->find();
  1191. //一级用户
  1192. if(!empty($parentData) && $sysData['tree_income_per']>0 && $sysData['tree_income_per']<=100){
  1193. $treepermono = "推广用户购买商品获得分成";//分成内容
  1194. $treePerMoney = $payMoney*((int)$sysData['tree_income_per']/100);//分成收益金额
  1195. if($treePerMoney>0){
  1196. // return true;//暂时关闭分成
  1197. (new UserDetailModel)->goodsIncome($request->user["parent_uid"],$treePerMoney,"tree_per_income",$treepermono,["cash_uid"=>$save["uid"],"p_id"=>$proData["id"],"o_id"=>$o_id]);
  1198. }
  1199. }
  1200. //二级用户
  1201. if(!empty($parentData) && $parentData["parent_uid"] > 0 && $sysData['tree_income_per_two']>0 && $sysData['tree_income_per_two']<=100){
  1202. $treepermonoTwo = "二级推广用户购买商品获得分成";//分成内容
  1203. $treePerMoneyTwo = $payMoney*((int)$sysData['tree_income_per_two']/100);//分成收益金额
  1204. if($treePerMoneyTwo>0){
  1205. // return true;//暂时关闭分成
  1206. (new UserDetailModel)->goodsIncome($parentData["parent_uid"],$treePerMoneyTwo,"tree_per_income",$treepermonoTwo,["cash_uid"=>$save["uid"],"p_id"=>$proData["id"],"o_id"=>$o_id]);
  1207. }
  1208. }
  1209. }
  1210. }
  1211. //如果不需要支付则直接算IP分成
  1212. if($save['status']==1 && $payMoney>0 && $save["is_ip_buy"]==0 && !empty($proData["uid"]) && $proData["is_ip"]==1){
  1213. // $sysPer=$sysData['ip_income_per'];//分成比例,后台设置
  1214. $sysPer=$proData['ip_income_per'];//如果是单个商品则用这条
  1215. if($sysPer>0 && $sysPer<=100){
  1216. $permono = "用户购买IP商品获得分成";//分成内容
  1217. $perMoney = $payMoney*((int)$sysPer/100);//分成收益金额
  1218. //增加用户收益
  1219. if($perMoney>0){
  1220. // return true;//暂时关闭分成
  1221. (new UserDetailModel)->goodsIncome($proData["uid"],$perMoney,"per_income",$permono,["cash_uid"=>$save["uid"],"p_id"=>$proData["id"],"o_id"=>$o_id]);
  1222. }
  1223. }
  1224. }
  1225. Db::commit();
  1226. $redis->delete($key);
  1227. if($is_ip_buy==1){
  1228. $redis->delete($ipkey);
  1229. }
  1230. return app("json")->success(["order_id"=>$save['order_id'],"money"=>$payMoney,"status"=>$save['status']]);
  1231. } catch (DbException $db){
  1232. Db::rollback();
  1233. if($is_ip_buy==1){
  1234. $redis->delete($ipkey);
  1235. }
  1236. return app('json')->fail("订单生成失败");
  1237. }
  1238. }
  1239. /**
  1240. * 获取支付订单详情[第二步]
  1241. * @param Request $request
  1242. */
  1243. public function payOrderInfo(Request $request){
  1244. [$order_id] = UtilService::getMore([
  1245. ['order_id','','empty','参数错误'],
  1246. ],$request,true);
  1247. $data = (new Order)
  1248. ->field("order_id,total_money,all_money,pay_money,status,time,is_ip_buy")
  1249. ->where("order_id",$order_id)
  1250. ->where("uid",$request->user["uid"])
  1251. ->find();
  1252. if(empty($data)){
  1253. return app('json')->fail('订单不存在!');
  1254. }
  1255. $data=$data->toArray();
  1256. if($data["status"]==0 && $data["time"]<time()-30*60){
  1257. (new Order)->where("id",$data["id"])->where("uid",$request->user["uid"])->update(["status"=>-1]);
  1258. $data["status"]==-1;
  1259. }
  1260. $data["time"] = date("Y-m-d H:i:s",$data["time"]);
  1261. return app('json')->success($data);
  1262. }
  1263. /**
  1264. * 生成支付[第三步]
  1265. * @param Request $request
  1266. */
  1267. public function orderPay(Request $request){
  1268. [$order_id] = UtilService::getMore([
  1269. ['order_id','','empty','参数错误'],
  1270. ],$request,true);
  1271. //缓存
  1272. $redis = \think\facade\Cache::store('redis');
  1273. $key = 'order_pay_' . $request->user['uid'];
  1274. $bool = $redis->handler()->exists($key);
  1275. if ($bool) {
  1276. return app('json')->fail('请务重复操作,请稍等在重试!');
  1277. }
  1278. $redis->set($key,1,6);//6秒缓存
  1279. $orderData = (new Order)
  1280. ->where("order_id",$order_id)
  1281. ->where("uid",$request->user["uid"])
  1282. ->find();
  1283. if(empty($orderData)){
  1284. return app('json')->fail('订单不存在!');
  1285. }
  1286. if(empty($request->user['openid'])){
  1287. return app('json')->fail('用户还未登录001!');
  1288. }
  1289. $orderData=$orderData->toArray();
  1290. if($orderData["status"]>0 || $orderData["pay_money"]<=0){
  1291. return app('json')->fail('订单已经支付了!');
  1292. }
  1293. if($orderData["status"]<0){
  1294. return app('json')->fail('当前订单不可支付!');
  1295. }
  1296. $orderInfoData = (new OrderInfo)->where("o_id",$orderData['id'])->find()->toArray();
  1297. $proData = (new Goods)->where("id",$orderInfoData["p_id"])->find();
  1298. if(empty($proData) || $proData["status"]!=1){
  1299. return app('json')->fail('订单中的商品已下架,请重新下单!');
  1300. }
  1301. //ip买断验证
  1302. if($orderData["is_ip_buy"]==1 && (!empty($proData["uip"]) || $proData["is_ip"]==0)){
  1303. return app('json')->fail('当前商品已经不可买断,请重新下单!');
  1304. }
  1305. //清理之前支付凭证 || 防止重复购买
  1306. $payTrade = (new PayTradeModel)
  1307. ->where("uid",$request->user["uid"])
  1308. ->where("o_id",$orderData["id"])
  1309. ->where("status",0)
  1310. ->select()
  1311. ->toArray();
  1312. $wxpay = new wxpayApi();
  1313. foreach ($payTrade as $v) {
  1314. if($v['pay_type'] == 'wxpay') {
  1315. $result = $wxpay->closeOrder($v['pay_no']);
  1316. }
  1317. // (new PayTradeModel)->where("pay_no",$v['pay_no'])->delete();
  1318. }
  1319. $mtime = microtime(true)*10000;
  1320. $payOn = "P".date("Ymd").$mtime .rand(1000,9000) . $request->user['uid'];
  1321. $out_trade_no="";
  1322. $payMoney = $orderData["pay_money"];
  1323. $payType=$orderData["pay_type"];
  1324. $give_score=$orderData["give_score"];//赠送积分
  1325. //添加交易记录
  1326. $trade = [
  1327. 'uid' => $request->user['uid'],
  1328. 'o_id' =>$orderData["id"],
  1329. 'order_id' =>$orderData["order_id"],
  1330. 'pay_no' => $payOn,
  1331. 'out_trade_no' => empty($out_trade_no) ? $payOn : $out_trade_no,
  1332. 'pay_type' => $payType,
  1333. 'money' => $payMoney,
  1334. 'type' => $orderData["is_ip_buy"]==1 ? 'ip' : 'pro',
  1335. 'd_json' => serialize(['orderId'=>$orderData["order_id"],"give_score"=>$give_score]),
  1336. 'time' => time(),
  1337. 'status' => 0,
  1338. ];
  1339. $r=(new PayTradeModel)->insert($trade);
  1340. if(!$r){
  1341. return app('json')->fail('获取支付信息失败!');
  1342. }
  1343. $clictip = get_client_ip();
  1344. if(empty($clictip)){
  1345. $clictip = $request->ip();
  1346. }
  1347. $data = $wxpay->wxmpPay([
  1348. 'description' =>$orderData["is_ip_buy"]==1?"微信小程序商城IP商品买断":"微信小程序商城普通商品购买",
  1349. 'out_trade_no' => $payOn,
  1350. 'total' => $payMoney,
  1351. 'openid' => $request->user['openid'],
  1352. 'payer_client_ip'=>$clictip,
  1353. ]);
  1354. if(empty($data)){
  1355. return app('json')->fail($clictip.$wxpay->errorMsg);
  1356. }
  1357. return app('json')->success([
  1358. 'jsApiParameters'=> $data,
  1359. 'pay_no' => $payOn,
  1360. 'order_id' => $orderData["order_id"],
  1361. ]);
  1362. }
  1363. /**
  1364. * 删除订单
  1365. * @param Request $request
  1366. */
  1367. public function orderDel(Request $request){
  1368. [$order_id] = UtilService::getMore([
  1369. ['order_id','','empty','参数错误'],
  1370. ],$request,true);
  1371. $data = (new Order)->where("order_id",$order_id)->where("uid",$request->user["uid"])->find();
  1372. if(empty($data)){
  1373. return app('json')->fail('订单不存在!');
  1374. }
  1375. if($data["status"]>0){
  1376. return app('json')->fail('当前订单不可删除!');
  1377. }
  1378. (new Order)->where("order_id",$order_id)->where("status","<",1)->where("uid",$request->user["uid"])->delete();
  1379. return app('json')->success("订单删除成功");
  1380. }
  1381. /**
  1382. * 清点
  1383. * @param Request $request
  1384. */
  1385. public function shopOrderSend(Request $request){
  1386. [$order_id] = UtilService::getMore([
  1387. ['order_id','','empty','参数错误'],
  1388. ],$request,true);
  1389. $shopData = (new UserShop)->field("id,area, address,name,lx_name,tel,longitude,latitude")->where("is_show",1)->where("uid",$request->user["uid"])->find();
  1390. if(empty($shopData)){
  1391. return app('json')->fail("门店信息错误");
  1392. }
  1393. $data = (new Order)->where("order_id",$order_id)->where("shop_id",$shopData["id"])->find();
  1394. if(empty($data)){
  1395. return app('json')->fail('订单不存在!');
  1396. }
  1397. if($data["status"]!=1){
  1398. return app('json')->fail('当前订单状态不可清点!');
  1399. }
  1400. (new Order)->where("order_id",$order_id)->where("status",1)->where("shop_id",$shopData["id"])->update(["status"=>2,"fa_time"=>time()]);
  1401. //插入记录
  1402. $saveData=[
  1403. "o_id"=>$data["id"],
  1404. "order_id"=>$data["order_id"],
  1405. "mono"=>"门店确定清点完毕",
  1406. "time"=>time(),
  1407. "admin_id"=>0,
  1408. "admin_name"=>"门店",
  1409. "type"=>1,
  1410. "code"=>"shop",
  1411. ];
  1412. (new OrderMono)->insert($saveData);
  1413. return app('json')->success("订单确认清点");
  1414. }
  1415. /**
  1416. * 提货
  1417. * @param Request $request
  1418. */
  1419. public function shopOrderOk(Request $request){
  1420. [$order_id] = UtilService::getMore([
  1421. ['order_id','','empty','参数错误'],
  1422. ],$request,true);
  1423. $shopData = (new UserShop)->field("id,area, address,name,lx_name,tel,longitude,latitude")->where("is_show",1)->where("uid",$request->user["uid"])->find();
  1424. if(empty($shopData)){
  1425. return app('json')->fail("门店信息错误");
  1426. }
  1427. $data = (new Order)->where("order_id",$order_id)->where("shop_id",$shopData["id"])->find();
  1428. if(empty($data)){
  1429. return app('json')->fail('订单不存在!');
  1430. }
  1431. if($data["status"]!=2){
  1432. return app('json')->fail('当前订单状态不可确认提货!');
  1433. }
  1434. (new Order)->where("order_id",$order_id)->where("status",2)->where("shop_id",$shopData["id"])->update(["status"=>3,"ok_time"=>time()]);
  1435. //插入记录
  1436. $saveData=[
  1437. "o_id"=>$data["id"],
  1438. "order_id"=>$data["order_id"],
  1439. "mono"=>"门店确定用户已经提走商品",
  1440. "time"=>time(),
  1441. "admin_id"=>0,
  1442. "admin_name"=>"门店",
  1443. "type"=>1,
  1444. "code"=>"shop",
  1445. ];
  1446. (new OrderMono)->insert($saveData);
  1447. return app('json')->success("订单确认提货完成");
  1448. }
  1449. /**
  1450. * 确认收货
  1451. * @param Request $request
  1452. */
  1453. public function orderOk(Request $request){
  1454. [$order_id] = UtilService::getMore([
  1455. ['order_id','','empty','参数错误'],
  1456. ],$request,true);
  1457. $data = (new Order)->where("order_id",$order_id)->where("uid",$request->user["uid"])->find();
  1458. if(empty($data)){
  1459. return app('json')->fail('订单不存在!');
  1460. }
  1461. if($data["status"]!=2){
  1462. return app('json')->fail('当前订单不可确认收货!');
  1463. }
  1464. (new Order)->where("order_id",$order_id)->where("status",2)->where("uid",$request->user["uid"])->update(["status"=>3,"ok_time"=>time()]);
  1465. return app('json')->success("订单确认收货完成");
  1466. }
  1467. public function bindPushUip(Request $request){
  1468. [$pushuip] = UtilService::getMore([
  1469. ['pushuip','','empty','参数错误'],
  1470. ],$request,true);
  1471. //缓存
  1472. $redis = \think\facade\Cache::store('redis');
  1473. $key = 'user_parent_bind_' . $request->user['uid'];
  1474. $bool = $redis->handler()->exists($key);
  1475. if ($bool) {
  1476. return app('json')->fail('请务重复操作,请稍等在重试!');
  1477. }
  1478. $redis->set($key,1,3);//3秒缓存
  1479. if(!empty($request->user["parent_uid"])){
  1480. return app('json')->success("绑定成功02");
  1481. }
  1482. if($request->user["uip"]==$pushuip){
  1483. return app('json')->success("绑定成功03");
  1484. }
  1485. $parentUser = (new UserModel)->where("uip",$pushuip)->find();
  1486. if(empty($parentUser)){
  1487. return app('json')->success("绑定成功04");
  1488. }
  1489. if(!empty($parentUser["parent_uid"]) && $parentUser["parent_uid"]==$request->user["uid"]){
  1490. return app('json')->success("绑定成功05");
  1491. }
  1492. $r = (new UserModel)->where("uid",$request->user["uid"])->update(["parent_uid"=>$parentUser["uid"],"parent_time"=>time()]);
  1493. if(!$r){
  1494. return app('json')->fail('绑定失败!');
  1495. }
  1496. return app('json')->success("绑定成功");
  1497. }
  1498. /**
  1499. * 我的下级列表
  1500. * @param Request $request
  1501. */
  1502. public function branchUserList(Request $request){
  1503. [$page,$pageSize] = UtilService::getMore([
  1504. ['page',1],
  1505. ['pageSize',50],
  1506. ],$request,true);
  1507. if($pageSize>50){
  1508. $pageSize = 50;
  1509. }
  1510. //条件
  1511. $where=[];
  1512. $where[] = ["parent_uid","=",$request->user['uid']];
  1513. $where[] = ["status",">",0];
  1514. $totalCount = (new UserModel)->where($where)->count();
  1515. $data = (new UserModel)
  1516. ->field("uip,nickname,avatar,mobile,status,uid")
  1517. ->where($where)
  1518. ->order("uid", "desc")
  1519. ->page((int)$page, (int)$pageSize)
  1520. ->select()
  1521. ->toArray();
  1522. $userDetailDb = new UserDetailModel();
  1523. foreach($data as $k=>$v){
  1524. $data[$k]["is_mobile"] = empty($v["mobile"])?0:1;
  1525. $data[$k]["treeIncomeCount"] = $userDetailDb->where("uid",$request->user["uid"])->where("cash_uid",$v["uid"])->where("type",1)->where("code","tree_per_income")->count();
  1526. $data[$k]["uid"] = null;
  1527. }
  1528. $data = empty($data)?[]:$data;
  1529. return app('json')->success(['list' => $data, 'pageSize' => $pageSize,'totalCount'=>$totalCount]);
  1530. }
  1531. /**
  1532. * 我的活动
  1533. * @param Request $request
  1534. */
  1535. public function activityList(Request $request){
  1536. [$page,$pageSize] = UtilService::getMore([
  1537. ['page',1],
  1538. ['pageSize',50],
  1539. ],$request,true);
  1540. if($pageSize>50){
  1541. $pageSize = 50;
  1542. }
  1543. //条件
  1544. $where=[];
  1545. $where[] = ["d.uid","=",$request->user['uid']];
  1546. $where[] = ["d.status",">",0];
  1547. $data = (new ActivityOrder)
  1548. ->alias("d")
  1549. ->field("d.id,d.order_id,d.status,d.pay_money,i.imgs,i.title,i.time,i.time_str,i.address")
  1550. ->join("activity i", "i.id = d.activity_id","left")
  1551. ->where($where)
  1552. ->order("d.id", "desc")
  1553. ->page((int)$page, (int)$pageSize)
  1554. ->select()
  1555. ->toArray();
  1556. foreach($data as $k=>$v){
  1557. $data[$k]["time"] = date("Y.m.d",(int)$v["time"]);
  1558. $data[$k]["img"] = empty($v["imgs"]) ? "" : explode(",", $v["imgs"])[0];
  1559. }
  1560. $data = empty($data)?[]:$data;
  1561. return app('json')->success(['list' => $data, 'pageSize' => $pageSize]);
  1562. }
  1563. /**
  1564. * 活动报名详情
  1565. * @param Request $request
  1566. */
  1567. public function activityOrderInfo(Request $request){
  1568. [$id,$order_id] = UtilService::getMore([
  1569. ['id',''],
  1570. ['order_id',''],
  1571. ],$request,true);
  1572. if(empty($id) && empty($order_id)){
  1573. return app('json')->fail("参数错误");
  1574. }
  1575. $where=[];
  1576. $where[]=["uid","=",$request->user["uid"]];
  1577. if(!empty($id)){
  1578. $where[]=["id","=",$id];
  1579. }else{
  1580. $where[]=["order_id","=",$order_id];
  1581. }
  1582. $orderData = (new ActivityOrder)
  1583. ->alias("d")
  1584. ->field("d.*,i.imgs,i.title,i.time as activity_time,i.time_str,i.address")
  1585. ->join("activity i", "i.id = d.activity_id","left")
  1586. ->where($where)
  1587. ->find();
  1588. if(empty($orderData)){
  1589. return app('json')->fail("报名信息不存在");
  1590. }
  1591. $data=$orderData->toArray();
  1592. if($data["status"]==0 && $data["time"]<time()-30*60){
  1593. (new ActivityOrder)->where("id",$data["id"])->where("uid",$request->user["uid"])->update(["status"=>-1]);
  1594. $data["status"]==-1;
  1595. }
  1596. $data['activity_time'] = empty($data['activity_time'])?"":date('Y-m-d H:i:s',$data['activity_time']);
  1597. $data['time'] = date('Y.m.d',$data['time']);
  1598. $data['pay_time'] = empty($data['pay_time']) ? '' : date('Y-m-d H:i:s',$data['pay_time']);
  1599. $data['ok_time'] = empty($data['ok_time']) ? '' : date('Y-m-d H:i:s',$data['ok_time']);
  1600. $data['img'] = empty($data["imgs"])?"": explode(",",$data["imgs"])[0];
  1601. $data['data'] = empty($data['data'])?[]: unserialize($data['data']);
  1602. return app('json')->success($data);
  1603. }
  1604. /**
  1605. * 获取收益明细
  1606. * @param Request $request
  1607. */
  1608. public function moneyDetail(Request $request){
  1609. [$page,$pageSize] = UtilService::getMore([
  1610. ['page',1],
  1611. ['pageSize',50],
  1612. ],$request,true);
  1613. if($pageSize>50){
  1614. $pageSize = 50;
  1615. }
  1616. //条件
  1617. $where=[];
  1618. $where[] = ["d.uid","=",$request->user['uid']];
  1619. $data = (new UserDetailModel)
  1620. ->alias("d")
  1621. ->field("d.*,i.img,i.title as pro_title")
  1622. ->join("order_info i", "i.o_id = d.o_id","left")
  1623. ->where($where)
  1624. ->order("d.id", "desc")
  1625. ->page((int)$page, (int)$pageSize)
  1626. ->select()
  1627. ->toArray();
  1628. foreach($data as $k=>$v){
  1629. $data[$k]["time"] = date("Y-m-d H:i:s",$v["time"]);
  1630. $data[$k]["into"] = number_format(floatval($v["into"]),2);
  1631. if(empty($v["pro_title"])){
  1632. $data[$k]["pro_title"] = $v["title"];
  1633. }
  1634. }
  1635. $data = empty($data)?[]:$data;
  1636. $money = number_format(floatval($request->user["money"]),2);
  1637. $money_in = number_format(floatval($request->user["money_in"]),2);
  1638. // $isCheck = false;//关闭提现按钮
  1639. $isCheck = true;
  1640. return app('json')->success(['list' => $data, 'pageSize' => $pageSize,'money'=>$money,'money_in'=>$money_in,'is_check'=>$isCheck]);
  1641. }
  1642. /**
  1643. * 获取积分明细
  1644. * @param Request $request
  1645. */
  1646. public function scoreDetail(Request $request){
  1647. [$page,$pageSize] = UtilService::getMore([
  1648. ['page',1],
  1649. ['pageSize',50],
  1650. ],$request,true);
  1651. if($pageSize>50){
  1652. $pageSize = 50;
  1653. }
  1654. //条件
  1655. $where=[];
  1656. $where[] = ["d.uid","=",$request->user['uid']];
  1657. $data = (new UserScoreDetailModel)
  1658. ->alias("d")
  1659. ->field("d.*,i.img,i.title as pro_title")
  1660. ->join("order_info i", "i.o_id = d.o_id","left")
  1661. ->where($where)
  1662. ->order("d.id", "desc")
  1663. ->page((int)$page, (int)$pageSize)
  1664. ->select()
  1665. ->toArray();
  1666. foreach($data as $k=>$v){
  1667. $data[$k]["time"] = date("Y-m-d H:i:s",$v["time"]);
  1668. }
  1669. $data = empty($data)?[]:$data;
  1670. $score = $request->user["score"];
  1671. $score_in = $request->user["score_in"];
  1672. return app('json')->success(['list' => $data, 'pageSize' => $pageSize,'score'=>$score,'score_in'=>$score_in]);
  1673. }
  1674. public function shopOrderList(Request $request){
  1675. [$page,$pageSize,$type] = UtilService::getMore([
  1676. ['page',1],
  1677. ['pageSize',20],
  1678. ['type','all'],
  1679. ],$request,true);
  1680. if($pageSize>50){
  1681. $pageSize = 50;
  1682. }
  1683. $shopData = (new UserShop)->field("id,area, address,name,tel,lx_name,longitude,latitude")->where("is_show",1)->where("uid",$request->user["uid"])->find();
  1684. if(empty($shopData)){
  1685. return app('json')->success(['list' => [], 'pageSize' => $pageSize]);
  1686. }
  1687. //条件
  1688. $where=[];
  1689. $where[] = ["shop_id","=",$shopData["id"]];
  1690. //待支付
  1691. if($type=="pay"){
  1692. $where[] = ["status","=",0];
  1693. }
  1694. //待发货
  1695. if($type=="send"){
  1696. $where[] = ["status","=",1];
  1697. }
  1698. //待收货
  1699. if($type=="accept"){
  1700. $where[] = ["status","=",2];
  1701. }
  1702. //已完成
  1703. if($type=="finish"){
  1704. $where[] = ["status","=",3];
  1705. }
  1706. $data = (new Order)
  1707. ->where($where)
  1708. ->order("time", "desc")
  1709. ->page((int)$page, (int)$pageSize)
  1710. ->select()
  1711. ->toArray();
  1712. $orderInfoModel=new OrderInfo();
  1713. foreach($data as $k=>$v){
  1714. $data[$k]["time"] = date("Y-m-d H:i:s",$v["time"]);
  1715. $data[$k]["pay_time"] = empty($v["pay_time"]) ? "" :date("Y-m-d H:i:s",$v["pay_time"]);
  1716. $data[$k]["fa_time"] = empty($v["fa_time"]) ? "" :date("Y-m-d H:i:s",$v["fa_time"]);
  1717. $data[$k]["ok_time"] = empty($v["ok_time"]) ? "" : date("Y-m-d H:i:s",$v["ok_time"]);
  1718. $data[$k]["info"] = $orderInfoModel->field("id,p_id,img,title,is_ip_buy,price,count")->where("o_id",$v["id"])->where("uid",$request->user["uid"])->select()->toArray();
  1719. }
  1720. $data = empty($data)?[]:$data;
  1721. return app('json')->success(['list' => $data, 'pageSize' => $pageSize]);
  1722. }
  1723. /**
  1724. * 订单列表
  1725. * @param Request $request
  1726. */
  1727. public function orderList(Request $request){
  1728. [$page,$pageSize,$type,$is_ip_buy] = UtilService::getMore([
  1729. ['page',1],
  1730. ['pageSize',20],
  1731. ['type','all'],
  1732. ['is_ip_buy','']
  1733. ],$request,true);
  1734. if($pageSize>50){
  1735. $pageSize = 50;
  1736. }
  1737. //条件
  1738. $where=[];
  1739. $where[] = ["uid","=",$request->user['uid']];
  1740. if(in_array((string)$is_ip_buy,["0","1"])){
  1741. $where[] = ["is_ip_buy","=",(int)$is_ip_buy];
  1742. }
  1743. //待支付
  1744. if($type=="pay"){
  1745. $where[] = ["status","=",0];
  1746. }
  1747. //待发货
  1748. if($type=="send"){
  1749. $where[] = ["status","=",1];
  1750. }
  1751. //待收货
  1752. if($type=="accept"){
  1753. $where[] = ["status","=",2];
  1754. }
  1755. //已完成
  1756. if($type=="finish"){
  1757. $where[] = ["status","=",3];
  1758. }
  1759. //失效订单
  1760. if((new Order)->where("uid",$request->user["uid"])->where("status",0)->where("time","<",time()-30*60)->count()>0){
  1761. (new Order)->where("uid",$request->user["uid"])->where("status",0)->where("time","<",time()-30*60)->update(["status"=>-1]);
  1762. }
  1763. $data = (new Order)
  1764. ->where($where)
  1765. ->order("time", "desc")
  1766. ->page((int)$page, (int)$pageSize)
  1767. ->select()
  1768. ->toArray();
  1769. $orderInfoModel=new OrderInfo();
  1770. $userDetailDb = new UserDetailModel();
  1771. foreach($data as $k=>$v){
  1772. $data[$k]["time"] = date("Y-m-d H:i:s",$v["time"]);
  1773. $data[$k]["pay_time"] = empty($v["pay_time"]) ? "" :date("Y-m-d H:i:s",$v["pay_time"]);
  1774. $data[$k]["fa_time"] = empty($v["fa_time"]) ? "" :date("Y-m-d H:i:s",$v["fa_time"]);
  1775. $data[$k]["ok_time"] = empty($v["ok_time"]) ? "" : date("Y-m-d H:i:s",$v["ok_time"]);
  1776. $data[$k]["info"] = $orderInfoModel->field("id,p_id,img,title,is_ip_buy,price,count")->where("o_id",$v["id"])->where("uid",$request->user["uid"])->select()->toArray();
  1777. $data[$k]["ipcount"] = 0;
  1778. $data[$k]["ipmoney"] = 0;
  1779. if($v["is_ip_buy"]==1){
  1780. foreach($data[$k]["info"] as $m=>$n){
  1781. $totalData = $userDetailDb->field("count(*) as count,sum(`into`) as money")->where("uid",$request->user["uid"])->where("p_id",$n["p_id"])->where("type",1)->find();
  1782. if(!empty($totalData) && !empty($totalData["count"])){
  1783. $data[$k]["ipcount"]+=(int)$totalData["count"];
  1784. $data[$k]["ipmoney"]+=(int)$totalData["money"];
  1785. }
  1786. }
  1787. }
  1788. }
  1789. $data = empty($data)?[]:$data;
  1790. return app('json')->success(['list' => $data, 'pageSize' => $pageSize]);
  1791. }
  1792. /**
  1793. * 获取订单详情
  1794. * @param Request $request
  1795. */
  1796. public function orderInfo(Request $request){
  1797. [$id,$order_id] = UtilService::getMore([
  1798. ['id',''],
  1799. ['order_id',''],
  1800. ],$request,true);
  1801. if(empty($id) && empty($order_id)){
  1802. return app('json')->fail("参数错误");
  1803. }
  1804. $where=[];
  1805. $where[]=["uid","=",$request->user["uid"]];
  1806. if(!empty($id)){
  1807. $where[]=["id","=",$id];
  1808. }else{
  1809. $where[]=["order_id","=",$order_id];
  1810. }
  1811. $orderData = (new Order)->where($where)->find();
  1812. if(empty($orderData)){
  1813. return app('json')->fail("订单不存在");
  1814. }
  1815. $data=$orderData->toArray();
  1816. $data["shop"]=[
  1817. "id"=>"",
  1818. "address"=>"",
  1819. "name"=>"",
  1820. "tel"=>""
  1821. ];
  1822. if($data["type"]=="shop"){
  1823. $shopData = (new UserShop)->where("id",$data["shop_id"])->find();
  1824. if(!empty($shopData)){
  1825. $data["shop"]["id"] = $shopData["id"];
  1826. $data["shop"]["address"] = $shopData["area"].$shopData["address"];
  1827. $data["shop"]["name"] = $shopData["name"];
  1828. $data["shop"]["tel"] = $shopData["tel"];
  1829. $data["shop"]["lx_name"] = $shopData["lx_name"];
  1830. $data["shop"]["longitude"] = $shopData["longitude"];
  1831. $data["shop"]["latitude"] = $shopData["latitude"];
  1832. }
  1833. }
  1834. if($data["status"]==0 && $data["time"]<time()-30*60){
  1835. (new Order)->where("id",$data["id"])->where("uid",$request->user["uid"])->update(["status"=>-1]);
  1836. $data["status"]==-1;
  1837. }
  1838. $data['time'] = date('Y-m-d H:i:s',$orderData['time']);
  1839. $data['pay_time'] = empty($data['pay_time']) ? '' : date('Y-m-d H:i:s',$data['pay_time']);
  1840. $data['fa_time'] = empty($data['fa_time']) ? '' : date('Y-m-d H:i:s',$data['fa_time']);
  1841. $data['ok_time'] = empty($data['ok_time']) ? '' : date('Y-m-d H:i:s',$data['ok_time']);
  1842. $data['coupon_title']="";
  1843. if(!empty($data['coupon_id'])) {
  1844. $couponData = (new UserCouponModel)->where("id",$data['coupon_id'])->find();
  1845. if(!empty($couponData)) {
  1846. $data['coupon_title'] = $couponData['title'];
  1847. }
  1848. }
  1849. // $tAr['tuiMono'] = '';
  1850. // if(!empty($tAr['isTui'])) {
  1851. // $tAr['tuiMono'] = M('orderMono')->where(['order_id'=>$order['id'],"type"=>0])->order("id desc")->getfield("mono");
  1852. // }
  1853. $info = (new OrderInfo)->where("o_id",$data["id"])->select();
  1854. $infoAr = [];
  1855. foreach ($info as $v2) {
  1856. $d2['p_id'] = $v2['p_id'];
  1857. $d2['title'] = $v2['title'];
  1858. $d2['img'] = $v2['img'];
  1859. $d2['count'] = $v2['count'];
  1860. $d2['price'] = $v2['price'];
  1861. $d2['money'] = $v2['money'];
  1862. $d2['is_ip_buy'] = $v2['is_ip_buy'];
  1863. $infoAr[] = $d2;
  1864. }
  1865. $data['info'] = $infoAr;
  1866. return app('json')->success($data);
  1867. }
  1868. /**
  1869. * 获取门店订单详情
  1870. * @param Request $request
  1871. */
  1872. public function shopOrderInfo(Request $request){
  1873. [$id,$order_id] = UtilService::getMore([
  1874. ['id',''],
  1875. ['order_id',''],
  1876. ],$request,true);
  1877. if(empty($id) && empty($order_id)){
  1878. return app('json')->fail("参数错误");
  1879. }
  1880. $shopData = (new UserShop)->field("id,area, address,name,tel,lx_name,longitude,latitude")->where("uid",$request->user["uid"])->find();
  1881. if(empty($shopData)){
  1882. return app('json')->fail("门店信息错误");
  1883. }
  1884. $where=[];
  1885. $where[]=["shop_id","=",$shopData["id"]];
  1886. if(!empty($id)){
  1887. $where[]=["id","=",$id];
  1888. }else{
  1889. $where[]=["order_id","=",$order_id];
  1890. }
  1891. $orderData = (new Order)->where($where)->find();
  1892. if(empty($orderData)){
  1893. return app('json')->fail("订单不存在");
  1894. }
  1895. $data=$orderData->toArray();
  1896. $data["shop"]=[
  1897. "id"=>"",
  1898. "address"=>"",
  1899. "name"=>"",
  1900. "tel"=>""
  1901. ];
  1902. if($data["type"]=="shop"){
  1903. $shopData = (new UserShop)->where("id",$data["shop_id"])->find();
  1904. if(!empty($shopData)){
  1905. $data["shop"]["id"] = $shopData["id"];
  1906. $data["shop"]["address"] = $shopData["area"].$shopData["address"];
  1907. $data["shop"]["name"] = $shopData["name"];
  1908. $data["shop"]["tel"] = $shopData["tel"];
  1909. $data["shop"]["lx_name"] = $shopData["lx_name"];
  1910. $data["shop"]["longitude"] = $shopData["longitude"];
  1911. $data["shop"]["latitude"] = $shopData["latitude"];
  1912. }
  1913. }
  1914. if($data["status"]==0 && $data["time"]<time()-30*60){
  1915. (new Order)->where("id",$data["id"])->where("uid",$request->user["uid"])->update(["status"=>-1]);
  1916. $data["status"]==-1;
  1917. }
  1918. $data['time'] = date('Y-m-d H:i:s',$orderData['time']);
  1919. $data['pay_time'] = empty($data['pay_time']) ? '' : date('Y-m-d H:i:s',$data['pay_time']);
  1920. $data['fa_time'] = empty($data['fa_time']) ? '' : date('Y-m-d H:i:s',$data['fa_time']);
  1921. $data['ok_time'] = empty($data['ok_time']) ? '' : date('Y-m-d H:i:s',$data['ok_time']);
  1922. $data['coupon_title']="";
  1923. if(!empty($data['coupon_id'])) {
  1924. $couponData = (new UserCouponModel)->where("id",$data['coupon_id'])->find();
  1925. if(!empty($couponData)) {
  1926. $data['coupon_title'] = $couponData['title'];
  1927. }
  1928. }
  1929. // $tAr['tuiMono'] = '';
  1930. // if(!empty($tAr['isTui'])) {
  1931. // $tAr['tuiMono'] = M('orderMono')->where(['order_id'=>$order['id'],"type"=>0])->order("id desc")->getfield("mono");
  1932. // }
  1933. $info = (new OrderInfo)->where("o_id",$data["id"])->select();
  1934. $infoAr = [];
  1935. foreach ($info as $v2) {
  1936. $d2['p_id'] = $v2['p_id'];
  1937. $d2['title'] = $v2['title'];
  1938. $d2['img'] = $v2['img'];
  1939. $d2['count'] = $v2['count'];
  1940. $d2['price'] = $v2['price'];
  1941. $d2['money'] = $v2['money'];
  1942. $d2['is_ip_buy'] = $v2['is_ip_buy'];
  1943. $infoAr[] = $d2;
  1944. }
  1945. $data['info'] = $infoAr;
  1946. return app('json')->success($data);
  1947. }
  1948. /**
  1949. * 发布圈子
  1950. * @param Request $request
  1951. */
  1952. public function upCircle(Request $request){
  1953. $post = UtilService::getMore([
  1954. ['id',''],
  1955. ['title',''],
  1956. ['content','','empty','请输入动态内容'],
  1957. ['imgs',[]],
  1958. ['video',''],
  1959. ['video_img',''],
  1960. ['video_time',0],
  1961. ['pro_id',''],
  1962. ],$request);
  1963. $post["status"]=0;
  1964. $post["imgs"] = empty($post["imgs"]) ? "" : $post["imgs"];
  1965. $post["update_time"] = time();
  1966. if(empty($post["imgs"]) && empty($post["video"])){
  1967. return app('json')->fail("请至少上传一张主图");
  1968. }
  1969. if(!empty($post["imgs"])){
  1970. $post["video"]="";
  1971. $post["video_img"]="";
  1972. $post["video_time"]=0;
  1973. }
  1974. if(!empty($post["video"])){
  1975. $post["imgs"]="";
  1976. if(empty($post["video_img"])){
  1977. return app('json')->fail("视频封面错误");
  1978. }
  1979. if(empty($post["video_time"]) || (int)$post["video_time"]<=0){
  1980. return app('json')->fail("视频时长错误");
  1981. }
  1982. }
  1983. if(!empty($post["pro_id"])){
  1984. $proData = (new Goods)->where("id",$post["pro_id"])->where("status",1)->find();
  1985. if(empty($proData)){
  1986. return app('json')->fail("当前商品不可选中");
  1987. }
  1988. }else{
  1989. $post["pro_id"]=0;
  1990. }
  1991. $id = $post["id"];
  1992. unset($post["id"]);
  1993. $r=0;
  1994. if(empty($id) || $id=="0"){
  1995. $post["time"] = time();
  1996. $post["uid"] = $request->user["uid"];
  1997. $r = (new UserCircle)->insert($post);
  1998. }else{
  1999. $r = (new UserCircle)->where("id",$id)->update($post);
  2000. }
  2001. if($r){
  2002. return app('json')->success("发布成功,等待客服审核。");
  2003. }else{
  2004. return app('json')->fail("数据保存失败");
  2005. }
  2006. }
  2007. /**
  2008. * 图片上传
  2009. * @param Request $request
  2010. * @return type
  2011. */
  2012. public function upload(Request $request){
  2013. $sysData = (new SysModel())->where("id",1)->find();
  2014. $file = $request->file('file');
  2015. $code = $request->post("code","image");
  2016. if(empty($file)) {
  2017. return app('json')->fail("未上传文件");
  2018. }
  2019. if(!in_array($code, ["video","image","circle","advert","goods","activity"])){
  2020. return app('json')->fail("上传路径错误");
  2021. }
  2022. $ext = $file->extension();
  2023. if(!in_array($ext, array("png","jpeg","gif","jpg"))){
  2024. return app('json')->fail("图片类型错误");
  2025. }
  2026. $upPath = \think\facade\Filesystem::disk('resource')->putFile( $code, $file);
  2027. if(!$upPath){
  2028. return app('json')->fail("图片上传失败01");
  2029. }
  2030. $savePath = $sysData['system_url'].'/resource/' . $upPath;
  2031. $imgUrl = str_replace("\\", "/", $savePath);
  2032. return app('json')->success(['img'=>$imgUrl]);
  2033. }
  2034. /**
  2035. * 视频上传
  2036. * @param Request $request
  2037. * @return type
  2038. */
  2039. public function uploadVideo(Request $request){
  2040. $sysData = (new SysModel())->where("id",1)->find();
  2041. $file = $request->file('file');
  2042. $code = $request->post("code","video");
  2043. if(empty($file)) {
  2044. return app('json')->fail("未上传文件");
  2045. }
  2046. if(!in_array($code, ["video"])){
  2047. return app('json')->fail("上传路径错误");
  2048. }
  2049. $ext = $file->extension();
  2050. if(!in_array($ext, array("mp4","megp4"))){
  2051. return app('json')->fail("视频类型错误");
  2052. }
  2053. $upPath = \think\facade\Filesystem::disk('resource')->putFile( $code, $file);
  2054. if(!$upPath){
  2055. return app('json')->fail("上传失败01");
  2056. }
  2057. $savePath = $sysData['system_url'].'/resource/' . $upPath;
  2058. $imgUrl = str_replace("\\", "/", $savePath);
  2059. return app('json')->success(['video'=>$imgUrl]);
  2060. }
  2061. /**
  2062. * 钻币明细
  2063. * @param Request $request
  2064. */
  2065. public function scoreList(Request $request)
  2066. {
  2067. $pageSize = 10;
  2068. [$page, $type, $monthTime]
  2069. = UtilService::getMore([
  2070. ['page', 1],
  2071. ['type',0],
  2072. ['monthTime', ''],
  2073. ], $request, true);
  2074. $data = (new UserScoreDetail)
  2075. ->where("uid", $request->user['uid'])
  2076. ->when($type!=0, function ($query) use ($type) {
  2077. if($type==1){
  2078. $query->where("type", 1);
  2079. }
  2080. if($type==-1){
  2081. $query->where("type", -1);
  2082. }
  2083. })
  2084. ->when(!empty($monthTime), function ($query) use ($monthTime) {
  2085. $query->whereMonth("time", $monthTime);
  2086. })
  2087. ->order("id", "desc")
  2088. ->page((int)$page, $pageSize)
  2089. ->select();
  2090. $tAr = UtilService::getParam([
  2091. 'id',
  2092. 'title',
  2093. 'content',
  2094. 'type',
  2095. ['into','v',function($item){
  2096. return floatval($item);
  2097. }],
  2098. ['time', 'time', 'date("Y-m-d H:i:s",$1)'],
  2099. ], $data);
  2100. return app('json')->success(['list' => $tAr, 'pageSize' => $pageSize]);
  2101. }
  2102. }