<?
/*function sql_connect($dbhost,$dbuser,$dbpass)
{
	$conn = mysqli_connect($dbhost,$dbuser,$dbpass);
	return $conn;
}*/
function sqlconnect($dbhost,$dbuser,$dbpass,$dbname)
{
	$conn = mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
	return $conn;
}
function sql_select_db($dbname)
{
	$res = mysqli_select_db($dbname);
	return $res;
}
function sql($sql)
{
	global $connect;
	$res = mysqli_query($connect,$sql);
	
	return $res;
}
function sql_query($sql)
{
	global $connect;
	$res = mysqli_query($connect,$sql);
	
	return $res;
}
function sql_fetch_array($res)
{
	$data = mysqli_fetch_array($res);
	return $data;
}
function sql_result($res,$arr,$field)
{
	//$data = mysqli_result($res,$arr,$field);
	$row 	= sql_fetch_array($res);
	$data 	= $row[0];
	return $data;
}
function sql_fetch_data($res)
{
	$data = mysqli_fetch_assoc($res);
	return $data;
}
function sql_fetch_assoc($res)
{
	$data = mysqli_fetch_assoc($res);
	return $data;
}
function sql_fetch_object($res)
{
	$data = mysqli_fetch_object($res);
	return $data;
}
function sql_num_rows($res)
{
	$data = mysqli_num_rows($res);
	return $data;
}
function sql_free_result($res)
{
	mysqli_free_result($res);
}
function rupiah($val)
{
	$num = number_format($val,0,'','.');
	return $num;
}

function rupiahorno($vkondisi, $vkondisi2, $val)
{
	if($vkondisi==$vkondisi2) $num = $val;
	else $num = number_format($val,0,'','.');
	return $num;
}

function rupiahdesimal($nominal)
{
	return number_format($nominal,2,",",".") ;
}

function kodeotolama($filename)
{
	global $database;
	
	$filename = str_replace(" ","",$filename);
	$filename = str_replace("index.php?kanal=","",$filename);
	
	$perintah 	= "select kode from tbl_childmenu where url='$filename'";
	$hasil 		= sql_query($perintah);
	$data		= sql_fetch_assoc($hasil);
	$kode 		= $data['kode'];
	sql_free_result($hasil);	
	
	if(empty($kode)) $kode = "---";
	
	return $kode;
}

function kodeoto($filename)
{
	global $otoritas_grup,$cmod_grupuserid;
	
	$filename = str_replace(" ","",$filename);
	$filename = str_replace("index.php?kanal=","",$filename);

	$cmod_gid = $_SESSION['cmod_grupid'];//$_SESSION['cmod_grupuserid'];
	
	if($cmod_gid != 1)
	{
		$ar = array("oto"=>1);
		
		$sqloto	= sql("SELECT kode FROM `tbl_otoritas` WHERE status='1'");
		while($rowoto = sql_fetch_data($sqloto))
		{
			$ars	=  array($rowoto['kode']=>1);
			$ar		=  array_merge((array)$ar, (array)$ars);
		}
		sql_free_result($sqloto);
	}
	else
	{
		$kodechild	= sql_get_var("select kode from tbl_menuchild where url='$filename' and status='1'");
		
		if(!empty($kodechild))
		{
			if(preg_match("/$kodechild/i",$otoritas_grup))
			{
				$ar	= array("oto"=>1);
				
				$expoto			= explode("$kodechild",$otoritas_grup);
				$expoto2		= explode("~",$expoto[1]);
				$otoritasnya	= $expoto2[0];
				
				$sqloto	= sql("SELECT kode FROM `tbl_otoritas` WHERE find_in_set(`otoritasid`,'$otoritasnya') and status='1'");
				while($rowoto = sql_fetch_data($sqloto))
				{
					$ars	=  array($rowoto['kode']=>1);
					$ar		=  array_merge((array)$ar, (array)$ars);
				}
				sql_free_result($sqloto);
			}
		}
	}
	
	$ar[0] = $ar;
	return $ar;
}

function idbaru($field,$tabel)
{
	$sql	= "select max($field) as idbaru from $tabel";
	$query	= sql_query($sql);
	$idbaru	= sql_result($query,0,idbaru) + 1;
	
	return $idbaru;
}

function sql_get_var($query)
{
	$res = sql_query($query);
	$row = sql_fetch_array($res);
	$rec = $row[0];
	
	return $rec;
	sql_free_result($res);
}

function sql_get_var_row($query)
{
	$res = sql_query($query);
	$row = sql_fetch_assoc($res);

	return $row;
	sql_free_result($res);
}

function mainaction($acc,$param)
{
	global $aksi,$alamaturl,$topurl;

	for($i=0;$i<count($param);$i++)
	{
		$pars = $param[$i];
		$par = $pars[0]."='".$pars[1]."'";
		$par2 = urlencode($pars[0])."=".urlencode($pars[1]);
		$params .=" and $par ";
		$urlparams .="&$par2";
	}
	
	if(preg_match("/tambah/i",$aksi))
		$judulnya	= "Tambah Data";
	elseif(preg_match("/edit/i",$aksi))
		$judulnya	= "Edit Data";
	else
		$judulnya	= "Lihat Data";
	
	echo '
	<div class="heading-layout1">
		<div class="item-title">
			<h3>'.$judulnya.'</h3>
		</div>
		<div class="dropdown">
			<a class="dropdown-toggle" href="#" role="button" data-toggle="dropdown" aria-expanded="false">...</a>

			<div class="dropdown-menu dropdown-menu-right">
	';
			for($i=0;$i<count($acc);$i++)
			{
				$url 	= $acc[$i][2];
				$icon 	= $acc[$i][1];
				$str 	= $acc[$i][0];
		
				if($icon=="lihat") 
					$iconnya = "book-open";
				if($icon=="tambah") 
					$iconnya = "plus-circle";
				if($icon=="cetak") 
					$iconnya = "print";
				if($icon=="kembali") 
					$iconnya = "arrow-alt-circle-left";
				if($icon=="search") 
					$iconnya = "search";
				
				echo '
				<div class="col-lg-2 col-12">
					<a class="dropdown-item" href="'.$url.$urlparams.'"><i class="fas fa-'.$iconnya.' text-orange-peel"></i> '.$str.'</a>
				</div>
				';
			}
	echo '
			</div>
		</div>
	</div>
	';
	
	echo '
	<div class="row gutters-2 mg-b-20">
	';
	for($i=0;$i<count($acc);$i++)
	{
		$url 	= $acc[$i][2];
		$icon 	= $acc[$i][1];
		$str 	= $acc[$i][0];

		if($icon=="lihat") 
			$iconnya = "book-open";
		if($icon=="tambah") 
			$iconnya = "plus-circle";
		if($icon=="cetak") 
			$iconnya = "print";
		if($icon=="kembali") 
			$iconnya = "arrow-alt-circle-left";
		if($icon=="search") 
			$iconnya = "search";
		
		echo '
		<div class="col-lg-2 col-12">
			<a href="'.$url.$urlparams.'"><button class="fw-btn-fill bg-blue-dark"><i class="fas fa-'.$iconnya.' text-orange-peel"></i> '.$str.'</button></a>
		</div>
		';
		
		//echo"<a class=\"btn\" href=\"$url$urlparams\" $del><img src=\"./template/images/icons/$icon.png\"/>&nbsp;&nbsp;$str</a>";
	}
	echo '</div>';
}

