@@ -59,8 +59,9 @@ |
||
59 | 59 | if (isset($taxesList) && is_array($taxesList) && count($taxesList) > 0) { |
60 | 60 | echo "<table>"; |
61 | 61 | foreach ($taxesList as $values) { |
62 | - if ($i == 1) |
|
63 | - echo"<tr>"; |
|
62 | + if ($i == 1) { |
|
63 | + echo"<tr>"; |
|
64 | + } |
|
64 | 65 | ?> |
65 | 66 | <td style="padding-left: 10px;"> |
66 | 67 | <input type="checkbox" id="tax_<?= $values->id; ?>"name="tax_<?= $values->id; ?>" value="<?= $values->id; ?>" <? if (in_array($values->id, $tax_ids)) { |
@@ -57,10 +57,10 @@ |
||
57 | 57 | <div style="color:red;margin-left: 60px;"> |
58 | 58 | <?php |
59 | 59 | if (isset($validation_errors)) { |
60 | - $validation_array=json_decode($validation_errors); |
|
61 | - if(is_object($validation_array)){ |
|
60 | + $validation_array = json_decode($validation_errors); |
|
61 | + if (is_object($validation_array)) { |
|
62 | 62 | $validation_array = get_object_vars($validation_array); |
63 | - foreach($validation_array as $key=>$value) |
|
63 | + foreach ($validation_array as $key=>$value) |
|
64 | 64 | echo $value."<br/>"; |
65 | 65 | } |
66 | 66 | else |
@@ -60,11 +60,12 @@ |
||
60 | 60 | $validation_array=json_decode($validation_errors); |
61 | 61 | if(is_object($validation_array)){ |
62 | 62 | $validation_array = get_object_vars($validation_array); |
63 | - foreach($validation_array as $key=>$value) |
|
64 | - echo $value."<br/>"; |
|
63 | + foreach($validation_array as $key=>$value) { |
|
64 | + echo $value."<br/>"; |
|
65 | + } |
|
66 | + } else { |
|
67 | + echo $validation_errors; |
|
65 | 68 | } |
66 | - else |
|
67 | - echo $validation_errors; |
|
68 | 69 | |
69 | 70 | } |
70 | 71 | ?> |
@@ -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'); |
@@ -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', ''), |
@@ -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,20 +362,20 @@ 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("Import with field map","btn btn-line-blue" ,"fa fa-upload fa-lg", "button_action", "/rates/termination_rate_import_mapper/", 'single'), |
|
369 | - 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("Import with field map", "btn btn-line-blue", "fa fa-upload fa-lg", "button_action", "/rates/termination_rate_import_mapper/", 'single'), |
|
369 | + array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/rates/termination_rate_export_cdr_xls/", 'single') |
|
370 | 370 | )); |
371 | 371 | return $buttons_json; |
372 | 372 | } |
373 | 373 | |
374 | 374 | function build_grid_buttons_origination_rate() { |
375 | - $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"), |
|
376 | - array("Delete", "btn btn-line-danger","fa fa-times-circle fa-lg", "button_action", "/rates/origination_rate_delete_multiple/"), |
|
377 | - array("import", "btn btn-line-blue","fa fa-upload fa-lg", "button_action", "/rates/origination_rate_import/", 'single'), |
|
378 | - array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/rates/origination_rate_export_cdr_xls/", 'single') |
|
375 | + $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"), |
|
376 | + array("Delete", "btn btn-line-danger", "fa fa-times-circle fa-lg", "button_action", "/rates/origination_rate_delete_multiple/"), |
|
377 | + array("import", "btn btn-line-blue", "fa fa-upload fa-lg", "button_action", "/rates/origination_rate_import/", 'single'), |
|
378 | + array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/rates/origination_rate_export_cdr_xls/", 'single') |
|
379 | 379 | |
380 | 380 | )); |
381 | 381 | return $buttons_json; |
@@ -384,7 +384,7 @@ discard block |
||
384 | 384 | function build_termination_rate_list_for_customer() { |
385 | 385 | // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name); |
386 | 386 | $grid_field_arr = json_encode(array( |
387 | - array("<input type='checkbox' name='chkAll' class='ace checking checkall'/><label class='lbl'></label>", "30", "", "", "", "","","false","center"), |
|
387 | + array("<input type='checkbox' name='chkAll' class='ace checking checkall'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center"), |
|
388 | 388 | array("Code", "70", "pattern", "pattern", "", "get_only_numeric_val"), |
389 | 389 | array("Increment", "75", "inc", "", "", ""), |
390 | 390 | array("Connect <br> Charge", "100", "connectcost", "connectcost", "connectcost", "convert_to_currency"), |
@@ -399,16 +399,16 @@ discard block |
||
399 | 399 | function build_block_pattern_list_for_customer() { |
400 | 400 | // array(display name, width, db_field_parent_table,feidname, db_field_child_table,function name); |
401 | 401 | $grid_field_arr = json_encode(array( |
402 | - array("<input type='checkbox' name='chkAll1' class='ace checking'/><label class='lbl'></label>", "30", "", "", "", "","","false","center","PatternChkBox"), |
|
402 | + array("<input type='checkbox' name='chkAll1' class='ace checking'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center", "PatternChkBox"), |
|
403 | 403 | array("Code", "350", "pattern", "pattern", "", "get_only_numeric_val"), |
404 | 404 | array("Destination", "350", "comment", "", "", ""), |
405 | 405 | )); |
406 | 406 | return $grid_field_arr; |
407 | 407 | } |
408 | - function build_pattern_list_for_customer($accountid,$accounttype) { |
|
408 | + function build_pattern_list_for_customer($accountid, $accounttype) { |
|
409 | 409 | |
410 | 410 | $grid_field_arr = json_encode(array( |
411 | - array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "","","false","center"), |
|
411 | + array("<input type='checkbox' name='chkAll' class='ace checkall'/><label class='lbl'></label>", "30", "", "", "", "", "", "false", "center"), |
|
412 | 412 | array("Code", "450", "blocked_patterns", "blocked_patterns", "", "get_only_numeric_val"), |
413 | 413 | array("Destination", "450", "destination", "", "", ""), |
414 | 414 | array("Action", "100", "", "", "", array("DELETE" => array("url" => "accounts/".$accounttype."_delete_block_pattern/$accountid/", "mode" => "single"))) |
@@ -417,7 +417,7 @@ discard block |
||
417 | 417 | } |
418 | 418 | |
419 | 419 | function set_pattern_grid_buttons($accountid) { |
420 | - $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 | + $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"))); |
|
421 | 421 | return $buttons_json; |
422 | 422 | } |
423 | 423 | |
@@ -435,7 +435,7 @@ discard block |
||
435 | 435 | |
436 | 436 | |
437 | 437 | function build_grid_buttons_rates() { |
438 | - $buttons_json = json_encode(array(array("Export","btn btn-xing" ," fa fa-download fa-lg", "button_action", "/rates/resellersrates_xls/", 'single'))); |
|
438 | + $buttons_json = json_encode(array(array("Export", "btn btn-xing", " fa fa-download fa-lg", "button_action", "/rates/resellersrates_xls/", 'single'))); |
|
439 | 439 | return $buttons_json; |
440 | 440 | } |
441 | 441 |
@@ -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 | } |
@@ -113,7 +113,7 @@ |
||
113 | 113 | foreach($csv_value as $field_name => $field_val){ |
114 | 114 | if($csv_key == 0){ |
115 | 115 | echo "<th>".ucfirst($field_name)."</th>"; |
116 | - }else{ |
|
116 | + } else{ |
|
117 | 117 | echo "<td class='portlet-content'>".$field_val."</td>"; |
118 | 118 | } |
119 | 119 | } |
@@ -15,7 +15,7 @@ discard block |
||
15 | 15 | <div class="col-md-12"> |
16 | 16 | <div class="w-box"> |
17 | 17 | <span style="margin-left:10px; text-align: center;background-color: none;color:#DD191D;"> |
18 | - <? if(isset($error) && !empty($error)) { |
|
18 | + <? if (isset($error) && ! empty($error)) { |
|
19 | 19 | echo $error; |
20 | 20 | }?> |
21 | 21 | </span> |
@@ -31,19 +31,19 @@ discard block |
||
31 | 31 | <div class="col-md-12 no-padding"> |
32 | 32 | <label class="col-md-3">Rate Group:</label> |
33 | 33 | <div> |
34 | - <? $pricelists = form_dropdown('pricelist_id', $this->db_model->build_dropdown("id,name", "pricelists","where_arr", array("reseller_id" => "0", "status" => "0")), ''); |
|
34 | + <? $pricelists = form_dropdown('pricelist_id', $this->db_model->build_dropdown("id,name", "pricelists", "where_arr", array("reseller_id" => "0", "status" => "0")), ''); |
|
35 | 35 | echo $pricelists; |
36 | 36 | ?> |
37 | 37 | </div> |
38 | 38 | </div> |
39 | 39 | <? |
40 | - $logintype=$this->session->userdata('userlevel_logintype'); |
|
40 | + $logintype = $this->session->userdata('userlevel_logintype'); |
|
41 | 41 | // $trunk=null; |
42 | - if($logintype !=1) { ?> |
|
42 | + if ($logintype != 1) { ?> |
|
43 | 43 | <div class="col-md-12 no-padding"> |
44 | 44 | <label class="col-md-3">Force Trunk:</label> |
45 | 45 | <div> |
46 | - <? $trunklist = form_dropdown_all('trunk_id', $this->db_model->build_dropdown("id,name", "trunks","where_arr", array("status" => "0")), ''); |
|
46 | + <? $trunklist = form_dropdown_all('trunk_id', $this->db_model->build_dropdown("id,name", "trunks", "where_arr", array("status" => "0")), ''); |
|
47 | 47 | echo $trunklist; |
48 | 48 | ?> |
49 | 49 | </div> |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | <?}?> |
101 | 101 | |
102 | 102 | <?php |
103 | - if(isset($csv_tmp_data) && !empty($csv_tmp_data)){ ?> |
|
103 | + if (isset($csv_tmp_data) && ! empty($csv_tmp_data)) { ?> |
|
104 | 104 | |
105 | 105 | <section class="slice color-three"> |
106 | 106 | <div class="w-section inverse no-padding"> |
@@ -109,14 +109,14 @@ discard block |
||
109 | 109 | <div class="col-md-12 margin-t-10"> |
110 | 110 | <form id="import_form" name="import_form" action="<?=base_url()?>rates/origination_rate_import_file/<?= $pricelistid?>/<?=$trunkid?><?=$check_header?>/" method="POST"> |
111 | 111 | <table width="100%" border="1" class="details_table table"> |
112 | - <? $cnt =7; |
|
113 | - foreach($csv_tmp_data as $csv_key => $csv_value){ |
|
114 | - if($csv_key < 15){ |
|
112 | + <? $cnt = 7; |
|
113 | + foreach ($csv_tmp_data as $csv_key => $csv_value) { |
|
114 | + if ($csv_key < 15) { |
|
115 | 115 | echo "<tr>"; |
116 | - foreach($csv_value as $field_name => $field_val){ |
|
117 | - if($csv_key == 0){ |
|
116 | + foreach ($csv_value as $field_name => $field_val) { |
|
117 | + if ($csv_key == 0) { |
|
118 | 118 | echo "<th>".ucfirst($field_name)."</th>"; |
119 | - }else{ |
|
119 | + } else { |
|
120 | 120 | echo "<td class='portlet-content'>".$field_val."</td>"; |
121 | 121 | } |
122 | 122 | } |
@@ -113,7 +113,7 @@ |
||
113 | 113 | foreach($csv_value as $field_name => $field_val){ |
114 | 114 | if($csv_key == 0){ |
115 | 115 | echo "<th>".ucfirst($field_name)."</th>"; |
116 | - }else{ |
|
116 | + } else{ |
|
117 | 117 | echo "<td class='portlet-content'>".$field_val."</td>"; |
118 | 118 | } |
119 | 119 | } |
@@ -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', |