Manage.php 44 KB

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