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('*****@*****.**');
}
