EmployeeService.php 59 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723
  1. <?php
  2. namespace App\Service;
  3. use App\Model\BasicType;
  4. use App\Model\Depart;
  5. use App\Model\DepartIndex;
  6. use App\Model\Employee;
  7. use App\Model\EmployeeDepartPermission;
  8. use App\Model\EmployeeFile;
  9. use App\Model\EmployeeManagerDepart;
  10. use App\Model\EmployeeMenuPermission;
  11. use App\Model\EmployeeRole;
  12. use App\Model\EmployeeTeamPermission;
  13. use App\Model\ProductInventory;
  14. use App\Model\ProductInventorySet;
  15. use App\Model\Role;
  16. use App\Model\RoleMenu;
  17. use App\Model\RoleMenuButton;
  18. use App\Model\Storehouse;
  19. use App\Model\SysMenu;
  20. use App\Model\SysMenuButton;
  21. use App\Model\Team;
  22. use App\Model\WxEmployeeOfficial;
  23. use App\Service\Weixin\WeixinService;
  24. use Illuminate\Support\Facades\DB;
  25. use Illuminate\Support\Facades\Hash;
  26. use Mockery\Exception;
  27. /**
  28. * 人员相关
  29. * @package App\Models
  30. */
  31. class EmployeeService extends Service
  32. {
  33. public function employeeEditImg($data, $user){
  34. $time = time();
  35. try {
  36. DB::beginTransaction();
  37. $old = EmployeeFile::where('del_time',0)
  38. ->where('employee_id',$user['id'])
  39. ->select('file')
  40. ->get()->toArray();
  41. $old = array_column($old,'file');
  42. EmployeeFile::where('del_time',0)
  43. ->where('employee_id',$user['id'])
  44. ->update(['del_time' => $time]);
  45. $new = [];
  46. $insert = [];
  47. if(! empty($data['img_url'])){
  48. $insert[] = [
  49. 'employee_id' => $user['id'],
  50. 'file' => $data['img_url'],
  51. 'crt_time' => $time,
  52. ];
  53. EmployeeFile::insert($insert);
  54. $new[] = $data['img_url'];
  55. }
  56. DB::commit();
  57. }catch (\Throwable $exception){
  58. DB::rollBack();
  59. return [false, $exception->getMessage()];
  60. }
  61. return [true, ['file' => ['new' => $new, 'old' => $old]]];
  62. }
  63. public function getEmployeeImg($user){
  64. $file = EmployeeFile::where('del_time',0)
  65. ->where('employee_id',$user['id'])
  66. ->select('file')
  67. ->get()->toArray();
  68. $file = array_column($file,'file');
  69. $file = $file[0] ?? "";
  70. $img_str = "";
  71. $timpstamp = 86400;
  72. if(! empty($file)){
  73. $fileUploadService = new FileUploadService();
  74. $img_str = $fileUploadService->getFileShow($file, $timpstamp);
  75. }
  76. return [true, ['img_url' => $img_str]];
  77. }
  78. public function employeeEditOther($data,$user){
  79. list($status,$msg) = $this->employeeOtherRule($data,$user);
  80. if(!$status) return [$status,$msg];
  81. try {
  82. DB::beginTransaction();
  83. $model = new Employee();
  84. $model = $model->where('id',$user['id'])->first();
  85. $model->password = Hash::make($data['new_password']);
  86. $model->save();
  87. DB::commit();
  88. }catch (\Exception $exception){
  89. DB::rollBack();
  90. return [false, $exception->getMessage()];
  91. }
  92. return [true,''];
  93. }
  94. public function employeeOtherRule($data,$user){
  95. if(! isset($data['old_password'])) return [false,'请输入原密码'];
  96. if($data['old_password'] == "") return [false,'原密码不能为空'];
  97. if(! isset($data['new_password'])) return [false,'请输入新密码'];
  98. if($data['new_password'] == "") return [false,'新密码不能为空'];
  99. if(! isset($data['re_password'])) return [false,'请输入确认密码'];
  100. if($data['re_password'] == "") return [false,'确认密码不能为空'];
  101. if(! Hash::check($data['old_password'], $user['password'])) return [false,'原密码错误'];
  102. if($data['new_password'] == $data['old_password']) return [false,'原密码与新密码一致'];
  103. if($data['new_password'] !== $data['re_password']) return [false,'新密码与确认密码不一致'];
  104. return [true,''];
  105. }
  106. /**
  107. * 用户编辑
  108. * @param $data
  109. * @param $user
  110. * @return array
  111. */
  112. public function employeeEdit($data,$user){
  113. list($status,$msg) = $this->employeeRule($data,false);
  114. if(!$status) return [$status,$msg];
  115. try {
  116. DB::beginTransaction();
  117. $model = new Employee();
  118. $model = $model->where('id',$data['id'])->first();
  119. $model->number = $data['number'];
  120. $model->emp_name = $data['emp_name'];
  121. $model->mobile = $data['mobile'] ?? '';
  122. $model->leave_time = $data['leave_time'] ?? '';
  123. $model->entry_time = $data['entry_time'] ?? '';
  124. $model->state = empty($data['leave_time']) ? Employee::USE : Employee::NOT_USE;
  125. $model->is_admin = $data['is_admin'];
  126. $model->account = $data['number'];
  127. if($model->is_admin == 1){
  128. if($data['password'] !== '******'){
  129. $model->password = Hash::make($data['password']);
  130. }
  131. }
  132. $model->save();
  133. EmployeeDepartPermission::where('employee_id',$data['id'])->delete();
  134. if(isset($data['depart'])){
  135. $insert = [];
  136. foreach ($data['depart'] as $value){
  137. $insert[] = [
  138. 'employee_id' => $model->id,
  139. 'depart_id' => $value,
  140. ];
  141. }
  142. EmployeeDepartPermission::insert($insert);
  143. }
  144. EmployeeRole::where('employee_id',$data['id'])->update([
  145. 'del_time' => time()
  146. ]);
  147. if(isset($data['role'])){
  148. $insert = [];
  149. foreach ($data['role'] as $value){
  150. $insert[] = [
  151. 'employee_id' => $model->id,
  152. 'role_id' => $value,
  153. 'crt_time' => time(),
  154. 'upd_time' => time(),
  155. ];
  156. }
  157. EmployeeRole::insert($insert);
  158. }
  159. DB::commit();
  160. }catch (\Exception $exception){
  161. DB::rollBack();
  162. return [false, $exception->getMessage()];
  163. }
  164. return [true,''];
  165. }
  166. /**
  167. * 用户新增
  168. * @param $data
  169. * @param $user
  170. * @return array
  171. */
  172. public function employeeAdd($data,$user){
  173. list($status,$msg) = $this->employeeRule($data);
  174. if(!$status) return [$status,$msg];
  175. try{
  176. DB::beginTransaction();
  177. $model = new Employee();
  178. $model->number = $data['number'];
  179. $model->emp_name = $data['emp_name'];
  180. $model->mobile = $data['mobile'] ?? '';
  181. $model->leave_time = $data['leave_time'] ?? '';
  182. $model->entry_time = $data['entry_time'] ?? '';
  183. $model->state = empty($data['leave_time']) ? Employee::USE : Employee::NOT_USE;
  184. $model->crt_id = $user['id'];
  185. $model->is_admin = $data['is_admin'];
  186. $model->account = $data['number'];
  187. if($model->is_admin == 1){
  188. if($data['password'] !== '********'){
  189. $model->password = Hash::make($data['password']);
  190. }
  191. }
  192. $model->save();
  193. if(isset($data['depart'])){
  194. $insert = [];
  195. foreach ($data['depart'] as $value){
  196. $insert[] = [
  197. 'employee_id' => $model->id,
  198. 'depart_id' => $value,
  199. ];
  200. }
  201. EmployeeDepartPermission::insert($insert);
  202. }
  203. if(isset($data['role'])){
  204. $insert = [];
  205. foreach ($data['role'] as $value){
  206. $insert[] = [
  207. 'employee_id' => $model->id,
  208. 'role_id' => $value,
  209. 'crt_time' => time(),
  210. 'upd_time' => time(),
  211. ];
  212. }
  213. EmployeeRole::insert($insert);
  214. }
  215. DB::commit();
  216. }catch (Exception $e){
  217. DB::rollBack();
  218. return [false, $e->getMessage()];
  219. }
  220. return [true,''];
  221. }
  222. /**
  223. * 用户删除
  224. * @param $data
  225. * @return array
  226. */
  227. public function employeeDel($data){
  228. if($this->isEmpty($data,'id')) return [false,'请选择删除的数据!'];
  229. Employee::whereIn('id',$data['id'])->update([
  230. 'del_time'=>time()
  231. ]);
  232. EmployeeRole::where('del_time',0)->whereIn('employee_id',$data['id'])->update([
  233. 'del_time'=>time()
  234. ]);
  235. EmployeeDepartPermission::whereIn('employee_id',$data['id'])->delete();
  236. return [true,'删除成功'];
  237. }
  238. /**
  239. * 用户列表
  240. * @param $data
  241. * @param $user
  242. * @return array
  243. */
  244. public function employeeList($data,$user){
  245. $model = Employee::where('del_time',0)
  246. ->select('number','mobile','emp_name','id','entry_time','leave_time','is_admin','state')
  247. ->orderBy('id','desc');
  248. if(! empty($data['depart'])) {
  249. $depart = Depart::where('del_time',0)
  250. ->select('id','parent_id')
  251. ->get()->toArray();
  252. $result = array_merge($this->getAllDescendants($depart,$data['depart']),[$data['depart']]);
  253. $employee_id = DB::table('employee_depart_permission')
  254. ->whereIn("depart_id", $result)
  255. ->select("employee_id")
  256. ->get()->toArray();
  257. $employee_id = array_column($employee_id,'employee_id');
  258. $model->whereIn("id", $employee_id);
  259. }else{
  260. if(! $user['is_all_depart'] && empty($data['is_top_qx'])){
  261. $employee_id = $this->getEmployee($user);
  262. $model->whereIn('id',$employee_id);
  263. }
  264. }
  265. if(! empty($data['number'])) $model->where('number', 'LIKE', '%'.$data['number'].'%');
  266. if(! empty($data['emp_name'])) $model->where('emp_name', 'LIKE', '%'.$data['emp_name'].'%');
  267. if(! empty($data['state'])) $model->where('state',$data['state']);
  268. if(! empty($data['mobile'])) $model->where('mobile', 'LIKE', '%'.$data['mobile'].'%');
  269. if(! isset($data['all_emp'])) $model->where('id','<>',Employee::SPECIAL_ADMIN);
  270. if(! empty($data['role'])) {
  271. $emp = EmployeeRole::where('role_id',$data['role'])
  272. ->where('del_time',0)
  273. ->select('employee_id')->get()->toArray();
  274. $model->whereIn('id',array_column($emp,'employee_id'));
  275. }
  276. if($user['id'] != Employee::SPECIAL_ADMIN) $model->where('is_manager',0);
  277. $list = $this->limit($model,'',$data);
  278. //组织数据
  279. $list = $this->organizationEmployeeData($list);
  280. return [true , $list];
  281. }
  282. /**
  283. * 用户数据组装
  284. * @param $data
  285. * @return array
  286. */
  287. public function organizationEmployeeData($data) {
  288. if (empty($data['data'])) return $data;
  289. $res = DB::table('employee_role as a')
  290. ->leftJoin('role as b','a.role_id','=','b.id')
  291. ->where('a.del_time',0)
  292. ->where('b.del_time',0)
  293. ->whereIn("a.employee_id",array_column($data['data'],'id'))
  294. ->select('a.employee_id','b.title','b.id')
  295. ->get()->toArray();
  296. $role = $role2 = [];
  297. foreach ($res as $value){
  298. if(isset($role[$value->employee_id])){
  299. $role[$value->employee_id] .= ',' . $value->title;
  300. }else{
  301. $role[$value->employee_id] = $value->title;
  302. }
  303. $role2[$value->employee_id][] = $value->id;
  304. }
  305. $map = $this->getTopDepartSon();
  306. $res = DB::table('employee_depart_permission as a')
  307. ->select('a.employee_id','b.title','b.id')
  308. ->join('depart as b','a.depart_id','=','b.id')
  309. ->whereIn("a.employee_id",array_column($data['data'],'id'))
  310. ->orderBy('b.id')
  311. ->get()->toArray();
  312. $depart_title = $depart_id = $man_top_depart = [];
  313. foreach ($res as $value){
  314. if(isset($depart_title[$value->employee_id])){
  315. $depart_title[$value->employee_id] .= ',' . $value->title;
  316. }else{
  317. $depart_title[$value->employee_id] = $value->title;
  318. }
  319. $depart_id[$value->employee_id][] = $value->id;
  320. $tmp = $map[$value->id] ?? [];
  321. if(empty($tmp)) continue;
  322. $key = $tmp['id'] . $tmp['title'];
  323. if(! isset($man_top_depart[$value->employee_id][$key])) {
  324. $man_top_depart[$value->employee_id][$key] = $map[$value->id];
  325. }
  326. }
  327. foreach ($man_top_depart as $key => $value){
  328. $man_top_depart[$key] = array_values($value);
  329. }
  330. $wx = WxEmployeeOfficial::where('appid',WeixinService::APPID)
  331. ->where('employee_id','>',0)
  332. ->select('employee_id')
  333. ->get()->toArray();
  334. $wx = array_column($wx,'employee_id');
  335. foreach ($data['data'] as $key => $value){
  336. $data['data'][$key]['role'] = $role2[$value['id']] ?? [];
  337. $data['data'][$key]['role_name'] = $role[$value['id']] ?? '';
  338. $data['data'][$key]['depart'] = $depart_id[$value['id']] ?? [];
  339. $data['data'][$key]['depart_title'] = $depart_title[$value['id']] ?? '';
  340. $is_wx = "未绑定微信公众号";
  341. if(in_array($value['id'], $wx)) $is_wx = "已绑定微信公众号";
  342. $data['data'][$key]['is_wx'] = $is_wx;
  343. $data['data'][$key]['my_top'] = $man_top_depart[$value['id']] ?? [];
  344. }
  345. return $data;
  346. }
  347. //门店下所有子集
  348. public function getTopDepartSon(){
  349. $departList = Depart::where('del_time',0)
  350. ->select('id','parent_id','title')
  351. ->get()->toArray();
  352. $map = [];
  353. foreach ($departList as $value){
  354. if($value['parent_id'] == 0){
  355. $result = array_merge($this->getAllDescendants($departList,$value['id']),[$value['id']]);
  356. foreach ($result as $val){
  357. $map[$val] = [
  358. 'id' => $value['id'],
  359. 'title' => $value['title'],
  360. ];
  361. }
  362. }
  363. }
  364. return $map;
  365. }
  366. //获取当前顶级部门下人员id
  367. public function getEmployee($user){
  368. $top_depart_id = $user['depart_top'][0] ?? [];
  369. $top_depart_id = $top_depart_id['depart_id'] ?? 0;
  370. $list = Depart::where('del_time',0)->select('id','parent_id')->get()->toArray();
  371. // 查找所有子级id
  372. $childIds = $this->findChildIds($top_depart_id, $list);
  373. $childIds[] = $top_depart_id;
  374. $employee_id = EmployeeDepartPermission::whereIn('depart_id',$childIds)
  375. ->select("employee_id")
  376. ->get()->toArray();
  377. return array_unique(array_column($employee_id,'employee_id'));
  378. }
  379. /**
  380. * 用户参数规则
  381. * @param $data
  382. * @param $is_add
  383. * @return array
  384. */
  385. public function employeeRule($data,$is_add = true){
  386. if($this->isEmpty($data,'number')) return [false,'工号不存在!'];
  387. if($this->isEmpty($data,'emp_name')) return [false,'姓名不存在!'];
  388. if(empty($data['depart'])) return [false,'部门不能为空'];
  389. $mobile = $data['mobile'] ?? "";
  390. $number = $data['number'] ?? "";
  391. if(! $is_add){
  392. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  393. $bool = Employee::where('del_time',0)
  394. ->where('id','<>',$data['id'])
  395. ->where(function ($query) use ($mobile, $number){
  396. $query->where('number', $number);
  397. $query->when(! empty($mobile), function ($query) use ($mobile) {
  398. return $query->orWhere('mobile', $mobile);
  399. });
  400. })->exists();
  401. }else{
  402. $bool = Employee::where('del_time',0)
  403. ->where(function ($query) use ($mobile, $number){
  404. $query->where('number', $number);
  405. $query->when(! empty($mobile), function ($query) use ($mobile) {
  406. return $query->orWhere('mobile', $mobile);
  407. });
  408. })->exists();
  409. }
  410. if($bool) return [false,'工号或手机号码已存在!'];
  411. return [true,''];
  412. }
  413. /**
  414. * 角色编辑
  415. * @param $data
  416. * @return array
  417. */
  418. public function roleEdit($data,$user){
  419. list($status,$msg) = $this->roleRule($data,$user, false);
  420. if(!$status) return [$status,$msg];
  421. $model = new Role();
  422. $model = $model->where('id',$data['id'])->first();
  423. $model->title = $data['title'];
  424. $model->save();
  425. return [true,''];
  426. }
  427. /**
  428. * 角色新增
  429. * @param $data
  430. * @param $user
  431. * @return array
  432. */
  433. public function roleAdd($data,$user){
  434. list($status,$msg) = $this->roleRule($data,$user);
  435. if(!$status) return [$status,$msg];
  436. $model = new Role();
  437. $model->title = $data['title'] ;
  438. $model->depart_id = $data['depart_id'] ?? 0;
  439. $model->top_depart_id = $data['top_depart_id'] ?? 0;
  440. $model->save();
  441. return [true,''];
  442. }
  443. /**
  444. * 角色删除
  445. * @param $data
  446. * @return array
  447. */
  448. public function roleDel($data){
  449. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  450. $bool = EmployeeRole::where('del_time',0)
  451. ->whereIn('role_id',$data['id'])
  452. ->exists();
  453. if($bool) return [false,'角色已绑定人员!'];
  454. Role::where('id',$data['id'])->update([
  455. 'del_time' => time()
  456. ]);
  457. RoleMenu::where('del_time',0)->where('role_id',$data['id'])->update([
  458. 'del_time' => time()
  459. ]);
  460. RoleMenuButton::where('del_time',0)->where('role_id',$data['id'])->update([
  461. 'del_time' => time()
  462. ]);
  463. return [true, ''];
  464. }
  465. /**
  466. * 角色列表
  467. * @param $data
  468. * @return array
  469. */
  470. public function roleList($data,$user){
  471. $model = Role::TopClear($user,$data);
  472. $model = $model->where('del_time',0)
  473. ->select('title','crt_time','id','upd_time')
  474. ->orderBy('id','desc');
  475. if(! empty($data['title'])) $model->where('title', 'LIKE', '%' . $data['title'] . '%');
  476. $list = $this->limit($model,'',$data);
  477. return [true, $list];
  478. }
  479. /**
  480. * 角色参数规则
  481. * @param $data
  482. * @param $is_check
  483. * @return array
  484. */
  485. public function roleRule(&$data,$user, $is_check = true){
  486. if($this->isEmpty($data,'title')) return [false,'名称不能为空!'];
  487. //所属部门 以及 顶级部门
  488. if(empty($data['depart_id'])) $data['depart_id'] = $this->getDepart($user);
  489. $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;
  490. if($is_check){
  491. $bool = Role::where('title',$data['title'])
  492. ->where('top_depart_id',$data['top_depart_id'])
  493. ->where('del_time',0)
  494. ->exists();
  495. if($bool) return [false,'角色名称已存在!'];
  496. }else{
  497. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  498. $top_depart_id = Role::where('id',$data['id'])->value('top_depart_id');
  499. $bool = Role::where('title',$data['title'])
  500. ->where('top_depart_id',$top_depart_id)
  501. ->where('id','<>',$data['id'])
  502. ->where('del_time',0)
  503. ->exists();
  504. if($bool) return [false,'角色名称已存在!'];
  505. }
  506. return [true, ''];
  507. }
  508. /**
  509. * 角色菜单更新
  510. * @param $data
  511. * @return array
  512. */
  513. public function roleMenu($data){
  514. if(empty($data['role_id'])) return [false,'角色不能为空!'];
  515. if(empty($data['menu'])) return [false,'菜单数据不能为空!'];
  516. DB::beginTransaction();
  517. try {
  518. RoleMenu::where('del_time',0)->where('role_id',$data['role_id'])->update(['del_time' => time()]);
  519. RoleMenuButton::where('del_time',0)->where('role_id',$data['role_id'])->update(['del_time' => time()]);
  520. $insert = $insert2 = [];
  521. foreach ($data['menu'] as $t){
  522. $insert[] = [
  523. 'role_id' => $data['role_id'],
  524. 'menu_id' => $t['menu_id'],
  525. 'type' => $t['type'],
  526. 'crt_time' => time()
  527. ];
  528. if(! empty($t['button'])){
  529. foreach ($t['button'] as $b){
  530. $insert2[] = [
  531. 'role_id' => $data['role_id'],
  532. 'menu_id' => $t['menu_id'],
  533. 'button_id' => $b,
  534. 'crt_time' => time()
  535. ];
  536. }
  537. RoleMenuButton::insert($insert2);
  538. }
  539. }
  540. RoleMenu::insert($insert);
  541. DB::commit();
  542. }catch (\Throwable $exception){
  543. DB::rollBack();
  544. return [false,$exception->getMessage()];
  545. }
  546. return [true, ''];
  547. }
  548. /**
  549. * 角色详情
  550. * @param $data
  551. * @return array
  552. */
  553. public function roleDetail($data){
  554. if(empty($data['role_id'])) return [false,'请选择角色'];
  555. $role = Role::where('id',$data['role_id'])
  556. ->where('del_time',0)
  557. ->select('id','title')
  558. ->first();
  559. if(empty($role)) return [false,'角色不存在或已被删除'];
  560. $role = $role->toArray();
  561. $menu = RoleMenu::where('role_id',$data['role_id'])
  562. ->where('del_time',0)
  563. ->select('menu_id','type')
  564. ->get()->toArray();
  565. $button = $this->fillRoleButton([$data['role_id']]);
  566. foreach ($menu as $key => $value){
  567. $menu[$key]['button'] = $button[$value['menu_id']] ?? [];
  568. }
  569. $role['menu'] = $menu;
  570. return [true, $role];
  571. }
  572. public function departSetIndex($data,$user){
  573. if(empty($data['data'])) return [false, '指标数据不能为空'];
  574. $time = time();
  575. $insert = [];
  576. foreach ($data['data'] as $value){
  577. if(empty($value['top_depart_id'])) return [false, '请选择门店'];
  578. if(! isset($value['param_one'])) return [false, '请填写销售额'];
  579. if(floatval($value['param_one']) == 0.0) return [false,'销售额不能为空'];
  580. $insert[] = [
  581. 'top_depart_id' => $value['top_depart_id'],
  582. 'param_one' => $value['param_one'],
  583. 'crt_time' => $time,
  584. ];
  585. }
  586. if(empty($insert)) return [true, ''];
  587. //删除指标
  588. DepartIndex::where('del_time',0)
  589. ->update(['del_time' => $time]);
  590. //写入指标
  591. DepartIndex::insert($insert);
  592. return [true, ''];
  593. }
  594. /**
  595. * 部门编辑
  596. * @param $data
  597. * @return array
  598. */
  599. public function departEdit($data, $user){
  600. list($status,$msg) = $this->departRule($data,$user,false);
  601. if(!$status) return [$status,$msg];
  602. $update = $msg['data'][0];
  603. $model = new Depart();
  604. $model->where('id',$data['id'])->update($update);
  605. return [true,'保存成功!'];
  606. }
  607. /**
  608. * 部门新增
  609. * @param $data
  610. * @param $user
  611. * @return array
  612. */
  613. public function departAdd($data,$user){
  614. list($status,$msg) = $this->departRule($data,$user);
  615. if(!$status) return [$status,$msg];
  616. try {
  617. DB::beginTransaction();
  618. $time = time();
  619. foreach ($msg['data'] as $value){
  620. $model = new Depart();
  621. $model->parent_id = $value['parent_id'];
  622. $model->title = $value['title'];
  623. $model->code = $value['code'];
  624. $model->is_main = $value['is_main'];
  625. $model->basic_type_id = $value['basic_type_id'] ?? 0;
  626. $model->rate = $value['rate'] ?? 0;
  627. $model->notify_id = $value['notify_id'] ?? 0;
  628. $model->area = $value['area'] ?? 0;
  629. $model->province = $value['province'] ?? "";
  630. $model->save();
  631. $depart_id = $model->id;
  632. if(empty($depart_id)) {
  633. DB::rollBack();
  634. return [false,'部门新建失败'];
  635. }
  636. if(empty($value['parent_id'])){
  637. $m = new Storehouse();
  638. $m->title = $value['title'];
  639. $m->depart_id = $depart_id;
  640. $m->top_depart_id = $depart_id;
  641. $m->crt_id = $user['id'];
  642. $m->save();
  643. if(empty($m->id)) {
  644. DB::rollBack();
  645. return [false,'仓库生成失败'];
  646. }
  647. $employee = new Employee();
  648. $number = "admin" . $value['code'];
  649. $employee->number = $number;
  650. $employee->emp_name = $value['title'] . "管理员账号";
  651. $employee->entry_time = date('Y-m-d');
  652. $employee->state = 1;
  653. $employee->crt_id = $user['id'];
  654. $employee->is_admin = 1;
  655. $employee->account = $number;
  656. $employee->password = Hash::make("password");
  657. $employee->is_manager = 1;
  658. $employee->save();
  659. if(empty($employee->id)) {
  660. DB::rollBack();
  661. return [false,'管理员账号生成失败'];
  662. }
  663. $depart = new EmployeeDepartPermission();
  664. $depart->employee_id = $employee->id;
  665. $depart->depart_id = $depart_id;
  666. $depart->save();
  667. if(empty($depart->id)) {
  668. DB::rollBack();
  669. return [false,'管理员账号部门关联生成失败'];
  670. }
  671. //公司系统设置
  672. ProductInventorySet::insert(['top_depart_id' => $depart_id, 'param_one' => 1, 'crt_time' => $time]);
  673. // if(! empty($value['is_main'])){
  674. // //总供应商 所有分社可见
  675. // Supplier::insert([
  676. // 'title' => $value['title'],
  677. // 'crt_id' => $user['id'],
  678. // 'crt_time' => $time,
  679. // 'depart_id' => $depart_id,
  680. // 'top_depart_id' => $depart_id,
  681. // 'is_main' => Supplier::is_main,
  682. // ]);
  683. // }
  684. }
  685. }
  686. DB::commit();
  687. }catch (\Exception $exception){
  688. DB::rollBack();
  689. return [false,$exception->getMessage()];
  690. }
  691. return [true,'保存成功!'];
  692. }
  693. /**
  694. * 部门删除
  695. * @param $data
  696. * @return array
  697. */
  698. public function departDel($data){
  699. list($status,$msg) = $this->checkDepartDel($data);
  700. if(! $status) return [false, $msg];
  701. Depart::whereIn('id',$data['id'])->update([
  702. 'del_time'=>time()
  703. ]);
  704. return [true,'删除成功'];
  705. }
  706. /**
  707. * 判断部门是否可以删除
  708. * @param $data
  709. * @return array
  710. */
  711. public function checkDepartDel($data){
  712. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  713. $bool = Depart::whereIn('parent_id',$data['id'])->where('del_time',0)->exists();
  714. if($bool) return [false,'部门下有子部门!'];
  715. if($this->checkDepartHasPerson($data['id'])) return [false,'部门下有人员档案!'];
  716. $bool = ProductInventory::whereIn('top_depart_id',$data['id'])->where('del_time',0)->exists();
  717. if($bool) return [false,'部门下的仓库有产品信息!'];
  718. return [true, ''];
  719. }
  720. /**
  721. * 部门列表
  722. * @param $data
  723. * @param $user
  724. * @return array
  725. */
  726. public function departList($data,$user){
  727. $model = Depart::where('del_time',0)
  728. ->select('title','id','code','parent_id','is_main','basic_type_id','rate','notify_id','channel_id','area','province')
  729. ->orderby('id', 'asc');
  730. if(! empty($data['get_top']) && $data['get_top'] == 1){
  731. //指派销售
  732. $depart_id = $this->getDepartIdListOfMySales($user);
  733. $model->whereIn('id', $depart_id);
  734. }else{
  735. if(! $user['is_all_depart'] && empty($data['is_top_qx'])){
  736. $depart_id = $this->getDepartIdList($user);
  737. $model->whereIn('id',$depart_id);
  738. }
  739. }
  740. if(isset($data['parent_id'])) $model->where('parent_id', $data['parent_id']);
  741. if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
  742. if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
  743. $list = $model->get()->toArray();
  744. $list = $this->fillDepartList($list, $user);
  745. $list_tree = $list;
  746. if(! empty($list_tree)) {
  747. $list_tree = $this->makeTree(0,$list_tree);
  748. $list_tree = $this->set_sort_circle($list_tree);
  749. }
  750. return [200,['data' => $list,'tree' => $list_tree]];
  751. }
  752. public function fillDepartList($list,$user){
  753. if(empty($list)) return $list;
  754. $basic = BasicType::where('del_time',0)
  755. ->whereIn('id', array_unique(array_column($list,'basic_type_id')))
  756. ->pluck('title','id')->toArray();
  757. $emp_id = array_unique(array_merge_recursive(array_column($list,'notify_id'),array_column($list,'channel_id')));
  758. $emp_map = Employee::whereIn('id',$emp_id)
  759. ->pluck('emp_name','id')
  760. ->toArray();
  761. //省
  762. $address_map = config('address');
  763. $address_map = array_column($address_map,'label','value');
  764. foreach ($list as $key => $value){
  765. $list[$key]['basic_type_title'] = $basic[$value['basic_type_id']] ?? '';
  766. $list[$key]['is_show_basic_type'] = $user['is_all_depart'];
  767. $list[$key]['notify_name'] = $emp_map[$value['notify_id']] ?? '';
  768. $list[$key]['channel_name'] = $emp_map[$value['channel_id']] ?? '';
  769. $list[$key]['area_name'] = Depart::$area[$value['area']] ?? '';
  770. $list[$key]['province_name'] = $address_map[$value['province']] ?? '';
  771. }
  772. return $list;
  773. }
  774. //获取可见的部门范围
  775. public function getDepartIdList($user){
  776. $list = Depart::where('del_time',0)->select('id','parent_id')->get()->toArray();
  777. $result = [];
  778. foreach ($user['depart_range'] as $v){
  779. // 查找所有父级id
  780. $parentIds = $this->findParentIds($v, $list);
  781. // 查找所有子级id
  782. $childIds = $this->findChildIds($v, $list);
  783. // 合并父级和子级id
  784. $tmp = array_merge($parentIds, $childIds, [$v]);
  785. $result = array_merge($result,$tmp);
  786. }
  787. return array_unique($result);
  788. }
  789. //获取指派销售时的部门
  790. public function getDepartIdListOfMySales($user){
  791. $top = $user['depart_top'][0] ?? [];
  792. $top = $top['depart_id'] ?? 0;
  793. $list = Depart::where('del_time',0)->select('id','parent_id')->get()->toArray();
  794. // 查找所有子级id
  795. $childIds = $this->findChildIds($top, $list);
  796. $result = array_merge($childIds, [$top]);
  797. return $result;
  798. }
  799. /**
  800. * 部门参数规则
  801. * @param $data
  802. * @param $is_check
  803. * @return array
  804. */
  805. public function departRule($data,$user, $is_check = true){
  806. if($this->isEmpty($data,'data')) return [false,'数据不能为空!'];
  807. $code = array_column($data['data'],'code');
  808. $title = array_column($data['data'],'title');
  809. $code = array_map(function($val) {
  810. return $val !== null ? $val : 0;
  811. }, $code);
  812. $title = array_map(function($val) {
  813. return $val !== null ? $val : 0;
  814. }, $title);
  815. $code_count = array_count_values($code);
  816. $title_count = array_count_values($title);
  817. foreach ($code as $value){
  818. if(empty($value)) return [false,'编码不能为空!'];
  819. if($code_count[$value] > 1) return [false,'编码不能重复'];
  820. }
  821. foreach ($title as $value){
  822. if(empty($value)) return [false,'名称不能为空!'];
  823. if($title_count[$value] > 1) return [false,'名称不能重复'];
  824. }
  825. $count = 0;
  826. foreach ($data['data'] as $value){
  827. if(empty($value['parent_id']) && ! empty($value['is_main'])) $count ++;
  828. }
  829. if($count > 1) return [false,'总社已存在!'];
  830. if($count == 1){
  831. $id = $data['id'] ?? 0;
  832. $bool = Depart::where('del_time',0)
  833. ->where('parent_id',0)
  834. ->where('is_main',1)
  835. ->when(! empty($id), function ($query) use ($id) {
  836. return $query->where('id', '<>',$id);
  837. })
  838. ->exists();
  839. if($bool) return [false,'总社已存在!'];
  840. }
  841. //省
  842. $address_map = config('address');
  843. $address_map = array_column($address_map,'label','value');
  844. foreach ($data['data'] as $key => $value){
  845. if(! empty($value['area'])){
  846. $area = array_keys(Depart::$area);
  847. if(! in_array($value['area'], $area)) return [false, '门店所属大区不存在'];
  848. }
  849. if(! empty($value['province']) && ! isset($address_map[$value['province']])) return [false, '门店所属省份不存在'];
  850. if(empty($value['parent_id'])) $data['data'][$key]['parent_id'] = 0;
  851. $data['data'][$key]['upd_time'] = time();
  852. //Depart::whereRaw("(binary code = '{$value['code']}' OR title = '{$value['title']}')")
  853. if($is_check){
  854. if(empty($user['is_all_depart']) && empty($value['parent_id'])) return [false,'上级部门必须选择'];
  855. $data['data'][$key]['crt_time'] = time();
  856. $bool = Depart::whereRaw("binary code = '{$value['code']}'")
  857. ->where('del_time',0)
  858. ->exists();
  859. }else{
  860. if($this->isEmpty($data,'id')) return [false,'id不能为空!'];
  861. if($data['id'] == $user['head']['id'] && empty($data['is_main'])) return [false,'总社不支持变更!'];
  862. $bool = Depart::whereRaw("binary code = '{$value['code']}'")
  863. ->where('id','<>',$data['id'])
  864. ->where('del_time',0)
  865. ->exists();
  866. }
  867. if($bool) return [false,'编码不能重复'];
  868. }
  869. return [true, $data];
  870. }
  871. /**
  872. * 检测部门下是否存在人员
  873. * @param $depart_id
  874. * @return false
  875. */
  876. public function checkDepartHasPerson($depart_id = []){
  877. if(empty($depart_id)) return false;
  878. $bool = EmployeeDepartPermission::from('employee_depart_permission as a')
  879. ->leftJoin('employee as b','b.id','a.employee_id')
  880. ->where('b.del_time',0)
  881. ->whereIn('a.depart_id',$depart_id)
  882. ->exists();
  883. return $bool;
  884. }
  885. /**
  886. * 班组编辑
  887. * @param $data
  888. * @return array
  889. */
  890. public function teamEdit($data){
  891. list($status,$msg) = $this->teamRule($data,false);
  892. if(!$status) return [$status,$msg];
  893. $model = new Team();
  894. $model = $model->where('id',$data['id'])->first();
  895. $model->title = $data['title'];
  896. $model->code = $data['code'];
  897. $model->save();
  898. return [true,'保存成功!'];
  899. }
  900. /**
  901. * 班组新增
  902. * @param $data
  903. * @param $user
  904. * @return array
  905. */
  906. public function teamAdd($data,$user){
  907. list($status,$msg) = $this->teamRule($data);
  908. if(!$status) return [$status,$msg];
  909. $model = new Team();
  910. $model->title = $data['title'] ;
  911. $model->code = $data['code'];
  912. $model->save();
  913. return [true,'保存成功!'];
  914. }
  915. /**
  916. * 班组删除
  917. * @param $data
  918. * @return array
  919. */
  920. public function teamDel($data){
  921. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  922. Team::where('id',$data['id'])->update([
  923. 'del_time'=>time()
  924. ]);
  925. return [true,'删除成功'];
  926. }
  927. /**
  928. * 班组列表
  929. * @param $data
  930. * @return array
  931. */
  932. public function teamList($data){
  933. $list = Team::where('del_time',0)
  934. ->select('title','id','crt_time','upd_time','code')
  935. ->orderBy('id','desc');
  936. $list = $this->limit($list,'',$data);
  937. return [200,$list];
  938. }
  939. /**
  940. * 班组参数规则
  941. * @param $data
  942. * @param $is_add
  943. * @return array
  944. */
  945. public function teamRule($data,$is_add = true){
  946. if($this->isEmpty($data,'title')) return [false,'名称不存在!'];
  947. if($this->isEmpty($data,'code')) return [false,'编码不存在'];
  948. $model = Team::where('title',$data['title'])
  949. ->where('code',$data['code'])
  950. ->where('del_time',0);
  951. if(! $is_add){
  952. if($this->isEmpty($data,'id')) return [false,'ID不能为空'];
  953. $model->where('id','<>',$data['id']);
  954. }
  955. $bool = $model->exists();
  956. if($bool) return [false,'名称和编码已存在!'];
  957. return [true,''];
  958. }
  959. /**
  960. * 班组详情
  961. * @param $data
  962. * @return array
  963. */
  964. public function teamDetail($data){
  965. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  966. $result = EmployeeTeamPermission::from('employee_team_permission as a')
  967. ->leftJoin('employee as b','b.id','a.employee_id')
  968. ->where('team_id',$data['id'])
  969. ->select('b.id','b.emp_name','b.number as code')
  970. ->get()->toArray();
  971. return [true,$result];
  972. }
  973. /**
  974. * 人员权限
  975. * @param $data
  976. * @return array
  977. */
  978. public function employeeRole($data){
  979. $role_ids = [];
  980. $employee_ids = [];
  981. foreach ($data as $v){
  982. if(isset($v['role_id'])){
  983. if(!in_array($v['role_id'],$role_ids)){
  984. $role_ids[] = $v['role_id'];
  985. }
  986. }
  987. if(isset($v['employee_id'])){
  988. if(!in_array($v['employee_id'],$employee_ids)){
  989. $employee_ids[] = $v['employee_id'];
  990. }
  991. }
  992. }
  993. EmployeeMenuPermission::wherein('role_id',$role_ids)->delete();
  994. EmployeeMenuPermission::wherein('employee_id',$employee_ids)->delete();
  995. EmployeeMenuPermission::insert($data);
  996. return [200,'保存成功!'];
  997. }
  998. /**
  999. * 人员部门关系更新
  1000. * @param $data
  1001. * @return array
  1002. */
  1003. public function employeeDepart($data){
  1004. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  1005. DB::beginTransaction();
  1006. try {
  1007. if($data['type'] == 1){
  1008. EmployeeDepartPermission::whereIn('depart_id',$data['insert']['depart_id'])->delete();
  1009. }else{
  1010. EmployeeDepartPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  1011. }
  1012. $insert = [];
  1013. foreach ($data['insert']['depart_id'] as $t){
  1014. foreach ($data['insert']['employee_id'] as $e){
  1015. $insert[] = [
  1016. 'depart_id' => $t,
  1017. 'employee_id' => $e
  1018. ];
  1019. }
  1020. }
  1021. EmployeeDepartPermission::insert($insert);
  1022. DB::commit();
  1023. }catch (\Throwable $exception){
  1024. DB::rollBack();
  1025. return [false,$exception->getMessage()];
  1026. }
  1027. return [true,'保存成功!'];
  1028. }
  1029. /**
  1030. * 人员班组关系更新
  1031. * @param $data
  1032. * @return array
  1033. */
  1034. public function employeeTeam($data){
  1035. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  1036. DB::beginTransaction();
  1037. try {
  1038. if($data['type'] == 1){
  1039. EmployeeTeamPermission::whereIn('team_id',$data['insert']['team_id'])->delete();
  1040. }else{
  1041. EmployeeTeamPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  1042. }
  1043. $insert = [];
  1044. foreach ($data['insert']['team_id'] as $t){
  1045. foreach ($data['insert']['employee_id'] as $e){
  1046. $insert[] = [
  1047. 'team_id' => $t,
  1048. 'employee_id' => $e
  1049. ];
  1050. }
  1051. }
  1052. EmployeeTeamPermission::insert($insert);
  1053. DB::commit();
  1054. }catch (\Throwable $exception){
  1055. DB::rollBack();
  1056. return [false,$exception->getMessage()];
  1057. }
  1058. return [true,'保存成功!'];
  1059. }
  1060. /**
  1061. * 登陆参数规则
  1062. * @param $data
  1063. * @return array
  1064. */
  1065. public function loginRule($data){
  1066. if($this->isEmpty($data,'account')) return [false,'账号不能为空!'];
  1067. if($this->isEmpty($data,'password')) return [false,'密码不存在!'];
  1068. $account = $data['account'];
  1069. $res = Employee::where('del_time',0)
  1070. ->where(function ($query)use($account) {
  1071. $query->where('account', $account)
  1072. ->orWhere('mobile', $account);
  1073. })
  1074. ->get()->toArray();
  1075. if(empty($res)) return [false,'账号不存在或已被删除!'];
  1076. if(count($res) > 1) return [false,'该手机号检测出多个账户,请联系后台!'];
  1077. $res = reset($res);
  1078. if(! Hash::check($data['password'], $res['password'])) return [false,'密码错误!'];
  1079. if($res['is_admin'] != Employee::IS_ADMIN) return [false,'该账号不能登录!'];
  1080. if($res['state'] == Employee::NOT_USE) return [false,'账号停用!'];
  1081. //门店的信息
  1082. $login_message = EmployeeService::getLoginMessage($res['id']);
  1083. return [true, ['id'=>$res['id'],'name'=>$res['emp_name'],'all_top'=> $login_message]];
  1084. }
  1085. /**
  1086. * 检查人员信息
  1087. * @param $userId
  1088. * @return array
  1089. */
  1090. public static function checkUser($userId){
  1091. $res = Employee::where('id', $userId)
  1092. ->where('del_time',0)
  1093. ->where('is_admin',Employee::IS_ADMIN)
  1094. ->where('state',Employee::USE)->get()->first();
  1095. if(empty($res)) return [false, '该账号无法登录,请联系管理员!'];
  1096. return [true, $res];
  1097. }
  1098. /**
  1099. * 获取登录账号的角色
  1100. * @param $employee_id
  1101. * @return array
  1102. */
  1103. public static function getPersonRole($employee_id){
  1104. if(empty($employee_id) || $employee_id == Employee::SPECIAL_ADMIN) return [];
  1105. $role = EmployeeRole::where('del_time',0)
  1106. ->where('employee_id',$employee_id)
  1107. ->select('role_id')
  1108. ->get()->toArray();
  1109. //组织
  1110. $role_id = array_unique(array_column($role,'role_id'));
  1111. asort($role_id);
  1112. $role_id = array_values($role_id);
  1113. return $role_id;
  1114. }
  1115. public static function getPersonRoleQx($role_id = []){
  1116. if(empty($role_id)) return [];
  1117. $role = RoleMenu::where('del_time',0)
  1118. ->whereIn('role_id',$role_id)
  1119. ->select('menu_id','type')
  1120. ->get()->toArray();
  1121. $sysmenu = SysMenu::where('del_time',0)
  1122. ->where('is_authority','>',0)
  1123. ->select('id')
  1124. ->get()->toArray();
  1125. $sysmenu = array_column($sysmenu,'id');
  1126. $return = [];
  1127. foreach ($role as $value){
  1128. if(! in_array($value['menu_id'],$sysmenu)) continue;
  1129. if(isset($return[$value['menu_id']])){
  1130. if($return[$value['menu_id']] < $value['type']) $return[$value['menu_id']] = $value['type'];
  1131. }else{
  1132. $return[$value['menu_id']] = $value['type'];
  1133. }
  1134. }
  1135. return $return;
  1136. }
  1137. public static function getSpecialButton($role_id,$user){
  1138. $return = [];
  1139. $special_button = config('specialButton');
  1140. if($user == Employee::SPECIAL_ADMIN) {
  1141. foreach ($special_button as $value){
  1142. $return[] = $value['id'];
  1143. }
  1144. return $return;
  1145. }
  1146. $role_button = RoleMenuButton::where('del_time',0)
  1147. ->where('button_id','<',0)
  1148. ->whereIn('role_id',$role_id)
  1149. ->select('menu_id','button_id')
  1150. ->get()->toArray();
  1151. foreach ($role_button as $value){
  1152. $return[] = $value['button_id'];
  1153. }
  1154. return $return;
  1155. }
  1156. //通过角色获取菜单
  1157. public function getMenuByRoleInList($user){
  1158. $role_id = $user['role'] ?? [];
  1159. $menu = SysMenu::where('del_time',0)->select('id')->get()->toArray();
  1160. if($user['id'] == Employee::SPECIAL_ADMIN) return array_column($menu,'id');
  1161. //没绑定角色
  1162. if(empty($role_id)) return [];
  1163. $role_menu = RoleMenu::whereIn('role_id',$role_id)
  1164. ->where('del_time',0)
  1165. ->select('menu_id')
  1166. ->get()->toArray();
  1167. return array_column($role_menu,'menu_id');
  1168. }
  1169. //通过角色获取菜单以及按钮
  1170. public function getMenuByRole($user){
  1171. $role_id = $user['role'] ?? [];
  1172. $menu = SysMenu::where('del_time',0)->select('id','uri')->get()->toArray();
  1173. $button = SysMenuButton::where('del_time',0)->select('id','title','sort','func','menu_id')->get()->toArray();
  1174. $button_map = [];
  1175. foreach ($button as $value){
  1176. $button_map[$value['menu_id']][] = $value;
  1177. }
  1178. $object = [];
  1179. //超级管理员
  1180. if($user['id'] == Employee::SPECIAL_ADMIN){
  1181. foreach ($menu as $value){
  1182. $object[] = [
  1183. 'id' => $value['id'],
  1184. // 'type' => 0,//所有权限
  1185. 'uri' => $value['uri'],
  1186. 'button' => $button_map[$value['id']] ?? [],
  1187. ];
  1188. }
  1189. }else{
  1190. //没绑定角色
  1191. if(empty($role_id)) return [];
  1192. $search = RoleMenu::whereIn('role_id',$role_id)
  1193. ->where('del_time',0)
  1194. ->select('menu_id','type')
  1195. ->get()->toArray();
  1196. $menu_map = array_column($menu,'uri','id');
  1197. //该角色下 菜单里所有按钮
  1198. $button_menu = $this->fillRoleButton($role_id);
  1199. $button_t = array_column($button,null,'id');
  1200. foreach ($search as $value){
  1201. $bt = $button_menu[$value['menu_id']] ?? [];
  1202. $new = [];
  1203. foreach ($bt as $b){
  1204. if(! empty($button_t[$b])) $new[] = $button_t[$b];
  1205. }
  1206. $object[] = [
  1207. 'id' => $value['menu_id'],
  1208. 'uri' => $menu_map[$value['menu_id']] ?? '',
  1209. // 'type' => $value['type'],
  1210. 'button' => $new,
  1211. ];
  1212. }
  1213. }
  1214. return $object;
  1215. }
  1216. /**
  1217. * 人员直接绑定部门
  1218. * @param $data
  1219. * @param $user
  1220. * @return array
  1221. */
  1222. public function employeeManagerDepart($data,$user){
  1223. if($user['id'] != Employee::SPECIAL_ADMIN) return [false,'非ADMIN账号不能操作'];
  1224. if($this->isEmpty($data,'employee_id')) return [false,'请选择操作人员'];
  1225. if($this->isEmpty($data,'depart_id')) return [false,'请选择部门'];
  1226. EmployeeManagerDepart::where('employee_id',$data['employee_id'])->update([
  1227. 'del_time' => time()
  1228. ]);
  1229. $insert = [];
  1230. foreach ($data['depart_id'] as $value){
  1231. $insert[] = [
  1232. 'employee_id' => $data['employee_id'],
  1233. 'depart_id' => $value,
  1234. 'crt_time' => time(),
  1235. 'upd_time' => time(),
  1236. ];
  1237. }
  1238. EmployeeManagerDepart::insert($insert);
  1239. return [true,''];
  1240. }
  1241. /**
  1242. * 填充角色下的按钮
  1243. * @param $role_id
  1244. * @return array
  1245. */
  1246. public function fillRoleButton($role_id){
  1247. $button = RoleMenuButton::whereIn('role_id',$role_id)
  1248. ->where('del_time',0)
  1249. ->select('menu_id','button_id')
  1250. ->get()->toArray();
  1251. $button_map = [];
  1252. foreach ($button as $value){
  1253. if(! isset($button_map[$value['menu_id']])){
  1254. $button_map[$value['menu_id']][] = $value['button_id'];
  1255. }else{
  1256. if(! in_array($value['button_id'], $button_map[$value['menu_id']])) $button_map[$value['menu_id']][] = $value['button_id'];
  1257. }
  1258. }
  1259. return $button_map;
  1260. }
  1261. /**
  1262. * 获取登录账号的部门
  1263. * @param $employee_id
  1264. * @return array|string[]
  1265. */
  1266. public static function getLoginDepart($employee_id, $top_depart_id = 0){
  1267. if(empty($employee_id)) return [];
  1268. //自己绑定的部门 启用的部门
  1269. $depart = EmployeeDepartPermission::from('employee_depart_permission as a')
  1270. ->join('depart as b','b.id','a.depart_id')
  1271. ->where('a.employee_id',$employee_id)
  1272. ->where('b.is_use',Depart::IS_UES)
  1273. ->select('a.depart_id','b.is_main','b.parent_id','b.basic_type_id','b.title')
  1274. ->orderBy('b.parent_id','asc')
  1275. ->orderBy('b.is_main','desc')
  1276. ->orderBy('a.depart_id','asc')
  1277. ->get()->toArray();
  1278. $top = $map = $rule = $head = [];
  1279. $res_data = [];//获取当前所在部门(也可能是门店 为了 depart_id)
  1280. $my_depart = [];//当前门店下 我勾选的门店以及部门信息
  1281. $is_all_depart = 0;
  1282. if(! empty($depart)){
  1283. //库存校验
  1284. $set_map = ProductInventorySet::where('del_time',0)->pluck('param_one','top_depart_id')->toArray();
  1285. //所有部门
  1286. $list = Depart::where('del_time',0)->get()->toArray();
  1287. $depart_map = array_column($list,null,'id');
  1288. foreach ($depart as $key => $value){
  1289. if($value['parent_id'] == 0){
  1290. $is_stock = $set_map[$value['depart_id']] ?? 1;
  1291. $depart[$key]['is_stock'] = $is_stock;
  1292. $top[$value['depart_id']] = [
  1293. 'depart_id' => $value['depart_id'],
  1294. 'is_main' => $value['is_main'],
  1295. 'basic_type_id' => $value['basic_type_id'],
  1296. 'title' => $value['title'],
  1297. 'is_stock' => $is_stock,
  1298. ];
  1299. $map[$value['depart_id']] = $value['depart_id'];
  1300. if($value['depart_id'] == $top_depart_id) {
  1301. $my_depart[] = $depart[$key];
  1302. if(empty($res_data)){
  1303. $res_data = $depart[$key];
  1304. }else{
  1305. if($value['depart_id'] >= $res_data['depart_id']) $res_data = $depart[$key];
  1306. }
  1307. }
  1308. }else{
  1309. $t = self::getTopParentId($value['depart_id'],$list);
  1310. if($t && isset($depart_map[$t])) {
  1311. $is_stock = $set_map[$t] ?? 1;
  1312. $depart[$key]['is_stock'] = $is_stock;
  1313. $t_tmp = $depart_map[$t] ?? [];
  1314. if( ! isset($top[$t_tmp['id']])){
  1315. $top[$t_tmp['id']] = [
  1316. 'depart_id' => $t_tmp['id'],
  1317. 'is_main' => $t_tmp['is_main'],
  1318. 'basic_type_id' => $t_tmp['basic_type_id'],
  1319. 'title' => $t_tmp['title'],
  1320. 'is_stock' => $set_map[$t] ?? 1,
  1321. ];
  1322. }
  1323. $map[$value['depart_id']] = $t;
  1324. }
  1325. if($t == $top_depart_id){
  1326. $my_depart[] = $depart[$key];
  1327. if(empty($res_data)){
  1328. $res_data = $depart[$key];
  1329. }else{
  1330. if($value['depart_id'] >= $res_data['depart_id']) $res_data = $depart[$key];
  1331. }
  1332. }
  1333. }
  1334. }
  1335. //-------------重组当前所在门店
  1336. $top = array_values($top);
  1337. usort($top, function($a, $b) {
  1338. return $b['is_main'] - $a['is_main'];
  1339. });
  1340. if(! empty($top_depart_id)){
  1341. $targetArray = null;
  1342. foreach ($top as $key => $value) {
  1343. if ($value['depart_id'] == $top_depart_id) {
  1344. $targetArray = $value;
  1345. unset($top[$key]); // 从原数组中移除目标数组
  1346. break; // 找到后跳出循环
  1347. }
  1348. }
  1349. if ($targetArray) array_unshift($top, $targetArray);
  1350. }
  1351. //-------------重组当前所在门店
  1352. //-------------拥有的数据权限(门店、部门)
  1353. $my_top = $top[0] ?? [];
  1354. foreach ($my_depart as $value){
  1355. if(in_array($value['depart_id'],$rule)) continue;
  1356. if(! $value['parent_id']){ //顶级
  1357. if(! empty($value['is_main']) && ! $is_all_depart) $is_all_depart = 1;
  1358. if($value['is_main']) {//是总公司
  1359. //所有部门都有
  1360. $rule = array_column($list,'id');
  1361. }else{//不是总公司
  1362. //自己以及子部门
  1363. $depart_id = array_merge(self::getAllIds($list,$map[$value['depart_id']]),[$map[$value['depart_id']]]);
  1364. $rule = array_merge_recursive($rule,$depart_id);
  1365. }
  1366. }else{//非顶级
  1367. if(! empty($my_top['is_main']) && $value['is_main'] && ! $is_all_depart) $is_all_depart = 1;
  1368. if($value['is_main']) {//是总社
  1369. $top_tmp = $map[$value['depart_id']];
  1370. if(! empty($depart_map[$top_tmp]['is_main'])){
  1371. //顶级公司是总公司 所有部门都有
  1372. $rule = array_column($list,'id');
  1373. }else{
  1374. //顶级公司是分公司 分公司所有部门
  1375. $depart_id = array_merge(self::getAllIds($list,$top_tmp),[$top_tmp]);
  1376. $rule = array_merge_recursive($rule,$depart_id);
  1377. }
  1378. }else{//不是总社
  1379. $rule = array_merge($rule,[$value['depart_id']]);
  1380. }
  1381. }
  1382. }
  1383. //-------------拥有的数据权限(门店、部门)
  1384. //总店
  1385. foreach ($list as $value){
  1386. if(empty($value['parent_id']) && ! empty($value['is_main'])) $head = $value;
  1387. }
  1388. }
  1389. $rule = array_unique($rule);
  1390. return [$depart,$top,$map,$rule,$is_all_depart,$head,$res_data];
  1391. }
  1392. //获取用户的所属门店信息
  1393. public static function getLoginMessage($employee_id){
  1394. if(empty($employee_id)) return [];
  1395. //自己绑定的部门 启用的部门
  1396. $depart = EmployeeDepartPermission::from('employee_depart_permission as a')
  1397. ->join('depart as b','b.id','a.depart_id')
  1398. ->where('a.employee_id',$employee_id)
  1399. ->where('b.is_use',Depart::IS_UES)
  1400. ->select('a.depart_id','b.is_main','b.parent_id','b.basic_type_id','b.title')
  1401. ->orderBy('b.parent_id','asc')
  1402. ->orderBy('b.is_main','desc')
  1403. ->orderBy('a.depart_id','asc')
  1404. ->get()->toArray();
  1405. $top = [];
  1406. if(! empty($depart)){
  1407. //所有部门
  1408. $list = Depart::where('del_time',0)->get()->toArray();
  1409. $depart_map = array_column($list,null,'id');
  1410. foreach ($depart as $value){
  1411. if($value['parent_id'] == 0){//顶级
  1412. if(! isset($top[$value['depart_id']])){
  1413. $top[$value['depart_id']] = [
  1414. 'depart_id' => $value['depart_id'],
  1415. 'is_main' => $value['is_main'],
  1416. 'title' => $value['title'],
  1417. ];
  1418. }
  1419. }else{
  1420. //门店
  1421. $t = self::getTopParentId($value['depart_id'],$list);
  1422. if($t && isset($depart_map[$t])) {
  1423. $t_tmp = $depart_map[$t] ?? [];
  1424. $is_all_depart = 0;
  1425. if(! empty($t_tmp['is_main']) && $value['is_main']) $is_all_depart = 1;
  1426. if(! isset($top[$t_tmp['id']])){
  1427. $top[$t_tmp['id']] = [
  1428. 'depart_id' => $t_tmp['id'],
  1429. 'is_main' => $is_all_depart,
  1430. 'title' => $t_tmp['title'],
  1431. ];
  1432. }else{
  1433. if(! empty($is_all_depart)) $top[$t_tmp['id']]['is_main'] = $is_all_depart;
  1434. }
  1435. }
  1436. }
  1437. }
  1438. }
  1439. $top = array_values($top);
  1440. usort($top, function($a, $b) {
  1441. return $b['is_main'] - $a['is_main'];
  1442. });
  1443. return $top;
  1444. }
  1445. /**
  1446. * 获取顶级id
  1447. * @param $id
  1448. * @param $data
  1449. * @return int
  1450. */
  1451. public static function getTopParentId($id, $data) {
  1452. foreach ($data as $item) {
  1453. if ($item['id'] == $id) {
  1454. if ($item['parent_id'] == 0) {
  1455. // 找到最顶级的id
  1456. return $item['id'];
  1457. } else {
  1458. // 继续递归查找父级
  1459. return self::getTopParentId($item['parent_id'], $data);
  1460. }
  1461. }
  1462. }
  1463. // 如果没有找到匹配的id,则返回null或者其他你希望的默认值
  1464. return 0;
  1465. }
  1466. /**
  1467. * 递归获取所有id
  1468. * @param $data
  1469. * @param $id
  1470. * @return array
  1471. */
  1472. public static function getAllIds($data, $id) {
  1473. $result = array(); // 存储结果的数组
  1474. foreach ($data as $node) {
  1475. if ($node['parent_id'] == $id) { // 如果当前节点的父 ID 等于指定 ID,则将该节点添加到结果中
  1476. $result[] = $node['id'];
  1477. // 递归查询该节点的所有子孙节点,并将结果合并到结果数组中
  1478. $result = array_merge($result, self::getAllIds($data, $node['id']));
  1479. }
  1480. }
  1481. return $result;
  1482. }
  1483. public static function checkWxUser($userId){
  1484. $res = Employee::where('id', $userId)
  1485. ->where('del_time',0)
  1486. ->where('state',Employee::USE)->get()->first();
  1487. if(empty($res)) return [false, '该账号无法登录,请联系管理员!'];
  1488. return [true, $res];
  1489. }
  1490. public function getTopMessage($data,$user){
  1491. $top = $user['depart_top'] ?? [];
  1492. return [true, ['top' => $top]];
  1493. }
  1494. }