<?php
 
session_start();
header("Content-type: text/html; charset=".$_SESSION['encodingmode']);
if($_SESSION['dbName']==""){
header("location:../index.php");
}


include("config.inc.php");
include("function.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");

if(	$_SESSION['encodingmode'] == 'utf8' || $_SESSION['encodingmode'] == 'utf-8'){
	mysql_query("SET NAMES 'utf8'"); 
	mysql_query('SET CHARACTER SET utf8'); 
	mysql_set_charset('utf8', $connection);
}

$startrange     = $_POST["startrange"]; if ($startrange == ""){$startrange = $_GET["startrange"];}  
$mode     = $_POST["mode"]; if ($mode == ""){$mode = $_GET["mode"];}  
$message     = $_POST["message"]; if ($message == ""){$message = $_GET["message"];}  
$txtKeyword     = $_POST["txtKeyword"]; if ($txtKeyword == ""){$txtKeyword = $_GET["txtKeyword"];}  
$item_code     = $_GET["item_code"]; if ($item_code == ""){$item_code = $_POST["item_code"];}  
$startrange     = $_POST["startrange"]; if ($startrange == ""){$startrange = $_GET["startrange"];}  

$querylog="SELECT FI_itemlocation as loginaccess ,language 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);
	}
	//echo $querylog;
//echo "langage is ".$language;


//echo " select * from ".$_SESSION['dbLabel']. " .itemLocation_label";
 $querylang="select keyword,lbl_itemlocation,lbl_clear,lbl_save,lbl_find,lbl_resultperpage,lbl_itemcode,lbl_description1,lbl_description2,lbl_description3,lbl_itemdescription
  from ".$_SESSION['dbLabel'].".itemlocation_label where language='$language'";


$resultlang=mysql_query($querylang,$connection) or die(mysql_error());
	while($rows=mysql_fetch_array($resultlang)){
		extract($rows); 
	}

$querylang="select language, buttonclear, save, print, find, clear, results, page from ".$_SESSION['dbLabel'].". buttons_label 
where language='$language'";


$resultlang=mysql_query($querylang,$connection) or die(mysql_error());
	while($rows=mysql_fetch_array($resultlang)){
		//extract($rows);
		
		$buttonclear=$rows[1];
		$save=$rows[2];
		$print=$rows[3];
		$find=$rows[4];
		$clear=$rows[5];
		$results=$rows[6];
		$page=$rows[7];
		//echo "sdfsf".$Category_CreationDate;
	}



	
	$perpage = $_POST['perpage']; if($perpage == '') $perpage = $_GET['perpage'];
if ($loginaccess=='' or $loginaccess==0)
	header("location:menu.php");
	
$querysetup="select DecimalBase, DecimalBase1, DecimalBase2, base1, base2, grid_color1, grid_color2,maxperpage from setup";
$resultsetup=mysql_query($querysetup,$connection) or die(mysql_error());
while($rowsetup=mysql_fetch_array($resultsetup)){
	extract($rowsetup);
}

	 
	
//User Access
$querylog=" select ifNull( FI_itemLocApp,0) As  FI_itemLocApp, ifNull( FI_itemLocDel,0) As  FI_itemLocDel, ".
          " ifNull( FI_itemLocMod,0) As  FI_itemLocMod from ".$_SESSION['dbLabel'].".listuserdir where  Usercode = '".$_SESSION['useraccount']."' and upper(concat(CompanyName,'_',Diryear)) = Upper('".$_SESSION['dbName']."') ";
$resultlog=mysql_query($querylog,$connection) or die(mysql_error());
while($rows=mysql_fetch_array($resultlog)){
	extract($rows);
}

//Access Mode On Insert/Edit/Delete
$InsMode = '';
if ($FI_itemLocApp == 0)
	$InsMode = ' disabled ';


if(!isset($actionmode))
$actionmode='';

function displayToday(){
	return strftime("%d")."/".strftime("%m")."/".strftime("%Y");
}

