Пример #1
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, 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>";
}
Пример #2
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 \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>";
}
Пример #3
0
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];
Пример #4
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>";
}
Пример #5
0
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>";
}
Пример #6
0
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>&nbsp;</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>";
}