Groups

<?php

class wpmlGroup extends wpMailPlugin {

    var $model = 'wpmlGroup';
    var $controller = 'groups';
    var $table;

    var $fields = array(
        'id'                =>  "INT(11) NOT NULL AUTO_INCREMENT",
        'title'             =>  "VARCHAR(100) NOT NULL DEFAULT ''",
        'created'           =>  "DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'",
        'modified'          =>  "DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'",
        'key'               =>  "PRIMARY KEY (`id`)",
    );

    var $tv_fields = array(
        'id'                =>  array("INT(11)", "NOT NULL AUTO_INCREMENT"),
        'title'             =>  array("VARCHAR(100)", "NOT NULL DEFAULT ''"),
        'created'           =>  array("DATETIME", "NOT NULL DEFAULT '0000-00-00 00:00:00'"),
        'modified'          =>  array("DATETIME", "NOT NULL DEFAULT '0000-00-00 00:00:00'"),
        'key'               =>  "PRIMARY KEY (`id`)",
    );

    function wpmlGroup($data = array()) {
        global $wpdb, $Db;
        $this -> table = $this -> pre . $this -> controller;

        if (!empty($data)) {
            foreach ($data as $dkey => $dval) {
                $this -> {$dkey} = stripslashes_deep($dval);
            }
        }

        return true;
    }

    function defaults() {
        global $Html;

        $defaults = array(
            'created'           =>  $Html -> gen_date(),
            'modified'          =>  $Html -> gen_date(),
        );

        return $defaults;
    }

    function validate($data = array()) {
        $this -> errors = array();

        $data = (empty($data[$this -> model])) ? $data : $data[$this -> model];
        $r = wp_parse_args($data, $defaults);
        extract($r, EXTR_SKIP);

        if (!empty($data)) {
            if (empty($title)) { $this -> errors['title'] = __('Please fill in a title for this group.', $this -> plugin_name); }
        } else {
            $this -> errors[] = __('No data was posted', $this -> plugin_name);
        }

        return $this -> errors;
    }

    function get_all_paginated($conditions = array(), $searchterm = null, $sub = 'newsletters-groups', $perpage = 15, $order = array('modified', "DESC")) {
        global $wpdb;

        $paginate = new wpMailPaginate($wpdb -> prefix . "" . $this -> table, "*", $sub);
        $paginate -> per_page = $perpage;
        $paginate -> searchterm = (empty($searchterm)) ? false : $searchterm;
        $paginate -> where = (empty($conditions)) ? false : $conditions;
        $paginate -> order = $order;
        $groups = $paginate -> start_paging($_GET[$this -> pre . 'page']);

        $data = array();
        $data['Pagination'] = $paginate;
        $data[$this -> model] = $groups;

        return $data;
    }

    function select() {
        global $wpdb, $Html;
        $query = "SELECT `id`, `title` FROM `" . $wpdb -> prefix . "" . $this -> table . "` ORDER BY `title` ASC";

        if ($groups = $wpdb -> get_results($query)) {
            if (!empty($groups)) {
                $groupsselect = array();

                foreach ($groups as $group) {
                    $groupsselect[$group -> id] = $group -> title;
                }

                return $groupsselect;
            }
        }

        return false;
    }
}

?>