public function store(ItemRequest $request)
{
try {
$customers = Customer::all();
Item::create($request->all());
$item = Item::orderBy('created_at', 'desc')->first();
foreach ($customers as $customer) {
Price::create(['item_id' => $item->id, 'customer_id' => $customer->id, 'custom_price' => $item->price, 'sellable' => '1', 'is_custom' => '0']);
}
return redirect('item')->with('message', 'Data berhasil dibuat!');
} catch (\Illuminate\Database\QueryException $e) {
return redirect('item')->with('message', 'Data dengan nama tersebut sudah digunakan!');
} catch (\PDOException $e) {
return redirect('item')->with('message', 'Data dengan nama tersebut sudah digunakan!');
}
}
public function getExample1()
{
//Order by amount
$items = \App\Item::orderBy('amount', 'asc')->get();
dump($items->toArray());
foreach ($items as $item) {
echo $item->name;
}
return 'Example 1';
}
public function add(Request $request)
{
//Get max item order id and add 1
$order = Item::orderBy('item_order', 'desc')->pluck('item_order');
$order++;
$item = new Item();
$item->title = $request->input('entry');
$item->item_order = $order;
$item->save();
$returnId = $item->id;
return array("id" => $returnId);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$userid = Auth::id();
$items = Item::orderBy('item_name', 'asc')->get();
$editInput = Item::findOrFail($id);
$skuscan = null;
$email = User::where('id', $userid)->first()->email;
$scan = Scan::where('userEmail', $email)->first();
if ($scan) {
$skuscan = $scan;
}
$totalValue = Item::where('user', $userid)->sum('price');
$totalQuantity = Item::where('user', $userid)->sum('quantity');
return view('inventory', compact('items', 'editInput', 'totalValue', 'totalQuantity', 'skuscan'));
}
<?php
use App\Item;
$app->get('/', function () use($app) {
$items = Item::orderBy('item_order', 'asc')->get();
return view('index', ['items' => $items]);
});
$app->post('/add-item', 'App\\Http\\Controllers\\ItemController@add');
$app->post('/edit-item', 'App\\Http\\Controllers\\ItemController@edit');
$app->post('/delete-item', 'App\\Http\\Controllers\\ItemController@delete');
$app->post('/sort-items', 'App\\Http\\Controllers\\ItemController@sort');
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$items = App\Item::orderBy('name')->get();
return $items;
}
public function index()
{
$items = Item::orderBy('id', 'DESC')->paginate(10);
return view('item.index', compact('items'));
}
