if ($action == "display_all") { if ($message == "ok") { echo "<div id=\"ok_message\">Email s Cenovou ponukou bol úspešne odoslaný</div>"; } display_all_revisions_cp($order, $revision); } if ($action == "email_send") { sql_update("UPDATE cp SET datum_email=now() WHERE id=\"{$cp}\""); send_email_revision_cp($revision, $cp); //die(); header("location: ?vyber=cp&order={$order}&revision={$revision}&action=display_all&message=ok"); } if ($action == "email") { echo "<div class=\"confirm_order_another\"><a href=\"?vyber={$vyber}&order={$order}&revision={$revision}&action=email_send&cp={$cp}\"><strong>Odošli email s cenovou ponukou zákazníkovi</strong></a></div>"; echo "<div class=\"print\">"; echo print_revision_cp($cp, $revision); echo "</div>"; } } function riadok_cp_simple($table, $cenova_hladina, $field_name, $field_title, $where = "", $field_value = "", $field_price = "", $hidden_id = "") { echo "<tr><td class=\"cp_value\">"; //var_dump($field_price); if ($field_price == "") { $query = "SELECT id, cena, id_c_hladina_typ FROM {$table} WHERE id_c_hladina=" . $cenova_hladina . " {$where} AND vymaz=0 ORDER BY id DESC LIMIT 1"; //var_dump($query); $item = sql_query($query); $item = $item[0]; $typ_ch = $item[id_c_hladina_typ]; if (count($item) < 1) { $item = sql_query("SELECT id, cena FROM {$table} WHERE id_c_hladina=1 {$where} ORDER BY id DESC LIMIT 1");
<?php if ($safe != "U,,5Enc!") { die("nepovoleny prístup k súboru!!"); } if (empty($action)) { $print_revision = print_revision($revision); } if ($action == "cp") { $print_revision = print_revision_cp($cp, $revision); } if ($action == "skrine") { $print_revision = print_revision_skrine($order, $revision); } if ($action == "do_objednavka") { $print_revision = print_do_objednavka(); } if ($action == "cennik") { //var_dump($_POST); $table = $sub; //var_dump($_POST); if ($_POST["id_vyrobca"]) { $where[id_vyrobca] = sec_input(sec_sql($_POST["id_vyrobca"])); //$_SESSION["filter_dekor_id_vyrobca"] = $where[id_vyrobca]; $id_vyrobca = $where[id_vyrobca]; } if ($_POST["id_material"]) { $where["dekor.id_material"] = sec_input(sec_sql($_POST["id_material"])); //$_SESSION["filter_dekor_dekor.id_material"] = $where["dekor.id_material"]; $id_material = $where["dekor.id_material"]; }