hod enp

SELECT
	hdd.service_id AS HOD_service_id,
	hppc.post_code,
	hdd.shop_code,
	hdd.day,
	hs.name,
	hs.service_index
FROM hod_pos_post_code hppc
JOIN hod_delivery_day hdd ON(hppc.shop_code = hdd.shop_code)
JOIN hod_service hs ON(hdd.service_id = hs.id)
WHERE 
	hppc.post_code = '00-001'
	AND hdd.day = '2021-01-24'
	# id usługi z tabeli hod_service
	# AND hdd.service_id IN (1,3,4,6,7,8,10,11,13,15,19,22,43,44,71)
	# AND hdd.service_id > 0
GROUP BY hdd.service_id
\Enp\Bundle\ENP0026\HomeDelivery\APIBundle\Command\EcShopsPostCodesDataGetCommand
\Enp\Bundle\ENP0026\HomeDelivery\APIBundle\Command\EcCalendarGetCommand
https://www.mediaexpert.pl/enp/logs/prod.supplier_api_error/1000/
https://enetproduction.atlassian.net/browse/TASUP-4165
https://enetproduction.atlassian.net/browse/TASUP-4205
 
 
Komentarze wyłączone