$discovery->referrals = $_POST['e_referrals'];
$discovery->others = $_POST['e_others'];
$discovery->update();
//----------------------------------------------------------------------------------------------------------------------------------//
$enrollmentDetail = EnrollmentDetail::get_by_id($student->enrollment_detail_id);
$enrollmentDetail->status = $_POST['f_status'];
$enrollmentDetail->program = $_POST['f_program'];
$enrollmentDetail->schedule = $_POST['f_schedule'];
$enrollmentDetail->payment = $_POST['f_payment'];
$enrollmentDetail->studentcontactnumber = $_POST['f_studentcontactnumber'];
$enrollmentDetail->update();
//----------------------------------------------------------------------------------------------------------------------------------//
$appointmentDetail = AppointmentDetail::get_by_id($student->appointment_detail_id);
$appointmentDetail->visitschedule = strtotime($_POST['g_visitschedule']);
$appointmentDetail->visitpurpose = $_POST['g_visitpurpose'];
$appointmentDetail->officer = $_POST['g_officer'];
$appointmentDetail->update();
//----------------------------------------------------------------------------------------------------------------------------------//
} else {
if ($_POST['oper'] == 'del') {
$student = Student::get_by_id($_POST['id']);
$student->delete();
AppointmentDetail::get_by_id($student->appointment_detail_id)->delete();
EnrollmentDetail::get_by_id($student->enrollment_detail_id)->delete();
StiDiscovery::get_by_id($student->sti_discovery_id)->delete();
SchoolConsidered::get_by_id($student->school_considered_id)->delete();
SchoolLastAttended::get_by_id($student->school_last_attended_id)->delete();
PersonalInformation::get_by_id($student->personal_information_id)->delete();
}
}
}
/**
* Create an associative array of object properties from XML
* @static
* @param SimpleXMLElement $parsedResponse - XML of registrant
* @return
*/
public static function createStruct($parsedResponse)
{
$reg['title'] = (string) $parsedResponse->title;
$reg['updated'] = (string) $parsedResponse->updated;
$reg['link'] = (string) $parsedResponse->link->Attributes()->href;
$reg['id'] = (string) $parsedResponse->id;
$content = $parsedResponse->content->children();
$reg['lastName'] = (string) $content->Registrant->LastName;
$reg['firstName'] = (string) $content->Registrant->FirstName;
$reg['email'] = (string) $content->Registrant->EmailAddress;
$reg['registrationStatus'] = (string) $content->Registrant->RegistrationStatus;
$reg['registrationDate'] = (string) $content->Registrant->RegistrationDate;
$reg['guestCount'] = (string) $content->Registrant->GuestCount;
$reg['paymentStatus'] = (string) $content->Registrant->PaymentStatus;
$reg['personalInformation'] = new PersonalInformation(PersonalInformation::createStruct($content->Registrant->PersonalInformation));
$reg['businessInformation'] = new BusinessInformation(BusinessInformation::createStruct($content->Registrant->BusinessInformation));
$reg['customInformation1'] = array();
$reg['customInformation2'] = array();
$reg['costs'] = array();
if (isset($content->Registrant->CustomInformation1->CustomField)) {
foreach ($content->Registrant->CustomInformation1->CustomField as $customInfo) {
$reg['customInformation1'][] = CustomField::createFromXml($customInfo);
}
}
if (isset($content->Registrant->CustomInformation2->CustomField)) {
foreach ($content->Registrant->CustomInformation2->CustomField as $customInfo) {
$reg['customInformation2'][] = CustomField::createFromXml($customInfo);
}
}
if (isset($content->Registrant->Costs->Cost)) {
foreach ($content->Registrant->Costs->Cost as $cost) {
$reg['costs'] = new Cost(Cost::createStruct($cost));
}
}
return $reg;
}
//$students = Student::get_by_sql("SELECT * FROM ".T_STUDENTS." INNER JOIN ".T_PERSONAL_INFORMATIONS." ON ".T_PERSONAL_INFORMATIONS.".student_id=".T_STUDENTS.".id ORDER BY ".T_STUDENTS.".id $sord LIMIT $start , $limit");
$students = Student::get_by_sql("SELECT * FROM " . T_STUDENTS . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}");
}
header("Content-type: text/xml;charset=utf-8");
$s = "<?xml version='1.0' encoding='utf-8'?>";
$s .= "<rows>";
$s .= "<page>" . $page . "</page>";
$s .= "<total>" . $total_pages . "</total>";
$s .= "<records>" . $count . "</records>";
foreach ($students as $student) {
$s .= "<row id='" . $student->id . "'>";
$s .= "<cell></cell>";
$s .= "<cell>" . $student->id . "</cell>";
$s .= "<cell>" . $student->studentid . "</cell>";
//----------------------------------------------------------------------------------------------------------------------------------//
$personInfo = PersonalInformation::get_by_id($student->personal_information_id);
if (!$personInfo) {
$personInfo = new PersonalInformation();
}
$s .= "<cell>" . $personInfo->firstname . "</cell>";
$s .= "<cell>" . $personInfo->lastname . "</cell>";
$s .= "<cell>" . $personInfo->middlename . "</cell>";
$s .= "<cell>" . $personInfo->address . "</cell>";
$s .= "<cell>" . $personInfo->father . "</cell>";
$s .= "<cell>" . $personInfo->mother . "</cell>";
$s .= "<cell>" . $personInfo->guardian . "</cell>";
$s .= "<cell>" . $personInfo->gender . "</cell>";
$s .= "<cell>" . $personInfo->civilstatus . "</cell>";
$s .= "<cell>" . $personInfo->citizenship . "</cell>";
$s .= "<cell>" . $personInfo->birthday . "</cell>";
$s .= "<cell>" . $personInfo->email . "</cell>";
