@extends('layouts.admin')


@push('styles')
<link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">


<link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">


<link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">


<style type="text/css">
    .btn_mt {
        margin-top: 31px;
    }

    .company_logo {
        width: 225px;
    }

    .company_name {
        margin-left: 25px;
    }

    .hb {
        font-size: 18px;
        margin: 12px 0 0 0;
        padding: 0;
    }

    .hb2 {
        font-size: 18px;
        margin: 3px 0 0 0;
        padding: 0;
    }

    #unitname {
        position: relative;
        top: 11px;
    }

    #btn_looding {
        display: none;
    }

    .pro_excel {
        display: block;
    }

    @media print {
        .company_logo {
            width: 225px;
        }
    }
</style>
@endpush


@section('content')

<!-- Main content -->
<section class="content">
    <div class="container-fluid pt-2">

        <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-info">

                <!-- form start -->
                <form method="GET" action="{{ route('report.incexprpt') }}">
                    <div class="card-body">
                        <div class="row">

                            <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="formdate">From Date</label>
                                    <div class="input-group date" id="formdate" data-target-input="nearest">
                                        <input type="text" class="form-control form-control-sm datetimepicker-input"
                                            data-target="#formdate" name="formdate" id="formdate"
                                            value="{{ $formdate }}" placeholder="Enter From Date" required />
                                        <div class="input-group-append" data-target="#formdate"
                                            data-toggle="datetimepicker">
                                            <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                        </div>
                                    </div>

                                </div>
                            </div>

                            <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="todate">To Date</label>
                                    <div class="input-group date" id="todate" data-target-input="nearest">
                                        <input type="text" class="form-control form-control-sm datetimepicker-input"
                                            data-target="#todate" name="todate" id="todate"
                                            value="{{ $todate }}" placeholder="Enter To Date" required />
                                        <div class="input-group-append" data-target="#todate"
                                            data-toggle="datetimepicker">
                                            <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="type">Type</label>

                                    <select id="type" name="type" class="form-control form-control-sm"
                                        value="" style="width: 100%;">
                                        <option value="" disabled>Select Type</option>
                                        <option {{ $type == 'details' ? 'selected' : '' }} value="details">Details
                                        </option>
                                        <option {{ $type == 'summary' ? 'selected' : '' }} value="summary">Summary
                                        </option>
                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-2">
                                <button type="submit" style="margin-top: 30px;"
                                    class="btn btn-sm btn-primary btn_mt">Search</button>
                                <a href="{{ route('report.incexprpt') }}" style="margin-top: 30px;"
                                    class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                            </div>

                        </div>
                </form>
            </div>
        </div>

        <!-- /.card -->

        <div class="row">
            <!-- left column -->
            <div class="col-md-12">

                <div class="card card-info">
                    <div class="card-header">
                        <h3 class="card-title">Income Expense Report</h3>
                    </div>
                    <!-- /.card-header -->
                    <div id="print_section" class="card-body">
                        <div id="table2excel">
                            <table class="table table-sm table-bordered table-striped">

                                <thead>
                                    <tr>
                                        <th colspan="7">
                                            <div style="text-align: center;">
                                                <h2 class="pfont">
                                                    <div class="col-sm-12">
                                                        <span class="company_name"> <b>
                                                                <i>{{ $companies->company_name }}</i>
                                                            </b>
                                                        </span>
                                                    </div>

                                                    <p class="pfont hb">{{ $companies->address }}</p>
                                                    <p class="pfont hb2"> <b>Phone : </b>{{ $companies->contact_no }}
                                                    </p>
                                                    <p class="pfont hb"><b>Income Expense Report</b></p>
                                                </h2>
                                            </div>
                                            <p><b>Print Date:</b>{{ date('d-m-Y') }}</p>
                                        </th>
                                    </tr>
                                    <!-- <tr>
                                        <th colspan="7">Sale:</th>
                                    </tr>
                                    <tr>
                                        <th>SL</th>
                                        <th>Sale Date</th>
                                        <th>Invoice No</th>
                                        <th>Sale Qty.</th>
                                        <th>SD Amt.</th>
                                        <th>Vat Amt.</th>
                                        <th>Total</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if (!empty($saleData))
                                    @php
                                    $sl = 1;
                                    $ttsale = 0;
                                    @endphp
                                    @foreach ($saleData as $key => $sale)
                                    @php
                                    $saleDate = date('d-m-Y', strtotime($sale->sale_date));

                                    $quantity = number_format($sale->quantity, 2, '.', '');
                                    $vat_amt = number_format($sale->vat_amt, 2, '.', '');
                                    $sd_amt = number_format($sale->sd_amt, 2, '.', '');
                                    $dis_amt = number_format($sale->dis_amt, 2, '.', '');
                                    $amount = number_format($sale->amount, 2, '.', '');

                                    $ttsale = number_format($ttsale + $amount, 2, '.', '');
                                    @endphp
                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $saleDate }}</td>
                                        <td>{{ $sale->invoiceno }}</td>
                                        <td>{{ $quantity }}</td>
                                        <td>{{ $sd_amt }}</td>
                                        <td>{{ $vat_amt }}</td>
                                        <td>{{ $amount }}</td>
                                    </tr>
                                    @endforeach
                                    @endif
                                </tbody> -->

                                    <!-- <tfoot>
                                    <tr>
                                        <th colspan="6">Total Sale</th>
                                        <th>{{ $ttsale }}</th>
                                    </tr>
                                </tfoot> -->
                            </table>
                            <table class="table table-sm table-bordered table-striped">
                                <p><b>Expense:</b></p>
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>Entry Date</th>
                                        <th>Effect Date</th>
                                        <th>Description</th>
                                        <th>Total Amt.</th>
                                        <th>Entry User</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if (!empty($incData))
                                    @php
                                    $sl = 1;
                                    $ttincome = 0;
                                    @endphp
                                    @foreach ($incData as $key => $inc)
                                    @php
                                    $entryDate = date('d-m-Y', strtotime($inc->entryDate));
                                    $ttincome = $ttincome + $inc->amount;

                                    @endphp
                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $inc->created_at }}</td>
                                        <td>{{ $entryDate }}</td>
                                        <td>{{ $inc->description }}</td>
                                        <td>{{ $inc->amount }}</td>
                                        <td>{{ $inc->name }}</td>
                                    </tr>
                                    @endforeach
                                    @endif
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th colspan="4">Total Expense</th>
                                        <th>{{ $ttincome }}</th>
                                        <th></th>
                                    </tr>
                                </tfoot>
                            </table>

                            <table class="table table-sm table-bordered table-striped">
                                <p><b>Expenditure:</b></p>
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>Entry Date</th>
                                        <th>Effect Date</th>
                                        <th>Description</th>
                                        <th>Sub Group</th>
                                        <th>Total Amt.</th>
                                        <th>Entry User</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if (!empty($expData))
                                    @php
                                    $sl = 1;
                                    $ttExpense = 0;
                                    @endphp
                                    @foreach ($expData as $key => $inc)
                                    @php
                                    $entryDate = date('d-m-Y', strtotime($inc->entryDate));
                                    $ttExpense = number_format($ttExpense + $inc->amount, 2, '.', '');

                                    @endphp
                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $inc->created_at }}</td>
                                        <td>{{ $entryDate }}</td>
                                        <td>{{ $inc->description }}</td>
                                        <td>{{ $inc->sub_group_name }}</td>
                                        <td>{{ $inc->amount }}</td>
                                        <td>{{ $inc->name }}</td>
                                    </tr>
                                    @endforeach
                                    @endif
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th colspan="5">Total Expense</th>
                                        <th>{{ $ttExpense }}</th>
                                    </tr>
                                </tfoot>
                            </table>

                            <table class="table table-sm table-bordered table-striped">
                                <p><b>Assets:</b></p>
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>Entry Date</th>
                                        <th>Effect Date</th>
                                        <th>Description</th>
                                        <th>Sub Group</th>
                                        <th>Total Amt.</th>
                                        <th>Entry User</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if (!empty($assets))
                                    @php
                                    $sl = 1;
                                    $ttAssetAmt = 0;
                                    @endphp
                                    @foreach ($assets as $key => $asset)
                                    @php
                                    $entryDate = date('d-m-Y', strtotime($asset->entryDate));
                                    $ttAssetAmt = number_format(
                                    $ttAssetAmt + $asset->amount,
                                    2,
                                    '.',
                                    '',
                                    );

                                    @endphp
                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $asset->created_at }}</td>
                                        <td>{{ $entryDate }}</td>
                                        <td>{{ $asset->description }}</td>
                                        <td>{{ $asset->sub_group_name }}</td>
                                        <td>{{ $asset->amount }}</td>
                                        <td>{{ $asset->name }}</td>
                                    </tr>
                                    @endforeach
                                    @endif
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th colspan="5">Total</th>
                                        <th>{{ $ttAssetAmt }}</th>
                                        <th></th>
                                    </tr>
                                </tfoot>
                            </table>

                            <table class="table table-sm table-bordered table-striped">
                                <p><b>Supplier Payment:</b></p>
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>Pay Date</th>
                                        <th>Pay. No</th>
                                        <th>Supplier</th>
                                        <th>Pay. Method</th>
                                        <th>Pay. Amount</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $sl = 1;
                                    $ttBill = 0;
                                    @endphp

                                    @foreach ($bill as $b)
                                    @php
                                    $ttBill = number_format($ttBill + $b->payAmt, 2, '.', '');
                                    @endphp
                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td> {{ Helper::dateFormate($b->payDate) }} </td>
                                        <td>{{ $b->payNo }} </td>
                                        <td>{{ $b->supplier_name }} </td>
                                        <td>{{ $b->pmode_name }} </td>
                                        <td>{{ $b->payAmt }} </td>
                                    </tr>
                                    @endforeach

                                    <br />
