function generate_csv_new($order, $revision, $sub = "") { mysql_query("BEGIN"); $rev = empty($revision) ? 0 : $revision; sql_insert("INSERT INTO revizia_aktivita (uzivatel_id, revizia, status) \r\n VALUES ({$_SESSION[username]}, {$rev}, \"vytvorenie CSV\")"); $obj = sql_query("SELECT id, DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum, status, c_obj\r\n FROM objednavka \r\n WHERE id=\"{$order}\"\r\n LIMIT 1"); $obj = $obj[0]; $rev = sql_query("SELECT DATE_FORMAT(datum, '%d. %m. %Y, %H:%i') AS datum,\r\n meno, adresa, ico_icdph, telefon, email, id_material, id_vyrobca, id_hrubka, id_dekor,\r\n dekor_vlastny, komentar\r\n FROM revizia \r\n WHERE id_obj=\"{$order}\" AND id=\"{$revision}\"\r\n LIMIT 1"); $rev = $rev[0]; $c_obj = $obj["c_obj"]; $material = sql_query("SELECT meno, max_dlzka, max_sirka\r\n FROM material \r\n WHERE id=\"" . $rev["id_material"] . "\" \r\n LIMIT 1")[0]; $hrubka = sql_query("SELECT id, hodnota\r\n FROM hrubka \r\n WHERE id=\"" . $rev["id_hrubka"] . "\" \r\n LIMIT 1")[0]; if (is_duplak($hrubka["id"])) { $hrubka["hodnota"] = "18"; } $meno_csv = sec_input(rep_dia($rev[meno])); $meno_csv = str_replace('/', "", $meno_csv); $meno_csv = str_replace(" ", "", $meno_csv); $meno_csv = str_replace(".", "", $meno_csv); //$material[meno] = str_replace(" ", "", $material[meno]); $vyrobca[meno] = str_replace(" ", "", $vyrobca[meno]); if (strlen($meno_csv) > 10) { $meno_csv = substr($meno_csv, 0, 10); } $directory = "files/csv_new/obj-{$order}/rev-{$revision}"; if (!file_exists($directory)) { mkdir($directory, 0777, true); } if (!empty($sub) && $sub == "pasy") { $meno_csv = $meno_csv . "-pasy"; } $fp = fopen("{$directory}/{$c_obj}-{$meno_csv}.csv", "w+"); $rev[meno] = rep_dia($rev[meno]); $rev[meno] = str_replace(" ", "_", $rev[meno]); $meno_suboru = $rev[meno] . "" . (strlen($dekor[hodnota]) > 1 ? "_{$dekor['hodnota']}" : "") . ""; $meno_suboru = mb_substr($meno_suboru, 0, 20, "UTF-8"); //$rev[meno] = str_replace("/", "", $rev[meno]); /* $hlavicka = "0;".rep_dia($material["meno"]).";2800;2070;18;*;10;10;10;10;1 "; */ $hlavicka = ""; $hlavicka2 = ""; $nar = sql_query("SELECT ks, dlzka, sirka, nazov, poznamka, duplak, hrubka, orientacia,\r\n hrana1, hrana2, hrana3, hrana4, duplak_paska\r\n FROM porez \r\n WHERE id_revizia=\"{$revision}\"\r\n "); $hrana = sql_query("SELECT id, hodnota, hodnota_csv, meno\r\n FROM hrana \r\n "); if (empty($material["max_dlzka"])) { $max_dlzka = def_value("max_dlzka", "hodnota"); } else { $max_dlzka = $material["max_dlzka"]; } if (empty($material["max_sirka"])) { $max_sirka = def_value("max_sirka", "hodnota"); } else { $max_sirka = $material["max_sirka"]; } //dd($material); foreach ($nar as $value) { //var_dump($value); $value[nazov] = str_replace(" ", "_", rep_dia($value[nazov])); $value[poznamka] = str_replace(" ", "_", rep_dia($value[poznamka])); $value[nazov] = preg_replace("/[^A-Z0-9a-z\\w ]/u", '', $value[nazov]); $value[poznamka] = preg_replace("/[^A-Z0-9a-z\\w ]/u", '', $value[poznamka]); //if ($value[orientacia]==0) $value[orientacia] = ""; /* if (!empty($value[nazov])) { $value[nazov] = $value[nazov]; } else { $value[nazov] = $rev[meno]; } if (!empty($value[poznamka])) { $value[poznamka] = $value[poznamka]; } else { $value[poznamka] = $rev[meno]; } */ if (strlen($value[nazov]) > 30) { $value[nazov] = substr($value[nazov], 0, 30); } if (strlen($value[poznamka]) > 40) { $value[poznamka] = substr($value[poznamka], 0, 40); } //var_dump($value[nazov]); foreach ($hrana as $value_hrana) { //var_dump($value_hrana); for ($i = 1; $i < 5; $i++) { if ($value_hrana[id] == $value["hrana" . $i]) { $value["hrana" . $i] = $value_hrana[meno]; $value["hrana" . $i . "_hodnota"] = $value_hrana[hodnota]; } if ($value["hrana" . $i] == "0") { $value["hrana" . $i] = ""; } if ($value["hrana" . $i] != "" and is_duplak($value[hrubka]) or $value["hrana" . $i] != "" and $value[duplak_paska] == 1) { $value["hrana" . $i] = "42/2"; } } } /* $orientacia = sql_query("SELECT meno, hodnota FROM orientacia WHERE id=\"$value[orientacia]\" LIMIT 1"); $orientacia = $orientacia[0][hodnota]; */ $orientacia = $value["orientacia"]; if ($orientacia == 3) { $orientacia = 0; } else { $orientacia = 1; } // nastavenie pre duplak // ak hrubka je totozna s prednastavenou hodnotou pre duplak, // automaticky zmeni pocet kusov * 2, // dlzku a sirku predlzi o 20 a znovu ich prevedie na string //var_dump(def_value("default_duplak", "hodnota")); //dd($value["hrubka"]); if (is_duplak($value[hrubka])) { $value[ks] = $value[ks] * 2; $value[ks] = "{$value['ks']}"; $value[poznamka] = $value[poznamka] . " Dup " . $value[dlzka] . "x" . $value[sirka] . " (rez " . ($value[dlzka] + 15) . "x" . ($value[sirka] + 15) . ")"; $value[dlzka] = $value[dlzka] + 30; $value[dlzka] = "{$value['dlzka']}"; $value[sirka] = $value[sirka] + 30; $value[sirka] = "{$value['sirka']}"; } $meno_materialu = rep_dia($material["meno"] . $hrubka["hodnota"]); if (!empty($sub) && $sub == "pasy") { $meno_materialu = "NaPasy" . $hrubka["hodnota"]; } else { if ($value[dlzka] > $max_dlzka - 20) { $value[dlzka] = $max_dlzka - 20; } if ($value[sirka] > $max_sirka - 20) { $value[sirka] = $max_sirka - 20; } } //if (count($value[hrana1_hodnota])<1) $value[hrana1_hodnota] = " "; //dd($value); $narezovka[] = array("ks" => $value[ks], "dlzka" => $value[dlzka], "sirka" => $value[sirka], "nazov" => $value[nazov] . "", "poznamka" => "{$value['poznamka']}", "orientacia" => "{$orientacia}", "{$value['hrana1']}", "{$value['hrana2']}", "{$value['hrana3']}", "{$value['hrana4']}", $meno_materialu); } //var_dump($narezovka); //die(); if ($fp) { fwrite($fp, $hlavicka); //fputcsv($fp, array_values($row), ";"); //fwrite($fp, $hlavicka2); foreach ($narezovka as $fields) { fputcsv($fp, $fields, ";"); } } $status_obj = def_value("default_obj_status_spracovana", "hodnota"); if ($obj["status"] == def_value("default_obj_status_cp", "hodnota")) { $status_obj = def_value("default_obj_status_cp_spracovana", "hodnota"); } $query = "UPDATE objednavka\r\n SET status={$status_obj}\r\n WHERE id=\"{$order}\""; sql_update($query); mysql_query("COMMIT"); ob_end_clean(); header('Content-Type: application/download'); header('Content-Disposition: attachment; filename="' . $c_obj . '-' . $meno_csv . '.csv"'); //header("Content-Length: " . filesize("{$c_obj}-{$meno_csv}.csv")); header('Pragma: no-cache'); readfile("{$directory}/{$c_obj}-{$meno_csv}.csv"); //header("location: {$directory}/{$c_obj}-{$meno_csv}.csv"); exit; }
function 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}"; }
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; }
$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];
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>"; }