public static function getAllAdvisingLogEntries($advisorUserID = null, $studentUserID = null, $advisingLogEntryTypeID = null) { $db = get_instance()->db; $db->select('AdvisingLogEntryID'); $db->from('AdvisingLogEntries'); if ($advisorUserID != null) { $db->where('AdvisorUserID', $advisorUserID); } if ($studentUserID != null) { $db->where('StudentUserID', $studentUserID); } if ($advisingLogEntryTypeID != null) { $db->where('AdvisingLogEntryTypeID', $advisingLogEntryTypeID); } $db->order_by('Timestamp', 'desc'); $models = array(); $results = $db->get(); if ($results->num_rows() > 0) { foreach ($results->result_array() as $row) { $model = new Advising_log_entry_model(); if ($model->loadPropertiesFromPrimaryKey($row['AdvisingLogEntryID'])) { array_push($models, $model); } } } return $models; }