1.从数据库读取供应商信息,下拉框显示供应商名字,选中的值为供应商id值来查询信息
2.控制器中equal()表示查询字段等于,like()表示查询包含的值
3.action="{:request()->url()}"发送至当前显示页
4.下拉查询中注释的代码为查询时根据查询的字段显示,即便分页跳转页获取到url传递的值默认选中
index_search.html前端搜索代码
<fieldset>
<legend>条件搜索</legend>
<form class="layui-form layui-form-pane form-search" action="{:request()->url()}" onsubmit="return false" method="get" autocomplete="off">
<div class="layui-form-item layui-inline" >
<label class="layui-form-label">供应商</label>
<div class="layui-input-inline">
<select class="layui-select" name="id">
<option value="">-- 选择供应商 --</option>
{foreach $supplierName as $k=>$v}
<!--{eq name='Think.get.id' value='$v.id'}-->
<option selected value="{$v.id}">{$v.gysmc}</option>
<!--{else}-->
<option value="{$v.id}">{$v.gysmc}</option>
<!--{/eq}-->
{/foreach}
</select>
</div>
</div>
<div class="layui-form-item layui-inline">
<label class="layui-form-label">编号</label>
<div class="layui-input-inline">
<input name="gysbh" value="{$Think.get.gysbh|default=''}" placeholder="供应商编号" class="layui-input">
</div>
</div>
<div class="layui-form-item layui-inline">
<label class="layui-form-label">合作品种类别</label>
<div class="layui-input-inline">
<input name="hzpzlb" value="{$Think.get.hzpzlb|default=''}" placeholder="合作品种类别" class="layui-input">
</div>
</div>
<div class="layui-form-item layui-inline">
<button class="layui-btn layui-btn-primary"><i class="layui-icon"></i> 搜 索</button>
</div>
</form>
<script>
window.form.render();
</script>
</fieldset>
Quali.php控制器代码
<?php
namespace app\goods\controller;
use library\Controller;
use app\goods\logic\QualiLogic;
class Quali extends Controller
{
/**
* 绑定数据表
* @var string
*/
protected $table = 'LiuQuali';
//供应商资质查询
public function index()
{
$QualiLogic = new QualiLogic();
$this->title = '供应商资质查询';
//供应商信息
$supplierName = $QualiLogic->SupplierName();
$this->assign('supplierName',$supplierName);
$this->_query($this->table)
->equal('id,')
->like('gysbh,hzpzlb')
->page();
}
QualiLogic.php逻辑类
<?php
namespace app\goods\logic;
use library\Controller;
use app\goods\model\QualiModel;
class QualiLogic extends Controller
{
//获取供应商名
public function SupplierName()
{
return QualiModel::select();
}
}
QualiModel.php模型类
<?php
namespace app\goods\model;
use think\Model;
class QualiModel extends Model
{
protected $table= 'liu_quali';
protected $pk= 'id';
}
显示结果页