<th>Action</th> <!-- <th>Follow-Up Date</th> --> <th>Notes</th> <th>Reason</th> <th>Sales Invoices</th> <th>Status</th> </tr> </thead> <tbody> @foreach ($collection_logs as $cLog) <tr> <?php $date = Carbon\Carbon::parse($cLog->date)->toFormattedDateString(); $salesinvoices = App\SalesInvoiceCollectionLog::join('clients', 'sales_invoice_collection_logs.client_id', '=', 'clients.id')->join('sales_invoices', 'sales_invoice_collection_logs.sales_invoice_id', '=', 'sales_invoices.id')->join('collection_logs', 'sales_invoice_collection_logs.collection_log_id', '=', 'collection_logs.id')->where('sales_invoice_collection_logs.client_id', $cLog->client_id)->where('sales_invoice_collection_logs.collection_log_id', $cLog->id)->select('*')->get(); ?> <td>{{ $date }}</td> <td>{{ $cLog->action }}</td> <td>{{ $cLog->note }}</td> @if ($cLog->Reason == null) <td>---------</td> @else <td>{{ $cLog->Reason->reason }}</td> @endif <td> @foreach($salesinvoices as $salesinvoice) <a href="{{ action ('SalesInvoicesController@show', [$salesinvoice->SalesInvoice->id])}}">{{$salesinvoice->SalesInvoice->si_no}}</a> <br>
<tr> <th></th> <th>Sales Invoice</th> <th>Status</th> <th>Amount</th> <th>Date</th> </tr> </thead> <tbody> @foreach ($salesinvoices as $salesinvoice) <tr> <?php if ($method == 'post') { $salescount = 0; } else { $salescount = App\SalesInvoiceCollectionLog::where('client_id', '=', $salesinvoice->client_id)->where('sales_invoice_id', '=', $salesinvoice->id)->where('collection_log_id', '=', $cLog->id)->count(); } ?> @if ($salescount != 0) <td> {!! Form::checkbox('check_list['.$salesinvoice->id.']', $salesinvoice->id, 'true') !!} </td> @else <td> {!! Form::checkbox('check_list['.$salesinvoice->id.']', $salesinvoice->id) !!} </td> @endif <td> {{ $salesinvoice->si_no }} </td> <td> {{ $salesinvoice->status }} </td> <td> {{ $salesinvoice->total_amount }} </td> <?php $date = Carbon\Carbon::parse($salesinvoice->date)->toFormattedDateString(); ?> <td> {{ $date }} </td> </tr>