 <?
   require "functions.php";
$db_server = "localhost";
$db_user = "objednavky.20";
$db_passwd = "LE905326le8972";
$db_name = "objednavky_20";

$pripoj = mysql_connect ($db_server, $db_user, $db_passwd);
// vyber db
$vyber = mysql_select_db ($db_name);
@mysql_query("SET NAMES 'utf-8';");

error_reporting(0);
session_start();

 $hlavna_funkcia = $_GET["funkcia"];

if ($hlavna_funkcia == "vytvor_objednavku"){
 $result = mysql_query("SELECT * FROM nastavenia WHERE nazov LIKE 'cislo_objednavky' LIMIT 1");
 $cislo_objednavky = MySQL_Result($result, 0, "popis");
 $cislo_objednavky = $cislo_objednavky + 1;
 mysql_query("UPDATE nastavenia SET popis = '$cislo_objednavky' WHERE nazov LIKE 'cislo_objednavky'");
 
  mysql_query("INSERT INTO objednavky (cislo, otvorena, zdroj) VALUES ('$cislo_objednavky', '1', '1')");
  $id = mysql_insert_id();
  $_SESSION["objednavka"] = $id;  
  
  header("Location: objednavka_kategorie.php");
  Exit();
  
  } elseif ($hlavna_funkcia == "odhlasit_uzivatela"){
   $id_zariadenia_andr = $_SESSION["id_zariadenia"];
              session_destroy(); 
  
  if ($_GET["presmerovanie"] == "1"){
  header("Location: m-driver/index.php");  
  } elseif ($_GET["presmerovanie"] == "2"){
   session_start();
   $_SESSION["id_zariadenia"] = $id_zariadenia_andr;
  header("Location: m-driver/prihlasenie.php");  
  } else {
  header("Location: objednavka_kategorie.php");
  }
  
  Exit();
  
  }


      $cislo_objednavky_dest = $_POST["id"];  
    $result_dest = mysql_query("SELECT * FROM objednavky WHERE id LIKE $cislo_objednavky_dest AND stav LIKE 0");
   $spolu_objednavka_dest = MySQL_Result($result_dest, 0, "spolu");
   $osobny_odber = MySQL_Result($result_dest, 0, "osobny_odber");
   $cena_doprava_dest = MySQL_Result($result_dest, 0, "cena_doprava");
   $zlava = MySQL_Result($result_dest, 0, "zlava");
     if($spolu_objednavka_dest == ""){

     $hlasenie = "1";
      $_POST["id"] = "";
     }