$inactive_date = '';
$TodayDate = displayToday();
$selecteddeactivate = 1;
$category_active = 1;

// if($mode=='editmode' or $mode=='view'){

// 	$query_edit="select   id, description1, description2, description3, item_code  from item_location where item_code = '".$item_code."'";

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

// 		$item_code = $row[4];
// 		$description1=$row[1];
// 		$description2=$row[2];
// 		$description3=$row[3]; 
// 	}
// 	$mode='edit';
// }

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

$query_language  = "select user_account, Language from ".$_SESSION['dbLabel'].".login  where user_account = '".$_SESSION['useraccount']."'";
$result_language = mysql_query($query_language, $connection); 
$row_language    = mysql_fetch_array($result_language);
extract($row_language);
 

if($item_code != '') {
	$querysearchX="select id,description1,description2,description3,items.item_code,item_description  from item_location left join items on items.item_code = item_location.item_code  where items.item_code =  '".$item_code."'";

	// echo $querysearchX;
	$resultsearchX=mysql_query($querysearchX,$connection) or die(mysql_error());
	$totalrowsX = mysql_num_rows($resultsearchX);
	$fieldVals = mysql_fetch_array($resultsearchX);
	if($totalrowsX == 1)
		extract ($fieldVals);
}

print <<<HERE

<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"> 


<link rel="stylesheet" type="text/css" media="all" href="css-v2/style.css">
<script type="text/javascript" language="javascript">

function clearform(str)
{
	if(str == 'A'){
		document.itemLocations.txtKeyword.value='';
		document.itemLocations.item_code[0].value='';
		document.itemLocations.item_code[1].value='';
		document.itemLocations.description1.value='';
		document.itemLocations.description2.value='';
		document.itemLocations.description3.value='';
		document.itemLocations.action='Form_Item_locations.php';
		document.itemLocations.submit();
	}
	if(str == 'D'){
		document.itemLocations.txtKeyword.value=''; 
		document.itemLocations.action='Form_Item_locations.php';
		document.itemLocations.submit();
	}

}
function UpdateDetail(Item_ID){
    x = document.itemLocations;
    x.item_code.value=Item_ID;
   x.actionmode.value='refresh';
   x.action='Form_Item_locations.php?item_code='+Item_ID;
   x.submit();
}	

function updateItem(){
     
    var vItemCode = document.itemLocations.item_code[1].value;
    var vdescription1 = document.itemLocations.description1.value;
    var vdescription2 = document.itemLocations.description2.value;
    var vdescription3 = document.itemLocations.description3.value;
    
    document.itemLocations.action='Form_Items_actions.php?actionmode=EditItemLocation&item_code='+vItemCode+'&item_desc1='+vdescription1+'&item_desc2='+vdescription2+'&item_desc3='+vdescription3;
    document.itemLocations.submit();
}


function PrintItems() {
 
	
	if (confirm ( "Do you want to Print current Items Locations ?"))
	{
		 
		str = 'Form_ItemsLocationsPreview.php';
		window.open(str,'_blank');
	}	
}

function ExportExcellItems() {
 
	
	if (confirm ( "Do you want to export current Items Locations to Excel?"))
	{
		 
		str = 'Form_ItemsLocationsExport.php';
		window.open(str,'_blank');
	}	
}

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

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

           

</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>$lbl_itemlocation</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;
}

.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>

</head>
<body >
<form name='itemLocations' method='post'>
<input type=hidden name='mode' value='$mode'>
<input type=hidden name='actionmode' value='$actionmode'>
<input type=hidden name='message' value='$message'>
<input type=hidden name='item_code' value='$item_code'>
HERE;



if($mode==''){
$status='disabled';
$dis='disabled';

}

if($mode=='view'){

$status='readonly';
$dis='disabled';

}

if($mode=='insert')
$status='';

//$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'>".$lbl_itemlocation."</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='clearform(\"A\"); return false;' title='Clear Page'><span><span>$buttonclear</span></span></button>";