function formsearch($cari,$parameter)
{
	global $alamaturl;

	$param = "";
	for($i=0;$i<count($parameter);$i++)
	{
		$pars 	= $parameter[$i];
		$par 	= $pars[0]."='".$pars[1]."'";
		$par2 	= urlencode($pars[0])."=".urlencode($pars[1]);
		$params .=" and $par ";
		$param 	.="&$par2";
	}

	$jml 	= count($cari);
	$sisa 	= $jml%2;
	
	if($sisa == "1") 
		$jml	= $jml;//+1
	else 
		$jml	= $jml;
	?>
	<script type="text/javascript">	
	$(document).ready(function() 
	{
		$("#formdata").validationEngine();
	});
	
	function showhide(data)
	{
		if(data == 1)
		{
			$("#viewfilter").show("fast");
			$("#btnhide").show("fast");
			$("#btnshow").hide();
		}
		else
		{
			$("#btnshow").show("fast");
			$("#btnhide").hide();
			$("#viewfilter").hide();
		}
	}
	</script>
	<div class="col-lg-12 col-12">
		<button class="fal fa-pull-right" onclick="showhide(0);" id="btnhide"><i class="fas fa-angle-down text-orange-peel"></i></button>
		<button class="fal fa-pull-right" onclick="showhide(1);" id="btnshow" style="display:none;"><i class="fas fa-angle-up text-orange-peel"></i></button>
	</div>
	<?
	echo "
		<form action=\"\" method=\"post\" class=\"mg-b-20\">
		<div class=\"row gutters-8\" id=\"viewfilter\">
	";
	
	$where = "";
	for($i=0; $i<$jml; $i++)
	{
		$data 	= $cari[$i];
		$field 	= $cari[$i][0];
		
		if(empty($field))
			echo "&nbsp;";
		else
		{
			if(isset($_POST[$field]))
				$in = $_POST[$field];
			else
			{
				$in = $_GET[$field];
				if(preg_match("/\|/i",$in)){$in = explode("|",$in);}
			}
		}
		
		if(is_array($in))
		{
			if(!array_filter($in) == false)
			{
				if(empty($in[0])){ $in[0] = $in[1]; }
				if(empty($in[1])){ $in[1] = $in[0]; }
				$in2 	= urlencode($in[0])."|".urlencode($in[1]);
				$param .= "&$data[0]=".$in2;
			
				if($data[3]=="daterange")
				{
					$where .= " and ($data[0] >= '".insert_tanggal($in[0])."' and $data[0] <= '".insert_tanggal($in[1])."')";
					//$where .= " and ($data[0] >= '$in[0]' and $data[0] <= '$in[1]')";
				}
				elseif($data[3]=="multiple")
				{
					$list_in	= array();
					$list_ins	= array();
					foreach($in as $in_d)
					{
						$list_in[]	= $in_d;
						$list_ins[]	= "~".$in_d."~";
					}
					$in		= implode(",",$list_in);
					$ins	= implode(",",$list_ins);
					$where 	.= " and find_in_set(`$data[0]`,'$in')";
				}
			}
			else
			{
				$ins	= array();
				$list_in= array();
			}
		}
		elseif($in != "")
		{
			$param	.= "&$data[0]=".urlencode($in);
			
			if($data[2]=="str")
			{
				$where 	.= " and $data[0] like '%$in%'";
			}
			elseif(($data[2]=="date") and ($data[3]=="date"))
			{
				$where 	.= " and substring($data[0],1,10)='$in'";
			}
			elseif($data[3]=="in")
			{
				$where 	.= " and (find_in_set('$in',`$data[0]`) or `$data[0]`='all')";
			}
			else
			{
				$where	.= " and $data[0]='$in'";
			}
		}
		
		//echo "<div class=\"col-lg-4 col-12 form-group\">";
		if($data[2]=="date")
		{
			echo "<div class=\"col-lg-4 col-12 form-group\">";
			echo "<label>$data[1] :</label>";
			echo "<input type=\"text\" class=\"form-control air-datepicker\" value=\"$in\" name=\"$data[0]\" id=\"$data[0]\" placeholder=\"$data[1] (dd/mm/yyyy)\" />";
			echo "</div>";
		}
		elseif($data[2]=="daterange")
		{
			$dtt = $data[0];
			$dts = $dtt."[]";
			
			echo "<div class=\"col-lg-4 col-12 form-group\">";
			echo "<label>$data[1] :</label>";
			echo "<input type=\"text\" class=\"form-control air-datepicker\" value=\"$in[0]\" name=\"$dts\" id=\"tanggal1\" class=\"date1\" placeholder=\"$data[1] Awal (dd/mm/yyyy)\" />";
			echo "</div>";
			echo "<div class=\"col-lg-4 col-12 form-group\">";
			echo "<label>&nbsp;</label>";
			echo "<input type=\"text\" class=\"form-control air-datepicker\" value=\"$in[1]\" name=\"$dts\" id=\"tanggal2\" class=\"date2\" placeholder=\"$data[1] Akhir (dd/mm/yyyy)\" />";
			echo "</div>";
		}
		elseif($data[2]=="select2")
		{
			$opsi = $cari[$i][4];
			echo "<div class=\"col-lg-4 col-12 form-group\">";
			echo "<label>$data[1] :</label>";
			echo "<select name=\"$data[0]\" id=\"$data[0]\" class=\"select2\" />";
			//echo "<option value=\"\"> - $data[1] -</option>";
			echo "<option value=\"\"> - All -</option>";
			for($o=0;$o<count($opsi);$o++)
			{
				if($in==$opsi[$o][0])
					echo "<option value=\"".$opsi[$o][0]."\" selected=selected>".$opsi[$o][1]."</option>";
				 else
				 	echo "<option value=\"".$opsi[$o][0]."\">".$opsi[$o][1]."</option>";
			}
			echo "</select>";
			echo "</div>";
			unset($opsi);
		}
		elseif($data[2]=="multiple")
		{
			$opsi = $cari[$i][4];
			echo "<div class=\"col-lg-4 col-12 form-group\">";
			echo "<label>$data[1] :</label>";
			echo "<select name=\"$data[0][]\" id=\"$data[0][]\" class=\"select2\" multiple=\"multiple\" />";
			if(!preg_match("/,/i",$in)) echo "<option value=\"\" selected=selected> - Lihat Semua -</option>";
			for($o=0;$o<count($opsi);$o++)
			{
				//$smultiple	= "~".$opsi[$o][0]."~";
				//if($in==$opsi[$o][0])
				//if(preg_match("/$smultiple/i",$in))
				//if(preg_match("/$smultiple/i",$ins))
				$smultiple	= $opsi[$o][0];
				if(in_array($smultiple,$list_in))
					echo "<option value=\"".$opsi[$o][0]."\" selected=selected>".$opsi[$o][1]."</option>";
				else
				 	echo "<option value=\"".$opsi[$o][0]."\">".$opsi[$o][1]."</option>";
			}
			echo "</select>";
			echo "</div>";
			unset($opsi);
		}
		else
		{
			if($data[2]=="baris")
			{
				echo '<br clear="all"/><br clear="all"/>';
			}
			else
			{
				echo "<div class=\"col-lg-4 col-12 form-group\">";
				echo "<label>$data[1] :</label>";
				echo "<input type=\"text\" class=\"form-control\" value=\"$in\" name=\"$data[0]\" id=\"$data[0]\" placeholder=\"$data[1] ...\" />";
				echo "</div>";
			}
		}
		//echo "</div>";
	}
	echo "
	<div class=\"col-lg-10 col-12 form-group\">&nbsp;</div>
	<div class=\"col-lg-2 col-12 form-group\">
		<button type=\"submit\" class=\"fw-btn-fill btn-gradient-yellow\">SEARCH</button>
	</div>
	";
	echo "</div></form><br clear=\"all\" />";

	$where .= $params;

	$dt[] = array("where"=>$where,"param"=>$param);
	return $dt;
}

