<?php
if((isset($_GET['token'])) and ($_GET['token']=='7f20557d2e1f58a0c7927225c58c81d4')){
include "home/admin/part/db.php";
	if($_POST['id']=='kunjungan'){
		$sql="SELECT COUNT(visitor_ID) as 'jumlah', DATE_FORMAT(visitor_date, '%d-%m-%Y') as 'tanggal' 
				FROM tbl_visitor_logs WHERE DATE(visitor_date) BETWEEN (CURDATE() - INTERVAL 30 DAY) AND CURDATE()
				GROUP BY tanggal order by visitor_date";	
		$result = getDataBySQL($sql);
		echo json_encode($result);
		exit;		
	}elseif($_POST['id']=='data'){
		$result=array();
		for($i = 30; $i > 0; $i--){
			$tgl = date("d-m-Y", strtotime("-$i days"));
			$sql_artikel="FROM tbl_post WHERE DATE_FORMAT(post_date, '%d-%m-%Y')='".$tgl."'";
			$sql_umkm="FROM tbl_umkm WHERE DATE_FORMAT(umkmTglInput, '%d-%m-%Y')='".$tgl."'";
			$sql_pma="FROM tbl_ub WHERE DATE_FORMAT(ubTglInput, '%d-%m-%Y')='".$tgl."' AND ubTipe='PMA'";
			$sql_pmdn="FROM tbl_ub WHERE DATE_FORMAT(ubTglInput, '%d-%m-%Y')='".$tgl."' AND ubTipe='PMDN'";
			
			$result[$tgl]['artikel']=jumlahDataQuery($sql_artikel);
			$result[$tgl]['umkm']	=jumlahDataQuery($sql_umkm);
			$result[$tgl]['pma']	=jumlahDataQuery($sql_pma);
			$result[$tgl]['pmdn']	=jumlahDataQuery($sql_pmdn);
		}

			$tgl = date("d-m-Y");
			$sql_artikel="FROM tbl_post WHERE DATE_FORMAT(post_date, '%d-%m-%Y')='".$tgl."'";
			$sql_umkm="FROM tbl_umkm WHERE DATE_FORMAT(umkmTglInput, '%d-%m-%Y')='".$tgl."'";
			$sql_pma="FROM tbl_ub WHERE DATE_FORMAT(ubTglInput, '%d-%m-%Y')='".$tgl."' AND ubTipe='PMA'";
			$sql_pmdn="FROM tbl_ub WHERE DATE_FORMAT(ubTglInput, '%d-%m-%Y')='".$tgl."' AND ubTipe='PMDN'";
			
			$result[$tgl]['artikel']=jumlahDataQuery($sql_artikel);
			$result[$tgl]['umkm']	=jumlahDataQuery($sql_umkm);
			$result[$tgl]['pma']	=jumlahDataQuery($sql_pma);
			$result[$tgl]['pmdn']	=jumlahDataQuery($sql_pmdn);

		echo json_encode($result);
		exit;	
	}
}else{exit;}
?>