<?
/* K-Rate
(C) Rinalds Uzkalns, 2003-2004. All Rights Reserved
http://turn-k.net

Version: 1.00 (22.09.04)
*/

//initialize the page
        include dirname(__file__).'/init_show.php';

//determine the fields to display in table
        if (is_array($editable_quick)) $editable = $editable_quick;

//show page title
        admin_header('','Manage '.$subj);

//show page menu
        echo $manage_menu;


        

?>

<form action=index.php method=get name=top>
<input type=hidden name=req value='<? echo $en['req']; ?>'>
<table width=100% class=tables cellspacing=0>
 <tr><td class=adm_menu_cat colspan=2>Select <? echo $subj; ?></td></tr>

<? if (is_array($statfield)) { ?>
 <tr class=row1><td class=key>Select which <? echo strtolower($subj); ?> to display</td></tr>
 <tr class=adm_menu_links><td valign=top>
<?
foreach ($statfield as $key => $value)
        echo '<input type=checkbox name=show_'.$key.' id=show_'.$key.' value=ON '.(isset($en['show_'.$key]) ? ' checked' : '').'><label for=show_'.$key.'>'.$value.'</label><br>';
?>
 </tr>
<? } ?>

 <tr><td>
<table width=100%>
<tr class=row1><td colspan=2 class=key>Search and Sorting Options</td></tr>

<tr><td width=80px>Search In</td>

<?
echo '<td align=left><select name=search_in>';
foreach ($srcfields as $key => $value)
        echo '<option value="'.$value.'"'.($en['search_in'] == $value ? ' selected' : '').'>'.(is_numeric($key) ? $fields[$table][$value.($lang_fields[$table][$value] ? '_'.$en['sortlang'] : '')]['title'] : $key).'</option>';
?>
    </select></td></tr>

<tr><td width=80px>Search Term</td>
<td align=left><select name=term_t>
        <option value=like <? echo ($en[term_t] == 'like' ? ' selected' : '');?>>Contains</option>
        <option value=eq <? echo ($en[term_t] == 'eq' ? ' selected' : '');?>>Matches</option>
    </select><input type=text name=term size=20 value="<? echo $en[term];?>"></td></tr>

<tr><td width=80px>Sort First</td>
<td align=left><select name=sort1>
<?
foreach ($srcfields as $key => $value)
        echo '<option value="'.$value.'"'.($en['sort1'] == $value ? ' selected' : '').'>'.(is_numeric($key) ? $fields[$table][$value.($lang_fields[$table][$value] ? '_'.$en['sortlang'] : '')]['title'] : $key).'</option>';
//        echo '<option value="'.$value.'"'.($en['sort1'] == $value ? ' selected' : '').'>'.$fields[$table][$value.($lang_fields[$table][$value] ? '_'.$en['sortlang'] : '')]['title'].'</option>';
?>
    </select><select name=type1>
        <option value=ASC <? echo ($en[type1] == ASC ? ' selected' : '');?>>Ascending</option>
        <option value=DESC <? echo ($en[type1] == DESC ? ' selected' : '');?>>Descending</option>
    </select></td></tr>

<tr><td width=80px>Sort Second</td>
<td align=left><select name=sort2>
<?
foreach ($srcfields as $key => $value)
        echo '<option value="'.$value.'"'.($en['sort2'] == $value ? ' selected' : '').'>'.(is_numeric($key) ? $fields[$table][$value.($lang_fields[$table][$value] ? '_'.$en['sortlang'] : '')]['title'] : $key).'</option>';
//        echo '<option value="'.$value.'"'.($en['sort2'] == $value ? ' selected' : '').'>'.$fields[$table][$value.($lang_fields[$table][$value] ? '_'.$en['sortlang'] : '')]['title'].'</option>';
?>
    </select><select name=type2>
        <option value=ASC <? echo ($en[type2] == ASC ? ' selected' : '');?>>Ascending</option>
        <option value=DESC <? echo ($en[type2] == DESC ? ' selected' : '');?>>Descending</option>
    </select></td></tr>

<tr><td>Per page:</td><td><input type=text name=per_page value="<? echo $en['per_page']; ?>" size=6></td></tr>
<tr><td>Go to page:</td>
<td><select name=page size=1>
   <? $pages = ceil(sql_num_rows($result)/$en['per_page']);
      for ($k=1;$k<=$pages;$k++) echo '<option value='.$k.($en[page] == $k ? ' selected':'').'>'.$k.'</option>';

      echo '</select>';
      if ($en[page]<$pages) echo '<input type=submit name=next value="Next page">';

   ?>

   </td>
   </tr>

