.-.-.-.-.-

<?php
$title = "Bank Receipt";
include 'header.php';
$uid = $_SESSION['userid'];
?>
<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Upload Bank receipt details</h4>
                         <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                        <li class="breadcrumb-item"><a href="">Support</a></li>
                        <li class="breadcrumb-item active">Bank Receipt</<li>
                    </ol>

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

<div class="row">
        <div class="col-12">
            <div class="card m-b-20">
                <div class="card-body">
                    <form name="form" id="form" enctype="multipart/form-data" action="bank_receipt_modal.php" method="post">

<div class="form-group row">
                            
                            <label for="amount" class="col-sm-2 col-form-label">Payment Amount</label>

                            <div class="col-sm-10">
                                <input class="form-control" type="number" name="amount" id="amount" required="required" step="any">

</div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="payment_type">Payment For <span>*</span></label>
                            <div class="col-sm-10">
                                <select class="custom-select" name="payment_type" id="payment_type" required="required">
                                    <option value="1">New Joining payment</option>
                                    <option value="2">Upgrade Id</option>
                                </select>
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="payment_mode">Payment Mode <span>*</span></label>

<div class="col-sm-10">
                                <select class="custom-select" name="payment_mode" id="payment_mode" required="required">
                                    <option value="NEFT">NEFT</option>
                                    <option value="CASH DEPOSIT">CASH DEPOSIT</option>
                                    <option value="CHEQUE">CHEQUE</option>
                                    <option value="RTGS">RTGS</option>
                                    <option value="IMPS">IMPS</option>
                                    <option value="DRAFT">DRAFT</option>
                                </select>
                            </div>

</div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="bank_name">Bank Name <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="text" name="bank_name" id="bank_name" maxlength="20"> </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="bank_branch">Bank Branch <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="text" name="bank_branch" id="bank_branch" maxlength="20"></div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="ifsc">Ifsc <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="text" name="ifsc" id="ifsc" maxlength="20"> </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="mobile">Mobile No<span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="text" name="mobile" id="mobile" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="payment_datetime">Payment Date <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="date" name="payment_datetime" id="payment_datetime"> </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="transaction_number">Transaction Number <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="text" name="transaction_number" id="tranaction_number" required="required"> </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="receipt">Bank receipt <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="file" name="receipt" id="receipt" required="required"></div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" id="packageList">Package <span>*</span></label>
                            <div class="col-sm-10">
                                <input style="position: relative; left: 160px;" name="" type="button" id="" value="Add more package" onclick="$('#packageList').append($('#packageListItem').html());"></div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="remark">Remark <span>*</span></label>
                            <div class="col-sm-10">
                                <textarea required class="form-control" rows="5"name="remark" id="remark" ></textarea>
                            </div>
                            <div class="form-group">
                                <div>
    
                                    <button name="submit" type="submit" id="submit" value="Save" class="btn btn-primary waves-effect waves-light">
                                        Submit
                                    </button>
                                    
                                </div>
                            </div>
                            
                            
                            
                    </form>
                </div>

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

</div>

<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Bank Receipt</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="javascript:void(0);">Member</a></li>
                    <li class="breadcrumb-item"><a href="javascript:void(0);">Bank Receipt</a></li>
                    <li class="breadcrumb-item active">Basic Tables</li>
                </ol>

<table class="table mb-0">
                    <thead>
                        <tr>
                            <th>S.No</th>
                            <th>Amount</th>
                            <th>Payment for</th>
                            <th>Remark</th>
                            <th>Date</th>
                            <th>Receipt</th>
                            <th>Payment Mode</th>
                            <th>Bank Name</th>
                            <th>Bank Branch</th>
                            <th>IFSC</th>
                            <th>Mobile No</th>
                            <th>Payment Date</th>
                            <th>Transaction #</th>
                            <th>Pin Package</th>
                            <th>Status</th>
                        </tr>
                    </thead>
                    <tbody>
                         <?php
                $i = 1;
                $rs = mysqli_query($connection, "SELECT * FROM bank_receipt WHERE uid='$uid'");
                while ($row = mysqli_fetch_object($rs)) {
                    ?>
                    <tr <?php
                    if ($i % 2) {
                        echo "class='light'";
                    } else {
                        echo "class='dark'";
                    }
                    ?>>
                        <td><?php echo $i; ?></td>
                        <td><?php echo $row->amount; ?></td>
                        <td><?php echo $row->payment_type == 1 ? "New Joining payment" : "Upgrade Id"; ?></td>
                        <td><?php echo nl2br($row->remark); ?></td>
                        <td><?php echo date("d/m/y h:i", strtotime($row->datetime)); ?></td>
                        <td><a href="../member/uploads/bank_receipt/<?php echo $row->file_name; ?>" target="_blank"><img src="../member/uploads/bank_receipt/<?php echo $row->file_name; ?>" width="100px" /></a></td>
                        <td><?php echo $row->payment_mode; ?></td>
                        <td><?php echo $row->bank_name; ?></td>
                        <td><?php echo $row->bank_branch; ?></td>
                        <td><?php echo $row->ifsc; ?></td>
                        <td><?php echo $row->mobile; ?></td>
                        <td><?php echo date('d/m/Y', strtotime($row->payment_datetime)); ?></td>
                        <td><?php echo $row->transaction_number; ?></td>
                        <td><?php
                            $result_package = mysqli_query($connection, "SELECT b.*, p.package_name AS package_name FROM bank_receipt_package b LEFT JOIN pin_package p ON b.pin_package_id = p.id WHERE b.bank_receipt_id='$row->id'");
                            while ($row_package = mysqli_fetch_object($result_package)) {
                                echo "$row_package->quantity - $row_package->package_name <br/>";
                            }
                            ?></td>
                        <td><?php
                            switch ($row->status) {
                                case 1: $status = "Approved";
                                    break;
                                case 2: $status = "Rejected";
                                    break;
                                default:$status = "Waiting";
                                    break;
                            } echo $status;
                            ?></td>
                    </tr>
                    <?php
                    $i++;
                }
                ?>
            </tbody>
        </table>
                <?php //echo $pager->renderFullNav(); ?>  
            </div>
        </div>
    </div> 
</div>

<div id="packageListItem" style="display: none">
    <div>
        <label for="">Package<span>*</span></label>
        <select name="pin_package[]" id="" required="required">
            <?php
            $result_pin_package = mysqli_query($connection, "SELECT id, package_name, package_amount, pin_length FROM pin_package");
            while ($pin_type = mysqli_fetch_object($result_pin_package)) {
                ?>
                <option value="<?php echo $pin_type->id; ?>" ><?php echo $pin_type->package_name; ?></option>
                <?php
            }
            ?>
        </select>
        <input type="number" name="quantity[]" id="" required="required" placeholder="Enter Quantity"  step="any" />
        <a href="javascript:;" onclick="$(this).closest('div').remove();">Remove</a>
    </div>
</div>
<script>
    $(document).ready(function () {
        $('#packageList').append($('#packageListItem').html());
    });
</script>
<?php include 'footer.php'; ?>

/home2/wtmwscom/public_html/livezila/../member/bank_receipt.php