function DftrLevel()
{
$s = "SELECT * FROM level WHERE Accounting = 'N' ORDER BY LevelID";
$r = _query($s);
// Buat Grid
echo gridTable('gridid', 350, 800);
$tb = "<table class=grid id=gridid cellspacing=1 cellpadding=4>";
$tb .= "<thead>";
$tb .= "<tr>";
$tb .= "<td colspan=6><input type=button name=add value='Tambah Level'></td></tr>";
$tb .= " <th>Level ID</th></td>";
$tb .= " <th>Nama Level</th></td>";
$tb .= " <th>Tabel User</th></td>";
$tb .= " <th>Aktif</th></td>";
$tb .= "<tr>";
$tb .= "</thead>";
$tb .= "<tbody>";
// Isi Table
$n = 1;
while ($w = _fetch_array($r)) {
$cls = stripTable($n);
$tb .= "<tr class={$cls}>";
$tb .= "<td><a href=?mnux=syslev&gos=edtLevel&md=0&lvl={$w['LevelID']} title=Edit class=editlink><img src='img/edit.png'></img></a> {$w['LevelID']}</td>";
$tb .= "<td>{$w['Nama']}</td>";
$tb .= "<td>{$w['TabelUser']}</td>";
$tb .= "<td><img src='img/{$w['NA']}.gif'></td>";
$tb .= "</tr>";
$n++;
}
$tb .= "</tbody>";
$tb .= "</table>";
echo $tb;
}
function stripTables($db)
{
stripTable($db, 'Results', array('competitionId', 'eventId', 'personId', 'best', 'average'));
stripTable($db, 'Competitions', array('id', 'year', 'month', 'day', 'eventSpecs', 'latitude', 'longitude'));
stripTable($db, 'Persons', array('id', 'name', 'countryId', 'gender'));
stripTable($db, 'Countries', array('id', 'name', 'latitude', 'longitude', 'iso2'));
stripTable($db, 'Events', array('id', 'name', 'rank', 'format', 'cellName'));
}
function DftrMdl()
{
TampilkanMdlGrp();
$whr = '';
$whr .= empty($_SESSION['mdlgrp']) ? '' : "and m.MdlGrpID='{$_SESSION['mdlgrp']}' ";
$s = "select m.*, mg.Urutan\r\n from mdl m\r\n left outer join mdlgrp mg on m.MdlGrpID=mg.MdlGrpID\r\n where m.MdlID>0 and mg.Accounting = 'N' {$whr}\r\n order by mg.Urutan, m.Nama";
$r = mysql_query($s) or die("Gagal: {$s}<br>" . mysql_error());
$n = 0;
TampilkanMenuModul();
echo gridTable('gridid', 300, 1000);
echo "<p><table class=grid id=gridid cellspacing=1 cellpadding=4>\r\n <thead>\r\n <tr><th class=ttl>#</th><th class=ttl>Module</td>\r\n <th class=ttl>Level</th>\r\n <th class=ttl>Script</th>\r\n <th class=ttl>Web</th>\r\n <th class=ttl>Exe</th>\r\n <th class=ttl>Group</th>\r\n <th class=ttl>NA</th>\r\n </tr>\r\n </thead>\r\n <tbody>";
while ($w = mysql_fetch_array($r)) {
$n++;
$c = $w['NA'] == 'Y' ? 'class=nac' : 'class=ul';
$cls = stripTable($n);
echo "<tr class={$cls}><td {$c}><a href=\"?mnux=sysmod&token=ModEdt&md=0&mid={$w['MdlID']}\"><img src='img/edit.png' border=0></a>\r\n {$n}</td>\r\n <td {$c}>{$w['Nama']}</td>\r\n <td {$c}>{$w['LevelID']}</td>\r\n <td {$c}>{$w['Script']}</td>\r\n <td {$c} align=center><img src='img/{$w['Web']}.gif'></td>\r\n <td {$c} align=center><img src='img/{$w['CS']}.gif'></td>\r\n <td {$c}>{$w['MdlGrpID']}</td>\r\n <td {$c} align=center><img src='img/book{$w['NA']}.gif'></td>\r\n </tr>";
}
echo "</tbody></table></p>";
}
