<?php
/**
    Matrix Core for AHP Calculation
    greetz to #1stlink #antihackerlink
*/
include "config.php";
include "fget_data.php";

$i=0;
$matrix_suku_bunga = array();
$matrix_limit_kredit = array();
$matrix_biaya_administrasi = array();
$matrix_uang_muka = array();
$matrix_jangka_waktu = array();


// Fetch Suku Bunga
$result = mysql_query("SELECT * FROM eigenvektor WHERE nama_matrix = 'suku_bunga' ORDER BY id_bank") or die("Data salah");
while ($record1 = mysql_fetch_row($result)){
  $suku_bunga[] = $record1[2];
}
// Fetch Limit Kredit
$result = mysql_query("SELECT * FROM eigenvektor WHERE nama_matrix = 'limit_kredit' ORDER BY id_bank") or die("Data salah");
while ($record1 = mysql_fetch_row($result)){
  $limit_kredit[] = $record1[2];
}

// Fetch jangka Waktu
$result = mysql_query("SELECT * FROM eigenvektor WHERE nama_matrix = 'jangka_waktu' ORDER BY id_bank") or die("Data salah");
while ($record1 = mysql_fetch_row($result)){
  $jangka_waktu[] = $record1[2];
}

// Fetch Uang Muka
$result = mysql_query("SELECT * FROM eigenvektor WHERE nama_matrix = 'uang_muka' ORDER BY id_bank") or die("Data salah");
while ($record1 = mysql_fetch_row($result)){
  $uang_muka[] = $record1[2];
}

// Fetch Biaya administrasi
$result = mysql_query("SELECT * FROM eigenvektor WHERE nama_matrix = 'biaya_administrasi' ORDER BY id_bank") or die("Data salah");
while ($record1 = mysql_fetch_row($result)){
  $biaya_administrasi[] = $record1[2];
}

// Fetch Kriteria
$result = mysql_query("SELECT * FROM eigenvektor WHERE nama_matrix = 'kriteria' ORDER BY id_bank") or die("Data salah");
while ($record1 = mysql_fetch_row($result)){
  $kriteria[] = $record1[2];
}

// Fetch dari tabel Alternatif
$result = mysql_query("SELECT * FROM calculator") or die("Data salah");
while ($record1 = mysql_fetch_row($result)){
  $suku_bunga[] = $record1[2];
  $limit_kredit[] = $record1[3];
  $biaya_administrasi[] = $record1[5];
  $uang_muka[] = $record1[4];
  $jangka_waktu[] = $record1[6];
}

// Fetch dari tabel Kriteria
$result2 = mysql_query("SELECT * FROM kriteria") or die("Data salah");
while ($record2 = mysql_fetch_row($result2)){
  $value_kriteria[] = $record2[2];
}


function fmatrix_suku_bunga($suku_bunga){

    // Rumus perkalian matrix
    $m1 = get_data_suku_bunga();
    $m2 = get_data_suku_bunga();
    $r = 0;

    for ($row=0; $row<5; $row++) {
           $kriteria = 0;
           for ($col=0; $col<5; $col++) {
                $x =0;
                for ($k=$col; $k<5; $k++) { // kolom
                    $x += number_format(($m1[$row][$k] * $m2[$k][$col]),2);
                }
                $m3[$row][$col] = $x;
                $kriteria += $x;
            }
        $h_kriteria[] = $kriteria;
        $jumlah +=  $kriteria;
    }
    for ($i=0;$i<sizeof($h_kriteria);$i++){
        $eigen[] = number_format(($h_kriteria[$i]/$jumlah),2);
    }

    // Untuk mencari eigen vektor
    mysql_query("DELETE FROM `ahp`.`eigenvektor`");
    for ($tabel=0;$tabel<5;$tabel++) {
        for ($tabel1=0; $tabel1<5; $tabel1++) {
        }
    mysql_query("INSERT INTO `ahp`.`eigenvektor` ( id_bank, nama_matrix, eigenvektor) VALUES ('" . ($tabel+1) . "', 'suku_bunga', " .$eigen[$tabel]. ");");
    }
}