function paging($tot,$hlm_tot,$jml_per_hlm,$param)
{
	global $hlm,$alamaturl,$aksi,$popup;

	if(empty($hlm))
		$hlm = 1;

	$alamats 		= $alamaturl."&aksi=$aksi".$param;
	$hlm 			= intval($hlm);
	$tot 			= intval($tot);
	$jml_per_hlm 	= intval($jml_per_hlm);
	$hlm_tot 		= intval($hlm_tot);

	if($hlm == 1 and $tot == 0)
		$datake = 0;
	else
	 	$datake = $jml_per_hlm * ($hlm - 1) + 1;

	$datasampai = ($jml_per_hlm * ($hlm - 1)) + $jml_per_hlm;

	if($popup)
	{
		if($tot < $datasampai and $tot > $jml_per_hlm)
		{
			$datasampai	= $tot;
			$dt 		= "Hal <strong>$hlm</strong> /<strong> $hlm_tot</strong> hal | Total $tot</strong> data";
		}
		elseif($tot < $jml_per_hlm)
		{
			 $datasampai = $tot;
			 $dt		 = "Hal <strong>$hlm</strong> /<strong> $hlm_tot</strong> hal | Total<strong> $tot</strong> data";
		}
		elseif($tot == 0)
		{
			$dt = "Data <strong>tidak ditemukan</strong>";
		}
		else
		{
			$dt = "Hal <strong>$hlm</strong> /<strong> $hlm_tot</strong> hal| Total<strong> $tot</strong> data";
		}
	}
	else
	{
		if($tot < $datasampai and $tot > $jml_per_hlm and $tot != 0)
		{
			$datasampai	= $tot;
			$dt 		= "Halaman <strong>$hlm</strong> dari<strong> $hlm_tot</strong> halaman | Data ke <strong>$datasampai</strong> dari total $tot</strong> data";
		}
		elseif($tot<$jml_per_hlm  and $tot!=0)
		{
			$datasampai = $tot;
			$dt			= "Halaman <strong>$hlm</strong> dari<strong> $hlm_tot</strong> halaman | Data ke <strong>$datake - $datasampai</strong> dari total<strong> $tot</strong> data";
		}
		elseif($tot == 0)
		{
			$dt	= "Data kosong atau tidak tersedia";
		}
		else
		{
			$dt = "Halaman <strong>$hlm</strong> dari<strong> $hlm_tot</strong> halaman | Data ke <strong>$datake - $datasampai</strong> dari total<strong> $tot</strong> data";
		}
	}
	
	if($popup)
	{
		$popup = "&popup=1";
	}
	
	echo '<div class="dataTables_paginate paging_simple_numbers">';
	$batas_page = 10;
	if($hlm_tot > 1)
	{
		if($hlm > 1)
		{
			$prev = $hlm - 1;
			print("<a href=\"$alamats$popup&hlm=$prev\" class=\"paginate_button previous\">Prev</a>");
		}
		else
		{
			print("<a class=\"paginate_button previous disabled\">Prev</a> ");
		}

		$hlm2 	= $hlm - (ceil($batas_page / 2));
		$hlm4	= $hlm + (ceil($batas_page / 2));

		if($hlm2 <= 0) 
			$hlm3 = 1;
		else 
			$hlm3 = $hlm2;

		//if($hlm_tot == 1)
			//echo"<span>&nbsp;</span>";
		echo"<span>";
		for($ii=$hlm3; $ii<=$hlm_tot and $ii<=$hlm4; $ii++)
		{
			if($ii == $hlm)
			{
				print("<a class=\"paginate_button current\">$ii</a>");
			}
			else
			{
				print("<a href=\"$alamats$popup&hlm=$ii\" class=\"paginate_button\">$ii</a>");
			}
		}
		echo"</span>";
		//if($hlm_tot == 1) 
			//echo"<span>&nbsp;</span>";
			
		if ($hlm < $hlm_tot)
		{
			$next = $hlm + 1;
			print("<a href=\"$alamats$popup&hlm=$next\" class=\"paginate_button next\">Next</a>");
		}
		else
		{
			print("<a class=\"paginate_button next disabled\">Next</a>");
		}
	}
	echo "</div>";
}

function tanggalLahir($tanggal)
{
	$tahun 	= substr("$tanggal",0,4); 
	$bulan 	= substr("$tanggal", 5, 2); 
	$tgl 	= substr("$tanggal", 8, 2);
	
	if ($bulan=="01"){ $bulan1="January"; }
	if ($bulan=="02"){ $bulan1="February"; }
	if ($bulan=="03"){ $bulan1="March"; }
	if ($bulan=="04"){ $bulan1="April"; }
	if ($bulan=="05"){ $bulan1="May"; }
	if ($bulan=="06"){ $bulan1="June"; }
	if ($bulan=="07"){ $bulan1="July"; }
	if ($bulan=="08"){ $bulan1="August"; }
	if ($bulan=="09"){ $bulan1="September"; }
	if ($bulan=="10"){ $bulan1="October"; }
	if ($bulan=="11"){ $bulan1="November"; }
	if ($bulan=="12"){ $bulan1="December"; }
	
	$tgl	= " $tgl $bulan1 $tahun";			
	return $tgl;
}	

function tanggal($tanggal)
{
	$tahun 	= substr("$tanggal",0,4); 
	$bulan 	= substr("$tanggal", 5, 2); 
	$tgl 	= substr("$tanggal", 8, 2); 
	$jam 	= substr("$tanggal", 11, 2); 
	$mnt 	= substr("$tanggal", 14, 2); 
	
	if ($bulan=="01"){ $bulan1="Januari"; }
	if ($bulan=="02"){ $bulan1="Februari"; }
	if ($bulan=="03"){ $bulan1="Maret"; }
	if ($bulan=="04"){ $bulan1="April"; }
	if ($bulan=="05"){ $bulan1="Mei"; }
	if ($bulan=="06"){ $bulan1="Juni"; }
	if ($bulan=="07"){ $bulan1="Juli"; }
	if ($bulan=="08"){ $bulan1="Agustus"; }
	if ($bulan=="09"){ $bulan1="September"; }
	if ($bulan=="10"){ $bulan1="Oktober"; }
	if ($bulan=="11"){ $bulan1="November"; }
	if ($bulan=="12"){$bulan1="Desember"; }
	
	$time = mktime(0,0,0,$bulan,$tgl,$tahun);
	$hari = getdate($time);
	$array_hari = array("Monday" => "Senin", "Tuesday" => "Selasa", "Wednesday" => "Rabu", "Thursday" => "Kamis",
						"Friday" => "Jum'at", "Saturday" => "Sabtu", "Sunday" => "Minggu");
	$hari = $array_hari[$hari[weekday]];
	
	$tgl="$hari, $tgl $bulan1 $tahun $jam:$mnt WIB ";
	
	return $tgl;
	
}
function tglblnthn($tanggal)
{
	$tahun 	= substr("$tanggal",0,4); 
	$bulan 	= substr("$tanggal", 5, 2); 
	$tgl 	= substr("$tanggal", 8, 2); 
	
	if ($bulan=="01"){ $bulan1="Januari"; }
	if ($bulan=="02"){ $bulan1="Februari"; }
	if ($bulan=="03"){ $bulan1="Maret"; }
	if ($bulan=="04"){ $bulan1="April"; }
	if ($bulan=="05"){ $bulan1="Mei"; }
	if ($bulan=="06"){ $bulan1="Juni"; }
	if ($bulan=="07"){ $bulan1="Juli"; }
	if ($bulan=="08"){ $bulan1="Agustus"; }
	if ($bulan=="09"){ $bulan1="September"; }
	if ($bulan=="10"){ $bulan1="Oktober"; }
	if ($bulan=="11"){ $bulan1="November"; }
	if ($bulan=="12"){$bulan1="Desember"; }
	
	$tgl	= "$tgl $bulan1 $tahun ";			
	return $tgl;
}

