角色 __XLjD79Km8j8pkSHjTTv __XLjD79Km8j8pkSHjTTv published UTF-8 post /event/role json 0){ result.put("isProjectManager",true); }else{ result.put("isProjectManager",false); } //是否有岗点负责人 var sql2="select 1 from tlk_event_post_manager m INNER JOIN tlk_event_post post on m.item_post_id=post.id inner join tlk_event_project p on p.id=post.item_project_id where m.item_person_id='"+person_id+"' and DATE_FORMAT(now(), '%Y-%m-%d') <= DATE_FORMAT(DATE_ADD(p.ITEM_project_end_time, INTERVAL 1 DAY), '%Y-%m-%d'); " var datas2 = queryByDSName("baibaodunFlow",sql2); if(datas2.size()>0){ result.put("isPostManager",true); }else{ result.put("isPostManager",false); } //所在组织是否加入项目 var sql3="select 1 from tlk_event_team m INNER JOIN tlk_event_project p on p.id=m.item_project_id where m.item_team_id='"+team_id+"' and DATE_FORMAT(now(), '%Y-%m-%d') <= DATE_FORMAT(DATE_ADD(ITEM_project_end_time, INTERVAL 1 DAY), '%Y-%m-%d');" var datas3 = queryByDSName("baibaodunFlow",sql3); if(datas3.size()>0){ result.put("isJoinProject",true); }else{ result.put("isJoinProject",false); } //所在组织是否创建项目 var sql4="select 1 from tlk_event_project p where p.item_domain_id='"+team_id+"' and DATE_FORMAT(now(), '%Y-%m-%d') <= DATE_FORMAT(DATE_ADD(ITEM_project_end_time, INTERVAL 1 DAY), '%Y-%m-%d');" var datas4 = queryByDSName("baibaodunFlow",sql4); if(datas4.size()>0){ result.put("isCreateProject",true); }else{ result.put("isCreateProject",false); } result.put("code","200"); result.put("msg","OK"); result.put("state", true); return result; } })()]]>