function fmatrix_limit_kredit($limit_kredit){

    // Rumus perkalian matrix
    $m1 = get_data_limit_kredit();
    $m2 = get_data_limit_kredit();
    $r = 0;

    for ($row=0; $row<5; $row++) {
           $kriteria = 0;
           for ($col=0; $col<5; $col++) {
                $x =0;
                for ($k=$col; $k<5; $k++) { // kolom
                    $x += number_format(($m1[$row][$k] * $m2[$k][$col]),2);
                }
                $m3[$row][$col] = $x;
                $kriteria += $x;
            }
        $h_kriteria[] = $kriteria;
        $jumlah +=  $kriteria;
    }
    for ($i=0;$i<sizeof($h_kriteria);$i++){
        $eigen[] = number_format(($h_kriteria[$i]/$jumlah),2);
    }

    // Untuk mencari eigen vektor
    for ($tabel=0;$tabel<5;$tabel++) {
        for ($tabel1=0; $tabel1<5; $tabel1++) {
        }
    mysql_query("INSERT INTO `ahp`.`eigenvektor` ( id_bank, nama_matrix, eigenvektor) VALUES ('" . ($tabel+1) . "', 'limit_kredit', " .$eigen[$tabel]. ");");
    }
}

function fmatrix_biaya_administrasi($biaya_administrasi){

    // Rumus perkalian matrix
    $m1 = get_data_administrasi();
    $m2 = get_data_administrasi();
    $r = 0;

    for ($row=0; $row<5; $row++) {
           $kriteria = 0;
           for ($col=0; $col<5; $col++) {
                $x =0;
                for ($k=$col; $k<5; $k++) { // kolom
                    $x += number_format(($m1[$row][$k] * $m2[$k][$col]),2);
                }
                $m3[$row][$col] = $x;
                $kriteria += $x;
            }
        $h_kriteria[] = $kriteria;
        $jumlah +=  $kriteria;
    }
    for ($i=0;$i<sizeof($h_kriteria);$i++){
        $eigen[] = number_format(($h_kriteria[$i]/$jumlah),2);
    }

    // Untuk mencari eigen vektor
    for ($tabel=0;$tabel<5;$tabel++) {
        for ($tabel1=0; $tabel1<5; $tabel1++) {
        }
    mysql_query("INSERT INTO `ahp`.`eigenvektor` ( id_bank, nama_matrix, eigenvektor) VALUES ('" . ($tabel+1) . "', 'biaya_administrasi', " .$eigen[$tabel]. ");");
    }
}

function fmatrix_uang_muka($uang_muka){

    // Rumus perkalian matrix
    $m1 = get_data_uang_muka();
    $m2 = get_data_uang_muka();
    $r = 0;

    for ($row=0; $row<5; $row++) {
           $kriteria = 0;
           for ($col=0; $col<5; $col++) {
                $x =0;
                for ($k=$col; $k<5; $k++) { // kolom
                    $x += number_format(($m1[$row][$k] * $m2[$k][$col]),2);
                }
                $m3[$row][$col] = $x;
                $kriteria += $x;
            }
        $h_kriteria[] = $kriteria;
        $jumlah +=  $kriteria;
    }
    for ($i=0;$i<sizeof($h_kriteria);$i++){
        $eigen[] = number_format(($h_kriteria[$i]/$jumlah),2);
    }

    // Untuk mencari eigen vektor
    for ($tabel=0;$tabel<5;$tabel++) {
        for ($tabel1=0; $tabel1<5; $tabel1++) {
        }
    mysql_query("INSERT INTO `ahp`.`eigenvektor` ( id_bank, nama_matrix, eigenvektor) VALUES ('" . ($tabel+1) . "', 'uang_muka', " .$eigen[$tabel]. ");");
    }
}

function fmatrix_jangka_waktu($jangka_waktu){

// Rumus perkalian matrix
    $m1 = get_data_jangkaw();
    $m2 = get_data_jangkaw();
    $r = 0;

    for ($row=0; $row<5; $row++) {
           $kriteria = 0;
           for ($col=0; $col<5; $col++) {
                $x =0;
                for ($k=$col; $k<5; $k++) { // kolom
                    $x += number_format(($m1[$row][$k] * $m2[$k][$col]),2);
                }
                $m3[$row][$col] = $x;
                $kriteria += $x;
            }
        $h_kriteria[] = $kriteria;
        $jumlah +=  $kriteria;
    }
    for ($i=0;$i<sizeof($h_kriteria);$i++){
        $eigen[] = number_format(($h_kriteria[$i]/$jumlah),2);
    }

    // Untuk mencari eigen vektor
    for ($tabel=0;$tabel<5;$tabel++) {
        for ($tabel1=0; $tabel1<5; $tabel1++) {
        }
    mysql_query("INSERT INTO `ahp`.`eigenvektor` ( id_bank, nama_matrix, eigenvektor) VALUES ('" . ($tabel+1) . "', 'jangka_waktu', " .$eigen[$tabel]. ");");
    }
}

