Redundant Fetching View in my self component created help !! - Joomla! Forum - community, help and support

hi got issues in component, created search need fetch view of resume of each jobseeker , cover letter view links, problem when have click on view got fetch same resume 1 person's resume on getting other resume or not have resume on account must "no resume" or no cover letter still view link of other applicant . please me , here code , attached picture regarding problem thanks.


https://fbcdn-sphotos-f-a.akamaihd.net/hphotos-ak-snc7/s480x480/406888_564766383550166_335468465_n.jpg

here code:
<?php

/**

+ created by : joombah team

* company : isds sdn bhd

+ contact : http://www.joombah.com , support@joombah.com

* created on : august 2010

* author : faisel

* tested by : zaki

+ project : job site

* file name : views/employer/tmpl/findresume.php

* license : gnu general public license version 3, or later

^

* description : search jobseekers (jbjobs)

^

* history : none

* */

defined('_jexec') or die('restricted access');

jbjobs::loadmootools();

jbjobs::gettooltip();

jhtml::_('behavior.modal');

$doc =& jfactory::getdocument();

$doc->addscript("components/com_jbjobs/js/lightface.js");

$doc->addscript("components/com_jbjobs/js/light.js");

$doc->addscript("components/com_jbjobs/js/utility.js");

jtext::script('jbjobs_buy_credit');

jtext::script('jbjobs_buy_subscription');

jtext::script('jbjobs_close');



$user =& jfactory::getuser();

$action = jroute::_('index.php?option=com_jbjobs&view=employer&layout=findresume');



$post = jrequest::get('get');



$keyword = (!empty($post['keyword'])) ? $post['keyword'] : jrequest::getvar('keyword','', 'get', 'string');

$phrase = (!empty($post['phrase'])) ? $post['phrase'] : jrequest::getvar('phrase','','get','string');

$id_job_spec = (!empty($post['id_job_spec'])) ?(int) $post['id_job_spec'] : (int) jrequest::getvar('id_job_spec', 0, 'get', 'string');

$id_major = (!empty($post['id_major'])) ? (int)$post['id_major'] : (int) jrequest::getvar('id_major', 0, 'get', 'string');

$id_job_exp = (!empty($post['id_job_exp'])) ? (int)$post['id_job_exp'] : (int) jrequest::getvar('id_job_exp', 0, 'get', 'string');

$id_degree_level = (!empty($post['id_degree_level'])) ? (int)$post['id_degree_level'] : (int) jrequest::getvar('id_degree_level', 0, 'get', 'string');

$id_industry = (!empty($post['id_industry'])) ? (int)$post['id_industry'] : (int) jrequest::getvar('id_industry', 0, 'get', 'string');

$id_search_job = (!empty($post['id_search_job'])) ? (int)$post['id_search_job'] : (int) jrequest::getvar('id_search_job', 0, 'get', 'string');

$id_country = (!empty($post['id_country'])) ?(int) $post['id_country'] int) jrequest::getvar('id_country', 0, 'get', 'string');

$city = (!empty($post['city'])) ? $post['city'] : jrequest::getvar('city', '', 'get', 'string');

$state = (!empty($post['state'])) ? $post['state'] : jrequest::getvar('state', '', 'get', 'string');

$gender = jrequest::getvar('personal_gender', '', 'post', 'char');

$image = jrequest::getvar('personal_gender', '', 'post', 'char');

$showresult = (!empty($post['showresult'])) ? $post['showresult'] : jrequest::getvar('showresult', '', 'get', 'int');



//filter out non alphanumerics

$keyword = preg_replace("/\s*,\s*/", ",", $keyword); //remove spaces before , after commas(,)

$keyword = preg_replace("/[^a-za-z0-9 ,-]/", "", $keyword);




$model = $this->getmodel();
$row = $this->data;

//start of update resume ----

$x = 0;
for ($y=0, $v=count($this->rows); $y < $v; $y++) {

$row = $this->rows[$y];
}
$id_resume = $model->getactiveresume($row->user_id);

