echo "<div id=error_message>" . implode("<br>", $error_msg) . "</div>";
}
}
// zobrazenie pridaných súborov
echo "<div id=\"added_files\">\r\n <h2>Nahraté súbory</h2>";
$directory = "files/obj-{$order}/rev-{$revision}";
$files = sql_query("SELECT meno, meno_old, pripona \r\n FROM subor\r\n WHERE id_obj=\"{$order}\" AND id_revizia=\"{$revision}\"");
//var_dump($files);
for ($i = 0; $i < count($files); $i++) {
echo "<a href=\"{$directory}/" . $files[$i]["meno"] . "." . $files[$i]["pripona"] . "\" target=\"_blank\">" . substr($files[$i]["meno_old"], 0, 20) . "</a><br>";
}
echo "</div>";
// tlačítko na generovanie csv súboru
echo "<div id=\"revision_buttons\">";
$directory = "files/csv_new/obj-{$order}/rev-{$revision}";
$meno_csv = sec_input(rep_dia($form_data[meno]));
$meno_csv = str_replace(" ", "", $meno_csv);
$meno_csv = str_replace('/', "", $meno_csv);
$meno_csv = str_replace('.', "", $meno_csv);
if (strlen($meno_csv) > 10) {
$meno_csv = substr($meno_csv, 0, 10);
}
$file = "{$c_obj}-{$meno_csv}.csv";
$file_pasy = "{$c_obj}-{$meno_csv}-pasy.csv";
echo "<div id=\"add_csv_button\">";
//var_dump("subor ".$directory."/".$file);
if (!file_exists($directory . "/" . $file)) {
echo "<a href=\"?vyber=objednavky&order={$order}&revision={$revision}&action=generate_csv_new\" class=\"download_csv\" data-url=\"?vyber=objednavky&order={$order}&revision={$revision}\">Vytvor .csv</a>";
} else {
echo "<a href=\"{$directory}/{$file}\" data-url=\"?vyber=objednavky&order={$order}&revision={$revision}\">Stiahni .csv</a><br>";
echo "<a href=\"?vyber=objednavky&order={$order}&revision={$revision}&action=generate_csv_new\">Pregeneruj .csv</a>";
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;
}
}
if (!empty($search_date_od)) {
$where[] = "o.datum >= \"{$search_date_od}\"";
}
if (!empty($search_date_do)) {
$where[] = "o.datum <= \"{$search_date_do}\"";
}
if (!empty($search_text) and $search_text != "undefined") {
$idecka = sql_query("SELECT id_obj\r\n FROM do_objednavka_row_search\r\n WHERE text LIKE '%{$search_text}%'");
foreach ($idecka as $idecko) {
$idecka_all[] = $idecko[id_obj];
}
$where[] = "o.id IN ( \r\n " . (count($idecka_all) > 0 ? implode(",", $idecka_all) : "NULL") . "\r\n )";
}
if (!empty($search_zakaznik) and $search_zakaznik != "undefined") {
$search_zakaznik_dia = rep_dia($search_zakaznik);
$idecka = sql_query("SELECT id_obj\r\n FROM do_objednavka_row_search\r\n WHERE zakaznik LIKE '%{$search_zakaznik}%'");
foreach ($idecka as $idecko) {
$idecka_all[] = $idecko[id_obj];
}
$where[] = "o.id IN ( \r\n " . (count($idecka_all) > 0 ? implode(",", $idecka_all) : "NULL") . "\r\n )";
}
if (!empty($search_id)) {
$where[] = "o.c_obj LIKE \"{$search_id}%\"";
}
//var_dump($where);
$query = "SELECT o.id, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i:%s') AS dat_upr, o.komplet, DATE_FORMAT(datum_email, '%d. %m. %Y, %H:%i:%s') AS datum_email, dod.meno as dodavatel, \r\n o.objednavka, o.poznamka \r\n FROM do_objednavka o\r\n INNER JOIN dodavatel dod\r\n ON o.id_dodavatel = dod.id\r\n WHERE " . implode(" AND ", $where) . "";
//echo $query;
$pager = pager("do_objednavka", $page, "do_objednavka", $query);
$page_from = $pager[page_from];
echo "<div class=\"pager\">Strany: " . implode(" | ", $pager[pages]) . "</div>";
function generate_csv_new($order, $revision, $sub = "")
{
mysql_query("BEGIN");
$rev = empty($revision) ? 0 : $revision;
sql_insert("INSERT INTO revizia_aktivita (uzivatel_id, revizia, status) \r\n VALUES ({$_SESSION[username]}, {$rev}, \"vytvorenie CSV\")");
$obj = sql_query("SELECT id, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum, status, c_obj\r\n FROM objednavka \r\n WHERE id=\"{$order}\"\r\n LIMIT 1");
$obj = $obj[0];
$rev = sql_query("SELECT DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum,\r\n meno, adresa, ico_icdph, telefon, email, id_material, id_vyrobca, id_hrubka, id_dekor,\r\n dekor_vlastny, komentar\r\n FROM revizia \r\n WHERE id_obj=\"{$order}\" AND id=\"{$revision}\"\r\n LIMIT 1");
$rev = $rev[0];
$c_obj = $obj["c_obj"];
$material = sql_query("SELECT meno, max_dlzka, max_sirka\r\n FROM material \r\n WHERE id=\"" . $rev["id_material"] . "\" \r\n LIMIT 1")[0];
$hrubka = sql_query("SELECT id, hodnota\r\n FROM hrubka \r\n WHERE id=\"" . $rev["id_hrubka"] . "\" \r\n LIMIT 1")[0];
if (is_duplak($hrubka["id"])) {
$hrubka["hodnota"] = "18";
}
$meno_csv = sec_input(rep_dia($rev[meno]));
$meno_csv = str_replace('/', "", $meno_csv);
$meno_csv = str_replace(" ", "", $meno_csv);
$meno_csv = str_replace(".", "", $meno_csv);
//$material[meno] = str_replace(" ", "", $material[meno]);
$vyrobca[meno] = str_replace(" ", "", $vyrobca[meno]);
if (strlen($meno_csv) > 10) {
$meno_csv = substr($meno_csv, 0, 10);
}
$directory = "files/csv_new/obj-{$order}/rev-{$revision}";
if (!file_exists($directory)) {
mkdir($directory, 0777, true);
}
if (!empty($sub) && $sub == "pasy") {
$meno_csv = $meno_csv . "-pasy";
}
$fp = fopen("{$directory}/{$c_obj}-{$meno_csv}.csv", "w+");
$rev[meno] = rep_dia($rev[meno]);
$rev[meno] = str_replace(" ", "_", $rev[meno]);
$meno_suboru = $rev[meno] . "" . (strlen($dekor[hodnota]) > 1 ? "_{$dekor['hodnota']}" : "") . "";
$meno_suboru = mb_substr($meno_suboru, 0, 20, "UTF-8");
//$rev[meno] = str_replace("/", "", $rev[meno]);
/*
$hlavicka = "0;".rep_dia($material["meno"]).";2800;2070;18;*;10;10;10;10;1
"; */
$hlavicka = "";
$hlavicka2 = "";
$nar = sql_query("SELECT ks, dlzka, sirka, nazov, poznamka, duplak, hrubka, orientacia,\r\n hrana1, hrana2, hrana3, hrana4, duplak_paska\r\n FROM porez \r\n WHERE id_revizia=\"{$revision}\"\r\n ");
$hrana = sql_query("SELECT id, hodnota, hodnota_csv, meno\r\n FROM hrana \r\n ");
if (empty($material["max_dlzka"])) {
$max_dlzka = def_value("max_dlzka", "hodnota");
} else {
$max_dlzka = $material["max_dlzka"];
}
if (empty($material["max_sirka"])) {
$max_sirka = def_value("max_sirka", "hodnota");
} else {
$max_sirka = $material["max_sirka"];
}
//dd($material);
foreach ($nar as $value) {
//var_dump($value);
$value[nazov] = str_replace(" ", "_", rep_dia($value[nazov]));
$value[poznamka] = str_replace(" ", "_", rep_dia($value[poznamka]));
$value[nazov] = preg_replace("/[^A-Z0-9a-z\\w ]/u", '', $value[nazov]);
$value[poznamka] = preg_replace("/[^A-Z0-9a-z\\w ]/u", '', $value[poznamka]);
//if ($value[orientacia]==0) $value[orientacia] = "";
/*
if (!empty($value[nazov])) {
$value[nazov] = $value[nazov];
} else {
$value[nazov] = $rev[meno];
}
if (!empty($value[poznamka])) {
$value[poznamka] = $value[poznamka];
} else {
$value[poznamka] = $rev[meno];
}
*/
if (strlen($value[nazov]) > 30) {
$value[nazov] = substr($value[nazov], 0, 30);
}
if (strlen($value[poznamka]) > 40) {
$value[poznamka] = substr($value[poznamka], 0, 40);
}
//var_dump($value[nazov]);
foreach ($hrana as $value_hrana) {
//var_dump($value_hrana);
for ($i = 1; $i < 5; $i++) {
if ($value_hrana[id] == $value["hrana" . $i]) {
$value["hrana" . $i] = $value_hrana[meno];
$value["hrana" . $i . "_hodnota"] = $value_hrana[hodnota];
}
if ($value["hrana" . $i] == "0") {
$value["hrana" . $i] = "";
}
if ($value["hrana" . $i] != "" and is_duplak($value[hrubka]) or $value["hrana" . $i] != "" and $value[duplak_paska] == 1) {
$value["hrana" . $i] = "42/2";
}
}
}
/*
$orientacia = sql_query("SELECT meno, hodnota FROM orientacia WHERE id=\"$value[orientacia]\" LIMIT 1");
$orientacia = $orientacia[0][hodnota];
*/
$orientacia = $value["orientacia"];
if ($orientacia == 3) {
$orientacia = 0;
} else {
$orientacia = 1;
}
// nastavenie pre duplak
// ak hrubka je totozna s prednastavenou hodnotou pre duplak,
// automaticky zmeni pocet kusov * 2,
// dlzku a sirku predlzi o 20 a znovu ich prevedie na string
//var_dump(def_value("default_duplak", "hodnota"));
//dd($value["hrubka"]);
if (is_duplak($value[hrubka])) {
$value[ks] = $value[ks] * 2;
$value[ks] = "{$value['ks']}";
$value[poznamka] = $value[poznamka] . " Dup " . $value[dlzka] . "x" . $value[sirka] . " (rez " . ($value[dlzka] + 15) . "x" . ($value[sirka] + 15) . ")";
$value[dlzka] = $value[dlzka] + 30;
$value[dlzka] = "{$value['dlzka']}";
$value[sirka] = $value[sirka] + 30;
$value[sirka] = "{$value['sirka']}";
}
$meno_materialu = rep_dia($material["meno"] . $hrubka["hodnota"]);
if (!empty($sub) && $sub == "pasy") {
$meno_materialu = "NaPasy" . $hrubka["hodnota"];
} else {
if ($value[dlzka] > $max_dlzka - 20) {
$value[dlzka] = $max_dlzka - 20;
}
if ($value[sirka] > $max_sirka - 20) {
$value[sirka] = $max_sirka - 20;
}
}
//if (count($value[hrana1_hodnota])<1) $value[hrana1_hodnota] = " ";
//dd($value);
$narezovka[] = array("ks" => $value[ks], "dlzka" => $value[dlzka], "sirka" => $value[sirka], "nazov" => $value[nazov] . "", "poznamka" => "{$value['poznamka']}", "orientacia" => "{$orientacia}", "{$value['hrana1']}", "{$value['hrana2']}", "{$value['hrana3']}", "{$value['hrana4']}", $meno_materialu);
}
//var_dump($narezovka);
//die();
if ($fp) {
fwrite($fp, $hlavicka);
//fputcsv($fp, array_values($row), ";");
//fwrite($fp, $hlavicka2);
foreach ($narezovka as $fields) {
fputcsv($fp, $fields, ";");
}
}
$status_obj = def_value("default_obj_status_spracovana", "hodnota");
if ($obj["status"] == def_value("default_obj_status_cp", "hodnota")) {
$status_obj = def_value("default_obj_status_cp_spracovana", "hodnota");
}
$query = "UPDATE objednavka\r\n SET status={$status_obj}\r\n WHERE id=\"{$order}\"";
sql_update($query);
mysql_query("COMMIT");
ob_end_clean();
header('Content-Type: application/download');
header('Content-Disposition: attachment; filename="' . $c_obj . '-' . $meno_csv . '.csv"');
//header("Content-Length: " . filesize("{$c_obj}-{$meno_csv}.csv"));
header('Pragma: no-cache');
readfile("{$directory}/{$c_obj}-{$meno_csv}.csv");
//header("location: {$directory}/{$c_obj}-{$meno_csv}.csv");
exit;
}
function edit($table, $vyber, $sub, $id, $page = 1)
{
$error_msg = array();
if ($_POST[submit]) {
$meno = sec_sql(sec_input($_POST["meno"]));
$adresa = sec_sql(sec_input($_POST["adresa"]));
$ico_icdph = sec_sql(sec_input($_POST["ico_icdph"]));
$telefon = sec_sql(sec_input($_POST["telefon"]));
$skupina = sec_sql(sec_input($_POST["skupina"]));
$id_c_hladina = sec_sql(sec_input($_POST["id_c_hladina"]));
$id_perm_uroven = sec_sql(sec_input($_POST["id_perm_uroven"]));
$hodnota = sec_sql(sec_input($_POST["hodnota"]));
$email = sec_sql(sec_input($_POST["email"]));
$email2 = sec_sql(sec_input($_POST["email2"]));
$old_password = sec_sql(sec_input($_POST["old_password"]));
$password = sec_sql(sec_input($_POST["password"]));
$password_confirm = sec_sql(sec_input($_POST["password_confirm"]));
$id_material = sec_sql(sec_input($_POST["id_material"]));
$id_vyrobca = sec_sql(sec_input($_POST["id_vyrobca"]));
$stvorakov = sec_sql(sec_input($_POST["stvorakov"]));
$stvorakov = str_replace(',', '.', $stvorakov);
$hodnota_csv = sec_sql(sec_input($_POST["hodnota_csv"]));
$id = sec_sql(sec_input($_POST["id"]));
$zobraz_vo_formulari = intval(sec_sql(sec_input($_POST["zobraz_vo_formulari"])));
$skryt_zakaznikom = intval(sec_sql(sec_input($_POST["skryt_zakaznikom"])));
if (strlen($meno) > 30 or strlen($meno) < 1) {
$error_msg[] = "Meno môže mať od 1 do 30 znakov";
}
if ($table == "vyrobca") {
if (strlen($hodnota) > 30 or strlen($hodnota) < 1) {
$error_msg[] = "Hodnota môže mať od 1 do 30 znakov";
}
}
if ($table == "hrana") {
//var_dump($zobraz_vo_formulari);
if ($zobraz_vo_formulari < 0) {
$error_msg[] = "Zobraz vo formulari ma nesprávnu hodnotu";
}
if (strlen($hodnota_csv) > 5 or strlen($hodnota_csv) < 1) {
$error_msg[] = "hodnota pre csv je povinný údaj a môže mať 5 znakov";
}
}
if ($table == "dekor") {
if ($_FILES["subor"]["name"]) {
$file_c = count($_FILES["subor"]["name"]);
if (!empty($_FILES["subor"]["name"]) and strlen($_FILES["subor"]["name"]) > 4) {
//echo "ok<br>";
$data[file_ext] = strtolower(end(explode(".", $_FILES["subor"]["name"])));
$data[file_name] = $id;
$data[file_name_old] = $_FILES["subor"]["name"];
$data[file_tmp_name] = $_FILES["subor"]["tmp_name"];
$data[file_size] = $_FILES["subor"]["size"];
//echo "ok<br>";
}
$form_data_file = array("file_name" => $data[file_name], "file_ext" => $data[file_ext], "file_size" => $data[file_size]);
$file_validate = dekor_img_validate($form_data_file);
}
if (count($file_validate) > 0) {
foreach ($file_validate as $message) {
$error_msg[] = $message;
}
}
}
if ($table == "uzivatel") {
//var_dump($skupina);
if (!is_numeric($skupina) or empty($skupina)) {
$error_msg[] = "skupina ma nesprávnu hodnotu";
}
//if(!is_numeric($id_c_hladina) or empty($id_c_hladina)) $error_msg[] = "cenova hladina ma nesprávnu hodnotu";
if ($skupina == 2) {
if (strlen($email) > 50 or strlen($email) < 8) {
$error_msg[] = "email je povinný údaj a môže mať od 8 do 50 znakov";
}
if (strlen($adresa) > 40 or strlen($adresa) < 6) {
$error_msg[] = "adresa je povinný údaj a môže mať od 8 do 50 znakov";
}
if (strlen($telefon) > 20 or strlen($telefon) < 5) {
$error_msg[] = "telefon je povinný údaj a môže mať od 8 do 50 znakov";
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$error_msg[] = "email je v nesprávnom tvare";
}
}
if (!is_numeric($id) or empty($id)) {
$error_msg[] = "ID ma nesprávnu hodnotu";
}
if (!empty($password) and !empty($old_password) and !empty($password_confirm)) {
$old_password_original = sql_query("SELECT heslo FROM {$table} WHERE id={$id} AND heslo=\"" . md5($old_password) . "\" LIMIT 1");
if (count($old_password_original) < 1) {
$error_msg[] = "Staré heslo nie je správne";
}
if (strlen($password) < 4 or strlen($password) > 30) {
$error_msg[] = "Heslo môže mať od 5 do 30 znakov";
}
if ($password != $password_confirm) {
$error_msg[] = "Heslá nie sú identické";
}
}
}
//var_dump($error_msg);
if (empty($error_msg)) {
$query = "UPDATE {$table}\n SET meno = \"{$meno}\", hodnota = \"{$hodnota}\"\n WHERE id = {$id}";
if ($table == "vyrobca") {
$query = "UPDATE {$table}\n SET meno = \"{$meno}\", hodnota = \"{$hodnota}\", id_material=\"{$id_material}\",\n skryt_zakaznikom=\"{$skryt_zakaznikom}\"\n WHERE id = {$id}";
}
if ($table == "cp_abs_vyrobca") {
$query = "UPDATE {$table}\n SET meno = \"{$meno}\"\n WHERE id = {$id}";
}
if ($table == "dekor") {
if (empty($stvorakov) or $stvorakov <= 0) {
$stvorakov = def_value("default_stvorak", "hodnota");
}
$hodnota = rep_dia($hodnota, 1);
$query = "UPDATE {$table}\n SET meno = \"{$meno}\", hodnota = \"{$hodnota}\", id_material=\"{$id_material}\", id_vyrobca=\"{$id_vyrobca}\",\n stvorakov=\"{$stvorakov}\", skryt_zakaznikom=\"{$skryt_zakaznikom}\"\n WHERE id = {$id}";
if ($data) {
$directory = "assets/images/dekor/";
if (!file_exists($directory)) {
mkdir($directory, 0777, true);
}
$filename = $data["file_tmp_name"];
$max_size = 250;
// percentage of resize
// Content type
//header('Content-type: image/jpeg');
// Get new dimensions
list($width, $height) = getimagesize($filename);
if ($width > $height) {
$percent = $max_size / $width;
$new_width = $max_size;
$new_height = $height * $percent;
} else {
$percent = $max_size / $height;
$new_height = $max_size;
$new_width = $width * $percent;
}
// Resample
$image_p = imagecreatetruecolor($new_width, $new_height);
$image = imagecreatefromjpeg($filename);
imagecopyresampled($image_p, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
// Output
imagejpeg($image_p, $directory . "/" . $data["file_name"] . "." . $data["file_ext"], 100);
move_uploaded_file($data["file_tmp_name"], $directory . "/orig_" . $data["file_name"] . "." . $data["file_ext"]);
//exit();
}
}
if ($table == "hrana") {
$query = "UPDATE {$table}\n SET meno = \"{$meno}\", hodnota = \"{$hodnota}\", hodnota_csv=\"{$hodnota_csv}\",\n zobraz_vo_formulari = \"{$zobraz_vo_formulari}\"\n WHERE id = {$id}";
}
if ($table == "hrubka") {
$query = "UPDATE {$table}\n SET meno = \"{$meno}\", hodnota = \"{$hodnota}\", id_material=\"{$id_material}\"\n WHERE id = {$id}";
}
if ($table == "uzivatel") {
if (empty($password) or empty($old_password) or empty($password_confirm)) {
$query = "UPDATE {$table}\n SET meno = \"{$meno}\", adresa = \"{$adresa}\", ico_icdph = \"{$ico_icdph}\", \n email = \"{$email}\", email2 = \"{$email2}\", telefon = \"{$telefon}\", skupina = \"{$skupina}\",\n id_c_hladina = \"{$id_c_hladina}\", perm_uroven_id = \"{$id_perm_uroven}\"\n WHERE id = {$id}";
} else {
$password = md5($password);
$query = "UPDATE {$table}\n SET meno = \"{$meno}\", email = \"{$email}\", heslo = \"{$password}\"\n WHERE id = {$id}";
}
}
sql_update($query);
//echo $id_perm_uroven;
header("location: index.php?vyber=nastavenia&sub={$table}&page={$page}");
exit;
} else {
echo "<div id=error_message>" . implode("<br>", $error_msg) . "</div>";
}
}
$id = sec_sql($id);
$query = "Select id, hodnota, meno from " . PREFIX . "{$table} WHERE id={$id}";
if ($table == "vyrobca") {
$query = "Select id, id_material, hodnota, meno, skryt_zakaznikom from {$table} WHERE id={$id}";
}
if ($table == "cp_abs_vyrobca") {
$query = "Select id, meno from {$table} WHERE id={$id}";
}
if ($table == "dekor") {
$query = "Select id, id_material, id_vyrobca, hodnota, meno, stvorakov, skryt_zakaznikom from {$table} WHERE id={$id}";
}
if ($table == "hrana") {
$query = "Select id, hodnota, hodnota_csv, meno, zobraz_vo_formulari from {$table} WHERE id={$id}";
}
if ($table == "hrubka") {
$query = "Select id, hodnota, meno, id_material from {$table} WHERE id={$id}";
}
if ($table == "uzivatel") {
$query = "Select id, meno, adresa, ico_icdph, telefon, email, email2, skupina, id_c_hladina, perm_uroven_id from {$table} WHERE id={$id}";
}
$value = sql_query($query);
$value = $value[0];
echo "<form method=\"POST\" enctype=\"multipart/form-data\">";
hidden("id", $value[id]);
echo textfield("meno", $value[meno], "Meno", 50, 30);
if ($table != "uzivatel" and $table != "cp_abs_vyrobca") {
echo textfield("hodnota", $value[hodnota], "Hodnota", 50, 30);
//echo "hej";
}
if ($table == "vyrobca" or $table == "hrubka") {
echo select("id_material", "Materiál", "SELECT id, hodnota, meno FROM material WHERE vymaz=0", $value[id_material]);
}
if ($table == "vyrobca") {
$zobraz_vo = array(1 => "skryť", 0 => "zobraz");
echo select("skryt_zakaznikom", "zobraz zákaznikom", "", $value[skryt_zakaznikom], "", "", "", "NO", $zobraz_vo);
}
if ($table == "dekor") {
echo select("id_material", "Materiál", "SELECT id, hodnota, meno FROM material WHERE vymaz=0", $value[id_material]);
echo select("id_vyrobca", "Výrobca", "SELECT id, hodnota, meno FROM vyrobca WHERE vymaz=0", $value[id_vyrobca]);
$zobraz_vo = array(1 => "skryť", 0 => "zobraz");
echo select("skryt_zakaznikom", "zobraz zákaznikom", "", $value[skryt_zakaznikom], "", "", "", "NO", $zobraz_vo);
echo textfield("stvorakov", $value[stvorakov], "stvorakov v tab.", 20, 10);
file_upload("subor", "subor", "Príloha");
if (isset($_GET["rotate"])) {
$rotate = sec_input($_GET["rotate"]);
}
if ($rotate == 1) {
$rotateFilename = "assets/images/dekor/{$value[id]}.jpg";
// PATH
if (file_exists($rotateFilename)) {
$degrees = 90;
//header('Content-type: image/jpeg');
$source = imagecreatefromjpeg($rotateFilename);
// Rotate
$rotate = imagerotate($source, $degrees, 0);
imagejpeg($rotate, $rotateFilename, 100);
imagedestroy($source);
imagedestroy($rotate);
//echo "ok";
}
}
if (file_exists("assets/images/dekor/{$value[id]}.jpg")) {
echo "<img src=\"assets/images/dekor/{$value[id]}.jpg?rand=" . microtime() . "\">";
echo "<br><a href=\"?vyber={$vyber}&sub={$sub}&action=edit&id={$id}&page={$page}&rotate=1\">Otočiť obrázok o 90st doprava</a>";
}
}
if ($table == "hrana") {
//var_dump($value);
$zobraz_vo = array(1 => "zobraz", 0 => "nezobrazuj");
echo textfield("hodnota_csv", $value[hodnota_csv], "Hodnota pre CSV", 40, 20);
echo select("zobraz_vo_formulari", "vo formulári", "", $value[zobraz_vo_formulari], "", "", "", "NO", $zobraz_vo);
}
if ($table == "uzivatel") {
if ($id == 1) {
echo "<strong>Nie je možné upravovať hlavného administrátora!</strong>";
die;
}
echo textfield("adresa", $value[adresa], "adresa", 40, 20);
echo textfield("ico_icdph", $value[ico_icdph], "ičo / ičdph", 40, 20);
echo textfield("telefon", $value[telefon], "telefón", 40, 20);
echo textfield("email", $value[email], "email", 40, 20);
echo textfield("email2", $value[email2], "email2", 40, 20);
echo select("skupina", "Skupina", "SELECT id, meno FROM uzivatel_skupina WHERE vymaz=0", $value[skupina], "", "", "", "NO");
echo select("id_c_hladina", "Cen.hladina", "SELECT id, meno FROM c_hladina WHERE vymaz=0", $value[id_c_hladina]);
echo select("id_perm_uroven", "Úroveň zabezp.", "SELECT id, meno FROM perm_uroven WHERE vymaz=0", $value[perm_uroven_id]);
echo textfield("old_password", $value[password], "Staré heslo", 40, 20);
echo textfield("password", $value[password], "Nové heslo", 40, 20);
echo textfield("password_confirm", "", "zopakujte heslo", 40, 20);
}
echo submit("submit", "Odoslať");
echo "<a href=\"?vyber={$vyber}&sub={$sub}\">Späť</a>";
echo "</form>";
}
function edit($table, $vyber, $sub, $id, $page = 1)
{
$error_msg = array();
if ($_POST[submit]) {
//var_dump($_POST);
//exit();
$meno = sec_sql(sec_input($_POST["meno"]));
$adresa = sec_sql(sec_input($_POST["adresa"]));
$mesto = sec_sql(sec_input($_POST["mesto"]));
$psc = sec_sql(sec_input($_POST["psc"]));
$ico = sec_sql(sec_input($_POST["ico"]));
$dic = sec_sql(sec_input($_POST["dic"]));
$doruc_meno = sec_sql(sec_input($_POST["doruc_meno"]));
$doruc_adresa = sec_sql(sec_input($_POST["doruc_adresa"]));
$doruc_mesto = sec_sql(sec_input($_POST["doruc_mesto"]));
$doruc_psc = sec_sql(sec_input($_POST["doruc_psc"]));
$doruc_telefon = sec_sql(sec_input($_POST["doruc_telefon"]));
$telefon = sec_sql(sec_input($_POST["telefon"]));
$skupina = sec_sql(sec_input($_POST["skupina"]));
$id_perm_uroven = sec_sql(sec_input($_POST["id_perm_uroven"]));
$email = sec_sql(sec_input($_POST["email"]));
$email2 = sec_sql(sec_input($_POST["email2"]));
$old_password = sec_sql(sec_input($_POST["old_password"]));
$password = sec_sql(sec_input($_POST["password"]));
$password_confirm = sec_sql(sec_input($_POST["password_confirm"]));
$id_product_type = sec_sql(sec_input($_POST["product_type"]));
$id_product = sec_sql(sec_input($_POST["product"]));
$montazny_balik = sec_sql(sec_input($_POST["montazny_balik"]));
$ean = sec_sql(sec_input($_POST["ean"]));
$id_product_atribute = sec_sql(sec_input($_POST["product_atribute"]));
$c_hladina = sec_sql(sec_input($_POST["c_hladina"]));
if (isset($_POST["product_types"])) {
foreach ($_POST["product_types"] as $product_t) {
$product_types[] = sec_sql(sec_input($product_t));
}
}
if (isset($_POST["product_packages"])) {
foreach ($_POST["product_packages"] as $product_p) {
$product_packages[] = sec_sql(sec_input($product_p));
}
}
$id = sec_sql(sec_input($_POST["id"]));
$zobraz_vo_formulari = intval(sec_sql(sec_input($_POST["zobraz_vo_formulari"])));
$skryt_zakaznikom = intval(sec_sql(sec_input($_POST["skryt_zakaznikom"])));
$skryt_prihlasenym = intval(sec_sql(sec_input($_POST["skryt_prihlasenym"])));
$def = intval(sec_sql(sec_input($_POST["def"])));
$skryt_atributy = intval(sec_sql(sec_input($_POST["skryt_atributy"])));
//var_dump($_POST);
//exit();
if ($table != "ean") {
if (strlen($meno) > 30 or strlen($meno) < 1) {
$error_msg[] = "Meno môže mať od 1 do 30 znakov";
}
}
if ($table == "ean") {
if (strlen($ean) > 13 or strlen($ean) < 13) {
$error_msg[] = "EAN kód môže mať iba 13 znakov";
}
$code = "2-" . $id_product . "-" . $id_product_atribute;
$before = sql_query("SELECT code from {$table} WHERE id=" . $id)[0]["code"];
$exist = 0;
if ($code == $before) {
$exist = 0;
} else {
$exists = sql_query("SELECT id from {$table} WHERE code=\"{$code}\"");
if (count($exists) > 0) {
$exist = 1;
}
}
//dd($exists);
if ($exist == 1) {
$error_msg[] = "Tento produkt sa už nachádza v databáze";
}
}
if ($table == "hrana") {
//var_dump($zobraz_vo_formulari);
if ($zobraz_vo_formulari < 0) {
$error_msg[] = "Zobraz vo formulari ma nesprávnu hodnotu";
}
if (strlen($hodnota_csv) > 5 or strlen($hodnota_csv) < 1) {
$error_msg[] = "hodnota pre csv je povinný údaj a môže mať 5 znakov";
}
}
if ($table == "dekor") {
if ($_FILES["subor"]["name"]) {
$file_c = count($_FILES["subor"]["name"]);
if (!empty($_FILES["subor"]["name"]) and strlen($_FILES["subor"]["name"]) > 4) {
//echo "ok<br>";
$data[file_ext] = strtolower(end(explode(".", $_FILES["subor"]["name"])));
$data[file_name] = $id;
$data[file_name_old] = $_FILES["subor"]["name"];
$data[file_tmp_name] = $_FILES["subor"]["tmp_name"];
$data[file_size] = $_FILES["subor"]["size"];
//echo "ok<br>";
}
$form_data_file = array("file_name" => $data[file_name], "file_ext" => $data[file_ext], "file_size" => $data[file_size]);
$file_validate = dekor_img_validate($form_data_file);
}
if (count($file_validate) > 0) {
foreach ($file_validate as $message) {
$error_msg[] = $message;
}
}
}
if ($table == "uzivatel") {
//var_dump($skupina);
if (!is_numeric($skupina) or empty($skupina)) {
$error_msg[] = "skupina ma nesprávnu hodnotu";
}
//if(!is_numeric($id_c_hladina) or empty($id_c_hladina)) $error_msg[] = "cenova hladina ma nesprávnu hodnotu";
if ($skupina == 2) {
if (strlen($email) > 50 or strlen($email) < 8) {
$error_msg[] = "email je povinný údaj a môže mať od 8 do 50 znakov";
}
if (strlen($adresa) > 40 or strlen($adresa) < 6) {
$error_msg[] = "adresa je povinný údaj a môže mať od 8 do 50 znakov";
}
if (strlen($telefon) > 20 or strlen($telefon) < 5) {
$error_msg[] = "telefon je povinný údaj a môže mať od 8 do 50 znakov";
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$error_msg[] = "email je v nesprávnom tvare";
}
}
if (!is_numeric($id) or empty($id)) {
$error_msg[] = "ID ma nesprávnu hodnotu";
}
if (!empty($password) and !empty($old_password) and !empty($password_confirm)) {
$old_password_original = sql_query("SELECT heslo FROM {$table} WHERE id={$id} AND heslo=\"" . md5($old_password) . "\" LIMIT 1");
if (count($old_password_original) < 1) {
$error_msg[] = "Staré heslo nie je správne";
}
if (strlen($password) < 4 or strlen($password) > 30) {
$error_msg[] = "Heslo môže mať od 5 do 30 znakov";
}
if ($password != $password_confirm) {
$error_msg[] = "Heslá nie sú identické";
}
}
}
//var_dump($error_msg);
if (empty($error_msg)) {
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\" \r\n WHERE id = {$id}";
if ($table == "product_type") {
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\", skryt_zakaznikom=\"{$skryt_zakaznikom}\", def=\"{$def}\"\r\n WHERE id = {$id}";
}
if ($table == "product") {
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\", id_product_type=\"{$id_product_type}\", montazny_balik = \"{$montazny_balik}\",\r\n skryt_zakaznikom=\"{$skryt_zakaznikom}\", skryt_prihlasenym=\"{$skryt_prihlasenym}\", skryt_atributy = \"{$skryt_atributy}\", def=\"{$def}\"\r\n WHERE id = {$id}";
}
if ($table == "product_delivery") {
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\", skryt_zakaznikom=\"{$skryt_zakaznikom}\", def=\"{$def}\"\r\n WHERE id = {$id}";
}
if ($table == "product_atribute") {
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\", skryt_zakaznikom=\"{$skryt_zakaznikom}\", def=\"{$def}\"\r\n WHERE id = {$id}";
}
if ($table == "ean") {
$query = "UPDATE {$table}\r\n SET code = \"{$code}\", ean=\"{$ean}\"\r\n WHERE id = {$id}";
}
if ($table == "product_atribute_option") {
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\", id_product_atribute=\"{$id_product_atribute}\",\r\n id_c_hladina = \"{$c_hladina}\", skryt_zakaznikom=\"{$skryt_zakaznikom}\", def=\"{$def}\"\r\n WHERE id = {$id}";
}
if ($table == "cp_abs_vyrobca") {
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\"\r\n WHERE id = {$id}";
}
if ($table == "dekor") {
if (empty($stvorakov) or $stvorakov <= 0) {
$stvorakov = def_value("default_stvorak", "hodnota");
}
$hodnota = rep_dia($hodnota, 1);
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\", hodnota = \"{$hodnota}\", id_material=\"{$id_material}\", id_vyrobca=\"{$id_vyrobca}\",\r\n stvorakov=\"{$stvorakov}\", kubikov=\"{$kubikov}\", skryt_zakaznikom=\"{$skryt_zakaznikom}\"\r\n WHERE id = {$id}";
if ($data) {
$directory = "assets/images/dekor/";
if (!file_exists($directory)) {
mkdir($directory, 0777, true);
}
$filename = $data["file_tmp_name"];
$max_size = 250;
// percentage of resize
// Content type
//header('Content-type: image/jpeg');
// Get new dimensions
list($width, $height) = getimagesize($filename);
if ($width > $height) {
$percent = $max_size / $width;
$new_width = $max_size;
$new_height = $height * $percent;
} else {
$percent = $max_size / $height;
$new_height = $max_size;
$new_width = $width * $percent;
}
// Resample
$image_p = imagecreatetruecolor($new_width, $new_height);
$image = imagecreatefromjpeg($filename);
imagecopyresampled($image_p, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
// Output
imagejpeg($image_p, $directory . "/" . $data["file_name"] . "." . $data["file_ext"], 100);
move_uploaded_file($data["file_tmp_name"], $directory . "/orig_" . $data["file_name"] . "." . $data["file_ext"]);
//exit();
}
}
if ($table == "uzivatel") {
if (empty($password) or empty($old_password) or empty($password_confirm)) {
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\", adresa = \"{$adresa}\", mesto = \"{$mesto}\", ico = \"{$ico}\", \r\n psc = \"{$psc}\", dic = \"{$dic}\", doruc_meno = \"{$doruc_meno}\", \r\n doruc_adresa = \"{$doruc_adresa}\", doruc_mesto = \"{$doruc_mesto}\",\r\n doruc_psc = \"{$doruc_psc}\", doruc_telefon = \"{$doruc_telefon}\",\r\n email = \"{$email}\", email2 = \"{$email2}\", telefon = \"{$telefon}\", skupina = \"{$skupina}\",\r\n perm_uroven_id = \"{$id_perm_uroven}\"\r\n WHERE id = {$id}";
} else {
$password = md5($password);
$query = "UPDATE {$table}\r\n SET meno = \"{$meno}\", adresa = \"{$adresa}\", mesto = \"{$mesto}\", ico = \"{$ico}\", \r\n psc = \"{$psc}\", dic = \"{$dic}\", doruc_meno = \"{$doruc_meno}\", \r\n doruc_adresa = \"{$doruc_adresa}\", doruc_mesto = \"{$doruc_mesto}\",\r\n doruc_psc = \"{$doruc_psc}\", doruc_telefon = \"{$doruc_telefon}\",\r\n email = \"{$email}\", email2 = \"{$email2}\", telefon = \"{$telefon}\", skupina = \"{$skupina}\",\r\n perm_uroven_id = \"{$id_perm_uroven}\" heslo = \"{$password}\"\r\n WHERE id = {$id}";
}
}
sql_update($query);
if ($table == "product_atribute") {
$exists = sql_delete("DELETE from product_atribute_product_types\r\n WHERE id_product_atribute = {$id} \r\n ");
foreach ($product_types as $product_type) {
sql_insert("INSERT INTO product_atribute_product_types \r\n (id_product_atribute, id_product_type)\r\n VALUES\r\n ({$id}, {$product_type})\r\n ");
}
}
if ($table == "product_delivery") {
$exists = sql_delete("DELETE from product_delivery_product_types\r\n WHERE id_product_delivery = {$id} \r\n ");
foreach ($product_types as $product_type) {
sql_insert("INSERT INTO product_delivery_product_types \r\n (id_product_delivery, id_product_type)\r\n VALUES\r\n ({$id}, {$product_type})\r\n ");
}
}
if ($table == "product") {
$exists = sql_delete("DELETE from product_packages\r\n WHERE id_product = {$id} \r\n ");
foreach ($product_packages as $package) {
sql_insert("INSERT INTO product_packages \r\n (id_product, meno)\r\n VALUES\r\n ({$id}, \"{$package}\")\r\n ");
}
}
//echo $id_perm_uroven;
header("location: index.php?vyber=nastavenia&sub={$table}&page={$page}");
exit;
} else {
echo "<div id=error_message>" . implode("<br>", $error_msg) . "</div>";
}
}
$id = sec_sql($id);
$query = "Select id, meno from " . PREFIX . "{$table} WHERE id={$id}";
if ($table == "product_type") {
$query = "Select id, meno, skryt_zakaznikom, def from {$table} WHERE id={$id}";
}
if ($table == "product") {
$query = "Select id, id_product_type, meno, montazny_balik, skryt_zakaznikom, skryt_prihlasenym, skryt_atributy, def from {$table} WHERE id={$id}";
}
if ($table == "ean") {
$query = "Select id, code, ean from {$table} WHERE id={$id}";
}
if ($table == "product_delivery") {
$query = "Select id, meno, skryt_zakaznikom, def from {$table} WHERE id={$id}";
}
if ($table == "product_atribute") {
$query = "Select id, meno, skryt_zakaznikom, def from {$table} WHERE id={$id}";
}
if ($table == "product_atribute_option") {
$query = "Select id, id_product_atribute, id_c_hladina, meno, skryt_zakaznikom, def from {$table} WHERE id={$id}";
}
if ($table == "cp_abs_vyrobca") {
$query = "Select id, meno from {$table} WHERE id={$id}";
}
if ($table == "dekor") {
$query = "Select id, id_material, id_vyrobca, hodnota, meno, stvorakov, kubikov, skryt_zakaznikom from {$table} WHERE id={$id}";
}
if ($table == "hrana") {
$query = "Select id, hodnota, hodnota_csv, meno, zobraz_vo_formulari from {$table} WHERE id={$id}";
}
if ($table == "hrubka") {
$query = "Select id, hodnota, meno, id_material from {$table} WHERE id={$id}";
}
if ($table == "uzivatel") {
$query = "Select id, meno, adresa, mesto, psc, ico, dic, telefon, email, email2,\r\n doruc_meno, doruc_adresa, doruc_mesto, doruc_psc, doruc_telefon, skupina, perm_uroven_id \r\n FROM {$table} WHERE id={$id}";
}
$value = sql_query($query);
$value = $value[0];
echo "<form method=\"POST\" enctype=\"multipart/form-data\" class=\"nastavenia_form\">";
echo hidden("id", $value[id]);
if ($table != "ean") {
echo textfield("meno", $value[meno], "Meno", 50, 30);
}
if ($table == "product_type") {
$zorad = array(1 => "navrchu", 0 => "normálne");
echo select("def", "poradie", "", $value[def], "", "", "", "NO", $zorad);
$zobraz_vo = array(1 => "skryť", 0 => "zobraz");
echo select("skryt_zakaznikom", "zobraz zákazníkom", "", $value[skryt_zakaznikom], "", "", "", "NO", $zobraz_vo);
}
if ($table == "ean") {
$arr = explode("-", $value["code"]);
echo select("product", "Produkt", "SELECT id, meno FROM product WHERE vymaz=0 AND id_product_type=2 ORDER BY meno ASC", $arr[1], "-vyberte si-", "", "", "NO");
echo select("product_atribute", "rozmer", "SELECT id, meno FROM product_atribute_option WHERE id_product_atribute=2 AND vymaz=0 ORDER BY def DESC, meno ASC", $arr[2], "-vyberte si-", "", "", "NO");
echo textfield("ean", $value["ean"], "EAN *", 13, 16);
}
if ($table == "product") {
echo select("product_type", "Typ produktu", "SELECT id, meno FROM product_type WHERE vymaz=0", $value[id_product_type]);
$zorad = array(1 => "navrchu", 0 => "normálne");
echo select("def", "poradie", "", $value[def], "", "", "", "NO", $zorad);
}
if ($table == "product") {
$zobraz_vo = array(1 => "skryť", 0 => "zobraz");
echo select("skryt_zakaznikom", "zobraz zákazníkom", "", $value[skryt_zakaznikom], "", "", "", "NO", $zobraz_vo);
echo select("skryt_prihlasenym", "zobraz prihláseným", "", $value[skryt_prihlasenym], "", "", "", "NO", $zobraz_vo);
echo select("skryt_atributy", "zobraz atribúty", "", $value[skryt_atributy], "", "", "", "NO", $zobraz_vo);
echo textfield("montazny_balik", $value[montazny_balik], "Mont. balík", 20, 15);
$product_packages = sql_query("SELECT id, meno FROM product_packages WHERE id_product={$id}");
echo '<div class="input_fields_wrap">';
$count = 1;
//var_dump($product_packages);
if (count($product_packages) > 0) {
foreach ($product_packages as $package) {
echo "<div><label>Balenie</label><input type=\"text\" name=\"product_packages[]\" size=15 maxlength=25 value=\"{$package["meno"]}\"><a href=\"#\" class=\"remove_field\">X</a></div>";
$count = $count + 1;
}
} else {
echo '<div><label>Balenie</label><input type="text" name="product_packages[]" size=15 maxlength=25><a href="#" class="remove_field">X</a></div>';
}
echo "</div>";
echo '<button class="add_field_button">Vlož ďalšie balenie</button>';
}
if ($table == "product_atribute") {
//echo select("product_type", "Typ produktu", "SELECT id, meno FROM product_type WHERE vymaz=0", $value[id_product_type]);
$zorad = array(1 => "navrchu", 0 => "normálne");
echo select("def", "poradie", "", $value[def], "", "", "", "NO", $zorad);
$selected = sql_query("SELECT id_product_type from product_atribute_product_types\r\n WHERE id_product_atribute = {$id}\r\n ");
foreach ($selected as $select) {
$sel[] = $select[id_product_type];
}
$product_types = sql_query("SELECT id, meno FROM product_type WHERE vymaz=0");
foreach ($product_types as $product_type) {
$checked = in_array($product_type["id"], $sel) ? "checked" : "";
echo "<input type=\"checkbox\" name=\"product_types[]\" value=\"{$product_type["id"]}\" {$checked}>{$product_type["meno"]}<br>";
}
}
if ($table == "product_delivery") {
//echo select("product_type", "Typ produktu", "SELECT id, meno FROM product_type WHERE vymaz=0", $value[id_product_type]);
$zorad = array(1 => "navrchu", 0 => "normálne");
echo select("def", "poradie", "", $value[def], "", "", "", "NO", $zorad);
$selected = sql_query("SELECT id_product_type from product_delivery_product_types\r\n WHERE id_product_delivery = {$id}\r\n ");
foreach ($selected as $select) {
$sel[] = $select[id_product_type];
}
$product_types = sql_query("SELECT id, meno FROM product_type WHERE vymaz=0");
foreach ($product_types as $product_type) {
$checked = in_array($product_type["id"], $sel) ? "checked" : "";
echo "<input type=\"checkbox\" name=\"product_types[]\" value=\"{$product_type["id"]}\" {$checked}>{$product_type["meno"]}<br>";
}
}
if ($table == "product_atribute_option") {
echo select("product_atribute", "Filtruj Atribút", "SELECT a.id as id, a.meno as meno \r\n FROM product_atribute as a \r\n WHERE a.vymaz=0 ORDER BY a.meno", $value[id_product_atribute]);
echo select("c_hladina", "Cen. hladina", "SELECT id, meno FROM c_hladina WHERE vymaz=0", $value[id_c_hladina], "", "", "", "NO");
$zorad = array(1 => "navrchu", 0 => "normálne");
echo select("def", "poradie", "", $value[def], "", "", "", "NO", $zorad);
}
if ($table == "vyrobca") {
$zobraz_vo = array(1 => "skryť", 0 => "zobraz");
echo select("skryt_zakaznikom", "zobraz zákaznikom", "", $value[skryt_zakaznikom], "", "", "", "NO", $zobraz_vo);
}
if ($table == "dekor") {
echo select("id_material", "Materiál", "SELECT id, hodnota, meno FROM material WHERE vymaz=0", $value[id_material]);
echo select("vyrobca", "Výrobca", "SELECT id, hodnota, meno FROM vyrobca WHERE vymaz=0", $value[id_vyrobca]);
$zobraz_vo = array(1 => "skryť", 0 => "zobraz");
echo select("skryt_zakaznikom", "zobraz zákaznikom", "", $value[skryt_zakaznikom], "", "", "", "NO", $zobraz_vo);
file_upload("subor", "subor", "Príloha");
if (isset($_GET["rotate"])) {
$rotate = sec_input($_GET["rotate"]);
}
if ($rotate == 1) {
$rotateFilename = "assets/images/dekor/{$value[id]}.jpg";
// PATH
if (file_exists($rotateFilename)) {
$degrees = 90;
//header('Content-type: image/jpeg');
$source = imagecreatefromjpeg($rotateFilename);
// Rotate
$rotate = imagerotate($source, $degrees, 0);
imagejpeg($rotate, $rotateFilename, 100);
imagedestroy($source);
imagedestroy($rotate);
//echo "ok";
}
}
if (file_exists("assets/images/dekor/{$value[id]}.jpg")) {
echo "<img src=\"assets/images/dekor/{$value[id]}.jpg?rand=" . microtime() . "\">";
echo "<br><a href=\"?vyber={$vyber}&sub={$sub}&action=edit&id={$id}&page={$page}&rotate=1\">Otočiť obrázok o 90st doprava</a>";
}
}
if ($table == "uzivatel") {
if ($id == 1) {
echo "<strong>Nie je možné upravovať hlavného administrátora!</strong>";
die;
}
echo textfield("adresa", $value[adresa], "adresa", 40, 20);
echo textfield("mesto", $value[mesto], "Mesto", 50, 20);
echo textfield("psc", $value[psc], "PSČ", 50, 20);
echo textfield("ico", $value[ico], "IČO", 15, 20);
echo textfield("dic", $value[dic], "DIČ", 15, 20);
echo textfield("doruc_meno", $value[doruc_meno], "Meno doručenia", 40, 20);
echo textfield("doruc_adresa", $value[doruc_adresa], "Adresa doručenia", 50, 20);
echo textfield("doruc_mesto", $value[doruc_mesto], "Mesto doručenia", 50, 20);
echo textfield("doruc_psc", $value[doruc_psc], "PSČ doručenia", 50, 20);
echo textfield("doruc_telefon", $value[doruc_telefon], "Telefon doručenia", 50, 20);
echo textfield("telefon", $value[telefon], "telefón", 40, 20);
echo textfield("email", $value[email], "email", 40, 20);
echo textfield("email2", $value[email2], "email2", 40, 20);
echo select("skupina", "Skupina", "SELECT id, meno FROM uzivatel_skupina WHERE vymaz=0", $value[skupina], "", "", "", "NO");
echo select("id_perm_uroven", "Úroveň zabezp.", "SELECT id, meno FROM perm_uroven WHERE vymaz=0", $value[perm_uroven_id]);
echo textfield("old_password", $value[password], "Staré heslo", 40, 20);
echo textfield("password", $value[password], "Nové heslo", 40, 20);
echo textfield("password_confirm", "", "zopakujte heslo", 40, 20);
}
echo submit("submit", "Odoslať");
echo "<a href=\"?vyber={$vyber}&sub={$sub}\">Späť</a>";
echo "</form>";
}
