/** * 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'); }); }