<?php
define('PATH', 'https://dpmptsp.pekanbaru.go.id/home/');
define('PATH2', 'https://dpmptsp.pekanbaru.go.id/');
//define('DB_HOST', 'localhost'); 
//define('DB_USERNAME', 'root'); 
//define('DB_PASSWORD', 'pus4td4t4/2017/1Z1N'); 
//define('DB_NAME', 'dpmptsp');

define('DB_HOST', '172.25.100.10'); 
define('DB_USERNAME', 'singledb'); 
define('DB_PASSWORD', 'S1ngl3db2024!'); 
define('DB_NAME', 'singledb_simpel');
	
	try {
    $conn = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME, DB_USERNAME, DB_PASSWORD);
	$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );	
    }
catch(PDOException $e)
    {
    echo "Koneksi Database Gagal : " . $e->getMessage();
    }
	
	function buatSelect($name, $arr = array(), $id, $required, $class) {
		echo '<select class="'.$class.'" name="'.$name.'" id="'.$name.'" '.($required ? 'required' : '').' >'."\n";
		if (count($arr) > 0) {
			foreach ($arr as $v) {
				echo "<option value='".$v."'";
				if ($v == $id) {
					echo " selected";
				}
				echo ">".$v."</option>\n";
			}
 
			echo "<option value='industri mesin, elektronik, instrumen kedokteran, peralatan listrik, presisi, optik dan jam'>industri mesin, elektronik, instrumen kedokteran, peralatan listrik, presisi, optik dan jam</option>\n";
			echo "<option value='industri barang dari kulit dan alas kaki'>industri barang dari kulit dan alas kaki</option>\n";
			echo "<option value='industri karet dan plastik'>industri karet dan plastik</option>\n";
			echo "<option value='industri kayu'>industri kayu</option>\n";
			echo "<option value='industri kendaraan bermotor dan alat transportasi lain'>industri kendaraan bermotor dan alat transportasi lain</option>\n";
			echo "<option value='industri lainnya'>industri lainnya</option>\n";
			echo "<option value='industri logam dasar, barang logam bukan mesin dan peralatannya'>industri logam dasar, barang logam bukan mesin dan peralatannya</option>\n";
			echo "<option value='industri mineral non logam'>industri mineral non logam</option>\n";
			echo "<option value='perikanan'>perikanan</option>\n";
			echo "<option value='pertambangan'>pertambangan</option>\n";

		}
		echo "</select>";
	}


function tglNormal($date,$delimeter){
	if(strlen($date)==10){
		if(($date=='0000-00-00')or(empty($date))){
			return '';
		}else{
			$date = explode('-',$date);
			if(isset($delimeter)){
				$date = $date[2].$delimeter.$date[1].$delimeter.$date[0];	
			}else{
				$date = $date[2].'-'.$date[1].'-'.$date[0];	
			}
			return($date);
		}
	}else{
		if(($date=='0000-00-00 00:00:00')or(empty($date))){
			return '';
		}else{
			$tgl = explode(' ',$date);
			$date = explode('-',$tgl[0]);
			if(isset($delimeter)){
				$date = $date[2].$delimeter.$date[1].$delimeter.$date[0].' '.$tgl[1];	
			}else{
				$date = $date[2].'-'.$date[1].'-'.$date[0].' '.$tgl[1];	
			}
			return($date);
		}		
	}
	
}
	
	function buatSelectBulan($name, $id, $required, $class) {
		echo '<select class="'.$class.'" name="'.$name.'" '.($required ? 'required' : '').' >'."\n";
		$BulanIndo = array('01'=>"Januari", '02'=>"Februari", '03'=>"Maret", '04'=>"April", '05'=>"Mei", '06'=>"Juni", '07'=>"Juli", '08'=>"Agustus", '09'=>"September", '10'=>"Oktober", '11'=>"November", '12'=>"Desember");		
			foreach ($BulanIndo as $k=>$v) {
				echo "<option value='".$k."'";
				if ($k == $id) {
					echo " selected";
				}
				echo ">".$v."</option>\n";
			}
		echo "</select>";
	}	

		function buatSelectTahun($name, $id,$from,$to, $required, $class) {
		echo '<select class="'.$class.'" name="'.$name.'" '.($required ? 'required' : '').' >'."\n";
			for($i=$from;$i<=$to;$i++){
				echo "<option value='".$i."'";
				if ($i == $id) {
					echo " selected";
				}
				echo ">".$i."</option>\n";
			}
		echo "</select>";
	}
	
