DeleteService.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  1. <?php
  2. namespace App\Service;
  3. use App\Model\Employee;
  4. use App\Model\SalesOrderInfo;
  5. use Illuminate\Support\Facades\DB;
  6. class DeleteService extends Service
  7. {
  8. public function getMan($data,$user){
  9. if(empty($data['id']) || empty($data['type']) || empty($data['man_type'])) return [false, '必填参数不能为空!'];
  10. $return = [];
  11. if($data['type'] == 1){
  12. $return = $this->getSaleOrderMan($data);
  13. }
  14. return [true, $return];
  15. }
  16. public function delete($data,$user){
  17. if(empty($data['id']) || empty($data['type']) || empty($data['man_type']) || empty($data['man'])) return [false, '必填参数不能为空!'];
  18. try {
  19. DB::beginTransaction();
  20. if($data['type'] == 1){
  21. $this->delSaleOrderMan($data);
  22. }
  23. DB::commit();
  24. }catch (\Exception $exception){
  25. DB::rollBack();
  26. return [false,$exception->getMessage()];
  27. }
  28. return [true,''];
  29. }
  30. public function getSaleOrderMan($data){
  31. $man_id = SalesOrderInfo::where('del_time',0)
  32. ->where('sales_order_id',$data['id'])
  33. ->where('type',$data['man_type'])
  34. ->get('data_id')->toArray();
  35. $man_id = array_column($man_id,'data_id');
  36. return Employee::whereIn('id',$man_id)->select('id', 'emp_name')->get()->toArray();
  37. }
  38. public function delSaleOrderMan($data){
  39. $time = time();
  40. SalesOrderInfo::where('del_time',0)
  41. ->where('sales_order_id',$data['id'])
  42. ->where('type',$data['man_type'])
  43. ->update(['del_time' => $time]);
  44. if(! empty($data['man'])){
  45. $insert = [];
  46. foreach ($data['man'] as $value){
  47. $insert[] = [
  48. 'sales_order_id' => $data['id'],
  49. 'data_id' => $value,
  50. 'type' => $data['man_type'],
  51. 'crt_time' => $time,
  52. ];
  53. }
  54. SalesOrderInfo::insert($insert);
  55. }
  56. }
  57. public function fp($data,$user){
  58. if(empty($data['id']) || empty($data['type']) || empty($data['man'])) return [false, '必填参数不能为空!'];
  59. try {
  60. DB::beginTransaction();
  61. if($data['type'] == 1){
  62. $this->fpSaleOrderMan($data);
  63. }
  64. DB::commit();
  65. }catch (\Exception $exception){
  66. DB::rollBack();
  67. return [false,$exception->getMessage()];
  68. }
  69. return [true,''];
  70. }
  71. public function fpSaleOrderMan($data){
  72. $time = time();
  73. if(! empty($data['man'])){
  74. $insert = [];
  75. foreach ($data['man'] as $value){
  76. $insert[] = [
  77. 'sales_order_id' => $data['id'],
  78. 'data_id' => $value,
  79. 'type' => SalesOrderInfo::type_two,
  80. 'crt_time' => $time,
  81. ];
  82. }
  83. SalesOrderInfo::insert($insert);
  84. }
  85. }
  86. public function yj($data,$user){
  87. if(empty($data['id']) || empty($data['type']) || empty($data['man'])) return [false, '必填参数不能为空!'];
  88. try {
  89. DB::beginTransaction();
  90. if($data['type'] == 1){
  91. $this->yjSaleOrderMan($data,$user);
  92. }
  93. DB::commit();
  94. }catch (\Exception $exception){
  95. DB::rollBack();
  96. return [false,$exception->getMessage()];
  97. }
  98. return [true,''];
  99. }
  100. public function yjSaleOrderMan($data,$user){
  101. $time = time();
  102. SalesOrderInfo::where('del_time',0)
  103. ->where('sales_order_id',$data['id'])
  104. ->where('type', SalesOrderInfo::type_two)
  105. ->where('data_id', $user['id'])
  106. ->update(['del_time' => $time]);
  107. if(! empty($data['man'])){
  108. $insert = [];
  109. foreach ($data['man'] as $value){
  110. $insert[] = [
  111. 'sales_order_id' => $data['id'],
  112. 'data_id' => $value,
  113. 'type' => SalesOrderInfo::type_two,
  114. 'crt_time' => $time,
  115. ];
  116. }
  117. SalesOrderInfo::insert($insert);
  118. }
  119. }
  120. }