Manage.php 49 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244
  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::db('agent/member_area')->update(array('where_id' => $area_info['id'], 'state' => 2));
  326. }
  327. if ($role && $role['type'] == 2) {
  328. Dever::load('area/api')->upStatus($area, 2);
  329. $area_data['order_id'] = $order_id;
  330. $area_data['role'] = $role['id'];
  331. $area_data['area'] = $area;
  332. $area_data['type'] = $type;
  333. $area_data['price'] = $price;
  334. $area_data['status'] = 1;
  335. Dever::db('agent/member_area')->insert($area_data);
  336. //Dever::load('agent/lib/order')->editArea($v, $area);
  337. }
  338. $this->area_log($member['id'], $order_id, $member['area'], $area);
  339. }
  340. # 获取
  341. # 设置上级
  342. public function setParent_commit($id, $name, $data)
  343. {
  344. //Dever::alert('暂未开放');
  345. Dever::config('base')->hook = true;
  346. $mid = Dever::param('mid', $data);
  347. $parent_mobile = trim(Dever::param('parent_mobile', $data));
  348. if ($mid && $parent_mobile) {
  349. $member = Dever::db('agent/member')->find($mid);
  350. $parent = Dever::db('agent/member')->find(array('mobile' => $parent_mobile));
  351. if ($parent && $parent['status'] == 2) {
  352. if ($member['parent_mid'] == $parent['id']) {
  353. Dever::alert('上级代理商设置失败');
  354. return;
  355. }
  356. if ($member['parent_mid'] == $mid) {
  357. Dever::alert('上级代理商不能设置为自己');
  358. return;
  359. }
  360. # 重置关系
  361. Dever::load('invite/api')->resetRelation($mid, $parent['id']);
  362. /*
  363. # 删除之前关系
  364. Dever::load('invite/api')->dropRelation($mid, $parent['id']);
  365. # 获取所有下级
  366. $child = Dever::load('invite/api')->getChild($mid);
  367. if ($child) {
  368. foreach ($child as $k => $v) {
  369. Dever::load('invite/api')->dropRelation($v['to_uid'], $parent['id']);
  370. }
  371. }
  372. # 重新设置关系
  373. Dever::load('invite/api')->setRelation($mid, $parent['id']);
  374. */
  375. Dever::db('agent/member')->update(array('where_id' => $mid, 'parent_mid' => $parent['id']));
  376. } else {
  377. Dever::alert('上级代理商还未注册或者已封禁');
  378. }
  379. }
  380. }
  381. public function orderUpdateParent($id, $name, $data)
  382. {
  383. Dever::config('base')->hook = true;
  384. $id = $id['where_id'];
  385. $order = Dever::db('agent/order')->find($id);
  386. if (!$order) {
  387. return;
  388. }
  389. $area = Dever::param('area', $data);#修改后
  390. $role = Dever::param('role', $data);
  391. $invite_type = Dever::param('invite_type', $data);
  392. $parent_code = Dever::param('parent_code', $data);
  393. if ($invite_type == 1 && $parent_code) {
  394. $parent_mid = Dever::load('invite/api')->getUid($parent_code);
  395. if ($parent_mid) {
  396. $parent_member = Dever::db('agent/member')->find($parent_mid);
  397. if (!$parent_member) {
  398. Dever::alert('错误的邀请码');
  399. }
  400. if ($order['mid'] == $parent_member['id']) {
  401. Dever::alert('邀请人不能是自己');
  402. }
  403. $data['set_parent_mid'] = $parent_mid;
  404. //Dever::db('agent/member')->update(array('where_id' => $order['mid'], 'parent_mid' => $parent_mid));
  405. } else {
  406. Dever::alert('错误的邀请码');
  407. }
  408. }
  409. if ($area && is_array($area) && $role) {
  410. $role = Dever::db('setting/role')->find($role);
  411. $area_string = array();
  412. if ($role && $role['type'] == 2) {
  413. $area_string = Dever::load('agent/lib/order')->checkArea($area, $role, $order['mid']);
  414. } else {
  415. $area_string = implode(',', $area);
  416. $area_string = str_replace(',-1', '', $area_string);
  417. }
  418. if ($role['type'] == 1) {
  419. $data['set_f_price'] = $data['set_price'] = $role['price'];
  420. } elseif ($role['type'] == 2) {
  421. $data['set_f_price'] = $data['set_price'] = Dever::load('area/api')->getPrice($role['area'], $area_string);
  422. } else {
  423. $data['set_f_price'] = $data['set_price'] = 0;
  424. }
  425. $data['set_area'] = $area_string;
  426. }
  427. return $data;
  428. }
  429. public function orderStartUpdate($id, $name, $data)
  430. {
  431. $order_id = Dever::param('order_id', $data);
  432. if ($order_id) {
  433. $order = Dever::db('agent/order')->find($order_id);
  434. if ($order && $order['source_id'] < 0) {
  435. if ($order['parent_mid'] > 0) {
  436. $member = Dever::db('agent/member')->find($order['parent_mid']);
  437. if ($member['status'] == 2) {
  438. return $data;
  439. }
  440. }
  441. Dever::alert('直属上级未认证,无法进行初审');
  442. }
  443. }
  444. }
  445. public function orderUpdate($id, $name, $data)
  446. {
  447. Dever::config('base')->hook = true;
  448. $audit = Dever::param('audit', $data);
  449. $status = Dever::param('status', $data);
  450. $desc = Dever::param('desc', $data);
  451. $order_id = Dever::param('order_id', $data);
  452. $order = Dever::db('agent/order')->find($order_id);
  453. if ($order_id && $order && $status) {
  454. $admin = Dever::load('manage/auth.info');
  455. if ($admin) {
  456. Dever::db('agent/order_process')->update(array('where_id' => $id, 'admin' => $admin['id']));
  457. }
  458. if ($status < 3) {
  459. if ($audit == 1) {
  460. $update = array('where_id' => $order_id, 'status' => $status+1);
  461. if ($status == 1) {
  462. $soft_price = Dever::param('soft_price', $data);
  463. $price = Dever::param('price', $data);
  464. $prize_type = Dever::param('prize_type', $data);
  465. $option_price = Dever::param('option_price', $data);
  466. if ($prize_type == 2) {
  467. # 扣减已有名额,判断一下 暂时废弃
  468. $prize = Dever::db('setting/prize')->find(array('type' => 1, 'price' => $order['price']));
  469. if ($prize) {
  470. $member_goods = Dever::db('agent/member_goods')->getOne(array('mid' => $order['mid'], 'type' => 3, 'type_id' => $prize['id']));
  471. if ($member_goods && $member_goods['num'] > 0) {
  472. # 有名额
  473. $price = 0;
  474. # 开始扣减
  475. $member = Dever::db('agent/member')->find($order['mid']);
  476. Dever::load('agent/lib/dhorder')->action($member, $prize['name'], $prize['num'], $prize['price'], array(), -1, 2, 3, $prize['id'], $desc);
  477. }
  478. }
  479. }
  480. if ($price <= 0) {
  481. $update['get_type'] = 2;
  482. } else {
  483. $update['get_type'] = 1;
  484. }
  485. $update['price'] = $price;
  486. $update['agent_cash'] = $price;
  487. $update['soft_cash'] = 0;
  488. $update['option_price']=$option_price;
  489. $cstatus = Dever::param('cstatus', $data);
  490. if ($cstatus && $cstatus == 2 && $price > 0) {
  491. # 拆分代理费
  492. if ($soft_price > 0) {
  493. $update['agent_cash'] = $price - $soft_price;
  494. $update['soft_cash'] = $soft_price;
  495. } else {
  496. $role = Dever::db('setting/role')->one($order['role']);
  497. if ($role && $role['soft']) {
  498. if (strstr($role['soft'], '%')) {
  499. $role['soft'] = str_replace('%', '', $role['soft']);
  500. $role['soft'] = $price * ($role['soft']/100);
  501. }
  502. $update['agent_cash'] = $price - $role['soft'];
  503. $update['soft_cash'] = $role['soft'];
  504. }
  505. }
  506. }
  507. # 增加业绩
  508. //Dever::load('bill/lib/sell')->up($order['mid'], 2, $order['price'], $order['role'], $order['id'], $order['name'] . '成为代理商');
  509. } elseif ($status == 2) {
  510. if ($order['mid'] && $order['mid'] > 0 && $order['parent_mid'] && $order['parent_mid'] > 0) {
  511. Dever::load('invite/api')->setRelation($order['mid'], $order['parent_mid']);
  512. Dever::db('agent/member')->update(array('where_id' => $order['mid'], 'parent_mid' => $order['parent_mid']));
  513. }
  514. $update['pay_status'] = 2;
  515. Dever::load('agent/lib/member')->create($order);
  516. }
  517. Dever::db('agent/order')->update($update);
  518. } else {
  519. Dever::db('agent/order')->update(array('where_id' => $order_id, 'status' => 5, 'history_status' => $order['status'], 'audit_desc' => $desc));
  520. if (Dever::project('sms')) {
  521. Dever::load('sms/api')->send('daili_reg_no', $order['mobile'], array('name' => $order['name'], 'content' => $desc));
  522. }
  523. }
  524. } elseif ($status == 3) {
  525. $info = Dever::db('agent/order_process')->find(array('id' => $id, 'clear' => true));
  526. if ($info && $info['status'] == 3) {
  527. $info['type'] = explode(',', $info['type']);
  528. }
  529. if (in_array(2, $info['type'])) {
  530. $goods_status = 3;
  531. } else {
  532. $goods_status = 2;
  533. }
  534. $curtime = time();
  535. Dever::db('agent/order')->update(array('where_id' => $order_id, 'fdate' => $curtime, 'status' => 4, 'goods_status' => $goods_status));
  536. # 通知短信
  537. if (Dever::project('sms')) {
  538. $order = Dever::db('agent/order')->find($order_id);
  539. Dever::load('sms/api')->send('daili_reg_yes', $order['mobile'], array('name' => $order['name']));
  540. }
  541. $order = Dever::db('agent/order')->find($order_id);
  542. if ($order && $order['mid']) {
  543. $member = Dever::db('agent/member')->find($order['mid']);
  544. $update['where_id'] = $order['mid'];
  545. if ($member && $member['status'] == 1) {
  546. $update['status'] = 2;
  547. $update['rdate'] = $curtime;
  548. }
  549. $update['area'] = $order['area'];
  550. $update['role'] = $order['role'];
  551. $update['udate'] = $curtime;
  552. Dever::db('agent/member')->update($update);
  553. if ($order['price'] > 0) {
  554. $type = 1;
  555. } else {
  556. $type = 2;
  557. }
  558. $this->upLog($member, $order['role'], $order['area'], $order['id'], $type, $order['price']);
  559. }
  560. }
  561. }
  562. }
  563. #区域日志
  564. public function area_log($mid,$order_id,$old_area, $area) {
  565. $data['mid']=$mid;
  566. $data['order_id']=$order_id;
  567. $data['old_area']=$old_area;
  568. $data['area']=$area;
  569. if ($order_id && $order_id > 0) {
  570. $data['type'] = 1;
  571. } else {
  572. $admin = Dever::load('manage/auth.info');
  573. $data['audit_admin'] = $admin['id'];
  574. $data['type'] = 2;
  575. }
  576. $id = Dever::db('agent/member_area_log')->insert($data);
  577. return $id;
  578. }
  579. # 发放权益
  580. public function set_commit_api()
  581. {
  582. Dever::config('base')->hook = true;
  583. $type = Dever::input('type', 2);
  584. $order_id = Dever::input('order_id');
  585. # 检测是否发放过了
  586. $order = Dever::db('agent/order')->find($order_id);
  587. if ($order['status'] != 3) {
  588. //Dever::alert('无发放权限');
  589. }
  590. $order_process = Dever::db('agent/order_process')->find(array('order_id' => $order_id, 'status' => 3));
  591. $yes = -1;
  592. if (!$order_process) {
  593. # 可以发放
  594. $yes = 1;
  595. } elseif ($order_process) {
  596. $order_process['type'] = explode(',', $order_process['type']);
  597. if (!in_array($type, $order_process['type'])) {
  598. # 可以发放
  599. $yes = 2;
  600. }
  601. }
  602. if ($yes > 0) {
  603. if ($yes == 1) {
  604. $data['order_id'] = $order_id;
  605. $data['status'] = 3;
  606. $data['type'] = '1,' . $type;
  607. $state = Dever::db('agent/order_process')->insert($data);
  608. } else {
  609. $data['where_id'] = $order_process['id'];
  610. $order_process['type'][] = $type;
  611. $data['type'] = implode(',', $order_process['type']);
  612. $state = Dever::db('agent/order_process')->update($data);
  613. }
  614. if ($state) {
  615. if ($type == 2) {
  616. $this->setGoods($order);
  617. } elseif ($type == 3) {
  618. $this->setCash($order);
  619. } elseif ($type == 5) {
  620. $this->setAgreement($order);
  621. }
  622. }
  623. return 'reload';
  624. } else {
  625. Dever::alert('无发放权限');
  626. }
  627. }
  628. # 设置多个权益
  629. private function setGoods($order)
  630. {
  631. $t = 1;
  632. $goods = Dever::db('agent/order_goods')->getData(array('order_id' => $order['id']));
  633. if (!$goods) {
  634. $goods = Dever::db('setting/role_goods')->getData(array('role_id' => $order['role'], 'give' => $order['order_type']));
  635. $t = intval($order['agent_cash']/10000);
  636. if ($t <= 0) {
  637. $t = 1;
  638. }
  639. }
  640. if ($goods) {
  641. $where = array();
  642. $goods_cash = 0;
  643. foreach ($goods as $k => $v) {
  644. $price = $this->addGoods($order, $v, $t);
  645. if ($price && $v['type'] < 3) {
  646. # 计算商品价值
  647. $goods_cash += $price;
  648. }
  649. }
  650. $update = array();
  651. if ($goods_cash) {
  652. $update['goods_cash'] = $goods_cash;
  653. }
  654. $update['goods_status'] = 3;
  655. $update['where_id'] = $order['id'];
  656. Dever::db('agent/order')->update($update);
  657. }
  658. }
  659. # 新增权益
  660. private function addGoods($order, $v, $t)
  661. {
  662. $cash = $price = 0;
  663. if ($v['type'] == 1) {
  664. $v['num'] = $v['num'] * $t;
  665. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['type_id'], $v['sku_id']);
  666. $price = $goods_info['price'];
  667. $cash = $goods_info['price'] * $v['num'];
  668. if (isset($goods_info['sku'])) {
  669. $sku = '-' . $goods_info['sku']['string'];
  670. } else {
  671. $sku = '';
  672. }
  673. $name = $goods_info['name'] . $sku;
  674. } elseif ($v['type'] == 2) {
  675. $v['sku_id'] = -1;
  676. # 生成一个电子券
  677. $card = Dever::db('card/info')->find($v['type_id']);
  678. if (!$card) {
  679. return false;
  680. }
  681. $name = $card['name'];
  682. if ($card['create_type'] == 2) {
  683. $cash = $card['value']*$v['num'] * $t;
  684. $price = $cash;
  685. $v['num'] = 1;
  686. $v['sku_id'] = Dever::load('card/lib/code')->create($card, 2, $order['mid'], $order['id'], $cash);
  687. if (!$v['sku_id']) {
  688. return false;
  689. }
  690. } elseif ($card['create_type'] == 3) {
  691. $cash = round($order['agent_cash']*($v['num']/100), 2);
  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. } else {
  699. $cash = $card['value'];
  700. $price = $cash;
  701. $total = $t*$v['num'];
  702. $t = 1;
  703. for($i=0; $i<$total;$i++) {
  704. $v['sku_id'] = Dever::load('card/lib/code')->create($card, 2, $order['mid'], $order['id'], $cash);
  705. if ($v['sku_id']) {
  706. $where['mid'] = $order['mid'];
  707. $where['type'] = $v['type'];
  708. $where['type_id'] = $v['type_id'];
  709. $where['sku_id'] = $v['sku_id'];
  710. $info = Dever::db('agent/member_goods')->find($where);
  711. if (!$info) {
  712. $up = $where;
  713. $up['total_num'] = $t;
  714. $up['cash'] = $cash;
  715. $up['price'] = $price;
  716. $up['name'] = $name;
  717. $state = Dever::db('agent/member_goods')->insert($up);
  718. if ($state) {
  719. Dever::load('agent/lib/member_set')->log($order['mid'], $order['order_num'], $v['type'], $v['type_id'], $v['sku_id'], $t, 0, $t, $name);
  720. }
  721. }
  722. }
  723. }
  724. return $cash * $total;
  725. }
  726. } elseif ($v['type'] == 3) {
  727. $prize = Dever::db('setting/prize')->find($v['type_id']);
  728. $v['num'] = $v['num'] * $t;
  729. $role = Dever::db('setting/role')->find($order['role']);
  730. if ($role && $role['max_me_num'] && $role['max_me_num'] < $v['num']) {
  731. $v['num'] = $role['max_me_num'];
  732. }
  733. $price = $prize['price'];
  734. $cash = $prize['price']*$v['num'];
  735. $name = $prize['name'];
  736. }
  737. $where['mid'] = $order['mid'];
  738. $where['type'] = $v['type'];
  739. $where['type_id'] = $v['type_id'];
  740. $where['sku_id'] = $v['sku_id'];
  741. $info = Dever::db('agent/member_goods')->find($where);
  742. if ($info) {
  743. $up['where_id'] = $info['id'];
  744. $up['total_num'] = $info['total_num'] + $v['num'];
  745. $up['cash'] = $cash;
  746. $up['price'] = $price;
  747. $up['name'] = $name;
  748. $state = Dever::db('agent/member_goods')->update($up);
  749. if ($state) {
  750. 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);
  751. }
  752. } else {
  753. $up = $where;
  754. $up['total_num'] = $v['num'];
  755. $up['cash'] = $cash;
  756. $up['price'] = $price;
  757. $up['name'] = $name;
  758. $state = Dever::db('agent/member_goods')->insert($up);
  759. if ($state) {
  760. 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);
  761. }
  762. }
  763. return $cash;
  764. }
  765. private function setCash($order)
  766. {
  767. $param = Dever::input('param');
  768. if ($param) {
  769. $param = explode(',', $param);
  770. foreach ($param as $k => $v) {
  771. $t = Dever::array_decode($v);
  772. # 判断是否名额内
  773. if (isset($t['prize_type']) && $t['prize_type'] == 2) {
  774. Dever::db('agent/member')->update(array('where_id' => $order['mid'], 'prize_type' => $t['prize_type']));
  775. }
  776. $parent_order = $order;
  777. $parent_order['mid'] = $t['parent_mid'];
  778. $where['type'] = $t['type'];
  779. $where['order_id'] = $order['id'];
  780. $where['mid'] = $order['mid'];
  781. $where['parent_mid'] = $t['parent_mid'];
  782. $info = Dever::db('agent/order_cash')->find($where);
  783. if (!$info) {
  784. $insert = $where;
  785. $insert['cash'] = $t['cash'];
  786. $insert['per'] = $t['per'];
  787. if (isset($t['prize_id'])) {
  788. $insert['prize_id'] = $t['prize_id'];
  789. }
  790. if (isset($t['goods'])) {
  791. $insert['goods'] = Dever::array_encode($t['goods']);
  792. }
  793. Dever::db('agent/order_cash')->insert($insert);
  794. } else {
  795. $update['where_id'] = $info['id'];
  796. $update['cash'] = $t['cash'];
  797. $update['per'] = $t['per'];
  798. if (isset($t['prize_id'])) {
  799. $update['prize_id'] = $t['prize_id'];
  800. }
  801. if (isset($t['goods'])) {
  802. $update['goods'] = Dever::array_encode($t['goods']);
  803. }
  804. Dever::db('agent/order_cash')->update($update);
  805. }
  806. if (isset($t['prize_id']) && isset($t['child_num'])) {
  807. $prize_info = Dever::db('setting/prize')->find($t['prize_id']);
  808. if ($prize_info) {
  809. $prize_insert['order_id'] = $order['order_id'];
  810. $prize_insert['mid'] = $t['parent_mid'];
  811. $prize_insert['child_num'] = $t['child_num'];
  812. $prize_insert['prize_id'] = $prize_info['id'];
  813. Dever::db('agent/member_prize')->insert($prize_insert);
  814. $prize['type'] = 3;
  815. $prize['type_id'] = $prize_info['id'];
  816. $prize['sku_id'] = -1;
  817. $prize['num'] = $prize_info['num'];
  818. $this->addGoods($parent_order, $prize, 1);
  819. }
  820. }
  821. if (isset($t['parent_goods_id'])) {
  822. $parent_goods = Dever::db('agent/member_goods')->getOne(array('id' => $t['parent_goods_id']));
  823. if ($parent_goods && $parent_goods['num'] > 0) {
  824. $parent_prize = Dever::db('setting/prize')->find($parent_goods['type_id']);
  825. if ($parent_prize) {
  826. # 检测有没有名额权益
  827. $prize_goods = Dever::db('setting/prize_goods')->select(array('prize_id' => $parent_prize['id']));
  828. if ($prize_goods) {
  829. # 赠送权益
  830. foreach ($prize_goods as $k1 => $v1) {
  831. $this->addGoods($parent_order, $v1, 1);
  832. }
  833. }
  834. $member = Dever::db('agent/member')->find($t['parent_mid']);
  835. if ($member) {
  836. $desc = $parent_prize['name'] . '名额使用';
  837. 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);
  838. }
  839. }
  840. }
  841. }
  842. if (!isset($t['parent_level'])) {
  843. $t['parent_level'] = false;
  844. }
  845. if (!isset($t['child_num'])) {
  846. $t['child_num'] = 0;
  847. }
  848. $member = Dever::db('agent/member')->find($where['mid']);
  849. $desc = $member['name'] . '成为代理商,佣金'.$t['per'].'%';
  850. 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']);
  851. # 自动升级
  852. if (isset($t['role_up']) && $t['role_up']) {
  853. $member = Dever::db('agent/member')->find(array('id' => $where['parent_mid']));
  854. $role = Dever::db('setting/role')->find($t['role_up']['t_role_id']);
  855. Dever::db('agent/member')->update(array('where_id' => $where['parent_mid'], 'role' => $t['role_up']['t_role_id']));
  856. if ($member && $role) {
  857. $this->upRole($member, $role, '', $order['id']);
  858. }
  859. }
  860. }
  861. }
  862. }
  863. private function setAgreement($order)
  864. {
  865. Dever::load('agent/lib/agreement')->up($order);
  866. }
  867. public function sellOrderUpdate($id, $name, $data)
  868. {
  869. Dever::config('base')->hook = true;
  870. $update = array();
  871. $audit = Dever::param('audit', $data);
  872. $desc = Dever::param('audit_desc', $data);
  873. $info = Dever::db('agent/dh_order')->one($id);
  874. if ($audit > 1 && $info && $info['status'] == 2) {
  875. if ($audit == 2) {
  876. # 成功
  877. Dever::setInput('order_id', $id);
  878. Dever::load('agent/lib/dhorder.audit_commit');
  879. } else {
  880. Dever::db('agent/dh_order')->update(array('where_id' => $id, 'status' => 7));
  881. Dever::load('agent/lib/dhorder')->updateSell($info, 2);
  882. if (Dever::project('sms')) {
  883. $member = Dever::db('agent/member')->find($info['mid']);
  884. Dever::load('sms/api')->send('daili_goods_no', $member['mobile'], array('name' => $member['name'], 'content' => $desc));
  885. }
  886. }
  887. }
  888. }
  889. public function sellOrderUpdateMul($id, $name, $data)
  890. {
  891. Dever::config('base')->hook = true;
  892. $status = Dever::param('status', $data);
  893. if ($status == 5) {
  894. $list = explode(',', $id);
  895. if ($list) {
  896. foreach ($list as $k => $v) {
  897. if (is_array($v)) {
  898. $id = $v['id'];
  899. $info = Dever::db('agent/dh_order')->one($id);
  900. } else {
  901. $id = $v;
  902. $info = Dever::db('agent/dh_order')->one($id);
  903. }
  904. $info['status'] = 4;
  905. Dever::load('agent/lib/dhorder')->finish($info, $info['shop_id']);
  906. }
  907. }
  908. }
  909. }
  910. # 确认收货
  911. public function setDhOrderStatus_api()
  912. {
  913. $order_id = Dever::input('order_id');
  914. $info = Dever::db('agent/dh_order')->find($order_id);
  915. if ($info) {
  916. Dever::load('agent/lib/dhorder')->finish($info, $info['shop_id']);
  917. return 'reload';
  918. } else {
  919. Dever::alert('错误的订单号');
  920. }
  921. }
  922. # 获取权益名称
  923. public function getGoods($type, $type_id, $sku_id, $name = '')
  924. {
  925. if ($type == 1) {
  926. if ($name) {
  927. return array('name' => $name . '('.$type_id.')');
  928. }
  929. if ($sku_id == -2) {
  930. return '商品';
  931. }
  932. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($type_id, $sku_id);
  933. if (isset($goods_info['sku'])) {
  934. $sku = '-' . $goods_info['sku']['string'];
  935. } else {
  936. $sku = '';
  937. }
  938. return array('name' => $goods_info['name'] . $sku . '('.$type_id.')', 'price' => $goods_info['price']);
  939. } elseif ($type == 2) {
  940. $code = Dever::db('card/code')->find($sku_id);
  941. $card = Dever::db('card/info')->find($code['card_id']);
  942. return array('name' => $card['name'] . '('.$type_id.') <br /> ' . $code['card'], 'price' => $code['total_cash']);
  943. } elseif ($type == 3) {
  944. if ($name) {
  945. return array('name' => $name . '('.$type_id.')');
  946. }
  947. $prize = Dever::db('setting/prize')->find($type_id);
  948. return array('name' => $prize['name'] . '('.$type_id.')', 'price' => $prize['price']);
  949. }
  950. }
  951. public function setOrderStatus_api()
  952. {
  953. $where['where_id'] = Dever::input('id');
  954. $order = Dever::db('agent/order')->find($where['where_id']);
  955. if ($order) {
  956. $where['status'] = Dever::input('status');
  957. if ($where['status'] == 6) {
  958. $where['history_status'] = $order['status'];
  959. }
  960. Dever::db('agent/order')->update($where);
  961. if ($where['status'] == 7 && $order['get_type'] == 1) {
  962. # 关闭订单
  963. $member = Dever::db('agent/member')->find($order['mid']);
  964. if ($member) {
  965. Dever::db('agent/member')->update(array('where_id' => $member['id'], 'state' => 2));
  966. }
  967. }
  968. }
  969. return 'reload';
  970. }
  971. public function upSignAgreement_api()
  972. {
  973. $id = Dever::input('id');
  974. if ($id) {
  975. Dever::load('agent/lib/agreement')->upContent($id, true);
  976. }
  977. return 'reload';
  978. }
  979. public function upAgreement_api()
  980. {
  981. $id = Dever::input('id');
  982. if ($id) {
  983. Dever::load('agent/lib/agreement')->upContent($id);
  984. }
  985. return 'reload';
  986. }
  987. public function dropAgreement_api()
  988. {
  989. $id = Dever::input('id');
  990. if ($id) {
  991. Dever::load('agent/lib/agreement')->drop($id);
  992. }
  993. return 'reload';
  994. }
  995. public function memberShop_api(){
  996. $data = Dever::db('agent/member')->getShopAll(array('shop_id'=>1,'state'=>1));
  997. if($data){
  998. foreach($data as $k=>$v){
  999. $log = Dever::db('agent/member_shop_log')->find(array('mid'=>$v['id']));
  1000. if($log){
  1001. }else{
  1002. Dever::db('agent/member_shop_log')->insert(array('mid'=>$v['id'],'new_shop_id'=>$v['shop_id'],'cdate'=>'1651680000'));
  1003. }
  1004. }
  1005. }
  1006. return 'ok';
  1007. }
  1008. public function updateUserBind($id, $name, $data)
  1009. {
  1010. Dever::config('base')->hook = true;
  1011. $update = array();
  1012. $audit = Dever::param('audit', $data);
  1013. $desc = Dever::param('audit_desc', $data);
  1014. $info = Dever::db('agent/user_bind')->one($id);
  1015. if ($info) {
  1016. if ($audit) {
  1017. $update['where_id'] = $info['id'];
  1018. $update['audit_date'] = time();
  1019. $update['status'] = $audit;
  1020. $admin = Dever::load('manage/auth.info');
  1021. $update['admin'] = $admin['id'];
  1022. Dever::db('agent/user_bind')->update($update);
  1023. }
  1024. }
  1025. }
  1026. public function search_api()
  1027. {
  1028. $where = array();
  1029. return Dever::search('agent/member', $where);
  1030. }
  1031. public function out_arealog($data){
  1032. $header = array('区域名称', '区域价值', '售出时间');
  1033. $body = array();
  1034. foreach($data as $k1=> $v1){
  1035. $member = Dever::db('agent/member')->find($v1['mid']);
  1036. $role = Dever::db('setting/role')->find($member['role']);
  1037. if ($role['type'] == 1) {
  1038. $data[$k1]['price'] = $role['price'];
  1039. }
  1040. if(isset($data[$k1]['price']) && $data[$k1]['price']<1){
  1041. unset($data[$k1]);
  1042. }
  1043. }
  1044. $res = array_values($data);
  1045. foreach($res as $k=>$v){
  1046. $res[$k]['areas'] = Dever::load("area/api.string", $v['area']);
  1047. $member = Dever::db('agent/member')->find($v['mid']);
  1048. $role = Dever::db('setting/role')->find($member['role']);
  1049. $res[$k]['cdate'] = date('Y-m-d H:i',$v['cdate']);
  1050. if ($role['type'] == 1) {
  1051. $res[$k]['price'] = $role['price'];
  1052. } elseif ($role['type'] == 2) {
  1053. $res[$k]['price'] = Dever::load('area/api')->getPrice($role['area'], $v['area']);
  1054. }
  1055. $d = array
  1056. (
  1057. $res[$k]['areas'],
  1058. $res[$k]['price'],
  1059. $res[$k]['cdate']
  1060. );
  1061. $body[] = $d;
  1062. }
  1063. $file = Dever::input('excel_name');
  1064. return Dever::excelExport($body, $header, $file);
  1065. }
  1066. public function out_zhitui($data){
  1067. $header = array('推荐人姓名', '手机号', '身份证', '角色', '被推荐人姓名', '手机号', '身份证', '角色','代理费','奖励金','时间');
  1068. $body = array();
  1069. foreach($data as $k => $v){
  1070. if($v['parent_mid']>0){
  1071. $member = Dever::db('agent/member')->find($v['parent_mid']);
  1072. $prole_name = '';
  1073. if($member && $member['role']){
  1074. $prole = Dever::db('setting/role')->find($member['role']);
  1075. if($prole && $prole['name']){
  1076. $prole_name = $prole['name'];
  1077. }
  1078. }
  1079. $role_name = '';
  1080. if($v['role']){
  1081. $role = Dever::db('setting/role') ->find($v['role']);
  1082. if($role && $role['name']){
  1083. $role_name = $role['name'];
  1084. }
  1085. }
  1086. $order = Dever::db('agent/order')->find(array('mid'=>$v['id']));
  1087. $cdate = '';
  1088. if($v['cdate']){
  1089. $cdate = date('Y-m-d H:i',$v['cdate']);
  1090. }
  1091. if($member){
  1092. $d = array
  1093. (
  1094. $member['name'],
  1095. $member['mobile'],
  1096. $member['idcard'],
  1097. $prole_name,
  1098. $v['name'],
  1099. $v['mobile'],
  1100. $v['idcard'],
  1101. $role['name'],
  1102. $order['agent_cash'],
  1103. $v['cash'],
  1104. $cdate,
  1105. );
  1106. $body[] = $d;
  1107. }
  1108. }
  1109. }
  1110. $file = Dever::input('excel_name');
  1111. return Dever::excelExport($body, $header, $file);
  1112. }
  1113. }