public static function getExpressOrderInfo($sellerAccount, $recordnumber, $field, $condition = '')
{
self::initDB();
$sql = "SELECT {$field}\n\t\t\t\t\t\tFROM om_unshipped_order AS a\n\t\t\t\t\t\tLEFT JOIN om_unshipped_order_userInfo AS b ON a.id = b.omOrderId\n\t\t\t\t\t\tLEFT JOIN om_account AS c ON a.accountId = c.id\n\t\t\t\t\t\tWHERE a.recordNumber = '{$recordnumber}' AND c.account='{$sellerAccount}' " . $condition;
//echo $sql;
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
return $ret;
//成功， 返回列表数据
} else {
self::$errCode = "003";
self::$errMsg = "error";
return false;
}
}
