RejectedBill.php 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181
  1. <?php
  2. namespace App;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Controllers\LogisticNumberFeatureController;
  5. use Carbon\Carbon;
  6. use Illuminate\Database\Eloquent\Model;
  7. use Illuminate\Database\Eloquent\SoftDeletes;
  8. use Illuminate\Support\Facades\Auth;
  9. use Overtrue\LaravelPinyin\Facades\Pinyin;
  10. /**
  11. * @method static find(array|string|null $param)
  12. */use App\Traits\ModelTimeFormat;
  13. class RejectedBill extends Model
  14. {
  15. use ModelTimeFormat;
  16. use SoftDeletes;
  17. protected $fillable=['id_owner','order_number','sender','mobile_sender',
  18. 'logistic_number','logistic_number_return','id_logistic_return',
  19. 'is_loaded','fee_collected','remark','id_operator','is_checked'
  20. ,'is_finished','checked_numbers','remark','common_01','common_02'];
  21. protected $appends = ['owner_name','logistic_name','created_at_short'
  22. ,'is_loaded_str','goods_amount','is_loaded_null','operator_name'];
  23. function owner(){
  24. return $this->hasOne('App\Owner','id','id_owner');
  25. }
  26. function logistic(){
  27. return $this->hasOne('App\Logistic','id','id_logistic_return');
  28. }
  29. function items(){
  30. return $this->hasMany('App\RejectedBillItem','id_rejected_bill','id');
  31. }
  32. function user(){
  33. return $this->hasOne('App\User','id','id_operator');
  34. }
  35. function rejectedBillItems(){
  36. return $this->items();
  37. }
  38. function wmsReflectReceive(){
  39. return $this->belongsTo('App\WMSReflectReceive','id','id_rejected_bill');
  40. }
  41. function setIsLoaded_toWaitConfirm(){
  42. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"将待推单修改为待确认! 退单号:".$this['logistic_number_return'],Auth::user()['id']);
  43. $bill=RejectedBill::find($this['id']);
  44. $bill['is_loaded']=4;
  45. $bill->save();
  46. }
  47. function logisticName(){
  48. $logistic=$this->hasOne('App\Logistic','id','id_logistic_return')->first();
  49. return $logistic?$logistic['name']:'';
  50. }
  51. function makeCheckedNumbers(){
  52. $owner = $this->owner()->first();
  53. if(!$owner)return '';
  54. $pinyinOwnerName=Pinyin::convert($owner->name);
  55. $pinyinArr=array_map(function($pinyin){
  56. return $pinyin[0];
  57. },$pinyinOwnerName);
  58. $initials=implode("", $pinyinArr);
  59. $this['checked_numbers']=$initials.Carbon::now()->format('Ymd').$owner->getIncreasedCheckingCount();
  60. return $this['checked_numbers'];
  61. }
  62. function orderIssue()
  63. {
  64. return $this->hasOne( OrderIssue::class, 'logistic_number_return', 'logistic_number_return');
  65. }
  66. function update(array $attributes = [], array $options = [])
  67. {
  68. (new LogisticNumberFeatureController())->createFeatures($this['logistic_number_return'],$this['id_logistic_return']);
  69. return parent::update($attributes, $options);
  70. }
  71. function save(array $options = [])
  72. {
  73. (new LogisticNumberFeatureController())->createFeatures($this['logistic_number_return'],$this['id_logistic_return']);
  74. return parent::save($options);
  75. }
  76. public function getOwnerNameAttribute(){
  77. return $this->owner['name']??'';
  78. }
  79. public function getLogisticNameAttribute(){
  80. return $this->logistic['name']??'';
  81. }
  82. public function getIsLoadedStrAttribute(){
  83. $val=$this['is_loaded']===null?'null':$this['is_loaded'];
  84. $val=$val===0?'0':$val;
  85. switch ($val){
  86. case 'null':return '无需入库';
  87. case '0':return '否';
  88. case 1:return '是';
  89. case 2:return '待推单';
  90. case 3:return '上传异常';
  91. }
  92. return '';
  93. }
  94. public function getCreatedAtShortAttribute(){
  95. return $this['created_at']?$this['created_at_short']=$this['created_at']->format('m-d H:i:s'):'';
  96. }
  97. public function getGoodsAmountAttribute(){
  98. $amount=0;
  99. $this->items->each(function (RejectedBillItem $item)use(&$amount){
  100. $amount+=$item['amount'];
  101. });
  102. return $amount;
  103. }
  104. public function getOperatorNameAttribute(){
  105. return $this['user'] ? $this['user']['name'] : null;
  106. }
  107. public function getIsLoadedNullAttribute(){
  108. if($this['is_loaded']===null) return 'null';
  109. return $this['is_loaded'];
  110. }
  111. public function changeIsLoaded_ifItemsAllLoaded(){
  112. $allItemsAreLoaded=true;
  113. $this->items->each(function (RejectedBillItem $item)use(&$allItemsAreLoaded){
  114. if($item['is_loaded']=='未入库'){
  115. $allItemsAreLoaded=false;
  116. return false;
  117. }
  118. });
  119. if($allItemsAreLoaded){
  120. $this['is_loaded']=1;
  121. }else{
  122. $this['is_loaded']=0;
  123. }
  124. $this->update();
  125. return $this['is_loaded'];
  126. }
  127. public function 同步问题件退件状态()
  128. {
  129. $orderIssue = $this->orderIssue()->first();
  130. if ($orderIssue ?? false) {
  131. // $this->同步退单状态();
  132. $orderIssue->update(['is_new_rejecting' => '有']);
  133. } else {
  134. OrderIssue::query()->where('logistic_number_return', $this->logistic_number_return)->update(['is_new_rejecting' => '有']);
  135. }
  136. }
  137. public function 同步问题件()
  138. {
  139. $orderIssue = $this->orderIssue()->first();
  140. if(!isset($orderIssue)){
  141. if(isset($this->order_number)){
  142. $orderNumber = $this->order_number;
  143. $orderIssue = OrderIssue::query()->with('order')->whereHas('order',function($query)use($orderNumber){
  144. $query->where('client_code',$orderNumber);
  145. })->first();
  146. }
  147. if(isset($this->logistic_number_return) && !isset($orderIssue)){
  148. $logistic_number_return = $this->logistic_number_return;
  149. $orderHeader = OracleDOCOrderHeader::query()->where('soreference1',function($query)use($logistic_number_return){
  150. $query->select('asnreference2')->from('DOC_ASN_HEADER')->where('asnreference3',$logistic_number_return)->first();
  151. })->first();
  152. $orderIssue = OrderIssue::query()->with('order')->whereHas('order',function($query)use($orderHeader){
  153. $query->where('code',$orderHeader->orderno);
  154. })->first();
  155. }
  156. }
  157. if(isset($orderIssue)){
  158. // $orderIssue->同步退单状态();
  159. $orderIssue->update(['is_new_rejecting' => '有']);
  160. }
  161. }
  162. private function 同步退单状态()
  163. {
  164. /** @var OrderIssue $orderIssue */
  165. $orderIssue = $this->orderIssue()->first();
  166. if($orderIssue ?? false)
  167. $orderIssue->同步退单状态();
  168. }
  169. }