001.
<?php
002.
003.
$sql
= "SELECT * from tb_projectmanagement, tb_strategy,tb_tactics,tb_planmanagement
004.
where tb_projectmanagement.Id_strategy=tb_strategy.Id_strategy
005.
and
tb_projectmanagement.Id_tactics=tb_tactics.Id_tactics
006.
and
tb_projectmanagement.Id_project=tb_planmanagement.Id_project
007.
and
tb_strategy.Id_strategy=tb_tactics.Id_strategy
008.
and
year=
'2560'
009.
order by tb_projectmanagement.Id_strategy asc,
010.
tb_projectmanagement.Id_tactics asc";
011.
$objQuery
=
$conn
->query(
$sql
);
012.
013.
$sql1
= "SELECT sum(Budget) from tb_projectmanagement
014.
where Budget
and
year=
'2560'
";
015.
$objQuery1
=
$conn
->query(
$sql1
);
016.
017.
$laststrategy_Id
=
$objResult
[
"Id_strategy"
];
018.
$lastId_tactics
=
$objResult
[
"Id_tactics"
];
019.
020.
while
(
$objResult
=
$objQuery
->fetch_assoc()){
021.
022.
if
(
$laststrategy_Id
!=
$objResult
[
"Id_strategy"
] &&
$lastId_tactics
!=
$objResult
[
"Id_tactics"
])
023.
{
024.
025.
?>
026.
</br>
027.
<span
class
=
"a"
>ยุทธ์ศาสตร์ :</span> <?php
echo
$objResult
[
'Id_strategy'
].
" "
.
$objResult
[
'Name_strategy'
];
echo
"</br>"
; ?>
028.
<span
class
=
"a"
>กลยุทธ์ : <?php
echo
$objResult
[
'Id_tactics'
].
" "
.
$objResult
[
'Name_tactics'
];
echo
"</br></br>"
;
029.
030.
?></span>
031.
032.
033.
<table width=
"1300"
border=
"1"
cellspacing=
"0"
cellpadding=
"0"
>
034.
<tr
class
=
"aa"
>
035.
<td width=
"145"
height=
"40"
bgcolor=
"#FFFFCC"
><center>
036.
โครงการ / กิจกรรม
037.
</center></td>
038.
<td width=
"158"
bgcolor=
"#FFFFCC"
><center>วัตถุประสงค์</center></td>
039.
<td width=
"145"
bgcolor=
"#FFFFCC"
><center>ตัวชี้วัตความสำเร็จและ<br>
040.
เป้าหมายของโครงการ</center></td>
041.
<td width=
"166"
bgcolor=
"#FFFFCC"
><center>ผลการดำเนินการ</center></td>
042.
<td width=
"135"
bgcolor=
"#FFFFCC"
><center>
043.
สถานะของโครงการ
044.
</center></td>
045.
<td width=
"133"
bgcolor=
"#FFFFCC"
><center>
046.
ปัญหาและอุปสรรค
047.
</center></td>
048.
<td width=
"141"
bgcolor=
"#FFFFCC"
><center>
049.
แนวทาง<br>
050.
ในการพัฒนา
051.
</center></td>
052.
<td width=
"136"
bgcolor=
"#FFFFCC"
><center>งบประมาณที่ตั้งไว้ </center></td>
053.
<td width=
"121"
bgcolor=
"#FFFFCC"
><center>
054.
งบประมาณ
055.
</center></td>
056.
</tr>
057.
</table>
058.
059.
<?php
060.
061.
062.
063.
064.
065.
}
066.
?>
067.
068.
<table width=
"1300"
border=
"1"
cellspacing=
"0"
cellpadding=
"0"
>
069.
<tr>
070.
<td width=
"145"
height=
"26"
font size=
"-1"
><?php
echo
$objResult
[
'Id_project'
].
" "
.
$objResult
[
'Name_project'
]; ?></td>
071.
<td width=
"157"
font size=
"-1"
><?php
echo
nl2br
(
$objResult
[
"Objective"
]);?></td>
072.
<td width=
"146"
font size=
"-1"
><?php
echo
nl2br
(
$objResult
[
"Indicators"
]);?></font></td>
073.
<td width=
"167"
font size=
"-1"
><?php
echo
nl2br
(
$objResult
[
"Summary"
]);?></font></td>
074.
<td width=
"134"
><center><?php
075.
if
(
$objResult
[
"Status"
]==
'1'
){
076.
echo
"สิ้นสุดโครงการ"
;
077.
}
if
(
$objResult
[
"Status"
]==
'2'
){
078.
079.
echo
"กำลังดำเนินการโครงการ"
;
080.
}
if
(
$objResult
[
"Status"
]==
'3'
){
081.
082.
echo
"ยังไม่ได้ดำเนินโครงการ"
;
083.
}
084.
?></center></td>
085.
<td width=
"133"
><center>
086.
<?php
echo
nl2br
(
$objResult
[
"Barrier"
]);?>
087.
</center></td>
088.
<td width=
"142"
font size=
"-1"
></font><center><?php
echo
nl2br
(
$objResult
[
"Guideline"
]);?></center></td>
089.
<td width=
"134"
font size=
"-1"
><center><?php
echo
number_format(
$objResult
[
"Budget"
],2).
" บาท"
;?></center></td>
090.
<td width=
"122"
font size=
"-1"
></font><center><?php
echo
number_format(
$objResult
[
"SummaryBudget"
],2).
" บาท"
;?></center></td>
091.
</tr>
092.
093.
094.
</table>
095.
096.
<?php
097.
}
098.
099.
100.
?>
101.
102.
<?php
103.
104.
$sql2
=
"SELECT sum(SummaryBudget) FROM `tb_projectmanagement` WHERE SummaryBudget and year='2560'"
;
105.
$objQuery2
=
$conn
->query(
$sql2
);
106.
while
(
$objResult2
=
$objQuery2
->fetch_assoc())
107.
{
108.
$Budget2
=
$objResult2
[
"sum(SummaryBudget)"
];
109.
}
110.
111.
?>
112.
<table width=
"1300"
border=
"1"
cellspacing=
"0"
cellpadding=
"0"
>
113.
<tr>
114.
<td width=
"1171"
height=
"41"
align=
"right"
>งบประมาณทั้งหมด : </td>
115.
<td width=
"123"
><center><b><?
echo
number_format(
$Budget2
,2).
"บาท"
; ?></b></center></td>
116.
</tr>
117.
</table>