<!DOCTYPE html>
<html lang="en">

<!-- Mirrored from yashadmin.dexignzone.com/tailwind/demo/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 09 Sep 2024 07:42:52 GMT -->

<head>
  
    <?php include "includes2/header-links.php" ?>

</head>
<style>
    /* The Modal (background) */
    .custom-modal {
        display: none;
        position: fixed;
        z-index: 1;
        left: 0;
        top: 0;
        width: 100%;
        height: 100%;
        overflow: auto;
        background-color: rgb(0, 0, 0);
        background-color: rgba(0, 0, 0, 0.4);
        padding-top: 60px;
    }

    /* Modal Content */
    .custom-modal-content {
        background-color: #fefefe;
        margin: 5% auto;
        padding: 20px;
        border: 1px solid #888;
        width: 80%;
        max-width: 680px;
        border-radius: 10px;
    }

    /* Close Button */
    .custom-modal-close {
        color: #aaa;
        float: right;
        font-size: 28px;
        font-weight: bold;
    }

    .custom-modal-close:hover,
    .custom-modal-close:focus {
        color: black;
        text-decoration: none;
        cursor: pointer;
    }
    .address-wrap {
    word-break: break-word; 
    overflow-wrap: break-word;
   
}
</style>

<body class="selection:text-white selection:bg-primary">
    <!-- Main wrapper start -->
    <div id="main-wrapper" class="relative">
        <?php include "includes2/header.php" ?>
        <?php include "includes2/sidebar.php" ?>
        <!-- Content body start -->
        <div class="content-body">
            <div class="container-fluid">
                <div class="row dz-tab-area">
                    <div class="flex justify-between items-center mb-5">
                        <a href="<?= base_url('admin_Dashboard/add_branch/' . encryptId($user['0']['id'])) ?>"
                            class="py-[5px] px-3 text-[13px] rounded text-white bg-primary leading-[18px] inline-block border border-primary duration-500 hover:bg-hover-primary hover:border-hover-primary ml-auto">+
                            Add User</a><br>
                        <!-- New Export to Excel Button -->
                        <a href="#" onclick="exportTableToExcel()"
                            class="py-[5px] px-3 text-[13px] rounded text-white bg-primary leading-[18px] inline-block border border-primary duration-500 hover:bg-hover-primary hover:border-hover-primary ml-2">
                            Export to Excel
                        </a>
                        <a href="#" onclick="exportTableAsPDF()"
                            class="py-[5px] px-3 text-[13px] rounded text-white bg-primary leading-[18px] inline-block border border-primary duration-500 hover:bg-hover-primary hover:border-hover-primary ml-2">
                            PDF
                        </a>
                    </div>

                    <div class="flex items-center">
                        <h3 style="font-size: 25px; margin: 10px;color: #454592;">View Return Product list</h3>
                        <ul class="nav nav-pills mix-chart-tab user-m-tabe flex flex-wrap">
                            <li class="nav-item">
                                <button class="nav-link py-[3px] px-2 mx-1 rounded text-[13px] block tab-btn active"
                                    data-tab="pills-colm">
                                    <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"
                                        width="24px" height="24px" viewBox="0 0 24  24" version="1.1"
                                        class="svg-main-icon">
                                        <g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd">
                                            <rect x="0" y="0" width="24" height="24" />
                                            <path
                                                d="M10.5,5 L19.5,5 C20.3284271,5 21,5.67157288 21,6.5 C21,7.32842712 20.3284271,8 19.5,8 L10.5,8 C9.67157288,8 9,7.32842712 9,6.5 C9,5.67157288 9.67157288,5 10.5,5 Z M10.5,10 L19.5,10 C20.3284271,10 21,10.6715729 21,11.5 C21,12.3284271 20.3284271,13 19.5,13 L10.5,13 C9.67157288,13 9,12.3284271 9,11.5 C9,10.6715729 9.67157288,10 10.5,10 Z M10.5,15 L19.5,15 C20.3284271,15 21,15.6715729 21,16.5 C21,17.3284271 20.3284271,18 19.5,18 L10.5,18 C9.67157288,18 9,17.3284271 9,16.5 C9,15.6715729 9.67157288,15 10.5,15 Z"
                                                fill="var(--dark)" />
                                            <path
                                                d="M5.5,8 C4.67157288,8 4,7.32842712 4,6.5 C4,5.67157288 4.67157288,5 5.5,5 C6.32842712,5 7,5.67157288 7,6.5 C7,7.32842712 6.32842712,8 5.5,8 Z M5.5,13 C4.67157288,13 4,12.3284271 4,11.5 C4,10.6715729 4.67157288,10 5.5,10 C6.32842712,10 7,10.6715729 7,11.5 C7,12.3284271 6.32842712,13 5.5,13 Z M5.5,18 C4.67157288,18 4,17.3284271 4,16.5 C4,15.6715729 4.67157288,15 5.5,15 C6.32842712,15 7,15.6715729 7,16.5 C7,17.3284271 6.32842712,18 5.5,18 Z"
                                                fill="var(--dark)" opacity="0.3" />
                                        </g>
                                    </svg>
                                </button>
                            </li>
                        </ul>
                    </div>
                </div>


                <div class="w-full active-p">
                    <div class="tab-content-area">
                        <div class="tab-content show active" id="pills-colm">
                            <div class="card">
                                <div class="sm:py-5 py-4">
                                    <div class="overflow-x-auto active-projects user-tbl ItemsCheckboxSec dt-filter">
                                        <table id="user-tbl" class="table">
                                            <thead>
                                                <tr>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        S No.</th>

                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        return<br>date</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        vender_name</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Return <br>Code</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Total<br> Return <br> Product</th>

                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Total <br>Quantity</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Sub Total</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Discount</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Total </th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        paid</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Due</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Status</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Add BY</th>
                                                    <th
                                                        class="border-b border-b-color text-[13px] py-2.5 px-4 bg-primary-light text-primary capitalize font-medium bg-none whitespace-nowrap text-left">
                                                        Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>

                                                <?php if (!empty($return)): ?>
                                                    <?php $serial = 1;
                                                    foreach ($return as $return_info): ?>
                                                        <?php
                                                        // Fetch the vendor name based on the vender_id
                                                        $vender_name = '';
                                                        foreach ($vender as $vender_info) {
                                                            if ($vender_info['id'] == $return_info['vender_name']) {
                                                                $vender_name = $vender_info['vender_name'];
                                                                break;
                                                            }
                                                        }
                                                        $product_counts = [];
                                                        // Fetch the product name based on the product_id
                                                        $product_name = '';
                                                        foreach ($return as $return_inf) {
                                                            $key = $return_inf['vender_name'] . '_' . $return_inf['return_code'];
                                                            if (!isset($product_counts[$key])) {
                                                                $product_counts[$key] = 0;
                                                            }
                                                            $product_counts[$key]++;
                                                        }
                                                        $total_products = $product_counts[$key];
                                                        ?>
                                                        <tr>
                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                <?= $serial++ ?></td>

                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                <?= date('d-m-Y', strtotime($return_info['datte'])) ?></td>
                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color address-wrap">
                                                                <?= $return_info['vender_name'] ?></td>
                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                <?= $user[0]['returne_code'] ?>-<?= $return_info['return_code'] ?>
                                                            </td>
                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                <?= $return_info['product_count']; ?></td>

                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                <?= $return_info['total_quantity'] ?></td>
                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                ₹ <?= $return_info['sub_total'] ?></td>
                                                                <td class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
    <?php
    if ($return_info['discount_type'] == 'rupee') {
        echo '₹ ' . $return_info['discount_value'];
    } else {
        echo $return_info['discount_value'] . '%';
    }
    ?>
