/**
* 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);
}
public static function check_data($user)
{
if ($user == 'moving') {
$data = LocationMovingTr::count();
} elseif ($user == 'items') {
$data = Item::count();
} elseif ($user == 'location') {
$data = Location::count();
} elseif ($user == 'sale') {
$data = Sale::count();
} elseif ($user == 'receiving') {
$data = Receiving::count();
} elseif ($user == 'saletemp') {
$data = SaleTemp::count();
}
return $data;
}
/**
* 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 readSales(Request $request)
{
$id = Input::get('term');
$results = Sale::select('id', 'customer_name')->where('id', '=', $id)->orWhere('customer_name', 'like', '%' . $id . '%')->get();
return Response::json($results);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$salesReport = Sale::orderBy('created_at', 'desc')->paginate(15);
return view('report.sale')->with('saleReport', $salesReport);
}
