<?php
header("Content-Type:application/json; ");
require_once('loader.php');
$ans = sql_q("SELECT * FROM post WHERE post_no=? " ,array($_POST['post_no']));
$sum = array('map'=>$ans);
echo json_encode($sum);
if(!empty($_GET['rest_day3'])){$rest3 = reverseDate($_GET['rest_day3']);}
if(!empty($_GET['rest_day4'])){$rest4 = reverseDate($_GET['rest_day4']);}
if(!empty($_GET['rest_day5'])){$rest5 = reverseDate($_GET['rest_day5']);}
//работен ден
if(!empty($_GET['work_day'])){$work1 = reverseDate($_GET['work_day']);}
if(!empty($_GET['work_day2'])){$work2 = reverseDate($_GET['work_day2']);}
if(!empty($_GET['work_day3'])){$work3 = reverseDate($_GET['work_day3']);}
if(!empty($_GET['work_day4'])){$work4 = reverseDate($_GET['work_day4']);}
if(!empty($_GET['work_day5'])){$work5 = reverseDate($_GET['work_day5']);}
//основание
if(!empty($_GET['reason'])){$reason1 = $_GET['reason'];}
if(!empty($_GET['reason2'])){$reason2 = $_GET['reason2'];}
if(!empty($_GET['reason3'])){$reason3 = $_GET['reason3'];}
if(!empty($_GET['reason4'])){$reason4 = $_GET['reason4'];}
if(!empty($_GET['reason5'])){$reason5 = $_GET['reason5'];}
$sql = "INSERT INTO calendar(year, extra_work_day, extra_not_work_day, reason)";
if($_GET['check1'] == 1){$sql .= " VALUES('$year1','$work1','$rest1','" . urldecode($reason1) . "')";}
if($_GET['check2'] == 2){$sql .= ", ('$year2','$work2','$rest2','" . urldecode($reason2) . "')";}
if($_GET['check3'] == 3){$sql .= ", ('$year3','$work3','$rest3','" . urldecode($reason3) . "')";}
if($_GET['check4'] == 4){$sql .= ", ('$year4','$work4','$rest4','" . urldecode($reason4) . "')";}
if($_GET['check5'] == 5){$sql .= ", ('$year5','$work5','$rest5','" . urldecode($reason5) . "')";}
$res = sql_q($sql) or die(mysql_error());
if($res){
echo "good";
}else{
echo "bad";
}
?>
<?include("../inc/conf.php");;
if (isset($_GET['asoc_id'])) $asoc_id=$_GET['asoc_id'];
if (isset($_GET['attach_id'])) $attach_id=$_GET['attach_id'];
//if (isset ($_GET['ans_id'])) $ans_id=$_GET['ans_id'];
$rows=mysql_fetch_array(sql_q("SELECT * FROM attached_files WHERE asoc_id='".$_GET['asoc_id']."' AND attach_id = ".$attach_id));
if (is_file($path.$rows['attach_dir'].$rows['attach_filename']))
{
// unlink($path.$rows['attach_dir'].$rows['attach_filename']);
// $sql = "DELETE FROM attached_files WHERE asoc_id=".$asoc_id." AND attach_id = ".$attach_id;
$sql = "UPDATE attached_files SET dell_flag=1 WHERE asoc_id=".$asoc_id." AND attach_id = ".$attach_id;
$res = sql_q($sql);
//$res1=sql_q("UPDATE answers SET attach_id = 0 WHERE attach_id = '".$attach_id."' AND ans_id='".$ans_id."' ");
$delete_flag = 1;
}
else
$delete_flag = 0;
echo $delete_flag;
?>
else {
sql_q("INSERT INTO accounts_municipality (id_accounts, name_accounts, number, iban, bic, bank_name, bank_branch, bank_address, status, main) VALUES('NULL', '$name_accounts', '$number', '$iban', '$bic', '$bank_name', '$bank_branch', '$bank_address', '$status', '$main')");
}
if ($main ==1)
{
sql_q("UPDATE accounts_municipality SET main=0 WHERE id_accounts!='$id_accounts'");
}
?>
<script language="JavaScript">
window.close();
window.opener.location.href="Accounts.php";
</script>
<?
}
$result = sql_q("SELECT * FROM accounts_municipality WHERE id_accounts = '$id_accounts'");
$row = mysql_fetch_array($result);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="bg">
<title>Сметки</title>
<script language="JavaScript" src="JFunctions.js"></script>
</head>
<body background="Images/Stone.jpg" onload="fgroups_data.name.focus()">
<form name="faccounts_data" action="Accounts_data.php?edit_flag=<?=$_GET['edit_flag']?>" method="post">
<table width="100%" height="100%">
<tr valign="top">
<?php
header("Content-Type:text/html; charset=utf-8");
require_once('loader.php');
$sql = "SELECT * FROM `rank` WHERE ac_no =? AND se_no =?";
$ans = sql_q( $sql,array( $_POST['ac_no'],$_POST['se_no']) );
if( count($ans)>0 )
echo json_encode($ans);
else
echo json_encode('未按過評分 !');
array_push( $sql_arr,$url[$i]['showInfo'][0]['location'].$url[$i]['showInfo'][0]['locationName'] );
sql_i($sql,$sql_arr);
echo 'Success !! ';
}
}else{
echo 'Error !! ';
}
}
break;
// parent= 親子活動
//999找到相同陣列不要新增
//998沒有找到相同陣列繼續新增
case 'parent':
$url = json_decode(file_get_contents( "http://cloud.culture.tw/frontsite/trans/SearchShowAction.do?method=doFindTypeJ&category=4" ),true);
$sql_s = "SELECT title FROM data";
$dt = sql_q($sql_s,array());
$sql = "INSERT INTO data (d_no,title,content,lng,lat,type,stime,etime,note,category,address) VALUES (?,?,?,?,?,?,?,?,?,?,?)";
for ($i=0; $i < count($url); $i++) {
if($url[$i]['descriptionFilterHtml']==''){
$pro='999';
}else{
$pro='998';
}
if($pro!='999'){
if(count($url[$i]['showInfo'])!='1'){
for ($y=0; $y < count($url[$i]['showInfo']); $y++) {
$sql_arr = array();
array_push( $sql_arr,'null' );
array_push( $sql_arr,$url[$i]['title'] );
array_push( $sql_arr,$url[$i]['descriptionFilterHtml'] );
array_push( $sql_arr,$url[$i]['showInfo'][$y]['longitude'] );
sql_q("Update municipality set placement ='{$placement}' where placement ='-1'");
sql_q("Update users set placement='{$placement}' where placement=''");
}
?>
<html>
<head><title>Избор на главна община</title></head>
<body>
<form method="post" name="kingdom" action="">
<table><th>Посочете общинския център:</th>
<tr>
<td>
<input type="hidden" name="place_hidd" id="place_hid" />
<select name="placement" id="placement">
<?php
$naselm = "SELECT * FROM elements WHERE nom_code ='06' ORDER BY cod_cod ASC";
//Petko Mihailov-programist Dobaveno vuv vruzka na kasieri s naseleni mesta
$get_code_name = sql_q($naselm);
while ($row2 = mysql_fetch_array($get_code_name)) {
echo "<option value ='" . $row2['cod_cod'] . "'" . $selected . ">" . $row2['cod_name'] . "</option>";
}
?>
</select>
</td><td><input type="submit" value="Запис" name="save" onclick="window.close(); "/></td>
</tr>
</table>
</form>
</body>
</html>
<!--<input type="image" src="Images/RightsUp.gif" onmouseout="this.src='Images/RightsUp.gif'" onmouseover="this.src='Images/RightsDown.gif'" onclick="alert('Правата все още са в процес на разработка!!!'); return false;">-->
<br><br><br><br>
Покажи:
<br><br>
<?
$sql_active = "SELECT COUNT(status)
FROM users
WHERE status = '1'";
$sql_unactive = "SELECT COUNT(status)
FROM users
WHERE status = '0'";
$sql_all = "SELECT COUNT(status)
FROM users";
$res_active = sql_q($sql_active) or die(mysql_error());
$res_unactive = sql_q($sql_unactive) or die(mysql_error());
$res_all = sql_q($sql_all) or die(mysql_error());
$row_active = mysql_fetch_assoc($res_active);
$row_unactive = mysql_fetch_assoc($res_unactive);
$row_all = mysql_fetch_assoc($res_all);
?>
<input type="radio" name="all" id="active" value="1" <? if ($all==1) echo "checked"?> onclick="fusers.submit();">
<label for="active">
Активни
<font color="red"><?php
echo $row_active['COUNT(status)'];
?>
</font>
</label>
<br>
<input type="radio" name="all" id="unactive" value="0" <?if ($all==0) echo "checked"?> onclick="fusers.submit();">
<label for="unactive">
<?php
header("Content-Type:application/json; ");
require_once('loader.php');
$x = ($_POST['lat_1']+$_POST['lat_2'])/2;
$y = ($_POST['lng_1']+$_POST['lng_2'])/2;
$sql = "SELECT *, ( ? * acos( cos( radians(?) ) * cos( radians( lng ) ) *
cos( radians( lat ) - radians(?) ) +
sin( radians(?) ) * sin( radians( lng ) ) ) ) AS distance
FROM data HAVING distance < 10";
$ans = sql_q( $sql ,array('6371',$y,$x,$y) );
$sum = array('map'=>$ans);
echo json_encode($sum);
?>
, <?php
echo $flag;
?>
)">
<table style="width:100%;">
<?
$result = sql_q("SELECT * FROM attached_files WHERE asoc_id = '".$asoc_id."' AND dell_flag=0 ORDER BY attach_timestamp");
$html_options = "Прикачен файл: <a href='".$url.$row['attach_dir'].$row['attach_filename']."' target='_blank'>".$row['attach_filename']."</a>";
echo "<tr><td style='width:20%;' class='header'>Дата/час:</td>
<td style='width:15%;' class='header'>Прикачил:</td>
<td style='width:55%;' class='header'>Файл:</td>
<td style='width:10%;' class='header'>Размер:</td>
<td style='width:10%;' class='header'> </td>";
while ($row=mysql_fetch_array($result)){
$full_name=mysql_fetch_array(sql_q("SELECT full_name FROM users WHERE id='".$row['uploader_id']."'"));
$filesize_in_KB= (int)(($row['filesize'])/1024);
$filesizepr = $filesize_in_KB;
$text = ' KB';
if($filesize_in_KB > 1024){
$filesizepr = (int) ($filesizepr/1024);
$text = ' MB';
}
echo "<tr><td style='width:20%;' class='content'>";
echo $row['attach_timestamp'];
echo "</td>";
echo "<td style='width:15%;' class='content'>".$full_name[0]."</td>";
echo "<td style='width:55%;' class='content'>";
if ($user_workorhome==1)
{ echo "<a href='".$url2.$row['attach_dir'].$row['attach_filename']."' target='_blank'>".$row['attach_filename']."</a>";
case 6:
case 7:
case 8:
sql_q("DELETE FROM single_payments WHERE invoice_id = '{$invoice_id}'");
sql_q("DELETE FROM townsfolk_less WHERE invoice_id = '{$invoice_id}'");
break;
}
}
}
} else {
if ($_POST['home_x']) {
echo "<script language='JavaScript'> top.main_window.location.href='Index.html'; </script>";
}
}
$query = "SELECT invoice_id, payee_mode, payee_identify, doc_state,\n date_format(doc_date, '%d-%m-%Y'), total_amount, pay_mode\n FROM invoices\n WHERE doc_state IN (1, 4)\n AND number = '0' AND date = '0000-00-00'\n AND doc_date BETWEEN '{$from_date}' AND '{$to_date}' \n AND invoice_id NOT IN (SELECT invoice_id FROM rkk WHERE invoice_id>0)\n ORDER BY invoice_id ASC";
$result = sql_q($query);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="bg">
<script language="JavaScript" src="JFunctions.js"></script>
</head>
<body background="Images/Stone.jpg">
<form name="fsingle_invoices" method="post">
<input type="hidden" name="from_date" value="<?php
echo $from_date;
?>
">
<input type="hidden" name="to_date" value="<?php
<?php
require_once('../loader.php');
$sql = "SELECT * FROM accounts WHERE account=? AND password=?";
$profile = sql_q( $sql, array( $_POST['account'],$_POST['password'] ));
if( count($profile)>0 ){
$_SESSION['account'] = $profile[0]['account'];
$_SESSION['name'] = $profile[0]['name'];
$_SESSION['level'] = $profile[0]['level'];
echo "<script language=javascript>
alert('Login Success!!');
window:location.href='./main.php';
</script>";
}else{
echo "<script language=javascript>
alert('Login Fail!!');
window:location.href='./index.php';
</script>";
}
function Interest_calc($year, $month, $contr_id, $date, $flag){
if ($flag==1){
$query=sql_q("select point_interest_percent from municipality");
$row=mysql_fetch_row($query);
$points=$row[0];
$query=sql_q("select * from bnb");
while ($row=mysql_fetch_row($query)){list($key, $val)= $row;$array_interest_rate[$key]=$val;}
$query=sql_q("select month_debt, interest_debt, interest_pay from balances where contr_id=".$contr_id." and year=".$year." and month= ".$month);
$row=mysql_fetch_array($query);
$month_balance=$row['month_debt'];
$interest_debt=round($row['interest_debt'],2);
$interest_pay=$row['interest_pay'];
$pad_date=GetPadDate($year, $month, $contr_id);
$query=sql_q("select count(i.invoice_id) from invoices as i, month_payments as m
where i.invoice_id=m.invoice_id and doc_id=".$contr_id." and m.year=".$year." and m.month=".$month.
" and i.doc_state in (3,7)");
$row=mysql_fetch_row($query);
$count=$row[0];
if ($count!=0){
$query=sql_q("select i.invoice_id, i.doc_date, m.amount from invoices as i, month_payments as m
where i.invoice_id=m.invoice_id and doc_id=".$contr_id." and m.year=".$year." and m.month=".$month." order by doc_date");
$row=mysql_fetch_array($query);
$doc_date= format_date($row['doc_date']);
$date_begin=$pad_date;
if ($row['doc_date']>=format_date($date_begin)){
$intervals[0]=$date_begin.'#'.$doc_date.'#'.$month_balance.'#'.$month_balance.'#0.00';
$date_begin= $doc_date;
if (($month_balance - $row['amount'])<0){$month_balance=0.00;} else {$month_balance=$month_balance - $row['amount'];}
}
else{
$intervals[0]=$doc_date.'#'.$date_begin.'#0.00#'.$month_balance.'#'.$row['amount'];
if (($month_balance - $row['amount'])<0){$month_balance=0.00;} else {$month_balance=$month_balance - $row['amount'];}
}
for ($i=1; $i<=$count; $i++){
if ($i==$count){
$date_end=$date;
$intervals[$i]=$date_begin.'#'.$date_end.'#'.$month_balance;
}
else {
$row=mysql_fetch_array($query);
if ($row['doc_date']>=format_date($date_begin)){
$doc_date= format_date($row['doc_date']);
$intervals[$i]=$date_begin.'#'.$doc_date.'#'.$month_balance.'#'.$month_balance.'#'.$row['amount'];
$intervals_bufer[$i+1]=$intervals[$i];
$date_begin = $doc_date;
if (($month_balance - $row['amount'])<0){$month_balance=0.00;} else {$month_balance=$month_balance - $row['amount'];}
}
else{
$doc_date= format_date($row['doc_date']);
$intervals[$i]=$doc_date.'#'.$date_begin.'#0.00#'.$month_balance.'#'.$row['amount'];
if (($month_balance - $row['amount'])<0){$month_balance=0.00;} else {$month_balance=$month_balance - $row['amount'];}
}
}
}
$interest=array();
for ($i=0;$i<=$count;$i++){
$split=split('[#]',$intervals[$i]);
$split_bufer=split('[#]',$intervals_bufer[$i]);
$difference=$split[3]-$split[4];
$diff_bufer=$split_bufer[3]-$split_bufer[4];
$interest[$i]=GetInterest($split[0],$split[1],$split[2] ,$array_interest_rate, $points,$flag);
if (is_string($interest[$i])){$interest=array();break;}
}
if (!(empty($interest))){
$array[0]= array_sum($interest);
if ($array[0] <= $interest_pay) {$array[0] = $interest_pay;}
}
}
else {$array[0]=GetInterest($pad_date,$date,$month_balance ,$array_interest_rate, $points,$flag);}
$array[1]=$pad_date;
$array[2]=$interest_debt;
$array[3]=$interest_pay;
return $array;
}
else{// Флаг != 1 представя функцията с визуализиращи редове
$query=sql_q("select point_interest_percent from municipality");
$row=mysql_fetch_row($query);
$points=$row[0];
$query=sql_q("select * from bnb");
while ($row=mysql_fetch_row($query)){list($key, $val)= $row;$array_interest_rate[$key]=$val;}
$query=sql_q("select month_debt, interest_debt, interest_pay from balances where contr_id=".$contr_id." and year=".$year." and month= ".$month);
$row=mysql_fetch_array($query);
$month_balance=$row['month_debt'];
$interest_debt=round($row['interest_debt'],2);
$interest_pay=$row['interest_pay'];
$pad_date=GetPadDate($year, $month, $contr_id);
$query=sql_q("select count(i.invoice_id) from invoices as i, month_payments as m
where i.invoice_id=m.invoice_id and doc_id=".$contr_id." and m.year=".$year." and m.month=".$month.
" and i.doc_state in (3,7)");
$row=mysql_fetch_row($query);
$count=$row[0];
//echo ' Платени фактури за месец '.NameOfMonth($month).' '.$year.' год. : <b>'.$count.'</b><br>----------------------------------------------------------------<br>';
if ($count!=0){
$query=sql_q("select i.invoice_id, i.doc_date, m.amount from invoices as i, month_payments as m
where i.invoice_id=m.invoice_id and doc_id=".$contr_id." and m.year=".$year." and m.month=".$month." order by doc_date");
$row=mysql_fetch_array($query);
$doc_date= format_date($row['doc_date']);
$date_begin=$pad_date;
if ($row['doc_date']>=format_date($date_begin)){
$intervals[0]=$date_begin.'#'.$doc_date.'#'.$month_balance.'#'.$month_balance.'#'.$row['amount'];
$intervals_bufer[1]=$intervals[0];
$date_begin= $doc_date;
if (($month_balance - $row['amount'])<0){$month_balance=0.00;} else {$month_balance=$month_balance - $row['amount'];}
}
else{
$intervals[0]=$doc_date.'#'.$date_begin.'#0.00#'.$month_balance.'#'.$row['amount'];
if (($month_balance - $row['amount'])<0){$month_balance=0.00;} else {$month_balance=$month_balance - $row['amount'];}
}
for ($i=1; $i<=$count; $i++){
if ($i==$count){
$date_end=$date;
$intervals[$i]=$date_begin.'#'.$date_end.'#'.$month_balance;
}
else {
$row=mysql_fetch_array($query);
if ($row['doc_date']>=format_date($date_begin)){
$doc_date= format_date($row['doc_date']);
$intervals[$i]=$date_begin.'#'.$doc_date.'#'.$month_balance.'#'.$month_balance.'#'.$row['amount'];
$intervals_bufer[$i+1]=$intervals[$i];
$date_begin = $doc_date;
if (($month_balance - $row['amount'])<0){$month_balance=0.00;} else {$month_balance=$month_balance - $row['amount'];}
}
else{
$doc_date= format_date($row['doc_date']);
$intervals[$i]=$doc_date.'#'.$date_begin.'#0.00#'.$month_balance.'#'.$row['amount'];
if (($month_balance - $row['amount'])<0){$month_balance=0.00;} else {$month_balance=$month_balance - $row['amount'];}
}
}
}
$interest=array();
$j=0;
for ($i=0;$i<=$count;$i++)
{
$split=split('[#]',$intervals[$i]);
$split_bufer=split('[#]',$intervals_bufer[$i]);
if (($split[3]-$split[4])<0){$difference=0.00;}
else {$difference=$split[3]-$split[4];}
if(($split_bufer[3]-$split_bufer[4])<0){$diff_bufer=0.00;}
else {$diff_bufer=$split_bufer[3]-$split_bufer[4];}
if ((format_date($split[0])==format_date($pad_date)) && ($j==0))
{
echo '<b><font color="DarkSeaGreen" size="4">Падежна дата : </font><font color="red" size="4">'.$split[0].'</font></b> ';
$j++;
}
else if((format_date($split[0])==format_date($pad_date)) && ($j!=0))
{
echo 'Фактура от дата : <font color="red" size="4"> <b>'.$split[0].'</b></font> Начално салдо : <b>'.Add_Fraction_Part($split_bufer[3]).
'</b> лв. Плащане : <b>'.$split_bufer[4].'</b> лв. Крайно салдо : <b>'.Add_Fraction_Part($diff_bufer).'</b> лв.<br>';
}
else if(format_date($split[0])<format_date($pad_date))
{
echo 'Фактура от дата : <font color="red" size="4" > <b>'.$split[0].'</b></font> Начално салдо : <b>'.Add_Fraction_Part($split[3]).
'</b> лв. Плащане : <b>'.$split[4].'</b> лв. Крайно салдо : <b>'.Add_Fraction_Part($difference).'</b> лв.<br>';
}
else
{
echo 'Фактура от дата : <font color="red" size="4"> <b>'.$split[0].'</b></font> Начално салдо : <b>'.Add_Fraction_Part($split_bufer[3]).
'</b> лв. Плащане : <b>'.$split_bufer[4].'</b> лв. Крайно салдо : <b>'.Add_Fraction_Part($diff_bufer).'</b> лв.<br>';
}
if(format_date($split[0])>=format_date($pad_date))
{
$interest[$i]=GetInterest($split[0],$split[1],$split[2] ,$array_interest_rate, $points, $flag);
}
//if (is_string($interest[$i])){$interest=array();break;}
}
echo '<b><font color="DarkSeaGreen" size="4"> Работна дата : </font><font color="red" size="4">'.$date.'</font><br></b>';
if (!(empty($interest)))
{
$array[0]= Add_Fraction_Part_4(array_sum($interest));
if ($array[0] < $interest_pay)
{
echo 'Тъй като изчислената лихва: <b>'.$array[0].'</b> е по-малка от платената посредством
платежни документи лихва: <b>'.$interest_pay.'</b>, то функцията връща стойността на платената лихва !!!
<br>';
$array[0] = $interest_pay;
}
}
}
else {
echo '<b><font color="DarkSeaGreen" size="4">Падежна дата : </font><font color="red" size="4">'.$pad_date.'</font></b>';
$array[0]=GetInterest($pad_date,$date,$month_balance ,$array_interest_rate, $points, $flag);++$k;
echo '<b><font color="DarkSeaGreen" size="4">Работна дата : </font><font color="red" size="4">'.$date.'</font></b><br>';
}
$array[1]=$pad_date;
$array[2]=$interest_debt;
$array[3]=$interest_pay;
?>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#eeeeee" style="position:relative" style="left:48.8%">
<tr>
<td align="right" width="250" bgcolor="DarkSeaGreen"><b><font color="white" size="5"> Изчислената лихва е :</font></b></td>
<th width="120" bgcolor="DarkSeaGreen"><font color="red" size="5"><?echo $array[0]?></font></th>
</tr>
<?
return $array;
}
}
<?php
include "../../inc/conf.php";
if ($_POST['delete_x']) {
$id = $_POST['data'];
sql_q("DELETE FROM mayors WHERE id = '{$id}'");
// sql_q("DELETE FROM group_users WHERE user_id = '$user_id'");
}
//else if ($_POST["home_x"]) {
// echo "<script language='JavaScript'> top.main_window.location.href='.php'; </script>";
// }
$result = sql_q("SELECT ifmayor FROM municipality;");
$row = mysql_fetch_array($result);
$res_ifmayor = sql_q("SELECT * FROM elements WHERE nom_code = '66' and cod_cod='" . $row['ifmayor'] . "'");
$row_ifmayor = mysql_fetch_assoc($res_ifmayor);
$ifmayor = $row_ifmayor['cod_name'];
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="bg">
<title>Данни - <?php
echo $ifmayor;
?>
</title>
<script language="JavaScript" src="../JFunctions.js"></script>
</head>
<body background="../Images/Stone.jpg" scroll="no">
<form name="fmayors" action="Mayors.php" method="post">
$max = $_POST['max_function_id'] + 1;
for ($i = 1; $i < $max; $i++) {
if ($_POST['function_id' . $i] == 'on') {
sql_q("INSERT INTO permissions (id, module_id, group_id, function_id, read_access) VALUES('NULL', '{$module_id}', '{$group_id}', '{$i}', 'Y')");
}
}
$max = $_POST['min_permission_id'];
$max = $_POST['max_permission_id'] + 1;
for ($i = $min; $i < $max; $i++) {
if ($_POST['permission_id' . $i] == 'on') {
sql_q("DELETE FROM permissions WHERE id = '{$i}'");
}
}
}
$functions_id = array();
$result = sql_q("SELECT f.function_id FROM functions f, permissions p\n WHERE f.module_id = p.module_id AND f.function_id = p.function_id\n AND f.status = '1' AND p.group_id = '{$group_id}' AND f.module_id = '{$module_id}'");
while ($row = mysql_fetch_array($result)) {
array_push($functions_id, $row['function_id']);
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="bg">
<title>Права</title>
<script language="JavaScript" src="JFunctions.js"></script>
</head>
<body background="Images/Stone.jpg" scroll="yes">
<form name="fgroup_permissions" action="GroupPermissions.php?group_data=<?php
<?
include("../../inc/conf.php");
$interest_mode = $_GET['interest_mode'];
$variant = array('1' => 'А', '2' => 'Б', '3' => 'В', '4' => 'Г');
if (isset($_POST['submit']))
{
//echo "UPDATE municipality SET interest_mode = '$interest_mode'";
sql_q("UPDATE municipality SET interest_mode = '$interest_mode'");
echo "<script language='JavaScript'> window.close(); window.opener.location.reload();</script>";
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<meta http-equiv="Content-Language" content="bg">
<title>Изчисление на лихва</title>
</head>
<body background="../Images/Stone.jpg">
<form name="finterest" method="post" action="CalcInterest.php?interest_mode=<?echo $interest_mode?>">
<table width="100%" height="100%">
<tr valign="top">
<td height="90%">
<table width="100%" border="0">
<tr>
<td>
<fieldset>
<legend>Изчисление на лихвата ще се извършва по <b>Вариант <?php
<?php
header("Content-Type:text/html; charset=utf-8");
require_once 'loader.php';
$sql = "SELECT * FROM rank WHERE ac_no=? AND se_no =?";
$ans_count = count(sql_q($sql, array($_POST['ac_no'], $_POST['se_no'])));
if ($ans_count == '0') {
$sql = "INSERT INTO `rank`(`rank_no`, `ac_no`, `se_no`, `score`) VALUES (?,?,?,?)";
$ans = sql_i($sql, array('null', $_POST['ac_no'], $_POST['se_no'], $_POST['score']));
} else {
$sql = "UPDATE rank SET score =? WHERE ac_no=? AND se_no =?";
$ans = sql_i($sql, array($_POST['score'], $_POST['ac_no'], $_POST['se_no']));
}
if ($ans) {
echo json_encode(array($_POST['score']));
} else {
echo json_encode('增加分數失敗 !');
}
<table id="table" width=600px border="0" cellspacing="0" cellpadding="0">
<?
for ($i = 0; $i < $counti; $i++) {
?>
<tr>
<?
$temp = sql_q("SELECT * FROM ranges WHERE nom_cod=".$rangesarr[$i]) ;
$rangeout = mysql_fetch_array($temp);
?>
<td class="bottom" colspan="2">
<font size="3" color="#0000FF"><?echo $rangeout[1]?></font>
</td>
</tr>
<tr>
<?
$res = sql_q("SELECT cod_cod, cod_name FROM elements WHERE nom_code=".$rangesarr[$i]);
for($j = 0; $j < mysql_num_rows($res); $j++) {
$r = mysql_fetch_array($res);
?>
<td class="bottom" align="right" width="50px"><?echo $r[0];?> </td>
<td class="left_bottom" width="550px"> <?echo $r[1];?></td>
</tr>
<?
}
}
?>
</table>
</body>
</html>
function displayContractsActivity()
{
if ($_POST['action'] == 'save') {
$result = $this->saveContractsActivity();
}
$this->getFinishedContracts();
$content_html = "";
$content_html .= "<HTML>";
$content_html .= "<HEAD>";
$content_html .= "<META http-equiv = 'content-type' content = 'text/html; charset:WINDOWS-1251;'>";
$content_html .= "<TITLE>Задаване активност на договори</TITLE>";
$content_html .= "</HEAD>";
$content_html .= "<SCRIPT language = 'JavaScript' src = '../JFunctions.js'></SCRIPT>";
$content_html .= "<SCRIPT language = 'JavaScript'>";
$content_html .= "function ShowContracts(object)";
$content_html .= "{";
$content_html .= "document.forms[\"fcontracts_activity\"].elements[\"contr_mode\"].value = object.value;";
$content_html .= "document.forms[\"fcontracts_activity\"].elements[\"action\"].value = \"view\";";
$content_html .= "document.forms[\"fcontracts_activity\"].submit();";
$content_html .= "}";
$content_html .= "function doCheckAll(check_status, form_name, action_name)";
$content_html .= "{";
$content_html .= "elements = document.forms[form_name].elements;";
$content_html .= "for(i = 0; i < elements.length; i++)";
$content_html .= "{";
$content_html .= "if(elements[i].name == action_name && elements[i].disabled == false)";
$content_html .= "{elements[i].checked = check_status;}";
$content_html .= "}";
$content_html .= "}";
$content_html .= "</SCRIPT>";
$content_html .= "<BODY background = '../Images/Stone.jpg'>";
$content_html .= "<form name = 'fcontracts_activity' action = 'ContractsActivity.php' method = 'post'>";
$content_html .= "<input type = 'hidden' name = 'contr_mode' value = '" . $this->params['contr_mode'] . "'>";
$content_html .= "<input type = 'hidden' name = 'action' value = '" . $this->params['action'] . "'>";
$content_html .= "<table width = '100%' height = '98%' cellpadding = '0' cellspacing = '0' align = 'center'>";
$content_html .= "<tr><td width = '100%' align = 'center'>";
$content_html .= "<span style = 'font-weight:bold; font-size:16px; color:blue;'>Активност за договори тип </span>";
$content_html .= "<select name = 'contr_mode_select' style = 'text-align:center;' onChange = 'ShowContracts(this);'>";
$content_html .= "<option value = '0'> </option>";
$contr_mode_query = "SELECT * FROM elements where nom_code = '07'";
$contr_mode_result = sql_q($contr_mode_query);
while ($contr_mode_row = mysql_fetch_assoc($contr_mode_result)) {
$contr_mode_cod = $contr_mode_row['cod_cod'];
$contr_mode_name = $contr_mode_row['cod_name'];
$content_html .= "<option value = '" . $contr_mode_cod . "'";
if ($contr_mode_cod == $this->params['contr_mode']) {
$content_html .= " selected ";
}
$content_html .= ">" . $contr_mode_name . "</option>";
}
$content_html .= "</select>";
$content_html .= "</td></tr>";
$content_html .= "<tr><td width = '100%' height = '85%' align = 'center'>";
$content_html .= $this->displayActiveContracts();
$content_html .= "<BR><BR><BR>";
$content_html .= $this->displayInactiveContracts();
$content_html .= "</td></tr>";
$content_html .= "<tr><td width = '100%' align = 'right'>";
$content_html .= "<img src = '../Images/Add.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"fcontracts_activity\"].elements[\"action\"].value = \"save\"; document.forms[\"fcontracts_activity\"].submit();'>";
$content_html .= "<img src = '../Images/Home.gif' style = 'cursor:pointer;' onclick = 'window.location.href = \"../Index.html\"'>";
$content_html .= "</td></tr>";
$content_html .= "</table>";
$content_html .= "</form>";
$content_html .= "</BODY>";
$content_html .= "</HTML>";
echo "" . $content_html;
}
<?php
header("Content-Type:application/json; ");
require_once('loader.php');
$ans = sql_q("SELECT * FROM post" ,array());
$sum = array('map'=>$ans);
echo json_encode($sum);
function displayInvoiceRanges()
{
if ($_POST['action'] == 'save') {
$result = $this->saveInvoiceRange();
} else {
if ($_POST['action'] == 'delete') {
$result = $this->deleteInvoiceRange();
}
}
$this->getInvoiceRanges();
$content_html = "";
$content_html .= "<HTML>";
$content_html .= "<HEAD>";
$content_html .= "<META http-equiv = 'content-type' content = 'text/html; charset:WINDOWS-1251;'>";
$content_html .= "<TITLE>Запазване на диапазон</TITLE>";
$content_html .= "</HEAD>";
$content_html .= "<SCRIPT language = 'JavaScript' src = '../JFunctions.js'></SCRIPT>";
$content_html .= "<SCRIPT language = 'JavaScript'>";
$content_html .= "function ShowRanges(object)";
$content_html .= "{";
$content_html .= "document.forms[\"finvoice_ranges\"].elements[\"doc_type\"].value = object.value;";
$content_html .= "document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"view\";";
$content_html .= "document.forms[\"finvoice_ranges\"].submit();";
$content_html .= "}";
$content_html .= "</SCRIPT>";
$content_html .= "<BODY background = '../Images/Stone.jpg' onload = 'document.forms[\"finvoice_ranges\"].elements[\"doc_type_select\"].focus();'>";
$content_html .= "<form name = 'finvoice_ranges' action = 'InvoiceRangeManager.php' method = 'post'>";
$content_html .= "<input type = 'hidden' name = 'doc_type' value = '" . $this->params['doc_type'] . "'>";
$content_html .= "<input type = 'hidden' name = 'action' value = '" . $this->params['action'] . "'>";
$content_html .= "<input type = 'hidden' name = 'range_id' value = '" . $this->params['range_id'] . "'>";
$content_html .= "<input type = 'hidden' name = 'range_start_num' value = '" . $this->params['range_start_num'] . "'>";
$content_html .= "<input type = 'hidden' name = 'range_end_num' value = '" . $this->params['range_end_num'] . "'>";
$content_html .= "<input type = 'hidden' name = 'range_doc_type' value = '" . $this->params['range_doc_type'] . "'>";
$content_html .= "<table width = '100%' height = '98%' cellpadding = '0' cellspacing = '0' align = 'center'>";
$content_html .= "<tr><td width = '100%' align = 'center'>";
$content_html .= "<span style = 'font-weight:bold; font-size:16px; color:blue;'>Запазени номера за </span>";
$content_html .= "<select name = 'doc_type_select' style = 'text-align:center;' onChange = 'ShowRanges(this);'>";
$content_html .= "<option value = '0'> </option>";
$pay_doc_query = "SELECT * FROM pay_documents";
$pay_doc_result = sql_q($pay_doc_query);
while ($pay_doc_row = mysql_fetch_assoc($pay_doc_result)) {
$pay_name = $pay_doc_row['name'];
$pay_doc_type = $pay_doc_row['doc_type'];
$pay_last_numb = $pay_doc_row['last_numb'];
$pay_status = $pay_doc_row['status'];
if ($pay_status == 'active') {
$content_html .= "<option value = '" . $pay_doc_type . "'";
if ($pay_doc_type == $this->params['doc_type']) {
$content_html .= " selected ";
}
$content_html .= ">" . $pay_name . " - " . $pay_last_numb . "</option>";
}
}
$content_html .= "</select>";
$content_html .= "</td></tr>";
$content_html .= "<tr><td width = '100%' height = '85%' align = 'center'>";
$content_html .= "<div style = 'width:700px; height:300px; overflow-y:scroll; border-style:solid; border-width:1; border-color:DarkSeaGreen;'>";
$content_html .= "<table style = 'width:100%; border-style:solid; border-width:1; border-color:DarkSeaGreen;'>";
$content_html .= "<tr>";
$content_html .= "<td style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; color:red;' align = 'center' color = 'red'>";
$content_html .= "№";
$content_html .= "</td>";
$content_html .= "<td style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; color:red;' align = 'center' color = 'red'>";
$content_html .= "Начален номер";
$content_html .= "</td>";
$content_html .= "<td style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; color:red;' align = 'center' color = 'red'>";
$content_html .= "Краен номер";
$content_html .= "</td>";
$content_html .= "<td style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; color:red;' align = 'center' color = 'red'>";
$content_html .= " ";
$content_html .= "</td>";
$content_html .= "</tr>";
$ranges_array = $this->invoice_ranges_array[$this->params['doc_type']];
$last_numb = $ranges_array['last_numb'];
$doc_type_name = $ranges_array['name'];
$doc_type_status = $ranges_array['status'];
if (!empty($ranges_array[0])) {
foreach ($ranges_array as $key => $value) {
if (!is_array($value)) {
continue;
}
$content_html .= "<tr>";
$content_html .= "<td style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; color:blue;' align = 'center'>";
$content_html .= "" . $value['range_id'];
$content_html .= "</td>";
$content_html .= "<td style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; color:blue;' align = 'center'>";
$content_html .= "" . $value['range_start_num'];
$content_html .= "</td>";
$content_html .= "<td style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; color:blue;' align = 'center'>";
$content_html .= "" . $value['range_end_num'];
$content_html .= "</td>";
$content_html .= "<td style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; color:blue;' align = 'center'>";
$content_html .= "<input type = 'radio' name = 'edit_info'\n onClick = 'document.forms[\"finvoice_ranges\"].elements[\"range_id\"].value = \"" . $value['range_id'] . "\";\n document.forms[\"finvoice_ranges\"].elements[\"range_start_num\"]. value = \"" . $value['range_start_num'] . "\";\n document.forms[\"finvoice_ranges\"].elements[\"range_end_num\"].value = \"" . $value['range_end_num'] . "\";\n document.forms[\"finvoice_ranges\"].elements[\"range_doc_type\"].value = \"" . $value['range_doc_type'] . "\"'>";
$content_html .= "</td>";
$content_html .= "</tr>";
}
} else {
$content_html .= "<tr>";
$content_html .= "<td colspan = '4' style = 'border-style:solid; border-width:1; border-color:DarkSeaGreen; font-weight:bold; font-size:14px; color:red;' align = 'center'>";
$content_html .= "Няма резервирани номера за този кочан.";
$content_html .= "</td>";
$content_html .= "</tr>";
}
$content_html .= "</table>";
$content_html .= "</div>";
if (!empty($this->params['doc_type'])) {
switch ($this->params['action']) {
case "new":
$content_html .= $this->displayAddNewForm();
break;
case "update":
$content_html .= $this->displayUpdateForm();
break;
case "save":
case "delete":
if ($result['result'] === false) {
$content_html .= "<BR><BR>ГРЕШКА! " . $result['reason'];
} else {
if ($result['result'] === true) {
$content_html .= "<BR><BR>ОК! " . $result['reason'];
}
}
break;
}
}
$content_html .= "</td></tr>";
$content_html .= "<tr><td width = '100%' align = 'right'>";
switch ($this->params['action']) {
case 'view':
case 'save':
case 'delete':
if ($this->params['doc_type'] != 0) {
$content_html .= "<img src = '../Images/Insert.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"new\"; document.forms[\"finvoice_ranges\"].submit();'>";
$content_html .= "<img src = '../Images/Edit.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"update\"; document.forms[\"finvoice_ranges\"].submit();'>";
$content_html .= "<img src = '../Images/Delete.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"delete\"; document.forms[\"finvoice_ranges\"].submit();'>";
}
break;
case 'new':
$content_html .= "<img src = '../Images/Add.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"save\"; document.forms[\"finvoice_ranges\"].submit();'>";
$content_html .= "<img src = '../Images/Edit.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"update\"; document.forms[\"finvoice_ranges\"].submit();'>";
$content_html .= "<img src = '../Images/Delete.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"delete\"; document.forms[\"finvoice_ranges\"].submit();'>";
break;
case 'update':
$content_html .= "<img src = '../Images/Add.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"save\"; document.forms[\"finvoice_ranges\"].submit();'>";
$content_html .= "<img src = '../Images/Insert.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"new\"; document.forms[\"finvoice_ranges\"].submit();'>";
$content_html .= "<img src = '../Images/Delete.gif' style = 'cursor:pointer;' onclick = 'document.forms[\"finvoice_ranges\"].elements[\"action\"].value = \"delete\"; document.forms[\"finvoice_ranges\"].submit();'>";
break;
}
$content_html .= "<img src = '../Images/Home.gif' style = 'cursor:pointer;' onclick = 'window.location.href = \"../Index.html\"'>";
$content_html .= "</td></tr>";
$content_html .= "</table>";
$content_html .= "</form>";
$content_html .= "</BODY>";
$content_html .= "</HTML>";
echo "" . $content_html;
}
на "Столична община".<br/>
Разработил: "Брайт Комплекс АТ" ЕООД.
</center>
</font>
</h3>
<center>
Моля, изберете модула, с който желаете да работите.
</center>
<form action="Modules.php" method="post" target="_top">
<table width="100%" height="35%" border="0" valign="middle">
<tr>
<td>
<table width="260px" border="1" align="center">
<th bgcolor="#629C73"><font color="#FFFFFF">Достъпни модули:</font></th>
<?
$result = sql_q("SELECT id, name FROM modules WHERE status = '1'");
while ($row = mysql_fetch_array($result)) {
if (in_array($row['id'], $modules_id)) {
echo "<tr>";
echo "<td align='left'><input type='radio' name='module' id='" . $row['name'] . "' value='".$row['id']."'><b><label for='" . $row['name'] . "'>".$row['name']."</label></b></td>";
echo "</tr>";
}
}
mysql_free_result($result);
mysql_close($connect);
//echo $result;
?>
</table>
<br/>
<div align="center">
<input type="image" name="confirm" src="Images/ConfirmUp.gif" onmouseout="this.src='Images/ConfirmUp.gif'" onmouseover="this.src='Images/ConfirmDown.gif'">
<br/>
<br/>
<br/>
<br/>
<br/>
<?php
$sqlActive = "SELECT COUNT(name) \n\t\t\t\t FROM groups \n\t\t\t\t WHERE status = '1'";
$resActive = sql_q($sqlActive) or die(mysql_error());
$rowActive = mysql_fetch_assoc($resActive);
//
$sqlUnActive = "SELECT COUNT(name) \n\t\t\t\t\tFROM groups \n\t\t\t\t\tWHERE status = '0'";
$resUnActive = sql_q($sqlUnActive) or die(mysql_error());
$rowUnActive = mysql_fetch_assoc($resUnActive);
//
$sqlAll = "SELECT COUNT(name) \n\t\t\t FROM groups";
$resAll = sql_q($sqlAll) or die(mysql_error());
$rowAll = mysql_fetch_assoc($resAll);
echo "Активни: <font color='red'>" . $rowActive['COUNT(name)'] . "</font><br/>";
echo "Неактивни: <font color='red'>" . $rowUnActive['COUNT(name)'] . "</font><br/>";
echo "Общо: <font color='red'>" . $rowAll['COUNT(name)'] . "</font><br/>";
?>
</td>
</tr>
</table>
</fieldset>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="bottom">
*
* $get_kv_name_q = sql_q("SELECT cod_name FROM elements WHERE nom_code ='".$nom_code_k."' AND cod_cod='".$cod_cod_k."';");
* $kvartal = mysql_fetch_array($get_kv_name_q);
* $kvar = ", ".$kvartal['cod_name'];
*
* $get_nas_name_q = sql_q("SELECT cod_name FROM elements WHERE nom_code ='".$nom_code_n."' AND cod_cod='".$cod_cod_n."';");
* $nasel_arr = mysql_fetch_array($get_nas_name_q);
* $nasel =", Нас.място ".$nasel_arr['cod_name'];
*
* $get_jk_name_q = sql_q("SELECT cod_name FROM elements WHERE nom_code ='".$nom_code_jk."' AND cod_cod='".$cod_cod_jk."';");
* $jk_arr = mysql_fetch_array($get_jk_name_q);
* $jk = ", ".$jk_arr['cod_name'];
*
*/
$get_asoc_type = sql_q("SELECT cod_cod, cod_name FROM elements WHERE nom_code ='06' and cod_cod ='".$row['predmet']."'");
$get_t =mysql_fetch_array($get_asoc_type);
$type = $get_t['cod_name'];
$sql_srok = "SELECT * FROM elements WHERE nom_code = '53' AND cod_cod='".$row['srok']."'";
$getsrok = mysql_query($sql_srok) or die(mysql_error());
$row_srok = mysql_fetch_assoc($getsrok);
$srok = $row_srok['cod_name'];
/**
* $street ='';
* if($row['street']!=''){
* $street = ", ул. ".$row['street'];
* }
*/
echo "<tr>";
echo "<td class='left_bottom' width='5px' align='center'> ".$i."</td>";
while ($row = mysql_fetch_array($result)) {
?><option value="<?php
echo $row['nom_cod'];
?>
"><?php
echo $row['nom_name'];
?>
</option>
<?
}
?>
<form>
</select>
<hr>
<?
$result = sql_q("SELECT * FROM rights WHERE user_name ='$user_name'");
$row_rights = mysql_fetch_array($result);
if ($row_rights["right_func"] != 2) {
?>
<center><input type="button" value="Номенклатури" onclick="OpenWindow()"></center><?
} else {
?><center><input type="button" value="Номенклатури" disabled>
<?
}
?>
<input name="back" type="button" value="Назад" onclick="window.location.href='../Administrative/index.html'">
</center>
</form>
</body>
</html>
<td class="left_bottom" colspan="9"style="border:1px solid red">
<table cellspacing="0" cellpadding="0" border="1" width="100%"><tr>
<tr><td class="left_bottom" colspan=""><b>Договори на сдружение №' . $row['asoc_numb'] . '</b></td></tr>
<td>№договор</td>
<td>От дата</td>
<td>Статус</td>
</tr>';
echo "</td>";
echo "</tr>";
$get_contr = sql_q("SELECT * FROM documents WHERE `type_flag`=50 AND asoc_id='" . $row['id'] . "'");
$incr = 0;
while ($contr_data = mysql_fetch_array($get_contr)) {
$incr++;
echo "<tr>";
echo "<td class='left_bottom'>Дог." . $incr . "-№" . $contr_data['number'] . "</td>";
$get_status = sql_q("SELECT cod_cod, cod_name FROM elements WHERE nom_code ='50' and cod_cod ='" . $contr_data['status'] . "'");
$get_stat = mysql_fetch_array($get_status);
$st = $get_stat['cod_name'];
// echo "<td class='left_bottom' width='160px' align='center'> ".$st."</td>";
echo "<td class='left_bottom'>От дата:" . $contr_data['theirs_date'] . "</td>";
echo "<td class='left_bottom'>Статус:" . $st . "</td>";
echo "</tr>";
}
echo "</table>";
//echo $query;
}
?>
</table>
<font size="-2">Справката е генерирана от система Брайт РЕГЕС&ПРОГЕС на фирма "Брайт Комплекс АТ" ЕООД.</font>
<form name="xls" id="xls" method="post" action="InquireContrxls.php">
$jk_ar = explode("~", $row['jk']);
$nom_code_jk = $jk_ar[0];
$cod_cod_jk = $jk_ar[1];
$get_raion = sql_q("SELECT region_name FROM regions WHERE show_cod ='" . $row['raion'] . "'");
$get_ra = mysql_fetch_array($get_raion);
$ra = $get_ra['region_name'];
$get_kv_name_q = sql_q("SELECT cod_name FROM elements WHERE nom_code ='" . $nom_code_k . "' AND cod_cod='" . $cod_cod_k . "';");
$kvartal = mysql_fetch_array($get_kv_name_q);
$kvar = $kvartal['cod_name'];
$get_nas_name_q = sql_q("SELECT cod_name FROM elements WHERE nom_code ='" . $nom_code_n . "' AND cod_cod='" . $cod_cod_n . "';");
$nasel_arr = mysql_fetch_array($get_nas_name_q);
$nasel = $nasel_arr['cod_name'];
$get_jk_name_q = sql_q("SELECT cod_name FROM elements WHERE nom_code ='" . $nom_code_jk . "' AND cod_cod='" . $cod_cod_jk . "';");
$jk_arr = mysql_fetch_array($get_jk_name_q);
$jk = $jk_arr['cod_name'];
$get_status = sql_q("SELECT cod_cod, cod_name FROM elements WHERE nom_code ='05' and cod_cod ='" . $row['status'] . "'");
$get_stat = mysql_fetch_array($get_status);
$st = $get_stat['cod_name'];
echo "<tr>";
echo "<td class='left_bottom' width='10px' align='center'>" . $i . "</td>";
echo "<td class='left_bottom' width='70px' align='center'>" . $row['date'] . "</td>";
echo "<td class='left_bottom' width='85px' align='center'>" . $row['build_identify'] . "</td>";
echo "<td class='left_bottom' width='85px' align='center'> " . $ra . "</td>";
echo "<td class='left_bottom' width='85px' align='center'> " . $nasel . "</td>";
echo "<td class='left_bottom' width='85px' align='center'> " . $kvar . "</td>";
echo "<td class='left_bottom' width='85px' align='center'> " . $jk . "</td>";
echo "<td class='left_bottom' width='85px' align='center'> " . $row['build_numb'] . "</td>";
echo "<td class='left_bottom' width='85px' align='center'> " . $row['asoc_name'] . "</td>";
echo "<td class='left_bottom' width='85px' align='center'> " . $row['asoc_numb'] . "</td>";
echo "<td class='left_bottom' width='85px' align='center'> " . $row['bulstat'] . "</td>";
echo "<td class='left_bottom' width='60px' align='center'> " . $row['number'] . "</td>";
<input type="hidden" name="data">
<table width="100%" border="1">
<tr>
<td width="20px" align="center">№</td>
<td width="250px" align="center">Наименование</td>
<td width="116px" align="center">Номер(сметкоплан)</td>
<td width="250px" align="center">IBAN</td>
<td width="90px" align="center">Състояние</td>
<td width="14"> </td>
</tr>
<tr>
<td colspan="7">
<div style="height:280px; overflow-y:scroll;">
<table width="100%">
<?$i=0;
$result = sql_q("SELECT * FROM accounts_municipality ORDER BY id_accounts ");
$buttons_flag = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {
$i++;
//echo $row['id_accounts']
?>
<tr onMouseOver="LmOverOut('faccounts', this, <? echo $row['id_accounts']?>, '#33CC00', '66FFFF')"
onMouseOut="LmOverOut('faccounts', this, <? echo $row['id_accounts']?>, '', '#66FFFF')" onMouseDown="LmDown('faccounts', <? echo $row['id_accounts']?>, this)">
<td width="18px"><? echo $i?></td>
<td width="256px"><? echo $row['name_accounts']?></td>
<td width="125px"><? echo $row['number']?></td>
<td width="235px"><? echo $row['iban']?></td>
<?
if (empty($row['status'])) {
$status = "Неактивна";
<?
session_start();
include("../inc/conf.php");
if (isset($_GET['asoc_id'])) $asoc_id=$_GET['asoc_id'];
$sql="SELECT count(attach_id) as nums FROM attached_files WHERE asoc_id=".$_GET['asoc_id']." AND dell_flag=0";
$num_rows=mysql_fetch_array(sql_q($sql));
echo $num_rows['nums'];
?>
$month_next=$row_next['month'];
$fb_next=$row_next['first_balance'];
$md_next=$row_next['month_debt'];
$mp_next=$row_next['month_pay'];
$id_next=$row_next['interest_debt'];
$ip_next=$row_next['interest_pay'];
$fd_next=$row_next['forfeit_debt'];
$fp_next=$row_next['forfeit_pay'];
$fb_next=$row_next['final_balance'];
$pa_next=$row_next['prepay_amount'];
}
else
{
$res_next_b=sql_q("SELECT * FROM balances WHERE contr_id='$contr_id' AND year='$year' AND month='$month' ");
$row_next_b=mysql_fetch_array($res_next_b);
$year_next=$row_next_b['year'];
$month_next=$row_next_b['month'];
$fb_next=$row_next_b['first_balance'];
$md_next=$row_next_b['month_debt'];
$mp_next=$row_next_b['month_pay'];
$id_next=$row_next_b['interest_debt'];
$ip_next=$row_next_b['interest_pay'];
$fd_next=$row_next_b['forfeit_debt'];
$fp_next=$row_next_b['forfeit_pay'];
$fb_next=$row_next_b['final_balance'];
$pa_next=$row_next_b['prepay_amount'];
}
