SampleBus.php 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128
  1. <?php
  2. /**
  3. *
  4. *User:Administrator
  5. *Date:2021/10/14
  6. */
  7. namespace app\api\business;
  8. use app\api\model\Ccjc;
  9. use app\api\model\Cyd;
  10. use app\api\model\Jcdw;
  11. use app\api\model\TestModel;
  12. use app\api\model\Undertake;
  13. use app\api\model\UnitProduction;
  14. use app\api\model\UnitSample;
  15. use app\api\model\UnitTest;
  16. use app\common\lib\Arr;
  17. use app\common\lib\auth\JwtAuth;
  18. class SampleBus
  19. {
  20. private $uid;
  21. public function __construct()
  22. {
  23. $JwtAuth = JwtAuth::getInstance();
  24. $this->uid = $JwtAuth->getUid();
  25. }
  26. public function getCydDetail($sample_id)
  27. {
  28. $result = (new Cyd())->getCydDetailBySampleID($sample_id);
  29. return $result;
  30. }
  31. public function selectSampleList($data)
  32. {
  33. $uid = $this->uid;
  34. $where=[
  35. ['cyd.task_id', '=', $data['task_id']],//这里绑定成cyd.task_id进行查询
  36. ['undertake_id','=',$data['undertake_id']],
  37. //['uid', '=', $uid]
  38. ];
  39. //注释掉的是搜索功能
  40. // if ($data['sample_name']!='') $where[]=['sample_name', 'LIKE', '%'.$data['sample_name'].'%'];//样品名称
  41. // if ($data['sample_id']!='') $where[]=['sample_id', 'LIKE', '%'.$data['sample_id'].'%'];//样品编码
  42. // if ($data['sample_ground']!='') $where[]=['sample_ground', 'LIKE', '%'.$data['sample_ground'].'%'];//抽样场所
  43. // if ($data['undertake_id']!='') $where[] = ['undertake_id', '=', $data['undertake_id']];
  44. //
  45. // //bear-抽样单位,report-报告单位,check-检测单位
  46. //
  47. // if($data['unit_test_name']!='') $where[]=['unit_test_name','LIKE','%'.$data['unit_test_name'].'%'];//受检单位名称
  48. // if($data['unit_sample_name']!='') $where[]=['unit_sample_name','LIKE','%'.$data['unit_sample_name'].'%'];//抽样单位名称
  49. // if($data['unit_production_name']!='') $where[]=['unit_production_name','LIKE','%'.$data['unit_production_name'].'%'];//生产单位名称
  50. //
  51. // if($data['sample_data']!='') $where[]=['sample_date','=',$data['sample_data']];//抽样日期
  52. $result = (new Cyd())->selectSampleListByTaskIdAndUid($where, $data['pageNum'], $data['pageSize']);
  53. $count = (new Cyd())->countSampleListByTaskIdAndUid($where);
  54. return ['rows'=>$result,'total'=>$count];
  55. }
  56. public function getSampleObj($data)
  57. {
  58. $model_id = (new Ccjc())->getTaskInfoByTaskID($data['task_id'])['test_model_id'];
  59. $data_tmp = (new TestModel())->getProductInfo($model_id);
  60. $result=(new Arr())->Arr_columns($data_tmp, 'product_name,product_id');
  61. //根据$data['undertake_id']获取抽样单位和检测单位信息
  62. $undertaek_info=(new Undertake())->getItemByUndertakeId($data['undertake_id']);
  63. //根据信息获取抽样单位和检测单位的信息
  64. $sample_info = (new Jcdw())->getInfoById($undertaek_info['bear_id']);
  65. $check_info = (new Jcdw())->getInfoById($undertaek_info['check_id']);
  66. return ['list'=>$result,'sample_info'=>$sample_info,'check_info'=>$check_info];
  67. // return $result;
  68. }
  69. public function createSampleId($task_id)
  70. {
  71. $task_class = (new Ccjc())->getTaskInfoByTaskID($task_id)['task_class'];
  72. $count = (new Cyd())->countSampleCreateID();
  73. if ($task_class=="例行监测") {
  74. $id['id'] = 'LXJC' . date('Y') . date('m') . date('d') . date('H') . date('m') . str_pad(($count + 1), 4, 0, STR_PAD_LEFT);
  75. }
  76. if ($task_class=='专项监测'){
  77. $id['id'] = 'ZXJC'.date('Y').date('m').date('d').date('H').date('m').str_pad(($count+1),4,0,STR_PAD_LEFT);
  78. }
  79. return $id;
  80. }
  81. public function createSample($unit_test,$unit_production,$unit_sample,$cyd_data)
  82. {
  83. //写入抽样单信息,并返回抽样单cyd ID
  84. $cyd_id = (new Cyd())->createSample($cyd_data);
  85. //赋值cydID
  86. $unit_test['cyd_id']=$unit_production['cyd_id']=$unit_sample['cyd_id']=$cyd_id;
  87. //写入受检单位信息,并返回自增id
  88. $unit_test_id = (new UnitTest())->insertUnitTestDataGetId($unit_test);
  89. //写入生产单位信息,并返回自增id
  90. $unit_production_id = (new UnitProduction())->insertUnitProductionDataGetId($unit_production);
  91. //写入抽样单位信息,并返回自增id
  92. $unit_sample_id=(new UnitSample())->insertUnitSampleDataGetId($unit_sample);
  93. //将各种id写入cyd
  94. $cyd_id_data = [
  95. 'uid' => $this->uid,
  96. 'test_id' => '',//检测单位id
  97. 'units_id' => $unit_test_id,//受检单位id
  98. 'product_unit' => $unit_production_id,//生产单位id
  99. 'sample_unit' => $unit_sample_id,//抽样单位id
  100. ];
  101. $result = (new Cyd())->updateCydDataByID($cyd_id,$cyd_id_data);
  102. return $result;
  103. }
  104. }