if ($_POST["id"] > 0){

$objednavka = $_POST["id"];
$meno = $_POST["meno"];
$ulica = $_POST["ulica"];
$mesto = $_POST["mesto"];
$email = $_POST["email"];
$telefon = $_POST["full_number"];
$poznamka = $_POST["poznamka"];
$platba = $_POST["paymentMethod"];
$typ_objednavky = $_POST["typobjednavky"];
$cas_prijatia = time();
$cas_expiracia_web = "0";
$datum_dorucenia = $_POST["datum_dorucenia"];
$cas_objednavky = $_POST["casobjednavky"];
$casovka_cas = $_POST["casovka_cas"];

if ($platba == "1"){
$hlasenie = "3"; 
} else {
$hlasenie = "2";
}

if ($osobny_odber == "1"){
$spolu_objednavka_celkom = $spolu_objednavka_dest - $cena_doprava_dest;
$cena_doprava_celkom = "0";

mysql_query("UPDATE objednavky SET cena_doprava = '$cena_doprava_celkom', spolu = '$spolu_objednavka_celkom' WHERE id LIKE '$objednavka'");
} else {
$spolu_objednavka_celkom = $spolu_objednavka_dest;
} 

      $telefon_prihlaseny = $_SESSION["telefon"];
      $zaciatok_cisla = strlen($telefon_prihlaseny);
        $kredit = kredity_uzivatel();
        

   if ($zaciatok_cisla > 9 && $kredit > 0){

        if ($kredit > $spolu_objednavka_celkom){
        $kredit_zobraz = $spolu_objednavka_celkom;
        $spolu_objednavka = "0.00";
        $zlava_nova = $zlava - $kredit_zobraz;
        $kredit_aktual = $kredit - $kredit_zobraz;
        mysql_query("UPDATE objednavky SET spolu = '$spolu_objednavka', zlava = '$zlava_nova' WHERE id LIKE '$objednavka'");
        mysql_query("UPDATE kredity SET kredit = '$kredit_aktual' WHERE telefon LIKE '$telefon_prihlaseny'");
        
        } else {
        $spolu_objednavka = $spolu_objednavka - $kredit;
        $kredit_zobraz = $kredit;
        $zlava_nova = $zlava - $kredit_zobraz;
        $kredit_aktual = $kredit - $kredit_zobraz;
        mysql_query("UPDATE objednavky SET spolu = '$spolu_objednavka', zlava = '$zlava_nova' WHERE id LIKE '$objednavka'");
        mysql_query("UPDATE kredity SET kredit = '$kredit_aktual' WHERE telefon LIKE '$telefon_prihlaseny'");
       }

    }
 
if ($datum_dorucenia == ""){
$datum_dorucenia = date("Y-m-d", time());
}


if ($cas_objednavky == "1"){
 $cas_objednavky_text = "now";
} else {
 $casovka_cas_vyp = strtotime("".$casovka_cas."");
 $cas_objednavky_text = date("H:i:s d.m.",$casovka_cas_vyp);
} 

if ($typ_objednavky == "2"){
$stav = "8";
$cas_ocak_dorucenia = time();
$cas_dorucenia = time();
} else {

if ($platba == "1"){
$stav = "0";
} else {
$stav = "1";
}

$cas_ocak_dorucenia = "0";
$cas_dorucenia = "0";
}


if ($telefon == "+421905904104"){
$stav = "9";
$hlasenie = "1";
} else {
$stav = $stav;
}

function ipadresa(){
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
    $ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
    $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
    $ip = $_SERVER['REMOTE_ADDR'];
}
return $ip;
}



$ipcka = ipadresa();

mysql_query("UPDATE objednavky SET meno = '$meno', ulica = '$ulica', mesto = '$mesto', dorucenie = '$cas_objednavky_text', datum_dorucenia = '$datum_dorucenia', telefon = '$telefon', email = '$email', cas_expiracia_web = '$cas_expiracia_web', popis = '$poznamka', cas_prijatia = '$cas_prijatia', cas_ocak_dorucenia = '$cas_ocak_dorucenia', cas_dorucenia = '$cas_dorucenia', otvorena = '0', platba_typ = '$platba', platba_ok = '0', stav = '$stav', ipcka='$ipcka' WHERE id LIKE '$objednavka'");

function over_akcia($id){
$result = mysql_query("SELECT * FROM nastavenia WHERE nazov = '$id' ORDER BY id DESC");
$hodnota = MySQL_Result($result, "0", "popis");
return $hodnota;
}

$akcia = over_akcia("akcia_cocacola_1520");
$cas_akcia = date("H", time());


if ($akcia == "1" && $cas_akcia > 14){
mysql_query("INSERT INTO polozky_objednavky (id_objednavka,nazov, suma, kusy, poznamka) VALUES ('$objednavka','Coca-Cola 0,33l', '0.00', '1', 'Ku každému jedlu jedna plechovka.')");

}

function over_buduce_polozky($cislo_telefon){
		$g = "SELECT * FROM polozky_buduce WHERE telefon LIKE '$cislo_telefon' AND polozky_buduce LIKE 0";
		$h = mysql_query($g);
	    $rowcount=mysql_num_rows($h);

return $rowcount;    
}

