请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
圣体叶小凡(uid:73830)
职业资格认证:FCP-报表开发工程师 | FCA-业务分析理论 | FCA-FineBI | FCP-报表交付工程师
  • 图1是下载路径写法,图2是数据库存的文件名称,图3是已经提交成功上传到服务器的文件名称和路径,就是下载的时候不行······,谁帮我指导一下
  • 想在移动端实现勾选对应复选框后,点击删除,删除对应勾选的行
  • 10.0版本钉钉插件,用户登录后,我关了钉钉app,重新进报表平台需要再登录账号,可以保留登录信息么,不要我重新登录(补贴孤陌)
  • 在我数据库查询的时候,下面这样写没啥问题,正常运行select * from  uportal.t_center_out union ALLselect * from  uportaltw.t_center_out union ALLselect * from  uportalgh.t_center_out但是在帆软设计器里面,sql中 union all 了 uportalgh 的表,一运行就开始报错,报内网ip错误SELECT command denied to user 'yycoinadmin'@'内网ip' for table 't_center_out'    ,有人遇到过类似的问题么
  • 由于业务员操作时候,有时候格式刷刷了整个excel,然后原样导入excel的时候,直接把系统给卡死了,能在原样导入的时候,获取excel大小,限制一下,例如超过1M就不让导入了
  • 勾选对应数据后,按照公司,将对应金额汇总
  • 由于公司的原因,从3月1号开始算新的1年,这样的话,345,算是第一个季度,678是第二个,然后按照自然月来算,3月1号至3月3号算是第一周,然后3月4日至10日算是第二周,这样排下去,然后等到6月1号的时候,6月1号至2号算是第二季度的第一周,前面的5月27号~31号算是上个季度的最后一周,我现在按照当前日期判断,需要把这个第几周提交入库,请教大佬怎么计算么,poseidon大佬帮忙写了,公司如下"第" + NUMTO(IF(DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") > 7 || WEEK(today()) <> WEEK(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01")))))), IF(WEEKDAY(today()) = 0, ROUNDUP((DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") - WEEKDAY(today())) / 7, 0), ROUNDUP((DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") - WEEKDAY(today())) / 7 + 1, 0)), 1)) + "周"
  • 我现在遇到这种情况,需要每周填一次数据,这个模板是可以填写可以修改,所以需要把sql把字段拖到页面修改,这个sql如何根据自然周来判断,到下一个周查询的数据就是空?然后我填写的数据提交就到了数据库,可以设置插入和更新提交,然后判断是属于第一次录入还是更新

87

1554

87

10

个人成就
内容被浏览136,384
加入社区8年50天
返回顶部