function import1() { $dir = $_FILES['file-name1']; $date = date("Y-m-d H:i:s"); if ($_FILES['file-name1']['error'] == '0') { $type = substr($_FILES['file-name1']['type'], -5); //var_dump($type);die(); if ($type == 'xlsx' || $type == '/kset' || $type == 'excel' || $type == 'sheet') { if ($_FILES['file-name1']['size'] <= 2000000) { $filePath = $_FILES['file-name1']['tmp_name']; //var_dump($filePath);die; import("ORG.Util.MyExcel"); $excel = new MyExcel(); //var_dump($excel);die(); $excel->loadExcel($filePath); $columnTitle = $excel->findColumnTitle(); //var_dump($columnTitle);die; $strTitle = md5(trim(implode(',', $columnTitle))); //$standard=md5("电话号码,ICCID,IP,产品型号,生产日期,WiFi-SSID,WiFi密码,备注,NULL"); $standard = md5("上网号"); //var_dump($standard);die; if ($standard != $strTitle) { echo "<script language='javascript'>alert('请选择正确的模板!');window.history.back(-1);</script>"; } else { $data = $excel->findAll(); //echo "<pre>"; //var_dump($data);die(); //echo "</pre>"; //echo "<pre>";var_dump($data);echo "</pre>";die(); $shOb = M("flows"); if (count($data) <= 1) { echo "<script language='javascript'>alert('无数据!');window.history.back(-1);</script>"; } else { for ($i = 2; $i <= count($data); $i++) { $reIn = $shOb->query("update r_flows set flow=0 where CCID=" . $data[$i]['A']); } if ($reIn !== false) { echo "<script language='javascript'>alert('导入成功!');window.history.back(-1);</script>"; } } } } else { echo "<script language='javascript'>alert('文件过大!');window.history.back(-1);</script>"; } } else { echo "<script language='javascript'>alert('文件类型不正确!');window.history.back(-1);</script>"; } } else { echo "<script language='javascript'>alert('文件上传失败!');window.history.back(-1);</script>"; } }
public function import1() { $dir = $_FILES['file-name1']; /* echo "<pre>"; var_dump($dir); echo "</pre>";die(); */ if ($_FILES['file-name1']['error'] == '0') { $type = substr($_FILES['file-name1']['type'], -5); // var_dump($type);die(); if ($type == 'xlsx' || ($type = '/kset' || ($type = 'excel' || ($type = 'sheet')))) { if ($_FILES['file-name1']['size'] <= 2000000) { $filePath = $_FILES['file-name1']['tmp_name']; //var_dump($filePath); import("ORG.Util.MyExcel"); $excel = new MyExcel(); //var_dump($excel);die(); $excel->loadExcel($filePath); $columnTitle = $excel->findColumnTitle(); $strTitle = md5(trim(implode(',', $columnTitle))); //$standard=md5("电话号码,ICCID,IP,产品型号,生产日期,WiFi-SSID,WiFi密码,备注"); $standard = md5("设备号,卡状态,配额类型,截止日期"); if ($standard != $strTitle) { echo "<script language='javascript'>alert('请选择正确的模板!');window.history.back(-1);</script>"; } else { $data = $excel->findAll(); //var_dump($data);exit(); //echo "<pre>"; //var_dump($data);die(); //echo "</pre>"; //echo "<pre>";var_dump($data);echo "</pre>";die(); if (count($data) <= 1) { echo "<script language='javascript'>alert('无数据!');window.history.back(-1);</script>"; } else { $dataStr = ""; for ($i = 2; $i <= count($data); $i++) { //$dataStr.=",('".$data[$i]['A']."','".ip2long($data[$i]['B'])."','".$data[$i]['C']."','".$data[$i]['D']."','".$simBatch."',1)"; $shOb = M("simhard"); $type = stripcslashes($data[$i]['C']); $deadTime = excelTime($data[$i]['D']); //将时间日期字段做一下格式转换 //$deadTime = stripcslashes('2014-12-31'); $status = stripcslashes($data[$i]['B']); if (stripcslashes($status) == "") { $status = 1; } $CCID = $data[$i]['A']; $date = date("Y-m-d H:i:s"); $reIn = $shOb->query("update r_simhard set deadTime='{$deadTime}',type='{$type}',status='{$status}',updated_at='{$date}' where CCID='{$CCID}'"); } //$dataStr1=substr($dataStr,1); //var_dump($dataStr1);die(); if ($reIn !== false) { echo "<script language='javascript'>alert('导入成功!');window.history.back(-1);</script>"; } } } } else { echo "<script language='javascript'>alert('文件过大!');window.history.back(-1);</script>"; } } else { echo "<script language='javascript'>alert('文件类型不正确!');window.history.back(-1);</script>"; } } else { echo "<script language='javascript'>alert('文件上传失败!');window.history.back(-1);</script>"; } }