<h3>Welcome to AutoCRUD, an automagic web interface for databases</h3>
<br />
[% IF cpac.c.keys.size == 0 %]
<p>No database schemas were found in this application. Please contact the site administrator.</p>
[% RETURN %]
[% ELSE %]
[% IF cpac.c.exists( cpac_db ) %]
[% IF cpac.c.$cpac_db.hidden == 'yes' %]
[% IF cpac.g.site == 'default' %]
<p>Return <a href="[% c.uri_for( c.controller('AutoCRUD::Root').action_for('no_db') ) %]">
Home</a> to select another database.</p>
[% ELSE %]
<p>Return <a href="[% c.uri_for( c.controller('AutoCRUD::Root').action_for('no_schema'), [cpac.g.site] ) %]">
Home</a> to select another database.</p>
[% END %]
[% RETURN %]
[% END %]
<p>The schema for database "[% cpac.c.$cpac_db.display_name %]" has been loaded,
so please select a table by clicking on its label, below.</p>
<br />
<div id="cpac_navcontainer">
<ul>
[% FOREACH t IN cpac.c.$cpac_db.t.keys.sort %]
[% NEXT IF cpac.c.$cpac_db.t.$t.hidden == 'yes' %]
<li>
[% IF cpac.g.site == 'default' %]
<a href="[% c.uri_for( c.controller('AutoCRUD::Root').action_for('table'), [cpac_db], t ) %]">
[% cpac.c.$cpac_db.t.$t.display_name %]</a>
[% ELSE %]
<a href="[% c.uri_for( c.controller('AutoCRUD::Root').action_for('source'), [cpac.g.site, cpac_db], t ) %]">
[% cpac.c.$cpac_db.t.$t.display_name %]</a>
[% END %]
</li>
[% END %]
</ul>
</div>
[% IF cpac.c.keys.size > 1 %]
<br />
[% IF cpac.g.site == 'default' %]
<p>Return <a href="[% c.uri_for( c.controller('AutoCRUD::Root').action_for('no_db') ) %]">
Home</a> to select another database.</p>
[% ELSE %]
<p>Return <a href="[% c.uri_for( c.controller('AutoCRUD::Root').action_for('no_schema'), [cpac.g.site] ) %]">
Home</a> to select another database.</p>
[% END %]
[% END %]
[% ELSE %]
<p>The following database schemas have been loaded.
Please select one by clicking on its label, below.</p>
<br />
<div id="cpac_navcontainer">
<ul>
[% FOREACH d IN cpac.c.keys.sort %]
[% NEXT IF cpac.c.$d.hidden == 'yes' %]
<li>
[% IF cpac.g.site == 'default' %]
<a href="[% c.uri_for( c.controller('AutoCRUD::Root').action_for('no_table'), [d] ) %]">
[% cpac.c.$d.display_name %]</a>
[% ELSE %]
<a href="[% c.uri_for( c.controller('AutoCRUD::Root').action_for('no_source'), [cpac.g.site, d] ) %]">
[% cpac.c.$d.display_name %]</a>
[% END %]
</li>
[% END %]
</ul>
</div>
[% END %]
[% END %]