Gecko [ 122.154.134.11 ]

Name	Size	Permission
fonts	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
install	[ DIR ]	drwxr-xr-x
main	[ DIR ]	drwxr-xr-x
manual	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
upload_files	[ DIR ]	drwxr-xr-x
add.php	16.08 KB	-rw-r--r--
book_pass.php	17.14 KB	-rw-r--r--
book_pass_form_comment1.php	5.19 KB	-rw-r--r--
book_pass_form_comment2.php	6.49 KB	-rw-r--r--
book_pass_form_comment3.php	2.72 KB	-rw-r--r--
css.css	1.06 KB	-rw-r--r--
default.php	216 B	-rw-r--r--
detail.php	8.11 KB	-rw-r--r--
display.php	9.25 KB	-rw-r--r--
docprint.php	7.22 KB	-rw-r--r--
document-detail.php	8.57 KB	-rw-r--r--
edit.php	20 KB	-rw-r--r--
idocument.sql	6.22 KB	-rw-r--r--
index.php	7.5 KB	-rw-r--r--
menu.php	3.13 KB	-rw-r--r--
menu_mobile.php	898 B	-rw-r--r--
save.php	4.91 KB	-rw-r--r--
time_inc.php	6.03 KB	-rw-r--r--
view.php	9.12 KB	-rw-r--r--
viewlist.php	7.88 KB	-rw-r--r--

Code Editor : detail.php

<?php	
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
require_once "modules/$_REQUEST[option]/time_inc.php";
foreach($_REQUEST as $key=>$value)
{
 $$key=$value;
}
$sql_idocument_status = "SELECT * FROM `idocument_status`";
$query_idocument_status = mysqli_query($connect, $sql_idocument_status);
$arrComment = array();
while($data_idocument_status = mysqli_fetch_assoc($query_idocument_status)){
 $arrComment[$data_idocument_status['bookstatusid']] = $data_idocument_status['bookstatusname'];
}
?>
<style type="text/css">
#content td{
 font-family: "Sarabun";
 font-size: 16pt;
}
</style>
 
<?php
$id = $_REQUEST['id'];
$sql = "Select * From idocument_main where id = $id";
$dbquery = mysqli_query($connect,$sql);
$dataDisplay = mysqli_fetch_assoc($dbquery);
?>
<div class="container" >
 <div class="panel panel-default">
 <div class="panel-heading">
 
 รายละเอียดบันทึกข้อความ 
 <?php
 if($dataDisplay['officer'] == $_SESSION['login_user_id']){
 ?>
 <a href="modules/idocument/display.php?id=<?=$id?>" class="pull-right btn btn-sm" alt="พิมพ์เอกสาร" title="พิมพ์เอกสาร" target="_blank">
 <img src="images/b_print.png" border="0" alt="พิมพ์เอกสาร" title="พิมพ์เอกสาร">
 </a>&nbsp;
 &nbsp;
 <a href="?option=idocument&task=view" class="pull-right btn btn-sm btn-warning">
 ย้อนกลับ</a>&nbsp;
 <?php
 }
 ?>
 
 </div>
 <div class="panel-body" id = "content">

<table width="100%" border="0">
 <tr>
 <td width="60">
 <img = src="./modules/<?php echo $_REQUEST['option']; ?>/main/krut.png" border="0" width="60">
 </td>
 <td align = "center" valign="middle" colspan="3">
 บันทึกข้อความ
 </td>
 </tr>
 <tr>
 <td colspan="4">
 
 ส่วนราชการ <?php echo $dataDisplay['workgroup_txt'];?>
 
 </td>
 </tr>
 <tr>
 <td valign="middle" colspan="2">
 
 ที่ <?php echo $dataDisplay['book_no'];?>
 
 </td>
 <td valign="middle" align="center" colspan="2">
 
 วันที่ <?php echo thai_dateBook($dataDisplay['book_date']);?>
 
 </td>
 </tr> 
 <tr>
 <td colspan="4" style="border-bottom: 1px solid">
 
 เรื่อง <?php echo $dataDisplay['subject'];?>
 
 </td>
 </tr>
 <tr>
 <td colspan="4" style="">
 
 เรียน <?php echo $dataDisplay['book_to'];?>
 
 </td>
 </tr>
