请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
HmjijsbZ(uid:2520483)
职业资格认证:FCA-FineReport | FCA-FineBI
  • 求助
  • 求助
  • https://help.fanruan.com/finereport/doc-view-2853.html 但是v11版本nginx是docker部署的,docker里的监听端口是8080,映射端口是80,重写会把地址重写为http://bi.tfzl.com:8080/webroot/decision,这个问题怎么解决啊
  • value函数里可以加一个时间函数或者是其他的设置条件吗?先调取符合这个条件的,再去执行value函数
  •    ${IF(送审结束否="", "SELECTmshipno AS shipno,dwg1,dwg2,dwg3,"+船号_BASESHIP+".dwgno,chuturi,"+船号_cd+".altno,ship1,songsri,fangqri,rusri,wancri,xwfqri,commt,reply,commtfile,replyfile,closed,cr,bzFROM"+船号_BASESHIP+"LEFT OUTER JOIN"+船号_cd+"ON"+船号_cd+".dwgno="+船号_BASESHIP+".dwgnoWHERE(chuand='Y' OR chuand='R')"+ IF(LEN(图号)=0,"","AND "+船号+".dwgno LIKE '%"+图号+"%'") + IF(LEN(返却状态)=0,"","AND (fangqri IS NULL AND xwfqri IS NULL) OR (fangqri IS NULL AND DATEDIFF(day,xwfqri,getdate())>0)") + IF(LEN(开始日期)=0,"","AND "+船号_cd+".songsri>='"+开始日期+"'") + IF(LEN(结束日期)=0,"","AND "+船号_cd+".songsri<='"+结束日期+"'") + IF(LEN(科室)=0,"","AND "+船号_BASESHIP+".bm IN ('"+SUBSTITUTE(科室,",","','")+"')") +\"ORDER BY mshipno,\"船号_cd\".altno,\"船号_cd\".ship1\",  "SELECTshipno,dwg1,dwg2,dwg3,"+船号_BASESHIP+".dwgno,chuturi,"+船号+"_cd.altno,ship1,songsri,fangqri,rusri,wancri,xwfqri,commt,reply,commtfile,replyfile,closed,cr,bzFROM"+船号+"_cd,"+船号_BASESHIP+"WHERE"+船号+"_cd.closed LIKE '%"+送审结束否+"%'AND "+船号+"_cd.dwgno="+船号_BASESHIP+".dwgno"+ IF(LEN(图号)=0,"","AND "+船号+"_cd.dwgno LIKE '%"+图号+"%'") + IF(LEN(返却状态)=0,"","AND (fangqri IS NULL AND xwfqri IS NULL) OR (fangqri IS NULL AND DATEDIFF(day,xwfqri,getdate()) >0)") + IF(LEN(开始日期)=0,"","AND "+船号_cd+".songsri>='"+开始日期+"'") + IF(LEN(结束日期)=0,"","AND "+船号_cd+".songsri<='"+结束日期+"'") + IF(LEN(科室)=0,"","AND "+船号_BASESHIP+".bm IN ('"+SUBSTITUTE(科室,",","','")+"') "))} 33
  • SQL("pdbfine_visual","SELECT CS FROM V_A_MEDICAL_GREENPASS_FILL WHERE CUST_NO = '" + I3 + "'",1)
  • 11222${IF(送审结束否="", "SELECTmshipno AS shipno,dwg1,dwg2,dwg3,"船号_BASESHIP".dwgno,chuturi,"船号_cd".altno,ship1,songsri,fangqri,rusri,wancri,xwfqri,commt,reply,commtfile,replyfile,closed,cr,bzFROM"船号_BASESHIP"LEFT OUTER JOIN"船号_cd"ON"船号_cd".dwgno="船号_BASESHIP".dwgnoWHERE(chuand='Y' OR chuand='R')"+ IF(LEN(图号)=0,"","AND "船号".dwgno LIKE '%"图号"%'") + IF(LEN(返却状态)=0,"","AND (fangqri IS NULL AND xwfqri IS NULL) OR (fangqri IS NULL AND DATEDIFF(day,xwfqri,getdate())>0)") + IF(LEN(开始日期)=0,"","AND "船号_cd".songsri>='"开始日期"'") + IF(LEN(结束日期)=0,"","AND "船号_cd".songsri<='"结束日期"'") + IF(LEN(科室)=0,"","AND "船号_BASESHIP".bm IN ('"SUBSTITUTE(科室,",","','")"')") ORDER BY mshipno,"船号_cd".altno,"船号_cd".ship1, "SELECTshipno,dwg1,dwg2,dwg3,"船号_BASESHIP".dwgno,chuturi,"船号"_cd.altno,ship1,songsri,fangqri,rusri,wancri,xwfqri,commt,reply,commtfile,replyfile,closed,cr,bzFROM"船号"_cd,"船号_BASESHIP"WHERE"船号"_cd.closed LIKE '%"送审结束否"%'AND "船号"_cd.dwgno="船号_BASESHIP".dwgno"+ IF(LEN(图号)=0,"","AND "船号"_cd.dwgno LIKE '%"图号"%'") + IF(LEN(返却状态)=0,"","AND (fangqri IS NULL AND xwfqri IS NULL) OR (fangqri IS NULL AND DATEDIFF(day,xwfqri,getdate()) >0)") + IF(LEN(开始日期)=0,"","AND "船号_cd".songsri>='"开始日期"'") + IF(LEN(结束日期)=0,"","AND "船号_cd".songsri<='"结束日期"'") + IF(LEN(科室)=0,"","AND "船号_BASESHIP".bm IN ('"SUBSTITUTE(科室,",","','")"') "))}
  • 求助

767

9

767

10

个人成就
内容被浏览121,615
加入社区330天
返回顶部