<?php

date_default_timezone_set('Europe/Athens');
include("includes/config.php");
//include("session.php");
if (!empty($_POST['timeDep'])) {

$routeName_Id =  $_POST['routeName'];
$city_from = $_POST['city_from'];
$city_to = $_POST['city_to'];

if (isset($_POST['timeDep'])) {
  $timeDep = $_POST['timeDep'];

}
/*
$deftera = isset($_POST['deftera']) ? 1 : 0;
$triti = isset($_POST['triti']) ? 1 : 0;
$tetarti = isset($_POST['tetarti']) ? 1 : 0;
$pemtpi = isset($_POST['pempti']) ? 1 : 0;
$triti = isset($_POST['triti']) ? 1 : 0;
*/
if (isset($_POST['deftera'])) {
  $deftera = $_POST['deftera'];
  console_log($deftera);
}
if (isset($_POST['triti'])) {
  $triti = $_POST['triti'];
    console_log($triti);
}
if (isset($_POST['tetarti'])) {
  $tetarti = $_POST['tetarti'];
}
if (isset($_POST['pempti'])) {
  $pemtpi = $_POST['pempti'];
}
if (isset($_POST['paraskevi'])) {
  $paraskevi = $_POST['paraskevi'];
}
if (isset($_POST['savato'])) {
  $savato = $_POST['savato'];
}
if (isset($_POST['kyriaki'])) {
  $kyriaki = $_POST['kyriaki'];
}
if (isset($_POST['express'])) {
  $exress = $_POST['express'];
}
if (isset($_POST['antapokrisi'])) {
  $antapokrisi = $_POST['antapokrisi'];
}
if (isset($_POST['notes'])) {
    $notes = $_POST['notes'];
}


$mycitiesfile = fopen("insert_cities_query.txt", "w")   or die("Αδυναμία δημιουργίας αρχείου καταγραφής εισαγωγής πόλεων διαδρομής!");
  //$result_routes = $mysqli->query("insert into routes(name,topiko) values ('ΑΓΡΙΝΙΟ-ΠΑΤΡΑ-ΑΘΗΝΑ',0) "); // Διαβάζει τις κατηγορίες των άρθρων
if (!$mysqli->query($query_route) ) {
    $result = $mysqli->error;
    }

    else //Έγινε η εγγραφή του συνδρομήτη και διαλέγω τον κωδικό του
    {
         $last_id = $mysqli->insert_id;  //Συνάρτησ που επιστρέφει το id που μόλις εισάχθηκε
        foreach ($cities as $poli_id) { //Για κάθε κατηγορία του πίνακα δημιουργεί και μία εγγραφή εισαγωγής κατηγορίας Συνδρομήτή - Κατηγορίας
            $query_insert_stops = "INSERT INTO starts_stops( id_route, id_city_from,id_city_to) VALUES (".$last_id.",".$city_from.",".$city_to.") ";
            echo $query_insert_stops ."</br>";
            if (!$mysqli->query($query_insert_stops)) {
                    $result = $mysqli->error; } else
                    {
                        fwrite($mycitiesfile,   $query_insert_stops);
                    }

          }
          $myschedulefile = fopen("insert_schedules_query.txt", "w")   or die("Αδυναμία δημιουργίας αρχείου καταγραφής Δρομολογίων!");
          //ΕΙΣΑΓΩΓΗ SCHEDULE
          $i= 0;
          foreach ($timeDep as $depart_id) {
                  $deftera_day = isset($deftera[$i]) ? 1 : 0;
                  $triti_day = isset($triti[$i]) ? 1 : 0;
                  $tetarti_day = isset($tetarti[$i]) ? 1 : 0;
                  $pemtpi_day = isset($pemtpi[$i]) ? 1 : 0;
                  $paraskevi_day = isset($paraskevi[$i]) ? 1 : 0;
                  $savato_day = isset($savato[$i]) ? 1 : 0;
                  $kyriaki_day = isset($kyriaki[$i]) ? 1 : 0;
                  $express_day = isset($exress[$i]) ? 1 : 0;
                  $antapokrisi_day = isset($antapokrisi[$i]) ? 1 : 0;
                  $notes_day =  strlen($notes[$i]) > 0 ? $notes[$i] : " ";
                $query_insert_schedule = "INSERT INTO schedule (Id_route,time,deftera,triti,tetarti,pempti,paraskeyi,savato,kyriaki,express,antapokrisi,notes) VALUES
                (".$last_id.",'".$depart_id."',". $deftera_day.",".$triti_day.",".$tetarti_day.",".$pemtpi_day.",".$paraskevi_day.",".$savato_day.",".$kyriaki_day.",".$express_day.",".$antapokrisi_day.",'".$notes_day."') ";
                echo $query_insert_schedule ."</br>";
                if (!$mysqli->query($query_insert_schedule))
                      {
                        $result = $mysqli->error;
                      }
                      else
                        {
                            fwrite($myschedulefile,   $query_insert_schedule);
                        }
            $i++; //Διαβάζει την επόμενη γραμμή του πίνακα
    }
  $result = "success"  ;

 //fwrite($myfile, $result);
 fclose($myroutefile);
fclose($mycitiesfile);
fclose($myschedulefile);
 //fclose($mycategoryfile);
 //echo $result;

  }
}
function console_log( $data ){
  echo '<script>';
  echo 'console.log('. json_encode( $data ) .')';
  echo '</script>';
}
function display_log( $data ){
  echo '<script>';
  echo 'alert("'.$data .'")';
  echo '</script>';
}
      //   $etos= substr($max_period,0,4);
      //  $mhnas=substr($max_period,4,2);
       // isset($_GET['etos'])? $etos=htmlspecialchars(strip_tags($_GET['etos'])):$etos='2017';
      //  isset($_GET['mhnas'])? $etos=htmlspecialchars(strip_tags($_GET['mhnas'])):$mhnas='01';
      // if (isset($_GET['etos'])) {
       //      $etos=htmlspecialchars(strip_tags($_GET['etos']));
       //     $mhnas=htmlspecialchars(strip_tags($_GET['mhnas']));
      // }
    //        $created=date('Y-m-d H:i:s');

    $result_cities = $mysqli->query("SELECT id, city from cities order by 2"); // Διαβάζει τις κατηγορίες των άρθρων
    $cities_array = array(); //Πίνακας που αποθηκευει τις κατηγορίες των άρθρων
    //while ($row_cities = $result_cities->fetch_assoc()) {
    //array_push($subscriber_categories_array,$row_subscriber["id_category"]);
     //}
    $cities_array = $result_cities->fetch_all(MYSQLI_ASSOC);
