- Timestamp:
- Apr 7, 2015 1:52:40 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
TabularUnified 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 }
Note: See TracChangeset
for help on using the changeset viewer.