Proses Clustering Data

result() as $tes_n) { ?> result_array() as $mx) { ?> if ($y1 == '') { $c1b = 0.42; } else { $c1b = $y1; } // if ($z1 == '') { $c1c = 0.64; } else { $c1c = $z1; } // if ($x2 == '') { $c2a = 0.11; } else { $c2a = $x2; } // if ($y2 == '') { $c2b = 0.14; } else { $c2b = $y2; } // if ($z2 == '') { $c2c = 0.26; } else { $c2c = $z2; } // if ($x3 == '') { $c3a = $mx['MIN(c1c)']; } else { $c3a = $x3; } // if ($y3 == '') { $c3b = 0; } else { $c3b = $y3; } // if ($z3 == '') { $c3c = 0.1; } else { $c3c = $z3; } $InsertCentroid = "insert into centroid_data(tahun,x1,x2,x3,y1,y2,y3,z1,z2,z3) values('" . $tahun . "','" . $x1 . "','" . $x2 . "','" . $x3 . "','" . $y1 . "','" . $y2 . "','" . $y3 . "','" . $z1 . "','" . $z2 . "','" . $z3 . "')"; $this->db->query($InsertCentroid); $c1a_b = ""; $c1b_b = ""; $c1c_b = ""; $c2a_b = ""; $c2b_b = ""; $c2c_b = ""; $c3a_b = ""; $c3b_b = ""; $c3c_b = ""; $hc1 = 0; $hc2 = 0; $hc3 = 0; $no = 0; $arr_c1 = array(); $arr_c2 = array(); $arr_c3 = array(); $arr_c1_temp = array(); $arr_c2_temp = array(); $arr_c3_temp = array(); $this->db->query('truncate table centroid_temp'); $this->db->query('truncate table hasil_centroid'); $deletee = "delete from centroid where tahun='$tahun'"; $this->db->query($deletee); //proses perhitungan Kmeans awal foreach ($kriteria->result_array() as $s) { ?> db->query($q); $no++; } //centroid baru 1.a $jum = 0; $arr = array(); for ($i = 0; $i < count($arr_c1); $i++) { $arr[$i] = $arr_c1_temp[$i] * $arr_c1[$i]; if ($arr_c1[$i] == 1) { $jum++; } } if ($arr > 0 && $jum > 0) { $c1a_b = round(array_sum($arr) / $jum, 2); } $contoh1 = $arr; $jumlah1 = $jum; $printed1 = false; //centroid baru 1.b $jum = 0; $arr = array(); for ($i = 0; $i < count($arr_c2); $i++) { $arr[$i] = $arr_c2_temp[$i] * $arr_c1[$i]; if ($arr_c1[$i] == 1) { $jum++; } } if ($arr > 0 && $jum > 0) { $c1b_b = round(array_sum($arr) / $jum, 2); } $contoh2 = $arr; $jumlah2 = $jum; $printed2 = false; //centroid baru 1.c $jum = 0; $arr = array(); for ($i = 0; $i < count($arr_c3); $i++) { $arr[$i] = $arr_c3_temp[$i] * $arr_c1[$i]; if ($arr_c1[$i] == 1) { $jum++; } } if ($arr > 0 && $jum > 0) { $c1c_b = round(array_sum($arr) / $jum, 2); } $contoh3 = $arr; $jumlah3 = $jum; $printed3 = false; //centroid baru 2.a $jum = 0; $arr = array(); for ($i = 0; $i < count($arr_c1); $i++) { $arr[$i] = $arr_c1_temp[$i] * $arr_c2[$i]; if ($arr_c2[$i] == 1) { $jum++; } } if ($arr > 0 && $jum > 0) { $c2a_b = round(array_sum($arr) / $jum, 2); } $contoh4 = $arr; $jumlah4 = $jum; $printed4 = false; //centroid baru 2.b $jum = 0; $arr = array(); for ($i = 0; $i < count($arr_c2); $i++) { $arr[$i] = $arr_c2_temp[$i] * $arr_c2[$i]; if ($arr_c2[$i] == 1) { $jum++; } } if ($arr > 0 && $jum > 0) { $c2b_b = round(array_sum($arr) / $jum, 2); } $contoh5 = $arr; $jumlah5 = $jum; $printed5 = false; //centroid baru 2.c $jum = 0; $arr = array(); for ($i = 0; $i < count($arr_c3); $i++) { $arr[$i] = $arr_c3_temp[$i] * $arr_c2[$i]; if ($arr_c2[$i] == 1) { $jum++; } } if ($arr > 0 && $jum > 0) { $c2c_b = round(array_sum($arr) / $jum, 2); } $contoh6 = $arr; $jumlah6 = $jum; $printed6 = false; //centroid baru 3.a $jum = 0; $arr = array(); $arb = array(); for ($i = 0; $i < count($arr_c1); $i++) { $arr[$i] = $arr_c1_temp[$i] * $arr_c3[$i]; if ($arr_c3[$i] == 1) { $jum++; } if ($arr_c1_temp[$i] == 0) { $arr_c1_temp[$i] = 1; } $arb[$i] = $arr_c1_temp[$i] * $arr_c3[$i]; } if ($arr > 0 && $jum > 0) { $c3a_b = round(array_sum($arr) / $jum, 2); } $contoh7 = $arb; $jumlah7 = $jum; $printed7 = false; //centroid baru 3.b $jum = 0; $arr = array(); $arb = array(); for ($i = 0; $i < count($arr_c2); $i++) { $arr[$i] = $arr_c2_temp[$i] * $arr_c3[$i]; if ($arr_c3[$i] == 1) { $jum++; } if ($arr_c2_temp[$i] == 0) { $arr_c2_temp[$i] = 1; } $arb[$i] = $arr_c2_temp[$i] * $arr_c3[$i]; } if ($arr > 0 && $jum > 0) { $c3b_b = round(array_sum($arr) / $jum, 2); } $contoh8 = $arb; $jumlah8 = $jum; $printed8 = false; //centroid baru 3.c $jum = 0; $arr = array(); $arb = array(); for ($i = 0; $i < count($arr_c3); $i++) { $arr[$i] = $arr_c3_temp[$i] * $arr_c3[$i]; if ($arr_c3[$i] == 1) { $jum++; } if ($arr_c3_temp[$i] == 0) { $arr_c3_temp[$i] = 1; } $arb[$i] = $arr_c3_temp[$i] * $arr_c3[$i]; } if ($arr > 0 && $jum > 0) { $c3c_b = round(array_sum($arr) / $jum, 2); } $contoh9 = $arb; $jumlah9 = $jum; $printed9 = false; $delete = "delete from predikat where tahun='$tahun'"; $this->db->query($delete); $q = "insert into hasil_centroid(c1a,c1b,c1c,c2a,c2b,c2c,c3a,c3b,c3c) values('" . $c1a_b . "','" . $c1b_b . "','" . $c1c_b . "','" . $c2a_b . "','" . $c2b_b . "','" . $c2c_b . "','" . $c3a_b . "','" . $c3b_b . "','" . $c3c_b . "')"; $this->db->query($q); $qw = "insert into centroid(tahun,x1,x2,x3,y1,y2,y3,z1,z2,z3) values('" . "$tahun" . "','" . $c1a_b . "','" . $c1b_b . "','" . $c1c_b . "','" . $c2a_b . "','" . $c2b_b . "','" . $c2c_b . "','" . $c3a_b . "','" . $c3b_b . "','" . $c3c_b . "')"; $this->db->query($qw); ?>

Kode kecamatan

Nama Kecamatan

nama; ?>

Centroid 1

Centroid 2

Centroid 3

C1

C2

C3

Hasil

Detail

Detail

Centroid 1
C1x
C1y
C1z

Centroid 2
C2x
C2y
C2z

Centroid 3
C3x
C3y
C3z