MINI SHELL

Server : Apache/2.2.2 (Fedora)
System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686
User : apache ( 48)
PHP Version : 5.2.9
Disable Function : NONE
Directory :  /var/www/html/eoffice/application/document/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /var/www/html/eoffice/application/document/docreg.php
<?
//include("chk_permission.php");
session_start();
include("../../config/config.inc.php");
include("../../common/function.php");
include("../../common/eoffice.inc.php");
 $time_start_main = getmicrotime();

//echo "<pre>";
//print_r($_SESSION);



# HARD FIX
$user=$_SESSION[session_staffid];
$type=$_GET[type];
if($type){$_SESSION[tab]=$type;}
if(!$type){$type=$_SESSION[type];}
$time_start = getmicrotime();


if( ($action) ){
include "docreg_action.php";
}
?>
<HTML>
<HEAD><TITLE>ระบบทะเบียนหนังสือ</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="../../common/style.css" rel="stylesheet" type="text/css">
<LINK href="../../common/tab_style.css" rel="stylesheet" type="text/css" />
<SCRIPT language="javascript" src="../../common/popcalendar.js"></SCRIPT>
<SCRIPT language="javascript" src="../../common/xmlhttp.js"></SCRIPT>
<SCRIPT type="text/javascript" src="../../common/tabber.js"></SCRIPT>


<LINK media=screen href="block_js/jq.css" type=text/css rel=stylesheet>
<LINK media=screen href="block_js/block.css" type=text/css rel=stylesheet>
<SCRIPT src="block_js/jquery-1.2.6.js" type=text/javaSCRIPT></SCRIPT>
<SCRIPT src="block_js/jquery.blockUI.js" type=text/javaSCRIPT></SCRIPT>
<SCRIPT type=text/javaSCRIPT>
// Effect funtion By P' NOI
function test() {
    $.ajax({ url: 'wait2.php', cache: false });
}
    $().ajaxStop($.unblockUI);
function loadfile(){
        $.blockUI();
        test();
}
</SCRIPT>

</HEAD>
<BODY topmargin="0" onLoad="loadfile();">

	<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
	<TR>
		<TD width="350" align="left"><IMG src="../../images/h-lampang/h-lampang_01.png" width="409" height="79"></TD>
		<TD align="right" background="../../images/h-lampang/h-lampang_02.png">&nbsp;</TD>
		<TD width="359" align="right" valign="bottom"><IMG src="../../images/h-lampang/h-lampang_03.jpg" width="387" height="79"></TD>
	</TR>
</TABLE>
<? $time_end = getmicrotime(); writetime2db($time_start,$time_end,'TITLE และ action');?>


<? $time_start = getmicrotime();?>
<? include "doc_menu_bar.php"; ?>
<? $time_end = getmicrotime(); writetime2db($time_start,$time_end,'MENU BAR');?>

<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
	<TR>
		<TD align="left">

