D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home5
/
rakcha
/
public_html
/
admin
/
Filename :
kyc_documents.php
back
Copy
<?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> <a class="parent-item" href="main_home.php">Home</a> <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 ©. 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 } ?>