Index.php 64 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697
  1. <?php
  2. namespace app\admin\controller;
  3. use app\common\model\Config;
  4. use think\Db;
  5. class Index extends Auth
  6. {
  7. public function index(){
  8. $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
  9. $this->assign('menus',$menus);
  10. $userInfo = Db::name('user')
  11. ->where('id',$this->userId)
  12. ->find();
  13. $this->assign('userInfo',$userInfo);
  14. // 判断用户是否是调度
  15. $isDispatch = 0;
  16. if(check_is_dispatch($this->userId) || check_two_dispatch($this->userId)){
  17. $isDispatch = 1;
  18. }
  19. $this->assign('isDispatch',$isDispatch);
  20. $order = 0;
  21. // 判断用户是否是调度
  22. $level1 = check_is_dispatch($this->userId);
  23. $level2 = check_two_dispatch($this->userId);
  24. $level2onoff = two_dispatch_off($this->orgId);
  25. if(!$level1 && !$level2){
  26. $order = -1;
  27. }else{
  28. // 一级调度
  29. if($level1 || (!$level2onoff && $level2)){
  30. $map[] = ['org_id','=',$this->orgId];
  31. $map[] = ['del','=',0];
  32. $map[] = ['order_mode','=',1];
  33. if($level2onoff){
  34. $map[] = ['is_deal','=',0];
  35. }
  36. if(!is_admin($this->userId)){
  37. $auth = get_dispatch_auth($this->userId);
  38. if($auth){
  39. $map[] = ['work_type_mode', 'in', $auth];
  40. $where[] = ['o.work_type_mode', 'in', $auth];
  41. }else{
  42. $map[] = ['work_type_mode', '=', -1];
  43. $where[] = ['o.work_type_mode', '=', -1];
  44. }
  45. }
  46. $order = Db::name('orders')->where($map)->count();
  47. //$驳回的订单
  48. $where[] = ['o.del','=',0];
  49. $where[] = ['t.del','=',0];
  50. $bh = Db::name('orders')
  51. ->alias('o')
  52. ->join('todo t','t.order_id=o.id')
  53. ->where('t.todo_mode',4)
  54. ->where('t.org_id',$this->orgId)
  55. ->where('o.order_mode',4)
  56. ->where('o.org_id',$this->orgId)
  57. ->where($where)
  58. ->group('o.id')
  59. ->count();
  60. $order = $order + $bh;
  61. } else if($level2 && $level2onoff) { // 二级调度
  62. $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
  63. if(!$rolesId){
  64. $order = 0;
  65. }else{
  66. $map[] = ['b.org_id','=',$this->orgId];
  67. $map[] = ['b.del','=',0];
  68. $map[] = ['b.order_mode','=',1];
  69. $map[] = ['b.is_deal','=',1];
  70. $map[] = ['a.roles_id','=',$rolesId];
  71. if(!is_admin($this->userId)){
  72. $auth = get_dispatch_auth($this->userId);
  73. if($auth){
  74. $map[] = ['b.work_type_mode', 'in', $auth];
  75. }else{
  76. $map[] = ['b.work_type_mode', '=', -1];
  77. }
  78. }
  79. $order = Db::name('dispatch_log')
  80. ->alias('a')
  81. ->join('orders b','b.id = a.order_id')
  82. ->where($map)
  83. ->field('a.*')
  84. ->count();
  85. }
  86. }
  87. }
  88. $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  89. $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  90. $endCount = $order+$complainCount+$hiddendangerCount;
  91. $this->assign('orderNums',$endCount);
  92. //今日看板
  93. $dayOrderNums1 = Db::name('orders')
  94. ->where('org_id',$this->orgId)
  95. ->where('del',0)
  96. ->where('order_mode',1)
  97. ->where('create_time','>=',date('Y-m-d').' 00:00:00')
  98. ->where('create_time','<=',date('Y-m-d').' 23:59:59')
  99. ->count();
  100. $dayOrderNums2 = Db::name('orders')
  101. ->where('org_id',$this->orgId)
  102. ->where('del',0)
  103. ->where('order_mode',4)
  104. ->where('create_time','>=',date('Y-m-d').' 00:00:00')
  105. ->where('create_time','<=',date('Y-m-d').' 23:59:59')
  106. ->count();
  107. $dayOrderNums3 = Db::name('orders')
  108. ->where('org_id',$this->orgId)
  109. ->where('del',0)
  110. ->where('order_mode',5)
  111. ->where('create_time','>=',date('Y-m-d').' 00:00:00')
  112. ->where('create_time','<=',date('Y-m-d').' 23:59:59')
  113. ->count();
  114. $dayOrderNums4 = Db::name('orders')
  115. ->where('org_id',$this->orgId)
  116. ->where('del',0)
  117. ->where('order_mode',6)
  118. ->where('create_time','>=',date('Y-m-d').' 00:00:00')
  119. ->where('create_time','<=',date('Y-m-d').' 23:59:59')
  120. ->count();
  121. $dayOrderNums5 = Db::name('orders')
  122. ->where('org_id',$this->orgId)
  123. ->where('del',0)
  124. ->where('order_mode',2)
  125. ->where('create_time','>=',date('Y-m-d').' 00:00:00')
  126. ->where('create_time','<=',date('Y-m-d').' 23:59:59')
  127. ->count();
  128. $dayOrderNums6 = Db::name('orders')
  129. ->where('org_id',$this->orgId)
  130. ->where('del',0)
  131. ->where('order_mode',3)
  132. ->where('create_time','>=',date('Y-m-d').' 00:00:00')
  133. ->where('create_time','<=',date('Y-m-d').' 23:59:59')
  134. ->count();
  135. $dayOrderCount =[
  136. 'count1'=> $dayOrderNums1,
  137. 'count2'=> $dayOrderNums2,
  138. 'count3'=> $dayOrderNums3,
  139. 'count4'=> $dayOrderNums4,
  140. 'count5'=> $dayOrderNums5,
  141. 'count6'=> $dayOrderNums6,
  142. ];
  143. $this->assign('dayOrderCount',$dayOrderCount);
  144. $notice = Db::name('notice')
  145. ->where('org_id',$this->orgId)
  146. ->where('del',0)
  147. ->where('user_id',$this->userId)
  148. ->field('id,title,create_time')
  149. ->order('id desc')
  150. ->limit(2)
  151. ->select();
  152. $this->assign('notice',$notice);
  153. //常用模块
  154. $module = Db::name('user_menu')->where('user_id',$this->userId)->order('count desc')->select();
  155. $id = 500;
  156. $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
  157. $submenus = [];
  158. foreach ($menus as $k=>$v){
  159. if($v['id'] == $id){
  160. $submenus = $v['child'];
  161. break;
  162. }
  163. }
  164. $lists11 = [];
  165. foreach ($submenus as $k=>$v){
  166. // if(!$v['url']){
  167. // $v['url'] = url('Index/submenu',['id'=>$v['id'],'t'=>1]);
  168. // }
  169. $lists11[] = $v;
  170. }
  171. $this->assign('submenus',$submenus);
  172. $limit = 6;
  173. $modules = [];
  174. foreach ($module as $k=>$v){
  175. foreach ($lists11 as $kk=>$vv){
  176. if(count($modules) == $limit){
  177. continue;
  178. }
  179. if($vv['id'] == $v['menu_id']){
  180. $v['title'] = $vv['title'];
  181. $v['url'] = $vv['url'];
  182. $v['img'] = $vv['img'];
  183. $v['des'] = $vv['des'];
  184. $modules[] = $v;
  185. break;
  186. }
  187. }
  188. }
  189. $this->assign('module',$modules);
  190. $id = 500;
  191. $userEndMenu = Db::name('menu')->where('pid',$id)->where('enable',1)->where('del',0)->select();
  192. $threeMenu = model('Menu')->getMenuTree1($this->rolesId,$this->orgId,'');
  193. $this->assign('userEndMenu',$userEndMenu);
  194. $authMenuIds = array_column($threeMenu,'id');
  195. //固定模块
  196. $fixedModule = Db::name('menu')
  197. ->where('id',500)
  198. ->where('del',0)
  199. ->find();
  200. $fixedModule1 = Db::name('menu')
  201. ->where('id',1)
  202. ->where('del',0)
  203. ->find();
  204. $fixedModule2 = Db::name('menu')
  205. ->where('id',144)
  206. ->where('del',0)
  207. ->find();
  208. $fixedModule3 = Db::name('menu')
  209. ->where('id',163)
  210. ->where('del',0)
  211. ->find();
  212. $fixedModule4 = Db::name('menu')
  213. ->where('id',28)
  214. ->where('del',0)
  215. ->find();
  216. $fixedModuleAuth = $fixedModuleAuth1 = $fixedModuleAuth2 = $fixedModuleAuth3 = $fixedModuleAuth4 = 0 ;
  217. if(in_array($fixedModule['id'],$authMenuIds)){
  218. $fixedModuleAuth = 1 ;
  219. }
  220. if(in_array($fixedModule1['id'],$authMenuIds)){
  221. $fixedModuleAuth1 = 1 ;
  222. }
  223. if(in_array($fixedModule2['id'],$authMenuIds)){
  224. $fixedModuleAuth2 = 1 ;
  225. }
  226. if(in_array($fixedModule3['id'],$authMenuIds)){
  227. $fixedModuleAuth3 = 1 ;
  228. }
  229. if(in_array($fixedModule4['id'],$authMenuIds)){
  230. $fixedModuleAuth4 = 1 ;
  231. }
  232. $this->assign('fixedModule',$fixedModule);
  233. $this->assign('fixedModule1',$fixedModule1);
  234. $this->assign('fixedModule2',$fixedModule2);
  235. $this->assign('fixedModule3',$fixedModule3);
  236. $this->assign('fixedModule4',$fixedModule4);
  237. $this->assign('fixedModuleAuth',$fixedModuleAuth);
  238. $this->assign('fixedModuleAuth1',$fixedModuleAuth1);
  239. $this->assign('fixedModuleAuth2',$fixedModuleAuth2);
  240. $this->assign('fixedModuleAuth3',$fixedModuleAuth3);
  241. $this->assign('fixedModuleAuth4',$fixedModuleAuth4);
  242. // APP下载二维码
  243. $download = think_encrypt(url('h5/Index/download','',true,true));
  244. $this->assign('download',$download);
  245. // 小程序二维码
  246. $wxcode = Db::name('org')->where('id',$this->orgId)->value('wxqrcode');
  247. $this->assign('wxcode',$wxcode);
  248. // 陪护h5
  249. $phcode = think_encrypt(config('app.ph_url').'?orgId='.$this->orgId);
  250. $this->assign('phcode',$phcode);
  251. // 点餐h5
  252. $shopcode = think_encrypt(config('app.shop_url').'?orgId='.$this->orgId);
  253. $this->assign('shopcode',$shopcode);
  254. // 商城h5
  255. $xshopcode = think_encrypt(config('app.xshop_url').'?orgId='.$this->orgId);
  256. $this->assign('xshopcode',$xshopcode);
  257. return $this->fetch();
  258. }
  259. public function ocount(){
  260. $order = 0;
  261. // 判断用户是否是调度
  262. $level1 = check_is_dispatch($this->userId);
  263. $level2 = check_two_dispatch($this->userId);
  264. $level2onoff = two_dispatch_off($this->orgId);
  265. if(!$level1 && !$level2){
  266. $order = -1;
  267. }else{
  268. // 一级调度
  269. if($level1 || (!$level2onoff && $level2)){
  270. $map[] = ['org_id','=',$this->orgId];
  271. $map[] = ['del','=',0];
  272. $map[] = ['order_mode','=',1];
  273. if($level2onoff){
  274. $map[] = ['is_deal','=',0];
  275. }
  276. if(!is_admin($this->userId)){
  277. $auth = get_dispatch_auth($this->userId);
  278. if($auth){
  279. $map[] = ['work_type_mode', 'in', $auth];
  280. $where[] = ['o.work_type_mode', 'in', $auth];
  281. }else{
  282. $map[] = ['work_type_mode', '=', -1];
  283. $where[] = ['work_type_mode', '=', -1];
  284. }
  285. }
  286. $order = Db::name('orders')->where($map)->count();
  287. //$驳回的订单
  288. $where[] = ['o.del','=',0];
  289. $where[] = ['t.del','=',0];
  290. $bh = Db::name('orders')
  291. ->alias('o')
  292. ->join('todo t','t.order_id=o.id')
  293. ->where('t.todo_mode',4)
  294. ->where('t.org_id',$this->orgId)
  295. ->where('o.order_mode',4)
  296. ->where('o.org_id',$this->orgId)
  297. ->where($where)
  298. ->group('o.id')
  299. ->count();
  300. $order = $order + $bh;
  301. } else if($level2 && $level2onoff) { // 二级调度
  302. $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
  303. if(!$rolesId){
  304. $order = 0;
  305. }else{
  306. $map[] = ['b.org_id','=',$this->orgId];
  307. $map[] = ['b.del','=',0];
  308. $map[] = ['b.order_mode','=',1];
  309. $map[] = ['b.is_deal','=',1];
  310. $map[] = ['a.roles_id','=',$rolesId];
  311. if(!is_admin($this->userId)){
  312. $auth = get_dispatch_auth($this->userId);
  313. if($auth){
  314. $map[] = ['b.work_type_mode', 'in', $auth];
  315. }else{
  316. $map[] = ['b.work_type_mode', '=', -1];
  317. }
  318. }
  319. $order = Db::name('dispatch_log')
  320. ->alias('a')
  321. ->join('orders b','b.id = a.order_id')
  322. ->where($map)
  323. ->field('a.*')
  324. ->count();
  325. }
  326. }
  327. $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  328. $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  329. $endCount = $order+$complainCount+$hiddendangerCount;
  330. }
  331. $this->success('成功','',['count'=>$endCount]);
  332. }
  333. public function def(){
  334. $id = 500;
  335. $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
  336. $submenus = [];
  337. foreach ($menus as $k=>$v){
  338. if($v['id'] == $id){
  339. $submenus = $v['child'];
  340. break;
  341. }
  342. }
  343. $lists = [];
  344. foreach ($submenus as $k=>$v){
  345. if(!$v['url']){
  346. // $v['url'] = url('Index/indexsub',['id'=>$v['id'],'t'=>1]);
  347. }
  348. $lists[] = $v;
  349. }
  350. $this->assign('lists',$lists);
  351. // 获取常用模块
  352. $cys = Db::name('user_menu')
  353. ->where('user_id',$this->userId)
  354. ->order('count desc,id asc')
  355. ->select();
  356. $cys = $cys?$cys:[];
  357. $ncys = [];
  358. foreach ($cys as $k=>$v){
  359. foreach ($lists as $kk=>$vv){
  360. if(count($ncys) == 5){
  361. continue;
  362. }
  363. if($vv['id'] == $v['menu_id']){
  364. $v['title'] = $vv['title'];
  365. $v['url'] = $vv['url'];
  366. $v['img'] = $vv['img'];
  367. $v['des'] = $vv['des'];
  368. $ncys[] = $v;
  369. break;
  370. }
  371. }
  372. }
  373. $this->assign('cys',$ncys);
  374. // 自定义模块
  375. $usermenus = Db::name('user_menu_group')->where('user_id',$this->userId)->order('sort asc,id asc')->select();
  376. $usermenus = $usermenus?$usermenus:[];
  377. $groupMenuList = $usermenus;
  378. $allmenus = [];
  379. foreach ($usermenus as $k=>$v){
  380. $menus = [];
  381. if($v['menus']){
  382. $menuids = explode(',',$v['menus']);
  383. $allmenus = array_merge($allmenus,$menuids);
  384. foreach ($lists as $kk=>$vv){
  385. if(in_array($vv['id'],$menuids)){
  386. $menus[] = $vv;
  387. }
  388. }
  389. }
  390. $usermenus[$k]['menus'] = $menus;
  391. }
  392. $menus = [];
  393. foreach ($lists as $kk=>$vv){
  394. if(!$allmenus || !in_array($vv['id'],$allmenus)){
  395. $menus[] = $vv;
  396. }
  397. }
  398. $usermenus[] = [
  399. 'id' => 0,
  400. 'title' => '综合模块',
  401. 'menus' => $menus
  402. ];
  403. $arr[] = [
  404. 'id'=>0,
  405. 'title'=>'综合模块',
  406. ];
  407. $this->assign('usermenusgroup',array_merge($arr,$groupMenuList));
  408. $this->assign('usermenus',$usermenus);
  409. $menuInfo = Db::name('menu')->where('id',$id)->find();
  410. $menuTitle = $menuInfo['title'];
  411. $menuTitle1 = $menuTitle2 = '';
  412. // if($menuInfo){
  413. // $menuInfo1 = Db::name('menu')->where('pid',$menuInfo['id'])->find();
  414. // if($menuInfo1){
  415. // $menuTitle1 = $menuInfo1['title'];
  416. // $menuInfo2 = Db::name('menu')->where('pid',$menuInfo1['id'])->find();
  417. // if($menuInfo2){
  418. // $menuTitle2 = $menuInfo2['title'];
  419. // }
  420. // }
  421. // }
  422. $this->assign('menuTitle',$menuTitle);
  423. $this->assign('menuTitle1',$menuTitle1);
  424. $this->assign('menuTitle2',$menuTitle2);
  425. return $this->fetch();
  426. }
  427. public function todo(){
  428. $mode = input('mode',1);
  429. $todoList = Db::name('todo')
  430. ->where('org_id',$this->orgId)
  431. ->where('del',0)
  432. ->where('work_type_mode',$mode)
  433. ->limit(11)
  434. ->order('id desc')
  435. ->select();
  436. foreach ($todoList as $k=>$v){
  437. $todoList[$k]['work_type_mode_text'] = Db::name('work_type_mode')->where('id',$v['work_type_mode'])->value('name');
  438. $todoList[$k]['to_user_name'] = Db::name('user')->where('id',$v['to_user_id'])->value('real_name');
  439. $todoList[$k]['user_name'] = Db::name('user')->where('id',$v['create_user_id'])->value('real_name');
  440. $todoList[$k]['content'] = Db::name('orders')->where('id',$v['order_id'])->value('content');
  441. $todomode = Db::name('todo_mode')->where('id',$v['todo_mode'])->find();
  442. $todoList[$k]['todo_mode_text'] = $todomode?$todomode['in_content']:'';
  443. $todoList[$k]['todo_mode_color'] = $todomode?$todomode['color']:'';
  444. }
  445. //数据返回
  446. $totalCount = count($todoList);
  447. $totalPage = 1;
  448. $result['page'] = 1;
  449. $result['total'] = $totalPage;
  450. $result['records'] = $totalCount;
  451. $result['rows'] = $todoList;
  452. return json($result);
  453. }
  454. public function attendanceCount1(){
  455. $group = Db::name('attendance_group')
  456. ->where('del',0)
  457. ->where('org_id',$this->orgId)
  458. ->select();
  459. $groupsId = [];
  460. $groupsId2 = [];
  461. $week = date('w');
  462. foreach ($group as $k=>$v){
  463. $content = json_decode($v['content'],true);
  464. if($v['type'] == 1){
  465. foreach ($content['week'] as $kk=>$vv){
  466. if($vv['week'] == $week && $vv['class_id'] > 0){
  467. $groupsId[] = $v['id'];
  468. }
  469. }
  470. }
  471. if($v['type'] == 2){
  472. $groupClass = Db::name('attendance_group_class')
  473. ->where('group_id',$v['id'])
  474. ->where('org_id',$this->orgId)
  475. ->where('day',date('Y-m-d'))
  476. ->find();
  477. if($groupClass){
  478. $groupsId2[] = $v['id'];
  479. }
  480. }
  481. }
  482. $endGroupIds = array_unique(array_merge($groupsId,$groupsId2));
  483. $userCount = Db::name('attendance_group_user')
  484. ->where('org_id',$this->orgId)
  485. ->whereIn('group_id',$endGroupIds)
  486. ->count();
  487. $userIds = Db::name('attendance_group_user')
  488. ->where('org_id',$this->orgId)
  489. ->whereIn('group_id',$endGroupIds)
  490. ->column('user_id');
  491. $attendanceNums = 0;
  492. foreach ($userIds as $k=>$v){
  493. $attendanceRecord = Db::name('attendance_record')
  494. ->where('user_id',$v)
  495. ->where('org_id',$this->orgId)
  496. // ->where('status',1)
  497. ->where('create_time','>=',date('Y-m-d').' 00:00:00')
  498. ->where('create_time','<=',date('Y-m-d').' 23:59:59')
  499. ->select();
  500. $flag = 0;
  501. if($attendanceRecord){
  502. foreach ($attendanceRecord as $kk=>$vv){
  503. if($vv['status'] == 1){
  504. }else{
  505. $flag = 1;
  506. }
  507. }
  508. if($flag == 0){
  509. $attendanceNums +=1;
  510. }
  511. }
  512. }
  513. $attendanceNums3 = $userCount-$attendanceNums;
  514. $attendanceCount1 = [
  515. 'count1' => $userCount, //总人数
  516. 'count2' => $attendanceNums, //在职人数
  517. 'count3' => $attendanceNums3>0?$attendanceNums3:0, //缺勤人数
  518. 'bl' => $userCount>0?round($attendanceNums/$userCount,2)*100:0,
  519. 'bl2' => $userCount>0?round($attendanceNums3/$userCount,2)*100:0,
  520. ];
  521. $this->success('','',$attendanceCount1);
  522. }
  523. public function changeOrg(){
  524. if(request()->isAjax()){
  525. $id = input('id/d');
  526. $info = Db::name('org')->where('id',$id)->find();
  527. if($info['type'] != 2){
  528. $this->error('管理机构不能切换');
  529. }
  530. session('orgId',$info['id']);
  531. session('orgName',$info['name']);
  532. $this->success('切换成功');
  533. }else{
  534. $tree = model('Org')->getTreeByRoles($this->rolesId,$this->userId);
  535. $this->assign('tree',$tree);
  536. return $this->fetch();
  537. }
  538. }
  539. public function order(){
  540. // 判断用户是否是调度
  541. $level1 = check_is_dispatch($this->userId);
  542. $level2 = check_two_dispatch($this->userId);
  543. $level2onoff = two_dispatch_off($this->orgId);
  544. if(!$level1 && !$level2){
  545. $this->error('不是调度');
  546. }
  547. $order = 0;
  548. // 一级调度
  549. if($level1 || (!$level2onoff && $level2)){
  550. $map[] = ['org_id','=',$this->orgId];
  551. $map[] = ['del','=',0];
  552. $map[] = ['order_mode','=',1];
  553. if($level2onoff){
  554. $map[] = ['is_deal','=',0];
  555. }
  556. if(!is_admin($this->userId)){
  557. $auth = get_dispatch_auth($this->userId);
  558. if($auth){
  559. $map[] = ['work_type_mode', 'in', $auth];
  560. $where[] = ['o.work_type_mode', 'in', $auth];
  561. }else{
  562. $map[] = ['work_type_mode', '=', -1];
  563. $where[] = ['o.work_type_mode', '=', -1];
  564. }
  565. }
  566. $order = Db::name('orders')->where($map)->count();
  567. //$驳回的订单
  568. $where[] = ['o.del','=',0];
  569. $where[] = ['t.del','=',0];
  570. $bh = Db::name('orders')
  571. ->alias('o')
  572. ->join('todo t','t.order_id=o.id')
  573. ->where('t.todo_mode',4)
  574. ->where('t.org_id',$this->orgId)
  575. ->where('o.order_mode',4)
  576. ->where('o.org_id',$this->orgId)
  577. ->where($where)
  578. ->group('o.id')
  579. ->count();
  580. $order = $order + $bh;
  581. } else if($level2 && $level2onoff) { // 二级调度
  582. $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
  583. if(!$rolesId){
  584. $this->error('无订单');
  585. }
  586. $map[] = ['b.org_id','=',$this->orgId];
  587. $map[] = ['b.del','=',0];
  588. $map[] = ['b.order_mode','=',1];
  589. $map[] = ['b.is_deal','=',1];
  590. $map[] = ['a.roles_id','=',$rolesId];
  591. if(!is_admin($this->userId)){
  592. $auth = get_dispatch_auth($this->userId);
  593. if($auth){
  594. $map[] = ['b.work_type_mode', 'in', $auth];
  595. }else{
  596. $map[] = ['b.work_type_mode', '=', -1];
  597. }
  598. }
  599. $order = Db::name('dispatch_log')
  600. ->alias('a')
  601. ->join('orders b','b.id = a.order_id')
  602. ->where($map)
  603. ->field('a.*')
  604. ->count();
  605. }
  606. $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  607. $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  608. $endCount = $order+$complainCount+$hiddendangerCount;
  609. if(!empty($endCount)){
  610. $this->success('','',$endCount);
  611. }else{
  612. $this->error('无订单');
  613. }
  614. }
  615. public function ordersList() {
  616. $orderType = input('orderType',1);
  617. $mode = input('mode', 0);
  618. $level1 = check_is_dispatch($this->userId);
  619. $level2 = check_two_dispatch($this->userId);
  620. $turnoff = two_dispatch_off($this->orgId);
  621. if (request()->isAjax()) {
  622. //分页参数
  623. $length = input('rows', 10, 'intval'); //每页条数
  624. $page = input('page', 1, 'intval'); //第几页
  625. $start = ($page - 1) * $length; //分页开始位置
  626. //排序
  627. $sortRow = input('sidx', 'id', 'trim'); //排序列
  628. $sort = input('sord', 'desc', 'trim'); //排序方式
  629. $order = $sortRow . ' ' . $sort;
  630. if($orderType == 1){
  631. $content = input('content', '', 'trim');
  632. if ($content) {
  633. $map[] = ['content', 'like', '%' . $content . '%'];
  634. }
  635. $dep_id = input('dep_id', '', 'trim');
  636. if ($dep_id != '') {
  637. $map[] = ['dep_id', '=', $dep_id];
  638. }
  639. $order_mode = input('order_mode', 1);
  640. $map6 = [];
  641. if ($order_mode != '') {
  642. if($level1 && $turnoff && $mode != 15){ // 一级调度且二级调度开关开着,品质整改例外
  643. if ($order_mode == 1) {
  644. $map[] = ['is_deal', '=', 0];
  645. }else if ($order_mode == 4) {
  646. $map6[] = ['is_deal', '=', 1];
  647. }
  648. }
  649. if($order_mode==100){//已挂起
  650. $gq = Db::name('todo')
  651. ->where('work_type_mode',1)
  652. ->where('todo_mode',2)
  653. ->where('pause',1)
  654. ->column('order_id');
  655. if(empty($gq)){
  656. $map[] = ['id', '=', -1];
  657. }else{
  658. $map[] = ['id', 'in', $gq];
  659. }
  660. }else{
  661. $map[] = ['order_mode', '=', $order_mode];
  662. }
  663. }
  664. $b = input('start', '', 'trim');
  665. $e = input('end', '', 'trim');
  666. if ($b) {
  667. $b = date('Ymd', strtotime($b));
  668. $map[] = ['create_yyyymmdd', '>=', $b];
  669. }
  670. if ($e) {
  671. $e = date('Ymd', strtotime($e));
  672. $map[] = ['create_yyyymmdd', '<=', $e];
  673. }
  674. $map[] = ['del', '=', 0];
  675. $map[] = ['org_id', '=', $this->orgId];
  676. if($mode==-1){
  677. $map[] = ['source_type', '=', 4];
  678. }
  679. $type = input('type', '', 'trim');
  680. $oids = [];
  681. if ($type != '') {
  682. $map1[] = ['parent_id', '=', $type];
  683. $type_id = Db::name('order_type')
  684. ->where($map1)
  685. ->where('org_id', $this->orgId)
  686. ->where('enable', 1)
  687. ->column('id');
  688. if (!empty($type_id)) {
  689. $map3[] = ['type_id', 'in', $type_id];
  690. $ids = Db::name('order_repair')
  691. ->where($map3)
  692. ->column('order_id');
  693. if (!empty($ids)) {
  694. $oids = $ids;
  695. }
  696. else {
  697. $oids = [];
  698. }
  699. }
  700. else {
  701. $oids = [];
  702. }
  703. }
  704. if($level2 && $turnoff){ // 二级调度
  705. $roles_id = Db::name('user_roles')
  706. ->where('user_id', $this->userId)
  707. ->value('roles_id');
  708. $ids = Db::name('dispatch_log')
  709. ->where('roles_id', $roles_id)
  710. ->whereOr('to_user_id', $this->userId)
  711. ->column('order_id');
  712. if (empty($ids)) {
  713. $map[] = ['id', '=', -1];
  714. } else {
  715. if($type != ''){
  716. $oids = array_intersect($oids,$ids);
  717. if($oids){
  718. $map[] = ['id', 'in', $oids];
  719. }else{
  720. $map[] = ['id', '=', -1];
  721. }
  722. }else{
  723. $map[] = ['id', 'in', $ids];
  724. }
  725. }
  726. }else{
  727. if($type != ''){
  728. if($oids){
  729. $map[] = ['id', 'in', $oids];
  730. }else{
  731. $map[] = ['id', '=', 0];
  732. }
  733. }
  734. }
  735. if($mode == 15){ // 品质检查,单独处理
  736. $map[] = ['work_type_mode','=',$mode];
  737. }else{
  738. $work_type_mode = input('work_type_mode','','trim');
  739. if(!is_admin($this->userId)){
  740. $auth = get_dispatch_auth($this->userId);
  741. if($auth){
  742. $map[] = ['work_type_mode', 'in', $auth];
  743. if($mode > 0){
  744. $map[] = ['work_type_mode', '=', $mode];
  745. }else{
  746. if($work_type_mode!=''){
  747. $map[] = ['work_type_mode','=',$work_type_mode];
  748. }
  749. }
  750. }else{
  751. $map[] = ['work_type_mode', '=', -1];
  752. }
  753. }else{
  754. if($mode > 0){
  755. $map[] = ['work_type_mode', '=', $mode];
  756. }else{
  757. if($work_type_mode!=''){
  758. $map[] = ['work_type_mode','=',$work_type_mode];
  759. }
  760. }
  761. }
  762. }
  763. $map = empty($map) ? true : $map;
  764. //数据查询
  765. $lists = db('orders')->where($map)
  766. ->whereOr($map6)
  767. ->limit($start, $length)->order($order)->select();
  768. foreach ($lists as $k => $v) {
  769. $lists[$k] = model('orders')->formatOrder($v);
  770. if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
  771. $lists[$k]['order_mode_text'] = '已派发';
  772. }
  773. $lists[$k]['bh_nums'] = Db::name('todo')->where('order_id',$v['id'])->where('del',0)->where('todo_mode',4)->count();
  774. $gq = Db::name('todo')
  775. ->where('order_id',$v['id'])
  776. ->where('work_type_mode',1)
  777. ->where('todo_mode',2)
  778. ->where('pause',1)
  779. ->find();
  780. $lists[$k]['gq'] = $gq?'存在挂起':'';
  781. }
  782. //数据返回
  783. $totalCount = db('orders')->where($map)->count();
  784. }elseif($orderType == 2){
  785. $map[] = ['del','=',0];
  786. $map[] = ['org_id','=',$this->orgId];
  787. $hour = (new Config())->getConfig('org_complain_hour',$this->orgId);
  788. $hour = $hour>0?$hour:0;
  789. $endTime = date('Y-m-d H:i:s',time() - $hour*60*60);
  790. $type = input('type/d',0);
  791. if($hour > 0 && $type == 1){
  792. $map[] = ['create_time','<',$endTime];
  793. $map[] = ['status','=',0];
  794. }
  795. $from = input('from', '', 'trim');
  796. if ($from!='') {
  797. $map[] = ['from','=',$from];
  798. }
  799. $map[] = ['status','=',0];
  800. $map[] = ['order_id','=',0];
  801. $map= empty($map) ? true: $map;
  802. //数据查询
  803. $lists = db('complain')->where($map)
  804. ->limit($start,$length)->order($order)->select();
  805. foreach ($lists as $k=>$v){
  806. $lists[$k]['depName'] = Db::name('dep')
  807. ->where('id',$v['dep_id'])
  808. ->value('title');
  809. // $lists[$k]['fromName'] = model('Complain')->from[$v['from']];
  810. $lists[$k]['fromName'] = '';
  811. if($v['order_id'] > 0 && $v['bus_type'] != 0){
  812. if($v['to_from']){
  813. $lists[$k]['fromName'] = '一键呼叫';
  814. }else{
  815. $lists[$k]['fromName'] = '隐患';
  816. }
  817. }
  818. $lists[$k]['worktypemode'] = '';
  819. if($v['order_id'] > 0 && in_array($v['bus_type'],[0,1])){
  820. $worktype = Db::name('orders')
  821. ->alias('o')
  822. ->join('work_type_mode w','o.work_type_mode = w.id')
  823. ->where('o.id',$v['order_id'])
  824. ->value('w.name');
  825. $lists[$k]['worktypemode'] = $worktype?$worktype:'';
  826. }
  827. if($v['hide'] == 1){
  828. $lists[$k]['realName'] = '匿名';
  829. }else{
  830. $lists[$k]['realName'] = Db::name('user')
  831. ->where('id',$v['create_user_id'])
  832. ->value('real_name');
  833. }
  834. $orderMode = 0;
  835. if($v['order_id'] > 0){
  836. $orderMode = Db::name('orders')->where('id',$v['order_id'])->value('order_mode');
  837. }
  838. $lists[$k]['statusTxt'] = model('Complain')->formatStatus($v['status'],$v['order_id'],$v['id']);
  839. $lists[$k]['order_mode'] = $orderMode;
  840. if($v['create_time'] < $endTime && $v['status']==0){
  841. $lists[$k]['statusTxt'] = $lists[$k]['statusTxt'].'<span style="color:red;">(已超时)</span>';
  842. }
  843. }
  844. //数据返回
  845. $totalCount = db('complain')->where($map)->count();
  846. }elseif ($orderType == 3){
  847. $map[] = ['del','=',0];
  848. $map[] = ['org_id','=',$this->orgId];
  849. $map[] = ['status','=',0];
  850. $map[] = ['order_id','=',0];
  851. $from = input('from', '', 'trim');
  852. if ($from!='') {
  853. $map[] = ['from','=',$from];
  854. }
  855. $map= empty($map) ? true: $map;
  856. //数据查询
  857. $lists = db('hiddendanger')->where($map)
  858. ->limit($start,$length)->order($order)->select();
  859. foreach ($lists as $k=>$v){
  860. $lists[$k]['depName'] = Db::name('dep')
  861. ->where('id',$v['dep_id'])
  862. ->value('title');
  863. // $lists[$k]['fromName'] = model('Hiddendanger')->from[$v['from']];
  864. $lists[$k]['fromName'] = '';
  865. if($v['order_id'] > 0 && $v['bus_type'] != 0){
  866. if($v['to_from']){
  867. $lists[$k]['fromName'] = '一键呼叫';
  868. }else{
  869. $lists[$k]['fromName'] = '投诉';
  870. }
  871. }
  872. $lists[$k]['worktypemode'] = '';
  873. if($v['order_id'] > 0 && in_array($v['bus_type'],[0,1])){
  874. $worktype = Db::name('orders')
  875. ->alias('o')
  876. ->join('work_type_mode w','o.work_type_mode = w.id')
  877. ->where('o.id',$v['order_id'])
  878. ->value('w.name');
  879. $lists[$k]['worktypemode'] = $worktype?$worktype:'';
  880. }
  881. $lists[$k]['realName'] = Db::name('user')
  882. ->where('id',$v['create_user_id'])
  883. ->value('real_name');
  884. // $lists[$k]['statusTxt'] = $v['status']==1?'已处理':"未处理";
  885. $orderMode = 0;
  886. if($v['order_id'] > 0){
  887. $orderMode = Db::name('orders')->where('id',$v['order_id'])->value('order_mode');
  888. }
  889. $lists[$k]['statusTxt'] = model('Hiddendanger')->formatStatus($v['status'],$v['order_id'],$v['id']);
  890. $lists[$k]['order_mode'] = $orderMode;
  891. }
  892. //数据返回
  893. $totalCount = db('hiddendanger')->where($map)->count();
  894. }elseif($orderType == 4){
  895. $order_mode = input('order_mode', 4);
  896. $map6 = [];
  897. if ($order_mode != '') {
  898. if($level1 && $turnoff && $mode != 15){ // 一级调度且二级调度开关开着,品质整改例外
  899. if ($order_mode == 1) {
  900. $map[] = ['is_deal', '=', 0];
  901. }else if ($order_mode == 4) {
  902. $map6[] = ['is_deal', '=', 1];
  903. }
  904. }
  905. if($order_mode==100){//已挂起
  906. $gq = Db::name('todo')
  907. ->where('work_type_mode',1)
  908. ->where('todo_mode',2)
  909. ->where('pause',1)
  910. ->column('order_id');
  911. if(empty($gq)){
  912. $map[] = ['id', '=', -1];
  913. }else{
  914. $map[] = ['id', 'in', $gq];
  915. }
  916. }else{
  917. $map[] = ['order_mode', '=', $order_mode];
  918. }
  919. }
  920. $map[] = ['del', '=', 0];
  921. $map[] = ['org_id', '=', $this->orgId];
  922. if($mode==-1){
  923. $map[] = ['source_type', '=', 4];
  924. }
  925. $type = input('type', '', 'trim');
  926. $oids = [];
  927. if ($type != '') {
  928. $map1[] = ['parent_id', '=', $type];
  929. $type_id = Db::name('order_type')
  930. ->where($map1)
  931. ->where('org_id', $this->orgId)
  932. ->where('enable', 1)
  933. ->column('id');
  934. if (!empty($type_id)) {
  935. $map3[] = ['type_id', 'in', $type_id];
  936. $ids = Db::name('order_repair')
  937. ->where($map3)
  938. ->column('order_id');
  939. if (!empty($ids)) {
  940. $oids = $ids;
  941. }
  942. else {
  943. $oids = [];
  944. }
  945. }
  946. else {
  947. $oids = [];
  948. }
  949. }
  950. if($level2 && $turnoff){ // 二级调度
  951. $roles_id = Db::name('user_roles')
  952. ->where('user_id', $this->userId)
  953. ->value('roles_id');
  954. $ids = Db::name('dispatch_log')
  955. ->where('roles_id', $roles_id)
  956. ->whereOr('to_user_id', $this->userId)
  957. ->column('order_id');
  958. if (empty($ids)) {
  959. $map[] = ['id', '=', -1];
  960. } else {
  961. if($type != ''){
  962. $oids = array_intersect($oids,$ids);
  963. if($oids){
  964. $map[] = ['id', 'in', $oids];
  965. }else{
  966. $map[] = ['id', '=', -1];
  967. }
  968. }else{
  969. $map[] = ['id', 'in', $ids];
  970. }
  971. }
  972. }else{
  973. if($type != ''){
  974. if($oids){
  975. $map[] = ['id', 'in', $oids];
  976. }else{
  977. $map[] = ['id', '=', 0];
  978. }
  979. }
  980. }
  981. if($mode == 15){ // 品质检查,单独处理
  982. $map[] = ['work_type_mode','=',$mode];
  983. }else{
  984. $work_type_mode = input('work_type_mode','','trim');
  985. if(!is_admin($this->userId)){
  986. $auth = get_dispatch_auth($this->userId);
  987. if($auth){
  988. $map[] = ['work_type_mode', 'in', $auth];
  989. if($mode > 0){
  990. $map[] = ['work_type_mode', '=', $mode];
  991. }else{
  992. if($work_type_mode!=''){
  993. $map[] = ['work_type_mode','=',$work_type_mode];
  994. }
  995. }
  996. }else{
  997. $map[] = ['work_type_mode', '=', -1];
  998. }
  999. }else{
  1000. if($mode > 0){
  1001. $map[] = ['work_type_mode', '=', $mode];
  1002. }else{
  1003. if($work_type_mode!=''){
  1004. $map[] = ['work_type_mode','=',$work_type_mode];
  1005. }
  1006. }
  1007. }
  1008. }
  1009. $orderIds = Db::name('todo')
  1010. ->where('todo_mode',4)
  1011. ->where('org_id',$this->orgId)
  1012. ->where('del',0)
  1013. ->group('order_id')
  1014. ->column('order_id');
  1015. $map[] = ['id','in',$orderIds];
  1016. $map = empty($map) ? true : $map;
  1017. //数据查询
  1018. $lists = db('orders')
  1019. ->where($map)
  1020. // ->whereOr($map6)
  1021. ->limit($start, $length)
  1022. ->order($order)
  1023. ->select();
  1024. foreach ($lists as $k => $v) {
  1025. $lists[$k] = model('orders')->formatOrder($v);
  1026. if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
  1027. $lists[$k]['order_mode_text'] = '已派发';
  1028. }
  1029. $lists[$k]['bh_nums'] = Db::name('todo')->where('order_id',$v['id'])->where('del',0)->where('todo_mode',4)->count();
  1030. $gq = Db::name('todo')
  1031. ->where('order_id',$v['id'])
  1032. ->where('work_type_mode',1)
  1033. ->where('todo_mode',2)
  1034. ->where('pause',1)
  1035. ->find();
  1036. $lists[$k]['gq'] = $gq?'存在挂起':'';
  1037. }
  1038. //数据返回
  1039. $totalCount = db('orders')->where($map)->count();
  1040. }
  1041. $totalPage = ceil($totalCount / $length);
  1042. $result['page'] = $page;
  1043. $result['total'] = $totalPage;
  1044. $result['records'] = $totalCount;
  1045. $result['rows'] = $lists;
  1046. return json($result);
  1047. }
  1048. else {
  1049. if($mode >0){
  1050. $mode_name = $this->getTableField('work_type_mode', ['id' => $mode], 'name');
  1051. }else{
  1052. $mode_name = '';
  1053. }
  1054. $auths = [1,2,3,4,15,0];
  1055. if(!is_admin($this->userId)){
  1056. $auth = get_dispatch_auth($this->userId);
  1057. if($auth){
  1058. $auths = array_intersect($auths,$auth);
  1059. if($mode > 0){
  1060. $auths = array_intersect($auths,[$mode]);
  1061. }
  1062. }else{
  1063. $auths = [];
  1064. }
  1065. }
  1066. $this->assign('auths',$auths);
  1067. $dep_list = (new \app\common\model\Dep())->getList();
  1068. $order_type = (new \app\common\model\OrderType())->list();
  1069. $order_mode = Db::name('order_mode')
  1070. ->select();
  1071. $this->assign('dep_list', $dep_list);
  1072. $this->assign('order_type_list', $order_type);
  1073. $this->assign('m_name', $mode_name);
  1074. $this->assign('mode', $mode);
  1075. $this->assign('order_mode_list', $order_mode);
  1076. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  1077. $this->assign('orderType',$orderType);
  1078. return $this->fetch('index/orders');
  1079. }
  1080. }
  1081. //调度查看订单详情
  1082. public function ordersDetail2($id) {
  1083. if (!$id) {
  1084. $this->error('参数错误');
  1085. }
  1086. $type = input('type/d',0);
  1087. $this->assign('type', $type);
  1088. $order = Db::name('orders')->where(['id' => $id])->find();
  1089. $order = model('Orders')->formatOrder($order, 1);
  1090. $order['images'] = !empty($order['images']) ? explode(',', $order['images']) : '';
  1091. $this->assign('info', $order);
  1092. $workTypeName = $this->getTableField('work_type_mode', ['id' => $order['work_type_mode']], 'name');
  1093. $this->assign('meta_title', $workTypeName . '订单详情');
  1094. $level2 = check_two_dispatch($this->userId);
  1095. $level1 = check_is_dispatch($this->userId);
  1096. $turnoff = two_dispatch_off($this->orgId);
  1097. $this->assign('level1', $level1);
  1098. $this->assign('level2', $level2);
  1099. $this->assign('turnoff', $turnoff);
  1100. $this->assign('dispatch_type', $level2);
  1101. return $this->fetch();
  1102. }
  1103. public function searchMenu(){
  1104. $menuName = input('menu_name');
  1105. if($menuName){
  1106. $map[] = ['title','like','%'.$menuName.'%'];
  1107. }
  1108. $map[] = ['del','=',0];
  1109. $map[] = ['enable','=',1];
  1110. $map[] = ['pid','=',500];
  1111. $list = Db::name('menu')->where($map)->select();
  1112. $this->success('','',$list);
  1113. }
  1114. public function indexsub(){
  1115. $curmenu = input('curmenu',500);
  1116. $menuId = input('menuId',0);
  1117. $this->assign('curmenu',$curmenu);
  1118. $this->assign('menuId',$menuId);
  1119. $menuInfo = Db::name('menu')->where('id',$curmenu)->find();
  1120. $menuTitle = $menuInfo['title'];
  1121. $menuTitle1 = $menuTitle2 = '';
  1122. if($curmenu != 500){
  1123. $menuInfo1 = Db::name('menu')->where('pid',$menuInfo['id'])->find();
  1124. if($menuInfo1){
  1125. $menuTitle1 = $menuInfo1['title'];
  1126. $menuInfo2 = Db::name('menu')->where('pid',$menuInfo1['id'])->where('del',0)->where('enable',1)->where('is_btn',0)->order(['sort'=>'asc','id'=>'asc'])->find();
  1127. if($menuInfo2){
  1128. $menuTitle2 = $menuInfo2['title'];
  1129. }
  1130. }
  1131. if($menuId > 0){
  1132. $menuInfo1 = Db::name('menu')->where('id',$menuId)->find();
  1133. if($menuInfo1){
  1134. $menuTitle1 = $menuInfo1['title'];
  1135. $menuInfo2 = Db::name('menu')->where('pid',$menuInfo1['id'])->where('is_btn',0)->where('del',0)->where('enable',1)->order(['sort'=>'asc','id'=>'asc'])->find();
  1136. if($menuInfo2){
  1137. $menuTitle2 = $menuInfo2['title'];
  1138. }
  1139. }
  1140. }
  1141. }
  1142. $this->assign('menuTitle',$menuTitle);
  1143. $this->assign('menuTitle1',$menuTitle1);
  1144. $this->assign('menuTitle2',$menuTitle2);
  1145. $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
  1146. $this->assign('menus',$menus);
  1147. $userInfo = Db::name('user')
  1148. ->where('id',$this->userId)
  1149. ->find();
  1150. $this->assign('userInfo',$userInfo);
  1151. // 判断用户是否是调度
  1152. $isDispatch = 0;
  1153. if(check_is_dispatch($this->userId) || check_two_dispatch($this->userId)){
  1154. $isDispatch = 1;
  1155. }
  1156. $this->assign('isDispatch',$isDispatch);
  1157. $order = 0;
  1158. // 判断用户是否是调度
  1159. $level1 = check_is_dispatch($this->userId);
  1160. $level2 = check_two_dispatch($this->userId);
  1161. $level2onoff = two_dispatch_off($this->orgId);
  1162. if(!$level1 && !$level2){
  1163. $order = -1;
  1164. }else{
  1165. // 一级调度
  1166. if($level1 || (!$level2onoff && $level2)){
  1167. $map[] = ['org_id','=',$this->orgId];
  1168. $map[] = ['del','=',0];
  1169. $map[] = ['order_mode','=',1];
  1170. if($level2onoff){
  1171. $map[] = ['is_deal','=',0];
  1172. }
  1173. if(!is_admin($this->userId)){
  1174. $auth = get_dispatch_auth($this->userId);
  1175. if($auth){
  1176. $map[] = ['work_type_mode', 'in', $auth];
  1177. $where[] = ['o.work_type_mode', 'in', $auth];
  1178. }else{
  1179. $map[] = ['work_type_mode', '=', -1];
  1180. $where[] = ['o.work_type_mode', '=', -1];
  1181. }
  1182. }
  1183. $order = Db::name('orders')->where($map)->count();
  1184. //$驳回的订单
  1185. $where[] = ['o.del','=',0];
  1186. $where[] = ['t.del','=',0];
  1187. $bh = Db::name('orders')
  1188. ->alias('o')
  1189. ->join('todo t','t.order_id=o.id')
  1190. ->where('t.todo_mode',4)
  1191. ->where('t.org_id',$this->orgId)
  1192. ->where('o.order_mode',4)
  1193. ->where('o.org_id',$this->orgId)
  1194. ->where($where)
  1195. ->group('o.id')
  1196. ->count();
  1197. $order = $order + $bh;
  1198. } else if($level2 && $level2onoff) { // 二级调度
  1199. $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
  1200. if(!$rolesId){
  1201. $order = 0;
  1202. }else{
  1203. $map[] = ['b.org_id','=',$this->orgId];
  1204. $map[] = ['b.del','=',0];
  1205. $map[] = ['b.order_mode','=',1];
  1206. $map[] = ['b.is_deal','=',1];
  1207. $map[] = ['a.roles_id','=',$rolesId];
  1208. if(!is_admin($this->userId)){
  1209. $auth = get_dispatch_auth($this->userId);
  1210. if($auth){
  1211. $map[] = ['b.work_type_mode', 'in', $auth];
  1212. }else{
  1213. $map[] = ['b.work_type_mode', '=', -1];
  1214. }
  1215. }
  1216. $order = Db::name('dispatch_log')
  1217. ->alias('a')
  1218. ->join('orders b','b.id = a.order_id')
  1219. ->where($map)
  1220. ->field('a.*')
  1221. ->count();
  1222. }
  1223. }
  1224. }
  1225. $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  1226. $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  1227. $endCount = $order+$complainCount+$hiddendangerCount;
  1228. $this->assign('orderNums',$endCount);
  1229. return $this->fetch();
  1230. }
  1231. public function indexsub1(){
  1232. $curmenu = input('curmenu',500);
  1233. $menuId = input('menuId',0);
  1234. $ct = input('ct',0);
  1235. $this->assign('curmenu',$curmenu);
  1236. $this->assign('menuId',$menuId);
  1237. $this->assign('ct',$ct);
  1238. $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
  1239. $this->assign('menus',$menus);
  1240. $userInfo = Db::name('user')
  1241. ->where('id',$this->userId)
  1242. ->find();
  1243. $this->assign('userInfo',$userInfo);
  1244. $menuInfo = Db::name('menu')->where('id',$curmenu)->find();
  1245. $menuTitle = $menuInfo['title'];
  1246. $menuTitle1 = $menuTitle2 = '';
  1247. if($curmenu == 500){
  1248. $menuInfo1 = Db::name('menu')->where('id',$menuId)->find();
  1249. if($menuInfo1){
  1250. $menuTitle1 = $menuInfo1['title'];
  1251. $menuInfo2 = Db::name('menu')->where('pid',$menuInfo1['id'])->where('del',0)->where('enable',1)->where('is_btn',0)->order(['sort'=>'asc','id'=>'asc'])->find();
  1252. if($menuInfo2){
  1253. $menuTitle2 = $menuInfo2['title'];
  1254. }
  1255. }
  1256. }
  1257. $this->assign('menuTitle',$menuTitle);
  1258. $this->assign('menuTitle1',$menuTitle1);
  1259. $this->assign('menuTitle2',$menuTitle2);
  1260. // 判断用户是否是调度
  1261. $isDispatch = 0;
  1262. if(check_is_dispatch($this->userId) || check_two_dispatch($this->userId)){
  1263. $isDispatch = 1;
  1264. }
  1265. $this->assign('isDispatch',$isDispatch);
  1266. $order = 0;
  1267. // 判断用户是否是调度
  1268. $level1 = check_is_dispatch($this->userId);
  1269. $level2 = check_two_dispatch($this->userId);
  1270. $level2onoff = two_dispatch_off($this->orgId);
  1271. if(!$level1 && !$level2){
  1272. $order = -1;
  1273. }else{
  1274. // 一级调度
  1275. if($level1 || (!$level2onoff && $level2)){
  1276. $map[] = ['org_id','=',$this->orgId];
  1277. $map[] = ['del','=',0];
  1278. $map[] = ['order_mode','=',1];
  1279. if($level2onoff){
  1280. $map[] = ['is_deal','=',0];
  1281. }
  1282. if(!is_admin($this->userId)){
  1283. $auth = get_dispatch_auth($this->userId);
  1284. if($auth){
  1285. $map[] = ['work_type_mode', 'in', $auth];
  1286. $where[] = ['o.work_type_mode', 'in', $auth];
  1287. }else{
  1288. $map[] = ['work_type_mode', '=', -1];
  1289. $where[] = ['o.work_type_mode', '=', -1];
  1290. }
  1291. }
  1292. $order = Db::name('orders')->where($map)->count();
  1293. //$驳回的订单
  1294. $where[] = ['o.del','=',0];
  1295. $where[] = ['t.del','=',0];
  1296. $bh = Db::name('orders')
  1297. ->alias('o')
  1298. ->join('todo t','t.order_id=o.id')
  1299. ->where('t.todo_mode',4)
  1300. ->where('t.org_id',$this->orgId)
  1301. ->where('o.order_mode',4)
  1302. ->where('o.org_id',$this->orgId)
  1303. ->where($where)
  1304. ->group('o.id')
  1305. ->count();
  1306. $order = $order + $bh;
  1307. } else if($level2 && $level2onoff) { // 二级调度
  1308. $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
  1309. if(!$rolesId){
  1310. $order = 0;
  1311. }else{
  1312. $map[] = ['b.org_id','=',$this->orgId];
  1313. $map[] = ['b.del','=',0];
  1314. $map[] = ['b.order_mode','=',1];
  1315. $map[] = ['b.is_deal','=',1];
  1316. $map[] = ['a.roles_id','=',$rolesId];
  1317. if(!is_admin($this->userId)){
  1318. $auth = get_dispatch_auth($this->userId);
  1319. if($auth){
  1320. $map[] = ['b.work_type_mode', 'in', $auth];
  1321. }else{
  1322. $map[] = ['b.work_type_mode', '=', -1];
  1323. }
  1324. }
  1325. $order = Db::name('dispatch_log')
  1326. ->alias('a')
  1327. ->join('orders b','b.id = a.order_id')
  1328. ->where($map)
  1329. ->field('a.*')
  1330. ->count();
  1331. }
  1332. }
  1333. }
  1334. $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  1335. $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  1336. $endCount = $order+$complainCount+$hiddendangerCount;
  1337. $this->assign('orderNums',$endCount);
  1338. $id = 500;
  1339. $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
  1340. $submenus = [];
  1341. foreach ($menus as $k=>$v){
  1342. if($v['id'] == $id){
  1343. $submenus = $v['child'];
  1344. break;
  1345. }
  1346. }
  1347. $this->assign('submenus',$submenus);
  1348. return $this->fetch();
  1349. }
  1350. public function menugroup($id = 0){
  1351. if(request()->isPost()){
  1352. $res = model('UserMenuGroup')->updates($this->userId);
  1353. if($res){
  1354. $this->success('操作成功');
  1355. }else{
  1356. $this->error(model('UserMenuGroup')->getError());
  1357. }
  1358. }else{
  1359. if($id){
  1360. $info = db('user_menu_group')->where('id',$id)->find();
  1361. if($info){
  1362. $info['menus'] = $info['menus']?explode(',',$info['menus']):[];
  1363. }
  1364. $this->assign('info',$info);
  1365. }
  1366. $id = 500;
  1367. $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
  1368. $submenus = [];
  1369. foreach ($menus as $k=>$v){
  1370. if($v['id'] == $id){
  1371. $submenus = $v['child'];
  1372. break;
  1373. }
  1374. }
  1375. $this->assign('submenus',$submenus);
  1376. return $this->fetch();
  1377. }
  1378. }
  1379. public function menugroupdel(){
  1380. $id = input('id',0);
  1381. $ret = Db::name('user_menu_group')->where('id',$id)->where('user_id',$this->userId)->delete();
  1382. if($ret){
  1383. $this->success('操作成功');
  1384. }else{
  1385. $this->error('操作失败');
  1386. }
  1387. }
  1388. public function def2(){
  1389. $curmenu = input('curmenu',500);
  1390. $this->assign('curmenu',$curmenu);
  1391. $menuId = input('menuId',0);
  1392. $this->assign('menuId',$menuId);
  1393. $menuInfo = Db::name('menu')->where('id',$curmenu)->find();
  1394. $menuTitle = $menuInfo['title'];
  1395. $menuTitle1 = $menuTitle2 = '';
  1396. if($curmenu == 500){
  1397. $menuInfo1 = Db::name('menu')->where('pid',$menuInfo['id'])->find();
  1398. if($menuInfo1){
  1399. $menuTitle1 = $menuInfo1['title'];
  1400. $menuInfo2 = Db::name('menu')->where('pid',$menuInfo1['id'])->where('is_btn',0)->order(['sort'=>'asc','id'=>'asc'])->find();
  1401. if($menuInfo2){
  1402. $menuTitle2 = $menuInfo2['title'];
  1403. }
  1404. }
  1405. if($menuId > 0){
  1406. $menuInfo1 = Db::name('menu')->where('id',$menuId)->find();
  1407. if($menuInfo1){
  1408. $menuTitle1 = $menuInfo1['title'];
  1409. $menuInfo2 = Db::name('menu')->where('pid',$menuInfo1['id'])->where('is_btn',0)->where('del',0)->where('enable',1)->order(['sort'=>'asc','id'=>'asc'])->find();
  1410. if($menuInfo2){
  1411. $menuTitle2 = $menuInfo2['title'];
  1412. }
  1413. }
  1414. }
  1415. }
  1416. $this->assign('menuTitle',$menuTitle);
  1417. $this->assign('menuTitle1',$menuTitle1);
  1418. $this->assign('menuTitle2',$menuTitle2);
  1419. $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
  1420. $this->assign('menus',$menus);
  1421. $userInfo = Db::name('user')
  1422. ->where('id',$this->userId)
  1423. ->find();
  1424. $this->assign('userInfo',$userInfo);
  1425. // 判断用户是否是调度
  1426. $isDispatch = 0;
  1427. if(check_is_dispatch($this->userId) || check_two_dispatch($this->userId)){
  1428. $isDispatch = 1;
  1429. }
  1430. $this->assign('isDispatch',$isDispatch);
  1431. $order = 0;
  1432. // 判断用户是否是调度
  1433. $level1 = check_is_dispatch($this->userId);
  1434. $level2 = check_two_dispatch($this->userId);
  1435. $level2onoff = two_dispatch_off($this->orgId);
  1436. if(!$level1 && !$level2){
  1437. $order = -1;
  1438. }else{
  1439. // 一级调度
  1440. if($level1 || (!$level2onoff && $level2)){
  1441. $map[] = ['org_id','=',$this->orgId];
  1442. $map[] = ['del','=',0];
  1443. $map[] = ['order_mode','=',1];
  1444. if($level2onoff){
  1445. $map[] = ['is_deal','=',0];
  1446. }
  1447. if(!is_admin($this->userId)){
  1448. $auth = get_dispatch_auth($this->userId);
  1449. if($auth){
  1450. $map[] = ['work_type_mode', 'in', $auth];
  1451. $where[] = ['o.work_type_mode', 'in', $auth];
  1452. }else{
  1453. $map[] = ['work_type_mode', '=', -1];
  1454. $where[] = ['o.work_type_mode', '=', -1];
  1455. }
  1456. }
  1457. $order = Db::name('orders')->where($map)->count();
  1458. //$驳回的订单
  1459. $where[] = ['o.del','=',0];
  1460. $where[] = ['t.del','=',0];
  1461. $bh = Db::name('orders')
  1462. ->alias('o')
  1463. ->join('todo t','t.order_id=o.id')
  1464. ->where('t.todo_mode',4)
  1465. ->where('t.org_id',$this->orgId)
  1466. ->where('o.order_mode',4)
  1467. ->where('o.org_id',$this->orgId)
  1468. ->where($where)
  1469. ->group('o.id')
  1470. ->count();
  1471. $order = $order + $bh;
  1472. } else if($level2 && $level2onoff) { // 二级调度
  1473. $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
  1474. if(!$rolesId){
  1475. $order = 0;
  1476. }else{
  1477. $map[] = ['b.org_id','=',$this->orgId];
  1478. $map[] = ['b.del','=',0];
  1479. $map[] = ['b.order_mode','=',1];
  1480. $map[] = ['b.is_deal','=',1];
  1481. $map[] = ['a.roles_id','=',$rolesId];
  1482. if(!is_admin($this->userId)){
  1483. $auth = get_dispatch_auth($this->userId);
  1484. if($auth){
  1485. $map[] = ['b.work_type_mode', 'in', $auth];
  1486. }else{
  1487. $map[] = ['b.work_type_mode', '=', -1];
  1488. }
  1489. }
  1490. $order = Db::name('dispatch_log')
  1491. ->alias('a')
  1492. ->join('orders b','b.id = a.order_id')
  1493. ->where($map)
  1494. ->field('a.*')
  1495. ->count();
  1496. }
  1497. }
  1498. }
  1499. $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  1500. $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
  1501. $endCount = $order+$complainCount+$hiddendangerCount;
  1502. $this->assign('orderNums',$endCount);
  1503. return $this->fetch();
  1504. }
  1505. public function umenu(){
  1506. $id = input('id/d',0);
  1507. $info = Db::name('user_menu')->where('menu_id',$id)->where('user_id',$this->userId)->find();
  1508. if($info){
  1509. Db::name('user_menu')->where('id',$info['id'])->setInc('count',1);
  1510. }else{
  1511. Db::name('user_menu')->insert([
  1512. 'user_id' => $this->userId,
  1513. 'menu_id' => $id,
  1514. 'count' => 1
  1515. ]);
  1516. }
  1517. $this->success('操作成功');
  1518. }
  1519. }