Pommo_Groups::makeDB PHP Method

makeDB() static public method

return a group object (array)
static public makeDB ( &$row )
    static function &makeDB(&$row)
    {
        $in = @array('id' => $row['group_id'], 'name' => $row['group_name']);
        $o = Pommo_Type::group();
        return Pommo_Api::getParams($o, $in);
    }

Usage Example

Example #1
0
 static function &get($p = array())
 {
     $defaults = array('id' => null);
     $p = Pommo_Api::getParams($defaults, $p);
     $dbo =& Pommo::$_dbo;
     $o = array();
     $query = "\n            SELECT g.group_id, g.group_name, c.rule_id, c.field_id, c.logic, c.value, c.type\n            FROM " . $dbo->table['groups'] . " g\n            LEFT JOIN " . $dbo->table['group_rules'] . " c\n                ON (g.group_id = c.group_id)\n            WHERE\n                1\n                [AND g.group_id IN(%C)]\n            ORDER BY g.group_name";
     $query = $dbo->prepare($query, array($p['id']));
     while ($row = $dbo->getRows($query)) {
         if (empty($o[$row['group_id']])) {
             $o[$row['group_id']] = Pommo_Groups::makeDB($row);
         }
         if (!empty($row['rule_id'])) {
             $c = array('field_id' => $row['field_id'], 'logic' => $row['logic'], 'value' => $row['value'], 'or' => $row['type'] == 0 ? false : true);
             $o[$row['group_id']]['rules'][$row['rule_id']] = $c;
         }
     }
     return $o;
 }