Changeset 838 for pro-violet-viettel/sourcecode/application/modules/frontend/controllers/home.php

Timestamp:

Mar 27, 2015 9:49:55 AM (10 years ago)

Author:

namnd

Message:

 

File:

• pro-violet-viettel/sourcecode/application/modules/frontend/controllers/home.php (modified) (1 diff)

pro-violet-viettel/sourcecode/application/modules/frontend/controllers/home.php

@@ -179 +179 @@
                 return 0;
         }
+        
+        public function test(){
+                $provinces = lang('_PROVINCES_');
+                $this->load->library("PHPExcel");
+                $file = './assets/danhsachquanhuyen.xls';
+                $objPHPExcel = PHPExcel_IOFactory::load($file);
+                $cell_collection = $objPHPExcel->getActiveSheet()->getCellCollection();
+                foreach ($cell_collection as $cell) {
+                        $column = $objPHPExcel->getActiveSheet()->getCell($cell)->getColumn();
+                        $row = $objPHPExcel->getActiveSheet()->getCell($cell)->getRow();
+                        $data_value = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue();
+                        
+                        if ($row == 1) {
+                                $header[$row][$column] = $data_value;
+                        } else {
+                                $arr_data[$row][$column] = $data_value;
+                        }
+                }
+                
+                $data['header'] = $header;
+                $data['values'] = $arr_data;
+                
+                foreach ($data['values'] as $index => $value){
+                        foreach ($provinces as $provinceId => $province){
+                                if ($value['C'] == $province) $data['values'][$index]['C'] = $provinceId;
+                                if ($value['B'] >= 10){
+                                        $data['values'][$index]['B'] = "0".$value['B'];
+                                }else{
+                                        $data['values'][$index]['B'] = "00".$value['B'];
+                                }
+                        }
+                        
+                }
+                
+                $dt = array();
+                foreach ($data['values'] as $index => $value){
+                        
+                        $dt[$index]['district_id'] = $value['B'];
+                        $dt[$index]['province_id'] = $value['C'];
+                        $dt[$index]['district_name'] = $value['D'];
+                        $dt[$index]['type'] = $value['E'];
+                }
+                //var_dump($dt);
+                //$this->load->model ( 'user_model' );
+                //$result = $this->user_model->insertDistrict($dt);
+                //var_dump($result);
+        }
 }