='${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 ]]> ='${p_start_day}' AND create_date <='${p_day}') uu1, (SELECT count(1)as vip_number FROM ums_user WHERE user_usertype = "会员用户" AND create_date >='${p_start_day}' AND create_date <='${p_day}' ) uu2 , (SELECT count(1)as enterprise_number FROM ums_user WHERE user_usertype = "企业注册用户" AND create_date >='${p_start_day}' AND create_date <='${p_day}' ) uu3 , (SELECT count(1)as internal_number FROM ums_user WHERE user_email LIKE "%@geidco.org" AND create_date >='${p_start_day}' AND create_date <='${p_day}') uu4 ]]> ='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3]]> ='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3 ]]> ='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3 ]]> ='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3]]> ='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3 UNION ALL SELECT "外部用户" AS user_usertype ,uu1.external_number AS all_number ,uu2.external_login_number AS login_number,(uu1.external_number - uu2.external_login_number)as nologin_number ,uu3.external_new_login_number AS new_login_number FROM ( SELECT COUNT(1) as external_number FROM ums_user where user_email NOT LIKE "%@geidco.org" AND user_usertype != "会员用户" and user_usertype != "企业注册用户") uu1, (SELECT COUNT(1) as external_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email NOT LIKE "%@geidco.org" AND uu.user_usertype != "会员用户" and uu.user_usertype != "企业注册用户" GROUP BY uu.id ) p) uu2, (SELECT COUNT(1) as external_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email LIKE "%@geidco.org" AND uu.user_usertype != "会员用户" and uu.user_usertype != "企业注册用户"AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3 UNION ALL SELECT "企业注册用户" AS user_usertype , uu1.enterprise_number AS all_number,uu2.enterprise_login_number AS login_number,(uu1.enterprise_number - uu2.enterprise_login_number)as nologin_number ,uu3.enterprise_new_login_number as new_login_number FROM ( SELECT COUNT(1) as enterprise_number FROM ums_user where user_usertype = "企业注册用户") uu1, (SELECT COUNT(1) as enterprise_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "企业注册用户" GROUP BY uu.id ) p) uu2, (SELECT COUNT(1) as enterprise_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "企业注册用户" AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3 UNION ALL SELECT "内部用户"AS user_usertype,uu1.internal_number AS all_number ,uu2.internal_login_number AS login_number,(uu1.internal_number - uu2.internal_login_number)as nologin_number ,uu3.internal_new_login_number AS new_login_number FROM ( SELECT COUNT(1) as internal_number FROM ums_user where user_email LIKE "%@geidco.org") uu1, (SELECT COUNT(1) as internal_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email LIKE "%@geidco.org" GROUP BY uu.id ) p) uu2, (SELECT COUNT(1) as internal_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email LIKE "%@geidco.org" AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3]]> = '${p_start_day}'and records_time <= '${p_day}' GROUP BY data_name]]> = '${p_start_day}'and records_time <= '${p_day}']]> ='2021-03-23' GROUP BY uu.id,uu.user_uid,uu.user_email,uu.user_preferred_mobile ORDER BY logincount DESC;]]> ='{p_start_day}' ),"新增","") AS new_insert FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id AND uu.user_usertype != "会员用户" AND uu.user_usertype !="企业注册用户" and (uu.user_email not like "%@geidco.org%" or isnull(uu.user_email)) and sl.create_date<='${p_day}' and sl.create_date>='2021-03-23' GROUP BY uu.id,uu.user_uid,uu.user_email,uu.user_preferred_mobile ORDER BY logincount DESC;]]> ='2021-03-23' GROUP BY uu.id,uu.user_uid,uu.user_email,uu.user_preferred_mobile ORDER BY logincount DESC;]]> ='2021-03-23' GROUP BY uu.id,uu.user_uid,uu.user_email,uu.user_preferred_mobile ORDER BY logincount DESC; ]]> ='${p_start_day}'AND create_date <='${p_day}')s3, (SELECT COUNT(1) AS month_interview_number FROM sys_log WHERE ( request_uri LIKE '/baseProjectViews%' OR request_uri LIKE '/baseCountryViews%' OR request_uri LIKE '/baseUnitViews%' OR request_uri LIKE '/baseMemberInfos%' OR request_uri LIKE '/committeeInformationReleaseManagementInfos%' OR request_uri LIKE '/baseResearchResultViews%' OR request_uri LIKE '/cmsInformationViews%' OR request_uri LIKE '/meetingBasicInfos%' OR request_uri LIKE '/activityInfos%' OR request_uri LIKE '/baseFinancialInstit%' OR request_uri LIKE '/baseThinkTankInfos%' ) AND create_date >='${p_start_day}'AND create_date <='${p_day}')s4 ]]>

