From ce3a9c915d09be8e14f809f754c7e5743e1fbaa3 Mon Sep 17 00:00:00 2001
From: Alexander Smirnov <fredeom@mail.ru>
Date: Mon, 6 May 2024 19:04:47 +0300
Subject: [PATCH] sales phone filter fix

---
 erp24/actions/sales/IndexAction.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/erp24/actions/sales/IndexAction.php b/erp24/actions/sales/IndexAction.php
index 99a9f5fe..69ff52ec 100644
--- a/erp24/actions/sales/IndexAction.php
+++ b/erp24/actions/sales/IndexAction.php
@@ -5,6 +5,7 @@ namespace yii_app\actions\sales;
 use Yii;
 use yii\base\Action;
 use yii\base\DynamicModel;
+use yii\db\Expression;
 use yii\helpers\ArrayHelper;
 use yii_app\records\Admin;
 use yii_app\records\Products1c;
@@ -54,7 +55,7 @@ class IndexAction extends Action {
             $salesQuery = $salesQuery->andWhere(['LIKE', 'number', '%' . $filterModel->name . '%', false]);
         }
         if (!empty($filterModel->phone)) {
-            $salesQuery = $salesQuery->andWhere(['LIKE', 'phone', '%' . $filterModel->phone . '%', false]);
+            $salesQuery = $salesQuery->andWhere(['LIKE', new Expression('phone::varchar(20)'), '%' . $filterModel->phone . '%', false]);
         }
         if (!empty($filterModel->operation)) {
             $salesQuery = $salesQuery->andWhere(['LIKE', 'operation', '%' . $filterModel->operation . '%', false]);
-- 
2.39.5