Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //検索対象追加フィールドを拡張
- function fn_my_product_extend_additional_fields_in_search(&$params, &$fields, $sortings, $condition, &$join, $sorting, $group_by, &$tmp, $piece, $having)
- {
- $params['pshort'] = 'Y';//ショート説明を含める
- $params['pfull'] = 'Y';//フル説明を含める
- $params['pkeywords'] = 'Y';//METAキーワードを含める
- //独自テーブルをJOIN
- if(AREA == 'A'){
- $join .= " LEFT JOIN ?:products_ex AS products_ex ON products_ex.product_id = products.product_id";
- }
- ///////////////////以下検索対象とする
- //カタログ番号
- $tmp .= db_quote(" OR products_ex.catelog_no LIKE ?l", '%' . $params['q'] . '%');
- //カタログ品名
- $tmp .= db_quote(" OR products_ex.catelog_name LIKE ?l", '%' . $params['q'] . '%');
- //メーカー品番
- $tmp .= db_quote(" OR products_ex.maker_item_code LIKE ?l", '%' . $params['q'] . '%');
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement