public static function updateOrder($orderid)
{
self::initDB();
$sql = "UPDATE om_unshipped_order SET orderStatus=" . C('STATEPENDING') . ", orderType=" . C('STATEPENDING_CONV') . ", combinePackage=0 WHERE id={$orderid}";
//echo $sql; echo "<br>";
$query = self::$dbConn->query($sql);
if ($query) {
OrderLogModel::orderLog($orderid, $sql, "更新订单");
return true;
} else {
return false;
}
}
public static function updateOrder($tableName, $data, $where)
{
self::initDB();
$string = array2sql($data);
$sql = "UPDATE " . $tableName . " SET " . $string . " " . $where;
if (isset($data['orderType'])) {
$info = explode("=", $where);
$orderid = $info[1];
OrderLogModel::orderLog($orderid, $sql, "更新" . $tableName, $data['orderType']);
} else {
$info = explode("=", $where);
$orderid = $info[1];
OrderLogModel::orderLog($orderid, $sql, "更新" . $tableName);
}
$query = self::$dbConn->query($sql);
if ($query) {
self::$errCode = "200";
self::$errMsg = "update success";
return true;
} else {
self::$errCode = "004";
self::$errMsg = "update error";
return false;
}
}
/**
* 插入跟踪号信息
* @para $data as array
* return true
*/
public static function insertOrderTrackRow($data)
{
self::initDB();
$string = array2sql_extral($data);
$sql = "INSERT INTO `om_order_tracknumber` SET " . $string;
$query = self::$dbConn->query($sql);
if ($query) {
$orderid = $data['omOrderId'];
OrderLogModel::orderLog($orderid, $sql, "插入跟踪号");
return true;
} else {
self::$errCode = "003";
self::$errMsg = "error";
return false;
}
}
