#------------------------------------------------------------
# Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved
# $Id$
#------------------------------------------------------------
package RPS::DB::Item::User;
use strict;
use warnings;
use lib '/app/tools/common/lib';
use Common::DB::Item;
use base 'Common::DB::Item';


use constant kTable => 'user';
use constant kDB => Common::DB::Item::kCommonDB();

sub Search
{
    my $class = shift;
    my $searchTerm = shift;

    return unless $searchTerm;

	my $where;

	if($searchTerm)
	{
		$where = "WHERE ". $class->SearchSyntax(field => "first_name", value => $searchTerm)
			. " OR ". $class->SearchSyntax(field => "last_name", value => $searchTerm)
			. " OR ". $class->SearchSyntax(field => "email", value => $searchTerm);
	}
	else
	{
		die "no valid param passed to album search";
	}

    my $sql = "SELECT * FROM " . kTable . " $where ORDER BY last_name, first_name, email";

    Common::Log::Debug( "SQL: $sql" );
    return $class->SUPER::GetAll($sql);
}

sub GetAllRoyaltyShare
{
	my $class = shift;

	my $sql = "SELECT user.* FROM " . kTable .
	             " INNER JOIN user_access USING (user_id) " .
				 " INNER JOIN access_level ON ( access_level_id = access_level ) " .
			  "WHERE access_level.name like 'RoyaltyShare%' " .
			  "GROUP BY user.user_id " .
			  "ORDER BY last_name ";

	return $class->SUPER::GetAll($sql);
}


1;