public function view_sampleSizeEditSubmit() { if (!isset($_SESSION['userName'])) { header('Location:index.php?mod=login&act=index'); } //获取POST数据 $sizeCode = ""; $sampleNum = ""; $EditId = ""; if (isset($_POST['EditId']) && !empty($_POST['EditId'])) { $EditId = trim($_POST['EditId']); } if (isset($_POST['sizeCodeInput']) && !empty($_POST['sizeCodeInput'])) { $sizeCode = "sizeCode = '" . trim($_POST['sizeCodeInput']) . "'"; } if (isset($_POST['sampleNumInput']) && !empty($_POST['sampleNumInput'])) { $sampleNum = "sampleNum = '" . trim($_POST['sampleNumInput']) . "'"; } $this->where = $sizeCode . " , " . $sampleNum . " where id = " . $EditId; //验证是否修改信息 global $dbConn; $existSql = "SELECT * FROM qc_sample_size_code WHERE id = {$EditId}"; $existInfo = $dbConn->fetch_first($existSql); if ($existInfo['sizeCode'] == trim($_POST['sizeCodeInput']) && $existInfo['sampleNum'] == trim($_POST['sampleNumInput'])) { $urldata = array('msg' => array('操作错误,信息未改变!'), 'link' => 'index.php?mod=sampleStandard&act=sampleSizeEditList&EditId=' . $EditId); $urldata = urlencode(json_encode($urldata)); header('location:index.php?mod=showerror&act=showerror&data=' . $urldata); exit; } else { $existRepeatSql = "SELECT * FROM qc_sample_size_code WHERE {$sizeCode} and id != {$EditId}"; $existRepeatSql = $dbConn->fetch_first($existRepeatSql); if (empty($existRepeatSql)) { $qcStandard = new qcStandardAct(); $list = $qcStandard->act_sampleSizeEditSubmit($this->where); if ($list) { header('Location:index.php?mod=sampleStandard&act=sampleSizeList'); } else { $urldata = array('msg' => array('系统出错啦!'), 'link' => 'index.php?mod=sampleStandard&act=sampleSizeEditList&EditId=' . $EditId); $urldata = urlencode(json_encode($urldata)); header('location:index.php?mod=showerror&act=showerror&data=' . $urldata); exit; } } else { $urldata = array('msg' => array('此执行标准已经存在,请勿重复添加!'), 'link' => 'index.php?mod=sampleStandard&act=sampleSizeEditList&EditId=' . $EditId); $urldata = urlencode(json_encode($urldata)); header('location:index.php?mod=showerror&act=showerror&data=' . $urldata); exit; } } }
public function view_iqcExportExcel() { header("Content-type:text/html;charset=utf-8"); $condition = array(); $where = ""; $sku = trim($_POST['sku']); $d_status = $_POST['d_status']; //导出类型:0->显示所以信息 1:->不良品统计表导出 $isCombine = $_POST['isCombine']; //是否合并:0->需要合并 1:->默认不合并 $sellerId = $_POST['sellerId']; //大卖家ID $j_status = $_POST['j_status']; //检测类型 $t_status = $_POST['t_status']; //SKU分类检测 if (!empty($_POST['startTime']) && !empty($_POST['endTime'])) { $startTime = strtotime(trim($_POST['startTime'])); //开始时间 $endTime = strtotime(trim($_POST['endTime'])); //结束时间 $condition[] = "checkTime BETWEEN {$startTime} AND {$endTime}"; $startTime = trim($_POST['startTime']); //开始时间 $endTime = trim($_POST['endTime']); //结束时间 } $condition[] = "sellerId = '{$sellerId}'"; if (!empty($j_status)) { $condition[] = "checkTypeID = '{$j_status}'"; } if (!empty($t_status)) { $condition[] = "skuTypeCheckID = '{$t_status}'"; } if (!empty($sku)) { $condition[] = "sku = '{$sku}'"; } $combine = false; if ($d_status == 1) { if ($isCombine == 0) { $combine = true; $condition[] = "rejectsNum > 0 GROUP BY sku"; } else { $condition[] = "rejectsNum > 0"; } } $where = "where " . implode(" and ", $condition); $IqcCompleteInfoAct = new IqcCompleteInfoAct(); $iqcCompleteInfoList = $IqcCompleteInfoAct->act_iqcCompleteInfo($where, $combine); //echo "<pre>"; print_r($iqcCompleteInfoList); exit; //检测类型 $qcStandard = new qcStandardAct(); $detectionTypeArrList = $qcStandard->act_detectionTypeList($this->where); $detectionTypeArr = array(); foreach ($detectionTypeArrList as $listValue) { $detectionTypeArr[$listValue['id']] = $listValue['typeName']; } //SKU分类检测 $qcStandard = new qcStandardAct(); $skuTypeQcArrList = $qcStandard->act_skuTypeQcList($this->where); $skuTypeQcArr = array(); foreach ($skuTypeQcArrList as $skuTypeList) { $skuTypeQcArr[$skuTypeList['id']] = $skuTypeList['typeName']; } //echo "<pre>";print_r($detectionTypeArrList); exit; $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file"); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '导出类型'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1', '料号'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1', '名称'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', '到货数'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1', '检测类型'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1', '抽检数'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('G1', 'SKU分类检测'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1', '不良数'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1', '不良原因'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('J1', '检测人'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('K1', '检测时间'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('L1', '大卖家'); //echo "<pre>"; print_r($iqcCompleteInfoList); exit; if ($d_status == 1) { $objPHPExcel->setActiveSheetIndex(0)->getCell('A2')->setValueExplicit('不良品统计表', PHPExcel_Cell_DataType::TYPE_STRING); } else { $objPHPExcel->setActiveSheetIndex(0)->getCell('A2')->setValueExplicit('检测信息统计', PHPExcel_Cell_DataType::TYPE_STRING); } $a = 2; if (!empty($iqcCompleteInfoList)) { foreach ($iqcCompleteInfoList as $key => $iqcExportArr) { //echo $skuTypeQcArr[$iqcExportArr['skuTypeCheckID']]; echo "<br>"; if (is_numeric($iqcExportArr['checkUser'])) { $username = UserModel::getUsernameById($iqcExportArr['checkUser']); if (!empty($username)) { $iqcExportArr['checkUser'] = $username; } } $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $a, $iqcExportArr['sku']); //SKU导出类型修改 add by chenwei 2013.12.20 //$objPHPExcel->setActiveSheetIndex(0)->getCell('B'.$a)->setValueExplicit($iqcExportArr['sku'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('C' . $a)->setValueExplicit(Deal_SC($iqcExportArr['goodsName']), PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('D' . $a)->setValueExplicit($iqcExportArr['arrivalNum'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('E' . $a)->setValueExplicit($detectionTypeArr[$iqcExportArr['checkTypeID']], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('F' . $a)->setValueExplicit($iqcExportArr['checkNum'], PHPExcel_Cell_DataType::TYPE_NUMERIC); $objPHPExcel->setActiveSheetIndex(0)->getCell('G' . $a)->setValueExplicit(@$skuTypeQcArr[$iqcExportArr['skuTypeCheckID']], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('H' . $a)->setValueExplicit($iqcExportArr['rejectsNum'], PHPExcel_Cell_DataType::TYPE_NUMERIC); //TYPE_NUMERIC 数值型 ADD BY chenwei 2013.12.20 $objPHPExcel->setActiveSheetIndex(0)->getCell('I' . $a)->setValueExplicit($iqcExportArr['rejectsReason'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('J' . $a)->setValueExplicit($iqcExportArr['checkUser'], PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('K' . $a)->setValueExplicit(date("Y-m-d H:i:s", $iqcExportArr['checkTime']), PHPExcel_Cell_DataType::TYPE_STRING); $objPHPExcel->setActiveSheetIndex(0)->getCell('L' . $a)->setValueExplicit('赛维网络', PHPExcel_Cell_DataType::TYPE_STRING); //echo $a.' '.$iqcExportArr['sku'].' '.$iqcExportArr['goodsName'].'<br/>'; $a++; } } $objPHPExcel->getActiveSheet(0)->getStyle('A1:N500')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(30); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(50); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('F')->setWidth(10); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(10); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('G')->setWidth(20); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('H')->setWidth(10); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('I')->setWidth(50); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('J')->setWidth(15); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('K')->setWidth(30); $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('L')->setWidth(20); $title = "QcWorkInfoExport" . date('Y-m-d'); $titlename = "QcWorkInfoExport" . date('Y-m-d') . ".xls"; $objPHPExcel->getActiveSheet()->setTitle($title); $objPHPExcel->setActiveSheetIndex(0); header('Content-Type: application/vnd.ms-excel'); header("Content-Disposition: attachment;filename={$titlename}"); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); exit; }
function act_getSkuInfo() { global $memc_obj; $sku_name = ''; $cate = ''; $sku = $_POST['sku']; if (is_numeric($sku) && $sku > 1000000) { //此sku为goods_code $goods_codes = WhStandardModel::goods_codeTosku($sku); $sku = $goods_codes['sku']; } //读取数据库 $categoryStr = ""; //$time1 = time(); //SKU信息API接口 $OmAvailableApiAct = new OmAvailableApiAct(); $skuInfo = $OmAvailableApiAct->act_getGoodsInfoBySku($sku); $skuInfo = $skuInfo['data']; //$skuInfo = $memc_obj->get_extral('pc_goods_'.$sku); $reSku = $skuInfo['sku']; //接口返回SKU $reSpu = $skuInfo['spu']; //接口返回SKU $skuName = $skuInfo['goodsName']; //产品描述 $purchaseId = $skuInfo['purchaseId']; //采购人ID $goodsCategory = $skuInfo['goodsCategory']; //SKU分类path $qcCategoryListAct = new qcCategoryListAct(); $where = 'WHERE is_delete=0 and path= "' . $goodsCategory . '"'; $categoryList = $qcCategoryListAct->act_getCategoryList('*', $where); $getCategoryArr = $qcCategoryListAct->act_getCategoryArr(); //获取产品类别列表信息 $sampleTypeListId = empty($categoryList) ? 1 : $categoryList[0]['sampleTypeId']; $qcStandard = new qcStandardAct(); $skuTypeQcArrList = $qcStandard->act_skuTypeQcList(''); $sampleTypeList = array(); $categoryInfo_ids = array(); $categoryInfo = array(); foreach ($skuTypeQcArrList as $skuTypeQcArrListValue) { $categoryInfo[$skuTypeQcArrListValue['id']] = $skuTypeQcArrListValue['typeName']; $sampleTypeList[$skuTypeQcArrListValue['id']] = $skuTypeQcArrListValue['typeName'] . " " . $skuTypeQcArrListValue['describe']; } $goodsCategoryNameArray = explode("-", $goodsCategory); $goodsCategoryName = array(); foreach ($goodsCategoryNameArray as $cvalue) { $goodsCategoryName[] = $getCategoryArr[$cvalue]; } $goodsCategoryNameStr = join('-', $goodsCategoryName); //$categoryInfo_ids = array_keys($categoryInfo_ids); //$categoryStr = $sampleTypeList[$sampleTypeListId]; //$img_return = $OmAvailableApiAct->act_getAllPic($reSpu, 'F');//图片接口 //var_dump($img_return); exit; $data = UserCacheModel::qccenterGetErpGoodscount($sku); $goods_count = $data['goods_count']; /*$goods_location = $data['goods_location']; $cguser = $data['cguser'];*/ //$categoryL = explode('-',$goodsCategory); /*foreach($category as $c_key=>$categoryArr){ if(in_array($categoryL[0],$categoryArr)){ if($c_key == '1'){ //SKU分类信息API接口 $cate = 1; $goodsCategorySt = $memc_obj->get_extral('pc_goods_category_'.$goodsCategory); $categoryStr = "{$goodsCategorySt['name']}:功能检测"; break; }else if($c_key == '2'){ //SKU分类信息API接口 $cate = 2; $goodsCategorySt = $memc_obj->get_extral('pc_goods_category_'.$goodsCategory); $categoryStr = "{$goodsCategorySt['name']}:尺寸质量检测"; break; }else if($c_key == '3'){ //SKU分类信息API接口 $cate = 3; $goodsCategorySt = $memc_obj->get_extral('pc_goods_category_'.$goodsCategory); $categoryStr = "{$goodsCategorySt['name']}:对图检测"; break; } }else{ continue; } }*/ $where = "where sku='{$sku}' and is_delete=0 and sellerId=1 and getUserId='{$_SESSION['sysUserId']}' and detectStatus=1 order by getTime asc limit 1"; $list = WhStandardModel::getNowWhList("*", $where); $num = $list[0]['num']; $infoid = $list[0]['id']; $goods_location = $list[0]['location']; $cguser = UserModel::getUsernameById($list[0]['purchaseId']); //$goods_count = 'TEST'; $where2 = "where sampleTypeId='{$sampleTypeListId}' and minimumLimit<='{$num}' and maximumLimit>='{$num}' limit 1"; $list2 = DetectStandardModel::getNowStandardList("*", $where2); //如果是正常回测,获取待定回测信息备注 $pendingInfo = PendingProductsModel::getPendingProductsList('backNote', ' WHERE infoId=' . $infoid); if ($pendingInfo) { $backNote = $pendingInfo[0]['backNote']; } //$time2 = time(); //echo ($time2-$time1); if ($list) { self::$errCode = "200"; $info = array(); $info['info'] = "{$reSku} {$skuName} <br> 产品分类: {$goodsCategoryNameStr} <br>【 来货 {$num} 个,现有库存 " . $goods_count . " 个,仓位:" . $goods_location . ",采购:{$cguser} 】"; $info['category'] = $sampleTypeListId; $info['categoryInfo'] = $categoryInfo; $info['sku'] = $reSku; $info['spu'] = $reSpu; $info['num'] = $num; $info['infoid'] = $infoid; $info['cate'] = $list2; $info['images'] = $img_return['data']['Description'][0]; $info['backNote'] = !empty($backNote) ? $backNote : ''; return $info; } else { self::$errCode = "003"; self::$errMsg = "未找到该料号[{$sku}]对于的{$_SESSION['userName']}领取记录!"; return false; } }