User.php 35 KB

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