<?php

include('customer.php');
if (isset($_POST['csvUpload'])) {
    $csvFile = $_FILES['csv-upload']['tmp_name'];
    if ($_FILES["csv-upload"]["size"] > 0) {
        $file = fopen($csvFile, "r");
        fgetcsv($file); // Skip the header row
        while (($row = fgetcsv($file)) !== false) {
            $data = $obj->rawSql("SELECT ag_id FROM tbl_agent ORDER BY ag_id DESC LIMIT 1");
            $ag_id = $data ? $data[0]["ag_id"] + 1 : 1;
            $customerIdPrefix = $obj->getSettingValue('customerIdPrefix', 'customerIdPrefix');
            $STD = ($customerIdPrefix ?: "CUS") . str_pad($ag_id, 5, '0', STR_PAD_LEFT);

            $entry_date = isset($row[12]) && strtotime($row[12]) ? date('Y-m-d', strtotime($row[12])) : date('Y-m-d');
            $connection_date = isset($row[13]) && strtotime($row[13]) ? date('Y-m-d', strtotime($row[13])) : null;
            $last_zone_id = $obj->zoneCreate($row[16]);
            $fromInsert = [
                'cus_id' => $STD,
                'ag_name' => $row[0],
                'ip' => $row[1],
                'type' => 1,
                'mikrotik_disconnect' => $row[2],
                'taka' => $obj->convertBanglaToEnglishNumbers($row[3]),
                'mb' => $row[4],
                'int_mb' => intval($row[4]),
                'ag_status' => $row[5],
                'ag_mobile_no' => $obj->convertBanglaToEnglishNumbers($row[6]),
                'regular_mobile' => $obj->convertBanglaToEnglishNumbers($row[7]),
                'ag_office_address' => $row[8],
                'ag_email' => $row[9],
                'national_id' => $row[10],
                'gender' => $row[11],
                'billing_person_id' => $userId,
                'entry_by' => $userId,
                'entry_date' => $entry_date,
                'connection_date' => $connection_date,
                'zone' => $last_zone_id ?? null
            ];

            // if ($mikrotikConnect) {
            $fromInsert['mikrotik_id'] = 1;
            $fromInsert['queue_password'] = $row[14];
            // }

            $lastinsert = $obj->insertData('tbl_agent', $fromInsert);
            if ($lastinsert) {
                $obj->insertData('customer_billing', [
                    'agid' => $lastinsert,
                    'cusid' => $STD,
                    'monthlybill' => $obj->convertBanglaToEnglishNumbers($row[3]),
                    'previousdue' => $obj->convertBanglaToEnglishNumbers($row[15]),
                    'dueadvance' => $obj->convertBanglaToEnglishNumbers($row[15]),
                    'generate_at' => '2024-01-01'
                ]);

                // if ($mikrotikConnect) {
                $obj->createNewSecret(1, $row[1], $row[14], $row[4]);
                if (($row[5] == 0) || ($row[5] == 3)) {
                    $obj->disableSingleSecret(1, $row[1]);
                }
                // }
            }


            // create package
            $obj->packageCreate($row[4], $obj->convertBanglaToEnglishNumbers($row[3]));
        }

        $obj->notificationStore("New Customer Add Successful", 'success');
        echo '<script>window.location="?page=customer_view";</script>';
    }
}


?>
<!-- chart-2 end -->
<style>
    .table-responsive {
        overflow-x: auto;
    }
</style>
<input type="hidden" id="package-filter" value="<?= $_GET['package'] ?? 0 ?>">
<input type="hidden" id="ag_status_filter" value="<?= $_GET['ag_status'] ?? 0 ?>">
<input type="hidden" id="zone_filter" value="<?= $_GET['zone'] ?? 0 ?>">
<input type="hidden" id="sub_zone_filter" value="<?= $_GET['sub_zone'] ?? 0 ?>">
<input type="hidden" id="destination_filter" value="<?= $_GET['destination'] ?? 0 ?>">
<input type="hidden" id="isBillGenerate" value="<?= $_GET['billGenerate'] ?? 0 ?>">
<div class="col-md-12">
    <div class="card">
        <div class="card-body">
            <!-- Form Wizard Start -->
            <div class="form-wizard">
                <fieldset class="wizard-fieldset show">
                    <div class="row gy-3">
                        <div class="col">
                            <label for="zone-filter" class="form-label">Zone</label>
                            <div>
                                <select id="zone-filter" class="form-control" onchange="getSubZoneByZone(this.value)">
                                    <option value="">All Zones</option>
                                    <?php
                                    $conditions = "level = 1";
                                    ?>
                                    <?php foreach ($obj->view_all_by_cond('tbl_zone', $conditions) as $zone): ?>
                                        <option value="<?php echo $zone['zone_id']; ?>"><?php echo $zone['zone_name']; ?> </option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        </div>
                        <div class="col">
                            <label for="sub-zone-filter" class="form-label">Sub Zone</label>
                            <div>
                                <select id="sub-zone-filter" class="form-control" onchange="getDestinationBySubZone(this.value)">
                                    <option value="">All Sub Zones</option>
                                    <?php
                                    $conditions = "level = 2";
                                    ?>
                                    <?php foreach ($obj->view_all_by_cond('tbl_zone', $conditions) as $sub_zone): ?>
                                        <option value="<?php echo $sub_zone['zone_id']; ?>"><?php echo $sub_zone['zone_name']; ?> </option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        </div>
                        <div class="col">
                            <label for="destination-filter" class="form-label">Destination</label>
                            <div>
                                <select id="destination-filter" class="form-control">
                                    <option value="">All Destination</option>
                                    <?php
                                    $conditions = "level = 3";
                                    ?>
                                    <?php foreach ($obj->view_all_by_cond('tbl_zone', $conditions) as $destination): ?>
                                        <option value="<?php echo $destination['zone_id']; ?>"><?php echo $destination['zone_name']; ?> </option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        </div>
                        <div class="col">
                            <label for="billing-person-filter" class="form-label">Billing Person</label>
                            <div class="position-relative">
                                <select id="billing-person-filter" class="form-control">
                                    <option value="">All Billing Persons</option>
                                    <?php foreach ($obj->getAllData('vw_user_info') as $bp): ?>
                                        <option value="<?php echo $bp['UserId']; ?>"><?php echo $bp['FullName']; ?> </option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        </div>
                        <div class="col">
                            <label for="select-package-filter" class="form-label">Package</label>
                            <div>
                                <select id="select-package-filter" class="form-control">
                                    <option value="">All Packages</option>
                                    <?php foreach ($obj->getAllData('tbl_package') as $package): ?>
                                        <option value="<?php echo $package['net_speed']; ?>"><?php echo $package['net_speed']; ?> </option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        </div>
                        <div class="col">
                            <label for="status-filter" class="form-label">Status</label>
                            <div class="position-relative">
                                <select id="status-filter" class="form-control">
                                    <option value="">All</option>
                                    <option value="1">Active</option>
                                    <option value="0">Inactive</option>
                                    <option value="2">Free</option>
                                </select>
                            </div>
                        </div>
                        <div class="col">
                            <label for="date-from" class="form-label">From Date</label>
                            <div class="position-relative">
                                <input type="date" id="date-from" class="form-control">
                            </div>
                        </div>
                        <div class="col">
                            <label for="date-to" class="form-label">To Date</label>
                            <div class="position-relative">
                                <input type="date" id="date-to" class="form-control">
                            </div>
                        </div>
                    </div>
                </fieldset>
            </div>
            <!-- Form Wizard End -->
        </div>
    </div>
