<?php

require_once dirname(__FILE__).'/accesscheck.php';

if (isset($_GET['delete'])) {
    # delete the index in delete
  $delete = sprintf('%d', $_GET['delete']);
    print $GLOBALS['I18N']->get('Deleting')." $delete ...\n";
    $result = Sql_query('delete from '.$tables['template']." where id = $delete");
    $result = Sql_query('delete from '.$tables['templateimage']." where template = $delete");
    print '... '.$GLOBALS['I18N']->get('Done')."<br /><hr /><br />\n";
}
if (isset($_POST['defaulttemplate'])) {
    saveConfig('defaultmessagetemplate', sprintf('%d', $_POST['defaulttemplate']));
}
if (isset($_POST['systemtemplate'])) {
    saveConfig('systemmessagetemplate', sprintf('%d', $_POST['systemtemplate']));
}

$req = Sql_Query("select * from {$tables['template']} order by listorder");
if (!Sql_Affected_Rows()) {
    print '<p class="information">'.$GLOBALS['I18N']->get('No template have been defined').'</p>';
}

$defaulttemplate = getConfig('defaultmessagetemplate');
$systemtemplate = getConfig('systemmessagetemplate');
print formStart('name="templates" class="templatesEdit" ');
$ls = new WebblerListing($GLOBALS['I18N']->get('Existing templates'));
while ($row = Sql_fetch_Array($req)) {
    $img_template = '<img src="images/no-image-template.png" />';
    if (file_exists('templates/'.$row['id'].'.jpg')) {
        $img_template = '<img src="templates/'.$row['id'].'.jpg" />';
    }
    $element = $row['title'];
    $ls->addElement($element, PageUrl2('template&amp;id='.$row['id']));
    $ls->setClass($element, 'row1');
    $ls->addColumn($element, $GLOBALS['I18N']->get('ID'), $row['id']);
    $ls->addRow($element, $img_template, '<span class="button">'.PageLinkDialogOnly('viewtemplate&amp;id='.$row['id'], $GLOBALS['img_view']).'</span>'.sprintf('<span class="delete"><a class="button" href="javascript:deleteRec(\'%s\');" title="'.$GLOBALS['I18N']->get('delete').'">%s</a>', PageUrl2('templates', '', 'delete='.$row['id']), $GLOBALS['I18N']->get('delete')));
#  $imgcount = Sql_Fetch_Row_query(sprintf('select count(*) from %s where template = %d',
#    $GLOBALS['tables']['templateimage'],$row['id']));
#  $ls->addColumn($element,$GLOBALS['I18N']->get('# imgs'),$imgcount[0]);
#  $ls->addColumn($element,$GLOBALS['I18N']->get('View'),);
  $ls->addColumn($element, $GLOBALS['I18N']->get('Campaign Default'), sprintf('<input type=radio name="defaulttemplate" value="%d" %s onchange="document.templates.submit();">',
    $row['id'], $row['id'] == $defaulttemplate ? 'checked' : ''));
    $ls->addColumn($element, $GLOBALS['I18N']->get('System'), sprintf('<input type=radio name="systemtemplate" value="%d" %s onchange="document.templates.submit();">',
    $row['id'], $row['id'] == $systemtemplate ? 'checked' : ''));
}
print $ls->display();

print '</form>';

print '<p class="button">'.PageLink2('template', $GLOBALS['I18N']->get('Add new Template')).'</p>';

$exists = Sql_Fetch_Row_Query(sprintf('select * from %s where title = "System Template"', $GLOBALS['tables']['template']));
if (empty($exists[0])) {
    print '<p class="button">'.PageLink2('defaultsystemtemplate', $GLOBALS['I18N']->get('Add default system template')).'</p>';
}
