<?php

session_start();
if($_SESSION['dbName']==""){
header("location:../index.php");
}


include("config.inc.php");


$connection = mysql_connect($config['dbServer'],$config['dbUser'],$config['dbPass']) or die("Could not connect to DB");
mysql_select_db($_SESSION['dbName'],$connection) or die("Could not find DB");


$querylog="SELECT FA_JournalType as loginaccess from ".$_SESSION['dbLabel'].".login where user_account='".$_SESSION['useraccount']."' 	and Upper(Login_Schema) = Upper('".$_SESSION['dbName']."')	";
	$resultlog=mysql_query($querylog,$connection) or die(mysql_error());
	while($rows=mysql_fetch_array($resultlog)){
		extract($rows);
	}

//if ($loginaccess=='' or $loginaccess==0)
	//header("location:menu.php");

//User Access
$querylog=" select ifNull(FI_AreaApp,0) As FI_AreaApp, ifNull(FI_AreaDel,0) As FI_AreaDel, ".
          " ifNull(FI_AreaMod,0) As FI_AreaMod from ".$_SESSION['dbLabel'].".login where user_account='".$_SESSION['useraccount']."' and Upper(Login_Schema) = Upper('".$_SESSION['dbName']."')  ";
$resultlog=mysql_query($querylog,$connection) or die(mysql_error());
while($rows=mysql_fetch_array($resultlog)){
	extract($rows);
}


$query="select Module_Transportation as Module_Transportation from module";
	$result=mysql_query($query,$connection) or die(mysql_error());
while($rows=mysql_fetch_array($result)){
	extract($rows);
}
	
//Read From Setup Table							
$querysetup= " select grid_color1, grid_color2,maxperpage from setup ";
$resultsetup=mysql_query($querysetup,$connection) or die(mysql_error());
while($rowsetup=mysql_fetch_array($resultsetup)){
	extract($rowsetup);
}

if ($mainmode == '') $mainmode = 'insert';

if($mainmode=='editmode' or $mainmode=='view'){

	$query_edit="select TYPE_NAME, Type_Visible, Type_Desc, confirmed_visible, jourtype_group, Type_Cash, Related_Type, showin_grouping, Type_dbcd  from jourtype where Type_name ='".$Type_Name."'";
	
	//echo $query_edit;exit;

	$resultedit = mysql_query($query_edit, $connection);
	while($row=mysql_fetch_array($resultedit)){

		$Type_Name = $row[0];
		$jour_visible=$row[1];
		$Desc=$row[2];
		$jour_confirmvisible=$row[3];
		$Jour_TypeGroup=$row[4];
		$jour_typecash=$row[5];
		$jour_Type=$row[6];
		$jour_showgroup=$row[7];
		$dbcd=$row[8];
		$mainmode='edit';

	}
}

print <<<HERE
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> 
<meta name="viewport" content="width=device-width, initial-scale=1.0"> 


<script type="text/javascript" language="javascript">

function ClearPage(){
	if (confirm ( "Are you sure you want to Clear Page?"))
	{
		document.JournalType.mainmode.value='';
		document.JournalType.Type_Name.value='';
		document.JournalType.Desc.value='';
		document.JournalType.Chk_visible.value='0';
		document.JournalType.Chk_confirmvisible.value='0';
		document.JournalType.Jour_TypeGroup.value='';
		document.JournalType.Chk_typecash.value='0';
		document.JournalType.reltype.value='';
		document.JournalType.Chk_Active.value='0';
		document.JournalType.txtdbcd.value='';
		document.JournalType.action='Form_JournalType.php';
		document.JournalType.submit();
	}	
}

   function PrintPreview() {
	var str = '';
	
	str = 'Form_JournalTypePreview.php';
	window.open(str);

}
function SubmitRecord(){
	document.JournalType.action="Form_JournalType_Actions.php";
	document.JournalType.submit();
}

function SetJournal(TypeId){
	
	document.JournalType.Type_Name.value=TypeId;
	document.JournalType.actionmode.value='';
	document.JournalType.mainmode.value='editmode';
	document.JournalType.submit();
}

function SetNextPage(startrange,perpage){
	document.JournalType.action='Form_JournalType.php?startrange='+startrange+'&perpage='+perpage;
	document.JournalType.submit();
}

function SetPrvPage(startrange,perpage){
	document.JournalType.action='Form_JournalType.php?startrange='+startrange+'&perpage='+perpage;
	document.JournalType.submit();
}

