function get_single_educ($employee_id, $level)
{
$data = array();
$e = new Education();
$e->where('employee_id', $employee_id);
$e->where('level', $level);
$e->get();
return $e;
/*
$this->db->where('employee_id', $employee_id);
$this->db->where('level', $level);
$this->db->order_by('level');
$q = $this->db->get('education_background');
if ($q->num_rows() > 0)
{
foreach ($q->result_array() as $row)
{
$data = $row;
}
}
return $data;
$q->free_result();
*/
}
public function saveEducation(Education $education)
{
try {
$education->save();
} catch (Exception $e) {
throw new DaoException($e->getMessage(), $e->getCode(), $e);
}
}
function process_bulk_action()
{
if ('delete' === $this->current_action()) {
require_once 'education.class.php';
$education = new Education();
$ids = isset($_REQUEST['ID']) ? $_REQUEST['ID'] : array();
$education->deleteUsers($ids);
}
}
public function testAddEducation()
{
$education = new Education();
$education->setName('PMP');
$this->educationDao->saveEducation($education);
$savedEducation = TestDataService::fetchLastInsertedRecord('Education', 'id');
$this->assertTrue($savedEducation instanceof Education);
$this->assertEquals('PMP', $savedEducation->getName());
}
public function education()
{
$userid = self::get_user();
$education = new Education($userid);
$educdata = $education->currenteducation();
$currenteduc = $education->currenteducdata();
$this->curreducation = $currenteduc->fetch_object();
while ($rowedu = $educdata->fetch_object()) {
$this->educationdata[] = $rowedu;
}
}
public function actionEditmoreinfo($user_id)
{
$user_more_info = UserInfoAR::model()->findByPk($user_id);
$this->assign('user_more', $user_more_info);
$maritalStatus = MaritalStatus::model()->findAll();
// 'MaritalStatus', 'marital_status_id'),
$hometown = Hometown::model()->findAll();
// 'Province', 'hometown_id'),
$nation = Nation::model()->findAll();
// 'Nation', 'nation_id'),
$bodyType = BodyType::model()->findAll();
// 'BodyType', 'body_type_id'),
$education = Education::model()->findAll();
// 'Education', 'education_id'),
$school = School::model()->findAll();
// 'School', 'school_id'),
$province = Province::model()->findAll();
// 'Province', 'province_id'),
$job = Job::model()->findAll();
// '$maritalSta,
$this->assign('maritalStatus', $maritalStatus);
$this->assign('hometown', $hometown);
$this->assign('nation', $nation);
$this->assign('bodyType', $bodyType);
$this->assign('education', $education);
$this->assign('school', $school);
$this->assign('province', $province);
$this->assign('job', $job);
}
public static function getModels($res)
{
$result = array();
foreach ($res as $element) {
$model = Education::getModel($element);
array_push($result, $model);
}
return $result;
}
public function get($educationId)
{
// we make sure $id is an integer
$id = intval($educationId);
$req = $this->db->prepare('SELECT * FROM educations WHERE id = :id');
$req->execute(array('id' => $id));
$res = $req->fetch();
var_dump($res);
$user = Education::getModel($res);
return $user;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
// $this->call(UserTableSeeder::class);
DB::table('education')->delete();
Education::create(['edu_id' => '0', 'edu_level' => 'None'], ['edu_id' => '1', 'edu_level' => 'Preschool'], ['edu_id' => '2', 'edu_level' => 'Elementary'], ['edu_id' => '3', 'edu_level' => 'High school'], ['edu_id' => '4', 'edu_level' => 'College']);
DB::table('completed')->delete();
Completed::create(['id_completed' => '0', 'author' => 'Patient'], ['id_completed' => '1', 'author' => 'Caregiver'], ['id_completed' => '2', 'author' => 'Caregiver-assisted']);
DB::table('admin')->delete();
Admin::create(['id_admin' => '0', 'email' => '*****@*****.**', 'password' => 'pass']);
Model::reguard();
}
/**
* Key-value pairs of all categories
* @return array [category_id => category_name]
*/
public static function all()
{
static $result;
if (!is_null($result)) {
return $result;
}
$command = Yii::app()->db;
/* @var CDbConnection $command */
$rows = $command->createCommand()->select('id, name')->from(Education::model()->tableName())->queryAll();
$result = [];
foreach ($rows as $row) {
$result[$row['id']] = $row['name'];
}
return $result;
}
public function getCandidateByUserId($userId)
{
$id = intval($userId);
$req = $this->db->prepare('SELECT * FROM candidates WHERE userId = :id');
$req->execute(array('id' => $id));
$res = $req->fetch();
$candidate = Candidate::getModel($res);
$req = $this->db->prepare('SELECT * FROM educations WHERE cvId = :id');
$req->execute(array('id' => $candidate->cv->id));
$res = $req->fetchAll();
$candidate->cv->educations = Education::getModels($res);
$req = $this->db->prepare('SELECT * FROM professionalexperiences WHERE cvId = :id');
$req->execute(array('id' => $candidate->cv->id));
$res = $req->fetchAll();
$candidate->cv->professional_experiences = ProfessionalExperience::getModels($res);
return $candidate;
}
public function normalizeIssue()
{
$issues = Issue::all();
foreach ($issues as $issue) {
// Normalize Educations
$educations = Education::where('student_id', '=', $issue->student_id)->get();
foreach ($educations as $education) {
$education->student_id = $issue->id;
$education->save();
}
// Normalize Placements
$placements = Placement::where('student_id', '=', $issue->student_id)->get();
foreach ($placements as $placement) {
$placement->student_id = $issue->id;
$placement->save();
}
// Normalize Receivables
$receivables = Receivable::where('student_id', '=', $issue->student_id)->get();
foreach ($receivables as $receivable) {
$receivable->student_id = $issue->id;
$receivable->save();
}
}
}
$state_var_name = $state ? $state->var_name : $jobs->state_province;
$smarty->assign('state', $state_name);
$smarty->assign('state_url', $country_var_name . "/" . $state_var_name . "/");
//county
$county = County::find_by_code($jobs->country, $jobs->state_province, $jobs->county);
$county_name = empty($county) ? $jobs->county : $county->name;
$county_var_name = $county ? $county->var_name : $jobs->county;
$smarty->assign('county', $county_name);
$smarty->assign('county_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/");
$city = City::find_by_code($jobs->country, $jobs->state_province, $jobs->county, $jobs->city);
$city_name = empty($city) ? $jobs->city : $city->name;
$city_var_name = empty($city) ? $jobs->city : $city->var_name;
$smarty->assign('city', $city_name);
$smarty->assign('city_url', $country_var_name . "/" . $state_var_name . "/" . $county_var_name . "/" . $city_var_name . "/");
//educations
$educations = Education::find_by_id($jobs->fk_education_id);
$education_name = !empty($educations) ? $educations->education_name : format_lang('not_provided');
$smarty->assign('education_var_name', $educations->var_name);
$smarty->assign('education', $education_name);
//career
$careers = CareerDegree::find_by_id($jobs->fk_career_id);
$smarty->assign('careers', $careers);
$career_name = $careers ? $careers->career_name : format_lang('not_provided');
$smarty->assign('career_var_name', $careers->var_name);
$smarty->assign('career', $career_name);
//experience
$experiences = Experience::find_by_id($jobs->fk_experience_id);
$smarty->assign('experiences', $experiences);
$experience_name = !empty($experiences) ? $experiences->experience_name : format_lang('not_provided');
$smarty->assign('experience_var_name', $experiences->var_name);
$smarty->assign('experience', $experience_name);
public function cascade_delete()
{
$id = $this->id;
// delete basic info mappings
$basic_info = BasicInfo::model()->findByAttributes(array('userid' => $id));
if (isset($basic_info)) {
$basic_info->delete();
}
// delete company info mapping
$comp_info = CompanyInfo::model()->findByAttributes(array('FK_userid' => $id));
if (isset($comp_info)) {
$comp_info->delete();
}
// delete sms mappings
$sms_mappings = SMS::model()->findAll("sender_id=:id OR receiver_id=:id ", array(':id' => $id));
foreach ($sms_mappings as $sms_mapping) {
$sms_mapping->delete();
}
// delete education mapping
$edu_mappings = Education::model()->findAllByAttributes(array('FK_user_id' => $id));
foreach ($edu_mappings as $edu_mapping) {
$edu_mapping->delete();
}
// delete skills mappings
$skills_mappings = StudentSkillMap::model()->findAllByAttributes(array('userid' => $id));
foreach ($skills_mappings as $skills_mapping) {
$skills_mapping->delete();
}
// delete application mappings
$app_mappings = Application::model()->findAllByAttributes(array('userid' => $id));
foreach ($app_mappings as $app_mapping) {
$app_mapping->delete();
}
// delete jobs mappings
$job_mappings = Job::model()->findAllByAttributes(array('FK_poster' => $id));
foreach ($job_mappings as $job_mapping) {
$job_mapping->cascade_delete();
}
$this->delete();
}
public function actionUpload()
{
parent::actionUpload();
$folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/';
// folder for uploaded files
$file = $folder . basename($_FILES['uploadfile']['name']);
if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $file)) {
$row = 0;
if (($handle = fopen($file, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if ($row > 0) {
$model = Educationmajor::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Educationmajor();
}
$model->educationmajorid = (int) $data[0];
$education = Education::model()->findbyattributes(array('educationname' => $data[1]));
if ($education != null) {
$model->educationid = $education->educationid;
}
$model->educationmajorname = $data[2];
$model->recordstatus = (int) $data[3];
try {
if (!$model->save()) {
$this->messages = $this->messages . Catalogsys::model()->getcatalog(' upload error at ' . $data[0]);
}
} catch (Exception $e) {
$this->messages = $this->messages . $e->getMessage();
}
}
$row++;
}
} else {
$this->messages = $this->messages . ' memory or harddisk full';
}
fclose($handle);
} else {
$this->messages = $this->messages . ' check your directory permission';
}
if ($this->messages == '') {
$this->messages = 'success';
}
echo $this->messages;
}
if (isset($_GET['action']) && $_GET['action'] == "add") {
if (isset($_POST['bt_add'])) {
$education = new Education();
$education->education_name = $_POST['txt_education_name'];
$education->var_name = $education->mod_write_check($_POST['txt_education_name']);
$education->is_active = $_POST['txt_is_active'];
if ($education->save()) {
$session->message("New Education added.");
redirect_to($_SERVER['PHP_SELF']);
die;
} else {
$message = join("<br />", $education->errors);
}
}
}
$education = Education::find_all();
$manage_lists = array();
if ($education && is_array($education)) {
$i = 1;
foreach ($education as $list) {
$manage_lists[$i]['id'] = $list->id;
$manage_lists[$i]['education_name'] = $list->education_name;
$manage_lists[$i]['is_active'] = $list->is_active;
$i++;
}
$smarty->assign('manage_lists', $manage_lists);
}
$query = "";
if (!empty($_GET)) {
foreach ($_GET as $key => $data) {
if (!empty($data) && $data != "" && $key != "page" && $key != "bt_search") {
/**
* Save Job Title
* @param sfWebRequest $request
* @return unknown_type
*/
public function executeSaveEducation(sfWebRequest $request)
{
$educationService = new EducationService();
if ($request->isMethod('post')) {
$education = new Education();
$education->setEduUni($request->getParameter('txtName'));
$education->setEduDeg($request->getParameter('txtDeg'));
$educationService->saveEducation($education);
$this->setMessage('SUCCESS', array(TopLevelMessages::SAVE_SUCCESS));
$this->redirect('admin/listEducation');
}
}
function education($employee_id = '')
{
$data['page_name'] = '<b>Personal Data Sheet</b>';
$data['section_name'] = '<b>Personal Information</b>';
$data['focus_field'] = 'elem_school';
$data['msg'] = '';
$e = new Employee_m();
$data['employee'] = $e->get_by_id($employee_id);
$e = new Education();
if (Input::get('op')) {
// EDUCATIONAL BACKGROUND============================================
// ELEMENTARY
if (Input::get('elem_school') != "") {
$e = new Education();
$e->where('level', 1);
$e->where('employee_id', $employee_id)->get();
$e->delete_all();
$e->employee_id = $employee_id;
$e->level = 1;
$e->school_name = Input::get('elem_school');
$e->degree_course = Input::get('elem_degree');
$e->year_graduated = Input::get('elem_grad');
$e->highest_grade = Input::get('elem_units');
$e->attend_from = Input::get('elem_date1');
$e->attend_to = Input::get('elem_date2');
$e->scholarship = Input::get('elem_scho');
$e->save();
}
// HIGHSCHOOL
if (Input::get('sec_school') != "") {
$e = new Education();
$e->where('level', 2);
$e->where('employee_id', $employee_id)->get();
$e->delete_all();
$e->employee_id = $employee_id;
$e->level = 2;
$e->school_name = Input::get('sec_school');
$e->degree_course = Input::get('sec_degree');
$e->year_graduated = Input::get('sec_grad');
$e->highest_grade = Input::get('sec_units');
$e->attend_from = Input::get('sec_date1');
$e->attend_to = Input::get('sec_date2');
$e->scholarship = Input::get('sec_scho');
$e->save();
}
// VOC
if (Input::get('voc_school') != "") {
$e = new Education();
$e->where('level', 3);
$e->where('employee_id', $employee_id)->get();
$e->delete_all();
$e->employee_id = $employee_id;
$e->level = 3;
$e->school_name = Input::get('voc_school');
$e->degree_course = Input::get('voc_degree');
$e->year_graduated = Input::get('voc_grad');
$e->highest_grade = Input::get('voc_units');
$e->attend_from = Input::get('voc_date1');
$e->attend_to = Input::get('voc_date2');
$e->scholarship = Input::get('voc_scho');
$e->save();
}
// COLLEGE
if (Input::get('col_school') != "") {
$e = new Education();
$e->where('level', 4);
$e->where('employee_id', $employee_id)->get();
$e->delete_all();
$e->employee_id = $employee_id;
$e->level = 4;
$e->school_name = Input::get('col_school');
$e->degree_course = Input::get('col_degree');
$e->year_graduated = Input::get('col_grad');
$e->highest_grade = Input::get('col_units');
$e->attend_from = Input::get('col_date1');
$e->attend_to = Input::get('col_date2');
$e->scholarship = Input::get('col_scho');
$e->save();
}
// GRAD SCHOOL
if (Input::get('grad_school') != "") {
$e = new Education();
$e->where('level', 5);
$e->where('employee_id', $employee_id)->get();
$e->delete_all();
$e->employee_id = $employee_id;
$e->level = 5;
$e->school_name = Input::get('grad_school');
$e->degree_course = Input::get('grad_degree');
$e->year_graduated = Input::get('grad_grad');
$e->highest_grade = Input::get('grad_units');
$e->attend_from = Input::get('grad_date1');
$e->attend_to = Input::get('grad_date2');
$e->scholarship = Input::get('grad_scho');
$e->save();
}
$data['msg'] = 'Educational Background has been saved!';
}
// Educational Background======================================
$e = new Education();
$data['educs1'] = $e->get_single_educ($employee_id, $level = 1);
$data['educs2'] = $e->get_single_educ($employee_id, $level = 2);
$data['educs3'] = $e->get_single_educ($employee_id, $level = 3);
$data['educs4'] = $e->get_single_educ($employee_id, $level = 4);
$data['educs5'] = $e->get_single_educ($employee_id, $level = 5);
$e = new Employee_m();
$e->get_by_id($employee_id);
$data['selected'] = $e->office_id;
//Use for office listbox
$data['options'] = $this->options->office_options();
$data['employee_id'] = $employee_id;
$data['main_content'] = 'education';
return View::make('includes/template', $data);
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Education::model()->findByPk((int) $id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
$this->widget('ToolbarButton', array('isSave' => true, 'UrlSave' => 'educationmajor/write', 'isCancel' => true, 'UrlCancel' => 'educationmajor/cancelwrite'));
?>
</div>
<?php
echo $form->hiddenField($model, 'educationmajorid');
?>
<div class="row">
<?php
echo $form->labelEx($model, 'educationid');
?>
<?php
echo $form->hiddenField($model, 'educationid');
?>
<input type="text" name="educationname" id="educationname" readonly value="<?php
echo Education::model()->findByPk($model->educationid) !== null ? Education::model()->findByPk($model->educationid)->educationname : '';
?>
">
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'education_dialog', 'options' => array('title' => Yii::t('app', 'Education'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true)));
$this->widget('zii.widgets.grid.CGridView', array('id' => 'catering-grid', 'dataProvider' => $education->Searchwstatus(), 'filter' => $education, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+",
array("name" => "send_absschedule",
"id" => "send_absschedule",
"onClick" => "$(\\"#education_dialog\\").dialog(\\"close\\"); $(\\"#educationname\\").val(\\"$data->educationname\\"); $(\\"#Educationmajor_educationid\\").val(\\"$data->educationid\\");
"))'), array('name' => 'educationid', 'visible' => false, 'value' => '$data->educationid', 'htmlOptions' => array('width' => '1%')), 'educationname', array('class' => 'CCheckBoxColumn', 'name' => 'recordstatus', 'selectableRows' => '0', 'header' => 'Record Status', 'checked' => '$data->recordstatus'))));
$this->endWidget('zii.widgets.jui.CJuiDialog');
echo CHtml::Button('...', array('onclick' => '$("#education_dialog").dialog("open"); return false;'));
?>
<?php
echo $form->error($model, 'educationid');
?>
public static function getBarAtLaw()
{
//return Apphelper::getMemberId();
$membership_id = AppHelper::getMemberId();
$Id = Education::where('membership_id', '=', $membership_id)->get();
//return $user;
foreach ($Id as $value) {
$id = $value['id'];
}
$education = Education::find($id);
return $education->BarAtLaw;
}
function reDirect($getArr, $object = null)
{
$form_creator = new FormCreator($getArr);
switch ($getArr['uniqcode']) {
case 'BNK':
$form_creator->formPath = '/templates/eimadmin/bankinformation.php';
$bankinfo = new BankInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $bankinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $bankinfo->filterBankInfo($getArr['id']);
}
break;
case 'BCH':
$form_creator->formPath = '/templates/eimadmin/branches.php';
$brch = new Branches();
$bank = new BankInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $brch->getLastRecord();
$form_creator->popArr['bankcode'] = $bank->getBankCodes();
} elseif ($getArr['captuIMPremode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $brch->filterBranches($getArr['id']);
$form_creator->popArr['bankcode'] = $bank->getBankCodes();
}
break;
case 'TAX':
$form_creator->formPath = '/templates/eimadmin/taxinformation.php';
$taxinfo = new TaxInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $taxinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $taxinfo->filterTaxInfo($getArr['id']);
}
break;
case 'CCB':
$form_creator->formPath = '/templates/eimadmin/cashben.php';
$cashben = new CashBen();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $cashben->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $cashben->filterCashBenefits($getArr['id']);
}
break;
case 'BBS':
$form_creator->formPath = '/templates/eimadmin/cashbensal.php';
$salgrd = new SalaryGrades();
$cashbensal = new CashBenSalary();
$cashben = new CashBen();
$form_creator->popArr['salDet'] = $salgrd->filterSalaryGrades($getArr['id']);
$form_creator->popArr['benListAll'] = $cashben->getAllCashBenefits();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $cashbensal->filterCashBenefits($arr);
} else {
$form_creator->popArr['benListUnAss'] = $cashben->getCashBenCodes($getArr['id']);
}
$form_creator->popArr['benListAss'] = $cashbensal->getAssCashBenefits($getArr['id']);
break;
case 'COS':
$form_creator->formPath = '/templates/eimadmin/costcenters.php';
$cost = new CostCenter();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $cost->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $cost->filterCostCenter($getArr['id']);
}
break;
case 'COU':
$form_creator->formPath = '/templates/eimadmin/countryinformation.php';
$country = new CountryInfo();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $country->filterCountryInfo($getArr['id']);
}
break;
case 'CUR':
$form_creator->formPath = '/templates/eimadmin/currencytypes.php';
$currency = new CurrencyTypes();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $currency->filterCurrencyTypes($getArr['id']);
}
break;
case 'DWT':
$form_creator->formPath = '/templates/eimadmin/dwellinginformation.php';
$dwinfo = new DwellingType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $dwinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $dwinfo->filterDwellingType($getArr['id']);
}
break;
case 'ELE':
$form_creator->formPath = '/templates/eimadmin/electorateinformation.php';
$eleinfo = new ElectorateInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $eleinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $eleinfo->filterElectorateInfo($getArr['id']);
}
break;
case 'EMC':
$form_creator->formPath = '/templates/eimadmin/empcatinfo.php';
$empcatinfo = new EmployeeCat();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $empcatinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $empcatinfo->filterEmployeeCat($getArr['id']);
}
break;
case 'EMG':
$form_creator->formPath = '/templates/eimadmin/employeegroups.php';
$empgrpinfo = new EmployeeGroup();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $empgrpinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $empgrpinfo->filterEmployeeGroup($getArr['id']);
}
break;
case 'ETY':
$form_creator->formPath = '/templates/eimadmin/emptypes.php';
$emptype = new EmployeeType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $emptype->getLastRecord();
} elseif ($getArr['capturemIMPode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $emptype->filterEmployeeType($getArr['id']);
}
break;
case 'EXC':
$form_creator->formPath = '/templates/eimadmin/extracurractcat.php';
$exccat = new ExtraCurrActCat();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $exccat->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $exccat->filterExtraCurrActCat($getArr['id']);
}
break;
case 'DEF':
$form_creator->formPath = '/templates/eimadmin/hierarchydef.php';
$hidef = new HierarchyDefInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $hidef->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $hidef->filterHierarchyDefInfo($getArr['id']);
}
break;
case 'CHI':
$form_creator->formPath = '/templates/eimadmin/comphier.php';
$cmphier = new CompHierachy();
$hidef = new HierarchyDefInfo();
$loc = new models_eimadmin_Location();
$empinfo = new EmpInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $cmphier->getLastRecord();
$form_creator->popArr['hiercodes'] = $hidef->getHierachyCodes();
$form_creator->popArr['empcodes'] = $empinfo->getEmpCodes();
$form_creator->popArr['deflev'] = $cmphier->getHierachyDef();
$form_creator->popArr['loccodes'] = $loc->getLocCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $cmphier->filterCompHierachy($getArr['id']);
$form_creator->popArr['hiercodes'] = $cmphier->getHierachyCodes();
$form_creator->popArr['empcodes'] = $empinfo->getEmpCodes();
$form_creator->popArr['deflev'] = $cmphier->getHierachyDef();
$form_creator->popArr['loccodes'] = $loc->getLocCodes();
}
break;
case 'LOC':
$form_creator->formPath = '/templates/eimadmin/locations.php';
$loc = new models_eimadmin_Location();
$country = new CountryInfo();
$form_creator->popArr['cntlist'] = $country->getCountryCodes();
if ($getArr['capturemode'] == 'updatemode') {
$province = new ProvinceInfo();
$district = new DistrictInfo();
$form_creator->popArr['editArr'] = $edit = $loc->filterLocation($getArr['id']);
$form_creator->popArr['provlist'] = $province->getProvinceCodes($edit[0][2]);
$form_creator->popArr['districtlist'] = $district->getDistrictCodes($edit[0][3]);
}
break;
case 'JDC':
$form_creator->formPath = '/templates/eimadmin/jdcategory.php';
$jdcat = new JDCategory();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $jdcat->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $jdcat->filterJDCategory($getArr['id']);
}
break;
case 'MEM':
$form_creator->formPath = '/templates/eimadmin/membershiptypes.php';
$memtype = new MembershipType();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $memtype->filterMembershipType($getArr['id']);
}
break;
case 'EMX':
$form_creator->formPath = '/templates/eimadmin/emailConfiguration.php';
$emailConfigObj = new EmailConfiguration();
$form_creator->popArr['editArr'] = $emailConfigObj;
break;
case 'CSE':
$form_creator->formPath = '/templates/eimadmin/dataExport.php';
$csvExport = new CSVExport();
$form_creator->popArr['exportTypes'] = $csvExport->getDefinedExportTypes();
break;
case 'IMP':
if (isset($getArr['upload']) && $getArr['upload'] == 1) {
$form_creator->formPath = '/templates/eimadmin/dataUploadStatus.php';
$form_creator->popArr['uploadStatus'] = $object;
$form_creator->popArr['recordLimit'] = CSVSplitter::getRecordLimit();
$form_creator->popArr['delimiterLevels'] = AjaxCalls::getDelimiterLevelsArray(3);
} else {
$form_creator->formPath = '/templates/eimadmin/dataImport.php';
$csvImport = new CSVImport();
$form_creator->popArr['importTypes'] = $csvImport->getDefinedImportTypes();
}
break;
case 'ENS':
$form_creator->formPath = '/templates/eimadmin/emailNotificationConfiguration.php';
$emailNotificationConfObj = new EmailNotificationConfiguration($_SESSION['user']);
$form_creator->popArr['editArr'] = $emailNotificationConfObj->fetchNotifcationStatus();
break;
case 'NAT':
$form_creator->formPath = '/templates/eimadmin/nationalityinformation.php';
$natinfo = new NationalityInfo();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $natinfo->filterNationalityInfo($getArr['id']);
}
break;
case 'NCB':
$form_creator->formPath = '/templates/eimadmin/noncashben.php';
$noncashben = new NonCashBen();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $noncashben->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $noncashben->filterNonCashBenefits($getArr['id']);
}
break;
case 'QLF':
$form_creator->formPath = '/templates/eimadmin/qualificationtypes.php';
$qualtype = new QualificationType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $qualtype->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $qualtype->filterQualificationType($getArr['id']);
}
break;
case 'RTM':
$form_creator->formPath = '/templates/eimadmin/ratingmethods.php';
$rattype = new RatingTypes();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $rattype->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $rattype->filterRatingTypes($getArr['id']);
}
break;
case 'RTE':
$form_creator->formPath = '/templates/eimadmin/routeinformation.php';
$rouinfo = new RouteInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $rouinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $rouinfo->filterRouteInfo($getArr['id']);
}
break;
case 'SGR':
$form_creator->formPath = '/templates/eimadmin/salarygrades.php';
$salgrade = new SalaryGrades();
$salcurdet = new SalCurDet();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $salgrade->filterSalaryGrades($getArr['id']);
$form_creator->popArr['assCurrency'] = $salcurdet->getAssSalCurDet($getArr['id']);
if (!isset($getArr['editID'])) {
$form_creator->popArr['unAssCurrency'] = $salcurdet->getUnAssSalCurDet($getArr['id']);
} else {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editAssCurrency'] = $salcurdet->filterSalCurDet($arr);
}
}
break;
case 'SKI':
$form_creator->formPath = '/templates/eimadmin/skills.php';
$skill = new Skills();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $skill->filterSkills($getArr['id']);
}
break;
case 'ETH':
$form_creator->formPath = '/templates/eimadmin/ethnicrace.php';
$ethnicrace = new EthnicRace();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $ethnicrace->filterEthnicRace($getArr['id']);
}
break;
case 'EXA':
$form_creator->formPath = '/templates/eimadmin/extracurractinfo.php';
$extcainfo = new ExtraCurActInfo();
$excurac = new ExtraCurrActCat();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $extcainfo->getLastRecord();
$form_creator->popArr['getResultSet'] = $extcainfo->getExtraCatCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $extcainfo->filterExtraCurActInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $excurac->getExtraCatCodes();
}
break;
case 'MME':
$form_creator->formPath = '/templates/eimadmin/membershipinformation.php';
$meminfo = new MembershipInfo();
$memtype = new MembershipType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['getResultSet'] = $memtype->getMembershipTypeCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $meminfo->filterMembershipInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $memtype->getMembershipTypeCodes();
}
break;
case 'JDK':
$form_creator->formPath = '/templates/eimadmin/jdkra.php';
$jdkr = new JDKra();
$skill = new Skills();
$jdtyp = new JDType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $jdkr->getLastRecord();
$form_creator->popArr['jdktyplist'] = $jdtyp->getJDTypeCodes();
$form_creator->popArr['sktyplist'] = $skill->getSkillCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $jdkr->filterJDKra($getArr['id']);
$form_creator->popArr['jdktyplist'] = $jdtyp->getJDTypeCodes();
$form_creator->popArr['sktyplist'] = $skill->getSkillCodes();
}
break;
case 'LAN':
$form_creator->formPath = '/templates/eimadmin/languageinformation.php';
$laninfo = new LanguageInfo();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $laninfo->filterLanguageInfo($getArr['id']);
}
break;
case 'RLG':
$form_creator->formPath = '/templates/eimadmin/religioninformation.php';
$relinfo = new ReligionInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $relinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $relinfo->filterReligionInfo($getArr['id']);
}
break;
case 'SAT':
$form_creator->formPath = '/templates/eimadmin/satutoryinfo.php';
$satinfo = new SatutoryInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $satinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $satinfo->filterSatutoryInfo($getArr['id']);
}
break;
case 'UNI':
$form_creator->formPath = '/templates/eimadmin/uniformtypes.php';
$unitype = new UniformType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $unitype->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $unitype->filterUniformType($getArr['id']);
}
break;
case 'EXA':
$form_creator->formPath = '/templates/eimadmin/extracurractinfo.php';
$excurac = new ExtraCurActInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $excurac->getLastRecord();
$form_creator->popArr['getResultSet'] = $excurac->getExtraCatCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $excurac->filterExtraCurActInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $excurac->getExtraCatCodes();
}
break;
case 'EDU':
$form_creator->formPath = '/templates/eimadmin/qualifications.php';
$edu = new Education();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $edu->filterEducation($getArr['id']);
}
break;
case 'JDT':
$form_creator->formPath = '/templates/eimadmin/jdtypes.php';
$jdtyp = new JDType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $jdtyp->getLastRecord();
$form_creator->popArr['jdcatcodes'] = $jdtyp->getJDTypeCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $jdtyp->filterJDType($getArr['id']);
$form_creator->popArr['jdcatcodes'] = $jdtyp->getJDTypeCodes();
}
break;
case 'SBJ':
$form_creator->formPath = '/templates/eimadmin/subjectinformation.php';
$subin = new SubjectInfo();
$qualifi = new Qualifications();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $subin->getLastRecord();
$form_creator->popArr['getResultSet'] = $qualifi->getQualifiCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $subin->filterSubjectInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $qualifi->getQualifiCodes();
}
break;
case 'SSK':
$form_creator->formPath = '/templates/eimadmin/subskillinformation.php';
$subsk = new SubSkillInfo();
$skill = new Skills();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $subsk->getLastRecord();
$form_creator->popArr['getResultSet'] = $skill->getSkillCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $subsk->filterSubSkillInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $skill->getSkillCodes();
}
break;
case 'CTT':
$form_creator->formPath = '/templates/eimadmin/corptit.php';
$corptit = new CorpTitle();
$salgrd = new SalaryGrades();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $corptit->getLastRecord();
$form_creator->popArr['corptitles'] = $corptit->getCorpTitles();
$form_creator->popArr['salgrds'] = $corptit->getSalGrades();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $corptit->filterCorpTitles($getArr['id']);
$form_creator->popArr['corptitles'] = $corptit->getCorpTitles();
$form_creator->popArr['salgrds'] = $salgrd->getSalGrades();
}
break;
case 'DSG':
$form_creator->formPath = '/templates/eimadmin/designations.php';
$desig = new Designations();
$corptit = new CorpTitle();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $desig->getLastRecord();
$form_creator->popArr['corptitles'] = $corptit->getCorpTitles();
$form_creator->popArr['des'] = $desig->getDes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $desig->filterDesignations($getArr['id']);
$form_creator->popArr['corptitles'] = $corptit->getCorpTitles();
$form_creator->popArr['des'] = $desig->getDes();
}
break;
case 'DIS':
$form_creator->formPath = '/templates/eimadmin/districtinformation.php';
$disinfo = new DistrictInfo();
$prov = new ProvinceInfo();
$country = new CountryInfo();
$form_creator->popArr['countrylist'] = $country->getCountryCodes();
if ($getArr['capturemode'] == 'addmode') {
if ($object != null) {
$form_creator->popArr['txtDistrictDesc'] = $object->txtDistrictDesc;
$form_creator->popArr['cmbCountry'] = $object->cmbCountry;
$form_creator->popArr['selProvince'] = $object->selProvince;
$form_creator->popArr['provlist'] = $prov->getProvinceCodes($object->cmbCountry);
}
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $editArr = $disinfo->filterDistrictInfo($getArr['id']);
if ($object != null) {
$form_creator->popArr['txtDistrictDesc'] = $object->txtDistrictDesc;
$form_creator->popArr['cmbCountry'] = $object->cmbCountry;
$form_creator->popArr['selProvince'] = $object->selProvince;
$form_creator->popArr['provlist'] = $prov->getProvinceCodes($object->cmbCountry);
} else {
$temp = $prov->filterGetProvinceCodeInfo($editArr[0][2]);
$form_creator->popArr['selcountry'] = $temp[0][2];
$form_creator->popArr['provlist'] = $prov->getProvinceCodes($temp[0][2]);
}
}
break;
case 'NBS':
$form_creator->formPath = '/templates/eimadmin/noncashbensal.php';
$salgrd = new SalaryGrades();
$noncashbensal = new NonCashBenSalary();
$noncashben = new NonCashBen();
$form_creator->popArr['salDet'] = $salgrd->filterSalaryGrades($getArr['id']);
$form_creator->popArr['benListAll'] = $noncashben->getAllNonCashBenefits();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $noncashben->filterNonCashBenefits($arr);
} else {
$form_creator->popArr['benListUnAss'] = $noncashben->getNonCashBenCodes($getArr['id']);
}
$form_creator->popArr['benListAss'] = $noncashbensal->getAssCashBenefits($getArr['id']);
break;
case 'DDI':
$form_creator->formPath = '/templates/eimadmin/desdis.php';
$desig = new Designations();
$desdis = new DesDescription();
$form_creator->popArr['desDet'] = $desig->getDes();
$form_creator->popArr['desDisAss'] = $desdis->getAssigned($getArr['id']);
if (isset($getArr['editID'])) {
$arr[1] = $getArr['id'];
$arr[0] = $getArr['editID'];
$form_creator->popArr['editArr'] = $desdis->filterJDKPI($arr);
}
if (isset($getArr['addForm']) && $getArr['addForm'] == 'ADD') {
$form_creator->popArr['desDisUnAss'] = $desdis->getGrouping($getArr['id']);
}
break;
case 'DQA':
$form_creator->formPath = '/templates/eimadmin/desqua.php';
$desig = new Designations();
$desqual = new DesQualification();
$form_creator->popArr['desDet'] = $desig->getDes();
$form_creator->popArr['qualListAll'] = $desqual->getAllQualifications();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $desqual->filterJDQual($arr);
} else {
$form_creator->popArr['qualListUnAss'] = $desqual->getQual($getArr['id']);
}
$form_creator->popArr['qualListAss'] = $desqual->getAssJDQual($getArr['id']);
break;
case 'DQS':
$form_creator->formPath = '/templates/eimadmin/desquasub.php';
$desig = new Designations();
$desqualsub = new DesQualSubject();
$qualifi = new Qualifications();
$form_creator->popArr['desDet'] = $desig->filterDesignations($getArr['id']);
$form_creator->popArr['qualDet'] = $qualifi->getQualCodes();
$form_creator->popArr['gradlist'] = $desqualsub->getRatGrds($getArr['QUA']);
$form_creator->popArr['subDet'] = $desqualsub->getSubjectCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$arr[2] = $getArr['QUA'];
$form_creator->popArr['editArr'] = $desqualsub->filterQuaSub($arr);
} else {
$form_creator->popArr['sublist'] = $desqualsub->getSubjects($getArr['id'], $getArr['QUA']);
}
$form_creator->popArr['rset'] = $desqualsub->getAssQuaSub($getArr['id']);
break;
case 'RTG':
$form_creator->formPath = '/templates/eimadmin/ratinggrade.php';
$rattyp = new RatingTypes();
$form_creator->popArr['ratDet'] = $rattyp->filterRatingTypes($getArr['id']);
$ratgrd = new RatingGrade();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $ratgrd->filterRatGrd($arr);
} else {
$form_creator->popArr['newID'] = $ratgrd->getLastRecord();
}
$form_creator->popArr['ratGrdAss'] = $ratgrd->getAssRatGrd($getArr['id']);
break;
case 'EEC':
$form_creator->formPath = '/templates/eimadmin/eeojobcat.php';
$eeojobcat = new EEOJobCat();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $eeojobcat->filterEEOJobCat($getArr['id']);
}
break;
case 'LIC':
$form_creator->formPath = '/templates/eimadmin/licenses.php';
$licenses = new Licenses();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $licenses->filterLicenses($getArr['id']);
}
break;
case 'CST':
$form_creator->formPath = '/templates/eimadmin/compstruct.php';
/*
$hierachinfo = new HierarchyDefInfo();
$comphier = new CompHierachy();
$compstruct = new CompStruct();
$form_creator->popArr['hierlist'] = $hierachinfo -> getHierarchyDef();
$form_creator->popArr['compstruct'] = $comphier ->getAssCompHier(1,'');
$form_creator->popArr['unAssCompStruct'] = $compstruct->getUnAssCompStruct('',1);
*/
$locations = new models_eimadmin_Location();
$countries = new CountryInfo();
$form_creator->popArr['locations'] = $locations->getLocCodes();
$form_creator->popArr['countries'] = $countries->getCountryCodes();
break;
case 'TCP':
$form_creator->formPath = '/templates/eimadmin/companyProperty.php';
$authorizeObj = new authorize($_SESSION['empID'], $_SESSION['isAdmin']);
if (!isset($_GET['action'])) {
$empInfo = new EmpInfo();
if ($authorizeObj->isAdmin()) {
$form_creator->popArr['emplist'] = $empInfo->getListofEmployee();
} else {
$empReportTo = new EmpRepTo();
$form_creator->popArr['emplist'] = $empReportTo->getEmpSubDetails($_SESSION['empID']);
/* An element of the value from $empInfo->getListofEmployee() will contain
* an array with 6 elements. Values from $empReportTo->getEmpSubDetails() will
* only contain 3 elements. But there won't be a problem because only first 3 values
* will be used in the template
*/
}
}
$compProp = new CompProperty();
$propertyCount = count($compProp->getPropertyList());
$pageNo = 1;
if (isset($_REQUEST['pageNo'])) {
$pageNo = $_REQUEST['pageNo'];
} else {
$pageNo = ceil($propertyCount / 10);
}
if ($authorizeObj->isAdmin()) {
$form_creator->popArr['properties'] = $compProp->getPropertyList($pageNo);
} else {
$subordinateList = array();
foreach ($form_creator->popArr['emplist'] as $subordinate) {
$subordinateList[] = $subordinate[0];
}
$form_creator->popArr['properties'] = $compProp->getPropertyList($pageNo, $subordinateList, true);
}
$form_creator->popArr['allProperties'] = $compProp->getPropertyList();
$form_creator->popArr['pageNo'] = $pageNo;
$form_creator->popArr['recordCount'] = $propertyCount;
$form_creator->popArr['authObj'] = $authorizeObj;
break;
case 'JOB':
$form_creator->formPath = '/templates/eimadmin/jobtitle.php';
$jobtitle = new JobTitle();
$paygrade = new SalaryGrades();
$jobtit_empstat = new JobTitEmpStat();
$form_creator->popArr['paygrade'] = $paygrade->getSalGrades(true);
$form_creator->popArr['jobSpecList'] = JobSpec::getAll();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $jobtitle->filterJobTitles($getArr['id']);
$form_creator->popArr['assEmploymentStat'] = $jobtit_empstat->getAssEmpStat($getArr['id']);
$form_creator->popArr['unAssEmploymentStat'] = $jobtit_empstat->getUnAssEmpStat($getArr['id']);
}
break;
case 'SPC':
$form_creator->formPath = '/templates/eimadmin/jobSpec.php';
// Here we fetch all job specs for easier validation of duplicate names
// Assuming it's unlikely that very large number of job specs will be defined.
$form_creator->popArr['jobSpecList'] = JobSpec::getAll();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['jobSpec'] = JobSpec::getJobSpec($getArr['id']);
} else {
$form_creator->popArr['jobSpec'] = new JobSpec();
}
break;
case 'EST':
$form_creator->formPath = '/templates/eimadmin/empstat.php';
$empstat = new EmploymentStatus();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $empstat->filterEmpStat($getArr['id']);
}
break;
case 'GEN':
$form_creator->formPath = '/templates/eimadmin/geninfo.php';
$geninfo = new GenInfo();
$country = new CountryInfo();
$province = new ProvinceInfo();
$district = new DistrictInfo();
$tabArr = $geninfo->filterGenInfo();
$genInfoKeys = explode('|', $tabArr[0][0]);
$genInfoValues = explode('|', $tabArr[0][1]);
for ($c = 0; $genInfoKeys && count($genInfoKeys) > $c; $c++) {
$editArr[$genInfoKeys[$c]] = $genInfoValues[$c];
}
$form_creator->popArr['editArr'] = $editArr;
$form_creator->popArr['cntlist'] = $country->getCountryCodes();
if (isset($editArr['COUNTRY'])) {
$form_creator->popArr['provlist'] = $province->getProvinceCodes($editArr['COUNTRY']);
}
if (isset($editArr['STATE'])) {
$form_creator->popArr['districtlist'] = $district->getDistrictCodes($editArr['STATE']);
}
//Finding the numer of employees
$empInfo = new EmpInfo();
$form_creator->popArr['empcount'] = $empInfo->countEmployee();
break;
case 'CUS':
$form_creator->formPath = '/templates/eimadmin/customer.php';
$customer = new Customer();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $customer->fetchCustomer($getArr['id']);
} else {
$form_creator->popArr['editArr'] = new Customer();
}
break;
case 'CTM':
$form_creator->formPath = '/templates/eimadmin/customFields.php';
$form_creator->popArr['available'] = CustomFields::getAvailableFieldNumbers();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = CustomFields::getCustomField($getArr['id']);
} else {
$form_creator->popArr['editArr'] = new CustomFields();
}
break;
case 'CEX':
$form_creator->formPath = '/templates/eimadmin/customExportDefine.php';
$form_creator->popArr['customExportList'] = CustomExport::getCustomExportList();
if ($getArr['capturemode'] == 'updatemode') {
$customExport = CustomExport::getCustomExport($getArr['id']);
$form_creator->popArr['headings'] = $customExport->getHeadings();
$form_creator->popArr['available'] = $customExport->getAvailableFields();
$form_creator->popArr['assigned'] = $customExport->getAssignedFields();
$form_creator->popArr['exportName'] = $customExport->getName();
$form_creator->popArr['id'] = $customExport->getId();
} else {
$form_creator->popArr['headings'] = array();
$form_creator->popArr['available'] = CustomExport::getAllFields();
$form_creator->popArr['assigned'] = array();
$form_creator->popArr['exportName'] = null;
$form_creator->popArr['id'] = null;
}
break;
case 'CIM':
$form_creator->formPath = '/templates/eimadmin/customImportDefine.php';
$form_creator->popArr['customImportList'] = CustomImport::getCustomImportList();
if ($getArr['capturemode'] == 'updatemode') {
$customImport = CustomImport::getCustomImport($getArr['id']);
$form_creator->popArr['has_heading'] = $customImport->getContainsHeader();
$form_creator->popArr['available'] = $customImport->getAvailableFields();
$form_creator->popArr['assigned'] = $customImport->getAssignedFields();
$form_creator->popArr['importName'] = $customImport->getName();
$form_creator->popArr['id'] = $customImport->getId();
$form_creator->popArr['compulsary_fields'] = CustomImport::getCompulsaryFields();
} else {
$customImport = new CustomImport();
// Assign compulsary fields
$compulsary = CustomImport::getCompulsaryFields();
$customImport->setAssignedFields($compulsary);
$form_creator->popArr['has_heading'] = true;
$form_creator->popArr['available'] = $customImport->getAvailableFields();
$form_creator->popArr['assigned'] = $compulsary;
$form_creator->popArr['importName'] = null;
$form_creator->popArr['id'] = null;
$form_creator->popArr['compulsary_fields'] = $compulsary;
}
break;
case 'CHD':
$form_creator->formPath = '/templates/eimadmin/customExportHeadingDefine.php';
$customExport = CustomExport::getCustomExport($getArr['id']);
$headings = $customExport->getHeadings();
$form_creator->popArr['headings'] = empty($headings) ? $customExport->getAssignedFields() : $headings;
$form_creator->popArr['assigned'] = $customExport->getAssignedFields();
$form_creator->popArr['exportName'] = $customExport->getName();
$form_creator->popArr['id'] = $customExport->getId();
break;
case 'PAD':
// Project Admin. Fall through to PRJ case below.
$form_creator->getArr['uniqcode'] = "PRJ";
case 'PRJ':
$form_creator->formPath = '/templates/eimadmin/project.php';
$project = new Projects();
$customer = new Customer();
$form_creator->popArr['cusid'] = $customer->fetchCustomers();
$form_creator->popArr['employeeList'] = EmpInfo::getEmployeeMainDetails();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $project->fetchProject($getArr['id']);
$gw = new ProjectAdminGateway();
$form_creator->popArr['admins'] = $gw->getAdmins($getArr['id']);
}
break;
case 'PAC':
$form_creator->formPath = '/templates/eimadmin/projectActivity.php';
/* If a HR admin, show all projects. Otherwise only show projects for which
* user is an admin
*/
$authorizeObj = new authorize($_SESSION['empID'], $_SESSION['isAdmin']);
if ($authorizeObj->isAdmin()) {
$projects = new Projects();
/* Filter only not deleted projects */
$projects->setDeleted(Projects::PROJECT_NOT_DELETED);
$projectList = $projects->fetchProjects();
} else {
if ($authorizeObj->isProjectAdmin()) {
$gw = new ProjectAdminGateway();
$projectList = $gw->getProjectsForAdmin($_SESSION['empID']);
}
}
/* If projectId given, get activities for that project else load first
* project in list
*/
$projectId = null;
$activities = array();
if (!empty($projectList)) {
if (isset($getArr['projectId']) && ($authorizeObj->isAdmin() || $authorizeObj->isProjectAdminOf($getArr['projectId']))) {
$projectId = $getArr['projectId'];
} else {
$projectId = $projectList[0]->getProjectId();
}
$activities = ProjectActivity::getActivityList($projectId);
}
$form_creator->popArr['projects'] = $projectList;
$form_creator->popArr['projectId'] = $projectId;
$form_creator->popArr['activities'] = $activities;
break;
case 'USR':
$form_creator->formPath = '/templates/maintenance/users.php';
$user = new Users();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['emplist'] = $user->getEmployeeCodes();
$form_creator->popArr['uglist'] = $user->getUserGroupCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $user->filterUsers($getArr['id']);
$form_creator->popArr['emplist'] = $user->getEmployeeCodes();
$form_creator->popArr['uglist'] = $user->getUserGroupCodes();
//$form_creator ->popArr['editArr'] = $user->filterChangeUsers($getArr['id']);
}
$form_creator->popArr['employeeSearchList'] = EmpInfo::getEmployeeSearchList();
break;
case 'USG':
$form_creator->formPath = '/templates/maintenance/usergroups.php';
$usrgrp = new UserGroups();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $usrgrp->filterUserGroups($getArr['id']);
}
break;
case 'UGR':
$form_creator->formPath = '/templates/maintenance/AdminMenu.php';
$urights = new Rights();
$usergroup = new UserGroups();
$form_creator->popArr['ugDet'] = $usergroup->filterUserGroups($getArr['id']);
$form_creator->popArr['modlist'] = $urights->getAllModules();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $urights->filterRights($arr);
} else {
$form_creator->popArr['modlistUnAss'] = $urights->getModuleCodes($getArr['id']);
}
$form_creator->popArr['modlistAss'] = $urights->getAssRights($getArr['id']);
break;
case 'LDAP':
if ($_SESSION['ldap'] == "enabled") {
$form_creator->formPath = '/templates/eimadmin/ldapConfiguration.php';
$ldapConfigObj = new LdapDetails();
$form_creator->popArr['editArr'] = $ldapConfigObj->retrieveLdapDetails();
}
break;
}
$form_creator->display();
}
function reDirect($getArr, $postArr, $object = null)
{
$form_creator = new FormCreator($getArr, $postArr);
switch ($getArr['reqcode']) {
case 'JSP':
$form_creator->formPath = '/templates/hrfunct/hrempjobspec.php';
$ejobsp = new EmpJobSpec();
$empinfo = new EmpInfo();
$jdcat = new JDCategory();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['catlist'] = $jdcat->getJDCatCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $ejobsp->filterEmpJobSpec($arr);
} else {
$form_creator->popArr['unasscatlist'] = $jdcat->getUnAssJDCatCodes($getArr['id']);
}
$form_creator->popArr['rset'] = $ejobsp->getAssEmpJobSpec($getArr['id']);
//$form_creator ->popArr['catlist']=$ejobsp->getJDCatCodes();
break;
case 'CXT':
$form_creator->formPath = '/templates/hrfunct/hrempconext.php';
$empconext = new EmpConExt();
$empinfo = new EmpInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['empstat'] = $empinfo->filterEmpJobStat($getArr['id']);
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empconext->filterConExt($arr);
$form_creator->popArr['lastrec'] = $empconext->getLastRecord($getArr['id']);
} else {
$form_creator->popArr['lastrec'] = $empconext->getLastRecord($getArr['id']);
}
$form_creator->popArr['rset'] = $empconext->getAssConExt($getArr['id']);
break;
case 'SAL':
$form_creator->formPath = '/templates/hrfunct/hrempbassal.php';
$empinfo = new EmpInfo();
$empbassal = new EmpBasSalary();
$currTyp = new CurrencyTypes();
$form_creator->popArr['einfo'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['empdet'] = $empdet = $empinfo->filterEmpJobInfo($getArr['id']);
$salGrd = $empdet[0][5];
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $edit = $empbassal->filterEmpBasSal($arr);
$form_creator->popArr['currlist'] = $empbassal->getCurrCodes($edit[0][1]);
} else {
$form_creator->popArr['curlist'] = $empbassal->getUnAssCurrCodes($salGrd, $getArr['id']);
if ($object != null) {
$form_creator->popArr['cmbCurrCode'] = $object->cmbCurrCode;
}
}
$form_creator->popArr['rset'] = $empbassal->getAssEmpBasSal($getArr['id']);
$form_creator->popArr['currAlllist'] = $currTyp->getAllCurrencyCodes();
break;
case 'LAN':
$form_creator->formPath = '/templates/hrfunct/hremplan.php';
$empinf = new EmpInfo();
$emplan = new EmpLanguage();
$laninfo = new LanguageInfo();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['lanlist'] = $lanlist = $laninfo->getLang();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $emplan->filterEmpLang($arr);
for ($c = 0; count($lanlist) > $c; $c++) {
if ($getArr['editID1'] == $lanlist[$c][0]) {
$ratSel = $lanlist[$c][2];
}
}
} else {
if ($object != null) {
$form_creator->popArr['cmbLanCode'] = $object->cmbLanCode;
for ($c = 0; $lanlist && count($lanlist) > $c; $c++) {
if ($lanlist[$c][0] == $object->cmbLanCode) {
$ratSel = $lanlist[$c][2];
}
}
$form_creator->popArr['ratSel'] = $ratSel;
}
$form_creator->popArr['lanlist'] = $laninfo->getLang();
}
$form_creator->popArr['rsets'] = $emplan->getAssEmpLang($getArr['id']);
break;
case 'MEM':
$form_creator->formPath = '/templates/hrfunct/hrempmemship.php';
$empinf = new EmpInfo();
$empmem = new EmpMembership();
$memtype = new MembershipType();
$memshipinfo = new MembershipInfo();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $edit = $empmem->filterEmpMembership($arr);
$form_creator->popArr['mship'] = $memshipinfo->getMembershipCodes($edit[0][2]);
} else {
if ($object != null) {
$form_creator->popArr['cmbMemTypeCode'] = $object->cmbMemTypeCode;
$form_creator->popArr['mship'] = $memshipinfo->getUnAssMembershipCodes($getArr['id'], $object->cmbMemTypeCode);
}
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
}
$form_creator->popArr['rset'] = $empmem->getAssEmpMembership($getArr['id']);
$form_creator->popArr['mshipAll'] = $memshipinfo->getAllMembershipCodes();
break;
case 'EXC':
$form_creator->formPath = '/templates/hrfunct/hrempextcur.php';
$empinfo = new EmpInfo();
$empextcur = new EmpExCur();
$extracurr = new ExtraCurrActCat();
$extrainfo = new ExtraCurActInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['catlist'] = $extracurr->getExCurCatCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $edit = $empextcur->filterEmpExCur($arr);
$form_creator->popArr['typelist'] = $extrainfo->getExCurTypeCodes($edit[0][2]);
} else {
$form_creator->popArr['lastrec'] = $empextcur->getLastRecord($getArr['id']);
if ($object != null) {
$form_creator->popArr['cmbExtCurCat'] = $catcode = $object->cmbExtCurCat;
$form_creator->popArr['typeunasslist'] = $extrainfo->getUnAssExCurTypeCodes($getArr['id'], $catcode);
}
}
$form_creator->popArr['rset'] = $empextcur->getAssExCur($getArr['id']);
$form_creator->popArr['allcatlist'] = $extracurr->getExCurCatCodes();
$form_creator->popArr['alltypelist'] = $extrainfo->getAllExtraCurActInfo();
break;
case 'EXP':
$form_creator->formPath = '/templates/hrfunct/hrempwrkexp.php';
$empinfo = new EmpInfo();
$empworkex = new EmpWorkExp();
$countryinfo = new CountryInfo();
$proinfo = new ProvinceInfo();
$form_creator->popArr['empDet'] = $empinfo->filterEmpMain($getArr['id']);
if ($object != null) {
$form_creator->popArr['txtEmpExpCompany'] = $object->txtEmpExpCompany;
$form_creator->popArr['txtEmpExpToDat'] = $object->txtEmpExpToDat;
$form_creator->popArr['txtEmpExpDesOnLev'] = $object->txtEmpExpDesOnLev;
$form_creator->popArr['txtEmpExpYears'] = $object->txtEmpExpYears;
$form_creator->popArr['chkEmpExpWorkRelFlag'] = $object->chkEmpExpWorkRelFlag;
$form_creator->popArr['txtEmpExpMonths'] = $object->txtEmpExpMonths;
$form_creator->popArr['txtEmpExpAdd1'] = $object->txtEmpExpAdd1;
$form_creator->popArr['txtEmpExpAcc'] = $object->txtEmpExpAcc;
$form_creator->popArr['txtEmpExpAdd2'] = $object->txtEmpExpAdd2;
}
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $edit = $empworkex->filterEmpWorkExp($arr);
$form_creator->popArr['list'] = $countryinfo->getCountryCodes();
if ($object != null) {
$form_creator->popArr['txtEmpExpAdd2'] = $pli = $object->txtEmpExpAdd2;
$form_creator->popArr['txtEmpExpConPers'] = $object->txtEmpExpConPers;
$form_creator->popArr['txtEmpExpAdd3'] = $object->txtEmpExpAdd3;
$form_creator->popArr['txtEmpExpTelep'] = $object->txtEmpExpTelep;
$form_creator->popArr['txtEmpResLev'] = $object->txtEmpResLev;
$form_creator->popArr['txtEmpExpAchmnt'] = $object->txtEmpExpAchmnt;
$form_creator->popArr['txtEmpExpFromDat'] = $object->txtEmpExpFromDat;
$form_creator->popArr['txtEmpExpEmail'] = $object->txtEmpExpEmail;
$form_creator->popArr['plist'] = $empinfo->getProvinceCodes($pli);
} else {
$form_creator->popArr['plist1'] = $proinfo->getProvinceCodes($edit[0][4]);
}
} else {
$form_creator->popArr['newID'] = $empworkex->getLastRecord($getArr['id']);
$form_creator->popArr['list'] = $countryinfo->getCountryCodes();
if ($object != null) {
$form_creator->popArr['txtEmpExpCompany'] = $object->txtEmpExpCompany;
$form_creator->popArr['txtEmpExpToDat'] = $object->txtEmpExpToDat;
$form_creator->popArr['txtEmpExpDesOnLev'] = $object->txtEmpExpDesOnLev;
$form_creator->popArr['txtEmpExpYears'] = $object->txtEmpExpYears;
$form_creator->popArr['chkEmpExpWorkRelFlag'] = $object->chkEmpExpWorkRelFlag;
$form_creator->popArr['txtEmpExpMonths'] = $object->txtEmpExpMonths;
$form_creator->popArr['txtEmpExpAdd1'] = $object->txtEmpExpAdd1;
$form_creator->popArr['txtEmpExpAcc'] = $object->txtEmpExpAcc;
$form_creator->popArr['txtEmpExpTelep'] = $object->txtEmpExpTelep;
$form_creator->popArr['txtEmpResLev'] = $object->txtEmpResLev;
$form_creator->popArr['txtEmpExpAchmnt'] = $object->txtEmpExpAchmnt;
$form_creator->popArr['txtEmpExpFromDat'] = $object->txtEmpExpFromDat;
$form_creator->popArr['txtEmpExpEmail'] = $object->txtEmpExpEmail;
$form_creator->popArr['txtEmpExpAdd2'] = $plis = $object->txtEmpExpAdd2;
$form_creator->popArr['txtEmpExpAdd3'] = $object->txtEmpExpAdd3;
$form_creator->popArr['txtEmpExpConPers'] = $object->txtEmpExpConPers;
$form_creator->popArr['plist2'] = $empinfo->getProvinceCodes($plis);
}
}
$form_creator->popArr['rset'] = $empworkex->getAssEmpWorkExp($getArr['id']);
break;
case 'QUA':
$form_creator->formPath = '/templates/hrfunct/hrempqual.php';
$empinfo = new EmpInfo();
$empqual = new EmpQualification();
$qualtyp = new QualificationType();
$qual = new Qualifications();
$form_creator->popArr['statlist'] = array('First Class', 'Second Class Upr.', 'Second Class Lwr.');
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['typlist'] = $qualtyp->getQualificationTypeCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $empqual->filterEmpQual($arr);
$form_creator->popArr['quallist'] = $qual->getAllQualifications();
} else {
if ($object != null) {
$form_creator->popArr['TypeCode'] = $object->TypeCode;
$form_creator->popArr['mship'] = $qual->getUnAssQualifications($getArr['id'], $object->TypeCode);
}
}
$form_creator->popArr['rset'] = $empqual->getAssEmpQual($getArr['id']);
$form_creator->popArr['allquallist'] = $qual->getAllQualifications();
break;
case 'QAS':
$form_creator->formPath = '/templates/hrfunct/hrempqualsub.php';
$empinfo = new EmpInfo();
$qual = new Qualifications();
$empqualsub = new EmpQualSubject();
$subinfo = new SubjectInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['qualDet'] = $qual->filterQualifications($getArr['QUA']);
$form_creator->popArr['sublistAll'] = $subinfo->getSubjectCodes($getArr['QUA']);
$form_creator->popArr['ratlist'] = $empqualsub->getRatGrds($getArr['QUA']);
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['QUA'];
$arr[2] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empqualsub->filterEmpQualSub($arr);
} else {
$form_creator->popArr['sublistUnAss'] = $subinfo->getUnAssSubjects($getArr['id'], $getArr['QUA']);
}
$arr[0] = $getArr['id'];
$arr[1] = $getArr['QUA'];
$form_creator->popArr['sublistAss'] = $empqualsub->getAssEmpQualSub($arr);
break;
case 'CBN':
$form_creator->formPath = '/templates/hrfunct/hrempcashben.php';
$empinfo = new EmpInfo();
$empcashben = new EmpCashBen();
$cashben = new CashBen();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['bfilter'] = array('Salary Point' => 1, 'Designation' => 2, 'Employee' => 3);
$form_creator->popArr['benlist'] = $cashben->getBenCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empcashben->filterEmpCashBen($arr);
}
$form_creator->popArr['cashbenAss'] = $empcashben->getAssEmpCashBen($getArr['id']);
$form_creator->popArr['cashbenUnAss'] = $empcashben->getUnAssEmpCashBen($getArr['id']);
if (isset($getArr['OBEN'])) {
$form_creator->popArr['cashbenOther'] = $cashben->getOthEmpCashBen($getArr['id']);
}
break;
case 'NBN':
$form_creator->formPath = '/templates/hrfunct/hrempnoncashben.php';
$empinfo = new EmpInfo();
$empnoncashben = new EmpNonCashBen();
$noncashben = new NonCashBen();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['bfilter'] = array('Salary Point' => 1, 'Designation' => 2, 'Employee' => 3);
$form_creator->popArr['benlist'] = $noncashben->getBenCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empnoncashben->filterEmpNonCashBen($arr);
}
$form_creator->popArr['cashbenAss'] = $empnoncashben->getAssEmpNonCashBen($getArr['id']);
$form_creator->popArr['cashbenUnAss'] = $empnoncashben->getUnAssEmpNonCashBen($getArr['id']);
if (isset($getArr['OBEN'])) {
$form_creator->popArr['cashbenOther'] = $noncashben->getOthEmpNonCashBen($getArr['id']);
}
break;
case 'ESS':
case 'EMP':
$form_creator->formPath = '/templates/hrfunct/hrEmpMain.php';
//hremp.php';
$form_creator->popArr['arrMStat'] = array('Unmarried', 'Married', 'Divorced', 'Others');
$empinfo = new EmpInfo();
$pport = new EmpPassPort();
$ddebit = new EmpDirectDebit();
$dep = new EmpDependents();
$econ = new EmpEmergencyCon();
$chi = new EmpChildren();
$attachment = new EmpAttach();
$countryinfo = new CountryInfo();
$porinfo = new ProvinceInfo();
$nationinfo = new NationalityInfo();
$location = new models_eimadmin_Location();
$distric = new DistrictInfo();
$jobtit = new JobTitle();
$depen = new EmpDependents();
$ethnicrace = new EthnicRace();
$eeojobcat = new EEOJobCat();
$emplan = new EmpLanguage();
$laninfo = new LanguageInfo();
$emplicen = new EmpLicenses();
$licen = new Licenses();
$empmem = new EmpMembership();
$memtype = new MembershipType();
$memshipinfo = new MembershipInfo();
$emprepto = new EmpRepTo();
$empskill = new EmpSkill();
$skill = new Skills();
$empworkex = new EmpWorkExp();
$empeducation = new EmpEducation();
$education = new Education();
$empTax = new EmpTax();
$form_creator->popArr['nation'] = $nationinfo->getNationCodes();
$form_creator->popArr['loc'] = $location->getLocCodes();
$form_creator->popArr['cntlist'] = $countryinfo->getCountryCodes();
$form_creator->popArr['ethRace'] = $ethnicrace->getEthnicRaceCodes();
$form_creator->popArr['eeojobcat'] = $eeojobcat->getEEOJobCatCodes();
$form_creator->popArr['jobtit'] = $jobtit->getJobTit();
$form_creator->popArr['hier'] = isset($res) ? $res : false;
$form_creator->popArr['cntlist'] = $countrylist = $countryinfo->getCountryCodes();
$form_creator->popArr['ppcntlist'] = $countrylist;
$form_creator->popArr['customFieldList'] = CustomFields::getCustomFieldList();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $empinfo->getLastId();
if ($object != null) {
$form_creator->popArr['ctlist'] = $corptit->getCorpTitlesEmpInfo($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $des->getDesEmpInfo($object->cmbCorpTit);
$form_creator->popArr['plist'] = $porinfo->getProvinceCodes($object->cmbTaxCountry);
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($object->cmbPermProvince);
if (isset($postArr['cmbJobTitle'])) {
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($postArr['cmbJobTitle'], 'JOB', 'allEmpStat');
}
$form_creator->popArr['ethRace'] = $ethnicrace->getEthnicRaceCodes($object->cmbEthnicRace);
}
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editTaxInfo'] = $empTax->getEmployeeTaxInfo($getArr['id']);
$form_creator->popArr['usStateList'] = $porinfo->getProvinceCodes('US');
$form_creator->popArr['empDDAss'] = $ddebit->getEmployeeDirectDebit($getArr['id']);
if (isset($getArr['DDSEQ'])) {
$form_creator->popArr['editDDForm'] = $ddebit->getDirectDebit($getArr['id'], $getArr['DDSEQ']);
}
$form_creator->popArr['editMainArr'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['editPersArr'] = $empinfo->filterEmpPers($getArr['id']);
$form_creator->popArr['editJobInfoArr'] = $empJobInfo = $empinfo->filterEmpJobInfo($getArr['id']);
$form_creator->popArr['editCustomInfoArr'] = $empCustomInfo = $empinfo->filterEmpCustomInfo($getArr['id']);
$view_controller = new ViewController();
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($empJobInfo[0][2], 'JOB', 'allEmpStat');
$empJobTitle = $empJobInfo[0][2];
if (isset($postArr['cmbJobTitle'])) {
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($postArr['cmbJobTitle'], 'JOB', 'allEmpStat');
$empJobTitle = $postArr['cmbJobTitle'];
}
if (CommonFunctions::isValidId($empJobTitle, 'JOB')) {
$empJobSpec = $view_controller->getJobSpecForJob($empJobTitle);
} else {
$empJobSpec = null;
}
$form_creator->popArr['jobSpec'] = $empJobSpec;
$jobTitleHistory = new JobTitleHistory();
$form_creator->popArr['jobTitleHistory'] = $jobTitleHistory->getHistory($getArr['id']);
$empDivisionHistory = new SubDivisionHistory();
$form_creator->popArr['subDivisionHistory'] = $empDivisionHistory->getHistory($getArr['id']);
$locationHistory = new LocationHistory();
$form_creator->popArr['locationHistory'] = $locationHistory->getHistory($getArr['id']);
$form_creator->popArr['assignedlocationList'] = EmpLocation::getEmpLocations($getArr['id']);
$form_creator->popArr['availablelocationList'] = EmpLocation::getUnassignedLocations($getArr['id']);
$form_creator->popArr['editPermResArr'] = $edit = $editPermRes = $empinfo->filterEmpContact($getArr['id']);
$form_creator->popArr['provlist'] = $porinfo->getProvinceCodes($edit[0][4]);
$form_creator->popArr['citylist'] = $distric->getDistrictCodes($edit[0][5]);
$form_creator->popArr['empPPAss'] = $pport->getAssEmpPP($getArr['id']);
$form_creator->popArr['empDepAss'] = $dep->getAssEmpDep($getArr['id']);
$form_creator->popArr['empECAss'] = $econ->getAssEmpEC($getArr['id']);
$form_creator->popArr['empChiAss'] = $chi->getAssEmpChi($getArr['id']);
$form_creator->popArr['empAttAss'] = $attachment->getAssEmpAtt($getArr['id']);
$form_creator->popArr['empDpAss'] = $depen->getAssEmpDep($getArr['id']);
$form_creator->popArr['newPPID'] = $pport->getLastRecord($getArr['id']);
if (isset($getArr['PPSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['PPSEQ'];
$form_creator->popArr['editPPForm'] = $pport->filterEmpPP($arr);
}
$form_creator->popArr['newECID'] = $econ->getLastRecord($getArr['id']);
if (isset($getArr['ECSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['ECSEQ'];
$form_creator->popArr['editECForm'] = $econ->filterEmpEC($arr);
}
$form_creator->popArr['newDepID'] = $dep->getLastRecord($getArr['id']);
if (isset($getArr['depSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['depSEQ'];
$form_creator->popArr['editDepForm'] = $dep->filterEmpDep($arr);
}
$form_creator->popArr['newCID'] = $chi->getLastRecord($getArr['id']);
if (isset($getArr['CHSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['CHSEQ'];
$form_creator->popArr['editChiForm'] = $chi->filterEmpChi($arr);
}
if (isset($getArr['ATTACH'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['ATTACH'];
$form_creator->popArr['editAttForm'] = $attachment->filterEmpAtt($arr);
}
$form_creator->popArr['lantype'] = array('Writing' => 1, 'Speaking' => 2, 'Reading' => 3);
$form_creator->popArr['grdcodes'] = array('Poor' => 1, 'Basic' => 2, 'Good' => 3, 'Mother Tongue' => 4);
$form_creator->popArr['lanlist'] = $lanlist = $laninfo->getLang();
if (isset($getArr['lanSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['lanSEQ'];
$arr[2] = $getArr['lanFLU'];
$form_creator->popArr['editLanArr'] = $emplan->filterEmpLang($arr);
}
$form_creator->popArr['rsetLang'] = $emplan->getAssEmpLang($getArr['id']);
$form_creator->popArr['allLicenlist'] = $licenlist = $licen->getLicensesCodes();
$form_creator->popArr['unassLicenlist'] = $licen->getUnAssLicensesCodes($getArr['id']);
if (isset($getArr['LIC'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['LIC'];
$form_creator->popArr['editLicenseArr'] = $emplicen->filterEmpLicenses($arr);
}
$form_creator->popArr['rsetLicense'] = $emplicen->getAssEmpLicenses($getArr['id']);
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
if (isset($getArr['MEM'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['MEM'];
$arr[2] = $getArr['MTP'];
$form_creator->popArr['editMembershipArr'] = $edit = $empmem->filterEmpMembership($arr);
$form_creator->popArr['mship'] = $memshipinfo->getMembershipCodes($edit[0][2]);
}
$form_creator->popArr['rsetMembership'] = $empmem->getAssEmpMembership($getArr['id']);
$form_creator->popArr['mshipAll'] = $memshipinfo->getAllMembershipCodes();
$empbassal = new EmpBasSalary();
$currTyp = new CurrencyTypes();
$jobtit = new JobTitle();
$salgradelist = new SalaryGrades();
$form_creator->popArr['salgradelist'] = $salgradelist->getSalGrades(true);
$empdet = $empinfo->filterEmpJobInfo($getArr['id']);
$jt = $jobtit->filterJobTitles($empdet[0][2]);
$form_creator->popArr['payPeriodList'] = PayPeriod::getPayPeriodList();
$form_creator->popArr['salGrd'] = $salGrd = $empbassal->getEmpSalGrade($getArr['id']);
if (isset($getArr['PAY'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['PAY'];
$arr[2] = $getArr['CUR'];
$form_creator->popArr['editPaymentArr'] = $edit = $empbassal->filterEmpBasSal($arr);
$form_creator->popArr['salGrd'] = $salGrd = $edit[0][1];
$form_creator->popArr['currlist'] = $empbassal->getCurrCodes($edit[0][1]);
}
$form_creator->popArr['unAssCurrList'] = $empbassal->getUnAssCurrCodes($salGrd, $getArr['id']);
$form_creator->popArr['rsetPayment'] = $empbassal->getAssEmpBasSal($getArr['id']);
$form_creator->popArr['currAlllist'] = $currTyp->getAllCurrencyCodes();
$form_creator->popArr['suprset'] = $emprepto->getEmpSup($getArr['id']);
$form_creator->popArr['empname'] = $empinfo->getEmpInfo();
$form_creator->popArr['subrset'] = $emprepto->getEmpSub($getArr['id']);
if (isset($getArr['editIDSup'])) {
$arr[0] = $getArr['editIDSup'];
$arr[1] = $getArr['id'];
$arr[2] = $getArr['RepMethod'];
$form_creator->popArr['editIDSupInfo'] = $emprepto->filterEmpRepTo($arr);
}
if (isset($getArr['editIDSub'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editIDSub'];
$arr[2] = $getArr['RepMethod'];
$form_creator->popArr['editIDSubInfo'] = $emprepto->filterEmpRepTo($arr);
}
$form_creator->popArr['allSkilllist'] = $skill->getSkillCodes();
$form_creator->popArr['uskilllist'] = $skill->getUnAssSkillCodes($getArr['id']);
if (isset($getArr['SKILL'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['SKILL'];
$form_creator->popArr['editSkillArr'] = $empskill->filterEmpSkill($arr);
}
$form_creator->popArr['rsetSkill'] = $empskill->getAssEmpSkill($getArr['id']);
$form_creator->popArr['newWrkExpID'] = $empworkex->getLastRecord($getArr['id']);
if (isset($getArr['WRKEXP'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['WRKEXP'];
$form_creator->popArr['editWrkExpArr'] = $edit = $empworkex->filterEmpWorkExp($arr);
}
$form_creator->popArr['rsetWrkExp'] = $empworkex->getAssEmpWorkExp($getArr['id']);
$form_creator->popArr['allEduCodes'] = $education->getListofEducation(0, '', 0);
$form_creator->popArr['unAssEduCodes'] = $empeducation->getUnAssEduCodes($getArr['id']);
if (isset($getArr['EDU'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['EDU'];
$form_creator->popArr['editEducationArr'] = $empeducation->filterEmpEducation($arr);
}
$form_creator->popArr['rsetEducation'] = $empeducation->getAssEmpEducation($getArr['id']);
if ($object != null) {
$form_creator->popArr['ctlist'] = $corptit->getCorpTitlesEmpInfo($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $des->getDesEmpInfo($object->cmbCorpTit);
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($object->cmbPermProvince);
$form_creator->popArr['brchlist'] = $brch->getUnAssBranchCodes($getArr['id'], $object->cmbBank);
$form_creator->popArr['ctlist'] = $empinfo->getCorpTitles($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $empinfo->getDes($object->cmbCorpTit);
$form_creator->popArr['resplist'] = $empinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $empinfo->getDistrictCodes($object->cmbPermProvince);
$form_creator->popArr['brchlist'] = $brch->getUnAssBranchCodes($getArr['id'], $object->cmbBank);
} else {
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($editPermRes[0][10]);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($editPermRes[0][11]);
}
$empconext = new EmpConExt();
$form_creator->popArr['newConExtID'] = $empconext->getLastRecord($getArr['id']);
if (isset($getArr['CONEXT'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['CONEXT'];
$form_creator->popArr['editConExtArr'] = $empconext->filterConExt($arr);
}
$form_creator->popArr['rsetConExt'] = $empconext->getAssConExt($getArr['id']);
}
break;
case 'REP':
$form_creator->formPath = '/templates/hrfunct/hremprepto.php';
$empinfo = new EmpInfo();
$emprepto = new EmpRepTo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['suprset'] = $emprepto->getEmpSup($getArr['id']);
$form_creator->popArr['empname'] = $empinfo->getEmpInfo();
$form_creator->popArr['subrset'] = $emprepto->getEmpSub($getArr['id']);
if (isset($getArr['editIDSup'])) {
$arr[0] = $getArr['editIDSup'];
$arr[1] = $getArr['id'];
$arr[2] = $getArr['repmethod'];
$form_creator->popArr['editIDSupInfo'] = $emprepto->filterEmpRepTo($arr);
}
if (isset($getArr['editIDSub'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editIDSub'];
$arr[2] = $getArr['repmethod'];
$form_creator->popArr['editIDSubInfo'] = $emprepto->filterEmpRepTo($arr);
}
break;
case 'SKI':
$form_creator->formPath = '/templates/hrfunct/hrempskill.php';
$empinf = new EmpInfo();
$empskill = new EmpSkill();
$skill = new Skills();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['allSkilllist'] = $skill->getSkillCodes();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $empskill->filterEmpSkill($arr);
} else {
$form_creator->popArr['uskilllist'] = $skill->getUnAssSkillCodes($getArr['id']);
}
$form_creator->popArr['rsets'] = $empskill->getAssEmpSkill($getArr['id']);
break;
case 'LIC':
$form_creator->formPath = '/templates/hrfunct/hremplicenses.php';
$empinf = new EmpInfo();
$emplicen = new EmpLicenses();
$licen = new Licenses();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['allLicenlist'] = $licenlist = $licen->getLicensesCodes();
$form_creator->popArr['unassLicenlist'] = $licen->getUnAssLicensesCodes($getArr['id']);
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $emplicen->filterEmpLicenses($arr);
}
$form_creator->popArr['rsets'] = $emplicen->getAssEmpLicenses($getArr['id']);
break;
}
$form_creator->display();
}
function page1($employee_id)
{
$this->load->helper('settings');
$this->load->library('fpdf');
//define('FPDF_FONTPATH',$this->config->item('fonts_path'));
$this->load->library('fpdi');
//$this->load->model('Personal_Info');
//Get personal info
//$pi = $this->Personal_Info->get_personal_info($employee_id);
$pi = new Personal();
$pi->get_by_employee_id($employee_id);
//print_r($personal_info);
// initiate FPDI
$pdf = new FPDI('P', 'mm', 'Legal');
// add a page
$pdf->AddPage();
// set the sourcefile
$pdf->setSourceFile('dtr/template/pds/page1.pdf');
// import page 1
$tplIdx = $pdf->importPage(1);
// use the imported page and place it at point 10,10 with a width of 100 mm
$pdf->useTemplate($tplIdx, 1, 1, 210);
// now write some text above the imported page
$pdf->SetFont('Arial');
$pdf->SetTextColor(0, 0, 0);
/*******************************
*START PERSONAL INFORMATION ==
******************************/
$split[0] = '';
$split[1] = '';
$split[2] = '';
$split[3] = '';
$split[4] = '';
$split[5] = '';
$split[6] = '';
$split[7] = '';
$split[8] = '';
$split[9] = '';
$split[10] = '';
$split[11] = '';
$split[12] = '';
$split[13] = '';
$split[14] = '';
$split[15] = '';
$split[16] = '';
$split[17] = '';
$split[18] = '';
$split[19] = '';
$split[20] = '';
$split[21] = '';
$split[22] = '';
$split[23] = '';
$split[24] = '';
$split[25] = '';
$split[26] = '';
$split[27] = '';
$split[28] = '';
$split[29] = '';
//$pdf->MultiCell(0,3,"hello this is a sample \nlong text with line break" ,'',1,'L',false);
//$pdf->MultiCell(0,3,"hello this is a sample \nlong text with line break" ,'',1,'L',false);
//$pdf->MultiCell(0,3,"hello this is a sample \nlong text with line break" ,'',1,'L',false);
$this->load->helper('text');
//$pdf->MultiCell(0,3,word_wrap("hello this is a sample nlong text with line break", 15) ,'',1,'L',false);
$split = str_split($pi->lname);
// Write something ==LAST NAME =========
$pdf->SetXY(39, 53);
$pdf->Write(0, $split[0]);
$pdf->SetX(44);
$pdf->Write(0, $split[1]);
$pdf->SetX(49);
$pdf->Write(0, $split[2]);
$pdf->SetX(54);
$pdf->Write(0, $split[3]);
$pdf->SetX(60);
$pdf->Write(0, $split[4]);
$pdf->SetX(65);
$pdf->Write(0, $split[5]);
$pdf->SetX(70);
$pdf->Write(0, $split[6]);
$pdf->SetX(75);
$pdf->Write(0, $split[7]);
$pdf->SetX(81);
$pdf->Write(0, $split[8]);
$pdf->SetX(86);
$pdf->Write(0, $split[9]);
$pdf->SetX(91);
$pdf->Write(0, $split[10]);
$pdf->SetX(96);
$pdf->Write(0, $split[11]);
$pdf->SetX(101);
$pdf->Write(0, $split[12]);
$pdf->SetX(106);
$pdf->Write(0, $split[13]);
$pdf->SetX(111);
$pdf->Write(0, $split[14]);
$pdf->SetX(116);
$pdf->Write(0, $split[15]);
$pdf->SetX(121);
$pdf->Write(0, $split[16]);
$pdf->SetX(126);
$pdf->Write(0, $split[17]);
$pdf->SetX(131);
$pdf->Write(0, $split[18]);
$pdf->SetX(137);
$pdf->Write(0, $split[19]);
$pdf->SetX(142);
$pdf->Write(0, $split[20]);
$pdf->SetX(147);
$pdf->Write(0, $split[21]);
$pdf->SetX(152);
$pdf->Write(0, $split[22]);
$pdf->SetX(157);
$pdf->Write(0, $split[23]);
$pdf->SetX(163);
$pdf->Write(0, $split[24]);
$pdf->SetX(168);
$pdf->Write(0, $split[25]);
$pdf->SetX(173);
$pdf->Write(0, $split[26]);
$pdf->SetX(178);
$pdf->Write(0, $split[27]);
$pdf->SetX(183);
$pdf->Write(0, $split[28]);
$pdf->SetX(188);
$pdf->Write(0, $split[29]);
// line break
//=========FIRST NAME====
$split = str_split($pi->fname);
$pdf->Ln(6);
$pdf->SetX(39);
$pdf->Write(0, $split[0]);
$pdf->SetX(44);
$pdf->Write(0, $split[1]);
$pdf->SetX(49);
$pdf->Write(0, $split[2]);
$pdf->SetX(54);
$pdf->Write(0, $split[3]);
$pdf->SetX(60);
$pdf->Write(0, $split[4]);
$pdf->SetX(65);
$pdf->Write(0, $split[5]);
$pdf->SetX(70);
$pdf->Write(0, $split[6]);
$pdf->SetX(75);
$pdf->Write(0, $split[7]);
$pdf->SetX(81);
$pdf->Write(0, $split[8]);
$pdf->SetX(86);
$pdf->Write(0, $split[9]);
$pdf->SetX(91);
$pdf->Write(0, $split[10]);
$pdf->SetX(96);
$pdf->Write(0, $split[11]);
$pdf->SetX(101);
$pdf->Write(0, $split[12]);
$pdf->SetX(106);
$pdf->Write(0, $split[13]);
$pdf->SetX(111);
$pdf->Write(0, $split[14]);
$pdf->SetX(116);
$pdf->Write(0, $split[15]);
$pdf->SetX(121);
$pdf->Write(0, $split[16]);
$pdf->SetX(126);
$pdf->Write(0, $split[17]);
$pdf->SetX(131);
$pdf->Write(0, $split[18]);
$pdf->SetX(137);
$pdf->Write(0, $split[19]);
$pdf->SetX(142);
$pdf->Write(0, $split[20]);
$pdf->SetX(147);
$pdf->Write(0, $split[21]);
$pdf->SetX(152);
$pdf->Write(0, $split[22]);
$pdf->SetX(157);
$pdf->Write(0, $split[23]);
$pdf->SetX(163);
$pdf->Write(0, $split[24]);
$pdf->SetX(168);
$pdf->Write(0, $split[25]);
$pdf->SetX(173);
$pdf->Write(0, $split[26]);
$pdf->SetX(178);
$pdf->Write(0, $split[27]);
$pdf->SetX(183);
$pdf->Write(0, $split[28]);
$pdf->SetX(188);
$pdf->Write(0, $split[29]);
//======== MNAME
$split = str_split($pi->mname);
// line break
$pdf->Ln(6);
$pdf->SetX(39);
$pdf->Write(0, $split[0]);
$pdf->SetX(44);
$pdf->Write(0, $split[1]);
$pdf->SetX(49);
$pdf->Write(0, $split[2]);
$pdf->SetX(54);
$pdf->Write(0, $split[3]);
$pdf->SetX(60);
$pdf->Write(0, $split[4]);
$pdf->SetX(65);
$pdf->Write(0, $split[5]);
$pdf->SetX(70);
$pdf->Write(0, $split[6]);
$pdf->SetX(75);
$pdf->Write(0, $split[7]);
$pdf->SetX(81);
$pdf->Write(0, $split[8]);
$pdf->SetX(86);
$pdf->Write(0, $split[9]);
$pdf->SetX(91);
$pdf->Write(0, $split[10]);
$pdf->SetX(96);
$pdf->Write(0, $split[11]);
$pdf->SetX(101);
$pdf->Write(0, $split[12]);
$pdf->SetX(106);
$pdf->Write(0, $split[13]);
$pdf->SetX(111);
$pdf->Write(0, $split[14]);
$pdf->SetX(116);
$pdf->Write(0, $split[15]);
$pdf->SetX(121);
$pdf->Write(0, $split[16]);
$pdf->SetX(126);
$pdf->Write(0, $split[17]);
$pdf->SetX(131);
$pdf->Write(0, $split[18]);
$pdf->SetX(137);
$pdf->Write(0, $split[19]);
$pdf->SetX(142);
$pdf->Write(0, $split[20]);
$pdf->SetX(147);
$pdf->Write(0, $split[21]);
$pdf->SetX(152);
$pdf->Write(0, $split[22]);
$pdf->SetX(157);
$pdf->Write(0, $split[23]);
$pdf->SetX(163);
$pdf->Write(0, $split[24]);
$pdf->SetX(168);
$pdf->Write(0, $split[25]);
$pdf->SetX(173);
$pdf->Write(0, $split[26]);
$pdf->SetX(178);
$pdf->Write(0, $split[27]);
$pdf->SetX(183);
$pdf->Write(0, $split[28]);
$pdf->SetX(188);
$pdf->Write(0, $split[29]);
$pdf->SetX(189);
$pdf->Write(0, $pi->extension);
$date = $pi->birth_date;
list($year, $month, $day) = explode('-', $date);
$pdf->Ln(6);
$pdf->SetX(67);
$pdf->Write(0, $month . '-' . $day . '-' . $year);
$res_address = splitstroverflow($pi->res_address, 30);
$pdf->SetX(126);
$pdf->Write(0, $res_address[0]);
$pdf->Ln(4);
$pdf->SetX(39);
$pdf->Write(0, $pi->birth_place);
$pdf->SetX(126);
$pdf->Write(0, $res_address[1]);
$pdf->Ln(5);
if ($pi->sex == 'M') {
$setx = 41.5;
}
if ($pi->sex == 'F') {
$setx = 58;
}
$pdf->SetX($setx);
$pdf->Write(0, 'X');
if ($pi->civil_status == 1) {
$pdf->SetXY(41.5, 85);
$pdf->Write(0, 'X');
}
if ($pi->civil_status == 2) {
$pdf->SetXY(41.5, 89);
$pdf->Write(0, 'X');
}
if ($pi->civil_status == 3) {
$pdf->SetXY(41.5, 94.5);
$pdf->Write(0, 'X');
}
if ($pi->civil_status == 4) {
$pdf->SetXY(64, 85);
$pdf->Write(0, 'X');
}
if ($pi->civil_status == 5) {
$pdf->SetXY(64, 89);
$pdf->Write(0, 'X');
}
if ($pi->civil_status == 6) {
$pdf->SetXY(64, 94.5);
$pdf->Write(0, 'X');
}
//citizeship
$pdf->SetXY(39, 103);
$pdf->Write(0, $pi->citizenship);
$pdf->Ln(5.2);
$pdf->SetX(39);
$pdf->Write(0, $pi->height);
$pdf->Ln(5.2);
$pdf->SetX(39);
$pdf->Write(0, $pi->weight);
$pdf->Ln(5.2);
$pdf->SetX(39);
$pdf->Write(0, $pi->blood_type);
$pdf->Ln(4);
$pdf->SetX(39);
$pdf->Write(0, $pi->gsis);
$pdf->Ln(5);
$pdf->SetX(39);
$pdf->Write(0, $pi->pagibig);
$pdf->Ln(4);
$pdf->SetX(39);
$pdf->Write(0, $pi->philhealth);
$pdf->Ln(5);
$pdf->SetX(39);
$pdf->Write(0, $pi->sss);
$pdf->SetXY(126, 85);
$pdf->Write(0, $pi->res_zip);
$pdf->Ln(5);
$pdf->SetX(126);
$pdf->Write(0, $pi->res_tel);
$pdf->Ln(5);
$pdf->SetX(126);
$permanent_address = splitstroverflow($pi->permanent_address, 30);
$pdf->Write(0, $permanent_address[0]);
$pdf->Ln(4);
$pdf->SetX(126);
$pdf->Write(0, $permanent_address[1]);
$pdf->Ln(15);
$pdf->SetX(126);
$pdf->Write(0, $pi->permanent_zip);
$pdf->Ln(4);
$pdf->SetX(126);
$pdf->Write(0, $pi->permanent_tel);
$pdf->Ln(4.3);
$pdf->SetX(126);
$pdf->Write(0, $pi->email);
$pdf->Ln(4.9);
$pdf->SetX(126);
$pdf->Write(0, $pi->cp);
$pdf->Ln(4.3);
$pdf->SetX(126);
$pdf->Write(0, $pi->agency_employee_no);
$pdf->Ln(4.3);
$pdf->SetX(126);
$pdf->Write(0, $pi->tin);
/*******************************
*END PERSONAL INFORMATION =====
******************************/
//======================================================================
/*******************************
*START FAMILY BACK GROUND=======
******************************/
//Get family background
//$fb = $this->Family_Background->get_family_background($employee_id);
$fb = new Family();
$fb->get_by_employee_id($employee_id);
$pdf->SetXY(39, 146);
$pdf->Write(0, $fb->spouse_lname);
$pdf->Ln(4.3);
$pdf->SetX(39);
$pdf->Write(0, $fb->spouse_fname);
$pdf->Ln(4.3);
$pdf->SetX(39);
$pdf->Write(0, $fb->spouse_mname);
$pdf->Ln(5);
$pdf->SetX(39);
$pdf->Write(0, $fb->spouse_occupation);
$pdf->Ln(5);
$pdf->SetX(39);
$pdf->Write(0, $fb->spouse_employer);
$pdf->Ln(5);
$pdf->SetX(39);
$pdf->Write(0, $fb->spouse_biz_ad);
$pdf->Ln(5);
$pdf->SetX(39);
$pdf->Write(0, $fb->spouse_tel);
$pdf->Ln(9);
$pdf->SetX(57);
$pdf->Write(0, $fb->father_lname);
$pdf->Ln(4.5);
$pdf->SetX(57);
$pdf->Write(0, $fb->father_fname);
$pdf->Ln(4.5);
$pdf->SetX(57);
$pdf->Write(0, $fb->father_mname);
$pdf->Ln(4.5);
$pdf->SetX(57);
$pdf->Write(0, $fb->mother_lname);
$pdf->Ln(4.5);
$pdf->SetX(57);
$pdf->Write(0, $fb->mother_fname);
$pdf->Ln(4.5);
$pdf->SetX(57);
$pdf->Write(0, $fb->mother_mname);
/*******************************
*END FAMILY BACK GROUND=======
******************************/
//=============================================================================
/*******************************
*START CHILDREN================
******************************/
//$children = $this->Children->get_child($employee_id);
$children = new Children();
$children->order_by('birth_date');
$children->get_by_employee_id($employee_id);
$pdf->SetXY(110, 145);
$i = 1;
$pdf->SetFont('Arial', '', 10);
foreach ($children as $child) {
if ($i == 7 || $i == 9 || $i == 11) {
$pdf->Ln(4.5);
} else {
$pdf->Ln(5);
}
$pdf->SetX(110);
$pdf->Write(0, $child->children);
$date = $child->birth_date;
list($year, $month, $day) = explode('-', $date);
$pdf->SetX(170);
$pdf->Write(0, $month . '/' . $day . '/' . $year);
$i++;
}
/*******************************
*END CHILDREN==================
******************************/
//=====================================================================
/*******************************
*START EDUC==================
******************************/
$e = new Education();
//$educs = $this->Educational_Background->get_educ($employee_id, $level = 1);
$educs = $e->get_single_educ($employee_id, $level = 1);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(39, 233);
//
/*******************************
*END EDUC==================
******************************/
foreach ($educs as $educ) {
$sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
$sch = explode("|", $sch);
//$degree = wordwrap($educ->degree_course, 15, "|");
$degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
$degree = explode("|", $degree);
$pdf->Write(0, $sch[0]);
$pdf->SetX(78);
$pdf->Write(0, $degree[0]);
$pdf->SetX(107);
$pdf->Write(0, $educ->year_graduated);
$pdf->SetX(130);
$pdf->Write(0, $educ->highest_grade);
$pdf->SetX(150);
$pdf->Write(0, $educ->attend_from);
$pdf->SetX(163);
$pdf->Write(0, $educ->attend_to);
$pdf->SetX(177);
$pdf->Write(0, $educ->scholarship);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[1]);
$pdf->SetX(78);
$pdf->Write(0, $degree[1]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[2]);
$pdf->SetX(78);
$pdf->Write(0, $degree[2]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[3]);
$pdf->SetX(78);
$pdf->Write(0, $degree[3]);
}
//secondary
// $educs = $this->Educational_Background->get_educ($employee_id, $level = 2);
$educs = $e->get_single_educ($employee_id, $level = 2);
$pdf->SetXY(39, 246);
foreach ($educs as $educ) {
//$sch = wordwrap($educ->school_name, 23, "|");
$sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
$sch = explode("|", $sch);
//$degree = wordwrap($educ->degree_course, 15, "|");
$degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
$degree = explode("|", $degree);
$pdf->Write(0, $sch[0]);
$pdf->SetX(78);
$pdf->Write(0, $degree[0]);
$pdf->SetX(107);
$pdf->Write(0, $educ->year_graduated);
$pdf->SetX(130);
$pdf->Write(0, $educ->highest_grade);
$pdf->SetX(150);
$pdf->Write(0, $educ->attend_from);
$pdf->SetX(163);
$pdf->Write(0, $educ->attend_to);
$pdf->SetX(177);
$pdf->Write(0, $educ->scholarship);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[1]);
$pdf->SetX(78);
$pdf->Write(0, $degree[1]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[2]);
$pdf->SetX(78);
$pdf->Write(0, $degree[2]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[3]);
$pdf->SetX(78);
$pdf->Write(0, $degree[3]);
}
//vocational
// $educs = $this->Educational_Background->get_educ($employee_id, $level = 3);
$educs = $e->get_single_educ($employee_id, $level = 3);
$pdf->SetXY(39, 259);
foreach ($educs as $educ) {
//$sch = wordwrap($educ->school_name, 23, "|");
$sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
$sch = explode("|", $sch);
//$degree = wordwrap($educ->degree_course, 15, "|");
$degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
$degree = explode("|", $degree);
$pdf->Write(0, $sch[0]);
$pdf->SetX(78);
$pdf->Write(0, $degree[0]);
$pdf->SetX(107);
$pdf->Write(0, $educ->year_graduated);
$pdf->SetX(130);
$pdf->Write(0, $educ->highest_grade);
$pdf->SetX(150);
$pdf->Write(0, $educ->attend_from);
$pdf->SetX(163);
$pdf->Write(0, $educ->attend_to);
$pdf->SetX(177);
$pdf->Write(0, $educ->scholarship);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[1]);
$pdf->SetX(78);
$pdf->Write(0, $degree[1]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[2]);
$pdf->SetX(78);
$pdf->Write(0, $degree[2]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[3]);
$pdf->SetX(78);
$pdf->Write(0, $degree[3]);
}
//college
// $educs = $this->Educational_Background->get_educ($employee_id, $level = 4);
$educs = $e->get_single_educ($employee_id, $level = 4);
$pdf->SetXY(39, 274);
foreach ($educs as $educ) {
//$sch = wordwrap($educ->school_name, 23, "|");
$sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
$sch = explode("|", $sch);
//$degree = wordwrap($educ->degree_course, 15, "|");
$degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
$degree = explode("|", $degree);
$pdf->Write(0, $sch[0]);
$pdf->SetX(78);
$pdf->Write(0, $degree[0]);
$pdf->SetX(107);
$pdf->Write(0, $educ->year_graduated);
$pdf->SetX(130);
$pdf->Write(0, $educ->highest_grade);
$pdf->SetX(150);
$pdf->Write(0, $educ->attend_from);
$pdf->SetX(163);
$pdf->Write(0, $educ->attend_to);
$pdf->SetX(177);
$pdf->Write(0, $educ->scholarship);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[1]);
$pdf->SetX(78);
$pdf->Write(0, $degree[1]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[2]);
$pdf->SetX(78);
$pdf->Write(0, $degree[2]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[3]);
$pdf->SetX(78);
$pdf->Write(0, $degree[3]);
}
//graduate studies
//$educs = $this->Educational_Background->get_educ($employee_id, $level = 5);
$educs = $e->get_single_educ($employee_id, $level = 5);
$pdf->SetXY(39, 290);
foreach ($educs as $educ) {
//$sch = wordwrap($educ->school_name, 23, "|");
$sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
$sch = explode("|", $sch);
//$degree = wordwrap($educ->degree_course, 15, "|");
$degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
$degree = explode("|", $degree);
$pdf->Write(0, $sch[0]);
$pdf->SetX(78);
$pdf->Write(0, $degree[0]);
$pdf->SetX(107);
$pdf->Write(0, $educ->year_graduated);
$pdf->SetX(130);
$pdf->Write(0, $educ->highest_grade);
$pdf->SetX(150);
$pdf->Write(0, $educ->attend_from);
$pdf->SetX(163);
$pdf->Write(0, $educ->attend_to);
$pdf->SetX(177);
$pdf->Write(0, $educ->scholarship);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[1]);
$pdf->SetX(78);
$pdf->Write(0, $degree[1]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[2]);
$pdf->SetX(78);
$pdf->Write(0, $degree[2]);
$pdf->Ln(3);
$pdf->SetX(39);
$pdf->Write(0, $sch[3]);
$pdf->SetX(78);
$pdf->Write(0, $degree[3]);
}
// Output
//$pdf->Output('resources/pdfs/archives/page1_'.$employee_id.'.pdf', 'F');
$pdf->Output('dtr/template/pds/page1_' . $employee_id . '.pdf', 'F');
$this->pds[] = 'dtr/template/pds/page1_' . $employee_id . '.pdf';
//$this->pds[] = 'resources/pdfs/archives/page1_'.$employee_id.'.pdf';
//header("location:".base_url()."resources/pdfs/archives/page1_".$employee_id.'.pdf');
}
<tr>
<td class="info"><a href="/JobFair/index.php/profile/student/user/<?php
echo $js->username;
?>
"><?php
echo $js->username;
?>
</a></td>
<td><?php
echo $js->first_name . " " . $js->last_name;
?>
</td>
<td><?php
$educ = Education::model()->findByAttributes(array('FK_user_id' => $js->id));
$school = "";
if ($educ) {
$school = School::model()->findByAttributes(array('id' => $educ->FK_school_id))->name;
}
echo $school;
?>
</td>
<td class="info1">
<?php
$temp = StudentSkillMap::model()->findAllByAttributes(array('userid' => $js->id));
foreach ($temp as $one) {
echo Skillset::model()->findByAttributes(array('id' => $one->skillid))->name . " - ";
}
?>
<?php echo frmElements($fsPrivate); ?> </fieldset> <fieldset id="timekeeping"> <legend>Time Keeping</legend> <?php echo frmElements($fsTimeKeeping); ?> </fieldset> <?php $address = new ArcAddress(); $address->filter = "id_addr"; $address->id = $rec[0]["id_addr"]; $address->build(); $education = new Education(); $education->filter = "id_hr_emp"; $education->id = $rec[0]["id_hr_emp"]; $education->build(); $certification = new Certification(); $certification->filter = "id_hr_emp"; $certification->id = $rec[0]["id_hr_emp"]; $certification->build(); $insurance = new Insurance(); $insurance->filter = "id_hr_emp"; $insurance->id = $rec[0]["id_hr_emp"]; $insurance->build(); ?> </form> <script type="text/javascript">
<?php
include_once "../../../../../../libraries/aces/models/education.php";
// echo json_encode($filter);
$_POST['id'] = $_POST['id'];
$_POST['userid'] = $_POST['userid'];
$_POST['school'] = $_POST['school'];
$_POST['fieldofstudy'] = $_POST['fieldofstudy'];
$_POST['dateattendfrom'] = $_POST['dateattendfrom'];
$_POST['dateattendto'] = $_POST['dateattendto'];
$_POST['degree'] = $_POST['degree'];
$_POST['grade'] = $_POST['grade'];
$_POST['description'] = $_POST['description'];
$edu = new Education();
$data = $edu->update($_POST);
echo json_encode($data);
// echo json_encode($_POST);
// foreach($data as $edudata){
// echo json_encode($edudata);
// }
public function duplicatecvpage($cv_code)
{
$cv_old = Cv::where('cv_code', $cv_code)->first();
if ($cv_old->user_id != Auth::id()) {
return 'False';
}
$new_cv_name = $cv_old->cv_name . ' - Copy';
$cv = new Cv();
do {
$random = str_random(10);
$count = Cv::where('cv_code', $random)->count();
} while ($count != 0);
$cv->cv_code = $random;
if (Auth::check()) {
$cv->user_id = Auth::id();
}
$cv->cv_name = $new_cv_name;
$cv->user_id = $cv_old->user_id;
$cv->full_name = $cv_old->full_name;
$cv->phone_num = $cv_old->phone_num;
$cv->email = $cv_old->email;
$cv->website = $cv_old->website;
$cv->add_line1 = $cv_old->add_line1;
$cv->add_line2 = $cv_old->add_line2;
$cv->dob = $cv_old->dob;
$cv->marital_status = $cv_old->marital_status;
$cv->profile_image = $cv_old->profile_image;
$cv->sex = $cv_old->sex;
$cv->state_origin = $cv_old->state_origin;
$cv->religion = $cv_old->religion;
$cv->religion_text = $cv_old->religion_text;
$cv->show_profile_pic = $cv_old->show_profile_pic;
$cv->local_government = $cv_old->local_government;
$cv->save();
$new_cv_id = $cv->id;
// copying sections
$sections = Section::where('cv_id', $cv_old->id)->get();
foreach ($sections as $section) {
$section_new = new Section();
$section_new->cv_id = $new_cv_id;
$section_new->section_name = $section->section_name;
$section_new->type = $section->type;
$section_new->content = $section->content;
$section_new->default = $section->default;
$section_new->priority = $section->priority;
$section_new->save();
}
// copying educations
$educations = Education::where('cv_id', $cv_old->id)->get();
foreach ($educations as $education) {
$education_new = new Education();
$education_new->cv_id = $new_cv_id;
$education_new->coursename = $education->coursename;
$education_new->institutename = $education->institutename;
$education_new->add_line1 = $education->add_line1;
$education_new->add_line2 = $education->add_line2;
$education_new->startdate = $education->startdate;
$education_new->enddate = $education->enddate;
$education_new->otherinfo = $education->otherinfo;
$education_new->priority = $education->priority;
$education_new->save();
}
// copying languages
$languages = Language::where('cv_id', $cv_old->id)->get();
foreach ($languages as $language) {
$language_new = new Language();
$language_new->cv_id = $new_cv_id;
$language_new->language_id = $language->language_id;
$language_new->language_name = $language->language_name;
$language_new->ability_id = $language->ability_id;
$language_new->level_id = $language->level_id;
$language_new->priority = $language->priority;
$language_new->save();
}
// copying nysc
$nyscs = Nysc::where('cv_id', $cv_old->id)->get();
foreach ($nyscs as $nysc) {
$nysc_new = new Nysc();
$nysc_new->cv_id = $new_cv_id;
$nysc_new->year = $nysc->year;
$nysc_new->batch = $nysc->batch;
$nysc_new->ppa = $nysc->ppa;
$nysc_new->cd = $nysc->cd;
$nysc_new->otherinfo = $nysc->otherinfo;
$nysc_new->priority = $nysc->priority;
$nysc_new->save();
}
// copying work_exp
$work_exps = WorkExperience::where('cv_id', $cv_old->id)->get();
foreach ($work_exps as $work_exp) {
$work_exp_new = new WorkExperience();
$work_exp_new->cv_id = $new_cv_id;
$work_exp_new->title = $work_exp->title;
$work_exp_new->company = $work_exp->company;
$work_exp_new->location = $work_exp->location;
$work_exp_new->startdate = $work_exp->startdate;
$work_exp_new->enddate = $work_exp->enddate;
$work_exp_new->otherinfo = $work_exp->otherinfo;
$work_exp_new->priority = $work_exp->priority;
$work_exp_new->save();
}
return Redirect::back();
}
function delete()
{
$education = new Education();
$education->_delete($this->edu_id);
$this->session->set_flashdata('message', 'Education deleted.');
redirect('staffs/' . $this->staff_id . '/educations/index');
}
public function store()
{
// Get StudentID
// From student_id or Create New
// Create Registration
// Create Issue
// Create Education
// Create Placement
// Create Receivables
// Reductions
// Create Installment
try {
//DB::beginTransaction();
if (Input::get('student_id') == 0) {
// Create New Student
$student = new Student();
$student->name = Input::get('name');
$student->sex = Input::get('sex');
$student->birthplace = Input::get('birthplace');
$student->birthdate = date('Y-m-d', strtotime(Input::get('birthdate')));
$student->religion = Input::get('religion');
$student->address = Input::get('address');
$student->contact = Input::get('contact');
$student->email = Input::get('email');
if (Input::get('sex') == 'L') {
$student->photo = 'boy.png';
} else {
$student->photo = 'girl.png';
}
$student->father_name = Input::get('father_name');
$student->father_occupation = Input::get('father_occupation');
$student->father_address = Input::get('father_address');
$student->father_contact = Input::get('father_contact');
$student->father_email = Input::get('father_email');
$student->mother_name = Input::get('mother_name');
$student->mother_occupation = Input::get('mother_occupation');
$student->mother_address = Input::get('mother_address');
$student->mother_contact = Input::get('mother_contact');
$student->mother_email = Input::get('mother_email');
$student->save();
$id = $student->id;
} else {
$student = Student::find(Input::get('student_id'));
$student->name = Input::get('name');
$student->sex = Input::get('sex');
$student->birthplace = Input::get('birthplace');
$student->birthdate = date('Y-m-d', strtotime(Input::get('birthdate')));
$student->religion = Input::get('religion');
$student->address = Input::get('address');
$student->contact = Input::get('contact');
$student->email = Input::get('email');
if (Input::get('sex') == 'L') {
$student->photo = 'boy.png';
} else {
$student->photo = 'girl.png';
}
$student->father_name = Input::get('father_name');
$student->father_occupation = Input::get('father_occupation');
$student->father_address = Input::get('father_address');
$student->father_contact = Input::get('father_contact');
$student->father_email = Input::get('father_email');
$student->mother_name = Input::get('mother_name');
$student->mother_occupation = Input::get('mother_occupation');
$student->mother_address = Input::get('mother_address');
$student->mother_contact = Input::get('mother_contact');
$student->mother_email = Input::get('mother_email');
$student->save();
$id = $student->id;
}
// Create Registration Data
$registration = new Registration();
$registration->project_id = Auth::user()->curr_project_id;
$registration->location_id = Auth::user()->location_id;
$registration->student_id = $id;
$registration->classification_id = Input::get('classification');
$registration->base_id = Input::get('location');
$registration->registration_date = date('Y-m-d', strtotime(Input::get('registration_date')));
$registration->registration_cost = Input::get('fee');
$registration->recommender_type = Input::get('recommender_type');
$registration->recommender_id = Input::get('recommender_id');
$registration->employee_id = Input::get('employee');
$registration->save();
// Create Issue
$issue = new Issue();
$issue->project_id = Auth::user()->curr_project_id;
$issue->location_id = Auth::user()->location_id;
$issue->registration_id = $registration->id;
$issue->generation_id = Input::get('generation');
$issue->student_id = $id;
$issue->issue = Input::get('issue');
$issue->save();
//Create Education Data
if (Input::get('school') != '0') {
$education = new Education();
$education->project_id = Auth::user()->curr_project_id;
$education->issue_id = $issue->id;
$education->school_id = Input::get('school');
$education->generation_id = Input::get('generation');
$education->save();
}
// Receivables - Registration Costs
$receivable = new Receivable();
$receivable->project_id = Auth::user()->curr_project_id;
$receivable->location_id = Auth::user()->location_id;
$receivable->issue_id = $issue->id;
$receivable->registration_id = $registration->id;
$receivable->total = Input::get('total');
$receivable->billable = Input::get('billable');
$receivable->receivable = Input::get('receivables');
$receivable->balance = Input::get('billable');
if (Input::get('payment') == 0) {
$receivable->payment = 'Cash';
} else {
$receivable->payment = 'Installment';
}
$receivable->save();
$billable = Input::get('billable');
$payment = Input::get('payment');
if ((int) $payment > 0) {
// First Installment
$installment = new Installment();
$installment->project_id = Auth::user()->curr_project_id;
$installment->location_id = Auth::user()->location_id;
$installment->receivable_id = $receivable->id;
$installment->schedule = Input::get('registration_date');
$installment->total = $billable / $payment;
$installment->balance = $billable / $payment;
$installment->paid = 0;
$installment->save();
// Extracting Date
$dd = (int) substr(Input::get('registration_date'), 8, 2);
$mm = (int) substr(Input::get('registration_date'), 5, 2);
$yy = (int) substr(Input::get('registration_date'), 0, 4);
if ($dd > 25) {
$mm += 2;
if ($mm > 12) {
$new_mm = $mm - 12;
$yy += 1;
} else {
$new_mm = $mm;
}
} else {
$mm += 1;
if ($mm > 12) {
$new_mm = $mm - 12;
$yy += 1;
} else {
$new_mm = $mm;
}
}
for ($i = 2; $i <= $payment; $i++) {
$installment_date = $yy . '-' . str_pad($new_mm, 2, "0", STR_PAD_LEFT) . '-' . '05';
$installment = new Installment();
$installment->project_id = Auth::user()->curr_project_id;
$installment->location_id = Auth::user()->location_id;
$installment->receivable_id = $receivable->id;
$installment->schedule = date('Y-m-d', strtotime($installment_date));
$installment->total = $billable / $payment;
$installment->balance = $billable / $payment;
$installment->paid = 0;
$installment->save();
$new_mm += 1;
if ($new_mm > 12) {
$new_mm = $new_mm - 12;
$yy += 1;
}
}
}
// Placements
$courses = Input::get('course');
foreach ($courses as $key => $value) {
$course = explode("#", $value);
$placement = new Placement();
$placement->project_id = Auth::user()->curr_project_id;
$placement->location_id = Auth::user()->location_id;
$placement->registration_id = $registration->id;
$placement->issue_id = $issue->id;
$placement->course_id = $course[0];
$placement->save();
}
// Reductions - Discounts
$discounts = Input::get('discounts');
if ($discounts) {
foreach ($discounts as $key => $value) {
$discount = explode("#", $value);
$reduction = new Reduction();
$reduction->project_id = Auth::user()->curr_project_id;
$reduction->location_id = Auth::user()->location_id;
$reduction->registration_id = $registration->id;
$reduction->receivable_id = $receivable->id;
$reduction->reductable_type = 'Discount';
$reduction->reductable_id = $discount[0];
$reduction->save();
}
}
// Reductions - Promotions
$promotions = Input::get('promotions');
if ($promotions) {
foreach ($promotions as $key => $value) {
$promotion = explode("#", $value);
$reduction = new Reduction();
$reduction->project_id = Auth::user()->curr_project_id;
$reduction->location_id = Auth::user()->location_id;
$reduction->registration_id = $registration->id;
$reduction->receivable_id = $receivable->id;
$reduction->reductable_type = 'Promotion';
$reduction->reductable_id = $promotion[0];
$reduction->save();
}
}
// Reductions - Vouchers
$vouchers = Input::get('vouchers');
if ($vouchers) {
foreach ($vouchers as $key => $value) {
$voucher = explode("#", $value);
$reduction = new Reduction();
$reduction->project_id = Auth::user()->curr_project_id;
$reduction->location_id = Auth::user()->location_id;
$reduction->registration_id = $registration->id;
$reduction->receivable_id = $receivable->id;
$reduction->reductable_type = 'Voucher';
$reduction->reductable_id = $voucher[0];
$reduction->save();
}
}
// Reductions - Charges
$charges = Input::get('charges');
if ($charges) {
foreach ($charges as $key => $value) {
$charger = explode("#", $value);
$reduction = new Reduction();
$reduction->project_id = Auth::user()->curr_project_id;
$reduction->location_id = Auth::user()->location_id;
$reduction->registration_id = $registration->id;
$reduction->receivable_id = $receivable->id;
$reduction->reductable_type = 'Charge';
$reduction->reductable_id = $charger[0];
$reduction->save();
}
}
// Updating Student Timelines
$content = 'Bergabung menjadi Siswa One School ' . Auth::user()->location->name . 'untuk periode ' . Auth::user()->curr_project->name;
$timeline = new Timeline();
$timeline->project_id = Auth::user()->curr_project_id;
$timeline->location_id = Auth::user()->location_id;
$timeline->informable_type = 'Issue';
$timeline->informable_id = $issue->id;
$timeline->content = $content;
$timeline->save();
// Updating Employee Timeline
$content = 'Menerima Pendaftaran Siswa untuk periode ' . Auth::user()->curr_project->name;
$timeline = new Timeline();
$timeline->project_id = Auth::user()->curr_project_id;
$timeline->location_id = Auth::user()->location_id;
$timeline->informable_type = 'Employee';
$timeline->informable_id = Input::get('employee');
$timeline->content = $content;
$timeline->save();
//DB::commit();
return Response::json(array('status' => 'Succeed', 'registration_id' => $registration->id, 'issue_id' => $issue->id));
} catch (Exception $e) {
DB::rollback();
return Response::json(array('status' => 'Failed', 'error' => $e));
}
}
