Company line of customer address

[afthrscomputers]

Company line of address (anywhere in store or order emails) cannot be moved...

What is displayed:
BK Transport (Company)
Steven Jackson Jnr (Name)
1236 new street
Elk Grove
HI 94534
United States

What is required:
Steven Jackson Jnr (Name)
BK Transport (Company)
1236 new street
Elk Grove
HI 94534
United States

Adding $company to address_format @ sql database results in:
BK Transport (Company)
Steven Jackson Jnr (Name)
BK Transport (Company)
1236 new street
Elk Grove
HI 94534
United States


Help ! ? ! ?

Many Thanks,
Matt

[jpf]

Yes it can be moved - don't add a feild in MYSQL.
Find the code in the TEMPLATE directory and move it.

Like in create_account.tpl.php

Line 80....
<?php
if (ACCOUNT_COMPANY == 'true') {
....
<?php
}
?>
(line 109)
MOVE to say line 44 would move the company name above the name...

Now email are much the same - find the code and move it....

Not sure which email your thinking of but a search for the unique text (for just that email) in the language files will get you the variable - find the varible in the site you found the code you need to look at...

Good Luck

[afthrscomputers]

Thanks for your reply jpf but i think you have missed my point... I shall explain a bit more..

Pic 1 - Correct layout, how it should be displayed on all account/checkout pages and order emails...


Pic 2 - Address layout puts the Company -ABOVE- the First Name, not below it as desired...


Pic 3 - Order email puts the Company above the First Name again...


I have searched and searched with UltraEdit and moved snippits of code everywhere but still no luck. Starting to go grey over this one as i have had no trouble customising any of my stores before.

Thanks
Matt

[jpf]

Yes your right.... it call a fuction from general.php called: tep_address_format

In that fuction generated the address format...modify the fuction...

  function tep_address_format($address_format_id, $address, $html, $boln, $eoln) {
    $address_format_query = tep_db_query("select address_format as format from " . TABLE_ADDRESS_FORMAT . " where address_format_id = '" . (int)$address_format_id . "'");
    $address_format = tep_db_fetch_array($address_format_query);

    $company = tep_output_string_protected($address['company']);
    if (isset($address['firstname']) && tep_not_null($address['firstname'])) {
      $firstname = tep_output_string_protected($address['firstname']);
      $lastname = tep_output_string_protected($address['lastname']);
    } elseif (isset($address['name']) && tep_not_null($address['name'])) {
      $firstname = tep_output_string_protected($address['name']);
      $lastname = '';
    } else {
      $firstname = '';
      $lastname = '';
    }
    $street = tep_output_string_protected($address['street_address']);
    $suburb = tep_output_string_protected($address['suburb']);

to

  function tep_address_format($address_format_id, $address, $html, $boln, $eoln) {
    $address_format_query = tep_db_query("select address_format as format from " . TABLE_ADDRESS_FORMAT . " where address_format_id = '" . (int)$address_format_id . "'");
    $address_format = tep_db_fetch_array($address_format_query);

    if (isset($address['firstname']) && tep_not_null($address['firstname'])) {
      $firstname = tep_output_string_protected($address['firstname']);
      $lastname = tep_output_string_protected($address['lastname']);
    } elseif (isset($address['name']) && tep_not_null($address['name'])) {
      $firstname = tep_output_string_protected($address['name']);
      $lastname = '';
    } else {
      $firstname = '';
      $lastname = '';
    }
    $company = tep_output_string_protected($address['company']);
    $street = tep_output_string_protected($address['street_address']);
    $suburb = tep_output_string_protected($address['suburb']);

Good Luck

[afthrscomputers]

Thanks again jpf.

I had previously edited "general.php" (using UltraEdit search) as per your recommendation before my last-gasp post here.

Heres what i have now....

=
Company ABOVE Name in 'general.php' results in:

BK Transport
Steven Jackson
1236 new street

(3 lines, wrong)

=
Company BELOW Name in 'general.php' results in:

BK Transport
Steven Jackson
1236 new street

(3 lines, no change)

=
Commented ( // ) Company in 'general.php' results in:

Steven Jackson
1236 new street

(2 lines, nothing displayed)

=
Adding '$company' to 'address_format' @ sql results in:

BK Transport
Steven Jackson
BK Transport
1236 new street

(4 lines, duplicate entry)

=
Adding '$company' to 'address_format' @ sql and commented company line:

Steven Jackson

1236 new street

(3 lines, blank line NOT a typo.)

=
The SQL line from 'address_format'.

$firstname $lastname$cr$streets$cr$city$cr$state $postcode$cr$country

Lines 432->465 of 'general.php'.

// Return a formatted address
// TABLES: address_format
function tep_address_format($address_format_id, $address, $html, $boln, $eoln) { 
    $address_format_query = tep_db_query("select address_format as format from " . TABLE_ADDRESS_FORMAT . " where address_format_id = '" . (int)$address_format_id . "'"); 
    $address_format = tep_db_fetch_array($address_format_query); 

    if (isset($address['firstname']) && tep_not_null($address['firstname'])) { 
      $firstname = tep_output_string_protected($address['firstname']); 
      $lastname = tep_output_string_protected($address['lastname']); 
    } elseif (isset($address['name']) && tep_not_null($address['name'])) { 
      $firstname = tep_output_string_protected($address['name']); 
      $lastname = ''; 
    } else { 
      $firstname = ''; 
      $lastname = ''; 
    } 
    $company = tep_output_string_protected($address['company']); 
    $street = tep_output_string_protected($address['street_address']); 
    $suburb = tep_output_string_protected($address['suburb']);
    $city = tep_output_string_protected($address['city']);
    $state = tep_output_string_protected($address['state']);
    if (isset($address['country_id']) && tep_not_null($address['country_id'])) {
      $country = tep_get_country_name($address['country_id']);

      if (isset($address['zone_id']) && tep_not_null($address['zone_id'])) {
        $state = tep_get_zone_code($address['country_id'], $address['zone_id'], $state);
      }
    } elseif (isset($address['country']) && tep_not_null($address['country'])) {
      $country = tep_output_string_protected($address['country']);
    } else {
      $country = '';
    }
    $postcode = tep_output_string_protected($address['postcode']);
    $zip = $postcode;

Thanks again, Matt

[jpf]

Okay delve a lot more and followed the code/fuctions.....

Address is setup as in your ADMIN setting, ONLY 4 options - all NOT including company name......

Option 1: Add another format
SQL:
insert into address_format (address_format_id, address_format, address_summary) values ('5', '$firstname $lastname$cr$company$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country');

and remove/comment out in general.php line 527-529
// if ( (ACCOUNT_COMPANY == 'true') && (tep_not_null($company)) ) {
// $address = $company . $cr . $address;
// }

Works????

Option 2: Change just general.php line 527-529 to---

if ( (ACCOUNT_COMPANY == 'true') && (tep_not_null($company)) ) {
// $address = $company . $cr . $address;
$address = $firstname . $lastname . $cr . $company . $cr . $streets . $cr . $city . ", " . $statecomma . $postcode . $cr . $country;
}

Which should work to produce...

Steven Jackson
BK Transport
1236 new street
MyState, ST
12345
Farfarawaycountry


What a pain in the a$$....