public function paidRemain()
{
$inputs = Input::all();
$exchangerate = DB::table('exchange_rates')->orderBy('id', 'desc')->first();
for ($i = 0; $i < count($inputs['id']); $i++) {
if ($inputs['amount'][$i] > 0 && $inputs['amount'][$i] != "") {
$saleOrders = SaleOrder::where('id', $inputs['id'][$i])->first();
$inputs['amount'][$i] = $inputs['amount'][$i] > $saleOrders->balance ? $saleOrders->balance : $inputs['amount'][$i];
// To save sale order receipts table
$saleOrderReceipt = new SaleOrderReceipt();
$saleOrderReceipt['sales_order_id'] = $saleOrders->id;
$saleOrderReceipt['exchange_rate_id'] = $exchangerate->id;
$saleOrderReceipt['receipt_code'] = $this->generateAutoCode("sales_order_receipts", "receipt_code", 6, "RE");
$saleOrderReceipt['amount_us'] = 0;
$saleOrderReceipt['amount_kh'] = $inputs['amount'][$i];
$saleOrderReceipt['total_amount'] = $saleOrders->total_amount_riel;
$saleOrderReceipt['balance'] = $saleOrders->balance - $inputs['amount'][$i];
$saleOrderReceipt['pay_date'] = date('Y-m-d');
$saleOrderReceipt['due_date'] = date('Y-m-d');
$saleOrderReceipt['created_by'] = \Auth::user()->id;
$saleOrderReceipt['updated_by'] = \Auth::user()->id;
$saleOrderReceipt['is_active'] = 1;
$saleOrderReceipt->save();
$saleOrder = array();
$saleOrder['balance'] = $saleOrders->balance - $inputs['amount'][$i];
$saleOrders->whereId($saleOrders->id)->update($saleOrder);
}
}
return Response::json('result');
}
