set('ccc', 3242353, 600); return 'success'; $users = Db::name('user')->where('score_account_id','<=',0)->field('id,mobile,money,score,remark')->select(); $count = 0; $ids = []; $ids1 = []; if($users){ foreach ($users as $item){ /* $moneyCount = Db::name('money_log')->where(['uid'=> $item['id']]) ->where('create_at','<=','2023-02-19 19:30:00') ->count('id'); if($moneyCount<=0){ Db::name('user')->where(['id'=> $item['id']])->update(['remark'=>$item['remark'].'|更新余额：'.$item['money'].'++0','money'=> 0]); echo '用户'.$item['id'].'处理成功
'; $ids[] = $item['id']; $count++; }else{ $ids1[] = $item['id']; } */ /* $lastMoneyLog = Db::name('money_log')->where(['uid'=> $item['id']]) ->where('create_at','<=','2023-02-19 19:30:00') ->order('create_at','desc') ->order('id','desc') ->find(); $lastMoneyId = isset($lastMoneyLog['id'])? $lastMoneyLog['id']:0; $lastMoney = isset($lastMoneyLog['after_money'])? $lastMoneyLog['after_money']:0; echo '处理用户：'.$item['id'].'++'.$item['money'].'++'.$lastMoneyId.'++'.$lastMoney."
"; if($lastMoneyLog && $lastMoneyId){ Db::name('user')->where(['id'=> $item['id']])->update(['remark'=>$item['remark'].'|更新余额：'.$item['money'].'++'.$lastMoney,'account_id'=> $lastMoneyId,'money'=> $lastMoney]); echo '处理成功
'; $count++; } */ $lastScoreLog = Db::name('score_log') ->where(['uid'=> $item['id']]) ->where('create_at','<=','2023-02-19 19:30:00') ->order('create_at','desc') ->order('id','desc') ->find(); $lastScoreId = isset($lastScoreLog['id'])? $lastScoreLog['id']:0; $lastScore = isset($lastScoreLog['after_score'])? $lastScoreLog['after_score']:0; echo '处理用户：'.$item['id'].'++'.$item['score'].'++'.$lastScoreId.'++'.$lastScore."
"; if($lastScoreLog && $lastScoreId){ Db::name('user')->where(['id'=> $item['id']])->update(['remark'=>$item['remark'].'|更新积分：'.$item['score'].'++'.$lastScore,'score_account_id'=> $lastScoreId,'score'=> $lastScore]); echo '处理成功
'; $count++; } } } echo "累计处理：".$count."
"; echo "累计ID：".implode(',', $ids)."
"; echo "累计ID1：".implode(',', $ids1)."
"; return 'success'; } public function test4() { return false; $count = 0; $list = Db::name('money_log')->where(['type'=> 3]) ->where('from_id','>', 0) ->where('create_at','>','2023-02-19 21:00:00') ->select(); Db::startTrans(); foreach($list as $v){ echo "空盒退换余额记录：".$v['uid'].'+m+'.$v['money'].'+t+'.$v['type'].'++'.$v['state'].'++'.$v['from_id'].'
'; if($v['uid']){ $totalNum = Db::name('box_record') ->where(['uid'=> $v['uid'],'pay_type'=>2]) ->where('create_time','>','2023-02-19 19:30:00') ->sum('num'); $boxNum = Db::name('box_record') ->where(['uid'=> $v['uid'],'pay_type'=>2]) ->where('create_time','>','2023-02-19 19:30:00') ->sum(Db::raw('box10+box20+box30+box40')); $emptyNum = $totalNum - $boxNum; $backNum = Db::name('money_log') ->where(['type'=> 3,'uid'=> $v['uid']]) ->where('from_id','>', 0) ->where('create_at','>','2023-02-19 21:00:00') ->count('id'); echo "用户空盒统计：".$v['uid'].'++'.$totalNum.'++'.$boxNum.'++应退'.$emptyNum.'++退了'.$backNum."个
"; $getNum = max(0, $backNum - $emptyNum); /** if($getNum>0){ $info = Db::name('user')->where(['id'=> $v['uid']])->field('id,money,score,profit_money')->find(); $money = $getNum * 288; if(!Db::name('user')->where('id',$v['uid'])->dec('money', $money)->update()){ Db::rollback(); return '运行账户错误：'.$v['uid'].'++'.$money.'
'; } $data = [ 'uid'=>$v['uid'], 'type'=> 98, 'money'=> $money, 'create_at'=> sr_getcurtime(time()), 'state'=> 0, 'before_money'=> $info['money'], 'after_money'=> max(0, $info['money'] - $money), 'from_id'=> 0, 'uid2'=> 0, 'free_type'=> 0 ]; if(!Db::name('money_log')->insertGetId($data)){ Db::rollback(); return '运行流水错误：'.$v['uid'].'+'.$money."
"; } $count++; } **/ } } Db::commit(); echo '合计处理：'.$count."个"; return 'success'; } public function test3() { return false; $temps = []; $temps1 = []; $userIds = []; $lists = Db::name('user_unmoney')->where(['status'=>1]) ->where('create_time','>','2023-02-19 21:00:00') ->select(); foreach ($lists as $v){ $ids = isset($v['ids'])? $v['ids'] : ''; $ids = $ids? explode(',', $ids): []; $uid = isset($v['uid'])? $v['uid'] : 0; $mid = isset($v['id'])? $v['id'] : 0; $tempIds = []; Db::startTrans(); echo 'IDS:'.$v['ids']."
"; $profitTotal = $profitTotal1= $v['money']; /** foreach ($ids as $id){ $boxInfo = Db::name('box_handle')->where('id','=', $id)->find(); //var_dump($info); $rid = isset($boxInfo['rid'])? $boxInfo['rid'] : 0; if($rid && !isset($temps[$rid])){ //Db::name('box_handle')->where('create_time','>','2023-02-19 19:30:00')->where(['id'=> $id])->update(['is_delete'=>1]); echo "保留：".$mid.'++'.$uid.'++'.$rid.'-'.$id."
"; $temps[$rid] = $rid; $userIds[] = $uid; $tempIds[] = $id; }else{ $goodsPrice = isset($boxInfo['goods_price'])? $boxInfo['goods_price'] : 0; $sourcePrice = 288; $fee = 10; $backProfit = max(0, $goodsPrice - $fee - $sourcePrice); $profitTotal = max(0, $profitTotal - $backProfit); echo "清除：".$mid.'++'.$uid.'++'.$backProfit.'++'.$goodsPrice.'++'.$rid.'-'.$id."
"; $info = Db::name('user')->where(['id'=> $uid])->field('id,money,score,profit_money')->find(); if(!Db::name('user')->where('id',$uid)->dec('money', $sourcePrice)->update()){ Db::rollback(); return $uid.'+1+'.$rid.'++'.$id.'++'.$sourcePrice; } // return false; if($backProfit>0 && !Db::name('user')->where(['id'=> $uid])->dec('profit_money', $backProfit)->update()){ Db::rollback(); return $uid.'+2+'.$rid.'++'.$id; } $data = [ 'uid'=>$uid, 'type'=> 98, 'money'=> $sourcePrice, 'create_at'=> sr_getcurtime(time()), 'state'=> 0, 'before_money'=> $info['money'], 'after_money'=> max(0, $info['money'] - $sourcePrice), 'from_id'=> $id, 'uid2'=> 0, 'free_type'=> 0 ]; if(!Db::name('money_log')->insertGetId($data)){ Db::rollback(); return $uid.'+3+'.$rid.'++'.$id; } if($boxInfo['is_delete'] != 1 && !Db::name('box_handle')->where('create_time','>','2023-02-19 19:30:00')->where(['id'=> $id])->update(['is_delete'=>1,'update_time'=> date('Y-m-d H:i:s')])){ Db::rollback(); return $uid.'+4+'.$rid.'++'.$id; } $temps1[] = $id; } } //var_dump($tempIds); if($profitTotal>0 && $profitTotal != $profitTotal1 && $mid && $tempIds && $temps1 && !Db::name('user_unmoney')->where(['status'=>1,'id'=> $mid])->update(['money'=> $profitTotal,'ids'=> implode(',', $tempIds)])){ Db::rollback(); return $uid.'+5+'.$mid; } **/ Db::commit(); echo "处理：".$mid."++".$uid.'++'.$profitTotal.'++'.$profitTotal1.'++'.($tempIds?implode(',', $tempIds):'')."
"; } echo count($temps).'
'; echo count($temps1); return 'success'; } public function test2() { return false; $temps = []; $temps1 = []; $userIds = []; $lists = Db::name('box_handle')->where(['status'=>2,'handle_type'=>2])->where('create_time','>','2023-02-19 19:30:00')->select(); foreach ($lists as $v){ $rid = isset($v['rid'])? $v['rid'] : 0; $id = isset($v['id'])? $v['id'] : 0; $uid = isset($v['uid'])? $v['uid'] : 0; if($rid && !isset($temps[$rid])){ //Db::name('box_handle')->where('create_time','>','2023-02-19 19:30:00')->where(['id'=> $id])->update(['is_delete'=>1]); $temps[$rid] = $rid; $userIds[] = $uid; }else{ $price = $v['goods_price']; } } echo count($temps); return 'success'; } // 根据一个时间戳 返回 还有多少 小时:分钟:秒 public function getHoursMinuteSencond($time){ if ($time > 3600){ $G_time = date('G', $time); $hours_time = $G_time-8; $format = 'i:s'; return $hours_time.':'.date($format, $time); // $format = 'G:i:s'; }else{ $format = ':i:s'; } return date($format, $time); } //签名 public function diankesign($data) { ksort($data); $signStr = ""; foreach ($data as $key => $val) { $signStr .= $key . '=' . $val . '&'; } $stringSignTemp = $signStr.'key=a05fd6fc1f924b74b83dfd519ce93c28'; $signtemp = \md5($stringSignTemp); return strtoupper($signtemp); } public function test1(Request $request){ die(); $test_info = Db::name('test')->where('id', '=', 1)->lock(true)->find();//加锁查询 $test_info = Db::name('test')->where('id', '=', 1)->update(['msg'=>intval($test_info['msg'])+1]); if (!$test_info){ return '没有数据'; } return 'success'; } public function test(Request $request){ // 13=>'提现失败退回 // edit_user_money(13, 5346035, 1518); // 12=>'提现手续费退回', // edit_user_money(12, 5345035,55); // return 33; die(); Db::name('action_liangb')->insert([ 'create_time'=>sr_getcurtime(time()), 'wd_id'=>'WD534508950100529797' ]); return 22; return AESjiami('guojin789'); // // sr_log('请求进来了：'.time()); // $services = new ThirdPayServices(); // $services->payDfBack('WD534508956101575010', 0, ['status'=>8, 'asdf'=>'adsfasdf'], 234234); // // return 33; Db::startTrans(); try { $test_info = Db::name('test')->where('id', '=', 1)->lock(true)->find();//加锁查询 // Db::commit(); }catch (\Exception $e){ Db::rollback(); } sleep(20); return 33; sr_log('请求进来了：'.time()); Db::startTrans();//开启事务 $test_info = Db::name('test')->where('id', '=', 1)->lock(true)->find();//加锁查询 if (empty($test_info)) { exit('查询的数据不存在~！'); } //执行你想进行的操作 #*如修改金额 // $edit = Db::name('user')->where('id', '=', $userInfo['id'])->update(['amount' => $userInfo['amount'] + 10]); $test_info = Db::name('test')->where('id', '=', 1)->update(['msg'=>intval($test_info['msg'])+1]); if (!$test_info) { Db::rollback(); return '操作失败~！'; } Db::commit(); return '操作成功'; return 33; return strtotime('2023-02-14'.' '.'01:59:00'); return AESjiami('abcd123456'); // 结果是 TDFyZ3n/5GksjKtjhj2G1w== return AESjiami('1993345xhy'); die(); Db::name('box_record')->where('create_time', '>', '2023-02-13 10:48:17')->save([ 'status'=>1 ]); return 33; return json_encode(explode('|', env('APP.NOT_OPEN_GOODS_ID'))); return AESjiami('271234ab'); die(); return Db::name('money_log')->where('type', 7)->sum('money'); die(); Db::startTrans(); try { $service = new ThirdPayServices(); $service->payBack("20230206160818959664875", '28', 22, json_encode([])); Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 33; // { // "pay": "true", // "appId": "dianke", // "amount": "28", // "orderId": "20230206160818959664875", // "version": "1.0", // "transactionId": "2023020622001491231429909739", // "sign": "D9560AEACD28FD948D979AF098C06451" //} return $this->diankesign([ 'appId'=>'dianke', 'amount'=>'28', 'orderId'=>'20230206160818959664875', 'version'=>'1.0', 'transactionId'=>'2023020622001491231429909739', 'pay'=>'true' ]); return AESjiami('abcd123456'); return 33; Db::startTrans(); try { edit_user_money(5, 5344487, 1.5, 0, 2355); Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 33; $money = 456710.6; // return (int)$money; $money = (int)$money; return $money - $money % 100; return 33; Db::startTrans(); try { edit_user_money(2, 5344460, 30); Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } // return 22; return AESjiami('le222555'); Db::startTrans(); try { $service = new ThirdPayServices(); $service->payBack('SY20230111155456310371725659', 0.21, 15, json_encode(['11'=>'22'])); Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 33; // $services-> return ; return json_encode(getdate()); $date = sr_getcurtime(time()); return $this->GetNextMonth($date); return 22; return AESjiami('abcd123456'); Db::startTrans(); try { $service = new ThirdPayServices(); $service->payBack('SY202301102021116710191277261', 0.32, 15, json_encode(['aa'=>'bb'])); Db::commit(); }catch (\Exception $e){ Db::rollback(); sr_log($e->getMessage()); return 'opstate=0'.$e->getMessage(); } return 44; return $this->getHoursMinuteSencond(20626); // 180秒 return date('Y-m-d H:i:s', $time); $hours = $time/60/60; $minute = (int)3234/60; $second = (int)3234/60/60; return $hours.'小时'.$minute.'分'.$second.'秒'; // Queue::instance()->log('确定手动执行匹配福袋')->do('SystemHandleBox')->job(SystemMiddleOpenBox::class)->push([1]); return 33; $model = new ShopGoodsModel(); $goods_arr = $model ->where('box_type', 20) ->where('goods_type', 2) ->field('goods_id,box_type,goods_img,price,goods_name') ->page(1, 20)->select(); return json_encode($goods_arr); // Queue::instance()->log('确定手动执行匹配福袋')->do('SystemHandleBox')->job(SystemMiddleOpenBox::class)->push([1]); return 33; return AESjiami('abcd123456'); $string = '144.0048'; return floatval($string); Db::startTrans(); try { // edit_user_money(6, 5344210, 144.0000, 0, 5344456); edit_user_money(6, 5344210, 3); Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 77; return AESjiami('abcd123456'); return 33; return Db::name('box_record')->where('id', '>', '0')->sum('num'); Db::startTrans(); try { $this->updateUserBox(); Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 22; return Db::name('box_record')->where('id', '>', 0)->sum('num'); return 22; Db::name('box_record')->where('id', '>', 0)->save([ 'box20'=>0, 'box30'=>0, 'box40'=>0 ]); return 22; sr_testDb('adsf', 4); return $count = rand(0, 10); return AESjiami('abcd123456'); Db::name('box')->insert([ 'create_time'=>sr_getcurtime(time()), 'buy_most'=>1000, 'once_buy'=>20, 'qi_count'=>1, 'time_set'=>'10:00-10:30|14:00-15:30|18:00-20:00' ]); return 11; return Db::name('tz_log')->where('type', 1)->sum('score'); // $path_user = Db::name('user')->whereFindInSet('path', 5344633)->sum('tz_num'); // $tz = Db::name('user')->where('id', 5344633)->value('tz_num'); //// 大飞下面 总共 306.7 // return $path_user + $tz; $path_user = Db::name('user')->whereFindInSet('path', 5344367)->sum('tz_num'); $tz = Db::name('user')->where('id', 5344367)->value('tz_num'); return $path_user + $tz; return 11; Db::startTrans(); try { Db::commit(); }catch (\Exception $e){ Db::rollback(); } return 33; die(); incUserPerformance(5344809, 5000); return 44; die(); incUserPerformance(5344723,10000); return 33; die(); return AESjiami('111111'); $num = 3; return sr_getdianLen($num); // $num = 3.33; // return $num%1; // if ($num%1 == 0){ // return true; // } return sr_isdouble_xiaoshu('1')?11:22; $val = 45.668; // return $val*100; if (is_float($val*100)){ return '是的'; } return '不是'; die(); Db::name('pingyin_account')->where('id','>', 0)->save(['status'=>1]); return 33; return ; die(); Db::startTrans(); try { $service = new ThirdPayServices(); $service->payBack('SY202211090152516106612547818', '0.28', 15, json_encode(['aa'=>'bbb'])); Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 33; return AESjiami('111111'); return md5(AESjiami('111111')); // die(); return AESjiami('abcd123456'); die(); die(); $user = Db::name('user')->where('mobile', '15678888155')->find(); return Db::name('user')->whereFindInSet('path', $user['id'])->where('user_type', 1)->sum('performance_me'); edit_user_score(3, 5344839, 5000); return 33; return AESjiami('111111'); die(); //die(); // payBack($out_trade_no, $pay_money, $pay_type, $content) // return AESjiami('a12345678'); // die(); return Db::name('user')->whereFindInSet('path', '5344346')->where('user_type', 1)->sum('performance_me'); die(); return Db::name('user')->where('id', 'not in', [5344210,5344229])->sum('score'); die(); $res = json_decode('{"sign":"DeoimrF6Y9VvYKHdDHRdV9/d5UMQNWo79SZvTRrBPl+96mC3z69WXR3efgwfw4W7SaX35UUgZtA3UxoplpiPh0Tc7Hg332NUg0h/hRFKNHicS0lOkp/E0bK0sRJ2Q1DOG60kiziZe4aXOcomRPe8FpjCoTfexkh3OmxiCKT5bac=","ysepay_online_fastpay_response":{"code":"10000","msg":"Success","out_trade_no":"20221012221334525683423_yswk3014","trade_no":"01O221012748736903","total_amount":"1.13","trade_status":"WAIT_BUYER_PAY"}}'); if (isset($res->ysepay_online_fastpay_response->code) && intval($res->ysepay_online_fastpay_response->code) == 10000 && isset($res->ysepay_online_fastpay_response->msg) && intval($res->ysepay_online_fastpay_response->msg) == 'Success'){ $trade_no = $res->ysepay_online_fastpay_response->trade_no; // $insert = [ // 'total_fee' => $total_amount, // 'trade_type' => $trade_type, // 'body' => $body, // 'state' => 7, // 'out_trade_no' => $out_trade_no, // 'pay_way' => $pay_way, // 'remarks' => $remarks, // 'order_type' => $order_type, // 'uid' => $uid, // 'voucher_img' => $voucher_img, // 'out_trade_no1'=>'', // 'hy_token_id'=>'', // 'buyer_mobile'=>$params['mobile'], // 'trade_no'=>$trade_no // ]; // Db::name('payment')->insert($insert); return api_succ_return(['msg'=>'成功', 'data'=>['thirdpayYS'=>['trade_no'=>$trade_no]]]); }else{ if (isset($res->ysepay_online_fastpay_response->sub_msg)){ return api_error_return($res->ysepay_online_fastpay_response->sub_msg); }else{ return api_error_return('支付错误，请联系客服'); } } return api_error_return('支付错误，请联系客服1'); incUserPerformance(5344400,10000); edit_user_score(8, 5344400, 25000); Db::name('user')->where('id', 5344400)->save(['user_type'=>9, 'free_level'=>10000]); return 22; return AESjiami('abcd123456'); // edit_user_score(9, 5344638, 15000); return 33; $ser = new UserServices(); try { $ser->exchargeMoneyDone(5344371, 1, '17888779318', '15102768809'); }catch (Exception $e){ return $e->getMessage(); } return '成功'; die(); return AESjiami('yu860802'); return ceil(9.0234 * 100)/100; die(); $m_user = new UserModel(); return $m_user->xiaoquPerformance(5344240); return Db::name('money_log')->where('uid', 5344240)->whereDay('create_at', 'today')->sum('money'); die(); return Db::name('tz_log')->where('type', 1)->sum('score'); die(); edit_user_score(9, 5344371,60000); die(); return 10/3; return sprintf('%.4f', 10/3); return md5(AESjiami('111111')); die(); return AESjiami('le222555'); // sr_log('asdfasd'); // $params = ["app_version"=>"1.0","app_sources"=>"android","sys_version"=>"11","sys_model"=>"CMAAN40","udid"=>"21e51c0ca03ed8c2","timestamp"=>"1664551149519","name"=>"111","sign"=>"0B0F7E07B36281F5B8EEAED2207E0567"]; return createApiSign($request->post()); // die(); return createApiSign($request->param()); die(); // die(); //// return sysconfig() // return AESjiami('111111'); // $list = Db::name('user')->where('money', '>', 0)->select(); // foreach ($list as $key=>$val){ // Db::name('user')->where('id', $val['id'])->save(['money'=>0]); // } // return 33; // // return AESjiami('abcd123456'); // return Db::name('user_freelevellog')->where('uid', 333)->where('type', 2)->max('free_level'); // // $max_level = Db::name('user_freelevellog')->where('uid', 5344217)->where('type', 1)->max('re_level'); // return $max_level; // // $num = 23.6666666; // return sprintf("%.4f",substr(sprintf("%.5f", $num), 0, -2)); // return Db::name('score_log')->whereTime('create_at', '>', '2022-09-24 07:03:42')->sum('score'); // return md5(AESjiami('abcd123456')); try { $arr = []; $begin_time = time() - 86400*30; for ($i=0;$i<30;$i++){ $price = '1.'.random_int(1, 9).random_int(1, 9); Db::name('sys_func_log')->insert([ 'type'=>1, 'money'=>$price, 'create_at'=>sr_getcurtime($begin_time + 86400*$i) ]); } }catch (Exception $e){ return $e->getMessage(); } return json_encode(json_encode($arr)); return 33; // return md5(AESjiami('123456')); return $pass = AESjiami('le222555.'); return preg_match('/\d+/', $pass) && preg_match('/[a-zA-Z]+/', $pass)?'有':'没有'; return strlen('le222555.'); return AESjiemi('fZhV5v5NjBSybEPtUoleJg=='); die(); return AESjiami('le222555.'); die(); // return is_numeric('123456')?'纯数字':'不是'; return AESjiami('123456'); return create_invite_code(); return Db::name('payment')->whereDay('creat_at', 'yesterday')->where('state', 6)->sum('total_fee'); die(); // 老王:18746178697 7493436 //心态:13260666578 7493433 //郑跃兵:17888779318 7493466 $teamUsers =[ '7493436'=>0, '7493433'=>0, '7493466'=>0 ]; $list = Db::name('shop_order')->whereDay('created_time', 'today')->where('status', 1)->select(); foreach ($list as $key=>$val){ $path = Db::name('user')->where('id', $val['user_id'])->value('path'); foreach ($teamUsers as $k1=>&$v1){ if (strpos(strval($path), strval($k1)) !== false){ $v1 += $val['total_price']; } } } return json_encode($teamUsers); die(); // 平台所有余额总和 return Db::name('user')->where('status', 1)->where('user_type', 1)->where('id', 'not in', [7493267, 7493266])->sum('money'); die(); die(); return json_encode('{"app_id":"app_4f8d1f05-bcfd-4e9e-b093-b60c43036f2d","created_time":"1662713634","description":"\u8d2d\u4e70\u5546\u54c1","expend":{"pay_info":"https:\/\/qr.alipay.com\/bax08139bwvehcew1b3t30c8"},"id":"002112022090916535410414235160744284160","object":"payment","order_no":"HFPAY20220909165205254560022948","party_order_id":"02212209096083454601956","pay_amt":"0.19","pay_channel":"alipay","prod_mode":"true","query_url":"https:\/\/api.adapay.tech\/v1\/expire\/payments\/1\/380d6a9c3aa72e53eeb65e04ec062043","status":"succeeded"}'); return json_decode('{"app_id":"app_4f8d1f05-bcfd-4e9e-b093-b60c43036f2d","created_time":"1662713634","description":"\u8d2d\u4e70\u5546\u54c1","expend":{"pay_info":"https:\/\/qr.alipay.com\/bax08139bwvehcew1b3t30c8"},"id":"002112022090916535410414235160744284160","object":"payment","order_no":"HFPAY20220909165205254560022948","party_order_id":"02212209096083454601956","pay_amt":"0.19","pay_channel":"alipay","prod_mode":"true","query_url":"https:\/\/api.adapay.tech\/v1\/expire\/payments\/1\/380d6a9c3aa72e53eeb65e04ec062043","status":"succeeded"}', true); return api_succ_return('成功'); // return dirname(__FILE__); // include_once dirname(__FILE__). "../../../../../extend/thirdpay/AdapaySdk/init.php"; // return 33; die(); $str = '7493267,7493426,7493587,7493434,7493466'; $arr = explode(',', $str); $arr = arsort($arr); var_dump($arr); return json_encode($arr); $apikey = 'getAppBanner1'; $redis = new Redis(); // $res = '{"code":200,"msg":"查询成功","datas":[{"id":12,"city_name":"安徽","initial":"A","is_del":0,"pid":0},{"id":316,"city_name":"阿坝藏族羌族自治州","initial":"A","is_del":0,"pid":24},{"id":322,"city_name":"安顺市","initial":"A","is_del":0,"pid":25},{"id":68,"city_name":"阿拉善盟","initial":"A","is_del":0,"pid":5},{"id":71,"city_name":"鞍山市","initial":"A","is_del":0,"pid":6},{"id":350,"city_name":"阿里地区","initial":"A","is_del":0,"pid":27},{"id":359,"city_name":"安康市","initial":"A","is_del":0,"pid":28},{"id":137,"city_name":"安庆市","initial":"A","is_del":0,"pid":12},{"id":395,"city_name":"阿克苏地区","initial":"A","is_del":0,"pid":32},{"id":401,"city_name":"阿勒泰地区","initial":"A","is_del":0,"pid":32},{"id":403,"city_name":"阿拉尔市","initial":"A","is_del":0,"pid":32},{"id":197,"city_name":"安阳市","initial":"A","is_del":0,"pid":17},{"id":1,"city_name":"北京","initial":"B","is_del":0,"pid":0},{"id":267,"city_name":"北海市","initial":"B","is_del":0,"pid":21},{"id":272,"city_name":"百色市","initial":"B","is_del":0,"pid":21},{"id":33,"city_name":"北京市","initial":"B","is_del":0,"pid":1},{"id":290,"city_name":"白沙黎族自治县","initial":"B","is_del":0,"pid":22},{"id":294,"city_name":"保亭黎族苗族自治县","initial":"B","is_del":0,"pid":22},{"id":40,"city_name":"保定市","initial":"B","is_del":0,"pid":3},{"id":58,"city_name":"包头市","initial":"B","is_del":0,"pid":5},{"id":314,"city_name":"巴中市","initial":"B","is_del":0,"pid":24},{"id":64,"city_name":"巴彦淖尔市","initial":"B","is_del":0,"pid":5},{"id":323,"city_name":"毕节市","initial":"B","is_del":0,"pid":25},{"id":73,"city_name":"本溪市","initial":"B","is_del":0,"pid":6},{"id":331,"city_name":"保山市","initial":"B","is_del":0,"pid":26},{"id":88,"city_name":"白山市","initial":"B","is_del":0,"pid":7},{"id":90,"city_name":"白城市","initial":"B","is_del":0,"pid":7},{"id":353,"city_name":"宝鸡市","initial":"B","is_del":0,"pid":28},{"id":364,"city_name":"白银市","initial":"B","is_del":0,"pid":29},{"id":132,"city_name":"蚌埠市","initial":"B","is_del":0,"pid":12},{"id":393,"city_name":"博尔塔拉蒙古自治州","initial":"B","is_del":0,"pid":32},{"id":394,"city_name":"巴音郭楞蒙古自治州","initial":"B","is_del":0,"pid":32},{"id":406,"city_name":"北屯市","initial":"B","is_del":0,"pid":32},{"id":180,"city_name":"滨州市","initial":"B","is_del":0,"pid":15},{"id":260,"city_name":"潮州市","initial":"C","is_del":0,"pid":20},{"id":276,"city_name":"崇左市","initial":"C","is_del":0,"pid":21},{"id":23,"city_name":"重庆","initial":"C","is_del":0,"pid":0},{"id":288,"city_name":"澄迈县","initial":"C","is_del":0,"pid":22},{"id":291,"city_name":"昌江黎族自治县","initial":"C","is_del":0,"pid":22},{"id":42,"city_name":"承德市","initial":"C","is_del":0,"pid":3},{"id":298,"city_name":"成都市","initial":"C","is_del":0,"pid":24},{"id":43,"city_name":"沧州市","initial":"C","is_del":0,"pid":3},{"id":60,"city_name":"赤峰市","initial":"C","is_del":0,"pid":5},{"id":336,"city_name":"楚雄彝族自治州","initial":"C","is_del":0,"pid":26},{"id":81,"city_name":"朝阳市","initial":"C","is_del":0,"pid":6},{"id":83,"city_name":"长春市","initial":"C","is_del":0,"pid":7},{"id":346,"city_name":"昌都市","initial":"C","is_del":0,"pid":27},{"id":109,"city_name":"常州市","initial":"C","is_del":0,"pid":10},{"id":392,"city_name":"昌吉回族自治州","initial":"C","is_del":0,"pid":32},{"id":139,"city_name":"滁州市","initial":"C","is_del":0,"pid":12},{"id":144,"city_name":"池州市","initial":"C","is_del":0,"pid":12},{"id":185,"city_name":"长治市","initial":"C","is_del":0,"pid":16},{"id":228,"city_name":"长沙市","initial":"C","is_del":0,"pid":19},{"id":234,"city_name":"常德市","initial":"C","is_del":0,"pid":19},{"id":237,"city_name":"郴州市","initial":"C","is_del":0,"pid":19},{"id":258,"city_name":"东莞市","initial":"D","is_del":0,"pid":20},{"id":285,"city_name":"东方市","initial":"D","is_del":0,"pid":22},{"id":286,"city_name":"定安县","initial":"D","is_del":0,"pid":22},{"id":302,"city_name":"德阳市","initial":"D","is_del":0,"pid":24},{"id":312,"city_name":"达州市","initial":"D","is_del":0,"pid":24},{"id":70,"city_name":"大连市","initial":"D","is_del":0,"pid":6},{"id":74,"city_name":"丹东市","initial":"D","is_del":0,"pid":6},{"id":340,"city_name":"大理白族自治州","initial":"D","is_del":0,"pid":26},{"id":341,"city_name":"德宏傣族景颇族自治州","initial":"D","is_del":0,"pid":26},{"id":343,"city_name":"迪庆藏族自治州","initial":"D","is_del":0,"pid":26},{"id":97,"city_name":"大庆市","initial":"D","is_del":0,"pid":8},{"id":104,"city_name":"大兴安岭地区","initial":"D","is_del":0,"pid":8},{"id":371,"city_name":"定西市","initial":"D","is_del":0,"pid":29},{"id":170,"city_name":"东营市","initial":"D","is_del":0,"pid":15},{"id":178,"city_name":"德州市","initial":"D","is_del":0,"pid":15},{"id":183,"city_name":"大同市","initial":"D","is_del":0,"pid":16},{"id":62,"city_name":"鄂尔多斯市","initial":"E","is_del":0,"pid":5},{"id":216,"city_name":"鄂州市","initial":"E","is_del":0,"pid":18},{"id":223,"city_name":"恩施土家族苗族自治州","initial":"E","is_del":0,"pid":18},{"id":268,"city_name":"防城港市","initial":"F","is_del":0,"pid":21},{"id":13,"city_name":"福建","initial":"F","is_del":0,"pid":0},{"id":72,"city_name":"抚顺市","initial":"F","is_del":0,"pid":6},{"id":77,"city_name":"阜新市","initial":"F","is_del":0,"pid":6},{"id":140,"city_name":"阜阳市","initial":"F","is_del":0,"pid":12},{"id":146,"city_name":"福州市","initial":"F","is_del":0,"pid":13},{"id":164,"city_name":"抚州市","initial":"F","is_del":0,"pid":14},{"id":247,"city_name":"佛山市","initial":"F","is_del":0,"pid":20},{"id":265,"city_name":"桂林市","initial":"G","is_del":0,"pid":21},{"id":270,"city_name":"贵港市","initial":"G","is_del":0,"pid":21},{"id":20,"city_name":"广东","initial":"G","is_del":1,"pid":0},{"id":21,"city_name":"广西","initial":"G","is_del":1,"pid":0},{"id":25,"city_name":"贵州","initial":"G","is_del":1,"pid":0},{"id":29,"city_name":"甘肃","initial":"G","is_del":0,"pid":0},{"id":304,"city_name":"广元市","initial":"G","is_del":0,"pid":24},{"id":311,"city_name":"广安市","initial":"G","is_del":0,"pid":24},{"id":317,"city_name":"甘孜藏族自治州","initial":"G","is_del":0,"pid":24},{"id":319,"city_name":"贵阳市","initial":"G","is_del":0,"pid":25},{"id":374,"city_name":"甘南藏族自治州","initial":"G","is_del":0,"pid":29},{"id":380,"city_name":"果洛藏族自治州","initial":"G","is_del":0,"pid":30},{"id":386,"city_name":"固原市","initial":"G","is_del":0,"pid":31},{"id":161,"city_name":"赣州市","initial":"G","is_del":0,"pid":14},{"id":242,"city_name":"广州市","initial":"G","is_del":0,"pid":20},{"id":3,"city_name":"河北","initial":"H","is_del":0,"pid":0},{"id":8,"city_name":"黑龙江","initial":"H","is_del":0,"pid":0},{"id":17,"city_name":"河南","initial":"H","is_del":0,"pid":0},{"id":273,"city_name":"贺州市","initial":"H","is_del":0,"pid":21},{"id":18,"city_name":"湖北","initial":"H","is_del":0,"pid":0},{"id":274,"city_name":"河池市","initial":"H","is_del":0,"pid":21},{"id":19,"city_name":"湖南","initial":"H","is_del":0,"pid":0},{"id":277,"city_name":"海口市","initial":"H","is_del":0,"pid":22},{"id":22,"city_name":"海南","initial":"H","is_del":1,"pid":0},{"id":38,"city_name":"邯郸市","initial":"H","is_del":0,"pid":3},{"id":45,"city_name":"衡水市","initial":"H","is_del":0,"pid":3},{"id":57,"city_name":"呼和浩特市","initial":"H","is_del":0,"pid":5},{"id":63,"city_name":"呼伦贝尔市","initial":"H","is_del":0,"pid":5},{"id":337,"city_name":"红河哈尼族彝族自治州","initial":"H","is_del":0,"pid":26},{"id":82,"city_name":"葫芦岛市","initial":"H","is_del":0,"pid":6},{"id":92,"city_name":"哈尔滨市","initial":"H","is_del":0,"pid":8},{"id":95,"city_name":"鹤岗市","initial":"H","is_del":0,"pid":8},{"id":357,"city_name":"汉中市","initial":"H","is_del":0,"pid":28},{"id":102,"city_name":"黑河市","initial":"H","is_del":0,"pid":8},{"id":113,"city_name":"淮安市","initial":"H","is_del":0,"pid":10},{"id":119,"city_name":"杭州市","initial":"H","is_del":0,"pid":11},{"id":376,"city_name":"海东市","initial":"H","is_del":0,"pid":30},{"id":377,"city_name":"海北藏族自治州","initial":"H","is_del":0,"pid":30},{"id":378,"city_name":"黄南藏族自治州","initial":"H","is_del":0,"pid":30},{"id":123,"city_name":"湖州市","initial":"H","is_del":0,"pid":11},{"id":379,"city_name":"海南藏族自治州","initial":"H","is_del":0,"pid":30},{"id":382,"city_name":"海西蒙古族藏族自治州","initial":"H","is_del":0,"pid":30},{"id":130,"city_name":"合肥市","initial":"H","is_del":0,"pid":12},{"id":133,"city_name":"淮南市","initial":"H","is_del":0,"pid":12},{"id":135,"city_name":"淮北市","initial":"H","is_del":0,"pid":12},{"id":391,"city_name":"哈密市","initial":"H","is_del":0,"pid":32},{"id":138,"city_name":"黄山市","initial":"H","is_del":0,"pid":12},{"id":398,"city_name":"和田地区","initial":"H","is_del":0,"pid":32},{"id":411,"city_name":"胡杨河市","initial":"H","is_del":0,"pid":32},{"id":181,"city_name":"菏泽市","initial":"H","is_del":0,"pid":15},{"id":198,"city_name":"鹤壁市","initial":"H","is_del":0,"pid":17},{"id":203,"city_name":"漯河市","initial":"H","is_del":0,"pid":17},{"id":212,"city_name":"黄石市","initial":"H","is_del":0,"pid":18},{"id":220,"city_name":"黄冈市","initial":"H","is_del":0,"pid":18},{"id":231,"city_name":"衡阳市","initial":"H","is_del":0,"pid":19},{"id":239,"city_name":"怀化市","initial":"H","is_del":0,"pid":19},{"id":252,"city_name":"惠州市","initial":"H","is_del":0,"pid":20},{"id":255,"city_name":"河源市","initial":"H","is_del":0,"pid":20},{"id":261,"city_name":"揭阳市","initial":"J","is_del":0,"pid":20},{"id":7,"city_name":"吉林","initial":"J","is_del":0,"pid":0},{"id":10,"city_name":"江苏","initial":"J","is_del":0,"pid":0},{"id":14,"city_name":"江西","initial":"J","is_del":0,"pid":0},{"id":75,"city_name":"锦州市","initial":"J","is_del":0,"pid":6},{"id":84,"city_name":"吉林市","initial":"J","is_del":0,"pid":7},{"id":94,"city_name":"鸡西市","initial":"J","is_del":0,"pid":8},{"id":99,"city_name":"佳木斯市","initial":"J","is_del":0,"pid":8},{"id":362,"city_name":"嘉峪关市","initial":"J","is_del":0,"pid":29},{"id":363,"city_name":"金昌市","initial":"J","is_del":0,"pid":29},{"id":369,"city_name":"酒泉市","initial":"J","is_del":0,"pid":29},{"id":122,"city_name":"嘉兴市","initial":"J","is_del":0,"pid":11},{"id":125,"city_name":"金华市","initial":"J","is_del":0,"pid":11},{"id":156,"city_name":"景德镇市","initial":"J","is_del":0,"pid":14},{"id":158,"city_name":"九江市","initial":"J","is_del":0,"pid":14},{"id":162,"city_name":"吉安市","initial":"J","is_del":0,"pid":14},{"id":166,"city_name":"济南市","initial":"J","is_del":0,"pid":15},{"id":173,"city_name":"济宁市","initial":"J","is_del":0,"pid":15},{"id":186,"city_name":"晋城市","initial":"J","is_del":0,"pid":16},{"id":188,"city_name":"晋中市","initial":"J","is_del":0,"pid":16},{"id":200,"city_name":"焦作市","initial":"J","is_del":0,"pid":17},{"id":210,"city_name":"济源市","initial":"J","is_del":0,"pid":17},{"id":217,"city_name":"荆门市","initial":"J","is_del":0,"pid":18},{"id":219,"city_name":"荆州市","initial":"J","is_del":0,"pid":18},{"id":248,"city_name":"江门市","initial":"J","is_del":0,"pid":20},{"id":328,"city_name":"昆明市","initial":"K","is_del":0,"pid":26},{"id":389,"city_name":"克拉玛依市","initial":"K","is_del":0,"pid":32},{"id":396,"city_name":"克孜勒苏柯尔克孜自治州","initial":"K","is_del":0,"pid":32},{"id":397,"city_name":"喀什地区","initial":"K","is_del":0,"pid":32},{"id":409,"city_name":"可克达拉市","initial":"K","is_del":0,"pid":32},{"id":410,"city_name":"昆玉市","initial":"K","is_del":0,"pid":32},{"id":194,"city_name":"开封市","initial":"K","is_del":0,"pid":17},{"id":6,"city_name":"辽宁","initial":"L","is_del":0,"pid":0},{"id":264,"city_name":"柳州市","initial":"L","is_del":0,"pid":21},{"id":275,"city_name":"来宾市","initial":"L","is_del":0,"pid":21},{"id":289,"city_name":"临高县","initial":"L","is_del":0,"pid":22},{"id":292,"city_name":"乐东黎族自治县","initial":"L","is_del":0,"pid":22},{"id":293,"city_name":"陵水黎族自治县","initial":"L","is_del":0,"pid":22},{"id":44,"city_name":"廊坊市","initial":"L","is_del":0,"pid":3},{"id":307,"city_name":"乐山市","initial":"L","is_del":0,"pid":24},{"id":318,"city_name":"凉山彝族自治州","initial":"L","is_del":0,"pid":24},{"id":320,"city_name":"六盘水市","initial":"L","is_del":0,"pid":25},{"id":333,"city_name":"丽江市","initial":"L","is_del":0,"pid":26},{"id":78,"city_name":"辽阳市","initial":"L","is_del":0,"pid":6},{"id":335,"city_name":"临沧市","initial":"L","is_del":0,"pid":26},{"id":86,"city_name":"辽源市","initial":"L","is_del":0,"pid":7},{"id":344,"city_name":"拉萨市","initial":"L","is_del":0,"pid":27},{"id":347,"city_name":"林芝市","initial":"L","is_del":0,"pid":27},{"id":361,"city_name":"兰州市","initial":"L","is_del":0,"pid":29},{"id":112,"city_name":"连云港市","initial":"L","is_del":0,"pid":10},{"id":372,"city_name":"陇南市","initial":"L","is_del":0,"pid":29},{"id":373,"city_name":"临夏回族自治州","initial":"L","is_del":0,"pid":29},{"id":129,"city_name":"丽水市","initial":"L","is_del":0,"pid":11},{"id":142,"city_name":"六安市","initial":"L","is_del":0,"pid":12},{"id":153,"city_name":"龙岩市","initial":"L","is_del":0,"pid":13},{"id":177,"city_name":"临沂市","initial":"L","is_del":0,"pid":15},{"id":179,"city_name":"聊城市","initial":"L","is_del":0,"pid":15},{"id":191,"city_name":"临汾市","initial":"L","is_del":0,"pid":16},{"id":192,"city_name":"吕梁市","initial":"L","is_del":0,"pid":16},{"id":195,"city_name":"洛阳市","initial":"L","is_del":0,"pid":17},{"id":240,"city_name":"娄底市","initial":"L","is_del":0,"pid":19},{"id":303,"city_name":"绵阳市","initial":"M","is_del":0,"pid":24},{"id":309,"city_name":"眉山市","initial":"M","is_del":0,"pid":24},{"id":101,"city_name":"牡丹江市","initial":"M","is_del":0,"pid":8},{"id":134,"city_name":"马鞍山市","initial":"M","is_del":0,"pid":12},{"id":250,"city_name":"茂名市","initial":"M","is_del":0,"pid":20},{"id":253,"city_name":"梅州市","initial":"M","is_del":0,"pid":20},{"id":5,"city_name":"内蒙古","initial":"N","is_del":1,"pid":0},{"id":263,"city_name":"南宁市","initial":"N","is_del":0,"pid":21},{"id":31,"city_name":"宁夏","initial":"N","is_del":0,"pid":0},{"id":306,"city_name":"内江市","initial":"N","is_del":0,"pid":24},{"id":308,"city_name":"南充市","initial":"N","is_del":0,"pid":24},{"id":342,"city_name":"怒江傈僳族自治州","initial":"N","is_del":0,"pid":26},{"id":349,"city_name":"那曲市","initial":"N","is_del":0,"pid":27},{"id":106,"city_name":"南京市","initial":"N","is_del":0,"pid":10},{"id":111,"city_name":"南通市","initial":"N","is_del":0,"pid":10},{"id":120,"city_name":"宁波市","initial":"N","is_del":0,"pid":11},{"id":152,"city_name":"南平市","initial":"N","is_del":0,"pid":13},{"id":154,"city_name":"宁德市","initial":"N","is_del":0,"pid":13},{"id":155,"city_name":"南昌市","initial":"N","is_del":0,"pid":14},{"id":205,"city_name":"南阳市","initial":"N","is_del":0,"pid":17},{"id":300,"city_name":"攀枝花市","initial":"P","is_del":0,"pid":24},{"id":334,"city_name":"普洱市","initial":"P","is_del":0,"pid":26},{"id":79,"city_name":"盘锦市","initial":"P","is_del":0,"pid":6},{"id":368,"city_name":"平凉市","initial":"P","is_del":0,"pid":29},{"id":148,"city_name":"莆田市","initial":"P","is_del":0,"pid":13},{"id":157,"city_name":"萍乡市","initial":"P","is_del":0,"pid":14},{"id":196,"city_name":"平顶山市","initial":"P","is_del":0,"pid":17},{"id":257,"city_name":"清远市","initial":"Q","is_del":0,"pid":20},{"id":269,"city_name":"钦州市","initial":"Q","is_del":0,"pid":21},{"id":282,"city_name":"琼海市","initial":"Q","is_del":0,"pid":22},{"id":30,"city_name":"青海","initial":"Q","is_del":0,"pid":0},{"id":37,"city_name":"秦皇岛市","initial":"Q","is_del":0,"pid":3},{"id":295,"city_name":"琼中黎族苗族自治县","initial":"Q","is_del":0,"pid":22},{"id":325,"city_name":"黔西南布依族苗族自治州","initial":"Q","is_del":0,"pid":25},{"id":326,"city_name":"黔东南苗族侗族自治州","initial":"Q","is_del":0,"pid":25},{"id":327,"city_name":"黔南布依族苗族自治州","initial":"Q","is_del":0,"pid":25},{"id":329,"city_name":"曲靖市","initial":"Q","is_del":0,"pid":26},{"id":93,"city_name":"齐齐哈尔市","initial":"Q","is_del":0,"pid":8},{"id":100,"city_name":"七台河市","initial":"Q","is_del":0,"pid":8},{"id":370,"city_name":"庆阳市","initial":"Q","is_del":0,"pid":29},{"id":150,"city_name":"泉州市","initial":"Q","is_del":0,"pid":13},{"id":167,"city_name":"青岛市","initial":"Q","is_del":0,"pid":15},{"id":225,"city_name":"潜江市","initial":"Q","is_del":0,"pid":18},{"id":345,"city_name":"日喀则市","initial":"R","is_del":0,"pid":27},{"id":176,"city_name":"日照市","initial":"R","is_del":0,"pid":15},{"id":9,"city_name":"上海","initial":"S","is_del":1,"pid":0},{"id":15,"city_name":"山东","initial":"S","is_del":0,"pid":0},{"id":16,"city_name":"山西","initial":"S","is_del":0,"pid":0},{"id":278,"city_name":"三亚市","initial":"S","is_del":0,"pid":22},{"id":279,"city_name":"三沙市","initial":"S","is_del":0,"pid":22},{"id":24,"city_name":"四川","initial":"S","is_del":1,"pid":0},{"id":28,"city_name":"陕西","initial":"S","is_del":0,"pid":0},{"id":35,"city_name":"石家庄市","initial":"S","is_del":0,"pid":3},{"id":305,"city_name":"遂宁市","initial":"S","is_del":0,"pid":24},{"id":69,"city_name":"沈阳市","initial":"S","is_del":0,"pid":6},{"id":85,"city_name":"四平市","initial":"S","is_del":0,"pid":7},{"id":89,"city_name":"松原市","initial":"S","is_del":0,"pid":7},{"id":348,"city_name":"山南市","initial":"S","is_del":0,"pid":27},{"id":96,"city_name":"双鸭山市","initial":"S","is_del":0,"pid":8},{"id":103,"city_name":"绥化市","initial":"S","is_del":0,"pid":8},{"id":360,"city_name":"商洛市","initial":"S","is_del":0,"pid":28},{"id":105,"city_name":"上海市","initial":"S","is_del":0,"pid":9},{"id":110,"city_name":"苏州市","initial":"S","is_del":0,"pid":10},{"id":118,"city_name":"宿迁市","initial":"S","is_del":0,"pid":10},{"id":124,"city_name":"绍兴市","initial":"S","is_del":0,"pid":11},{"id":384,"city_name":"石嘴山市","initial":"S","is_del":0,"pid":31},{"id":141,"city_name":"宿州市","initial":"S","is_del":0,"pid":12},{"id":402,"city_name":"石河子市","initial":"S","is_del":0,"pid":32},{"id":149,"city_name":"三明市","initial":"S","is_del":0,"pid":13},{"id":408,"city_name":"双河市","initial":"S","is_del":0,"pid":32},{"id":165,"city_name":"上饶市","initial":"S","is_del":0,"pid":14},{"id":187,"city_name":"朔州市","initial":"S","is_del":0,"pid":16},{"id":204,"city_name":"三门峡市","initial":"S","is_del":0,"pid":17},{"id":206,"city_name":"商丘市","initial":"S","is_del":0,"pid":17},{"id":213,"city_name":"十堰市","initial":"S","is_del":0,"pid":18},{"id":222,"city_name":"随州市","initial":"S","is_del":0,"pid":18},{"id":227,"city_name":"神农架林区","initial":"S","is_del":0,"pid":18},{"id":232,"city_name":"邵阳市","initial":"S","is_del":0,"pid":19},{"id":243,"city_name":"韶关市","initial":"S","is_del":0,"pid":20},{"id":244,"city_name":"深圳市","initial":"S","is_del":0,"pid":20},{"id":246,"city_name":"汕头市","initial":"S","is_del":0,"pid":20},{"id":254,"city_name":"汕尾市","initial":"S","is_del":0,"pid":20},{"id":2,"city_name":"天津","initial":"T","is_del":0,"pid":0},{"id":287,"city_name":"屯昌县","initial":"T","is_del":0,"pid":22},{"id":34,"city_name":"天津市","initial":"T","is_del":0,"pid":2},{"id":36,"city_name":"唐山市","initial":"T","is_del":0,"pid":3},{"id":61,"city_name":"通辽市","initial":"T","is_del":0,"pid":5},{"id":324,"city_name":"铜仁市","initial":"T","is_del":0,"pid":25},{"id":80,"city_name":"铁岭市","initial":"T","is_del":0,"pid":6},{"id":87,"city_name":"通化市","initial":"T","is_del":0,"pid":7},{"id":352,"city_name":"铜川市","initial":"T","is_del":0,"pid":28},{"id":365,"city_name":"天水市","initial":"T","is_del":0,"pid":29},{"id":117,"city_name":"泰州市","initial":"T","is_del":0,"pid":10},{"id":128,"city_name":"台州市","initial":"T","is_del":0,"pid":11},{"id":390,"city_name":"吐鲁番市","initial":"T","is_del":0,"pid":32},{"id":136,"city_name":"铜陵市","initial":"T","is_del":0,"pid":12},{"id":400,"city_name":"塔城地区","initial":"T","is_del":0,"pid":32},{"id":404,"city_name":"图木舒克市","initial":"T","is_del":0,"pid":32},{"id":407,"city_name":"铁门关市","initial":"T","is_del":0,"pid":32},{"id":174,"city_name":"泰安市","initial":"T","is_del":0,"pid":15},{"id":182,"city_name":"太原市","initial":"T","is_del":0,"pid":16},{"id":226,"city_name":"天门市","initial":"T","is_del":0,"pid":18},{"id":266,"city_name":"梧州市","initial":"W","is_del":0,"pid":21},{"id":281,"city_name":"五指山市","initial":"W","is_del":0,"pid":22},{"id":283,"city_name":"文昌市","initial":"W","is_del":0,"pid":22},{"id":284,"city_name":"万宁市","initial":"W","is_del":0,"pid":22},{"id":59,"city_name":"乌海市","initial":"W","is_del":0,"pid":5},{"id":65,"city_name":"乌兰察布市","initial":"W","is_del":0,"pid":5},{"id":338,"city_name":"文山壮族苗族自治州","initial":"W","is_del":0,"pid":26},{"id":355,"city_name":"渭南市","initial":"W","is_del":0,"pid":28},{"id":107,"city_name":"无锡市","initial":"W","is_del":0,"pid":10},{"id":366,"city_name":"武威市","initial":"W","is_del":0,"pid":29},{"id":121,"city_name":"温州市","initial":"W","is_del":0,"pid":11},{"id":385,"city_name":"吴忠市","initial":"W","is_del":0,"pid":31},{"id":131,"city_name":"芜湖市","initial":"W","is_del":0,"pid":12},{"id":388,"city_name":"乌鲁木齐市","initial":"W","is_del":0,"pid":32},{"id":405,"city_name":"五家渠市","initial":"W","is_del":0,"pid":32},{"id":172,"city_name":"潍坊市","initial":"W","is_del":0,"pid":15},{"id":175,"city_name":"威海市","initial":"W","is_del":0,"pid":15},{"id":211,"city_name":"武汉市","initial":"W","is_del":0,"pid":18},{"id":27,"city_name":"西藏","initial":"X","is_del":0,"pid":0},{"id":32,"city_name":"新疆","initial":"X","is_del":1,"pid":0},{"id":39,"city_name":"邢台市","initial":"X","is_del":0,"pid":3},{"id":66,"city_name":"兴安盟","initial":"X","is_del":0,"pid":5},{"id":67,"city_name":"锡林郭勒盟","initial":"X","is_del":0,"pid":5},{"id":339,"city_name":"西双版纳傣族自治州","initial":"X","is_del":0,"pid":26},{"id":351,"city_name":"西安市","initial":"X","is_del":0,"pid":28},{"id":354,"city_name":"咸阳市","initial":"X","is_del":0,"pid":28},{"id":108,"city_name":"徐州市","initial":"X","is_del":0,"pid":10},{"id":375,"city_name":"西宁市","initial":"X","is_del":0,"pid":30},{"id":145,"city_name":"宣城市","initial":"X","is_del":0,"pid":12},{"id":147,"city_name":"厦门市","initial":"X","is_del":0,"pid":13},{"id":159,"city_name":"新余市","initial":"X","is_del":0,"pid":14},{"id":190,"city_name":"忻州市","initial":"X","is_del":0,"pid":16},{"id":199,"city_name":"新乡市","initial":"X","is_del":0,"pid":17},{"id":202,"city_name":"许昌市","initial":"X","is_del":0,"pid":17},{"id":207,"city_name":"信阳市","initial":"X","is_del":0,"pid":17},{"id":215,"city_name":"襄阳市","initial":"X","is_del":0,"pid":18},{"id":218,"city_name":"孝感市","initial":"X","is_del":0,"pid":18},{"id":221,"city_name":"咸宁市","initial":"X","is_del":0,"pid":18},{"id":224,"city_name":"仙桃市","initial":"X","is_del":0,"pid":18},{"id":230,"city_name":"湘潭市","initial":"X","is_del":0,"pid":19},{"id":241,"city_name":"湘西土家族苗族自治州","initial":"X","is_del":0,"pid":19},{"id":256,"city_name":"阳江市","initial":"Y","is_del":0,"pid":20},{"id":262,"city_name":"云浮市","initial":"Y","is_del":0,"pid":20},{"id":271,"city_name":"玉林市","initial":"Y","is_del":0,"pid":21},{"id":26,"city_name":"云南","initial":"Y","is_del":1,"pid":0},{"id":310,"city_name":"宜宾市","initial":"Y","is_del":0,"pid":24},{"id":313,"city_name":"雅安市","initial":"Y","is_del":0,"pid":24},{"id":330,"city_name":"玉溪市","initial":"Y","is_del":0,"pid":26},{"id":76,"city_name":"营口市","initial":"Y","is_del":0,"pid":6},{"id":91,"city_name":"延边朝鲜族自治州","initial":"Y","is_del":0,"pid":7},{"id":98,"city_name":"伊春市","initial":"Y","is_del":0,"pid":8},{"id":356,"city_name":"延安市","initial":"Y","is_del":0,"pid":28},{"id":358,"city_name":"榆林市","initial":"Y","is_del":0,"pid":28},{"id":114,"city_name":"盐城市","initial":"Y","is_del":0,"pid":10},{"id":115,"city_name":"扬州市","initial":"Y","is_del":0,"pid":10},{"id":381,"city_name":"玉树藏族自治州","initial":"Y","is_del":0,"pid":30},{"id":383,"city_name":"银川市","initial":"Y","is_del":0,"pid":31},{"id":399,"city_name":"伊犁哈萨克自治州","initial":"Y","is_del":0,"pid":32},{"id":160,"city_name":"鹰潭市","initial":"Y","is_del":0,"pid":14},{"id":163,"city_name":"宜春市","initial":"Y","is_del":0,"pid":14},{"id":171,"city_name":"烟台市","initial":"Y","is_del":0,"pid":15},{"id":184,"city_name":"阳泉市","initial":"Y","is_del":0,"pid":16},{"id":189,"city_name":"运城市","initial":"Y","is_del":0,"pid":16},{"id":201,"city_name":"濮阳市","initial":"Y","is_del":0,"pid":17},{"id":214,"city_name":"宜昌市","initial":"Y","is_del":0,"pid":18},{"id":233,"city_name":"岳阳市","initial":"Y","is_del":0,"pid":19},{"id":236,"city_name":"益阳市","initial":"Y","is_del":0,"pid":19},{"id":238,"city_name":"永州市","initial":"Y","is_del":0,"pid":19},{"id":259,"city_name":"中山市","initial":"Z","is_del":0,"pid":20},{"id":11,"city_name":"浙江","initial":"Z","is_del":0,"pid":0},{"id":280,"city_name":"儋州市","initial":"Z","is_del":0,"pid":22},{"id":41,"city_name":"张家口市","initial":"Z","is_del":0,"pid":3},{"id":297,"city_name":"重庆市","initial":"Z","is_del":0,"pid":23},{"id":299,"city_name":"自贡市","initial":"Z","is_del":0,"pid":24},{"id":301,"city_name":"泸州市","initial":"Z","is_del":0,"pid":24},{"id":315,"city_name":"资阳市","initial":"Z","is_del":0,"pid":24},{"id":321,"city_name":"遵义市","initial":"Z","is_del":0,"pid":25},{"id":332,"city_name":"昭通市","initial":"Z","is_del":0,"pid":26},{"id":367,"city_name":"张掖市","initial":"Z","is_del":0,"pid":29},{"id":116,"city_name":"镇江市","initial":"Z","is_del":0,"pid":10},{"id":126,"city_name":"衢州市","initial":"Z","is_del":0,"pid":11},{"id":127,"city_name":"舟山市","initial":"Z","is_del":0,"pid":11},{"id":387,"city_name":"中卫市","initial":"Z","is_del":0,"pid":31},{"id":143,"city_name":"亳州市","initial":"Z","is_del":0,"pid":12},{"id":151,"city_name":"漳州市","initial":"Z","is_del":0,"pid":13},{"id":168,"city_name":"淄博市","initial":"Z","is_del":0,"pid":15},{"id":169,"city_name":"枣庄市","initial":"Z","is_del":0,"pid":15},{"id":193,"city_name":"郑州市","initial":"Z","is_del":0,"pid":17},{"id":208,"city_name":"周口市","initial":"Z","is_del":0,"pid":17},{"id":209,"city_name":"驻马店市","initial":"Z","is_del":0,"pid":17},{"id":229,"city_name":"株洲市","initial":"Z","is_del":0,"pid":19},{"id":235,"city_name":"张家界市","initial":"Z","is_del":0,"pid":19},{"id":245,"city_name":"珠海市","initial":"Z","is_del":0,"pid":20},{"id":249,"city_name":"湛江市","initial":"Z","is_del":0,"pid":20},{"id":251,"city_name":"肇庆市","initial":"Z","is_del":0,"pid":20}]}'; // $result = json_decode($res, true); $redis->delete($apikey); // $redis->set($apikey, $result['datas']); die(); Db::startTrans(); try { // // edit_user_score(24, 7495015, 16); // edit_user_scoreaway(8, 7495015, 16); // // edit_user_score(24, 7496456, 40); // edit_user_scoreaway(8, 7496456, 40); // // edit_user_score(24, 7494044, 40); // edit_user_scoreaway(8, 7494044, 40); edit_user_money(17, 7493428,10); Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 'success'; return AESjiami('abcd123456'); die(); // return Db::name('coupon_plan_log')->where('uid', 7501136)->where('plan_id', 'in', '278,282,279,283,275,280,277,281')->sum('buy_num'); return Db::name('scorelock_log')->where('uid', 7501136)->where('plan_id', 'in', '278,282,279,283,275,280,277,281')->sum('buy_num'); die(); // 处理 18198666086 他积分扣5万 6086已经扣除25585 edit_user_scoreaway(7 , 7572458, 8000); edit_user_scoreaway(7 , 7575889, 8000); edit_user_scoreaway(7 , 7603254, 6000); edit_user_scoreaway(7 , 7572324, 1500); edit_user_scoreaway(7 , 7605407, 1500); edit_user_scoreaway(7 , 7603010, 585); die(); // 15759476806 7588620 // 17537161112 7493442 // 13996260121 7520062 $mobile = 13996260121; $uid = 7520062; $total_income = Db::name('payment')->where('state', 6)->where('order_type', 4)->where('uid', $uid)->sum('total_fee'); $tx_success = Db::name('withdraw_log')->where('status', 1)->where('uid', $uid)->sum('apply_money'); return $mobile.'充值:'.$total_income.',提现成功：'.$tx_success; // edit_user_scorelock1(1, 7495271, 1); die(); // Db::name('coupon_plan_log')->where('id', '>', 61805)->save(['is_get_dymic'=>2]); // return 22; // die(); // $service = new UserServices(); // try { // $service->withdraw(7493456, 100, 1); // }catch (Exception $e){ // return $e->getMessage(); // } // // return 'success'; // return Db::name('user')->where('id', 'not in', '7493266,7493267')->sum('score'); // return Db::name('user')->where('id', 'not in', '7493266,7493267')->where('income_type', 2)->sum('score_away'); // return 33; // return $income = Db::name('payment')->where('state', 6)->where('uid', 7601690)->where('order_type', 4)->sum('total_fee'); // $withdraw = Db::name('withdraw_log')->where('status', 1)->where('uid', 7539494)->sum('apply_money'); // return $income - $withdraw; // return Db::name('withdraw_log')->where('status', 1)->sum('practical_money'); //// 272 277 // return Db::name('coupon_plan_log')->where('plan_id','in','272')->where('uid', 'not in', '7493266,7493267')->sum('buy_num'); // $arr = [ // '超过10000笔数'=>Db::name('withdraw_log')->where('practical_money', '>', 10000)->where('status', 0)->count('id'), // '超过10000总金额'=>Db::name('withdraw_log')->where('practical_money', '>', 10000)->where('status', 0)->sum('practical_money'), // ]; // // return json_encode($arr); // // die(); // edit_user_score(20, 7569185, 2160); // edit_user_score(20, 7493480, 60); // return 22; // die(); // return Db::name('user')->where('id', 'not in', '7493267,7493266')->sum('score'); // return Db::name('coupon_plan_log')->where('uid', 'not in', '7493267,7493266')->where('plan_id', '266')->sum('buy_num'); // return Db::name('user')->where('id', 'not in', '7493267,7493266')->whereFindInSet('path', '7493430')->sum('buy_num'); // // return Db::name('coupon_plan_log')->whereDay('create_time', '-1 day')->where('uid', 'not in', '7493267')->sum('buy_num'); // return Db::name('coupon_plan_log')->whereDay('create_time', '-1 day')->where('uid', 'not in', '7493267')->sum('buy_num'); // die(); $apikey = 'dianfeiarea'; $redis = new Redis(); $res = '{"code":200,"msg":"查询成功","datas":[{"id":12,"city_name":"安徽","initial":"A","is_del":0,"pid":0},{"id":316,"city_name":"阿坝藏族羌族自治州","initial":"A","is_del":0,"pid":24},{"id":322,"city_name":"安顺市","initial":"A","is_del":0,"pid":25},{"id":68,"city_name":"阿拉善盟","initial":"A","is_del":0,"pid":5},{"id":71,"city_name":"鞍山市","initial":"A","is_del":0,"pid":6},{"id":350,"city_name":"阿里地区","initial":"A","is_del":0,"pid":27},{"id":359,"city_name":"安康市","initial":"A","is_del":0,"pid":28},{"id":137,"city_name":"安庆市","initial":"A","is_del":0,"pid":12},{"id":395,"city_name":"阿克苏地区","initial":"A","is_del":0,"pid":32},{"id":401,"city_name":"阿勒泰地区","initial":"A","is_del":0,"pid":32},{"id":403,"city_name":"阿拉尔市","initial":"A","is_del":0,"pid":32},{"id":197,"city_name":"安阳市","initial":"A","is_del":0,"pid":17},{"id":1,"city_name":"北京","initial":"B","is_del":0,"pid":0},{"id":267,"city_name":"北海市","initial":"B","is_del":0,"pid":21},{"id":272,"city_name":"百色市","initial":"B","is_del":0,"pid":21},{"id":33,"city_name":"北京市","initial":"B","is_del":0,"pid":1},{"id":290,"city_name":"白沙黎族自治县","initial":"B","is_del":0,"pid":22},{"id":294,"city_name":"保亭黎族苗族自治县","initial":"B","is_del":0,"pid":22},{"id":40,"city_name":"保定市","initial":"B","is_del":0,"pid":3},{"id":58,"city_name":"包头市","initial":"B","is_del":0,"pid":5},{"id":314,"city_name":"巴中市","initial":"B","is_del":0,"pid":24},{"id":64,"city_name":"巴彦淖尔市","initial":"B","is_del":0,"pid":5},{"id":323,"city_name":"毕节市","initial":"B","is_del":0,"pid":25},{"id":73,"city_name":"本溪市","initial":"B","is_del":0,"pid":6},{"id":331,"city_name":"保山市","initial":"B","is_del":0,"pid":26},{"id":88,"city_name":"白山市","initial":"B","is_del":0,"pid":7},{"id":90,"city_name":"白城市","initial":"B","is_del":0,"pid":7},{"id":353,"city_name":"宝鸡市","initial":"B","is_del":0,"pid":28},{"id":364,"city_name":"白银市","initial":"B","is_del":0,"pid":29},{"id":132,"city_name":"蚌埠市","initial":"B","is_del":0,"pid":12},{"id":393,"city_name":"博尔塔拉蒙古自治州","initial":"B","is_del":0,"pid":32},{"id":394,"city_name":"巴音郭楞蒙古自治州","initial":"B","is_del":0,"pid":32},{"id":406,"city_name":"北屯市","initial":"B","is_del":0,"pid":32},{"id":180,"city_name":"滨州市","initial":"B","is_del":0,"pid":15},{"id":260,"city_name":"潮州市","initial":"C","is_del":0,"pid":20},{"id":276,"city_name":"崇左市","initial":"C","is_del":0,"pid":21},{"id":23,"city_name":"重庆","initial":"C","is_del":0,"pid":0},{"id":288,"city_name":"澄迈县","initial":"C","is_del":0,"pid":22},{"id":291,"city_name":"昌江黎族自治县","initial":"C","is_del":0,"pid":22},{"id":42,"city_name":"承德市","initial":"C","is_del":0,"pid":3},{"id":298,"city_name":"成都市","initial":"C","is_del":0,"pid":24},{"id":43,"city_name":"沧州市","initial":"C","is_del":0,"pid":3},{"id":60,"city_name":"赤峰市","initial":"C","is_del":0,"pid":5},{"id":336,"city_name":"楚雄彝族自治州","initial":"C","is_del":0,"pid":26},{"id":81,"city_name":"朝阳市","initial":"C","is_del":0,"pid":6},{"id":83,"city_name":"长春市","initial":"C","is_del":0,"pid":7},{"id":346,"city_name":"昌都市","initial":"C","is_del":0,"pid":27},{"id":109,"city_name":"常州市","initial":"C","is_del":0,"pid":10},{"id":392,"city_name":"昌吉回族自治州","initial":"C","is_del":0,"pid":32},{"id":139,"city_name":"滁州市","initial":"C","is_del":0,"pid":12},{"id":144,"city_name":"池州市","initial":"C","is_del":0,"pid":12},{"id":185,"city_name":"长治市","initial":"C","is_del":0,"pid":16},{"id":228,"city_name":"长沙市","initial":"C","is_del":0,"pid":19},{"id":234,"city_name":"常德市","initial":"C","is_del":0,"pid":19},{"id":237,"city_name":"郴州市","initial":"C","is_del":0,"pid":19},{"id":258,"city_name":"东莞市","initial":"D","is_del":0,"pid":20},{"id":285,"city_name":"东方市","initial":"D","is_del":0,"pid":22},{"id":286,"city_name":"定安县","initial":"D","is_del":0,"pid":22},{"id":302,"city_name":"德阳市","initial":"D","is_del":0,"pid":24},{"id":312,"city_name":"达州市","initial":"D","is_del":0,"pid":24},{"id":70,"city_name":"大连市","initial":"D","is_del":0,"pid":6},{"id":74,"city_name":"丹东市","initial":"D","is_del":0,"pid":6},{"id":340,"city_name":"大理白族自治州","initial":"D","is_del":0,"pid":26},{"id":341,"city_name":"德宏傣族景颇族自治州","initial":"D","is_del":0,"pid":26},{"id":343,"city_name":"迪庆藏族自治州","initial":"D","is_del":0,"pid":26},{"id":97,"city_name":"大庆市","initial":"D","is_del":0,"pid":8},{"id":104,"city_name":"大兴安岭地区","initial":"D","is_del":0,"pid":8},{"id":371,"city_name":"定西市","initial":"D","is_del":0,"pid":29},{"id":170,"city_name":"东营市","initial":"D","is_del":0,"pid":15},{"id":178,"city_name":"德州市","initial":"D","is_del":0,"pid":15},{"id":183,"city_name":"大同市","initial":"D","is_del":0,"pid":16},{"id":62,"city_name":"鄂尔多斯市","initial":"E","is_del":0,"pid":5},{"id":216,"city_name":"鄂州市","initial":"E","is_del":0,"pid":18},{"id":223,"city_name":"恩施土家族苗族自治州","initial":"E","is_del":0,"pid":18},{"id":268,"city_name":"防城港市","initial":"F","is_del":0,"pid":21},{"id":13,"city_name":"福建","initial":"F","is_del":0,"pid":0},{"id":72,"city_name":"抚顺市","initial":"F","is_del":0,"pid":6},{"id":77,"city_name":"阜新市","initial":"F","is_del":0,"pid":6},{"id":140,"city_name":"阜阳市","initial":"F","is_del":0,"pid":12},{"id":146,"city_name":"福州市","initial":"F","is_del":0,"pid":13},{"id":164,"city_name":"抚州市","initial":"F","is_del":0,"pid":14},{"id":247,"city_name":"佛山市","initial":"F","is_del":0,"pid":20},{"id":265,"city_name":"桂林市","initial":"G","is_del":0,"pid":21},{"id":270,"city_name":"贵港市","initial":"G","is_del":0,"pid":21},{"id":20,"city_name":"广东","initial":"G","is_del":1,"pid":0},{"id":21,"city_name":"广西","initial":"G","is_del":1,"pid":0},{"id":25,"city_name":"贵州","initial":"G","is_del":1,"pid":0},{"id":29,"city_name":"甘肃","initial":"G","is_del":0,"pid":0},{"id":304,"city_name":"广元市","initial":"G","is_del":0,"pid":24},{"id":311,"city_name":"广安市","initial":"G","is_del":0,"pid":24},{"id":317,"city_name":"甘孜藏族自治州","initial":"G","is_del":0,"pid":24},{"id":319,"city_name":"贵阳市","initial":"G","is_del":0,"pid":25},{"id":374,"city_name":"甘南藏族自治州","initial":"G","is_del":0,"pid":29},{"id":380,"city_name":"果洛藏族自治州","initial":"G","is_del":0,"pid":30},{"id":386,"city_name":"固原市","initial":"G","is_del":0,"pid":31},{"id":161,"city_name":"赣州市","initial":"G","is_del":0,"pid":14},{"id":242,"city_name":"广州市","initial":"G","is_del":0,"pid":20},{"id":3,"city_name":"河北","initial":"H","is_del":0,"pid":0},{"id":8,"city_name":"黑龙江","initial":"H","is_del":0,"pid":0},{"id":17,"city_name":"河南","initial":"H","is_del":0,"pid":0},{"id":273,"city_name":"贺州市","initial":"H","is_del":0,"pid":21},{"id":18,"city_name":"湖北","initial":"H","is_del":0,"pid":0},{"id":274,"city_name":"河池市","initial":"H","is_del":0,"pid":21},{"id":19,"city_name":"湖南","initial":"H","is_del":0,"pid":0},{"id":277,"city_name":"海口市","initial":"H","is_del":0,"pid":22},{"id":22,"city_name":"海南","initial":"H","is_del":1,"pid":0},{"id":38,"city_name":"邯郸市","initial":"H","is_del":0,"pid":3},{"id":45,"city_name":"衡水市","initial":"H","is_del":0,"pid":3},{"id":57,"city_name":"呼和浩特市","initial":"H","is_del":0,"pid":5},{"id":63,"city_name":"呼伦贝尔市","initial":"H","is_del":0,"pid":5},{"id":337,"city_name":"红河哈尼族彝族自治州","initial":"H","is_del":0,"pid":26},{"id":82,"city_name":"葫芦岛市","initial":"H","is_del":0,"pid":6},{"id":92,"city_name":"哈尔滨市","initial":"H","is_del":0,"pid":8},{"id":95,"city_name":"鹤岗市","initial":"H","is_del":0,"pid":8},{"id":357,"city_name":"汉中市","initial":"H","is_del":0,"pid":28},{"id":102,"city_name":"黑河市","initial":"H","is_del":0,"pid":8},{"id":113,"city_name":"淮安市","initial":"H","is_del":0,"pid":10},{"id":119,"city_name":"杭州市","initial":"H","is_del":0,"pid":11},{"id":376,"city_name":"海东市","initial":"H","is_del":0,"pid":30},{"id":377,"city_name":"海北藏族自治州","initial":"H","is_del":0,"pid":30},{"id":378,"city_name":"黄南藏族自治州","initial":"H","is_del":0,"pid":30},{"id":123,"city_name":"湖州市","initial":"H","is_del":0,"pid":11},{"id":379,"city_name":"海南藏族自治州","initial":"H","is_del":0,"pid":30},{"id":382,"city_name":"海西蒙古族藏族自治州","initial":"H","is_del":0,"pid":30},{"id":130,"city_name":"合肥市","initial":"H","is_del":0,"pid":12},{"id":133,"city_name":"淮南市","initial":"H","is_del":0,"pid":12},{"id":135,"city_name":"淮北市","initial":"H","is_del":0,"pid":12},{"id":391,"city_name":"哈密市","initial":"H","is_del":0,"pid":32},{"id":138,"city_name":"黄山市","initial":"H","is_del":0,"pid":12},{"id":398,"city_name":"和田地区","initial":"H","is_del":0,"pid":32},{"id":411,"city_name":"胡杨河市","initial":"H","is_del":0,"pid":32},{"id":181,"city_name":"菏泽市","initial":"H","is_del":0,"pid":15},{"id":198,"city_name":"鹤壁市","initial":"H","is_del":0,"pid":17},{"id":203,"city_name":"漯河市","initial":"H","is_del":0,"pid":17},{"id":212,"city_name":"黄石市","initial":"H","is_del":0,"pid":18},{"id":220,"city_name":"黄冈市","initial":"H","is_del":0,"pid":18},{"id":231,"city_name":"衡阳市","initial":"H","is_del":0,"pid":19},{"id":239,"city_name":"怀化市","initial":"H","is_del":0,"pid":19},{"id":252,"city_name":"惠州市","initial":"H","is_del":0,"pid":20},{"id":255,"city_name":"河源市","initial":"H","is_del":0,"pid":20},{"id":261,"city_name":"揭阳市","initial":"J","is_del":0,"pid":20},{"id":7,"city_name":"吉林","initial":"J","is_del":0,"pid":0},{"id":10,"city_name":"江苏","initial":"J","is_del":0,"pid":0},{"id":14,"city_name":"江西","initial":"J","is_del":0,"pid":0},{"id":75,"city_name":"锦州市","initial":"J","is_del":0,"pid":6},{"id":84,"city_name":"吉林市","initial":"J","is_del":0,"pid":7},{"id":94,"city_name":"鸡西市","initial":"J","is_del":0,"pid":8},{"id":99,"city_name":"佳木斯市","initial":"J","is_del":0,"pid":8},{"id":362,"city_name":"嘉峪关市","initial":"J","is_del":0,"pid":29},{"id":363,"city_name":"金昌市","initial":"J","is_del":0,"pid":29},{"id":369,"city_name":"酒泉市","initial":"J","is_del":0,"pid":29},{"id":122,"city_name":"嘉兴市","initial":"J","is_del":0,"pid":11},{"id":125,"city_name":"金华市","initial":"J","is_del":0,"pid":11},{"id":156,"city_name":"景德镇市","initial":"J","is_del":0,"pid":14},{"id":158,"city_name":"九江市","initial":"J","is_del":0,"pid":14},{"id":162,"city_name":"吉安市","initial":"J","is_del":0,"pid":14},{"id":166,"city_name":"济南市","initial":"J","is_del":0,"pid":15},{"id":173,"city_name":"济宁市","initial":"J","is_del":0,"pid":15},{"id":186,"city_name":"晋城市","initial":"J","is_del":0,"pid":16},{"id":188,"city_name":"晋中市","initial":"J","is_del":0,"pid":16},{"id":200,"city_name":"焦作市","initial":"J","is_del":0,"pid":17},{"id":210,"city_name":"济源市","initial":"J","is_del":0,"pid":17},{"id":217,"city_name":"荆门市","initial":"J","is_del":0,"pid":18},{"id":219,"city_name":"荆州市","initial":"J","is_del":0,"pid":18},{"id":248,"city_name":"江门市","initial":"J","is_del":0,"pid":20},{"id":328,"city_name":"昆明市","initial":"K","is_del":0,"pid":26},{"id":389,"city_name":"克拉玛依市","initial":"K","is_del":0,"pid":32},{"id":396,"city_name":"克孜勒苏柯尔克孜自治州","initial":"K","is_del":0,"pid":32},{"id":397,"city_name":"喀什地区","initial":"K","is_del":0,"pid":32},{"id":409,"city_name":"可克达拉市","initial":"K","is_del":0,"pid":32},{"id":410,"city_name":"昆玉市","initial":"K","is_del":0,"pid":32},{"id":194,"city_name":"开封市","initial":"K","is_del":0,"pid":17},{"id":6,"city_name":"辽宁","initial":"L","is_del":0,"pid":0},{"id":264,"city_name":"柳州市","initial":"L","is_del":0,"pid":21},{"id":275,"city_name":"来宾市","initial":"L","is_del":0,"pid":21},{"id":289,"city_name":"临高县","initial":"L","is_del":0,"pid":22},{"id":292,"city_name":"乐东黎族自治县","initial":"L","is_del":0,"pid":22},{"id":293,"city_name":"陵水黎族自治县","initial":"L","is_del":0,"pid":22},{"id":44,"city_name":"廊坊市","initial":"L","is_del":0,"pid":3},{"id":307,"city_name":"乐山市","initial":"L","is_del":0,"pid":24},{"id":318,"city_name":"凉山彝族自治州","initial":"L","is_del":0,"pid":24},{"id":320,"city_name":"六盘水市","initial":"L","is_del":0,"pid":25},{"id":333,"city_name":"丽江市","initial":"L","is_del":0,"pid":26},{"id":78,"city_name":"辽阳市","initial":"L","is_del":0,"pid":6},{"id":335,"city_name":"临沧市","initial":"L","is_del":0,"pid":26},{"id":86,"city_name":"辽源市","initial":"L","is_del":0,"pid":7},{"id":344,"city_name":"拉萨市","initial":"L","is_del":0,"pid":27},{"id":347,"city_name":"林芝市","initial":"L","is_del":0,"pid":27},{"id":361,"city_name":"兰州市","initial":"L","is_del":0,"pid":29},{"id":112,"city_name":"连云港市","initial":"L","is_del":0,"pid":10},{"id":372,"city_name":"陇南市","initial":"L","is_del":0,"pid":29},{"id":373,"city_name":"临夏回族自治州","initial":"L","is_del":0,"pid":29},{"id":129,"city_name":"丽水市","initial":"L","is_del":0,"pid":11},{"id":142,"city_name":"六安市","initial":"L","is_del":0,"pid":12},{"id":153,"city_name":"龙岩市","initial":"L","is_del":0,"pid":13},{"id":177,"city_name":"临沂市","initial":"L","is_del":0,"pid":15},{"id":179,"city_name":"聊城市","initial":"L","is_del":0,"pid":15},{"id":191,"city_name":"临汾市","initial":"L","is_del":0,"pid":16},{"id":192,"city_name":"吕梁市","initial":"L","is_del":0,"pid":16},{"id":195,"city_name":"洛阳市","initial":"L","is_del":0,"pid":17},{"id":240,"city_name":"娄底市","initial":"L","is_del":0,"pid":19},{"id":303,"city_name":"绵阳市","initial":"M","is_del":0,"pid":24},{"id":309,"city_name":"眉山市","initial":"M","is_del":0,"pid":24},{"id":101,"city_name":"牡丹江市","initial":"M","is_del":0,"pid":8},{"id":134,"city_name":"马鞍山市","initial":"M","is_del":0,"pid":12},{"id":250,"city_name":"茂名市","initial":"M","is_del":0,"pid":20},{"id":253,"city_name":"梅州市","initial":"M","is_del":0,"pid":20},{"id":5,"city_name":"内蒙古","initial":"N","is_del":1,"pid":0},{"id":263,"city_name":"南宁市","initial":"N","is_del":0,"pid":21},{"id":31,"city_name":"宁夏","initial":"N","is_del":0,"pid":0},{"id":306,"city_name":"内江市","initial":"N","is_del":0,"pid":24},{"id":308,"city_name":"南充市","initial":"N","is_del":0,"pid":24},{"id":342,"city_name":"怒江傈僳族自治州","initial":"N","is_del":0,"pid":26},{"id":349,"city_name":"那曲市","initial":"N","is_del":0,"pid":27},{"id":106,"city_name":"南京市","initial":"N","is_del":0,"pid":10},{"id":111,"city_name":"南通市","initial":"N","is_del":0,"pid":10},{"id":120,"city_name":"宁波市","initial":"N","is_del":0,"pid":11},{"id":152,"city_name":"南平市","initial":"N","is_del":0,"pid":13},{"id":154,"city_name":"宁德市","initial":"N","is_del":0,"pid":13},{"id":155,"city_name":"南昌市","initial":"N","is_del":0,"pid":14},{"id":205,"city_name":"南阳市","initial":"N","is_del":0,"pid":17},{"id":300,"city_name":"攀枝花市","initial":"P","is_del":0,"pid":24},{"id":334,"city_name":"普洱市","initial":"P","is_del":0,"pid":26},{"id":79,"city_name":"盘锦市","initial":"P","is_del":0,"pid":6},{"id":368,"city_name":"平凉市","initial":"P","is_del":0,"pid":29},{"id":148,"city_name":"莆田市","initial":"P","is_del":0,"pid":13},{"id":157,"city_name":"萍乡市","initial":"P","is_del":0,"pid":14},{"id":196,"city_name":"平顶山市","initial":"P","is_del":0,"pid":17},{"id":257,"city_name":"清远市","initial":"Q","is_del":0,"pid":20},{"id":269,"city_name":"钦州市","initial":"Q","is_del":0,"pid":21},{"id":282,"city_name":"琼海市","initial":"Q","is_del":0,"pid":22},{"id":30,"city_name":"青海","initial":"Q","is_del":0,"pid":0},{"id":37,"city_name":"秦皇岛市","initial":"Q","is_del":0,"pid":3},{"id":295,"city_name":"琼中黎族苗族自治县","initial":"Q","is_del":0,"pid":22},{"id":325,"city_name":"黔西南布依族苗族自治州","initial":"Q","is_del":0,"pid":25},{"id":326,"city_name":"黔东南苗族侗族自治州","initial":"Q","is_del":0,"pid":25},{"id":327,"city_name":"黔南布依族苗族自治州","initial":"Q","is_del":0,"pid":25},{"id":329,"city_name":"曲靖市","initial":"Q","is_del":0,"pid":26},{"id":93,"city_name":"齐齐哈尔市","initial":"Q","is_del":0,"pid":8},{"id":100,"city_name":"七台河市","initial":"Q","is_del":0,"pid":8},{"id":370,"city_name":"庆阳市","initial":"Q","is_del":0,"pid":29},{"id":150,"city_name":"泉州市","initial":"Q","is_del":0,"pid":13},{"id":167,"city_name":"青岛市","initial":"Q","is_del":0,"pid":15},{"id":225,"city_name":"潜江市","initial":"Q","is_del":0,"pid":18},{"id":345,"city_name":"日喀则市","initial":"R","is_del":0,"pid":27},{"id":176,"city_name":"日照市","initial":"R","is_del":0,"pid":15},{"id":9,"city_name":"上海","initial":"S","is_del":1,"pid":0},{"id":15,"city_name":"山东","initial":"S","is_del":0,"pid":0},{"id":16,"city_name":"山西","initial":"S","is_del":0,"pid":0},{"id":278,"city_name":"三亚市","initial":"S","is_del":0,"pid":22},{"id":279,"city_name":"三沙市","initial":"S","is_del":0,"pid":22},{"id":24,"city_name":"四川","initial":"S","is_del":1,"pid":0},{"id":28,"city_name":"陕西","initial":"S","is_del":0,"pid":0},{"id":35,"city_name":"石家庄市","initial":"S","is_del":0,"pid":3},{"id":305,"city_name":"遂宁市","initial":"S","is_del":0,"pid":24},{"id":69,"city_name":"沈阳市","initial":"S","is_del":0,"pid":6},{"id":85,"city_name":"四平市","initial":"S","is_del":0,"pid":7},{"id":89,"city_name":"松原市","initial":"S","is_del":0,"pid":7},{"id":348,"city_name":"山南市","initial":"S","is_del":0,"pid":27},{"id":96,"city_name":"双鸭山市","initial":"S","is_del":0,"pid":8},{"id":103,"city_name":"绥化市","initial":"S","is_del":0,"pid":8},{"id":360,"city_name":"商洛市","initial":"S","is_del":0,"pid":28},{"id":105,"city_name":"上海市","initial":"S","is_del":0,"pid":9},{"id":110,"city_name":"苏州市","initial":"S","is_del":0,"pid":10},{"id":118,"city_name":"宿迁市","initial":"S","is_del":0,"pid":10},{"id":124,"city_name":"绍兴市","initial":"S","is_del":0,"pid":11},{"id":384,"city_name":"石嘴山市","initial":"S","is_del":0,"pid":31},{"id":141,"city_name":"宿州市","initial":"S","is_del":0,"pid":12},{"id":402,"city_name":"石河子市","initial":"S","is_del":0,"pid":32},{"id":149,"city_name":"三明市","initial":"S","is_del":0,"pid":13},{"id":408,"city_name":"双河市","initial":"S","is_del":0,"pid":32},{"id":165,"city_name":"上饶市","initial":"S","is_del":0,"pid":14},{"id":187,"city_name":"朔州市","initial":"S","is_del":0,"pid":16},{"id":204,"city_name":"三门峡市","initial":"S","is_del":0,"pid":17},{"id":206,"city_name":"商丘市","initial":"S","is_del":0,"pid":17},{"id":213,"city_name":"十堰市","initial":"S","is_del":0,"pid":18},{"id":222,"city_name":"随州市","initial":"S","is_del":0,"pid":18},{"id":227,"city_name":"神农架林区","initial":"S","is_del":0,"pid":18},{"id":232,"city_name":"邵阳市","initial":"S","is_del":0,"pid":19},{"id":243,"city_name":"韶关市","initial":"S","is_del":0,"pid":20},{"id":244,"city_name":"深圳市","initial":"S","is_del":0,"pid":20},{"id":246,"city_name":"汕头市","initial":"S","is_del":0,"pid":20},{"id":254,"city_name":"汕尾市","initial":"S","is_del":0,"pid":20},{"id":2,"city_name":"天津","initial":"T","is_del":0,"pid":0},{"id":287,"city_name":"屯昌县","initial":"T","is_del":0,"pid":22},{"id":34,"city_name":"天津市","initial":"T","is_del":0,"pid":2},{"id":36,"city_name":"唐山市","initial":"T","is_del":0,"pid":3},{"id":61,"city_name":"通辽市","initial":"T","is_del":0,"pid":5},{"id":324,"city_name":"铜仁市","initial":"T","is_del":0,"pid":25},{"id":80,"city_name":"铁岭市","initial":"T","is_del":0,"pid":6},{"id":87,"city_name":"通化市","initial":"T","is_del":0,"pid":7},{"id":352,"city_name":"铜川市","initial":"T","is_del":0,"pid":28},{"id":365,"city_name":"天水市","initial":"T","is_del":0,"pid":29},{"id":117,"city_name":"泰州市","initial":"T","is_del":0,"pid":10},{"id":128,"city_name":"台州市","initial":"T","is_del":0,"pid":11},{"id":390,"city_name":"吐鲁番市","initial":"T","is_del":0,"pid":32},{"id":136,"city_name":"铜陵市","initial":"T","is_del":0,"pid":12},{"id":400,"city_name":"塔城地区","initial":"T","is_del":0,"pid":32},{"id":404,"city_name":"图木舒克市","initial":"T","is_del":0,"pid":32},{"id":407,"city_name":"铁门关市","initial":"T","is_del":0,"pid":32},{"id":174,"city_name":"泰安市","initial":"T","is_del":0,"pid":15},{"id":182,"city_name":"太原市","initial":"T","is_del":0,"pid":16},{"id":226,"city_name":"天门市","initial":"T","is_del":0,"pid":18},{"id":266,"city_name":"梧州市","initial":"W","is_del":0,"pid":21},{"id":281,"city_name":"五指山市","initial":"W","is_del":0,"pid":22},{"id":283,"city_name":"文昌市","initial":"W","is_del":0,"pid":22},{"id":284,"city_name":"万宁市","initial":"W","is_del":0,"pid":22},{"id":59,"city_name":"乌海市","initial":"W","is_del":0,"pid":5},{"id":65,"city_name":"乌兰察布市","initial":"W","is_del":0,"pid":5},{"id":338,"city_name":"文山壮族苗族自治州","initial":"W","is_del":0,"pid":26},{"id":355,"city_name":"渭南市","initial":"W","is_del":0,"pid":28},{"id":107,"city_name":"无锡市","initial":"W","is_del":0,"pid":10},{"id":366,"city_name":"武威市","initial":"W","is_del":0,"pid":29},{"id":121,"city_name":"温州市","initial":"W","is_del":0,"pid":11},{"id":385,"city_name":"吴忠市","initial":"W","is_del":0,"pid":31},{"id":131,"city_name":"芜湖市","initial":"W","is_del":0,"pid":12},{"id":388,"city_name":"乌鲁木齐市","initial":"W","is_del":0,"pid":32},{"id":405,"city_name":"五家渠市","initial":"W","is_del":0,"pid":32},{"id":172,"city_name":"潍坊市","initial":"W","is_del":0,"pid":15},{"id":175,"city_name":"威海市","initial":"W","is_del":0,"pid":15},{"id":211,"city_name":"武汉市","initial":"W","is_del":0,"pid":18},{"id":27,"city_name":"西藏","initial":"X","is_del":0,"pid":0},{"id":32,"city_name":"新疆","initial":"X","is_del":1,"pid":0},{"id":39,"city_name":"邢台市","initial":"X","is_del":0,"pid":3},{"id":66,"city_name":"兴安盟","initial":"X","is_del":0,"pid":5},{"id":67,"city_name":"锡林郭勒盟","initial":"X","is_del":0,"pid":5},{"id":339,"city_name":"西双版纳傣族自治州","initial":"X","is_del":0,"pid":26},{"id":351,"city_name":"西安市","initial":"X","is_del":0,"pid":28},{"id":354,"city_name":"咸阳市","initial":"X","is_del":0,"pid":28},{"id":108,"city_name":"徐州市","initial":"X","is_del":0,"pid":10},{"id":375,"city_name":"西宁市","initial":"X","is_del":0,"pid":30},{"id":145,"city_name":"宣城市","initial":"X","is_del":0,"pid":12},{"id":147,"city_name":"厦门市","initial":"X","is_del":0,"pid":13},{"id":159,"city_name":"新余市","initial":"X","is_del":0,"pid":14},{"id":190,"city_name":"忻州市","initial":"X","is_del":0,"pid":16},{"id":199,"city_name":"新乡市","initial":"X","is_del":0,"pid":17},{"id":202,"city_name":"许昌市","initial":"X","is_del":0,"pid":17},{"id":207,"city_name":"信阳市","initial":"X","is_del":0,"pid":17},{"id":215,"city_name":"襄阳市","initial":"X","is_del":0,"pid":18},{"id":218,"city_name":"孝感市","initial":"X","is_del":0,"pid":18},{"id":221,"city_name":"咸宁市","initial":"X","is_del":0,"pid":18},{"id":224,"city_name":"仙桃市","initial":"X","is_del":0,"pid":18},{"id":230,"city_name":"湘潭市","initial":"X","is_del":0,"pid":19},{"id":241,"city_name":"湘西土家族苗族自治州","initial":"X","is_del":0,"pid":19},{"id":256,"city_name":"阳江市","initial":"Y","is_del":0,"pid":20},{"id":262,"city_name":"云浮市","initial":"Y","is_del":0,"pid":20},{"id":271,"city_name":"玉林市","initial":"Y","is_del":0,"pid":21},{"id":26,"city_name":"云南","initial":"Y","is_del":1,"pid":0},{"id":310,"city_name":"宜宾市","initial":"Y","is_del":0,"pid":24},{"id":313,"city_name":"雅安市","initial":"Y","is_del":0,"pid":24},{"id":330,"city_name":"玉溪市","initial":"Y","is_del":0,"pid":26},{"id":76,"city_name":"营口市","initial":"Y","is_del":0,"pid":6},{"id":91,"city_name":"延边朝鲜族自治州","initial":"Y","is_del":0,"pid":7},{"id":98,"city_name":"伊春市","initial":"Y","is_del":0,"pid":8},{"id":356,"city_name":"延安市","initial":"Y","is_del":0,"pid":28},{"id":358,"city_name":"榆林市","initial":"Y","is_del":0,"pid":28},{"id":114,"city_name":"盐城市","initial":"Y","is_del":0,"pid":10},{"id":115,"city_name":"扬州市","initial":"Y","is_del":0,"pid":10},{"id":381,"city_name":"玉树藏族自治州","initial":"Y","is_del":0,"pid":30},{"id":383,"city_name":"银川市","initial":"Y","is_del":0,"pid":31},{"id":399,"city_name":"伊犁哈萨克自治州","initial":"Y","is_del":0,"pid":32},{"id":160,"city_name":"鹰潭市","initial":"Y","is_del":0,"pid":14},{"id":163,"city_name":"宜春市","initial":"Y","is_del":0,"pid":14},{"id":171,"city_name":"烟台市","initial":"Y","is_del":0,"pid":15},{"id":184,"city_name":"阳泉市","initial":"Y","is_del":0,"pid":16},{"id":189,"city_name":"运城市","initial":"Y","is_del":0,"pid":16},{"id":201,"city_name":"濮阳市","initial":"Y","is_del":0,"pid":17},{"id":214,"city_name":"宜昌市","initial":"Y","is_del":0,"pid":18},{"id":233,"city_name":"岳阳市","initial":"Y","is_del":0,"pid":19},{"id":236,"city_name":"益阳市","initial":"Y","is_del":0,"pid":19},{"id":238,"city_name":"永州市","initial":"Y","is_del":0,"pid":19},{"id":259,"city_name":"中山市","initial":"Z","is_del":0,"pid":20},{"id":11,"city_name":"浙江","initial":"Z","is_del":0,"pid":0},{"id":280,"city_name":"儋州市","initial":"Z","is_del":0,"pid":22},{"id":41,"city_name":"张家口市","initial":"Z","is_del":0,"pid":3},{"id":297,"city_name":"重庆市","initial":"Z","is_del":0,"pid":23},{"id":299,"city_name":"自贡市","initial":"Z","is_del":0,"pid":24},{"id":301,"city_name":"泸州市","initial":"Z","is_del":0,"pid":24},{"id":315,"city_name":"资阳市","initial":"Z","is_del":0,"pid":24},{"id":321,"city_name":"遵义市","initial":"Z","is_del":0,"pid":25},{"id":332,"city_name":"昭通市","initial":"Z","is_del":0,"pid":26},{"id":367,"city_name":"张掖市","initial":"Z","is_del":0,"pid":29},{"id":116,"city_name":"镇江市","initial":"Z","is_del":0,"pid":10},{"id":126,"city_name":"衢州市","initial":"Z","is_del":0,"pid":11},{"id":127,"city_name":"舟山市","initial":"Z","is_del":0,"pid":11},{"id":387,"city_name":"中卫市","initial":"Z","is_del":0,"pid":31},{"id":143,"city_name":"亳州市","initial":"Z","is_del":0,"pid":12},{"id":151,"city_name":"漳州市","initial":"Z","is_del":0,"pid":13},{"id":168,"city_name":"淄博市","initial":"Z","is_del":0,"pid":15},{"id":169,"city_name":"枣庄市","initial":"Z","is_del":0,"pid":15},{"id":193,"city_name":"郑州市","initial":"Z","is_del":0,"pid":17},{"id":208,"city_name":"周口市","initial":"Z","is_del":0,"pid":17},{"id":209,"city_name":"驻马店市","initial":"Z","is_del":0,"pid":17},{"id":229,"city_name":"株洲市","initial":"Z","is_del":0,"pid":19},{"id":235,"city_name":"张家界市","initial":"Z","is_del":0,"pid":19},{"id":245,"city_name":"珠海市","initial":"Z","is_del":0,"pid":20},{"id":249,"city_name":"湛江市","initial":"Z","is_del":0,"pid":20},{"id":251,"city_name":"肇庆市","initial":"Z","is_del":0,"pid":20}]}'; $result = json_decode($res, true); $redis->set($apikey, $result['datas']); return 11; //die(); // $list = Db::name('user')->where('pid', 7569185)->select(); // $users = ''; // foreach ($list as $key=>$val){ // $users .= ($val['id'].','); // } // return $users; // return json_encode(Db::name('score_log')->where('type', 10)->whereDay('create_at', 'today')->sum('score'); return $pushDynamic = Db::name('score_log')->where('type', 10)->whereDay('create_at', '-2 day')->sum('score'); return Db::name('withdraw_log')->where('status', 0)->sum('practical_money'); $addmoney = intval(number_format(8.32*100 - 8.22*100, '0', '.', '')); $need = env('APP.YG_ONCE_ADD') * 100; // return json_encode([$addmoney, $need]); if (intval($need) > intval($addmoney)){ return '当前加价幅度不能低于'.env('APP.YG_ONCE_ADD'); } return 11; return Db::name('score_log')->whereDay('create_at', '-1 day')->where('type', 10)->sum('score'); die(); return Db::name('score_log')->where('id', '>', 618769)->where('type', 11)->sum('score'); // 7493433 return Db::name('score_log')->where('uid', 7493433)->where('type', 11)->where('create_at', '>', '2022-07-25 00:00:00')->where('create_at', '<', '2022-07-26 00:00:00')->sum('score'); $day = 'today'; return $total = Db::name('coupon_plan_log')->whereDay('create_time', $day)->where('uid', 'not in', [7493267,7493266])->sum('buy_num'); // return Db::name('coupon_plan_log')->where('create_time', '>', '2022-07-24 20:16:42')->where('uid', 'not in', '7493266,7493267')->sum('buy_num'); // Queue::instance()->log('执行成功新增计划')->do("couponAddNewPlan")->job(CouponPlanJob::class)->push([13, 272, 1]); // // return 22; // return Db::name('score_log')->whereDay('create_at', 'today')->where('type', 'in', '11')->sum('score'); $set_arr = []; $list = Db::name('coupon_plan_log')->where('create_time', '>', '2022-07-25 20:00:01')->where('plan_id', 272)->where('uid', 'not in', '7493266,7493267')->select(); foreach ($list as $key=>$val){ } return Db::name('withdraw_log')->whereDay('create_at', 'today')->sum('apply_money'); return 33; return 33; Db::name('coupon_plan_log')->where('create_time', '>', '2022-07-24 20:16:42')->save(['is_get_dymic'=>2]); return 44; $get_time = time(); $model = new CouponPlanModel(); Db::startTrans(); try { $model->addPlan(7528608, 1000, 271, true, 0, $get_time); // $m_uer = new UserModel(); // // $userinfo = Db::name('user')->where('id', 7493487)->find(); // $money = 20; // // 直推收益 // $piduserinfo = $m_uer->where('id', $userinfo['pid'])->field('score, id,pid,is_auth,level')->find(); // $zt_score = number_format($money * env('coupon.COUPON_ZHITUI_SCALE', 0)/100, 4, '.', ''); // if ($zt_score > 0 && $piduserinfo){ // if ($piduserinfo['is_auth'] == 1){ // // edit_user_score(9, $piduserinfo['id'],$zt_score); // } // } Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 33; // Queue::instance()->log('竞拍过期执行成功705675')->job(JpOrderJob::class)->do('YgOrderExpired')->secs(5)->push([705675]); // return 33; // return Db::name('score_log')->where('uid', 7495208)->where('type', 'in', '9,11')->sum('score'); // return AESjiami('abcd123456'); // // Queue::instance()->log('竞拍过期执行成功')->job(JpOrderJob::class)->do('YgOrderExpired')->secs(5)->push([200336]); //// // return 33; // return Db::name('score_log')->where('uid', )->su return createApiSign([ 'timestamp'=> '1658559823114', 'app_version'=> '2.0.0', 'app_sources'=> 'miniapp', 'sys_version'=> '10.0.1', 'udid'=> '16585598231114333537', 'sm_deviceid'=> '16585598231114333537', 'mobile'=> '18280066008', 'password'=> 'JUiJ5bDDSsWEaHKeAhCC7w==', 'login_type'=> 'pass', 'jg_regid'=> '3aasdfad' ]); return AESjiami('abcd1234'); return 33; return Db::name('shop_goods')->where('price', '<', '999')->field('price,goods_id')->page(1, 10)->select(); // edit_user_couponnum(5, 7506924, 5); return 33; $service = new UserServices(); try { $service->withdraw(7494922,300, 1); }catch (Exception $e){ return $e->getMessage(); } return 'success'; $list = Db::name('score_log')->where('uid', 7494922)->where('type', 3)->page(1,1)->select(); return json_encode($list); // $in = Db::name('score_log')->where('type', 'in', '1,6,13')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'); // $out = Db::name('score_log')->where('type', 'in', '2,7,8,9,10,11,15')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'); $arr = [ '消费抢购参加扣除'=>Db::name('score_log')->where('type', 'in', '1')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '消费抢购活动结束发放'=>Db::name('score_log')->where('type', 'in', '2')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '购买商品返积分'=>Db::name('score_log')->where('type', 'in', '5')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '兑换商品'=>Db::name('score_log')->where('type', 'in', '6')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '激励奖'=>Db::name('score_log')->where('type', 'in', '7')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '末尾奖'=>Db::name('score_log')->where('type', 'in', '8')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '直推认购收益'=>Db::name('score_log')->where('type', 'in', '9')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '平级收益'=>Db::name('score_log')->where('type', 'in', '10')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '动态收益'=>Db::name('score_log')->where('type', 'in', '11')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '积分兑换到余额'=>Db::name('score_log')->where('type', 'in', '12')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '分红任务包兑换'=>Db::name('score_log')->where('type', 'in', '13')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '货款补发'=>Db::name('score_log')->where('type', 'in', '14')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '购物收益'=>Db::name('score_log')->where('type', 'in', '15')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'), '货款补缴'=>Db::name('score_log')->where('type', 'in', '16')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score') ]; return json_encode($arr); return Db::name('withdraw_log')->where('status', '0')->select(); $count = Db::name('xz_log')->where('type', 12)->where('id', '>', 3305814)->where('uid2', '20220705082713911354155')->count('id'); return $count; $list = Db::name('xz_log')->where('type', 12)->select()->toArray(); $arr = []; foreach ($list as $key=>$val){ $count = Db::name('xz_log')->where('uid2', $val['uid2'])->count('id'); if ($count > 1){ $arr[] = $val['uid2']; } } return json_encode($arr); $list = Db::name('yg_buy_record')->where('type', 1)->select()->toArray(); return json_encode($list); return $redscore = explode('-', '-'); // return $beginToday=mktime(0,0,0,intval(date('m')),intval(date('d')),intval(date('Y')));; // return $endToday=mktime(24,0,0,intval(date('m')),intval(date('d')),intval(date('Y')));; $arr = []; // 更新每天的couponarea信息 $area_list = Db::name('coupon_area')->select(); foreach ($area_list as $key=>$val){ $dayval = json_decode($val['buy_time']); $day = $dayval->day; $arr[] = $day; $beginToday=mktime(0,0,0,intval(date('m')),intval(date('d')),intval(date('Y'))); $endToday=mktime(24,0,0,intval(date('m')),intval(date('d')),intval(date('Y'))); $is_today = false; if ($beginToday<=$day && $endToday>$day){ $is_today = true; } Db::name('coupon_area')->where('id', $val['id'])->save(['is_today'=>($is_today?1:0)]); } return $arr; return 22; return $list = Db::name('shop_order')->where('user_id', 7605660)->where('status', 2)->select(); JPushServicePushOneMsg(false, '1507bfd3f73dcc61ff8', '您的竞拍被别人拍下了，快去看看吧', ['type'=>2,'params'=>json_encode(['yg_id'=>'3333'])]); return 22; return AESjiami('whl123456'); return JPushServicePushOneMsg(false, '1507bfd3f73dcc61ff8', '测试', ['type'=>1,'params'=>json_encode(['url'=>html_entity_decode('https://www.baidu.com')])]); return 33; return sr_getcurtime(mktime(0,0,0,date('m'), date('d'), date('Y'))); // return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', '-1 day')->sum('total_fee'); return $list = Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'in', [])->select(); $sum = 0; foreach ($list as $key=>$val){ $sum +=$val['total_fee']; } return $sum; $total = 0.0000; $list = Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'yesterday')->select(); foreach ($list as $key=>$val){ $total += $val['total_fee']; } return $total; return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'yesterday')->sum('total_fee'); $dayback = '- 10 day'; $total = Db::name('user')->whereDay('reg_time', $dayback)->count('id'); $total_shim = Db::name('user')->whereDay('reg_time', $dayback)->where('is_auth', 1)->count('id'); $res = [ 'date'=>sr_getcurtime(time()-86400*10, 'Y年-m月-d日'), 'xz_sum'=>Db::name('user')->sum('xz_num'), 'xz_more_10'=>Db::name('user')->where('xz_num', '>', 11.5)->sum('xz_num'), 'yesterday_income'=>Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', $dayback)->sum('total_fee'), 'withdow_success'=>number_format(Db::name('withdraw_log')->whereDay('update_at', $dayback)->where('status', 1)->sum('practical_money'), '2', '.', ''), 'yesterday_incomeuser'=>$total, 'yester_incomshiming'=>$total_shim, 'yester_couponnum'=>Db::name('coupon_plan_log')->whereDay('create_time', $dayback)->count('id'), 'yeseter_xznum'=>Db::name('xz_log')->where('type', 6)->whereDay('create_at', $dayback)->sum('score'), 'yester_shouxu'=>Db::name('xz_log')->where('type', 5)->whereDay('create_at', $dayback)->sum('shouxu_num') ]; return $res; die(); return json_encode(['tokenId'=>'7493666', 'ip'=>'113.251.62.38', 'timestamp'=>1657861293000, 'deviceId'=>'DeyJvcmdhbml6YXRpb24iOiJqNUtZSUpWVThtVk9ZTEQ1Qm5vRmFjY2Vzc0tleTp3Zlc1dUM4WE9XcTJza2FEUW9YMyIsIm9zIjoiYW5kcm9pZCIsImFwcElkIjoiZGVmYXVsdCIsImVuY29kZSI6MSwiZGF0YSI6ImV5SmhNU0k2SW1WNFkyVndkR2x2YmlJc0ltRTJJam9pWVc1a2NtOXBaQ0lzSW1FM0lqb2lNeTR5TGpJaUxDSmhNVEFpT2lJeE1DSXNJbUV4TXlJNklrMUpJRGdpTENKaE9UWWlPaUpxTlV0WlNVcFdWVGh0Vms5WlRFUTFRbTV2Um1GalkyVnpjMHRsZVRwM1psYzFkVU00V0U5WGNUSnphMkZFVVc5WU15SXNJbUV4TVNJNkltUmxabUYxYkhRaUxDSmxJam9pYW1GMllTNXNZVzVuTGtWNFkyVndkR2x2YmpvZ1pYSnliM0lnY21WME9pQTJNVFEzTURCY2JseDBZWFFnWTI5dExtbHphSFZ0WldrdWJERXhNVEZzTVRFeE1URXhTV3d1YkRFeE1URnNNVEV4TVRFeFNXd3ViREV4TVRGc01URXhNVEV4U1d3b1ZXNXJibTkzYmlCVGIzVnlZMlU2TVRRMU1DbGNibHgwWVhRZ1kyOXRMbWx6YUhWdFpXa3ViREV4TVd3eE1URXhNV3hKYkM1c01URXhNV3d4TVRFeE1URkpiQzVzTVRFeGJERXhNVEZzU1d3dWJERXhNV3d4TVRFeE1XeEpiQ2hWYm10dWIzZHVJRk52ZFhKalpUb3hNRFlwWEc1Y2RHRjBJR052YlM1cGMyaDFiV1ZwTG5OdFlXNTBhV1p5WVhWa0xsTnRRVzUwYVVaeVlYVmtMbWRsZEVSbGRtbGpaVWxrS0ZWdWEyNXZkMjRnVTI5MWNtTmxPakUxS1Z4dVhIUmhkQ0JqYjIwdVpYaGhiWEJzWlM1a1lYRnpiMlowTG1obFlXeDBhSEJoYzNOd2IzSjBMbTEyY0M1MWFTNWhZM1JwZG1sMGVTNVRjR3hoYzJoQlkzUnBkbWwwZVM1cGJtbDBSR0YwWVNoVGNHeGhjMmhCWTNScGRtbDBlUzVyZERvNU5pbGNibHgwWVhRZ1kyOXRMbXhwWVc1NWFTNWpiMjF0YjI1elpHc3VZbUZ6WlM1Q1lYTmxRV04wYVhacGRIa3ViMjVEY21WaGRHVW9RbUZ6WlVGamRHbDJhWFI1TG10ME9qRXhPQ2xjYmx4MFlYUWdZVzVrY205cFpDNWhjSEF1UVdOMGFYWnBkSGt1Y0dWeVptOXliVU55WldGMFpTaEJZM1JwZG1sMGVTNXFZWFpoT2pjNE9UTXBYRzVjZEdGMElHRnVaSEp2YVdRdVlYQndMa0ZqZEdsMmFYUjVMbkJsY21admNtMURjbVZoZEdVb1FXTjBhWFpwZEhrdWFtRjJZVG8zT0Rnd0tWeHVYSFJoZENCaGJtUnliMmxrTG1Gd2NDNUpibk4wY25WdFpXNTBZWFJwYjI0dVkyRnNiRUZqZEdsMmFYUjVUMjVEY21WaGRHVW9TVzV6ZEhKMWJXVnVkR0YwYVc5dUxtcGhkbUU2TVRNd055bGNibHgwWVhRZ1lXNWtjbTlwWkM1aGNIQXVRV04wYVhacGRIbFVhSEpsWVdRdWNHVnlabTl5YlV4aGRXNWphRUZqZEdsMmFYUjVLRUZqZEdsMmFYUjVWR2h5WldGa0xtcGhkbUU2TXpJNE15bGNibHgwWVhRZ1lXNWtjbTlwWkM1aGNIQXVRV04wYVhacGRIbFVhSEpsWVdRdWFHRnVaR3hsVEdGMWJtTm9RV04wYVhacGRIa29RV04wYVhacGRIbFVhSEpsWVdRdWFtRjJZVG96TkRVM0tWeHVYSFJoZENCaGJtUnliMmxrTG1Gd2NDNXpaWEoyWlhKMGNtRnVjMkZqZEdsdmJpNU1ZWFZ1WTJoQlkzUnBkbWwwZVVsMFpXMHVaWGhsWTNWMFpTaE1ZWFZ1WTJoQlkzUnBkbWwwZVVsMFpXMHVhbUYyWVRvNE15bGNibHgwWVhRZ1lXNWtjbTlwWkM1aGNIQXVjMlZ5ZG1WeWRISmhibk5oWTNScGIyNHVWSEpoYm5OaFkzUnBiMjVGZUdWamRYUnZjaTVsZUdWamRYUmxRMkZzYkdKaFkydHpLRlJ5WVc1ellXTjBhVzl1UlhobFkzVjBiM0l1YW1GMllUb3hNelVwWEc1Y2RHRjBJR0Z1WkhKdmFXUXVZWEJ3TG5ObGNuWmxjblJ5WVc1ellXTjBhVzl1TGxSeVlXNXpZV04wYVc5dVJYaGxZM1YwYjNJdVpYaGxZM1YwWlNoVWNtRnVjMkZqZEdsdmJrVjRaV04xZEc5eUxtcGhkbUU2T1RVcFhHNWNkR0YwSUdGdVpISnZhV1F1WVhCd0xrRmpkR2wyYVhSNVZHaHlaV0ZrSkVndWFHRnVaR3hsVFdWemMyRm5aU2hCWTNScGRtbDBlVlJvY21WaFpDNXFZWFpoT2pJd05EUXBYRzVjZEdGMElHRnVaSEp2YVdRdWIzTXVTR0Z1Wkd4bGNpNWthWE53WVhSamFFMWxjM05oWjJVb1NHRnVaR3hsY2k1cVlYWmhPakV3TnlsY2JseDBZWFFnWVc1a2NtOXBaQzV2Y3k1TWIyOXdaWEl1Ykc5dmNDaE1iMjl3WlhJdWFtRjJZVG95TWpRcFhHNWNkR0YwSUdGdVpISnZhV1F1WVhCd0xrRmpkR2wyYVhSNVZHaHlaV0ZrTG0xaGFXNG9RV04wYVhacGRIbFVhSEpsWVdRdWFtRjJZVG8zTlRZeUtWeHVYSFJoZENCcVlYWmhMbXhoYm1jdWNtVm1iR1ZqZEM1TlpYUm9iMlF1YVc1MmIydGxLRTVoZEdsMlpTQk5aWFJvYjJRcFhHNWNkR0YwSUdOdmJTNWhibVJ5YjJsa0xtbHVkR1Z5Ym1Gc0xtOXpMbEoxYm5ScGJXVkpibWwwSkUxbGRHaHZaRUZ1WkVGeVozTkRZV3hzWlhJdWNuVnVLRkoxYm5ScGJXVkpibWwwTG1waGRtRTZOVE01S1Z4dVhIUmhkQ0JqYjIwdVlXNWtjbTlwWkM1cGJuUmxjbTVoYkM1dmN5NWFlV2R2ZEdWSmJtbDBMbTFoYVc0b1dubG5iM1JsU1c1cGRDNXFZWFpoT2prMU1DbGNiaUo5IiwidG4iOiIiLCJlcCI6IiJ9','os'=>'android', 'appVersion'=>'2.0.0']); // 动态百分之三 // Queue::instance()->log('动态收益执行成功')->do("couponPlanDynamic")->job(CouponPlanJob::class)->push(['7493267,7493426,7493427,7493428,7493429,7493433,7493446', 2000, 7493500]); // return 22; // Queue::instance()->log('竞拍过期执行成功')->job(JpOrderJob::class)->do('YgOrderExpired')->secs(5)->push([200203]); die(); return 22; return Db::name('score_log')->where('from_id', 240)->where('type', 2)->sum('score'); die(); $redis = new \think\cache\driver\Redis(); $redis->delete('getCouponAreaList'); return 22; $redis->set('getCouponAreaList', ['aa'=>'bb']); return 22; // return Db::name('withdraw_log')->where('status', 1)->sum('practical_money'); // return Db::name('payment')->where('state', 6)->where('total_fee', '>', '3')->sum('total_fee'); // $list = Db::name('coupon_plan_log')->whereDay('create_time', '-1 day')->group('uid')->select(); // return $list; // // $levelarr = array(); // foreach ($list as $key=>$val){ // $path = Db::name('user')->where('id', $val['uid'])->value('path'); // $arr = explode(',', $path); // $level = ''; // foreach ($arr as $key1=>$val1){ // $level = Db::name('user')->where('id', $val['uid'])->value('level'); // $level .= $level; // } // // array_push($levelarr, $level); // } // // return $levelarr; // return Db::name('user')->where('id', ) // // return Db::name('score_log')->where('type', 11)->whereDay('create_at', 'yesterday')->where('uid', 'not in', [7493267,7493266])->sum('score'); // return Db::name('coupon_plan_log')->whereDay('create_time', 'yesterday')->where('uid', 'not in', [7493267,7493266])->sum('buy_num'); // // return Db::name('coupon_plan_log')->whereDay('create_time', 'today')->group('uid'); // // return AESjiami('Hmd1234567890'); // die(); return 22; $ser = new ThirdPayServices(); return $ser->getYsfPayJJSubmit(3444, []); // edit_user_xz(14,7494382, 20, 111, 0); // edit_user_xz(14, $uid, $need_num, $insert_id, $shouxu_num); die(); $model_user = new UserModel(); $list = $model_user->whereFindInSet('path', 7493430)->field('id,is_auth,nickname, avatar, reg_time')->toArray(); return 33; return 23; return password('admin'); die(); // aaa // return Db::name('thirdxz_hforder')->where('status', 1)->sum('price'); // return Db::name('withdraw_log')->where('status', 0)->where('practical_money', '>', '10000')->field('uid,apply_money,create_at,zfb_number,zfb_name')->select(); return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee'); // return Db::name('xz_log')->where('type', 3)->whereDay('create_at', '-7 day')->sum('score'); // return 22; // // return 33; // // return AESjiami('a123456789.'); // // return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee'); // return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee'); //return creathfOrderSn(); // $params = [ // 'mchId'=>env('XZTHIRD.PINWEI_MCHID'), // 'datetime'=>date('Ymdhis', time()) // ]; // // $params['sign'] = createApiSigncreatePwApiSign($params); // // return $params; // return password_hash("rasmuslerdorf", PASSWORD_DEFAULT); // 想知道以下字符从哪里来，可参见 password_hash() 的例子 // $hash = '$2y$10$KJwzVxe/plQ/EfDU2BnJIl.tbmvpAkVD0fq3T3a5OAEwGQ0qSBAcgK'; // // if (password_verify('rasmuslerdorf', $hash)) { // return '密码正确'; // } else { // return '密码错误'; // } // return AESjiemi('5izRb20EuGOQmIasKQCfYQ=='); // RSA 加密 // return RSA_openssl('{"test":"asdfasdf","asdf":"555555"}', 'encode'); // rsa 解密 // return RSA_openssl('WJOUfBgNuFYHwgfJtwgqVt8tmlbqRzNDCXab9SrdH7xb46b4HFBDhL5AltFITbg19ZxeMZJXsoYyruRHvYP/Y3FBCjdM5N08gaM8Z0OlKW85gJfy3TlfKQmLicYmxuMVcpBLEzFpeM9CBgs5KWDnngb9zz8DlJyzV4tTR/vR73I=', 'decode'); // GOBOkWqE87XgKLdl+3ePZMk7BUV1qEI0AqiLVuDwKj2GpBVMLR+mh0RrmD7a0ZFunF7ruZpvSU2b1mf3R/UNt+DcDU8wNQL1bCxz/acG5jdkuXi95eCIAyIe2Ym7YeMyFe4y8hvAlj4j/KFHGMWgWBgxdtOXH5o8e9oSlwX3u6g= // return RSA_openssl('GOBOkWqE87XgKLdl+3ePZMk7BUV1qEI0AqiLVuDwKj2GpBVMLR+mh0RrmD7a0ZFunF7ruZpvSU2b1mf3R/UNt+DcDU8wNQL1bCxz/acG5jdkuXi95eCIAyIe2Ym7YeMyFe4y8hvAlj4j/KFHGMWgWBgxdtOXH5o8e9oSlwX3u6g=', 'decode'); // 获取某个用户的token // die(); // $start = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d'),date('Y'))); // $w = date('w',strtotime($start)); //// $last_week_mon = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')-$w+1-7,date('Y'))); // $old_start = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')-90,date('Y'))); // $end_time = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1); // // // 用户在上一周的抢购数据总和 用户零撸次数 // $buy_num = Db::name('coupon_plan_log')->where('uid', 7494925)->where('create_time', '>', $old_start)->sum('buy_num'); // // return $buy_num; // return checkUserNeedsSecuritLogin(7494925); // $start = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d'),date('Y'))); // $w = date('w',strtotime($start)); //// $last_week_mon = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')-$w+1-7,date('Y'))); // $old_start = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')-7,date('Y'))); // $end_time = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1); // // return $end_time; // edit_user_xz(8, 7501532, 16); // return 22; // ////return $b_withdraw = array('bankStage'=>[],'businessCode'=>'WITHDRAW'); // $ser = new ThirdPayServices(); // return $ser->getYsfPayJJSubmit(3444, []); // return 22; // return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee'); //return ; // $time = time(); // return $order_timestart = sr_getcurtime($time, 'YmdHis');; // $orderi_info = [ // 'businessType'=>"100007", // 'goodsList'=>[ // 'amount'=>1, // 'name'=>'商品名字', // 'number'=>'1箱' // ], // 'id'=>'id34535' // ]; // return json_encode($orderi_info); // return $have_count = Db::name('machine_list')->where('uid', 7493460)->where('mid', 2)->where('state', 1)->count(); // return AESjiami('453322'); // return number_format(20*(100-5)/100, '2', '.', ''); // die(); // // return password('Wubiao112759?@$+'); // return Db::name('user')->where('id', 'in', '7590826,7535444,7601260,7601255,7601256,7601258,7601313,7601265,7601268,7601257,7601264,7601309,7601307,7601284,7601316,7601310,7601287,7601270,7601272,7601271,7601304,7601252,7601305,7601253,7601249,7601251,7601250,7601413,7601415,7601414,7601376,7601412,7601383,7601411,7601400,7601371,7601364,7601365,7601291,7601386,7601389,7601340,7601379,7601341,7601342,7601344,7601346,7601295,7601321,7601303,7601323,7601322,7545546,7545533,7545528,7545518,7545504,7545493,7545486,7545495,7545455,7545408,7545406,7545407,7545403,7545544,7545374,7545357,7545412,7545378,7545355,7545588,7545394,7545432,7545414,7545417,7545732,7545804,7545438,7545469,7545591,7545839,7545837,7545743,7545601,7545575,7545885,7545860,7545882,7545739,7545579,7545358,7545472,7545430,7545425,7545383,7545856,7545581,7545381,7545593,7545878,7545448,7545427,7545873,7545754,7545836,7545585,7545433,7545397,7545847,7545893,7545368,7545366,7545431,7545468,7545480,7545476,7545450,7545501,7545517,7545530,7545515,7545497,7545507,7545490,7545736,7545746,7545737,7545742,7545865,7523174,7523220,7523016,7523167,7523226,7523211,7523015,7523175,7523009,7523244,7523253,7523188,7523288,7523208,7523161,7523256,7523212,7523171,7523052,7523360,7523255,7523367,7523383,7523058,7523081,7523224,7523260,7523432,7523319,7523254,7523325,7523332,7523411,7523311,7523350,7523348,7523225,7523292,7523335,7523358,7523388,7523877,7523762,7523909,7523858,7523827,7523588,7523829,7523351,7523833,7526058,7526094,7526113,7526112,7526174,7526064,7526125,7523583,7526081,7526178,7526173,7526126,7526065,7525972,7526155,7526141,7526056,7526090,7526115,7526783,7526743,7526744,7526884,7526955,7526894,7526872,7526871,7527048,7526907,7526909,7526985,7526470,7526988,7526914,7527022,7526499,7526497,7527026,7526782,7543503,7543578,7543630,7543599,7543610,7543574,7543611,7543576,7543615,7544227,7543589,7544071,7544042,7545805,7543620,7544230,7545795,7545199,7545225,7545786,7545208,7545791,7545205,7545799,7543621,7545788,7545763,7545211,7543441,7543459,7543401,7545200,7543407,7543445,7544228,7543454,7543460,7543382,7543423,7543524,7543515,7543509,7543458,7543455,7543436,7543487,7543559,7543519,7543521,7543543,7543529,7543565,7543488,7543549,7543569,7543571,7543440,7543411,7543418,7544073,7544079,7544085,7543406,7544034,7543467,7543421,7543470,7545179,7545764,7545774,7545181,7545173,7545765,7545185,7545164,7545768,7545781,7543466,7545782,7545680,7545701,7545714,7545650,7545651,7545656,7545755,7545905,7545908,7545914,7545965,7546004,7545854,7545600,7545946,7545913,7545925,7546006,7545840,7545728,7545710,7545716,7545699,7545692,7545598,7545620,7545911,7545655,7545685,7545691,7545936,7545643,7545652,7545992,7545918,7545937,7545671,7545687,7545586,7545624,7545648,7545610,7545711,7545723,7545758,7545920,7545981,7545997,7563912,7563923,7563931,7564110,7563934,7563942,7563089,7563327,7563598,7563649,7563650,7563652,7563657,7563357,7563858,7563697,7563380,7563517,7563519,7563523,7563636,7563602,7563172,7563191,7563225,7563734,7563741,7563790,7564133,7563303,7563298,7563229,7563332,7563214,7563360,7563419,7563423,7563362,7563359,7563361,7563531,7563461,7563411,7563408,7563518,7563352,7563467,7563465,7563100,7564367,7564512,7564410,7563414,7564510,7564508,7563683,7563631,7564288,7564294,7564333,7564320,7564326,7564329,7564290,7564291,7564327,7564289,7564308,7564407,7564292,7564298,7564304,7564301,7564578,7564592,7564577,7564240,7564207,7564137,7564122,7564012,7563970,7563211,7563364,7564259,7563594,7564420,7578664,7558661,7558652,7558650,7557288,7557305,7557264,7557279,7557298,7557273,7557419,7558719,7558218,7557342,7557528,7557326,7557497,7557280,7557238,7557176,7557728,7557735,7557484,7557409,7558566,7558410,7558461,7558409,7558408,7558436,7558407,7558417,7558445,7559289,7559282,7559284,7559274,7559310,7559015,7557505,7557507,7557516,7557348,7557322,7559301,7559212,7557140,7558536,7559285,7557483,7557903,7557738,7556724,7556766,7556759,7556773,7556641,7556753,7556910,7556846,7556847,7556744,7556805,7556902,7556906,7550651,7550723,7550774,7551313,7551314,7551310,7551323,7551311,7551553,7551552,7551711,7551698,7551674,7551693,7551678,7551673,7551391,7551382,7551388,7552759,7551873,7551881,7551876,7551912,7551874,7551870,7551609,7551869,7550996,7551709,7550815,7550732,7551608,7551554,7550637,7551875,7550742,7550818,7550685,7550656,7550649,7550662,7550724,7550660,7550658,7551216,7551213,7551224,7551219,7551226,7551231,7551228,7550821,7550746,7550636,7550765,7551251,7551341,7551517,7550908,7551308,7551309,7551317,7551318,7551315,7551312,7551322,7551384,7551381,7551258,7551257,7551400,7551559,7551557,7551671,7551613,7551616,7551615,7551611,7550834,7550835,7550702,7551669,7550826,7550946,7550820,7551182,7551026,7551028,7551186,7551174,7551103,7551142,7551138,7551179,7551143,7551227,7551160,7551241,7551289,7551184,7551270,7551242,7551141,7551250,7551247,7551253,7551202,7548681,7548710,7548682,7548680,7548707,7548712,7548715,7548713,7548714,7548709,7548563,7548776,7548716,7548937,7549047,7549054,7548786,7548829,7548797,7548809,7548811,7548820,7548810,7548881,7548856,7548866,7548869,7548911,7548868,7548888,7548902,7549112,7549086,7549123,7549125,7549121,7549139,7549149,7544546,7551153,7551166,7551180,7551175,7551189,7551173,7551163,7551167,7551197,7548752,7548936,7548940,7548973,7548935,7548949,7551273,7548670,7551279,7551287,7551288,7551285,7551280,7551292,7551291,7551293,7551134,7551249,7551327,7548657,7551765,7551296,7552079,7551769,7552470,7551484,7550461,7550456,7550470,7550466,7550455,7550465,7550464,7550468,7550463,7550457,7550406,7536725,7557092,7548691,7548733,7548749,7548745,7548758,7548816,7548864,7548794,7548894,7549022,7548744,7548915,7548770,7548805,7548899,7548900,7548959,7548934,7548608,7548606,7548649,7548646,7548653,7548998,7548654,7548663,7548665,7548669,7548674,7548835,7548778,7548801,7548804,7548800,7548907,7548913,7548919,7548939,7548921,7548941,7548629,7548626,7548635,7548690,7548831,7548838,7548839,7548874,7548696,7548697,7548742,7548748,7548686,7548850,7548637,7548640,7548634,7548661,7548638,7548641,7548662,7548677,7548688,7527341,7527357,7527339,7527358,7527359,7529164,7529159,7529171,7529152,7529268,7529237,7529231,7529146,7529288,7529154,7529170,7529227,7529160,7529155,7529157,7529252,7529196,7529181,7529150,7529168,7529138,7529232,7530054,7530241,7530224,7529334,7527342,7529224,7530017,7529312,7527343,7527352,7527345,7527344,7529892,7529895,7527356,7527355,7529901,7530398,7530221,7530421,7530444,7529191,7530390,7530307,7530191,7529205,7530452,7534354,7534400,7534402,7534397,7534398,7534351,7534395,7529948,7529212,7534357,7534390,7534383,7534374,7534385,7529233,7529215,7529203,7529141,7529147,7529145,7529173,7529149,7529188,7529261,7529256,7529161,7529189,7529166,7526805,7529240,7529220,7529194,7529222,7529246,7529259,7529271,7529250,7529284,7529323,7529254,7529255,7526851,7529257,7529287,7529310,7529294,7529211,7529186,7529199,7529230,7529286,7529285,7529304,7529317,7529201,7529223,7529216,7529333,7529249,7529305,7529309,7529325,7535500,7535953,7535495,7529289,7535457,7535456,7529192,7529332,7529244,7534421,7534411,7535434,7535437,7535438,7534377,7534414,7535448,7535925,7535930,7534423,7535447,7535950,7535488,7534434,7535463,7541266,7524978,7534430,7524569,7541163,7524471,7523916,7535928,7541165,7523886,7541158,7535945,7543679,7543695,7543657,7544596,7544312,7544331,7543675,7543694,7543705,7544029,7543651,7543638,7544601,7543660,7543658,7543652,7543649,7543678,7543684,7543738,7543731,7543977,7543765,7529320,7544530,7543990,7543676,7544584,7543775,7544549,7544025,7544015,7544020,7543934,7543681,7544011,7543409,7544493,7544523,7544309,7544413,7544532,7544594,7544306,7544410,7544088,7543868,7544235,7544542,7543811,7544301,7545213,7543762,7545261,7545250,7545267,7544010,7543659,7545536,7545670,7545228,7545696,7545644,7545628,7545638,7545829,7545808,7545810,7545852,7545241,7545812,7544244,7545834,7545831,7545811,7545806,7545232,7544593,7544608,7544574,7544558,7544520,7544535,7544544,7544465,7544492,7544515,7544475,7544395,7544402,7544427,7544424,7544390,7544391,7544345,7544362,7544279,7543995,7544234,7545826,7544560,7545809,7544534,7545821,7545824,7545816,7545815,7546023,7545820,7543667,7543963,7543892,7543647,7543860,7543751,7543770,7544923,7544898,7544899,7544900,7544918,7544924,7544920,7544586,7544925,7544571,7544553,7544522,7544550,7544979,7544988,7544869,7544893,7544929,7544940,7544949,7544956,7544970,7544822,7544831,7544839,7544841,7544843,7544846,7544722,7544716,7544708,7545109,7545136,7544844,7545024,7545092,7545798,7544937,7544993,7545832,7545612,7545606,7545607,7545608,7545006,7545007,7545540,7545005,7544857,7544871,7544862,7544856,7544863,7544861,7545775,7545148,7545850,7545862,7545771,7545077,7545060,7545021,7545779,7544622,7545439,7541172,7534415,7534424,7541151,7541170,7524011,7541153,7541168,7541182,7541214,7541208,7541190,7541207,7545784,7545823,7544308,7545276,7541202,7541179,7541200,7541178,7541184,7541177,7541187,7541173,7541203,7541225,7541253,7541249,7541197,7541229,7541243,7541261,7541238,7541218,7541237,7541216,7541263,7541256,7548636,7548701,7548685,7548584,7544519,7548981,7548957,7548987,7544502,7540988,7541054,7540983,7540980,7541020,7541025,7540977,7541028,7540972,7541031,7540995,7541035,7541011,7540948,7541000,7540952,7541018,7541007,7540960,7540957,7540969,7564135,7564283,7564302,7564319,7564293,7571444,7571573,7523959,7571545,7523960,7523971,7523973,7523988,7523993,7523997,7524002,7524017,7524139,7524149,7524382,7524385,7524498,7524499,7524501,7524510,7524610,7524697,7524763,7524803,7524973,7524985,7524549,7524993,7524998,7525015,7525059,7525061,7525072,7525081,7525160,7525162,7525164,7525193,7525220,7525221,7525225,7525243,7525268,7525275,7525273,7525288,7525329,7525373,7525420,7525482,7529239,7529177,7529298,7529311,7529225,7529264,7529313,7529324,7529272,7529238,7529162,7529174,7529965,7529957,7529882,7529916,7530000,7530112,7530093,7529985,7529877,7530021,7530102,7530108,7530101,7530095,7530106,7530099,7529913,7530109,7529908,7529949,7530168,7530043,7529301,7529955,7530222,7530040,7529163,7530305,7530364,7530267,7529984,7530288,7530263,7530297,7530405,7530423,7530450,7543281,7530007,7544656,7543772,7545280,7548692,7548699,7548727,7548773,7548817,7548854,7549177,7601245,7601405,7601339,7601343,7598066,7598077,7598482,7598116,7598100,7598494,7598884,7599190,7599207,7599175,7599224,7599208,7599222,7599241,7599245,7599255,7545551,7563543,7563654,7563693,7551193,7548762,7529193,7592008,7514087,7525687,7524049,7523666,7524093,7524076,7524126,7524080,7524061,7524118,7524109,7524116,7524091,7524064,7523659,7523657,7523664,7523645,7520429,7523151,7523662,7541343,7524134,7524132,7543976,7524158,7548962,7524155,7528958,7524150,7523961')->where('xz_num', '>', 10)->sum('xz_num'); // //// return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee'); // $total = Db::name('user')->whereDay('reg_time', 'yesterday')->count('id'); $total_shim = Db::name('user')->whereDay('reg_time', 'yesterday')->where('is_auth', 1)->count('id'); $res = [ '日期'=>sr_getcurtime(time()-86400, 'Y年-m月-d日'), '星钻总数'=>Db::name('user')->sum('xz_num'), '星钻大于10总数'=>Db::name('user')->where('xz_num', '>', 11.5)->sum('xz_num'), '昨日充值'=>Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'yesterday')->sum('total_fee'), '昨日提现总金额'=>number_format(Db::name('withdraw_log')->whereDay('update_at', 'yesterday')->where('status', 1)->sum('practical_money'), '2', '.', ''), '昨日用户新增总人数'=>$total, '昨日用户新增实名人数'=>$total_shim, '昨日抢购人数'=>Db::name('coupon_plan_log')->whereDay('create_time', 'yesterday')->count('id'), '昨日星钻交易量'=>Db::name('xz_log')->where('type', 6)->whereDay('create_at', 'yesterday')->sum('score'), '昨日星钻手续费'=>Db::name('xz_log')->where('type', 5)->whereDay('create_at', 'yesterday')->sum('shouxu_num') ]; return json_encode($res); // Queue::instance()->log('执行成功新增计划')->do("couponAddNewPlan")->job(CouponPlanJob::class)->secs(3)->push([13, 152, 1]); // return 33; // Queue::instance()->log('竞拍过期执行成功')->do('YgOrderExpired')->job(JpOrderJob::class)->push([1]); // return 22; //die(); // return sysconfig('xzconfig', 'xz_cur_money');; // die(); // 星钻扣退 // edit_user_xz(13,7497003, 1 ); // 星钻退回 // edit_user_xz(8,7496595,1 ); return 11; // return AESjiami('453211'); // if (vertifySecurityPass('035155')){ // return '通过'; // } // return '不通过'; // adsfasdf // $list = Db::name('user')->where('id', 'in', '7555174,7538654,7507902,7532263,7520159,7515649,7528156,7600010,7600011,7595952,7502027,7520988,7529577,7570021,7502027,7515649,7553812')->field('mobile,id')->select(); // $str = ''; // // foreach ($list as $key=>$val){ // $str .= ("'".$val['mobile']."'"); // } // // return $str; // return Db::name('payment')->where('state', 6)->where('out_trade_no', 'like', "%CL%")->sum('total_fee'); // return Db::name('payment')->where('state', 6)->where('out_trade_no', 'like', "%FYYL%")->sum('total_fee'); // $sum_before = Db::name('coupon_plan')->where('area_id', 20)->where('state', 1)->sum('target_num'); // $bobi = $sum_before * 0.7; // // $tuandui = $sum_before * 0.03; // // $score = Db::name('user')->where('mobile', 18981488889)->value('score'); // // if (($score + $bobi+$tuandui) > 500000){ // return '负波比'.'---'.($score + $bobi+$tuandui); // } // // return '正波比'.'---'.($score + $bobi+$tuandui); // $time_arr = []; // for ($i = 0;$i < 5;$i ++){ // // $datastr = date("Y-m-d",strtotime("-".$i." day")); // $str=$datastr." 0:0:0"; // $data["star"]=$str; // $str=$datastr." 24:00:00"; // $data["end"]=$str; //// return $data; // // array_push($time_arr, $data); //// $time_arr[] = $i; //// array_push($time_arr, $i); // } // // // return $time_arr; // // die(); // $income = Db::name('score_log')->where('uid',7494922)->where('state', 1)->sum('score'); // $out = Db::name('score_log')->where('uid',7494922)->where('state', 2)->sum('score'); // return [ // '收入'=>$income, // '支出'=>$out, // '相差'=>$income-$out // ]; // return ; // return AESjiami('mm123456'); // return Db::name('shop_order')->where('status', 'in', '2,3')->sum('rebate_lock_score'); // return Db::name('withdraw_log')->where('status', 1)->sum('practical_money'); // return Db::name('payment')->where('order_type', 'in',"4")->where('state', 6)->sum('total_fee'); // return getWebUrl(); // return md5(AESjiami('Hmd1234567890')); // return Db::name('score_log')->where('uid', 7525254)->where('state', 2)->sum('score'); // die(); // Db::name('ad_error_records')->whereTime('create_time', '<', sr_getcurtime(time()))->save(['status'=>2]); // return 22; // $count199 = Db::name('renwu_machine_list')->where('rid', 9)->count(); // $count399 = Db::name('renwu_machine_list')->where('rid', 10)->count(); // // return [ // '199个数'=>$count199, // '199'=>$count199 * 199, // '399个数'=>$count399, // '399'=>$count399 * 399, // '共计'=>$count399 * 399+$count199 * 199, // '分发'=>Db::name('sys_func_log')->where('type', 1)->sum('money') // ]; // // die(); // // $arr = array( // 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, // 144, 147, // 150, 151, 152, 153, 155, 156, 157, 158, 159, // 176, 177, 178, // 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, // ); // $phone = $arr[array_rand($arr)] . '' . mt_rand(1000, 9999) . '' . mt_rand(1000, 9999); // die(); // die(); // $last_info = Db::name('coupon_plan_log')->where('plan_id', 158)->where('uid', 7548432)->max('id'); // return $last_info; // return AESjiami('abcd123456'); // 今日总实名人数 // return Db::name('user')->whereDay('reg_time', 'today')->where('is_auth', 1)->count(); // return Db::name('ad_log')->where('uid', 75133205)->where('status', 2)->whereDay('create_time', 'today')->max('id'); // return AESjiami('abcd123456'); // die(); // // $redis = new \think\cache\driver\Redis(); // $redis->clear(); // return 22; // 昨日星钻交易数量 // return Db::name('xz_log')->where('type', 5)->whereDay('create_at', 'today')->sum('score'); // 所有积分星钻 return json_encode(['星钻'=>Db::name('user')->where('xz_num', '>', 0.2)->where('xz_num', '<', 200)->sum('xz_num'), 'score'=>['用户持有'=>Db::name('user')->where('id', 'not in', 7493267)->sum('score'), '池子'=>Db::name('coupon_plan')->where('state', 1)->sum('target_num')] ]); // return sr_getcurtime(strtotime('+3 day', strtotime("2022-04-18 12:42:20"))); // return sr_getcurtime(strtotime('+3 day')); // Db::startTrans(); try { Db::name('user')->where('id', 'in', '7598474,7598479,7598492,7598495,7598508,7598522,7598540,7598555,7598562,7598574,7598590,7598594,7598598,7598605,7598614,7598615,7598616,7598617,7598618,7598619,7598620,7598621,7598622,7598623,7598624,7598625,7598626,7598627,7598628,7598629,7598630,7598632,7598634,7598635,7598637,7598639,7598641,7598642,7598648,7598649,7598650,7598651,7598655,7598656,7598659,7598660,7598661,7598662,7598663,7598664,7598668,7598669,7598670,7598673,7598674,7598675,7598678,7598679,7598684,7598687,7598689,7598690,7598696,7598697,7598698,7598699,7598700,7598701,7598702,7598704,7598709,7598711,7598712,7598713,7598714,7598715,7598717,7598718,7598720,7598723,7598725,7598726,7598728,7598729,7598730,7598731,7598740,7598741,7598748,7598750,7598755,7598756,7598759,7598760,7598761,7598762,7598763,7598764,7598765,7598766,7598767,7598768,7598770,7598771,7598773,7598776,7598777,7598779,7598781,7598782,7598783,7598785,7598787,7598789,7598793,7598794,7598795,7598797,7598801,7598805,7598806,7598808,7598811,7598813,7598814,7598815,7598819,7598821,7598823,7598827,7598828,7598831,7598832,7598833,7598834,7598838,7598843,7598847,7598850,7598855,7598856,7598864,7598869,7598871,7598873,7598877,7598881,7598882,7598885,7598888,7598893,7598899,7598905,7598906,7598910,7598916,7598917,7598918,7598920,7598921,7598923,7598931,7598932,7598933,7598934,7598938,7598939,7598941,7598942,7598945,7598950,7598952,7598957,7598961,7598962,7598969,7598971,7598972,7598977,7598980,7598981,7598983,7598986,7598988,7598989,7598990,7598992,7598993,7598995,7598999,7599000,7599004,7599005,7599013,7599015,7599018,7599020,7599027,7599030,7599042,7599050,7599059,7599070,7599072,7599078,7599080,7599086,7599087,7599094,7599095,7599099,7599105,7599106,7599113,7599155')->inc('total_active', 2000)->update(); Db::commit(); }catch (\Exception $e){ Db::rollback(); return 'error'; } return 'success'; // return AESjiami('abcd123456'); // 当前这一期购买记录 总和 return Db::name('coupon_plan_log')->where('plan_id', 143)->sum('buy_num'); // 查看昨天这个人的总收益 return Db::name('score_log')->where('uid', 7493427)->where('type', 'in', [9,10,11])->whereDay('create_at', 'yesterday')->sum('score'); // 减少用户积分 // edit_user_score(16, 7493685, 22); // return 33; // // $list = Db::name('machine_list') // ->alias('l') // ->leftJoin('machine m','m.id = l.mid') // ->field('l.*,m.name,m.add_active') // ->where('get_type', 'in', [2,3]) // ->where('state', 2) // ->select() // ->toArray(); // foreach ($list as $key=>$val){ // // if ($key > 1391){ // edit_user_active(5,$val['uid'], $val['add_active']); // } // } // return 22; // $m_machinelist = new MachineListModel(); // return $m_machinelist->whereTime('expire_time', '<', date("Y-m-d",strtotime("+90 day")))->where('state', 1)->select()->toArray(); // return AESjiami('abcd123456'); //return $error_count = env('API.ORDER_ERROR_BOTH_COUNT', 20); // $sql = "update zy_user set zy_user.`level` = `super_lv` where `super_lv` > 0"; // edit_user_score(16,7507305,14); // $modeluser = new UserModel(); // $list = Db::name('active_log')->where('type', 3)->select(); // foreach ($list as $key=>$val){ // $modeluser->where('id', $val['uid'])->dec('total_active', $val['score']*2)->update(); // } // // return 33; // // 获取团队上面所有uid $str = ''; $list = Db::name('user')->where('pid', 7496093)->field('id,pid')->select()->toArray(); foreach ($list as $key=>$val){ $str = $str . $val['id'].','; } return $str; $model = new UserModel(); return $model->getFansData(7496093); // 7495457 $list = Db::name('user')->whereFindInSet('path', 7495457)->field('id')->select()->toArray(); // $active_arr = [1=>1,2=>1,3=>10,4=>50,5=>100]; $active = 1; $less = 0; foreach ($list as $key=>$val){ $mlist = Db::name('machine_list')->where('uid', $val['id'])->field('mid,state')->select(); foreach ($mlist as $k1=>$v1){ $machine = Db::name('machine')->where('id', $v1['mid'])->find(); if ($v1['state'] == 1){ $active = $active + $machine['add_active']; }else{ $less = $less + $machine['add_active']; } } } return ['active'=>$active, 'less'=>$less]; // 获取团队下面所有uid // $str = ''; // $list = Db::name('user')->where('pid', 7496093)->field('id,pid')->select()->toArray(); // // foreach ($list as $key=>$val){ // $str = $str . $val['id'].','; // } // // return $str; Db::startTrans(); try { $list = Db::name('user')->where('pid', 'in', "7496093,7499553,7493635")->where('status', 0)->field('id,status,performance_me,money_income')->select()->toArray(); foreach ($list as $key=>$val){ Db::name('user')->where('id', $val['id'])->save(['status'=>1]); // if ($val['performance_me'] > 0 || $val['money_income'] > 0){ // Db::name('user')->where('id', $val['id'])->save(['status'=>1]); // }else{ // Db::name('user')->where('id', $val['id'])->save(['status'=>0]); // } } Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 22; $m_user = new UserModel(); return $m_user->getFansData('7496093'); return Db::name('payment')->where('state', 6)->where('pay_at', '>', '2022-05-16 00:00:00')->where('order_type', 4)->sum('total_fee'); // 今日团队新增 return Db::name('user')->where('reg_time', '>', '2022-05-16 00:00:00')->where('is_auth', 1)->count(); if (Db::name('xz_log')->where([['uid', '=', 7493426],['type','=', 3],['create_at','>', sr_getcurtime(time()-86400*3)]])->find()){ return 11; } return 22; die(); incTodayTeamStatic(7500968, 2, '7493267,7493487,7499425'); return 11; // 全网星钻手续费比例星钻分红 // return Db::name('userteam_log')->where('day', sr_getcurtime(strtotime("-1 day"), 'Y-m-d'))->where('type', 2)->field('level,day,num')->select(); // return Db::name('xz_log')->where('uid', 7493727)->where('state', 1)->sum('score'); // die(); // return Db::name('payment')->where('state', 6)->where('creat_at', '>', '2022-05-11 00:00:00')->where('order_type', 4)->sum('total_fee'); // // return urlencode(getWebUrl().'/api/thirdPayClSuccess'); // return AESjiemi('KFM7rNmEprpl7awDjqjJNrZ0P82HeE61L1SDN9tT5EW3NLgXk6ku3Oh8fiBPiWKgy41w\/XH3ss2jBIThLmprFA=='); // return bcmul(10.311933, 100, 0); // // // // return sr_getcurtime(time(), 'Ymd'); // sr_log('aa'); // return 11; // Queue::instance()->log('动态收益执行成功')->do("couponPlanDynamic")->job(CouponPlanJob::class)->push(['7493267,7493426,7493427,7493428,7493429,7493433,7493452,7493974,7495238', 1000, '7503557']); // return 11; // $path = Db::name('user')->where('id', 7498935)->value('path'); // // $arr = explode(',', $path); // return Db::name('user')->where('id','in', $arr)->field('level,id')->select(); // // $list = Db::name('score_log')->where('create_at', '>', '2022-05-09 02:56:43')->where('type', '1')->field('uid, score')->select()->toArray(); // // $arr = []; // foreach ($list as $key=>$value){ // $user = Db::name('user')->where('id', $value['uid'])->field('id,level,path')->find(); // array_push($arr, ['id'=>$value['uid'], 'level'=>$user['level'], 'score'=>$value['score'], '']); // } // return $arr; // // return Db::table('zy_devices_record') //// ->field('username,max(score)') // ->group('udid') // ->having('count(udid)>1') // ->select(); // // return Db::name('devices_record')->group('udid')->having("count(udid)>1")->select(); // return Db::execute('select * from zy_devices_record GROUP BY udid HAVING count(udid) > 1'); // //return Db::query("select * from zy_user where status=0", ['id' => 1]); // // $list = Db::query(""); // return $list; // // return Db::query("select * from zy_devices_record where 1=1 GROUP BY udid HAVING count(udid) > 1"); // edit_user_score(9 , 7493430, 0.65); // edit_user_score(11 , 7493430, 0.65); // return 11; // 总共平台波比 // $muser = new UserModel(); // // $userinfo = $muser->where('id', 7493434)->field('score, id,pid,is_auth,level')->find(); // $piduserinfo = $muser->where('id', $userinfo['pid'])->field('score, id,pid,is_auth,level')->find(); // $user_de = 605; // $pj_score = 0; // // 平级收益 // if ($piduserinfo && $userinfo['level'] > 0){ // if ($userinfo['level'] == $piduserinfo['level']){ // $money = $user_de - 560; // $pj_score = number_format($money * env('coupon.COUPON_PINGJI_SCALE', 0)/100, 4, '.', ''); // } // } // // return $pj_score; // // // // return [ // 'dongtai'=> Db::name('score_log')->where([['type', '=', 11],['create_at', '>','2022-05-07 00:01:18']])->sum('score'), // 'pingji'=> Db::name('score_log')->where([['type', '=', 10],['create_at', '>','2022-05-07 00:01:18']])->sum('score'), // 'zhitui'=> Db::name('score_log')->where([['type', '=', 9],['create_at', '>','2022-05-07 00:01:18']])->sum('score'), // 'jingtai'=> Db::name('score_log')->where([['type', '=', 2],['create_at', '>','2022-05-07 00:01:18']])->sum('score') // ]; // // $list = Db::name('score_log')->where([['type', '=', 2],['create_at', '>','2022-05-07 00:01:18']])->select()->toArray(); // $arr = []; // foreach ($list as $key=>$value){ // $user = Db::name('user')->where('id', $value['uid'])->field('id,level,pid')->find(); // if ($user['level'] > 0){ // $piduser = Db::name('user')->where('id', $user['pid'])->field('id,level,pid')->find(); // if ($piduser['level'] == $user['level']){ // array_push($arr, $value); // } // // } // } // // return $arr; // return AESjiami('hxf250725'); // 今日总充值 return Db::name('payment')->where('state', 6)->where('pay_at', '>', '2022-04-16 00:00:00')->where('order_type', 4)->sum('total_fee'); // return Db::name('payment')->where('state', 6)->where('order_type', 4)->sum('total_fee'); // return Db::name('payment')->where('state', 6)->where('order_type', 2)->sum('total_fee'); // return Db::name('withdraw_log')->where('status', 1)->sum('practical_money'); // // die(); // die(); // ======================================= 查看直推看广告 ============================================ // $list = Db::name('user')->where('pid', 7493477)->where('is_auth', 1)->field('id, mobile')->select(); // $uids = []; // foreach ($list as $key=>$val){ // array_push($uids, $val['id']); // // } // return Db::name('ad_log')->where('type', 2)->whereDay('create_time', 'yesterday')->where('uid', 'in', $uids)->field('create_time')->select(); // return $uids; // ============================================================================================================== // return Db::name('sys_func_log')->where('type', 1)->sum('money'); // return Db::name('user')->where('reg_time', '>', '2022-04-25 00:00:00')->where('reg_time', '<', '2022-04-26 00:00:00')->where('is_auth', 1)->count('id'); // die(); // die(); // return Db::name('payment')->where('state', 6)->where('order_type', 2)->where('pay_at', '<', '2022-04-22 11:45:13')->count('id'); // die(); // return Db::name('devices_record')->field('udid, uid')->group('udid')->select(); // ================ 计算任务包很天增长 ================ $arr = []; // 矿机增长 for ($i=0;$i<9;$i++){ $time = sr_getcurtime(time()-86400*$i, 'Y-m-d'); $count = Db::name('renwu_machine_list')->whereDay('create_time',$time)->where('rid', 9)->count(); $count1 = Db::name('renwu_machine_list')->whereDay('create_time',$time)->where('rid', 10)->count(); $arr[$time] = ['199'=>$count, '399'=>$count1, 'all'=>$count + $count1]; } return json_encode($arr); // ================ 计算任务包很天增长 ================ return Db::name('coupon_plan_log')->where('plan_id', 112)->sum('buy_num'); die(); // ========================================================================================== // ===============计算每一期消费抢购目标金额跟实际买入 $res = []; $list = Db::name('coupon_plan')->where('state', 'in', [1,2])->select()->toArray(); foreach ($list as $key=>$val){ $res[$val['id']] = Db::name('coupon_plan_log')->where('plan_id', $val['id'])->sum('buy_num'); } return $res; // ========================================================================================== // return $request->ip(); // return AESjiemi('537PacNG7epB4QcZklKbHw=='); // return intval(2.34); // 锁定积分 // Db::name('shop_order')->where('status','in', [1, 2])->sum('rebate_lock_score'); // 总积分 Db::name('shop_order')->where('status','in', [1, 2])->sum('rebate_score'); //用户总消费 Db::name('payment')->where('state','in', 6)->where('order_type', 4)->sum('total_fee'); // 199 分红任务包 // 399 分红任务包 // 总提现金额 return Db::name('withdraw_log')->where('status', 1)->sum('practical_money'); die(); return Db::name('payment')->where('state', 6)->where('order_type', 4)->sum('total_fee'); // Db::name('shop_order')->where('status', 'in', [1,2])->update(['ship_code'=>'', 'ship_name'=>'', 'ship_number'=>'', 'status'=>1]); $list = Db::name('shop_order')->select()->toArray(); foreach ($list as $key=>$val){ $uptime = $val['updated_time']; $cutime = $val['created_time']; Db::name('shop_order')->where('order_id', $val['order_id'])->update(['created_time'=>$uptime, 'updated_time'=>$cutime]); } return 11; // $user_model = new UserModel(); // return $list = $user_model->where('is_auth', 1)->field('id,is_auth')->select(); //// foreach () return 11; Db::name('getali_token')->insertGetId([ 'uid'=>33, 'content'=>json_encode(['aa'=>'bb']), 'create_time'=>sr_getcurtime(time()), 'ip'=>$request->ip() ]); return 22; return $count = Db::name('getali_token')->whereDay('create_time', 'today')->where('uid', 33)->count(); die(); $pay_info= Db::name('payment')->where('out_trade_no', 'DLB1649942227721944271609429OP')->find(); sr_testDb(json_encode($pay_info), 1); return 22; $params = [ 'appid'=>'92b8bd950a272d07038c72fdc4ca80f1', 'method'=>'payment.aljsapp', 'merchant'=>'220971127793732674', 'body'=>'购买商品', 'external_order_no'=>'24235256', // 我们自己的订单号 'total_amount'=>'1.5', 'notify_url'=>'http://api.meikangjw.com/api/aliResult' ]; $sign = thirdPayGetSign($params, '9e4089dd079d8f6e3bb9f274825818ad'); $params['sign'] = $sign; // return $params; $res = _curlrequest('http://openpay.duolaibei.com/api/gateway', $params, 'post'); return $res; return AESjiami('abcd123456'); // return encode('888888'); // return decode('123456x544qo83ef'); $ser = new UserServices(); $res = $ser->checkSmsCode('286117', 'register', '18280066008'); // return json_encode($res); return $res?'11':'22'; return $new_login = cryption('888888', 'E', 'zy02022'); return $new_login = cryption('7H+6DCDrGMtrESqhogM', 'D', 'zy02022'); return AESjiami('haohao6752'); $model = new UserModel(); try { $model->getUserDetailByUid('7493267'); }catch (Exception $e){ return api_error_return($e->getMessage()); } return 22; } // 测试redis public function testredis(){ die(); $redis = new \think\cache\driver\Redis(); $redis->connect('127.0.0.1', 6379); $redis->set('Magic','http://shejishi.cc'); echo $redis->get('Magic'); } // 订单退款接口 public function refund(Request $request){ die(); //die(); // list($body, $total_amount, $order_type, $remarks, $trade_type, $pay_way, $voucher_img) = $this->_payConf($uid, $params); // 这是测试 线要干掉 // $total_amount = floatval('0.'.mt_rand(1, 3).mt_rand(1, 9)); // $out_trade_no = 'CL'.rand(1000000000, 9999999999) . (string)date('ymdhis', time()) . (int)microtime(true); // 订单号 $params = [ 'appid'=>'1059174', 'out_trade_no'=>'CL82200455302206141216301655180190' ]; // sr_log(json_encode($params)); $sign = thirdPayGetSignCL('XMLfjHMPOGexsSaadIWSVCNG0XJBClZZ', $params); $params['sign'] = $sign; // return $params; // sr_log(json_encode($params)); $res = _curlrequest('https://api2.payunk.com/index/refund', $params, 'post'); sr_log(sr_getcurtime(time()).$res); $res = json_decode($res); return $res; if ($res && isset($res->code) && $res->code == 200){ // $this->setPaymentOrder(compact('body', 'out_trade_no','total_amount', 'remarks', 'uid', 'trade_type', 'order_type', 'pay_way', 'voucher_img'), 7); return api_succ_return(['msg'=>'请求成功', 'data'=>['thirdpayclwx'=>['url'=>$res->url,'success_url'=>$success_url, 'error_url'=>$error_url]]]); }else{ return api_error_return('获取失败'); } } // 请求商品缓存 public function updateTemple(Request $request){ die(); Db::startTrans(); try { $temp_list = Db::name('shop_buynote')->field('id,content')->select(); $tempsarr = []; foreach ($temp_list as $key=>$val){ $tempsarr[$val['id']] = $val['content']; } $list = Db::name('shop_goods')->field('goods_id,buynote_template_id')->select(); foreach ($list as $key=>$val){ Db::name('shop_goods')->where('goods_id', $val['goods_id'])->save(['buynote_template'=>$tempsarr[$val['buynote_template_id']]]); } Db::commit(); }catch (\Exception $e){ Db::rollback(); return $e->getMessage(); } return 'success'; } }