Changeset 3083859

Timestamp:

05/09/2024 10:31:57 AM (21 months ago)

Author:

xtoool

Message:

add custom ads

Location:

xtoool-ads-box/trunk

Files:

• lib/AdsbxAdmin.php (modified) (2 diffs)
• lib/Shortcode.php (modified) (1 diff)
• template/add_custom_ads.php (added)
• template/list_custom_ads.php (added)
• xtoool-ads-box.php (modified) (5 diffs)

xtoool-ads-box/trunk/lib/AdsbxAdmin.php

@@ -15 +15 @@
         add_action('wp_ajax_adsbx_ads_list', [$this, 'adsbx_ads_list']);
         add_action('wp_ajax_adsbx_delete_ads', [$this, 'adsbx_delete_ads']);
+
+        add_action('wp_ajax_adsbx_save_custom_ads', [$this, 'adsbx_save_custom_ads']);
+        add_action('wp_ajax_adsbx_custom_ads_list', [$this, 'adsbx_ads_custom_list']);
+        add_action('wp_ajax_adsbx_delete_custom_ads', [$this, 'adsbx_delete_custom_ads']);
     }
 
@@ -146 +150 @@
     }
 
+    public function add_custom_ad(){
+        $id = intval(sanitize_text_field(isset($_GET['id']) ? $_GET['id'] : 0));
+        $data = [];
+        if($id){
+            $sql = 'select * from ' . $this->obj->db->prefix . 'xtl_custom_ads where id = %d limit 1';
+            $sql_pre = $this->obj->db->prepare($sql, $id);
+            $data = $this->obj->db->get_row($sql_pre, ARRAY_A);
+        }
+        include_once XTPLB_DIR . '/template/add_custom_ads.php';
+    }
+
+    public function custom_list(){
+        include_once XTPLB_DIR . '/template/list_custom_ads.php';
+    }
+
+    public function adsbx_delete_custom_ads(){
+        $code = 0;
+        $msg = '';
+        $data = '';
+        $id = intval(sanitize_text_field($_POST['id']));
+        if(! $id){
+            $msg =  __('params error', 'xt-adsbx');
+            return wp_send_json(
+                [
+                    'code'   => $code,
+                    'msg'  => $msg,
+                    'data' => $data
+                ]
+            );
+        }
+        $res = $this->obj->db->delete($this->obj->db->prefix . 'xtl_custom_ads', ['id' => $id]);
+        if($res !== false){
+            $code =  1;
+        }else{
+            $msg = __('delete failed', 'xt-adsbx');
+        }
+        return wp_send_json(
+            [
+                'code'   => $code,
+                'msg'  => $msg,
+                'data' => $data
+            ]
+        );
+    }
+
+    public function adsbx_ads_custom_list(){
+        $code = 0;
+        $msg = '';
+        $data = '';
+        $where = '';
+        $keyword = trim(addslashes(sanitize_text_field($_POST['keyword'])));
+        if($keyword){
+            $where .= ' and name like "%' . $keyword . '%"';
+        }
+
+        $pre = $this->obj->db->prefix;
+
+        $sql_count = 'select count(*) as count from ' . $pre . 'xtl_custom_ads where 1=1 ' . $where;
+        $count = $this->obj->db->get_var($sql_count);
+        $sql = 'select * from ' . $pre . 'xtl_custom_ads where 1=1 ' . $where . ' order by id desc';
+        $list = $this->obj->db->get_results($sql, ARRAY_A);
+
+        return wp_send_json(
+            [
+                'code'   => $code,
+                'msg'  => $msg,
+                'count' => $count,
+                'data' => $list
+            ]
+        );
+
+    }
+
+    public function xtplb_expanded_alowed_tags() {
+        $my_allowed = wp_kses_allowed_html( 'post' );
+        // iframe
+        $my_allowed['iframe'] = array(
+            'src'             => array(),
+            'height'          => array(),
+            'width'           => array(),
+            'frameborder'     => array(),
+            'allowfullscreen' => array(),
+        );
+        // form fields - input
+        $my_allowed['input'] = array(
+            'class' => array(),
+            'id'    => array(),
+            'name'  => array(),
+            'value' => array(),
+            'type'  => array(),
+        );
+        // select
+        $my_allowed['select'] = array(
+            'class'  => array(),
+            'id'     => array(),
+            'name'   => array(),
+            'value'  => array(),
+            'type'   => array(),
+        );
+        // select options
+        $my_allowed['option'] = array(
+            'selected' => array(),
+            'value' => []
+        );
+        // style
+        $my_allowed['style'] = array(
+            'types' => array(),
+        );
+    
+        return $my_allowed;
+    }
+
+    public function adsbx_save_custom_ads(){
+        $code = 0;
+        $msg = '';
+        $data = '';
+        $id = intval(sanitize_text_field($_POST['id']));
+        $name = sanitize_text_field($_POST['name']);
+        $content = html_entity_decode($_POST['content']);
+        
+        $code = uniqid();
+        $shotcode = '[xt-ads-custom code="' . $code . '"]';
+        $data = [
+            'name' => $name,
+            'content' => $content
+        ];
+        $pre = $this->obj->db->prefix;
+        $user_id = get_current_user_id();
+        $date = date('Y-m-d H:i:s');
+        if($id){
+            
+            $data['updated_by'] = $user_id;
+            $data['updated_date'] = $date;
+            $res = $this->obj->db->update($pre . 'xtl_custom_ads', $data, ['id' => $id]);
+        }else{
+            $data['code'] = $code;
+            $data['shotcode'] = $shotcode;
+            $data['added_by'] = $user_id;
+            $data['added_date'] = $date;
+            $res = $this->obj->db->insert($pre . 'xtl_custom_ads', $data);
+        }
+        if($res){
+            $code = 1;
+            $msg = 'Save Success';
+        }
+
+        return wp_send_json(
+            [
+                'code'   => $code,
+                'msg'  => $msg,
+                'data' => ''
+            ]
+        );
+
+    }
+
 
 }

