Merge branch 'master' of http://nonxin.cn:8090/r/product/product-server-administration/V2.0.0
| | |
| | | public DataTableEntity listModel(FieldSetEntity fse) { |
| | | String curUserID = SpringMVCContextHolder.getCurrentUserId(); |
| | | StringBuilder sql = new StringBuilder(256); |
| | | sql.append("\nselect uuid,name,date_format(created_utc_datetime,'%Y-%m-%d %H:%i:%s') created_utc_datetime,type from ("); |
| | | sql.append("\n select uuid,name,created_utc_datetime,0 type from product_oa_cooperates_template where created_by=? and created_by<>1"); |
| | | sql.append("\nselect uuid,name,date_format(created_utc_datetime,'%Y-%m-%d %H:%i:%s') created_utc_datetime,created_by,type from ("); |
| | | sql.append("\n select uuid,name,created_utc_datetime,created_by,0 type from product_oa_cooperates_template where created_by=? and created_by<>1"); |
| | | sql.append("\n union all"); |
| | | sql.append("\n select uuid,name,created_utc_datetime,1 type from product_oa_cooperates_template where find_in_set(?,share_user)>0 and created_by<>1 and created_by<>?"); |
| | | sql.append("\n select uuid,name,created_utc_datetime,created_by,1 type from product_oa_cooperates_template where find_in_set(?,share_user)>0 and created_by<>1 and created_by<>?"); |
| | | sql.append("\n union all"); |
| | | sql.append("\n select uuid,name,created_utc_datetime,2 type from product_oa_cooperates_template where created_by=1"); |
| | | sql.append("\n select uuid,name,created_utc_datetime,created_by,2 type from product_oa_cooperates_template where created_by=1"); |
| | | sql.append("\n) t"); |
| | | sql.append("\norder by created_utc_datetime desc"); |
| | | return baseDao.listTable(sql.toString(), new Object[]{curUserID, curUserID, curUserID}); |