\"mnutopshadow\"
home about us auction terms online catalog"; if (file_exists("additional.php")) { echo " additional lots"; } echo " contact details
\"mnubotshadow\"
"; } function form_login_member(){ echo "
BidName
BidPass
Sign Up
Forget Bidder Pass
"; } function form_logout_member() { if(!isset($_SESSION['visitor_number'])) { $vis_nom=1; } else { $vis_nom=$_SESSION['visitor_number']; } $resbid=mysql_query("SELECT * FROM stay_sheet WHERE stay_nom=$vis_nom ORDER BY stay_lot ASC"); echo " "; if(mysql_num_rows($resbid)){ echo " "; } else { echo " "; echo " "; } echo "
PREVIOUS BID
PROFILE
\"logout\"
"; while($row = mysql_fetch_array($resbid)) { echo " "; echo " "; echo " "; } echo " "; echo " "; echo " "; echo "
".$row[3]."Rp. ".number_format($row[5])."
CHECKOUT BIDDING
"; echo "
"; } function coba_bidding() { echo "
Bid : Rp.
"; } function venue_get() { echo "
How to get
RedTop Hotel Jakarta?
click here
"; } function auction_upcoming1() { echo "
\"Upcoming
Java Auction 5
A Public Auction
RedTop Hotel JAKARTA
Consignment Closing Date
Saturday, May 9th, 2009
Public Auction
Saturday, August 8th, 2009
9 AM - 6 PM
"; } function auction_upcoming2() { echo "
\"Upcoming

Java Auction # 5

A Public Auction
RedTop Hotel JAKARTA
MailBid Closing
Thursday, August 6th, 2009
10 AM GMT
Public Viewing
Friday, August 7th, 2009
10 AM - 5 PM
Public Auction
Saturday, August 8th, 2009
9 AM - 6 PM
"; } function auction_latest() { echo "
\"Latest
Java Auction 888
Result
Total 1,286 lots
Sold 1,026 lots
Percentage 79.78 %
Realized Price
download here (pdf format)
"; } function auction_previous() { $res=mysql_query("select * from previous order by idx"); echo ""; echo " "; while($lam = mysql_fetch_array($res)) { echo ""; echo " "; } echo ""; echo " "; echo "
\"Upcoming
"; echo " ".$lam[2].""; echo "
"; } function printed_catalog() { echo "
\"Upcoming

Please contact us
for order and
detail informations.
"; } function tell_friends() { echo "
\"Tell