if($item_code!='')
echo"		<button type='button' id='btnPost' name='btnPost' onclick='updateItem(); return false;' title='Save Changes' $Insmode><span><span>$save</span></span></button>";

echo"		<button type='button' id='btnPrint' name='btnPrint' onclick='PrintItems(); return false;' title='Print Items Locations Changes'  ><span><span>$print</span></span></button>";
echo"		<button type='button' id='btnExportExcellItems' name='btnExportExcellItems' onclick='ExportExcellItems(); return false;' title='export Items Locations Changes'  ><span><span>Export To Excel</span></span></button>";


echo"   </td><td align='left' width='260px'>
	
	<input type='text' name='txtKeyword' value='$txtKeyword' style='width:110px;' onKeyPress='return submitenter(this,event)'>&nbsp;
	<button type='Submit' id='btnSearch' name='btnSearch'   return false;' title='Search locations'><span><span>$find</span></span></button>
	<button type='button' id='btnClear' name='btnClear' onclick='clearform(\"D\");' title='Clear Keyword'><span><span>$clear</span></span></button>
	
	</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>";
echo"	</table>";
echo"</td></tr>";

echo"<tr><td id='content-body'>
<table border='0'  align='center' valign='top' width=100% class='tablecontent'>
	<col width=65%>";
	
echo"   <tr bgcolor='#F7F7F7'><td valign='top'>";	 
	  
echo"<table border='0' style='table-layout:fixed' align='left' valign='top'>
		<col width=120>
		<col width=120>
		<col width=80>
		<col width=80>
		<col width=80>
		<col width=80> <col width=80>";
	  
	  
	echo"<tr bgcolor='#F7F7F7' height='25'>
		<td valign='center' align='left' ><span class='style1'> $lbl_itemcode &nbsp;<span class='style26'>*</span></span></td>";
		
		echo"
		<td align='left' colspan = '4'>
		<input type='text' name='item_code' value='".htmlspecialchars($item_code, ENT_QUOTES)."' style='font-size:12px; width:100px; height:18px;'  $status  readOnly />
		&nbsp;
		<input type='text' name='item_description' value='".htmlspecialchars($item_description, ENT_QUOTES)."' style='font-size:12px; width:180px; height:18px;'  $status  readOnly />
		</td>
	</tr>";
			
			
	echo"<tr bgcolor='#F7F7F7' height='25'>";
	echo"<td valign='center' align='left' ><span class='style1'>$lbl_description1 &nbsp;<span class='style26'>*</span></span></td>";
	echo"<td colspan='6' align='left'>
	<input type='text' name='description1' value='".htmlspecialchars($description1, ENT_QUOTES)."' style='font-size:12px; width:400px; height:18px;'  $status maxlength='150' />
	</td>"; 
	echo"<tr bgcolor='#F7F7F7' height='25'><td valign='center' align='left'><span class='style1'>$lbl_description2 &nbsp;<span class='style26'>*</span></span>";
	echo"<td colspan='6' align='left'><input type='text' name='description2' value='".htmlspecialchars($description2, ENT_QUOTES)."' style='font-size:12px; width:400px; height:18px;'  $status maxlength='150' /></td></tr>";
	echo"<tr bgcolor='#F7F7F7' height='25'><td valign='center' align='left'><span class='style1'>$lbl_description3</span>";
	echo"<td colspan='6' align='left'><input type='text' name='description3' value='".htmlspecialchars($description3, ENT_QUOTES)."' style='font-size:12px; width:400px; height:18px;'  $status maxlength='150' /></td></tr>";
	
echo"</table></td></tr><tr>";

echo"<td  valign='top'>";

