Esempio n. 1
0
        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('*****@*****.**');
    }
    ////////////////////////////////
}
if ($_POST['ca_court_fee_date_d'] != '') {
    ereg("([0-9]{2}).([0-9]{2}).([0-9]{4})", $_POST['ca_court_fee_date_d'], $D);
    $_POST['ca_court_fee_date_d'] = $D[3] . '-' . $D[2] . '-' . $D[1];
}
$aff = update2($_POST, "wind_case", array("ca_id_s"), "ca_id_s", $_POST['ca_id_s']);
if ($aff >= 0) {
    $name = $db->GetOne("SELECT ca_number_c FROM wind_case WHERE ca_id_s=" . $_POST['ca_id_s']);
    update_history_operation("Sprawy", "Zmiana opłaty sądowej w sprawie o numerze \"" . $name . "\"", "wind_case", $_POST['ca_id_s']);
    update_case_history($_POST['ca_id_s'], 0, 'Zmiana opłaty sądowej w sprawie o numerze ' . $name);
    echo "1";
} else {
    echo "0";
}
Esempio n. 2
0
        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}");
    if ($sprawa['ca_agent_id_k'] != $_SESSION["fh49ty58u893ytf83902g758902djr4cf302ty5798"]["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);
        }
    }
    ////////////////////////////////
}
$_POST['n_datetime_d'] = date("Y-m-d H:i:s");
$_POST['n_u_id_k'] = $_SESSION["fh49ty58u893ytf83902g758902djr4cf302ty5798"]["id"];
$_POST['n_stage_e'] = $db->GetOne("SELECT ca_stage_e FROM wind_case WHERE ca_id_s=" . $_POST['n_case_id_k']);
$_nID = wpisz($_POST, "wind_notes", array());
if ($_nID) {
    $name = $db->GetOne("SELECT ca_number_c FROM wind_case WHERE ca_id_s=" . $_POST['n_case_id_k']);
    update_history_operation("Notatki", "Dodanie notatki do sprawy o numerze \"" . $name . "\"", "wind_notes", $_nID);
    update_case_history($_POST['n_case_id_k'], 0, 'Dodanie notatki');
    echo "1";
} else {
    echo "0";
}
Esempio n. 3
0
        }
    }
    if ($kwota > 0) {
        //albo pozostała kwota albo nie było faktur wyszczególnionych, i "jedziemy" jeszcze raz, tylko biorąc wszystkie faktury od najstarszej
        $FS = $db->GetAll("SELECT frn_id_s FROM wind_frn WHERE frn_case_id_k=" . $_POST['pi_case_id_k'] . " AND frn_amount_left_f > 0 ORDER BY frn_date_d ASC");
        foreach ($FS as $_id => $FR) {
            $frn = $FR['frn_id_s'];
            $F = $db->GetRow("SELECT * FROM wind_frn WHERE frn_id_s={$frn}");
            if ($kwota > 0) {
                $pozostalo = $kwota - $F['frn_amount_left_f'];
                if ($pozostalo >= 0) {
                    //spłacone zobowiązanie
                    $db->Execute("UPDATE wind_frn SET frn_amount_left_f=0 WHERE frn_id_s={$frn}");
                    $db->Execute("INSERT INTO wind_f2p(fp_payin_id_k, fp_frn_id_k, fp_case_id_k, fp_currency_e, fp_amount_f) VALUES({$_piID}, {$frn}, " . $_POST['pi_case_id_k'] . ", '" . $_POST['pi_currency_e'] . "', " . $F['frn_amount_left_f'] . ")");
                    $kwota = $pozostalo;
                } else {
                    $left = $F['frn_amount_left_f'] - $kwota;
                    $db->Execute("UPDATE wind_frn SET frn_amount_left_f={$left} WHERE frn_id_s={$frn}");
                    $db->Execute("INSERT INTO wind_f2p(fp_payin_id_k, fp_frn_id_k, fp_case_id_k, fp_currency_e, fp_amount_f) VALUES({$_piID}, {$frn}, " . $_POST['pi_case_id_k'] . ", '" . $_POST['pi_currency_e'] . "', " . $kwota . ")");
                    $kwota = 0;
                }
            }
        }
    }
    $name = $db->GetOne("SELECT ca_number_c FROM wind_case WHERE ca_id_s=" . $_POST['pi_case_id_k']);
    update_history_operation("Wpłaty", "Dodanie wpłaty " . number_format($_POST['pi_amount_f'], 2, ".", " ") . " " . $_POST['pi_currency_e'] . " do sprawy o numerze \"" . $name . "\"", "wind_payin", $_piID);
    update_case_history($_POST['pi_case_id_k'], 0, 'Dodanie wpłaty ' . number_format($_POST['pi_amount_f'], 2, ".", " ") . ' ' . $_POST['pi_currency_e']);
    echo "1";
} else {
    echo "0";
}
Esempio n. 4
0
 <?php 
           print print_calendar('ca_statement_delivery_d', 'ca_statement_delivery_d_handle');
           ?>
 <?php 
           print print_calendar('ca_exec_apply_d', 'ca_exec_apply_d_handle');
           ?>
 <?php 
           print print_calendar('ca_exec_d', 'ca_exec_d_handle');
           ?>
 <?php 
           print print_calendar('ca_statement_exec_d', 'ca_statement_exec_d_handle');
           ?>
 </script>
 <?php 
       }
       update_case_history($caID, 1);
   }
   //}}}
   if ($list == 1) {
       if (isset($submit2_x) || isset($submit2)) {
           if (count($_POST["check"]) > 0) {
               foreach ($_POST["check"] as $_id => $pid) {
                   $name = $db->GetOne("SELECT ca_number_c FROM wind_case WHERE ca_id_s={$pid}");
                   $deleting = usun2("wind_case", "ca_id_s", $pid);
                   if ($deleting) {
                       update_history_operation("Sprawy", "Usunięcie sprawy o numerze \"" . $name . "\"", "wind_case", 'NULL');
                       $_SESSION['message'][] = "Sprawa {$name} usunięta";
                   } else {
                       $_SESSION['errors'][] = "Usunięcie sprawy {$name} nie powiodło się";
                   }
               }