</td>
                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                ₹ <?= $return_info['grand_total'] ?></td>
                                                            <?php
                                                            $payment = $this->CommonModal->getRowByIdOrderByLimit('return_purchase_payment', 'return_code', $return_info['return_code'], 'user_id', $user['0']['id'], 'id', 'DESC', '1');
                                                            $paymentsum = $this->CommonModal->getRowByIdSum('return_purchase_payment', 'return_code', $return_info['return_code'], 'user_id', $user['0']['id'], 'paid');
                                                            ?>
                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                ₹ <?= $paymentsum[0]['total_sum'] ?></td>
                                                            <td
                                                                class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                ₹ <?= number_format((float)$payment[0]['due'], 2) ?></td>
                                                            <?php if ($paymentsum[0]['total_sum'] < $payment[0]['total']  && $paymentsum[0]['total_sum'] !=0) { ?>
                                                                <td
                                                                    class="py-[0.9375rem] px-2.5 capitalize whitespace-nowrap sm:text-sm text-xs font-normal border-t border-[#E6E6E6] dark:border-[#ffffff1a] text-left text-body-color">
                                                                    <span
                                                                        class="text-xs py-[5px] px-3 rounded leading-[1.5] inline-block text-warning bg-warning-light">partial</span>
                                                                </td>
                                                            <?php } elseif ($paymentsum[0]['total_sum'] = $payment[0]['total']  && $paymentsum[0]['total_sum'] !=0) { ?>
                                                                <td
                                                                    class="py-[0.9375rem] px-2.5 capitalize whitespace-nowrap sm:text-sm text-xs font-normal border-t border-[#E6E6E6] dark:border-[#ffffff1a] text-left text-body-color">
                                                                    <span
                                                                        class="text-xs py-[5px] px-3 rounded leading-[1.5] inline-block text-success bg-success-light dark:text-white dark:bg-[#3a9b941a]">Complete</span>
                                                                </td>
                                                            <?php } elseif ($paymentsum[0]['total_sum'] > $payment[0]['total']  && $paymentsum[0]['total_sum'] !=0) { ?>
                                                                <td
                                                                    class="py-[0.9375rem] px-2.5 capitalize whitespace-nowrap sm:text-sm text-xs font-normal border-t border-[#E6E6E6] dark:border-[#ffffff1a] text-left text-body-color">
                                                                    <span
                                                                        class="text-xs py-[5px] px-3 rounded leading-[1.5] inline-block text-primary bg-primary-light light border border-primary-light-3 dark:border-transparent">Advance</span>
                                                                </td>
                                                            <?php } else { ?>
                                                                <td
                                                                    class="py-[0.9375rem] px-2.5 capitalize whitespace-nowrap sm:text-sm text-xs font-normal border-t border-[#E6E6E6] dark:border-[#ffffff1a] text-left text-body-color">
                                                                    <span
                                                                        class="text-xs py-[5px] px-3 rounded leading-[1.5] inline-block text-danger bg-danger-light">pending</span>
                                                                </td>
                                                            <?php }
                                                            if ($return_info['branch_id'] != 0) {
                                                                $branch = $this->CommonModal->getRowByMultitpleId('branch', 'id', $return_info['branch_id'], 'user_id', $user[0]['id']); ?>
                                                                <td
                                                                    class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                    <?= $branch[0]['name'] ?></td>
                                                            <?php } else {
                                                                ?>
                                                                <td
                                                                    class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                    Admin</td>
                                                            <?php }
                                                            ?>

                                                            <td
                                                                class="py-[0.9375rem] px-2.5 capitalize whitespace-nowrap sm:text-sm text-xs font-normal border-t border-[#E6E6E6] dark:border-[#ffffff1a] text-left text-body-color">

                                                                <div class="dropdown">
                                                                    <button type="button"
                                                                        class="btn min-w-[2.4rem] p-[0.4375rem] h-[2.4rem] leading-[1.7] min-h-[2.5rem] btn-primary rounded-md dz-dropdown bg-primary-light hover:bg-primary duration-300 light sharp"
                                                                        data-dz-dropdown="dropdown-<?= $return_info['return_code'] ?>">
                                                                        <svg width="20px" height="20px" viewBox="0 0 24 24"
                                                                            version="1.1">
                                                                            <g stroke="none" stroke-width="1" fill="none"
                                                                                fill-rule="evenodd">
                                                                                <rect x="0" y="0" width="24" height="24" />
                                                                                <circle fill="#000000" cx="5" cy="12" r="2" />
                                                                                <circle fill="#000000" cx="12" cy="12" r="2" />
                                                                                <circle fill="#000000" cx="19" cy="12" r="2" />
                                                                            </g>
                                                                        </svg>
                                                                    </button>
                                                                    <div class="dz-dropdown-menu dropdown-menu-end border py-2 rounded-md min-w-[10rem] z-[9] translate-x-[-96px] translate-y-1 shadow-[0_0_3.125rem_0_rgba(82,63,105,0.15)] overflow-hidden border-b-color absolute bg-white dark:bg-[#182237] dark:shadow-[0rem_0rem_0rem_0.0625rem_rgba(255,255,255,0.1)] hidden"
                                                                        id="dropdown-<?= $return_info['return_code'] ?>">
                                                                        <a class="dropdown-item py-2 px-5 text-body-color text-[13px] text-left block w-full whitespace-nowrap hover:bg-[#f8f9fa] hover:text-primary dark:hover:bg-[#151C2C]"
                                                                            href="<?= base_url('Admin_Dashboard/print_return_purchase/' . encryptId($user[0]['id']) . '/' . $return_info['return_code']); ?>">
                                                                            View Return
                                                                        </a>
                                                                        
                                                                        <?php if ($return_info['branch_id'] != 0) { ?>
                                                                            <a class="dropdown-item py-2 px-5 text-body-color text-[13px] text-left block w-full whitespace-nowrap hover:bg-[#f8f9fa] hover:text-primary dark:hover:bg-[#151C2C]"
                                                                                href="<?= base_url('admin_Dashboard/edit_return?user_id=' . $user['0']['id'] . '&branch_id=' . $return_info['branch_id'] . '&return_code=' . $return_info['return_code']) ?>">Edit</a>
                                                                        <?php } else { ?>
                                                                            <a class="dropdown-item py-2 px-5 text-body-color text-[13px] text-left block w-full whitespace-nowrap hover:bg-[#f8f9fa] hover:text-primary dark:hover:bg-[#151C2C]"
                                                                                href="<?= base_url('admin_Dashboard/edit_return?user_id=' . $user['0']['id'] . '&branch_id=0&return_code=' . $return_info['return_code']) ?>">Edit</a>
                                                                        <?php } ?>
                                                                        <a class="dropdown-item py-2 px-5 text-body-color text-[13px] text-left block w-full whitespace-nowrap hover:bg-[#f8f9fa] hover:text-primary dark:hover:bg-[#151C2C]"
                                                                            href="javascript:void(0);"
                                                                            onclick="openModal('<?= $return_info['return_code'] ?>')">View
                                                                            Payment</a>
                                                                        <a class="dropdown-item py-2 px-5 text-body-color text-[13px] text-left block w-full whitespace-nowrap hover:bg-[#f8f9fa] hover:text-primary dark:hover:bg-[#151C2C]"
                                                                            href="javascript:void(0);"
                                                                            onclick="dueModal('<?= $return_info['return_code'] ?>')">Pay
                                                                            Due Payment</a>
                                                                        <a class="dropdown-item py-2 px-5 text-body-color text-[13px] text-left block w-full whitespace-nowrap hover:bg-[#f8f9fa] hover:text-primary dark:hover:bg-[#151C2C]"
                                                                            href="<?= base_url('Admin_Dashboard/return/' . encryptId($user[0]['id']) . '?return_code=' . $return_info['return_code']); ?>"
                                                                            onclick="return confirm('Are you sure you want to delete this Account Detail?')">Delete</a>


                                                                    </div>
                                                                </div>
                                                            </td>
                                                        </tr>
                                                    <?php endforeach; ?>
                                                <?php else: ?>
                                                    <!-- <tr><td colspan="9">No data found</td></tr> -->
                                                <?php endif; ?>
                                            </tbody>

                                        </table>
                                        <?php if (!empty($return)): ?>
                                            <?php foreach ($return as $return_info): ?>
                                                <?php
                                                // Fetch the vendor name based on the vender_id
                                                $vender_name = '';
                                                foreach ($vender as $vender_info) {
                                                    if ($vender_info['id'] == $return_info['vender_name']) {
                                                        $vender_name = $vender_info['vender_name'];
                                                        break;
                                                    }
                                                }

                                                // Fetch the product name based on the product_id
                                                $product_name = '';
                                                foreach ($product_list as $product_list_info) {
                                                    if ($product_list_info['id'] == $return_info['product_name']) {
                                                        $product_name = $product_list_info['product_name'];
                                                        break;
                                                    }
                                                }
                                                ?>
                                                <div id="paymentModal<?= $return_info['return_code'] ?>" class="custom-modal">
                                                    <div class="custom-modal-content">
                                                        <span class="custom-modal-close"
                                                            onclick="closeModal('<?= $return_info['return_code'] ?>')">&times;</span>
                                                        <h2 id="paymentModalLabel">Payment Details</h2>
                                                        <div class="modal-body">
                                                            <div class="row mb-12">

                                                                <div class="mt-6 lg:w-1/2 md:w-1/2 w-full detail">
                                                                    <!-- <h6 class="mb-2">Customer Detail:</h6> -->
                                                                    <?php
                                                                    $vender = $this->CommonModal->getRowByMultitpleId('vender', 'id', $return_info['vender_name'], 'user_id', $user['0']['id']);
                                                                    ?>
                                                                    <div class="text-body-color sm:text-sm text-xs">
                                                                        <strong>Vender Name:</strong>
                                                                        <?= $vender[0]['vender_name'] ?></div>

                                                                    <div class="text-body-color sm:text-sm text-xs">
                                                                        <strong>Invoice No.:</strong>
                                                                        <?= $user[0]['returne_code'] ?>-<?= $return_info['return_code'] ?>
                                                                    </div>
                                                                    <div class="text-body-color sm:text-sm text-xs">
                                                                        <strong>Date:</strong> <?= $return_info['date'] ?></div>

                                                                </div>
                                                                <div class="mt-6 lg:w-1/2 md:w-1/2 w-full detail">
                                                                    <!-- <h6 class="mb-2">Customer Detail:</h6> -->
                                                                    <?php
                                                                    $payment = $this->CommonModal->getRowByIdOrderByLimit('return_purchase_payment', 'return_code', $return_info['return_code'], 'user_id', $user['0']['id'], 'id', 'DESC', '1');
                                                                    $paymentsum = $this->CommonModal->getRowByIdSum('return_purchase_payment', 'return_code', $return_info['return_code'], 'user_id', $user['0']['id'], 'paid');
                                                                    ?>
                                                                    <div class="text-body-color sm:text-sm text-xs">
                                                                        <strong>Total Amount:</strong> ₹
                                                                        <?= $payment[0]['total'] ?>/-</div>

                                                                    <div class="text-body-color sm:text-sm text-xs"><strong>Paid
                                                                            Amount:</strong> ₹
                                                                        <?= $paymentsum[0]['total_sum'] ?>/-</div>
                                                                    <div class="text-body-color sm:text-sm text-xs"><strong>Due
                                                                            Amount:</strong> ₹ <?= $payment[0]['due'] ?>/-</div>

                                                                </div>


                                                                <table>
                                                                    <thead>
                                                                        <tr>
                                                                            <th
                                                                                class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap  sm:text-base text-sm font-medium text-left center text-dark">
                                                                                #</th>
                                                                            <th
                                                                                class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap  sm:text-base text-sm font-medium text-left text-dark">
                                                                                Payment Date</th>
                                                                            <th
                                                                                class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap  sm:text-base text-sm font-medium text-left text-dark">
                                                                                Paid Amount</th>
                                                                            <th
                                                                                class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap  sm:text-base text-sm font-medium text-left right text-dark">
                                                                                Payment Mode</th>
                                                                            <th
                                                                                class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap  sm:text-base text-sm font-medium text-left center text-dark">
                                                                                Bank/Cheque</th>
                                                                                <th class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap  sm:text-base text-sm font-medium text-right text-dark">Received by</th>
                                                                        </tr>
                                                                    </thead>
                                                                    <tbody>
                                                                        <?php
                                                                        $paymentall = $this->CommonModal->getRowByMultitpleId('return_purchase_payment', 'return_code', $return_info['return_code'], 'user_id', $user['0']['id']);
                                                                        $i = 0;
                                                                        if (!empty($paymentall)) {  // Missing closing parenthesis fixed here
                                                                            foreach ($paymentall as $row) {
                                                                                $i++;
                                                                                ?>
                                                                                <tr>

                                                                                    <td
                                                                                        class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap sm:text-sm text-xs text-body-color center">
                                                                                        <?= $i ?></td>

                                                                                    <td
                                                                                        class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap sm:text-sm text-xs text-body-color left strong">
                                                                                        <?= $row['date'] ?></td>
                                                                                    <td
                                                                                        class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap sm:text-sm text-xs text-body-color left">
                                                                                        ₹<?= $row['paid'] ?>/-</td>
                                                                                    <td
                                                                                        class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap sm:text-sm text-xs text-body-color right">
                                                                                        <?= $row['mode'] ?> </td>
                                                                                    <?php if ($row['bank']) {
                                                                                        $bank = $this->CommonModal->getRowByMultitpleId('account', 'id', $row['bank'], 'user_id', $user['0']['id']); ?>
                                                                                        <td
                                                                                            class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap sm:text-sm text-xs text-body-color center">
                                                                                            <?= $bank[0]['bank_name'] ?></td>
                                                                                             <?php } elseif($row['cheque_no']) {
                                                                                            ?>
                                                                                             <td
                                                                                                class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap sm:text-sm text-xs text-body-color center">
                                                                                                <?= $row['cheque_no'] ?></td>
                                                                                    <?php } else {
                                                                                        ?>
                                                                                        <td
                                                                                            class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap sm:text-sm text-xs text-body-color center">
                                                                                            <?= $row['mode'] ?></td>
                                                                                            <?php } if($row['branch_id']) {
                                                                                        $branch = $this->CommonModal->getRowByMultitpleId('branch', 'id', $row['branch_id'], 'user_id', $user[0]['id']); ?>
                                                                    <td
                                                                        class="border-b border-b-color py-2.5 px-4 text-[13px] font-normal text-body-color whitespace-nowrap">
                                                                        <?= $branch[0]['name'] ?></td>

                                                                                        <?php } else {?>
                                                <td class="py-[0.9375rem] px-2.5 border-b border-[#E6E6E6] dark:border-[#ffffff1a] whitespace-nowrap sm:text-sm text-xs text-body-color text-right">By Own</td>

                                                <?php } ?>
                                                                                </tr>
                                                                            <?php }
                                                                        } ?>

                                                                    </tbody>
                                                                </table>

                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div id="payModal<?= $return_info['return_code'] ?>" class="custom-modal">
                                                    <div class="custom-modal-content">
                                                        <span class="custom-modal-close"
                                                            onclick="closeM('<?= $return_info['return_code'] ?>')">&times;</span>
                                                        <h2 id="payModalLabel">Pay Due Payment</h2>
                                                        <div class="modal-body">
                                                            <div class="row mb-12">

                                                                <div class="mt-6 lg:w-1/2 md:w-1/2 w-full detail">
                                                                    <!-- <h6 class="mb-2">Customer Detail:</h6> -->
                                                                    <?php
                                                                    $vender = $this->CommonModal->getRowByMultitpleId('vender', 'id', $return_info['vender_name'], 'user_id', $user['0']['id']);
                                                                    ?>
                                                                    <div class="text-body-color sm:text-sm text-xs">
                                                                        <strong>Vender Name:</strong>
                                                                        <?= $vender[0]['vender_name'] ?></div>

                                                                    <div class="text-body-color sm:text-sm text-xs">
                                                                        <strong>Invoice No.:</strong>
                                                                        <?= $user[0]['returne_code'] ?>-<?= $return_info['return_code'] ?>
                                                                    </div>
                                                                    <div class="text-body-color sm:text-sm text-xs">
                                                                        <strong>Date:</strong> <?= $return_info['date'] ?></div>

                                                                </div>
                                                                <div class="mt-6 lg:w-1/2 md:w-1/2 w-full detail">
                                                                    <!-- <h6 class="mb-2">Customer Detail:</h6> -->
                                                                    <?php
                                                                    $payment = $this->CommonModal->getRowByIdOrderByLimit('return_purchase_payment', 'return_code', $return_info['return_code'], 'user_id', $user['0']['id'], 'id', 'DESC', '1');
                                                                    $paymentsum = $this->CommonModal->getRowByIdSum('return_purchase_payment', 'return_code', $return_info['return_code'], 'user_id', $user['0']['id'], 'paid');
                                                                    ?>
                                                                    <div class="text-body-color sm:text-sm text-xs">
                                                                        <strong>Total Amount:</strong> ₹
                                                                        <?= $payment[0]['total'] ?>/-</div>

                                                                    <div class="text-body-color sm:text-sm text-xs"><strong>Paid
                                                                            Amount:</strong> ₹
                                                                        <?= $paymentsum[0]['total_sum'] ?>/-</div>
                                                                    <div class="text-body-color sm:text-sm text-xs"><strong>Due
                                                                            Amount:</strong> ₹ <?= $payment[0]['due'] ?>/-</div>

                                                                </div>
                                                                <form class="profile-form"
                                                                    action="<?= base_url('admin_Dashboard/add_return_purchase_payment/' . encryptId($user['0']['id'])) ?>"
                                                                    method="post" enctype="multipart/form-data">
                                                                    <div class="sm:p-10 sm:pb-2.5 p-[25px] pb-0">

                                                                        <div class="row">
                                                                            <div class="sm:w-1/2 w-full mb-[30px]">
                                                                                <label
                                                                                    class="text-dark dark:text-white text-[13px] mb-2">Date</label>
                                                                                <input type="date"
                                                                                    id="paymentDate<?= $return_info['return_code'] ?>"
                                                                                    name="date"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full">
                                                                            </div>
                                                                            <div class="sm:w-1/2 w-full mb-[30px]">
                                                                                <label
                                                                                    class="text-dark dark:text-white text-[13px] mb-2">Paid
                                                                                    Amount</label>
                                                                                <input type="number" name="paid"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500  outline-none w-full"
                                                                                    placeholder="paid amount"
                                                                                    value="<?= $payment[0]['due'] ?>"  max="<?= $payment[0]['due'] ?>" 
    id="paidAmount<?= $return_info['return_code'] ?>" 
    oninput="validatePaidAmount('<?= $return_info['return_code'] ?>')">
                                                                                <input type="hidden" name="due"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500  outline-none w-full"
                                                                                    placeholder="paid amount"
                                                                                    value="<?= $payment[0]['due'] ?>">
                                                                                <input type="hidden" name="purchase_code"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500  outline-none w-full"
                                                                                    placeholder="paid amount"
                                                                                    value="<?= $return_info['purchase_code'] ?>">
                                                                                <input type="hidden" name="return_code"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500  outline-none w-full"
                                                                                    placeholder="paid amount"
                                                                                    value="<?= $return_info['return_code'] ?>">
                                                                                <input type="hidden" name="user_id"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500  outline-none w-full"
                                                                                    placeholder="paid amount"
                                                                                    value="<?= $user['0']['id'] ?>">
                                                                                <input type="hidden" name="total"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500  outline-none w-full"
                                                                                    placeholder="paid amount"
                                                                                    value=" <?= $payment[0]['total'] ?>">
                                                                                <input type="hidden" name="vender_id"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500  outline-none w-full"
                                                                                    placeholder="paid amount"
                                                                                    value="<?= $return_info['vender_name'] ?>">
                                                                            </div>
                                                                            <div class="sm:w-1/2 w-full mb-[30px]">
                                                                                <label
                                                                                    class="text-dark dark:text-white text-[13px] mb-2">Payment
                                                                                    Mode</label>
                                                                                <select name="mode"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full "
                                                                                    id="paymentMode<?= $return_info['return_code'] ?>"
                                                                                    required>
                                                                                    <option value="">--SELECT--</option>
                                                                                    <option value="Cash">CASH</option>
                                                                                    <option value="Upi">UPI</option>
                                                                                    <option value="Card">CREADIT/DEBIT CARD</option>
                                                                                     
                                                                                    <option value="Bank">Bank Transfer</option>
 <option value="Cheque">Cheque</option>

                                                                                </select>
                                                                            </div>
                                                                            <div class="sm:w-1/2 w-full mb-[30px]"
                                                                                id="bankDetails<?= $return_info['return_code'] ?>"
                                                                                style="display:none;">
                                                                                <label
                                                                                    class="text-dark dark:text-white text-[13px] mb-2">Account</label>
                                                                                <select name="bank"
                                                                                    class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full "
                                                                                    id="bankAccount<?= $return_info['return_code'] ?>" >
                                                                                    <option value="">--SELECT--</option>
                                                                                    <?php

                                                                                    $account = $this->CommonModal->getRowById('account', 'user_id', $user['0']['id']);
                                                                                    foreach ($account as $account_info) { ?>
                                                                                        <option value="<?= $account_info['id'] ?>">
                                                                                            <?= $account_info['bank_name'] ?>-<?= $account_info['account_no'] ?>
                                                                                        </option>
                                                                                    <?php } ?>


                                                                                </select>
                                                                            </div>
                                                                             <div class="sm:w-1/2 w-full mb-[30px]"
                                                                                    id="chequeDetails<?= $return_info['return_code'] ?>"
                                                                                    style="display:none;">
                                                                                    <label
                                                                                        class="text-dark dark:text-white text-[13px] mb-2">Cheque Number</label>
                                                            <input type="text" name="cheque_no"
                                                                                        class="form-control relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500 outline-none w-full relative text-[13px] text-body-color h-[2.813rem] border border-b-color block rounded-md py-1.5 px-3 duration-500  outline-none w-full"
                                                                                        placeholder="Cheque Number"
                                                                                       id="cheque<?= $return_info['return_code'] ?>" >
                                                                                </div>
                                                                        </div>
                                                                    </div>
                                                                    <div
                                                                        class="sm:py-5 sm:px-10 p-[25px] flex items-center justify-between border-t border-b-color">
                                                                        <button type="submit" id="add-product-btn"
                                                                            class="btn btn-primary sm:py-[0.719rem] py-2.5 sm:px-[1.563rem] px-4 sm:text-[15px] text-[13px] font-medium rounded text-white bg-primary leading-5 inline-block border border-primary duration-500 hover:bg-hover-primary hover:border-hover-primary">Pay</button>
                                                                    </div>
                                                            </div>
                                                            </form>
                                                            <script>
                                                                document.getElementById('paymentMode<?= $return_info['return_code'] ?>').addEventListener('change', function () {
                                                                    var bankDetails = document.getElementById('bankDetails<?= $return_info['return_code'] ?>');
                                                                      var selectDetails = document.getElementById('bankAccount<?= $return_info['return_code'] ?>');
                                                                    if (this.value === 'Bank') {
                                                                        bankDetails.style.display = 'block';
                                                                        selectDetails.setAttribute('required', 'required')
                                                                    } else {
                                                                        bankDetails.style.display = 'none';
                                                                         selectDetails.removeAttribute('required'); 
                                                                    }
                                                                });
                                                                document.addEventListener("DOMContentLoaded", function () {
                                                                    var today = new Date();
                                                                    var year = today.getFullYear();
                                                                    var month = (today.getMonth() + 1).toString().padStart(2, '0');
                                                                    var day = today.getDate().toString().padStart(2, '0');
                                                                    var currentDate = `${year}-${month}-${day}`;
                                                                    document.getElementById('paymentDate<?= $return_info['return_code'] ?>').value = currentDate;
                                                                });
                                                                   document.getElementById('paymentMode<?= $return_info['return_code'] ?>').addEventListener('change', function () {
                                                                        var chequeDetails = document.getElementById('chequeDetails<?= $return_info['return_code'] ?>');
                                                                          var selectDetails = document.getElementById('cheque<?= $return_info['return_code'] ?>');
                                                                        if (this.value === 'Cheque') {
                                                                            chequeDetails.style.display = 'block';
                                                                              selectDetails.setAttribute('required', 'required')
                                                                        } else {
                                                                            chequeDetails.style.display = 'none';
                                                                             selectDetails.removeAttribute('required'); 
                                                                        }
                                                                    });
                                                            </script>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        <?php endforeach; ?>
                                    <?php else: ?>
                                        <!-- <tr><td colspan="11">No data found</td></tr> -->
                                    <?php endif; ?>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    </div>
    <?php include "includes2/footer-links.php" ?>
    </div>
    <?php include "includes2/footer.php" ?>
