Manage.php 49 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247
  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. $price = $this->addGoods($order, $v, $t);
  646. if ($price && $v['type'] < 3) {
  647. # 计算商品价值
  648. $goods_cash += $price;
  649. }
  650. }
  651. $update = array();
  652. if ($goods_cash) {
  653. $update['goods_cash'] = $goods_cash;
  654. }
  655. $update['goods_status'] = 3;
  656. $update['where_id'] = $order['id'];
  657. Dever::db('agent/order')->update($update);
  658. }
  659. }
  660. # 新增权益
  661. private function addGoods($order, $v, $t)
  662. {
  663. $cash = $price = 0;
  664. if ($v['type'] == 1) {
  665. $v['num'] = $v['num'] * $t;
  666. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($v['type_id'], $v['sku_id']);
  667. $price = $goods_info['price'];
  668. $cash = $goods_info['price'] * $v['num'];
  669. if (isset($goods_info['sku'])) {
  670. $sku = '-' . $goods_info['sku']['string'];
  671. } else {
  672. $sku = '';
  673. }
  674. $name = $goods_info['name'] . $sku;
  675. } elseif ($v['type'] == 2) {
  676. $v['sku_id'] = -1;
  677. # 生成一个电子券
  678. $card = Dever::db('card/info')->find($v['type_id']);
  679. if (!$card) {
  680. return false;
  681. }
  682. $name = $card['name'];
  683. if ($card['create_type'] == 2) {
  684. $cash = $card['value']*$v['num'] * $t;
  685. $price = $cash;
  686. $v['num'] = 1;
  687. $v['sku_id'] = Dever::load('card/lib/code')->create($card, 2, $order['mid'], $order['id'], $cash);
  688. if (!$v['sku_id']) {
  689. return false;
  690. }
  691. } elseif ($card['create_type'] == 3) {
  692. $cash = round($order['agent_cash']*($v['num']/100), 2);
  693. $price = $cash;
  694. $v['num'] = 1;
  695. $v['sku_id'] = Dever::load('card/lib/code')->create($card, 2, $order['mid'], $order['id'], $cash);
  696. if (!$v['sku_id']) {
  697. return false;
  698. }
  699. } else {
  700. $cash = $card['value'];
  701. $price = $cash;
  702. $total = $t*$v['num'];
  703. $t = 1;
  704. for($i=0; $i<$total;$i++) {
  705. $v['sku_id'] = Dever::load('card/lib/code')->create($card, 2, $order['mid'], $order['id'], $cash);
  706. if ($v['sku_id']) {
  707. $where['mid'] = $order['mid'];
  708. $where['type'] = $v['type'];
  709. $where['type_id'] = $v['type_id'];
  710. $where['sku_id'] = $v['sku_id'];
  711. $info = Dever::db('agent/member_goods')->find($where);
  712. if (!$info) {
  713. $up = $where;
  714. $up['total_num'] = $t;
  715. $up['cash'] = $cash;
  716. $up['price'] = $price;
  717. $up['name'] = $name;
  718. $state = Dever::db('agent/member_goods')->insert($up);
  719. if ($state) {
  720. Dever::load('agent/lib/member_set')->log($order['mid'], $order['order_num'], $v['type'], $v['type_id'], $v['sku_id'], $t, 0, $t, $name);
  721. }
  722. }
  723. }
  724. }
  725. return $cash * $total;
  726. }
  727. } elseif ($v['type'] == 3) {
  728. $prize = Dever::db('setting/prize')->find($v['type_id']);
  729. $v['num'] = $v['num'] * $t;
  730. $role = Dever::db('setting/role')->find($order['role']);
  731. if ($role && $role['max_me_num'] && $role['max_me_num'] < $v['num']) {
  732. $v['num'] = $role['max_me_num'];
  733. }
  734. $price = $prize['price'];
  735. $cash = $prize['price']*$v['num'];
  736. $name = $prize['name'];
  737. }
  738. $where['mid'] = $order['mid'];
  739. $where['type'] = $v['type'];
  740. $where['type_id'] = $v['type_id'];
  741. $where['sku_id'] = $v['sku_id'];
  742. $info = Dever::db('agent/member_goods')->find($where);
  743. if ($info) {
  744. $up['where_id'] = $info['id'];
  745. $up['total_num'] = $info['total_num'] + $v['num'];
  746. $up['cash'] = $cash;
  747. $up['price'] = $price;
  748. $up['name'] = $name;
  749. $state = Dever::db('agent/member_goods')->update($up);
  750. if ($state) {
  751. 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);
  752. }
  753. } else {
  754. $up = $where;
  755. $up['total_num'] = $v['num'];
  756. $up['cash'] = $cash;
  757. $up['price'] = $price;
  758. $up['name'] = $name;
  759. $state = Dever::db('agent/member_goods')->insert($up);
  760. if ($state) {
  761. 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);
  762. }
  763. }
  764. return $cash;
  765. }
  766. private function setCash($order)
  767. {
  768. $param = Dever::input('param');
  769. if ($param) {
  770. $param = explode(',', $param);
  771. foreach ($param as $k => $v) {
  772. $t = Dever::array_decode($v);
  773. # 判断是否名额内
  774. if (isset($t['prize_type']) && $t['prize_type'] == 2) {
  775. Dever::db('agent/member')->update(array('where_id' => $order['mid'], 'prize_type' => $t['prize_type']));
  776. }
  777. $parent_order = $order;
  778. $parent_order['mid'] = $t['parent_mid'];
  779. $where['type'] = $t['type'];
  780. $where['order_id'] = $order['id'];
  781. $where['mid'] = $order['mid'];
  782. $where['parent_mid'] = $t['parent_mid'];
  783. $info = Dever::db('agent/order_cash')->find($where);
  784. if (!$info) {
  785. $insert = $where;
  786. $insert['cash'] = $t['cash'];
  787. $insert['per'] = $t['per'];
  788. if (isset($t['prize_id'])) {
  789. $insert['prize_id'] = $t['prize_id'];
  790. }
  791. if (isset($t['goods'])) {
  792. $insert['goods'] = Dever::array_encode($t['goods']);
  793. }
  794. Dever::db('agent/order_cash')->insert($insert);
  795. } else {
  796. $update['where_id'] = $info['id'];
  797. $update['cash'] = $t['cash'];
  798. $update['per'] = $t['per'];
  799. if (isset($t['prize_id'])) {
  800. $update['prize_id'] = $t['prize_id'];
  801. }
  802. if (isset($t['goods'])) {
  803. $update['goods'] = Dever::array_encode($t['goods']);
  804. }
  805. Dever::db('agent/order_cash')->update($update);
  806. }
  807. if (isset($t['prize_id']) && isset($t['child_num'])) {
  808. $prize_info = Dever::db('setting/prize')->find($t['prize_id']);
  809. if ($prize_info) {
  810. $prize_insert['order_id'] = $order['order_id'];
  811. $prize_insert['mid'] = $t['parent_mid'];
  812. $prize_insert['child_num'] = $t['child_num'];
  813. $prize_insert['prize_id'] = $prize_info['id'];
  814. Dever::db('agent/member_prize')->insert($prize_insert);
  815. $prize['type'] = 3;
  816. $prize['type_id'] = $prize_info['id'];
  817. $prize['sku_id'] = -1;
  818. $prize['num'] = $prize_info['num'];
  819. $this->addGoods($parent_order, $prize, 1);
  820. }
  821. }
  822. if (isset($t['parent_goods_id'])) {
  823. $parent_goods = Dever::db('agent/member_goods')->getOne(array('id' => $t['parent_goods_id']));
  824. if ($parent_goods && $parent_goods['num'] > 0) {
  825. $parent_prize = Dever::db('setting/prize')->find($parent_goods['type_id']);
  826. if ($parent_prize) {
  827. # 检测有没有名额权益
  828. $prize_goods = Dever::db('setting/prize_goods')->select(array('prize_id' => $parent_prize['id']));
  829. if ($prize_goods) {
  830. # 赠送权益
  831. foreach ($prize_goods as $k1 => $v1) {
  832. $this->addGoods($parent_order, $v1, 1);
  833. }
  834. }
  835. $member = Dever::db('agent/member')->find($t['parent_mid']);
  836. if ($member) {
  837. $desc = $parent_prize['name'] . '名额使用';
  838. 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);
  839. }
  840. }
  841. }
  842. }
  843. if (!isset($t['parent_level'])) {
  844. $t['parent_level'] = false;
  845. }
  846. if (!isset($t['child_num'])) {
  847. $t['child_num'] = 0;
  848. }
  849. $member = Dever::db('agent/member')->find($where['mid']);
  850. $desc = $member['name'] . '成为代理商,佣金'.$t['per'].'%';
  851. 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']);
  852. # 自动升级
  853. if (isset($t['role_up']) && $t['role_up']) {
  854. $member = Dever::db('agent/member')->find(array('id' => $where['parent_mid']));
  855. $role = Dever::db('setting/role')->find($t['role_up']['t_role_id']);
  856. Dever::db('agent/member')->update(array('where_id' => $where['parent_mid'], 'role' => $t['role_up']['t_role_id']));
  857. if ($member && $role) {
  858. $this->upRole($member, $role, '', $order['id']);
  859. }
  860. }
  861. }
  862. }
  863. }
  864. private function setAgreement($order)
  865. {
  866. Dever::load('agent/lib/agreement')->up($order);
  867. }
  868. public function sellOrderUpdate($id, $name, $data)
  869. {
  870. Dever::config('base')->hook = true;
  871. $update = array();
  872. $audit = Dever::param('audit', $data);
  873. $desc = Dever::param('audit_desc', $data);
  874. $info = Dever::db('agent/dh_order')->one($id);
  875. if ($audit > 1 && $info && $info['status'] == 2) {
  876. if ($audit == 2) {
  877. # 成功
  878. Dever::setInput('order_id', $id);
  879. Dever::load('agent/lib/dhorder.audit_commit');
  880. } else {
  881. Dever::db('agent/dh_order')->update(array('where_id' => $id, 'status' => 7));
  882. Dever::load('agent/lib/dhorder')->updateSell($info, 2);
  883. if (Dever::project('sms')) {
  884. $member = Dever::db('agent/member')->find($info['mid']);
  885. Dever::load('sms/api')->send('daili_goods_no', $member['mobile'], array('name' => $member['name'], 'content' => $desc));
  886. }
  887. }
  888. }
  889. }
  890. public function sellOrderUpdateMul($id, $name, $data)
  891. {
  892. Dever::config('base')->hook = true;
  893. $status = Dever::param('status', $data);
  894. if ($status == 5) {
  895. $list = explode(',', $id);
  896. if ($list) {
  897. foreach ($list as $k => $v) {
  898. if (is_array($v)) {
  899. $id = $v['id'];
  900. $info = Dever::db('agent/dh_order')->one($id);
  901. } else {
  902. $id = $v;
  903. $info = Dever::db('agent/dh_order')->one($id);
  904. }
  905. $info['status'] = 4;
  906. Dever::load('agent/lib/dhorder')->finish($info, $info['shop_id']);
  907. }
  908. }
  909. }
  910. }
  911. # 确认收货
  912. public function setDhOrderStatus_api()
  913. {
  914. $order_id = Dever::input('order_id');
  915. $info = Dever::db('agent/dh_order')->find($order_id);
  916. if ($info) {
  917. Dever::load('agent/lib/dhorder')->finish($info, $info['shop_id']);
  918. return 'reload';
  919. } else {
  920. Dever::alert('错误的订单号');
  921. }
  922. }
  923. # 获取权益名称
  924. public function getGoods($type, $type_id, $sku_id, $name = '')
  925. {
  926. if ($type == 1) {
  927. if ($name) {
  928. return array('name' => $name . '('.$type_id.')');
  929. }
  930. if ($sku_id == -2) {
  931. return '商品';
  932. }
  933. $goods_info = Dever::load('goods/lib/info')->getInfoBySku($type_id, $sku_id);
  934. if (isset($goods_info['sku'])) {
  935. $sku = '-' . $goods_info['sku']['string'];
  936. } else {
  937. $sku = '';
  938. }
  939. return array('name' => $goods_info['name'] . $sku . '('.$type_id.')', 'price' => $goods_info['price']);
  940. } elseif ($type == 2) {
  941. $code = Dever::db('card/code')->find($sku_id);
  942. $card = Dever::db('card/info')->find($code['card_id']);
  943. return array('name' => $card['name'] . '('.$type_id.') <br /> ' . $code['card'], 'price' => $code['total_cash']);
  944. } elseif ($type == 3) {
  945. if ($name) {
  946. return array('name' => $name . '('.$type_id.')');
  947. }
  948. $prize = Dever::db('setting/prize')->find($type_id);
  949. return array('name' => $prize['name'] . '('.$type_id.')', 'price' => $prize['price']);
  950. }
  951. }
  952. public function setOrderStatus_api()
  953. {
  954. $where['where_id'] = Dever::input('id');
  955. $order = Dever::db('agent/order')->find($where['where_id']);
  956. if ($order) {
  957. $where['status'] = Dever::input('status');
  958. if ($where['status'] == 6) {
  959. $where['history_status'] = $order['status'];
  960. }
  961. Dever::db('agent/order')->update($where);
  962. if ($where['status'] == 7 && $order['get_type'] == 1) {
  963. # 关闭订单
  964. $member = Dever::db('agent/member')->find($order['mid']);
  965. if ($member) {
  966. Dever::db('agent/member')->update(array('where_id' => $member['id'], 'state' => 2));
  967. }
  968. }
  969. }
  970. return 'reload';
  971. }
  972. public function upSignAgreement_api()
  973. {
  974. $id = Dever::input('id');
  975. if ($id) {
  976. Dever::load('agent/lib/agreement')->upContent($id, true);
  977. }
  978. return 'reload';
  979. }
  980. public function upAgreement_api()
  981. {
  982. $id = Dever::input('id');
  983. if ($id) {
  984. Dever::load('agent/lib/agreement')->upContent($id);
  985. }
  986. return 'reload';
  987. }
  988. public function dropAgreement_api()
  989. {
  990. $id = Dever::input('id');
  991. if ($id) {
  992. Dever::load('agent/lib/agreement')->drop($id);
  993. }
  994. return 'reload';
  995. }
  996. public function memberShop_api(){
  997. $data = Dever::db('agent/member')->getShopAll(array('shop_id'=>1,'state'=>1));
  998. if($data){
  999. foreach($data as $k=>$v){
  1000. $log = Dever::db('agent/member_shop_log')->find(array('mid'=>$v['id']));
  1001. if($log){
  1002. }else{
  1003. Dever::db('agent/member_shop_log')->insert(array('mid'=>$v['id'],'new_shop_id'=>$v['shop_id'],'cdate'=>'1651680000'));
  1004. }
  1005. }
  1006. }
  1007. return 'ok';
  1008. }
  1009. public function updateUserBind($id, $name, $data)
  1010. {
  1011. Dever::config('base')->hook = true;
  1012. $update = array();
  1013. $audit = Dever::param('audit', $data);
  1014. $desc = Dever::param('audit_desc', $data);
  1015. $info = Dever::db('agent/user_bind')->one($id);
  1016. if ($info) {
  1017. if ($audit) {
  1018. $update['where_id'] = $info['id'];
  1019. $update['audit_date'] = time();
  1020. $update['status'] = $audit;
  1021. $admin = Dever::load('manage/auth.info');
  1022. $update['admin'] = $admin['id'];
  1023. Dever::db('agent/user_bind')->update($update);
  1024. }
  1025. }
  1026. }
  1027. public function search_api()
  1028. {
  1029. $where = array();
  1030. return Dever::search('agent/member', $where);
  1031. }
  1032. public function out_arealog($data){
  1033. $header = array('区域名称', '区域价值', '售出时间');
  1034. $body = array();
  1035. foreach($data as $k1=> $v1){
  1036. $member = Dever::db('agent/member')->find($v1['mid']);
  1037. $role = Dever::db('setting/role')->find($member['role']);
  1038. if ($role['type'] == 1) {
  1039. $data[$k1]['price'] = $role['price'];
  1040. }
  1041. if(isset($data[$k1]['price']) && $data[$k1]['price']<1){
  1042. unset($data[$k1]);
  1043. }
  1044. }
  1045. $res = array_values($data);
  1046. foreach($res as $k=>$v){
  1047. $res[$k]['areas'] = Dever::load("area/api.string", $v['area']);
  1048. $member = Dever::db('agent/member')->find($v['mid']);
  1049. $role = Dever::db('setting/role')->find($member['role']);
  1050. $res[$k]['cdate'] = date('Y-m-d H:i',$v['cdate']);
  1051. if ($role['type'] == 1) {
  1052. $res[$k]['price'] = $role['price'];
  1053. } elseif ($role['type'] == 2) {
  1054. $res[$k]['price'] = Dever::load('area/api')->getPrice($role['area'], $v['area']);
  1055. }
  1056. $d = array
  1057. (
  1058. $res[$k]['areas'],
  1059. $res[$k]['price'],
  1060. $res[$k]['cdate']
  1061. );
  1062. $body[] = $d;
  1063. }
  1064. $file = Dever::input('excel_name');
  1065. return Dever::excelExport($body, $header, $file);
  1066. }
  1067. public function out_zhitui($data){
  1068. $header = array('推荐人姓名', '手机号', '身份证', '角色', '被推荐人姓名', '手机号', '身份证', '角色','代理费','奖励金','时间');
  1069. $body = array();
  1070. foreach($data as $k => $v){
  1071. if($v['parent_mid']>0){
  1072. $member = Dever::db('agent/member')->find($v['parent_mid']);
  1073. $prole_name = '';
  1074. if($member && $member['role']){
  1075. $prole = Dever::db('setting/role')->find($member['role']);
  1076. if($prole && $prole['name']){
  1077. $prole_name = $prole['name'];
  1078. }
  1079. }
  1080. $role_name = '';
  1081. if($v['role']){
  1082. $role = Dever::db('setting/role') ->find($v['role']);
  1083. if($role && $role['name']){
  1084. $role_name = $role['name'];
  1085. }
  1086. }
  1087. $order = Dever::db('agent/order')->find(array('mid'=>$v['id']));
  1088. $cdate = '';
  1089. if($v['cdate']){
  1090. $cdate = date('Y-m-d H:i',$v['cdate']);
  1091. }
  1092. if($member){
  1093. $d = array
  1094. (
  1095. $member['name'],
  1096. $member['mobile'],
  1097. $member['idcard'],
  1098. $prole_name,
  1099. $v['name'],
  1100. $v['mobile'],
  1101. $v['idcard'],
  1102. $role['name'],
  1103. $order['agent_cash'],
  1104. $v['cash'],
  1105. $cdate,
  1106. );
  1107. $body[] = $d;
  1108. }
  1109. }
  1110. }
  1111. $file = Dever::input('excel_name');
  1112. return Dever::excelExport($body, $header, $file);
  1113. }
  1114. }