Member.php 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650
  1. <?php
  2. namespace Agent\Lib;
  3. use Dever;
  4. class Member
  5. {
  6. public function getOne($id, $table = 'agent/member', $area = false)
  7. {
  8. if ($id < 0) {
  9. return '无';
  10. }
  11. $member = Dever::db($table)->find($id);
  12. if ($member) {
  13. if (isset($member['mid'])) {
  14. $member['id'] = $member['mid'];
  15. }
  16. $member['role'] = Dever::db('setting/role')->find($member['role']);
  17. $url = Dever::url('project/database/list?project=agent&table=member_area&mid='.$member['id'].'&page_type=1&[refer]', 'manage');
  18. $member['name'] = '<a href="'.$url.'">' . $member['name'] . '</a>';
  19. $code = Dever::load("invite/api.code", $member['id']);
  20. $string = '';
  21. if ($code) {
  22. $string = '[' . $code . '] <br />';
  23. }
  24. $string .= $member['name'] . '<br />' . $member['mobile'] . '<br />' . $member['role']['name'];
  25. if (isset($member['level_id']) && $member['level_id'] && $member['level_id'] > 0) {
  26. $member['level'] = Dever::db('setting/level')->find($member['level_id']);
  27. $string .= '('.$member['level']['name'].')';
  28. }
  29. if (isset($member['shop_id']) && $member['shop_id'] > 0) {
  30. $string .= ' ' . Dever::load("shop/info-one#name", $member['shop_id']);
  31. }
  32. if ($area) {
  33. $area = Dever::load("area/api.string", $member['area']);
  34. if ($area) {
  35. $string .= '<br />' . $area;
  36. }
  37. }
  38. $member['mobile'] = strip_tags($member['mobile']);
  39. $url = Dever::url('project/database/list?project=agent&table=member&search_api_parent_mid='.$member['mobile'].'&[refer]', 'manage');
  40. $string .= '<br /><a href="'.$url.'">直推:'. Dever::load("invite/api")->getChildNum($member['id'], 1) . '</a>';
  41. if ($member['source_id'] > 0) {
  42. $source = Dever::db('setting/source')->one($member['source_id']);
  43. if ($source) {
  44. $string .= '<br />来源:' . $source['name'];
  45. }
  46. }
  47. return $string;
  48. } else {
  49. return '';
  50. }
  51. }
  52. public function getInfoString($member)
  53. {
  54. $member = $this->getInfo($member);
  55. $info = '代理商信息:'.$member['name'].' '.$member['mobile'].' ' . $member['role']['name'];
  56. if ($member && isset($member['level']) && $member['level']) {
  57. $info .= '('.$member['level']['name'].')';
  58. }
  59. return $info;
  60. }
  61. public function getInfo($member)
  62. {
  63. Dever::setInput('getInfo', 1);
  64. if (is_numeric($member)) {
  65. $member = Dever::db('agent/member')->find($member);
  66. }
  67. $member['area_string'] = Dever::load("area/api.string", $member['area'], '/', true, '');
  68. $member['role'] = Dever::db('setting/role')->find($member['role']);
  69. $member['level'] = Dever::db('setting/level')->find($member['level_id']);
  70. $member['shop'] = array();
  71. if ($member['shop_id'] && $member['shop_id'] > 0) {
  72. $member['shop'] = Dever::db('shop/info')->getOne($member['shop_id']);
  73. }
  74. $data = Dever::load('passport/reg')->getSign($member['id']);
  75. if ($data['signature']) {
  76. $member['signature'] = $data['signature'];
  77. }
  78. $member['birthday'] = date('Y-m-d', $member['birthday']);
  79. return $member;
  80. }
  81. /**
  82. * 检测邀请码
  83. *
  84. * @return mixed
  85. */
  86. public function checkCode()
  87. {
  88. $code = Dever::input('code');
  89. if (!$code) {
  90. Dever::alert('请输入邀请码');
  91. }
  92. $uid = Dever::load('invite/api')->getUid($code);
  93. if (!$uid) {
  94. Dever::alert('邀请码错误');
  95. }
  96. $user = Dever::db('agent/member')->find($uid);
  97. if (!$user) {
  98. Dever::alert('邀请码错误');
  99. }
  100. if ($user['status'] <= 2) {
  101. return $user;
  102. }
  103. Dever::alert('邀请人状态不正常');
  104. }
  105. /**
  106. * 验证手机号
  107. * @return mixed
  108. */
  109. public function checkMobile($mobile)
  110. {
  111. $rule = Dever::rule('mobile');
  112. if (!$mobile) {
  113. Dever::alert('手机号不能为空');
  114. }
  115. if (!preg_match($rule, $mobile)) {
  116. Dever::alert('手机号码格式错误');
  117. }
  118. return $mobile;
  119. }
  120. /**
  121. * 验证验证码
  122. * @return mixed
  123. */
  124. public function checkMcode($mobile)
  125. {
  126. $code = Dever::input('mcode');
  127. if (!$code) {
  128. Dever::alert('请输入验证码');
  129. }
  130. $code = Dever::load('passport/reg')->mcode($mobile, $code, 1);
  131. if (!$code) {
  132. Dever::alert('验证码输入错误');
  133. }
  134. }
  135. /**
  136. * 更新余额和业绩
  137. * @return mixed
  138. */
  139. public function up($member, $order_id, $role, $type, $mid, $cash, $sell, $level_id = false, $desc = '', $group_num = 0)
  140. {
  141. $data['where_id'] = $mid;
  142. if ($cash) {
  143. Dever::load('bill/lib/cash')->up($mid, $type, $cash, $role, $order_id, $desc, 2);
  144. $data['cash'] = $cash;
  145. } else {
  146. $data['cash'] = 0;
  147. }
  148. Dever::load('bill/lib/sell')->up($mid, $type, $sell, $role, $order_id, $desc);
  149. $data['upcol'] = $sell;
  150. if ($level_id) {
  151. $data['level_id'] = $level_id;
  152. }
  153. //$method = 'upGroupSell';
  154. if ($type == 1) {
  155. $method = 'upSell';
  156. } else {
  157. $method = 'upGroupSell';
  158. }
  159. $data['clear'] = true;
  160. Dever::db('agent/member')->$method($data);
  161. if ($level_id) {
  162. Dever::load('agent/lib/level_log')->up($mid, $order_id, $member['level_id'], $level_id, $sell, $member['sell'] + $sell, $group_num);
  163. }
  164. }
  165. /**
  166. * 查看详情
  167. * @return mixed
  168. */
  169. public function show()
  170. {
  171. $mid = Dever::input('mid');
  172. $member = Dever::db('agent/member')->one($mid);
  173. $config_type = Dever::db('agent/member')->config['config_type'];
  174. $config_status = Dever::db('agent/member')->config['config_status'];
  175. $result['代理商信息'] = $this->getShowInfo($member);
  176. if ($member['parent_mid'] && $member['parent_mid'] > 0) {
  177. $parent = Dever::db('agent/member')->one($member['parent_mid']);
  178. if ($parent) {
  179. $result['上级信息'] = $this->getShowInfo($parent);
  180. }
  181. }
  182. $idcard_pic = '<a href="'.$member['idcard_front'].'" target="_blank"><img src="'.$member['idcard_front'].'" width="100" /></a>';
  183. if ($member['idcard_back']) {
  184. $idcard_pic .= '&nbsp;&nbsp;<a href="'.$member['idcard_back'].'" target="_blank"><img src="'.$member['idcard_back'].'" width="100" /></a>';
  185. }
  186. $member_name = $member['name'];
  187. $member_number = $member['idcard'];
  188. $result['认证信息'] = array
  189. (
  190. 'type' => 'info',
  191. 'content' => array
  192. (
  193. array
  194. (
  195. array('类型', $config_type[$member['type']]),
  196. array('姓名', $member_name),
  197. array('身份证号', $member_number),
  198. ),
  199. ),
  200. );
  201. if ($member['type'] == 2) {
  202. $company_pic = '<a href="'.$member['company_pic'].'" target="_blank"><img src="'.$member['company_pic'].'" width="100" /></a>';
  203. $member_name = $member['company_name'];
  204. $member_number = $member['company_number'];
  205. $result['认证信息']['content'][] = array
  206. (
  207. array('企业名称', $member_name),
  208. array('营业执照', $member_number),
  209. array('营业执照照片', $company_pic),
  210. );
  211. }
  212. $result['认证信息']['content'][] = array
  213. (
  214. array('身份证照片', $idcard_pic),
  215. );
  216. $button = array();
  217. if (Dever::load('manage/auth')->checkFunc('agent.member', 'edit', '修改基础资料')) {
  218. $button[0]['btn'][] = array
  219. (
  220. 'type' => 'edit',
  221. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=name,mobile,password,email,shop_id,area,role,level_id,is_shop', 'manage'),
  222. 'name' => '修改基础资料',
  223. );
  224. }
  225. if (Dever::load('manage/auth')->checkFunc('agent.member','sport','修改认证资料')) {
  226. $button[0]['btn'][] = array
  227. (
  228. 'type' => 'edit',
  229. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=type,idcard,idcard_front,idcard_back,company_name,company_pic,company_number', 'manage'),
  230. 'name' => '修改认证资料',
  231. );
  232. }
  233. /*
  234. $button[] = array
  235. (
  236. 'type' => 'edit',
  237. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=shop_id', 'manage'),
  238. 'name' => '修改归属门店',
  239. );
  240. */
  241. $url = '';
  242. if (Dever::load('manage/auth')->checkFunc('agent.member', 'bun', '禁用账号')) {
  243. if ($member['status'] == 5) {
  244. $button[0]['btn'][] = array
  245. (
  246. 'type' => 'action',
  247. 'link' => Dever::url('lib/member.setStatus?id=' . $member['id'] . '&value=2', 'agent'),
  248. 'name' => '恢复账号',
  249. );
  250. } elseif ($member['status'] == 2) {
  251. $button[0]['btn'][] = array
  252. (
  253. 'type' => 'action',
  254. 'link' => Dever::url('lib/member.setStatus?id=' . $member['id'] . '&value=5', 'agent'),
  255. 'name' => '禁用账号',
  256. );
  257. }
  258. }
  259. $button[0]['btn'][] = array
  260. (
  261. 'type' => 'link',
  262. 'link' => Dever::url('project/database/list?project=agent&table=order&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  263. 'name' => '代理订单',
  264. );
  265. $button[0]['btn'][] = array
  266. (
  267. 'type' => 'link',
  268. 'link' => Dever::url('project/database/list?project=agent&table=order&search_api_parent_mid='.$member['mobile'].'&[refer]', 'manage'),
  269. 'name' => '直推代理订单',
  270. );
  271. $button[0]['btn'][] = array
  272. (
  273. 'type' => 'link',
  274. 'link' => Dever::url('project/database/list?project=agent&table=member_level_log&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  275. 'name' => '升级日志',
  276. );
  277. if (Dever::load('manage/auth')->checkFunc('agent.member', 'edit1', '发放资金')) {
  278. $button[1]['btn'][] = array
  279. (
  280. 'type' => 'edit',
  281. 'link' => Dever::url('project/database/update?project=bill&table=push_cash&search_option_mid='.$member['id'], 'manage'),
  282. 'name' => '发放资金',
  283. );
  284. }
  285. if (Dever::load('manage/auth')->checkFunc('agent.member', 'edit2', '发放业绩')) {
  286. $button[1]['btn'][] = array
  287. (
  288. 'type' => 'edit',
  289. 'link' => Dever::url('project/database/update?project=bill&table=push_sell&search_option_mid='.$member['id'], 'manage'),
  290. 'name' => '发放业绩',
  291. );
  292. }
  293. $button[1]['btn'][] = array
  294. (
  295. 'type' => 'link',
  296. 'link' => Dever::url('project/database/list?project=bill&table=cash&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  297. 'name' => '资金账户',
  298. );
  299. $button[1]['btn'][] = array
  300. (
  301. 'type' => 'link',
  302. 'link' => Dever::url('project/database/list?project=bill&table=sell&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  303. 'name' => '业绩流水',
  304. );
  305. $button[1]['btn'][] = array
  306. (
  307. 'type' => 'link',
  308. 'link' => Dever::url('project/database/list?project=agent&table=member_goods&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  309. 'name' => '代理商权益',
  310. );
  311. $button[1]['btn'][] = array
  312. (
  313. 'type' => 'link',
  314. 'link' => Dever::url('project/database/list?project=agent&table=dh_order&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  315. 'name' => '权益订单',
  316. );
  317. $button[2]['btn'][] = array
  318. (
  319. 'type' => 'link',
  320. 'link' => Dever::url('project/database/list?project=agent&table=member_agreement&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  321. 'name' => '代理商合同',
  322. );
  323. $button[2]['btn'][] = array
  324. (
  325. 'type' => 'link',
  326. 'link' => Dever::url('project/database/list?project=agent&table=member&search_api_parent_mid='.$member['mobile'].'&[refer]', 'manage'),
  327. 'name' => '查看直推团队',
  328. );
  329. /*
  330. $button[2]['btn'][] = array
  331. (
  332. 'type' => 'edit',
  333. 'link' => Dever::url('lib/member.setStatus?id=' . $member['id'] . '&value=5', 'agent'),
  334. 'name' => '查看邀请关系',
  335. );
  336. */
  337. $furl = '';
  338. if (Dever::load('manage/auth')->checkFunc('agent.member','set','设置直推上级')) {
  339. $button[2]['btn'][] = array
  340. (
  341. 'type' => 'edit',
  342. 'link' => Dever::url('project/database/update?project=agent&table=member_parent&mid='.$member['id'], 'manage'),
  343. 'name' => '设置直推上级',
  344. );
  345. }
  346. if (Dever::load('manage/auth')->checkFunc('agent.member', 'edit6', '查看关系图谱')) {
  347. $button[2]['btn'][] = array
  348. (
  349. 'type' => 'link',
  350. 'link' => Dever::url('lib/manage.relation?mid='.$member['id'].'&[refer].manage', 'agent'),
  351. 'name' => '查看关系图谱',
  352. );
  353. }
  354. $head_btn[] = array
  355. (
  356. 'type' => 'link',
  357. 'link' => 'refer',
  358. 'name' => '返回上一页',
  359. );
  360. $head = array
  361. (
  362. 'name' => '基本信息',
  363. 'btn' => $head_btn,
  364. );
  365. $foot = $button;
  366. $html = Dever::show($head, $result, $foot);
  367. return $html;
  368. }
  369. private function getShowInfo($member)
  370. {
  371. $role = Dever::db('setting/role')->one($member['role']);
  372. $level = Dever::db('setting/level')->one($member['level_id']);
  373. $area = Dever::load("area/api.string", $member['area'], '-', true, '');
  374. $code = Dever::load("invite/api.code", $member['id']);
  375. if ($member['shop_id']) {
  376. $shop = Dever::db('shop/info')->one($member['shop_id']);
  377. } else {
  378. $shop['id'] = -1;
  379. $shop['name'] = '无';
  380. }
  381. $result = array();
  382. if ($level) {
  383. $role['name'] .= '(' . $level['name'] . ')';
  384. }
  385. if (!$member['cash']) {
  386. $member['cash'] = 0;
  387. }
  388. if (!$member['sell']) {
  389. $member['sell'] = 0;
  390. }
  391. if (!$member['group_sell']) {
  392. $member['group_sell'] = 0;
  393. }
  394. $result = array
  395. (
  396. 'type' => 'info',
  397. 'content' => array
  398. (
  399. array
  400. (
  401. array('代理商姓名', $member['name']),
  402. array('手机号', $member['mobile']),
  403. array('邀请码', $code),
  404. ),
  405. array
  406. (
  407. array('代理角色', $role['name']),
  408. array('代理区域', $area),
  409. array('所属店铺', $shop['name']),
  410. ),
  411. array
  412. (
  413. array('资金余额', '<span style="color:blue">¥' . $member['cash'] . '元</span>'),
  414. array('直推业绩', '<span style="color:blue">¥' . $member['sell'] . '元</span>'),
  415. array('团队业绩', '<span style="color:blue">¥' . $member['group_sell'] . '元</span>'),
  416. ),
  417. ),
  418. );
  419. return $result;
  420. }
  421. public function setStatus_api()
  422. {
  423. $where['where_id'] = Dever::input('id');
  424. $where['status'] = Dever::input('value');
  425. Dever::db('agent/member')->update($where);
  426. return 'reload';
  427. }
  428. public function create($data)
  429. {
  430. $update['mobile'] = $data['mobile'];
  431. $info = Dever::db('agent/member')->find(array('mobile' => $data['mobile']));
  432. $update['name'] = $data['name'];
  433. $update['idcard'] = $data['idcard'];
  434. $update['idcard_front'] = $data['idcard_front'];
  435. $update['idcard_back'] = $data['idcard_back'];
  436. $update['company_name'] = $data['company_name'];
  437. $update['company_pic'] = $data['company_pic'];
  438. $update['company_number'] = $data['company_number'];
  439. $update['parent_mid'] = $data['parent_mid'];
  440. $update['source_id'] = $data['source_id'];
  441. $update['type'] = $data['type'];
  442. if (!$info) {
  443. $update['role'] = 1;
  444. $update['level_id'] = -1;
  445. $mid = Dever::db('agent/member')->insert($update);
  446. /*
  447. if ($mid && $data['parent_mid'] && $data['parent_mid'] > 0) {
  448. Dever::load('invite/api')->setRelation($mid, $data['parent_mid']);
  449. }
  450. */
  451. return $mid;
  452. } else {
  453. $update['where_id'] = $info['id'];
  454. Dever::db('agent/member')->update($update);
  455. return $info['id'];
  456. }
  457. }
  458. #认证时间
  459. public function set_rdate($id){
  460. $info=Dever::db('agent/member')->one(array('id'=>$id,'state'=>1));
  461. if($info['cdate']){
  462. $data['注册时间']=date('Y-m-d H:i',$info['cdate']);
  463. }else{
  464. $data['注册时间']='-';
  465. }
  466. if($info['status']==2){
  467. if($info['rdate']){
  468. $data['认证时间']=date('Y-m-d H:i',$info['rdate']);
  469. }else{
  470. $data['认证时间']='-';
  471. }
  472. }else{
  473. $data['认证时间']='-';
  474. }
  475. // $html = Dever::table($data);
  476. return '注册时间:'.$data['注册时间'].'<br/>认证时间:'.$data['认证时间'];
  477. }
  478. #更改收件人信息
  479. public function set_mobile($id){
  480. $info=Dever::db('agent/dh_order')->one(array('id'=>$id,'state'=>1));
  481. $data=array();
  482. if($info['name']=='兑换商品'){
  483. $address=Dever::db('agent/member_address')->one(array('id'=>$info['address_id'],'state'=>1));
  484. $data['联系人']=$address['contact'];
  485. $data['联系电话']=$address['mobile'];
  486. $res=Dever::load('agent/address')->getOne($address['mid'],$address['id']);
  487. $data['详细地址']=$res['address_info'].$address['house_number'];
  488. // $data['门牌号']=$address['house_number'];
  489. return $data['联系人'].'<br/>'.$data['联系电话'].'<br/>'.$data['详细地址'];
  490. }else{
  491. return '';
  492. }
  493. // $html=Dever::table($data);
  494. // return $html;
  495. }
  496. public function daili($id){
  497. $info=Dever::db('agent/member')->one(array('id'=>$id,'state'=>1));
  498. $member['role'] = Dever::db('setting/role')->find($info['role']);
  499. $name ='<a href='.Dever::url('project/database/list&project=bill&table=sell&menu=bill&search_option_state=1&function=&method=search&search_api_mid='.$info['mobile'].'&search_fulltext_order_num=&search_option_start_cdate=&search_option_end_cdate=&excel=2&page_type=2', 'manage').'>'.$info['name'].'</a>';
  500. $mobile = $info['mobile'];
  501. $role = $member['role']['name'];
  502. if (isset($info['level_id']) && $info['level_id'] && $info['level_id'] > 0) {
  503. $info['level'] = Dever::db('setting/level')->find($info['level_id']);
  504. $role .= '('.$info['level']['name'].')';
  505. }
  506. $html = $name.'<br/>'.$mobile.'<br/>'.$role;
  507. return $html;
  508. }
  509. #上级信息
  510. public function sdaili($id){
  511. $res=Dever::db('agent/member')->one(array('id'=>$id,'state'=>1));
  512. if($res['parent_mid']>0){
  513. $info=Dever::db('agent/member')->one(array('id'=>$res['parent_mid'],'state'=>1));
  514. $member['role'] = Dever::db('setting/role')->find($info['role']);
  515. $data['姓名']='<a href='.Dever::url('project/database/list&project=bill&table=sell&menu=bill&search_option_state=1&function=&method=search&search_api_mid='.$info['mobile'].'&search_fulltext_order_num=&search_option_start_cdate=&search_option_end_cdate=&excel=2&page_type=2', 'manage').'>'.$info['name'].'</a>';
  516. $data['电话']=$info['mobile'];
  517. $data['角色']=$member['role']['name'];
  518. if (isset($info['level_id']) && $info['level_id'] && $info['level_id'] > 0) {
  519. $info['level'] = Dever::db('setting/level')->find($info['level_id']);
  520. $data['角色'] .= '('.$info['level']['name'].')';
  521. }
  522. $data['团队业绩']=$info['group_sell'];
  523. $html = $data['姓名'].'<br/>'.$data['电话'].'<br/>'.$data['角色'].'<br/>'.$data['团队业绩'];
  524. return $html;
  525. }elseif($res['source_id']){
  526. $source=Dever::db('setting/source')->one(array('id'=>$res['source_id'],'state'=>1));
  527. $data['来源']=$source['name'];
  528. return $html =$data['来源'];
  529. }else{
  530. return '无';
  531. }
  532. }
  533. public function search_api()
  534. {
  535. $value = Dever::input('value');
  536. if ($value) {
  537. $parent_mid = Dever::load('invite/api')->getUid($value);
  538. $table = array();
  539. if ($parent_mid) {
  540. $member = Dever::db('agent/member')->find($parent_mid);
  541. if (!$member) {
  542. return '暂无账号';
  543. }
  544. $table = array();
  545. $table['head'] = array('姓名', '手机号');
  546. $table['body'] = array();
  547. $table['body'][] = array($member['name'], $member['mobile']);
  548. $result[] = array
  549. (
  550. 'type' => 'table',
  551. 'content' => $table,
  552. );
  553. $html = Dever::show('', $result, false, false);
  554. return $html;
  555. }
  556. return '暂无账号';
  557. } else {
  558. return '';
  559. }
  560. }
  561. }