function act_removeRollback()
{
$userId = $_SESSION['userId'];
$time = time();
$shipOrderId = $_POST['order'];
$sku = $_POST['sku'];
$pName = $_POST['pname'];
$scan_record = OmAvailableModel::getTNameList("wh_order_picking_records", "*", "where shipOrderId='{$shipOrderId}' and sku='{$sku}' and pName='{$pName}' and is_delete=0 ");
if (empty($scan_record)) {
self::$errCode = "401";
self::$errMsg = "配货单号 {$shipOrderId} 其中料号 {$sku} 在仓位 {$pName} 的配货记录不存在！";
return false;
} else {
OmAvailableModel::begin();
$amount = $scan_record[0]['amount'];
//配货数量
$sql = "update ebay_order_scan_record set is_show = 1,canceltime='{$mctime}' where ebay_id = '{$ebay_id}' and sku = '{$ebay_sku}' and is_show = 0 ";
$update_record = OmAvailableModel::updateTNameRow("wh_order_picking_records", "set cancelUserId='{$userId}',cancelTime='{$time}',is_delete=1", "where shipOrderId='{$shipOrderId}' and sku='{$sku}' and pName='{$pName}' and is_delete=0");
if (!$update_record) {
self::$errCode = "402";
self::$errMsg = "配货单删除配货记录失败";
return false;
}
$sku_info = OmAvailableModel::getTNameList("pc_goods", "id", "where sku='{$sku}' and is_delete=0");
$position_info = OmAvailableModel::getTNameList("wh_position_distribution", "id", "where pName='{$pName}' and storeId=1");
if (!$position_info || !$sku_info) {
self::$errCode = "403";
self::$errMsg = "配货单删除配货记录失败，找不到对应仓位id或者skuid";
OmAvailableModel::rollback();
return false;
}
$update_product_position = OmAvailableModel::updateTNameRow("wh_product_position_relation", "set nums=nums+'{$amount}'", "where pId={$sku_info[0]['id']} and positionId={$position_info[0]['id']}");
if (!$update_product_position) {
self::$errCode = "404";
self::$errMsg = "配货单删除配货记录失败,更新仓位数量出错";
OmAvailableModel::rollback();
return false;
}
$update_sku_location = OmAvailableModel::updateTNameRow("wh_sku_location", "set actualStock=actualStock+'{$amount}'", "where sku='{$sku}' and storeId=1");
if (!$update_sku_location) {
self::$errCode = "405";
self::$errMsg = "配货单删除配货记录失败,更新库存数量出错";
OmAvailableModel::rollback();
return false;
}
self::$errMsg = "配货单删除配货记录成功";
OmAvailableModel::commit();
return false;
}
}
public function view_inquiry()
{
$starttime = date('Y-m-d ') . ' 09:00:00';
$now_time = date("Y-m-d H:i:s", time());
$startdate = isset($_POST['startdate']) ? post_check($_POST['startdate']) : $starttime;
$enddate = isset($_POST['enddate']) ? post_check($_POST['enddate']) : $now_time;
$pda_user = isset($_POST['pda_user']) ? post_check($_POST['pda_user']) : 0;
$weigh_scan_user = isset($_POST['weigh_scan_user']) ? post_check($_POST['weigh_scan_user']) : 0;
$orderid = isset($_POST['orderid']) ? post_check($_POST['orderid']) : '';
$action = isset($_POST['action']) ? post_check($_POST['action']) : '';
$PdaManagementAct = new PdaManagementAct();
if (!empty($action)) {
switch ($action) {
case 'search':
$search_info = $PdaManagementAct->act_getPickingInfo($startdate, $enddate, $pda_user);
$this->smarty->assign('pda_user', $pda_user);
$this->smarty->assign('serch_info', $search_info);
break;
case 'search_scan_recheck':
$search_info = $PdaManagementAct->act_getReviewInfo($startdate, $enddate, $pda_user);
$this->smarty->assign('pda_user', $pda_user);
$this->smarty->assign('serch_info', $search_info);
break;
case 'packge_search':
$search_info = $PdaManagementAct->act_getPackageInfo($startdate, $enddate, $pda_user);
$this->smarty->assign('pda_user', $pda_user);
$this->smarty->assign('serch_info', $search_info);
break;
case 'search_scan_weigh':
$search_info = $PdaManagementAct->act_getWeighInfo($startdate, $enddate, $weigh_scan_user);
$this->smarty->assign('weigh_scan_user', $weigh_scan_user);
$this->smarty->assign('serch_info', $search_info);
break;
case 'search_info1':
$search_info = $PdaManagementAct->act_getGroupInfo($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info2':
$search_info = $PdaManagementAct->act_searchPickingInfo($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info3':
$search_info = $PdaManagementAct->act_searchReviewInfo($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info4':
$search_info = $PdaManagementAct->act_searchPackageInfo($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info5':
$search_info = $PdaManagementAct->act_searchWeighInfo($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info6':
//查询订单分区扫描记录
$search_info = $PdaManagementAct->act_searchPartionInfo($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info7':
//分拣记录
$search_info = $PdaManagementAct->act_searchSortingInfo($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info8':
//装车扫描纪录
$search_info = $PdaManagementAct->act_searchLoading_express($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info9':
//分区复核记录
$search_info = $PdaManagementAct->act_searchReview($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info10':
//发货组复核记录
$search_info = $PdaManagementAct->act_searchGroupReview($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info11':
//查询包裹下订单信息
$search_info = $PdaManagementAct->act_searchOrderToPackage($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info12':
//查询配货单配货记录
$search_info = $PdaManagementAct->act_search_scan_record($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
case 'search_info13':
//查询发货单分拣信息
$search_info = $PdaManagementAct->act_search_order_pick($orderid);
$this->smarty->assign('orderid', $orderid);
$this->smarty->assign('serch_record', $search_info);
break;
}
}
//包装员
$usermodel = UserModel::getInstance();
$picking_info = $usermodel->getGlobalUserLists('global_user_id,global_user_name', "where a.global_user_job=103", '', '');
$this->smarty->assign('picking_info', $picking_info);
//称重员
$Weigh_info = $usermodel->getGlobalUserLists('global_user_id,global_user_name', "where a.global_user_job=126", '', '');
$this->smarty->assign('Weigh_info', $Weigh_info);
$this->smarty->assign('startdate', $startdate);
$this->smarty->assign('enddate', $enddate);
$navlist = array(array('url' => '', 'title' => '出库'), array('url' => 'index.php?mod=pdaManagement&act=inquiry', 'title' => 'pda操作查询'));
$this->smarty->assign('navlist', $navlist);
$toplevel = 2;
//一级菜单的序号 0 开始
$this->smarty->assign('toplevel', $toplevel);
$secondlevel = 210;
//当前的二级菜单
$this->smarty->assign('secondlevel', $secondlevel);
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toptitle', 'pda操作查询');
$this->smarty->assign('curusername', $_SESSION['userName']);
$this->smarty->display('pdaManagement.htm');
}