function pridaj_do_objednavky($cislo_telefon,$objednavka){
		$g = "SELECT * FROM polozky_buduce WHERE telefon LIKE '$cislo_telefon' AND polozky_buduce LIKE 0";
		$h = mysql_query($g);
        
	   while($row=mysql_fetch_array($h)){
       $id_buduce = $row['id'];
       $nazov = $row['nazov'];
       $mnozstvo = $row['kusy'];
mysql_query("INSERT INTO polozky_objednavky (id_objednavka,nazov, suma, kusy, poznamka) VALUES ('$objednavka','$nazov', '0.00', '$mnozstvo', '')");
mysql_query("UPDATE polozky_buduce SET pouzite = '1' WHERE id LIKE '$id_buduce'");
}    
}


      $buduce_objednavky_pocet = over_buduce_polozky($telefon);
      if ($buduce_objednavky_pocet > 0){
      pridaj_do_objednavky ($telefon, $objednavka);
    } 
    




  $_SESSION["objednavka"] = "";  

$resulte = mysql_query("SELECT * FROM kredity WHERE telefon LIKE '$telefon' LIMIT 1");
 $id_telefonu = MySQL_Result($resulte, 0, "id");

 if ($id_telefonu > 0) {
mysql_query("UPDATE kredity SET meno = '$meno', ulica = '$ulica', mesto = '$mesto', email = '$email', poznamka = '$poznamka' WHERE id LIKE '$id_telefonu'");
 } else {
 
 
 if ($typ_objednavky == "2"){
 
 } else {
 
 mysql_query("INSERT INTO kredity (meno, ulica, mesto, telefon, email, poznamka, platba_fakturou, platba_kartou, platba_hotovost) VALUES ('$meno', '$ulica', '$mesto','$telefon','$email','$poznamka','0','1','1')");
 zaradit_newsletter($email,$meno);
 } 
 }






    
}


 
?>
<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">
    <meta name="generator" content="Jekyll v3.8.5">
    <link rel="shortcut icon" type="image/x-icon" href="css/ikona.ico" />
    <title>Objednávka odoslaná</title>
             <script src="/js/bootstrap.min.js"></script>
 <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
      <script>window.jQuery || document.write('<script src="/docs/4.3/assets/js/vendor/jquery-slim.min.js"><\/script>')</script><script src="/docs/4.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-xrRywqdh3PHs8keKZN+8zzc5TX0GRTLCcmivcbNJWm2rs5C8PRhcEn3czEjhAO9o" crossorigin="anonymous"></script>
        <!-- Bootstrap core CSS -->
<link href="/css/bootstrap.min.css" rel="stylesheet">

    <style>
      .bd-placeholder-img {
        font-size: 1.125rem;
        text-anchor: middle;
        -webkit-user-select: none;
        -moz-user-select: none;
        -ms-user-select: none;
        user-select: none;
      }

      @media (min-width: 768px) {
        .bd-placeholder-img-lg {
          font-size: 3.5rem;
        }
      }
      
            .pozadie {
    background-color: rgba(0, 0, 0, 0);
    background-repeat: no-repeat;
    background-image: url('pozadie.jpg');
    background-size: cover;
    background-position: center center;
    width: 100%;
    height: 100%;
    opacity: 1;
    visibility: inherit;
    z-index: 20;
        font-family: -apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",Arial,"Noto Sans",sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";
}
    </style>
    <!-- Custom styles for this template -->
    <script async src="https://www.googletagmanager.com/gtag/js?id=UA-20522907-9"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'UA-20522907-9');
</script>

  </head>
  <body class="pozadie" >
  <div class="modal fade" id="exampleModalCenterplatba" style="" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
  <div class="modal-dialog modal-dialog-centered" role="document">
    <div class="modal-content">
                <div class="overlay">
                <span class="fas fa-spinner fa-spin fa-2x w-100"></span> Loading...
            </div>
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalCenterTitle">Platba kartou</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">               
               <iframe src="about:blank" id="framec" width="100%" height="100%" style="min-height:280px;"frameborder="0" scrolling="no" allowtransparency="true"></iframe>  
      </div>
    </div>
  </div>
</div>
  
    <div class="container" id="kontajner">
  <div class="py-5 text-center">
    
