public function saveEducation(Education $education)
{
try {
$education->save();
} catch (Exception $e) {
throw new DaoException($e->getMessage(), $e->getCode(), $e);
}
}
$education->id = (int) $_GET['id'];
if ($education->delete()) {
$session->message("Education deleted ");
redirect_to($_SERVER['PHP_SELF'] . "?#" . $_GET['id']);
die;
} else {
$message = join("<br />", $education->errors);
}
}
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;
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);
}
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();
}
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));
}
}
function save()
{
$education = new Education();
$education->staff_id = $this->staff_id;
$education->edu_year = $this->input->post('edu_year');
$education->edu_gelar = $this->input->post('edu_gelar');
$education->edu_name = $this->input->post('edu_name');
if ($education->save()) {
$this->session->set_flashdata('message', 'Education successfully created!');
redirect('staffs/' . $this->staff_id . '/educations/index');
} else {
// Failed
$education->error_message('custom', 'Field required');
$msg = $education->error->custom;
$this->session->set_flashdata('message', $msg);
redirect('staffs/' . $this->staff_id . '/educations/add');
}
}
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 = Education::model()->findByPk((int) $data[0]);
if ($model === null) {
$model = new Education();
}
$model->educationid = (int) $data[0];
$model->educationname = $data[1];
$model->recordstatus = (int) $data[2];
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;
}
/**
* Store a newly created template in storage.
*
* @return Response
*/
public function store()
{
$validator = Validator::make($data = Input::all(), Template::$rules);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
} else {
$template = new Template();
$template->color = Input::get('color');
$template->layout = Input::get('templateID');
$template->user_id = Auth::id();
$template->save();
//Storing header info
if (Input::has('headerJobTitle')) {
$header = new Header1();
$header->job_title = Input::get('headerJobTitle');
$header->template_id = $template->id;
if (Input::has('headerResumeTitle')) {
$header->description = Input::get('headerResumeTitle');
}
if (Input::hasFile('headerImage')) {
$header->picture = Input::file('headerImage')->move("images/uploaded/");
}
if (Input::has('headerJobTitle')) {
$header->description = Input::get('headerJobTitle');
}
$header->save();
}
//Storing adjectives for template 2
if (Input::has('adjectives1')) {
$header1 = new Header1();
$header1->template_id = $template->id;
$header1->adjective = Input::get('adjectives1');
$header1->save();
}
if (Input::has('adjectives2')) {
$header2 = new Header1();
$header2->template_id = $template->id;
$header2->adjective = Input::get('adjectives2');
$header2->save();
}
if (Input::has('adjectives3')) {
$header3 = new Header1();
$header3->template_id = $template->id;
$header3->adjective = Input::get('adjectives3');
$header3->save();
}
//Checking for up to 6 skill inputs to be accpeted
if (Input::has('skillPercent1') && Input::has('skillTitle1')) {
$skill1 = new Skill();
$skill1->template_id = $template->id;
$skill1->percent = Input::get('skillPercent1');
$skill1->skill_title = Input::get('skillTitle1');
if (Input::has('skillDescription1')) {
$skill1->description = Input::get('skillDescription1');
}
if (Input::has('skillDescriptionTitle1')) {
$skill1->description_title = Input::get('skillDescriptionTitle1');
}
if (Input::has('hobbies1')) {
$skill1->description_title = Input::get('hobbies1');
}
$skill1->save();
}
if (Input::has('skillPercent2') && Input::has('skillTitle2')) {
$skill2 = new Skill();
$skill2->template_id = $template->id;
$skill2->percent = Input::get('skillPercent2');
$skill2->skill_title = Input::get('skillTitle2');
if (Input::has('skillDescription2')) {
$skill2->description = Input::get('skillDescription2');
}
if (Input::has('skillDescriptionTitle2')) {
$skill2->description_title = Input::get('skillDescriptionTitle2');
}
if (Input::has('hobbies2')) {
$skill2->description_title = Input::get('hobbies2');
}
$skill2->save();
}
if (Input::has('skillPercent3') && Input::has('skillTitle3')) {
$skill3 = new Skill();
$skill3->template_id = $template->id;
$skill3->percent = Input::get('skillPercent3');
$skill3->skill_title = Input::get('skillTitle3');
if (Input::has('skillDescription3')) {
$skill3->description = Input::get('skillDescription3');
}
if (Input::has('skillDescriptionTitle3')) {
$skill3->description_title = Input::get('skillDescriptionTitle3');
}
if (Input::has('hobbies3')) {
$skill3->description_title = Input::get('hobbies3');
}
$skill3->save();
}
if (Input::has('skillPercent4') && Input::has('skillTitle4')) {
$skill4 = new Skill();
$skill4->template_id = $template->id;
$skill4->percent = Input::get('skillPercent4');
$skill4->skill_title = Input::get('skillTitle4');
if (Input::has('skillDescription4') && Input::has('descriptionTitle4')) {
$skill4->description = Input::get('skillDescription4');
}
if (Input::has('skillDescriptionTitle4')) {
$skill4->description_title = Input::get('skillDescriptionTitle4');
}
$skill4->save();
}
if (Input::has('skillPercent5') && Input::has('skillTitle5')) {
$skill5 = new Skill();
$skill5->template_id = $template->id;
$skill5->percent = Input::get('skillPercent5');
$skill5->skill_title = Input::get('skillTitle5');
if (Input::has('skillDescription5')) {
$skill5->description = Input::get('skillDescription5');
}
if (Input::has('skillDescriptionTitle5')) {
$skill5->description_title = Input::get('skillDescriptionTitle5');
}
$skill5->save();
}
//Knowledge storage starts here for template 2
if (Input::has('knowledge1') && Input::has('miscHead1') && Input::has('miscFoot1') && Input::has('miscPercent1')) {
$knowledge1 = new Knowledge();
$knowledge1->template_id = $template->id;
$knowledge1->knowledge_item = Input::get('knowledge1');
$knowledge1->sub_percent = Input::get('miscPercent1');
$knowledge1->sub_head = Input::get('miscHead1');
$knowledge1->sub_foot = Input::get('miscFoot1');
if (Input::has('miscTitle1')) {
$knowledge1->sub_title = Input::get('miscTitle1');
}
$knowledge1->save();
}
if (Input::has('knowledge2') && Input::has('miscHead2') && Input::has('miscFoot2') && Input::has('miscPercent2')) {
$knowledge2 = new Knowledge();
$knowledge2->template_id = $template->id;
$knowledge2->knowledge_item = Input::get('knowledge2');
$knowledge2->sub_percent = Input::get('miscPercent2');
$knowledge2->sub_head = Input::get('miscHead2');
$knowledge2->sub_foot = Input::get('miscFoot2');
$knowledge2->save();
}
if (Input::has('knowledge3') && Input::has('miscHead3') && Input::has('miscFoot3') && Input::has('miscPercent3')) {
$knowledge3 = new Knowledge();
$knowledge3->template_id = $template->id;
$knowledge3->knowledge_item = Input::get('knowledge3');
$knowledge3->sub_percent = Input::get('miscPercent3');
$knowledge3->sub_head = Input::get('miscHead3');
$knowledge3->sub_foot = Input::get('miscFoot3');
$knowledge3->save();
}
if (Input::has('knowledge4') && Input::has('miscHead4') && Input::has('miscFoot4') && Input::has('miscPercent4')) {
$knowledge4 = new Knowledge();
$knowledge4->template_id = $template->id;
$knowledge4->knowledge_item = Input::get('knowledge4');
$knowledge4->sub_percent = Input::get('miscPercent4');
$knowledge4->sub_head = Input::get('miscHead4');
$knowledge4->sub_foot = Input::get('miscFoot4');
$knowledge4->save();
}
if (Input::has('aboutDescription1')) {
$abouts1 = new About();
$abouts1->template_id = $template->id;
$abouts1->description = Input::get('aboutDescription1');
if (Input::has('aboutTitle')) {
$abouts1->title = Input::get('aboutTitle');
}
if (Input::hasFile('aboutBackgroundImage1')) {
$abouts1->picture = Input::file('aboutBackgroundImage1')->move("images/uploaded/");
}
$abouts1->save();
}
if (Input::has('aboutDescription2')) {
$abouts2 = new About();
$abouts2->template_id = $template->id;
$abouts2->description = Input::get('aboutDescription2');
if (Input::has('aboutTitle')) {
$abouts2->title = Input::get('aboutTitle');
}
if (Input::hasFile('aboutBackgroundImage2')) {
$abouts2->picture = Input::file('aboutBackgroundImage2')->move("images/uploaded/");
}
$abouts2->save();
}
if (Input::has('aboutDescription3')) {
$abouts3 = new About();
$abouts3->template_id = $template->id;
$abouts3->description = Input::get('aboutDescription3');
if (Input::has('aboutTitle')) {
$abouts3->title = Input::get('aboutTitle');
}
if (Input::hasFile('aboutBackgroundImage3')) {
$abouts3->picture = Input::file('aboutBackgroundImage3')->move("images/uploaded/");
}
$abouts3->save();
}
if (Input::has('contactDescription')) {
$contacts = new Contact();
$contacts->template_id = $template->id;
$contacts->description = Input::get('contactDescription');
$contacts->save();
}
//Storing services currently for template 2
if (Input::has('serviceTitle1') || Input::has('serviceTitle2') || Input::has('serviceTitle3') || Input::has('serviceTitle4') || Input::has('serviceTitle5') || Input::has('serviceTitle6')) {
if (Input::has('serviceTitle1') && Input::has('serviceDescription1')) {
$service1 = new Service();
$service1->template_id = $template->id;
$service1->title = Input::get('serviceTitle1');
$service1->description = Input::get('serviceDescription1');
$service1->save();
}
if (Input::has('serviceTitle2') && Input::has('serviceDescription2')) {
$service2 = new Service();
$service2->template_id = $template->id;
$service2->title = Input::get('serviceTitle2');
$service2->description = Input::get('serviceDescription2');
$service2->save();
}
if (Input::has('serviceTitle3') && Input::has('serviceDescription3')) {
$service3 = new Service();
$service3->template_id = $template->id;
$service3->title = Input::get('serviceTitle3');
$service3->description = Input::get('serviceDescription3');
$service3->save();
}
if (Input::has('serviceTitle4') && Input::has('serviceDescription4')) {
$service4 = new Service();
$service4->template_id = $template->id;
$service4->title = Input::get('serviceTitle4');
$service4->description = Input::get('serviceDescription4');
$service4->save();
}
if (Input::has('serviceTitle5') && Input::has('serviceDescription5')) {
$service5 = new Service();
$service5->template_id = $template->id;
$service5->title = Input::get('serviceTitle5');
$service5->description = Input::get('serviceDescription5');
$service5->save();
}
if (Input::has('serviceTitle6') && Input::has('serviceDescription6')) {
$service6 = new Service();
$service6->template_id = $template->id;
$service6->title = Input::get('serviceTitle6');
$service6->description = Input::get('serviceDescription6');
$service6->save();
}
}
//There are the inputs for the portfolio storeTemplate1Images
if (Input::has('portfolioDescription1')) {
$portfolio1 = new Portfolio();
if (Input::has('portfolioTitle1')) {
$portfolio1->title = Input::get('portfolioTitle1');
}
$portfolio1->template_id = $template->id;
$portfolio1->description = Input::get('portfolioDescription1');
if (Input::hasFile('portfolioPicture1')) {
$portfolio1->picture = Input::file('portfolioPicture1')->move("img/uploaded/");
}
if (Input::has('portfolioLink1')) {
$portfolio1->link = Input::get('portfolioLink1');
}
if (Input::has('portfolioCategory1')) {
$portfolio1->category = Input::get('portfolioCategory1');
}
$portfolio1->save();
}
if (Input::has('portfolioDescription2')) {
$portfolio2 = new Portfolio();
if (Input::has('portfolioTitle2')) {
$portfolio2->title = Input::get('portfolioTitle2');
}
$portfolio2->template_id = $template->id;
$portfolio2->description = Input::get('portfolioDescription2');
if (Input::hasFile('portfolioPicture2')) {
$portfolio2->picture = Input::file('portfolioPicture2')->move("img/uploaded/");
}
if (Input::has('portfolioLink2')) {
$portfolio2->link = Input::get('portfolioLink2');
}
if (Input::has('portfolioCategory2')) {
$portfolio2->category = Input::get('portfolioCategory2');
}
$portfolio2->save();
}
if (Input::has('portfolioDescription3')) {
$portfolio3 = new Portfolio();
if (Input::has('portfolioTitle3')) {
$portfolio3->title = Input::get('portfolioTitle3');
}
$portfolio3->template_id = $template->id;
$portfolio3->description = Input::get('portfolioDescription3');
if (Input::hasFile('portfolioPicture3')) {
$portfolio3->picture = Input::file('portfolioPicture3')->move("img/uploaded/");
}
if (Input::has('portfolioLink3')) {
$portfolio3->link = Input::get('portfolioLink3');
}
if (Input::has('portfolioCategory3')) {
$portfolio3->category = Input::get('portfolioCategory3');
}
$portfolio3->save();
}
if (Input::has('portfolioDescription4')) {
$portfolio4 = new Portfolio();
if (Input::has('portfolioTitle4')) {
$portfolio4->title = Input::get('portfolioTitle4');
}
$portfolio4->template_id = $template->id;
$portfolio4->description = Input::get('portfolioDescription4');
if (Input::hasFile('portfolioPicture4')) {
$portfolio4->picture = Input::file('portfolioPicture4')->move("img/uploaded/");
}
if (Input::has('portfolioLink4')) {
$portfolio4->link = Input::get('portfolioLink4');
}
if (Input::has('portfolioCategory4')) {
$portfolio4->category = Input::get('portfolioCategory4');
}
$portfolio4->save();
}
if (Input::has('portfolioDescription5')) {
$portfolio5 = new Portfolio();
if (Input::has('portfolioTitle5')) {
$portfolio5->title = Input::get('portfolioTitle5');
}
$portfolio5->template_id = $template->id;
$portfolio5->description = Input::get('portfolioDescription5');
if (Input::hasFile('portfolioPicture5')) {
$portfolio5->picture = Input::file('portfolioPicture5')->move("img/uploaded/");
}
if (Input::has('portfolioLink5')) {
$portfolio5->link = Input::get('portfolioLink5');
}
if (Input::has('portfolioCategory5')) {
$portfolio5->category = Input::get('portfolioCategory5');
}
$portfolio5->save();
}
if (Input::has('portfolioDescription6')) {
$portfolio6 = new Portfolio();
if (Input::has('portfolioTitle6')) {
$portfolio6->title = Input::get('portfolioTitle6');
}
$portfolio6->template_id = $template->id;
$portfolio6->description = Input::get('portfolioDescription6');
if (Input::hasFile('portfolioPicture6')) {
$portfolio6->picture = Input::file('portfolioPicture6')->move("img/uploaded/");
}
if (Input::hasFile('portfolioLink6')) {
$portfolio6->link = Input::get('portfolioLink6');
}
if (Input::hasFile('portfolioCategory6')) {
$portfolio6->category = Input::get('portfolioCategory6');
}
$portfolio6->save();
}
//Awards
if (Input::has('awardTitle1') && Input::has('awardNumber1')) {
$award1 = new Award();
$award1->template_id = $template->id;
$award1->award_number = Input::get('awardTitle1');
$award1->award_title = Input::get('awardNumber1');
$award1->save();
}
if (Input::has('awardTitle2') && Input::has('awardNumber2')) {
$award2 = new Award();
$award2->template_id = $template->id;
$award2->award_number = Input::get('awardTitle2');
$award2->award_title = Input::get('awardNumber2');
$award2->save();
}
if (Input::has('awardTitle3') && Input::has('awardNumber3')) {
$award3 = new Award();
$award3->template_id = $template->id;
$award3->award_number = Input::get('awardTitle3');
$award3->award_title = Input::get('awardNumber3');
$award3->save();
}
//Storing up to 6 work experience sections
if (Input::has('workExperienceStart1') && Input::has('workExperienceDescription1') && Input::has('workExperienceTitle1')) {
$experience1 = new workExperience();
if (Input::has('workExperienceExtraText1')) {
$experience1->description = Input::get('workExperienceExtraText1');
}
$experience1->template_id = $template->id;
$experience1->start_date = Input::get('workExperienceStart1');
$experience1->title = Input::get('workExperienceTitle1');
$experience1->description = Input::get('workExperienceDescription1');
if (Input::has('workExperienceEnd1')) {
$experience1->end_date = Input::get('workExperienceEnd1');
}
$experience1->save();
}
if (Input::has('workExperienceStart2') && Input::has('workExperienceDescription2') && Input::has('workExperienceTitle2')) {
$experience2 = new workExperience();
$experience2->template_id = $template->id;
$experience2->start_date = Input::get('workExperienceStart2');
$experience2->title = Input::get('workExperienceTitle2');
$experience2->description = Input::get('workExperienceDescription2');
if (Input::has('workExperienceEnd2')) {
$experience2->end_date = Input::get('workExperienceEnd2');
}
$experience2->save();
}
if (Input::has('workExperienceStart3') && Input::has('workExperienceDescription3') && Input::has('workExperienceTitle3')) {
$experience3 = new workExperience();
$experience3->template_id = $template->id;
$experience3->start_date = Input::get('workExperienceStart3');
$experience3->title = Input::get('workExperienceTitle3');
$experience3->description = Input::get('workExperienceDescription3');
if (Input::has('workExperienceEnd3')) {
$experience3->end_date = Input::get('workExperienceEnd3');
}
$experience3->save();
}
if (Input::has('workExperienceStart4') && Input::has('workExperienceDescription4') && Input::has('workExperienceTitle4')) {
$experience4 = new workExperience();
$experience4->template_id = $template->id;
$experience4->start_date = Input::get('workExperienceStart4');
$experience4->title = Input::get('workExperienceTitle4');
$experience4->description = Input::get('workExperienceDescription4');
if (Input::has('workExperienceEnd4')) {
$experience4->end_date = Input::get('workExperienceEnd4');
}
$experience4->save();
}
if (Input::has('workExperienceStart5') && Input::has('workExperienceDescription5') && Input::has('workExperienceTitle5')) {
$experience5 = new workExperience();
$experience5->template_id = $template->id;
$experience5->start_date = Input::get('workExperienceStart5');
$experience5->title = Input::get('workExperienceTitle5');
$experience5->description = Input::get('workExperienceDescription5');
if (Input::has('workExperienceEnd5')) {
$experience5->end_date = Input::get('workExperienceEnd5');
}
$experience5->save();
}
if (Input::has('workExperienceStart6') && Input::has('workExperienceDescription6') && Input::has('workExperienceTitle6')) {
$experience6 = new workExperience();
$experience6->template_id = $template->id;
$experience6->start_date = Input::get('workExperienceStart6');
$experience6->title = Input::get('workExperienceTitle6');
$experience6->description = Input::get('workExperienceDescription6');
if (Input::has('workExperienceEnd6')) {
$experience6->end_date = Input::get('workExperienceEnd6');
}
$experience6->save();
}
if (Input::has('educationStart1') && Input::has('educationDescription1') && Input::has('educationTitle1')) {
$education1 = new Education();
$education1->template_id = $template->id;
$education1->start_date = Input::get('educationStart1');
if (Input::has('educationEnd1')) {
$education1->end_date = Input::get('educationEnd1');
}
$education1->title = Input::get('educationTitle1');
$education1->description = Input::get('educationDescription1');
$education1->save();
}
if (Input::has('educationStart2') && Input::has('educationDescription2') && Input::has('educationTitle2')) {
$education2 = new Education();
$education2->template_id = $template->id;
$education2->start_date = Input::get('educationStart2');
if (Input::has('educationEnd2')) {
$education2->end_date = Input::get('educationEnd2');
}
$education2->title = Input::get('educationTitle2');
$education2->description = Input::get('educationDescription2');
$education2->save();
}
if (Input::has('educationStart3') && Input::has('educationDescription3') && Input::has('educationTitle3')) {
$education3 = new Education();
$education3->template_id = $template->id;
$education3->start_date = Input::get('educationStart3');
if (Input::has('educationEnd3')) {
$education3->end_date = Input::get('educationEnd3');
}
$education3->title = Input::get('educationTitle3');
$education3->description = Input::get('educationDescription3');
$education3->save();
}
if (Input::has('educationStart4') && Input::has('educationDescription4') && Input::has('educationTitle4')) {
$education4 = new Education();
$education4->template_id = $template->id;
$education4->start_date = Input::get('educationStart4');
if (Input::has('educationEnd4')) {
$education4->end_date = Input::get('educationEnd4');
}
$education4->title = Input::get('educationTitle4');
$education4->description = Input::get('educationDescription4');
$education4->save();
}
}
return Redirect::action('UsersController@getProfile');
}
public function run()
{
$education = new Education();
$education->description = "I worked as a fisher";
$education->title = "Fisherman";
$education->start_date = "June 6, 1990";
$education->end_date = "May 7, 2000";
$education->template_id = 1;
$education->save();
$education2 = new Education();
$education2->description = "I worked as a fisher";
$education2->title = "Fisherman";
$education2->start_date = "June 6, 1990";
$education2->end_date = "May 7, 2000";
$education2->template_id = 1;
$education2->save();
$education3 = new Education();
$education3->description = "I worked as a fisher";
$education3->title = "Fisherman";
$education3->start_date = "June 6, 1990";
$education3->end_date = "May 7, 2000";
$education3->template_id = 1;
$education3->save();
$education4 = new Education();
$education4->description = "I worked as a fisher";
$education4->title = "Fisherman";
$education4->start_date = "June 6, 1990";
$education4->end_date = "May 7, 2000";
$education4->template_id = 1;
$education4->save();
$education5 = new Education();
$education5->description = "I worked as a fisher";
$education5->title = "Fisherman";
$education5->start_date = "June 6, 1990";
$education5->end_date = "May 7, 2000";
$education5->template_id = 2;
$education5->save();
$education6 = new Education();
$education6->description = "I worked as a fisher";
$education6->title = "Fisherman";
$education6->start_date = "June 6, 1990";
$education6->end_date = "May 7, 2000";
$education6->template_id = 2;
$education6->save();
$education7 = new Education();
$education7->description = "I worked as a fisher";
$education7->title = "Fisherman";
$education7->start_date = "June 6, 1990";
$education7->end_date = "May 7, 2000";
$education7->template_id = 2;
$education7->save();
$education8 = new Education();
$education8->description = "I worked as a fisher";
$education8->title = "Fisherman";
$education8->start_date = "June 6, 1990";
$education8->end_date = "May 7, 2000";
$education8->template_id = 2;
$education8->save();
$education9 = new Education();
$education9->description = "I worked as a fisher";
$education9->title = "Fisherman";
$education9->start_date = "June 6, 1990";
$education9->end_date = "May 7, 2000";
$education9->template_id = 3;
$education9->save();
$education10 = new Education();
$education10->description = "I worked as a fisher";
$education10->title = "Fisherman";
$education10->start_date = "June 6, 1990";
$education10->end_date = "May 7, 2000";
$education10->template_id = 3;
$education10->save();
$education11 = new Education();
$education11->description = "I worked as a fisher";
$education11->title = "Fisherman";
$education11->start_date = "June 6, 1990";
$education11->end_date = "May 7, 2000";
$education11->template_id = 3;
$education11->save();
$education12 = new Education();
$education12->description = "I worked as a fisher";
$education12->title = "Fisherman";
$education12->start_date = "June 6, 1990";
$education12->end_date = "May 7, 2000";
$education12->template_id = 3;
$education12->save();
}
}
$journo = db_getRow("SELECT * FROM journo WHERE id=?", $journo_id);
admPageHeader($journo['ref'] . " Education Info");
$action = get_http_var('_action');
if ($action == 'update' || $action == 'create') {
// form has been submitted
$obj = new Education();
$obj->fromHTTPVars($_POST);
/*
print"<hr/><pre><code>\n";
print_r( $_POST );
print "--------\n";
print_r( $obj );
print"</code></pre><hr/>\n";
*/
$obj->save();
?>
<div class="info">Saved.</div>
<?php
} else {
$obj = new Education();
if (!$id) {
// it's new.
$obj->journo_id = $journo_id;
} else {
// fetch from db
$sql = <<<EOT
SELECT e.*,
l.id as src__id,
l.url as src__url,
l.title as src__title,
public function actionRegisterLinkedIn()
{
// if user canceled, redirect to home page
if (isset($_GET['oauth_problem'])) {
$problem = $_GET['oauth_problem'];
if ($problem == 'user_refused') {
$this->redirect('/JobFair/index.php');
}
}
if (!isset($_SESSION)) {
session_start();
}
//edit by Manuel making the link dynamic, using Yii
$config['base_url'] = 'http://' . Yii::app()->request->getServerName() . '/JobFair/index.php/user/auth1.php';
$config['callback_url'] = 'http://' . Yii::app()->request->getServerName() . '/JobFair/index.php/user/RegisterLinkedIn';
$config['linkedin_access'] = '2rtmn93gu2m4';
$config['linkedin_secret'] = 'JV0fYG9ls3rclP8v';
include_once Yii::app()->basePath . "/views/user/linkedin.php";
# First step is to initialize with your consumer key and secret. We'll use an out-of-band oauth_callback
$linkedin = new LinkedIn($config['linkedin_access'], $config['linkedin_secret'], $config['callback_url']);
//$linkedin->debug = true;
if (isset($_REQUEST['oauth_verifier'])) {
$_SESSION['oauth_verifier'] = $_REQUEST['oauth_verifier'];
$linkedin->request_token = unserialize($_SESSION['requestToken']);
$linkedin->oauth_verifier = $_SESSION['oauth_verifier'];
$linkedin->getAccessToken($_REQUEST['oauth_verifier']);
$_SESSION['oauth_access_token'] = serialize($linkedin->access_token);
header("Location: " . $config['callback_url']);
exit;
} else {
$linkedin->request_token = unserialize($_SESSION['requestToken']);
$linkedin->oauth_verifier = $_SESSION['oauth_verifier'];
$linkedin->access_token = unserialize($_SESSION['oauth_access_token']);
}
# You now have a $linkedin->access_token and can make calls on behalf of the current member
$xml_response = $linkedin->getProfile("~:(id,first-name,last-name,headline,picture-url,industry,email-address,languages,phone-numbers,skills,educations,location:(name),positions,picture-urls::(original))");
$data = simplexml_load_string($xml_response);
// get user by linkedinid
$model = new User();
$user = User::model()->findByAttributes(array('linkedinid' => $data->id));
// check if user exits in database, if so login
if ($user != null) {
if ($user->disable != 1) {
$identity = new UserIdentity($user->username, '');
if ($identity->authenticateOutside()) {
Yii::app()->user->login($identity);
}
$this->redirect("/JobFair/index.php/home/studenthome");
return;
} else {
$this->redirect("/JobFair/index.php/site/page?view=disableUser");
return;
}
// register
} else {
// print "<pre>"; print_r('user is null');print "</pre>";
// check that there is no duplicate user if so link to that account
$duplicateUser = User::model()->findByAttributes(array('email' => $data->{'email-address'}));
if ($duplicateUser != null) {
// get username and link the accounts
$username = $duplicateUser->username;
$user = User::model()->find("username=:username", array(':username' => $username));
$user->linkedinid = $data->{'id'};
$user->save(false);
$user_id = $user->id;
// ------------------BASIC INFO---------------
$basic_info = null;
$basic_info = BasicInfo::model()->findByAttributes(array('userid' => $user_id));
if ($basic_info == null) {
$basic_info = new BasicInfo();
}
$basic_info->userid = $user_id;
$basic_info->save(false);
// ------------------BASIC INFO -----------------
// -----------------EDUCATION ----------------------
// get number of educations to add
$educ_count = $data->educations['total'];
// delete current educations
$delete_educs = Education::model()->findAllByAttributes(array('FK_user_id' => $user_id));
foreach ($delete_educs as $de) {
$de->delete();
}
// add educations
for ($i = 0; $i < $educ_count; $i++) {
// first check if current education is in school table. if not, add it
$current_school_name = $data->educations->education[$i]->{'school-name'};
$school_exists = School::model()->findByAttributes(array('name' => $current_school_name));
if ($school_exists == null) {
$new_school = new School();
$new_school->name = $current_school_name;
$new_school->save();
$school_id = School::model()->findByAttributes(array('name' => $current_school_name))->id;
} else {
$school_id = $school_exists->id;
}
// now ready to add new education
$new_educ = new Education();
$new_educ->degree = $data->educations->education[$i]->degree;
$new_educ->major = $data->educations->education[$i]->{'field-of-study'};
// $model->admission_date=date('Y-m-d',strtotime($model->admission_date));
$new_educ->graduation_date = date('Y-m-d', strtotime($data->educations->education[$i]->{'end-date'}->year));
// print "<pre>"; print_r($new_educ->graduation_date);print "</pre>";return;
$new_educ->FK_school_id = $school_id;
$new_educ->FK_user_id = $user_id;
$new_educ->additional_info = $data->educations->education[$i]->notes;
$new_educ->save(false);
}
// -----------------EDUCATION ----------------------
// -----------------EXPERIENCE -------------------
// get number of educations to add
$pos_count = $data->positions['total'];
// delete current positions
$delete_pos = Experience::model()->findAllByAttributes(array('FK_userid' => $user_id));
foreach ($delete_pos as $de) {
$de->delete();
}
for ($i = 0; $i < $pos_count; $i++) {
$new_pos = new Experience();
$new_pos->FK_userid = $user_id;
$new_pos->company_name = $data->positions->position[$i]->company->name;
$new_pos->job_title = $data->positions->position[$i]->title;
$new_pos->job_description = $data->positions->position[$i]->summary;
$temp_start_date = $data->positions->position[$i]->{'start-date'}->month . '/01/' . $data->positions->position[$i]->{'start-date'}->year;
$new_pos->startdate = date('Y-m-d', strtotime($temp_start_date));
if ($data->positions->position[$i]->{'is-current'} == 'true') {
$new_pos->enddate = '';
} else {
$temp_end_date = $data->positions->position[$i]->{'end-date'}->month . '/01/' . $data->positions->position[$i]->{'end-date'}->year;
$new_pos->enddate = date('Y-m-d', strtotime($temp_end_date));
}
$new_pos->city = '';
$new_pos->state = '';
$new_pos->save(false);
}
// -----------------EXPERIENCE -------------------
// ----------------------SKILLS----------------------
// get number of educations to add
$linkedin_skill_count = $data->skills['total'];
for ($i = 0; $i < $linkedin_skill_count; $i++) {
// check if skill exists in skill set table, if not, add it to skill set table
if (Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name)) == null) {
$new_skill = new Skillset();
$new_skill->name = $data->skills->skill[$i]->skill->name;
$new_skill->save(false);
//echo 'New Skill ' . $new_skill->attributes;
}
// check if student has that skill, if not add it to student-skill-map table
if (StudentSkillMap::model()->findByAttributes(array('userid' => $user_id, 'skillid' => Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name))->id)) == null) {
$new_sdnt_skill = new StudentSkillMap();
$new_sdnt_skill->userid = $user_id;
$new_sdnt_skill->skillid = Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name))->id;
$new_sdnt_skill->ordering = $i + 1;
$new_sdnt_skill->save(false);
echo 'New Skill for student' . $new_sdnt_skill->attributes;
}
}
// ----------------------SKILLS----------------------
if ($duplicateUser->disable != 1) {
$identity = new UserIdentity($duplicateUser->username, '');
if ($identity->authenticateOutside()) {
Yii::app()->user->login($identity);
}
$mesg = "LinkedIn";
//get variables
$mesg = "LinkedIn";
$phone = $data->{'phone-numbers'}->{'phone-number'}->{'phone-number'};
if ($phone != null) {
$phone = strip_tags($data->{'phone-numbers'}->{'phone-number'}->{'phone-number'}->asXML());
}
$city = $data->location->name;
if ($city != null) {
$city = strip_tags($data->location->name->asXML());
}
$state = '';
$about_me = $data->headline;
if ($about_me != null) {
$about_me = strip_tags($data->headline->asXML());
}
$picture = $data->{'picture-urls'}->{'picture-url'}[0];
if ($picture != null) {
$picture = strip_tags($data->{'picture-urls'}->{'picture-url'}[0]->asXML());
}
$this->actionLinkTo($data->{'email-address'}, $data->{'first-name'}, $data->{'last-name'}, $picture, $mesg, $phone, $city, $state, $about_me);
return;
} else {
$this->redirect("/JobFair/index.php/site/page?view=disableUser");
return;
}
}
// Populate user attributes
$model->FK_usertype = 1;
$model->registration_date = new CDbExpression('NOW()');
$model->activation_string = 'linkedin';
$model->username = $data->{'email-address'}[0];
$model->first_name = $data->{'first-name'};
$model->last_name = $data->{'last-name'};
$model->email = $data->{'email-address'};
$model->image_url = $data->{'picture-urls'}->{'picture-url'}[0];
$model->linkedinid = $data->id;
//Hash the password before storing it into the database
$hasher = new PasswordHash(8, false);
$model->password = $hasher->HashPassword('tester');
$model->activated = 1;
$model->has_viewed_profile = 1;
$model->save(false);
// // ------------------BASIC INFO---------------
$basic_info = null;
$basic_info = BasicInfo::model()->findByAttributes(array('userid' => $model->id));
if ($basic_info == null) {
$basic_info = new BasicInfo();
}
$basic_info->userid = $model->id;
$basic_info->phone = $data->{'phone-numbers'}->{'phone-number'}->{'phone-number'};
$basic_info->city = $data->location->name;
$basic_info->state = '';
$basic_info->about_me = $data->headline;
$basic_info->save(false);
// ------------------BASIC INFO -----------------
// -----------------EDUCATION ----------------------
// get number of educations to add
$educ_count = $data->educations['total'];
// delete current educations
$delete_educs = Education::model()->findAllByAttributes(array('FK_user_id' => $model->id));
foreach ($delete_educs as $de) {
$de->delete();
}
// add educations
for ($i = 0; $i < $educ_count; $i++) {
// first check if current education is in school table. if not, add it
$current_school_name = $data->educations->education[$i]->{'school-name'};
$school_exists = School::model()->findByAttributes(array('name' => $current_school_name));
if ($school_exists == null) {
$new_school = new School();
$new_school->name = $current_school_name;
$new_school->save();
$school_id = School::model()->findByAttributes(array('name' => $current_school_name))->id;
} else {
$school_id = $school_exists->id;
}
// now ready to add new education
$new_educ = new Education();
$new_educ->degree = $data->educations->education[$i]->degree;
$new_educ->major = $data->educations->education[$i]->{'field-of-study'};
// $model->admission_date=date('Y-m-d',strtotime($model->admission_date));
$new_educ->graduation_date = date('Y-m-d', strtotime($data->educations->education[$i]->{'end-date'}->year));
// print "<pre>"; print_r($new_educ->graduation_date);print "</pre>";return;
$new_educ->FK_school_id = $school_id;
$new_educ->FK_user_id = $model->id;
$new_educ->additional_info = $data->educations->education[$i]->notes;
$new_educ->save(false);
}
// -----------------EDUCATION ----------------------
// -----------------EXPERIENCE -------------------
// get number of educations to add
$pos_count = $data->positions['total'];
// delete current positions
$delete_pos = Experience::model()->findAllByAttributes(array('FK_userid' => $model->id));
foreach ($delete_pos as $de) {
$de->delete();
}
for ($i = 0; $i < $pos_count; $i++) {
$new_pos = new Experience();
$new_pos->FK_userid = $model->id;
$new_pos->company_name = $data->positions->position[$i]->company->name;
$new_pos->job_title = $data->positions->position[$i]->title;
$new_pos->job_description = $data->positions->position[$i]->summary;
$temp_start_date = $data->positions->position[$i]->{'start-date'}->month . '/01/' . $data->positions->position[$i]->{'start-date'}->year;
$new_pos->startdate = date('Y-m-d', strtotime($temp_start_date));
if ($data->positions->position[$i]->{'is-current'} == 'true') {
$new_pos->enddate = '';
} else {
$temp_end_date = $data->positions->position[$i]->{'end-date'}->month . '/01/' . $data->positions->position[$i]->{'end-date'}->year;
$new_pos->enddate = date('Y-m-d', strtotime($temp_end_date));
}
$new_pos->city = '';
$new_pos->state = '';
$new_pos->save(false);
}
// -----------------EXPERIENCE -------------------
// ----------------------SKILLS----------------------
// get number of educations to add
$linkedin_skill_count = $data->skills['total'];
for ($i = 0; $i < $linkedin_skill_count; $i++) {
// check if skill exists in skill set table, if not, add it to skill set table
if (Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name)) == null) {
$new_skill = new Skillset();
$new_skill->name = $data->skills->skill[$i]->skill->name;
$new_skill->save(false);
//echo 'New Skill ' . $new_skill->attributes;
}
// check if student has that skill, if not add it to student-skill-map table
if (StudentSkillMap::model()->findByAttributes(array('userid' => $model->id, 'skillid' => Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name))->id)) == null) {
$new_sdnt_skill = new StudentSkillMap();
$new_sdnt_skill->userid = $model->id;
$new_sdnt_skill->skillid = Skillset::model()->findByAttributes(array('name' => $data->skills->skill[$i]->skill->name))->id;
$new_sdnt_skill->ordering = $i + 1;
$new_sdnt_skill->save(false);
}
}
// ----------------------SKILLS----------------------
// LOGIN
$user = User::model()->find("username=:username", array(':username' => $model->username));
$identity = new UserIdentity($user->username, 'tester');
if ($identity->authenticate()) {
Yii::app()->user->login($identity);
}
$this->redirect("/JobFair/index.php/user/ChangeFirstPassword");
}
}
public function postEducation()
{
$cre = ['coursename' => Input::get('coursename'), 'institutename' => Input::get('institutename')];
$rules = ['coursename' => 'required', 'institutename' => 'required'];
$validator = Validator::make($cre, $rules);
if ($validator->passes()) {
$education = new Education();
$education->cv_id = Input::get('cv_id');
$education->coursename = Input::get('coursename');
$education->institutename = Input::get('institutename');
$education->add_line1 = Input::get('add_line1');
$education->add_line2 = Input::get('add_line2');
$education->startdate = Input::get('startdate');
$education->enddate = Input::get('enddate');
$education->otherinfo = Input::get('otherinfo');
$education->save();
$insert_id = $education->id;
$data["success"] = true;
$data["message"] = 'Education details are succefully added';
$data["title"] = Input::get('title');
$data["id"] = $insert_id;
$data["coursename"] = Input::get('coursename');
$data["institutename"] = Input::get('institutename');
$data["startdate"] = Input::get('startdate');
$data["enddate"] = Input::get('enddate');
} else {
$data["success"] = false;
$data["message"] = 'Please fill required fields';
}
return json_encode($data);
}