</body>
<script>
    // Function to open modal and load content
    function openModal(invoice_no) {
        var modal = document.getElementById(`paymentModal${invoice_no}`);
        var modalLabel = document.getElementById("paymentModalLabel");
        var modalBody = document.querySelector(".modal-body");

        // Display the modal
        modal.style.display = "block";


    }

    // Function to close modal
    function closeModal(invoice_no) {
        var modal = document.getElementById(`paymentModal${invoice_no}`);
        modal.style.display = "none";
    }

    // Close the modal if the user clicks outside of it
    window.onclick = function (event) {
        var modal = document.getElementById("paymentModal");
        if (event.target == modal) {
            modal.style.display = "none";
        }
    }
    function dueModal(invoice_no) {
        var modal = document.getElementById(`payModal${invoice_no}`);
        var modalLabel = document.getElementById("payModalLabel");
        var modalBody = document.querySelector(".modal-body");

        // Display the modal
        modal.style.display = "block";


    }

    // Function to close modal
    function closeM(invoice_no) {
        var modal = document.getElementById(`payModal${invoice_no}`);
        modal.style.display = "none";
    }

    // Close the modal if the user clicks outside of it
    window.onclick = function (event) {
        var modal = document.getElementById(`payModal${invoice_no}`);
        if (event.target == modal) {
            modal.style.display = "none";
        }
    }

