ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / ldqm1 / wp-content / plugins / woocommerce-sendinblue-newsletter-subscription / model

<?php
/**
 * Model class <i>SIB_Model_Contact</i> represents account
 * @package SIB_Model
 */

class SIB_Model_Contact
{
    /**
     * Tab table name
     */
    const table_name = 'sib_model_contact';

/**
     * Holds found campaign count
     */
    static $found_count;

/**
     * Holds all campaign count
     */
    static $all_count;

/** Create Table */
    public static function create_table()
    {
        global $wpdb;
        // create list table
        $creation_query =
            'CREATE TABLE IF NOT EXISTS ' . $wpdb->prefix  .self::table_name . ' (
			`id` int(20) NOT NULL AUTO_INCREMENT,
			`email` varchar(255),
            `info` TEXT,
            `code` varchar(100),
            `is_activate` int(2),
			`extra` TEXT,
			PRIMARY KEY (`id`)
			);';
        $wpdb->query( $creation_query );
    }

/**
     * Remove table
     */
    public static function remove_table()
    {
        global $wpdb;
        $query = 'DROP TABLE IF EXISTS ' . $wpdb->prefix  .self::table_name . ';';
        $wpdb->query($query);
    }

/**
     * Get data by id
     * @param $id
     */
    public static function get_data($id)
    {
        global $wpdb;
        $query = $wpdb->prepare('select * from ' . $wpdb->prefix  .self::table_name . ' ' . ' where id= %d ',array(esc_sql($id)));
        $results = $wpdb->get_results($query, ARRAY_A);

if(is_array($results))
            return $results[0];
        else
            return false;
    }

/**
     * Get data by code
     */
    public static function get_data_by_code($code)
    {
        global $wpdb;
        $query = $wpdb->prepare('select * from ' . $wpdb->prefix  .self::table_name . ' ' . ' where code like %s',array(esc_sql($code)));
        $results = $wpdb->get_results($query, ARRAY_A);

if(is_array($results))
            return $results[0];
        else
            return false;
    }

/**
     * Get code by email
     */
    public static function get_data_by_email($email)
    {
        global $wpdb;
        $query = $wpdb->prepare('select * from ' . $wpdb->prefix  .self::table_name . ' ' . ' where email like %s',array(esc_sql($email)));
        $results = $wpdb->get_results($query, ARRAY_A);

if(is_array($results) && count($results)>0)
            return $results[0];
        else
            return false;
    }

/** Add record */
    public static function add_record($data)
    {
        global $wpdb;

if(self::is_exist_same_email($data['email']) == true) {
            return false;
        }

$query = $wpdb->prepare("INSERT INTO " . $wpdb->prefix  .self::table_name . ' ' . "(email,info,code,is_activate,extra) VALUES (%s,%s,%s,%d,%s)",array(esc_sql($data['email']),esc_sql($data['info']),esc_sql($data['code']),esc_sql($data['is_activate']),esc_sql($data['extra'])));

$wpdb->query( $query );

$index = $wpdb->get_var('SELECT LAST_INSERT_ID();');

return $index;

}

public static function is_exist_same_email($email, $id='')
    {
        global $wpdb;

$query = $wpdb->prepare('select * from ' . $wpdb->prefix  .self::table_name . ' ' . ' where email like %s ',array(esc_sql($email)));

$results = $wpdb->get_results($query, ARRAY_A);

if(is_array($results) && (count($results) > 0)) {
            if($id == '')
                return true;
            if (isset($results) && is_array($results)) {
                foreach($results as $result)
                {
                    if($result['id'] != $id) {
                        return true;
                    }
                }
            }
        }

return false;
    }

/** Remove guest */
    public static function remove_record($id)
    {
        global $wpdb;

$query = $wpdb->prepare('delete from ' . $wpdb->prefix  .self::table_name . ' ' . ' where id= %d ',array(esc_sql($id)));

$wpdb->query($query);
    }

/** Get all guests by pagenum, per_page*/
    public static function get_all($orderby='email', $order='asc', $pagenum=1, $per_page=15)
    {
        global $wpdb;
        $limit = ($pagenum - 1) * $per_page;
        $query = $wpdb->prepare('SELECT * FROM ' . $wpdb->prefix  .self::table_name . ' ' . ' ORDER BY %s %s LIMIT %d , %d' ,array(esc_sql($orderby),esc_sql($order),esc_sql($limit),esc_sql($per_page)));

$results = $wpdb->get_results($query, ARRAY_A);
        self::$found_count =  self::get_count_element();

if(!is_array($results)) {
            $results = array();
            return $results;
        }

return $results;
    }

/** get all records of table */
    public static function get_all_records()
    {
        global $wpdb;

$query = 'select * from ' . $wpdb->prefix  .self::table_name . ' ' . ' order by email asc'; 
            
        $results = $wpdb->get_results($wpdb->prepare($query), ARRAY_A);

if(!is_array($results)) {
            $results = array();
            return $results;
        }

return $results;
    }

/** get count of row */
    public static function get_count_element()
    {
        global $wpdb;

$query = 'Select count(*) from ' . $wpdb->prefix  .self::table_name . ';';  
            
        $count = $wpdb->get_var($wpdb->prepare($query));

return $count;
    }

/** update record */
    public static function update_element($id, $data)
    {
        global $wpdb;

if(self::is_exist_same_email($data['email'], $id) == true) {
            return false;
        }

$query = $wpdb->prepare( "update " . $wpdb->prefix  .self::table_name . ' ' . "set email='{%s}',info='{%s}',code='{%s}',is_activate='{%d}',extra='{%s}' where id= %d",array(esc_sql($data['email']),esc_sql($data['info']),esc_sql($data['code']),esc_sql($data['is_activate']),esc_sql($data['extra']),esc_sql($id)));

$wpdb->query($query);

return true;
    }

/** Add prefix to the table */
    public static function add_prefix() {
        global $wpdb;
        if ( $wpdb->get_var( "SHOW TABLES LIKE '" . self::table_name . "'" ) == self::table_name ) {
                $query = 'ALTER TABLE ' . self::table_name . ' RENAME TO ' . $wpdb->prefix . self::table_name . ';';
                $wpdb->query( $query ); // db call ok; no-cache ok.
            }
    }

}

[+] ..
[-] index.php [edit]
[-] model-contacts.php [edit]
[-] country_code.csv [edit]
[-] model-country.php [edit]