xtoool-ads-box/trunk/lib/Shortcode.php

@@ -13 +13 @@
         // [xt-ads-banner id="4444"]
         add_shortcode('xt-ads-banner', [$this, 'showBanner']);
+        add_shortcode('xt-ads-custom', [$this, 'showCustom']);
+    }
+
+    public function showCustom($attr){
+        if(! isset($attr['code'])){
+            return '';
+        }
+        $id = $attr['code'];
+        if(! $id){
+            return '';
+        }
+        $sql = 'select content from ' . $this->obj->db->prefix . 'xtl_custom_ads where `code` = %s limit 1';
+        $sql_pre = $this->obj->db->prepare($sql, $id);
+        $temp = $this->obj->db->get_var($sql_pre);
+        if(! $temp){
+            return '';
+        }
+        ob_start();
+        echo $temp;
+        $data = ob_get_clean();
+        return $data;
     }
 

xtoool-ads-box/trunk/xtoool-ads-box.php

@@ -40 +40 @@
     private static $instance = null;
     public $db;
-    const XTPLB_VERSION = '1.0.6';
+    const XTPLB_VERSION = '1.0.7';
     public $AdsbxAdmin_obj = null;
 
@@ -60 +60 @@
         add_action( 'upgrader_process_complete', [$this, 'my_upgrate_function'], 10, 2);
 
+        // test hook
+        // do_action('upgrader_process_complete', null, ['action' => 'update', 'type' => 'plugin', 'plugins' => ['xtoool-ads-box/xtoool-ads-box.php']]);
+
         $this->_initScript();
 
@@ -78 +81 @@
         }
 
-        if(self::XTPLB_VERSION == '1.0.2'){
-            $this->_update_1_0_3();
-        }
-
+        if($this->_checkUpdate()){
+            $this->_update_1_0_7();
+        }
+
+    }
+
+    private function _checkUpdate(){
+        if(str_replace('.', '', self::XTPLB_VERSION) <= 107){
+            return true;
+        }else{
+            return false;
+        }
     }
 
@@ -104 +115 @@
   
   PRIMARY KEY (`id`)
+) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;';
+        $wpdb->query($sql4);
+    }
+
+    private function _update_1_0_7(){
+        $this->_update_1_0_3();
+
+        global $wpdb;
+        $sql4 = 'CREATE TABLE if not exists `' . $wpdb->prefix . 'xtl_custom_ads` (
+            `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(255) NOT NULL default "",
+  `shotcode` varchar(255) NOT NULL default "",
+  `code` varchar(255) NOT NULL default "",
+  `content` text default null,
+  `added_by` int(11) not null default 0,
+  `added_date` datetime default null,
+  `updated_by` int(11) not null default 0,
+  `updated_date` datetime default null,
+  
+  PRIMARY KEY (`id`),
+  unique key(shotcode),
+  unique key(`code`)
 ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;';
         $wpdb->query($sql4);
@@ -343 +376 @@
         add_submenu_page( 'product_list', 'products List', 'products List', 'manage_options', 'products_list_show', [&$this, 'productsShowList'] );
         add_submenu_page( 'product_list', 'Add products List', 'Add products list', 'manage_options', 'add_products_list', [&$this, 'addProductsList'] );
+        add_submenu_page( 'product_list', 'Custom Ad', 'Custom Ad', 'manage_options', 'custom_list', [$this->AdsbxAdmin_obj, 'custom_list'] );
+        add_submenu_page( 'product_list', 'Add Custom Ad', 'Add Custom Ad', 'manage_options', 'add_custom_ad', [$this->AdsbxAdmin_obj, 'add_custom_ad'] );
     }