示例#1
0
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;
}
示例#2
0
function send_email_revision_($revision, $only_kraf = "", $status = "")
{
    //var_dump($revision);
    // die();
    require_once 'include/PHPMailer/PHPMailerAutoload.php';
    $email_to_kraf = def_value("default_email", "hodnota");
    mysql_query("BEGIN");
    $data = sql_query("SELECT id_obj, meno, adresa, ico_icdph, telefon, email, id_material as material,\r\n                                    id_vyrobca as vyrobca, id_dekor as dekor, dekor_vlastny, komentar,\r\n                                    DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum\r\n                                    FROM revizia \r\n                                    WHERE id={$revision} \r\n                                    LIMIT 1");
    $data_narez = sql_query("SELECT ks, dlzka, sirka, nazov, poznamka, hrubka, orientacia,\r\n                                    hrana1, hrana2, hrana3, hrana4\r\n                                    FROM porez \r\n                                    WHERE id_revizia={$revision}");
    $data = $data[0];
    $fieldsets_c = count($data_narez);
    for ($i = 0; $i < $fieldsets_c; $i++) {
        $ks[$i] = $data_narez[$i][ks];
        $dlzka[$i] = $data_narez[$i][dlzka];
        $sirka[$i] = $data_narez[$i][sirka];
        $nazov[$i] = $data_narez[$i][nazov];
        $poznamka[$i] = $data_narez[$i][poznamka];
        $hrubka[$i] = $data_narez[$i][hrubka];
        $orientacia[$i] = $data_narez[$i][orientacia];
        $hrana1[$i] = $data_narez[$i][hrana1];
        $hrana2[$i] = $data_narez[$i][hrana2];
        $hrana3[$i] = $data_narez[$i][hrana3];
        $hrana4[$i] = $data_narez[$i][hrana4];
    }
    $data[ks_all] = $ks;
    $data[dlzka_all] = $dlzka;
    $data[sirka_all] = $sirka;
    $data[nazov_all] = $nazov;
    $data[poznamka_all] = $poznamka;
    $data[hrubka_all] = $hrubka;
    $data[orientacia_all] = $orientacia;
    $data[hrana1_all] = $hrana1;
    $data[hrana2_all] = $hrana2;
    $data[hrana3_all] = $hrana3;
    $data[hrana4_all] = $hrana4;
    //var_dump($data);
    $files = sql_query("SELECT meno, meno_old, pripona \r\n                                FROM subor\r\n                                WHERE id_obj=" . $data["id_obj"] . "");
    //var_dump($data);
    $data_obj = sql_query("SELECT DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum, c_obj, status,\r\n                                    DATE_FORMAT(datum, '%Y') AS rok\r\n                                    FROM objednavka \r\n                                    WHERE id=" . $data["id_obj"] . " LIMIT 1");
    $data_obj = $data_obj[0];
    $secure_key = sql_query("SELECT secure_key\r\n                                    FROM objednavka_secure\r\n                                    WHERE id_obj=" . $data["id_obj"] . " AND \r\n                                          id_revizia={$revision} LIMIT 1");
    $secure_key = $secure_key[0][secure_key];
    $message = "<html><body>";
    $message .= "<img src=\"http://" . def_value("default_url", "hodnota") . "/assets/images/logo.jpg\">";
    $message .= "<h1>Objednávka č. " . $data_obj["c_obj"] . "/" . $data_obj["rok"] . "</h1>";
    $message .= "zo dňa: " . $data_obj["datum"] . "<br><br>";
    $message .= "<table><tr>";
    $message .= "<td style=\"width: 400px;\"><strong>Dodávateľ</strong><br>";
    $message .= "<table><tr><td>" . def_value("default_firma", "hodnota") . "</td></tr>";
    $message .= "<tr><td>" . def_value("default_adresa", "hodnota") . "<br>" . def_value("default_mesto", "hodnota") . "</td></tr>";
    $message .= "<tr><td>IČO: " . def_value("default_ico", "hodnota") . "<br> DIČ: " . def_value("default_dic", "hodnota") . "</td></tr>";
    $message .= "<tr><td>" . def_value("default_telefon", "hodnota") . "<br> " . def_value("default_mobil", "hodnota") . "</td></tr>";
    $message .= "<tr><td>" . def_value("default_email", "hodnota") . "<br> " . def_value("default_email_2", "hodnota") . "</td></tr>";
    $message .= "</table><br><br></td>";
    $message .= "<td style=\"width: 50%;\"><strong>Objednávateľ:</strong>";
    $message .= "<table><tr><td>" . $data["meno"] . "</td></tr>";
    $message .= "<tr><td>" . $data["adresa"] . "</td></tr>";
    $message .= "<tr><td>" . $data["ico_icdph"] . "</td></tr>";
    $message .= "<tr><td>" . $data["telefon"] . "</td></tr>";
    $message .= "<tr><td>" . $data["email"] . "</td></tr>";
    $message .= "</table><br><br></td>";
    $message .= "</tr></table>";
    $message .= "<strong>Materiál:</strong>";
    $material = sql_query("SELECT meno FROM material WHERE id=" . sec_sql(sec_input($data["material"])) . " LIMIT 1");
    $material = $material[0];
    $message .= "<table><tr><td>" . $material["meno"] . "</td></tr>";
    $vyrobca = sql_query("SELECT meno FROM vyrobca WHERE id=\"" . sec_sql(sec_input($data["vyrobca"])) . "\" LIMIT 1");
    $vyrobca = $vyrobca[0];
    $dekor = sql_query("SELECT meno FROM dekor WHERE id=" . sec_sql(sec_input($data["dekor"])) . " LIMIT 1");
    $dekor = $dekor[0];
    $message .= "<tr><td>" . $vyrobca["meno"] . " " . $dekor["meno"] . "</td></tr>";
    $message .= "<tr><td>" . $data["dekor_vlastny"] . "</td></tr>";
    $message .= "</table><br><br>";
    $message .= "<table style=\"font-size: 10pt;\">\r\n               <tr style=\"border-bottom: solid 1px darkslategrey ;\">\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 20px;\"></th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 40px;\">ks</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 180px;\">rozmer</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 150px;\">Názov</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 150px;\">Poznámka</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 50px;\">hrúbka</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 50px;\">orient.</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 20px;\">dolná</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 20px;\">pravá</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 20px;\">horná</th>\r\n               <th style=\"background-color: lightsteelblue; color: white; padding:5px; font-size: 90%; width: 20px;\">ľava</th>\r\n               </tr>";
    for ($i = 0; $i < $fieldsets_c; $i++) {
        $poradie = 0;
        $poradie = $i + 1;
        $message .= "<tr>\r\n                    <td class=\"form_poradie\">{$poradie}. </td>\r\n                    <td class=\"form_ks\">" . sec_input($data["ks_all"][$i]) . "</td>\r\n                    <td class=\"form_rozmer\">" . sec_input($data["dlzka_all"][$i]) . " x " . $data["sirka_all"][$i] . " mm</td>\r\n                    <td class=\"form_nazov\">" . sec_input($data["nazov_all"][$i]) . "</td>\r\n                    <td class=\"form_nazov\">" . sec_input($data["poznamka_all"][$i]) . "</td>";
        $hrubka = sql_query("SELECT meno FROM hrubka WHERE id=" . sec_sql(sec_input($data["hrubka_all"][$i])) . " LIMIT 1");
        $hrubka = $hrubka[0];
        $message .= "\r\n                    <td class=\"form_hrana\">" . $hrubka["meno"] . "</td>";
        $orientacia = sql_query("SELECT meno FROM orientacia WHERE id=" . sec_sql(sec_input($data["orientacia_all"][$i])) . " LIMIT 1");
        $orientacia = $orientacia[0];
        $message .= "\r\n                    <td class=\"form_hrana\">" . $orientacia["meno"] . "</td>";
        $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana1_all"][$i])) . " LIMIT 1");
        $hrana = $hrana[0];
        $message .= "<td class=\"form_hrana\">" . $hrana[meno] . "</td>";
        $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana2_all"][$i])) . " LIMIT 1");
        $hrana = $hrana[0];
        $message .= "<td class=\"form_hrana\">" . $hrana[meno] . "</td>";
        $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana3_all"][$i])) . " LIMIT 1");
        $hrana = $hrana[0];
        $message .= "\r\n                    <td class=\"form_hrana\">" . $hrana[meno] . "</td>";
        $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana4_all"][$i])) . " LIMIT 1");
        $hrana = $hrana[0];
        $message .= "<td class=\"form_hrana\">" . $hrana[meno] . "</td>";
        $vypocet = $data["dlzka_all"][$i] * $data["sirka_all"][$i] / 1000000;
        $vypocet = $vypocet * $data["ks_all"][$i];
        if (is_duplak($data["hrubka_all"][$i])) {
            $paska = 0;
            if ($data[hrana1_all][$i] > 0) {
                $paska = $paska + $data[dlzka_all][$i];
            }
            if ($data[hrana3_all][$i] > 0) {
                $paska = $paska + $data[dlzka_all][$i];
            }
            if ($data[hrana2_all][$i] > 0) {
                $paska = $paska + $data[sirka_all][$i];
            }
            if ($data[hrana4_all][$i] > 0) {
                $paska = $paska + $data[sirka_all][$i];
            }
            $vypocet_duplak = $data["dlzka_all"][$i] * $data["sirka_all"][$i] / 1000000;
            $vypocet_duplak = $vypocet_duplak * $data["ks_all"][$i];
            $vypocet = ($data["dlzka_all"][$i] + 30) * ($data["sirka_all"][$i] + 30) / 1000000;
            $vypocet = $vypocet * ($data["ks_all"][$i] * 2);
            $vypocet_duplak_sum = $vypocet_duplak_sum + $vypocet_duplak;
            $vypocet_paska_sum = $vypocet_paska_sum + $paska * $data["ks_all"][$i] / 1000;
        } else {
            $hrany = sql_query("SELECT id, meno FROM hrana where vymaz=0 and zobraz_vo_formulari=1");
            //var_dump($hrany);
            foreach ($hrany as $hrana) {
                $paska_normal[$hrana["meno"]] = 0;
                if ($data[hrana1_all][$i] > 0 and $data[hrana1_all][$i] == $hrana["id"]) {
                    $paska_normal[$hrana["meno"]] = $paska_normal[$hrana["meno"]] + $data[dlzka_all][$i];
                }
                if ($data[hrana3_all][$i] > 0 and $data[hrana3_all][$i] == $hrana["id"]) {
                    $paska_normal[$hrana["meno"]] = $paska_normal[$hrana["meno"]] + $data[dlzka_all][$i];
                }
                if ($data[hrana2_all][$i] > 0 and $data[hrana2_all][$i] == $hrana["id"]) {
                    $paska_normal[$hrana["meno"]] = $paska_normal[$hrana["meno"]] + $data[sirka_all][$i];
                }
                if ($data[hrana4_all][$i] > 0 and $data[hrana4_all][$i] == $hrana["id"]) {
                    $paska_normal[$hrana["meno"]] = $paska_normal[$hrana["meno"]] + $data[sirka_all][$i];
                }
                $vypocet_paska_normal_sum[$hrana["meno"]] = $vypocet_paska_normal_sum[$hrana["meno"]] + $paska_normal[$hrana["meno"]] * $data["ks_all"][$i] / 1000;
                //var_dump($paska_normal);
                //var_dump($vypocet_paska_normal_sum);
            }
        }
        $vypocet_sum = $vypocet_sum + $vypocet;
        $vypocet_final = round($vypocet, 2) . " m2";
        //var_dump($vypocet_paska_sum);
        //$message .= "<td class=\"td_vypocet\">".($vypocet>0 ? $vypocet_final : "" )."</td>";
        $message .= "</tr>";
    }
    $message .= "</table><br>";
    $message .= "<div class=\"form_vypocet_sum\">" . ($vypocet_sum > 0 ? "Spolu: " . round($vypocet_sum, 2) . " m2" : "") . "</div>";
    $message .= "<div class=\"form_vypocet_sum\">";
    if (!empty($vypocet_paska_normal_sum)) {
        foreach ($vypocet_paska_normal_sum as $key => $paska_view) {
            $message .= "{$key} opáskovanie: " . round($paska_view, 2) . " m<br>";
        }
    }
    $message .= "</div>";
    $message .= "<div class=\"form_vypocet_sum_duplak\">" . ($vypocet_duplak_sum > 0 ? "Duplák spracovanie: " . round($vypocet_duplak_sum, 2) . " m2" : "") . "<br>\r\n                                                                " . ($vypocet_paska_sum > 0 ? "Duplák opaskovanie: " . round($vypocet_paska_sum, 2) . " m" : "") . "</div>";
    $message .= "<br>" . $data["komentar"] . "<br><br>";
    if (count($files) > 0) {
        $message .= "<div class=\"print_subory\">\r\n               Počet príloh objednávky: " . count($files) . "<br>";
        for ($i = 0; $i < count($files); $i++) {
            $message .= " - " . $files[$i]["meno_old"] . "<br>";
        }
        $message .= "</div><br><br>";
    }
    if ($data_obj["status"] == def_value("default_obj_status_rozpracovana", "hodnota")) {
        $message .= "<h2>Objednávka je uložená a ešte nebola Vami potvrdená.</h2>\r\n                                Pre potvrdenie objednávky, alebo jej ďalšie úpravy kliknite na túto adresu:\r\n                                ";
    } else {
        $message .= "Pre dodatočnú úpravu objednávky použite prosím túto adresu:";
    }
    $message .= "<br><a href=\"http://" . def_value("default_url", "hodnota") . "/?vyber=formular&secure_key={$secure_key}\">\r\n                                    http://" . def_value("default_url", "hodnota") . "/?vyber=formular&secure_key={$secure_key}\r\n                                </a>";
    $message .= "<br>Ak sme už Vašu objednávku spracovali a je v procese výroby, jej úpravy už nie su možné.<br>\r\n                         <br><br>";
    $message .= "email vytvorený: " . date("j. n. Y - H:i") . "<br>";
    $message .= "</body></html>";
    mysql_query("COMMIT");
    $headers = "From: \"" . $data["meno"] . "\" <" . $data["email"] . ">\r\n";
    $headers .= "Reply-To: " . $data["email"] . "\r\n";
    //$headers .= "CC: scooti@stonline.sk\r\n";
    $headers .= "MIME-Version: 1.0\r\n";
    $headers .= "Content-Type: text/html; charset=UTF-8\r\n";
    $mail = new PHPMailer();
    //$mail->IsSMTP();
    $mail->CharSet = "UTF-8";
    $mail->SMTPDebug = 0;
    $mail->SMTPAuth = true;
    //$mail->SMTPSecure = 'ssl';
    $mail->Host = def_value("default_email_host", "hodnota");
    $mail->Port = def_value("default_email_port", "hodnota");
    $mail->Username = def_value("default_email_username", "hodnota");
    $mail->Password = def_value("default_email_password", "hodnota");
    $mail->isHTML(true);
    $mail->setLanguage('sk', 'language/');
    $mail->SetFrom(def_value("default_email", "hodnota"), def_value("default_firma", "hodnota"));
    if (!empty($status) and $status == "rozpracovana") {
        $email_to = $data["email"];
        $email_subject = "Rozpracovaná Objednávka č. " . $data_obj["c_obj"] . "/" . $data_obj["rok"] . " - " . def_value("default_firma", "hodnota") . "";
        $headers = "From: \"" . def_value("default_firma", "hodnota") . "\" <" . def_value("default_email", "hodnota") . ">\r\n";
        $headers .= "Reply-To: " . def_value("default_email", "hodnota") . "\r\n";
        //$headers .= "CC: scooti@stonline.sk\r\n";
        $headers .= "MIME-Version: 1.0\r\n";
        $headers .= "Content-Type: text/html; charset=UTF-8\r\n";
        $mail->Subject = $email_subject;
        $mail->Body = $message;
        $mail->AddAddress($email_to);
        $mail->Send();
        //mail($email_to, $email_subject, $message, $headers);
    } else {
        $email_to = $email_to_kraf;
        $email_subject = "Objednávka č. " . $data_obj["c_obj"] . "/" . $data_obj["rok"] . " od " . $data["meno"] . " - " . def_value("default_firma", "hodnota") . "";
        if (!empty($status) and $status == "cp") {
            $email_subject = "Žiadosť o Cenovú ponuku pre objednávku č. " . $data_obj["c_obj"] . " od " . $data["meno"] . " - " . def_value("default_firma", "hodnota") . "";
        }
        $mail->Subject = $email_subject;
        $mail->Body = $message;
        $mail->AddAddress($email_to);
        $mail->Send();
        //mail($email_to, $email_subject, $message, $headers);
        //var_dump($email_to);
        //var_dump($data["email"]);
        if ($only_kraf != 1 and $data["email"] != $email_to) {
            $email_to = $data["email"];
            $email_subject = "Objednávka č. " . $data_obj["c_obj"] . "/" . $data_obj["rok"] . " - " . def_value("default_firma", "hodnota") . "";
            if (!empty($status) and $status == "cp") {
                $email_subject = "Žiadosť o Cenovú ponuku pre objednávku č. " . $data_obj["c_obj"] . "/" . $data_obj["rok"] . " - " . def_value("default_firma", "hodnota") . "";
            }
            $headers = "From: \"" . def_value("default_firma", "hodnota") . "\" <" . def_value("default_email", "hodnota") . ">\r\n";
            $headers .= "Reply-To: " . def_value("default_email", "hodnota") . "\r\n";
            //$headers .= "CC: scooti@stonline.sk\r\n";
            $headers .= "MIME-Version: 1.0\r\n";
            $headers .= "Content-Type: text/html; charset=UTF-8\r\n";
            //mail($email_to, $email_subject, $message, $headers);
            $mail->clearAddresses();
            $mail->Subject = $email_subject;
            $mail->Body = $message;
            $mail->AddAddress($email_to);
            $mail->Send();
            //var_dump($email_to);
            //var_dump($data["email"]);
        }
    }
    echo "Email bol úspešne odoslaný na adresu: {$email_to}";
}
示例#3
0
function porez_vypocty($data)
{
    //var_dump($data);
    $stvorak = $data["dlzka_all"] * $data["sirka_all"] / 1000000;
    $stvorak = $stvorak * $data["ks_all"];
    $nadmiera_pasky = 25;
    $nadmiera_pasky = $nadmiera_pasky * 2;
    if (is_duplak($data["hrubka_all"]) or $data["hrubka_all"] == 9 or $data["duplak_paska_all"] == 1) {
        if (is_duplak($data["hrubka_all"])) {
            $stvorak = ($data["dlzka_all"] + 30) * ($data["sirka_all"] + 30) / 1000000;
            $stvorak = $stvorak * ($data["ks_all"] * 2);
        }
        $paska_duplak[rozmer] = 0;
        $paska_duplak[nadmiera] = 0;
        for ($i = 1; $i <= 4; $i++) {
            if ($data["hrana" . $i . "_all"] > 0) {
                if ($i == 1 or $i == 3) {
                    $paska_duplak[rozmer] = $paska_duplak[rozmer] + $data[dlzka_all] * $data["ks_all"];
                    $paska_duplak[nadmiera] = $paska_duplak[nadmiera] + ($data[dlzka_all] + $nadmiera_pasky) * $data["ks_all"];
                } else {
                    $paska_duplak[rozmer] = $paska_duplak[rozmer] + $data[sirka_all] * $data["ks_all"];
                    $paska_duplak[nadmiera] = $paska_duplak[nadmiera] + ($data[sirka_all] + $nadmiera_pasky) * $data["ks_all"];
                }
                //var_dump($paska_duplak[rozmer]);
            }
        }
        if (is_duplak($data["hrubka_all"])) {
            $vypocet_duplak = $data["dlzka_all"] * $data["sirka_all"] / 1000000;
            $vypocet_duplak = $vypocet_duplak * $data["ks_all"];
        }
    } else {
        $hrany = sql_query("SELECT id, meno FROM hrana where vymaz=0 and zobraz_vo_formulari=1 AND duplak<>1");
        //var_dump($hrany);
        foreach ($hrany as $hrana) {
            $paska_normal[$hrana["id"]][rozmer] = 0;
            $paska_normal[$hrana["id"]][nadmiera] = 0;
            if ($data[hrana1_all] > 0 and $data[hrana1_all] == $hrana["id"]) {
                $paska_normal[$hrana["id"]][rozmer] = $paska_normal[$hrana["id"]][rozmer] + $data[dlzka_all] * $data["ks_all"];
                $paska_normal[$hrana["id"]][nadmiera] = $paska_normal[$hrana["id"]][nadmiera] + ($data[dlzka_all] + $nadmiera_pasky) * $data["ks_all"];
            }
            if ($data[hrana3_all] > 0 and $data[hrana3_all] == $hrana["id"]) {
                $paska_normal[$hrana["id"]][rozmer] = $paska_normal[$hrana["id"]][rozmer] + $data[dlzka_all] * $data["ks_all"];
                $paska_normal[$hrana["id"]][nadmiera] = $paska_normal[$hrana["id"]][nadmiera] + ($data[dlzka_all] + $nadmiera_pasky) * $data["ks_all"];
            }
            if ($data[hrana2_all] > 0 and $data[hrana2_all] == $hrana["id"]) {
                $paska_normal[$hrana["id"]][rozmer] = $paska_normal[$hrana["id"]][rozmer] + $data[sirka_all] * $data["ks_all"];
                $paska_normal[$hrana["id"]][nadmiera] = $paska_normal[$hrana["id"]][nadmiera] + ($data[dlzka_all] + $nadmiera_pasky) * $data["ks_all"];
            }
            if ($data[hrana4_all] > 0 and $data[hrana4_all] == $hrana["id"]) {
                $paska_normal[$hrana["id"]][rozmer] = $paska_normal[$hrana["id"]][rozmer] + $data[sirka_all] * $data["ks_all"];
                $paska_normal[$hrana["id"]][nadmiera] = $paska_normal[$hrana["id"]][nadmiera] + ($data[dlzka_all] + $nadmiera_pasky) * $data["ks_all"];
            }
        }
    }
    $vypocet = array();
    $vypocet[stvorak] = $stvorak;
    $vypocet[paska_duplak] = $paska_duplak;
    $vypocet[paska_normal] = $paska_normal;
    //$vypocet[paska_normal_mat] = $paska_normal_mat;
    $vypocet[lepenie] = $vypocet_duplak;
    if (empty($vypocet[lepenie])) {
        $vypocet[lepenie] = 0;
    }
    //var_dump($vypocet);
    //die();
    return $vypocet;
}
示例#4
0
 $message .= "\r\n                    <td class=\"form_hrana\">" . $orientacia["meno"] . "</td>";
 $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana1_all"][$i])) . " LIMIT 1");
 $hrana = $hrana[0];
 $message .= "<td class=\"form_hrana\">" . $hrana[meno] . "</td>";
 $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana2_all"][$i])) . " LIMIT 1");
 $hrana = $hrana[0];
 $message .= "<td class=\"form_hrana\">" . $hrana[meno] . "</td>";
 $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana3_all"][$i])) . " LIMIT 1");
 $hrana = $hrana[0];
 $message .= "\r\n                    <td class=\"form_hrana\">" . $hrana[meno] . "</td>";
 $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana4_all"][$i])) . " LIMIT 1");
 $hrana = $hrana[0];
 $message .= "\r\n                    <td class=\"form_hrana\">" . $hrana[meno] . "</td>";
 $vypocet = $data["dlzka_all"][$i] * $data["sirka_all"][$i] / 1000000;
 $vypocet = $vypocet * $data["ks_all"][$i];
 if (is_duplak($data["hrubka_all"][$i])) {
     $paska = 0;
     if ($data[hrana1_all][$i] > 0) {
         $paska = $paska + $data[dlzka_all][$i];
     }
     if ($data[hrana3_all][$i] > 0) {
         $paska = $paska + $data[dlzka_all][$i];
     }
     if ($data[hrana2_all][$i] > 0) {
         $paska = $paska + $data[sirka_all][$i];
     }
     if ($data[hrana4_all][$i] > 0) {
         $paska = $paska + $data[sirka_all][$i];
     }
     $vypocet_duplak = $data["dlzka_all"][$i] * $data["sirka_all"][$i] / 1000000;
     $vypocet_duplak = $vypocet_duplak * $data["ks_all"][$i];
示例#5
0
function display_form_data($fieldsets_c, $secure_key = "")
{
    $data = $_SESSION["posted_form"];
    $fieldsets_c = count($data["ks_all"]);
    //df($data);
    //var_dump($data);
    //var_dump($_SESSION["csrf_key"]);
    if ($_SESSION["csrf_key"] != $data["secure_csrf"]) {
        echo "ACCESS_dennied!!";
        header("location: ?vyber={$vyber}&page=1");
        die;
    }
    //var_dump($data);
    $file_c = count($data["file_name"]);
    for ($i = 0; $i < $file_c; $i++) {
        move_uploaded_file($data["file_tmp_name"][$i], "files/tmp/" . $data["file_name"][$i] . "." . $data["file_ext"][$i]);
    }
    echo "<table id=\"form_data_objednavatel\">\r\n       <tr>\r\n            <td class=\"hlavicka\">Meno / Firma</td><td class=\"objednavatel obj_meno\">" . sec_input($data["meno"]) . "</td>\r\n       </tr>\r\n       <tr>\r\n            <td class=\"hlavicka\">Adresa / Mesto</td>\r\n            <td class=\"objednavatel\">";
    if (!empty($data["adresa"])) {
        $adresa[] = sec_input($data["adresa"]);
    }
    if (!empty($data["mesto"])) {
        $adresa[] = sec_input($data["mesto"]);
    }
    echo "" . implode(", ", $adresa) . "        \r\n            </td>\r\n       </tr>\r\n       <tr>\r\n            <td class=\"hlavicka\">IČO / IČ DPH</td><td class=\"objednavatel\">" . sec_input($data["ico_icdph"]) . "</td>\r\n       </tr>\r\n       <tr>\r\n            <td class=\"hlavicka\">telefon</td><td class=\"objednavatel\">" . sec_input($data["telefon"]) . "</td>\r\n       </tr>\r\n       <tr>\r\n            <td class=\"hlavicka\">email</td><td class=\"objednavatel\">" . sec_input($data["email"]) . "</td>\r\n       </tr>";
    echo "</table>";
    echo "<table id=\"form_data_material\">\r\n       <tr>\r\n            <td class=\"hlavicka\">Materiál</td>";
    echo "<td class=\"objednavatel obj_meno\">";
    if (!empty($data["material"])) {
        $material = sql_query("SELECT meno FROM material WHERE id=" . sec_sql(sec_input($data["material"])) . " LIMIT 1");
        $material = $material[0];
        echo $material["meno"];
        $hrubka = sql_query("SELECT meno FROM hrubka WHERE id=" . sec_sql(sec_input($data["hrubka_rev"])) . " LIMIT 1");
        $hrubka = $hrubka[0]["meno"];
        echo " " . $hrubka;
    }
    echo "</td>\r\n       </tr>\r\n       <tr>\r\n            <td class=\"hlavicka\">Výrobca</td>";
    echo "<td class=\"objednavatel\">";
    if (!empty($data["vyrobca"])) {
        $vyrobca = sql_query("SELECT meno FROM vyrobca WHERE id=\"" . sec_sql(sec_input($data["vyrobca"])) . "\" LIMIT 1");
        $vyrobca = $vyrobca[0];
        echo $vyrobca["meno"];
    }
    echo "</td>\r\n       </tr>\r\n       <tr>\r\n            <td class=\"hlavicka\">Dekor</td>";
    echo "<td class=\"objednavatel\">";
    if (!empty($data["dekor"])) {
        $dekor = sql_query("SELECT meno FROM dekor WHERE id=" . sec_sql(sec_input($data["dekor"])) . " LIMIT 1");
        $dekor = $dekor[0];
        echo $dekor["meno"];
    }
    echo "</td>\r\n       </tr>\r\n       <tr>\r\n            <td class=\"hlavicka\">Vlastný dekor</td><td class=\"objednavatel\">" . sec_input($data["dekor_vlastny"]) . "</td>\r\n       </tr>";
    echo "</table>";
    echo "<table id=\"form_data_table\">\r\n       <tr>\r\n       <th></th>\r\n       <th>ks</th>\r\n       <th>rozmer</th>\r\n       <th>Názov</th>\r\n       <th>Poznámka</th>\r\n       <th>hrúbka</th>\r\n       <th>orient.</th>\r\n       <th>dolná</th>\r\n       <th>pravá</th>\r\n       <th>horná</th>\r\n       <th>ľavá</th>\r\n       <th></th>\r\n       </tr>";
    for ($i = 0; $i < $fieldsets_c; $i++) {
        $poradie = 0;
        $poradie = $i + 1;
        if (empty($data["hrana1_all"][$i])) {
            $data["hrana1_all"][$i] = "0";
        }
        if (empty($data["hrana2_all"][$i])) {
            $data["hrana2_all"][$i] = "0";
        }
        if (empty($data["hrana3_all"][$i])) {
            $data["hrana3_all"][$i] = "0";
        }
        if (empty($data["hrana4_all"][$i])) {
            $data["hrana4_all"][$i] = "0";
        }
        echo "<tr>\r\n            <td class=\"form_poradie\">{$poradie}. </td>\r\n            <td class=\"form_ks\">" . sec_input($data["ks_all"][$i]) . "</td>\r\n            <td class=\"form_rozmer\">" . sec_input($data["dlzka_all"][$i]) . " x " . $data["sirka_all"][$i] . " mm</td>\r\n            <td class=\"form_nazov\">" . sec_input($data["nazov_all"][$i]) . "</td>\r\n            <td class=\"form_nazov\">" . sec_input($data["poznamka_all"][$i]) . "</td>";
        $hrubka = sql_query("SELECT meno FROM hrubka WHERE id=" . sec_sql(sec_input($data["hrubka_all"][$i])) . " LIMIT 1");
        $hrubka = $hrubka[0];
        echo "\r\n            <td class=\"form_hrana\">" . $hrubka["meno"] . "</td>";
        $orientacia = sql_query("SELECT meno FROM orientacia WHERE id=" . sec_sql(sec_input($data["orientacia_all"][$i])) . " LIMIT 1");
        $orientacia = $orientacia[0];
        echo "\r\n            <td class=\"form_hrana\">" . $orientacia["meno"] . "</td>";
        $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana1_all"][$i])) . " LIMIT 1");
        $hrana = $hrana[0];
        echo "<td class=\"form_hrana\">" . $hrana[meno] . "</td>";
        $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana2_all"][$i])) . " LIMIT 1");
        $hrana = $hrana[0];
        echo "<td class=\"form_hrana\">" . $hrana[meno] . "</td>";
        $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana3_all"][$i])) . " LIMIT 1");
        $hrana = $hrana[0];
        echo "\r\n            <td class=\"form_hrana\">" . $hrana[meno] . "</td>";
        $hrana = sql_query("SELECT meno FROM hrana WHERE id=" . sec_sql(sec_input($data["hrana4_all"][$i])) . " LIMIT 1");
        $hrana = $hrana[0];
        echo "\r\n            <td class=\"form_hrana\">" . $hrana[meno] . "</td>";
        $vypocet = $data["dlzka_all"][$i] * $data["sirka_all"][$i] / 1000000;
        $vypocet = $vypocet * $data["ks_all"][$i];
        if (is_duplak($data["hrubka_all"][$i])) {
            $vypocet = ($data["dlzka_all"][$i] + 30) * ($data["sirka_all"][$i] + 30) / 1000000;
            $vypocet = $vypocet * ($data["ks_all"][$i] * 2);
        }
        $vypocet_sum = $vypocet_sum + $vypocet;
        $vypocet_final = round($vypocet, 2) . " m<sup>2</sup>";
        echo "<td class=\"td_vypocet\">" . ($vypocet > 0 ? $vypocet_final : "") . "</td>";
        echo "</tr>";
    }
    echo "</table>";
    echo "<div class=\"form_vypocet_sum\">Spolu: " . round($vypocet_sum, 2) . " m<sup>2</sup></div>";
    echo "<div id=\"form_komentar\">\r\n     " . sec_input($data["komentar"]) . "  \r\n    </div>";
    echo "<form method=\"POST\" id=\"formular\" enctype=\"multipart/form-data\">";
    echo "<fieldset><legend><strong>Prílohy k objednávke:</strong></legend>";
    echo "Povolené typy súborov: .doc .docx .xls .xlsx .jpg .pdf <br> ";
    file_upload("subor[]", "subor", "Príloha");
    file_upload("subor[]", "subor", "Príloha");
    file_upload("subor[]", "subor", "Príloha");
    file_upload("subor[]", "subor", "Príloha");
    file_upload("subor[]", "subor", "Príloha");
    echo "</fieldset>";
    echo "<div class=\"formular_buttons clearfix\">";
    echo submit("submit_confirm", "Odoslať objednávku");
    echo submit("submit_save", "Uložiť objednávku");
    echo "<div class=\"confirm_order_another\"><a href=\"?vyber=formular&page=1\">Vrátiť sa Späť k úprave</a></div>";
    echo "</div>";
    echo "</form>\r\n        \r\n        ";
    echo "<div class=\"help_text clearfix\">";
    echo "<ul>";
    echo "<li>Po odoslaní objednávky Vám bude doručený potvrdzujúci email</li>";
    echo "<li>Ak si prajete objednávku ešte opraviť použite tlačítko <strong>Vrátiť sa Späť</strong></li>";
    echo "<li>Ak Vaša objednávka ešte nie je v tejto chvíli kompletná a v jej dokončení chcete pokračovať neskôr, použite tlačítko <strong>Uložiť objednávku</strong>.<br>\r\n         Po uložení Vám bude na Vašu adresu doručený email s potvrdením a inštukciami, ako pokračovať vo vypĺňaní uloženej objednávky.\r\n        </li>";
    echo "</ul>";
    echo "</div>";
}