4,249
社区成员




public function upload(){
if ($this->isPost()){
import("ORG.Net.UploadFile");
$upload = new UploadFile();
$upload->maxSize = 3145728;
$upload->allowExts = array('xls');
$upload->savePath = '../Public/Files/Contractorder/';
$upload->saveRule = 'uniqid';
if (!$upload->upload()) {
$this->error($upload->getErrorMsg());
}else {
$info = $upload->getUploadFileInfo();
}
Vendor("Excel.reader");
//一到这里就停了
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('utf-8');
$myfilename = $upload->savePath.$info[0]['savename'];
if(file_exists($myfilename)){
$models = M('contractorder');
$mytime = time();
$data->read($myfilename);
for ($i = 3; $i <= $data->sheets[0]['numRows']; $i++) {
if(empty($data->sheets[0]['cells'][$i][1])) continue;
$array = array();
$array['year'] = $data->sheets[0]['cells'][$i][1];
$array['month'] = $data->sheets[0]['cells'][$i][2];
$array['uid'] = $data->sheets[0]['cells'][$i][3];
$mycells = 'p';
for ($j = 4; $j <= 31; $j++) {
$array[$mycells.$j] = $data->sheets[0]['cells'][$i][$j];
}
$array['zong'] = $data->sheets[0]['cells'][$i][18];
$array['time'] = $mytime;
$models->data($array)->add();
}
}else{
$this->success("读取xls文件失败!");
}
$this->assign('jumpUrl','__APP__/Contractorder/upload_ok');
$this->success("导入成功!");
}else{
$data['op'] = '业绩上传';
$this->assign('data',$data);
$this->display();
}
}