<?

 if( ($session_permit[100]) || ($session_permit[200]) || ($session_permit[300])){ 
	 $time_start = getmicrotime();
### อ่านจากทั้งหมด
	 # นับ docid ที่ไม่ว่าง
	$sql_ac="
	SELECT
	Count(document.id) as num
	FROM
	document
	WHERE 
	document.docid is not null
	";
	$result_ac = mysql_query($sql_ac)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
	$rs_ac = mysql_fetch_assoc($result_ac);

	 # นับ docid ตามประเภท จากทั้งหมด
	$sql_res="
	SELECT
	document.type,
	Count(document.id) as num
	FROM
	document
	WHERE 
	document.docid is not null
	GROUP by document.type
	";
	$result_res = mysql_query($sql_res)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
	while($rs_res = mysql_fetch_assoc($result_res)){
	$doc_num[$rs_res[type]]=$rs_res[num];
	}


	$sql_allread="
	SELECT DISTINCT
	COUNT(doc_history.doc_action) as ALLNUMREAD
	FROM document Inner Join doc_history ON document.id = doc_history.docid
	WHERE doc_history.doc_action = 'view' AND doc_history.doc_owner = '$session_staffid'
	GROUP by doc_history.doc_owner
	";
	$result_allread = mysql_query($sql_allread)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
	$rs_allread = mysql_fetch_assoc($result_allread);
			$time_end = getmicrotime(); writetime2db($time_start,$time_end,'ยอดผลรวมสถิติย่อย Admin');
}


 if( ($session_username!="root") && ((!$session_permit[100]) && (!$session_permit[200]) ) ){

	if($_SESSION[session_staffid]){
	$sql_group="	SELECT	org_groupmember.gid	FROM 	org_groupmember		WHERE	org_groupmember.staffid =  '$session_staffid'	";
	$code_gid="";
	$result_gid_list=mysql_query($sql_group);
	if(@mysql_num_rows($result_gid_list)>0){$i=0;
		while($rs_gid=mysql_fetch_assoc($result_gid_list)){
			if($i>0){ $code_gid.="or"; }else{$code_gid=" WHERE ";} $i++;
			$code_gid.=" org_groupmember.gid like '".$rs_gid[gid]."' ";
		}	
	$sql_group_mem="	SELECT	org_groupmember.staffid	FROM		org_groupmember	$code_gid ";
	$code_gid="";
		$result_gid_list2=mysql_query($sql_group_mem);
		$i=0;
	}
		if($result_gid_list2){
			while($rs_gid=mysql_fetch_assoc($result_gid_list2)){
				if($i>0){ $code_gid.="or"; }else{ $code_gid=" "; } $i++;
				$code_gid.=" (doc_receive.staff_id = '".$rs_gid[staffid]."' )or(doc_receive.owner = '".$rs_gid[staffid]."' ) ";
			}
		}
		if($i>0){ $code_gid.="or doc_receive.staff_id = '".$session_staffid."' "; }else{   $code_gid.="doc_receive.staff_id = '".$session_staffid."' "; }		

		$sql_member_owner=" select  doc_receive.docid from doc_receive where $code_gid group by doc_receive.docid	";

		$code_mem="";$i=0;
		$result_mem_list2=mysql_query($sql_member_owner);
		if($result_mem_list2){
			while($rs_mem=mysql_fetch_assoc($result_mem_list2)){
				if($i>0){ $code_mem.="or"; }else{ $code_mem=" OR "; } $i++;
				$code_mem.="( document.id= '$rs_mem[docid]' )";
			}
		}
	}
	if($i>0){ $code_mem.=" "; }
	$where_code.="and (  (document.owner =  '$session_staffid') $code_mem )";		
	
	$sql_all="
	SELECT
		document.type,
		count(*) as num
	FROM
		document
	WHERE 
		document.type LIKE '%%'
		$paidcheck
		$year_select_code
		$where_code
	GROUP by document.type
	";
	$result=mysql_query($sql_all);

	while($rs_all=mysql_fetch_assoc($result)){
		$doc_num[$rs_all[type]]=$rs_all[num];
	}
		$rs_num=$doc_num[get]+$doc_num[send]+$doc_num[circular];

	$sql_read="
	SELECT
		Count(doc_receive.id) as num
	FROM
		doc_receive
	WHERE
		doc_receive.`status` =  '0' AND
		doc_receive.staff_id =  '$session_staffid'
	GROUP by doc_receive.id
	";
	
	$result_read = mysql_query($sql_read)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
	$rs_read = mysql_fetch_assoc($result_read);
}

