Jump to content
xt:Commerce Community Forum

Firmenname im Adminbereich anzeigen


snwue

Recommended Posts

Habs leider nur in English - wenn Du Hilfe brauchst -> PM

Gibt Kundenname und Nummer aus....

Gruß,

Uwe

Customer Number and Company in admin area - Customers

Date: 2007-03-09

xt-Commerce version: 3.04 SP2

Files affected:

/lang/english/admin/english.php

/lang/german/admin/german.php

/admin/customers.php

1.) Open file /lang/english/admin/english.php

- Go to the end

- Insert before the last "?>" this

define('TABLE_HEADING_CUSTOMERSCID','Customer #');

define('TABLE_HEADING_COMPANY','Customer');

2.) Open file /lang/german/admin/german.php

- Go to the end

- Insert before the last "?>" this:

define('TABLE_HEADING_CUSTOMERSCID','Kunden #');

define('TABLE_HEADING_COMPANY','Kunde');

3.) Open file /admin/customers.php

Find:

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_FIRSTNAME.xtc_sorting(FILENAME_CUSTOMERS,'customers_firstname'); ?></td>

- Insert right after this line (probably 958) this:

<!-- Customer # -->

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERSCID; ?></td>

<!-- Customer # -->

<!-- Company -->

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_COMPANY; ?></td>

<!-- Company -->

4.) Find this block:

$customers_query_raw = "select

c.account_type,

c.customers_id,

c.customers_vat_id,

c.customers_vat_id_status,

c.customers_lastname,

c.customers_firstname,

c.customers_email_address,

a.entry_country_id,

c.customers_status,

c.member_flag,

ci.customers_info_date_account_created

from

".TABLE_CUSTOMERS." c ,

".TABLE_ADDRESS_BOOK." a,

".TABLE_CUSTOMERS_INFO." ci

Where

c.customers_id = a.customers_id

and c.customers_default_address_id = a.address_book_id

and ci.customers_info_id = c.customers_id

".$search."

group by c.customers_id

".$sort;

Insert after row: c.customers_firstname,

this: c.customers_cid,

And after row: a.entry_country_id,

this: a.entry_company,

so that the entire block looks like this:

$customers_query_raw = "select

c.account_type,

c.customers_id,

c.customers_vat_id,

c.customers_vat_id_status,

c.customers_lastname,

c.customers_firstname,

c.customers_cid,

c.customers_email_address,

a.entry_country_id,

a.entry_company,

c.customers_status,

c.member_flag,

ci.customers_info_date_account_created

from

".TABLE_CUSTOMERS." c ,

".TABLE_ADDRESS_BOOK." a,

".TABLE_CUSTOMERS_INFO." ci

Where

c.customers_id = a.customers_id

and c.customers_default_address_id = a.address_book_id

and ci.customers_info_id = c.customers_id

".$search."

group by c.customers_id

".$sort;

5.) Find:

<td class="dataTableContent"><?php echo $customers['customers_firstname']; ?></td>

- Insert right after this line (probably 1074) this:

<!-- Customer # -->

<td class="dataTableContent"><?php echo $customers['customers_cid']; ?></td>

<!-- Customer # -->

<!-- Company -->

<td class="dataTableContent"><?php echo $customers['entry_company']; ?></td>

<!-- Company -->

Upload all three files - done.

Link to comment
Share on other sites

Damit bekommst Du aber den Frimen-/Kundennamen.

Wenn Du andere Dinge wie Vor-, Nachname oder die Nummer nicht brauchst kommentierst Du einfach die anderen Spalten aus.

ggf. kannst Du den Firmennamen auch noch Fett machen..

Oder versteh ich was falsch?

Link to comment
Share on other sites

also ich hab

Konto,Kdn-Nr,Nachname,Vorname,Kundengruppe,Ust-ID,Zugang erstellt am,Aktion

und davon könnte ich z.b. konto nicht gebrauchen. also wenn anstelle konto der firmenname erscheinen würde würde es optimal sein.

wie mache ich das?

Link to comment
Share on other sites

Company name before Name in admin area - Customers

Date: 2007-03-13

xt-Commerce version: 3.04 SP2

Files affected:

/lang/english/admin/english.php

/lang/german/admin/german.php

/admin/customers.php

1.) Open file /lang/english/admin/english.php

