douleijiang8111 2014-05-10 06:24
浏览 15

使用yii框架,无法在具有两个表的内部联接的重复列名中显示值

I cant display value in repeated column names with inner join of two tables using yii. my view page is advance_search_detail.php and controller sitecontroller.php.I got the error 'Property "Job.Ltitle" is not defined'.Without ltitle in view page i got the search results.

Controller is sitecontroller.php

public function actionadvance_search_result()
{
  $title=$_GET['title'];
  $experience=$_GET['experience'];
  $location=$_GET['location'];
  $category=$_GET['category'];
  $salary_min=$_GET['salary_min'];
  $salary_max=$_GET['salary_max'];

  $criteria = new CDbCriteria();
  $criteria->select = 't.title, location.title as  Ltitle,  t.key_skills, t.description,   t.no_vacancy, t.experience, t.company_name, t.salary';
  $criteria->join = 'INNER JOIN location ON t.location_id = location.id';
  if($experience!="")
  {
    $criteria->addCondition("(title like '%$title%' or  key_skills like '%$title%') and   (   experience like '%$experience%')");    
  }
  if($location!="")
  {
    $criteria->addCondition("location_id like '%$location%'");
  }

  if($category!="")
  {
    $criteria->addCondition("category_id like '%$category%'");
  }
  if($salary_min!="" && $salary_max!="")
  {
    $criteria->addCondition("salary >= '$salary_min' and salary <=  '$salary_max'");
  }

  $count=Job::model()->count($criteria);
  $pages=new CPagination($count);
  $pages->pageSize=2;
  $pages->applyLimit($criteria);
  $model=Job::model()->findAll($criteria);
  $number_rec=count($model);
  if($number_rec<=0)
  {
    $this->render('search_result1',array('model' =>$model));
  }
  else
  {
    $this->render('advance_search_result',array('model' =>$model,'pages' => $pages));
  }
}

My view page is advance_search_result.php

<div>
  <div>
    <h1>Search Results</h1>
    <ul style="list-style:none; ">
    <?php
      foreach($model as $models)  
      {
        $job_id=$models->id;
      ?>
      <li><p><?php //echo $models->title; ?>
          <?php echo CHtml::link($models->title, array('site/advance_search_detail', 'job_id'=>$job_id,'status'=>0)); ?></p>
          <p><?php echo CHtml::link($models->Ltitle); ?></p>
          <p><?php echo $models->company_name; ?></p>
          <p><?php echo $models->description; ?></p>
          <p>Keyskill:<?php echo $models->key_skills; ?><p>
      </li></br>
    <?php
      }
     ?>
    </ul>    
    <p><?php $this->widget('CLinkPager', array('pages' => $pages)) ?></p>   
  </div>
</div>

Anybody give any suggestion for these issue?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度