public function newItem()
{
$type = Input::get('type');
if ($type == 1) {
$ReceivingTemps = new ReceivingTemp();
$ReceivingTemps->item_id = Input::get('item_id');
$ReceivingTemps->cost_price = Input::get('cost_price');
$ReceivingTemps->total_cost = Input::get('total_cost');
$ReceivingTemps->quantity = 1;
$ReceivingTemps->save();
return $ReceivingTemps;
} else {
$itemkits = ItemKitItem::where('item_kit_id', Input::get('item_id'))->get();
foreach ($itemkits as $value) {
$item = Item::where('id', $value->item_id)->first();
$ReceivingTemps = new ReceivingTemp();
$ReceivingTemps->item_id = $value->item_id;
$ReceivingTemps->cost_price = $item->cost_price;
$ReceivingTemps->total_cost = $item->cost_price * $value->quantity;
$ReceivingTemps->quantity = $value->quantity;
$ReceivingTemps->save();
//return $ReceivingTemps;
}
return $ReceivingTemps;
}
}
public function getCancha(Request $request)
{
$cancha = $request->input('term');
$canchas = Item::all();
$result = [];
foreach ($canchas as $sede) {
if (strpos(Str::lower($sede), $cancha) !== false) {
$result[] = $sede;
}
}
return $result;
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$items = Item::find($id);
$items->quantity = $items->quantity + Input::get('in_out_qty');
$items->save();
$inventories = new Inventory();
$inventories->item_id = $id;
$inventories->user_id = Auth::user()->id;
$inventories->in_out_qty = Input::get('in_out_qty');
$inventories->remarks = Input::get('remarks');
$inventories->save();
Session::flash('message', 'You have successfully updated item');
return Redirect::to('inventory/' . $id . '/edit');
}
public function scanitem()
{
$code = Input::get('mysearch');
$item = Item::where('barcode', $code)->firts();
$SaleTemps = new ItemTemp();
$SaleTemps->item_id = $item->id;
$SaleTemps->cost_price = $item->cost_price;
$SaleTemps->selling_price = $item->selling_price;
$SaleTemps->quantity = Input::get('myquantity');
$SaleTemps->total_cost = $item->cost_price;
$SaleTemps->total_selling = $item->selling_price;
$SaleTemps->save();
return Redirect::to('sales');
}
public static function item_detailed($group_id, $loc_id)
{
$barcode = Session::get('items');
foreach ($barcode as $key) {
$code = $key->barcode;
}
if (count($barcode) == 1) {
$StockItems = Item::where('fk_cat', $group_id)->where('fk_location', $loc_id)->where('barcode', $code)->get();
} else {
$StockItems = Item::where('fk_cat', $group_id)->where('fk_location', $loc_id)->get();
}
if (count($StockItems) > 0) {
return $StockItems;
} else {
return $StockItems = array('no' => 'barang kosong');
}
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
$items = Item::where('type', 1)->count();
$item_kits = Item::where('type', 2)->count();
$customers = Customer::count();
$suppliers = Supplier::count();
$receivings = Receiving::count();
$sales = Sale::count();
$employees = User::count();
// passing jam variable
$array_hari = array(1 => "Senin", "Selasa", "Rabu", "Kamis", "Jum'at", "Sabtu", "Minggu");
$hari = $array_hari[date("N")];
$tanggal = date("j");
$array_bulan = array(1 => "Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");
$bulan = $array_bulan[date("n")];
$tahun = date("Y");
$date = "{$tanggal} {$bulan} {$tahun}";
$time = date("H:i:s");
//end jam
return view('home')->with('items', $items)->with('item_kits', $item_kits)->with('customers', $customers)->with('suppliers', $suppliers)->with('receivings', $receivings)->with('sales', $sales)->with('employees', $employees)->with('date', $date);
}
public function additems()
{
//scenario di dalam create transaksi
if (Input::has('additems')) {
//Get all items in the cart so far...
$items = $this->get_cart();
$maxkey = 0;
//nilai tertinggi
$insertkey = 0;
foreach ($items as $item) {
//looping index key nya biar bisa nambah banyak
if ($maxkey <= $item['line']) {
$maxkey = $item['line'];
}
}
$insertkey = $maxkey + 1;
// cari id items barang
$id = Item::select('id')->where('barcode', '=', $this->get_in('barcode'))->value('id');
//bentukan data session
$item = array($insertkey => array('id' => $id, 'barcode' => $this->get_in('barcode'), 'qty' => $this->get_in('qty'), 'line' => $insertkey));
$items += $item;
//add items
//storing ke session
$this->set_cart($items);
return redirect('warehouse_move_items/create');
}
//end of add items new transaksi
//scenario datam detail transaksi
}
public function readBarcode(Request $request)
{
$id = Input::get('term');
$results = Item::select('barcode', 'item_name', 'upc_ean_isbn')->where('id', $id)->orWhere('barcode', 'LIKE', '%' . $id . '%')->orWhere('upc_ean_isbn', 'like', '%' . $id . '%')->orWhere('item_name', 'like', '%' . $id . '%')->get();
return Response::json($results);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$sales = new Sale();
// $sales->customer_id = Input::get('customer_id');
Session::put('add_payment', Input::get('add_payment'));
$sales->customer_id = 1;
$sales->customer_name = Input::get('customer_name');
$sales->user_id = Auth::user()->id;
$sales->payment_type = Input::get('payment_type');
$sales->comments = Input::get('comments');
$sales->save();
// process sale items
$saleItems = SaleTemp::all();
foreach ($saleItems as $value) {
$saleItemsData = new SaleItem();
$saleItemsData->sale_id = $sales->id;
$saleItemsData->item_id = $value->item_id;
$saleItemsData->cost_price = $value->cost_price;
$saleItemsData->selling_price = $value->selling_price;
$saleItemsData->quantity = $value->quantity;
$saleItemsData->total_cost = $value->total_cost;
$saleItemsData->total_selling = $value->total_selling;
$saleItemsData->save();
//process inventory
$items = Item::find($value->item_id);
if ($items->type == 1) {
$inventories = new Inventory();
$inventories->item_id = $value->item_id;
$inventories->user_id = Auth::user()->id;
$inventories->in_out_qty = -$value->quantity;
$inventories->remarks = 'SL0000' . $sales->id;
$inventories->save();
//process item quantity
$items->quantity = $items->quantity - $value->quantity;
$items->save();
} else {
$itemkits = ItemKitItem::where('item_kit_id', $value->item_id)->get();
foreach ($itemkits as $item_kit_value) {
$inventories = new Inventory();
$inventories->item_id = $item_kit_value->item_id;
$inventories->user_id = Auth::user()->id;
$inventories->in_out_qty = -($item_kit_value->quantity * $value->quantity);
$inventories->remarks = 'SL0000' . $sales->id;
$inventories->save();
//process item quantity
$item_quantity = Item::find($item_kit_value->item_id);
$item_quantity->quantity = $item_quantity->quantity - $item_kit_value->quantity * $value->quantity;
$item_quantity->save();
}
}
}
//delete all data on SaleTemp model
SaleTemp::truncate();
$itemssale = SaleItem::where('sale_id', $saleItemsData->sale_id)->get();
Session::flash('message', 'You have successfully added sales');
//return Redirect::to('receivings');
return view('sale.complete2')->with('sales', $sales)->with('saleItemsData', $saleItemsData)->with('saleItems', $itemssale);
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$items = Item::find($id);
// process inventory
$receivingTemps = new ReceivingTemp();
$inventories->item_id = $id;
$inventories->quantity = Input::get('quantity');
$inventories->save();
Session::flash('message', 'You have successfully add item');
return Redirect::to('receivings');
}
public function stock()
{
$this->rem_ses('');
$invReports = Item::all();
// $locReports = Location::all();
// $groupReports = ItemGroup::all();
// $this->set_cart($invReports);
// $this->set_group($groupReports);
// $this->set_location($locReports);
return view('report.stock_items')->with('invReport', $invReports);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$items = Item::find($id);
// process inventory
$inventories = new Inventory();
$inventories->item_id = $id;
$inventories->user_id = Auth::user()->id;
$inventories->in_out_qty = Input::get('quantity') - $items->quantity;
$inventories->remarks = 'Manual Edit of Quantity';
$inventories->save();
// save update
$items->upc_ean_isbn = Input::get('upc_ean_isbn');
$items->item_name = Input::get('item_name');
$items->size = Input::get('size');
$items->satuan = Input::get('satuan');
$items->fk_cat = Input::get('fk_cat');
$items->fk_location = Input::get('fk_location');
$items->description = Input::get('description');
$items->cost_price = Input::get('cost_price');
$items->grocery_price = Input::get('grocery_price');
$items->selling_price = Input::get('selling_price');
$items->selling_price2 = Input::get('selling_price2');
$items->selling_price3 = Input::get('selling_price3');
$items->qty_min = Input::get('qty_min');
$items->qty_min_2 = Input::get('qty_min_2');
$items->qty_min_2 = Input::get('qty_min_3');
$items->disc_currency = Input::get('disc_currency');
$items->disc_persen = Input::get('disc_persen');
$items->quantity = Input::get('quantity');
$items->save();
// process avatar
$image = $request->file('avatar');
if (!empty($image)) {
$avatarName = 'item' . $id . '.' . $request->file('avatar')->getClientOriginalExtension();
$request->file('avatar')->move(base_path() . '/public/images/items/', $avatarName);
$img = Image::make(base_path() . '/public/images/items/' . $avatarName);
$img->resize(100, null, function ($constraint) {
$constraint->aspectRatio();
});
$img->save();
$itemAvatar = Item::find($id);
$itemAvatar->avatar = $avatarName;
$itemAvatar->save();
}
Session::flash('message', 'You have successfully updated item');
return Redirect::to('items');
}
