$smarty->assign("PositionName", "{$a['pos_name']}");
$smarty->assign("PositionText", "{$a['pos_text']}");
$smarty->assign("PositionQuantity", "{$a['pos_quantity']}");
$smarty->assign("PositionPrice", "{$a['pos_price']}");
$smarty->assign("PositionAmount", "{$a['pos_amount']}");
$smarty->assign("Date_From", "{$a['date_from']}");
$smarty->assign("Date_Till", "{$a['date_till']}");
// Database connection
//
DBConnect();
// Get lines per page and currency from settings table
//
$smarty->assign("Currency", "{$CompanyCurrency}");
$intCursor = ($page - 1) * $EntrysPerPage;
$DateFrom = German_Mysql_Date($DateFrom);
$DateTill = German_Mysql_Date($DateTill);
$query = $db->Execute("SELECT I.INVOICEID, I.CANCELED, I.INVOICE_DATE, P.POSITIONID, P.POS_NAME, V.POSITIONID, V.POS_DESC, V.POS_QUANTITY, V.POS_PRICE, V.POS_GROUP, V.INVOICEID, V.INVOICEPOSID FROM {$TBLName}invoice AS I, {$TBLName}article AS P, {$TBLName}invoicepos AS V WHERE I.INVOICEID=V.INVOICEID AND I.CANCELED=2 AND P.POSITIONID=V.POSITIONID AND I.INVOICE_DATE >= '{$DateFrom}' AND I.INVOICE_DATE <= '{$DateTill}' ORDER BY {$Order} {$Sort} LIMIT {$intCursor}, {$EntrysPerPage}");
// If an error has occurred, display the error message
//
if (!$query) {
print $db->ErrorMsg();
} else {
// Count PageRows
//
$pagenumrows = $query->RecordCount();
}
// Count MaxRows depend on searchstring
//
$query1 = $db->Execute("SELECT I.INVOICEID, I.CANCELED, I.INVOICE_DATE, P.POSITIONID, P.POS_NAME, V.POSITIONID, V.POS_DESC, V.POS_QUANTITY, V.POS_PRICE, V.POS_GROUP, V.INVOICEID, V.INVOICEPOSID FROM {$TBLName}invoice AS I, {$TBLName}article AS P, {$TBLName}invoicepos AS V WHERE I.INVOICEID=V.INVOICEID AND I.CANCELED=2 AND P.POSITIONID=V.POSITIONID AND I.INVOICE_DATE >= '{$DateFrom}' AND I.INVOICE_DATE <= '{$DateTill}'");
$numrows = $query1->RecordCount();
$TotalAmount = 0;
$smarty->assign("Cash_In_Hand", "{$a['cash_in_hand']}");
$smarty->assign("Starting_With", "{$a['starting_with']}");
$smarty->assign("Cashbook_Description", "{$a['cashbook_description']}");
$Searchstring = "CashbookNo_1={$CashbookNo_1}&DateFrom_1={$DateFrom_1}&DateTill_1={$DateTill_1}&Takings_1={$Takings_1}&Expenditures_1={$Expenditures_1}&Description_1={$Description_1}";
$smarty->assign("Searchstring", "{$Searchstring}");
// Database connection
//
DBConnect();
// Get data from company_settings.inc.php
//
$smarty->assign("Cashbook_Currency", $CompanyCurrency);
$intCursor = ($page - 1) * $EntrysPerPage;
// Get Cashbook Information
//
$DateFrom_1 = German_Mysql_Date($DateFrom_1);
$DateTill_1 = German_Mysql_Date($DateTill_1);
if (isset($Canceled) && $Canceled == "1") {
$query = $db->Execute("SELECT CASHBOOKID, MYID, DATE_FORMAT(CASHBOOK_DATE,'%d.%m.%Y') AS CASHBOOK_DDATE, CASH_IN_HAND_STARTING_WITH, TAKINGS, EXPENDITURES, CASH_IN_HAND, DESCRIPTION, CANCELED FROM {$TBLName}cashbook\n\t\tWHERE CANCELED=1 AND CASHBOOKID LIKE '{$CashbookNo_1}%' AND TAKINGS LIKE '%{$Takings_1}%'\n\t\tAND EXPENDITURES LIKE '%{$Expenditures_1}%' AND DESCRIPTION LIKE '%{$Description_1}%'\n\t\tAND CASHBOOK_DATE >= '{$DateFrom_1}' AND CASHBOOK_DATE <= '{$DateTill_1}' ORDER BY {$Order} {$Sort} LIMIT {$intCursor}, {$EntrysPerPage}");
} else {
if (isset($Canceled) && $Canceled == "3") {
$query = $db->Execute("SELECT CASHBOOKID, MYID, DATE_FORMAT(CASHBOOK_DATE,'%d.%m.%Y') AS CASHBOOK_DDATE, CASH_IN_HAND_STARTING_WITH, TAKINGS, EXPENDITURES, CASH_IN_HAND, DESCRIPTION, CANCELED FROM {$TBLName}cashbook\n\t\tWHERE CASHBOOKID LIKE '{$CashbookNo_1}%' AND TAKINGS LIKE '%{$Takings_1}%'\n\t\tAND EXPENDITURES LIKE '%{$Expenditures_1}%' AND DESCRIPTION LIKE '%{$Description_1}%'\n\t\tAND CASHBOOK_DATE >= '{$DateFrom_1}' AND CASHBOOK_DATE <= '{$DateTill_1}' ORDER BY {$Order} {$Sort} LIMIT {$intCursor}, {$EntrysPerPage}");
} else {
$query = $db->Execute("SELECT CASHBOOKID, MYID, DATE_FORMAT(CASHBOOK_DATE,'%d.%m.%Y') AS CASHBOOK_DDATE, CASH_IN_HAND_STARTING_WITH, TAKINGS, EXPENDITURES, CASH_IN_HAND, DESCRIPTION, CANCELED FROM {$TBLName}cashbook\n\t\tWHERE CANCELED=2 AND CASHBOOKID LIKE '{$CashbookNo_1}%' AND TAKINGS LIKE '%{$Takings_1}%'\n\t\tAND EXPENDITURES LIKE '%{$Expenditures_1}%' AND DESCRIPTION LIKE '%{$Description_1}%'\n\t\tAND CASHBOOK_DATE >= '{$DateFrom_1}' AND CASHBOOK_DATE <= '{$DateTill_1}' ORDER BY {$Order} {$Sort} LIMIT {$intCursor}, {$EntrysPerPage}");
}
}
// If an error has occurred, display the error message
//
if (!$query) {
print $db->ErrorMsg();
} else {
// Count PageRows
// Database connection
//
DBConnect();
$intCursor = ($page - 1) * $EntrysPerPage;
if (!empty($PrintName1)) {
$PrintName1 = "AND PRINT_NAME={$PrintName1}";
}
if (!empty($Category1)) {
$Category1 = "AND CATEGORY={$Category1}";
}
if (!empty($MethodOfPayment1)) {
$MethodOfPayment1 = "AND METHODOFPAY={$MethodOfPayment1}";
}
$Date_From1 = German_Mysql_Date($Date_From1);
$Date_Till1 = German_Mysql_Date($Date_Till1);
$Birthday1 = German_Mysql_Date($Birthday1);
// Get Customer Information
//
$query = $db->Execute("SELECT FIRSTNAME, LASTNAME, COMPANY, PHONEWORK, CREATED, MYID FROM {$TBLName}addressbook\n\t\tWHERE MYID LIKE '%{$CustomerID}%' AND PREFIX LIKE '%{$Prefix1}%' AND FIRSTNAME LIKE '%{$Firstname1}%'\n\t\tAND LASTNAME LIKE '%{$Lastname1}%' AND TITLE LIKE '%{$Title11}%' AND COMPANY LIKE '%{$Company1}%'\n\t\tAND DEPARTMENT LIKE '%{$Department1}%' AND ADDRESS LIKE '%{$Address1}%' AND CITY LIKE '%{$City1}%'\n\t\tAND STATEPROV LIKE '%{$Stateprov1}%' AND POSTALCODE LIKE '%{$Postalcode1}%' AND COUNTRY LIKE '%{$Country1}%'\n\t\tAND POSITION LIKE '%{$Position11}%' AND INITIALS LIKE '%{$Initials1}%' AND SALUTATION LIKE '%{$Salutation1}%'\n\t\tAND PHONEHOME LIKE '%{$Phonehome1}%' AND PHONEOFFI LIKE '%{$Phoneoffi1}%' AND PHONEOTHE LIKE '%{$Phoneothe1}%'\n\t\tAND PHONEWORK LIKE '%{$Phonework1}%' AND MOBILE LIKE '%{$Mobile1}%' AND PAGER LIKE '%{$Pager1}%'\n\t\tAND FAX LIKE '%{$Fax1}%' AND EMAIL LIKE '%{$Email1}%' AND URL LIKE '%{$Url1}%' AND NOTE LIKE '%{$Note1}%'\n\t\tAND BIRTHDAY LIKE '%{$Birthday1}%' AND CREATED >= '{$Date_From1}' AND CREATED <= '{$Date_Till1}'\n\t\t{$Category1} {$MethodOfPayment1} {$PrintName1} ORDER BY {$Order} {$Sort} LIMIT {$intCursor}, {$EntrysPerPage}");
// If an error has occurred, display the error message
//
if (!$query) {
print $db->ErrorMsg();
} else {
// Count only PageRows depend on search result
//
$pagenumrows = $query->RecordCount();
}
// Count search result
//
$query1 = $db->Execute("SELECT FIRSTNAME, LASTNAME, COMPANY, PHONEWORK, CREATED, MYID FROM {$TBLName}addressbook\n\t\tWHERE MYID LIKE '%{$CustomerID}%' AND PREFIX LIKE '%{$Prefix1}%' AND FIRSTNAME LIKE '%{$Firstname1}%'\n\t\tAND LASTNAME LIKE '%{$Lastname1}%' AND TITLE LIKE '%{$Title11}%' AND COMPANY LIKE '%{$Company1}%'\n\t\tAND DEPARTMENT LIKE '%{$Department1}%' AND ADDRESS LIKE '%{$Address1}%' AND CITY LIKE '%{$City1}%'\n\t\tAND STATEPROV LIKE '%{$Stateprov1}%' AND POSTALCODE LIKE '%{$Postalcode1}%' AND COUNTRY LIKE '%{$Country1}%'\n\t\tAND POSITION LIKE '%{$Position11}%' AND INITIALS LIKE '%{$Initials1}%' AND SALUTATION LIKE '%{$Salutation1}%'\n\t\tAND PHONEHOME LIKE '%{$Phonehome1}%' AND PHONEOFFI LIKE '%{$Phoneoffi1}%' AND PHONEOTHE LIKE '%{$Phoneothe1}%'\n\t\tAND PHONEWORK LIKE '%{$Phonework1}%' AND MOBILE LIKE '%{$Mobile1}%' AND PAGER LIKE '%{$Pager1}%'\n\t\tAND FAX LIKE '%{$Fax1}%' AND EMAIL LIKE '%{$Email1}%' AND URL LIKE '%{$Url1}%' AND NOTE LIKE '%{$Note1}%'\n\t\tAND BIRTHDAY LIKE '%{$Birthday1}%' AND CREATED >= '{$Date_From1}' AND CREATED <= '{$Date_Till1}'\n\t\t{$Category1} {$MethodOfPayment1} {$PrintName1} ORDER BY {$Order} {$Sort}");
$TAX4 = $f['TAX4_TOTAL'];
$TAX1_DESC = $f['TAX1_DESC'];
$TAX2_DESC = $f['TAX2_DESC'];
$TAX3_DESC = $f['TAX3_DESC'];
$TAX4_DESC = $f['TAX4_DESC'];
$SUBTOTAL1 = $f['SUBTOTAL1'];
$SUBTOTAL2 = $f['SUBTOTAL2'];
$SUBTOTAL3 = $f['SUBTOTAL3'];
$SUBTOTAL4 = $f['SUBTOTAL4'];
$TOTAL_AMOUNT = $f['TOTAL_AMOUNT'];
$NOTE = $f['NOTE'];
}
}
// Create a new offer
//
$Date = German_Mysql_Date(date('d.m.Y'));
$query2 = "INSERT INTO {$TBLName}offer (OFFERID, MYID, INVOICEID, OFFER_DATE, MESSAGEID, MESSAGE_DESC, METHODOFPAYID, METHOD_OF_PAY, METHOD_OF_PAY_DATE, STATUS, TAX1_TOTAL, TAX2_TOTAL, TAX3_TOTAL, TAX4_TOTAL, TAX1_DESC, TAX2_DESC, TAX3_DESC, TAX4_DESC, SUBTOTAL1, SUBTOTAL2, SUBTOTAL3, SUBTOTAL4, TOTAL_AMOUNT, NOTE, ORDER_PRINTED, ORDER_MAILED, OFFER_PRINTED, OFFER_MAILED, CANCELED, CREATEDBY, MODIFIEDBY, USERGROUP1, USERGROUP2, CREATED, MODIFIED)";
$query2 .= "VALUES (NULL, '{$MYID}', '', '{$Date}', '{$MESSAGEID}', '{$MESSAGE_DESC}', '{$METHODOFPAYID}', '{$METHOD_OF_PAY}', '{$METHOD_OF_PAY_DATE}', '1', '{$TAX1}', '{$TAX2}', '{$TAX3}', '{$TAX4}', '{$TAX1_DESC}', '{$TAX2_DESC}', '{$TAX3_DESC}', '{$TAX4_DESC}', '{$SUBTOTAL1}', '{$SUBTOTAL2}', '{$SUBTOTAL3}', '{$SUBTOTAL4}', '{$TOTAL_AMOUNT}', '{$NOTE}', '2', '2', '2', '2', '2', '{$_SESSION['Username']}','{$_SESSION['Username']}', '{$_SESSION['Usergroup1']}', '{$_SESSION['Usergroup2']}', '{$CurrentDateTime}', '{$CurrentDateTime}')";
if ($db->Execute($query2) === false) {
die($db->ErrorMsg());
}
// Get the last entry from table 'offer'
//
$query3 = $db->GetRow("SELECT MAX(OFFERID) AS MAX_OFFERID FROM {$TBLName}offer");
if (!$query3) {
die($db->ErrorMsg());
} else {
$maxOfferID = $query3['MAX_OFFERID'];
}
// Get all positions from table 'offerpos'
//
} else {
// Database connection
//
DBConnect();
// Check if this invoice is fully paid
//
$query = $db->Execute("SELECT INVOICEID, PAID FROM {$TBLName}invoice WHERE PAID='1' AND INVOICEID={$invoiceID}");
$numrows = $query->RowCount();
if ($numrows) {
$smarty->assign("FieldError", "{$a['payment_error']}");
UserInput("");
$smarty->display('payment/newf.tpl');
} else {
// Convert payment date to mysql ISO standard
//
$PaymentDate = German_Mysql_Date($PaymentDate);
// Get the current method of payment description
//
$query1 = $db->Execute("SELECT METHODOFPAYID, DESCRIPTION FROM {$TBLName}methodofpay WHERE METHODOFPAYID={$MethodOfPayment}");
if (!$query1) {
print $db->ErrorMsg();
} else {
foreach ($query1 as $f1) {
$MethodOfPayment_Desc = $f1['DESCRIPTION'];
}
}
// Check if method of payment is cash and $Sum_Paid is negative (credit note)
//
if (isset($MethodOfPayment) && $MethodOfPayment === "2" && $Sum_Paid < 0) {
// Calculate cash in hand
//
UserInput("description");
$smarty->display('cashbook/newf.tpl');
} else {
if (isset($startingwith) && $startingwith + $Cash_In_Hand - $expenditures < 0) {
$smarty->assign("FieldError", "{$a['cashbook_expenditures']}");
UserInput("expenditures");
$smarty->display('cashbook/newf.tpl');
} else {
if ($Cash_In_Hand_Till - $expenditures < 0) {
$smarty->assign("FieldError", "{$a['cashbook_expenditures']}");
UserInput("expenditures");
$smarty->display('cashbook/newf.tpl');
} else {
$Cash_In_Hand_Day = $Cash_In_Hand + ($takings - $expenditures);
$Cash_In_Hand_Day = FormatDBNumber($Cash_In_Hand_Day);
$cashbookdate = German_Mysql_Date($cashbookdate);
$query4 = "INSERT INTO {$TBLName}cashbook (CASHBOOKID, MYID, INVOICEID, PAYMENTID, DESCRIPTION, CASHBOOK_DATE, TAKINGS, EXPENDITURES, CASH_IN_HAND, CASH_IN_HAND_STARTING_WITH, CANCELED, CREATEDBY, MODIFIEDBY, USERGROUP1, USERGROUP2, CREATED, MODIFIED)";
$query4 .= "VALUES(NULL, '', '', '', '{$description}', '{$cashbookdate}', '{$takings}', '{$expenditures}', '{$Cash_In_Hand_Day}', '{$startingwith}', '2', '{$_SESSION['Username']}', '{$_SESSION['Username']}', '{$_SESSION['Usergroup1']}', '{$_SESSION['Usergroup2']}', '{$CurrentDateTime}','{$CurrentDateTime}')";
if ($db->Execute($query4) === false) {
die($db->ErrorMsg());
}
$_SESSION['NewID'] = "1";
Header("Location: {$web}/cashbook/new.php?page={$page}&infoID={$infoID}&Order={$Order}&Sort={$Sort}&Canceled={$Canceled}&{$sessname}={$sessid}");
}
}
}
}
}
}
}
}
if (empty($D_Company_Postal)) {
$smarty->assign("FieldError", "{$a['company_postal']} - {$a['field_error']}");
UserInput("D_Company_Postal");
} else {
if (empty($D_Company_City)) {
$smarty->assign("FieldError", "{$a['company_city']} - {$a['field_error']}");
UserInput("D_Company_City");
} else {
if (empty($D_Company_Country)) {
$smarty->assign("FieldError", "{$a['company_country']} - {$a['field_error']}");
UserInput("D_Company_Country");
} else {
if (empty($D_Company_Currency)) {
$smarty->assign("FieldError", "{$a['company_currency']} - {$a['field_error']}");
UserInput("D_Company_Currency");
} else {
$D_Company_Date = German_Mysql_Date($D_Company_Date);
if (empty($D_Sales_Prices)) {
$query = $db->Execute("UPDATE {$TBLName}setting SET COMPANY_DATE='{$D_Company_Date}', COMPANY_NAME='{$D_Company_Name}', COMPANY_ADDRESS='{$D_Company_Address}', COMPANY_POSTAL='{$D_Company_Postal}', COMPANY_CITY='{$D_Company_City}', COMPANY_COUNTRY='{$D_Company_Country}', COMPANY_PHONE='{$D_Company_Phone}', COMPANY_FAX='{$D_Company_Fax}', COMPANY_EMAIL='{$D_Company_Email}', COMPANY_URL='{$D_Company_URL}', COMPANY_CURRENCY='{$D_Company_Currency}', TAX_FREE='{$D_Company_Tax_Free}', COMPANY_TAXNR='{$D_Company_Taxnr}', COMPANY_BUSINESS_TAXNR='{$D_Business_Taxnr}', COMPANY_BANKNAME='{$D_Bank_Name}', COMPANY_BANKACCOUNT='{$D_Bank_Account}', COMPANY_BANKNUMBER='{$D_Bank_Number}', COMPANY_BANKIBAN='{$D_Bank_IBAN}', COMPANY_BANKBIC='{$D_Bank_BIC}', MODIFIEDBY='{$_SESSION['Username']}' WHERE SETTINGID={$settingID}");
} else {
$query = $db->Execute("UPDATE {$TBLName}setting SET COMPANY_DATE='{$D_Company_Date}', COMPANY_NAME='{$D_Company_Name}', COMPANY_ADDRESS='{$D_Company_Address}', COMPANY_POSTAL='{$D_Company_Postal}', COMPANY_CITY='{$D_Company_City}', COMPANY_COUNTRY='{$D_Company_Country}', COMPANY_PHONE='{$D_Company_Phone}', COMPANY_FAX='{$D_Company_Fax}', COMPANY_EMAIL='{$D_Company_Email}', COMPANY_URL='{$D_Company_URL}', COMPANY_CURRENCY='{$D_Company_Currency}', COMPANY_SALESPRICE='{$D_Sales_Prices}', TAX_FREE='{$D_Company_Tax_Free}', COMPANY_TAXNR='{$D_Company_Taxnr}', COMPANY_BUSINESS_TAXNR='{$D_Business_Taxnr}', COMPANY_BANKNAME='{$D_Bank_Name}', COMPANY_BANKACCOUNT='{$D_Bank_Account}', COMPANY_BANKNUMBER='{$D_Bank_Number}', COMPANY_BANKIBAN='{$D_Bank_IBAN}', COMPANY_BANKBIC='{$D_Bank_BIC}', MODIFIEDBY='{$_SESSION['Username']}' WHERE SETTINGID={$settingID}");
}
Header("Location: {$web}/config/list.php?page={$page}&Order={$Order}&Sort={$Sort}&{$sessname}={$sessid}#{$settingID}");
}
}
}
}
}
}
}
$smarty->display('config/editf_company.tpl');
} else {
if (!empty($MethodOfPaymentDate) && !checkdate($month1, $day1, $year1)) {
$smarty->assign("FieldError", "{$a['date_text']} - {$a['field_error']}");
UserInput("MethodOfPayD.MethodOfPaymentDate");
$smarty->display('invoice/newf.tpl');
} else {
if ($MaxRows <= 0) {
$smarty->assign("FieldError", "{$a['pos_name']} - {$a['field_error']}");
UserInput("");
$smarty->display('invoice/newf.tpl');
} else {
// Database connection
//
DBConnect();
$InvoiceDate = German_Mysql_Date($InvoiceDate);
$MethodOfPaymentDate = German_Mysql_Date($MethodOfPaymentDate);
$query = $db->Execute("SELECT MESSAGEID, DESCRIPTION FROM {$TBLName}message WHERE MESSAGEID={$messageID}");
if (!$query) {
print $db->ErrorMsg();
} else {
foreach ($query as $f) {
$Message_Desc = $f['DESCRIPTION'];
}
}
$query1 = $db->Execute("SELECT METHODOFPAYID, DESCRIPTION FROM {$TBLName}methodofpay WHERE METHODOFPAYID={$MethodOfPayment}");
if (!$query1) {
print $db->ErrorMsg();
} else {
foreach ($query1 as $f1) {
$MethodOfPayment_Desc = $f1['DESCRIPTION'];
}
$TotalExpenditures += $result['EXPENDITURES'];
$Cash_In_Hand_Starting_With += $result['CASH_IN_HAND_STARTING_WITH'];
}
}
$Cash_In_Hand = $Cash_In_Hand_Starting_With + ($TotalTakings - $TotalExpenditures);
// Get min date from cashbook
//
$query2 = $db->GetRow("SELECT MIN(CASHBOOK_DATE) AS MIN_CASHBOOK_DATE FROM {$TBLName}cashbook WHERE CANCELED=2");
if (!$query2) {
print $db->ErrorMsg();
} else {
$Min_Cashbook_Date = $query2['MIN_CASHBOOK_DATE'];
}
// Calculate total takings / expenditures depend on $Min_Cashbook_Date and $CashbookDate
//
$CashbookDate_Till = German_Mysql_Date($CashbookDate);
$query3 = $db->Execute("SELECT CASH_IN_HAND_STARTING_WITH, TAKINGS, EXPENDITURES, CASHBOOK_DATE FROM {$TBLName}cashbook WHERE CANCELED=2 AND TO_DAYS(CASHBOOK_DATE) BETWEEN TO_DAYS('{$Min_Cashbook_Date}') AND TO_DAYS('{$CashbookDate_Till}')");
$Cash_In_Hand_Starting_With_Till = 0;
$TotalExpenditures_Till = 0;
$TotalTakings_Till = 0;
// If an error has occurred, display the error message
//
if (!$query3) {
print $db->ErrorMsg();
} else {
foreach ($query3 as $result3) {
$Cash_In_Hand_Starting_With_Till += $result3['CASH_IN_HAND_STARTING_WITH'];
$TotalExpenditures_Till += $result3['EXPENDITURES'];
$TotalTakings_Till += $result3['TAKINGS'];
}
}
$smarty->assign("Offer_Not_Accepted", $offer_status[1]);
$smarty->assign("Offer_Confirmation", $offer_status[2]);
$smarty->assign("Offer_Invoice", $offer_status[3]);
$smarty->assign("DateFrom", "{$a['date_from']}");
$smarty->assign("DateTill", "{$a['date_till']}");
// Database connection
//
DBConnect();
// Get data from company_settings.inc.php
//
$smarty->assign("Offer_Currency", $CompanyCurrency);
$intCursor = ($page - 1) * $EntrysPerPage;
// Get Offer Information
//
$DateFrom1 = German_Mysql_Date($DateFrom1);
$DateTill1 = German_Mysql_Date($DateTill1);
if (isset($Canceled) && $Canceled == 1) {
$query = $db->Execute("SELECT A.MYID, A.FIRSTNAME, A.LASTNAME, A.COMPANY, O.CREATEDBY, O.OFFERID, O.MYID, DATE_FORMAT(O.OFFER_DATE,'%d.%m.%Y') AS OFFER_DATE, O.INVOICEID, O.TOTAL_AMOUNT, O.STATUS, O.CANCELED, O.METHODOFPAYID, O.NOTE, O.MESSAGEID FROM {$TBLName}offer AS O, {$TBLName}addressbook AS A WHERE O.CANCELED=1 AND A.MYID=O.MYID AND O.OFFERID LIKE '%{$OfferID1}%'\n\t\t\tAND O.MYID LIKE '%{$CustomerID1}' AND O.TOTAL_AMOUNT LIKE '%{$Total1}%' AND ( A.FIRSTNAME LIKE '%{$Customer1}%' OR A.LASTNAME LIKE '%{$Customer1}%' OR A.COMPANY LIKE '%{$Customer1}%' )\n\t\t\tAND O.OFFER_DATE >= '{$DateFrom1}' AND O.OFFER_DATE <= '{$DateTill1}' ORDER BY {$Order} {$Sort} LIMIT {$intCursor}, {$EntrysPerPage}");
} else {
if (isset($Canceled) && $Canceled == 3) {
$query = $db->Execute("SELECT A.MYID, A.FIRSTNAME, A.LASTNAME, A.COMPANY, O.CREATEDBY, O.OFFERID, O.MYID, DATE_FORMAT(O.OFFER_DATE,'%d.%m.%Y') AS OFFER_DATE, O.INVOICEID, O.TOTAL_AMOUNT, O.STATUS, O.CANCELED, O.METHODOFPAYID, O.NOTE, O.MESSAGEID FROM {$TBLName}offer AS O, {$TBLName}addressbook AS A WHERE A.MYID=O.MYID AND O.OFFERID LIKE '%{$OfferID1}%'\n\t\t\tAND O.MYID LIKE '%{$CustomerID1}' AND O.TOTAL_AMOUNT LIKE '%{$Total1}%' AND ( A.FIRSTNAME LIKE '%{$Customer1}%' OR A.LASTNAME LIKE '%{$Customer1}%' OR A.COMPANY LIKE '%{$Customer1}%' )\n\t\t\tAND O.OFFER_DATE >= '{$DateFrom1}' AND O.OFFER_DATE <= '{$DateTill1}' ORDER BY {$Order} {$Sort} LIMIT {$intCursor}, {$EntrysPerPage}");
} else {
$query = $db->Execute("SELECT A.MYID, A.FIRSTNAME, A.LASTNAME, A.COMPANY, O.CREATEDBY, O.OFFERID, O.MYID, DATE_FORMAT(O.OFFER_DATE,'%d.%m.%Y') AS OFFER_DATE, O.INVOICEID, O.TOTAL_AMOUNT, O.STATUS, O.CANCELED, O.METHODOFPAYID, O.NOTE, O.MESSAGEID FROM {$TBLName}offer AS O, {$TBLName}addressbook AS A WHERE O.CANCELED=2 AND A.MYID=O.MYID AND O.OFFERID LIKE '%{$OfferID1}%'\n\t\t\tAND O.MYID LIKE '%{$CustomerID1}' AND O.TOTAL_AMOUNT LIKE '%{$Total1}%' AND ( A.FIRSTNAME LIKE '%{$Customer1}%' OR A.LASTNAME LIKE '%{$Customer1}%' OR A.COMPANY LIKE '%{$Customer1}%' )\n\t\t\tAND O.OFFER_DATE >= '{$DateFrom1}' AND O.OFFER_DATE <= '{$DateTill1}' ORDER BY {$Order} {$Sort} LIMIT {$intCursor}, {$EntrysPerPage}");
}
}
// If an error has occurred, display the error message
//
if (!$query) {
print $db->ErrorMsg();
} else {
// Count only PageRows
$query1 = $db->Execute("SELECT FIRSTNAME, LASTNAME, ADDRESS, POSTALCODE, CITY FROM {$TBLName}addressbook WHERE FIRSTNAME='{$firstname}' AND LASTNAME='{$lastname}' AND ADDRESS='{$address}' AND POSTALCODE='{$postalcode}' AND CITY='{$city}'");
$numrows1 = $query1->RowCount();
$query2 = $db->Execute("SELECT DECODE(USERNAME,'{$pkey}') AS USERNAME FROM {$TBLName}addressbook WHERE DECODE(USERNAME,'{$pkey}')='{$username}'");
$numrows2 = $query2->RowCount();
if ($numrows1) {
$smarty->assign("FieldError", "{$a['entry_exist']}");
UserInput("");
$smarty->display('addressbook/newf.tpl');
} else {
if (!empty($UserName) && $numrows2) {
$smarty->assign("FieldError", "{$a['entry_exist']} -> {$a['username']}");
UserInput("username");
$smarty->display('addressbook/newf.tpl');
} else {
list($day, $month, $year) = explode(".", $birthday);
$birthday = German_Mysql_Date($birthday);
$query3 = "INSERT INTO {$TBLName}addressbook (MYID, PRINT_NAME, PREFIX, FIRSTNAME, LASTNAME, TITLE, COMPANY, DEPARTMENT, ADDRESS, CITY, STATEPROV, POSTALCODE, COUNTRY, POSITION, INITIALS, SALUTATION, PHONEHOME, PHONEOFFI, PHONEOTHE, PHONEWORK, MOBILE, PAGER, FAX, EMAIL, URL, NOTE, CHANGELOG, ALTFIELD1, ALTFIELD2, URL2, EMAIL2, CATEGORY, METHODOFPAY, MESSAGE, BIRTHDAY, BANKNAME, BANKACCOUNT, BANKNUMBER, BANKIBAN, BANKBIC, TAX_FREE, TAXNR, BUSINESS_TAXNR, USERNAME, PASSWORD, USERLANGUAGE, USER_ACTIVE, CREATEDBY, MODIFIEDBY, USERGROUP1, USERGROUP2, CREATED, MODIFIED)";
$query3 .= "VALUES (NULL, '{$printname}', '{$prefix}', '{$firstname}', '{$lastname}', '{$title}', '{$company}', '{$department}', '{$address}', '{$city}', '{$stateprov}', '{$postalcode}', '{$country}', '{$position}', '{$initials}', '{$salutation}', '{$phonehome}', '{$phoneoffi}', '{$phoneothe}', '{$phonework}', '{$mobile}', '{$pager}', '{$fax}', '{$email}', '{$url}', '{$note}', '{$changelog}', '{$altfield1}', '{$altfield2}', '{$url2}', '{$email2}', '{$category}', '{$methodofpayment}', '{$message}', '{$birthday}', '{$bankname}', '{$bankaccount}', '{$banknumber}', '{$bankiban}', '{$bankbic}', '2', '{$taxnr}', '{$businesstaxnr}', ENCODE('{$username}','{$pkey}'), ENCODE('{$password1}','{$pkey}'), '{$userlanguage}', '{$useractive}', '{$_SESSION['Username']}', '{$_SESSION['Username']}', '{$_SESSION['Usergroup1']}', '{$_SESSION['Usergroup2']}', '{$CurrentDateTime}', '{$CurrentDateTime}')";
if ($db->Execute($query3) === false) {
die($db->ErrorMsg());
}
$_SESSION['NewID'] = "1";
Header("Location: {$web}/addressbook/new.php?page={$page}&infoID={$infoID}&Order={$Order}&Sort={$Sort}&{$sessname}={$sessid}");
}
}
}
}
}
}
}
}
