|
This example shows the full potential of toolbar search.
Column option search_op defines the search method for each column.
Try the following searches:
1. 1,2,3 for column ID (IN search)
2. >10 for column Order id (Numeric search)
3. Any delivery type (Equal search)
4. Any on Delivery cost (nothing will happen)
5. ohn for column Customer name (LIKE search)
6. jQuery for column Book name (custom search)
7. 123 for column Book name (custom search - will find books by id)
8. <=100 for column Price (auto search assumed numeric search)
Этот пример показывает весь потенциал автоматического поиска.
Опция search_op определеяет метод поиска для каждой колонки.
Попробуйте поискать:
1. 1,2,3 в колонке ID (id 1, 2 и 3)
2. >10 в колонке Order id (order_id больше 10)
3. Любой тип доставки
4. Любое значение в Delivery cost (ничего не произойдет - ignore)
5. ohn в колонке Customer name (LIKE '%ohn%')
6. jQuery в колонке Book name (пользовательский поиск - строки ищет LIKE'ом)
7. 123 в колонке Book name (пользовательский поиск - числа ищет по ID в другой колонке)
8. <=100 в колонке Price (цена меньше или равна 100)
higrid.net嗨网提供电子表格、在线图形等互联网开发及运营技术，提供相关资料及软件下载，分享奇趣网络时事评论！欢迎访问。
部分内容为俄文，higrid计划翻译一下。敬请期待！
php代码和js代码请点击tab查看。
<?php
class jqOutSearch extends jqGrid
{
protected function init()
{
$delivery_types = $this->getDeliveryTypes();
$this->table = 'tbl_order_item';
$this->query = "
SELECT {fields}
FROM tbl_order_item i
JOIN tbl_books b ON (i.book_id=b.id)
JOIN tbl_order o ON (i.order_id=o.id)
JOIN tbl_customer c ON (c.id=o.customer_id)
WHERE {where}
";
#Set columns
$this->cols = array(
'id' => array('label' => 'ID',
'db' => 'i.id',
'width' => 10,
'align' => 'center',
'formatter' => 'integer',
'search_op' => 'in', //IN (1,2,3)
),
'order_id' => array('label' => 'Order id',
'db' => 'i.order_id',
'width' => 15,
'align' => 'center',
'formatter' => 'integer',
'search_op' => 'numeric', //numeric ops
),
'delivery_type' => array('label' => 'Delivery',
'db' => 'o.delivery_type',
'width' => 20,
'replace' => $delivery_types,
'stype' => 'select',
'searchoptions' => array(
'value' => new jqGrid_Data_Value($delivery_types, 'All'),
),
'search_op' => 'equal', //exact match
),
'delivery_cost' => array('label' => 'Deliv. cost',
'db' => 'o.delivery_cost',
'width' => 15,
'align' => 'center',
'search_op' => 'ignore', //searching is totally ignored
),
'customer_name' => array('label' => 'Customer name',
'db' => "CONCAT(c.first_name, ' ', c.last_name)",
'width' => 20,
'search_op' => 'like', //LIKE '%value%'
),
'name' => array('label' => 'Book name',
'db' => 'b.name',
'width' => 30,
'search_op' => 'book', //custom search -> searchOpBooks
),
'price' => array('label' => 'Price',
'db' => 'i.price',
'width' => 15,
'align' => 'center',
'formatter' => 'integer',
'search_op' => 'auto', //auto recognize search type (default)
),
);
$this->render_filter_toolbar = true;
}
#Custom search operation
protected function searchOpBook($c, $val)
{
#If numeric input -> search by book id
if(is_numeric($val))
{
return "b.id='$val'";
}
#Non-numeric? Perform common 'LIKE' search by book name
else
{
return parent::searchOpLike($c, $val);
}
}
protected function getDeliveryTypes()
{
$result = $this->DB->query("SELECT * FROM lst_delivery_types");
$rows = array();
while($r = $this->DB->fetch($result))
{
$rows[$r['id']] = $r['name'];
}
return $rows;
}
protected function renderPostData()
{
$data = array();
foreach(array_intersect_key($this->input, $this->cols) as $k => $v)
{
$data[$k] = $v;
}
return $data;
}
protected function renderColumn($c)
{
if($this->input($c['name']))
{
$c['searchoptions']['defaultValue'] = $this->input($c['name']);
}
return $c;
}
}
<script>
<?= $rendered_grid ?>
</script>
|