$res = mysql_query("SELECT * FROM `db_it_invent` WHERE `invent`='" . $invent . "' AND `inv_plus`='" . $inv_plus . "' AND `id`<>'" . $_POST['edit_id'] . "' LIMIT 1;");
if (mysql_num_rows($res) == 0) {
mysql_query("UPDATE `db_it_invent` SET `name`='" . $name . "', `invent`='" . $invent . "', `inv_plus`='" . $inv_plus . "', `data_made`='" . data_trans("ua", "mysql", $data_made) . "', `data_install`='" . data_trans("ua", "mysql", $data_install) . "', `status_id`='" . $status_id . "', `room_id`='" . $room_id . "', `user_id`='" . $user_id . "', `suma`='" . $suma . "', `amort`='" . $amort . "' WHERE `id`='" . $_POST['edit_id'] . "' LIMIT 1;") or die(mysql_error());
echo '
<font color="green"><strong>Дані оновлено</strong></font>
<hr>
<center>
<button onclick="$(\'#informer\').modal(\'hide\'); load();" type="button" class="btn btn-success" data-dismiss="modal">Закрити</button>
</center>';
} else {
$error = 1;
}
} else {
$res = mysql_query("SELECT * FROM `db_it_invent` WHERE `invent`='" . $invent . "' AND `inv_plus`='" . $inv_plus . "' LIMIT 1;");
if (mysql_num_rows($res) == 0) {
mysql_query("INSERT INTO `db_it_invent` (`id`, `invent`, `inv_plus`, `name`, `data_made`, `data_install`, `status_id`, `room_id`, `user_id`, `suma`, `amort`)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (NULL, '" . $invent . "', '" . $inv_plus . "', '" . $name . "', '" . data_trans("ua", "mysql", $data_made) . "', '" . data_trans("ua", "mysql", $data_install) . "', '" . $status_id . "', '" . $room_id . "', '" . $user_id . "', '" . $suma . "', '" . $amort . "')") or die(mysql_error());
echo '
<font color="green"><strong>Дані записано</strong></font>
<hr>
<center>
<button onclick="$(\'#informer\').modal(\'hide\'); load();" type="button" class="btn btn-success" data-dismiss="modal">Закрити</button>
</center>';
} else {
$error = 1;
}
}
if ($error == 1) {
echo '
<font color="red">Інвентарний номер вже існує</font>
<hr>
<center>
$count_overdue++;
}
if ($count_overdue > 0) {
$html .= "У Вас є " . $count_overdue . " прострочена(них) інформація(й) у вхідній кореспонденції.<hr>";
$html .= $html_overdue;
$html .= "<hr>";
}
}
// Пошук прострочених завдань вхідної ел. кор.
$query = "SELECT `id`, `add_time`, `org_name`, `org_subj`, `make_data` FROM `db_" . date('Y') . "_in_ep` WHERE `do_user`='" . $_SESSION['user_id'] . "' AND `do_made` IS NULL AND `make_data` < '" . date('Y-m-d H:i:s') . "' ; ";
$res = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($res) > 0) {
$count_overdue = 0;
$html_overdue = "";
while ($row = mysql_fetch_array($res)) {
$html_overdue .= "<strong>" . $row['add_time'] . "</strong>, №<strong><a href=\"jurnal_in_ep.php?do=search&id=" . $row['id'] . "\">" . $row['id'] . "</a></strong>, <strong>" . $row['org_name'] . "</strong> - <strong>" . $row['org_subj'] . "</strong> до <font color=\"red\"><strong>" . data_trans("mysql", "ua", $row['make_data']) . "</strong></font><br>";
$count_overdue++;
}
if ($count_overdue > 0) {
$html .= "У Вас є " . $count_overdue . " прострочена(них) інформація(й) у вхідній ел. кореспонденції.<hr>";
$html .= $html_overdue;
$html .= "<hr>";
}
}
if ($html != "") {
echo "<div class=\"modal-header\">\n <button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-label=\"{LANG_JURN_OUT_NUM_CLOSE}\"><span aria-hidden=\"true\">×</span></button>\n <h4 class=\"modal-title text-center\" id=\"myModalLabel\">Прострочена інформація</h4>\n </div>\n <div class=\"modal-body text-center\">\n " . $html . "\n </div>\n <div class=\"modal-footer\">\n <a href=\"#\" onclick=\"set_overdue_time();\" role=\"button\" class=\"btn btn-default btn-lg\"><span class=\"glyphicon glyphicon-remove\" aria-hidden=\"true\" data-toggle=\"tooltip\" data-original-title=\"Закрити\"></span> Закрити</a>\n </div>";
}
}
if ($_GET['do'] == "set_view") {
$_SESSION['overdue_timestamp'] = date('Y-m-d H:i:s');
$query = "UPDATE `db_" . date('Y') . "_in` SET `do_view`='" . date('Y-m-d H:i:s') . "', `do_view_ip`='" . $_SERVER['REMOTE_ADDR'] . "' WHERE `do_user`='" . $_SESSION['user_id'] . "' AND `do_view` IS NULL ; ";
$need_serch_blank = "";
if ($_GET['blank'] == "do") {
$need_serch_blank = "&blank=do&";
}
if ($row['to_num'] == "") {
$row['to_num'] = "-";
}
$num_is_edited = "";
if ($row['edit'] == 1) {
$num_is_edited = "<tr><td class=\"bg-warning\" colspan=\"2\"><p class=\"text-danger\"><strong>{LANG_NUM_IS_EDITED}</strong><br>{LANG_MODERATOR} <strong>" . $users[$row['fav']] . "</strong><br>{LANG_LOG_TIME} <strong>" . date('Y-m-d H:i:s', $row['time']) . "</strong></p></td></tr>";
}
$num_show_index = get_index_module($_SESSION['user_year'], "out", $row['id'], $index_module[$row['nom']]['str'], $index_module[$row['nom']]['nom'], $row['user'], $c_index_module);
$print_regular_nt = get_mailto_subject($c_n_ray, $index_module[$row['nom']]['str'], $index_module[$row['nom']]['nom'], $row['id'], $row['subj']);
$mailtobody = get_mailto_body($c_nam, $num_show_index, $users[$row['user']], data_trans("mysql", "ua", $row['data']), $c_ver, $c_ver_alt, $user_tel1);
$jurnal_out .= "\n <tr valign=\"top\" align=\"center\">\n <td valign=\"top\" align=\"center\" ><abbr title=\"{LANG_NUM_INFO_PLUS}\"><a data-toggle=\"modal\" href=\"#JOn" . $row['id'] . "\" aria-expanded=\"false\" aria-controls=\"JOn" . $row['id'] . "\">" . $num_show_index . "</a></abbr></td>\n <td valign=\"top\" align=\"center\" ><a href=\"jurnal_out.php?" . $need_serch_blank . "find=data&do=" . $row_data[0] . "\">" . data_trans("mysql", "ua", $row_data[0]) . "</a></td>\n <td valign=\"top\" align=\"left\" >" . $row['to'] . "</td>\n <td valign=\"top\" align=\"left\" >" . $row['subj'] . "</td>\n <td valign=\"top\" align=\"left\" ><a href=\"jurnal_out.php?" . $need_serch_blank . "find=user&do=" . $row['user'] . "\">" . $users[$row['user']] . "</a></td>\n <td valign=\"top\" align=\"center\" ><a href=\"jurnal_out.php?" . $need_serch_blank . "find=how&do=" . $row['how'] . "\">" . $how_img . "</a></td>\n <td valign=\"top\" align=\"center\" >" . $blank_num . "</td>\n </tr>";
$modals .= "\n <div class=\"modal\" id=\"JOn" . $row['id'] . "\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"JOn" . $row['id'] . "Label\">\n <div class=\"modal-dialog\" role=\"document\">\n <div class=\"modal-content\">\n <div class=\"modal-header\">\n <button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-label=\"{LANG_JURN_OUT_NUM_CLOSE}\"><span aria-hidden=\"true\">×</span></button>\n <h4 class=\"modal-title text-center\" id=\"myModalLabel\">{LANG_JURN_OUT_NUM_INFO} " . $num_show_index . "</h4>\n\t\t\t\t\t\t\t\t\t\t<center><p>Підготувати лист: <a href=\"mailto:?subject=" . $print_regular_nt . "&body=" . $mailtobody . "\">Поштовий клієнт</a>, <a target=\"_blank\" href=\"https://mail.dksu.gov.ua/owa/?ae=Item&a=New&t=IPM.Note&to=" . $db_connect[4] . "&SUBJECT=" . $print_regular_nt . "\">OWA</a></p></center>\n </div>\n <div class=\"modal-body text-center\">\n <table class=\"table table-hover\">\n " . $num_is_edited . "\n <tr>\n <td align=\"right\">{LANG_OUT_ADD_FROM}</td>\n <td align=\"left\"><strong>" . $users[$row['user']] . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_LOG_TIME}</td>\n <td align=\"left\"><strong>" . data_trans("mysql", "ua", $row_data[0]) . "</strong> " . $row_data[1] . "</td>\n </tr>\n <tr>\n <td align=\"right\">{RETURN_BLANK_N}</td>\n <td align=\"left\"><strong>" . $blank_num . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_JURNAL_TO}</td>\n <td align=\"left\"><strong>" . $row['to'] . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_OUT_TEMA}</td>\n <td align=\"left\"><strong>" . $row['subj'] . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_OUT_ADD_TO_N}</td>\n <td align=\"left\"><strong>" . $row['to_num'] . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_HOW}</td>\n <td align=\"left\"><strong>{LANG_HOW_" . $row['how'] . "}</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_SEND_MONEY}</td>\n <td align=\"left\"><strong>" . $row['money'] . "</strong></td>\n </tr>\n </table>\n </div>\n <div class=\"modal-footer\">\n <a href=\"#\" role=\"button\" class=\"btn btn-default btn-lg\" data-dismiss=\"modal\"><span class=\"glyphicon glyphicon-remove\" aria-hidden=\"true\" data-toggle=\"tooltip\" data-original-title=\"{LANG_JURN_OUT_NUM_CLOSE}\"></span></a>\n " . $admin_links_do . "\n </div>\n </div>\n </div>\n </div>";
$is_first = "true";
if (isset($_GET['export']) and $_GET['export'] == "do") {
$export .= "\"" . $row['id'] . " \\ " . $nomenclatura[$row['nom']] . "\";\"" . $blank_num . "\";\"" . $row['to_num'] . "\";\"" . $row['data'] . "\";\"" . $row['subj'] . "\";\"" . $users[$row['user']] . "\";\"" . $row['to'] . "\";\"{LANG_HOW_" . $row['how'] . "}\";\"" . $row['money'] . "\";\n";
}
}
$page .= $modals;
$page = str_replace("{JURNAL_OUT}", $jurnal_out, $page);
$page = str_replace("{JURNAL_OUT_STAT}", "{JURNAL_OUT_NUM_ON_PAGE}: " . $list . " / " . mysql_num_rows($res) . " / " . ($b[0] - mysql_num_rows($res) - $list), $page);
if (mysql_num_rows($res) == 0) {
$page .= file_get_contents("templates/information_danger.html");
$page = str_replace("{INFORMATION}", "{LANG_JURNAL_OUT_EMPTY}", $page);
}
} else {
$page .= file_get_contents("templates/information_danger.html");
$page = str_replace("{INFORMATION}", "{LANG_YEAR_NOT_EXIST}", $page);
if ($inform_user_array[1] == "") {
$inform_user_array[1] = "<span class=\"glyphicon glyphicon-eye-close\"></span>";
}
$html_inform_users .= "<tr>\n <td align=\"right\">" . $users[$inform_user_array[0]] . "</td>\n <td align=\"left\">" . $inform_user_array[1] . "</td>\n </tr>";
}
}
$jurnal_in .= "\n <tr valign=\"top\" align=\"center\" id=\"TRn" . $row['id'] . "\" " . $tr_color_info . ">\n <td valign=\"top\" align=\"center\"><abbr title=\"{LANG_NUM_INFO_PLUS}\"><strong><a data-toggle=\"modal\" href=\"#JOn" . $row['id'] . "\" aria-expanded=\"false\" aria-controls=\"JOn" . $row['id'] . "\">" . $row['id'] . "</strong></a></abbr></td>\n <td valign=\"top\" align=\"center\"><a onclick=\"skm_LockScreen()\" href=\"" . $glyphicon_search_url . "\"><span class=\"" . $glyphicon . "\" aria-hidden=\"true\" data-toggle=\"tooltip\" data-original-title=\"" . $glyphicon_tooltip . "\"></span></a></td>\n <td valign=\"top\" align=\"center\"><a onclick=\"skm_LockScreen()\" href=\"?do=search&get_data=" . data_trans("mysql", "ua", $row['get_data']) . "\">" . data_trans("mysql", "ua", $row['get_data']) . "</a></td>\n <td valign=\"top\" align=\"left\"><a onclick=\"skm_LockScreen()\" href=\"?do=search&org_name=" . $row['org_name'] . "\">" . $row['org_name'] . "</a></td>\n <td valign=\"top\" align=\"left\">" . $row['org_index'] . "</td>\n <td valign=\"top\" align=\"center\"><a onclick=\"skm_LockScreen()\" href=\"?do=search&org_data=" . data_trans("mysql", "ua", $row['org_data']) . "\">" . data_trans("mysql", "ua", $row['org_data']) . "</a></td>\n <td valign=\"top\" align=\"left\">" . $row['org_subj'] . "</td>\n <td valign=\"top\" align=\"left\"><a onclick=\"skm_LockScreen()\" href=\"?do=search&do_user="******"\">" . $users[$row['do_user']] . "</a></td>\n <td valign=\"top\" align=\"left\">" . $row['make_visa'] . "</td>\n <td valign=\"top\" align=\"center\">" . data_trans("mysql", "ua", $row['make_data']) . "</td>\n </tr>";
$modals .= "\n <div class=\"modal\" id=\"JOn" . $row['id'] . "\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"JOn" . $row['id'] . "Label\">\n <div class=\"modal-dialog\" role=\"document\">\n <div class=\"modal-content\">\n <div class=\"modal-header\">\n <button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-label=\"{LANG_JURN_OUT_NUM_CLOSE}\"><span aria-hidden=\"true\">×</span></button>\n <h4 class=\"modal-title text-center\" id=\"myModalLabel\">{LANG_JURNAL_IN_INFO_N} " . $row['id'] . "</h4>\n </div>\n <div class=\"modal-body text-center\">\n <table class=\"table table-hover\">\n " . $num_is_edited . "\n <tr>\n <td align=\"right\"><strong>" . data_trans("mysql", "ua", $row['add_time']) . "</strong></td>\n <td align=\"left\">{LANG_ADD_USER} <abbr data-toggle=\"tooltip\" data-placement=\"bottom\" data-original-title=\"" . $row['add_ip'] . "\"><strong>" . $users[$row['add_user']] . "</strong></abbr></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_GET_DATA_S}</td>\n <td align=\"left\"><strong>" . data_trans("mysql", "ua", $row['get_data']) . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_ORG_NAME_S}: <strong>" . $row['org_name'] . "</strong></td>\n <td align=\"left\"><kbd>№" . $row['org_index'] . ", від " . data_trans("mysql", "ua", $row['org_data']) . "</kbd></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_ORG_SUBJ}</td>\n <td align=\"left\"><strong>" . $row['org_subj'] . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_MAKE_VISA}: <strong>" . $row['make_visa'] . "</strong></td>\n <td align=\"left\">{LANG_DO_USER}: <strong>" . $users[$row['do_user']] . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_MAKE_DATA}</td>\n <td align=\"left\"><strong>" . data_trans("mysql", "ua", $row['make_data']) . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_JURNAL_STEP_DO}</td>\n <td align=\"left\"><strong><span class=\"" . $glyphicon . "\" aria-hidden=\"true\" data-toggle=\"tooltip\" data-original-title=\"" . $glyphicon_tooltip . "\"></span> " . $glyphicon_tooltip . "</strong></td>\n </tr>" . $html_inform_users;
if (!empty($row['out_year'])) {
$row_nom = explode(":", $row['out_index']);
$modals .= "<tr>\n <td align=\"right\">{LANG_OUT_DOC_INDEX}: </td>\n <td align=\"left\"><strong>" . $row_nom[0] . "</strong></td>\n </tr>\n <tr>\n <td align=\"right\">{LANG_NOMENCLATURA}: </td>\n <td align=\"left\"><strong>" . $row_nom[1] . "</strong></td>\n </tr>";
}
$modals .= "</table>\n </div>\n <div class=\"modal-footer\"><a href=\"#\" role=\"button\" class=\"btn btn-default btn-lg\" data-dismiss=\"modal\"><span class=\"glyphicon glyphicon-remove\" aria-hidden=\"true\" data-toggle=\"tooltip\" data-original-title=\"{LANG_JURN_OUT_NUM_CLOSE}\"></span></a>" . $admin_links_do . "</div>\n </div>\n </div>\n </div>";
$is_first = 1;
if (isset($_GET['export']) and $_GET['export'] == "do") {
$export .= "\"" . $row['id'] . "\";\"" . $glyphicon_export . "\";\"" . $users[$row['add_user']] . "\";\"" . data_trans("mysql", "ua", $row['add_time']) . "\";\"" . data_trans("mysql", "ua", $row['get_data']) . "\";\"" . $row['org_name'] . "\";\"" . $row['org_index'] . "\";\"" . data_trans("mysql", "ua", $row['org_data']) . "\";\"" . $row['org_subj'] . "\";\"" . $users[$row['do_user']] . "\";\"" . $row['make_visa'] . "\";\"" . data_trans("mysql", "ua", $row['make_data']) . "\";\"" . data_trans("mysql", "ua", $row['do_view']) . "\";\"" . data_trans("mysql", "ua", $row['do_made']) . "\";\n";
}
}
} else {
$page .= file_get_contents("templates/information.html");
$page = str_replace("{INFORMATION}", "{LANG_JURNAL_OUT_EMPTY}", $page);
}
$page = str_replace("{JURNAL_IN}", $jurnal_in, $page);
$page .= $modals;
}
$page = str_replace("{JURNAL_IN_TOP_STAT}", " ", $page);
} else {
$loging_do = "{LANG_LOG_JURNAL_IN_403}";
include 'inc/loging.php';
header('HTTP/1.1 403 Forbidden');
$page .= file_get_contents("templates/information_danger.html");
function Add($add_user, $add_ip, $add_permission, $srch, $rpls, $user_p_mod)
{
$error = "";
if (!preg_match("/^[1-9][0-9]*\$/", $add_user)) {
$error .= "Помилка авторизації.<br />";
}
if ($add_ip == '') {
$error .= "Помилка визначення IP адреси.<br />";
}
if ($add_permission != 1) {
$error .= "Нема прав на додавання доходів.<br />";
}
if ($error == "") {
$vys_nom = str_replace($srch, $rpls, $_POST['vys_nom']);
$vys_data = str_replace($srch, $rpls, $_POST['vys_data']);
$plat_cod = str_replace($srch, $rpls, $_POST['plat_cod']);
$plat_name = str_replace($srch, $rpls, $_POST['plat_name']);
$kbk = str_replace($srch, $rpls, $_POST['kbk']);
$suma = str_replace($srch, $rpls, $_POST['suma']);
$from_rah = str_replace($srch, $rpls, $_POST['from_rah']);
$to_rah = str_replace($srch, $rpls, $_POST['to_rah']);
$new_plat = str_replace($srch, $rpls, $_POST['new_plat']);
if ($vys_nom == "") {
$error .= "Не вказано номер висновку<br />";
}
if ($vys_data == '') {
$vys_data = 0;
}
if (!check_data(data_trans("ua", "mysql", $vys_data))) {
$error .= "Не вірна дата висновку<br />";
}
if ($plat_cod == "") {
$error .= "Не вказано код платника<br />";
}
if ($plat_name == "") {
$error .= "Не вказано платника<br />";
}
if ($kbk == "") {
$error .= "Не вказано код бюджетної класифікації доходів<br />";
}
if (!preg_match("/^[1-9][0-9]*\$/", $from_rah)) {
$error .= "Не вказано з якого рахунку<br />";
}
if (!preg_match("/^[1-9][0-9]*\$/", $to_rah)) {
$error .= "Не вказано на який рахунок<br />";
}
if ($new_plat == "") {
$error .= "Не вказано платіжне доручення<br />";
}
$suma = check_suma($suma);
if ($suma == 0) {
$error .= 'Сума вказана не вірно<br />';
}
// echo "DEBUG ".date('H:i:s').".<hr>vys_nom=".$vys_nom.".<br>vys_data=".$vys_data.".<br>plat_cod=".$plat_cod.".<br>plat_name=".$plat_name.".<br>kbk=".$kbk.".<br>suma=".$suma.".<br>from_rah=".$from_rah.".<br>to_rah=".$to_rah.".<br>new_plat=".$new_plat.".<hr><font color=red>".$error."</font>";
if ($error == "") {
if (preg_match("/^[1-9][0-9]*\$/", $_POST['edit_id'])) {
$edit_id = $_POST['edit_id'];
if (date('Y') == $_SESSION['user_year']) {
$res = mysql_query("SELECT * FROM `db_" . date('Y') . "_dox_1` WHERE `id`='" . $edit_id . "' LIMIT 1 ;");
if (mysql_num_rows($res) == 1) {
while ($row = mysql_fetch_array($res)) {
if ($row['add_user'] == $add_user or $user_p_mod == 1) {
mysql_query("UPDATE `db_" . date('Y') . "_dox_1` SET `vys_nom`='" . $vys_nom . "', `vys_data`='" . data_trans("ua", "mysql", $vys_data) . "', `plat_cod`='" . $plat_cod . "', `plat_name`='" . $plat_name . "', `kbk`='" . $kbk . "', `suma`='" . $suma . "', `from_rah`='" . $from_rah . "', `to_rah`='" . $to_rah . "', `new_plat`='" . $new_plat . "', `edit_user`='" . $add_user . "', `edit_time`='" . date('Y-m-d H:i:s') . "', `edit_ip`='" . $add_ip . "' WHERE `id`='" . $edit_id . "' LIMIT 1 ;") or die(mysql_error());
echo "<hr>Результат: <font color=green>Дані оновлено</font> № <strong>" . $edit_id . "</strong>. Висновок №<strong>" . $vys_nom . "</strong> від <strong>" . $vys_data . "</strong> на суму <strong>" . $suma . "</strong><hr>";
echo "<input id=\"result\" value=\"editSuccess\" class=\"hidden\" type=\"hidden\"/>";
echo "<input id=\"editId\" value=\"" . $edit_id . "\" class=\"hidden\" type=\"hidden\"/>";
} else {
echo "<hr>Результат: <font color=red>Дані не оновлено</font> Ви не автор № <strong>" . $edit_id . "</strong> та права модератора відсутні.<hr>";
echo "<input id=\"result\" value=\"editError\" class=\"hidden\" type=\"hidden\"/>";
echo "<input id=\"reason\" value=\"noModer\" class=\"hidden\" type=\"hidden\"/>";
}
}
} else {
echo "<hr>Результат: <font color=red>Дані не оновлено</font> № <strong>" . $edit_id . "</strong> Не існує.<hr>";
echo "<input id=\"result\" value=\"editError\" class=\"hidden\" type=\"hidden\"/>";
echo "<input id=\"reason\" value=\"noExists\" class=\"hidden\" type=\"hidden\"/>";
}
} else {
echo "<hr>Результат: <font color=red>Дані не оновлено</font> <strong>Редагувати номери минулого року заборонено</strong>.<hr>";
echo "<input id=\"result\" value=\"editError\" class=\"hidden\" type=\"hidden\"/>";
echo "<input id=\"reason\" value=\"lastYear\" class=\"hidden\" type=\"hidden\"/>";
}
} else {
mysql_query("INSERT INTO `db_" . date('Y') . "_dox_1` (`id`, `add_user`, `add_time`, `add_ip`, `vys_nom`, `vys_data`, `plat_cod`, `plat_name`, `kbk`, `suma`, `from_rah`, `to_rah`, `new_plat`) \n\t\t\t\t\t\t\t\tVALUES (NULL, '" . $add_user . "', '" . date('Y-m-d H:i:s') . "', '" . $add_ip . "', '" . $vys_nom . "', '" . data_trans("ua", "mysql", $vys_data) . "', '" . $plat_cod . "', '" . $plat_name . "', '" . $kbk . "', '" . $suma . "', '" . $from_rah . "', '" . $to_rah . "', '" . $new_plat . "')") or die(mysql_error());
echo "<hr>Результат: <font color=green>Дані записано</font> під № <strong>" . mysql_insert_id() . "</strong>. Висновок №<strong>" . $vys_nom . "</strong> від <strong>" . $vys_data . "</strong> на суму <strong>" . $suma . "</strong><hr>";
echo "<input id=\"result\" value=\"addSuccess\" class=\"hidden\" type=\"hidden\"/>";
echo "<input id=\"new_id\" value=\"" . mysql_insert_id() . "\" class=\"hidden\" type=\"hidden\"/>";
}
} else {
echo "<hr>Результат:<br /><font color=red>" . $error . "</font><hr>";
echo "<input id=\"result\" value=\"addError\" class=\"hidden\" type=\"hidden\"/>";
if (preg_match("/^[1-9][0-9]*\$/", $_POST['edit_id'])) {
echo "<input id=\"editId\" value=\"" . $_POST['edit_id'] . "\" class=\"hidden\" type=\"hidden\"/>";
}
}
} else {
echo $error;
echo "<input id=\"result\" value=\"addError\" class=\"hidden\" type=\"hidden\"/>";
}
}
