<?php
require_once('DatabaseMySQL.php');

$open = fopen('cron1.txt', 'a+');
fwrite($open, date("Y/m/d")." - ".date("h:i:sa")."\n");
fclose($open);

$month_number = array('Januari' => 1, 'Februari' => 2, 'Maret' => 3, 'April' => 4, 'Mei' => 5, 'Juni' => 6, 'Juli' => 7, 'Agustus' => 8, 'September' => 9, 'Oktober' => 10, 'November' => 11, 'Desember' => 12);
$mysqli = new DatabaseMySQL();
$mysqli_connection = $mysqli->connection();

function curl_get($url, $is_save_cookie, $proxy){
    $useragent = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36';
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    if(!empty($proxy)){
      preg_replace('/\s+?|\r+?|\t+?|\n+/', '', $proxy);
      $proxy_array = array(explode(":", $proxy));
      $ip = $proxy_array[0][0];
      $port = $proxy_array[0][1];
      curl_setopt($ch, CURLOPT_PROXY, $ip);
      curl_setopt($ch, CURLOPT_PROXYPORT, $port);
      curl_setopt($ch, CURLOPT_PROXYTYPE, CURLPROXY_SOCKS5);
    }
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
    curl_setopt($ch, CURLOPT_USERAGENT, $useragent);
    curl_setopt($ch, CURLOPT_TIMEOUT, 30);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    if(!empty($is_save_cookie)){
      curl_setopt($ch, CURLOPT_COOKIEJAR, '/temp/'.$is_save_cookie.'.txt');
      curl_setopt($ch, CURLOPT_COOKIEFILE, '/temp/'.$is_save_cookie.'.txt');
    }
    $data = curl_exec($ch);
    curl_close($ch);
    if(file_exists('/temp/'.$is_save_cookie.'.txt')){
      unlink('/temp/'.$is_save_cookie.'.txt');
    }
    return $data;
  }