- Go to the end

- Insert before the last "?>" this

define('TABLE_HEADING_CUSTOMERSCID','Customer #');

define('TABLE_HEADING_COMPANY','Customer');

2.) Open file /lang/german/admin/german.php

- Go to the end

- Insert before the last "?>" this:

define('TABLE_HEADING_CUSTOMERSCID','Kunden #');

define('TABLE_HEADING_COMPANY','Kunde');

3.) Open file /admin/customers.php

Find this codeblock:

<tr class="dataTableHeadingRow">

<td class="dataTableHeadingContent" width="40"><?php echo TABLE_HEADING_ACCOUNT_TYPE; ?></td>

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LASTNAME.xtc_sorting(FILENAME_CUSTOMERS,'customers_lastname'); ?></td>

- and replace by this:

<tr class="dataTableHeadingRow">

<!-- Company -->

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_COMPANY; ?></td>

<!-- Company -->

<!-- <td class="dataTableHeadingContent" width="40"><?php echo TABLE_HEADING_ACCOUNT_TYPE; ?></td>-->

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LASTNAME.xtc_sorting(FILENAME_CUSTOMERS,'customers_lastname'); ?></td>

4.) Find this block:

$customers_query_raw = "select

c.account_type,

c.customers_id,

c.customers_vat_id,

c.customers_vat_id_status,

c.customers_lastname,

c.customers_firstname,

c.customers_email_address,

a.entry_country_id,

c.customers_status,

c.member_flag,

ci.customers_info_date_account_created

from

".TABLE_CUSTOMERS." c ,

".TABLE_ADDRESS_BOOK." a,

".TABLE_CUSTOMERS_INFO." ci

Where

c.customers_id = a.customers_id

and c.customers_default_address_id = a.address_book_id

and ci.customers_info_id = c.customers_id

".$search."

group by c.customers_id

".$sort;

Insert after row: c.customers_firstname,

this: c.customers_cid,

And after row: a.entry_country_id,

this: a.entry_company,

so that the entire block looks like this:

$customers_query_raw = "select

c.account_type,

c.customers_id,

c.customers_vat_id,

c.customers_vat_id_status,

c.customers_lastname,

c.customers_firstname,

c.customers_cid,

c.customers_email_address,

a.entry_country_id,

a.entry_company,

c.customers_status,

c.member_flag,

ci.customers_info_date_account_created

from

".TABLE_CUSTOMERS." c ,

".TABLE_ADDRESS_BOOK." a,

".TABLE_CUSTOMERS_INFO." ci

Where

c.customers_id = a.customers_id

and c.customers_default_address_id = a.address_book_id

and ci.customers_info_id = c.customers_id

".$search."

group by c.customers_id

".$sort;

5.) Find this codeblock:

if ($customers['account_type'] == 1) {

echo '<td class="dataTableContent">';

echo TEXT_GUEST;

} else {

echo '<td class="dataTableContent">';

echo TEXT_ACCOUNT;

}

?></td>

<td class="dataTableContent"><b><?php echo $customers['customers_lastname']; ?></b></td>

- and replace by this:

/*

if ($customers['account_type'] == 1) {

echo '<td class="dataTableContent">';

echo TEXT_GUEST;

} else {

echo '<td class="dataTableContent">';

echo TEXT_ACCOUNT;

}

*/

?></td>

<!-- Company -->

<td class="dataTableContent"><?php echo $customers['entry_company']; ?></td>

<!-- Company -->

<td class="dataTableContent"><b><?php echo $customers['customers_lastname']; ?></b></td>

6.) Upload all three files - done.

Link to comment
Share on other sites

  • 8 months later...

Gibt Kundenname und Nummer aus....

Gruß,

Uwe [...]

Upload all three files - done.

Vielen Dank für diese Anleitung... genau das brauchte ich :-) Funktioniert super.

Eine ergänzende Frage noch dazu: Kann ich das auch so einstellen, dass nach der Firma sortiert wird oder sortiert werden kann? Und in die Suchfunktion wird das Feld Firma leider auch nicht einbezogen. Geht das auch irgendwie mit vertretbarem Aufwand?

Danke und Gruß

Catharina

Link to comment
Share on other sites

  • 1 year later...

Archived

This topic is now archived and is closed to further replies.

×
  • Create New...