BP_Media_Model

BuddyBoss Media Model
Description

Source

File: bp-media/classes/class-bp-media-model.php
abstract class BP_Media_Model {
 
    static $primary_key = 'id';
 
    /**
     * Get the DB table
     *
     * @since BuddyBoss 1.0.0
     *
     * @return string
     */
    private static function _table() {
        $bp_prefix = bp_core_get_table_prefix();
        $tablename = strtolower( get_called_class() );
 
        return $bp_prefix . $tablename;
    }
 
    /**
     * Fetch SQL
     *
     * @param $value
     *
     * @since BuddyBoss 1.0.0
     *
     * @return string|void
     */
    private static function _fetch_sql( $value ) {
        global $wpdb;
        $sql = sprintf( 'SELECT * FROM %s WHERE %s = %%s', self::_table(), static::$primary_key );
 
        return $wpdb->prepare( $sql, $value );
    }
 
    /**
     * Get the single item data
     *
     * @param $value
     *
     * @since BuddyBoss 1.0.0
     *
     * @return array|null|object|void
     */
    static function get( $value ) {
        global $wpdb;
 
        return $wpdb->get_row( self::_fetch_sql( $value ) );
    }
 
    /**
     * Insert into table
     *
     * @param $data
     *
     * @since BuddyBoss 1.0.0
     */
    static function insert( $data ) {
        global $wpdb;
        return $wpdb->insert( self::_table(), $data );
    }
 
    /**
     * Update the data in table
     *
     * @param $data
     * @param $where
     *
     * @since BuddyBoss 1.0.0
     */
    static function update( $data, $where ) {
        global $wpdb;
        return $wpdb->update( self::_table(), $data, $where );
    }
 
    /**
     * Delete from the table
     *
     * @param $value
     * @param bool $media_id
     *
     * @since BuddyBoss 1.0.0
     *
     * @return bool|false|int
     */
    static function delete( $value, $media_id = false ) {
        global $wpdb;
 
        if ( empty( $media_id ) ) {
            $media    = self::get( $value );
            $media_id = $media->media_id;
        }
        wp_delete_post( $media_id, true );
 
        $sql = sprintf( 'DELETE FROM %s WHERE %s = %%s', self::_table(), static::$primary_key );
 
        return $wpdb->query( $wpdb->prepare( $sql, $value ) );
    }
 
    /**
     * Fetch data from table with conditions on column
     *
     * @param $columns
     * @param bool $offset
     * @param bool $per_page
     * @param string $order_by
     *
     * @since BuddyBoss 1.0.0
     *
     * @return array|null|object
     */
    static function where( $columns, $offset = false, $per_page = false, $order_by = 'id desc' ) {
        $select = 'SELECT * FROM ' . self::_table();
        $where  = ' where 2=2 ';
        foreach ( $columns as $colname => $colvalue ) {
            if ( is_array( $colvalue ) ) {
                if ( ! isset( $colvalue['compare'] ) ) {
                    $compare = 'IN';
                } else {
                    $compare = $colvalue['compare'];
                }
                if ( ! isset( $colvalue['value'] ) ) {
                    $colvalue['value'] = $colvalue;
                }
                $col_val_compare = ( $colvalue['value'] ) ? '(\'' . implode( "','", $colvalue['value'] ) . '\')' : '';
                $where           .= " AND " . self::_table() . ".{$colname} {$compare} {$col_val_compare}";
            } else {
                $where .= " AND " . self::_table() . ".{$colname} = '{$colvalue}'";
            }
        }
        $sql = $select . $where;
        $sql .= " ORDER BY " . self::_table() . ".$order_by";
        if ( false !== $offset ) {
            if ( ! is_integer( $offset ) ) {
                $offset = 0;
            }
            if ( intval( $offset ) < 0 ) {
                $offset = 0;
            }
            if ( ! is_integer( $per_page ) ) {
                $per_page = 1;
            }
            if ( intval( $per_page ) < 0 ) {
                $per_page = 1;
            }
            $sql .= ' LIMIT ' . $offset . ',' . $per_page;
        }
        global $wpdb;
 
        return $wpdb->get_results( $sql );
    }
 
    /**
     * Fetch the rows
     *
     * @param $columns
     *
     * @since BuddyBoss 1.0.0
     *
     * @return null|string
     */
    static function rows( $columns ) {
        $select = 'SELECT COUNT(*) FROM ' . self::_table();
        $where  = ' where 2=2 ';
        foreach ( $columns as $colname => $colvalue ) {
            if ( is_array( $colvalue ) ) {
                if ( ! isset( $colvalue['compare'] ) ) {
                    $compare = 'IN';
                } else {
                    $compare = $colvalue['compare'];
                }
                if ( ! isset( $colvalue['value'] ) ) {
                    $colvalue['value'] = $colvalue;
                }
                $col_val_comapare = ( $colvalue['value'] ) ? '(\'' . implode( "','", $colvalue['value'] ) . '\')' : '';
                $where            .= " AND " . self::_table() . ".{$colname} {$compare} {$col_val_comapare}";
            } else {
                $where .= " AND " . self::_table() . ".{$colname} = '{$colvalue}'";
            }
        }
        $sql = $select . $where;
        global $wpdb;
 
        return $wpdb->get_var( $sql );
    }
 
    /**
     * Get the insert id
     *
     * @since BuddyBoss 1.0.0
     *
     * @return int
     */
    static function insert_id() {
        global $wpdb;
 
        return $wpdb->insert_id;
    }
 
    /**
     * Convert time to date format
     *
     * @param $time
     *
     * @since BuddyBoss 1.0.0
     *
     * @return false|string
     */
    static function time_to_date( $time ) {
        return gmdate( 'Y-m-d H:i:s', $time );
    }
 
    /**
     * Get now timestamp
     *
     * @since BuddyBoss 1.0.0
     * @return false|string
     */
    static function now() {
        return self::time_to_date( time() );
    }
 
    /**
     * Convert date to time
     *
     * @param $date
     *
     * @since BuddyBoss 1.0.0
     *
     * @return false|int
     */
    static function date_to_time( $date ) {
        return strtotime( $date . ' GMT' );
    }
 
}
Expand full source code Collapse full source code
Changelog

Changelog
Version	Description
BuddyBoss 1.0.0	Introduced.
Methods

_fetch_sql — Fetch SQL
_table — Get the DB table
date_to_time — Convert date to time
delete — Delete from the table
get — Get the single item data
insert — Insert into table
insert_id — Get the insert id
now — Get now timestamp
rows — Fetch the rows
time_to_date — Convert time to date format
update — Update the data in table
where — Fetch data from table with conditions on column
Questions?

We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.
Contents

Description

Source

Changelog

Methods

Questions?