<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">
    <meta name="generator" content="Jekyll v3.8.5">
    <title>Objednávka</title>


    <!-- Bootstrap core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet" >


    <style>
      .bd-placeholder-img {
        font-size: 1.125rem;
        text-anchor: middle;
        -webkit-user-select: none;
        -moz-user-select: none;
        -ms-user-select: none;
        user-select: none;
      }

      @media (min-width: 768px) {
        .bd-placeholder-img-lg {
          font-size: 3.5rem;
        }
      }
    </style>
    <!-- Custom styles for this template -->
    <link href="form-validation.css" rel="stylesheet">
  </head>

<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
      <script>window.jQuery || document.write('<script src="/docs/4.3/assets/js/vendor/jquery-slim.min.js"><\/script>')</script><script src="/js/bootstrap.bundle.min.js" integrity="sha384-xrRywqdh3PHs8keKZN+8zzc5TX0GRTLCcmivcbNJWm2rs5C8PRhcEn3czEjhAO9o" crossorigin="anonymous"></script>
     
      <?
      if ($_GET["menu"] == "okej"){
      ?>
      <img src="css/okej.png" style="width:300px;">
        <h2>Objednávky odoslaná</h2><h2>Čas doručenia potvrdíme SMS</h2>
        <p class="lead">  <a href="objednavka_kategorie.php" class="btn btn-primary" style="margin-top:30px;">Vytvoriť novú objednávku</a></p>
       <meta http-equiv='refresh' content='1; URL=/objednavka_kategorie.php'> 
      <?
        Exit();
      } elseif ($_GET["menu"] == "chyba_token"){
      ?>
      <img src="css/chyba.png" style="width:300px;">
       <h2>Platba zlyhala</h2><h2>Zadajte prosím objednávku znovu</h2>
       <p class="lead">  <a href="objednavka_kategorie.php" class="btn btn-primary" style="margin-top:30px;">Vytvoriť novú objednávku</a></p>
      <?
  Exit();
      }
   
      ?>
            
      <?
      if ($hlasenie == "1"){
      ?>
      <img src="css/chyba.png" style="width:300px;">
       <h2>Chyba pri vytváraní objednávky</h2><h2>Zadajte prosím objednávku znovu</h2>
      <?
      } elseif  ($hlasenie == "2"){
      ?>
      <img src="css/okej.png" style="width:300px;">
        <h2>Objednávky odoslaná</h2><h2>Čas doručenia potvrdíme SMS</h2>
       <meta http-equiv='refresh' content='1; URL=/objednavka_kategorie.php'> 
                       <?
        } elseif  ($hlasenie == "3"){
           ?>
      <img src="css/karta.png" style="width:300px;">

        <h2>Čakáme na potvrdenie platby kartou.</h2><h2>V prípade problémov volajte 0949 000 948.</h2>
           <meta http-equiv='refresh' content='1; URL=pay_gp/platba.php?token=<? echo $objednavka;?>'>

<?
//       <script type="application/javascript">
//$(document).ready(function () { 
// $('#exampleModalCenterplatba').modal('show'); 
// $(".overlay").show();
// $("#framec").attr("src", "pay/index.php?token=echo $objednavka;");
// $(".overlay").hide();
// });
//</script>          

?>
          <?
        }
        
        if ($_SESSION["vrat_spat"] == "1"){
           ?>
  <meta http-equiv='refresh' content='1; URL=/m-driver/presmeruj_objednavku.php?operacia=navrat'>

<?
    }
?>
    <p class="lead">  <a href="objednavka_kategorie.php" class="btn btn-primary" style="margin-top:30px;">Vytvoriť novú objednávku</a></p>
  </div>

  <div class="row">

 <script type="application/javascript">
window.closeModal = function(){
    $('#kontajner').load('objednavka_kategorie.php #kontajner > *');
    $('#exampleModalCenterplatba').modal('hide');
};


</script>

  <footer class="my-5 pt-5 text-muted text-center text-small">
    <p class="mb-1">&copy; 2020 Kitchen, s.r.o.</p>
  </footer>
</div>


        </body>