Import.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490
  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 '.$this->get_yes_where().' order by id 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. $data = array();
  69. $data['id'] = $v['id'];
  70. $data['mobile'] = $v['mobile'];
  71. $data['name'] = $v['realname'];
  72. $data['avatar'] = $v['avatar'];
  73. $data['username'] = $v['nickname'];
  74. $data['mid'] = $v['id'];
  75. $data['parent_mid'] = $v['agentid'];
  76. $data['admin_desc'] = $v['content'];
  77. $data['parent_code'] = Dever::load("invite/api.code", $data['parent_mid']);
  78. $data['role'] = $this->getRole($v['agentlevel']);
  79. $data['area'] = str_replace(' ', ',', $v['datavalue']);
  80. if ($v['streetvalue']) {
  81. $data['area'] .= ',' . $v['streetvalue'];
  82. }
  83. if ($v['entertype'] == 1) {
  84. $data['type'] = 1;
  85. } else {
  86. $data['type'] = 2;
  87. }
  88. $data['price'] = $v['paymoney'];
  89. $data['f_price'] = $data['price'];
  90. $role = Dever::db('setting/role')->find($data['role']);
  91. if ($role['type'] == 1) {
  92. //$data['f_price'] = $role['price'];
  93. } elseif ($role['type'] == 2) {
  94. /*
  95. $data['f_price'] = Dever::load('area/api')->getPrice($role['area'], $data['area']);
  96. if ($data['f_price'] <= 0) {
  97. $data['f_price'] = $data['price'];
  98. }
  99. */
  100. # 区域要进行占用
  101. if ($data['area']) {
  102. Dever::load('area/api')->upStatus($data['area'], 2);
  103. $area_data = array('mid' => $v['id'], 'order_id' => $v['id'], 'role' => $data['role'], 'area' => $data['area']);
  104. $area_data['type'] = 4;
  105. $area_data['price'] = $data['f_price'];
  106. $area_data['cdate'] = $v['agentapplytime'];
  107. Dever::db('agent/member_area')->insert($area_data);
  108. }
  109. }
  110. $data['agent_cash'] = $data['f_price'];
  111. $data['sign'] = $v['contractsign'] ? $host . $v['contractsign'] : '';
  112. $data['idcard'] = $v['idnumber'];
  113. $data['idcard_front'] = $data['idcard_back'] = '';
  114. if ($v['identity']) {
  115. $identity = Dever::json_decode($v['identity']);
  116. if (isset($identity[0])) {
  117. $data['idcard_front'] = $host . $identity[0];
  118. }
  119. if (isset($identity[1])) {
  120. $data['idcard_back'] = $host . $identity[1];
  121. }
  122. }
  123. $data['company_name'] = $v['company'];
  124. $data['address'] = $v['province'] . $v['city'] . $v['area'] . $v['street'];
  125. $data['pay_type'] = 2;
  126. if ($v['receipt']) {
  127. $receipt = Dever::json_decode($v['receipt']);
  128. $data['pay_pic'] = array();
  129. foreach ($receipt as $k => $v) {
  130. $data['pay_pic'][] = $host . $v;
  131. }
  132. $data['pay_pic'] = implode(',', $data['pay_pic']);
  133. }
  134. $data['status'] = $this->getStatus($v);
  135. $data['audit_desc'] = $v['refuse'];
  136. if ($v['issuingstate'] == 1) {
  137. $data['goods_status'] = 3;
  138. } else {
  139. $data['goods_status'] = 1;
  140. }
  141. $data['pay_status'] = 2;
  142. $data['import'] = $v['olduid'] > 0 ? 3 : 2;
  143. $data['order_num'] = Dever::load('agent/lib/order')->getOrderId();
  144. $data['cdate'] = $v['agentapplytime'];
  145. if ($data['status'] == 4) {
  146. $data['fdate'] = $v['agenttime'];
  147. }
  148. $data['order_type'] = 1;
  149. $data['company_pic'] = '';
  150. $order_id = Dever::db('agent/order')->insert($data);
  151. if ($order_id) {
  152. if (!$v['preagenttime']) {
  153. $v['preagenttime'] = $v['agenttime'];
  154. }
  155. if ($data['status'] == 2) {
  156. $this->addProcess($order_id, 1, $v['preagenttime'], $data);
  157. } elseif ($data['status'] == 3) {
  158. $this->addProcess($order_id, 1, $v['preagenttime'], $data);
  159. $this->addProcess($order_id, 2, $v['agenttime'], $data);
  160. } elseif ($data['status'] == 4) {
  161. $this->addProcess($order_id, 1, $v['preagenttime'], $data);
  162. $this->addProcess($order_id, 2, $v['agenttime'], $data);
  163. $this->addProcess($order_id, 3, $v['agenttime'], $data);
  164. }
  165. # 生成合同
  166. if ($data['sign']) {
  167. $this->addAgreement($data);
  168. }
  169. $member = Dever::db('agent/member')->find($v['id']);
  170. if ($data['status'] == 4) {
  171. $data['status'] = 2;
  172. } elseif ($data['status'] == 5) {
  173. $data['status'] = 1;
  174. $data['state'] = 2;
  175. } else {
  176. $data['status'] = 1;
  177. }
  178. $mc_member = $this->db->fetch('select * from ims_mc_members where uid = ' . $v['uid']);
  179. $data['rdate'] = $v['agenttime'];
  180. $data['cash'] = ($mc_member && $mc_member['credit2']) ? $mc_member['credit2'] : $v['credit2'];
  181. $data['group_sell'] = $v['allcommission'];
  182. Dever::load('invite/api')->setRelation($data['mid'], $data['parent_mid']);
  183. if (!$member) {
  184. Dever::db('agent/member')->insert($data);
  185. } else {
  186. $data['where_id'] = $member['id'];
  187. Dever::db('agent/member')->update($data);
  188. }
  189. }
  190. }
  191. }
  192. $index = $index + 1;
  193. return $index * $limit;
  194. }
  195. # 导入区域价格
  196. private function getAreaPrice()
  197. {
  198. $data = $this->db->fetchAll('select * from ims_ewei_shop_wang_city_other where deleted=0 and hide=0');
  199. if ($data) {
  200. foreach ($data as $k => $v) {
  201. $province = Dever::db('area/province')->one(array('name' => $v['province']));
  202. if ($province && $v['city']) {
  203. $city = Dever::db('area/city')->one(array('name' => $v['city'], 'province_id' => $province['id']));
  204. if ($city && $v['district']) {
  205. $county = Dever::db('area/county')->one(array('name' => $v['district'], 'city_id' => $city['id']));
  206. if ($county && $v['identity'] == 3) {
  207. # 区县
  208. Dever::db('area/county')->update(array('where_id' => $county['id'], 'price' => $v['money']));
  209. } elseif ($county && $v['street'] && $v['identity'] == 4) {
  210. # 街道
  211. if (strstr($v['street'], '燕郊')) {
  212. Dever::db('area/town')->update(array('where_id' => 131082450, 'price' => $v['money']));
  213. Dever::db('area/town')->update(array('where_id' => 131082109, 'price' => $v['money']));
  214. } else {
  215. $town = Dever::db('area/town')->one(array('name' => $v['street'], 'county_id' => $county['id']));
  216. if ($town) {
  217. Dever::db('area/town')->update(array('where_id' => $town['id'], 'price' => $v['money']));
  218. }
  219. }
  220. }
  221. }
  222. }
  223. }
  224. }
  225. }
  226. # 导入余额日志[不包括提现]
  227. private function getYue()
  228. {
  229. $data = $this->db->fetchAll('select * from mc_credits_record where credittype = "credit2" order by id asc');
  230. if ($data) {
  231. foreach ($data as $k => $v) {
  232. if ($v['credittype'] == 'credit2') {
  233. # 直推佣金
  234. $type = 1;
  235. } elseif ($v['credittype'] == 'credit3') {
  236. # 市场培训费
  237. $type = 2;
  238. } else {
  239. continue;
  240. }
  241. $remark = $v['remark'];
  242. if (strstr($remark, '提现')) {
  243. continue;
  244. }
  245. $info = Dever::db('bill/cash')->one(array('id' => $v['id'], 'clear' => true));
  246. if (!$info) {
  247. $update['id'] = $v['id'];
  248. $update['type'] = $type;
  249. if ($v['uid'] > 0) {
  250. $member = $this->db->fetch('select * from ims_ewei_shop_member where uid = ' . $v['uid'] . ' and isagent = 1 and status = 1 and prestatus = 1');
  251. if ($member) {
  252. $update['mid'] = $member['id'];
  253. }
  254. } elseif ($remark) {
  255. $temp = explode('OPENID: ', $remark);
  256. $temp = explode(' 剩余', $temp[1]);
  257. if (isset($temp[0]) && $temp[0]) {
  258. $member = $this->db->fetch('select * from ims_ewei_shop_member where openid = "' . $temp[0] . '" and isagent = 1 and status = 1 and prestatus = 1');
  259. if ($member) {
  260. $update['mid'] = $member['id'];
  261. }
  262. }
  263. }
  264. if (isset($update['mid']) && $update['mid'] > 0) {
  265. if (strstr($remark, '消费')) {
  266. $type = 12;
  267. }
  268. $update['cash'] = $v['num'];
  269. $update['yue'] = $v['presentcredit'];
  270. $update['status'] = 2;
  271. $update['audit'] = 2;
  272. $update['cdate'] = $update['operdate'] = $v['createtime'];
  273. $update['order_num'] = Dever::load('bill/lib/cash')->getOrderId();
  274. Dever::db('bill/cash')->insert($update);
  275. }
  276. }
  277. }
  278. }
  279. }
  280. # 获取提现
  281. private function getTixian()
  282. {
  283. $data = $this->db->fetchAll('select * from ims_ewei_shop_member_log where type > 0');
  284. if ($data) {
  285. foreach ($data as $k => $v) {
  286. $v['id'] = 50000 + $v['id'];
  287. $info = Dever::db('bill/cash')->one(array('id' => $v['id'], 'clear' => true));
  288. if (!$info) {
  289. $update['id'] = $v['id'];
  290. $update['type'] = 11;
  291. if ($v['uid'] > 0) {
  292. $member = $this->db->fetch('select * from ims_ewei_shop_member where uid = ' . $v['uid'] . ' and isagent = 1 and status = 1 and prestatus = 1');
  293. if ($member) {
  294. $update['mid'] = $member['id'];
  295. }
  296. } elseif ($remark) {
  297. $member = $this->db->fetch('select * from ims_ewei_shop_member where openid = "' . $v['openid'] . '" and isagent = 1 and status = 1 and prestatus = 1');
  298. if ($member) {
  299. $update['mid'] = $member['id'];
  300. }
  301. }
  302. if (isset($update['mid']) && $update['mid'] > 0) {
  303. $update['cash'] = $v['num'];
  304. $update['yue'] = $v['presentcredit'];
  305. $status = 1;
  306. $fstatus = -1;
  307. if ($v['status'] == 0 && $v['check'] == 0) {
  308. # 待审核
  309. $status = 1;
  310. } elseif ($v['status'] != -1 && $v['check'] == 1) {
  311. # 已审核
  312. $status = 2;
  313. } elseif ($v['status'] == 0 && $v['check'] == 1) {
  314. # 待发放
  315. $status = 2;
  316. $fstatus = 1;
  317. } elseif ($v['status'] == 1 && $v['check'] == 1) {
  318. # 已发放
  319. $status = 2;
  320. $fstatus = 2;
  321. } elseif ($v['check'] == -1) {
  322. # 已拒绝
  323. $status = 3;
  324. }
  325. $update['status'] = $status;
  326. $update['audit'] = $status;
  327. $update['cdate'] = $v['createtime'];
  328. $update['operdate'] = $v['checktime'];
  329. $update['order_num'] = Dever::load('bill/lib/cash')->getOrderId();
  330. $id = Dever::db('bill/cash')->insert($update);
  331. if ($id) {
  332. $tixian['order_num'] = Dever::load('bill/lib/tixian')->getOrderId();
  333. $tixian['id'] = $v['id'];
  334. $tixian['cash_id'] = $v['id'];
  335. $tixian['mid'] = $update['mid'];
  336. $tixian['ycash'] = $v['money'];
  337. $tixian['cash'] = $v['realmoney'];
  338. $tixian['yue'] = $v['deductionmoney'];
  339. $tixian['name'] = $v['realname'];
  340. $tixian['bank'] = $this->upBank($v['bankname']);
  341. $tixian['bankname'] = $v['bankopen'];
  342. $tixian['card'] = $v['bankcard'];
  343. $tixian['status'] = $fstatus;
  344. Dever::db('bill/tixian')->insert($tixian);
  345. }
  346. }
  347. }
  348. }
  349. }
  350. }
  351. # 导入关联表
  352. private function getRelation()
  353. {
  354. $data = $this->db->fetchAll('select * from ims_ewei_shop_commission_relation');
  355. if ($data) {
  356. foreach ($data as $k => $v) {
  357. $where['uid'] = $v['pid'];
  358. $where['to_uid'] = $v['id'];
  359. $where['level'] = $v['level'];
  360. $info = Dever::db('invite/relation')->one($where);
  361. if (!$info) {
  362. Dever::db('invite/relation')->insert($where);
  363. }
  364. }
  365. }
  366. }
  367. # 生成合同
  368. private function addAgreement($data)
  369. {
  370. Dever::load('agent/lib/agreement')->up($data);
  371. }
  372. # 更新进度
  373. private function addProcess($order_id, $status, $time, $data)
  374. {
  375. return;
  376. $where['order_id'] = $order_id;
  377. $where['status'] = $status;
  378. $info = Dever::db('agent/order_process')->find($where);
  379. if (!$info) {
  380. if ($status == 3) {
  381. $where['type'] = '1,2,3,5';
  382. }
  383. $where['cdate'] = $time;
  384. Dever::db('agent/order_process')->insert($where);
  385. }
  386. }
  387. # 状态对应
  388. private function getStatus($data)
  389. {
  390. # 完成权益发放issuingstate、财务审核status、初审prestatus的认为订单有效
  391. if ($data['issuingstate'] == 1 && $data['status'] == 1 && $data['prestatus'] == 1) {
  392. return 4;
  393. } elseif ($data['status'] == 1 && $data['prestatus'] == 1) {
  394. return 4;
  395. } elseif ($data['prestatus'] == 1) {
  396. return 2;
  397. } elseif ($data['restatus'] == 1) {
  398. # 审核失败
  399. return 5;
  400. } elseif ($data['trainersign'] && $data['contractsign']) {
  401. return 1;
  402. } else {
  403. return -2;
  404. }
  405. }
  406. # 代理商角色对应
  407. private function getRole($role)
  408. {
  409. # key是历史数据 value是最新数据
  410. $config = array
  411. (
  412. # 创服
  413. 5 => 5,
  414. # 创客
  415. 4 => 6,
  416. # 逍客
  417. 8 => 7,
  418. # 城市
  419. 1 => 2,
  420. # 区县
  421. 2 => 3,
  422. # 街道
  423. 3 => 4,
  424. # 炒菜机分享会员
  425. 6 => 8,
  426. # 热敏炉分享会员
  427. 7 => 9,
  428. );
  429. if (isset($config[$role]) && $config[$role]) {
  430. return $config[$role];
  431. }
  432. return 1;
  433. }
  434. }