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;
}
