osCommerce Community Support Forums: Configurando adicionando criando Complemento e Numero no PAGSEGURO - osCommerce Community Support Forums

Jump to content

Corporate Sponsors (view more of our hosting, developer, and service partners)


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Configurando adicionando criando Complemento e Numero no PAGSEGURO adicionando criando os campos numero e complemento no pagseguro. Rate Topic: -----

#1 User is offline   souzadavi Icon

  • Find Posts
  • Group: Community Member
  • Posts: 60
  • Joined: 02-August 03
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 30 June 2008 - 09:29 PM

Pessoal aq esta um pedaço da solução para a pessoa cadastrar o complemento e o numero na hora de criar a conta possibilitando o preenchimento automatico no pagseguro.


ABAIXO SEGUE INFO:::::::::::


Para adicionar número e complemento novo campo, é necessário alterar os arquivos:

- catalog/create_account.php
- catalog/checkout_process.php
- catalog/includes/classes/order.php
- catalog/includes/modules/payment/pagseguro.php




SQL >>> NO BANCO DE DADOS ::::
TABELA

address_book
crie os campos após - ----- entry_lastname
- entry_number_address --- varchar 64
- entry_comple_address --- varchar 64

orders
crie os campos após - ----- customers_street_address
- customers_number_address --- varchar 64
- customers_comple_address --- varchar 64

crie os campos após ----- delivery_street_address
- delivery_number_address --- varchar 64
- delivery_comple_address --- varchar 64

crie os campor após ----- billing_street_address
- billing_number_address --- varchar 64
- billing_comple_address --- varchar 64








:::::::::::::::::::::: create_account.php

PROCURE POR:
$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);


SUBSTITUA POR
$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
$number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']);
$comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']);
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => $street_address,

SUBSTITUIA:
'entry_street_address' => $street_address,
'entry_number_address' => $number_address,
'entry_comple_address' => $comple_address,
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
<tr>
<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('street_address') . '&nbsp;' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>

SUBSTITUE POR:
<tr>
<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('street_address') . '&nbsp;' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>

