function act_updateTNameRow($tName, $set, $where)
{
$ret = WhIoStoreModel::updateTNameRow($tName, $set, $where);
if ($ret !== FALSE) {
return $ret;
} else {
self::$errCode = WhIoStoreModel::$errCode;
self::$errMsg = WhIoStoreModel::$errMsg;
return false;
}
}
/**
* 添加单据及详情
* @param array $orderArr
*/
public function ddIoStore($orderArr)
{
self::initDB();
$invoiceTypeId = $orderArr['invoiceTypeId'];
//出入库类型表中的id
$ioType = $orderArr['ioType'];
//出/入库，只能为1或2,1为出库，2为入库
$userId = $orderArr['userId'];
//申请人id
$ordersn = $orderArr['ordersn'];
//单据号（单据编码）
$paymentMethodsId = $orderArr['paymentMethodsId'];
//付款方式表中的id
$note = isset($orderArr['note']) ? $orderArr['note'] : '';
//备注
$companyId = $orderArr['companyId'];
//公司id
$storeId = $orderArr['storeId'];
//仓库表中的id
$detail = $orderArr['detail'];
//订单详情
if (is_numeric($invoiceTypeId)) {
//出入库类型表中的id不能为空
self::$errCode = 402;
self::$errMsg = 'invoiceTypeId有误';
return false;
}
if ($ioType != 1 && $ioType != 2) {
//出或者入库
self::$errCode = 403;
self::$errMsg = 'ioType有误';
return false;
}
if (empty($userId)) {
self::$errCode = 404;
self::$errMsg = 'userId有误';
return false;
}
if (empty($ordersn)) {
self::$errCode = 405;
self::$errMsg = 'ordersn有误';
return false;
}
if (empty($paymentMethodsId)) {
self::$errCode = 406;
self::$errMsg = 'paymentMethodsId有误';
return false;
}
if (!is_array($detail)) {
self::$errCode = 407;
self::$errMsg = 'detail有误';
return false;
}
if (empty($companyId)) {
//默认公司为1赛维
$companyId = 1;
}
if (empty($storeId)) {
//默认仓库为1，深圳仓库
$storeId = 1;
}
$sql = "SELECT * FROM wh_audit_relation_list WHERE invoiceTypeId={$invoiceTypeId} AND storeId={$storeId} ORDER BY auditLevel ASC, auditorId ASC";
$query = self::$dbConn->query($sql);
$lists = self::$dbConn->fetch_array_all($query);
if (empty($lists)) {
self::$errCode = 408;
self::$errMsg = "找不到对应的出入库类型";
return false;
}
$now_time = time();
self::$dbConn->begin();
$insert_iostore_sql = "INSERT INTO wh_iostore (invoiceTypeId,ioType,userId,createdTime,ordersn,paymentMethodsId,companyId,nextoperatorId,storeId,note) \n\t\t\t\t\t\t\tVALUES({$invoiceTypeId},{$ioType},{$userId},{$now_time},'{$ordersn}',{$paymentMethodsId},{$companyId},{$lists[0]['auditorId']},{$storeId},'{$note}')";
$insert_iostore = self::$dbConn->query($insert_iostore_sql);
if (!$insert_iostore) {
self::$errCode = "409";
self::$errMsg = "插入单据表失败";
return false;
} else {
$iostoreId = self::$dbConn->insert_id($insert_iostore);
}
//添加详情
foreach ($detail as $det) {
$sku = $det['sku'];
//添加的sku
$amount = $det['amount'];
//对应数量
$cost = $det['cost'];
//成本
$purchaseId = $det['purchaseId'];
//采购员id
$insert_detail_sql = "INSERT INTO wh_iostoredetail (iostoreId,sku,amount,cost,purchaseId,storeId) \n\t\t\t\t\t\t\t\tVALUES({$iostoreId},'{$sku}',{$amount},'{$cost}',{$purchaseId},{$storeId})";
$insert_detail = self::$dbConn->query($insert_detail_sql);
if (!$insert_detail) {
self::$errCode = "410";
self::$errMsg = "插入单据详情表失败";
self::$dbConn->rollback();
return false;
}
}
self::$dbConn->commit();
return true;
}
public function view_getWhIoRecordsList()
{
$type = isset($_GET['type']) ? $_GET['type'] : '';
$status = isset($_GET['status']) ? $_GET['status'] : '';
$ioType = isset($_GET['ioType']) ? $_GET['ioType'] : '';
if (intval($ioType) != 1 && intval($ioType) != 2) {
//1为出库，2为入库
$this->smarty->assign('$toptitle', '出入库记录列表');
$this->smarty->assign('status', '参数错误');
$this->smarty->assign('whIoRecordsList', null);
//循环列表
$this->smarty->display("whIoRecords.htm");
} else {
$ioType = intval($ioType);
$whIoRecordsAct = new WhIoRecordsAct();
$where = "WHERE ioType='{$ioType}' ";
if ($type == 'search') {
$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']) : '';
$positionId = isset($_GET['position']) ? post_check($_GET['position']) : '';
$cStartTime = isset($_GET['cStartTime']) ? post_check($_GET['cStartTime']) : '';
$cEndTime = isset($_GET['cEndTime']) ? post_check($_GET['cEndTime']) : '';
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 ($positionId) {
$positionId = WhPositionDistributionModel::get_position_info('id', '', $positionId);
$positionId = empty($positionId) ? '-1' : $positionId[0]['id'];
$where .= "AND positionId = '{$positionId}' ";
}
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}' ";
}
}
$total = $whIoRecordsAct->act_getTNameCount('wh_iorecords', $where);
$num = 100;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
$where .= "ORDER BY createdTime DESC " . $page->limit;
$whIoRecordsList = $whIoRecordsAct->act_getTNameList('wh_iorecords', '*', $where);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
$toptitle = '出库记录列表';
$ioSearchName = '出库类型';
$navlist = array(array('url' => 'index.php?mod=skuStock&act=getSkuStockList', 'title' => '库存信息'), array('url' => '', 'title' => '出库记录列表'));
$this->smarty->assign('toplevel', 0);
$this->smarty->assign('secondlevel', '34');
$ioTypeList = WhIoStoreModel::getIoTypeListByioType(0);
if ($ioType == 2) {
$toptitle = '入库记录列表';
$ioSearchName = '入库类型';
$this->smarty->assign('secondlevel', 35);
$navlist = array(array('url' => 'index.php?mod=skuStock&act=getSkuStockList', 'title' => '库存信息'), array('url' => '', 'title' => '入库记录列表'));
$ioTypeList = WhIoStoreModel::getIoTypeListByioType(1);
}
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('ioSearchName', $ioSearchName);
$this->smarty->assign('ioTypeList', $ioTypeList);
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('status', $status);
$usermodel = UserModel::getInstance();
foreach ($whIoRecordsList as $key => $val) {
$whIoRecordsList[$key]['ioTypeName'] = WhIoStoreModel::getIoTypeNameById($val['ioTypeId']);
$whIoRecordsList[$key]['whName'] = WhIoStoreModel::getWhNameById($val['storeId']);
$purchase_user_info = $usermodel->getGlobalUserLists('global_user_name', "where a.global_user_id='{$val['purchaseId']}'", '', 'limit 1');
$whIoRecordsList[$key]['purchaseName'] = $purchase_user_info[0]['global_user_name'];
//$user_info = $usermodel->getGlobalUserLists('global_user_name',"where a.global_user_id='{$val['userId']}'",'','limit 1');
//$whIoRecordsList[$key]['userName'] = $user_info[0]['global_user_name'];
$whIoRecordsList[$key]['userName'] = getUserNameById($val['userId']);
$position_info = whShelfModel::selectPosition("where id={$val['positionId']}");
$whIoRecordsList[$key]['pName'] = $position_info[0]['pName'];
}
$this->smarty->assign('whIoRecordsList', $whIoRecordsList ? $whIoRecordsList : null);
//循环列表
$this->smarty->display("whIoRecords.htm");
}
}
function act_addWhShipingOrderCAT()
{
global $memc_obj;
//调用memcache获取sku信息
$jsonArr = isset($_GET['jsonArr']) ? $_GET['jsonArr'] : '';
//传过来的base64编码的json字符串(客户端要先json然后再base64))
if (empty($jsonArr)) {
self::$errCode = '0101';
self::$errMsg = 'empty jsonArr';
return 0;
}
$jsonArr = json_decode(base64_decode($jsonArr), true);
//对base64及json解码
if (!is_array($jsonArr)) {
self::$errCode = '0201';
self::$errMsg = 'error array';
return 0;
}
if (!is_array($jsonArr['shipOrderDetail'])) {
self::$errCode = '0301';
self::$errMsg = 'shipOrderDetail error array';
return 0;
}
try {
TransactionBaseModel::begin();
$originOrderId = $jsonArr['originOrderId'];
//订单ID
if (intval($originOrderId) == 0) {
self::$errCode = '0401';
self::$errMsg = 'error originOrderId';
return 0;
}
$recordNumber = $jsonArr['recordNumber'];
//订单记录各平台id号
$shipOrderDetail = $jsonArr['shipOrderDetail'];
//订单详细,为数组记录
$username = $jsonArr['username'];
//收件人
$platformUsername = $jsonArr['platformUsername'];
//对应平台的用户登陆名称,买家id
$email = $jsonArr['email'];
//客户邮箱
$countryName = $jsonArr['countryName'];
//收件人国家名称
$countrySn = $jsonArr['countrySn'];
//收件人国家简称
$state = $jsonArr['state'];
//收件人省份，州名
$city = $jsonArr['city'];
//收件人城市名称
$street = $jsonArr['street'];
//收件人街道
$address2 = $jsonArr['address2'];
//收件人地址2
$address3 = $jsonArr['address3'];
//收件人地址3
$currency = $jsonArr['currency'];
//币种
$landline = $jsonArr['landline'];
//座机
$phone = $jsonArr['phone'];
//手机
$zipCode = $jsonArr['zipCode'];
//邮政编码
$transportId = $jsonArr['transportId'];
//运输方式ID
$accountId = $jsonArr['accountId'];
//发货单对应销售账号
$orderAttributes = $jsonArr['orderAttributes'];
//发货单属性状态id,为数组
if (empty($orderAttributes) || !is_array($orderAttributes)) {
self::$errCode = '0501';
self::$errMsg = 'error orderAttributes';
return 0;
}
$pmId = $jsonArr['pmId'];
//包装材料ID
$isFixed = $jsonArr['isFixed'];
//是否固定运输方式，默认2最优运输方式；1固定运输方式
$total = $jsonArr['total'];
//发货单总价值
$channelId = $jsonArr['channelId'];
//渠道ID
$calcWeight = $jsonArr['calcWeight'];
//估算重量，单位是kg
$calcShipping = $jsonArr['calcShipping'];
//估算运费
$createdTime = $jsonArr['createdTime'] ? $jsonArr['createdTime'] : time();
//添加时间
$orderTypeId = $jsonArr['orderTypeId'] ? $jsonArr['orderTypeId'] : 1;
//发货单类别，默认为1，发货单；2为配货单
$companyId = $jsonArr['companyId'] ? $jsonArr['companyId'] : 1;
//公司名称ID，默认赛维网络科技
$storeId = $jsonArr['storeId'] ? $jsonArr['storeId'] : 1;
//仓库ID，默认为1赛维网络深圳仓库
$tName = 'wh_shipping_order';
$set = "SET username='******',platformUsername='******',email='{$email}',countryName='{$countryName}',\n\t\t\t countrySn='{$countrySn}',state='{$state}',city='{$city}',street='{$street}',address2='{$address2}',\n\t\t\t address3='{$address3}',currency='{$currency}',landline='{$landline}',\n\t\t\t phone='{$phone}',zipCode='{$zipCode}',transportId='{$transportId}',\n\t\t\t accountId='{$accountId}',pmId='{$pmId}',\n\t\t\t isFixed='{$isFixed}',total='{$total}',channelId='{$channelId}',\n\t\t\t calcWeight='{$calcWeight}',calcShipping='{$calcShipping}',createdTime='{$createdTime}',\n\t\t\t orderTypeId='{$orderTypeId}',companyId='{$companyId}',storeId='{$storeId}' ";
$insertId = WhIoStoreModel::addTNameRow($tName, $set);
if (!$insertId) {
self::$errCode = '0801';
self::$errMsg = 'addRow error';
throw new Exception('add shipOrder error');
}
$shipOrderId = $insertId;
//发货单ID
foreach ($shipOrderDetail as $detail) {
$sku = $detail['sku'];
//sku
$amount = $detail['amount'];
//配货数量
if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $sku) || intval($amount) == 0) {
self::$errCode = '0811';
self::$errMsg = 'sku or amount error';
throw new Exception('sku or amount error');
}
//echo 'sku == '.$sku.'<br/>';
$storeId = $detail['storeId'] ? $detail['storeId'] : 1;
//仓库ID，默认为1赛维网络深圳仓库
//echo '$memc_obj====';
//print_r($memc_obj);
//echo'<br/>';
$skuInfo = $memc_obj->get_extral("sku_info_" . $sku);
//调用memcache取得对应单料号或组合料号的重量
//echo '$skuInfo=======';
//print_r($skuInfo);
//echo'<br/>';
if (empty($skuInfo)) {
self::$errCode = '0814';
self::$errMsg = 'empty skuInfo';
throw new Exception('skuInfo');
}
// $ppp = $memc_obj->get_extral("pc_packing_material"); //调用memcache取得对应单料号或组合料号的重量
// //echo '$ppp=======';
// //print_r($ppp);
// //echo'<br/>';
if (!empty($skuInfo['sku']) && is_array($skuInfo['sku'])) {
//为组合料号
foreach ($skuInfo['sku'] as $key => $value) {
//循环$skuInfo下的sku的键，找出所有真实料号及对应数量,$key为组合料号下对应的真实单料号，value为对应数量
if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $key) || intval($value) == 0) {
self::$errCode = '0812';
self::$errMsg = 'sku or amount error';
throw new Exception('sku or amount error');
}
$singSkuAmount = $value * $amount;
//echo '$key == '.$key.'<br/>';
//echo '$singSkuAmount == '.$singSkuAmount.'<br/>';
$tName = 'wh_shipping_orderdetail';
$set = "SET shipOrderId='{$shipOrderId}',combineSku='{$sku}',combineNum='{$amount}',sku='{$key}',\n\t\t\t\t\t\t amount='{$singSkuAmount}',storeId='{$storeId}' ";
$insertDetailId = WhIoStoreModel::addTNameRow($tName, $set);
if (!$insertDetailId) {
self::$errCode = '0802';
self::$errMsg = 'add shipOrderDetail1 error';
throw new Exception('add shipOrderDetail1 error');
}
}
} else {
$tName = 'wh_shipping_orderdetail';
$set = "SET shipOrderId='{$shipOrderId}',sku='{$sku}',\n\t\t\t\t\t amount='{$amount}',storeId='{$storeId}' ";
$insertDetailId = WhIoStoreModel::addTNameRow($tName, $set);
//echo'++++++++++++++++++++++++++';
//echo '$insertDetailId========='.$insertDetailId.'<br/>';
if (!$insertDetailId) {
self::$errCode = '0822';
self::$errMsg = 'add shipOrderDetail2 error';
throw new Exception('add shipOrderDetail2 error');
}
}
}
//插入发货单和属性关系表
//echo '$orderAttributes=======';
//print_r($orderAttributes);
//echo'<br/>';
$tName = 'wh_order_attributes_relation';
foreach ($orderAttributes as $orderAttribute) {
if ($orderAttribute != 1 && $orderAttribute != 2) {
self::$errCode = '0805';
self::$errMsg = 'orderAttribute error';
throw new Exception('orderAttribute error');
}
$set = "SET shippingOrderId='{$shipOrderId}',attributeId='{$orderAttribute}'";
$insertARId = WhIoStoreModel::addTNameRow($tName, $set);
//echo'++++++++++++++++++++++++++';
//echo '$insertARId========='.$insertARId.'<br/>';
if ($insertARId !== 0) {
self::$errCode = '0806';
self::$errMsg = 'add insertARId error';
throw new Exception('add insertARId error');
}
}
//插入订单发货单关系表
$tName = 'wh_shipping_order_relation';
$set = "SET originOrderId='{$originOrderId}',shipOrderId='{$shipOrderId}',recordNumber='{$recordNumber}',storeId='{$storeId}' ";
$insertRelationId = WhIoStoreModel::addTNameRow($tName, $set);
if (!$insertRelationId) {
self::$errCode = '0803';
self::$errMsg = 'add relation error';
throw new Exception('add relation error');
}
TransactionBaseModel::commit();
TransactionBaseModel::autoCommit();
self::$errCode = '222';
self::$errMsg = "success";
return 1;
} catch (Exception $e) {
TransactionBaseModel::rollback();
TransactionBaseModel::autoCommit();
self::$errCode = '404';
self::$errMsg = $e->getMessage();
return 0;
}
}
function act_updateTNameRow()
{
$jsonArr = isset($_GET['jsonArr']) ? $_GET['jsonArr'] : '';
//传过来的base64编码的json字符串
if (empty($jsonArr)) {
self::$errCode = 101;
self::$errMsg = '参数数组为空';
return false;
}
$jsonArr = json_decode(base64_decode($jsonArr), true);
//对base64及json解码
if (!is_array($jsonArr)) {
self::$errCode = 103;
self::$errMsg = '参数数组不是数组格式';
return false;
}
$tName = $jsonArr['tName'];
//表名
$set = $jsonArr['set'];
//set，用关键字SET
$where = $jsonArr['where'];
//where,要带上关键字WHERE
if (empty($tName) || empty($set) || empty($where)) {
self::$errCode = '300';
self::$errMsg = '必要参数不完整';
return false;
}
$affectRows = WhIoStoreModel::updateTNameRow($tName, $set, $where);
if ($affectRows !== FALSE) {
self::$errCode = '200';
self::$errMsg = '成功';
return $affectRows;
} else {
self::$errCode = '404';
self::$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;
}
function act_updateWhIoStoreStatus()
{
$id = isset($_GET['id']) ? $_GET['id'] : '';
//id
$ioStatus = $_GET['ioStatus'];
//待修改数量的sku
if (empty($id)) {
self::$errCode = 0101;
self::$errMsg = 'empty id';
return 0;
}
if (!isset($_GET['ioStatus'])) {
self::$errCode = 0201;
self::$errMsg = 'unset ioStatus';
return 0;
}
$ioStatus = intval($ioStatus);
if ($ioStatus != 0 && $ioStatus != 1) {
self::$errCode = 0301;
self::$errMsg = 'illegal ioStatus';
return 0;
}
$tName = 'wh_iostore';
$set = "SET ioStatus='{$ioStatus}' ";
$where = "WHERE id='{$id}' ";
$affectRows = WhIoStoreModel::updateTNameRow($tName, $set, $where);
if ($affectRows === FALSE) {
//执行错误或者无affectedRow
self::$errCode = 0401;
self::$errMsg = 'updateRow error';
return 0;
} else {
self::$errCode = 200;
self::$errMsg = 'success';
return $affectRows;
}
}
public function view_scanUpdateAuditList()
{
$whAuditAct = new WhAuditAct();
$id = isset($_GET['id']) ? post_check($_GET['id']) : '';
if (empty($id)) {
//id为空时，跳转到列表页面，输出错误信息
$status = '找不到要修改记录的id';
header("location:index.php?mod=whAudit&act=getWhAuditList&status={$status}");
exit;
}
$where = "WHERE id={$id} ";
$whAuditList = $whAuditAct->act_getTNameList('wh_audit_relation_list', '*', $where);
if (empty($whAuditList)) {
$status = '找不到要修改记录的id';
header("location:index.php?mod=whAudit&act=getWhAuditList&status={$status}");
exit;
} else {
$value = $whAuditList[0];
}
//设置修改页面上指定字段的值
$navlist = array(array('url' => 'index.php?mod=goodsInfo&act=showSearchForm', 'title' => '仓库'), array('url' => 'index.php?mod=whAudit&act=getWhAuditList', 'title' => '审核列表'), array('url' => '', 'title' => '修改审核列表记录'));
$usermodel = UserModel::getInstance();
//审核人
$user_info = $usermodel->getGlobalUserLists('global_user_name', "where a.global_user_id='{$value['auditorId']}'", '', 'limit 1');
$auditorName = $user_info[0]['global_user_name'];
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toptitle', '修改审核列表记录');
$this->smarty->assign('toplevel', 3);
$this->smarty->assign('secondlevel', '011');
$this->smarty->assign("id", $value['id']);
$this->smarty->assign("invoiceTypeId", $value['invoiceTypeId']);
$this->smarty->assign("auditorName", $auditorName);
$this->smarty->assign("auditorId", $value['auditorId']);
$this->smarty->assign("auditLevel", $value['auditLevel']);
$this->smarty->assign("is_enable", $value['is_enable']);
$this->smarty->assign("storeId", $value['storeId']);
$this->smarty->assign("invoiceTypeName", WhIoStoreModel::getInvoiceTypeNameById($value['invoiceTypeId']));
$this->smarty->assign("whName", WhIoStoreModel::getWhNameById($value['storeId']));
$this->smarty->display("whUpdateAuditList.htm");
}
