Changeset 7969 for temp/trunk/data

Timestamp:

2006/11/09 11:32:12 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/downloads/module/mdl_epsilon/mdl_epsilon.php (modified) (2 diffs)

temp/trunk/data/downloads/module/mdl_epsilon/mdl_epsilon.php

@@ -72 +72 @@
         
         // del_flg¤òºï½ü¤Ë¤·¤Æ¤ª¤¯
-        $del_sql = "UPDATE dtb_payment SET del_flg = 1, memo03='', memo04='' WHERE module_id = ? AND memo03 NOT IN (";
-        
+        $del_sql = "UPDATE dtb_payment SET del_flg = 1, memo03='', memo04='' WHERE module_id = ? ";
+        $arrDel = array(MDL_EPSILON_ID);
         if(count($_POST["payment"]) > 0){
-            
-        }
-        for($i = 1; $i < count($_POST["payment"]); $i++){
-            
-        }
-        
-        //$objQuery->query($del_sql, array(MDL_EPSILON_ID));
+            $del_sql .= " AND memo03 NOT IN ( ?";
+            $arrDel = array_merge($arrDel, array($_POST["payment"][0]));
+            for($i = 1; $i < count($_POST["payment"]); $i++){
+                $del_sql .= " ,?";
+                $arrDel = array_merge($arrDel, array($_POST["payment"][$i]));
+            }
+            $del_sql .= " ) ";
+        }
+        
+        $objQuery->query($del_sql, $arrDel);
         
         foreach($_POST["payment"] as $key => $val){
@@ -140 +143 @@
         }
         
-        $sql = "";
-        for($i = 0; $i<100; $i++){
-            $sql .= "INSERT INTO test VALUES(1,1,1);";
-        }
-        $objQuery->query($sql);
-        
         // javascript¼Â¹Ô
         //$objPage->tpl_onload = 'alert("ÅÐÏ¿´°Î»¤·¤Þ¤·¤¿¡£\n´ðËܾðÊó¡ä»ÙʧÊýË¡ÀßÄê¤è¤ê¾ÜºÙÀßÄê¤ò¤·¤Æ¤¯¤À¤µ¤¤¡£"); window.close();';