工资条当月同比

  //当月同比
    @RequestMapping(value = "/salary/api/getMonthBj", method = RequestMethod.POST)
    @ResponseBody
    public String getMonthBj(HttpServletRequest request, HttpSession session) {
        return RESULT_MAP_SUCCESS(salaryService.getMonthBj(REQUEST_BODY(request)));
    }
	
	  //当月同比
    public List getMonthBj(Map param){
        return tbGzCalculatedMapper.getMonthBj(param);
    }
	
	
	
	    List<Map> getMonthBj(Map param);
	

<select id="getMonthBj" parameterType="java.util.Map" resultType="java.util.Map">
    select A.tax,(A.tax-B.tax)/B.tax as tax1,A.sfhj,(A.sfhj-B.sfhj)/B.sfhj as sfhj1, A.skhj,(A.skhj-B.skhj)/B.skhj as skhj1,A.gz,(A.gz-B.gz)/B.gz as gz1
    from (select sum(tax) as tax,sum(sfhj) as sfhj,sum(skhj) as skhj,(sum(sfhj) - sum(skhj) - sum(tax)) as gz from tb_gz_calculated  where yf = #{yf}) A,
    (select sum(tax) as tax,sum(sfhj) as sfhj,sum(skhj) as skhj,(sum(sfhj) - sum(skhj) - sum(tax)) as gz from tb_gz_calculated where yf = #{yf}-1) B;

    <!--  select A.tax,(A.tax-B.tax)/B.tax as tax1,A.sfhj,(A.sfhj-B.sfhj)/B.sfhj as sfhj1, A.skhj,(A.skhj-B.skhj)/B.skhj as skhj1,A.gz,(A.gz-B.gz)/B.gz as gz1
      from
      (select sum(tax) as tax,sum(sfhj) as sfhj,sum(skhj) as skhj,(sum(sfhj) - sum(skhj) - sum(tax)) as gz from tb_gz_calculated
      <trim prefix="WHERE" prefixOverrides="AND">
          <if test="yf != null">
              AND yf=#{yf,jdbcType=INTEGER}
          </if>
          <if test="cnid != null">
              AND cnid=#{cnid,jdbcType=VARCHAR}
          </if>
      </trim>) A,
      (select sum(tax) as tax,sum(sfhj) as sfhj,sum(skhj) as skhj,(sum(sfhj) - sum(skhj) - sum(tax)) as gz from tb_gz_calculated
      <trim prefix="WHERE" prefixOverrides="AND">
          <if test="yf != null">
              AND yf=#{yf,jdbcType=INTEGER}-1
          </if>
          <if test="cnid != null">
              AND cnid=#{cnid,jdbcType=VARCHAR}
          </if>
      </trim>) B;-->
  </select>

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值