| | |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "持续改进列表(分页)") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(paramType = "query", name = "pageNum", dataType = "int", required = false, value = "当前页,默认1"), |
| | | @ApiImplicitParam(paramType = "query", name = "pageSize", dataType = "int", required = false, value = "每页数目,默认10"), |
| | | }) |
| | | @GetMapping("/inside/list") |
| | | public CommonResult listContinuousImprove(ContinuousImprove continuousImprove){ |
| | | return CommonResult.success(continuousImproveService.selectContinuousImproveList(continuousImprove)); |
| | | } |
| | | |
| | | /** |
| | | * 持续改进id查 |
| | | * @param improveId |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "持续改进id查") |
| | | @GetMapping("/inside/listByid") |
| | | public CommonResult listdContinuousImproveByid(@RequestParam("improveId") Integer improveId){ |
| | | return continuousImproveService.listContinuousImproveById(improveId); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 持续改进新增 |
| | | * @param continuousImprove |
| | | * @return |
| | |
| | | return CommonResult.success(customerInventoryService.selectCustomerInventoryList(customerInventory)); |
| | | } |
| | | |
| | | /** |
| | | * 顾客清单列表所有 |
| | | * @param customerInventory |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "顾客清单列表(所有)") |
| | | @GetMapping("/inventory/listAll") |
| | | public CommonResult listCustomerAll(CustomerInventory customerInventory){ |
| | | return CommonResult.success(customerInventoryService.selectCustomerInventoryListAll(customerInventory)); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 顾客清单新增 |
| | |
| | | return CommonResult.success(monthlyInspectionService.selectMonthlyInspectionList(monthlyInspection)); |
| | | } |
| | | |
| | | /** |
| | | * 月度检查记录id查 |
| | | * @param monthlyId |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "月度检查记录id查") |
| | | @GetMapping("/monthly/listByid") |
| | | public CommonResult listMonthlyInspectionByid(@RequestParam("monthlyId") Integer monthlyId){ |
| | | return monthlyInspectionService.listMonthlyInspectionById(monthlyId); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 月度检查记录新增 |
| | |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "质量体系策划列表(分页)") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(paramType = "query", name = "pageNum", dataType = "int", required = false, value = "当前页,默认1"), |
| | | @ApiImplicitParam(paramType = "query", name = "pageSize", dataType = "int", required = false, value = "每页数目,默认10"), |
| | | }) |
| | | @GetMapping("/list") |
| | | public CommonResult listQualitySystemPlan(QualitySystemPlan qualitySystemPlan){ |
| | | return CommonResult.success(qualitySystemPlanService.selectQualitySystemPlanList(qualitySystemPlan)); |
| | | } |
| | | |
| | | /** |
| | | * 质量体系策划id查 |
| | | * @param planId |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "质量体系策划id查") |
| | | @GetMapping("/listByid") |
| | | public CommonResult listQualitySystemPlanByid(@RequestParam("planId") Integer planId){ |
| | | return qualitySystemPlanService.listQualitySystemPlanByid(planId); |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 质量体系策划新增 |
| | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.gkhy.exam.system.domain.ContinuousImprove; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.mapstruct.Mapper; |
| | | |
| | | import java.util.List; |
| | |
| | | List<ContinuousImprove> selectImproveList(ContinuousImprove continuousImprove); |
| | | |
| | | List<ContinuousImprove> selectByCompanyId(ContinuousImprove continuousImprove); |
| | | |
| | | ContinuousImprove selectListById(@Param("improveId") Integer improveId); |
| | | } |
| | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.gkhy.exam.system.domain.MonthlyInspection; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.mapstruct.Mapper; |
| | | |
| | | import java.util.List; |
| | |
| | | @Mapper |
| | | public interface MonthlyInspectionMapper extends BaseMapper<MonthlyInspection> { |
| | | List<MonthlyInspection> selectInspectionList(MonthlyInspection monthlyInspection); |
| | | |
| | | MonthlyInspection selectListById(@Param("monthlyId") Integer monthlyId); |
| | | } |
| | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.gkhy.exam.system.domain.QualitySystemPlan; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.mapstruct.Mapper; |
| | | |
| | | import java.util.List; |
| | |
| | | @Mapper |
| | | public interface QualitySystemPlanMapper extends BaseMapper<QualitySystemPlan> { |
| | | List<QualitySystemPlan> selectSystemPlanList(QualitySystemPlan qualitySystemPlan); |
| | | |
| | | QualitySystemPlan selectListById(@Param("planId") Integer planId); |
| | | } |
| | |
| | | CommonResult updateContinuousImprove(ContinuousImprove continuousImprove); |
| | | |
| | | CommonResult deletedContinuousImprove(Integer improveId); |
| | | |
| | | CommonResult listContinuousImproveById(Integer improveId); |
| | | } |
| | |
| | | CommonResult deletedCustomerInventory(Integer customerId); |
| | | |
| | | |
| | | CommonResult selectCustomerInventoryListAll(CustomerInventory customerInventory); |
| | | } |
| | |
| | | CommonResult updateMonthlyInspection(MonthlyInspection monthlyInspection); |
| | | |
| | | CommonResult deletedMonthlyInspection(Integer monthlyId); |
| | | |
| | | CommonResult listMonthlyInspectionById(Integer monthlyId); |
| | | } |
| | |
| | | CommonResult updateQualitySystemPlan(QualitySystemPlan qualitySystemPlan); |
| | | |
| | | CommonResult deletedQualitySystemPlan(Integer planId); |
| | | |
| | | CommonResult listQualitySystemPlanByid(Integer planId); |
| | | } |
| | |
| | | throw new RuntimeException("非管理员操作,查询条件不可为空"); |
| | | } |
| | | } |
| | | PageUtils.startPage(); |
| | | List<ContinuousImprove> continuousImproves = continuousImproveMapper.selectImproveList(continuousImprove); |
| | | for (ContinuousImprove improve : continuousImproves) { |
| | | List<ContinuousImprovePlan> continuousImprovePlans = continuousImprovePlanMapper.selectByImproveId(improve.getId()); |
| | |
| | | } |
| | | return CommonResult.failed(); |
| | | } |
| | | |
| | | @Override |
| | | public CommonResult listContinuousImproveById(Integer improveId) { |
| | | ContinuousImprove continuousImprove = continuousImproveMapper.selectListById(improveId); |
| | | List<ContinuousImprovePlan> continuousImprovePlans = continuousImprovePlanMapper.selectByImproveId(improveId); |
| | | continuousImprove.setPlans(continuousImprovePlans); |
| | | return CommonResult.success(continuousImprove); |
| | | } |
| | | } |
| | |
| | | return CommonResult.failed(); |
| | | } |
| | | |
| | | @Override |
| | | public CommonResult selectCustomerInventoryListAll(CustomerInventory customerInventory) { |
| | | List<CustomerInventory> customerInventories = customerInventoryMapper.selectInventoryList(customerInventory); |
| | | return CommonResult.success(customerInventories); |
| | | } |
| | | |
| | | } |
| | |
| | | } |
| | | return CommonResult.failed(); |
| | | } |
| | | |
| | | @Override |
| | | public CommonResult listMonthlyInspectionById(Integer monthlyId) { |
| | | MonthlyInspection monthlyInspection = monthlyInspectionMapper.selectListById(monthlyId); |
| | | List<MonthlyInspectionMess> monthlyInspectionMesses = monthlyInspectionMessMapper.selectByMonthlyId(monthlyId); |
| | | monthlyInspection.setInspectionMesses(monthlyInspectionMesses); |
| | | return CommonResult.success(monthlyInspection); |
| | | } |
| | | } |
| | |
| | | throw new ApiException("非管理员操作,企业id不可为空"); |
| | | } |
| | | } |
| | | PageUtils.startPage(); |
| | | List<QualitySystemPlan> qualitySystemPlans = qualitySystemPlanMapper.selectSystemPlanList(qualitySystemPlan); |
| | | for (QualitySystemPlan systemPlan : qualitySystemPlans) { |
| | | List<QualitySystemPlanMess> qualitySystemPlanMesses = qualitySystemPlanMessMapper.selectByPlanId(systemPlan.getId()); |
| | |
| | | qualitySystemPlanMapper.updateById(qualitySystemPlan); |
| | | return CommonResult.success(); |
| | | } |
| | | |
| | | @Override |
| | | public CommonResult listQualitySystemPlanByid(Integer planId) { |
| | | QualitySystemPlan qualitySystemPlan = qualitySystemPlanMapper.selectListById(planId); |
| | | List<QualitySystemPlanMess> qualitySystemPlanMesses = qualitySystemPlanMessMapper.selectByPlanId(planId); |
| | | qualitySystemPlan.setPlanMesses(qualitySystemPlanMesses); |
| | | return CommonResult.success(qualitySystemPlan); |
| | | } |
| | | } |
| | |
| | | and id != #{id} |
| | | </if> |
| | | </select> |
| | | <select id="selectListById" resultType="com.gkhy.exam.system.domain.ContinuousImprove"> |
| | | SELECT |
| | | ci.`id`, |
| | | ci.`company_id`, |
| | | sc.`name` AS company_name, |
| | | ci.`year`, |
| | | ci.`fiction_id`, |
| | | su1.`name` AS fiction_name, |
| | | ci.`check_id`, |
| | | su2.`name` AS check_name, |
| | | ci.`ratify_id`, |
| | | su3.`name` AS ratify_name, |
| | | ci.`del_flag`, |
| | | ci.`create_by`, |
| | | ci.`create_time`, |
| | | ci.`update_by`, |
| | | ci.`update_time` |
| | | FROM |
| | | `continuous_improve` ci |
| | | LEFT JOIN sys_user su1 ON ci.fiction_id = su1.id |
| | | LEFT JOIN sys_user su2 ON ci.check_id = su2.id |
| | | LEFT JOIN sys_user su3 ON ci.ratify_id = su3.id |
| | | LEFT JOIN sys_company sc ON ci.company_id = sc.id |
| | | WHERE |
| | | ci.del_flag = 0 |
| | | and ci.id = #{improveId} |
| | | </select> |
| | | </mapper> |
| | |
| | | <if test="companyId!=null"> |
| | | and mi.company_id =#{companyId} |
| | | </if> |
| | | <if test="id!=null"> |
| | | and mi.id = #{id} |
| | | </if> |
| | | ORDER BY |
| | | mi.create_time DESC |
| | | </select> |
| | | <select id="selectListById" resultType="com.gkhy.exam.system.domain.MonthlyInspection"> |
| | | SELECT |
| | | mi.`id`, |
| | | mi.`company_id`, |
| | | sc.`name` AS company_name, |
| | | mi.`record_name`, |
| | | mi.`del_flag`, |
| | | mi.`create_by`, |
| | | mi.`create_time`, |
| | | mi.`update_by`, |
| | | mi.`update_time` |
| | | FROM |
| | | `monthly_inspection` mi |
| | | LEFT JOIN sys_company sc ON mi.company_id = sc.id |
| | | WHERE |
| | | mi.del_flag = 1 |
| | | and mi.id = #{monthlyId} |
| | | </select> |
| | | </mapper> |
| | |
| | | </if> |
| | | ORDER BY qsp.create_time DESC |
| | | </select> |
| | | <select id="selectListById" resultType="com.gkhy.exam.system.domain.QualitySystemPlan"> |
| | | SELECT |
| | | qsp.`id`, |
| | | qsp.`company_id`, |
| | | sc.`name` as company_name, |
| | | qsp.`year`, |
| | | qsp.`write_id`, |
| | | su1.`name` as write_name, |
| | | qsp.`check_id`, |
| | | su2.`name` as check_name, |
| | | qsp.`ratify_id`, |
| | | su3.`name` as ratify_name, |
| | | qsp.`del_flag`, |
| | | qsp.`create_by`, |
| | | qsp.`create_time`, |
| | | qsp.`update_by`, |
| | | qsp.`update_time` |
| | | FROM |
| | | `quality_system_plan` qsp |
| | | INNER JOIN sys_company sc on qsp.company_id = sc.id |
| | | LEFT JOIN sys_user su1 on qsp.write_id = su1.id |
| | | LEFT JOIN sys_user su2 on qsp.check_id = su2.id |
| | | LEFT JOIN sys_user su3 on qsp.ratify_id = su3.id |
| | | WHERE qsp.del_flag = 1 and qsp.id = #{planId} |
| | | </select> |
| | | </mapper> |