User.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996
  1. <?php
  2. namespace app\admin\controller;
  3. use app\common\model\UserWill;
  4. use think\facade\Session;
  5. use app\admin\BaseController;
  6. use app\common\model\User as UserModel;
  7. use app\common\model\UserAuths as UserAuthsModel;
  8. use app\common\model\UserFollow as UserFollowModel;
  9. use app\common\model\UserGroups as UserGroupsModel;
  10. use app\common\model\UserPart as UserPartModel;
  11. use app\common\model\UserIntegral as UserIntegralModel;
  12. use app\common\model\UserRank as UserRankModel;
  13. use app\common\model\UserParam as UserParamModel;
  14. use app\common\model\Agent as AgentModel;
  15. use app\common\model\Broker as BrokerModel;
  16. use app\common\validate\User as UserValidate;
  17. use think\exception\ValidateException;
  18. use think\facade\Db;
  19. use PHPExcel_IOFactory;
  20. use PHPExcel;
  21. class User extends BaseController
  22. {
  23. // 用户跟进记录
  24. public function follow()
  25. {
  26. $userid = input('userid/d');
  27. $user = UserModel::findOrEmpty($userid);
  28. $followlist = UserFollowModel::where('userid', $userid)->order('id', 'desc')->limit(100)->select();
  29. return view('user/follow', [
  30. 'user' => $user,
  31. 'followlist' => $followlist
  32. ]);
  33. }
  34. public function editFollow()
  35. {
  36. $userid = input('userid/d', 0);
  37. $user = UserModel::findOrEmpty($userid);
  38. if ($user->isEmpty()) {
  39. exit(json_encode(array(
  40. 'code' => 1,
  41. 'msg' => "用户信息不存在。"
  42. )));
  43. }
  44. UserFollowModel::create([
  45. 'userid' => $userid,
  46. 'ftype' => input('ftype/s', ""),
  47. 'remark' => input('remark/s', ""),
  48. 'createtime' => time()
  49. ]);
  50. $followstatus = input('followstatus/d', 1);
  51. $user->save([
  52. 'followstatus' => $followstatus
  53. ]);
  54. exit(json_encode(array(
  55. 'code' => 0
  56. )));
  57. }
  58. // 邀请排行榜
  59. public function rankList()
  60. {
  61. return view('user/ranklist');
  62. }
  63. public function rankForm()
  64. {
  65. $id = input('id/d');
  66. $rank = UserRankModel::findOrEmpty($id);
  67. return view('user/rankform', [
  68. 'rank' => $rank
  69. ]);
  70. }
  71. public function editRank()
  72. {
  73. $id = input('id/d');
  74. $rank = UserRankModel::findOrEmpty($id);
  75. $rank->save([
  76. 'realname' => input('realname/s'),
  77. 'mobile' => input('mobile/s'),
  78. 'partnumber' => input('partnumber/d', 0),
  79. ]);
  80. exit(json_encode(array(
  81. 'code' => 0
  82. )));
  83. }
  84. public function fieldRank()
  85. {
  86. $id = input('id/d', 0);
  87. $rank = UserRankModel::findOrEmpty($id);
  88. if ($rank->isEmpty()) {
  89. exit(json_encode(array(
  90. 'code' => 1,
  91. 'msg' => "信息不存在"
  92. )));
  93. } else {
  94. $rank->save([
  95. input('field/s') => input('value')
  96. ]);
  97. }
  98. exit(json_encode(array(
  99. 'code' => 0
  100. )));
  101. }
  102. public function listRank()
  103. {
  104. $limit = input('limit');
  105. $page = input('page');
  106. $map = array();
  107. $list = UserRankModel::where($map)->order('partnumber', 'desc')->limit($limit)->page($page)->select();
  108. $count = UserRankModel::where($map)->count();
  109. if ($count==0) {
  110. exit(json_encode(array(
  111. 'code' => 1,
  112. 'msg' => "未查询到数据"
  113. )));
  114. }
  115. exit(json_encode(array(
  116. 'code' => 0,
  117. 'msg' => "",
  118. 'count' => $count,
  119. 'data' => $list
  120. )));
  121. }
  122. public function delRank()
  123. {
  124. $idarr = input('idarr/a');
  125. UserRankModel::whereIn('id', $idarr)->delete();
  126. exit(json_encode(array(
  127. 'code' => 0,
  128. 'msg' => ""
  129. )));
  130. }
  131. // 邀请记录
  132. public function partList()
  133. {
  134. return view('user/partlist');
  135. }
  136. public function listPart()
  137. {
  138. $limit = input('limit');
  139. $page = input('page');
  140. $map = array();
  141. $keywords = input('keywords/s', "");
  142. $status = input('status/d', 0);
  143. if (!empty($status)) {
  144. $map[] = ['UserPart.status', '=', $status];
  145. }
  146. $list = UserPartModel::hasWhere('puser', [['realname|mobile', 'like', '%'.$keywords.'%', 'or']])->with(['puser','user'])->where($map)->order('id', 'desc')->limit($limit)->page($page)->append(['status_text'])->select();
  147. $count = UserPartModel::hasWhere('puser', [['realname|mobile', 'like', '%'.$keywords.'%', 'or']])->where($map)->count();
  148. if ($count==0) {
  149. exit(json_encode(array(
  150. 'code' => 1,
  151. 'msg' => "未查询到数据"
  152. )));
  153. }
  154. exit(json_encode(array(
  155. 'code' => 0,
  156. 'msg' => "",
  157. 'count' => $count,
  158. 'data' => $list
  159. )));
  160. }
  161. public function exportPart()
  162. {
  163. $map = array();
  164. $keywords = input('keywords/s', "");
  165. $status = input('status/d', 0);
  166. if (!empty($status)) {
  167. $map[] = ['UserPart.status', '=', $status];
  168. }
  169. $xlsData = UserPartModel::hasWhere('puser', [['realname|mobile', 'like', '%'.$keywords.'%', 'or']])->with(['puser','user'])->where($map)->order('id', 'desc')->select()->toArray();
  170. $xlsCell = array(
  171. array('id','表ID'),
  172. array('puser.nickname','邀请人昵称'),
  173. array('puser.realname','邀请人姓名'),
  174. array('puser.mobile','邀请人手机号'),
  175. array('puser.bankcard.openbank','邀请人开户行'),
  176. array('puser.bankcard.account','邀请人帐户名'),
  177. array('puser.bankcard.number','邀请人账户号'),
  178. array('user.nickname','被邀请人昵称'),
  179. array('user.realname','被邀请人姓名'),
  180. array('user.mobile','被邀请人手机号'),
  181. array('status','状态',array(1=>'未入职',2=>'已入职',3=>'已发放')),
  182. array('redmoney','奖金金额'),
  183. array('createtime','推荐时间'),
  184. );
  185. export_excel("系统用户", $xlsCell, $xlsData);
  186. }
  187. public function fieldPart()
  188. {
  189. $id = input('id/d', 0);
  190. $part = UserPartModel::findOrEmpty($id);
  191. if ($part->isEmpty()) {
  192. exit(json_encode(array(
  193. 'code' => 1,
  194. 'msg' => "信息不存在"
  195. )));
  196. } else {
  197. $part->save([
  198. input('field/s') => input('value')
  199. ]);
  200. }
  201. exit(json_encode(array(
  202. 'code' => 0
  203. )));
  204. }
  205. public function partForm()
  206. {
  207. $id = input('id/d');
  208. $part = UserPartModel::with(['puser','user'])->findOrEmpty($id);
  209. return view('user/partform', [
  210. 'part' => $part
  211. ]);
  212. }
  213. public function editPart()
  214. {
  215. $id = input('id/d');
  216. $part = UserPartModel::findOrEmpty($id);
  217. $part->save([
  218. 'status' => input('status/d', 1),
  219. 'redmoney' => input('redmoney/d', 0),
  220. ]);
  221. exit(json_encode(array(
  222. 'code' => 0
  223. )));
  224. }
  225. public function delPart()
  226. {
  227. $idarr = input('idarr/a');
  228. UserPartModel::whereIn('id', $idarr)->delete();
  229. exit(json_encode(array(
  230. 'code' => 0,
  231. 'msg' => ""
  232. )));
  233. }
  234. // 用户聘豆
  235. public function integralList()
  236. {
  237. return view('user/integrallist');
  238. }
  239. public function listIntegral()
  240. {
  241. $limit = input('limit');
  242. $page = input('page');
  243. $map = array();
  244. $keywords = input('keywords/s', "");
  245. $itype = input('itype/d', 0);
  246. if (!empty($itype)) {
  247. $map[] = ['itype', '=', $itype];
  248. }
  249. $status = input('status/d', 0);
  250. if (!empty($status)) {
  251. $map[] = ['status', '=', $status];
  252. }
  253. $list = UserIntegralModel::hasWhere('user', [['realname|mobile', 'like', '%'.$keywords.'%', 'or']])->with(['user'])->where($map)->order('id', 'desc')->limit($limit)->page($page)->select()->append(['itype_text','status_text']);
  254. $count = UserIntegralModel::hasWhere('user', [['realname|mobile', 'like', '%'.$keywords.'%', 'or']])->where($map)->count();
  255. if ($count==0) {
  256. exit(json_encode(array(
  257. 'code' => 1,
  258. 'msg' => "未查询到数据"
  259. )));
  260. }
  261. exit(json_encode(array(
  262. 'code' => 0,
  263. 'msg' => "",
  264. 'count' => $count,
  265. 'data' => $list
  266. )));
  267. }
  268. public function exportIntegral()
  269. {
  270. $map = array();
  271. $keywords = input('keywords/s', "");
  272. $itype = input('itype/d', 0);
  273. if (!empty($itype)) {
  274. $map[] = ['itype', '=', $itype];
  275. }
  276. $xlsData = UserIntegralModel::hasWhere('user', [['realname|mobile', 'like', '%'.$keywords.'%', 'or']])->with(['user'])->where($map)->order('id', 'desc')->select()->append(['itype_text','status_text'])->toArray();
  277. $xlsCell = array(
  278. array('id','表ID'),
  279. array('user.nickname','昵称'),
  280. array('user.realname','姓名'),
  281. array('user.mobile','手机号'),
  282. array('user.bankcard.openbank','开户行'),
  283. array('user.bankcard.account','帐户名'),
  284. array('user.bankcard.number','账户号'),
  285. array('title','聘豆标题'),
  286. array('itype_text','类型'),
  287. array('status_text','状态'),
  288. array('intvalue','聘豆变更值'),
  289. array('intmoney','聘豆金额'),
  290. array('remark','备注'),
  291. array('createtime','注册时间'),
  292. );
  293. export_excel("用户聘豆", $xlsCell, $xlsData);
  294. }
  295. public function fieldIntegral()
  296. {
  297. $id = input('id/d', 0);
  298. $integral = UserIntegralModel::findOrEmpty($id);
  299. if ($integral->isEmpty()) {
  300. exit(json_encode(array(
  301. 'code' => 1,
  302. 'msg' => "信息不存在"
  303. )));
  304. } else {
  305. $integral->save([
  306. input('field/s') => input('value')
  307. ]);
  308. }
  309. exit(json_encode(array(
  310. 'code' => 0
  311. )));
  312. }
  313. public function integralUpdate()
  314. {
  315. $id = input('id/d', 0);
  316. $integral = UserIntegralModel::with('user')->findOrEmpty($id);
  317. return view('user/integralupdate', [
  318. 'integral' => $integral
  319. ]);
  320. }
  321. public function updateIntegral()
  322. {
  323. $id = input('id/d', 0);
  324. $integral = UserIntegralModel::findOrEmpty($id);
  325. if ($integral->isEmpty()) {
  326. exit(json_encode(array(
  327. 'code' => 1,
  328. 'msg' => "用户聘豆记录不存在"
  329. )));
  330. }
  331. $createtime = input('createtime/s', date("Y-m-d H:i:s"));
  332. $integral->save([
  333. 'title' => input('title/s', ""),
  334. 'intvalue' => input('intvalue/d', 0),
  335. 'intmoney' => input('intmoney/f', 0.00),
  336. 'remark' => input('remark/s', ""),
  337. 'itype' => input('itype/d', 1),
  338. 'status' => input('status/d', 1),
  339. 'createtime' => $createtime,
  340. 'yeartime' => date("Y", strtotime($createtime)),
  341. 'monthtime' => date("Ym", strtotime($createtime))
  342. ]);
  343. exit(json_encode(array(
  344. 'code' => 0
  345. )));
  346. }
  347. public function statusIntegral()
  348. {
  349. $id = input('id/d');
  350. $integral = UserIntegralModel::where(['itype'=>3])->find($id);
  351. if ($integral==null) {
  352. exit(json_encode(array(
  353. 'code' => 1,
  354. 'msg' => "该记录非兑现类型"
  355. )));
  356. } elseif ($integral->status==1) {
  357. $integral->save([
  358. 'status' => 2
  359. ]);
  360. } elseif ($integral->status==2) {
  361. $integral->save([
  362. 'status' => 1
  363. ]);
  364. } else {
  365. exit(json_encode(array(
  366. 'code' => 1,
  367. 'msg' => "该记录非兑现类型。"
  368. )));
  369. }
  370. exit(json_encode(array(
  371. 'code' => 0
  372. )));
  373. }
  374. public function statusIntegralAll()
  375. {
  376. $idarr = input('idarr/a');
  377. UserIntegralModel::update(['status' => 2], ['status'=>1,'itype'=>3,'id'=>$idarr]);
  378. exit(json_encode(array(
  379. 'code' => 0,
  380. 'msg' => ""
  381. )));
  382. }
  383. public function delIntegral()
  384. {
  385. $idarr = input('idarr/a');
  386. UserIntegralModel::whereIn('id', $idarr)->delete();
  387. exit(json_encode(array(
  388. 'code' => 0,
  389. 'msg' => ""
  390. )));
  391. }
  392. public function integralForm()
  393. {
  394. $userid = input('userid/d');
  395. $user = UserModel::findOrEmpty($userid);
  396. return view('user/integralform', [
  397. 'user' => $user
  398. ]);
  399. }
  400. public function editIntegral()
  401. {
  402. $userid = input('userid/d');
  403. $user = UserModel::findOrEmpty($userid);
  404. $intvalue = input('intvalue/d', 0);
  405. if ($intvalue==0) {
  406. exit(json_encode(array(
  407. 'code' => 1,
  408. 'msg' => "聘豆变更值不能为0"
  409. )));
  410. }
  411. $data = array(
  412. 'userid' => $userid,
  413. 'title' => input('title/s'),
  414. 'intvalue' => $intvalue,
  415. 'intmoney' => input('intmoney/s', 0.00),
  416. 'onlycontent' => "",
  417. 'remark' => input('remark/s'),
  418. 'itype' => input('itype/d'),
  419. 'status' => 2,
  420. 'createtime' => input('createtime/s'),
  421. 'yeartime' => date("Y"),
  422. 'monthtime' => date("Ym")
  423. );
  424. UserIntegralModel::create($data);
  425. $udata = array();
  426. $udata['integral'] = intval($user->integral) + $intvalue;
  427. $isinttotal = input('isinttotal/d', 0);
  428. if ($isinttotal==1) {
  429. $udata['inttotal'] = intval($user->inttotal) + $intvalue;
  430. }
  431. $user->save($udata);
  432. exit(json_encode(array(
  433. 'code' => 0
  434. )));
  435. }
  436. // 用户授权
  437. public function authsList()
  438. {
  439. $userid = input('userid/d');
  440. return view('user/authslist', [
  441. 'userid' => $userid
  442. ]);
  443. }
  444. public function listAuths()
  445. {
  446. $userid = input('userid/d');
  447. $list = UserAuthsModel::where('userid', $userid)->order('id', 'asc')->append(['identitytype_text'])->select();
  448. $count = UserAuthsModel::where('userid', $userid)->count();
  449. if ($count==0) {
  450. exit(json_encode(array(
  451. 'code' => 1,
  452. 'msg' => "未查询到数据"
  453. )));
  454. }
  455. exit(json_encode(array(
  456. 'code' => 0,
  457. 'msg' => "",
  458. 'count' => $count,
  459. 'data' => $list
  460. )));
  461. }
  462. public function delAuths()
  463. {
  464. $id = input('id/d');
  465. $auths = UserAuthsModel::find($id);
  466. if ($auths->identitytype == 'mobile') {
  467. exit(json_encode(array(
  468. 'code' => 1,
  469. 'msg' => "手机号授权方式不允许删除"
  470. )));
  471. }
  472. $result = $auths->delete();
  473. if ($result) {
  474. exit(json_encode(array(
  475. 'code' => 0
  476. )));
  477. }
  478. exit(json_encode(array(
  479. 'code' => 1,
  480. 'msg' => "删除失败,请稍后重试"
  481. )));
  482. }
  483. // 用户
  484. public function userPublic()
  485. {
  486. $groupslist = UserGroupsModel::order(['isdefault'=>'desc','id'=>'asc'])->select();
  487. $agentlist = AgentModel::with('broker')->order(['id'=>'desc'])->select();
  488. return view('user/userpublic', [
  489. 'groupslist' => $groupslist,
  490. 'agentlist' => $agentlist
  491. ]);
  492. }
  493. public function userList()
  494. {
  495. $groupslist = UserGroupsModel::order(['isdefault'=>'desc','id'=>'asc'])->select();
  496. $agentlist = AgentModel::with('broker')->order(['id'=>'desc'])->select();
  497. return view('user/userlist', [
  498. 'groupslist' => $groupslist,
  499. 'agentlist' => $agentlist
  500. ]);
  501. }
  502. public function userForm()
  503. {
  504. $id = input('id/d', 0);
  505. $user = UserModel::with(['broker'])->findOrEmpty($id);
  506. $agentlist = AgentModel::with('broker')->order(['id'=>'asc'])->select();
  507. $groupslist = UserGroupsModel::order(['isdefault'=>'desc','id'=>'asc'])->select();
  508. $willlist = UserWill::select();
  509. return view('user/userform', [
  510. 'groupslist' => $groupslist,
  511. 'willlist' => $willlist,
  512. 'agentlist' => $agentlist,
  513. 'user' => $user
  514. ]);
  515. }
  516. public function fieldUser()
  517. {
  518. $id = input('id/d', 0);
  519. $user = UserModel::findOrEmpty($id);
  520. if ($user->isEmpty()) {
  521. exit(json_encode(array(
  522. 'code' => 1,
  523. 'msg' => "信息不存在"
  524. )));
  525. } else {
  526. $user->save([
  527. input('field/s') => input('value')
  528. ]);
  529. }
  530. exit(json_encode(array(
  531. 'code' => 0
  532. )));
  533. }
  534. public function listUser()
  535. {
  536. $limit = input('limit');
  537. $page = input('page');
  538. $map = array();
  539. $keywords = input('keywords/s');
  540. if (!empty($keywords)) {
  541. $map[] =['nickname|realname|mobile', 'like', '%'.$keywords.'%', 'or'];
  542. }
  543. $groupsid = input('groupsid/d');
  544. if (!empty($groupsid)) {
  545. $map[] = ['groupsid', '=', $groupsid];
  546. }
  547. $ispublic = input('ispublic/d', 0);
  548. if ($ispublic==0) {
  549. $agentbrokerarr = explode(",", input('agentbroker/s'));
  550. $agentid = isset($agentbrokerarr[0]) ? $agentbrokerarr[0] : 0;
  551. if (!empty($agentid)) {
  552. $brokeridarr = BrokerModel::where('agentid', '=', $agentid)->column('id');
  553. $map[] = ['brokerid', 'in', $brokeridarr];
  554. $map[] = ['brokerid', '<>', 0];
  555. }
  556. $brokerid = isset($agentbrokerarr[1]) ? $agentbrokerarr[1] : 0;
  557. if (!empty($brokerid)) {
  558. $map[] = ['brokerid', '=', $brokerid];
  559. }
  560. }else{
  561. $map[] = ['brokerid', '=', 0];
  562. }
  563. $status = input('status/d');
  564. if (!empty($status)) {
  565. $map[] = ['status', '=', $status];
  566. }
  567. $authstatus = input('authstatus/d');
  568. if (!empty($authstatus)) {
  569. $map[] = ['authstatus', '=', $authstatus];
  570. }
  571. $followstatus = input('followstatus/d');
  572. if (!empty($followstatus)) {
  573. $map[] = ['followstatus', '=', $followstatus];
  574. }
  575. $list = UserModel::with(['userGroups','broker'=>['agent','worker']])->withCount('userPart')->where($map)->order('id', 'desc')->limit($limit)->page($page)->append(['status_text','isvip_text','authstatus_text','followstatus_text','education_text','worker_text','jobintention_text'])->select();
  576. $count = UserModel::where($map)->count();
  577. if ($count==0) {
  578. exit(json_encode(array(
  579. 'code' => 1,
  580. 'msg' => "未查询到数据"
  581. )));
  582. }
  583. exit(json_encode(array(
  584. 'code' => 0,
  585. 'msg' => "",
  586. 'count' => $count,
  587. 'data' => $list
  588. )));
  589. }
  590. public function exportUser()
  591. {
  592. $map = array();
  593. $keywords = input('keywords/s');
  594. if (!empty($keywords)) {
  595. $map[] =['nickname|realname|mobile', 'like', '%'.$keywords.'%', 'or'];
  596. }
  597. $groupsid = input('groupsid/d');
  598. if (!empty($groupsid)) {
  599. $map[] = ['groupsid', '=', $groupsid];
  600. }
  601. $agentbrokerarr = explode(",", input('agentbroker/s'));
  602. $agentid = isset($agentbrokerarr[0]) ? $agentbrokerarr[0] : 0;
  603. if (!empty($agentid)) {
  604. $brokeridarr = BrokerModel::where('agentid', '=', $agentid)->column('id');
  605. $map[] = ['brokerid', 'in', $brokeridarr];
  606. $map[] = ['brokerid', '<>', 0];
  607. }
  608. $brokerid = isset($agentbrokerarr[1]) ? $agentbrokerarr[1] : 0;
  609. if (!empty($brokerid)) {
  610. $map[] = ['brokerid', '=', $brokerid];
  611. }
  612. $status = input('status/d');
  613. if (!empty($status)) {
  614. $map[] = ['status', '=', $status];
  615. }
  616. $authstatus = input('authstatus/d');
  617. if (!empty($authstatus)) {
  618. $map[] = ['authstatus', '=', $authstatus];
  619. }
  620. $followstatus = input('followstatus/d');
  621. if (!empty($followstatus)) {
  622. $map[] = ['followstatus', '=', $followstatus];
  623. }
  624. $xlsData = UserModel::with(['userGroups','broker'=>['agent','worker']])->withCount('userPart')->where($map)->order('id', 'desc')->append(['status_text','isvip_text','authstatus_text','followstatus_text'])->select()->toArray();
  625. $xlsCell = array(
  626. array('id','表ID'),
  627. array('nickname','昵称'),
  628. array('realname','姓名'),
  629. array('mobile','手机号'),
  630. array('integral','可用聘豆'),
  631. array('inttotal','累计聘豆'),
  632. array('status_text','状态'),
  633. array('isvip_text','是否VIP'),
  634. array('authstatus_text','是否实名认证'),
  635. array('idcard','身份证号'),
  636. array('gender','性别',array(1=>'男',2=>'女')),
  637. array('birthday','出生日期'),
  638. array('address','现居住地'),
  639. array('education','学历'),
  640. array('bankcard.openbank','开户行'),
  641. array('bankcard.account','账户名'),
  642. array('bankcard.number','账户号'),
  643. array('followstatus_text','跟进状态'),
  644. array('userGroups.title','用户组'),
  645. array('broker.worker.title','劳务公司'),
  646. array('broker.agent.title','代理门店'),
  647. array('broker.title','职业顾问'),
  648. array('user_part_count','推广人数'),
  649. array('createtime','注册时间'),
  650. );
  651. export_excel("系统用户", $xlsCell, $xlsData);
  652. }
  653. public function setBroker()
  654. {
  655. $idarr = input('idarr/a');
  656. $setagentbroker = explode(",", input('setagentbroker/s'));
  657. $brokerid = isset($setagentbroker[1]) ? $setagentbroker[1] : 0;
  658. if (empty($brokerid)) {
  659. exit(json_encode(array(
  660. 'code' => 1,
  661. 'msg' => "请选择职业顾问。"
  662. )));
  663. }
  664. UserModel::whereIn('id', $idarr)->update(['brokerid' => $brokerid]);
  665. exit(json_encode(array(
  666. 'code' => 0,
  667. 'msg' => ""
  668. )));
  669. }
  670. public function delUser()
  671. {
  672. $idarr = input('idarr/a');
  673. UserAuthsModel::whereIn('userid', $idarr)->delete();
  674. UserModel::whereIn('id', $idarr)->delete();
  675. // $result = Db::name('user')->whereIn('id',$idarr)->update(['deletetime'=>time()]);
  676. exit(json_encode(array(
  677. 'code' => 0,
  678. 'msg' => ""
  679. )));
  680. }
  681. public function editUser()
  682. {
  683. $id = input('id/d');
  684. $mobile = input('mobile/s');
  685. $vdata = array(
  686. 'id' => $id,
  687. 'mobile' => $mobile
  688. );
  689. try {
  690. validate(UserValidate::class)->check($vdata);
  691. } catch (ValidateException $e) {
  692. exit(json_encode(array(
  693. 'code' => 1,
  694. 'msg' => $e->getError()
  695. )));
  696. }
  697. $address = input('address/s', "");
  698. $jobintention = input('jobintention/s', "");
  699. if(!$address){
  700. exit(json_encode(array(
  701. 'code' => 1,
  702. 'msg' => "请填写居住地址。"
  703. )));
  704. }
  705. if(!$jobintention){
  706. exit(json_encode(array(
  707. 'code' => 1,
  708. 'msg' => "请填写意向岗位。"
  709. )));
  710. }
  711. $agentbrokerarr = explode(",", input('agentbroker/s'));
  712. $brokerid = isset($agentbrokerarr[1]) ? $agentbrokerarr[1] : 0;
  713. $data = array(
  714. 'groupsid' => input('groupsid/d', 0),
  715. 'brokerid' => $brokerid,
  716. 'nickname' => input('nickname/s', ""),
  717. 'avatar' => input('avatar/s', ""),
  718. 'realname' => input('realname/s', ""),
  719. 'mobile' => $mobile,
  720. 'inttotal' => input('inttotal/d', 0),
  721. 'status' => input('status/d', 1),
  722. 'isvip' => input('isvip/d', 1),
  723. 'authstatus' => input('authstatus/d', 1),
  724. 'authremark' => input('authremark/s', ""),
  725. 'idcardzpic' => input('idcardzpic/s', ""),
  726. 'idcardfpic' => input('idcardfpic/s', ""),
  727. 'idcard' => input('idcard/s', ""),
  728. 'gender' => input('gender/d', 1),
  729. 'birthday' => input('birthday/s', ""),
  730. 'address' => $address,
  731. 'education' => input('education/s', ""),
  732. 'createtime' => input('createtime/s', ""),
  733. 'jobintention' => $jobintention,
  734. 'workexperience' => input('workexperience/s', ""),
  735. 'eduexperience' => input('eduexperience/s', ""),
  736. 'followstatus' => input('followstatus/d', 1),
  737. 'bankcard' => input('bankcard/a', array()),
  738. );
  739. $password = input('password/s');
  740. if (empty($id)) {
  741. $data['integral'] = 0;
  742. $user = UserModel::create($data);
  743. $auths = UserAuthsModel::create([
  744. 'userid' => $user->id,
  745. 'identitytype' => "mobile",
  746. 'identifier' => $mobile,
  747. 'password' => empty($password) ? md5("123456789") : md5($password),
  748. 'logintime' => time(),
  749. 'loginip' => $_SERVER['SERVER_ADDR'],
  750. 'wxampcode' => ""
  751. ]);
  752. } else {
  753. $data['id'] = $id;
  754. $user = UserModel::update($data);
  755. $adata = ['identifier'=>$mobile];
  756. if (!empty($password)) {
  757. $adata['password'] = md5($password);
  758. }
  759. UserAuthsModel::update($adata, ['userid'=>$id,'identitytype'=>'mobile']);
  760. }
  761. exit(json_encode(array(
  762. 'code' => 0
  763. )));
  764. }
  765. // 用户组
  766. public function groupsList()
  767. {
  768. return view('user/groupslist');
  769. }
  770. public function groupsForm()
  771. {
  772. $id = input('id/d, 0');
  773. $groups = UserGroupsModel::findOrEmpty($id);
  774. return view('user/groupsform', [
  775. 'groups' => $groups
  776. ]);
  777. }
  778. public function listGroups()
  779. {
  780. $limit = input('limit');
  781. $page = input('page');
  782. $list = UserGroupsModel::order(['isdefault'=>'desc','id'=>'asc'])->limit($limit)->page($page)->append(['isdefault_text'])->select();
  783. $count = UserGroupsModel::count();
  784. if ($count==0) {
  785. exit(json_encode(array(
  786. 'code' => 1,
  787. 'msg' => "未查询到数据"
  788. )));
  789. }
  790. exit(json_encode(array(
  791. 'code' => 0,
  792. 'msg' => "",
  793. 'count' => $count,
  794. 'data' => $list
  795. )));
  796. }
  797. public function editGroups()
  798. {
  799. $id = input('id/d');
  800. if (empty($id)) {
  801. $groups = UserGroupsModel::create([
  802. 'title' => input('title/s'),
  803. 'isdefault' => input('isdefault/d')==2 ? 2 : 1
  804. ]);
  805. } else {
  806. $administer = UserGroupsModel::find($id);
  807. $administer->save([
  808. 'title' => input('title/s'),
  809. 'isdefault' => input('isdefault/d')==2 ? 2 : 1
  810. ]);
  811. }
  812. exit(json_encode(array(
  813. 'code' => 0
  814. )));
  815. }
  816. public function delGroups()
  817. {
  818. $access_admin = session('access_admin');
  819. $password = input('password');
  820. if ($access_admin['password'] !== md5($password)) {
  821. exit(json_encode(array(
  822. 'code' => 1,
  823. 'msg' => "操作密码验证失败"
  824. )));
  825. }
  826. $idarr = input('idarr/a');
  827. UserGroupsModel::whereIn('id', $idarr)->delete();
  828. exit(json_encode(array(
  829. 'code' => 0,
  830. 'msg' => ""
  831. )));
  832. }
  833. // 参数设置
  834. public function param()
  835. {
  836. $param = UserParamModel::where(1)->findOrEmpty();
  837. return view('user/param', [
  838. 'param' => $param
  839. ]);
  840. }
  841. public function editParam()
  842. {
  843. $param = UserParamModel::where(1)->findOrEmpty();
  844. $data = array(
  845. 'redmoney' => input('redmoney/d', 0),
  846. 'usernumber' => input('usernumber/d', 0),
  847. 'shareintegral' => input('shareintegral/d', 0),
  848. 'postintegral' => input('postintegral/d', 0),
  849. 'inttomoney' => input('inttomoney/d', 0),
  850. 'minintegral' => input('minintegral/d', 0),
  851. 'intrecharge' => input('intrecharge/d', 0),
  852. 'picregworker' => input('picregworker/s', ""),
  853. 'intregworker' => input('intregworker/d', 0)
  854. );
  855. if ($param->isEmpty()) {
  856. UserParamModel::create($data);
  857. } else {
  858. $data['id'] = $param->id;
  859. UserParamModel::update($data);
  860. }
  861. exit(json_encode(array(
  862. 'code' => 0,
  863. 'msg' => ""
  864. )));
  865. }
  866. // 用户组
  867. public function willList()
  868. {
  869. return view('user/willlist');
  870. }
  871. public function willForm()
  872. {
  873. $id = input('id/d, 0');
  874. $will = UserWill::findOrEmpty($id);
  875. return view('user/willform', [
  876. 'will' => $will
  877. ]);
  878. }
  879. public function listwill()
  880. {
  881. $limit = input('limit');
  882. $page = input('page');
  883. $list = UserWill::order(['isdefault'=>'desc','id'=>'asc'])->limit($limit)->page($page)->append(['isdefault_text'])->select();
  884. $count = UserWill::count();
  885. if ($count==0) {
  886. exit(json_encode(array(
  887. 'code' => 1,
  888. 'msg' => "未查询到数据"
  889. )));
  890. }
  891. exit(json_encode(array(
  892. 'code' => 0,
  893. 'msg' => "",
  894. 'count' => $count,
  895. 'data' => $list
  896. )));
  897. }
  898. public function editwill()
  899. {
  900. $id = input('id/d');
  901. if (empty($id)) {
  902. UserWill::create([
  903. 'title' => input('title/s'),
  904. 'isdefault' => input('isdefault/d')==2 ? 2 : 1
  905. ]);
  906. } else {
  907. $administer = UserWill::find($id);
  908. $administer->save([
  909. 'title' => input('title/s'),
  910. 'isdefault' => input('isdefault/d')==2 ? 2 : 1
  911. ]);
  912. }
  913. exit(json_encode(array(
  914. 'code' => 0
  915. )));
  916. }
  917. public function delwill()
  918. {
  919. $access_admin = session('access_admin');
  920. $password = input('password');
  921. if ($access_admin['password'] !== md5($password)) {
  922. exit(json_encode(array(
  923. 'code' => 1,
  924. 'msg' => "操作密码验证失败"
  925. )));
  926. }
  927. $idarr = input('idarr/a');
  928. UserWill::whereIn('id', $idarr)->delete();
  929. exit(json_encode(array(
  930. 'code' => 0,
  931. 'msg' => ""
  932. )));
  933. }
  934. }