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;
}
}
