<?

function connect_db() {
 $username='c2webopd';
 $password='Diskominfo@23';
 $hostname='localhost';
 $dbname='c2balitbangda';
 $link=mysql_connect("$hostname","$username","$password") or die("Could not connect");
 $dbconn=mysql_select_db("$dbname") or die("Could not select database"); 
 return $dbconn;
}



function is_member_login($member_login,$password_login,$member_id){
	if(($member_login=='')or($password_login=='')or($member_id=='')) {
		$is_login=0;
	} else {
		$is_login=1;
	}
	return $is_login;
}

function masukPicker($tanggal){
	$pisah = explode('-',$tanggal);
	$larik = array($pisah[2],$pisah[1],$pisah[0]);
	$satukan = implode('/',$larik);
	return $satukan;
}

function keluarPicker($tanggal){
	$pisah = explode('/',$tanggal);
	$array = array($pisah[2],$pisah[1],$pisah[0]);
	$satukan = implode('-',$array);
	return $satukan;
}

function format_timestamp($timestamp){ 
	$hour = substr($timestamp,11,2); 
	$minute = substr($timestamp,14,2); 
	$second = substr($timestamp,17,2); 
	$month = substr($timestamp,5,2); 
	$day = substr($timestamp,8,2); 
	$year = substr($timestamp,0,4);
	return $tanggal=array ($year,$month,$day,$hour,$minute,$second);
}

function format_tanggal_lahir($timestamp) {
	$bulan_arr=array("","Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember");
	$data=format_timestamp($timestamp);
	$bul=(int)($data[1]);
	return $data[2]." ".$bulan_arr[$bul]." ".$data[0];
}

function format_tanggal_berita($timestamp) {
	$day=date('w', strtotime($timestamp));
	$namaHari_arr=array("Minggu","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu");  
	$namaBulan_arr=array("","Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember");
	$data=format_timestamp($timestamp);
	$bul=(int)($data[1]);
	return $namaHari_arr[$day].", ".$data[2]." ".$namaBulan_arr[$bul]." ".$data[0]." - ".$data[3].":".$data[4];
}

function format_tanggal_lengkap($timestamp) {
	$day=date('w', strtotime($timestamp));
	$namaHari_arr=array("Minggu","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu");
	$namaBulan_arr=array("","Jan","Feb","Mar","Apr","Mei","Jun","Jul","Agt","Sep","Okt","Nov","Des");
	$data=format_timestamp($timestamp);
	$bul=(int)($data[1]);
	return $namaHari_arr[$day].", ".$data[2]." ".$namaBulan_arr[$bul]." ".$data[0]." - ".$data[3].":".$data[4].":".$data[5];
}

function format_tanggal_gallery($timestamp) {
	$bulan_arr=array("","Jan","Feb","Mar","Apr","Mei","Jun","Jul","Agt","Sep","Okt","Nov","Des");
	$data=format_timestamp($timestamp);
	$bul=(int)($data[1]);
	return $data[2]." ".$bulan_arr[$bul]." ".$data[0];
}

function format_tanggal_ind($timestamp) {
	$bulan_arr=array("","Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember");
	$data=format_timestamp($timestamp);
	$bul=(int)($data[1]);
	return $data[2]." ".$bulan_arr[$bul]." ".$data[0]." - ".$data[3].":".$data[4].":".$data[5];
}

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 format_tanggal_login($timestamp) {
	$data=format_timestamp($timestamp);
	return $data[2]."/".$data[1]."/".$data[0]." ".$data[3].":".$data[4].":".$data[5];
}

