public function search()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria=new CDbCriteria;
$criteria->compare('usertest_id',$this->usertest_id,true);
$criteria->compare('usertest_project',$this->usertest_project,true);
$criteria->compare('usertest_imei',$this->usertest_imei,true);
//$criteria->compare('usertest_sw',$this->usertest_sw,true);
$whereSql = "usertest_sw like '"; //Y2A5HA80BR20 Y2A5GD80BR10 Y2A5*80BR20 usertest_sw like '%Y2A5%80BR20%'
$keyword = $this->usertest_sw;
$keyarr=explode('*',$keyword);
for($index = 0; $index < count($keyarr); $index++) {
$whereSql .= "%$keyarr[$index]";
}
$whereSql .= "%'";
$criteria->addCondition($whereSql);
$criteria->compare('usertest_package',$this->usertest_package,true);
$criteria->compare('usertest_type',$this->usertest_type,true);
$criteria->compare('usertest_logtime',$this->usertest_logtime,true);
$criteria->compare('usertest_cu',$this->usertest_cu,true);
$criteria->compare('usertest_localtime',$this->usertest_localtime,true);
$criteria->compare('usertest_logpath',$this->usertest_logpath,true);
$criteria->compare('usertest_logkeyinfo',$this->usertest_logkeyinfo,true);
$criteria->compare('usertest_bugid',$this->usertest_bugid,true);
$criteria->compare('usertest_bugstatus',$this->usertest_bugstatus,true);
$criteria->compare('usertest_comments',$this->usertest_comments,true);
$criteria->compare('usertest_userinfo',$this->usertest_userinfo,true);
$criteria->compare('usertest_repeatcount',$this->usertest_repeatcount,true);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
'sort'=>array(
'defaultOrder'=>'usertest_logtime desc',
),
));
}以上就介绍了Yii 添加自己的搜索条件,包括了方面的内容,希望对PHP教程有兴趣的朋友有所帮助。
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号