| 123456789101112131415161718192021222324252627282930313233 |
- <?php
- namespace App\Services;
- use App\Commodity;
- use App\OracleActAllocationDetails;
- use App\OracleBasSKU;
- use App\OracleDOCOrderDetail;
- use App\OrderPackage;
- use App\OrderPackageCommodities;
- use App\Owner;
- Class OrderPackageCommoditiesService
- {
- public function createOrFindBy(OrderPackage $orderPackage,OracleActAllocationDetails $detail){
- $owner = Owner::where(['code'=>$detail->customerid])->first(); // 货主
- $orderDetail = OracleDOCOrderDetail::where(['orderNo'=>$detail->orderno,'orderLineNo'=>$detail->orderlineno])->first();
- $sku = $detail->sku;
- $owner_id = $owner->id;
- $customerid = $orderDetail->customerid;
- $commodity = Commodity::where(['sku'=>$sku,'owner_id'=>$owner_id])->first();
- if($commodity == null){
- $basSku = OracleBasSKU::where(['sku'=>$sku,'customerid'=>$customerid])->first();
- $commodity = Commodity::create(['sku'=>$sku,'owner_id'=>$owner_id,'name',$basSku->descr_c]);
- }
- $arr = [
- 'order_package_id'=>$orderPackage->id, // 包裹id
- 'commodity_id'=>$commodity->id, // 商品id
- 'amount'=>$detail->qty, // 商品数量
- ];
- OrderPackageCommodities::create($arr);
- }
- }
|