function namabulan($bulan)
{
	if ($bulan=="01"){ $bulan1="Januari"; }
	if ($bulan=="02"){ $bulan1="Februari"; }
	if ($bulan=="03"){ $bulan1="Maret"; }
	if ($bulan=="04"){ $bulan1="April"; }
	if ($bulan=="05"){ $bulan1="Mei"; }
	if ($bulan=="06"){ $bulan1="Juni"; }
	if ($bulan=="07"){ $bulan1="Juli"; }
	if ($bulan=="08"){ $bulan1="Agustus"; }
	if ($bulan=="09"){ $bulan1="September"; }
	if ($bulan=="10"){ $bulan1="Oktober"; }
	if ($bulan=="11"){ $bulan1="November"; }
	if ($bulan=="12"){ $bulan1="Desember"; }
			
	return $bulan1;
}

function getbulan($bulan)
{
	if ($bulan=="01"){ $bulan1="Januari"; }
	if ($bulan=="02"){ $bulan1="Februari"; }
	if ($bulan=="03"){ $bulan1="Maret"; }
	if ($bulan=="04"){ $bulan1="April"; }
	if ($bulan=="05"){ $bulan1="Mei"; }
	if ($bulan=="06"){ $bulan1="Juni"; }
	if ($bulan=="07"){ $bulan1="Juli"; }
	if ($bulan=="08"){ $bulan1="Agustus"; }
	if ($bulan=="09"){ $bulan1="September"; }
	if ($bulan=="10"){ $bulan1="Oktober"; }
	if ($bulan=="11"){ $bulan1="November"; }
	if ($bulan=="12"){ $bulan1="Desember"; }

	return $bulan1;
}

function tanggalhariini($tanggal)
{
	$tahun 	= substr("$tanggal",0,4); 
	$bulan 	= substr("$tanggal", 5, 2); 
	$tgl 	= substr("$tanggal", 8, 2); 
	$jam 	= substr("$tanggal", 11, 2); 
	$mnt 	= substr("$tanggal", 14, 2); 
	if ($bulan=="01"){ $bulan1="Januari"; }
	if ($bulan=="02"){ $bulan1="Februari"; }
	if ($bulan=="03"){ $bulan1="Maret"; }
	if ($bulan=="04"){ $bulan1="April"; }
	if ($bulan=="05"){ $bulan1="Mei"; }
	if ($bulan=="06"){ $bulan1="Juni"; }
	if ($bulan=="07"){ $bulan1="Juli"; }
	if ($bulan=="08"){ $bulan1="Agustus"; }
	if ($bulan=="09"){ $bulan1="September"; }
	if ($bulan=="10"){ $bulan1="Oktober"; }
	if ($bulan=="11"){ $bulan1="November"; }
	if ($bulan=="12"){$bulan1="Desember"; }
	
	$time = mktime(0,0,0,$bulan,$tgl,$tahun);
	$hari = getdate($time);
	$array_hari = array("Monday" => "Senin", "Tuesday" => "Selasa", "Wednesday" => "Rabu", "Thursday" => "Kamis",
						"Friday" => "Jum'at", "Saturday" => "Sabtu", "Sunday" => "Minggu");
	$hari 	= $array_hari[$hari[weekday]];
	$tgl	= "$hari, $tgl $bulan1 $tahun";			
	return $tgl;
}

function tanggalbulantahun($tanggal)
{
	$tahun 	= substr("$tanggal",0,4); 
	$bulan 	= substr("$tanggal", 5, 2); 
	$tgl 	= substr("$tanggal", 8, 2);
	
	$tgl="$tgl-$bulan-$tahun";			
	return $tgl;
}

function bulantahun($tanggal)
{
	$tahun 	= substr("$tanggal",0,4); 
	$bulan 	= substr("$tanggal", 5, 2); 
	$tgl 	= substr("$tanggal", 8, 2);
	
	if ($bulan=="01"){ $bulan1="Januari"; }
	if ($bulan=="02"){ $bulan1="Februari"; }
	if ($bulan=="03"){ $bulan1="Maret"; }
	if ($bulan=="04"){ $bulan1="April"; }
	if ($bulan=="05"){ $bulan1="Mei"; }
	if ($bulan=="06"){ $bulan1="Juni"; }
	if ($bulan=="07"){ $bulan1="Juli"; }
	if ($bulan=="08"){ $bulan1="Agustus"; }
	if ($bulan=="09"){ $bulan1="September"; }
	if ($bulan=="10"){ $bulan1="Oktober"; }
	if ($bulan=="11"){ $bulan1="November"; }
	if ($bulan=="12"){ $bulan1="Desember"; }
	
	$tgl	= "$bulan1 $tahun";			
	return $tgl;
}

function tahun($tanggal)
{
	$tahun 	= substr("$tanggal",0,4);
	return $tahun;
}

function insert_tanggal($tanggal)
{
	$expt	= explode("/",$tanggal);
	$tgl	= $expt[2]."-".$expt[1]."-".$expt[0];
	
	return $tgl;
}

function form_tanggal($tanggal)
{
	$expt	= explode("-",$tanggal);
	$tgl	= $expt[2]."/".$expt[1]."/".$expt[0];
	
	return $tgl;
}

function generateCode($characters) 
{
	$possible = '23456789bcdfghjknpqrstvwxyz';
	$code = '';
	$i = 0;
	while ($i < $characters) 
	{ 
		 $code .= substr($possible, mt_rand(0, strlen($possible)-1), 1);
		 $i++;
	}
	return $code;
}

function file_size($file)
{
      $filesize = round((((int)$file)/1024)/1024,2);
      if($filesize >= 1) $filesize = $filesize." MB";
      else $filesize = round((int)$file/1024,0)."KB";
      return $filesize;
}

function strrand($length) 
{
	$str = "";
	while(strlen($str)<$length)
	{
		$random	= rand(42,122);
		if (ereg('[A-Z0-9]',chr($random)))
			$str.=chr($random);
	}
	return $str;
}

function getaliasbaru($string)
{
	// remove any '-' from the string since they will be used as concatenaters
	$str = str_replace('-', ' ', $string);

	// Trim white spaces at beginning and end of alias and make lowercase
	$str = trim(strtolower($str));

	// Remove any duplicate whitespace, and ensure all characters are alphanumeric
	$str = preg_replace('/(\s|[^A-Za-z0-9\-])+/', '-', $str);

	// Trim dashes at beginning and end of alias
	$str = trim($str, '-');

	return $str;
}

function getAlias($judul)
{
	$judul = strtolower($judul);
	$judul = str_replace(" ","-",$judul);
	$judul = str_replace("'","",$judul);
	$search = array ("'<script[^>]*?>.*?</script>'si","'<[\/\!]*?[^<>]*?>'si","'([\r\n])[\s]+'","'&(quot|#34);'i","'&(amp|#38);'i","'&(lt|#60);'i","'&(gt|#62);'i","'&(nbsp|#160);'i","'&(iexcl|#161);'i","'&(cent|#162);'i","'&(pound|#163);'i","'&(copy|#169);'i","'&#(\d+);'e");                    // evaluate as php
	$replace = array ("","","","","","","","","","","","","");
	$judul = preg_replace($search, $replace, $judul);
	$judul = str_replace(".","",$judul);
	$judul = str_replace(",","",$judul);
	$judul = str_replace("`","",$judul);
	$judul = str_replace("!","",$judul);
	$judul = str_replace("#","",$judul);
	$judul = str_replace("$","",$judul);
	$judul = str_replace("%","",$judul);
	$judul = str_replace("^","",$judul);
	$judul = str_replace("&","",$judul);
	$judul = str_replace("*","",$judul);
	$judul = str_replace("(","",$judul);
	$judul = str_replace(")","",$judul);
	$judul = str_replace("_","",$judul);
	$judul = str_replace("=","",$judul);
	$judul = str_replace("+","",$judul);
	$judul = str_replace("|","",$judul);
	$judul = str_replace("|","",$judul);
	$judul = str_replace("/","",$judul);
	$judul = str_replace("{","",$judul);
	$judul = str_replace("}","",$judul);
	$judul = str_replace("[","",$judul);
	$judul = str_replace("]","",$judul);
	$judul = str_replace("?","",$judul);
	$judul = str_replace("/","",$judul);
	$judul = str_replace("~","",$judul);
	$judul = str_replace("\"","",$judul);
	
	$judul = substr("$judul", 0,200);
	
	return $judul;
}

