帆软学习笔记

Love The Way You Lie 2021-07-26 13:44 486阅读 0赞

字符串拼接

CONCATENATE("核心市场",LEFT($endtime,4),"年",RIGHT($endtime,2),"月价格情况")

sql查询接收日期控件传参：

![20191227140249324.png][]

select 
    	year,
    	month,
    	yearmonth,
    	country,
    	segment,
    	rank_no,
    	model,
    	round(volume,0) as volume,
    	round(ytd_volume,0) as ytd_volume,
    	concat(round(min_msrp_price,0),"~",round(max_msrp_price,0)) as msrp_price,
    	concat(round(min_tp_price,0),"~",round(max_tp_price,0)) as tp_price,
    	concat(round(diff_min_tpprice,0),"~",round(diff_max_tpprice,0)) as diff_tpprice,
    	round((diff_min_tpprice-diff_mg_price)/diff_mg_price,0) as diff_mg_price,
    	diff_min_tpprice,
    	diff_max_tpprice,
    	case 
        when diff_min_tpprice < 0 then '1' 
        when diff_max_tpprice > 0 then '2'  
        when diff_min_tpprice = 0 and diff_max_tpprice = 0 then '3'
        else '0' 
        end price_trend,
        CONCAT(country,"_",model) as link
        
    from t_ids_coreprice
    where 1=1
    ${if(len(endtime)=0,""," and yearmonth='"+endtime+"'")}
    order by country,segment,rank_no

sql接收链接传参：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbWluZzEwMTY_size_16_color_FFFFFF_t_70][]

select 
    	round(min_tp_price,0) as min_tp_price,
    	round(max_tp_price,0) as max_tp_price,
    	round((max_tp_price-min_tp_price),0) as dif_tp_price,
    	yearmonth
    from t_industry_price_l2
    where country = '${country_chart}' and model = '${model_chart}' and year = '${endtime}'

隔行变色

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbWluZzEwMTY_size_16_color_FFFFFF_t_70 1][]

普通报表修改日期控件后提交：

[https://help.finereport.com/doc-view-409.html][https_help.finereport.com_doc-view-409.html]

_g().parameterCommit();

[20191227140249324.png]: /images/20210726/61a550b97d794453ad15067cb4b1612e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbWluZzEwMTY_size_16_color_FFFFFF_t_70]: /images/20210726/f4ba6b981b2442cfb21674f00cdcf625.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpbWluZzEwMTY_size_16_color_FFFFFF_t_70 1]: /images/20210726/af16ec92334044858ae68d31c5449969.png
[https_help.finereport.com_doc-view-409.html]: https://help.finereport.com/doc-view-409.html