<?php
$result = new stdClass();
$result->success = false;
$result->pesan = 'ERROR';
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && ($_SERVER['HTTP_X_REQUESTED_WITH'] == 'XMLHttpRequest')) {
	require_once('../../admin/part/db.php');
	$valid_file = false;		
	$valid_photo = false;		
	$photo_allowed = array('png','PNG', 'jpg', 'JPG', 'jpeg', 'JPEG');
	$file_allowed = array('pdf','PDF');

	if(isset($_POST) AND ($_POST['tipe']=='umkm')){
		if(!$_FILES['photo']['error']){
			$photo_ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION);
			if (!in_array($photo_ext, $photo_allowed)) {
					$valid_photo = false;
					$result->pesan ='Gagal Menyimpan Data, extensi File Foto tidak dibolehkan!';
			}else{				
				if($_FILES['photo']['size'] > (2097152)){
					$valid_photo = false;
					$result->pesan ='Gagal Menyimpan Data, File Foto tidak boleh lebih besar dari 2MB!';	
				}else{
					$valid_photo = true;
					$photo = md5(date('Y-m-d H:i:s')).'_'.strtolower(str_replace(' ','_',$_FILES['photo']['name'])); 
				}
			}
		}else{
			$result->pesan ='Gagal Menyimpan Data, Error File Foto!';
		}
		
		if(!$_FILES['perizinan']['error']){
			$file_ext = pathinfo($_FILES['perizinan']['name'], PATHINFO_EXTENSION);
			if (!in_array($file_ext, $file_allowed)) {
					$valid_file = false;
					$result->pesan ='Gagal Menyimpan Data, extensi File Perizinan  tidak dibolehkan!';
			}else{				
				if($_FILES['perizinan']['size'] > (2097152 )){
					$valid_file = false;
					$result->pesan ='Gagal Menyimpan Data, File Perizinan tidak boleh lebih besar dari 2MB!';	
				}else{
					$valid_file = true;
					$perizinan = md5(date('Y-m-d H:i:s')).'_'.strtolower(str_replace(' ','_',$_FILES['perizinan']['name'])); 
				}
			}
		}else{
			$result->pesan ='Gagal Menyimpan Data, Error File Perizinan!';
		}					

		if($valid_file AND $valid_photo){
			move_uploaded_file($_FILES['photo']['tmp_name'], '../assets/upload/'.$photo);
			move_uploaded_file($_FILES['perizinan']['tmp_name'], '../assets/upload/'.$perizinan);
			$umkmMediaSosial = $_POST['instagram'].';'.$_POST['youtube'].';'.$_POST['facebook'].';'.$_POST['website'].';'.$_POST['lainnya'];
			$stmt = $conn->prepare("INSERT INTO `tbl_UMKM` 
									(`umkmNama`, `umkmPemilik`, `umkmHP`, `umkmJenis`, `umkmAlamat`,  `umkmMediaSosial`, `umkmModal`, `umkmOmset`, `umkmPerizinan`, `umkmFoto`, `umkmTglDaftar`) 
									VALUES (:umkmNama, :umkmPemilik, :umkmHP, :umkmJenis, :umkmAlamat,  :umkmMediaSosial, :umkmModal, :umkmOmset, :umkmPerizinan, :umkmFoto, :umkmTglDaftar)");
			$data = array(
						':umkmNama'=>aInj($_POST['umkmNama']),
						':umkmPemilik'=>aInj($_POST['umkmPemilik']),
						':umkmHP'=>aInj($_POST['umkmHP']),
						':umkmJenis'=>aInj($_POST['umkmJenis']),
						':umkmAlamat'=>aInj($_POST['umkmAlamat']),
						':umkmModal'=>aInj($_POST['umkmModal']),
						':umkmOmset'=>aInj($_POST['umkmOmset']),
						':umkmMediaSosial'=>aInj($umkmMediaSosial),
						':umkmPerizinan'=>aInj($perizinan),
						':umkmFoto'=>aInj($photo),
						':umkmTglDaftar'=>date('Y-m-d H:i:s')
						);
			if ($stmt->execute($data)) {
					$result->success =true;				
					$result->pesan ='Berhasil Menyimpan Data';
				}else{
					$result->success =false;				
					$result->pesan ='Gagal Menyimpan Data';
				}
		}
		echo json_encode($result);	
		exit;	
		
	}else if(isset($_POST) AND ($_POST['tipe']=='ub')){
		
		if(!$_FILES['photo']['error']){
			$photo_ext = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION);
			if (!in_array($photo_ext, $photo_allowed)) {
					$valid_photo = false;
					$result->pesan ='Gagal Menyimpan Data, extensi File Foto tidak dibolehkan!';
			}else{				
				if($_FILES['photo']['size'] > (2097152)){
					$valid_photo = false;
					$result->pesan ='Gagal Menyimpan Data, File Foto tidak boleh lebih besar dari 2MB!';	
				}else{
					$valid_photo = true;
					$photo = md5(date('Y-m-d H:i:s')).'_'.strtolower(str_replace(' ','_',$_FILES['photo']['name'])); 
				}
			}
		}else{
			$result->pesan ='Gagal Menyimpan Data, Error File Foto!';
		}
		
		if(!$_FILES['perizinan']['error']){
			$file_ext = pathinfo($_FILES['perizinan']['name'], PATHINFO_EXTENSION);
			if (!in_array($file_ext, $file_allowed)) {
					$valid_file = false;
					$result->pesan ='Gagal Menyimpan Data, extensi File Perizinan  tidak dibolehkan!';
			}else{				
				if($_FILES['perizinan']['size'] > (2097152 )){
					$valid_file = false;
					$result->pesan ='Gagal Menyimpan Data, File Perizinan tidak boleh lebih besar dari 2MB!';	
				}else{
					$valid_file = true;
					$perizinan = md5(date('Y-m-d H:i:s')).'_'.strtolower(str_replace(' ','_',$_FILES['perizinan']['name'])); 
				}
			}
		}else{
			$result->pesan ='Gagal Menyimpan Data, Error File Perizinan!';
		}					

		if($valid_file AND $valid_photo){
			move_uploaded_file($_FILES['photo']['tmp_name'], '../assets/upload/'.$photo);
			move_uploaded_file($_FILES['perizinan']['tmp_name'], '../assets/upload/'.$perizinan);
			$ubMediaSosial = $_POST['instagram'].';'.$_POST['youtube'].';'.$_POST['facebook'].';'.$_POST['website'].';'.$_POST['lainnya'];
			$stmt = $conn->prepare("INSERT INTO `tbl_UB` 
									(`ubNama`, `ubJabatan`, `ubHP`, `ubEmail`, `ubJenis_usaha`,  `ubMediaSosial`, `ubPerizinan`, `ubFoto`, `ubTglDaftar`) 
									VALUES (:ubNama, :ubJabatan, :ubHP, :ubEmail, :ubJenis_usaha,  :ubMediaSosial,  :ubPerizinan, :ubFoto, :ubTglDaftar)");
			$data = array(
						':ubNama'=>aInj($_POST['ubNama']),
						':ubJabatan'=>aInj($_POST['ubJabatan']),
						':ubHP'=>aInj($_POST['ubHP']),
						':ubEmail'=>aInj($_POST['ubEmail']),
						':ubJenis_usaha'=>aInj($_POST['ubJenis_usaha']),
						':ubMediaSosial'=>aInj($ubMediaSosial),
						':ubPerizinan'=>aInj($perizinan),
						':ubFoto'=>aInj($photo),
						':ubTglDaftar'=>date('Y-m-d H:i:s')
						);
			if ($stmt->execute($data)) {
					$result->success =true;				
					$result->pesan ='Berhasil Menyimpan Data';
				}else{
					$result->success =false;				
					$result->pesan ='Gagal Menyimpan Data';
				}
		}

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

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