public function getPartydue($party_id)
{
$partySales = PurchaseInvoice::where('party_id', '=', $party_id)->where('status', '!=', 'Completed')->get();
if (count($partySales) > 0) {
$totalAmount = 0;
$totalPrice = 0;
foreach ($partySales as $sale) {
$saleDetails = PurchaseInvoiceDetail::where('detail_invoice_id', '=', $sale->invoice_id)->get();
$transactions = Transaction::where('invoice_id', '=', $sale->invoice_id)->where('payment_method', '=', 'Check')->where('type', '=', 'Payment')->where('cheque_status', '=', 1)->get();
foreach ($saleDetails as $saleDetail) {
$totalPrice = $totalPrice + $saleDetail->price * $saleDetail->quantity;
}
foreach ($transactions as $transaction) {
$totalAmount = $totalAmount + $transaction->amount;
}
$transactions2 = Transaction::where('invoice_id', '=', $sale->invoice_id)->where('type', '=', 'Payment')->where('payment_method', '!=', 'Check')->get();
foreach ($transactions2 as $transaction) {
$totalAmount = $totalAmount + $transaction->amount;
}
}
$due = $totalPrice - $totalAmount;
echo "<p3 style='color: red;font-size: 114%; margin-left: 32px;'>Due is {$due}</p3>";
} else {
echo "<p3 style='color: blue;font-size: 114%; margin-left: 32px; '>No Due</p3>";
}
}
<th>Cheque No</th>
<th>Cheque Date</th>
<th>Amount</th>
<th>Received by</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$slNo = 1;
?>
@foreach($purchaseregister as $reg)
<?php
if ($reg->type == 'Payment') {
$sale = \App\PurchaseInvoice::where('invoice_id', '=', $reg->invoice_id)->first();
$partyname = \App\Party::find($sale->party_id);
} else {
$sale = \App\Expense::where('invoice_id', '=', $reg->invoice_id)->first();
}
$time = strtotime($reg->cheque_date);
$newformat = date('d', $time);
$today = date('d', time());
?>
<tr>
<td <?php
if ($newformat >= $today - 2 && $newformat <= $today + 2) {
echo "class='blink'";
}
?>
>{{$slNo}}</td>
</td>
</tr>
</table>
<table class="col-md-12" style="width: 100%;" >
<tr style="border:1px solid black; background: url('../../assets/img/lightBlueBackground.jpg');">
<td colspan="2">Received from:
@if($transaction->type == "Receive")
<?php
$sales = \App\Sale::where('invoice_id', '=', $transaction->invoice_id)->first();
?>
{{$sales->party->name}}
@elseif($transaction->type == "Payment")
<?php
$sales = \App\PurchaseInvoice::where('invoice_id', '=', $transaction->invoice_id)->first();
?>
{{$sales->party->name}}
@endif
</td>
<td style="border:1px solid black;" class="text-center">
Amount
</td>
</tr>
<tr style="border:1px solid black;">
<td colspan="2">
Being: {{$transaction->remarks}}<br>
Payment Mode: <?php
if ($transaction->payment_method == 'Check') {
echo 'Cheque';
} else {
public function getDel($id)
{
$del = PurchaseInvoice::where('invoice_id', '=', $id)->get();
try {
$del[0]->deletee();
Session::flash('message', 'Purchase Invoice has been Successfully Deleted.');
} catch (Exception $e) {
Session::flash('message', 'This Purchase Invoice can\'t delete because it is used to file');
}
return Redirect::to('purchases/index');
}
