<?
include("connections.php");
include("./class/class.ezpdf.php");
include("./class/class_mysql_function.php");
include("./class/class_date.php");
include("./class/class_form.php");
$form=new personelClass;
$pdf = new Cezpdf();
$mini=new miniClass;
$dateClass=new dateClass;
// better using push on type
// offset are needed at each page
//before wrong location
$array1[]="offset";
$array2[]=$_GET['offset'];
if(isset($_GET['type']) && !empty($_GET['type']) && (strlen($_GET['type']==0))) { $array1[]="type"; $array2[]=$_GET['type']; }
else { unset($_GET['value']); unset($_GET['type']); }
// unset variable of $_GET['value'] and $_GET['type'] before entering the page
if(isset($_GET['type']) && !empty($_GET['type']) && (strlen($_GET['type']==0))) { $array1[]="value"; $array2[]=$_GET['value']; }
if(isset($_GET['mode'])) { if($_GET['mode']==3) {
$sql="delete from `meeting` where `meetingId`='".$_GET['meetingId']."'";
mysql_query($sql) or die(mysql_error());
$form->redirect("meetings.php?message=terminate");
} }
$limit=15;
if(empty($_GET['date'])) { $_GET['date']=date("Ymd"); }
if(empty($_GET['offset'])) { $_GET['offset']=0; }
$tablename="meeting";
$rowid="meetingId";
if(empty($_GET['order'])) { $_GET['order']="`".$tablename."`.`".$rowid."` desc"; }
$sql="SELECT
*
FROM
`".$tablename."`
where
`".$tablename."`.`departmentId`='".$_SESSION['MM_UserDepartment']."'";
if(empty($_GET['date'])) { $_GET['date']=date("Ymd"); }
if(isset($_GET['calendar'])) { $sql=$mysqlDb->date_query($sql,"meeting","date",$_GET['date'],$_GET['calendar']); }
if(isset($_GET['type'])) {
$rowsort[]="meeting_title";
$rowsort[]="meeting_description";
$sql=$mysqlDb->sort_query($sql,$rowid,$rowsort,$_GET['type']);
}
$result_meeting=$mysqlDb->query_page($sql,$_GET['offset'],$limit,$mysql_version);
$countRecord=$mysqlDb->record();
// plugin pdf,excel and word plugin for idcms module
$array_header=array('No','Tajuk','Masa Mula','Masa Berhenti','Tarikh','Penerangan','Hapus');
if(isset($_GET['request']) && !empty($_GET['request'])) {
// this is portable digital file plugin.
if($_GET['request']=="pdf") {
$pdf->selectFont('./class/fonts/Helvetica.afm');
$pdf->ezText('Interactive Digital Content Management System(IDCMS) For E-Mukim',14);
$pdf->ezText('',12);
$i=0;
// had to do query normal
//$result_pdf=mysql_query($sql) or die(mysql_error()."herer");
// better fetch same as the browser wanted
while( $row=mysql_fetch_array($result_meeting) )
{
$j++;
$data[$i]=array('No'=>$j++,'Tajuk'=>$row['meeting_title'],'Masa Mula'=>$row['starttime'],'Masa Berhenti'=>$row['endtime'],'Tarikh'=>$dateClass->convertDateMysql($row['date']),'Penerangan'=>$row['meeting_description']);
$i++;
}
$pdf->ezTable($data,"","Module Meeting",array('width'=>550,'showHeadings' => 1,'shaded'=> 1));
$pdf->ezText('',12);
$pdf->ezText('© 2007,Interative Digital Content Management System(IDCMS)',10);
$pdf->ezStream();
exit;
}
elseif($_GET['request']=='word') {
// this is word plugin.Using header are more faster then building new active x which sometimes memory leak
header("Content-Type: application/msword");
header("Content-Disposition: attachment; filename=mesyuarat.doc");
header("Pragma: no-cache");
header("Expires: 0");
//recreate back all into simple table without the color property
print"<table border=1 bordercolor=000000 cellpadding=0 cellspacing=0>
<tr>";
for($i=0;$i<(count($array_header) -1);$i++) {
print"<th bgcolor=000000><font color=ffffff>".$array_header[$i]."</font></th>
";
}
print"</tr>";
$q=1;
while($row_word=mysql_fetch_array($result_meeting)) {
print"<tr>
<td>".$q++."</td>
<td>".$row_word['meeting_title']."</td>
<td>".$row_word['starttime']."</td>
<td>".$row_word['endtime']."</td>
<td>".$dateClass->convertDateMysql($row_word['date'])."</td>
<td>".$row_word['meeting_description']."<td>
</tr>";
}
print"</table>";
exit();
}
elseif($_GET['request']=="excel") {
// this is excel plugin.
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=mesyuarat.xls");
header("Pragma: no-cache");
header("Expires: 0");
//recreate back all into simple table without the color property
print"<table border=1 bordercolor=000000 cellpadding=0 cellspacing=0>
<tr>";
for($i=0;$i<(count($array_header) -1);$i++) {
print"<th bgcolor=000000><font color=ffffff>".$array_header[$i]."</font> </th>";
}
print"</tr>";
$q=1;
while($row_excel=mysql_fetch_array($result_meeting)) {
print"<tr>
<td>".$q++."</td>
<td>".$row_excel['meeting_title']."</td>
<td>".$row_excel['starttime']."</td>
<td>".$row_excel['endtime']."</td>
<td>".$dateClass->convertDateMysql($row_excel['date'])."</td>
<td>".$row_excel['meeting_description']."<td>
</tr>";
}
print"</table>";
exit();
}
}
include("language/".$_SESSION['MM_UserLanguage']."/text.php");
include("./class/class_navigation.php");
include("./class/class_miscellaneous.php");
$miscellaneous=new miscellaneous;
$starttime=$miscellaneous-> excute_time_start();
$ng = new navigation;
// functionize to better close
function meeting_user($meetingId) {
$sql_user_meeting="select * from `meeting_user`,`human` where `meeting_user`.`meetingId`='".$meetingId."' and `meeting_user`.`humanId`=`human`.`humanId`";
$result_user_meeting=mysql_query($sql_user_meeting) or die(mysql_error());
while($row_user_meeting=mysql_fetch_array($result_user_meeting)) {
$text=$row_user_meeting['name'].$text."
";
}
return($text);
}
?>
<html>
<head>
<title>Meeting Management Module</title>
</head>
<link rel="stylesheet" type="text/css" href="css/reset-min.css">
<link rel="stylesheet" type="text/css" href="css/grid.css">
<link rel="stylesheet" type="text/css" href="css/welcome.css">
<script type="text/javascript" language="javascript">
//<![CDATA[
function addLoadEvent(func) {if ( typeof wpOnload!='function'){wpOnload=func;}else{ var oldonload=wpOnload;wpOnload=function(){oldonload();func();}}}
//]]>
</script>
<script type="text/javascript" src="jscripts/test.js"></script>
<script type="text/javascript" src="jscripts/fat.js"></script>
<script type="text/javascript" src="jscripts/yui-ext.js"></script>
<script language="javascript" type="text/javascript">
/*
* yui-ext
* Copyright(c) 2006, Jack Slocum.
*/
var Example = {
init : function(){
// get the data from web and parse into the yui-ext grid
<? $total_row=@mysql_num_rows($result_meeting); ?>
var myData = [
<? $loop=0; if ($countRecord > 0) { while($row_meeting=@mysql_fetch_array($result_meeting)) {
$loop++;
// here you have to loop data
echo "[
'".$loop."',
'<a href=mmeeting.php?mode=2&meetingId=".$row_meeting['meetingId']." style=\'text-decoration:none;\'><font color=000000>".$miscellaneous->stripparagraph($row_meeting['meeting_title'])."</font></a>',
'<a href=mmeeting.php?mode=2&meetingId=".$row_meeting['meetingId']." style=\'text-decoration:none;\'><font color=000000>".$row_meeting['starttime']."</font></a>','<a href=mmeeting.php?mode=2&meetingId=".$row_meeting['meetingId']." style=\'text-decoration:none;\'><font color=000000>".$row_meeting['endtime']."</font></a>',
'<a href=mmeeting.php?mode=2&meetingId=".$row_meeting['meetingId']." style=\'text-decoration:none;\'><font color=000000>".$dateClass->convertDateMysql($row_meeting['date'])."</font></a>',
'<a href=mmeeting.php?mode=2&meetingId=".$row_meeting['meetingId']." style=\'text-decoration:none;\'><font color=000000>".addslashes($row_meeting['meeting_description'])."</font></a>',
";
// making the code more complex then ever if pull searching style
if(($_SESSION['MM_UserGroup']=="manager") or ($_SESSION['MM_UserGroup']=="hr")) {
echo "'<a href=javascript:deletepage(".$row_meeting['meetingId'].")><font color=000000>". $language[$_SESSION['MM_UserLanguage']]['data']['delete']."</font></a>']";
} else { echo '\'You don\'t have exclusive right to delete\']'; }
if($total_row==$loop) { } else { echo ","; }
// just to make sure code not faiil
} }
echo "];"; ?>
var dataModel = new YAHOO.ext.grid.DefaultDataModel(myData);
// the DefaultColumnModel expects this blob to define columns. It can be extended to provide // custom or reusable ColumnModels
var colModel = new YAHOO.ext.grid.DefaultColumnModel([
<?
//using array to shorten code
$array_header=array('No','Tajuk','Masa Mula','Masa Berhenti','Tarikh','Penerangan','Hapus');
$total=count($array_header);
for($i=0;$i<$total;$i++) {
print "{header: '".$array_header[$i]."', width: 110, sortable: true}";
if(($total -1)== $i) { } else { echo ","; }
} ?>
]);
// create the Grid
var grid = new YAHOO.ext.grid.Grid('example-grid', dataModel, colModel);
grid.render();
}
}
YAHOO.ext.EventManager.onDocumentReady(Example.init, Example, true);
</script>