RejectedBill.php 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233
  1. <?php
  2. namespace App;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Controllers\LogisticNumberFeatureController;
  5. use App\Services\OrderPackageCommoditiesService;
  6. use Carbon\Carbon;
  7. use Illuminate\Database\Eloquent\Model;
  8. use Illuminate\Database\Eloquent\SoftDeletes;
  9. use Illuminate\Support\Arr;
  10. use Illuminate\Support\Facades\Auth;
  11. use Overtrue\LaravelPinyin\Facades\Pinyin;
  12. /**
  13. * @method static find(array|string|null $param)
  14. */use App\Traits\ModelTimeFormat;
  15. class RejectedBill extends Model
  16. {
  17. use ModelTimeFormat;
  18. use SoftDeletes;
  19. protected $fillable=['id_owner','order_number','sender','mobile_sender',
  20. 'logistic_number','logistic_number_return','id_logistic_return',
  21. 'is_loaded','fee_collected','remark','id_operator','is_checked'
  22. ,'is_finished','checked_numbers','remark','common_01','common_02'];
  23. protected $appends = ['owner_name','logistic_name','created_at_short'
  24. ,'is_loaded_str','goods_amount','is_loaded_null','operator_name'];
  25. function owner(){
  26. return $this->hasOne('App\Owner','id','id_owner');
  27. }
  28. function logistic(){
  29. return $this->hasOne('App\Logistic','id','id_logistic_return');
  30. }
  31. function items(){
  32. return $this->hasMany('App\RejectedBillItem','id_rejected_bill','id');
  33. }
  34. function user(){
  35. return $this->hasOne('App\User','id','id_operator');
  36. }
  37. function rejectedBillItems(){
  38. return $this->items();
  39. }
  40. function wmsReflectReceive(){
  41. return $this->belongsTo('App\WMSReflectReceive','id','id_rejected_bill');
  42. }
  43. function setIsLoaded_toWaitConfirm(){
  44. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"将待推单修改为待确认! 退单号:".$this['logistic_number_return'],Auth::user()['id']);
  45. $bill=RejectedBill::find($this['id']);
  46. $bill['is_loaded']=4;
  47. $bill->save();
  48. }
  49. function logisticName(){
  50. $logistic=$this->hasOne('App\Logistic','id','id_logistic_return')->first();
  51. return $logistic?$logistic['name']:'';
  52. }
  53. function makeCheckedNumbers(){
  54. $owner = $this->owner()->first();
  55. if(!$owner)return '';
  56. $pinyinOwnerName=Pinyin::convert($owner->name);
  57. $pinyinArr=array_map(function($pinyin){
  58. return $pinyin[0];
  59. },$pinyinOwnerName);
  60. $initials=implode("", $pinyinArr);
  61. $this['checked_numbers']=$initials.Carbon::now()->format('Ymd').$owner->getIncreasedCheckingCount();
  62. return $this['checked_numbers'];
  63. }
  64. function orderIssue(){
  65. return $this->hasOne('App\OrderIssue','rejected_bill_id','id');
  66. }
  67. function update(array $attributes = [], array $options = [])
  68. {
  69. (new LogisticNumberFeatureController())->createFeatures($this['logistic_number_return'],$this['id_logistic_return']);
  70. return parent::update($attributes, $options);
  71. }
  72. function save(array $options = [])
  73. {
  74. (new LogisticNumberFeatureController())->createFeatures($this['logistic_number_return'],$this['id_logistic_return']);
  75. return parent::save($options);
  76. }
  77. public function getOwnerNameAttribute(){
  78. $id_owner=$this['id_owner']??0;
  79. $owner=Owner::find($id_owner);
  80. return $this['owner_name']=$owner['name'];
  81. }
  82. public function getLogisticNameAttribute(){
  83. $id_logistic=$this['id_logistic_return']??0;
  84. $logistic=Logistic::find($id_logistic);
  85. return $this['logistic_name']=$logistic['name'];
  86. }
  87. public function getIsLoadedStrAttribute(){
  88. $val=$this['is_loaded']===null?'null':$this['is_loaded'];
  89. $val=$val===0?'0':$val;
  90. switch ($val){
  91. case 'null':return '无需入库';
  92. case '0':return '否';
  93. case 1:return '是';
  94. case 2:return '待推单';
  95. case 3:return '上传异常';
  96. }
  97. return '';
  98. }
  99. public function getCreatedAtShortAttribute(){
  100. return $this['created_at']?$this['created_at_short']=$this['created_at']->format('m-d H:i:s'):'';
  101. }
  102. public function getGoodsAmountAttribute(){
  103. $amount=0;
  104. $this->items()->get()->each(function (RejectedBillItem $item)use(&$amount){
  105. $amount+=$item['amount'];
  106. });
  107. return $amount;
  108. }
  109. public function getOperatorNameAttribute(){
  110. return $this['user'] ? $this['user']['name'] : null;
  111. }
  112. public function getIsLoadedNullAttribute(){
  113. if($this['is_loaded']===null) return 'null';
  114. return $this['is_loaded'];
  115. }
  116. public function changeIsLoaded_ifItemsAllLoaded(){
  117. $allItemsAreLoaded=true;
  118. $this->items->each(function (RejectedBillItem $item)use(&$allItemsAreLoaded){
  119. if($item['is_loaded']=='未入库'){
  120. $allItemsAreLoaded=false;
  121. return false;
  122. }
  123. });
  124. if($allItemsAreLoaded){
  125. $this['is_loaded']=1;
  126. }else{
  127. $this['is_loaded']=0;
  128. }
  129. $this->update();
  130. return $this['is_loaded'];
  131. }
  132. public function syncOrderIssue(){
  133. $orderIssue = $this->orderIssue()->first();
  134. if(isset($orderIssue)){
  135. $this-> judgeRejectingStatus($orderIssue);
  136. OrderIssue::where('id',$orderIssue['id'])->update(['is_new_rejecting'=>'有']);
  137. }
  138. }
  139. private function judgeRejectingStatus(OrderIssue $orderIssue)
  140. {
  141. $orderPackageCommoditiesService = new OrderPackageCommoditiesService();
  142. $rejectedItems = [];
  143. $orderItems = [];
  144. if ($orderIssue->rejected_bill_id) {
  145. $rejectedBill = RejectedBill::find($orderIssue->rejected_bill_id)->first();
  146. $rejectedBillItems = RejectedBillItem::where('id_rejected_bill', $rejectedBill->id)->get();
  147. if ($rejectedBillItems) {
  148. foreach ($rejectedBillItems as $item) {
  149. if(!isset($rejectedItems[$item->barcode_goods])){
  150. $rejectedItems[$item->barcode_goods] =0;
  151. }
  152. $rejectedItems[$item->barcode_goods] = $item->amount + $rejectedItems[$item->barcode_goods] ?? 0;
  153. }
  154. }
  155. } else {
  156. $orderIssue->update(['rejecting' => '无']);
  157. $orderIssue->save();
  158. return;
  159. }
  160. if ($orderIssue->order_id) {
  161. $orderPackageCommodities = $orderPackageCommoditiesService->getOrderPackageCommoditiesByOrderId($orderIssue->order_id);
  162. if ($orderPackageCommodities) {
  163. foreach ($orderPackageCommodities as $key => $item) {
  164. if (!isset($orderItems[$item->commodity->sku])) {
  165. Arr::add($orderItems,$item->commodity->sku,0);
  166. }
  167. $orderItems[$item->commodity->sku] = $orderItems[$item->commodity->sku] ?? 0 + $item->amount;
  168. }
  169. } else {
  170. $orderIssue->update(['rejecting_status' => '未退回']);
  171. $orderIssue->save();
  172. return;
  173. }
  174. }
  175. $rejectedExcess = 0; // 退回差异
  176. $rejectedReview = 0; // 退回复核 $rejectedItems == $orderItems
  177. foreach ($rejectedItems as $key => $items) {
  178. if (!isset($orderItems[$key])) {
  179. $rejectedExcess++;
  180. } else {
  181. if ($rejectedItems[$key] == $orderItems[$key]) {
  182. $rejectedReview++;
  183. }
  184. }
  185. }
  186. if ($rejectedExcess > 0) {
  187. $orderIssue->update(['rejecting_status' => '差异退回']);
  188. $orderIssue->save();
  189. return;
  190. }
  191. $isExcess = 0; // 超量 $orderItems < $rejectedItems
  192. $isDiff = 0; // 部分 $orderItems > $rejectedItems
  193. $isAccord = 0; // 相同 $orderItems == $rejectedItems
  194. $isLack = 0; // 缺少 $orderItems != $rejectedItems
  195. foreach ($orderItems as $key => $item) {
  196. if (isset($rejectedItems[$key])) {
  197. if ($orderItems[$key] > $rejectedItems[$key]) {
  198. $isExcess++;
  199. } else if ($orderItems[$key] < $rejectedItems[$key]) {
  200. $isDiff++;
  201. } else if ($orderItems[$key] == $rejectedItems[$key]) {
  202. $isAccord++;
  203. }
  204. } else {
  205. $isLack++;
  206. }
  207. }
  208. if ($isAccord == $rejectedReview) {
  209. $orderIssue->update(['rejecting_status' => '全部退回']);
  210. $orderIssue->save();
  211. return;
  212. } else if ($isDiff > 0 and $isLack >= 0) {
  213. $orderIssue->update(['rejecting_status' => '部分退回']);
  214. $orderIssue->save();
  215. return;
  216. } else if ($isExcess > 0 and $isDiff == 0) {
  217. $orderIssue->update(['rejecting_status' => '超量退回']);
  218. $orderIssue->save();
  219. return;
  220. }
  221. }
  222. }