Import.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534
  1. <?php
  2. namespace Agent\Lib;
  3. set_time_limit(0);
  4. use Dever;
  5. class Import
  6. {
  7. # 图片存放地址
  8. private $img_host = 'https://cryl.yijiuguanfang.com/attachment/';
  9. public function __construct()
  10. {
  11. $this->db = Dever::db('agent/test:old');
  12. }
  13. # 获取已审核的条件
  14. private function get_yes_where()
  15. {
  16. //issuingstate=1 已发放权益
  17. return 'restatus = 0 and status = 1 and prestatus = 1 and isagent = 1';
  18. }
  19. # 获取审核失败的条件
  20. private function get_no_where()
  21. {
  22. //issuingstate=1 已发放权益
  23. return 'restatus = 1 and isagent = 1';
  24. }
  25. # 获取待审核的条件
  26. private function get_where()
  27. {
  28. //issuingstate=1 已发放权益
  29. return 'restatus = 0 and status = 0 and isagent = 1 and contractstatus = 1';
  30. }
  31. # 获取sql
  32. public function get_sql_api()
  33. {
  34. $table['已审核'] = 'select count(*) as num,mobile from ims_ewei_shop_member where '.$this->get_yes_where().' group by mobile order by num desc';
  35. $table['审核失败'] = 'select count(*) as num,mobile from ims_ewei_shop_member where '.$this->get_no_where().' group by mobile order by num desc';
  36. $table['待审核'] = 'select count(*) as num,mobile from ims_ewei_shop_member where '.$this->get_where().' group by mobile order by num desc';
  37. echo Dever::table($table);die;
  38. }
  39. public function get_api()
  40. {
  41. Dever::config('base')->hook = true;
  42. $host = 'https://cryl.yijiuguanfang.com/attachment/';
  43. $state = 1;
  44. while($state) {
  45. $state = $this->get_data($host, $state);
  46. }
  47. # 导入关联表
  48. //$this->getRelation();
  49. # 导入地区价格
  50. //$this->getAreaPrice();
  51. # 导入余额 不导入了
  52. //$this->getYue();
  53. return 'ok';
  54. }
  55. public function get_data($host, $index = 0)
  56. {
  57. # 获取已审核通过、权益已发放的用户
  58. $index = $index - 1;
  59. $limit = 1000;
  60. $data = $this->db->fetchAll('select * from ims_ewei_shop_member where status = 1 and prestatus = 1 and isagent = 1 order by createtime asc limit ' . $index . ', ' . $limit);
  61. if (!$data) {
  62. return false;
  63. }
  64. foreach ($data as $k => $v) {
  65. # 创建订单
  66. $order = Dever::db('agent/order')->find(array('id' => $v['id'], 'clear' => true));
  67. if (!$order) {
  68. echo $v['id'];
  69. echo "\r\n";
  70. $data = array();
  71. $data['id'] = $v['id'];
  72. $data['mobile'] = $v['mobile'];
  73. $data['name'] = $v['realname'];
  74. $data['avatar'] = $v['avatar'];
  75. $data['username'] = $v['nickname'];
  76. $data['mid'] = $v['id'];
  77. $data['parent_mid'] = $v['agentid'];
  78. $data['admin_desc'] = $v['content'];
  79. $data['parent_code'] = Dever::load("invite/api.code", $data['parent_mid']);
  80. $data['role'] = $this->getRole($v['agentlevel']);
  81. if ($v['datavalue']) {
  82. $data['area'] = Dever::load('area/api')->up($v['province'], $v['city'], $v['area'], $v['street'], $v['datavalue'], $v['streetvalue']);
  83. } else {
  84. $data['area'] = Dever::load('area/api')->upByName($v['province'], $v['city'], $v['area'], $v['street'], $v['streetvalue']);
  85. }
  86. if ($v['entertype'] == 1) {
  87. $data['type'] = 1;
  88. } else {
  89. $data['type'] = 2;
  90. }
  91. $data['price'] = $v['paymoney'];
  92. $data['f_price'] = $data['price'];
  93. $role = Dever::db('setting/role')->find($data['role']);
  94. if ($role['type'] == 1) {
  95. //$data['f_price'] = $role['price'];
  96. } elseif ($role['type'] == 2) {
  97. /*
  98. $data['f_price'] = Dever::load('area/api')->getPrice($role['area'], $data['area']);
  99. if ($data['f_price'] <= 0) {
  100. $data['f_price'] = $data['price'];
  101. }
  102. */
  103. # 区域要进行占用
  104. if ($data['area']) {
  105. Dever::load('area/api')->upStatus($data['area'], 2);
  106. $area_data = array('mid' => $v['id'], 'order_id' => $v['id'], 'role' => $data['role'], 'area' => $data['area']);
  107. $area_data['type'] = 4;
  108. $area_data['price'] = $data['f_price'];
  109. $area_data['cdate'] = $v['agentapplytime'];
  110. Dever::db('agent/member_area')->insert($area_data);
  111. }
  112. }
  113. $data['agent_cash'] = $data['f_price'];
  114. $data['sign'] = $v['contractsign'] ? $host . $v['contractsign'] : '';
  115. $data['idcard'] = $v['idnumber'];
  116. $data['idcard_front'] = $data['idcard_back'] = '';
  117. if ($v['identity']) {
  118. $identity = Dever::json_decode($v['identity']);
  119. if (isset($identity[0])) {
  120. $data['idcard_front'] = $host . $identity[0];
  121. }
  122. if (isset($identity[1])) {
  123. $data['idcard_back'] = $host . $identity[1];
  124. }
  125. }
  126. $data['company_name'] = $v['company'];
  127. $data['address'] = $v['province'] . $v['city'] . $v['area'] . $v['street'];
  128. $data['pay_type'] = 2;
  129. if ($v['receipt']) {
  130. $receipt = Dever::json_decode($v['receipt']);
  131. $data['pay_pic'] = array();
  132. foreach ($receipt as $v1) {
  133. $data['pay_pic'][] = $host . $v1;
  134. }
  135. $data['pay_pic'] = implode(',', $data['pay_pic']);
  136. }
  137. $data['status'] = $this->getStatus($v);
  138. $data['audit_desc'] = $v['refuse'];
  139. if ($v['issuingstate'] == 1) {
  140. $data['goods_status'] = 3;
  141. } else {
  142. $data['goods_status'] = 1;
  143. }
  144. $data['pay_status'] = 2;
  145. $data['import'] = $v['olduid'] > 0 ? 3 : 2;
  146. $data['order_num'] = Dever::load('agent/lib/order')->getOrderId();
  147. $data['cdate'] = $v['agentapplytime'];
  148. if ($data['status'] == 4) {
  149. $data['fdate'] = $v['agenttime'];
  150. }
  151. $data['order_type'] = 1;
  152. $data['company_pic'] = '';
  153. $order = Dever::db('agent/order')->find(array('id' => $v['id'], 'clear' => true));
  154. if (!$order) {
  155. $order_id = Dever::db('agent/order')->insert($data);
  156. } else {
  157. $order_id = $order['id'];
  158. }
  159. if ($order_id) {
  160. if (!$v['preagenttime']) {
  161. $v['preagenttime'] = $v['agenttime'];
  162. }
  163. if ($data['status'] == 2) {
  164. $this->addProcess($order_id, 1, $v['preagenttime'], $data);
  165. } elseif ($data['status'] == 3) {
  166. $this->addProcess($order_id, 1, $v['preagenttime'], $data);
  167. $this->addProcess($order_id, 2, $v['agenttime'], $data);
  168. } elseif ($data['status'] == 4) {
  169. $this->addProcess($order_id, 1, $v['preagenttime'], $data);
  170. $this->addProcess($order_id, 2, $v['agenttime'], $data);
  171. $this->addProcess($order_id, 3, $v['agenttime'], $data);
  172. }
  173. if ($data['status'] == 4) {
  174. # 生成合同
  175. if ($data['sign']) {
  176. $this->addAgreement($data);
  177. }
  178. $member = Dever::db('agent/member')->find($v['id']);
  179. if ($data['status'] == 4) {
  180. $data['status'] = 2;
  181. } elseif ($data['status'] == 5) {
  182. $data['status'] = 1;
  183. $data['state'] = 2;
  184. } else {
  185. $data['status'] = 1;
  186. }
  187. $mc_member = $this->db->fetch('select * from ims_mc_members where uid = ' . $v['uid']);
  188. $data['rdate'] = $v['agenttime'];
  189. $data['cash'] = ($mc_member && $mc_member['credit2']) ? $mc_member['credit2'] : $v['credit2'];
  190. $data['group_sell'] = $v['allcommission'];
  191. if (!$member) {
  192. Dever::db('agent/member')->insert($data);
  193. } else {
  194. $data['where_id'] = $member['id'];
  195. Dever::db('agent/member')->update($data);
  196. }
  197. if ($data['parent_mid']) {
  198. # 添加直推关系
  199. Dever::load('invite/lib/relation')->add($data['parent_mid'], $data['mid'], 1);
  200. # 为上级增加增加业绩
  201. Dever::load('bill/lib/sell')->up($data['parent_mid'], 1, $data['f_price'], $data['role'], $order_id, '直推业绩', 1, $data['cdate']);
  202. Dever::load('bill/lib/sell')->up($data['parent_mid'], 2, $data['f_price'], $data['role'], $order_id, '团队业绩', 1, $data['cdate']);
  203. }
  204. }
  205. echo 1;
  206. echo "\r\n";
  207. }
  208. }
  209. }
  210. $index = $index + 1;
  211. return $index + $limit;
  212. }
  213. # 设置邀请关系 要跑完所有数据才能设置
  214. public function relation()
  215. {
  216. $data = Dever::db('invite/relation')->all(array('level' => 1));
  217. if ($data) {
  218. foreach ($data as $k => $v) {
  219. $this->addRelation($v['to_uid'], $v['uid'], 2);
  220. }
  221. }
  222. }
  223. private function addRelation($cur, $parent, $level = 2)
  224. {
  225. $info = Dever::db('invite/relation')->one(array('to_uid' => $parent));
  226. if ($info) {
  227. Dever::load('invite/lib/relation')->add($info['uid'], $cur, $level);
  228. $level = $level + 1;
  229. $this->addRelation($cur, $info['uid'], $level);
  230. }
  231. }
  232. # 验证直推代理人数是否正确 agentdownnum
  233. # 导入区域价格
  234. private function getAreaPrice()
  235. {
  236. $data = $this->db->fetchAll('select * from ims_ewei_shop_wang_city_other where deleted=0 and hide=0');
  237. if ($data) {
  238. foreach ($data as $k => $v) {
  239. $province = Dever::db('area/province')->one(array('name' => $v['province']));
  240. if ($province && $v['city']) {
  241. $city = Dever::db('area/city')->one(array('name' => $v['city'], 'province_id' => $province['id']));
  242. if ($city && $v['district']) {
  243. $county = Dever::db('area/county')->one(array('name' => $v['district'], 'city_id' => $city['id']));
  244. if ($county && $v['identity'] == 3) {
  245. # 区县
  246. Dever::db('area/county')->update(array('where_id' => $county['id'], 'price' => $v['money']));
  247. } elseif ($county && $v['street'] && $v['identity'] == 4) {
  248. # 街道
  249. if (strstr($v['street'], '燕郊')) {
  250. Dever::db('area/town')->update(array('where_id' => 131082450, 'price' => $v['money']));
  251. Dever::db('area/town')->update(array('where_id' => 131082109, 'price' => $v['money']));
  252. } else {
  253. $town = Dever::db('area/town')->one(array('name' => $v['street'], 'county_id' => $county['id']));
  254. if ($town) {
  255. Dever::db('area/town')->update(array('where_id' => $town['id'], 'price' => $v['money']));
  256. }
  257. }
  258. }
  259. }
  260. }
  261. }
  262. }
  263. }
  264. # 导入余额日志[不包括提现]
  265. private function getYue()
  266. {
  267. $data = $this->db->fetchAll('select * from mc_credits_record where credittype = "credit2" order by id asc');
  268. if ($data) {
  269. foreach ($data as $k => $v) {
  270. if ($v['credittype'] == 'credit2') {
  271. # 直推佣金
  272. $type = 1;
  273. } elseif ($v['credittype'] == 'credit3') {
  274. # 市场培训费
  275. $type = 2;
  276. } else {
  277. continue;
  278. }
  279. $remark = $v['remark'];
  280. if (strstr($remark, '提现')) {
  281. continue;
  282. }
  283. $info = Dever::db('bill/cash')->one(array('id' => $v['id'], 'clear' => true));
  284. if (!$info) {
  285. $update['id'] = $v['id'];
  286. $update['type'] = $type;
  287. if ($v['uid'] > 0) {
  288. $member = $this->db->fetch('select * from ims_ewei_shop_member where uid = ' . $v['uid'] . ' and isagent = 1 and status = 1 and prestatus = 1');
  289. if ($member) {
  290. $update['mid'] = $member['id'];
  291. }
  292. } elseif ($remark) {
  293. $temp = explode('OPENID: ', $remark);
  294. $temp = explode(' 剩余', $temp[1]);
  295. if (isset($temp[0]) && $temp[0]) {
  296. $member = $this->db->fetch('select * from ims_ewei_shop_member where openid = "' . $temp[0] . '" and isagent = 1 and status = 1 and prestatus = 1');
  297. if ($member) {
  298. $update['mid'] = $member['id'];
  299. }
  300. }
  301. }
  302. if (isset($update['mid']) && $update['mid'] > 0) {
  303. if (strstr($remark, '消费')) {
  304. $type = 12;
  305. }
  306. $update['cash'] = $v['num'];
  307. $update['yue'] = $v['presentcredit'];
  308. $update['status'] = 2;
  309. $update['audit'] = 2;
  310. $update['cdate'] = $update['operdate'] = $v['createtime'];
  311. $update['order_num'] = Dever::load('bill/lib/cash')->getOrderId();
  312. Dever::db('bill/cash')->insert($update);
  313. }
  314. }
  315. }
  316. }
  317. }
  318. # 获取提现
  319. private function getTixian()
  320. {
  321. $data = $this->db->fetchAll('select * from ims_ewei_shop_member_log where type > 0');
  322. if ($data) {
  323. foreach ($data as $k => $v) {
  324. $v['id'] = 50000 + $v['id'];
  325. $info = Dever::db('bill/cash')->one(array('id' => $v['id'], 'clear' => true));
  326. if (!$info) {
  327. $update['id'] = $v['id'];
  328. $update['type'] = 11;
  329. if ($v['uid'] > 0) {
  330. $member = $this->db->fetch('select * from ims_ewei_shop_member where uid = ' . $v['uid'] . ' and isagent = 1 and status = 1 and prestatus = 1');
  331. if ($member) {
  332. $update['mid'] = $member['id'];
  333. }
  334. } elseif ($remark) {
  335. $member = $this->db->fetch('select * from ims_ewei_shop_member where openid = "' . $v['openid'] . '" and isagent = 1 and status = 1 and prestatus = 1');
  336. if ($member) {
  337. $update['mid'] = $member['id'];
  338. }
  339. }
  340. if (isset($update['mid']) && $update['mid'] > 0) {
  341. $update['cash'] = $v['num'];
  342. $update['yue'] = $v['presentcredit'];
  343. $status = 1;
  344. $fstatus = -1;
  345. if ($v['status'] == 0 && $v['check'] == 0) {
  346. # 待审核
  347. $status = 1;
  348. } elseif ($v['status'] != -1 && $v['check'] == 1) {
  349. # 已审核
  350. $status = 2;
  351. } elseif ($v['status'] == 0 && $v['check'] == 1) {
  352. # 待发放
  353. $status = 2;
  354. $fstatus = 1;
  355. } elseif ($v['status'] == 1 && $v['check'] == 1) {
  356. # 已发放
  357. $status = 2;
  358. $fstatus = 2;
  359. } elseif ($v['check'] == -1) {
  360. # 已拒绝
  361. $status = 3;
  362. }
  363. $update['status'] = $status;
  364. $update['audit'] = $status;
  365. $update['cdate'] = $v['createtime'];
  366. $update['operdate'] = $v['checktime'];
  367. $update['order_num'] = Dever::load('bill/lib/cash')->getOrderId();
  368. $id = Dever::db('bill/cash')->insert($update);
  369. if ($id) {
  370. $tixian['order_num'] = Dever::load('bill/lib/tixian')->getOrderId();
  371. $tixian['id'] = $v['id'];
  372. $tixian['cash_id'] = $v['id'];
  373. $tixian['mid'] = $update['mid'];
  374. $tixian['ycash'] = $v['money'];
  375. $tixian['cash'] = $v['realmoney'];
  376. $tixian['yue'] = $v['deductionmoney'];
  377. $tixian['name'] = $v['realname'];
  378. $tixian['bank'] = $this->upBank($v['bankname']);
  379. $tixian['bankname'] = $v['bankopen'];
  380. $tixian['card'] = $v['bankcard'];
  381. $tixian['status'] = $fstatus;
  382. Dever::db('bill/tixian')->insert($tixian);
  383. }
  384. }
  385. }
  386. }
  387. }
  388. }
  389. # 导入关联表
  390. private function getRelation()
  391. {
  392. $data = $this->db->fetchAll('select * from ims_ewei_shop_commission_relation');
  393. if ($data) {
  394. foreach ($data as $k => $v) {
  395. $where['uid'] = $v['pid'];
  396. $where['to_uid'] = $v['id'];
  397. $where['level'] = $v['level'];
  398. $info = Dever::db('invite/relation')->one($where);
  399. if (!$info) {
  400. Dever::db('invite/relation')->insert($where);
  401. }
  402. }
  403. }
  404. }
  405. # 生成合同
  406. private function addAgreement($data)
  407. {
  408. Dever::load('agent/lib/agreement')->up($data);
  409. }
  410. # 更新进度
  411. private function addProcess($order_id, $status, $time, $data)
  412. {
  413. $where['order_id'] = $order_id;
  414. $where['status'] = $status;
  415. $info = Dever::db('agent/order_process')->find($where);
  416. if (!$info) {
  417. if ($status == 3) {
  418. $where['type'] = '1,2,3,5';
  419. }
  420. $where['cdate'] = $time;
  421. Dever::db('agent/order_process')->insert($where);
  422. }
  423. }
  424. # 状态对应
  425. private function getStatus($data)
  426. {
  427. # 完成权益发放issuingstate、财务审核status、初审prestatus的认为订单有效
  428. if ($data['issuingstate'] == 1 && $data['status'] == 1 && $data['prestatus'] == 1) {
  429. return 4;
  430. } elseif ($data['status'] == 1 && $data['prestatus'] == 1) {
  431. return 4;
  432. } elseif ($data['prestatus'] == 1) {
  433. return 2;
  434. } elseif ($data['restatus'] == 1) {
  435. # 审核失败
  436. return 5;
  437. } elseif ($data['trainersign'] && $data['contractsign']) {
  438. return 1;
  439. } else {
  440. return -2;
  441. }
  442. }
  443. # 代理商角色对应
  444. private function getRole($role)
  445. {
  446. # key是历史数据 value是最新数据
  447. $config = array
  448. (
  449. # 创服
  450. 5 => 5,
  451. # 创客
  452. 4 => 6,
  453. # 逍客
  454. 8 => 7,
  455. # 城市
  456. 1 => 2,
  457. # 区县
  458. 2 => 3,
  459. # 街道
  460. 3 => 4,
  461. # 炒菜机分享会员
  462. 6 => 8,
  463. # 热敏炉分享会员
  464. 7 => 9,
  465. );
  466. if (isset($config[$role]) && $config[$role]) {
  467. return $config[$role];
  468. }
  469. return 1;
  470. }
  471. }