<?php 



  include("includes/database.php"); 



        
// echo "select * from member where daily_sms ='1' and member_no = '065'";
          

          $select_query_select_10a = "select * from member where daily_sms ='1'";



                                  $run_select_10a = mysqli_query($con,$select_query_select_10a);

                                    while ($row_select_10a = mysqli_fetch_array($run_select_10a)) {

                                    $name_row_select_10a = $row_select_10a['name'];

                                    $member_no_row_select_10a = $row_select_10a['member_no'];

                                    

                                    $user_id_row_select_10a = $row_select_10a['user_id'];

                                    $date_of_join_row_select_10a =$row_select_10a['date_of_join'];

                                    $city_district_row_select_10a =$row_select_10a['city_district'];

                                    $mobile_number_row_select_10a =$row_select_10a['mobile_number'];

                                    $state_row_select_10a =$row_select_10a['state'];


// echo "select * from roi_tree where member_no = '$member_no_row_select_10a' ORDER BY tree_id ASC";

                                    $select_query_main = "select * from roi_tree where member_no = '$member_no_row_select_10a' ORDER BY tree_id ASC";

                                    $run_main = mysqli_query($con,$select_query_main);

                                     

                                     while ($row_main = mysqli_fetch_array($run_main)) {

                                      $tree_id_main = $row_main['tree_id'];                                    

                                      $group_number_main = $row_main['group_number'];

                                      $member_no_main = $row_main['member_no'];

                                      $user_id_main = $row_main['user_id'];

                                      $sponsor_no_main = $row_main['sponsor_no'];

                                      $relation_ship_no_main = $row_main['relation_ship_no'];

                                      $level_no_main = $row_main['level_no'];

                                      $x_position_main = $row_main['x_position']+1;

                                      $y_position_main = $row_main['y_position'];

                                      $roi_amount_main = $row_main['roi_amount'];

                                      $roi_status_main = $row_main['roi_status'];

                                      $network_amount_main = $row_main['network_amount'];

                                      $total_bv_main = $row_main['total_bv'];

                                      }
                                    //   echo $network_amount_main += $network_amount_main;

                                      $arr1_10a_pro = array();

                                        $select_query_findempty_pay_10a_pro = "select * from product_member where member_no = '$member_no_main'";

                                        $run_findempty_pay_10a_pro = mysqli_query($con,$select_query_findempty_pay_10a_pro);

                                        while ($row_findempty_pay_10a_pro = mysqli_fetch_array($run_findempty_pay_10a_pro)) {

                                         $arr1_10a_pro[] = $row_findempty_pay_10a_pro['used_no'];

                                        }



                                      $select_query_cur_product_x1_10a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

                                      $run_cur_product_x1_10a = mysqli_query($con,$select_query_cur_product_x1_10a);

                                      while($row_cur_product_x1_10a = mysqli_fetch_array($run_cur_product_x1_10a)){

                                            $p_cur_product_x1_10a = $row_cur_product_x1_10a['SUM(product_amount)'];

                                      }



                                      $total_group_pv = $p_cur_product_x1_10a;

                                      

                               

      $string = preg_replace('/\s+/', '', $name_row_select_10a);



     $network_amount_mains = intval($network_amount_main);

     $total_group_pvs = intval($total_group_pv);

          


// echo "Dear ".$string." Happy Morning, Your A/C ".$user_id_main." Personal PV ".$network_amount_mains.", Group PV ".$total_group_pvs.". More Info : www.rakcha.in";
  $message = "Dear ".$string." Happy Morning, Your A/C ".$user_id_main." Personal PV ".$network_amount_mains.", Group PV ".$total_group_pvs.". More Info : www.rakcha.in";

//   exit(); 

                        $message = urlencode($message);

                        $url = 'http://sms.messageindia.in/sendSMS?username=th&message='.$message.'&sendername=RAKCHA&smstype=TRANS&numbers='.$mobile_number_row_select_10a.'&apikey=25679508-87af-4b55-bb22-873e006ef48a';

                        $xml = file_get_contents($url);

                        echo $xml;



     



          

 }



 exit();





  ?>