| | |
| | | package com.yeshi.buwan.dao; |
| | | |
| | | import com.yeshi.buwan.dao.base.BaseDao; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | import com.yeshi.buwan.domain.Config; |
| | |
| | | * @return |
| | | */ |
| | | public List<Config> listBySystemIdAndMaxVersion(Long systemId, int maxVersion) { |
| | | List list = sqlList(" SELECT a.* FROM (SELECT * FROM `wk_video_config` vc WHERE vc.`systemId`=? AND vc.`minVersion`<=? ORDER BY vc.`minVersion` DESC) a GROUP BY a.`systemId`,a.`key`", systemId, maxVersion); |
| | | List list = sqlListWithEntity("SELECT a.* FROM (SELECT * FROM `wk_video_config` vc WHERE vc.`systemId`=? AND vc.`minVersion`<=? ORDER BY vc.`minVersion` DESC) a GROUP BY a.`systemId`,a.`key`", Config.class, systemId, maxVersion); |
| | | return list; |
| | | } |
| | | |
| | |
| | | return null; |
| | | } |
| | | |
| | | } |
| | | } |