public function tutoreditAction()
{
if (isset($_POST['addpeople'])) {
# ADDING PERSON RECORD
$peopleadd = new Peopleadd();
$tutorid = $peopleadd->Peopleadd($_POST);
/*
# ADDING ADDRESS RECORD
$query = "INSERT INTO addresses SET
address1 = '" . addslashes($_POST[address1]) . "',
address2 = '" . addslashes($_POST[address2]) . "',
city = '" . addslashes($_POST[zip]) . "',
postalcode = '" . addslashes($_POST[address1]) . "',
id_addresstype = '" . addslashes(1) . "',
id_geog1 = '" . addslashes($_POST[province_id] ? $_POST[province_id] : 0) . "',
id_geog2 = '" . addslashes($_POST[district_id] ? $_POST[district_id] : 0) . "',
id_geog3 = '" . addslashes($_POST[region_c_id] ? $_POST[region_c_id] : 0) . "'";
die($query);
$db = $this->dbfunc()->query($query);
$id = $db->lastInsertId();
# ADDING ADDRESS RECORD
$query = "INSERT INTO link_tutor_addresses SET
id_address = '" . addslashes($id) . "',
id_tutor = '" . addslashes($tutorid) . "'";
die($query);
$db = $this->dbfunc()->query($query);
$id = $db->lastInsertId();
# LINKING TO TUTOR RECORD
$db = $this->dbfunc();
$linkrec = array(
'id_address' => $id,
'id_tutor' => $tutorid,
);
$rowArray = $db->insert("link_tutor_addresses",$linkrec);
$id = $db->lastInsertId();
*/
$this->_redirect(Settings::$COUNTRY_BASE_URL . "/tutoredit/tutoredit/id/" . $tutorid);
}
if (isset($_POST['update'])) {
$tutoredit = new Tutoredit();
$updateperson = $tutoredit->UpdatePerson($_POST);
$updateperson = $tutoredit->UpdateTutor($_POST);
# STORE LANGUAGES ON EDIT
# $updateperson=$tutoredit->UpdatePermanentAddress($_POST);
# $studentupdate = new Tutoredit();
# $update = $studentupdate->UpdatePerson($_POST); # STORING PERSON RECORD
# $update = $studentupdate->UpdateStudent($_POST); # STORING STUDENT RECORD
# $update = $studentupdate->UpdateStudentCohort($_POST); # STORING COHORT LINK
# $update = $studentupdate->UpdatePermanentAddress($_POST); # STORING PERMANENT ADDRESS
$tutorid = $_POST['id'];
$this->view->assign('newid', $tutorid);
}
$request = $this->getRequest();
$tutorid = $request->getParam('id');
$this->view->assign('id', $tutorid);
$this->viewAssignEscaped('locations', Location::getAll());
$Tutoredit = new Tutoredit();
$details = $Tutoredit->EditTutor($tutorid);
#print_r ($details);
$date = $details['person'][0]['birthdate'];
$dob = date("d-m-Y", strtotime($date));
$this->view->assign('id', $tutorid);
$this->view->assign('selid', $details['person'][0]['title_option_id']);
$this->view->assign('firstname', $details['person'][0]['first_name']);
$this->view->assign('middlename', $details['person'][0]['middle_name']);
$this->view->assign('lastname', $details['person'][0]['last_name']);
$this->view->assign('nationalid', $details['person'][0]['national_id']);
$this->view->assign('gender', $details['person'][0]['gender']);
$this->view->assign('dob', $dob);
$helper = new Helper();
$this->view->assign('lookupnationalities', $helper->getNationalities());
$this->view->assign('lookupfacilities', $helper->getNationalities());
$this->view->assign('lookupdegrees', $helper->getDegrees());
$this->view->assign('tutorlanguages', $helper->getLanguages());
$known = array();
$tl = $helper->getTutorLanguages($details['tutor'][0]['id']);
foreach ($tl as $_tl) {
$known[] = $_tl['id_language'];
}
$this->view->assign('knownlanguages', $known);
$this->view->assign('lookuptutortypes', $helper->getTutorTypes());
$tt = array();
$types = $helper->getLinkedTutorTypes($details['tutor'][0]['id']);
foreach ($types as $type) {
$tt[] = $type['id'];
}
$this->view->assign('tutortypes', $tt);
$this->view->assign('students', $helper->getTutorStudents($tutorid));
$this->view->assign('classes', $helper->getTutorClasses($tutorid));
# GET ALL STUDENTS WHERE ADVISOR = THIS ID
# GET ALL COURSES LINKED TO THIS ID
/*
$this->view->assign('localgeo1',$details['student'][0]['geog1']);
$this->view->assign('localgeo2',$details['student'][0]['geog2']);
$this->view->assign('localgeo3',$details['student'][0]['geog3']);
$this->view->assign('address1',$details['person'][0]['home_address_1']);
$this->view->assign('address2',$details['person'][0]['home_address_2']);
$this->view->assign('city',$details['person'][0]['city']);
$this->view->assign('zip',$details['person'][0]['home_postal_code']);
$this->view->assign('enroll',$details['person'][0]['home_address_2']);
$this->view->assign('city',$details['person'][0]['city']);
$this->view->assign('email',$details['person'][0]['email']);
$this->view->assign('email2',$details['person'][0]['email_secondary']);
$this->view->assign('titid',$details['person'][0]['title_option_id']);
$this->view->assign('phone',$details['person'][0]['phone_work']);
$this->view->assign('cell',$details['person'][0]['phone_mobile']);
$this->view->assign('cadre',$details['person'][0]['cadre']);
$this->view->assign('graduated',$details['student'][0]['isgraduated']);
$this->view->assign('cohortid',$details['link_cohort'][0]['id_cohort']);
*/
# FACILITY INFORMATION GEO
$this->view->assign('localgeo1', $details['tutor'][0]['geog1']);
$this->view->assign('localgeo2', $details['tutor'][0]['geog2']);
$this->view->assign('localgeo3', $details['tutor'][0]['geog3']);
$this->view->assign('facility', $details['tutor'][0]['facility']);
$this->view->assign('cadre', $details['tutor'][0]['cadre']);
$this->view->assign('tutorsince', $details['tutor'][0]['tutorsince']);
$this->view->assign('tutortimehere', $details['tutor'][0]['tutortimehere']);
$this->view->assign('cadre', $details['tutor'][0]['cadre']);
$this->view->assign('degree', $details['tutor'][0]['degree']);
$this->view->assign('degreeinst', $details['tutor'][0]['degreeinst']);
$this->view->assign('degreeyear', $details['tutor'][0]['degreeyear']);
$this->view->assign('languagesspoken', $details['tutor'][0]['languagesspoken']);
$this->view->assign('positionsheld', $details['tutor'][0]['positionsheld']);
$this->view->assign('comments', $details['tutor'][0]['comments']);
$this->view->assign('nationality', $details['tutor'][0]['nationalityid']);
# PERMANENT ADDRESS
$this->view->assign('permanentgeo1', $details['permanent_address'][0]['id_geog1']);
$this->view->assign('permanentgeo2', $details['permanent_address'][0]['id_geog2']);
$this->view->assign('permanentgeo3', $details['permanent_address'][0]['id_geog3']);
$this->view->assign('permanentaddress1', $details['permanent_address'][0]['address1']);
$this->view->assign('permanentaddress2', $details['permanent_address'][0]['address2']);
$this->view->assign('permanentcity', $details['permanent_address'][0]['city']);
$this->view->assign('permanentzip', $details['permanent_address'][0]['postalcode']);
/*
# STUDENT VIEW
$this->view->assign('studentid',$details['student'][0]['studentid']);
$this->view->assign('studenttype',$details['student'][0]['studenttype']);
if ($details['student'][0]['enrollmentdate'] == "0000-00-00"){
$enrolldate = "";
} else {
$enrolldate = date("d-m-Y", strtotime($details['student'][0]['enrollmentdate']));
}
$this->view->assign('enrollmentdate',$enrolldate);
$this->view->assign('enrollmentreason',$details['student'][0]['enrollmentreason']);
if ($details['student'][0]['separationdate'] == "0000-00-00"){
$separationdate = "";
} else {
$separationdate = date("d-m-Y", strtotime($details['student'][0]['separationdate']));
}
$this->view->assign('separationdate',$separationdate);
$this->view->assign('separationreason',$details['student'][0]['separationreason']);
$this->view->assign('cadre',$details['student'][0]['cadre']);
$this->view->assign('advisor',$details['student'][0]['advisorid']);
$this->view->assign('yearofstudy',($details['student'][0]['yearofstudy'] != 0 ? $details['student'][0]['yearofstudy'] : ""));
*/
// For Title List
$listtitle = $Tutoredit->ListTitle();
$this->view->assign('gettitle', $listtitle);
#
# # GETTING COHORTS
# $listcohort = $Tutoredit->ListCohort();
# $this->view->assign('getcohorts',$listcohort);
#
# # GETTING CADRES
# $listcadre = $Tutoredit->listCadre();
# $this->view->assign('getcadres',$listcadre);
#
# # GETTING TUTORS
# $listtutors = $Tutoredit->ListTutors();
# $this->view->assign('gettutors',$listtutors);
}
public function peopleaddAction()
{
//locations
if (count($_POST) > 0) {
if (isset($_POST['addpeople'])) {
$peopleadd = new PeopleAdd();
# TRIGGERS ADDING PERSON
$tutorid = $peopleadd->addTutor($_POST);
switch ($_POST['type']) {
case "tutor":
$this->_redirect(Settings::$COUNTRY_BASE_URL . "/tutoredit/tutoredit/id/" . $tutorid);
break;
}
}
exit;
}
$this->viewAssignEscaped('locations', Location::getAll());
$this->view->assign('action', '../studentedit/studentedit/');
$this->view->assign('title', $this->view->translation['Application Name']);
$persontitle = new Peopleadd();
$result = $persontitle->Peopletitle($fetchtitle);
$this->view->assign('fetchtitle', $result);
// FOr Facility
$faclilityttitle = new Peopleadd();
$result = $faclilityttitle->PeopleFacility($fetchfacility);
$this->view->assign('fetchfacility', $result);
$citylist = new Peopleadd();
$result = $citylist->PeopleCity($citylist);
$this->view->assign('fetchcity', $result);
# CREATING HELPER
$helper = new Helper();
$this->view->assign('institutions', $helper->getInstitutions(false));
}
public function studenteditAction()
{
$this->view->assign('title', $this->view->translation['Application Name']);
if (isset($_POST['addpeople'])) {
$peopleadd = new Peopleadd();
$pupiladd = $peopleadd->Peopleadd($_POST);
echo "<script language=\"JavaScript\">location.replace('../personview/id/" . $pupiladd . "');</script>";
exit;
//print_r($pupiladd);
$this->viewAssignEscaped('locations', Location::getAll());
$studentedit = new Studentedit();
$details = $studentedit->EditStudent($pupiladd);
// For Geo Listing
$listgeo = $studentedit->ViewStudent($pupiladd);
$this->view->assign('getgeo', $listgeo);
//print_r($listgeo);
$geo1 = $listgeo[0]['geog1'];
$geo2 = $listgeo[0]['geog2'];
$geo3 = $listgeo[0]['geog3'];
$this->view->assign('selgeo1', $geo1);
$this->view->assign('selgeo2', $geo2);
$this->view->assign('selgeo3', $geo3);
$this->view->assign('enrolldate', $listgeo[0]['enrollmentdate']);
$this->view->assign('enrollreason', $listgeo[0]['enrollmentreason']);
$this->view->assign('seprationreason', $listgeo[0]['separationdate']);
$this->view->assign('sepration', $listgeo[0]['separationreason']);
$this->view->assign('study', $listgeo[0]['yearofstudy']);
//For Title List
$listtitle = $studentedit->ListTitle();
$this->view->assign('gettitle', $listtitle);
//For city List
$listcity = $studentedit->ListCity();
$this->view->assign('getcity', $listcity);
//For Selected Title
$titleid = $details[0]['title_option_id'];
$fetchtitle = $studentedit->EditTitle($titleid);
$title = $fetchtitle[0]['title_phrase'];
$this->view->assign('selid', $fetchtitle[0]['id']);
$this->view->assign('seltitle', $title);
//For Selected City
$cityid = $details[0]['home_location_id'];
$fetchcity = $studentedit->EditCity($cityid);
$city = $fetchcity[0]['city_name'];
$this->view->assign('selcity', $city);
$date = $details[0]['birthdate'];
$dob = date("d-m-Y", strtotime($date));
$this->view->assign('id', $pupiladd);
$this->view->assign('firstname', $details[0]['first_name']);
$this->view->assign('lastname', $details[0]['last_name']);
$this->view->assign('gender', $details[0]['gender']);
$this->view->assign('dob', $dob);
$this->view->assign('address1', $details[0]['home_address_1']);
$this->view->assign('address2', $details[0]['home_address_2']);
$this->view->assign('city', $details[0]['city']);
$this->view->assign('zip', $details[0]['home_postal_code']);
//$this->view->assign('action','../../studentedit/studentupdate/'.$pupiladd);
}
if (isset($_POST['update'])) {
$studentupdate = new Studentedit();
$update = $studentupdate->UpdatePerson($_POST);
$pupiladd = $_POST['id'];
$this->viewAssignEscaped('locations', Location::getAll());
$studentedit = new Studentedit();
$details = $studentedit->EditStudent($pupiladd);
// For Geo Listing
$listgeo = $studentedit->ViewStudent($pupiladd);
$this->view->assign('getgeo', $listgeo);
# $sid = $studentedit->addfunding($_POST);
$studid = $listgeo[0]['id'];
$this->view->assign('stdid', $studid);
$date = $update['birthdate'];
$dob = date("d-m-Y", strtotime($date));
$this->view->assign('newid', $pupiladd);
$this->view->assign('firstname', $update['first_name']);
$this->view->assign('lastname', $update['last_name']);
$this->view->assign('gender', $update['gender']);
$this->view->assign('dob', $dob);
$this->view->assign('address1', $update['home_address_1']);
$this->view->assign('address2', $update['home_address_2']);
$this->view->assign('city', $update['city']);
$this->view->assign('zip', $update['home_postal_code']);
$this->view->assign('enroll', $update['home_address_2']);
$this->view->assign('city', $update['city']);
$this->view->assign('email', $update['email']);
$this->view->assign('email2', $update['email_secondary']);
$this->view->assign('titid', $update['title_option_id']);
$this->view->assign('phone', $update['phone_work']);
$this->view->assign('cell', $update['phone_mobile']);
$this->view->assign('cadre', $update['cadre']);
$geo1 = $listgeo[0]['geog1'];
$geo2 = $listgeo[0]['geog2'];
$geo3 = $listgeo[0]['geog3'];
$this->view->assign('selgeo1', $geo1);
$this->view->assign('selgeo2', $geo2);
$this->view->assign('selgeo3', $geo3);
$this->view->assign('enrolldate', $listgeo[0]['enrollmentdate']);
$this->view->assign('enrollreason', $listgeo[0]['enrollmentreason']);
$this->view->assign('seprationreason', $listgeo[0]['separationdate']);
$this->view->assign('sepration', $listgeo[0]['separationreason']);
$this->view->assign('study', $listgeo[0]['yearofstudy']);
//For Title List
$listtitle = $studentedit->ListTitle();
$this->view->assign('gettitle', $listtitle);
//For city List
$listcity = $studentedit->ListCity();
$this->view->assign('getcity', $listcity);
//For Selected Title
/*$titleid = $details[0]['title_option_id'];
$fetchtitle=$studentedit->EditTitle($titleid);*/
$title = $fetchtitle[0]['title_phrase'];
$this->view->assign('selid', $fetchtitle[0]['id']);
$this->view->assign('seltitle', $title);
//For Selected City
$cityid = $details[0]['home_location_id'];
$fetchcity = $studentedit->EditCity($cityid);
$city = $fetchcity[0]['city_name'];
$this->view->assign('selcity', $city);
$cadre = $listgeo[0]['cadre'];
# if($cadre=="0"){
# $cadreid = $studentupdate->AddCadre($_POST);
# }else{
#
# $cid = $_POST['cadreid'];
# //$updatecare=$studentupdate->ViewCadre($cid);
# //$this->view->assign('cadrename',$updatecare[0]['cadrename']);
# }
# $this->view->assign('cadreid',$cadreid);
$updatestud = $studentupdate->UpdateStudent($_POST);
$enroll = $updatestud['enrollmentdate'];
$enrolldate = date("d-m-Y", strtotime($enroll));
$seprate = $updatestud['separationdate'];
$seprationdate = date("d-m-Y", strtotime($seprate));
$this->view->assign('grade', $updatestud['isgraduated']);
$this->view->assign('enrollmentdate', $enrolldate);
$this->view->assign('enrollmentreason', $updatestud['enrollmentreason']);
$this->view->assign('separation', $seprationdate);
$this->view->assign('separationreason', $updatestud['separationreason']);
$this->view->assign('study', $updatestud['yearofstudy']);
$this->view->assign('comments', $updatestud['comments']);
$this->view->assign('cadre', $updatestud['cadre']);
//print_r($updatestud);
$updatecadre = $studentupdate->UpdateCadre($_POST);
$this->view->assign('id', $pupiladd);
$this->view->assign('cadrename', $updatecadre['cadrename']);
$this->view->assign('success', 'Update succesfully');
}
}
