From ca9b998492e6d2b504f54feacb3b292ae6906555 Mon Sep 17 00:00:00 2001
From: Alexander Smirnov <fredeom@mail.ru>
Date: Sat, 27 Apr 2024 17:51:39 +0300
Subject: [PATCH] admin list

---
 .../v1/controllers/AdminController.php        | 39 +++++++++++++++++++
 1 file changed, 39 insertions(+)

diff --git a/erp24/api3/modules/v1/controllers/AdminController.php b/erp24/api3/modules/v1/controllers/AdminController.php
index 40a8dce..8e0ca7b 100644
--- a/erp24/api3/modules/v1/controllers/AdminController.php
+++ b/erp24/api3/modules/v1/controllers/AdminController.php
@@ -100,4 +100,43 @@ class AdminController extends \yii_app\api3\controllers\ActiveController
 
         return $response;
     }
+
+    public function actionList() {
+        $query = (new Query())
+            ->select([
+                'id' => new Expression("CONCAT('-', id)"),
+                'name' => 'name',
+                'group_id' => new Expression('27'),
+                'group_name' => new Expression("'Курьер'"),
+                'md5' => new Expression("MD5(CONCAT(id, ':', pass_user))"),
+                'md5_login' => new Expression("MD5(CONCAT(login_user, ':', pass_user))")
+            ])
+            ->from('admin')
+            ->where(['group_id' => 27])
+            ->limit(1000);
+
+        $admins = [];
+
+        $admins = array_merge($admins, $query->all());
+
+        // Получаем данные для остальных групп, кроме 27
+        $query = (new Query())
+            ->select([
+                'id',
+                'group_id',
+                'group_name',
+                'name',
+                'md5' => new Expression("MD5(CONCAT(id, ':', pass_user))"),
+                'md5_login' => new Expression("MD5(CONCAT(login_user, ':', pass_user))")
+            ])
+            ->from('admin')
+            ->where(['>', 'group_id', 0])
+            ->andWhere(['!=', 'group_id', 27])
+            ->orderBy(['group_id' => SORT_ASC])
+            ->limit(1000);
+
+        $admins = array_merge($admins, $query->all());
+
+        return $admins;
+    }
 }
\ No newline at end of file
-- 
2.39.5