</div>

<div class="col-md-12">
    <div class="card h-100 p-0 radius-12">
        <div class="card-body p-24">
            <div class="mt-24">
                <div class="row mt-24 gy-4">
                    <!-- total customer -->
                    <div class="col-xxl-3 col-sm-6">
                        <div class="card p-3 shadow-none radius-8 border h-100 bg-gradient-end-1">
                            <div class="card-body p-0">
                                <div class="d-flex flex-wrap align-items-center justify-content-between gap-1 mb-8">

                                    <div class="d-flex align-items-center gap-2">
                                        <span class="mb-0 w-48-px h-48-px bg-primary-600 flex-shrink-0 text-white d-flex justify-content-center align-items-center rounded-circle h6 mb-0">
                                            <iconify-icon icon="flowbite:users-group-solid" class="icon"></iconify-icon>
                                        </span>
                                        <div>
                                            <span class="mb-2 fw-medium text-secondary-light text-sm">Total Customers</span>
                                            <!-- <h6 class="fw-semibold" id="totalCustomers">0</h6> -->
                                            <h6 class="fw-semibold" style="display: flex; justify-content: start; align-items: center;">
                                                <span style="font-size: 23px;" id="totalCustomers">0</span>
                                                <span style="font-size: 18px; margin: 0px 5px;"> => </span>
                                                <span style="font-size: 18px;" id="totalCustomerBill">৳0</span>
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- total active customers -->
                    <div class="col-xxl-3 col-sm-6">
                        <div class="card p-3 shadow-none radius-8 border h-100 bg-gradient-end-1">
                            <div class="card-body p-0">
                                <div class="d-flex flex-wrap align-items-center justify-content-between gap-1 mb-8">

                                    <div class="d-flex align-items-center gap-2">
                                        <span class="mb-0 w-48-px h-48-px bg-primary-600 flex-shrink-0 text-white d-flex justify-content-center align-items-center rounded-circle h6 mb-0">
                                            <iconify-icon icon="flowbite:users-group-solid" class="icon"></iconify-icon>
                                        </span>
                                        <div>
                                            <span class="mb-2 fw-medium text-secondary-light text-sm">Total Active Customers</span>
                                            <h6 class="fw-semibold" style="display: flex; justify-content: start; align-items: center;">
                                                <span style="font-size: 23px;" id="totalActiveCustomers">0</span>
                                                <span style="font-size: 18px; margin: 0px 5px;"> => </span>
                                                <span style="font-size: 18px;" id="totalActiveCustomersBill">৳0</span>
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- total inactive customers -->
                    <div class="col-xxl-3 col-sm-6">
                        <div class="card p-3 shadow-none radius-8 border h-100 bg-gradient-start-5">
                            <div class="card-body p-0">
                                <div class="d-flex flex-wrap align-items-center justify-content-between gap-1 mb-8">

                                    <div class="d-flex align-items-center gap-2">
                                        <span class="mb-0 w-48-px h-48-px border-danger-light-white bg-danger flex-shrink-0 text-white d-flex justify-content-center align-items-center rounded-circle h6 mb-0">
                                            <iconify-icon icon="flowbite:users-group-solid" class="icon"></iconify-icon>
                                        </span>
                                        <div>
                                            <span class="mb-2 fw-medium text-secondary-light text-sm">Total Inactive Customers</span>
                                            <h6 class="fw-semibold" style="display: flex; justify-content: start; align-items: center;">
                                                <span style="font-size: 23px;" id="totalInActiveCustomers">0</span>
                                                <span style="font-size: 18px; margin: 0px 5px;"> => </span>
                                                <span style="font-size: 18px;" id="totalInActiveCustomersBill">৳0</span>
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>


                    <!-- total free customers -->
                    <div class="col-xxl-3 col-sm-6">
                        <div class="card p-3 shadow-none radius-8 border h-100 bg-gradient-start-2">
                            <div class="card-body p-0">
                                <div class="d-flex flex-wrap align-items-center justify-content-between gap-1 mb-8">

                                    <div class="d-flex align-items-center gap-2">
                                        <span class="mb-0 w-48-px h-48-px bg-purple flex-shrink-0 text-white d-flex justify-content-center align-items-center rounded-circle h6 mb-0">
                                            <iconify-icon icon="flowbite:users-group-solid" class="icon"></iconify-icon>
                                        </span>
                                        <div>
                                            <span class="mb-2 fw-medium text-secondary-light text-sm">Total Free Customers</span>
                                            <h6 class="fw-semibold" style="display: flex; justify-content: start; align-items: center;">
                                                <span style="font-size: 23px;" id="totalFreeCustomers">0</span>
                                                <span style="font-size: 18px; margin: 0px 5px;"> => </span>
                                                <span style="font-size: 18px;" id="totalFreeCustomersBill">৳0</span>
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>


                    <!-- Running Month New customers -->
                    <div class="col-xxl-3 col-sm-6">
                        <div class="card p-3 shadow-none radius-8 border h-100 bg-gradient-start-4">
                            <div class="card-body p-0">
                                <div class="d-flex flex-wrap align-items-center justify-content-between gap-1 mb-8">

                                    <div class="d-flex align-items-center gap-2">
                                        <span class="mb-0 w-48-px h-48-px bg-success-main flex-shrink-0 text-white d-flex justify-content-center align-items-center rounded-circle h6 mb-0">
                                            <iconify-icon icon="flowbite:users-group-solid" class="icon"></iconify-icon>
                                        </span>
                                        <div>
                                            <span class="mb-2 fw-medium text-secondary-light text-sm"><?= date("F") ?> New Customers</span>
                                            <h6 class="fw-semibold" id="">

                                            </h6>

                                            <h6 class="fw-semibold" style="display: flex; justify-content: start; align-items: center;">
                                                <?php
                                                $newCustomersInfo = $obj->rawSqlSingle("SELECT COUNT(*) as TotalUsers, SUM(taka) as TotalBill FROM `tbl_agent` WHERE deleted_at is NULL AND MONTH(entry_date) = MONTH(CURDATE()) AND YEAR(entry_date) = YEAR(CURDATE());");
                                                ?>
                                                <span style="font-size: 23px;" id=""><?= $newCustomersInfo["TotalUsers"] ?? 0 ?></span>
                                                <span style="font-size: 18px; margin: 0px 5px;"> => </span>
                                                <span style="font-size: 18px;" id="">৳<?= $newCustomersInfo["TotalBill"] ?? 0 ?></span>
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Running Month Inactive customers -->
                    <div class="col-xxl-3 col-sm-6">
                        <div class="card p-3 shadow-none radius-8 border h-100 bg-gradient-start-5">
                            <div class="card-body p-0">
                                <div class="d-flex flex-wrap align-items-center justify-content-between gap-1 mb-8">

                                    <div class="d-flex align-items-center gap-2">
                                        <span class="mb-0 w-48-px h-48-px bg-danger flex-shrink-0 text-white d-flex justify-content-center align-items-center rounded-circle h6 mb-0">
                                            <iconify-icon icon="flowbite:users-group-solid" class="icon"></iconify-icon>
                                        </span>
                                        <div>
                                            <span class="mb-2 fw-medium text-secondary-light text-sm"><?= date("F") ?> Inactive Customers</span>
                                            <h6 class="fw-semibold" style="display: flex; justify-content: start; align-items: center;">
                                                <?php
                                                $runningMonthInactive = $obj->rawSqlSingle("SELECT COUNT(*) as TotalUsers, SUM(taka) as TotalBill FROM `tbl_agent` WHERE deleted_at is NULL  AND `ag_status` = '0' AND MONTH(inactive_date) = MONTH(CURDATE());");
                                                ?>
                                                <span style="font-size: 23px;" id=""><?= $runningMonthInactive["TotalUsers"] ?? 0 ?></span>
                                                <span style="font-size: 18px; margin: 0px 5px;"> => </span>
                                                <span style="font-size: 18px;" id="">৳<?= $runningMonthInactive["TotalBill"] ?? 0 ?></span>
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>


                    <!-- total bill amount -->
                    <div class="col-xxl-3 col-sm-6">
                        <div class="card p-3 shadow-none radius-8 border h-100 bg-gradient-end-1">
                            <div class="card-body p-0">
                                <div class="d-flex flex-wrap align-items-center justify-content-between gap-1 mb-8">

                                    <div class="d-flex align-items-center gap-2">
                                        <span class="mb-0 w-48-px h-48-px bg-primary-600 flex-shrink-0 text-white d-flex justify-content-center align-items-center rounded-circle h6 mb-0">
                                            <iconify-icon icon="hugeicons:invoice-03" class="icon"></iconify-icon>
                                        </span>
                                        <div>
                                            <span class="mb-2 fw-medium text-secondary-light text-sm">Total Collected Bill as of <span class="text-primary"><?php echo date('F') . " " . date("Y"); ?></span> </span>
                                            <h6 class="fw-semibold" id="totalbill">
                                                <?php echo $obj->rawSqlSingle("SELECT SUM(totalpaid) as TotalCollectedBill FROM `customer_billing`")["TotalCollectedBill"] ?? 0; ?>
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- total connection charge -->
                    <div class="col-xxl-3 col-sm-6">
                        <div class="card p-3 shadow-none radius-8 border h-100 bg-gradient-start-5">
                            <div class="card-body p-0">
                                <div class="d-flex flex-wrap align-items-center justify-content-between gap-1 mb-8">

                                    <div class="d-flex align-items-center gap-2">
                                        <span class="mb-0 w-48-px h-48-px border-pink-light-white bg-pink-light flex-shrink-0 text-pink d-flex justify-content-center align-items-center rounded-circle h6 mb-0">
                                            <iconify-icon icon="ri:discount-percent-fill" class="icon"></iconify-icon>
                                        </span>
                                        <div>
                                            <span class="mb-2 fw-medium text-secondary-light text-sm">Total Connection Charge Collected as of <span class="text-primary"><?php echo date('F') . " " . date("Y"); ?></span>
                                            </span>
                                            <h6 class="fw-semibold" id="totalconnectionfees">
                                                <?php echo $obj->rawSqlSingle("SELECT SUM(acc_amount) AS TotalConnectionCharge FROM `tbl_account` WHERE `acc_type` = 4")["TotalConnectionCharge"] ?? 0; ?>
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

