231 lines
9.1 KiB
PHP
231 lines
9.1 KiB
PHP
<?php
|
|
include '../connect/cms-config.php' ;
|
|
include '../requires/function.php' ;
|
|
|
|
$array_other_details = array() ;
|
|
|
|
// personal information
|
|
$position_applied = escapeString($_POST['position_applied']) ;
|
|
$personal_call = escapeString($_POST['personal_call']) ;
|
|
$personal_name = escapeString($_POST['personal_name']) ;
|
|
$personal_nric = escapeString($_POST['personal_nric']) ;
|
|
$personal_old_nric = escapeString($_POST['personal_old_nric']) ;
|
|
$personal_dob = escapeString($_POST['personal_dob']) ;
|
|
$personal_sex = escapeString($_POST['personal_sex']) ;
|
|
$personal_race = escapeString($_POST['personal_race']) ;
|
|
$personal_religion = escapeString($_POST['personal_religion']) ;
|
|
$personal_nationality = escapeString($_POST['personal_nationality']) ;
|
|
$personal_marital = escapeString($_POST['personal_marital']) ;
|
|
$personal_mobile = escapeString($_POST['personal_mobile']) ;
|
|
$personal_tel = escapeString($_POST['personal_tel']) ;
|
|
$personal_address = escapeString($_POST['personal_address']) ;
|
|
$personal_email = escapeString($_POST['personal_email']) ;
|
|
$personal_transport = escapeString($_POST['personal_transport']) ;
|
|
$personal_type_vehicle = escapeString($_POST['personal_type_vehicle']) ;
|
|
|
|
// set image in variable
|
|
$personal_image = $_FILES["image"]["name"] ;
|
|
$personal_image_type = $_FILES["image"]["type"] ;
|
|
|
|
// family background
|
|
$family_father_name = escapeString($_POST['family_father_name']) ;
|
|
$family_father_occupation = escapeString($_POST['family_father_occupation']) ;
|
|
$family_mother_name = escapeString($_POST['family_mother_name']) ;
|
|
$family_mother_occupation = escapeString($_POST['family_mother_occupation']) ;
|
|
$family_spouse_name = escapeString($_POST['family_spouse_name']) ;
|
|
$family_spouse_occupation = escapeString($_POST['family_spouse_occupation']) ;
|
|
|
|
// family member
|
|
$family_member_key = $_POST['family_member_key'] ;
|
|
$array_family_member = array() ;
|
|
if (arrayCheck($family_member_key)){
|
|
foreach($family_member_key as $key => $value){
|
|
$array_family_member[] = array('name' => $_POST['family_member_name'][$value],
|
|
'dob' => $_POST['family_member_dob'][$value],
|
|
'occupation' => $_POST['family_member_occupation'][$value],
|
|
'education' => $_POST['family_member_education'][$value]) ;
|
|
}
|
|
}
|
|
|
|
// family children
|
|
$family_child_key = $_POST['family_child_key'] ;
|
|
$array_family_child = array() ;
|
|
if (arrayCheck($family_child_key)){
|
|
foreach($family_child_key as $key => $value){
|
|
$array_family_child[] = array('name' => $_POST['family_child_name'][$value],
|
|
'dob' => $_POST['family_child_dob'][$value],
|
|
'occupation' => $_POST['family_child_occupation'][$value],
|
|
'education' => $_POST['family_child_education'][$value]) ;
|
|
}
|
|
}
|
|
|
|
// educational level
|
|
$education_key = $_POST['education_key'] ;
|
|
$array_education = array() ;
|
|
if (arrayCheck($education_key)){
|
|
foreach($education_key as $key => $value){
|
|
$array_education[] = array('year' => $_POST['education_year'][$value],
|
|
'school' => $_POST['education_name_school'][$value],
|
|
'qualification' => $_POST['education_qualification'][$value]) ;
|
|
}
|
|
}
|
|
$education_others = escapeString($_POST['education_others']) ;
|
|
|
|
// employment history
|
|
$employment_key = $_POST['employment_key'] ;
|
|
$array_employment = array() ;
|
|
if (arrayCheck($employment_key)){
|
|
foreach($employment_key as $key => $value){
|
|
$array_employment[] = array('date' => $_POST['employment_date'][$value],
|
|
'employer' => $_POST['employment_employer'][$value],
|
|
'positionheld' => $_POST['employment_positionheld'][$value],
|
|
'contacts' => $_POST['employment_contacts'][$value],
|
|
'salary' => $_POST['employment_salary'][$value],
|
|
'reasons' => $_POST['employment_reasons_leaving'][$value]) ;
|
|
}
|
|
}
|
|
|
|
// personality
|
|
$personality_language_spoken = escapeString($_POST['personality_language_spoken']) ;
|
|
$personality_language_written = escapeString($_POST['personality_language_written']) ;
|
|
$personality_own_strengths = escapeString($_POST['personality_own_strengths']) ;
|
|
$personality_own_weakness = escapeString($_POST['personality_own_weakness']) ;
|
|
|
|
$personality_aims = escapeString($_POST['personality_aims']) ;
|
|
$personality_overtime = escapeString($_POST['personality_overtime']) ;
|
|
$personality_pressure = escapeString($_POST['personality_pressure']) ;
|
|
$personality_available_work = escapeString($_POST['personality_available_work']) ;
|
|
$personality_contract = escapeString($_POST['personality_contract']) ;
|
|
$personality_notice = escapeString($_POST['personality_notice']) ;
|
|
|
|
// salary
|
|
$salary_last_drawn = escapeString($_POST['salary_last_drawn']) ;
|
|
$salary_expected_salary = escapeString($_POST['salary_expected_salary']) ;
|
|
|
|
// references
|
|
$references_key = $_POST['references_key'] ;
|
|
$array_references = array() ;
|
|
if (arrayCheck($references_key)){
|
|
foreach($references_key as $key => $value){
|
|
$array_references[] = array('name' => $_POST['references_name'][$value],
|
|
'position' => $_POST['references_position'][$value],
|
|
'contacts' => $_POST['references_contracts'][$value],
|
|
'years' => $_POST['references_years'][$value]) ;
|
|
}
|
|
}
|
|
|
|
// aknowledgement and authorization
|
|
$acknowledgement_certify = escapeString($_POST['acknowledgement_certify']) ;
|
|
$acknowledgement_authorize = escapeString($_POST['acknowledgement_authorize']) ;
|
|
$acknowledgement_event = escapeString($_POST['acknowledgement_event']) ;
|
|
|
|
// signature
|
|
$application_signature = escapeString($_POST['application_signature']) ;
|
|
$application_signature_date = TODAYDATE ;
|
|
|
|
// interview by
|
|
$incharge_person = escapeString($_POST['incharge_person']) ;
|
|
$information_interview_date = escapeString($_POST['information_interview_date']) ;
|
|
$information_interview_comments = escapeString($_POST['information_interview_comments']) ;
|
|
|
|
// status
|
|
$employment_status = escapeString($_POST['employment_status']) ;
|
|
// keep other value in array
|
|
$array_other_details = array('family' => array('background' => array('father_name' => $family_father_name,
|
|
'father_occupation' => $family_father_occupation,
|
|
'mother_name' => $family_mother_name,
|
|
'mother_occupation' => $family_mother_occupation,
|
|
'spouse_name' => $family_spouse_name,
|
|
'spouse_occupation' => $family_spouse_occupation),
|
|
'member' => $array_family_member,
|
|
'child' => $array_family_child),
|
|
'education' => array('school' => $array_education,
|
|
'others' => $education_others),
|
|
'employment' => $array_employment,
|
|
'personality' => array('language_spoken' => $personality_language_spoken,
|
|
'language_written' => $personality_language_written,
|
|
'own_strengths' => $personality_own_strengths,
|
|
'own_weakness' => $personality_own_weakness,
|
|
'aims' => $personality_aims,
|
|
'overtime' => $personality_overtime,
|
|
'pressure' => $personality_pressure,
|
|
'available_work' => $personality_available_work,
|
|
'contract' => $personality_contract,
|
|
'notice' => $personality_notice),
|
|
'salary' => array('last_drawn' => $salary_last_drawn,
|
|
'expected_salary' => $salary_expected_salary),
|
|
'references' => $array_references,
|
|
'acknowledgement' => array('certify' => $acknowledgement_certify,
|
|
'authorize' => $acknowledgement_authorize,
|
|
'event' => $acknowledgement_event),
|
|
'application' => array('signature' => $application_signature,
|
|
'date' => $application_signature_date),
|
|
'interview' => array('date' => $information_interview_date,
|
|
'comments' => $information_interview_comments)
|
|
) ;
|
|
$array_other_details = jsonEncodeDecode('encode', $array_other_details) ;
|
|
$status = $_POST['status'];
|
|
$status1 = $_POST['status1'];
|
|
|
|
$id = $_POST['id'];
|
|
$descrition = $_SESSION['system_name'].'(username) ' ;
|
|
$record = '';
|
|
$page_id = '';
|
|
switch ($status) {
|
|
case 'new':
|
|
switch ($status1) {
|
|
case 'not-yet':
|
|
$descrition .= 'click on application form but not submit yet';
|
|
break;
|
|
case 'insert':
|
|
$descrition .= 'submit an new application form';
|
|
break;
|
|
default:
|
|
$descrition .= 'click on new application form';
|
|
break;
|
|
}
|
|
$page_id = '200';
|
|
break;
|
|
case 'edit':
|
|
switch ($status1) {
|
|
case 'not-yet':
|
|
$descrition .= 'edit application form but not submit yet';
|
|
break;
|
|
case 'insert':
|
|
$descrition .= 'submit an edited application form';
|
|
break;
|
|
default:
|
|
$descrition .= 'click on edit application form';
|
|
break;
|
|
}
|
|
$page_id = '200';
|
|
break;
|
|
case 'unknown':
|
|
switch ($status1) {
|
|
case 'not-yet':
|
|
$descrition .= 'click on unknown application form but not submit yet';
|
|
break;
|
|
case 'insert':
|
|
$descrition .= 'submit an unknown application form';
|
|
break;
|
|
default:
|
|
$descrition .= 'click on unknown application form';
|
|
break;
|
|
}
|
|
$page_id = '201';
|
|
break;
|
|
}
|
|
|
|
if ($mysqli->query("INSERT INTO system_log
|
|
(log_table, log_action, log_page_id, log_user_id, log_description, log_record, log_date) VALUES
|
|
('employment', '".$status."', ".$page_id.", '".$_SESSION["system_id"]."', '".$descrition."', '".$array_other_details."', NOW())")){
|
|
return "success";
|
|
}else{
|
|
return "fail";
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
|