Jump to content
eMDi

Polofunkcne bloky + Export objednaneho tovaru

Recommended Posts

Ahojte, potreboval by som poradit.
1. problem: potreboval by som umiestnit napr. pri konkretnom produkte (bude to u vsetkych produktov, myslel som detail produktu) - http://linuxeshop.eu/cs/panske-unisex/84-arch-linux-bile-logo-napis - ako je symbol platieb nejaky custom HTML block, ktory mi umozni podla jazykovej mutacie tam vlozit typy dodania + platieb ... custom HTML mi nechce fungovat. Okrem toho, ze stitky zacali fungovat az po stlaceni reset, niektore ostatne bloky a moduly sa tiez spravaju cudne. naraz nejdu, ani po resete, ani po reinstalle, pritom v liveedit ich vidim zapnute.
2. problem/otazka: kedze u niektorych produktov mam aj velkosti S-XXL, chcel by som nejak docielit v SQL manageri moznost exportu objednaneho tovaru (rozdelene aj podla velkosti) s naparovanym obrazkom produktu ...
mam nieco taketo:
 

SELECT  d.`id_order` AS `#`,product_id,product_name, product_quantity,current_state  , SUM(product_quantity) AS celkom , im.`id_image` FROM linuxeshop_order_detail d
    LEFT JOIN linuxeshop_orders o ON (d.id_order = o.id_order)
    LEFT JOIN linuxeshop_product_attribute a ON (a.id_product=d.product_id)
    LEFT JOIN linuxeshop_product_attribute_image im ON (im.id_product_attribute=a.id_product_attribute)
    WHERE o.current_state = 3 GROUP BY d.product_id ORDER BY  d.product_name ASC 

co mi sice nejaky zoznam objednanych produktov da, ale nie vzdy je to rozdelene aj podla velkosti.

any idea? vdaka za odpovede

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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