='${p_start_day}']]> ='${p_start_day}' ]]> ='${p_start_day}' ]]> ='${p_start_day}' GROUP BY data_type ORDER BY CONVERT(sum_number,SIGNED) DESC ]]> = DATE_ADD(DATE_FORMAT('${p_start_day}',"%y-%m-%d"),interval -1 day) AND records_time <'${p_day}' ) AS any_update_number, ( SELECT CONCAT(',其中',GROUP_CONCAT(CONCAT(data_name,update_number,'条'))) AS update_info FROM platform_buisness_data_record WHERE DATE_ADD(DATE_FORMAT(records_time,"%y-%m-%d"),interval 1 day)='${p_day}' AND update_number>0 GROUP BY records_time ) AS one_update_info, ( SELECT CONCAT(',其中',GROUP_CONCAT(CONCAT(data_name,update_number,'条'))) AS update_info FROM (select data_name , SUM(update_number) as update_number from platform_buisness_data_record where records_time >= DATE_ADD(DATE_FORMAT('${p_start_day}',"%y-%m-%d"),interval -1 day) AND records_time <'${p_day}' GROUP BY data_name) AS a WHERE update_number>0 ) AS any_update_info FROM platform_buisness_data_record WHERE DATE_ADD(DATE_FORMAT(records_time,"%y-%m-%d"),interval 1 day)='${p_day}']]> ='${p_start_day}' AND r1.data_name=d.dict_name ) AS update_number,( SELECT MAX(r1.update_number_all) AS update_number_all FROM platform_buisness_data_record r1 WHERE DATE_ADD(DATE_FORMAT(r1.records_time,"%y-%m-%d"),interval 1 day)<='${p_day}' AND DATE_ADD(DATE_FORMAT(r1.records_time,"%y-%m-%d"),interval 1 day)>='${p_start_day}' AND r1.data_name=d.dict_name ) AS update_number_all FROM sys_dict_misc d WHERE d.dict_type_code='INTERVIEW_TYPE_DATA' ORDER BY d.dict_disp_order ]]> ='2021-03-23' AND sum_number > 0 GROUP BY DATE_FORMAT(records_time,'%Y-%m-%d') ORDER BY records_time]]> ='2021-03-23' GROUP BY DATE_FORMAT(records_time,'%Y-%m-%d') ORDER BY records_time]]> = DATE_SUB(DATE_FORMAT('${p_day}','%Y-%m-%d'), INTERVAL 6 DAY) GROUP BY DATE_FORMAT(records_time,'%Y-%m-%d') ORDER BY records_time;]]> ='2021-03-23' GROUP BY DATE_FORMAT(records_time,'%Y-%m-%d') ORDER BY records_time]]> = DATE_SUB(DATE_FORMAT('${p_day}','%Y-%m-%d'), INTERVAL 6 DAY) GROUP BY DATE_FORMAT(records_time,'%Y-%m-%d') ORDER BY records_time ]]> ='2021-03-23' ORDER BY records_time]]> ='2021-03-23' GROUP BY DATE_FORMAT(records_time,'%Y-%m-%d') ORDER BY records_time ]]> = DATE_FORMAT('2021-03-23','%Y-%m-%d') AND CAST(register_number AS SIGNED) > 50 GROUP BY DATE_FORMAT(records_time,'%Y-%m-%d') ORDER BY records_time ]]> ='${p_start_day}' AND STATUS='1' GROUP BY cooperation,cooperation_dict ORDER BY cooperation_dict) a,(SELECT @i:=0) t2 ORDER BY a.cooperation_dict ) temp , sys_dict_misc d WHERE temp.rownum = d.dict_name AND d.dict_type_code='CHARACTER_SORT_CN_DICT']]>

---

        1.用户注册。"+ if($p_day_count > 1, MONTH(datedelta($p_start_day,-1)) + "月" + DAY(datedelta($p_start_day,-1)) + "日" + "至"+ MONTH(datedelta($p_day,-1)) + "月" + DAY(datedelta($p_day,-1)) + "日期间",( MONTH(datedelta($p_day,-1)) + "月" + DAY(datedelta($p_day,-1)) + "日")) +"新增注册用户"+sum_number+"个，当前平台累计注册用户数为"+latest_number_all+"个。其中,1205个会员账号和密码,合作局于2021年5月底通过邮件批量发送功能发至每位会员。"]]>

        2.用户登录。"+if($p_day_count > 1, MONTH(datedelta($p_start_day,-1)) + "月" + DAY(datedelta($p_start_day,-1)) + "日" + "至"+ MONTH(datedelta($p_day,-1)) + "月" + DAY(datedelta($p_day,-1)) + "日期间",(MONTH(datedelta($p_day,-1)) + "月" + DAY(datedelta($p_day,-1)) + "日"))+"有"+total_number+"个用户登录平台，其中合作组织内部用户"+internal_number+"个，外部用户"+external_number+"个。平台用户登录次数累计"+total_number_all+"次。
"+"        截至目前，共有396个用户登录过平台,其中会员用户40个,合作组织内部用户227个,其他个人用户125个、企业用户4个。
"]]>

1, MONTH(datedelta($p_start_day,-1)) + "月" + DAY(datedelta($p_start_day,-1)) + "日" + "至"+ MONTH(datedelta($p_day,-1)) + "月" + DAY(datedelta($p_day,-1)) + "日期间",(MONTH(datedelta($p_day,-1)) + "月" + DAY(datedelta($p_day,-1)) + "日"))+"总访问次数为"+total_number+"次，其中未注册用户访问"+unregister_number+"次，注册用户访问"+register_number+"次。平台累计访问次数"+round(total_number_all/10000,2)+"万次。"]]>

        各模块" + if($p_day_count > 1, MONTH(datedelta($p_start_day, -1)) + "月" + DAY(datedelta($p_start_day, -1)) + "日" + "至" + MONTH(datedelta($p_day, -1)) + "月" + DAY(datedelta($p_day, -1)) + "日期间", (MONTH(datedelta($p_day, -1)) + "月" + DAY(datedelta($p_day, -1)) + "日")) + "访问数据见下表。"]]> 1, MONTH(datedelta($p_start_day,-1)) + "月" + DAY(datedelta($p_start_day,-1)) + "日" + "至"+ MONTH(datedelta($p_day,-1)) + "月" + DAY(datedelta($p_day,-1)) + "日期间"+"业务数据更新"+any_update_number+"条"+if(any_update_number>0,any_update_info,"")+"。平台业务数据累计"+format(update_number_all/10000,"##0.00")+"万条。",MONTH(datedelta($p_day,-1)) + "月" + DAY(datedelta($p_day,-1)) + "日"+"业务数据更新"+one_update_number+"条"+if(one_update_number>0,one_update_info,"")+"。平台业务数据累计"+format(update_number_all/10000,"##0.00")+"万条。")]]>