function resizeimg($src,$dst,$maxwidth,$maxheight)
{
	global $oleh,$domain;
	$ext = substr($dst,-3,3);
		
	if(($ext=="jpg") || ($ext=="peg"))
	{
		$src_img = imagecreatefromjpeg($src); 
		$lebar_awal = imagesx($src_img); 
		$tinggi_awal = imagesy($src_img);
		$new_w=$maxwidth;
		$new_h = ($new_w/$lebar_awal)*$tinggi_awal; 
		$dst_img = imagecreatetruecolor($new_w,$new_h); 
		imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img)); 
		imagejpeg($dst_img, $dst,100); 
		$benar = true;
	}
	else if(($ext=="gif"))
	{
		$src_img = imagecreatefromgif($src); 
		$lebar_awal = imagesx($src_img); 
		$tinggi_awal = imagesy($src_img);
		$new_w=$maxwidth;
		$new_h = ($new_w/$lebar_awal)*$tinggi_awal; 
		$dst_img = imagecreatetruecolor($new_w,$new_h); 
		imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img)); 
		imagegif($dst_img, $dst,100); 
		$benar = true;
	}
	else if(($ext=="png"))
	{
		$src_img = imagecreatefrompng($src); 
		$lebar_awal = imagesx($src_img); 
		$tinggi_awal = imagesy($src_img);
		$new_w=$maxwidth;
		$new_h = ($new_w/$lebar_awal)*$tinggi_awal; 
		$dst_img = imagecreatetruecolor($new_w,$new_h); 
		imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img)); 
		imagepng($dst_img, $dst,100); 
		$benar = true;
	}
	return $benar;
}

function resizeimgclean($src,$dst,$maxwidth,$maxheight)
{
	global $oleh,$domain;
	$ext = substr($dst,-3,3);
		
	if(($ext=="jpg") || ($ext=="peg"))
	{
		$src_img = imagecreatefromjpeg($src); 
		$lebar_awal = imagesx($src_img); 
		$tinggi_awal = imagesy($src_img);
		$new_w=$maxwidth;
		$new_h = ($new_w/$lebar_awal)*$tinggi_awal; 
		$dst_img = imagecreatetruecolor($new_w,$new_h); 
		imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img)); 
		imagejpeg($dst_img, $dst,100); 
		$benar = true;
	}
	else if(($ext=="gif"))
	{
		$src_img = imagecreatefromgif($src); 
		$lebar_awal = imagesx($src_img); 
		$tinggi_awal = imagesy($src_img);
		$new_w=$maxwidth;
		$new_h = ($new_w/$lebar_awal)*$tinggi_awal; 
		$dst_img = imagecreatetruecolor($new_w,$new_h); 
		imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img)); 
		imagegif($dst_img, $dst,100); 
		$benar = true;
	}
	else if(($ext=="png"))
	{
		$src_img = imagecreatefrompng($src); 
		$lebar_awal = imagesx($src_img); 
		$tinggi_awal = imagesy($src_img);
		$new_w=$maxwidth;
		$new_h = ($new_w/$lebar_awal)*$tinggi_awal; 
		$dst_img = imagecreatetruecolor($new_w,$new_h); 
		imagecopyresized($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img)); 
		imagepng($dst_img, $dst,100); 
		$benar = true;
	}
	return $benar;
}

function sendmail($namapenerima,$emailpenerima,$subject,$isi,$isihtml)
{
	global $smtp_host,$smtp_name,$smtp_user,$smtp_pass;
	
	include('../librari/phpmailer/class.phpmailer.php');
		
	$mail = new PHPMailer();
	
	$mail->From 	= $smtp_user;
	$mail->FromName = $smtp_name;
	
	$mail->AddAddress($emailpenerima,$namapenerima);
	$mail->WordWrap = 500; 
	$mail->IsHTML(true); 
	$mail->Subject 	= $subject;
	$mail->Body 	= $isi; 
	$mail->AltBody 	= $isihtml; 
	$mail->IsSMTP();
	
	$mail->Host 	= $smtp_host;
	$mail->Port 	= 25; 
	$mail->Password = $smtp_pass;
	$mail->Username = $smtp_user;
	$mail->SMTPAuth	= "true";
	
	
	if(!$mail->Send())
	{
		return false;
	} 
	else
	{
		return true;
	} 
}

function encode($string)
{
    $key = sha1($key);
    $strLen = strlen($string);
    $keyLen = strlen($key);
    for ($i = 0; $i < $strLen; $i++) 
	{
        $ordStr = ord(substr($string,$i,1));
        if ($j == $keyLen) { $j = 0; }
        $ordKey = ord(substr($key,$j,1));
        $j++;
        $hash .= strrev(base_convert(dechex($ordStr + $ordKey),16,36));
    }
    return $hash;
}

function decode($string)
{
    $key = sha1($key);
    $strLen = strlen($string);
    $keyLen = strlen($key);
    for ($i = 0; $i < $strLen; $i+=2) {
        $ordStr = hexdec(base_convert(strrev(substr($string,$i,2)),36,16));
        if ($j == $keyLen) { $j = 0; }
        $ordKey = ord(substr($key,$j,1));
        $j++;
        $hash .= chr($ordStr - $ordKey);
    }
    return $hash;
}

function pesanalert($hasilpesan,$isipesan)
{
	if($hasilpesan == "error")
		$hasilpesan	= "danger";
		
	$pesanalert = "
	<div class=\"col-xl-12 col-lg-12 col-12\">
	<div class=\"alert alert-block alert-$hasilpesan\">
		<button data-dismiss=\"alert\" class=\"close\" type=\"button\">x</button>
		<p>$isipesan</p>
	</div></div>";
	
	return $pesanalert;
}

