req.on('end', function() {
//console.log("----------------原xml-------------------")
common.xmlToJson(result, function(json) {
var reply = weixin.process_msg(json, res);
if (json.Event == "unsubscribe") {
} else {
res.type(".xml");
res.send(reply);
}
})
});
app.post("/news/save", function(req, res) {
common.upload_file(req, res, function(fields, files) {
fields.content = decodeURIComponent(fields.content);
fields.image = files.length > 0 ? files[0].file.file_name : '';
fields.image1 = files.length > 1 && files[1] ? files[1].file.file_name : '';
fields.image2 = files.length > 2 && files[2] ? files[2].file.file_name : '';
fields.id = +fields.id;
if (fields.id > 0) {
req.emit('getNews', fields);
} else {
req.emit('toSave', fields);
}
}, global.config.upload_path)
req.on('getNews', function(fields) {
var sql = 'select * from tbl_news where id=?';
var param = [fields.id];
db.query(sql, param)
.then(function(d) {
var rows = d.rows;
if (rows && rows.length > 0) {
if (fields.image) {
deleteOneImage(rows[0].image);
} else {
fields.image = rows[0].image;
}
if (fields.image1) {
deleteOneImage(rows[0].image1);
} else {
fields.image1 = rows[0].image1;
}
if (fields.image2) {
deleteOneImage(rows[0].image2);
} else {
fields.image2 = rows[0].image2;
}
}
req.emit('toSave', fields)
}, function(e) {
console.log(e)
e.WriteLog();
})
})
req.on('toSave', function(fields) {
var sql = '';
var params = [];
var now = Date.now();
if (fields.id == 0) {
sql = 'insert into tbl_news(type,title,content,image,image1,image2,createtime,updatetime,footer) values(?,?,?,?,?,?,?,?,?)';
params = [fields.type, fields.title, fields.content, fields.image, fields.image1, fields.image2, now, now, fields.footer]
} else {
sql = 'update tbl_news set title=?,content=?,image=?,image1=?,image2=?,updatetime=?,footer=? where id=?';
params = [fields.title, fields.content, fields.image, fields.image1, fields.image2, now, fields.footer, fields.id]
}
db.query(sql, params)
.then(function(d) {
if (d.rows && (d.rows.insertId > 0 || d.rows.changedRows > 0)) {
res.send({
status: true
})
} else {
res.send({
status: false,
message: "保存失败"
})
}
}, function(e) {
console.log(e)
e.WriteLog();
})
})
});