function act_getOutRecordsBySku() { $sku = isset($_GET['sku']) ? trim($_GET['sku']) : ''; $startTime = isset($_GET['startTime']) ? trim($_GET['startTime']) : ''; $endTime = isset($_GET['endTime']) ? trim($_GET['endTime']) : ''; if (empty($sku) || empty($startTime) || empty($endTime)) { //参数不完整 self::$errCode = 101; self::$errMsg = '参数信息不完整'; return false; } $totalNum = 0; $infos = WhIoRecordsModel::getTNameList("wh_iorecords", "*", "where createdTime>={$startTime} and createdTime<={$endTime} and {$sku}='{$sku}' and ioType=1"); if ($info) { if (!empty($infos)) { foreach ($infos as $info) { $totalNum += $info['amount']; } } return $totalNum; } else { self::$errCode = WhIoRecordsModel::$errCode; self::$errMsg = WhIoRecordsModel::$errMsg; return false; } }
public function act_export() { $ioType = intval($_GET['ioType']); $id = isset($_GET['id']) ? post_check($_GET['id']) : ''; $ordersn = isset($_GET['ordersn']) ? post_check($_GET['ordersn']) : ''; $ioTypeId = isset($_GET['ioTypeId']) ? post_check($_GET['ioTypeId']) : ''; $sku = isset($_GET['sku']) ? post_check($_GET['sku']) : ''; $purchaseId = isset($_GET['purchaseId']) ? post_check($_GET['purchaseId']) : ''; $userId = isset($_GET['userId']) ? post_check($_GET['userId']) : ''; $cStartTime = isset($_GET['cStartTime']) ? post_check($_GET['cStartTime']) : ''; $cEndTime = isset($_GET['cEndTime']) ? post_check($_GET['cEndTime']) : ''; if (empty($id) && empty($ordersn) && empty($ioTypeId) && empty($sku) && empty($purchaseId) && empty($userId) && empty($cStartTime) && empty($cEndTime)) { echo "请选择导出条件"; exit; } $where = "WHERE ioType='{$ioType}' "; if (!empty($id)) { $where .= "AND id='{$id}' "; } if (!empty($ordersn)) { $where .= "AND ordersn='{$ordersn}' "; } if (!empty($ioTypeId)) { $where .= "AND ioTypeId='{$ioTypeId}' "; } if (!empty($sku)) { $where .= "AND sku='{$sku}' "; } if (!empty($purchaseId)) { $purchaseId = getUserIdByName($purchaseId); $where .= "AND purchaseId='{$purchaseId}' "; } if (!empty($userId)) { $userId = getUserIdByName($userId); $where .= "AND userId='{$userId}' "; } if (!empty($cStartTime)) { $startTime = strtotime($cStartTime . '00:00:00'); $where .= "AND createdTime >='{$startTime}' "; } if (!empty($cEndTime)) { $endTime = strtotime($cEndTime . '23:59:59'); $where .= "AND createdTime <='{$endTime}' "; } $lists = WhIoRecordsModel::getTNameList('wh_iorecords', '*', $where); if ($ioType == 1) { $excel = new ExportDataExcel('browser', "out_warehouse." . date('Y-m-d') . ".xls"); } else { $excel = new ExportDataExcel('browser', "in_warehouse." . date('Y-m-d') . ".xls"); } $excel->initialize(); $tharr = array("日期", "料号", "仓位", "数量", "类型", "申请人", "订单号", "备注"); $excel->addRow($tharr); foreach ($lists as $list) { $time = date('Y/m/d', $list['createdTime']); $sku = $list['sku']; $position_info = whShelfModel::selectPosition("where id={$list['positionId']}"); $pName = $position_info[0]['pName']; $num = $list['amount']; $ioTypeName = WhIoStoreModel::getIoTypeNameById($list['ioTypeId']); $user = getUserNameById($list['userId']); $ordersn = $list['ordersn']; $reason = $list['reason']; $tdarr = array($time, $sku, $pName, $num, $ioTypeName, $user, $ordersn, $reason); $excel->addRow($tdarr); } $excel->finalize(); exit; }