@@ -7,15 +7,15 @@ |
||
| 7 | 7 | |
| 8 | 8 | <?php |
| 9 | 9 | $this->db->select('*'); |
| 10 | - $this->db->where('domain',$_SERVER['HTTP_HOST']); |
|
| 11 | - $result=$this->db->get('invoice_conf'); |
|
| 12 | - if($result->num_rows() > 0){ |
|
| 13 | - $result=$result->result_array(); |
|
| 10 | + $this->db->where('domain', $_SERVER['HTTP_HOST']); |
|
| 11 | + $result = $this->db->get('invoice_conf'); |
|
| 12 | + if ($result->num_rows() > 0) { |
|
| 13 | + $result = $result->result_array(); |
|
| 14 | 14 | $footer = $result[0]['website_footer']; |
| 15 | - }else{ |
|
| 15 | + } else { |
|
| 16 | 16 | $footer = ''; |
| 17 | 17 | } |
| 18 | - if($footer != ''){ ?> |
|
| 18 | + if ($footer != '') { ?> |
|
| 19 | 19 | <div style="margin-left:470px; "><?=$footer ?> |
| 20 | 20 | |
| 21 | 21 | <div style="" class="pull-left"> |
@@ -61,84 +61,83 @@ |
||
| 61 | 61 | <div class="sidebar collapse"> |
| 62 | 62 | |
| 63 | 63 | <?php |
| 64 | - $uri_string= uri_string(); |
|
| 65 | - $uri_arr=explode("/",$uri_string);
|
|
| 66 | - $entity_name=false; |
|
| 67 | - if(isset($uri_arr[1]) && !empty($uri_arr[1])){
|
|
| 68 | - $function_explode=explode("_",$uri_arr[1]);
|
|
| 69 | - $entity_name = isset($function_explode[1]) && !empty($function_explode[1]) ? $function_explode[0] : false; |
|
| 64 | + $uri_string = uri_string(); |
|
| 65 | + $uri_arr = explode("/", $uri_string);
|
|
| 66 | + $entity_name = false; |
|
| 67 | + if (isset($uri_arr[1]) && ! empty($uri_arr[1])) {
|
|
| 68 | + $function_explode = explode("_", $uri_arr[1]);
|
|
| 69 | + $entity_name = isset($function_explode[1]) && ! empty($function_explode[1]) ? $function_explode[0] : false; |
|
| 70 | 70 | } |
| 71 | 71 | |
| 72 | - $accountinfo=$this->session->userdata('accountinfo');
|
|
| 73 | - if($accountinfo['type'] != 0 && $accountinfo['type'] !=3){
|
|
| 74 | - $menu_info= ($uri_arr[0]=="user" |
|
| 75 | - ? unserialize(RESELLERPROFILE_ARRAY):($uri_arr[0]=="accounts"&& $entity_name =='customer' |
|
| 76 | - ? unserialize(CUSTOMEREDIT_ARRAY) :($uri_arr[0]=="accounts"&& $entity_name =='provider' |
|
| 77 | - ? unserialize(PROVIDEREDIT_ARRAY) :($uri_arr[0]=="accounts"&& $entity_name =='reseller' |
|
| 78 | - ? unserialize(RESELLEREDIT_ARRAY) : ($uri_arr[0] =="package" ? unserialize(PACKAGEEDIT_ARRAY):false) )))); |
|
| 79 | - }else{
|
|
| 80 | - $menu_info=null; |
|
| 81 | - $current_menu_url=$uri_arr[0]."/".$uri_arr[1]."/"; |
|
| 82 | - $new_menu_info=array(); |
|
| 83 | - $menus= unserialize($this->session->userdata('menuinfo'));
|
|
| 84 | - foreach($menus as $entity_key=>$entity_menu){
|
|
| 85 | - foreach($entity_menu as $entity_subkey=>$entity_submenu){
|
|
| 86 | - foreach($entity_submenu as $subkey=>$submenus){
|
|
| 87 | - if($submenus['module_url']==$current_menu_url){
|
|
| 88 | - $new_menu_info=$entity_menu; |
|
| 72 | + $accountinfo = $this->session->userdata('accountinfo');
|
|
| 73 | + if ($accountinfo['type'] != 0 && $accountinfo['type'] != 3) {
|
|
| 74 | + $menu_info = ($uri_arr[0] == "user" |
|
| 75 | + ? unserialize(RESELLERPROFILE_ARRAY) : ($uri_arr[0] == "accounts" && $entity_name == 'customer' |
|
| 76 | + ? unserialize(CUSTOMEREDIT_ARRAY) : ($uri_arr[0] == "accounts" && $entity_name == 'provider' |
|
| 77 | + ? unserialize(PROVIDEREDIT_ARRAY) : ($uri_arr[0] == "accounts" && $entity_name == 'reseller' |
|
| 78 | + ? unserialize(RESELLEREDIT_ARRAY) : ($uri_arr[0] == "package" ? unserialize(PACKAGEEDIT_ARRAY) : false))))); |
|
| 79 | + } else {
|
|
| 80 | + $menu_info = null; |
|
| 81 | + $current_menu_url = $uri_arr[0]."/".$uri_arr[1]."/"; |
|
| 82 | + $new_menu_info = array(); |
|
| 83 | + $menus = unserialize($this->session->userdata('menuinfo'));
|
|
| 84 | + foreach ($menus as $entity_key=>$entity_menu) {
|
|
| 85 | + foreach ($entity_menu as $entity_subkey=>$entity_submenu) {
|
|
| 86 | + foreach ($entity_submenu as $subkey=>$submenus) {
|
|
| 87 | + if ($submenus['module_url'] == $current_menu_url) {
|
|
| 88 | + $new_menu_info = $entity_menu; |
|
| 89 | 89 | } |
| 90 | 90 | } |
| 91 | 91 | } |
| 92 | 92 | } |
| 93 | - foreach($new_menu_info as $key=>$value){
|
|
| 94 | - foreach($value as $subvalue){
|
|
| 95 | - $menu_info[$subvalue['menu_label']]=$subvalue['module_url']; |
|
| 93 | + foreach ($new_menu_info as $key=>$value) {
|
|
| 94 | + foreach ($value as $subvalue) {
|
|
| 95 | + $menu_info[$subvalue['menu_label']] = $subvalue['module_url']; |
|
| 96 | 96 | } |
| 97 | 97 | } |
| 98 | 98 | } |
| 99 | - if($accountinfo['type']==0 || $accountinfo['type']==3){
|
|
| 100 | - if($uri_arr[0]=='user' && $uri_arr[1] =='user_myprofile' || $uri_arr[0]=='user' && $uri_arr[1]=='user_change_password'){
|
|
| 101 | - $menu_info=unserialize(CUSTOMERPROFILE_ARRAY); |
|
| 99 | + if ($accountinfo['type'] == 0 || $accountinfo['type'] == 3) {
|
|
| 100 | + if ($uri_arr[0] == 'user' && $uri_arr[1] == 'user_myprofile' || $uri_arr[0] == 'user' && $uri_arr[1] == 'user_change_password') {
|
|
| 101 | + $menu_info = unserialize(CUSTOMERPROFILE_ARRAY); |
|
| 102 | 102 | } |
| 103 | 103 | } |
| 104 | - if(!empty($menu_info)){
|
|
| 104 | + if ( ! empty($menu_info)) {
|
|
| 105 | 105 | echo "<ul class='sidemenu'>"; |
| 106 | - $i=0; |
|
| 107 | - foreach($menu_info as $key=>$value){
|
|
| 108 | - $url=($entity_name=='provider'||$entity_name =='customer' || $entity_name =='reseller' || $uri_arr[0] =="package") && isset($uri_arr[2]) && !empty($uri_arr[2]) |
|
| 106 | + $i = 0; |
|
| 107 | + foreach ($menu_info as $key=>$value) {
|
|
| 108 | + $url = ($entity_name == 'provider' || $entity_name == 'customer' || $entity_name == 'reseller' || $uri_arr[0] == "package") && isset($uri_arr[2]) && ! empty($uri_arr[2]) |
|
| 109 | 109 | ? |
| 110 | - base_url().$value.$uri_arr[2]."/" : |
|
| 111 | - base_url().$value; |
|
| 112 | - $value_flag=false; |
|
| 113 | - if($acc_info['type'] == '3' || $acc_info['type'] == '0'){
|
|
| 114 | - if($value == "user/user_ipmap/" && $acc_info['allow_ip_management'] == '1'){
|
|
| 115 | - $value_flag=false; |
|
| 116 | - }elseif(in_array('user/user_sipdevices/',$menu_info) && $value == "user/user_sipdevices/" && common_model::$global_config['system_config']['opensips']== 0){
|
|
| 117 | - $value_flag=false; |
|
| 118 | - }else{
|
|
| 119 | - $value_flag=true; |
|
| 110 | + base_url().$value.$uri_arr[2]."/" : base_url().$value; |
|
| 111 | + $value_flag = false; |
|
| 112 | + if ($acc_info['type'] == '3' || $acc_info['type'] == '0') {
|
|
| 113 | + if ($value == "user/user_ipmap/" && $acc_info['allow_ip_management'] == '1') {
|
|
| 114 | + $value_flag = false; |
|
| 115 | + }elseif (in_array('user/user_sipdevices/', $menu_info) && $value == "user/user_sipdevices/" && common_model::$global_config['system_config']['opensips'] == 0) {
|
|
| 116 | + $value_flag = false; |
|
| 117 | + } else {
|
|
| 118 | + $value_flag = true; |
|
| 120 | 119 | } |
| 121 | - }else{
|
|
| 122 | - if(common_model::$global_config['system_config']['opensips'] == 1 ){
|
|
| 123 | - if($value != "accounts/".$entity_name."_opensips/"){
|
|
| 124 | - $value_flag=true; |
|
| 125 | - }else{
|
|
| 126 | - $value_flag=false; |
|
| 120 | + } else {
|
|
| 121 | + if (common_model::$global_config['system_config']['opensips'] == 1) {
|
|
| 122 | + if ($value != "accounts/".$entity_name."_opensips/") {
|
|
| 123 | + $value_flag = true; |
|
| 124 | + } else {
|
|
| 125 | + $value_flag = false; |
|
| 127 | 126 | } |
| 128 | 127 | } |
| 129 | - if(common_model::$global_config['system_config']['opensips']== 0 ){
|
|
| 130 | - if($value != "accounts/".$entity_name."_sipdevices/"){
|
|
| 131 | - $value_flag=true; |
|
| 132 | - }else{
|
|
| 133 | - $value_flag=false; |
|
| 128 | + if (common_model::$global_config['system_config']['opensips'] == 0) {
|
|
| 129 | + if ($value != "accounts/".$entity_name."_sipdevices/") {
|
|
| 130 | + $value_flag = true; |
|
| 131 | + } else {
|
|
| 132 | + $value_flag = false; |
|
| 134 | 133 | } |
| 135 | 134 | } |
| 136 | 135 | } |
| 137 | 136 | |
| 138 | - if($value_flag){
|
|
| 139 | - $class = ($value == $uri_arr[0]."/".$uri_arr[1]."/" ) ? 'active' : ''; |
|
| 140 | - if($i==0) |
|
| 141 | - $class=($uri_arr[1]== $entity_name."_save") ? 'active': $class; |
|
| 137 | + if ($value_flag) {
|
|
| 138 | + $class = ($value == $uri_arr[0]."/".$uri_arr[1]."/") ? 'active' : ''; |
|
| 139 | + if ($i == 0) |
|
| 140 | + $class = ($uri_arr[1] == $entity_name."_save") ? 'active' : $class; |
|
| 142 | 141 | |
| 143 | 142 | echo "<li class='$class'><a href ='$url'>$key</a></li>"; |
| 144 | 143 | } |
@@ -3,7 +3,7 @@ discard block |
||
| 3 | 3 | } |
| 4 | 4 | |
| 5 | 5 | function create_csv_string($data) { |
| 6 | - if (!$fp = fopen('php://temp', 'w+')) { |
|
| 6 | + if ( ! $fp = fopen('php://temp', 'w+')) { |
|
| 7 | 7 | return FALSE; |
| 8 | 8 | } |
| 9 | 9 | foreach ($data as $line) { |
@@ -13,13 +13,13 @@ discard block |
||
| 13 | 13 | return stream_get_contents($fp); |
| 14 | 14 | } |
| 15 | 15 | |
| 16 | -function send_csv_mail ($csvData, $body, $to, $subject,$file_name) { |
|
| 16 | +function send_csv_mail($csvData, $body, $to, $subject, $file_name) { |
|
| 17 | 17 | //print_r($csvData); |
| 18 | 18 | $where = array('group_title' =>'email'); |
| 19 | 19 | $query = $this->CI->db_model->getSelect("*", "system", $where); |
| 20 | 20 | $query = $query->result_array(); |
| 21 | - foreach($query as $key=>$val){ |
|
| 22 | - $from=$val['value']; |
|
| 21 | + foreach ($query as $key=>$val) { |
|
| 22 | + $from = $val['value']; |
|
| 23 | 23 | } |
| 24 | 24 | $multipartSep = '-----'.md5(time()).'-----'; |
| 25 | 25 | $headers = array( |
@@ -51,7 +51,7 @@ discard block |
||
| 51 | 51 | "Alert Threshold"=>"user/user_alert_threshold/" |
| 52 | 52 | )) |
| 53 | 53 | ); |
| 54 | -define("CUSTOMEREDIT_ARRAY",serialize(array( |
|
| 54 | +define("CUSTOMEREDIT_ARRAY", serialize(array( |
|
| 55 | 55 | "Customer Profile"=>"accounts/customer_edit/", |
| 56 | 56 | "SIP Devices"=>"accounts/customer_sipdevices/", |
| 57 | 57 | "Opensips Device"=>"accounts/customer_opensips/", |
@@ -70,7 +70,7 @@ discard block |
||
| 70 | 70 | ) |
| 71 | 71 | )); |
| 72 | 72 | |
| 73 | -define("PROVIDEREDIT_ARRAY",serialize(array( |
|
| 73 | +define("PROVIDEREDIT_ARRAY", serialize(array( |
|
| 74 | 74 | "Provider Profile"=>"accounts/provider_edit/", |
| 75 | 75 | "SIP Devices"=>"accounts/provider_sipdevices/", |
| 76 | 76 | "Opensips Device"=>"accounts/provider_opensips/", |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | "Alert Threshold"=>"accounts/provider_alert_threshold/" |
| 89 | 89 | ) |
| 90 | 90 | )); |
| 91 | -define("RESELLEREDIT_ARRAY",serialize(array("Reseller Profile"=>"accounts/reseller_edit/", |
|
| 91 | +define("RESELLEREDIT_ARRAY", serialize(array("Reseller Profile"=>"accounts/reseller_edit/", |
|
| 92 | 92 | "DID"=>"accounts/reseller_dids/", |
| 93 | 93 | "Subscription"=>"accounts/reseller_subscription/", |
| 94 | 94 | "Invoice"=>"accounts/reseller_invoices/", |
@@ -100,15 +100,15 @@ discard block |
||
| 100 | 100 | "Emails"=>"accounts/reseller_emailhistory/", |
| 101 | 101 | "Alert Threshold"=>"accounts/reseller_alert_threshold/" |
| 102 | 102 | ))); |
| 103 | -define("PACKAGEEDIT_ARRAY", serialize( array( |
|
| 103 | +define("PACKAGEEDIT_ARRAY", serialize(array( |
|
| 104 | 104 | "Package Details"=>"package/package_edit/", |
| 105 | 105 | "Package Codes"=>"package/package_pattern_list/" |
| 106 | 106 | ))); |
| 107 | -define("CUSTOMERPROFILE_ARRAY",serialize(array( |
|
| 107 | +define("CUSTOMERPROFILE_ARRAY", serialize(array( |
|
| 108 | 108 | "My Profile"=>"user/user_myprofile/", |
| 109 | 109 | "Change Password"=>"user/user_change_password" |
| 110 | 110 | ))); |
| 111 | -define("DATABASE_DIRECTORY",FCPATH.'database_backup'.DIRECTORY_SEPARATOR); |
|
| 111 | +define("DATABASE_DIRECTORY", FCPATH.'database_backup'.DIRECTORY_SEPARATOR); |
|
| 112 | 112 | define('LOCALE_REQUEST_PARAM', 'lang'); |
| 113 | 113 | define('WEBSITE_DOMAIN', 'messages'); |
| 114 | 114 | |
@@ -1,6 +1,6 @@ |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -if (!defined('BASEPATH')) |
|
| 3 | +if ( ! defined('BASEPATH')) |
|
| 4 | 4 | exit('No direct script access allowed'); |
| 5 | 5 | |
| 6 | 6 | /* |
@@ -63,8 +63,8 @@ discard block |
||
| 63 | 63 | $this->db->insert("charges", $add_array); |
| 64 | 64 | $insert_id = $this->db->insert_id(); |
| 65 | 65 | $data = $this->db_model->getSelect("*", "accounts", array("pricelist_id" => $add_array['pricelist_id'])); |
| 66 | - if($data->num_rows > 0){ |
|
| 67 | - foreach ($data->result_array() as $key => $value){ |
|
| 66 | + if ($data->num_rows > 0) { |
|
| 67 | + foreach ($data->result_array() as $key => $value) { |
|
| 68 | 68 | $this->common->mail_to_users('add_subscription', $value); |
| 69 | 69 | } |
| 70 | 70 | } |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | $this->db->where("id", $id); |
| 89 | 89 | $this->db->update("charges", $data); |
| 90 | 90 | |
| 91 | - if($data['pricelist_id'] == 0){ |
|
| 91 | + if ($data['pricelist_id'] == 0) { |
|
| 92 | 92 | $this->db->where("charge_id", $id); |
| 93 | 93 | $this->db->delete("charge_to_account"); |
| 94 | 94 | } |
@@ -103,23 +103,23 @@ discard block |
||
| 103 | 103 | $data = $data->result_array(); |
| 104 | 104 | $data = $data[0]; |
| 105 | 105 | $data = $this->db_model->getSelect("*", "accounts", array("pricelist_id" => $data['pricelist_id'])); |
| 106 | - if($data->num_rows > 0){ |
|
| 107 | - foreach ($data->result_array() as $key => $value){ |
|
| 106 | + if ($data->num_rows > 0) { |
|
| 107 | + foreach ($data->result_array() as $key => $value) { |
|
| 108 | 108 | $this->common->mail_to_users('remove_subscription', $value); |
| 109 | 109 | } |
| 110 | 110 | } |
| 111 | 111 | return true; |
| 112 | 112 | } |
| 113 | 113 | |
| 114 | - function add_account_charges($pricelistid,$chargeid,$flag){ |
|
| 115 | - if($flag){ |
|
| 114 | + function add_account_charges($pricelistid, $chargeid, $flag) { |
|
| 115 | + if ($flag) { |
|
| 116 | 116 | $this->db->where("charge_id", $chargeid); |
| 117 | 117 | $this->db->delete("charge_to_account"); |
| 118 | 118 | } |
| 119 | 119 | $account = $this->db_model->getSelect("*", "accounts", array("pricelist_id"=>$pricelistid)); |
| 120 | - if($account->num_rows > 0){ |
|
| 121 | - foreach ($account->result_array() as $key => $value){ |
|
| 122 | - $charge_arr = array("charge_id"=>$chargeid,"accountid"=>$value['id'],"assign_date"=>gmdate("Y-m-d H:i:s")); |
|
| 120 | + if ($account->num_rows > 0) { |
|
| 121 | + foreach ($account->result_array() as $key => $value) { |
|
| 122 | + $charge_arr = array("charge_id"=>$chargeid, "accountid"=>$value['id'], "assign_date"=>gmdate("Y-m-d H:i:s")); |
|
| 123 | 123 | $this->db->insert("charge_to_account", $charge_arr); |
| 124 | 124 | } |
| 125 | 125 | } |
@@ -35,7 +35,7 @@ discard block |
||
| 35 | 35 | $this->load->model('charges_model'); |
| 36 | 36 | |
| 37 | 37 | if ($this->session->userdata('user_login') == FALSE) |
| 38 | - redirect(base_url() . '/astpp/login'); |
|
| 38 | + redirect(base_url().'/astpp/login'); |
|
| 39 | 39 | } |
| 40 | 40 | |
| 41 | 41 | function periodiccharges_add() { |
@@ -75,8 +75,8 @@ discard block |
||
| 75 | 75 | $add_array['charge'] = $this->common_model->add_calculate_currency($add_array['charge'], '', '', false, false); |
| 76 | 76 | $this->charges_model->edit_charge($add_array, $add_array['id']); |
| 77 | 77 | |
| 78 | - if($add_array['pricelist_id'] > 0){ |
|
| 79 | - $this->charges_model->add_account_charges($add_array['pricelist_id'],$add_array['id'],true); |
|
| 78 | + if ($add_array['pricelist_id'] > 0) { |
|
| 79 | + $this->charges_model->add_account_charges($add_array['pricelist_id'], $add_array['id'], true); |
|
| 80 | 80 | } |
| 81 | 81 | echo json_encode(array("SUCCESS"=> $add_array["description"]." subscription updated successfully!")); |
| 82 | 82 | exit; |
@@ -90,8 +90,8 @@ discard block |
||
| 90 | 90 | } else { |
| 91 | 91 | $add_array['charge'] = $this->common_model->add_calculate_currency($add_array['charge'], '', '', false, false); |
| 92 | 92 | $charge_id = $this->charges_model->add_charge($add_array); |
| 93 | - if($add_array['pricelist_id'] > 0 && $charge_id > 0){ |
|
| 94 | - $this->charges_model->add_account_charges($add_array['pricelist_id'],$charge_id,false); |
|
| 93 | + if ($add_array['pricelist_id'] > 0 && $charge_id > 0) { |
|
| 94 | + $this->charges_model->add_account_charges($add_array['pricelist_id'], $charge_id, false); |
|
| 95 | 95 | } |
| 96 | 96 | echo json_encode(array("SUCCESS"=> $add_array["description"]." subscription added successfully!")); |
| 97 | 97 | exit; |
@@ -104,7 +104,7 @@ discard block |
||
| 104 | 104 | function periodiccharges_delete($id) { |
| 105 | 105 | $this->charges_model->remove_charge($id); |
| 106 | 106 | $this->session->set_flashdata('astpp_notification', 'Subscription removed successfully!'); |
| 107 | - redirect(base_url() . 'charges/periodiccharges/'); |
|
| 107 | + redirect(base_url().'charges/periodiccharges/'); |
|
| 108 | 108 | } |
| 109 | 109 | |
| 110 | 110 | function periodiccharges_search() { |
@@ -120,7 +120,7 @@ discard block |
||
| 120 | 120 | $this->session->set_userdata('charges_list_search', $action); |
| 121 | 121 | } |
| 122 | 122 | if (@$ajax_search != 1) { |
| 123 | - redirect(base_url() . 'charges/periodiccharges/'); |
|
| 123 | + redirect(base_url().'charges/periodiccharges/'); |
|
| 124 | 124 | } |
| 125 | 125 | } |
| 126 | 126 | |
@@ -160,9 +160,9 @@ discard block |
||
| 160 | 160 | function periodiccharges_delete_multiple() { |
| 161 | 161 | $ids = $this->input->post("selected_ids", true); |
| 162 | 162 | $where = "id IN ($ids)"; |
| 163 | - $charge_where="charge_id IN(".$ids.")"; |
|
| 164 | - $this->db->delete('charge_to_account',$charge_where); |
|
| 165 | - echo $this->db->delete("charges",$where); |
|
| 163 | + $charge_where = "charge_id IN(".$ids.")"; |
|
| 164 | + $this->db->delete('charge_to_account', $charge_where); |
|
| 165 | + echo $this->db->delete("charges", $where); |
|
| 166 | 166 | } |
| 167 | 167 | function customer_charge_list($accountid, $accounttype) { |
| 168 | 168 | |
@@ -176,18 +176,18 @@ discard block |
||
| 176 | 176 | $where = array('accounts.id' => $accountid); |
| 177 | 177 | $order_type = 'id'; |
| 178 | 178 | $order_by = "ASC"; |
| 179 | - $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_subscription'); |
|
| 180 | - $like_str=!empty($instant_search) ? "(charges.description like '%$instant_search%' |
|
| 179 | + $instant_search = $this->session->userdata('left_panel_search_'.$accounttype.'_subscription'); |
|
| 180 | + $like_str = ! empty($instant_search) ? "(charges.description like '%$instant_search%' |
|
| 181 | 181 | OR charges.charge like '%$instant_search%' |
| 182 | 182 | OR charges.charge like '%$instant_search%' |
| 183 | 183 | )" |
| 184 | 184 | :null; |
| 185 | - if(!empty($like_str)) |
|
| 185 | + if ( ! empty($like_str)) |
|
| 186 | 186 | $this->db->where($like_str); |
| 187 | 187 | $count_all = $this->db_model->getCountWithJion($table, $select, $where, $jionTable, $jionCondition, $type); |
| 188 | 188 | $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
| 189 | 189 | $json_data = $paging_data["json_paging"]; |
| 190 | - if(!empty($like_str)) |
|
| 190 | + if ( ! empty($like_str)) |
|
| 191 | 191 | $this->db->where($like_str); |
| 192 | 192 | $account_charge_list = $this->db_model->getAllJionQuery($table, $select, $where, $jionTable, $jionCondition, $type, $paging_data["paging"]["page_no"], $paging_data["paging"]["start"], $order_by, $order_type, ""); |
| 193 | 193 | $grid_fields = json_decode($this->charges_form->build_charges_list_for_customer($accountid, $accounttype)); |
@@ -22,7 +22,7 @@ discard block |
||
| 22 | 22 | # along with this program. If not, see <http://www.gnu.org/licenses/>. |
| 23 | 23 | ############################################################################### |
| 24 | 24 | |
| 25 | -if (!defined('BASEPATH'))
|
|
| 25 | +if ( ! defined('BASEPATH'))
|
|
| 26 | 26 | exit('No direct script access allowed');
|
| 27 | 27 | |
| 28 | 28 | class Charges_form {
|
@@ -31,7 +31,7 @@ discard block |
||
| 31 | 31 | } |
| 32 | 32 | |
| 33 | 33 | function get_charge_form_fields() {
|
| 34 | - $form['forms'] = array(base_url() . 'charges/periodiccharges_save/', array('id' => 'charges_form', 'method' => 'POST', 'name' => 'charges_form'));
|
|
| 34 | + $form['forms'] = array(base_url().'charges/periodiccharges_save/', array('id' => 'charges_form', 'method' => 'POST', 'name' => 'charges_form'));
|
|
| 35 | 35 | $form['Information'] = array( |
| 36 | 36 | array('', 'HIDDEN', array('name' => 'id'), '', '', '', ''),
|
| 37 | 37 | array('Name', 'INPUT', array('name' => 'description', 'size' => '20', 'class' => "text field medium"), 'trim|required|xss_clean', 'tOOL TIP', 'Please Enter account number'),
|
@@ -52,13 +52,13 @@ discard block |
||
| 52 | 52 | $account_data = $this->CI->session->userdata("accountinfo");
|
| 53 | 53 | $loginid = $account_data['id']; |
| 54 | 54 | |
| 55 | - }else{
|
|
| 55 | + } else {
|
|
| 56 | 56 | $loginid = "0"; |
| 57 | 57 | } |
| 58 | 58 | $form['forms'] = array("", array('id' => "charges_search"));
|
| 59 | 59 | $form['Search'] = array( |
| 60 | 60 | array('Name', 'INPUT', array('name' => 'description[description]', '', 'size' => '20', 'class' => "text field"), '', 'tOOL TIP', '1', 'description[description-string]', '', '', '', 'search_string_type', ''),
|
| 61 | - array('Rate Group', 'pricelist_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array('status'=>0,'reseller_id'=>$loginid)),
|
|
| 61 | + array('Rate Group', 'pricelist_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array('status'=>0, 'reseller_id'=>$loginid)),
|
|
| 62 | 62 | array('Amount', 'INPUT', array('name' => 'charge[charge]', 'value' => '', 'size' => '20', 'class' => "text field"), '', 'Tool tips info', '1', 'charge[charge-integer]', '', '', '', 'search_int_type', ''),
|
| 63 | 63 | array('Billing Cycle', 'sweep_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'sweep', 'sweeplist', 'build_dropdown', '', ''),
|
| 64 | 64 | array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_search_status'),
|
@@ -77,28 +77,28 @@ discard block |
||
| 77 | 77 | function build_charge_list_for_admin() {
|
| 78 | 78 | |
| 79 | 79 | $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');
|
| 80 | - $currency_id=$account_info['currency_id']; |
|
| 81 | - $currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 80 | + $currency_id = $account_info['currency_id']; |
|
| 81 | + $currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 82 | 82 | |
| 83 | 83 | // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name); |
| 84 | - $grid_field_arr = json_encode(array(array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "","","false","center"),
|
|
| 84 | + $grid_field_arr = json_encode(array(array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center"),
|
|
| 85 | 85 | /** |
| 86 | 86 | ASTPP 3.0 |
| 87 | 87 | For DID edit on DID number |
| 88 | 88 | **/ |
| 89 | - array(gettext("Name"), "140", "description", "", "", "","EDITABLE","true","center"),
|
|
| 89 | + array(gettext("Name"), "140", "description", "", "", "", "EDITABLE", "true", "center"),
|
|
| 90 | 90 | /**************************************************/ |
| 91 | - array(gettext("Rate Group"), "140", "pricelist_id", "name", "pricelists", "get_field_name","","true","center"),
|
|
| 92 | - array("Amount($currency)", "125", "charge", "charge", "charge", "convert_to_currency","","true","right"),
|
|
| 93 | - array(gettext("Prorate"), "125", "pro_rate", "pro_rate", "charges", "get_prorate","","true","center"),
|
|
| 94 | - array(gettext("Billing Cycle"), "130", "sweep_id", "sweep", "sweeplist", "get_field_name","","true","center"),
|
|
| 91 | + array(gettext("Rate Group"), "140", "pricelist_id", "name", "pricelists", "get_field_name", "", "true", "center"),
|
|
| 92 | + array("Amount($currency)", "125", "charge", "charge", "charge", "convert_to_currency", "", "true", "right"),
|
|
| 93 | + array(gettext("Prorate"), "125", "pro_rate", "pro_rate", "charges", "get_prorate", "", "true", "center"),
|
|
| 94 | + array(gettext("Billing Cycle"), "130", "sweep_id", "sweep", "sweeplist", "get_field_name", "", "true", "center"),
|
|
| 95 | 95 | /** |
| 96 | 96 | ASTPP 3.0 |
| 97 | 97 | Show Creation date,last_modified date in reseller grid with admin login |
| 98 | 98 | **/ |
| 99 | - array(gettext("Status"), "125", "status", "status", "charges", "get_status","","true","center"),
|
|
| 100 | - array(gettext("Created Date"), "150", "creation_date", "", "", "","","true","center"),
|
|
| 101 | - array(gettext("Modified Date"), "150", "last_modified_date", "", "", "","","true","center"),
|
|
| 99 | + array(gettext("Status"), "125", "status", "status", "charges", "get_status", "", "true", "center"),
|
|
| 100 | + array(gettext("Created Date"), "150", "creation_date", "", "", "", "", "true", "center"),
|
|
| 101 | + array(gettext("Modified Date"), "150", "last_modified_date", "", "", "", "", "true", "center"),
|
|
| 102 | 102 | /************************************************/ |
| 103 | 103 | /* |
| 104 | 104 | ASTPP 3.0 |
@@ -114,8 +114,8 @@ discard block |
||
| 114 | 114 | /********************************************/ |
| 115 | 115 | |
| 116 | 116 | function build_grid_buttons() {
|
| 117 | - $buttons_json = json_encode(array(array("Create" , "btn btn-line-warning btn" , "fa fa-plus-circle fa-lg", "button_action", "/charges/periodiccharges_add/", "popup"),
|
|
| 118 | - array("Delete", "btn btn-line-danger","fa fa-times-circle fa-lg", "button_action", "/charges/periodiccharges_delete_multiple/")
|
|
| 117 | + $buttons_json = json_encode(array(array("Create", "btn btn-line-warning btn", "fa fa-plus-circle fa-lg", "button_action", "/charges/periodiccharges_add/", "popup"),
|
|
| 118 | + array("Delete", "btn btn-line-danger", "fa fa-times-circle fa-lg", "button_action", "/charges/periodiccharges_delete_multiple/")
|
|
| 119 | 119 | )); |
| 120 | 120 | return $buttons_json; |
| 121 | 121 | } |
@@ -123,15 +123,15 @@ discard block |
||
| 123 | 123 | function build_charges_list_for_customer($accountid, $accounttype) {
|
| 124 | 124 | |
| 125 | 125 | $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');
|
| 126 | - $currency_id=$account_info['currency_id']; |
|
| 127 | - $currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 126 | + $currency_id = $account_info['currency_id']; |
|
| 127 | + $currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 128 | 128 | |
| 129 | - $grid_field_arr = json_encode(array(array("Name", "140", "description", "", "", "","","true","center"),
|
|
| 130 | - array("Amount($currency)", "140", "charge", "charge", "charge", "convert_to_currency","","true","right"),
|
|
| 131 | - array("Prorate", "125", "pro_rate", "pro_rate", "charges", "get_prorate","","true","center"),
|
|
| 132 | - array("Billing Cycle", "170", "sweep_id", "sweep", "sweeplist", "get_field_name","","true","center"),
|
|
| 133 | - array("Created Date", "150", "creation_date", "", "", "","","true","center"),
|
|
| 134 | - array("Modified Date", "150", "last_modified_date", "", "", "","","true","center"),
|
|
| 129 | + $grid_field_arr = json_encode(array(array("Name", "140", "description", "", "", "", "", "true", "center"),
|
|
| 130 | + array("Amount($currency)", "140", "charge", "charge", "charge", "convert_to_currency", "", "true", "right"),
|
|
| 131 | + array("Prorate", "125", "pro_rate", "pro_rate", "charges", "get_prorate", "", "true", "center"),
|
|
| 132 | + array("Billing Cycle", "170", "sweep_id", "sweep", "sweeplist", "get_field_name", "", "true", "center"),
|
|
| 133 | + array("Created Date", "150", "creation_date", "", "", "", "", "true", "center"),
|
|
| 134 | + array("Modified Date", "150", "last_modified_date", "", "", "", "", "true", "center"),
|
|
| 135 | 135 | array("Action", "150", "", "", "", array("DELETE" => array("url" => "accounts/".$accounttype."_subscription_action/delete/$accountid/$accounttype/", "mode" => "single")))
|
| 136 | 136 | )); |
| 137 | 137 | return $grid_field_arr; |
@@ -28,24 +28,24 @@ discard block |
||
| 28 | 28 | parent::__construct(); |
| 29 | 29 | } |
| 30 | 30 | |
| 31 | - function get_resellersummary_report_list($flag, $start = 0, $limit = 0,$group_by, $select,$order, $export = false) { |
|
| 31 | + function get_resellersummary_report_list($flag, $start = 0, $limit = 0, $group_by, $select, $order, $export = false) { |
|
| 32 | 32 | |
| 33 | 33 | $this->db_model->build_search('summary_reseller_search'); |
| 34 | - $accountinfo=$this->session->userdata('accountinfo'); |
|
| 34 | + $accountinfo = $this->session->userdata('accountinfo'); |
|
| 35 | 35 | $reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0; |
| 36 | - $where['reseller_id']=$reseller_id; |
|
| 36 | + $where['reseller_id'] = $reseller_id; |
|
| 37 | 37 | if ($this->session->userdata('advance_search') != 1) { |
| 38 | - $where['callstart >=']=date('Y-m-d') . " 00:00:00"; |
|
| 39 | - $where['callstart <=']=date('Y-m-d') . " 23:59:59"; |
|
| 38 | + $where['callstart >='] = date('Y-m-d')." 00:00:00"; |
|
| 39 | + $where['callstart <='] = date('Y-m-d')." 23:59:59"; |
|
| 40 | 40 | } |
| 41 | 41 | $this->db->where($where); |
| 42 | - if(!empty($group_by)) |
|
| 42 | + if ( ! empty($group_by)) |
|
| 43 | 43 | $this->db->group_by($group_by); |
| 44 | 44 | if ($flag) { |
| 45 | 45 | if ($export) { |
| 46 | - $result = $this->db_model->select($select . ",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(debit) AS debit,SUM(cost) AS cost", "reseller_cdrs", '', $order, 'asc', '', '', ''); |
|
| 46 | + $result = $this->db_model->select($select.",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(debit) AS debit,SUM(cost) AS cost", "reseller_cdrs", '', $order, 'asc', '', '', ''); |
|
| 47 | 47 | } else { |
| 48 | - $result = $this->db_model->select($select . ",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(debit) AS debit,SUM(cost) AS cost", "reseller_cdrs", '', $order, 'asc', $limit, $start, ''); |
|
| 48 | + $result = $this->db_model->select($select.",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(debit) AS debit,SUM(cost) AS cost", "reseller_cdrs", '', $order, 'asc', $limit, $start, ''); |
|
| 49 | 49 | } |
| 50 | 50 | } else { |
| 51 | 51 | $result = $this->db_model->getSelect("count(*) as total_count", "reseller_cdrs", ''); |
@@ -58,21 +58,21 @@ discard block |
||
| 58 | 58 | return $result; |
| 59 | 59 | } |
| 60 | 60 | |
| 61 | - function get_providersummary_report_list($flag, $start = 0, $limit = 0, $group_by, $select,$order, $export = false) { |
|
| 61 | + function get_providersummary_report_list($flag, $start = 0, $limit = 0, $group_by, $select, $order, $export = false) { |
|
| 62 | 62 | $this->db_model->build_search('summary_provider_search'); |
| 63 | - $where['provider_id >']=0; |
|
| 63 | + $where['provider_id >'] = 0; |
|
| 64 | 64 | if ($this->session->userdata('advance_search') != 1) { |
| 65 | - $where['callstart >=']=date('Y-m-d') . " 00:00:00"; |
|
| 66 | - $where['callstart <=']=date('Y-m-d') . " 23:59:59"; |
|
| 65 | + $where['callstart >='] = date('Y-m-d')." 00:00:00"; |
|
| 66 | + $where['callstart <='] = date('Y-m-d')." 23:59:59"; |
|
| 67 | 67 | } |
| 68 | 68 | $this->db->where($where); |
| 69 | - if(!empty($group_by)) |
|
| 69 | + if ( ! empty($group_by)) |
|
| 70 | 70 | $this->db->group_by($group_by); |
| 71 | 71 | if ($flag) { |
| 72 | 72 | if ($export) { |
| 73 | - $result = $this->db_model->select($select . ",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(cost) AS cost", "cdrs", '', $order, 'asc', '', '', ''); |
|
| 73 | + $result = $this->db_model->select($select.",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(cost) AS cost", "cdrs", '', $order, 'asc', '', '', ''); |
|
| 74 | 74 | } else { |
| 75 | - $result = $this->db_model->select($select . ",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(cost) AS cost", "cdrs", '', $order, 'asc', $limit, $start, ''); |
|
| 75 | + $result = $this->db_model->select($select.",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(cost) AS cost", "cdrs", '', $order, 'asc', $limit, $start, ''); |
|
| 76 | 76 | } |
| 77 | 77 | } else { |
| 78 | 78 | $result = $this->db_model->getSelect("count(*) as total_count", "cdrs", ''); |
@@ -85,24 +85,24 @@ discard block |
||
| 85 | 85 | return $result; |
| 86 | 86 | } |
| 87 | 87 | |
| 88 | - function get_customersummary_report_list($flag, $start = 0, $limit = 0, $group_by, $select,$order, $export) { |
|
| 88 | + function get_customersummary_report_list($flag, $start = 0, $limit = 0, $group_by, $select, $order, $export) { |
|
| 89 | 89 | $this->db_model->build_search('summary_customer_search'); |
| 90 | - $accountinfo=$this->session->userdata('accountinfo'); |
|
| 90 | + $accountinfo = $this->session->userdata('accountinfo'); |
|
| 91 | 91 | $reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0; |
| 92 | - $where['reseller_id']=$reseller_id; |
|
| 93 | - $where['type']=0; |
|
| 92 | + $where['reseller_id'] = $reseller_id; |
|
| 93 | + $where['type'] = 0; |
|
| 94 | 94 | if ($this->session->userdata('advance_search') != 1) { |
| 95 | - $where['callstart >=']=date('Y-m-d') . " 00:00:00"; |
|
| 96 | - $where['callstart <=']=date('Y-m-d') . " 23:59:59"; |
|
| 95 | + $where['callstart >='] = date('Y-m-d')." 00:00:00"; |
|
| 96 | + $where['callstart <='] = date('Y-m-d')." 23:59:59"; |
|
| 97 | 97 | } |
| 98 | 98 | $this->db->where($where); |
| 99 | - if(!empty($group_by)) |
|
| 99 | + if ( ! empty($group_by)) |
|
| 100 | 100 | $this->db->group_by($group_by); |
| 101 | 101 | if ($flag) { |
| 102 | 102 | if ($export) { |
| 103 | - $result = $this->db_model->select($select . ",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(debit) AS debit,SUM(cost) AS cost", "cdrs", '', $order, 'asc', '', '', ''); |
|
| 103 | + $result = $this->db_model->select($select.",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(debit) AS debit,SUM(cost) AS cost", "cdrs", '', $order, 'asc', '', '', ''); |
|
| 104 | 104 | } else { |
| 105 | - $result = $this->db_model->select($select . ",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(debit) AS debit,SUM(cost) AS cost", "cdrs", '', $order, 'asc', $limit, $start, ''); |
|
| 105 | + $result = $this->db_model->select($select.",COUNT(*) AS attempts, AVG(billseconds) AS acd,MAX(billseconds) AS mcd,SUM(billseconds) AS duration,SUM(CASE WHEN calltype !='free' THEN billseconds ELSE 0 END) as billable,SUM(CASE WHEN billseconds > 0 THEN 1 ELSE 0 END) as completed,SUM(debit) AS debit,SUM(cost) AS cost", "cdrs", '', $order, 'asc', $limit, $start, ''); |
|
| 106 | 106 | } |
| 107 | 107 | } else { |
| 108 | 108 | $result = $this->db_model->getSelect("count(*) as total_count", "cdrs", ''); |