<tr>
<td class="main"><?php echo ENTRY_NUMBER_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('number_address') . '&nbsp;' . (tep_not_null(ENTRY_NUMBER_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_NUMBER_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_COMPLE_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('comple_address') . '&nbsp;' . (tep_not_null(ENTRY_COMPLE_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_COMPLE_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>







::::::::::::::::::::::: checkout_process.php

PROCURE:
'customers_street_address' => $order->customer['street_address'],

SUBSTITUA POR:
'customers_street_address' => $order->customer['street_address'],
'customers_number_address' => $order->customer['number_address'],
'customers_comple_address' => $order->customer['comple_address'],


//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'delivery_street_address' => $order->delivery['street_address'],

SUBSTITUA POR:
'delivery_street_address' => $order->delivery['street_address'],
'delivery_number_address' => $order->delivery['number_address'],
'delivery_comple_address' => $order->delivery['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'billing_street_address' => $order->billing['street_address'],

SUBSITUIA POR:
'billing_street_address' => $order->billing['street_address'],
'billing_number_address' => $order->billing['number_address'],
'billing_comple_address' => $order->billing['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>








:::::::::::::::::::::::::::::: catalog/includes/classes/order.php

PROCURE POR:
customers_company, customers_street_address,

SUBSTITUIA POR:
customers_company, customers_street_address, customers_number_address, customers_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
delivery_company, delivery_street_address,

SUBSTITUA POR:
delivery_company, delivery_street_address, delivery_number_address, delivery_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
billing_company, billing_street_address,

SUBSTITUA POR:
billing_company, billing_street_address, billing_number_address, billing_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'street_address' => $order['customers_street_address'],

SUBSTITUA POR:
'street_address' => $order['customers_street_address'],
'number_address' => $order['customers_number_address'],
'comple_address' => $order['customers_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $order['delivery_street_address'],

SUBSTITUA POR:
'street_address' => $order['delivery_street_address'],
'number_address' => $order['delivery_number_address'],
'comple_address' => $order['delivery_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $order['billing_street_address'],

SUBSTITUA POR:
'street_address' => $order['billing_street_address'],
'number_address' => $order['billing_number_address'],
'comple_address' => $order['billing_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address,

ab.entry_company, ab.entry_street_address,

SUBSTITUA POR:
$customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address,

ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => $sendto['street_address'],

SUBSTITUA POR:
'entry_street_address' => $sendto['street_address'],
'entry_number_address' => $sendto['number_address'],
'entry_comple_address' => $sendto['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

SUBSTITUA POR:
$shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => null,

SUBSTITUA POR:
'entry_street_address' => null,
'entry_number_address' => null,
'entry_comple_address' => null,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'entry_street_address' => $billto['street_address'],

SUBSTITUA POR:
'entry_street_address' => $billto['street_address'],
'entry_number_address' => $billto['number_address'],
'entry_comple_address' => $billto['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

SUBSTITUE POR:
$billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $customer_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $customer_address['entry_street_address'],
'number_address' => $customer_address['entry_number_address'],
'street_comple' => $customer_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $shipping_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $shipping_address['entry_street_address'],
'number_address' => $shipping_address['entry_number_address'],
'comple_address' => $shipping_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'street_address' => $billing_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $billing_address['entry_street_address'],
'number_address' => $billing_address['entry_number_address'],
'comple_address' => $billing_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address,

SUBSTITUE POR:
$order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_number_address,

customers_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>




::::::::::::::::::::::::: pagseguro.php

PROCURE POR:
'street_address' => $customer_address['entry_street_address'],

SUBSTITUIE POR:
'customers_street_address' => $order->customer['street_address'],
'customers_number_address' => $order->customer['number_address'],
'comple_address' => $customer_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'delivery_street_address' => $order->delivery['street_address'],

SUBSTITUIR POR:
'delivery_street_address' => $order->delivery['street_address'],
'delivery_number_address' => $order->delivery['number_address'],
'delivery_comple_address' => $order->delivery['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
billing_street_address' => $order->billing['street_address'],
SUBSTITUIE POR:
'billing_street_address' => $order->billing['street_address'],
'billing_number_address' => $order->billing['number_address'],
'billing_comple_address' => $order->billing['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$cust_num = "s/n";
$cust_compl = "casa2";

SUBSTITUIE POR:
// $cust_num = "s/n";
// $cust_compl = "casa2";

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
//tep_draw_hidden_field('cliente_num', $cust_num) . "\n" .
//tep_draw_hidden_field('cliente_compl', $cust_compl) . "\n" .

SUBSTITUIE POR:
tep_draw_hidden_field('cliente_num', $order->delivery['number_address']) . "\n" .
tep_draw_hidden_field('cliente_compl', $order->delivery['comple_address']) . "\n" .

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>



Com esta informação o cliente ao se cadastrar adiciona o numero de seu endereço e o complemento, e estas informações são enviadas para o pagseguro.... para contas novas....


qualquer dúvida posta ai....
Davi S Souza
0

#2 User is offline   cafumbira Icon

  • Find Posts
  • Group: Community Member
  • Posts: 3
  • Joined: 16-June 08
  • Real Name:Edward Dias

Posted 01 July 2008 - 05:50 AM

Não tenho em minha loja espaço para o preenchimento de número e nem complemento, como que eu faço pra colocar na loja?

Só tenho:
Endereço:
Bairro:
CEP:
Cidade:
Estado:
País:

:huh:
0

#3 User is offline   souzadavi Icon

  • Find Posts
  • Group: Community Member
  • Posts: 60
  • Joined: 02-August 03
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 01 July 2008 - 12:26 PM

View Postcafumbira, on Jul 1 2008, 02:50 AM, said:

Não tenho em minha loja espaço para o preenchimento de número e nem complemento, como que eu faço pra colocar na loja?

Só tenho:
Endereço:
Bairro:
CEP:
Cidade:
Estado:
País:

:huh:


cara le a resposta acima!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Davi S Souza
0

#4 User is offline   souzadavi Icon

  • Find Posts
  • Group: Community Member
  • Posts: 60
  • Joined: 02-August 03
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 01 July 2008 - 06:12 PM

USEM ESTE CODIGO PARA ADICIONAR NOVO CAMPO:

Numero e Complemento para funcionar nos pagseguro.

Quote

Para adicionar número e complemento novo campo, é necessário alterar os arquivos:

- catalog/create_account.php
- catalog/checkout_process.php
- catalog/includes/classes/order.php
- catalog/includes/modules/payment/pagseguro.php
- catalog/includes/form_check.js.php



SQL >>> NO BANCO DE DADOS ::::
TABELA

address_book
crie os campos após - ----- entry_lastname
- entry_number_address --- varchar 64
- entry_comple_address --- varchar 64

orders
crie os campos após - ----- customers_street_address
- customers_number_address --- varchar 64
- customers_comple_address --- varchar 64

crie os campos após ----- delivery_street_address
- delivery_number_address --- varchar 64
- delivery_comple_address --- varchar 64

crie os campor após ----- billing_street_address
- billing_number_address --- varchar 64
- billing_comple_address --- varchar 64






:::::::::::::::::::::: create_account.php

PROCURE POR:
$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);


SUBSTITUA POR
$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
$number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']);
$comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']);
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => $street_address,

SUBSTITUIA:
'entry_street_address' => $street_address,
'entry_number_address' => $number_address,
'entry_comple_address' => $comple_address,
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
<tr>
<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('street_address') . '&nbsp;' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>

SUBSTITUE POR:
<tr>
<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('street_address') . '&nbsp;' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>

<tr>
<td class="main"><?php echo ENTRY_NUMBER_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('number_address') . '&nbsp;' . (tep_not_null(ENTRY_NUMBER_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_NUMBER_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_COMPLE_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('comple_address') . '&nbsp;' . (tep_not_null(ENTRY_COMPLE_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_COMPLE_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>







::::::::::::::::::::::: checkout_process.php

PROCURE:
'customers_street_address' => $order->customer['street_address'],

SUBSTITUA POR:
'customers_street_address' => $order->customer['street_address'],
'customers_number_address' => $order->customer['number_address'],
'customers_comple_address' => $order->customer['comple_address'],


//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'delivery_street_address' => $order->delivery['street_address'],

SUBSTITUA POR:
'delivery_street_address' => $order->delivery['street_address'],
'delivery_number_address' => $order->delivery['number_address'],
'delivery_comple_address' => $order->delivery['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'billing_street_address' => $order->billing['street_address'],

SUBSITUIA POR:
'billing_street_address' => $order->billing['street_address'],
'billing_number_address' => $order->billing['number_address'],
'billing_comple_address' => $order->billing['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>








:::::::::::::::::::::::::::::: catalog/includes/classes/order.php

PROCURE POR:
customers_company, customers_street_address,

SUBSTITUIA POR:
customers_company, customers_street_address, customers_number_address, customers_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
delivery_company, delivery_street_address,

SUBSTITUA POR:
delivery_company, delivery_street_address, delivery_number_address, delivery_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
billing_company, billing_street_address,

SUBSTITUA POR:
billing_company, billing_street_address, billing_number_address, billing_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'street_address' => $order['customers_street_address'],

SUBSTITUA POR:
'street_address' => $order['customers_street_address'],
'number_address' => $order['customers_number_address'],
'comple_address' => $order['customers_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $order['delivery_street_address'],

SUBSTITUA POR:
'street_address' => $order['delivery_street_address'],
'number_address' => $order['delivery_number_address'],
'comple_address' => $order['delivery_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $order['billing_street_address'],

SUBSTITUA POR:
'street_address' => $order['billing_street_address'],
'number_address' => $order['billing_number_address'],
'comple_address' => $order['billing_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address,

ab.entry_company, ab.entry_street_address,

SUBSTITUA POR:
$customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address,

ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => $sendto['street_address'],

SUBSTITUA POR:
'entry_street_address' => $sendto['street_address'],
'entry_number_address' => $sendto['number_address'],
'entry_comple_address' => $sendto['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

SUBSTITUA POR:
$shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => null,

SUBSTITUA POR:
'entry_street_address' => null,
'entry_number_address' => null,
'entry_comple_address' => null,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'entry_street_address' => $billto['street_address'],

SUBSTITUA POR:
'entry_street_address' => $billto['street_address'],
'entry_number_address' => $billto['number_address'],
'entry_comple_address' => $billto['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

SUBSTITUE POR:
$billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $customer_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $customer_address['entry_street_address'],
'number_address' => $customer_address['entry_number_address'],
'comple_address' => $customer_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $shipping_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $shipping_address['entry_street_address'],
'number_address' => $shipping_address['entry_number_address'],
'comple_address' => $shipping_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'street_address' => $billing_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $billing_address['entry_street_address'],
'number_address' => $billing_address['entry_number_address'],
'comple_address' => $billing_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address,

SUBSTITUE POR:
$order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_number_address,

customers_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>




::::::::::::::::::::::::: pagseguro.php

PROCURE POR:
'street_address' => $customer_address['entry_street_address'],

SUBSTITUIE POR:
'customers_street_address' => $order->customer['street_address'],
'customers_number_address' => $order->customer['number_address'],
'customers_comple_address' => $order->customer['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'delivery_street_address' => $order->delivery['street_address'],

SUBSTITUIR POR:
'delivery_street_address' => $order->delivery['street_address'],
'delivery_number_address' => $order->delivery['number_address'],
'delivery_comple_address' => $order->delivery['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
billing_street_address' => $order->billing['street_address'],
SUBSTITUIE POR:
'billing_street_address' => $order->billing['street_address'],
'billing_number_address' => $order->billing['number_address'],
'billing_comple_address' => $order->billing['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$cust_num = "s/n";
$cust_compl = "casa2";

SUBSTITUIE POR:
// $cust_num = "s/n";
// $cust_compl = "casa2";

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
//tep_draw_hidden_field('cliente_num', $cust_num) . "\n" .
//tep_draw_hidden_field('cliente_compl', $cust_compl) . "\n" .

SUBSTITUIE POR:
tep_draw_hidden_field('cliente_num', $order->delivery['number_address']) . "\n" .
tep_draw_hidden_field('cliente_compl', $order->delivery['comple_address']) . "\n" .

// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>




:::::::::::::::::::::::::::::::::: catalog/includes/form_check.js.php

PROCURE POR:
check_input("street_address", <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_STREET_ADDRESS_ERROR; ?>");

SUBSITUA POR:
check_input("street_address", <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_STREET_ADDRESS_ERROR; ?>");
check_input("number_address", <?php echo ENTRY_NUMBER_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_NUMBER_ADDRESS_ERROR; ?>");

// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Davi S Souza
0

#5 User is offline   cafumbira Icon

  • Find Posts
  • Group: Community Member
  • Posts: 3
  • Joined: 16-June 08
  • Real Name:Edward Dias

Posted 01 July 2008 - 08:17 PM

View Postsouzadavi, on Jul 1 2008, 09:26 AM, said:

cara le a resposta acima!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

:rolleyes: Foi mal nao li direito aqui entre no meu banco de dados e não encontrei customers_street_address nem delivery_street_address nem billing_street_address veja a imagem:
Posted Image

This post has been edited by cafumbira: 01 July 2008 - 08:18 PM

0

#6 User is offline   souzadavi Icon

  • Find Posts
  • Group: Community Member
  • Posts: 60
  • Joined: 02-August 03
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 02 July 2008 - 06:50 PM

View Postcafumbira, on Jul 1 2008, 05:17 PM, said:

:rolleyes: Foi mal nao li direito aqui entre no meu banco de dados e não encontrei customers_street_address nem delivery_street_address nem billing_street_address veja a imagem:
Posted Image



por favor leia direito esta escrito leia com calma....


esta escrito o nome das tabela order e address_book veja na explicação acima....

Quote

SQL >>> NO BANCO DE DADOS ::::
TABELA

address_book
crie os campos após - ----- entry_lastname
- entry_number_address --- varchar 64
- entry_comple_address --- varchar 64

orders
crie os campos após - ----- customers_street_address
- customers_number_address --- varchar 64
- customers_comple_address --- varchar 64

crie os campos após ----- delivery_street_address
- delivery_number_address --- varchar 64
- delivery_comple_address --- varchar 64

crie os campor após ----- billing_street_address
- billing_number_address --- varchar 64
- billing_comple_address --- varchar 64

Davi S Souza
0

#7 User is offline   d3mundo Icon

  • Find Posts
  • Group: Community Member
  • Posts: 1
  • Joined: 07-July 08
  • Real Name:douglas souza

Posted 07 July 2008 - 10:42 AM

View Postsouzadavi, on Jul 2 2008, 03:50 PM, said:

por favor leia direito esta escrito leia com calma....


esta escrito o nome das tabela order e address_book veja na explicação acima....


e como eu coloco estes dados no banco de dados para que fiquem no lugar certo, tem como mostrar para nos?
0

#8 User is offline   Edison-Nctec Icon

  • Find Posts
  • Group: Community Member
  • Posts: 1
  • Joined: 03-August 08
  • Real Name:Edison

Posted 03 August 2008 - 04:46 PM

Olá Davi, primeiramente gostaria de parabeniza-lo pelo excelente tópico.
Para mim funcionou tudo direitnho até a parte de testar a tela de edição do livro de endereços, não consigo de jetio nenhum fazer aparecer os campos de número e complemento na tela address_book, nem na tela address_book_processes.
Neste última até mostra, porém quando clico em atualizar :blink: ele apaga as entradas no banco de dados. Coloque algumas informações em address_book_process seguindo sua linha de racionciocinio:

$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
$street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']);
$number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']);
$comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']);

e depois em address_book

entry_number_address as number_address, entry_comple_address as comple_address, ...

Mas não funcionou!
Por favor se puder me ajudar eu agradeço
0

#9 User is offline   souzadavi Icon

  • Find Posts
  • Group: Community Member
  • Posts: 60
  • Joined: 02-August 03
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 03 August 2008 - 09:29 PM

View Postd3mundo, on Jul 7 2008, 07:42 AM, said:

e como eu coloco estes dados no banco de dados para que fiquem no lugar certo, tem como mostrar para nos?



use o phpmyadmin ou qualquer programa de sql.. recomendo o sqlyog...

caso não consiga me avise aq q te passo o comando SQL.. vlw davi
Davi S Souza
0

#10 User is offline   souzadavi Icon

  • Find Posts
  • Group: Community Member
  • Posts: 60
  • Joined: 02-August 03
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 15 August 2008 - 05:13 PM

novas informações sobre como inserir o numero e complemento....





Quote

Para adicionar número e complemento novo campo, é necessário alterar os arquivos:

- catalog/create_account.php
- catalog/checkout_process.php
- catalog/includes/classes/order.php
- catalog/includes/modules/payment/pagseguro.php
- catalog/includes/form_check.js.php

-admin/includes/classes/order.php
-admin/includes/functions/general.php



SQL >>> NO BANCO DE DADOS ::::
TABELA

address_book
crie os campos após - ----- entry_lastname
- entry_number_address --- varchar 64
- entry_comple_address --- varchar 64

orders
crie os campos após - ----- customers_street_address
- customers_number_address --- varchar 64
- customers_comple_address --- varchar 64

crie os campos após ----- delivery_street_address
- delivery_number_address --- varchar 64
- delivery_comple_address --- varchar 64

crie os campor após ----- billing_street_address
- billing_number_address --- varchar 64
- billing_comple_address --- varchar 64

address_format
- no address_format_id 1 alterar o address_format para:
$firstname $lastname$cr $streets$cr $suburb$cr$city, $postcode$cr$statecomma$country







:::::::::::::::::::::: create_account.php

PROCURE POR:
$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);


SUBSTITUA POR
$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
$number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']);
$comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']);
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => $street_address,

SUBSTITUIA:
'entry_street_address' => $street_address,
'entry_number_address' => $number_address,
'entry_comple_address' => $comple_address,
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
<tr>
<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('street_address') . '&nbsp;' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>

SUBSTITUE POR:
<tr>
<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('street_address') . '&nbsp;' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>

<tr>
<td class="main"><?php echo ENTRY_NUMBER_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('number_address') . '&nbsp;' . (tep_not_null(ENTRY_NUMBER_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_NUMBER_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_COMPLE_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('comple_address') . '&nbsp;' . (tep_not_null(ENTRY_COMPLE_ADDRESS_TEXT) ? '<span

class="inputRequirement">' . ENTRY_COMPLE_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>







::::::::::::::::::::::: checkout_process.php

PROCURE:
'customers_street_address' => $order->customer['street_address'],

SUBSTITUA POR:
'customers_street_address' => $order->customer['street_address'],
'customers_number_address' => $order->customer['number_address'],
'customers_comple_address' => $order->customer['comple_address'],


//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'delivery_street_address' => $order->delivery['street_address'],

SUBSTITUA POR:
'delivery_street_address' => $order->delivery['street_address'],
'delivery_number_address' => $order->delivery['number_address'],
'delivery_comple_address' => $order->delivery['comple_address'],


//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'billing_street_address' => $order->billing['street_address'],

SUBSITUIA POR:
'billing_street_address' => $order->billing['street_address'],
'billing_number_address' => $order->billing['number_address'],
'billing_comple_address' => $order->billing['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>








:::::::::::::::::::::::::::::: catalog/includes/classes/order.php

PROCURE POR:
customers_company, customers_street_address,

SUBSTITUIA POR:
customers_company, customers_street_address, customers_number_address, customers_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
delivery_company, delivery_street_address,

SUBSTITUA POR:
delivery_company, delivery_street_address, delivery_number_address, delivery_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
billing_company, billing_street_address,

SUBSTITUA POR:
billing_company, billing_street_address, billing_number_address, billing_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'street_address' => $order['customers_street_address'],

SUBSTITUA POR:
'street_address' => $order['customers_street_address'],
'number_address' => $order['customers_number_address'],
'comple_address' => $order['customers_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $order['delivery_street_address'],

SUBSTITUA POR:
'street_address' => $order['delivery_street_address'],
'number_address' => $order['delivery_number_address'],
'comple_address' => $order['delivery_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $order['billing_street_address'],

SUBSTITUA POR:
'street_address' => $order['billing_street_address'],
'number_address' => $order['billing_number_address'],
'comple_address' => $order['billing_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone,

c.customers_email_address, ab.entry_company, ab.entry_street_address,

SUBSTITUA POR:
$customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone,

c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => $sendto['street_address'],

SUBSTITUA POR:
'entry_street_address' => $sendto['street_address'],
'entry_number_address' => $sendto['number_address'],
'entry_comple_address' => $sendto['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

SUBSTITUA POR:
$shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'entry_street_address' => null,

SUBSTITUA POR:
'entry_street_address' => null,
'entry_number_address' => null,
'entry_comple_address' => null,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'entry_street_address' => $billto['street_address'],

SUBSTITUA POR:
'entry_street_address' => $billto['street_address'],
'entry_number_address' => $billto['number_address'],
'entry_comple_address' => $billto['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

SUBSTITUE POR:
$billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address,

ab.entry_number_address, ab.entry_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $customer_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $customer_address['entry_street_address'],
'number_address' => $customer_address['entry_number_address'],
'comple_address' => $customer_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
'street_address' => $shipping_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $shipping_address['entry_street_address'],
'number_address' => $shipping_address['entry_number_address'],
'comple_address' => $shipping_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'street_address' => $billing_address['entry_street_address'],

SUBSTITUE POR:
'street_address' => $billing_address['entry_street_address'],
'number_address' => $billing_address['entry_number_address'],
'comple_address' => $billing_address['entry_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address,

SUBSTITUE POR:
$order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address,

customers_number_address, customers_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>




::::::::::::::::::::::::: pagseguro.php

PROCURE POR:
'street_address' => $customer_address['entry_street_address'],

SUBSTITUIE POR:
'customers_street_address' => $order->customer['street_address'],
'customers_number_address' => $order->customer['number_address'],
'customers_comple_address' => $order->customer['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'delivery_street_address' => $order->delivery['street_address'],

SUBSTITUIR POR:
'delivery_street_address' => $order->delivery['street_address'],
'delivery_number_address' => $order->delivery['number_address'],
'delivery_comple_address' => $order->delivery['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
billing_street_address' => $order->billing['street_address'],
SUBSTITUIE POR:
'billing_street_address' => $order->billing['street_address'],
'billing_number_address' => $order->billing['number_address'],
'billing_comple_address' => $order->billing['comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
$cust_num = "s/n";
$cust_compl = "casa2";

SUBSTITUIE POR:
// $cust_num = "s/n";
// $cust_compl = "casa2";

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
//tep_draw_hidden_field('cliente_num', $cust_num) . "\n" .
//tep_draw_hidden_field('cliente_compl', $cust_compl) . "\n" .

SUBSTITUIE POR:
tep_draw_hidden_field('cliente_num', $order->delivery['number_address']) . "\n" .
tep_draw_hidden_field('cliente_compl', $order->delivery['comple_address']) . "\n" .

// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>




:::::::::::::::::::::::::::::::::: catalog/includes/form_check.js.php

PROCURE POR:
check_input("street_address", <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_STREET_ADDRESS_ERROR; ?>");

SUBSITUA POR:
check_input("street_address", <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_STREET_ADDRESS_ERROR; ?>");
check_input("number_address", <?php echo ENTRY_NUMBER_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_NUMBER_ADDRESS_ERROR; ?>");

// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>





:::::::::::::::::::::::::::::: admin/includes/classes/order.php

PROCURE POR:
customers_company, customers_street_address,

SUBSTITUIA POR:
customers_company, customers_street_address, customers_number_address, customers_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


PROCURE POR:
billing_company, billing_street_address,

SUBSTITUA POR:
billing_company, billing_street_address, billing_number_address, billing_comple_address,

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

PROCURE POR:
'street_address' => $order['customers_street_address'],

SUBSTITUA POR:
'street_address' => $order['customers_street_address'],
'number_address' => $order['customers_number_address'],
'comple_address' => $order['customers_comple_address'],

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>




:::::::::::::::::::::::::::::: admin/includes/functions/general.php

PROCURE POR:
$street = tep_output_string_protected($address['street_address']);

SUBSTITUA POR:
$street = tep_output_string_protected($address['street_address']) .' '. tep_output_string_protected($address['number_address']) . '

'.tep_output_string_protected($address['comple_address']);

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Davi S Souza
0

#11 User is offline   OGATORJ Icon

  • Find Posts
  • Group: Community Member
  • Posts: 1
  • Joined: 12-December 08
  • Real Name:OGATORJ

Posted 12 December 2008 - 04:24 AM

olá, davi.

Poderia me enviar o comando SQL pra eu rodar no meu PHPMyAdmin ?

Assim eu só teria que rodá-lo e depois alterar os arquivos PHP, correto ?

Obrigado.

Abs, Lucci.

0

#12 User is offline   FGML Icon

  • Find Posts
  • Group: Community Member
  • Posts: 2
  • Joined: 29-March 09
  • Real Name:Fernando Meira Lins
  • Gender:Male
  • Location:Recife / PE / Brazil

Posted 29 March 2009 - 05:44 PM

Hello, sorry my poor english. I installed the version OSCommerceBR RC2.2. But when insert a new product, regardless of value, prices are always 0 (Zero). Somebody help me?

Olá, eu instalei a versão OSCommerceBR RC2.2. Porém quando inserimos um novo produto, independente do valor, os preços ficam como 0 (Zero). Alguém pode me ajudar?

Fernando Meira Lins
Fernando Meira Lins
SIP Code: *8839 78910
+558132426582
+558196339633
+552140637234 Station: 78910
0

#13 User is offline   angelli007 Icon

  • Find Posts
  • Group: Community Member
  • Posts: 2
  • Joined: 09-May 09
  • Real Name:Domingos Angeli

Posted 09 May 2009 - 07:58 PM

View PostEdison-Nctec, on Aug 3 2008, 04:46 PM, said:

Olá Davi, primeiramente gostaria de parabeniza-lo pelo excelente tópico.
Para mim funcionou tudo direitnho até a parte de testar a tela de edição do livro de endereços, não consigo de jetio nenhum fazer aparecer os campos de número e complemento na tela address_book, nem na tela address_book_processes.
Neste última até mostra, porém quando clico em atualizar :blink: ele apaga as entradas no banco de dados. Coloque algumas informações em address_book_process seguindo sua linha de racionciocinio:

$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
$street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']);
$number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']);
$comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']);

e depois em address_book

entry_number_address as number_address, entry_comple_address as comple_address, ...

Mas não funcionou!
Por favor se puder me ajudar eu agradeço



Alguem ja conseguiu colocar os campos do numero e complemento no address_book_processes.php e address_book.php ?
0

#14 User is offline   Amegalos Icon

  • Find Posts
  • Group: Community Member
  • Posts: 1
  • Joined: 11-June 09
  • Real Name:Alex Magnos

Post icon  Posted 11 June 2009 - 11:01 PM

Amigos, eu instalei uma versão em português do oscommerce 'oscommercebr RC2.2' que traz um módulo de pagamento "cod.php" que habilita as informações para depósito em conta:

Quando eu instalo o módulo "cod.php" pelo administrador>ferramentas>modulos>pagamento : aparecem as informações abaixo e não sei como modificar. :(


Pagamento por Depósito Bancário ALINE SOUZA REAL FRANCO
Banco BRADESCO - Agência 1662-4 Conta Corrente 19717-3


Obviamente esses não são meus dados!

Gostaria de saber com posso editar essas informações. Retirar os dados acima e colocar meus dados bancários.

Se alguém puder ajudar, eu agradeço muito. É a primeira vez que estalo uma loja virtual, então estou meio perdido.

Obrigado!
0

#15 User is offline   je4423 Icon

  • Find Posts
  • Group: Community Member
  • Posts: 1
  • Joined: 16-December 08
  • Real Name:Jeferson Ivo

Posted 22 June 2009 - 04:31 PM

Boa tarde galera!
É o seguinte, não estou conseguindo mandar o ddd para o pagseguro. Alguem poderia me ajudar? Obrigado!
0

#16 User is offline   digaovr Icon

  • Find Posts
  • Group: Community Member
  • Posts: 6
  • Joined: 20-May 07
  • Real Name:Rodrigo

Posted 24 June 2009 - 10:31 PM

Olá Pessoal, vou tentar simplificar isto aqui:

Adicione o código abaixo em seu banco de dados através do phpmyadmin:

ALTER TABLE customers ADD customers_ddd int(2) NOT NULL;



No arquivo create_account.php localize:

$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);



Logo abaixo, adicione:

$ddd = tep_db_prepare_input($HTTP_POST_VARS['ddd']);



Localize:

'customers_lastname' => $lastname,



Logo abaixo adicione:

'customers_ddd' => $ddd,



Localize:

<tr>
				<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
				<td class="main"><?php echo tep_draw_input_field('telephone') . '&nbsp;' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td>
			  </tr>



Substitua por:

<tr>
				
				<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
				<td class="main"><?php echo tep_draw_input_field('ddd','','size="2"'); ?> - <?php echo tep_draw_input_field('telephone') . '&nbsp;' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td>
			  </tr>



No arquivo account_edit.php, localize:

$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);



Logo abaixo, adicione:

$ddd = tep_db_prepare_input($HTTP_POST_VARS['ddd']);



Localize:

'customers_lastname' => $lastname,



Logo abaixo adicione:

'customers_ddd' => $ddd,



Localize:

$account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); 
  $account = tep_db_fetch_array($account_query);



Substitua por:

$account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_cpf, customers_rg,customers_dob, customers_email_address, customers_ddd, customers_telephone, customers_fax from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); 
  $account = tep_db_fetch_array($account_query);



Localize:

<tr>
				<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
				<td class="main"><?php echo tep_draw_input_field('telephone') . '&nbsp;' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td>
			  </tr>



Substitua por:

<tr>
				
				<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
				<td class="main"><?php echo tep_draw_input_field('ddd','','size="2"'); ?> - <?php echo tep_draw_input_field('telephone') . '&nbsp;' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td>
			  </tr>




Agora no arquivo admin/customers.php, localize:

$customers_lastname = tep_db_prepare_input($HTTP_POST_VARS['customers_lastname']);



Logo abaixo, adicione:

$ddd = tep_db_prepare_input($HTTP_POST_VARS['ddd']);



Localize:

'customers_lastname' => $customers_lastname,



Abaixo adicione:

'customers_ddd' => $ddd,



Localize:

$customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");



Substitua por:

$customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_cpf, c.customers_rg, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_ddd, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");



Localize:

<?php
  if ($error == true) {
	if ($entry_telephone_error == true) {
	  echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"') . '&nbsp;' . ENTRY_TELEPHONE_NUMBER_ERROR;
	} else {
	  echo $cInfo->customers_telephone . tep_draw_hidden_field('customers_telephone');
	}
  } else {
	echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"', true);
  }
?>



Substitua por:


<?php

echo tep_draw_input_field('customers_ddd', $cInfo->customers_ddd, 'maxlength="2" size="2"', false) . ' - ';
  if ($error == true) {
	if ($entry_telephone_error == true) {
	  echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"') . '&nbsp;' . ENTRY_TELEPHONE_NUMBER_ERROR;
	} else {
	  echo $cInfo->customers_telephone . tep_draw_hidden_field('customers_telephone');
	}
  } else {
	echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"', true);
  }
?>



Abra o arquivo checkout_process.php e encontre:

'customers_telephone' => $order->customer['telephone'],


Abaixo, adicione:

'ddd' => $order->customer['ddd'],


Abra o arquivo includes/classes/order.php e ache:

 $order_query = tep_db_query("select customers_id, 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_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)$order_id . "'");


Substitua por:

$order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_ddd, 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_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)$order_id . "'");


Encontre:

'telephone' => $order['customers_telephone'],


Abaixo, adicione:

'ddd' => $order['customers_ddd'],



Rode e veja se está tudo funcionando.

"O Coringão voltou B) "

This post has been edited by digaovr: 24 June 2009 - 10:37 PM

0

#17 User is offline   digaovr Icon

  • Find Posts
  • Group: Community Member
  • Posts: 6
  • Joined: 20-May 07
  • Real Name:Rodrigo

Posted 24 June 2009 - 10:39 PM

View PostAmegalos, on Jun 11 2009, 11:01 PM, said:

Amigos, eu instalei uma versão em português do oscommerce 'oscommercebr RC2.2' que traz um módulo de pagamento "cod.php" que habilita as informações para depósito em conta:

Quando eu instalo o módulo "cod.php" pelo administrador>ferramentas>modulos>pagamento : aparecem as informações abaixo e não sei como modificar. :(


Pagamento por Depósito Bancário ALINE SOUZA REAL FRANCO
Banco BRADESCO - Agência 1662-4 Conta Corrente 19717-3


Obviamente esses não são meus dados!

Gostaria de saber com posso editar essas informações. Retirar os dados acima e colocar meus dados bancários.

Se alguém puder ajudar, eu agradeço muito. É a primeira vez que estalo uma loja virtual, então estou meio perdido.

Obrigado!



Abra o arquivo includes\languages\portugues\modules\payment\cod.php e edite os textos com os seus devidos dados.

Abraços
0

#18 User is offline   digaovr Icon

  • Find Posts
  • Group: Community Member
  • Posts: 6
  • Joined: 20-May 07
  • Real Name:Rodrigo

Posted 24 June 2009 - 11:31 PM

Desculpem a falha, coloquei o código que postei acima com algumas modificações aqui:

http://forums.oscomm...howtopic=339322

Abs
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic