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/Pnat_doc_report.php
<?
if(!$username){
include("../../config/config.inc.php");
}

//function ที่ใช้แสดงวันที่แบบเต็ม ใช้ใน edocument
function fulltime_daythai($temp){
if($temp != "0000-00-00 00:00:00"){
	$month = array("ม.ค.", "ก.พ.", "มี.ค.", "เม.ย.", "พ.ค.", "มิ.ย.", "ก.ค.", "ส.ค.", "ก.ย", "ต.ค.", "พ.ย.", "ธ.ค.");
	$temp1=explode(" ", $temp);
	$num = explode("-", $temp1[0]);			
	if($num[0] == "0000"){
	  $date = "ไม่ระบุ";
	} else {
	  $tyear = ($num[0] + 543);
	  $date = remove_zero($num[2])." ".$month[$num[1] - 1 ]." ".$tyear." ".substr($temp1[1],0,-3);	
	}

} else {
	$date = "ไม่ระบุ";
}	
	return $date;
}

?>
<table width="150" border="0" align="right" cellpadding="0" cellspacing="5">
  <tr>
    <td width="50%" align="center" valign="middle"><a href="docreg.php?type=report">รายหน่วยงาน</a></td>
    <td width="50%" align="center" valign="middle"><a href="docreg.php?type=report&amp;view=month">รายเดือน</a></td>
  </tr>
</table><br />
<?


