Changeset 7586 for temp/trunk

Timestamp:

2006/11/07 14:11:43 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html

Files:

• install/sql/create_table_mysql.sql (modified) (previous)
• install/sql/create_table_pgsql.sql (modified) (previous)
• shopping/confirm.php (modified) (2 diffs)

temp/trunk/html/shopping/confirm.php

@@ -75 +75 @@
     break;
 case 'confirm':
+
+    // ¤³¤Î»þÅÀ¤Ç¥ª¡¼¥À¡¼ID¤ò³ÎÊݤ·¤Æ¤ª¤¯¡Ê¥¯¥ì¥¸¥Ã¥È¡¢¥³¥ó¥Ó¥Ë·èºÑ¤ÇɬÍפʤ¿¤á¡Ë
+    // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
+    if (DB_TYPE == "pgsql") {
+        $order_id = $objQuery->nextval("dtb_order","order_id");
+        $objQuery->query("INSERT INTO dtb_order (order_id, customer_id, create_date, del_flg) VALUES (?, ?, now(), 1)", array($order_id, $arrData["customer_id"]));
+    }elseif (DB_TYPE == "mysql") {
+        $objQuery->query("INSERT INTO dtb_order (customer_id, create_date, del_flg) VALUES (?, now(), 1)", array($arrData["customer_id"]));
+        $order_id = $objQuery->nextval("dtb_order","order_id");
+    }
+    $arrData["order_id"] = $order_id;
+
     // ½¸·×·ë²Ì¤ò¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤ËÈ¿±Ç
     sfRegistTempOrder($uniqid, $arrData);
@@ -86 +98 @@
     }
     
-    // ¤³¤Î»þÅÀ¤Ç¥ª¡¼¥À¡¼ID¤ò³ÎÊݤ·¤Æ¤ª¤¯¡Ê¥¯¥ì¥¸¥Ã¥È¡¢¥³¥ó¥Ó¥Ë·èºÑ¤ÇɬÍפʤ¿¤á¡Ë
-    // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
-    if (DB_TYPE == "pgsql") {
-        $order_id = $objQuery->nextval("dtb_order","order_id");
-        $objQuery->query("INSERT INTO dtb_order (order_id, customer_id, create_date, del_flg) VALUES (?, ?, now(), 1)", array($order_id, $arrData["customer_id"]));
-    }elseif (DB_TYPE == "mysql") {
-        $objQuery->query("INSERT INTO dtb_order (customer_id, create_date, del_flg) VALUES (?, now(), 1)", array($arrData["customer_id"]));
-        $order_id = $objQuery->nextval("dtb_order","order_id");
-    }
-
     // ·èºÑÊýË¡¤Ë¤è¤ê²èÌÌÀÚÂØ
     switch($arrPayment[0]["memo03"]) {