</script>
<script>
    function exportTableToExcel() {
        // Select the table element
        var table = document.querySelector("#user-tbl"); // Replace with your table's ID

        // Initialize an empty array to hold table data
        var data = [];

        // Loop through each row of the table
        for (var i = 0, row; row = table.rows[i]; i++) {
            var rowData = [];
            // Loop through each cell in the row
            for (var j = 0, cell; cell = row.cells[j]; j++) {
                rowData.push(cell.innerText);
            }
            data.push(rowData);
        }

        // Convert array to worksheet
        var worksheet = XLSX.utils.aoa_to_sheet(data);

        // Create a new workbook and append the worksheet
        var workbook = XLSX.utils.book_new();
        XLSX.utils.book_append_sheet(workbook, worksheet, "Return Product List");

        // Generate Excel file and download
        XLSX.writeFile(workbook, "Return_Product.xlsx");
    }

    function exportTableAsPDF() {
        // Check if jsPDF is available
        const { jsPDF } = window.jspdf;
        if (!jsPDF) {
            console.error("jsPDF not loaded");
            return;
        }

        const pdf = new jsPDF('p', 'mm', 'a4');
        const table = document.getElementById('user-tbl');

        // Capture the table as an image
        html2canvas(table, { scale: 2 }).then((canvas) => {
            const imgData = canvas.toDataURL('image/png');
            const pdfWidth = pdf.internal.pageSize.getWidth();
            const pdfHeight = (canvas.height * pdfWidth) / canvas.width;

            // Add the image to PDF and adjust size
            pdf.addImage(imgData, 'PNG', 0, 10, pdfWidth, pdfHeight);

            // Download the PDF
            pdf.save('Return_Product.pdf');
        }).catch((error) => {
            console.error("Error generating PDF:", error);
        });
    }

</script>
        <script>
    function validatePaidAmount(purchaseCode) {
        const paidInput = document.getElementById('paidAmount' + purchaseCode);
        const maxValue = parseFloat(paidInput.max);

        // Parse the input value and check against the max value
        const currentValue = parseFloat(paidInput.value);

        if (currentValue > maxValue) {
            alert('Amount cannot exceed the due amount!');
            paidInput.value = maxValue; // Reset to the maximum allowed value
        } else if (currentValue < 0 || isNaN(currentValue)) {
            paidInput.value = ""; // Reset for invalid or negative inputs
        }
    }
</script>
</html>