Jump to content

sondiva

Members
  • Posts

    22
  • Joined

  • Last visited

Everything posted by sondiva

  1. will you try this, SELECT p.id_product, p.active 'Active', m.name 'Manufacturer', p.id_product 'Product Id', p.reference 'Reference', pl.name 'Product name', GROUP_CONCAT(DISTINCT(al.name) SEPARATOR ", ") AS 'Combination', s.quantity 'Quantity', p.price 'Price w/o VAT', pa.price 'Combination price', p.wholesale_price 'Wholesale price', GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") AS 'Product groups', p.weight 'Weight', p.id_tax_rules_group 'TAX group', pa.reference 'Combination reference', pl.description_short 'Short description', pl.description 'Long description', pl.meta_title 'Meta Title', pl.meta_keywords 'Meta Keywords', pl.meta_description 'Meta Description', pl.link_rewrite 'Link', pl.available_now 'In stock text', pl.available_later 'Coming text', p.available_for_order 'Orderable text', p.date_add 'Added', p.show_price 'Show price', p.online_only 'Only online', GROUP_CONCAT("http://", su.domain, su.physical_uri , IF(pai.id_image IS NOT NULL,pai.id_image,im.id_image), "/", REPLACE(REPLACE(REPLACE(pl.name," ","_"),"\"",""),"#",""), ".jpg") AS "Image URL" FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang=2) LEFT JOIN ps_manufacturer m ON (p.id_manufacturer = m.id_manufacturer) LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN ps_category c ON (cp.id_category = c.id_category) LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category AND cl.id_lang=2) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_stock_available s ON (p.id_product = s.id_product AND (pa.id_product_attribute=s.id_product_attribute OR pa.id_product_attribute IS NULL)) LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = pa.id_product_attribute) LEFT JOIN ps_attribute_lang al ON (al.id_attribute = pac.id_attribute AND al.id_lang=2) LEFT JOIN ps_shop sh ON p.id_shop_default = sh.id_shop LEFT JOIN ps_shop_url su ON su.id_shop = sh.id_shop AND su.main = 1 LEFT JOIN ps_image im ON (p.id_product = im.id_product AND im.cover = 1) LEFT JOIN ps_product_attribute_image pai ON (pai.id_product_attribute = s.id_product_attribute) GROUP BY p.id_product,pac.id_product_attribute ORDER BY p.id_product
  2. Hello shagshag, I've been trying to contact you by mails and support, I have simple issue with your module for datepicker for customer for prestashop. It works well when used in front end while checking out but when we use in backend via custom hooking it does show you the date picker and even i managed to make it selectable by date but when we order it does not send data to database. Can you please help us in this , i have a project where it is needed urgently. I m using the backend office in Add New Order (Manual) ->after selecting customer name->Adding item to cart->in shipping i use your module. Pls Help
  3. no error reported but i can't select the date in backend whereas i can select the date and timeframe from front end while checking out I will PM u the code
  4. Ok Luckily i managed to get hook into form.tpl, but date selection is not active...is it jquery issue?? see the attachment
  5. Hi Fabien Serny Recently I bought a module to show delivery dates and time-frame slots for customers it works well in front (website) but when I made a custom hook and and tried to call the hook into back-end admin , manual new order it does not shows up. The hook installed in database ps_hooks perfectly here is the code i used to install ---------------------------------------------------------- public function install() { if (version_compare(_PS_VERSION_, '1.5.0.0', '<')) { $before_carrier = method_exists('Hook', 'get') && Hook::get('beforeCarrier'); } else { $before_carrier = true; } if (!$this->samdha_tools->executeSQLFile(self::INSTALL_SQL_FILE) || !parent::install() || !($before_carrier?$this->registerHook('beforeCarrier'):true) || !$this->registerHook('footer') || !$this->registerHook('header') || !$this->registerHook('adminOrder') || !$this->registerHook('GoDate') || (version_compare(_PS_VERSION_, '1.5.0.0', '>=')?!$this->registerHook('displayPDFInvoice'):false) || (version_compare(_PS_VERSION_, '1.5.0.0', '>=')?!$this->registerHook('displayPDFDeliverySlip'):false) || !$this->registerHook('newOrder')) { return false; } return true; } public function hookGoDate($params) { return $this->display(__FILE__, 'deliverydays.tpl'); }
  6. Hi Vekia, I need to put carrier selection while generating all the pdf file invoices from/to date in back office so that we can only print the particular invoices as per carrier selection..any advice on that...
  7. Yup, sure it is what i want...for front end i have bought the module but for backend admin order i need this to be incorporated.
  8. Seems we are on the same issue mayank, even I am looking for adding a date in shipping in back office admin manual order and bought a module from smadha but for some reason many vendors are unable to give a proper solution to add a date of delivery in shipping section in back office /Manual Order by admin. Vekia , Any guidance shall be appreciated...
  9. Does any one have an idea on what is the hook name for manual admin add order in backoffice so that i can transplant a date and time delivery module, if it is possible many people will be benefitted.
  10. As this given by p00pstar , this code is working in 1.6.1.2, i have tested and had to refresh the page 4 to 5 times, and it works perfectly Here' is the fixed one with mobile phone too: $sql = 'SELECT c.* FROM '._DB_PREFIX_.'customer c, '._DB_PREFIX_.'address a WHERE c.id_customer = a.id_customer AND ( a.phone LIKE \'%'.pSQL($query).'%\' OR a.phone_mobile LIKE \'%'.pSQL($query).'%\' OR c.email LIKE \'%'.pSQL($query).'%\' OR c.id_customer LIKE \'%'.pSQL($query).'%\' OR c.lastname LIKE \'%'.pSQL($query).'%\' OR c.firstname LIKE \'%'.pSQL($query).'%\' )'.Shop::addSqlRestriction(Shop::SHARE_CUSTOMER);
  11. The following module(s) could not be installed properly: pss_pdfinvoiceplus : Installed OK but when tried to install on 1.6.x , this error was displayed.. Hope if this module can be upgraded by someone , would be a great help to all
  12. Can anybody help to get Rates of Products and Add to Cart option with Quantity in Ajax Live Search????.. It would be a nice addon...
  13. I want to add rates with the list, and if possible add to cart button...Is it possible to achieve this.. Thanks in Advance..
  14. Hello, I updated rates and wholesale price to zero in backend (mysql) but i still see old rates coming on product list , i deleted cache also but still the old rates are showing up Any help will be appriciated
  15. Hi all, I have a small problem in top menu which is responsive one comes with default settings, when ever i check out in mobile , it shows only category and on clicking it sub menu does not shows up otherwise in DESKTOP version it is working..... I have already clicked on tablets and Mobile in backend. the link is http://tsmfresh.com/tsmshop/ Vekia Pls advice .. Thanks
  16. Actually , i tried this but position did not changed to its original place i m using Presta 1.6.013 , i had to shift it to left sidebar, but i need it on top with search bar
  17. Hi Nemo1 I am referring to Featured Products (Home Page) and categories page list -->Product-list.tpl I was able to add quantity in my product-list.tpl file but I also want to add Product Attributes Combinations so that visitor can directly add to the cart. Although (product.tpl) single product page shows all the Attributes and Combinations + Qty and Amount but why can't we have same functionality in product-list.tpl...which makes life easier for most of us.. ... I have seen that there are some paid modules to do this... but want to try myself in creating that.. with prestashop community help... Can you please guide us... Thanks
  18. I was able to use quantity in my product-list.tpl file and it works well, but how to add weight+rates with product combinations activated...so i can add the quantity+weight+rate directly to cart...
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More