$file = $_FILES['file'];
if(!$file['size']){
message('文件上传不能为空!','','error');
}
if($file['name'] && $file['error'] == 0){
$type = @end(explode('.',$file['name']));
$type = strtolower($type);
}
if(!in_array($type,array('xls','xlsx','csv'))){
message('文件类型错误!','','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';
}else{
$inputFileType = 'Excel2007';
}
$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;
for($row = 1;$row <= $highestRow;$row++){
$party_name = $sheet->getCellByColumnAndRow(0, $row)->getValue();//党支部
$insert_data['name'] = $party_name;
$insert_data['pid'] = $pid;
$insert_data['sort'] = 0;
$insert_data['status'] = 1;
$insert_data['create_time'] = strtotime('now');
$checkData = pdo_fetchcolumn("select count(*) from".tablename($linkageTableName)." where name='$party_name' and pid='$pid' and status = 1");
if($checkData == 0){
pdo_insert($linkageTableName, $insert_data);
}
}
message('导入完成');
最新评论