$actualWeight = $data['actualWeight']; $tracknumber = trim($data['tracknumber']); $orderids = CombinePackageModel::selectAllRecordByOrderId($orderid); var_dump($orderid . "-------" . $orderStatus); echo "\n"; if (C($orderStatus) == 2) { //已发货状态 $where = " WHERE id in (" . join(',', $orderids) . ") AND orderStatus = " . C('STATESHIPPED'); $returnStatus0 = array('orderStatus' => C("STATESHIPPED"), 'orderType' => C('STATEHASSHIPPED_CONV')); if (OrderindexModel::updateOrder($tableName, $returnStatus0, $where)) { echo "\n=====同步的订单{$orderid}状态成功======\n"; } $msg = CommonModel::updateWarehouseInfo($orderid, 2, $operateUserId, $operateTime, $actualWeight); if ($msg) { $where = ' WHERE id in (' . join(",", $orderids) . ') AND orderStatus= ' . C('STATESHIPPED') . ' AND orderType= ' . C('STATEHASSHIPPED_CONV') . ' AND is_delete = 0 '; if (OrderindexModel::shiftOrderList($where)) { echo "转移成功\n"; } else { echo "转移失败\n"; } } } else { $where = " WHERE id in (" . join(',', $orderids) . ") AND orderStatus = " . C('STATESHIPPED'); $returnStatus0 = array('orderType' => C($orderStatus)); if (OrderindexModel::updateOrder($tableName, $returnStatus0, $where)) { echo "\n=====同步的订单{$orderid}状态成功======\n"; } $msg = commonModel::updateWarehouseInfo($orderid, C($orderStatus), $operateUserId, $operateTime); if ($tracknumber) { $updateArr = array('omOrderId' => $orderid, 'tracknumber' => $tracknumber, 'createdTime' => time()); $msg = OrderAddModel::insertOrderTrackRow($updateArr);
echo $account." add error!\n"; } }*/ } exit; $tableName = "om_account"; /*$db_config = C("DB_CONFIG"); $dbConn = new mysql(); $dbConn->connect($db_config["master1"][0],$db_config["master1"][1],$db_config["master1"][2],''); $dbConn->select_db($db_config["master1"][4]);*/ //echo ' [x] ', json_decode($msg->body), "\n"; //var_dump($msg->body); echo "\n"; $where = ' WHERE orderStatus = 100 and orderType in(101,110) and is_delete = 0 and storeId = 1 '; $orderNum = OrderindexModel::showOrderNum($tableName, $where); echo $orderNum; echo "\n"; $page = 1; $perpage = 1000; $totalpage = ceil($orderNum / $perpage); while ($page <= $totalpage) { echo "总共{$totalpage}页---现在是第{$page}页\n"; //$start_num = ($page-1)*$perpage; $start_num = 0; $limit = " ORDER BY id LIMIT {$start_num}, {$perpage}"; if (OrderindexModel::shiftOrderList($where . $limit)) { echo "转移成功\n"; } else { echo "转移失败\n"; } $page++; }