public function getReceptionCode($patientId, $organizationId, $respondentId = null)
    {
        $db     = $this->getAdapter();
        $select = $db->select();
        $select->from('gems__respondent2org', array('gr2o_reception_code'));

        if ($patientId) {
            $select->where('gr2o_patient_nr = ?', $patientId);
        } else {
            $select->where('gr2o_id_user = ?', $respondentId);
        }

        $select->where('gr2o_id_organization = ?', $organizationId);

        return $db->fetchOne($select);
    }
public function getReceptionCode($patientId, $organizationId, $respondentId = null)
    {
        $db     = $this->getAdapter();
        $select = $db->select();
        $select->from('gems__respondent2org', array('gr2o_reception_code'));

        if ($patientId) {
            $select->where('gr2o_patient_nr = ?', $patientId);
        } else {
            $select->where('gr2o_id_user = ?', $respondentId);
        }

        $select->where('gr2o_id_organization = ?', $organizationId);

        return $db->fetchOne($select);
    }
public function getReceptionCode ( $ patientId , $ organizationId , $ respondentId = null ) { $ db = $ this -> getAdapter ( ) ; $ select = $ db -> select ( ) ; $ select -> from ( 'gems__respondent2org' , array ( 'gr2o_reception_code' ) ) ; if ( $ patientId ) { $ select -> where ( 'gr2o_patient_nr = ?' , $ patientId ) ; } else { $ select -> where ( 'gr2o_id_user = ?' , $ respondentId ) ; } $ select -> where ( 'gr2o_id_organization = ?' , $ organizationId ) ; return $ db -> fetchOne ( $ select ) ; }
Get the current reception code for a respondent

@param string $patientId Can be empty if $respondentId is passed
@param int $organizationId
@param int $respondentId   Pass when at hand, is looked up otherwise
@return string The current reception code
Get the current reception code for a respondent