if ($id_resume>0)
$link_view = jroute::_('index.php?option=com_jbjobs&view=jobseeker&layout=viewresume&id='.$id_resume.'&tmpl=component&print=1');

//update video end update

$switch = $model->whichuse();

$plan = $model->whichplan($user->id);

$creditpercv = $plan->creditpercv;

?>

<script type="text/javascript">

<!--

var buycredit = "<?php echo jroute::_('index.php?option=com_jbjobs&view=membership&layout=buy_credit');?>";

var buysubscr_e = "<?php echo jroute::_('index.php?option=com_jbjobs&view=membership&layout=planadd');?>";

var buysubscr_j = "<?php echo jroute::_('index.php?option=com_jbjobs&view=membership&layout=planaddjs');?>";



function clrfields(){

var form = document.userformjob;

form.keyword.value = '';

form.id_job_spec.value = '';

form.id_major.value = '';

form.id_job_exp.value = '';

form.id_degree_level.value = '';

form.id_industry.value = '';

form.personal_gender.value = '';

form.id_country.value = '';

form.state.value = '';

form.city.value = '';

}

//-->

</script>

<div class="fsl_h3title"><b><?php echo jtext::_('jbjobs_search_jobseekers'); ?></b></div>



<form action="<?php echo $action; ?>" method="get" name="userformjob" enctype="multipart/form-data">



<table width="100%" cellpadding="0" cellspacing="0">

<tr>

<td><?php echo jtext::_('jbjobs_enter_keyword'); ?></td>

<td><input class="inputbox jbtooltip" type="text" name="keyword" id="keyword" size="40" title="<?php echo jtext::_('jbjobs_tt_resume_keyword'); ?>" value="<?php echo $keyword; ?>" />

<?php $list_phrase = $model->getsearchphrase('phrase', $phrase);

echo $list_phrase;?></td>

</tr>

<tr>

<td><?php echo jtext::_('jbjobs_job_specialization'); ?></td>

<td><?php $list_job_spec = $model->getselectjobspec('id_job_spec',$id_job_spec,'');

echo $list_job_spec;?></td>

</tr>

<tr>

<td><?php echo jtext::_('jbjobs_major'); ?></td>

<td><?php $list_major = $model->getselectmajor('id_major',$id_major,'');

echo $list_major;?></td>

</tr>

<tr>

<td><?php echo jtext::_('jbjobs_experience_level'); ?></td>

<td><?php $list_job_spec = $model->getselectexplevel('id_job_exp', $id_job_exp, '');

echo $list_job_spec;?></td>

</tr>

<tr>

<td><?php echo jtext::_('jbjobs_education_level'); ?></td>

<td><?php $list_job_spec = $model->getselectdegreelevel('id_degree_level', $id_degree_level, '');

echo $list_job_spec;?></td>

</tr>

<tr>

<td><?php echo jtext::_('jbjobs_industry'); ?></td>

<td><?php $list_industry = $model->getselectindustry('id_industry', $id_industry, '');

echo $list_industry; ?></td>

</tr>

<tr>

<td><?php echo jtext::_('jbjobs_gender'); ?></td>

<td><?php $list_industry = $model->malefemale('personal_gender', $gender,1);

echo $list_industry; ?></td>

</tr>

</table>

<table width="100%">

<tr>

<td><strong><?php echo jtext::_('jbjobs_country'); ?></strong></td>

<td ><strong><?php echo jtext::_('jbjobs_state'); ?></strong></td>

<td ><strong><?php echo jtext::_('jbjobs_city'); ?></strong></td>

</tr>

<tr>

<td width="33%"><?php

if($showresult == 1)

$list_country = $model->getselectcountry('id_country', $id_country, '', 'style="width:200px;" onchange="loadaddress(this.value, \'state\')"',1);

else

$list_country = $model->getselectcountry('id_country', 0, '', 'style="width:200px;" onchange="loadaddress(this.value, \'state\')"');



echo $list_country; ?>

</td>

<td width="33%">

<div id="state1" class="fl">

<?php

$list_state = $model->getselectstate('state', $state, 'onchange="loadaddress(this.value, \'city\')"', $id_country);

