$postdata = json_decode(file_get_contents("php://input"), TRUE); $data = new koneksi(); $text = ""; $arr = array(); if ($cek_token = $data->runQuery("SELECT `karyawan`.`id`,`karyawan`.`nama` FROM `karyawan` INNER JOIN `pin` ON `pin`.`id_karyawan`=`karyawan`.`id` WHERE `pin`.`id_karyawan`='" . $postdata['token'] . "' ")) { if ($cek_token->num_rows > 0) { $rs_spv = $cek_token->fetch_assoc(); $text .= "Spv: " . $rs_spv['nama']; $arr['id_karyawan'] = $rs_spv['id']; if ($cek_barcode = $data->runQuery("SELECT `id`,`nama` FROM `pelanggan` WHERE `barcode`='" . $postdata['barcode'] . "' ")) { $rs_pelanggan = $cek_barcode->fetch_assoc(); $text .= " | Pelanggan : " . $rs_pelanggan['nama']; $arr['id_pelanggan'] = $rs_pelanggan['id']; if ($rec = $data->runQuery("INSERT INTO `visit` (`barcode`,`latitude`,`longitude`,`id_pelanggan`,`id_karyawan`) \n\t\t\t\tVALUES ('" . $postdata['barcode'] . "', '" . $postdata['latitude'] . "', '" . $postdata['longitude'] . "', '" . $arr['id_pelanggan'] . "', '" . $arr['id_karyawan'] . "') ")) { //$text .=" [ "; $id_visit = $data->lastInsertID(); $qry = "INSERT INTO `visit_detail`(`id_visit`,`id_jenis_pekerjaan`) VALUES "; if ($postdata['tagih']) { $qry .= " ('{$id_visit}','1') ,"; //$text.=" Tagih ,"; } if ($postdata['kirim']) { $qry .= " ('{$id_visit}','2') ,"; //$text.=" Kirim Barang ,"; } if ($postdata['kunjungan']) { $qry .= " ('{$id_visit}','3') ,"; //$text.=" Kunjungan ,"; } if ($postdata['konfirmasi']) { $qry .= " ('{$id_visit}','4') ,";