/** * 写入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 } }