@sql 10.14.2024 19:22:22 - 10.128.10.46 > SELECT spgl.product_id,
spgl.currency_id,
spgl.price_nofees,
spgl.tax_nofees,
spgl.price_tax_notrounded_nofees,
spgl.price_tax_nofees,
spgl.fee_rema,
spgl.fee_rema_tax,
spgl.fee_rema_withtax,
spgl.fee_author,
spgl.fee_author_tax,
spgl.fee_author_withtax,
spgl.price,
spgl.tax,
spgl.price_tax_notrounded,
spgl.price_tax,
spgl.price_rec,
spgl.discount,
spgl.discount_percent,
spgl.no_action_price,
spgl.no_action_price_tax
FROM view_s_pricelist_generated_lists_customer AS spgl
WHERE spgl.product_id IN (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,)
AND spgl.customer_id = 0
AND spgl.currency_id = 1
@error: ERROR: syntax error at or near ","
LINE 23: WHERE spgl.product_id IN (,,,,,,,,,,,,,,...
^
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warning: pg_fetch_array() expects parameter 1 to be resource, bool given in /var/www/html/libs/core/classes/c_db.php on line 325 @sql 10.14.2024 19:22:22 - 10.128.10.46 > select sub.product_id, SUM(quantity) as quantity FROM (
SELECT CASE WHEN CURRENT_DATE BETWEEN sprh.del_date AND sprh.end_date THEN true ELSE false END AS running,
ARRAY_AGG(CASE WHEN sprg.is_b2c = true THEN 0 WHEN sprh.customer_id > 0 THEN sprh.customer_id WHEN sprh.customer_id IS NULL AND jcrg.customer_id IS NULL THEN -1 ELSE jcrg.customer_id END) as targ_customer_id,
sprr.product_id, sprr.row_id, COALESCE(sprr.quantity, 0::numeric) - COALESCE(sprr.quantity_actual, 0::numeric) AS quantity
FROM s_product_reservation_row sprr, s_product_reservation_header sprh
LEFT JOIN s_product_reservation_groups sprg ON (sprg.reservation_group_id = sprh.reservation_group_id)
LEFT JOIN j_customers_reservation_groups jcrg ON (jcrg.reservation_group_id = sprg.reservation_group_id)
WHERE sprr.status = 1
AND sprr.order_no IS NULL
AND sprh.reservation_id = sprr.reservation_id
and sprr.product_id IN (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,)
GROUP BY running, sprr.product_id, sprr.row_id, quantity) sub
WHERE (NOT ARRAY[0] <@ sub.targ_customer_id OR (ARRAY[0] <@ sub.targ_customer_id AND sub.running = false))
GROUP BY sub.product_id
@error: ERROR: syntax error at or near ","
LINE 11: and sprr.product_id IN (,,,,,,,,,,,,...
^
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warning: pg_fetch_row() expects parameter 1 to be resource, bool given in /var/www/html/libs/core/classes/c_db.php on line 313
@sql 10.14.2024 19:22:22 - 10.128.10.46 > SELECT spgl.product_id,
spgl.currency_id,
spgl.price_nofees,
spgl.tax_nofees,
spgl.price_tax_notrounded_nofees,
spgl.price_tax_nofees,
spgl.fee_rema,
spgl.fee_rema_tax,
spgl.fee_rema_withtax,
spgl.fee_author,
spgl.fee_author_tax,
spgl.fee_author_withtax,
spgl.price,
spgl.tax,
spgl.price_tax_notrounded,
spgl.price_tax,
spgl.price_rec,
spgl.discount,
spgl.discount_percent,
spgl.no_action_price,
spgl.no_action_price_tax
FROM view_s_pricelist_generated_lists_customer AS spgl
WHERE spgl.product_id IN (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,)
AND spgl.customer_id = 0
AND spgl.currency_id = 1
@error: ERROR: syntax error at or near ","
LINE 23: WHERE spgl.product_id IN (,,,,,,,,,,,,,,...
^
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warning: pg_fetch_array() expects parameter 1 to be resource, bool given in /var/www/html/libs/core/classes/c_db.php on line 325 @sql 10.14.2024 19:22:22 - 10.128.10.46 > select sub.product_id, SUM(quantity) as quantity FROM (
SELECT CASE WHEN CURRENT_DATE BETWEEN sprh.del_date AND sprh.end_date THEN true ELSE false END AS running,
ARRAY_AGG(CASE WHEN sprg.is_b2c = true THEN 0 WHEN sprh.customer_id > 0 THEN sprh.customer_id WHEN sprh.customer_id IS NULL AND jcrg.customer_id IS NULL THEN -1 ELSE jcrg.customer_id END) as targ_customer_id,
sprr.product_id, sprr.row_id, COALESCE(sprr.quantity, 0::numeric) - COALESCE(sprr.quantity_actual, 0::numeric) AS quantity
FROM s_product_reservation_row sprr, s_product_reservation_header sprh
LEFT JOIN s_product_reservation_groups sprg ON (sprg.reservation_group_id = sprh.reservation_group_id)
LEFT JOIN j_customers_reservation_groups jcrg ON (jcrg.reservation_group_id = sprg.reservation_group_id)
WHERE sprr.status = 1
AND sprr.order_no IS NULL
AND sprh.reservation_id = sprr.reservation_id
and sprr.product_id IN (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,)
GROUP BY running, sprr.product_id, sprr.row_id, quantity) sub
WHERE (NOT ARRAY[0] <@ sub.targ_customer_id OR (ARRAY[0] <@ sub.targ_customer_id AND sub.running = false))
GROUP BY sub.product_id
@error: ERROR: syntax error at or near ","
LINE 11: and sprr.product_id IN (,,,,,,,,,,,,...
^
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warning: pg_fetch_row() expects parameter 1 to be resource, bool given in /var/www/html/libs/core/classes/c_db.php on line 313