function SearchForSup(){
	x = document.JournalType;
	document.JournalType.action='Form_JournalType.php?startrange=0';
	document.JournalType.submit();
}

function confirm_delete(Code) {
	
				
	if (confirm ( "Are you sure you want to Delete this Record " + "?")) {
		document.JournalType.mainmode.value='delete';	
		
		document.JournalType.action='Form_JournalType_Actions.php?Type_Name='+Code;
		document.JournalType.submit();
	}
					
}

function set_limit(){

	perpage=document.JournalType.perpage.value;
	document.JournalType.action='Form_JournalType.php?perpage='+perpage+'&startrange=0';
	document.JournalType.submit();
}

function Checkvisible(chk_name) {
	
	if(document.getElementById(chk_name).checked){
		document.getElementById(chk_name).value=1;

	}
	else
	{
		document.getElementById(chk_name).value=0;

	}
}

</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Add Journal Type</title>

<style type="text/css">

body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 11px;
}
body {
	margin-top: 2px;
	margin-left: 1px;
}
a:link {
	text-decoration: none;
	color: #0000FF;
}
a:visited {
	text-decoration: none;
	color: #0000FF;
}
a:hover {
	text-decoration: none;
	color: #0000FF;
}
a:active {
	text-decoration: none;
	color: #0000FF;
}
.style1 {color: #999999; font-weight: bold; }
.style12 {
	font-size: 9px;
	color: #999999;
	font-weight: bold;
}
.style15 {color: #5151FF; font-size: 10px;}
.style16 {
	font-size: 16px;
	color: #FF0000;
	font-weight: bold;
	font-family: "Times New Roman", Times, serif;
}
.style17 {font-size: 9px}
.style25 {color: #999999; font-weight: bold; font-size: 10px; }
.style26 {color: #FF0000}
.style27 {color: #999999 ;font-size: 10px;}
.style28 {color: #FFFFFF ;font-size: 10px;}

</style>

<link type="text/css" rel="stylesheet" href="dhtmlgoodies_calendar.css?random=20051112" media="screen"></LINK>
<SCRIPT type="text/javascript" src="dhtmlgoodies_calendar.js?random=20060118"></script>
<LINK REL="stylesheet" TYPE="text/css" MEDIA="all" HREF="tabs.css">
<link rel="stylesheet" type="text/css" media="all" href="css-v2/style.css">

</head>
<body >
<form name='JournalType' method='post'>

<input type=hidden name='mainmode' value='$mainmode'>
<input type=hidden name='actionmode' value='$actionmode'>
HERE;

//$style= "style=' background-color:#4069A7; color:#FFFFFF;font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px;'";

echo"<table cellpadding='0' cellspacing='0' border='0'  align='center' class='layout-width'>";
include_once("header.php");
echo" <tr><td  valign='top'>";

include_once("sidemenu.php");
echo"  </td></tr>";


echo" <tr style='height:26px;'>
		<td  valign='top' id='content-top'>
			<table border='0' cellpadding='0' cellspacing='0' style='table-layout:fixed; height:26px;' class='layout-width'>
			<tr style='height:26px;'>
				<td style='width:38px; height:26px;'>&nbsp;</td>
				<td valign='middle' style='width:300px; height:26px;'><span class='title'>Journal Type</span></td>
				<td class='message' valign='middle' style='height:26px;'>".htmlspecialchars($message, ENT_QUOTES)."</td>
			</tr></table>
		</td>
	  </tr>";
	  

echo"<tr>
		<td  height='34'  valign='top' id='content-top2'>
			<table border='0' cellpadding='0' cellspacing='0' class='layout-width'>
			<tr>
				<td width='38'  height='34'>&nbsp;</td>
				<td valign='middle' height='34' width='720px'>";
echo"		<button type='button' id='btnClear' name='btnClear' onclick='ClearPage(); return false;' title='Clear Page'><span><span>Clear Page</span></span></button>";


echo"		<button type='button' id='btnPost' name='btnPost' onclick='SubmitRecord(1); return false;' title='Save Changes' $Insmode><span><span>Save</span></span></button>";

echo"	
<button  type='button'  value='Print' onclick='PrintPreview();return false;' title='print' ";


echo"><span><span>Print</span></span></button>";
				
echo"   </td><td align='left' width='250px'> 
	<input type='text' name='txtKeyword' value='$txtKeyword' style='width:105px;' onKeyPress='return submitenter(this,event)'>
	<button type='button' id='btnSearch' name='btnSearch' onclick='SearchForSup(); return false;' title='Search Area'><span><span>Find</span></span></button>
<button type='button' id='btnClear' name='btnClear' onclick='ClearKeyword(); return false;' title='Clear Keyword'><span><span>Clear</span></span></button>";
     echo"</td><td align='left'><span class='style1'><b>Results/page</b></span>
	 <span class='style1'><select name='perpage' id='perpage' value='$perpage' onchange=set_limit();>";
	 
	if ($startrange=='')
		$startrange = 0;
	if ($perpage=='')
		$perpage = 20;
		
	for($i=10;$i<=$maxperpage;$i=$i+10){
		if($i==$perpage)
			echo "<option value='$i'  selected>$i</option>";
		else echo "<option value='$i'>$i</option>";
		
	} 
	 echo"</td></tr></tr>";
echo"	</table>";
echo"</td></tr>";


echo"<tr><td id='content-body'>";				
echo"<table border='0'  align='center' valign='top'  class='tablecontent' >
	<col width=64%>";

echo"   <tr bgcolor='#F7F7F7'  ><td valign='top' align='left'>";	 

echo" <table border='0' style='table-layout:fixed' align='left' valign='top' >
      <col width=120><col width=450>";
	  
echo"<tr bgcolor='#F7F7F7' height='25'>
        <td valign='center' align='left' ><span class='style1'>Type Name&nbsp;<span class='style26'>*</span></span>";
	echo"</td>";			
				
	echo"<td><input type='text' name='Type_Name' id='Type_Name' value='$Type_Name' style='font-size:12px; width:120px; height:18px;'/>";

	echo" </td><td valign='center' align='left' ><span class='style1'>Visible</span></td><td><input type='checkbox' value='$jour_visible' name='Chk_visible' id='Chk_visible' ";if($jour_visible=='1'){echo'checked';} echo " onclick=\"Checkvisible('Chk_visible');\"/> </td></tr>";

echo"<tr bgcolor='#F7F7F7'><td valign='center' align='left' ><span class='style1'>Description&nbsp;<span class='style26'>*</span></span>";
echo"<td><input type='text' name='Desc'  value='".htmlspecialchars($Desc, ENT_QUOTES)."' style='font-size:12px; width:120px; height:18px;'  $status maxlength='20' /></td><td valign='center' align='left' ><span class='style1'>Confirmed Visible</span></td><td><input type='checkbox' name='Chk_confirmvisible' id='Chk_confirmvisible' value='$jour_confirmvisible'";if($jour_confirmvisible=='1'){echo'checked';} echo " onclick=\"Checkvisible('Chk_confirmvisible');\"/></td></tr>";
echo"<tr bgcolor='#F7F7F7'><td valign='center' align='left' ><span class='style1'>Jour Type Group&nbsp;<span class='style26'></span></span>";
echo"<td><input type='text' name='Jour_TypeGroup' value='".htmlspecialchars($Jour_TypeGroup, ENT_QUOTES)."' style='font-size:12px; width:120px; height:18px;'  $status maxlength='20' /></td><td valign='center' align='left' ><span class='style1'>Type Cash</span></td><td><input type='checkbox' name='Chk_typecash' id='Chk_typecash' value='$jour_typecash'";if($jour_typecash=='1'){echo'checked';} echo " onclick=\"Checkvisible('Chk_typecash');\"/></td></tr>";
echo "<td valign='center' align='left' ><span class='style1'>Related Type&nbsp;</span>";

$querytype = "select TYPE_NAME from jourtype where TYPE_NAME != '".$Type_Name."' "; 
$resulttype = mysql_query($querytype, $connection);
	echo"<td><select name='reltype' id='reltype'>
	<option value = ''"; if ($jour_Type==$row[0]) {echo"selected";}echo"></option>";
	while($row=mysql_fetch_array($resulttype)){

echo"<option value='$row[0]'"; if ($jour_Type==$row[0]) {echo"selected";}echo">$row[0]</option>";
}

		  echo"</select></td>
		  <td valign='center' align='left' ><span class='style1'>Show In Grouping</span></td><td><input type='checkbox' name='Chk_Active' id ='Chk_Active' value='$jour_showgroup'";if($jour_showgroup=='1'){echo'checked';} echo " onclick=\"Checkvisible('Chk_Active')\"/></td></tr>
<tr><td valign='center' align='left' ><span class='style1'>DBCD&nbsp;</span></td><td><select name='txtdbcd' id='txtdbcd'>;
  <option value='C'"; if ($dbcd=='C') {echo'selected';} echo ">C</option>
  <option value='D'"; if ($dbcd=='D') {echo'selected';} echo ">D</option>";
		  echo"</select></span></td>";      
echo"   </tr>";


echo"<tr height=15px><td colspan=3></td></tr>";


// Richard
echo"<table style='width:1050px;' border='0' cellspacing=0 cellpadding=0>
	<tr><td id='' style='width:1050px;height:15px;' colspan='3'></td>
	</tr>
	<tr bgcolor='#F7F7F7' > <td  valign='top' colspan=3 id='' style='width:1050px;'>";

echo"<table style='width:1050px; position:relative; left:15px;' border='0' cellspacing=0 >
	<col width=50><col width=500><col width=500>

	 <tr style='background-color:darkgray;' height='30px' >
	 <td>&nbsp;</td>
	 <td align='center' ><span class='style1'><b>Name</b></td>
	 <td align='center' ><span class='style1'><b>Description </b></td> <td> </td>
	 </tr>";
	
	 
	echo"<tr><td  colspan=4 ><div style='overflow-y:scroll;height:250px;width:1060px;border:0px solid #000000;'>
	<table  border='0' width='1050px'>
	<col width=50><col width=500><col width=500>";
	
	$querysearch="select TYPE_NAME,Type_Desc from jourtype ";


	$resultsearch=mysql_query($querysearch,$connection) or die(mysql_error());
	$totalrows = mysql_num_rows($resultsearch);
	
	if ($startrange=='')
		$startrange = 0;
	if ($perpage=='')
		$perpage = 20;
	
	$querysearch = $querysearch." limit ".$startrange.",".$perpage;
	

	$resultsearch=mysql_query($querysearch,$connection) or die(mysql_error());	
	while($rows=mysql_fetch_array($resultsearch)){
		$ct+=1;
		$stylefont='style15';
		
		if($ct%2==0)
			$Color="style='background-color:".$grid_color1."'";
		else			
			$Color="style='background-color:".$grid_color2."'";	
				
		if($mainmode=='edit' && $Type_Name==$rows[0]){
			
			$Color="style='background-color:#1e87a5'";
			$stylefont='style28';
	}	
		
	echo'<tr '.$Color.' height="20px" >';
	
	if($FI_AreaDel==1)	
print<<<HERE

<td align=center ><img border='0' src='img/c_delete.png' width='9' height='10' title='Delete Detail' onmouseover="this.style.cursor='pointer'" OnClick="confirm_delete('$rows[0]')" $DelMode></td>

HERE;
else print<<<HERE

<td align=center >&nbsp;</td>

HERE;

	echo"<td style='cursor:pointer;' onclick=SetJournal('$rows[0]');";echo"><span class='$stylefont' >$rows[0]&nbsp;</span></font></td>
		<td style='cursor:pointer;' onclick=SetJournal('$rows[0]');";echo"><font face='Arial' size='2' color='#186194'><span class='$stylefont'>$rows[1]&nbsp;</span></font></td>";
	echo"";
	

	echo"	</tr>";
}		
	
echo"</table></div></td></tr>";
echo"<tr  ><td >&nbsp;</td><td align='center' >";
		
		$diff= $startrange - $perpage;
		
		if (($diff) >= 0 ){
			$prvstartrange = $startrange - $perpage;
			echo"<img src='img/arrowleft.png' title='Previous' onMouseOver=\"style.cursor='hand'\"  onclick=SetPrvPage('".$prvstartrange."','".$perpage."')>";
		}
		else
			echo "&nbsp;";
		
		echo"</td><td  align='center' colspan=2>";
		
		
		if ($startrange <= $totalrows){
			$startrange = $startrange + $perpage;
			if  ($startrange <= $totalrows)
				echo"<img src='img/arrowright.png' title='Next' onMouseOver=\"style.cursor='hand'\" onclick=SetNextPage('".$startrange."','".$perpage."')>";
		} else
			echo "&nbsp;";
			
		echo"</td></tr>";
		
		

echo"</table></td></tr><tr>
					<td id='' style='width:380px;height:20px;' colspan='3'></td>
				</tr></table></td></tr>";			
	

echo" </table></td></tr>";

echo" <tr height='30'><td align='center' id='content-bottom' ></td></tr>";
include("footer.php");	
echo" </table>  ";//end of last table menu



print <<<HERE
</form>
</body>

HERE;

?>