if($list_state == ''){ ?>

<input class="inputbox" type="text" name="state" id="state" size="35" maxlength="255" value="<?php echo $state; ?>" />

<?php

}

else {

echo $list_state;

} ?>

</div>

<div id="status_state" class="dis-inl-blk fl"></div>

</td>

<td width="33%">

<div id="city1" class="fl">

<?php

$list_city = $model->getselectcity('city', $city, '', $state);

if($list_city == ''){ ?>

<input class="inputbox" type="text" name="city" id="city" size="35" maxlength="255" value="<?php echo $city; ?>" />

<?php

}

else {

echo $list_city;

} ?>

</div>

<div id="status_city" class="dis-inl-blk fl"></div>

</td>

</tr>

<tr>

<td colspan="3" align="center">

<input type="submit" value="<?php echo jtext::_('jbjobs_search'); ?>" class="button" />

<input type="button" value="<?php echo jtext::_('jbjobs_reset'); ?>" class="button" onclick="clrfields();" /><br />

<?php

$link_adv_search = jroute::_('index.php?option=com_jbjobs&view=guest&layout=advsearch');

?>

</td>

</tr>

</table>

<?php

if(!jbjobs_free_mode && $switch == 0){ ?>

<div class="sp10">&nbsp;</div>

<?php echo jtext::sprintf('jbjobs_resume_view_note', $creditpercv);

}

?>



<?php

