Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage_22222/plan/ drwxr-xr-x |
Viewing file: RepPlanSum_bkp.php (80.21 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | <?php session_start(); if (session_is_registered("valid_user") && session_is_registered("Priority") ) { include("../include/FunctionDB.php"); include("admin_menu.php"); ConnectDB(); $Username = $valid_user; $sql = " SELECT * FROM user_tb WHERE Username='$Username' "; $result = mysql_query($sql) ; $rs1 = mysql_fetch_array($result); $row = mysql_num_rows($result); $sql1 = " SELECT * FROM project_tb WHERE Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) ; $rs = mysql_fetch_array($result1); ?> <meta http-equiv="Content-Type" content="text/html; charset=TIS-620"> <link href="../source/style.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- .style17 {font-size: 14px} .style18 {color: #003399; font-size: 14px; } .style21 { font-family: Tahoma; font-size: 14px; color: #0000FF; } .style22 { font-family: Tahoma; font-size: 14px; } --> </style> <table width="842" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="842"><br> <fieldset> <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="menu_report.php?Budget_Year=<? echo $rs[Budget_Year]?>" >หน้าหลัก</a></font><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><span class="style17"><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="RepStdSum.php?Budget_Year=<? echo $rs[Budget_Year] ?>">รายงานสรุปวงเเงินที่ตั้งการใช้เงินตามแผน</a></span></font></legend> <label><div align="center"><br /> <form id="form1" name="form1" method="post" action=""> <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray"size="12"> <tr> <td width="56%" bgcolor="#FFFFFF"><font size="2" face="Tahoma"><img src="../picture/previous.gif" onclick="window.history.back()" width="85" height="22" border="0" /></font></td> <td width="30%" bgcolor="#FFFFFF"> </td> <td width="7%" bgcolor="#FFFFFF"> </td> <td width="7%" bgcolor="#FFFFFF"><div align="right"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><span class="style17">ส่งออก <a href="ExcelStdSum.php"><img src="../picture/excel.gif" width="18" height="18" border="0" align="absmiddle" /></a></span></font></div></td> </tr> <tr> <td colspan="4" bgcolor="#FFFFFF"><div align="center"><span class="style22">ตารางสรุปจำนวนตามหมวดค่าใช้จ่าย ปีงบประมาณ</span> <?=$rs["Budget_Year"]?> </div></td> </tr> <tr> <td colspan="4" bgcolor="#FFFFFF"> </td> </tr> <tr> <td colspan="4" bgcolor="#FFFFFF"><div align="left"></div></td> </tr> <tr> <td height="43" colspan="4" bgcolor="#D1E1F0" ><div align="center"> <table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border:0px solid gray"> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="24" bgcolor="#eeeeee" style="border:1px solid gray"><div align="center"><span class="style21">ภาค/ฝ่าย</span></div></td> <td bgcolor="#eeeeee" style="border:1px solid gray"><div align="center"><font color="#0033CC" size="2" face="Tahoma"> <?php $MoneyId = $rs["MoneyId"]; $sql = "Select * From money_tb Where MoneyId='1' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[MoneyName]"; ?> </font></div></td> <td bgcolor="#eeeeee" style="border:1px solid gray"><div align="center"><font color="#0033CC" size="2" face="Tahoma"> <?php $MoneyId = $rs["MoneyId"]; $sql = "Select * From money_tb Where MoneyId='2' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[MoneyName]"; ?> </font></div></td> <td bgcolor="#eeeeee" style="border:1px solid gray"><div align="center"><font color="#0033CC" size="2" face="Tahoma"> <?php $MoneyId = $rs["MoneyId"]; $sql = "Select * From money_tb Where MoneyId='3' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[MoneyName]"; ?> </font></div></td> <td bgcolor="#eeeeee" style="border:1px solid gray"><div align="center"><font color="#0033CC" size="2" face="Tahoma"> <?php $MoneyId = $rs["MoneyId"]; $sql = "Select * From money_tb Where MoneyId='4' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[MoneyName]"; ?> </font></div></td> <td bgcolor="#eeeeee"style="border:1px solid gray"><div align="center"><font color="#0033CC" size="2" face="Tahoma"> <?php $MoneyId = $rs["MoneyId"]; $sql = "Select * From money_tb Where MoneyId='5' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[MoneyName]"; ?> </font></div></td> <td bgcolor="#eeeeee" style="border:1px solid gray"><div align="center"><font color="#0033CC" size="2" face="Tahoma"> <?php $MoneyId = $rs["MoneyId"]; $sql = "Select * From money_tb Where MoneyId='6' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[MoneyName]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td width="24%" bgcolor="#ECF5FF"><font color="#993333" size="2" face="Tahoma"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=01"title="Click to see Detail" class="d"><div align="left"><?php $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='01' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?></div></a></font></td> <td width="14%" bgcolor="#ECF5FF" class="style18"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=01&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='01' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?></font></a></div></td> <td width="12%" bgcolor="#ECF5FF" class="style18"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=01&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='01' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td width="13%" bgcolor="#ECF5FF" class="style18"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=01&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='01' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td width="13%" bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=01&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='01' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td width="12%" bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=01&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='01' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td width="12%" bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=01&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='01' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#FFFFFF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=02"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='02' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=02&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='02' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=02&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='02' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=02&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='02' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=02&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='02' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=02&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='02' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=02&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='02' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#ECF5FF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=03"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='03' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=03&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='03' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=03&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='03' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=03&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='03' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></a></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=03&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='03' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=03&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='03' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=03&MoneyId=6"title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='03' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#FFFFFF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=04"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='04' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#FFFFFF" class="d style17"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=04&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='04' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF" class="d style17"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=04&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='04' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?></font></div></td> <td bgcolor="#FFFFFF" class="d style17"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=04&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='04' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=04&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='04' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=04&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='04' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=04&MoneyId=6"title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='04' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#ECF5FF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=06"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='06' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=06&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='06' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=06&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='06' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=06&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='06' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=06&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='06' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=06&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='06' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=06&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='06' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#FFFFFF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=07"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='07' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=07&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='07' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=07&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='07'and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=07&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='07' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=07&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='07' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=07&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='07' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=07&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='07' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#ECF5FF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=08"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='08' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=08&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='08' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=08&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='08' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=08&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='08' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=08&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='08' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=08&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='08' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=08&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='08' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#FFFFFF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=09"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='09' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=09&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"><?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='09' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=09&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='09' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=09&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='09' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=09&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='09' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=09&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='09' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=09&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='09' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#ECF5FF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=10"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='10' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=10&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='10' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=10&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='10' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=10&MoneyId=3"title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='10' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=10&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='10' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=10&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='10' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=10&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='10' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#FFFFFF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=12"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='12' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=12&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='12' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=12&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='12' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=12&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='12' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=12&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='12' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=12&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='12' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=12&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='12' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#ECF5FF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=15"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='15' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=15&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='15' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=15&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='15' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=15&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='15' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=15&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='15' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=15&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='15' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=15&MoneyId=6"title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='15' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#FFFFFF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=16"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='16' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=16&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='16' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=16&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='16' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=16&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='16' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=16&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='16' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=16&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='16' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=16&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='16' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#ECF5FF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=17"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='17' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=17&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='17' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=17&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='17' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=17&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='17' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=17&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='17' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=17&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='17' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=17&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='17' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#FFFFFF"><a href="ReportPlaning.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=18"title="Click to see Detail" class="d"> <div align="left"> <div align="left"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql = "Select * From faculty_tb Where Faculty_code='18' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Faculty_code] $rss[Faculty_name]"; ?> </div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=18&MoneyId=1 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='1' and Faculty_code='18' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=18&MoneyId=2 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='2' and Faculty_code='18' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=18&MoneyId=3 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='3' and Faculty_code='18' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=18&MoneyId=4 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='4' and Faculty_code='18' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=18&MoneyId=5 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='5' and Faculty_code='18' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#FFFFFF"><div align="right"><a href="RepplanMoy.php?Budget_Year=<?=$rs["Budget_Year"] ?>&Faculty_code=18&MoneyId=6 "title="Click to see Detail" class="d"><font color="#993333" size="2" face="Tahoma"> <?php // $Faculty_code = $rs["Faculty_code"]; $sql1 = "Select Sum(Budget_use) as SumB1 From project_tb Where MoneyId='6' and Faculty_code='18' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumB1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td bgcolor="#ECF5FF"><div align="center" class="style22"><strong>รวม</strong></div></td> <td bgcolor="#ECF5FF"><div align="right"><font color="#993333" size="2" face="Tahoma"> <?php $sql1 = "Select Sum(Budget_use) as SumC1 From project_tb Where MoneyId='1' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumC1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><font color="#993333" size="2" face="Tahoma"> <?php $sql1 = "Select Sum(Budget_use) as SumC1 From project_tb Where MoneyId='2' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumC1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><font color="#993333" size="2" face="Tahoma"> <?php $sql1 = "Select Sum(Budget_use) as SumC1 From project_tb Where MoneyId='3' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumC1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><font color="#993333" size="2" face="Tahoma"> <?php $sql1 = "Select Sum(Budget_use) as SumC1 From project_tb Where MoneyId='4' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumC1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><font color="#993333" size="2" face="Tahoma"> <?php $sql1 = "Select Sum(Budget_use) as SumC1 From project_tb Where MoneyId='5' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumC1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> <td bgcolor="#ECF5FF"><div align="right"><font color="#993333" size="2" face="Tahoma"> <?php $sql1 = "Select Sum(Budget_use) as SumC1 From project_tb Where MoneyId='6' and Budget_Year='$Budget_Year' "; $result1 = mysql_query($sql1) or die("Erro".mysql_error()); $rss1 = mysql_fetch_array($result1); echo number_format($rss1[SumC1],2,'.',','); //echo"$rss1[SumC1]"; ?> </font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td colspan="7" bgcolor="#FFFFFF"> </td> </tr> </table> </div></td> </tr> </table> <br> </form> </div> </label> </fieldset><br> <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br> </font></td> </tr> </table> <?php } else { echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n"; echo"Please Login "; } ?> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0071 ]-- |