<?php

$a = session_id();
if ($a == '')
  session_start();

chdir(dirname(__FILE__));

include_once("common/constants.inc");
include_once("common/db_utils.php");
include_once("common/segf.php");
include_once("Spreadsheet/Excel/Writer.php");
include_once("PHPExcel/PHPExcel.php"); 
include_once("PHPExcel/PHPExcel/IOFactory.php");


class ImportRagasztasiLista2 {

  function importRagasztasiLista2() {
    if (file_exists(RAGLISTA_FELDOLGOZANDO_DIRECTORY2)) {
      $files = scandir(RAGLISTA_FELDOLGOZANDO_DIRECTORY2);
      for ($i = 0; $i < count($files); $i++) {
        if (strpos($files[$i], "xls") !== false) {
          if (file_exists(RAGLISTA_FELDOLGOZANDO_DIRECTORY2 . $files[$i])) {
            rename(RAGLISTA_FELDOLGOZANDO_DIRECTORY2 . $files[$i], RAGLISTA_FELDOLGOZASALATT_DIRECTORY2 . $files[$i]);
          }
        }
      }
    }

    if (file_exists(RAGLISTA_FELDOLGOZASALATT_DIRECTORY2)) {
      $files = scandir(RAGLISTA_FELDOLGOZASALATT_DIRECTORY2);
      $rows = array();
      foreach ($files as $id => $file) {
        if (strpos($file, "xls") !== false) {
          if (file_exists(RAGLISTA_FELDOLGOZASALATT_DIRECTORY2 . $file)) {
            $cegId = 0;
            if (substr($file, 1, 1) != "_" && substr($file, 2, 1) != "_") {
              $date = substr($file, 0, 4) . "." . substr($file, 4, 2) . "." . substr($file, 6, 2) . ".";
            } else {
              if (substr($file, 1, 1) == "_") {
                $date = substr($file, 2, 4) . "." . substr($file, 6, 2) . "." . substr($file, 8, 2) . ".";
                $cegId = substr($file, 0, 1);
                errorlog("date1: " . $date);
              } else  {
                $date = substr($file, 3, 4) . "." . substr($file, 7, 2) . "." . substr($file, 9, 2) . ".";
                $cegId = substr($file, 0, 2);
                errorlog("date2: " . $date);
              }
            }

//            $ret = importRagLista2(RAGLISTA_FELDOLGOZASALATT_DIRECTORY2 . $files[$i], $date, $cegId);

            $xlsFile = RAGLISTA_FELDOLGOZASALATT_DIRECTORY2 . $file;
            if (file_exists($xlsFile)) {
              try {
                $inputFileType = PHPExcel_IOFactory::identify($xlsFile);
                $objReader = PHPExcel_IOFactory::createReader($inputFileType);
                $objPHPExcel = $objReader->load($xlsFile);

                $sheet = $objPHPExcel->getSheet(0);
                $highestRow = $sheet->getHighestRow();
                $highestColumn = $sheet->getHighestColumn();
                $headerData = $sheet->rangeToArray('A1:' . $highestColumn . '1', NULL, TRUE, FALSE);

                if (isset($headerData[0][12]) && $headerData[0][12] == "JELL5")
                  $xlsType = 1;
                else 
                  $xlsType = 2;

                $isGPSEmbedded = false;
                if (isset($headerData[0][21]) && ($headerData[0][21] == "GPSKOORDINATAX" || $headerData[0][21] == "GPSKOORDINATAY"))
                  $isGPSEmbedded = true;

                for ($row = 1; $row <= $highestRow; $row++) {
                  $rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
                  if ($row > 1 && trim($rowData[0][0]) != "") {
                    if (true) {
                      if (true) {
                        $feluletKod = str_replace("/", "_", $rowData[0][0]);
                        if (true) {
                          $feluletId = GetFeluletId($feluletKod, $date);

                          $gpsLat = 'null';
                          $gpsLon = 'null';
                          if ($isGPSEmbedded) {
                            $gpsLat = str_replace(",", ".", $rowData[0][20]);
                            $gpsLon = str_replace(",", ".", $rowData[0][21]);
                            if ($xlsType == 1)
                              $sajatKod = $rowData[0][24];
                            else
                              $sajatKod = $rowData[0][23];
                          } else {
                            if ($xlsType == 1)
                              $sajatKod = $rowData[0][22];
                            else
                              $sajatKod = $rowData[0][21];
                          }
                          $rows[] = array("felulet_kod" => $feluletKod, "sajat_kod" => $sajatKod, "gps_lat" => $gpsLat, "gps_lon" => $gpsLon, "ragasztas_datum" => $date);
                        }
                      }
                    }
                  }
                }
                $objPHPExcel = null;
                $objReader = null;
              } catch(Exception $ex) {
                $ret = "Az xls feldolgozása nem sikerült!";
                errorlog($ret . " - " . $ex);
                return $ret;
              }
            } else {
              $ret .= "Az xls file nem található!";
              errorlog($ret);
            }

            rename(RAGLISTA_FELDOLGOZASALATT_DIRECTORY2 . $file, RAGLISTA_FELDOLGOZOTT_DIRECTORY2 . $file);
          }
        }
//        errorlogdev(serialize($rows));
//        errorlogdev('-----------------------------------------------------------------------');
      }
      UpdateRagacsList3($rows);
    }
  }

  // send mail
/*  function sendMail($body) {
    mail(RECIPIENTMAIL, MAILSUBJECT, $body, MAILHEADER);
  }*/
  
}

$importRagasztasiLista = new ImportRagasztasiLista2();

// import raglista
$importRagasztasiLista->importRagasztasiLista2();

?>