VAT-mod for European companies

**Beez** · 10 Jan 2008, 03:54 PM

Originally Posted by joachimp

Also wondering about version 1.3.8

I found that there is a duplicated function called zen_address_format()
on functions_customers.php
and general.php

functions_customers.php is from the catalog files and the and the is from admin. Are you sure you got the right files in the right directory? or has there been changes in 1.3.8?

We have not tested with Zen Cart 1.3.8, yet, but we will do it as soon as we got the time. If anyone does install it on 1.3.8, please report your finding.

**joachimp** · 10 Jan 2008, 04:05 PM

Hi,
I'm doing a full restore, maybe I did made a mistake... I will let you know...

Joachim

**joachimp** · 10 Jan 2008, 04:28 PM

Same deal, when trying to log in on the admin part I get the following:

Fatal error: Cannot redeclare zen_address_format() (previously declared in /www/zencart/admin/includes/functions/general.php:470) in /www/zencart/admin/includes/functions/functions_customers.php on line 35

zencart2 is before installing the mod, zencart is with the mod.

shrek:/www/zencart2/admin/includes/functions# regrep zen_address_format
./functions_customers.php:35: function zen_address_format($address_format_id, $address, $html, $boln, $eoln) {
./functions_customers.php:134: return zen_address_format($format_id, $address->fields, $html, $boln, $eoln);
./general.php:465: function zen_address_format($address_format_id, $address, $html, $boln, $eoln) {

shrek:/www/zencart2/admin/includes/functions#
shrek:/www/zencart2/admin/includes/functions#
shrek:/www/zencart2/admin/includes/functions#
shrek:/www/zencart2/admin/includes/functions# cd /www/zencart/admin/includes/functions/

shrek:/www/zencart/admin/includes/functions# regrep zen_address_format
./functions_customers.php:35: function zen_address_format($address_format_id, $address, $html, $boln, $eoln) {
./functions_customers.php:134: return zen_address_format($format_id, $address->fields, $html, $boln, $eoln);
./general.php:470: function zen_address_format($address_format_id, $address, $html, $boln, $eoln) {
shrek:/www/zencart/admin/includes/functions#

I will do some further digging...

**martyndw2005** · 13 Jan 2008, 03:10 PM

Extra figures appearing on invoice page in admin

On the attachment we have circled two areas - we need to get rid of these but cannot work out what they are called so cannot find similar problems on zencart. They only started appearing after we recently installed the European VAT Module - do you have any ideas how we could delete/remove these from invoices?

other conversation about this
http://www.zen-cart.com/forum/showth...hlight=invoice

We have compared files and everything seems fine.

Please help is anyone else getting this problem?

**martyndw2005** · 13 Jan 2008, 03:13 PM

This is the code for invoice.php in our admin folder.

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce |
// +----------------------------------------------------------------------+
// | Copyright (c) 2006 The zen-cart developers |
// | |
// | http://www.zen-cart.com/index.php |
// | |
// | Portions Copyright (c) 2003 osCommerce |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license, |
// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.zen-cart.com/license/2_0.txt. |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to |
// | [email protected] so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
// $Id: invoice.php 6524 2007-06-25 21:27:46Z drbyte $
//

require('includes/application_top.php');

require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();

$oID = zen_db_prepare_input($_GET['oID']);

include(DIR_WS_CLASSES . 'order.php');
$order = new order($oID);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/menu.js"></script>
<script language="javascript" type="text/javascript"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">


<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"></td>
<td class="pageHeading" align="right"></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2"><?php echo zen_draw_separator(); ?></td>
</tr>

<?php
$order_check = $db->Execute("select cc_cvv, customers_name, customers_company, customers_street_address,
customers_suburb, customers_city, customers_postcode,
customers_state, customers_country, customers_telephone,
customers_email_address, customers_address_format_id, delivery_name,
delivery_company, delivery_street_address, delivery_suburb,
delivery_city, delivery_postcode, delivery_state, delivery_country,
delivery_address_format_id, billing_name, billing_company, billing_tva_intracom,
billing_street_address, billing_suburb, billing_city, billing_postcode,
billing_state, billing_country, billing_address_format_id,
payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
currency_value, date_purchased, orders_status, last_modified
from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'"); // TVA_INTRACOM
$show_customer = 'false';
if ($order_check->fields['billing_name'] != $order_check->fields['delivery_name']) {
$show_customer = 'true';
}
if ($order_check->fields['billing_street_address'] != $order_check->fields['delivery_street_address']) {
$show_customer = 'true';
}
if ($show_customer == 'true') {
?>
<tr>
<td class="main"><b><?php echo ENTRY_CUSTOMER; ?></b></td>
</tr>
<tr>
<td class="main"><?php echo zen_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>
</tr>
<?php } ?>
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_SOLD_TO; ?></td>
</tr>
<tr>

<td class="main"><?php echo zen_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>

</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
</tr>

<tr>
<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?> <?php echo $order->customer['telephone']; ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_EMAIL_ADDRESS; ?> <?php echo '<a href="mailto:' . $order->customer['email_address'] . '">' . $order->customer['email_address'] . '</a>'; ?></td>
</tr>


<?php if (zen_not_null($order_check->fields['billing_tva_intracom'])) { ?>
<tr>
<td class="main"><b><?php echo ENTRY_TVA_INTRACOM; ?></b> <?php echo $order_check->fields['billing_tva_intracom']; ?></td>
</tr>
<?php } ?>

</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_SHIP_TO; ?></td>
</tr>
<tr>
<td class="main"><?php echo zen_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>

<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<tr>
<td class="main"><b></b></td>
<td class="main"><?php echo TVA_SHOP_INTRACOM; ?></td>
</tr>
</table></td>
</tr>

<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_ORDER_ID . $oID; ?></td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_DATE_PURCHASED; ?></td>
<td class="main"><?php echo zen_date_long($order->info['date_purchased']); ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_PAYMENT_METHOD; ?></td>
<td class="main"><?php echo $order->info['payment_method']; ?></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>
<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>
</tr>
<?php
for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
echo ' <tr class="dataTableRow">' . "\n" .
' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .
' <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];

if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) {
for ($j = 0; $j < $k; $j++) {
echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . nl2br($order->products[$i]['attributes'][$j]['value']);
if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
if ($order->products[$i]['attributes'][$j]['product_attribute_is_free'] == '1' and $order->products[$i]['product_is_free'] == '1') echo TEXT_INFO_ATTRIBUTE_FREE;
echo '</i></small></nobr>';
}
}

echo ' </td>' . "\n" .
' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";
echo ' <td class="dataTableContent" align="right" valign="top">' . zen_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><b>' .
$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) .
($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format($order->products[$i]['onetime_charges'], true, $order->info['currency'], $order->info['currency_value']) : '') .
'</b></td>' . "\n" .
// TVA_INTRACOM you may replace 'zen_add_tax' with 'zen_add_tax_invoice' below to unconditionally add tax to a products price.
$currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) .
// TVA_INTRACOM you may replace 'zen_add_tax' with 'zen_add_tax_invoice' below to unconditionally add tax to a products price.
($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format(zen_add_tax($order->products[$i]['onetime_charges'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) : '') .
'</b></td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><b>' .
$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) .
($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format($order->products[$i]['onetime_charges'], true, $order->info['currency'], $order->info['currency_value']) : '') .
'</b></td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><b>' .
// TVA_INTRACOM you may replace 'zen_add_tax' with 'zen_add_tax_invoice' below to unconditionally add tax to a products price.
$currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) .
// TVA_INTRACOM you may replace 'zen_add_tax' with 'zen_add_tax_invoice' below to unconditionally add tax to a products price.
($order->products[$i]['onetime_charges'] != 0 ? '<br />' . $currencies->format(zen_add_tax($order->products[$i]['onetime_charges'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) : '') .
'</b></td>' . "\n";
echo ' </tr>' . "\n";
}
?>
<tr>
<td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
</table></td>
</tr>
</table></td>
</tr>
</table>
<?php
//--Add comments starts--
$orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($oID) . "'
order by date_added limit 1");
//--Add comments ends--
?>
<?php

<tr><td class="main"><?php echo '<b>Customer comments: </b>' . $orders_history->fields['comments']; ?></td>
</tr>

?>
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

**marksu** · 19 Jan 2008, 10:18 PM

I found a small bug in VAT-Mod 1.2.5.

File vatmod.php was place in false directory.

admin/includes/languages/extra_definitions/vatmod.php

BUT SHOULD HAVE BEEN IN

admin/includes/languages/english/extra_definitions/vatmod.php

marksu

**pe7er** · 6 Feb 2008, 12:07 PM

Originally Posted by martyndw2005

Extra figures appearing on invoice page in admin
On the attachment we have circled two areas - we need to get rid of these but cannot work out what they are called so cannot find similar problems on zencart. They only started appearing after we recently installed the European VAT Module - do you have any ideas how we could delete/remove these from invoices?
Please help is anyone else getting this problem?

I had the same problem. First it seemed that the total column appeared above the list.
But if you look at the figures you will see that it's not the total column that is out of place, but the unit price (look at the row where you've ordered multiple items).
In my case there was a missing <tr> or <td> tag somewhere...

**keon** · 8 Feb 2008, 02:43 AM

I get this funny message at the top of the page, when trying to register as a new customer, with a valid VAT number:

Warning: file_get_contents() expects at most 2 parameters, 3 given in /var/www/html/cart/includes/functions/extra_functions/functions_vatmod.php on line 77

I have PHP 4.3.9, ZC 1.3.7.1 and the latest VAT-mod.

Also, I can't seem to find where to manually validate users VAT numbers in the admin section?

Any idea?

**dimjoula** · 16 Feb 2008, 02:06 PM

VAT-Mod 1.2.7beta for Zen Cart v. 1.3.8
For Companies inside European Union dealing with european sales tax.

IMPORTANT NOTE: THIS IS NOTE THE OFFICIAL RELEASE FROM Beez & Vike.
IT IS A *BETA* VERSION.

I did a simple Cut and Paste from the previous code VAT-Mod 1.2.6 for Zen Cart v. 1.3.7) and paste it to Zen Cart v. 1.3.8 files.

It works for me, but you should take it with cautious.

What's new:

Compatibility with Zen Cart v. 1.3.8
adding Bulgaria and Romania to the list
french translation
update of the VIES link to check the validity of the number

I hope that Beez & Vike will offer an official release soon.

And thanks guys for your great help !!

**neonsun** · 16 Feb 2008, 05:17 PM

Dimjoula: thank you very much
All seems to be working ok, except a PHP4 problem with VAT verification process in function zen_verif_tva, where is used file_get_contents with $context parametr, which is supported from PHP5.
I know it's weird to use PHP4 in the age of PHP6 coming :-)

Thread: VAT-mod for European companies

Thread Tools

Search Thread

Display

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Re: VAT-mod for European companies

Similar Threads

v138a VAT mod for european companies on ZC 1.5

VAT MOD for EU Countries Support

Is it possible to have tax exemption with VAT-mod for European companies?

"VAT for companies" mode with checkout without account mode

Bookmarks

Bookmarks

Posting Permissions