';
}
else
{
echo '
';
}
}
elseif ($id_kat_orig == $sql['nadrazena'])
{
echo '';
if ($level == 0)
{
echo '';
}
else
{
echo '';
}
}
else
{
echo '';
echo '
';
$celkem += $doprava;
echo '
'; $celkem += $polozky['cena'] * $polozky['pocet']; } } $komu = $objednavka['mail']; $predmet = 'Nová objednávka na ' . $GLOBALS['web'] . ', č. ' . $objednavka['kod']; $text = 'Vážený zákazníku
Vaše objednávka byla přijata pod číslem ' . $objednavka['kod'] . '.
'; $text .= 'Objednané položky:
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
'; $text .= $pretext . '
'; $text .= 'Celkem: ' . $celkem . ',- Kč s DPH
'; $text .= '= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
'; $text .= 'Poznámka: ' . $objednavka['poznamka'] . '
'; $text .= 'http://' . $GLOBALS['web'] . '/
'; $text .= '' . $GLOBALS['mail'] . '
'; $text .= 'tel: '.$GLOBALS['phone'].'
'; #$text .= 'mobil: +420 777 338 717
'; $hlavicka = 'Content-type: text/html; charset=UTF-8' . "\n" . "Content-Transfer-Encoding: 8bit" . "\n" . 'From: <' . $GLOBALS['mail'] . '>' . "\n" . 'Reply-To: <' . $GLOBALS['mail'] . '>' . "\n" . 'X-Mailer: PHP/' . phpversion (); mail ($komu, mail_encode ($predmet), $text, $hlavicka); } function send_mail_new_obj_admin ($kod) { $objednavka = mysql_fetch_array (mysql_query ("SELECT * FROM shop_objednavky WHERE kod = '$kod' LIMIT 1")); $polozky_s = mysql_query ("SELECT * FROM shop_objednavky_polozky WHERE id_objednavky = '" . $objednavka['id_objednavky'] . "' ORDER BY doprava ASC"); while ($polozky = mysql_fetch_array ($polozky_s)) { if ($polozky['doprava'] == '1' AND $polozky['cena'] == '0') { $pretext .= $polozky['pocet'] . 'ks ' . $polozky['nazev'] . ' - zdarma
'; $celkem += $polozky['cena'] * $polozky['pocet']; } else { $pretext .= $polozky['pocet'] . 'ks ' . $polozky['nazev'] . ' za cenu ' . $polozky['cena'] * $polozky['pocet'] . ',-Kč s DPH
'; $celkem += $polozky['cena'] * $polozky['pocet']; } } $komu = $GLOBALS['mail']; $predmet = 'Nová objednávka na ' . $GLOBALS['web'] . ', č. ' . $objednavka['kod']; $text = 'Zákazník ' . $objednavka['prijmeni'] . ' ' . $objednavka['jmeno'] . ' vytvořil objednávku s číslem ' . $objednavka['kod'] . '.
'; $text .= 'Objednané položky:
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
'; $text .= $pretext . '
'; $text .= 'Celkem: ' . $celkem . ',- Kč s DPH
'; $text .= '= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
'; $text .= 'Poznámka: ' . $objednavka['poznamka'] . '
'; $text .= 'http://' . $GLOBALS['web'] . '/
'; $text .= '' . $GLOBALS['mail'] . '
'; $text .= 'tel: +420 775 330 930
'; #$text .= 'mobil: +420 777 338 717
'; $hlavicka = 'Content-type: text/html; charset=UTF-8' . "\n" . "Content-Transfer-Encoding: 8bit" . "\n" . 'From: <' . $GLOBALS['mail'] . '>' . "\n" . 'Reply-To: <' . $GLOBALS['mail'] . '>' . "\n" . 'X-Mailer: PHP/' . phpversion (); mail ($komu, mail_encode ($predmet), $text, $hlavicka); } function send_mail_new_user ($mail, $password) { $komu = $mail; $predmet = 'Přihlášení na ' . $GLOBALS['web'] . ''; $text = 'Vážený zákazníku
Vaše heslo pro přihlášení je ' . $password . '
'; $text .= 'http://' . $GLOBALS['mail'] . '/
'; $text .= '' . $GLOBALS['mail'] . '
'; $text .= 'tel: +420 775 330 930
'; #$text .= 'mobil: +420 777 338 717
'; $hlavicka = 'Content-type: text/html; charset=UTF-8' . "\n" . "Content-Transfer-Encoding: 8bit" . "\n" . 'From: <' . $GLOBALS['mail'] . '>' . "\n" . 'Reply-To: <' . $GLOBALS['mail'] . '>' . "\n" . 'X-Mailer: PHP/' . phpversion (); mail ($komu, mail_encode ($predmet), $text, $hlavicka); } ?>'; // debug_print_backtrace(); if (!class_exists($function_name, false) || !interface_exists($function_name, false)) { //print $function_name.BR; require_once ($function_name.'.php'); } } ?>
Fatal error: Uncaught Error: Class 'javascript' not found in /var/www/client-09-pohanova-lucie/centrumstastnehodetstvi.cz/web/index.php:31 Stack trace: #0 {main} thrown in /var/www/client-09-pohanova-lucie/centrumstastnehodetstvi.cz/web/index.php on line 31
';
}
else
{
echo '';
}
}
else
{
echo '';
if (isset ($GLOBALS['menu_check']))
{
$search = in_array ($sql['id_kat'], $GLOBALS['menu_check']);
}
if ($level == 0)
{
if ($search == true)
{
echo '';
}
else
{
echo '
';
}
}
else
{
echo '';
}
}
#echo '';
#echo '';
$cyk = $level;
while ($cyk != 0)
{
#echo '';
$cyk = $cyk - 1;
}
if ($id_kat_orig == $sql['id_kat'] AND $id_zbozi == "")
{
echo '' . $sql['nazev'] . '';
}
else
{
echo '' . $sql['nazev'] . '';
}
echo '';
echo '
';
echo '';
if (isset ($menu_check))
{
foreach ($menu_check as $m_c)
{
if ($m_c == $sql['id_kat'])
{
menu ($sql['id_kat'], $menu_check, $level + 1, $id_kat_orig, $id_zbozi);
}
}
}
}
}
function navigace ($id_kat, $menu_check)
{
if (isset ($menu_check))
{
krsort ($menu_check);
foreach ($menu_check as $m_c)
{
$sql = mysql_fetch_array (mysql_query ("SELECT nazev, id_kat, nadrazena FROM shop_kategorie WHERE id_kat = '$m_c' LIMIT 1"));
if ($sql['nadrazena'] == "0")
{
echo '
';
}
else
{
echo '
';
}
}
}
echo '';
}
function navigace2 ($id_kat)
{
$old_mezera = '/ /';
$new_mezera = ' ';
$cyk = 0;
$sql_sql = mysql_query ("SELECT nazev, id_kat FROM shop_kategorie WHERE nadrazena = '$id_kat' ORDER BY poradi ASC");
while ($sql = mysql_fetch_array ($sql_sql))
{
$GLOBALS['pocet_zbozi'] = 0;
pocet_zbozi ($sql['id_kat']);
$nazev = preg_replace ($old_mezera, $new_mezera, $sql['nazev']);
if ($cyk == "0")
{
echo '
';
$cyk++;
}
else
{
echo '
';
}
}
echo '';
}
function pocet_zbozi ($id_kat)
{
$sql_sql = mysql_query ("SELECT count(0) AS pocet FROM shop_zbozi WHERE id_kat = '$id_kat' AND zapnuto = 1");
$sql = mysql_fetch_array ($sql_sql);
$GLOBALS['pocet_zbozi'] = $GLOBALS['pocet_zbozi'] + $sql['pocet'];
$sql_sql2 = mysql_query ("SELECT id_kat FROM shop_kategorie WHERE nadrazena = '$id_kat'");
while ($sql2 = mysql_fetch_array ($sql_sql2))
{
pocet_zbozi ($sql2['id_kat']);
}
}
function menu_check ($id_kat)
{
$sql_sql = mysql_query ("SELECT id_kat, nadrazena FROM shop_kategorie WHERE id_kat = '$id_kat' LIMIT 1");
while ($sql = mysql_fetch_array ($sql_sql))
{
$GLOBALS['menu_check'][] = $sql['id_kat'];
menu_check ($sql['nadrazena']);
}
}
function check_id_kat ($id_zbozi)
{
$sql = mysql_fetch_array (mysql_query ("SELECT id_kat FROM shop_zbozi WHERE id_zbozi = '$id_zbozi' LIMIT 1"));
return $sql['id_kat'];
}
function check_dostupnost ($dostupnost)
{
$sql = mysql_fetch_array (mysql_query ("SELECT nazev FROM shop_zbozi_dostupnost WHERE id_dostupnost = '$dostupnost' LIMIT 1"));
return $sql['nazev'];
}
function zbozi ($id_kat)
{
if ($_SESSION['razeni_typ'] == "nazev")
{
$order = " nazev";
}
elseif ($_SESSION['razeni_typ'] == "ceny")
{
$order = " cena";
}
else
{
$order = " poradi";
};
if ($_SESSION['razeni_smer'] == "down")
{
$order .= " DESC";
}
else
{
$order .= " ASC";
};
if ($_SESSION['vyrobce'] == "0")
{
$where = " AND id_vyrobci != '" . $_SESSION['vyrobce'] . "'";
}
else
{
$where = " AND id_vyrobci = '" . $_SESSION['vyrobce'] . "'";
}
if ($_SESSION['search'] != "")
{
$pole_w = explode (" ", $_SESSION['search']);
foreach ($pole_w AS $pole)
{
$where .= " AND nazev LIKE '%" . $pole . "%'";
}
}
if ($_SESSION['search'] != "")
{
$sql_sql = mysql_query ("SELECT shop_zbozi.nazev, shop_zbozi.cena, shop_zbozi.id_zbozi FROM shop_zbozi WHERE shop_zbozi.varianta_poradi = 2 AND shop_zbozi.zapnuto = 1" . $where . " ORDER BY " . $order);
}
else
{
$sql_sql = mysql_query ("SELECT shop_zbozi.nazev, shop_zbozi.cena, shop_zbozi.id_zbozi FROM shop_zbozi WHERE id_kat = '$id_kat' AND shop_zbozi.varianta_poradi = 2 AND shop_zbozi.zapnuto = 1" . $where . " ORDER BY " . $order);
}
$cyk = 0;
while ($sql = mysql_fetch_array ($sql_sql))
{
echo '';
}
else
{
echo '';
}
}
else
{
echo '';
}
}
#echo '';
#echo '';
$cyk = $level;
while ($cyk != 0)
{
#echo '';
$cyk = $cyk - 1;
}
if ($id_kat_orig == $sql['id_kat'] AND $id_zbozi == "")
{
echo '' . $sql['nazev'] . '';
}
else
{
echo '' . $sql['nazev'] . '';
}
echo '';
echo '';
echo '
';
$cyk++;
if ($cyk == 4)
{
echo '';
echo '';
$cyk = 0;
}
}
}
function zbozi2 ($id_kat)
{
if ($_SESSION['razeni_typ'] == "nazev")
{
$order = " nazev";
}
elseif ($_SESSION['razeni_typ'] == "ceny")
{
$order = " cena";
}
else
{
$order = " poradi";
};
if ($_SESSION['razeni_smer'] == "down")
{
$order .= " DESC";
}
else
{
$order .= " ASC";
};
if ($_SESSION['vyrobce'] == "0")
{
$where = " AND id_vyrobci != '" . $_SESSION['vyrobce'] . "'";
}
else
{
$where = " AND id_vyrobci = '" . $_SESSION['vyrobce'] . "'";
}
if ($_SESSION['search'] != "")
{
$pole_w = explode (" ", $_SESSION['search']);
foreach ($pole_w AS $pole)
{
$where .= " AND nazev LIKE '%" . $pole . "%'";
}
}
if ($_SESSION['search'] != "")
{
$sql_sql = mysql_query ("SELECT shop_zbozi.nazev, shop_zbozi.cena, shop_zbozi.id_zbozi FROM shop_zbozi WHERE shop_zbozi.varianta_poradi = 2 AND shop_zbozi.zapnuto = 1" . $where . " ORDER BY " . $order);
}
else
{
$sql_sql = mysql_query ("SELECT shop_zbozi.nazev, shop_zbozi.cena, shop_zbozi.id_zbozi FROM shop_zbozi WHERE id_kat1 = '$id_kat' OR id_kat2 = '$id_kat' OR id_kat3 = '$id_kat' AND shop_zbozi.varianta_poradi = 2 AND shop_zbozi.zapnuto = 1" . $where . " ORDER BY " . $order);
}
while ($sql = mysql_fetch_array ($sql_sql))
{
echo '';
echo '
';
$stitky_s = mysql_query ("
SELECT shop_stitky.*
FROM shop_zbozi_stitky, shop_stitky
WHERE shop_zbozi_stitky.id_zbozi = '" . $sql['id_zbozi'] . "' AND shop_stitky.id_stitky = shop_zbozi_stitky.id_stitky");
$width = '18';
while ($stitky = mysql_fetch_array ($stitky_s))
{
echo '';
echo '' . $sql['nazev'] . "";
echo '
';
echo '' . $stitky['text'] . '
';
$width += '18';
}
echo '';
$sql_img = mysql_fetch_array (mysql_query ("SELECT file FROM shop_zbozi_image WHERE id_zbozi = " . $sql['id_zbozi'] . " ORDER BY hlavni DESC LIMIT 1"));
if ($sql_img['file'] == "")
{
echo '
';
}
else
{
echo '
';
}
echo '
';
echo '';
}
else
{
echo '';
echo '
';
echo '' . $sql['cena'] . ',- Kč
';
echo '';
echo '';
echo '
';
$cyk++;
if ($cyk == 4)
{
echo '';
echo '';
$cyk = 0;
}
}
}
function aktualni_kategorie ($id_kat)
{
$sql = mysql_fetch_array (mysql_query ("SELECT nazev FROM shop_kategorie WHERE id_kat = '$id_kat' LIMIT 1"));
echo $sql['nazev'];
}
function zbozi_nacist ($id_zbozi)
{
$sql = mysql_fetch_array (mysql_query ("SELECT * FROM shop_zbozi WHERE id_zbozi = $id_zbozi LIMIT 1"));
return $sql;
}
function zbozi_obrazek_hlavni ($id_zbozi)
{
$sql = mysql_fetch_array (mysql_query ("SELECT file FROM shop_zbozi_image WHERE id_zbozi = " . $id_zbozi . " ORDER BY hlavni DESC, id_img ASC LIMIT 1"));
if ($sql['file'] == "")
{
echo 'none.jpg';
}
else
{
echo $sql['file'];
}
}
function zbozi_obrazek_vedlejsi ($id_zbozi)
{
$sql_s = mysql_query ("SELECT file FROM shop_zbozi_image WHERE id_zbozi = " . $id_zbozi . " ORDER BY hlavni DESC, id_img ASC LIMIT 1,100");
return $sql_s;
}
function zbozi_obrazek_hlavni_return ($id_zbozi)
{
$sql = mysql_fetch_array (mysql_query ("SELECT file FROM shop_zbozi_image WHERE id_zbozi = " . $id_zbozi . " ORDER BY hlavni DESC, id_img ASC LIMIT 1"));
if ($sql['file'] == "")
{
return 'none.jpg';
}
else
{
return $sql['file'];
}
}
function zbozi_varianty ($varianta, $id_zbozi)
{
$sql_sql = mysql_query ("SELECT id_zbozi,nazev FROM shop_zbozi WHERE varianta = '$varianta' ORDER BY varianta_poradi ASC");
if (mysql_num_rows ($sql_sql) > 1)
{
echo '';
echo '
';
$stitky_s = mysql_query ("
SELECT shop_stitky.*
FROM shop_zbozi_stitky, shop_stitky
WHERE shop_zbozi_stitky.id_zbozi = '" . $sql['id_zbozi'] . "' AND shop_stitky.id_stitky = shop_zbozi_stitky.id_stitky");
$width = '18';
while ($stitky = mysql_fetch_array ($stitky_s))
{
echo '';
echo '' . $sql['nazev'] . "";
echo '
';
echo '' . $stitky['text'] . '
';
$width += '18';
}
echo '';
$sql_img = mysql_fetch_array (mysql_query ("SELECT file FROM shop_zbozi_image WHERE id_zbozi = " . $sql['id_zbozi'] . " ORDER BY hlavni DESC LIMIT 1"));
if ($sql_img['file'] == "")
{
echo '';
}
else
{
echo '';
}
echo '
';
echo '';
}
else
{
echo '';
echo '
';
echo '' . $sql['cena'] . ',- Kč
';
echo '';
echo '';
echo '; ?>)
';
}
}
function novinky_zbozi_nacist ($id_zbozi)
{
$sql_sql = mysql_query ("
SELECT shop_zbozi.nazev, shop_zbozi.id_zbozi, shop_zbozi_image.file
FROM shop_zbozi,shop_zbozi_image
WHERE shop_zbozi.id_zbozi = '$id_zbozi' AND shop_zbozi.id_zbozi = shop_zbozi_image.id_zbozi
ORDER BY shop_zbozi_image.hlavni DESC
LIMIT 1");
while ($sql = mysql_fetch_array ($sql_sql))
{
echo '
 . ')
';
$cena += $sql['pocet'] * $sql['cena'];
}
echo '
Varianty zboží:
';
while ($sql = mysql_fetch_array ($sql_sql))
{
if ($id_zbozi == $sql['id_zbozi'])
{
}
else
{
?>';
echo '';
echo '
';
echo '
';
}
}
?>
' . $sql['nazev'] . '
' . $sql['pocet'] * $sql['cena'] . ',- Kč
' . $sql['pocet'] . ' ks
Cena celkem:
' . $cena . ',- Kč
';
}
function seznam_kosik2 ()
{
$celkem = '0';
$sql_sql = mysql_query ("
SELECT shop_kosik.pocet, shop_kosik.id_kosik, shop_zbozi.*
FROM shop_kosik, shop_zbozi
WHERE shop_kosik.id_zbozi = shop_zbozi.id_zbozi AND shop_kosik.id_session = '" . $_SESSION['id_session'] . "'
ORDER BY shop_kosik.id_kosik ASC");
echo '| Položka | cena | počet | celkem |
|---|---|---|---|
| ' . $sql['nazev'] . ' | ' . $sql['cena'] . ',- | ' . $sql['pocet'] . 'x | ' . $sql['pocet'] * $sql['cena'] . ',- |
| Doprava: ' . $sql['nadpis'] . ' | ' . $doprava_text . ' | 1x | ' . $doprava_text . ' |
Celková hodnota objednávky: ' . $celkem . ',-
';
}
function check_kosik ()
{
$sql_sql = mysql_query ("
SELECT shop_kosik.pocet, shop_kosik.id_kosik, shop_zbozi.*
FROM shop_kosik, shop_zbozi
WHERE shop_kosik.id_zbozi = shop_zbozi.id_zbozi AND shop_kosik.id_session = '" . $_SESSION['id_session'] . "'
ORDER BY shop_kosik.id_kosik ASC LIMIT 1");
while ($sql = mysql_fetch_array ($sql_sql))
{
return true;
}
return false;
}
function check_extra ()
{
$sql_sql = mysql_query ("
SELECT shop_zbozi.extra
FROM shop_kosik, shop_zbozi
WHERE shop_kosik.id_zbozi = shop_zbozi.id_zbozi AND shop_kosik.id_session = '" . $_SESSION['id_session'] . "' AND shop_zbozi.extra = '1'
LIMIT 1");
while ($sql = mysql_fetch_array ($sql_sql))
{
return true;
}
return false;
}
function novy_user ($f_mail, $f_jmeno, $f_prijmeni, $f_firma, $f_ico, $f_dic, $f_ulice, $f_obec, $f_psc, $f_ulice_f, $f_obec_f, $f_psc_f, $f_telefon, $f_mobil, $f_fax)
{
$password = password ();
$password_c = sha1 ($password);
mysql_query ("INSERT INTO shop_user
(`mail`,`jmeno`,`prijmeni`,`firma`,`ico`,`dic`,`ulice`,`obec`,`psc`,`ulice_f`,`obec_f`,`psc_f`,`telefon`,`mobil`,`fax`,`password`)
VALUES
('$f_mail','$f_jmeno','$f_prijmeni','$f_firma','$f_ico','$f_dic','$f_ulice','$f_obec','$f_psc','$f_ulice_f','$f_obec_f','$f_psc_f','$f_telefon','$f_mobil','$f_fax','$password_c')
");
$_SESSION['id_user'] = mysql_insert_id ();
mysql_query ("UPDATE shop_kosik SET id_user = '" . $_SESSION['id_user'] . "' WHERE id_session = '" . $_SESSION['id_session'] . "'");
send_mail_new_user ($f_mail, $password);
}
function editace_user ($f_mail, $f_jmeno, $f_prijmeni, $f_firma, $f_ico, $f_dic, $f_ulice, $f_obec, $f_psc, $f_ulice_f, $f_obec_f, $f_psc_f, $f_telefon, $f_mobil, $f_fax)
{
mysql_query ("UPDATE shop_user SET
`mail` = '$f_mail',
`jmeno` = '$f_jmeno',
`prijmeni` = '$f_prijmeni',
`firma` = '$f_firma',
`ico` = '$f_ico',
`dic` = '$f_dic',
`ulice` = '$f_ulice',
`obec` = '$f_obec',
`psc` = '$f_psc',
`ulice_f` = '$f_ulice_f',
`obec_f` = '$f_obec_f',
`psc_f` = '$f_psc_f',
`telefon` = '$f_telefon',
`mobil` = '$f_mobil',
`fax` = '$f_fax'
WHERE mail = '$f_mail' LIMIT 1
");
$sql = mysql_fetch_array (mysql_query ("SELECT id_user FROM shop_user WHERE mail = '$f_mail' LIMIT 1"));
$_SESSION['id_user'] = $sql['id_user'];
mysql_query ("UPDATE shop_kosik SET id_user = '" . $sql['id_user'] . "' WHERE id_session = '" . $_SESSION['id_session'] . "'");
}
function kod_objednavky ()
{
$obj = mysql_fetch_array (mysql_query ("SELECT * FROM `shop_objednavky` ORDER BY `kod` DESC LIMIT 1"));
$cislo_o = $obj['kod'];
$cislo_u = substr ($cislo_o, 2, 5) + 1;
$cislo_l = strlen (substr ($cislo_o, 2, 5) + 1);
$datum_old = substr ($cislo_o, 0, 2);
$cislo = "";
$cislo .= date ('y');
if ($cislo_l == "1")
{
$cislo .= "0000" . $cislo_u;
}
elseif ($cislo_l == "2")
{
$cislo .= "000" . $cislo_u;
}
elseif ($cislo_l == "3")
{
$cislo .= "00" . $cislo_u;
}
elseif ($cislo_l == "4")
{
$cislo .= "0" . $cislo_u;
}
elseif ($cislo_l == "5")
{
$cislo .= $cislo_u;
}
if ($datum_old != date ('y'))
{
$cislo = "" . date ('y') . "00001";
};
return $cislo;
}
function objednat ()
{
$user = mysql_fetch_array (mysql_query ("SELECT * FROM shop_user WHERE id_user = '" . $_SESSION['id_user'] . "' LIMIT 1"));
$kod = kod_objednavky ();
$poznamka = $_SESSION['poznamka'];
mysql_query ("INSERT INTO shop_objednavky
(`mail`,`jmeno`,`prijmeni`,`firma`,`ico`,`dic`,`ulice`,`obec`,`psc`,`ulice_f`,`obec_f`,`psc_f`,`telefon`,`mobil`,`fax`,`kod`,`poznamka`)
VALUES
(
'" . $user['mail'] . "',
'" . $user['jmeno'] . "',
'" . $user['prijmeni'] . "',
'" . $user['firma'] . "',
'" . $user['ico'] . "',
'" . $user['dic'] . "',
'" . $user['ulice'] . "',
'" . $user['obec'] . "',
'" . $user['psc'] . "',
'" . $user['ulice_f'] . "',
'" . $user['obec_f'] . "',
'" . $user['psc_f'] . "',
'" . $user['telefon'] . "',
'" . $user['mobil'] . "',
'" . $user['fax'] . "',
'$kod',
'$poznamka'
)
");
$id_objednavky = mysql_insert_id ();
$sql_kosik = mysql_query ("
SELECT shop_kosik.pocet, shop_kosik.id_kosik, shop_zbozi.*
FROM shop_kosik, shop_zbozi
WHERE shop_kosik.id_zbozi = shop_zbozi.id_zbozi AND shop_kosik.id_session = '" . $_SESSION['id_session'] . "'
ORDER BY shop_kosik.id_kosik ASC");
while ($kosik = mysql_fetch_array ($sql_kosik))
{
$out = mysql_query ("INSERT INTO shop_objednavky_polozky (`id_objednavky`,`nazev`,`cena`,`pocet`,`kod`) VALUES
('$id_objednavky','" . $kosik['nazev'] . "','" . $kosik['cena'] . "','" . $kosik['pocet'] . "','" . $kosik['kod'] . "')");
$celkem += $kosik['pocet'] * $kosik['cena'];
mysql_query ("DELETE FROM shop_kosik WHERE id_kosik = '" . $kosik['id_kosik'] . "' LIMIT 1");
}
$doprava = mysql_fetch_array (mysql_query ("SELECT * FROM shop_doprava WHERE id_doprava = '" . $_SESSION['doprava'] . "'"));
if ($celkem > ($doprava['hranice'] - 1) AND $doprava['hranice'] != '0')
{
$doprava2 = '0';
}
else
{
$doprava2 = $doprava['cena'];
}
$out = mysql_query ("INSERT INTO shop_objednavky_polozky (`id_objednavky`,`nazev`,`cena`,`pocet`,`doprava`) VALUES
('$id_objednavky','" . $doprava['nadpis'] . "','" . $doprava2 . "','1','1')");
send_mail_new_obj ($kod);
send_mail_new_obj_admin ($kod);
return $kod;
}
function cena_kosik ()
{
$celkem = '0';
$sql_sql = mysql_query ("
SELECT shop_kosik.pocet, shop_zbozi.cena
FROM shop_kosik, shop_zbozi
WHERE shop_kosik.id_zbozi = shop_zbozi.id_zbozi AND shop_kosik.id_session = '" . $_SESSION['id_session'] . "'
ORDER BY shop_kosik.id_kosik ASC");
while ($sql = mysql_fetch_array ($sql_sql))
{
$celkem += $sql['pocet'] * $sql['cena'];
}
return $celkem;
}
function pocet_kosik ()
{
$celkem = '0';
$sql_sql = mysql_query ("
SELECT shop_kosik.pocet, shop_zbozi.cena
FROM shop_kosik, shop_zbozi
WHERE shop_kosik.id_zbozi = shop_zbozi.id_zbozi AND shop_kosik.id_session = '" . $_SESSION['id_session'] . "'
ORDER BY shop_kosik.id_kosik ASC");
while ($sql = mysql_fetch_array ($sql_sql))
{
$celkem += $sql['pocet'];
}
return $celkem;
}
?> ' . "\n" . 'Reply-To: <'.$GLOBALS['info_mail'].'>' . "\n" . 'X-Mailer: PHP/' . phpversion ();
mail ($komu, mail_encode ($predmet), $text, $hlavicka);
$send_new_password = '1';
}
else
{
$no_send_new_password = '1';
}
}
function password ()
{
$string = 'abcdefghijklmnpqrstuvwx123456789';
$pocet = strlen ($string);
$cely = '';
for ($prubeh = 0; $prubeh < 6; $prubeh++)
{
$cely .= strtoupper ($string[rand (0, $pocet - 1)]);
}
return $cely;
}
?>';
$celkem += $polozky['cena'] * $polozky['pocet'];
}
else
{
$pretext .= $polozky['pocet'] . 'ks ' . $polozky['nazev'] . ' za cenu ' . $polozky['cena'] * $polozky['pocet'] . ',-Kč s DPH'; $celkem += $polozky['cena'] * $polozky['pocet']; } } $komu = $objednavka['mail']; $predmet = 'Nová objednávka na ' . $GLOBALS['web'] . ', č. ' . $objednavka['kod']; $text = 'Vážený zákazníku
Vaše objednávka byla přijata pod číslem ' . $objednavka['kod'] . '.
'; $text .= 'Objednané položky:
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
'; $text .= $pretext . '
'; $text .= 'Celkem: ' . $celkem . ',- Kč s DPH
'; $text .= '= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
'; $text .= 'Poznámka: ' . $objednavka['poznamka'] . '
'; $text .= 'http://' . $GLOBALS['web'] . '/
'; $text .= '' . $GLOBALS['mail'] . '
'; $text .= 'tel: '.$GLOBALS['phone'].'
'; #$text .= 'mobil: +420 777 338 717
'; $hlavicka = 'Content-type: text/html; charset=UTF-8' . "\n" . "Content-Transfer-Encoding: 8bit" . "\n" . 'From: <' . $GLOBALS['mail'] . '>' . "\n" . 'Reply-To: <' . $GLOBALS['mail'] . '>' . "\n" . 'X-Mailer: PHP/' . phpversion (); mail ($komu, mail_encode ($predmet), $text, $hlavicka); } function send_mail_new_obj_admin ($kod) { $objednavka = mysql_fetch_array (mysql_query ("SELECT * FROM shop_objednavky WHERE kod = '$kod' LIMIT 1")); $polozky_s = mysql_query ("SELECT * FROM shop_objednavky_polozky WHERE id_objednavky = '" . $objednavka['id_objednavky'] . "' ORDER BY doprava ASC"); while ($polozky = mysql_fetch_array ($polozky_s)) { if ($polozky['doprava'] == '1' AND $polozky['cena'] == '0') { $pretext .= $polozky['pocet'] . 'ks ' . $polozky['nazev'] . ' - zdarma
'; $celkem += $polozky['cena'] * $polozky['pocet']; } else { $pretext .= $polozky['pocet'] . 'ks ' . $polozky['nazev'] . ' za cenu ' . $polozky['cena'] * $polozky['pocet'] . ',-Kč s DPH
'; $celkem += $polozky['cena'] * $polozky['pocet']; } } $komu = $GLOBALS['mail']; $predmet = 'Nová objednávka na ' . $GLOBALS['web'] . ', č. ' . $objednavka['kod']; $text = 'Zákazník ' . $objednavka['prijmeni'] . ' ' . $objednavka['jmeno'] . ' vytvořil objednávku s číslem ' . $objednavka['kod'] . '.
'; $text .= 'Objednané položky:
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
'; $text .= $pretext . '
'; $text .= 'Celkem: ' . $celkem . ',- Kč s DPH
'; $text .= '= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
'; $text .= 'Poznámka: ' . $objednavka['poznamka'] . '
'; $text .= 'http://' . $GLOBALS['web'] . '/
'; $text .= '' . $GLOBALS['mail'] . '
'; $text .= 'tel: +420 775 330 930
'; #$text .= 'mobil: +420 777 338 717
'; $hlavicka = 'Content-type: text/html; charset=UTF-8' . "\n" . "Content-Transfer-Encoding: 8bit" . "\n" . 'From: <' . $GLOBALS['mail'] . '>' . "\n" . 'Reply-To: <' . $GLOBALS['mail'] . '>' . "\n" . 'X-Mailer: PHP/' . phpversion (); mail ($komu, mail_encode ($predmet), $text, $hlavicka); } function send_mail_new_user ($mail, $password) { $komu = $mail; $predmet = 'Přihlášení na ' . $GLOBALS['web'] . ''; $text = 'Vážený zákazníku
Vaše heslo pro přihlášení je ' . $password . '
'; $text .= 'http://' . $GLOBALS['mail'] . '/
'; $text .= '' . $GLOBALS['mail'] . '
'; $text .= 'tel: +420 775 330 930
'; #$text .= 'mobil: +420 777 338 717
'; $hlavicka = 'Content-type: text/html; charset=UTF-8' . "\n" . "Content-Transfer-Encoding: 8bit" . "\n" . 'From: <' . $GLOBALS['mail'] . '>' . "\n" . 'Reply-To: <' . $GLOBALS['mail'] . '>' . "\n" . 'X-Mailer: PHP/' . phpversion (); mail ($komu, mail_encode ($predmet), $text, $hlavicka); } ?>'; // debug_print_backtrace(); if (!class_exists($function_name, false) || !interface_exists($function_name, false)) { //print $function_name.BR; require_once ($function_name.'.php'); } } ?>
Fatal error: Uncaught Error: Class 'javascript' not found in /var/www/client-09-pohanova-lucie/centrumstastnehodetstvi.cz/web/index.php:31 Stack trace: #0 {main} thrown in /var/www/client-09-pohanova-lucie/centrumstastnehodetstvi.cz/web/index.php on line 31