123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393 |
- package com.medex.mdap.re.sportmovemode.business;
- import java.util.ArrayList;
- import java.util.List;
- import org.springframework.beans.BeanUtils;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Component;
- import org.springframework.transaction.annotation.Propagation;
- import org.springframework.transaction.annotation.Transactional;
- import com.medex.mdap.base.security.UserInfo;
- import com.medex.mdap.pub.exception.BusinessException;
- import com.medex.mdap.pub.exception.ExceptionCode;
- import com.medex.mdap.re.sportaction.pojo.SportActionVO;
- import com.medex.mdap.re.sportaction.service.SportActionService;
- import com.medex.mdap.re.sportactionrecord.pojo.SportActionrecordVO;
- import com.medex.mdap.re.sportactionrecord.service.SportActionrecordService;
- import com.medex.mdap.re.sportactionrecord.view.SportActionrecordView;
- import com.medex.mdap.re.sportactionrecorddetail.pojo.SportActionrecordDetailVO;
- import com.medex.mdap.re.sportactionrecorddetail.service.SportActionrecordDetailService;
- import com.medex.mdap.re.sportactionrecorddetail.view.SportActionrecordDetailView;
- import com.medex.mdap.re.sporteachgroup.pojo.SportEachgroupVO;
- import com.medex.mdap.re.sporteachgroup.service.SportEachgroupService;
- import com.medex.mdap.re.sporteachgroup.view.SportEachgroupView;
- import com.medex.mdap.re.sportmovemode.pojo.SportMovemodeVO;
- import com.medex.mdap.re.sportmovemode.service.SportMovemodeService;
- import com.medex.mdap.re.sportmovemode.view.RetrunMoveMode;
- import com.medex.mdap.re.sportmovemode.view.SportMovemodeView;
- import com.medex.mdap.re.sportscheme.service.SportSchemeService;
- import com.medex.mdap.util.JSONProcessUtil;
- import com.medex.mdap.util.PrimaryKeyUtil;
- @Component
- public class SportMovemodeBusiness {
-
- @Autowired
- SportSchemeService sportSchemeService;
-
- @Autowired
- SportMovemodeService sportMovemodeService;
- @Autowired
- SportActionrecordService sportActionrecordService;
-
- @Autowired
- SportActionService sportActionService;
-
- @Autowired
- SportEachgroupService sportEachgroupService;
-
- @Autowired
- private PrimaryKeyUtil primaryKeyUtil;
-
- @Autowired
- SportActionrecordDetailService sportActionrecordDetailService;
-
- //查询列表 支持模糊
- @Transactional(propagation=Propagation.REQUIRED,rollbackFor=Exception.class)
- public List<SportMovemodeView> selectSportMovemodeAll(String json, UserInfo userInfo) {
- // TODO Auto-generated method stub
- //定义返回值
- List<SportMovemodeView> listSportMovemodeView = new ArrayList<SportMovemodeView>();
- List<SportMovemodeView> movemodes = new ArrayList<SportMovemodeView>();
- //获取前端传值
- SportMovemodeView sportMovemodeView = JSONProcessUtil.parseJsonObject(json, SportMovemodeView.class);
- //将登陆人的基本信息赋值给对象
- sportMovemodeView.setPk_group(userInfo.pkGroup);
- sportMovemodeView.setPk_org(userInfo.pkOrg);
- sportMovemodeView.setPk_dept(userInfo.pkDept);
- List<SportMovemodeView> listView = sportMovemodeService.selectSportMovemodeAll(sportMovemodeView);
- //查询动作方式
- for(SportMovemodeView movemodeView : listView){
- listSportMovemodeView.clear();
- movemodes.clear();
- //根据动作方式查询动作记录表中动作N的动作详情 获得所有组数的主键
- List<SportActionrecordView> listSportActionrecord = sportActionrecordService.selectCordPkActionByModePk(movemodeView);
- for(SportActionrecordView sportActionrecordView : listSportActionrecord){
- //去动作明细表 根据动作N的主键找到所有动作的主键
- List<SportActionrecordDetailView> listPkAction = sportActionrecordDetailService.selectPkActionByActionrecordPk(sportActionrecordView);
- //根据所有动作的主键找到动作的名称
- for(SportActionrecordDetailView sportActionrecordDetailView : listPkAction){
- //根据主键查询动作
- SportActionVO sportActionVO = sportActionService.selectById(sportActionrecordDetailView.getRe_sport_action());
- sportActionrecordDetailView.setActionName(sportActionVO.getName());
- }
- sportActionrecordView.setDetailList(listPkAction);
- }
- movemodeView.setListSportActionrecord(listSportActionrecord);
- }
- return listView;
- }
- @Transactional(propagation=Propagation.REQUIRED,rollbackFor=Exception.class)
- public List<RetrunMoveMode> insertSportMovemodeAll(String json, UserInfo userInfo) {
- // TODO Auto-generated method stub
- //定义返回值
- List<RetrunMoveMode> list = new ArrayList<RetrunMoveMode>();
- RetrunMoveMode retrun = new RetrunMoveMode();
- List<SportActionrecordView> cordListRe = new ArrayList<SportActionrecordView>();
- List<SportEachgroupView> eachListRe = new ArrayList<SportEachgroupView>();
- List<SportActionrecordDetailView> detailListRe = new ArrayList<SportActionrecordDetailView>();
- //获得前端传值
- RetrunMoveMode retrunMoveMode = JSONProcessUtil.parseJsonObject(json, RetrunMoveMode.class);
- //新增动作方式主表
- SportMovemodeVO sportMovemodeVo = new SportMovemodeVO();
- SportMovemodeView sportMovemodeView = retrunMoveMode.getSportMovemodeView();
- BeanUtils.copyProperties(sportMovemodeView, sportMovemodeVo);
- sportMovemodeVo.setPk_dept(userInfo.getPkDept());
- if(null != sportMovemodeView.getPk_group() || !"".equals(sportMovemodeView.getPk_group())){
- sportMovemodeVo.setPk_group(userInfo.getPkGroup());
- }
- sportMovemodeVo.setPk_org(userInfo.getPkOrg());
- sportMovemodeVo.setCreator(userInfo.getPkPsndocName());
- sportMovemodeVo.setCreatetime(primaryKeyUtil.createTs());
- sportMovemodeVo.setDr(0);
- sportMovemodeService.insert(sportMovemodeVo);
- //返回值
- BeanUtils.copyProperties(sportMovemodeVo,sportMovemodeView);
- retrun.setSportMovemodeView(sportMovemodeView);
- //新增动作记录
- List<SportActionrecordView> cordList = retrunMoveMode.getCordList();
- //每次根据新增的值覆盖之前的值
- SportActionrecordVO sportActionrecordVO = new SportActionrecordVO();
- for(SportActionrecordView sportActionrecordView : cordList){
- eachListRe.clear();
- detailListRe.clear();
- BeanUtils.copyProperties(sportActionrecordView, sportActionrecordVO);
- sportActionrecordVO.setPk_sport_movemode(sportMovemodeVo.getPk_sport_movemode());
- sportActionrecordVO.setDr(0);
- sportActionrecordService.insert(sportActionrecordVO);
- //返回值
- BeanUtils.copyProperties(sportActionrecordVO,sportActionrecordView);
-
- //新增动作明细
- List<SportActionrecordDetailView> detailList = sportActionrecordView.getDetailList();
- //每次根据新增的值覆盖之前的值
- SportActionrecordDetailVO SportActionrecordDetailVO = new SportActionrecordDetailVO();
- for(SportActionrecordDetailView sportActionrecordDetailView : detailList){
- BeanUtils.copyProperties(sportActionrecordDetailView, SportActionrecordDetailVO);
- SportActionrecordDetailVO.setRe_sport_actionrecord(sportActionrecordView.getPk_sport_actionrecord());
- sportActionrecordDetailService.insert(SportActionrecordDetailVO);
- //返回值
- BeanUtils.copyProperties( SportActionrecordDetailVO,sportActionrecordDetailView);
- detailListRe.add(sportActionrecordDetailView);
-
- }
- //新增每组记录
- List<SportEachgroupView> eachList = sportActionrecordView.getEachList();
- //每次根据新增的值覆盖之前的值
- SportEachgroupVO sportEachgroupVO = new SportEachgroupVO();
- for(SportEachgroupView SportEachgroupView : eachList){
- BeanUtils.copyProperties(SportEachgroupView, sportEachgroupVO);
- sportEachgroupVO.setPk_sport_actionrecord(sportActionrecordView.getPk_sport_actionrecord());
- sportEachgroupService.insert(sportEachgroupVO);
- //返回值
- BeanUtils.copyProperties( sportEachgroupVO,SportEachgroupView);
- eachListRe.add(SportEachgroupView);
- }
- sportActionrecordView.setDetailList(detailListRe);
- sportActionrecordView.setEachList(eachListRe);
- cordListRe.add(sportActionrecordView);
- }
- retrun.setCordList(cordListRe);
- list.add(retrun);
- return list;
- }
-
- //修改
- @Transactional(propagation=Propagation.REQUIRED,rollbackFor=Exception.class)
- public List<RetrunMoveMode> updateSportMovemodeAll(String json, UserInfo userInfo) {
- // TODO Auto-generated method stub
- //定义返回值
- List<RetrunMoveMode> list = new ArrayList<RetrunMoveMode>();
- RetrunMoveMode retrun = new RetrunMoveMode();
- List<SportActionrecordView> cordListRe = new ArrayList<SportActionrecordView>();
- List<SportEachgroupView> eachListRe = new ArrayList<SportEachgroupView>();
- List<SportActionrecordDetailView> detailListRe = new ArrayList<SportActionrecordDetailView>();
- //接收前端传参
- RetrunMoveMode retrunMoveMode = JSONProcessUtil.parseJsonObject(json, RetrunMoveMode.class);
- //根据运动方式主表查询动作方式记录表 动作明细表 组数表并且删除
- SportMovemodeView sportMovemodeView = retrunMoveMode.getSportMovemodeView();
- //查询运动方式主表
- SportMovemodeVO sportMovemodeVo = new SportMovemodeVO();
- BeanUtils.copyProperties(sportMovemodeView,sportMovemodeVo);
- SportMovemodeVO sportMovemodeVO = sportMovemodeService.selectById(sportMovemodeVo);
- //查询动作记录表中的数据
- List<SportActionrecordView> cordListRe1 = sportActionrecordService.selectActionCordByModePK(sportMovemodeVO);
- for(SportActionrecordView sportActionrecordView : cordListRe1){
- //根据动作记录的主键查询动作明细表
- detailListRe = sportActionrecordDetailService.selectPkActionByActionrecordPk(sportActionrecordView);
- //执行删除动作明细表
- for(SportActionrecordDetailView sportActionrecordDetailView : detailListRe){
- sportActionrecordDetailService.deleteById(sportActionrecordDetailView.getPk_sport_actionrecord_detail());
- }
- //根据动作记录的主键查询每组记录表
- eachListRe = sportEachgroupService.selectEachGroupBypkCord(sportActionrecordView);
- //执行删除询每组记录表
- for(SportEachgroupView SportEachgroupView : eachListRe){
- sportEachgroupService.deleteById(SportEachgroupView.getPk_sport_eachgroup());
- }
- //执行删除动作记录
- sportActionrecordService.deleteById(sportActionrecordView.getPk_sport_actionrecord());
- }
-
- //修改主表
- BeanUtils.copyProperties(sportMovemodeView, sportMovemodeVo);
- sportMovemodeVo.setPk_dept(userInfo.getPkDept());
- if(null != sportMovemodeView.getPk_group() || !"".equals(sportMovemodeView.getPk_group())){
- sportMovemodeVo.setPk_group(userInfo.getPkGroup());
- }
- sportMovemodeVo.setPk_org(userInfo.getPkOrg());
- sportMovemodeVo.setModifier(userInfo.getPkPsndocName());
- sportMovemodeVo.setModifiedtime(primaryKeyUtil.createTs());
- /*if(sportMovemodeVO.getEntablestate() != sportMovemodeView.getEntablestate()){
- //是否被引用
- int count = sportSchemeService.selectCountByPkMove(sportMovemodeVO);
- if(count != 0){
- throw new BusinessException(ExceptionCode.UPDATEDRUGDIC);
- }
- }*/
- sportMovemodeService.updateSelectiveById(sportMovemodeVo);
- //返回值
- BeanUtils.copyProperties(sportMovemodeVo,sportMovemodeView);
- retrun.setSportMovemodeView(sportMovemodeView);
- //新增动作记录
- List<SportActionrecordView> cordList = retrunMoveMode.getCordList();
- //每次根据新增的值覆盖之前的值
- SportActionrecordVO sportActionrecordVO = new SportActionrecordVO();
- for(SportActionrecordView sportActionrecordView : cordList){
- eachListRe.clear();
- detailListRe.clear();
- BeanUtils.copyProperties(sportActionrecordView, sportActionrecordVO);
- sportActionrecordVO.setPk_sport_movemode(sportMovemodeVo.getPk_sport_movemode());
- sportActionrecordService.insert(sportActionrecordVO);
- //返回值
- BeanUtils.copyProperties(sportActionrecordVO,sportActionrecordView);
-
- //新增动作明细
- List<SportActionrecordDetailView> detailList = sportActionrecordView.getDetailList();
- //每次根据新增的值覆盖之前的值
- SportActionrecordDetailVO SportActionrecordDetailVO = new SportActionrecordDetailVO();
- for(SportActionrecordDetailView sportActionrecordDetailView : detailList){
- BeanUtils.copyProperties(sportActionrecordDetailView, SportActionrecordDetailVO);
- SportActionrecordDetailVO.setRe_sport_actionrecord(sportActionrecordView.getPk_sport_actionrecord());
- sportActionrecordDetailService.insert(SportActionrecordDetailVO);
- //返回值
- BeanUtils.copyProperties( SportActionrecordDetailVO,sportActionrecordDetailView);
- detailListRe.add(sportActionrecordDetailView);
-
- }
- //新增每组记录
- List<SportEachgroupView> eachList = sportActionrecordView.getEachList();
- //每次根据新增的值覆盖之前的值
- SportEachgroupVO sportEachgroupVO = new SportEachgroupVO();
- for(SportEachgroupView SportEachgroupView : eachList){
- BeanUtils.copyProperties(SportEachgroupView, sportEachgroupVO);
- sportEachgroupVO.setPk_sport_actionrecord(sportActionrecordView.getPk_sport_actionrecord());
- sportEachgroupService.insert(sportEachgroupVO);
- //返回值
- BeanUtils.copyProperties( sportEachgroupVO,SportEachgroupView);
- eachListRe.add(SportEachgroupView);
- }
- sportActionrecordView.setDetailList(detailListRe);
- sportActionrecordView.setEachList(eachListRe);
- cordListRe.add(sportActionrecordView);
- }
- retrun.setCordList(cordListRe);
- list.add(retrun);
- return list;
- }
- //删除
- @Transactional(propagation=Propagation.REQUIRED,rollbackFor=Exception.class)
- public List<RetrunMoveMode> deleteSportMovemodeAll(String json) {
- //定义返回值
- List<RetrunMoveMode> list = new ArrayList<RetrunMoveMode>();
- //全局变量
- List<SportActionrecordView> cordListRe = new ArrayList<SportActionrecordView>();
- List<SportEachgroupView> eachListRe = new ArrayList<SportEachgroupView>();
- List<SportActionrecordDetailView> detailListRe = new ArrayList<SportActionrecordDetailView>();
-
- //查询要修改的这条对象的详情
-
- //获得前端传值
- RetrunMoveMode retrunMoveMode = JSONProcessUtil.parseJsonObject(json, RetrunMoveMode.class);
- //查询运动方式主表
- SportMovemodeView sportMovemodeView = retrunMoveMode.getSportMovemodeView();
- SportMovemodeVO sportMovemodeVo = new SportMovemodeVO();
- BeanUtils.copyProperties(sportMovemodeView,sportMovemodeVo);
- /*//是否被引用
- int count = sportSchemeService.selectCountByPkMove(sportMovemodeVo);
- if(count != 0){
- throw new BusinessException(ExceptionCode.DELETEDRUGDIC);
- }*/
- SportMovemodeVO sportMovemodeVO = sportMovemodeService.selectById(sportMovemodeVo);
- //查询动作记录表中的数据
- cordListRe = sportActionrecordService.selectActionCordByModePK(sportMovemodeVO);
- for(SportActionrecordView sportActionrecordView : cordListRe){
- //根据动作记录的主键查询动作明细表
- detailListRe = sportActionrecordDetailService.selectPkActionByActionrecordPk(sportActionrecordView);
- //执行删除动作明细表
- for(SportActionrecordDetailView sportActionrecordDetailView : detailListRe){
- sportActionrecordDetailService.deleteById(sportActionrecordDetailView.getPk_sport_actionrecord_detail());
- }
- //根据动作记录的主键查询每组记录表
- eachListRe = sportEachgroupService.selectEachGroupBypkCord(sportActionrecordView);
- //执行删除询每组记录表
- for(SportEachgroupView SportEachgroupView : eachListRe){
- sportEachgroupService.deleteById(SportEachgroupView.getPk_sport_eachgroup());
- }
- //执行删除动作记录
- sportActionrecordService.deleteById(sportActionrecordView.getPk_sport_actionrecord());
- }
- sportMovemodeService.deleteById(sportMovemodeVO.getPk_sport_movemode());
- list.add(retrunMoveMode);
- return list;
- }
- //单个查询
- public List<RetrunMoveMode> selectSportMovemodeByPKMode(String json) {
- // TODO Auto-generated method stub
- //定义返回值
- List<RetrunMoveMode> list = new ArrayList<RetrunMoveMode>();
- RetrunMoveMode retrun = new RetrunMoveMode();
- List<SportActionrecordView> cordListRe = new ArrayList<SportActionrecordView>();
- //获得前端传值
- SportMovemodeView sportMovemodeView = JSONProcessUtil.parseJsonObject(json, SportMovemodeView.class);
- //查询运动方式主表
- SportMovemodeVO sportMovemodeVo = new SportMovemodeVO();
- BeanUtils.copyProperties(sportMovemodeView,sportMovemodeVo);
- SportMovemodeVO sportMovemodeVO = sportMovemodeService.selectById(sportMovemodeVo);
- //查询动作记录表中的数据
- cordListRe = sportActionrecordService.selectActionCordByModePK(sportMovemodeVO);
-
- for(SportActionrecordView sportActionrecordView : cordListRe){
- //根据动作记录的主键查询动作明细表
- List<SportActionrecordDetailView> detailListRe = sportActionrecordDetailService.selectPkActionByActionrecordPk(sportActionrecordView);
- for(SportActionrecordDetailView sportActionrecordDetailView : detailListRe){
- //根据主键查询动作
- SportActionVO sportActionVO = sportActionService.selectById(sportActionrecordDetailView.getRe_sport_action());
- sportActionrecordDetailView.setActionName(sportActionVO.getName());
- }
-
-
- //根据动作记录的主键查询每组记录表
- List<SportEachgroupView> eachListRe = sportEachgroupService.selectEachGroupBypkCord(sportActionrecordView);
- sportActionrecordView.setEachList(eachListRe);
- sportActionrecordView.setDetailList(detailListRe);
- }
- BeanUtils.copyProperties(sportMovemodeVO,sportMovemodeView);
- retrun.setSportMovemodeView(sportMovemodeView);
- retrun.setCordList(cordListRe);
- list.add(retrun);
- return list;
- }
- public List<SportMovemodeView> selectSportMovemode(String json, UserInfo userInfo) {
- //定义返回值
- List<SportMovemodeView> listSportMovemodeView = new ArrayList<SportMovemodeView>();
- List<SportMovemodeView> movemodes = new ArrayList<SportMovemodeView>();
- //获取前端传值
- SportMovemodeView sportMovemodeView = JSONProcessUtil.parseJsonObject(json, SportMovemodeView.class);
- //将登陆人的基本信息赋值给对象
- sportMovemodeView.setPk_group(userInfo.pkGroup);
- sportMovemodeView.setPk_org(userInfo.pkOrg);
- sportMovemodeView.setPk_dept(userInfo.pkDept);
- List<SportMovemodeView> listView = sportMovemodeService.selectSportMovemode(sportMovemodeView);
- //查询动作方式
- for(SportMovemodeView movemodeView : listView){
- listSportMovemodeView.clear();
- movemodes.clear();
- //根据动作方式查询动作记录表中动作N的动作详情 获得所有组数的主键
- List<SportActionrecordView> listSportActionrecord = sportActionrecordService.selectCordPkActionByModePk(movemodeView);
- for(SportActionrecordView sportActionrecordView : listSportActionrecord){
- //去动作明细表 根据动作N的主键找到所有动作的主键
- List<SportActionrecordDetailView> listPkAction = sportActionrecordDetailService.selectPkActionByActionrecordPk(sportActionrecordView);
- //根据所有动作的主键找到动作的名称
- for(SportActionrecordDetailView sportActionrecordDetailView : listPkAction){
- //根据主键查询动作
- SportActionVO sportActionVO = sportActionService.selectById(sportActionrecordDetailView.getRe_sport_action());
- sportActionrecordDetailView.setActionName(sportActionVO.getName());
- }
- sportActionrecordView.setDetailList(listPkAction);
- }
- movemodeView.setListSportActionrecord(listSportActionrecord);
- }
- return listView;
- }
- }
|