"; } function format_timestamp($timestamp){ $hour = substr($timestamp,8,2); $minute = substr($timestamp,10,2); $second = substr($timestamp,12,2); $month = substr($timestamp,4,2); $day = substr($timestamp,6,2); $year = substr($timestamp,0,4); return $tanggal=array ($year,$month,$day,$hour,$minute,$second); } function format_tanggal($timestamp) { $bulan_arr=array("January","February","March","April","May","June","July","August","September","October","November","December"); $data=format_timestamp($timestamp); $bul=(int)($data[1]); return $bulan_arr[$bul]." ".$data[2].", ".$data[0]." - ".$data[3].":".$data[4].":".$data[5]; } function format_tanggal2($timestamp) { $data=format_timestamp($timestamp); return $data[2]."/".$data[1]."/".$data[0]; } function login_admin() { $username=$_POST['username']; $passwd=$_POST['passwd']; $qry="select * from admin where username='$username' and passwd='$passwd'"; $qryres=mysql_query($qry); if(mysql_num_rows($qrys)) { session_register('username'); session_register('passwd'); }else header("Location:index.php"); } function select_tanggal($tanggal,$bulan,$tahun) { $bulan_arr=array("Jan","Feb","Mar","Apr","Mei","Jun","Jul","Ags","Sep","Okt","Nov","Des"); echo " "; } function select_tanggal_update($tanggal_update,$bulan_update,$tahun_update) { $bulan_arr=array("","Jan","Feb","Mar","Apr","Mei","Jun","Jul","Ags","Sep","Okt","Nov","Des"); echo " "; } function select_tanggal_tutup($tanggal_tutup,$bulan_tutup,$tahun_tutup) { $bulan_arr=array("","Jan","Feb","Mar","Apr","Mei","Jun","Jul","Ags","Sep","Okt","Nov","Des"); echo " "; } function select_tanggal_lahir($tanggal_lahir,$bulan_lahir,$tahun_lahir) { $bulan_arr=array("","Jan","Feb","Mar","Apr","Mei","Jun","Jul","Ags","Sep","Okt","Nov","Des"); echo " "; } function select_tanggal_lowongan($prefix,$tanggal,$bulan,$tahun) { $bulan_arr=array("Jan","Feb","Mar","Apr","Mei","Jun","Jul","Ags","Sep","Okt","Nov","Des"); $bulan=(int)($bulan); //echo $bulan; $n=1; echo " "; } function select_lokasi($lokasi_perusahaan) { $qry="select * from kota order by nama_kota asc"; $qryres=mysql_query($qry); echo " "; } function select_bidang_kerja($bidang_kerja) { $qry="select * from bidang_kerja order by kat_low asc"; $qryres=mysql_query($qry); echo " "; } function select_industri($industri) { $qry="select * from industri order by nama_industri asc"; $qryres=mysql_query($qry); echo " "; } function select_perusahaan($perusahaan) { $qry="select * from perusahaan order by nama_perusahaan asc"; $qryres=mysql_query($qry); echo " "; } function select_jabatan($jabatan) { $qry="select * from jabatan order by jabatan asc"; $qryres=mysql_query($qry); echo " "; } function select_kategori_pendidikan($kategori_pendidikan) { $qry="select * from pendidikan order by tk_pend asc"; $qryres=mysql_query($qry); echo " "; } function select_jurusan($jurusan) { $qry="select * from jurusan order by id_bid_ilmu asc"; $qryres=mysql_query($qry); echo " "; } function select_pengalaman_kerja($pengalaman_kerja) { $qry="select * from pengalaman_kerja order by id_pengalaman_kerja asc"; $qryres=mysql_query($qry); echo " "; } function select_jenis_kelamin($jenis_kelamin) { $qry="select * from jenis_kelamin order by id_jenis_kelamin asc"; $qryres=mysql_query($qry); echo " "; } function select_gaji_yang_ditawarkan($gaji) { $qry="select * from gaji_bulanan order by id_gaji asc"; $qryres=mysql_query($qry); echo " "; } function select_dipublish($dipublish) { $sel1=$sel2=""; echo " "; } function menuKiri($is_member) { echo " "; if($is_member==1) { echo" "; }else { echo" "; } echo" "; if($is_member==1) { echo" "; } echo "
Home
Tentang Kami
Member Area
Info Lowongan
Agenda/Berita
Buku Tamu
Situs Terkait
Kontak
Logout
"; } function menuAtas($is_member) { echo " Home   Tentang Kami  "; if($is_member==1){ echo " Member Area  "; }else { echo " Info Lowongan  "; } echo " Agenda/Berita   Buku Tamu   Kontak   "; } function menu_kiri_member() { echo " "; /* */ echo"
Cari Lowongan
Profile
Curriculum Vitae
Kirim Lamaran
Logout
"; } function menuAdmin() { echo " "; // // // // echo"
Update Selamat Datang
Update Berita
Daftar Perusahaan
Update Lowongan
SMS Registrasi
Polling
Daftar Member
Banner System
Polling System
Update Situs Terkait
User System
Logout
"; } function kontakKami() { echo " Jl. Menukan 300 Karangkajen, Yogyakarta 55153
Telp. / Fax. : 0274 372057
Email : info@jipkarir.com
Website : www.jipkarir.com
Contact Us "; } function kKami() { echo " Jl. Menukan 300
Karangkajen
Yogyakarta 55153
Telp. / Fax. 0274 372057
Email
Website www.jipkarir.com
"; } function tampil_selamat_datang() { $qry="select * from welcome_msg where status=1"; $qryres=mysql_query($qry); $data=mysql_fetch_object($qryres); if($data->img) { $welcome_img=$data->img; echo "

\"\"width\" height=\"$data->height\" hspace=\"10\" vspace=\"5\" align=\"left\"> $data->msg