function cetak($width,$height,$resize,$scroll)
{
	$url = $_SERVER['REQUEST_URI'];
	
	if($scroll == "0") 
		$scroll = "No";
	else 
		$scroll = "yes";
		
	echo "<script type=\"text/javascript\">
			function cetak() 
			{
				window.open(\"$url&cetak=1\", \"Print\",\"status = 1, menubar=1, height = $height, width = $width, resizable=$resize,scrollbars=$scroll\")
			}
			</script>
			";
			
	echo "<input type=\"button\" class=\"btn\"  value=\"Print\" onclick=\"cetak();\" />";
}

function headprint($document)
{
	global $cetak;
	
	if($cetak)
	{
		$param 		= "select judul,note_head,note_foot,judul,signature,kop from tbl_document where kode='$document'";
		$hasil 		= sql_query($param);
		$data 		= sql_fetch_assoc($hasil);
		$judul 		= $data['judul'];
		$head 		= $data['note_head'];
		$foot 		= $data['note_foot'];
		$signature 	= $data['signature'];
		$kop 		= $data['kop'];
		sql_free_result($hasil);

		if($kop)
		{
			$param 		= "select nama,alamat,telp,fax,email,website,logo from tbl_company";
			$hasil 		= sql_query($param);
			$data 		= sql_fetch_assoc($hasil);
			$nama 		= $data['nama'];
			$alamat 	= $data['alamat'];
			$telp 		= $data['telp'];
			$fax 		= $data['fax'];
			$alamat 	= $data['alamat'];
			$email 		= $data['email'];
			$website 	= $data['website'];
			$logo 		= $data['logo'];
			sql_free_result($hasil);

			echo"<table width=\"100%\" style=\"border:none\">
			<tr><td align=\"center\"  style=\"border:none; border-bottom:3px solid #ccc; font-weight:normal; margin:0px 0px 10px 0px;\">
				<table width=\"100%\" style=\"border:none\">
				<tr>
				<td align=\"left\" valign=\"middle\"  style=\"border:none; font-weight:normal; line-height:18px !important; margin:0px 0px 10px 0px;\">
					<img src=\"./gambar/company/$logo\" class=\"logoprint\" style=\"height:80px; margin:0px 10px 10px 0px; border:none; float:left; \" />
					<span style=\"font-size:16px;\"><strong>$nama</strong></span><br />$alamat <br />Telp: $telp Fax: $fax <br />Email: $email Website: $website
				</td><tr>
				</table>
			</td><tr>
			</table>$head<br clear=\"all\" /><br clear=\"all\" />";
		}

		echo"<table width=\"100%\" style=\"border:none\">
			<tr><td align=\"center\"  style=\"border:none; font-size:16px !important; font-weight:bold; margin:0px 0px 10px 0px;\">$judul</td><tr>
			</table><br clear=\"all\" /><br clear=\"all\" />";
	}
}
function endprint($document,$guest,$date)
{
	global $cetak;

	if($cetak)
	{
		$param 		= "select judul,note_head,note_foot,judul,signature,documentid,tanggal from tbl_document where kode='$document'";
		$hasil 		= sql_query($param);
		$data 		= sql_fetch_assoc($hasil);
		$judul 		= $data['judul'];
		$documentid = $data['documentid'];
		$head 		= $data['note_head'];
		$foot 		= $data['note_foot'];
		$signature 	= $data['signature'];
		$tanggal 	= $data['tanggal'];
		sql_free_result($hasil);
		
		if($signature)
		{
			$param 	= "select nama,caption,tipenama from tbl_document_signature where documentid='$documentid' order by urutan asc";
			$hasil 	= sql_query($param);
			$jum 	= sql_num_rows($hasil);
			echo"<table style=\"border:none; width:auto; float:right;\"><tr>";
			$a = 1;
			while($data = sql_fetch_assoc($hasil))
			{
				$nm 		= $data['nama'];
				$caption 	= $data['caption'];
				$tipenama 	= $data['tipenama'];

				if($tipenama=="0") $nm = "&nbsp;";
				if($tipenama=="1") $nm = "$nm";
				if($tipenama=="2") $nm = $_SESSION['cmod_userfullname'];
				if($tipenama=="3") $nm = "$guest";

				if($tanggal=="1")
				{
					if($a==$jum)
					{
						$t 		= tanggal(date("Y-m-d H:i:s"));
						$tgl 	= "$t<br />";
					}
					else
					{
						$tgl = "<br />";
					}
				}

				$nm = ucwords($nm);

				if(empty($caption)) $caption = "&nbsp;";

				echo "
				<td style=\"width:150px; border:none; border-bottom:1px solid #333; margin:0px 10px 0px 10px; float:left; text-align:center;\">$tgl$caption <br clear=\"all\" /><br clear=\"all\" /><br clear=\"all\" /><strong>$nm</strong></td>";
				$a++;
			}
			$tglnow = date("Y-m-d H:i:s");
			echo"</tr>
			</table><br clear=\"all\" /><br clear=\"all\" />DICETAK OLEH : $_SESSION[cmod_userfullname] <br clear=\"all\" />TANGGAL-JAM : $tglnow ";
		}
		 
		 echo "<br clear=\"all\" /><br clear=\"all\" /><center><input type=\"button\" class=\"btn-print\"  value=\"Print\" onclick=\"window.print();\" /></center>";
	}
}

function terbilang_get_valid($str,$from,$to,$min=1,$max=9)
{
	$val	= false;
	$from	= ($from<0)?0:$from;
	for ($i=$from;$i<$to;$i++)
	{
		if (((int) $str{$i}>=$min)&&((int) $str{$i}<=$max)) $val=true;
	}
	return $val;
}

function terbilang_get_str($i,$str,$len)
{
	$numA	= array("","satu","dua","tiga","empat","lima","enam","tujuh","delapan","sembilan");
	$numB	= array("","se","dua ","tiga ","empat ","lima ","enam ","tujuh ","delapan ","sembilan ");
	$numC	= array("","satu ","dua ","tiga ","empat ","lima ","enam ","tujuh ","delapan ","sembilan ");
	$numD	= array(0=>"puluh",1=>"belas",2=>"ratus",4=>"ribu", 7=>"juta", 10=>"milyar", 13=>"triliun");
	$buf	= "";
	$pos	= $len-$i;
	switch($pos)
	{
		case 1:
				if (!terbilang_get_valid($str,$i-1,$i,1,1))
					$buf=$numA[(int) $str{$i}];
			break;
		case 2:	case 5: case 8: case 11: case 14:
				if ((int) $str{$i}==1)
				{
					if ((int) $str{$i+1}==0)
						$buf=($numB[(int) $str{$i}]).($numD[0]);
					else
						$buf=($numB[(int) $str{$i+1}]).($numD[1]);
				}
				else if ((int) $str{$i}>1)
				{
						$buf=($numB[(int) $str{$i}]).($numD[0]);
				}
			break;
		case 3: case 6: case 9: case 12: case 15:
				if ((int) $str{$i}>0)
				{
						$buf=($numB[(int) $str{$i}]).($numD[2]);
				}
			break;
		case 4: case 7: case 10: case 13:
				if (terbilang_get_valid($str,$i-2,$i))
				{
					if (!terbilang_get_valid($str,$i-1,$i,1,1))
						$buf=$numC[(int) $str{$i}].($numD[$pos]);
					else
						$buf=$numD[$pos];
				}
				else if((int) $str{$i}>0)
				{
					if ($pos==4)
						$buf=($numB[(int) $str{$i}]).($numD[$pos]);
					else
						$buf=($numC[(int) $str{$i}]).($numD[$pos]);
				}
			break;
	}
	return $buf;
}
function toTerbilang($nominal)
{
	$buf	= "";
	$str	= $nominal."";
	$len	= strlen($str);
	for($i=0; $i<$len; $i++)
	{
		$buf	= trim($buf)." ".terbilang_get_str($i,$str,$len);
	}
	return trim($buf);
}

function array_sort($array, $on, $order=SORT_ASC)
{
    $new_array 		= array();
    $sortable_array = array();

    if (count($array) > 0)
	{
        foreach ($array as $k => $v)
		{
            if (is_array($v))
			{
                foreach ($v as $k2 => $v2)
				{
                    if ($k2 == $on)
					{
                        $sortable_array[$k] = $v2;
                    }
                }
            }
			else
			{
                $sortable_array[$k] = $v;
            }
        }
        switch ($order)
		{
            case SORT_ASC:
                asort($sortable_array);
            break;
            case SORT_DESC:
                arsort($sortable_array);
            break;
        }

        foreach ($sortable_array as $k => $v)
		{
            $new_array[$k] = $array[$k];
        }
    }

    return $new_array;
}

function get_age($birthdayDate)
{
	$date     = new DateTime($birthdayDate);
	$now      = new DateTime();
	$interval = $now->diff($date);
	return $interval->y;
}

function aksidata($namaaksi,$urlaksi,$style)
{
	echo "<a href=\"$urlaksi\" class=\"button btn btn-primary bottom-margin pull-right\" style=\"color:#FFFFFF;margin-right:$style;\">$namaaksi</a>";
	/*echo "
		<button class=\"btn btn-primary bottom-margin pull-right\" type=\"button\" style=\"margin-right:$style;\">
		  <a href=\"$urlaksi\" class=\"button\" style=\"color:#FFFFFF;\">$namaaksi</a>
		</button>
	";*/
}

function upload_gambar($userfile,$pathimage,$folder,$nama_gambar,$id)
{
	if($userfile["size"] > 0)
	{
		$jenis1 		= $userfile["type"];
		$namafile		= strtolower($userfile["name"]);
		$ex				= explode(".",$namafile);
		$jfile			= count($ex) - 1;
		$jenis			= $ex[$jfile];	
		$imageinfo 		= getimagesize($userfile["tmp_name"]);
		$imagewidth 	= $imageinfo[0];
		$imageheight	= $imageinfo[1];
		$imagetype 		= $imageinfo[2];
		
		if(!empty($folder))
			$simpan_file	= $pathimage.$folder."/";
		else
			$simpan_file	= $pathimage;

		if(!file_exists($simpan_file))
		{	
			mkdir($simpan_file,0777); 
		}
		
		if( ($jenis == "jpg" or $jenis == "jpeg") or ($jenis == "gif") or ($jenis == "png") )
		{
			if(($imagewidth >= 500 or $imagewidth <= 500) and $imagewidth > 0)
			{
				if(!empty($id))
					$gambar	= "$nama_gambar-$id".".".$jenis;
				else
					$gambar	= "$nama_gambar".".".$jenis;

				if($jenis == "jpg" or $jenis == "jpeg")
					$src_img	= imagecreatefromjpeg($userfile["tmp_name"]);
				elseif($jenis == "gif")
					$src_img	= imagecreatefromgif($userfile["tmp_name"]);
				elseif($jenis == "png")
					$src_img	= imagecreatefrompng($userfile["tmp_name"]);

				$lebar_awal 	= imagesx($src_img);
				$tinggi_awal 	= imagesy($src_img);

				if($imagewidth >= 500)
					$new_w		= 500;
				else
					$new_w		= $lebar_awal;

				$new_h			= ($new_w / $lebar_awal) * $tinggi_awal;
				$dst_img 		= imagecreatetruecolor($new_w,$new_h);

				imagecopyresampled($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img));

				if($jenis == "jpg" or $jenis == "jpeg")
					imagejpeg($dst_img, "$simpan_file"."$gambar");
				elseif($jenis == "gif")
					imagegif($dst_img, "$simpan_file"."$gambar");
				elseif($jenis == "png")
					imagepng($dst_img, "$simpan_file"."$gambar");
			}
		}
	}
	else
	{
		$gambar	= "";
	}
	
	return $gambar;
}

