.-.-.-.-.-

<?php
$title = "Profile";
include 'header.php';
//include_once('lib/ps_pagination.php');
//$pin_type =  array('a'=>10000,'b'=>25000,'c'=>50000,'d'=>100000,);
$uid = $_SESSION['userid'];
$result=mysqli_query($connection,"SELECT * FROM user WHERE uid='".$uid."'");
$row=mysqli_fetch_object($result);
$country = mysqli_fetch_object(mysqli_query($connection,"SELECT short_name FROM country WHERE country_id='$row->country'"))->short_name;
$refer = mysqli_fetch_object(mysqli_query($connection,"SELECT login_id, name, mobile, email FROM user WHERE uid='$row->refer_id'"));
$manager = mysqli_fetch_object(mysqli_query($connection,"SELECT login_id, name, mobile, email FROM user WHERE uid='$row->manager_id'"));
?>
<style type="text/css">
    th{
        text-align: left;
    }
    .kyc-box{
        margin: 10px 10px 10px 10px; border: #0090EC solid medium;
    }
</style>
<?php
if ($_SESSION['is_paid'] != 0) {
    $result_pin = mysqli_query($connection, "SELECT t1.used_datetime as used_datetime, t2.package_amount as package_amount, t2.package_name as package_name FROM `dynamicpinnumber` t1 INNER JOIN pin_package t2 ON t1.type = t2.id WHERE t1.uid = '$uid' ORDER BY t1.used_datetime DESC LIMIT 1 ");
    $row_pin = mysqli_fetch_object($result_pin);
    $pin_date = date("d/m/Y h:i A", strtotime($row_pin->used_datetime));
    $pin_package = $row_pin->package_name . " - Rs." . $row_pin->package_amount;
} else {
    $pin_date = "-";
    $pin_package = "Free";
}
?>

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">View Profile</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Member Profile</a></li>
                    <li class="breadcrumb-item active">View Profile</li>
                </ol>

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

<h4 class="mt-0 header-title"><ul>Your TopUp Details</ul></h4>

<table class="table mb-0">
                        <tbody>
                            <tr>
                                <td>Topup Date</td>
                                <td><?php echo $pin_date; ?></td>
                            </tr>
                            <tr>
                                <td>Topup Plan</td>
                                <td><?php echo $pin_package; ?></td>
                            </tr>
                        </tbody>

</table>
                    <?php
//                    if ($_SESSION['is_paid'] != 0) :
//                        $query = "SELECT p.*,  u.name as name, u.login_id as login_id FROM user u INNER JOIN product_package p ON u.uid = p.uid WHERE p.uid='$uid'  ORDER BY p.datetime DESC ";
//                        $result_product_package = mysqli_query($connection, $query);
//                        $row_product_package = mysqli_fetch_object($result_product_package);
                        ?>
                    <?php // endif; ?>

<div>
                        <h4 class="mt-0 header-title"><ul>Sponsor Detail</ul></h4>
                        <table class="table mb-0">

<tbody>
                                <tr>
                                    <td>Sponsor Id</td>
                                    <td><?php echo $refer->login_id; ?></td>
                                </tr>
    
                            </tbody>

</table>
                    </div>
                    <h4 class="mt-0 header-title"><ul>Account Detail</ul></h4>
                    <table class="table mb-0">

<tbody>
                            <tr>
                                <td>User id</td>
                                <td><?php echo $row->login_id; ?></td>
                            </tr>
                            <tr>
                                <td>Register Date</td>
                                <td><?php echo date("d M, Y h:i A", strtotime($row->reg_date)); ?></td></tr>
                        </tbody>

</table>
                    <h4 class="mt-0 header-title"><ul>Personal Detail</ul></h4>
                    <table class="table mb-0">

