git -C '/home/opc/rocketa.git' show 45de6a1 -- oci_func/click/func.py

commit 45de6a1d4fa7ddaa97757ca5d33499b443241a73
Author: Satoshi Ujihara <satoshi_ujihara@fivegate.jp>
Date:   Mon Nov 3 13:50:34 2025 +0900

    画像で文字を表示している部分をCSSに変更
    test click機能追加
    click時のsqlを元に戻した。

diff --git a/oci_func/click/func.py b/oci_func/click/func.py
index a0b986b..9a9afb0 100644
--- a/oci_func/click/func.py
+++ b/oci_func/click/func.py
@@ -158,14 +158,14 @@ def handler(ctx, data: io.BytesIO = None):
         sql_query += 'AND '
         sql_query += '    j.media_id = :media_id '
         sql_query += 'AND '
-        # sql_query += '    a.status = 1 '
-        # sql_query += 'AND '
-        # sql_query += '    j.status = 1 '
-        # sql_query += 'AND '
-        # sql_query += '    a.start_date <= CAST(:start_date AS DATETIME) '
-        # sql_query += 'AND '
-        # sql_query += '    a.end_date > CAST(:end_date AS DATETIME) '
-        # sql_query += 'AND '
+        sql_query += '    a.status = 1 '
+        sql_query += 'AND '
+        sql_query += '    j.status = 1 '
+        sql_query += 'AND '
+        sql_query += '    a.start_date <= CAST(:start_date AS DATETIME) '
+        sql_query += 'AND '
+        sql_query += '    a.end_date > CAST(:end_date AS DATETIME) '
+        sql_query += 'AND '
         sql_query += '    a.url != "" '
         sql_query += 'LIMIT 1 '
 
@@ -173,8 +173,8 @@ def handler(ctx, data: io.BytesIO = None):
             "master_ad_id": int(ad_id),
             "client_id": int(client_id),
             "media_id": int(media_id),
-            # "start_date": format_date,
-            # "end_date": format_date,
+            "start_date": format_date,
+            "end_date": format_date,
         }
         # SQLAlchemyが安全にクエリを組み立て、SQLインジェクションを防ぐ
         result = connection.execute(text(sql_query), params)