|
@@ -35,14 +35,14 @@ discard block |
|
|
block discarded – undo |
|
35
|
35
|
$this->load->library('csvreader'); |
|
36
|
36
|
|
|
37
|
37
|
if ($this->session->userdata('user_login') == FALSE) |
|
38
|
|
- redirect(base_url() . '/astpp/login'); |
|
|
38
|
+ redirect(base_url().'/astpp/login'); |
|
39
|
39
|
} |
|
40
|
40
|
|
|
41
|
41
|
function did_add() { |
|
42
|
42
|
$data['page_title'] = 'Create DID'; |
|
43
|
43
|
$data['form'] = $this->form->build_form($this->did_form->get_dids_form_fields(), ''); |
|
44
|
44
|
$data['country_id'] = $this->common->get_field_name('id', 'countrycode', array('country' => Common_model::$global_config['system_config']['country'])); |
|
45
|
|
- if (!$data['country_id']) { |
|
|
45
|
+ if ( ! $data['country_id']) { |
|
46
|
46
|
$data['country_id'] = 1; |
|
47
|
47
|
} |
|
48
|
48
|
$this->load->view('view_did_add_edit', $data); |
|
@@ -64,7 +64,7 @@ discard block |
|
|
block discarded – undo |
|
64
|
64
|
$data['country_id'] = Common_model::$global_config['system_config']['country']; |
|
65
|
65
|
} |
|
66
|
66
|
/* * ************************************************* */ |
|
67
|
|
- if (!$data['country_id']) { |
|
|
67
|
+ if ( ! $data['country_id']) { |
|
68
|
68
|
$data['country_id'] = 1; |
|
69
|
69
|
} |
|
70
|
70
|
$edit_data['setup'] = $this->common_model->to_calculate_currency($edit_data['setup'], '', '', false, false); |
|
@@ -83,9 +83,9 @@ discard block |
|
|
block discarded – undo |
|
83
|
83
|
|
|
84
|
84
|
function did_save() { |
|
85
|
85
|
$add_array = $this->input->post(); |
|
86
|
|
- $parent_id =isset($add_array['parent_id']) && $add_array['parent_id'] >0 ? $add_array['parent_id'] : ''; |
|
87
|
|
- $accountid =isset($add_array['accountid']) && $add_array['accountid'] > 0 ? $add_array['accountid'] : ''; |
|
88
|
|
- $data['form'] = $this->form->build_form($this->did_form->get_dids_form_fields($add_array['id'],$parent_id,$accountid), $add_array); |
|
|
86
|
+ $parent_id = isset($add_array['parent_id']) && $add_array['parent_id'] > 0 ? $add_array['parent_id'] : ''; |
|
|
87
|
+ $accountid = isset($add_array['accountid']) && $add_array['accountid'] > 0 ? $add_array['accountid'] : ''; |
|
|
88
|
+ $data['form'] = $this->form->build_form($this->did_form->get_dids_form_fields($add_array['id'], $parent_id, $accountid), $add_array); |
|
89
|
89
|
if ($add_array['id'] != '') { |
|
90
|
90
|
$data['page_title'] = 'Edit DID'; |
|
91
|
91
|
if ($this->form_validation->run() == FALSE) { |
|
@@ -95,13 +95,13 @@ discard block |
|
|
block discarded – undo |
|
95
|
95
|
} else { |
|
96
|
96
|
$number = $add_array['number']; |
|
97
|
97
|
unset($add_array['number']); |
|
98
|
|
- $add_array['accountid']=isset($add_array['accountid']) ?$add_array['accountid'] : 0; |
|
|
98
|
+ $add_array['accountid'] = isset($add_array['accountid']) ? $add_array['accountid'] : 0; |
|
99
|
99
|
$add_array['setup'] = $this->common_model->add_calculate_currency($add_array['setup'], '', '', false, false); |
|
100
|
100
|
$add_array['monthlycost'] = $this->common_model->add_calculate_currency($add_array['monthlycost'], '', '', false, false); |
|
101
|
101
|
$add_array['connectcost'] = $this->common_model->add_calculate_currency($add_array['connectcost'], '', '', false, false); |
|
102
|
102
|
$add_array['cost'] = $this->common_model->add_calculate_currency($add_array['cost'], '', '', false, false); |
|
103
|
103
|
$this->did_model->edit_did($add_array, $add_array['id'], $number); |
|
104
|
|
- echo json_encode(array("SUCCESS" => $number . " DID Updated Successfully!")); |
|
|
104
|
+ echo json_encode(array("SUCCESS" => $number." DID Updated Successfully!")); |
|
105
|
105
|
exit; |
|
106
|
106
|
} |
|
107
|
107
|
} else { |
|
@@ -120,9 +120,9 @@ discard block |
|
|
block discarded – undo |
|
120
|
120
|
$add_array['monthlycost'] = $this->common_model->add_calculate_currency($add_array['monthlycost'], '', '', false, false); |
|
121
|
121
|
$add_array['connectcost'] = $this->common_model->add_calculate_currency($add_array['connectcost'], '', '', false, false); |
|
122
|
122
|
$add_array['cost'] = $this->common_model->add_calculate_currency($add_array['cost'], '', '', false, false); |
|
123
|
|
- $add_array['accountid']=isset($add_array['accountid'])?$add_array['accountid'] : 0; |
|
|
123
|
+ $add_array['accountid'] = isset($add_array['accountid']) ? $add_array['accountid'] : 0; |
|
124
|
124
|
$this->did_model->add_did($add_array); |
|
125
|
|
- echo json_encode(array("SUCCESS" => $add_array["number"] . " DID Added Successfully!")); |
|
|
125
|
+ echo json_encode(array("SUCCESS" => $add_array["number"]." DID Added Successfully!")); |
|
126
|
126
|
exit; |
|
127
|
127
|
exit; |
|
128
|
128
|
} |
|
@@ -132,7 +132,7 @@ discard block |
|
|
block discarded – undo |
|
132
|
132
|
function did_remove($id) { |
|
133
|
133
|
$this->did_model->remove_did($id); |
|
134
|
134
|
$this->session->set_flashdata('astpp_notification', 'DID Removed Successfully!'); |
|
135
|
|
- redirect(base_url() . 'did/did_list/'); |
|
|
135
|
+ redirect(base_url().'did/did_list/'); |
|
136
|
136
|
} |
|
137
|
137
|
|
|
138
|
138
|
/* |
|
@@ -141,54 +141,54 @@ discard block |
|
|
block discarded – undo |
|
141
|
141
|
*/ |
|
142
|
142
|
|
|
143
|
143
|
function did_list_release($id) { |
|
144
|
|
- $accountinfo=$this->session->userdata('accountinfo'); |
|
145
|
|
- $this->db->where('id',$id); |
|
|
144
|
+ $accountinfo = $this->session->userdata('accountinfo'); |
|
|
145
|
+ $this->db->where('id', $id); |
|
146
|
146
|
$this->db->select('parent_id,accountid,number'); |
|
147
|
|
- $did_info=(array)$this->db->get('dids')->first_row(); |
|
148
|
|
- if($did_info['parent_id'] > 0){ |
|
149
|
|
- $str=$this->common->get_parent_info($did_info['parent_id'],$accountinfo['id']); |
|
150
|
|
- $str=rtrim($str,","); |
|
151
|
|
- $account_result=(array)$this->db->get_where('accounts',"id IN (".$str.")")->result_array(); |
|
152
|
|
- foreach($account_result as $key=>$acc_row){ |
|
153
|
|
- $acc_row['did_number']=$did_info['number']; |
|
|
147
|
+ $did_info = (array)$this->db->get('dids')->first_row(); |
|
|
148
|
+ if ($did_info['parent_id'] > 0) { |
|
|
149
|
+ $str = $this->common->get_parent_info($did_info['parent_id'], $accountinfo['id']); |
|
|
150
|
+ $str = rtrim($str, ","); |
|
|
151
|
+ $account_result = (array)$this->db->get_where('accounts', "id IN (".$str.")")->result_array(); |
|
|
152
|
+ foreach ($account_result as $key=>$acc_row) { |
|
|
153
|
+ $acc_row['did_number'] = $did_info['number']; |
|
154
|
154
|
$this->common->mail_to_users('email_remove_did', $acc_row); |
|
155
|
155
|
} |
|
156
|
156
|
} |
|
157
|
|
- if($accountinfo['type'] == -1){ |
|
158
|
|
- $update_array = array('parent_id' => 0, 'accountid' => 0, 'assign_date' => '0000-00-00 00:00:00', "charge_upto" => "0000-00-00 00:00:00","last_modified_date"=>gmdate("Y-m-d H:i:s"),'call_type'=>'-1','extensions'=>''); |
|
|
157
|
+ if ($accountinfo['type'] == -1) { |
|
|
158
|
+ $update_array = array('parent_id' => 0, 'accountid' => 0, 'assign_date' => '0000-00-00 00:00:00', "charge_upto" => "0000-00-00 00:00:00", "last_modified_date"=>gmdate("Y-m-d H:i:s"), 'call_type'=>'-1', 'extensions'=>''); |
|
159
|
159
|
$where = array('id' => $id); |
|
160
|
160
|
$this->db->where($where); |
|
161
|
161
|
$this->db->update('dids', $update_array); |
|
162
|
|
- if($did_info['parent_id'] > 0){ |
|
163
|
|
- $this->db->where('note',$did_info['number']); |
|
|
162
|
+ if ($did_info['parent_id'] > 0) { |
|
|
163
|
+ $this->db->where('note', $did_info['number']); |
|
164
|
164
|
$this->db->delete("reseller_pricing"); |
|
165
|
165
|
} |
|
166
|
|
- }else{ |
|
167
|
|
- $reseller_ids=$this->common->get_subreseller_info($accountinfo['id']); |
|
168
|
|
- $reseller_ids=rtrim($reseller_ids,","); |
|
169
|
|
- $where="parent_id IN ($reseller_ids)"; |
|
170
|
|
- $this->db->where('note',$did_info['number']); |
|
171
|
|
- $this->db->delete('reseller_pricing',$where); |
|
|
166
|
+ } else { |
|
|
167
|
+ $reseller_ids = $this->common->get_subreseller_info($accountinfo['id']); |
|
|
168
|
+ $reseller_ids = rtrim($reseller_ids, ","); |
|
|
169
|
+ $where = "parent_id IN ($reseller_ids)"; |
|
|
170
|
+ $this->db->where('note', $did_info['number']); |
|
|
171
|
+ $this->db->delete('reseller_pricing', $where); |
|
172
|
172
|
} |
|
173
|
|
- if($accountinfo['type']==1){ |
|
174
|
|
- $update_array = array('parent_id' => $accountinfo['id'], 'accountid' => 0, 'assign_date' => '0000-00-00 00:00:00', "charge_upto" => "0000-00-00 00:00:00","last_modified_date"=>gmdate("Y-m-d H:i:s"),'call_type'=>'-1','extensions'=>''); |
|
175
|
|
- }else{ |
|
176
|
|
- $update_array = array('parent_id' => 0, 'accountid' => 0, 'assign_date' => '0000-00-00 00:00:00', "charge_upto" => "0000-00-00 00:00:00","last_modified_date"=>gmdate("Y-m-d H:i:s"),'call_type'=>'-1','extensions'=>''); |
|
|
173
|
+ if ($accountinfo['type'] == 1) { |
|
|
174
|
+ $update_array = array('parent_id' => $accountinfo['id'], 'accountid' => 0, 'assign_date' => '0000-00-00 00:00:00', "charge_upto" => "0000-00-00 00:00:00", "last_modified_date"=>gmdate("Y-m-d H:i:s"), 'call_type'=>'-1', 'extensions'=>''); |
|
|
175
|
+ } else { |
|
|
176
|
+ $update_array = array('parent_id' => 0, 'accountid' => 0, 'assign_date' => '0000-00-00 00:00:00', "charge_upto" => "0000-00-00 00:00:00", "last_modified_date"=>gmdate("Y-m-d H:i:s"), 'call_type'=>'-1', 'extensions'=>''); |
|
177
|
177
|
} |
|
178
|
178
|
$where = array('id' => $id); |
|
179
|
179
|
$this->db->where($where); |
|
180
|
180
|
$this->db->update('dids', $update_array); |
|
181
|
|
- $accountid=$did_info['accountid'] > 0 ? $did_info['accountid']:0; |
|
182
|
|
- if($did_info['accountid'] > 0 ){ |
|
183
|
|
- $email_user_id=$did_info['accountid']; |
|
184
|
|
- }elseif($did_info['parent_id'] > 0){ |
|
185
|
|
- $email_user_id=$did_info['parent_id']; |
|
|
181
|
+ $accountid = $did_info['accountid'] > 0 ? $did_info['accountid'] : 0; |
|
|
182
|
+ if ($did_info['accountid'] > 0) { |
|
|
183
|
+ $email_user_id = $did_info['accountid']; |
|
|
184
|
+ }elseif ($did_info['parent_id'] > 0) { |
|
|
185
|
+ $email_user_id = $did_info['parent_id']; |
|
186
|
186
|
} |
|
187
|
|
- $accountinfo=(array)$this->db->get_where('accounts',array("id"=>$email_user_id))->first_row(); |
|
|
187
|
+ $accountinfo = (array)$this->db->get_where('accounts', array("id"=>$email_user_id))->first_row(); |
|
188
|
188
|
$accountinfo['did_number'] = $did_info['number']; |
|
189
|
189
|
$this->common->mail_to_users('email_remove_did', $accountinfo); |
|
190
|
190
|
$this->session->set_flashdata('astpp_errormsg', 'DID Released Successfully!'); |
|
191
|
|
- redirect(base_url() . 'did/did_list/'); |
|
|
191
|
+ redirect(base_url().'did/did_list/'); |
|
192
|
192
|
} |
|
193
|
193
|
|
|
194
|
194
|
function did_list() { |
|
@@ -204,33 +204,33 @@ discard block |
|
|
block discarded – undo |
|
204
|
204
|
} |
|
205
|
205
|
|
|
206
|
206
|
if ($this->session->userdata['userlevel_logintype'] == '1') { |
|
207
|
|
- $drp_list=array(); |
|
|
207
|
+ $drp_list = array(); |
|
208
|
208
|
$accountinfo = $this->session->userdata('accountinfo'); |
|
209
|
|
- if($accountinfo['reseller_id'] > 0){ |
|
210
|
|
- $dids_array=$this->db->query("SELECT a.id AS id,a.number as number, b.monthlycost, b.setup FROM dids AS a, reseller_pricing AS b WHERE a.number = b.note AND b.reseller_id = ".$accountinfo['reseller_id']." AND a.parent_id =".$accountinfo['reseller_id'])->result_array(); |
|
211
|
|
- }else{ |
|
|
209
|
+ if ($accountinfo['reseller_id'] > 0) { |
|
|
210
|
+ $dids_array = $this->db->query("SELECT a.id AS id,a.number as number, b.monthlycost, b.setup FROM dids AS a, reseller_pricing AS b WHERE a.number = b.note AND b.reseller_id = ".$accountinfo['reseller_id']." AND a.parent_id =".$accountinfo['reseller_id'])->result_array(); |
|
|
211
|
+ } else { |
|
212
|
212
|
$this->db->select('id,monthlycost,setup,number'); |
|
213
|
|
- $this->db->where('accountid',0); |
|
214
|
|
- $this->db->where('parent_id',0); |
|
215
|
|
- $dids_array=$this->db->get('dids')->result_array(); |
|
|
213
|
+ $this->db->where('accountid', 0); |
|
|
214
|
+ $this->db->where('parent_id', 0); |
|
|
215
|
+ $dids_array = $this->db->get('dids')->result_array(); |
|
216
|
216
|
} |
|
217
|
|
- if(!empty($dids_array)){ |
|
|
217
|
+ if ( ! empty($dids_array)) { |
|
218
|
218
|
foreach ($dids_array as $drp_value) { |
|
219
|
|
- if (!empty($drp_value['monthlycost']) && $drp_value['monthlycost'] != 0) { |
|
|
219
|
+ if ( ! empty($drp_value['monthlycost']) && $drp_value['monthlycost'] != 0) { |
|
220
|
220
|
$did_cost = $this->common_model->to_calculate_currency($drp_value['monthlycost'], '', '', true, false); |
|
221
|
221
|
} else { |
|
222
|
222
|
$did_cost = 0; |
|
223
|
223
|
} |
|
224
|
|
- if (!empty($drp_value['setup']) && $drp_value['setup'] != 0) { |
|
|
224
|
+ if ( ! empty($drp_value['setup']) && $drp_value['setup'] != 0) { |
|
225
|
225
|
$did_setup = $this->common_model->to_calculate_currency($drp_value['setup'], '', '', true, false); |
|
226
|
226
|
} else { |
|
227
|
227
|
$did_setup = 0; |
|
228
|
228
|
} |
|
229
|
|
- $drp_list[$drp_value['id']] = $drp_value['number'] . ' ( Setup : ' . $did_setup . ')' . '( Monthly : ' . $did_cost . ' )'; |
|
|
229
|
+ $drp_list[$drp_value['id']] = $drp_value['number'].' ( Setup : '.$did_setup.')'.'( Monthly : '.$did_cost.' )'; |
|
230
|
230
|
/* * ********************************************************************************************* */ |
|
231
|
231
|
} |
|
232
|
232
|
} |
|
233
|
|
- $data['didlist'] = form_dropdown_all(array("name"=>"free_did_list","id"=>"free_did_list","class"=>"did_dropdown"), $drp_list, ''); |
|
|
233
|
+ $data['didlist'] = form_dropdown_all(array("name"=>"free_did_list", "id"=>"free_did_list", "class"=>"did_dropdown"), $drp_list, ''); |
|
234
|
234
|
} |
|
235
|
235
|
if ($this->session->userdata['userlevel_logintype'] == '1') { |
|
236
|
236
|
$data['grid_fields'] = $this->did_form->build_did_list_for_reseller_login(); |
|
@@ -270,7 +270,7 @@ discard block |
|
|
block discarded – undo |
|
270
|
270
|
$this->session->set_userdata('did_list_search', $action); |
|
271
|
271
|
} |
|
272
|
272
|
if (@$ajax_search != 1) { |
|
273
|
|
- redirect(base_url() . 'did/did_list/'); |
|
|
273
|
+ redirect(base_url().'did/did_list/'); |
|
274
|
274
|
} |
|
275
|
275
|
} |
|
276
|
276
|
|
|
@@ -318,10 +318,10 @@ discard block |
|
|
block discarded – undo |
|
318
|
318
|
*/ |
|
319
|
319
|
function customer_did($accountid, $accounttype) { |
|
320
|
320
|
$json_data = array(); |
|
321
|
|
- $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_did'); |
|
322
|
|
- $account_arr=(array)$this->db->get_where('accounts',array("id"=>$accountid))->first_row(); |
|
|
321
|
+ $instant_search = $this->session->userdata('left_panel_search_'.$accounttype.'_did'); |
|
|
322
|
+ $account_arr = (array)$this->db->get_where('accounts', array("id"=>$accountid))->first_row(); |
|
323
|
323
|
$field_name = $accounttype == "reseller" ? "parent_id" : 'accountid'; |
|
324
|
|
- $like_str=!empty($instant_search) ? |
|
|
324
|
+ $like_str = ! empty($instant_search) ? |
|
325
|
325
|
"(a.note like '%$instant_search%' |
|
326
|
326
|
OR a.init_inc like '%$instant_search%' |
|
327
|
327
|
OR a.inc like '%$instant_search%' |
|
@@ -330,32 +330,32 @@ discard block |
|
|
block discarded – undo |
|
330
|
330
|
OR a.setup like '%$instant_search%' |
|
331
|
331
|
OR a.monthlycost like '%$instant_search%' |
|
332
|
332
|
OR a.connectcost like '%$instant_search%' |
|
333
|
|
- )" :null; |
|
|
333
|
+ )" : null; |
|
334
|
334
|
if ($account_arr['reseller_id'] != 0) { |
|
335
|
|
- if(!empty($like_str)) |
|
|
335
|
+ if ( ! empty($like_str)) |
|
336
|
336
|
$this->db->where($like_str); |
|
337
|
|
- if($accounttype=='reseller'){ |
|
338
|
|
- $this->db->where('a.note','b.number',false); |
|
339
|
|
- $this->db->where('a.reseller_id',$account_arr['id']); |
|
340
|
|
- $this->db->where('a.parent_id',$account_arr['reseller_id']); |
|
|
337
|
+ if ($accounttype == 'reseller') { |
|
|
338
|
+ $this->db->where('a.note', 'b.number', false); |
|
|
339
|
+ $this->db->where('a.reseller_id', $account_arr['id']); |
|
|
340
|
+ $this->db->where('a.parent_id', $account_arr['reseller_id']); |
|
341
|
341
|
$this->db->select('count(a.id) as count'); |
|
342
|
|
- $count_result=(array)$this->db->get('reseller_pricing as a,dids as b')->first_row(); |
|
|
342
|
+ $count_result = (array)$this->db->get('reseller_pricing as a,dids as b')->first_row(); |
|
343
|
343
|
$paging_data = $this->form->load_grid_config($count_result['count'], $_GET['rp'], $_GET['page']); |
|
344
|
344
|
$json_data = $paging_data["json_paging"]; |
|
345
|
|
- $this->db->where('a.note','b.number',false); |
|
346
|
|
- $this->db->where('a.reseller_id',$account_arr['id']); |
|
347
|
|
- $this->db->where('a.parent_id',$account_arr['reseller_id']); |
|
|
345
|
+ $this->db->where('a.note', 'b.number', false); |
|
|
346
|
+ $this->db->where('a.reseller_id', $account_arr['id']); |
|
|
347
|
+ $this->db->where('a.parent_id', $account_arr['reseller_id']); |
|
348
|
348
|
$this->db->select('a . * , b.id, a.reseller_id AS accountid,a.note as number,b.country_id as country_id'); |
|
349
|
|
- $this->db->limit($paging_data["paging"]["page_no"],$paging_data["paging"]["start"]); |
|
350
|
|
- $query=$this->db->get('reseller_pricing as a,dids as b'); |
|
351
|
|
- }else{ |
|
352
|
|
- $count_result=(array)$this->db->query('select count(id) as count from dids where accountid='.$accountid." AND parent_id =".$account_arr['reseller_id'])->first_row(); |
|
|
349
|
+ $this->db->limit($paging_data["paging"]["page_no"], $paging_data["paging"]["start"]); |
|
|
350
|
+ $query = $this->db->get('reseller_pricing as a,dids as b'); |
|
|
351
|
+ } else { |
|
|
352
|
+ $count_result = (array)$this->db->query('select count(id) as count from dids where accountid='.$accountid." AND parent_id =".$account_arr['reseller_id'])->first_row(); |
|
353
|
353
|
$paging_data = $this->form->load_grid_config($count_result['count'], $_GET['rp'], $_GET['page']); |
|
354
|
354
|
$json_data = $paging_data["json_paging"]; |
|
355
|
|
- $query=$this->db->query("SELECT a . * ,a.note as number,b.country_id as country_id,b.id FROM reseller_pricing AS a, dids AS b WHERE b.accountid =".$account_arr['id']." AND a.note = b.number AND a.reseller_id =".$account_arr['reseller_id']); |
|
|
355
|
+ $query = $this->db->query("SELECT a . * ,a.note as number,b.country_id as country_id,b.id FROM reseller_pricing AS a, dids AS b WHERE b.accountid =".$account_arr['id']." AND a.note = b.number AND a.reseller_id =".$account_arr['reseller_id']); |
|
356
|
356
|
} |
|
357
|
|
- }else{ |
|
358
|
|
- $like_str=!empty($instant_search) ? |
|
|
357
|
+ } else { |
|
|
358
|
+ $like_str = ! empty($instant_search) ? |
|
359
|
359
|
"(dids.number like '%$instant_search%' |
|
360
|
360
|
OR dids.inc like '%$instant_search%' |
|
361
|
361
|
OR dids.cost like '%$instant_search%' |
|
@@ -363,14 +363,14 @@ discard block |
|
|
block discarded – undo |
|
363
|
363
|
OR dids.setup like '%$instant_search%' |
|
364
|
364
|
OR dids.monthlycost like '%$instant_search%' |
|
365
|
365
|
OR dids.connectcost like '%$instant_search%' |
|
366
|
|
- )" :null; |
|
367
|
|
- if(!empty($like_str)) |
|
|
366
|
+ )" : null; |
|
|
367
|
+ if ( ! empty($like_str)) |
|
368
|
368
|
$this->db->where($like_str); |
|
369
|
369
|
$where = array($field_name => $accountid); |
|
370
|
370
|
$count_all = $this->db_model->countQuery("*", "dids", $where); |
|
371
|
371
|
$paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
|
372
|
372
|
$json_data = $paging_data["json_paging"]; |
|
373
|
|
- if(!empty($like_str)) |
|
|
373
|
+ if ( ! empty($like_str)) |
|
374
|
374
|
$this->db->where($like_str); |
|
375
|
375
|
$query = $this->db_model->select("*", "dids", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]); |
|
376
|
376
|
} |
|
@@ -382,9 +382,9 @@ discard block |
|
|
block discarded – undo |
|
382
|
382
|
$ids = $this->input->post("selected_ids", true); |
|
383
|
383
|
$where = "id IN ($ids)"; |
|
384
|
384
|
$this->db->where($where); |
|
385
|
|
- $this->db->select("group_concat(concat('''',number,'''')) as number",false); |
|
386
|
|
- $dids_result=(array)$this->db->get('dids')->first_row(); |
|
387
|
|
- $notes_where="note IN (".$dids_result['number'].")"; |
|
|
385
|
+ $this->db->select("group_concat(concat('''',number,'''')) as number", false); |
|
|
386
|
+ $dids_result = (array)$this->db->get('dids')->first_row(); |
|
|
387
|
+ $notes_where = "note IN (".$dids_result['number'].")"; |
|
388
|
388
|
$this->db->where($notes_where); |
|
389
|
389
|
$this->db->delete('reseller_pricing'); |
|
390
|
390
|
$this->db->where($where); |
|
@@ -398,7 +398,7 @@ discard block |
|
|
block discarded – undo |
|
398
|
398
|
*/ |
|
399
|
399
|
function did_reseller_edit($action = false, $id = false) { |
|
400
|
400
|
$data['page_title'] = 'Edit DID '; |
|
401
|
|
- $accountinfo=$this->session->userdata('accountinfo'); |
|
|
401
|
+ $accountinfo = $this->session->userdata('accountinfo'); |
|
402
|
402
|
if ($action == 'edit') { |
|
403
|
403
|
if (($this->input->post())) { |
|
404
|
404
|
$post = $this->input->post(); |
|
@@ -427,7 +427,7 @@ discard block |
|
|
block discarded – undo |
|
427
|
427
|
$accountinfo = $this->did_model->get_account($accountinfo['number']); |
|
428
|
428
|
$reseller_did = $this->db_model->getSelect("*", "reseller_pricing", array('id' => $id)); |
|
429
|
429
|
$reseller_didinfo = (array)$reseller_did->first_row(); |
|
430
|
|
- if (!empty($reseller_didinfo)) { |
|
|
430
|
+ if ( ! empty($reseller_didinfo)) { |
|
431
|
431
|
$reseller_didinfo['setup'] = $this->common_model->to_calculate_currency($reseller_didinfo['setup'], '', '', true, false); |
|
432
|
432
|
$reseller_didinfo['monthlycost'] = $this->common_model->to_calculate_currency($reseller_didinfo['monthlycost'], '', '', true, false); |
|
433
|
433
|
$reseller_didinfo['connectcost'] = $this->common_model->to_calculate_currency($reseller_didinfo['connectcost'], '', '', true, false); |
|
@@ -441,43 +441,43 @@ discard block |
|
|
block discarded – undo |
|
441
|
441
|
} |
|
442
|
442
|
} |
|
443
|
443
|
if ($action == 'delete') { |
|
444
|
|
- $this->db->where('id',$id); |
|
|
444
|
+ $this->db->where('id', $id); |
|
445
|
445
|
$this->db->select('note'); |
|
446
|
|
- $reseller_pricing=(array)$this->db->get('reseller_pricing')->first_row(); |
|
447
|
|
- $did_number=$reseller_pricing['note']; |
|
448
|
|
- $did_info=(array)$this->db->get_where('dids',array('number'=>$did_number))->first_row(); |
|
449
|
|
- $query="select count(id) as count from reseller_pricing where id >= (select id from reseller_pricing where note =$did_number AND parent_id =".$accountinfo['reseller_id']." AND reseller_id =".$accountinfo['id'].") AND note= $did_number order by id desc"; |
|
450
|
|
- $result=(array)$this->db->query($query)->first_row(); |
|
451
|
|
- if($result['count'] > 0){ |
|
452
|
|
- $str=$this->common->get_parent_info($did_info['parent_id'],$accountinfo['id']); |
|
453
|
|
- $str=rtrim($str,","); |
|
454
|
|
- $account_result=(array)$this->db->get_where('accounts',"id IN (".$str.")")->result_array(); |
|
455
|
|
- foreach($account_result as $key=>$acc_row){ |
|
456
|
|
- $acc_row['did_number']=$did_info['number']; |
|
|
446
|
+ $reseller_pricing = (array)$this->db->get('reseller_pricing')->first_row(); |
|
|
447
|
+ $did_number = $reseller_pricing['note']; |
|
|
448
|
+ $did_info = (array)$this->db->get_where('dids', array('number'=>$did_number))->first_row(); |
|
|
449
|
+ $query = "select count(id) as count from reseller_pricing where id >= (select id from reseller_pricing where note =$did_number AND parent_id =".$accountinfo['reseller_id']." AND reseller_id =".$accountinfo['id'].") AND note= $did_number order by id desc"; |
|
|
450
|
+ $result = (array)$this->db->query($query)->first_row(); |
|
|
451
|
+ if ($result['count'] > 0) { |
|
|
452
|
+ $str = $this->common->get_parent_info($did_info['parent_id'], $accountinfo['id']); |
|
|
453
|
+ $str = rtrim($str, ","); |
|
|
454
|
+ $account_result = (array)$this->db->get_where('accounts', "id IN (".$str.")")->result_array(); |
|
|
455
|
+ foreach ($account_result as $key=>$acc_row) { |
|
|
456
|
+ $acc_row['did_number'] = $did_info['number']; |
|
457
|
457
|
$this->common->mail_to_users('email_remove_did', $acc_row); |
|
458
|
458
|
} |
|
459
|
|
- $reseller_ids=$this->common->get_subreseller_info($accountinfo['id']); |
|
460
|
|
- $reseller_ids=rtrim($reseller_ids,","); |
|
461
|
|
- $where="parent_id IN ($reseller_ids)"; |
|
462
|
|
- $this->db->where('note',$did_info['number']); |
|
463
|
|
- $this->db->delete('reseller_pricing',$where); |
|
464
|
|
- $this->db->where('reseller_id',$accountinfo['id']); |
|
465
|
|
- $this->db->where('note',$did_info['number']); |
|
|
459
|
+ $reseller_ids = $this->common->get_subreseller_info($accountinfo['id']); |
|
|
460
|
+ $reseller_ids = rtrim($reseller_ids, ","); |
|
|
461
|
+ $where = "parent_id IN ($reseller_ids)"; |
|
|
462
|
+ $this->db->where('note', $did_info['number']); |
|
|
463
|
+ $this->db->delete('reseller_pricing', $where); |
|
|
464
|
+ $this->db->where('reseller_id', $accountinfo['id']); |
|
|
465
|
+ $this->db->where('note', $did_info['number']); |
|
466
|
466
|
$this->db->delete('reseller_pricing'); |
|
467
|
467
|
} |
|
468
|
|
- $this->db->where('number',$did_number); |
|
|
468
|
+ $this->db->where('number', $did_number); |
|
469
|
469
|
$this->db->select('accountid'); |
|
470
|
|
- $did_array=(array)$this->db->get('dids')->first_row(); |
|
471
|
|
- if($did_array['accountid'] > 0){ |
|
472
|
|
- $customer_info=(array)$this->db->get_where('accounts',array('id'=>$did_array['accountid']))->first_row(); |
|
473
|
|
- $customer_info['did_number']=$did_number; |
|
|
470
|
+ $did_array = (array)$this->db->get('dids')->first_row(); |
|
|
471
|
+ if ($did_array['accountid'] > 0) { |
|
|
472
|
+ $customer_info = (array)$this->db->get_where('accounts', array('id'=>$did_array['accountid']))->first_row(); |
|
|
473
|
+ $customer_info['did_number'] = $did_number; |
|
474
|
474
|
$this->common->mail_to_users('email_remove_did', $customer_info); |
|
475
|
475
|
} |
|
476
|
|
- $did_array=array("accountid"=>0,"parent_id"=>$accountinfo['reseller_id'], "assign_date" => "0000-00-00 00:00:00", "charge_upto" => "0000-00-00 00:00:00"); |
|
477
|
|
- $this->db->where('number',$did_number); |
|
478
|
|
- $this->db->update('dids',$did_array); |
|
|
476
|
+ $did_array = array("accountid"=>0, "parent_id"=>$accountinfo['reseller_id'], "assign_date" => "0000-00-00 00:00:00", "charge_upto" => "0000-00-00 00:00:00"); |
|
|
477
|
+ $this->db->where('number', $did_number); |
|
|
478
|
+ $this->db->update('dids', $did_array); |
|
479
|
479
|
$this->session->set_flashdata('astpp_notification', 'DID Removed Successfully!'); |
|
480
|
|
- redirect(base_url() . 'did/did_list/'); |
|
|
480
|
+ redirect(base_url().'did/did_list/'); |
|
481
|
481
|
} |
|
482
|
482
|
} |
|
483
|
483
|
|
|
@@ -486,37 +486,37 @@ discard block |
|
|
block discarded – undo |
|
486
|
486
|
$accountinfo = $this->session->userdata('accountinfo'); |
|
487
|
487
|
$where = array('id' => $accountinfo['id']); |
|
488
|
488
|
$account = $this->db_model->getSelect("*", "accounts", $where); |
|
489
|
|
- $currency_name=$this->common->get_field_name('currency',"currency",array('id'=>$accountinfo['currency_id'])); |
|
490
|
|
- $accountinfo= (array)$account->first_row(); |
|
|
489
|
+ $currency_name = $this->common->get_field_name('currency', "currency", array('id'=>$accountinfo['currency_id'])); |
|
|
490
|
+ $accountinfo = (array)$account->first_row(); |
|
491
|
491
|
if (($this->input->post())) { |
|
492
|
492
|
$post = $this->input->post(); |
|
493
|
493
|
if (isset($post['free_did_list']) && $post['free_did_list'] != '') { |
|
494
|
494
|
// For deduction of admin price to reseller |
|
495
|
495
|
$didinfo = $this->did_model->get_did_by_number($post['free_did_list']); |
|
496
|
|
- if($accountinfo['reseller_id'] > 0 ){ |
|
497
|
|
- $reseller_pricing_query = $this->db_model->getSelect("call_type,setup,extensions,monthlycost,connectcost,includedseconds,cost,inc", "reseller_pricing", array("note" => $didinfo['number'],'reseller_id'=>$accountinfo['reseller_id'])); |
|
|
496
|
+ if ($accountinfo['reseller_id'] > 0) { |
|
|
497
|
+ $reseller_pricing_query = $this->db_model->getSelect("call_type,setup,extensions,monthlycost,connectcost,includedseconds,cost,inc", "reseller_pricing", array("note" => $didinfo['number'], 'reseller_id'=>$accountinfo['reseller_id'])); |
|
498
|
498
|
$reseller_pricing_result = (array)$reseller_pricing_query->first_row(); |
|
499
|
|
- $didinfo['call_type']=$reseller_pricing_result['call_type']; |
|
500
|
|
- $didinfo['extensions']=$reseller_pricing_result['extensions']; |
|
501
|
|
- $didinfo['setup']=$reseller_pricing_result['setup']; |
|
502
|
|
- $didinfo['monthlycost']=$reseller_pricing_result['monthlycost']; |
|
503
|
|
- $didinfo['connectcost']=$reseller_pricing_result['connectcost']; |
|
504
|
|
- $didinfo['includedseconds']=$reseller_pricing_result['includedseconds']; |
|
505
|
|
- $didinfo['cost']=$reseller_pricing_result['cost']; |
|
506
|
|
- $didinfo['inc']=$reseller_pricing_result['inc']; |
|
|
499
|
+ $didinfo['call_type'] = $reseller_pricing_result['call_type']; |
|
|
500
|
+ $didinfo['extensions'] = $reseller_pricing_result['extensions']; |
|
|
501
|
+ $didinfo['setup'] = $reseller_pricing_result['setup']; |
|
|
502
|
+ $didinfo['monthlycost'] = $reseller_pricing_result['monthlycost']; |
|
|
503
|
+ $didinfo['connectcost'] = $reseller_pricing_result['connectcost']; |
|
|
504
|
+ $didinfo['includedseconds'] = $reseller_pricing_result['includedseconds']; |
|
|
505
|
+ $didinfo['cost'] = $reseller_pricing_result['cost']; |
|
|
506
|
+ $didinfo['inc'] = $reseller_pricing_result['inc']; |
|
507
|
507
|
} |
|
508
|
508
|
$available_bal = $this->db_model->get_available_bal($accountinfo); |
|
509
|
509
|
$accountinfo['did_number'] = $didinfo['number']; |
|
510
|
510
|
$accountinfo['did_country_id'] = $didinfo['country_id']; |
|
511
|
|
- $accountinfo['did_setup'] = $this->common_model->calculate_currency($didinfo['setup'],'',$currency_name,true,true); |
|
512
|
|
- $accountinfo['did_monthlycost'] = $this->common_model->calculate_currency($didinfo['monthlycost'],'',$currency_name,true,true); |
|
|
511
|
+ $accountinfo['did_setup'] = $this->common_model->calculate_currency($didinfo['setup'], '', $currency_name, true, true); |
|
|
512
|
+ $accountinfo['did_monthlycost'] = $this->common_model->calculate_currency($didinfo['monthlycost'], '', $currency_name, true, true); |
|
513
|
513
|
$accountinfo['did_maxchannels'] = $didinfo['maxchannels']; |
|
514
|
514
|
if ($available_bal >= $didinfo["setup"]) { |
|
515
|
515
|
$available_bal = $this->db_model->update_balance($didinfo['setup'], $accountinfo['id'], "debit"); |
|
516
|
|
- $this->db_model->update("dids", array('parent_id' => $accountinfo['id'],"assign_date"=>gmdate("Y-m-d H:i:s")), array("id" => $didinfo['id'])); |
|
|
516
|
+ $this->db_model->update("dids", array('parent_id' => $accountinfo['id'], "assign_date"=>gmdate("Y-m-d H:i:s")), array("id" => $didinfo['id'])); |
|
517
|
517
|
$this->did_model->insert_reseller_pricing($accountinfo, $didinfo); |
|
518
|
|
- $this->common->add_invoice_details($accountinfo,"DIDCHRG",$didinfo['setup'],$didinfo['number']); |
|
519
|
|
- $this->common->mail_to_users('email_add_did', $accountinfo,"",$didinfo['number']); |
|
|
518
|
+ $this->common->add_invoice_details($accountinfo, "DIDCHRG", $didinfo['setup'], $didinfo['number']); |
|
|
519
|
+ $this->common->mail_to_users('email_add_did', $accountinfo, "", $didinfo['number']); |
|
520
|
520
|
$this->session->set_flashdata('astpp_errormsg', 'DID Purchased Successfully.'); |
|
521
|
521
|
} else { |
|
522
|
522
|
$this->session->set_flashdata('astpp_notification', 'Insuffiecient fund to purchase this did'); |
|
@@ -525,7 +525,7 @@ discard block |
|
|
block discarded – undo |
|
525
|
525
|
$this->session->set_flashdata('astpp_notification', 'Please Select DID.'); |
|
526
|
526
|
} |
|
527
|
527
|
} |
|
528
|
|
- redirect(base_url() . 'did/did_list/'); |
|
|
528
|
+ redirect(base_url().'did/did_list/'); |
|
529
|
529
|
exit; |
|
530
|
530
|
} |
|
531
|
531
|
|
|
@@ -547,8 +547,8 @@ discard block |
|
|
block discarded – undo |
|
547
|
547
|
|
|
548
|
548
|
function did_download_sample_file($file_name) { |
|
549
|
549
|
$this->load->helper('download'); |
|
550
|
|
- $full_path = base_url() . "assets/Rates_File/" . $file_name . ".csv"; |
|
551
|
|
- $arrContextOptions=array( |
|
|
550
|
+ $full_path = base_url()."assets/Rates_File/".$file_name.".csv"; |
|
|
551
|
+ $arrContextOptions = array( |
|
552
|
552
|
"ssl"=>array( |
|
553
|
553
|
"verify_peer"=>false, |
|
554
|
554
|
"verify_peer_name"=>false, |
|
@@ -567,28 +567,28 @@ discard block |
|
|
block discarded – undo |
|
567
|
567
|
$this->session->set_userdata('import_did_rate_csv', ""); |
|
568
|
568
|
$error_data = $this->session->userdata('import_did_csv_error'); |
|
569
|
569
|
$full_path = $this->config->item('rates-file-path'); |
|
570
|
|
- if (file_exists($full_path . $error_data) && $error_data != "") { |
|
571
|
|
- unlink($full_path . $error_data); |
|
|
570
|
+ if (file_exists($full_path.$error_data) && $error_data != "") { |
|
|
571
|
+ unlink($full_path.$error_data); |
|
572
|
572
|
$this->session->set_userdata('import_did_csv_error', ""); |
|
573
|
573
|
} |
|
574
|
|
- $accountinfo=$this->session->userdata('accountinfo'); |
|
575
|
|
- $this->db->where('id',$accountinfo['currency_id']); |
|
|
574
|
+ $accountinfo = $this->session->userdata('accountinfo'); |
|
|
575
|
+ $this->db->where('id', $accountinfo['currency_id']); |
|
576
|
576
|
$this->db->select('currency'); |
|
577
|
|
- $currency_info=(array)$this->db->get('currency')->first_row(); |
|
578
|
|
- $data['fields']="DID,Country,Account,Per Minute Cost(".$currency_info['currency']."),Initial Increment,Increment,Setup Fee(".$currency_info['currency']."),Monthly Fee(".$currency_info['currency']."),Call Type,Destination,Status"; |
|
|
577
|
+ $currency_info = (array)$this->db->get('currency')->first_row(); |
|
|
578
|
+ $data['fields'] = "DID,Country,Account,Per Minute Cost(".$currency_info['currency']."),Initial Increment,Increment,Setup Fee(".$currency_info['currency']."),Monthly Fee(".$currency_info['currency']."),Call Type,Destination,Status"; |
|
579
|
579
|
$this->load->view('view_import_did', $data); |
|
580
|
580
|
} |
|
581
|
581
|
|
|
582
|
582
|
function did_preview_file() { |
|
583
|
583
|
$data['page_title'] = 'Import DIDs'; |
|
584
|
584
|
$config_did_array = $this->config->item('DID-rates-field'); |
|
585
|
|
- $accountinfo=$this->session->userdata('accountinfo'); |
|
586
|
|
- $this->db->where('id',$accountinfo['currency_id']); |
|
|
585
|
+ $accountinfo = $this->session->userdata('accountinfo'); |
|
|
586
|
+ $this->db->where('id', $accountinfo['currency_id']); |
|
587
|
587
|
$this->db->select('currency'); |
|
588
|
|
- $currency_info=(array)$this->db->get('currency')->first_row(); |
|
589
|
|
- foreach($config_did_array as $key=>$value){ |
|
|
588
|
+ $currency_info = (array)$this->db->get('currency')->first_row(); |
|
|
589
|
+ foreach ($config_did_array as $key=>$value) { |
|
590
|
590
|
$key = str_replace('CURRENCY', $currency_info['currency'], $key); |
|
591
|
|
- $did_fields_array[$key]=$value; |
|
|
591
|
+ $did_fields_array[$key] = $value; |
|
592
|
592
|
} |
|
593
|
593
|
$check_header = $this->input->post('check_header', true); |
|
594
|
594
|
$invalid_flag = false; |
|
@@ -599,10 +599,10 @@ discard block |
|
|
block discarded – undo |
|
599
|
599
|
if ($error == 0) { |
|
600
|
600
|
$uploadedFile = $_FILES["didimport"]["tmp_name"]; |
|
601
|
601
|
$full_path = $this->config->item('rates-file-path'); |
|
602
|
|
- $actual_file_name = "ASTPP-DIDs-" . date("Y-m-d H:i:s") . "." . $ext; |
|
603
|
|
- if (move_uploaded_file($uploadedFile, $full_path . $actual_file_name)) { |
|
|
602
|
+ $actual_file_name = "ASTPP-DIDs-".date("Y-m-d H:i:s").".".$ext; |
|
|
603
|
+ if (move_uploaded_file($uploadedFile, $full_path.$actual_file_name)) { |
|
604
|
604
|
$data['page_title'] = 'Import DIDs Preview'; |
|
605
|
|
- $data['csv_tmp_data'] = $this->csvreader->parse_file($full_path . $actual_file_name, $did_fields_array, $check_header); |
|
|
605
|
+ $data['csv_tmp_data'] = $this->csvreader->parse_file($full_path.$actual_file_name, $did_fields_array, $check_header); |
|
606
|
606
|
$data['provider_id'] = $_POST['provider_id']; |
|
607
|
607
|
$data['check_header'] = $check_header; |
|
608
|
608
|
$this->session->set_userdata('import_did_rate_csv', $actual_file_name); |
|
@@ -619,7 +619,7 @@ discard block |
|
|
block discarded – undo |
|
619
|
619
|
if ($invalid_flag) { |
|
620
|
620
|
$str = ''; |
|
621
|
621
|
if (empty($_FILES['didimport']['name'])) { |
|
622
|
|
- $str.= '<br/>Please Select File.'; |
|
|
622
|
+ $str .= '<br/>Please Select File.'; |
|
623
|
623
|
} |
|
624
|
624
|
$data['error'] = $str; |
|
625
|
625
|
} |
|
@@ -630,32 +630,32 @@ discard block |
|
|
block discarded – undo |
|
630
|
630
|
$new_final_arr = array(); |
|
631
|
631
|
$invalid_array = array(); |
|
632
|
632
|
$new_final_arr_key = $this->config->item('DID-rates-field'); |
|
633
|
|
- $accountinfo=$this->session->userdata('accountinfo'); |
|
634
|
|
- $reseller_id = $accountinfo['type']==1 ? $accountinfo['id']: 0; |
|
|
633
|
+ $accountinfo = $this->session->userdata('accountinfo'); |
|
|
634
|
+ $reseller_id = $accountinfo['type'] == 1 ? $accountinfo['id'] : 0; |
|
635
|
635
|
|
|
636
|
636
|
$full_path = $this->config->item('rates-file-path'); |
|
637
|
637
|
$did_file_name = $this->session->userdata('import_did_rate_csv'); |
|
638
|
|
- $csv_tmp_data = $this->csvreader->parse_file($full_path . $did_file_name, $new_final_arr_key, $check_header); |
|
|
638
|
+ $csv_tmp_data = $this->csvreader->parse_file($full_path.$did_file_name, $new_final_arr_key, $check_header); |
|
639
|
639
|
$flag = false; |
|
640
|
640
|
$i = 0; |
|
641
|
641
|
$number_arr = array(); |
|
642
|
|
- $reseller_array=array(); |
|
643
|
|
- $final_reseller_array=array(); |
|
|
642
|
+ $reseller_array = array(); |
|
|
643
|
+ $final_reseller_array = array(); |
|
644
|
644
|
foreach ($csv_tmp_data as $key => $csv_data) { |
|
645
|
645
|
|
|
646
|
646
|
if (isset($csv_data['number']) && $csv_data['number'] != '' && $i != 0) { |
|
647
|
647
|
$str = null; |
|
648
|
|
- if(isset($csv_data['call_type'])){ |
|
649
|
|
- if(strtolower($csv_data['call_type']) == 'sip-did'){ |
|
|
648
|
+ if (isset($csv_data['call_type'])) { |
|
|
649
|
+ if (strtolower($csv_data['call_type']) == 'sip-did') { |
|
650
|
650
|
$call_type = '3'; |
|
651
|
|
- } else if(strtolower($csv_data['call_type']) == 'did-local'){ |
|
|
651
|
+ } else if (strtolower($csv_data['call_type']) == 'did-local') { |
|
652
|
652
|
$call_type = '1'; |
|
653
|
|
- } else if(strtolower($csv_data['call_type']) == 'other'){ |
|
|
653
|
+ } else if (strtolower($csv_data['call_type']) == 'other') { |
|
654
|
654
|
$call_type = '2'; |
|
655
|
655
|
} else { |
|
656
|
656
|
$call_type = '0'; |
|
657
|
657
|
} |
|
658
|
|
- } else{ |
|
|
658
|
+ } else { |
|
659
|
659
|
$call_type = '0'; |
|
660
|
660
|
} |
|
661
|
661
|
$csv_data['accountid'] = isset($csv_data['accountid']) ? $csv_data['accountid'] : 0; |
|
@@ -664,77 +664,77 @@ discard block |
|
|
block discarded – undo |
|
664
|
664
|
$csv_data['call_type'] = $call_type; |
|
665
|
665
|
$csv_data['extensions'] = isset($csv_data['extensions']) ? $csv_data['extensions'] : ''; |
|
666
|
666
|
$csv_data['includedseconds'] = isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] : 0; |
|
667
|
|
- $csv_data['cost'] = !empty($csv_data['cost']) && is_numeric($csv_data['cost']) && $csv_data['cost'] ? $csv_data['cost'] : 0; |
|
668
|
|
- $csv_data['setup'] = !empty($csv_data['setup']) && is_numeric($csv_data['setup']) && $csv_data['setup'] > 0 ? $csv_data['setup'] : 0; |
|
669
|
|
- $csv_data['monthlycost'] = !empty($csv_data['monthlycost']) && is_numeric($csv_data['monthlycost']) && $csv_data['monthlycost'] > 0 ? $csv_data['monthlycost'] : 0; |
|
670
|
|
- $csv_data['connectcost'] = !empty($csv_data['connectcost']) && is_numeric($csv_data['connectcost']) && $csv_data['connectcost'] > 0 ? $csv_data['connectcost'] : 0; |
|
|
667
|
+ $csv_data['cost'] = ! empty($csv_data['cost']) && is_numeric($csv_data['cost']) && $csv_data['cost'] ? $csv_data['cost'] : 0; |
|
|
668
|
+ $csv_data['setup'] = ! empty($csv_data['setup']) && is_numeric($csv_data['setup']) && $csv_data['setup'] > 0 ? $csv_data['setup'] : 0; |
|
|
669
|
+ $csv_data['monthlycost'] = ! empty($csv_data['monthlycost']) && is_numeric($csv_data['monthlycost']) && $csv_data['monthlycost'] > 0 ? $csv_data['monthlycost'] : 0; |
|
|
670
|
+ $csv_data['connectcost'] = ! empty($csv_data['connectcost']) && is_numeric($csv_data['connectcost']) && $csv_data['connectcost'] > 0 ? $csv_data['connectcost'] : 0; |
|
671
|
671
|
$csv_data['inc'] = isset($csv_data['inc']) ? $csv_data['inc'] : 0; |
|
672
|
672
|
$str = $this->data_validate($csv_data); |
|
673
|
673
|
if ($str != "") { |
|
674
|
674
|
$invalid_array[$i] = $csv_data; |
|
675
|
675
|
$invalid_array[$i]['error'] = $str; |
|
676
|
676
|
} else { |
|
677
|
|
- if (!in_array($csv_data['number'], $number_arr)) { |
|
|
677
|
+ if ( ! in_array($csv_data['number'], $number_arr)) { |
|
678
|
678
|
$number_count = $this->db_model->countQuery('id', 'dids', array('number' => $csv_data['number'])); |
|
679
|
679
|
if ($number_count > 0) { |
|
680
|
680
|
$invalid_array[$i] = $csv_data; |
|
681
|
681
|
$invalid_array[$i]['error'] = 'Duplicate DID found from database'; |
|
682
|
682
|
} else { |
|
683
|
|
- if($csv_data['accountid'] > 0 && $csv_data['setup'] > 0){ |
|
|
683
|
+ if ($csv_data['accountid'] > 0 && $csv_data['setup'] > 0) { |
|
684
|
684
|
$this->db->where('type IN(0,1,3)'); |
|
685
|
|
- $this->db->where('reseller_id',0); |
|
686
|
|
- $this->db->where('deleted',0); |
|
687
|
|
- $this->db->where('status',0); |
|
688
|
|
- $account_info=(array)$this->db->get_where('accounts',array("number"=>$csv_data['accountid']))->first_row(); |
|
689
|
|
- if($account_info){ |
|
690
|
|
- $account_balance=$this->db_model->get_available_bal($account_info); |
|
|
685
|
+ $this->db->where('reseller_id', 0); |
|
|
686
|
+ $this->db->where('deleted', 0); |
|
|
687
|
+ $this->db->where('status', 0); |
|
|
688
|
+ $account_info = (array)$this->db->get_where('accounts', array("number"=>$csv_data['accountid']))->first_row(); |
|
|
689
|
+ if ($account_info) { |
|
|
690
|
+ $account_balance = $this->db_model->get_available_bal($account_info); |
|
691
|
691
|
$setup = $this->common_model->add_calculate_currency($csv_data['setup'], '', '', false, false); |
|
692
|
|
- if($account_balance >= $setup){ |
|
693
|
|
- $field_name=$account_info['type']==1 ? 'parent_id':'accountid'; |
|
694
|
|
- $currency_name=$this->common->get_field_name('currency',"currency",array('id'=>$account_info['currency_id'])); |
|
|
692
|
+ if ($account_balance >= $setup) { |
|
|
693
|
+ $field_name = $account_info['type'] == 1 ? 'parent_id' : 'accountid'; |
|
|
694
|
+ $currency_name = $this->common->get_field_name('currency', "currency", array('id'=>$account_info['currency_id'])); |
|
695
|
695
|
$csv_data['monthlycost'] = $this->common_model->add_calculate_currency($csv_data['monthlycost'], '', '', false, false); |
|
696
|
696
|
$csv_data['cost'] = $this->common_model->add_calculate_currency($csv_data['cost'], '', '', false, false); |
|
697
|
697
|
$csv_data['connectcost'] = $this->common_model->add_calculate_currency($csv_data['connectcost'], '', '', false, false); |
|
698
|
|
- $csv_data['setup']=$setup; |
|
699
|
|
- $csv_data[$field_name]=$account_info['id']; |
|
700
|
|
- $csv_data['status']=$this->common->get_import_status($csv_data['status']); |
|
701
|
|
- $available_bal = $this->db_model->update_balance($csv_data["setup"],$account_info['id'], "debit"); |
|
|
698
|
+ $csv_data['setup'] = $setup; |
|
|
699
|
+ $csv_data[$field_name] = $account_info['id']; |
|
|
700
|
+ $csv_data['status'] = $this->common->get_import_status($csv_data['status']); |
|
|
701
|
+ $available_bal = $this->db_model->update_balance($csv_data["setup"], $account_info['id'], "debit"); |
|
702
|
702
|
$account_info['did_number'] = $csv_data['number']; |
|
703
|
703
|
$account_info['did_country_id'] = $csv_data['country_id']; |
|
704
|
|
- $account_info['did_setup'] = $this->common_model->calculate_currency($csv_data['setup'],'',$currency_name,true,true); |
|
705
|
|
- $account_info['did_monthlycost'] = $this->common_model->calculate_currency($csv_data['monthlycost'],'',$currency_name,true,true); |
|
|
704
|
+ $account_info['did_setup'] = $this->common_model->calculate_currency($csv_data['setup'], '', $currency_name, true, true); |
|
|
705
|
+ $account_info['did_monthlycost'] = $this->common_model->calculate_currency($csv_data['monthlycost'], '', $currency_name, true, true); |
|
706
|
706
|
$account_info['did_maxchannels'] = "0"; |
|
707
|
|
- $csv_data['country_id']=$this->common->get_field_name('id','countrycode',array("country"=>$csv_data['country_id'])); |
|
708
|
|
- if($account_info['type']==1){ |
|
709
|
|
- $reseller_array=$csv_data; |
|
710
|
|
- $reseller_array['note']=$csv_data['number']; |
|
711
|
|
- $reseller_array['reseller_id']=$account_info['id']; |
|
712
|
|
- $reseller_array['parent_id']=$account_info['reseller_id']; |
|
713
|
|
- $reseller_array['assign_date']=gmdate("Y-m-d H:i:s"); |
|
714
|
|
- unset($reseller_array['number'],$csv_data['accountid'],$reseller_array['accountid'],$reseller_array['country_id'],$reseller_array['init_inc']); |
|
715
|
|
- $csv_data['accountid']=0; |
|
716
|
|
- $final_reseller_array[$i]=$reseller_array; |
|
717
|
|
- }else{ |
|
718
|
|
- $csv_data['parent_id']=0; |
|
|
707
|
+ $csv_data['country_id'] = $this->common->get_field_name('id', 'countrycode', array("country"=>$csv_data['country_id'])); |
|
|
708
|
+ if ($account_info['type'] == 1) { |
|
|
709
|
+ $reseller_array = $csv_data; |
|
|
710
|
+ $reseller_array['note'] = $csv_data['number']; |
|
|
711
|
+ $reseller_array['reseller_id'] = $account_info['id']; |
|
|
712
|
+ $reseller_array['parent_id'] = $account_info['reseller_id']; |
|
|
713
|
+ $reseller_array['assign_date'] = gmdate("Y-m-d H:i:s"); |
|
|
714
|
+ unset($reseller_array['number'], $csv_data['accountid'], $reseller_array['accountid'], $reseller_array['country_id'], $reseller_array['init_inc']); |
|
|
715
|
+ $csv_data['accountid'] = 0; |
|
|
716
|
+ $final_reseller_array[$i] = $reseller_array; |
|
|
717
|
+ } else { |
|
|
718
|
+ $csv_data['parent_id'] = 0; |
|
719
|
719
|
} |
|
720
|
|
- $csv_data['assign_date']=gmdate("Y-m-d H:i:s"); |
|
|
720
|
+ $csv_data['assign_date'] = gmdate("Y-m-d H:i:s"); |
|
721
|
721
|
$new_final_arr[$i] = $csv_data; |
|
722
|
722
|
$this->common->mail_to_users('email_add_did', $account_info); |
|
723
|
|
- }else{ |
|
|
723
|
+ } else { |
|
724
|
724
|
$invalid_array[$i] = $csv_data; |
|
725
|
725
|
$invalid_array[$i]['error'] = 'Account have not sufficient amount to purchase this DID.'; |
|
726
|
726
|
} |
|
727
|
|
- }else{ |
|
|
727
|
+ } else { |
|
728
|
728
|
$invalid_array[$i] = $csv_data; |
|
729
|
729
|
$invalid_array[$i]['error'] = 'Account not found or assign to invalid account'; |
|
730
|
730
|
} |
|
731
|
|
- }else{ |
|
|
731
|
+ } else { |
|
732
|
732
|
$csv_data['setup'] = $this->common_model->add_calculate_currency($csv_data['setup'], '', '', false, false); |
|
733
|
733
|
$csv_data['monthlycost'] = $this->common_model->add_calculate_currency($csv_data['monthlycost'], '', '', false, false); |
|
734
|
734
|
$csv_data['cost'] = $this->common_model->add_calculate_currency($csv_data['cost'], '', '', false, false); |
|
735
|
735
|
$csv_data['connectcost'] = $this->common_model->add_calculate_currency($csv_data['connectcost'], '', '', false, false); |
|
736
|
|
- $csv_data['accountid']=0; |
|
737
|
|
- $csv_data['country_id']=$this->common->get_field_name('id','countrycode',array("country"=>$csv_data['country_id'])); |
|
|
736
|
+ $csv_data['accountid'] = 0; |
|
|
737
|
+ $csv_data['country_id'] = $this->common->get_field_name('id', 'countrycode', array("country"=>$csv_data['country_id'])); |
|
738
|
738
|
$new_final_arr[$i] = $csv_data; |
|
739
|
739
|
} |
|
740
|
740
|
} |
|
@@ -747,17 +747,17 @@ discard block |
|
|
block discarded – undo |
|
747
|
747
|
} |
|
748
|
748
|
$i++; |
|
749
|
749
|
} |
|
750
|
|
- if (!empty($new_final_arr)) { |
|
|
750
|
+ if ( ! empty($new_final_arr)) { |
|
751
|
751
|
$result = $this->did_model->bulk_insert_dids($new_final_arr); |
|
752
|
752
|
} |
|
753
|
|
- if(!empty($final_reseller_array)){ |
|
|
753
|
+ if ( ! empty($final_reseller_array)) { |
|
754
|
754
|
$this->db->insert_batch('reseller_pricing', $final_reseller_array); |
|
755
|
755
|
} |
|
756
|
756
|
unlink($full_path.$did_file_name); |
|
757
|
757
|
$count = count($invalid_array); |
|
758
|
758
|
if ($count > 0) { |
|
759
|
759
|
$session_id = "-1"; |
|
760
|
|
- $fp = fopen($full_path . $session_id . '.csv', 'w'); |
|
|
760
|
+ $fp = fopen($full_path.$session_id.'.csv', 'w'); |
|
761
|
761
|
foreach ($new_final_arr_key as $key => $value) { |
|
762
|
762
|
$custom_array[0][$key] = ucfirst($key); |
|
763
|
763
|
} |
|
@@ -767,16 +767,16 @@ discard block |
|
|
block discarded – undo |
|
767
|
767
|
fputcsv($fp, $err_data); |
|
768
|
768
|
} |
|
769
|
769
|
fclose($fp); |
|
770
|
|
- $this->session->set_userdata('import_did_csv_error', $session_id . ".csv"); |
|
|
770
|
+ $this->session->set_userdata('import_did_csv_error', $session_id.".csv"); |
|
771
|
771
|
$data["error"] = $invalid_array; |
|
772
|
772
|
$data['provider_id'] = $provider_id; |
|
773
|
|
- $data['import_record_count'] = count($new_final_arr)+count($reseller_array); |
|
|
773
|
+ $data['import_record_count'] = count($new_final_arr) + count($reseller_array); |
|
774
|
774
|
$data['failure_count'] = count($invalid_array) - 1; |
|
775
|
775
|
$data['page_title'] = 'DID Import Error'; |
|
776
|
776
|
$this->load->view('view_import_error', $data); |
|
777
|
777
|
} else { |
|
778
|
|
- $this->session->set_flashdata('astpp_errormsg', 'Total ' . count($new_final_arr) . ' DIDs Imported Successfully!'); |
|
779
|
|
- redirect(base_url() . "did/did_list/"); |
|
|
778
|
+ $this->session->set_flashdata('astpp_errormsg', 'Total '.count($new_final_arr).' DIDs Imported Successfully!'); |
|
|
779
|
+ redirect(base_url()."did/did_list/"); |
|
780
|
780
|
} |
|
781
|
781
|
} |
|
782
|
782
|
|
|
@@ -785,17 +785,17 @@ discard block |
|
|
block discarded – undo |
|
785
|
785
|
$alpha_regex = "/^[a-z ,.'-]+$/i"; |
|
786
|
786
|
$alpha_numeric_regex = "/^[a-z0-9 ,.'-]+$/i"; |
|
787
|
787
|
$email_regex = "/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/"; |
|
788
|
|
- $str.= $csvdata['number'] != '' ? null : 'Number,'; |
|
|
788
|
+ $str .= $csvdata['number'] != '' ? null : 'Number,'; |
|
789
|
789
|
$str = rtrim($str, ','); |
|
790
|
|
- if (!$str) { |
|
791
|
|
- $str.= is_numeric($csvdata['number']) ? null : 'Number,'; |
|
792
|
|
- $str.=!empty($csvdata['connectcost']) && is_numeric($csvdata['connectcost']) ? null : ( empty($csvdata['connectcost']) ? null : 'Connect Cost,'); |
|
793
|
|
- $str.=!empty($csvdata['includedseconds']) && is_numeric($csvdata['includedseconds']) ? null : ( empty($csvdata['includedseconds']) ? null : 'Included Seconds,'); |
|
|
790
|
+ if ( ! $str) { |
|
|
791
|
+ $str .= is_numeric($csvdata['number']) ? null : 'Number,'; |
|
|
792
|
+ $str .= ! empty($csvdata['connectcost']) && is_numeric($csvdata['connectcost']) ? null : (empty($csvdata['connectcost']) ? null : 'Connect Cost,'); |
|
|
793
|
+ $str .= ! empty($csvdata['includedseconds']) && is_numeric($csvdata['includedseconds']) ? null : (empty($csvdata['includedseconds']) ? null : 'Included Seconds,'); |
|
794
|
794
|
if ($str) { |
|
795
|
795
|
$str = rtrim($str, ','); |
|
796
|
796
|
$error_field = explode(',', $str); |
|
797
|
797
|
$count = count($error_field); |
|
798
|
|
- $str.= $count > 1 ? ' are not valid' : ' is not Valid'; |
|
|
798
|
+ $str .= $count > 1 ? ' are not valid' : ' is not Valid'; |
|
799
|
799
|
return $str; |
|
800
|
800
|
} else { |
|
801
|
801
|
return false; |
|
@@ -804,7 +804,7 @@ discard block |
|
|
block discarded – undo |
|
804
|
804
|
$str = rtrim($str, ','); |
|
805
|
805
|
$error_field = explode(',', $str); |
|
806
|
806
|
$count = count($error_field); |
|
807
|
|
- $str.= $count > 1 ? ' are required' : ' is Required'; |
|
|
807
|
+ $str .= $count > 1 ? ' are required' : ' is Required'; |
|
808
|
808
|
return $str; |
|
809
|
809
|
} |
|
810
|
810
|
} |
|
@@ -813,38 +813,38 @@ discard block |
|
|
block discarded – undo |
|
813
|
813
|
$this->load->helper('download'); |
|
814
|
814
|
$error_data = $this->session->userdata('import_did_csv_error'); |
|
815
|
815
|
$full_path = $this->config->item('rates-file-path'); |
|
816
|
|
- $data = file_get_contents($full_path . $error_data); |
|
|
816
|
+ $data = file_get_contents($full_path.$error_data); |
|
817
|
817
|
force_download("error_did_rates.csv", $data); |
|
818
|
818
|
} |
|
819
|
819
|
|
|
820
|
820
|
function did_export_data_xls() { |
|
821
|
821
|
$account_info = $accountinfo = $this->session->userdata('accountinfo'); |
|
822
|
|
- $currency_id=$account_info['currency_id']; |
|
823
|
|
- $currency=$this->common->get_field_name('currency', 'currency', $currency_id); |
|
|
822
|
+ $currency_id = $account_info['currency_id']; |
|
|
823
|
+ $currency = $this->common->get_field_name('currency', 'currency', $currency_id); |
|
824
|
824
|
$query = $this->did_model->getdid_list(true, '0', '10000000'); |
|
825
|
825
|
ob_clean(); |
|
826
|
|
- $outbound_array[] = array("DID", "Country", "Account","Per Minute Cost($currency)","Initial Increment","Increment","Setup Fee($currency)","Monthly Fee($currency)","Call Type","Destination","Status","Modified Date","Is Purchased"); |
|
|
826
|
+ $outbound_array[] = array("DID", "Country", "Account", "Per Minute Cost($currency)", "Initial Increment", "Increment", "Setup Fee($currency)", "Monthly Fee($currency)", "Call Type", "Destination", "Status", "Modified Date", "Is Purchased"); |
|
827
|
827
|
if ($query->num_rows() > 0) { |
|
828
|
828
|
foreach ($query->result_array() as $row) { |
|
829
|
829
|
$outbound_array[] = array( |
|
830
|
830
|
$row['number'], |
|
831
|
831
|
$this->common->get_field_name("country", "countrycode", $row['country_id']), |
|
832
|
832
|
$this->common->get_field_name("number", "accounts", $row['accountid']), |
|
833
|
|
- $this->common_model->calculate_currency($row['cost'], '', '',true, false), |
|
|
833
|
+ $this->common_model->calculate_currency($row['cost'], '', '', true, false), |
|
834
|
834
|
$row['init_inc'], |
|
835
|
835
|
$row['inc'], |
|
836
|
|
- $this->common_model->calculate_currency($row['setup'], '', '',true, false), |
|
837
|
|
- $this->common_model->calculate_currency($row['monthlycost'], '', '',true, false), |
|
838
|
|
- $this->common->get_call_type("","",$row['call_type']), |
|
|
836
|
+ $this->common_model->calculate_currency($row['setup'], '', '', true, false), |
|
|
837
|
+ $this->common_model->calculate_currency($row['monthlycost'], '', '', true, false), |
|
|
838
|
+ $this->common->get_call_type("", "", $row['call_type']), |
|
839
|
839
|
$row['extensions'], |
|
840
|
|
- $this->common->get_status('export','',$row['status']), |
|
|
840
|
+ $this->common->get_status('export', '', $row['status']), |
|
841
|
841
|
$row['last_modified_date'], |
|
842
|
842
|
$this->common->check_did_avl_export($row['number']) |
|
843
|
843
|
); |
|
844
|
844
|
} |
|
845
|
845
|
} |
|
846
|
846
|
$this->load->helper('csv'); |
|
847
|
|
- array_to_csv($outbound_array, 'DIDs_' . date("Y-m-d") . '.csv'); |
|
|
847
|
+ array_to_csv($outbound_array, 'DIDs_'.date("Y-m-d").'.csv'); |
|
848
|
848
|
} |
|
849
|
849
|
|
|
850
|
850
|
} |