public function __construct($dbSelect = null)
{
$this->_ormClass = 'ClaimRule';
if ($dbSelect !== null) {
parent::__construct($this->_ormClass, $dbSelect);
}
}
public function __construct($dbSelect = null, $autoload = true)
{
$this->_ormClass = 'Appointment';
if ($autoload) {
parent::__construct($this->_ormClass, $dbSelect);
}
}
public function __construct($dbSelect = null)
{
if ($dbSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from('number');
}
parent::__construct("PhoneNumber", $dbSelect);
}
public function __construct($dbSelect = null)
{
if ($dbSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from('clinicalNoteDefinitions')->joinUsing('clinicalNoteTemplates', 'clinicalNoteTemplateId')->order('clinicalNoteDefinitions.title ASC');
}
parent::__construct("ClinicalNoteDefinition", $dbSelect);
}
public function __construct($dbSelect = null)
{
if ($dbSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from('address');
}
parent::__construct("Address", $dbSelect);
}
public function __construct($dbSelect = null)
{
if ($dbSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from('lab_result', "description as description2")->joinLeft('lab_test', 'lab_test.lab_test_id=lab_result.lab_test_id')->joinLeft('lab_order', 'lab_order.lab_order_id=lab_test.lab_order_id')->order('lab_result.observation_time DESC')->where('0');
}
parent::__construct("LabResult", $dbSelect);
}
public function __construct($dbSelect = null)
{
if ($dbSelect === null) {
$db = Zend_Registry::get("dbAdapter");
$dbSelect = $db->select()->from("barcodeMacros")->order("order ASC");
}
parent::__construct("BarcodeMacro", $dbSelect);
}
public function __construct($dbSelect = null)
{
if ($dbSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from('nsdrDefinitions')->joinLeft('nsdrDefinitionMethods', 'nsdrDefinitionMethods.uuid = nsdrDefinitions.uuid', array('methodName', 'method'));
}
parent::__construct("NSDRDefinition", $dbSelect);
}
public function __construct($dbSelect = null, $autoLoad = true)
{
$this->_ormClass = 'Order';
// autoLoad gives an option to query the entire rows which takes time if more data in the table
if ($autoLoad) {
parent::__construct($this->_ormClass, $dbSelect);
}
}
public function __construct($dbSelect = null)
{
if ($dbSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from('clinicalNoteTemplates');
$dbSelect->order("name ASC");
}
parent::__construct("ClinicalNoteTemplate", $dbSelect);
}
public function __construct($dbSelect = null, $autoLoad = false)
{
$this->_ormClass = 'Payment';
if ($dbSelect !== null) {
$this->_dbSelect = $dbSelect;
}
// autoLoad gives an option to query the entire rows which takes time if more data in the table
if ($autoLoad) {
parent::__construct($this->_ormClass, $dbSelect);
}
}
public function __construct($dbSelect = null, $autoLoad = true)
{
$this->_ormClass = 'ProcedureCodesLOINC';
if ($dbSelect === null) {
$dbSelect = $this->getDefaultSQLSelect()->order('shortname');
}
// autoLoad gives an option to query the entire rows which takes time if more data in the table
if ($autoLoad) {
parent::__construct($this->_ormClass, $dbSelect);
}
}
public function __construct($dbSelect = null, $autoLoad = true)
{
$this->_ormClass = 'Messaging';
if ($dbSelect === null) {
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from('messaging')->order('dateStatus DESC')->order('objectType ASC')->order('objectClass ASC');
}
// autoLoad gives an option to query the entire rows which takes time if more data in the table
if ($autoLoad) {
parent::__construct($this->_ormClass, $dbSelect);
}
}
public function __construct($dbSelect = null)
{
parent::__construct('VitalSignGroup', $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct("ClinicalNote", $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct("FilterState", $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct('PatientExam', $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct("ESignature", $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct('PatientProcedure', $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct('PatientVisitType', $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct("PatientImmunization", $dbSelect);
}
public function __construct($dbSelect = null)
{
$db = Zend_Registry::get('dbAdapter');
$dbSelect = $db->select()->from(array('zipcodeGeo1' => 'zipcodeGeo'), null)->join(array('zipcodeGeo2' => 'zipcodeGeo'), null, null)->join('pharmacies', 'pharmacies.Zip = zipcodeGeo2.zip', array('pharmacies.pharmacyId', 'pharmacies.StoreName', 'pharmacies.AddressLine1', 'pharmacies.City', 'pharmacies.ServiceLevel'))->joinLeft('patient', 'patient.defaultPharmacyId = pharmacies.pharmacyId')->where('pharmacies.ActiveStartTime <= NOW()')->where('DATE_ADD(pharmacies.ActiveEndTime, INTERVAL 30 DAY) >= NOW()')->group('pharmacies.pharmacyId');
parent::__construct("Pharmacy", $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct('Medication', $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct('ExternalTeamMember', $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct('DiagnosisCodesAllergy', $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct("Provider", $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct('PatientDiagnosis', $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct("ProblemList", $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct("DiagnosisCodesICD", $dbSelect);
}
public function __construct($dbSelect = null)
{
parent::__construct("Visit", $dbSelect);
}