function _populateCCUsers(){
global $db_conn;
if(intval($this->id) <= 0){
$this->error = "SI_Project::_populateCCUsers(): Project ID not set!";
return FALSE;
}
$this->ccs = array();
$sql = 'SELECT user_id FROM project_cc
WHERE project_id = '.intval($this->id);
$result = $db_conn->query($sql);
if($result === FALSE){
$this->error = "SI_Project::_populateCCUsers(): ".$db_conn->getLastError()."\n";
return FALSE;
}
$ids = array();
while($row = $result->fetchArray(MYSQL_ASSOC)){
$ids[] = $row['user_id'];
}
if(count($ids) > 0){
$user = new SI_User();
$users = $user->retrieveSet("WHERE u.id IN (".implode(', ', $ids).")");
if($users === FALSE){
$this->error = "SI_Project::_populateCCUsers(): ".$user->getLastError()."\n";
return FALSE;
}
$this->ccs = $users;
}
return TRUE;
}
function getUserByLogin($email, $password){
global $db_conn;
if(empty($email) || empty($password)){
$this->error = "Both Email and Password are required!";
return FALSE;
}
$users = SI_User::retrieveSet("email = '".$db_conn->escapeString($email)."' AND password = '******' AND u.active = 'Y' AND u.deleted = 'N'");
if(is_object($users[0]) && is_a($users[0], 'SI_User')){
$users[0]->last_login_ts = time();
$users[0]->_updateLastLogin();
return $users[0];
}else{
$this->error = "Username and password do not match any current accounts";
return FALSE;
}
}
