$url_site&EvnDirection_begInsDT=date("Y-m-d H:i:s", strtotime('2023-01-16 00:00:01'))
то ничего не происходит, сервер возвращает пустоту.
$url_site&EvnDirection_begInsDT='2023-01-16%2010:43:44';
То сервер возвращает данные.
SELECT
BIN,
SUM(
CASE WHEN collector = "Person A" THEN quantity ELSE 0 END
) AS "Person A",
SUM(
CASE WHEN collector = "Person B" THEN quantity ELSE 0 END
) AS "Person B",
SUM(
CASE WHEN collector = "Person C" THEN quantity ELSE 0 END
) AS "Person C"
FROM
bin_quantity
GROUP BY
BIN
SET @pivot_sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'SUM(CASE WHEN collector = "', `collector`, '" THEN quantity ELSE 0 end) AS "', `collector`, '"'
)
)
INTO @pivot_sql
FROM
bin_quantity;
SET @pivot_sql = CONCAT('SELECT bin, ', @pivot_sql, ' FROM bin_quantity GROUP BY bin');
PREPARE stmt FROM @pivot_sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.7.26-0ubuntu0.16.04.1-log - (Ubuntu)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
SET @pivot_sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'SUM(CASE WHEN collector = "', `collector`, '" THEN quantity ELSE 0 end) AS "', `collector`, '"'
)
)
INTO @pivot_sql
FROM
bin_quantity;
SET @pivot_sql = CONCAT('SELECT bin, ', @pivot_sql, ' FROM bin_quantity GROUP BY bin');
PREPARE stmt FROM @pivot_sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SELECT bin, SUM(CASE WHEN collector = "Person A" THEN quantity ELSE 0 end) AS "Person A",
SUM(CASE WHEN collector = "Person B" THEN quantity ELSE 0 end) AS "Person B",
SUM(CASE WHEN collector = "Person C" THEN quantity ELSE 0 end) AS "Person C"
FROM bin_quantity GROUP BY bin
SET @pivot_sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'SUM(CASE WHEN collector = "', `collector`, '" THEN quantity ELSE 0 end) AS "', `collector`, '"'
)
)
INTO @pivot_sql
FROM
bin_quantity;
SELECT @pivot_sql;