.-.-.-.-.-

<?php
$title = "Balance";
include 'header.php';
include_once('lib/ps_pagination.php');
$uid = $_SESSION['userid'];
//if (!isset($_SESSION['e_wallet']) && empty($_SESSION['e_wallet'])) {
//    redirect('./transaction_password.php?url=account.php');
//}
//$wallet_row = mysqli_fetch_object(mysqli_query($connection, "SELECT wallet, wallet_fund FROM `user` WHERE `uid`='".$uid."'"));
$provide_help_amount_array = array(2 => 1000, 3 => 2000, 4 => 3000, 5 => 5000, 6 => 10000, 7 => 20000, 8 => 30000, 9 => 40000, 10 => 50000, 11 => 100000);

$total_closed_amount = mysqli_fetch_object(mysqli_query($connection, "SELECT sum(remaining_amount) as total_amount FROM `transaction` WHERE `uid`='" . $uid . "' AND status='1' AND remaining_amount > '0' AND txn_mode='0' "))->total_amount;
$total_unclosed_amount = mysqli_fetch_object(mysqli_query($connection, "SELECT sum(remaining_amount) as total_amount FROM `transaction` WHERE `uid`='" . $uid . "' AND status='0' AND remaining_amount > '0' AND txn_mode='0' "))->total_amount;
$query = "SELECT uid, amount, txn_type, txn_mode, datetime, status FROM `transaction` WHERE `uid`='" . $uid . "' AND status IN (0, 1) ";
$query .= isset($_GET['from_date']) && $_GET['from_date'] != '' && isset($_GET['to_date']) && $_GET['to_date'] != '' ? " AND (DATE(datetime) BETWEEN '" . $_GET['from_date'] . "' AND '" . $_GET['to_date'] . "')" : '';

$query .= "ORDER BY `datetime` ASC";
$plan_type = mysqli_fetch_object(mysqli_query($connection, "SELECT plan_type FROM user where uid = '$uid'"))->plan_type;
?>
<style>
    .text{
        font-size: 20px;
        font-weight: bold;
        text-align: center;
    }
</style>

<div><a href="report_transaction.php">All Ledger Report</a></div>
<?php echo getMessage(); ?>


<!--<div class="container">
       <div class="row">
        <div class="col-lg-12">
            <div class="card m-b-20">
                <div class="card-body">
                    <h3>E-wallet</h3>

<section>
    <table style="width: 50%;" align="center" class="datatable">
        <thead>
            <tr>
                <th>Fund wallet</th> 
                <th>Payout wallet</th>
                <th>Total wallet</th>
            </tr>
        </thead>
        <tbody>
            <tr class="dark">
                <td class="text"><?php echo empty($total_unclosed_amount) ? "0.00" : $total_unclosed_amount; ?></td>
                <td class="text"><?php echo empty($total_closed_amount) ? "0.00" : $total_closed_amount; ?></td>
                <td class="text"><?php echo $total_closed_amount + $total_unclosed_amount; ?></td>
            </tr>
        </tbody>
    </table>
</section>
                </div></div></div></div>
</div>-->

<div class="container-fluid">
    <?php echo getMessage(); ?>
    <div class="row" >
        <div class="col-sm-12" >
            <div class="page-title-box">
                <h4 class="page-title">My Wallet</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">My Wallet</a></li>
                    
                </ol>
            </div>
        </div>
    </div>  
    
    <div class="row" style="width:1500px; margin:0 auto;" >
        <div class="col-lg-8">
            <div class="card m-b-20">
                <div class="card-body">
                    <h3 class="mt-0 header-title"><center>My Wallet</center></h3>
                    <table class="table mb-0">
                        <tbody>
                            <tr>
                                <td style="text-align: center"><?php echo empty($total_closed_amount) ? "0.00" : $total_closed_amount; ?></td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div> 
    </div> 
</div> 
<h1>Ledger</h1>
<?php echo getMessage(); ?>

<div class="container-fluid">
    <div class="row">
        <div class="col-lg-12">
            <div class="card m-b-20">
                <div class="card-body">
                    <table style="width: 100%;" class="table mb-0 datatable">
                        <thead>
                            <tr>
                                <th>S. No.</th>
                                <th>Date</th>
                                <th>Amount</th>
                                <th>Type</th>
                                <th>Particular</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <?php
                        $result = mysqli_query($connection, $query);
                        if (mysqli_num_rows($result) > 0) {
                            ?>
                            <tbody>
                                <?php
                                $total = 0;
                                $i = 1;
                                while ($row = mysqli_fetch_object($result)) {
                                    $total = $total + $row->amount;
                                    ?>
                                    <tr <?php
                                    if ($i % 2) {
                                        echo "class='light'";
                                    } else {
                                        echo "class='dark'";
                                    }
                                    ?>>
                                        <td><?php echo $i; ?></td>
                                        <td><?php echo date("d/m/Y h:i A", strtotime($row->datetime)); ?></td>
                                        <td><?php echo $row->amount; ?></td>
                                        <td><?php echo $row->txn_mode == 0 ? "CREDIT" : "DEBIT"; ?></td>
                                        <td><?php echo $master_income_type_array[$row->txn_type]; ?></td>
                                        <td><?php
                                            if ($row->txn_type == 9 || $row->txn_type == 10)
                                                echo "Successfull";
                                            else if ($row->status == 1)
                                                echo "Closed";
                                            else
                                                echo "Not Closed";
                                            ?></td>
                                    </tr>
                                    <?php
                                    $i++;
                                }
                                ?>
                            </tbody>
                    
                        <?php } ?>
                    </table>
                </div></div></div></div>
</div>

<section >
    <h1>Get Help Request</h1>

<h4>Total Payout wallet <?php echo empty($total_closed_amount) ? 0.00 : $total_closed_amount ?> </h4>
    <form name="form" id="form" action="payout_model.php" method="post">
        <p>

<label for="amount" >Amount</label>
            <select  name="amount" id="amount">
                <option value="">Select</option>
                <option value="1000">1000</option>
                <option value="2000">2000</option>
                <option value="3000">3000</option>
                <option value="4000">4000</option>
                <option value="5000">5000</option>
                <option value="6000">6000</option>
                <option value="7000">7000</option>
                <option value="8000">8000</option>
                <option value="9000">9000</option>
                <option value="10000">10000</option>
                <option value="11000">11000</option>
                <option value="12000">12000</option>
                <option value="13000">13000</option>
                <option value="14000">14000</option>
                <option value="15000">15000</option>
                <option value="16000">16000</option>
                <option value="17000">17000</option>
                <option value="18000">18000</option>
                <option value="19000">19000</option>
                <option value="20000">20000</option>
          
            </select>
        </p>
        <p><br />
            <input style="position: relative; left: 200px;" name="submit" type="submit" id="submit" value="Submit">
        </p>
    </form>
</section>

<?php include 'footer.php'; ?>

/home2/wtmwscom/./public_html/member/account.php