echo "</table>"; //Lakukan Normalisasi dengan rumus pada langkah 2 //Cari Max atau min dari tiap kolom Matrik $crMax = mysql_query("SELECT max(id_bencana) as maxK1, \n\t\t\t\t\t\tmax(kerusakan) as maxK2,\n\t\t\t\t\t\tmax(id_bencana) as maxK3,\n\t\t\t\t\t\tmax(pengungsi) as maxK4 \n\t\t\tFROM tbl_informasi"); $max = mysql_fetch_array($crMax); //Hitung Normalisasi tiap Elemen $sql2 = mysql_query("SELECT * FROM tbl_informasi"); //Buat tabel untuk menampilkan hasil echo "\n\t<table width=500 style='border:1px; #ddd; solid; border-collapse:collapse' border=1>\n\t\t\n\t\t"; $no = 1; while ($dt2 = mysql_fetch_array($sql2)) { "<tr>\n\t\t\t<td>{$no}</td><td>" . getId_prov($dt2['id_prov']) . "</td><td>" . getId_bencana($dt2['id_bencana']) . "</td><td>" . getNama($dt2['id_info']) . "</td><td>" . round($dt2['id_bencana'] / $max['maxK1'], 2) . "</td><td>" . round($dt2['kerusakan'] / $max['maxK2'], 2) . "</td><td>" . round($dt2['id_bencana'] / $max['maxK3'], 2) . "</td><td>" . round($dt2['pengungsi'] / $max['maxK4'], 2) . "</td>\n\t\t</tr>"; $no++; } echo "</table>"; //Proses perangkingan dengan rumus langkah 3 $sql3 = mysql_query("SELECT * FROM tbl_informasi"); //Buat tabel untuk menampilkan hasil echo " <center><H3>Sistem Pendukung Keputusan Metode SAW</H3>\n\t<table width=500 style='border:1px; #ddd; solid; border-collapse:collapse' border=1>\n\t\t<tr>\n\t\t\t<td>No</td><td>id provinsi</td><td>id bencana</td><td>id info</td><td>jenis</td><td>Rangking</td>\n\t\t</tr> </center>\n\t\t"; $no = 1; //Kita gunakan rumus (Normalisasi x bobot) while ($dt3 = mysql_fetch_array($sql3)) { echo "<tr>\n\t\t\t<td>{$no}</td><td>" . getId_prov($dt3['id_prov']) . "</td><td>" . getId_bencana($dt3['id_bencana']) . "</td><td>" . getNama($dt3['id_info']) . "</td><td>" . getJenis($dt3['jenis']) . "</td>\n\t\t\t<td>" . round($dt3['id_bencana'] / $max['maxK1'] * $bobot[0] + $dt3['kerusakan'] / $max['maxK2'] * $bobot[1] + $dt3['id_bencana'] / $max['maxK3'] * $bobot[2] + $dt3['pengungsi'] / $max['maxK4'] * $bobot[3], 2) . "</td>\n\t\t\t\n\t\t</tr>"; $no++; } echo "</table>"; echo " pilih urutan 3 paling bawah atau 3 ranking paling tinggi"; ?> </footer> </br></html>
//Cari Max atau min dari tiap kolom Matrik $crMax = mysql_query("SELECT max(id_bencana) as maxK1, \n\t\t\t\t\t\tmax(kerusakan) as maxK2,\n\t\t\t\t\t\tmax(id_bencana) as maxK3,\n\t\t\t\t\t\tmax(pengungsi) as maxK4 \n\t\t\tFROM tbl_informasi"); $max = mysql_fetch_array($crMax); //Hitung Normalisasi tiap Elemen $sql2 = mysql_query("SELECT * FROM tbl_informasi"); //Buat tabel untuk menampilkan hasil echo "\n\t<table width=500 style='border:1px; #ddd; solid; border-collapse:collapse' border=1>\n\t\t"; $no = 1; while ($dt2 = mysql_fetch_array($sql2)) { "<tr>\n\t\t\t<td>{$no}</td><td>" . getId_prov($dt2['id_prov']) . "</td><td>" . getId_bencana($dt2['id_bencana']) . "</td><td>" . getNama($dt2['id_info']) . "</td><td>" . round($dt2['id_bencana'] / $max['maxK1'], 2) . "</td><td>" . round($dt2['kerusakan'] / $max['maxK2'], 2) . "</td><td>" . round($dt2['id_bencana'] / $max['maxK3'], 2) . "</td><td>" . round($dt2['pengungsi'] / $max['maxK4'], 2) . "</td>\n\t\t</tr>"; $no++; } echo "</table>"; //Proses perangkingan dengan rumus langkah 3 $sql3 = mysql_query("SELECT * FROM tbl_informasi"); //Buat tabel untuk menampilkan hasil echo " <center><H3>Sistem Pendukung Keputusan Metode SAW</H3>\n\t<table width=500 style='border:1px; #ddd; solid; border-collapse:collapse' border=1>\n\t\t<tr>\n\t\t\t<td>No</td><td>id provinsi</td><td>id bencana</td><td>id info</td><td>jenis</td><td>Rangking</td>\n\t\t</tr> </center>\n\t\t"; $no = 1; //Kita gunakan rumus (Normalisasi x bobot) while ($dt3 = mysql_fetch_array($sql3)) { echo "<tr>\n\t\t\t<td>{$no}</td><td><a href='http://localhost/google-gis-ri32/dashboard.php?page=peta26/" . getId_prov($dt3['id_prov']) . "'>" . getId_prov($dt3['id_prov']) . "</a></td><td>" . getId_bencana($dt3['id_bencana']) . "</td><td>" . getNama($dt3['id_info']) . "</td><td>" . getJenis($dt3['jenis']) . "</td>\n\t\t\t<td>" . round($dt3['id_bencana'] / $max['maxK1'] * $bobot[0] + $dt3['kerusakan'] / $max['maxK2'] * $bobot[1] + $dt3['id_bencana'] / $max['maxK3'] * $bobot[2] + $dt3['pengungsi'] / $max['maxK4'] * $bobot[3], 2) . "</td>\t\t\n\t\t</tr>"; $no++; } echo "</table>"; echo " pilih urutan 3 paling bawah atau 3 ranking paling tinggi"; ?> echo "<td><a href='http://localhost/contoh/".$row['nama']."'>".$row['nama']."</a></td>"; echo "<td><a href='alamat linknya'>".$row['nama']."</a></td>";
echo "</table>"; ?> <table class=table cellpadding=2 cellspacing=1 bordercolor=#111111 width=100%> <tr class=\"bodystyle\" bgcolor='#757575' align=center height="3"><td align="center" width="3"><b>No</b></td><td align="center" width="5"><b>Tanggal Peraturan</b></td><td align="center" width="10"><b>Jenis Peraturan</b></td><td align="center" width="10"><b>Nomor Peraturan</b></td><td align="center" width="53%"><b>Tentang</b></td><td align="center" width="3">-</td><td align="center" width="10%"><b>Action</b></td></tr> <?php $no = $row_perpage * ($page - 1) + 1; while ($row = mysql_fetch_array($rs)) { $tgl = date("d-M-Y", strtotime($row['tanggal'])); $tgl_terima = date("d-M-Y", strtotime($row['tanggal_diterima'])); $tgl_selesai = date("d-M-Y", strtotime($row['tanggal_distribusi'])); if ($no % 2 == 0) { $bg = "#C8C8C8"; } else { $bg = "#CCCCCC"; } echo "<tr bgcolor={$bg}><td align=\"center\">{$no}</td><td align=\"center\">{$tgl}</td><td >" . getJenis($row[2]) . "</td><td align=\"center\">{$row['3']}</td><td>{$row['4']}</td>"; ?> <td align="center"><a target='_blank' href="download.php?id=<?php echo getFileId($row[0]); ?> "><img border=0 src="images/doc.gif" </a></td> <td align="center"><a href="index.php?_mod=peraturan&task=edit_peraturan&id=<?php echo $row[0]; ?> ">Edit |</a><a href="index.php?_mod=peraturan&task=delete_peraturan&id=<?php echo $row[0]; ?> " onclick="return confirm('Are you sure you want to delete Peraturan No <?php echo $row['no_peraturan'];
//$header = array('No','Tanggal Peraturan','Jenis Peraturan','No. Peraturan','Tentang','Unit Pemroses','Tgl Diterima Untuk Digandakan','Tanggal Selesai Didistribusikan'); //table_header('#757575',$header,''); $go = $row_perpage * ($page - 1) + 1; while ($row = mysql_fetch_array($rs)) { $tgl = date("d-M-Y", strtotime($row['tanggal'])); $tgl_terima = date("d-M-Y", strtotime($row['tanggal_diterima'])); $tgl_selesai = date("d-M-Y", strtotime($row['tanggal_distribusi'])); if ($go % 2 == 0) { $bg = "#C8C8C8"; } else { $bg = "#ffffff"; } echo "<tr bgcolor={$bg}>"; echo "<td>" . $go . "</td>"; echo "<td>" . $tgl . "</td>"; echo "<td>" . getJenis($row[2]) . "</td>"; echo "<td>" . $row[3] . "</td>"; echo "<td>" . $row[4] . "</td>"; echo "<td>" . $row[5] . "</td>"; echo "<td>" . $tgl_terima . "</td>"; echo "<td>" . $tgl_selesai . "</td>"; echo "</tr>"; $go++; } table_close(); echo "</td></tr>"; echo "<tr>"; echo "<td colspan=4 align=right>"; echo "<table border=0 width=100%>"; echo "<tr>"; echo "<td align=right>";