André Teixeira andretx
rafaelpatro
/ magento-address-autocomplete.js
Last active
September 23, 2024 12:44
Magento Address Auto Fill based on Postcode
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Address Auto Fill based on Postcode | |
| * | |
| * Author: | |
| * Rafael Patro <rafaelpatro@gmail.com> | |
| * | |
| * Intallation: | |
| * Add a CMS Static Block applying the entire script below. | |
| * Add a Widget to pages with address forms. | |
| * |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT `main_table`.*, (main_table.base_subtotal_with_discount*main_table.base_to_global_rate) AS `subtotal`, `cust_email`.`email`, `cust_fname`.`value` AS `firstname`, `cust_lname`.`value` AS `lastname`, CONCAT_WS(' ', cust_fname.value, cust_lname.value) AS `customer_name` FROM `sales_flat_quote` AS `main_table` | |
| INNER JOIN `customer_entity` AS `cust_email` ON cust_email.entity_id = main_table.customer_id | |
| INNER JOIN `customer_entity_varchar` AS `cust_fname` ON cust_fname.entity_id = main_table.customer_id AND cust_fname.attribute_id = 5 | |
| INNER JOIN `customer_entity_varchar` AS `cust_lname` ON cust_lname.entity_id = main_table.customer_id AND cust_lname.attribute_id = 7 WHERE (items_count != '0') AND (main_table.is_active = '1') AND (main_table.created_at >= '2014-06-15 00:00:00') ORDER BY updated_at DESC | |