@extends('layouts.admin.master')
@section('title', 'Purchase Reports')
<link rel="stylesheet" href="{{ asset('css/links_css/dataTable.2.0.8.css') }}">
<link rel="stylesheet" href="{{ asset('css/links_css/buttons.dataTables.3.0.2.css') }}">

@section('content')
    <style>
        .purchase_report_list_by_default {
            table-layout: fixed;
            width: 100%;
        }

        .purchase_report_list_by_default th {
            overflow: hidden;
            text-overflow: ellipsis;
            white-space: nowrap;
        }
    </style>
    <section class="home-section">
        <div class="home-title">
            <i class='bx bx-menu'></i>
            <span class="text">Purchase Reports</span>
        </div>
        <div class="home-content" style="margin-left: 20px">
            <div class="table_buttons_container mb-3"
                style="display: flex; justify-content:end; gap:5px; margin-right:11px">
                <button class="btn btn-primary" id="btn_itemSummary_print"><i class="fa-solid fa-print"></i> Print</button>
                <button class="btn btn-success" id="btn_itemSummary_excel"><i class="fa-solid fa-file-excel"></i>
                    Excel</button>
                <button class="btn btn-danger" id="btn_itemSummary_pdf"><i class="fa-solid fa-file-pdf"></i> PDF</button>
            </div>
            <div class="purchase_report_container row">
                <div class="col-3 purchase_filter">
                    <div class="border border-1 p-3 rounded-2 mt-3">
                        <label class="mb-3" style="color: #512da8">Search By Date:</label>
                        <div class="mb-3 ms-3">
                            <label class="form-label">Start Date</label>
                            <input type="date" class="form-control" id="startDate" name="startDate">
                        </div>
                        <div class="mb-3 ms-3">
                            <label class="form-label">End Date</label>
                            <input type="date" class="form-control" id="endDate" name="endDate">
                        </div>
                    </div>
                    <div class="border border-1 p-3 mt-3 rounded-2">
                        <label class="mb-3" style="color: #512da8">Search By Item Summary:</label>
                        <div class="form-check mb-3 mx-3">
                            <input class="form-check-input" type="checkbox" id="byItemSummaryCheck"
                                name="byItemSummaryCheck">
                            <label class="form-check-label" for="byItemSummaryCheck">By Item Summary</label>
                        </div>
                        <div class="searchCategoryCheck_div form-check mb-3 ms-5 d-none">
                            <input class="form-check-input" type="checkbox" name="bySearchCategory" id="bySearchCategory">
                            <label class="form-check-label" for="bySearchCategory">By Category</label>
                        </div>
                        <div class="searchItemCheck_div form-check mb-3 ms-5 d-none">
                            <input class="form-check-input" type="checkbox" name="bySearchStockItem" id="bySearchStockItem">
                            <label class="form-check-label" for="bySearchStockItem">By Stock Item</label>
                        </div>
                        <div class="searchSupplierCheck_div form-check mb-3 ms-5 d-none">
                            <input class="form-check-input" type="checkbox" name="bySearchSupplier" id="bySearchSupplier">
                            <label class="form-check-label" for="bySearchSupplier">By Supplier</label>
                        </div>
                        <div class="selectCategory_div mx-3 d-none">
                            <select class="form-select form-select-sm" id="categoryList" name="categoryList">
                                {{-- <option value="0">--Select Category</option> --}}
                            </select>
                        </div>
                        <div class="selectItem_div mx-3 d-none">
                            <select class="form-select form-select-sm" id="stockItemList" name="stockItemList">
                                {{-- <option value="0">--Select Item</option> --}}
                            </select>
                        </div>
                        <div class="selectSupplier_div mx-3 d-none">
                            <select class="form-select form-select-sm" id="supplierList" name="supplierList">
                                {{-- <option value="0">--Select Item</option> --}}
                            </select>
                        </div>
                    </div>
                    <div style="display: flex; justify-content:end">
                        <button class="btn custom_btn" id="btn_purchase_search" name="btn_purchase_search">Search</button>
                    </div>
                </div>
                <div class="col-9">
                    <div class="purchase_table p-3">
                        {{-- <div class="table_buttons_container mb-3" style="display: flex; justify-content:end; gap:5px;">
                            <button class="btn btn-primary" id="btn_itemSummary_print"><i class="fa-solid fa-print"></i> Print</button>
                            <button class="btn btn-success" id="btn_itemSummary_export"><i class="fa-solid fa-file-excel"></i> Excel</button>
                            <button class="btn btn-danger" id="btn_itemSummary_pdf"><i class="fa-solid fa-file-pdf"></i> PDF</button>
                        </div> --}}
                        <div class="report_by_default_container">
                            <table id="purchase_report_list_by_default"
                                class="purchase_report_list_by_default display nowrap" style="width:100%;">
                                <thead>
                                    <tr>
                                        <th>No</th>
                                        <th>Purchase Date</th>
                                        <th>Purchase Voucher</th>
                                        <th>Supplier</th>
                                        <th>Total Amount</th>
                                        <th>Transport Charges</th>
                                        <th>Other Charges</th>
                                        <th>Tax</th>
                                        <th>Total Discount</th>
                                        <th>Net Amount</th>
                                        <th>Paid Amount</th>
                                        <th>Balance</th>
                                        <th>Due Date</th>
                                        <th>Remark</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $totalAmount = 0;
                                        $totalDebit = 0;
                                    @endphp
                                    @if (count($purchase_list) != 0)
                                        @php
                                            $count = 1;
                                        @endphp
                                        @foreach ($purchase_list as $purchase)
                                            <tr>
                                                <td style="text-align: center">{{ $count }}</td>
                                                <td>{{ date('d-m-Y', strtotime($purchase['purchase_date'])) }}</td>
                                                <td>{{ $purchase['purchase_voucher_number'] }}</td>
                                                <td style="word-wrap: break-word; white-space:normal;">
                                                    {{ $purchase['supplier_name'] }}</td>
                                                <td>{{ number_format($purchase['total_amount']) }}</td>
                                                <td>{{ number_format($purchase['transport_charges']) }}</td>
                                                <td>{{ number_format($purchase['other_charges']) }}</td>
                                                <td>{{ number_format($purchase['tax']) }}</td>
                                                <td>{{ number_format($purchase['discount_amount']) }}</td>
                                                <td>{{ number_format($purchase['total_amount'] + $purchase['transport_charges'] + $purchase['other_charges'] + $purchase['tax'] - $purchase['discount_amount']) }}
                                                </td>
                                                <td>{{ number_format($purchase['paid_amount']) }}</td>
                                                <td>{{ number_format($purchase['total_amount'] + $purchase['transport_charges'] + $purchase['other_charges'] + $purchase['tax'] - $purchase['discount_amount'] - $purchase['paid_amount']) }}
                                                </td>
                                                <td>{{ date('d-m-Y', strtotime($purchase['due_date'])) }}</td>
                                                <td style="word-wrap: break-word; white-space:normal;">
                                                    {{ $purchase['remark'] }}</td>
                                            </tr>
                                            @php
                                                $count++;
                                                $totalDebit +=
                                                    $purchase['total_amount'] +
                                                    $purchase['transport_charges'] +
                                                    $purchase['other_charges'] +
                                                    $purchase['tax'] -
                                                    $purchase['discount_amount'] -
                                                    $purchase['paid_amount'];
                                                $totalAmount += $purchase['total_amount'];
                                            @endphp
                                        @endforeach
                                    @endif
                                </tbody>
                            </table>
                        </div>
                        <div class="report_by_search_container d-none">
                            <table id="purchase_report_list_by_search" class="display nowrap" style="width:100%;">
                                <thead class="table_header">
                                    <tr>
                                        <th>No</th>
                                        <th>Purchase Date</th>
                                        <th>Purchase Voucher</th>
                                        <th>Supplier</th>
                                        <th>Item Name</th>
                                        <th>Category</th>
                                        <th>Unit</th>
                                        <th>Qty</th>
                                        <th>Unit Cost</th>
                                        <th>Amount</th>
                                        <th>Expire Date</th>
                                    </tr>
                                </thead>
                                <tbody class="body_data">
                                    <tr>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                    <div class="total_div row">
                        <div class="col-4">
                            {{-- <div class="row ms-3 d-flex align-items-center" style="margin-top: 35px">
                                <div class="col-5">
                                    <label class="form-label">Total Debit:</label>
                                </div>
                                <div class="col">
                                    <input class="form-control muted text-end" type="text" id="total_debit"
                                        name="total_debit" value="{{ number_format($totalDebit) }}" readonly>
                                </div>
                            </div> --}}
                        </div>
                        <div class="col-4">
                        </div>
                        <div class="col-4">
                            <div class="row ms-3 d-flex align-items-center" style="margin-top: 35px">
                                <div class="col-5">
                                    <label class="form-label">Total Amount:</label>
                                </div>
                                <div class="col">
                                    <input class="form-control muted text-end" type="text" id="total_amount"
                                        name="total_amount" value="{{ number_format($totalAmount) }}" readonly>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>

    <script src="{{ asset('script/links_js/jquery.3.6.4.min.js') }}"></script>
    <script src="{{ asset('script/links_js/jquery.validate.1.19.5.js') }}"></script>
    <script src="{{ asset('script/links_js/jquery.dataTables.1.13.7.min.js') }}"></script>
    <script src="{{ asset('script/links_js/dataTables.bootstrap5_1.13.7.min.js') }}"></script>

    <script src="{{ asset('script/links_js/jquery.table2excel.1.1.0.min.js') }}"></script>
    <script src="{{ asset('script/links_js/jspdf.umd.min.js') }}"></script>
    <script src="{{ asset('script/links_js/tableExport.1.30.0.min.js') }}"></script>
    <script src="{{ asset('script/printThis.js') }}"></script>

    <script src="{{ asset('script/purchase_report_script.js') }}"></script>
@endsection