01.<form name="frmSearch" method="post" action="<?=$_SERVER['SCRIPT_NAME'];?>">
02. <table width="100%" border="0" align="center">
03. <tr>
04. <th width="161" align="left" valign="middle" >ผู้รับผิดชอบ<select name="lmName">
05. <option value="" selected>--ระบุฝ่าย/สาขา--</option>
06. <?
07. $strSQL1 = "SELECT * FROM pgroup ";
08. $objQuery1 = mysql_query($strSQL1);
09. while($objResuut1 = mysql_fetch_array($objQuery1))
10. {
11. ?>
12. <option value="<?=$objResuut1["id_pgroup"];?>">
13. <?=$objResuut1["name_pgroup"];?>
14. </option>
15. <? } ?>
16. </select>ปีการศึกษา<input name="year" type="text" id="year" value="" size="8" /> <input name="submit" type="submit" value="ค้นหา" /> </th>
17. </tr>
18. </table>
19. </form>
20.<? $year = $_POST['year'];
21. $name_pgroup = $_POST['lmName'];
22. $strSQL2 = "SELECT * FROM charges inner join project where project.status_manager='อนุมัติ' and charges.id_project=project.id_project ";
23. if($_POST["year"] != "")
24. {
25. $strSQL2 .= " AND project.year like '%".$_POST["year"]."' ";
26. }
27. if($_POST["lmName"] != "")
28. {
29. $strSQL2 .= " AND project.owner = '".$_POST["lmName"]."' ";
30. }
31. if($_POST["year"] == "" and $_POST["lmName"] == "" )
32. {
33. $strSQL2 .= " and project.id_project='0'";
34. }
35. $strSQL2 .= " order by charges.list asc ";
36. $objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]");
37. $a=1;
38. ?>
39.<table width="100%" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#e76e6f">
40. <tr align="center" bgcolor="#2F97E0" class="style8">
41. <td width="461" height="30" bgcolor="#e76e6f">รายการวัสดุ</td>
42. <td width="234" bgcolor="#e76e6f">จำนวน</td>
43. <td width="143" bgcolor="#e76e6f">งบประมาณ</td>
44. </tr>
45. <?
46. while($objResult2 = mysql_fetch_array($objQuery2))
47. {
48. ?>
49. <tr align="center" valign="top" bgcolor="#FFFFFF" >
50. <td height="20" align="left"><span class="style59">
51. <?
52. $id_project=$objResult2["id_project"];
53. $list=$objResult2["list"];
54. $strSQL5 = "SELECT * FROM material where id_material='$list' ";
55. $objQuery5 = mysql_query($strSQL5) or die ("Error Query [".$strSQL5."]");
56. $objResult5 = mysql_fetch_array($objQuery5);
57. $name_material =$objResult5["name_material"];
58. echo $name_material;
59. ?>
60. </span></td>
61. <td height="20" align="left"><div align="center"><?=$objResult2["c_quantity"];?><?=$objResult2["unit"];?></div></td>
62. <td align="right" >
63. <?
64. $status_plan=$objResult2["status_plan"];
65. $status_manager=$objResult2["status_manager"];
66. $price=$objResult2["price"]; echo number_format($price,2);
67. $sumbudget=$sumbudget+$price;
68. ?> </td>
69. </tr>
70. <? $a++;} ?>
71. <tr align="center" valign="top" bgcolor="#FFFFFF" >
72. <td height="20" colspan="2" align="right">งบประมาณที่ใช้ </td>
73. <td align="right" valign="middle" ><? echo number_format($sumbudget,2) ; ?> </td>
74. </tr>
75.
76. </table>