"; }else echo $data->msg; } function save_selamat_datang() { if ($_POST['dbsave']) { $namafile=basename($_FILES['filename']['name']); $img="welcome_msg_".$namafile; $id=$_POST['id']; $msg=$_POST['msg']; $alt=$_POST['alt']; $width=$_POST['width']; $height=$_POST['height']; $status=$_POST['status']; if($namafile){ $qry="UPDATE welcome_msg SET msg='$msg', img='$img', alt='$alt', status=$status, width=$width, height=$height where id=$id"; if (move_uploaded_file($_FILES['filename']['tmp_name'],"../images/".$img)) { echo "
Image Telah tersimpan\n"; } else { echo "
Image Tidak dapat tersimpan, hubungi administrator anda!\n"; } }else $qry="UPDATE welcome_msg SET msg='$msg', alt='$alt', status=$status, width=$width, height=$height where id=$id"; $qryres=mysql_query($qry); }; if($qryres) print('
Data Telah tersimpan/terupdate !'); else print('Maaf data tidak dapat tersimpan/terupdate, silahkan hubungi administrator anda !'); } function admin_berita() { if(!strcmp($_GET['action'],"hapus")){ $id_berita=$_GET['id_berita']; $qryres_berita=mysql_query("select gambar from berita where id_berita=$id_berita"); $data_berita=mysql_fetch_object($qryres_berita); if($data_berita->gambar){ $img_location="../images/$data_berita->gambar"; $file_exists=file_exists($img_location); echo "file exists:$file_exists"; if(file_exists($img_location)){ unlink($img_location); clearstatcache(); }else echo "file tidak ada"; } mysql_query("delete from berita where id_berita=$id_berita"); } echo " "; $qry="select * from berita"; $qryres=mysql_query($qry); if($qryres){ while($data=mysql_fetch_object($qryres)) { $tanggal_kirim=format_tanggal($data->tgl_kirim); echo " "; } } echo "
Action
Tanggal kirim
Judul
Deskripsi
Pengirim
Publish
id_berita\" class=\"merah\">Edit id_berita\" class=\"merah\">Hapus
$tanggal_kirim
$data->judul $data->deskripsi
$data->pengirim
$data->dipublish
"; } function save_berita($namaadmin) { $judul=$_POST['judul']; $deskripsi=$_POST['deskripsi']; $detail=$_POST['detail']; $tgl_kirim=date("YmdHis"); $dipublish=$_POST['dipublish']; $alt=$_POST['alt']; $id_berita=$_POST['id_berita']; $width=$_POST['width']?$_POST['width']:0; $height=$_POST['height']?$_POST['height']:0; $namafile=basename($_FILES['filename']['name']); if ($namafile) { $gambar="berita_".$namafile; }else if ($_POST['isgambar']) { $gambar=$_POST['isgambar']; }else $gambar=''; if($id_berita) { $qry="UPDATE berita SET judul='$judul', deskripsi='$deskripsi', detail='$detail', tgl_kirim='$tgl_kirim', pengirim='$namaadmin', dipublish=$dipublish, gambar='$gambar', alt='$alt', width=$width, height=$height where id_berita=$id_berita"; }else{ $qry="INSERT into berita SET judul='$judul', deskripsi='$deskripsi', detail='$detail', tgl_kirim='$tgl_kirim', pengirim='$pengirim', dipublish=$dipublish, gambar='$gambar', alt='$alt', width=$width, height=$height"; } //echo $qry; $qryres=mysql_query($qry); if($qryres) { echo "
Data Berita Telah tersimpan Dalam Database
"; if($namafile){ if (move_uploaded_file($_FILES['filename']['tmp_name'],"../images/".$gambar)) { echo "
Image Telah tersimpan\n"; }else { echo "
Image Tidak dapat tersimpan, hubungi administrator anda!\n"; } } }else echo "
Data Berita Tidak dapat tersimpan, hubungi administrator Anda !
"; } function edit_berita($id_berita) { $qry="select * from berita where id_berita=$id_berita"; $qryres=mysql_query($qry); if($qryres){ $data=mysql_fetch_object($qryres); } return $data; } function headline_berita(){ echo ""; $qry="select * from berita where dipublish=1 order by tgl_kirim desc limit 0,3"; $qryres=mysql_query($qry); if($qryres) { echo ""; } echo " "; } function arsip_berita(){ $qry="select * from berita where dipublish=1"; $qryres=mysql_query($qry); if($qryres) { while ($data=mysql_fetch_object($qryres)){ $tanggal_kirim=format_tanggal($data->tgl_kirim); echo " $tanggal_kirim id_berita\" class=\"merah\">$data->judul

"; } } } function detail_berita() { $id_berita=$_GET['id_berita']; if($id_berita) { $qry="select * from berita where id_berita=$id_berita"; }else $qry="select * from berita where dipublish=1 order by tgl_kirim desc"; $qryres=mysql_query($qry); $data=mysql_fetch_object($qryres); $tanggal_kirim=format_tanggal($data->tgl_kirim); echo " $data->judul
Posted $tanggal_kirim By: $data->pengirim

"; if($data->gambar){ echo"

