public static function get($id) { global $db; $query = "SELECT * FROM `student_formal_remediations` where `id`=" . $db->qstr($id); $result = $db->GetRow($query); if ($result) { $fr = FormalRemediation::fromArray($result); return $fr; } }
public static function get(User $user) { global $db; $frs = array(); $user_id = $user->getID(); $query = "SELECT * FROM `student_formal_remediations` WHERE `user_id` = " . $db->qstr($user_id); $results = $db->getAll($query); if ($results) { foreach ($results as $result) { $fr = FormalRemediation::fromArray($result); $frs[] = $fr; } } return new self($frs); }
function process_mspr_details($translator, $section) { $action = clean_input(isset($_POST['action']) ? $_POST['action'] : "", array("lower")); if (!$action) { return; } switch ($action) { case 'add': $user_id = clean_input(isset($_POST['user_id']) ? $_POST['user_id'] : 0, array("int")); $details = clean_input(isset($_POST['details']) ? $_POST['details'] : "", array("notags")); if (!$user_id) { add_error($translator->translate("mspr_invalid_user_info")); } if (!$details) { add_error($translator->translate("mspr_no_details")); } if (!has_error()) { switch ($section) { case 'leaves_of_absence': LeaveOfAbsence::create($user_id, $details); break; case 'disciplinary_actions': DisciplinaryAction::create($user_id, $details); break; case 'formal_remediation': FormalRemediation::create($user_id, $details); break; } } break; case 'remove': $entity_id = clean_input(isset($_POST['entity_id']) ? $_POST['entity_id'] : 0, array("int")); if (!$entity_id) { add_error($translator->translate("mspr_no_entity")); } if (!has_error()) { switch ($section) { case 'leaves_of_absence': $entity = LeaveOfAbsence::get($entity_id); break; case 'disciplinary_actions': $entity = DisciplinaryAction::get($entity_id); break; case 'formal_remediation': $entity = FormalRemediation::get($entity_id); break; } if (!$entity) { add_error($translator->translate("mspr_invalid_entity")); } if (!has_error()) { $entity->delete(); } } break; } }