<?php
/*
posnewf.php
phpInvoice - 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");
CheckUser();
CheckSession();
if(isset($_REQUEST['myID']))
{
$myID = $_REQUEST['myID'];
}
if(isset($_REQUEST['invoiceID']))
{
$invoiceID = $_REQUEST['invoiceID'];
}
if(isset($_REQUEST['page']))
{
$page = $_REQUEST['page'];
}
if(isset($_REQUEST['infoID']))
{
$infoID = $_REQUEST['infoID'];
}
if(isset($_REQUEST['messageID']))
{
$messageID = $_REQUEST['messageID'];
}
if(isset($_REQUEST['InvoiceDate']))
{
$InvoiceDate = $_REQUEST['InvoiceDate'];
}
if(isset($_REQUEST['MethodOfPaymentDate']))
{
$MethodOfPaymentDate = $_REQUEST['MethodOfPaymentDate'];
}
if(isset($_REQUEST['MethodOfPayment']))
{
$MethodOfPayment = $_REQUEST['MethodOfPayment'];
}
if(isset($_REQUEST['Note']))
{
$Note = $_REQUEST['Note'];
}
if(isset($_POST['PosID']))
{
$PosID = $_POST['PosID'];
}
if(isset($_POST['Pos_Desc']))
{
$Pos_Desc = $_POST['Pos_Desc'];
}
if(isset($_POST['Pos_Quantity']))
{
$Pos_Quantity = $_POST['Pos_Quantity'];
}
if(isset($_POST['Pos_Price']))
{
$Pos_Price = $_POST['Pos_Price'];
}
if(isset($_POST['Pos_Tax']))
{
$Pos_Tax = $_POST['Pos_Tax'];
}
if(isset($_POST['Pos_Tax_Multi']))
{
$Pos_Tax_Multi = $_POST['Pos_Tax_Multi'];
}
if(isset($_POST['Pos_Tax_Divide']))
{
$Pos_Tax_Divide = $_POST['Pos_Tax_Divide'];
}
if(isset($_POST['Pos_Tax_Desc']))
{
$Pos_Tax_Desc = $_POST['Pos_Tax_Desc'];
}
if(isset($_POST['Pos_Group']))
{
$Pos_Group = $_POST['Pos_Group'];
}
if(isset($_REQUEST['InvoiceID1']))
{
$InvoiceID1 = $_REQUEST['InvoiceID1'];
}
if(isset($_REQUEST['CustomerID1']))
{
$CustomerID1 = $_REQUEST['CustomerID1'];
}
if(isset($_REQUEST['DateFrom1']))
{
$DateFrom1 = $_REQUEST['DateFrom1'];
}
if(isset($_REQUEST['DateTill1']))
{
$DateTill1 = $_REQUEST['DateTill1'];
}
if(isset($_REQUEST['Total1']))
{
$Total1 = $_REQUEST['Total1'];
}
if(isset($_REQUEST['Customer1']))
{
$Customer1 = $_REQUEST['Customer1'];
}
if(isset($_REQUEST['Order']))
{
$Order = $_REQUEST['Order'];
}
if(isset($_REQUEST['Sort']))
{
$Sort = $_REQUEST['Sort'];
}
if(isset($_REQUEST['Canceled']))
{
$Canceled = $_REQUEST['Canceled'];
}
if(isset($_REQUEST['Pos_Order']))
{
$Pos_Order = $_REQUEST['Pos_Order'];
$smarty->assign("Pos_Order",$Pos_Order);
}
if(isset($_REQUEST['Pos_Sort']))
{
$Pos_Sort = $_REQUEST['Pos_Sort'];
$smarty->assign("Pos_Sort",$Pos_Sort);
}
$Requestedstring = "myID=$myID&invoiceID=$invoiceID&infoID=$infoID&messageID=$messageID&InvoiceDate=$InvoiceDate&MethodOfPayment=$MethodOfPayment&MethodOfPaymentDate=$MethodOfPaymentDate&Note=$Note&Canceled=$Canceled&Pos_Order=$Pos_Order&Pos_Sort=$Pos_Sort";
$Searchstring = "InvoiceID1=$InvoiceID1&CustomerID1=$CustomerID1&DateFrom1=$DateFrom1&DateTill1=$DateTill1&Total1=$Total1&Customer1=$Customer1";
// Database connection
//
DBConnect();
$query = "INSERT INTO {$TBLName}tmp_invoice (TMP_INVOICEID, MYID, INVOICEID, POSITIONID, USERNAME, POS_DESC, POS_QUANTITY, POS_PRICE, POS_GROUP, TAX, TAX_MULTI, TAX_DIVIDE, TAX_DESC)";
$query .= "VALUES (NULL, '$myID', '$invoiceID', '$PosID', '$_SESSION[Username]', '$Pos_Desc', '$Pos_Quantity', '$Pos_Price', '$Pos_Group', '$Pos_Tax', '$Pos_Tax_Multi', '$Pos_Tax_Divide', '$Pos_Tax_Desc')";
if ($db->Execute($query) === false)
{
die($db->ErrorMsg());
}
if(isset($_POST['Next']))
{
Header("Location: $web/invoice/posnew.php?page=$page&$Requestedstring&Order=$Order&Sort=$Sort&$Searchstring&$sessname=$sessid");
} else {
if(!empty($invoiceID))
{
Header("Location: $web/invoice/edit.php?page=$page&$Requestedstring&tmpID=1&Order=$Order&Sort=$Sort&$Searchstring&$sessname=$sessid");
}
else
{
Header("Location: $web/invoice/new.php?$Requestedstring&tmpID=1&$sessname=$sessid");
}
}
?>