コード例 #1
0
	public function anyImportProduct(){
		
		\Excel::load('kho-2015.xls', function($reader) {
		    $results = $reader->get();
		    $company = Company::getDistributeList()->get()->toArray();
		    $arr_company = array();
		    foreach ($company as $key => $value) {
		    	$arr_company[$value['name']] = $value['id'];
		    }
		    // pr($arr_company);die;
		    $arr_oum = array();
		    $oums = Oum::orderBy('name')->get()->toArray();
		    foreach ($oums as $key => $value) {
		    	$arr_oum[$value['name']] = $value['id'];
		    }
		 	foreach ($results as $row) {

		 	 	$product = new Product;
				$product->name = $row['ten_san_pham'];
				$product->sku = $row['sku'];
				// $name_product = $row['ten_san_pham'];
				// $check1 = is_numeric(mb_strpos($name_product, "Áo"));
				// $check2 = is_numeric(mb_strpos($name_product, 'Váy'));
				// $check3 = is_numeric(mb_strpos($name_product, 'Quần'));
				// $check3 = is_numeric(mb_strpos($name_product, 'Đầm'));
				// $check4 = is_numeric(mb_strpos($name_product, 'Bộ')) && is_numeric(mb_strpos($name_product, 'ton'));
				// $check5 = is_numeric(mb_strpos($name_product, 'Bộ')) && is_numeric(mb_strpos($name_product, 'bo'));
				// $check6 = is_numeric(mb_strpos($name_product, 'Bộ')) && is_numeric(mb_strpos($name_product, 'thun'));
				// $check = $check1 || $check2 || $check3 || $check4 || $check5 || $check6;
				if($row['loai_san_pham'] == "Đồ dùng"){
					$product->product_type = 2;
				}else{
					$product->product_type = 1;
				}
				$product->status=0;
				$product->created_by = \Auth::user()->id;
				if($product->save()){
					$mproduct = new MProduct;
					$mproduct->product_id	=	$product->id;
					$mproduct->module_id	= 	0;
					$mproduct->company_id	= 	$arr_company[$row['nha_cung_cap']];
					$mproduct->module_type	=	'in_stock';
					$mproduct->specification	=	$row['quy_cach'];
					$mproduct->oum_id		=	$arr_oum[$row['don_vi_ban']];
					$mproduct->origin_price	=	intval(str_replace(",","",$row['gia_goc']));
					$mproduct->quantity		=	$row['so_luong'];
					$mproduct->invest		=	intval(str_replace(",","",$row['gia_goc']))*intval($row['so_luong'])*intval($row['quy_cach']);
					if($mproduct->save()){
						Product::where('id','=',$product->id)->update(['check_in_stock'=>1]);
						if(intval($row['gia_npp'])>0){
							$sell_price = new SellPrice;
							$sell_price->name = "Giá NPP";
							$sell_price->price = intval($row['gia_npp']);
							$sell_price->product_id = $product->id;
							$sell_price->m_product_id = $mproduct->id;
							$sell_price->save();
						}
						if(intval($row['dai_ly'])>0){
							$sell_price = new SellPrice;
							$sell_price->name = "Giá đại lý";
							$sell_price->price = intval($row['dai_ly']);
							$sell_price->product_id = $product->id;
							$sell_price->m_product_id = $mproduct->id;
							$sell_price->save();
						}
						if(intval($row['shop'])>0){
							$sell_price = new SellPrice;
							$sell_price->name = "Giá bán shop";
							$sell_price->price = intval($row['shop']);
							$sell_price->product_id = $product->id;
							$sell_price->m_product_id = $mproduct->id;
							$sell_price->save();
						}
						if(intval($row['ban_le'])>0){
							$sell_price = new SellPrice;
							$sell_price->name = "Giá bán lẻ";
							$sell_price->price = intval($row['ban_le']);
							$sell_price->product_id = $product->id;
							$sell_price->m_product_id = $mproduct->id;
							$sell_price->save();
						}
					}
				}
		 	}
		 	echo "Done";
		 	die;
		});
		
	}
