function data_asisten($kd_asisten)
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
$sql = "\r\n\t\t\tSelect\r\n\t\t\tkd_asisten,\r\n\t\t\tnm_asisten,\r\n\t\t\thapeasisten,\r\n\t\t\talamat_asisten,\t\r\n\t\t\tkota_asisten,\t\t\r\n\t\t\ttmpt_lahirasisten,\r\n\t\t\ttgl_lahirasisten,\r\n\t\t\tno_idasisten,\r\n\t\t\tcopy_asisten\r\n\t\t\tFrom\r\n\t\t\tasisten\r\n\t\t\tWhere\r\n\t\t\tkd_asisten = '" . $kd_asisten . "'\r\n\t\t\t";
$list_cari = false;
$res = mysql_query($sql);
if ($res) {
while ($row = mysql_fetch_assoc($res)) {
$cari = new birojasa();
$cari->kd_asisten = $row['kd_asisten'];
$cari->nm_asisten = $row['nm_asisten'];
$cari->hapeasisten = $row['hapeasisten'];
$cari->alamat_asisten = $row['alamat_asisten'];
$cari->kota_asisten = $row['kota_asisten'];
$cari->tmpt_lahirasisten = $row['tmpt_lahirasisten'];
$cari->tgl_lahirasisten = $row['tgl_lahirasisten'];
$cari->no_idasisten = $row['no_idasisten'];
$cari->copy_asisten = $row['copy_asisten'];
$list_cari[] = $cari;
}
}
$koneksi->tutupdb();
return $list_cari;
}
function hitungTestimoni()
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
$sql = "\r\n\t\t\tSELECT \r\n\t\t\tcount(*) as total \r\n\t\t\tFROM \r\n\t\t\ttestimoni\r\n\t\t";
$itung = mysql_query($sql);
$jumlah = mysql_fetch_array($itung);
return $jumlah['total'];
}
function gantiPassword($id_users, $password, $password1, $password2)
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
$sql = "\r\n\t\t\tselect\r\n\t\t\tpassword\r\n\t\t\tfrom \r\n\t\t\tusers\r\n\t\t\twhere\r\n\t\t\tkd_users='" . $id_user . "';\r\n\t\t";
$hasil = mysql_query($sql);
if ($password != $hasil) {
echo "Password lama salah";
}
if ($password1 != $password2) {
echo "Password baru tidak cocok";
}
if ($hasil == $password and $password1 == $password2) {
$sql = "\r\n\t\t\tupdate\r\n\t\t\tusers\r\n\t\t\tset\r\n\t\t\tpassword='******'\r\n\t\t\twhere\r\n\t\t\tkd_users='" . $id_users . "' \r\n\t\t\t";
mysql_query($sql);
}
$koneksi->tutupdb();
}
function lamar($kd_lowongan, $kd_asisten)
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
echo $kd_asisten;
echo $kd_lowongan;
$sql = "\r\n\t\tINSERT INTO \r\n\t\t`detail_lowongan`\r\n\t\t(`KD_LOWONGAN`, `KD_MEMBER`, `KD_ASISTEN`) \r\n\t\tSELECT \r\n\t\tb.kd_lowongan, a.kd_member, a.kd_asisten \r\n\t\tFROM asisten a \r\n\t\tJOIN lowongan b \r\n\t\tWHERE b.kd_lowongan = '" . $kd_lowongan . "'\r\n\t\tAND\r\n\t\ta.kd_asisten = '" . $kd_asisten . "'\r\n\t\t";
$berhasil = mysql_query($sql) or die(mysql_error());
if ($berhasil) {
echo "berhasil";
} else {
echo "ngga berhasil :(";
}
$koneksi->tutupdb();
}
function tentukanPembantu($kd_lowongan, $kd_asisten, $status)
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
$sql1 = "\r\n\t\t\tUPDATE\r\n\t\t\tlowongan\r\n\t\t\tSET\r\n\t\t\tkd_asisten={$kd_asisten},kd_status=2\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t";
$hasil1 = mysql_query($sql1);
$sql2 = "\r\n\t\t\tUPDATE\r\n\t\t\tdetail_lowongan\r\n\t\t\tSET\r\n\t\t\tkd_status={$status}\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t\tAND\r\n\t\t\tkd_asisten={$kd_asisten}\r\n\t\t";
print_r($sql2);
$hasil2 = mysql_query($sql2);
$sql3 = "\r\n\t\t\tUPDATE\r\n\t\t\tdetail_lowongan\r\n\t\t\tSET\r\n\t\t\tkd_status=3\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t\tAND\r\n\t\t\tkd_asisten!={$kd_asisten}\r\n\t\t";
//print_r($sql3);
$hasil3 = mysql_query($sql3);
$koneksi->tutupdb();
return true;
}