<tbody>
                            <tr class="light">
                                <td>Name</td>
                                <td><?php echo $row->name; ?></td>
                            </tr>
                            <tr class="dark">
                                <td>Date of Birth</td>
                                <td><?php echo date("d M, Y", strtotime($row->dob)); ?></td>
                            </tr>
                            <tr class="light">
                                <td>Gender</td>
                                <td><?php echo $row->gender; ?></td>
                            </tr>
                            <tr class="dark">
                                <td>Email</td>
                                <td><?php echo $row->email; ?></td>
                            </tr>
                            <tr class="light">
                                <td>Phone</td>
                                <td><?php echo $row->phone; ?></td>
                            </tr>
                            <tr class="dark">
                                <td>Mobile</td>
                                <td><?php echo $row->mobile; ?></td>
                            </tr>
                            <tr class="light">
                                <td>Address</td>
                                <td><?php echo $row->address; ?></td>
                            </tr>
                            <tr class="dark">
                                <td>City</td>
                                <td><?php echo $row->city; ?></td>
                            </tr>
                            <tr class="light">
                                <td>District</td>
                                <td><?php echo $row->district; ?></td>
                            </tr>
                            <tr class="dark">
                                <td>State</td>
                                <td><?php echo $row->state; ?></td>
                            </tr>
                            <tr class="light">
                                <td>Country</td>
                                <td><?php echo $country; ?></td>
                            </tr>
                            <tr class="dark">
                                <td>Pin Code</td>
                                <td><?php echo $row->pincode; ?></td>
                            </tr>
                        </tbody>

</table>
                    
                     <h4 class="mt-0 header-title"><ul>E-currency Details</ul></h4>
                    <table class="table mb-0">

<tbody>
                            <tr>
                                <td>Paytm</td>
                                <td><?php echo $row->paytm; ?></td>
                            </tr>
                            <tr>
                                <td>Google Pay</td>
                                <td><?php echo $row->g_pay; ?></td></tr>
                            <tr>
                                <td>Phone Pay</td>
                                <td><?php echo $row->phone_pay; ?></td></tr>

                        </tbody>

</table>
                    
                    <?php //echo $pager->renderFullNav();  ?>  
                </div>
            </div>
        </div> 
    </div>

<!--    <div class="">
                <h1>Club Type: <u>

</u></h1>
    
        </div>-->

</div>
<!--<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Document Details</h4>

</div>
        </div>
    </div>
    <?php //echo getMessage(); ?>

<div class="row">
                                    <div class="col-lg-6">
                                        <div class="card m-b-30">
                                            <div class="card-body">
                
                                                <h4 class="mt-0 header-title">Block Buttons</h4>
                                                <p class="text-muted m-b-30 ">Create block level buttons�those that
                                                    span the full width of a parent�by adding <code
                                                            class="highlighter-rouge">.btn-block</code>.</p>
                
                                                <div class="button-items">
                                                    <button type="button" class="btn btn-primary btn-lg btn-block waves-effect waves-light">Block level button</button>
                                                    <button type="button" class="btn btn-secondary btn-sm btn-block waves-effect">Block level button</button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<h2>Document Details</h2>
    <?php echo getMessage(); ?>
    <?php
    $kyc_doc = 0;
    $pan_doc = 0;
    $cancel_cheque_doc = 0;
    $is_kyc_doc_edit = TRUE;
    $is_pan_doc_edit = TRUE;
    $is_cancel_cheque_doc_edit = TRUE;
    
//    $kyc_result = mysqli_query($connection,"SELECT id, `uid`, `doc_type`, `file_name`,`file_path`, `create_date`, `status` FROM kyc_doc WHERE uid='$uid' AND is_delete=0");
//    while ($kyc_row = mysqli_fetch_object($kyc_result)) {
//        // kyc doc flags 1=> kyc, 2=>PAN, 3=> Cancel cheque
//        if ($kyc_row->doc_type == 1) {
//            $kyc_doc = $kyc_row->id;
//            $is_kyc_doc_edit = is_kyc_edit($uid, $kyc_row->doc_type);
//            ?>
            <div class="kyc-box">
                <p>
                    KYC doc <img src="../static/backend/user-resource/uploads/kyc_doc///<?php echo $kyc_row->file_name; ?>" width="400" />
                </p>
            </div>
            <?php
