@@ -7,19 +7,19 @@ discard block |
||
| 7 | 7 | }); |
| 8 | 8 | </script> <script type="text/javascript" language="javascript"><? |
| 9 | 9 | if (isset($mapto_fields) && !empty($mapto_fields)) { |
| 10 | - foreach($mapto_fields as $csv_key => $csv_value) { |
|
| 11 | - echo '$("#'.$csv_value .'-prefix").live("change", function () {'; |
|
| 12 | - echo 'var select = document.getElementById("'.$csv_value .'-select");'; |
|
| 13 | - echo 'var answer = select.options[select.selectedIndex].value;'; |
|
| 14 | - echo 'document.getElementById("'.$csv_value .'-display").value = (!answer) ? document.getElementById("'.$csv_value .'-prefix").value : document.getElementById("'.$csv_value .'-prefix").value + csv_tmp_data[2][answer];'; |
|
| 15 | - echo '});'; |
|
| 16 | - echo '$("#'.$csv_value .'-select").live("change", function () {'; |
|
| 17 | - echo 'var select = document.getElementById("'.$csv_value .'-select");'; |
|
| 18 | - echo 'var answer = select.options[select.selectedIndex].value;'; |
|
| 19 | - echo 'document.getElementById("'.$csv_value .'-display").value = (!answer) ? document.getElementById("'.$csv_value .'-prefix").value : document.getElementById("'.$csv_value .'-prefix").value + csv_tmp_data[2][answer];'; |
|
| 20 | - echo '});'; |
|
| 21 | - } |
|
| 22 | - } |
|
| 10 | + foreach($mapto_fields as $csv_key => $csv_value) { |
|
| 11 | + echo '$("#'.$csv_value .'-prefix").live("change", function () {'; |
|
| 12 | + echo 'var select = document.getElementById("'.$csv_value .'-select");'; |
|
| 13 | + echo 'var answer = select.options[select.selectedIndex].value;'; |
|
| 14 | + echo 'document.getElementById("'.$csv_value .'-display").value = (!answer) ? document.getElementById("'.$csv_value .'-prefix").value : document.getElementById("'.$csv_value .'-prefix").value + csv_tmp_data[2][answer];'; |
|
| 15 | + echo '});'; |
|
| 16 | + echo '$("#'.$csv_value .'-select").live("change", function () {'; |
|
| 17 | + echo 'var select = document.getElementById("'.$csv_value .'-select");'; |
|
| 18 | + echo 'var answer = select.options[select.selectedIndex].value;'; |
|
| 19 | + echo 'document.getElementById("'.$csv_value .'-display").value = (!answer) ? document.getElementById("'.$csv_value .'-prefix").value : document.getElementById("'.$csv_value .'-prefix").value + csv_tmp_data[2][answer];'; |
|
| 20 | + echo '});'; |
|
| 21 | + } |
|
| 22 | + } |
|
| 23 | 23 | ?></script> |
| 24 | 24 | <? |
| 25 | 25 | if (isset($csv_tmp_data) && !empty($csv_tmp_data)) { |
@@ -27,7 +27,7 @@ discard block |
||
| 27 | 27 | echo 'var csv_tmp_data = ' . json_encode($csv_tmp_data) . ';'; |
| 28 | 28 | echo '</script>'; |
| 29 | 29 | } |
| 30 | - ?> |
|
| 30 | + ?> |
|
| 31 | 31 | <?php |
| 32 | 32 | endblock() ?> |
| 33 | 33 | <?php |
@@ -50,9 +50,9 @@ discard block |
||
| 50 | 50 | <div class="w-box"> |
| 51 | 51 | <span style="margin-left:10px; text-align: center;background-color: none;color:#DD191D;"> |
| 52 | 52 | <?php |
| 53 | - if (isset($error) && !empty($error)) { |
|
| 54 | - echo $error; |
|
| 55 | - } ?> |
|
| 53 | + if (isset($error) && !empty($error)) { |
|
| 54 | + echo $error; |
|
| 55 | + } ?> |
|
| 56 | 56 | </span> |
| 57 | 57 | <h3 class="padding-t-10 padding-l-16">You must either select a field from your file OR provide a default value for the following fields:</h3> |
| 58 | 58 | <p>Code,Destination,Connect Cost,Included Seconds,Per Minute Cost,Increment,Precedence,Strip,Prepend.</p> |
@@ -66,10 +66,10 @@ discard block |
||
| 66 | 66 | <label class="col-md-3">Trunk List:</label> |
| 67 | 67 | <div class="col-md-8"> |
| 68 | 68 | <?php |
| 69 | - $trunklist = form_dropdown('trunk_id', $this->db_model->build_dropdown("id,name", "trunks", "where_arr", array( |
|
| 70 | - "status " => "0" |
|
| 71 | - )) , ''); |
|
| 72 | - echo $trunklist; ?> |
|
| 69 | + $trunklist = form_dropdown('trunk_id', $this->db_model->build_dropdown("id,name", "trunks", "where_arr", array( |
|
| 70 | + "status " => "0" |
|
| 71 | + )) , ''); |
|
| 72 | + echo $trunklist; ?> |
|
| 73 | 73 | </div> |
| 74 | 74 | </div> |
| 75 | 75 | |
@@ -134,28 +134,28 @@ discard block |
||
| 134 | 134 | </thead> |
| 135 | 135 | <tbody> |
| 136 | 136 | <?php |
| 137 | - foreach($mapto_fields as $csv_key => $csv_value) { |
|
| 137 | + foreach($mapto_fields as $csv_key => $csv_value) { |
|
| 138 | 138 | |
| 139 | - echo "<tr>"; |
|
| 140 | - echo "<td>" . $csv_key . '(' . $csv_value . ")</td>"; |
|
| 141 | - echo "<td><input type='text' name='".$csv_value ."-prefix' id='".$csv_value ."-prefix'></td>"; |
|
| 142 | - echo "<td>"; |
|
| 143 | - echo "<select name='".$csv_value ."-select' id='".$csv_value ."-select'>"; |
|
| 144 | - ?> |
|
| 139 | + echo "<tr>"; |
|
| 140 | + echo "<td>" . $csv_key . '(' . $csv_value . ")</td>"; |
|
| 141 | + echo "<td><input type='text' name='".$csv_value ."-prefix' id='".$csv_value ."-prefix'></td>"; |
|
| 142 | + echo "<td>"; |
|
| 143 | + echo "<select name='".$csv_value ."-select' id='".$csv_value ."-select'>"; |
|
| 144 | + ?> |
|
| 145 | 145 | <option value=""></option> |
| 146 | 146 | <?php |
| 147 | - $keys = array_keys($file_data); |
|
| 148 | - for ($i = 0; $i < count($file_data); $i++) { ?> |
|
| 147 | + $keys = array_keys($file_data); |
|
| 148 | + for ($i = 0; $i < count($file_data); $i++) { ?> |
|
| 149 | 149 | <option value="<?php |
| 150 | - echo $file_data[$i]; ?>"><?php |
|
| 151 | - echo $file_data[$i]; ?></option> |
|
| 150 | + echo $file_data[$i]; ?>"><?php |
|
| 151 | + echo $file_data[$i]; ?></option> |
|
| 152 | 152 | <?php |
| 153 | - } |
|
| 154 | - echo "</td>"; |
|
| 155 | - echo "<td><input type='text' name='".$csv_value ."-display' id='".$csv_value ."-display'></td>"; |
|
| 156 | - echo "</tr>"; |
|
| 153 | + } |
|
| 154 | + echo "</td>"; |
|
| 155 | + echo "<td><input type='text' name='".$csv_value ."-display' id='".$csv_value ."-display'></td>"; |
|
| 156 | + echo "</tr>"; |
|
| 157 | 157 | |
| 158 | - } ?> |
|
| 158 | + } ?> |
|
| 159 | 159 | </tbody> |
| 160 | 160 | </table> |
| 161 | 161 | <input type="hidden" name="trunkid" value="<?php echo $trunkid ?>" /> |
@@ -167,30 +167,30 @@ discard block |
||
| 167 | 167 | <H2> Import File Data..</H2> |
| 168 | 168 | <table width="100%" border="1" class="details_table"> |
| 169 | 169 | <?php |
| 170 | - $cnt = 1; |
|
| 171 | - foreach($csv_tmp_data as $csv_key => $csv_value) { |
|
| 172 | - if ($csv_key < 15) { |
|
| 173 | - echo "<tr>"; |
|
| 174 | - foreach($csv_value as $field_name => $field_val) { |
|
| 175 | - if ($csv_key == 0) { |
|
| 170 | + $cnt = 1; |
|
| 171 | + foreach($csv_tmp_data as $csv_key => $csv_value) { |
|
| 172 | + if ($csv_key < 15) { |
|
| 173 | + echo "<tr>"; |
|
| 174 | + foreach($csv_value as $field_name => $field_val) { |
|
| 175 | + if ($csv_key == 0) { |
|
| 176 | 176 | |
| 177 | - echo "<th>".ucfirst($field_val)."</th>"; |
|
| 177 | + echo "<th>".ucfirst($field_val)."</th>"; |
|
| 178 | 178 | |
| 179 | - } |
|
| 180 | - else { |
|
| 181 | - echo "<td class='portlet-content'>" . $field_val . "</td>"; |
|
| 182 | - $cnt++; |
|
| 183 | - } |
|
| 184 | - } |
|
| 179 | + } |
|
| 180 | + else { |
|
| 181 | + echo "<td class='portlet-content'>" . $field_val . "</td>"; |
|
| 182 | + $cnt++; |
|
| 183 | + } |
|
| 184 | + } |
|
| 185 | 185 | |
| 186 | - echo "</tr>"; |
|
| 187 | - } |
|
| 188 | - } |
|
| 186 | + echo "</tr>"; |
|
| 187 | + } |
|
| 188 | + } |
|
| 189 | 189 | |
| 190 | - echo "<tr><td colspan='" . $cnt . "'> |
|
| 190 | + echo "<tr><td colspan='" . $cnt . "'> |
|
| 191 | 191 | <a href='" . base_url() . "rates/termination_rate_list/'><input type='button' class='btn btn-line-sky pull-right margin-x-10' value='Back'/></a> |
| 192 | 192 | <input type='submit' class='btn btn-line-parrot pull-right'' id='Process' value='Process Records'/></td></tr>"; |
| 193 | - ?> |
|
| 193 | + ?> |
|
| 194 | 194 | </table> |
| 195 | 195 | </form> |
| 196 | 196 | </div> |
@@ -6,25 +6,25 @@ discard block |
||
| 6 | 6 | $(document).ready(function() { |
| 7 | 7 | }); |
| 8 | 8 | </script> <script type="text/javascript" language="javascript"><? |
| 9 | - if (isset($mapto_fields) && !empty($mapto_fields)) { |
|
| 10 | - foreach($mapto_fields as $csv_key => $csv_value) { |
|
| 11 | - echo '$("#'.$csv_value .'-prefix").live("change", function () {'; |
|
| 12 | - echo 'var select = document.getElementById("'.$csv_value .'-select");'; |
|
| 9 | + if (isset($mapto_fields) && ! empty($mapto_fields)) { |
|
| 10 | + foreach ($mapto_fields as $csv_key => $csv_value) { |
|
| 11 | + echo '$("#'.$csv_value.'-prefix").live("change", function () {'; |
|
| 12 | + echo 'var select = document.getElementById("'.$csv_value.'-select");'; |
|
| 13 | 13 | echo 'var answer = select.options[select.selectedIndex].value;'; |
| 14 | - echo 'document.getElementById("'.$csv_value .'-display").value = (!answer) ? document.getElementById("'.$csv_value .'-prefix").value : document.getElementById("'.$csv_value .'-prefix").value + csv_tmp_data[2][answer];'; |
|
| 14 | + echo 'document.getElementById("'.$csv_value.'-display").value = (!answer) ? document.getElementById("'.$csv_value.'-prefix").value : document.getElementById("'.$csv_value.'-prefix").value + csv_tmp_data[2][answer];'; |
|
| 15 | 15 | echo '});'; |
| 16 | - echo '$("#'.$csv_value .'-select").live("change", function () {'; |
|
| 17 | - echo 'var select = document.getElementById("'.$csv_value .'-select");'; |
|
| 16 | + echo '$("#'.$csv_value.'-select").live("change", function () {'; |
|
| 17 | + echo 'var select = document.getElementById("'.$csv_value.'-select");'; |
|
| 18 | 18 | echo 'var answer = select.options[select.selectedIndex].value;'; |
| 19 | - echo 'document.getElementById("'.$csv_value .'-display").value = (!answer) ? document.getElementById("'.$csv_value .'-prefix").value : document.getElementById("'.$csv_value .'-prefix").value + csv_tmp_data[2][answer];'; |
|
| 19 | + echo 'document.getElementById("'.$csv_value.'-display").value = (!answer) ? document.getElementById("'.$csv_value.'-prefix").value : document.getElementById("'.$csv_value.'-prefix").value + csv_tmp_data[2][answer];'; |
|
| 20 | 20 | echo '});'; |
| 21 | 21 | } |
| 22 | 22 | } |
| 23 | 23 | ?></script> |
| 24 | 24 | <? |
| 25 | - if (isset($csv_tmp_data) && !empty($csv_tmp_data)) { |
|
| 25 | + if (isset($csv_tmp_data) && ! empty($csv_tmp_data)) { |
|
| 26 | 26 | echo '<script>'; |
| 27 | - echo 'var csv_tmp_data = ' . json_encode($csv_tmp_data) . ';'; |
|
| 27 | + echo 'var csv_tmp_data = '.json_encode($csv_tmp_data).';'; |
|
| 28 | 28 | echo '</script>'; |
| 29 | 29 | } |
| 30 | 30 | ?> |
@@ -40,7 +40,7 @@ discard block |
||
| 40 | 40 | <?php |
| 41 | 41 | startblock('content') ?> |
| 42 | 42 | <?php |
| 43 | - if (!isset($csv_tmp_data)) { ?> |
|
| 43 | + if ( ! isset($csv_tmp_data)) { ?> |
|
| 44 | 44 | <section class="slice color-three padding-t-20"> |
| 45 | 45 | <div class="w-section inverse no-padding"> |
| 46 | 46 | <div class="container"> |
@@ -50,7 +50,7 @@ discard block |
||
| 50 | 50 | <div class="w-box"> |
| 51 | 51 | <span style="margin-left:10px; text-align: center;background-color: none;color:#DD191D;"> |
| 52 | 52 | <?php |
| 53 | - if (isset($error) && !empty($error)) { |
|
| 53 | + if (isset($error) && ! empty($error)) { |
|
| 54 | 54 | echo $error; |
| 55 | 55 | } ?> |
| 56 | 56 | </span> |
@@ -68,7 +68,7 @@ discard block |
||
| 68 | 68 | <?php |
| 69 | 69 | $trunklist = form_dropdown('trunk_id', $this->db_model->build_dropdown("id,name", "trunks", "where_arr", array( |
| 70 | 70 | "status " => "0" |
| 71 | - )) , ''); |
|
| 71 | + )), ''); |
|
| 72 | 72 | echo $trunklist; ?> |
| 73 | 73 | </div> |
| 74 | 74 | </div> |
@@ -100,7 +100,7 @@ discard block |
||
| 100 | 100 | <div class="col-md-12 padding-b-10"> |
| 101 | 101 | <div class="pull-right"> |
| 102 | 102 | <input class="btn btn-line-parrot" id="import_terminationrate" type="submit" name="action" value="Import" /> |
| 103 | - <a href="<?php echo base_url() . 'rates/termination_rate_list/' ?>" > |
|
| 103 | + <a href="<?php echo base_url().'rates/termination_rate_list/' ?>" > |
|
| 104 | 104 | <input class="btn btn-line-sky margin-x-10" id="ok" type="button" name="action" value="Cancel"/> |
| 105 | 105 | </a> |
| 106 | 106 | </div> |
@@ -113,7 +113,7 @@ discard block |
||
| 113 | 113 | <?php |
| 114 | 114 | } ?> |
| 115 | 115 | <?php |
| 116 | - if (isset($csv_tmp_data) && !empty($csv_tmp_data)) { ?> |
|
| 116 | + if (isset($csv_tmp_data) && ! empty($csv_tmp_data)) { ?> |
|
| 117 | 117 | <section class="slice color-three padding-b-20"> |
| 118 | 118 | <div class="w-section inverse no-padding"> |
| 119 | 119 | <div class="container"> |
@@ -134,13 +134,13 @@ discard block |
||
| 134 | 134 | </thead> |
| 135 | 135 | <tbody> |
| 136 | 136 | <?php |
| 137 | - foreach($mapto_fields as $csv_key => $csv_value) { |
|
| 137 | + foreach ($mapto_fields as $csv_key => $csv_value) { |
|
| 138 | 138 | |
| 139 | 139 | echo "<tr>"; |
| 140 | - echo "<td>" . $csv_key . '(' . $csv_value . ")</td>"; |
|
| 141 | - echo "<td><input type='text' name='".$csv_value ."-prefix' id='".$csv_value ."-prefix'></td>"; |
|
| 140 | + echo "<td>".$csv_key.'('.$csv_value.")</td>"; |
|
| 141 | + echo "<td><input type='text' name='".$csv_value."-prefix' id='".$csv_value."-prefix'></td>"; |
|
| 142 | 142 | echo "<td>"; |
| 143 | - echo "<select name='".$csv_value ."-select' id='".$csv_value ."-select'>"; |
|
| 143 | + echo "<select name='".$csv_value."-select' id='".$csv_value."-select'>"; |
|
| 144 | 144 | ?> |
| 145 | 145 | <option value=""></option> |
| 146 | 146 | <?php |
@@ -152,7 +152,7 @@ discard block |
||
| 152 | 152 | <?php |
| 153 | 153 | } |
| 154 | 154 | echo "</td>"; |
| 155 | - echo "<td><input type='text' name='".$csv_value ."-display' id='".$csv_value ."-display'></td>"; |
|
| 155 | + echo "<td><input type='text' name='".$csv_value."-display' id='".$csv_value."-display'></td>"; |
|
| 156 | 156 | echo "</tr>"; |
| 157 | 157 | |
| 158 | 158 | } ?> |
@@ -168,17 +168,17 @@ discard block |
||
| 168 | 168 | <table width="100%" border="1" class="details_table"> |
| 169 | 169 | <?php |
| 170 | 170 | $cnt = 1; |
| 171 | - foreach($csv_tmp_data as $csv_key => $csv_value) { |
|
| 171 | + foreach ($csv_tmp_data as $csv_key => $csv_value) { |
|
| 172 | 172 | if ($csv_key < 15) { |
| 173 | 173 | echo "<tr>"; |
| 174 | - foreach($csv_value as $field_name => $field_val) { |
|
| 174 | + foreach ($csv_value as $field_name => $field_val) { |
|
| 175 | 175 | if ($csv_key == 0) { |
| 176 | 176 | |
| 177 | 177 | echo "<th>".ucfirst($field_val)."</th>"; |
| 178 | 178 | |
| 179 | 179 | } |
| 180 | 180 | else { |
| 181 | - echo "<td class='portlet-content'>" . $field_val . "</td>"; |
|
| 181 | + echo "<td class='portlet-content'>".$field_val."</td>"; |
|
| 182 | 182 | $cnt++; |
| 183 | 183 | } |
| 184 | 184 | } |
@@ -187,8 +187,8 @@ discard block |
||
| 187 | 187 | } |
| 188 | 188 | } |
| 189 | 189 | |
| 190 | - echo "<tr><td colspan='" . $cnt . "'> |
|
| 191 | - <a href='" . base_url() . "rates/termination_rate_list/'><input type='button' class='btn btn-line-sky pull-right margin-x-10' value='Back'/></a> |
|
| 190 | + echo "<tr><td colspan='".$cnt."'> |
|
| 191 | + <a href='" . base_url()."rates/termination_rate_list/'><input type='button' class='btn btn-line-sky pull-right margin-x-10' value='Back'/></a> |
|
| 192 | 192 | <input type='submit' class='btn btn-line-parrot pull-right'' id='Process' value='Process Records'/></td></tr>"; |
| 193 | 193 | ?> |
| 194 | 194 | </table> |
@@ -176,8 +176,7 @@ |
||
| 176 | 176 | |
| 177 | 177 | echo "<th>".ucfirst($field_val)."</th>"; |
| 178 | 178 | |
| 179 | - } |
|
| 180 | - else { |
|
| 179 | + } else { |
|
| 181 | 180 | echo "<td class='portlet-content'>" . $field_val . "</td>"; |
| 182 | 181 | $cnt++; |
| 183 | 182 | } |
@@ -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 | |
@@ -1253,11 +1253,11 @@ |
||
| 1253 | 1253 | { |
| 1254 | 1254 | $result = $this->rates_model->bulk_insert_termination_rate($new_final_arr); |
| 1255 | 1255 | } |
| 1256 | - else |
|
| 1257 | - { |
|
| 1256 | + else |
|
| 1257 | + { |
|
| 1258 | 1258 | |
| 1259 | - $this->session->set_flashdata('astpp_errormsg', 'Error - Nothing selected to import/process!'); |
|
| 1260 | - redirect(base_url() . 'rates/termination_rates_list/'); |
|
| 1259 | + $this->session->set_flashdata('astpp_errormsg', 'Error - Nothing selected to import/process!'); |
|
| 1260 | + redirect(base_url() . 'rates/termination_rates_list/'); |
|
| 1261 | 1261 | } |
| 1262 | 1262 | |
| 1263 | 1263 | unlink($full_path . $terminationrate_file_name); |
@@ -36,7 +36,7 @@ discard block |
||
| 36 | 36 | ini_set("max_execution_time", "259200"); |
| 37 | 37 | ini_set("upload_max_filesize", "200M"); |
| 38 | 38 | if ($this->session->userdata('user_login') == FALSE) |
| 39 | - redirect(base_url() . '/astpp/login'); |
|
| 39 | + redirect(base_url().'/astpp/login'); |
|
| 40 | 40 | } |
| 41 | 41 | |
| 42 | 42 | function termination_rates_list() { |
@@ -73,70 +73,70 @@ discard block |
||
| 73 | 73 | |
| 74 | 74 | echo json_encode($json_data); |
| 75 | 75 | } |
| 76 | - function termination_rates_list_delete($flag='') { |
|
| 76 | + function termination_rates_list_delete($flag = '') { |
|
| 77 | 77 | $json_data = array(); |
| 78 | - $this->session->set_userdata('advance_batch_data_delete',1); |
|
| 78 | + $this->session->set_userdata('advance_batch_data_delete', 1); |
|
| 79 | 79 | $count_all = $this->rates_model->get_termination_rates_list(false); |
| 80 | 80 | echo $count_all; |
| 81 | 81 | } |
| 82 | 82 | /****************/ |
| 83 | 83 | function termination_rate_import() { |
| 84 | 84 | $data['page_title'] = 'Import Termination Rates'; |
| 85 | - $this->session->set_userdata('import_termination_rate_csv',""); |
|
| 86 | - $this->session->set_userdata('import_termination_rate_csv_error',""); |
|
| 85 | + $this->session->set_userdata('import_termination_rate_csv', ""); |
|
| 86 | + $this->session->set_userdata('import_termination_rate_csv_error', ""); |
|
| 87 | 87 | $this->load->view('view_import_termination_rate', $data); |
| 88 | 88 | } |
| 89 | - function termination_rate_preview_file(){ |
|
| 90 | - $invalid_flag= false; |
|
| 91 | - $check_header=$this->input->post('check_header',true); |
|
| 89 | + function termination_rate_preview_file() { |
|
| 90 | + $invalid_flag = false; |
|
| 91 | + $check_header = $this->input->post('check_header', true); |
|
| 92 | 92 | $data['page_title'] = 'Import Termination Rates'; |
| 93 | 93 | $new_final_arr_key = $this->config->item('Termination-rates-field'); |
| 94 | - if(empty($_FILES) || !isset($_FILES)){ |
|
| 94 | + if (empty($_FILES) || ! isset($_FILES)) { |
|
| 95 | 95 | redirect(base_url()."rates/termination_rates_list/"); |
| 96 | 96 | } |
| 97 | - if (isset($_FILES['termination_rate_import']['name']) && $_FILES['termination_rate_import']['name'] != "" && isset($_POST['trunk_id']) && $_POST['trunk_id'] != '') { |
|
| 97 | + if (isset($_FILES['termination_rate_import']['name']) && $_FILES['termination_rate_import']['name'] != "" && isset($_POST['trunk_id']) && $_POST['trunk_id'] != '') { |
|
| 98 | 98 | list($txt, $ext) = explode(".", $_FILES['termination_rate_import']['name']); |
| 99 | - if($ext == "csv" && $_FILES['termination_rate_import']['size'] > 0){ |
|
| 99 | + if ($ext == "csv" && $_FILES['termination_rate_import']['size'] > 0) { |
|
| 100 | 100 | $error = $_FILES['termination_rate_import']['error']; |
| 101 | - if ($error == 0 ) { |
|
| 101 | + if ($error == 0) { |
|
| 102 | 102 | $uploadedFile = $_FILES["termination_rate_import"]["tmp_name"]; |
| 103 | - $csv_data=$this->csvreader->parse_file($uploadedFile,$new_final_arr_key,$check_header); |
|
| 104 | - if(!empty($csv_data)){ |
|
| 103 | + $csv_data = $this->csvreader->parse_file($uploadedFile, $new_final_arr_key, $check_header); |
|
| 104 | + if ( ! empty($csv_data)) { |
|
| 105 | 105 | $full_path = $this->config->item('rates-file-path'); |
| 106 | - $actual_file_name = "ASTPP-TERMINATION-RATES-".date("Y-m-d H:i:s"). "." . $ext; |
|
| 107 | - if (move_uploaded_file($uploadedFile,$full_path.$actual_file_name)) { |
|
| 106 | + $actual_file_name = "ASTPP-TERMINATION-RATES-".date("Y-m-d H:i:s").".".$ext; |
|
| 107 | + if (move_uploaded_file($uploadedFile, $full_path.$actual_file_name)) { |
|
| 108 | 108 | $data['csv_tmp_data'] = $csv_data; |
| 109 | 109 | $data['trunkid'] = $_POST['trunk_id']; |
| 110 | - $data['check_header']=$check_header; |
|
| 110 | + $data['check_header'] = $check_header; |
|
| 111 | 111 | $data['page_title'] = 'Termination Rates Preview'; |
| 112 | - $this->session->set_userdata('import_termination_rate_csv',$actual_file_name); |
|
| 113 | - }else{ |
|
| 112 | + $this->session->set_userdata('import_termination_rate_csv', $actual_file_name); |
|
| 113 | + } else { |
|
| 114 | 114 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 115 | 115 | } |
| 116 | 116 | } |
| 117 | 117 | } |
| 118 | - else{ |
|
| 119 | - $data['error']=="File Uploading Fail Please Try Again"; |
|
| 118 | + else { |
|
| 119 | + $data['error'] == "File Uploading Fail Please Try Again"; |
|
| 120 | 120 | } |
| 121 | - }else { |
|
| 121 | + } else { |
|
| 122 | 122 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 123 | 123 | } |
| 124 | - }else{ |
|
| 125 | - $invalid_flag=true; |
|
| 124 | + } else { |
|
| 125 | + $invalid_flag = true; |
|
| 126 | 126 | } |
| 127 | 127 | if ($invalid_flag) { |
| 128 | 128 | $str = ''; |
| 129 | - if (!isset($_POST['trunk_id']) || empty($_POST['trunk_id'])) { |
|
| 130 | - $str.= '<br/>Please Create Trunk.'; |
|
| 129 | + if ( ! isset($_POST['trunk_id']) || empty($_POST['trunk_id'])) { |
|
| 130 | + $str .= '<br/>Please Create Trunk.'; |
|
| 131 | 131 | } |
| 132 | 132 | if (empty($_FILES['termination_rate_import']['name'])) { |
| 133 | - $str.= '<br/>Please Select File.'; |
|
| 133 | + $str .= '<br/>Please Select File.'; |
|
| 134 | 134 | } |
| 135 | - $data['error']=$str; |
|
| 135 | + $data['error'] = $str; |
|
| 136 | 136 | } |
| 137 | 137 | $this->load->view('view_import_termination_rate', $data); |
| 138 | 138 | } |
| 139 | - function termination_rate_rates_import($trunkID,$check_header=false) { |
|
| 139 | + function termination_rate_rates_import($trunkID, $check_header = false) { |
|
| 140 | 140 | $new_final_arr = array(); |
| 141 | 141 | $invalid_array = array(); |
| 142 | 142 | $new_final_arr_key = $this->config->item('Termination-rates-field'); |
@@ -146,65 +146,65 @@ discard block |
||
| 146 | 146 | } |
| 147 | 147 | $full_path = $this->config->item('rates-file-path'); |
| 148 | 148 | $terminationrate_file_name = $this->session->userdata('import_termination_rate_csv'); |
| 149 | - $csv_tmp_data = $this->csvreader->parse_file($full_path.$terminationrate_file_name,$new_final_arr_key,$check_header); |
|
| 150 | - $i=0; |
|
| 149 | + $csv_tmp_data = $this->csvreader->parse_file($full_path.$terminationrate_file_name, $new_final_arr_key, $check_header); |
|
| 150 | + $i = 0; |
|
| 151 | 151 | foreach ($csv_tmp_data as $key => $csv_data) { |
| 152 | - if(isset($csv_data['pattern']) && $csv_data['pattern']!= '' && $i != 0){ |
|
| 153 | - $str=null; |
|
| 154 | - $csv_data['prepend']= isset($csv_data['prepend'])? $csv_data['prepend'] :''; |
|
| 155 | - $csv_data['comment']= isset($csv_data['comment'])? $csv_data['comment'] :''; |
|
| 156 | - $csv_data['connectcost']= isset($csv_data['connectcost']) ? $csv_data['connectcost'] :0; |
|
| 157 | - $csv_data['includedseconds']= isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] :0; |
|
| 158 | - $csv_data['cost']= !empty($csv_data['cost']) && is_numeric( $csv_data['cost']) ? $csv_data['cost'] :0; |
|
| 159 | - $csv_data['inc']= isset($csv_data['inc']) ? $csv_data['inc'] :0; |
|
| 160 | - $csv_data['precedence']= isset($csv_data['precedence']) ? $csv_data['precedence'] :''; |
|
| 161 | - $csv_data['strip']= isset($csv_data['strip']) ? $csv_data['strip'] :''; |
|
| 152 | + if (isset($csv_data['pattern']) && $csv_data['pattern'] != '' && $i != 0) { |
|
| 153 | + $str = null; |
|
| 154 | + $csv_data['prepend'] = isset($csv_data['prepend']) ? $csv_data['prepend'] : ''; |
|
| 155 | + $csv_data['comment'] = isset($csv_data['comment']) ? $csv_data['comment'] : ''; |
|
| 156 | + $csv_data['connectcost'] = isset($csv_data['connectcost']) ? $csv_data['connectcost'] : 0; |
|
| 157 | + $csv_data['includedseconds'] = isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] : 0; |
|
| 158 | + $csv_data['cost'] = ! empty($csv_data['cost']) && is_numeric($csv_data['cost']) ? $csv_data['cost'] : 0; |
|
| 159 | + $csv_data['inc'] = isset($csv_data['inc']) ? $csv_data['inc'] : 0; |
|
| 160 | + $csv_data['precedence'] = isset($csv_data['precedence']) ? $csv_data['precedence'] : ''; |
|
| 161 | + $csv_data['strip'] = isset($csv_data['strip']) ? $csv_data['strip'] : ''; |
|
| 162 | 162 | $csv_data['last_modified_date'] = date("Y-m-d H:i:s"); |
| 163 | - $str=$this->data_validate($csv_data); |
|
| 164 | - if($str != ""){ |
|
| 165 | - $invalid_array[$i]=$csv_data; |
|
| 163 | + $str = $this->data_validate($csv_data); |
|
| 164 | + if ($str != "") { |
|
| 165 | + $invalid_array[$i] = $csv_data; |
|
| 166 | 166 | $invalid_array[$i]['error'] = $str; |
| 167 | 167 | } |
| 168 | - else{ |
|
| 169 | - $csv_data['trunk_id']=$trunkID; |
|
| 170 | - $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
|
| 171 | - $new_final_arr[$i]=$csv_data; |
|
| 168 | + else { |
|
| 169 | + $csv_data['trunk_id'] = $trunkID; |
|
| 170 | + $csv_data['pattern'] = "^".$csv_data['pattern'].".*"; |
|
| 171 | + $new_final_arr[$i] = $csv_data; |
|
| 172 | 172 | } |
| 173 | 173 | } |
| 174 | 174 | $i++; |
| 175 | 175 | } |
| 176 | - if(!empty($new_final_arr)){ |
|
| 176 | + if ( ! empty($new_final_arr)) { |
|
| 177 | 177 | $result = $this->rates_model->bulk_insert_termination_rate($new_final_arr); |
| 178 | 178 | } |
| 179 | 179 | unlink($full_path.$terminationrate_file_name); |
| 180 | - $count=count($invalid_array); |
|
| 181 | - if($count >0){ |
|
| 180 | + $count = count($invalid_array); |
|
| 181 | + if ($count > 0) { |
|
| 182 | 182 | $session_id = "-1"; |
| 183 | 183 | $fp = fopen($full_path.$session_id.'.csv', 'w'); |
| 184 | - foreach($new_final_arr_key as $key=>$value){ |
|
| 185 | - $custom_array[0][$key]=ucfirst($key); |
|
| 184 | + foreach ($new_final_arr_key as $key=>$value) { |
|
| 185 | + $custom_array[0][$key] = ucfirst($key); |
|
| 186 | 186 | } |
| 187 | - $custom_array[0]['error']= "Error"; |
|
| 188 | - $invalid_array =array_merge($custom_array,$invalid_array); |
|
| 189 | - foreach($invalid_array as $err_data){ |
|
| 190 | - fputcsv($fp,$err_data); |
|
| 187 | + $custom_array[0]['error'] = "Error"; |
|
| 188 | + $invalid_array = array_merge($custom_array, $invalid_array); |
|
| 189 | + foreach ($invalid_array as $err_data) { |
|
| 190 | + fputcsv($fp, $err_data); |
|
| 191 | 191 | } |
| 192 | 192 | fclose($fp); |
| 193 | 193 | $this->session->set_userdata('import_termination_rate_csv_error', $session_id.".csv"); |
| 194 | 194 | $data["error"] = $invalid_array; |
| 195 | 195 | $data['trunkid'] = $trunkID; |
| 196 | 196 | $data['impoted_count'] = count($new_final_arr); |
| 197 | - $data['failure_count'] = count($invalid_array)-1; |
|
| 197 | + $data['failure_count'] = count($invalid_array) - 1; |
|
| 198 | 198 | $data['page_title'] = 'Termination Rates Import Error'; |
| 199 | - $this->load->view('view_import_error',$data); |
|
| 200 | - } else{ |
|
| 199 | + $this->load->view('view_import_error', $data); |
|
| 200 | + } else { |
|
| 201 | 201 | $this->session->set_flashdata('astpp_errormsg', 'Total '.count($new_final_arr).' Termination rates imported successfully!'); |
| 202 | 202 | redirect(base_url()."rates/termination_rates_list/"); |
| 203 | 203 | } |
| 204 | 204 | } |
| 205 | - function termination_rate_error_download(){ |
|
| 205 | + function termination_rate_error_download() { |
|
| 206 | 206 | $this->load->helper('download'); |
| 207 | - $error_data = $this->session->userdata('import_termination_rate_csv_error'); |
|
| 207 | + $error_data = $this->session->userdata('import_termination_rate_csv_error'); |
|
| 208 | 208 | $full_path = $this->config->item('rates-file-path'); |
| 209 | 209 | $data = file_get_contents($full_path.$error_data); |
| 210 | 210 | force_download("Termination_rate_error.csv", $data); |
@@ -212,182 +212,182 @@ discard block |
||
| 212 | 212 | } |
| 213 | 213 | function origination_rate_import() { |
| 214 | 214 | $data['page_title'] = 'Import Origination Rates'; |
| 215 | - $this->session->set_userdata('import_origination_rate_csv',""); |
|
| 216 | - $error_data = $this->session->userdata('import_origination_rate_csv_error'); |
|
| 215 | + $this->session->set_userdata('import_origination_rate_csv', ""); |
|
| 216 | + $error_data = $this->session->userdata('import_origination_rate_csv_error'); |
|
| 217 | 217 | $full_path = $this->config->item('rates-file-path'); |
| 218 | - if(file_exists($full_path.$error_data) && $error_data != ""){ |
|
| 218 | + if (file_exists($full_path.$error_data) && $error_data != "") { |
|
| 219 | 219 | unlink($full_path.$error_data); |
| 220 | - $this->session->set_userdata('import_origination_rate_csv_error',""); |
|
| 220 | + $this->session->set_userdata('import_origination_rate_csv_error', ""); |
|
| 221 | 221 | } |
| 222 | 222 | $this->load->view('view_import_origination_rate', $data); |
| 223 | 223 | } |
| 224 | - function origination_rate_preview_file(){ |
|
| 225 | - $invalid_flag= false; |
|
| 226 | - $data=array(); |
|
| 224 | + function origination_rate_preview_file() { |
|
| 225 | + $invalid_flag = false; |
|
| 226 | + $data = array(); |
|
| 227 | 227 | $data['page_title'] = 'Import Origination Rates'; |
| 228 | - $check_header=$this->input->post('check_header',true); |
|
| 229 | - if(empty($_FILES) || !isset($_FILES)){ |
|
| 228 | + $check_header = $this->input->post('check_header', true); |
|
| 229 | + if (empty($_FILES) || ! isset($_FILES)) { |
|
| 230 | 230 | redirect(base_url()."rates/origination_rate_list/"); |
| 231 | 231 | } |
| 232 | - $get_extension=strpos($_FILES['origination_rate_import']['name'],'.'); |
|
| 232 | + $get_extension = strpos($_FILES['origination_rate_import']['name'], '.'); |
|
| 233 | 233 | $new_final_arr_key = $this->config->item('Origination-rates-field'); |
| 234 | - if(!$get_extension){ |
|
| 235 | - $data['error']= "Please Upload File Atleast"; |
|
| 234 | + if ( ! $get_extension) { |
|
| 235 | + $data['error'] = "Please Upload File Atleast"; |
|
| 236 | 236 | } |
| 237 | 237 | if (isset($_FILES['origination_rate_import']['name']) && $_FILES['origination_rate_import']['name'] != "" && isset($_POST['pricelist_id']) && $_POST['pricelist_id'] != '') { |
| 238 | - list($txt,$ext) = explode(".", $_FILES['origination_rate_import']['name']); |
|
| 238 | + list($txt, $ext) = explode(".", $_FILES['origination_rate_import']['name']); |
|
| 239 | 239 | |
| 240 | - if($ext == "csv" && $_FILES['origination_rate_import']['size'] > 0){ |
|
| 240 | + if ($ext == "csv" && $_FILES['origination_rate_import']['size'] > 0) { |
|
| 241 | 241 | $error = $_FILES['origination_rate_import']['error']; |
| 242 | 242 | if ($error == 0) { |
| 243 | 243 | $uploadedFile = $_FILES["origination_rate_import"]["tmp_name"]; |
| 244 | - $csv_data=$this->csvreader->parse_file($uploadedFile,$new_final_arr_key,$check_header); |
|
| 245 | - if(!empty($csv_data)){ |
|
| 244 | + $csv_data = $this->csvreader->parse_file($uploadedFile, $new_final_arr_key, $check_header); |
|
| 245 | + if ( ! empty($csv_data)) { |
|
| 246 | 246 | $full_path = $this->config->item('rates-file-path'); |
| 247 | - $actual_file_name = "ASTPP-ORIGIN-RATES-".date("Y-m-d H:i:s"). "." . $ext; |
|
| 248 | - if (move_uploaded_file($uploadedFile,$full_path.$actual_file_name)) { |
|
| 249 | - $flag=false; |
|
| 250 | - $data['trunkid']=isset($_POST['trunk_id']) && $_POST['trunk_id'] > 0 ? $_POST['trunk_id'] : 0; |
|
| 247 | + $actual_file_name = "ASTPP-ORIGIN-RATES-".date("Y-m-d H:i:s").".".$ext; |
|
| 248 | + if (move_uploaded_file($uploadedFile, $full_path.$actual_file_name)) { |
|
| 249 | + $flag = false; |
|
| 250 | + $data['trunkid'] = isset($_POST['trunk_id']) && $_POST['trunk_id'] > 0 ? $_POST['trunk_id'] : 0; |
|
| 251 | 251 | $data['csv_tmp_data'] = $csv_data; |
| 252 | 252 | $data['pricelistid'] = $_POST['pricelist_id']; |
| 253 | 253 | $data['page_title'] = "Origination Rates Preview"; |
| 254 | - $data['check_header']=$check_header; |
|
| 255 | - $this->session->set_userdata('import_origination_rate_csv',$actual_file_name); |
|
| 256 | - }else{ |
|
| 254 | + $data['check_header'] = $check_header; |
|
| 255 | + $this->session->set_userdata('import_origination_rate_csv', $actual_file_name); |
|
| 256 | + } else { |
|
| 257 | 257 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 258 | 258 | } |
| 259 | 259 | } |
| 260 | 260 | } |
| 261 | - else{ |
|
| 262 | - $data['error']=="File Uploading Fail Please Try Again"; |
|
| 261 | + else { |
|
| 262 | + $data['error'] == "File Uploading Fail Please Try Again"; |
|
| 263 | 263 | } |
| 264 | 264 | } |
| 265 | 265 | else { |
| 266 | 266 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 267 | 267 | } |
| 268 | - }else{ |
|
| 269 | - $invalid_flag=true; |
|
| 268 | + } else { |
|
| 269 | + $invalid_flag = true; |
|
| 270 | 270 | } |
| 271 | 271 | if ($invalid_flag) { |
| 272 | 272 | $str = ''; |
| 273 | - if (!isset($_POST['pricelist_id']) || empty($_POST['pricelist_id'])) { |
|
| 274 | - $str.= '<br/>Please Create Rate Group.'; |
|
| 273 | + if ( ! isset($_POST['pricelist_id']) || empty($_POST['pricelist_id'])) { |
|
| 274 | + $str .= '<br/>Please Create Rate Group.'; |
|
| 275 | 275 | } |
| 276 | 276 | if (empty($_FILES['origination_rate_import']['name'])) { |
| 277 | - $str.= '<br/>Please Select File.'; |
|
| 277 | + $str .= '<br/>Please Select File.'; |
|
| 278 | 278 | } |
| 279 | - $data['error']=$str; |
|
| 279 | + $data['error'] = $str; |
|
| 280 | 280 | } |
| 281 | 281 | $this->load->view('view_import_origination_rate', $data); |
| 282 | 282 | } |
| 283 | - function origination_rate_import_file($pricelistID,$trunkid,$check_header=false) { |
|
| 283 | + function origination_rate_import_file($pricelistID, $trunkid, $check_header = false) { |
|
| 284 | 284 | $new_final_arr = array(); |
| 285 | 285 | $invalid_array = array(); |
| 286 | 286 | $new_final_arr_key = $this->config->item('Origination-rates-field'); |
| 287 | 287 | $screen_path = $this->config->item('screen_path'); |
| 288 | - $reseller_id=0; |
|
| 288 | + $reseller_id = 0; |
|
| 289 | 289 | if ($this->session->userdata('logintype') == 1 || $this->session->userdata('logintype') == 5) { |
| 290 | 290 | $reseller_id = $this->session->userdata["accountinfo"]['id']; |
| 291 | 291 | } |
| 292 | 292 | |
| 293 | 293 | $full_path = $this->config->item('rates-file-path'); |
| 294 | 294 | $originationrate_file_name = $this->session->userdata('import_origination_rate_csv'); |
| 295 | - $csv_tmp_data = $this->csvreader->parse_file($full_path.$originationrate_file_name,$new_final_arr_key,$check_header); |
|
| 295 | + $csv_tmp_data = $this->csvreader->parse_file($full_path.$originationrate_file_name, $new_final_arr_key, $check_header); |
|
| 296 | 296 | //echo "<pre>";print_r($csv_tmp_data);exit; |
| 297 | - $i=0; |
|
| 297 | + $i = 0; |
|
| 298 | 298 | foreach ($csv_tmp_data as $key => $csv_data) { |
| 299 | - if(isset($csv_data['pattern']) && $csv_data['pattern']!= '' && $i != 0){ |
|
| 300 | - $str=null; |
|
| 301 | - $csv_data['comment']= isset($csv_data['comment'])? $csv_data['comment'] :''; |
|
| 302 | - $csv_data['connectcost']= isset($csv_data['connectcost']) ? $csv_data['connectcost'] :0; |
|
| 303 | - $csv_data['includedseconds']= isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] :0; |
|
| 304 | - $csv_data['cost']= !empty($csv_data['cost']) && is_numeric( $csv_data['cost']) ? $csv_data['cost'] :0; |
|
| 305 | - $csv_data['inc']= isset($csv_data['inc']) ? $csv_data['inc'] :0; |
|
| 306 | - $csv_data['precedence']= isset($csv_data['precedence']) ? $csv_data['precedence'] :''; |
|
| 299 | + if (isset($csv_data['pattern']) && $csv_data['pattern'] != '' && $i != 0) { |
|
| 300 | + $str = null; |
|
| 301 | + $csv_data['comment'] = isset($csv_data['comment']) ? $csv_data['comment'] : ''; |
|
| 302 | + $csv_data['connectcost'] = isset($csv_data['connectcost']) ? $csv_data['connectcost'] : 0; |
|
| 303 | + $csv_data['includedseconds'] = isset($csv_data['includedseconds']) ? $csv_data['includedseconds'] : 0; |
|
| 304 | + $csv_data['cost'] = ! empty($csv_data['cost']) && is_numeric($csv_data['cost']) ? $csv_data['cost'] : 0; |
|
| 305 | + $csv_data['inc'] = isset($csv_data['inc']) ? $csv_data['inc'] : 0; |
|
| 306 | + $csv_data['precedence'] = isset($csv_data['precedence']) ? $csv_data['precedence'] : ''; |
|
| 307 | 307 | $csv_data['last_modified_date'] = date("Y-m-d H:i:s"); |
| 308 | - $str=$this->data_validate($csv_data); |
|
| 309 | - if($str != ""){ |
|
| 310 | - $invalid_array[$i]=$csv_data; |
|
| 308 | + $str = $this->data_validate($csv_data); |
|
| 309 | + if ($str != "") { |
|
| 310 | + $invalid_array[$i] = $csv_data; |
|
| 311 | 311 | $invalid_array[$i]['error'] = $str; |
| 312 | 312 | } |
| 313 | - else{ |
|
| 314 | - $csv_data['pricelist_id']=$pricelistID; |
|
| 315 | - $csv_data['trunk_id']=$trunkid; |
|
| 316 | - $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
|
| 317 | - $csv_data['reseller_id']= $reseller_id; |
|
| 313 | + else { |
|
| 314 | + $csv_data['pricelist_id'] = $pricelistID; |
|
| 315 | + $csv_data['trunk_id'] = $trunkid; |
|
| 316 | + $csv_data['pattern'] = "^".$csv_data['pattern'].".*"; |
|
| 317 | + $csv_data['reseller_id'] = $reseller_id; |
|
| 318 | 318 | $csv_data['creation_date'] = gmdate('Y-m-d H:i:s'); |
| 319 | - $new_final_arr[$i]=$csv_data; |
|
| 319 | + $new_final_arr[$i] = $csv_data; |
|
| 320 | 320 | } |
| 321 | 321 | } |
| 322 | 322 | $i++; |
| 323 | 323 | } |
| 324 | - if(!empty($new_final_arr)){ |
|
| 324 | + if ( ! empty($new_final_arr)) { |
|
| 325 | 325 | $result = $this->rates_model->bulk_insert_origination_rate($new_final_arr); |
| 326 | 326 | } |
| 327 | 327 | unlink($full_path.$originationrate_file_name); |
| 328 | - $count=count($invalid_array); |
|
| 329 | - if($count >0){ |
|
| 328 | + $count = count($invalid_array); |
|
| 329 | + if ($count > 0) { |
|
| 330 | 330 | $session_id = "-1"; |
| 331 | 331 | $fp = fopen($full_path.$session_id.'.csv', 'w'); |
| 332 | - foreach($new_final_arr_key as $key=>$value){ |
|
| 333 | - $custom_array[0][$key]=ucfirst($key); |
|
| 332 | + foreach ($new_final_arr_key as $key=>$value) { |
|
| 333 | + $custom_array[0][$key] = ucfirst($key); |
|
| 334 | 334 | } |
| 335 | - $custom_array[0]['error']= "Error"; |
|
| 336 | - $invalid_array =array_merge($custom_array,$invalid_array); |
|
| 337 | - foreach($invalid_array as $err_data){ |
|
| 338 | - fputcsv($fp,$err_data); |
|
| 335 | + $custom_array[0]['error'] = "Error"; |
|
| 336 | + $invalid_array = array_merge($custom_array, $invalid_array); |
|
| 337 | + foreach ($invalid_array as $err_data) { |
|
| 338 | + fputcsv($fp, $err_data); |
|
| 339 | 339 | } |
| 340 | 340 | fclose($fp); |
| 341 | 341 | $this->session->set_userdata('import_origination_rate_csv_error', $session_id.".csv"); |
| 342 | 342 | $data["error"] = $invalid_array; |
| 343 | 343 | $data['pricelistid'] = $pricelistID; |
| 344 | 344 | $data['impoted_count'] = count($new_final_arr); |
| 345 | - $data['failure_count'] = count($invalid_array)-1; |
|
| 345 | + $data['failure_count'] = count($invalid_array) - 1; |
|
| 346 | 346 | $data['page_title'] = 'Origination Rates Import Error'; |
| 347 | - $this->load->view('view_import_error',$data); |
|
| 348 | - } else{ |
|
| 347 | + $this->load->view('view_import_error', $data); |
|
| 348 | + } else { |
|
| 349 | 349 | $this->session->set_flashdata('astpp_errormsg', 'Total '.count($new_final_arr).' Origination rates imported successfully!'); |
| 350 | 350 | redirect(base_url()."rates/origination_rates_list/"); |
| 351 | 351 | } |
| 352 | 352 | } |
| 353 | - function data_validate($csvdata){ |
|
| 354 | - $str=null; |
|
| 353 | + function data_validate($csvdata) { |
|
| 354 | + $str = null; |
|
| 355 | 355 | $alpha_regex = "/^[a-z ,.'-]+$/i"; |
| 356 | 356 | $alpha_numeric_regex = "/^[a-z0-9 ,.'-]+$/i"; |
| 357 | 357 | $email_regex = "/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/"; |
| 358 | - $str.= $csvdata['pattern']!= '' ? null : 'Code,'; |
|
| 359 | - $str=rtrim($str,','); |
|
| 360 | - if(!$str){ |
|
| 361 | - $str.= is_numeric($csvdata['pattern']) ? null : 'Code,'; |
|
| 362 | - |
|
| 363 | - $str.= !empty($csvdata['connectcost']) && is_numeric( $csvdata['connectcost']) ? null :( empty($csvdata['connectcost']) ? null : 'Connect Cost,'); |
|
| 364 | - $str.= !empty($csvdata['includedseconds']) && is_numeric( $csvdata['includedseconds']) ? null :( empty($csvdata['includedseconds']) ? null : 'Included Seconds,'); |
|
| 365 | - |
|
| 366 | - $str.= !empty($csvdata['inc']) && is_numeric( $csvdata['inc']) ? null :( empty($csvdata['inc']) ? null : 'Increment,'); |
|
| 367 | - $str.= !empty($csvdata['precedence']) && is_numeric( $csvdata['precedence']) ? null :( empty($csvdata['precedence']) ? null : 'Precedence,'); |
|
| 368 | - $str.= (isset($csvdata['strip']) && !empty($csvdata['strip'])) ? (is_numeric($csvdata['strip']) ? null :'Strip,') : null; |
|
| 369 | - if($str){ |
|
| 370 | - $str=rtrim($str,','); |
|
| 371 | - $error_field=explode(',',$str); |
|
| 358 | + $str .= $csvdata['pattern'] != '' ? null : 'Code,'; |
|
| 359 | + $str = rtrim($str, ','); |
|
| 360 | + if ( ! $str) { |
|
| 361 | + $str .= is_numeric($csvdata['pattern']) ? null : 'Code,'; |
|
| 362 | + |
|
| 363 | + $str .= ! empty($csvdata['connectcost']) && is_numeric($csvdata['connectcost']) ? null : (empty($csvdata['connectcost']) ? null : 'Connect Cost,'); |
|
| 364 | + $str .= ! empty($csvdata['includedseconds']) && is_numeric($csvdata['includedseconds']) ? null : (empty($csvdata['includedseconds']) ? null : 'Included Seconds,'); |
|
| 365 | + |
|
| 366 | + $str .= ! empty($csvdata['inc']) && is_numeric($csvdata['inc']) ? null : (empty($csvdata['inc']) ? null : 'Increment,'); |
|
| 367 | + $str .= ! empty($csvdata['precedence']) && is_numeric($csvdata['precedence']) ? null : (empty($csvdata['precedence']) ? null : 'Precedence,'); |
|
| 368 | + $str .= (isset($csvdata['strip']) && ! empty($csvdata['strip'])) ? (is_numeric($csvdata['strip']) ? null : 'Strip,') : null; |
|
| 369 | + if ($str) { |
|
| 370 | + $str = rtrim($str, ','); |
|
| 371 | + $error_field = explode(',', $str); |
|
| 372 | 372 | $count = count($error_field); |
| 373 | - $str.= $count > 1 ? ' are not valid' : ' is not Valid'; |
|
| 373 | + $str .= $count > 1 ? ' are not valid' : ' is not Valid'; |
|
| 374 | 374 | return $str; |
| 375 | 375 | } |
| 376 | - else{ |
|
| 376 | + else { |
|
| 377 | 377 | return false; |
| 378 | 378 | } |
| 379 | 379 | } |
| 380 | - else{ |
|
| 381 | - $str=rtrim($str,','); |
|
| 382 | - $error_field=explode(',',$str); |
|
| 380 | + else { |
|
| 381 | + $str = rtrim($str, ','); |
|
| 382 | + $error_field = explode(',', $str); |
|
| 383 | 383 | $count = count($error_field); |
| 384 | - $str.= $count > 1 ? ' are required' : ' is Required'; |
|
| 384 | + $str .= $count > 1 ? ' are required' : ' is Required'; |
|
| 385 | 385 | return $str; |
| 386 | 386 | } |
| 387 | 387 | } |
| 388 | - function origination_rate_error_download(){ |
|
| 388 | + function origination_rate_error_download() { |
|
| 389 | 389 | $this->load->helper('download'); |
| 390 | - $error_data = $this->session->userdata('import_origination_rate_csv_error'); |
|
| 390 | + $error_data = $this->session->userdata('import_origination_rate_csv_error'); |
|
| 391 | 391 | $full_path = $this->config->item('rates-file-path'); |
| 392 | 392 | $data = file_get_contents($full_path.$error_data); |
| 393 | 393 | force_download("Origination_rate_error.csv", $data); |
@@ -417,13 +417,13 @@ discard block |
||
| 417 | 417 | $edit_data = $value; |
| 418 | 418 | } |
| 419 | 419 | $edit_data['connectcost'] = $this->common_model->to_calculate_currency($edit_data['connectcost'], '', '', true, false); |
| 420 | - $edit_data['cost'] = $this->common_model->to_calculate_currency($edit_data['cost'], '', '',true, false); |
|
| 420 | + $edit_data['cost'] = $this->common_model->to_calculate_currency($edit_data['cost'], '', '', true, false); |
|
| 421 | 421 | $edit_data['pattern'] = filter_var($edit_data['pattern'], FILTER_SANITIZE_NUMBER_INT); |
| 422 | 422 | |
| 423 | 423 | $data['form'] = $this->form->build_form($this->rates_form->get_origination_rate_form_fields(), $edit_data); |
| 424 | 424 | $this->load->view('view_origination_rate_add_edit', $data); |
| 425 | 425 | } else { |
| 426 | - redirect(base_url() . 'rates/origination_rate_list/'); |
|
| 426 | + redirect(base_url().'rates/origination_rate_list/'); |
|
| 427 | 427 | } |
| 428 | 428 | } |
| 429 | 429 | |
@@ -471,7 +471,7 @@ discard block |
||
| 471 | 471 | $this->session->set_userdata('origination_rate_list_search', $action); |
| 472 | 472 | } |
| 473 | 473 | if (@$ajax_search != 1) { |
| 474 | - redirect(base_url() . 'rates/origination_rates_list/'); |
|
| 474 | + redirect(base_url().'rates/origination_rates_list/'); |
|
| 475 | 475 | } |
| 476 | 476 | } |
| 477 | 477 | |
@@ -483,13 +483,13 @@ discard block |
||
| 483 | 483 | function termination_rate_delete($id) { |
| 484 | 484 | $this->rates_model->remove_termination_rate($id); |
| 485 | 485 | $this->session->set_flashdata('astpp_notification', 'Termination removed successfully!'); |
| 486 | - redirect(base_url() . '/rates/termination_rates_list/'); |
|
| 486 | + redirect(base_url().'/rates/termination_rates_list/'); |
|
| 487 | 487 | } |
| 488 | 488 | |
| 489 | 489 | function origination_rate_delete($id) { |
| 490 | 490 | $this->rates_model->remove_origination_rate($id); |
| 491 | 491 | $this->session->set_flashdata('astpp_notification', 'Origination rate removed successfully!'); |
| 492 | - redirect(base_url() . 'rates/origination_rates_list/'); |
|
| 492 | + redirect(base_url().'rates/origination_rates_list/'); |
|
| 493 | 493 | } |
| 494 | 494 | |
| 495 | 495 | function origination_rates_list() { |
@@ -528,9 +528,9 @@ discard block |
||
| 528 | 528 | echo json_encode($json_data); |
| 529 | 529 | } |
| 530 | 530 | |
| 531 | - function origination_rates_list_delete($flag='') { |
|
| 531 | + function origination_rates_list_delete($flag = '') { |
|
| 532 | 532 | $json_data = array(); |
| 533 | - $this->session->set_userdata('advance_batch_data_delete',1); |
|
| 533 | + $this->session->set_userdata('advance_batch_data_delete', 1); |
|
| 534 | 534 | $count_all = $this->rates_model->get_origination_rate_list(false); |
| 535 | 535 | echo $count_all; |
| 536 | 536 | } |
@@ -604,7 +604,7 @@ discard block |
||
| 604 | 604 | $this->session->set_userdata('termination_rates_list_search', $action); |
| 605 | 605 | } |
| 606 | 606 | if (@$ajax_search != 1) { |
| 607 | - redirect(base_url() . 'rates/termination_rates_list/'); |
|
| 607 | + redirect(base_url().'rates/termination_rates_list/'); |
|
| 608 | 608 | } |
| 609 | 609 | } |
| 610 | 610 | |
@@ -613,20 +613,20 @@ discard block |
||
| 613 | 613 | $this->session->set_userdata('account_search', ""); |
| 614 | 614 | } |
| 615 | 615 | |
| 616 | - function customer_block_pattern_list($accountid,$accounttype) { |
|
| 616 | + function customer_block_pattern_list($accountid, $accounttype) { |
|
| 617 | 617 | $json_data = array(); |
| 618 | 618 | $where = array('accountid' => $accountid); |
| 619 | - $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_pattern'); |
|
| 620 | - $like_str=!empty($instant_search) ? "(blocked_patterns like '%$instant_search%' OR destination like '%$instant_search%' )" :null; |
|
| 621 | - if(!empty($like_str)) |
|
| 619 | + $instant_search = $this->session->userdata('left_panel_search_'.$accounttype.'_pattern'); |
|
| 620 | + $like_str = ! empty($instant_search) ? "(blocked_patterns like '%$instant_search%' OR destination like '%$instant_search%' )" : null; |
|
| 621 | + if ( ! empty($like_str)) |
|
| 622 | 622 | $this->db->where($like_str); |
| 623 | 623 | $count_all = $this->db_model->countQuery("*", "block_patterns", $where); |
| 624 | 624 | $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
| 625 | 625 | $json_data = $paging_data["json_paging"]; |
| 626 | - if(!empty($like_str)) |
|
| 626 | + if ( ! empty($like_str)) |
|
| 627 | 627 | $this->db->where($like_str); |
| 628 | 628 | $pattern_data = $this->db_model->getSelect("*", "block_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]); |
| 629 | - $grid_fields = json_decode($this->rates_form->build_pattern_list_for_customer($accountid,$accounttype)); |
|
| 629 | + $grid_fields = json_decode($this->rates_form->build_pattern_list_for_customer($accountid, $accounttype)); |
|
| 630 | 630 | $json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields); |
| 631 | 631 | echo json_encode($json_data); |
| 632 | 632 | } |
@@ -649,7 +649,7 @@ discard block |
||
| 649 | 649 | $json_data = array(); |
| 650 | 650 | $account_data = $this->session->userdata("accountinfo"); |
| 651 | 651 | $markup = $this->common->get_field_name('markup', 'pricelists', array('id'=>$account_data["pricelist_id"])); |
| 652 | - $markup = ($markup > 0)?$markup:1; |
|
| 652 | + $markup = ($markup > 0) ? $markup : 1; |
|
| 653 | 653 | |
| 654 | 654 | $count_all = $this->rates_model->get_origination_rate_list_for_user(false); |
| 655 | 655 | $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
@@ -659,11 +659,11 @@ discard block |
||
| 659 | 659 | $grid_fields = json_decode($this->rates_form->build_origination_rate_list_for_user()); |
| 660 | 660 | foreach ($query->result_array() as $key => $value) { |
| 661 | 661 | $json_data['rows'][] = array('cell' => array( |
| 662 | - $this->common->get_only_numeric_val("","",$value["pattern"]), |
|
| 662 | + $this->common->get_only_numeric_val("", "", $value["pattern"]), |
|
| 663 | 663 | $value['comment'], |
| 664 | 664 | $value['inc'], |
| 665 | - $this->common_model->calculate_currency(($value['cost'] + ($value['cost']*$markup)/100),'','','',true), |
|
| 666 | - $this->common_model->calculate_currency($value['connectcost'],'','','',true), |
|
| 665 | + $this->common_model->calculate_currency(($value['cost'] + ($value['cost'] * $markup) / 100), '', '', '', true), |
|
| 666 | + $this->common_model->calculate_currency($value['connectcost'], '', '', '', true), |
|
| 667 | 667 | $value['includedseconds'] |
| 668 | 668 | )); |
| 669 | 669 | } |
@@ -682,7 +682,7 @@ discard block |
||
| 682 | 682 | $this->session->set_userdata('origination_rate_list_search', $action); |
| 683 | 683 | } |
| 684 | 684 | if (@$ajax_search != 1) { |
| 685 | - redirect(base_url() . 'user/user_rates_list/'); |
|
| 685 | + redirect(base_url().'user/user_rates_list/'); |
|
| 686 | 686 | } |
| 687 | 687 | } |
| 688 | 688 | |
@@ -690,10 +690,10 @@ discard block |
||
| 690 | 690 | $this->session->set_userdata('advance_search', 0); |
| 691 | 691 | $this->session->set_userdata('account_search', ""); |
| 692 | 692 | } |
| 693 | - function customer_rates_download_sample_file($file_name){ |
|
| 693 | + function customer_rates_download_sample_file($file_name) { |
|
| 694 | 694 | $this->load->helper('download'); |
| 695 | 695 | $full_path = base_url()."assets/Rates_File/".$file_name.".csv"; |
| 696 | - $arrContextOptions=array( |
|
| 696 | + $arrContextOptions = array( |
|
| 697 | 697 | "ssl"=>array( |
| 698 | 698 | "verify_peer"=>false, |
| 699 | 699 | "verify_peer_name"=>false, |
@@ -702,19 +702,19 @@ discard block |
||
| 702 | 702 | $file = file_get_contents($full_path, false, stream_context_create($arrContextOptions)); |
| 703 | 703 | force_download("samplefile.csv", $file); |
| 704 | 704 | } |
| 705 | - function termination_rate_batch_update(){ |
|
| 705 | + function termination_rate_batch_update() { |
|
| 706 | 706 | $batch_update_arr = $this->input->post(); |
| 707 | - $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"])?$this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false):"0.0000"; |
|
| 708 | - $batch_update_arr["connectcost"]["connectcost"] = isset($batch_update_arr["connectcost"]["connectcost"])?$this->common_model->add_calculate_currency($batch_update_arr["connectcost"]["connectcost"], '', '', true, false):"0.0000"; |
|
| 707 | + $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"]) ? $this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false) : "0.0000"; |
|
| 708 | + $batch_update_arr["connectcost"]["connectcost"] = isset($batch_update_arr["connectcost"]["connectcost"]) ? $this->common_model->add_calculate_currency($batch_update_arr["connectcost"]["connectcost"], '', '', true, false) : "0.0000"; |
|
| 709 | 709 | // $batch_update_arr = array("inc"=> array("inc"=>"1","operator"=>"3"),"cost"=> array("cost"=>"1","operator"=>"4")); |
| 710 | 710 | $result = $this->rates_model->termination_rate_batch_update($batch_update_arr); |
| 711 | 711 | echo json_encode(array("SUCCESS"=> "Termination rates batch updated successfully!")); |
| 712 | 712 | exit; |
| 713 | 713 | } |
| 714 | 714 | |
| 715 | - function origination_rate_batch_update(){ |
|
| 715 | + function origination_rate_batch_update() { |
|
| 716 | 716 | $batch_update_arr = $this->input->post(); |
| 717 | - $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"])?$this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false):"0.0000"; |
|
| 717 | + $batch_update_arr["cost"]["cost"] = isset($batch_update_arr["cost"]["cost"]) ? $this->common_model->add_calculate_currency($batch_update_arr["cost"]["cost"], '', '', true, false) : "0.0000"; |
|
| 718 | 718 | // $batch_update_arr = array("inc"=> array("inc"=>"1","operator"=>"3"),"cost"=> array("cost"=>"1","operator"=>"4")); |
| 719 | 719 | $result = $this->rates_model->origination_rate_batch_update($batch_update_arr); |
| 720 | 720 | echo json_encode(array("SUCCESS"=> "Origination rates batch updated successfully!")); |
@@ -723,23 +723,23 @@ discard block |
||
| 723 | 723 | |
| 724 | 724 | function termination_rate_export_cdr_xls() { |
| 725 | 725 | $account_info = $accountinfo = $this->session->userdata('accountinfo'); |
| 726 | - $currency_id=$account_info['currency_id']; |
|
| 727 | - $currency=$this->common->get_field_name('currency', 'currency', $currency_id); |
|
| 726 | + $currency_id = $account_info['currency_id']; |
|
| 727 | + $currency = $this->common->get_field_name('currency', 'currency', $currency_id); |
|
| 728 | 728 | $query = $this->rates_model->get_termination_rate(true, '', '', false); |
| 729 | 729 | $outbound_array = array(); |
| 730 | 730 | ob_clean(); |
| 731 | - $outbound_array[] = array("Code", "Destination", "Connect Cost($currency)", "Included Seconds","Per Minute Cost($currency)","Initial Increment", "Increment","Priority","Strip","Prepend","Trunk","Status","Created Date"); |
|
| 731 | + $outbound_array[] = array("Code", "Destination", "Connect Cost($currency)", "Included Seconds", "Per Minute Cost($currency)", "Initial Increment", "Increment", "Priority", "Strip", "Prepend", "Trunk", "Status", "Created Date"); |
|
| 732 | 732 | if ($query->num_rows() > 0) { |
| 733 | 733 | |
| 734 | 734 | foreach ($query->result_array() as $row) { |
| 735 | 735 | //echo"<pre>";print_r($row);exit; |
| 736 | 736 | $outbound_array[] = array( |
| 737 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 737 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 738 | 738 | $row['comment'], |
| 739 | - $this->common_model->calculate_currency($row['connectcost'],'','',TRUE,false), |
|
| 739 | + $this->common_model->calculate_currency($row['connectcost'], '', '', TRUE, false), |
|
| 740 | 740 | |
| 741 | 741 | $row['includedseconds'], |
| 742 | - $this->common_model->calculate_currency($row['cost'],'','',TRUE,false), |
|
| 742 | + $this->common_model->calculate_currency($row['cost'], '', '', TRUE, false), |
|
| 743 | 743 | /** |
| 744 | 744 | ASTPP 3.0 |
| 745 | 745 | For Add Initial Increment field |
@@ -751,7 +751,7 @@ discard block |
||
| 751 | 751 | $row['strip'], |
| 752 | 752 | $row['prepend'], |
| 753 | 753 | //$row['trunk_id'], |
| 754 | - $this->common->get_field_name('name','trunks',$row["trunk_id"]), |
|
| 754 | + $this->common->get_field_name('name', 'trunks', $row["trunk_id"]), |
|
| 755 | 755 | $this->common->get_status('export', '', $row['status']), |
| 756 | 756 | $row['creation_date'], |
| 757 | 757 | |
@@ -760,7 +760,7 @@ discard block |
||
| 760 | 760 | } |
| 761 | 761 | $this->load->helper('csv'); |
| 762 | 762 | |
| 763 | - array_to_csv($outbound_array, 'Termination_Rates_' . date("Y-m-d") . '.csv'); |
|
| 763 | + array_to_csv($outbound_array, 'Termination_Rates_'.date("Y-m-d").'.csv'); |
|
| 764 | 764 | |
| 765 | 765 | } |
| 766 | 766 | |
@@ -771,13 +771,13 @@ discard block |
||
| 771 | 771 | $this->load->library('pdf'); |
| 772 | 772 | $this->fpdf = new PDF('P', 'pt'); |
| 773 | 773 | $this->fpdf->initialize('P', 'mm', 'A4'); |
| 774 | - $this->fpdf->tablewidths = array(20, 30, 20, 20, 20, 20, 20,20,20); |
|
| 775 | - $outbound_array[] = array("Code", "Destination", "Connect Cost","Included Seconds","Per Minute Cost","Initial Increment", "Increment","Precedence","Prepend","Strip"); |
|
| 774 | + $this->fpdf->tablewidths = array(20, 30, 20, 20, 20, 20, 20, 20, 20); |
|
| 775 | + $outbound_array[] = array("Code", "Destination", "Connect Cost", "Included Seconds", "Per Minute Cost", "Initial Increment", "Increment", "Precedence", "Prepend", "Strip"); |
|
| 776 | 776 | if ($query->num_rows() > 0) { |
| 777 | 777 | |
| 778 | 778 | foreach ($query->result_array() as $row) { |
| 779 | 779 | $outbound_array[] = array( |
| 780 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 780 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 781 | 781 | $row['comment'], |
| 782 | 782 | $row['connectcost'], |
| 783 | 783 | $row['includedseconds'], |
@@ -800,7 +800,7 @@ discard block |
||
| 800 | 800 | |
| 801 | 801 | $this->fpdf->SetFont('Arial', '', 15); |
| 802 | 802 | $this->fpdf->SetXY(60, 5); |
| 803 | - $this->fpdf->Cell(100, 10, "Outbound Rates Report " . date('Y-m-d')); |
|
| 803 | + $this->fpdf->Cell(100, 10, "Outbound Rates Report ".date('Y-m-d')); |
|
| 804 | 804 | |
| 805 | 805 | $this->fpdf->SetY(20); |
| 806 | 806 | $this->fpdf->SetFont('Arial', '', 7); |
@@ -808,29 +808,29 @@ discard block |
||
| 808 | 808 | $this->fpdf->lMargin = 2; |
| 809 | 809 | |
| 810 | 810 | $dimensions = $this->fpdf->export_pdf($outbound_array, "7"); |
| 811 | - $this->fpdf->Output('Termination_Rate_' . date("Y-m-d") . '.pdf', "D"); |
|
| 811 | + $this->fpdf->Output('Termination_Rate_'.date("Y-m-d").'.pdf', "D"); |
|
| 812 | 812 | } |
| 813 | 813 | |
| 814 | 814 | |
| 815 | 815 | function origination_rate_export_cdr_xls() { |
| 816 | 816 | $account_info = $accountinfo = $this->session->userdata('accountinfo'); |
| 817 | - $currency_id=$account_info['currency_id']; |
|
| 818 | - $currency=$this->common->get_field_name('currency', 'currency', $currency_id); |
|
| 817 | + $currency_id = $account_info['currency_id']; |
|
| 818 | + $currency = $this->common->get_field_name('currency', 'currency', $currency_id); |
|
| 819 | 819 | $query = $this->rates_model->get_origination_rate(true, '', '', false); |
| 820 | 820 | //echo "<pre>";print_r($query);exit; |
| 821 | 821 | $inbound_array = array(); |
| 822 | 822 | ob_clean(); |
| 823 | - $inbound_array[] = array("Code", "Destination","Connect Cost($currency)","Included Seconds","Per Minute Cost($currency)", "Initial Increment", "Increment","Rate Group","Status","Created Date"); |
|
| 823 | + $inbound_array[] = array("Code", "Destination", "Connect Cost($currency)", "Included Seconds", "Per Minute Cost($currency)", "Initial Increment", "Increment", "Rate Group", "Status", "Created Date"); |
|
| 824 | 824 | if ($query->num_rows() > 0) { |
| 825 | 825 | |
| 826 | 826 | foreach ($query->result_array() as $row) { |
| 827 | 827 | //echo"<pre>";print_r($row);exit; |
| 828 | 828 | $inbound_array[] = array( |
| 829 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 829 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 830 | 830 | $row['comment'], |
| 831 | - $this->common_model->calculate_currency($row['connectcost'],'','',TRUE,false), |
|
| 831 | + $this->common_model->calculate_currency($row['connectcost'], '', '', TRUE, false), |
|
| 832 | 832 | $row['includedseconds'], |
| 833 | - $this->common_model->calculate_currency($row['cost'],'','',TRUE,false), |
|
| 833 | + $this->common_model->calculate_currency($row['cost'], '', '', TRUE, false), |
|
| 834 | 834 | /** |
| 835 | 835 | ASTPP 3.0 |
| 836 | 836 | For Add Initial Increment field |
@@ -846,7 +846,7 @@ discard block |
||
| 846 | 846 | } |
| 847 | 847 | } |
| 848 | 848 | $this->load->helper('csv'); |
| 849 | - array_to_csv($inbound_array, 'Origination_Rates_' . date("Y-m-d") . '.csv'); |
|
| 849 | + array_to_csv($inbound_array, 'Origination_Rates_'.date("Y-m-d").'.csv'); |
|
| 850 | 850 | } |
| 851 | 851 | function origination_rate_export_cdr_pdf() { |
| 852 | 852 | $query = $this->rates_model->get_origination_rate(true, '', '', false); |
@@ -857,15 +857,15 @@ discard block |
||
| 857 | 857 | $this->fpdf = new PDF('P', 'pt'); |
| 858 | 858 | $this->fpdf->initialize('P', 'mm', 'A4'); |
| 859 | 859 | $this->fpdf->tablewidths = array(20, 20, 20, 20, 20, 20); |
| 860 | - $inbound_array[] = array("Code", "Destination","Connect Cost","Included Seconds","Per Minute Cost","Initial Increment","Increment"); |
|
| 860 | + $inbound_array[] = array("Code", "Destination", "Connect Cost", "Included Seconds", "Per Minute Cost", "Initial Increment", "Increment"); |
|
| 861 | 861 | if ($query->num_rows() > 0) { |
| 862 | 862 | foreach ($query->result_array() as $row) { |
| 863 | 863 | $inbound_array[] = array( |
| 864 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 864 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 865 | 865 | $row['comment'], |
| 866 | 866 | $row['connectcost'], |
| 867 | 867 | $row['includedseconds'], |
| 868 | - $this->common_model->calculate_currency($row['cost'],'','','',false), |
|
| 868 | + $this->common_model->calculate_currency($row['cost'], '', '', '', false), |
|
| 869 | 869 | /** |
| 870 | 870 | ASTPP 3.0 |
| 871 | 871 | For Add Initial Increment field |
@@ -881,7 +881,7 @@ discard block |
||
| 881 | 881 | |
| 882 | 882 | $this->fpdf->SetFont('Arial', '', 15); |
| 883 | 883 | $this->fpdf->SetXY(60, 5); |
| 884 | - $this->fpdf->Cell(100, 10, "Origination Rates Report " . date('Y-m-d')); |
|
| 884 | + $this->fpdf->Cell(100, 10, "Origination Rates Report ".date('Y-m-d')); |
|
| 885 | 885 | |
| 886 | 886 | $this->fpdf->SetY(20); |
| 887 | 887 | $this->fpdf->SetFont('Arial', '', 7); |
@@ -889,7 +889,7 @@ discard block |
||
| 889 | 889 | $this->fpdf->lMargin = 2; |
| 890 | 890 | |
| 891 | 891 | $dimensions = $this->fpdf->export_pdf($inbound_array, "5"); |
| 892 | - $this->fpdf->Output('Origination_Rate_' . date("Y-m-d") . '.pdf', "D"); |
|
| 892 | + $this->fpdf->Output('Origination_Rate_'.date("Y-m-d").'.pdf', "D"); |
|
| 893 | 893 | } |
| 894 | 894 | |
| 895 | 895 | |
@@ -901,14 +901,14 @@ discard block |
||
| 901 | 901 | $this->fpdf = new PDF('P', 'pt'); |
| 902 | 902 | $this->fpdf->initialize('P', 'mm', 'A4'); |
| 903 | 903 | $this->fpdf->tablewidths = array(20, 20, 20, 20, 20, 20); |
| 904 | - $inbound_array[] = array("Code", "Destination", "Increment","Cost Per Minutes", "Connect Charge", "Included Seconds"); |
|
| 904 | + $inbound_array[] = array("Code", "Destination", "Increment", "Cost Per Minutes", "Connect Charge", "Included Seconds"); |
|
| 905 | 905 | if ($query->num_rows() > 0) { |
| 906 | 906 | foreach ($query->result_array() as $row) { |
| 907 | 907 | $inbound_array[] = array( |
| 908 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 908 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 909 | 909 | $row['comment'], |
| 910 | 910 | $row['inc'], |
| 911 | - $this->common_model->calculate_currency($row['cost'],'','','',false), |
|
| 911 | + $this->common_model->calculate_currency($row['cost'], '', '', '', false), |
|
| 912 | 912 | $row['connectcost'], |
| 913 | 913 | $row['includedseconds'] |
| 914 | 914 | ); |
@@ -920,7 +920,7 @@ discard block |
||
| 920 | 920 | |
| 921 | 921 | $this->fpdf->SetFont('Arial', '', 15); |
| 922 | 922 | $this->fpdf->SetXY(60, 5); |
| 923 | - $this->fpdf->Cell(100, 10, "Rates Report " . date('Y-m-d')); |
|
| 923 | + $this->fpdf->Cell(100, 10, "Rates Report ".date('Y-m-d')); |
|
| 924 | 924 | |
| 925 | 925 | $this->fpdf->SetY(20); |
| 926 | 926 | $this->fpdf->SetFont('Arial', '', 7); |
@@ -928,12 +928,12 @@ discard block |
||
| 928 | 928 | $this->fpdf->lMargin = 2; |
| 929 | 929 | |
| 930 | 930 | $dimensions = $this->fpdf->export_pdf($inbound_array, "5"); |
| 931 | - $this->fpdf->Output('Rates_' . date("Y-m-d") . '.pdf', "D"); |
|
| 931 | + $this->fpdf->Output('Rates_'.date("Y-m-d").'.pdf', "D"); |
|
| 932 | 932 | } |
| 933 | - function resellersrates_list(){ |
|
| 934 | - $accountinfo=$this->session->userdata('accountinfo'); |
|
| 933 | + function resellersrates_list() { |
|
| 934 | + $accountinfo = $this->session->userdata('accountinfo'); |
|
| 935 | 935 | $data['username'] = $this->session->userdata('user_name'); |
| 936 | - $data['page_title'] = 'My Rates' ; |
|
| 936 | + $data['page_title'] = 'My Rates'; |
|
| 937 | 937 | $data['search_flag'] = true; |
| 938 | 938 | $this->session->set_userdata('advance_search', 0); |
| 939 | 939 | $data['grid_fields'] = $this->rates_form->build_rates_list_for_reseller(); |
@@ -953,11 +953,11 @@ discard block |
||
| 953 | 953 | $grid_fields = json_decode($this->rates_form->build_rates_list_for_reseller()); |
| 954 | 954 | foreach ($query->result_array() as $key => $value) { |
| 955 | 955 | $json_data['rows'][] = array('cell' => array( |
| 956 | - $this->common->get_only_numeric_val("","",$value["pattern"]), |
|
| 956 | + $this->common->get_only_numeric_val("", "", $value["pattern"]), |
|
| 957 | 957 | $value['comment'], |
| 958 | - $this->common_model->calculate_currency($value['connectcost'],'','','true',true), |
|
| 958 | + $this->common_model->calculate_currency($value['connectcost'], '', '', 'true', true), |
|
| 959 | 959 | $value['includedseconds'], |
| 960 | - $this->common_model->calculate_currency(($value['cost'] + ($value['cost']*$markup)/100),'','','true',true), |
|
| 960 | + $this->common_model->calculate_currency(($value['cost'] + ($value['cost'] * $markup) / 100), '', '', 'true', true), |
|
| 961 | 961 | $value['inc'], |
| 962 | 962 | $value['precedence'], |
| 963 | 963 | )); |
@@ -977,7 +977,7 @@ discard block |
||
| 977 | 977 | $this->session->set_userdata('resellerrates_list_search', $action); |
| 978 | 978 | } |
| 979 | 979 | if (@$ajax_search != 1) { |
| 980 | - redirect(base_url() . 'rates/resellersrates_list/'); |
|
| 980 | + redirect(base_url().'rates/resellersrates_list/'); |
|
| 981 | 981 | } |
| 982 | 982 | } |
| 983 | 983 | function resellersrates_list_clearsearchfilter() { |
@@ -1001,7 +1001,7 @@ discard block |
||
| 1001 | 1001 | foreach ($query->result_array() as $row) { |
| 1002 | 1002 | |
| 1003 | 1003 | $customer_array[] = array( |
| 1004 | - $row['pattern']=$this->common->get_only_numeric_val("","",$row["pattern"]), |
|
| 1004 | + $row['pattern'] = $this->common->get_only_numeric_val("", "", $row["pattern"]), |
|
| 1005 | 1005 | $row['comment'], |
| 1006 | 1006 | $row['connectcost'], |
| 1007 | 1007 | $row['includedseconds'], |
@@ -1013,7 +1013,7 @@ discard block |
||
| 1013 | 1013 | } |
| 1014 | 1014 | } |
| 1015 | 1015 | $this->load->helper('csv'); |
| 1016 | - array_to_csv($customer_array, 'My_Own_Rate_' . date("Y-m-d") . '.csv'); |
|
| 1016 | + array_to_csv($customer_array, 'My_Own_Rate_'.date("Y-m-d").'.csv'); |
|
| 1017 | 1017 | exit; |
| 1018 | 1018 | } |
| 1019 | 1019 | /*********** |
@@ -1030,7 +1030,7 @@ discard block |
||
| 1030 | 1030 | $this->session->set_userdata('termination_rates_list_search', $action); |
| 1031 | 1031 | } |
| 1032 | 1032 | if (@$ajax_search != 1) { |
| 1033 | - redirect(base_url() . 'rates/termination_rates_list/'); |
|
| 1033 | + redirect(base_url().'rates/termination_rates_list/'); |
|
| 1034 | 1034 | } |
| 1035 | 1035 | } |
| 1036 | 1036 | function origination_rates_list_batch_delete() { |
@@ -1043,7 +1043,7 @@ discard block |
||
| 1043 | 1043 | $this->session->set_userdata('origination_rate_list_search', $action); |
| 1044 | 1044 | } |
| 1045 | 1045 | if (@$ajax_search != 1) { |
| 1046 | - redirect(base_url() . 'rates/origination_rates_list/'); |
|
| 1046 | + redirect(base_url().'rates/origination_rates_list/'); |
|
| 1047 | 1047 | } |
| 1048 | 1048 | } |
| 1049 | 1049 | |
@@ -1059,14 +1059,14 @@ discard block |
||
| 1059 | 1059 | |
| 1060 | 1060 | function csv_to_array($filename = '', $delimiter = ',') |
| 1061 | 1061 | { |
| 1062 | - if (!file_exists($filename) || !is_readable($filename)) return FALSE; |
|
| 1062 | + if ( ! file_exists($filename) || ! is_readable($filename)) return FALSE; |
|
| 1063 | 1063 | $header = NULL; |
| 1064 | 1064 | $data = array(); |
| 1065 | 1065 | if (($handle = fopen($filename, 'r')) !== FALSE) |
| 1066 | 1066 | { |
| 1067 | 1067 | while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
| 1068 | 1068 | { |
| 1069 | - if (!$header) $header = $row; |
|
| 1069 | + if ( ! $header) $header = $row; |
|
| 1070 | 1070 | else $data[] = array_combine($header, $row); |
| 1071 | 1071 | } |
| 1072 | 1072 | |
@@ -1079,9 +1079,9 @@ discard block |
||
| 1079 | 1079 | function utf8_converter($array) |
| 1080 | 1080 | { |
| 1081 | 1081 | array_walk_recursive($array, |
| 1082 | - function (&$item, $key) |
|
| 1082 | + function(&$item, $key) |
|
| 1083 | 1083 | { |
| 1084 | - if (!mb_detect_encoding($item, 'utf-8', true)) |
|
| 1084 | + if ( ! mb_detect_encoding($item, 'utf-8', true)) |
|
| 1085 | 1085 | { |
| 1086 | 1086 | $item = utf8_encode($item); |
| 1087 | 1087 | } |
@@ -1095,9 +1095,9 @@ discard block |
||
| 1095 | 1095 | $check_header = $this->input->post('check_header', true); |
| 1096 | 1096 | $data['page_title'] = 'Import Termination Rates'; |
| 1097 | 1097 | $new_final_arr_key = $this->config->item('Termination-rates-field'); |
| 1098 | - if (empty($_FILES) || !isset($_FILES)) |
|
| 1098 | + if (empty($_FILES) || ! isset($_FILES)) |
|
| 1099 | 1099 | { |
| 1100 | - redirect(base_url() . "rates/termination_rates_list/"); |
|
| 1100 | + redirect(base_url()."rates/termination_rates_list/"); |
|
| 1101 | 1101 | } |
| 1102 | 1102 | |
| 1103 | 1103 | $data['mapto_fields'] = $new_final_arr_key; |
@@ -1117,13 +1117,13 @@ discard block |
||
| 1117 | 1117 | // $csv_data = $this->csvreader->parse_file($uploadedFile, $new_final_arr_key, $check_header); |
| 1118 | 1118 | |
| 1119 | 1119 | $csv_data = $this->utf8_converter($this->csvreader->parse_file($uploadedFile, $field_select, $check_header)); |
| 1120 | - if (!empty($csv_data)) |
|
| 1120 | + if ( ! empty($csv_data)) |
|
| 1121 | 1121 | { |
| 1122 | 1122 | $full_path = $this->config->item('rates-file-path'); |
| 1123 | - $actual_file_name = "ASTPP-TERMINATION-RATES-" . date("Y-m-d H:i:s") . "." . $ext; |
|
| 1123 | + $actual_file_name = "ASTPP-TERMINATION-RATES-".date("Y-m-d H:i:s").".".$ext; |
|
| 1124 | 1124 | $actual_file_name = str_replace(' ', '-', $actual_file_name); |
| 1125 | 1125 | $actual_file_name = str_replace(':', '-', $actual_file_name); |
| 1126 | - if (move_uploaded_file($uploadedFile, $full_path . $actual_file_name)) |
|
| 1126 | + if (move_uploaded_file($uploadedFile, $full_path.$actual_file_name)) |
|
| 1127 | 1127 | { |
| 1128 | 1128 | $data['field_select'] = serialize($field_select); |
| 1129 | 1129 | $data['csv_tmp_data'] = $csv_data; |
@@ -1157,14 +1157,14 @@ discard block |
||
| 1157 | 1157 | if ($invalid_flag) |
| 1158 | 1158 | { |
| 1159 | 1159 | $str = ''; |
| 1160 | - if (!isset($_POST['trunk_id']) || empty($_POST['trunk_id'])) |
|
| 1160 | + if ( ! isset($_POST['trunk_id']) || empty($_POST['trunk_id'])) |
|
| 1161 | 1161 | { |
| 1162 | - $str.= '<br/>Please Create Trunk.'; |
|
| 1162 | + $str .= '<br/>Please Create Trunk.'; |
|
| 1163 | 1163 | } |
| 1164 | 1164 | |
| 1165 | 1165 | if (empty($_FILES['termination_rate_import_mapper']['name'])) |
| 1166 | 1166 | { |
| 1167 | - $str.= '<br/>Please Select File.'; |
|
| 1167 | + $str .= '<br/>Please Select File.'; |
|
| 1168 | 1168 | } |
| 1169 | 1169 | |
| 1170 | 1170 | $data['error'] = $str; |
@@ -1185,7 +1185,7 @@ discard block |
||
| 1185 | 1185 | $new_final_arr = array(); |
| 1186 | 1186 | $invalid_array = array(); |
| 1187 | 1187 | $new_final_arr_key = array(); |
| 1188 | - foreach($filefields as $item) |
|
| 1188 | + foreach ($filefields as $item) |
|
| 1189 | 1189 | { |
| 1190 | 1190 | $new_final_arr_key[$item] = $item; |
| 1191 | 1191 | } |
@@ -1199,30 +1199,30 @@ discard block |
||
| 1199 | 1199 | |
| 1200 | 1200 | $full_path = $this->config->item('rates-file-path'); |
| 1201 | 1201 | $terminationrate_file_name = $this->session->userdata('import_termination_rate_mapper_csv'); |
| 1202 | - $csv_tmp_data = $this->csvreader->parse_file($full_path . $terminationrate_file_name, $new_final_arr_key, $check_header); |
|
| 1202 | + $csv_tmp_data = $this->csvreader->parse_file($full_path.$terminationrate_file_name, $new_final_arr_key, $check_header); |
|
| 1203 | 1203 | $i = 0; |
| 1204 | - foreach($csv_tmp_data as $key => $csv_data) |
|
| 1204 | + foreach ($csv_tmp_data as $key => $csv_data) |
|
| 1205 | 1205 | { |
| 1206 | - if (isset($csv_data[$this->input->post("pattern-select") ]) && $csv_data[$this->input->post("pattern-select") ] != '' && $i != 0) |
|
| 1206 | + if (isset($csv_data[$this->input->post("pattern-select")]) && $csv_data[$this->input->post("pattern-select")] != '' && $i != 0) |
|
| 1207 | 1207 | { |
| 1208 | 1208 | $str = null; |
| 1209 | - $csv_data['pattern'] = ($this->input->post("pattern-prefix")) ? $this->input->post("pattern-prefix") . $csv_data[$this->input->post("pattern-select") ] : $csv_data[$this->input->post("pattern-select") ]; |
|
| 1210 | - $csv_data['cost'] = ($this->input->post("cost-select")) ? $csv_data[$this->input->post("cost-select") ] : ""; |
|
| 1211 | - $csv_data['cost'] = ($this->input->post("cost-prefix")) ? $this->input->post("cost-prefix") . $csv_data['cost'] : $csv_data['cost']; |
|
| 1212 | - $csv_data['prepend'] = ($this->input->post("prepend-select")) ? $csv_data[$this->input->post("prepend-select") ] : ""; |
|
| 1213 | - $csv_data['prepend'] = ($this->input->post("prepend-prefix")) ? $this->input->post("prepend-prefix") . $csv_data['prepend'] : $csv_data['prepend']; |
|
| 1214 | - $csv_data['comment'] = ($this->input->post("comment-select")) ? $csv_data[$this->input->post("comment-select") ] : ""; |
|
| 1215 | - $csv_data['comment'] = ($this->input->post("comment-prefix")) ? $this->input->post("comment-prefix") . $csv_data['comment'] : $csv_data['comment']; |
|
| 1216 | - $csv_data['connectcost'] = ($this->input->post("connectcost-select")) ? $csv_data[$this->input->post("connectcost-select") ] : "0"; |
|
| 1217 | - $csv_data['connectcost'] = ($this->input->post("connectcost-prefix")) ? $this->input->post("connectcost-prefix") . $csv_data['connectcost'] : $csv_data['connectcost']; |
|
| 1218 | - $csv_data['includedseconds'] = ($this->input->post("includedseconds-select")) ? $csv_data[$this->input->post("includedseconds-select") ] : "0"; |
|
| 1219 | - $csv_data['includedseconds'] = ($this->input->post("includedseconds-prefix")) ? $this->input->post("includedseconds-prefix") . $csv_data['includedseconds'] : $csv_data['includedseconds']; |
|
| 1220 | - $csv_data['inc'] = ($this->input->post("inc-select")) ? $csv_data[$this->input->post("inc-select") ] : "0"; |
|
| 1221 | - $csv_data['inc'] = ($this->input->post("inc-prefix")) ? $this->input->post("inc-prefix") . $csv_data['inc'] : $csv_data['inc']; |
|
| 1222 | - $csv_data['precedence'] = ($this->input->post("precedence-select")) ? $csv_data[$this->input->post("precedence-select") ] : ""; |
|
| 1223 | - $csv_data['precedence'] = ($this->input->post("precedence-prefix")) ? $this->input->post("precedence-prefix") . $csv_data['precedence'] : $csv_data['precedence']; |
|
| 1224 | - $csv_data['strip'] = ($this->input->post("strip-select")) ? $csv_data[$this->input->post("strip-select") ] : ""; |
|
| 1225 | - $csv_data['strip'] = ($this->input->post("strip-prefix")) ? $this->input->post("strip-prefix") . $csv_data['strip'] : $csv_data['strip']; |
|
| 1209 | + $csv_data['pattern'] = ($this->input->post("pattern-prefix")) ? $this->input->post("pattern-prefix").$csv_data[$this->input->post("pattern-select")] : $csv_data[$this->input->post("pattern-select")]; |
|
| 1210 | + $csv_data['cost'] = ($this->input->post("cost-select")) ? $csv_data[$this->input->post("cost-select")] : ""; |
|
| 1211 | + $csv_data['cost'] = ($this->input->post("cost-prefix")) ? $this->input->post("cost-prefix").$csv_data['cost'] : $csv_data['cost']; |
|
| 1212 | + $csv_data['prepend'] = ($this->input->post("prepend-select")) ? $csv_data[$this->input->post("prepend-select")] : ""; |
|
| 1213 | + $csv_data['prepend'] = ($this->input->post("prepend-prefix")) ? $this->input->post("prepend-prefix").$csv_data['prepend'] : $csv_data['prepend']; |
|
| 1214 | + $csv_data['comment'] = ($this->input->post("comment-select")) ? $csv_data[$this->input->post("comment-select")] : ""; |
|
| 1215 | + $csv_data['comment'] = ($this->input->post("comment-prefix")) ? $this->input->post("comment-prefix").$csv_data['comment'] : $csv_data['comment']; |
|
| 1216 | + $csv_data['connectcost'] = ($this->input->post("connectcost-select")) ? $csv_data[$this->input->post("connectcost-select")] : "0"; |
|
| 1217 | + $csv_data['connectcost'] = ($this->input->post("connectcost-prefix")) ? $this->input->post("connectcost-prefix").$csv_data['connectcost'] : $csv_data['connectcost']; |
|
| 1218 | + $csv_data['includedseconds'] = ($this->input->post("includedseconds-select")) ? $csv_data[$this->input->post("includedseconds-select")] : "0"; |
|
| 1219 | + $csv_data['includedseconds'] = ($this->input->post("includedseconds-prefix")) ? $this->input->post("includedseconds-prefix").$csv_data['includedseconds'] : $csv_data['includedseconds']; |
|
| 1220 | + $csv_data['inc'] = ($this->input->post("inc-select")) ? $csv_data[$this->input->post("inc-select")] : "0"; |
|
| 1221 | + $csv_data['inc'] = ($this->input->post("inc-prefix")) ? $this->input->post("inc-prefix").$csv_data['inc'] : $csv_data['inc']; |
|
| 1222 | + $csv_data['precedence'] = ($this->input->post("precedence-select")) ? $csv_data[$this->input->post("precedence-select")] : ""; |
|
| 1223 | + $csv_data['precedence'] = ($this->input->post("precedence-prefix")) ? $this->input->post("precedence-prefix").$csv_data['precedence'] : $csv_data['precedence']; |
|
| 1224 | + $csv_data['strip'] = ($this->input->post("strip-select")) ? $csv_data[$this->input->post("strip-select")] : ""; |
|
| 1225 | + $csv_data['strip'] = ($this->input->post("strip-prefix")) ? $this->input->post("strip-prefix").$csv_data['strip'] : $csv_data['strip']; |
|
| 1226 | 1226 | $csv_data['last_modified_date'] = date("Y-m-d H:i:s"); |
| 1227 | 1227 | $str = $this->data_validate($csv_data); |
| 1228 | 1228 | if ($str != "") |
@@ -1233,13 +1233,13 @@ discard block |
||
| 1233 | 1233 | else |
| 1234 | 1234 | { |
| 1235 | 1235 | $new_final_arr[$i]['trunk_id'] = $trunkID; |
| 1236 | - $new_final_arr[$i]['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
|
| 1236 | + $new_final_arr[$i]['pattern'] = "^".$csv_data['pattern'].".*"; |
|
| 1237 | 1237 | $new_final_arr[$i]['prepend'] = $csv_data['prepend']; |
| 1238 | 1238 | $new_final_arr[$i]['last_modified_date'] = $csv_data['last_modified_date']; |
| 1239 | 1239 | $new_final_arr[$i]['comment'] = $csv_data['comment']; |
| 1240 | 1240 | $new_final_arr[$i]['connectcost'] = $csv_data['connectcost']; |
| 1241 | 1241 | $new_final_arr[$i]['includedseconds'] = $csv_data['includedseconds']; |
| 1242 | - $new_final_arr[$i]['cost'] = !empty($csv_data['cost']) && is_numeric($csv_data['cost']) ? $csv_data['cost'] : 0; |
|
| 1242 | + $new_final_arr[$i]['cost'] = ! empty($csv_data['cost']) && is_numeric($csv_data['cost']) ? $csv_data['cost'] : 0; |
|
| 1243 | 1243 | $new_final_arr[$i]['inc'] = isset($csv_data['inc']) ? $csv_data['inc'] : 0; |
| 1244 | 1244 | $new_final_arr[$i]['precedence'] = isset($csv_data['precedence']) ? $csv_data['precedence'] : ''; |
| 1245 | 1245 | $new_final_arr[$i]['strip'] = isset($csv_data['strip']) ? $csv_data['strip'] : ''; |
@@ -1249,7 +1249,7 @@ discard block |
||
| 1249 | 1249 | $i++; |
| 1250 | 1250 | } |
| 1251 | 1251 | |
| 1252 | - if (!empty($new_final_arr)) |
|
| 1252 | + if ( ! empty($new_final_arr)) |
|
| 1253 | 1253 | { |
| 1254 | 1254 | $result = $this->rates_model->bulk_insert_termination_rate($new_final_arr); |
| 1255 | 1255 | } |
@@ -1257,29 +1257,29 @@ discard block |
||
| 1257 | 1257 | { |
| 1258 | 1258 | |
| 1259 | 1259 | $this->session->set_flashdata('astpp_errormsg', 'Error - Nothing selected to import/process!'); |
| 1260 | - redirect(base_url() . 'rates/termination_rates_list/'); |
|
| 1260 | + redirect(base_url().'rates/termination_rates_list/'); |
|
| 1261 | 1261 | } |
| 1262 | 1262 | |
| 1263 | - unlink($full_path . $terminationrate_file_name); |
|
| 1263 | + unlink($full_path.$terminationrate_file_name); |
|
| 1264 | 1264 | $count = count($invalid_array); |
| 1265 | 1265 | if ($count > 0) |
| 1266 | 1266 | { |
| 1267 | 1267 | $session_id = "-1"; |
| 1268 | - $fp = fopen($full_path . $session_id . '.csv', 'w'); |
|
| 1269 | - foreach($new_final_arr_key as $key => $value) |
|
| 1268 | + $fp = fopen($full_path.$session_id.'.csv', 'w'); |
|
| 1269 | + foreach ($new_final_arr_key as $key => $value) |
|
| 1270 | 1270 | { |
| 1271 | 1271 | $custom_array[0][$key] = ucfirst($key); |
| 1272 | 1272 | } |
| 1273 | 1273 | |
| 1274 | 1274 | $custom_array[0]['error'] = "Error"; |
| 1275 | 1275 | $invalid_array = array_merge($custom_array, $invalid_array); |
| 1276 | - foreach($invalid_array as $err_data) |
|
| 1276 | + foreach ($invalid_array as $err_data) |
|
| 1277 | 1277 | { |
| 1278 | 1278 | fputcsv($fp, $err_data); |
| 1279 | 1279 | } |
| 1280 | 1280 | |
| 1281 | 1281 | fclose($fp); |
| 1282 | - $this->session->set_userdata('import_termination_rate_mapper_csv_error', $session_id . ".csv"); |
|
| 1282 | + $this->session->set_userdata('import_termination_rate_mapper_csv_error', $session_id.".csv"); |
|
| 1283 | 1283 | $data["error"] = $invalid_array; |
| 1284 | 1284 | $data['trunkid'] = $trunkID; |
| 1285 | 1285 | $data['impoted_count'] = count($new_final_arr); |
@@ -1289,8 +1289,8 @@ discard block |
||
| 1289 | 1289 | } |
| 1290 | 1290 | else |
| 1291 | 1291 | { |
| 1292 | - $this->session->set_flashdata('astpp_errormsg', 'Total ' . count($new_final_arr) . ' Termination rates imported successfully!'); |
|
| 1293 | - redirect(base_url() . "rates/termination_rate_list/"); |
|
| 1292 | + $this->session->set_flashdata('astpp_errormsg', 'Total '.count($new_final_arr).' Termination rates imported successfully!'); |
|
| 1293 | + redirect(base_url()."rates/termination_rate_list/"); |
|
| 1294 | 1294 | } |
| 1295 | 1295 | } |
| 1296 | 1296 | |
@@ -35,8 +35,9 @@ discard block |
||
| 35 | 35 | ini_set("memory_limit", "2048M"); |
| 36 | 36 | ini_set("max_execution_time", "259200"); |
| 37 | 37 | ini_set("upload_max_filesize", "200M"); |
| 38 | - if ($this->session->userdata('user_login') == FALSE) |
|
| 39 | - redirect(base_url() . '/astpp/login'); |
|
| 38 | + if ($this->session->userdata('user_login') == FALSE) { |
|
| 39 | + redirect(base_url() . '/astpp/login'); |
|
| 40 | + } |
|
| 40 | 41 | } |
| 41 | 42 | |
| 42 | 43 | function termination_rates_list() { |
@@ -110,18 +111,17 @@ discard block |
||
| 110 | 111 | $data['check_header']=$check_header; |
| 111 | 112 | $data['page_title'] = 'Termination Rates Preview'; |
| 112 | 113 | $this->session->set_userdata('import_termination_rate_csv',$actual_file_name); |
| 113 | - }else{ |
|
| 114 | + } else{ |
|
| 114 | 115 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 115 | 116 | } |
| 116 | 117 | } |
| 117 | - } |
|
| 118 | - else{ |
|
| 118 | + } else{ |
|
| 119 | 119 | $data['error']=="File Uploading Fail Please Try Again"; |
| 120 | 120 | } |
| 121 | - }else { |
|
| 121 | + } else { |
|
| 122 | 122 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 123 | 123 | } |
| 124 | - }else{ |
|
| 124 | + } else{ |
|
| 125 | 125 | $invalid_flag=true; |
| 126 | 126 | } |
| 127 | 127 | if ($invalid_flag) { |
@@ -164,8 +164,7 @@ discard block |
||
| 164 | 164 | if($str != ""){ |
| 165 | 165 | $invalid_array[$i]=$csv_data; |
| 166 | 166 | $invalid_array[$i]['error'] = $str; |
| 167 | - } |
|
| 168 | - else{ |
|
| 167 | + } else{ |
|
| 169 | 168 | $csv_data['trunk_id']=$trunkID; |
| 170 | 169 | $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
| 171 | 170 | $new_final_arr[$i]=$csv_data; |
@@ -253,19 +252,17 @@ discard block |
||
| 253 | 252 | $data['page_title'] = "Origination Rates Preview"; |
| 254 | 253 | $data['check_header']=$check_header; |
| 255 | 254 | $this->session->set_userdata('import_origination_rate_csv',$actual_file_name); |
| 256 | - }else{ |
|
| 255 | + } else{ |
|
| 257 | 256 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 258 | 257 | } |
| 259 | 258 | } |
| 260 | - } |
|
| 261 | - else{ |
|
| 259 | + } else{ |
|
| 262 | 260 | $data['error']=="File Uploading Fail Please Try Again"; |
| 263 | 261 | } |
| 264 | - } |
|
| 265 | - else { |
|
| 262 | + } else { |
|
| 266 | 263 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 267 | 264 | } |
| 268 | - }else{ |
|
| 265 | + } else{ |
|
| 269 | 266 | $invalid_flag=true; |
| 270 | 267 | } |
| 271 | 268 | if ($invalid_flag) { |
@@ -309,8 +306,7 @@ discard block |
||
| 309 | 306 | if($str != ""){ |
| 310 | 307 | $invalid_array[$i]=$csv_data; |
| 311 | 308 | $invalid_array[$i]['error'] = $str; |
| 312 | - } |
|
| 313 | - else{ |
|
| 309 | + } else{ |
|
| 314 | 310 | $csv_data['pricelist_id']=$pricelistID; |
| 315 | 311 | $csv_data['trunk_id']=$trunkid; |
| 316 | 312 | $csv_data['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
@@ -372,12 +368,10 @@ discard block |
||
| 372 | 368 | $count = count($error_field); |
| 373 | 369 | $str.= $count > 1 ? ' are not valid' : ' is not Valid'; |
| 374 | 370 | return $str; |
| 375 | - } |
|
| 376 | - else{ |
|
| 371 | + } else{ |
|
| 377 | 372 | return false; |
| 378 | 373 | } |
| 379 | - } |
|
| 380 | - else{ |
|
| 374 | + } else{ |
|
| 381 | 375 | $str=rtrim($str,','); |
| 382 | 376 | $error_field=explode(',',$str); |
| 383 | 377 | $count = count($error_field); |
@@ -618,13 +612,15 @@ discard block |
||
| 618 | 612 | $where = array('accountid' => $accountid); |
| 619 | 613 | $instant_search=$this->session->userdata('left_panel_search_'.$accounttype.'_pattern'); |
| 620 | 614 | $like_str=!empty($instant_search) ? "(blocked_patterns like '%$instant_search%' OR destination like '%$instant_search%' )" :null; |
| 621 | - if(!empty($like_str)) |
|
| 622 | - $this->db->where($like_str); |
|
| 615 | + if(!empty($like_str)) { |
|
| 616 | + $this->db->where($like_str); |
|
| 617 | + } |
|
| 623 | 618 | $count_all = $this->db_model->countQuery("*", "block_patterns", $where); |
| 624 | 619 | $paging_data = $this->form->load_grid_config($count_all, $_GET['rp'], $_GET['page']); |
| 625 | 620 | $json_data = $paging_data["json_paging"]; |
| 626 | - if(!empty($like_str)) |
|
| 627 | - $this->db->where($like_str); |
|
| 621 | + if(!empty($like_str)) { |
|
| 622 | + $this->db->where($like_str); |
|
| 623 | + } |
|
| 628 | 624 | $pattern_data = $this->db_model->getSelect("*", "block_patterns", $where, "id", "ASC", $paging_data["paging"]["page_no"], $paging_data["paging"]["start"]); |
| 629 | 625 | $grid_fields = json_decode($this->rates_form->build_pattern_list_for_customer($accountid,$accounttype)); |
| 630 | 626 | $json_data['rows'] = $this->form->build_grid($pattern_data, $grid_fields); |
@@ -1059,15 +1055,20 @@ discard block |
||
| 1059 | 1055 | |
| 1060 | 1056 | function csv_to_array($filename = '', $delimiter = ',') |
| 1061 | 1057 | { |
| 1062 | - if (!file_exists($filename) || !is_readable($filename)) return FALSE; |
|
| 1058 | + if (!file_exists($filename) || !is_readable($filename)) { |
|
| 1059 | + return FALSE; |
|
| 1060 | + } |
|
| 1063 | 1061 | $header = NULL; |
| 1064 | 1062 | $data = array(); |
| 1065 | 1063 | if (($handle = fopen($filename, 'r')) !== FALSE) |
| 1066 | 1064 | { |
| 1067 | 1065 | while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
| 1068 | 1066 | { |
| 1069 | - if (!$header) $header = $row; |
|
| 1070 | - else $data[] = array_combine($header, $row); |
|
| 1067 | + if (!$header) { |
|
| 1068 | + $header = $row; |
|
| 1069 | + } else { |
|
| 1070 | + $data[] = array_combine($header, $row); |
|
| 1071 | + } |
|
| 1071 | 1072 | } |
| 1072 | 1073 | |
| 1073 | 1074 | fclose($handle); |
@@ -1131,25 +1132,21 @@ discard block |
||
| 1131 | 1132 | $data['check_header'] = $check_header; |
| 1132 | 1133 | $data['page_title'] = 'Map CSV to Termination Rates'; |
| 1133 | 1134 | $this->session->set_userdata('import_termination_rate_mapper_csv', $actual_file_name); |
| 1134 | - } |
|
| 1135 | - else |
|
| 1135 | + } else |
|
| 1136 | 1136 | { |
| 1137 | 1137 | $data['error'] = "File Uploading Fail Please Try Again"; |
| 1138 | 1138 | } |
| 1139 | 1139 | } |
| 1140 | - } |
|
| 1141 | - else |
|
| 1140 | + } else |
|
| 1142 | 1141 | { |
| 1143 | 1142 | $data['error'] == "File Uploading Fail Please Try Again"; |
| 1144 | 1143 | } |
| 1145 | - } |
|
| 1146 | - else |
|
| 1144 | + } else |
|
| 1147 | 1145 | { |
| 1148 | 1146 | $data['error'] = "Invalid file format : Only CSV file allows to import records(Can't import empty file)"; |
| 1149 | 1147 | $data['error'] = var_dump($_FILES); |
| 1150 | 1148 | } |
| 1151 | - } |
|
| 1152 | - else |
|
| 1149 | + } else |
|
| 1153 | 1150 | { |
| 1154 | 1151 | $invalid_flag = true; |
| 1155 | 1152 | } |
@@ -1229,8 +1226,7 @@ discard block |
||
| 1229 | 1226 | { |
| 1230 | 1227 | $invalid_array[$i] = $csv_data; |
| 1231 | 1228 | $invalid_array[$i]['error'] = $str; |
| 1232 | - } |
|
| 1233 | - else |
|
| 1229 | + } else |
|
| 1234 | 1230 | { |
| 1235 | 1231 | $new_final_arr[$i]['trunk_id'] = $trunkID; |
| 1236 | 1232 | $new_final_arr[$i]['pattern'] = "^" . $csv_data['pattern'] . ".*"; |
@@ -1252,8 +1248,7 @@ discard block |
||
| 1252 | 1248 | if (!empty($new_final_arr)) |
| 1253 | 1249 | { |
| 1254 | 1250 | $result = $this->rates_model->bulk_insert_termination_rate($new_final_arr); |
| 1255 | - } |
|
| 1256 | - else |
|
| 1251 | + } else |
|
| 1257 | 1252 | { |
| 1258 | 1253 | |
| 1259 | 1254 | $this->session->set_flashdata('astpp_errormsg', 'Error - Nothing selected to import/process!'); |
@@ -1286,8 +1281,7 @@ discard block |
||
| 1286 | 1281 | $data['failure_count'] = count($invalid_array) - 1; |
| 1287 | 1282 | $data['page_title'] = 'Termination Rates Import Error'; |
| 1288 | 1283 | $this->load->view('view_import_error', $data); |
| 1289 | - } |
|
| 1290 | - else |
|
| 1284 | + } else |
|
| 1291 | 1285 | { |
| 1292 | 1286 | $this->session->set_flashdata('astpp_errormsg', 'Total ' . count($new_final_arr) . ' Termination rates imported successfully!'); |
| 1293 | 1287 | redirect(base_url() . "rates/termination_rate_list/"); |