<?php
/*
	edit.php

	phpRechnung - is easy-to-use Web-based multilingual accounting software.
	Copyright (C) 2001 - 2008 Edy Corak < phprechnung at ecorak dot net >

	This program is free software; you can redistribute it and/or modify
	it under the terms of the GNU General Public License as published by
	the Free Software Foundation; either version 2 of the License, or
	(at your option) any later version.

	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
	along with this program; if not, write to the Free Software
	Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

require_once("../include/phprechnung.inc.php");
require_once("../include/company_settings.inc.php");
require_once("../include/smarty.inc.php");
CheckUser();
CheckAdminGroup1();
CheckSession();

if(isset($_REQUEST['posID']))
{
	$posID = $_REQUEST['posID'];
	$smarty->assign("posID","$posID");
}
if(isset($_REQUEST['page']))
{
	$page = $_REQUEST['page'];
	$smarty->assign("page","$page");
}
if(isset($_REQUEST['infoID']))
{
	$infoID = $_REQUEST['infoID'];
	$smarty->assign("infoID","$infoID");
}
if(isset($_POST['Pos_Active']))
{
	$Pos_Active = $_POST['Pos_Active'];
}
if(isset($_REQUEST['Pos_Name']))
{
	$Pos_Name = $_REQUEST['Pos_Name'];
}
if(isset($_REQUEST['Pos_Desc']))
{
	$Pos_Desc = $_REQUEST['Pos_Desc'];
}
if(isset($_REQUEST['Pos_Price']))
{
	$Pos_Price = $_REQUEST['Pos_Price'];
}
if(isset($_POST['Pos_Tax']))
{
	$Pos_Tax = $_POST['Pos_Tax'];
}
if(isset($_POST['PosGroupID']))
{
	$PosGroupID = $_POST['PosGroupID'];
	$smarty->assign("PosGroupID","$PosGroupID");
}
if(isset($_REQUEST['Note']))
{
	$Note = $_REQUEST['Note'];
}
if(isset($_REQUEST['Pos_Name1']))
{
	$Pos_Name1 = $_REQUEST['Pos_Name1'];
	$smarty->assign("Pos_Name1","$Pos_Name1");
}
if(isset($_REQUEST['Pos_Desc1']))
{
	$Pos_Desc1 = $_REQUEST['Pos_Desc1'];
	$smarty->assign("Pos_Desc1","$Pos_Desc1");
}
if(isset($_REQUEST['Pos_Price1']))
{
	$Pos_Price1 = $_REQUEST['Pos_Price1'];
	$smarty->assign("Pos_Price1","$Pos_Price1");
}
if(isset($_REQUEST['Note1']))
{
	$Note1 = $_REQUEST['Note1'];
	$smarty->assign("Note1","$Note1");
}
if(isset($_REQUEST['Pos_Active1']))
{
	$Pos_Active1 = $_REQUEST['Pos_Active1'];
	$smarty->assign("Pos_Active1","$Pos_Active1");
}
if(isset($_REQUEST['Order']))
{
	$Order = $_REQUEST['Order'];
	$smarty->assign("Order","$Order");
}
if(isset($_REQUEST['Sort']))
{
	$Sort = $_REQUEST['Sort'];
	$smarty->assign("Sort","$Sort");
}

$Searchstring = "Pos_Name1=$Pos_Name1&amp;Pos_Desc1=$Pos_Desc1&amp;Pos_Price1=$Pos_Price1&amp;Note1=$Note1&amp;Pos_Active1=$Pos_Active1";
$smarty->assign("Searchstring","$Searchstring");

$smarty->assign("Title","$a[position] - $a[edit]");
$smarty->assign("PositionName","$a[pos_name]");
$smarty->assign("PositionText","$a[pos_text]");
$smarty->assign("PositionPrice","$a[pos_price]");
$smarty->assign("PositionActive","$a[pos_active]");
$smarty->assign("PositionGroup","$a[pos_group]");
$smarty->assign("NoteMsg","$a[note]");

// Database connection
//
DBConnect();

// Get the currency from settings table
//
$smarty->assign("Currency",$CompanyCurrency);

// Save options in $pos_active_values
//
$smarty->assign("pos_active_values",array($choice_yes_no));

// Select the tax
//
$query1 = $db->GetAll("SELECT TAXID, TAX_DESC from {$TBLName}tax ORDER BY TAX_DESC");

// If an error has occurred, display the error message
//
if (!$query1)
	print($db->ErrorMsg());
else
	// Save all entrys in $TaxArray
	//
	foreach ( $query1 as $f1 )
	{
		$TaxArray[] = $f1;
	}

$smarty->assign("TaxArray",$TaxArray);

// Select the position group
//
$query2 = $db->GetAll("SELECT POSGROUPID, DESCRIPTION from {$TBLName}posgroup ORDER BY DESCRIPTION");

// If an error has occurred, display the error message
//
if (!$query2)
	print($db->ErrorMsg());
else
	// Save all entrys in $PosGroupArray
	//
	foreach ( $query2 as $f1 )
	{
		$PosGroupArray[] = $f1;
	}

$smarty->assign("PosGroupArray",$PosGroupArray);

// Get entrys from position table
//
$query = $db->GetAll("SELECT POSITIONID, POS_ACTIVE, POS_NAME, POS_DESC, POS_PRICE, POS_TAX, POSGROUPID, NOTE FROM {$TBLName}article WHERE POSITIONID=$posID");

// If an error has occurred, display the error message
//
if (!$query)
	print($db->ErrorMsg());
else
	foreach($query as $f)
	{
		if (empty($Pos_Active))
		{
			$smarty->assign("Pos_Active",$f['POS_ACTIVE']);
		}
		else
		{
			$smarty->assign("Pos_Active",$Pos_Active);
		}
		if (empty($Pos_Name))
		{
			$smarty->assign("Pos_Name",$f['POS_NAME']);
		}
		else
		{
			$smarty->assign("Pos_Name",$Pos_Name);
		}
		if (empty($Pos_Desc))
		{
			$smarty->assign("Pos_Desc",$f['POS_DESC']);
		}
		else
		{
			$smarty->assign("Pos_Desc",$Pos_Desc);
		}
		if (empty($Pos_Price))
		{
			$smarty->assign("Pos_Price",$f['POS_PRICE']);
		}
		else
		{
			$smarty->assign("Pos_Price",$Pos_Price);
		}
		if (empty($Pos_Tax))
		{
			$smarty->assign("TaxID",$f['POS_TAX']);
		}
		else
		{
			$smarty->assign("TaxID",$Pos_Tax);
		}
		if (empty($PosGroupID))
		{
			$smarty->assign("PosGroupID",$f['POSGROUPID']);
		}
		else
		{
			$smarty->assign("PosGroupID",$PosGroupID);
		}
		if (empty($Note))
		{
			$smarty->assign("Note",$f['NOTE']);
		}
		else
		{
			$smarty->assign("Note",$Note);
		}
	}

$smarty->display('position/edit.tpl');

?>