function tglIndo($date){
	$BulanIndo = array("Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");
	$bulan = substr($date, 5, 2);
	$tgl = substr($date, 8, 2);
	$tahun   = substr($date, 0, 4);
	$result = $tgl . " " . $BulanIndo[(int)$bulan-1] . " ". $tahun;		
	return($result);
}	
function tglIndo2($date){
	$BulanIndo = array("Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");
	$tgl = substr($date, 0, 2);
	$bulan = substr($date, 3, 2);
	$tahun   = substr($date, 6, 4);
	$result = $tgl . " " . $BulanIndo[(int)$bulan-1] . " ". $tahun;		
	return($result);
}
	function createSelect($name, $arr = array(), $id, $required, $class,$ket) {
		echo '<select class="'.$class.'" id="'.$name.'" name="'.$name.'"  '.($required ? 'required' : '').' '.$ket.' >'."\n";
		if ($id == 0) {
			echo'<option value="0">Pilih</option>';
		}
		if (count($arr) > 0) {
			foreach ($arr as $k=>$v) {
				echo "<option value='".$v['id']."'";
				if ($v['id'] == $id) {
					echo " selected";
				}
				echo ">".(strlen($v['name']) > 150 ? substr($v['name'], 0, 150).'...' : $v['name'])."</option>\n";
			}
		}
		echo "</select>";
	}
	
	function createSelect2($name, $arr = array(), $id, $required, $class,$ket) {
		echo '<select class="'.$class.'" id="'.$name.'" name="'.$name.'"  '.($required ? 'required' : '').' '.$ket.' >'."\n";
		echo '<optgroup label="Provinsi">';
		if (($id == 0) or ($id == 1)){
			echo'<option value="1" selected>Riau</option>';
		}else{
			echo'<option value="1">Riau</option>';
		}
		echo '</optgroup>';
		echo '<optgroup label="Kabupaten/Kota">';
		if (count($arr) > 0) {
			foreach ($arr as $k=>$v) {
				echo "<option value='".$v['id']."'";
				if ($v['id'] == $id) {
					echo " selected";
				}
				echo ">".(strlen($v['name']) > 45 ? substr($v['name'], 0, 45).'...' : $v['name'])."</option>\n";
			}
		}
		echo '</optgroup>';
		echo "</select>";
	}
	
function dateNormal($date){
if(!empty($date)){
	$date = explode('-',$date);
	$date = $date[2].'/'.$date[1].'/'.$date[0];	
	}
	return($date);
}