//ΠΙΝΑΚΑΣ ΔΡΟΜΟΛΟΓΙΩΝ
    $result_routes = $mysqli->query("SELECT id_route,name  from routes order by 2"); // Διαβάζει τις κατηγορίες των άρθρων
    $routes_array = array(); //Πίνακας που αποθηκευει τις κατηγορίες των άρθρων
    //while ($row_cities = $result_cities->fetch_assoc()) {
    //array_push($subscriber_categories_array,$row_subscriber["id_category"]);
     //}
    $routes_array = $result_routes->fetch_all(MYSQLI_ASSOC);



//ΤΕΛΟΣ ΠΙΝΑΚΑΣ ΔΡΟΜΟΛΓΙΩΝ

      //   $etos= substr($max_period,0,4);
      //  $mhnas=substr($max_period,4,2);
       // isset($_GET['etos'])? $etos=htmlspecialchars(strip_tags($_GET['etos'])):$etos='2017';
      //  isset($_GET['mhnas'])? $etos=htmlspecialchars(strip_tags($_GET['mhnas'])):$mhnas='01';
      // if (isset($_GET['etos'])) {
       //      $etos=htmlspecialchars(strip_tags($_GET['etos']));
       //     $mhnas=htmlspecialchars(strip_tags($_GET['mhnas']));
      // }
    //        $created=date('Y-m-d H:i:s');



