WasteRecord.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916
  1. <?php
  2. namespace app\common\model;
  3. use function PHPSTORM_META\map;
  4. use think\Db;
  5. use think\Exception;
  6. class WasteRecord extends Base {
  7. public $table = 'waste_record';
  8. protected $validateName = 'WasteRecord';
  9. public $status = [
  10. '已收取',
  11. '已交接',
  12. '已转运',
  13. '医废异常',
  14. '未转运',
  15. ];
  16. /**
  17. * 医废记录详情
  18. *
  19. * @author wst
  20. * @date 2021/9/8 17:32
  21. * @return array
  22. */
  23. public function info($id,$orgId){
  24. $info = $this->getOne($id,$orgId);
  25. if($info){
  26. $info['real_name'] = Db::name('user')
  27. ->where('id',$info['user_id'])
  28. ->value('real_name');
  29. $info['waste_device'] = Db::name('address')
  30. ->where('id',$info['waste_device_id'])
  31. ->value('title');
  32. $info['cate'] = Db::name('waste_type')
  33. ->where('id',$info['cateid'])
  34. ->value('title');
  35. $info['weight'] =round($info['weight']/1000,2);
  36. $info['status'] =$this->status[$info['status']];
  37. $rlist = Db::name('waste_record_user')
  38. ->alias('waste_record_user')
  39. ->join('user user','user.id = waste_record_user.user_id')
  40. ->where('waste_record_user.waste_record_id',$info['id'])
  41. ->field('waste_record_user.*,user.real_name')
  42. ->order('status', 'asc')
  43. ->select();
  44. $info['rlist'] = $rlist?$rlist:array();
  45. $info = json_decode(json_encode($info),true);
  46. }
  47. return $info;
  48. }
  49. //转运
  50. public function finish($id,$user_id){
  51. $this->startTrans();
  52. try{
  53. $ret = $this
  54. ->where('id', $id)
  55. ->update(['status'=>2]);
  56. if(!$ret){
  57. throw new Exception('更新状态失败');
  58. }
  59. $ret2 = Db::name('waste_record_user')->insert(array(
  60. 'waste_record_id' => $id,
  61. 'user_id' => $user_id,
  62. 'status' => 2,
  63. 'create_time' => getTime()
  64. ));
  65. if(!$ret2){
  66. throw new exception('保存操作记录失败');
  67. }
  68. $this->commit();
  69. return true;
  70. }catch (exception $e){
  71. $this->rollback();
  72. $this->error=$e->getMessage();
  73. return false;
  74. }
  75. }
  76. public function getOne($id,$orgId=0){
  77. $info = $this
  78. ->where('id',$id)
  79. ->where('org_id',$orgId)
  80. ->whereOr('serial_number',$id)
  81. ->find()
  82. ->toArray();
  83. return $info;
  84. }
  85. /*----------------api----------------*/
  86. public function recordInfo($serialNum,$orgId){
  87. $map[] = ['serial_number','=',$serialNum];
  88. $map[] = ['org_id','=',$orgId];
  89. $map[] = ['del','=',0];
  90. $info = $this->field('id,serial_number,org_id,waste_device_id,user_id,cateid,weight,status,create_time,reason,is_print,weight2')
  91. ->where($map)->find();
  92. $info = $info?$info->toArray():[];
  93. if(!$info){
  94. $this->error = '记录不存在';
  95. return false;
  96. }
  97. $org = Db::name('org')
  98. ->where('id',$info['org_id'])
  99. ->field('name')->find();
  100. $info['org_name'] = $org?$org['name']:'';
  101. $user = Db::name('user')
  102. ->where('id',$info['user_id'])
  103. ->field('real_name')->find();
  104. $info['real_name'] = $user?$user['real_name']:'';
  105. $wasteDevice = Db::name('address')
  106. ->where('id',$info['waste_device_id'])
  107. ->field('title')
  108. ->find();
  109. $info['title'] = $wasteDevice?$wasteDevice['title']:'';
  110. $info['cate_id'] = $info['cateid'];
  111. $info['cate_name'] =Db::name('waste_type')
  112. ->where('id',$info['cateid'])->value('title');
  113. unset($info['cateid']);
  114. $lists = Db::name('waste_record_user')
  115. ->alias('wru')
  116. ->where('wru.waste_record_id',$info['id'])
  117. ->join('user u','u.id = wru.user_id')
  118. ->field('u.real_name,wru.status,wru.create_time')
  119. ->order('wru.id asc')
  120. ->select();
  121. $data = [
  122. 'type' => 1, // 1=医废记录详情 2=医废包详情
  123. 'info' => $info,
  124. 'status_list' => $lists?$lists:[]
  125. ];
  126. return $data;
  127. }
  128. public function queryIsPrint($id){
  129. $ret=$this
  130. ->where('id',$id)
  131. ->field('is_print')
  132. ->find()->toArray();
  133. return $ret;
  134. }
  135. public function wasteRecordList($orgId,$status,$createTime,$page,$size){
  136. $offset= ($page - 1) * $size;
  137. $starttime=$createTime.' 00:00:00';
  138. $endtime=$createTime.' 23:59:59';
  139. $where[] = ['create_time','between',[$starttime,$endtime]];
  140. $list=$this
  141. ->field('waste_device_id,cateid,create_time,is_print,serial_number,id,weight')
  142. ->where([
  143. 'org_id'=>$orgId,
  144. 'status'=>$status,
  145. 'del'=>0,
  146. ])
  147. ->where($where)
  148. ->order('id desc')
  149. ->limit($offset,$size)
  150. ->select()->toArray();
  151. $ret['list']=$list;
  152. foreach ($list as $k=>$v){
  153. $title=Db::name('address')
  154. ->where([
  155. 'id'=>$v['waste_device_id'],
  156. 'del'=>0,
  157. 'enable'=>1,
  158. ])->value('title');
  159. $ret['list'][$k]['title']= $title;
  160. $cate = Db::name('waste_type')
  161. ->where('id',$v['cateid'])
  162. ->value('title');
  163. $ret['list'][$k]['cate_title']= $cate;
  164. }
  165. return $ret;
  166. }
  167. public function unTransportList($orgId,$createTime){
  168. $where = [];
  169. if($createTime){
  170. $starttime=$createTime.' 00:00:00';
  171. $endtime=$createTime.' 23:59:59';
  172. $where[] = ['create_time','between',[$starttime,$endtime]];
  173. }
  174. $list=$this
  175. ->field('waste_device_id,cateid,create_time,is_print,serial_number,id,weight')
  176. ->where('org_id',$orgId)
  177. ->where('del',0)
  178. ->where($where)
  179. ->where('status','in',[0,1])
  180. ->order('id','desc')
  181. ->select()
  182. ->toArray();
  183. $ret['list']=$list;
  184. foreach ($list as $k=>$v){
  185. $title=Db::name('address')
  186. ->where([
  187. 'id'=>$v['waste_device_id'],
  188. 'del'=>0,
  189. 'enable'=>1,
  190. ])->value('title');
  191. $ret['list'][$k]['title']= $title;
  192. $cate =Db::name('waste_type')
  193. ->where('id',$v['cateid'])
  194. ->value('title');;
  195. $ret['list'][$k]['cate_title']= $cate;
  196. }
  197. return $ret;
  198. }
  199. public function saveRecord($data){
  200. $curtime = getTime();
  201. $data['serial_number'] = get_unique_id();
  202. // if(!$data['create_time']){
  203. // $data['create_time'] = $curtime;
  204. // }
  205. $data['create_time'] = $curtime;
  206. $data['create_yyyy'] = date('Y',strtotime($data['create_time']));
  207. $data['create_yyyymm'] = date('Ym',strtotime($data['create_time']));
  208. $data['create_yyyymmdd'] = date('Ymd',strtotime($data['create_time']));
  209. $this->startTrans();
  210. try{
  211. $waste_record_id = $this->insertGetId($data);
  212. if (!$waste_record_id) {
  213. throw new Exception('保存记录失败');
  214. }
  215. $sdata = [
  216. 'status' => 0,
  217. 'create_time' => $data['create_time'],
  218. 'user_id' => $data['user_id'],
  219. 'waste_record_id' => $waste_record_id,
  220. ];
  221. $res = Db::name('waste_record_user')->insert($sdata);
  222. if (!$res) {
  223. throw new Exception('保存操作记录失败');
  224. }
  225. $this->commit();
  226. return $waste_record_id;
  227. }catch (Exception $e){
  228. $this->error = $e->getMessage();
  229. $this->rollback();
  230. return false;
  231. }
  232. }
  233. public function saveStatus($data){
  234. $info = $this->
  235. where('serial_number',$data['serialNumber'])
  236. ->find();
  237. if(!$info){
  238. $this->error = '记录不存在';
  239. return false;
  240. }
  241. $curTime = date('Y-m-d H:i:s');
  242. $this->startTrans();
  243. try{
  244. $rdata = [
  245. 'weight2' => isset($data['weight2'])?$data['weight2']:0,
  246. 'status' => $data['status'],
  247. 'reason' => isset($data['reason'])?$data['reason']:'',
  248. 'package_id' => 0 // 有任何变化,都删除与包的关系
  249. ];
  250. $ret = $this
  251. ->where('id',$info['id'])
  252. ->update( $rdata);
  253. if (!$ret) {
  254. \exception('操作失败1');
  255. }
  256. $sdata = [
  257. 'status' => $data['status'],
  258. 'create_time' => $curTime,
  259. 'user_id' => $data['userId'],
  260. 'waste_record_id' => $info['id'],
  261. ];
  262. $res = Db::name('waste_record_user')
  263. ->insert($sdata);
  264. if (!$res) {
  265. \exception('操作失败');
  266. }
  267. // 如果在保内,检查包内是否还有可以记录,没有则删除包记录
  268. if($info['package_id'] > 0){
  269. $count = $this
  270. ->where('package_id',$info['package_id'])
  271. ->where('id','<>',$info['id'])
  272. ->count();
  273. if($count == 0){
  274. $res = Db::name('waste_package')->
  275. where('id',$info['package_id'])
  276. ->update(['del' => 1]);
  277. if (!$res) {
  278. \exception('操作失败');
  279. }
  280. }
  281. }
  282. $this->commit();
  283. }catch (Exception $e){
  284. $this->error = '操作失败'.$e->getMessage();
  285. $this->rollback();
  286. return false;
  287. }
  288. return true;
  289. }
  290. public function lists($orgId,$depId,$date,$page,$size,$userId){
  291. $offset= ($page - 1) * $size;
  292. $map[]= ['wr.org_id','=',$orgId];
  293. $map[]= ['wr.sign','=',0];
  294. $map[]= ['wr.del','=',0];
  295. $map1[]= ['wr.user_id','=',$userId];
  296. if($depId){
  297. $map1[]= ['wd.dep_id','=',$depId];
  298. }
  299. if($date){
  300. $date = date('Ymd',strtotime($date));
  301. $map[]= ['wr.create_yyyymmdd','=',$date];
  302. }
  303. $list = $this
  304. ->alias('wr')
  305. ->join('address wd','wd.id = wr.waste_device_id')
  306. ->where(function ($query) use ($map1) {
  307. $query->whereOr($map1);
  308. })->where($map)->field('wr.waste_device_id,wr.cateid,wr.create_time,wr.is_print,wr.serial_number,wr.id,wr.weight,wr.sign')
  309. ->order('wr.id','desc')
  310. ->limit($offset,$size)->select();
  311. $list = $list?$list->toArray():[];
  312. foreach ($list as $k=>$v){
  313. $title=Db::name('address')
  314. ->where('id',$v['waste_device_id'])
  315. ->value('title');
  316. $list[$k]['waste_device_name'] = $title;
  317. $cate = Db::name('waste_type')->
  318. where('id',$v['cateid'])->value('title');
  319. $list[$k]['cate_title']= $cate?$cate:'';
  320. }
  321. $ret['list']=$list?$list:[];
  322. return $ret;
  323. }
  324. public function savePackage($post){
  325. $curTime =getTime();
  326. $data = [
  327. 'org_id' => $post['org_id'],
  328. 'user_id' => $post['user_id'],
  329. 'ids' => $post['ids'],
  330. 'create_time' => $curTime,
  331. ];
  332. // 检查是否符合要求
  333. $count = Db::name('waste_record')
  334. ->where('del',0)
  335. ->where('status',0)
  336. ->where('package_id',0)
  337. ->where('user_id',$data['user_id'])
  338. ->where('id','in',$data['ids'])
  339. ->count();
  340. if($count != count($data['ids'])){
  341. $this->error = '有不符合要求的医废记录';
  342. return false;
  343. }
  344. $this->startTrans();
  345. try{
  346. $pData = [
  347. 'org_id' => $post['org_id'],
  348. 'user_id' => $post['user_id'],
  349. 'record' => implode(',',$post['ids']),
  350. 'create_time' => $curTime,
  351. 'sn' => get_unique_id2()
  352. ];
  353. $id= Db::name('waste_package')
  354. ->insertGetId($pData);
  355. if (!$id) {
  356. exception('操作失败');
  357. }
  358. $sData = [
  359. 'package_id' => $id,
  360. ];
  361. $res = $this->where('id','in',$data['ids'])
  362. ->update( $sData);
  363. if (!$res) {
  364. exception('操作失败');
  365. }
  366. $this->commit();
  367. }catch (Exception $e){
  368. $this->error = $e->getMessage();
  369. $this->rollback();
  370. return false;
  371. }
  372. return $id;
  373. }
  374. public function packInfo($serialNum,$orgId){
  375. $map[] = ['sn','=',$serialNum];
  376. $map[] = ['org_id','=',$orgId];
  377. $map[] = ['del','=',0];
  378. $info = Db::name('waste_package')
  379. ->where($map)
  380. ->field('id,sn,org_id,user_id,status,create_time,jj_time,zy_time,jj_user_id,zy_user_id')
  381. ->find();
  382. if(!$info){
  383. $this->error = '记录不存在';
  384. return false;
  385. }
  386. $org = Db::name('org')
  387. ->where('id',$info['org_id'])
  388. ->field('name')->find();
  389. $info['org_name'] = $org?$org['name']:'';
  390. $user = Db::name('user')
  391. ->where('id',$info['user_id'])
  392. ->field('real_name')->find();
  393. $info['real_name'] = $user?$user['real_name']:'';
  394. $info['jj_time'] = $info['jj_time']?$info['jj_time']:'';
  395. $info['zy_time'] = $info['zy_time']?$info['zy_time']:'';
  396. if($info['jj_user_id'] > 0){
  397. $user = Db::name('user')
  398. ->where('id',$info['jj_user_id'])
  399. ->field('real_name')->find();
  400. $info['jj_real_name'] = $user?$user['real_name']:'';
  401. }
  402. if($info['zy_user_id'] > 0){
  403. $user = Db::name('user')
  404. ->where('id',$info['zy_user_id'])
  405. ->field('real_name')->find();
  406. $info['zy_real_name'] = $user?$user['real_name']:'';
  407. }
  408. $weight =$this
  409. ->where('package_id',$info['id'])
  410. ->sum('weight');
  411. // $info['weight'] = $weight?round($weight/1000,2):0;
  412. $info['weight'] = $weight;
  413. $count = $this->where('package_id',$info['id'])
  414. ->count();
  415. $info['count'] = $count?$count:0;
  416. $record = Db::name('waste_record')
  417. ->alias('wr')
  418. ->where('wr.del',0)
  419. ->where('wr.package_id',$info['id'])
  420. ->field('wr.waste_device_id,wr.cateid,wr.create_time,wr.is_print,wr.serial_number,wr.id,wr.weight,wr.sign')
  421. ->order('wr.id desc')
  422. ->select();
  423. foreach ($record as $k=>$v){
  424. $title=Db::name('address')
  425. ->field('title')
  426. ->where('id',$v['waste_device_id'])
  427. ->find();
  428. $record[$k]['title'] = $title?$title['title']:'';
  429. $record[$k]['cate_name'] =Db::name('waste_type')
  430. ->where('id',$v['cateid'])->value('title');
  431. // $record[$k]['weight'] = $v['weight']?round($v['weight']/1000,2):0;
  432. $record[$k]['weight'] = $v['weight']?$v['weight']:0;
  433. }
  434. $data = [
  435. 'type' => 2,
  436. 'pinfo' => $info,
  437. 'record' => $record?$record:[]
  438. ];
  439. return $data;
  440. }
  441. public function packagesLists($orgId,$page,$size,$userId){
  442. $offset= ($page - 1) * $size;
  443. $map[] = ['org_id','=',$orgId];
  444. $map[] = ['user_id','=',$userId];
  445. $map[] = ['del','=',0];
  446. $list = Db::name('waste_package')
  447. ->field('id,sn,org_id,user_id,status,create_time')
  448. ->order('id desc')
  449. ->where($map)
  450. ->limit($offset,$size)
  451. ->select();
  452. foreach ($list as $k=>$v){
  453. $user = Db::name('user')
  454. ->where('id',$v['user_id'])
  455. ->field('real_name')
  456. ->find();
  457. $list[$k]['real_name'] = $user?$user['real_name']:'';
  458. $weight = $this->where('package_id',$v['id'])
  459. ->sum('weight');
  460. $list[$k]['weight'] = $weight?$weight:0;
  461. $count = $this->where('package_id',$v['id'])
  462. ->count();
  463. $list[$k]['count'] = $count?$count:0;
  464. }
  465. return $list?$list:[];
  466. }
  467. public function delpackage($orgId,$userId,$id,$recordId){
  468. $info = $this
  469. ->where('del',0)
  470. ->where('org_id',$orgId)
  471. ->where('package_id',$id)
  472. ->where('id',$recordId)
  473. ->find();
  474. if(!$info){
  475. $this->error = '记录不存在';
  476. return false;
  477. }
  478. $this->startTrans();
  479. try{
  480. $res = $this->where('id',$recordId)
  481. ->update(['package_id' => 0]);
  482. if (!$res) {
  483. exception('操作失败');
  484. }
  485. // 如果在保内,检查包内是否还有可以记录,没有则删除包记录
  486. if($info['package_id'] > 0){
  487. $count = $this
  488. ->where('package_id',$id)
  489. ->where('id','<>',$recordId)
  490. ->count();
  491. if($count == 0){
  492. $res = Db::name('waste_package')
  493. ->where('id',$id)
  494. ->update(['del' => 1]);
  495. if (!$res) {
  496. exception('操作失败');
  497. }
  498. }
  499. }
  500. $this->commit();
  501. return true;
  502. }catch (Exception $e){
  503. $this->error = '操作失败'.$e->getmessage();
  504. $this->rollback();
  505. return false;
  506. }
  507. }
  508. // 交接
  509. public function jjpackage($orgId,$userId,$id){
  510. $info = Db::name('waste_package')
  511. ->where('del',0)
  512. ->where('org_id',$orgId)
  513. ->where('id',$id)
  514. ->find();
  515. if(!$info){
  516. $this->error = '记录不存在';
  517. return false;
  518. }
  519. if($info['status'] != 0){
  520. $this->error = '无权限操作';
  521. return false;
  522. }
  523. $lists = $this
  524. ->where('package_id',$id)
  525. ->where('del',0)
  526. ->select();
  527. $lists = $lists?$lists->toArray():[];
  528. if(count($lists) == 0){
  529. $this->error = '无可操作的医废记录';
  530. return false;
  531. }
  532. $ids = [];
  533. foreach ($lists as $k=>$v){
  534. $ids[] = $v['id'];
  535. }
  536. $this->startTrans();
  537. try{
  538. $rData = [
  539. 'jj_time' => getTime(),
  540. 'status' => 1,
  541. 'jj_user_id' => $userId,
  542. 'jj_record' => implode(',',$ids)
  543. ];
  544. $ret = Db::name('waste_package')
  545. ->where('id',$id)
  546. ->update($rData);
  547. if (!$ret) {
  548. exception('操作失败1');
  549. }
  550. foreach ($lists as $k=>$v){
  551. $rrData = [
  552. 'weight2' => 0,
  553. 'status' => 1,
  554. 'reason' => '',
  555. ];
  556. $ret = $this
  557. ->where('id',$v['id'])
  558. ->update($rrData);
  559. if (!$ret) {
  560. exception('操作失败');
  561. }
  562. $sData = [
  563. 'status' => 1,
  564. 'create_time' => getTime(),
  565. 'user_id' => $userId,
  566. 'waste_record_id' => $v['id'],
  567. ];
  568. $res = Db::name('waste_record_user')
  569. ->insert($sData);
  570. if (!$res) {
  571. exception('操作失败');
  572. }
  573. }
  574. $this->commit();
  575. return true;
  576. }catch (Exception $e){
  577. $this->error = '操作失败'.$e->getmessage();
  578. $this->rollback();
  579. return false;
  580. }
  581. }
  582. // 转运
  583. public function zypackage($orgId,$userId,$id){
  584. $info = Db::name('waste_package')
  585. ->where('del',0)
  586. ->where('org_id',$orgId)
  587. ->where('id',$id)
  588. ->find();
  589. if(!$info){
  590. $this->error = '记录不存在';
  591. return false;
  592. }
  593. if($info['status'] != 1){
  594. $this->error = '无权限操作';
  595. return false;
  596. }
  597. $lists = $this
  598. ->where('package_id',$id)
  599. ->where('del',0)
  600. ->select();
  601. $lists = $lists?$lists->toArray():[];
  602. if(count($lists) == 0){
  603. $this->error = '无可操作的医废记录';
  604. return false;
  605. }
  606. $ids = [];
  607. foreach ($lists as $k=>$v){
  608. $ids[] = $v['id'];
  609. }
  610. $this->startTrans();
  611. try{
  612. $rData = [
  613. 'zy_time' => date('Y-m-d H:i:s'),
  614. 'status' => 2,
  615. 'zy_user_id' => $userId,
  616. 'zy_record' => implode(',',$ids)
  617. ];
  618. $ret = Db::name('waste_package')
  619. ->where('id',$id)
  620. ->update($rData);
  621. if (!$ret) {
  622. throw new exception('操作失败');
  623. }
  624. foreach ($lists as $k=>$v){
  625. $rrdata = [
  626. 'weight2' => 0,
  627. 'status' => 2,
  628. 'reason' => '',
  629. ];
  630. $ret = $this
  631. ->where('id',$v['id'])
  632. ->update($rrdata);
  633. if (!$ret) {
  634. exception('操作失败');
  635. }
  636. $sdata = [
  637. 'status' => 2,
  638. 'create_time' => getTime(),
  639. 'user_id' => $userId,
  640. 'waste_record_id' => $v['id'],
  641. ];
  642. $res = Db::name('waste_record_user')
  643. ->insert($sdata);
  644. if (!$res) {
  645. exception('操作失败');
  646. }
  647. }
  648. $this->commit();
  649. return true;
  650. }catch (Exception $e){
  651. $this->error = '操作失败'.$e->getmessage();
  652. $this->rollback();
  653. return false;
  654. }
  655. }
  656. public function yflist($orgId,$userId){
  657. $map[] = ['wr.org_id','=',$orgId];
  658. $map[] = ['wr.user_id','=',$userId];
  659. $map[] = ['wr.package_id','=',0];
  660. $map[] = ['wr.del','=',0];
  661. $map[] = ['wr.status','=',0];
  662. $list=$this->alias('wr')
  663. ->where($map)
  664. ->field('wr.waste_device_id,wr.cateid,wr.create_time,wr.is_print,wr.serial_number,wr.id,wr.weight,wr.sign')
  665. ->order('wr.id desc')
  666. ->select();
  667. $list = $list?$list->toArray():[];
  668. foreach ($list as $k=>$v){
  669. $title=Db::name('address')
  670. ->field('title')
  671. ->where('id',$v['waste_device_id'])
  672. ->find();
  673. $list[$k]['title'] = $title?$title['title']:'';
  674. $list[$k]['cate_name'] =Db::name('waste_type')
  675. ->where('id',$v['cateid'])->value('title');
  676. }
  677. return $list?$list:[];
  678. }
  679. public function printList($orgId,$userId){
  680. $title = input('title','');
  681. if($title!=''){
  682. $type = 7;
  683. $map1[]=['','exp',Db::raw("FIND_IN_SET($type,types)")];
  684. $address = Db::name('address')
  685. ->where('del',0)
  686. ->where('enable',1)
  687. ->where('org_id',$orgId)
  688. ->where('title','like','%'.$title.'%')
  689. ->where($map1)
  690. ->column('id');
  691. if($address){
  692. $map[] = ['wr.waste_device_id','in',$address];
  693. }else{
  694. $map[] = ['wr.waste_device_id','=',-1];
  695. }
  696. }
  697. $map[] = ['wr.org_id','=',$orgId];
  698. $map[] = ['wr.user_id','=',$userId];
  699. $map[] = ['wr.del','=',0];
  700. $map[] = ['wr.status','=',0];
  701. $map[] = ['wr.create_yyyymmdd','=',date('Ymd')];
  702. $list=$this->alias('wr')
  703. ->where($map)
  704. ->field('wr.waste_device_id,wr.cateid,wr.create_time,wr.is_print,wr.serial_number,wr.id,wr.weight,wr.sign')
  705. ->order('wr.id desc')
  706. ->limit(1000)
  707. ->select();
  708. $list = $list?$list->toArray():[];
  709. foreach ($list as $k=>$v){
  710. $title=Db::name('address')
  711. ->field('title')
  712. ->where('id',$v['waste_device_id'])
  713. ->find();
  714. $list[$k]['title'] = $title?$title['title']:'';
  715. $list[$k]['cate_name'] =Db::name('waste_type')
  716. ->where('id',$v['cateid'])->value('title');
  717. }
  718. return $list?$list:[];
  719. }
  720. public function recordLists($orgId,$wasteDeviceId,$start,$end,$page,$size,$userId){
  721. $offset= ($page - 1) * $size;
  722. $map[] = ['wr.org_id','=',$orgId];
  723. $map[] = ['wr.del','=',0];
  724. if($wasteDeviceId>0){
  725. $map[] = ['wr.waste_device_id','=',$wasteDeviceId];
  726. }
  727. if($start){
  728. $date = date('Ymd',strtotime($start));
  729. $map[] = ['wr.create_yyyymmdd','>=',$date];
  730. }
  731. if($end){
  732. $date = date('Ymd',strtotime($end));
  733. $map[] = ['wr.create_yyyymmdd','<=',$date];
  734. }
  735. $list=db('waste_record')
  736. ->alias('wr')
  737. ->field('wr.waste_device_id,wr.status,wr.cateid,wr.create_time,wr.is_print,wr.serial_number,wr.id,wr.weight,wr.sign')
  738. ->order('wr.id','desc')
  739. ->where($map)
  740. ->limit($offset,$size)
  741. ->select();
  742. foreach ($list as $k=>$v){
  743. $title=db('address')
  744. ->field('title')
  745. ->where('id',$v['waste_device_id'])
  746. ->find();
  747. $list[$k]['title'] = $title?$title['title']:'';
  748. $list[$k]['cate_title'] = $this->getTableField('waste_type',['id'=>$v['cateid']],'title');
  749. }
  750. $ret=$list?$list:[];
  751. return $ret;
  752. }
  753. public function getByDepDayList($wasteDeviceId,$orgId){
  754. $typeList = model('WasteType')->getList($orgId);
  755. $str ='';
  756. foreach ($typeList as $k=>$v){
  757. $sum = Db::name('waste_record')
  758. ->where('create_yyyymmdd',date('Ymd'))
  759. ->where('org_id',$orgId)
  760. ->where('waste_device_id',$wasteDeviceId)
  761. ->where('cateid',$v['id'])
  762. ->where('del',0)
  763. ->sum('weight');
  764. if($sum >0){
  765. $count = ($sum/1000).'kg';
  766. $str.=$v['title'].':'.$count.';';
  767. }
  768. }
  769. if($str!=''){
  770. $s = explode(';',$str);
  771. unset($s[count($s)-1]);
  772. $str = implode(';',$s);
  773. }
  774. return $str;
  775. }
  776. public function print($ids,$orgId,$userId){
  777. $waste_device_id = [];
  778. $id = explode(',',$ids);
  779. $total = 0;
  780. $cate = [];
  781. foreach ($id as $k=>$v){
  782. $info = Db::name('waste_record')
  783. ->where('id',$v)
  784. ->find();
  785. if(empty($info)){
  786. $this->error='记录id'.$v.'不存在';
  787. return false;
  788. }
  789. if($info['user_id']!=$userId){
  790. $this->error='记录id'.$v.'收取人不是自己';
  791. return false;
  792. }
  793. $cateInfo = Db::name('waste_type')
  794. ->where('id',$info['cateid'])
  795. ->find();
  796. $cate[] = [
  797. 'id'=>$info['cateid'],
  798. 'title'=>$cateInfo['title'],
  799. 'num'=>$info['weight'],
  800. 'count'=>1,
  801. ];
  802. $total+=$info['weight'];
  803. $waste_device_id[] = $info['waste_device_id'];
  804. }
  805. $aa = [];
  806. foreach ($cate as $k=>$v){
  807. if(isset($aa[$v['id']])){
  808. $aa[$v['id']]['num'] = $aa[$v['id']]['num']+$v['num'];
  809. $aa[$v['id']]['count'] = $aa[$v['id']]['count']+1;
  810. }else{
  811. $aa[$v['id']] = $v;
  812. }
  813. }
  814. $ab = [];
  815. foreach ($aa as $k=>$v){
  816. $kg = sprintf("%.2f",$v['num']/1000);
  817. $ab[]=$v['title'].':'.$v['count'].' '.$kg.'kg';
  818. }
  819. if(count(array_unique($waste_device_id)) >1){
  820. $this->error='只能打印同一个科室下的记录';
  821. return false;
  822. }
  823. $address = Db::name('address')
  824. ->where('id',$waste_device_id[0])
  825. ->find();
  826. if(empty($address['user'])){
  827. $this->error='当前科室未绑定负责人';
  828. return false;
  829. }
  830. $amount = $total>0?sprintf("%.2f",$total/1000):"0";
  831. $total_desc = $amount.'kg,'.count($id).'袋';
  832. $a = [
  833. 'org_id'=>$orgId,
  834. 'waste_record_id'=>$ids,
  835. 'address'=>$address['title'],
  836. 'address_user'=>$address['user'],
  837. 'create_time'=>getTime(),
  838. 'total'=>$total_desc,
  839. 'user_id'=>$userId,
  840. 'desc'=>implode(',',$ab),
  841. ];
  842. $r = Db::name('waste_print_log')
  843. ->insertGetId($a);
  844. $a['org_name'] = Db::name('org')
  845. ->where('id',$a['org_id'])
  846. ->value('name');
  847. $a['user_name'] = Db::name('user')
  848. ->where('id',$userId)
  849. ->value('real_name');
  850. unset($a['user_id']);
  851. return $a;
  852. }
  853. }