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