| | |
|---|
| | | left join sys_user as fir on fir.id=oa.first_user |
|---|
| | | left join base_meta as bm on sr.product_home = bm.id |
|---|
| | | where oa.valid_flag = 1 |
|---|
| | | and sr.valid_flag = 1 |
|---|
| | | <include refid="queryWhereSql"/> |
|---|
| | | order by oa.create_time desc |
|---|
| | | <if test="first != null and pageSize != null"> |
|---|
| | |
|---|
| | | left join sys_user as sys on sys.id=oa.before_approve_user_id |
|---|
| | | left join sys_user as fir on fir.id=oa.first_user |
|---|
| | | left join base_meta as bm on sr.product_home = bm.id |
|---|
| | | where oa.valid_flag = 1 |
|---|
| | | where oa.valid_flag = 1 and sr.valid_flag = 1 |
|---|
| | | <include refid="queryWhereSql"/> |
|---|
| | | </select> |
|---|
| | | |
|---|
