<?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']; }