</div>
<div class="col-md-12">
    <div class="card basic-data-table">
        <div class="card-header d-flex flex-wrap align-items-center justify-content-between">
            <h5 class="card-title mb-0">Customer List</h5>
            <div>
                <!--<a href="?page=cus_info" class="btn btn-success-600 radius-8 px-20 py-11">Customer Online Status</a>-->
                <a href="?page=bulk_zone" type="button" class="btn btn-success-600 radius-8 px-20 py-11">Bulk Edit</a>
                <button type="button" class="btn btn-success-600 radius-8 px-20 py-11" data-bs-toggle="modal" data-bs-target="#import">
                    Import Customer <i class="fa-solid fa-arrow-up"></i> </button>
            </div>
        </div>
        <div class="card-body table-responsive">
            <table
                class="table table-striped bordered-table mb-0"
                id="customer-datatable"
                data-page-length="10">
                <thead>
                    <tr>
                        <th scope="col">SL.</th>
                        <?php if ($obj->userWorkPermission('edit') || $obj->userWorkPermission('delete')) { ?>
                            <th scope="col">Action</th>
                        <?php } ?>
                        <th scope="col">ID</th>
                        <th scope="col">IP</th>
                        <th scope="col">Name</th>
                        <th scope="col">Address</th>
                        <th scope="col">Mobile No</th>
                        <th scope="col">Package</th>
                        <th scope="col">Bill Amount</th>
                        <th scope="col">Con.Date</th>
                        <th scope="col">Zone</th>
                        <th scope="col">B.Person</th>
                        <th scope="col">Status</th>
                    </tr>
                </thead>
                <tbody>
                </tbody>
            </table>
        </div>
    </div>