コード例 #2
0
	public function postUpdateMproduct(Request $request){
		$arr_return= array('status'=>'error','amount'=>0);
		$id = $request->has('id')?$request->input('id'):0;
		$log="";
		if($id){
			$mproduct = MProduct::find($id);
			$mproduct_po = Mproduct::find($mproduct->m_product_id);
			$mproduct_so = Mproduct::find($mproduct->m_product_id_so);

			$mproduct_rso_before = Mproduct::where('m_product_id_so','=',$mproduct_so->id)
							->where('module_type','=','App\\ReturnSaleorder')
							->where('company_id','=',$mproduct->company_id)
							->get();
			$mproduct_so->con_lai = $mproduct_so->quantity * $mproduct_so->specification;
			
			foreach ($mproduct_rso_before as $key => $value) {
				$mproduct_so->con_lai -=  $value->quantity * $value->specification;
			}
			$so_luong_con = $mproduct_so->con_lai;
			if($request->has('oum_id')  && $mproduct->oum_id != $request->input('oum_id')){
				$old = Oum::find($mproduct->oum_id);
				$new = Oum::find($request->input('oum_id'));
				if($old){
					$log .= 'đơn vị từ "'.$old->name.'" thành "'.$new->name.'" ';
				}else{
					$log .= 'đơn vị từ " " thành "'.$new->name.'" ';
				}
			}
			if($request->has('sell_price')  && $mproduct->sell_price != $request->input('sell_price')){
				$log .= 'giá bán từ "'.$mproduct->sell_price.'" thành "'.$request->input('sell_price').'" ';
			}
			if($request->has('specification')  && $mproduct->specification != $request->input('specification')){
				$log .= 'quy cách từ "'.$mproduct->specification.'" thành "'.$request->input('specification').'" ';
			}
			if($request->has('quantity')  && $mproduct->quantity != $request->input('quantity')){
				$log .= 'số lượng từ "'.$mproduct->quantity.'" thành "'.$request->input('quantity').'" ';
			}

			$mproduct->oum_id =  $request->has('oum_id')?$request->input('oum_id'):0;
			$mproduct->sell_price =  $request->has('sell_price')?$request->input('sell_price'):0;
			$mproduct->specification =  $request->has('specification')?$request->input('specification'):0;
			$old_quantity = $mproduct->quantity ;
			$mproduct->quantity =  $request->has('quantity')?$request->input('quantity'):0;
			$check_return = ($mproduct_so->con_lai - $mproduct->quantity*$mproduct->specification) >=0;

			$mproduct->origin_price = $mproduct_so->origin_price;
			$mproduct->amount = $mproduct->specification* $mproduct->quantity* $mproduct->sell_price;
			$mproduct->invest = $mproduct->specification* $mproduct->quantity* $mproduct->origin_price;
			// if($product_stock->in_stock >=0){
				if( $check_return ){
					if($mproduct->save()){
						$product = Product::find($mproduct->product_id);
						Log::create_log(\Auth::user()->id,'App\ReturnSaleorder','cập nhật '.$log.' sản phẩm '.$product->sku.' đơn hàng đại lý trả số '.session('current_returnsaleorder'));
						$arr_return['status'] = 'success';
						$arr_return['amount'] = number_format( $mproduct->amount );
					}else{ 
						$arr_return['message'] = 'Saving fail !';
					}
				}else{
					$arr_return['message'] = 'Số lượng sản phẩm trả về lớn hơn số lượng còn lại trong kho <br/> Số lượng còn lại trong kho là '.$so_luong_con.' cái';
				}
			// }else{
			// 	$arr_return['message'] = 'Số lượng trả hàng lớn hơn số lượng đã bán';
			// }
		}

		//Init array
		$list_product = array();
		//Get value
		$returnsaleorder = ReturnSaleorder::find(session('current_returnsaleorder'));
		$list_product = MProduct::select('m_products.*','products.sku','products.name')->where('module_type','=','App\ReturnSaleorder')
						->where('module_id','=',$id)
						->where('company_id','=',$returnsaleorder['company_id'])
						->leftJoin('products','products.id','=','m_products.product_id')
						->addSelect('oums.name as oum_name')
						->leftJoin('oums','oums.id','=','m_products.oum_id')
						->get()->toArray();

		\Cache::put('list_product_rso'.\Auth::user()->id, $list_product, 30);

		
		$returnsaleorder->updated_by = \Auth::user()->id;
		$returnsaleorder->save();
		self::getListProduct();
		return $arr_return;
	}
