Member.php 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883
  1. <?php
  2. namespace Agent\Lib;
  3. use Dever;
  4. class Member
  5. {
  6. public function getUserNum($id)
  7. {
  8. return Dever::load("invite/api")->getChildNum($id, false);
  9. }
  10. public function getOne($id, $table = 'agent/member', $area = false, $admin_auth = false)
  11. {
  12. if ($id < 0) {
  13. return '无';
  14. }
  15. $member = Dever::db($table)->one($id);
  16. if ($member) {
  17. if (isset($member['mid'])) {
  18. $member['id'] = $member['mid'];
  19. }
  20. $member['role'] = Dever::db('setting/role')->find($member['role']);
  21. $url = Dever::url('project/database/list?project=agent&table=member_area&mid='.$member['id'].'&page_type=1&[refer]', 'manage');
  22. $member['name'] = '<a href="'.$url.'">' . $member['name'] . '</a>';
  23. $code = Dever::load("invite/api.code", $member['id']);
  24. $string = '';
  25. if ($code) {
  26. $string = '[' . $code . '] <br />';
  27. }
  28. $prize_type = '';
  29. if($member['role']['id'] == 8){
  30. if($member['prize_type'] && $member['prize_type'] == 1){
  31. $prize_type = '(名额外)';
  32. }elseif($member['prize_type'] && $member['prize_type'] == 2){
  33. $prize_type = '(名额内)';
  34. }
  35. }
  36. $string .= $member['name'] . '('.$member['id'].')' .'<br />' . $member['mobile'] . '<br />' . $member['role']['name'].$prize_type;
  37. if (!$admin_auth) {
  38. if (isset($member['level_id']) && $member['level_id'] && $member['level_id'] > 0) {
  39. $member['level'] = Dever::db('setting/level')->find($member['level_id']);
  40. $string .= '('.$member['level']['name'].')';
  41. }
  42. }
  43. if (isset($member['shop_id']) && $member['shop_id'] > 0) {
  44. $string .= ' ' . Dever::load("shop/info-one#name", $member['shop_id']);
  45. }
  46. if ($area) {
  47. $area = Dever::load("area/api.string", $member['area']);
  48. if ($area) {
  49. $string .= '<br />' . $area;
  50. }
  51. }
  52. $member['mobile'] = strip_tags($member['mobile']);
  53. $url = Dever::url('project/database/list?project=agent&table=member&search_api_parent_mid='.$member['mobile'].'&[refer]', 'manage');
  54. if (!$admin_auth) {
  55. $string .= '<br /><a href="'.$url.'">直推:'. Dever::load("invite/api")->getChildNum($member['id'], 1) . '</a>';
  56. }
  57. if ($member['source_id'] > 0) {
  58. $source = Dever::db('setting/source')->one($member['source_id']);
  59. if ($source) {
  60. $string .= '<br />来源:' . $source['name'];
  61. }
  62. }
  63. return $string;
  64. } else {
  65. return '';
  66. }
  67. }
  68. public function getInfoString($member)
  69. {
  70. $member = $this->getInfo($member);
  71. $info = '代理商信息:'.$member['name'].' '.$member['mobile'].' ' . $member['role']['name'];
  72. if ($member && isset($member['level']) && $member['level']) {
  73. $info .= '('.$member['level']['name'].')';
  74. }
  75. return $info;
  76. }
  77. public function getInfo($member)
  78. {
  79. Dever::setInput('getInfo', 1);
  80. if (is_numeric($member)) {
  81. $member = Dever::db('agent/member')->find($member);
  82. }
  83. $member['area_string'] = Dever::load("area/api.string", $member['area'], '/', true, '');
  84. $member['role'] = Dever::db('setting/role')->find($member['role']);
  85. $member['level'] = Dever::db('setting/level')->find($member['level_id']);
  86. $member['title'] = array();
  87. if($member['title_id']) {
  88. $title_id = explode(',',$member['title_id']);
  89. if ($title_id) {
  90. foreach ($title_id as $k =>$v) {
  91. $title[] = Dever::db('setting/title')->getTitle(array('id'=>$v));
  92. }
  93. }
  94. foreach ($title as $k1 => $v1) {
  95. $t[] = $v1['name'];
  96. }
  97. if ($t) {
  98. $member['title'] = implode('、',$t);
  99. }
  100. }
  101. $member['shop'] = array();
  102. if ($member['shop_id'] && $member['shop_id'] > 0) {
  103. $member['shop'] = Dever::db('shop/info')->find($member['shop_id']);
  104. }
  105. $data = Dever::load('passport/reg')->getSign($member['id']);
  106. if ($data['signature']) {
  107. $member['signature'] = $data['signature'];
  108. }
  109. $member['birthday'] = date('Y-m-d', $member['birthday']);
  110. return $member;
  111. }
  112. /**
  113. * 检测邀请码
  114. *
  115. * @return mixed
  116. */
  117. public function checkCode()
  118. {
  119. $code = Dever::input('code');
  120. if (!$code) {
  121. Dever::alert('请输入邀请码');
  122. }
  123. $uid = Dever::load('invite/api')->getUid($code);
  124. if (!$uid) {
  125. Dever::alert('请输入正确的邀请码');
  126. }
  127. $user = Dever::db('agent/member')->find($uid);
  128. if (!$user) {
  129. Dever::alert('请输入正确的邀请码');
  130. }
  131. if ($user['status'] <= 2) {
  132. return $user;
  133. }
  134. Dever::alert('邀请人状态不正常');
  135. }
  136. /**
  137. * 验证手机号
  138. * @return mixed
  139. */
  140. public function checkMobile($mobile)
  141. {
  142. $rule = Dever::rule('mobile');
  143. if (!$mobile) {
  144. Dever::alert('手机号不能为空');
  145. }
  146. if (!preg_match($rule, $mobile)) {
  147. Dever::alert('手机号码格式错误');
  148. }
  149. return $mobile;
  150. }
  151. /**
  152. * 验证验证码
  153. * @return mixed
  154. */
  155. public function checkMcode($mobile)
  156. {
  157. $code = Dever::input('mcode');
  158. if (!$code) {
  159. Dever::alert('请输入验证码');
  160. }
  161. $code = Dever::load('passport/reg')->mcode($mobile, $code, 1);
  162. if ($mobile == '18030186059') {
  163. return;
  164. }
  165. if (!$code) {
  166. Dever::alert('验证码输入错误');
  167. }
  168. }
  169. /**
  170. * 更新余额和业绩
  171. * @return mixed
  172. */
  173. public function up($child, $mid, $order_id, $role, $type, $cash, $sell, $level_id = false, $desc = '', $group_num = 0)
  174. {
  175. $member = Dever::db('agent/member')->find(array('id' => $mid, 'clear' => true));
  176. $data['where_id'] = $mid;
  177. if ($cash) {
  178. Dever::load('bill/lib/cash')->up($mid, $type, $cash, $role, $order_id, $desc, 2);
  179. $data['cash'] = $cash;
  180. } else {
  181. $data['cash'] = 0;
  182. }
  183. Dever::load('bill/lib/sell')->up($child, $mid, $type, $sell, $role, $order_id, $desc);
  184. $data['upcol'] = $sell;
  185. if ($level_id) {
  186. $data['level_id'] = $level_id;
  187. }
  188. //$method = 'upGroupSell';
  189. if ($type == 1) {
  190. $method = 'upSell';
  191. } else {
  192. $method = 'upGroupSell';
  193. }
  194. $data['clear'] = true;
  195. Dever::db('agent/member')->$method($data);
  196. if ($level_id && $level_id != $member['level_id']) {
  197. Dever::load('agent/lib/level_log')->up($mid, $order_id, $member['level_id'], $level_id, $sell, $member['group_sell'] + $sell, $group_num);
  198. }
  199. }
  200. /**
  201. * 查看详情
  202. * @return mixed
  203. */
  204. public function show()
  205. {
  206. $mid = Dever::input('mid');
  207. $member = Dever::db('agent/member')->one($mid);
  208. $admin = Dever::load('manage/auth.info');
  209. $admin_auth = false;
  210. if ($admin && $admin['role'] == 24){
  211. $admin_auth = $admin['role'];
  212. }
  213. $config_type = Dever::db('agent/member')->config['config_type'];
  214. $config_status = Dever::db('agent/member')->config['config_status'];
  215. $result['代理商信息'] = $this->getShowInfo($member,$admin_auth);
  216. if ($member['parent_mid'] && $member['parent_mid'] > 0) {
  217. $parent = Dever::db('agent/member')->one($member['parent_mid']);
  218. if ($parent) {
  219. $result['推荐人信息'] = $this->getShowInfo($parent,$admin_auth);
  220. }
  221. }
  222. $idcard_pic = '<a href="'.$member['idcard_front'].'" target="_blank"><img src="'.$member['idcard_front'].'" width="100" /></a>';
  223. if ($member['idcard_back']) {
  224. $idcard_pic .= '&nbsp;&nbsp;<a href="'.$member['idcard_back'].'" target="_blank"><img src="'.$member['idcard_back'].'" width="100" /></a>';
  225. }
  226. $member_name = $member['name'];
  227. $member_number = $member['idcard'];
  228. $result['认证信息'] = array
  229. (
  230. 'type' => 'user',
  231. 'content' => array
  232. (
  233. array('类型', $config_type[$member['type']]),
  234. array('姓名', $member_name),
  235. array('身份证号', $member_number),
  236. ),
  237. );
  238. if ($member['type'] == 2) {
  239. $company_pic = '<a href="'.$member['company_pic'].'" target="_blank"><img src="'.$member['company_pic'].'" width="100" /></a>';
  240. $member_name = $member['company_name'];
  241. $member_number = $member['company_number'];
  242. $result['认证信息']['content'][] = array('企业名称', $member_name);
  243. $result['认证信息']['content'][] = array('营业执照', $member_number);
  244. $result['认证信息']['content'][] = array('营业执照照片', $company_pic);
  245. }
  246. $result['认证信息']['content'][] = array('身份证照片', $idcard_pic);
  247. $button = array();
  248. if (Dever::load('manage/auth')->checkFunc('agent.member', 'edit', '修改基础资料')) {
  249. $button[0]['btn'][] = array
  250. (
  251. 'type' => 'edit',
  252. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=name,email,area,role,level_id,is_shop,is_area', 'manage'),
  253. 'name' => '修改基础资料',
  254. );
  255. }
  256. if (Dever::load('manage/auth')->checkFunc('agent.member', 'editTitle', '修改头衔')) {
  257. $button[0]['btn'][] = array
  258. (
  259. 'type' => 'edit',
  260. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=title_id,state', 'manage'),
  261. 'name' => '修改头衔',
  262. );
  263. }
  264. if (Dever::load('manage/auth')->checkFunc('agent.member', 'editPassport', '修改密码')) {
  265. $button[0]['btn'][] = array
  266. (
  267. 'type' => 'edit',
  268. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=password', 'manage'),
  269. 'name' => '修改密码',
  270. );
  271. }
  272. if (Dever::load('manage/auth')->checkFunc('agent.member','sport','修改认证资料')) {
  273. $button[0]['btn'][] = array
  274. (
  275. 'type' => 'edit',
  276. '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'),
  277. 'name' => '修改认证资料',
  278. );
  279. }
  280. if (Dever::load('manage/auth')->checkFunc('agent.member', 'editShop', '修改门店')) {
  281. $button[0]['btn'][] = array
  282. (
  283. 'type' => 'edit',
  284. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=shop_id', 'manage'),
  285. 'name' => '修改门店',
  286. );
  287. }
  288. if (Dever::load('manage/auth')->checkFunc('agent.member', 'editMobile', '修改手机号')) {
  289. $button[0]['btn'][] = array
  290. (
  291. 'type' => 'edit',
  292. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=mobile', 'manage'),
  293. 'name' => '修改手机号',
  294. );
  295. }
  296. /*
  297. $button[] = array
  298. (
  299. 'type' => 'edit',
  300. 'link' => Dever::url('project/database/update?project=agent&table=member&where_id='.$member['id'].'&status=1&col=shop_id', 'manage'),
  301. 'name' => '修改归属门店',
  302. );
  303. */
  304. $url = '';
  305. if ($member['status'] == 5) {
  306. $button[0]['btn'][] = array
  307. (
  308. 'type' => 'action',
  309. 'link' => Dever::url('lib/member.setStatus?id=' . $member['id'] . '&value=2', 'agent'),
  310. 'name' => '恢复账号',
  311. 'auth' => array('agent.member', 'bun', '禁用账号'),
  312. );
  313. } elseif ($member['status'] == 2) {
  314. $button[0]['btn'][] = array
  315. (
  316. 'type' => 'action',
  317. 'link' => Dever::url('lib/member.setStatus?id=' . $member['id'] . '&value=5', 'agent'),
  318. 'name' => '禁用账号',
  319. 'auth' => array('agent.member', 'bun', '禁用账号'),
  320. );
  321. }
  322. $button[0]['btn'][] = array
  323. (
  324. 'type' => 'link',
  325. 'link' => Dever::url('project/database/list?project=agent&table=order&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  326. 'name' => '代理订单',
  327. 'auth' => array('agent.member', 'dailidingdan', '代理订单'),
  328. );
  329. $button[0]['btn'][] = array
  330. (
  331. 'type' => 'link',
  332. 'link' => Dever::url('project/database/list?project=agent&table=order&search_api_parent_mid='.$member['mobile'].'&[refer]', 'manage'),
  333. 'name' => '直推代理订单',
  334. 'auth' => array('agent.member', 'ztdailidingdan', '直推代理订单'),
  335. );
  336. $button[0]['btn'][] = array
  337. (
  338. 'type' => 'link',
  339. 'link' => Dever::url('project/database/list?project=agent&table=member_level_log&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  340. 'name' => '升级日志',
  341. 'auth' => array('agent.member', 'sjlog', '升级日志'),
  342. );
  343. $button[1]['btn'][] = array
  344. (
  345. 'type' => 'edit',
  346. 'link' => Dever::url('project/database/update?project=bill&table=push_cash&search_option_mid='.$member['id'], 'manage'),
  347. 'name' => '发放资金',
  348. 'auth' => array('agent.member', 'edit1'),
  349. );
  350. $button[1]['btn'][] = array
  351. (
  352. 'type' => 'edit',
  353. 'link' => Dever::url('project/database/update?project=bill&table=push_sell&search_option_mid='.$member['id'], 'manage'),
  354. 'name' => '发放业绩',
  355. 'auth' => array('agent.member', 'edit2'),
  356. );
  357. $button[1]['btn'][] = array
  358. (
  359. 'type' => 'link',
  360. 'link' => Dever::url('project/database/list?project=bill&table=cash&search_api_mid='.$member['mobile'].'&search_option_state=1&[refer]', 'manage'),
  361. 'name' => '资金账户',
  362. 'auth' => array('agent.member', 'zjaccount', '资金账户'),
  363. );
  364. $button[1]['btn'][] = array
  365. (
  366. 'type' => 'link',
  367. 'link' => Dever::url('project/database/list?project=bill&table=sell&search_api_mid='.$member['mobile'].'&search_option_state=1&[refer]', 'manage'),
  368. 'name' => '业绩流水',
  369. 'auth' => array('agent.member', 'yjls', '业绩流水'),
  370. );
  371. $button[1]['btn'][] = array
  372. (
  373. 'type' => 'link',
  374. 'link' => Dever::url('project/database/list?project=agent&table=member_goods&search_option_state=1&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  375. 'name' => '代理商权益',
  376. 'auth' => array('agent.member', 'dailisqy', '代理商权益'),
  377. );
  378. $button[1]['btn'][] = array
  379. (
  380. 'type' => 'link',
  381. 'link' => Dever::url('project/database/list?project=agent&table=dh_order&search_option_state=1&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  382. 'name' => '权益订单',
  383. 'auth' => array('agent.member', 'qydingdan', '权益订单'),
  384. );
  385. $order = Dever::db('agent/order')->find(array('mid' => $member['id'], 'order_type' => 1));
  386. if ($order) {
  387. $agreement = Dever::db('agent/member_agreement')->getData(array('order_id' => $order['id']));
  388. if (!$agreement) {
  389. $button[2]['btn'][] = array
  390. (
  391. 'type' => 'action',
  392. 'link' => Dever::url('lib/manage.createAgreement?json=1&order_id='.$order['id'], 'agent'),
  393. 'name' => '生成代理合同',
  394. 'auth' => array('agent.member', 'createAgreement1'),
  395. );
  396. }
  397. }
  398. $button[2]['btn'][] = array
  399. (
  400. 'type' => 'link',
  401. 'link' => Dever::url('project/database/list?project=agent&table=member_agreement&search_option_state=1&search_api_mid='.$member['mobile'].'&[refer]', 'manage'),
  402. 'name' => '代理商合同',
  403. 'auth' => array('agent.member', 'dailisht', '代理商合同'),
  404. );
  405. $button[2]['btn'][] = array
  406. (
  407. 'type' => 'link',
  408. 'link' => Dever::url('project/database/list?project=agent&table=member&search_option_state=1&search_api_parent_mid='.$member['mobile'].'&[refer]', 'manage'),
  409. 'name' => '查看直推团队',
  410. 'auth' => array('agent.member', 'ckztgroup', '查看直推团队'),
  411. );
  412. /*
  413. $button[2]['btn'][] = array
  414. (
  415. 'type' => 'edit',
  416. 'link' => Dever::url('lib/member.setStatus?id=' . $member['id'] . '&value=5', 'agent'),
  417. 'name' => '查看邀请关系',
  418. );
  419. */
  420. $furl = '';
  421. $button[2]['btn'][] = array
  422. (
  423. 'type' => 'edit',
  424. 'link' => Dever::url('project/database/update?project=agent&table=member_parent&mid='.$member['id'], 'manage'),
  425. 'name' => '设置直推上级',
  426. 'auth' => array('agent.member', 'set'),
  427. 'log' => false,
  428. );
  429. $table = 'template';
  430. $res = Dever::load('sms/api')->getTable($table);
  431. $button[2]['btn'][] = array
  432. (
  433. 'type' => 'edit',
  434. 'link' => Dever::url($res.'&search_option_state=1&search_option_type=daili_reg_yes,daili_reg_no,daili_goods_no,daili_tixian_yes,daili_tixian_no,daili_hetong_no&search_option_name='.$member['name'].'&search_option_mobile='.$member['mobile'], 'manage'),
  435. 'name' => '发送短信',
  436. 'auth' => array('agent.member', 'setmessage'),
  437. 'log' => false,
  438. );
  439. /*
  440. if (Dever::load('manage/auth')->checkFunc('agent.member', 'edit6', '查看关系图谱')) {
  441. $button[2]['btn'][] = array
  442. (
  443. 'type' => 'link',
  444. 'link' => Dever::url('lib/manage.relation?mid='.$member['id'].'&[refer].manage', 'agent'),
  445. 'name' => '查看关系图谱',
  446. );
  447. }
  448. */
  449. $jump = Dever::input('jump');
  450. if (!$jump) {
  451. $head_btn[] = array
  452. (
  453. 'type' => 'link',
  454. 'link' => 'refer',
  455. 'name' => '返回上一页',
  456. );
  457. $head = array
  458. (
  459. 'name' => '基本信息',
  460. 'btn' => $head_btn,
  461. );
  462. } else {
  463. $head = array
  464. (
  465. 'name' => '基本信息',
  466. 'btn' => '',
  467. );
  468. }
  469. $foot = $button;
  470. $html = Dever::show($head, $result, $foot, false, 'dls-user-box');
  471. return $html;
  472. }
  473. public function getShowInfo($member,$admin_auth=false)
  474. {
  475. $role = Dever::db('setting/role')->one($member['role']);
  476. $level = Dever::db('setting/level')->one($member['level_id']);
  477. $area = Dever::load("area/api.string", $member['area'], '-', true, '');
  478. $code = Dever::load("invite/api.code", $member['id']);
  479. $title = Dever::db('setting/title')->getDataByIds(array('id' => $member['title_id']));
  480. $title_name = array();
  481. if ($title) {
  482. foreach ($title as $k => $v) {
  483. $title_name[] = $v['name'];
  484. }
  485. }
  486. $title_name = implode('、', $title_name);
  487. if ($member['shop_id']) {
  488. $shop = Dever::db('shop/info')->one($member['shop_id']);
  489. } else {
  490. $shop['id'] = -1;
  491. $shop['name'] = '无';
  492. }
  493. $result = array();
  494. if ($level) {
  495. $role['name'] .= '(' . $level['name'] . ')';
  496. }
  497. if (!$member['cash']) {
  498. $member['cash'] = 0;
  499. }
  500. if (!$member['sell']) {
  501. $member['sell'] = 0;
  502. }
  503. if (!$member['group_sell']) {
  504. $member['group_sell'] = 0;
  505. }
  506. if (!$member['avatar']) {
  507. $default = Dever::db('passport/avatar')->one(1);
  508. $member['avatar'] = $default['avatar'];
  509. }
  510. if ($admin_auth) {
  511. $result = array
  512. (
  513. 'type' => 'user',
  514. 'pic' => $member['avatar'],
  515. 'content' => array
  516. (
  517. $member['name'],
  518. array('手机号', $member['mobile']),
  519. array('邀请码', $code),
  520. // array('代理商头衔', $title_name),
  521. array('代理角色', $role['name']),
  522. array('代理区域', $area),
  523. array('所属店铺', $shop['name']),
  524. array('资金余额', '<span style="color:blue">¥' . $member['cash'] . '元</span>'),
  525. // array('直推业绩', '<span style="color:blue">¥' . $member['sell'] . '元</span>'),
  526. // array('团队业绩', '<span style="color:blue">¥' . $member['group_sell'] . '元</span>'),
  527. ),
  528. );
  529. } else {
  530. $result = array
  531. (
  532. 'type' => 'user',
  533. 'pic' => $member['avatar'],
  534. 'content' => array
  535. (
  536. $member['name'],
  537. array('手机号', $member['mobile']),
  538. array('邀请码', $code),
  539. array('代理商头衔', $title_name),
  540. array('代理角色', $role['name']),
  541. array('代理区域', $area),
  542. array('所属店铺', $shop['name']),
  543. array('资金余额', '<span style="color:blue">¥' . $member['cash'] . '元</span>'),
  544. array('直推业绩', '<span style="color:blue">¥' . $member['sell'] . '元</span>'),
  545. array('团队业绩', '<span style="color:blue">¥' . $member['group_sell'] . '元</span>'),
  546. ),
  547. );
  548. }
  549. return $result;
  550. }
  551. public function setStatus_api()
  552. {
  553. $where['where_id'] = Dever::input('id');
  554. $where['status'] = Dever::input('value');
  555. Dever::db('agent/member')->update($where);
  556. return 'reload';
  557. }
  558. public function create($data)
  559. {
  560. $update['mobile'] = $data['mobile'];
  561. $info = Dever::db('agent/member')->find(array('mobile' => $data['mobile']));
  562. $update['name'] = $data['name'];
  563. $update['idcard'] = $data['idcard'];
  564. $update['idcard_front'] = $data['idcard_front'];
  565. $update['idcard_back'] = $data['idcard_back'];
  566. $update['company_name'] = $data['company_name'];
  567. $update['company_pic'] = $data['company_pic'];
  568. $update['company_number'] = $data['company_number'];
  569. $update['parent_mid'] = $data['parent_mid'];
  570. $update['source_id'] = $data['source_id'];
  571. $update['type'] = $data['type'];
  572. if (!$info) {
  573. $update['role'] = 1;
  574. $update['level_id'] = -1;
  575. $mid = Dever::db('agent/member')->insert($update);
  576. /*
  577. if ($mid && $data['parent_mid'] && $data['parent_mid'] > 0) {
  578. Dever::load('invite/api')->setRelation($mid, $data['parent_mid']);
  579. }
  580. */
  581. return $mid;
  582. } else {
  583. $update['where_id'] = $info['id'];
  584. Dever::db('agent/member')->update($update);
  585. return $info['id'];
  586. }
  587. }
  588. #认证时间
  589. public function set_rdate($id){
  590. $info=Dever::db('agent/member')->one(array('id'=>$id,'state'=>1));
  591. if($info['cdate']){
  592. $data['注册时间']=date('Y-m-d H:i',$info['cdate']);
  593. }else{
  594. $data['注册时间']='-';
  595. }
  596. if($info['status']==2){
  597. if($info['rdate']){
  598. $data['认证时间']=date('Y-m-d H:i',$info['rdate']);
  599. }else{
  600. $data['认证时间']='-';
  601. }
  602. }else{
  603. $data['认证时间']='-';
  604. }
  605. if($info['udate']){
  606. $data['终审时间']=date('Y-m-d H:i',$info['udate']);
  607. }else{
  608. $data['终审时间']='-';
  609. }
  610. // $html = Dever::table($data);
  611. return '注册时间:'.$data['注册时间'].'<br/>认证时间:'.$data['认证时间'].'<br/>终审时间:'.$data['终审时间'];
  612. }
  613. #更改收件人信息
  614. public function set_mobile($id){
  615. $info=Dever::db('agent/dh_order')->one(array('id'=>$id,'state'=>1));
  616. $data=array();
  617. if($info && $info['name']=='兑换商品'){
  618. $address=Dever::db('agent/member_address')->one(array('id'=>$info['address_id'],'state'=>1));
  619. if ($address) {
  620. $data['联系人']=$address['contact'];
  621. $data['联系电话']=$address['mobile'];
  622. $res=Dever::load('agent/lib/address')->getOne($address['mid'],$address['id']);
  623. $data['详细地址']=$res['address_info'].$address['house_number'];
  624. // $data['门牌号']=$address['house_number'];
  625. return $data['联系人'].'<br/>'.$data['联系电话'].'<br/>'.$data['详细地址'];
  626. } else {
  627. return '';
  628. }
  629. }else{
  630. return '';
  631. }
  632. // $html=Dever::table($data);
  633. // return $html;
  634. }
  635. public function daili($id){
  636. $info=Dever::db('agent/member')->one(array('id'=>$id,'state'=>1));
  637. $member['role'] = Dever::db('setting/role')->find($info['role']);
  638. $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>';
  639. $mobile = $info['mobile'];
  640. $role = $member['role']['name'];
  641. if (isset($info['level_id']) && $info['level_id'] && $info['level_id'] > 0) {
  642. $info['level'] = Dever::db('setting/level')->find($info['level_id']);
  643. $role .= '('.$info['level']['name'].')';
  644. }
  645. $html = $name.'<br/>'.$mobile.'<br/>'.$role;
  646. return $html;
  647. }
  648. #上级信息
  649. public function sdaili($id){
  650. $res=Dever::db('agent/member')->one(array('id'=>$id,'state'=>1));
  651. if($res['parent_mid']>0){
  652. $info=Dever::db('agent/member')->one(array('id'=>$res['parent_mid'],'state'=>1));
  653. $member['role'] = Dever::db('setting/role')->find($info['role']);
  654. $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>';
  655. $data['电话']=$info['mobile'];
  656. $data['角色']=$member['role']['name'];
  657. if (isset($info['level_id']) && $info['level_id'] && $info['level_id'] > 0) {
  658. $info['level'] = Dever::db('setting/level')->find($info['level_id']);
  659. $data['角色'] .= '('.$info['level']['name'].')';
  660. }
  661. $data['团队业绩']=$info['group_sell'];
  662. $html = $data['姓名'].'<br/>'.$data['电话'].'<br/>'.$data['角色'].'<br/>'.$data['团队业绩'];
  663. return $html;
  664. }elseif($res['source_id'] && $res['source_id'] >=1){
  665. $source=Dever::db('setting/source')->one(array('id'=>$res['source_id'],'state'=>1));
  666. $data['来源']=$source['name'];
  667. return $html =$data['来源'];
  668. }else{
  669. return '无';
  670. }
  671. }
  672. public function search_api()
  673. {
  674. $value = Dever::input('value');
  675. if ($value) {
  676. $parent_mid = Dever::load('invite/api')->getUid($value);
  677. $table = array();
  678. if ($parent_mid) {
  679. $member = Dever::db('agent/member')->find($parent_mid);
  680. if (!$member) {
  681. return '暂无账号';
  682. }
  683. $table = array();
  684. $table['head'] = array('姓名', '手机号');
  685. $table['body'] = array();
  686. $table['body'][] = array($member['name'], $member['mobile']);
  687. $result[] = array
  688. (
  689. 'type' => 'table',
  690. 'content' => $table,
  691. );
  692. $html = Dever::show('', $result, false, false);
  693. return $html;
  694. }
  695. return '暂无账号';
  696. } else {
  697. return '';
  698. }
  699. }
  700. #新增业绩(去掉直推最大一组市场,其他小组市场新增业绩之和)
  701. public function new_money($id){
  702. $start = Dever::input('search_option_start_dever_time');
  703. $end = Dever::input('search_option_end_dever_time');
  704. $where = array();
  705. $where['parent_mid'] = $id;
  706. // $info = Dever::db('bill/sell')->getNewChildParent($where);
  707. $member = Dever::db('agent/member')->getNewMember($where);
  708. $temp = array();
  709. $sell = 0;
  710. $total = 0;
  711. if($member){
  712. unset($member[0]);
  713. }
  714. $where = array();
  715. if($start){
  716. $where['start'] = $start;
  717. }
  718. if($end){
  719. $where['end'] = $end;
  720. }
  721. $where['state'] = 1;
  722. $where['type'] = 2;
  723. $where['stype'] = 1;
  724. $array = array_column($member, 'id');
  725. foreach($array as $k=>$v){
  726. $where['mid'] = $v;
  727. $info[] = Dever::db('bill/sell')->getNewChildParent($where);
  728. }
  729. if(isset($info) && $info){
  730. foreach($info as $k => $v){
  731. $total += $v['total'];
  732. }
  733. }
  734. $total = sprintf ('%01.2f',$total);
  735. return $total;
  736. }
  737. #新增正常业绩
  738. public function new_zmoney($id){
  739. $start = Dever::input('search_option_start_dever_time');
  740. $end = Dever::input('search_option_end_dever_time');
  741. $where = array();
  742. if($start){
  743. $where['start'] = $start;
  744. }
  745. if($end){
  746. $where['end'] = $end;
  747. }
  748. $where['mid'] = $id;
  749. $where['state'] = 1;
  750. $where['type'] = 2;
  751. $where['stype'] = 1;
  752. $info = Dever::db('bill/sell')->getNewParent($where);
  753. $total = sprintf ('%01.2f',$info['total']);
  754. return $total;
  755. }
  756. #头衔统计数据导出
  757. public function out_member($data){
  758. $header = array('姓名', '手机号', '代理角色', '代理头衔', '直推业绩', '团队业绩', '新增业绩', '新增正常业绩');
  759. $body = array();
  760. foreach($data as $k => $v){
  761. $role = Dever::db('setting/role')->find($v['role']);
  762. $title = Dever::db('setting/title')->find($v['title_id']);
  763. $new_sell = $this->new_money($v['id']);
  764. $new_zsell = $this->new_zmoney($v['id']);
  765. $d = array
  766. (
  767. $v['name'],
  768. $v['mobile'],
  769. $role['name'],
  770. $title['name'],
  771. $v['sell'],
  772. $v['group_sell'],
  773. $new_sell,
  774. $new_zsell,
  775. );
  776. $body[] = $d;
  777. }
  778. $file = Dever::input('excel_name');
  779. return Dever::excelExport($body, $header, $file);
  780. }
  781. }