/** 修改点货备注信息**/
public static function update_note($id, $note)
{
self::initDB();
$id = intval(trim($id));
$note = trim($note);
if ($id) {
$sql = "update wh_inventory_records set remark = '{$note}' where id = '{$id}'";
$query = self::$dbConn->query($sql);
if ($query) {
return TRUE;
} else {
self::$errCode = "003";
self::$errMsg = "error";
return FALSE;
}
} else {
self::$errCode = "003";
self::$errMsg = "error";
return FALSE;
}
}
/**
* InventoryAct::act_editInventoryNote()
* 修改点货备注信息
* @return void
*/
public function act_editInventoryNote()
{
$ids = array_map('trim', $_POST['ids']);
$notes = array_map('trim', $_POST['notes']);
foreach ($notes as $k => $note) {
if (!$note) {
continue;
}
$id = intval($ids[$k]);
if ($id) {
InvRecordModel::update_note($id, $note);
}
}
self::$errCode = 0;
self::$errMsg = "更新备注成功";
return TRUE;
}
public function act_markUnusual1()
{
$userId = $_SESSION['userId'];
$orderids = isset($_POST['orderids']) ? $_POST['orderids'] : '';
if (empty($orderids)) {
self::$errCode = 0;
self::$errMsg = '请选择发货单号!';
return;
}
if (!is_numeric($orderids)) {
$tracknumber = $orderids;
$info = orderWeighingModel::selectOrderId($tracknumber);
if (!$info) {
self::$errCode = 501;
self::$errMsg = "此跟踪号不存在！";
return false;
}
$orderids = $info[0]['shipOrderId'];
}
$order_arr = explode(',', $orderids);
OmAvailableModel::begin();
$po_obj = new PackingOrderModel();
$qresult = $po_obj->changeStatusToUnusual($orderids);
if ($qresult) {
foreach ($order_arr as $order) {
$order_info = orderWeighingModel::selectOrderDetail($order);
foreach ($order_info as $o_info) {
$data = array();
$sku_info = InvRecordModel::getSkuInfo($o_info['sku']);
$data = array('sku' => $o_info['sku'], 'applicantId' => $userId, 'applicantionTime' => time(), 'invReasonId' => 4, 'invStatus' => 0, 'systemNums' => $sku_info['actualStock']);
$insertid = WaitInventoryModel::insertRow($data);
if (!$insertid) {
self::$errCode = 0;
self::$errMsg = '标记异常发货单失败！';
OmAvailableModel::rollback();
return false;
}
}
}
self::$errCode = 200;
self::$errMsg = '标记异常发货单成功!';
OmAvailableModel::commit();
return true;
} else {
self::$errCode = 0;
self::$errMsg = '标记异常发货单失败！';
return false;
}
}
