Ignore:
Timestamp:
2014/03/10 15:23:56 (10 years ago)
Author:
system_friend
Message:

#1768 LC_Page_Admin_Order TEL を数値と扱い、携帯電話の場合にオーバーフローするケースが見られる 
不具合を修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_13-dev/data/class/pages/admin/order/LC_Page_Admin_Order.php

    r23129 r23351  
    192192        $objFormParam->addParam('年齢2', 'search_age2', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 
    193193        $objFormParam->addParam('メールアドレス', 'search_order_email', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 
    194         $objFormParam->addParam('TEL', 'search_order_tel', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 
     194        $objFormParam->addParam('TEL', 'search_order_tel', TEL_LEN, 'n', array('NUM_CHECK','MAX_LENGTH_CHECK')); 
    195195        $objFormParam->addParam('支払い方法', 'search_payment_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 
    196196        $objFormParam->addParam('購入金額1', 'search_total1', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 
     
    312312            case 'search_order_tel': 
    313313                $where .= ' AND (' . $dbFactory->concatColumn(array('order_tel01', 'order_tel02', 'order_tel03')) . ' LIKE ?)'; 
    314                 $arrValues[] = sprintf('%%%d%%', preg_replace('/[()-]+/','', $objFormParam->getValue($key))); 
     314                $arrValues[] = SC_SelectSql_Ex::addSearchStr(preg_replace('/[()-]+/','', $objFormParam->getValue($key))); 
    315315                break; 
    316316            case 'search_order_email': 
Note: See TracChangeset for help on using the changeset viewer.