Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Kenapa saya mendapatkan eror "the query you submitted is not valid"?
Function SAW
function saw(){
// collect skill
$skill = array();
$sk = $_POST["skill"];
foreach ($sk as $sek) {
array_push($skill, "'".$sek."'");
}
$skills = implode(",",$skill);
// collect nilai
$nilai = $this->input->post("nilai");
//collect gaji
$gaji = $this->input->post("gaji");
// collect Lokasi
$lokasi = ($this->input->post("lokasi") == "0" ? false : true);
// collect jurusan
$jurusan = $this->input->post("jurusan");
$sql = $this->model_data->getRating($skills, $nilai, $gaji, $lokasi, $jurusan);
$result = $this->db->query("$sql")->result();
$saw = new Algoritma();
// menambahkan Kriteria
$saw->addCriteria("skill",$this->input->post("bobot_skill")/100,"1");
$saw->addCriteria("nilai",$this->input->post("bobot_nilai")/100,"0");
$saw->addCriteria("gaji",$this->input->post("bobot_gaji")/100,"0");
$saw->addCriteria("lokasi",$this->input->post("bobot_lokasi")/100,"1");
$saw->addCriteria("jurusan",$this->input->post("bobot_jurusan")/100,"1");
foreach ($result as $hasil) {
$alt = new Alternative("$hasil->kode_lowongan","$hasil->nama_perusahaan");
$alt->addCriteria("skill",$hasil->skill);
$alt->addCriteria("nilai",$hasil->nilai);
$alt->addCriteria("gaji",$hasil->gaji);
$alt->addCriteria("lokasi",$hasil->lokasi);
$alt->addCriteria("jurusan",$hasil->jurusan);
$saw->addAlternative($alt);
}
$saw->generate();
$rekomendasi = $saw->data;
for ($i=0; $i < count($rekomendasi); $i++) {
for ($j=($i+1); $j < count($rekomendasi); $j++) {
if($rekomendasi[$i]->preferensi < $rekomendasi[$j]->preferensi){
$temp = $rekomendasi[$i];
$rekomendasi[$i] = $rekomendasi[$j];
$rekomendasi[$j] = $temp;
}
}
}
$data["hasil"] = $rekomendasi;
$this->load->view("home/sawhasil",$data);
}
Query di Model data
function getRating($skill, $nilai, $gaji, $lokasi, $jurusan ){
$parameter = array(
"skills" => $skill,
"nilai" => $nilai,
"gaji" => $gaji,
"lokasi" => $lokasi,
"jurusan" => $jurusan,
);
$p='';
for($i=0;$i<count($parameter);$i++){
if($p=='') $p='?';
else $p.=',?';
}
$proc="call rating($p)";
$query=$this->db->query($proc,$parameter);
$sqltext = $query->row()->sqltext;
// $query->free_result();
mysqli_next_result( $this->db->conn_id );
return $sqltext;
}
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban