/** * Show the form for creating a new resource. * * @return Response */ public function create() { $input = Input::all(); $dateX = \Carbon\Carbon::now(); $p_status = $input['payment_status']; $data = ['price' => $input['frm_payable'], 'payment_status' => $input['payment_status'], 'paid' => $input['frm_ammount'], 'due' => $input['frm_due'], 'installments' => $input['frm_inst_no'], 'cus_id' => $input['cus_id'], 'inv_id' => $input['inv_id'], 'sold_date' => $dateX->year . "-" . $dateX->month . "-" . $dateX->day, 'vat' => $input['frm_payVat'], 'bank_int' => $input['frm_payInt'], 'total_billed' => $input['total_bill'], 'ref_id' => $input['ref_id']]; if ($p_status == 'cash') { if ($data['due'] != 0) { return ['data' => 0, 'massage' => 'Please paid full amount or choose installment', 'status' => 0]; } else { $sold = Sell::create($data); $payment = ['car_sold_id' => $sold->id, 'cus_id' => $sold->cus_id, 'paid' => $sold->paid, 'interest' => 0, 'due_date' => $sold->sold_date, 'comment' => 'sold with cash', 'transection_id' => 1]; $update = DB::table('inventory')->where('id', '=', $sold->inv_id)->update(['is_sell' => '1']); $paid = CusPay::create($payment); return ['data' => ['sold_info' => ['id' => $sold->id, 'moto_price' => $sold->price, 'vat' => $sold->vat, 'bank_int' => $sold->bank_int, 'sold_date' => $sold->sold_date, 'total_billed' => $sold->total_billed, 'installments' => $sold->installments, 'paid' => $sold->paid, 'due' => $sold->due], 'paid_id' => $paid->id], 'massage' => 'Success to payment', 'status' => 1]; } } else { $sold = Sell::create($data); $dateLast = \Carbon\Carbon::parse($sold->sold_date)->addMonths($data['installments']); $dateNext = \Carbon\Carbon::parse($sold->sold_date)->addMonth(); $payment = ['car_sold_id' => $sold->id, 'cus_id' => $sold->cus_id, 'paid' => $sold->paid, 'interest' => 0, 'due_date' => $sold->sold_date, 'transection_id' => 1, 'comment' => 'sold with due']; $loan = ['sold_id' => $sold->id, 'rate' => $input['frm_inst_rate'], 'total_inst' => $sold->installments, 'current_inst' => 1, 'current_paid' => $sold->paid, 'current_due' => $sold->due, 'next_pay_date' => $dateNext->year . "-" . $dateNext->month . "-" . $dateNext->day, 'end_date' => $dateLast->year . "-" . $dateLast->month . "-" . $dateLast->day]; $setLoan = Loan::create($loan); $update = DB::table('inventory')->where('id', '=', $sold->inv_id)->update(['is_sell' => '1']); $paid = CusPay::create($payment); return ['data' => ['sold_info' => ['id' => $sold->id, 'moto_price' => $sold->price, 'vat' => $sold->vat, 'bank_int' => $sold->bank_int, 'sold_date' => $sold->sold_date, 'total_billed' => $sold->total_billed, 'paid' => $sold->paid, 'due' => $sold->due, 'total_inst' => $setLoan->total_inst, 'rate' => $setLoan->rate], 'paid_id' => $paid->id, 'loan_id' => $setLoan->id], 'massage' => 'Success to payment', 'status' => 1]; } }