form.parse(req, function(err, fields) {
if(err){
console.log(err);
return;
}
//var updateTime = (new Date()).valueOf(); //时间戳
var updateTime = sd.format(new Date(), 'YYYY-MM-DD HH:mm:ss');
fields.updateTime = updateTime;
fields.username = req.session.username;
var login = true;
data.goAvatar(login,fields.username,function(err,results){
if(err){
next();
return;
}
fields.avatar = '/uploads/avatar/' + results.result[0].avatar;
data.savaTalk(fields,function(err,msg){
if(err){
next();
return;
}
if(msg){
res.send(true);
}
});
});
});
mkdirs(`${process.cwd()}/apps/${uid}/${appid}`, '0777', (d) => {
// 保存文件
saveToHtmlFile(req.body.shtml, ph);
// 保存sql
updateSQL('h5ds_apps', {
id: {
type: Sequelize.INTEGER,
primaryKey: true
},
name: {
type: Sequelize.CHAR
},
url: {
type: Sequelize.CHAR
},
pic: {
type: Sequelize.CHAR
},
des: {
type: Sequelize.CHAR
},
date: {
type: Sequelize.CHAR
},
data: {
type: Sequelize.TEXT('long')
}
}, {
name: req.body.name,
url: ph + '/index.html',
pic: req.body.pic,
des: req.body.des,
date: sd.format(new Date(), 'YYYY/MM/DD HH:mm:ss'),
data: req.body.data
}, {
owner: uid,
id: appid
}, (ret) => {
if (ret) {
result(req, res, {
code: 200,
data: ph + '/index.html',
msg: "成功",
success: true
});
} else {
// 返回值
result(req, res, {
code: 500,
data: ret,
msg: "失败",
success: false
})
}
});
});
app.all('*', function(req, res, next) {
res.header("Access-Control-Allow-Origin", "*");
res.header("Access-Control-Allow-Headers", "X-Requested-With,Authorization");
res.header("Access-Control-Allow-Methods","PUT,POST,GET,DELETE,OPTIONS");
res.header("X-Powered-By",' 3.2.1');
res.header("Content-Type", "application/json;charset=utf-8");
var time=sd.format(new Date(), 'YYYY-MM-DD HH:mm');
console.log(time);
next();
});
function createTimeStamp() {
//生成由 年月日时分秒+“0——f”内任意6位构成的随机数，前面14位，后面6位，共20位随机数
var date = new Date();
var timestamp = sd.format(date, 'YYYYMMDDHHmmss');
var random = '0123456789abcdef';
var length = random.length;
for (var i = 0; i < 6; i++) {
timestamp += random[Math.floor(Math.random() * length)];
}
return timestamp;
}
form.parse(req, function(err, fields, files,next) {
if(err){next();return;}
console.log(fields);
console.log(files);
var nowDate=sd.format(new Date(), 'YYYYMMDDHHmm');
var random=parseInt(Math.random()*89999+10000);
var oldPath=files.pic.path;
var extName=path.extname(files.pic.name);
var newPath=path.normalize(__dirname+'/../uploads/'+fields.files+'/'+nowDate+random+extName);
fs.rename(oldPath,newPath,function(err){
if(err){next();return;};
res.send('success')
})
});
// function gets(){
// }
/**
* @param {[type]} 目标主题的html
* @param {[type]} post的url
* @return {[type]}
*/
function tiebaDateAnalysis(targetLi,postUrl){
//原版字符串
var dateString = $(".is_show_create_time",targetLi).text().trim();
//只有时间的说明是今天 返回日期加时间
if(dateString.indexOf(":") > -1){
var postDate = sd.format(new Date(),"YYYY-MM-DD");
//console.log(postDate);
return postDate + " " + dateString;
}//格式"月份-日期" 获取其年份
else if(dateString.indexOf("-") > -1){
//将进入post内部搜索
var $post = initPageObject(postUrl);
var postDate = $post(".tail-info",$post("#j_p_postlist div").first().html()).last().text();
return postDate;
}
}
router.post('/addBlog', function(req, res, next){
var _id = req.body.id,
_title = req.body.title,
_blockquote = req.body.blockquote,
_body = req.body.body,
_time = sd.format(new Date(), 'YYYY.MM.DD HH:mm'),
_query = { author: _id, title: _title, blockquote: _blockquote, body: _body, createTime: _time };
db.createBlog(_query, function(err, doc){
if(err){
console.log('not find, and err is ', err)
} else{
if(doc ===null || doc.length === 0){
res.json({status:1,message:"no data",data:[]})
} else{
res.json({status:0,message:"",data:doc})
}
}
})
})
router.post('/addComment', function(req, res, next){
var _id = req.body.id,
_type = req.body.type,
_articleId = req.body.articleId,
_body = req.body.body,
_time = sd.format(new Date(), 'YYYY-MM-DD HH:mm'),
_query = { authorId: _id, type: _type, articleId: _articleId, body: _body, createTime: _time };
db.createComment(_query, function(err, doc){
if(err){
console.log('not create, and err is ', err)
return next(err);
} else{
if(doc ===null || doc.length === 0){
res.json({status:1,message:"no data",data:[]})
} else{
res.json({status:0,message:"",data:doc})
}
}
})
})
var C = function(){
for(var i=0;i<arguments.length;i++){
console.log(arguments[i]);
}
};
//
var sd = require('silly-datetime');
var ttt = sd.format(new Date(),"YYYYMMDDHHmm");
var c = "#ff0000";
const express = require('express')
const router = express.Router()
const dbConfig = require('../db/dbConfig')
const mysql = require('mysql')
const sd = require('silly-datetime')
const time = sd.format(new Date(), 'YYYY-MM-DD HH:mm:ss')
const pool = mysql.createPool(dbConfig.mysql)
let responseJSON = function (res, ret) {
if (typeof ret === 'undefined') {
res.json({
code: '-200', msg: '操作失败'
})
} else {
res.json(ret)
}
}
// 有关新闻信息的接口
// 获取关注数据接口 根据id 先后排序
router.get('/focus', (req, res, next) => {
pool.getConnection((err, connection) => {
let param = req.query
let sql = 'select * ' +
' from w_news as a' +
' left join w_theme as b' +
' on b.c_type = a.theme' +
' where a.img <> \'\' and a.id >= (select floor(RAND() * (SELECT MAX(id) FROM `w_news`)))' +
' group by a.id ' +