</div>
<div class="modal fade" id="import" tabindex="-1" aria-labelledby="saleModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-xl">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title fs-5" id="saleModalLabel">Upload CSV</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <h5 class="modal-title fs-5" id="saleModalLabel">CSV Structure</h5>
                <div class="card-body table-responsive">
                    <div class="py-3">
                        <a href="../../assets/democsv.csv" class="btn btn-success" download>Download Example CSV</a>
                    </div>
                    <table class="table bordered-table mb-0">
                        <thead>
                            <tr>
                                <th>Name</th>
                                <th>IP</th>
                                <th>Dis. day</th>
                                <th>Bill</th>
                                <th>Package</th>
                                <th>Status</th>
                                <th>Mobile</th>
                                <th>Mobile(Opt)</th>
                                <th>Address</th>
                                <th>Email</th>
                                <th>National ID</th>
                                <th>gender</th>
                                <th>Entry Date</th>
                                <th>Con. Date</th>
                                <th>Queue Password</th>
                                <th>Previous Due</th>
                                <th>Zone</th>
                            </tr>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
                <form class="flex-row" action="" enctype="multipart/form-data" method="post">
                    <div class="col-xxl-4">
                        <label for="csv-upload" class="form-label">Upload CSV</label>
                        <div class="position-relative">
                            <input type="file" id="csv-upload" class="form-control" name="csv-upload">
                        </div>
                    </div>
                    <div class="col-md-2" style="margin-top: 22px;">

                        <button type="submit" name="csvUpload" class="btn btn-success">Upload</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

<!-- end row-->
<button class="btn btn-info btn-lg" style="padding: 10px;margin-bottom: 16px;font-size: 21px;"
    id="graphicalViewButton">Graphical View</button>
