function display_all_revisions($order) { $objednavka = sql_query("SELECT id, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum, c_obj, id_zakaznik, komplet, vymaz, status, komentar_private \r\n FROM objednavka \r\n WHERE id=\"{$order}\" LIMIT 1"); $objednavka = $objednavka[0]; echo "<h1>Objednávka č. {$objednavka['c_obj']} " . (def_value("default_obj_status_spracovana", "hodnota") == $objednavka["status"] ? "<span class=\"red_text paddet\">SPRACOVANÁ</span>" : "") . "</h1>"; echo "<div class=\"main_box_33\">"; $access = check_access_true("objednavka_edit"); if ($access == TRUE) { echo "<form method=\"POST\">"; echo select("zakaznik", "Priradená zákazníkovi", "SELECT id, meno FROM uzivatel WHERE vymaz=0 AND skupina=2 ORDER BY meno", $objednavka[id_zakaznik], "---", "", ""); echo submit("save_zakaznik", "Priradiť"); echo "</form>"; } echo "</div>"; echo "<table id=\"all_revisions\">"; $revizia = sql_query("\r\n SELECT revizia.id, revizia.meno, revizia.adresa, material.meno AS mat_meno,\r\n DATE_FORMAT(revizia.datum, '%d. %m. %Y, %H:%i') AS dat_upr,\r\n vyrobca.meno as vyr_meno, dekor.meno as dek_meno, revizia.dekor_vlastny,\r\n uzivatel.meno as uziv_meno\r\n FROM revizia\r\n LEFT JOIN material\r\n ON revizia.id_material=material.id \r\n LEFT JOIN vyrobca\r\n ON revizia.id_vyrobca=vyrobca.id\r\n LEFT JOIN dekor\r\n ON revizia.id_dekor=dekor.id\r\n LEFT JOIN uzivatel\r\n ON revizia.upravil=uzivatel.id\r\n WHERE revizia.id_obj = \"" . $order . "\"\r\n ORDER BY revizia.datum DESC\r\n "); //var_dump($revizia); foreach ($revizia as $rev) { $is_cp = sql_query("SELECT count(id) as count FROM cp \r\n WHERE id_revizia = \"" . $rev[id] . "\""); $is_cp = $is_cp[0][count]; $email_cp = sql_query("SELECT DATE_FORMAT(datum_email, '%d. %m. %Y, %H:%i') AS datum_email_upr FROM cp \r\n WHERE id_revizia = \"" . $rev[id] . "\" AND datum_email <>0 LIMIT 1"); //$email_cp = count($email_cp); //var_dump($email_cp); $query_vyroba = "SELECT count(status) status FROM revizia_vyroba WHERE id_obj=" . $order . " AND id_revizia=\"" . $rev[id] . "\" AND status>0"; $query_vyroba = sql_query($query_vyroba); $display_rev = 1; if ($access == TRUE) { $adressto = "objednavky"; } else { $adressto = "vyroba"; $filename = "files/csv_new/obj-{$order}/rev-{$rev[id]}/*.csv"; //var_dump(glob($filename)); if (glob($filename) != false) { $display_rev = 1; } else { $display_rev = 0; } } //echo $display_rev; if ($display_rev > 0) { echo "\r\n <tr>\r\n <td class=\"obj_cislo\">" . $rev[id] . "</td>\r\n <td class=\"obj_datum\">\r\n " . $rev["dat_upr"] . "</td>\r\n <td class=\"obj_meno\">\r\n <a href=\"?vyber={$adressto}&order=" . $order . "&revision=" . $rev[id] . "\">\r\n " . $rev[meno] . "" . (!empty($rev[adresa]) ? ", " . $rev[adresa] : "") . "</a>\r\n </td>\r\n <td class=\"obj_material\">\r\n " . $rev[mat_meno] . "" . (!empty($rev[vyr_meno]) ? ", " . $rev[vyr_meno] : "") . "" . (!empty($rev[dek_meno]) ? ", " . $rev[dek_meno] : "") . "" . (!empty($rev[dekor_vlastny]) ? ", " . $rev[dekor_vlastny] : "") . "</td>\r\n <td class=\"obj_icons\">" . ($is_cp > 0 ? "<a href=\"?vyber=cp&order={$order}&revision=" . $rev[id] . "&action=display_all\"><img src=\"assets/images/euro.png\" title=\"Objednávka má vypracované Cenové Ponuky: {$is_cp}\"></a>" : "<img src=\"assets/images/euro_no.png\" title=\"Objednávka bez Cenových ponúk\">") . "\r\n " . (count($email_cp) > 0 ? "<img src=\"assets/images/checked.png\" title=\"CP odoslaná: " . $email_cp[0]["datum_email_upr"] . "\">" : "") . " \r\n <a href=\"?vyber=vyroba&order={$order}&revision=" . $rev[id] . "\">" . ($query_vyroba[0]["status"] > 0 ? "<img src=\"assets/images/vyroba.png\" title=\"Objednávka vo výrobe\">" : "<img src=\"assets/images/vyroba_no.png\" title=\"Bez výroby\">") . "</a>\r\n " . (!empty($rev["uziv_meno"]) ? "<span class=\"upravil\">" . $rev["uziv_meno"] . "</span>" : "") . " \r\n </td> \r\n \r\n </tr>\r\n "; } } echo "</table>"; // zobrazenie detailov objednávky echo "<div class=\"new_task_form_poznamka\">"; echo "<form method=\"POST\" id=\"do_objednavka_poznamka\" action=\"?vyber=objednavky&order={$order}&action=komentar_private\">"; echo textarea("komentar_private", $objednavka["komentar_private"], "Súkromný komentár k objednávke (nezveréjnene zákazníkom)", 50, 3, "komentar_private"); echo submit("submit_poznamka", "Odoslať"); echo "</form>"; echo "</div>"; echo "<div class=\"order_details\">\r\n <div>Objednávka prijatá: {$objednavka['datum']}</div>"; if ($access == TRUE) { echo "<div>" . ($objednavka[komplet] == 0 ? "Objednávka neuzavretá - <a href=\"?vyber=objednavky&order={$order}&action=close\">Uzavrieť</a>" : "Objednávka je kompletná - <a href=\"?vyber=objednavky&order={$order}&action=open\">Otvoriť</a>") . " </div>"; echo "<div class=\"main_box_33\">"; echo "<form method=\"POST\">"; echo select("status", "Stav objednávky:", "SELECT id, meno FROM objednavka_status ORDER BY id", $objednavka[status], "", "", "", "NO"); echo submit("save_status", "Uložiť stav objednávky"); echo "</form>"; echo "</div>"; echo "<div>" . ($objednavka[vymaz] == 0 ? "<a href=\"?vyber=objednavky&order={$order}&action=delete\">Úplne vymazať objednávku</a>" : "<a href=\"?vyber=objednavky&order={$order}&action=delete\">Zrušiť vymazanie objednávky</a>") . "</div> \r\n"; } // zobrazenie pridaných súborov $files = sql_query("SELECT id_revizia, meno, meno_old, pripona, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum \r\n FROM subor\r\n WHERE id_obj=\"{$order}\""); echo "<div id=\"added_files\"" . (count($files) > 0 ? " class=\"attatch_exists\"" : "") . ">\r\n <h2>Všetky nahraté súbory</h2>"; //var_dump($files); for ($i = 0; $i < count($files); $i++) { $directory = "files/obj-{$order}/rev-{$files[$i][id_revizia]}"; echo "revízia č. {$files[$i][id_revizia]} <a href=\"{$directory}/" . $files[$i]["meno"] . "." . $files[$i]["pripona"] . "\" target=\"_blank\">" . $files[$i]["meno_old"] . "</a><br>"; } echo "</div>\r\n \r\n "; echo "</div>"; }
function display_all_revisions($order) { $objednavka = sql_query("SELECT id, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum, c_obj, id_zakaznik, komplet, vymaz, status \r\n FROM objednavka_skrine \r\n WHERE id=\"{$order}\" LIMIT 1"); $objednavka = $objednavka[0]; //var_dump($objednavka); echo "<h1>Objednávka skrine č. {$objednavka['c_obj']} (zobrazené sú všetky zmeny v objednávke)</h1>"; echo "<div class=\"main_box_33\">"; $access = check_access_true("objednavka_edit"); if ($access == TRUE) { echo "<form method=\"POST\">"; echo select("zakaznik", "Priradená zákazníkovi", "SELECT id, meno FROM uzivatel WHERE vymaz=0 AND skupina=2 ORDER BY meno", $objednavka[id_zakaznik], "---", "", ""); echo submit("save_zakaznik", "Priradiť"); echo "</form>"; } echo "</div>"; echo "<table id=\"all_revisions\">"; $revizia = sql_query("\r\n SELECT revizia.id, revizia.meno, revizia.adresa, \r\n DATE_FORMAT(revizia.datum, '%d. %m. %Y, %H:%i') AS dat_upr, \r\n uzivatel.meno as uziv_meno\r\n FROM revizia_skrine revizia \r\n LEFT JOIN uzivatel\r\n ON revizia.upravil=uzivatel.id\r\n WHERE revizia.id_obj = \"" . $order . "\"\r\n ORDER BY revizia.datum DESC\r\n "); //var_dump($revizia); foreach ($revizia as $rev) { /* $is_cp = sql_query("SELECT count(id) as count FROM cp_skrine WHERE id_revizia = \"".$rev[id]."\""); $is_cp = $is_cp[0][count]; $email_cp = sql_query("SELECT DATE_FORMAT(datum_email, '%d. %m. %Y, %H:%i') AS datum_email_upr FROM cp_skrine WHERE id_revizia = \"".$rev[id]."\" AND datum_email <>0 LIMIT 1"); //$email_cp = count($email_cp); //var_dump($email_cp); * */ $display_rev = 1; if ($access == TRUE) { $adressto = "objednavky_skrine"; } else { $adressto = "vyroba_skrine"; $filename = "files/csv/obj-{$order}/rev-{$rev[id]}/*.csv"; //var_dump(glob($filename)); if (glob($filename) != false) { $display_rev = 1; } else { $display_rev = 0; } } //echo $display_rev; if ($display_rev > 0) { echo "\r\n <tr>\r\n <td class=\"obj_cislo\">" . $rev[id] . "</td>\r\n <td class=\"obj_datum\">\r\n " . $rev["dat_upr"] . "</td>\r\n <td class=\"obj_meno\">\r\n <a href=\"?vyber={$adressto}&order=" . $order . "&revision=" . $rev[id] . "\">\r\n " . $rev[meno] . "" . (!empty($rev[adresa]) ? ", " . $rev[adresa] : "") . "</a>\r\n </td>\r\n <td class=\"obj_material\">\r\n " . $rev[mat_meno] . "" . (!empty($rev[vyr_meno]) ? ", " . $rev[vyr_meno] : "") . "" . (!empty($rev[dek_meno]) ? ", " . $rev[dek_meno] : "") . "" . (!empty($rev[dekor_vlastny]) ? ", " . $rev[dekor_vlastny] : "") . "</td>\r\n <td class=\"obj_icons\">" . ($is_cp > 0 ? "<a href=\"?vyber=cp&order={$order}&revision=" . $rev[id] . "&action=display_all\"><img src=\"assets/images/euro.png\" title=\"Objednávka má vypracované Cenové Ponuky: {$is_cp}\"></a>" : "<img src=\"assets/images/euro_no.png\" title=\"Objednávka bez Cenových ponúk\">") . "\r\n " . (count($email_cp) > 0 ? "<img src=\"assets/images/checked.png\" title=\"CP odoslaná: " . $email_cp[0]["datum_email_upr"] . "\">" : "") . " \r\n <a href=\"?vyber=vyroba_skrine&order={$order}&revision=" . $rev[id] . "\">" . ($query_vyroba[0]["status"] > 0 ? "<img src=\"assets/images/vyroba.png\" title=\"Objednávka vo výrobe\">" : "<img src=\"assets/images/vyroba_no.png\" title=\"Bez výroby\">") . "</a>\r\n " . (!empty($rev["uziv_meno"]) ? "<span class=\"upravil\">" . $rev["uziv_meno"] . "</span>" : "") . " \r\n </td> \r\n \r\n </tr>\r\n "; } } echo "</table>"; // zobrazenie detailov objednávky echo "<div class=\"order_details\">\r\n <div>Objednávka prijatá: {$objednavka['datum']}</div>"; if ($access == TRUE) { echo "<div>" . ($objednavka[komplet] == 0 ? "Objednávka neuzavretá - <a href=\"?vyber=objednavky_skrine&order={$order}&action=close\">Uzavrieť</a>" : "Objednávka je kompletná - <a href=\"?vyber=objednavky_skrine&order={$order}&action=open\">Otvoriť</a>") . " </div>"; echo "<div class=\"main_box_33\">"; echo "<form method=\"POST\">"; echo select("status", "Stav objednávky:", "SELECT id, meno FROM objednavka_status ORDER BY id", $objednavka[status], "", "", "", "NO"); echo submit("save_status", "Uložiť stav objednávky"); echo "</form>"; echo "</div>"; echo "<div>" . ($objednavka[vymaz] == 0 ? "<a href=\"?vyber=objednavky_skrine&order={$order}&action=delete\">Úplne vymazať objednávku</a>" : "<a href=\"?vyber=objednavky_skrine&order={$order}&action=delete\">Zrušiť vymazanie objednávky</a>") . "</div> \r\n"; } // zobrazenie pridaných súborov echo "</div>"; }
if ($safe != "U,,5Enc!") { die("nepovoleny prístup k súboru!!"); } if (!empty($sub)) { $query_vyroba = "SELECT status, tabula, stvorak, abs_vyrobca, porez, status, upravil \r\n FROM revizia_vyroba WHERE id={$sub} LIMIT 1"; $query_vyroba = sql_query($query_vyroba); $query_vyroba = $query_vyroba[0]; $vyr_tabula = $query_vyroba[tabula]; $vyr_stvorak = $query_vyroba[stvorak]; $vyr_status = $query_vyroba[status]; $vyr_abs = $query_vyroba[abs_vyrobca]; $vyr_porez = $query_vyroba[porez]; $vyr_upravil = $query_vyroba[upravil]; } $access = check_access_true("objednavka_edit"); $query_vyroba_stat = "SELECT status from revizia_vyroba \r\n WHERE id_revizia={$revision} AND vymaz=0"; $vyroba_stat = sql_query($query_vyroba_stat); if (count($vyroba_stat) > 0) { foreach ($vyroba_stat as $value) { $vyroba_status[] = $value[status]; } } else { $vyroba_status[] = 0; } if ($action == "close" and $access == TRUE) { mysql_query("BEGIN"); $query = "SELECT upravil, tabula, stvorak, abs_vyrobca, porez\r\n FROM revizia_vyroba WHERE id={$sub} LIMIT 1"; //echo $query; $original = sql_query($query); $original = $original[0];
function display_all_revisions($order) { $objednavka = sql_query("SELECT id, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum, c_obj, id_zakaznik, komplet, vymaz, status, delivery \n FROM objednavka \n WHERE id=\"{$order}\" LIMIT 1"); $objednavka = $objednavka[0]; echo "<h1>Objednávka č. {$objednavka['c_obj']} (zobrazené sú všetky zmeny v objednávke)</h1>"; echo "<div class=\"main_box_33\">"; $access = check_access_true("objednavka_edit"); if ($access == TRUE) { echo "<form method=\"POST\">"; echo select("zakaznik", "Priradená zákazníkovi", "SELECT id, CONCAT(meno, ', ', doruc_mesto) meno FROM uzivatel WHERE vymaz=0 AND skupina=2 ORDER BY meno", $objednavka[id_zakaznik], "---", "", ""); echo submit("save_zakaznik", "Priradiť"); echo "</form>"; } echo "</div>"; echo "<table id=\"all_revisions\">"; $revizia = sql_query("\n SELECT r.id, r.meno, r.adresa, \n DATE_FORMAT(r.datum, '%d. %m. %Y, %H:%i') AS dat_upr, \n uzivatel.meno as uziv_meno\n FROM revizia as r \n LEFT JOIN uzivatel\n ON r.upravil=uzivatel.id\n WHERE r.id_obj = \"" . $order . "\"\n ORDER BY r.datum DESC\n "); //var_dump($revizia); $counter = 1; foreach ($revizia as $rev) { $is_cp = sql_query("SELECT count(id) as count FROM cp \n WHERE id_revizia = \"" . $rev[id] . "\""); $is_cp = $is_cp[0][count]; /* $email_cp = sql_query("SELECT DATE_FORMAT(datum_email, '%d. %m. %Y, %H:%i') AS datum_email_upr FROM cp WHERE id_revizia = \"".$rev[id]."\" AND datum_email <>0 LIMIT 1"); * */ //$email_cp = count($email_cp); //var_dump($email_cp); $query_vyroba = "SELECT count(status) status FROM revizia_vyroba WHERE id_obj=" . $order . " AND id_revizia=\"" . $rev[id] . "\" AND status>0"; $query_vyroba = sql_query($query_vyroba); $display_rev = 1; if ($access == TRUE) { $adressto = "objednavky"; } else { $adressto = "vyroba"; $filename = "files/csv/obj-{$order}/rev-{$rev[id]}/*.csv"; //var_dump(glob($filename)); if (glob($filename) != false) { $display_rev = 1; } else { $display_rev = 0; } } //echo $display_rev; if ($display_rev > 0) { echo "\n <tr class=\"" . ($counter == 1 ? "last_rev" : "another_rev") . "\">\n <td class=\"obj_cislo\">" . $rev[id] . "</td>\n <td class=\"obj_datum\">\n " . $rev["dat_upr"] . "</td>\n <td class=\"obj_meno\">\n <a href=\"?vyber={$adressto}&order=" . $order . "&revision=" . $rev[id] . "\">\n " . $rev[meno] . "" . (!empty($rev[adresa]) ? ", " . $rev[adresa] : "") . "</a>\n </td>"; echo "<td class=\"obj_icons\">"; echo "" . ($is_cp > 0 ? "<a href=\"?vyber=cp&order={$order}&revision=" . $rev[id] . "&action=display_all\"><img src=\"assets/images/euro.png\" title=\"Objednávka má vypracované Cenové Ponuky: {$is_cp}\"></a>" : "<img src=\"assets/images/euro_no.png\" title=\"Objednávka bez Cenových ponúk\">") . "\n " . (!empty($rev["uziv_meno"]) ? "<span class=\"upravil\">" . $rev["uziv_meno"] . "</span>" : "") . ""; echo "</td> \n \n </tr>\n "; } $counter = $counter + 1; } echo "</table>"; // zobrazenie detailov objednávky echo "<div class=\"order_details\">\n <div>Objednávka prijatá: {$objednavka['datum']}</div>"; if ($access == TRUE) { echo "<div>" . ($objednavka[komplet] == 0 ? "Objednávka neuzavretá - <a href=\"?vyber=objednavky&order={$order}&action=close\">Uzavrieť</a>" : "Objednávka je kompletná - <a href=\"?vyber=objednavky&order={$order}&action=open\">Otvoriť</a>") . " </div>"; echo "<div class=\"main_box_33\">"; echo "<form method=\"POST\">"; $zobraz_vo = array(4 => "štandard", 1 => "48 hodín"); echo select("status_delivery", "Typ dopravy", "", $objednavka[delivery], "", "", "", "NO", $zobraz_vo); echo submit("save_delivery", "Uložiť"); echo "</form>"; echo "</div>"; echo "<div class=\"main_box_33\">"; echo "<form method=\"POST\">"; echo select("status", "Stav objednávky:", "SELECT id, meno FROM objednavka_status ORDER BY id", $objednavka[status], "", "", "", "NO"); echo submit("save_status", "Uložiť stav objednávky"); echo "</form>"; echo "</div>"; echo "<div>" . ($objednavka[vymaz] == 0 ? "<a href=\"?vyber=objednavky&order={$order}&action=delete\">Úplne vymazať objednávku</a>" : "<a href=\"?vyber=objednavky&order={$order}&action=delete\">Zrušiť vymazanie objednávky</a>") . "</div> \n"; } // zobrazenie pridaných súborov echo "</div>"; }
function display_all_revisions($order) { $objednavka = sql_query("SELECT id, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum, komplet, vymaz, status \r\n FROM velkoobchod \r\n WHERE id=\"{$order}\" LIMIT 1"); $objednavka = $objednavka[0]; echo "<h1>Veľkoobchodná Objednávka č. {$objednavka['id']} (zobrazené sú všetky zmeny v objednávke)</h1>"; $access = check_access_true("velkoobchod_edit"); echo "<table id=\"all_revisions\">"; $revizia = sql_query("\r\n SELECT r.id, DATE_FORMAT(r.datum, '%d. %m. %Y, %H:%i') AS dat_upr,\r\n DATE_FORMAT(r.datum_vlastny, '%d. %m. %Y') AS dat_vlastny, sum,\r\n uzivatel.meno as uziv_meno, datum_email, DATE_FORMAT(r.datum_email, '%d. %m. %Y, %H:%i') AS dat_upr_email \r\n FROM revizia_velkoobchod r\r\n LEFT JOIN uzivatel\r\n ON r.upravil=uzivatel.id\r\n WHERE r.id_velkoobchod = \"" . $order . "\"\r\n ORDER BY r.datum DESC\r\n "); //var_dump($revizia); foreach ($revizia as $rev) { $display_rev = 1; if ($access == TRUE) { $adressto = "velkoobchod"; } else { $adressto = ""; } //echo $display_rev; if ($display_rev > 0) { echo "\r\n <tr>\r\n <td class=\"obj_cislo\">" . $rev[id] . "</td>\r\n <td class=\"obj_datum\">\r\n " . $rev["dat_vlastny"] . "\r\n </td>\r\n <td class=\"obj_meno\" > \r\n <a href=\"?vyber={$adressto}&order=" . $order . "&revision=" . $rev[id] . "\">s celkovou cenou <strong>" . $rev["sum"] . "€</strong></a>\r\n </td>\r\n <td class=\"obj_datum\">\r\n " . $rev["dat_upr"] . "</td>\r\n \r\n <td class=\"\">\r\n <a href=\"?vyber=print_velkoobchod&order={$order}&revision={$rev[id]}\" target=\"_blank\">Vytlačiť</a> | \r\n <a href=\"?vyber=velkoobchod&order={$order}&revision={$rev[id]}&action=email\">email</a>\r\n " . ($rev[datum_email] != "0000-00-00 00:00:00" ? "<img src=\"assets/images/checked.png\" title=\"{$rev['dat_upr_email']}\">" : "") . "\r\n </td>\r\n </tr>\r\n "; } } echo "</table>"; // zobrazenie detailov objednávky echo "<div class=\"order_details\">\r\n "; if ($access == TRUE) { echo "<div>" . ($objednavka[komplet] == 0 ? "Objednávka neuzavretá - <a href=\"?vyber=velkoobchod&order={$order}&action=close\">Uzavrieť</a>" : "Objednávka je kompletná - <a href=\"?vyber=velkoobchod&order={$order}&action=open\">Otvoriť</a>") . " </div>"; echo "<div class=\"main_box_33\">"; echo "<form method=\"POST\">"; echo select("status", "Stav objednávky:", "SELECT id, meno FROM objednavka_status ORDER BY id", $objednavka[status], "", "", "", "NO"); echo submit("save_status", "Uložiť stav objednávky"); echo "</form>"; echo "</div>"; echo "<div>" . ($objednavka[vymaz] == 0 ? "<a href=\"?vyber=velkoobchod&order={$order}&action=delete\">Úplne vymazať objednávku</a>" : "<a href=\"?vyber=velkoobchod&order={$order}&action=delete\">Zrušiť vymazanie objednávky</a>") . "</div> \r\n"; } // zobrazenie pridaných súborov echo "</div>"; }
function display_all_revisions($order) { $objednavka = sql_query("SELECT o.id, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i:%s') AS dat_upr, komplet, \r\n o.id_dodavatel, dod.meno as dodavatel , o.poznamka, o.vymaz\r\n FROM do_objednavka o\r\n INNER JOIN dodavatel dod\r\n ON o.id_dodavatel = dod.id\r\n WHERE o.id=\"{$order}\" LIMIT 1"); $objednavka = $objednavka[0]; echo "<h1>Dodávateľská Objednávka č. {$objednavka['id']}</h1>"; $access = check_access_true("do_objednavka_edit"); echo "<table id=\"all_revisions\">"; $revizia = sql_query("\r\n SELECT objr.*, u.meno as uz_vytvoril, p.meno\r\n FROM do_objednavka_row objr \r\n INNER JOIN uzivatel u\r\n ON objr.vytvoril = u.id\r\n INNER JOIN do_produkt p\r\n ON objr.id_do_produkt = p.id\r\n WHERE objr.id_do_objednavka = " . $order . "\r\n ORDER BY objr.datum DESC\r\n "); //var_dump($revizia); $count = 0; foreach ($revizia as $rev) { $count += 1; $zadal = ""; //echo $display_rev; if ($rev["vytvoril"] != $rev["zadal"]) { $zadal = sql_query("\r\n SELECT meno\r\n FROM uzivatel \r\n WHERE id={$rev["zadal"]}\r\n LIMIT 1\r\n ")[0]["meno"]; } if ($count == 1) { echo "<div class=\"tasker_form\">"; echo "<div class=\"new_task_form\">"; echo "<form method=\"POST\" id=\"do_objednavka\">"; hidden("task_revision", $rev[id]); echo select("task_dodavatel", "Dodávateľ", "SELECT id, meno from dodavatel \r\n WHERE vymaz=0 \r\n ORDER BY meno", $objednavka[id_dodavatel], "", "", "", "NO"); echo textfield("task_ks", !empty($rev[ks]) ? $rev[ks] : "", "ks", 10, 2); $jednotky = array("ks" => "ks", "m" => "m"); echo select("jednotky", "", "", $rev["jednotka"], "", "", "", "NO", $jednotky); echo "<div class=\"task_produkt bold\"><label> </label>{$rev['meno']}</div>"; echo hidden("task_produkt", $rev[id_do_produkt]); echo textfield("task_zakaznik", $rev["zakaznik"], "Zákazník", 100, 20); $ord = ""; if ($vyber == "objednavky" && $order > 0) { $ord = $order; } echo textfield("task_order", !empty($rev[objednavka]) ? $rev[objednavka] : "", "č. obj.", 15, 5); echo select("task_from", "Zadal", "SELECT id, meno from uzivatel \r\n WHERE skupina=1 AND perm_uroven_id<=2 AND vymaz=0 \r\n ORDER BY meno", $rev["zadal"], "", "", "", "NO"); echo submit("submit", "Odoslať"); echo "</form>"; echo "</div>"; if ($access == TRUE) { echo "<div class=\"new_task_form_poznamka\">"; echo "<form method=\"POST\" id=\"do_objednavka_poznamka\">"; echo textfield("task_poznamka", $objednavka["poznamka"], "Poznámka", 100, 20); echo submit("submit_poznamka", "Odoslať"); echo "</form>"; echo "</div>"; } echo "</div>"; } echo "\r\n <tr>\r\n <td class=\"obj_cislo\">" . $rev[id] . "</td>\r\n <td class=\"obj_datum do_obj_datum\">\r\n " . $rev["datum"] . "\r\n </td>\r\n <td class=\"obj_meno\" > \r\n <strong>\r\n " . (!empty($rev[ks]) ? $rev["ks"] . $rev["jednotka"] . "" : "") . "\r\n " . $rev["meno"] . "\r\n </strong>\r\n - " . $rev["zakaznik"] . "\r\n </a>\r\n </td> \r\n <td class=\"obj_datum do_obj_datum\">\r\n " . (empty($zadal) ? "" : " zadal " . $zadal . " cez účet ") . "\r\n " . $rev["uz_vytvoril"] . "\r\n \r\n </td>\r\n \r\n \r\n </tr>\r\n "; } echo "</table>"; // zobrazenie detailov objednávky //dd($objednavka); echo "<div class=\"order_details\">\r\n "; if ($access == TRUE) { echo "<div>" . ($objednavka[komplet] == 0 ? "Objednávka neuzavretá - <a href=\"?vyber=do_objednavka&order={$order}&action=close\">Uzavrieť</a>" : "Objednávka je kompletná - <a href=\"?vyber=do_objednavka&order={$order}&action=open\">Otvoriť</a>") . " </div>"; echo "<div>" . ($objednavka[vymaz] == 0 ? "<a href=\"?vyber=do_objednavka&order={$order}&action=delete\">Úplne vymazať objednávku</a>" : "<a href=\"?vyber=do_objednavka&order={$order}&action=delete\">Zrušiť vymazanie objednávky</a>") . "</div> \r\n"; } // zobrazenie pridaných súborov echo "</div>"; }