//        } elseif ($kyc_row->doc_type == 2) {
//            $pan_doc = $kyc_row->id;
//            $is_pan_doc_edit = is_kyc_edit($uid, $kyc_row->doc_type);
//            ?>
            <div class="kyc-box">
                <p>
                    PAN doc <img src="../static/backend/user-resource/uploads/kyc_doc///<?php echo $kyc_row->file_name; ?>" width="400" />
                </p>
            </div>
            <?php
//        } elseif ($kyc_row->doc_type == 3) {
//            $cancel_cheque_doc = $kyc_row->id;
//            $is_cancel_cheque_doc_edit = is_kyc_edit($uid, $kyc_row->doc_type);
//            ?>
            <div class="kyc-box">
                <p>
                    Cancel Cheque doc <img src="../static/backend/user-resource/uploads/kyc_doc///<?php echo $kyc_row->file_name; ?>" width="400" />
                </p>
            </div>
            <?php
//        }
//    }
    ?>
        <?php
//        $kyc_doc = 0;
//        $pan_doc = 0;
//        $cancel_cheque_doc = 0;
//        $is_kyc_doc_edit = TRUE;
//        $is_pan_doc_edit = TRUE;
//        $is_cancel_cheque_doc_edit = TRUE;

//           
        ?>

<div class="col-lg-8">
            <div class="card m-b-30">
                <div class="card-body">
                    <?php if ($is_kyc_doc_edit) : ?>
                        <form action="./kyc_add_model.php" method="post" enctype="multipart/form-data">
                            <div class="kyc-box">
                                <p>
                                <h3 class="mt-0 header-title">Upload KYC doc</h3>
                                <p style="color:blue;">Image size exceed 500px * 500px the click on this link to compress yr image.
                                    <br>  <b>  <a href="https://www.reduceimages.com/" style="color:blue;">Compress Image</a></b></p>

<label class="text-muted m-b-30 " for="kyc_doc">Upload any address proof (Aadhar card or Driving license or voter Id card or any address proof).</label>
                                <input type="file" name="receipt" id="kyc_doc" required="required"  />
                                </p>
                                <p>
                                    <input type="hidden" name="doc_type" value="1" />
                                    <input type="hidden" name="update_id" value="<?php echo $kyc_doc; ?>" />
                                                            <label for=""></label>
                                                            <div class="button-items">
                                    <button type="submit" name="submit"  class="btn btn-primary waves-effect waves-light" data-toggle="submit">Upload</button>
                                    <input type="submit" name="submit" value="Upload" />
                                                            </div>
                                </p>
                            </div>
                        </form>

<h4 class="mt-0 header-title">Toggle states</h4>
                                                                <p class="text-muted m-b-30 ">Add <code class="highlighter-rouge">data-toggle="button"</code>
                                                                    to toggle a button�s <code class="highlighter-rouge">active</code>
                                                                    state. If you�re pre-toggling a button, you must manually add the <code
                                                                            class="highlighter-rouge">.active</code> class
                                                                    <strong>and</strong> <code
                                                                            class="highlighter-rouge">aria-pressed="true"</code> to the
                                                                    <code class="highlighter-rouge">&lt;button&gt;</code>.
                                                                </p>
                                
                                                                <div class="button-items">
                                                                    <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="button" aria-pressed="false">
                                                                        Single toggle
                                                                    </button>
                                    
                                                                </div>
                    </div>
                </div>
            </div>
        <?php endif; ?>
        <div class="col-lg-8">
            <div class="card m-b-30">
                <div class="card-body">
                    <?php if ($is_pan_doc_edit) : ?>
                        <form action="./kyc_add_model.php" method="post" enctype="multipart/form-data">
                            <div class="kyc-box">
                                <p>
                                <h3 class="mt-0 header-title">Upload PAN doc</h3>
                                <p style="color:blue;">Image size exceed 500px * 500px the click on this link to compress yr image.
                                    <br>  <b>  <a href="https://www.reduceimages.com/" style="color:blue;">Compress Image</a></b></p>