gambar\" alt=\"\" width=\"$data->width\" height=\"$data->height\" hspace=\"10\" vspace=\"5\" align=\"left\">"; } echo" $data->detail





"; } function admin_selamat_datang() { $qry="select * from welcome_msg"; $qryres=mysql_query($qry); echo " "; while ($data=mysql_fetch_object($qryres)) { echo " "; } echo "
Action
Message
Status
id."\" class=\"merah\">Edit
".$data->msg." ".$data->status."
"; } function info_lowongan() { echo "

Info Lowongan

+ Edit/Tambah Daftar Industri Perusahaan

+ Edit/Tambah Bidang Kerja

+ Edit/Tambah Kategori Pendidikan

+ Edit/Tambah Kategori Jabatan/Posisi

+ Edit/Tambah Lowongan

 

"; } function info_lowongan_industri($do,$id){ if(!strcmp($do,"del")){ mysql_query("delete from industri where id_industri=$id"); echo "Record ke $id telah terhapus"; }; if(!strcmp($do,"edit")){ $sqlres=mysql_query("select * from industri where id_industri=$id"); $data_edit=mysql_fetch_object($sqlres); }; if(!strcmp($do,"save_edit")){ $industri=$_GET['industri']; //$alias_bidang_kerja=$_GET['alias_bidang_kerja']; $sql="update industri set nama_industri='$industri' where id_industri=$id"; if(mysql_query($sql)) echo "edited";else echo "error edit"; } if(!strcmp($do,"add")){ $industri=$_GET['industri']; //$alias_bidang_kerja=$_GET['alias_bidang_kerja']; $sql="insert into industri set nama_industri='$industri'"; if(mysql_query($sql)) echo "added";else echo "error add"; } $sql="select * from industri where id_industri>0"; $sqlres=mysql_query($sql); echo "

Edit/Tambah Kategori Industri

     
Nama Industri : nama_industri\">
    id_industri\">"; if(!strcmp($do,"edit")){ echo" "; }else { echo " "; } echo"

 

"; $no_urut=0; while ($data=mysql_fetch_object($sqlres)){ $no_urut=$no_urut+1; echo " "; } echo "
No
Action
Nama Industri
$no_urut id_industri\" class=\"merah\">Edit id_industri\" class=\"merah\">Hapus $data->nama_industri
     
"; } function info_lowongan_bidang_kerja($do,$id){ if(!strcmp($do,"del")){ mysql_query("delete from bidang_kerja where id_kat_low=$id"); echo "Record ke $id telah terhapus"; }; if(!strcmp($do,"edit")){ $sqlres=mysql_query("select * from bidang_kerja where id_kat_low=$id"); $data_edit=mysql_fetch_object($sqlres); }; if(!strcmp($do,"save_edit")){ $bidang_kerja=$_GET['bidang_kerja']; $alias_bidang_kerja=$_GET['alias_bidang_kerja']; $sql="update bidang_kerja set kat_low='$bidang_kerja', alias_sms='$alias_bidang_kerja' where id_kat_low=$id"; if(mysql_query($sql)) echo "edited";else echo "error edit"; } if(!strcmp($do,"add")){ $bidang_kerja=$_GET['bidang_kerja']; $alias_bidang_kerja=$_GET['alias_bidang_kerja']; $sql="insert into bidang_kerja set kat_low='$bidang_kerja', alias_sms='$alias_bidang_kerja'"; if(mysql_query($sql)) echo "added";else echo "error add"; } $sql="select * from bidang_kerja where id_kat_low>0"; $sqlres=mysql_query($sql); echo "

Edit/Tambah Bidang Kerja

     
Bidang Kerja : kat_low\">
Alias SMS : alias_sms\" >
    id_kat_low\">"; if(!strcmp($do,"edit")){ echo" "; }else { echo " "; } echo"

 

"; $no_urut=0; while ($data=mysql_fetch_object($sqlres)){ $no_urut=$no_urut+1; echo " "; } echo "
No
Action
Bidang Kerja
Alias SMS
$no_urut id_kat_low\" class=\"merah\">Edit id_kat_low\" class=\"merah\">Hapus $data->kat_low $data->alias_sms
       