if($type != "personal"){ // ปิดการแสดงผลในกรณีเลือกข้อมูลส่วนบุคคล
?>
<? if( ($session_username!="root") && ((!$session_permit[100]) && (!$session_permit[200]) && (!$session_permit[300])) ){
	echo "จำนวนหนังสือทั้งหมด ".$rs_num."  ฉบับ";  if($rs_read[num]) { echo "ยังไม่ได้อ่าน ".$rs_read[num]." ฉบับ";}?>
<? }?>



<? // if( ($session_permit[100]) || ($session_permit[200]) || ($session_permit[300])){ ?>
หนังสือในระบบ <?=$rs_ac[num]?> ฉบับ <?  if($rs_allread[ALLNUMREAD]) {?> ยังไม่ได้อ่าน <?=$rs_ac[num]-$rs_allread[ALLNUMREAD]?><? }?> 
[<? if($doc_num[get]){ ?>รับ :<?=$doc_num[get]?>&nbsp;<?}?>
<? if($doc_num[send]){ ?>ส่ง : <?=$doc_num[send]?>&nbsp;<?}?>
<? if($doc_num[circular]){ ?>เวียน : <?=$doc_num[circular]?>&nbsp;<?}?>
]<?
	//}// end if($type == "personal"){ // ปิดการแสดงผลในกรณีเลือกข้อมูลส่วนบุคคล
 }

 ?>

</TD>
		<TD align="right" valign="top">
		
			<A href="?type=personal">ผู้ใช้ระบบ : 
			<?if($_SESSION[session_title]){echo "(".$_SESSION[session_title].")";}?>		
			<?=$_SESSION[session_fullname]?>		
			<? if($session_permit[300]){echo "[สารบรรณ]";}?>
		</A>		</TD>
	</TR>
	
	<TR>
		<TD height="420" colspan="2" align="left" valign="top">
	
	
	
	
<?
$time_start_A = getmicrotime();

if($type=="add")
{
include "add_select.php";
}

if($action=="search")
{
include "docreg_search.php";
}


if($type=="setting")
{
	include "docreg_profile_setting.php";
}
 if($_SESSION[session_username]!="root"){ 
//<!--------------------------TAB GET--------------------------------->	
 if(($type=="get")||(!$type)||($type=="send")||($type=="all")||($type=="circular")){

//		if ( (($type=="send")||($type=="all"))&&(!$session_permit[300]) ) {
//			$type="get";
//		}

			if(!$action){
			include "docreg_getdart.php";
			}elseif( $action=="add"){
			include "docreg_addform.php";
			}elseif($action=="edit"){
			include "docreg_getform.php";
			}elseif( $action=="view" ){
			include "docreg_getview.php";
			}elseif( $action=="activity" ){
			include "docreg_getact.php";
			}elseif( $action=="confirm" ){
			include "docreg_confirm.php";
			}elseif( $action=="add_past" ){
			include "docreg_passform.php";
			}
	}

// <!-- ------------------------END TAB GET------------------------------- -->

if($type == "personal"){ // แก้ไขข้อมูลส่วนบุคคล
	include("user_properties.php");
}// end / แก้ไขข้อมูลส่วนบุคคล





//<!--------------------------TAB PROFILE--------------------------------->
 if($type=="profile"){ 
	 $type="profile" ?>
		<!--<H2>ระบบบริหารจัดการ Profile Manager</H2>--><BR>

	<? 	
				include "docreg_profile.php";  
	}

}
?>

			
<? if($_SESSION[session_username]=="root"){ 
//<!--------------------------TAB ROOT--------------------------------->
// if($type=="system"){ 
 $type="system" ?>
	<? include "docreg_user_menu.php";  ?>
<!-- ------------------------END TAB ROOT--------------------------------->
<?}?>
<!--------------------------------------------------------------------------------------------->	
<?
if($type == "report"){ // แก้ไขข้อมูลส่วนบุคคล
	include("doc_report.php");
}// end / แก้ไขข้อมูลส่วนบุคคล

$time_end_A = getmicrotime(); writetime2db($time_start_A,$time_end_A,'ส่วนแสดงผล');
?>

</TD>
	</TR>
		<TR>
		<TD colspan="2">
	
	
	
	
		<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
	<TR>
		<TD colspan="2" align="left">&nbsp;</TD>
		</TR>
	<TR>
		<TD align="left">&nbsp;</TD>
		<TD align="right">&nbsp;</TD>
	</TR>
</TABLE>
</BODY>
</HTML>
<? $time_end_main = getmicrotime(); writetime2db($time_start_main,$time_end_main,'หน้าแสดงผลหลัก'); ?>

Anon7 - 2021