public function postBatchup()
{
$file = Input::file('excel_file');
$result = Excel::load($file, function ($reader) {
$reader->take(500);
})->toArray();
$data = array_filter($result);
if (isset($data[0][0]['vendor_id'])) {
$data = $data[0];
}
foreach ($data as $key => $value) {
//$validator = Validator::make($value,Product::$rules);
//if($validator->passes()){
$venid = User::where('uniq_ven_id', '=', $value['vendor_id'])->get(array('id'));
$already_product = Product::where('title', '=', $value['title'])->get();
if ($already_product->count()) {
$prodvenrel = new Prodvenrelations();
$prodvenrel->vendor_id = $venid[0]->id;
$prodvenrel->product_id = $already_product[0]->id;
$prodvenrel->description = $value['description'];
$prodvenrel->regular_price = $value['regular_price'];
$prodvenrel->delux_price = $value['delux_price'];
$prodvenrel->premium_price = $value['premium_price'];
$prodvenrel->city = $value['city'];
$prodvenrel->save();
$product = Product::where('id', '=', $already_product[0]->id)->first();
$product->ovid = $product->ovid . "," . $prodvenrel->id;
$product->save();
} else {
$product = new Product();
$product->category_id = $value['category_id'];
$product->vendor_id = $venid[0]->id;
$product->title = $value['title'];
$product->description = $value['description'];
//images in another batch up
//just save the file paths
$product->image = $value['image'];
$product->regular_price = $value['regular_price'];
$product->delux_price = $value['delux_price'];
$product->premium_price = $value['premium_price'];
$product->product_code = $value['product_code'];
$product->city = $value['city'];
$product->save();
}
//}
}
return Redirect::to('admin/products/index')->with('message', 'Product created.');
}
