kirim.php

<?php
//

set_time_limit(0);
ini_set('date.timezone', 'Asia/Jakarta');
ini_set('display_errors', true);
error_reporting(E_ERROR);

//silahkan konfigurasi
$server   = "localhost";
 //$port     = 41013;
 $username = "root";
 $password = "bismillah";
 $database = "kehadiran_unit_kerja";

 //dbase server
 $host   = "xxx.xxx.xx.xx";
 $user   = "xxxxxx";
 $pass   = "xxxxx";
 $time     = date('H:i', time());
 $bts      = '12:00';
 $dir_awal = "kehadiran_server";
 $folder = "lpmpjogja";// ubah disini

if(isset($_POST['tgl']))
 { $today  = $_POST['tgl']; }
 else
 { $today  = date('Y-m-d', time()); }
echo "tanggal: ".$today;

 function _getExplodedFileNameWE($name) {
        $nname_ = explode('.', $name);
        $nname__ = '';

        if ( sizeOf($nname_) <= 2 ) {
            foreach($nname_ as $k=>$n) {
                if ( $k != sizeOf($nname_)-1 ) {
                    $nname__ .= $n;
                }
            }
        } else {
            foreach($nname_ as $k=>$n) {
                if ( $k != sizeOf($nname_)-1 ) {
                    $nname__ .= $n.".";
                }
            }

            $nname__ = substr($nname__, 0, strlen($nname__)-1);
        }

        //echo $nname__;exit;

        return (empty($nname__) ? $name : $nname__);
    }

 /*$mysqli = new mysqli($server,$username,$password,$database) or die("Koneksi gagal");
 $query = "select * from checkinout";//where tanggal-jam and userid 18 digit
 $hasil = $mysqli->query($query);*/

 mysql_connect($server,$username,$password) or die("Koneksi gagal");
 mysql_select_db($database) or die("Database tidak bisa dibuka");
 //$query="select * from checkinout where date(checktime) = date(now()) and length(userid)=18";//per hari
 $query="select * from checkinout where length(userid)=18 and date(checktime) like '%".$today."%'";//per bulan
 $hasil =mysql_query($query);

 $data =  array();

// var_dump($hasil);
 //while($d=mysqli_fetch_array($hasil))
 while($d=mysql_fetch_array($hasil))
 {
        //echo $d[userid];
        $data[]  = array(
                'nip' => $d["userid"],
                'checkin' => $d["checktime"]
            );
 }

//var_dump($data);
//echo json_encode($data);
$json = json_encode($data);
$today = date('Ymd', time());
$filename = "data_".$today."_1.json";
if ( !file_exists($folder."/".$filename) ) {
    if ( file_put_contents($folder."/".$filename, $json) ) {
        echo "File JSON $filename sukses dibuat...";
    } else echo "Oops! Terjadi error saat membuat file JSON $filename";
} else {
    $filename = "data_".$today."_2.json";
    if ( !file_exists($folder."/".$filename) ) {
        if ( file_put_contents($folder."/".$filename, $json) ) {
            echo "File JSON $filename sukses dibuat...";
        } else echo "Oops! Terjadi error saat membuat file JSON $filename";
    }
}

//ftp
//require_once "config_ftp.php";

$ftpConn = ftp_connect($host);
$login = ftp_login($ftpConn,$user,$pass);

ftp_pasv($ftpConn, true);
_sendingFile();

function _sendingFile() {
        global $ftpConn, $login, $folder, $today, $dir_awal, $time, $bts;
        // check connection
        if ((!$ftpConn) || (!$login)) {
         echo 'FTP connection has failed! Attempted to connect to '. $host. ' for user '.$user.'.';
        }else{
            //ubah direktori ke $dir_awal
            if ( @ftp_chdir($ftpConn, $dir_awal) ) {
                //echo "Berhasil";
                //do nothing
            } else echo "Gagal";

            //set direktori asal
            $ftp_origin = ftp_pwd($ftpConn);
            if (!@ftp_chdir($ftpConn, $folder)) {
                //create folder on then destination file server
                ftp_mkdir($ftpConn, $folder);
            } else ftp_chdir($ftpConn, $ftp_origin);

            //echo $ftp_origin;
            //exit;

            //looping folder
            $real_path = realpath($folder);
            if ($handle = opendir($folder)) {
                while (false !== ($entry = readdir($handle))) {
                    if ($entry != "." && $entry != "..") {
                        $ext = end(explode('.', $entry));
                        if ( strtolower($ext) == 'json' ) {
                            $entry_x = _getExplodedFileNameWE($entry);
                            $entry_1 = explode('_', _getExplodedFileNameWE($entry));
                            if ( $entry_1[1] == $today ) {
                                if ( $time <= $bts ) {
                                    if ( strpos($entry_x, '_1') !== false ) $file = $entry;
                                } else {
                                    if ( strpos($entry_x, '_2') !== false ) $file = $entry;
                                }
                            }
                        }
                    }
                }
                closedir($handle);
            }
        }

        if (ftp_put($ftpConn, $folder."/".$file, realpath($folder."/".$file), FTP_ASCII)) {
            //echo "successfully uploaded $file\n";
        } else {
            echo "There was a problem while uploading $file\n";
        }

        ftp_close($ftpConn);
    }

    echo '<a href="index.php"><input type="button" value="Back"/> </a>';
?>