function opigno_class_app_get_my_classes in Opigno Class App 7

File

./opigno_class_app.views.inc, line 31

Code

function opigno_class_app_get_my_classes($userid) {
  $query = db_select('og_membership', 'og');
  $query
    ->condition('og.state', '1', '=');
  $query
    ->condition('og.group_type', 'node', '=');
  $query
    ->condition('og.entity_type', 'user', '=');
  $query
    ->condition('og.etid', $userid, '=');
  $query
    ->join('node', 'n', 'n.nid = og.gid');
  $query
    ->condition('n.type', 'class', '=');
  $query
    ->addField('n', 'nid', 'nid');
  return $query;
}