Manage.php 48 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222
  1. <?php
  2. namespace Agent\Lib;
  3. use Dever;
  4. class Manage
  5. {
  6. public function import($file)
  7. {
  8. $file = Dever::local($file);
  9. echo $file;die;
  10. }
  11. public function agentOut($data)
  12. {
  13. $file = Dever::input('excel_name');
  14. $header = array('姓名', '手机号', '身份证号', '代理角色', '代理商区域', '代理费', '余额', '直推业绩', '团队业绩', '注册时间', '注册完成时间', '推荐人', '推荐人电话', '推荐人代理角色');
  15. $body = array();
  16. if ($data) {
  17. foreach ($data as $k => $v) {
  18. $prize_type = '';
  19. if (is_array($v)) {
  20. if ($v['role']) {
  21. $role = Dever::db('setting/role')->find($v['role']);
  22. if($v['role'] == 8){
  23. if($v['prize_type'] == 1){
  24. $prize_type = '-名额外';
  25. }elseif($v['prize_type'] == 2){
  26. $prize_type = '-名额内';
  27. }
  28. }
  29. } else {
  30. $role = array('name' => '普通代理',);
  31. }
  32. $order = Dever::db('agent/order')->find(array('mid' => $v['id']));
  33. $agent_cash = 0;
  34. if ($order) {
  35. $agent_cash = $order['agent_cash'];
  36. }
  37. $area = Dever::load("area/api.string", $v['area']);
  38. if ($v['rdate']) {
  39. $rdate = date('Y-m-d H:i',$v['rdate']);
  40. } else {
  41. $rdate = '-';
  42. }
  43. $parent_name = '';
  44. $parent_mobile = '';
  45. $parent_rolename = '';
  46. if ($v['parent_mid'] && $v['parent_mid'] > 0) {
  47. $parent = Dever::db('agent/member')->find(array('id'=>$v['parent_mid']));
  48. if ($parent) {
  49. if($parent['role']){
  50. $parent_role = Dever::db('setting/role')->find(array('id'=>$parent['role']));
  51. if($parent_role){
  52. $parent_rolename = $parent_role['name'];
  53. }
  54. }
  55. if($parent['name']){
  56. $parent_name = $parent['name'];
  57. }
  58. if($parent['mobile']){
  59. $parent_mobile = $parent['mobile'];
  60. }
  61. }
  62. }
  63. $d = array
  64. (
  65. $v['name'],
  66. $v['mobile'],
  67. $v['idcard'],
  68. $role['name'].$prize_type,
  69. $area,
  70. $agent_cash,
  71. $v['cash'],
  72. $v['sell'],
  73. $v['group_sell'],
  74. date('Y-m-d H:i',$v['cdate']),
  75. $rdate,
  76. $parent_name,
  77. $parent_mobile,
  78. $parent_rolename,
  79. );
  80. $body[] = $d;
  81. }
  82. }
  83. }
  84. return Dever::excelExport($body, $header, $file);
  85. }
  86. public function agentCashOut($data)
  87. {
  88. $db = Dever::db('agent/test:old');
  89. $file = Dever::input('excel_name');
  90. $header = array('姓名', '手机号', '代理角色', '交款金额', '直推佣金', '团队佣金', '注册时间');
  91. $body = array();
  92. if ($data) {
  93. foreach ($data as $k => $v) {
  94. if ($v['rdate'] > 0) {
  95. if ($v['role']) {
  96. $role = Dever::db('setting/role')->find($v['role']);
  97. } else {
  98. $role = array('name' => '普通代理',);
  99. }
  100. $order = Dever::db('agent/order')->find(array('mid' => $v['id']));
  101. $price = 0;
  102. if ($order) {
  103. $price = $order['price'];
  104. }
  105. $cash_zt = 0;
  106. $cash_group = 0;
  107. $cash = Dever::db('bill/cash')->getCash(array('type' => 1, 'mid' => $v['id']));
  108. if ($cash) {
  109. $cash_zt = $cash['total'];
  110. }
  111. $cash = Dever::db('bill/cash')->getCash(array('type' => 2, 'mid' => $v['id']));
  112. if ($cash) {
  113. $cash_group = $cash['total'];
  114. }
  115. if (!$cash_group) {
  116. $cash_group = 0;
  117. }
  118. if ($v['id'] < 50000) {
  119. $info = $db->fetch('select * from ims_ewei_shop_member where id = ' . $v['id']);
  120. if ($info) {
  121. $member = $db->fetch('select * from ims_mc_members where uid = ' . $info['uid']);
  122. $cash_zt += ($member && $member['credit2']) ? $member['credit2'] : $info['credit2'];
  123. }
  124. }
  125. $cdate = date('Y-m-d H:i', $v['rdate']);
  126. $d = array
  127. (
  128. $v['name'],
  129. $v['mobile'],
  130. $role['name'],
  131. $price,
  132. $cash_zt,
  133. $cash_group,
  134. $cdate,
  135. );
  136. $body[] = $d;
  137. }
  138. }
  139. }
  140. return Dever::excelExport($body, $header, $file);
  141. }
  142. public function relation_api()
  143. {
  144. $admin = Dever::load('manage/auth.data');
  145. if ($admin['role'] != 1) {
  146. Dever::alert('无法访问');
  147. }
  148. $data = array();
  149. $data['mobile'] = Dever::input('mobile');
  150. $member = Dever::db('agent/member')->find(array('mobile' => $data['mobile']));
  151. $data['mid'] = $member['id'];
  152. // Dever::input('mid');
  153. $data['link'] = Dever::decode(Dever::input('refer'));
  154. return Dever::render('index', $data);
  155. }
  156. # 后台设置区域
  157. public function updateArea($id, $name, $data)
  158. {
  159. Dever::config('base')->hook = true;
  160. $id = $id['where_id'];
  161. $is_area = Dever::param('is_area', $data);
  162. $area = Dever::param('area', $data);#修改后
  163. $role = Dever::param('role', $data);
  164. $level_id = Dever::param('level_id', $data);
  165. $member = Dever::db('agent/member')->find($id);
  166. if (!$member) {
  167. return;
  168. }
  169. if (!$is_area) {
  170. $is_area = 1;
  171. }
  172. if ($is_area == 1) {
  173. if ($area && is_array($area) && $role) {
  174. $role = Dever::db('setting/role')->find($role);
  175. $area_string = array();
  176. if ($role && $role['type'] == 2) {
  177. $area_string = Dever::load('agent/lib/order')->checkArea($area, $role, $member['id']);
  178. } else {
  179. $area_string = implode(',', $area);
  180. }
  181. $area_string = str_replace(',-1', '', $area_string);
  182. $data['set_area'] = $area_string;
  183. if ($area_string == $member['area']) {
  184. $area_string = '';
  185. }
  186. $this->upLog($member, $role, $area_string, -1, 3);
  187. }
  188. } else {
  189. # 清理区域
  190. $role = Dever::db('setting/role')->find($member['role']);
  191. if ($role && $role['type'] == 2) {
  192. $area = $member['area'];
  193. Dever::load('area/api')->upStatus($area, 1);
  194. $area_data['mid'] = $member['id'];
  195. $area_data['area'] = $area;
  196. $area_info = Dever::db('agent/member_area')->find($area_data);
  197. if ($area_info) {
  198. Dever::db('agent/member_area')->update(array('where_id' => $area_info['id'], 'state' => 2));
  199. Dever::db('agent/member')->update(array('where_id' => $member['id'], 'area' => ''));
  200. //Dever::load('agent/lib/order')->editArea($member, '');
  201. $this->area_log($member['id'], -1, $member['area'], '');
  202. }
  203. $data['set_area'] = 'null';
  204. }
  205. }
  206. if ($level_id && $level_id != $member['level_id']) {
  207. $group_num = Dever::load('invite/api')->getChildNum($member['id'], 1);
  208. Dever::load('agent/lib/level_log')->up($member['id'], -1, $member['level_id'], $level_id, 0, 0, $group_num);
  209. }
  210. $name = Dever::param('name', $data);
  211. if ($name) {
  212. $order = Dever::db('agent/order')->select(array('mid' => $member['id']));
  213. if ($order) {
  214. foreach ($order as $k => $v) {
  215. if ($v['status'] <= 2) {
  216. Dever::db('agent/order')->update(array('where_id' => $v['id'], 'name' => $name));
  217. }
  218. }
  219. }
  220. }
  221. $mobile = Dever::param('mobile', $data);
  222. if ($mobile) {
  223. # 验证手机号是否可以修改
  224. $mobile_member = Dever::db('agent/member')->find(array('mobile' => $mobile));
  225. if ($mobile_member && $mobile_member['id'] != $member['id']) {
  226. Dever::alert('无法修改手机号,当前手机号已被代理商'.$mobile_member['name'].'使用');
  227. }
  228. # 是否同步修改期权表
  229. $option_member = Dever::db('option/member')->find(array('mobile' => $member['mobile'], 'main' => 2));
  230. if ($option_member) {
  231. $mobile_member = Dever::db('option/member')->find(array('mobile' => $mobile));
  232. if ($mobile_member && $mobile_member['id'] != $option_member['id']) {
  233. Dever::alert('无法修改手机号,当前手机号已被代理商期权账户'.$mobile_member['name'].'使用');
  234. }
  235. Dever::db('option/member')->update(array('where_id' => $option_member['id'], 'mobile' => $mobile));
  236. }
  237. # 同步修改其他表的手机号
  238. Dever::db('agent/member_agreement')->updates(array('option_mid' => $member['id'], 'set_mobile' => $mobile));
  239. Dever::db('agent/dh_order')->updates(array('option_mid' => $member['id'], 'set_mobile' => $mobile));
  240. Dever::db('agent/order')->updates(array('option_mid' => $member['id'], 'set_mobile' => $mobile));
  241. Dever::db('agent/user_bind')->updates(array('option_mid' => $member['id'], 'set_mobile' => $mobile));
  242. Dever::db('agent/soft_cash')->updates(array('option_mid' => $member['id'], 'set_mobile' => $mobile));
  243. }
  244. $shop_id = Dever::param('shop_id', $data);
  245. if ($shop_id && $member['shop_id'] != $shop_id) {
  246. $insert['mid'] = $member['id'];
  247. $insert['new_shop_id'] = $shop_id;
  248. $info = Dever::db('agent/member_shop_log')->find($insert);
  249. if (!$info) {
  250. $insert['old_shop_id'] = $member['shop_id'];
  251. Dever::db('agent/member_shop_log')->insert($insert);
  252. }
  253. }
  254. return $data;
  255. }
  256. # 更改日志
  257. private function upLog($member, $role, $area, $order_id = -1, $type = 3, $price = 0)
  258. {
  259. if (is_numeric($role)) {
  260. $role = Dever::db('setting/role')->find($role);
  261. }
  262. if (!$role) {
  263. return;
  264. }
  265. $this->upRole($member, $role, $area, $order_id);
  266. if ($area) {
  267. $this->upArea($member, $role, $area, $order_id, $type, $price);
  268. }
  269. }
  270. private function upRole($member, $role, $area, $order_id = -1)
  271. {
  272. if ($role['id'] == $member['role']) {
  273. return;
  274. }
  275. $data['mid'] = $member['id'];
  276. $data['order_id'] = $order_id;
  277. $data['old_role'] = $member['role'];
  278. $data['new_role'] = $role['id'];
  279. if ($area) {
  280. $data['area'] = $area;
  281. } else {
  282. $data['area'] = $member['area'];
  283. }
  284. if ($order_id && $order_id > 0) {
  285. $data['type'] = 1;
  286. $order = Dever::db('agent/order')->find($order_id);
  287. $data['price'] = $order['price'];
  288. } else {
  289. $data['type'] = 2;
  290. $admin = Dever::load('manage/auth.info');
  291. $data['audit_admin'] = $admin['id'];
  292. }
  293. Dever::db('agent/member_account_log')->insert($data);
  294. }
  295. public function upArea($member, $role, $area, $order_id = -1, $type = 3, $price = 0)
  296. {
  297. if (!$role) {
  298. return;
  299. }
  300. if ($area == $member['area']) {
  301. //return;
  302. }
  303. $area_data = array('mid' => $member['id']);
  304. $area_info = Dever::db('agent/member_area')->getOne($area_data);
  305. if ($area_info) {
  306. Dever::db('agent/member_area')->update(array('where_id' => $area_info['id'], 'state' => 2));
  307. }
  308. if ($role && $role['type'] == 2) {
  309. Dever::load('area/api')->upStatus($area, 2);
  310. $area_data['order_id'] = $order_id;
  311. $area_data['role'] = $role['id'];
  312. $area_data['area'] = $area;
  313. $area_data['type'] = $type;
  314. $area_data['price'] = $price;
  315. $area_data['status'] = 1;
  316. Dever::db('agent/member_area')->insert($area_data);
  317. //Dever::load('agent/lib/order')->editArea($v, $area);
  318. }
  319. $this->area_log($member['id'], $order_id, $member['area'], $area);
  320. }
  321. # 获取
  322. # 设置上级
  323. public function setParent_commit($id, $name, $data)
  324. {
  325. //Dever::alert('暂未开放');
  326. Dever::config('base')->hook = true;
  327. $mid = Dever::param('mid', $data);
  328. $parent_mobile = trim(Dever::param('parent_mobile', $data));
  329. if ($mid && $parent_mobile) {
  330. $member = Dever::db('agent/member')->find($mid);
  331. $parent = Dever::db('agent/member')->find(array('mobile' => $parent_mobile));
  332. if ($parent && $parent['status'] == 2) {
  333. if ($member['parent_mid'] == $parent['id']) {
  334. Dever::alert('上级代理商设置失败');
  335. return;
  336. }
  337. if ($member['parent_mid'] == $mid) {
  338. Dever::alert('上级代理商不能设置为自己');
  339. return;
  340. }
  341. # 重置关系
  342. Dever::load('invite/api')->resetRelation($mid, $parent['id']);
  343. /*
  344. # 删除之前关系
  345. Dever::load('invite/api')->dropRelation($mid, $parent['id']);
  346. # 获取所有下级
  347. $child = Dever::load('invite/api')->getChild($mid);
  348. if ($child) {
  349. foreach ($child as $k => $v) {
  350. Dever::load('invite/api')->dropRelation($v['to_uid'], $parent['id']);
  351. }
  352. }
  353. # 重新设置关系
  354. Dever::load('invite/api')->setRelation($mid, $parent['id']);
  355. */
  356. Dever::db('agent/member')->update(array('where_id' => $mid, 'parent_mid' => $parent['id']));
  357. } else {
  358. Dever::alert('上级代理商还未注册或者已封禁');
  359. }
  360. }
  361. }
  362. public function orderUpdateParent($id, $name, $data)
  363. {
  364. Dever::config('base')->hook = true;
  365. $id = $id['where_id'];
  366. $order = Dever::db('agent/order')->find($id);
  367. if (!$order) {
  368. return;
  369. }
  370. $area = Dever::param('area', $data);#修改后
  371. $role = Dever::param('role', $data);
  372. $invite_type = Dever::param('invite_type', $data);
  373. $parent_code = Dever::param('parent_code', $data);
  374. if ($invite_type == 1 && $parent_code) {
  375. $parent_mid = Dever::load('invite/api')->getUid($parent_code);
  376. if ($parent_mid) {
  377. $parent_member = Dever::db('agent/member')->find($parent_mid);
  378. if (!$parent_member) {
  379. Dever::alert('错误的邀请码');
  380. }
  381. if ($order['mid'] == $parent_member['id']) {
  382. Dever::alert('邀请人不能是自己');
  383. }
  384. $data['set_parent_mid'] = $parent_mid;
  385. //Dever::db('agent/member')->update(array('where_id' => $order['mid'], 'parent_mid' => $parent_mid));
  386. } else {
  387. Dever::alert('错误的邀请码');
  388. }
  389. }
  390. if ($area && is_array($area) && $role) {
  391. $role = Dever::db('setting/role')->find($role);
  392. $area_string = array();
  393. if ($role && $role['type'] == 2) {
  394. $area_string = Dever::load('agent/lib/order')->checkArea($area, $role, $order['mid']);
  395. } else {
  396. $area_string = implode(',', $area);
  397. $area_string = str_replace(',-1', '', $area_string);
  398. }
  399. if ($role['type'] == 1) {
  400. $data['set_f_price'] = $data['set_price'] = $role['price'];
  401. } elseif ($role['type'] == 2) {
  402. $data['set_f_price'] = $data['set_price'] = Dever::load('area/api')->getPrice($role['area'], $area_string);
  403. } else {
  404. $data['set_f_price'] = $data['set_price'] = 0;
  405. }
  406. $data['set_area'] = $area_string;
  407. }
  408. return $data;
  409. }
  410. public function orderStartUpdate($id, $name, $data)
  411. {
  412. $order_id = Dever::param('order_id', $data);
  413. if ($order_id) {
  414. $order = Dever::db('agent/order')->find($order_id);
  415. if ($order && $order['source_id'] < 0) {
  416. if ($order['parent_mid'] > 0) {
  417. $member = Dever::db('agent/member')->find($order['parent_mid']);
  418. if ($member['status'] == 2) {
  419. return $data;
  420. }
  421. }
  422. Dever::alert('直属上级未认证,无法进行初审');
  423. }
  424. }
  425. }
  426. public function orderUpdate($id, $name, $data)
  427. {
  428. Dever::config('base')->hook = true;
  429. $audit = Dever::param('audit', $data);
  430. $status = Dever::param('status', $data);
  431. $desc = Dever::param('desc', $data);
  432. $order_id = Dever::param('order_id', $data);
  433. $order = Dever::db('agent/order')->find($order_id);
  434. if ($order_id && $order && $status) {
  435. $admin = Dever::load('manage/auth.info');
  436. if ($admin) {
  437. Dever::db('agent/order_process')->update(array('where_id' => $id, 'admin' => $admin['id']));
  438. }
  439. if ($status < 3) {
  440. if ($audit == 1) {
  441. $update = array('where_id' => $order_id, 'status' => $status+1);
  442. if ($status == 1) {
  443. $soft_price = Dever::param('soft_price', $data);
  444. $price = Dever::param('price', $data);
  445. $prize_type = Dever::param('prize_type', $data);
  446. $option_price = Dever::param('option_price', $data);
  447. if ($prize_type == 2) {
  448. # 扣减已有名额,判断一下 暂时废弃
  449. $prize = Dever::db('setting/prize')->find(array('type' => 1, 'price' => $order['price']));
  450. if ($prize) {
  451. $member_goods = Dever::db('agent/member_goods')->getOne(array('mid' => $order['mid'], 'type' => 3, 'type_id' => $prize['id']));
  452. if ($member_goods && $member_goods['num'] > 0) {
  453. # 有名额
  454. $price = 0;
  455. # 开始扣减
  456. $member = Dever::db('agent/member')->find($order['mid']);
  457. Dever::load('agent/lib/dhorder')->action($member, $prize['name'], $prize['num'], $prize['price'], array(), -1, 2, 3, $prize['id'], $desc);
  458. }
  459. }
  460. }
  461. if ($price <= 0) {
  462. $update['get_type'] = 2;
  463. } else {
  464. $update['get_type'] = 1;
  465. }
  466. $update['price'] = $price;
  467. $update['agent_cash'] = $price;
  468. $update['soft_cash'] = 0;
  469. $update['option_price']=$option_price;
  470. $cstatus = Dever::param('cstatus', $data);
  471. if ($cstatus && $cstatus == 2 && $price > 0) {
  472. # 拆分代理费
  473. if ($soft_price > 0) {
  474. $update['agent_cash'] = $price - $soft_price;
  475. $update['soft_cash'] = $soft_price;
  476. } else {
  477. $role = Dever::db('setting/role')->one($order['role']);
  478. if ($role && $role['soft']) {
  479. if (strstr($role['soft'], '%')) {
  480. $role['soft'] = str_replace('%', '', $role['soft']);
  481. $role['soft'] = $price * ($role['soft']/100);
  482. }
  483. $update['agent_cash'] = $price - $role['soft'];
  484. $update['soft_cash'] = $role['soft'];
  485. }
  486. }
  487. }
  488. # 增加业绩
  489. //Dever::load('bill/lib/sell')->up($order['mid'], 2, $order['price'], $order['role'], $order['id'], $order['name'] . '成为代理商');
  490. } elseif ($status == 2) {
  491. if ($order['mid'] && $order['mid'] > 0 && $order['parent_mid'] && $order['parent_mid'] > 0) {
  492. Dever::load('invite/api')->setRelation($order['mid'], $order['parent_mid']);
  493. Dever::db('agent/member')->update(array('where_id' => $order['mid'], 'parent_mid' => $order['parent_mid']));
  494. }
  495. $update['pay_status'] = 2;
  496. Dever::load('agent/lib/member')->create($order);
  497. }
  498. Dever::db('agent/order')->update($update);
  499. } else {
  500. Dever::db('agent/order')->update(array('where_id' => $order_id, 'status' => 5, 'history_status' => $order['status'], 'audit_desc' => $desc));
  501. if (Dever::project('sms')) {
  502. Dever::load('sms/api')->send('daili_reg_no', $order['mobile'], array('name' => $order['name'], 'content' => $desc));
  503. }
  504. }
  505. } elseif ($status == 3) {
  506. $info = Dever::db('agent/order_process')->find(array('id' => $id, 'clear' => true));
  507. if ($info && $info['status'] == 3) {
  508. $info['type'] = explode(',', $info['type']);
  509. }
  510. if (in_array(2, $info['type'])) {
  511. $goods_status = 3;
  512. } else {
  513. $goods_status = 2;
  514. }
  515. $curtime = time();
  516. Dever::db('agent/order')->update(array('where_id' => $order_id, 'fdate' => $curtime, 'status' => 4, 'goods_status' => $goods_status));
  517. # 通知短信
  518. if (Dever::project('sms')) {
  519. $order = Dever::db('agent/order')->find($order_id);
  520. Dever::load('sms/api')->send('daili_reg_yes', $order['mobile'], array('name' => $order['name']));
  521. }
  522. $order = Dever::db('agent/order')->find($order_id);
  523. if ($order && $order['mid']) {
  524. $member = Dever::db('agent/member')->find($order['mid']);
  525. $update['where_id'] = $order['mid'];
  526. if ($member && $member['status'] == 1) {
  527. $update['status'] = 2;
  528. $update['rdate'] = $curtime;
  529. }
  530. $update['area'] = $order['area'];
  531. $update['role'] = $order['role'];
  532. $update['udate'] = $curtime;
  533. Dever::db('agent/member')->update($update);
  534. if ($order['price'] > 0) {
  535. $type = 1;
  536. } else {
  537. $type = 2;
  538. }
  539. $this->upLog($member, $order['role'], $order['area'], $order['id'], $type, $order['price']);
  540. }
  541. }
  542. }
  543. }
  544. #区域日志
  545. public function area_log($mid,$order_id,$old_area, $area) {
  546. $data['mid']=$mid;
  547. $data['order_id']=$order_id;
  548. $data['old_area']=$old_area;
  549. $data['area']=$area;
  550. if ($order_id && $order_id > 0) {
  551. $data['type'] = 1;
  552. } else {
  553. $admin = Dever::load('manage/auth.info');
  554. $data['audit_admin'] = $admin['id'];
  555. $data['type'] = 2;
  556. }
  557. $id = Dever::db('agent/member_area_log')->insert($data);
  558. return $id;
  559. }
  560. # 发放权益
  561. public function set_commit_api()
  562. {
  563. Dever::config('base')->hook = true;
  564. $type = Dever::input('type', 2);
  565. $order_id = Dever::input('order_id');
  566. # 检测是否发放过了
  567. $order = Dever::db('agent/order')->find($order_id);
  568. if ($order['status'] != 3) {
  569. //Dever::alert('无发放权限');
  570. }
  571. $order_process = Dever::db('agent/order_process')->find(array('order_id' => $order_id, 'status' => 3));
  572. $yes = -1;
  573. if (!$order_process) {
  574. # 可以发放
  575. $yes = 1;
  576. } elseif ($order_process) {
  577. $order_process['type'] = explode(',', $order_process['type']);
  578. if (!in_array($type, $order_process['type'])) {
  579. # 可以发放
  580. $yes = 2;
  581. }
  582. }
  583. if ($yes > 0) {
  584. if ($yes == 1) {
  585. $data['order_id'] = $order_id;
  586. $data['status'] = 3;
  587. $data['type'] = '1,' . $type;
  588. $state = Dever::db('agent/order_process')->insert($data);
  589. } else {
  590. $data['where_id'] = $order_process['id'];
  591. $order_process['type'][] = $type;
  592. $data['type'] = implode(',', $order_process['type']);
  593. $state = Dever::db('agent/order_process')->update($data);
  594. }
  595. if ($state) {
  596. if ($type == 2) {
  597. $this->setGoods($order);
  598. } elseif ($type == 3) {
  599. $this->setCash($order);
  600. } elseif ($type == 5) {
  601. $this->setAgreement($order);
  602. }
  603. }
  604. return 'reload';
  605. } else {
  606. Dever::alert('无发放权限');
  607. }
  608. }
  609. # 设置多个权益
  610. private function setGoods($order)
  611. {
  612. $t = 1;
  613. $goods = Dever::db('agent/order_goods')->getData(array('order_id' => $order['id']));
  614. if (!$goods) {
  615. $goods = Dever::db('setting/role_goods')->getData(array('role_id' => $order['role'], 'give' => $order['order_type']));
  616. $t = intval($order['agent_cash']/10000);
  617. if ($t <= 0) {
  618. $t = 1;
  619. }
  620. }
  621. if ($goods) {
  622. $where = array();
  623. $goods_cash = 0;
  624. foreach ($goods as $k => $v) {
  625. $price = $this->addGoods($order, $v, $t);
  626. if ($price && $v['type'] < 3) {
  627. # 计算商品价值
  628. $goods_cash += $price;
  629. }
  630. }
  631. $update = array();
  632. if ($goods_cash) {
  633. $update['goods_cash'] = $goods_cash;
  634. }
  635. $update['goods_status'] = 3;
  636. $update['where_id'] = $order['id'];
  637. Dever::db('agent/order')->update($update);
  638. }
  639. }
  640. # 新增权益
  641. private function addGoods($order, $v, $t)
  642. {
  643. $cash = $price = 0;
  644. if ($v['type'] == 1) {
  645. $v['num'] = $v['num'] * $t;
  646. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['type_id'], $v['sku_id']);
  647. $price = $goods_info['price'];
  648. $cash = $goods_info['price'] * $v['num'];
  649. if (isset($goods_info['sku'])) {
  650. $sku = '-' . $goods_info['sku']['string'];
  651. } else {
  652. $sku = '';
  653. }
  654. $name = $goods_info['name'] . $sku;
  655. } elseif ($v['type'] == 2) {
  656. $v['sku_id'] = -1;
  657. # 生成一个电子券
  658. $card = Dever::db('card/info')->find($v['type_id']);
  659. if (!$card) {
  660. return false;
  661. }
  662. $name = $card['name'];
  663. if ($card['create_type'] == 2) {
  664. $cash = $card['value']*$v['num'] * $t;
  665. $price = $cash;
  666. $v['num'] = 1;
  667. $v['sku_id'] = Dever::load('card/lib/code')->create($card, 2, $order['mid'], $order['id'], $cash);
  668. if (!$v['sku_id']) {
  669. return false;
  670. }
  671. } elseif ($card['create_type'] == 3) {
  672. $cash = round($order['agent_cash']*($v['num']/100), 2);
  673. $price = $cash;
  674. $v['num'] = 1;
  675. $v['sku_id'] = Dever::load('card/lib/code')->create($card, 2, $order['mid'], $order['id'], $cash);
  676. if (!$v['sku_id']) {
  677. return false;
  678. }
  679. } else {
  680. $cash = $card['value'];
  681. $price = $cash;
  682. $total = $t*$v['num'];
  683. $t = 1;
  684. for($i=0; $i<$total;$i++) {
  685. $v['sku_id'] = Dever::load('card/lib/code')->create($card, 2, $order['mid'], $order['id'], $cash);
  686. if ($v['sku_id']) {
  687. $where['mid'] = $order['mid'];
  688. $where['type'] = $v['type'];
  689. $where['type_id'] = $v['type_id'];
  690. $where['sku_id'] = $v['sku_id'];
  691. $info = Dever::db('agent/member_goods')->find($where);
  692. if (!$info) {
  693. $up = $where;
  694. $up['total_num'] = $t;
  695. $up['cash'] = $cash;
  696. $up['price'] = $price;
  697. $up['name'] = $name;
  698. $state = Dever::db('agent/member_goods')->insert($up);
  699. if ($state) {
  700. Dever::load('agent/lib/member_set')->log($order['mid'], $order['order_num'], $v['type'], $v['type_id'], $v['sku_id'], $t, 0, $t, $name);
  701. }
  702. }
  703. }
  704. }
  705. return $cash * $total;
  706. }
  707. } elseif ($v['type'] == 3) {
  708. $prize = Dever::db('setting/prize')->find($v['type_id']);
  709. $v['num'] = $v['num'] * $t;
  710. $role = Dever::db('setting/role')->find($order['role']);
  711. if ($role && $role['max_me_num'] && $role['max_me_num'] < $v['num']) {
  712. $v['num'] = $role['max_me_num'];
  713. }
  714. $price = $prize['price'];
  715. $cash = $prize['price']*$v['num'];
  716. $name = $prize['name'];
  717. }
  718. $where['mid'] = $order['mid'];
  719. $where['type'] = $v['type'];
  720. $where['type_id'] = $v['type_id'];
  721. $where['sku_id'] = $v['sku_id'];
  722. $info = Dever::db('agent/member_goods')->find($where);
  723. if ($info) {
  724. $up['where_id'] = $info['id'];
  725. $up['total_num'] = $info['total_num'] + $v['num'];
  726. $up['cash'] = $cash;
  727. $up['price'] = $price;
  728. $up['name'] = $name;
  729. $state = Dever::db('agent/member_goods')->update($up);
  730. if ($state) {
  731. Dever::load('agent/lib/member_set')->log($order['mid'], $order['order_num'], $v['type'], $v['type_id'], $v['sku_id'], $v['num'], $info['total_num'], $up['total_num'], $name);
  732. }
  733. } else {
  734. $up = $where;
  735. $up['total_num'] = $v['num'];
  736. $up['cash'] = $cash;
  737. $up['price'] = $price;
  738. $up['name'] = $name;
  739. $state = Dever::db('agent/member_goods')->insert($up);
  740. if ($state) {
  741. Dever::load('agent/lib/member_set')->log($order['mid'], $order['order_num'], $v['type'], $v['type_id'], $v['sku_id'], $v['num'], 0, $up['total_num'], $name);
  742. }
  743. }
  744. return $cash;
  745. }
  746. private function setCash($order)
  747. {
  748. $param = Dever::input('param');
  749. if ($param) {
  750. $param = explode(',', $param);
  751. foreach ($param as $k => $v) {
  752. $t = Dever::array_decode($v);
  753. # 判断是否名额内
  754. if (isset($t['prize_type']) && $t['prize_type'] == 2) {
  755. Dever::db('agent/member')->update(array('where_id' => $order['mid'], 'prize_type' => $t['prize_type']));
  756. }
  757. $parent_order = $order;
  758. $parent_order['mid'] = $t['parent_mid'];
  759. $where['type'] = $t['type'];
  760. $where['order_id'] = $order['id'];
  761. $where['mid'] = $order['mid'];
  762. $where['parent_mid'] = $t['parent_mid'];
  763. $info = Dever::db('agent/order_cash')->find($where);
  764. if (!$info) {
  765. $insert = $where;
  766. $insert['cash'] = $t['cash'];
  767. $insert['per'] = $t['per'];
  768. if (isset($t['prize_id'])) {
  769. $insert['prize_id'] = $t['prize_id'];
  770. }
  771. if (isset($t['goods'])) {
  772. $insert['goods'] = Dever::array_encode($t['goods']);
  773. }
  774. Dever::db('agent/order_cash')->insert($insert);
  775. } else {
  776. $update['where_id'] = $info['id'];
  777. $update['cash'] = $t['cash'];
  778. $update['per'] = $t['per'];
  779. if (isset($t['prize_id'])) {
  780. $update['prize_id'] = $t['prize_id'];
  781. }
  782. if (isset($t['goods'])) {
  783. $update['goods'] = Dever::array_encode($t['goods']);
  784. }
  785. Dever::db('agent/order_cash')->update($update);
  786. }
  787. if (isset($t['prize_id']) && isset($t['child_num'])) {
  788. $prize_info = Dever::db('setting/prize')->find($t['prize_id']);
  789. if ($prize_info) {
  790. $prize_insert['order_id'] = $order['order_id'];
  791. $prize_insert['mid'] = $t['parent_mid'];
  792. $prize_insert['child_num'] = $t['child_num'];
  793. $prize_insert['prize_id'] = $prize_info['id'];
  794. Dever::db('agent/member_prize')->insert($prize_insert);
  795. $prize['type'] = 3;
  796. $prize['type_id'] = $prize_info['id'];
  797. $prize['sku_id'] = -1;
  798. $prize['num'] = $prize_info['num'];
  799. $this->addGoods($parent_order, $prize, 1);
  800. }
  801. }
  802. if (isset($t['parent_goods_id'])) {
  803. $parent_goods = Dever::db('agent/member_goods')->getOne(array('id' => $t['parent_goods_id']));
  804. if ($parent_goods && $parent_goods['num'] > 0) {
  805. $parent_prize = Dever::db('setting/prize')->find($parent_goods['type_id']);
  806. if ($parent_prize) {
  807. # 检测有没有名额权益
  808. $prize_goods = Dever::db('setting/prize_goods')->select(array('prize_id' => $parent_prize['id']));
  809. if ($prize_goods) {
  810. # 赠送权益
  811. foreach ($prize_goods as $k1 => $v1) {
  812. $this->addGoods($parent_order, $v1, 1);
  813. }
  814. }
  815. $member = Dever::db('agent/member')->find($t['parent_mid']);
  816. if ($member) {
  817. $desc = $parent_prize['name'] . '名额使用';
  818. Dever::load('agent/lib/dhorder')->action($member, $parent_prize['name'], $parent_prize['num'], $parent_prize['price'], array(), -1, 2, 3, $parent_goods['type_id'], $desc);
  819. }
  820. }
  821. }
  822. }
  823. if (!isset($t['parent_level'])) {
  824. $t['parent_level'] = false;
  825. }
  826. if (!isset($t['child_num'])) {
  827. $t['child_num'] = 0;
  828. }
  829. $member = Dever::db('agent/member')->find($where['mid']);
  830. $desc = $member['name'] . '成为代理商,佣金'.$t['per'].'%';
  831. Dever::load('agent/lib/member')->up($member, $where['parent_mid'], $order['id'], $order['role'], $where['type'], $t['cash'], $order['agent_cash'], $t['parent_level'], $desc, $t['child_num']);
  832. # 自动升级
  833. if (isset($t['role_up']) && $t['role_up']) {
  834. $member = Dever::db('agent/member')->find(array('id' => $where['parent_mid']));
  835. $role = Dever::db('setting/role')->find($t['role_up']['t_role_id']);
  836. Dever::db('agent/member')->update(array('where_id' => $where['parent_mid'], 'role' => $t['role_up']['t_role_id']));
  837. if ($member && $role) {
  838. $this->upRole($member, $role, '', $order['id']);
  839. }
  840. }
  841. }
  842. }
  843. }
  844. private function setAgreement($order)
  845. {
  846. Dever::load('agent/lib/agreement')->up($order);
  847. }
  848. public function sellOrderUpdate($id, $name, $data)
  849. {
  850. Dever::config('base')->hook = true;
  851. $update = array();
  852. $audit = Dever::param('audit', $data);
  853. $desc = Dever::param('audit_desc', $data);
  854. $info = Dever::db('agent/dh_order')->one($id);
  855. if ($audit > 1 && $info && $info['status'] == 2) {
  856. if ($audit == 2) {
  857. # 成功
  858. Dever::setInput('order_id', $id);
  859. Dever::load('agent/lib/dhorder.audit_commit');
  860. } else {
  861. Dever::db('agent/dh_order')->update(array('where_id' => $id, 'status' => 7));
  862. Dever::load('agent/lib/dhorder')->updateSell($info, 2);
  863. if (Dever::project('sms')) {
  864. $member = Dever::db('agent/member')->find($info['mid']);
  865. Dever::load('sms/api')->send('daili_goods_no', $member['mobile'], array('name' => $member['name'], 'content' => $desc));
  866. }
  867. }
  868. }
  869. }
  870. public function sellOrderUpdateMul($id, $name, $data)
  871. {
  872. Dever::config('base')->hook = true;
  873. $status = Dever::param('status', $data);
  874. if ($status == 5) {
  875. $list = explode(',', $id);
  876. if ($list) {
  877. foreach ($list as $k => $v) {
  878. if (is_array($v)) {
  879. $id = $v['id'];
  880. $info = Dever::db('agent/dh_order')->one($id);
  881. } else {
  882. $id = $v;
  883. $info = Dever::db('agent/dh_order')->one($id);
  884. }
  885. Dever::load('agent/lib/dhorder')->finish($info, $info['shop_id']);
  886. }
  887. }
  888. }
  889. }
  890. # 确认收货
  891. public function setDhOrderStatus_api()
  892. {
  893. $order_id = Dever::input('order_id');
  894. $info = Dever::db('agent/dh_order')->find($order_id);
  895. if ($info) {
  896. Dever::load('agent/lib/dhorder')->finish($info, $info['shop_id']);
  897. return 'reload';
  898. } else {
  899. Dever::alert('错误的订单号');
  900. }
  901. }
  902. # 获取权益名称
  903. public function getGoods($type, $type_id, $sku_id, $name = '')
  904. {
  905. if ($type == 1) {
  906. if ($name) {
  907. return array('name' => $name . '('.$type_id.')');
  908. }
  909. if ($sku_id == -2) {
  910. return '商品';
  911. }
  912. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($type_id, $sku_id);
  913. if (isset($goods_info['sku'])) {
  914. $sku = '-' . $goods_info['sku']['string'];
  915. } else {
  916. $sku = '';
  917. }
  918. return array('name' => $goods_info['name'] . $sku . '('.$type_id.')', 'price' => $goods_info['price']);
  919. } elseif ($type == 2) {
  920. $code = Dever::db('card/code')->find($sku_id);
  921. $card = Dever::db('card/info')->find($code['card_id']);
  922. return array('name' => $card['name'] . '('.$type_id.') <br /> ' . $code['card'], 'price' => $code['total_cash']);
  923. } elseif ($type == 3) {
  924. if ($name) {
  925. return array('name' => $name . '('.$type_id.')');
  926. }
  927. $prize = Dever::db('setting/prize')->find($type_id);
  928. return array('name' => $prize['name'] . '('.$type_id.')', 'price' => $prize['price']);
  929. }
  930. }
  931. public function setOrderStatus_api()
  932. {
  933. $where['where_id'] = Dever::input('id');
  934. $order = Dever::db('agent/order')->find($where['where_id']);
  935. if ($order) {
  936. $where['status'] = Dever::input('status');
  937. if ($where['status'] == 6) {
  938. $where['history_status'] = $order['status'];
  939. }
  940. Dever::db('agent/order')->update($where);
  941. if ($where['status'] == 7 && $order['get_type'] == 1) {
  942. # 关闭订单
  943. $member = Dever::db('agent/member')->find($order['mid']);
  944. if ($member) {
  945. Dever::db('agent/member')->update(array('where_id' => $member['id'], 'state' => 2));
  946. }
  947. }
  948. }
  949. return 'reload';
  950. }
  951. public function upSignAgreement_api()
  952. {
  953. $id = Dever::input('id');
  954. if ($id) {
  955. Dever::load('agent/lib/agreement')->upContent($id, true);
  956. }
  957. return 'reload';
  958. }
  959. public function upAgreement_api()
  960. {
  961. $id = Dever::input('id');
  962. if ($id) {
  963. Dever::load('agent/lib/agreement')->upContent($id);
  964. }
  965. return 'reload';
  966. }
  967. public function dropAgreement_api()
  968. {
  969. $id = Dever::input('id');
  970. if ($id) {
  971. Dever::load('agent/lib/agreement')->drop($id);
  972. }
  973. return 'reload';
  974. }
  975. public function memberShop_api(){
  976. $data = Dever::db('agent/member')->getShopAll(array('shop_id'=>1,'state'=>1));
  977. if($data){
  978. foreach($data as $k=>$v){
  979. $log = Dever::db('agent/member_shop_log')->find(array('mid'=>$v['id']));
  980. if($log){
  981. }else{
  982. Dever::db('agent/member_shop_log')->insert(array('mid'=>$v['id'],'new_shop_id'=>$v['shop_id'],'cdate'=>'1651680000'));
  983. }
  984. }
  985. }
  986. return 'ok';
  987. }
  988. public function updateUserBind($id, $name, $data)
  989. {
  990. Dever::config('base')->hook = true;
  991. $update = array();
  992. $audit = Dever::param('audit', $data);
  993. $desc = Dever::param('audit_desc', $data);
  994. $info = Dever::db('agent/user_bind')->one($id);
  995. if ($info) {
  996. if ($audit) {
  997. $update['where_id'] = $info['id'];
  998. $update['audit_date'] = time();
  999. $update['status'] = $audit;
  1000. $admin = Dever::load('manage/auth.info');
  1001. $update['admin'] = $admin['id'];
  1002. Dever::db('agent/user_bind')->update($update);
  1003. }
  1004. }
  1005. }
  1006. public function search_api()
  1007. {
  1008. $where = array();
  1009. return Dever::search('agent/member', $where);
  1010. }
  1011. public function out_arealog($data){
  1012. $header = array('区域名称', '区域价值', '售出时间');
  1013. $body = array();
  1014. foreach($data as $k1=> $v1){
  1015. $member = Dever::db('agent/member')->find($v1['mid']);
  1016. $role = Dever::db('setting/role')->find($member['role']);
  1017. if ($role['type'] == 1) {
  1018. $data[$k1]['price'] = $role['price'];
  1019. }
  1020. if(isset($data[$k1]['price']) && $data[$k1]['price']<1){
  1021. unset($data[$k1]);
  1022. }
  1023. }
  1024. $res = array_values($data);
  1025. foreach($res as $k=>$v){
  1026. $res[$k]['areas'] = Dever::load("area/api.string", $v['area']);
  1027. $member = Dever::db('agent/member')->find($v['mid']);
  1028. $role = Dever::db('setting/role')->find($member['role']);
  1029. $res[$k]['cdate'] = date('Y-m-d H:i',$v['cdate']);
  1030. if ($role['type'] == 1) {
  1031. $res[$k]['price'] = $role['price'];
  1032. } elseif ($role['type'] == 2) {
  1033. $res[$k]['price'] = Dever::load('area/api')->getPrice($role['area'], $v['area']);
  1034. }
  1035. $d = array
  1036. (
  1037. $res[$k]['areas'],
  1038. $res[$k]['price'],
  1039. $res[$k]['cdate']
  1040. );
  1041. $body[] = $d;
  1042. }
  1043. $file = Dever::input('excel_name');
  1044. return Dever::excelExport($body, $header, $file);
  1045. }
  1046. public function out_zhitui($data){
  1047. $header = array('推荐人姓名', '手机号', '身份证', '角色', '被推荐人姓名', '手机号', '身份证', '角色','代理费','奖励金','时间');
  1048. $body = array();
  1049. foreach($data as $k => $v){
  1050. if($v['parent_mid']>0){
  1051. $member = Dever::db('agent/member')->find($v['parent_mid']);
  1052. $prole_name = '';
  1053. if($member && $member['role']){
  1054. $prole = Dever::db('setting/role')->find($member['role']);
  1055. if($prole && $prole['name']){
  1056. $prole_name = $prole['name'];
  1057. }
  1058. }
  1059. $role_name = '';
  1060. if($v['role']){
  1061. $role = Dever::db('setting/role') ->find($v['role']);
  1062. if($role && $role['name']){
  1063. $role_name = $role['name'];
  1064. }
  1065. }
  1066. $order = Dever::db('agent/order')->find(array('mid'=>$v['id']));
  1067. $cdate = '';
  1068. if($v['cdate']){
  1069. $cdate = date('Y-m-d H:i',$v['cdate']);
  1070. }
  1071. if($member){
  1072. $d = array
  1073. (
  1074. $member['name'],
  1075. $member['mobile'],
  1076. $member['idcard'],
  1077. $prole_name,
  1078. $v['name'],
  1079. $v['mobile'],
  1080. $v['idcard'],
  1081. $role['name'],
  1082. $order['agent_cash'],
  1083. $v['cash'],
  1084. $cdate,
  1085. );
  1086. $body[] = $d;
  1087. }
  1088. }
  1089. }
  1090. $file = Dever::input('excel_name');
  1091. return Dever::excelExport($body, $header, $file);
  1092. }
  1093. }