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 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>"; }