function cleaninsert($text)
{
	global $connect;
	
	$text = str_replace("' OR ''='", "", $text);
	$text = str_replace("' or 1=1--", "", $text);
	$text = str_replace('" or 1=1�', "", $text);
	$text = str_replace('or 0=0 --', "", $text);
	$text = str_replace("' or 1=1 #", "", $text);
	$text = str_replace('" or 1=1 #', "", $text);
	$text = str_replace('or 0=0 #', "", $text);
	$text = str_replace("' or 'x' = 'x", "", $text);
	$text = str_replace('" or "x" = "x', "", $text);
	$text = str_replace("') or ('x' = 'x", "", $text);
	$text = str_replace("' or 1=1--", "", $text);
	$text = str_replace('" or 1=1--', "", $text);
	$text = str_replace('or 1=1--', "", $text);
	$text = str_replace('" or a=a--', "", $text);
	$text = mysqli_escape_string($connect,$text);
	// $text = str_replace("'", "&apos;", $text);
	$text = htmlspecialchars($text);
    return $text;
}

function setlog($grupuserid,$pesan,$uri,$ip,$date)
{
	global $database,$cmod_grupuserid;

	$perintah 	= "insert into tbl_log (create_grupuserid,create_date,pesan,uri,ip) values ('$grupuserid','$date','$pesan','$uri','$ip')";
	$hasil 		= sql($perintah);
}

function getfileext($src)
{
	$jenis 	= $src['name'];
	$exp	= explode(".",$jenis);
	$ext	= $exp[count($exp)-1];

	return $ext;
}

function cekhari($tanggal)
{
	$tahun 	= substr("$tanggal", 0,4);
	$bulan 	= substr("$tanggal", 5, 2);
	$tgl 	= substr("$tanggal", 8, 2);
	$time 	= mktime(0,0,0,$bulan,$tgl,$tahun);
	$hari 	= getdate($time);

	$array_hari = array("Monday" => "senin", "Tuesday" => "selasa", "Wednesday" => "rabu", "Thursday" => "kamis",
						"Friday" => "jumat", "Saturday" => "sabtu", "Sunday" => "minggu");
	$hari 		= strtolower($array_hari[$hari[weekday]]);
	
	return $hari;
}

function getRomawi($bln){
	switch ($bln){
			case 1: 
				return "I";
				break;
			case 2:
				return "II";
				break;
			case 3:
				return "III";
				break;
			case 4:
				return "IV";
				break;
			case 5:
				return "V";
				break;
			case 6:
				return "VI";
				break;
			case 7:
				return "VII";
				break;
			case 8:
				return "VIII";
				break;
			case 9:
				return "IX";
				break;
			case 10:
				return "X";
				break;
			case 11:
				return "XI";
				break;
			case 12:
				return "XII";
				break;
	  }
}

//Jurnal
function acc_sum_saldo_coa($date,$cuserid,$tgl,$coaid,$sum,$posting,$periodeakuntansiid)
{
	if((preg_match("/,/i",$sum)) and (preg_match("/./i",$sum)))
	{
		$sum	= str_replace(".","",cleaninsert($sum));
		$sum	= str_replace(",",".",cleaninsert($sum));
	}

	$sumsaldocoaid	= idbaru("sumsaldocoaid","tbl_acc_sum_saldo_coa");
	
	$tahun 	= substr("$tgl",0,4);
	$bulan 	= substr("$tgl",5,2);
	
	//get post default
	$post_default = sql_get_var("select post_default from tbl_acc_coa where coaid='$coaid'");
	
	if ( (($post_default == "debit") and ($posting == "Cr")) or (($post_default == "credit") and ($posting == "Dr")) )
	{
		$sum = "-".$sum;
	}
	
	$sum_sebelum = sql_get_var("select sum from tbl_acc_sum_saldo_coa where MONTH(tanggal)='$bulan' and YEAR(tanggal)='$tahun' and coaid='$coaid' limit 1");
	$sum_sesudah = $sum_sebelum + $sum;
	
	$datacoa 	= "select posting,sum from tbl_acc_sum_saldo_coa where MONTH(tanggal)='$bulan' and YEAR(tanggal)='$tahun' and coaid='$coaid' limit 1";
	$hasil 		= sql($datacoa);
	$jumlah		= sql_num_rows($hasil);

	if($jumlah)
	{
		$sql = "update tbl_acc_sum_saldo_coa set update_date='$date',update_grupuserid='$cuserid',tanggal='$tgl',posting='$posting',sum=sum+'$sum' where MONTH(tanggal)='$bulan' and YEAR(tanggal)='$tahun' and coaid='$coaid'";
		$hsl = sql($sql);
	}
	else
	{
		$sqls = "INSERT INTO tbl_acc_sum_saldo_coa(sumsaldocoaid,tanggal,create_date,create_grupuserid,periodeakuntansiid,coaid,sum,posting)
					VALUES ('$sumsaldocoaid','$tgl','$date','$cuserid','$periodeakuntansiid','$coaid','$sum','$posting')";
		$hsls = sql($sqls);
	}
	
	$shasil 	= sql_get_var_row("select sumsaldocoaid,sum from tbl_acc_sum_saldo_coa where MONTH(tanggal)='$bulan' and YEAR(tanggal)='$tahun' and coaid='$coaid' limit 1");
	$sum_hasil	= $shasil['sum'];
	$sumid		= $shasil['sumsaldocoaid'];
	
	if ($sum_sesudah != $sum_hasil)
	{
		 $ip 	= $_SERVER['REMOTE_ADDR'];
		 $uri 	= $_SERVER['REQUEST_URI'];
		 $data 	= date('Y-m-d H:i:s')." | ip: $ip | uri $uri | user : $_SESSION[cmod_grupuserid] |coaid : $coaid | nilaisum : nilaiseharusnya, $sum_sesudah != nilaiditabel, $sum_hasil |sumid: $sumid | $_SESSION[cmod_username] \r\n <br>";
		 $file 	= "./logs/sumcoa.html";
		 $open 	= fopen($file, "a+"); 
		 
		 fwrite($open, "$data"); 
		 fclose($open);
	}
	
	return true;	
}


