/service_tp50.php
PHP | 258 lines | 136 code | 22 blank | 100 comment | 32 complexity | dc6d17aaf73ecc2f0c563b7b268833c1 MD5 | raw file
- <?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();
- ?>