if(jrequest::getmethod() == 'post' || $showresult == 1){

?>

<?php

if(count($this->rows) > 0) { ?>

<br>

<div class="fsl_h3title"><b><?php echo jtext::_('jbjobs_search_results'); ?></b></div>

<div class="border">

<table width="100%" cellpadding="0" cellspacing="0">

<thead>

<tr class="jbj_rowhead">

<th width="3%"><?php echo jtext::_('#'); ?></th>
<th width="7%"><div align="center"><?php echo jtext::_('image'); ?></div></th>
<th width="7%"><div align="center"><?php echo jtext::_('video resume'); ?></div></th>

<th width="7%"><div align="center"><?php echo jtext::_('jbjobs_jobseeker_name'); ?></div></th>
<th width="10%"><div align="center"><?php echo jtext::_('jbjobs_position'); ?></div></th>

<th width="21%"><div align="center"><?php echo jtext::_('jbjobs_skills_summary'); ?></div></th>

<th width="14%"><div align="center"><?php echo jtext::_('jbjobs_degree_level'); ?></div></th>

<th width="6%" align="center"><div align="center"><?php echo jtext::_('jbjobs_status'); ?></div></th>

<th width="7%" align="center"><div align="center"><?php echo jtext::_('jbjobs_cover'); ?></div></th>

<?php if($switch == 0) : ?>

<th width="9%" align="center"><div align="center"><?php echo jtext::_('jbjobs_preview'); ?></div></th>

<?php endif; ?>

</tr>

</thead>



<tfoot>

<tr>

<td colspan="11" class="jbj_row3"><?php echo $this->pagenav->getlistfooter(); ?></td>

</tr>

</tfoot>



<tbody>

<?php

$k = 0;

for ($i=0, $n=count($this->rows); $i < $n; $i++) {

$row = $this->rows[$i];

$id_cover = $model->getactivecoverletter($row->user_id);


$res_featured = $model->getactiveresumefeatured($row->user_id);

if ($link_cover)

$link_cover = jroute::_('index.php?option=com_jbjobs&view=jobseeker&layout=viewcoverletter&id='.$id_cover.'&print=1&tmpl=component');



switch($switch){

case 1:

$link_jobseeker = jroute::_('index.php?option=com_comprofiler&task=userprofile&user='.$row->user_id);

break;

case 2:

$link_jobseeker = jroute::_('index.php?option=com_community&view=profile&userid='.$row->user_id);

break;

default:

$link_jobseeker = jroute::_('index.php?option=com_jbjobs&view=employer&layout=detailjobseeker&id='.$row->user_id);

$link_prev_resume = jroute::_('index.php?option=com_jbjobs&view=employer&layout=detailjobseeker&id='.$row->user_id.'&preview=1&tmpl=component');

break;

}

?>

<tr class="jbj_<?php echo "row$k"; ?>">

<td><?php echo $this->pagenav->getrowoffset($i); ?></td>
<td><div align="center">
<a href="<?php echo $link_jobseeker; ?>" <?php echo $onclick; ?> ><?php

echo jbjobs::getlogo($row->user_id); ?>
</div></td>
<td><div align="center"><a rel="{handler: 'iframe', size: {x: 750, y: 600}}" href="<?php echo $link_view; ?>" class="modal"><?php echo jtext::_('jbjobs_view'); ?></a></div></td>

<td><div align="center">
<?php

$onclick = '';

if(!jbjobs_free_mode)

if(!$row->hits > 0)

if($this->total_credit < $creditpercv){

$msg = jtext::_('jbjobs_resume_view_not_enough_credit');

$onclick="onclick='nocredit(\"$msg\", \"e\");return false;'";

}

?>
<a href="<?php echo $link_jobseeker; ?>" <?php echo $onclick; ?> ><?php echo ($row->show_name == 'y') ? $row->name : jtext::_('jbjobs_name_confidential'); ?></a>
<?php if(!jbjobs_free_mode_js):?>
<?php if($res_featured): ?>
<span style="float:right;"><img src="components/com_jbjobs/images/f1.png" alt="featured" width="18" title="<?php echo jtext::_('jbjobs_featured_resume');?>" /></span>
<?php endif; ?>
<?php endif; ?>
</div></td>
<td><div align="center"><?php echo $row->current_position; ?></div></td>


<td><div align="center"><?php echo ($row->skill_summary != "") ? nl2br($row->skill_summary) : '<span class="redfont">'.jtext::_('jbjobs_not_mentioned').'</span>'; ?></div></td>

<td><div align="center"><?php echo $row->degree_level; ?></div></td>

<td style="text-align:center;">

<div align="center">
<?php

if(!jbjobs_free_mode){

$ttlviewed = jtext::_('jbjobs_tt_resume_viewed');

$ttlnotviewed = jtext::_('jbjobs_tt_resume_not_viewed');

}

else {

$ttlviewed = jtext::_('jbjobs_tt_resume_viewed_fm');

$ttlnotviewed = jtext::_('jbjobs_tt_resume_not_viewed_fm');

}



if($row->hits > 0) : ?>

<img class="jbtooltip" src="components/com_jbjobs/images/s1.png" title="<?php echo $ttlviewed; ?>" alt="viewed">

<?php else: ?>

<img class="jbtooltip" src="components/com_jbjobs/images/s0.png" title="<?php echo $ttlnotviewed; ?>" alt="not-viewed">

<?php endif; ?>

</div></td>

<td style="text-align:center;"><div align="center">
<?php if($id_cover){ ?>

<a rel="{handler: 'iframe', size: {x: 650, y: 500}}" href="<?php echo $link_cover; ?>" class="modal"><?php echo jtext::_('jbjobs_view'); ?></a>

<?php

}

else{ ?>

<i><?php echo jtext::_('jbjobs_cover_not_found'); ?></i>

<?php }

?>

</div></td>

<?php if($switch == 0) : ?>

<td style="text-align:center;">

<div align="center"><a rel="{handler: 'iframe', size: {x: 650, y: 500}}" href="<?php echo $link_prev_resume; ?>" class="modal"><img src="components/com_jbjobs/images/icosearch.png" width="12" alt="preview"/></a>

</div></td>

<?php endif; ?>

</tr>

<?php

$k = 1 - $k;

}

?>

</tbody>

</table>

</div>



<?php

}

else{

echo '<br><br>'.jtext::_('jbjobs_sorry_search_returned_no_result');

}

?>

<?php

}

?>

<input type="hidden" name="showresult" value="1">

<input type="hidden" name="option" value="com_jbjobs" />

<input type="hidden" name="view" value="employer"/>

<input type="hidden" name="layout" value="findresume"/>

<?php echo jhtml::_('form.token'); ?>

</form>