<!-- chart start -->
<!-- Loading Bar (hidden by default) -->
<div style="display: none;" id="chart1Visibility">
    <div class="row gy-3 gx-3 mb-5" style="display: flex; justify-content: space-between;">
        <!-- customer count by month chart start -->
        <div class="col-12 col-xl-7 card p-2">
            <div class="card-header border-bottom bg-base py-16 px-24" style="display: flex; justify-content: space-between;">
                <h6 class="card-title text-lg fw-semibold mb-0">Customer Growth: <span id="customerCountYear"><?php echo date("Y") . " vs " . (intval(date("Y")) - 1); ?></span> Trend</h6>
                <div class="">
                    <select id="twoYearsCustomerTrendYearSelect" class="form-select form-select-sm w-auto bg-base border text-secondary-light">
                        <?php for ($i = date("Y"); $i >= 2020; $i--): ?>
                            <option value="<?= $i; ?>"><?= $i . " - " . ($i - 1); ?></option>
                        <?php endfor; ?>
                    </select>
                </div>
            </div>

            <!-- <div class="card-body p-24"> -->
            <div id="customer_view_line_chart"></div>
            <!-- </div> -->
        </div>
        <!-- customer count by month chart end -->

        <div class="col-12 col-xl-4 card p-2">
            <h6 style="padding: 10px;">Customer Statistics by Type</h6>
            <div id="customerStatisticsByStatusChart" class="apex-charts mt-3"></div>
        </div>

    </div>


    <div class="row gap-2" style="display: flex; justify-content: space-between;">
        <div class="col-12 col-xl-5 card p-2">
            <h6 style="padding: 10px;">Customer Statistics by Zone</h6>
            <div id="zoneWiseCustomerViewPieChart" class="apex-charts mt-3"></div>
        </div>

        <div class="col-12 col-xl-5 card p-2">
            <h6 style="padding: 10px;">Customer Statistics by Package</h6>
            <div id="packageWiseCustomerPieChart" class=" apex-charts pt-3" data-colors="#6658dd"></div>
        </div>
    </div>

    <div class="row" style="display: flex; justify-content: space-between; margin-top: 30px;">
        <div class="col-12 col-xl-12 card p-2">
            <div class="card-header border-bottom bg-base py-16 px-24" style="display: flex; justify-content: space-between;">
                <h6 class="card-title text-lg fw-semibold mb-0">Inactive Customers: <span id="customerInactiveCountYear"><?php echo date("Y") . " vs " . (intval(date("Y")) - 1); ?></span> Trend</h6>
                <div class="">
                    <select id="twoYearsInactiveCustomerTrendYearSelect" class="form-select form-select-sm w-auto bg-base border text-secondary-light">
                        <?php for ($i = date("Y"); $i >= 2020; $i--): ?>
                            <option value="<?= $i; ?>"><?= $i . " - " . ($i - 1); ?></option>
                        <?php endfor; ?>
                    </select>
                </div>
            </div>
            <div id="inactiveCustomerTrendingChart" class=""></div>
        </div>



    </div>

</div>

