Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1.  
  2. //Buat array bobot { C1 = 40%; C2 = 25%; C3 = 30%;}
  3. $ak=mysql_fetch_array(mysql_query("select * from kriteria order by idkriteria asc"));
  4. //$bobot= array($ak[kriteria]);
  5.  
  6. //$bobot = array(0.5, 0.3, 0.2);
  7.  
  8.  
  9. //Lakukan Normalisasi dengan rumus pada langkah 2
  10. //Cari Max atau min dari tiap kolom Matrik
  11. $crMax = mysql_query("SELECT min(kriteria1_pekerjaan) as maxK1,
  12. max(kriteria2_penghasilan) as maxK2,
  13. max(kriteria3_jenis_rumah) as maxK3
  14. FROM tbl_matrik");
  15. $max = mysql_fetch_array($crMax);
  16. //Buat fungsi tampilkan nama
  17. function getNama($id){
  18. $q =mysql_query("SELECT * FROm tbl_warga where nik = '$id'");
  19. $d = mysql_fetch_array($q);
  20. return $d['nama'];
  21. }
  22.  
  23.  
  24. //Proses perangkingan dengan rumus langkah 3
  25. $sql3 = mysql_query("SELECT * FROM tbl_matrik");
  26. //Buat tabel untuk menampilkan hasil
  27. echo "
  28. <table id='example' class='display' cellspacing='0' width='100%'>
  29. <thead>
  30. <tr align='center'>
  31. <td>No</td>
  32. <td>Nama</td>
  33. <td>Rangking</td>
  34. <td>Status</td>
  35. </tr>
  36. </thead>
  37. ";
  38. $no = 1;
  39. //Kita gunakan rumus (Normalisasi x bobot)
  40. while ($dt3 = mysql_fetch_array($sql3)) {
  41. $rangking = round((($max['maxK1']/$dt3['kriteria1_pekerjaan'])*$bobot[0])+
  42. (($dt3['kriteria2_penghasilan']/$max['maxK2'])*$bobot[1])+
  43. (($dt3['kriteria3_jenis_rumah']/$max['maxK3'])*$bobot[2]),3);
  44. $status = $rangking;
  45. if ($status < 0.500){
  46. $status = 'Tidak Menerima';
  47. } else {
  48. $status = 'Menerima';
  49. }
  50.  
  51. echo "<tr>
  52. <td align='center'>$no</td>
  53. <td>".getNama($dt3['nik'])."</td>
  54. <td align='center'>$rangking</td>
  55. <td align='center'>$status</td>
  56. </tr>";
  57. $no++;
  58. }
  59.  
  60. echo "</table>";
  61.  
  62. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement