From c78d8e4bbb5df21bc0f6334cbfc16b0ce115d860 Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Wed, 26 Jun 2024 11:44:06 +0300 Subject: [PATCH] =?utf8?q?=D0=9F=D0=BE=D0=BF=D1=80=D0=B0=D0=B2=D0=B8=D0=BB?= =?utf8?q?=20=D0=BF=D1=80=D0=B0=D0=B2=D1=8B=D0=B9=20=D0=BA=D1=80=D0=B0?= =?utf8?q?=D0=B9=20=D0=B2=D1=8B=D0=B1=D0=BE=D1=80=D0=BA=D0=B8=20=D1=87?= =?utf8?q?=D0=B5=D0=BA=D0=BE=D0=B2=20=D0=B4=D0=BE=20=D0=BA=D0=BE=D0=BD?= =?utf8?q?=D1=86=D0=B0=20=D0=B2=D1=8B=D0=B1=D1=80=D0=B0=D0=BD=D0=BD=D0=BE?= =?utf8?q?=D0=B3=D0=BE=20=D0=B4=D0=BD=D1=8F?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- erp24/modul/orders/collation.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/erp24/modul/orders/collation.php b/erp24/modul/orders/collation.php index 33b2e7d9..0a155715 100644 --- a/erp24/modul/orders/collation.php +++ b/erp24/modul/orders/collation.php @@ -146,9 +146,9 @@ foreach($data as $row) { } - + $sql = "SELECT id, operation, summ, number, date, store_id_1c, order_id FROM sales WHERE date>='" . $delivery_date - . "'::date - INTERVAL '25 day' AND date<='" . $delivery_date . "' AND operation IN ('Возврат', 'Продажа') order by date DESC"; + . "'::date - INTERVAL '20 day' AND date<='" . $delivery_date . " 23:59:59' AND operation IN ('Возврат', 'Продажа') order by date DESC"; $checkarr= $db::getRows($sql); //$cheks_txt="; -- 2.39.5