微擎后台Excel导入数据

$file = $_FILES['file'];
                if(!$file['size']){
                     message('文件上传不能为空！',  '', 'error');
                }
				if( $file['name'] && $file['error'] == 0){
                    $type = substr($file['name'], strrpos($file['name'], '.')+1); 
                    $type = strtolower($type);
                    if( !in_array($type, array('xls','xlsx','csv')) ){
                   		 message('文件类型错误！，请选择Excel文件',  '', 'error');	
                    }
                    set_time_limit(0);
                    include_once IA_ROOT . '/framework/library/phpexcel/PHPExcel.php';
                    include_once IA_ROOT . '/framework/library/phpexcel/PHPExcel/IOFactory.php';
                    if($type == 'xls'){
                      $inputFileType = 'Excel5';    //这个是读 xls的
                    }else{
                      $inputFileType = 'Excel2007';//这个是计xlsx的
                    }
                  	$objReader = PHPExcel_IOFactory::createReader($inputFileType);
                    $objPHPExcel = $objReader->load($file['tmp_name']);
                    $sheet = $objPHPExcel->getSheet(0);
                    //获取行数与列数,注意列数需要转换
                    $highestRow = $sheet->getHighestRow();
                    $highestColumn = $sheet->getHighestColumn();
                    $highestColumnNum = PHPExcel_Cell::columnIndexFromString($highestColumn);
                    $usefullColumnNum = $highestColumnNum;
                  
                    list($msec, $sec) = explode(' ', microtime());
				    $msectime = (float)sprintf('%.0f', (floatval($msec) + floatval($sec)) * 1000);		
                  
                    for ($row = 2;$row <= $highestRow;$row++){
                        $generation_number = $sheet->getCellByColumnAndRow(0, $row)->getValue();//世代编号
						$direct_line = $sheet->getCellByColumnAndRow(1, $row)->getValue();//轨可直系
                        $generation_no = $sheet->getCellByColumnAndRow(2, $row)->getValue();//第几代
                        $lineage_nickname = $sheet->getCellByColumnAndRow(3, $row)->getValue();//世系别名
                        $member_ID = $sheet->getCellByColumnAndRow(4, $row)->getValue();//成员编号
                        $famiMembFana = $sheet->getCellByColumnAndRow(5, $row)->getValue();//姓氏
                        $famiMembLana = $sheet->getCellByColumnAndRow(6, $row)->getValue();//名字
                        $userIdent = $sheet->getCellByColumnAndRow(7, $row)->getValue();//身份证号
                        $famiMembTel = $sheet->getCellByColumnAndRow(8, $row)->getValue();//联系方式
                        $famiMembBirth = $sheet->getCellByColumnAndRow(9, $row)->getValue();//生日
                        $famiMembGender = $sheet->getCellByColumnAndRow(10, $row)->getValue();//性别
                        $famiMembEdu = $sheet->getCellByColumnAndRow(11, $row)->getValue();//学历
                        $famiMembWost = $sheet->getCellByColumnAndRow(12, $row)->getValue();//个人介绍
                        $famiMembEx = $sheet->getCellByColumnAndRow(13, $row)->getValue();//是否嫁入
                        $dead = $sheet->getCellByColumnAndRow(14, $row)->getValue();//是否已亡
                        $address = $sheet->getCellByColumnAndRow(15, $row)->getValue();//居住地址
                        $cemetery = $sheet->getCellByColumnAndRow(16, $row)->getValue();//墓地
                        $member_note = $sheet->getCellByColumnAndRow(17, $row)->getValue();//备注
                        $father_ID = $sheet->getCellByColumnAndRow(18, $row)->getValue();//父亲编号
                        $famiMembFauid = $sheet->getCellByColumnAndRow(19, $row)->getValue();//父亲身份证号
                        $wife_ID = $sheet->getCellByColumnAndRow(20, $row)->getValue();//配偶编号
                        $wifeIdent = $sheet->getCellByColumnAndRow(21, $row)->getValue();//配偶身份证号
                      
                        if(trim($famiMembGender) == 1) {
                        	$famiMembAvatar = "/xcx/Public/images/man.png";
                        }else{
                        	$famiMembAvatar = "/xcx/Public/images/woman.png";
                        }
                      
                        if(trim($famiMembEx) == '' || trim($famiMembEx) == 1) {
                        	$famiMembEx = 0;
                        }else{
                            $famiMembEx = 1;
                        }
                      
                      	$insert = array(
                            'generation_number' => trim($generation_number),
                            'direct_line' => trim($direct_line),	
                            'generation_no' => trim($generation_no),	
                            'lineage_nickname' => trim($lineage_nickname),
                            'member_ID' => trim($member_ID),
                            'famiMembAvatar' => $famiMembAvatar,
                            'famiMembFana' => trim($famiMembFana),
                            'famiMembLana' => trim($famiMembLana),
                            'userIdent' => trim($userIdent),
                            'famiMembTel' => trim($famiMembTel),
                            'famiMembBirth' => trim($famiMembBirth),
                            'famiMembGender' => trim($famiMembGender),
                            'famiMembEdu' => trim($famiMembEdu),
                            'famiMembWost' => trim($famiMembWost),
                            'famiMembEx' => $famiMembEx,
                            'dead' => trim($dead),
                            'address' => trim($address),
                            'cemetery' => trim($cemetery),
                            'member_note' => trim($member_note),
                            'father_ID' => trim($father_ID),
                            'famiMembFauid' => trim($famiMembFauid),
                            'wife_ID' => trim($wife_ID),
                            'wifeIdent' => trim($wifeIdent),
                            'famiId' => 89,
							'createtime' => $msectime,
                        );
						
                        $exists = pdo_fetch("SELECT * FROM ".tablename('gkwh_famimembs')." WHERE member_ID = :member_ID AND famiId = :famiId", array(':famiId' => 89, ':member_ID' => trim($member_ID)));
                        if(empty($exists)) {
                            $result = pdo_insert('gkwh_famimembs', $insert);                             
                            if (!empty($result)) {
                                //$famiMembId = pdo_insertid();
                            }
                        }else {
                            pdo_update('gkwh_famimembs', $insert, array('member_ID' => trim($member_ID)));
                        }
                        unset($insert);
                    }
                  	message("家族成员保存成功!", $this->createWebUrl('myGen_list'), "success");
                }	
				
				message('导入错误',  '', 'error');	

新蔷程序员特训营，带领初学者快速开发商业项目：https://paishenwx.taobao.com/