//当月同比
@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>