From 473ecd27f7c1e264414ab828b2b371a5da3a3d1c Mon Sep 17 00:00:00 2001
From: Aleksey Filippov <Aleksey.Filippov@erp-flowers.ru>
Date: Wed, 19 Nov 2025 15:07:27 +0300
Subject: [PATCH] =?utf8?q?ERP-493=20=D0=9A=D0=BE=D0=BC=D0=B0=D0=BD=D0=B4?=
 =?utf8?q?=D0=B0=20=D0=B4=D0=BB=D1=8F=20=D0=BE=D1=87=D0=B8=D1=81=D1=82?=
 =?utf8?q?=D0=BA=D0=B8=20=D0=BB=D0=BE=D0=B3=D0=BE=D0=B2?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/commands/CronClearController.php | 47 ++++++++++++++++++++++++++
 1 file changed, 47 insertions(+)
 create mode 100644 erp24/commands/CronClearController.php

diff --git a/erp24/commands/CronClearController.php b/erp24/commands/CronClearController.php
new file mode 100644
index 00000000..e58c734f
--- /dev/null
+++ b/erp24/commands/CronClearController.php
@@ -0,0 +1,47 @@
+<?php
+
+namespace yii_app\commands;
+
+use Yii;
+use yii\console\Controller;
+use yii\console\ExitCode;
+use yii_app\records\ApiLogs;
+
+/**
+ * CronClear command controller
+ */
+class CronClearController extends Controller
+{
+    /**
+     * Default action
+     * @return int Exit code
+     */
+    public function actionIndex()
+    {
+        echo "CronClear command executed\n";
+
+        return ExitCode::OK;
+    }
+
+    /**
+     * Clear old API logs older than 8 days
+     * @return int Exit code
+     */
+    public function actionClearOldApiLogs()
+    {
+        echo "Starting cleanup of old API logs...\n";
+
+        try {
+            $deletedCount = ApiLogs::deleteAll(
+                ['<', 'date', new \yii\db\Expression("NOW() - INTERVAL '8 days'")]
+            );
+
+            echo "Successfully deleted {$deletedCount} old API log records\n";
+
+            return ExitCode::OK;
+        } catch (\Exception $e) {
+            echo "Error during cleanup: " . $e->getMessage() . "\n";
+            return ExitCode::UNSPECIFIED_ERROR;
+        }
+    }
+}
-- 
2.39.5