Orders.php 124 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947
  1. <?php
  2. namespace app\admin\controller;
  3. use app\common\model\Config;
  4. use app\common\util\AppMsg;
  5. use Overtrue\Pinyin\Pinyin;
  6. use think\App;
  7. use think\Db;
  8. use think\Exception;
  9. class Orders extends Auth {
  10. public function __construct(App $app = null) {
  11. parent::__construct($app);
  12. $this->model = new \app\common\model\Orders();
  13. $this->table = $this->model->table;
  14. }
  15. //用户订单列表
  16. public function selfIndex() {
  17. $mode = input('mode', 1);
  18. if (request()->isAjax()) {
  19. //分页参数
  20. $length = input('rows', 10, 'intval'); //每页条数
  21. $page = input('page', 1, 'intval'); //第几页
  22. $start = ($page - 1) * $length; //分页开始位置
  23. //排序
  24. $sortRow = input('sidx', 'a.id', 'trim'); //排序列
  25. $sort = input('sord', 'desc', 'trim'); //排序方式
  26. $order = $sortRow . ' ' . $sort;
  27. $map[] = ['a.del', '=', 0];
  28. $map[] = ['a.org_id', '=', $this->orgId];
  29. $order_mode = input('order_mode', '', 'trim');
  30. if ($order_mode != '') {
  31. $map[] = ['a.order_mode', '=', $order_mode];
  32. }
  33. if($mode >0){
  34. $map[] = ['a.work_type_mode', '=', $mode];
  35. }else{
  36. $map[] = ['a.source_type', '=', 4];
  37. }
  38. $sn = input('sn', '', 'trim');
  39. if ($sn) {
  40. $map[] = ['a.sn', 'like', '%' . $sn . '%'];
  41. }
  42. if (!is_admin($this->userId)) {
  43. $map[] = ['a.user_id', '=', $this->userId];
  44. }
  45. $priority = input('priority', '', 'trim');
  46. if($priority !=''){
  47. $map[] = ['b.priority', '=',$priority];
  48. }
  49. $map = empty($map) ? true : $map;
  50. //数据查询
  51. $lists = db($this->table)
  52. ->alias('a')
  53. ->leftJoin('order_convey b','a.id=b.order_id')
  54. ->where($map)
  55. ->field('a.*,b.priority')
  56. ->limit($start, $length)
  57. ->order($order)
  58. ->select();
  59. foreach ($lists as $k => $v) {
  60. $lists[$k] = $this->model->formatOrder($v);
  61. $lists[$k]['priority'] = isset($this->model->priority[$v['priority']])?$this->model->priority[$v['priority']]:"";
  62. }
  63. //数据返回
  64. $totalCount = db($this->table)
  65. ->alias('a')
  66. ->leftJoin('order_convey b','a.id=b.order_id')
  67. ->where($map)->count();
  68. $totalPage = ceil($totalCount / $length);
  69. $result['page'] = $page;
  70. $result['total'] = $totalPage;
  71. $result['records'] = $totalCount;
  72. $result['rows'] = $lists;
  73. return json($result);
  74. }
  75. else {
  76. $mode_name = $this->getTableField('work_type_mode', ['id' => $mode], 'name');
  77. if($mode==4){
  78. $mode_name = '应急';
  79. }
  80. $this->assign('m_name', $mode_name);
  81. $this->assign('mode', $mode);
  82. $this->assign('priority', model("Orders")->priority);
  83. $order_mode = Db::name('order_mode')->select();
  84. $this->assign('order_mode_list', $order_mode);
  85. $tsDh = model('Config')->getConfig('org_config_ts',$this->orgId);
  86. $this->assign('tsDh',$tsDh);
  87. if ($mode == 1) {
  88. return $this->fetch('selfIndex1');
  89. }
  90. else {
  91. if ($mode == 3) {
  92. return $this->fetch('selfIndex3');
  93. }
  94. else {
  95. return $this->fetch('selfIndex');
  96. }
  97. }
  98. }
  99. }
  100. //用户添加订单
  101. public function selfAdd($mode = 1) {
  102. if (request()->isPost()) {
  103. $data = request()->post();
  104. $data['user_id'] = $this->userId;
  105. $data['org_id'] = $this->orgId;
  106. $data['work_type_mode'] = $mode;
  107. $data['images'] = isset($data['images']) && !empty($data['images']) ? implode(',', $data['images']) : '';
  108. $res = $this->model->addSave($data);
  109. if ($res) {
  110. $this->success('操作成功');
  111. }
  112. else {
  113. $this->error($this->model->getError());
  114. }
  115. }
  116. else {
  117. $dep = $this->getTableField('user_dep', ['user_id' => $this->userId], 'dep_id');
  118. $depList = (new \app\common\model\Dep())->getList();
  119. $this->assign('dep_id', $dep);
  120. $this->assign('dep_list', $depList);
  121. $this->assign('mode', $mode);
  122. if ($mode == 3) {
  123. $address = (new \app\common\model\Address())->getListByType(2);
  124. $conveyCate = (new \app\common\model\ConveyCate());
  125. $priority = $conveyCate->priority;
  126. $order_convey = $conveyCate->getList();
  127. $order_device = (new \app\common\model\ConveyDevice())->getList();
  128. $this->assign('address', $address);
  129. $this->assign('priority', $priority);
  130. $this->assign('order_convey_type', $order_convey);
  131. $this->assign('order_device', $order_device);
  132. }
  133. $user = Db::name('user')
  134. ->where('id',$this->userId)
  135. ->find();
  136. $this->assign('user',$user);
  137. $tsDh = model('Config')->getConfig('org_config_ts',$this->orgId);
  138. $this->assign('tsDh',$tsDh);
  139. if ($mode == 3) {
  140. return $this->fetch('self_add3');
  141. }
  142. else {
  143. return $this->fetch('self_add');
  144. }
  145. }
  146. }
  147. public function getAddr(){
  148. $id = input('id/d',0);
  149. $info = Db::name('convey_cate')
  150. ->where('id',$id)
  151. ->find();
  152. if(!empty($info['starts'])){
  153. $st = explode(',',$info['starts']);
  154. $s = (new \app\common\model\Address())->getListByTypes($st,2);
  155. }else{
  156. $s = (new \app\common\model\Address())->getListByType(2);
  157. }
  158. if(!empty($info['ends'])){
  159. $ent = explode(',',$info['ends']);
  160. $en = (new \app\common\model\Address())->getListByTypes($ent,2);
  161. }else{
  162. $en = (new \app\common\model\Address())->getListByType(2);
  163. }
  164. $a = [
  165. 's'=>$s,
  166. 'e'=>$en,
  167. ];
  168. $this->success('','',$a);
  169. }
  170. //用户取消订单
  171. public function cancel($id) {
  172. $res = $this->model->cancel($id, $this->userId);
  173. if (!$res) {
  174. $this->error($this->model->getError());
  175. }
  176. $this->success('取消成功');
  177. }
  178. //调度取消订单
  179. public function disCancel($id) {
  180. if (request()->isGet()) {
  181. $this->assign('id', $id);
  182. return $this->fetch();
  183. }
  184. else {
  185. $reason = input('cancel_reason');
  186. $res = $this->model->cancel($id, $this->userId, 2, $reason);
  187. if (!$res) {
  188. $this->error($this->model->getError());
  189. }
  190. $this->success('取消成功');
  191. }
  192. }
  193. //延迟订单
  194. public function batchdelay($id) {
  195. if (request()->isGet()) {
  196. $delay_reason = Db::name('delay_reason')
  197. ->where('org_id', $this->orgId)
  198. ->where('enable', 1)
  199. ->where('del', 0)
  200. ->select();
  201. $this->assign('delay_reason', $delay_reason);
  202. $this->assign('id', $id);
  203. return $this->fetch();
  204. }
  205. else {
  206. $delay_reason_id = input('delay_reason_id');
  207. if (empty($delay_reason_id)) {
  208. $this->error('请选择延迟原因');
  209. }
  210. $res = $this->model->delay_reason($id, $delay_reason_id);
  211. if (!$res) {
  212. $this->error($this->model->getError());
  213. }
  214. $this->success('延迟成功');
  215. }
  216. }
  217. //取消延迟订单
  218. public function batchcanceldelay($id) {
  219. if (request()->isGet()) {
  220. $this->assign('id', $id);
  221. return $this->fetch();
  222. }
  223. else {
  224. $res = $this->model->batchcanceldelay($id);
  225. if (!$res) {
  226. $this->error($this->model->getError());
  227. }
  228. $this->success('延迟成功');
  229. }
  230. }
  231. //用户查看订单详情
  232. public function detail($id) {
  233. if (!$id) {
  234. $this->error('参数错误');
  235. }
  236. $order = Db::name('orders')->where(['id' => $id])->find();
  237. $order = $this->model->formatOrder($order, 1);
  238. $order['images'] = !empty($order['images']) ? explode(',', $order['images']) : '';
  239. if($order['work_type_mode'] == 3){
  240. // 地点路径
  241. $conveyends = Db::name('order_convey_end')
  242. ->alias('a')
  243. ->join('address b','b.id = a.addr')
  244. ->where('a.order_id',$id)
  245. ->order('a.id asc')
  246. ->field('a.*,b.title')
  247. ->select();
  248. $order['ends'] = $conveyends?$conveyends:[];
  249. }
  250. $this->assign('info', $order);
  251. $workTypeName = $this->getTableField('work_type_mode', ['id' => $order['work_type_mode']], 'name');
  252. $this->assign('meta_title', $workTypeName . '订单详情');
  253. return $this->fetch();
  254. }
  255. //调度订单列表
  256. public function index() {
  257. $mode = input('mode', 0);
  258. $quality_type = input('quality_type','');
  259. $level1 = check_is_dispatch($this->userId);
  260. $level2 = check_two_dispatch($this->userId);
  261. $turnoff = two_dispatch_off($this->orgId);
  262. if (request()->isAjax()) {
  263. //分页参数
  264. $length = input('rows', 10, 'intval'); //每页条数
  265. $page = input('page', 1, 'intval'); //第几页
  266. $start = ($page - 1) * $length; //分页开始位置
  267. //排序
  268. $sortRow = input('sidx', 'a.id', 'trim'); //排序列
  269. $sort = input('sord', 'desc', 'trim'); //排序方式
  270. $order = $sortRow . ' ' . $sort;
  271. $content = input('content', '', 'trim');
  272. if ($content) {
  273. $map[] = ['a.content', 'like', '%' . $content . '%'];
  274. }
  275. $dep_id = input('dep_id', '', 'trim');
  276. if ($dep_id != '') {
  277. $map[] = ['a.dep_id', '=', $dep_id];
  278. }
  279. $dep_cate = input('dep_cate', '', 'trim');
  280. if ($dep_cate != '') {
  281. $depIds = Db::name('dep')
  282. ->where('org_id',$this->orgId)
  283. ->where('cate_id',$dep_cate)
  284. ->where('del',0)
  285. ->column('id');
  286. if(!empty($depIds)){
  287. $map[] = ['a.dep_id', 'in', $depIds];
  288. }else{
  289. $map[] = ['a.dep_id', '=', -1];
  290. }
  291. }
  292. $order_mode = input('order_mode', '', 'trim');
  293. $map6 = [];
  294. if ($order_mode != '') {
  295. if($level1 && $turnoff && $mode != 15){ // 一级调度且二级调度开关开着,品质整改例外
  296. if ($order_mode == 1) {
  297. $map[] = ['a.is_deal', '=', 0];
  298. }else if ($order_mode == 4) {
  299. $map6[] = ['a.is_deal', '=', 1];
  300. }
  301. }
  302. if($order_mode==100){//已挂起
  303. $gq = Db::name('todo')
  304. ->where('work_type_mode',1)
  305. ->where('todo_mode',2)
  306. ->where('pause',1)
  307. ->column('order_id');
  308. if(empty($gq)){
  309. $map[] = ['a.id', '=', -1];
  310. }else{
  311. $map[] = ['a.id', 'in', $gq];
  312. }
  313. }else{
  314. $map[] = ['a.order_mode', '=', $order_mode];
  315. }
  316. }
  317. $b = input('start', '', 'trim');
  318. $e = input('end', '', 'trim');
  319. if ($b) {
  320. // $b = date('Ymd', strtotime($b));
  321. // $map[] = ['a.create_yyyymmdd', '>=', $b];
  322. $map[] = ['a.create_time', '>=', $b];
  323. }
  324. if ($e) {
  325. // $e = date('Ymd', strtotime($e));
  326. // $map[] = ['a.create_yyyymmdd', '<=', $e];
  327. $map[] = ['a.create_time', '<=', $e];
  328. }
  329. $map[] = ['a.del', '=', 0];
  330. $map[] = ['a.org_id', '=', $this->orgId];
  331. if($mode==-1){
  332. $map[] = ['a.source_type', '=', 4];
  333. }
  334. $type = input('type', '', 'trim');
  335. $oids = [];
  336. if ($type != '') {
  337. $map1[] = ['parent_id', '=', $type];
  338. $type_id = Db::name('order_type')
  339. ->where($map1)
  340. ->where('org_id', $this->orgId)
  341. ->where('enable', 1)
  342. ->column('id');
  343. if (!empty($type_id)) {
  344. $map3[] = ['type_id', 'in', $type_id];
  345. $ids = Db::name('order_repair')
  346. ->where($map3)
  347. ->column('order_id');
  348. if (!empty($ids)) {
  349. $oids = $ids;
  350. }
  351. else {
  352. $oids = [];
  353. }
  354. }
  355. else {
  356. $oids = [];
  357. }
  358. }
  359. $typeName = input('typeName', '', 'trim');
  360. if ($typeName != '') {
  361. $map_11[] = ['a.title', 'like', '%'.$typeName.'%'];
  362. $typeNameId = Db::name('convey_cate')
  363. ->alias('a')
  364. ->join('order_convey b','a.id=b.type')
  365. ->where($map_11)
  366. ->where('a.org_id', $this->orgId)
  367. ->where('a.enable', 1)
  368. ->where('a.del', 0)
  369. ->column('b.order_id');
  370. if (!empty($typeNameId)) {
  371. $map[] = ['a.id', 'in', $typeNameId];
  372. }
  373. else {
  374. $map[] = ['a.id', '=', -1];
  375. }
  376. }
  377. if($level2 && $turnoff){ // 二级调度
  378. $roles_id = Db::name('user_roles')
  379. ->where('user_id', $this->userId)
  380. ->value('roles_id');
  381. $ids = Db::name('dispatch_log')
  382. ->where('roles_id', $roles_id)
  383. ->whereOr('to_user_id', $this->userId)
  384. ->column('order_id');
  385. if (empty($ids)) {
  386. $map[] = ['a.id', '=', -1];
  387. } else {
  388. if($type != ''){
  389. $oids = array_intersect($oids,$ids);
  390. if($oids){
  391. $map[] = ['a.id', 'in', $oids];
  392. }else{
  393. $map[] = ['a.id', '=', -1];
  394. }
  395. }else{
  396. $map[] = ['a.id', 'in', $ids];
  397. }
  398. }
  399. }else{
  400. if($type != ''){
  401. if($oids){
  402. $map[] = ['a.id', 'in', $oids];
  403. }else{
  404. $map[] = ['a.id', '=', 0];
  405. }
  406. }
  407. }
  408. if($mode == 15){ // 品质检查,单独处理
  409. $map[] = ['a.work_type_mode','=',$mode];
  410. if($quality_type!=''){
  411. $map[] = ['a.quality_type','=',$quality_type];
  412. }
  413. }else{
  414. $work_type_mode = input('work_type_mode','','trim');
  415. if(!is_admin($this->userId)){
  416. $auth = get_dispatch_auth($this->userId);
  417. if($auth){
  418. $map[] = ['a.work_type_mode', 'in', $auth];
  419. if($mode > 0){
  420. $map[] = ['a.work_type_mode', '=', $mode];
  421. }else{
  422. if($work_type_mode!=''){
  423. $map[] = ['a.work_type_mode','=',$work_type_mode];
  424. }
  425. }
  426. }else{
  427. $map[] = ['a.work_type_mode', '=', -1];
  428. }
  429. }else{
  430. if($mode > 0){
  431. $map[] = ['a.work_type_mode', '=', $mode];
  432. }else{
  433. if($work_type_mode!=''){
  434. $map[] = ['a.work_type_mode','=',$work_type_mode];
  435. }
  436. }
  437. }
  438. }
  439. $sn = input('sn', '', 'trim');
  440. if ($sn) {
  441. $map[] = ['a.sn', 'like', '%' . $sn . '%'];
  442. }
  443. $from = input('from', '', 'trim');
  444. if ($from) {
  445. if($from >3){
  446. $map[] = ['a.from','=',0];
  447. $map[] = ['a.work_type_mode','=',$from-3];
  448. }else{
  449. $map[] = ['a.from','=',$from];
  450. }
  451. }
  452. $priority = input('priority', '', 'trim');
  453. if($priority !=''){
  454. $map[] = ['b.priority', '=',$priority];
  455. }
  456. $sddr = input('saddr','','trim');
  457. if($sddr !=''){
  458. $map[] = ['b.start','=',$sddr];
  459. }
  460. $eddr = input('eaddr','','trim');
  461. if($eddr !=''){
  462. $map[] = ['b.end','=',$eddr];
  463. }
  464. $toUserName = input('toUserName','','trim');
  465. if($toUserName !=''){
  466. $ooids = Db::name('user')
  467. ->alias('u')
  468. ->join('todo t','t.to_user_id=u.id')
  469. ->where('t.del',0)
  470. ->where('t.org_id',$this->orgId)
  471. ->where('u.real_name',$toUserName)
  472. ->column('t.order_id');
  473. if($ooids){
  474. $map[] = ['a.id','in',$ooids];
  475. }else{
  476. $map[] = ['a.id','=',-1];
  477. }
  478. }
  479. $conveyCateId = input('conveyCateId','','trim');
  480. if($conveyCateId !=''){
  481. $typeNameId = Db::name('convey_cate')
  482. ->alias('a')
  483. ->join('order_convey b','a.id=b.type')
  484. ->where('a.org_id', $this->orgId)
  485. ->where('a.enable', 1)
  486. ->where('a.del', 0)
  487. ->where('a.id', $conveyCateId)
  488. ->column('b.order_id');
  489. if (!empty($typeNameId)) {
  490. $map[] = ['a.id', 'in', $typeNameId];
  491. }else {
  492. $map[] = ['a.id', '=', -1];
  493. }
  494. }
  495. $deviceId = input('device_id',0);
  496. if($deviceId){
  497. $map[] = ['b.device_id','=',$deviceId];
  498. }
  499. $map = empty($map) ? true : $map;
  500. //数据查询
  501. $lists = db($this->table)
  502. ->where($map)
  503. ->alias('a')
  504. ->leftJoin('order_convey b','a.id=b.order_id')
  505. ->field('a.*,b.priority')
  506. ->whereOr($map6)
  507. ->limit($start, $length)
  508. ->order($order)
  509. // ->fetchSql()
  510. ->select();
  511. // halt($lists);
  512. foreach ($lists as $k => $v) {
  513. $lists[$k] = $this->model->formatOrder($v);
  514. $lists[$k]['priority'] = isset($this->model->priority[$v['priority']])?$this->model->priority[$v['priority']]:"";
  515. if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
  516. $lists[$k]['order_mode_text'] = '已派发';
  517. }
  518. $lists[$k]['bh_nums'] = Db::name('todo')->where('order_id',$v['id'])->where('del',0)->where('todo_mode',4)->count();
  519. $gq = Db::name('todo')
  520. ->where('order_id',$v['id'])
  521. ->where('work_type_mode',1)
  522. ->where('todo_mode',2)
  523. ->where('pause',1)
  524. ->find();
  525. $lists[$k]['gq'] = $gq?'存在挂起':'';
  526. $toUserNames = Db::name('todo')
  527. ->alias('t')
  528. ->join('user u','u.id=t.to_user_id')
  529. ->where('t.order_id',$v['id'])
  530. ->where('t.del',0)
  531. ->column('u.real_name');
  532. $lists[$k]['to_user_names'] = $toUserNames ? implode(',',$toUserNames):'';
  533. }
  534. //数据返回
  535. $totalCount = db($this->table)
  536. ->alias('a')
  537. ->leftJoin('order_convey b','a.id=b.order_id')
  538. ->where($map)->count();
  539. $totalPage = ceil($totalCount / $length);
  540. $result['page'] = $page;
  541. $result['total'] = $totalPage;
  542. $result['records'] = $totalCount;
  543. $result['rows'] = $lists;
  544. return json($result);
  545. }
  546. else {
  547. if($mode >0){
  548. $mode_name = $this->getTableField('work_type_mode', ['id' => $mode], 'name');
  549. }else{
  550. $mode_name = '';
  551. }
  552. if($mode==4){
  553. $mode_name = '应急';
  554. }
  555. $auths = [1,2,3,4,15,0];
  556. if(!is_admin($this->userId)){
  557. $auth = get_dispatch_auth($this->userId);
  558. if($auth){
  559. $auths = array_intersect($auths,$auth);
  560. if($mode > 0){
  561. $auths = array_intersect($auths,[$mode]);
  562. }
  563. }else{
  564. $auths = [];
  565. }
  566. }
  567. $this->assign('auths',$auths);
  568. $this->assign('priority', model("Orders")->priority);
  569. $dep_list = (new \app\common\model\Dep())->getList();
  570. $order_type = (new \app\common\model\OrderType())->list();
  571. $order_mode = Db::name('order_mode')
  572. ->select();
  573. $this->assign('dep_list', $dep_list);
  574. $this->assign('order_type_list', $order_type);
  575. $this->assign('m_name', $mode_name);
  576. $this->assign('mode', $mode);
  577. $this->assign('order_mode_list', $order_mode);
  578. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  579. $this->assign('quality_type',$quality_type);
  580. $dep_cate = model('DepCate')->getList();
  581. $this->assign('dep_cate',$dep_cate);
  582. $conveyCate = Db::name('convey_cate')
  583. ->where('org_id',$this->orgId)
  584. ->where('del',0)
  585. ->where('enable',1)
  586. ->select();
  587. $this->assign('convey_cate',$conveyCate);
  588. $addrList = (new \app\common\model\Address())->getListByTypes([],2,$this->orgId);
  589. $this->assign('addrList',$addrList);
  590. //抢单开关
  591. $this->assign('org_grab_order',(new \app\common\model\Config())
  592. ->getConfig('org_grab_order1',$this->orgId));
  593. $is = 0;
  594. if(!isset($_GET['quality_type']) && $mode==15){
  595. $is = 1;
  596. }
  597. $this->assign('is',$is);
  598. if ($mode == 1) {
  599. return $this->fetch('index1');
  600. }
  601. else {
  602. if ($mode == 3) {
  603. $order_device = (new \app\common\model\ConveyDevice())->getList();
  604. $this->assign('order_device', $order_device);
  605. return $this->fetch('index3');
  606. }else if (in_array($mode,[0,-1])) {
  607. return $this->fetch('index0');
  608. }
  609. else {
  610. return $this->fetch('index');
  611. }
  612. }
  613. }
  614. }
  615. //调度删除订单
  616. public function del($id = 0) {
  617. if (!$id) {
  618. $this->error('参数错误');
  619. }
  620. $model = (new \app\common\model\Orders());
  621. $res = $model->del($id, $this->userId);
  622. if (!$res) {
  623. $this->error($model->getError());
  624. }
  625. $this->success('删除成功');
  626. }
  627. //调度添加订单
  628. public function dispatchAdd($mode = 1) {
  629. $id = input('id', 0);
  630. if (request()->isPost()) {
  631. $data = request()->post();
  632. $data['user_id'] = $this->userId;
  633. $data['org_id'] = $this->orgId;
  634. $data['work_type_mode'] = isset($data['work_type_mode'])?$data['work_type_mode']:$mode;
  635. $data['images'] = isset($data['images']) && !empty($data['images']) ? implode(',', $data['images']) : '';
  636. if ($id > 0) {
  637. // $phoneInfo = Db::name('phone_monitor_record')
  638. // ->where('id', $id)
  639. // ->find();
  640. $data['id'] = $id;
  641. $data['user_id'] = $this->userId;
  642. }
  643. $res = $this->model->addSave($data, 1);
  644. if ($res) {
  645. $this->success('操作成功');
  646. }
  647. else {
  648. $this->error($this->model->getError());
  649. }
  650. }
  651. else {
  652. $tsDh = model('Config')->getConfig('org_config_ts',$this->orgId);
  653. $this->assign('tsDh',$tsDh);
  654. $user = Db::name('user')
  655. ->where('id',$this->userId)
  656. ->find();
  657. $this->assign('user',$user);
  658. if($mode==0){//创建一键呼叫
  659. $dep = $this->getTableField('user_dep', ['user_id' => $this->userId], 'dep_id');
  660. $depList = (new \app\common\model\Dep())->getList();
  661. $this->assign('dep_id', $dep);
  662. $this->assign('dep_list', $depList);
  663. $order_type = (new \app\common\model\OrderType())->getList();
  664. $address = (new \app\common\model\Address())->getListByType(1);
  665. $this->assign('order_type_list', $order_type);
  666. $this->assign('address_list', $address);
  667. $order_repair = Db::name('order_repair')
  668. ->where('order_id', $id)
  669. ->find();
  670. $this->assign('order_repair', $order_repair);
  671. $workType = Db::name('work_type_mode')
  672. ->where('type',1)
  673. ->select();
  674. $config = Db::name('config')
  675. ->where('name','web_order_transfer_type')
  676. ->value('value');
  677. if(empty($config)){
  678. $workType = [];
  679. }else{
  680. $ll = explode('|',$config);
  681. foreach ($workType as $kk=>$vv){
  682. if(!in_array($vv['id'],$ll)){
  683. unset($workType[$kk]);
  684. }
  685. }
  686. }
  687. if(!is_admin($this->userId)){
  688. $auth = get_dispatch_auth($this->userId);
  689. if(empty($auth)){
  690. $workType = [];
  691. }else{
  692. foreach ($workType as $kk=>$vv){
  693. if(!in_array($vv['id'],$auth)){
  694. unset($workType[$kk]);
  695. }
  696. }
  697. }
  698. }
  699. foreach ($workType as $k=>$v){
  700. $this->assign('send_user_num'.$v['id'], $this->model->sendUserNum($v['id'], $this->orgId));
  701. $this->assign('user_list'.$v['id'], (new \app\common\model\WorkTypeMode())->getRolesUserByNum($v['id'], $this->orgId, 1));
  702. $two_dispatch_roles = model('user')->get_two_dispatch_role($this->orgId, $v['id']);
  703. $this->assign('dispatch_roles'.$v['id'], $two_dispatch_roles);
  704. }
  705. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  706. $this->assign('two_dispatch_off', two_dispatch_off($this->orgId));
  707. $this->assign('workType', $workType);
  708. $address = (new \app\common\model\Address())->getListByType(2);
  709. $conveyCate = (new \app\common\model\ConveyCate());
  710. $priority = $conveyCate->priority;
  711. $order_convey = $conveyCate->getList();
  712. $order_device = (new \app\common\model\ConveyDevice())->getList();
  713. $this->assign('address', $address);
  714. $this->assign('priority', $priority);
  715. $this->assign('order_convey_type', $order_convey);
  716. $this->assign('order_device', $order_device);
  717. $oCid = Db::name('order_convey')
  718. ->where('order_id',$id)
  719. ->find();
  720. $opt = Db::name('order_convey_patient')
  721. ->where('order_id',$id)
  722. ->find();
  723. $this->assign('ocid',$oCid);
  724. $this->assign('opt',$opt);
  725. $this->assign('ps',empty($opt)?1:0);
  726. $this->assign('id', $id);
  727. $this->assign('mode', $mode);
  728. return $this->fetch('yjhj_dispatch_add');
  729. }else{
  730. $dep = $this->getTableField('user_dep', ['user_id' => $this->userId], 'dep_id');
  731. $depList = (new \app\common\model\Dep())->getList();
  732. $order_type = (new \app\common\model\OrderType())->getList();
  733. $address = (new \app\common\model\Address())->getListByType(1);
  734. $this->assign('dep_id', $dep);
  735. $this->assign('dep_list', $depList);
  736. $this->assign('order_type_list', $order_type);
  737. $this->assign('mode', $mode);
  738. $this->assign('send_user_num', $this->model->sendUserNum($mode, $this->orgId));
  739. $this->assign('user_list', (new \app\common\model\WorkTypeMode())->getRolesUserByNum($mode, $this->orgId,1));
  740. $this->assign('address_list', $address);
  741. $this->assign('address_id', '');
  742. if ($mode == 3) {
  743. $address = (new \app\common\model\Address())->getListByType(2);
  744. $conveyCate = (new \app\common\model\ConveyCate());
  745. $priority = $conveyCate->priority;
  746. $order_convey = $conveyCate->getList();
  747. $order_device = (new \app\common\model\ConveyDevice())->getList();
  748. $this->assign('address', $address);
  749. $this->assign('priority', $priority);
  750. $this->assign('order_convey_type', $order_convey);
  751. $this->assign('order_device', $order_device);
  752. }
  753. if ($id > 0) {
  754. // $phoneInfo = Db::name('phone_monitor_record')
  755. // ->where('id', $id)
  756. // ->find();
  757. $this->assign('address_id', 0);
  758. // $depId = Db::name('user_dep')
  759. // ->where('user_id', $phoneInfo['user_id'])
  760. // ->value('dep_id');
  761. $this->assign('dep_id', 0);
  762. }
  763. $two_dispatch_roles = model('user')->get_two_dispatch_role($this->orgId, $mode);
  764. $this->assign('dispatch_roles', $two_dispatch_roles);
  765. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  766. $this->assign('two_dispatch_off', two_dispatch_off($this->orgId));
  767. $this->assign('id', $id);
  768. if ($mode == 3) {
  769. return $this->fetch('dispatch_add3');
  770. }
  771. else {
  772. return $this->fetch('dispatch_add');
  773. }
  774. }
  775. }
  776. }
  777. public function editOrder() {
  778. $id = input('id', 0);
  779. if (request()->isPost()) {
  780. $data = request()->post();
  781. $data['user_id'] = $this->userId;
  782. $data['org_id'] = $this->orgId;
  783. $data['images'] = isset($data['images']) && !empty($data['images']) ? implode(',', $data['images']) : '';
  784. $res = $this->model->editSave($data);
  785. if ($res) {
  786. $this->success('操作成功');
  787. }
  788. else {
  789. $this->error($this->model->getError());
  790. }
  791. }
  792. else {
  793. $order = Db::name('orders')->where('id',$id)->find();
  794. $mode = $order['work_type_mode'];
  795. $tsDh = model('Config')->getConfig('org_config_ts',$this->orgId);
  796. $this->assign('tsDh',$tsDh);
  797. $user = Db::name('user')
  798. ->where('id',$this->userId)
  799. ->find();
  800. $this->assign('user',$user);
  801. if($mode==0){//创建一键呼叫
  802. $dep = $this->getTableField('user_dep', ['user_id' => $this->userId], 'dep_id');
  803. $depList = (new \app\common\model\Dep())->getList();
  804. $this->assign('dep_id', $dep);
  805. $this->assign('dep_list', $depList);
  806. $order_type = (new \app\common\model\OrderType())->getList();
  807. $address = (new \app\common\model\Address())->getListByType(1);
  808. $this->assign('order_type_list', $order_type);
  809. $this->assign('address_list', $address);
  810. $order_repair = Db::name('order_repair')
  811. ->where('order_id', $id)
  812. ->find();
  813. $this->assign('order_repair', $order_repair);
  814. $workType = Db::name('work_type_mode')
  815. ->where('type',1)
  816. ->select();
  817. $config = Db::name('config')
  818. ->where('name','web_order_transfer_type')
  819. ->value('value');
  820. if(empty($config)){
  821. $workType = [];
  822. }else{
  823. $ll = explode('|',$config);
  824. foreach ($workType as $kk=>$vv){
  825. if(!in_array($vv['id'],$ll)){
  826. unset($workType[$kk]);
  827. }
  828. }
  829. }
  830. if(!is_admin($this->userId)){
  831. $auth = get_dispatch_auth($this->userId);
  832. if(empty($auth)){
  833. $workType = [];
  834. }else{
  835. foreach ($workType as $kk=>$vv){
  836. if(!in_array($vv['id'],$auth)){
  837. unset($workType[$kk]);
  838. }
  839. }
  840. }
  841. }
  842. foreach ($workType as $k=>$v){
  843. $this->assign('send_user_num'.$v['id'], $this->model->sendUserNum($v['id'], $this->orgId));
  844. $this->assign('user_list'.$v['id'], (new \app\common\model\WorkTypeMode())->getRolesUserByNum($v['id'], $this->orgId, 1));
  845. $two_dispatch_roles = model('user')->get_two_dispatch_role($this->orgId, $v['id']);
  846. $this->assign('dispatch_roles'.$v['id'], $two_dispatch_roles);
  847. }
  848. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  849. $this->assign('two_dispatch_off', two_dispatch_off($this->orgId));
  850. $this->assign('workType', $workType);
  851. $address = (new \app\common\model\Address())->getListByType(2);
  852. $conveyCate = (new \app\common\model\ConveyCate());
  853. $priority = $conveyCate->priority;
  854. $order_convey = $conveyCate->getList();
  855. $order_device = (new \app\common\model\ConveyDevice())->getList();
  856. $this->assign('address', $address);
  857. $this->assign('priority', $priority);
  858. $this->assign('order_convey_type', $order_convey);
  859. $this->assign('order_device', $order_device);
  860. $oCid = Db::name('order_convey')
  861. ->where('order_id',$id)
  862. ->find();
  863. $opt = Db::name('order_convey_patient')
  864. ->where('order_id',$id)
  865. ->find();
  866. $this->assign('ocid',$oCid);
  867. $this->assign('opt',$opt);
  868. $this->assign('ps',empty($opt)?1:0);
  869. $this->assign('id', $id);
  870. $this->assign('mode', $mode);
  871. $this->assign('order',$order);
  872. return $this->fetch('yjhj_dispatch_edit');
  873. }else{
  874. $dep = $this->getTableField('user_dep', ['user_id' => $this->userId], 'dep_id');
  875. $depList = (new \app\common\model\Dep())->getList();
  876. $order_type = (new \app\common\model\OrderType())->getList();
  877. $address = (new \app\common\model\Address())->getListByType(1);
  878. $this->assign('dep_id', $dep);
  879. $this->assign('dep_list', $depList);
  880. $this->assign('order_type_list', $order_type);
  881. $this->assign('mode', $mode);
  882. $this->assign('send_user_num', $this->model->sendUserNum($mode, $this->orgId));
  883. $this->assign('user_list', (new \app\common\model\WorkTypeMode())->getRolesUserByNum($mode, $this->orgId,1));
  884. $this->assign('address_list', $address);
  885. $this->assign('address_id', '');
  886. if ($mode == 3) {
  887. $address = (new \app\common\model\Address())->getListByType(2);
  888. $conveyCate = (new \app\common\model\ConveyCate());
  889. $priority = $conveyCate->priority;
  890. $order_convey = $conveyCate->getList();
  891. $order_device = (new \app\common\model\ConveyDevice())->getList();
  892. $this->assign('address', $address);
  893. $this->assign('priority', $priority);
  894. $this->assign('order_convey_type', $order_convey);
  895. $this->assign('order_device', $order_device);
  896. $orderconvey = Db::name('order_convey')->where('order_id',$id)->find();
  897. $this->assign('orderconvey',$orderconvey);
  898. $orderconveypatient = Db::name('order_convey_patient')->where('order_id',$id)->find();
  899. $this->assign('orderconveypatient',$orderconveypatient);
  900. $addrs = Db::name('order_convey_end')->where('order_id',$id)->column('addr');
  901. $this->assign('addrs',$addrs?implode(',',$addrs):'');
  902. }else if($mode == 1){
  903. $orderrepair = Db::name('order_repair')->where('order_id',$id)->find();
  904. $this->assign('orderrepair',$orderrepair);
  905. }
  906. if ($id > 0) {
  907. // $phoneInfo = Db::name('phone_monitor_record')
  908. // ->where('id', $id)
  909. // ->find();
  910. $this->assign('address_id', 0);
  911. // $depId = Db::name('user_dep')
  912. // ->where('user_id', $phoneInfo['user_id'])
  913. // ->value('dep_id');
  914. $this->assign('dep_id', 0);
  915. }
  916. $two_dispatch_roles = model('user')->get_two_dispatch_role($this->orgId, $mode);
  917. $this->assign('dispatch_roles', $two_dispatch_roles);
  918. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  919. $this->assign('two_dispatch_off', two_dispatch_off($this->orgId));
  920. $this->assign('id', $id);
  921. $this->assign('order',$order);
  922. if ($mode == 3) {
  923. return $this->fetch('dispatch_edit3');
  924. }
  925. else {
  926. return $this->fetch('dispatch_edit');
  927. }
  928. }
  929. }
  930. }
  931. //调度查看订单详情
  932. public function detail2($id) {
  933. if (!$id) {
  934. $this->error('参数错误');
  935. }
  936. $type = input('type/d',0);
  937. $this->assign('type', $type);
  938. $order = Db::name('orders')->where(['id' => $id])->find();
  939. $order = $this->model->formatOrder($order, 1);
  940. $order['images'] = !empty($order['images']) ? explode(',', $order['images']) : '';
  941. $is_ch = 0;
  942. if($order['order_mode'] == 4){
  943. $todoInfo = Db::name('todo')->where('order_id',$order['id'])->where('del',0)->where('todo_mode','>',1)->find();
  944. if(!$todoInfo){
  945. $is_ch = 1;
  946. }
  947. }
  948. $order['is_ch'] = $is_ch;
  949. if($order['work_type_mode'] == 3){
  950. // 地点路径
  951. $conveyends = Db::name('order_convey_end')
  952. ->alias('a')
  953. ->join('address b','b.id = a.addr')
  954. ->where('a.order_id',$id)
  955. ->order('a.id asc')
  956. ->field('a.*,b.title')
  957. ->select();
  958. $order['ends'] = $conveyends?$conveyends:[];
  959. }
  960. $this->assign('info', $order);
  961. $workTypeName = $this->getTableField('work_type_mode', ['id' => $order['work_type_mode']], 'name');
  962. $this->assign('meta_title', $workTypeName . '订单详情');
  963. $level2 = check_two_dispatch($this->userId);
  964. $level1 = check_is_dispatch($this->userId);
  965. $turnoff = two_dispatch_off($this->orgId);
  966. $this->assign('level1', $level1);
  967. $this->assign('level2', $level2);
  968. $this->assign('turnoff', $turnoff);
  969. $this->assign('dispatch_type', $level2);
  970. $this->assign('org_auto_send',(new \app\common\model\Config())
  971. ->getConfig('org_auto_send',$this->orgId));
  972. return $this->fetch();
  973. }
  974. public function zg_detail($id) {
  975. if (!$id) {
  976. $this->error('参数错误');
  977. }
  978. $type = input('type/d',0);
  979. $this->assign('type', $type);
  980. $order = Db::name('orders')->where(['id' => $id])->find();
  981. $order = $this->model->formatOrder($order, 1);
  982. $order['images'] = !empty($order['images']) ? explode(',', $order['images']) : '';
  983. $this->assign('info', $order);
  984. $workTypeName = $this->getTableField('work_type_mode', ['id' => $order['work_type_mode']], 'name');
  985. $this->assign('meta_title', $workTypeName . '订单详情');
  986. $level2 = check_two_dispatch($this->userId);
  987. $level1 = check_is_dispatch($this->userId);
  988. $turnoff = two_dispatch_off($this->orgId);
  989. $this->assign('level1', $level1);
  990. $this->assign('level2', $level2);
  991. $this->assign('turnoff', $turnoff);
  992. $this->assign('dispatch_type', $level2);
  993. return $this->fetch();
  994. }
  995. public function print($id) {
  996. if (!$id) {
  997. $this->error('参数错误');
  998. }
  999. $type = input('type/d',0);
  1000. $this->assign('type', $type);
  1001. $order = Db::name('orders')->where(['id' => $id])->find();
  1002. $order = $this->model->formatOrder($order, 1);
  1003. $order['images'] = !empty($order['images']) ? explode(',', $order['images']) : '';
  1004. $this->assign('info', $order);
  1005. $workTypeName = $this->getTableField('work_type_mode', ['id' => $order['work_type_mode']], 'name');
  1006. $this->assign('meta_title', $workTypeName . '订单详情');
  1007. $level2 = check_two_dispatch($this->userId);
  1008. $level1 = check_is_dispatch($this->userId);
  1009. $turnoff = two_dispatch_off($this->orgId);
  1010. $this->assign('level1', $level1);
  1011. $this->assign('level2', $level2);
  1012. $this->assign('turnoff', $turnoff);
  1013. $this->assign('dispatch_type', $level2);
  1014. return $this->fetch();
  1015. }
  1016. //派单
  1017. public function send($id, $mode = 1) {
  1018. if (request()->isGet()) {
  1019. $this->assign('id', $id);
  1020. $this->assign('mode', $mode);
  1021. $orders = Db::name('orders')
  1022. ->where('id',$id)
  1023. ->find();
  1024. if($orders['source_type']==4 && $orders['work_type_mode']==0 && $orders['is_deal']==0){//一键呼叫
  1025. $order_type = (new \app\common\model\OrderType())->getList();
  1026. $address = (new \app\common\model\Address())->getListByType(1);
  1027. $this->assign('order_type_list', $order_type);
  1028. $this->assign('address_list', $address);
  1029. $order_repair = Db::name('order_repair')
  1030. ->where('order_id', $id)
  1031. ->find();
  1032. $this->assign('order_repair', $order_repair);
  1033. $workType = Db::name('work_type_mode')
  1034. ->where('type',1)
  1035. ->select();
  1036. $config = Db::name('config')
  1037. ->where('name','web_order_transfer_type')
  1038. ->value('value');
  1039. if(empty($config)){
  1040. $workType = [];
  1041. }else{
  1042. $ll = explode('|',$config);
  1043. foreach ($workType as $kk=>$vv){
  1044. if(!in_array($vv['id'],$ll)){
  1045. unset($workType[$kk]);
  1046. }
  1047. }
  1048. }
  1049. foreach ($workType as $k=>$v){
  1050. $this->assign('send_user_num'.$v['id'], $this->model->sendUserNum($v['id'], $this->orgId));
  1051. $this->assign('user_list'.$v['id'], (new \app\common\model\WorkTypeMode())->getRolesUserByNum($v['id'], $this->orgId, 1));
  1052. $two_dispatch_roles = model('user')->get_two_dispatch_role($this->orgId, $v['id']);
  1053. $this->assign('dispatch_roles'.$v['id'], $two_dispatch_roles);
  1054. }
  1055. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  1056. $this->assign('two_dispatch_off', two_dispatch_off($this->orgId));
  1057. $this->assign('workType', $workType);
  1058. $this->assign('orders', $orders);
  1059. $address = (new \app\common\model\Address())->getListByType(2);
  1060. $conveyCate = (new \app\common\model\ConveyCate());
  1061. $priority = $conveyCate->priority;
  1062. $order_convey = $conveyCate->getList();
  1063. $order_device = (new \app\common\model\ConveyDevice())->getList();
  1064. $this->assign('address', $address);
  1065. $this->assign('priority', $priority);
  1066. $this->assign('order_convey_type', $order_convey);
  1067. $this->assign('order_device', $order_device);
  1068. $oCid = Db::name('order_convey')
  1069. ->where('order_id',$id)
  1070. ->find();
  1071. $opt = Db::name('order_convey_patient')
  1072. ->where('order_id',$id)
  1073. ->find();
  1074. $this->assign('ocid',$oCid);
  1075. $this->assign('opt',$opt);
  1076. $this->assign('ps',empty($opt)?1:0);
  1077. $auths = [1,2,3,4,15,0];
  1078. if(!is_admin($this->userId)){
  1079. $auth = get_dispatch_auth($this->userId);
  1080. if($auth){
  1081. $auths = array_intersect($auths,$auth);
  1082. if($mode > 0){
  1083. $auths = array_intersect($auths,[$mode]);
  1084. }
  1085. }else{
  1086. $auths = [];
  1087. }
  1088. }
  1089. $this->assign('auths',$auths);
  1090. return $this->fetch('yjhj_send');
  1091. }else{
  1092. if ($mode == 1) {
  1093. $order_type = (new \app\common\model\OrderType())->getList();
  1094. $address = (new \app\common\model\Address())->getListByType(1);
  1095. $this->assign('order_type_list', $order_type);
  1096. $this->assign('address_list', $address);
  1097. $order_repair = Db::name('order_repair')
  1098. ->where('order_id', $id)
  1099. ->find();
  1100. $this->assign('order_repair', $order_repair);
  1101. }
  1102. $this->assign('send_user_num', $this->model->sendUserNum($mode, $this->orgId));
  1103. $this->assign('user_list', (new \app\common\model\WorkTypeMode())->getRolesUserByNum($mode, $this->orgId, 1));
  1104. $two_dispatch_roles = model('user')->get_two_dispatch_role($this->orgId, $mode);
  1105. $this->assign('dispatch_roles', $two_dispatch_roles);
  1106. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  1107. $this->assign('two_dispatch_off', two_dispatch_off($this->orgId));
  1108. return $this->fetch();
  1109. }
  1110. }
  1111. else {
  1112. $data = request()->post();
  1113. $data['org_id'] = $this->orgId;
  1114. $res = $this->model->send($id, $this->userId, $data);
  1115. if (!$res) {
  1116. $this->error($this->model->getError());
  1117. }
  1118. $this->success('操作成功');
  1119. }
  1120. }
  1121. //转单
  1122. public function zd_send($id, $mode = 1) {
  1123. if (request()->isGet()) {
  1124. $this->assign('id', $id);
  1125. $this->assign('mode', $mode);
  1126. $orders = Db::name('orders')
  1127. ->where('id',$id)
  1128. ->find();
  1129. if($orders['source_type']==4 && $orders['is_deal']==0){//一键呼叫
  1130. $order_type = (new \app\common\model\OrderType())->getList();
  1131. $address = (new \app\common\model\Address())->getListByType(1);
  1132. $this->assign('order_type_list', $order_type);
  1133. $this->assign('address_list', $address);
  1134. $order_repair = Db::name('order_repair')
  1135. ->where('order_id', $id)
  1136. ->find();
  1137. $this->assign('order_repair', $order_repair);
  1138. $workType = Db::name('work_type_mode')
  1139. ->where('type',1)
  1140. ->select();
  1141. $config = Db::name('config')
  1142. ->where('name','web_order_transfer_type')
  1143. ->value('value');
  1144. if(empty($config)){
  1145. $workType = [];
  1146. }else{
  1147. $ll = explode('|',$config);
  1148. foreach ($workType as $kk=>$vv){
  1149. if(!in_array($vv['id'],$ll)){
  1150. unset($workType[$kk]);
  1151. }
  1152. }
  1153. }
  1154. foreach ($workType as $k=>$v){
  1155. $this->assign('send_user_num'.$v['id'], $this->model->sendUserNum($v['id'], $this->orgId));
  1156. $this->assign('user_list'.$v['id'], (new \app\common\model\WorkTypeMode())->getRolesUser($v['id'], $this->orgId, 1));
  1157. $two_dispatch_roles = model('user')->get_two_dispatch_role($this->orgId, $v['id']);
  1158. $this->assign('dispatch_roles'.$v['id'], $two_dispatch_roles);
  1159. }
  1160. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  1161. $this->assign('two_dispatch_off', two_dispatch_off($this->orgId));
  1162. $this->assign('workType', $workType);
  1163. $this->assign('orders', $orders);
  1164. $address = (new \app\common\model\Address())->getListByType(2);
  1165. $conveyCate = (new \app\common\model\ConveyCate());
  1166. $priority = $conveyCate->priority;
  1167. $order_convey = $conveyCate->getList();
  1168. $order_device = (new \app\common\model\ConveyDevice())->getList();
  1169. $this->assign('address', $address);
  1170. $this->assign('priority', $priority);
  1171. $this->assign('order_convey_type', $order_convey);
  1172. $this->assign('order_device', $order_device);
  1173. $oCid = Db::name('order_convey')
  1174. ->where('order_id',$id)
  1175. ->find();
  1176. $opt = Db::name('order_convey_patient')
  1177. ->where('order_id',$id)
  1178. ->find();
  1179. $this->assign('ocid',$oCid);
  1180. $this->assign('opt',$opt);
  1181. $this->assign('ps',empty($opt)?1:0);
  1182. $auths = [1,2,3,4,15,0];
  1183. if(!is_admin($this->userId)){
  1184. $auth = get_dispatch_auth($this->userId);
  1185. if($auth){
  1186. $auths = array_intersect($auths,$auth);
  1187. if($mode > 0){
  1188. $auths = array_intersect($auths,[$mode]);
  1189. }
  1190. }else{
  1191. $auths = [];
  1192. }
  1193. }
  1194. $this->assign('auths',$auths);
  1195. return $this->fetch('yjhj_zd_send');
  1196. }
  1197. }
  1198. else {
  1199. $data = request()->post();
  1200. $data['org_id'] = $this->orgId;
  1201. $res = $this->model->zd_send($id, $data);
  1202. if (!$res) {
  1203. $this->error($this->model->getError());
  1204. }
  1205. $this->success('操作成功');
  1206. }
  1207. }
  1208. //批量派单
  1209. public function batchsend($id, $mode = 1) {
  1210. ini_set('memory_limit', '256M');
  1211. if (request()->isGet()) {
  1212. $this->assign('id', $id);
  1213. $this->assign('mode', $mode);
  1214. if ($mode == 1) {
  1215. $order_type = (new \app\common\model\OrderType())->getList();
  1216. $address = (new \app\common\model\Address())->getListByType(1);
  1217. $this->assign('order_type_list', $order_type);
  1218. $this->assign('address_list', $address);
  1219. $order_repair = Db::name('order_repair')
  1220. ->where('order_id', $id)
  1221. ->find();
  1222. $this->assign('order_repair', $order_repair);
  1223. }
  1224. $user = (new \app\common\model\WorkTypeMode())->getRolesUser($mode, $this->orgId, 1);
  1225. $newUser = [];
  1226. $pinyin = new Pinyin();
  1227. foreach ($user as $k => $v) {
  1228. foreach ($v['user'] as $k1 => $v1) {
  1229. $v1['pinyin'] = $pinyin->abbr($v1['real_name'],PINYIN_KEEP_ENGLISH); //只保留汉字首字母 和 字母的首字母 //例如:'汉字sszz11' = hzs
  1230. $newUser[] = $v1;
  1231. }
  1232. }
  1233. $newUser = arraySequence($newUser,'pinyin');
  1234. $mm = new \app\common\model\User();
  1235. //旧版,速度太慢,抛弃
  1236. // foreach ($newUser as $key => $value) {
  1237. // $nums = Db::name('todo')
  1238. // ->where(['to_user_id' => $value['id'], 'work_type_mode' => 3])
  1239. // ->where('create_yyyymmdd', date('Ymd'))
  1240. // ->where('todo_mode', 'in', [1, 2, 3])
  1241. // ->count();
  1242. // $newUser[$key]['nums'] = $nums;
  1243. //
  1244. // $newUser[$key]['cur_status'] = 0; // 空闲
  1245. // $nums2 = Db::name('todo')
  1246. // ->where(['to_user_id' => $value['id'], 'work_type_mode' => 3])
  1247. // ->where('todo_mode', 'in', [1, 2])
  1248. // ->count();
  1249. // if($nums2 > 0){
  1250. // $newUser[$key]['cur_status'] = 1; // 任务中
  1251. // }
  1252. //
  1253. //
  1254. // $addr = Db::name('order_convey')
  1255. // ->alias('cpr')
  1256. // ->join('todo os', 'cpr.order_id = os.order_id')
  1257. // ->join('orders ods', 'cpr.order_id = ods.id')
  1258. // ->join('address ca', 'ca.id = cpr.start')
  1259. // ->join('address cad', 'cad.id = cpr.end')
  1260. // ->field('os.todo_mode,ca.title as start_name,cad.title as end_name,os.create_time')
  1261. // ->where('os.to_user_id', $value['id'])
  1262. // ->where('os.del', 0)
  1263. // ->where('ods.del', 0)
  1264. // ->order('os.id desc')
  1265. // ->find();
  1266. // $newUser[$key]['title'] = '';
  1267. // $newUser[$key]['addr_time'] = '';
  1268. // if($addr){
  1269. // if(in_array($addr['todo_mode'],[1,2])){
  1270. // $newUser[$key]['title'] = $addr['start_name'];
  1271. // }else{
  1272. // $newUser[$key]['title'] = $addr['end_name'];
  1273. // }
  1274. // $newUser[$key]['addr_time'] = $addr['create_time'];
  1275. // }
  1276. // $u = Db::name('user')
  1277. // ->where('id',$value['id'])
  1278. // ->value('sex');
  1279. // $newUser[$key]['sex_name'] = isset($mm->sex[$u])?$mm->sex[$u]:"";
  1280. //
  1281. // }
  1282. $userIds = array_column($newUser, 'id');
  1283. $taskCounts = Db::name('todo')
  1284. ->where('to_user_id', 'in', $userIds)
  1285. ->where('work_type_mode', 3)
  1286. ->where('create_yyyymmdd', date('Ymd'))
  1287. ->where('todo_mode', 'in', [1, 2, 3])
  1288. ->field([
  1289. 'to_user_id',
  1290. 'COUNT(*) as nums',
  1291. 'SUM(CASE WHEN todo_mode IN (1, 2) THEN 1 ELSE 0 END) as nums2' // 进行中任务数(todo_mode in [1,2])
  1292. ])
  1293. ->group('to_user_id')
  1294. ->select();
  1295. $taskCountMap = array_column($taskCounts, null, 'to_user_id');
  1296. $addrInfo = Db::name('todo')
  1297. ->alias('os')
  1298. ->join('order_convey cpr', 'cpr.order_id = os.order_id', 'LEFT')
  1299. ->field('os.to_user_id, os.todo_mode, cpr.end, cpr.start, os.create_time')
  1300. ->where('os.to_user_id', 'in', $userIds)
  1301. ->where('os.del', 0)
  1302. ->whereBetween('os.create_time', [date('Y-m-d 00:00:00', strtotime('-7 days')), date('Y-m-d 23:59:59')])
  1303. ->select();
  1304. unset($userIds,$taskCounts);
  1305. $addrMap = [];
  1306. foreach ($addrInfo as $addr) {
  1307. $addrMap[$addr['to_user_id']] = $addr;
  1308. }
  1309. $start = array_column($addrInfo,'start');
  1310. $end = array_column($addrInfo,'end');
  1311. $addressIds = array_unique(array_merge($start,$end));
  1312. $address = Db::name('address')
  1313. ->where('id','in',$addressIds)
  1314. ->column('title','id');
  1315. unset($start,$end,$addressIds);
  1316. foreach ($newUser as $key => $value) {
  1317. $userId = $value['id'];
  1318. $counts = $taskCountMap[$userId] ?? ['nums' => 0, 'nums2' => 0];
  1319. $newUser[$key]['nums'] = $counts['nums'];
  1320. $newUser[$key]['cur_status'] = $counts['nums2'] > 0 ? 1 : 0;
  1321. $newUser[$key]['title'] = '';
  1322. $newUser[$key]['addr_time'] = '';
  1323. if (isset($addrMap[$userId])) {
  1324. $addr = $addrMap[$userId];
  1325. if (in_array($addr['todo_mode'], [1, 2])) {
  1326. $newUser[$key]['title'] = $address[$addr['start']];
  1327. } else {
  1328. $newUser[$key]['title'] = $address[$addr['end']];
  1329. }
  1330. $newUser[$key]['addr_time'] = $addr['create_time'];
  1331. }
  1332. }
  1333. $newUser = list_sort_by($newUser,"addr_time", 'asc');
  1334. if($this->orgId==3){
  1335. // echo "<pre/>";
  1336. // print_r($newUser);
  1337. // die();
  1338. }
  1339. $this->assign('user_list', $newUser);
  1340. return $this->fetch();
  1341. }
  1342. else {
  1343. $data = request()->post();
  1344. $data['org_id'] = $this->orgId;
  1345. if (empty($data['to_user_id'])) {
  1346. $this->error('请选择执行人');
  1347. }
  1348. $data['to_user_id'] = implode(',', $data['to_user_id']);
  1349. $res = $this->model->batchsend($id, $this->userId, $data);
  1350. if (!$res) {
  1351. $this->error($this->model->getError());
  1352. }
  1353. $this->success('操作成功');
  1354. }
  1355. }
  1356. public function onesend($id, $mode = 1) {
  1357. $data = request()->post();
  1358. $data['org_id'] = $this->orgId;
  1359. if (empty($data['to_user_id'])) {
  1360. $this->error('请选择执行人');
  1361. }
  1362. // $data['to_user_id'] = implode(',', $data['to_user_id']);
  1363. $res = $this->model->batchsend($id, $this->userId, $data);
  1364. if (!$res) {
  1365. $this->error($this->model->getError());
  1366. }
  1367. $this->success('操作成功');
  1368. }
  1369. //完成订单
  1370. public function finish($id) {
  1371. $res = $this->model->finish($id);
  1372. if (!$res) {
  1373. $this->error($this->model->getError());
  1374. }
  1375. $this->success('操作成功');
  1376. }
  1377. //批量完成订单
  1378. public function batchfinish($id) {
  1379. $res = $this->model->batchfinish($id);
  1380. if (!$res) {
  1381. $this->error($this->model->getError());
  1382. }
  1383. $this->success('操作成功');
  1384. }
  1385. //评价
  1386. public function comment() {
  1387. $id = input('id');
  1388. $score = input('score');
  1389. $content = input('content');
  1390. if ($score <= 0 || $score > 5) {
  1391. $this->error('参数错误');
  1392. }
  1393. $res = $this->model->addComment($id, $score, $content, $this->userId, $this->orgId);
  1394. if (!$res) {
  1395. $this->error($this->model->getError());
  1396. }
  1397. $this->success('操作成功');
  1398. }
  1399. public function phone() {
  1400. $phone = input('phone','','trim');
  1401. $fp = input('fp','','trim');
  1402. $id = input('id/d',0,'trim');
  1403. if($phone){
  1404. $fp = $fp?base64_decode($fp):'';
  1405. $md5 = md5($this->orgId.'|'.$fp);
  1406. $ret = Db::name('phone_monitor_record')->where('md5',$md5)->find();
  1407. if(!$ret){
  1408. $id = Db::name('phone_monitor_record')->insertGetId([
  1409. 'org_id' => $this->orgId,
  1410. 'phone' => $phone,
  1411. 'path' => $fp,
  1412. 'md5' => $md5,
  1413. 'create_time' => date('Y-m-d H:i:s')
  1414. ]);
  1415. }else{
  1416. $id = $ret['id'];
  1417. }
  1418. }
  1419. $worktype = [
  1420. ['id' => 1, 'title' => '报修'],
  1421. ['id' => 2, 'title' => '保洁'],
  1422. ['id' => 3, 'title' => '运送'],
  1423. ['id' => 4, 'title' => '应急'],
  1424. ];
  1425. $info = Db::name('phone_monitor_record')->where('id',$id)->find();
  1426. if(!$info){
  1427. halt('数据存储失败');
  1428. }
  1429. $this->assign('worktype', $worktype);
  1430. $this->assign('info', $info);
  1431. $this->assign('id', $id);
  1432. return $this->fetch();
  1433. }
  1434. public function phoneAdd() {
  1435. $id = input('id');
  1436. $worktype = [
  1437. ['id' => 1, 'title' => '报修'],
  1438. ['id' => 2, 'title' => '保洁'],
  1439. ['id' => 3, 'title' => '运送'],
  1440. ['id' => 4, 'title' => '应急'],
  1441. ];
  1442. $info = Db::name('phone_monitor')
  1443. ->where('id', $id)->find();
  1444. if (!$info) {
  1445. echo '负责人不存在', exit();
  1446. }
  1447. $info['real_name'] = Db::name('user')
  1448. ->where('id', $info['user_id'])
  1449. ->value('real_name');
  1450. $info['dep'] = Db::name('user_dep')
  1451. ->alias('a')
  1452. ->join('dep b', 'a.dep_id=b.id')
  1453. ->where('a.user_id', $info['user_id'])
  1454. ->value('b.title');
  1455. $this->assign('worktype', $worktype);
  1456. $this->assign('info', $info);
  1457. $this->assign('id', $id);
  1458. return $this->fetch();
  1459. }
  1460. //运送调度订单列表
  1461. public function convey() {
  1462. set_time_limit(0);
  1463. ini_set("memory_limit","1024M");
  1464. $mode = input('mode', 1);
  1465. if (request()->isAjax()) {
  1466. //分页参数
  1467. $length = input('rows', 10, 'intval'); //每页条数
  1468. $page = input('page', 1, 'intval'); //第几页
  1469. $start = ($page - 1) * $length; //分页开始位置
  1470. //排序
  1471. $sortRow = input('sidx', 'id', 'trim'); //排序列
  1472. $sort = input('sord', 'desc', 'trim'); //排序方式
  1473. $order = $sortRow . ' ' . $sort;
  1474. $content = input('content', '', 'trim');
  1475. if ($content) {
  1476. $map[] = ['o.content', 'like', '%' . $content . '%'];
  1477. }
  1478. $dep_id = input('dep_id', '', 'trim');
  1479. if ($dep_id != '') {
  1480. $map[] = ['o.dep_id', '=', $dep_id];
  1481. }
  1482. $priority = input('priority', '', 'trim');
  1483. if ($priority) {
  1484. $map[] = ['oc.priority', '=', $priority];
  1485. }
  1486. $s = input('start', '', 'trim');
  1487. $end = input('end', '', 'trim');
  1488. if ($s) {
  1489. $map[] = ['oc.start', '=', $start];
  1490. }
  1491. if ($end) {
  1492. $map[] = ['oc.end', '=', $end];
  1493. }
  1494. $type = input('type', '', 'trim');
  1495. if ($type) {
  1496. $map[] = ['oc.type', '=', $type];
  1497. }
  1498. $xqtime = input('xqtime', '', 'trim');
  1499. $ywctime = input('ywctime', '', 'trim');
  1500. if ($xqtime) {
  1501. $xqtimes = explode(' - ', $xqtime);
  1502. $x1 = date('Ymd', strtotime($xqtimes[0]));
  1503. $x2 = date('Ymd', strtotime($xqtimes[1]));
  1504. $map[] = ['oc.xq_time', '>=', $x1];
  1505. $map[] = ['oc.xq_time', '<=', $x2];
  1506. }else{ // 默认只显示当天的订单
  1507. // $map[] = ['oc.xq_time', '>=', date("Y-m-d")." 00:00:00"];
  1508. $map[] = ['oc.xq_time', '<=', date("Y-m-d")." 23:59:59"];
  1509. }
  1510. if ($ywctime) {
  1511. $ywctimes = explode(' - ', $ywctime);
  1512. $y1 = date('Ymd', strtotime($ywctimes[0]));
  1513. $y2 = date('Ymd', strtotime($ywctimes[1]));
  1514. $map[] = ['oc.ywc_time', '>=', $y1];
  1515. $map[] = ['oc.ywc_time', '<=', $y2];
  1516. }
  1517. $map[] = ['o.del', '=', 0];
  1518. $map[] = ['o.org_id', '=', $this->orgId];
  1519. $map[] = ['o.work_type_mode', '=', 3];
  1520. $map[] = ['o.order_mode', 'in', [1, 4]];
  1521. $status = input('status', '', 'trim');
  1522. $ysName = input('ysname', '');
  1523. if ($ysName) {
  1524. $orders = Db::name('todo')
  1525. ->alias('t')
  1526. ->where('t.org_id', $this->orgId)
  1527. ->where('t.del', 0)
  1528. ->where('t.work_type_mode', 3)
  1529. ->where('t.todo_mode', [1, 2, 4])
  1530. ->where('u.real_name', 'like', '%' . $ysName . '%')
  1531. ->join('orders o', 'o.id = t.order_id')
  1532. ->join('user u', 't.to_user_id = u.id')
  1533. ->group('o.id')
  1534. ->column('o.id');
  1535. if ($orders) {
  1536. $map[] = ['o.id', 'in', $orders];
  1537. }
  1538. else {
  1539. $map[] = ['o.id', '=', 0];
  1540. }
  1541. }
  1542. $map = empty($map) ? true : $map;
  1543. //数据查询
  1544. $lists = db($this->table)->alias('o')
  1545. ->join('order_convey oc', 'oc.order_id=o.id')
  1546. ->field('o.*,oc.type,oc.start,oc.end,oc.xq_time,oc.ywc_time,oc.device_id,oc.name,oc.phone,oc.priority')
  1547. ->where($map)
  1548. ->order(['o.order_mode' => 'asc', 'oc.xq_time' => 'desc'])
  1549. ->select();
  1550. list($newret,$newret1,$newret2,$newret3,$newret4) = $this->model->formatOrderConvey($lists,$status);
  1551. // foreach ($lists as $k => $v) {
  1552. // $v = $this->model->formatOrder($v);
  1553. //
  1554. // $v['bed_number'] = '';
  1555. // $ocp = Db::name('order_convey_patient')
  1556. // ->where('order_id', $v['id'])
  1557. // ->find();
  1558. // $v['bed_number'] = !empty($ocp)?$ocp['bed_number']:'';
  1559. //
  1560. // $todo = Db::name('todo')
  1561. // ->alias('t')
  1562. // ->where('t.order_id', $v['id'])
  1563. // ->join('user u', 'u.id = t.to_user_id')
  1564. // ->where('t.todo_mode', 'in', [1, 2, 3, 4])
  1565. // ->where('t.del', 0)
  1566. // ->field('u.real_name,u.mobile,t.create_time,t.confirm_time')
  1567. // ->order('t.id asc')
  1568. // ->select();
  1569. // $users = [];
  1570. // $confirmtime = '';
  1571. // foreach ($todo as $kk => $vv) {
  1572. // $users[] = $vv['real_name'].($vv['mobile']?'['.$vv['mobile'].']':'');
  1573. // if (!$confirmtime && $vv['confirm_time']) {
  1574. // $confirmtime = $vv['confirm_time'];
  1575. // }
  1576. // else {
  1577. // if ($confirmtime && $vv['confirm_time'] && $vv['confirm_time'] < $confirmtime) {
  1578. // $confirmtime = $vv['confirm_time'];
  1579. // }
  1580. // }
  1581. // }
  1582. // $v['is_todo'] = $todo?1:0;
  1583. // $v['real_names'] = implode(',', $users);
  1584. // $v['confirm_time'] = $confirmtime;
  1585. //
  1586. //
  1587. //
  1588. // $last = strtotime($v['ywc_time']) - time();
  1589. // $v['last_time'] = $last > 0 ? round($last / 60) : 0;
  1590. // //是否有延时
  1591. // $v['delay'] = 0; // 0=未延迟 1=延迟
  1592. // $v['delay_diff'] = 0;
  1593. // $v['delay_reason'] = '';
  1594. // $delays = Db::name('order_delay')
  1595. // ->where('order_id', $v['id'])
  1596. // ->select();
  1597. // $delays = $delays ? $delays : [];
  1598. // foreach ($delays as $vv) {
  1599. // if ($vv['status'] == 0) {
  1600. // $v['delay'] = 1;
  1601. // $v['delay_reason'] = $this->gettablefield('delay_reason', ['id' => $vv['delay_reason_id']], 'title');
  1602. // $vv['diff'] = time() - strtotime($vv['start_time']);
  1603. // }
  1604. // $v['delay_diff'] += $vv['diff'];
  1605. // }
  1606. // $v['delay_diff'] = round($v['delay_diff'] / 60);
  1607. // if ($v['delay'] == 1) {
  1608. // $v['status'] = 3;
  1609. // } else {
  1610. // if ($v['order_mode'] == 1) {
  1611. // $v['status'] = 1;
  1612. // } else {
  1613. // $v['status'] = 2;
  1614. // }
  1615. // }
  1616. // $convey = Db::name('convey_cate')
  1617. // ->alias('oc')
  1618. // ->join('time ot', 'ot.id = oc.time_id')
  1619. // ->where('oc.id', $v['type'])
  1620. // ->field('ot.*')
  1621. // ->find();
  1622. // $xqtime = strtotime($v['xq_time']);
  1623. // $curtime = time();
  1624. // if ($curtime > $xqtime) {
  1625. // $ct = round(($curtime - $xqtime) / 60);
  1626. // if ($ct < $convey['yy_time']) {
  1627. // $ss = 0;
  1628. // }
  1629. // else {
  1630. // if ($ct >= $convey['yy_time'] && $ct < $convey['bz_time']) {
  1631. // $ss = 1;
  1632. // }
  1633. // else {
  1634. // if ($ct >= $convey['bz_time'] && $ct < $convey['jg_time']) {
  1635. // $ss = 2;
  1636. // }
  1637. // else {
  1638. // if ($ct >= $convey['jg_time'] && $ct < $convey['wjjg_time']) {
  1639. // $ss = 3;
  1640. // }
  1641. // else {
  1642. // $ss = 4;
  1643. // }
  1644. // }
  1645. // }
  1646. // }
  1647. // }else{
  1648. // $ss = 0;
  1649. // }
  1650. //
  1651. // $v['ss'] = $ss;
  1652. // $v['xtime'] = date('H:i', strtotime($v['xq_time']));
  1653. // $v['stime'] = $v['send_time'] ? date('H:i', strtotime($v['send_time'])) : "";
  1654. // $v['ctime'] = $v['confirm_time'] ? date('H:i', strtotime($v['confirm_time'])) : "";
  1655. // $v['starttime'] = '';
  1656. // if($v['confirm_time']){ // 如果确认时间不为空
  1657. // $todoconvey = Db::name('todo_convey')
  1658. // ->alias('a')
  1659. // ->join('todo t','t.id = a.todo_id')
  1660. // ->where('t.order_id', $v['id'])
  1661. // ->field('a.*')
  1662. // ->order('a.id asc')
  1663. // ->find();
  1664. // if($todoconvey){
  1665. // $v['starttime'] = date('H:i', strtotime($todoconvey['start_time']));
  1666. // }
  1667. // }
  1668. //
  1669. // $v['priorityName'] = isset($this->model->priority[$v['priority']])?$this->model->priority[$v['priority']]:'';
  1670. // if ($status == 3 && $v['delay'] == 1) { //延时任务
  1671. // $newret[] = $v;
  1672. // $newret1[] = $v;
  1673. // }
  1674. // if ($status == 1 && $v['order_mode'] == 1) { //新任务
  1675. // $newret[] = $v;
  1676. // $newret2[] = $v;
  1677. // }
  1678. // if ($status == 2 && $v['order_mode'] == 4) { // 进行中
  1679. // $newret[] = $v;
  1680. // $newret3[] = $v;
  1681. // }
  1682. // if (!$status || !in_array($status, [1, 2, 3])) {
  1683. // $newret[] = $v;
  1684. // $newret4[] = $v;
  1685. // }
  1686. // $lists[$k] = $v;
  1687. // }
  1688. if (!empty($newret)) {
  1689. $curtime = time();
  1690. $curtime15 = $curtime + 60 * 15;
  1691. $limitTime = date('Y-m-d H:i:s', $curtime15);
  1692. $sortFn = function ($list) {
  1693. if (!$list) return [];
  1694. $list = arraySequence($list, 'status');
  1695. $list = arraySequence($list, 'xtime', 'SORT_DESC');
  1696. return $list;
  1697. };
  1698. $newret2 = $sortFn($newret2);
  1699. $newret3 = $sortFn($newret3);
  1700. $newret1 = $sortFn($newret1);
  1701. $all = array_merge($newret2, $newret3, $newret1);
  1702. $a1 = $a2 = $a3 = [];
  1703. foreach ($newret4 as $v) {
  1704. if ($v['status'] == 3) $a1[] = $v; // 延迟
  1705. elseif ($v['status'] == 1) $a2[] = $v; // 新单
  1706. elseif ($v['status'] == 2) $a3[] = $v; // 进行中
  1707. }
  1708. $a2 = $sortFn($a2);
  1709. $a3 = $sortFn($a3);
  1710. $a1 = $sortFn($a1);
  1711. $filterFn = function ($list) use ($limitTime) {
  1712. $out = [];
  1713. foreach ($list as $v) {
  1714. if ($v['priority'] != 4 && $v['xq_time'] < $limitTime) {
  1715. $out[] = $v;
  1716. }
  1717. }
  1718. return $out;
  1719. };
  1720. $all = array_merge(
  1721. $all,
  1722. $filterFn($a2),
  1723. $filterFn($a3),
  1724. $filterFn($a1)
  1725. );
  1726. $newret = $all;
  1727. }
  1728. $sdd[] =['org_id','=',$this->orgId];
  1729. $sdd[] =['del','=',0];
  1730. $sdd[] =['work_type_mode','=',3];
  1731. $sdd[] =['create_yyyymmdd','=',date('Ymd')];
  1732. $stat = Db::name('orders')
  1733. ->where($sdd)
  1734. ->field("
  1735. SUM(CASE WHEN order_mode = 1 THEN 1 ELSE 0 END) AS dcl,
  1736. SUM(CASE WHEN order_mode = 4 THEN 1 ELSE 0 END) AS ypf,
  1737. SUM(CASE WHEN order_mode IN (5,6) THEN 1 ELSE 0 END) AS ywc,
  1738. SUM(CASE WHEN order_mode IN (2,3) THEN 1 ELSE 0 END) AS yqx
  1739. ")
  1740. ->find();
  1741. $dcl = (int)($stat['dcl'] ?? 0);
  1742. $ypf = (int)($stat['ypf'] ?? 0);
  1743. $ywc = (int)($stat['ywc'] ?? 0);
  1744. $yqx = (int)($stat['yqx'] ?? 0);
  1745. //数据返回
  1746. $totalCount = count($newret);
  1747. $totalPage = ceil($totalCount / $length);
  1748. $result['dcl'] = $dcl;
  1749. $result['ypf'] = $ypf;
  1750. $result['ywc'] = $ywc;
  1751. $result['yqx'] = $yqx;
  1752. $result['page'] = $page;
  1753. $result['total'] = $totalPage;
  1754. $result['records'] = $totalCount;
  1755. $result['rows'] = $newret;
  1756. return json($result);
  1757. }
  1758. else {
  1759. $mode_name = $this->getTableField('work_type_mode', ['id' => $mode], 'name');
  1760. $order_type = (new \app\common\model\ConveyCate())->getList();
  1761. $order_mode = Db::name('order_mode')
  1762. ->select();
  1763. $this->assign('order_type_list', $order_type);
  1764. $this->assign('m_name', $mode_name);
  1765. $this->assign('mode', $mode);
  1766. $this->assign('order_mode_list', $order_mode);
  1767. $this->assign('dispatch_type', check_two_dispatch($this->userId));
  1768. $address = (new \app\common\model\Address())->getListByType(2);
  1769. $this->assign('address', $address);
  1770. $count = Db::name('todo')
  1771. ->where('org_id', $this->orgId)
  1772. ->where('del', 0)
  1773. ->where('work_type_mode', 3)
  1774. ->where('todo_mode', 4)
  1775. ->count();
  1776. $this->assign('count', $count);
  1777. $info = Db::name('config')->where('name','org_order_refresh')
  1778. ->find();
  1779. $orgConfig = Db::name('config_org')
  1780. ->where('config_id',$info['id'])
  1781. ->where('org_id',$this->orgId)
  1782. ->find();
  1783. $value = $orgConfig?$orgConfig['value']:0;
  1784. $this->assign('refresh',$value);
  1785. $sxJg = (new Config())->getConfig('ys_auto_sx',$this->orgId);
  1786. $this->assign('sxJg',$sxJg?$sxJg:30);
  1787. return $this->fetch();
  1788. }
  1789. }
  1790. public function reminder(){
  1791. $id = input('id/d',0);
  1792. $touserids = Db::name('todo')->where('order_id',$id)->where('todo_mode','in',[1,2])->where('del',0)->column('to_user_id');
  1793. if($touserids){
  1794. $touserids = array_unique($touserids);
  1795. send_jpush($touserids,AppMsg::PUSH_WORKER_ORDER_SEND,'您有订单需要处理');
  1796. }
  1797. $this->success('催单成功');
  1798. }
  1799. //运送员状态
  1800. public function conveystatus($id='') {
  1801. if (request()->isAjax()) {
  1802. //分页参数
  1803. $length = input('rows', 10, 'intval'); //每页条数
  1804. $page = input('page', 1, 'intval'); //第几页
  1805. $start = ($page - 1) * $length; //分页开始位置
  1806. //排序
  1807. $sortRow = input('sidx', 'id', 'trim'); //排序列
  1808. $sort = input('sord', 'desc', 'trim'); //排序方式
  1809. $order = $sortRow . ' ' . $sort;
  1810. $real_name = input('real_name', '');
  1811. $map8 = [];
  1812. if ($real_name) {
  1813. $map8[] = ['real_name', 'like', '%'.$real_name.'%'];
  1814. }
  1815. $work = input('work', '');
  1816. if ($work!='') {
  1817. $map8[] = ['work', '=',$work];
  1818. }
  1819. $user = (new \app\common\model\WorkTypeMode())->getRolesUser(3, $this->orgId);
  1820. $newUser = [];
  1821. foreach ($user as $k => $v) {
  1822. foreach ($v['user'] as $k1 => $v1) {
  1823. $newUser[] = $v1['id'];
  1824. }
  1825. }
  1826. $userIds1 = [];
  1827. if($id){
  1828. $ids = explode(',', $id);
  1829. $map[] = ['order_id', 'in', $ids];
  1830. $map[] = ['del', '=', 0];
  1831. $map[] = ['org_id', '=', $this->orgId];
  1832. $map[] = ['work_type_mode', '=', 3];
  1833. $userIds = Db::name('todo')->where($map)->column('to_user_id');
  1834. $userIds1 = $userIds?$userIds:[];
  1835. $newUser = array_intersect($userIds1,$newUser);
  1836. }
  1837. if(empty($newUser)){
  1838. $map8[] = ['id','=',0];
  1839. }else{
  1840. $map8[] = ['id','in',$newUser];
  1841. }
  1842. $mm = [];
  1843. $group = input('group', '');
  1844. if ($group) {
  1845. $uid = Db::name('user_group_user')
  1846. ->where('group_id',$group)
  1847. ->column('user_id');
  1848. if(!empty($uid)){
  1849. $mm[] = ['id','in',$uid];
  1850. }else{
  1851. $mm[] = ['id','in',[-1]];
  1852. }
  1853. }
  1854. $lists = db('user')
  1855. ->where($mm)
  1856. ->where($map8)
  1857. ->limit($start, $length)
  1858. ->order($order)
  1859. ->select();
  1860. foreach ($lists as $key => $value) {
  1861. $lists[$key]['user_group_title'] = Db::name('user_group')
  1862. ->alias('ug')
  1863. ->join('user_group_user ugu','ugu.group_id=ug.id')
  1864. ->where('ugu.user_id',$value['id'])
  1865. ->value('ug.title');
  1866. $nums = Db::name('todo')
  1867. ->where(['to_user_id' => $value['id'], 'work_type_mode' => 3])
  1868. ->where('create_yyyymmdd', date('Ymd'))
  1869. ->where('todo_mode', 'in', [1, 2, 3])
  1870. ->count();
  1871. $lists[$key]['nums'] = $nums;
  1872. $addr = Db::name('order_convey')
  1873. ->alias('cpr')
  1874. ->join('todo os', 'cpr.order_id = os.order_id')
  1875. ->join('orders ods', 'cpr.order_id = ods.id')
  1876. ->join('address ca', 'ca.id = cpr.start')
  1877. ->join('address cad', 'cad.id = cpr.end')
  1878. ->field('os.todo_mode,ca.title as start_name,cad.title as end_name,os.create_time')
  1879. ->where('os.to_user_id', $value['id'])
  1880. ->where('os.del', 0)
  1881. ->where('ods.del', 0)
  1882. ->order('os.id desc')
  1883. ->find();
  1884. $lists[$key]['title'] = '';
  1885. $lists[$key]['addr_time'] = '';
  1886. if($addr){
  1887. if(in_array($addr['todo_mode'],[1,2])){
  1888. $lists[$key]['title'] = $addr['start_name'];
  1889. }else{
  1890. $lists[$key]['title'] = $addr['end_name'];
  1891. }
  1892. $lists[$key]['addr_time'] = $addr['create_time'];
  1893. }
  1894. $lists[$key]['worktxt'] = $value['work'] == 1 ? '上班' : '下班';
  1895. $lists[$key]['stationtxt'] = $value['station'] == 1 ? '驻守' : '取消驻守';
  1896. }
  1897. //数据返回
  1898. // $totalCount = db('user')
  1899. // ->where($map1)->count();
  1900. $totalCount = db('user')
  1901. ->where($map8)->count();
  1902. $totalPage = ceil($totalCount / $length);
  1903. $result['page'] = $page;
  1904. $result['total'] = $totalPage;
  1905. $result['records'] = $totalCount;
  1906. $result['rows'] = $lists;
  1907. return json($result);
  1908. }
  1909. else {
  1910. $group = model('UserGroup')->getList();
  1911. $this->assign('group', $group);
  1912. $this->assign('id', $id);
  1913. return $this->fetch();
  1914. }
  1915. }
  1916. //上下班
  1917. public function work($id) {
  1918. $user = Db::name('user')
  1919. ->where('id', $id)
  1920. ->find();
  1921. $value = $user['work'] == 1 ? 0 : 1;
  1922. $res = Db::name('user')
  1923. ->where('id', $id)
  1924. ->update(['work' => $value, 'update_time' => getTime()]);
  1925. $res ? $this->success('操作成功') : $this->error('操作失败');
  1926. }
  1927. //驻守
  1928. public function station($id) {
  1929. $user = Db::name('user')
  1930. ->where('id', $id)
  1931. ->find();
  1932. $value = $user['station'] == 1 ? 0 : 1;
  1933. $res = Db::name('user')
  1934. ->where('id', $id)
  1935. ->update(['station' => $value, 'update_time' => getTime()]);
  1936. $res ? $this->success('操作成功') : $this->error('操作失败');
  1937. }
  1938. //驳回工单列表
  1939. public function bhTodoList() {
  1940. if (request()->isAjax()) {
  1941. $length = input('rows', 10, 'intval'); //每页条数
  1942. $page = input('page', 1, 'intval'); //第几页
  1943. $start = ($page - 1) * $length; //分页开始位置
  1944. $map[] = ['todo.org_id', '=', $this->orgId];
  1945. $map[] = ['todo.del', '=', 0];
  1946. $map[] = ['todo.todo_mode', '=', 4];
  1947. $map[] = ['todo.work_type_mode', '=', 3];
  1948. $totalCount = Db::name('todo')
  1949. ->alias('todo')
  1950. ->join('orders orders', 'orders.id = todo.order_id')
  1951. ->join('order_convey oc', 'oc.order_id = orders.id')
  1952. ->join('user u', 'u.id = todo.to_user_id')
  1953. ->where($map)
  1954. ->count();
  1955. $totalPage = ceil($totalCount / $length);
  1956. $ret = Db::name('todo')
  1957. ->alias('todo')
  1958. ->join('orders orders', 'orders.id = todo.order_id')
  1959. ->join('order_convey oc', 'oc.order_id = orders.id')
  1960. ->join('user u', 'u.id = todo.to_user_id')
  1961. ->field('orders.*,u.real_name as to_real_name,oc.type,oc.start,oc.end,oc.xq_time,oc.ywc_time,oc.device_id,oc.name,oc.phone,oc.priority,todo.nodo_reason,todo.id,todo.reject_time')
  1962. ->order('oc.xq_time', 'desc')
  1963. ->where($map)
  1964. ->limit($start, $length)
  1965. ->select();
  1966. foreach ($ret as $k => $v) {
  1967. $ret[$k]['start_name'] = $this->gettablefield('address', array('id' => $v['start']), 'title');
  1968. $ret[$k]['end_name'] = $this->gettablefield('address', array('id' => $v['end']), 'title');
  1969. $ret[$k]['type_name'] = $this->gettablefield('convey_cate', array('id' => $v['type']), 'title');
  1970. $ret[$k]['real_name'] = $this->gettablefield('user', array('id' => $v['user_id']), 'real_name');
  1971. $ret[$k]['device_name'] = '';
  1972. if ($v['device_id'] > 0) {
  1973. $ret[$k]['device_name'] = $this->gettablefield('convey_device', array('id' => $v['device_id']), 'title');
  1974. }
  1975. $last = strtotime($v['ywc_time']) - time();
  1976. $ret[$k]['last_time'] = $last > 0 ? round($last / 60) : 0;
  1977. $ret[$k]['reject_time'] = $v['reject_time'] ? date('Y-m-d h:i', strtotime($v['reject_time'])) : '';
  1978. }
  1979. $result['page'] = $page;
  1980. $result['total'] = $totalPage;
  1981. $result['records'] = $totalCount;
  1982. $result['rows'] = $ret;
  1983. return json($result);
  1984. }
  1985. else {
  1986. return $this->fetch();
  1987. }
  1988. }
  1989. //excel导出
  1990. public function export($mode) {
  1991. set_time_limit(0);
  1992. ini_set("memory_limit", "1024M");
  1993. $meta_title = '订单列表';
  1994. if ($mode == 1) {
  1995. $meta_title = '报修' . $meta_title;
  1996. }
  1997. elseif ($mode == 2) {
  1998. $meta_title = '保洁' . $meta_title;
  1999. }
  2000. elseif ($mode == 3) {
  2001. $meta_title = '运送' . $meta_title;
  2002. }
  2003. elseif ($mode == 4) {
  2004. $meta_title = '应急' . $meta_title;
  2005. }
  2006. elseif ($mode == 15) {
  2007. $meta_title = '品质整改' . $meta_title;
  2008. }elseif ($mode == -1) {
  2009. $meta_title = '一键呼叫' . $meta_title;
  2010. }
  2011. $level1 = check_is_dispatch($this->userId);
  2012. $level2 = check_two_dispatch($this->userId);
  2013. $turnoff = two_dispatch_off($this->orgId);
  2014. $quality_type = input('quality_type','');
  2015. if (request()->isGet()) {
  2016. //排序
  2017. $sortRow = input('sidx', 'a.id', 'trim'); //排序列
  2018. $sort = input('sord', 'desc', 'trim'); //排序方式
  2019. $order = $sortRow . ' ' . $sort;
  2020. $content = input('content', '', 'trim');
  2021. if ($content) {
  2022. $map[] = ['a.content', 'like', '%' . $content . '%'];
  2023. }
  2024. $dep_id = input('dep_id', '', 'trim');
  2025. if ($dep_id != '') {
  2026. $map[] = ['a.dep_id', '=', $dep_id];
  2027. }
  2028. $order_mode = input('order_mode', '', 'trim');
  2029. $map6 = [];
  2030. if ($order_mode != '') {
  2031. if($level1 && $turnoff && $mode != 15){ // 一级调度且二级调度开关开着,品质整改例外
  2032. if ($order_mode == 1) {
  2033. $map[] = ['a.is_deal', '=', 0];
  2034. }else if ($order_mode == 4) {
  2035. $map6[] = ['a.is_deal', '=', 1];
  2036. }
  2037. }
  2038. if($order_mode==100){//已挂起
  2039. $gq = Db::name('todo')
  2040. ->where('work_type_mode',1)
  2041. ->where('todo_mode',2)
  2042. ->where('pause',1)
  2043. ->column('order_id');
  2044. if(empty($gq)){
  2045. $map[] = ['a.id', '=', -1];
  2046. }else{
  2047. $map[] = ['a.id', 'in', $gq];
  2048. }
  2049. }else{
  2050. $map[] = ['a.order_mode', '=', $order_mode];
  2051. }
  2052. }
  2053. $b = input('start', '', 'trim');
  2054. $e = input('end', '', 'trim');
  2055. if ($b) {
  2056. // $b = date('Ymd', strtotime($b));
  2057. // $map[] = ['a.create_yyyymmdd', '>=', $b];
  2058. $map[] = ['a.create_time', '>=', $b];
  2059. }
  2060. if ($e) {
  2061. // $e = date('Ymd', strtotime($e));
  2062. // $map[] = ['a.create_yyyymmdd', '<=', $e];
  2063. $map[] = ['a.create_time', '<=', $e];
  2064. }
  2065. $map[] = ['a.del', '=', 0];
  2066. $map[] = ['a.org_id', '=', $this->orgId];
  2067. if($mode==-1){
  2068. $map[] = ['a.source_type', '=', 4];
  2069. }
  2070. $type = input('type', '', 'trim');
  2071. $oids = [];
  2072. if ($type != '') {
  2073. $map1[] = ['parent_id', '=', $type];
  2074. $type_id = Db::name('order_type')
  2075. ->where($map1)
  2076. ->where('org_id', $this->orgId)
  2077. ->where('enable', 1)
  2078. ->column('id');
  2079. if (!empty($type_id)) {
  2080. $map3[] = ['type_id', 'in', $type_id];
  2081. $ids = Db::name('order_repair')
  2082. ->where($map3)
  2083. ->column('order_id');
  2084. if (!empty($ids)) {
  2085. $oids = $ids;
  2086. }
  2087. else {
  2088. $oids = [];
  2089. }
  2090. }
  2091. else {
  2092. $oids = [];
  2093. }
  2094. }
  2095. $typeName = input('typeName', '', 'trim');
  2096. if ($typeName != '') {
  2097. $map_11[] = ['a.title', 'like', '%'.$typeName.'%'];
  2098. $typeNameId = Db::name('convey_cate')
  2099. ->alias('a')
  2100. ->join('order_convey b','a.id=b.type')
  2101. ->where($map_11)
  2102. ->where('a.org_id', $this->orgId)
  2103. ->where('a.enable', 1)
  2104. ->where('a.del', 0)
  2105. ->column('b.order_id');
  2106. if (!empty($typeNameId)) {
  2107. $map[] = ['a.id', 'in', $typeNameId];
  2108. }
  2109. else {
  2110. $map[] = ['a.id', '=', -1];
  2111. }
  2112. }
  2113. if($level2 && $turnoff){ // 二级调度
  2114. $roles_id = Db::name('user_roles')
  2115. ->where('user_id', $this->userId)
  2116. ->value('roles_id');
  2117. $ids = Db::name('dispatch_log')
  2118. ->where('roles_id', $roles_id)
  2119. ->whereOr('to_user_id', $this->userId)
  2120. ->column('order_id');
  2121. if (empty($ids)) {
  2122. $map[] = ['a.id', '=', -1];
  2123. } else {
  2124. if($type != ''){
  2125. $oids = array_intersect($oids,$ids);
  2126. if($oids){
  2127. $map[] = ['a.id', 'in', $oids];
  2128. }else{
  2129. $map[] = ['a.id', '=', -1];
  2130. }
  2131. }else{
  2132. $map[] = ['a.id', 'in', $ids];
  2133. }
  2134. }
  2135. }else{
  2136. if($type != ''){
  2137. if($oids){
  2138. $map[] = ['a.id', 'in', $oids];
  2139. }else{
  2140. $map[] = ['a.id', '=', 0];
  2141. }
  2142. }
  2143. }
  2144. if($mode == 15){ // 品质检查,单独处理
  2145. $map[] = ['a.work_type_mode','=',$mode];
  2146. if($quality_type !=''){
  2147. $map[] = ['a.quality_type','=',$quality_type];
  2148. }
  2149. }else{
  2150. $work_type_mode = input('work_type_mode','','trim');
  2151. if(!is_admin($this->userId)){
  2152. $auth = get_dispatch_auth($this->userId);
  2153. if($auth){
  2154. $map[] = ['a.work_type_mode', 'in', $auth];
  2155. if($mode > 0){
  2156. $map[] = ['a.work_type_mode', '=', $mode];
  2157. }else{
  2158. if($work_type_mode!=''){
  2159. $map[] = ['a.work_type_mode','=',$work_type_mode];
  2160. }
  2161. }
  2162. }else{
  2163. $map[] = ['a.work_type_mode', '=', -1];
  2164. }
  2165. }else{
  2166. if($mode > 0){
  2167. $map[] = ['a.work_type_mode', '=', $mode];
  2168. }else{
  2169. if($work_type_mode!=''){
  2170. $map[] = ['a.work_type_mode','=',$work_type_mode];
  2171. }
  2172. }
  2173. }
  2174. }
  2175. $sn = input('sn', '', 'trim');
  2176. if ($sn) {
  2177. $map[] = ['a.sn', 'like', '%' . $sn . '%'];
  2178. }
  2179. $from = input('from', '', 'trim');
  2180. if ($from) {
  2181. if($from >3){
  2182. $map[] = ['a.from','=',0];
  2183. $map[] = ['a.work_type_mode','=',$from-3];
  2184. }else{
  2185. $map[] = ['a.from','=',$from];
  2186. }
  2187. }
  2188. $dep_cate = input('dep_cate', '', 'trim');
  2189. if ($dep_cate != '') {
  2190. $depIds = Db::name('dep')
  2191. ->where('org_id',$this->orgId)
  2192. ->where('cate_id',$dep_cate)
  2193. ->where('del',0)
  2194. ->column('id');
  2195. if(!empty($depIds)){
  2196. $map[] = ['a.dep_id', 'in', $depIds];
  2197. }else{
  2198. $map[] = ['a.dep_id', '=', -1];
  2199. }
  2200. }
  2201. $priority = input('priority', '', 'trim');
  2202. if($priority !=''){
  2203. $map[] = ['b.priority', '=',$priority];
  2204. }
  2205. $sddr = input('saddr','','trim');
  2206. if($sddr !=''){
  2207. $map[] = ['b.start','=',$sddr];
  2208. }
  2209. $eddr = input('eaddr','','trim');
  2210. if($eddr !=''){
  2211. $map[] = ['b.end','=',$eddr];
  2212. }
  2213. $toUserName = input('toUserName','','trim');
  2214. if($toUserName !=''){
  2215. $ooids = Db::name('user')
  2216. ->alias('u')
  2217. ->join('todo t','t.to_user_id=u.id')
  2218. ->where('t.del',0)
  2219. ->where('t.org_id',$this->orgId)
  2220. ->where('u.real_name',$toUserName)
  2221. ->column('t.order_id');
  2222. if($ooids){
  2223. $map[] = ['a.id','in',$ooids];
  2224. }else{
  2225. $map[] = ['a.id','=',-1];
  2226. }
  2227. }
  2228. $conveyCateId = input('conveyCateId','','trim');
  2229. if($conveyCateId !=''){
  2230. $typeNameId = Db::name('convey_cate')
  2231. ->alias('a')
  2232. ->join('order_convey b','a.id=b.type')
  2233. ->where('a.org_id', $this->orgId)
  2234. ->where('a.enable', 1)
  2235. ->where('a.del', 0)
  2236. ->where('a.id', $conveyCateId)
  2237. ->column('b.order_id');
  2238. if (!empty($typeNameId)) {
  2239. $map[] = ['a.id', 'in', $typeNameId];
  2240. }else {
  2241. $map[] = ['a.id', '=', -1];
  2242. }
  2243. }
  2244. $deviceId = input('device_id',0);
  2245. if($deviceId){
  2246. $map[] = ['b.device_id','=',$deviceId];
  2247. }
  2248. $map = empty($map) ? true : $map;
  2249. //数据查询
  2250. if($mode==3){
  2251. $lists = db($this->table)->where($map)
  2252. ->alias('a')
  2253. ->leftJoin('order_convey b','a.id=b.order_id')
  2254. ->leftJoin('address ad','b.start=ad.id')
  2255. ->leftJoin('address ade','b.end=ade.id')
  2256. ->leftJoin('convey_cate cc','b.type=cc.id')
  2257. ->leftJoin('convey_device cd','b.device_id=cd.id')
  2258. ->leftJoin('dep dp','a.dep_id=dp.id')
  2259. // ->leftJoin('dep_cate dc','dp.cate_id=dc.id')
  2260. ->leftJoin('order_mode om','a.order_mode=om.id')
  2261. ->field('a.*,om.in_content as order_mode_text,dp.title as dep,cd.title as device_name,cc.title as type_name,b.priority,ad.title as start_name,ade.title as end_name')
  2262. ->whereOr($map6)
  2263. ->order($order)
  2264. ->select();
  2265. foreach ($lists as $k => $v) {
  2266. // $lists[$k] = $this->model->newFormatOrder($v);
  2267. $content = removeEmojiChar($v['content']);
  2268. $lists[$k]['content'] = preg_replace('/[^\p{L}\p{N}\p{P}\p{Z}^\n]/u', '', $content);
  2269. $lists[$k]['priority'] = isset($this->model->priority[$v['priority']])?$this->model->priority[$v['priority']]:"";
  2270. $lists[$k]['task_priority'] = $v['priority']==3?2:0;
  2271. $lists[$k]['source_type_text'] =$v['from']>0? isset($this->model->source_type[$v['from']])?$this->model->source_type[$v['from']]:'':$this->getTableField('work_type_mode', ['id' => $v['work_type_mode']], 'name');
  2272. if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
  2273. $lists[$k]['order_mode_text'] = '已派发';
  2274. }
  2275. }
  2276. }else{
  2277. $lists = db($this->table)->where($map)
  2278. ->alias('a')
  2279. ->leftJoin('order_convey b','a.id=b.order_id')
  2280. ->field('a.*,b.priority')
  2281. ->whereOr($map6)
  2282. ->order($order)->select();
  2283. foreach ($lists as $k => $v) {
  2284. $lists[$k] = $this->model->newFormatOrder($v);
  2285. $content = removeEmojiChar($v['content']);
  2286. $lists[$k]['content'] = preg_replace('/[^\p{L}\p{N}\p{P}\p{Z}^\n]/u', '', $content);
  2287. $lists[$k]['priority'] = isset($this->model->priority[$v['priority']])?$this->model->priority[$v['priority']]:"";
  2288. if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
  2289. $lists[$k]['order_mode_text'] = '已派发';
  2290. }
  2291. }
  2292. }
  2293. include_once env('root_path') . '/extend/phpexcel/Classes/PHPExcel.php';
  2294. //实例化PHPExcel类
  2295. $objPHPExcel = new \PHPExcel();
  2296. //激活当前的sheet表
  2297. $objPHPExcel->setActiveSheetIndex(0);
  2298. //设置表格头(即excel表格的第一行)
  2299. if ($mode == 1) {
  2300. $objPHPExcel->setActiveSheetIndex(0)
  2301. ->setCellValue('A1', '编号')
  2302. ->setCellValue('B1', '申请时间')
  2303. ->setCellValue('C1', '内容')
  2304. ->setCellValue('D1', '所在科室/部门')
  2305. ->setCellValue('E1', '报修类型')
  2306. ->setCellValue('F1', '状态')
  2307. ->setCellValue('G1', '紧急程度')
  2308. ->setCellValue('H1', '来源')
  2309. ->setCellValue('I1', '物料名称')
  2310. ->setCellValue('J1', '单价')
  2311. ->setCellValue('K1', '数量')
  2312. ->setCellValue('L1', '总价');
  2313. }
  2314. else {
  2315. if ($mode == 3) {
  2316. $objPHPExcel->setActiveSheetIndex(0)
  2317. ->setCellValue('A1', '编号')
  2318. ->setCellValue('B1', '申请时间')
  2319. ->setCellValue('C1', '开始地点')
  2320. ->setCellValue('D1', '结束地点')
  2321. ->setCellValue('E1', '运送类型')
  2322. ->setCellValue('F1', '任务备注')
  2323. ->setCellValue('G1', '所在科室/部门')
  2324. ->setCellValue('H1', '状态')
  2325. ->setCellValue('I1', '来源')
  2326. ->setCellValue('J1', '优先级');
  2327. }
  2328. else {
  2329. if($mode==0){
  2330. $objPHPExcel->setActiveSheetIndex(0)
  2331. ->setCellValue('A1', '编号')
  2332. ->setCellValue('B1', '申请时间')
  2333. ->setCellValue('C1', '内容')
  2334. ->setCellValue('D1', '所在科室/部门')
  2335. ->setCellValue('E1', '状态')
  2336. ->setCellValue('F1', '订单类型')
  2337. ->setCellValue('G1', '来源');
  2338. }else{
  2339. if($mode==15){
  2340. $objPHPExcel->setActiveSheetIndex(0)
  2341. ->setCellValue('A1', '编号')
  2342. ->setCellValue('B1', '申请时间')
  2343. ->setCellValue('C1', '内容')
  2344. ->setCellValue('D1', '所在科室/部门')
  2345. ->setCellValue('E1', '状态')
  2346. ->setCellValue('F1', '来源')
  2347. ->setCellValue('H1', '部门分类');
  2348. }else{
  2349. $objPHPExcel->setActiveSheetIndex(0)
  2350. ->setCellValue('A1', '编号')
  2351. ->setCellValue('B1', '申请时间')
  2352. ->setCellValue('C1', '内容')
  2353. ->setCellValue('D1', '所在科室/部门')
  2354. ->setCellValue('E1', '状态')
  2355. ->setCellValue('F1', '来源');
  2356. }
  2357. }
  2358. }
  2359. }
  2360. // 设置表格头水平居中
  2361. $objPHPExcel->setActiveSheetIndex(0)->getStyle('A1')->getAlignment()
  2362. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2363. $objPHPExcel->setActiveSheetIndex(0)->getStyle('B1')->getAlignment()
  2364. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2365. $objPHPExcel->setActiveSheetIndex(0)->getStyle('C1')->getAlignment()
  2366. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2367. $objPHPExcel->setActiveSheetIndex(0)->getStyle('D1')->getAlignment()
  2368. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2369. $objPHPExcel->setActiveSheetIndex(0)->getStyle('E1')->getAlignment()
  2370. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2371. $objPHPExcel->setActiveSheetIndex(0)->getStyle('F1')->getAlignment()
  2372. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2373. $objPHPExcel->setActiveSheetIndex(0)->getStyle('G1')->getAlignment()
  2374. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2375. $objPHPExcel->setActiveSheetIndex(0)->getStyle('H1')->getAlignment()
  2376. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2377. //设置列水平居中
  2378. $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()
  2379. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2380. $objPHPExcel->setActiveSheetIndex(0)->getStyle('B')->getAlignment()
  2381. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2382. $objPHPExcel->setActiveSheetIndex(0)->getStyle('C')->getAlignment()
  2383. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2384. $objPHPExcel->setActiveSheetIndex(0)->getStyle('D')->getAlignment()
  2385. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2386. $objPHPExcel->setActiveSheetIndex(0)->getStyle('E')->getAlignment()
  2387. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2388. $objPHPExcel->setActiveSheetIndex(0)->getStyle('F')->getAlignment()
  2389. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2390. $objPHPExcel->setActiveSheetIndex(0)->getStyle('G')->getAlignment()
  2391. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2392. $objPHPExcel->setActiveSheetIndex(0)->getStyle('H')->getAlignment()
  2393. ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  2394. //设置单元格宽度
  2395. $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(10);
  2396. $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(20);
  2397. $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(20);
  2398. $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(20);
  2399. $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(20);
  2400. $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('F')->setWidth(50);
  2401. $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('G')->setWidth(20);
  2402. $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('H')->setWidth(20);
  2403. //循环刚取出来的数组,将数据逐一添加到excel表格。
  2404. if ($mode == 1) {
  2405. // halt($lists);
  2406. for ($i = 0; $i < count($lists); $i++) {
  2407. $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
  2408. $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
  2409. $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['content']);
  2410. $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['dep']);
  2411. $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['order_type']);
  2412. $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['order_mode_text']);
  2413. $objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 2), $lists[$i]['repair_priority']);
  2414. $objPHPExcel->getActiveSheet()->setCellValue('H' . ($i + 2), $lists[$i]['source_type_text']);
  2415. $goodsName = $goodsPrice = $goodsNum = $goodsTotal = '';
  2416. if(empty($lists[$i]['cons'])){
  2417. $objPHPExcel->getActiveSheet()->setCellValue('I' . ($i + 2), "");
  2418. $objPHPExcel->getActiveSheet()->setCellValue('J' . ($i + 2), "");
  2419. $objPHPExcel->getActiveSheet()->setCellValue('K' . ($i + 2), "");
  2420. $objPHPExcel->getActiveSheet()->setCellValue('L' . ($i + 2), "");
  2421. }else{
  2422. $objPHPExcel->getActiveSheet()->getStyle('I'.($i + 2))->getAlignment()->setWrapText(true);
  2423. $objPHPExcel->getActiveSheet()->getStyle('J'.($i + 2))->getAlignment()->setWrapText(true);
  2424. $objPHPExcel->getActiveSheet()->getStyle('K'.($i + 2))->getAlignment()->setWrapText(true);
  2425. $objPHPExcel->getActiveSheet()->getStyle('L'.($i + 2))->getAlignment()->setWrapText(true);
  2426. foreach ($lists[$i]['cons'] as $kk=>$vv){
  2427. // $consstr[] = $vv['title'].'_'.$vv['total'].'_'.$vv['money']."_".$vv['total_money']."_".$vv['realName'];
  2428. $goodsName.= $vv['title']."\r\n";
  2429. $goodsPrice.= $vv['money']."\r\n";
  2430. $goodsNum.= $vv['total']."\r\n";
  2431. $goodsTotal.= $vv['total_money']."\r\n";
  2432. }
  2433. $objPHPExcel->getActiveSheet()->setCellValue('I' . ($i + 2), $goodsName);
  2434. $objPHPExcel->getActiveSheet()->setCellValue('J' . ($i + 2), $goodsPrice);
  2435. $objPHPExcel->getActiveSheet()->setCellValue('K' . ($i + 2), $goodsNum);
  2436. $objPHPExcel->getActiveSheet()->setCellValue('L' . ($i + 2), $goodsTotal);
  2437. }
  2438. }
  2439. }
  2440. else {
  2441. if ($mode == 3) {
  2442. for ($i = 0; $i < count($lists); $i++) {
  2443. $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
  2444. $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
  2445. $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['start_name']);
  2446. $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['end_name']);
  2447. $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['type_name']);
  2448. $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['content']);
  2449. $objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 2), $lists[$i]['dep']);
  2450. $objPHPExcel->getActiveSheet()->setCellValue('H' . ($i + 2), $lists[$i]['order_mode_text']);
  2451. $objPHPExcel->getActiveSheet()->setCellValue('I' . ($i + 2), $lists[$i]['source_type_text']);
  2452. $objPHPExcel->getActiveSheet()->setCellValue('J' . ($i + 2), $lists[$i]['priority']);
  2453. }
  2454. }
  2455. else {
  2456. if($mode==0){
  2457. for ($i = 0; $i < count($lists); $i++) {
  2458. $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
  2459. $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
  2460. $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['content']);
  2461. $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['dep']);
  2462. $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['order_mode_text']);
  2463. $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['work_type_mode_text']);
  2464. $objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 2), $lists[$i]['source_type_text']);
  2465. }
  2466. }else{
  2467. if($mode==15){
  2468. for ($i = 0; $i < count($lists); $i++) {
  2469. $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
  2470. $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
  2471. $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['content']);
  2472. $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['dep']);
  2473. $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['order_mode_text']);
  2474. $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['source_type_text']);
  2475. $objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 2), $lists[$i]['quality_cate_name']);
  2476. }
  2477. }else{
  2478. for ($i = 0; $i < count($lists); $i++) {
  2479. $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
  2480. $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
  2481. $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['content']);
  2482. $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['dep']);
  2483. $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['order_mode_text']);
  2484. $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['source_type_text']);
  2485. }
  2486. }
  2487. }
  2488. }
  2489. }
  2490. //设置保存的Excel表格名称
  2491. $filename = $meta_title . '_' . date('YmdHis', time()) . '.xls';
  2492. //设置当前激活的sheet表格名称
  2493. $objPHPExcel->getActiveSheet()->setTitle($meta_title);
  2494. //设置浏览器窗口下载表格
  2495. ob_end_clean();
  2496. header("Content-Type: application/force-download");
  2497. header("Content-Type: application/octet-stream");
  2498. header("Content-Type: application/download");
  2499. header('Content-Disposition:inline;filename="' . $filename);
  2500. //生成excel文件
  2501. $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  2502. //下载文件在浏览器窗口
  2503. return $objWriter->save('php://output');
  2504. }
  2505. }
  2506. public function rejectTodoList(){
  2507. $orderId = input('orderId',0);
  2508. if (request()->isAjax()) {
  2509. $length = input('rows', 10, 'intval'); //每页条数
  2510. $page = input('page', 1, 'intval'); //第几页
  2511. $start = ($page - 1) * $length; //分页开始位置
  2512. $map[] = ['org_id','=',$this->orgId];
  2513. $map[] = ['del','=',0];
  2514. $map[] = ['todo_mode','=',4];
  2515. $map[] = ['order_id','=',$orderId];
  2516. $lists = Db::name('todo')
  2517. ->where($map)
  2518. ->limit($start,$length)
  2519. ->order('id desc')
  2520. ->select();
  2521. $workTypeMode = [
  2522. '0'=>'一键呼叫',
  2523. '1'=>'报修',
  2524. '2'=>'保洁',
  2525. '3'=>'运送',
  2526. '4'=>'应急',
  2527. ];
  2528. foreach ($lists as $k=>$v){
  2529. $lists[$k]['to_user_name'] = Db::name('user')->where('id',$v['to_user_id'])->value('real_name');
  2530. $lists[$k]['work_type_mode_text'] = $workTypeMode[$v['work_type_mode']];
  2531. $lists[$k]['todo_mode_in_content'] = Db::name('todo_mode')->where('id',$v['todo_mode'])->value('in_content');
  2532. $lists[$k]['todo_mode_color'] = Db::name('todo_mode')->where('id',$v['todo_mode'])->value('color');
  2533. }
  2534. $totalCount = Db::name('todo')
  2535. ->where($map)
  2536. ->count();
  2537. $totalPage = ceil($totalCount / $length);
  2538. $result['page'] = $page;
  2539. $result['total'] = $totalPage;
  2540. $result['records'] = $totalCount;
  2541. $result['rows'] = $lists;
  2542. return json($result);
  2543. }
  2544. else {
  2545. $this->assign('orderId',$orderId);
  2546. return $this->fetch();
  2547. }
  2548. }
  2549. public function orderRefreshOff(){
  2550. $info = Db::name('config')->where('name','org_order_refresh')
  2551. ->find();
  2552. $orgConfig = Db::name('config_org')
  2553. ->where('config_id',$info['id'])
  2554. ->where('org_id',$this->orgId)
  2555. ->find();
  2556. if($orgConfig){
  2557. $value = $orgConfig['value']==1?0:1;
  2558. $res = Db::name('config_org')
  2559. ->where('config_id',$info['id'])
  2560. ->where('org_id',$this->orgId)
  2561. ->update(['value'=>$value]);
  2562. }else{
  2563. $value = 1;
  2564. $res = Db::name('config_org')
  2565. ->insertGetId([
  2566. 'config_id'=>$info['id'],
  2567. 'org_id'=>$this->orgId,
  2568. 'value'=>$value,
  2569. ]);
  2570. }
  2571. $res?$this->success('操作成功','',['status'=>$value]):$this->error('操作失败');
  2572. }
  2573. public function bhTodoCount()
  2574. {
  2575. $count = Db::name('todo')
  2576. ->where('org_id', $this->orgId)
  2577. ->where('del', 0)
  2578. ->where('work_type_mode', 3)
  2579. ->where('todo_mode', 4)
  2580. ->count() ?? 0;
  2581. $this->success('操作成功','',['count'=>$count]);
  2582. }
  2583. public function print1($id){
  2584. $order = Db::name('orders')->where(['id' => $id])->find();
  2585. $depName = Db::name('dep')
  2586. ->where('id',$order['dep_id'])
  2587. ->value('title');
  2588. $info['depName'] = $depName;
  2589. $info['create_time'] = $order['create_time'];
  2590. $users = Db::name('todo')
  2591. ->alias('t')
  2592. ->join('user u','u.id=t.to_user_id')
  2593. ->where('t.order_id',$order['id'])
  2594. ->column('u.real_name');
  2595. $info['users'] = $users?implode(',',$users):'';
  2596. $info['content'] = $order['content'];
  2597. $info['cons'] = [];
  2598. $tList = Db::name('todo')
  2599. ->where('order_id',$order['id'])
  2600. ->select();
  2601. $total = $totalPrice = 0;
  2602. $signs = [];
  2603. foreach ($tList as $k=>$v){
  2604. if($v['sign']){
  2605. $signs[] = $v['sign'];
  2606. }
  2607. $mate = Db::name('todo_mate_item')
  2608. ->alias('tmi')
  2609. ->join('todo_mate tm','tmi.todo_mate_id = tm.id')
  2610. ->join('mate_goods mg','mg.id = tmi.items_id')
  2611. ->field('tmi.items_id,tmi.total,tmi.money,tmi.total_money,mg.title')
  2612. ->where('tm.todo_id',$v['id'])
  2613. ->select();
  2614. if(!empty($mate)){
  2615. foreach ($mate as $kk=>$todo_mate){
  2616. $info['cons'][] = [
  2617. 'title' =>$todo_mate['title'],
  2618. 'total' =>$todo_mate['total'],
  2619. 'money' =>$todo_mate['money'],
  2620. 'total_money' =>$todo_mate['total_money'],
  2621. ];
  2622. $total +=$todo_mate['total'];
  2623. $totalPrice +=$todo_mate['total_money'];
  2624. }
  2625. }
  2626. }
  2627. $aa = [
  2628. 'title'=>'',
  2629. 'total'=>'',
  2630. 'money'=>'',
  2631. 'total_money'=>'',
  2632. ];
  2633. if(empty($info['cons'])){
  2634. for ($i=1;$i<=4;$i++){
  2635. $info['cons'][] = $aa;
  2636. }
  2637. }elseif (count($info['cons']) <4){
  2638. $ii = 4-count($info['cons']);
  2639. for ($i=1;$i<=$ii;$i++){
  2640. $info['cons'][] = $aa;
  2641. }
  2642. }
  2643. $info['total'] = $total;
  2644. $info['totalPrice'] = round($totalPrice,2);
  2645. $info['signs'] = $signs;
  2646. $this->assign('info', $info);
  2647. return $this->fetch();
  2648. }
  2649. public function withdraw(){
  2650. $id = input('id');
  2651. $info = Db::name('orders')
  2652. ->where('id',$id)
  2653. ->where('del',0)
  2654. ->where('order_mode',4)
  2655. ->find();
  2656. if(!$info){
  2657. $this->error('参数错误');
  2658. }
  2659. $saveOrder = Db::name('orders')
  2660. ->where('id',$id)
  2661. ->update(['order_mode'=>1,'withdraw_time'=>getTime()]);
  2662. $saveTodo = Db::name('todo')
  2663. ->where('order_id',$id)
  2664. ->update(['del'=>1]);
  2665. $todoIds = Db::name('todo')
  2666. ->where('order_id',$id)
  2667. ->where('todo_mode',1)
  2668. ->column('id');
  2669. $task = Db::name('task')
  2670. ->where('type',1)
  2671. ->whereIn('bus_id',$todoIds)
  2672. ->delete();
  2673. if($info['work_type_mode'] == 3){
  2674. Db::name('order_convey_end')->where('order_id',$info['id'])->setField('del',0);
  2675. }
  2676. if(!$saveOrder){
  2677. $this->error('操作失败');
  2678. }
  2679. $this->success('操作成功');
  2680. }
  2681. public function autoSend($id,$form=0) {
  2682. if(request()->isGet() && $form==0){
  2683. $order_type = (new \app\common\model\OrderType())->getList();
  2684. $order_repair = Db::name('order_repair')
  2685. ->where('order_id', $id)
  2686. ->find();
  2687. $this->assign('order_repair', $order_repair);
  2688. $this->assign('order_type_list',$order_type);
  2689. $this->assign('id',$id);
  2690. return $this->fetch();
  2691. }else{
  2692. $type_id = input('type_id/d','');
  2693. if(!empty($type_id)){
  2694. $old = Db::name('order_repair')
  2695. ->where('order_id', $id)
  2696. ->find();
  2697. $rData['type_id'] = $type_id;
  2698. if ($old) {
  2699. $rData['update_time'] = getTime();
  2700. Db::name('order_repair')
  2701. ->where('order_id', $id)
  2702. ->update($rData);
  2703. }
  2704. else {
  2705. $rData['order_id'] = $id;
  2706. Db::name('order_repair')
  2707. ->insert($rData);
  2708. }
  2709. }
  2710. $res = $this->model->autoSend($id);
  2711. if (!$res) {
  2712. $this->error($this->model->getError());
  2713. }
  2714. $this->success('操作成功');
  2715. }
  2716. }
  2717. public function setType($id) {
  2718. if(request()->isGet()){
  2719. $order_type = (new \app\common\model\OrderType())->getList();
  2720. $order_repair = Db::name('order_repair')
  2721. ->where('order_id', $id)
  2722. ->find();
  2723. $this->assign('order_repair', $order_repair);
  2724. $this->assign('order_type_list',$order_type);
  2725. $this->assign('id',$id);
  2726. return $this->fetch();
  2727. }else{
  2728. $type_id = input('type_id/d','');
  2729. if(empty($type_id)){
  2730. $this->error('请选择报修事项');
  2731. }
  2732. $old = Db::name('order_repair')
  2733. ->where('order_id', $id)
  2734. ->find();
  2735. $rData['type_id'] = $type_id;
  2736. if ($old) {
  2737. $rData['update_time'] = getTime();
  2738. $r = Db::name('order_repair')
  2739. ->where('order_id', $id)
  2740. ->update($rData);
  2741. }
  2742. else {
  2743. $rData['order_id'] = $id;
  2744. $r = Db::name('order_repair')
  2745. ->insert($rData);
  2746. }
  2747. $r?$this->success('操作成功'):$this->error('操作失败');
  2748. }
  2749. }
  2750. public function batchSb(){
  2751. $id = input('ids',[]);
  2752. if(!$id){
  2753. $this->error('参数错误');
  2754. }
  2755. $res = db('user')->where('id','in',$id)->setField('work',1);
  2756. if($res){
  2757. $this->success('操作成功');
  2758. }else{
  2759. $this->error('操作失败');
  2760. }
  2761. }
  2762. public function batchXb(){
  2763. $id = input('ids',[]);
  2764. if(!$id){
  2765. $this->error('参数错误');
  2766. }
  2767. $res = db('user')->where('id','in',$id)->setField('work',0);
  2768. if($res){
  2769. $this->success('操作成功');
  2770. }else{
  2771. $this->error('操作失败');
  2772. }
  2773. }
  2774. public function getTime(){
  2775. $type = input('type');
  2776. $start = input('start');
  2777. $v = Db::name('convey_cate')
  2778. ->where('id',$type)
  2779. ->where('enable',1)
  2780. ->where('del',0)
  2781. ->find();
  2782. if($v['time_id'] > 0){
  2783. $time = Db::name('time')
  2784. ->where('id',$v['time_id'])
  2785. ->find();
  2786. $v['xq_time'] = $start?$start:date('Y-m-d H:i');
  2787. $v['ywc_time'] = date('Y-m-d H:i',strtotime($v['xq_time']) + 60*$time['bz_time']);
  2788. }else{
  2789. $v['xq_time'] = $start?$start:date('Y-m-d H:i');
  2790. $v['ywc_time'] = '';
  2791. }
  2792. $this->success('','',$v);
  2793. }
  2794. }