public function act_ordererpupdateStatus() { $orderid_arr = $_POST['orderid_arr']; $ostatus = $_POST['ostatus']; $otype = $_POST['otype']; if (!$ostatus) { self::$errCode = "001"; self::$errMsg = "ostatus is null"; return false; } if (!$otype) { self::$errCode = "002"; self::$errMsg = "otype is null"; return false; } $idArr = $_POST['idArr']; $idStr = ""; if (is_array($idArr)) { $idStr = " AND id in (" . join(',', $idArr) . ") "; } $table = 'om_unshipped_order'; $fields = '*'; $storeId = 1; $where = " WHERE is_delete = '0' {$idStr} AND orderStatus = {$ostatus} AND orderType = {$otype} "; $rtn = OrderPushModel::listPushOneMessage($orderValue); //$data = OldsystemModel::ordererpupdateStatus($orderId,$ebay_status,$final_status); return $data; }
public static function applyPartPrint($orderid_arr, $ostatus, $otype, $flag, $storeId = 1) { self::initDB(); if (!isset($_SESSION['sysUserId'])) { self::$errCode = "400"; self::$errMsg = "登陆过期!"; return false; } $tableName = "om_unshipped_order"; //var_dump($orderid_arr); exit; if (!$orderid_arr) { self::$errCode = "300"; self::$errMsg = "传值失败!"; return false; } $where = " WHERE is_delete = 0 AND storeId = {$storeId} "; if ($ostatus) { $where .= ' and orderStatus = ' . $ostatus; } if ($otype) { $where .= ' and orderType = ' . $otype; } $accountList = $_SESSION['accountList']; $platformList = $_SESSION['platformList']; //echo "<pre>"; print_r($accountList); exit; $platformsee = array(); for ($i = 0; $i < count($platformList); $i++) { $platformsee[] = $platformList[$i]; } if ($platformsee) { $where .= ' AND platformId IN (' . join(",", $platformsee) . ') '; } else { self::$errCode = "500"; self::$errMsg = "无申请权限!"; return false; } $accountsee = array(); for ($i = 0; $i < count($accountList); $i++) { $accountsee[] = $accountList[$i]; } if ($accountsee) { $where .= ' AND accountId IN (' . join(",", $accountsee) . ') '; } else { self::$errCode = "600"; self::$errMsg = "无申请权限!"; return false; } $where .= ' AND id in (' . join(',', $orderid_arr) . ') '; //基础信息 /*$sql = "SELECT id FROM ".self::$table_order.$where; //echo $sql; echo "<br>"; $query = self::$dbConn->query($sql); $orderids = self::$dbConn->fetch_array_all($query); foreach($orderids as $value){ $orderid = $value['id']; self::limitApplyPrintInfo($orderid); }*/ //$where = " WHERE id in (".join(',',$orderids).") AND orderStatus = ".C('STATESHIPPED'); $returnStatus0 = array('orderStatus' => C("STATESHIPPED"), 'orderType' => C('STATESHIPPED_APPLYPRINT')); if (OrderindexModel::updateOrder($tableName, $returnStatus0, $where)) { self::$errCode = "200"; self::$errMsg = "申请打印成功!"; return true; } else { self::$errCode = "002"; self::$errMsg = "申请打印失败!"; return false; } /*foreach($orderids as $value){ //echo $value['id']."---".$flag; echo "<br>"; self::listPushMessage($value['id'],$flag); }*/ }
$ordersql = 'SELECT a.id FROM ' . $tableName . ' AS a LEFT JOIN ' . $tableName . '_detail AS b ON b.omOrderId = a.id WHERE a.orderStatus = ' . C('STATESHIPPED') . ' AND a.orderType = ' . C('STATESHIPPED_APPLYPRINT') . ' AND a.is_delete = 0 AND a.storeId= ' . $storeId . $limit; //echo $ordersql; echo "<br>"; //exit; $query = $dbConn->query($ordersql); $orders = $dbConn->fetch_array_all($query); if (!empty($orders)) { foreach ($orders as $value) { $omOrderId = $value['id']; if (OrderPushModel::listPushMessage($omOrderId)) { echo "=====[" . date('Y-m-d H:i:s', $time_start) . "]订单{$omOrderId}同步成功======\n"; } else { echo "=====[" . date('Y-m-d H:i:s', $time_start) . "]订单{$omOrderId}同步失败,原因:" . OrderPushModel::$errMsg . "======\n"; $CommonAct->act_ApplicationException($omOrderId, OrderPushModel::$errMsg); } } } else { echo "=====没有同步的订单======\n"; } $page++; } $time_end = time(); echo "\n=====[耗时:" . ceil(($time_end - $time_start) / 60) . "分钟]====\n"; echo "\n=====[" . date('Y-m-d H:i:s', $time_end) . "]系统【推送打印数据给仓库系统】订单结束\n"; exit;
/** * OrderPushAct::申请部分打印() * * @return bool */ public function act_applyPartPrint() { $orderid_arr = isset($_POST["orderid_arr"]) ? $_POST["orderid_arr"] : ''; $ostatus = isset($_POST["ostatus"]) ? intval($_POST["ostatus"]) : ''; $otype = isset($_POST["otype"]) ? intval($_POST["otype"]) : ''; $flag = isset($_POST["flag"]) ? intval($_POST["flag"]) : 2; /*if (!$ostatus) { self::$errCode = "1001"; self::$errMsg = "无一级状态"; return false; }*/ $result = OrderPushModel::applyPartPrint($orderid_arr, $ostatus, $otype, $flag); self::$errCode = OrderPushModel::$errCode; self::$errMsg = OrderPushModel::$errMsg; return $result; }
/** * 申请打印订单 * @author czq */ public function act_applyAllPrintOrder() { $orderid_arr = $_POST['orderid_arr']; //整个文件夹打印 $order_status = $_POST['ostatus']; $order_type = isset($_POST['otype']) ? $_POST['otype'] : ''; $flag = isset($_POST['flag']) ? $_POST['flag'] : ''; if (empty($order_status) || empty($order_type)) { self::$errMsg[10100] = get_promptmsg(10100); return false; } $idStr = ""; if (is_array($idArr)) { $idStr = " AND id in (" . join(',', $idArr) . ") "; } $table = 'om_unshipped_order'; $fields = '*'; $storeId = 1; $where = " WHERE is_delete = '0' {$idStr} AND orderStatus = {$ostatus} AND orderType = {$otype} "; /**队列推送到仓库,预留**/ $rtn = OrderPushModel::listPushOneMessage($orderValue); return $rtn; }