POUZE PRO ADMINY!!!!!
výjezd platných položek ceníku z databáze pro aktuální platné datum do budoucnosti. Datumy možné měnit v query
SELECT
seller.ic as seller_ic,
seller.name as seller_name,
web.name as web_name,
web.web_url as web_url,
section.name as section_name,
section.url as section_url,
format.name as format_name,
pricelist.buy_unit_days as buy_unit_days,
pricelist.impression as price_units_number,
pricelist.price as price,
pricelist.users as users,
pricelist.spec_buymodel as buying_model,
format.width as format_width,
format.height as format_height,
format.next_dimensions as format_next_dimensions,
position.description as position_description,
format.max_KB as format_max_KB,
format.max_KB as format_max_KB,
position.description_tp as position_description_tp,
pricelist.platform as platform,
pricelist.cat1 as cat1,
pricelist.cat2 as cat2,
pricelist.cat3 as cat3,
pricelist.cat4 as cat4,
pricelist.cat5 as cat5,
pricelist.cat6 as cat6,
pricelist.cat7 as cat7,
pricelist.cat8 as cat8,
pricelist.cat9 as cat9,
pricelist.cat10 as cat10,
pricelist.cat11 as cat11,
seller.mediasystem_id_buyin2 as ext_dodavatel_id,
web.mediasystem_id_buyin2 as ext_medium_id
FROM edge_h20_pricelist as pricelist
INNER JOIN edge_h20_seller as seller ON (pricelist.id_seller = seller.id_seller)
INNER JOIN edge_h20_web_position as position ON (pricelist.id_position = position.id_position)
INNER JOIN edge_h20_web as web ON (position.id_web = web.id_web)
INNER JOIN edge_h20_web_section as section ON (position.id_section = section.id_section)
INNER JOIN edge_h20_web_position_format as format ON (position.id_format = format.id_format)
WHERE
-- CURRENT_DATE() muze byt rucne psane datum ve formatu RRRR-MM-DD napr:
-- pricelist.valid_from <= '2020-12-24'
pricelist.valid_from <= CURRENT_DATE()
AND
-- CURRENT_DATE() muze byt rucne psane datum ve formatu RRRR-MM-DD napr:
-- COALESCE(pricelist.valid_to, '9999-12-31') >= '2020-12-24'
COALESCE(pricelist.valid_to, '9999-12-31') >= CURRENT_DATE()
ORDER BY
seller.ic ASC, seller.name ASC