/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$sale = new Sale();
$sale->product_id = ${$request}->product_id;
$sale->quantity = $request->item_quantity;
$sale->unit_price = $request->item_price;
$sale->save();
return view('dashboard/create_sale')->with('products', Product::where('is_published', 1)->orderBy("title")->get());
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(SaleRequest $request)
{
$sales = new Sale();
$sales->customer_id = Input::get('customer_id');
$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 = 'SALE' . $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 = 'SALE' . $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.complete')->with('sales', $sales)->with('saleItemsData', $saleItemsData)->with('saleItems', $itemssale);
}
private function setSaleData()
{
$sale = new Sale();
$saleDetails = new SAleDetail();
$saleDetails->quantity = Input::get('quantity');
$saleDetails->price = Input::get('price');
$saleDetails->invoice_id = Input::get('invoice_id');
$saleDetails->product_id = Input::get('product_id');
$saleDetails->branch_id = Input::get('branch_id');
$saleDetails->stock_info_id = Input::get('stock_info_id');
$saleDetails->product_type = Input::get('product_type');
$saleDetails->remarks = Input::get('remarks');
$saleDetails->save();
$hasSale = Sale::where('invoice_id', '=', Input::get('invoice_id'))->get();
if (empty($hasSale[0])) {
$sale->party_id = Input::get('party_id');
$sale->status = "Activate";
$sale->invoice_id = Input::get('invoice_id');
$sale->user_id = Session::get('user_id');
$sale->save();
}
$salesDetails = SAleDetail::find($saleDetails->id);
$list = $this->saleDetailConvertToArray($salesDetails);
return $list;
}
public function addSales()
{
$activeTab = 'sales';
$task_types = TaskType::all();
$saleTypes = SaleType::all();
$user = Auth::user();
$today_target = 140;
$add_sales = $this->doubleValue(Input::get('sales'));
if (empty($add_sales) || $add_sales <= 0) {
$today_total = $this->getTodaysStats();
$message = '<strong>Oh snap!</strong>. Please enter a value of 1 or above. You entered \'' . Input::get('point') . '\'. Try submitting again.';
$isErr = true;
return view('myStat.add', compact('user', 'today_total', 'task_types', 'tasks', 'activeTab', 'isErr', 'message', 'today_target', 'saleTypes'));
} else {
$saleType = SaleType::findOrfail(Input::get('saleType_id'));
$salesAudit = new SaleAudit();
$salesAudit->sale = $add_sales;
if (stripos(Input::get('sales'), '-') !== false) {
$salesAudit->sale = -1 * $salesAudit->sale;
}
$salesAudit->user_id = Auth::user()->id;
$salesAudit->company_id = Auth::user()->company_id;
$salesAudit->saleType_id = $saleType->id;
$salesAudit->date = new \DateTime();
$salesAudit->save();
$salesID = Input::get('saleType_id') . $user->id . date("mdY");
$salesEntity = Sale::find($salesID);
if ($salesEntity != null) {
$salesEntity->sale = $salesEntity->sale + $salesAudit->sale;
$salesEntity->update();
} else {
$salesEntity = new Sale();
$salesEntity->id = $salesID;
$salesEntity->month = date("m");
$salesEntity->year = date("Y");
$salesEntity->user_id = $user->id;
$salesEntity->saleType_id = Input::get('saleType_id');
$salesEntity->company_id = $user->company_id;
$salesEntity->sale = $salesAudit->sale;
$salesEntity->save();
}
$message = 'You have added <strong>' . number_format($salesAudit->sale, 2) . ' points</strong> to <strong>' . $saleType->name . '</strong>.';
$today_total = $this->getTodaysStats();
$isErr = false;
return view('myStat.add', compact('user', 'today_total', 'task_types', 'tasks', 'activeTab', 'isErr', 'message', 'today_target', 'saleTypes'));
}
}
public function decrease(Request $request)
{
$view = $this->modifyQuantity($request, -1);
if ($view == false) {
return;
}
$sale = new Sale();
$sale->product_id = $request->product_id;
$sale->quantity = 1;
$sale->unit_price = Product::find($request->product_id)->sale_price;
$sale->save();
return $view;
}