<label class="text-muted m-b-30 " for="pan_doc">Upload PAN doc</label>
                                <input type="file" name="receipt" id="pan_doc" required="required"  />
                                </p>
                                <p>
                                    <input type="hidden" name="doc_type" value="2" />
                                    <input type="hidden" name="update_id" value="<?php echo $pan_doc; ?>" />
                                    <button type="submit" name="submit"  class="btn btn-primary waves-effect waves-light" data-toggle="submit">Upload</button>
                                                     
                                                        </p>
                                                    </div>
                                                </form>
                    
                                    <!--                                        <h4 class="mt-0 header-title">Toggle states</h4>
                                                                            <p class="text-muted m-b-30 ">Add <code class="highlighter-rouge">data-toggle="button"</code>
                                                                                to toggle a button�s <code class="highlighter-rouge">active</code>
                                                                                state. If you�re pre-toggling a button, you must manually add the <code
                                                                                        class="highlighter-rouge">.active</code> class
                                                                                <strong>and</strong> <code
                                                                                        class="highlighter-rouge">aria-pressed="true"</code> to the
                                                                                <code class="highlighter-rouge">&lt;button&gt;</code>.
                                                                            </p>
                                            
                                                                            <div class="button-items">
                                                                                <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="button" aria-pressed="false">
                                                                                    Single toggle
                                                                                </button>
                                                
                                                                            </div>
                            </div>
                        </form>

</div>
                </div>
            <?php endif; ?>
            <div class="card m-b-30">
                <div class="card-body">
                    <?php if ($is_cancel_cheque_doc_edit) : ?>
                        <form action="./kyc_add_model.php" method="post" enctype="multipart/form-data">
                            <div class="kyc-box">
                                <p>
                                <h3 class="mt-0 header-title">Upload Cancel Cheaque</h3>
                                <p style="color:blue;">Image size exceed 500px * 500px the click on this link to compress yr image.
                                    <br>  <b>  <a href="https://www.reduceimages.com/" style="color:blue;">Compress Image</a></b></p>

<label class="text-muted m-b-30 " for="cancel_cheque_doc">Upload Cancel Cheque doc</label>
                                <input type="file" name="receipt" id="cancel_cheque_doc" required="required"  />
                                </p>
                                <p>
                                    <input type="hidden" name="doc_type" value="3" />
                                    <input type="hidden" name="update_id" value="<?php echo $cancel_cheque_doc; ?>" />
                                    <label for=""></label>
                                    <button type="submit" name="submit"  class="btn btn-primary waves-effect waves-light" data-toggle="submit">Upload</button>

</p>
                            </div>
                        </form>
                    <?php endif; ?>
                                                            <h4 class="mt-0 header-title">Toggle states</h4>
                                                            <p class="text-muted m-b-30 ">Add <code class="highlighter-rouge">data-toggle="button"</code>
                                                                to toggle a button�s <code class="highlighter-rouge">active</code>
                                                                state. If you�re pre-toggling a button, you must manually add the <code
                                                                        class="highlighter-rouge">.active</code> class
                                                                <strong>and</strong> <code
                                                                        class="highlighter-rouge">aria-pressed="true"</code> to the
                                                                <code class="highlighter-rouge">&lt;button&gt;</code>.
                                                            </p>
                            
                                                            <div class="button-items">
                                                                <button type="button" class="btn btn-primary waves-effect waves-light" data-toggle="button" aria-pressed="false">
                                                                    Single toggle
                                                                </button>
                                
                                                            </div>
                </div>
            </div>
        </div>
    </div>end row
</div>  container-fluid-->

<?php include 'footer.php'; ?>
<?php
//
//function is_kyc_edit($uid, $doc_type) {
//    $date_today = new DateTime(date("Y-m-d"));
//    $kyc_create_date = mysqli_fetch_object(mysqli_query($GLOBALS['connection'], "SELECT `create_date` FROM kyc_doc WHERE uid='$uid' AND doc_type='$doc_type' ORDER BY create_date ASC LIMIT 1 "))->create_date;
//    $first_kyc_create_date = new DateTime($kyc_create_date);
////    if ($date_today->diff($first_kyc_create_date)->format("%a") > 7) {
////        $is_kyc_doc_edit = TRUE;
////    }
//    return $date_today->diff($first_kyc_create_date)->format("%a") > 7 ? FALSE : TRUE;
//}
?>

/home2/wtmwscom/public_html/css/../member/scripts/./../view_profile.php