"; } function info_lowongan_kategori_pendidikan($do,$id){ if(!strcmp($do,"del")){ mysql_query("delete from pendidikan where id_tk_pend=$id"); echo "Record ke $id telah terhapus"; }; if(!strcmp($do,"edit")){ $sqlres=mysql_query("select * from pendidikan where id_tk_pend=$id"); $data_edit=mysql_fetch_object($sqlres); }; if(!strcmp($do,"save_edit")){ $kategori_pendidikan=$_GET['kategori_pendidikan']; $alias_kategori_pendidikan=$_GET['alias_kategori_pendidikan']; $sql="update pendidikan set tk_pend='$kategori_pendidikan', alias_sms='$alias_kategori_pendidikan' where id_tk_pend=$id"; if(mysql_query($sql)) echo "edited";else echo "error edit"; } if(!strcmp($do,"add")){ $kategori_pendidikan=$_GET['kategori_pendidikan']; $alias_kategori_pendidikan=$_GET['alias_kategori_pendidikan']; $sql="insert into pendidikan set tk_pend='$kategori_pendidikan', alias_sms='$alias_kategori_pendidikan'"; if(mysql_query($sql)) echo "added";else echo "error add"; } $sql="select * from pendidikan where id_tk_pend>1"; $sqlres=mysql_query($sql); echo "

Edit/Tambah Kategori Pendidikan

     
Kategori Pendidikan : tk_pend\">
Alias SMS : alias_sms\">
    id_tk_pend\">"; if(!strcmp($do,"edit")){ echo" "; }else { echo " "; } echo"

 

"; $no_urut=0; while($data=mysql_fetch_object($sqlres)){ $no_urut=$no_urut+1; echo" "; } echo "
No
Action
Kategori Pendidikan
Alias SMS
$no_urut id_tk_pend\" class=\"merah\">Edit id_tk_pend\" class=\"merah\">Hapus $data->tk_pend $data->alias_sms
       
"; } function info_lowongan_kategori_jabatan($do,$id){ if(!strcmp($do,"del")){ mysql_query("delete from jabatan where id_jabatan=$id"); echo "Record ke $id telah terhapus"; }; if(!strcmp($do,"edit")){ $sqlres=mysql_query("select * from jabatan where id_jabatan=$id"); $data_edit=mysql_fetch_object($sqlres); }; if(!strcmp($do,"save_edit")){ $kategori_jabatan=$_GET['kategori_jabatan']; $alias_kategori_jabatan=$_GET['alias_kategori_jabatan']; $sql="update jabatan set jabatan='$kategori_jabatan', alias_sms='$alias_kategori_jabatan' where id_jabatan=$id"; if(mysql_query($sql)) echo "edited";else echo "error edit"; } if(!strcmp($do,"add")){ $kategori_jabatan=$_GET['kategori_jabatan']; $alias_kategori_jabatan=$_GET['alias_kategori_jabatan']; $sql="insert into jabatan set jabatan='$kategori_jabatan', alias_sms='$alias_kategori_jabatan'"; if(mysql_query($sql)) echo "added";else echo "error add"; } $sql="select * from jabatan where id_jabatan>0"; $sqlres=mysql_query($sql); echo "

Edit/Tambah Kategori Jabatan/Posisi

     
Kategori Jabatan/Posisi : jabatan\">
Alias SMS : alias_sms\" >
    id_jabatan\">"; if(!strcmp($do,"edit")){ echo" "; }else { echo " "; } echo"

 

"; $no_urut; while ($data=mysql_fetch_object($sqlres)) { $no_urut=$no_urut+1; echo" "; } echo"
No
Action
Kategori Jabatan
Alias SMS
$no_urut id_jabatan\" class=\"merah\">Edit id_jabatan\" class=\"merah\">Hapus $data->jabatan $data->alias_sms
       
