/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
DB::transaction(function () {
// Get Max invoice id
$data = new Sale();
$invoice_id = $data->get_invoice_id();
$invoice_id++;
$mytime = Carbon::now();
//$date = $mytime->toDateTimeString();
$date = date("Y-m-d H:i:s");
// Insert in sale table
$net_amount = Input::get('net_amount');
$discount_amount = Input::get('discount_amount');
$user_id = Session::get('user_id');
$shop_id = Session::get('shop_id');
$arrayInsert = array('net_amount' => $net_amount, "created_at" => $date, "discount_amount" => $discount_amount, "invoice_id" => $invoice_id, "shop_id" => $shop_id, "user_id" => $user_id);
$last_sale_id = Sale::insertGetId($arrayInsert);
if ($last_sale_id != 0 && $last_sale_id != "") {
// Insert in sale detail table
$product_id = Input::get('product_id');
for ($i = 0; $i < count($product_id); $i++) {
$arrData[] = array("product_price" => Input::get("product_price.{$i}"), "product_qty" => Input::get("product_qty.{$i}"), "product_id" => Input::get("product_id.{$i}"), "sale_id" => $last_sale_id, "created_at" => $date);
}
$sale = salesDetails::insert($arrData);
echo "done";
}
// Redirect to sale page
//return Redirect::to('sale');
});
}
