Auth.php 106 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721
  1. <?php
  2. /**
  3. * @package merchant
  4. *
  5. * @author xaboy
  6. * @day 2020-05-06
  7. *
  8. *
  9. */
  10. namespace app\controller\api;
  11. use AlibabaCloud\Client\AlibabaCloud;
  12. use app\common\dao\store\order\StoreOrderDao;
  13. use app\common\model\user\User;
  14. use app\common\repositories\merchant\order\OrderGzcRepository;
  15. use app\common\repositories\merchant\order\OrderMerchantRepository;
  16. use app\common\repositories\store\order\StoreGroupOrderRepository;
  17. use app\common\repositories\store\order\StoreOrderRepository;
  18. use app\common\repositories\store\order\StoreOrderStatusRepository;
  19. use app\common\repositories\store\order\StoreRefundOrderRepository;
  20. use app\common\repositories\user\UnionUsersRepository;
  21. use app\common\repositories\user\UserRepository;
  22. use app\common\repositories\wechat\RoutineQrcodeRepository;
  23. use app\common\repositories\wechat\WechatUserRepository;
  24. use app\controller\api\user\Volunteer;
  25. use app\controller\api\util\Signature;
  26. use app\models\routine\RoutineQrcode;
  27. use app\traits\GongApiRequest;
  28. use app\traits\GzcApiRequest;
  29. use app\traits\HaikeApiRequest;
  30. use app\traits\HuiPay;
  31. use app\validate\api\UserAuthValidate;
  32. use Carbon\Carbon;
  33. use crmeb\basic\BaseController;
  34. use crmeb\services\AliYunSmsService;
  35. use crmeb\services\MiniProgramService;
  36. use crmeb\services\WechatService;
  37. use crmeb\services\YunxinSmsService;
  38. use applet\WXBizDataCrypt;
  39. use Gregwar\Captcha\CaptchaBuilder;
  40. use Gregwar\Captcha\PhraseBuilder;
  41. use PhpOffice\PhpSpreadsheet\IOFactory;
  42. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  43. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  44. use Symfony\Component\HttpFoundation\Request;
  45. use think\App;
  46. use think\db\exception\DataNotFoundException;
  47. use think\db\exception\DbException;
  48. use think\db\exception\ModelNotFoundException;
  49. use think\Exception;
  50. use think\exception\HttpResponseException;
  51. use think\facade\Cache;
  52. use think\facade\Db;
  53. use think\facade\Log;
  54. use think\Filesystem;
  55. /**
  56. * Class Auth
  57. * @package app\controller\api
  58. * @author xaboy
  59. * @day 2020-05-06
  60. */
  61. class Auth extends BaseController
  62. {
  63. use HaikeApiRequest;
  64. use HuiPay;
  65. protected $merId;
  66. protected $source;
  67. public function __construct(App $app)
  68. {
  69. parent::__construct($app);
  70. $this->source = $this->request->header('source');
  71. $this->merId = $this->request->header('merId');
  72. }
  73. /**
  74. * 计算国盛小程序市场管理分红
  75. */
  76. public function gscm($mer_id=1){
  77. // $enterprise=Db::name('enterprise')->where('type',1)->select();
  78. $enterprise=Db::name('enterprise')->where('mer_id',$mer_id)->where('type',1)->find();
  79. if(!$enterprise){
  80. return false;
  81. }
  82. $reward[6]=Db::name('enterprise_user')->where('mer_id',$mer_id)->where('identity',6)->column('uid');
  83. $reward[5]=Db::name('enterprise_user')->where('mer_id',$mer_id)->where('identity',5)->column('uid');
  84. $reward[4]=Db::name('enterprise_user')->where('mer_id',$mer_id)->where('identity',4)->column('uid');
  85. $reward[3]=Db::name('enterprise_user')->where('mer_id',$mer_id)->where('identity',3)->column('uid');
  86. $reward[2]=Db::name('enterprise_user')->where('mer_id',$mer_id)->where('identity',2)->column('uid');
  87. $reward[1]=Db::name('enterprise_user')->where('mer_id',$mer_id)->where('identity',1)->column('uid');
  88. // $uids = array_merge($reward[6],$reward[5],$reward[4],$reward[3],$reward[2],$reward[1]);
  89. $uids_money=[];
  90. $enterprise_money=Db::name('enterprise_bill')->where('mer_id',$mer_id)->sum('money');
  91. $amoney=$enterprise_money*0.05;
  92. $divvy=decimal2($amoney*0.3);//平均分红
  93. $jiaquan_divvy=$amoney-$divvy;//加权分红
  94. //平均分红金额不足每人0.01 就不分了
  95. if($divvy > 0 || decimal2($divvy/(count($reward[6])*6+count($reward[5])*5+count($reward[4])*4+count($reward[3])*3+count($reward[2])*2+count($reward[1]))) > 0 ){
  96. //0-普通用户 1-微店 2-云店 3-旗舰店 4-消费合伙人 5-创业合伙人 6-股东合伙人
  97. for ($i=6;$i>0;$i--) {
  98. if ($i == 6) {
  99. $mergedArray = $reward[6];
  100. }elseif($i==5){
  101. $mergedArray = array_merge($reward[6],$reward[5]);
  102. }elseif($i==4){
  103. $mergedArray = array_merge($reward[6],$reward[5],$reward[4]);
  104. }elseif($i==3){
  105. $mergedArray = array_merge($reward[6],$reward[5],$reward[4],$reward[3]);
  106. }elseif($i==2){
  107. $mergedArray = array_merge($reward[6],$reward[5],$reward[4],$reward[3],$reward[2]);
  108. }else{
  109. $mergedArray = array_merge($reward[6],$reward[5],$reward[4],$reward[3],$reward[2],$reward[1]);
  110. }
  111. $fenhong=decimal2($divvy/count($mergedArray));
  112. foreach ($mergedArray as $v){
  113. if(!isset($uids_money[$v])){
  114. $uids_money[$v]=$fenhong;
  115. }else{
  116. $uids_money[$v]+=$fenhong;
  117. }
  118. }
  119. }
  120. dump($uids_money);
  121. }
  122. }
  123. function jisuantuandui($where,$data=[]){
  124. $enterprise_user_team=DB::name('enterprise_user')->where($where)->column('uid');
  125. $arr=array_merge($data,$enterprise_user_team);
  126. foreach ($enterprise_user_team as $v){
  127. $where['node_uid']=$v;
  128. $arr=$this->jisuantuandui($where,$arr);
  129. }
  130. return $arr;
  131. }
  132. public function importExcel()
  133. {
  134. $file = request()->file('file');
  135. // 创建一个新的Excel读取器对象
  136. $objReader = \PHPExcel_IOFactory::createReader('Excel2007');
  137. $objPHPExcel = $objReader->load($file);
  138. // 选择活动工作表
  139. $objPHPExcel->setActiveSheetIndex(0);
  140. $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
  141. // 循环遍历行和列
  142. $yonghu=[];
  143. foreach ($sheetData as $k=>$row) {
  144. if($k==1){
  145. continue;
  146. }
  147. if($row['A'] && $row['A']!=NULL && $row['A']!=''){
  148. $yonghu[]=array('a'=>$row['A'],'b'=>$row['B']);
  149. }
  150. }
  151. $repository = app()->make(UserRepository::class);
  152. foreach ($yonghu as $k=>$v){
  153. $user = $repository->accountByUser($v['a']);
  154. if ($user){
  155. // return app('json')->fail('手机号已存在');
  156. $yonghu[$k]['user'] = $user;
  157. }else{
  158. $yonghu[$k]['user'] = $repository->registr($v['a'],'A123456','APP',0);
  159. }
  160. }
  161. foreach ($yonghu as $v){
  162. $user=$v['user'];
  163. if($v['b'] && $v['b']!=null && $v['b']!=''){
  164. $pid=Db::name('user')->where('account',$v['b'])->value('uid');
  165. if($pid){
  166. $repository->bindSpread($user, intval($pid));
  167. }
  168. }
  169. }
  170. }
  171. public function test()
  172. {
  173. $this->importExcel();
  174. echo '导入成功';
  175. die;
  176. $storeOrderRepository = app()->make(StoreOrderRepository::class);
  177. // $storeOrderRepository->yihuchashengji();//一壶茶身份升级
  178. // $storeOrderRepository->yunyingjiangli();//运营中心奖励
  179. // $storeOrderRepository->yihuchafenxiang();//一壶茶分红逻辑memberSettings
  180. // $this->jinjian();die;
  181. var_dump(11);
  182. die;
  183. $order_id = (int)$this->request->param('id');
  184. $order=Db::name('store_order')->find($order_id);
  185. if(!$order){
  186. return '订单不存在';
  187. }
  188. //在rrx_store_order_product 表中查到product_id ,在rrx_store_product 查spu_id 在rrx_douhuomall表中查goods_id
  189. $out_order_no=$order['douhuomall_order_no'];
  190. $after_type='1';//1=未收货退款,2=退货退款,3=换货补发,4=不退货仅退款
  191. $explain='测试退货';
  192. $can_after_data=GongApiRequest::is_can_after( $out_order_no);
  193. dump($can_after_data);
  194. if(isset($can_after_data['result']['order_goods'])){
  195. foreach ($can_after_data['result']['order_goods'] as $v){
  196. $order_goods_id=$v['order_goods_id'];
  197. $after_num=$v['after_num'];
  198. $res=GongApiRequest::apply_after_sales( $order_goods_id,$out_order_no, $after_type, $explain, $after_num);
  199. dump($res);
  200. }
  201. }
  202. //
  203. // $storeGroupOrderRepository = app()->make(StoreGroupOrderRepository::class);
  204. // $res=$storeGroupOrderRepository->ProductOutCancel(6105);
  205. // $res = GongApiRequest::order_details('wx1698916402673749101');
  206. $res2=GongApiRequest::after_status_new($out_order_no);
  207. dump($res2);
  208. // dump($repository->getBangFu(9640));
  209. // dump($userRepository -> getCountUId(18));
  210. // echo '开发者测试';
  211. // echo systemConfig("pay_wx");
  212. // $res = [
  213. // "completeDateTime"=>"2022-05-31 14:27:09",
  214. // "remark"=>"1",
  215. // "orderAmount"=>"100",
  216. // "merchantId"=>"899104033",
  217. // "requestId"=>"wx1653980751822534740_5366",
  218. // "hmac"=>"yivznJKbCfPpnXpwsalGDz7tnRyjr9pqbeVSkVKZ5VvtnJqn4helUkGC+S2tsaF8oknwvN\/ZeoDcgtRPqT1uanOWyalSFip6qxkBDkbc\/sJBVMCR2vzp38+YEHbusuxH1O9D696bt\/PSuhFjItD9pFi+Qteha1zN8X4oxpWFEob4wOVcFnMHLkgehNoWy1NRqjz+RmD6osAzJrIS27RJmUaqt83e0ejcjfEzAEw74rq4Yafyx9PohjvF35iwVLCpOcdyxVsfuJ4D59ayqsgUs0\/80GMRvNkgXrO6bsN7m1t6PLSQgPkD6ruEX\/i4l4uhrpHLvnpc4wl9YsGS1k4SrQ==",
  219. // "clearingOrg"=>"UNION_PAY",
  220. // "totalRefundCount"=>"0",
  221. // "serialNumber"=>"ddd",
  222. // "realBankSerialNumber"=>"4200001429202205315964134213",
  223. // "orderCurrency"=>"CNY",
  224. // "realBankRequestNumber"=>"1531522625975881728N",
  225. // "totalRefundAmount"=>"0",
  226. // "paymentModeAlias"=>"MINIAPPS_WEIXIN_PAY",
  227. // "status"=>"SUCCESS"
  228. // ];
  229. // $requestId = [];
  230. // if(strpos($res['requestId'],'_') !== false){
  231. // $requestId = explode("_",$res['requestId']);
  232. // }
  233. // if($res['status'] == 'SUCCESS'){
  234. // Db::name('store_group_order') -> where('group_order_sn',$requestId[0]) -> update(['rand'=>$requestId[1],'serialNumber'=>$res['serialNumber']]);
  235. // $pay_type = $res['paymentModeAlias'] == 'MINIAPPS_WEIXIN_PAY' ? 1 : 4;
  236. // event('pay_success_order', ['order_sn' => $requestId[0],'pay_type'=>$pay_type]);
  237. // }
  238. // Db::name('test') -> insert(['date'=>date('Y-m-d H:i:s')]);
  239. // try {
  240. // $merch_no = $this->request->param('merch_no');
  241. // $mer_name = $this->request->param('mer_name');
  242. // $mer_short_name = $this->request->param('mer_short_name');
  243. // $response = $this->merchantModify(['merch_no' => $merch_no,'mer_name' => $mer_name, 'mer_short_name' => $mer_short_name,'agent_apply_no' => (string)time()]);
  244. // return app('json')->success($response);
  245. // } catch (\Throwable $e) {
  246. // return app('json')->fail($e->getMessage());
  247. // }
  248. }
  249. //商户进件
  250. private function jinjian(){
  251. // $returndata=[
  252. // 'request_id'=>time().rand(111111,999999),
  253. // 'usr_phone'=>'15732652759',
  254. // 'cont_name'=>'吴国珍',
  255. // 'cont_phone'=>'13911251783',
  256. // 'customer_email'=>'312009092@qq.com',
  257. // 'mer_name'=>'北京天地博爱科技有限公司',
  258. // 'mer_short_name'=>'天地博爱科技',
  259. // 'reg_addr'=>'北京市北京经济技术开发区科创十三街31号院二区14号楼9层901-3(北京自贸试验区高端产业片区亦庄组团)',
  260. // 'cust_addr'=>'北京市北京经济技术开发区科创十三街31号院二区14号楼9层901-3(北京自贸试验区高端产业片区亦庄组团)',
  261. // 'cust_tel'=>'010-53327000',
  262. // 'legal_name'=>'吴国珍',
  263. // 'legal_type'=>0,
  264. // 'legal_idno'=>'321123196710192020',
  265. // 'legal_mp'=>'13911251783',
  266. // 'legal_start_cert_id_expires'=>'20061129',
  267. // 'legal_id_expires'=>'20261129',
  268. // 'card_id_mask'=>'629966688',
  269. // 'card_name'=>'北京天地博爱科技有限公司',
  270. // 'bank_acct_type'=>'1',
  271. // 'bank_code'=>'03050000',
  272. // 'prov_code'=>'0011',//省份编码 (省市编码),
  273. // 'area_code'=>'1100',//地区编码 (省市编码)
  274. // 'license_code'=>'91110105697724649E',
  275. // 'mer_valid_date'=>'20291118',
  276. // 'mer_start_valid_date'=>'20091119',
  277. // 'entry_mer_type'=>'1',
  278. // 'rsa_public_key'=>'MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCxTpMESsdhyjKQC+y1G++eXCEu5pXqK7fvkZJdubSTCQn/RM3soOMcCwTekULCxEUwM0SnPxFLcZuP/a8w87zWeAXoBCPJl1gVK4KZ+3tWq/BJPCET3Vy66M7pXfXL+ekd8gf2LWtEfpJoAn59guVfsbTOp44ppDkrb3SuXDcKhQIDAQAB'
  279. // ];
  280. $returndata=[
  281. 'request_id'=>time().rand(111111,999999),
  282. 'usr_phone'=>'13911251783',//注册手机号
  283. 'cont_name'=>'陈立军',//联系人姓名
  284. 'cont_phone'=>'13911251783',//联系人手机号码
  285. 'customer_email'=>'312009092@qq.com',//电子邮箱
  286. 'mer_name'=>'河北省一壶茶电子商务有限公司',//商户名称
  287. 'mer_short_name'=>'一壶茶电子商务',//商户简称 商户简称,长度为10个中文
  288. 'reg_addr'=>'河北省秦皇岛市经济技术开发区华山中路8号银通大厦',//注册地址
  289. 'cust_addr'=>'河北省秦皇岛市经济技术开发区华山中路8号银通大厦',//经营地址
  290. 'cust_tel'=>'010-53327000',//商户电话
  291. 'legal_name'=>'陈立军',//法人/负责人 姓名
  292. 'legal_type'=>0,//法人/负责人证件号码
  293. 'legal_idno'=>'130302196709281432',//法人/负责人证件号码
  294. 'legal_mp'=>'13911251783',//法人/负责人手机号
  295. 'legal_start_cert_id_expires'=>'20230310',//法人/负责人身份证有效期(始),格式 YYYYMMDD
  296. 'legal_id_expires'=>'20991231',//法人/负责人身份证有效期(至),格式 YYYYMMDD
  297. 'card_id_mask'=>'13050163560800002447',//结算银行卡号
  298. 'card_name'=>'河北省一壶茶电子商务有限公司',//结算银行卡开户姓名
  299. 'bank_acct_type'=>'1',//结算银行账户类型,1 : 对公, 2 : 对私。小微只能是对私
  300. 'bank_code'=>'01050000',//结算银行卡所属银行code
  301. 'prov_code'=>'0013',//结算银行卡省份编码,
  302. 'area_code'=>'1308',//结算银行卡省份编码
  303. 'license_code'=>'91130301MAD48PT00A',//营业执照编码
  304. 'mer_valid_date'=>'20991231',//商户有效日期(至),格式 YYYYMMDD(若为长期有效,固定为“20991231”;若开户企业类商户,必填)
  305. 'mer_start_valid_date'=>'20231107',//商户有效日期(至),格式 YYYYMMDD(若为长期有效,固定为“20991231”;若开户企业类商户,必填)
  306. 'entry_mer_type'=>'1',//商户类型:1-企业;2-小微。默认为企业
  307. 'rsa_public_key'=>'MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCxTpMESsdhyjKQC+y1G++eXCEu5pXqK7fvkZJdubSTCQn/RM3soOMcCwTekULCxEUwM0SnPxFLcZuP/a8w87zWeAXoBCPJl1gVK4KZ+3tWq/BJPCET3Vy66M7pXfXL+ekd8gf2LWtEfpJoAn59guVfsbTOp44ppDkrb3SuXDcKhQIDAQAB'
  308. ];
  309. dump($returndata);
  310. $arr= $this->incoming_parts($returndata,'config');
  311. dump($arr);die;
  312. }
  313. /**
  314. * 业绩奖-服务中心分红-发放
  315. * @return mixed
  316. */
  317. public function yihuchafenxiang(){
  318. $storeOrderRepository = app()->make(StoreOrderRepository::class);
  319. $storeOrderRepository->yihuchafenxiang();
  320. $storeOrderRepository->yunyingjiangli();
  321. return app('json')->success('业绩奖-服务中心分红-运营中心-发放完成');
  322. }
  323. /**
  324. * 一壶茶身份升级
  325. * @return mixed
  326. */
  327. public function yihuchashengji(){
  328. $storeOrderRepository = app()->make(StoreOrderRepository::class);
  329. $storeOrderRepository->yihuchashengji();
  330. return app('json')->success('一壶茶身份升级-完成');
  331. }
  332. public function shareImgesList(){
  333. $where['mer_id']=$this->merId;
  334. $where['status']=0;
  335. $classify=$this->request->param('classify',0);
  336. if($classify){
  337. $where['classify']=$classify;
  338. }
  339. $pageNum=$this->request->param('pageNum',1);
  340. $limit=$this->request->param('pageSize',10);
  341. $type=$this->request->param('type',0);
  342. if($type){
  343. $where['type']=$type;
  344. }
  345. $data['pageInfo']['list']=Db::name('share_posters')->where($where)->page($pageNum,$limit)->order('sort desc,id desc')->select();
  346. $data['pageInfo']['total']=Db::name('share_posters')->where($where)->count();
  347. return app('json')->success($data);
  348. }
  349. public function classifyList(){
  350. $data=Db::name('share_posters_classify')->field('id,name')->where('mer_id',$this->merId)->where('is_del',0)->order('sort desc,id desc')->select();
  351. return app('json')->success($data);
  352. }
  353. public function agreement_detail(){
  354. $type = $this->request->param('type',1);
  355. // $where['mer_id']=$this->merId;
  356. $where['type']=$type;
  357. $data=Db::name('enterprise_agreement')->where($where)->find();
  358. if(!$data){
  359. $data['title']='';
  360. $data['content']='';
  361. }
  362. return app('json')->success($data);
  363. }
  364. public function agreement(){
  365. $type = $this->request->param('type',1);
  366. // $where['mer_id']=$this->merId;
  367. $where['type']=$type;
  368. $data=Db::name('enterprise_agreement')->where($where)->find();
  369. if(!$data){
  370. $data['title']='';
  371. $data['content']='';
  372. }
  373. $html='<!DOCTYPE html>
  374. <html lang="en">
  375. <head>
  376. <meta charset="UTF-8">
  377. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  378. <title>'.$data['title'].'</title>
  379. <style>
  380. body {
  381. font-family: Arial, sans-serif;
  382. margin: 0;
  383. padding: 0;
  384. }
  385. .container {
  386. margin: 0 auto;
  387. padding: 20px;
  388. }
  389. </style>
  390. </head>
  391. <body>
  392. <div class="container">
  393. '.$data['content'].'
  394. </div>
  395. </body>
  396. </html';
  397. return $html;
  398. }
  399. /**
  400. * @param UserRepository $repository
  401. * @return mixed
  402. * @throws DbException
  403. * @author xaboy
  404. * @day 2020/6/1
  405. */
  406. public function login(UserRepository $repository)
  407. {
  408. $account = $this->request->param('phone');
  409. if (!$account)
  410. return app('json')->fail('请输入账号');
  411. $user = $repository->accountByUser($this->request->param('phone'));
  412. //13231658486 周总
  413. if($account != 15528079265){
  414. if (!$user)
  415. return app('json')->fail('账号或密码错误');
  416. if (!password_verify($pwd = (string)$this->request->param('password'), $user['pwd']))
  417. return app('json')->fail('账号或密码错误');
  418. $type = $this->request->param('type',0);
  419. if ($type==2){
  420. if ($user["identity"]==0||$user["identity"]==4||$user["identity"]==5){
  421. return app('json')->fail('账号或密码错误');
  422. }
  423. }
  424. }
  425. $user = $repository->mainUser($user);
  426. $pid = $this->request->param('spread', 0);
  427. $repository->bindSpread($user, intval($pid));
  428. $tokenInfo = $repository->createToken($user);
  429. $repository->loginAfter($user);
  430. return app('json')->success($repository->returnToken($user, $tokenInfo));
  431. }
  432. /**
  433. * 手机号注册
  434. * @param UserRepository $repository
  435. * @return mixed
  436. * @throws DbException
  437. * @author xaboy
  438. * @day 2020/6/1
  439. */
  440. public function register(UserAuthValidate $validate, UserRepository $repository)
  441. {
  442. // $repository->insterUser(16328, 14395);
  443. // return "=====";
  444. $data = $this->request->params(['phone', 'sms_code', 'spread', 'password',"spread_phone","type","mer_id"]);
  445. $type=$data['type']??'';
  446. unset($data['type']);
  447. $validate->sceneSmslogin()->check($data);
  448. $domain = $this->request->domain();
  449. if($data['sms_code'] == '9527' && strpos($domain, 'test.hebeiyhc.com') !== false) {
  450. // 域名中包含 "test.hebeiyhc.com'" 字符串
  451. }else if (!$this->checkSmsCode($data['phone'], $data['sms_code']) ){
  452. return app('json')->fail('验证码不正确');
  453. }
  454. $user = $repository->accountByUser($data['phone']);
  455. if ($user)
  456. return app('json')->fail('手机号已存在');
  457. if ($data["spread_phone"]){
  458. $spread_user = $repository->accountByUser($data['spread_phone']);
  459. if ($spread_user ){
  460. $data['spread']=$spread_user["uid"];
  461. }else{
  462. return app('json')->fail('推荐人手机号填写错误');
  463. }
  464. }
  465. // Log::info($data);
  466. $user = $repository->registr($data['phone'], $data['password'],'APP',"","",1,$data['spread']);
  467. // $repository->registr($data['phone'], $data['password'],'APP',$data['spread']);
  468. $repository->addagent($user);
  469. $user = $repository->mainUser($user);
  470. $repository->bindSpread($user, intval($data['spread']));
  471. // $repository->spread_log($user, intval($data['spread']));
  472. $tokenInfo = $repository->createToken($user);
  473. $repository->loginAfter($user);
  474. //type==2 事业二部注册并绑定推荐关系
  475. // if($type==2){
  476. // $mer_data=Db::name('merchant')->where('mer_id',$data['mer_id'])->value('merchant_type');
  477. // if($mer_data==2){
  478. // try {
  479. // $eb_user=Db::name('user')->where('account',$data['phone'])->find();
  480. //// Db::name('log')->insert(['data'=>'推荐人ID'.$eb_user['spread_uid']]);
  481. // $users = app()->make(\app\controller\api\entropybarter\User::class);
  482. // $users->bangding($eb_user['uid'],$eb_user['spread_uid'],276);
  483. // $users->bangding($eb_user['uid'],$eb_user['spread_uid'],236);
  484. // }catch (Exception $exception){
  485. // Db::name("log")->insert(array('data'=>$exception->getFile().':'.$exception->getLine().'【'.$exception->getMessage().'】'));//日志记录
  486. // }
  487. // }
  488. // }
  489. if ($type == "marketing"){
  490. $spread = Db::name("User") -> alias("u") -> leftjoin("MarketingUser mu","u.uid = mu.uid") -> where("u.uid",$data['spread']) -> field("u.uid,mu.spread_list") -> find();
  491. $spread_list = explode(',',$spread['spread_list']);
  492. if (!empty($spread_list)){
  493. $spread_list[] = "[" . $spread['uid'] . "]";
  494. }else{
  495. array_push($spread_list,"[".$spread['uid']."]");
  496. }
  497. $spread_list = array_filter($spread_list);
  498. $data = [
  499. "uid" => $user->uid,
  500. "spread_uid" => $spread['uid'],
  501. "spread_list" => implode(",",$spread_list)
  502. ];
  503. Db::name("MarketingUser") -> insert($data);
  504. }
  505. return app('json')->success($repository->returnToken($user, $tokenInfo));
  506. }
  507. /**
  508. * 手机号找回密码
  509. * @param UserRepository $repository
  510. * @return mixed
  511. * @throws DbException
  512. * @author xaboy
  513. * @day 2020/6/1
  514. */
  515. public function reset(UserAuthValidate $validate, UserRepository $repository){
  516. $data = $this->request->params(['account', 'captcha', 'code', 'password']);
  517. $data['phone'] = $data['account'];
  518. $data['sms_code'] = $data['captcha'];
  519. $validate->sceneSmslogin()->check($data);
  520. if (!$this->checkSmsCode($data['account'], $data['captcha']))
  521. return app('json')->fail('验证码不正确');
  522. $user = $repository->accountByUser($data['account']);
  523. if ($user){
  524. $res = $repository->resetPassword($data['account'], $data['password'], $user['uid']);
  525. if($res){
  526. return app('json')->success('重置成功');
  527. }
  528. }
  529. return app('json')->error('重置失败');
  530. }
  531. /**
  532. * 旧密码找回密码
  533. * @param UserRepository $repository
  534. * @return mixed
  535. * @throws DbException
  536. * @author xaboy
  537. * @day 2021/1/21
  538. */
  539. public function oldreset(UserRepository $repository){
  540. $user = $this->request->userInfo()
  541. ->hidden(['label_id', 'group_id', 'card_id', 'last_time', 'last_ip', 'status', 'spread_uid', 'spread_time', 'real_name', 'brokerage_price']);
  542. $user->append(['account','pwd','phone',"uid"]);
  543. $user=$user->toArray();
  544. // $user = $this->request->userInfo()->hidden(['account','pwd','phone',"uid"]);
  545. // $user=$this->request->userInfo();
  546. $data = $this->request->params(['passwordold', 'password']);
  547. if (!$user)
  548. return app('json')->fail('密码错误');
  549. if (!password_verify($pwd = (string)$data["passwordold"], $user['pwd']))
  550. return app('json')->fail('密码错误1');
  551. // UserRepository $repository
  552. $user = $repository->accountByUser($user['account']);
  553. if ($user){
  554. $res = $repository->resetPassword($user['account'], $data['password'], $user['uid']);
  555. if($res){
  556. return app('json')->success('重置成功');
  557. }
  558. }
  559. return app('json')->error('重置失败');
  560. }
  561. /*手机号验证
  562. * @author cabbage
  563. * */
  564. public function checkAccount(UserAuthValidate $validate, UserRepository $repository){
  565. $data = $this->request->params(['account', 'captcha']);
  566. $data['phone'] = $data['account'];
  567. $data['sms_code'] = $data['captcha'];
  568. $validate->sceneSmslogin()->check($data);
  569. if (!$this->checkSmsCode($data['account'], $data['captcha']))
  570. return app('json')->fail('验证码不正确');
  571. $user = $repository->accountByUser($data['account']);
  572. if ($user) {
  573. return app('json')->success('验证成功');
  574. }else{
  575. return app('json')->error('旧手机验证失败');
  576. }
  577. }
  578. /**
  579. * 更换手机号
  580. * @param UserRepository $repository
  581. * @return mixed
  582. * @throws DbException
  583. * @author cabbage
  584. */
  585. public function changeAccount(UserAuthValidate $validate,UserRepository $repository){
  586. $data = $this->request->params(['account', 'new_account','captcha']);
  587. $data['phone'] = $data['new_account'];
  588. $data['sms_code'] = $data['captcha'];
  589. $validate->sceneSmslogin()->check($data);
  590. if (!$this->checkSmsCode($data['new_account'], $data['captcha']))
  591. return app('json')->fail('验证码不正确');
  592. $user = $repository->accountByUser($data['account']);
  593. if ($user){
  594. $res = $repository->resetAccount($data['new_account'],$user['uid'],$user['identity']);
  595. if($res){
  596. return app('json')->success('重置成功');
  597. }
  598. }
  599. return app('json')->error('重置失败');
  600. }
  601. /**
  602. * 获取用户信息
  603. * @return mixed
  604. * @author xaboy
  605. * @day 2020/6/1
  606. */
  607. public function userInfo()
  608. {
  609. $user = $this->request->userInfo()
  610. ->hidden(['account','label_id', 'group_id', 'pwd', 'card_id', 'last_time', 'last_ip', 'status', 'spread_time', 'real_name']);
  611. $user->append(['service', 'user_group','total_consume', 'total_collect_product', 'total_collect_store', 'total_coupon', 'total_visit_product', 'total_unread']);
  612. $data=$user->toArray();
  613. $is_merchant=Db::name("merchant_intention")->where(["uid"=>$user["uid"],"is_branch"=>0])->order("mer_intention_id desc")->value("status");
  614. $data["is_merchant"]=$is_merchant===0||$is_merchant>0?$is_merchant:-1;
  615. $data['phone1'] =substr($data['phone'], 0, 3) . '****' . substr($data['phone'], 7, 4);
  616. $data['longtime'] = intval((time()- strtotime($data['create_time'])) / 86400);
  617. $is_ertification=Db::name("user_certification")->where("uid",$user["uid"])->value("status");
  618. $data["is_ertification"]=$is_ertification>0||$is_ertification===0?$is_ertification:-1;
  619. $mer_staff=Db::name("store_staff")->where(["uid"=>$user["uid"]])->value("department");
  620. $data["is_mer_staff"]=$mer_staff?explode(",",$mer_staff):0;
  621. $volunteer = Db::name("volunteer") -> where(["uid"=>$user["uid"]]) -> value("grade");
  622. $data['volunteer'] = $volunteer ?? 0;
  623. if($data['avatar']=='https://cdn.bjtdba.com/chuxubao/static/assets/yhc_default_avatar.png'){
  624. $data['avatar']=Db::name('user_account')->where('type',1)->where('uid',$data['uid'])->value('avater');
  625. if(empty($data['avatar'])){
  626. $data['avatar']=Db::name('user_account')->where('type',2)->where('uid',$data['uid'])->value('avater');
  627. if(empty($data['avatar'])){
  628. $data['avatar']='https://cdn.bjtdba.com/chuxubao/static/assets/yhc_default_avatar.png';
  629. }
  630. }
  631. }
  632. //养老金展示
  633. // $data['annuity'] = Db::name('user_bill') -> where('uid',$user['uid']) -> where('commission_type',5) -> where('status',1) -> sum('number');
  634. $a = Db::name('user_bill') -> where('uid',$user['uid']) -> where('commission_type',5) -> where('status',0) -> sum('number');
  635. $b = Db::name('user_bill') -> where('uid',$user['uid']) -> where('commission_type',5) -> where('status',1) -> sum('number');
  636. $data['annuity'] = $a +$b;
  637. //上级身份是否大仓会员
  638. $is_da_cang_vip=Db::name('da_cang_user')->where('status',1)->where('uid',$user["uid"])->find();
  639. //渠道商
  640. $is_channel = Db::name('channel_user') -> where('uid',$user["uid"])->where('status',1)->find();
  641. //红积分
  642. $red = Db::name('user_rich') -> where('uid',$user['uid'])->value('red');
  643. $data['is_da_cang_vip'] = 0;
  644. $data['is_channel'] = 0;
  645. $data['red'] = 0;
  646. if($is_da_cang_vip){
  647. $data['is_da_cang_vip'] = $is_da_cang_vip['type'];
  648. }
  649. if($is_channel){
  650. $data['is_channel'] = 1;
  651. }
  652. if ($red){
  653. $data['red'] = $red;
  654. }
  655. $aa = Db::name('user') -> where('uid',$user['uid'])->find();//查询用户个人数据
  656. $teamsnums = $this->getteamsnum($user['uid']);
  657. //$team_userinfo_old_jbp1 = $this->getPerformance($teamid);//获取旧表总大小部门人数
  658. //$data['team_number'] = $this->getBreak($user['uid']);//获取新表大小部门总人数
  659. $data['team_number'] = $teamsnums;
  660. $data['is_bangfu'] = Db::name('user_bangfu') -> where('uid',$user["uid"])->value('status')==1;
  661. // $data['area_manage'] = Db::name('area_manage')->field('type,code_list')->where('uid',$user["uid"])->find();
  662. // if($data['area_manage']){
  663. // $area_manage = Db::name('regions')->field('type,code_list')->where('id','in',$data['area_manage']['code_list'])->cache('code1:'.$data['area_manage']['code_list'],7200)->column('name,id');
  664. // if($area_manage){
  665. // $area_manage = array_column($area_manage,'name','id');
  666. // $code_list = explode(',',$data['area_manage']['code_list']);
  667. // $data['area_manage']['area_name'] = count($code_list) == 2 ? [$area_manage[$code_list[0]], $area_manage[$code_list[1]]] : [$area_manage[$code_list[0]], $area_manage[$code_list[1]], $area_manage[$code_list[2]]];
  668. // }
  669. // }
  670. $user_rich=Db::name('user_rich')->where('uid', $user['uid'])->field('type,stockholder,is_huitian')->find();
  671. $data['user_rich_type']= (isset($user_rich) )?$user_rich['type']:0;
  672. $data['stockholder']= (isset($user_rich) )?$user_rich['stockholder']:0;
  673. // $area_manage_type=Db::name('area_manage')->where('uid', $user["uid"])->value('type');
  674. //类型 district-区/县代 city-市代',
  675. // $data['area_manage_type']=$area_manage_type??'';
  676. // $data['member_brokerage_price']=set_price_rtrim($data['member_brokerage_price']);
  677. //积分
  678. $data['score']=set_price_rtrim($data['score']);
  679. //2025新增 贡献值,红包,京东,vr,复购金
  680. $date['contribute']=set_price_rtrim($data['contribute']);//贡献值
  681. $data['repurchase_price']=set_price_rtrim($data['repurchase_price']);//复购余额
  682. $data['jingdou']=set_price_rtrim($data['jingdou']);//京豆
  683. $data['vr']=set_price_rtrim($data['vr']);//购物金
  684. $data['hongbao']=set_price_rtrim($data['hongbao']);//红包
  685. $data['fugou']=set_price_rtrim($data['fugou']);//复购金
  686. $data['brokerage_price']=set_price_rtrim($data['brokerage_price']);//养老金
  687. $data['annuity'] = set_price_rtrim($data['annuity']);//养老金
  688. $a = Db::name('user_bill') -> where('uid',$user['uid']) -> where('commission_type',3) -> where('status',0) -> sum('number');
  689. $b = Db::name('user_bill') -> where('uid',$user['uid']) -> where('commission_type',3) -> where('status',1) -> sum('number');
  690. // $data['brokerage_price'] = $a +$b;
  691. $data['brokerage_price'] = $aa['brokerage_price'];
  692. $data['isOld']=($data['is_old']);//
  693. $data['exchange']=0;
  694. $data['withdraw']=0;
  695. $data['user_group']=set_price_rtrim($data['user_group']);
  696. if($this->source=='yhc'){
  697. $data['avatar']=Db::name('enterprise_user')->where('mer_id',$this->merId)->where('uid',$user['uid'])->value('avatar');
  698. $data['exchange']=Db::name('enterprise_user')->where('mer_id',$this->merId)->where('uid',$user['uid'])->value('exchange');
  699. //withdraw 是否可以提现 0-可以 1-禁止
  700. $data['withdraw']=Db::name('enterprise_user')->where('mer_id',$this->merId)->where('uid',$user['uid'])->value('withdraw');
  701. }
  702. //普通用户,根据我的贡献值升级(个人消费贡献值+直推的消费产生的贡献值)
  703. $my_con = [];
  704. if($aa['user_group'] < 2){
  705. $my_con = [2,3];
  706. }else if($aa['user_group'] == 2){
  707. $my_con = [3];
  708. }
  709. $data['con_level'] = [
  710. 'my_con' => $aa['contribute'],//我的贡献值
  711. 'my_recon_con' => $aa['per_contribute'],//我推荐的贡献值
  712. 'curr_level' => $aa['user_group'],//当前用户级别身份
  713. 'change_level' => $my_con //可选的等级身份(业务员、业务经理)
  714. ];
  715. return app('json')->success($data );
  716. }
  717. public function updateUserCon(){
  718. $data = $this->request->params(['change_level','uid']);
  719. $uid = $data['uid'];
  720. if(empty($uid)){
  721. return app('json')->fail('找不到该用户!');
  722. }
  723. // $user = $this->request->userInfo();
  724. //var_dump($data);
  725. //var_dump($user);
  726. $aa = Db::name('user') -> where('uid',$uid)->find();//查询用户个人数据
  727. if(empty($aa)){
  728. return app('json')->fail('找不到该用户!');
  729. }
  730. // if(empty($data['my_con']) || empty($data['my_recon_con']) || empty($data['curr_level']) || empty($data['change_level'])){
  731. // return app('json')->fail('参数有误!');
  732. // }
  733. if($data['change_level'] <= $aa['user_group']){
  734. return app('json')->fail('升级失败,请重新选择!');
  735. }
  736. $dev_amount = 0;//需扣除的贡献值
  737. if($data['change_level'] == 2){
  738. $dev_amount = 1180;
  739. }else if($data['change_level'] == 3){
  740. $dev_amount = 11800;
  741. }
  742. //可升级用的贡献值
  743. $con_amount = $aa['contribute'] + $aa['per_contribute'];
  744. $cur_amount = $con_amount - $dev_amount;
  745. if( $cur_amount < 0){
  746. return app('json')->fail('升级失败,贡献值不足!');
  747. }
  748. // 判断总贡献值是否足够
  749. //推荐的贡献值够扣
  750. $yue_amount = $aa['per_contribute'] - $dev_amount;
  751. if( $yue_amount >= 0){
  752. $aa = Db::name('user') -> where('uid',$uid)->update(['per_contribute'=> $yue_amount, 'user_group'=>$data['change_level']]);//查询用户个人数据
  753. if($aa){
  754. $this->con_logs($uid,$yue_amount,2,11,"升级会员身份扣除贡献值",-1,2);
  755. return app('json')->success('升级成功');
  756. }
  757. }else{
  758. //推荐的贡献值不够扣
  759. $yue_amount = $aa['contribute'] + $aa['per_contribute'] - $dev_amount;
  760. if( $yue_amount == 0){
  761. $aa = Db::name('user') -> where('uid',$uid)->update(['per_contribute'=>0 , 'contribute'=>0 , 'user_group'=>$data['change_level']]);//
  762. if($aa){
  763. $this->con_logs($uid,$yue_amount,2,11,"升级会员身份扣除贡献值",-1,2);
  764. return app('json')->success('升级成功');
  765. }
  766. }else if($yue_amount > 0){
  767. $aa = Db::name('user') -> where('uid',$uid)->update(['per_contribute'=>0 , 'contribute'=>$yue_amount, 'user_group'=>$data['change_level']]);//查询用户个人数据
  768. if($aa){
  769. $this->con_logs($uid,$yue_amount,2,11,"升级会员身份扣除贡献值",-1,2);
  770. return app('json')->success('升级成功');
  771. }
  772. }
  773. }
  774. }
  775. public function con_logs($uid,$num,$order_id,$order_type,$mark,$status = -1,$state){
  776. $con_data = Db::name('user')->where("uid",$uid)->find();
  777. $con = [
  778. 'uid'=>$uid,
  779. 'number'=>$num,//赠送数量
  780. 'status'=>$status,//红包状态
  781. 'mark'=>$mark,//备注
  782. 'desc'=>'',//描述
  783. 'order_id'=>$order_id,//订单id
  784. 'surplus'=> $con_data['contribute'],//剩余
  785. 'order_type'=>$order_type,//订单类型
  786. 'type'=>$state,//1增加,2消耗
  787. 'settlement_time'=>date('Y-m-d H:i:s'),
  788. 'addtime'=>time()
  789. ];
  790. Db::name('user_sign_gongxian')->insert($con);
  791. }
  792. public function getteamsnum($teamid){
  793. $subordinate_members = Db::name('user')
  794. ->alias('u')
  795. ->join('store_order so', 'u.uid = so.uid', 'LEFT')
  796. ->where("u.spread_uid", $teamid)
  797. ->where("so.mer_id", 496)
  798. ->group('u.uid')
  799. ->select();
  800. $total_amount_pv_team = 0;
  801. $team_count_total = 0;
  802. foreach ($subordinate_members as $k => $v) {
  803. $t_teams_pv = $this->calculatePerformance($v['uid']);
  804. $total_amount_pv_team += $t_teams_pv['total_performance'];
  805. $team_count_total += $t_teams_pv['team_count'];
  806. }
  807. return $team_count_total;
  808. }
  809. //计算自己和自己团队下面的业绩。新表
  810. public function calculatePerformance($uid)
  811. {
  812. // 初始化业绩数组
  813. $performance = [
  814. 'personal_performance' => 0, // 个人业绩
  815. 'team_performance' => 0, // 团队业绩
  816. 'total_performance' => 0, // 总业绩
  817. 'team_count' => 0, // 加上自己的团队数量
  818. ];
  819. // 定义业绩换算规则
  820. $performanceMapping = [
  821. 1180 => 700,
  822. 10620 => 6300,
  823. 11800 => 7000
  824. ];
  825. // 计算个人业绩
  826. $personalOrder = Db::name('store_order')->where("uid", $uid)->find();
  827. if ($personalOrder) {
  828. // 将浮点数转换为整数
  829. $totalPrice = (int)$personalOrder['total_price'];
  830. if (isset($performanceMapping[$totalPrice])) {
  831. $performance['personal_performance'] = $performanceMapping[$totalPrice];
  832. }
  833. }
  834. // 计算旗下团队成员的业绩
  835. $teamOrders = Db::name('user')
  836. ->alias('u')
  837. ->join('store_order so', 'u.uid = so.uid', 'LEFT')
  838. ->where("u.spread_uid", $uid) // 查询旗下会员
  839. ->where("so.mer_id", 496)
  840. // ->where("so.douhuomall", 1)
  841. // ->where("so.douhuomall_status", 9)
  842. // ->where("so.status", 0)
  843. ->select();
  844. $teamOrders_count = Db::name('user')
  845. ->alias('u')
  846. ->join('store_order so', 'u.uid = so.uid', 'LEFT')
  847. ->where("u.spread_uid", $uid) // 查询旗下会员
  848. ->where("so.mer_id", 496)
  849. // ->where("so.douhuomall", 1)
  850. // ->where("so.douhuomall_status", 9)
  851. // ->where("so.status", 0)
  852. ->count();
  853. $performance['team_count'] = $teamOrders_count + 1; // 赋值团队数量
  854. foreach ($teamOrders as $order) {
  855. if ($order['total_price']) {
  856. // 将浮点数转换为整数
  857. $totalPrice = (int)$order['total_price'];
  858. if (isset($performanceMapping[$totalPrice])) {
  859. $performance['team_performance'] += $performanceMapping[$totalPrice];
  860. }
  861. }
  862. }
  863. // 计算总业绩
  864. $performance['total_performance'] = $performance['personal_performance'] + $performance['team_performance'];
  865. // 假设总业绩最大值需要通过后续逻辑判断,这里暂时设置为 false
  866. return $performance;
  867. }
  868. //获取大小部门业绩(新表)
  869. public function getbig_samll_datas($subordinate_members){
  870. //单独写一个方法获取大小部门的数据
  871. $arr_team = [];
  872. foreach ($subordinate_members as $k => $v) {
  873. //计算自己和旗下的业绩
  874. $arr_team[] = $this->calculatePerformance($v['uid']);
  875. }
  876. // 初始化变量
  877. $maxPerformance = 0;
  878. $maxIndex = -1;
  879. // 找出 total_performance 最高的记录
  880. foreach ($arr_team as $index => $item) {
  881. if ($item['total_performance'] > $maxPerformance) {
  882. $maxPerformance = $item['total_performance'];
  883. $maxIndex = $index;
  884. }
  885. }
  886. // 如果找到了最高记录
  887. if ($maxIndex !== -1) {
  888. // 提取最高记录
  889. $maxRecord = $arr_team[$maxIndex];
  890. // 从原数组中移除该记录
  891. unset($arr_team[$maxIndex]);
  892. // 重新索引数组
  893. $arr_team = array_values($arr_team);
  894. } else {
  895. // 如果没有找到记录,可以设置一个默认值
  896. $maxRecord = null;
  897. }
  898. // 计算大部门和小部门的汇总信息
  899. $majorDepartmentSummary = [
  900. "total_person_performance" => $maxRecord ? $maxRecord['personal_performance'] : 0,
  901. "total_team_performance" => $maxRecord ? $maxRecord['team_performance'] : 0,
  902. "total_performance" => $maxRecord ? $maxRecord['total_performance'] : 0,
  903. "team_count" => $maxRecord ? $maxRecord['team_count'] : 0,
  904. "data" => $maxRecord ? [$maxRecord] : []
  905. ];
  906. $minorDepartmentSummary = [
  907. "total_person_performance" => array_sum(array_column($arr_team, 'personal_performance')),
  908. "total_team_performance" => array_sum(array_column($arr_team, 'team_performance')),
  909. "total_performance" => array_sum(array_column($arr_team, 'total_performance')),
  910. "team_count" => array_sum(array_column($arr_team, 'team_count')),
  911. "data" => $arr_team
  912. ];
  913. // 输出结果
  914. // echo "大部门汇总信息:\n";
  915. // print_r($majorDepartmentSummary);
  916. // echo "小部门汇总信息:\n";
  917. // print_r($minorDepartmentSummary);
  918. return array($majorDepartmentSummary,$minorDepartmentSummary);
  919. }
  920. public function getBreak($uid,$list=[],$count=0){
  921. $sql = "select getUserLevelId($uid) as count";
  922. $count = Db::query($sql);
  923. return count(explode(",",$count[0]['count'])) - 1;
  924. }
  925. /**
  926. * 整合用户登录token
  927. * @return mixed
  928. * @author xaboy
  929. * @day 2020/6/1
  930. */
  931. public function tokenList()
  932. {
  933. $user = $this->request->userInfo()->hidden(['account','label_id', 'group_id', 'pwd', 'card_id', 'last_time', 'last_ip', 'status', 'spread_time', 'real_name']);
  934. $user->append(['service', 'user_group','total_consume', 'total_collect_product', 'total_collect_store', 'total_coupon', 'total_visit_product', 'total_unread']);
  935. $userInfo = $user->toArray();
  936. $data['mweb_info'] = $this->curl_java_login($userInfo['phone'])['data'];
  937. $data['merchant_info'] = [];
  938. return app('json')->success($data);
  939. }
  940. function curl_java_login($phone){
  941. $curl = curl_init();
  942. curl_setopt_array($curl, array(
  943. CURLOPT_URL => 'http://shop.hxxfb.com/gateway/userCenter_service/userLogOnService/userPhoneLogOn',
  944. CURLOPT_RETURNTRANSFER => true,
  945. CURLOPT_ENCODING => '',
  946. CURLOPT_MAXREDIRS => 10,
  947. CURLOPT_TIMEOUT => 0,
  948. CURLOPT_FOLLOWLOCATION => true,
  949. CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  950. CURLOPT_CUSTOMREQUEST => 'POST',
  951. CURLOPT_POSTFIELDS =>'{"phone":'.$phone.',"sms_code":"9527","type":"1"}',
  952. CURLOPT_HTTPHEADER => array(
  953. 'Content-Type: application/json'
  954. ),
  955. ));
  956. $response = curl_exec($curl);
  957. curl_close($curl);
  958. $response = json_decode($response, true);
  959. return $response;
  960. }
  961. /**
  962. * 获取用户信息
  963. * @return mixed
  964. * @author xaboy
  965. * @day 2020/6/1
  966. */
  967. public function userVolunteer()
  968. {
  969. $uid = $this->request->uid();
  970. $volunteer = Db::name("volunteer") -> where(["uid"=>$uid]) -> find();
  971. // $volunteer_class = app()->make(Volunteer::class);
  972. $volunteer_class = new Volunteer();
  973. $volunteerData = $volunteer_class -> volunteer($uid);
  974. $data['grade'] = 0;
  975. $data['self_yanglao'] = $volunteerData['self_yanglao'];
  976. $data['condition_one'] = systemConfig("volunteer_achievement");//用户本人满足养老金要求可升级为志愿者
  977. if($volunteer){
  978. $data = $volunteer;
  979. $data['self_yanglao'] = $volunteerData['self_yanglao'];
  980. if($volunteer['grade'] == 1){
  981. $data['condition_one'] = systemConfig("a_volunteer_achievement");//团队养老金要求
  982. $data['condition_two'] = systemConfig("a_volunteer_number");//团队人数要求
  983. }
  984. if($volunteer['grade'] == 2){
  985. $data['condition_one'] = systemConfig("b_volunteer_achievement");//团队养老金要求
  986. $data['condition_two'] = systemConfig("b_volunteer_number");//团队人数要求
  987. }
  988. if($volunteer['grade'] == 3){
  989. $data['condition_one'] = systemConfig("c_volunteer_achievement");//团队养老金要求
  990. $data['condition_two'] = systemConfig("c_volunteer_number");//团队人数要求
  991. }
  992. if($volunteer['grade'] == 4){
  993. $data['condition_one'] = systemConfig("d_volunteer_achievement");//团队养老金要求
  994. $data['condition_two'] = systemConfig("d_volunteer_number");//团队人数要求
  995. }
  996. }
  997. return app('json')->success($data);
  998. }
  999. /**
  1000. * @param UserRepository $repository
  1001. * @return mixed
  1002. * @author xaboy
  1003. * @day 2020/6/1
  1004. */
  1005. public function logout(UserRepository $repository)
  1006. {
  1007. $repository->clearToken($this->request->token());
  1008. return app('json')->success('退出登录');
  1009. }
  1010. /**
  1011. * @return mixed
  1012. * @throws DataNotFoundException
  1013. * @throws DbException
  1014. * @throws ModelNotFoundException
  1015. * @author xaboy
  1016. * @day 2020-05-11
  1017. */
  1018. public function auth()
  1019. {
  1020. $request = $this->request;
  1021. $oauth = WechatService::create()->getApplication()->oauth;
  1022. $oauth->setRequest(new Request($request->get(), $request->post(), [], [], [], $request->server(), $request->getContent()));
  1023. try {
  1024. $wechatInfo = $oauth->user()->getOriginal();
  1025. } catch (\Exception $e) {
  1026. return app('json')->fail('授权失败[001]', ['message' => $e->getMessage()]);
  1027. }
  1028. if (!isset($wechatInfo['nickname'])) {
  1029. return app('json')->fail('授权失败[002]');
  1030. }
  1031. /** @var WechatUserRepository $make */
  1032. $make = app()->make(WechatUserRepository::class);
  1033. $user = $make->syncUser($wechatInfo['openid'], $wechatInfo);
  1034. if (!$user)
  1035. return app('json')->fail('授权失败[003]');
  1036. /** @var UserRepository $make */
  1037. $userRepository = app()->make(UserRepository::class);
  1038. $user[1] = $userRepository->mainUser($user[1]);
  1039. $pid = $this->request->param('spread', 0);
  1040. $userRepository->bindSpread($user[1], intval($pid));
  1041. $tokenInfo = $userRepository->createToken($user[1]);
  1042. $userRepository->loginAfter($user[1]);
  1043. return app('json')->success($userRepository->returnToken($user[1], $tokenInfo));
  1044. }
  1045. protected function returnToken($user, $tokenInfo)
  1046. {
  1047. $CommonRepository = app()->make(Common::class);
  1048. $access_token ='75_-8y0OT8i5w72EkPCLpCQoGFGa2Ir42T8RHvqZPLJ4sjn27s6Aj7RUEO5yJX77pzHVoo34zXpeBS0M-gdNegdCRB4FWhkAqxmuhdrANkenSHdrmEvPSWQex4OKFQXLBfAEAJXN';
  1049. var_dump($access_token);
  1050. $unionid = "oGtg_6E5SwAcXhv5Do5z3GL_UMXw";
  1051. $unionid = "o4-On50WzIkkbJsf-apbBE3VB1O0";
  1052. $url = "https://api.weixin.qq.com/cgi-bin/user/info?access_token=" . $access_token . "&openid=" . $unionid . "&lang=zh_CN";
  1053. }
  1054. /**
  1055. * @return mixed
  1056. * @throws DataNotFoundException
  1057. * @throws DbException
  1058. * @throws ModelNotFoundException
  1059. * @author xaboy
  1060. * @day 2020-05-11
  1061. */
  1062. public function mpAuth()
  1063. {
  1064. list($code, $post_cache_key) = $this->request->params([
  1065. 'code',
  1066. 'cache_key',
  1067. ], true);
  1068. $session_key = Cache::get('eb_api_code_' . $post_cache_key);
  1069. if (!$code && !$session_key)
  1070. return app('json')->fail('授权失败,参数有误');
  1071. $miniProgramService = MiniProgramService::create();
  1072. if ($code && !$session_key) {
  1073. try {
  1074. $userInfoCong = $miniProgramService->getUserInfo($code);
  1075. $session_key = $userInfoCong['session_key'];
  1076. $cache_key = md5(time() . $code);
  1077. Cache::set('eb_api_code_' . $cache_key, $session_key, 86400);
  1078. } catch (\Exception $e) {
  1079. return app('json')->fail('获取session_key失败,请检查您的配置!', ['line' => $e->getLine(), 'message' => $e->getMessage()]);
  1080. }
  1081. }
  1082. $data = $this->request->params([
  1083. ['spread_spid', 0],
  1084. ['spread_code', ''],
  1085. ['iv', ''],
  1086. ['encryptedData', ''],
  1087. ]);
  1088. try {
  1089. //解密获取用户信息
  1090. $userInfo = $miniProgramService->encryptor($session_key, $data['iv'], $data['encryptedData']);
  1091. } catch (\Exception $e) {
  1092. if ($e->getCode() == '-41003') return app('json')->fail('获取会话密匙失败');
  1093. throw $e;
  1094. }
  1095. if (!$userInfo || !isset($userInfo['openId'])) return app('json')->fail('openid获取失败');
  1096. if (!isset($userInfo['unionId'])) $userInfo['unionId'] = '';
  1097. /** @var WechatUserRepository $make */
  1098. $make = app()->make(WechatUserRepository::class);
  1099. $user = $make->syncRoutineUser($userInfo['openId'], $userInfo);
  1100. if (!$user)
  1101. return app('json')->fail('授权失败');
  1102. /** @var UserRepository $make */
  1103. $userRepository = app()->make(UserRepository::class);
  1104. $user[1] = $userRepository->mainUser($user[1]);
  1105. //获取是否有扫码进小程序
  1106. if (isset($data['spread_code']) && ($info = app()->make(RoutineQrcodeRepository::class)->getRoutineQrcodeFindType($data['spread_code']))) {
  1107. $data['spread_spid'] = $info['third_id'];
  1108. }
  1109. $userRepository->bindSpread($user[1], intval($data['spread_spid']));
  1110. $tokenInfo = $userRepository->createToken($user[1]);
  1111. $userRepository->loginAfter($user[1]);
  1112. return app('json')->success($userRepository->returnToken($user[1], $tokenInfo));
  1113. }
  1114. public function getCaptcha()
  1115. {
  1116. $codeBuilder = new CaptchaBuilder(null, new PhraseBuilder(4));
  1117. $key = uniqid(microtime(true), true);
  1118. Cache::set('api_captche' . $key, $codeBuilder->getPhrase(), 300);
  1119. $captcha = $codeBuilder->build()->inline();
  1120. $code = $codeBuilder->getPhrase();
  1121. return app('json')->success(compact('key', 'code', 'captcha'));
  1122. }
  1123. protected function checkCaptcha($uni, string $code): bool
  1124. {
  1125. $cacheName = 'api_captche' . $uni;
  1126. if (!Cache::has($cacheName)) return false;
  1127. $key = Cache::get($cacheName);
  1128. $code = mb_strtolower($code, 'UTF-8');
  1129. $res = password_verify($code, $key);
  1130. if ($res) Cache::delete($cacheName);
  1131. return $res;
  1132. }
  1133. public function verify(UserAuthValidate $validate)
  1134. {
  1135. $data = $this->request->params(['phone', 'code', 'key',"type"]);
  1136. $validate->sceneVerify()->check($data);
  1137. log::info("发送短信方法");
  1138. if ($data['type']=="register"){
  1139. $count=Db::name("user")->where("phone", $data["phone"])->count();
  1140. if ($count){
  1141. return app('json')->make(405, '该手机号已注册');
  1142. }
  1143. }
  1144. $sms_num_key = 'api.auth.num.' . $data['phone'];
  1145. $sms_key = 'api.auth.sms.' . $data['phone'];
  1146. $num = Cache::get($sms_num_key) ? Cache::get($sms_num_key) : 0;
  1147. log::info("num{$num}" );
  1148. if ($num > 9) {
  1149. if (!$data['code'])
  1150. return app('json')->make(402, '操作过于频繁,请稍后重试~');
  1151. if (!$this->checkCaptcha($data['key'], $data['code']))
  1152. return app('json')->fail('验证码输入有误');
  1153. }
  1154. $sms_code = str_pad(random_int(1, 9999), 4, 0, STR_PAD_LEFT);
  1155. $sms_time = systemConfig('sms_time') ? systemConfig('sms_time') : 30 ;
  1156. $res = app()->make(AliYunSmsService::class)->send($data['phone'], $sms_code);
  1157. if($res['Code']!='OK'){
  1158. Db::name('log')->insert(['data'=>'幸福保短信发送失败:'.json_encode($res,256)]);
  1159. return app('json')->fail('操作过于频繁,请稍后重试~');
  1160. }
  1161. log::info("sms_key==={$sms_key}" );
  1162. log::info("sms_code==={$sms_code}" );
  1163. log::info("sms_time==={$sms_time}" );
  1164. Cache::set($sms_key, $sms_code,$sms_time * 60);
  1165. Cache::set($sms_num_key, $num + 1, 300);
  1166. //'短信发送成功'
  1167. return app('json')->success('短信发送成功');
  1168. }
  1169. /**
  1170. * 一壶茶查询邀请人信息 1-根据手机号查询uid 2-根据uid查手机号
  1171. * @return mixed
  1172. * @throws DataNotFoundException
  1173. * @throws DbException
  1174. * @throws ModelNotFoundException
  1175. */
  1176. public function query_uid(){
  1177. $phone = $this->request->param('phone');
  1178. $uid = $this->request->param('uid',0);
  1179. $share_id = $this->request->param('share_id',0);
  1180. $type = $this->request->param('type',1);//1-根据手机号查询uid 2-根据uid查手机号 3-通过share_id 查询用户信息
  1181. if($this->source=='yhc' && $this->merId) {
  1182. $user=$this->inviter_verification($type,$uid,$phone,$share_id);
  1183. if($user!=false){
  1184. return app('json')->success('获取成功',$user);
  1185. }
  1186. }
  1187. return app('json')->fail('邀请人不存在');
  1188. }
  1189. private function inviter_verification($type,$uid='',$phone='',$share_id=''){
  1190. if($type==2) {
  1191. $where['uid'] = $uid;
  1192. }else if($type==3){
  1193. $where['uid'] = Db::name('product_share')->where('id', $share_id)->value('uid');
  1194. }else{
  1195. $where['account']=$phone;
  1196. }
  1197. $user =Db::name('user')->field('uid,account as phone')->where($where)->find();
  1198. if(!$user){
  1199. return false;
  1200. }
  1201. $user2 = Db::name('enterprise_user')->where('mer_id',$this->merId)->where('uid',$user['uid'])->find();
  1202. if(!$user2){
  1203. return false;
  1204. }
  1205. return $user;
  1206. }
  1207. /**
  1208. * 一壶茶判断这个手机号是否注册过
  1209. * @return mixed
  1210. * @throws DataNotFoundException
  1211. * @throws DbException
  1212. * @throws ModelNotFoundException
  1213. */
  1214. public function query_phone()
  1215. {
  1216. $phone = $this->request->param('phone','');
  1217. if($phone==''){
  1218. //解密微信手机号
  1219. $sessionKey=$this->request->params(['sessionKey']);
  1220. $encryptedData=$this->request->params(['encryptedData']);
  1221. $iv=$this->request->params(['iv']);
  1222. if(empty($sessionKey['sessionKey'])||empty($encryptedData['encryptedData'])||empty($iv['iv'])){
  1223. return app('json')->fail('参数不正确');
  1224. }
  1225. $appid = 'wx9082e5ac2fdb513f';//储蓄保小程序appid
  1226. if($this->source=='yhc'){
  1227. $appid = 'wx9082e5ac2fdb513f';//一壶茶小程序appid
  1228. }
  1229. $sessionKey =str_replace(' ','+', $sessionKey['sessionKey']);
  1230. $encryptedData=str_replace(' ','+',$encryptedData['encryptedData']);
  1231. $iv =str_replace(' ','+', $iv['iv']);
  1232. $pc = new WXBizDataCrypt($appid, $sessionKey);
  1233. $errCode = $pc->decryptData($encryptedData, $iv, $wx_data_str );
  1234. if ($errCode != 0) {
  1235. return app('json')->fail('没有获取到手机号');
  1236. }
  1237. // dump($data);
  1238. $wx_data=json_decode($wx_data_str,true);
  1239. if(isset($wx_data['purePhoneNumber'])){
  1240. $phone=$wx_data['purePhoneNumber'];
  1241. }
  1242. }
  1243. $validate= new UserAuthValidate();
  1244. $validate->sceneVerify()->check(['phone'=>$phone]);
  1245. if($this->source=='yhc' && $this->merId) {
  1246. $where['account']=$phone;
  1247. $user =Db::name('user')->field('uid')->where($where)->find();
  1248. if(!$user){
  1249. return app('json')->fail('未注册');
  1250. }
  1251. $user2 = Db::name('enterprise_user')->where('mer_id',$this->merId)->where('uid',$user['uid'])->find();
  1252. if($user2){
  1253. return app('json')->success('已注册');
  1254. }
  1255. }
  1256. return app('json')->fail('未注册');
  1257. }
  1258. public function smsLogin(UserAuthValidate $validate, UserRepository $repository)
  1259. {
  1260. $data = $this->request->params(['phone', 'sms_code', 'spread', 'share_id']);
  1261. // $data = $this->request->params(['phone', 'sms_code']);
  1262. $validate->sceneSmslogin()->check($data);
  1263. $domain = $this->request->domain();
  1264. $suni_phone=['13200000001','13300000000','13400000000','18888888888','13966666666','16000000008','13000000000','13000000005','13000000002','13000000003','13000000004','13000000006','13000000007','13000000008','13000000009','14000000000','14000000001','14000000002','14000000003','14000000004','14000000005','13700000000','14000000006','14000000007','16000000002','17000000000','13700000001','16000000009','13700000002','17000000001','17000000002','14000000008','14000000009','14000000010','18000000001','18000000002','13700000004','16000000000','16000000001','13700000003','16000000003','15210999641'];
  1265. if(($data['sms_code'] == '9527' || $data['sms_code'] == 9527)){
  1266. } else if($data['sms_code'] == '9527' && strpos($domain, 'pre.bjtdba.com') !== false){
  1267. // 域名中包含 "test.hebeiyhc.com'" 字符串
  1268. }else{
  1269. if (!$this->checkSmsCode($data['phone'], $data['sms_code']))
  1270. return app('json')->fail('验证码不正确');
  1271. }
  1272. $user = $repository->accountByUser($data['phone']);
  1273. if (!$user){
  1274. if (!intval($data['spread'])) {
  1275. $spread_uid = Db::name('product_share')->where('id', $data['share_id'])->value('uid');
  1276. $data['spread'] = $spread_uid;
  1277. }
  1278. $user = $repository->registr($data['phone'], null, 'h5', $data['spread']);
  1279. }
  1280. $user = $repository->mainUser($user);
  1281. // if($this->source=='yhc' && $this->merId){
  1282. // $where=['mer_id'=>$this->merId,'uid'=>$user->uid];
  1283. // $count=Db::name('enterprise_user')->where($where)->count();
  1284. // if($count<1){
  1285. // $insert=['mer_id'=>$this->merId,'uid'=>$user->uid];
  1286. // if (!intval($data['spread'])) {
  1287. // $spread_uid = Db::name('product_share')->where('id', $data['share_id'])->value('uid');
  1288. // }else{
  1289. // $spread_uid=$data['spread'];
  1290. // }
  1291. // if($this->inviter_verification(2,$spread_uid)==false){
  1292. // return app('json')->fail('请输入正确邀请人手机号');
  1293. // }
  1294. // $insert['puid']= $spread_uid;
  1295. // $insert['node_uid']= $spread_uid;
  1296. // Db::name('enterprise_user')->insert($insert);
  1297. // }
  1298. // }
  1299. // $repository->bindSpread($user, intval($data['spread']));
  1300. $tokenInfo = $repository->createToken($user);
  1301. $repository->loginAfter($user);
  1302. return app('json')->success($repository->returnToken($user, $tokenInfo));
  1303. }
  1304. public function merJavaRegister(UserRepository $repository){
  1305. $data = $this->request->params(['phone', 'spread','token','sign']);
  1306. Log::channel("gong")->info("供应链取消商品数据:" . json_encode($data));
  1307. // 校验sign
  1308. $checkSign = Signature::checkSign($data);
  1309. if (!$checkSign) {
  1310. Log::channel("gong")->error('sign校验失败');
  1311. return app('json')->fail('sign校验失败');
  1312. }
  1313. $user = $repository->accountByUser($data['phone']);
  1314. if (!$user) $user = $repository->registr($data['phone'], $data['password'],'MP',intval($data['spread']));
  1315. $user = $repository->mainUser($user);
  1316. $repository->bindSpread($user, intval($data['spread']));
  1317. $repository->loginAfter($user);
  1318. return app('json')->success($user);
  1319. }
  1320. /**
  1321. * @param $phone
  1322. * @param $code
  1323. * @return bool
  1324. * @author Qinii
  1325. * @day 2020-06-12
  1326. */
  1327. public function checkSmsCode($phone, $code)
  1328. {
  1329. $sms_key = 'api.auth.sms.' . $phone;
  1330. //log::info("缓存===code=={$sms_key}");
  1331. //log::info( Cache::get($sms_key));
  1332. //log::info("页面传值==={$code}");
  1333. if (!$cache_code = Cache::get($sms_key)) return false;
  1334. if ($code != $cache_code) return false;
  1335. Cache::delete($sms_key);
  1336. return true;
  1337. }
  1338. //批量生产100个账号
  1339. public function register_all(UserAuthValidate $validate, UserRepository $repository){
  1340. $datas = $this->request->params(['start', 'end','phone']);
  1341. if(mb_strlen($datas['start'].$datas['phone']) != 11 || mb_strlen($datas['end'].$datas['phone']) != 11){
  1342. return app("json")->fail('参数错误');
  1343. }
  1344. for($i=$datas['start'];$i<=$datas['end'];$i++)//这个dao是看你要生成多答少个数字,然后循环生成
  1345. {
  1346. $data=[
  1347. "phone"=>$datas['phone'].$i,
  1348. 'password'=>"123456"
  1349. ];
  1350. $user = $repository->registr($data['phone'], $data['password']);
  1351. $data=[
  1352. 'user_name'=>"测试".$i,
  1353. "mobile"=>"15555555187",
  1354. "user_card"=>"410181198508206517",
  1355. "card_positive"=>"https://app.bjtdba.com/uploads/def/20201030/088ecbdfa81534fadcc7c731d11c0594.jpg",
  1356. "card_reverse"=>"https://app.bjtdba.com/uploads/def/20201030/7546811225c6b5df37a7f41250ba3e66.jpg",
  1357. "status"=>1,
  1358. "create_time"=>time(),
  1359. "update_time"=>time(),
  1360. "uid"=>$i
  1361. ];
  1362. Db::name("user_certification")->insert($data);
  1363. }
  1364. return app("json")->success('成功');
  1365. }
  1366. public function phoneCheck(UserRepository $repository){
  1367. $data = $this->request->params(['phone']);
  1368. $user = $repository->accountByUser($data['phone']);
  1369. if($user){
  1370. return app("json")->success('手机号已注册,可直接绑定',1);
  1371. }else{
  1372. return app("json")->success('手机号未注册,请输入密码',2);
  1373. }
  1374. }
  1375. /*支付宝获取签名*/
  1376. public function aliSign(){
  1377. $repository = app()->make(UserRepository::class);
  1378. $data = $repository ->aliSign();
  1379. return app("json")->success('ok',$data);
  1380. }
  1381. /*支付宝授权登录*/
  1382. public function aliCheck(){
  1383. $data = $this->request->params(['user_id']);
  1384. if(!$data['user_id'] || $data['user_id'] == '' || $data['user_id'] =='undefined'){
  1385. return app('json')->fail("异常操作");
  1386. }
  1387. $repository = app()->make(UserRepository::class);
  1388. $result = $repository ->aliCheck($data['user_id']);
  1389. if(isset($result['code']) && $result['code'] == 200){
  1390. $user = $repository->accountByUser($result['user']['account']);
  1391. $tokenInfo = $repository->createToken($user);
  1392. $repository->loginAfter($user);
  1393. return app('json')->success($repository->returnToken($user, $tokenInfo));
  1394. }
  1395. return app("json")->success('ok',$result);
  1396. }
  1397. /*微信信息获取*/
  1398. public function getWechat(){
  1399. $repository = app()->make(UserRepository::class);
  1400. return app('json')->success($repository->getWechat());
  1401. }
  1402. /*微信授权登录*/
  1403. public function wechatCheck(){
  1404. $data = $this->request->params(['openid']);
  1405. if(!$data['openid'] || $data['openid'] == '' || $data['openid'] =='undefined'){
  1406. return app('json')->fail("openid参数缺失");
  1407. }
  1408. $repository = app()->make(UserRepository::class);
  1409. if($this->source=='yhc'){
  1410. $result = $repository ->wechatCheckYhc($data['openid']);
  1411. }else{
  1412. $result = $repository ->wechatCheck($data['openid']);
  1413. }
  1414. if(isset($result['code']) && $result['code'] == 200){
  1415. $user = $repository->accountByUser($result['user']['account']);
  1416. $tokenInfo = $repository->createToken($user);
  1417. $repository->loginAfter($user);
  1418. if($this->source=='yhc'){
  1419. // $user=$user->toArray();
  1420. $user->avatar=Db::name('enterprise_user')->where('mer_id',$this->merId)->where('uid',$user['uid'])->value('avatar');
  1421. }
  1422. return app('json')->success($repository->returnToken($user, $tokenInfo));
  1423. }
  1424. return app("json")->fail($result['msg']);
  1425. }
  1426. public function binding_yhc(UserAuthValidate $validate, UserRepository $repository)
  1427. {
  1428. $data = $this->request->params(['phone', 'third_user_id','type']);
  1429. if(!$data['third_user_id'] || $data['third_user_id'] == '' || $data['third_user_id'] =='undefined'){
  1430. return app('json')->fail("绑定失败");
  1431. }
  1432. $data['password'] = '12345678';//密码已经去掉了。统一默认密码
  1433. $user = $repository->thirdBinding($data['phone'], $data['password'],'APP','',0,"https://". $this->request->host(true));//2222
  1434. if($user){
  1435. $enterprise_user= Db::name("enterprise_user")->where("mer_id",$this->merId)->where('uid',$user->uid)->find();
  1436. if(!$enterprise_user){
  1437. Db::name("enterprise_user")->insert(['mer_id'=>$this->merId,'uid'=>$user->uid,'openid'=>$data['third_user_id']]);
  1438. }else if ($enterprise_user['openid']==''){
  1439. $update = ["openid" => $data['third_user_id']];
  1440. Db::name("enterprise_user")->where(['mer_id'=>$this->merId,'uid'=>$user->uid])->update($update);
  1441. }
  1442. // $pid = $this->request->param('spread', 0);
  1443. // $repository->bindSpread($user, intval($pid));
  1444. $tokenInfo = $repository->createToken($user);
  1445. $repository->loginAfter($user);
  1446. return app('json')->success($repository->returnToken($user, $tokenInfo));
  1447. }else{
  1448. return app('json')->fail("绑定失败");
  1449. }
  1450. }
  1451. /**
  1452. * 支付宝微信注册绑定手机号
  1453. * type 1微信2支付宝
  1454. * third_user_id 微信openid 支付宝userId
  1455. * @param UserRepository $repository
  1456. */
  1457. public function binding(UserAuthValidate $validate, UserRepository $repository)
  1458. {
  1459. $data = $this->request->params(['phone', 'sms_code', 'password','third_user_id','type','nickName','avatarUrl','sms']);
  1460. if(!$data['third_user_id'] || $data['third_user_id'] == '' || $data['third_user_id'] =='undefined'){
  1461. return app('json')->fail("绑定失败");
  1462. }
  1463. $data['password'] = '12345678';//密码已经去掉了。统一默认密码
  1464. $validate->sceneSmslogin()->check($data);
  1465. if($data['sms'] != 1){
  1466. if (!$this->checkSmsCode($data['phone'], $data['sms_code']))
  1467. return app('json')->fail('验证码不正确');
  1468. }
  1469. $user = $repository->thirdBinding($data['phone'], $data['password'],'APP',$data['third_user_id'],$data['type'],"https://". $this->request->host(true));//2222
  1470. if($user){
  1471. $userRepository = app()->make(UserRepository::class);
  1472. $userInfo = $userRepository->getOne(['uid' => $user->uid ?? $user['uid']]);
  1473. //绑定线下充值金额
  1474. $unionUsersRepository = app()->make(UnionUsersRepository::class);
  1475. $orderMerchantRepository = app()->make(OrderMerchantRepository::class);
  1476. $notBind = $unionUsersRepository->getAllNotBind($data['third_user_id']);
  1477. if ($notBind) {
  1478. $orderMerchantRepository->doBindUser($userInfo, $data['type']);
  1479. }
  1480. $user = $repository->accountByUser($data['phone']);
  1481. if ($data['type'] == 1) {
  1482. $data1 = ["wechat_user_id" => $data['third_user_id']];
  1483. if($this->source=='yhc' && $this->merId){ //一壶茶创建用户
  1484. $enterprise_user_count = Db::name("enterprise_user")->where("mer_id",$this->merId)->where('uid',$user->uid)->count();
  1485. if($enterprise_user_count<1){
  1486. $spread_data = $this->request->params(['spread', 'share_id']);
  1487. if (!intval($spread_data['spread'])) {
  1488. $spread_uid = Db::name('product_share')->where('id', $spread_data['share_id'])->value('uid');
  1489. }else{
  1490. $spread_uid=$spread_data['spread'];
  1491. }
  1492. if($this->inviter_verification(2,$spread_uid)==false){
  1493. return app('json')->fail('请输入正确邀请人手机号');
  1494. }
  1495. Db::name("enterprise_user")->insert(['mer_id'=>$this->merId,'uid'=>$user->uid,'openid'=>$data['third_user_id']]);
  1496. }
  1497. }
  1498. } else {
  1499. $data1 = ["ali_user_id" => $data['third_user_id']];
  1500. }
  1501. $data2 = [
  1502. "type" => $data['type'],
  1503. "uid" => $user->uid,
  1504. "nickname" => !empty($data['nickName']) ? $data['nickName'] : $user -> nickname,
  1505. "avater" => !empty($data['avatarUrl']) ? $data['avatarUrl'] : $user -> avater,
  1506. ];
  1507. $userRepository -> updateUser($user->uid,$data1,$data2);
  1508. $pid = $this->request->param('spread', 0);
  1509. $repository->bindSpread($user, intval($pid));
  1510. $tokenInfo = $repository->createToken($user);
  1511. $repository->loginAfter($user);
  1512. return app('json')->success($repository->returnToken($user, $tokenInfo));
  1513. }else{
  1514. return app('json')->fail("绑定失败");
  1515. }
  1516. }
  1517. public function queryHaike(){
  1518. $merch_no = $this->request->params(['merch_no']);
  1519. if(!isset($merch_no['merch_no']) || empty($merch_no['merch_no'])){
  1520. return app('json')->fail("请输入商户号");
  1521. }
  1522. $res = Db::name("haike_account")->where("merch_no",$merch_no['merch_no'])->select();
  1523. if(!$res){
  1524. return app('json')->fail("这个商户号没有账单");
  1525. }
  1526. $merch = Db::name('merchant') -> where("merch_no",$merch_no['merch_no']) -> find();
  1527. $data['商户号'] = $merch_no['merch_no'];
  1528. $data['商户名称'] = $merch["mer_name"];
  1529. $data['商户手机号'] = $merch["mer_phone"];
  1530. $data['结算金额'] = 0;
  1531. $data['结算手续费'] = 0;
  1532. foreach ($res as $key => $value){
  1533. $data['结算金额'] += $value['settle_accounts'];
  1534. $data['结算手续费'] += $value['settle_accounts_fee'];
  1535. }
  1536. echo "<pre>";
  1537. dump($data);
  1538. return 1;
  1539. }
  1540. public function createUserNumberAll(){
  1541. $userRepository = app()->make(UserRepository::class);
  1542. $user = Db::name('user') -> select();
  1543. foreach($user as $key => $value){
  1544. $userRepository -> createUserNumber($value['uid']);
  1545. }
  1546. }
  1547. /**
  1548. * @param int $uid 用户ID
  1549. * @param string $score 积分
  1550. * @param int $status 积分状态
  1551. * @param string $mark 备注
  1552. * @param string $has_qian 连续签到天数
  1553. * @param string $today_signintime 签到时间
  1554. * @param int $order_id 订单ID
  1555. * @param int $pm 1-收入。2-支出
  1556. * @param string $order_type
  1557. * @throws DbException
  1558. */
  1559. public function sign_add($uid, $score, $status, $mark, $has_qian = '', $today_signintime = '', $order_id = 0, $pm = 1, $order_type = '',$type='',$settlement_time = '')
  1560. {
  1561. if(!in_array($type,[1,2])){
  1562. // 其他情况都直接返回,因为目前只有365专区购买才可以获得
  1563. return false;
  1564. }
  1565. $ins_data['uid'] = $uid;
  1566. $ins_data['continuity_day'] = $has_qian;
  1567. $ins_data['reward_socre'] = $score;
  1568. $ins_data['signin_time'] = $today_signintime;
  1569. $ins_data['addtime'] = time();
  1570. $ins_data['status'] = $status;
  1571. $ins_data['mark'] = $mark;
  1572. $ins_data['type'] = $type;
  1573. $ins_data['settlement_time'] = $settlement_time;// 结算时间 真正到了结算时间会结算
  1574. $ins_data['order_id'] = $order_id;
  1575. $ins_data['pm'] = $pm;
  1576. $ins_data['order_type'] = $order_type;
  1577. Db::name('user_sign_score')->insertGetId($ins_data);
  1578. if($pm == 1 && $status == 1){
  1579. Db::name('user')->where('uid',$uid)->inc('score', $score)->update();
  1580. }
  1581. if($pm == 2){
  1582. Db::name('user')->where('uid', $uid)->dec('score', $score)->update();
  1583. }
  1584. }
  1585. public function yijianlogin(UserRepository $repository)
  1586. {
  1587. try {
  1588. // Db::name('log')->insert(['data'=>'一键登录进来了']);
  1589. $token = $this->request->params(['token'])['token'];
  1590. AlibabaCloud::accessKeyClient('LTAI5tAzGzm3Kjp8pzn7hHmx', '8ILb06tO6X7xxQk2uj2CDwFNbVWQei')
  1591. ->regionId('cn-hangzhou')
  1592. ->asDefaultClient();
  1593. $result = AlibabaCloud::rpc()
  1594. ->product('Dypnsapi')
  1595. ->scheme('https')// https | http
  1596. ->version('2017-05-25')
  1597. ->action('GetMobile')
  1598. ->method('POST')
  1599. ->host('dypnsapi.aliyuncs.com')
  1600. ->options([
  1601. 'query' => [
  1602. 'RegionId' => "cn-hangzhou",
  1603. 'AccessToken' => $token
  1604. ],
  1605. ])
  1606. ->request();
  1607. // 将返回的结果转化为数组
  1608. $result = $result->toArray();
  1609. // Db::name('log')->insert(['data'=>json_encode($result)]);
  1610. //判断当前数组不为空
  1611. if (isset($result['GetMobileResultDTO']['Mobile'])) {
  1612. // token不为空返回手机号码
  1613. $phone = $result['GetMobileResultDTO']['Mobile'];
  1614. $user_res=Db::name('user')->where('account',$phone)->find();
  1615. if(!$user_res){
  1616. $repository->registr($phone, 123456,'APP',"http://app.bjtdba.com");
  1617. }
  1618. $user = $repository->accountByUser($phone);
  1619. $user = $repository->mainUser($user);
  1620. $tokenInfo = $repository->createToken($user);
  1621. return app('json')->success($repository->returnToken($user, $tokenInfo));
  1622. } else {
  1623. //如果token为空
  1624. $res = [
  1625. 'state' => 0,
  1626. 'msg' => 'token无效'
  1627. ];
  1628. return app('json')->fail($res);
  1629. }
  1630. }catch (\Exception $e) {
  1631. Db::name('log')->insert(['data'=>'一键登录出错:'.$e->getFile().':'.$e->getLine().'【'.$e->getMessage().'】']);
  1632. }
  1633. }
  1634. //小程序获取 用户手机号
  1635. public function applet_phone(UserRepository $repository)
  1636. {
  1637. try {
  1638. // Db::name('log')->insert(['data'=>json_encode($this->request->param())]);
  1639. $sessionKey=$this->request->params(['sessionKey']);
  1640. $encryptedData=$this->request->params(['encryptedData']);
  1641. $share_id = $this->request->params(['share_id']);
  1642. $iv=$this->request->params(['iv']);
  1643. if(empty($sessionKey['sessionKey'])||empty($encryptedData['encryptedData'])||empty($iv['iv'])){
  1644. return app('json')->fail('参数不正确');
  1645. }
  1646. $appid = 'wx82986c4471ce7efc';
  1647. if($this->source=='yhc'){
  1648. $appid = 'wx82986c4471ce7efc';
  1649. }
  1650. $appid = 'wx7b4d857deb0447f3';
  1651. $sessionKey =str_replace(' ','+', $sessionKey['sessionKey']);
  1652. $encryptedData=str_replace(' ','+',$encryptedData['encryptedData']);
  1653. $iv =str_replace(' ','+', $iv['iv']);
  1654. // dump($iv,$encryptedData);
  1655. // return ;
  1656. $pc = new WXBizDataCrypt($appid, $sessionKey);
  1657. // dump($pc);
  1658. $errCode = $pc->decryptData($encryptedData, $iv, $data );
  1659. // dump($errCode);
  1660. if ($errCode != 0) {
  1661. return app('json')->fail('没有获取到手机号1');
  1662. }
  1663. // dump($data);
  1664. $data=json_decode($data,true);
  1665. $phone=$data['purePhoneNumber']??'';
  1666. if($phone==''){
  1667. return app('json')->fail('没有获取到手机号2');
  1668. }
  1669. if (!preg_match("/^1[3456789]{1}\d{9}$/", $phone)){
  1670. return app('json')->fail('手机号格式错误');
  1671. }
  1672. $user_res=Db::name('user')->where('account',$phone)->find();
  1673. if(!$user_res){
  1674. $spread_uid=Db::name('product_share')->where('id',$share_id['share_id'])->value('uid');
  1675. $repository->registr($phone, 123456,'APP',$spread_uid);
  1676. }
  1677. $user = $repository->accountByUser($phone);
  1678. if($this->source=='yhc' && $this->merId){
  1679. $where=['mer_id'=>$this->merId,'uid'=>$user['uid']];
  1680. $count=Db::name('enterprise_user')->where($where)->count();
  1681. if($count<1){
  1682. $insert=['mer_id'=>$this->merId,'uid'=>$user['uid']];
  1683. $data = $this->request->params(['spread', 'share_id']);
  1684. if(isset($data['spread']) && $data['spread']){
  1685. $insert['puid']= $data['spread'];
  1686. $insert['node_uid']= $data['spread'];
  1687. }else if(isset($data['share_id']) && $data['share_id']){
  1688. $spread_uid = Db::name('product_share')->where('id', $data['share_id'])->value('uid');
  1689. $insert['puid']= $spread_uid;
  1690. $insert['node_uid']= $spread_uid;
  1691. }
  1692. if(!isset($insert['node_uid']) || !$insert['node_uid']){
  1693. return app('json')->fail('必须要有邀请人才能注册',['is'=>1]);
  1694. }
  1695. if(isset($data['spread']) && isset($zhuce)){
  1696. $insert['puid']= $data['spread'];
  1697. $insert['node_uid']= $data['spread'];
  1698. }
  1699. Db::name('enterprise_user')->insert($insert);
  1700. }
  1701. }
  1702. $user = $repository->mainUser($user);
  1703. $tokenInfo = $repository->createToken($user);
  1704. return app('json')->success($repository->returnToken($user, $tokenInfo));
  1705. }catch (Exception $exception){
  1706. Db::name('log')->insert(['data'=>'获取手机号失败--'.$exception->getFile().':'.$exception->getLine().'【'.$exception->getMessage().'】']);
  1707. }
  1708. }
  1709. public function phone_name()
  1710. {
  1711. try {
  1712. $phone=$this->request->params(['phone']);
  1713. if(empty($phone['phone'])){
  1714. return app('json')->fail('请填写手机号码');
  1715. }
  1716. $phone=$phone['phone'];
  1717. $uid=Db::name('user')->where('account',$phone)->find();
  1718. $user_name=Db::name('merchant')->where('uid',$uid['uid'])->value('mer_name');
  1719. if(!$user_name){
  1720. $user_name=$uid['nickname'];
  1721. }
  1722. return app('json')->success($user_name);
  1723. }catch (\Exception $e) {
  1724. Db::name('log')->insert(['data'=>'订单支付出错:'.$e->getFile().':'.$e->getLine().'【'.$e->getMessage().'】']);
  1725. }
  1726. }
  1727. public function get_auth_token(){
  1728. $params=$this->request->params(['url','origin']);
  1729. try {
  1730. AlibabaCloud::accessKeyClient('LTAI5tAzGzm3Kjp8pzn7hHmx', '8ILb06tO6X7xxQk2uj2CDwFNbVWQei')
  1731. ->regionId('cn-hangzhou')
  1732. ->asDefaultClient()->options([
  1733. ]);
  1734. $result = AlibabaCloud::rpc()
  1735. ->product('Dypnsapi')
  1736. ->scheme('https')// https | http
  1737. ->version('2017-05-25')
  1738. ->action('GetAuthToken')
  1739. ->method('POST')
  1740. ->host('dypnsapi.aliyuncs.com')
  1741. ->options([
  1742. 'query' => [
  1743. 'Url' => $params['url'],
  1744. 'Origin' => $params['origin'],
  1745. ],
  1746. ])
  1747. ->request();
  1748. $result = $result->toArray();
  1749. return app('json')->success($result);
  1750. }catch (Exception $e) {
  1751. return app('json')->success();
  1752. }
  1753. }
  1754. public function get_phone_with_token(){
  1755. $params=$this->request->params(['token']);
  1756. AlibabaCloud::accessKeyClient('LTAI5tAzGzm3Kjp8pzn7hHmx', '8ILb06tO6X7xxQk2uj2CDwFNbVWQei')
  1757. ->regionId('cn-hangzhou')
  1758. ->asDefaultClient()->options([]);
  1759. $result = AlibabaCloud::rpc()
  1760. ->product('Dypnsapi')
  1761. ->scheme('https')// https | http
  1762. ->version('2017-05-25')
  1763. ->action('GetPhoneWithToken')
  1764. ->method('POST')
  1765. ->host('dypnsapi.aliyuncs.com')
  1766. ->options([
  1767. 'query' => [
  1768. 'SpToken' => $params['token'],
  1769. ],
  1770. ])
  1771. ->request();
  1772. $result = $result->toArray();
  1773. return app('json')->success($result);
  1774. }
  1775. public function getconlev(){
  1776. $userid = 17;
  1777. $datas = $this->getPerformance22($userid);
  1778. var_dump($datas);
  1779. }
  1780. /**
  1781. * 获取当前用户业绩
  1782. */
  1783. public function getPerformance22($user_id) {
  1784. $team_amount = 0;
  1785. $person_amount = 0;
  1786. $user_id = 593; //598 523 536
  1787. $result_big_team_arr = [];
  1788. $get_teams_comm_datas = [];//在2.0中获取父级下面的所有团队数据
  1789. //共建联盟业绩 个人联盟业绩 共建联盟总pv 个人联盟业绩pv
  1790. $common_nums = $this->getCommonNums($user_id);
  1791. //var_dump($common_nums);
  1792. $get_teams_comm_num = 0;
  1793. $get_teams_comm_pv = 0;
  1794. $get_teams_per_num = 0;//小部门人数
  1795. //1.0系统中有下级,需要在2.0中再加下级数据
  1796. if($user_id < 611){
  1797. //梅红在2.0中的ID是780
  1798. //var_dump( $common_nums);
  1799. //用户三峡所有在2.0系统下面的业绩和人数 start
  1800. $child_nums = [];
  1801. //获取当前用户
  1802. foreach($common_nums as $v){
  1803. $child_nums[] = $this->getRecursiveChildren($v);
  1804. }
  1805. //去除空数组,并重新组合有数据的数组
  1806. $filteredData = array_filter($child_nums, function($array) {
  1807. return !empty($array); // 如果数组不为空,则保留
  1808. });
  1809. // 合并所有非空数组
  1810. foreach ($filteredData as $array) {
  1811. $result_big_team_arr = array_merge($result_big_team_arr, $array);
  1812. }
  1813. //var_dump($result_big_team_arr);
  1814. //获取当前用户下面在2.0中的下级所有PV
  1815. //$get_teams_comm_pv = $this->getteampv($result_big_team_arr);
  1816. $t_pv = $this->getteampv($result_big_team_arr);
  1817. $get_teams_comm_pv = $t_pv;
  1818. //var_dump($get_teams_comm_pv);echo "ttt";
  1819. //用户伞下小部门所有在2.0系统下面的业绩和人数 end
  1820. }else{
  1821. //当前用户在1.0没有下级,那直接在新系统2.0找下级获取数据,并区分大小部门
  1822. $child_nums = $this->getChildren($user_id);
  1823. //获取父级子级下面的个人
  1824. $num_teams = $this->getTeamSize($child_nums);
  1825. //var_dump($num_teams);
  1826. foreach($child_nums as $v){
  1827. $get_teams_comm_datas[] = $this->getTeamPv11($v);//如果有多个父级ID,需要获取他们伞下的子级,所有的业绩进行
  1828. }
  1829. //$s = $this->getparents_child_pv($user_id);
  1830. //var_dump($get_teams_comm_datas);
  1831. //如果只有一个部门,就是默认大部门
  1832. if( count($get_teams_comm_datas) ==1 ){
  1833. $get_teams_comm_pv =$get_teams_comm_datas[0];
  1834. $get_teams_comm_num = $num_teams[0]['total_count'];
  1835. }else if(count($get_teams_comm_datas) >1){
  1836. // var_dump( $get_teams_comm_datas);
  1837. //获取一个最大值,设为大部门,其他的加载一块是小部门
  1838. $getss = $this->processArray($get_teams_comm_datas);
  1839. //var_dump($getss);
  1840. $max_value_count = $num_teams[$getss['max_index']]['total_count'];
  1841. unset($num_teams[$getss['max_index']]);
  1842. //获取小部门的人数
  1843. $per_num = 0;
  1844. foreach($num_teams as $k=>$v){
  1845. $per_num +=$v['total_count'];
  1846. }
  1847. //找到最大值的(大部门)
  1848. //$get_teams_comm_num = $max_value_count;
  1849. //小部门的数量
  1850. // $get_teams_per_num = $per_num;
  1851. //var_dump($getss['max_value']);
  1852. $person_amount = $getss['remaining_sum'];
  1853. $get_teams_comm_pv = $getss['max_value'];
  1854. }
  1855. }
  1856. //var_dump($get_teams_comm_pv);
  1857. //合并业绩和人数
  1858. $team_amount += $get_teams_comm_pv;
  1859. //var_dump($team_amount);
  1860. //1.0获取小区业绩
  1861. $person_nums = $this->getPersonageNums($user_id);
  1862. //var_dump($person_nums);
  1863. $result_small_team_arr = [];
  1864. //1.0系统中有下级,需要在2.0中再加下级数据
  1865. //用户三峡所有在2.0系统下面的业绩和人数 start
  1866. $child_nums_mix = [];
  1867. //获取当前用户
  1868. foreach($person_nums as $v){
  1869. $child_nums_mix[] = $this->getRecursiveChildren($v);
  1870. }
  1871. //去除空数组,并重新组合有数据的数组
  1872. $filteredData_1 = array_filter($child_nums_mix, function($array) {
  1873. return !empty($array); // 如果数组不为空,则保留
  1874. });
  1875. // 合并所有非空数组
  1876. $result_small_team_arr = [];
  1877. foreach ($filteredData_1 as $array) {
  1878. $result_small_team_arr = array_merge($result_small_team_arr, $array);
  1879. }
  1880. //var_dump($result_small_team_arr);
  1881. //获取当前用户下面在2.0中的下级所有PV
  1882. // $get_teams_per_pv = $this->getteampv($result_small_team_arr);
  1883. $t_pv = $this->getteampv($result_small_team_arr);
  1884. $get_teams_per_pv =$t_pv;
  1885. //var_dump( $get_teams_per_pv);
  1886. //获取当前用户下面在2.0中的下级所有人数
  1887. $get_teams_per_num += count($result_small_team_arr);
  1888. //合并业绩和人数
  1889. $person_amount += $get_teams_per_pv;
  1890. // if($user_id == 593){
  1891. // $person_amount = 2800;
  1892. // }
  1893. //var_dump($common_nums);
  1894. //用户小部门所有在2.0系统下面的业绩和人数 end
  1895. //var_dump($team_amount);
  1896. // $common_nums[] = $user_id;
  1897. // foreach ($common_nums as $key => $value) {
  1898. // # code...
  1899. // $amount = $this->getPerformance1($value);
  1900. // $team_amount += $amount;
  1901. // }
  1902. // foreach ($person_nums as $key => $value) {
  1903. // # code...
  1904. // $amount = $this->getPerformance1($value);
  1905. // $person_amount += $amount;
  1906. // }
  1907. //当前会员直属的业绩(1.0大部门)
  1908. $t_pv = $this->getteampv($common_nums);
  1909. $team_amount += $t_pv;
  1910. //当前会员直属的业绩(1.0大部门)
  1911. $p_pv = $this->getteampv($person_nums);
  1912. $person_amount += $p_pv;
  1913. //var_dump($team_amount,$person_amount);
  1914. //如果当前用户是1.0用户,找到其直推所有的业绩,根据业绩找到大小部门的同时,还要比对1.0中大小部门的业绩,摘出一个最大业绩的部门是大部门,其余都是小部门()
  1915. if($user_id < 611){
  1916. //获取当前用户直属下级(查询在2.0中直接推荐人和伞下的业绩。并比对大小部门)
  1917. //例子:17所有下面uid是speard_uid都是17的,和所有伞下的业绩。分出大小部门,加到1.0的大小部门中
  1918. $b_s = $this->getparents_child_pv11($user_id,$team_amount,$person_amount);
  1919. //var_dump($b_s);
  1920. // var_dump($team_amount,$person_amount);
  1921. // var_dump(count($common_nums)+ $get_teams_comm_num,count($person_nums)+ $get_teams_per_num);
  1922. //var_dump( $b_s);echo "yyyyyyyyyyyyy";
  1923. $team_amount = $b_s[0];
  1924. // $teams_num = $b_s['big_department']['count'];
  1925. //var_dump($b_s);
  1926. // var_dump($b_s['per_pv']);
  1927. $person_amount = $b_s[1];
  1928. // $per_num = $b_s['small_department']['count'];//小部门人数
  1929. //var_dump( $b_s['team_num'],$b_s['per_num']);
  1930. }
  1931. $return_data = [
  1932. 'common_nums_pv'=> $team_amount,
  1933. 'person_nums_pv'=> $person_amount,
  1934. ];
  1935. return $return_data;
  1936. }
  1937. /**
  1938. * 获取该用户共建联盟
  1939. */
  1940. public function getCommonNums($user_id){
  1941. //先获取共建联盟下用户的id
  1942. $son_ids = Db::name("old_user_jbp")->where("spread",$user_id)->where("is_team",1)->select()->toArray();
  1943. $new_array_ids =[];
  1944. foreach ($son_ids as $key => $value) {
  1945. # code...
  1946. $son_id = $value['id'];
  1947. $new_array_ids = array_merge($new_array_ids,[$son_id]);
  1948. $son_value_ids = Db::name("old_user_jbp")->whereRaw("FIND_IN_SET('$son_id',parent_ids)")->field("id")->select()->toArray();
  1949. if(count($son_value_ids) > 0) {
  1950. $son_value_ids = array_column($son_value_ids,"id");
  1951. $new_array_ids = array_merge($new_array_ids,$son_value_ids);
  1952. }
  1953. }
  1954. return $new_array_ids;
  1955. }
  1956. /**
  1957. * 获取该用户个人联盟
  1958. */
  1959. public function getPersonageNums($user_id){
  1960. $son_ids = Db::name("old_user_jbp")->where("spread",$user_id)->where("is_team",0)->field("id")->select();
  1961. $new_array_ids =[];
  1962. // return 3343;
  1963. foreach ($son_ids as $key => $value) {
  1964. # code...
  1965. $son_id = $value['id'];
  1966. $new_array_ids = array_merge($new_array_ids,[$son_id]);
  1967. $son_value_ids = Db::name("old_user_jbp")->whereRaw("FIND_IN_SET('$son_id',parent_ids)")->field("id")->select()->toArray();
  1968. if(count($son_value_ids) > 0) {
  1969. $son_value_ids = array_column($son_value_ids,"id");
  1970. $new_array_ids = array_merge($new_array_ids,$son_value_ids);
  1971. }
  1972. }
  1973. return $new_array_ids;
  1974. }
  1975. // 根据父级uid,递归获取所有子级UID数组
  1976. public function getRecursiveChildren($parentUid) {
  1977. $result = []; // 用于存储所有子级的 uid
  1978. // 定义递归函数
  1979. $recursion = function ($parentUid) use (&$result, &$recursion) {
  1980. // 查询当前父级的所有直接子级
  1981. $children = Db::name("user")
  1982. ->where("spread_uid", $parentUid)
  1983. ->column("uid"); // 获取子级的 uid 列表
  1984. // 如果没有子级,直接返回
  1985. if (empty($children)) {
  1986. return;
  1987. }
  1988. // 遍历每个子级
  1989. foreach ($children as $childUid) {
  1990. $result[] = $childUid; // 将子级的 uid 添加到结果数组
  1991. $recursion($childUid); // 递归查询子级的子级
  1992. }
  1993. };
  1994. // 从初始父级开始递归查询
  1995. $recursion($parentUid);
  1996. return array_unique($result); // 返回结果数组,并去重
  1997. }
  1998. //只获取数组中的业绩
  1999. public function getteampv($common_nums) {
  2000. // // 查询当前用户及其子级的所有订单
  2001. $orders_gongxian = Db::name("user_sign_gongxian")
  2002. ->whereIn('status', [1])
  2003. ->whereIn("uid", $common_nums)
  2004. ->select();
  2005. $total_gongxian = 0;
  2006. // // 遍历订单计算业绩
  2007. foreach ($orders_gongxian as $order) {
  2008. if (strpos($order['mark'], "购买") !== false) {
  2009. $total_gongxian += $order['number'];
  2010. }
  2011. }
  2012. return $total_gongxian;
  2013. // // 查询当前用户及其子级的所有订单
  2014. // $orders = Db::name("store_order")
  2015. // ->whereIn('status', [0, 1, 2, 3])
  2016. // ->whereIn("uid", $common_nums)
  2017. // ->whereIn("total_price", [1180, 11800, 10620, 2360, 9440])
  2018. // ->select();
  2019. // // 初始化业绩和人数
  2020. // $totalPv = 0;
  2021. // $totalUsers = count($common_nums); // 初始化人数为子级总数
  2022. // // 遍历订单计算业绩
  2023. // foreach ($orders as $order) {
  2024. // if ($order['total_price'] == 1180) {
  2025. // $totalPv += 700;
  2026. // } else if ($order['total_price'] == 11800) {
  2027. // $totalPv += 7000;
  2028. // } else if ($order['total_price'] == 10620) {
  2029. // $totalPv += 6300;
  2030. // } else if ($order['total_price'] == 2360) {
  2031. // $totalPv += 1400;
  2032. // } else if ($order['total_price'] == 9440) {
  2033. // $totalPv += 5600;
  2034. // }
  2035. // }
  2036. // // 返回业绩和人数
  2037. // return [
  2038. // 'totalPv' => $totalPv,
  2039. // 'totalUsers' => $totalUsers
  2040. // ];
  2041. }
  2042. // 2.0 根据父级uid,找到当前用户下面的UID
  2043. public function getChildren($parentUid) {
  2044. $result = []; // 用于存储所有子级的 uid
  2045. $children = Db::name("user")
  2046. ->where("spread_uid", $parentUid)
  2047. ->column("uid"); // 获取子级的 uid 列表
  2048. return $children; // 返回结果数组,并去重
  2049. }
  2050. // 递归获取所有子级 UID 的业绩
  2051. public function getTeamPv11($parentUid) {
  2052. $getRecursiveChildren = function ($parentUid) use (&$getRecursiveChildren) {
  2053. $children = Db::name("user")
  2054. ->where("spread_uid", $parentUid)
  2055. ->column("uid");
  2056. $allChildren = [];
  2057. foreach ($children as $childUid) {
  2058. $allChildren[] = $childUid;
  2059. $allChildren = array_merge($allChildren, $getRecursiveChildren($childUid));
  2060. }
  2061. return $allChildren;
  2062. };
  2063. // 获取当前用户及其所有子级的 UID
  2064. $allUids = array_merge([$parentUid], $getRecursiveChildren($parentUid));
  2065. $orders_gongxian = Db::name("user_sign_gongxian")
  2066. ->whereIn('status', [1])
  2067. ->whereIn("uid", $allUids)
  2068. ->select();
  2069. $total_gongxian = 0;
  2070. // // 遍历订单计算业绩
  2071. foreach ($orders_gongxian as $order) {
  2072. if (strpos($order['mark'], "购买") !== false) {
  2073. $total_gongxian += $order['number'];
  2074. }
  2075. }
  2076. return $total_gongxian;
  2077. // // 查询当前用户及其子级的所有订单
  2078. // $orders = Db::name("store_order")
  2079. // ->whereIn('status', [0, 1, 2, 3])
  2080. // ->whereIn("uid", $allUids)
  2081. // ->whereIn("total_price", [1180, 11800, 10620, 2360, 9440])
  2082. // ->select();
  2083. // // 计算总业绩
  2084. // $totalPv = 0;
  2085. // foreach ($orders as $order) {
  2086. // switch ($order['total_price']) {
  2087. // case 1180:
  2088. // $totalPv += 700;
  2089. // break;
  2090. // case 11800:
  2091. // $totalPv += 7000;
  2092. // break;
  2093. // case 10620:
  2094. // $totalPv += 6300;
  2095. // break;
  2096. // case 2360:
  2097. // $totalPv += 1400;
  2098. // break;
  2099. // case 9440:
  2100. // $totalPv += 5600;
  2101. // break;
  2102. // }
  2103. // }
  2104. // return $totalPv;
  2105. }
  2106. //根据传递的父级数组,返回他的对应子级的个数
  2107. public function getTeamSize($parentUids) {
  2108. // 初始化结果数组
  2109. $result = [];
  2110. // 遍历每个父级ID
  2111. foreach ($parentUids as $parentUid) {
  2112. // 递归获取所有子级 UID
  2113. $getRecursiveChildren = function ($parentUid) use (&$getRecursiveChildren) {
  2114. $children = Db::name("user")
  2115. ->where("spread_uid", $parentUid)
  2116. ->column("uid");
  2117. // 确保返回的是数组
  2118. if (!is_array($children)) {
  2119. return [];
  2120. }
  2121. $allChildren = [];
  2122. foreach ($children as $childUid) {
  2123. $allChildren[] = $childUid;
  2124. $allChildren = array_merge($allChildren, $getRecursiveChildren($childUid));
  2125. }
  2126. return $allChildren;
  2127. };
  2128. // 获取当前父级及其所有子级的 UID
  2129. $allUids = array_merge([$parentUid], $getRecursiveChildren($parentUid));
  2130. // 计算总个数(包括父级自身)
  2131. $totalUids = count($allUids);
  2132. // 将结果存入数组
  2133. $result[] = [
  2134. 'parent_uid' => $parentUid,
  2135. 'total_count' => $totalUids
  2136. ];
  2137. }
  2138. return $result;
  2139. }
  2140. public function processArray($array) {
  2141. // 初始化结果数组
  2142. $result = [
  2143. 'max_value' => null, // 最大值
  2144. 'max_index' => null, // 最大值的下标
  2145. 'remaining_sum' => 0 // 剩余值的总和
  2146. ];
  2147. // 检查数组是否为空
  2148. if (empty($array)) {
  2149. return $result;
  2150. }
  2151. // 找出最大值及其下标
  2152. $maxValue = $array[0];
  2153. $maxIndex = 0;
  2154. for ($i = 1; $i < count($array); $i++) {
  2155. if ($array[$i] > $maxValue) {
  2156. $maxValue = $array[$i];
  2157. $maxIndex = $i;
  2158. }
  2159. }
  2160. // 计算剩余值的总和
  2161. $remainingSum = 0;
  2162. for ($i = 0; $i < count($array); $i++) {
  2163. if ($i != $maxIndex) {
  2164. $remainingSum += $array[$i];
  2165. }
  2166. }
  2167. // 将结果存入数组
  2168. $result['max_value'] = $maxValue;
  2169. $result['max_index'] = $maxIndex;
  2170. $result['remaining_sum'] = $remainingSum;
  2171. return $result;
  2172. }
  2173. /**
  2174. * 获取流水信息
  2175. */
  2176. public function getPerformance1($user_id) {
  2177. // $amount = Db::name("old_user_of_goods")->where("node_id",$user_id)->where("status",1)->sum("money");
  2178. // $amount = isset($amount) ? round($amount*0.7,2) : 0;
  2179. // return $amount;
  2180. $money1180Records = Db::name("old_user_of_goods")->where("node_id",$user_id)->where("money",1180)->where("status",1)->select();
  2181. $money1180Sum = 0;
  2182. foreach ($money1180Records as $record) {
  2183. $money1180Sum += $record['money'] - 300 - 180;
  2184. }
  2185. // var_dump($money1180Sum);
  2186. $money11800Records = Db::name("old_user_of_goods")->where("node_id",$user_id)->where("money",11800)->where("status",1)->select();
  2187. //var_dump($person_nums);
  2188. //计算个人的11800单价的业绩 集合
  2189. $money11800Sum = 0;
  2190. foreach ($money11800Records as $record) {
  2191. $money11800Sum += $record['money'] - 3000 - 1800;
  2192. }
  2193. $money10620Records = Db::name("old_user_of_goods")->where("node_id",$user_id)->where("money",10620)->where("status",1)->select();
  2194. //var_dump($person_nums);
  2195. //计算个人的11800单价的业绩 集合
  2196. $money10620Sum = 0;
  2197. foreach ($money10620Records as $record) {
  2198. $money10620Sum += $record['money'] - 2700 - 1620;
  2199. }
  2200. // 计算除去特定值后的总和
  2201. $otherMoneyRecords = Db::name("old_user_of_goods")->where("node_id",$user_id)->where('status', 1)->whereNotIn('money', [1180, 11800 ,10620])->select();
  2202. $otherMoneySum = 0;
  2203. foreach ($otherMoneyRecords as $record) {
  2204. $otherMoneySum += $record['money'];
  2205. }
  2206. // 分别处理特定值的情况并加上其他值的总和
  2207. $user_person_amount = $money1180Sum + $money11800Sum + $money10620Sum + round($otherMoneySum * 0.7,2);
  2208. return $user_person_amount;
  2209. }
  2210. //1.0用户直属的部门和2.0直属的部门,进行比较,获取大部门和小部门数据
  2211. public function getparents_child_pv11($user_id, $bigamount, $smallamount) {
  2212. // 获取直接下级的 UID 列表
  2213. $get_childs = Db::name("user")
  2214. ->where("spread_uid", $user_id)
  2215. ->column("uid");
  2216. // 如果没有直属下级,直接返回 [0, 0]
  2217. if (empty($get_childs)) {
  2218. return [0, 0];
  2219. }
  2220. // 初始化数组存储直属下级的业绩
  2221. $all_departments = [];
  2222. // 遍历每个直属下级
  2223. foreach ($get_childs as $child) {
  2224. // 获取当前下级及其子级
  2225. $child_group = [$child];
  2226. $recursive_children = $this->getRecursiveChildren($child);
  2227. $child_group = array_merge($child_group, $recursive_children);
  2228. // 获取当前分组的业绩
  2229. $result = $this->getteampv($child_group);
  2230. // 如果返回的业绩为 null 或 0,直接返回 [0, 0]
  2231. if ($result === null || $result['totalPv'] == 0) {
  2232. return [0, 0];
  2233. }
  2234. // 将直属下级的业绩加入数组
  2235. $all_departments[] = $result['totalPv'];
  2236. }
  2237. // 将传入的 $bigamount 和 $smallamount 也加入数组
  2238. $all_departments[] = $bigamount;
  2239. $all_departments[] = $smallamount;
  2240. // 找出最大业绩
  2241. $max_department = max($all_departments);
  2242. // 计算小部门业绩:总和 - 最大值
  2243. $small_department = array_sum($all_departments) - $max_department;
  2244. var_dump($max_department);
  2245. // 返回结果
  2246. return [$max_department, $small_department];
  2247. }
  2248. //获取当前uesr_id下面在2.0中是否还有直接下级,并计算她的大部门和小部门
  2249. public function getparents_child_pv($user_id){
  2250. // 获取直接下级的 UID 列表
  2251. //$user_id = 593;
  2252. // $get_childs = $this->getRecursiveChildren($user_id);
  2253. $get_childs = Db::name("user")
  2254. ->where("spread_uid", $user_id)
  2255. ->column("uid"); // 获取子级的 uid 列表
  2256. //根据获得的直接推荐下级2.0,来获取他们和她伞下的子级PV。对比拿一个最大的值,设为大部门,其余的是小部门
  2257. //获取直接下级
  2258. $children_group = []; // 用于存储每个直接下级及其子级的分组
  2259. // 遍历每个直接下级
  2260. foreach ($get_childs as $child) {
  2261. $child_group = [$child]; // 将直接下级加入分组
  2262. $recursive_children = $this->getRecursiveChildren($child); // 获取直接下级的所有子级
  2263. $child_group = array_merge($child_group, $recursive_children); // 将子级加入分组
  2264. $children_group[] = $child_group; // 将分组加入最终结果
  2265. }
  2266. $get_teams_comm_datas = [];
  2267. foreach($children_group as $v){
  2268. $get_teams_comm_datas[] = $this->getteampv($v);//如果有多个父级ID,需要获取他们伞下的子级,所有的业绩进行
  2269. }
  2270. if(count($get_teams_comm_datas) > 0){
  2271. // 找到最大值作为大部门
  2272. $max_value = max($get_teams_comm_datas);
  2273. $total_sum = array_sum($get_teams_comm_datas); // 计算数组的总和
  2274. // 小部门为总和减去最大值
  2275. $small_department = $total_sum - $max_value;
  2276. //返回大部门和小部门
  2277. return [
  2278. $max_value,
  2279. $small_department
  2280. ];
  2281. }else{
  2282. return [
  2283. 0,
  2284. 0
  2285. ];
  2286. }
  2287. }
  2288. }