{assign var='db' value=$item->dbname|htmlspecialchars}
{assign var='prefix' value=$item->tablePrefix|htmlspecialchars}
{assign var='errorsCount' value=$item->errors|@count}
<style type="text/css">
    #fields-report td, #fields-report th {$smarty.ldelim} padding: 4px; {$smarty.rdelim}
    #fields-report .high {$smarty.ldelim} color: #FF0000; {$smarty.rdelim}
    #fields-report .low {$smarty.ldelim} color: #808080; {$smarty.rdelim}
</style>

<div class="alert alert-info"><i class="fa fa-info-circle fa-lg"></i>
    Please Note: This report is approximate, some errors and warnings are redundant.
    Report does not analyze tables and fields that are joined.
 </div>

<div id="fields-report">
    <h4>Legend</h4>
    <a data-role="legendSwitch" href="#">show legend</a>
    <table data-role="legend" class="table" style="display: none;">
        {* NON-EXISTENT FILE FIELD *}
        <tr>
            <th rowspan="2"><strong>{$item->errors.errNonExistentFileField}</strong></th>
            <td>Field declared in Qs_Db_Obj::_fileFields but missed in db table</td>
        </tr>
        <tr>
            <td><span class="high"><i class="fa fa-exclamation-triangle"></i></span> Always HIGH Priority</td>
        </tr>


        {* NON-EXISTENT URL FIELD *}
        <tr>
            <th rowspan="2"><strong>{$item->errors.errNonExistentUrlField}</strong></th>
            <td>Field declared in Qs_Db_Obj::_urlParseFields but missed in db table</td>
        </tr>
        <tr>
            <td><span class="high"><i class="fa fa-exclamation-triangle"></i></span> Always HIGH Priority</td>
        </tr>


        {* UNDECLARED FILE FIELD *}
        <tr>
            <th rowspan="3"><strong>{$item->errors.errUndeclaredFileField}</strong></th>
            <td>Table field that look like file field, by missed in Qs_Db_Obj::_fileFields</td>
        </tr>
        <tr>
            <td><span class="high"><i class="fa fa-exclamation-triangle"></i></span>
                Field name contains words "file", "image", "path"
            </td>
        </tr>
        <tr>
            <td><span class="low"><i class="fa fa-exclamation-triangle"></i></span>
                Other fields with data type "char" or "varchar", and data length &gt; 12
            </td>
        </tr>


        {* UNDECLARED URL FIELD *}
        <tr>
            <th rowspan="3"><strong>{$item->errors.errUndeclaredUrlField}</strong></th>
            <td>Table field that look like url field, by missed in Qs_Db_Obj::_urlParseFields</td>
        </tr>
        <tr>
            <td><span class="high"><i class="fa fa-exclamation-triangle"></i></span>
                Field name contains words "url", "link", "content", "description"
            </td>
        </tr>
        <tr>
            <td><span class="low"><i class="fa fa-exclamation-triangle"></i></span>
                Other fields with data type "char" or "varchar", and data length &gt; 12<br>
                Or fields with data type "text", "mediumtext", "longtext"
            </td>
        </tr>
    </table>
    <br>
    <hr>

{if $item->list}
    <h2>Report</h2>
    <a data-role="warningSwitch" href="#">hide warnings</a>
    <table data-role="report" class="table table-bordered">
        {foreach from=$item->list item='row'}
        <tbody>
            <tr style="background-color: #efefef">
                <td><a target="_blank"
                       href="http://dev.orange35.com/phpMyAdmin3/sql.php?db={$db}&amp;table={$prefix}{$row.tableAlias|htmlspecialchars}"><strong>{$prefix}{$row.tableAlias|htmlspecialchars}</strong></a>
                </td>
                <td colspan="{$errorsCount}">
                    <strong>{$row.className|htmlspecialchars}</strong>:
                    {if $row.repositoryUrl}<a target="_blank" href="{$row.repositoryUrl}">{$row.fileName|htmlspecialchars}</a>{else}{$row.fileName|htmlspecialchars}{/if}
                </td>
            </tr>
            <tr>
                <th></th>
                {foreach from=$item->errors key='code' item='title'}
                    <th><strong>{$title|htmlspecialchars}</strong></th>
                {/foreach}
            </tr>
            {foreach from=$row.fields item='field' key='name'}
                <tr data-role="field">
                    <td>
                        <strong>{$name|htmlspecialchars}</strong>{if isset($field.type)} {$field.type|htmlspecialchars}{/if}
                    </td>
                    {foreach from=$item->errors key='code' item='title'}
                        {if isset($field[$code])}
                            <td><span data-error="{$field[$code]}" class="{$field[$code]}"><i
                                            class="fa fa-exclamation-triangle"></i></span></td>
                        {else}
                            <td></td>
                        {/if}
                    {/foreach}
                </tr>
            {/foreach}
        </tbody>
        {/foreach}
    </table>
{/if}
</div>