<?php  

 include("includes/database.php"); 



  $select_query_main = "select * from net_trees where status='0' ORDER BY tree_id ASC";

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

         

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

          $member_no_main = $row_main['member_no'];

          $network_tree_id = $row_main['tree_id'];











             //





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

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

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

                  $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'];

                  $user_id = $row['user_id'];

                  $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'];

                  $activity_level = $row['activity_level'];

                  $activity_referral = $row['activity_referral'];

                  $activity_date = $row['activity_date'];

                  $activity_month = $row['activity_month'];

                  $member_fess = $row['member_fess'];

                  $elite_board = $row['elite_board'];

                  $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'];

                  $date_of_join_1 =$row['date_of_join'];

               



                  $today_date = date('Y-m-d');



                }



                $select_query_12 = "select * from admin";

                $run_12 = mysqli_query($con,$select_query_12);

                 while ($row_12 = mysqli_fetch_array($run_12)) { 

                      $network_12 = $row_12['network']; 

                  }



                   



                      





                   



                     



                               



                                  

                                

                       



                                       $select_query_direct_get_first_list = "select * from net_tree where member_no='$member_no' AND status='$network_12'";

                                       $run_direct_get_first_list = mysqli_query($con,$select_query_direct_get_first_list);

                                       $user_direct_get_first_list = mysqli_num_rows($run_direct_get_first_list); 





                                       $select_query_direct_get_last_tree = "select * from net_tree where status='$network_12'";

                                       $run_direct_get_last_tree = mysqli_query($con,$select_query_direct_get_last_tree);

                                       $user_direct_get_last_tree = mysqli_num_rows($run_direct_get_last_tree);



                                       if ($user_direct_get_last_tree == 0) {



                                        $group_number ="001";

                                        $sponsor_no =$member_no;

                                        $level_no =1;

                                        $relation_ship_no_1 ="001001".$member_no;

                                        $x_position_next =1;

                                        $y_position_1 =1; 





                                        mysqli_query($con, "insert into net_tree(group_number, member_no, sponsor_no, level_no, relation_ship_no, x_position, y_position, date, user_id, status) values('$group_number', '$member_no', '$sponsor_no', '$level_no', '$relation_ship_no_1', '$x_position_next', '$y_position_1', '$today_date', '$user_id', '$network_12')");



                                                      mysqli_query($con,"update net_trees set status='1' where tree_id = '$network_tree_id'");



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

                                                      exit();







                                                  

                                       }

                                       else {







                      

                                       if ($user_direct_get_first_list == 0) {

                                          

                              

                                  

                                        $select_query_12 = "select * from net_tree where status='$network_12' ORDER BY tree_id ASC LIMIT 1";

                                        $run_12 = mysqli_query($con,$select_query_12);

                                         while ($row_12 = mysqli_fetch_array($run_12)) { 

                                              $sponsor_id = $row_12['member_no']; 

                                          }

                                       





                                         



                                        $select_query_register = "select * from net_tree where member_no='$sponsor_id' AND status='$network_12' ORDER BY tree_id ASC LIMIT 1";



                                          $run_register = mysqli_query($con,$select_query_register);                       



                                          while ($row_register = mysqli_fetch_array($run_register)) {                       



                                          $tree_id_register = $row_register['tree_id'];



                                          $group_number_register = $row_register['group_number'];



                                          $member_no_register = $row_register['member_no'];



                                          $sponsor_no_register = $row_register['sponsor_no'];



                                          $level_no_register = $row_register['level_no'];



                                          $relation_ship_no_register = $row_register['relation_ship_no'];



                                          $x_position_register = $row_register['x_position'];



                                          $y_position_register = $row_register['y_position'];







                                          }







                                        $group_number = $group_number_register;



                                        $member_no = $member_no;



                                        $sponsor_no = $sponsor_id;



                                        $level_no = 1;



                                        $relation_ship_no = $relation_ship_no_register."".$member_no;



                                        $x_position = $x_position_register+1;







                                        // find empty position







                                            $select_query_findempty = "select * from net_tree where status='$network_12' ORDER BY tree_id ASC, x_position ASC";



                                            $run_findempty = mysqli_query($con,$select_query_findempty);



                                            



                                             while ($row_findempty = mysqli_fetch_array($run_findempty)) {



                                              



                                              $tree_id_findempty = $row_findempty['tree_id'];



                                              $group_number_findempty = $row_findempty['group_number'];



                                              $member_no_findempty = $row_findempty['member_no'];



                                              $sponsor_no_findempty = $row_findempty['sponsor_no'];



                                              $level_no_findempty = $row_findempty['level_no'];



                                              $relation_ship_no_findempty = $row_findempty['relation_ship_no'];



                                              $x_position_findempty = $row_findempty['x_position']+1;



                                              $y_position_findempty = $row_findempty['y_position'];



                                              



                                              //count user



                                              $select_query_check_empty = "select * from net_tree where group_number = '$group_number_findempty' AND relation_ship_no LIKE '%{$relation_ship_no_findempty}%' AND x_position = '$x_position_findempty' AND status='$network_12' ORDER BY x_position ASC, y_position ASC";



                                                  $run_check_empty = mysqli_query($con,$select_query_check_empty);



                                                  $user_check_empty = mysqli_num_rows($run_check_empty);







                                                if ($user_check_empty < 2) {



                                                  



                                                  



                                                   //count user



                                                    $select_query_y = "select * from net_tree where group_number = '$group_number' AND x_position = '$x_position_findempty' AND relation_ship_no LIKE '%{$relation_ship_no_findempty}%' AND status='$network_12'";



                                                        $run_y = mysqli_query($con,$select_query_y);







                                                        $user_y = mysqli_num_rows($run_y);







                                                        $y_position_1 = $user_y + 1;







                                                        $relation_ship_no_1 = $relation_ship_no_findempty."".$member_no;



                                                        



                                                        $x_position_next = $x_position_findempty;



                                                        //get sponser activity month



                                                    



                                                   // get sponser activity month







                                                    





                                                     

                                                     



                                                      mysqli_query($con, "insert into net_tree(group_number, member_no, sponsor_no, level_no, relation_ship_no, x_position, y_position, date, user_id, status) values('$group_number', '$member_no', '$sponsor_no', '$level_no', '$relation_ship_no_1', '$x_position_next', '$y_position_1', '$today_date', '$user_id', '$network_12')");



                                                      mysqli_query($con,"update net_trees set status='1' where tree_id = '$network_tree_id'");



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

                                                          exit();



                                                      

                                                    











                                                }



















                                          





                           

                          





                           





                         

              }





              } 



              }

 }

             //

           

  

        



   

   

    

  ?>