GiveOutService.php 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  1. <?php
  2. namespace App\Service;
  3. use App\Model\Employee;
  4. use App\Model\GiveOut;
  5. use Illuminate\Support\Facades\DB;
  6. /**
  7. * 发放
  8. */
  9. class GiveOutService extends Service
  10. {
  11. public function giveOutEdit($data,$user){
  12. list($status,$msg) = $this->giveOutRule($data, $user, false);
  13. if(!$status) return [$status,$msg];
  14. try {
  15. DB::beginTransaction();
  16. $model = GiveOut::where('id',$data['id'])->first();
  17. $model->give_out_amount = $data['give_out_amount'] ?? 0;
  18. $model->employee_id_1 = $data['employee_id_1'] ?? 0;
  19. $model->employee_id_1_title = $data['employee_id_1_title'] ?? "";
  20. $model->send_time = $data['send_time'] ?? 0;
  21. $model->start_time = $data['start_time'] ?? 0;
  22. $model->end_time = $data['end_time'] ?? 0;
  23. $model->save();
  24. DB::commit();
  25. }catch (\Exception $exception){
  26. DB::rollBack();
  27. return [false,$exception->getMessage()];
  28. }
  29. return [true, ''];
  30. }
  31. public function giveOutAdd($data,$user){
  32. list($status,$msg) = $this->giveOutRule($data, $user);
  33. if(!$status) return [$status,$msg];
  34. try {
  35. DB::beginTransaction();
  36. $model = new GiveOut();
  37. $model->give_out_amount = $data['give_out_amount'] ?? 0;
  38. $model->employee_id_1 = $data['employee_id_1'] ?? 0;
  39. $model->employee_id_1_title = $data['employee_id_1_title'] ?? "";
  40. $model->send_time = $data['send_time'] ?? 0;
  41. $model->start_time = $data['start_time'] ?? 0;
  42. $model->end_time = $data['end_time'] ?? 0;
  43. $model->crt_id = $user['id'];
  44. $model->save();
  45. DB::commit();
  46. }catch (\Exception $exception){
  47. DB::rollBack();
  48. return [false,$exception->getMessage()];
  49. }
  50. return [true, ''];
  51. }
  52. public function giveOutDel($data){
  53. if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
  54. try {
  55. DB::beginTransaction();
  56. $time = time();
  57. GiveOut::where('del_time',0)
  58. ->whereIn('id',$data['id'])
  59. ->update(['del_time' => $time]);
  60. DB::commit();
  61. }catch (\Exception $exception){
  62. DB::rollBack();
  63. return [false,$exception->getMessage()];
  64. }
  65. return [true, ''];
  66. }
  67. public function giveOutDetail($data,$user){
  68. if($this->isEmpty($data,'id')) return [false,'请选择数据!'];
  69. $customer = GiveOut::where('del_time',0)
  70. ->where('id',$data['id'])
  71. ->first();
  72. if(empty($customer)) return [false,'发放记录不存在或已被删除'];
  73. $customer = $customer->toArray();
  74. $customer['crt_name'] = Employee::where('id',$customer['crt_id'])->value('emp_name');
  75. $customer['crt_time'] = $customer['crt_time'] ? date("Y-m-d H:i:s",$customer['crt_time']): '';
  76. return [true, $customer];
  77. }
  78. public function giveOutCommon($data,$user, $field = []){
  79. if(empty($field)) $field = GiveOut::$field;
  80. $model = GiveOut::where('del_time',0)
  81. ->select($field)
  82. ->orderby('id', 'desc');
  83. if(! empty($data['employee_id_1_title'])) $model->where('employee_id_1_title', 'LIKE', '%'.$data['employee_id_1_title'].'%');
  84. if(! empty($data['send_time'][0]) && ! empty($data['send_time'][1])) {
  85. $return = $this->changeDateToTimeStampAboutRange($data['send_time']);
  86. $model->where('send_time','>=',$return[0]);
  87. $model->where('send_time','<=',$return[1]);
  88. }
  89. if(! empty($data['belong_time'][0]) && ! empty($data['belong_time'][1])) {
  90. $return = $this->changeDateToTimeStampAboutRange($data['belong_time']);
  91. $model->where('start_time','>=',$return[0]);
  92. $model->where('end_time','<=',$return[1]);
  93. }
  94. return $model;
  95. }
  96. public function giveOutList($data,$user){
  97. $model = $this->giveOutCommon($data, $user);
  98. $list = $this->limit($model,'',$data);
  99. $list = $this->fillData($list);
  100. return [true, $list];
  101. }
  102. public function giveOutRule(&$data, $user, $is_add = true){
  103. if(empty($data['give_out_amount'])) return [false, '分红已发金额不能为空'];
  104. $res = $this->checkNumber($data['give_out_amount'],2,'positive');
  105. if(! $res['valid']) return [false,'分红已发金额:' . $res['error']];
  106. if(empty($data['employee_id_1'])) return [false, '业务员不能为空'];
  107. $employee = Employee::where('del_time',0)
  108. ->where('id',$data['employee_id_1'])
  109. ->first();
  110. if(empty($employee)) return [false, '业务员不存在或已被删除'];
  111. $data['employee_id_1_title'] = $employee->emp_name;
  112. if(empty($data['send_time'])) return [false, '发放日期不能为空'];
  113. $data['send_time'] = $this->changeDateToDate($data['send_time']);
  114. if($data['send_time'] == null) return [false, '发放日期错误'];
  115. if(empty($data['belong_time'])) return [false, '归属日期不能为空'];
  116. list($start_time,$end_time) = $this->changeDateToTimeStampAboutRange($data['belong_time'], false);
  117. if ($start_time === null || $end_time === null || $start_time > $end_time) return [false, "归属日期的区间无效"];
  118. $data['start_time'] = $start_time;
  119. $data['end_time'] = $start_time;
  120. if($is_add){
  121. }else{
  122. if(empty($data['id'])) return [false,'ID不能为空'];
  123. $bool = GiveOut::where('id',$data['id'])
  124. ->where('del_time',0)
  125. ->exists();
  126. if(! $bool) return [false,'发放记录不存在或已被删除'];
  127. }
  128. return [true, $data];
  129. }
  130. public function fillData($data){
  131. if(empty($data['data'])) return $data;
  132. foreach ($data['data'] as $key => $value){
  133. $data['data'][$key]['send_time'] = $value['send_time'] ? date('Y-m-d',$value['send_time']) : '';
  134. $start = $value['start_time'] ? date('Y-m-d',$value['start_time']) : '';
  135. $end = $value['end_time'] ? date('Y-m-d',$value['end_time']) : '';
  136. $string = "";
  137. if(! empty($start) && ! empty($end)) $string = $start . "-" . $end;
  138. $data['data'][$key]['belong_time'] = $string;
  139. }
  140. return $data;
  141. }
  142. }