File includes/wcap_functions.php

  1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66  67  68  69  70  71  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129

<?php
/**
 * Common function that can be used to get the data
 * from the notifications_meta table
 * 
 * @param integer $template_id - Template ID
 * @param string $meta_key - Meta Key
 * @return boolean|string - Meta Value. Returns false if meta key not found
 * 
 * @since 7.9
 */
function wcap_get_notification_meta( $template_id, $meta_key ) {
    
    global $wpdb;
    
    if( $template_id > 0 && $meta_key != '' ) {
        $get_query = "SELECT meta_value FROM `" . WCAP_NOTIFICATIONS_META . "`
                        WHERE template_id = %d
                        AND meta_key = %s";
        $query_data = $wpdb->get_results( $wpdb->prepare( $get_query, $template_id, $meta_key ) );
        
        if( is_array( $query_data ) && count( $query_data ) > 0 ) {
            return ( isset( $query_data[0]->meta_value ) ) ? $query_data[0]->meta_value : false;
        } else {
            return false;
        }
    } else {
        return false;
    }
    
}

/**
 * Common function that can be used to update the 
 * Notifications_meta table
 * 
 * @param integer $template_id - Template ID
 * @param string $meta_key - Meta Key
 * @param string $meta_value - Meta Value
 * 
 * @since 7.9
 */
function wcap_update_notification_meta( $template_id, $meta_key, $meta_value ) {
    
    global $wpdb;
    
    if( $template_id > 0 && $meta_key != '' ) {
        
        
        $update = $wpdb->update( WCAP_NOTIFICATIONS_META, 
                        array( 'meta_value' => $meta_value ),
                        array( 'template_id' => $template_id,
                               'meta_key' => $meta_key
                        ) 
            );
    
        if( $update == 0 ) { // no record was found for update
            wcap_add_notification_meta( $template_id, $meta_key, $meta_value );
        } 
    }
    
}

/**
 * Common function that can be used to insert in the 
 * Notifications_meta table
 * 
 * @param integer $template_id - Template ID
 * @param string $meta_key - Meta Key
 * @param string $meta_value - Meta Value
 * 
 * @since 7.9
 */
function wcap_add_notification_meta( $template_id, $meta_key, $meta_value ) {

    global $wpdb;
    
    $update = $wpdb->insert( WCAP_NOTIFICATIONS_META,
                array( 'template_id' => $template_id,
                       'meta_key' => $meta_key,
                       'meta_value' => $meta_value )
    );
     
}

/**
 * Returns the data from the Notifications meta 
 * table that have the meta key as passed
 * 
 * @param string $meta_key - Meta Key
 * @return array $results - Results array
 * 
 * @since 7.9
 */
function wcap_get_notification_meta_by_key( $meta_key ) {
    global $wpdb;
    
    $meta_query = "SELECT meta_id, template_id, meta_value FROM `" . WCAP_NOTIFICATIONS_META . "`
                    WHERE meta_key = %s";
    
    $meta_results = $wpdb->get_results( $wpdb->prepare( $meta_query, $meta_key ) );
    
    return $meta_results;
}

/**
 * Returns the template status
 * 
 * @param integer $template_id - Template ID
 * @return boolean $status - Template status - true - active|false - inactive
 * 
 * @since 7.9
 */
function wcap_get_template_status( $template_id ) {
    
    $status = false;

    global $wpdb;
    
    $status_query = "SELECT is_active FROM `" . WCAP_NOTIFICATIONS . "`
                    WHERE id = %d";

    $status_col = $wpdb->get_results( $wpdb->prepare( $status_query, $template_id ) );
    
    $status = ( isset( $status_col[0] ) ) ? $status_col[0]->is_active : false;
    
    return $status;
}
?>

Packages

Classes

Functions