DspBannerService.java 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249
  1. package com.cloudcross.ssp.service.impl;
  2. import java.util.ArrayList;
  3. import java.util.Date;
  4. import java.util.HashMap;
  5. import java.util.List;
  6. import java.util.Map;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.stereotype.Service;
  9. import com.cloudcross.ssp.base.dao.GenericIBatisDao;
  10. import com.cloudcross.ssp.common.utils.MapBuilder;
  11. import com.cloudcross.ssp.common.utils.Pager;
  12. import com.cloudcross.ssp.model.DspBanner;
  13. import com.cloudcross.ssp.model.Zone;
  14. import com.cloudcross.ssp.service.IDspBannerService;
  15. /**
  16. * 创建人:rongying
  17. * 创建时间:2015.12.11
  18. * dsp-广告主-创意服务接口实现
  19. */
  20. @Service
  21. public class DspBannerService implements IDspBannerService{
  22. @Autowired
  23. private GenericIBatisDao myBatisDao;
  24. /**
  25. * 添加dsp广告主对应的创意
  26. *
  27. * @param list
  28. * 实体对象
  29. * @return <code>true</code>代表成功,否则代表失败。
  30. */
  31. @Override
  32. public boolean add(List<DspBanner> list) {
  33. myBatisDao.save("dspBannerSqlMapper.add", MapBuilder.create(HashMap.class)
  34. .add("dspBannerList",list).map());
  35. return true;
  36. }
  37. /**
  38. * 编辑dsp广告主对应的创意
  39. *
  40. * @param list
  41. * 实体对象
  42. * @return <code>true</code>代表成功,否则代表失败。
  43. */
  44. @Override
  45. public boolean update(List<DspBanner> list) {
  46. myBatisDao.save("dspBannerSqlMapper.update", MapBuilder.create(HashMap.class)
  47. .add("dspBannerList",list).map());
  48. return true;
  49. }
  50. /**
  51. * 获取dsp广告主对应的所有创意
  52. *
  53. * @param map
  54. * 实体对象
  55. * @return 符合条件的列表记录
  56. */
  57. @Override
  58. public List<DspBanner> getAll(Map<String, Object> map) {
  59. return myBatisDao.getList("dspBannerSqlMapper.getAll", map);
  60. }
  61. /**
  62. * 根据条件获取对应的创意
  63. *
  64. * @param map
  65. * 实体对象
  66. * @return 符合条件的列表记录
  67. */
  68. @Override
  69. public List<DspBanner> get(Map<String, Object> map) {
  70. return myBatisDao.getList("dspBannerSqlMapper.get", map);
  71. }
  72. /**
  73. * 查询最大的id - 插入时获取
  74. *
  75. * @param paramMap
  76. * dspId和advertiserId
  77. * @return 下一个id的值
  78. */
  79. @Override
  80. public Long selectMaxId(Map<String, Long> paramMap) {
  81. // TODO Auto-generated method stub
  82. return myBatisDao.get("dspBannerSqlMapper.selectMaxId",paramMap);
  83. }
  84. /**
  85. * 批量查询创意审核的状态
  86. *
  87. * @param paramMap
  88. * bannerIds
  89. * @return 符合条件的记录
  90. */
  91. public List<Map<String,Object>> queryState(Map<String,Object> paramMap){
  92. return myBatisDao.getList("dspBannerSqlMapper.queryState",paramMap);
  93. }
  94. @Override
  95. public int countByParams(HashMap<String, Object> paramMap) {
  96. if(!paramMap.containsKey("searchValue")||paramMap.get("searchValue").equals("")){
  97. paramMap.put("searchValue", null);
  98. }
  99. if(!paramMap.containsKey("backState")||paramMap.get("backState").equals("")){
  100. paramMap.put("backState", null);
  101. }
  102. return myBatisDao.get("dspBannerSqlMapper.countByParams",paramMap);
  103. }
  104. @Override
  105. public List<Map<String, Object>> findByParams(
  106. HashMap<String, Object> paramMap,Pager pager) {
  107. paramMap.put("pager", pager);
  108. return myBatisDao.getList("dspBannerSqlMapper.findByParams", paramMap);
  109. }
  110. @Override
  111. public boolean updatePass(List<Long> auditIdList, int state) {
  112. Date date = new Date();
  113. myBatisDao.save("dspBannerSqlMapper.updateBackPass",
  114. MapBuilder.create(HashMap.class)
  115. .add("auditIdList", auditIdList)
  116. .add("updated", date)
  117. .add("supdated", date.getTime()/1000)
  118. .add("state", state).map());
  119. return true;
  120. }
  121. @Override
  122. public boolean updateNoPass(List<Long> auditIdList, int state, String memo) {
  123. Date date = new Date();
  124. myBatisDao.save("dspBannerSqlMapper.updateBackNoPass",
  125. MapBuilder.create(HashMap.class)
  126. .add("auditIdList", auditIdList)
  127. .add("memo",memo)
  128. .add("updated", date)
  129. .add("supdated", date.getTime()/1000)
  130. .add("state", state).map());
  131. return true;
  132. }
  133. @Override
  134. public List<Map<String, Object>> findByParamMap(Map<String, Object> paramMap) {
  135. return myBatisDao.getList("dspBannerSqlMapper.findByParamMap", paramMap);
  136. }
  137. @Override
  138. public int countByParamsOperator(Long operatorId, HashMap<String, Object> paramMap) {
  139. List<Zone> zoneList = myBatisDao.getList("zoneSqlMapper.findByOperatorIdOperator", operatorId);
  140. paramMap.put("zoneList", zoneList);
  141. if(zoneList.size()==0){
  142. return 0;
  143. }
  144. if(!paramMap.containsKey("searchValue")||paramMap.get("searchValue").equals("")){
  145. paramMap.put("searchValue", null);
  146. }
  147. if(!paramMap.containsKey("operatorChecked")||paramMap.get("operatorChecked").equals("")){
  148. paramMap.put("operatorChecked", null);
  149. }
  150. return myBatisDao.get("dspBannerSqlMapper.countByParamsOperator", paramMap);
  151. }
  152. @Override
  153. public List<Map<String, Object>> findByParamsOpeator(Long operatorId,HashMap<String, Object> paramMap, Pager pager) {
  154. paramMap.put("pager", pager);
  155. List<Zone> zoneList = myBatisDao.getList("zoneSqlMapper.findByOperatorIdOperator", operatorId);
  156. paramMap.put("zoneList", zoneList);
  157. if(zoneList.size()==0){
  158. return new ArrayList<Map<String,Object>>();
  159. }
  160. return myBatisDao.getList("dspBannerSqlMapper.findByParamsOperator", paramMap);
  161. }
  162. @Override
  163. public boolean updateOperatorPass(long id, int checked) {
  164. Date date = new Date();
  165. myBatisDao.save("dspBannerSqlMapper.updateOperatorPass",
  166. MapBuilder.create(HashMap.class)
  167. .add("bannerId", id)
  168. .add("updated", date)
  169. .add("supdated", date.getTime()/1000)
  170. .add("checked", checked).map());
  171. return true;
  172. }
  173. @Override
  174. public boolean updateOperatorNoPass(long id, int checked,
  175. String memo) {
  176. Date date = new Date();
  177. myBatisDao.save("dspBannerSqlMapper.updateOperatorNoPass",
  178. MapBuilder.create(HashMap.class)
  179. .add("bannerId", id)
  180. .add("memo",memo)
  181. .add("updated", date)
  182. .add("supdated", date.getTime()/1000)
  183. .add("checked", checked).map());
  184. return true;
  185. }
  186. @Override
  187. public int getState(long operatorId, long id) {
  188. return myBatisDao.get("dspBannerSqlMapper.getState", MapBuilder.create(HashMap.class)
  189. .add("operatorId", operatorId)
  190. .add("bannerId", id)
  191. .map());
  192. }
  193. @Override
  194. public void addBannerOperator(long operatorId, long id) {
  195. Date date = new Date();
  196. long dspId = findById(id).getDspId();
  197. myBatisDao.save("dspBannerSqlMapper.addBannerOperator",
  198. MapBuilder.create(HashMap.class)
  199. .add("operatorId", operatorId)
  200. .add("bannerId",id)
  201. .add("dspId",dspId)
  202. .add("supdated",date)
  203. .map());
  204. }
  205. @Override
  206. public DspBanner findById(long id) {
  207. return myBatisDao.get("dspBannerSqlMapper.findById", id);
  208. }
  209. }