Manage.php 49 KB

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