Changeset 16603 for branches/feature-module-combz/data/downloads

Timestamp:

2007/10/29 22:42:34 (15 years ago)

Author:

naka

Message:

コンビーズ中間アップ

Location:

branches/feature-module-combz/data/downloads/module/mdl_combz

Files:

• combz_reserve.tpl (modified) (2 diffs)
• mdl_combz.inc (modified) (4 diffs)
• mdl_combz.php (added)
• mdl_combz.tpl (added)

branches/feature-module-combz/data/downloads/module/mdl_combz/combz_reserve.tpl

@@ -96 +96 @@
                                         </tr>
                                         <tr class="fs12n">
-                                            <td width="" bgcolor="#f3f3f3">ƒƒ‹ƒ}ƒKŒ–¼<span class="red"> ¦</span></td>
+                                            <td width="" bgcolor="#f3f3f3">ƒƒ‹ƒ}ƒKŒ–¼</td>
                                             <td width="300" bgcolor="#ffffff">
                                             <!--{assign var=key value="subject"}-->
@@ -104 +104 @@
                                         </tr>
                                         <tr class="fs12n">
-                                            <td width="" bgcolor="#f3f3f3">ƒƒ‹ƒ}ƒK–{•¶<span class="red"> ¦</span></td>
+                                            <td width="" bgcolor="#f3f3f3">ƒƒ‹ƒ}ƒK–{•¶</td>
                                             <td width="300" bgcolor="#ffffff">
                                             <!--{assign var=key value="body"}-->

branches/feature-module-combz/data/downloads/module/mdl_combz/mdl_combz.inc

@@ -11 +11 @@
 define('COMBZ_ENCODE', 'Shift-JIS');
 
+/**** ¢§Äê¿ôÀë¸À *********************************************************************************************/
+
+define("MDL_COMBZ_ID", 13);
+define("MODULE_NAME", "¥³¥ó¥Ó¡¼¥ºÏ¢Æ°¥â¥¸¥å¡¼¥ë");
+define("MODULE_ID", MDL_COMBZ_ID);
+
+/**************************************************************************************************************
+ * ´Ø¿ô̾   ¡§sfSetModuleDB
+ * ½èÍýÆâÍÆ ¡§É¬Íפʥǡ¼¥¿¤ò¼èÆÀ¤¹¤ë¡£
+ * °ú¿ô1    ¡§
+ * °ú¿ô2    ¡§
+ * °ú¿ô3    ¡§
+ * Ìá¤êÃÍ   ¡§¼èÆÀ·ë²Ì
+ **************************************************************************************************************/
+function sfSetModuleDB($module_id, $objFormParam){
+    global $objQuery;
+    $arrRet = $objFormParam->getHashArray();
+    foreach($arrRet as $key => $val) {
+        $arrVal[$key] = $val;
+    }    
+    $sqlval['sub_data'] = serialize($arrVal);   
+    $objQuery->update("dtb_module", $sqlval, "module_id = ?", array($module_id));
+}
+
+/**************************************************************************************************************
+ * ´Ø¿ô̾   ¡§sfGetModuleDB
+ * ½èÍýÆâÍÆ ¡§É¬Íפʥǡ¼¥¿¤ò¼èÆÀ¤¹¤ë¡£
+ * °ú¿ô1    ¡§
+ * °ú¿ô2    ¡§
+ * °ú¿ô3    ¡§
+ * Ìá¤êÃÍ   ¡§¼èÆÀ·ë²Ì
+ **************************************************************************************************************/
+// DB¤«¤é¥Ç¡¼¥¿¤ò¼èÆÀ¤¹¤ë
+function sfGetModuleDB($module_id){
+    $objQuery = new SC_Query();
+    $arrVal = array($module_id);
+    $arrRet = array();
+    $sql = "SELECT 
+                sub_data
+            FROM dtb_module WHERE module_id = ? " . $where;
+    $arrRet = $objQuery->getall($sql, $arrVal);
+    return unserialize($arrRet[0]['sub_data']);
+}
 /**************************************************************************************************************
  * ´Ø¿ô̾   ¡§sfCombzReserve
@@ -24 +67 @@
     ini_set("default_charset", COMBZ_ENCODE);
     ini_set("mbstring.internal_encoding", COMBZ_ENCODE);
-        
-    $arrForm = array(
-        'pubid' => 'u7gu',
-        'pw' => 'iejkngt67',
-        'magid' => 'j7zb',
-    );
     
+    //¥Ç¡¼¥¿¤ò¼èÆÀ
+    $arrForm = sfGetModuleDB(MODULE_ID);
     //¥Ú¡¼¥¸´ÉÍý¥¯¥é¥¹
     class LC_ReservePage {
@@ -65 +104 @@
     ini_set("mbstring.internal_encoding", COMBZ_ENCODE);
         
-    $arrForm = array(
-        'pubid' => 'u7gu',
-        'pw' => 'iejkngt67',
-        'magid' => 'j7zb',
-    );
+    //¥Ç¡¼¥¿¤ò¼èÆÀ
+    $arrForm = sfGetModuleDB(MODULE_ID);
     
     //¥Ú¡¼¥¸´ÉÍý¥¯¥é¥¹
@@ -85 +121 @@
     $objQuery = new SC_Query();
     $arrRet = $objQuery->select("email, email_mobile", "dtb_customer", $where, $arrval);
-    
+    $arrForm['set_data'] = "";
     for($i = 0; $i < count($arrRet); $i++) {
         if($arrRet[$i]['email'] != "") {
-            $arrForm['set_data'] =  $arrRet[$i]['email'] . "\n";
+            $arrForm['set_data'].=  $arrRet[$i]['email'] . "\n";
         }
-        if($arrRet[$i]['email_mobile'] != "") {
-            $arrForm['set_data'] =  $arrRet[$i]['email_mobile'] . "\n"; 
-        }       
+        if($arrRet[$i]['email_mobile'] != "" && $arrRet[$i]['email'] != $arrRet[$i]['email_mobile']) {
+            $arrForm['set_data'].=  $arrRet[$i]['email_mobile'] . "\n"; 
+        }
     }