public static function getClaimFile($claimId) { $db = Zend_Registry::get('dbAdapter'); $claimFile = new self(); $sqlSelect = $db->select()->from($claimFile->_table)->where('claimIds LIKE ?', '%' . $claimId . '%'); $claimFile->populateWithSql($sqlSelect->__toString()); return $claimFile; }
public static function retrieveSignatureId($objectClass, $objectId, $signed = true) { $db = Zend_Registry::get('dbAdapter'); $esig = new self(); $sqlSelect = $db->select()->from($esig->_table)->where('objectClass = ?', $objectClass)->where('objectId = ?', $objectId)->limit(1); if ($signed) { $sqlSelect->where("signature != ''"); } $esig->populateWithSql($sqlSelect->__toString()); return $esig->eSignatureId; }
public static function filterByPayerPersonIds($insuranceProgramId, $personId) { $db = Zend_Registry::get('dbAdapter'); $orm = new self(); $sqlSelect = $db->select()->from($orm->_table)->where('insurance_program_id = ?', (int) $insuranceProgramId)->where('person_id = ?', (int) $personId)->where('active = 1')->order('program_order')->limit(1); $orm->populateWithSql($sqlSelect->__toString()); return $orm; }