| | |
|---|
| | | sb.append(" SELECT DISTINCT a.uuid,a.start_time,a.end_time,a.meeting_topic,a.record_man,a.record_master,a.status,t.dict_label "); |
|---|
| | | sb.append(" FROM ("); |
|---|
| | | sb.append(" SELECT T1.*, "); |
|---|
| | | sb.append(" SUBSTRING_INDEX( SUBSTRING_INDEX( T1.meeting_resource, ',', T2.digit + 1 ), ',',- 1 ) AS type "); |
|---|
| | | sb.append(UnifySQLFunction.substringIndexFuntion(UnifySQLFunction.substringIndexFuntion("T1.meeting_resource", "','", "T2.digit + 1"), "','", "-1")).append(" AS type "); |
|---|
| | | sb.append(" FROM product_oa_conference_apply T1 "); |
|---|
| | | sb.append(" LEFT JOIN ( SELECT 0 AS digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 ) T2"); |
|---|
| | | sb.append(" ON T2.digit < ( length( T1.meeting_resource )- length( REPLACE ( T1.meeting_resource, ',', '' ))+ 1 )"); |
|---|
| | |
|---|
| | | filter.append(" ) "); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | DataTableEntity dt = baseDao.listTable(fse.getTableName(), filter.toString(), new Object[]{}, null, "ifnull(updated_utc_datetime,created_utc_datetime) desc", fse.getInteger(CmnConst.PAGESIZE), fse.getInteger(CmnConst.CPAGE), false); |
|---|
| | | DataTableEntity dt = baseDao.listTable(fse.getTableName(), filter.toString(), new Object[]{}, null, |
|---|
| | | UnifySQLFunction.ifnullRepalce("IFNULL(updated_utc_datetime,created_utc_datetime) DESC"), |
|---|
| | | fse.getInteger(CmnConst.PAGESIZE), fse.getInteger(CmnConst.CPAGE), false); |
|---|
| | | baseDao.loadPromptData(dt); |
|---|
| | | return dt; |
|---|
| | | } |
|---|
