function update_case_history($id, $enter = 0, $txt = '') { global $db, $_SESSION; $H = array(); $H["hc_cu_id_k"] = $_SESSION["fh49ty58u893ytf83902g758902djr4cf302ty5798"]["id"]; $H["hc_c_id_k"] = $id; $H["hc_timestamp"] = date("Y-m-d H:i:s"); $H["hc_enter"] = $enter; $cnt = $db->GetOne("SELECT COUNT(1) FROM wind_history_case WHERE hc_timestamp LIKE '" . date("Y-m-d H:i") . "%' AND hc_c_id_k={$id} AND hc_cu_id_k=" . $_SESSION["fh49ty58u893ytf83902g758902djr4cf302ty5798"]["id"]); if (!$cnt) { wpisz($H, "wind_history_case", array()); } //wysyłanie maila do pełnomocnika $sprawa = $db->GetRow("SELECT ca_number_c, ca_agent_id_k, ca_debtor_id_k, ca_creditor_id_k FROM wind_case WHERE ca_id_s={$id}"); $email = $db->GetOne("SELECT cu_email_c FROM wind_users WHERE cu_id_s=" . $sprawa['ca_agent_id_k']); if ($email != '') { if (file_exists("../include/mail.php")) { include "../include/mail.php"; } $dluznik = $db->GetOne("SELECT c_shortname_c FROM wind_client WHERE c_id_s=" . $sprawa['ca_debtor_id_k']); $wierzyciel = $db->GetOne("SELECT c_shortname_c FROM wind_client WHERE c_id_s=" . $sprawa['ca_creditor_id_k']); $admin_letter = new eMail(2); $admin_letter->eMailContent('Zmiana w sprawie ' . $sprawa['ca_number_c'], '<html><head><title>Zmiana w sprawie ' . $sprawa['ca_number_c'] . '</title></head><body>W sprawie o numerze ' . $sprawa['ca_number_c'] . ' zostały zarejestrowane zmiany.' . "\n" . '<br><br>Dłużnik: ' . $dluznik . "\n" . '<br>Wierzyciel: ' . $wierzyciel . "\n" . ($txt != '' ? '<br>Szczegóły: ' . $txt : '') . '</body></html>'); $admin_letter->eMailSend($email); //$admin_letter->eMailSend('*****@*****.**'); } //////////////////////////////// }
//$in7days = mktime(0, 0, 0, date("m"), date("d")+7, date("Y")); //$in14days = mktime(0, 0, 0, date("m"), date("d")+14, date("Y")); $cases = $db->GetAll("SELECT `ca_number_c`, `ca_court_fee_date_d`, UNIX_TIMESTAMP(`ca_court_fee_date_d`) as termin, `ca_agent_id_k`, `ca_debtor_id_k`, `ca_creditor_id_k` FROM `wind_case` WHERE DATE_ADD(`ca_court_fee_date_d`, INTERVAL 7 DAY) <= '" . date("Y-m-d") . "' AND DATE_ADD(`ca_court_fee_date_d`, INTERVAL 14 DAY) >= '" . date("Y-m-d") . "' AND `ca_court_fee_paid_i`=0 AND ca_stage_e <> 'ep' AND ca_close_i=0"); if (count($cases) > 0) { foreach ($cases as $_id => $C) { $email = $db->GetOne("SELECT cu_email_c FROM wind_users WHERE cu_id_s=" . $C['ca_agent_id_k']); if ($email) { $dluznik = $db->GetOne("SELECT c_shortname_c FROM wind_client WHERE c_id_s=" . $C['ca_debtor_id_k']); $wierzyciel = $db->GetOne("SELECT c_shortname_c FROM wind_client WHERE c_id_s=" . $C['ca_creditor_id_k']); $tin14days = mktime(0, 0, 0, date("m", $C['termin']), date("d", $C['termin']) + 14, date("Y", $C['termin'])); $admin_letter = new eMail(2); $admin_letter->eMailContent(iconv('ISO-8859-2', 'UTF-8', 'Opłata sądowa sprawy ' . $C['ca_number_c']), '<html><head><title>Opłata sądowa sprawy ' . $C['ca_number_c'] . '</title></head><body>Termin zapłacenia opłaty sądowej w sprawie o numerze ' . $C['ca_number_c'] . ' mija ' . date("d.m.Y", $tin14days) . "\n" . '<br><br>Dłużnik: ' . $dluznik . "\n" . '<br>Wierzyciel: ' . $wierzyciel . "\n" . '</body></html>'); $admin_letter->eMailSend($email); } } } //przeholowane $cases = $db->GetAll("SELECT `ca_number_c`, `ca_court_fee_date_d`, UNIX_TIMESTAMP(`ca_court_fee_date_d`) as termin, `ca_agent_id_k`, `ca_debtor_id_k`, `ca_creditor_id_k` FROM `wind_case` WHERE DATE_ADD(`ca_court_fee_date_d`, INTERVAL 14 DAY) < '" . date("Y-m-d") . "' AND `ca_court_fee_paid_i`=0 AND ca_stage_e <> 'ep' AND ca_close_i=0"); if (count($cases) > 0) { foreach ($cases as $_id => $C) { $email = $db->GetOne("SELECT cu_email_c FROM wind_users WHERE cu_id_s=" . $C['ca_agent_id_k']); if ($email) { $tin14days = mktime(0, 0, 0, date("m", $C['termin']), date("d", $C['termin']) + 14, date("Y", $C['termin'])); $dluznik = $db->GetOne("SELECT c_shortname_c FROM wind_client WHERE c_id_s=" . $C['ca_debtor_id_k']); $wierzyciel = $db->GetOne("SELECT c_shortname_c FROM wind_client WHERE c_id_s=" . $C['ca_creditor_id_k']); $admin_letter = new eMail(2); $admin_letter->eMailContent(iconv('ISO-8859-2', 'UTF-8', 'Opłata sądowa sprawy ' . $C['ca_number_c']), '<html><head><title>Opłata sądowa sprawy ' . $C['ca_number_c'] . '</title></head><body>Termin zapłacenia opłaty sądowej w sprawie o numerze ' . $C['ca_number_c'] . ' minął ' . date("d.m.Y", $tin14days) . "\n" . '<br><br>Dłużnik: ' . $dluznik . "\n" . '<br>Wierzyciel: ' . $wierzyciel . "\n" . '</body></html>'); $admin_letter->eMailSend($email); } } }
<?php if ($_GET['xyz'] == 789) { require "./include/mail.php"; $admin_letter = new eMail(2); $admin_letter->eMailContent('Testowy email', 'Nagłówek' . "\n" . 'Content' . "\n" . 'Stopka'); $admin_letter->eMailSend('*****@*****.**'); }