@@ -51,7 +51,7 @@ |
||
| 51 | 51 | } |
| 52 | 52 | $data_errrors = json_decode($validation_errors); |
| 53 | 53 | foreach ($data_errrors as $key => $value) { |
| 54 | - echo $value . "<br/>"; |
|
| 54 | + echo $value."<br/>"; |
|
| 55 | 55 | } |
| 56 | 56 | ?> |
| 57 | 57 | </div> |
@@ -28,7 +28,7 @@ |
||
| 28 | 28 | <!-- <?php |
| 29 | 29 | $data_errrors = json_decode($validation_errors); |
| 30 | 30 | foreach ($data_errrors as $key => $value) { |
| 31 | - echo $value . "<br/>"; |
|
| 31 | + echo $value."<br/>"; |
|
| 32 | 32 | } |
| 33 | 33 | ?> |
| 34 | 34 | </div> |
@@ -122,236 +122,236 @@ |
||
| 122 | 122 | $this->db_model->build_search('origination_rate_list_search'); |
| 123 | 123 | /***********************/ |
| 124 | 124 | |
| 125 | - if ($flag) { |
|
| 126 | - $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 127 | - } else { |
|
| 128 | - $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 125 | + if ($flag) { |
|
| 126 | + $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 127 | + } else { |
|
| 128 | + $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 129 | 129 | |
| 130 | - } |
|
| 131 | - //echo $this->db->last_query(); |
|
| 132 | - return $query; |
|
| 133 | - } |
|
| 134 | - function getunblocked_pattern_list($accountid, $flag, $start = 0, $limit = 0) { |
|
| 135 | - $this->db_model->build_search('origination_rate_list_search'); |
|
| 136 | - if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 137 | - $account_data = $this->session->userdata("accountinfo"); |
|
| 138 | - $reseller = $account_data['id']; |
|
| 139 | - $where = array("reseller_id" => $reseller, "status" => "0"); |
|
| 140 | - } else { |
|
| 141 | - $where = array("status" => "0", 'reseller_id'=>'0'); |
|
| 142 | - } |
|
| 143 | - $where1 = '(pattern NOT IN (select blocked_patterns from block_patterns where accountid = "'.$accountid.'"))'; |
|
| 144 | - $this->db->where($where1); |
|
| 145 | - if ($flag) { |
|
| 146 | - $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 130 | + } |
|
| 131 | + //echo $this->db->last_query(); |
|
| 132 | + return $query; |
|
| 133 | + } |
|
| 134 | + function getunblocked_pattern_list($accountid, $flag, $start = 0, $limit = 0) { |
|
| 135 | + $this->db_model->build_search('origination_rate_list_search'); |
|
| 136 | + if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 137 | + $account_data = $this->session->userdata("accountinfo"); |
|
| 138 | + $reseller = $account_data['id']; |
|
| 139 | + $where = array("reseller_id" => $reseller, "status" => "0"); |
|
| 140 | + } else { |
|
| 141 | + $where = array("status" => "0", 'reseller_id'=>'0'); |
|
| 142 | + } |
|
| 143 | + $where1 = '(pattern NOT IN (select blocked_patterns from block_patterns where accountid = "'.$accountid.'"))'; |
|
| 144 | + $this->db->where($where1); |
|
| 145 | + if ($flag) { |
|
| 146 | + $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 147 | 147 | // echo "<pre>"; print_r($query); exit; |
| 148 | - } else { |
|
| 149 | - $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 150 | - } |
|
| 151 | - return $query; |
|
| 152 | - } |
|
| 153 | - function getunblocked_package_pattern($accountid, $flag, $start = 0, $limit = 0) { |
|
| 154 | - $this->db_model->build_search('origination_rate_list_search'); |
|
| 155 | - if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 156 | - $account_data = $this->session->userdata("accountinfo"); |
|
| 157 | - $reseller = $account_data['id']; |
|
| 158 | - $where = array("reseller_id" => $reseller, "status" => "0"); |
|
| 159 | - } else { |
|
| 160 | - $where = array("status" => "0", 'reseller_id'=>'0'); |
|
| 161 | - } |
|
| 162 | - $where1 = '(pattern NOT IN (select DISTINCT patterns from package_patterns where package_id = "'.$accountid.'"))'; |
|
| 163 | - $this->db->where($where1); |
|
| 164 | - if ($flag) { |
|
| 165 | - $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 166 | - } else { |
|
| 167 | - $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 168 | - } |
|
| 169 | - return $query; |
|
| 170 | - } |
|
| 148 | + } else { |
|
| 149 | + $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 150 | + } |
|
| 151 | + return $query; |
|
| 152 | + } |
|
| 153 | + function getunblocked_package_pattern($accountid, $flag, $start = 0, $limit = 0) { |
|
| 154 | + $this->db_model->build_search('origination_rate_list_search'); |
|
| 155 | + if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 156 | + $account_data = $this->session->userdata("accountinfo"); |
|
| 157 | + $reseller = $account_data['id']; |
|
| 158 | + $where = array("reseller_id" => $reseller, "status" => "0"); |
|
| 159 | + } else { |
|
| 160 | + $where = array("status" => "0", 'reseller_id'=>'0'); |
|
| 161 | + } |
|
| 162 | + $where1 = '(pattern NOT IN (select DISTINCT patterns from package_patterns where package_id = "'.$accountid.'"))'; |
|
| 163 | + $this->db->where($where1); |
|
| 164 | + if ($flag) { |
|
| 165 | + $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 166 | + } else { |
|
| 167 | + $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 168 | + } |
|
| 169 | + return $query; |
|
| 170 | + } |
|
| 171 | 171 | |
| 172 | - function get_origination_rate_list_for_user($flag, $start = 0, $limit = 0) { |
|
| 173 | - $this->db_model->build_search('user_rates_list_search'); |
|
| 172 | + function get_origination_rate_list_for_user($flag, $start = 0, $limit = 0) { |
|
| 173 | + $this->db_model->build_search('user_rates_list_search'); |
|
| 174 | 174 | |
| 175 | - $account_data = $this->session->userdata("accountinfo"); |
|
| 176 | - $where = array("pricelist_id" => $account_data["pricelist_id"], "status" => '0'); |
|
| 175 | + $account_data = $this->session->userdata("accountinfo"); |
|
| 176 | + $where = array("pricelist_id" => $account_data["pricelist_id"], "status" => '0'); |
|
| 177 | 177 | |
| 178 | - $this->db_model->build_search('origination_rate_list_search'); |
|
| 179 | - if ($flag) { |
|
| 180 | - $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 181 | - } else { |
|
| 182 | - $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 183 | - } |
|
| 184 | - return $query; |
|
| 185 | - } |
|
| 178 | + $this->db_model->build_search('origination_rate_list_search'); |
|
| 179 | + if ($flag) { |
|
| 180 | + $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 181 | + } else { |
|
| 182 | + $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 183 | + } |
|
| 184 | + return $query; |
|
| 185 | + } |
|
| 186 | 186 | |
| 187 | 187 | |
| 188 | - function add_termination_rate($add_array) { |
|
| 189 | - unset($add_array["action"]); |
|
| 190 | - if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 191 | - $account_data = $this->session->userdata("accountinfo"); |
|
| 192 | - $reseller = $account_data['id']; |
|
| 193 | - $add_array['reseller_id'] = $reseller; |
|
| 194 | - } |
|
| 195 | - $add_array['pattern'] = "^".$add_array['pattern'].".*"; |
|
| 196 | - $add_array['prepend'] = $add_array['prepend']; |
|
| 197 | - /* |
|
| 188 | + function add_termination_rate($add_array) { |
|
| 189 | + unset($add_array["action"]); |
|
| 190 | + if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 191 | + $account_data = $this->session->userdata("accountinfo"); |
|
| 192 | + $reseller = $account_data['id']; |
|
| 193 | + $add_array['reseller_id'] = $reseller; |
|
| 194 | + } |
|
| 195 | + $add_array['pattern'] = "^".$add_array['pattern'].".*"; |
|
| 196 | + $add_array['prepend'] = $add_array['prepend']; |
|
| 197 | + /* |
|
| 198 | 198 | ASTPP 3.0 |
| 199 | 199 | add creation date. |
| 200 | 200 | */ |
| 201 | - $add_array['creation_date'] = gmdate('Y-m-d H:i:s'); |
|
| 202 | - /*******************************************************/ |
|
| 203 | - $this->insert_if_not_exitst($add_array, "outbound_routes"); |
|
| 204 | - //$this->db->insert("outbound_routes", $add_array); |
|
| 205 | - return true; |
|
| 206 | - } |
|
| 201 | + $add_array['creation_date'] = gmdate('Y-m-d H:i:s'); |
|
| 202 | + /*******************************************************/ |
|
| 203 | + $this->insert_if_not_exitst($add_array, "outbound_routes"); |
|
| 204 | + //$this->db->insert("outbound_routes", $add_array); |
|
| 205 | + return true; |
|
| 206 | + } |
|
| 207 | 207 | |
| 208 | - function edit_termination_rate($data, $id) { |
|
| 209 | - unset($data["action"]); |
|
| 210 | - /* |
|
| 208 | + function edit_termination_rate($data, $id) { |
|
| 209 | + unset($data["action"]); |
|
| 210 | + /* |
|
| 211 | 211 | ASTPP 3.0 |
| 212 | 212 | Edit time last modified date |
| 213 | 213 | */ |
| 214 | - $data['last_modified_date'] = gmdate('Y-m-d H:i:s'); |
|
| 215 | - /***************************************************/ |
|
| 216 | - $data['pattern'] = "^".$data['pattern'].".*"; |
|
| 217 | - $this->db->where("id", $id); |
|
| 218 | - $this->db->update("outbound_routes", $data); |
|
| 219 | - } |
|
| 214 | + $data['last_modified_date'] = gmdate('Y-m-d H:i:s'); |
|
| 215 | + /***************************************************/ |
|
| 216 | + $data['pattern'] = "^".$data['pattern'].".*"; |
|
| 217 | + $this->db->where("id", $id); |
|
| 218 | + $this->db->update("outbound_routes", $data); |
|
| 219 | + } |
|
| 220 | 220 | |
| 221 | - function remove_termination_rate($id) { |
|
| 222 | - $this->db->where("id", $id); |
|
| 223 | - $this->db->delete("outbound_routes"); |
|
| 224 | - return true; |
|
| 225 | - } |
|
| 221 | + function remove_termination_rate($id) { |
|
| 222 | + $this->db->where("id", $id); |
|
| 223 | + $this->db->delete("outbound_routes"); |
|
| 224 | + return true; |
|
| 225 | + } |
|
| 226 | 226 | |
| 227 | - function add_origination_rate($add_array) { |
|
| 227 | + function add_origination_rate($add_array) { |
|
| 228 | 228 | |
| 229 | - unset($add_array["action"]); |
|
| 230 | - /* |
|
| 229 | + unset($add_array["action"]); |
|
| 230 | + /* |
|
| 231 | 231 | ASTPP 3.0 |
| 232 | 232 | ADD time put creation date in routes table |
| 233 | 233 | */ |
| 234 | - $add_array['creation_date'] = gmdate('Y-m-d H:i:s'); |
|
| 235 | - /**********************************************/ |
|
| 236 | - if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 237 | - $account_data = $this->session->userdata("accountinfo"); |
|
| 238 | - $reseller = $account_data['id']; |
|
| 239 | - $add_array['reseller_id'] = $reseller; |
|
| 240 | - } |
|
| 234 | + $add_array['creation_date'] = gmdate('Y-m-d H:i:s'); |
|
| 235 | + /**********************************************/ |
|
| 236 | + if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 237 | + $account_data = $this->session->userdata("accountinfo"); |
|
| 238 | + $reseller = $account_data['id']; |
|
| 239 | + $add_array['reseller_id'] = $reseller; |
|
| 240 | + } |
|
| 241 | 241 | |
| 242 | - $add_array['pattern'] = "^".$add_array['pattern'].".*"; |
|
| 242 | + $add_array['pattern'] = "^".$add_array['pattern'].".*"; |
|
| 243 | 243 | /************* |
| 244 | 244 | ASTPP 3.0 |
| 245 | 245 | Rate insert |
| 246 | 246 | *************/ |
| 247 | - $this->insert_if_not_exitst($add_array, "routes"); |
|
| 247 | + $this->insert_if_not_exitst($add_array, "routes"); |
|
| 248 | 248 | // $this->db->insert("routes", $add_array); |
| 249 | 249 | /*******************************/ |
| 250 | - return true; |
|
| 251 | - } |
|
| 250 | + return true; |
|
| 251 | + } |
|
| 252 | 252 | |
| 253 | - function edit_origination_rate($data, $id) { |
|
| 254 | - unset($data["action"]); |
|
| 255 | - /* |
|
| 253 | + function edit_origination_rate($data, $id) { |
|
| 254 | + unset($data["action"]); |
|
| 255 | + /* |
|
| 256 | 256 | ASTPP 3.0 |
| 257 | 257 | Edit tile last modified date update |
| 258 | 258 | */ |
| 259 | - $data['last_modified_date'] = gmdate('Y-m-d H:i:s'); |
|
| 260 | - /********************************************************/ |
|
| 261 | - $data['pattern'] = "^".$data['pattern'].".*"; |
|
| 262 | - $this->db->where("id", $id); |
|
| 263 | - $this->db->update("routes", $data); |
|
| 264 | - } |
|
| 259 | + $data['last_modified_date'] = gmdate('Y-m-d H:i:s'); |
|
| 260 | + /********************************************************/ |
|
| 261 | + $data['pattern'] = "^".$data['pattern'].".*"; |
|
| 262 | + $this->db->where("id", $id); |
|
| 263 | + $this->db->update("routes", $data); |
|
| 264 | + } |
|
| 265 | 265 | |
| 266 | - function remove_origination_rate($id) { |
|
| 267 | - $this->db->where("id", $id); |
|
| 268 | - $this->db->delete("routes"); |
|
| 269 | - return true; |
|
| 270 | - } |
|
| 266 | + function remove_origination_rate($id) { |
|
| 267 | + $this->db->where("id", $id); |
|
| 268 | + $this->db->delete("routes"); |
|
| 269 | + return true; |
|
| 270 | + } |
|
| 271 | 271 | |
| 272 | - function get_trunk_name($field_value) { |
|
| 273 | - $this->db->where("name", $field_value); |
|
| 274 | - $query = $this->db->get('trunks'); |
|
| 275 | - $data = $query->result(); |
|
| 276 | - if ($query->num_rows > 0) { |
|
| 277 | - return $data[0]->id; |
|
| 278 | - } else { |
|
| 279 | - return ''; |
|
| 280 | - } |
|
| 281 | - } |
|
| 272 | + function get_trunk_name($field_value) { |
|
| 273 | + $this->db->where("name", $field_value); |
|
| 274 | + $query = $this->db->get('trunks'); |
|
| 275 | + $data = $query->result(); |
|
| 276 | + if ($query->num_rows > 0) { |
|
| 277 | + return $data[0]->id; |
|
| 278 | + } else { |
|
| 279 | + return ''; |
|
| 280 | + } |
|
| 281 | + } |
|
| 282 | 282 | |
| 283 | - function bulk_insert_termination_rate($field_value) { |
|
| 284 | - //$this->db->insert_batch('outbound_routes', $field_value); |
|
| 285 | - $this->db->insert_on_duplicate_update_batch('outbound_routes', $field_value); |
|
| 286 | - $affected_row = $this->db->affected_rows(); |
|
| 287 | - return $affected_row; |
|
| 288 | - } |
|
| 283 | + function bulk_insert_termination_rate($field_value) { |
|
| 284 | + //$this->db->insert_batch('outbound_routes', $field_value); |
|
| 285 | + $this->db->insert_on_duplicate_update_batch('outbound_routes', $field_value); |
|
| 286 | + $affected_row = $this->db->affected_rows(); |
|
| 287 | + return $affected_row; |
|
| 288 | + } |
|
| 289 | 289 | |
| 290 | - function bulk_insert_origination_rate($inserted_array) { |
|
| 291 | - //$this->db->insert_batch('routes', $inserted_array); |
|
| 292 | - $this->db->insert_on_duplicate_update_batch('routes', $inserted_array); |
|
| 293 | - $affected_row = $this->db->affected_rows(); |
|
| 294 | - return $affected_row; |
|
| 295 | - } |
|
| 296 | - function termination_rate_batch_update($update_array) { |
|
| 297 | - $this->db_model->build_search('termination_rates_list_search'); |
|
| 298 | - if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 299 | - $account_data = $this->session->userdata("accountinfo"); |
|
| 300 | - $this->db->where("reseller_id", $account_data['id']); |
|
| 301 | - } |
|
| 290 | + function bulk_insert_origination_rate($inserted_array) { |
|
| 291 | + //$this->db->insert_batch('routes', $inserted_array); |
|
| 292 | + $this->db->insert_on_duplicate_update_batch('routes', $inserted_array); |
|
| 293 | + $affected_row = $this->db->affected_rows(); |
|
| 294 | + return $affected_row; |
|
| 295 | + } |
|
| 296 | + function termination_rate_batch_update($update_array) { |
|
| 297 | + $this->db_model->build_search('termination_rates_list_search'); |
|
| 298 | + if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 299 | + $account_data = $this->session->userdata("accountinfo"); |
|
| 300 | + $this->db->where("reseller_id", $account_data['id']); |
|
| 301 | + } |
|
| 302 | 302 | |
| 303 | - $updateflg = $this->db_model->build_batch_update_array($update_array); |
|
| 304 | - if ($updateflg) |
|
| 305 | - return $this->db->update("outbound_routes"); |
|
| 306 | - else |
|
| 307 | - return false; |
|
| 308 | - } |
|
| 309 | - function origination_rate_batch_update($update_array) { |
|
| 310 | - $this->db_model->build_search('origination_rate_list_search'); |
|
| 311 | - if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 312 | - $account_data = $this->session->userdata("accountinfo"); |
|
| 313 | - $this->db->where("reseller_id", $account_data['id']); |
|
| 314 | - } |
|
| 315 | - $updateflg = $this->db_model->build_batch_update_array($update_array); |
|
| 316 | - if ($updateflg) |
|
| 317 | - return $this->db->update("routes"); |
|
| 318 | - else |
|
| 319 | - return false; |
|
| 320 | - } |
|
| 321 | - function getreseller_rates_list($flag, $start = 0, $limit = 0, $export = false) { |
|
| 322 | - $this->db_model->build_search('resellerrates_list_search'); |
|
| 323 | - $account_data = $this->session->userdata("accountinfo"); |
|
| 324 | - $where = array("status"=>"0", "pricelist_id" => $account_data["pricelist_id"]); |
|
| 325 | - if ($flag) { |
|
| 326 | - $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 327 | - } else { |
|
| 328 | - $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 329 | - } |
|
| 330 | - return $query; |
|
| 331 | - } |
|
| 303 | + $updateflg = $this->db_model->build_batch_update_array($update_array); |
|
| 304 | + if ($updateflg) |
|
| 305 | + return $this->db->update("outbound_routes"); |
|
| 306 | + else |
|
| 307 | + return false; |
|
| 308 | + } |
|
| 309 | + function origination_rate_batch_update($update_array) { |
|
| 310 | + $this->db_model->build_search('origination_rate_list_search'); |
|
| 311 | + if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
|
| 312 | + $account_data = $this->session->userdata("accountinfo"); |
|
| 313 | + $this->db->where("reseller_id", $account_data['id']); |
|
| 314 | + } |
|
| 315 | + $updateflg = $this->db_model->build_batch_update_array($update_array); |
|
| 316 | + if ($updateflg) |
|
| 317 | + return $this->db->update("routes"); |
|
| 318 | + else |
|
| 319 | + return false; |
|
| 320 | + } |
|
| 321 | + function getreseller_rates_list($flag, $start = 0, $limit = 0, $export = false) { |
|
| 322 | + $this->db_model->build_search('resellerrates_list_search'); |
|
| 323 | + $account_data = $this->session->userdata("accountinfo"); |
|
| 324 | + $where = array("status"=>"0", "pricelist_id" => $account_data["pricelist_id"]); |
|
| 325 | + if ($flag) { |
|
| 326 | + $query = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
|
| 327 | + } else { |
|
| 328 | + $query = $this->db_model->countQuery("*", "routes", $where); |
|
| 329 | + } |
|
| 330 | + return $query; |
|
| 331 | + } |
|
| 332 | 332 | /************* |
| 333 | 333 | ASTPP 3.0 |
| 334 | 334 | Rate insert |
| 335 | 335 | *************/ |
| 336 | - /** |
|
| 337 | - * @param string $table_name |
|
| 338 | - */ |
|
| 339 | - function insert_if_not_exitst($add_array,$table_name){ |
|
| 340 | - $insert_str = "Insert into $table_name ("; |
|
| 341 | - $insert_key = ""; |
|
| 342 | - $insert_value = ""; |
|
| 343 | - $update_str = ""; |
|
| 344 | - foreach($add_array as $key => $value){ |
|
| 345 | - if($key != 'id'){ |
|
| 346 | - $insert_key .= $key.","; |
|
| 347 | - $insert_value .= "'$value',"; |
|
| 348 | - $update_str .= $key." = '$value',"; |
|
| 349 | - } |
|
| 350 | - } |
|
| 351 | - $insert_key = rtrim($insert_key,","); |
|
| 352 | - $insert_value = rtrim($insert_value,","); |
|
| 353 | - $update_str = rtrim($update_str,","); |
|
| 354 | - $insert_str .= $insert_key.") values"."(".$insert_value.") ON DUPLICATE KEY UPDATE $update_str"; |
|
| 355 | - $this->db->query($insert_str); |
|
| 356 | - } |
|
| 336 | + /** |
|
| 337 | + * @param string $table_name |
|
| 338 | + */ |
|
| 339 | + function insert_if_not_exitst($add_array,$table_name){ |
|
| 340 | + $insert_str = "Insert into $table_name ("; |
|
| 341 | + $insert_key = ""; |
|
| 342 | + $insert_value = ""; |
|
| 343 | + $update_str = ""; |
|
| 344 | + foreach($add_array as $key => $value){ |
|
| 345 | + if($key != 'id'){ |
|
| 346 | + $insert_key .= $key.","; |
|
| 347 | + $insert_value .= "'$value',"; |
|
| 348 | + $update_str .= $key." = '$value',"; |
|
| 349 | + } |
|
| 350 | + } |
|
| 351 | + $insert_key = rtrim($insert_key,","); |
|
| 352 | + $insert_value = rtrim($insert_value,","); |
|
| 353 | + $update_str = rtrim($update_str,","); |
|
| 354 | + $insert_str .= $insert_key.") values"."(".$insert_value.") ON DUPLICATE KEY UPDATE $update_str"; |
|
| 355 | + $this->db->query($insert_str); |
|
| 356 | + } |
|
| 357 | 357 | } |
@@ -32,10 +32,10 @@ discard block |
||
| 32 | 32 | ASTPP 3.0 |
| 33 | 33 | Batch Delete |
| 34 | 34 | ********/ |
| 35 | - if($this->session->userdata('advance_batch_delete') == 1){ |
|
| 35 | + if ($this->session->userdata('advance_batch_delete') == 1) { |
|
| 36 | 36 | $this->db->where(array("trunk_id >"=>"0")); |
| 37 | 37 | $this->db->delete("outbound_routes"); |
| 38 | - $this->session->set_userdata('advance_batch_delete','0'); |
|
| 38 | + $this->session->set_userdata('advance_batch_delete', '0'); |
|
| 39 | 39 | $this->session->unset_userdata('advance_batch_delete'); |
| 40 | 40 | } |
| 41 | 41 | /**************/ |
@@ -53,7 +53,7 @@ discard block |
||
| 53 | 53 | if ($export) |
| 54 | 54 | $this->db->limit($limit, $start); |
| 55 | 55 | $result = $this->db->get(); |
| 56 | - }else { |
|
| 56 | + } else { |
|
| 57 | 57 | $result = $this->db->count_all_results(); |
| 58 | 58 | } |
| 59 | 59 | return $result; |
@@ -74,14 +74,14 @@ discard block |
||
| 74 | 74 | if ($export) |
| 75 | 75 | $this->db->limit($limit, $start); |
| 76 | 76 | $result = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
| 77 | - }else { |
|
| 77 | + } else { |
|
| 78 | 78 | $result = $this->db_model->countQuery("*", "routes", $where); |
| 79 | 79 | } |
| 80 | 80 | // echo "<pre>";print_r($result->result());exit; |
| 81 | 81 | return $result; |
| 82 | 82 | } |
| 83 | 83 | |
| 84 | - function get_origination_rate_for_user($flag, $start = 0, $limit = 0,$export = true) { |
|
| 84 | + function get_origination_rate_for_user($flag, $start = 0, $limit = 0, $export = true) { |
|
| 85 | 85 | $this->db_model->build_search('origination_rate_list_search'); |
| 86 | 86 | |
| 87 | 87 | $account_data = $this->session->userdata("accountinfo"); |
@@ -93,7 +93,7 @@ discard block |
||
| 93 | 93 | if ($export) |
| 94 | 94 | $this->db->limit($limit, $start); |
| 95 | 95 | $result = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
| 96 | - }else { |
|
| 96 | + } else { |
|
| 97 | 97 | $result = $this->db_model->countQuery("*", "routes", $where); |
| 98 | 98 | } |
| 99 | 99 | return $result; |
@@ -111,11 +111,11 @@ discard block |
||
| 111 | 111 | ASTPP 3.0 |
| 112 | 112 | Batch delete |
| 113 | 113 | ************/ |
| 114 | - if($this->session->userdata('advance_batch_delete') == 1){ |
|
| 114 | + if ($this->session->userdata('advance_batch_delete') == 1) { |
|
| 115 | 115 | $this->db->where($where); |
| 116 | 116 | $this->db->delete("routes"); |
| 117 | 117 | //echo $this->db->last_query(); exit; |
| 118 | - $this->session->set_userdata('advance_batch_delete','0'); |
|
| 118 | + $this->session->set_userdata('advance_batch_delete', '0'); |
|
| 119 | 119 | $this->session->unset_userdata('advance_batch_delete'); |
| 120 | 120 | |
| 121 | 121 | } |
@@ -336,21 +336,21 @@ discard block |
||
| 336 | 336 | /** |
| 337 | 337 | * @param string $table_name |
| 338 | 338 | */ |
| 339 | - function insert_if_not_exitst($add_array,$table_name){ |
|
| 339 | + function insert_if_not_exitst($add_array, $table_name) { |
|
| 340 | 340 | $insert_str = "Insert into $table_name ("; |
| 341 | 341 | $insert_key = ""; |
| 342 | 342 | $insert_value = ""; |
| 343 | 343 | $update_str = ""; |
| 344 | - foreach($add_array as $key => $value){ |
|
| 345 | - if($key != 'id'){ |
|
| 344 | + foreach ($add_array as $key => $value) { |
|
| 345 | + if ($key != 'id') { |
|
| 346 | 346 | $insert_key .= $key.","; |
| 347 | 347 | $insert_value .= "'$value',"; |
| 348 | 348 | $update_str .= $key." = '$value',"; |
| 349 | 349 | } |
| 350 | 350 | } |
| 351 | - $insert_key = rtrim($insert_key,","); |
|
| 352 | - $insert_value = rtrim($insert_value,","); |
|
| 353 | - $update_str = rtrim($update_str,","); |
|
| 351 | + $insert_key = rtrim($insert_key, ","); |
|
| 352 | + $insert_value = rtrim($insert_value, ","); |
|
| 353 | + $update_str = rtrim($update_str, ","); |
|
| 354 | 354 | $insert_str .= $insert_key.") values"."(".$insert_value.") ON DUPLICATE KEY UPDATE $update_str"; |
| 355 | 355 | $this->db->query($insert_str); |
| 356 | 356 | } |
@@ -50,10 +50,11 @@ discard block |
||
| 50 | 50 | $this->db_model->build_search('termination_rates_list_search'); |
| 51 | 51 | $this->db->from('outbound_routes'); |
| 52 | 52 | if ($flag) { |
| 53 | - if ($export) |
|
| 54 | - $this->db->limit($limit, $start); |
|
| 53 | + if ($export) { |
|
| 54 | + $this->db->limit($limit, $start); |
|
| 55 | + } |
|
| 55 | 56 | $result = $this->db->get(); |
| 56 | - }else { |
|
| 57 | + } else { |
|
| 57 | 58 | $result = $this->db->count_all_results(); |
| 58 | 59 | } |
| 59 | 60 | return $result; |
@@ -71,10 +72,11 @@ discard block |
||
| 71 | 72 | |
| 72 | 73 | $this->db_model->build_search('origination_rate_list_search'); |
| 73 | 74 | if ($flag) { |
| 74 | - if ($export) |
|
| 75 | - $this->db->limit($limit, $start); |
|
| 75 | + if ($export) { |
|
| 76 | + $this->db->limit($limit, $start); |
|
| 77 | + } |
|
| 76 | 78 | $result = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
| 77 | - }else { |
|
| 79 | + } else { |
|
| 78 | 80 | $result = $this->db_model->countQuery("*", "routes", $where); |
| 79 | 81 | } |
| 80 | 82 | // echo "<pre>";print_r($result->result());exit; |
@@ -90,10 +92,11 @@ discard block |
||
| 90 | 92 | |
| 91 | 93 | $this->db_model->build_search('origination_rate_list_search'); |
| 92 | 94 | if ($flag) { |
| 93 | - if ($export) |
|
| 94 | - $this->db->limit($limit, $start); |
|
| 95 | + if ($export) { |
|
| 96 | + $this->db->limit($limit, $start); |
|
| 97 | + } |
|
| 95 | 98 | $result = $this->db_model->select("*", "routes", $where, "id", "ASC", $limit, $start); |
| 96 | - }else { |
|
| 99 | + } else { |
|
| 97 | 100 | $result = $this->db_model->countQuery("*", "routes", $where); |
| 98 | 101 | } |
| 99 | 102 | return $result; |
@@ -301,10 +304,11 @@ discard block |
||
| 301 | 304 | } |
| 302 | 305 | |
| 303 | 306 | $updateflg = $this->db_model->build_batch_update_array($update_array); |
| 304 | - if ($updateflg) |
|
| 305 | - return $this->db->update("outbound_routes"); |
|
| 306 | - else |
|
| 307 | - return false; |
|
| 307 | + if ($updateflg) { |
|
| 308 | + return $this->db->update("outbound_routes"); |
|
| 309 | + } else { |
|
| 310 | + return false; |
|
| 311 | + } |
|
| 308 | 312 | } |
| 309 | 313 | function origination_rate_batch_update($update_array) { |
| 310 | 314 | $this->db_model->build_search('origination_rate_list_search'); |
@@ -313,10 +317,11 @@ discard block |
||
| 313 | 317 | $this->db->where("reseller_id", $account_data['id']); |
| 314 | 318 | } |
| 315 | 319 | $updateflg = $this->db_model->build_batch_update_array($update_array); |
| 316 | - if ($updateflg) |
|
| 317 | - return $this->db->update("routes"); |
|
| 318 | - else |
|
| 319 | - return false; |
|
| 320 | + if ($updateflg) { |
|
| 321 | + return $this->db->update("routes"); |
|
| 322 | + } else { |
|
| 323 | + return false; |
|
| 324 | + } |
|
| 320 | 325 | } |
| 321 | 326 | function getreseller_rates_list($flag, $start = 0, $limit = 0, $export = false) { |
| 322 | 327 | $this->db_model->build_search('resellerrates_list_search'); |
@@ -32,10 +32,10 @@ discard block |
||
| 32 | 32 | $this->load->library('astpp/form'); |
| 33 | 33 | $this->load->model('rates_model'); |
| 34 | 34 | $this->load->library('csvreader'); |
| 35 | - ini_set("memory_limit","2048M"); |
|
| 36 | - ini_set("max_execution_time","259200"); |
|
| 35 | + ini_set("memory_limit", "2048M"); |
|
| 36 | + ini_set("max_execution_time", "259200"); |
|
| 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 termination_rates_list() { |
@@ -72,70 +72,70 @@ discard block |
||
| 72 | 72 | |
| 73 | 73 | echo json_encode($json_data); |
| 74 | 74 | } |
| 75 | - function termination_rates_list_delete($flag='') { |
|
| 75 | + function termination_rates_list_delete($flag = '') { |
|
| 76 | 76 | $json_data = array(); |
| 77 | - $this->session->set_userdata('advance_batch_data_delete',1); |
|
| 77 | + $this->session->set_userdata('advance_batch_data_delete', 1); |
|
| 78 | 78 | $count_all = $this->rates_model->get_termination_rates_list(false); |
| 79 | 79 | echo $count_all; |
| 80 | 80 | } |
| 81 | 81 | /****************/ |
| 82 | 82 | function termination_rate_import() { |
| 83 | 83 | $data['page_title'] = 'Import Termination Rates'; |
| 84 | - $this->session->set_userdata('import_termination_rate_csv',""); |
|
| 85 | - $this->session->set_userdata('import_termination_rate_csv_error',""); |
|
| 84 | + $this->session->set_userdata('import_termination_rate_csv', ""); |
|
| 85 | + $this->session->set_userdata('import_termination_rate_csv_error', ""); |
|
| 86 | 86 | $this->load->view('view_import_termination_rate', $data); |
| 87 | 87 | } |
| 88 | - function termination_rate_preview_file(){ |
|
| 89 | - $invalid_flag= false; |
|
| 90 | - $check_header=$this->input->post('check_header',true); |
|
| 88 | + function termination_rate_preview_file() { |
|
| 89 | + $invalid_flag = false; |
|
| 90 | + $check_header = $this->input->post('check_header', true); |
|
| 91 | 91 | $data['page_title'] = 'Import Termination Rates'; |
| 92 | 92 | $new_final_arr_key = $this->config->item('Termination-rates-field'); |
| 93 | - if(empty($_FILES) || !isset($_FILES)){ |
|
| 93 | + if (empty($_FILES) || ! isset($_FILES)) { |
|
| 94 | 94 | redirect(base_url()."rates/termination_rates_list/"); |
| 95 | 95 | } |
| 96 | - if (isset($_FILES['termination_rate_import']['name']) && $_FILES['termination_rate_import']['name'] != "" && isset($_POST['trunk_id']) && $_POST['trunk_id'] != '') { |
|
| 96 | + if (isset($_FILES['termination_rate_import']['name']) && $_FILES['termination_rate_import']['name'] != "" && isset($_POST['trunk_id']) && $_POST['trunk_id'] != '') { |
|
| 97 | 97 | list($txt, $ext) = explode(".", $_FILES['termination_rate_import']['name']); |
| 98 | - if($ext == "csv" && $_FILES['termination_rate_import']['size'] > 0){ |
|
| 98 | + if ($ext == "csv" && $_FILES['termination_rate_import']['size'] > 0) { |
|
| 99 | 99 | $error = $_FILES['termination_rate_import']['error']; |
| 100 | - if ($error == 0 ) { |
|
| 100 | + if ($error == 0) { |
|
| 101 | 101 | $uploadedFile = $_FILES["termination_rate_import"]["tmp_name"]; |
| 102 | - $csv_data=$this->csvreader->parse_file($uploadedFile,$new_final_arr_key,$check_header); |
|
| 103 | - if(!empty($csv_data)){ |
|
| 102 | + $csv_data = $this->csvreader->parse_file($uploadedFile, $new_final_arr_key, $check_header); |
|
| 103 | + if ( ! empty($csv_data)) { |
|
| 104 | 104 | $full_path = $this->config->item('rates-file-path'); |
| 105 | - $actual_file_name = "ASTPP-TERMINATION-RATES-".date("Y-m-d H:i:s"). "." . $ext; |
|
| 106 | - if (move_uploaded_file($uploadedFile,$full_path.$actual_file_name)) { |
|
| 105 | + $actual_file_name = "ASTPP-TERMINATION-RATES-".date("Y-m-d H:i:s").".".$ext; |
|
| 106 | + if (move_uploaded_file($uploadedFile, $full_path.$actual_file_name)) { |
|
| 107 | 107 | $data['csv_tmp_data'] = $csv_data; |
| 108 | 108 | $data['trunkid'] = $_POST['trunk_id']; |
| 109 | - $data['check_header']=$check_header; |
|
| 109 | + $data['check_header'] = $check_header; |
|
| 110 | 110 | $data['page_title'] = 'Termination Rates Preview'; |
| 111 | - $this->session->set_userdata('import_termination_rate_csv',$actual_file_name); |
|
| 112 | - }else{ |
|
| 111 | + $this->session->set_userdata('import_termination_rate_csv', $actual_file_name); |
|
| 112 | + } else { |
|
| 113 | 113 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 114 | 114 | } |
| 115 | 115 | } |
| 116 | 116 | } |
| 117 | - else{ |
|
| 118 | - $data['error']=="File Uploading Fail Please Try Again"; |
|
| 117 | + else { |
|
| 118 | + $data['error'] == "File Uploading Fail Please Try Again"; |
|
| 119 | 119 | } |
| 120 | - }else { |
|
| 120 | + } else { |
|
| 121 | 121 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 122 | 122 | } |
| 123 | - }else{ |
|
| 124 | - $invalid_flag=true; |
|
| 123 | + } else { |
|
| 124 | + $invalid_flag = true; |
|
| 125 | 125 | } |
| 126 | 126 | if ($invalid_flag) { |
| 127 | 127 | $str = ''; |
| 128 | - if (!isset($_POST['trunk_id']) || empty($_POST['trunk_id'])) { |
|
| 129 | - $str.= '<br/>Please Create Trunk.'; |
|
| 128 | + if ( ! isset($_POST['trunk_id']) || empty($_POST['trunk_id'])) { |
|
| 129 | + $str .= '<br/>Please Create Trunk.'; |
|
| 130 | 130 | } |
| 131 | 131 | if (empty($_FILES['termination_rate_import']['name'])) { |
| 132 | - $str.= '<br/>Please Select File.'; |
|
| 132 | + $str .= '<br/>Please Select File.'; |
|
| 133 | 133 | } |
| 134 | - $data['error']=$str; |
|
| 134 | + $data['error'] = $str; |
|
| 135 | 135 | } |
| 136 | 136 | $this->load->view('view_import_termination_rate', $data); |
| 137 | 137 | } |
| 138 | - function termination_rate_rates_import($trunkID,$check_header=false) { |
|
| 138 | + function termination_rate_rates_import($trunkID, $check_header = false) { |
|
| 139 | 139 | $new_final_arr = array(); |
| 140 | 140 | $invalid_array = array(); |
| 141 | 141 | $new_final_arr_key = $this->config->item('Termination-rates-field'); |
@@ -145,65 +145,65 @@ discard block |
||
| 145 | 145 | } |
| 146 | 146 | $full_path = $this->config->item('rates-file-path'); |
| 147 | 147 | $terminationrate_file_name = $this->session->userdata('import_termination_rate_csv'); |
| 148 | - $csv_tmp_data = $this->csvreader->parse_file($full_path.$terminationrate_file_name,$new_final_arr_key,$check_header); |
|
| 149 | - $i=0; |
|
| 148 | + $csv_tmp_data = $this->csvreader->parse_file($full_path.$terminationrate_file_name, $new_final_arr_key, $check_header); |
|
| 149 | + $i = 0; |
|
| 150 | 150 | foreach ($csv_tmp_data as $key => $csv_data) { |
| 151 | - if(isset($csv_data['pattern']) && $csv_data['pattern']!= '' && $i != 0){ |
|
| 152 | - $str=null; |
|
| 153 | - $csv_data['prepend']= isset($csv_data['prepend'])? $csv_data['prepend'] :''; |
|
| 154 | - $csv_data['comment']= isset($csv_data['comment'])? $csv_data['comment'] :''; |
|
| 155 | - $csv_data['connectcost']= isset($csv_data['connectcost']) ? $csv_data['connectcost'] :0; |
|
| 156 | - $csv_data['includedseconds']= isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] :0; |
|
| 157 | - $csv_data['cost']= !empty($csv_data['cost']) && is_numeric( $csv_data['cost']) ? $csv_data['cost'] :0; |
|
| 158 | - $csv_data['inc']= isset($csv_data['inc']) ? $csv_data['inc'] :0; |
|
| 159 | - $csv_data['precedence']= isset($csv_data['precedence']) ? $csv_data['precedence'] :''; |
|
| 160 | - $csv_data['strip']= isset($csv_data['strip']) ? $csv_data['strip'] :''; |
|
| 151 | + if (isset($csv_data['pattern']) && $csv_data['pattern'] != '' && $i != 0) { |
|
| 152 | + $str = null; |
|
| 153 | + $csv_data['prepend'] = isset($csv_data['prepend']) ? $csv_data['prepend'] : ''; |
|
| 154 | + $csv_data['comment'] = isset($csv_data['comment']) ? $csv_data['comment'] : ''; |
|
| 155 | + $csv_data['connectcost'] = isset($csv_data['connectcost']) ? $csv_data['connectcost'] : 0; |
|
| 156 | + $csv_data['includedseconds'] = isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] : 0; |
|
| 157 | + $csv_data['cost'] = ! empty($csv_data['cost']) && is_numeric($csv_data['cost']) ? $csv_data['cost'] : 0; |
|
| 158 | + $csv_data['inc'] = isset($csv_data['inc']) ? $csv_data['inc'] : 0; |
|
| 159 | + $csv_data['precedence'] = isset($csv_data['precedence']) ? $csv_data['precedence'] : ''; |
|
| 160 | + $csv_data['strip'] = isset($csv_data['strip']) ? $csv_data['strip'] : ''; |
|
| 161 | 161 | $csv_data['last_modified_date'] = date("Y-m-d H:i:s"); |
| 162 | - $str=$this->data_validate($csv_data); |
|
| 163 | - if($str != ""){ |
|
| 164 | - $invalid_array[$i]=$csv_data; |
|
| 162 | + $str = $this->data_validate($csv_data); |
|
| 163 | + if ($str != "") { |
|
| 164 | + $invalid_array[$i] = $csv_data; |
|
| 165 | 165 | $invalid_array[$i]['error'] = $str; |
| 166 | 166 | } |
| 167 | - else{ |
|
| 168 | - $csv_data['trunk_id']=$trunkID; |
|
| 169 | - $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
|
| 170 | - $new_final_arr[$i]=$csv_data; |
|
| 167 | + else { |
|
| 168 | + $csv_data['trunk_id'] = $trunkID; |
|
| 169 | + $csv_data['pattern'] = "^".$csv_data['pattern'].".*"; |
|
| 170 | + $new_final_arr[$i] = $csv_data; |
|
| 171 | 171 | } |
| 172 | 172 | } |
| 173 | 173 | $i++; |
| 174 | 174 | } |
| 175 | - if(!empty($new_final_arr)){ |
|
| 175 | + if ( ! empty($new_final_arr)) { |
|
| 176 | 176 | $result = $this->rates_model->bulk_insert_termination_rate($new_final_arr); |
| 177 | 177 | } |
| 178 | 178 | unlink($full_path.$terminationrate_file_name); |
| 179 | - $count=count($invalid_array); |
|
| 180 | - if($count >0){ |
|
| 179 | + $count = count($invalid_array); |
|
| 180 | + if ($count > 0) { |
|
| 181 | 181 | $session_id = "-1"; |
| 182 | 182 | $fp = fopen($full_path.$session_id.'.csv', 'w'); |
| 183 | - foreach($new_final_arr_key as $key=>$value){ |
|
| 184 | - $custom_array[0][$key]=ucfirst($key); |
|
| 183 | + foreach ($new_final_arr_key as $key=>$value) { |
|
| 184 | + $custom_array[0][$key] = ucfirst($key); |
|
| 185 | 185 | } |
| 186 | - $custom_array[0]['error']= "Error"; |
|
| 187 | - $invalid_array =array_merge($custom_array,$invalid_array); |
|
| 188 | - foreach($invalid_array as $err_data){ |
|
| 189 | - fputcsv($fp,$err_data); |
|
| 186 | + $custom_array[0]['error'] = "Error"; |
|
| 187 | + $invalid_array = array_merge($custom_array, $invalid_array); |
|
| 188 | + foreach ($invalid_array as $err_data) { |
|
| 189 | + fputcsv($fp, $err_data); |
|
| 190 | 190 | } |
| 191 | 191 | fclose($fp); |
| 192 | 192 | $this->session->set_userdata('import_termination_rate_csv_error', $session_id.".csv"); |
| 193 | 193 | $data["error"] = $invalid_array; |
| 194 | 194 | $data['trunkid'] = $trunkID; |
| 195 | 195 | $data['impoted_count'] = count($new_final_arr); |
| 196 | - $data['failure_count'] = count($invalid_array)-1; |
|
| 196 | + $data['failure_count'] = count($invalid_array) - 1; |
|
| 197 | 197 | $data['page_title'] = 'Termination Rates Import Error'; |
| 198 | - $this->load->view('view_import_error',$data); |
|
| 199 | - } else{ |
|
| 198 | + $this->load->view('view_import_error', $data); |
|
| 199 | + } else { |
|
| 200 | 200 | $this->session->set_flashdata('astpp_errormsg', 'Total '.count($new_final_arr).' Termination rates imported successfully!'); |
| 201 | 201 | redirect(base_url()."rates/termination_rates_list/"); |
| 202 | 202 | } |
| 203 | 203 | } |
| 204 | - function termination_rate_error_download(){ |
|
| 204 | + function termination_rate_error_download() { |
|
| 205 | 205 | $this->load->helper('download'); |
| 206 | - $error_data = $this->session->userdata('import_termination_rate_csv_error'); |
|
| 206 | + $error_data = $this->session->userdata('import_termination_rate_csv_error'); |
|
| 207 | 207 | $full_path = $this->config->item('rates-file-path'); |
| 208 | 208 | $data = file_get_contents($full_path.$error_data); |
| 209 | 209 | force_download("Termination_rate_error.csv", $data); |
@@ -211,182 +211,182 @@ discard block |
||
| 211 | 211 | } |
| 212 | 212 | function origination_rate_import() { |
| 213 | 213 | $data['page_title'] = 'Import Origination Rates'; |
| 214 | - $this->session->set_userdata('import_origination_rate_csv',""); |
|
| 215 | - $error_data = $this->session->userdata('import_origination_rate_csv_error'); |
|
| 214 | + $this->session->set_userdata('import_origination_rate_csv', ""); |
|
| 215 | + $error_data = $this->session->userdata('import_origination_rate_csv_error'); |
|
| 216 | 216 | $full_path = $this->config->item('rates-file-path'); |
| 217 | - if(file_exists($full_path.$error_data) && $error_data != ""){ |
|
| 217 | + if (file_exists($full_path.$error_data) && $error_data != "") { |
|
| 218 | 218 | unlink($full_path.$error_data); |
| 219 | - $this->session->set_userdata('import_origination_rate_csv_error',""); |
|
| 219 | + $this->session->set_userdata('import_origination_rate_csv_error', ""); |
|
| 220 | 220 | } |
| 221 | 221 | $this->load->view('view_import_origination_rate', $data); |
| 222 | 222 | } |
| 223 | - function origination_rate_preview_file(){ |
|
| 224 | - $invalid_flag= false; |
|
| 225 | - $data=array(); |
|
| 223 | + function origination_rate_preview_file() { |
|
| 224 | + $invalid_flag = false; |
|
| 225 | + $data = array(); |
|
| 226 | 226 | $data['page_title'] = 'Import Origination Rates'; |
| 227 | - $check_header=$this->input->post('check_header',true); |
|
| 228 | - if(empty($_FILES) || !isset($_FILES)){ |
|
| 227 | + $check_header = $this->input->post('check_header', true); |
|
| 228 | + if (empty($_FILES) || ! isset($_FILES)) { |
|
| 229 | 229 | redirect(base_url()."rates/origination_rate_list/"); |
| 230 | 230 | } |
| 231 | - $get_extension=strpos($_FILES['origination_rate_import']['name'],'.'); |
|
| 231 | + $get_extension = strpos($_FILES['origination_rate_import']['name'], '.'); |
|
| 232 | 232 | $new_final_arr_key = $this->config->item('Origination-rates-field'); |
| 233 | - if(!$get_extension){ |
|
| 234 | - $data['error']= "Please Upload File Atleast"; |
|
| 233 | + if ( ! $get_extension) { |
|
| 234 | + $data['error'] = "Please Upload File Atleast"; |
|
| 235 | 235 | } |
| 236 | 236 | if (isset($_FILES['origination_rate_import']['name']) && $_FILES['origination_rate_import']['name'] != "" && isset($_POST['pricelist_id']) && $_POST['pricelist_id'] != '') { |
| 237 | - list($txt,$ext) = explode(".", $_FILES['origination_rate_import']['name']); |
|
| 237 | + list($txt, $ext) = explode(".", $_FILES['origination_rate_import']['name']); |
|
| 238 | 238 | |
| 239 | - if($ext == "csv" && $_FILES['origination_rate_import']['size'] > 0){ |
|
| 239 | + if ($ext == "csv" && $_FILES['origination_rate_import']['size'] > 0) { |
|
| 240 | 240 | $error = $_FILES['origination_rate_import']['error']; |
| 241 | 241 | if ($error == 0) { |
| 242 | 242 | $uploadedFile = $_FILES["origination_rate_import"]["tmp_name"]; |
| 243 | - $csv_data=$this->csvreader->parse_file($uploadedFile,$new_final_arr_key,$check_header); |
|
| 244 | - if(!empty($csv_data)){ |
|
| 243 | + $csv_data = $this->csvreader->parse_file($uploadedFile, $new_final_arr_key, $check_header); |
|
| 244 | + if ( ! empty($csv_data)) { |
|
| 245 | 245 | $full_path = $this->config->item('rates-file-path'); |
| 246 | - $actual_file_name = "ASTPP-ORIGIN-RATES-".date("Y-m-d H:i:s"). "." . $ext; |
|
| 247 | - if (move_uploaded_file($uploadedFile,$full_path.$actual_file_name)) { |
|
| 248 | - $flag=false; |
|
| 249 | - $data['trunkid']=isset($_POST['trunk_id']) && $_POST['trunk_id'] > 0 ? $_POST['trunk_id'] : 0; |
|
| 246 | + $actual_file_name = "ASTPP-ORIGIN-RATES-".date("Y-m-d H:i:s").".".$ext; |
|
| 247 | + if (move_uploaded_file($uploadedFile, $full_path.$actual_file_name)) { |
|
| 248 | + $flag = false; |
|
| 249 | + $data['trunkid'] = isset($_POST['trunk_id']) && $_POST['trunk_id'] > 0 ? $_POST['trunk_id'] : 0; |
|
| 250 | 250 | $data['csv_tmp_data'] = $csv_data; |
| 251 | 251 | $data['pricelistid'] = $_POST['pricelist_id']; |
| 252 | 252 | $data['page_title'] = "Origination Rates Preview"; |
| 253 | - $data['check_header']=$check_header; |
|
| 254 | - $this->session->set_userdata('import_origination_rate_csv',$actual_file_name); |
|
| 255 | - }else{ |
|
| 253 | + $data['check_header'] = $check_header; |
|
| 254 | + $this->session->set_userdata('import_origination_rate_csv', $actual_file_name); |
|
| 255 | + } else { |
|
| 256 | 256 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 257 | 257 | } |
| 258 | 258 | } |
| 259 | 259 | } |
| 260 | - else{ |
|
| 261 | - $data['error']=="File Uploading Fail Please Try Again"; |
|
| 260 | + else { |
|
| 261 | + $data['error'] == "File Uploading Fail Please Try Again"; |
|
| 262 | 262 | } |
| 263 | 263 | } |
| 264 | 264 | else { |
| 265 | 265 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 266 | 266 | } |
| 267 | - }else{ |
|
| 268 | - $invalid_flag=true; |
|
| 267 | + } else { |
|
| 268 | + $invalid_flag = true; |
|
| 269 | 269 | } |
| 270 | 270 | if ($invalid_flag) { |
| 271 | 271 | $str = ''; |
| 272 | - if (!isset($_POST['pricelist_id']) || empty($_POST['pricelist_id'])) { |
|
| 273 | - $str.= '<br/>Please Create Rate Group.'; |
|
| 272 | + if ( ! isset($_POST['pricelist_id']) || empty($_POST['pricelist_id'])) { |
|
| 273 | + $str .= '<br/>Please Create Rate Group.'; |
|
| 274 | 274 | } |
| 275 | 275 | if (empty($_FILES['origination_rate_import']['name'])) { |
| 276 | - $str.= '<br/>Please Select File.'; |
|
| 276 | + $str .= '<br/>Please Select File.'; |
|
| 277 | 277 | } |
| 278 | - $data['error']=$str; |
|
| 278 | + $data['error'] = $str; |
|
| 279 | 279 | } |
| 280 | 280 | $this->load->view('view_import_origination_rate', $data); |
| 281 | 281 | } |
| 282 | - function origination_rate_import_file($pricelistID,$trunkid,$check_header=false) { |
|
| 282 | + function origination_rate_import_file($pricelistID, $trunkid, $check_header = false) { |
|
| 283 | 283 | $new_final_arr = array(); |
| 284 | 284 | $invalid_array = array(); |
| 285 | 285 | $new_final_arr_key = $this->config->item('Origination-rates-field'); |
| 286 | 286 | $screen_path = $this->config->item('screen_path'); |
| 287 | - $reseller_id=0; |
|
| 287 | + $reseller_id = 0; |
|
| 288 | 288 | if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
| 289 | 289 | $reseller_id = $this->session->userdata["accountinfo"]['id']; |
| 290 | 290 | } |
| 291 | 291 | |
| 292 | 292 | $full_path = $this->config->item('rates-file-path'); |
| 293 | 293 | $originationrate_file_name = $this->session->userdata('import_origination_rate_csv'); |
| 294 | - $csv_tmp_data = $this->csvreader->parse_file($full_path.$originationrate_file_name,$new_final_arr_key,$check_header); |
|
| 294 | + $csv_tmp_data = $this->csvreader->parse_file($full_path.$originationrate_file_name, $new_final_arr_key, $check_header); |
|
| 295 | 295 | //echo "<pre>";print_r($csv_tmp_data);exit; |
| 296 | - $i=0; |
|
| 296 | + $i = 0; |
|
| 297 | 297 | foreach ($csv_tmp_data as $key => $csv_data) { |
| 298 | - if(isset($csv_data['pattern']) && $csv_data['pattern']!= '' && $i != 0){ |
|
| 299 | - $str=null; |
|
| 300 | - $csv_data['comment']= isset($csv_data['comment'])? $csv_data['comment'] :''; |
|
| 301 | - $csv_data['connectcost']= isset($csv_data['connectcost']) ? $csv_data['connectcost'] :0; |
|
| 302 | - $csv_data['includedseconds']= isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] :0; |
|
| 303 | - $csv_data['cost']= !empty($csv_data['cost']) && is_numeric( $csv_data['cost']) ? $csv_data['cost'] :0; |
|
| 304 | - $csv_data['inc']= isset($csv_data['inc']) ? $csv_data['inc'] :0; |
|
| 305 | - $csv_data['precedence']= isset($csv_data['precedence']) ? $csv_data['precedence'] :''; |
|
| 298 | + if (isset($csv_data['pattern']) && $csv_data['pattern'] != '' && $i != 0) { |
|
| 299 | + $str = null; |
|
| 300 | + $csv_data['comment'] = isset($csv_data['comment']) ? $csv_data['comment'] : ''; |
|
| 301 | + $csv_data['connectcost'] = isset($csv_data['connectcost']) ? $csv_data['connectcost'] : 0; |
|
| 302 | + $csv_data['includedseconds'] = isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] : 0; |
|
| 303 | + $csv_data['cost'] = ! empty($csv_data['cost']) && is_numeric($csv_data['cost']) ? $csv_data['cost'] : 0; |
|
| 304 | + $csv_data['inc'] = isset($csv_data['inc']) ? $csv_data['inc'] : 0; |
|
| 305 | + $csv_data['precedence'] = isset($csv_data['precedence']) ? $csv_data['precedence'] : ''; |
|
| 306 | 306 | $csv_data['last_modified_date'] = date("Y-m-d H:i:s"); |
| 307 | - $str=$this->data_validate($csv_data); |
|
| 308 | - if($str != ""){ |
|
| 309 | - $invalid_array[$i]=$csv_data; |
|
| 307 | + $str = $this->data_validate($csv_data); |
|
| 308 | + if ($str != "") { |
|
| 309 | + $invalid_array[$i] = $csv_data; |
|
| 310 | 310 | $invalid_array[$i]['error'] = $str; |
| 311 | 311 | } |
| 312 | - else{ |
|
| 313 | - $csv_data['pricelist_id']=$pricelistID; |
|
| 314 | - $csv_data['trunk_id']=$trunkid; |
|
| 315 | - $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
|
| 316 | - $csv_data['reseller_id']= $reseller_id; |
|
| 312 | + else { |
|
| 313 | + $csv_data['pricelist_id'] = $pricelistID; |
|
| 314 | + $csv_data['trunk_id'] = $trunkid; |
|
| 315 | + $csv_data['pattern'] = "^".$csv_data['pattern'].".*"; |
|
| 316 | + $csv_data['reseller_id'] = $reseller_id; |
|
| 317 | 317 | $csv_data['creation_date'] = gmdate('Y-m-d H:i:s'); |
| 318 | - $new_final_arr[$i]=$csv_data; |
|
| 318 | + $new_final_arr[$i] = $csv_data; |
|
| 319 | 319 | } |
| 320 | 320 | } |
| 321 | 321 | $i++; |
| 322 | 322 | } |
| 323 | - if(!empty($new_final_arr)){ |
|
| 323 | + if ( ! empty($new_final_arr)) { |
|
| 324 | 324 | $result = $this->rates_model->bulk_insert_origination_rate($new_final_arr); |
| 325 | 325 | } |
| 326 | 326 | unlink($full_path.$originationrate_file_name); |
| 327 | - $count=count($invalid_array); |
|
| 328 | - if($count >0){ |
|
| 327 | + $count = count($invalid_array); |
|
| 328 | + if ($count > 0) { |
|
| 329 | 329 | $session_id = "-1"; |
| 330 | 330 | $fp = fopen($full_path.$session_id.'.csv', 'w'); |
| 331 | - foreach($new_final_arr_key as $key=>$value){ |
|
| 332 | - $custom_array[0][$key]=ucfirst($key); |
|
| 331 | + foreach ($new_final_arr_key as $key=>$value) { |
|
| 332 | + $custom_array[0][$key] = ucfirst($key); |
|
| 333 | 333 | } |
| 334 | - $custom_array[0]['error']= "Error"; |
|
| 335 | - $invalid_array =array_merge($custom_array,$invalid_array); |
|
| 336 | - foreach($invalid_array as $err_data){ |
|
| 337 | - fputcsv($fp,$err_data); |
|
| 334 | + $custom_array[0]['error'] = "Error"; |
|
| 335 | + $invalid_array = array_merge($custom_array, $invalid_array); |
|
| 336 | + foreach ($invalid_array as $err_data) { |
|
| 337 | + fputcsv($fp, $err_data); |
|
| 338 | 338 | } |
| 339 | 339 | fclose($fp); |
| 340 | 340 | $this->session->set_userdata('import_origination_rate_csv_error', $session_id.".csv"); |
| 341 | 341 | $data["error"] = $invalid_array; |
| 342 | 342 | $data['pricelistid'] = $pricelistID; |
| 343 | 343 | $data['impoted_count'] = count($new_final_arr); |
| 344 | - $data['failure_count'] = count($invalid_array)-1; |
|
| 344 | + $data['failure_count'] = count($invalid_array) - 1; |
|
| 345 | 345 | $data['page_title'] = 'Origination Rates Import Error'; |
| 346 | - $this->load->view('view_import_error',$data); |
|
| 347 | - } else{ |
|
| 346 | + $this->load->view('view_import_error', $data); |
|
| 347 | + } else { |
|
| 348 | 348 | $this->session->set_flashdata('astpp_errormsg', 'Total '.count($new_final_arr).' Origination rates imported successfully!'); |
| 349 | 349 | redirect(base_url()."rates/origination_rates_list/"); |
| 350 | 350 | } |
| 351 | 351 | } |
| 352 | - function data_validate($csvdata){ |
|
| 353 | - $str=null; |
|
| 352 | + function data_validate($csvdata) { |
|
| 353 | + $str = null; |
|
| 354 | 354 | $alpha_regex = "/^[a-z ,.'-]+$/i"; |
| 355 | 355 | $alpha_numeric_regex = "/^[a-z0-9 ,.'-]+$/i"; |
| 356 | 356 | $email_regex = "/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/"; |
| 357 | - $str.= $csvdata['pattern']!= '' ? null : 'Code,'; |
|
| 358 | - $str=rtrim($str,','); |
|
| 359 | - if(!$str){ |
|
| 360 | - $str.= is_numeric($csvdata['pattern']) ? null : 'Code,'; |
|
| 357 | + $str .= $csvdata['pattern'] != '' ? null : 'Code,'; |
|
| 358 | + $str = rtrim($str, ','); |
|
| 359 | + if ( ! $str) { |
|
| 360 | + $str .= is_numeric($csvdata['pattern']) ? null : 'Code,'; |
|
| 361 | 361 | |
| 362 | - $str.= !empty($csvdata['connectcost']) && is_numeric( $csvdata['connectcost']) ? null :( empty($csvdata['connectcost']) ? null : 'Connect Cost,'); |
|
| 363 | - $str.= !empty($csvdata['includedseconds']) && is_numeric( $csvdata['includedseconds']) ? null :( empty($csvdata['includedseconds']) ? null : 'Included Seconds,'); |
|
| 362 | + $str .= ! empty($csvdata['connectcost']) && is_numeric($csvdata['connectcost']) ? null : (empty($csvdata['connectcost']) ? null : 'Connect Cost,'); |
|
| 363 | + $str .= ! empty($csvdata['includedseconds']) && is_numeric($csvdata['includedseconds']) ? null : (empty($csvdata['includedseconds']) ? null : 'Included Seconds,'); |
|
| 364 | 364 | |
| 365 | - $str.= !empty($csvdata['inc']) && is_numeric( $csvdata['inc']) ? null :( empty($csvdata['inc']) ? null : 'Increment,'); |
|
| 366 | - $str.= !empty($csvdata['precedence']) && is_numeric( $csvdata['precedence']) ? null :( empty($csvdata['precedence']) ? null : 'Precedence,'); |
|
| 367 | - $str.= (isset($csvdata['strip']) && !empty($csvdata['strip'])) ? (is_numeric($csvdata['strip']) ? null :'Strip,') : null; |
|
| 368 | - if($str){ |
|
| 369 | - $str=rtrim($str,','); |
|
| 370 | - $error_field=explode(',',$str); |
|
| 365 | + $str .= ! empty($csvdata['inc']) && is_numeric($csvdata['inc']) ? null : (empty($csvdata['inc']) ? null : 'Increment,'); |
|
| 366 | + $str .= ! empty($csvdata['precedence']) && is_numeric($csvdata['precedence']) ? null : (empty($csvdata['precedence']) ? null : 'Precedence,'); |
|
| 367 | + $str .= (isset($csvdata['strip']) && ! empty($csvdata['strip'])) ? (is_numeric($csvdata['strip']) ? null : 'Strip,') : null; |
|
| 368 | + if ($str) { |
|
| 369 | + $str = rtrim($str, ','); |
|
| 370 | + $error_field = explode(',', $str); |
|
| 371 | 371 | $count = count($error_field); |
| 372 | - $str.= $count > 1 ? ' are not valid' : ' is not Valid'; |
|
| 372 | + $str .= $count > 1 ? ' are not valid' : ' is not Valid'; |
|
| 373 | 373 | return $str; |
| 374 | 374 | } |
| 375 | - else{ |
|
| 375 | + else { |
|
| 376 | 376 | return false; |
| 377 | 377 | } |
| 378 | 378 | } |
| 379 | - else{ |
|
| 380 | - $str=rtrim($str,','); |
|
| 381 | - $error_field=explode(',',$str); |
|
| 379 | + else { |
|
| 380 | + $str = rtrim($str, ','); |
|
| 381 | + $error_field = explode(',', $str); |
|
| 382 | 382 | $count = count($error_field); |
| 383 | - $str.= $count > 1 ? ' are required' : ' is Required'; |
|
| 383 | + $str .= $count > 1 ? ' are required' : ' is Required'; |
|
| 384 | 384 | return $str; |
| 385 | 385 | } |
| 386 | 386 | } |
| 387 | - function origination_rate_error_download(){ |
|
| 387 | + function origination_rate_error_download() { |
|
| 388 | 388 | $this->load->helper('download'); |
| 389 | - $error_data = $this->session->userdata('import_origination_rate_csv_error'); |
|
| 389 | + $error_data = $this->session->userdata('import_origination_rate_csv_error'); |
|
| 390 | 390 | $full_path = $this->config->item('rates-file-path'); |
| 391 | 391 | $data = file_get_contents($full_path.$error_data); |
| 392 | 392 | force_download("Origination_rate_error.csv", $data); |
@@ -416,13 +416,13 @@ discard block |
||
| 416 | 416 | $edit_data = $value; |
| 417 | 417 | } |
| 418 | 418 | $edit_data['connectcost'] = $this->common_model->to_calculate_currency($edit_data['connectcost'], '', '', true, false); |
| 419 | - $edit_data['cost'] = $this->common_model->to_calculate_currency($edit_data['cost'], '', '',true, false); |
|
| 419 | + $edit_data['cost'] = $this->common_model->to_calculate_currency($edit_data['cost'], '', '', true, false); |
|
| 420 | 420 | $edit_data['pattern'] = filter_var($edit_data['pattern'], FILTER_SANITIZE_NUMBER_INT); |
| 421 | 421 | |
| 422 | 422 | $data['form'] = $this->form->build_form($this->rates_form->get_origination_rate_form_fields(), $edit_data); |
| 423 | 423 | $this->load->view('view_origination_rate_add_edit', $data); |
| 424 | 424 | } else { |
| 425 | - redirect(base_url() . 'rates/origination_rate_list/'); |
|
| 425 | + redirect(base_url().'rates/origination_rate_list/'); |
|
| 426 | 426 | } |
| 427 | 427 | } |
| 428 | 428 | |
@@ -470,7 +470,7 @@ discard block |
||
| 470 | 470 | $this->session->set_userdata('origination_rate_list_search', $action); |
| 471 | 471 | } |
| 472 | 472 | if (@$ajax_search != 1) { |
| 473 | - redirect(base_url() . 'rates/origination_rates_list/'); |
|
| 473 | + redirect(base_url().'rates/origination_rates_list/'); |
|
| 474 | 474 | } |
| 475 | 475 | } |
| 476 | 476 | |
@@ -482,13 +482,13 @@ discard block |
||
| 482 | 482 | function termination_rate_delete($id) { |
| 483 | 483 | $this->rates_model->remove_termination_rate($id); |
| 484 | 484 | $this->session->set_flashdata('astpp_notification', 'Termination removed successfully!'); |
| 485 | - redirect(base_url() . '/rates/termination_rates_list/'); |
|
| 485 | + redirect(base_url().'/rates/termination_rates_list/'); |
|
| 486 | 486 | } |
| 487 | 487 | |
| 488 | 488 | function origination_rate_delete($id) { |
| 489 | 489 | $this->rates_model->remove_origination_rate($id); |
| 490 | 490 | $this->session->set_flashdata('astpp_notification', 'Origination rate removed successfully!'); |
| 491 | - redirect(base_url() . 'rates/origination_rates_list/'); |
|
| 491 | + redirect(base_url().'rates/origination_rates_list/'); |
|
| 492 | 492 | } |
| 493 | 493 | |
| 494 | 494 | function origination_rates_list() { |
@@ -527,9 +527,9 @@ discard block |
||
| 527 | 527 | echo json_encode($json_data); |
| 528 | 528 | } |
| 529 | 529 | |
| 530 | - function origination_rates_list_delete($flag='') { |
|
| 530 | + function origination_rates_list_delete($flag = '') { |
|
| 531 | 531 | $json_data = array(); |
| 532 | - $this->session->set_userdata('advance_batch_data_delete',1); |
|
| 532 | + $this->session->set_userdata('advance_batch_data_delete', 1); |
|
| 533 | 533 | $count_all = $this->rates_model->get_origination_rate_list(false); |
| 534 | 534 | echo $count_all; |
| 535 | 535 | } |
@@ -603,7 +603,7 @@ discard block |
||
| 603 | 603 | $this->session->set_userdata('termination_rates_list_search', $action); |
| 604 | 604 | } |
| 605 | 605 | if (@$ajax_search != 1) { |
| 606 | - redirect(base_url() . 'rates/termination_rates_list/'); |
|
| 606 | + redirect(base_url().'rates/termination_rates_list/'); |
|
| 607 | 607 | } |
| 608 | 608 | } |
| 609 | 609 | |
@@ -612,20 +612,20 @@ discard block |
||
| 612 | 612 | $this->session->set_userdata('account_search', ""); |
| 613 | 613 | } |
| 614 | 614 | |
| 615 | - function customer_block_pattern_list($accountid,$accounttype) { |
|
| 615 | + function customer_block_pattern_list($accountid, $accounttype) { |
|
| 616 | 616 | $json_data = array(); |
| 617 | 617 | $where = array('accountid' => $accountid); |
| 618 | - $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_pattern'); |
|
| 619 | - $like_str=!empty($instant_search) ? "(blocked_patterns like '%$instant_search%' OR destination like '%$instant_search%' )" :null; |
|
| 620 | - if(!empty($like_str)) |
|
| 618 | + $instant_search = $this->session->userdata('left_panel_search_'.$accounttype.'_pattern'); |
|
| 619 | + $like_str = ! empty($instant_search) ? "(blocked_patterns like '%$instant_search%' OR destination like '%$instant_search%' )" : null; |
|
| 620 | + if ( ! empty($like_str)) |
|
| 621 | 621 | $this->db->where($like_str); |
| 622 | 622 | $count_all = $this->db_model->countQuery("*", "block_patterns", $where); |
| 623 | 623 | $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
| 624 | 624 | $json_data = $paging_data["json_paging"]; |
| 625 | - if(!empty($like_str)) |
|
| 625 | + if ( ! empty($like_str)) |
|
| 626 | 626 | $this->db->where($like_str); |
| 627 | 627 | $pattern_data = $this->db_model->getSelect("*", "block_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]); |
| 628 | - $grid_fields = json_decode($this->rates_form->build_pattern_list_for_customer($accountid,$accounttype)); |
|
| 628 | + $grid_fields = json_decode($this->rates_form->build_pattern_list_for_customer($accountid, $accounttype)); |
|
| 629 | 629 | $json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields); |
| 630 | 630 | echo json_encode($json_data); |
| 631 | 631 | } |
@@ -648,7 +648,7 @@ discard block |
||
| 648 | 648 | $json_data = array(); |
| 649 | 649 | $account_data = $this->session->userdata("accountinfo"); |
| 650 | 650 | $markup = $this->common->get_field_name('markup', 'pricelists', array('id'=>$account_data["pricelist_id"])); |
| 651 | - $markup = ($markup > 0)?$markup:1; |
|
| 651 | + $markup = ($markup > 0) ? $markup : 1; |
|
| 652 | 652 | |
| 653 | 653 | $count_all = $this->rates_model->get_origination_rate_list_for_user(false); |
| 654 | 654 | $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
@@ -658,11 +658,11 @@ discard block |
||
| 658 | 658 | $grid_fields = json_decode($this->rates_form->build_origination_rate_list_for_user()); |
| 659 | 659 | foreach ($query->result_array() as $key => $value) { |
| 660 | 660 | $json_data['rows'][] = array('cell' => array( |
| 661 | - $this->common->get_only_numeric_val("","",$value["pattern"]), |
|
| 661 | + $this->common->get_only_numeric_val("", "", $value["pattern"]), |
|
| 662 | 662 | $value['comment'], |
| 663 | 663 | $value['inc'], |
| 664 | - $this->common_model->calculate_currency(($value['cost'] + ($value['cost']*$markup)/100),'','','',true), |
|
| 665 | - $this->common_model->calculate_currency($value['connectcost'],'','','',true), |
|
| 664 | + $this->common_model->calculate_currency(($value['cost'] + ($value['cost'] * $markup) / 100), '', '', '', true), |
|
| 665 | + $this->common_model->calculate_currency($value['connectcost'], '', '', '', true), |
|
| 666 | 666 | $value['includedseconds'] |
| 667 | 667 | )); |
| 668 | 668 | } |
@@ -681,7 +681,7 @@ discard block |
||
| 681 | 681 | $this->session->set_userdata('origination_rate_list_search', $action); |
| 682 | 682 | } |
| 683 | 683 | if (@$ajax_search != 1) { |
| 684 | - redirect(base_url() . 'user/user_rates_list/'); |
|
| 684 | + redirect(base_url().'user/user_rates_list/'); |
|
| 685 | 685 | } |
| 686 | 686 | } |
| 687 | 687 | |
@@ -689,10 +689,10 @@ discard block |
||
| 689 | 689 | $this->session->set_userdata('advance_search', 0); |
| 690 | 690 | $this->session->set_userdata('account_search', ""); |
| 691 | 691 | } |
| 692 | - function customer_rates_download_sample_file($file_name){ |
|
| 692 | + function customer_rates_download_sample_file($file_name) { |
|
| 693 | 693 | $this->load->helper('download'); |
| 694 | 694 | $full_path = base_url()."assets/Rates_File/".$file_name.".csv"; |
| 695 | - $arrContextOptions=array( |
|
| 695 | + $arrContextOptions = array( |
|
| 696 | 696 | "ssl"=>array( |
| 697 | 697 | "verify_peer"=>false, |
| 698 | 698 | "verify_peer_name"=>false, |
@@ -701,19 +701,19 @@ discard block |
||
| 701 | 701 | $file = file_get_contents($full_path, false, stream_context_create($arrContextOptions)); |
| 702 | 702 | force_download("samplefile.csv", $file); |
| 703 | 703 | } |
| 704 | - function termination_rate_batch_update(){ |
|
| 704 | + function termination_rate_batch_update() { |
|
| 705 | 705 | $batch_update_arr = $this->input->post(); |
| 706 | - $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"])?$this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false):"0.0000"; |
|
| 707 | - $batch_update_arr["connectcost"]["connectcost"] = isset($batch_update_arr["connectcost"]["connectcost"])?$this->common_model->add_calculate_currency($batch_update_arr["connectcost"]["connectcost"], '', '', true, false):"0.0000"; |
|
| 706 | + $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"]) ? $this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false) : "0.0000"; |
|
| 707 | + $batch_update_arr["connectcost"]["connectcost"] = isset($batch_update_arr["connectcost"]["connectcost"]) ? $this->common_model->add_calculate_currency($batch_update_arr["connectcost"]["connectcost"], '', '', true, false) : "0.0000"; |
|
| 708 | 708 | // $batch_update_arr = array("inc"=> array("inc"=>"1","operator"=>"3"),"cost"=> array("cost"=>"1","operator"=>"4")); |
| 709 | 709 | $result = $this->rates_model->termination_rate_batch_update($batch_update_arr); |
| 710 | 710 | echo json_encode(array("SUCCESS"=> "Termination rates batch updated successfully!")); |
| 711 | 711 | exit; |
| 712 | 712 | } |
| 713 | 713 | |
| 714 | - function origination_rate_batch_update(){ |
|
| 714 | + function origination_rate_batch_update() { |
|
| 715 | 715 | $batch_update_arr = $this->input->post(); |
| 716 | - $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"])?$this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false):"0.0000"; |
|
| 716 | + $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"]) ? $this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false) : "0.0000"; |
|
| 717 | 717 | // $batch_update_arr = array("inc"=> array("inc"=>"1","operator"=>"3"),"cost"=> array("cost"=>"1","operator"=>"4")); |
| 718 | 718 | $result = $this->rates_model->origination_rate_batch_update($batch_update_arr); |
| 719 | 719 | echo json_encode(array("SUCCESS"=> "Origination rates batch updated successfully!")); |
@@ -722,23 +722,23 @@ discard block |
||
| 722 | 722 | |
| 723 | 723 | function termination_rate_export_cdr_xls() { |
| 724 | 724 | $account_info = $accountinfo = $this->session->userdata('accountinfo'); |
| 725 | - $currency_id=$account_info['currency_id']; |
|
| 726 | - $currency=$this->common->get_field_name('currency', 'currency', $currency_id); |
|
| 725 | + $currency_id = $account_info['currency_id']; |
|
| 726 | + $currency = $this->common->get_field_name('currency', 'currency', $currency_id); |
|
| 727 | 727 | $query = $this->rates_model->get_termination_rate(true, '', '', false); |
| 728 | 728 | $outbound_array = array(); |
| 729 | 729 | ob_clean(); |
| 730 | - $outbound_array[] = array("Code", "Destination", "Connect Cost($currency)", "Included Seconds","Per Minute Cost($currency)","Initial Increment", "Increment","Priority","Strip","Prepend","Trunk","Status","Created Date"); |
|
| 730 | + $outbound_array[] = array("Code", "Destination", "Connect Cost($currency)", "Included Seconds", "Per Minute Cost($currency)", "Initial Increment", "Increment", "Priority", "Strip", "Prepend", "Trunk", "Status", "Created Date"); |
|
| 731 | 731 | if ($query->num_rows() > 0) { |
| 732 | 732 | |
| 733 | 733 | foreach ($query->result_array() as $row) { |
| 734 | 734 | //echo"<pre>";print_r($row);exit; |
| 735 | 735 | $outbound_array[] = array( |
| 736 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 736 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 737 | 737 | $row['comment'], |
| 738 | - $this->common_model->calculate_currency($row['connectcost'],'','',TRUE,false), |
|
| 738 | + $this->common_model->calculate_currency($row['connectcost'], '', '', TRUE, false), |
|
| 739 | 739 | |
| 740 | 740 | $row['includedseconds'], |
| 741 | - $this->common_model->calculate_currency($row['cost'],'','',TRUE,false), |
|
| 741 | + $this->common_model->calculate_currency($row['cost'], '', '', TRUE, false), |
|
| 742 | 742 | /** |
| 743 | 743 | ASTPP 3.0 |
| 744 | 744 | For Add Initial Increment field |
@@ -750,7 +750,7 @@ discard block |
||
| 750 | 750 | $row['strip'], |
| 751 | 751 | $row['prepend'], |
| 752 | 752 | //$row['trunk_id'], |
| 753 | - $this->common->get_field_name('name','trunks',$row["trunk_id"]), |
|
| 753 | + $this->common->get_field_name('name', 'trunks', $row["trunk_id"]), |
|
| 754 | 754 | $this->common->get_status('export', '', $row['status']), |
| 755 | 755 | $row['creation_date'], |
| 756 | 756 | |
@@ -759,7 +759,7 @@ discard block |
||
| 759 | 759 | } |
| 760 | 760 | $this->load->helper('csv'); |
| 761 | 761 | |
| 762 | - array_to_csv($outbound_array, 'Termination_Rates_' . date("Y-m-d") . '.csv'); |
|
| 762 | + array_to_csv($outbound_array, 'Termination_Rates_'.date("Y-m-d").'.csv'); |
|
| 763 | 763 | |
| 764 | 764 | } |
| 765 | 765 | |
@@ -770,13 +770,13 @@ discard block |
||
| 770 | 770 | $this->load->library('pdf'); |
| 771 | 771 | $this->fpdf = new PDF('P', 'pt'); |
| 772 | 772 | $this->fpdf->initialize('P', 'mm', 'A4'); |
| 773 | - $this->fpdf->tablewidths = array(20, 30, 20, 20, 20, 20, 20,20,20); |
|
| 774 | - $outbound_array[] = array("Code", "Destination", "Connect Cost","Included Seconds","Per Minute Cost","Initial Increment", "Increment","Precedence","Prepend","Strip"); |
|
| 773 | + $this->fpdf->tablewidths = array(20, 30, 20, 20, 20, 20, 20, 20, 20); |
|
| 774 | + $outbound_array[] = array("Code", "Destination", "Connect Cost", "Included Seconds", "Per Minute Cost", "Initial Increment", "Increment", "Precedence", "Prepend", "Strip"); |
|
| 775 | 775 | if ($query->num_rows() > 0) { |
| 776 | 776 | |
| 777 | 777 | foreach ($query->result_array() as $row) { |
| 778 | 778 | $outbound_array[] = array( |
| 779 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 779 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 780 | 780 | $row['comment'], |
| 781 | 781 | $row['connectcost'], |
| 782 | 782 | $row['includedseconds'], |
@@ -799,7 +799,7 @@ discard block |
||
| 799 | 799 | |
| 800 | 800 | $this->fpdf->SetFont('Arial', '', 15); |
| 801 | 801 | $this->fpdf->SetXY(60, 5); |
| 802 | - $this->fpdf->Cell(100, 10, "Outbound Rates Report " . date('Y-m-d')); |
|
| 802 | + $this->fpdf->Cell(100, 10, "Outbound Rates Report ".date('Y-m-d')); |
|
| 803 | 803 | |
| 804 | 804 | $this->fpdf->SetY(20); |
| 805 | 805 | $this->fpdf->SetFont('Arial', '', 7); |
@@ -807,29 +807,29 @@ discard block |
||
| 807 | 807 | $this->fpdf->lMargin = 2; |
| 808 | 808 | |
| 809 | 809 | $dimensions = $this->fpdf->export_pdf($outbound_array, "7"); |
| 810 | - $this->fpdf->Output('Termination_Rate_' . date("Y-m-d") . '.pdf', "D"); |
|
| 810 | + $this->fpdf->Output('Termination_Rate_'.date("Y-m-d").'.pdf', "D"); |
|
| 811 | 811 | } |
| 812 | 812 | |
| 813 | 813 | |
| 814 | 814 | function origination_rate_export_cdr_xls() { |
| 815 | 815 | $account_info = $accountinfo = $this->session->userdata('accountinfo'); |
| 816 | - $currency_id=$account_info['currency_id']; |
|
| 817 | - $currency=$this->common->get_field_name('currency', 'currency', $currency_id); |
|
| 816 | + $currency_id = $account_info['currency_id']; |
|
| 817 | + $currency = $this->common->get_field_name('currency', 'currency', $currency_id); |
|
| 818 | 818 | $query = $this->rates_model->get_origination_rate(true, '', '', false); |
| 819 | 819 | //echo "<pre>";print_r($query);exit; |
| 820 | 820 | $inbound_array = array(); |
| 821 | 821 | ob_clean(); |
| 822 | - $inbound_array[] = array("Code", "Destination","Connect Cost($currency)","Included Seconds","Per Minute Cost($currency)", "Initial Increment", "Increment","Rate Group","Status","Created Date"); |
|
| 822 | + $inbound_array[] = array("Code", "Destination", "Connect Cost($currency)", "Included Seconds", "Per Minute Cost($currency)", "Initial Increment", "Increment", "Rate Group", "Status", "Created Date"); |
|
| 823 | 823 | if ($query->num_rows() > 0) { |
| 824 | 824 | |
| 825 | 825 | foreach ($query->result_array() as $row) { |
| 826 | 826 | //echo"<pre>";print_r($row);exit; |
| 827 | 827 | $inbound_array[] = array( |
| 828 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 828 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 829 | 829 | $row['comment'], |
| 830 | - $this->common_model->calculate_currency($row['connectcost'],'','',TRUE,false), |
|
| 830 | + $this->common_model->calculate_currency($row['connectcost'], '', '', TRUE, false), |
|
| 831 | 831 | $row['includedseconds'], |
| 832 | - $this->common_model->calculate_currency($row['cost'],'','',TRUE,false), |
|
| 832 | + $this->common_model->calculate_currency($row['cost'], '', '', TRUE, false), |
|
| 833 | 833 | /** |
| 834 | 834 | ASTPP 3.0 |
| 835 | 835 | For Add Initial Increment field |
@@ -845,7 +845,7 @@ discard block |
||
| 845 | 845 | } |
| 846 | 846 | } |
| 847 | 847 | $this->load->helper('csv'); |
| 848 | - array_to_csv($inbound_array, 'Origination_Rates_' . date("Y-m-d") . '.csv'); |
|
| 848 | + array_to_csv($inbound_array, 'Origination_Rates_'.date("Y-m-d").'.csv'); |
|
| 849 | 849 | } |
| 850 | 850 | function origination_rate_export_cdr_pdf() { |
| 851 | 851 | $query = $this->rates_model->get_origination_rate(true, '', '', false); |
@@ -856,15 +856,15 @@ discard block |
||
| 856 | 856 | $this->fpdf = new PDF('P', 'pt'); |
| 857 | 857 | $this->fpdf->initialize('P', 'mm', 'A4'); |
| 858 | 858 | $this->fpdf->tablewidths = array(20, 20, 20, 20, 20, 20); |
| 859 | - $inbound_array[] = array("Code", "Destination","Connect Cost","Included Seconds","Per Minute Cost","Initial Increment","Increment"); |
|
| 859 | + $inbound_array[] = array("Code", "Destination", "Connect Cost", "Included Seconds", "Per Minute Cost", "Initial Increment", "Increment"); |
|
| 860 | 860 | if ($query->num_rows() > 0) { |
| 861 | 861 | foreach ($query->result_array() as $row) { |
| 862 | 862 | $inbound_array[] = array( |
| 863 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 863 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 864 | 864 | $row['comment'], |
| 865 | 865 | $row['connectcost'], |
| 866 | 866 | $row['includedseconds'], |
| 867 | - $this->common_model->calculate_currency($row['cost'],'','','',false), |
|
| 867 | + $this->common_model->calculate_currency($row['cost'], '', '', '', false), |
|
| 868 | 868 | /** |
| 869 | 869 | ASTPP 3.0 |
| 870 | 870 | For Add Initial Increment field |
@@ -880,7 +880,7 @@ discard block |
||
| 880 | 880 | |
| 881 | 881 | $this->fpdf->SetFont('Arial', '', 15); |
| 882 | 882 | $this->fpdf->SetXY(60, 5); |
| 883 | - $this->fpdf->Cell(100, 10, "Origination Rates Report " . date('Y-m-d')); |
|
| 883 | + $this->fpdf->Cell(100, 10, "Origination Rates Report ".date('Y-m-d')); |
|
| 884 | 884 | |
| 885 | 885 | $this->fpdf->SetY(20); |
| 886 | 886 | $this->fpdf->SetFont('Arial', '', 7); |
@@ -888,7 +888,7 @@ discard block |
||
| 888 | 888 | $this->fpdf->lMargin = 2; |
| 889 | 889 | |
| 890 | 890 | $dimensions = $this->fpdf->export_pdf($inbound_array, "5"); |
| 891 | - $this->fpdf->Output('Origination_Rate_' . date("Y-m-d") . '.pdf', "D"); |
|
| 891 | + $this->fpdf->Output('Origination_Rate_'.date("Y-m-d").'.pdf', "D"); |
|
| 892 | 892 | } |
| 893 | 893 | |
| 894 | 894 | |
@@ -900,14 +900,14 @@ discard block |
||
| 900 | 900 | $this->fpdf = new PDF('P', 'pt'); |
| 901 | 901 | $this->fpdf->initialize('P', 'mm', 'A4'); |
| 902 | 902 | $this->fpdf->tablewidths = array(20, 20, 20, 20, 20, 20); |
| 903 | - $inbound_array[] = array("Code", "Destination", "Increment","Cost Per Minutes", "Connect Charge", "Included Seconds"); |
|
| 903 | + $inbound_array[] = array("Code", "Destination", "Increment", "Cost Per Minutes", "Connect Charge", "Included Seconds"); |
|
| 904 | 904 | if ($query->num_rows() > 0) { |
| 905 | 905 | foreach ($query->result_array() as $row) { |
| 906 | 906 | $inbound_array[] = array( |
| 907 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 907 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 908 | 908 | $row['comment'], |
| 909 | 909 | $row['inc'], |
| 910 | - $this->common_model->calculate_currency($row['cost'],'','','',false), |
|
| 910 | + $this->common_model->calculate_currency($row['cost'], '', '', '', false), |
|
| 911 | 911 | $row['connectcost'], |
| 912 | 912 | $row['includedseconds'] |
| 913 | 913 | ); |
@@ -919,7 +919,7 @@ discard block |
||
| 919 | 919 | |
| 920 | 920 | $this->fpdf->SetFont('Arial', '', 15); |
| 921 | 921 | $this->fpdf->SetXY(60, 5); |
| 922 | - $this->fpdf->Cell(100, 10, "Rates Report " . date('Y-m-d')); |
|
| 922 | + $this->fpdf->Cell(100, 10, "Rates Report ".date('Y-m-d')); |
|
| 923 | 923 | |
| 924 | 924 | $this->fpdf->SetY(20); |
| 925 | 925 | $this->fpdf->SetFont('Arial', '', 7); |
@@ -927,12 +927,12 @@ discard block |
||
| 927 | 927 | $this->fpdf->lMargin = 2; |
| 928 | 928 | |
| 929 | 929 | $dimensions = $this->fpdf->export_pdf($inbound_array, "5"); |
| 930 | - $this->fpdf->Output('Rates_' . date("Y-m-d") . '.pdf', "D"); |
|
| 930 | + $this->fpdf->Output('Rates_'.date("Y-m-d").'.pdf', "D"); |
|
| 931 | 931 | } |
| 932 | - function resellersrates_list(){ |
|
| 933 | - $accountinfo=$this->session->userdata('accountinfo'); |
|
| 932 | + function resellersrates_list() { |
|
| 933 | + $accountinfo = $this->session->userdata('accountinfo'); |
|
| 934 | 934 | $data['username'] = $this->session->userdata('user_name'); |
| 935 | - $data['page_title'] = 'My Rates' ; |
|
| 935 | + $data['page_title'] = 'My Rates'; |
|
| 936 | 936 | $data['search_flag'] = true; |
| 937 | 937 | $this->session->set_userdata('advance_search', 0); |
| 938 | 938 | $data['grid_fields'] = $this->rates_form->build_rates_list_for_reseller(); |
@@ -952,11 +952,11 @@ discard block |
||
| 952 | 952 | $grid_fields = json_decode($this->rates_form->build_rates_list_for_reseller()); |
| 953 | 953 | foreach ($query->result_array() as $key => $value) { |
| 954 | 954 | $json_data['rows'][] = array('cell' => array( |
| 955 | - $this->common->get_only_numeric_val("","",$value["pattern"]), |
|
| 955 | + $this->common->get_only_numeric_val("", "", $value["pattern"]), |
|
| 956 | 956 | $value['comment'], |
| 957 | - $this->common_model->calculate_currency($value['connectcost'],'','','true',true), |
|
| 957 | + $this->common_model->calculate_currency($value['connectcost'], '', '', 'true', true), |
|
| 958 | 958 | $value['includedseconds'], |
| 959 | - $this->common_model->calculate_currency(($value['cost'] + ($value['cost']*$markup)/100),'','','true',true), |
|
| 959 | + $this->common_model->calculate_currency(($value['cost'] + ($value['cost'] * $markup) / 100), '', '', 'true', true), |
|
| 960 | 960 | $value['inc'], |
| 961 | 961 | $value['precedence'], |
| 962 | 962 | )); |
@@ -976,7 +976,7 @@ discard block |
||
| 976 | 976 | $this->session->set_userdata('resellerrates_list_search', $action); |
| 977 | 977 | } |
| 978 | 978 | if (@$ajax_search != 1) { |
| 979 | - redirect(base_url() . 'rates/resellersrates_list/'); |
|
| 979 | + redirect(base_url().'rates/resellersrates_list/'); |
|
| 980 | 980 | } |
| 981 | 981 | } |
| 982 | 982 | function resellersrates_list_clearsearchfilter() { |
@@ -1000,7 +1000,7 @@ discard block |
||
| 1000 | 1000 | foreach ($query->result_array() as $row) { |
| 1001 | 1001 | |
| 1002 | 1002 | $customer_array[] = array( |
| 1003 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 1003 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 1004 | 1004 | $row['comment'], |
| 1005 | 1005 | $row['connectcost'], |
| 1006 | 1006 | $row['includedseconds'], |
@@ -1012,7 +1012,7 @@ discard block |
||
| 1012 | 1012 | } |
| 1013 | 1013 | } |
| 1014 | 1014 | $this->load->helper('csv'); |
| 1015 | - array_to_csv($customer_array, 'My_Own_Rate_' . date("Y-m-d") . '.csv'); |
|
| 1015 | + array_to_csv($customer_array, 'My_Own_Rate_'.date("Y-m-d").'.csv'); |
|
| 1016 | 1016 | exit; |
| 1017 | 1017 | } |
| 1018 | 1018 | /*********** |
@@ -1029,7 +1029,7 @@ discard block |
||
| 1029 | 1029 | $this->session->set_userdata('termination_rates_list_search', $action); |
| 1030 | 1030 | } |
| 1031 | 1031 | if (@$ajax_search != 1) { |
| 1032 | - redirect(base_url() . 'rates/termination_rates_list/'); |
|
| 1032 | + redirect(base_url().'rates/termination_rates_list/'); |
|
| 1033 | 1033 | } |
| 1034 | 1034 | } |
| 1035 | 1035 | function origination_rates_list_batch_delete() { |
@@ -1042,7 +1042,7 @@ discard block |
||
| 1042 | 1042 | $this->session->set_userdata('origination_rate_list_search', $action); |
| 1043 | 1043 | } |
| 1044 | 1044 | if (@$ajax_search != 1) { |
| 1045 | - redirect(base_url() . 'rates/origination_rates_list/'); |
|
| 1045 | + redirect(base_url().'rates/origination_rates_list/'); |
|
| 1046 | 1046 | } |
| 1047 | 1047 | } |
| 1048 | 1048 | /*************************/ |
@@ -34,8 +34,9 @@ discard block |
||
| 34 | 34 | $this->load->library('csvreader'); |
| 35 | 35 | ini_set("memory_limit","2048M"); |
| 36 | 36 | ini_set("max_execution_time","259200"); |
| 37 | - if ($this->session->userdata('user_login') == FALSE) |
|
| 38 | - redirect(base_url() . '/astpp/login'); |
|
| 37 | + if ($this->session->userdata('user_login') == FALSE) { |
|
| 38 | + redirect(base_url() . '/astpp/login'); |
|
| 39 | + } |
|
| 39 | 40 | } |
| 40 | 41 | |
| 41 | 42 | function termination_rates_list() { |
@@ -109,18 +110,17 @@ discard block |
||
| 109 | 110 | $data['check_header']=$check_header; |
| 110 | 111 | $data['page_title'] = 'Termination Rates Preview'; |
| 111 | 112 | $this->session->set_userdata('import_termination_rate_csv',$actual_file_name); |
| 112 | - }else{ |
|
| 113 | + } else{ |
|
| 113 | 114 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 114 | 115 | } |
| 115 | 116 | } |
| 116 | - } |
|
| 117 | - else{ |
|
| 117 | + } else{ |
|
| 118 | 118 | $data['error']=="File Uploading Fail Please Try Again"; |
| 119 | 119 | } |
| 120 | - }else { |
|
| 120 | + } else { |
|
| 121 | 121 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 122 | 122 | } |
| 123 | - }else{ |
|
| 123 | + } else{ |
|
| 124 | 124 | $invalid_flag=true; |
| 125 | 125 | } |
| 126 | 126 | if ($invalid_flag) { |
@@ -163,8 +163,7 @@ discard block |
||
| 163 | 163 | if($str != ""){ |
| 164 | 164 | $invalid_array[$i]=$csv_data; |
| 165 | 165 | $invalid_array[$i]['error'] = $str; |
| 166 | - } |
|
| 167 | - else{ |
|
| 166 | + } else{ |
|
| 168 | 167 | $csv_data['trunk_id']=$trunkID; |
| 169 | 168 | $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
| 170 | 169 | $new_final_arr[$i]=$csv_data; |
@@ -252,19 +251,17 @@ discard block |
||
| 252 | 251 | $data['page_title'] = "Origination Rates Preview"; |
| 253 | 252 | $data['check_header']=$check_header; |
| 254 | 253 | $this->session->set_userdata('import_origination_rate_csv',$actual_file_name); |
| 255 | - }else{ |
|
| 254 | + } else{ |
|
| 256 | 255 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 257 | 256 | } |
| 258 | 257 | } |
| 259 | - } |
|
| 260 | - else{ |
|
| 258 | + } else{ |
|
| 261 | 259 | $data['error']=="File Uploading Fail Please Try Again"; |
| 262 | 260 | } |
| 263 | - } |
|
| 264 | - else { |
|
| 261 | + } else { |
|
| 265 | 262 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 266 | 263 | } |
| 267 | - }else{ |
|
| 264 | + } else{ |
|
| 268 | 265 | $invalid_flag=true; |
| 269 | 266 | } |
| 270 | 267 | if ($invalid_flag) { |
@@ -308,8 +305,7 @@ discard block |
||
| 308 | 305 | if($str != ""){ |
| 309 | 306 | $invalid_array[$i]=$csv_data; |
| 310 | 307 | $invalid_array[$i]['error'] = $str; |
| 311 | - } |
|
| 312 | - else{ |
|
| 308 | + } else{ |
|
| 313 | 309 | $csv_data['pricelist_id']=$pricelistID; |
| 314 | 310 | $csv_data['trunk_id']=$trunkid; |
| 315 | 311 | $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
@@ -371,12 +367,10 @@ discard block |
||
| 371 | 367 | $count = count($error_field); |
| 372 | 368 | $str.= $count > 1 ? ' are not valid' : ' is not Valid'; |
| 373 | 369 | return $str; |
| 374 | - } |
|
| 375 | - else{ |
|
| 370 | + } else{ |
|
| 376 | 371 | return false; |
| 377 | 372 | } |
| 378 | - } |
|
| 379 | - else{ |
|
| 373 | + } else{ |
|
| 380 | 374 | $str=rtrim($str,','); |
| 381 | 375 | $error_field=explode(',',$str); |
| 382 | 376 | $count = count($error_field); |
@@ -617,13 +611,15 @@ discard block |
||
| 617 | 611 | $where = array('accountid' => $accountid); |
| 618 | 612 | $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_pattern'); |
| 619 | 613 | $like_str=!empty($instant_search) ? "(blocked_patterns like '%$instant_search%' OR destination like '%$instant_search%' )" :null; |
| 620 | - if(!empty($like_str)) |
|
| 621 | - $this->db->where($like_str); |
|
| 614 | + if(!empty($like_str)) { |
|
| 615 | + $this->db->where($like_str); |
|
| 616 | + } |
|
| 622 | 617 | $count_all = $this->db_model->countQuery("*", "block_patterns", $where); |
| 623 | 618 | $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
| 624 | 619 | $json_data = $paging_data["json_paging"]; |
| 625 | - if(!empty($like_str)) |
|
| 626 | - $this->db->where($like_str); |
|
| 620 | + if(!empty($like_str)) { |
|
| 621 | + $this->db->where($like_str); |
|
| 622 | + } |
|
| 627 | 623 | $pattern_data = $this->db_model->getSelect("*", "block_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]); |
| 628 | 624 | $grid_fields = json_decode($this->rates_form->build_pattern_list_for_customer($accountid,$accounttype)); |
| 629 | 625 | $json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields); |
@@ -20,7 +20,7 @@ discard block |
||
| 20 | 20 | # You should have received a copy of the GNU Affero General Public License |
| 21 | 21 | # along with this program. If not, see <http://www.gnu.org/licenses/>. |
| 22 | 22 | ############################################################################### |
| 23 | -if (!defined('BASEPATH'))
|
|
| 23 | +if ( ! defined('BASEPATH'))
|
|
| 24 | 24 | exit('No direct script access allowed');
|
| 25 | 25 | |
| 26 | 26 | class rates_form {
|
@@ -28,29 +28,29 @@ discard block |
||
| 28 | 28 | $this->CI = & get_instance(); |
| 29 | 29 | } |
| 30 | 30 | function get_termination_rate_form_fields() {
|
| 31 | - $form['forms'] = array(base_url() . 'rates/termination_rate_save/', array('id' => 'termination_rate_form', 'method' => 'POST', 'name' => 'termination_rate_form'));
|
|
| 31 | + $form['forms'] = array(base_url().'rates/termination_rate_save/', array('id' => 'termination_rate_form', 'method' => 'POST', 'name' => 'termination_rate_form'));
|
|
| 32 | 32 | $form['Rate Information'] = array( |
| 33 | 33 | array('', 'HIDDEN', array('name' => 'id'), '', '', '', ''),
|
| 34 | 34 | array('Trunk', 'trunk_id', 'SELECT', '', 'dropdown', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0")),
|
| 35 | - array('Code', 'INPUT', array('name' => 'pattern', 'size' => '20', 'class' => "text field medium"), 'trim|required|numeric|xss_clean', 'tOOL TIP', ''),
|
|
| 36 | - array('Destination', 'INPUT', array('name' => 'comment', 'size' => '20', 'class' => "text field medium"), 'tOOL TIP', ''),
|
|
| 37 | - array('Strip', 'INPUT', array('name' => 'strip', 'size' => '20', 'class' => "text field medium"), '', 'tOOL TIP', ''),
|
|
| 38 | - array('Prepend', 'INPUT', array('name' => 'prepend', 'size' => '20', 'class' => "text field medium"), 'trim|xss_clean', 'tOOL TIP', ''),
|
|
| 35 | + array('Code', 'INPUT', array('name' => 'pattern', 'size' => '20', 'class' => "text field medium"), 'trim|required|numeric|xss_clean', 'tOOL TIP', ''),
|
|
| 36 | + array('Destination', 'INPUT', array('name' => 'comment', 'size' => '20', 'class' => "text field medium"), 'tOOL TIP', ''),
|
|
| 37 | + array('Strip', 'INPUT', array('name' => 'strip', 'size' => '20', 'class' => "text field medium"), '', 'tOOL TIP', ''),
|
|
| 38 | + array('Prepend', 'INPUT', array('name' => 'prepend', 'size' => '20', 'class' => "text field medium"), 'trim|xss_clean', 'tOOL TIP', ''),
|
|
| 39 | 39 | array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_status'),
|
| 40 | 40 | |
| 41 | 41 | |
| 42 | 42 | ); |
| 43 | 43 | $form['Billing Information'] = array( |
| 44 | - array('Connect Cost', 'INPUT', array('name' => 'connectcost', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|currency_decimal|xss_clean', 'tOOL TIP', ''),
|
|
| 44 | + array('Connect Cost', 'INPUT', array('name' => 'connectcost', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|currency_decimal|xss_clean', 'tOOL TIP', ''),
|
|
| 45 | 45 | array('Included Seconds', 'INPUT', array('name' => 'includedseconds', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''),
|
| 46 | 46 | array('Per Minute Cost', 'INPUT', array('name' => 'cost', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|currency_decimal|xss_clean', 'tOOL TIP', ''),
|
| 47 | 47 | /** |
| 48 | 48 | ASTPP 3.0 |
| 49 | 49 | For Add Initial Increment field |
| 50 | 50 | **/ |
| 51 | - array('Initial Increment', 'INPUT', array('name' => 'init_inc', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''),
|
|
| 51 | + array('Initial Increment', 'INPUT', array('name' => 'init_inc', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''),
|
|
| 52 | 52 | /*******************************************************/ |
| 53 | - array('Increment', 'INPUT', array('name' => 'inc', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''),
|
|
| 53 | + array('Increment', 'INPUT', array('name' => 'inc', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''),
|
|
| 54 | 54 | array('Priority', 'INPUT', array('name' => 'precedence', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''));
|
| 55 | 55 | |
| 56 | 56 | $form['button_cancel'] = array('name' => 'action', 'content' => 'Close', 'value' => 'cancel', 'type' => 'button', 'class' => 'btn btn-line-sky margin-x-10', 'onclick' => 'return redirect_page(\'NULL\')');
|
@@ -60,14 +60,14 @@ discard block |
||
| 60 | 60 | } |
| 61 | 61 | |
| 62 | 62 | function get_origination_rate_form_fields() {
|
| 63 | - $logintype=$this->CI->session->userdata('userlevel_logintype');
|
|
| 64 | - $trunk=null; |
|
| 65 | - if($logintype !=1) |
|
| 63 | + $logintype = $this->CI->session->userdata('userlevel_logintype');
|
|
| 64 | + $trunk = null; |
|
| 65 | + if ($logintype != 1) |
|
| 66 | 66 | $trunk = array('Force Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0"));
|
| 67 | - $form['forms'] = array(base_url() . 'rates/origination_rate_save/', array('id' => 'origination_rate_form', 'method' => 'POST', 'name' => 'origination_rate_form'));
|
|
| 67 | + $form['forms'] = array(base_url().'rates/origination_rate_save/', array('id' => 'origination_rate_form', 'method' => 'POST', 'name' => 'origination_rate_form'));
|
|
| 68 | 68 | $form['Rate Information'] = array( |
| 69 | 69 | array('', 'HIDDEN', array('name' => 'id'), '', '', '', ''),
|
| 70 | - array('Rate Group', 'pricelist_id', 'SELECT', '','', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0",'reseller_id'=>0)),
|
|
| 70 | + array('Rate Group', 'pricelist_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0", 'reseller_id'=>0)),
|
|
| 71 | 71 | array('Code', 'INPUT', array('name' => 'pattern', 'size' => '20', 'class' => "text field medium"), 'trim|required|numeric|xss_clean', 'tOOL TIP', ''),
|
| 72 | 72 | array('Destination', 'INPUT', array('name' => 'comment', 'size' => '20', 'class' => "text field medium"), 'tOOL TIP', ''),
|
| 73 | 73 | //array('Priority', 'INPUT', array('name' => 'precedence', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''),
|
@@ -75,9 +75,9 @@ discard block |
||
| 75 | 75 | |
| 76 | 76 | ); |
| 77 | 77 | $form['Billing Information'] = array( |
| 78 | - array('Connect Cost', 'INPUT', array('name' => 'connectcost', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|currency_decimal|xss_clean', 'tOOL TIP', ''),
|
|
| 79 | - array('Included Seconds', 'INPUT', array('name' => 'includedseconds', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''),
|
|
| 80 | - array('Per Minute Cost', 'INPUT', array('name' => 'cost', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|currency_decimal|xss_clean', 'tOOL TIP', ''),
|
|
| 78 | + array('Connect Cost', 'INPUT', array('name' => 'connectcost', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|currency_decimal|xss_clean', 'tOOL TIP', ''),
|
|
| 79 | + array('Included Seconds', 'INPUT', array('name' => 'includedseconds', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|xss_clean', 'tOOL TIP', ''),
|
|
| 80 | + array('Per Minute Cost', 'INPUT', array('name' => 'cost', 'size' => '20', 'class' => "text field medium"), 'trim|numeric|currency_decimal|xss_clean', 'tOOL TIP', ''),
|
|
| 81 | 81 | /** |
| 82 | 82 | ASTPP 3.0 |
| 83 | 83 | For Add Initial Increment field |
@@ -113,7 +113,7 @@ discard block |
||
| 113 | 113 | /***************************************************************/ |
| 114 | 114 | array('Increment', 'INPUT', array('name' => 'inc[inc]', '', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', 'inc[inc-integer]', '', '', '', 'search_int_type', ''),
|
| 115 | 115 | array('Priority', 'INPUT', array('name' => 'prepend[prepend]', '', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', 'prepend[prepend-string]', '', '', '', 'search_string_type', ''),
|
| 116 | - array('Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0")),array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),
|
|
| 116 | + array('Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0")), array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),
|
|
| 117 | 117 | array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_search_status', '', ''),
|
| 118 | 118 | /****** |
| 119 | 119 | ASTPP 3.0 |
@@ -129,14 +129,14 @@ discard block |
||
| 129 | 129 | ASTPP 3.0 |
| 130 | 130 | Batch Delete |
| 131 | 131 | ******/ |
| 132 | - $form['button_search_delete'] = array('name' => 'action', 'id' => "termination_rate_batch_dlt",'onclick'=>"check_btn();", 'content' => 'Delete Search Record','style'=>'display:none;', 'value' => 'submit', 'type' => 'button', 'class' => 'btn pull-right btn btn-line-danger ');
|
|
| 132 | + $form['button_search_delete'] = array('name' => 'action', 'id' => "termination_rate_batch_dlt", 'onclick'=>"check_btn();", 'content' => 'Delete Search Record', 'style'=>'display:none;', 'value' => 'submit', 'type' => 'button', 'class' => 'btn pull-right btn btn-line-danger ');
|
|
| 133 | 133 | |
| 134 | 134 | /***********************/ |
| 135 | 135 | /****** |
| 136 | 136 | ASTPP 3.0 |
| 137 | 137 | Batch Delete |
| 138 | 138 | ******/ |
| 139 | - $form['button_search'] = array('name' => 'action', 'id' => "termination_rate_search_btn",'onclick'=>'search_btn();', 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right margin-x-10');
|
|
| 139 | + $form['button_search'] = array('name' => 'action', 'id' => "termination_rate_search_btn", 'onclick'=>'search_btn();', 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right margin-x-10');
|
|
| 140 | 140 | /***********************/ |
| 141 | 141 | $form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear', 'value' => 'cancel', 'type' => 'reset', 'class' => 'btn btn-line-sky pull-right margin-x-10');
|
| 142 | 142 | |
@@ -147,14 +147,14 @@ discard block |
||
| 147 | 147 | function termination_rate_batch_update_form() {
|
| 148 | 148 | $form['forms'] = array("rates/termination_rate_batch_update/", array('id' => "termination_rate_batch_update"));
|
| 149 | 149 | $form['Batch Update'] = array( |
| 150 | - array('Connect Cost', 'INPUT', array('name' => 'connectcost[connectcost]','id'=>'connectcost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'connectcost[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 151 | - array('Included Seconds', 'INPUT', array('name' => 'includedseconds[includedseconds]','id'=>'includedseconds', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'includedseconds[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 152 | - array('Per Minute Cost', 'INPUT', array('name' => 'cost[cost]','id'=>'cost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'cost[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 150 | + array('Connect Cost', 'INPUT', array('name' => 'connectcost[connectcost]', 'id'=>'connectcost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'connectcost[operator]', 'class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 151 | + array('Included Seconds', 'INPUT', array('name' => 'includedseconds[includedseconds]', 'id'=>'includedseconds', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'includedseconds[operator]', 'class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 152 | + array('Per Minute Cost', 'INPUT', array('name' => 'cost[cost]', 'id'=>'cost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'cost[operator]', 'class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 153 | 153 | |
| 154 | - array('Increment', 'INPUT', array('name' => 'inc[inc]','id'=>'inc', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', array('name'=>'inc[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 155 | - array('Priority', 'INPUT', array('name' => 'precedence[precedence]','id'=>'precedence', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', array('name'=>'precedence[operator]','class'=>'update_drp'), '', '', '', 'update_drp_type', ''),
|
|
| 156 | - array('Prepand', 'INPUT', array('name' => 'prepend[prepend]','id'=>'prepend', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', array('name'=>'prepend[operator]','class'=>'update_drp'), '', '', '', 'update_drp_type', ''),
|
|
| 157 | - array('Trunk', array('name'=> 'trunk_id[trunk_id]','id'=>'trunk_id'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0"),array('name'=>'trunk_id[operator]','class'=>'update_drp'), 'update_drp_type'),
|
|
| 154 | + array('Increment', 'INPUT', array('name' => 'inc[inc]', 'id'=>'inc', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', array('name'=>'inc[operator]', 'class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 155 | + array('Priority', 'INPUT', array('name' => 'precedence[precedence]', 'id'=>'precedence', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', array('name'=>'precedence[operator]', 'class'=>'update_drp'), '', '', '', 'update_drp_type', ''),
|
|
| 156 | + array('Prepand', 'INPUT', array('name' => 'prepend[prepend]', 'id'=>'prepend', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', array('name'=>'prepend[operator]', 'class'=>'update_drp'), '', '', '', 'update_drp_type', ''),
|
|
| 157 | + array('Trunk', array('name'=> 'trunk_id[trunk_id]', 'id'=>'trunk_id'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0"), array('name'=>'trunk_id[operator]', 'class'=>'update_drp'), 'update_drp_type'),
|
|
| 158 | 158 | ); |
| 159 | 159 | |
| 160 | 160 | $form['button_search'] = array('name' => 'action', 'id' => "batch_update_btn", 'content' => 'Update', 'value' => 'save', 'type' => 'button', 'class' =>'btn btn-line-parrot pull-right');
|
@@ -163,17 +163,17 @@ discard block |
||
| 163 | 163 | return $form; |
| 164 | 164 | } |
| 165 | 165 | function origination_rate_batch_update_form() {
|
| 166 | - $logintype=$this->CI->session->userdata('userlevel_logintype');
|
|
| 167 | - $trunk=null; |
|
| 168 | - if($logintype !=1) |
|
| 169 | - $trunk = array('Force Trunk', array('name'=> 'trunk_id[trunk_id]','id'=>'trunk_id'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0"),array('name'=>'trunk_id[operator]','class'=>'update_drp'), 'update_drp_type');
|
|
| 170 | - $form['forms'] = array("rates/origination_rate_batch_update/",array('id' => "origination_rate_batch_update"));
|
|
| 166 | + $logintype = $this->CI->session->userdata('userlevel_logintype');
|
|
| 167 | + $trunk = null; |
|
| 168 | + if ($logintype != 1) |
|
| 169 | + $trunk = array('Force Trunk', array('name'=> 'trunk_id[trunk_id]', 'id'=>'trunk_id'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0"), array('name'=>'trunk_id[operator]', 'class'=>'update_drp'), 'update_drp_type');
|
|
| 170 | + $form['forms'] = array("rates/origination_rate_batch_update/", array('id' => "origination_rate_batch_update"));
|
|
| 171 | 171 | $form['Batch Update'] = array( |
| 172 | - array('Connect Cost', 'INPUT', array('name' => 'connectcost[connectcost]','id'=>'connectcost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'connectcost[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 173 | - array('Included Seconds', 'INPUT', array('name' => 'includedseconds[includedseconds]','id'=>'includedseconds', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1',array('name'=>'includedseconds[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 174 | - array('Per Minute Cost', 'INPUT', array('name' => 'cost[cost]', 'id'=>'cost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1',array('name'=>'cost[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 175 | - array('Increment', 'INPUT', array('name' => 'inc[inc]', 'id'=>'inc', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', array('name'=>'inc[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 176 | - array('Rate Group', array('name'=> 'pricelist_id[pricelist_id]','id'=>'pricelist_id'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0","reseller_id" => "0"),array('name'=>'pricelist_id[operator]','class'=>'update_drp'), 'update_drp_type'),
|
|
| 172 | + array('Connect Cost', 'INPUT', array('name' => 'connectcost[connectcost]', 'id'=>'connectcost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'connectcost[operator]', 'class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 173 | + array('Included Seconds', 'INPUT', array('name' => 'includedseconds[includedseconds]', 'id'=>'includedseconds', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'includedseconds[operator]', 'class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 174 | + array('Per Minute Cost', 'INPUT', array('name' => 'cost[cost]', 'id'=>'cost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'cost[operator]', 'class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 175 | + array('Increment', 'INPUT', array('name' => 'inc[inc]', 'id'=>'inc', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', array('name'=>'inc[operator]', 'class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
|
| 176 | + array('Rate Group', array('name'=> 'pricelist_id[pricelist_id]', 'id'=>'pricelist_id'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0", "reseller_id" => "0"), array('name'=>'pricelist_id[operator]', 'class'=>'update_drp'), 'update_drp_type'),
|
|
| 177 | 177 | $trunk, |
| 178 | 178 | ); |
| 179 | 179 | |
@@ -186,21 +186,21 @@ discard block |
||
| 186 | 186 | function build_rates_list_for_reseller() {
|
| 187 | 187 | |
| 188 | 188 | $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');
|
| 189 | -$currency_id=$account_info['currency_id']; |
|
| 190 | -$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 189 | +$currency_id = $account_info['currency_id']; |
|
| 190 | +$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 191 | 191 | |
| 192 | - $grid_field_arr = json_encode(array(array('Code', "140", "pattern", "pattern", "", "get_only_numeric_val","","true","center"),
|
|
| 192 | + $grid_field_arr = json_encode(array(array('Code', "140", "pattern", "pattern", "", "get_only_numeric_val", "", "true", "center"),
|
|
| 193 | 193 | array('Destination', "240", "comment", "", "", ""),
|
| 194 | - array('Connection Cost('.$currency.')', "210", "connectcost", "connectcost", "connectcost", "convert_to_currency","","true","right"),
|
|
| 195 | - array('Included Seconds', "180", "includedseconds", "", "", "","","true","center"),
|
|
| 196 | - array('Per Minute Cost('.$currency.')', "180", "cost", "cost", "cost", "convert_to_currency","","true","right"),
|
|
| 197 | - array('Increment', "140", "inc", "", "", "","","true","center"),
|
|
| 198 | - array('Priority', "155", "precedence", "", "", "","","true","center"),
|
|
| 194 | + array('Connection Cost('.$currency.')', "210", "connectcost", "connectcost", "connectcost", "convert_to_currency", "", "true", "right"),
|
|
| 195 | + array('Included Seconds', "180", "includedseconds", "", "", "", "", "true", "center"),
|
|
| 196 | + array('Per Minute Cost('.$currency.')', "180", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),
|
|
| 197 | + array('Increment', "140", "inc", "", "", "", "", "true", "center"),
|
|
| 198 | + array('Priority', "155", "precedence", "", "", "", "", "true", "center"),
|
|
| 199 | 199 | )); |
| 200 | 200 | return $grid_field_arr; |
| 201 | 201 | } |
| 202 | 202 | function get_reseller_origination_rate_search_form() {
|
| 203 | - $accountinfo=$this->CI->session->userdata('accountinfo');
|
|
| 203 | + $accountinfo = $this->CI->session->userdata('accountinfo');
|
|
| 204 | 204 | |
| 205 | 205 | $form['forms'] = array("", array('id' => "resellerrates_list_search"));
|
| 206 | 206 | $form['Search My Rates'] = array( |
@@ -236,7 +236,7 @@ discard block |
||
| 236 | 236 | array('Initial Increment', 'INPUT', array('name' => 'init_inc[init_inc]', '', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', 'init_inc[init_inc-integer]', '', '', '', 'search_int_type', ''),
|
| 237 | 237 | /**************************************************************/ |
| 238 | 238 | array('Increment', 'INPUT', array('name' => 'inc[inc]', '', 'size' => '20', 'class' => "text field "), '', 'tOOL TIP', '1', 'inc[inc-integer]', '', '', '', 'search_int_type', ''),
|
| 239 | - array('Rate Group', 'pricelist_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0","reseller_id"=>"0")),
|
|
| 239 | + array('Rate Group', 'pricelist_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'pricelists', 'build_dropdown', 'where_arr', array("status" => "0", "reseller_id"=>"0")),
|
|
| 240 | 240 | array('Status', 'status', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', '', '', '', 'set_search_status', '', ''),
|
| 241 | 241 | array('', 'HIDDEN', 'ajax_search', '1', '', '', ''),
|
| 242 | 242 | array('', 'HIDDEN', 'advance_search', '1', '', '', ''),
|
@@ -245,14 +245,14 @@ discard block |
||
| 245 | 245 | ASTPP 3.0 |
| 246 | 246 | Batch Delete |
| 247 | 247 | ******/ |
| 248 | - $form['button_search_delete'] = array('name' => 'action', 'id' => "origination_rate_batch_dlt",'onclick'=>"check_btn();", 'content' => 'Delete Search Record','style'=>'display:none;', 'value' => 'save', 'type' => 'button', 'class' => 'btn pull-right btn btn-line-danger ');
|
|
| 248 | + $form['button_search_delete'] = array('name' => 'action', 'id' => "origination_rate_batch_dlt", 'onclick'=>"check_btn();", 'content' => 'Delete Search Record', 'style'=>'display:none;', 'value' => 'save', 'type' => 'button', 'class' => 'btn pull-right btn btn-line-danger ');
|
|
| 249 | 249 | |
| 250 | 250 | /***********************/ |
| 251 | 251 | /******** |
| 252 | 252 | ASTPP 3.0 |
| 253 | 253 | Batch delete |
| 254 | 254 | *********/ |
| 255 | - $form['button_search'] = array('name' => 'action', 'id' => "origination_rate_list_search_btn",'onclick'=>'search_btn();', 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right margin-x-10');
|
|
| 255 | + $form['button_search'] = array('name' => 'action', 'id' => "origination_rate_list_search_btn", 'onclick'=>'search_btn();', 'content' => 'Search', 'value' => 'save', 'type' => 'button', 'class' => 'btn btn-line-parrot pull-right margin-x-10');
|
|
| 256 | 256 | /**************************/ |
| 257 | 257 | $form['button_reset'] = array('name' => 'action', 'id' => "id_reset", 'content' => 'Clear', 'value' => 'cancel', 'type' => 'reset', 'class' => 'btn btn-line-sky pull-right margin-x-10');
|
| 258 | 258 | |
@@ -268,34 +268,34 @@ discard block |
||
| 268 | 268 | |
| 269 | 269 | function build_termination_rate_for_admin() {
|
| 270 | 270 | $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');
|
| 271 | -$currency_id=$account_info['currency_id']; |
|
| 272 | -$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 271 | +$currency_id = $account_info['currency_id']; |
|
| 272 | +$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 273 | 273 | |
| 274 | 274 | // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name); |
| 275 | - $grid_field_arr = json_encode(array(array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "","","false","center"),
|
|
| 275 | + $grid_field_arr = json_encode(array(array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center"),
|
|
| 276 | 276 | /** |
| 277 | 277 | ASTPP 3.0 |
| 278 | 278 | For Termination Rate edit on Code |
| 279 | 279 | **/ |
| 280 | - array("Code", "78", "pattern", "pattern", "", "get_only_numeric_val","EDITABLE","true","center"),
|
|
| 280 | + array("Code", "78", "pattern", "pattern", "", "get_only_numeric_val", "EDITABLE", "true", "center"),
|
|
| 281 | 281 | /*********************************/ |
| 282 | - array("Destination", "80", "comment", "", "", "","","true","center"),
|
|
| 283 | - array("Connect Cost($currency)", "125", "connectcost", "connectcost", "connectcost", "convert_to_currency","","true","right"),
|
|
| 284 | - array("Included<br/> Seconds", "70", "includedseconds", "", "", "","","true","center"),
|
|
| 285 | - array("Per Minute <br/>Cost($currency)", "100", "cost", "cost", "cost", "convert_to_currency","","true","right"),
|
|
| 286 | - array("Initial <br/> Increment", "95", "init_inc", "", "", "","","true","center"),
|
|
| 287 | - array("Increment", "75", "inc", "", "", "","","true","center"),
|
|
| 288 | - array("Priority", "70", "precedence", "", "", "","","true","center"),
|
|
| 289 | - array("Strip","60", "strip", "", "", "","","true","center"),
|
|
| 290 | - array("Prepend", "70", "prepend", "pattern", "", "get_only_numeric_val","","true","center"),
|
|
| 291 | - array("Trunk", "80", "trunk_id", "name", "trunks", "get_field_name","","true","center"),
|
|
| 282 | + array("Destination", "80", "comment", "", "", "", "", "true", "center"),
|
|
| 283 | + array("Connect Cost($currency)", "125", "connectcost", "connectcost", "connectcost", "convert_to_currency", "", "true", "right"),
|
|
| 284 | + array("Included<br/> Seconds", "70", "includedseconds", "", "", "", "", "true", "center"),
|
|
| 285 | + array("Per Minute <br/>Cost($currency)", "100", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),
|
|
| 286 | + array("Initial <br/> Increment", "95", "init_inc", "", "", "", "", "true", "center"),
|
|
| 287 | + array("Increment", "75", "inc", "", "", "", "", "true", "center"),
|
|
| 288 | + array("Priority", "70", "precedence", "", "", "", "", "true", "center"),
|
|
| 289 | + array("Strip", "60", "strip", "", "", "", "", "true", "center"),
|
|
| 290 | + array("Prepend", "70", "prepend", "pattern", "", "get_only_numeric_val", "", "true", "center"),
|
|
| 291 | + array("Trunk", "80", "trunk_id", "name", "trunks", "get_field_name", "", "true", "center"),
|
|
| 292 | 292 | /* |
| 293 | 293 | ASTPP 3.0 |
| 294 | 294 | creation field show in grid |
| 295 | 295 | */ |
| 296 | - array("Status", "100", "status", "status", "outbound_routes", "get_status","","true","center"),
|
|
| 296 | + array("Status", "100", "status", "status", "outbound_routes", "get_status", "", "true", "center"),
|
|
| 297 | 297 | // array("Created<br/>Date", "80", "creation_date", "creation_date", "creation_date", "convert_GMT_to","","true","center"),
|
| 298 | - array("Modified Date", "150", "last_modified_date", "last_modified_date", "last_modified_date", "convert_GMT_to","","true","center"),
|
|
| 298 | + array("Modified Date", "150", "last_modified_date", "last_modified_date", "last_modified_date", "convert_GMT_to", "", "true", "center"),
|
|
| 299 | 299 | /********************************************************************/ |
| 300 | 300 | /* |
| 301 | 301 | ASTPP 3.0 |
@@ -304,7 +304,7 @@ discard block |
||
| 304 | 304 | |
| 305 | 305 | /***********************************************************************/ |
| 306 | 306 | // array("Reseller", "103", "reseller_id", "number", "accounts", "get_field_name"),
|
| 307 | - array("Action", "80", "", "", "", array("EDIT" => array("url" => "rates/termination_rate_edit/", "mode" => "popup","layout"=>"medium"),
|
|
| 307 | + array("Action", "80", "", "", "", array("EDIT" => array("url" => "rates/termination_rate_edit/", "mode" => "popup", "layout"=>"medium"),
|
|
| 308 | 308 | "DELETE" => array("url" => "rates/termination_rate_delete/", "mode" => "single")))
|
| 309 | 309 | )); |
| 310 | 310 | return $grid_field_arr; |
@@ -317,36 +317,36 @@ discard block |
||
| 317 | 317 | */ |
| 318 | 318 | function build_origination_rate_list_for_admin() {
|
| 319 | 319 | $account_info = $accountinfo = $this->CI->session->userdata('accountinfo');
|
| 320 | -$currency_id=$account_info['currency_id']; |
|
| 321 | -$currency=$this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 320 | +$currency_id = $account_info['currency_id']; |
|
| 321 | +$currency = $this->CI->common->get_field_name('currency', 'currency', $currency_id);
|
|
| 322 | 322 | |
| 323 | 323 | // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name); |
| 324 | - $grid_field_arr = json_encode(array(array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "","","false","center"),
|
|
| 324 | + $grid_field_arr = json_encode(array(array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center"),
|
|
| 325 | 325 | /** |
| 326 | 326 | ASTPP 3.0 |
| 327 | 327 | For Origination rate edit on code |
| 328 | 328 | **/ |
| 329 | - array("Code", "75", "pattern", "pattern", "", "get_only_numeric_val","EDITABLE","true","center"),
|
|
| 329 | + array("Code", "75", "pattern", "pattern", "", "get_only_numeric_val", "EDITABLE", "true", "center"),
|
|
| 330 | 330 | /************************************/ |
| 331 | - array("Destination", "100", "comment", "", "", "","","true","center"),
|
|
| 332 | - array("Connect Cost($currency)", "130", "connectcost", "connectcost", "connectcost", "convert_to_currency","","true","right"),
|
|
| 333 | - array("Included Seconds", "120", "includedseconds", "", "", "","","true","center"),
|
|
| 334 | - array("Per Minute Cost($currency)", "150", "cost", "cost", "cost", "convert_to_currency","","true","right"),
|
|
| 331 | + array("Destination", "100", "comment", "", "", "", "", "true", "center"),
|
|
| 332 | + array("Connect Cost($currency)", "130", "connectcost", "connectcost", "connectcost", "convert_to_currency", "", "true", "right"),
|
|
| 333 | + array("Included Seconds", "120", "includedseconds", "", "", "", "", "true", "center"),
|
|
| 334 | + array("Per Minute Cost($currency)", "150", "cost", "cost", "cost", "convert_to_currency", "", "true", "right"),
|
|
| 335 | 335 | /** |
| 336 | 336 | ASTPP 3.0 |
| 337 | 337 | For Add Initial Increment field |
| 338 | 338 | **/ |
| 339 | - array("Initial Increment", "130", "init_inc", "", "", "","","true","center"),
|
|
| 339 | + array("Initial Increment", "130", "init_inc", "", "", "", "", "true", "center"),
|
|
| 340 | 340 | /*******************************************************************/ |
| 341 | - array("Increment", "90", "inc", "", "", "","","true","center"),
|
|
| 341 | + array("Increment", "90", "inc", "", "", "", "", "true", "center"),
|
|
| 342 | 342 | //array("Priority", "72", "precedence", "", "", "","","true","center"),
|
| 343 | - array("Rate Group", "90", "pricelist_id", "name", "pricelists", "get_field_name","","true","center"),
|
|
| 343 | + array("Rate Group", "90", "pricelist_id", "name", "pricelists", "get_field_name", "", "true", "center"),
|
|
| 344 | 344 | /* |
| 345 | 345 | ASTPP 3.0 creation field show in grid |
| 346 | 346 | */ |
| 347 | - array("Status", "100", "status", "status", "routes", "get_status","","true","center"),
|
|
| 347 | + array("Status", "100", "status", "status", "routes", "get_status", "", "true", "center"),
|
|
| 348 | 348 | // array("Created<br/>Date", "80", "creation_date", "creation_date", "creation_date", "convert_GMT_to","","true","center"),
|
| 349 | - array("Modified Date", "150", "last_modified_date", "last_modified_date", "last_modified_date", "convert_GMT_to","","true","center"),
|
|
| 349 | + array("Modified Date", "150", "last_modified_date", "last_modified_date", "last_modified_date", "convert_GMT_to", "", "true", "center"),
|
|
| 350 | 350 | |
| 351 | 351 | /********************************************************************/ |
| 352 | 352 | /* |
@@ -354,7 +354,7 @@ discard block |
||
| 354 | 354 | chnage in status active or inactive |
| 355 | 355 | */ |
| 356 | 356 | |
| 357 | - array("Action", "95", "", "", "", array("EDIT" => array("url" => "rates/origination_rate_edit/", "mode" => "popup","layout"=>"medium"),
|
|
| 357 | + array("Action", "95", "", "", "", array("EDIT" => array("url" => "rates/origination_rate_edit/", "mode" => "popup", "layout"=>"medium"),
|
|
| 358 | 358 | "DELETE" => array("url" => "/rates/origination_rate_delete/", "mode" => "single")))
|
| 359 | 359 | )); |
| 360 | 360 | return $grid_field_arr; |
@@ -362,19 +362,19 @@ discard block |
||
| 362 | 362 | /****************************************************************************************/ |
| 363 | 363 | |
| 364 | 364 | function build_grid_buttons() {
|
| 365 | - $buttons_json = json_encode(array(array("Create","btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/rates/termination_rate_add/", "popup","medium"),
|
|
| 366 | - array("Delete", "btn btn-line-danger","fa fa-times-circle fa-lg", "button_action", "/rates/termination_rate_delete_multiple/"),
|
|
| 367 | - array("import","btn btn-line-blue" ,"fa fa-upload fa-lg", "button_action", "/rates/termination_rate_import/", 'single'),
|
|
| 368 | - array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/rates/termination_rate_export_cdr_xls/", 'single')
|
|
| 365 | + $buttons_json = json_encode(array(array("Create", "btn btn-line-warning btn", "fa fa-plus-circle fa-lg", "button_action", "/rates/termination_rate_add/", "popup", "medium"),
|
|
| 366 | + array("Delete", "btn btn-line-danger", "fa fa-times-circle fa-lg", "button_action", "/rates/termination_rate_delete_multiple/"),
|
|
| 367 | + array("import", "btn btn-line-blue", "fa fa-upload fa-lg", "button_action", "/rates/termination_rate_import/", 'single'),
|
|
| 368 | + array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/rates/termination_rate_export_cdr_xls/", 'single')
|
|
| 369 | 369 | )); |
| 370 | 370 | return $buttons_json; |
| 371 | 371 | } |
| 372 | 372 | |
| 373 | 373 | function build_grid_buttons_origination_rate() {
|
| 374 | - $buttons_json = json_encode(array(array("Create","btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/rates/origination_rate_add/", "popup","medium"),
|
|
| 375 | - array("Delete", "btn btn-line-danger","fa fa-times-circle fa-lg", "button_action", "/rates/origination_rate_delete_multiple/"),
|
|
| 376 | - array("import", "btn btn-line-blue","fa fa-upload fa-lg", "button_action", "/rates/origination_rate_import/", 'single'),
|
|
| 377 | - array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/rates/origination_rate_export_cdr_xls/", 'single')
|
|
| 374 | + $buttons_json = json_encode(array(array("Create", "btn btn-line-warning btn", "fa fa-plus-circle fa-lg", "button_action", "/rates/origination_rate_add/", "popup", "medium"),
|
|
| 375 | + array("Delete", "btn btn-line-danger", "fa fa-times-circle fa-lg", "button_action", "/rates/origination_rate_delete_multiple/"),
|
|
| 376 | + array("import", "btn btn-line-blue", "fa fa-upload fa-lg", "button_action", "/rates/origination_rate_import/", 'single'),
|
|
| 377 | + array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/rates/origination_rate_export_cdr_xls/", 'single')
|
|
| 378 | 378 | |
| 379 | 379 | )); |
| 380 | 380 | return $buttons_json; |
@@ -383,7 +383,7 @@ discard block |
||
| 383 | 383 | function build_termination_rate_list_for_customer() {
|
| 384 | 384 | // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name); |
| 385 | 385 | $grid_field_arr = json_encode(array( |
| 386 | - array("<input type='checkbox' name='chkAll' class='ace checking checkall'/><label class='lbl'></label>", "30", "", "", "", "","","false","center"),
|
|
| 386 | + array("<input type='checkbox' name='chkAll' class='ace checking checkall'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center"),
|
|
| 387 | 387 | array("Code", "70", "pattern", "pattern", "", "get_only_numeric_val"),
|
| 388 | 388 | array("Increment", "75", "inc", "", "", ""),
|
| 389 | 389 | array("Connect <br> Charge", "100", "connectcost", "connectcost", "connectcost", "convert_to_currency"),
|
@@ -398,16 +398,16 @@ discard block |
||
| 398 | 398 | function build_block_pattern_list_for_customer() {
|
| 399 | 399 | // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name); |
| 400 | 400 | $grid_field_arr = json_encode(array( |
| 401 | - array("<input type='checkbox' name='chkAll1' class='ace checking'/><label class='lbl'></label>", "30", "", "", "", "","","false","center","PatternChkBox"),
|
|
| 401 | + array("<input type='checkbox' name='chkAll1' class='ace checking'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center", "PatternChkBox"),
|
|
| 402 | 402 | array("Code", "350", "pattern", "pattern", "", "get_only_numeric_val"),
|
| 403 | 403 | array("Destination", "350", "comment", "", "", ""),
|
| 404 | 404 | )); |
| 405 | 405 | return $grid_field_arr; |
| 406 | 406 | } |
| 407 | - function build_pattern_list_for_customer($accountid,$accounttype) {
|
|
| 407 | + function build_pattern_list_for_customer($accountid, $accounttype) {
|
|
| 408 | 408 | |
| 409 | 409 | $grid_field_arr = json_encode(array( |
| 410 | - array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "","","false","center"),
|
|
| 410 | + array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center"),
|
|
| 411 | 411 | array("Code", "450", "blocked_patterns", "blocked_patterns", "", "get_only_numeric_val"),
|
| 412 | 412 | array("Destination", "450", "destination", "", "", ""),
|
| 413 | 413 | array("Action", "100", "", "", "", array("DELETE" => array("url" => "accounts/".$accounttype."_delete_block_pattern/$accountid/", "mode" => "single")))
|
@@ -416,7 +416,7 @@ discard block |
||
| 416 | 416 | } |
| 417 | 417 | |
| 418 | 418 | function set_pattern_grid_buttons($accountid) {
|
| 419 | - $buttons_json = json_encode(array(array("Add Prefixes","btn btn-line-warning btn","fa fa-plus-circle fa-lg", "button_action", "/accounts/customer_add_blockpatterns/$accountid", "popup")));
|
|
| 419 | + $buttons_json = json_encode(array(array("Add Prefixes", "btn btn-line-warning btn", "fa fa-plus-circle fa-lg", "button_action", "/accounts/customer_add_blockpatterns/$accountid", "popup")));
|
|
| 420 | 420 | return $buttons_json; |
| 421 | 421 | } |
| 422 | 422 | |
@@ -434,7 +434,7 @@ discard block |
||
| 434 | 434 | |
| 435 | 435 | |
| 436 | 436 | function build_grid_buttons_rates() {
|
| 437 | - $buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/rates/resellersrates_xls/", 'single')));
|
|
| 437 | + $buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/rates/resellersrates_xls/", 'single')));
|
|
| 438 | 438 | return $buttons_json; |
| 439 | 439 | } |
| 440 | 440 | |
@@ -20,8 +20,9 @@ discard block |
||
| 20 | 20 | # You should have received a copy of the GNU Affero General Public License |
| 21 | 21 | # along with this program. If not, see <http://www.gnu.org/licenses/>. |
| 22 | 22 | ############################################################################### |
| 23 | -if (!defined('BASEPATH'))
|
|
| 24 | - exit('No direct script access allowed');
|
|
| 23 | +if (!defined('BASEPATH')) { |
|
| 24 | + exit('No direct script access allowed'); |
|
| 25 | +} |
|
| 25 | 26 | |
| 26 | 27 | class rates_form {
|
| 27 | 28 | function __construct($library_name = '') {
|
@@ -62,8 +63,9 @@ discard block |
||
| 62 | 63 | function get_origination_rate_form_fields() {
|
| 63 | 64 | $logintype=$this->CI->session->userdata('userlevel_logintype');
|
| 64 | 65 | $trunk=null; |
| 65 | - if($logintype !=1) |
|
| 66 | - $trunk = array('Force Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0"));
|
|
| 66 | + if($logintype !=1) { |
|
| 67 | + $trunk = array('Force Trunk', 'trunk_id', 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0")); |
|
| 68 | + } |
|
| 67 | 69 | $form['forms'] = array(base_url() . 'rates/origination_rate_save/', array('id' => 'origination_rate_form', 'method' => 'POST', 'name' => 'origination_rate_form'));
|
| 68 | 70 | $form['Rate Information'] = array( |
| 69 | 71 | array('', 'HIDDEN', array('name' => 'id'), '', '', '', ''),
|
@@ -165,8 +167,9 @@ discard block |
||
| 165 | 167 | function origination_rate_batch_update_form() {
|
| 166 | 168 | $logintype=$this->CI->session->userdata('userlevel_logintype');
|
| 167 | 169 | $trunk=null; |
| 168 | - if($logintype !=1) |
|
| 169 | - $trunk = array('Force Trunk', array('name'=> 'trunk_id[trunk_id]','id'=>'trunk_id'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0"),array('name'=>'trunk_id[operator]','class'=>'update_drp'), 'update_drp_type');
|
|
| 170 | + if($logintype !=1) { |
|
| 171 | + $trunk = array('Force Trunk', array('name'=> 'trunk_id[trunk_id]','id'=>'trunk_id'), 'SELECT', '', '', 'tOOL TIP', 'Please Enter account number', 'id', 'name', 'trunks', 'build_dropdown', 'where_arr', array("status" => "0"),array('name'=>'trunk_id[operator]','class'=>'update_drp'), 'update_drp_type'); |
|
| 172 | + } |
|
| 170 | 173 | $form['forms'] = array("rates/origination_rate_batch_update/",array('id' => "origination_rate_batch_update"));
|
| 171 | 174 | $form['Batch Update'] = array( |
| 172 | 175 | array('Connect Cost', 'INPUT', array('name' => 'connectcost[connectcost]','id'=>'connectcost', 'value' => '', 'size' => '20', 'class' => "text field "), '', 'Tool tips info', '1', array('name'=>'connectcost[operator]','class'=>'update_drp'), '', '', '', 'update_int_type', ''),
|
@@ -18,7 +18,7 @@ discard block |
||
| 18 | 18 | <div class="col-md-12"> |
| 19 | 19 | <div class="w-box"> |
| 20 | 20 | <span style="margin-left:10px; text-align: center;background-color: none;color:#DD191D;"> |
| 21 | - <? if(isset($error) && !empty($error)) { |
|
| 21 | + <? if (isset($error) && ! empty($error)) { |
|
| 22 | 22 | echo $error; |
| 23 | 23 | }?> |
| 24 | 24 | </span> |
@@ -34,7 +34,7 @@ discard block |
||
| 34 | 34 | <div class="col-md-12 no-padding"> |
| 35 | 35 | <label class="col-md-3">Trunk List:</label> |
| 36 | 36 | <div class=""> |
| 37 | - <? $trunklist = form_dropdown('trunk_id', $this->db_model->build_dropdown("id,name", "trunks", "where_arr",array("status " => "0")), ''); |
|
| 37 | + <? $trunklist = form_dropdown('trunk_id', $this->db_model->build_dropdown("id,name", "trunks", "where_arr", array("status " => "0")), ''); |
|
| 38 | 38 | echo $trunklist; ?></div> |
| 39 | 39 | </div> |
| 40 | 40 | <div class="col-md-12 no-padding"> |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | <?}?> |
| 89 | 89 | |
| 90 | 90 | <?php |
| 91 | - if(isset($csv_tmp_data) && !empty($csv_tmp_data)){ ?> |
|
| 91 | + if (isset($csv_tmp_data) && ! empty($csv_tmp_data)) { ?> |
|
| 92 | 92 | |
| 93 | 93 | <section class="slice color-three padding-b-20"> |
| 94 | 94 | <div class="w-section inverse no-padding"> |
@@ -97,14 +97,14 @@ discard block |
||
| 97 | 97 | <div class="col-md-12 margin-t-10"> |
| 98 | 98 | <form id="import_form" name="import_form" action="<?=base_url()?>rates/termination_rate_rates_import/<?= $trunkid?>/<?=$check_header?>/" method="POST"> |
| 99 | 99 | <table width="100%" border="1" class="details_table table"> |
| 100 | - <? $cnt =7; |
|
| 101 | - foreach($csv_tmp_data as $csv_key => $csv_value){ |
|
| 102 | - if($csv_key < 15){ |
|
| 100 | + <? $cnt = 7; |
|
| 101 | + foreach ($csv_tmp_data as $csv_key => $csv_value) { |
|
| 102 | + if ($csv_key < 15) { |
|
| 103 | 103 | echo "<tr>"; |
| 104 | - foreach($csv_value as $field_name => $field_val){ |
|
| 105 | - if($csv_key == 0){ |
|
| 104 | + foreach ($csv_value as $field_name => $field_val) { |
|
| 105 | + if ($csv_key == 0) { |
|
| 106 | 106 | echo "<th>".ucfirst($field_name)."</th>"; |
| 107 | - }else{ |
|
| 107 | + } else { |
|
| 108 | 108 | echo "<td class='portlet-content'>".$field_val."</td>"; |
| 109 | 109 | } |
| 110 | 110 | } |
@@ -104,7 +104,7 @@ |
||
| 104 | 104 | foreach($csv_value as $field_name => $field_val){ |
| 105 | 105 | if($csv_key == 0){ |
| 106 | 106 | echo "<th>".ucfirst($field_name)."</th>"; |
| 107 | - }else{ |
|
| 107 | + } else{ |
|
| 108 | 108 | echo "<td class='portlet-content'>".$field_val."</td>"; |
| 109 | 109 | } |
| 110 | 110 | } |
@@ -51,49 +51,49 @@ |
||
| 51 | 51 | $data['reseller_id'] = $data['key_unique']; |
| 52 | 52 | unset($data['agreeCheck']); |
| 53 | 53 | unset($data['key_unique']); |
| 54 | - $data['creation']=gmdate('Y-m-d H:i:s'); |
|
| 54 | + $data['creation'] = gmdate('Y-m-d H:i:s'); |
|
| 55 | 55 | $data['expiry'] = date('Y-m-d H:i:s', strtotime('+10 years')); |
| 56 | - $this->db->insert("accounts",$data); |
|
| 56 | + $this->db->insert("accounts", $data); |
|
| 57 | 57 | return $this->db->insert_id(); |
| 58 | 58 | } |
| 59 | 59 | |
| 60 | - function check_user($accno,$email,$balance) |
|
| 60 | + function check_user($accno, $email, $balance) |
|
| 61 | 61 | { |
| 62 | - $info = array("number"=>$accno,"email"=>$email,"status"=>1); |
|
| 62 | + $info = array("number"=>$accno, "email"=>$email, "status"=>1); |
|
| 63 | 63 | $this->db->where($info); |
| 64 | 64 | $this->db->select('*'); |
| 65 | - $acc_res=$this->db->get('accounts'); |
|
| 66 | - if($acc_res->num_rows() > 0) |
|
| 65 | + $acc_res = $this->db->get('accounts'); |
|
| 66 | + if ($acc_res->num_rows() > 0) |
|
| 67 | 67 | { |
| 68 | - $acc_res=$acc_res->result_array(); |
|
| 69 | - $acc_res=$acc_res[0]; |
|
| 70 | - $this->db->where('pricelist_id',$acc_res['pricelist_id']); |
|
| 68 | + $acc_res = $acc_res->result_array(); |
|
| 69 | + $acc_res = $acc_res[0]; |
|
| 70 | + $this->db->where('pricelist_id', $acc_res['pricelist_id']); |
|
| 71 | 71 | $this->db->select("*"); |
| 72 | - $charge_res=$this->db->get('charges'); |
|
| 72 | + $charge_res = $this->db->get('charges'); |
|
| 73 | 73 | |
| 74 | - if($charge_res->num_rows() > 0){ |
|
| 75 | - $charge_res=$charge_res->result_array(); |
|
| 76 | - $charge_res=$charge_res[0]; |
|
| 77 | - $charge_acc_arr=array( |
|
| 74 | + if ($charge_res->num_rows() > 0) { |
|
| 75 | + $charge_res = $charge_res->result_array(); |
|
| 76 | + $charge_res = $charge_res[0]; |
|
| 77 | + $charge_acc_arr = array( |
|
| 78 | 78 | "charge_id"=>$charge_res['id'], |
| 79 | 79 | "accountid"=>$acc_res['id'], |
| 80 | 80 | "status"=>0, |
| 81 | 81 | "assign_date"=>date('Y-m-d H:i:s') |
| 82 | 82 | ); |
| 83 | - }else{ |
|
| 84 | - $charge_res=$charge_res->result_array(); |
|
| 83 | + } else { |
|
| 84 | + $charge_res = $charge_res->result_array(); |
|
| 85 | 85 | //echo "<pre>"; print_r($charge_res); exit; |
| 86 | 86 | $charge_acc_arr = array("charge_id"=>'id', |
| 87 | 87 | "accountid"=>$acc_res['id'], |
| 88 | 88 | "assign_date"=>date('Y-m-d H:i:s')); |
| 89 | 89 | } |
| 90 | - $result=$this->db->insert("charge_to_account",$charge_acc_arr); |
|
| 91 | - $update = array("status" => 0,"balance" => $balance ); |
|
| 90 | + $result = $this->db->insert("charge_to_account", $charge_acc_arr); |
|
| 91 | + $update = array("status" => 0, "balance" => $balance); |
|
| 92 | 92 | $this->db->where($info); |
| 93 | 93 | $result = $this->db->update('accounts', $update); |
| 94 | - $sip_device_update = array('username'=>$accno,"status"=>1); |
|
| 94 | + $sip_device_update = array('username'=>$accno, "status"=>1); |
|
| 95 | 95 | return 1; |
| 96 | - } else{ |
|
| 96 | + } else { |
|
| 97 | 97 | return 0; |
| 98 | 98 | } |
| 99 | 99 | } |
@@ -80,7 +80,7 @@ |
||
| 80 | 80 | "status"=>0, |
| 81 | 81 | "assign_date"=>date('Y-m-d H:i:s') |
| 82 | 82 | ); |
| 83 | - }else{ |
|
| 83 | + } else{ |
|
| 84 | 84 | $charge_res=$charge_res->result_array(); |
| 85 | 85 | //echo "<pre>"; print_r($charge_res); exit; |
| 86 | 86 | $charge_acc_arr = array("charge_id"=>'id', |
@@ -39,50 +39,50 @@ discard block |
||
| 39 | 39 | return $query; |
| 40 | 40 | } |
| 41 | 41 | |
| 42 | - function gettemplate_list($flag="", $start, $limit="") { |
|
| 42 | + function gettemplate_list($flag = "", $start, $limit = "") { |
|
| 43 | 43 | |
| 44 | 44 | |
| 45 | 45 | if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
| 46 | 46 | $account_data = $this->session->userdata("accountinfo"); |
| 47 | 47 | $reseller = $account_data['id']; |
| 48 | - $this->db->where('reseller_id',$reseller); |
|
| 49 | - $query = $this->db_model->select("*", "default_templates","","","","",""); |
|
| 50 | - |
|
| 51 | - if($query->num_rows() >0){ |
|
| 52 | - $result =$query->result_array(); |
|
| 53 | - $match_array =array(); |
|
| 54 | - $unmatch_array= array(); |
|
| 55 | - $i=0; |
|
| 56 | - $str=0; |
|
| 57 | - foreach($result as $value) |
|
| 48 | + $this->db->where('reseller_id', $reseller); |
|
| 49 | + $query = $this->db_model->select("*", "default_templates", "", "", "", "", ""); |
|
| 50 | + |
|
| 51 | + if ($query->num_rows() > 0) { |
|
| 52 | + $result = $query->result_array(); |
|
| 53 | + $match_array = array(); |
|
| 54 | + $unmatch_array = array(); |
|
| 55 | + $i = 0; |
|
| 56 | + $str = 0; |
|
| 57 | + foreach ($result as $value) |
|
| 58 | 58 | { |
| 59 | - $this->db->where('name',$value['name']); |
|
| 60 | - $this->db->where('reseller_id',0); |
|
| 61 | - $query = $this->db_model->select("id", "default_templates","", "id", "ASC", $limit, $start); |
|
| 62 | - $innerresult =$query->result_array(); |
|
| 63 | - foreach($innerresult as $value) |
|
| 59 | + $this->db->where('name', $value['name']); |
|
| 60 | + $this->db->where('reseller_id', 0); |
|
| 61 | + $query = $this->db_model->select("id", "default_templates", "", "id", "ASC", $limit, $start); |
|
| 62 | + $innerresult = $query->result_array(); |
|
| 63 | + foreach ($innerresult as $value) |
|
| 64 | 64 | { |
| 65 | - $str.=$value['id'].","; |
|
| 65 | + $str .= $value['id'].","; |
|
| 66 | 66 | } |
| 67 | 67 | } |
| 68 | - $str= rtrim($str,','); |
|
| 68 | + $str = rtrim($str, ','); |
|
| 69 | 69 | |
| 70 | 70 | $where = "id NOT IN ($str)"; |
| 71 | - $this->db->where('reseller_id',$reseller); |
|
| 72 | - $this->db->or_where('reseller_id',0); |
|
| 71 | + $this->db->where('reseller_id', $reseller); |
|
| 72 | + $this->db->or_where('reseller_id', 0); |
|
| 73 | 73 | $this->db->where($where); |
| 74 | 74 | } |
| 75 | 75 | else |
| 76 | 76 | { |
| 77 | - $this->db->where('reseller_id',0); |
|
| 77 | + $this->db->where('reseller_id', 0); |
|
| 78 | 78 | } |
| 79 | 79 | |
| 80 | - if($flag) { |
|
| 80 | + if ($flag) { |
|
| 81 | 81 | |
| 82 | - $query = $this->db_model->select("*", "default_templates","", "id", "ASC", $limit, $start); |
|
| 83 | - }else { |
|
| 82 | + $query = $this->db_model->select("*", "default_templates", "", "id", "ASC", $limit, $start); |
|
| 83 | + } else { |
|
| 84 | 84 | |
| 85 | - $query = $this->db_model->countQuery("*", "default_templates",""); |
|
| 85 | + $query = $this->db_model->countQuery("*", "default_templates", ""); |
|
| 86 | 86 | |
| 87 | 87 | } |
| 88 | 88 | } |
@@ -92,9 +92,9 @@ discard block |
||
| 92 | 92 | $this->db->where($where); |
| 93 | 93 | $this->db_model->build_search('template_search'); |
| 94 | 94 | if ($flag) { |
| 95 | - $query = $this->db_model->select("*", "default_templates","", "id", "ASC", $limit, $start); |
|
| 95 | + $query = $this->db_model->select("*", "default_templates", "", "id", "ASC", $limit, $start); |
|
| 96 | 96 | } else { |
| 97 | - $query = $this->db_model->countQuery("*", "default_templates",""); |
|
| 97 | + $query = $this->db_model->countQuery("*", "default_templates", ""); |
|
| 98 | 98 | } |
| 99 | 99 | } |
| 100 | 100 | |
@@ -106,13 +106,13 @@ discard block |
||
| 106 | 106 | |
| 107 | 107 | $this->db->where("name", $name); |
| 108 | 108 | $this->db->update("system", $add_array); |
| 109 | - if($name == 'base_currency'){ |
|
| 109 | + if ($name == 'base_currency') { |
|
| 110 | 110 | |
| 111 | - $screen_path = getcwd() . "/cron"; |
|
| 112 | - $screen_filename = "CurrencyUpdate" . strtotime('now'); |
|
| 113 | - $command = "cd " . $screen_path . " && /usr/bin/screen -d -m -S $screen_filename php cron.php CurrencyUpdate"; |
|
| 111 | + $screen_path = getcwd()."/cron"; |
|
| 112 | + $screen_filename = "CurrencyUpdate".strtotime('now'); |
|
| 113 | + $command = "cd ".$screen_path." && /usr/bin/screen -d -m -S $screen_filename php cron.php CurrencyUpdate"; |
|
| 114 | 114 | exec($command); |
| 115 | - $this->db->update("currency",array("currencyrate"=>'1'),array("currency"=>"INR")); |
|
| 115 | + $this->db->update("currency", array("currencyrate"=>'1'), array("currency"=>"INR")); |
|
| 116 | 116 | } |
| 117 | 117 | } |
| 118 | 118 | |
@@ -179,7 +179,7 @@ discard block |
||
| 179 | 179 | function getcurrency_list($flag, $start = 0, $limit = 0) { |
| 180 | 180 | $this->db_model->build_search('currency_list_search'); |
| 181 | 181 | |
| 182 | - $where=array('currency <>' =>Common_model::$global_config['system_config']['base_currency']); |
|
| 182 | + $where = array('currency <>' =>Common_model::$global_config['system_config']['base_currency']); |
|
| 183 | 183 | if ($flag) { |
| 184 | 184 | $query = $this->db_model->select("*", "currency", $where, "id", "ASC", $limit, $start); |
| 185 | 185 | } else { |
@@ -205,7 +205,7 @@ discard block |
||
| 205 | 205 | $this->db->delete("currency"); |
| 206 | 206 | return true; |
| 207 | 207 | } |
| 208 | - function backup_insert($add_array='') |
|
| 208 | + function backup_insert($add_array = '') |
|
| 209 | 209 | { |
| 210 | 210 | unset($add_array["action"]); |
| 211 | 211 | $this->db->insert("backup_database", $add_array); |
@@ -222,13 +222,13 @@ discard block |
||
| 222 | 222 | } |
| 223 | 223 | function get_backup_data($id) |
| 224 | 224 | { |
| 225 | - $where=array('id'=>$id); |
|
| 225 | + $where = array('id'=>$id); |
|
| 226 | 226 | $query = $this->db_model->getSelect("*", "backup_database", $where); |
| 227 | 227 | return $query; |
| 228 | 228 | } |
| 229 | - function import_database($filename,$target_path) |
|
| 229 | + function import_database($filename, $target_path) |
|
| 230 | 230 | { |
| 231 | - $this->db->insert("backup_database", array('backup_name'=>$filename , 'path'=>$target_path)); |
|
| 231 | + $this->db->insert("backup_database", array('backup_name'=>$filename, 'path'=>$target_path)); |
|
| 232 | 232 | return true; |
| 233 | 233 | } |
| 234 | 234 | } |
@@ -71,8 +71,7 @@ discard block |
||
| 71 | 71 | $this->db->where('reseller_id',$reseller); |
| 72 | 72 | $this->db->or_where('reseller_id',0); |
| 73 | 73 | $this->db->where($where); |
| 74 | - } |
|
| 75 | - else |
|
| 74 | + } else |
|
| 76 | 75 | { |
| 77 | 76 | $this->db->where('reseller_id',0); |
| 78 | 77 | } |
@@ -80,13 +79,12 @@ discard block |
||
| 80 | 79 | if($flag) { |
| 81 | 80 | |
| 82 | 81 | $query = $this->db_model->select("*", "default_templates","", "id", "ASC", $limit, $start); |
| 83 | - }else { |
|
| 82 | + } else { |
|
| 84 | 83 | |
| 85 | 84 | $query = $this->db_model->countQuery("*", "default_templates",""); |
| 86 | 85 | |
| 87 | 86 | } |
| 88 | - } |
|
| 89 | - else { |
|
| 87 | + } else { |
|
| 90 | 88 | |
| 91 | 89 | $where = array('reseller_id' => 0); |
| 92 | 90 | $this->db->where($where); |
@@ -34,7 +34,7 @@ discard block |
||
| 34 | 34 | $this->load->dbutil(); |
| 35 | 35 | |
| 36 | 36 | if ($this->session->userdata('user_login') == FALSE) |
| 37 | - redirect(base_url() . '/astpp/login'); |
|
| 37 | + redirect(base_url().'/astpp/login'); |
|
| 38 | 38 | } |
| 39 | 39 | |
| 40 | 40 | function configuration_edit($edit_id = '') { |
@@ -58,7 +58,7 @@ discard block |
||
| 58 | 58 | $this->session->set_userdata('configuration_search', $action); |
| 59 | 59 | } |
| 60 | 60 | if (@$ajax_search != 1) { |
| 61 | - redirect(base_url() . 'systems/configuration/'); |
|
| 61 | + redirect(base_url().'systems/configuration/'); |
|
| 62 | 62 | } |
| 63 | 63 | } |
| 64 | 64 | |
@@ -84,29 +84,29 @@ discard block |
||
| 84 | 84 | } |
| 85 | 85 | } |
| 86 | 86 | |
| 87 | - function configuration($group_title='') { |
|
| 88 | - if($group_title==""){ |
|
| 89 | - redirect(base_url() . '/dashboard'); |
|
| 87 | + function configuration($group_title = '') { |
|
| 88 | + if ($group_title == "") { |
|
| 89 | + redirect(base_url().'/dashboard'); |
|
| 90 | 90 | } |
| 91 | - if($group_title=="email"){ |
|
| 91 | + if ($group_title == "email") { |
|
| 92 | 92 | $data['test_email_flag'] = true; |
| 93 | 93 | } |
| 94 | 94 | $data['username'] = $this->session->userdata('user_name'); |
| 95 | 95 | $data['page_title'] = ucfirst($group_title); |
| 96 | - $data['group_title']=$group_title; |
|
| 97 | - $where=array("group_title"=>$group_title); |
|
| 96 | + $data['group_title'] = $group_title; |
|
| 97 | + $where = array("group_title"=>$group_title); |
|
| 98 | 98 | $details = $this->db_model->getSelect("*", "system", $where); |
| 99 | - $data['details']=$details->result_array(); |
|
| 99 | + $data['details'] = $details->result_array(); |
|
| 100 | 100 | $add_array = $this->input->post(); |
| 101 | - if (!empty($add_array)) { |
|
| 101 | + if ( ! empty($add_array)) { |
|
| 102 | 102 | |
| 103 | - foreach($add_array as $key=>$val){ |
|
| 104 | - $update_array=array('value'=>$val); |
|
| 103 | + foreach ($add_array as $key=>$val) { |
|
| 104 | + $update_array = array('value'=>$val); |
|
| 105 | 105 | $this->system_model->edit_configuration($update_array, $key); |
| 106 | 106 | } |
| 107 | 107 | $this->session->set_flashdata('astpp_errormsg', ucfirst($group_title).' Settings updated sucessfully!'); |
| 108 | - redirect(base_url() . 'systems/configuration/'.$group_title); |
|
| 109 | - }else{ |
|
| 108 | + redirect(base_url().'systems/configuration/'.$group_title); |
|
| 109 | + } else { |
|
| 110 | 110 | $this->load->view('view_systemconf', $data); |
| 111 | 111 | } |
| 112 | 112 | } |
@@ -166,7 +166,7 @@ discard block |
||
| 166 | 166 | if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
| 167 | 167 | $account_data = $this->session->userdata("accountinfo"); |
| 168 | 168 | $reseller = $account_data['id']; |
| 169 | - $this->resellertemplate_save($add_array,$reseller); |
|
| 169 | + $this->resellertemplate_save($add_array, $reseller); |
|
| 170 | 170 | } |
| 171 | 171 | else |
| 172 | 172 | { |
@@ -174,12 +174,12 @@ discard block |
||
| 174 | 174 | } |
| 175 | 175 | } |
| 176 | 176 | |
| 177 | - function resellertemplate_save($data,$resellerid) |
|
| 177 | + function resellertemplate_save($data, $resellerid) |
|
| 178 | 178 | { |
| 179 | - $where = array('name' => $data['name'],'reseller_id'=>$resellerid); |
|
| 179 | + $where = array('name' => $data['name'], 'reseller_id'=>$resellerid); |
|
| 180 | 180 | $count = $this->db_model->countQuery("*", "default_templates", $where); |
| 181 | 181 | $data['form'] = $this->form->build_form($this->system_form->get_template_form_fields(), $data); |
| 182 | - if($count >0) |
|
| 182 | + if ($count > 0) |
|
| 183 | 183 | { |
| 184 | 184 | $data['page_title'] = 'Edit Template'; |
| 185 | 185 | if ($this->form_validation->run() == FALSE) { |
@@ -188,7 +188,7 @@ discard block |
||
| 188 | 188 | |
| 189 | 189 | $this->system_model->edit_resellertemplate($data, $data['id']); |
| 190 | 190 | $this->session->set_flashdata('astpp_errormsg', 'Template updated successfully!'); |
| 191 | - redirect(base_url() . 'systems/template/'); |
|
| 191 | + redirect(base_url().'systems/template/'); |
|
| 192 | 192 | exit; |
| 193 | 193 | } |
| 194 | 194 | } else { |
@@ -199,7 +199,7 @@ discard block |
||
| 199 | 199 | $data['reseller_id'] = $resellerid; |
| 200 | 200 | $this->system_model->add_resellertemplate($data); |
| 201 | 201 | $this->session->set_flashdata('astpp_errormsg', 'Template added successfully!'); |
| 202 | - redirect(base_url() . 'systems/template/'); |
|
| 202 | + redirect(base_url().'systems/template/'); |
|
| 203 | 203 | exit; |
| 204 | 204 | } |
| 205 | 205 | } |
@@ -217,7 +217,7 @@ discard block |
||
| 217 | 217 | unset($data['page_title']); |
| 218 | 218 | $this->system_model->edit_template($data, $data['id']); |
| 219 | 219 | $this->session->set_flashdata('astpp_errormsg', 'Template updated successfully!'); |
| 220 | - redirect(base_url() . 'systems/template/'); |
|
| 220 | + redirect(base_url().'systems/template/'); |
|
| 221 | 221 | exit; |
| 222 | 222 | } |
| 223 | 223 | } else { |
@@ -228,7 +228,7 @@ discard block |
||
| 228 | 228 | unset($data['form']); |
| 229 | 229 | $this->system_model->add_template($data); |
| 230 | 230 | $this->session->set_flashdata('astpp_errormsg', 'Template added successfully!'); |
| 231 | - redirect(base_url() . 'systems/template/'); |
|
| 231 | + redirect(base_url().'systems/template/'); |
|
| 232 | 232 | exit; |
| 233 | 233 | } |
| 234 | 234 | } |
@@ -245,7 +245,7 @@ discard block |
||
| 245 | 245 | $this->session->set_userdata('template_search', $action); |
| 246 | 246 | } |
| 247 | 247 | if (@$ajax_search != 1) { |
| 248 | - redirect(base_url() . 'systems/template/'); |
|
| 248 | + redirect(base_url().'systems/template/'); |
|
| 249 | 249 | } |
| 250 | 250 | } |
| 251 | 251 | |
@@ -293,7 +293,7 @@ discard block |
||
| 293 | 293 | $this->session->set_userdata('country_list_search', $action); |
| 294 | 294 | } |
| 295 | 295 | if (@$ajax_search != 1) { |
| 296 | - redirect(base_url() . 'systems/country_list/'); |
|
| 296 | + redirect(base_url().'systems/country_list/'); |
|
| 297 | 297 | } |
| 298 | 298 | } |
| 299 | 299 | |
@@ -352,9 +352,9 @@ discard block |
||
| 352 | 352 | |
| 353 | 353 | function country_remove($id) { |
| 354 | 354 | $this->system_model->remove_country($id); |
| 355 | - $country=$this->common->get_field_name('country','countrycode',$id); |
|
| 355 | + $country = $this->common->get_field_name('country', 'countrycode', $id); |
|
| 356 | 356 | $this->session->set_flashdata('astpp_notification', $country.'Country removed successfully!'); |
| 357 | - redirect(base_url() . 'systems/country_list/'); |
|
| 357 | + redirect(base_url().'systems/country_list/'); |
|
| 358 | 358 | } |
| 359 | 359 | |
| 360 | 360 | function country_delete_multiple() { |
@@ -405,7 +405,7 @@ discard block |
||
| 405 | 405 | $this->session->set_userdata('currency_list_search', $action); |
| 406 | 406 | } |
| 407 | 407 | if (@$ajax_search != 1) { |
| 408 | - redirect(base_url() . 'systems/currency_list/'); |
|
| 408 | + redirect(base_url().'systems/currency_list/'); |
|
| 409 | 409 | } |
| 410 | 410 | } |
| 411 | 411 | |
@@ -464,10 +464,10 @@ discard block |
||
| 464 | 464 | } |
| 465 | 465 | |
| 466 | 466 | function currency_remove($id) { |
| 467 | - $currencyname=$this->common->get_field_name('currencyname','currency',$id); |
|
| 467 | + $currencyname = $this->common->get_field_name('currencyname', 'currency', $id); |
|
| 468 | 468 | $this->system_model->remove_currency($id); |
| 469 | - $this->session->set_flashdata('astpp_notification',$currencyname. ' Currency removed successfully!'); |
|
| 470 | - redirect(base_url() . 'systems/currency_list/'); |
|
| 469 | + $this->session->set_flashdata('astpp_notification', $currencyname.' Currency removed successfully!'); |
|
| 470 | + redirect(base_url().'systems/currency_list/'); |
|
| 471 | 471 | } |
| 472 | 472 | |
| 473 | 473 | function currency_delete_multiple() { |
@@ -478,53 +478,53 @@ discard block |
||
| 478 | 478 | } |
| 479 | 479 | function database_backup() |
| 480 | 480 | { |
| 481 | - $data=array(); |
|
| 481 | + $data = array(); |
|
| 482 | 482 | $data['username'] = $this->session->userdata('user_name'); |
| 483 | 483 | $data['page_title'] = 'Database Backup'; |
| 484 | - $filename=$this->db->database."_".date("YmdHms").".sql.gz"; |
|
| 484 | + $filename = $this->db->database."_".date("YmdHms").".sql.gz"; |
|
| 485 | 485 | $data['form'] = $this->form->build_form($this->system_form->get_backup_database_form_fields($filename), ''); |
| 486 | 486 | $this->load->view('view_database_backup', $data); |
| 487 | 487 | } |
| 488 | 488 | function database_backup_save() |
| 489 | 489 | { |
| 490 | 490 | |
| 491 | - $add_array=$this->input->post(); |
|
| 491 | + $add_array = $this->input->post(); |
|
| 492 | 492 | |
| 493 | - $data['form'] = $this->form->build_form($this->system_form->get_backup_database_form_fields($add_array['path'],$add_array['id']),$add_array); |
|
| 493 | + $data['form'] = $this->form->build_form($this->system_form->get_backup_database_form_fields($add_array['path'], $add_array['id']), $add_array); |
|
| 494 | 494 | $data['page_title'] = 'Database Backup'; |
| 495 | - if($add_array['id'] != ''){ |
|
| 495 | + if ($add_array['id'] != '') { |
|
| 496 | 496 | |
| 497 | - }else{ |
|
| 498 | - if($this->form_validation->run() == FALSE) { |
|
| 497 | + } else { |
|
| 498 | + if ($this->form_validation->run() == FALSE) { |
|
| 499 | 499 | $data['validation_errors'] = validation_errors(); |
| 500 | 500 | echo $data['validation_errors']; |
| 501 | 501 | exit; |
| 502 | - }else{ |
|
| 502 | + } else { |
|
| 503 | 503 | $db_name = $this->db->database; |
| 504 | 504 | $db_username = $this->db->username; |
| 505 | 505 | $db_password = $this->db->password; |
| 506 | 506 | $db_hostname = $this->db->hostname; |
| 507 | 507 | $filename = $add_array['path']; |
| 508 | - $backup_file=DATABASE_DIRECTORY.$filename; |
|
| 509 | - if (substr($backup_file,-3)=='.gz'){ |
|
| 510 | - $backup_file = substr($backup_file,0,-3); |
|
| 511 | - $do_gzip=1; |
|
| 508 | + $backup_file = DATABASE_DIRECTORY.$filename; |
|
| 509 | + if (substr($backup_file, -3) == '.gz') { |
|
| 510 | + $backup_file = substr($backup_file, 0, -3); |
|
| 511 | + $do_gzip = 1; |
|
| 512 | 512 | } |
| 513 | 513 | |
| 514 | - $run_backup="/usr/bin/mysqldump -all --databases ".$db_name." -u'".$db_username."' -p'".$db_password."' > '$backup_file'"; |
|
| 515 | - $error_zip=0; |
|
| 516 | - exec($run_backup,$output,$error); |
|
| 517 | - if ($do_gzip){ |
|
| 514 | + $run_backup = "/usr/bin/mysqldump -all --databases ".$db_name." -u'".$db_username."' -p'".$db_password."' > '$backup_file'"; |
|
| 515 | + $error_zip = 0; |
|
| 516 | + exec($run_backup, $output, $error); |
|
| 517 | + if ($do_gzip) { |
|
| 518 | 518 | $gzip = $this->config->item('gzip-path'); |
| 519 | 519 | $run_gzip = $gzip." ".$backup_file; |
| 520 | - exec($run_gzip,$output,$error_zip); |
|
| 520 | + exec($run_gzip, $output, $error_zip); |
|
| 521 | 521 | } |
| 522 | 522 | |
| 523 | - if($error == 0 && $error_zip == 0 ){ |
|
| 523 | + if ($error == 0 && $error_zip == 0) { |
|
| 524 | 524 | $this->system_model->backup_insert($add_array); |
| 525 | 525 | echo json_encode(array("SUCCESS"=> $add_array['backup_name']." backup exported successfully!")); |
| 526 | 526 | exit; |
| 527 | - }else{ |
|
| 527 | + } else { |
|
| 528 | 528 | echo 'An error occur when the system tried to backup of the database. Please check yours system settings for the backup section'; |
| 529 | 529 | exit; |
| 530 | 530 | } |
@@ -541,7 +541,7 @@ discard block |
||
| 541 | 541 | { |
| 542 | 542 | $json_data = array(); |
| 543 | 543 | $count_all = $this->system_model->getbackup_list(false, "", ""); |
| 544 | - $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'],$_GET['page']); |
|
| 544 | + $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
|
| 545 | 545 | $json_data = $paging_data["json_paging"]; |
| 546 | 546 | |
| 547 | 547 | $query = $this->system_model->getbackup_list(true, $paging_data["paging"]["start"], $paging_data["paging"]["page_no"]); |
@@ -551,56 +551,56 @@ discard block |
||
| 551 | 551 | echo json_encode($json_data); |
| 552 | 552 | exit; |
| 553 | 553 | } |
| 554 | - function database_restore_one($id='') |
|
| 554 | + function database_restore_one($id = '') |
|
| 555 | 555 | { |
| 556 | 556 | $result = $this->system_model->get_backup_data($id); |
| 557 | - $result_array=$result->result_array(); |
|
| 558 | - if($result->num_rows() > 0) |
|
| 557 | + $result_array = $result->result_array(); |
|
| 558 | + if ($result->num_rows() > 0) |
|
| 559 | 559 | { |
| 560 | 560 | $db_name = $this->db->database; |
| 561 | 561 | $db_username = $this->db->username; |
| 562 | 562 | $db_password = $this->db->password; |
| 563 | 563 | $db_hostname = $this->db->hostname; |
| 564 | - $path=DATABASE_DIRECTORY.$result_array[0]['path']; |
|
| 565 | - if(file_exists($path)){ |
|
| 566 | - if (substr($path,-3)=='.gz') { |
|
| 564 | + $path = DATABASE_DIRECTORY.$result_array[0]['path']; |
|
| 565 | + if (file_exists($path)) { |
|
| 566 | + if (substr($path, -3) == '.gz') { |
|
| 567 | 567 | $GUNZIP_EXE = $this->config->item('gunzip-path'); |
| 568 | 568 | $run_gzip = $GUNZIP_EXE." < ".$path." | "; |
| 569 | 569 | } |
| 570 | - $MYSQL="/usr/bin/mysql"; |
|
| 570 | + $MYSQL = "/usr/bin/mysql"; |
|
| 571 | 571 | $run_restore = $run_gzip.$MYSQL." -h".$db_hostname." -u".$db_username." -p".$db_password." ".$db_name; |
| 572 | 572 | exec($run_restore); |
| 573 | 573 | $this->session->set_flashdata('astpp_errormsg', 'Database Restore successfully.'); |
| 574 | - redirect(base_url() . 'systems/database_restore/'); |
|
| 575 | - }else{ |
|
| 574 | + redirect(base_url().'systems/database_restore/'); |
|
| 575 | + } else { |
|
| 576 | 576 | $this->session->set_flashdata('astpp_notification', 'File not exists!'); |
| 577 | - redirect(base_url() . 'systems/database_restore/'); |
|
| 577 | + redirect(base_url().'systems/database_restore/'); |
|
| 578 | 578 | } |
| 579 | 579 | } |
| 580 | - redirect(base_url() . 'systems/database_restore/'); |
|
| 580 | + redirect(base_url().'systems/database_restore/'); |
|
| 581 | 581 | } |
| 582 | 582 | |
| 583 | - function database_download($id=''){ |
|
| 583 | + function database_download($id = '') { |
|
| 584 | 584 | |
| 585 | 585 | $result = $this->system_model->get_backup_data($id); |
| 586 | - $result_array=$result->result_array(); |
|
| 587 | - if($result->num_rows() > 0) |
|
| 586 | + $result_array = $result->result_array(); |
|
| 587 | + if ($result->num_rows() > 0) |
|
| 588 | 588 | { |
| 589 | - $path=$result_array[0]['path']; |
|
| 589 | + $path = $result_array[0]['path']; |
|
| 590 | 590 | $filename = basename($path); |
| 591 | 591 | $len = filesize($path); |
| 592 | 592 | |
| 593 | 593 | header("Content-Encoding: binary"); |
| 594 | 594 | header("Content-Type: application/octet-stream"); |
| 595 | - header( "content-length: " . $len ); |
|
| 596 | - header( "content-disposition: attachment; filename=" . $filename ); |
|
| 595 | + header("content-length: ".$len); |
|
| 596 | + header("content-disposition: attachment; filename=".$filename); |
|
| 597 | 597 | header("Expires: 0"); |
| 598 | 598 | header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); |
| 599 | 599 | header("Cache-Control: private"); |
| 600 | 600 | header("Pragma: public"); |
| 601 | 601 | ob_clean(); |
| 602 | - $fp=fopen( $path, "r" ); |
|
| 603 | - fpassthru( $fp ); |
|
| 602 | + $fp = fopen($path, "r"); |
|
| 603 | + fpassthru($fp); |
|
| 604 | 604 | exit; |
| 605 | 605 | } |
| 606 | 606 | } |
@@ -614,17 +614,17 @@ discard block |
||
| 614 | 614 | function database_import_file() |
| 615 | 615 | { |
| 616 | 616 | $filename = $_POST['fname']; |
| 617 | - $upload_greeting_file= $_FILES['userfile']['name']; |
|
| 618 | - $db_file = explode(".",$upload_greeting_file); |
|
| 619 | - if( $db_file[1] == 'csv' || $db_file[1] == 'tar' || $db_file[1] == 'sql'){ |
|
| 620 | - $target_path = basename( $_FILES['userfile']['name']); |
|
| 621 | - move_uploaded_file($_FILES["userfile"]["tmp_name"], $target_path ); |
|
| 617 | + $upload_greeting_file = $_FILES['userfile']['name']; |
|
| 618 | + $db_file = explode(".", $upload_greeting_file); |
|
| 619 | + if ($db_file[1] == 'csv' || $db_file[1] == 'tar' || $db_file[1] == 'sql') { |
|
| 620 | + $target_path = basename($_FILES['userfile']['name']); |
|
| 621 | + move_uploaded_file($_FILES["userfile"]["tmp_name"], $target_path); |
|
| 622 | 622 | |
| 623 | - $query = $this->system_model->import_database($filename,$_FILES['userfile']['name']); |
|
| 624 | - $this->session->set_flashdata('astpp_errormsg',"The file ". basename( $_FILES['userfile']['name'])." has been uploaded"); |
|
| 623 | + $query = $this->system_model->import_database($filename, $_FILES['userfile']['name']); |
|
| 624 | + $this->session->set_flashdata('astpp_errormsg', "The file ".basename($_FILES['userfile']['name'])." has been uploaded"); |
|
| 625 | 625 | redirect(base_url()."systems/database_restore/"); |
| 626 | - }else{ |
|
| 627 | - $this->session->set_flashdata('astpp_notification',"There is a some issue or invalid file format."); |
|
| 626 | + } else { |
|
| 627 | + $this->session->set_flashdata('astpp_notification', "There is a some issue or invalid file format."); |
|
| 628 | 628 | redirect(base_url()."systems/database_restore/"); |
| 629 | 629 | } |
| 630 | 630 | } |
@@ -634,7 +634,7 @@ discard block |
||
| 634 | 634 | $this->db->where($where); |
| 635 | 635 | $this->db->delete("backup_database"); |
| 636 | 636 | $this->session->set_flashdata('astpp_errormsg', 'Database backup deleted successfully.'); |
| 637 | - redirect(base_url() . 'systems/database_restore/'); |
|
| 637 | + redirect(base_url().'systems/database_restore/'); |
|
| 638 | 638 | return true; |
| 639 | 639 | } |
| 640 | 640 | function database_backup_delete_multiple() { |
@@ -33,8 +33,9 @@ discard block |
||
| 33 | 33 | $this->load->model('system_model'); |
| 34 | 34 | $this->load->dbutil(); |
| 35 | 35 | |
| 36 | - if ($this->session->userdata('user_login') == FALSE) |
|
| 37 | - redirect(base_url() . '/astpp/login'); |
|
| 36 | + if ($this->session->userdata('user_login') == FALSE) { |
|
| 37 | + redirect(base_url() . '/astpp/login'); |
|
| 38 | + } |
|
| 38 | 39 | } |
| 39 | 40 | |
| 40 | 41 | function configuration_edit($edit_id = '') { |
@@ -106,7 +107,7 @@ discard block |
||
| 106 | 107 | } |
| 107 | 108 | $this->session->set_flashdata('astpp_errormsg', ucfirst($group_title).' Settings updated sucessfully!'); |
| 108 | 109 | redirect(base_url() . 'systems/configuration/'.$group_title); |
| 109 | - }else{ |
|
| 110 | + } else{ |
|
| 110 | 111 | $this->load->view('view_systemconf', $data); |
| 111 | 112 | } |
| 112 | 113 | } |
@@ -167,8 +168,7 @@ discard block |
||
| 167 | 168 | $account_data = $this->session->userdata("accountinfo"); |
| 168 | 169 | $reseller = $account_data['id']; |
| 169 | 170 | $this->resellertemplate_save($add_array,$reseller); |
| 170 | - } |
|
| 171 | - else |
|
| 171 | + } else |
|
| 172 | 172 | { |
| 173 | 173 | $this->admintemplate_save($add_array); |
| 174 | 174 | } |
@@ -494,12 +494,12 @@ discard block |
||
| 494 | 494 | $data['page_title'] = 'Database Backup'; |
| 495 | 495 | if($add_array['id'] != ''){ |
| 496 | 496 | |
| 497 | - }else{ |
|
| 497 | + } else{ |
|
| 498 | 498 | if($this->form_validation->run() == FALSE) { |
| 499 | 499 | $data['validation_errors'] = validation_errors(); |
| 500 | 500 | echo $data['validation_errors']; |
| 501 | 501 | exit; |
| 502 | - }else{ |
|
| 502 | + } else{ |
|
| 503 | 503 | $db_name = $this->db->database; |
| 504 | 504 | $db_username = $this->db->username; |
| 505 | 505 | $db_password = $this->db->password; |
@@ -524,7 +524,7 @@ discard block |
||
| 524 | 524 | $this->system_model->backup_insert($add_array); |
| 525 | 525 | echo json_encode(array("SUCCESS"=> $add_array['backup_name']." backup exported successfully!")); |
| 526 | 526 | exit; |
| 527 | - }else{ |
|
| 527 | + } else{ |
|
| 528 | 528 | echo 'An error occur when the system tried to backup of the database. Please check yours system settings for the backup section'; |
| 529 | 529 | exit; |
| 530 | 530 | } |
@@ -572,7 +572,7 @@ discard block |
||
| 572 | 572 | exec($run_restore); |
| 573 | 573 | $this->session->set_flashdata('astpp_errormsg', 'Database Restore successfully.'); |
| 574 | 574 | redirect(base_url() . 'systems/database_restore/'); |
| 575 | - }else{ |
|
| 575 | + } else{ |
|
| 576 | 576 | $this->session->set_flashdata('astpp_notification', 'File not exists!'); |
| 577 | 577 | redirect(base_url() . 'systems/database_restore/'); |
| 578 | 578 | } |
@@ -623,7 +623,7 @@ discard block |
||
| 623 | 623 | $query = $this->system_model->import_database($filename,$_FILES['userfile']['name']); |
| 624 | 624 | $this->session->set_flashdata('astpp_errormsg',"The file ". basename( $_FILES['userfile']['name'])." has been uploaded"); |
| 625 | 625 | redirect(base_url()."systems/database_restore/"); |
| 626 | - }else{ |
|
| 626 | + } else{ |
|
| 627 | 627 | $this->session->set_flashdata('astpp_notification',"There is a some issue or invalid file format."); |
| 628 | 628 | redirect(base_url()."systems/database_restore/"); |
| 629 | 629 | } |