function dateSql($date){
	$date = explode('/',$date);
	$date = $date[2].'-'.$date[1].'-'.$date[0];	
	return($date);
}

	function romanicNumber($integer, $upcase = true)  { 
		$table = array('M'=>1000, 'CM'=>900, 'D'=>500, 'CD'=>400, 'C'=>100, 'XC'=>90, 'L'=>50, 'XL'=>40, 'X'=>10, 'IX'=>9, 'V'=>5, 'IV'=>4, 'I'=>1); 
		$return = ''; 
		while($integer > 0) 
		{ 
		    foreach($table as $rom=>$arb) 
		    { 
		        if($integer >= $arb) 
		        { 
		            $integer -= $arb; 
		            $return .= $rom; 
		            break; 
		        } 
		    } 
		} 
		
		return $upcase ? $return : strtolower($return); 
	}

	function debug($x){
		echo'<pre>';
		print_r($x);
		echo'</pre>';
	}

	function writeLog($tipe,$pesan,$userid){
		global $conn;
				$stmt = $conn->prepare("INSERT INTO tbl_log
										(logTipe, logTgl, logPesan,logUserID) 
										VALUES (:logTipe, :logTgl, :logPesan,:logUserID) 
										"); 
			$data = array(
						':logTipe'=>$tipe,
						':logTgl'=>date('Y-m-d H:i:s'),
						':logPesan'=>$pesan,
						':logUserID'=>$userid
						);
			if ($stmt->execute($data)) { 
					return true;
					}else{
					return false;
					}
	}

	function jumlahData($tabel){
		global $conn;
				$stmt = $conn->prepare("SELECT count(*) as total from ".$tabel." "); 
				$stmt->execute();
				$jumlah = $stmt->fetchColumn();
				$stmt->closeCursor();
				return $jumlah;
	}
	function jumlahDataQuery($query){
		global $conn;
				$stmt = $conn->prepare("SELECT count(*) as total ".$query." "); 
				$stmt->execute();
				$jumlah = $stmt->fetchColumn();
				$stmt->closeCursor();
				return $jumlah;
	}
	
	function getDataBySQL($sql){
		global $conn;						
			$stmt = $conn->prepare($sql); 			
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}	
	
	function getData($tipe,$batas){
		global $conn;
		if($batas>0){
				$batas ='LIMIT '.$batas;
			}else{
				$batas ='';		
			}
			
		if($tipe=='all'){
				$tipe2 ='';
			}else{
				$tipe2 = "AND post_type='".$tipe."'";		
			}			
			
			$stmt = $conn->prepare("SELECT post_ID,post_title,post_image,post_date,post_type,post_counter,post_content FROM tbl_post 
									where post_status=1 ".$tipe2." 
									order by post_date DESC ".$batas." "); 
			
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}
	function getData2($tipe,$batas){
		global $conn;
			$stmt = $conn->prepare("SELECT post_ID,post_title,post_image,post_date,post_type FROM tbl_post 
									where tbl_post.post_status=1 
									order by post_date DESC LIMIT ".$batas." "); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}
	function getCari($q,$tipe,$awal,$akhir){
		global $conn;
		if($tipe=='all'){
			$stmt = $conn->prepare("SELECT post_ID,post_title,post_image,post_date,post_type,post_counter,post_content FROM tbl_post 
									where tbl_post.post_status=1 AND 
									(post_title LIKE '%".$q."%' OR post_type LIKE '%".$q."%' OR post_content LIKE '%".$q."%')
									order by post_date DESC LIMIT ".$awal.",".$akhir." ");
			}elseif($tipe=='arsip'){
			$stmt = $conn->prepare("SELECT post_ID,post_title,post_image,post_date,post_type,post_counter,post_content FROM tbl_post 
									where tbl_post.post_status=1 AND 
									(post_date LIKE '%".$q."%')
									order by post_date DESC LIMIT ".$awal.",".$akhir." ");
			}else{
			$stmt = $conn->prepare("SELECT post_ID,post_title,post_image,post_date,post_type,post_counter,post_content FROM tbl_post 
									where tbl_post.post_status=1 AND post_type='".$tipe."'
									order by post_date DESC LIMIT ".$awal.",".$akhir." ");
			}			
 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}	
	
	function getBerita($id){
		global $conn;
			$stmt = $conn->prepare("SELECT * FROM tbl_post 
									where tbl_post.post_status=1 and tbl_post.post_ID='".$id."'
									order by post_date DESC LIMIT 1 "); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}	
	function getIzin($id){
		global $conn;
			$stmt = $conn->prepare("SELECT * FROM jenislayanan 
									where tampil=1 and id='".$id."'
									LIMIT 1 "); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}
	function getIzinDetail($jenis,$judul){
		global $conn;
			$stmt = $conn->prepare("SELECT * FROM jenislayanan 
									where judul LIKE '%".$judul."%'
									LIMIT 1 "); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}
	function getJP(){
		global $conn;
			$stmt = $conn->prepare("SELECT id,judul,jenis,sop,formulir FROM jenislayanan WHERE tampil=1 order by judul"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}
	
	function getDataIzin($tipe,$batas){
		global $conn;
			$stmt = $conn->prepare("SELECT id,judul FROM jenislayanan 
									where jenis='".$tipe."' and tampil=1 
									order by id LIMIT ".$batas." "); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}	
	function getDataPartner($batas){
		global $conn;
			$stmt = $conn->prepare("SELECT * FROM partner 
									order by no LIMIT ".$batas." "); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}
	function getPimpinan(){
		global $conn;
			$stmt = $conn->prepare("SELECT * FROM pejabat,jabatan
									WHERE jabatan.jbtnID=pejabat.jabatan AND (jabatan.jbtnParentID=0 OR jabatan.jbtnParentID=1)
									order by jabatan.jbtnID"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}	
	function getKasi($parent){
		global $conn;
			$stmt = $conn->prepare("SELECT * FROM pejabat,jabatan
									WHERE jabatan.jbtnID=pejabat.jabatan AND (jabatan.jbtnParentID='".$parent."')
									order by jabatan.jbtnID"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}	
	function getAbout(){
		global $conn;
			$stmt = $conn->prepare("SELECT * FROM about order by no"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;
	}		
	function getArsip(){
		global $conn;
			$stmt = $conn->prepare("SELECT DATE_FORMAT(`post_date`, '%m') as 'month', COUNT(`post_ID`) as 'total', DATE_FORMAT(`post_date`, '%Y-%m') as 'tgl'
			FROM  tbl_post WHERE `post_date` > DATE_SUB(now(), INTERVAL 11 MONTH)
			GROUP BY DATE_FORMAT(`post_date`, '%m') ORDER by tgl DESC"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
		$BulanIndo = array("01"=>"Januari", "02"=>"Februari", "03"=>"Maret", "04"=>"April", "05"=>"Mei", "06"=>"Juni", "07"=>"Juli", "08"=>"Agustus", "09"=>"September", "10"=>"Oktober", "11"=>"November", "12"=>"Desember");
		foreach($data as $k=>$v){
			$hasil[$BulanIndo[$v['month']]]['jumlah']=$v['total'];
			$hasil[$BulanIndo[$v['month']]]['tanggal']=$v['tgl'];
		}
		return $hasil;		
	}
	function getVisitorBulanan(){
		global $conn;
			$stmt = $conn->prepare("SELECT DATE_FORMAT(`visitor_date`, '%m') as 'month', COUNT(`visitor_ID`) as 'total', DATE_FORMAT(`visitor_date`, '%Y-%m') as 'tgl'
			FROM  tbl_visitor_logs WHERE MONTH(`visitor_date`) <= MONTH(CURRENT_DATE - INTERVAL 12 MONTH) 
			GROUP BY DATE_FORMAT(`visitor_date`, '%m') ORDER by month"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
		$BulanIndo = array("01"=>"Januari", "02"=>"Februari", "03"=>"Maret", "04"=>"April", "05"=>"Mei", "06"=>"Juni", "07"=>"Juli", "08"=>"Agustus", "09"=>"September", "10"=>"Oktober", "11"=>"November", "12"=>"Desember");
		foreach($data as $k=>$v){
			$hasil[$BulanIndo[$v['month']]]['jumlah']=$v['total'];
			$hasil[$BulanIndo[$v['month']]]['tanggal']=$v['tgl'];
		}
		return $hasil;		
	}
		function getVisitorMingguan(){
		global $conn;
			$stmt = $conn->prepare("SELECT COUNT(`visitor_ID`) as 'total', DATE_FORMAT(`visitor_date`, '%d-%m-%Y') as 'tgl' 
FROM  tbl_visitor_logs WHERE DATE(visitor_date) BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()
			GROUP BY tgl order by visitor_date"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();

		return $data;		
	}

	function getStatPengunjung(){
		global $conn;
			$stmt = $conn->prepare("SELECT COUNT(`visitor_ID`) as 'total' FROM  tbl_visitor_logs WHERE `visitor_date` LIKE '".date('Y-m')."%'"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
		foreach($data as $k=>$v){
			$hasil['bulan']=$v['total'];
		}
			$stmt = $conn->prepare("SELECT COUNT(`visitor_ID`) as 'total' FROM  tbl_visitor_logs WHERE `visitor_date` LIKE '".date('Y-m-d')."%'"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
		foreach($data as $k=>$v){
			$hasil['hari']=$v['total'];
		}
			$stmt = $conn->prepare("SELECT COUNT(`visitor_ID`) as 'total' FROM  tbl_visitor_logs"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
		foreach($data as $k=>$v){
			$hasil['total']=$v['total'];
		}		
		return $hasil;		
	}	
	
	function getJenisPerizinan(){
		global $conn;
			$stmt = $conn->prepare("SELECT jenis,count(id) as total FROM  jenislayanan WHERE tampil=1 GROUP BY jenis ORDER by jenis DESC"); 
			$stmt->execute();
			$data = $stmt->fetchAll();
			$stmt->closeCursor();
			return $data;		
	}
	
	function visitor_log($sessId){	
	global $conn;
		if(isset($sessId)){		
		if($sessId<>'192.168.1.199'){
			$date = date('Y-m-d H:i:s');
			$agent = $_SERVER['HTTP_USER_AGENT'];
			(!empty($_SERVER['HTTP_REFERER'])) ? $reff = $_SERVER['HTTP_REFERER'] : $reff = '';
			
			@$var = file_get_contents("http://ip-api.com/json/$sessId");
			$var = json_decode($var);
			
			$stmt = $conn->prepare("INSERT INTO `tbl_visitor_logs` 
								(`visitor_IP`, `visitor_referer`, `visitor_date`, `visitor_agent`, `visitor_session`, `visitor_city`, `visitor_region`, `visitor_country`, `visitor_os`, `visitor_browser`, `visitor_isp`) 
								VALUES (:visitor_IP, :visitor_referer, :visitor_date, :visitor_agent, :visitor_session, :visitor_city, :visitor_region, :visitor_country, :visitor_os, :visitor_browser, :visitor_isp)"); 
			$visitorLogs = array(
					'visitor_IP' => $sessId, 
					'visitor_referer' => $reff, 
					'visitor_date' => $date, 
					'visitor_agent' => $agent, 
					'visitor_session' => $sessId,
					'visitor_city' => @$var->city, 	
					'visitor_region' => @$var->regionName, 	
					'visitor_country' => @$var->country, 	
					'visitor_os' => getOS($agent),
					'visitor_browser' => getBrowser($agent),
					'visitor_isp' => @$var->isp
			);
							
		if ($stmt->execute($visitorLogs)) { 
			return TRUE;
			}else{
			return FALSE;
			}	
		}else{
			return FALSE;
		}			
		}else{ return FALSE; }			
	}

function getOS($user_agent) { 
    $os_platform    =   "Unknown OS Platform";
    $os_array       =   array(
                            '/windows nt 10/i'     =>  'Windows 10',
                            '/windows nt 6.3/i'     =>  'Windows 8.1',
                            '/windows nt 6.2/i'     =>  'Windows 8',
                            '/windows nt 6.1/i'     =>  'Windows 7',
                            '/windows nt 6.0/i'     =>  'Windows Vista',
                            '/windows nt 5.2/i'     =>  'Windows Server 2003/XP x64',
                            '/windows nt 5.1/i'     =>  'Windows XP',
                            '/windows xp/i'         =>  'Windows XP',
                            '/windows nt 5.0/i'     =>  'Windows 2000',
                            '/windows me/i'         =>  'Windows ME',
                            '/win98/i'              =>  'Windows 98',
                            '/win95/i'              =>  'Windows 95',
                            '/win16/i'              =>  'Windows 3.11',
                            '/macintosh|mac os x/i' =>  'Mac OS X',
                            '/mac_powerpc/i'        =>  'Mac OS 9',
                            '/linux/i'              =>  'Linux',
                            '/ubuntu/i'             =>  'Ubuntu',
                            '/iphone/i'             =>  'iPhone',
                            '/ipod/i'               =>  'iPod',
                            '/ipad/i'               =>  'iPad',
                            '/android/i'            =>  'Android',
                            '/blackberry/i'         =>  'BlackBerry',
                            '/webos/i'              =>  'Mobile'
                        );

    foreach ($os_array as $regex => $value) { 
        if (preg_match($regex, $user_agent)) {
            $os_platform    =   $value;
        }
    }   
    return $os_platform;
}

function getBrowser($user_agent) {
    $browser        =   "Unknown Browser";
    $browser_array  =   array(
                            '/msie/i'       =>  'Internet Explorer',
                            '/firefox/i'    =>  'Firefox',
                            '/safari/i'     =>  'Safari',
                            '/chrome/i'     =>  'Chrome',
                            '/edge/i'       =>  'Edge',
                            '/opera/i'      =>  'Opera',
                            '/netscape/i'   =>  'Netscape',
                            '/maxthon/i'    =>  'Maxthon',
                            '/konqueror/i'  =>  'Konqueror',
                            '/mobile/i'     =>  'Handheld Browser'
                        );
foreach ($browser_array as $regex => $value) { 
        if (preg_match($regex, $user_agent)) {
            $browser    =   $value;
        }
    }
   return $browser;
}	

function buatLink($tipe,$no,$judul){
	if($tipe=='Berita'){$tipe='Kegiatan';}
	$alt=$judul;
	$tipe = str_replace(' ', '-',$tipe);
	$judul = preg_replace('~[^a-zA-Z0-9\s]+~', '', $judul);	
	$judul = str_replace(' ', '-',$judul);	
	$link=PATH.$tipe.'/'.$no.'/'.$judul.'" title="'.$alt.'" alt="'.$alt;
	return($link);
}	
function buatLinkMeta($tipe,$no,$judul){
	$alt=$judul;
	if($tipe=='Berita'){$tipe='Kegiatan';}	
	$judul = preg_replace('~[^a-zA-Z0-9\s]+~', '', $judul);	
	$judul = str_replace(' ', '-',$judul);	
	$link=$tipe.'/'.$no.'/'.$judul.'';
	return($link);
}	
function ambilNarasi($p,$x){
	if (strlen($p)<=$x) {
		return($p);
		}else{
	$s=substr($p,$x,1);
		if(ctype_space($s)){
		$n=substr($p,0,$x);
		return($n);
		}else{
		$x++;
		return(ambilNarasi($p,$x));
		}
	}
}

	function countView($posID){	
	global $conn;
		if(isset($posID)){		
			$stmt = $conn->prepare("UPDATE tbl_post SET
									post_counter=post_counter+1
									WHERE post_ID=:ID
									"); 
			$data = array(
						':ID'=>$posID
						);
							
		if ($stmt->execute($data)) { 
			return TRUE;
			}else{
			return FALSE;
			}		
		}else{ return FALSE; }			
	}

	
	function aInj($data){
		$filter = stripslashes(strip_tags(htmlspecialchars($data,ENT_QUOTES)));
		$filter = str_replace("'","\'",$filter);
		return $filter;
	}

	function MySQLToMoney($val, $precision = 0, $task = 'print', $zero = 0) {
		if ($val == 0) {
			return $zero;
		} else {
			if (substr($task,0,7) == 'preview' || substr($task,0,5) == 'print') {
				if ($precision >= 0) {
					return number_format($val, $precision, ',', '.');
				} else {
					$val = floatval($val);
					$val2 = explode('.',$val);
					
					if (count($val2) > 1) {
						return number_format($val, strlen($val2[1]), ',', '.');
					} else {
						return $val;
					}
				}
			} else {
				//ekspor
				//NOTE: pada server inggris cukup return $val, sementara pada server indonesia, sbb:
				//      formatnya dilakukan di excel via style, jadi angka tetap bisa dihitung di excel
				if ($precision > 0) {
					return $val;
				} else {
					$val2 = explode('.',$val);
					
					return $val2[0];
				}
			}
		}
	}	
		
	
?>