---

        截至" + YEAR($p_day) + "年" + MONTH($p_day) + "月" + DAY($p_day) + "日,对发展合作平台用户注册、登录、访问、内容更新、APP下载情况进行了统计分析，有关情况汇报如下："]]>         平台累计注册用户"+all_number+"个，包括会员用户"+vip_number+"个、外部用户"+extranal_number+"个、企业用户"+enterprise_number+"个与内部用户"+inter_number+"个。"]]> 0,"本月新增会员用户"+vip_number+"个,","")+if(extranal_number>0,"本月新增外部用户"+extranal_number+"个,","")+if(inter_number>0,"本月新增内部用户"+inter_number+"个,","")+if(enterprise_number>0,"本月新增企业用户"+enterprise_number+"个,","")+"各类用户登录情况统计图1所示，其中："]]>         1.会员用户。"+"共计"+vip_number+"个,其中登录平台"+vip_login_number+"个，未登录平台"+vip_nologin_number+"个。登陆率为"+FORMAT(vip_login_number/vip_number,"0.00%")+"。"+if(vip_new_login_number>0,"本月新增登录用户"+vip_new_login_number+"个。","本月无新增登录用户")+"登录情况详见附件1。"]]>         2.外部用户。"+"共计"+external_number+"个,其中登录平台"+external_login_number+"个，未登录平台"+internal_nologin_number+"个。登陆率为"+FORMAT(external_login_number/external_number,"0.00%")+"。"+if(external_new_login_number>0,"本月新增登录用户"+external_new_login_number+"个。","本月无新增登录用户")+"登录情况详见附件2。"]]>         2.外部用户。"+"共计"+enterprise_number+"个,其中登录平台"+enterprise_login_number+"个，未登录平台"+enterprise_nologin_number+"个。登陆率为"+FORMAT(enterprise_login_number/enterprise_number,"0.00%")+"。"+if(enterprise_new_login_number>0,"本月新增登录用户"+enterprise_new_login_number+"个。","本月无新增登录用户")+"登录情况详见附件3。"]]>         4.内部用户。"+"共计"+internal_number+"个,其中登录平台"+internal_login_number+"个，未登录平台"+internal_nologin_number+"个。登陆率为"+FORMAT(internal_login_number/internal_number,"0.00%")+"。"+if(internal_new_login_number>0,"本月新增登录用户"+internal_new_login_number+"个。","本月无新增登录用户")+"登录情况详见附件3。"]]>

        平台累计发布业务数据" + ds_business_total.select(update_number_all) + "条（详见附件6），其中" + JOINARRAY(MAPARRAY(ds_business.select(data_name), item + INDEXOF(ds_business.select(update_number_all), INARRAY(item, ds_business.select(data_name))) + "条"), "、") + "。"]]>         本月新增数据" + ds_business2_total.select(update_number) + "条（详见附件6），其中" + JOINARRAY(MAPARRAY(ds_business2.select(data_name), item + INDEXOF(ds_business2.select(update_number), INARRAY(item, ds_business2.select(data_name))) + "条"), "、") + "。"]]>