function print_revision_vp_stitky($revision, $sub = "") { $default_firma = def_value("default_firma", "hodnota"); $default_adresa = def_value("default_adresa", "hodnota"); $default_mesto = def_value("default_mesto", "hodnota"); $default_ico = def_value("default_ico", "hodnota"); $default_dic = def_value("default_dic", "hodnota"); $default_telefon = def_value("default_telefon", "hodnota"); $default_email = def_value("default_email", "hodnota"); $default_web = def_value("default_web", "hodnota"); $data = sql_query("SELECT id, id_vyrobny_plan, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum\r\n FROM revizia_vyrobny_plan \r\n WHERE id={$revision} \r\n LIMIT 1")[0]; $data_row = sql_query("SELECT vyr.*, obr.*, rev.meno, rev.adresa, rev.psc, rev.mesto, rev.ico, rev.dic,\r\n rev.telefon, rev.email, rev.doruc_meno, rev.doruc_adresa, rev.doruc_mesto, \r\n rev.doruc_psc, rev.doruc_telefon,\r\n rev.komentar, rev.komentar_private, rev.vlastne_cislo_obj, obj.id_zakaznik, obj.c_obj, obj.datum \r\n FROM vyrobny_plan_row vyr\r\n INNER JOIN objednavka_row obr\r\n ON vyr.id_objednavka_row = obr.id\r\n INNER JOIN revizia rev\r\n ON obr.id_revizia = rev.id\r\n INNER JOIN objednavka obj\r\n ON rev.id_obj = obj.id\r\n WHERE id_revizia_vyrobny_plan = " . $revision . "\r\n AND vyr.vymaz=0 AND obr.id_product_type <> 14 \r\n ORDER BY obj.id_zakaznik DESC\r\n "); $message = ""; //var_dump($data_row); foreach ($data_row as $key => $row) { $data_row_option = sql_query("SELECT id_product_atribute, id_product_atribute_option \r\n FROM objednavka_row_atribute \r\n WHERE id_revizia=\"{$row['id_revizia']}\" AND id_objednavka_row=\"{$row[id]}\""); //var_dump($row); //dd($data_row_option); $options = array(); $options_id = array(); foreach ($data_row_option as $option) { $option = sql_query("SELECT id, meno FROM product_atribute_option WHERE id=" . $option["id_product_atribute_option"] . " LIMIT 1")[0]; $options[] = $option["meno"]; $options_id[] = $option["id"]; } $options_str = empty($options) ? "" : join(" / ", $options); $options_id_str = $row["id_product_type"] . "-" . $row["id_product"] . "-" . join("-", $options_id); if (!empty($row["atyp_text"])) { $options_str .= " / " . $row["atyp_text"]; } $required = array("meno", "adresa", "mesto", "psc", "ico", "dic"); if ($row["id_zakaznik"] > 0) { $query = "SELECT meno, adresa, mesto, psc, ico, dic, \r\n doruc_meno, doruc_adresa, doruc_psc, doruc_mesto, doruc_telefon \r\n FROM uzivatel WHERE id=" . $row["id_zakaznik"] . " LIMIT 1"; $zakaz = sql_query($query)[0]; //var_dump($zakaz); foreach ($zakaz as $k => $zak) { if (in_array($k, $required)) { $row[$k] = $zak; } else { } } } $product_type = sql_query("SELECT meno FROM product_type WHERE id=" . $row["id_product_type"] . " LIMIT 1")[0]["meno"]; $product = sql_query("SELECT meno, montazny_balik FROM product WHERE id=" . $row["id_product"] . " LIMIT 1")[0]; $product_balenie = sql_query("SELECT meno FROM product_packages WHERE id_product=" . $row["id_product"] . ""); //var_dump(count($product_balenie)); if (count($product_balenie) == 0) { $product_balenie = array(0 => array("meno" => "")); } $ean = sql_query("SELECT ean FROM ean WHERE code=\"" . $options_id_str . "\" LIMIT 1")[0]["ean"]; for ($i = 1; $i <= $row["ks"]; $i++) { $count = 1; foreach ($product_balenie as $balenie) { $barcode = "BEN" . $product["meno"] . "" . str_replace("/", "", $options_str); $barcode = str_replace('.', '', $barcode); $barcode = str_replace(' ', '', $barcode); $barcode = strtoupper(rep_dia($barcode)); $barcode = substr($barcode, 0, 45); $img = "<img src=\"barcode.php?codetype=Code128&size=40&text={$barcode}\" />"; if (!empty($ean)) { $barcode = $ean; $img = "<img src=\"barcode/barcode.php?scale=2&code={$barcode}\" />"; } $message .= "\r\n <div class=\"print_hlavicka_vp\">\r\n <table class=\"stitky\" >\r\n <tr>\r\n <td class=\"logo\" rowspan=4>\r\n <img src=\"assets/images/vp_stitok_logo.jpg\" width=200 style=\"margin: 15px auto;\">\r\n </td>\r\n <td colspan=3 class=\"nazov\" style=\"height: 2.4cm;\">\r\n <table class=\"inner_table\">\r\n <tr>\r\n <td class=\"titulka\">Názov produktu:</td>\r\n <td class=\"barcode\" align=\"right\" rowspan=2> \r\n {$img}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td class=\"product_type\">{$product_type}</td>\r\n </tr>\r\n <tr>\r\n <td class=\"product\" colspan=2>{$product["meno"]}</td>\r\n </tr>\r\n </table>\r\n\r\n </td> \r\n </tr>\r\n <tr>\r\n <td colspan=2 rowspan=3>\r\n <table class=\"inner_table\">\r\n <tr>\r\n <td class=\"titulka\">Špecifikácia:</td>\r\n </tr>\r\n <tr>\r\n <td class=\"product\" style=\"font-size: " . (strlen($options_str) > 27 ? "18" : "24") . "px;\">{$options_str}</td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td class=\"c_obj\" style=\"width: 4cm;\">č.obj {$row["c_obj"]}/" . dateYear($row["datum"]) . "</td>\r\n </tr>\r\n <tr> \r\n <td class=\"c_obj\" style=\"font-size: 13px;\">{$row["vlastne_cislo_obj"]}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"padding: 0px 5px; height: 15px;\">dátum výroby: " . date("j. n. Y") . "</td>\r\n </tr>\r\n <tr>\r\n <td style=\"height: 4.4cm; vertical-align: top;\">\r\n <table class=\"inner_table adresy\" style=\"font-size: 105%;\">\r\n <tr>\r\n <td style=\"font-size: 8px;\">Výrobca:</td>\r\n </tr>\r\n <tr>\r\n <td style=\"\">{$default_firma}, {$default_adresa}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\">{$default_mesto}, SLOVENSKO</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\">IČO: {$default_ico}, DIČ: {$default_dic}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\">tel. {$default_telefon}, email: {$default_email}</td>\r\n </tr> \r\n <tr> \r\n <td style=\"\">web: {$default_web}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"padding-top: 10px;\">Výstupná kontrola: Ľubomír Kredatus</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\"><img src=\"assets/images/qr1455130356.png\" width=45 style=\"margin: 0px;\"></td>\r\n </tr>\r\n\r\n </table>\r\n </td>\r\n <td style=\"vertical-align: top;\">\r\n <table class=\"inner_table adresy\" style=\"font-size: 110%;\">\r\n <tr>\r\n <td style=\"width: 22%; font-size: 8px; vertical-align: top;\" rowspan=5>Odberateľ:</td>\r\n <td style=\"font-weight: bold; font-size: " . (strlen($row["meno"]) > 24 ? "170" : "193") . "%;\">{$row["meno"]}</td>\r\n </tr>\r\n <tr>\r\n <td style=\"\">{$row["adresa"]}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\">{$row["mesto"]} {$row["psc"]}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\">IČO: {$row["ico"]}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\">IČDPH: {$row["dic"]}</td>\r\n </tr>\r\n\r\n </table>\r\n <table class=\"inner_table adresy\" style=\"font-size: 110%;\">\r\n <tr>\r\n <td style=\"width: 22%; font-size: 8px; vertical-align: top;\" rowspan=5>Adresa dodania:</td>\r\n <td style=\"font-weight: bold;\">{$row["doruc_meno"]}</td>\r\n </tr>\r\n <tr>\r\n <td style=\"\">{$row["doruc_adresa"]}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\">{$row["doruc_mesto"]} {$row["doruc_psc"]}</td>\r\n </tr>\r\n <tr> \r\n <td style=\"\">tel: {$row["doruc_telefon"]}</td>\r\n </tr> \r\n\r\n </table>\r\n </td>\r\n <td colspan=2 style=\"vertical-align: top;\">\r\n <table class=\"inner_table\">\r\n <tr>\r\n <td class=\"titulka\">Balenie:</td>\r\n </tr>\r\n <tr>\r\n <td class=\"balenie\">{$count}/" . count($product_balenie) . "</td>\r\n </tr>\r\n <tr>\r\n <td class=\"balenie_popis\">{$balenie["meno"]}</td>\r\n </tr>\r\n <tr>\r\n <td class=\"balenie_montazny_balik\">{$product["montazny_balik"]}</td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n </div>\r\n "; $count = $count + 1; } } } return $message; }
* */ echo "<div id=\"add_csv_button\">"; echo "<a href=\"?vyber=objednavky&order={$order}&revision={$revision}&action=send_mail_to\">Odošli mail zákazníkovi</a>"; echo "</div>"; echo "<div id=\"add_csv_button\">"; echo "<a href=\"?vyber=print&order={$order}&revision={$revision}\" id=\"print_order\" target=\"_blank\">Vytlačiť</a>"; echo "</div>"; echo "<div id=\"activity\">"; echo "<a href=\"\" id=\"revision_activity\" data-revision=\"{$revision}\">Aktivita</a>"; echo "</div>"; echo "<div id=\"dialog\"></div>"; echo "</div>"; $num_files = sql_query("SELECT id from subor WHERE id_obj=\"{$order}\""); $form_data[num_files] = count($num_files); echo "<h1>Objednávka č. {$c_obj}/" . dateYear($obj["datum"]) . "</h1>"; formular($fieldsets_c, $form_data); } } function display_all($page, $vyber, $search_name) { echo "<h1>Všetky objednávky</h1>"; echo "<div class=\"filter_obj clearfix\">"; echo textfield("filter_by_obj_id", $_SESSION["search_id"], "č. obj:", 5, 4); echo select("filter_by_zakaznik", "Filtruj zákazníkov:", "SELECT id, meno FROM uzivatel WHERE skupina=2 AND vymaz=0 ORDER BY meno", $_SESSION["search_zakaznik"], "- všetci -", "", ""); echo textfield("filter_by_name", $_SESSION["search_name"], "Vyhľadaj podľa mena (min. 3zn):", 10, 10); $filtbyst = array("bez_rozpracovanych" => "všetky bez rozpracovaných", "aj_rozpracovane" => "všetky + rozpracované", "iba_prijate" => "iba prijaté", "iba_rozpracovane" => "iba rozpracované"); echo check_visibility("filter_by_status", select("filter_by_status", "Filtruj objednávky:", "", $_SESSION["search_status"], "", "", "", "NO", $filtbyst)); echo "</div>"; echo "<div id=\"list_of_all\">"; $sec_code = "8975JK.!";
echo "<td class=\"revizia\">"; if (empty($product["revizia"]["id_zakaznik"])) { $odberatel = $product["revizia"]["meno"]; if (empty($product["revizia"]["doruc_mesto"])) { $odberatel .= !empty($product["revizia"]["mesto"]) ? ", " . $product["revizia"]["mesto"] : ""; } else { $odberatel .= ", " . $product["revizia"]["doruc_mesto"]; } } else { $query = "SELECT meno, mesto, doruc_mesto from uzivatel \r\n WHERE id = {$product["revizia"]["id_zakaznik"]}\r\n "; $uzivatel = sql_query($query)[0]; $odberatel = $uzivatel["meno"]; if (empty($uzivatel["doruc_mesto"])) { $odberatel .= !empty($uzivatel["mesto"]) ? ", " . $uzivatel["mesto"] : ""; } else { $odberatel .= ", " . $uzivatel["doruc_mesto"]; } } echo "<span class=\"bold\">{$odberatel}</span>\r\n obj. č. {$product["revizia"]["c_obj"]}/" . dateYear($product["revizia"]["datum"]) . " z " . dateDate($product["revizia"]["datum"]) . "\r\n "; echo "</td>"; echo "</tr>"; //var_dump($objednavka); } echo "</tbody></table>"; //var_dump($_SESSION); $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $totaltime = $endtime - $starttime; //echo "<div class=\"Etimer\">".$totaltime." seconds</div>";
echo "<thead> <tr>\r\n \r\n <th>dátum</th>\r\n <th>produkt</th>\r\n <th>dodávateľ</th>\r\n <th>zákazník</th>\r\n <th>poznámka</th>\r\n \r\n </tr></thead><tbody>"; //var_dump($where); $objednavka = sql_query($query); //$objednavka = $objednavka[0]; //var_dump($objednavka); if (count($objednavka) > 0) { foreach ($objednavka as $obj) { if ($obj["komplet"] > 0) { $obj[meno] = "kompletná"; // kompletná objednávka $obj[nastavenie] = "komplet"; } $revizia = sql_query("\r\n SELECT objr.*, p.meno\r\n FROM do_objednavka_row objr\r\n INNER JOIN do_produkt p\r\n ON objr.id_do_produkt = p.id\r\n WHERE objr.id_do_objednavka = " . $obj["id"] . "\r\n ORDER BY objr.datum DESC LIMIT 1\r\n "); $revizia = $revizia[0]; if (!empty($obj[objednavka])) { $obj_porez = sql_query("\r\n SELECT id, datum\r\n FROM objednavka\r\n WHERE c_obj = " . $obj["objednavka"] . "\r\n ORDER BY id DESC LIMIT 1\r\n ")[0]; } echo "\r\n <tr class=\"obj_" . $obj[nastavenie] . "\">\r\n <td class=\"obj_datum do_obj_datum\">\r\n " . $obj["dat_upr"] . " </td>\r\n <td class=\"obj_datum do_obj_produkt\"><a href=\"?vyber=do_objednavka&order=" . $obj[id] . "\">\r\n " . (!empty($revizia[ks]) ? $revizia["ks"] . $revizia["jednotka"] . " " : "") . "\r\n {$revizia['meno']}\r\n \r\n </a>" . (!empty($obj[objednavka]) ? " (obj. č. <a href=\"?vyber=objednavky&order=" . $obj_porez["id"] . "\">" . $obj["objednavka"] . "/" . dateYear($obj_porez["datum"]) . "</a>)" : "") . "</td>\r\n <td class=\"obj_datum\"><a href=\"?vyber=do_objednavka&order=" . $obj[id] . "\">{$obj['dodavatel']}</a></td>"; //var_dump($vyroba2); echo "<td class=\"obj_status\">" . $revizia[zakaznik] . "</td> \r\n <td class=\"do_obj_poznamka bold\">" . (!empty($obj["datum_email"]) ? $obj["datum_email"] . "<br> " : "") . "<span class=\"red_text\">" . $obj[poznamka] . "</span></td>\r\n </tr>\r\n "; } } echo "</tbody></table>"; echo "<div class=\"pager\">Strany: " . implode(" | ", $pager[pages]) . "</div>"; //var_dump($_SESSION); $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $totaltime = $endtime - $starttime; echo "" . $totaltime . " seconds<br>";
$before = before($objednavka["datum"]); } $tooltip = ""; if (!empty($objednavka["revizia"]["komentar"])) { $title = $objednavka["revizia"]["komentar"]; $tooltip .= "<img src=\"assets/images/icon-tooltip.png\" title=\"" . $title . "\" class=\"tooltip_info tooltip\">"; } if (!empty($objednavka["revizia"]["komentar_private"])) { $title = $objednavka["revizia"]["komentar_private"]; $tooltip .= "<img src=\"assets/images/icon-tooltip-green.png\" title=\"" . $title . "\" class=\"tooltip_info tooltip\">"; } $vlastne_cislo_obj = ""; if (!empty($objednavka["revizia"]["vlastne_cislo_obj"])) { $vlastne_cislo_obj = " (" . $objednavka["revizia"]["vlastne_cislo_obj"] . ") "; } echo "<span class=\"vyr_plan_odberatel\">{$odberatel}</span>\r\n obj. č. {$objednavka["c_obj"]}/" . dateYear($objednavka["revizia"]["datum"]) . "{$vlastne_cislo_obj} <span class=\"bold\">" . $before . "</span>\r\n {$tooltip}\r\n </div>"; echo "<table class=\"vyr_plan_produkty\">"; echo "<tbody>"; foreach ($objednavka["produkty"] as $product) { echo "<tr>"; $opt = array(); foreach ($product["options"] as $option) { //var_dump($option[name]); $opt[] = $option[meno]; } $opt = empty($opt) ? "" : " (" . join(", ", $opt) . ")"; if (empty($checkbox)) { echo "<td class=\"checker\"><input type=\"checkbox\" value=\"{$product["id"]}\" data-id=\"{$id}\" data-revision=\"{$revision}\"></td>"; } echo "<td class=\"product\">{$product["ks"]}x {$product["product_type"]} {$product["product"]}{$opt} " . (!empty($checkbox) ? $product["delivery"] : "") . " \r\n " . (!empty($product["atyp_text"]) ? "<br>Atyp: " . $product["atyp_text"] : "") . "</td>"; echo "</tr>";
function display($id, $revision = 0, $vyber = "vyrobny_plan") { if (empty($revision)) { $query = "SELECT id \r\n FROM revizia_vyrobny_plan \r\n WHERE id_vyrobny_plan = {$id}\r\n ORDER BY id DESC limit 1\r\n "; $revision = sql_query($query)[0]["id"]; } $upravil = $_SESSION[username]; //var_dump($revision); $query = "SELECT r.id, r.ks, r.atyp_text, r.id_revizia, pt.meno product_type, p.meno product, vpr.vymaz\r\n FROM objednavka_row r\r\n INNER JOIN product p\r\n ON r.id_product = p.id\r\n INNER JOIN product_type pt\r\n ON r.id_product_type = pt.id\r\n INNER JOIN vyrobny_plan_row vpr\r\n ON r.id = vpr.id_objednavka_row\r\n WHERE vpr.id_vyrobny_plan = {$id} AND\r\n vpr.id_revizia_vyrobny_plan = {$revision} \r\n ORDER BY r.id DESC"; //print_r($query); $products = sql_query($query); //var_dump($products); foreach ($products as $key => $product) { $query = "SELECT * from revizia r\r\n INNER JOIN objednavka o\r\n ON r.id_obj = o.id\r\n WHERE r.id = {$product["id_revizia"]}\r\n limit 1"; $products[$key]["revizia"] = sql_query($query)[0]; $products[$key]["options"] = sql_query("\r\n SELECT o.meno\r\n FROM objednavka_row_atribute as a \r\n INNER JOIN product_atribute_option as o\r\n ON a.id_product_atribute_option = o.id \r\n WHERE a.id_revizia = {$product["id_revizia"]}\r\n AND a.id_objednavka_row = {$product["id"]}\r\n ORDER BY a.id_product_atribute\r\n "); } if ($_POST[submit]) { $meno = sec_sql(sec_input($_POST["meno"])); $popis = sec_sql(sec_input($_POST["popis"])); $delivery = sec_sql(sec_input($_POST["delivery"])); $datum_vyvozu = sec_sql(sec_input($_POST["datum_vyvozu"])); if (strlen($meno) > 30 or strlen($meno) < 2) { $error_msg[] = "Meno môže mať od 4 do 30 znakov"; } if (strlen($datum_vyvozu) > 30 or strlen($datum_vyvozu) < 10) { $error_msg[] = "Dátum vývozu je povinný údaj a môže mať od 10 do 30 znakov"; } if (empty($error_msg)) { $query = "UPDATE vyrobny_plan SET\r\n meno = \"{$meno}\", popis = \"{$popis}\", delivery = \"{$delivery}\", \r\n datum_vyvozu = \"{$datum_vyvozu}\", vytvoril = \"{$upravil}\"\r\n WHERE id={$id}\r\n "; sql_insert($query); } else { echo "<div id=error_message>" . implode("<br>", $error_msg) . "</div>"; } } $query = "SELECT * FROM vyrobny_plan \r\n WHERE id = {$id}\r\n "; $vyrobny_plan = sql_query($query)[0]; $meno = $vyrobny_plan["meno"]; $popis = $vyrobny_plan["popis"]; $datum = $vyrobny_plan["datum"]; $delivery = $vyrobny_plan["delivery"]; $datum_vyvozu = $vyrobny_plan["datum_vyvozu"]; $status = $vyrobny_plan["status"]; $komplet = $vyrobny_plan["komplet"]; //var_dump($products); echo "<h1>Výrobný plán č. {$id}-{$revision}/" . dateYear($datum) . " - {$meno}</h1>"; echo "<h3>dátum vývozu: " . dateDate($datum_vyvozu) . "</h3>"; echo "<h3>popis: " . $popis . "</h3>"; echo "<table class=\"vyr_plan_detail\">"; echo "<tbody>"; $poradie = 0; foreach ($products as $product) { $poradie = $poradie + 1; $removed = ""; if ($product["vymaz"] > 0) { $removed = "class=\"removed\""; } echo "<tr {$removed}>"; $opt = array(); foreach ($product["options"] as $option) { //var_dump($option[name]); $opt[] = $option[meno]; } $opt = empty($opt) ? "" : " (" . join(", ", $opt) . ")"; echo "<td class=\"product\"><span class=\"bold\">{$product["ks"]}x {$product["product_type"]} {$product["product"]}{$opt}</span>\r\n " . (!empty($product["atyp_text"]) ? "<br>- " . $product["atyp_text"] : "") . "</td>"; echo "<td class=\"revizia\">"; if (empty($product["revizia"]["id_zakaznik"])) { $odberatel = $product["revizia"]["meno"]; if (empty($product["revizia"]["doruc_mesto"])) { $odberatel .= !empty($product["revizia"]["mesto"]) ? ", " . $product["revizia"]["mesto"] : ""; } else { $odberatel .= ", " . $product["revizia"]["doruc_mesto"]; } } else { $query = "SELECT meno, mesto, doruc_mesto from uzivatel \r\n WHERE id = {$product["revizia"]["id_zakaznik"]}\r\n "; $uzivatel = sql_query($query)[0]; $odberatel = $uzivatel["meno"]; if (empty($uzivatel["doruc_mesto"])) { $odberatel .= !empty($uzivatel["mesto"]) ? ", " . $uzivatel["mesto"] : ""; } else { $odberatel .= ", " . $uzivatel["doruc_mesto"]; } } echo "<span class=\"bold\">{$odberatel}</span>\r\n obj. č. {$product["revizia"]["c_obj"]}/" . dateYear($product["revizia"]["datum"]) . " z " . dateDate($product["revizia"]["datum"]) . "\r\n "; echo "</td>"; echo "</tr>"; //var_dump($objednavka); } echo "</tbody></table>"; echo "<div class=\"edit_buttons\">"; echo "<a href=\"?vyber={$vyber}&action=edit&id={$id}&revision={$revision}\" class=\"button\">upraviť</a>"; echo "<a href=\"?vyber=print&revision={$revision}&action=vyrobny_plan&cp=" . $id . "\" target=\"_blank\" class=\"button\">vytlačiť priebežne</a>"; echo "<a href=\"?vyber=print&revision={$revision}&action=vp_stitky&cp=" . $id . "\" target=\"_blank\" class=\"button\">štítky</a>"; echo "<a href=\"?vyber=print&revision={$revision}&action=vyrobny_plan&cp=" . $id . "&sub=close\" target=\"_blank\" class=\"button\">vytlačiť pre VÝROBU</a>"; echo "</div>"; echo "<div class=\"vyrobny_plan_bottom_row\">"; echo "<div class=\"all_revisions\">"; $query = "SELECT id, datum, vytvoril\r\n FROM revizia_vyrobny_plan\r\n WHERE id_vyrobny_plan = {$id}\r\n ORDER BY datum DESC"; $all_revisions = sql_query($query); $poradie = 0; foreach ($all_revisions as $rev) { $selected = ""; if (empty($revision)) { if ($poradie == 0) { $selected = "selected"; } } else { if ($rev["id"] == $revision) { $selected = "selected"; } } echo "<div class=\"all_revisions_row {$selected}\">"; echo "<a href=\"?vyber={$vyber}&action=display&id={$id}&revision={$rev["id"]}\" class=\"\">revízia č. {$rev["id"]} z dňa " . dateFull($rev["datum"]) . "</a>"; echo "</div>"; $poradie = $poradie + 1; } if ($status > 1) { echo "<div id=\"add_csv_button\" class=\"add_csv_button_vyr_plan\">"; $cp_exists = count(sql_query("SELECT id FROM cp_vyrobny_plan where id_vyrobny_plan=\"{$id}\" LIMIT 1")); if ($cp_exists > 0) { echo "<a href=\"?vyber=cp_vyrobny_plan&order={$id}&revision={$revision}&action=display_all\">Zobraz Cenové ponuky</a><br>"; } echo "<a href=\"?vyber=cp_vyrobny_plan&order={$id}&revision={$revision}&action=create\">Vytvor Cenovú ponuku</a>"; echo "</div>"; echo "</div>"; } echo "<div class=\"vyrobny_plan_edit\">"; echo "<form method=\"POST\">"; echo textfield("meno", $meno, "Meno plánu *", 40, 20); echo textfield("datum_vyvozu", $datum_vyvozu, "Dátum vývozu *", 40, 20); $zobraz_vo = array(0 => "štandard", 1 => "48 hodín"); echo select("delivery", "typ dopravy", "", $delivery, "", "", "", "NO", $zobraz_vo); echo textarea("popis", $popis, "Popis", 25, 3, "popis", ""); echo submit("submit", "Odoslať"); echo "</form>"; echo "<div>" . ($komplet == 0 ? "<a href=\"?vyber=vyrobny_plan&id={$id}&action=close\" class=\"button\">VP Vyrobený</a>" : "<a href=\"?vyber=vyrobny_plan&id={$id}&action=open\" class=\"button\">Otvoriť VP</a>") . " </div>"; echo "<form method=\"POST\" class=\"status_form\">"; echo select("status", "Stav VP:", "SELECT id, meno FROM vyrobny_plan_status WHERE vymaz=0 ORDER BY id", $status, "", "", "", "NO"); echo submit("save_status", "Uložiť stav VP"); echo "</form>"; echo "</div>"; echo "</div>"; echo "</div>"; }
function formular_cp($order, $revision = 0, $fieldsets_c = 1, $form_data = "", $page = "") { if (isset($_GET["cp"])) { $cp = sec_input($_GET["cp"]); } if (!empty($form_data)) { foreach ($form_data as $key => $value) { ${$key} = $value; } } $data = sql_query("SELECT id, id_vyrobny_plan, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum\r\n FROM revizia_vyrobny_plan r \r\n WHERE r.id={$revision} \r\n LIMIT 1"); $data = $data[0]; //var_dump($data); $data_obj = sql_query("SELECT id, meno, popis, DATE_FORMAT(datum_vyvozu, '%d. %m. %Y') AS datum, datum AS rok\r\n FROM vyrobny_plan \r\n WHERE id=" . $data["id_vyrobny_plan"] . " LIMIT 1"); $data_obj = $data_obj[0]; //var_dump($data); $message = ""; $message .= "<h1>Cenová ponuka <br> Výrobný Plán č. " . $data_obj["id"] . "/" . dateYear($data_obj["rok"]) . " - " . $data_obj["meno"] . " </h1>"; $message .= "<h5>Dátum vývozu: " . $data_obj["datum"] . "</h5>"; $message .= !empty($data_obj["popis"]) ? "<h5>Popis: " . $data_obj["popis"] . "</h5>" : ""; //var_dump($dekor); echo "<div class=\"print\">"; echo $message; echo "</div>"; echo "<div id=\"content\" class=\"print_hlavicka4\">"; if (empty($page) or $page == 1) { //dd($_POST); if ($_POST["submit_page1"]) { //dd($_POST); $fieldsets_c = count($_POST["id"]); for ($i = 0; $i < $fieldsets_c; $i++) { $id_objednavka_row[] = sec_input(sec_sql($_POST["id"][$i])); $zlava[] = str_replace(',', '.', sec_input(sec_sql($_POST["zlava"][$i]))); $black[] = isset($_POST["black"][$i]) && $_POST["black"][$i] == 1 ? "1" : "0"; $ppd[] = isset($_POST["ppd"][$i]) && $_POST["ppd"][$i] == 1 ? "1" : "0"; $komis[] = isset($_POST["komis"][$i]) && $_POST["komis"][$i] == 1 ? "1" : "0"; $product_price[] = str_replace(',', '.', sec_input(sec_sql($_POST["product_price"][$i]))); $id_cp_product[] = sec_input(sec_sql($_POST["id_cp_product"][$i])); $ks[] = sec_input(sec_sql($_POST["ks"][$i])); $koment[] = sec_input(sec_sql($_POST["koment"][$i])); } $form_data[id_objednavka_row] = $id_objednavka_row; $form_data[id_cp_product] = $id_cp_product; $form_data[ks] = $ks; $form_data[zlava] = $zlava; $form_data[black] = $black; $form_data[ppd] = $ppd; $form_data[komis] = $komis; $form_data[product_price] = $product_price; $form_data[koment] = $koment; //var_dump($order); //var_dump($revision); if (empty($error_msg)) { $query = "INSERT INTO cp_vyrobny_plan ( id_vyrobny_plan, id_revizia_vyrobny_plan, vytvoril )\r\n VALUES ( {$order}, {$revision}, {$_SESSION['username']} )\r\n "; //print_r($query); //die(); mysql_query("BEGIN"); $sql_cp = sql_insert($query); $cp_id = $sql_cp["inserted_id"]; //dd($form_data); for ($i = 0; $i < count($form_data[id_objednavka_row]); $i++) { // ak je vacsi rovny nule if (empty($form_data[product_price][$i])) { if (!empty($form_data[id_cp_product][$i]) and $form_data[id_cp_product][$i] > 0) { $product_price = sql_query("SELECT cena FROM cp_product WHERE id=" . $form_data[id_cp_product][$i] . " ORDER BY id DESC LIMIT 1")[0]["cena"]; } else { $product_price = 0; } } else { $product_price = $form_data[product_price][$i]; } //echo $product_price."<br>"; //$product_ks_sum = $product_ks_sum + sec_input($form_data["ks"][$i]); $product_price_sum = $product_price * sec_input($form_data["ks"][$i]); $products_prices_sums = $products_prices_sums + $product_price_sum; $zlava_E = $product_price_sum * $form_data["zlava"][$i] / 100; $po_zlave = $product_price_sum - $zlava_E; $po_zlave_sum = $po_zlave_sum + $po_zlave; $query_cp_row = "INSERT into cp_vyrobny_plan_row (id_cp_vyrobny_plan, id_objednavka_row, id_cp_product, \r\n ks, cena, zlava, sum, black, ppd, komis, koment)\r\n VALUES ({$cp_id},\r\n {$form_data[id_objednavka_row][$i]}, \r\n \"{$form_data[id_cp_product][$i]}\", \r\n {$form_data[ks][$i]},\r\n \"{$form_data[product_price][$i]}\",\r\n \"{$form_data[zlava][$i]}\",\r\n \"{$po_zlave}\",\r\n \"{$form_data[black][$i]}\",\r\n \"{$form_data[ppd][$i]}\",\r\n \"{$form_data[komis][$i]}\",\r\n \"{$form_data[koment][$i]}\"\r\n )"; //echo $query_cp_row."<br>"; sql_insert($query_cp_row); //var_dump($query_poznamka); } sql_update("UPDATE cp_vyrobny_plan SET all_sum={$po_zlave_sum} WHERE id={$cp_id}"); mysql_query("COMMIT"); //dd($form_data); //$_SESSION["posted_form_from_cp"]=$form_data; header("location: ?vyber=cp_vyrobny_plan&order={$order}&revision={$revision}&action=display_all"); } else { echo "<div id=error_message>" . implode("<br>", $error_msg) . "</div>"; } } echo "<form method=\"POST\" id=\"formular\" enctype=\"multipart/form-data\">"; echo "<fieldset id=\"cp_rows\">"; // pre editaciu cenovej ponuky.... //========================================= $data_row = sql_query("SELECT vyr.*, obr.*, rev.meno, rev.mesto, rev.doruc_mesto, obj.id_zakaznik,\r\n rev.komentar, rev.komentar_private, rev.email, obj.c_obj c_obj, obj.datum datum_obj\r\n FROM vyrobny_plan_row vyr\r\n INNER JOIN objednavka_row obr\r\n ON vyr.id_objednavka_row = obr.id\r\n INNER JOIN revizia rev\r\n ON obr.id_revizia = rev.id\r\n INNER JOIN objednavka obj\r\n ON rev.id_obj = obj.id\r\n WHERE vyr.id_revizia_vyrobny_plan = " . $revision . "\r\n AND vyr.vymaz = 0\r\n "); //var_dump($data_row); foreach ($data_row as $key => $row) { $data_row_option = sql_query("SELECT id_product_atribute, id_product_atribute_option \r\n FROM objednavka_row_atribute \r\n WHERE id_revizia=\"{$row['id_revizia']}\" AND id_objednavka_row=\"{$row[id]}\""); //var_dump($data_row_option); foreach ($data_row_option as $option) { $data_row[$key]["product_atribute_options_all"][$option["id_product_atribute"]] = $option["id_product_atribute_option"]; } if (isset($_GET["cp"]) and !empty($_GET["cp"])) { $query = "SELECT * from cp_vyrobny_plan_row WHERE id_cp_vyrobny_plan=" . sec_input(sec_sql($_GET["cp"])) . " AND id_objednavka_row=" . $row[id] . ""; $cp_row = sql_query($query)[0]; $data_row[$key]["cena"] = $cp_row[cena]; $data_row[$key]["zlava"] = $cp_row[zlava]; $data_row[$key]["black"] = $cp_row[black]; $data_row[$key]["ppd"] = $cp_row[ppd]; $data_row[$key]["komis"] = $cp_row[komis]; $data_row[$key]["koment"] = $cp_row[koment]; //var_dump($cp_row); } if ($row["id_zakaznik"] > 0) { $query = "SELECT meno, mesto, doruc_mesto FROM uzivatel WHERE id=" . $row["id_zakaznik"] . " LIMIT 1"; $zakaznik = sql_query($query)[0]; $data_row[$key]["meno"] = $zakaznik["meno"]; $data_row[$key]["doruc_mesto"] = $zakaznik["doruc_mesto"]; $data_row[$key]["mesto"] = $zakaznik["mesto"]; } if ($row["id_zakaznik"] == 0) { $data_zak[$row["id_zakaznik"]][$row["id_revizia"]][] = $data_row[$key]; } else { $data_zak[$row["id_zakaznik"]][] = $data_row[$key]; } } //var_dump($data_row); $message = "<div class=\"print_hlavicka3\">\r\n <table>\r\n <tr> \r\n <th style=\"width: 380px;\">produkt</th> \r\n <th style=\"width: 50px;\">j.cena</th> \r\n <th style=\"width: 120px;\">zľava % / j.cena po</th>\r\n <th style=\"width: 50px;\">vl.cena</th>\r\n <th style=\"width: 60px;\">Spolu bez DPH</th>\r\n <th>DL</th>\r\n <th>PPD</th>\r\n <th>KMS</th>\r\n <th style=\"width: 135px;\">komentár</th>\r\n </tr>"; $count = 0; foreach ($data_zak as $key => $zakaznik) { $data_z = array(); if ($key > 0) { $message .= "<tr class=\"silver\">"; $query = "SELECT meno, mesto, doruc_mesto, email FROM uzivatel WHERE id=" . $key . " LIMIT 1"; $zakaz = sql_query($query)[0]; //dd($zakaz); $data_z["meno"] = $zakaz["meno"]; $data_z["doruc_mesto"] = $zakaz["doruc_mesto"]; $data_z["mesto"] = $zakaz["mesto"]; $data_z["email"] = $zakaz["email"]; $odberatel = $data_z["meno"]; if (empty($data_z["doruc_mesto"])) { $odberatel .= empty($data_z["mesto"]) ? "" : ", " . $data_z["mesto"]; } else { $odberatel .= ", " . $data_z["doruc_mesto"]; } $odberatel = "<span class=\"bold\">" . $odberatel . "</span>" . (!empty($data_z["email"]) ? " (" . $data_z["email"] . ")" : "") . ""; $message .= "<td colspan=9>{$odberatel}</td>"; $message .= "</tr>"; } foreach ($zakaznik as $keyer => $riadok) { if ($key > 0) { $at_text = ""; if (!empty($riadok["atyp_text"])) { $at_text = "atp"; } $cls = "class=\"{$count} {$at_text}\""; $message .= "<tr {$cls}>\r\n\r\n "; $product_type = sql_query("SELECT meno FROM product_type WHERE id=" . sec_sql(sec_input($riadok["id_product_type"])) . " LIMIT 1"); $product_type = $product_type[0]; $product = sql_query("SELECT id, meno FROM product WHERE id=" . sec_sql(sec_input($riadok["id_product"])) . " LIMIT 1")[0]; $options_str = array(); //var_dump($data); if (!isset($riadok["product_atribute_options_all"]) or empty($riadok["product_atribute_options_all"])) { $riadok["product_atribute_options_all"] = array(); } $option_c_hladina = 1; foreach ($riadok["product_atribute_options_all"] as $option) { //var_dump($option); $options = sql_query("SELECT id, meno, id_c_hladina FROM product_atribute_option WHERE id=" . sec_sql(sec_input($option)) . " LIMIT 1"); $options_str[] = $options[0]["meno"]; if ($options[0]["id_c_hladina"] > $option_c_hladina) { $option_c_hladina = $options[0]["id_c_hladina"]; } //$options["price"] = sql_query("SELECT id, cena FROM product_atribute_option WHERE id=".sec_sql(sec_input($option))." LIMIT 1"); } $options_str = empty($options_str) ? "" : " (" . join(", ", $options_str) . ")"; //var_dump($option_c_hladina); /* $odberatel = $riadok["meno"]; if(empty($riadok["doruc_mesto"])) { $odberatel .= ( empty($riadok["mesto"]) ? "" : ", ".$riadok["mesto"] ); } else { $odberatel .= ", ".$riadok["doruc_mesto"]; } */ $odberatel = " (obj č. " . $riadok["c_obj"] . "/" . dateYear($riadok["datum_obj"]) . ") z " . dateDate($riadok["datum_obj"]) . ""; $odberatel = "<br>" . $odberatel . ""; $message .= "<td class=\"form_nazov_siroky\">" . sec_input($riadok["ks"]) . "x " . $product_type["meno"] . " <span class=\"bold\">" . $product["meno"] . "" . $options_str . "</span>\r\n " . (empty($riadok["atyp_text"]) ? "" : "<br>Atyp: " . sec_input($riadok["atyp_text"])) . "\r\n {$odberatel}\r\n " . (empty($riadok["komentar"]) ? "" : "<br>- " . sec_input($riadok["komentar"])) . "\r\n " . (empty($riadok["komentar_private"]) ? "" : "<br>- " . sec_input($riadok["komentar_private"])) . "\r\n " . hidden("ks[]", $riadok["ks"], "ks") . "\r\n " . hidden("id[]", $riadok["id"]) . "</td>"; $product_prices = sql_query("SELECT id, cena FROM cp_product WHERE id_c_hladina=" . $option_c_hladina . " AND id_product=" . $product["id"] . " ORDER BY id DESC LIMIT 1")[0]; $regular_price = $product_prices[cena] . " €"; //echo "$i<br>"; //var_dump(count($data[product_price_all][$i])); //var_dump($data[product_price_all]); if ($riadok[cena] == 0) { //echo "hej"; if (!empty($riadok[vlastna_cena])) { $cena_final = $riadok[vlastna_cena]; $product_price = $riadok[vlastna_cena]; } else { $cena_final = 0; $product_price = $product_prices[cena]; } } else { $product_price = $riadok[cena]; $cena_final = $riadok[cena]; } $product_ks_sum = $product_ks_sum + sec_input($riadok["ks"]); $product_price_sum = $product_price * sec_input($riadok["ks"]); // spocitanie ceny spolu za vsetky produkty $products_prices_sums = $products_prices_sums + $product_price_sum; $zlava_E = $product_price_sum * $riadok["zlava"] / 100; $zlava_J = $product_price * $riadok["zlava"] / 100; $zlava_J = $product_price - $zlava_J; $po_zlave = $product_price_sum - $zlava_E; $po_zlave_sum = $po_zlave_sum + $po_zlave; $message .= "<td class=\"form_nazov ali-center product-price regular-price bold bigger\">" . $regular_price . "" . hidden("id_cp_product[]", $product_prices[id]) . " </td>"; $message .= "<td class=\"form_nazov bold bigger\">" . textfield("zlava[]", empty($riadok[zlava]) ? "0" : $riadok[zlava], "", 4, 2, "zlava") . "<span class=\"zlava-E\">" . ($riadok["zlava"] > 0 ? "" . $zlava_J . " €" : "") . "</span></td>"; $message .= "<td class=\"form_nazov ali-center product-price\">" . textfield("product_price[{$i}]", $cena_final, "", 5, 3, "product_price") . "</td>"; //$message .= "<td class=\"form_nazov ali-center bold\"><span class=\"cena-spolu-product\">".$product_price_sum ."</span> €</td>"; $message .= "<td class=\"form_nazov ali-center po-zlave-sum\">" . $po_zlave . " €</td>"; $checked = ""; if ($riadok[black] == 1) { $checked = "checked"; } $checked_ppd = ""; if ($riadok[ppd] == 1) { $checked_ppd = "checked"; } $checked_komis = ""; if ($riadok[komis] == 1) { $checked_komis = "checked"; } $message .= "<td><input type=\"checkbox\" name=\"black[{$count}]\" value=\"1\" {$checked}></td>"; $message .= "<td><input type=\"checkbox\" name=\"ppd[{$count}]\" value=\"1\" {$checked_ppd}></td>"; $message .= "<td><input type=\"checkbox\" name=\"komis[{$count}]\" value=\"1\" {$checked_komis}></td>"; $message .= "<td>" . textarea("koment[]", $riadok[koment], "", 16, 1, "koment") . "</td>"; $message .= "</tr>"; $count = $count + 1; } else { $message .= "<tr class=\"silver\">"; $data_z["meno"] = $riadok[0]["meno"]; $data_z["doruc_mesto"] = $riadok[0]["doruc_mesto"]; $data_z["mesto"] = $riadok[0]["mesto"]; $data_z["email"] = $riadok[0]["email"]; $odberatel = $data_z["meno"]; if (empty($data_z["doruc_mesto"])) { $odberatel .= empty($data_z["mesto"]) ? "" : ", " . $data_z["mesto"]; } else { $odberatel .= ", " . $data_z["doruc_mesto"]; } $odberatel = "<span class=\"bold\">" . $odberatel . "</span>" . (!empty($data_z["email"]) ? " (" . $data_z["email"] . ")" : "") . ""; $message .= "<td colspan=9>{$odberatel}</td>"; $message .= "</tr>"; foreach ($riadok as $riadok_without) { $cls = "class=\"{$count}\""; $message .= "<tr {$cls}>"; $product_type = sql_query("SELECT meno FROM product_type WHERE id=" . sec_sql(sec_input($riadok_without["id_product_type"])) . " LIMIT 1"); $product_type = $product_type[0]; $product = sql_query("SELECT id, meno FROM product WHERE id=" . sec_sql(sec_input($riadok_without["id_product"])) . " LIMIT 1")[0]; $options_str = array(); //var_dump($data); if (!isset($riadok_without["product_atribute_options_all"]) or empty($riadok_without["product_atribute_options_all"])) { $riadok_without["product_atribute_options_all"] = array(); } $option_c_hladina = 1; foreach ($riadok_without["product_atribute_options_all"] as $option) { //var_dump($option); $options = sql_query("SELECT id, meno, id_c_hladina FROM product_atribute_option WHERE id=" . sec_sql(sec_input($option)) . " LIMIT 1"); $options_str[] = $options[0]["meno"]; if ($options[0]["id_c_hladina"] > $option_c_hladina) { $option_c_hladina = $options[0]["id_c_hladina"]; } //$options["price"] = sql_query("SELECT id, cena FROM product_atribute_option WHERE id=".sec_sql(sec_input($option))." LIMIT 1"); } $options_str = empty($options_str) ? "" : " (" . join(", ", $options_str) . ")"; //var_dump($option_c_hladina); /* $odberatel = $riadok_without["meno"]; if(empty($riadok_without["doruc_mesto"])) { $odberatel .= ( empty($riadok_without["mesto"]) ? "" : ", ".$riadok_without["mesto"] ); } else { $odberatel .= ", ".$riadok_without["doruc_mesto"]; } */ $odberatel = " (obj č. " . $riadok_without["c_obj"] . "/" . dateYear($riadok_without["datum_obj"]) . ") z " . dateDate($riadok_without["datum_obj"]) . ""; $odberatel = "<br>" . $odberatel . ""; $message .= "<td class=\"form_nazov_siroky\">" . sec_input($riadok_without["ks"]) . "x " . $product_type["meno"] . " <span class=\"bold\">" . $product["meno"] . "" . $options_str . "</span>\r\n " . (empty($riadok_without["atyp_text"]) ? "" : "<br>Atyp: " . sec_input($riadok_without["atyp_text"])) . "\r\n {$odberatel}\r\n " . (empty($riadok_without["komentar"]) ? "" : "<br>- " . sec_input($riadok_without["komentar"])) . "\r\n " . (empty($riadok_without["komentar_private"]) ? "" : "<br>- " . sec_input($riadok_without["komentar_private"])) . "\r\n " . hidden("ks[]", $riadok_without["ks"], "ks") . "\r\n " . hidden("id[]", $riadok_without["id"]) . "</td>"; $product_prices = sql_query("SELECT id, cena FROM cp_product WHERE id_c_hladina=" . $option_c_hladina . " AND id_product=" . $product["id"] . " ORDER BY id DESC LIMIT 1")[0]; $regular_price = $product_prices[cena] . " €"; //echo "$i<br>"; //var_dump(count($data[product_price_all][$i])); //var_dump($data[product_price_all]); if ($riadok_without[cena] == 0) { //echo "hej"; if (!empty($riadok_without[vlastna_cena])) { $cena_final = $riadok_without[vlastna_cena]; $product_price = $riadok_without[vlastna_cena]; } else { $cena_final = 0; $product_price = $product_prices[cena]; } } else { $product_price = $riadok_without[cena]; $cena_final = $riadok_without[cena]; } $product_ks_sum = $product_ks_sum + sec_input($riadok_without["ks"]); $product_price_sum = $product_price * sec_input($riadok_without["ks"]); // spocitanie ceny spolu za vsetky produkty $products_prices_sums = $products_prices_sums + $product_price_sum; $zlava_E = $product_price_sum * $riadok_without[zlava] / 100; $zlava_J = $product_price * $riadok["zlava"] / 100; $zlava_J = $product_price - $zlava_J; $po_zlave = $product_price_sum - $zlava_E; $po_zlave_sum = $po_zlave_sum + $po_zlave; $message .= "<td class=\"form_nazov ali-center product-price regular-price bold bigger\">" . $regular_price . "" . hidden("id_cp_product[]", $product_prices[id]) . " </td>"; $message .= "<td class=\"form_nazov bold bigger\">" . textfield("zlava[]", empty($riadok_without[zlava]) ? "0" : $riadok_without[zlava], "", 4, 2, "zlava") . "<span class=\"zlava-E\">" . ($riadok["zlava"] > 0 ? "-" . $zlava_J . " €" : "") . "</span></td>"; $message .= "<td class=\"form_nazov ali-center product-price\">" . textfield("product_price[{$i}]", $cena_final, "", 5, 3, "product_price") . "</td>"; //$message .= "<td class=\"form_nazov ali-center bold\"><span class=\"cena-spolu-product\">".$product_price_sum ."</span> €</td>"; $message .= "<td class=\"form_nazov ali-center po-zlave-sum\">" . $po_zlave . " €</td>"; $checked = ""; $checked_ppd = ""; $checked_komis = ""; if ($riadok_without[black] == 1) { $checked = "checked"; } $checked_ppd = ""; if ($riadok_without[ppd] == 1) { $checked_ppd = "checked"; } $checked_komis = ""; if ($riadok_without[komis] == 1) { $checked_komis = "checked"; } $message .= "<td><input type=\"checkbox\" name=\"black[{$count}]\" value=\"1\" {$checked}></td>"; $message .= "<td><input type=\"checkbox\" name=\"ppd[{$count}]\" value=\"1\" {$checked_ppd}></td>"; $message .= "<td><input type=\"checkbox\" name=\"komis[{$count}]\" value=\"1\" {$checked_komis}></td>"; $message .= "<td>" . textarea("koment[]", $riadok_without[koment], "", 16, 1, "koment") . "</td>"; $message .= "</tr>"; $count = $count + 1; } } } } $message .= "<tr class=\"cp_spolu bold\">\r\n <td>Spolu: " . $product_ks_sum . " ks</td>\r\n <td></td>\r\n <td></td>\r\n <td></td>\r\n <td class=\"ali-center po-zlave-sum-all\">" . $po_zlave_sum . " €</td>\r\n <td></td>\r\n <td></td>\r\n <td></td>\r\n <td></td>\r\n \r\n <tr>"; $message .= "</table></div>"; echo $message; echo "</fieldset>"; echo submit("submit_page1", "Pokračovať"); } echo "</form>"; }