数据集是: SELECT count( member_id ) as a, a.travel_city_id FROM (SELECT DISTINCT ( member_id ), travel_city_id FROM ads_brand_contact WHERE is_member = 1 AND date_format( now( ), '%Y-%m-%d' ) = substr( register_time, 1, 10 ) ) a where travel_city_id in ('${travel_city_id}') group by travel_city_id 复选框的数据字典 sql("JDBC3", "SELECT travel_city_id FROM dim_crm_poster_inviter_employee a where a.employee_number='"+$fine_username+"'"),1) 问题是: 现在有10个文旅城对应10个travel_city_id ads_brand_contact ,dim_crm_poster_inviter_employee这两个表中都是以 travel_city_id 匹配的,想实现下拉框的实际值是travel_city_id,但是显示值是每个travel_city_id对应的文旅城名称。要怎样修改模板才能实现? |