[Svn-src-all:1391] [version-2_5-dev 20281] #963 [管理画面]メルマガ管理リファクタリング 検索ボックスのフォーム名にsearch_をつけた #965[管理画面]顧客管理と被りそうなので一部先行コミット
fukuda
admin ＠ mail.ec-cube.net
2011年 2月 21日 (月) 02:13:45 JST
Subversion committed to /home/svn/open 20281
http://svn.ec-cube.net/open_trac/changeset/20281
┌────────────────────────────┐
│更新者 : fukuda │
│更新日時: 2011-02-21 02:13:44 +0900 (月, 21 2月 2011)│
└────────────────────────────┘
Log:
--------------------------------------------------------
#963 [管理画面]メルマガ管理リファクタリング 検索ボックスのフォーム名にsearch_をつけた #965[管理画面]顧客管理と被りそうなので一部先行コミット
Changed: [U:修正，A:追加，D:削除]
--------------------------------------------------------
U branches/version-2_5-dev/data/Smarty/templates/admin/adminparts/form_customer_search.tpl
U branches/version-2_5-dev/data/class/SC_CustomerList.php
U branches/version-2_5-dev/data/class/helper/SC_Helper_Customer.php
変更: branches/version-2_5-dev/data/Smarty/templates/admin/adminparts/form_customer_search.tpl
===================================================================
--- branches/version-2_5-dev/data/Smarty/templates/admin/adminparts/form_customer_search.tpl 2011-02-20 17:00:17 UTC (rev 20280)
+++ branches/version-2_5-dev/data/Smarty/templates/admin/adminparts/form_customer_search.tpl 2011-02-20 17:13:44 UTC (rev 20281)
@@ -1,164 +1,235 @@
<tr>
<th>顧客ID</th>
- <td><!--{if $arrErr.customer_id}--><span class="attention"><!--{$arrErr.customer_id}--></span><br /><!--{/if}--><input type="text" name="customer_id" maxlength="<!--{$smarty.const.INT_LEN}-->" value="<!--{$arrForm.customer_id|h}-->" size="30" class="box30" <!--{if $arrErr.customer_id}--><!--{sfSetErrorStyle}--><!--{/if}--> /></td>
+ <td>
+ <!--{assign var=key value="search_customer_id"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><br /><!--{/if}-->
+ <input type="text" name="<!--{$key}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key].value|h}-->" size="30" class="box30" <!--{if $arrErr[$key]}--><!--{sfSetErrorStyle}--><!--{/if}--> /></td>
<th>都道府県</th>
<td>
- <!--{if $arrErr.pref}--><span class="attention"><!--{$arrErr.pref}--></span><br /><!--{/if}-->
- <select class="top" name="pref">
- <option value="" selected="selected" <!--{if $arrErr.name}--><!--{sfSetErrorStyle}--><!--{/if}-->>都道府県を選択</option>
- <!--{html_options options=$arrPref selected=$arrForm.pref}-->
+ <!--{assign var=key value="search_pref"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><br /><!--{/if}-->
+ <select class="top" name="<!--{$key}-->">
+ <option value="" selected="selected" <!--{if $arrErr[$key]}--><!--{sfSetErrorStyle}--><!--{/if}-->>都道府県を選択</option>
+ <!--{html_options options=$arrPref selected=$arrForm[$key].value}-->
</select>
</td>
</tr>
<tr>
<th>顧客名</th>
- <td><!--{if $arrErr.name}--><span class="attention"><!--{$arrErr.name}--></span><br /><!--{/if}--><input type="text" name="name" maxlength="<!--{$smarty.const.STEXT_LEN}-->" value="<!--{$arrForm.name|h}-->" size="30" class="box30" <!--{if $arrErr.name}--><!--{sfSetErrorStyle}--><!--{/if}--> /></td>
+ <td>
+ <!--{assign var=key value="search_name"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><br /><!--{/if}-->
+ <input type="text" name="<!--{$key}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key].value|h}-->" size="30" class="box30" <!--{if $arrErr[$key]}--><!--{sfSetErrorStyle}--><!--{/if}--> />
+ </td>
<th>顧客名(カナ)</th>
- <td><!--{if $arrErr.kana}--><span class="attention"><!--{$arrErr.kana}--></span><br /><!--{/if}--><input type="text" name="kana" maxlength="<!--{$smarty.const.STEXT_LEN}-->" value="<!--{$arrForm.kana|h}-->" size="30" class="box30" <!--{if $arrErr.kana}--><!--{sfSetErrorStyle}--><!--{/if}--> /></td>
+ <td>
+ <!--{assign var=key value="search_kana"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><br /><!--{/if}-->
+ <input type="text" name="<!--{$key}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key].value|h}-->" size="30" class="box30" <!--{if $arrErr[$key]}--><!--{sfSetErrorStyle}--><!--{/if}--> />
+ </td>
</tr>
<tr>
<th>性別</th>
- <td><!--{html_checkboxes name="sex" options=$arrSex separator=" " selected=$arrForm.sex}--></td>
+ <td>
+ <!--{assign var=key value="search_sex"}-->
+ <!--{html_checkboxes name=$key options=$arrSex separator=" " selected=$arrForm[$key].value}-->
+ </td>
<th>誕生月</th>
- <td><!--{if $arrErr.birth_month}--><span class="attention"><!--{$arrErr.birth_month}--></span><br /><!--{/if}-->
- <select name="birth_month" style="<!--{$arrErr.birth_month|sfGetErrorColor}-->" >
+ <td>
+ <!--{assign var=key value="search_birth_month"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><br /><!--{/if}-->
+ <select name="<!--{$key}-->" style="<!--{$arrErr[$key]|sfGetErrorColor}-->" >
<option value="" selected="selected">--</option>
- <!--{html_options options=$objDate->getMonth() selected=$arrForm.birth_month}-->
+ <!--{html_options options=$objDate->getMonth() selected=$arrForm[$key].value}-->
</select>月
</td>
</tr>
<tr>
<th>誕生日</th>
<td colspan="3">
- <!--{if $arrErr.b_start_year || $arrErr.b_end_year}--><span class="attention"><!--{$arrErr.b_start_year}--><!--{$arrErr.b_end_year}--></span><br /><!--{/if}-->
- <select name="b_start_year" <!--{if $arrErr.b_start_year || $arrErr.b_end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=errkey1 value="search_b_start_year"}-->
+ <!--{assign var=errkey2 value="search_b_end_year"}-->
+ <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><span class="attention"><!--{$arrErr[$errkey1]}--><!--{$arrErr[$errkey2]}--></span><br /><!--{/if}-->
+ <!--{assign var=key value="search_b_start_year"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">----</option>
- <!--{html_options options=$arrYear selected=$arrForm.b_start_year}-->
+ <!--{html_options options=$arrYear selected=$arrForm[$key].value}-->
</select>年
- <select name="b_start_month" <!--{if $arrErr.b_start_year || $arrErr.b_end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_b_start_month"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrMonth selected=$arrForm.b_start_month}-->
+ <!--{html_options options=$arrMonth selected=$arrForm[$key].value}-->
</select>月
- <select name="b_start_day" <!--{if $arrErr.b_start_year || $arrErr.b_end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_b_start_day"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrDay selected=$arrForm.b_start_day}-->
+ <!--{html_options options=$arrDay selected=$arrForm[$key].value}-->
</select>日〜
- <select name="b_end_year" <!--{if $arrErr.b_start_year || $arrErr.b_end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_b_end_year"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">----</option>
- <!--{html_options options=$arrYear selected=$arrForm.b_end_year}-->
+ <!--{html_options options=$arrYear selected=$arrForm[$key].value}-->
</select>年
- <select name="b_end_month" <!--{if $arrErr.b_start_year || $arrErr.b_end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_b_end_month"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrMonth selected=$arrForm.b_end_month}-->
+ <!--{html_options options=$arrMonth selected=$arrForm[$key].value}-->
</select>月
- <select name="b_end_day" <!--{if $arrErr.b_start_year || $arrErr.b_end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_b_end_day"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrDay selected=$arrForm.b_end_day}-->
+ <!--{html_options options=$arrDay selected=$arrForm[$key].value}-->
</select>日
</td>
</tr>
<tr>
<th>メールアドレス</th>
- <td colspan="3"><!--{if $arrErr.email}--><span class="attention"><!--{$arrErr.email}--></span><!--{/if}--><input type="text" name="email" maxlength="<!--{$smarty.const.STEXT_LEN}-->" value="<!--{$arrForm.email|h}-->" size="60" class="box60" <!--{if $arrErr.email}--><!--{sfSetErrorStyle}--><!--{/if}-->/></td>
+ <td colspan="3">
+ <!--{assign var=key value="search_email"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><!--{/if}-->
+ <input type="text" name="<!--{$key}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key].value|h}-->" size="60" class="box60" <!--{if $arrErr[$key]}--><!--{sfSetErrorStyle}--><!--{/if}-->/>
+ </td>
</tr>
<tr>
<th>携帯メールアドレス</th>
- <td colspan="3"><!--{if $arrErr.email_mobile}--><span class="attention"><!--{$arrErr.email_mobile}--></span><!--{/if}--><input type="text" name="email_mobile" maxlength="<!--{$smarty.const.STEXT_LEN}-->" value="<!--{$arrForm.email_mobile|h}-->" size="60" class="box60" <!--{if $arrErr.email_mobile}--><!--{sfSetErrorStyle}--><!--{/if}-->/></td>
+ <td colspan="3">
+ <!--{assign var=key value="search_email_mobile"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><!--{/if}-->
+ <input type="text" name="<!--{$key}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key].value|h}-->" size="60" class="box60" <!--{if $arrErr[$key]}--><!--{sfSetErrorStyle}--><!--{/if}-->/></td>
</tr>
<tr>
<th>電話番号</th>
- <td colspan="3"><!--{if $arrErr.tel}--><span class="attention"><!--{$arrErr.tel}--></span><br /><!--{/if}--><input type="text" name="tel" maxlength="<!--{$smarty.const.TEL_LEN}-->" value="<!--{$arrForm.tel|h}-->" size="60" class="box60" /></td>
+ <td colspan="3">
+ <!--{assign var=key value="search_tel"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><br /><!--{/if}-->
+ <input type="text" name="<!--{$key}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key].value|h}-->" size="60" class="box60" /></td>
</tr>
<tr>
<th>職業</th>
- <td colspan="3"><!--{html_checkboxes name="job" options=$arrJob separator=" " selected=$arrForm.job}--></td>
+ <td colspan="3">
+ <!--{assign var=key value="search_job"}-->
+ <!--{html_checkboxes name=$key options=$arrJob separator=" " selected=$arrForm[$key].value}--></td>
</tr>
<tr>
<th>購入金額</th>
- <td><!--{if $arrErr.buy_total_from || $arrErr.buy_total_to}--><span class="attention"><!--{$arrErr.buy_total_from}--><!--{$arrErr.buy_total_to}--></span><br /><!--{/if}--><input type="text" name="buy_total_from" maxlength="<!--{$smarty.const.INT_LEN}-->" value="<!--{$arrForm.buy_total_from|h}-->" size="6" class="box6" <!--{if $arrErr.buy_total_from || $arrErr.buy_total_to}--><!--{sfSetErrorStyle}--><!--{/if}--> /> 円 〜 <input type="text" name="buy_total_to" maxlength="<!--{$smarty.const.INT_LEN}-->" value="<!--{$arrForm.buy_total_to|h}-->" size="6" class="box6" <!--{if $arrErr.buy_total_from || $arrErr.buy_total_to}--><!--{sfSetErrorStyle}--><!--{/if}--> /> 円</td>
+ <td>
+ <!--{assign var=key1 value="search_buy_total_from"}-->
+ <!--{assign var=key2 value="search_buy_total_to"}-->
+ <!--{if $arrErr[$key1] || $arrErr[$key2]}--><span class="attention">
+ <!--{$arrErr[$key1]}--><!--{$arrErr[$key2]}--></span><br />
+ <!--{/if}-->
+ <input type="text" name="<!--{$key1}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key1].value|h}-->" size="6" class="box6" <!--{if $arrErr[$key1] || $arrErr[$key2]}--><!--{sfSetErrorStyle}--><!--{/if}--> /> 円 〜
+ <input type="text" name="<!--{$key2}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key2].value|h}-->" size="6" class="box6" <!--{if $arrErr[$key1] || $arrErr[$key2]}--><!--{sfSetErrorStyle}--><!--{/if}--> /> 円
+ </td>
<th>購入回数</th>
- <td><!--{if $arrErr.buy_times_from || $arrErr.buy_times_to}--><span class="attention"><!--{$arrErr.buy_times_from}--><!--{$arrErr.buy_times_to}--></span><br /><!--{/if}--><input type="text" name="buy_times_from" maxlength="<!--{$smarty.const.INT_LEN}-->" value="<!--{$arrForm.buy_times_from|h}-->" size="6" class="box6" <!--{if $arrErr.buy_times_from || $arrErr.buy_times_to}--><!--{sfSetErrorStyle}--><!--{/if}--> /> 回 〜 <input type="text" name="buy_times_to" maxlength="<!--{$smarty.const.INT_LEN}-->" value="<!--{$arrForm.buy_times_to|h}-->" size="6" class="box6" <!--{if $arrErr.buy_times_from || $arrErr.buy_times_to}--><!--{sfSetErrorStyle}--><!--{/if}--> /> 回</td>
+ <td>
+ <!--{assign var=key1 value="search_buy_times_from"}-->
+ <!--{assign var=key2 value="search_buy_times_to"}-->
+ <!--{if $arrErr.buy_times_from || $arrErr.buy_times_to}-->
+ <span class="attention"><!--{$arrErr.buy_times_from}--><!--{$arrErr.buy_times_to}--></span><br />
+ <!--{/if}-->
+ <input type="text" name="<!--{$key1}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key1].value|h}-->" size="6" class="box6" <!--{if $arrErr[$key1] || $arrErr[$key2]}--><!--{sfSetErrorStyle}--><!--{/if}--> /> 回 〜
+ <input type="text" name="<!--{$key2}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key2].value|h}-->" size="6" class="box6" <!--{if $arrErr[$key1] || $arrErr[$key2]}--><!--{sfSetErrorStyle}--><!--{/if}--> /> 回</td>
</tr>
<tr>
<th>登録・更新日</th>
<td colspan="3">
- <!--{if $arrErr.start_year || $arrErr.end_year}--><span class="attention"><!--{$arrErr.start_year}--><!--{$arrErr.end_year}--></span><br /><!--{/if}-->
- <select name="start_year" <!--{if $arrErr.start_year || $arrErr.end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=errkey1 value="search_start_year"}-->
+ <!--{assign var=errkey2 value="search_end_year"}-->
+ <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><span class="attention"><!--{$arrErr[$errkey1]}--><!--{$arrErr[$errkey2]}--></span><br /><!--{/if}-->
+ <!--{assign var=key value="search_start_year"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">----</option>
- <!--{html_options options=$arrYear selected=$arrForm.start_year}-->
+ <!--{html_options options=$arrYear selected=$arrForm[$key].value}-->
</select>年
- <select name="start_month" <!--{if $arrErr.start_year || $arrErr.end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_start_month"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrMonth selected=$arrForm.start_month}-->
+ <!--{html_options options=$arrMonth selected=$arrForm[$key].value}-->
</select>月
- <select name="start_day" <!--{if $arrErr.start_year || $arrErr.end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_start_day"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrDay selected=$arrForm.start_day}-->
+ <!--{html_options options=$arrDay selected=$arrForm[$key].value}-->
</select>日〜
- <select name="end_year" <!--{if $arrErr.start_year || $arrErr.end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_end_year"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">----</option>
- <!--{html_options options=$arrYear selected=$arrForm.end_year}-->
+ <!--{html_options options=$arrYear selected=$arrForm[$key].value}-->
</select>年
- <select name="end_month" <!--{if $arrErr.start_year || $arrErr.end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_end_month"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrMonth selected=$arrForm.end_month}-->
+ <!--{html_options options=$arrMonth selected=$arrForm[$key].value}-->
</select>月
- <select name="end_day" <!--{if $arrErr.start_year || $arrErr.end_year}--><!--{sfSetErrorStyle}--><!--{/if}-->>
+ <!--{assign var=key value="search_end_day"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrDay selected=$arrForm.end_day}-->
+ <!--{html_options options=$arrDay selected=$arrForm[$key].value}-->
</select>日
</td>
</tr>
<tr>
<th>最終購入日</th>
<td colspan="3">
- <!--{if $arrErr.buy_start_year || $arrErr.buy_end_year}--><span class="attention"><!--{$arrErr.buy_start_year}--><!--{$arrErr.buy_end_year}--></span><br /><!--{/if}-->
- <select name="buy_start_year" style="<!--{$arrErr.buy_start_year|sfGetErrorColor}-->">
+ <!--{assign var=errkey1 value="search_buy_start_year"}-->
+ <!--{assign var=errkey2 value="search_buy_end_year"}-->
+ <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><span class="attention"><!--{$arrErr[$errkey1]}--><!--{$arrErr[$errkey2]}--></span><br /><!--{/if}-->
+ <!--{assign var=key value="search_buy_start_year"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">----</option>
- <!--{html_options options=$objDate->getYear($smarty.const.RELEASE_YEAR) selected=$arrForm.buy_start_year}-->
+ <!--{html_options options=$arrYear selected=$arrForm[$key].value}-->
</select>年
- <select name="buy_start_month" style="<!--{$arrErr.buy_start_year|sfGetErrorColor}-->">
+ <!--{assign var=key value="search_buy_start_month"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrMonth selected=$arrForm.buy_start_month}-->
+ <!--{html_options options=$arrMonth selected=$arrForm[$key].value}-->
</select>月
- <select name="buy_start_day" style="<!--{$arrErr.buy_start_year|sfGetErrorColor}-->">
+ <!--{assign var=key value="search_buy_start_day"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrDay selected=$arrForm.buy_start_day}-->
+ <!--{html_options options=$arrDay selected=$arrForm[$key].value}-->
</select>日〜
- <select name="buy_end_year" style="<!--{$arrErr.buy_end_year|sfGetErrorColor}-->">
+ <!--{assign var=key value="search_buy_end_year"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">----</option>
- <!--{html_options options=$objDate->getYear($smarty.const.RELEASE_YEAR) selected=$arrForm.buy_end_year}-->
+ <!--{html_options options=$arrYear selected=$arrForm[$key].value}-->
</select>年
- <select name="buy_end_month" style="<!--{$arrErr.buy_end_year|sfGetErrorColor}-->">
+ <!--{assign var=key value="search_buy_end_month"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrMonth selected=$arrForm.buy_end_month}-->
+ <!--{html_options options=$arrMonth selected=$arrForm[$key].value}-->
</select>月
- <select name="buy_end_day" style="<!--{$arrErr.buy_end_year|sfGetErrorColor}-->">
+ <!--{assign var=key value="search_buy_end_day"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey1] || $arrErr[$errkey2]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="" selected="selected">--</option>
- <!--{html_options options=$arrDay selected=$arrForm.buy_end_day}-->
+ <!--{html_options options=$arrDay selected=$arrForm[$key].value}-->
</select>日
</td>
</tr>
<tr>
<th>購入商品名</th>
<td>
- <!--{if $arrErr.buy_product_name}--><span class="attention"><!--{$arrErr.buy_product_name}--></span><!--{/if}-->
- <span style="<!--{$arrErr.buy_product_name|sfGetErrorColor}-->">
- <input type="text" name="buy_product_name" maxlength="<!--{$smarty.const.STEXT_LEN}-->" value="<!--{$arrForm.buy_product_name|h}-->" size="30" class="box30" style="<!--{$arrErr.buy_product_name|sfGetErrorColor}-->"/>
+ <!--{assign var=key value="search_buy_product_name"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><!--{/if}-->
+ <span style="<!--{$arrErr[$key]|sfGetErrorColor}-->">
+ <input type="text" name="<!--{$key}-->" maxlength="<!--{$arrForm[$key].length}-->" value="<!--{$arrForm[$key].value|h}-->" size="30" class="box30" style="<!--{$arrErr[$key]|sfGetErrorColor}-->"/>
</span>
</td>
<th>購入商品コード</th>
<td>
- <!--{if $arrErr.buy_product_code}--><span class="attention"><!--{$arrErr.buy_product_code}--></span><!--{/if}-->
- <input type="text" name="buy_product_code" value="<!--{$arrForm.buy_product_code}-->" maxlength="<!--{$smarty.const.STEXT_LEN}-->" size="30" class="box30" style="<!--{$arrErr.buy_product_code|sfGetErrorColor}-->" >
+ <!--{assign var=key value="search_buy_product_code"}-->
+ <!--{if $arrErr[$key]}--><span class="attention"><!--{$arrErr[$key]}--></span><!--{/if}-->
+ <input type="text" name="<!--{$key}-->" value="<!--{$arrForm[$key].value}-->" maxlength="<!--{$arrForm[$key].length}-->" size="30" class="box30" style="<!--{$arrErr[$key]|sfGetErrorColor}-->" >
</td>
</tr>
<tr>
<th>カテゴリ</th>
<td colspan="3">
- <select name="category_id" style="<!--{if $arrErr.category_id != ""}-->background-color: <!--{$smarty.const.ERR_COLOR}-->;<!--{/if}-->">
+ <!--{assign var=key value="search_category_id"}-->
+ <select name="<!--{$key}-->" <!--{if $arrErr[$errkey]}--><!--{sfSetErrorStyle}--><!--{/if}-->>
<option value="">選択してください</option>
- <!--{html_options options=$arrCatList selected=$arrForm.category_id}-->
+ <!--{html_options options=$arrCatList selected=$arrForm[$key].value}-->
</select>
</td>
</tr>
\ No newline at end of file
変更: branches/version-2_5-dev/data/class/SC_CustomerList.php
===================================================================
--- branches/version-2_5-dev/data/class/SC_CustomerList.php 2011-02-20 17:00:17 UTC (rev 20280)
+++ branches/version-2_5-dev/data/class/SC_CustomerList.php 2011-02-20 17:13:44 UTC (rev 20281)
@@ -50,59 +50,59 @@
}
// 顧客ID
- if (!isset($this->arrSql['customer_id'])) $this->arrSql['customer_id'] = "";
- if ( strlen($this->arrSql['customer_id']) > 0 ) {
+ if (!isset($this->arrSql['search_customer_id'])) $this->arrSql['search_customer_id'] = "";
+ if ( strlen($this->arrSql['search_customer_id']) > 0 ) {
$this->setWhere( "customer_id = ?" );
- $this->arrVal[] = $this->arrSql['customer_id'];
+ $this->arrVal[] = $this->arrSql['search_customer_id'];
}
// 名前
- if (!isset($this->arrSql['name'])) $this->arrSql['name'] = "";
- if ( strlen($this->arrSql['name']) > 0 ) {
+ if (!isset($this->arrSql['search_name'])) $this->arrSql['search_name'] = "";
+ if ( strlen($this->arrSql['search_name']) > 0 ) {
$this->setWhere("(" . $dbFactory->concatColumn(array("name01", "name02")) . " LIKE ?)" );
- $searchName = $this->addSearchStr($this->arrSql['name']);
+ $searchName = $this->addSearchStr($this->arrSql['search_name']);
$this->arrVal[] = mb_ereg_replace("[ ]+","",$searchName);
}
// 名前(カナ)
- if (!isset($this->arrSql['kana'])) $this->arrSql['kana'] = "";
- if ( strlen($this->arrSql['kana']) > 0 ) {
+ if (!isset($this->arrSql['search_kana'])) $this->arrSql['search_kana'] = "";
+ if ( strlen($this->arrSql['search_kana']) > 0 ) {
$this->setWhere("(" . $dbFactory->concatColumn(array("kana01", "kana02")) . " LIKE ?)" );
- $searchKana = $this->addSearchStr($this->arrSql['kana']);
+ $searchKana = $this->addSearchStr($this->arrSql['search_kana']);
$this->arrVal[] = mb_ereg_replace("[ ]+","",$searchKana);
}
// 都道府県
- if (!isset($this->arrSql['pref'])) $this->arrSql['pref'] = "";
- if ( strlen($this->arrSql['pref']) > 0 ) {
+ if (!isset($this->arrSql['search_pref'])) $this->arrSql['search_pref'] = "";
+ if ( strlen($this->arrSql['search_pref']) > 0 ) {
$this->setWhere( "pref = ?" );
- $this->arrVal[] = $this->arrSql['pref'];
+ $this->arrVal[] = $this->arrSql['search_pref'];
}
// 電話番号
- if (!isset($this->arrSql['tel'])) $this->arrSql['tel'] = "";
- if ( is_numeric( $this->arrSql['tel'] ) ) {
+ if (!isset($this->arrSql['search_tel'])) $this->arrSql['search_tel'] = "";
+ if ( is_numeric( $this->arrSql['search_tel'] ) ) {
$this->setWhere("(" . $dbFactory->concatColumn(array("tel01", "tel02", "tel03")) . " LIKE ?)" );
- $searchTel = $this->addSearchStr($this->arrSql['tel']);
+ $searchTel = $this->addSearchStr($this->arrSql['search_tel']);
$this->arrVal[] = ereg_replace("-", "", $searchTel);
}
// 性別
- if (!isset($this->arrSql['sex'])) $this->arrSql['sex'] = "";
- if ( is_array( $this->arrSql['sex'] ) ){
- $arrSexVal = $this->setItemTerm( $this->arrSql['sex'] ,"sex" );
+ if (!isset($this->arrSql['search_sex'])) $this->arrSql['search_sex'] = "";
+ if ( is_array( $this->arrSql['search_sex'] ) ){
+ $arrSexVal = $this->setItemTerm( $this->arrSql['search_sex'] ,"sex" );
foreach ($arrSexVal as $data) {
$this->arrVal[] = $data;
}
}
// 職業
- if (!isset($this->arrSql['job'])) $this->arrSql['job'] = "";
- if ( is_array( $this->arrSql['job'] ) ){
- if ( in_array("不明", $this->arrSql['job'] ) ) {
- $arrJobVal = $this->setItemTermWithNull( $this->arrSql['job'] ,"job" );
+ if (!isset($this->arrSql['search_job'])) $this->arrSql['search_job'] = "";
+ if ( is_array( $this->arrSql['search_job'] ) ){
+ if ( in_array("不明", $this->arrSql['search_job'] ) ) {
+ $arrJobVal = $this->setItemTermWithNull( $this->arrSql['search_job'] ,"job" );
} else {
- $arrJobVal = $this->setItemTerm( $this->arrSql['job'] ,"job" );
+ $arrJobVal = $this->setItemTerm( $this->arrSql['search_job'] ,"job" );
}
if (is_array($arrJobVal)) {
foreach ($arrJobVal as $data) {
@@ -112,12 +112,12 @@
}
// E-MAIL
- if (!isset($this->arrSql['email'])) $this->arrSql['email'] = "";
- if (strlen($this->arrSql['email']) > 0) {
+ if (!isset($this->arrSql['search_email'])) $this->arrSql['search_email'] = "";
+ if (strlen($this->arrSql['search_email']) > 0) {
//カンマ区切りで複数の条件指定可能に
- $this->arrSql['email'] = explode(",", $this->arrSql['email']);
+ $this->arrSql['search_email'] = explode(",", $this->arrSql['search_email']);
$sql_where = "";
- foreach($this->arrSql['email'] as $val) {
+ foreach($this->arrSql['search_email'] as $val) {
$val = trim($val);
//検索条件を含まない
if($this->arrSql['not_emailinc'] == '1') {
@@ -140,13 +140,13 @@
}
// E-MAIL(mobile)
- if (!isset($this->arrSql['email_mobile'])) $this->arrSql['email_mobile'] = "";
+ if (!isset($this->arrSql['search_email_mobile'])) $this->arrSql['search_email_mobile'] = "";
- if (strlen($this->arrSql['email_mobile']) > 0) {
+ if (strlen($this->arrSql['search_email_mobile']) > 0) {
//カンマ区切りで複数の条件指定可能に
- $this->arrSql['email_mobile'] = explode(",", $this->arrSql['email_mobile']);
+ $this->arrSql['search_email_mobile'] = explode(",", $this->arrSql['search_email_mobile']);
$sql_where = "";
- foreach($this->arrSql['email_mobile'] as $val) {
+ foreach($this->arrSql['search_email_mobile'] as $val) {
$val = trim($val);
//検索条件を含まない
if($this->arrSql['not_email_mobileinc'] == '1') {
@@ -171,10 +171,10 @@
// メールマガジンの場合
if($mode == "customer") {
// メルマガ受け取りの選択項目がフォームに存在する場合
- if ( isset($this->arrSql['htmlmail'])){
- if (SC_Utils_Ex::sfIsInt($this->arrSql['htmlmail'])){
+ if ( isset($this->arrSql['search_htmlmail'])){
+ if (SC_Utils_Ex::sfIsInt($this->arrSql['search_htmlmail'])){
$this->setWhere("mailmaga_flg = ?");
- $this->arrVal[] = $this->arrSql['htmlmail'];
+ $this->arrVal[] = $this->arrSql['search_htmlmail'];
} else {
// メルマガ購読拒否は省く
$this->setWhere("mailmaga_flg <> 3");
@@ -184,9 +184,9 @@
// 配信メールアドレス種別
if ( $mode == 'customer' ){
- if (isset($this->arrSql['mail_type'])){
+ if (isset($this->arrSql['search_mail_type'])){
$sqlEmailMobileIsEmpty = "(dtb_customer.email_mobile IS NULL OR dtb_customer.email_mobile = '')";
- switch ($this->arrSql['mail_type']) {
+ switch ($this->arrSql['search_mail_type']) {
// PCメールアドレス
case 1:
$this->setWhere("(dtb_customer.email <> dtb_customer.email_mobile OR $sqlEmailMobileIsEmpty)");
@@ -208,37 +208,37 @@
}
// 購入金額指定
- if (!isset($this->arrSql['buy_total_from'])) $this->arrSql['buy_total_from'] = "";
- if (!isset($this->arrSql['buy_total_to'])) $this->arrSql['buy_total_to'] = "";
- if( is_numeric( $this->arrSql["buy_total_from"] ) || is_numeric( $this->arrSql["buy_total_to"] ) ) {
- $arrBuyTotal = $this->selectRange($this->arrSql["buy_total_from"], $this->arrSql["buy_total_to"], "buy_total");
+ if (!isset($this->arrSql['search_buy_total_from'])) $this->arrSql['search_buy_total_from'] = "";
+ if (!isset($this->arrSql['search_buy_total_to'])) $this->arrSql['search_buy_total_to'] = "";
+ if( is_numeric( $this->arrSql["search_buy_total_from"] ) || is_numeric( $this->arrSql["search_buy_total_to"] ) ) {
+ $arrBuyTotal = $this->selectRange($this->arrSql["search_buy_total_from"], $this->arrSql["search_buy_total_to"], "buy_total");
foreach ($arrBuyTotal as $data1) {
$this->arrVal[] = $data1;
}
}
// 購入回数指定
- if (!isset($this->arrSql['buy_times_from'])) $this->arrSql['buy_times_from'] = "";
- if (!isset($this->arrSql['buy_times_to'])) $this->arrSql['buy_times_to'] = "";
- if( is_numeric( $this->arrSql["buy_times_from"] ) || is_numeric( $this->arrSql["buy_times_to"] ) ) {
- $arrBuyTimes = $this->selectRange($this->arrSql["buy_times_from"], $this->arrSql["buy_times_to"], "buy_times");
+ if (!isset($this->arrSql['search_buy_times_from'])) $this->arrSql['search_buy_times_from'] = "";
+ if (!isset($this->arrSql['search_buy_times_to'])) $this->arrSql['search_buy_times_to'] = "";
+ if( is_numeric( $this->arrSql["search_buy_times_from"] ) || is_numeric( $this->arrSql["search_buy_times_to"] ) ) {
+ $arrBuyTimes = $this->selectRange($this->arrSql["search_buy_times_from"], $this->arrSql["search_buy_times_to"], "buy_times");
foreach ($arrBuyTimes as $data2) {
$this->arrVal[] = $data2;
}
}
// 誕生日期間指定
- if (!isset($this->arrSql['b_start_year'])) $this->arrSql['b_start_year'] = "";
- if (!isset($this->arrSql['b_start_month'])) $this->arrSql['b_start_month'] = "";
- if (!isset($this->arrSql['b_start_day'])) $this->arrSql['b_start_day'] = "";
- if (!isset($this->arrSql['b_end_year'])) $this->arrSql['b_end_year'] = "";
- if (!isset($this->arrSql['b_end_month'])) $this->arrSql['b_end_month'] = "";
- if (!isset($this->arrSql['b_end_day'])) $this->arrSql['b_end_day'] = "";
- if ( (strlen($this->arrSql['b_start_year']) > 0 && strlen($this->arrSql['b_start_month']) > 0 && strlen($this->arrSql['b_start_day']) > 0) ||
- strlen($this->arrSql['b_end_year']) > 0 && strlen($this->arrSql['b_end_month']) > 0 && strlen($this->arrSql['b_end_day']) > 0) {
+ if (!isset($this->arrSql['search_b_start_year'])) $this->arrSql['search_b_start_year'] = "";
+ if (!isset($this->arrSql['search_b_start_month'])) $this->arrSql['search_b_start_month'] = "";
+ if (!isset($this->arrSql['search_b_start_day'])) $this->arrSql['search_b_start_day'] = "";
+ if (!isset($this->arrSql['search_b_end_year'])) $this->arrSql['search_b_end_year'] = "";
+ if (!isset($this->arrSql['search_b_end_month'])) $this->arrSql['search_b_end_month'] = "";
+ if (!isset($this->arrSql['search_b_end_day'])) $this->arrSql['search_b_end_day'] = "";
+ if ( (strlen($this->arrSql['search_b_start_year']) > 0 && strlen($this->arrSql['search_b_start_month']) > 0 && strlen($this->arrSql['search_b_start_day']) > 0) ||
+ strlen($this->arrSql['search_b_end_year']) > 0 && strlen($this->arrSql['search_b_end_month']) > 0 && strlen($this->arrSql['search_b_end_day']) > 0) {
- $arrBirth = $this->selectTermRange($this->arrSql['b_start_year'], $this->arrSql['b_start_month'], $this->arrSql['b_start_day']
- , $this->arrSql['b_end_year'], $this->arrSql['b_end_month'], $this->arrSql['b_end_day'], "birth");
+ $arrBirth = $this->selectTermRange($this->arrSql['search_b_start_year'], $this->arrSql['search_b_start_month'], $this->arrSql['search_b_start_day']
+ , $this->arrSql['search_b_end_year'], $this->arrSql['search_b_end_month'], $this->arrSql['search_b_end_day'], "birth");
if (is_array($arrBirth)) {
foreach ($arrBirth as $data3) {
$this->arrVal[] = $data3;
@@ -247,24 +247,24 @@
}
// 誕生月の検索
- if (!isset($this->arrSql['birth_month'])) $this->arrSql['birth_month'] = "";
- if (is_numeric($this->arrSql["birth_month"])) {
+ if (!isset($this->arrSql['search_birth_month'])) $this->arrSql['search_birth_month'] = "";
+ if (is_numeric($this->arrSql["search_birth_month"])) {
$this->setWhere(" EXTRACT(month from birth) = ?");
- $this->arrVal[] = $this->arrSql["birth_month"];
+ $this->arrVal[] = $this->arrSql["search_birth_month"];
}
// 登録期間指定
- if (!isset($this->arrSql['start_year'])) $this->arrSql['start_year'] = "";
- if (!isset($this->arrSql['start_month'])) $this->arrSql['start_month'] = "";
- if (!isset($this->arrSql['start_day'])) $this->arrSql['start_day'] = "";
- if (!isset($this->arrSql['end_year'])) $this->arrSql['end_year'] = "";
- if (!isset($this->arrSql['end_month'])) $this->arrSql['end_month'] = "";
- if (!isset($this->arrSql['end_day'])) $this->arrSql['end_day'] = "";
- if ( (strlen($this->arrSql['start_year']) > 0 && strlen($this->arrSql['start_month']) > 0 && strlen($this->arrSql['start_day']) > 0 ) ||
- (strlen($this->arrSql['end_year']) > 0 && strlen($this->arrSql['end_month']) >0 && strlen($this->arrSql['end_day']) > 0) ) {
+ if (!isset($this->arrSql['search_start_year'])) $this->arrSql['search_start_year'] = "";
+ if (!isset($this->arrSql['search_start_month'])) $this->arrSql['search_start_month'] = "";
+ if (!isset($this->arrSql['search_start_day'])) $this->arrSql['search_start_day'] = "";
+ if (!isset($this->arrSql['search_end_year'])) $this->arrSql['search_end_year'] = "";
+ if (!isset($this->arrSql['search_end_month'])) $this->arrSql['search_end_month'] = "";
+ if (!isset($this->arrSql['search_end_day'])) $this->arrSql['search_end_day'] = "";
+ if ( (strlen($this->arrSql['search_start_year']) > 0 && strlen($this->arrSql['search_start_month']) > 0 && strlen($this->arrSql['search_start_day']) > 0 ) ||
+ (strlen($this->arrSql['search_end_year']) > 0 && strlen($this->arrSql['search_end_month']) >0 && strlen($this->arrSql['search_end_day']) > 0) ) {
- $arrRegistTime = $this->selectTermRange($this->arrSql['start_year'], $this->arrSql['start_month'], $this->arrSql['start_day']
- , $this->arrSql['end_year'], $this->arrSql['end_month'], $this->arrSql['end_day'], $regdate_col);
+ $arrRegistTime = $this->selectTermRange($this->arrSql['ssearch_tart_year'], $this->arrSql['search_start_month'], $this->arrSql['search_start_day']
+ , $this->arrSql['search_end_year'], $this->arrSql['search_end_month'], $this->arrSql['search_end_day'], $regdate_col);
if (is_array($arrRegistTime)) {
foreach ($arrRegistTime as $data4) {
$this->arrVal[] = $data4;
@@ -273,17 +273,17 @@
}
// 最終購入日指定
- if (!isset($this->arrSql['buy_start_year'])) $this->arrSql['buy_start_year'] = "";
- if (!isset($this->arrSql['buy_start_month'])) $this->arrSql['buy_start_month'] = "";
- if (!isset($this->arrSql['buy_start_day'])) $this->arrSql['buy_start_day'] = "";
- if (!isset($this->arrSql['buy_end_year'])) $this->arrSql['buy_end_year'] = "";
- if (!isset($this->arrSql['buy_end_month'])) $this->arrSql['buy_end_month'] = "";
- if (!isset($this->arrSql['buy_end_day'])) $this->arrSql['buy_end_day'] = "";
+ if (!isset($this->arrSql['search_buy_start_year'])) $this->arrSql['search_buy_start_year'] = "";
+ if (!isset($this->arrSql['search_buy_start_month'])) $this->arrSql['search_buy_start_month'] = "";
+ if (!isset($this->arrSql['search_buy_start_day'])) $this->arrSql['search_buy_start_day'] = "";
+ if (!isset($this->arrSql['search_buy_end_year'])) $this->arrSql['search_buy_end_year'] = "";
+ if (!isset($this->arrSql['search_buy_end_month'])) $this->arrSql['search_buy_end_month'] = "";
+ if (!isset($this->arrSql['search_buy_end_day'])) $this->arrSql['search_buy_end_day'] = "";
- if ( (strlen($this->arrSql['buy_start_year']) > 0 && strlen($this->arrSql['buy_start_month']) > 0 && strlen($this->arrSql['buy_start_day']) > 0 ) ||
- (strlen($this->arrSql['buy_end_year']) > 0 && strlen($this->arrSql['buy_end_month']) >0 && strlen($this->arrSql['buy_end_day']) > 0) ) {
- $arrRegistTime = $this->selectTermRange($this->arrSql['buy_start_year'], $this->arrSql['buy_start_month'], $this->arrSql['buy_start_day']
- , $this->arrSql['buy_end_year'], $this->arrSql['buy_end_month'], $this->arrSql['buy_end_day'], "last_buy_date");
+ if ( (strlen($this->arrSql['search_buy_start_year']) > 0 && strlen($this->arrSql['search_buy_start_month']) > 0 && strlen($this->arrSql['search_buy_start_day']) > 0 ) ||
+ (strlen($this->arrSql['search_buy_end_year']) > 0 && strlen($this->arrSql['search_buy_end_month']) >0 && strlen($this->arrSql['search_buy_end_day']) > 0) ) {
+ $arrRegistTime = $this->selectTermRange($this->arrSql['search_buy_start_year'], $this->arrSql['search_buy_start_month'], $this->arrSql['search_buy_start_day']
+ , $this->arrSql['search_buy_end_year'], $this->arrSql['search_buy_end_month'], $this->arrSql['search_buy_end_day'], "last_buy_date");
if (is_array($arrRegistTime)) {
foreach ($arrRegistTime as $data4) {
$this->arrVal[] = $data4;
@@ -292,26 +292,26 @@
}
// 購入商品コード
- if (!isset($this->arrSql['buy_product_code'])) $this->arrSql['buy_product_code'] = "";
- if ( strlen($this->arrSql['buy_product_code']) > 0 ) {
+ if (!isset($this->arrSql['search_buy_product_code'])) $this->arrSql['search_buy_product_code'] = "";
+ if ( strlen($this->arrSql['search_buy_product_code']) > 0 ) {
$this->setWhere( "customer_id IN (SELECT customer_id FROM dtb_order WHERE order_id IN (SELECT order_id FROM dtb_order_detail WHERE product_code LIKE ? ))");
- $search_buyproduct_code = $this->addSearchStr($this->arrSql['buy_product_code']);
+ $search_buyproduct_code = $this->addSearchStr($this->arrSql['search_buy_product_code']);
$this->arrVal[] = $search_buyproduct_code;
}
// 購入商品名称
- if (!isset($this->arrSql['buy_product_name'])) $this->arrSql['buy_product_name'] = "";
- if ( strlen($this->arrSql['buy_product_name']) > 0 ) {
+ if (!isset($this->arrSql['search_buy_product_name'])) $this->arrSql['search_buy_product_name'] = "";
+ if ( strlen($this->arrSql['search_buy_product_name']) > 0 ) {
$this->setWhere( "customer_id IN (SELECT customer_id FROM dtb_order WHERE order_id IN (SELECT order_id FROM dtb_order_detail WHERE product_name LIKE ? ))");
- $search_buyproduct_name = $this->addSearchStr($this->arrSql['buy_product_name']);
+ $search_buyproduct_name = $this->addSearchStr($this->arrSql['search_buy_product_name']);
$this->arrVal[] = $search_buyproduct_name;
}
// カテゴリーを選択している場合のみ絞込検索を行う
- if (!isset($this->arrSql['category_id'])) $this->arrSql['category_id'] = "";
- if ( strlen($this->arrSql['category_id']) > 0){
+ if (!isset($this->arrSql['search_category_id'])) $this->arrSql['search_category_id'] = "";
+ if ( strlen($this->arrSql['search_category_id']) > 0){
// カテゴリーで絞込検索を行うSQL文生成
- list($tmp_where, $tmp_arrval) = $objDb->sfGetCatWhere($this->arrSql['category_id']);
+ list($tmp_where, $tmp_arrval) = $objDb->sfGetCatWhere($this->arrSql['search_category_id']);
// カテゴリーで絞込みが可能の場合
if($tmp_where != "") {
@@ -320,17 +320,17 @@
}
}
// 携帯電話番号
- if (!isset($this->arrSql['cell'])) $this->arrSql['cell'] = "";
- if ( is_numeric( $this->arrSql['cell'] ) ) {
+ if (!isset($this->arrSql['search_cell'])) $this->arrSql['search_cell'] = "";
+ if ( is_numeric( $this->arrSql['search_cell'] ) ) {
$this->setWhere( "(cell01 || cell02 || cell03 LIKE ?)" );
- $searchTel = $this->addSearchStr($this->arrSql['cell']);
+ $searchTel = $this->addSearchStr($this->arrSql['search_cell']);
$this->arrVal[] = ereg_replace("-", "", $searchTel);
}
// 会員状態
- if (!isset($this->arrSql['status'])) $this->arrSql['status'] = "";
- if ( is_array( $this->arrSql['status'] ) ){
- $arrStatusVal = $this->setItemTerm( $this->arrSql['status'] ,"status" );
+ if (!isset($this->arrSql['search_status'])) $this->arrSql['search_status'] = "";
+ if ( is_array( $this->arrSql['search_status'] ) ){
+ $arrStatusVal = $this->setItemTerm( $this->arrSql['search_status'] ,"status" );
foreach ($arrStatusVal as $data) {
$this->arrVal[] = $data;
}
変更: branches/version-2_5-dev/data/class/helper/SC_Helper_Customer.php
===================================================================
--- branches/version-2_5-dev/data/class/helper/SC_Helper_Customer.php 2011-02-20 17:00:17 UTC (rev 20280)
+++ branches/version-2_5-dev/data/class/helper/SC_Helper_Customer.php 2011-02-20 17:13:44 UTC (rev 20281)
@@ -468,45 +468,45 @@
* @return void
*/
function sfSetSearchParam(&$objFormParam) {
- $objFormParam->addParam('顧客ID', 'customer_id', ID_MAX_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('顧客名', 'name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
- $objFormParam->addParam('顧客名(カナ)', 'kana', STEXT_LEN, 'CKV', array("SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANABLANK_CHECK"));
- $objFormParam->addParam('都道府県', 'pref', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('誕生日(開始年)', 'b_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('誕生日(開始月)', 'b_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('誕生日(開始日)', 'b_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('顧客ID', 'search_customer_id', ID_MAX_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('顧客名', 'search_name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('顧客名(カナ)', 'search_kana', STEXT_LEN, 'CKV', array("SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANABLANK_CHECK"));
+ $objFormParam->addParam('都道府県', 'search_pref', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('誕生日(開始年)', 'search_b_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('誕生日(開始月)', 'search_b_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('誕生日(開始日)', 'search_b_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('誕生日(終了年)', 'b_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('誕生日(終了月)', 'b_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('誕生日(終了日)', 'b_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('誕生月', 'birth_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('メールアドレス', 'email', MTEXT_LEN, 'a', array("SPTAB_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
- $objFormParam->addParam('携帯メールアドレス', 'email_mobile', MTEXT_LEN, 'a', array("SPTAB_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
- $objFormParam->addParam('電話番号', 'birth_month', TEL_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('購入金額(開始)', 'buy_total_from', PRICE_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('購入金額(終了)', 'buy_total_to', PRICE_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('購入回数(開始)', 'buy_times_from', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('購入回数(終了)', 'buy_times_to', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('登録・更新日(開始年)', 'start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('登録・更新日(開始月)', 'start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('登録・更新日(開始日)', 'start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('登録・更新日(終了年)', 'end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('登録・更新日(終了月)', 'end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('登録・更新日(終了日)', 'end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('表示件数', 'page_rows', 3, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('最終購入日(開始年)', 'buy_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('最終購入日(開始月)', 'buy_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('最終購入日(開始日)', 'buy_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('最終購入日(終了年)', 'buy_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('最終購入日(終了月)', 'buy_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('最終購入日(終了日)', 'buy_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('購入商品コード', 'buy_product_code', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
- $objFormParam->addParam('購入商品名', 'buy_product_name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
- $objFormParam->addParam('カテゴリ', 'category_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('編集対象顧客ID', 'edit_customer_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
- $objFormParam->addParam('性別', 'sex');
- $objFormParam->addParam('会員状態', 'status');
- $objFormParam->addParam('職業', 'job');
+ $objFormParam->addParam('誕生日(終了年)', 'search_b_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('誕生日(終了月)', 'search_b_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('誕生日(終了日)', 'search_b_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('誕生月', 'search_birth_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('メールアドレス', 'search_email', MTEXT_LEN, 'a', array("SPTAB_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('携帯メールアドレス', 'search_email_mobile', MTEXT_LEN, 'a', array("SPTAB_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('電話番号', 'search_birth_month', TEL_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('購入金額(開始)', 'search_buy_total_from', PRICE_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('購入金額(終了)', 'search_buy_total_to', PRICE_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('購入回数(開始)', 'search_buy_times_from', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('購入回数(終了)', 'search_buy_times_to', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('登録・更新日(開始年)', 'search_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('登録・更新日(開始月)', 'search_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('登録・更新日(開始日)', 'search_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('登録・更新日(終了年)', 'search_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('登録・更新日(終了月)', 'search_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('登録・更新日(終了日)', 'search_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('表示件数', 'search_page_rows', 3, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('最終購入日(開始年)', 'search_buy_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('最終購入日(開始月)', 'search_buy_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('最終購入日(開始日)', 'search_buy_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('最終購入日(終了年)', 'search_buy_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('最終購入日(終了月)', 'search_buy_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('最終購入日(終了日)', 'search_buy_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('購入商品コード', 'search_buy_product_code', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('購入商品名', 'search_buy_product_name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('カテゴリ', 'search_category_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('編集対象顧客ID', 'search_edit_customer_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('性別', 'search_sex', INT_LEN, "n", array("MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('会員状態', 'search_status', INT_LEN, "n", array("MAX_LENGTH_CHECK"));
+ $objFormParam->addParam('職業', 'search_job', INT_LEN, "n", array("MAX_LENGTH_CHECK"));
}
/**
@@ -522,28 +522,28 @@
// 拡張エラーチェック初期化
$objErr = new SC_CheckError($objFormParam->getHashArray());
// 拡張エラーチェック
- $objErr->doFunc(array("誕生日(開始日)", "b_start_year", "b_start_month", "b_start_day"), array("CHECK_DATE"));
- $objErr->doFunc(array("誕生日(終了日)", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_DATE"));
+ $objErr->doFunc(array("誕生日(開始日)", "search_b_start_year", "search_b_start_month", "search_b_start_day"), array("CHECK_DATE"));
+ $objErr->doFunc(array("誕生日(終了日)", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_DATE"));
- $objErr->doFunc(array("誕生日(開始日)","誕生日(終了日)", "b_start_year", "b_start_month", "b_start_day", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_SET_TERM"));
- $objErr->doFunc(array("登録・更新日(開始日)", "start_year", "start_month", "start_day",), array("CHECK_DATE"));
- $objErr->doFunc(array("登録・更新日(終了日)", "end_year", "end_month", "end_day"), array("CHECK_DATE"));
- $objErr->doFunc(array("登録・更新日(開始日)","登録・更新日(終了日)", "start_year", "start_month", "start_day", "end_year", "end_month", "end_day"), array("CHECK_SET_TERM"));
- $objErr->doFunc(array("最終購入日(開始日)", "buy_start_year", "buy_start_month", "buy_start_day",), array("CHECK_DATE"));
- $objErr->doFunc(array("最終購入(終了日)", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_DATE"));
+ $objErr->doFunc(array("誕生日(開始日)","誕生日(終了日)", "search_b_start_year", "search_b_start_month", "search_b_start_day", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_SET_TERM"));
+ $objErr->doFunc(array("登録・更新日(開始日)", "search_start_year", "search_start_month", "search_start_day",), array("CHECK_DATE"));
+ $objErr->doFunc(array("登録・更新日(終了日)", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_DATE"));
+ $objErr->doFunc(array("登録・更新日(開始日)","登録・更新日(終了日)", "search_start_year", "search_start_month", "search_start_day", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_SET_TERM"));
+ $objErr->doFunc(array("最終購入日(開始日)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day",), array("CHECK_DATE"));
+ $objErr->doFunc(array("最終購入(終了日)", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_DATE"));
//購入金額(from) ＞ 購入金額(to) の場合はエラーとする
- $objErr->doFunc(array("最終購入日(開始日)","登録・更新日(終了日)", "buy_start_year", "buy_start_month", "buy_start_day", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_SET_TERM"));
+ $objErr->doFunc(array("最終購入日(開始日)","登録・更新日(終了日)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_SET_TERM"));
- if ((SC_Utils_Ex::sfIsInt($array["buy_total_from"])
- && SC_Utils_Ex::sfIsInt($array["buy_total_to"]))
- && ($array["buy_total_from"] > $array["buy_total_to"])) {
- $objErr->arrErr["buy_total_from"] .= "※ 購入金額の指定範囲が不正です。";
+ if ((SC_Utils_Ex::sfIsInt($array["search_buy_total_from"])
+ && SC_Utils_Ex::sfIsInt($array["search_buy_total_to"]))
+ && ($array["search_buy_total_from"] > $array["buy_total_to"])) {
+ $objErr->arrErr["search_buy_total_from"] .= "※ 購入金額の指定範囲が不正です。";
}
- if ((SC_Utils_Ex::sfIsInt($array["buy_times_from"])
- && SC_Utils_Ex::sfIsInt($array["buy_times_to"]))
- && ($array["buy_times_from"] > $array["buy_times_to"])) {
- $objErr->arrErr["buy_times_from"] .= "※ 購入回数の指定範囲が不正です。";
+ if ((SC_Utils_Ex::sfIsInt($array["search_buy_times_from"])
+ && SC_Utils_Ex::sfIsInt($array["search_buy_times_to"]))
+ && ($array["search_buy_times_from"] > $array["search_buy_times_to"])) {
+ $objErr->arrErr["search_buy_times_from"] .= "※ 購入回数の指定範囲が不正です。";
}
if(!SC_Utils::isBlank($objErr->arrErr)) {
$arrErr = array_merge($arrErr, $objErr->arrErr);
Svn-src-all メーリングリストの案内