ShiftPlanRepository::findByComplexId

public function findByComplexId($shiftId, $userId, $dateAssigned)
{
	if (!$dateAssigned || !($dateAssigned instanceof Date))
	{
		return null;
	}
	return ShiftPlanTable::query()
		->addSelect('*')
		->where('SHIFT_ID', $shiftId)
		->where('USER_ID', $userId)
		->where('DATE_ASSIGNED', $dateAssigned)
		->exec()
		->fetchObject();
}