"; } function save_perusahaan($edit) { $nama_perusahaan=$_POST['nama_perusahaan']; $deskripsi_perusahaan=$_POST['deskripsi_perusahaan']; $alamat_perusahaan=$_POST['alamat_perusahaan']; $bidang_kerja=$_POST['industri']; $lokasi_perusahaan=$_POST['lokasi_perusahaan']; $kode_pos_perusahaan=$_POST['kode_pos_perusahaan']; $fax_perusahaan=$_POST['fax_perusahaan']; $website_perusahaan=$_POST['website_perusahaan']; $email_perusahaan=$_POST['email_perusahaan']; $contact_perusahaan=$_POST['contact_perusahaan']; $id=$_POST['id']; if($edit) { $sql="update perusahaan set nama_perusahaan='$nama_perusahaan', deskripsi_perusahaan='$deskripsi_perusahaan', alamat_perusahaan='$alamat_perusahaan', bidang_kerja='$bidang_kerja', lokasi_perusahaan='$lokasi_perusahaan', kode_pos_perusahaan='$kode_pos_perusahaan', fax_perusahaan='$fax_perusahaan', website_perusahaan='$website_perusahaan', email_perusahaan='$email_perusahaan', contact_perusahaan='$contact_perusahaan' where id_perusahaan=$id"; }else { $sql="insert into perusahaan set nama_perusahaan='$nama_perusahaan', deskripsi_perusahaan='$deskripsi_perusahaan', alamat_perusahaan='$alamat_perusahaan', bidang_kerja='$bidang_kerja', lokasi_perusahaan='$lokasi_perusahaan', kode_pos_perusahaan='$kode_pos_perusahaan', fax_perusahaan='$fax_perusahaan', website_perusahaan='$website_perusahaan', email_perusahaan='$email_perusahaan', contact_perusahaan='$contact_perusahaan'"; }//echo $sql; if(mysql_query($sql)) echo "."; else echo ".."; } function daftar_kategori_lowongan() { $data_array[]= array(); $sql="select * from bidang_kerja"; $sqlres=mysql_query($sql); $i=0; while ($data=mysql_fetch_object($sqlres)){ $data_array[$i][0]=$data->id_kat_low; $data_array[$i][1]=$data->alias_sms; $i++; } $n=$i; echo ""; for($i=0;$i<=$n;$i=$i+3) { echo " "; $i++; } echo "
".$data_array[$i][1]." ".$data_array[$i+1][1]." ".$data_array[$i+2][1]."
"; } function daftar_perusahaan($submit,$nama_perusahaan,$lokasi,$industri) { $bidang_kerja_arr[]=array(); $lokasi_arr[]=array(); $i=1; $j=1; $sql_industri="select * from industri"; $sql_lokasi="select * from kota"; $sqlres_industri=mysql_query($sql_industri); $sqlres_lokasi=mysql_query($sql_lokasi); while($data_industri=mysql_fetch_object($sqlres_industri)) { $industri_arr[$i][0]=$data_industri->id_industri; $industri_arr[$i][1]=$data_industri->nama_industri; $i++; } while($data_lokasi=mysql_fetch_object($sqlres_lokasi)) { $lokasi_arr[$j][0]=$data_lokasi->id_kota; $lokasi_arr[$j][1]=$data_lokasi->nama_kota; $j++; } if(!strcmp($submit,"Search")) { //memilih lokasi dan memilih industri if (($lokasi>1)and($industri>=1)) { $sql="select * from perusahaan where nama_perusahaan like '%$nama_perusahaan%' and bidang_kerja=$industri and lokasi_perusahaan=$lokasi and id_perusahaan>1"; } //memilih lokasi tetapi tidak memilih industri if (($lokasi>1)and($industri<1)) { $sql="select * from perusahaan where nama_perusahaan like '%$nama_perusahaan%' and lokasi_perusahaan=$lokasi and id_perusahaan>1"; } //memilih industri tetapi tidak memilih lokasi if (($lokasi<=1)and($industri>=1)) { $sql="select * from perusahaan where nama_perusahaan like '%$nama_perusahaan%' and bidang_kerja=$industri and id_perusahaan>1"; } if (($lokasi<=1)and($industri<1)) { $sql="select * from perusahaan where nama_perusahaan like '%$nama_perusahaan%' and id_perusahaan>1"; } }else { $sql="select * from perusahaan where id_perusahaan>1"; } //echo "query: $sql"; $sqlres=mysql_query($sql); echo" "; if(mysql_num_rows($sqlres)>0) { while($data=mysql_fetch_object($sqlres)) { echo" "; } } echo"
Action
Nama Perusahaan
Bidang Kerja
Lokasi
id_perusahaan\" class=\"merah\">Edit id_perusahaan&submit=Search&nama_perusahaan=$nama_perusahaan&lokasi_perusahaan=$lokasi_perusahaan&industri=$industri\" class=\"merah\">Hapus $data->nama_perusahaan ".$industri_arr[$data->bidang_kerja][1]." ".$lokasi_arr[$data->lokasi_perusahaan][1]."
"; } function edit_perusahaan($id_perusahaan){ $sql="select * from perusahaan where id_perusahaan=$id_perusahaan"; $sqlres=mysql_query($sql); $data=mysql_fetch_object($sqlres); return $data; } function hapus_perusahaan($id_perusahaan){ $sql_hapus_lowongannya="delete from lowongan where id_persh=$id_perusahaan"; $sql="delete from perusahaan where id_perusahaan=$id_perusahaan"; mysql_query($sql_hapus_lowongannya); mysql_query($sql); } function save_add_lowongan(){ $perusahaan=$_POST['perusahaan']; $bidang_kerja=$_POST['bidang_kerja']; $jabatan=$_POST['jabatan']; $lokasi_perusahaan=$_POST['lokasi_perusahaan']; $kategori_pendidikan=$_POST['kategori_pendidikan']; $jurusan=$_POST['jurusan']; $pengalaman_kerja=$_POST['pengalaman_kerja']; $jenis_kelamin=$_POST['jenis_kelamin']; $gaji=$_POST['gaji']; $persyaratan=$_POST['persyaratan']; $keterangan=$_POST['keterangan']; $jam_menit_detik=date("His"); $tanggal_update=$_POST['tahun_update'].$_POST['bulan_update'].$_POST['tanggal_update'].$jam_menit_detik; $tanggal_tutup=$_POST['tahun_tutup'].$_POST['bulan_tutup'].$_POST['tanggal_tutup']."240000"; $dipublish=$_POST['dipublish']; $push_sms=$_POST['push_sms']; $sql="insert into lowongan set id_persh=$perusahaan, id_bidang_kerja=$bidang_kerja, persyaratan='$persyaratan', job_desc='$keterangan', id_gaji=$gaji, tgl_selesai='$tanggal_tutup', tgl_kirim='$tanggal_update', id_lokasi=$lokasi_perusahaan, id_tk_pend=$kategori_pendidikan, id_jabatan=$jabatan, id_jurusan=$jurusan, pengalaman_kerja=$pengalaman_kerja, jenis_kelamin=$jenis_kelamin, push_sms='$push_sms', dipublish='$dipublish'"; //echo "query=$sql"; //if(mysql_query($sql)) echo "added";else echo "error added"; mysql_query($sql); } function save_edit_lowongan(){ $id_lowongan=$_POST['id_lowongan']; $perusahaan=$_POST['perusahaan']; $bidang_kerja=$_POST['bidang_kerja']; $jabatan=$_POST['jabatan']; $lokasi_perusahaan=$_POST['lokasi_perusahaan']; $kategori_pendidikan=$_POST['kategori_pendidikan']; $jurusan=$_POST['jurusan']; $pengalaman_kerja=$_POST['pengalaman_kerja']; $jenis_kelamin=$_POST['jenis_kelamin']; $gaji=$_POST['gaji']; $persyaratan=$_POST['persyaratan']; $keterangan=$_POST['keterangan']; $jam_menit_detik=date("His"); $tanggal_update=$_POST['tahun_update'].$_POST['bulan_update'].$_POST['tanggal_update'].$jam_menit_detik; $tanggal_tutup=$_POST['tahun_tutup'].$_POST['bulan_tutup'].$_POST['tanggal_tutup']."240000"; $dipublish=$_POST['dipublish']; $push_sms=$_POST['push_sms']; $sql="update lowongan set id_persh=$perusahaan, id_bidang_kerja=$bidang_kerja, persyaratan='$persyaratan', job_desc='$keterangan', id_gaji=$gaji, tgl_selesai='$tanggal_tutup', tgl_kirim='$tanggal_update', id_lokasi=$lokasi_perusahaan, id_tk_pend=$kategori_pendidikan, id_jabatan=$jabatan, id_jurusan=$jurusan, pengalaman_kerja=$pengalaman_kerja, jenis_kelamin=$jenis_kelamin, push_sms='$push_sms', dipublish='$dipublish' where id_lowongan=$id_lowongan"; //echo "query=$sql"; //if(mysql_query($sql)) echo "added";else echo "error added"; mysql_query($sql); } function form_cari_lowongan() { echo "
 
 
 
    "; select_bidang_kerja($bidang_kerja); echo "  
    "; select_jabatan($jabatan); echo "  
    "; select_lokasi($lokasi_perusahaan); echo"  
         
       
