R6: 出店カードからFestivalStallPlacementをフォーム編集できる導線を追加 |
R7: 座標付き出店情報のみ屋台地図と連動 |
||
| 430行目: | 430行目: | ||
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._pageName=page_name,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.opening_time=opening_time,P.closing_time=closing_time,P.hours_note=hours_note,P.location_note=location_note,P.position_status=position_status,P.position_accuracy_m=position_accuracy_m,P.verification_status=verification_status,P.status=status,P.last_confirmed=last_confirmed | |fields=P.placement_id=placement_id,P._pageName=page_name,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.opening_time=opening_time,P.closing_time=closing_time,P.hours_note=hours_note,P.location_note=location_note,P.position_status=position_status,P.position_accuracy_m=position_accuracy_m,P.verification_status=verification_status,P.status=status,P.last_confirmed=last_confirmed | ||
|where=P.festival_id={{PAGEID}} AND P.year={{CURRENTYEAR}} | |where=P.festival_id={{PAGEID}} AND P.year={{CURRENTYEAR}} | ||
|order by=P.sort_order ASC,S.name ASC | |order by=P.sort_order ASC,S.name ASC | ||