2015/03/01
ec-cube
検索キーワードに一覧と詳細の文章も含める
/class/pages/products/LC_Page_Products_List.phpの
// 分割したキーワードを一つずつwhere文に追加
foreach ($names as $val) {
if (strlen($val) > 0) {
$searchCondition['where'] .= ' AND ( alldtl.name ILIKE ? OR alldtl.comment3 ILIKE ?) ';
$searchCondition['arrval'][] = "%$val%";
$searchCondition['arrval'][] = "%$val%";
}
の箇所を下記に修正する。
if ( strlen($val) > 0 ) {
$searchCondition['where'] .= " AND ( alldtl.name ILIKE ? OR alldtl.comment3 ILIKE ? OR alldtl.main_list_comment ILIKE ? OR alldtl.main_comment ILIKE ?) ";
$searchCondition['arrval'][] = "%$val%";
$searchCondition['arrval'][] = "%$val%";
$searchCondition['arrval'][] = "%$val%";
$searchCondition['arrval'][] = "%$val%";
}