"; } function counter_visitor(){ $filename = "counter.txt"; @$fptr = fopen($filename, "r+"); if ($fptr == NULL) { @$fptr = fopen($filename, "w+"); fwrite($fptr, "1"); fclose($fptr); $dataInt=1; }else { $data = fread($fptr, filesize($filename)); $dataInt = (int) $data; //echo "hallo $is_add";; if($is_add==0){ $dataInt++; $is_add=1; rewind($fptr); fwrite($fptr, $dataInt); fclose($fptr); } } return $dataInt; } function add_banner($page){ $qry="select * from banner where page='$page'"; //echo $qry; $qry_res=mysql_query($qry); if(mysql_num_rows($qry_res)>0) { while($data_banner=mysql_fetch_object($qry_res)) { if($data_banner->tipe=="Image"){ echo " url\">file_name\" width=\"$data_banner->width\" height=\"$data_banner->height\" border=\"0\">"; }else { echo " url\"> width\" height=\"$data_banner->height\"> file_name\"> file_name\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"$data_banner->width\" height=\"$data_banner->height\"> "; } echo "

"; } } } function internasional_msisdn($msisdn) { $prefix=substr($msisdn,0,2); if(strcmp($prefix,"62")) { $msisdn=substr($msisdn,1,strlen($msisdn)-1); $msisdn="62".$msisdn; } return $msisdn; } ?>db->query('select idx,year,title,name,date,date(tanggal) as tanggal, ven_room,ven_name,ven_add,ven_city,ven_zip,ven_country,lat,lang,lot_total,gbr_1 from previous'); return $q; } function getLatest(){ $tgl_skr = date('Y-m-d H:i:s'); $q=$this->db->query('SELECT * FROM previous WHERE tanggal <="'.$tgl_skr.'" ORDER BY tanggal DESC limit 1'); return $q; } function getClStart($st){ $tgl_skr = date('Y-m-d H:i:s'); $q=$this->db->query('SELECT * FROM previous WHERE tanggal <= "'.$tgl_skr.'" ORDER BY tanggal DESC limit '.$st.',3'); return $q; } function getNext(){ $tgl_skr = date('Y-m-d H:i:s'); $q=$this->db->query("SELECT title,gbr_1,tanggal,date,DATE(tanggal)-1 as tgl,ven_name FROM previous WHERE tanggal >'".$tgl_skr."' ORDER BY tanggal"); return $q; } function getTglAuc(){ $tgl_skr = date('Y-m-d H:i:s'); $q=$this->db->query("SELECT date(tanggal) as tanggal FROM previous WHERE tanggal >'".$tgl_skr."' ORDER BY tanggal limit 1"); return $q; } function select($idx){ $r= $this->db->query('select * from previous where idx='.$idx.''); return $r; } function selectAll(){ return $this->db->get('previous')->result(); } /*function getMaxDate(){ $tgl_skr = date('Y-m-d H:i:s'); $q= $this->db->query("SELECT DATE_FORMAT(DATE(tanggal)-2,'%M %d, %Y') as tgl FROM previous WHERE tanggal >'".$tgl_skr."' ORDER BY tanggal limit 1"); return $q; }*/ function getSiteMap(){ $tgl_skr = date('Y-m-d H:i:s'); $s=$this->db->query('select * from previous where tanggal<="'.$tgl_skr.'" order by tanggal'); return $s; } //countdown function getCtDwWeb(){ $cd= $this->db->query("SELECT day(start) as tgl, month(start) as bln, year(start) as thn FROM countdown"); return $cd; } function getCtDw(){ $cd= $this->db->query("SELECT date(start) as start FROM countdown"); return $cd; } function setCtDw($dt){ $this->db->query("truncate table countdown"); $cd= $this->db->query("insert into countdown(start) values('$dt')"); return $cd; } function stopCtDw(){ $st= $this->db->query("truncate table countdown"); return $st; } //admin function insert($b,$c,$d,$f,$g,$h,$i,$j,$k,$l,$m,$n,$o,$p){ $e=date("l, F d,Y",strtotime($f)); $s= $this->db->query("INSERT INTO previous(year,title,name,date,tanggal, ven_room,ven_name,ven_add,ven_city,ven_zip,ven_country,lat,lang,lot_total,gbr_1) VALUES ('$b','$c','$d','$e','$f','$g','$h','$i','$j','$k','$l','$m','$n','$o','$p')"); return $s; } function hapus($id){ $r= $this->db->query("delete from previous where idx='$id'"); return $r; } function update($a,$b,$c,$d,$f,$g,$h,$i,$j,$k,$l,$m,$n,$o,$p){ $e=date("l, F d,Y",strtotime($f)); $u= $this->db->query("UPDATE previous SET year=$b, title='$c', name='$d' ,date='$e', tanggal='$f', ven_room='$g', ven_name='$h', ven_add='$i' , ven_city='$j', ven_zip='$k', ven_country='$l', lat='$m', lang='$n',lot_total='$o', gbr_1='$p' WHERE idx='$a'"); return $u; } } ?>