function update_logger(){
  $google_csv = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vSzf6EiXEZjHYWxMF9KWPNYsRn2-0S2FiJWelVd7ubnOUQinb2yogqo61RTuwehUCG3WDx2HLRJSceB/pub?gid=1944938174&single=true&output=csv';
  $google_spreadsheet_csv = curl_get($google_csv, md5(time()), '');
  //echo $google_spreadsheet_csv."<br><br>";
  if(!empty($google_spreadsheet_csv) || $google_spreadsheet_csv != null || $google_spreadsheet_csv != 'none'){
    $stmt = $GLOBALS['mysqli_connection']->prepare('TRUNCATE TABLE logger');
    $stmt->execute();
    $stmt->close();
    $totaldata = 0;
    $data = explode("\r\n", $google_spreadsheet_csv);
    unset($data[0]);
    foreach($data as $d){
      if(preg_match('/^\,/', $d)){
      }else{
      $blacklist = array();
      $d_arrx = explode(",", $d);
      $d_arr = array();
      for($i=0;$i<=count($d_arrx);$i++){
        if(in_array($i, $blacklist) == false){
          if(empty($d_arrx[$i])){
            array_push($d_arr, '-');
          }elseif(preg_match('/\d+\s+\S+\s+\d+/', $d_arrx[$i])){
            //echo $d_arrx[$i]."<br>";
            $montharr = explode(" ", $d_arrx[$i]);
            array_push($d_arr, ($montharr[2].'-'.$GLOBALS['month_number'][$montharr[1]].'-'.$montharr[0]));
          }elseif(preg_match('/\d+\/\d+\/\d+/', $d_arrx[$i])){
            $montharr = explode("/", $d_arrx[$i]);
            $newmonth = ($montharr[2].'-'.$montharr[1].'-'.$montharr[0]);
            array_push($d_arr, $newmonth);
          }elseif(preg_match('/\"\d+?|\"-\d+?|\d+\"/', $d_arrx[$i])){
            array_push($blacklist, $i+1);
            $newstring = preg_replace('/\"/', '', ($d_arrx[$i].'.'.$d_arrx[$i+1]));
            array_push($d_arr, $newstring);
          }else{
            array_push($d_arr, preg_replace('/\"?|\'/', '', $d_arrx[$i]));
          }
        }
      }
      $blacklist = array();
      if($d_arr[0] == '-'){
      }else{
        $stmt = $GLOBALS['mysqli_connection']->prepare('SELECT * FROM logger WHERE `tanggal`=? AND `PP1`=? AND `PP2`=? AND `PP3`=? AND `PP4`=? AND `P1`=? AND `P2`=? AND `P3`=?  AND `P4`=? AND `P5`=? AND `P6`=? AND `P7`=?  AND `P8`=? LIMIT 1');
        $stmt->bind_param('sssssssssssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3], $d_arr[4], $d_arr[5], $d_arr[6], $d_arr[7], $d_arr[8], $d_arr[9], $d_arr[10], $d_arr[11], $d_arr[12]);
        $stmt->execute();
        $stmt->store_result();
        if($stmt->num_rows() < 1){
          $stmt->free_result();
          $stmt->close();
          $stmt = $GLOBALS['mysqli_connection']->prepare('INSERT INTO `logger`(`tanggal`, `PP1`, `PP2`, `PP3`, `PP4`, `P1`, `P2`, `P3`, `P4`, `P5`, `P6`, `P7`, `P8`, `P9`, `P10`, `P11`, `P12`, `P13`, `P14`, `P15`, `P16`, `P17`, `P18`, `Pe1`, `Pe2`, `Pe3`, `Pe4`, `Pe5`, `Pe6`, `Pe7`, `Pe8`, `E1_1`, `E1_2`, `E1_3`, `E2_1`, `E2_2`, `E2_3`, `E3_1`, `E3_2`, `E3_3`, `E4_1`, `E4_2`, `E4_3`, `E5_1`, `E5_2`, `E5_3`, `E6_1`, `E6_2`, `E6_3`, `E7`, `E8`, `elevasi`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
          $stmt->bind_param('ssssssssssssssssssssssssssssssssssssssssssssssssssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3], $d_arr[4], $d_arr[5], $d_arr[6], $d_arr[7], $d_arr[8], $d_arr[9], $d_arr[10], $d_arr[11], $d_arr[12], $d_arr[13], $d_arr[14], $d_arr[15], $d_arr[16], $d_arr[17], $d_arr[18], $d_arr[19], $d_arr[20], $d_arr[21], $d_arr[22], $d_arr[23], $d_arr[24], $d_arr[25], $d_arr[26], $d_arr[27], $d_arr[28], $d_arr[29], $d_arr[30], $d_arr[31], $d_arr[32], $d_arr[33], $d_arr[34], $d_arr[35], $d_arr[36], $d_arr[37], $d_arr[38], $d_arr[39], $d_arr[40], $d_arr[41], $d_arr[42], $d_arr[43], $d_arr[44], $d_arr[45], $d_arr[46], $d_arr[47], $d_arr[48], $d_arr[49], $d_arr[50], $d_arr[51]);
          $stmt->execute();
          $stmt->free_result();
          $stmt->close();
          $totaldata += 1;
       }else{
         $stmt->free_result();
         $stmt->close();
       }
      }
    }
    }
    echo 'total input: '.$totaldata.'<br>';
    $mysqli_connection->close();
  }
}

function update_klimatologi(){
  $google_csv = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vS0GYQBtTxGSqu51B0rmiEE4Cbb0FhiAqo2wkwos4cG_gTZgJdV7Dw5_lxTDuoJA9vrSF9gLjJc-OvR/pub?gid=0&single=true&output=csv';
  $google_spreadsheet_csv = curl_get($google_csv, md5(time()), '');
  //echo $google_spreadsheet_csv."<br><br>";
  if(!empty($google_spreadsheet_csv) || $google_spreadsheet_csv != null || $google_spreadsheet_csv != 'none'){
    $stmt = $GLOBALS['mysqli_connection']->prepare('TRUNCATE TABLE klimatologi');
    $stmt->execute();
    $stmt->close();
    $totaldata = 0;
    $data = explode("\r\n", $google_spreadsheet_csv);
    unset($data[0]);
    foreach($data as $d){
      if(preg_match('/^\,/', $d)){
      }else{
        $blacklist = array();
        $d_arrx = explode(",", $d);
        $d_arr = array();
        for($i=0;$i<=count($d_arrx);$i++){
          if(in_array($i, $blacklist) == false){
            if(empty($d_arrx[$i])){
              array_push($d_arr, '-');
            }elseif(preg_match('/\d+\s+\S+\s+\d+/', $d_arrx[$i])){
              //echo $d_arrx[$i]."<br>";
              $montharr = explode(" ", $d_arrx[$i]);
              array_push($d_arr, ($montharr[2].'-'.$GLOBALS['month_number'][$montharr[1]].'-'.$montharr[0]));
            }elseif(preg_match('/\d+\/\d+\/\d+/', $d_arrx[$i])){
              $montharr = explode("/", $d_arrx[$i]);
              $newmonth = ($montharr[2].'-'.$montharr[1].'-'.$montharr[0]);
              array_push($d_arr, $newmonth);
            }elseif(preg_match('/\"\d+?|\d+\"/', $d_arrx[$i])){
              array_push($blacklist, $i+1);
              $newstring = preg_replace('/\"/', '', ($d_arrx[$i].'.'.$d_arrx[$i+1]));
              array_push($d_arr, $newstring);
            }elseif(preg_match('/\d+\:\d+/', $d_arrx[$i])){
              $arrtime = explode(":", $d_arrx[$i]);
              if(preg_match('/\d\d/', $arrtime[0])){
                if(isset($arrtime[2]) == false){
                  array_push($d_arr, $d_arrx[$i].':00');
                }else{
                  array_push($d_arr, $d_arrx[$i]);
                }
              }else{
                if(isset($arrtime[2]) == false){
                  array_push($d_arr, '0'.$d_arrx[$i].':00');
                }else{
                  array_push($d_arr, '0'.$d_arrx[$i]);
                }
              }
            }elseif(preg_match('/\d+\.\d+\.\d+/', $d_arrx[$i])){
              $arrtime = explode(".", $d_arrx[$i]);
              if(preg_match('/\d\d/', $arrtime[0])){
                if($arrtime[2] >= 60){
                  $neg = $arrtime[2] - 60;
                  $arrtime[1] += 01;
                  if(preg_match('/\d\d/', $neg)){
                    $arrtime[2] = $neg;
                  }else{
                    $arrtime[2] = '0'.$neg;
                  }
                }
                $newtimex = ($arrtime[0].':'.$arrtime[1].':'.$arrtime[2]);
                array_push($d_arr, $newtimex);
                /*$xt = "1. ".$d_arrx[$i]." - ".$newtime;
                $open = fopen('/var/www/vhosts/gistecprima.com/cipanas.gistecprima.com/cron1.txt', 'a+');
                fwrite($open, $xt."\n");
                fclose($open);*/
              }else{
                if($arrtime[2] >= 60){
                  $neg = $arrtime[2] - 60;
                  $arrtime[1] += 01;
                  if(preg_match('/\d\d/', $neg)){
                    $arrtime[2] = $neg;
                  }else{
                    $arrtime[2] = '0'.$neg;
                  }
                }
                $newtime = ('0'.$arrtime[0].':'.$arrtime[1].':'.$arrtime[2]);
                array_push($d_arr, $newtime);
                /*$xt = "2. ".$d_arrx[$i]." - ".$newtime;
                $open = fopen('/var/www/vhosts/gistecprima.com/cipanas.gistecprima.com/cron1.txt', 'a+');
                fwrite($open, $xt."\n");
                fclose($open);*/
              }
            }else{
              array_push($d_arr, preg_replace('/\"?|\'/', '', $d_arrx[$i]));
            }
          }
        }
        $blacklist = array();
        if($d_arr[0] == '-'){
        }else{
          $stmt = $GLOBALS['mysqli_connection']->prepare('SELECT * FROM klimatologi WHERE `tanggal`=? AND `jam`=? AND `curah_hujan`=? AND `kondisi`=? LIMIT 1');
          $stmt->bind_param('ssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3]);
          $stmt->execute();
          $stmt->store_result();
          if($stmt->num_rows() < 1){
            $stmt->free_result();
            $stmt->close();
            $stmt = $GLOBALS['mysqli_connection']->prepare('INSERT INTO `klimatologi`(`tanggal`, `jam`, `curah_hujan`, `kondisi`) VALUES (?,?,?,?)');
            $stmt->bind_param('ssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3]);
            $stmt->execute();
            $stmt->free_result();
            $stmt->close();
            $totaldata += 1;
         }else{
           $stmt->free_result();
           $stmt->close();
         }
        }
      }
    }
  }
}


function update_v_notch(){
  $google_csv = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQew4y9g9oPkABB4FQIWHSwNPp-jtsp2L0Ks1EBibP2peUelT5ONvRw9FbKAxLFGulB7dB8AA9gWQ88/pub?gid=636979376&single=true&output=csv';
  $google_spreadsheet_csv = curl_get($google_csv, md5(time()), '');
  //echo $google_spreadsheet_csv."<br><br>";
  if(!empty($google_spreadsheet_csv) || $google_spreadsheet_csv != null || $google_spreadsheet_csv != 'none'){
    $stmt = $GLOBALS['mysqli_connection']->prepare('TRUNCATE TABLE v_notch');
    $stmt->execute();
    $stmt->close();
    $totaldata = 0;
    $data = explode("\r\n", $google_spreadsheet_csv);
    unset($data[0]);
    foreach($data as $d){
      if(preg_match('/^\,/', $d)){
      }else{
        $blacklist = array();
        $d_arrx = explode(",", $d);
        $d_arr = array();
        for($i=0;$i<=count($d_arrx);$i++){
          if(in_array($i, $blacklist) == false){
            if(empty($d_arrx[$i])){
              array_push($d_arr, '-');
            }elseif(preg_match('/\d+\s+\S+\s+\d+/', $d_arrx[$i])){
              //echo $d_arrx[$i]."<br>";
              $montharr = explode(" ", $d_arrx[$i]);
              array_push($d_arr, ($montharr[2].'-'.$GLOBALS['month_number'][$montharr[1]].'-'.$montharr[0]));
            }elseif(preg_match('/\d+\/\d+\/\d+/', $d_arrx[$i])){
              $montharr = explode("/", $d_arrx[$i]);
              $newmonth = ($montharr[2].'-'.$montharr[1].'-'.$montharr[0]);
              array_push($d_arr, $newmonth);
            }elseif(preg_match('/\"\d+?|\d+\"/', $d_arrx[$i])){
              array_push($blacklist, $i+1);
              $newstring = preg_replace('/\"/', '', ($d_arrx[$i].'.'.$d_arrx[$i+1]));
              array_push($d_arr, $newstring);
            }elseif(preg_match('/\d+\:\d+/', $d_arrx[$i])){
              $arrtime = explode(":", $d_arrx[$i]);
              if(preg_match('/\d\d/', $arrtime[0])){
                if(isset($arrtime[2]) == false){
                  array_push($d_arr, $d_arrx[$i].':00');
                }else{
                  array_push($d_arr, $d_arrx[$i]);
                }
              }else{
                if(isset($arrtime[2]) == false){
                  array_push($d_arr, '0'.$d_arrx[$i].':00');
                }else{
                  array_push($d_arr, '0'.$d_arrx[$i]);
                }
              }
            }elseif(preg_match('/\d+\.\d+\.\d+/', $d_arrx[$i])){
              $arrtime = explode(".", $d_arrx[$i]);
              if(preg_match('/\d\d/', $arrtime[0])){
                if($arrtime[2] >= 60){
                  $neg = $arrtime[2] - 60;
                  $arrtime[1] += 01;
                  if(preg_match('/\d\d/', $neg)){
                    $arrtime[2] = $neg;
                  }else{
                    $arrtime[2] = '0'.$neg;
                  }
                }
                $newtimex = ($arrtime[0].':'.$arrtime[1].':'.$arrtime[2]);
                array_push($d_arr, $newtimex);
                /*$xt = "1. ".$d_arrx[$i]." - ".$newtime;
                $open = fopen('/var/www/vhosts/gistecprima.com/cipanas.gistecprima.com/cron1.txt', 'a+');
                fwrite($open, $xt."\n");
                fclose($open);*/
              }else{
                if($arrtime[2] >= 60){
                  $neg = $arrtime[2] - 60;
                  $arrtime[1] += 01;
                  if(preg_match('/\d\d/', $neg)){
                    $arrtime[2] = $neg;
                  }else{
                    $arrtime[2] = '0'.$neg;
                  }
                }
                $newtime = ('0'.$arrtime[0].':'.$arrtime[1].':'.$arrtime[2]);
                array_push($d_arr, $newtime);
                /*$xt = "2. ".$d_arrx[$i]." - ".$newtime;
                $open = fopen('/var/www/vhosts/gistecprima.com/cipanas.gistecprima.com/cron1.txt', 'a+');
                fwrite($open, $xt."\n");
                fclose($open);*/
              }
            }else{
              array_push($d_arr, preg_replace('/\"?|\'/', '', $d_arrx[$i]));
            }
          }
        }
        $blacklist = array();
        if($d_arr[0] == '-'){
        }else{
          $stmt = $GLOBALS['mysqli_connection']->prepare('SELECT * FROM v_notch WHERE `Tanggal`=? AND `Jam`=? AND `Saluran Kanan`=? AND `Saluran Kiri`=? AND `Cuaca`=? LIMIT 1');
          $stmt->bind_param('sssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3], $d_arr[4]);
          $stmt->execute();
          $stmt->store_result();
          if($stmt->num_rows() < 1){
            $stmt->free_result();
            $stmt->close();
            $stmt = $GLOBALS['mysqli_connection']->prepare('INSERT INTO `v_notch`(`Tanggal`, `Jam`, `Saluran Kanan`, `Saluran Kiri`, `Cuaca`) VALUES (?,?,?,?,?)');
            $stmt->bind_param('sssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3], $d_arr[4]);
            $stmt->execute();
            $stmt->free_result();
            $stmt->close();
            $totaldata += 1;
         }else{
           $stmt->free_result();
           $stmt->close();
         }
        }
      }
    }
  }
}


function update_sumur_pengamatan(){
  $google_csv = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQtEYX6KTmrehZ4j3HeHPavU--Fcc3QLh3IQ2zsHPYx18KOuyl2HAIYKpZZmGR5jAfI6Tj2Kus6V5H7/pub?gid=1083081537&single=true&output=csv';
  $google_spreadsheet_csv = curl_get($google_csv, md5(time()), '');
  //echo $google_spreadsheet_csv."<br><br>";
  if(!empty($google_spreadsheet_csv) || $google_spreadsheet_csv != null || $google_spreadsheet_csv != 'none'){
    $stmt = $GLOBALS['mysqli_connection']->prepare('TRUNCATE TABLE sumur_pengamatan');
    $stmt->execute();
    $stmt->close();
    $totaldata = 0;
    $data = explode("\r\n", $google_spreadsheet_csv);
    unset($data[0]);
    foreach($data as $d){
      if(preg_match('/^\,/', $d)){
      }else{
        $blacklist = array();
        $d_arrx = explode(",", $d);
        $d_arr = array();
        for($i=0;$i<=count($d_arrx);$i++){
          if(in_array($i, $blacklist) == false){
            if(empty($d_arrx[$i])){
              array_push($d_arr, '-');
            }elseif(preg_match('/\d+\s+\S+\s+\d+/', $d_arrx[$i])){
              //echo $d_arrx[$i]."<br>";
              $montharr = explode(" ", $d_arrx[$i]);
              array_push($d_arr, ($montharr[2].'-'.$GLOBALS['month_number'][$montharr[1]].'-'.$montharr[0]));
            }elseif(preg_match('/\d+\/\d+\/\d+/', $d_arrx[$i])){
              $montharr = explode("/", $d_arrx[$i]);
              $newmonth = ($montharr[2].'-'.$montharr[1].'-'.$montharr[0]);
              array_push($d_arr, $newmonth);
            }elseif(preg_match('/\"\d+?|\d+\"/', $d_arrx[$i])){
              array_push($blacklist, $i+1);
              $newstring = preg_replace('/\"/', '', ($d_arrx[$i].'.'.$d_arrx[$i+1]));
              array_push($d_arr, $newstring);
            }elseif(preg_match('/\d+\:\d+/', $d_arrx[$i])){
              $arrtime = explode(":", $d_arrx[$i]);
              if(preg_match('/\d\d/', $arrtime[0])){
                if(isset($arrtime[2]) == false){
                  array_push($d_arr, $d_arrx[$i].':00');
                }else{
                  array_push($d_arr, $d_arrx[$i]);
                }
              }else{
                if(isset($arrtime[2]) == false){
                  array_push($d_arr, '0'.$d_arrx[$i].':00');
                }else{
                  array_push($d_arr, '0'.$d_arrx[$i]);
                }
              }
            }elseif(preg_match('/\d+\.\d+\.\d+/', $d_arrx[$i])){
              $arrtime = explode(".", $d_arrx[$i]);
              if(preg_match('/\d\d/', $arrtime[0])){
                if($arrtime[2] >= 60){
                  $neg = $arrtime[2] - 60;
                  $arrtime[1] += 01;
                  if(preg_match('/\d\d/', $neg)){
                    $arrtime[2] = $neg;
                  }else{
                    $arrtime[2] = '0'.$neg;
                  }
                }
                $newtimex = ($arrtime[0].':'.$arrtime[1].':'.$arrtime[2]);
                array_push($d_arr, $newtimex);
                /*$xt = "1. ".$d_arrx[$i]." - ".$newtime;
                $open = fopen('/var/www/vhosts/gistecprima.com/cipanas.gistecprima.com/cron1.txt', 'a+');
                fwrite($open, $xt."\n");
                fclose($open);*/
              }else{
                if($arrtime[2] >= 60){
                  $neg = $arrtime[2] - 60;
                  $arrtime[1] += 01;
                  if(preg_match('/\d\d/', $neg)){
                    $arrtime[2] = $neg;
                  }else{
                    $arrtime[2] = '0'.$neg;
                  }
                }
                $newtime = ('0'.$arrtime[0].':'.$arrtime[1].':'.$arrtime[2]);
                array_push($d_arr, $newtime);
                /*$xt = "2. ".$d_arrx[$i]." - ".$newtime;
                $open = fopen('/var/www/vhosts/gistecprima.com/cipanas.gistecprima.com/cron1.txt', 'a+');
                fwrite($open, $xt."\n");
                fclose($open);*/
              }
            }else{
              array_push($d_arr, preg_replace('/\"?|\'/', '', $d_arrx[$i]));
            }
          }
        }
        $blacklist = array();
        if($d_arr[0] == '-'){
        }else{
          $stmt = $GLOBALS['mysqli_connection']->prepare('SELECT * FROM sumur_pengamatan WHERE `tanggal`=? AND `jam`=? AND `OH1`=? AND `OH2`=? AND `OH3`=? AND `OH4`=? AND `OH5`=? LIMIT 1');
          $stmt->bind_param('sssssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3], $d_arr[4], $d_arr[5], $d_arr[6]);
          $stmt->execute();
          $stmt->store_result();
          if($stmt->num_rows() < 1){
            $stmt->free_result();
            $stmt->close();
            $stmt = $GLOBALS['mysqli_connection']->prepare('INSERT INTO `sumur_pengamatan`(`tanggal`, `jam`, `OH1`, `OH2`, `OH3`, `OH4`, `OH5`) VALUES (?,?,?,?,?,?,?)');
            $stmt->bind_param('sssssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3], $d_arr[4], $d_arr[5], $d_arr[6]);
            $stmt->execute();
            $stmt->free_result();
            $stmt->close();
            $totaldata += 1;
         }else{
           $stmt->free_result();
           $stmt->close();
         }
        }
      }
    }
  }
}



function update_brosur(){
  $brosur_url = 'https://cipanas.gistecprima.com/files/?list=1';
  $data_brosur = curl_get($brosur_url, md5(time()), '');
  if(!empty($data_brosur) || $data_brosur != null || $data_brosur != 'none'){
    $jsondata = json_decode($data_brosur);
    foreach($jsondata as $data){
      $stmt = $GLOBALS['mysqli_connection']->prepare('SELECT * FROM brosur WHERE `nama_brosur`=? LIMIT 1');
      $stmt->bind_param('s', $data->nama_brosur);
      $stmt->execute();
      $stmt->store_result();
      print_r($stmt->get_result());
      if($stmt->num_rows() < 1){
        $stmt->free_result();
        $stmt->close();
        $stmt = $GLOBALS['mysqli_connection']->prepare('INSERT INTO `brosur`(`nama_brosur`, `brosur`) VALUES (?,?)');
        $stmt->bind_param('ss', $data->nama_brosur, $data->file_brosur);
        $stmt->execute();
        $stmt->free_result();
        $stmt->close();
     }else{
       $stmt->free_result();
       $stmt->close();
     }
    }
  }
}

function update_inklinometer(){
  $google_csv = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQnHOILxXiqysbg9ppVhCJ64BazODspApJBrQkHxzU8BqHfoMRykPrgzj5hrRdq_2lEzquaXGnzgypN/pub?gid=994522473&single=true&output=csv';
  $google_spreadsheet_csv = curl_get($google_csv, md5(time()), '');
  //echo $google_spreadsheet_csv."<br><br>";
  if(!empty($google_spreadsheet_csv) || $google_spreadsheet_csv != null || $google_spreadsheet_csv != 'none'){
    $stmt = $GLOBALS['mysqli_connection']->prepare('TRUNCATE TABLE inklinometer');
    $stmt->execute();
    $stmt->close();
    $totaldata = 0;
    $data = explode("\r\n", $google_spreadsheet_csv);
    unset($data[0]);
    foreach($data as $d){
      if(preg_match('/^\,/', $d)){
      }else{
        $blacklist = array();
        $d_arrx = explode(",", $d);
        $d_arr = array();
        for($i=0;$i<=count($d_arrx);$i++){
          if(in_array($i, $blacklist) == false){
            if(empty($d_arrx[$i])){
              array_push($d_arr, '-');
            }elseif(preg_match('/\d+\s+\S+\s+\d+/', $d_arrx[$i])){
              //echo $d_arrx[$i]."<br>";
              $montharr = explode(" ", $d_arrx[$i]);
              array_push($d_arr, ($montharr[2].'-'.$GLOBALS['month_number'][$montharr[1]].'-'.$montharr[0]));
            }elseif(preg_match('/\d+\/\d+\/\d+/', $d_arrx[$i])){
              $montharr = explode("/", $d_arrx[$i]);
              $newmonth = ($montharr[2].'-'.$montharr[1].'-'.$montharr[0]);
              array_push($d_arr, $newmonth);
            }elseif(preg_match('/\"\d+?|\d+\"?|\"-\d+/', $d_arrx[$i])){
              array_push($blacklist, $i+1);
              $newstring = preg_replace('/\"/', '', ($d_arrx[$i].'.'.$d_arrx[$i+1]));
              array_push($d_arr, $newstring);
            }elseif(preg_match('/\d+\:\d+/', $d_arrx[$i])){
              $arrtime = explode(":", $d_arrx[$i]);
              if(preg_match('/\d\d/', $arrtime[0])){
                if(isset($arrtime[2]) == false){
                  array_push($d_arr, $d_arrx[$i].':00');
                }else{
                  array_push($d_arr, $d_arrx[$i]);
                }
              }else{
                if(isset($arrtime[2]) == false){
                  array_push($d_arr, '0'.$d_arrx[$i].':00');
                }else{
                  array_push($d_arr, '0'.$d_arrx[$i]);
                }
              }
            }elseif(preg_match('/\d+\.\d+\.\d+/', $d_arrx[$i])){
              $arrtime = explode(".", $d_arrx[$i]);
              if(preg_match('/\d\d/', $arrtime[0])){
                if($arrtime[2] >= 60){
                  $neg = $arrtime[2] - 60;
                  $arrtime[1] += 01;
                  if(preg_match('/\d\d/', $neg)){
                    $arrtime[2] = $neg;
                  }else{
                    $arrtime[2] = '0'.$neg;
                  }
                }
                $newtimex = ($arrtime[0].':'.$arrtime[1].':'.$arrtime[2]);
                array_push($d_arr, $newtimex);
                /*$xt = "1. ".$d_arrx[$i]." - ".$newtime;
                $open = fopen('/var/www/vhosts/gistecprima.com/cipanas.gistecprima.com/cron1.txt', 'a+');
                fwrite($open, $xt."\n");
                fclose($open);*/
              }else{
                if($arrtime[2] >= 60){
                  $neg = $arrtime[2] - 60;
                  $arrtime[1] += 01;
                  if(preg_match('/\d\d/', $neg)){
                    $arrtime[2] = $neg;
                  }else{
                    $arrtime[2] = '0'.$neg;
                  }
                }
                $newtime = ('0'.$arrtime[0].':'.$arrtime[1].':'.$arrtime[2]);
                array_push($d_arr, $newtime);
                /*$xt = "2. ".$d_arrx[$i]." - ".$newtime;
                $open = fopen('/var/www/vhosts/gistecprima.com/cipanas.gistecprima.com/cron1.txt', 'a+');
                fwrite($open, $xt."\n");
                fclose($open);*/
              }
            }else{
              array_push($d_arr, preg_replace('/\"?|\'/', '', $d_arrx[$i]));
            }
          }
        }
        $blacklist = array();
        if($d_arr[0] == '-'){
        }else{
          $stmt = $GLOBALS['mysqli_connection']->prepare('SELECT * FROM inklinometer WHERE `tanggal`=? LIMIT 1');
          $stmt->bind_param('s', $d_arr[0]);
          $stmt->execute();
          $stmt->store_result();
          print_r($stmt->get_result());
          if($stmt->num_rows() < 1){
            $stmt->free_result();
            $stmt->close();
            $stmt = $GLOBALS['mysqli_connection']->prepare('INSERT INTO `inklinometer`(`tanggal`, `M1`, `M2`, `M3`, `M4`, `M5`, `M6`, `M7`, `M8`, `M9`, `M10`, `M11`, `M12`, `M13`, `M14`, `IM2_1`, `IM2_2`, `IM2_3`, `IM2_4`, `IM2_5`, `IM2_6`, `IM2_7`, `IM2_8`, `IM2_9`, `IM2_10`, `IM2_11`, `IM2_12`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
            $stmt->bind_param('sssssssssssssssssssssssssss', $d_arr[0], $d_arr[1], $d_arr[2], $d_arr[3], $d_arr[4], $d_arr[5], $d_arr[6], $d_arr[7], $d_arr[8], $d_arr[9], $d_arr[10], $d_arr[11], $d_arr[12], $d_arr[13], $d_arr[14], $d_arr[15], $d_arr[16], $d_arr[17], $d_arr[18], $d_arr[19], $d_arr[20], $d_arr[21], $d_arr[22], $d_arr[23], $d_arr[24], $d_arr[25], $d_arr[26]);
            $stmt->execute();
            $stmt->free_result();
            $stmt->close();
            $totaldata += 1;
         }else{
           $stmt->free_result();
           $stmt->close();
         }
        }
      }
    }
  }
}

update_logger();
update_klimatologi();
update_sumur_pengamatan();
update_brosur();
update_v_notch();
update_inklinometer();
$mysqli_connection->close();
?>