public function anyImportPrice(){ set_time_limit(0); \Excel::load('gia.xls', function($reader) { $results = $reader->get(); foreach ($results as $row) { $row = $row->toArray(); $sku = $row['sku']; $product = Product::where('sku','=',$sku)->first(); $mproducts = MProduct::where('product_id','=',$product->id) ->where(function ($query){ $query->where('module_type','in_stock') ->orwhere('module_type','App\\Purchaseorder'); }) ->get(); foreach ($mproducts as $key => $value) { $sell_price = new SellPrice; $sell_price->name = "Giá hot cấp 2"; $sell_price->price = intval($row['gia_hot_cap_2']); $sell_price->product_id = $product->id; $sell_price->m_product_id = $value->id; $sell_price->save(); } } }); echo "done"; die; }
public function anyAddProduct(Request $request){ $arr_return = array( "status"=>'success' ); $id = $request->has('id')?$request->input('id'):0; $company_id = $request->has('company_id')?$request->input('company_id'):0; $module_id = session('current_purchaseorder'); $module_type = 'App\Purchaseorder'; $arr_product = session('product_of_po'.session('current_purchaseorder')); $arr_product_of_po = Mproduct::where('module_id','=',$module_id) ->where('module_type','=',$module_type) ->lists('product_id'); $log = ""; foreach ($arr_product as $key => $product_id) { if(!in_array($product_id, $arr_product_of_po)){ $product = Product::find($product_id); $last_mproduct = Mproduct::where('product_id','=',$product_id)->get()->last(); $mproduct = new MProduct; $mproduct->company_id = $company_id; $mproduct->product_id = $product_id; $mproduct->module_id = $module_id; $mproduct->id = $id; $mproduct->module_type = $module_type; if($last_mproduct){ $mproduct->specification = $last_mproduct->specification; $mproduct->oum_id = $last_mproduct->oum_id; $mproduct->origin_price = $last_mproduct->origin_price; }else{ $mproduct->specification = 0; $mproduct->oum_id = 0; $mproduct->origin_price = 0; } $mproduct->save(); $last_sellprice = SellPrice::where('product_id','=',$product_id)->orderBy('m_product_id','desc')->first(); if($last_sellprice){ $arr_sellprice = SellPrice::where('m_product_id','=',$last_sellprice->m_product_id)->get()->toArray(); foreach ($arr_sellprice as $key => $value) { $sellprice = new SellPrice; $sellprice->name = $value['name']; $sellprice->price = $value['price']; $sellprice->m_product_id = $mproduct->id; $sellprice->product_id = $value['product_id']; $sellprice->save(); } } if(!$product->check_in_stock){ $product->check_in_stock = 1; $product->save(); } if($log==""){ $log .= "Thêm sản phẩm ".$product->sku; }else{ $log .= ", ".$product->sku; } } } $log_delete = ""; foreach ($arr_product_of_po as $key => $product_id) { if(!in_array($product_id, $arr_product)){ $product = Product::find($product_id); $mproduct = MProduct::where('module_id','=',$module_id) ->where('module_type','=',$module_type) ->where('product_id','=',$product_id)->first()->toArray(); $id_product = $mproduct['product_id']; $quantity = $mproduct['quantity']; $check = MProduct::where('module_id','=',$module_id) ->where('module_type','=',$module_type) ->where('product_id','=',$product_id)->delete(); if($check){ $product_stock = ProductStock::where('m_product_id','=',$mproduct['id'])->delete(); } if($log==""){ $log .= "xóa sản phẩm ".$product->sku; }else{ $log .= ", ".$product->sku; } } } if($log_delete !="") Log::create_log(\Auth::user()->id,'App\Purchaseorder',$log.' và .'.$log_delete.' đơn hàng đại lý trả số '.session('current_purchaseorder')); else Log::create_log(\Auth::user()->id,'App\Purchaseorder',$log.'vào đơn hàng mua số '.session('current_purchaseorder')); $purchaseorder = Purchaseorder::find(session('current_purchaseorder')); $purchaseorder->updated_by = \Auth::user()->id; $purchaseorder->save(); self::getListProduct(); return $arr_return; }