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;
}
