Index.php 64 KB

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