From 95ec7617246120556a4f3dcb5178d9a158c31456 Mon Sep 17 00:00:00 2001
From: AndreaChirulescu <andrea.chirulescu@gmail.com>
Date: Wed, 7 Apr 2021 23:28:10 +0200
Subject: Checkbox for own concerts added

---
 includes/admin/views/giglog_admin_page.php | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

diff --git a/includes/admin/views/giglog_admin_page.php b/includes/admin/views/giglog_admin_page.php
index cb8a4a5..637820f 100644
--- a/includes/admin/views/giglog_admin_page.php
+++ b/includes/admin/views/giglog_admin_page.php
@@ -52,7 +52,7 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) {
                 filter_input(INPUT_POST, "selectcity", FILTER_SANITIZE_SPECIAL_CHARS)
                 || $cities[0];
 
-            $select = '<form method="POST" action=""><select name="selectcity">';
+            $select = '<form method="POST" action="">FILTER DATA: <select name="selectcity">';
 
             foreach ( $cities AS $city ) {
                 $select .= '<option value="' . $city . '"' . selected($city, $selected_city) . '>';
@@ -78,8 +78,12 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) {
 
                 $select .= '</select>';
             }
+            //option to select own concerts only
+            $select .= '<input  class="ownconc" type="checkbox" value="1"';
+                if(isset($_POST['my_checkbox'])) $select .=' checked="checked" ';
+            $select.=' name="my_checkbox">Show own concerts only</input>';
 
-            $select .= '<input type="submit" value="Filter"></form>';
+            $select .= '<input type="submit" value="APPLY"></form>';
 
             return $select;
         }
@@ -143,10 +147,11 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) {
 
             $query .= ($cty == "ALL") ? "" : "  and wpgv.wpgvenue_city='" .$cty ."'";
             $query .= ($venue == "0") ? "" : "  and wpgv.id='" .$venue ."'";
+            $query.= (empty($_POST['my_checkbox'])) ? "": " and (wpgcl_photo1 ='".$hf_username."' or wpgcl_photo2 ='".$hf_username."' or wpgcl_rev1 ='".$hf_username."' or wpgcl_rev2 ='".$hf_username."')";
             $query .=" order by wpgv.wpgvenue_city, wpgconcert_date, wpgc.id" ;
             $results = $wpdb->get_results($query);
-
             $lastType = '';
+
             foreach ( $results AS $row ) {
                 $content .= '<tr class="assignitr">';
 
-- 
cgit v1.2.3