<b>Warning</b>:  Undefined variable $ttincome in <b>D:\agemark\server\htdocs\New folder\resources\views\report\incexprpt.blade.php</b> on line <b>397</b><br />
<br />
<b>Warning</b>:  Undefined variable $ttsale in <b>D:\agemark\server\htdocs\New folder\resources\views\report\incexprpt.blade.php</b> on line <b>397</b><br />
<br />
<b>Warning</b>:  Undefined variable $ttExpense in <b>D:\agemark\server\htdocs\New folder\resources\views\report\incexprpt.blade.php</b> on line <b>398</b><br />
<br />
<b>Warning</b>:  Undefined variable $ttBill in <b>D:\agemark\server\htdocs\New folder\resources\views\report\incexprpt.blade.php</b> on line <b>398</b><br />
<br />
<b>Warning</b>:  Undefined variable $ttAssetAmt in <b>D:\agemark\server\htdocs\New folder\resources\views\report\incexprpt.blade.php</b> on line <b>398</b><br />
<br />
<b>Warning</b>:  Undefined variable $ttincome in <b>D:\agemark\server\htdocs\New folder\resources\views\report\incexprpt.blade.php</b> on line <b>398</b><br />
<br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;Helper&quot; not found in D:\agemark\server\htdocs\New folder\resources\views\report\incexprpt.blade.php:400
Stack trace:
#0 {main}
  thrown in <b>D:\agemark\server\htdocs\New folder\resources\views\report\incexprpt.blade.php</b> on line <b>400</b><br />