From 68fc9e55e538e03f94509731ab41a0c8cf96710f Mon Sep 17 00:00:00 2001
From: George Halkiadakis <gchalkiadakis@sklavenitis.co.gr>
Date: Mon, 17 Apr 2023 12:12:22 +0300
Subject: setup a real server environment (apache DocumentRoot=/var/www/public)

---
 public/app/controllers/cli/CliContoller.php | 85 +++++++++++++++++++++++++++++
 1 file changed, 85 insertions(+)
 create mode 100644 public/app/controllers/cli/CliContoller.php

(limited to 'public/app/controllers/cli/CliContoller.php')

diff --git a/public/app/controllers/cli/CliContoller.php b/public/app/controllers/cli/CliContoller.php
new file mode 100644
index 0000000..310e2ae
--- /dev/null
+++ b/public/app/controllers/cli/CliContoller.php
@@ -0,0 +1,85 @@
+<?php
+
+namespace app\controllers\cli;
+
+/** CliContoller
+ * 
+ * Re-generate cashes of commonly used entities
+ * like: product categories and trendy products
+ * (proxy calls make use of PROXY_IGNORE_CACHE)
+ * 
+ * CliController calls Model methods who create
+ * cashed data with the exact same arguments as
+ * when called from the web interface; this way
+ * the Model::method(arguments) triplete creates
+ * the same keys as via the web interface.
+ * 
+ * NOTE: Only Cli interface is allowed
+ * [if (php_sapi_name() != 'cli') return false;]
+ * 
+ * The Cli-interfaced script can run manualy or
+ * (most usual scenario) scheduled via a cron job
+ * in order to refresh cashes befor expiration.
+ * 
+ * ---------------------------------------------
+ */
+class CliContoller
+{
+
+
+    /** (re-) cacheCategoriesTree
+     * regenerate cache for product_categories tree
+     * @param (void) 
+     */
+    public static function cacheCategoriesTree()
+    {   
+        // Only Cli interface is allowed
+        if (php_sapi_name() != 'cli') return false;
+
+        # PROXY call:
+        # MARKET \ ProductCategories_model::tree(): 
+        # + Refresh Cache
+        # --------------------------------------
+        echo textColor("Creating category_products tree Cache ... ", \NORMAL);
+        $reply = proxy(
+            [\app\models\market\ProductCategories_model::class, 'tree'],
+            [], \CACHE_ROOT_TTL,
+            \PROXY_IGNORE_CACHE
+        );
+        echo ($reply == false) ? textColor("Failed\n", \FAIL) : textColor("Done!\n", \SUCCESS);
+    }
+
+
+
+    public static function getProductCategories()
+    {
+        return \Registry::use('database')->runQuery(
+            "SELECT * FROM product_categories",
+            []
+        );
+    }
+
+
+
+    /** (re-) cacheCategoryByUrl( url )
+     * regenerate cache of a category_product
+     * by category's friendly url
+     * @param $url (string): the category's friendly url
+     */
+    public static function cacheCategoryByUrl(string $url)
+    {
+        // Only Cli interface is allowed
+        if (php_sapi_name() != 'cli') return false;
+
+        # PROXY call:
+        # MARKET \ ProductCategories_model::tree(): 
+        # + Refresh Cache
+        # --------------------------------------
+        $reply = proxy(
+            [\app\models\market\ProductCategories_model::class, 'categoryFromUrl'],
+            [ $url ], \CACHE_CATEGORY_TTL,
+            \PROXY_IGNORE_CACHE
+        );
+        echo ($reply == false) ? textColor("Failed\n", \FAIL) : textColor("Done!\n", \SUCCESS);
+    }
+}
\ No newline at end of file
-- 
cgit v1.2.3