db->query("SELECT id FROM customer_account_opening_requests WHERE MONTH(created_at) = '".$months[$i-1]."' AND YEAR(created_at) = '".$years[$i-1]."' AND network_id ='".$this->session->userdata('network_id')."'"); array_push($insuranceSubcriptions, $monthQuery->num_rows()); } $careRequests = []; // $date = date("Y"); // // $demandes_data[] = ''; // $demandes_data =array(); // for ($i = 1; $i <= 12; $i++) { // $demandes_query_mounth = $this->db->query("SELECT demande_id FROM info_demandeCredits // WHERE MONTH(dateAjout) = '".$months[$i-1]."' AND YEAR(dateAjout) = ".$years[$i-1]." // AND codeParrain='".$this->session->userdata('member_code')."'" // ); // $demandes_data[] = $demandes_query_mounth->num_rows(); // } // // $demandes_query = $listdem; // // if($demandes_query!=false){ // $demandes=$demandes_query->num_rows(); // // Count networks for simple users // $array_simple = array(); // $num = 0; // if ($demandes > 0) { // foreach($demandes_query->result() as $row) { // $num++; // $array_simple[] = $row->codeMembre; // } // // $vals_simple = array_count_values($array_simple); // //echo 'No. of NON Duplicate Items: '.count($vals_simple).'

'; // //print_r($vals_simple); // $pieChart2 = array(); // foreach(array_keys($vals_simple) as $paramName2) { // $color2 = dechex(rand(0x000000, 0xFFFFFF)); // $trash2 = array("value" => $vals_simple[$paramName2], // "color" => "#".$color2, // "highlight" => "#".$color2, // "label" => $paramName2); // // $pieChart2[]= $trash2; // // } // } // }else{ $pieChart2 = array(); // } /** ** Geolocated User Treatment **/ // $users_geolocated_query = $list_geolocated_users; // // Geolocated Users by month replace 2016 by NOW() // $users_geolocated_data[] = ''; // $users_geolocated_data =array(); // for ($i = 1; $i <= 12; $i++) { // $users_geolocated_query_january = $this->db->query("SELECT agent_id FROM super_infos // WHERE MONTH(date_created) = '".$months[$i-1]."' AND YEAR(date_created) = ".$years[$i-1]." // AND category='geolocated' AND code_parrain='".$this->session->userdata('member_code')."'"); // $users_geolocated_data[] = $users_geolocated_query_january->num_rows(); // } // // if($users_geolocated_query!=false){ // // $users_geolocated=$users_geolocated_query->num_rows(); // //$users_geolocated_query = json_encode($users_geolocated_query->result()); // // Counts network for geolocated users // $array_geolocated = array(); // $num = 0; // if ($users_geolocated > 0) { // foreach($users_geolocated_query->result() as $row) { // $num++; // $array_geolocated[] = date("M", strtotime($row->date_created)); // } // $vals_geolocated = array_count_values($array_geolocated); // //echo 'No. of NON Duplicate Items: '.count($vals_geolocated).'

'; // //print_r($vals_geolocated); // $pieChart = array(); // foreach(array_keys($vals_geolocated) as $paramName) { // $color = dechex(rand(0x000000, 0xFFFFFF)); // $trash = array("value" => $vals_geolocated[$paramName], // "color" => "#".$color, // "highlight" => "#".$color, // "label" => $paramName); // // $pieChart[]= $trash; // } // } // }else{ // $pieChart = array(); // } ?>

lang->line('account_opening_agent'); ?> lang->line('Tableau de bord'); ?>

lang->line('accepted_opening_account_requests'); ?>

lang->line("Plus d'informations"); ?>

lang->line('not_treated_opening_account_requests'); ?>

lang->line("Plus d'informations"); ?>

lang->line("rejected_opening_account_requests"); ?>

lang->line("Plus d'informations"); ?>

lang->line('customer_account_opening_requests'); ?>

lang->line('subscription_requests'); ?>