function randomPassword($length) {
	$digit = 6;
	$karakter = "abcdefghijkmnopqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ23456789";	
	srand((double)microtime()*1000000);
	$i = 0;
	$pass = "";
	while ($i <= $digit-1) {
		$num = rand() % 32;
		$tmp = substr($karakter,$num,1);
		$pass = $pass.$tmp;
		$i++;
	}
	return $pass;
}

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 "
 <select name=\"tanggal\">";
 echo "<option value=\"\" ></option>";
 for($i=1;$i<=31;$i++) {
            if($tanggal==$i) $sel="selected";else $sel=""; 
            echo "<option value=\"$i\" $sel >$i</option>";
 }
 echo "             
 </select>
 <select name=\"bulan\">";
 echo "<option value=\"\" ></option>";
 for($i=1;$i<count($bulan_arr);$i++) {
             if ($bulan==$bulan_arr[$i]) $sel="selected";else $sel=""; 
             echo "<option value=\"$bulan_arr[$i]\" $sel >$bulan_arr[$i]</option>";
  }
  echo "             
  </select>
  <select name=\"tahun\"> ";
  echo "<option value=\"\" ></option>";
  for($i=2006;$i<2020;$i++) {
               if ($tahun==$i) $sel="selected";else $sel="";     
               echo" <option value=\"$i\" $sel >$i</option>";
  }
  echo "              
   </select>";
}


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 "
 <select name=\"tanggal_lahir\">";
 for($i=1;$i<=31;$i++) {
 			if($i<10) $n="0".$i;else $n=$i;
            if($tanggal_lahir==$n) $sel="selected";else $sel=""; 
            echo "<option value=\"$n\" $sel >$i</option>";
 }
 echo "             
 </select>
 <select name=\"bulan_lahir\">";
 for($i=0;$i<count($bulan_arr);$i++) {
 			if($i<10) $n="0".$i;else $n=$i;
             if ($bulan_lahir==$n) $sel="selected";else $sel="";
             echo "<option value=\"$n\" $sel >$bulan_arr[$i]</option>";
  }
  echo "             
  </select>
  <select name=\"tahun_lahir\"> ";
  for($i=1960;$i<2006;$i++) {
               if ($tahun_lahir==$i) $sel="selected";else $sel="";     
               echo" <option value=\"$i\" $sel >$i</option>";
  }
  echo "              
   </select>";
}


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 "
 <select name=\"tgl_$prefix\">";
 echo "<option value=\"\" ></option>";
 for($i=1;$i<=31;$i++) {
            if($tanggal==$i) $sel="selected";else $sel=""; 
            echo "<option value=\"$i\" $sel >$i</option>";
 }
 echo "             
 </select>
 <select name=\"bln_$prefix\">";
 echo "<option value=\"\" ></option>";
 for($i=0;$i<count($bulan_arr);$i++) {
 				$n=$i+1;
             if ($bulan==$n) $sel="selected";else $sel=""; 
             echo "<option value=\"$n\" $sel >$bulan_arr[$i]</option>";
  }
  echo "             
  </select>
  <select name=\"thn_$prefix\"> ";
  echo "<option value=\"\" ></option>";
  for($i=2006;$i<2020;$i++) {
               if ($tahun==$i) $sel="selected";else $sel="";     
               echo" <option value=\"$i\" $sel >$i</option>";
  }
  echo "              
   </select>";
}


function select_lokasi($lokasi_perusahaan) {
 $qry="select * from kota order by nama_kota asc";
 $qryres=mysql_query($qry);
 
 echo "
 <select name=\"lokasi_perusahaan\">";
 while ($data=mysql_fetch_object($qryres)){
            if($lokasi_perusahaan==$data->id_kota) $sel="selected";else $sel=""; 
            echo "<option value=\"$data->id_kota\" $sel >$data->nama_kota</option>";
 }
 echo "</select>";
 
}

function select_bidang_kerja($bidang_kerja) {
 $qry="select * from bidang_kerja order by kat_low asc";
 $qryres=mysql_query($qry);
 
 echo "
 <select name=\"bidang_kerja\">";
 while ($data=mysql_fetch_object($qryres)){
            if($bidang_kerja==$data->id_kat_low) $sel="selected";else $sel=""; 
            echo "<option value=\"$data->id_kat_low\" $sel >$data->kat_low</option>";
 }
 echo "</select>";
 
}

function select_industri($industri) {
 $qry="select * from industri order by nama_industri asc";
 $qryres=mysql_query($qry);
 
 echo "
 <select name=\"industri\">";
  echo "<option value=\"0\" $sel >Tidak Disebutkan</option>";
 while ($data=mysql_fetch_object($qryres)){
            if($industri==$data->id_industri) $sel="selected";else $sel=""; 
            echo "<option value=\"$data->id_industri\" $sel >$data->nama_industri</option>";
 }
 echo "</select>";
 
}

function select_perusahaan($perusahaan) {
$qry="select * from perusahaan order by nama_perusahaan asc";
 $qryres=mysql_query($qry);
 
 echo "
 <select name=\"perusahaan\">";
 while ($data=mysql_fetch_object($qryres)){
            if($perusahaan==$data->id_perusahaan) $sel="selected";else $sel=""; 
            echo "<option value=\"$data->id_perusahaan\" $sel >$data->nama_perusahaan</option>";
 }
 echo "</select>";
 
}

