function() {
if(!me().isLogin) return login();
var rs = db().table("info a").join("catalog b on b.id=a.cataid").
where("b.kind=?").page("a.id desc", ~~form("size") || 10, form("page"), [ form("kind") ]).
select("a.id, a.title, a.pv, a.state, a.pubtime, b.name").query();
return { list: rs, pager: db().pager };
}
function() {
if(!me().isLogin) return login();
var id = ~~form("id"), data = new Object;
data.info = !id ? { kind: form("kind") || 0, ext: "{}", pubtime: sys.sTime.getVarDate() } :
db().table("info a left join catalog b on b.id=a.cataid").
where("a.id=@id").select("a.*, b.kind").fetch({ id: id });
if(!data.info) return { err: "信息不存在或已被删除。" };
// 分类列表
data.cata = db().query("select * from catalog where kind=@kind", { kind: data.info.kind });
delete data.info.kind;
if(!data.info.cataid && data.cata[0]) data.info.cataid = data.cata[0].id;
return data;
}
function() {
if(!me().isLogin) return login();
var rs = fromjson(tojson(form()));
var id = ~~rs.id; delete rs.id; delete rs.kind;
rs.state = rs.state == "发布" ? 1 : 0;
return !id ? addnew() : update();
function addnew() { db().insert("info", rs); return { msg: "添加成功" }; }
function update() { db().update("info", rs, { id: id }); return { msg: "更新成功" }; }
}
function() {
if(!me().isLogin) return login();
db().query("delete from info where id=@id", { id: form("id") });
return { msg: "删除成功" };
}