?>

<!DOCTYPE html>
<html>
<head>
 <?php
        include("head.php");
?>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
.dropdown-submenu {
    position: relative;
}

.dropdown-submenu .dropdown-menu {
    top: 0;
    left: 100%;
    margin-top: -1px;
}
</style>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>ΕΦΗΜΕΡΙΔΑ ΚΑΜΜΕΝΟΣ - ΣΕΛΙΔΑ ΕΓΓΡΑΦΗΣ</title>
</head>
<body class="hold-transition skin-blue sidebar-mini">
<?php
        include("header.php");
?>

 <div class="content-wrapper">
    <section class="content-header">
      <h1>
        Πίνακας Ελέγχου
        <small>Control panel</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="index.php"><i class="fa fa-dashboard"></i> Αρχική</a></li>
        <li class="active">Πίνακας Ελέγχου</li>
      </ol>
    </section>
    <section class="content">
      <div class="row">
         <div class="col-md-12">
           <div class="box box-warning">
             <div class="box-header with-border">

            <div class="register-logo">
              <a href="index.php"><p class="text-info"><b>ΚΤΕΛ ΑΙΤΩΛΝΙΑΣ</b> ΔΡΟΜΟΛΟΓΙΑ</p></a>
            </div>
              <p class="login-box-msg"><b>Οθόνη εισαγωγής δρομολογιών</b></br>Καταχωρήστε νέα εγγραφή</p>
              <div class="box-tools pull-right">
                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                </button>
              </div>

        </div>
        <div class="box-body">
        <form action="" onsubmit="return validateForm_city()"  method="post">
        <div class="form-row">
          <div class="form-group">
            <label for="routes">ΔΡΟΜΟΛΟΓΙΑ</label>
               <select class="form-control select2" id="route" name="routeName"  style="width: 100%;">
                  <?php
                  for ($l=0;$l <count($routes_array);$l++) {
                      ?>
                      <option  value="<?=$routes_array[$l]["id_route"];?>"><?=$routes_array[$l] ["name"];?></option>
                      <?php
                      }

                      ?>
                </select>
              </div>
         </div>
        <div class="form-row">
                <div class="form-group">
            <label for="city_from">Αφετηρία</label>
               <select class="form-control select2" id="city_from" name="city_from"  style="width: 100%;">
                  <?php
                  for ($l=0;$l <count($cities_array);$l++) {
                      ?>
                      <option  value="<?=$cities_array[$l]["id"];?>"><?=$cities_array[$l] ["city"];?></option>
                      <?php
                      }

                      ?>
                </select>
              </div>
            <div class="form-group">
            <label for="city_from">Προορισμός</label>
               <select class="form-control select2" id="city_το" name="city_το"  style="width: 100%;">
                  <?php
                  for ($l=0;$l <count($cities_array);$l++) {
                      ?>
                      <option  value="<?=$cities_array[$l]["id"];?>"><?=$cities_array[$l] ["city"];?></option>
                      <?php
                      }

                      ?>
                </select>
              </div>
          </div>
          <div class="row clearfix">
              <div class="col-md-12 column">
                  <table class="table table-bordered table-hover" id="tab_logic">
                      <thead>
                          <tr >
                              <th class="text-center">
                                  #
                              </th>
                              <th class="text-center">
                                  Ώρα
                              </th>
                              <th class="text-center">
                                  Δευτέρα
                              </th>
                              <th class="text-center">
                                  Τρίτη
                              </th>
                              <th class="text-center">
                                  Τετάρτη
                              </th>
                              <th class="text-center">
                                  Πέμπτη
                              </th>
                              <th class="text-center">
                                  Παρασκευή
                              </th>
                              <th class="text-center">
                                  Σαββάτο
                              </th>
                              <th class="text-center">
                                  Κυριακή
                              </th>
                              <th class="text-center">
                                  Express
                              </th>
                              <th class="text-center">
                                  Με ανταπόκριση
                              </th>
                              <th class="text-center">
                                  Σημειώσεις
                              </th>
                          </tr>
                      </thead>
                      <tbody>
                          <tr id='addr0'>
                              <td>
                              1
                              </td>
                              <td class="text-center">
                                  <input id="timepicker1" type="time" id="timeDep" name='timeDep[]' class="form-control input-small">
                              </td>
                              <td>
                                <input class="form-check-input text-center" name='deftera[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-check-input" name='triti[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-check-input" name='tetarti[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-check-input" name='pempti[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-check-input" name='paraskevi[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-check-input" name='savato[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-check-input" name='kyriaki[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-check-input" name='exrpess[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-check-input" name='antapokrisi[]' type="checkbox" >
                              </td>
                              <td>
                                <input class="form-control" name='notes[]' type="text" >
                              </td>
                          </tr>
                          <tr id='addr1'></tr>
                      </tbody>
                  </table>
              </div>
          </div>
          <a id="add_row" class="btn btn-default pull-left">Προσθήκη γραμμής</a>
          <a id='delete_row' class="pull-right btn btn-default">Διαγραφή γραμμής</a>
          <!-- <a id='clone_row' class="pull-right btn btn-default">Κλωνοποίηση γραμμής</a> -->
            <button type="submit" class="btn btn-primary btn-flat pull-left">Απαοθήκευση</button>
        </form>
      </div>
      <div class="box-footer clearfix no-border">
        <!-- <button type="button" class="btn btn-default pull-right"><i class="fa fa-plus"></i> Add item</button> -->
      </div>
    </div>
  </div>
</div>
  <!-- Στατιστικά για συνδρομές - Κουτί - Πίνακας -->



    </section>

    </div>
<?php
        include("footer.html");
        include("aside.php");
  ?>
</div>
<?php
 include("end_js_scripts.html");
include("end_scripts.html");
?>

<script>
$(document).ready(function(){
  $('.dropdown-submenu a.test').on("click", function(e){
    $(this).next('ul').toggle();
    e.stopPropagation();
    e.preventDefault();
  });
  var i=1;
$("#add_row").click(function(){
  $('#addr'+i).html("<td>"+ (i+1) +"<td>    <input id='timepicker1' type='time' name='timeDep[]' class='form-control input-small'></td>"
  +"<td><input class='form-check-input' name='deftera[]' type='checkbox' ></td>"+
  "  <td>      <input class='form-check-input' name='triti[]' type='checkbox'>    </td>"+
  "  <td>      <input class='form-check-input' name='tetarti[]' type='checkbox'>   </td>"+
  "  <td>      <input class='form-check-input' name='pempti[]' type='checkbox'>    </td>"+
  " <td>      <input class='form-check-input' name='paraskevi[]' type='checkbox'>  </td>"+
  " <td>      <input class='form-check-input' name='savato[]' type='checkbox'>     </td>"+
  " <td>      <input class='form-check-input' name='kyriaki[]' type='checkbox'>    </td>"+
  " <td>      <input class='form-check-input' name='exrpess[]' type='checkbox'>    </td>"+
  " <td>      <input class='form-check-input' name='antapokrisi[]' type='checkbox'> </td>"+
  "<td><input class='form-control' name='notes[]' type='text' ></td>");

  $('#tab_logic').append('<tr id="addr'+(i+1)+'"></tr>');
  i++;
    $('input').iCheck({
      checkboxClass: 'icheckbox_square-blue',
      increaseArea: '20%' // optional
    });
});
});

</script>

</body>
</html>
