小黑小波比.服务端js的sql写在task外在task内调用task外的sql语句-CSDN博客

2019独角兽企业重金招聘Python工程师标准>>>

app/more/publish.js

1.在服务端js中添加task.sql{};

task.sql = {
    "modules":{
        sql:"select * from (select * from publisher p left join subscriber s on p.pcode=s.pubcode where status='0' and pubmode=:mode limit '20' offset :start) t order by t.level asc"
    },
    "subscrib":{
        sql:"update subscriber set status=1 where ucode=:pcode"
    },
    "subcancel":{
        sql:"update subscriber set status=0 where ucode=:pcode"
    },
    "subread":{
        sql:"select * from (select * from publisher p left join subscriber s on p.pcode=s.pubcode where status='1' and pubcode=:code limit '20' offset :start) t order by t.level asc"
    }
};

2.然后在task.tasks={};调用sql,

var sql = task.sql.modules.sql;

modules:{
    attribute:{

    },
    method:function(e){
        var _=this.apis;
        var sql = task.sql.modules.sql;
        //console.log(task.sql.modules.sql);
        //console.log(sql);
        _.sql.query(sql,{
            start: e.params.start,
            mode: e.params.mode
        }).success(function(row){
            e.result({
                modules:row
            });
        }).failure(function(){
            e.result({
                failure:false
            });
        });
    }
},