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