Changeset 11624

Timestamp:

2007/03/08 23:01:50 (17 years ago)

Author:

uehara

Message:

 

Location:

branches/dev/data

Files:

• Smarty/templates/admin/mail/index.tpl (modified) (1 diff)
• class/SC_CustomerList.php (modified) (1 diff)

branches/dev/data/Smarty/templates/admin/mail/index.tpl

@@ -137 +137 @@
                             </tr>
                             
+                            <tr class="fs12n">
+                                <td bgcolor="#f2f1ec" width="110">¥á¡¼¥ë¥¢¥É¥ì¥¹(·ÈÂÓÍÑ)</td>
+                                <td bgcolor="#ffffff" colspan="3">
+                                    <!--{if $arrErr.email_mobile}--><span class="red12"><!--{$arrErr.email_mobile}--></span><!--{/if}-->
+                                    <span style="<!--{$arrErr.email_mobile|sfGetErrorColor}-->">
+                                    <input type="text" name="email_mobile" maxlength="<!--{$smarty.const.STEXT_LEN}-->" value="<!--{$list_data.email_mobile|escape}-->" size="60" class="box60"  style="<!--{$arrErr.email_mobile|sfGetErrorColor}-->"/>
+                                    </span>
+                                </td>
+                            </tr>
+                                                        
                             <tr class="fs12n">
                                 <td bgcolor="#f2f1ec" width="110">¿¦¶È</td>

branches/dev/data/class/SC_CustomerList.php

@@ -164 +164 @@
             $this->setWhere($sql_where);
         }
+    
+        //¡¡·ÈÂÓÍѥ᡼¥ë¥¢¥É¥ì¥¹
+        if (strlen($this->arrSql['email_mobile']) > 0) {
+            //¥«¥ó¥Þ¶èÀÚ¤ê¤ÇÊ£¿ô¤Î¾ò·ï»ØÄê²Äǽ¤Ë
+            $this->arrSql['email_mobile'] = explode(",", $this->arrSql['email_mobile']);
+            $sql_where = "";
+            foreach($this->arrSql['email_mobile'] as $val) {
+                $val = trim($val);
+                if($sql_where == "") {
+                    $sql_where .= "dtb_customer.email_mobile ILIKE ? ";
+                } else {
+                    $sql_where .= "OR dtb_customer.email_mobile ILIKE ? ";
+                }
+                $this->arrVal[] = $this->addSearchStr($val);
+            }
+            $this->setWhere($sql_where);
+        }
+        
+                
         //¡¡HTML-mail
         if ( $mode == 'magazine' ){