if($_GET['view'] == ''){

$arr_history = array();  
$show_data = "";
  
$sql_history="
SELECT
document.`type`,
epm_staffgroup.gid,
epm_staffgroup.groupname,
doc_receive.`status`,
document.refid,
epm_staffgroup.parent,
doc_receive.id,
doc_receive.staff_id,
epm_staffgroup.org_id
FROM
document
Right Join doc_receive ON document.id = doc_receive.docid
Left Join epm_groupmember ON doc_receive.staff_id = epm_groupmember.staffid
Left Join epm_staffgroup ON epm_groupmember.gid = epm_staffgroup.gid
WHERE
doc_receive.staff_id >  0 AND 
epm_staffgroup.org_id > 1
GROUP BY
doc_receive.id
ORDER BY
document.id ASC
";
$result = mysql_query($sql_history)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($hrs = mysql_fetch_assoc($result)){
	$arr_history[$hrs['groupname']][$hrs['type']]['all'] += 1;
	if($hrs['status'] > 0){
		$arr_history[$hrs['groupname']][$hrs['type']]['rec'] += 1;
	}
}

// ไม่ระบุ
$sql_history="
SELECT
document.id,
document.refid,
document.`type`
FROM
document
WHERE
document.id NOT IN ('
SELECT
doc_receive.docid
FROM
doc_receive'
)
";
$result = mysql_query($sql_history)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($hrs = mysql_fetch_assoc($result)){
	$arr_history['ไม่ระบุ'][$hrs['type']]['all'] += 1;
}

//echo "<font color='#FFFFFF'>".print_r($arr_history)."</font>"; 

if(count($arr_history) > 0){
	foreach($arr_history as $k => $v){	
	
			if($k != 'ไม่ระบุ'){
					if($bgcolor == "#F5F5F5"){$bgcolor="#ffffff";}else{$bgcolor="#F5F5F5";}
			
					if($arr_history[$k]['get']['all'] > 0){ $get_all = $arr_history[$k]['get']['all']; }else{  $get_all = 0; }
					if($arr_history[$k]['get']['rec'] > 0){ $get_rec = $arr_history[$k]['get']['rec']; }else{  $get_rec = 0; }
					$get_res = $get_all - $get_rec;
					
					if($arr_history[$k]['send']['all'] > 0){ $send_all = $arr_history[$k]['send']['all']; }else{  $send_all = 0; }
					if($arr_history[$k]['send']['rec'] > 0){ $send_rec = $arr_history[$k]['send']['rec']; }else{  $send_rec = 0; }
					$send_res = $send_all - $send_rec;
					
					if($arr_history[$k]['circular']['all'] > 0){ $circular_all = $arr_history[$k]['circular']['all']; }else{  $circular_all = 0; }
					if($arr_history[$k]['circular']['rec'] > 0){ $circular_rec = $arr_history[$k]['circular']['rec']; }else{  $circular_rec = 0; }
					$circular_res = $circular_all - $circular_rec;
					
					//sum
					$total_get_all += $get_all;
					$total_get_rec += $get_rec;
					$total_get_res += $get_res;
					
					$total_send_all += $send_all;
					$total_send_rec += $send_rec;
					$total_send_res += $send_res;
					
					$total_circular_all += $circular_all;
					$total_circular_rec += $circular_rec;
					$total_circular_res += $circular_res;
					
					$show_data .= '<tr bgcolor="'.$bgcolor.'" onmouseover="mOvr(this,&quot;dbf2ae&quot;);" onmouseout="mOut(this,&quot;'.$bgcolor.'&quot;);" >
    <td align="left" valign="middle" class="menu_java">&nbsp;'.$k.'</td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=get_all&gn='.$k.'">'.$get_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=get_rec&gn='.$k.'">'.$get_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=get_res&gn='.$k.'">'.$get_res.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=send_all&gn='.$k.'">'.$send_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=send_rec&gn='.$k.'">'.$send_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=send_res&gn='.$k.'">'.$send_res.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=circular_all&gn='.$k.'">'.$circular_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=circular_rec&gn='.$k.'">'.$circular_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=circular_res&gn='.$k.'">'.$circular_res.'</a></td>
  </tr>';
					
			}
	}
	
	if(count($arr_history['ไม่ระบุ']) > 0){
		if($bgcolor == "#F5F5F5"){$bgcolor="#ffffff";}else{$bgcolor="#F5F5F5";}
		
		if($arr_history['ไม่ระบุ']['get']['all'] > 0){ $get_all = $arr_history['ไม่ระบุ']['get']['all']; }else{  $get_all = 0; }
		if($arr_history['ไม่ระบุ']['get']['rec'] > 0){ $get_rec = $arr_history['ไม่ระบุ']['get']['rec']; }else{  $get_rec = 0; }
		$get_res = $get_all - $get_rec;
		
		if($arr_history['ไม่ระบุ']['send']['all'] > 0){ $send_all = $arr_history['ไม่ระบุ']['send']['all']; }else{  $send_all = 0; }
		if($arr_history['ไม่ระบุ']['send']['rec'] > 0){ $send_rec = $arr_history['ไม่ระบุ']['send']['rec']; }else{  $send_rec = 0; }
		$send_res = $send_all - $send_rec;
		
		if($arr_history['ไม่ระบุ']['circular']['all'] > 0){ $circular_all = $arr_history['ไม่ระบุ']['circular']['all']; }else{  $circular_all = 0; }
		if($arr_history['ไม่ระบุ']['circular']['rec'] > 0){ $circular_rec = $arr_history['ไม่ระบุ']['circular']['rec']; }else{  $circular_rec = 0; }
		$circular_res = $circular_all - $circular_rec;
		
		//sum
		$total_get_all += $get_all;
		$total_get_rec += $get_rec;
		$total_get_res += $get_res;
		
		$total_send_all += $send_all;
		$total_send_rec += $send_rec;
		$total_send_res += $send_res;
		
		$total_circular_all += $circular_all;
		$total_circular_rec += $circular_rec;
		$total_circular_res += $circular_res;
  
  $show_data .= '<tr bgcolor="'.$bgcolor.'" onmouseover="mOvr(this,&quot;dbf2ae&quot;);" onmouseout="mOut(this,&quot;'.$bgcolor.'&quot;);" >
    <td align="left" valign="middle" class="menu_java">&nbsp;ไม่ระบุ</td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=get_all">'.$get_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=get_rec">'.$get_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=get_res">'.$get_res.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=send_all">'.$send_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=send_rec">'.$send_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=send_res">'.$send_res.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=circular_all">'.$circular_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=circular_rec">'.$circular_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=dep&nodoc=1&dw=circular_res">'.$circular_res.'</a></td>
  </tr>';
  	}
}

$data1 = $total_get_all.";".$total_send_all.";".$total_circular_all.";";
$data2 = $total_get_rec.";".$total_send_rec.";".$total_circular_rec.";";
$data3 = $total_get_res.";".$total_send_res.";".$total_circular_res.";";

$graphurl="http://202.129.35.106/graphservice/graphservice.php?category=หนังสือรับ;หนังสือส่ง;หนังสือเวียน;&data1=$data1&data2=$data2&data3=$data3&outputstyle=&numseries=3&seriesname=จำนวน;ลงรับ;คงค้าง;&graphtype=column&title=&xname=ประเภท&yname=จำนวน&subtitle=&graphstyle=srd_allvisible_sf_18";

$w1 = 385;
$h1 = 185 ;

?>
<br />
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="50%" align="center" valign="top">
      <table width="385" border="0" cellpadding="0" cellspacing="0" style="border:1px solid #666666;">
      
      <tr>
        <td width="445" height="19" align="center" valign="middle">
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td align="right" class="fillcolor_headgraph"><img src="../../images/maximize.gif" width="18" height="18" onClick="window.open('<?=$graphurl?>')" style="cursor:hand" alt="แสดงกราฟขนาดใหญ่"></td>
          </tr>
        </table>        </td>
      </tr>
      <tr>
        <td height="19" valign="middle" class="link_back">
		  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="flashx1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="<?=$w1?>" height="<?=$h1?>">
          <param name="movie" value="<?=$graphurl?>">
          <param name="quality" value="high">
          <embed src="<?=$graphurl?>" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="<?=$w1?>" height="<?=$h1?>"></embed>
        </object>		</td>
      </tr>
</table>
</td>
    <td width="50%" valign="top"><table width="450" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
      <tr>
        <td width="132" bgcolor="#CCCCCC">&nbsp;</td>
        <td width="56" align="center" bgcolor="#CCCCCC"><strong>จำนวน</strong></td>
        <td width="56" align="center" bgcolor="#CCCCCC"><strong>ลงรับ</strong></td>
        <td width="56" align="center" bgcolor="#CCCCCC"><strong>คงค้าง</strong></td>
      </tr>
      <tr>
        <td bgcolor="#F5F5F5">&nbsp;หนังสือรับ</td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_get_all"><?=$total_get_all?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_get_rec"><?=$total_get_rec?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_get_res"><?=$total_get_res?></a></td>
      </tr>
      <tr>
        <td bgcolor="#F5F5F5">&nbsp;หนังสือส่ง</td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_send_all"><?=$total_send_all?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_send_rec"><?=$total_send_rec?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_send_res"><?=$total_send_res?></a></td>
      </tr>
      <tr>
        <td bgcolor="#F5F5F5">&nbsp;หนังสือเวียน</td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_circular_all"><?=$total_circular_all?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_circular_rec"><?=$total_circular_rec?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=total_circular_res"><?=$total_circular_res?></a></td>
      </tr>
	   <tr>
        <td bgcolor="#F5F5F5">&nbsp;<strong>รวม</strong></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=sum_total_all"><?=($total_get_all+$total_send_all+$total_circular_all)?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=sum_total_rec"><?=($total_get_rec+$total_send_rec+$total_circular_rec)?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=dep&dw=sum_total_res"><?=($total_get_res+$total_send_res+$total_circular_res)?></a></td>
      </tr>
    </table></td>
  </tr>
</table>
<br />
<table width="98%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#000000">
  <tr>
    <td width="182" rowspan="2" bgcolor="#CCCCCC">&nbsp;<strong>หน่วยงาน</strong></td>
    <td height="26" colspan="3" align="center" bgcolor="#CCCCCC"><strong>หนังสือรับ</strong></td>
    <td colspan="3" align="center" bgcolor="#CCCCCC"><strong>หนังสือส่ง</strong></td>
    <td colspan="3" align="center" bgcolor="#CCCCCC"><strong>หนังสือเวียน</strong></td>
  </tr>
  <tr>
    <td width="60" align="center" bgcolor="#CCCCCC">จำนวน</td>
    <td width="60" align="center" bgcolor="#CCCCCC">ลงรับ</td>
    <td width="60" align="center" bgcolor="#CCCCCC">คงค้าง</td>
    <td width="60" align="center" bgcolor="#CCCCCC">จำนวน</td>
    <td width="60" align="center" bgcolor="#CCCCCC">ลงรับ</td>
    <td width="60" align="center" bgcolor="#CCCCCC">คงค้าง</td>
    <td width="60" align="center" bgcolor="#CCCCCC">จำนวน</td>
    <td width="60" align="center" bgcolor="#CCCCCC">ลงรับ</td>
    <td width="59" align="center" bgcolor="#CCCCCC">คงค้าง</td>
  </tr>
  <?
if(count($arr_history) > 0){
	echo $show_data;
?>
<tr bgcolor="<?=$bgcolor?>" onmouseover='mOvr(this,&quot;dbf2ae&quot;);' onmouseout='mOut(this,&quot;<?=$bgcolor?>&quot;);' >
    <td height="22" align="left" valign="middle" bgcolor="#CCCCCC" class="menu_java">&nbsp;<strong>รวม</strong></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_get_all"><?=$total_get_all;?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_get_rec"><?=$total_get_rec?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_get_res"><?=$total_get_res?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_send_all"><?=$total_send_all?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_send_rec"><?=$total_send_rec?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_send_res"><?=$total_send_res?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_circular_all"><?=$total_circular_all?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_circular_rec"><?=$total_circular_rec?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=dep&dw=total_circular_res"><?=$total_circular_res?></a></td>
  </tr>
<?
 }else{
 ?>
 <tr bgcolor="#ffffff" onmouseover='mOvr(this,&quot;dbf2ae&quot;);' onmouseout='mOut(this,&quot;<?=$bgcolor?>&quot;);' >
    <td colspan="10" align="center" valign="top" class="menu_java">ยังไม่มีข้อมูล</td>
  </tr>
 <?
 }
?>
</table>
<?

}else if($view == 'dep'){

//dw=get_all&gn=
switch($_GET['dw']){
	case 'get_all': $booktype = "AND document.`type` =  'get'"; $bookstatus = ''; break;
	
	case 'get_rec': $booktype = "AND document.`type` =  'get'"; $bookstatus = 'AND doc_receive.`status` > 0'; break;
	
	case 'get_res': $booktype = "AND document.`type` =  'get'"; $bookstatus = 'AND doc_receive.`status` = 0'; break;
	
	case 'send_all': $booktype = "AND document.`type` =  'send'"; $bookstatus = ''; break;
	
	case 'send_rec': $booktype = "AND document.`type` =  'send'"; $bookstatus = 'AND doc_receive.`status` > 0'; break;
	
	case 'send_res': $booktype = "AND document.`type` =  'send'"; $bookstatus = 'AND doc_receive.`status` = 0'; break;
	
	case 'circular_all':  $booktype = "AND document.`type` =  'circular'"; $bookstatus = ''; break;
	
	case 'circular_rec':  $booktype = "AND document.`type` =  'circular'"; $bookstatus = 'AND doc_receive.`status` > 0'; break;
	
	case 'circular_res':  $booktype = "AND document.`type` =  'circular'"; $bookstatus = 'AND doc_receive.`status` = 0'; break;
	
	case 'total_get_all': $booktype = "AND document.`type` =  'get'"; $bookstatus = '';  $bookcir = "GROUP BY doc_receive.id"; $getdata = 1; break;
	
	case 'total_get_rec': $booktype = "AND document.`type` =  'get'"; $bookstatus = 'AND doc_receive.`status` > 0'; $bookcir = "GROUP BY doc_receive.id";  break;
	
	case 'total_get_res': $booktype = "AND document.`type` =  'get'"; $bookstatus = 'AND doc_receive.`status` = 0'; $bookcir = "GROUP BY doc_receive.id";  $getdata = 1; break;
	
	case 'total_send_all': $booktype = "AND document.`type` =  'send'"; $bookstatus = ''; $bookcir = "GROUP BY doc_receive.id";  $getdata = 1; break;
	
	case 'total_send_rec': $booktype = "AND document.`type` =  'send'"; $bookstatus = 'AND doc_receive.`status` > 0'; $bookcir = "GROUP BY doc_receive.id";  break;
	
	case 'total_send_res': $booktype = "AND document.`type` =  'send'"; $bookstatus = 'AND doc_receive.`status` = 0'; $bookcir = "GROUP BY doc_receive.id";  $getdata = 1; break;
	
	case 'total_circular_all':  $booktype = "AND document.`type` =  'circular'"; $bookstatus = ''; $getdata = 1; $bookcir = "GROUP BY doc_receive.id"; break;
	
	case 'total_circular_rec':  $booktype = "AND document.`type` =  'circular'"; $bookstatus = 'AND doc_receive.`status` > 0'; $bookcir = "GROUP BY doc_receive.id"; break;
	
	case 'total_circular_res':  $booktype = "AND document.`type` =  'circular'"; $bookstatus = 'AND doc_receive.`status` = 0'; $bookcir = "GROUP BY doc_receive.id"; $getdata = 1; break;
	
	case 'sum_total_all': $booktype = ''; $bookstatus = ''; $bookcir = "GROUP BY doc_receive.id"; $getdata = 1; break;
	
	case 'sum_total_rec': $booktype = ''; $bookstatus = 'AND doc_receive.`status` > 0'; $bookcir = "GROUP BY doc_receive.id"; break;
	
	case 'sum_total_res': $booktype = ''; $bookstatus = 'AND doc_receive.`status` = 0'; $bookcir = "GROUP BY doc_receive.id"; $getdata = 1; break;
}

?>
<br />
<table width="98%" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
	<td valign="middle"><a href="docreg.php?type=report"><img src="../../images/element_previous.png" border="0" />กลับหน้าหลัก</a></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#000000">
  
  <tr>
    <td width="35" bgcolor="#CCCCCC">&nbsp;</td>
	<td width="80" bgcolor="#CCCCCC">&nbsp;เอกสารเลขที่</td>
	<td width="70" align="center" bgcolor="#CCCCCC">ลงวันที่</td>
    <td width="221" bgcolor="#CCCCCC">&nbsp;เรื่อง</td>
    <td width="157" bgcolor="#CCCCCC">&nbsp;จาก</td>
    <td width="157" bgcolor="#CCCCCC">ถึง</td>
  </tr>
  <?
 $count_i = 1; 
  
if($_GET['nodoc'] == ''){
  
  if($_GET['gn']){ $bookgp = "AND epm_staffgroup.groupname =  '".$_GET['gn']."'";}else{ $bookgp = "AND epm_staffgroup.org_id > 1";}
  
	$sql_history="
SELECT
document.`type`,
epm_staffgroup.gid,
epm_staffgroup.groupname,
doc_receive.`status`,
document.refid,
epm_staffgroup.parent,
doc_receive.id,
doc_receive.staff_id,
document.pdate,
document.getting,
document.title,
document.sending
FROM
document
Right Join doc_receive ON document.id = doc_receive.docid
Left Join epm_groupmember ON doc_receive.staff_id = epm_groupmember.staffid
Left Join epm_staffgroup ON epm_groupmember.gid = epm_staffgroup.gid
WHERE
1
AND doc_receive.staff_id >  0
$booktype
$bookgp
$bookstatus
$bookcir
";

}else{

	$sql_history="
SELECT
document.id,
document.refid,
document.pdate,
document.getting,
document.title,
document.sending,
document.`type`
FROM
document
WHERE
document.id NOT IN ('
SELECT
doc_receive.docid
FROM
doc_receive'
) 
$booktype
";

}
echo "<font color='#FFFFFF'>".$sql_history."</font>";
$result = mysql_query($sql_history)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
if(@mysql_num_rows($result ) > 0){
while($hrs = mysql_fetch_assoc($result)){
if($bgcolor == "#F5F5F5"){$bgcolor="#ffffff";}else{$bgcolor="#F5F5F5";}
?>
<tr bgcolor="<?=$bgcolor?>" onmouseover="mOvr(this,&quot;dbf2ae&quot;);" onmouseout="mOut(this,&quot;<?=$bgcolor?>&quot;);" >
    <td align="center" valign="middle" class="menu_java"><?=$count_i?>.</td>
    <td align="left" valign="middle" class="menu_java"><?=$hrs['refid']?></td>
    <td align="center" valign="middle" class="menu_java"><?=$hrs['pdate']?></td>
	<td align="left" valign="middle" class="menu_java">&nbsp;
    <?=$hrs['title']?></td>
    <td valign="middle" class="menu_java"><? echo $hrs['sending'];?></td>
    <td valign="middle" class="menu_java"><? if($bookcir != ''){ echo $hrs['groupname'];}else{echo $hrs['getting'];}?></td>
</tr>
<? $count_i++; }
 }
 
 if( $getdata == 1){
 	
	// ไม่ระบุ
	$sql_history2="
	SELECT
	document.id,
	document.refid,
	document.pdate,
	document.getting,
	document.title,
	document.sending,
	document.`type`
	FROM
	document
	WHERE
	document.id NOT IN ('
	SELECT
	doc_receive.docid
	FROM
	doc_receive'
	) $booktype
	";
	$result2 = mysql_query($sql_history2)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
	if(@mysql_num_rows($result2 ) > 0){
		while($hrs2 = mysql_fetch_assoc($result2)){
		if($bgcolor == "#F5F5F5"){$bgcolor="#ffffff";}else{$bgcolor="#F5F5F5";}
		?>
		<tr bgcolor="<?=$bgcolor?>" onmouseover="mOvr(this,&quot;dbf2ae&quot;);" onmouseout="mOut(this,&quot;<?=$bgcolor?>&quot;);" >
			<td align="center" valign="middle" class="menu_java"><?=$count_i?>.</td>
			<td align="left" valign="middle" class="menu_java"><?=$hrs2['refid']?></td>
			<td align="center" valign="middle" class="menu_java"><?=$hrs2['pdate']?></td>
			<td align="left" valign="middle" class="menu_java">&nbsp;
			<?=$hrs2['title']?></td>
			<td valign="middle" class="menu_java"><?=$hrs2['sending']?></td>
		    <td valign="middle" class="menu_java"><?=$hrs2['getting']?></td>
		</tr>
		<? $count_i++; }
 	}
 }
 
 if(@mysql_num_rows($result ) < 1 && @mysql_num_rows($result2 ) < 1){
 ?>
 <tr bgcolor="#ffffff" onmouseover='mOvr(this,&quot;dbf2ae&quot;);' onmouseout='mOut(this,&quot;<?=$bgcolor?>&quot;);' >
    <td colspan="6" align="center" valign="top" class="menu_java">ยังไม่มีข้อมูล</td>
  </tr>
 <?
 }
?>
</table>

<?
}else if($view == 'month'){

	

$arr_history = array();  
$show_data = "";
  
$sql_history="
SELECT
document.`type`,
epm_staffgroup.gid,
epm_staffgroup.groupname,
doc_receive.`status`,
document.refid,
epm_staffgroup.parent,
doc_receive.id,
doc_receive.staff_id,
document.pdate
FROM
document
Right Join doc_receive ON document.id = doc_receive.docid
Left Join epm_groupmember ON doc_receive.staff_id = epm_groupmember.staffid
Left Join epm_staffgroup ON epm_groupmember.gid = epm_staffgroup.gid
WHERE
document.pdate BETWEEN '".date('Y')."-".date('m')."-01' AND '".date('Y')."-".date('m')."-31' AND
doc_receive.staff_id >  0 AND 
epm_staffgroup.org_id > 1
GROUP BY
doc_receive.id
ORDER BY
document.id ASC
";
$result = mysql_query($sql_history)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($hrs = mysql_fetch_assoc($result)){
	if($hrs['parent'] > 0){
		$arr_history[$hrs['pdate']][$hrs['type']]['all'] += 1;
		if($hrs['status'] > 0){
			$arr_history[$hrs['pdate']][$hrs['type']]['rec'] += 1;
		}
	}
}

// ไม่ระบุ
$sql_history="
SELECT
document.id,
document.refid,
document.`type`,
document.pdate
FROM
document
WHERE
document.id NOT IN ('
SELECT
doc_receive.docid
FROM
doc_receive'
) AND
document.pdate BETWEEN '".date('Y')."-".date('m')."-01' AND '".date('Y')."-".date('m')."-31'
";
$result = mysql_query($sql_history)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
while($hrs = mysql_fetch_assoc($result)){
	$arr_history[$hrs['pdate']][$hrs['type']]['all'] += 1;
}

//print_r($arr_history); exit();

if(count($arr_history) > 0){
	ksort($arr_history);
	foreach($arr_history as $k => $v){	
	
					if($bgcolor == "#F5F5F5"){$bgcolor="#ffffff";}else{$bgcolor="#F5F5F5";}
			
					if($arr_history[$k]['get']['all'] > 0){ $get_all = $arr_history[$k]['get']['all']; }else{  $get_all = 0; }
					if($arr_history[$k]['get']['rec'] > 0){ $get_rec = $arr_history[$k]['get']['rec']; }else{  $get_rec = 0; }
					$get_res = $get_all - $get_rec;
					
					if($arr_history[$k]['send']['all'] > 0){ $send_all = $arr_history[$k]['send']['all']; }else{  $send_all = 0; }
					if($arr_history[$k]['send']['rec'] > 0){ $send_rec = $arr_history[$k]['send']['rec']; }else{  $send_rec = 0; }
					$send_res = $send_all - $send_rec;
					
					if($arr_history[$k]['circular']['all'] > 0){ $circular_all = $arr_history[$k]['circular']['all']; }else{  $circular_all = 0; }
					if($arr_history[$k]['circular']['rec'] > 0){ $circular_rec = $arr_history[$k]['circular']['rec']; }else{  $circular_rec = 0; }
					$circular_res = $circular_all - $circular_rec;
					
					//sum
					$total_get_all += $get_all;
					$total_get_rec += $get_rec;
					$total_get_res += $get_res;
					
					$total_send_all += $send_all;
					$total_send_rec += $send_rec;
					$total_send_res += $send_res;
					
					$total_circular_all += $circular_all;
					$total_circular_rec += $circular_rec;
					$total_circular_res += $circular_res;
					
					$cate .= urlencode(fulltime_daythai($k)).";";
					
					$data1 .= $get_all.";";
					$data2 .= $send_all.";";
					$data3 .= $circular_all.";";
					
					$show_data .= '<tr bgcolor="'.$bgcolor.'" onmouseover="mOvr(this,&quot;dbf2ae&quot;);" onmouseout="mOut(this,&quot;'.$bgcolor.'&quot;);" >
    <td align="left" valign="middle" class="menu_java">&nbsp;'.fulltime_daythai($k).'</td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=get_all&gn='.$k.'">'.$get_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=get_rec&gn='.$k.'">'.$get_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=get_res&gn='.$k.'">'.$get_res.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=send_all&gn='.$k.'">'.$send_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=send_rec&gn='.$k.'">'.$send_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=send_res&gn='.$k.'">'.$send_res.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=circular_all&gn='.$k.'">'.$circular_all.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=circular_rec&gn='.$k.'">'.$circular_rec.'</a></td>
    <td align="center" valign="middle" class="menu_java"><a href="docreg.php?type=report&view=month&dw=circular_res&gn='.$k.'">'.$circular_res.'</a></td>
  </tr>';
					
	}
	
}

$graphurl="http://202.129.35.106/graphservice/graphservice.php?category=$cate&data1=$data1&data2=$data2&data3=$data3&outputstyle=&numseries=3&seriesname=หนังสือรับ;หนังสือส่ง;หนังสือเวียน;&graphtype=line&title=&xname=วันที่&yname=จำนวน&subtitle=&graphstyle=srd_sf_014";

$w1 = 385;
$h1 = 185 ;

?>
<br />
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="50%" align="center" valign="top">
      <table width="385" border="0" cellpadding="0" cellspacing="0" style="border:1px solid #666666;">
      
      <tr>
        <td width="445" height="19" align="center" valign="middle">
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td align="right" class="fillcolor_headgraph"><img src="../../images/maximize.gif" width="18" height="18" onClick="window.open('<?=$graphurl?>')" style="cursor:hand" alt="แสดงกราฟขนาดใหญ่"></td>
          </tr>
        </table>        </td>
      </tr>
      <tr>
        <td height="19" valign="middle" class="link_back">
		  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="flashx1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="<?=$w1?>" height="<?=$h1?>">
          <param name="movie" value="<?=$graphurl?>">
          <param name="quality" value="high">
          <embed src="<?=$graphurl?>" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="<?=$w1?>" height="<?=$h1?>"></embed>
        </object>		</td>
      </tr>
</table>
</td>
    <td width="50%" valign="top"><table width="450" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
      <tr>
        <td width="132" bgcolor="#CCCCCC">&nbsp;</td>
        <td width="56" align="center" bgcolor="#CCCCCC"><strong>จำนวน</strong></td>
        <td width="56" align="center" bgcolor="#CCCCCC"><strong>ลงรับ</strong></td>
        <td width="56" align="center" bgcolor="#CCCCCC"><strong>คงค้าง</strong></td>
      </tr>
      <tr>
        <td bgcolor="#F5F5F5">&nbsp;หนังสือรับ</td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_get_all"><?=$total_get_all?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_get_rec"><?=$total_get_rec?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_get_res"><?=$total_get_res?></a></td>
      </tr>
      <tr>
        <td bgcolor="#F5F5F5">&nbsp;หนังสือส่ง</td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_send_all"><?=$total_send_all?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_send_rec"><?=$total_send_rec?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_send_res"><?=$total_send_res?></a></td>
      </tr>
      <tr>
        <td bgcolor="#F5F5F5">&nbsp;หนังสือเวียน</td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_circular_all"><?=$total_circular_all?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_circular_rec"><?=$total_circular_rec?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=total_circular_res"><?=$total_circular_res?></a></td>
      </tr>
	   <tr>
        <td bgcolor="#F5F5F5">&nbsp;<strong>รวม</strong></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=sum_total_all"><?=($total_get_all+$total_send_all+$total_circular_all)?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=sum_total_rec"><?=($total_get_rec+$total_send_rec+$total_circular_rec)?></a></td>
        <td align="center" bgcolor="#F5F5F5"><a href="docreg.php?type=report&view=month&dw=sum_total_res"><?=($total_get_res+$total_send_res+$total_circular_res)?></a></td>
      </tr>
    </table></td>
  </tr>
</table>
<br />
<table width="98%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#000000">
  <tr>
    <td width="182" rowspan="2" bgcolor="#CCCCCC">&nbsp;<strong>วันที่</strong></td>
    <td height="26" colspan="3" align="center" bgcolor="#CCCCCC"><strong>หนังสือรับ</strong></td>
    <td colspan="3" align="center" bgcolor="#CCCCCC"><strong>หนังสือส่ง</strong></td>
    <td colspan="3" align="center" bgcolor="#CCCCCC"><strong>หนังสือเวียน</strong></td>
  </tr>
  <tr>
    <td width="60" align="center" bgcolor="#CCCCCC">จำนวน</td>
    <td width="60" align="center" bgcolor="#CCCCCC">ลงรับ</td>
    <td width="60" align="center" bgcolor="#CCCCCC">คงค้าง</td>
    <td width="60" align="center" bgcolor="#CCCCCC">จำนวน</td>
    <td width="60" align="center" bgcolor="#CCCCCC">ลงรับ</td>
    <td width="60" align="center" bgcolor="#CCCCCC">คงค้าง</td>
    <td width="60" align="center" bgcolor="#CCCCCC">จำนวน</td>
    <td width="60" align="center" bgcolor="#CCCCCC">ลงรับ</td>
    <td width="59" align="center" bgcolor="#CCCCCC">คงค้าง</td>
  </tr>
  <?
if(count($arr_history) > 0){
	echo $show_data;
?>
<tr bgcolor="<?=$bgcolor?>" onmouseover='mOvr(this,&quot;dbf2ae&quot;);' onmouseout='mOut(this,&quot;<?=$bgcolor?>&quot;);' >
    <td height="22" align="left" valign="middle" bgcolor="#CCCCCC" class="menu_java">&nbsp;<strong>รวม</strong></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_get_all"><?=$total_get_all;?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_get_rec"><?=$total_get_rec?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_get_res"><?=$total_get_res?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_send_all"><?=$total_send_all?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_send_rec"><?=$total_send_rec?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_send_res"><?=$total_send_res?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_circular_all"><?=$total_circular_all?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_circular_rec"><?=$total_circular_rec?></a></td>
    <td align="center" valign="middle" bgcolor="#CCCCCC" class="menu_java"><a href="docreg.php?type=report&view=month&dw=total_circular_res"><?=$total_circular_res?></a></td>
  </tr>
<?
 }else{
 ?>
 <tr bgcolor="#ffffff" onmouseover='mOvr(this,&quot;dbf2ae&quot;);' onmouseout='mOut(this,&quot;<?=$bgcolor?>&quot;);' >
    <td colspan="10" align="center" valign="top" class="menu_java">ยังไม่มีข้อมูล</td>
  </tr>
 <?
 }
?>
</table>
<?



}

//echo $sql_history2;
?>

Anon7 - 2021