GiveOutService.php 6.5 KB

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