echo"<table style='width:1050px;' border='0' cellspacing=0>
	<col width=100><col width=150>
	<tr><td id='' style='width:1050px;height:15px;' colspan='4'></td>
	</tr>
	 <tr><td  valign='top' colspan=3 id='' style='width:1050px;'>
	 <table style='width:1050px;' border='0' cellspacing=0>
	 <col width=50>
	 <col width=100>
	 <col width=210>
	 <col width=180>
	 <col width=180>
	 <col width=180>
	<tr height='30px' style='background-color:darkgray;'>
	<td>&nbsp;</td>
	<td align='center'><span class='style1'><b>$lbl_itemcode</b></td>
	<td align='center'><span class='style1'><b>$lbl_itemdescription</b></td>
	<td align='center'><span class='style1'><b>$lbl_description1</b></td>
	<td align='center'><span class='style1'><b>$lbl_description2</b></td>
	<td align='center'><span class='style1'><b>$lbl_description3</b></td>
	</tr></table></td></tr>";
	 
	echo"<tr><td colspan=3 id=''>
	<div style='overflow-y:scroll;height:280px;width:1050px;border:0px solid #000000;'>
	<table  border='0' width='1050px'>
	 <col width=50>
	 <col width=100>
	 <col width=250>
	 <col width=250>
	 <col width=250>";

	$querysearch="select id,description1,description2,description3,items.item_code,item_description  from item_location,items where  item_location.item_code=items.item_code  ";
	if($txtKeyword != '' )
	$querysearch=$querysearch."  and ( item_description like"."('%".$txtKeyword."%') or description1 like"."('%".$txtKeyword."%') or description2 like"."('%".$txtKeyword."%') or description3 like"."('%".$txtKeyword."%') or items.item_code like"."('%".$txtKeyword."%')) ";

	$querysearch=$querysearch." order by item_code";

	$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($mode=='edit' && $Increment==$rows[0]){
			
			$Color="style='background-color:#1e87a5'";
			$stylefont='style28';
	}	
		
	echo'<tr '.$Color.' height="20px" >';
	
if($FI_itemLocDel==1)	
print<<<HERE
<td align=center ><img border='0' src='img/button_edit.png' width='9' height='10' title='Edit Item Location' onmouseover="this.style.cursor='pointer'"  OnClick="UpdateDetail('$rows[4]')" $DelMode></td>
HERE;

else
	print<<<HERE

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

HERE;

	echo"<td style='cursor:pointer;' ";if($FI_itemLocMod==1) echo " onclick='UpdateDetail(\"$rows[4]\")'";echo"><span class='$stylefont' >$rows[4]&nbsp;</span></font></td>
	<td style='cursor:pointer;' ";if($FI_itemLocMod==1) echo " onclick=UpdateDetail('$rows[4]')";echo"><span class='$stylefont' >$rows[5]&nbsp;</span></font></td>
	<td style='cursor:pointer;' ";if($FI_itemLocMod==1) echo " onclick=UpdateDetail('$rows[4]')";echo"><span class='$stylefont' >$rows[1]&nbsp;</span></font></td>
		<td style='cursor:pointer;' ";if($FI_itemLocMod==1) echo " onclick=UpdateDetail('$rows[4]')";echo"><font face='Arial' size='2' color='#186194'><span class='$stylefont'>$rows[2]&nbsp;</span></font></td>
		<td style='cursor:pointer;' ";if($FI_itemLocMod==1) echo " onclick=UpdateDetail('$rows[4]')";echo" width=33%><font face='Arial' size='2' color='#186194'><span class='$stylefont'>$rows[3]&nbsp;</span></font></td>";
	
	echo"";
	

	echo"	</tr>";
}		
	
	echo"</table></div></td></tr>";
echo"<tr height='50px'><td id='' colspan='2'><table width=100% border='0'><tr><td align='center' width=50%>";
		
		$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'>";
		
		
		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><tr>
					<td id='' style='width:1050px;height:20px;' colspan='6'></td>
				</tr></table></td></tr>";
		

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


echo"</td></tr>";		
		 
print <<< HERE
       </td>
      </tr><tr height='30'><td align='center' id='content-bottom' ></td></tr>
	  </table>
HERE;


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

HERE;

?>