コード例 #3
0
	public function postUpdateMproduct(Request $request){
		$arr_return= array('status'=>'error','invest'=>0);
		$id = $request->has('id')?$request->input('id'):0;
		$log="";
		if($id){
			$mproduct = MProduct::find($id);
			$mproduct_po = Mproduct::find($mproduct->m_product_id);
			if($request->has('oum_id')  && $mproduct->oum_id != $request->input('oum_id')){
				$old = Oum::find($mproduct->oum_id);
				$new = Oum::find($request->input('oum_id'));
				if($old){
					$log .= 'đơn vị từ "'.$old->name.'" thành "'.$new->name.'" ';
				}else{
					$log .= 'đơn vị từ " " thành "'.$new->name.'" ';
				}
			}
			if($request->has('sell_price')  && $mproduct->sell_price != $request->input('sell_price')){
				$log .= 'giá bán từ "'.$mproduct->sell_price.'" thành "'.$request->input('sell_price').'" ';
			}
			if($request->has('specification')  && $mproduct->specification != $request->input('specification')){
				$log .= 'quy cách từ "'.$mproduct->specification.'" thành "'.$request->input('specification').'" ';
			}
			if($request->has('quantity')  && $mproduct->quantity != $request->input('quantity')){
				$log .= 'số lượng từ "'.$mproduct->quantity.'" thành "'.$request->input('quantity').'" ';
			}
			$mproduct->oum_id =  $request->has('oum_id')?$request->input('oum_id'):0;
			$mproduct->origin_price =  $request->has('origin_price')?$request->input('origin_price'):0;
			$mproduct->specification =  $request->has('specification')?$request->input('specification'):0;
			$old_quantity = $mproduct->quantity ;
			$mproduct->quantity =  $request->has('quantity')?$request->input('quantity'):0;
			$product_stock = ProductStock::where('m_product_id','=',$mproduct_po->id)->first();
			$so_luong_con = $product_stock->in_stock;
			$product_stock->in_stock = $product_stock->in_stock - ($mproduct->quantity*$mproduct->specification);
			$mproduct->invest = $mproduct->specification* $mproduct->quantity* $mproduct->origin_price;
			if($product_stock->in_stock >=0){
				if( !$mproduct->status){
					if($mproduct->save()){
						$product = Product::find($mproduct->product_id);
						Log::create_log(\Auth::user()->id,'App\ReturnPurchaseorder','cập nhật '.$log.' sản phẩm '.$product->sku.' đơn hàng trả nhà cung cấp số '.session('current_returnpurchaseorder'));
						$arr_return['status'] = 'success';
						$arr_return['invest'] = number_format( $mproduct->invest );
					}else{
						$arr_return['message'] = 'Saving fail !';
					}
				}else{
					$arr_return['message'] = 'Đơn hàng đã hoàn thành không thể cập nhật';
				}
			}else{
				$arr_return['message'] = 'Số lượng trả '.$mproduct->name.' lớn hơn số lượng đã nhập<br/> Số lượng đã nhập là '.$so_luong_con.' cái';
			}
		}

		$id = session('current_returnpurchaseorder');
		//Init array
		$list_product = array();

		//Get value
		$returnpurchaseorder = ReturnPurchaseorder::find(session('current_returnpurchaseorder'));
		$list_product = MProduct::select('m_products.*','products.sku','products.name')->where('module_type','=','App\ReturnPurchaseorder')
						->where('module_id','=',$id)
						->where('company_id','=',$returnpurchaseorder['company_id'])
						->leftJoin('products','products.id','=','m_products.product_id')
						->addSelect('oums.name as oum_name')
						->leftJoin('oums','oums.id','=','m_products.oum_id')
						->get()->toArray();
		\Cache::put('list_product_rpo'.\Auth::user()->id, $list_product, 30); 
		$returnpurchaseorder->updated_by = \Auth::user()->id;
		$returnpurchaseorder->save();
		self::getListProduct();
		return $arr_return;
	}
コード例 #4
0
	 public function getDeleteOum($id)
	{
		$arr_return = array(
			"status"=>"error"
		);
		$oum = Oum::find($id);
		if($oum->delete()){
			$arr_return['status'] = 'success';
		}else{
			$arr_return['message']= "Delete fail";
		}
		return $arr_return;
	}