public static function applyTheLineEUBTrackNumber($recordnumber, $tracknumber) { !self::$dbConn ? self::initDB() : null; $SYSTEM_ACCOUNTS = OmAvailableModel::getPlatformAccount(); $accountIds = array(); foreach ($SYSTEM_ACCOUNTS['Amazon'] as $id => $account) { $accountIds[] = $id; } //print_r($SYSTEM_ACCOUNTS['Amazon']); $tableName = 'om_unshipped_order'; $where = " WHERE recordNumber='{$recordnumber}' AND accountId in ('" . join("','", $accountIds) . "') AND is_delete =0 AND storeId=1 "; $tinfo = OrderindexModel::showOnlyOrderList($tableName, $where); self::$errMsg = ''; if ($tinfo) { $omOrderId = $tinfo[0]['id']; $trackinfo = OrderindexModel::selectOrderTracknumber(" WHERE tracknumber = '" . $tracknumber . "' AND is_delete = 0 "); //var_dump($trackinfo); if ($trackinfo) { self::$errCode = "001"; self::$errMsg = " 第" . $row . "行已经存在跟踪" . $tinfo['ebay_tracknumber'] . " 新跟踪号[{$tracknumber}]更新失败<br>"; return false; } else { $data['omOrderId'] = $omOrderId; $data['tracknumber'] = $tracknumber; $data['addUser'] = $_SESSION['sysUserId']; $data['createdTime'] = time(); $msg = OrderRecordModel::insertOrderTrackRow($data); //echo $msg; if (!$msg) { self::$errCode = "001"; self::$errMsg = " 第" . $row . "行订单号[{$recordnumber}]添加跟踪号[{$tracknumber}]失败<br>"; return false; } } self::$errCode = "200"; self::$errMsg = "获取数据成功"; return true; //失败则设置错误码和错误信息, 返回false } else { self::$errCode = "001"; self::$errMsg = " 第" . $row . "行订单号[{$recordnumber}]不是亚马孙订单或者不存在系统<br>"; return false; } }
public function act_getMarketTimeAPI() { $omOrderId = !empty($_GET['omOrderId']) ? $_GET['omOrderId'] : ''; if (!$omOrderId) { self::$errCode = '006'; self::$errMsg = 'have no omOrderId'; return false; } $where = " id = " . $omOrderId . " AND is_delete = 0 AND storeId = 1 "; $tableName = "om_shipped_order"; $orderlist = OrderindexModel::showOnlyOrderList($tableName, $where); if ($orderlist) { self::$errCode = '007'; self::$errMsg = 'have no info'; return array($orderlist[0]['marketTime'], $orderlist[0]['ShippedTime']); } else { self::$errCode = '007'; self::$errMsg = 'have no info'; return false; } }