function select_jabatan($jabatan) {
 $qry="select * from jabatan order by jabatan asc";
 $qryres=mysql_query($qry);
 
 echo "
 <select name=\"jabatan\">";
 while ($data=mysql_fetch_object($qryres)){
            if($jabatan==$data->id_jabatan) $sel="selected";else $sel=""; 
            echo "<option value=\"$data->id_jabatan\" $sel >$data->jabatan</option>";
 }
 echo "</select>";
}


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 "
<table width=\"98%\"  border=\"1\" cellpadding=\"0\" cellspacing=\"0\">
          <tr bgcolor=\"#CCCCCC\">
            <td width=\"11%\"><div align=\"center\"><strong>Action</strong></div></td>
            <td width=\"14%\"><div align=\"center\"><strong>Tanggal kirim </strong></div></td>
            <td width=\"22%\"><div align=\"center\"><strong>Judul</strong></div></td>
            <td width=\"34%\"><div align=\"center\"><strong>Deskripsi</strong></div></td>
            <td width=\"10%\"><div align=\"center\"><strong>Pengirim</strong></div></td>
            <td width=\"9%\"><div align=\"center\"><strong>Publish</strong></div></td>
          </tr>";
		  
 $qry="select * from berita";
 $qryres=mysql_query($qry);
 if($qryres){
 while($data=mysql_fetch_object($qryres)) {
 		$tanggal_kirim=format_tanggal($data->tgl_kirim);
		echo "     
		  <tr>
            <td><div align=\"center\"><a href=\"editberita.php?id_berita=$data->id_berita\" class=\"merah\">Edit</a> 
			<a href=\"berita.php?action=hapus&id_berita=$data->id_berita\" class=\"merah\">Hapus</a> </div></td>
            <td><div align=\"center\">$tanggal_kirim</td>
            <td>$data->judul</td>
            <td>$data->deskripsi</td>
            <td><div align=\"center\">$data->pengirim</td>
            <td><div align=\"center\">$data->dipublish</td>
          </tr>";
	}
 }		  
echo " 
</table>";

}

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 "<br>Data Berita Telah tersimpan Dalam Database<br>";
		if($namafile){
			if (move_uploaded_file($_FILES['filename']['tmp_name'],"../images/".$gambar)) {
  				echo "<br>Image Telah tersimpan\n";
			}else {
   				echo "<br>Image Tidak dapat tersimpan, hubungi administrator anda!\n";
			}
		}
	}else 
	echo "<br>Data Berita Tidak dapat tersimpan, hubungi administrator Anda !<br>";
}

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 "<td class=\"kotakberita\">";
	$qry="select * from berita where dipublish=1 order by tgl_kirim desc limit 0,3";
	$qryres=mysql_query($qry);
	if($qryres) {
	echo "<ul>";
	 	while ($data=mysql_fetch_object($qryres)){
		   $tanggal_kirim=format_tanggal($data->tgl_kirim);
			echo "
			<li>
			<a href=\"detail_berita.php?id_berita=$data->id_berita\" class=\"headline\">
			<span class=\"judulheadline\">$data->judul<br></span>
			<span class=\"headline\">$data->deskripsi</span><br>
            <span class=\"tglberita\">$tanggal_kirim<br></span>
			</a>
		   </li>";
 		}
	echo "</ul>";
	}
	echo "</td> ";
}

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 "
	 		<span class=\"tglberita\">$tanggal_kirim</span>
			<a href=\"detail_berita.php?id_berita=$data->id_berita\" class=\"merah\"><span class=\"\">$data->judul<br></span></a>
           	<br>";
 		}
	}
}

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 "
	<span class=\"judul\">$data->judul<br></span>
	<span class=\"tglberita\">Posted $tanggal_kirim By: $data->pengirim<br><br></span>";
	
	if($data->gambar){
	echo"
	<p align=\"justify\"><img src=\"images/$data->gambar\" alt=\"\" width=\"$data->width\" height=\"$data->height\" hspace=\"10\" vspace=\"5\" align=\"left\">";
	}
	echo"
		<span class=\"berita\">$data->detail</span>
		
	</p><br><br><br><hr>";
}

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;
}

?>