Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

Configurando adicionando criando Complemento e Numero no PAGSEGURO

Started by souzadavi, Jun 30 2008, 21:29

17 replies to this topic

#1 souzadavi

  • Community Member
  • 60 posts
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 30 June 2008, 21:29

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

#2 cafumbira

  • Community Member
  • 3 posts
  • Real Name:Edward Dias

Posted 01 July 2008, 05:50

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:

#3 souzadavi

  • Community Member
  • 60 posts
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 01 July 2008, 12:26

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

#4 souzadavi

  • Community Member
  • 60 posts
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 01 July 2008, 18:12

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

#5 cafumbira

  • Community Member
  • 3 posts
  • Real Name:Edward Dias

Posted 01 July 2008, 20:17

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:
[img]http://i268.photobucket.com/albums/jj30/cafumbira/bd.jpg[/img]

Edited by cafumbira, 01 July 2008, 20:18.

#6 souzadavi

  • Community Member
  • 60 posts
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 02 July 2008, 18:50

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:
[img]http://i268.photobucket.com/albums/jj30/cafumbira/bd.jpg[/img]


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

#7 d3mundo

  • Community Member
  • 1 posts
  • Real Name:douglas souza

Posted 07 July 2008, 10:42

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?

#8 Edison-Nctec

  • Community Member
  • 1 posts
  • Real Name:Edison

Posted 03 August 2008, 16:46

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

#9 souzadavi

  • Community Member
  • 60 posts
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 03 August 2008, 21:29

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

#10 souzadavi

  • Community Member
  • 60 posts
  • Real Name:Davi Souza
  • Gender:Male
  • Location:Brasil

Posted 15 August 2008, 17:13

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

#11 OGATORJ

  • Community Member
  • 1 posts
  • Real Name:OGATORJ

Posted 12 December 2008, 04:24

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.

#12 FGML

  • Community Member
  • 2 posts
  • Real Name:Fernando Meira Lins
  • Gender:Male
  • Location:Recife / PE / Brazil

Posted 29 March 2009, 17:44

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

#13 angelli007

  • Community Member
  • 2 posts
  • Real Name:Domingos Angeli

Posted 09 May 2009, 19:58

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 ?

#14 Amegalos

  • Community Member
  • 1 posts
  • Real Name:Alex Magnos

Posted 11 June 2009, 23:01

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!

#15 je4423

  • Community Member
  • 1 posts
  • Real Name:Jeferson Ivo

Posted 22 June 2009, 16:31

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

#16 digaovr

  • Community Member
  • 6 posts
  • Real Name:Rodrigo

Posted 24 June 2009, 22:31

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) "

Edited by digaovr, 24 June 2009, 22:37.

#17 digaovr

  • Community Member
  • 6 posts
  • Real Name:Rodrigo

Posted 24 June 2009, 22:39

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

#18 digaovr

  • Community Member
  • 6 posts
  • Real Name:Rodrigo

Posted 24 June 2009, 23:31

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

http://forums.oscommerce.com/index.php?showtopic=339322

Abs
Back to General Add-Ons Support · Next Unread Topic →


  1. osCommerce Support Forum
  2. → osCommerce Online Merchant v2.x
  3. → Add-Ons
  4. → General Add-Ons Support
  5. Forum Rules