1#@!#!123s

32767 1#@!#!123s
: / home5 / rakcha / public_html / admin /
Filename : main_home.php
back
<?php error_reporting(E_ALL);
ini_set('display_errors', '1'); ?>
<?php 

session_start();

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

    header("location: index.php");

 }

 else {

  include("includes/database.php");

  $page_user = $_SESSION['admin_name'];

  $year = date("Y");

     $month = date("m");



     $select_query_payment = "select * from week_payout ORDER BY payout_id DESC LIMIT 1";

       $run_payment = mysqli_query($con,$select_query_payment);

       $serial_payment = 1;

       while ($row_payment = mysqli_fetch_array($run_payment)) {

        $date = $row_payment['date'];

    }

    $last_month_end = date("Y-m-d", strtotime("last day of previous month"));

  ?>

  <!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" />

    <!-- 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 -->

    

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

    <link href="assets/css/style.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" />

    <!-- Owl Carousel Assets -->

    <link href="assets/plugins/owl-carousel/owl.carousel.css" rel="stylesheet">

    <link href="assets/plugins/owl-carousel/owl.theme.css" rel="stylesheet">

    <!-- 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 active">

                                <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">

                                <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">

                            

                            <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">Dashboard</li>

                            </ol>

                        </div>

                    </div>

                    <!-- start widget -->



                    <div class="state-overview">

                        <div class="row">

                            <div class="col-xl-3 col-md-6 col-12">

                              <div class="info-box bg-blue">

                                <span class="info-box-icon push-bottom"><i class="material-icons">style</i></span>

                                <div class="info-box-content">

                                  <span class="info-box-text">KIT SALES REPORT</span>

                                  <span class="info-box-number">



                                    <?php 

                                              

                                               $select_query_get_left_xc = "select * from roi_tree where roi_amount ='300'";

                                                $run_get_left_xc = mysqli_query($con,$select_query_get_left_xc);

                                                $num_left_xc = mysqli_num_rows($run_get_left_xc);

                                                echo $num_left_xc*999;



                                         ?>



                                         TOTAL



                                  </span>

                                  <div class="progress">

                                    <div class="progress-bar width-60"></div>

                                  </div>

                                  <span class="progress-description">

                                    <?php 



                                              

                                              

                                               $select_query_get_left_ac = "select * from roi_tree where roi_amount ='300' AND date > '$last_month_end'";

                                                $run_get_left_ac = mysqli_query($con,$select_query_get_left_ac);

                                                $num_left_ac = mysqli_num_rows($run_get_left_ac);

                                                echo $num_left_ac*999;



                                         ?>



                                          CM

                                  </span>

                                </div>

                                <!-- /.info-box-content -->

                              </div>

                              <!-- /.info-box -->

                            </div>

                            <!-- /.col -->

                            <div class="col-xl-3 col-md-6 col-12">

                              <div class="info-box bg-orange">

                                <span class="info-box-icon push-bottom"><i class="material-icons">card_travel</i></span>

                                <div class="info-box-content">

                                  <span class="info-box-text">RE-PURCHASE REPORT</span>

                                  <span class="info-box-number">

                                     <?php 

                                              

                                               $select_query_total_team_pv = "select SUM(cp) from product_check";

                                                  $run_total_team_pv = mysqli_query($con,$select_query_total_team_pv);

                                                  while($row_total_team_pv = mysqli_fetch_array($run_total_team_pv)){

                                                        $total_team_pv_1 = $row_total_team_pv['SUM(cp)'];

                                                        

                                                  }

                                                  echo $total_team_pv_1;



                                         ?>

                                  </span>

                                  <div class="progress">

                                    <div class="progress-bar width-40"></div>

                                  </div>

                                  <span class="progress-description">

                                        <?php 

                                              

                                               $select_query_total_team_pv_a = "select SUM(cp) from product_check where issue_date > '$last_month_end'";

                                                  $run_total_team_pv_a = mysqli_query($con,$select_query_total_team_pv_a);

                                                  while($row_total_team_pv_a = mysqli_fetch_array($run_total_team_pv_a)){

                                                        $total_team_pv_a_1 = $row_total_team_pv_a['SUM(cp)'];

                                                        

                                                  }

                                                  echo $total_team_pv_a_1;



                                         ?>   CM

                                      </span>

                                </div>

                                <!-- /.info-box-content -->

                              </div>

                              <!-- /.info-box -->

                            </div>

                            <!-- /.col -->

                            <div class="col-xl-3 col-md-6 col-12">

                              <div class="info-box bg-purple">

                                <span class="info-box-icon push-bottom"><i class="material-icons">phone_in_talk</i></span>

                                <div class="info-box-content">

                                  <span class="info-box-text">COMPANY BV REPORT </span>

                                  <span class="info-box-number">



                                     <?php 

                                              

                                               $select_query_total_totalbv = "select SUM(roi_amount) from roi_tree";

                                                  $run_total_totalbv = mysqli_query($con,$select_query_total_totalbv);

                                                  while($row_total_totalbv = mysqli_fetch_array($run_total_totalbv)){

                                                        $total_totalbv_1 = $row_total_totalbv['SUM(roi_amount)'];

                                                        

                                                  }



                                                  $select_query_total_tcmbv = "select SUM(product_amount) from product_tree";

                                                  $run_total_tcmbv = mysqli_query($con,$select_query_total_tcmbv);

                                                  while($row_total_tcmbv = mysqli_fetch_array($run_total_tcmbv)){

                                                        $total_tcmbv_1 = $row_total_tcmbv['SUM(product_amount)'];

                                                        

                                                  }



                                                  echo $total_totalbv_1+$total_tcmbv_1;



                                         ?>



                                  </span>

                                  <div class="progress">

                                    <div class="progress-bar width-80"></div>

                                  </div>

                                  <span class="progress-description">

                                        <?php 

                                              

                                               $select_query_total_totalbvr = "select SUM(roi_amount) from roi_tree where date > '$last_month_end'";

                                                  $run_total_totalbvr = mysqli_query($con,$select_query_total_totalbvr);

                                                  while($row_total_totalbvr = mysqli_fetch_array($run_total_totalbvr)){

                                                        $total_totalbvr_1 = $row_total_totalbvr['SUM(roi_amount)'];

                                                        

                                                  }



                                                  $select_query_total_tcmbvr = "select SUM(bv) from product_check where issue_date > '$last_month_end'";

                                                  $run_total_tcmbvr = mysqli_query($con,$select_query_total_tcmbvr);

                                                  while($row_total_tcmbvr = mysqli_fetch_array($run_total_tcmbvr)){

                                                        $total_tcmbvr_1 = $row_total_tcmbvr['SUM(bv)'];

                                                        

                                                  }



                                                  echo $total_totalbvr_1+$total_tcmbvr_1;



                                         ?>   CM

                                      </span>

                                </div>

                                <!-- /.info-box-content -->

                              </div>

                              <!-- /.info-box -->

                            </div>

                            <!-- /.col -->

                             

                            <!-- /.col -->

                          </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>

    <!-- Common js-->

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

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

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

    <!-- owl carousel -->

    <script src="assets/plugins/owl-carousel/owl.carousel.js"></script>

    <script src="assets/js/pages/owl-carousel/owl_data.js"></script>

    <!-- material -->

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

    <!-- animation -->

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

    <!-- chart js -->

    <script src="assets/plugins/chart-js/Chart.bundle.js" ></script>

    <script src="assets/plugins/chart-js/utils.js" ></script>

    <script src="assets/js/pages/chart/chartjs/home-data3.js" ></script>

    <!-- sparkline -->

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

    <script src="assets/js/pages/sparkline/sparkline-data.js" ></script>

    <script type="text/javascript">

        $("#btc_count").keyup(function(){

            $("#btc_count_display").text($(this).val().length);

          });

          $("#btc_count").keyup(function(){

              $("#btc_count_display").text("Message Length - " + ($(this).val().length));

            });

    </script>

    <!-- end js include path -->

  </body>



</html>

<?php 



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

       $message = $_POST['message'];

       $mobile_number = $_POST['contact_no'];



       $message = urlencode($message);

      $url = 'http://sms.indiatext.in/api/mt/SendSMS?user=th&password=Optimus_1&senderid=RAKCHA&channel=trans&DCS=0&flashsms=0&number='.$mobile_number.'&text='.$message.'&route=1';



      $xml = file_get_contents($url);



      echo $xml;

                      

                              // count group

                              echo "<script>alert('Your has been Successfully Sent...')</script>";

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

                    exit();

    }



 ?>

<?php } ?>