myapps的流程的视图的sql语句

最新推荐文章于 2024-04-06 21:20:26 发布

miketom155

最新推荐文章于 2024-04-06 21:20:26 发布

阅读量760

点赞数

分类专栏： Java 文章标签： sql date 公告

本文链接：https://blog.csdn.net/miketom155/article/details/7697170

版权

Java 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

1：拟稿状态的 getStateint() 257 待审核 256 发布成功 1048576 getStateLable;

"select n.ID ,n.PARENT,n.ITEM_TITLE ,n.ITEM_ANNEX,n.domainid ,n.item_send_department,n.item_send_person,n.item_con ,n.flowid,n.item_date ,n.stateint from TLK_NOTICE n where n.item_send_person like '%"+getWebUser().getId()+"%' and n.item_title like '%"+getItemValue("q_title")+"%' and n.item_date >='"+getItemValue("q_date")+"' and n.ITEM_DRAFT_DEPARTMENT ='"+st+"' and n.item_status=1";

待审核的公告的视图

var sql="select t.id,t.domainid,t.parent,t.item_title,t.item_con, t.auditorlist,t.item_date ,t.item_send_person,t.stateint ,t.item_send_department from TLK_NOTICE t where t.AUDITORLIST like '%"+getWebUser().getId()+"%' and t.item_title like '%"+getItemValue("q_title")+"%' and t.item_date >='"+getItemValue("q_date")+"' and t.item_status=1 and item_draft_department='"+st+"'";
sql;

审核成功的的视图的

var sql="select t.id,t.domainid,t.parent,t.item_title,t.item_con, t.auditorlist,t.item_date ,t.item_send_person,t.stateint,t.item_send_department from TLK_NOTICE t where t.stateInt='1048576' and t.item_date between '2012-06-20 16:40' and '2012-08-22 07:30' and t.item_send_department like '%"+st+"%'and t.item_title like '%"+getItemValue("q_title")+"%' and t.item_con like '%"+getItemValue("q_content")+"%'";
sql;