JA Job Board Component 8,554 posts

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#734921

Hi Andrea.

It’s seem that this matter will take longer than i expect.

So please wait a little.

I’ll pm you asap when the work done.

Regards.

[fismpn Friend fismpnJoin date: May 2013Posts: 67Downloads:2Uploads:1 Thanks: 34]

#570167

Hi,
Thank you, if you need more informations I’m here. 🙂

Andrea

[fismpn Friend fismpnJoin date: May 2013Posts: 67Downloads:2Uploads:1 Thanks: 34]

#570693

Hi,
the Export works fine now!
We are still waiting for the filter problem.

Thank you!
Andrea

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#571480

Hi fismpn,

I’m terribly sorry for this lateness. I sorted problem out with following solution:

1.administratorcomponentscom_jajobboardcontrollersjacandidates.php

Edit
[PHP]$data = $model->getItems(” a.user_id IN (” . implode(‘,’, $cid) . “) “, 0, 0);[/PHP]

To
[PHP]$data = $model->getItems(” a.user_id IN (” . implode(‘,’, $cid) . “) “, 0, 0, ”, true);[/PHP]

2.componentscom_jajobboardmodelsjaresumes.php

Edit
[PHP]if (!checkPermission(‘view_list_resumes’, “YOU_DONT_HAVE_PERMISSION_TO_VIEW_RESUMES”, false) && !$mainframe->isAdmin()) {[/PHP]

To
[PHP]if (!$mainframe->isAdmin() && !checkPermission(‘view_list_resumes’, “YOU_DONT_HAVE_PERMISSION_TO_VIEW_RESUMES”, false)) {[/PHP]

3./components/com_jajobboard/helper/jafunctions.class.php
Line: 5037
Edit
[PHP]$alias = ‘code’;[/PHP]

To
[PHP]$alias = ‘code_’.$field->field_name;[/PHP]

Line: 5063-5073
[PHP]$join_clause_field[$alias] = ” ON $alias.field_id='{$field->table_name}_{$field->field_name}'”.
” AND(“.
” a.{$field->field_name} LIKE CONCAT($alias.value, ‘,%’)”.
” a.{$field->field_name} LIKE CONCAT(‘%, ‘, $alias.value, ‘,%’)”.
” a.{$field->field_name} LIKE CONCAT(‘%, ‘, $alias.value)”.
” AND a.{$field->field_name}=$alias.value”;
if($filter_text && $filter_text != “”” && $filter_text != “‘ ‘”){
$where_clause[] = ” $alias.value IN($filter_text) “;
}[/PHP]

To
[PHP]$join_clause_field[$alias] = ” ON $alias.field_id='{$field->table_name}_{$field->field_name}'”.
” AND(“.
” a.{$field->field_name} LIKE CONCAT($alias.value, ‘,%’)”.
” OR a.{$field->field_name} LIKE CONCAT(‘%,’, $alias.value, ‘,%’)”.
” OR a.{$field->field_name} LIKE CONCAT(‘%,’, $alias.value)”.
” OR a.{$field->field_name}=$alias.value )”;
if($filter_text && $filter_text != “”” && $filter_text != “‘ ‘”){
$where_clause[] = ” (a.{$field->field_name} IN($filter_text) OR $alias.value IN($filter_text)) “;
} [/PHP]

Regard

2 users say Thank You to Mo0nlight for this useful post

1. Saguaros
2. fismpn

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#736528

Hi fismpn,

I’m terribly sorry for this lateness. I sorted problem out with following solution:

1.administratorcomponentscom_jajobboardcontrollersjacandidates.php

Edit

$data = $model->getItems(" a.user_id IN (" . implode(',', $cid) . ") ", 0, 0);

To

$data = $model->getItems(" a.user_id IN (" . implode(',', $cid) . ") ", 0, 0, '', true);

2.componentscom_jajobboardmodelsjaresumes.php

Edit

if (!checkPermission('view_list_resumes', "YOU_DONT_HAVE_PERMISSION_TO_VIEW_RESUMES", false) && !$mainframe->isAdmin()) {

To

if (!$mainframe->isAdmin() && !checkPermission('view_list_resumes', "YOU_DONT_HAVE_PERMISSION_TO_VIEW_RESUMES", false)) {

3./components/com_jajobboard/helper/jafunctions.class.php
Line: 5037
Edit

$alias = 'code';

To

$alias = 'code_'.$field->field_name;

Line: 5063-5073

$join_clause_field[$alias] = " ON $alias.field_id='{$field->table_name}_{$field->field_name}'".
" AND(".
" a.{$field->field_name} LIKE CONCAT($alias.value, ',%')".
" a.{$field->field_name} LIKE CONCAT('%, ', $alias.value, ',%')".
" a.{$field->field_name} LIKE CONCAT('%, ', $alias.value)".
" AND a.{$field->field_name}=$alias.value";
if($filter_text && $filter_text != "''" && $filter_text != "' '"){
$where_clause[] = " $alias.value IN($filter_text) ";
}

To

$join_clause_field[$alias] = " ON $alias.field_id='{$field->table_name}_{$field->field_name}'".
" AND(".
" a.{$field->field_name} LIKE CONCAT($alias.value, ',%')".
" OR a.{$field->field_name} LIKE CONCAT('%,', $alias.value, ',%')".
" OR a.{$field->field_name} LIKE CONCAT('%,', $alias.value)".
" OR a.{$field->field_name}=$alias.value )";
if($filter_text && $filter_text != "''" && $filter_text != "' '"){
$where_clause[] = " (a.{$field->field_name} IN($filter_text) OR $alias.value IN($filter_text)) ";
}

Regard

2 users say Thank You to Mo0nlight for this useful post

1. Saguaros
2. fismpn

[fismpn Friend fismpnJoin date: May 2013Posts: 67Downloads:2Uploads:1 Thanks: 34]

#571521

Hi Mo0nlight,
thank you for the reply, I’m very happy to read you fixed it! ^_^
Thanks!!!

Andrea

[Author]

Posts