Location: PHPKode > projects > PhpRechnung > phpRechnung/position/new.php
<?php
/*
	new.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'];
	$smarty->assign("Pos_Active","$Pos_Active");
}
if(isset($_POST['Pos_Name']))
{
	$Pos_Name = $_POST['Pos_Name'];
	$smarty->assign("Pos_Name","$Pos_Name");
}
if(isset($_POST['Pos_Desc']))
{
	$Pos_Desc = $_POST['Pos_Desc'];
	$smarty->assign("Pos_Desc","$Pos_Desc");
}
if(isset($_POST['Pos_Price']))
{
	$Pos_Price = $_POST['Pos_Price'];
	$smarty->assign("Pos_Price","$Pos_Price");
}
if(isset($_POST['Pos_Tax']))
{
	$Pos_Tax = $_POST['Pos_Tax'];
	$smarty->assign("TaxID","$Pos_Tax");
}
if(isset($_POST['PosGroupID']))
{
	$PosGroupID = $_POST['PosGroupID'];
	$smarty->assign("PosGroupID","$PosGroupID");
}
if(isset($_REQUEST['Note']))
{
	$Note = $_REQUEST['Note'];
	$smarty->assign("Note","$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($_POST['Pos_Active1']))
{
	$Pos_Active1 = $_POST['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[new]");
$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]");
$smarty->assign("NewEntry","$a[new_entry]");

// Database connection
//
DBConnect();

$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);

$query3 = $db->GetRow("SELECT MAX(POSITIONID) AS MAX_POSITIONID FROM {$TBLName}article");
if (!$query3)
	print($db->ErrorMsg());
else
	$PositionID = $query3['MAX_POSITIONID'];

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

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

unset($_SESSION['NewID']);
?>
Return current item: PhpRechnung