MINI SHELL

<?
if($history_mode=="timeline"){
include'docreg_history_timeline.php';	
}else{

if ($nowdocid == ""){ $nowdocid = $user_id ; } 
//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])."&nbsp;".$month[$num[1] - 1 ]."&nbsp;".$tyear." ".substr($temp1[1],0,-3);	
	}

} else {
	$date = "ไม่ระบุ";
}
	return $date;
} ############### END function fulltime_daythai
//'$nowdocid'

// จำนวนนับ ให้แต่ละ กิจกรรม
$sql2_all ="
SELECT
count(history_actstatus.actstatus) as count_rec,
doc_history.timerec as timerec,
doc_history.doc_action as action
FROM doc_history Inner Join history_actstatus ON doc_history.action_id = history_actstatus.id
WHERE docid = '$nowdocid'
GROUP BY doc_history.timerec
ORDER BY doc_history.timerec ASC
";
$result2 = mysql_db_query($dbname , $sql2_all)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
	while($rs2 = mysql_fetch_assoc($result2)){
	$count[$rs2[timerec]][$rs2[action]]=$rs2[count_rec];
	}


$sql2_all ="
SELECT
doc_history.timerec as timerec,
doc_history.doc_action as action,
doc_history.owner_label as label,
history_actstatus.actstatus as status,
history_actstatus.img as img
FROM doc_history Inner Join history_actstatus ON doc_history.action_id = history_actstatus.id
WHERE docid = '$nowdocid'
ORDER BY doc_history.timerec ASC , doc_history.doc_action DESC 
";
$r=0;$unity_row="off";$all_row=0;
//echo "<pre>";
$result2 = mysql_db_query($dbname , $sql2_all)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
	while($rs2 = mysql_fetch_assoc($result2)){


if(($timerow!=$rs2[timerec])||($rs2[action]!=$action_g)||($rs2[action]=="edit")){$unity_row="off";}
if(($rs2[action]=="activity")){$unity_row="on";}

// ปิด-เปิดกรุ๊ปโรล
//echo $unity_row."<br>";
// ปัดโรลใหม
if($unity_row=="off"){	$r++; $all_row=$r;}

		$show_row[$r][count_grow]=$show_row[$r][count_grow]+1;
		$show_row[$r][timerec]=$rs2[timerec];
		$show_row[$r][status]=$rs2[status];
		$show_row[$r][action]=$rs2[action];
		$show_row[$r][img]=$rs2[img];
		$show_row[$r][label]=$rs2[label];




//if(($timerow==$rs2[timerec])&&($timerow)&&($action_g==$rs2[action])){$unity_row="on";}
if(($timerow==$rs2[timerec])&&($timerow)){$unity_row="on";}
$action_g=$rs2[action];
$timerow=$rs2[timerec];
}

/*
if(!$hpage){$hpage="1";}
if(!$perpage){$perpage="20";}
$lasthpage=intval($all_rows/$perpage)+1;

$limit_start=($hpage-1)*$perpage;
$limit_code=" limit $limit_start , $perpage ";

$nonm=0;

$sql2_all.=" $limit_code";
			
$result2 = mysql_db_query($dbname , $sql2_all)or die("Query line " . __LINE__ . " error<hr>".mysql_error());

while($rs2 = mysql_fetch_assoc($result2)){ 

}
*/
?>
<table width="98%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#eeeeee">

<tr>
<td colspan="3" align="center">
<tr><td colspan="3" align="center">&nbsp;</td>
</tr>

	<tr>
		<td valign="top" bgcolor="#CCCCCC"><strong>ประวัติกิจกรรมทะเบียนหนังสือ </strong> 
			<a href="?action=view&amp;id=<?=$id?>&amp;type=<?=$type?>&amp;history_mode=timeline"><img src="../../images/arrow-b.gif" width="21" height="21" border="0" /></a>		</td>
	</tr>
	<tr>
		<td valign="top"><table width="100%" border="0" cellspacing="1" cellpadding="1">
			
			<tr>
				<td width="30%" bgcolor="#F5F5F5"><strong>กิจกรรมทะเบียนหนังสือ</strong></td>
				<td width="50%" bgcolor="#F5F5F5"><strong>หน่วยดำเนินการ</strong></td>
				<td width="20%" bgcolor="#F5F5F5"><strong>วัน เวลา</strong></td>
			</tr>
						




<?
for($i=1;$i<=$all_row;$i++){
?>
	<tr bgcolor="<?=$bgcolor?>">
		<td><img src='../../images/<?=$show_row[$i][img]?>' ><?=$show_row[$i][status]?></td>
		<td><?
		if(($show_row[$i][action]!="activity")&&($show_row[$i][action]!="add")){
		echo $show_row[$i][label];}else{echo " ".$show_row[$i][count_grow]," หน่วยงาน";}
		?>
		</td>
		<td>
<?
if(($show_row[$i][action]!="activity")&&($show_row[$i][action]!="add")){
	echo  fulltime_daythai( $show_row[$i][timerec]);
	}
?>
	</td>		
	</tr>
<? }?>

</table>
<? }?>

<?
// echo "<pre>";
// print_r($show_row);
?>