<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfinclude template="header.cfm">

<cfif NOT (parameterExists(getuser.id) AND getuser.accesslevel EQ 100)>
    <cfabort>
</cfif>

<cfquery name="syncCulturalArts" datasource="#ds#">
    UPDATE CulturalArts ca
    INNER JOIN cultimport ci ON ca.id = ci.id
    SET ca.tags = ci.tags,
        ca.image_url = ci.image_url,
        ca.featured = ci.featured,
        ca.status_code = ci.status_code,
        ca.hours = ci.hours,
        ca.ticket_price = ci.ticket_price,
        ca.free_days = ci.free_days,
        ca.exhibit1 = ci.exhibit1,
        ca.exhibit2 = ci.exhibit2,
        ca.exhibit_open_date_1 = ci.exhibit_open_date_1,
        ca.exhibit_close_date_1 = ci.exhibit_close_date_1,
        ca.exhibit_open_date_2 = ci.exhibit_open_date_2,
        ca.exhibit_close_date_2 = ci.exhibit_close_date_2
</cfquery>

<cfquery name="getCultImport" datasource="#ds#">
    SELECT
        id,
        tags,
        image_url,
        featured,
        status_code,
        hours,
        ticket_price,
        free_days,
        exhibit1,
        exhibit2,
        exhibit_open_date_1,
        exhibit_close_date_1,
        exhibit_open_date_2,
        exhibit_close_date_2
    FROM cultimport
    ORDER BY id
</cfquery>

<div id="content">
    <div id="content-header">
        <h1>cultimport &rarr; CulturalArts Sync</h1>
    </div>
    <div class="container-fluid" style="margin-left:200px;">
        <cfoutput>
        </cfoutput>

        <table class="table table-bordered table-striped" width="100%">
            <thead>
                <tr>
                    <th>ID</th>
                    <th>Tags</th>
                    <th>Image URL</th>
                    <th>Featured</th>
                    <th>Status Code</th>
                    <th>Hours</th>
                    <th>Ticket Price</th>
                    <th>Free Days</th>
                    <th>Exhibit 1</th>
                    <th>Exhibit 2</th>
                    <th>Open Date 1</th>
                    <th>Close Date 1</th>
                    <th>Open Date 2</th>
                    <th>Close Date 2</th>
                </tr>
            </thead>
            <tbody>
                <cfoutput query="getCultImport">
                    <tr>
                        <td>#id#</td>
                        <td>#htmleditformat(tags)#</td>
                        <td>#htmleditformat(image_url)#</td>
                        <td>#featured#</td>
                        <td>#status_code#</td>
                        <td>#htmleditformat(hours)#</td>
                        <td>#htmleditformat(ticket_price)#</td>
                        <td>#htmleditformat(free_days)#</td>
                        <td>#htmleditformat(exhibit1)#</td>
                        <td>#htmleditformat(exhibit2)#</td>
                        <td>#exhibit_open_date_1#</td>
                        <td>#exhibit_close_date_1#</td>
                        <td>#exhibit_open_date_2#</td>
                        <td>#exhibit_close_date_2#</td>
                    </tr>
                </cfoutput>
            </tbody>
        </table>
    </div>
</div>

<cfinclude template="footer.cfm">