/service_tp50.php

<?Php

	function service_tp50(){
		/*$servername = "localhost";
		$database = "vms";
		$username = "root";
		$password = "rumahkusyurgaku";
		*/
		
		$servername = "localhost";
		$database = "dacon";
		$username = "root";
		$password = "";
		
		//echo "$servername";exit;
		$conn = mysqli_connect($servername, $username, $password, $database);
		// Check connection
		if (!$conn) {
			die("Connection failed: " . mysqli_connect_error());
		}
		
		$sql = "SELECT * FROM tbl_seting_path";
		$path = $conn->query($sql)->fetch_assoc();
		
		$dir    = $path["path_ftp"];
		$dir_repo    = $path["path_cut"];
		$file = scandir($dir, 1);
		$jml_file=count($file);
		$sts=0;
		
		$list=getDirContents($dir,$path);
		//echo "<pre>";print_r($list);exit;
		foreach($list as $a=>$b){
			
			/*$sql = "SELECT * FROM tbl_data_kendaraan WHERE plat_number='".$b["plat_number"]."' AND capture_date='".$b["capture_date"]."'";
			$ck = $conn->query($sql)->fetch_assoc();
			$qr="";
			$c_thn=substr($b["capture_date"],0,4);
			$c_bln=substr($b["capture_date"],4,2);
			$c_tgl=substr($b["capture_date"],6,2);
			$c_date=$c_thn."-".$c_bln."-".$c_tgl;
			
			if(isset($ck["plat_number"])){
				if(isset($b["file_foto"])){
					$f="file_foto";
					$v=$b["file_foto"];
					$qr="speed='".$b["speed"]."',";
				}
				if(isset($b["file_flat"])){
					$f="file_flat";
					$v=$b["file_flat"];
				}
				
				$sql="UPDATE tbl_data_kendaraan SET plat_number='".$b["plat_number"]."',capture_date='".$c_date."',".$qr.$f." = '".mysqli_real_escape_string($conn, $v)."',lane_no='".$b["lane_no"]."'   WHERE plat_number='".$b["plat_number"]."' AND capture_date='".$b["capture_date"]."' ";
				$conn->query($sql);
				
				echo "Update Data Berhasil Masuk Plat -> ".$b["plat_number"]." <br>";
			}else{
				if(isset($b["file_foto"])){
					$f="file_foto";
					$v=$b["file_foto"];
				}
				if(isset($b["file_flat"])){
					$f="file_flat";
					$v=$b["file_flat"];
				}
				
		
				$sql="INSERT INTO tbl_data_kendaraan (plat_number,capture_date,capture_time,speed,$f,lane_no) VALUES ('".$b["plat_number"]."','".$c_date."','".$b["capture_time"]."','".$b["speed"]."','".mysqli_real_escape_string($conn, $v)."','".$b["lane_no"]."')";
				$conn->query($sql);
				//$this->db->insert('tbl_data_kendaraan',$b);
				echo "Data Baru Berhasil Masuk Plat -> ".$b["plat_number"]." <br>";
			}
			*/
			$sql="INSERT INTO tbl_data_kamera (ip_camera,tgl,jam,cl_kategori_id,create_date,create_by,file,file_name) VALUES ('".$b["ip_camera"]."','".$b["tgl"]."','".$b["jam"]."','".$b["cl_kategori_id"]."','".date('Y-m-d H:i:s')."','SYS','".mysqli_real_escape_string($conn, $b["file"])."','".$b["file_name"]."')";
			$conn->query($sql);
		}
		$file = scandir($dir, 1);
		//recurse_copy($dir.'192.168.5.61', $dir_repo.'192.168.5.61');
		//echo $dir;exit;
		//echo "<pre>";print_r($file);exit;
		if($jml_file > 2 ){
			foreach($file as $v=>$x){
				if($x!="." && $x!=".."){
					
					//rename_win($dir.$x, $dir_repo.$x);
					recurse_copy($dir.$x, $dir_repo.$x);
					echo $x." -> Status : Sukses <br>";
					$sts=1;
				}
			}
			rrmdir($path["path_ftp"]);
		}else{
			echo "Tidak Ada File Untuk Diexport";
		}
		mysqli_close($conn);
		
	}
	function getDirContents($dir,$dir_repo,&$results = array()) {
		//print_r($dir_repo);exit;
		$servername = "localhost";
		$database = "dacon";
		$username = "root";
		$password = "";
		
		//echo "$servername";exit;
		$conn = mysqli_connect($servername, $username, $password, $database);
		// Check connection
		if (!$conn) {
			die("Connection failed: " . mysqli_connect_error());
		}
		
		$dir_ftp=$dir_repo["path_ftp"];
		$dir_rep=$dir_repo["path_cut"];
		$files = scandir($dir);
		//echo $dir_ftp."<br>".$dir_rep;exit;
		//echo "<pre>";print_r($files);exit;
		foreach ($files as $key => $value) {
			//$path_repo = realpath($dir_repo . DIRECTORY_SEPARATOR . $value);
			$path = realpath($dir . DIRECTORY_SEPARATOR . $value);
			//echo $value;exit;
			//if($value!='.' && $value!='..')	{echo is_dir($path);exit;}
			if (!is_dir($path)) {
				$ext = pathinfo($value, PATHINFO_EXTENSION);
				
				if($ext=='JPG' || $ext=='jpg' || $ext=='JPEG' || $ext=='jpeg'){
					//echo $ext;exit;
					$ex=explode("-",$value);
					$ip=$ex[0];
					if(substr($ip,0,5)!='Plate'){
						$nama_kamera=$ex[1];
						$kat=$ex[2];
						$waktu=$ex[3];
						$thn=substr($waktu,0,4);
						$bln=substr($waktu,4,2);
						$hr=substr($waktu,6,2);
						$jam=substr($waktu,8,2);
						$menit=substr($waktu,10,2);
						$detik=substr($waktu,12,2);
						$tgl=$thn.'-'.$bln.'-'.$hr;
						$waktu=$jam.':'.$menit.':'.$detik;
						
						
						$sql = "SELECT * FROM cl_kategori WHERE kategori='".$kat."'";
						$ck = $conn->query($sql)->fetch_assoc();
						if(isset($ck["id"])){
							$kat_id=$ck["id"];
						}else{
							$kat_id=4;
						}
						//echo $tgl. ' '.$waktu.' '.$kat_id;exit;
						//print_r($ex);exit;
						
						
						$path_repo =str_replace($dir_ftp,$dir_rep,$path);
						$dt=array('ip_camera'=>$ip,'tgl'=>$tgl,'jam'=>$waktu,'cl_kategori_id'=>$kat_id,'file_name'=>$value);
						$dt["file"]=$path_repo;
						//echo $conn->real_escape_string($path_repo);exit;
						/*$pc=explode('.',$ex[5]);
						if($pc[0]=='MOBIL1'){
							
							$dt=array('plat_number'=>$ex[2],'capture_date'=>$ex[0],'capture_time'=>$ex[1],'speed'=>$ex[3],'lane_no'=>$ex[4]);
							$dt["file_foto"]=$path_repo;
						}else{
							
							$dt=array('plat_number'=>$ex[3],'capture_date'=>$ex[0],'capture_time'=>$ex[1],'speed'=>$ex[2],'lane_no'=>$ex[4]);
							$dt["file_flat"]=$path_repo;
						}
						*/
						//echo "<pre>";print_r($dt);exit;
						$results[] = $dt;
					}else{
						//unlink($dir_ftp.$value);
						//return TRUE;	
					}
				}else{
					//unlink($dir_ftp.$value);
					//return TRUE;
				}
				//$results[] = $path;
			} else if ($value != "." && $value != "..") {
				getDirContents($path,$dir_repo, $results);
				//$results[] = $path;
			}
		}
		mysqli_close($conn);
		return $results;
	}
	
	function rename_win($oldfile,$newfile) {
		if (!rename($oldfile,$newfile)) {
			if (copy ($oldfile,$newfile)) {
				unlink($oldfile);
				return TRUE;
			}
			return FALSE;
		}
		return TRUE;
	}
	
	function recurse_copy($src,$dst) { 
        $dir = opendir($src); 
        @mkdir($dst); 
        while(false !== ( $file = readdir($dir)) ) { 
            if (( $file != '.' ) && ( $file != '..' )) { 
                if ( is_dir($src . '/' . $file) ) { 
                    recurse_copy($src . '/' . $file,$dst . '/' . $file); 
					//unlink($src . '/' . $file,$dst . '/' . $file);
					chmod($src . '/' . $file,777);
					//unlink($src . '/' . $file);
                } 
                else { 
                    copy($src . '/' . $file,$dst . '/' . $file); 
					chmod($src . '/' . $file,777);
					//unlink($src . '/' . $file);
                } 
            } 
        } 
        closedir($dir); 
		//rrmdir($dir);
    } 
	function rrmdir($dir) { 
	   if (is_dir($dir)) { 
		 $objects = scandir($dir);
		 foreach ($objects as $object) { 
		   if ($object != "." && $object != "..") { 
			 if (is_dir($dir. DIRECTORY_SEPARATOR .$object) && !is_link($dir."/".$object)){
			   chmod($dir. DIRECTORY_SEPARATOR .$object,0777);
			   rrmdir($dir. DIRECTORY_SEPARATOR .$object);
			 }
			 else{
			   chmod($dir. DIRECTORY_SEPARATOR .$object,0777);
			   unlink($dir. DIRECTORY_SEPARATOR .$object); 
			 }
		   } 
		 }
		// rmdir($dir); 
	   } 
	 }

/*

$al=new alarm();
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
		$sts=$al->send_firebase($notification,$row["firebase_token"]);
        //echo "token: " . ."<br>";
    }
} else {
    echo "0 results";
}
echo $sts;
*/
service_tp50();



?>