function acc_sum_saldo_coa_kurang($date,$cuserid,$tgl,$coaid,$sum,$posting,$periodeakuntansiid)
{
	if((preg_match("/,/i",$sum)) and (preg_match("/./i",$sum)))
	{
		$sum	= str_replace(".","",cleaninsert($sum));
		$sum	= str_replace(",",".",cleaninsert($sum));
	}
	
	$tahun 	= substr("$tgl",0,4);
	$bulan 	= substr("$tgl",5,2);
	
	//get post default
	$post_default = sql_get_var("select post_default from tbl_acc_coa where coaid='$coaid'");
	
	if ( (($post_default == "debit") and ($posting == "Cr")) or (($post_default == "credit") and ($posting == "Dr")) )
	{
		$sum = "-".$sum;
	}
	
	$sum_sebelum = sql_get_var("select sum from tbl_acc_sum_saldo_coa where MONTH(tanggal)='$bulan' and YEAR(tanggal)='$tahun' and coaid='$coaid' limit 1");
	$sum_sesudah = $sum_sebelum - $sum;
	
	$datacoa 	= "select posting,sum from tbl_acc_sum_saldo_coa where MONTH(tanggal)='$bulan' and YEAR(tanggal)='$tahun' and coaid='$coaid' limit 1";
	$hasil 		= sql($datacoa);
	$jumlah		= sql_num_rows($hasil);

	if($jumlah)
	{
		$sql = "update tbl_acc_sum_saldo_coa set update_date='$date',update_grupuserid='$cuserid',tanggal='$tgl',posting='$posting',sum=sum-'$sum' where MONTH(tanggal)='$bulan' and YEAR(tanggal)='$tahun' and coaid='$coaid'";
		$hsl = sql($sql);
	}
	
	$shasil 	= sql_get_var_row("select sumsaldocoaid,sum from tbl_acc_sum_saldo_coa where MONTH(tanggal)='$bulan' and YEAR(tanggal)='$tahun' and coaid='$coaid' limit 1");
	$sum_hasil	= $shasil['sum'];
	$sumid		= $shasil['sumsaldocoaid'];
	
	if ($sum_sesudah != $sum_hasil)
	{
		 $ip 	= $_SERVER['REMOTE_ADDR'];
		 $uri 	= $_SERVER['REQUEST_URI'];
		 $data 	= date('Y-m-d H:i:s')." | ip: $ip | uri $uri | user : $_SESSION[cmod_grupuserid] |coaid : $coaid | nilaisum : nilaiseharusnya, $sum_sesudah != nilaiditabel, $sum_hasil |sumid: $sumid | $_SESSION[cmod_username] \r\n <br>";
		 $file 	= "./logs/sumcoa.html";
		 $open 	= fopen($file, "a+"); 
		 
		 fwrite($open, "$data"); 
		 fclose($open);
	}
	
	return true;	
}

function get_statuslock($coaid,$periodeid)
{
	$data_coaid		= explode("~",$coaid);
	$jumlahcodid	= count($data_coaid);
	$open	= 0;
	$close	= 0;
	for($r=0;$r<=$jumlahcodid; $r++)
	{	
		$perintah 	= "SELECT coaid,nama,status_lock,tahunperiode,periodeakuntansiid from tbl_acc_coa where coaid='$data_coaid[$r]'";
		$hasil 		= sql($perintah);
		$rowk 		= sql_fetch_data($hasil);
		
		$data_periode		= explode(",",$rowk['tahunperiode']);
		$data_lock 			= explode(",",$rowk['status_lock']);
		$data_periodid		= explode(",",$rowk['periodeakuntansiid']);
	
		$jumlah	= count($data_lock);
		$zbaru	= "";
		for($z=0; $z<$jumlah; $z++)
		{
			
			if ($data_periodid[$z]==$periodeid)
			{
				$zbaru	= $data_lock[$z];
				if ($zbaru==0)
				{
					$open++;
				}
				elseif($zbaru==1)
				{
					$close++;
				}
			}
		}
	}
	if ($close>0)
	{
		return "1";
	}
	elseif ($close=="0")
	{
		return "0";
	}
}

function list_coa($rows,$parent=0,$alamaturl=0)
{
	$no		= 1;
	$jum 	= 0; 
	foreach ($rows as $row)
	{
		$coaid  = $row['coaid'];
		$kode   = $row['kode'];
		$nama   = $row['nama'];
		
		if ($row['parent_id'] == $parent)
		{		
			if(($row['parent_id'] > 0) and ($row['post_type'] != 'header'))
			{
				$result	.= "
				<tr>
					<td align=\"center\">$no</td>
					<td><div style=\"width:60px; float:left;\">&nbsp;</div> $nama</td>
					<td align=\"center\"><a href=\"$alamaturl&coaid=$coaid\"><input type=\"button\" value=\"Detail\"  class=\"btn-fill-lg btn-gradient-yellow btn-hover-bluedark\"/></a> </td>
				</tr>";
			}
			elseif(($row['parent_id'] > 0) and ($row['post_type'] == 'header'))
			{ 
				if(substr($kode,2,1) == 0)
				{
					$result	.= "
					<tr>
						<td align=\"center\">$no</td>
						<td colspan=2><div style=\"width:20px; float:left;\">&nbsp;</div> <strong>$nama</strong></td>
					</tr>";
				}
				else
				{
					$result	.= "
					<tr>
						<td align=\"center\">$no</td>
						<td colspan=2><div style=\"width:40px; float:left;\">&nbsp;</div> <strong>$nama</strong></td>
					</tr>";
				}
			}
			else
			{ 
				$result	.= 
				"<tr style=\"background-color:#99CCCC\">
					<td align=\"center\">$no</td>
					<td colspan=2><b style='text-transform:uppercase'>$nama</b></td>
				</tr>";		
			}
		
			$result	.= list_coa($rows,$coaid,$alamaturl);
			$input	= "";	
		}
		$no++;
		$jum++;
	}
  
  return $result;
}
?><br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function sqlconnect() in /home/rakeyansantang/apps/akuntansi/setingan/cmod.database.php:9
Stack trace:
#0 /home/rakeyansantang/apps/akuntansi/index.php(8): include()
#1 {main}
  thrown in <b>/home/rakeyansantang/apps/akuntansi/setingan/cmod.database.php</b> on line <b>9</b><br />