1#@!#!123s

32767 1#@!#!123s
: / proc / self / root / home / rakcha / public_html / admin /
Filename : kyc_documents.php
back
<?php error_reporting(0); ?>

<?php 

session_start();

 if (!isset($_SESSION['admin_name'])) {

    header("location: index.php");

 }

 else {

  include("includes/database.php");

  $page_user = $_SESSION['admin_name'];

  ?>

<!DOCTYPE html>

<html lang="en">



<head>

    <meta charset="utf-8" />

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta content="width=device-width, initial-scale=1" name="viewport" />

    <meta name="description" content="RAKCHA | Dashboard" />

    <meta name="author" content="RAKCHA | Dashboard" />

    <title>RAKCHA | Dashboard</title>

    <!-- google font -->

    <link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet" type="text/css" />

	<!-- icons -->

    <link href="assets/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" />

    <link href="assets/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>

	<link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">

    <!-- bootstrap -->

	<link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />

    <!-- data tables -->

    <link href="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css"/>

	<!-- Material Design Lite CSS -->

	<link rel="stylesheet" href="assets/plugins/material/material.min.css">

	<link rel="stylesheet" href="assets/css/material_style.css">

	<!-- animation -->

	<link href="assets/css/pages/animate_page.css" rel="stylesheet">

	<!-- Theme Styles -->

    <!-- gallery -->

    <link href="assets/plugins/light-gallery/css/lightgallery.css" rel="stylesheet">

    

    <link href="assets/css/style.css" rel="stylesheet" type="text/css" />

    <link href="assets/css/plugins.min.css" rel="stylesheet" type="text/css" />

    <link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />

	<link href="assets/css/theme-color.css" rel="stylesheet" type="text/css" />

	<!-- favicon -->

    <link rel="shortcut icon" href="assets/img/favicon.ico" />

 </head>

<!-- END HEAD -->

<body class="page-header-fixed sidemenu-closed-hidelogo page-content-white page-md header-white dark-sidebar-color logo-dark">

    <div class="page-wrapper">

        <!-- start header -->

        <div class="page-header navbar navbar-fixed-top">

            <div class="page-header-inner ">

                <!-- logo start -->

                <div class="page-logo">

                    <a href="main_home.php">

                        <img src="../images/resources/logo.png">

                    </a>

                </div>

                <!-- logo end -->

                <ul class="nav navbar-nav navbar-left in">

                    <li><a href="#" class="menu-toggler sidebar-toggler"><i class="icon-menu"></i></a></li>

                </ul>

                

                <!-- start mobile menu -->

                <a href="javascript:;" class="menu-toggler responsive-toggler" data-toggle="collapse" data-target=".navbar-collapse">

                    <span></span>

                </a>

               <!-- end mobile menu -->

                <!-- start header menu -->

                <div class="top-menu">

                    <ul class="nav navbar-nav pull-right">

                        

                        <!-- start manage user dropdown -->

                        <li class="dropdown dropdown-user">

                            <a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-close-others="true">

                                <i class="fa fa-user-o"></i>

                                <span class="username username-hide-on-mobile"> Admin </span>

                                <i class="fa fa-angle-down"></i>

                            </a>

                            <ul class="dropdown-menu dropdown-menu-default animated jello">

                                

                                <li>

                                    <a href="logout.php">

                                        <i class="icon-logout"></i> Log Out </a>

                                </li>

                            </ul>

                        </li>

                       

                    </ul>

                </div>

            </div>

        </div>

        <!-- end header -->

        

        <!-- start page container -->

        <div class="page-container">

 			<!-- start sidebar menu -->

 			<div class="sidebar-container">

                <div class="sidemenu-container navbar-collapse collapse fixed-menu">

                    <div id="remove-scroll">

                        <ul class="sidemenu  page-header-fixed" data-keep-expanded="false" data-auto-scroll="true" data-slide-speed="200" style="padding-top: 20px">

                            <li class="sidebar-toggler-wrapper hide">

                                <div class="sidebar-toggler">

                                    <span></span>

                                </div>

                            </li>

                            

                            <li class="nav-item start">

	                            <a href="main_home.php" class="nav-link nav-toggle">

	                                <i class="material-icons">dashboard</i>

	                                <span class="title">Dashboard</span>

                                	

	                            </a>

	                            

	                        </li>

                            <li class="nav-item">

                                <a href="stock_mangement.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Stock Management</span> 

                                </a>

                            </li>

                            



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Members</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                     

                                    <li class="nav-item">

                                        <a href="member_roi.php" class="nav-link "> <span class="title">Member List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="member_company.php" class="nav-link "> <span class="title">Company Member List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="member_adv.php" class="nav-link "> <span class="title">Advance Registeration</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                             

                           

                             

                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Payout</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                    <li class="nav-item">

                                        <a href="weekly_roi.php" class="nav-link "> <span class="title">Payout</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="weekly_roi_history.php" class="nav-link "> <span class="title">Payout History</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="weekly_roi_search.php" class="nav-link "> <span class="title">Report</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Kit Bank</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                     

                                    <li class="nav-item">

                                        <a href="eproduct_request_roi.php" class="nav-link "> <span class="title">KIT Request</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                             

                            



                            



                             

                            



                            



                             



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Product Management</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                    <li class="nav-item">

                                        <a href="new_kit.php" class="nav-link "> <span class="title">New Kit I</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_kit_1.php" class="nav-link "> <span class="title">New Kit II</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_address.php" class="nav-link "> <span class="title">Get Address</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_address_1.php" class="nav-link "> <span class="title">Get Address I</span>

                                        </a>

                                    </li>

                                    

                                    <li class="nav-item">

                                        <a href="billing.php" class="nav-link "> <span class="title">New Billing</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_binary.php" class="nav-link "> <span class="title">Product Details</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi.php" class="nav-link "> <span class="title">New Orders</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi_approve.php" class="nav-link "> <span class="title">Approved Orders</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi_order.php" class="nav-link "> <span class="title">Orders History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_1_history.php" class="nav-link "> <span class="title">New Kit I History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_2_history.php" class="nav-link "> <span class="title">New Kit II History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_pay.php" class="nav-link "> <span class="title">Download Invoice</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                            <li class="nav-item">

                                <a href="daily.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Daily Updates</span> 

                                </a>

                            </li>

                            <li class="nav-item">

                                <a href="gallery.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Gallery</span> 

                                </a>

                            </li>



                             

                            <li class="nav-item">

                                <a href="reward_list.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Reward Eligible list</span> 

                                </a>

                            </li>

                             

                             

                             

                            <li class="nav-item active">

                                <a href="kyc_documents.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">KYC Documents</span> 

                                </a>

                            </li>

                            <li class="nav-item">

                                <a href="../control/" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">OLD DATA</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">NETWORK TREE</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">



                                    

                                    

                                    <li class="nav-item">

                                        <a href="network.php" class="nav-link "> <span class="title">Seniority List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="network_search.php" class="nav-link "> <span class="title">Level List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="../user/network_report.php" class="nav-link "> <span class="title">Get Report</span>

                                        </a>

                                    </li>



                                    

                                    

                                    

                                    

                                </ul>

                            </li>

                             

                            <li class="nav-item">

                                <a href="coupon_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Coupon Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="personal_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Personal Pv Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="special_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Special Pv Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="sms_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">SMS DETAILS</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="comitee_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">COMMITTEE DETAILS</span> 

                                </a>

                            </li>

                             

                            

                            <li class="nav-item">

                                <a href="nottice_letter.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Notice Letter</span> 

                                </a>

                            </li>

                            

                            <li class="nav-item">

                                <a href="change_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Change Password</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="change_trans_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Change Trans Password</span> 

                                </a>

                            </li>

                           

                        </ul>

                    </div>

                </div>

            </div>

			 <!-- end sidebar menu -->

			<!-- start page content -->

            <div class="page-content-wrapper">

                <div class="page-content">

                    <div class="page-bar">

                        <div class="page-title-breadcrumb">

                            <div class=" pull-left">

                                <div class="page-title">KYC Documents</div>

                            </div>

                            <ol class="breadcrumb page-breadcrumb pull-right">

                                <li><i class="fa fa-home"></i>&nbsp;<a class="parent-item" href="main_home.php">Home</a>&nbsp;<i class="fa fa-angle-right"></i>

                                </li>

                                

                                <li class="active">KYC Documents</li>

                            </ol>

                        </div>

                    </div>

                   

                    

                    

                    <div class="row">

                        <div class="col-md-12">

                            <div class="card card-topline-red">

                                <div class="card-head">

                                    <header>KYC Documents</header>

                                   

                                </div>

                                <div class="card-body " id="aniimated-thumbnials">

                                    

                                    <table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%" id="example4">

                                        <thead>

                                            <tr>

                                                  <th>S.No</th>

                                                  <th>Name</th>

                                                  <th>RC ID</th>

                                                  <th>Aadhaar Card</th>

                                                  <th>Pan Card</th>

                                                  <th>Bank Proof</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php 

                                   

                                                  $select_query = "select * from member where aadhaar_status='2' OR pan_card_status='2' OR bank_proof_status='2'";

                                                  $run = mysqli_query($con,$select_query);

                                                   $serial = 1;

                                                   while ($row = mysqli_fetch_array($run)) {

                                                    $s_num = $serial++;

                                                    $member_id = $row['member_id'];

                                                    $title = $row['title'];

                                                    $dob = $row['dob'];

                                                    $name = $row['name'];

                                                    $gender = $row['gender'];

                                                    $address_1 = $row['address_1'];

                                                    $address_2 = $row['address_2'];

                                                    $town_area = $row['town_area'];

                                                    $city_district = $row['city_district'];

                                                    $state = $row['state'];

                                                    $country = $row['country'];

                                                    $pincode = $row['pincode'];

                                                    $mobile_number = $row['mobile_number'];

                                                    $email = $row['email'];

                                                    $aadhaar_card = $row['aadhaar_card'];

                                                    $pan_card = $row['pan_card'];

                                                    $nominee_name = $row['nominee_name'];

                                                    $nominee_relationship = $row['nominee_relationship'];

                                                    $account_name = $row['account_name'];

                                                    $account_number = $row['account_number'];

                                                    $ifsc_code = $row['ifsc_code'];

                                                    $bank_name = $row['bank_name'];

                                                    $branch_name = $row['branch_name'];



                                                    $member_no = $row['member_no'];

                                                    $password = $row['password'];

                                                    $aadhaar_card_image = $row['aadhaar_card_image'];

                                                    $pan_card_image = $row['pan_card_image'];

                                                    $bank_proof_image = $row['bank_proof_image'];

                                                    $document_status = $row['document_status'];

                                                    $aadhaar_status = $row['aadhaar_status'];

                                                    $pan_card_status = $row['pan_card_status'];

                                                    $bank_proof_status = $row['bank_proof_status'];               

                                             ?>

                                            <tr class="odd gradeX">

                                                

                                              <td><?= $s_num; ?></td>

                                              <td><?= $name; ?></td>

                                              <td><?= $member_no; ?></td>

                                              <td>

                                                <a href="../aadhaar/<?= $aadhaar_card_image; ?>" data-sub-html="Name - <?= $name; ?> / Aadhaar no - <?= $aadhaar_card; ?>" id="<?= $member_id; ?>"><img width="100" src="../aadhaar/<?= $aadhaar_card_image; ?>" class="img-fluid img-thumbnail"></a><br>



                                                <?php 

                                                 

                                                  if ($aadhaar_status == 2) {

                                                    ?>



                                                    <div style="margin-top: 10px;">

                                                      <form method="post" action="kyc_documents.php" enctype="multipart/form-data" >

                                                         <input type="hidden" name="aadhaar_status" value="3">

                                                         <input type="hidden" name="member_no" value="<?= $member_no; ?>">

                                                         <input type="submit" name="ok_aathar" class="btn btn-primary btn-mini" value="OK" style="float: left;">

                                                         



                                                      </form>

                                                      <form method="post" action="kyc_documents.php" enctype="multipart/form-data" >

                                                         <input type="hidden" name="aadhaar_status" value="1">

                                                         <input type="hidden" name="member_no" value="<?= $member_no; ?>">

                                                         <input type="hidden" name="old_image" value="<?= $aadhaar_card_image; ?>">

                                                         <input type="submit" name="cancel_aathar" class="btn btn-danger btn-mini" value="Reject">

                                                         



                                                      </form>

                                                     

                                                      

                                                    </div>

                                                    <?php

                                                  }



                                                 ?>



                                                



                                            </td>



                                              <td>

                                                <a href="../pan/<?= $pan_card_image; ?>" data-sub-html="Name - <?= $name; ?> / PAN no - <?= $pan_card; ?>" id="<?= $member_id; ?>"><img width="100" src="../pan/<?= $pan_card_image; ?>" class="img-fluid img-thumbnail"></a><br>

                                                 <?php 

                                                 

                                                  if ($pan_card_status == 2) {

                                                    ?>

                                                <div style="margin-top: 10px;">

                                                      <form method="post" action="kyc_documents.php" enctype="multipart/form-data" >

                                                         <input type="hidden" name="pan_card_status" value="3">

                                                         <input type="hidden" name="member_no" value="<?= $member_no; ?>">

                                                         <input type="submit" name="ok_pan" class="btn btn-primary btn-mini" value="OK" style="float: left;">

                                                         



                                                      </form>

                                                      <form method="post" action="kyc_documents.php" enctype="multipart/form-data" >

                                                         <input type="hidden" name="pan_card_status" value="1">

                                                         <input type="hidden" name="member_no" value="<?= $member_no; ?>">

                                                         <input type="hidden" name="old_image" value="<?= $pan_card_image; ?>">

                                                         <input type="submit" name="cancel_pan" class="btn btn-danger btn-mini" value="Reject">

                                                         



                                                      </form>

                                                     

                                                      

                                                    </div>

                                                <?php } ?>

                                            </td>



                                            <td>

                                                <a href="../bank/<?= $bank_proof_image; ?>" data-sub-html="Name - <?= $name; ?> / Acc no - <?= $account_number; ?> / IFSC code - <?= $ifsc_code; ?> / Bank Name - <?= $bank_name; ?> / Branch Name - <?= $branch_name; ?>" id="<?= $member_id; ?>"><img width="100" src="../bank/<?= $bank_proof_image; ?>" class="img-fluid img-thumbnail"></a><br>

                                                <?php 

                                                 

                                                  if ($bank_proof_status == 2) {

                                                    ?>

                                                <div style="margin-top: 10px;">

                                                      <form method="post" action="kyc_documents.php" enctype="multipart/form-data" >

                                                         <input type="hidden" name="bank_proof_status" value="3">

                                                         <input type="hidden" name="member_no" value="<?= $member_no; ?>">

                                                         <input type="submit" name="ok_bank" class="btn btn-primary btn-mini" value="OK" style="float: left;">

                                                         



                                                      </form>

                                                      <form method="post" action="kyc_documents.php" enctype="multipart/form-data" >

                                                         <input type="hidden" name="bank_proof_status" value="1">

                                                         <input type="hidden" name="member_no" value="<?= $member_no; ?>">

                                                         <input type="hidden" name="old_image" value="<?= $bank_proof_image; ?>">

                                                         <input type="submit" name="cancel_bank" class="btn btn-danger btn-mini" value="Reject">

                                                         



                                                      </form>

                                                     

                                                      

                                                    </div>

                                                <?php } ?>

                                            </td>



                                                

                                            </tr>

                                            <?php } ?>

                                        </tbody>

                                    </table>

                                </div>

                            </div>

                        </div>

                    </div>

                    

                </div>

            </div>

            <!-- end page content -->

            

        </div>

        <!-- end page container -->

        <!-- start footer -->

        <div class="page-footer">

            <div class="page-footer-inner"> 2018 &copy;. All Rights Reserved.

            </div>

            <div class="scroll-to-top">

                <i class="icon-arrow-up"></i>

            </div>

        </div>

        <!-- end footer -->

    </div>

    <!-- start js include path -->

    <script src="assets/plugins/jquery/jquery.min.js" ></script>

    <script src="assets/plugins/popper/popper.min.js" ></script>

    <script src="assets/plugins/jquery-blockui/jquery.blockui.min.js" ></script>

	<script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.min.js"></script>

    <!-- bootstrap -->

    <script src="assets/plugins/bootstrap/js/bootstrap.min.js" ></script>

    <!-- data tables -->

    <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>

 	<script src="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.js" ></script>

    <script src="assets/js/pages/table/table_data.js" ></script>

    <!-- Common js-->

	<script src="assets/js/app.js" ></script>

    <script src="assets/js/layout.js" ></script>

	<script src="assets/js/theme-color.js" ></script>

	<!-- Material -->

	<script src="assets/plugins/material/material.min.js"></script>

	<!-- animation -->

	<script src="assets/js/pages/ui/animations.js" ></script>

    <!-- gallery -->

    <script src="assets/plugins/light-gallery/js/lightgallery-all.js"></script> <!-- Light Gallery Plugin Js --> 

    <script src="assets/plugins/light-gallery/js/image-gallery.js"></script>

    <!-- end js include path -->

</body>



</html>

<?php 

    // verifyinh process for aathar 

    if (isset($_POST['ok_aathar'])) {   

    $aadhaar_status = $_POST['aadhaar_status'];

    $member_no = $_POST['member_no'];



    $select_query = "select * from member where member_no='$member_no'";

    $run = mysqli_query($con,$select_query);    

     while ($row = mysqli_fetch_array($run)) {



      $pan_card_status = $row['pan_card_status'];

      $bank_proof_status = $row['bank_proof_status']; 

     }



     if ($pan_card_status = '3' && $bank_proof_status == '3') {

       $document_status = '3';

     }

     else {

       $document_status = '1';

     }



    if($aadhaar_status==''){        

        echo "<script>alert('some one feilds is empty please fill')</script>";

        exit();

        }

        else {  

             $insert_query = "update member set document_status='$document_status', aadhaar_status='$aadhaar_status' where member_no = '$member_no'";

            if (mysqli_query($con,$insert_query)) {                    

                     



                echo "<script>alert('Kyc Document has been successfully Verified...')</script>";

                echo "<script>window.open('kyc_documents.php','_self')</script>";

            }

            

            

        

        }  

  }

  if (isset($_POST['cancel_aathar'])) {

   

    $document_status = '1';

    $aadhaar_status = $_POST['aadhaar_status'];

    $member_no = $_POST['member_no'];

    $date =  date('Y/m/d');

    $message = "Your Aadhar image not clear or mismatch, please Reupload clear image...";

    $old_image=$_POST['old_image'];

      



    if($document_status==''){

        

        echo "<script>alert('some one feilds is empty please fill')</script>";

        exit();

        }



        else {     

             

             

             $insert_query = "update member set document_status='$document_status', aadhaar_status='$aadhaar_status' where member_no = '$member_no'";

            if (mysqli_query($con,$insert_query)) {                    

                     

                mysqli_query($con, "insert into doc_notify(member_no, message, date, doc_status) values('$member_no', '$message', '$date', '1')");

                unlink($_SERVER['DOCUMENT_ROOT'] . "/aadhaar/$old_image");

                echo "<script>alert('Kyc Document has been Rejected...')</script>";

                echo "<script>window.open('kyc_documents.php','_self')</script>";

            }

            

            

        

        }  

  }



  // verifyinh process for aathar 



  // verifyinh process for pan 

    if (isset($_POST['ok_pan'])) {   

    $pan_card_status = $_POST['pan_card_status'];

    $member_no = $_POST['member_no'];



    $select_query = "select * from member where member_no='$member_no'";

    $run = mysqli_query($con,$select_query);    

     while ($row = mysqli_fetch_array($run)) {



      $aadhaar_status = $row['aadhaar_status'];

      

      $bank_proof_status = $row['bank_proof_status']; 

     }



     if ($aadhaar_status = '3' && $bank_proof_status == '3') {

       $document_status = '3';

     }

     else {

       $document_status = '1';

     }



    if($pan_card_status==''){        

        echo "<script>alert('some one feilds is empty please fill')</script>";

        exit();

        }

        else {  

             $insert_query = "update member set document_status='$document_status', pan_card_status='$pan_card_status' where member_no = '$member_no'";

            if (mysqli_query($con,$insert_query)) {                    

                     



                echo "<script>alert('Kyc Document has been successfully Verified...')</script>";

                echo "<script>window.open('kyc_documents.php','_self')</script>";

            }

            

            

        

        }  

  }

  if (isset($_POST['cancel_pan'])) {

   

    $document_status = '1';

    $pan_card_status = $_POST['pan_card_status'];

    $member_no = $_POST['member_no'];

    $date =  date('Y/m/d');

    $message = "Your Pan image not clear or mismatch, please Reupload clear image...";

    $old_image=$_POST['old_image'];

      



    if($document_status==''){

        

        echo "<script>alert('some one feilds is empty please fill')</script>";

        exit();

        }



        else {     

             

             

             $insert_query = "update member set document_status='$document_status', pan_card_status='$pan_card_status' where member_no = '$member_no'";

            if (mysqli_query($con,$insert_query)) {                    

                     

                 mysqli_query($con, "insert into doc_notify(member_no, message, date, doc_status) values('$member_no', '$message', '$date', '2')");

                 unlink($_SERVER['DOCUMENT_ROOT'] . "/pan/$old_image");

                echo "<script>alert('Kyc Document has been Rejected...')</script>";

                echo "<script>window.open('kyc_documents.php','_self')</script>";

            }

            

            

        

        }  

  }



  // verifyinh process for pan 





  // verifyinh process for pan 

    if (isset($_POST['ok_bank'])) {   

    $bank_proof_status = $_POST['bank_proof_status'];

    $member_no = $_POST['member_no'];



    $select_query = "select * from member where member_no='$member_no'";

    $run = mysqli_query($con,$select_query);    

     while ($row = mysqli_fetch_array($run)) {



      $aadhaar_status = $row['aadhaar_status'];

      $pan_card_status = $row['pan_card_status'];

       

     }



     if ($aadhaar_status = '3' && $pan_card_status == '3') {

       $document_status = '3';

     }

     else {

       $document_status = '1';

     }



    if($bank_proof_status==''){        

        echo "<script>alert('some one feilds is empty please fill')</script>";

        exit();

        }

        else {  

             $insert_query = "update member set document_status='$document_status', bank_proof_status='$bank_proof_status' where member_no = '$member_no'";

            if (mysqli_query($con,$insert_query)) {                    

                     



                echo "<script>alert('Kyc Document has been successfully Verified...')</script>";

                echo "<script>window.open('kyc_documents.php','_self')</script>";

            }

            

            

        

        }  

  }

  if (isset($_POST['cancel_bank'])) {

   

    $document_status = '1';

    $bank_proof_status = $_POST['bank_proof_status'];

    $member_no = $_POST['member_no'];

    $date =  date('Y/m/d');

    $message = "Your Bank Proof image not clear or mismatch, please Reupload clear image...";

    $old_image=$_POST['old_image'];

      



    if($document_status==''){

        

        echo "<script>alert('some one feilds is empty please fill')</script>";

        exit();

        }



        else {     

             

             

             $insert_query = "update member set document_status='$document_status', bank_proof_status='$bank_proof_status' where member_no = '$member_no'";

            if (mysqli_query($con,$insert_query)) {                    

                     

                 mysqli_query($con, "insert into doc_notify(member_no, message, date, doc_status) values('$member_no', '$message', '$date', '3')");

                 unlink($_SERVER['DOCUMENT_ROOT'] . "/bank/$old_image");

                echo "<script>alert('Kyc Document has been Rejected...')</script>";

                echo "<script>window.open('kyc_documents.php','_self')</script>";

            }

            

            

        

        }  

  }



  // verifyinh process for pan 



 ?>

<?php } ?>