Member.php 21 KB

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