Kód Název Barva ks Kč/ks Celkem ";
// if (isset($_POST['obj']))
// { $kosik = $_POST['obj'] ;
// print " ";
//
// for ($i = 0; $i < count($kosik); $i++)
// {
// $id=key($kosik);
// $ks = $kosik[$id];
// $delka = strlen($id)-1;
// $item = substr($id,0, $delka);
$dotaz="select id, id_pop, datum, produkt, ks, cena_ks from kosik where id_pop=$id_pop order by produkt;";
$vysledek = mysql_query($dotaz);
while ($zaznam = MySQL_Fetch_object($vysledek))
{
$radek= $zaznam -> id;
$id = $zaznam -> produkt;
$ks = $zaznam -> ks;
$cena = $zaznam -> cena_ks;
$delka = strlen($id)-1;
$item = substr($id,0, $delka);
$barva = substr($id, $delka, 1);
$dotaz_prod="select * from katalog where kod_prod='$item' group by kod_prod;";
$vysledek_prod = mysql_query($dotaz_prod);
if (mysql_num_rows($vysledek_prod) == 0 )
{
$barva = 99;
$dotaz_prod="select * from katalog where kod_prod='$id' group by kod_prod;";
$vysledek_prod = mysql_query($dotaz_prod);
}
while ($zaznam_prod = MySQL_Fetch_Object($vysledek_prod))
{
$kod_prod = $zaznam_prod -> kod_prod;
$nazev = $zaznam_prod -> nazev;
$mekky= $zaznam_prod -> mekky;
$stredni= $zaznam_prod -> stredni;
$tvrdy= $zaznam_prod ->tvrdy;
$vlakno= $zaznam_prod ->vlakno;
$kartac= $zaznam_prod ->kartac;
$nasada= $zaznam_prod ->nasada;
$rozmer= $zaznam_prod ->rozmer;
$hmotnost= $zaznam_prod ->hmotnost;
$teplota= $zaznam_prod ->teplota;
$material= $zaznam_prod ->material;
$text= $zaznam_prod ->text;
$tm_modra= $zaznam_prod ->tm_modra;
$zelena= $zaznam_prod ->zelena;
$sv_modra= $zaznam_prod ->sv_modra;
$cervena= $zaznam_prod ->cervena;
$bila= $zaznam_prod ->bila;
$zluta = $zaznam_prod ->zluta;
$oranzova= $zaznam_prod ->oranzova;
$cerna= $zaznam_prod ->cerna;
$kategorie= $zaznam_prod ->kategorie;
$cena= $zaznam_prod -> cena;
echo " ";
if ($barva!=99)
{
$start = (strlen($item)-1);
$kontrola = substr($item, $start, 1);
if (is_numeric($kontrola))
{
print substr($id,1,10);
}
else
{
print substr($item,1,$start-1).$barva.substr($item,$start,1);}}
else
{
print substr($id,1,10);
}
print" $nazev ";
if ($barva != 99)
{
if ($barva == 1)
{print " ";}
if ($barva == 2)
{print " ";}
if ($barva == 3)
{print " ";}
if ($barva == 4)
{print " ";}
if ($barva == 5)
{print " ";}
if ($barva == 6)
{print " ";}
if ($barva == 7)
{print " ";}
if ($barva == 9)
{print " ";}
}
print " ";
print " ";
print " $cena,- ".($cena*$ks).",- x ";
$cena_celk = $cena_celk + ($cena*$ks);
}
}
print " ";
print "Cena celkem bez DPH ".number_format($cena_celk,2,","," ")." Kč ";
$sleva=0;
//$sleva = (-$cena_celk*0.1);
//print "Akční selva 10% ".number_format($sleva,2,","," ")." Kč ";
$dph = (($cena_celk+$sleva)*0.21);
//print "Cena celkem bez DPH po slevě ".number_format(($cena_celk+$sleva),2,","," ")." Kč ";
print "DPH 21% ".number_format($dph,2,","," ")." Kč ";
print "Cena celkem s DPH ".number_format(($cena_celk+$sleva+$dph),2,","," ")." Kč ";
print " ";
print " ";
print " ";
print "
";
print "