@@ -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 | } |