<?php $obj->start_script(); ?>
<script>
    $(document).ready(function() {
        var table = $('#customer-datatable').DataTable({
            dom: `<"row"<"col-sm-6"l><"col-sm-6 text-end"f>>` + // Show entries and search in one row
                `<"row"<"col-sm-12 text-end"B>>` + // Buttons in a separate row
                `<"row dt-layout-row"<"col-sm-12"tr>>` + // Table content
                `<"row"<"col-sm-5"i><"col-sm-7 text-end"p>>`, // Info left, pagination right

            keys: true,
            stateSave: true,
            lengthChange: true,
            responsive: false,
            pagingType: "full_numbers",
            processing: true, // Show processing indicator
            serverSide: true, // Enable server-side processing
            ajax: {
                url: "./pages/customer/customer_ajax.php", // URL to your PHP file
                type: "GET",
                data: function(d) {
                    d.zone = $('#zone-filter').val(); // Get zone filter value
                    d.sub_zone = $('#sub-zone-filter').val();
                    d.destination = $('#destination-filter').val();
                    d.bid = $('#billing-person-filter').val(); // Get billing person filter
                    d.status = $('#status-filter').val(); // Get status filter
                    d.datefrom = $('#date-from').val(); // Get date from filter
                    d.dateto = $('#date-to').val(); // Get date to filter
                    d.package_filter = $('#package-filter').val();
                    d.select_package_filter = $('#select-package-filter').val();
                    d.ag_status_filter = $('#ag_status_filter').val();
                    d.month = $('#month').val();
                    d.zone_filter = $('#zone_filter').val();
                    d.sub_zone_filter = $('#sub_zone_filter').val();
                    d.isBillGenerate = $('#isBillGenerate').val();
                }
            },
            columns: [{
                    data: 'sl',
                    orderable: false
                },
                <?php if ($obj->userWorkPermission('edit') || $obj->userWorkPermission('delete')) { ?> {
                        data: 'ag_id',
                        render: function(data, type, row) {
                            return ` <?php if ($obj->userWorkPermission('edit')) { ?>
                    <a
                    href="?page=customer_edit&token=` + data + `"
                    class="w-32-px h-32-px bg-success-focus text-success-main rounded-circle d-inline-flex align-items-center justify-content-center idupdate">
                    <iconify-icon icon="lucide:edit"></iconify-icon>
                </a>
                <?php } ?>
                 <?php if ($obj->userWorkPermission('delete')) { ?>
                <a onclick="swal.fire({
                        title: 'Are you sure?',
                        text: 'You want to temporary delete this customer!',
                        icon: 'warning',
                        showCancelButton: true,
                        confirmButtonColor: '#3085d6',
                        cancelButtonColor: '#d33',
                        confirmButtonText: 'Yes, delete it!'
                    }).then((result) => {
                        if (result.isConfirmed) {
                            window.location.href='?page=customer_view&delete-token=` + data + `';
                        }
                    });"
              class="w-32-px h-32-px bg-danger-focus text-danger-main rounded-circle d-inline-flex align-items-center justify-content-center cursor-pointer"
            >
              <iconify-icon
                icon="mingcute:delete-2-line"
              ></iconify-icon>
            </a>
                <?php } ?>
                `;
                        }
                    },
                <?php } ?> {
                    data: 'cus_id',
                    orderable: true,
                    render: function(data, type, row) {
                        return '<a class="btn btn-info waves-effect waves-light btn-sm" href="?page=customer_ledger&token=' + row['ag_id'] + '"> ' + data + ' </a>' +
                            ' <a href="#" class="w-32-px h-32-px bg-success-focus text-success-main rounded-circle d-inline-flex align-items-center justify-content-center send-sms" data-customerid=' + row['ag_id'] + '><iconify-icon icon="mdi:sms"></iconify-icon></a>';
                    }
                },
                {
                    data: 'ip',
                    orderable: true
                },
                {
                    data: 'ag_name',
                    orderable: true,
                    render: function(data, type, row) {
                        return "<span class='text-wrap'>" + data + "</span>";
                    }
                },
                {
                    data: 'ag_office_address',
                    orderable: true,
                    render: function(data, type, row) {
                        return (data != null) ? "<span class='text-wrap'>" + data + "</span>" : "N/A";
                    }
                },
                {
                    data: 'ag_mobile_no',
                    defaultContent: 'N/A',
                    orderable: true
                },
                {
                    data: 'mb',
                    defaultContent: 'N/A',
                    orderable: true
                },
                {
                    data: 'taka',
                    defaultContent: 'N/A',
                    orderable: true
                }, // Bill Amount
                {
                    data: 'connection_date',
                    orderable: true
                },
                {
                    data: 'zone_name',
                    orderable: true,
                    defaultContent: 'N/A',
                    render: function(data, type, row) {
                        return (data != null) ? "<span class='text-wrap'>" + data + "</span>" : "N/A";
                    }
                },
                {
                    data: 'FullName',
                    render: function(data, type, row) {
                        return (data != null) ? "<span class='text-wrap'>" + data + "</span>" : "N/A";
                    }
                },
                {
                    data: 'ag_status',
                    render: function(data, type, row) {
                        if (data == 0) {
                            return "<span class='text-danger'>Inactive</span>";
                        } else if (data == 1) {
                            return "<span class='text-success'>Active</span>";
                        } else if (data == 2) {
                            return "<span class='text-warning'>Free</span>";
                        } else if (data == 3) {
                            return "<span class='text-danger'>Discontinue</span>";
                        }
                    }
                },
            ],
            buttons: [{
                    extend: "copy",
                    exportOptions: {
                        columns: [0, 3, 4, 6, 7, 8, 9, 10, 11]
                    }
                },
                {
                    extend: "print",
                    exportOptions: {
                        columns: [0, 3, 4, 6, 7, 8, 9, 10, 11]
                    }
                },

                {
                    extend: "pdf",
                    className: "btn-light",
                    exportOptions: {
                        columns: [0, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
                    },
                    orientation: 'landscape',
                    pageSize: 'A4'
                },
                {
                    extend: "excel",
                    exportOptions: {
                        columns: [0, 2, 3, 4, 6, 7, 8, 9, 10, 11, 12]
                    }
                }
            ],
            language: {
                search: "_INPUT_",
                searchPlaceholder: "Search customers...",
                lengthMenu: "Show _MENU_ entries",
                emptyTable: "No data available in table"
            },
            lengthMenu: [10, 25, 50, 100, 500, 1000, 1500],
            order: [
                [1, 'asc']
            ], // Order by 'cus_id', adjust as needed
            initComplete: function(settings, json) {
                // This function is called once the table has been fully initialized
                // $('#totalbill').text(json.totalbill);
                $('#totalconnectionfee').text(json.totalconnectionFee);
                $('#totalCustomers').text(json.totalCustomers);
                $('#totalCustomerBill').text(`৳${json.totalCustomerBill ?? 0}`);
                $("#totalActiveCustomers").text(`${json.totalActiveCustomers}`);
                $("#totalActiveCustomersBill").text(`৳${json.totalActiveCustomerBill ?? 0}`);
                $("#totalInActiveCustomers").text(json.totalInActiveCustomers);
                $("#totalInActiveCustomersBill").text(`৳${json.totalInActiveCustomerBill ?? 0}`);
                $("#totalFreeCustomers").text(json.totalFreeCustomers);
                $("#totalFreeCustomersBill").text(`৳${json.totalFreeCustomerBill ?? 0}`);
            },
            drawCallback: function(settings) {
                var json = settings.json; // Get the JSON response
                // Update total bill and total connection fee after each table draw
                // $('#totalbill').text(json.totalbill);
                $('#totalconnectionfee').text(json.totalconnectionFee);
                $('#totalCustomers').text(json.totalCustomers);
                $('#totalCustomerBill').text(`৳${json.totalCustomerBill ?? 0}`);
                $("#totalActiveCustomers").text(`${json.totalActiveCustomers}`);
                $("#totalActiveCustomersBill").text(`৳${json.totalActiveCustomerBill ?? 0}`);
                $("#totalInActiveCustomers").text(json.totalInActiveCustomers);
                $("#totalInActiveCustomersBill").text(`৳${json.totalInActiveCustomerBill ?? 0}`);
                $("#totalFreeCustomers").text(json.totalFreeCustomers);
                $("#totalFreeCustomersBill").text(`৳${json.totalFreeCustomerBill ?? 0}`);
            }
        });

        // Trigger table reload when filters are changed
        $('#zone-filter, #billing-person-filter, #select-package-filter, #status-filter, #date-from, #date-to,#sub-zone-filter,#destination-filter').on('change', function() {
            table.ajax.reload();
        });


        // Handle SMS button click event
        $('#customer-datatable').on('click', '.send-sms', function() {
            $.get("./pages/customer/customer_sms_ajax.php", {
                token: $(this).data('customerid')
            }, function(result) {
                result = JSON.parse(result)
                if (result.response == true) {
                    Swal.fire({
                        icon: "success",
                        title: 'SMS was sent Successfull',
                        timer: 1500,
                        showConfirmButton: false,
                        position: "top-end"
                    });
                } else {
                    // alert(result.response.error_message);
                    Swal.fire({
                        icon: "error",
                        title: result.response.error_message,
                        timer: 1500,
                        showConfirmButton: false,
                        position: "top-end"
                    });
                }
            });
        });

    });
</script>


<!-- customer line chart -->
<script>
    $(document).ready(function() {
        // Add event listener for the button click
        $('#graphicalViewButton').click(function() {
            $('#loading-spinner').show()
            $("#chart1Visibility").show();
            // Perform AJAX request when the button is clicked

            // two years customer trending chart start
            function twoYearsCustomerSelectChart(selectedYear) {
                $.ajax({
                    type: "GET",
                    url: `./pages/customer/customer_view_line_chart_ajax.php?selectedYear=${selectedYear}`,
                    dataType: "json",
                    success: function(response) {
                        $('#loading-spinner').hide();
                        // Call the function to render the line chart with the data from the server
                        cutomer_view_line_chart(response.previousData, response.previousYear, response.currentData, response.currentYear, response.maxData);
                    },
                    error: function(xhr, status, error) {
                        console.error("Error fetching data:", error);
                    }
                });
            }

            twoYearsCustomerSelectChart(new Date().getFullYear());
            $("#twoYearsCustomerTrendYearSelect").on("change", function() {
                const selectedYear = $(this).val();
                twoYearsCustomerSelectChart(selectedYear);
                $("#customerCountYear").text(selectedYear + " vs " + (selectedYear - 1));
            })
            // two years customer trending chart end


            $.ajax({
                type: "GET",
                url: "./pages/customer/TypeWiseCustomerPieChart_ajax.php",
                dataType: "json",
                success: function(res) {
                    $('#loading-spinner').hide();
                    // Call the function to render the line chart with the data from the server
                    TypeWiseCustomerPieChart(res.customerType, res.customerCountData);
                },
                error: function(xhr, status, error) {
                    console.error("Error fetching data:", error);
                }
            });

            $.ajax({
                type: "GET",
                url: "./pages/customer/packageWiseCustomerPieChart_ajax.php",
                dataType: "json",
                success: function(res) {
                    $('#loading-spinner').hide();
                    // Call the function to render the line chart with the data from the server
                    packageWiseCustomerPieChart(res.pakageCountData, res.mbbsCountData);
                },
                error: function(xhr, status, error) {
                    console.error("Error fetching data:", error);
                }
            });

            function inactiveCustomerTrendingChartLoad(selectedYear) {
                $.ajax({
                    type: "GET",
                    url: `./pages/customer/inactive_customer_view_column_chart_ajax.php?selectedYear=${selectedYear}`,
                    dataType: "json",
                    success: function(response) {
                        $('#loading-spinner').hide();
                        // Call the function to render the line chart with the data from the server
                        inactiveCustomerTrendingChart(response.previousData, response.previousYear, response.currentData, response.currentYear, response.maxData);
                        // console.log(res.pakageCountData); // To check the response
                        // alert(response); // To check the full response
                    },
                    error: function(xhr, status, error) {
                        console.error("Error fetching data:", error);
                    }
                });
            }
            inactiveCustomerTrendingChartLoad(new Date().getFullYear());
            $("#twoYearsInactiveCustomerTrendYearSelect").on("change", function() {
                const selectedYear = $(this).val();
                inactiveCustomerTrendingChartLoad(selectedYear);
                $("#customerInactiveCountYear").text(selectedYear + " vs " + (selectedYear - 1));
            })

            $.ajax({
                type: "GET",
                url: "./pages/customer/zone_wise_customer_view_pie_chart_ajax.php",
                dataType: "json",
                success: function(response) {
                    $('#loading-spinner').hide();
                    // Call the function to render the line chart with the data from the server
                    zoneWiseCustomerViewPieChart(response.agCountData, response.zoneCountData);
                    // console.log(res.pakageCountData); // To check the response
                    // alert(response); // To check the full response
                },
                error: function(xhr, status, error) {
                    console.error("Error fetching data:", error);
                }
            });
        });
    });



    let twoYearsCustomerSelectChartInstance = null;

    function cutomer_view_line_chart(previousData, previousYear, currentData, currentYear, maxData) {
        // Static month names for both years
        const months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"];

        // Convert the comma-separated strings to arrays of numbers
        const previousDataArray = previousData.split(',').map(Number);
        const currentDataArray = currentData.split(',').map(Number);

        // Calculate the tick amount for y-axis dynamically
        const tickAmount = Math.ceil(maxData / 1000); // Adjust this based on your maxData

        // Chart options
        var options = {
            series: [{
                name: `Previous - ${previousYear}`,
                data: previousDataArray // Use the actual array of numbers
            }, {
                name: `Current - ${currentYear}`,
                data: currentDataArray // Use the actual array of numbers
            }],
            chart: {
                height: 350,
                type: 'area'
            },
            dataLabels: {
                enabled: false
            },
            stroke: {
                curve: 'smooth'
            },
            // xaxis: {
            //     type: 'datetime',
            //     categories: ["2018-09-19T00:00:00.000Z", "2018-09-19T01:30:00.000Z", "2018-09-19T02:30:00.000Z", "2018-09-19T03:30:00.000Z", "2018-09-19T04:30:00.000Z", "2018-09-19T05:30:00.000Z", "2018-09-19T06:30:00.000Z"]
            // },
            xaxis: {
                categories: months, // Use static month names
                title: {
                    text: "Month"
                }
            },
            tooltip: {
                x: {
                    format: 'dd/MM/yy HH:mm'
                },
            },
        };


        if (twoYearsCustomerSelectChartInstance) {
            twoYearsCustomerSelectChartInstance.updateOptions(options);
        } else {
            if (twoYearsCustomerSelectChartInstance) {
                twoYearsCustomerSelectChartInstance.destroy();
            }

            twoYearsCustomerSelectChartInstance = new ApexCharts(document.querySelector("#customer_view_line_chart"), options);
            twoYearsCustomerSelectChartInstance.render();
        }
    }
    //end line chart 


    function TypeWiseCustomerPieChart(customerType, customerCountData) {
        colors = ["#6658dd"];
        (dataColors = $("#customerStatisticsByStatusChart").data("colors")) &&
        (colors = dataColors.split(","));

        var options = {
            series: customerCountData.map(Number),
            chart: {
                width: 450,
                type: 'pie',
            },
            labels: customerType,
            responsive: [{
                breakpoint: 480,
                options: {
                    chart: {
                        width: 200
                    },
                    legend: {
                        position: 'bottom'
                    }
                }
            }]
        };

        var chart = new ApexCharts(document.querySelector("#customerStatisticsByStatusChart"), options);
        chart.render();

    }


    function packageWiseCustomerPieChart(pakageCountData, mbbsCountData) {
        colors = ["#6658dd"];
        // console.log(pakageCountData);
        // const mbbsCountDataArr = Array.from(mbbsCountData);
        // const normalizedData = pakageCountData.map(item => parseFloat(item.mb.trim()) || 0).filter(value => value > 0);
        const mbbsCountDataprocess = mbbsCountData.map(item => item?.mb || "N/A");


        (dataColors = $("#packageWiseCustomerPieChart").data("colors")) &&
        (colors = dataColors.split(","));

        var options = {
            series: pakageCountData.map((item) => Number(item)),
            chart: {
                width: 450,
                type: 'pie',
            },
            labels: mbbsCountDataprocess,
            responsive: [{
                breakpoint: 480,
                options: {
                    chart: {
                        width: 200
                    },
                    legend: {
                        position: 'bottom'
                    }
                }
            }]
        };

        var chart = new ApexCharts(document.querySelector("#packageWiseCustomerPieChart"), options);
        chart.render();

    }

    function zoneWiseCustomerViewPieChart(agCountData, zoneCountData) {
        var options = {
            series: agCountData.map(item => Number(item)),
            chart: {
                width: 450,
                type: 'pie',
            },
            labels: zoneCountData.map((item) => "Zone: " + item),
            responsive: [{
                breakpoint: 480,
                options: {
                    legend: {
                        position: 'bottom'
                    }
                }
            }]
        };

        var chart = new ApexCharts(document.querySelector("#zoneWiseCustomerViewPieChart"), options);
        chart.render();
    }


    inactiveCustomerTrendingChartInstance = null;

    function inactiveCustomerTrendingChart(previousData, previousYear, currentData, currentYear, maxData) {
        // Static month names for both years
        const months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"];

        // Convert the comma-separated strings to arrays of numbers
        const previousDataArray = previousData.split(',').map(Number);
        const currentDataArray = currentData.split(',').map(Number);

        var options = {
            series: [{
                name: `Current - ${currentYear}`,
                data: currentDataArray
            }, {
                name: `Previous - ${previousYear}`,
                data: previousDataArray
            }],
            chart: {
                height: 350,
                type: 'area'
            },
            colors: ['#FF9B17', '#FF0000'],
            dataLabels: {
                enabled: false
            },
            stroke: {
                curve: 'smooth'
            },
            xaxis: {
                type: 'month',
                categories: months
            },
            tooltip: {
                x: {
                    format: 'dd/MM/yy HH:mm'
                },
            },
        };


        if (inactiveCustomerTrendingChartInstance) {
            inactiveCustomerTrendingChartInstance.updateOptions(options);
        } else {
            if (inactiveCustomerTrendingChartInstance) {
                inactiveCustomerTrendingChartInstance.destroy();
            }
            inactiveCustomerTrendingChartInstance = new ApexCharts(document.querySelector("#inactiveCustomerTrendingChart"), options);
            inactiveCustomerTrendingChartInstance.render();
        }
    }
    
    function getSubZoneByZone(zoneId){
        $.ajax({
            type: "GET",
            url: `./pages/customer/get_sub_zone_by_zone_ajax.php`,
            data: {zoneId: zoneId},
            dataType: "json",
            success: function(res){
                console.log(res.subZones);
                var option = '';
                option += '<option value="">All Sub Zones</option>';
                $.each(res.subZones, function(index, subZone){
                    option += `<option value="${subZone.zone_id}">${subZone.zone_name}</option>`;
                });
                $('#sub-zone-filter').empty();
                $('#destination-filter').empty();
                $('#sub-zone-filter').append(option);
                var destoption = '<option value=""> All Destination</option>';
                $('#destination-filter').append(destoption);
            },
            error: function(err){
            console.log("AJAX error:", err);
        }
        });
    }

    function getDestinationBySubZone(subZone){
        console.log(subZone);
        $.ajax({
            type: "GET",
            url: `./pages/customer/get_destination_by_sub_zone_ajax.php`,
            data: {subZone: subZone},
            dataType: "json",
            success: function(res){
                console.log(res.destinations);
                var option = '';
                option += `<option value="">All Destination</option>`;
                $.each(res.destinations, function(index, destination){
                    option += `<option value="${destination.zone_id}">${destination.zone_name}</option>`;
                });
                $('#destination-filter').empty();
                $('#destination-filter').append(option);
            },
            error: function(err){
                console.log("AJAX error:", err);
            }
        });
    }
</script>



<?php $obj->end_script(); ?>