// list all staff who are not in a group.
$this->whereAdd("{$this->tableName()}.id NOT IN (
SELECT distinct(user_id) FROM $tn_gm LEFT JOIN
- $tn_g ON $tn_g.id = $tn_gm.group_id
- WHERE $tn_g.type = ".$q['query']['type']."
- )");
-
+ $tn_g ON $tn_g.id = $tn_gm.group_id)");
} else {
}
$c->find(true);
$this->company_id = $c->id;
+ $this->email = trim($this->email);
}
}
}
}
+ $this->email = trim($this->email);
}
function generateOathKey()