<?
function get_assignmentlogins($propertyid)
{
	$sql = "
	select *
		, case 
			when propertyassignmentexpireddate is not null then propertyassignmentexpireddate
			when propertyassignmentexpiredmarkeddate < now() then propertyassignmentexpiredmarkeddate
			else null
		end propertyassignmenthasexpireddate
	from tblpropertyassignment
		join tbllogin using (accountstaffid, staffid)
	where propertyid = ".db_number($propertyid)."
		and (accountstaffid > 0 or staffid > 0)";
	$qry = db_query($sql);
	d_dev('get_assignmentlogins', array('sql' => $sql, 'qry' => $qry));
	return $qry;
}

function get_propertyassignments($propertyid, $taskid)
{
	$sql = "
		select *
		from (
			select *
				, case
					when propertyassignmentexpireddate is not null then propertyassignmentexpireddate
					when propertyassignmentexpiredmarkeddate < now() then propertyassignmentexpiredmarkeddate
					else null
				end propertyassignmenthasexpireddate
			from tblpropertyassignment
		) tblpropertyassignment
			left join
			(
					select staffid, 0 accountstaffid, stafffname||' '||stafflname agentname
					from tblstaff
				union
					select 0 staffid, accountstaffid, accountstafffname||' '||accountstafflname agentname
					from tblaccountstaff
	
			) tblagent using (staffid, accountstaffid)
			left join
			(
				select taskassignid, propertyassignmentid
				from tbltaskassign
				where taskid = ".db_number($taskid)."
			) tbltaskassign using (propertyassignmentid)
		where propertyid = ".db_number($propertyid)."
			and propertyassignmentrevokeddate is null
			and propertyassignmentcompleteddate is null
			and propertyassignmenthasexpireddate is null
		order by taskassignid desc";
	$qry = db_query($sql);
	d_dev('get_propertyassignments', array('sql' => $sql, 'qry' => $qry));
	return $qry;
}