<?php
//Check Ref doc
$sql = "Select * From idocument_files Where document_id = '$id' and docType = 'ref'";
$result = mysqli_query($connect,$sql);
if($result->num_rows > 0){
$i = 1;
echo' <tr>
 <td valign="top" width ="120">อ้างถึง
 </td>
 <td colspan="3" style="">
 ';
 while ($row = $result->fetch_assoc()) {
 if(!empty($row['file_name'])){
 if(empty($row['file_des'])){
 echo $i.". <a target='_blank' href='".$row['file_name'] ."'>เอกสารหนังสืออ้างถึง</a> ";
 }else{
 echo $i.". <a target='_blank' href='".$row['file_name'] ."'>".$row['file_des']."</a> ";
 }
 }else{
 echo $i.". ". $row['file_des']." ";
 }
 $i++;
 }
echo' 
 </td>
 </tr>';
}
?> 
<?php
//Check Ref doc
$sql = "Select * From idocument_files Where document_id = '$id' and docType = 'attach'";
$result = mysqli_query($connect,$sql);
if($result->num_rows > 0){
$i = 1;
echo' <tr>
 <td valign="top" width ="120">สิ่งที่ส่งมาด้วย
 </td>
 <td colspan="3" style="">
 ';
 while ($row = $result->fetch_assoc()) {
 if(!empty($row['file_name'])){
 if(empty($row['file_des'])){
 echo $i.". <a target='_blank' href='".$row['file_name'] ."'>เอกสารสิ่งที่ส่งมาด้วย</a> ";
 }else{
 echo $i.". <a target='_blank' href='".$row['file_name'] ."'>".$row['file_des']."</a> ";
 }
 }else{
 echo $i.". ". $row['file_des']." ";
 }
 $i++;
 }
echo' 
 </td>
 </tr>';
}
?> 
 <tr>
 <td colspan="4" style="">
 
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo nl2br(str_replace(" ", "&nbsp;", $dataDisplay['content1']));?>
 
 </td>
 </tr>
 <tr>
 <td colspan="4" style="">
 
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo nl2br(str_replace(" ", "&nbsp;", $dataDisplay['content2']));?>
 
 </td>
 </tr>
 <tr>
 <td colspan="4" style="">
 
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo nl2br(str_replace(" ", "&nbsp;", $dataDisplay['content3']));?>
 
 </td>
 </tr>
 <tr>
 <td colspan="3" style="text-align:center;"> 
ตรวจสอบเสนอ
 
<?php
// Add signature
$sigFile = "./modules/person/signature/". $dataDisplay['officer'] .".png";
//$sigFile = "./signature/3700300113267.png";
if(file_exists($sigFile)){
	echo "<img src='". $sigFile ."' border='0' width='150'>";
}
?>
 
(<?php echo $dataDisplay['officer_name'];?>)
 
<?php echo $dataDisplay['officer_position'];?>
 
<?php echo thai_dateBook($dataDisplay['book_date']);?>
</td>
 <td style=""></td>
 </tr>
</table>

 
<?php
$sqlComment = "Select * From idocument_comment where document_id = $id Order by id";
//echo $sqlComment;
$dbqueryComment = mysqli_query($connect,$sqlComment); 
if(mysqli_num_rows($dbqueryComment)==0){

}else{
 echo " ";
 while($commentData = mysqli_fetch_array($dbqueryComment)){
$fullname = '( '. $commentData['person_comments_name'].' ) 
'. nl2br($commentData['person_comments_position']).' 
'. thai_dateBook($commentData['comments_date']);
//'. thai_dateBook(date("Y-m-d",$commentData['comments_date']));
$data_comment = explode(", ", $commentData['comments_select']);
$comment ="";
foreach($data_comment as $value){
 @$comment .=($value=="")?"":("-". (($arrComment[$value])?$arrComment[$value]:$value)." ");
}
echo "<div class='col-sm-4' style='font-size:14pt;font-family: \"Sarabun\";'>";
echo $comment;
echo "";

// Add signature
$sigFileComment = "./modules/person/signature/". $commentData['person_comments_id'] .".png";
//$sigFile = "./signature/3700300113267.png";
if(file_exists($sigFileComment)){
	echo "<img src='". $sigFileComment ."' border='0' width='150'>";
}

echo " ".$fullname;
echo "";
echo "</div>";
 }
}

?>
 </div>
<?php
$sql3 = "SELECT * FROM `idocument_sendto` where document_id='$id' and (status='0' or status is null) and person_id<>'' ";
$dbquery3 = mysqli_query($connect,$sql3);
$result3 = mysqli_fetch_array($dbquery3);
$num_row=mysqli_num_rows($dbquery3);

if($num_row>=1){
$sql4 = "SELECT * FROM `person_main` where person_id='$result3[person_id]' ";
$dbquery4 = mysqli_query($connect,$sql4);
$result4 = mysqli_fetch_array($dbquery4);

echo "(ขณะนี้อยู่ระหว่างการพิจารณาของ : ";
echo $result4['prename']; 
echo $result4['name'];
echo " ";
echo $result4['surname'];
echo ")";
}
?>
 </div>
</div>

${this.title}

Code Editor : detail.php