/** * returns specific items * @param array $args ( default: $args[ 'field' ] == '*' ) list of args are field, category and id */ public static function get_items($args) { $fields = PSU::sql_select_fields($args['fields']); $sql = 'SELECT ' . $fields . ' FROM checklist_items WHERE category_id = ? ORDER BY name'; if ($args['category']) { return PSU::db('hr')->GetAll($sql, array($args['category'])); } if ($args['id']) { return PSU::db('hr')->GetAll($sql, array($args['id'])); } // return $items; }