query_pp_dailypaper.cptselect * from input_pp_dailypaper twheret.factorycode='${factorycode}'andt.period = '${date}'order by t.period选择某一天,让这一天的数据只显示在这一天的列上日期是根据月份扩展的RANGE(DATE(YEAR($date), MONTH($date), 1), DATE(YEAR($date), MONTH($date), DAY(DATEINMONTH($date, -1))))