public function update($id, Request $request)
{
$this->validate($request, ['name' => 'required|min:2|max:10']);
$product = Product::findOrFail($id);
$product->name = $request->name;
$product->save();
return redirect('products/' . $id);
}
public function remove($id, Request $request)
{
$jenis = Product::findOrFail($id);
if ($request->ajax()) {
$company->delete($request->all());
return response(['msg' => 'Company deleted', 'status' => 'success']);
}
return response(['msg' => 'Failed deleting the company', 'status' => 'failed']);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create(Request $request)
{
if ($request->isMethod('get')) {
//menampilkan form
return View('product.create');
} else {
//save ke db
$input = $request->only('name', 'purcase_price', 'sell_price');
Product::create($input);
return redirect('product/create');
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index($id)
{
$product = new Product();
$product = Product::find($id);
$categorys = new Category();
$categorys = Category::all();
$brands = new Brand();
$brands = Brand::all();
$reviews = new Review();
$reviews = $reviews = DB::table('review')->where('product_id', '=', $id)->get();
return view('productDetails.productDetails', ['product' => $product, 'categorys' => $categorys, 'brands' => $brands, 'reviews' => $reviews]);
}
public function index()
{
$topic = new Topic();
$topics = Topic::all();
//echo "<pre>";
//$ss = $topic->GetUserinfo();
//print_r($ss);
//echo $topic::find(1)->user->username;
$product = \Product::Find(['slug' => 'decorative-hedgehogs']);
print_r($product);
return view("index")->with('topic', $topics);
}
public function categoryShow($categorySlug)
{
dd($categorySlug);
try {
// Get category
$category = \Category::Find(['slug' => $categorySlug, 'status' => 1]);
if ($category['result'][0]) {
// Get products
$products = \Product::Find(['limit' => $this->app->config['app_per_page'], 'offset' => $offset, 'category' => $category['result'][0]['id']]);
// Assign products
$category['products'] = $products['result'];
} else {
$this->app->redirect('404');
}
} catch (\Exception $e) {
exit($e->getMessage());
}
// Build page
$this->render('Views/Category', $category);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$product = Product::find($id);
return $product;
}
public function store(productRequest $request)
{
/*$validation = Validator::make($request->all(), [
'name' => 'required',
'O-Shop' => 'required',
'short_description' => 'required',
'product_photo' => 'required',
'retail_price' => 'required',
'original_price' => 'required',
'available' => 'required',
'owarehouse_moq' => 'required',
'owarehouse_price' => 'required',
'product_details' => 'required',
]);
if ($validation->fails()) {
return redirect('create_new_product')
->withErrors($validation)
->withInput();
}
else {*/
/*
* Get product last id from product table
*/
$product_id = Product::orderBy('id', 'desc')->take(1)->get();
foreach ($product_id as $PI) {
$Pid = $PI->id;
}
if (!isset($Pid)) {
$Pid = 0;
}
$Pid = $Pid + 1;
/*
* Product table section
*/
$destination = 'public/images/product/' . $Pid . '/';
$image = $request->file('product_photo');
$image_name = $image->getClientOriginalName();
if ($image->move($destination, $image_name)) {
//if image moved
$pro_table = new Product();
$pro_table->name = $request->name;
$pro_table->brand_id = $request->brand_id;
$pro_table->category_id = $request->category_id;
$pro_table->subcat_id = $request->subcat_id;
$pro_table->photo_1 = $destination . $image_name;
if (isset($request->free_delivery)) {
$pro_table->free_delivery = $request->free_delivery;
$pro_table->del_worldwide = 0;
$pro_table->del_west_malaysia = 0;
$pro_table->del_sabah_labuan = 0;
$pro_table->del_sarawak = 0;
} else {
$pro_table->free_delivery = 0;
$pro_table->del_worldwide = $request->del_worldwid;
$pro_table->del_west_malaysia = $request->del_west_malaysia;
$pro_table->del_sabah_labuan = $request->del_sabah_labuan;
$pro_table->del_sarawak = $request->del_sarawak;
}
$pro_table->cov_country_id = $request->cov_country_id;
$pro_table->cov_state_id = $request->cov_state_id;
$pro_table->cov_city_id = $request->cov_city_id;
$pro_table->retail_price = $request->retail_price;
$pro_table->original_price = $request->original_price;
$pro_table->available = $request->available;
$pro_table->owarehouse_moq = $request->owarehouse_moq;
$pro_table->owarehouse_price = $request->owarehouse_price;
$pro_table->product_details = $request->product_details;
$pro_table->type = 'product';
$pro_table->save();
/*
* Unit and price section....Wholesaletable
*/
for ($i = 0; $i < count($request->wunit); $i++) {
$wholwsale_table = new wholesale();
$wholwsale_table->product_id = $Pid;
$wholwsale_table->unit = $request->wunit[$i];
$wholwsale_table->price = $request->wprice[$i];
$wholwsale_table->save();
}
/*
* Dealer section with speacial price....productdealer table
*/
for ($i = 0; $i < count($request->dealer); $i++) {
$productdealer_table = new productdealer();
$productdealer_table->product_id = $Pid;
$productdealer_table->dealer_id = $request->dealer[$i];
$productdealer_table->special_unit = $request->sunit[$i];
$productdealer_table->special_price = $request->sprice[$i];
$productdealer_table->save();
}
/*
* Product Specification section..specification table
*/
/*
* get last spec id
*/
$spec_id = specification::orderBy('id', 'desc')->take(1)->get();
foreach ($spec_id as $SI) {
$Sid = $SI->id;
}
if (!isset($Sid)) {
$Sid = 1;
}
for ($i = 1; $i <= 6; $i++) {
$spec_table = new specification();
$spec_table->name = $request->product_specification_name;
$spec_table->description = $request->product_specification_[$i];
$spec_table->save();
//save into subcat_level_1 table;
$subcat = new SubCatLevel1Spec();
$subcat->subcat_level_1_id = $request->category_id;
$subcat->spec_id = $Sid;
$subcat->save();
$Sid = $Sid + 1;
}
/*
* Seller information section..address table
*/
$address_table = new Address();
$address_table->city_id = 0;
$address_table->line1 = $request->SFA1;
$address_table->line2 = $request->SFA3;
$address_table->line3 = $request->SFA3;
$address_table->save();
/*
* get last enter adress id
*/
$address_id = Address::orderBy('id', 'desc')->take(1)->get();
foreach ($address_id as $AI) {
$Aid = $AI->id;
}
/*
* O-shop and shot-description section ....merchant table
*/
$merchant_table = new Merchant();
$merchant_table->User_id = 1;
//here we get user id//Auth()::user()->id;
$merchant_table->oshop_name = $request->O - Shop;
$merchant_table->oshop_name = $request->description;
$merchant_table->oshop_address_id = $Aid;
$merchant_table->contact_person = $request->seller_name;
$merchant_table->return_policy = $request->return_policy;
$merchant_table->save();
return "Data saved into tables";
}
//}
}
public function store(Request $request)
{
/*$validation = Validator::make($request->all(), [
'name' => 'required',
'O-Shop' => 'required',
'short_description' => 'required',
'product_photo' => 'required',
'retail_price' => 'required',
'original_price' => 'required',
'available' => 'required',
'owarehouse_moq' => 'required',
'owarehouse_price' => 'required',
'product_details' => 'required',
]);
if ($validation->fails()) {
return redirect('create_new_product')
->withErrors($validation)
->withInput();
}
else {*/
/*
* Get product last id from product table
*/
$product_id = Product::orderBy('id', 'desc')->take(1)->get();
foreach ($product_id as $PI) {
$Pid = $PI->id;
}
if (!isset($Pid)) {
$Pid = 0;
}
$Pid = $Pid + 1;
/*
* Product table section
*/
$destination = 'public/images/product/' . $Pid . '/';
$image = $request->file('product_photo');
$image_name = $image->getClientOriginalName();
if ($image->move($destination, $image_name)) {
//if image moved
$pro_table = new Product();
$pro_table->name = $request->name;
$pro_table->brand_id = $request->brand_id;
$pro_table->category_id = $request->category_id;
$pro_table->subcat_id = $request->subcat_id;
$pro_table->photo_1 = $destination . $image_name;
$pro_table->retail_price = $request->retail_price;
$pro_table->original_price = $request->original_price;
$pro_table->available = $request->Quantity;
$pro_table->product_details = $request->product_details;
$pro_table->type = 'voucher';
$pro_table->save();
/*
* address table
*/
$address_table = new Address();
$address_table->city_id = 0;
$address_table->line1 = $request->VL1;
$address_table->line2 = $request->VL1;
$address_table->line3 = $request->VL1;
$address_table->save();
/*
* get last enter adress id
*/
$address_id = Address::orderBy('id', 'desc')->take(1)->get();
foreach ($address_id as $AI) {
$Aid = $AI->id;
}
/*
* Voucher section....voucher table
*/
//for($i=0;$i<count($request->wholeweek);$i++) {if user chose multi checkboxs
$voucher_table = new voucher();
$voucher_table->product_id = $Pid;
$voucher_table->validity = $request->whole;
$voucher_table->weekly_duration = $request->wholeweek;
$voucher_table->start_duration = $request->start_duration;
$voucher_table->end_duration = $request->years . '-' . $request->months . '-' . $request->days;
$voucher_table->address_id = $Aid;
$voucher_table->save();
//}
/*
* get last enter voucher id
*/
$voucher_id = voucher::orderBy('id', 'desc')->take(1)->get();
foreach ($voucher_id as $VI) {
$Vid = $VI->id;
}
/*
* Timealot section....timeslot table
* timeslot may b many
*/
for ($i = 0; $i < count($request->from); $i++) {
$timeslot_table = new timeslot();
$timeslot_table->voucher_id = Vid;
$timeslot_table->from = $request->from[$i];
$timeslot_table->to = $request->to[$i];
$timeslot_table->price = $request->myrprice[$i];
$timeslot_table->pax_per_table = $request->fixedprice[$i];
$timeslot_table->save();
}
/*
* Unit and price section....Wholesaletable
*/
for ($i = 0; $i < count($request->wunit); $i++) {
$wholwsale_table = new wholesale();
$wholwsale_table->product_id = $Pid;
$wholwsale_table->unit = $request->wunit[$i];
$wholwsale_table->price = $request->wprice[$i];
$wholwsale_table->save();
}
/*
* Dealer section with speacial price....productdealer table
*/
for ($i = 0; $i < count($request->dealer); $i++) {
$productdealer_table = new productdealer();
$productdealer_table->product_id = $Pid;
$productdealer_table->dealer_id = $request->dealer[$i];
$productdealer_table->special_unit = $request->sunit[$i];
$productdealer_table->special_price = $request->sprice[$i];
$productdealer_table->save();
}
/*
* Product Specification section..specification table
*/
/*
* get last spec id
*/
$spec_id = specification::orderBy('id', 'desc')->take(1)->get();
foreach ($spec_id as $SI) {
$Sid = $SI->id;
}
if (!isset($Sid)) {
$Sid = 1;
}
for ($i = 1; $i <= 6; $i++) {
$spec_table = new specification();
$spec_table->name = $request->product_specification_name;
$spec_table->description = $request->product_specification_[$i];
$spec_table->save();
//save into subcat_level_1 table;
$subcat = new SubCatLevel1Spec();
$subcat->subcat_level_1_id = $request->category_id;
$subcat->spec_id = $Sid;
$subcat->save();
$Sid = $Sid + 1;
}
/*
* Seller information section..address table
*/
$address_table = new Address();
$address_table->city_id = 0;
$address_table->line1 = $request->SFA1;
$address_table->line2 = $request->SFA3;
$address_table->line3 = $request->SFA3;
$address_table->save();
/*
* get last enter adress id
*/
$address_id = Address::orderBy('id', 'desc')->take(1)->get();
foreach ($address_id as $AI) {
$Aid = $AI->id;
}
/*
* O-shop and shot-description section ....merchant table
*/
$merchant_table = new Merchant();
$merchant_table->user_id = 1;
//here we get user id//Auth()::user()->id;
$merchant_table->oshop_name = $request->O - Shop;
$merchant_table->oshop_name = $request->description;
$merchant_table->oshop_address_id = $Aid;
$merchant_table->contact_person = $request->seller_name;
$merchant_table->return_policy = $request->return_policy;
$merchant_table->save();
return "Data saved into tables";
}
//}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$music = new Product();
Product::find($id)->delete();
$musics = $music->join('categories', 'products.category_id', '=', 'categories.id')->select('products.title', 'products.description', 'products.price', 'products.id', 'categories.name')->get();
$music_style = new Musicstyle();
$music_styles = $music_style->orderBy('name')->get();
return view('products')->with('products', $musics)->with('categories', $music_styles)->with('deleted', 1);
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$inputData = $request->all();
Product::create($inputData);
}
public function getProductDetail($product_id)
{
//preparing models for view
$product = Product::find($product_id);
return View::make('product_detail', compact('product'));
}