select
year(dstartdate)as 开始时间年份,
CONVERT(varchar(10), CONVERT(date, dstartdate), 120)as 合同开始时间,
CONVERT(varchar(10), CONVERT(date, denddate), 120)as 合同结束时间,
chzmanner + Convert(varchar(10),cdefine4) as 合作方式,
cfree1 as 合作品牌,
Zkprice as 信用额度,
ccuscode as 客户编码,
isumrate as 回款比率,
icontractsum as 合同金额,
remarkTrans as 运费说明,
cdefine1 as 退货率,
cdefine6 as 合同到期扣率,
cdefine2 as 销售目标,
remarkKD as 合同约定内容
from XS_Cuscontract where ccuscode='${cuscode_c}'
group by
year(dstartdate),
CONVERT(varchar(10), CONVERT(date, dstartdate), 120),CONVERT(varchar(10), CONVERT(date, denddate), 120),chzmanner,cfree1,Zkprice,ccuscode,isumrate,icontractsum,remarkTrans,cdefine1,cdefine6,cdefine2,remarkKD,cdefine4
order by year(dstartdate) ${if(radioType="回款","ASC","DESC"}
---改一下