$suffix= strrchr($_FILES['file_path']['name'],'.');
$xl = array('.xls');
if(!in_array($suffix,$xl)){
echo "{success:false,msg:'文件错误,文件只能是xls文件'}";exit;
}
set_time_limit(0);
include_once(CFG_PATH_LIB.'PHPExcel/Reader/Excel5.php');
$objReader = new PHPExcel_Reader_Excel5();
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($_FILES['file_path']['tmp_name']);
$currentSheet =$objPHPExcel->getSheet(0);
$allColumn = $currentSheet->getHighestColumn();
$allRow = $currentSheet->getHighestRow();
$field_list = array();
$object = new ModelGoods();
$msg = '';
if($currentSheet->getCell("A1")->getValue() != 'goods_sn') {echo "{success:false,msg:'文件格式错误'}";exit;}
for($currentColumn='B';$currentColumn<=$allColumn;$currentColumn++){ //第一行取更新字段
$field_list[] = trim($currentSheet->getCell($currentColumn."1")->getValue());
}
$err = 0;
for($currentRow = 2;$currentRow<=$allRow;$currentRow++){//从第二行开始更新数据
$goods_info = array();
$filed_value = array();
for($currentColumn='B';$currentColumn<=$allColumn;$currentColumn++){
$address = $currentColumn.$currentRow;
$filed_value[] = trim($currentSheet->getCell($address)->getValue());
}
for($i=0;$i<count($field_list);$i++){
$goods_info[$field_list[$i]] = $filed_value[$i];
}
try {
$object->updategoods($goods_info,trim($currentSheet->getCell("A".$currentRow)->getValue()));
} catch (Exception $e) {
$err =1;
$msg .= $currentSheet->getCell("A".$currentRow)->getValue().'产品数据保存失败<br>';
}
}
if($err == 1) {echo "{success:false,msg:'$msg'}";exit;}
savelog($_SESSION['admin_id'],'goods','批量更新产品信息',$_SESSION['admin_id']);
echo "{success:true,msg:'产品更新成功'}";exit;
}
$xl = array('.xls');
if(!in_array($suffix,$xl)){
echo "{success:false,msg:'文件错误,文件只能是xls文件'}";exit;
}
set_time_limit(0);
include_once(CFG_PATH_LIB.'PHPExcel/Reader/Excel5.php');
$objReader = new PHPExcel_Reader_Excel5();
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($_FILES['file_path']['tmp_name']);
$currentSheet =$objPHPExcel->getSheet(0);
$allColumn = $currentSheet->getHighestColumn();
$allRow = $currentSheet->getHighestRow();
$field_list = array();
$object = new ModelGoods();
$msg = '';
if($currentSheet->getCell("A1")->getValue() != 'goods_sn') {echo "{success:false,msg:'文件格式错误'}";exit;}
for($currentColumn='B';$currentColumn<=$allColumn;$currentColumn++){ //第一行取更新字段
$field_list[] = trim($currentSheet->getCell($currentColumn."1")->getValue());
}
$err = 0;
for($currentRow = 2;$currentRow<=$allRow;$currentRow++){//从第二行开始更新数据
$goods_info = array();
$filed_value = array();
for($currentColumn='B';$currentColumn<=$allColumn;$currentColumn++){
$address = $currentColumn.$currentRow;
$filed_value[] = trim($currentSheet->getCell($address)->getValue());
}
for($i=0;$i<count($field_list);$i++){
$goods_info[$field_list[$i]] = $filed_value[$i];
}
try {
$object->updategoods($goods_info,trim($currentSheet->getCell("A".$currentRow)->getValue()));
} catch (Exception $e) {
$err =1;
$msg .= $currentSheet->getCell("A".$currentRow)->getValue().'产品数据保存失败<br>';
}
}
if($err == 1) {echo "{success:false,msg:'$msg'}";exit;}
savelog($_SESSION['admin_id'],'goods','批量更新产品信息',$_SESSION['admin_id']);
echo "{success:true,msg:'产品更新成功'}";exit;
}