/**
* 写入LOG日志
* @param $sql //修改订单的SQL语句
* @param $note //修改订单的操作
* @param $omOrderId //订单ID
* @return bool
*/
function orderOperatorLog($sql, $note, $omOrderId)
{
$nowtime = time();
$noteArr = array();
$noteArr['operatorId'] = $_SESSION['sysUserId'] ? $_SESSION['sysUserId'] : 0;
$noteArr['omOrderId'] = $omOrderId;
$noteArr['operatorNote'] = $note;
$noteArr['sql'] = addslashes($sql);
$noteArr['createdTime'] = $nowtime;
$table = C('DB_PREFIX') . 'order_logs';
$fdata = $this->formatInsertField($table, $noteArr);
if ($fdata === false) {
self::$errMsg = $this->validatemsg;
return false;
}
$this->sql("INSERT " . $table . " SET " . array2sql($noteArr))->insert();
}
public static function insertOrderLog($omOrderId, $note)
{
!self::$dbConn ? self::initDB() : null;
//om_order_log
$data = array('operatorId' => $_SESSION['sysUserId'], 'omOrderId' => $omOrderId, 'note' => $note, 'createdTime' => time());
$string = array2sql($data);
//var_dump($string); exit;
$strmctime = date('Y_m', time());
$sql = "INSERT INTO `" . self::$orderLogTable . $strmctime . "` SET " . $string;
//echo $sql; exit;
$query = self::$dbConn->query($sql);
if ($query) {
self::$errCode = "200";
self::$errMsg = "插入成功";
return true;
} else {
self::$errCode = "001";
self::$errMsg = "获取数据失败";
return false;
//失败则设置错误码和错误信息， 返回false
}
}
