- Timestamp:
- Apr 7, 2015 1:52:40 PM (10 years ago)
- Location:
- pro-violet-viettel/sourcecode/application/modules/frontend/controllers
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/frontend/controllers/home.php
r838 r883 181 181 182 182 public function test(){ 183 $provinces = lang('_PROVINCES_'); 184 $this->load->library("PHPExcel"); 185 $file = './assets/danhsachquanhuyen.xls'; 186 $objPHPExcel = PHPExcel_IOFactory::load($file); 187 $cell_collection = $objPHPExcel->getActiveSheet()->getCellCollection(); 188 foreach ($cell_collection as $cell) { 189 $column = $objPHPExcel->getActiveSheet()->getCell($cell)->getColumn(); 190 $row = $objPHPExcel->getActiveSheet()->getCell($cell)->getRow(); 191 $data_value = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue(); 192 193 if ($row == 1) { 194 $header[$row][$column] = $data_value; 195 } else { 196 $arr_data[$row][$column] = $data_value; 197 } 183 $aryMatch = array(); 184 $phoneNumber = '987133325'; 185 $regex = '/^[1,9][0-9]{8,9}$/'; 186 if (preg_match('/^[1,9]([0-9]{8,9})$/', $phoneNumber, $aryMatch)){ 187 $phoneNumber = "0".$phoneNumber; 188 echo $phoneNumber; 189 }else{ 190 echo "Not match"; 198 191 } 199 200 $data['header'] = $header;201 $data['values'] = $arr_data;202 203 foreach ($data['values'] as $index => $value){204 foreach ($provinces as $provinceId => $province){205 if ($value['C'] == $province) $data['values'][$index]['C'] = $provinceId;206 if ($value['B'] >= 10){207 $data['values'][$index]['B'] = "0".$value['B'];208 }else{209 $data['values'][$index]['B'] = "00".$value['B'];210 }211 }212 213 }214 215 $dt = array();216 foreach ($data['values'] as $index => $value){217 218 $dt[$index]['district_id'] = $value['B'];219 $dt[$index]['province_id'] = $value['C'];220 $dt[$index]['district_name'] = $value['D'];221 $dt[$index]['type'] = $value['E'];222 }223 //var_dump($dt);224 //$this->load->model ( 'user_model' );225 //$result = $this->user_model->insertDistrict($dt);226 //var_dump($result);227 192 } 228 193 } -
pro-violet-viettel/sourcecode/application/modules/frontend/controllers/user.php
r838 r883 449 449 public function regis_history() 450 450 { 451 $this->load->model('servicepackage_model'); 451 452 $this->load->helper('pagging'); 452 453 $us_id = $this->uri->segment(4); … … 466 467 $this->load->model('user_model'); 467 468 $result = $this->user_model->getPackagelog($data); 468 $data['total'] = $this->user_model->countPackagelogs($username); 469 $results = array(); 470 foreach($result as $re){ 471 if ($re['p_code']>0){ 472 $p_price = $this->servicepackage_model->getPackagePriceByCode($re['p_code']); 473 $re['amount'] = -$p_price; 474 } 475 array_push($results, $re); 476 } 477 $data['total'] = $this->user_model->countPackagelogs($username, $us_id); 469 478 $data['num_links'] = 2; 470 479 $data['paging_url'] = base_url() . "frontend/user/regis_history/".$us_id."/page/"; 471 480 $data['paging'] = pagging($data); 472 481 $packagelogs = array(); 473 foreach ($result as $packagelog):482 foreach ($results as $packagelog): 474 483 $packagelog['created_time'] = date('d/m/Y H:i:s', strtotime($packagelog['created_time'])); 475 484 array_push($packagelogs, $packagelog); … … 487 496 488 497 $user_info = $this->session->userdata('userInfo'); 489 if ($user_info) { 498 $admin_info = $this->session->userdata('adminInfo'); 499 if ($user_info || $admin_info) { 490 500 $result = array(); 491 501 $provinceId = $this->uri->segment(4);
Note: See TracChangeset
for help on using the changeset viewer.