R42-18L 屋台未登録年にも追加導線を表示 |
R42-33C 屋台写真の整理待ちと安全な一括取り込み |
||
| (同じ利用者による、間の3版が非表示) | |||
| 404行目: | 404行目: | ||
屋台名や商品名、カテゴリ、会場から屋台を探せます。地図上のピンから場所を確認したり、屋台同士を比較することもできます。 | 屋台名や商品名、カテゴリ、会場から屋台を探せます。地図上のピンから場所を確認したり、屋台同士を比較することもできます。 | ||
</div> | </div> | ||
<div class="festival-stall-batch-link">[{{fullurl:屋台写真一括登録|festival_id={{PAGEID}}}} 写真をまとめて整理する（屋台名は後から登録）]</div> | |||
<div class="festival-stall-contribute"> | <div class="festival-stall-contribute"> | ||
<div class="festival-stall-contribute-title">この祭りで見かけた屋台はありますか？</div> | <div class="festival-stall-contribute-title">この祭りで見かけた屋台はありますか？</div> | ||
| 478行目: | 479行目: | ||
tables=FestivalStallPlacements=P,Stalls=S,Venues=V,Areas=A | tables=FestivalStallPlacements=P,Stalls=S,Venues=V,Areas=A | ||
|join on=P.stall_id=S.stall_id,P.venue_id=V.venue_id,V.area_id=A.area_id | |join on=P.stall_id=S.stall_id,P.venue_id=V.venue_id,V.area_id=A.area_id | ||
|fields=P.placement_id=placement_id,P.latitude=latitude,P.longitude=longitude,S._pageName=stall_page,S.name=stall_name,S.category=category,V._pageName=venue_page,V.name=venue_name,A._pageName=area_page,A.name=area_name,P.location_note=location_note,P.position_status=position_status,P.position_accuracy_m=position_accuracy_m,P.verification_status=verification_status | |fields=P.placement_id=placement_id,P._pageName=placement_page,P.latitude=latitude,P.longitude=longitude,S._pageName=stall_page,S.name=stall_name,S.category=category,V._pageName=venue_page,V.name=venue_name,A._pageName=area_page,A.name=area_name,P.location_note=location_note,P.position_status=position_status,P.position_accuracy_m=position_accuracy_m,P.verification_status=verification_status | ||
|where=P.festival_id={{PAGEID}} AND P.year={{LOCALYEAR}} | |where=P.festival_id={{PAGEID}} AND P.year={{LOCALYEAR}} AND P.latitude IS NOT NULL AND P.longitude IS NOT NULL | ||
|order by=P.sort_order ASC | |order by=P.sort_order ASC | ||
|format=template | |format=template | ||
| 487行目: | 488行目: | ||
|more results text= | |more results text= | ||
}} | }} | ||
; | {{#if: | ||
{{#cargo_query: | |||
tables=FestivalStallPlacements=P | |||
|fields=P.placement_id | |||
|where=P.festival_id={{PAGEID}} AND P.year={{LOCALYEAR}} AND P.latitude IS NOT NULL AND P.longitude IS NOT NULL | |||
|limit=1 | |||
|format=list | |||
|delimiter= | |||
|default= | |||
}} | |||
|{{#if: | |||
{{#cargo_query: | |||
tables=FestivalTemporaryFacilities=T | |||
|fields=T.facility_id | |||
|where=T.festival_id={{PAGEID}} AND T.year={{LOCALYEAR}} AND T.latitude IS NOT NULL AND T.longitude IS NOT NULL | |||
|limit=1 | |||
|format=list | |||
|delimiter= | |||
|default= | |||
}} | |||
|; | |||
}} | |||
}} | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=FestivalTemporaryFacilities=T | tables=FestivalTemporaryFacilities=T | ||
|fields=T.facility_id=facility_id,T._pageName=page_name,T.facility_type=facility_type,T.label=label,T.latitude=latitude,T.longitude=longitude,T.location_note=location_note,T.position_status=position_status,T.verification_status=verification_status,T.status=status | |fields=T.facility_id=facility_id,T._pageName=page_name,T.facility_type=facility_type,T.label=label,T.latitude=latitude,T.longitude=longitude,T.location_note=location_note,T.position_status=position_status,T.verification_status=verification_status,T.status=status | ||
|where=T.festival_id={{PAGEID}} AND T.year={{LOCALYEAR}} | |where=T.festival_id={{PAGEID}} AND T.year={{LOCALYEAR}} AND T.latitude IS NOT NULL AND T.longitude IS NOT NULL | ||
|order by=T.sort_order ASC,T.facility_id ASC | |order by=T.sort_order ASC,T.facility_id ASC | ||
|format=template | |format=template | ||