/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit(Request $request, $id, $cLog_id)
{
$cLog = CollectionLog::find($cLog_id);
$actionOptions = [];
$actionOptions['Text'] = 'Text';
$actionOptions['Call'] = 'Call';
$actionOptions['Fax'] = 'Fax';
$actionOptions['Send SOA'] = 'Send SOA';
$actionOptions['Email'] = 'Email';
$actionOptions['Visit'] = 'Visit';
$reasonOptions = Reason::lists('reason', 'id');
$statusOptions = [];
$statusOptions['To Do'] = 'To Do';
$statusOptions['Done'] = 'Done';
// $salesinvoices = SalesInvoice::where('client_id', $id)
// ->where('status', '!=', 'Collected')
// ->where('status', '!=', 'Draft')
// ->orderBy('status', 'asc')
// ->get();
$salesinvoices = DB::SELECT("SELECT si.si_no, si.status, si.total_amount, si.date FROM sales_invoice_collection_logs sicl\n JOIN sales_invoices si ON sicl.sales_invoice_id = si.id\n JOIN collection_logs cl ON sicl.collection_log_id = cl.id\n WHERE cl.id = '{$cLog_id}'");
$date = Carbon::parse($cLog->date)->toFormattedDateString();
$method = 'patch';
return view('collection_logs.edit', compact('method', 'cLog', 'date', 'actionOptions', 'statusOptions', 'reasonOptions', 'id', 'salesinvoices'));
}
