From 90b4e5673ec8805a9cf59d3fc21e1d0d99bf9e42 Mon Sep 17 00:00:00 2001 From: Aleksey Filippov Date: Thu, 4 Sep 2025 23:21:20 +0300 Subject: [PATCH] =?utf8?q?=D0=9F=D1=80=D0=B0=D0=B2=D0=BA=D0=B0=20=D0=B7?= =?utf8?q?=D0=B0=D0=BF=D1=80=D0=BE=D1=81=D0=B0=20=D0=BD=D0=B0=20=D0=BF?= =?utf8?q?=D0=BE=D0=BB=D1=83=D1=87=D0=B5=D0=BD=D0=B8=D0=B5=20=D1=81=D0=BF?= =?utf8?q?=D0=B8=D1=81=D0=BA=D0=B0=20=D1=82=D0=BE=D0=B2=D0=B0=D1=80=D0=BE?= =?utf8?q?=D0=B2?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- erp24/records/Products1c.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/erp24/records/Products1c.php b/erp24/records/Products1c.php index f0b7e246..dde0e87f 100644 --- a/erp24/records/Products1c.php +++ b/erp24/records/Products1c.php @@ -134,7 +134,7 @@ class Products1c extends \yii\db\ActiveRecord $query = self::find() ->select(['name', 'products_1c.id' , 'parent_id']) ->andWhere('tip=:tip', [':tip' => $tip]) - ->innerJoin('prices_dynamic', 'products_1c.id = prices_dynamic.product_id') + ->innerJoin('prices_dynamic', 'products_1c.id = prices_dynamic.product_id AND prices_dynamic.active = 1') ; $listAllProductsPreparedDict = $query->orderBy(['products_1c.name' => SORT_ASC])->asArray() -- 2.39.5