<?
//choose default language
//        if (isset($has_lang_fields[$table])) {
                echo '<tr><td width=100px>Language for sorting:</td><td><select name=sortlang>';
                foreach ($langs as $key => $value)
                        echo '<option value="'.$value['l_code'].'"'.($en['sortlang'] == $value['l_code'] ? ' selected' : '').'>'.$value['l_name'].'</option>';
                echo '</select></td></tr>';
//                }
?>

<tr><td colspan=2>
<b><a href='index.php?req=<? echo $en['req']; ?>&act=reset'>Reset Sorting Form</a></b>
</td></tr>

</table>
 </td>
 <td>

<? if ($topmenu_right != '') include $topmenu_right; ?>

 </td>

 </tr>
 <tr><td colspan=2 align=center><input type=submit name=dosubm value="Display <? echo $subj; ?>!"></td></tr>
 </table>
<br>
</form>

<form name='ch' action=index.php method=post enctype="multipart/form-data">
<input type=hidden name=req value='<? echo $en['req']; ?>'>

<style>
.hidden {display: none;}
</style>

<script language=javascript>
function ch_spons(id) {
        setv = !id.checked;
        id.form.show_0.checked = setv;
        id.form.show_1.checked = setv;
        }

function set_values(id) {
        el = 'edit['.concat(id).concat('][<? echo $status;?>]');
        document.forms['ch'].elements[el].value = 1;
        document.forms['ch'].elements['appr_'.concat(id)].className = 'hidden';
        document.forms['ch'].elements['decl_'.concat(id)].className = 'hidden';
        document.forms['ch'].elements['del['.concat(id).concat(']')].checked = false;
        }

function set_decl(id) {
        el = 'edit['.concat(id).concat('][<? echo $status;?>]');
        document.forms['ch'].elements[el].value = 0;
        document.forms['ch'].elements['appr_'.concat(id)].className = 'hidden';
        document.forms['ch'].elements['decl_'.concat(id)].className = 'hidden';
        document.forms['ch'].elements['del['.concat(id).concat(']')].checked = true;
        }

function change_spons(id,l0,l1,l2,l3) {
        val = document.forms['ch'].elements['spons_<? echo $sptype;?>_'.concat(id)].value;
        if (val == 0) setv = l0;
        if (val == 1) setv = l1;
        if (val == 2) setv = l2;
        if (val == 3) setv = l3;
        document.forms['ch'].elements['spons_<? echo $spleft;?>_'.concat(id)].value = setv;
        document.forms['ch'].elements['cb_'.concat(id)].className = '';
        }

function change_back(id,l,dl) {
        document.forms['ch'].elements['spons_<? echo $sptype;?>_'.concat(id)].value = l;
        document.forms['ch'].elements['spons_<? echo $spleft;?>_'.concat(id)].value = dl;
        }

function check_values(id) {
        if (document.forms['ch'].elements['edit_<? echo $status;?>_'.concat(id)].value == 0) {
                document.forms['ch'].elements['appr_'.concat(id)].className = '';
                document.forms['ch'].elements['decl_'.concat(id)].className = '';
                }
        else if (document.forms['ch'].elements['edit_<? echo $status;?>_'.concat(id)].value == 1) {
                document.forms['ch'].elements['appr_'.concat(id)].className = 'hidden';
                document.forms['ch'].elements['decl_'.concat(id)].className = 'hidden';
                }
        }

</script>

<table width=100% class=tables><tr><td align=center class=adm_menu_links><input type=submit name='save' value="Save changes!"></td></tr></table>
<? if (!$hideselect) { ?>
<table width=100% class=tables><tr><td align=center class=adm_menu_cat>Found <? echo sql_num_rows($result).' '.strtolower($subj).'. Displaying '.$from.' to '.$to; ?></td></tr></table>
<? } ?>
<br>
<?

//start the table
        echo '<table class=tables><Tr align=center class=adm_menu_cat><td>Delete</td>';
        foreach ($editable as $key => $value)
                echo '<Td>'.$fields[$table][$value]['title'].'<td>';
        echo '</tr>';

$npk = 0;

while ($line = sql_fetch_assoc($result))
   if (++$npk >=$from && $npk<=$to) {

        echo '<Tr align=center><td><input type=checkbox></td>';
        foreach ($editable as $key => $value)
                echo '<td>'.$line[$value].'</td>';
        echo '</tr>';

        }


?>

<tr><td align=center class=adm_menu_links><input type=submit name='save' value="Save"></td></tr></table>
</form>