public function clean($mlm_plan)
{
require_once 'registersubmit.php';
$obj_reg = new registersubmit();
require_once 'validation.php';
$obj_val = new validation();
require_once 'board_registersubmit.php';
$obj_board = new board_registersubmit();
$session_data = $this->session->userdata('logged_in');
$admin_pass = $obj_val->getAdminPassword();
$admin_id = $obj_val->getAdminId();
$details = $this->getUserDetail($admin_id);
//to get details of admin
//$logged_user_id = $details['user_detail_refid'];
$logged_user_id = 12345;
$table_prefix = $session_data['table_prefix'];
$user_name = $session_data['user_name'];
$this->begin();
$res1 = $this->db->truncate('amount_paid');
$res2 = $this->db->truncate('complaint_query_table');
$res3 = $this->db->truncate('complaint_ticket_table');
$res4 = $this->db->truncate('events');
$res5 = $this->db->truncate('feedback');
$res6 = $this->db->truncate('ft_individual');
$res7 = $this->db->truncate('ft_individual_unilevel');
$res8 = $this->db->truncate('fund_transfer_details');
$res9 = $this->db->truncate('investment');
$res10 = $this->db->truncate('leg_amount');
$res11 = $this->db->truncate('leg_carry_forward');
$res12 = $this->db->truncate('login_user');
$res13 = $this->db->truncate('mailtoadmin');
$res14 = $this->db->truncate('mailtouser');
$res15 = $this->db->truncate('news');
$res16 = $this->db->truncate('password_reset_table');
$res17 = $this->db->truncate('pin_numbers');
$res18 = $this->db->truncate('pin_request');
$res19 = $this->db->truncate('payout_release_requests');
$res20 = $this->db->truncate('sms_history');
$res21 = $this->db->truncate('tran_password');
$res22 = $this->db->truncate('user_balance_amount');
$res23 = $this->db->truncate('user_details');
$res24 = $this->db->truncate('leg_details');
$res25 = $this->db->truncate('product_image_table');
$res26 = $this->db->truncate('rank_history');
$res27 = $this->db->truncate('sales_order');
$res28 = $this->db->truncate('activity_history');
$res29 = $this->db->truncate('live_account_registration_details');
$res30 = $this->db->truncate('credit_card_purchase_details');
$res31 = $this->db->truncate('pin_used');
$res31 = $this->db->truncate('username_change_history');
$res61 = $this->db->truncate('payment_registration_details');
$res62 = $this->db->truncate('authorize_payment_details');
$res63 = $this->db->truncate('employee_details');
$res64 = $this->db->truncate('login_employee');
$res65 = $this->db->truncate('cron_history');
$res66 = $this->db->truncate('exact_payment_history');
$res66 = $this->db->truncate('cookie_user');
$login_user = $this->table_prefix . "login_user";
$set_auto_increment_login_user = "******";
$res32 = $this->db->query($set_auto_increment_login_user);
$ft_individual = $this->table_prefix . "ft_individual";
$set_auto_increment_ft_individual = "ALTER TABLE {$ft_individual} AUTO_INCREMENT={$logged_user_id}";
$res33 = $this->db->query($set_auto_increment_ft_individual);
$login_data = array('user_id' => $logged_user_id, 'user_type' => 'admin', 'addedby' => 'code', 'user_name' => $user_name, 'password' => $admin_pass);
$res37 = $this->db->insert('login_user', $login_data);
$current_date = date("Y-m-d H:i:s");
$ft_details = array('id' => $logged_user_id, 'father_id' => '0', 'position' => '', 'user_name' => $user_name, 'active' => 'yes', 'date_of_joining' => $current_date, 'product_id' => '1');
$res38 = $this->db->insert('ft_individual', $ft_details);
$ft_details_ul = array('id' => $logged_user_id, 'father_id' => '0', 'position' => '0', 'user_name' => $user_name, 'active' => 'yes', 'date_of_joining' => $current_date, 'product_id' => '1');
$res39 = $this->db->insert('ft_individual_unilevel', $ft_details_ul);
$leg_details = array('id' => $logged_user_id);
$res40 = $this->db->insert('leg_details', $leg_details);
///////////////////code added by amrutha
$date = date("Y-m-d H:i:s");
$user_details = array('user_detail_refid' => $logged_user_id, 'user_detail_name' => $details['user_detail_name'], 'user_detail_address' => $details['user_detail_address'], 'user_detail_town' => $details['user_detail_town'], 'user_detail_country' => $details['user_detail_country'], 'user_detail_state' => $details['user_detail_state'], 'user_detail_pin' => $details['user_detail_pin'], 'user_detail_passcode' => $details['user_detail_passcode'], 'user_detail_mobile' => $details['user_detail_mobile'], 'user_detail_land' => $details['user_detail_land'], 'user_detail_email' => $details['user_detail_email'], 'user_detail_dob' => $details['user_detail_dob'], 'user_detail_gender' => $details['user_detail_gender'], 'user_detail_nominee' => $details['user_detail_nominee'], 'user_detail_relation' => $details['user_detail_relation'], 'user_detail_acnumber' => $details['user_detail_acnumber'], 'user_detail_nbank' => $details['user_detail_nbank'], 'user_photo' => $details['user_photo'], 'join_date' => $date, 'user_detail_nbranch' => $details['user_detail_nbranch']);
$res41 = $this->db->insert('user_details', $user_details);
$this->db->select_max('user_id', 'user_id');
$this->db->from('login_user');
$query = $this->db->get();
foreach ($query->result() as $row) {
$get_id = $row->user_id;
}
if ($mlm_plan == 'Board') {
$res42 = $obj_board->tmpInsert($get_id, "1");
} else {
$res42 = $obj_reg->tmpInsert($get_id, "L");
$res43 = $obj_reg->tmpInsert($get_id, "R");
}
$user_balance_details = array('user_id' => $get_id, 'balance_amount' => '0');
$res44 = $this->db->insert('user_balance_amount', $user_balance_details);
$tran_password_details = array('user_id' => $logged_user_id, 'tran_password' => '12345678');
$res45 = $this->db->insert('tran_password', $tran_password_details);
if ($mlm_plan == "Board") {
/////////////////////////////////////////////////////////////for board plan
$res46 = $this->db->truncate("board_split_status");
$res47 = $this->db->truncate("board_user_detail");
$res48 = $this->db->truncate("auto_board_1");
$res49 = $this->db->truncate("board_view");
$res50 = $this->db->truncate("board_referral_count");
$auto_board = $this->table_prefix . "auto_board_1";
$set_auto_increment_auto_board = "ALTER TABLE {$auto_board} AUTO_INCREMENT={$logged_user_id}";
$res51 = $this->db->query($set_auto_increment_auto_board);
$board_split_status = $this->table_prefix . "board_split_status";
$set_auto_increment_board_split_status = "ALTER TABLE {$board_split_status} AUTO_INCREMENT=1";
$res52 = $this->db->query($set_auto_increment_board_split_status);
$board_user_detail = $this->table_prefix . "board_user_detail";
$set_auto_increment_board_user_detail = "ALTER TABLE {$board_user_detail} AUTO_INCREMENT=1";
$res53 = $this->db->query($set_auto_increment_board_user_detail);
$board_view = $this->table_prefix . "board_view";
$set_auto_increment_board_view = "ALTER TABLE {$board_view} AUTO_INCREMENT = 1";
$res54 = $this->db->query($set_auto_increment_board_view);
$board_view = $this->table_prefix . "board_referral_count";
$set_auto_increment_board_referral_count = "ALTER TABLE {$board_view} AUTO_INCREMENT = 1";
$res55 = $this->db->query($set_auto_increment_board_referral_count);
$board_user_details = array("board_table_name" => '1', "user_id" => $logged_user_id, "board_serial_no" => '1', "date_of_join" => $date);
$res56 = $this->db->insert('board_user_detail', $board_user_details);
$board_split_status_det = array("user_ref_id" => $logged_user_id, "board_number" => '1', "status" => 'no', "date_of_update" => $date);
$res57 = $this->db->insert('board_split_status', $board_split_status_det);
$auto_board_det = array("user_ref_id" => $logged_user_id, "user_name" => $user_name, "position" => '', "active" => 'yes', "father_id" => '0', "date_of_joining" => $date, "user_level" => '0');
$res58 = $this->db->insert('auto_board_1', $auto_board_det);
$board_view_det = array("board_top_id" => $logged_user_id, "board_table_name" => '1', "board_no" => '1', "board_split_status" => 'no', "date_of_join" => $date);
$res59 = $this->db->insert('board_view', $board_view_det);
$board_referral_count_det = array("board_id" => $logged_user_id, "user_ref_id" => $logged_user_id, "referral_count" => '0');
$res60 = $this->db->insert('board_referral_count', $board_referral_count_det);
/* ///////////////////////////////if auto_board_2 exists
$res61 = $this->db->truncate("auto_board_2");
$auto_board2 = $this->table_prefix . "auto_board_2";
$set_auto_increment_auto_board = "ALTER TABLE $auto_board2 AUTO_INCREMENT=$logged_user_id";
$res62 = $this->db->query($set_auto_increment_auto_board);
$board_user_details = array(
"board_table_name" => '2',
"user_id" => $logged_user_id,
"board_serial_no" => '1',
"date_of_join" => $date
);
$res63 = $this->db->insert('board_user_detail', $board_user_details);
$auto_board_det = array(
"user_ref_id" => $logged_user_id,
"user_name" => $user_name,
"position" => '',
"active" => 'yes',
"father_id" => '0',
"date_of_joining" => $date,
"user_level" => '0'
);
$res64 = $this->db->insert('auto_board_2', $auto_board_det);
$board_view_det = array(
"board_top_id" => $logged_user_id,
"board_table_name" => '2',
"board_no" => '1',
"board_split_status" => 'no',
"date_of_join" => $date
);
$res65 = $this->db->insert('board_view', $board_view_det); */
////////////////////////////////////////////////////
}
if ($res45) {
$this->commit();
} else {
$this->rollBack();
}
return $res45;
}