function fmatrix_kriteria($value_kriteria){

    // Rumus perkalian matrix
    $m1 = get_data_kriteria();
    $m2 = get_data_kriteria();
    $r = 0;

    for ($row=0; $row<5; $row++) {
           $kriteria = 0;
           for ($col=0; $col<5; $col++) {
                $x =0;
                for ($k=$col; $k<5; $k++) { // kolom
                    $x += number_format(($m1[$row][$k] * $m2[$k][$col]),2);
                }
                $m3[$row][$col] = $x;
                $kriteria += $x;
            }
        $h_kriteria[] = $kriteria;
        $jumlah +=  $kriteria;
    }
    for ($i=0;$i<sizeof($h_kriteria);$i++){
        $eigen[] = number_format(($h_kriteria[$i]/$jumlah),2);
    }

    // Untuk mencari eigen vektor
    for ($tabel=0;$tabel<5;$tabel++) {
        for ($tabel1=0; $tabel1<5; $tabel1++) {
        }
    mysql_query("INSERT INTO `ahp`.`eigenvektor` ( id_bank, nama_matrix, eigenvektor) VALUES ('" . ($tabel+1) . "', 'kriteria', " .$eigen[$tabel]. ");");
    }
}
?>
<table border="1" cellpadding="0" cellspacing="0" align="center">
<?php fmatrix_suku_bunga($suku_bunga); ?>
<?php fmatrix_limit_kredit($limit_kredit); ?>
<?php fmatrix_biaya_administrasi($biaya_administrasi); ?>
<?php fmatrix_uang_muka($uang_muka); ?>
<?php fmatrix_jangka_waktu($jangka_waktu); ?>
<?php fmatrix_kriteria($value_kriteria);

for ($tabel=0;$tabel<5;$tabel++) {
        $nomer_urut[$tabel] = $tabel;
        $hasil[$tabel][0]  = ($suku_bunga[$tabel]*$kriteria[$tabel])+
                ($limit_kredit[$tabel]*$kriteria[$tabel])+
                ($jangka_waktu[$tabel] *$kriteria[$tabel])+
                ($uang_muka[$tabel] *$kriteria[$tabel])+
                ($biaya_administrasi[$tabel] *$kriteria[$tabel]);
        $hasil[$tabel][1] = $tabel;
    }sort($hasil);

for ($tabel=0;$tabel<5;$tabel++) {
        $id_bank[$tabel] = $hasil[$tabel][1];
    }


?>
<tr>
  <td align="center">ID</td>
  <td align="center">Nama Bank</td>
  <td align="center">Kode Bank</td>
  <td align="center">Nilai Eigene</td>
</tr>
<?php
    for ($n=0;$n<5;$n++){
    $query = "SELECT * FROM calculator where id='".($id_bank[$n]+1)."'";
    $result =  mysql_query($query);
    $row = mysql_fetch_array($result);
?>
<tr>
<input type="hidden" name="id" value"<?php echo $row['id'];?>">
    <td align="center" width="5%"><?php echo $row['id'] ?></td>
    <td align="center" width="23%"><?php echo $row['nama_bank']?></td>
    <td align="center" width="21%"><?php echo $row['id_bank']?></td>
    <td align="center" width="21%"><?php echo $hasil[$n][0];?></td>
</tr>
<?php
    }
?>
</table>

<?php
$array_faktor = array();

for($index = 0; $index<5;$index++){

    $array_faktor_baris = array();
    $array_faktor_baris[] = $eigen_biaya_admin[$index];

    $array_faktor = $array_faktor_baris;
    $array_faktor_baris = array();
}
$hasil =array();
for($row = 0; $row<5;$row++){
    for($col =0;$col<5;$col++){
        $h = $array_faktor[$row][$col] * $eigen_kriteria[$col];
        $hasil[] = $h;
    }
}
for($row = 0; $row<5;$row++){
}
?>