Changeset 5002 for temp/trunk/html/admin

Timestamp:

2006/09/18 15:46:49 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin

Files:

• basis/delivery_input.php (modified) (1 diff)
• contents/inquiry.php (modified) (1 diff)
• develop/csv.php (modified) (2 diffs)
• develop/upload_csv.php (modified) (2 diffs)
• mail/index.php (modified) (1 diff)
• products/bak_upload_csv.php (modified) (2 diffs)
• products/product.php (modified) (2 diffs)

temp/trunk/html/admin/basis/delivery_input.php

@@ -96 +96 @@
     } else {
         // ÅÐÏ¿¤¹¤ëÇÛÁ÷¶È¼ÔID¤Î¼èÆÀ
+
+        if (DB_TYPE == "pgsql") {
+            $deliv_id = $objQuery->nextval('dtb_deliv', 'deliv_id');
+            $sqlval['deliv_id'] = $deliv_id;
+        }
+        
         $sqlval['rank'] = $objQuery->max("dtb_deliv", "rank") + 1;
         // INSERT¤Î¼Â¹Ô
         $objQuery->insert("dtb_deliv", $sqlval);
-        $deliv_id = $objQuery->nextval('dtb_deliv', 'deliv_id');
-
+        
+        if (DB_TYPE == "mysql") {
+            $deliv_id = $objQuery->nextval('dtb_deliv', 'deliv_id');            
+        }
     }
     

temp/trunk/html/admin/contents/inquiry.php

@@ -94 +94 @@
             $value = serialize($_POST);
             $sql_val = array( $value, $_POST['title'] ,$question_id );
+            if (DB_TYPE == "pgsql") {
+                $question_id = $objQuery->nextval('dtb_question', 'question_id');
+                $objPage->QUESTION_ID = $question_id;
+            }
             $conn->query("INSERT INTO dtb_question ( question, question_name, question_id ) VALUES (?, ?, ?)", $sql_val );
             $objPage->MESSAGE = "ÅÐÏ¿¤¬´°Î»¤·¤Þ¤·¤¿";
             
             $objQuery = new SC_Query();
-            $question_id = $objQuery->nextval('dtb_question', 'question_id');
-            $objPage->QUESTION_ID = $question_id;
+            
+            if (DB_TYPE == "mysql") {
+                $question_id = $objQuery->nextval('dtb_question', 'question_id');
+                $objPage->QUESTION_ID = $question_id;
+            }
             sfReload();
         } else {

temp/trunk/html/admin/develop/csv.php

@@ -110 +110 @@
         }
     }
-                
-    $product_id = $objQuery->nextval("dtb_products", "product_id");
-    $sqlval['product_id'] = $product_id;
+    
+    if (DB_TYPE == "pgsql") {
+        $product_id = $objQuery->nextval("dtb_products", "product_id");
+        $sqlval['product_id'] = $product_id;
+    }
     $sqlval['status'] = 1;  // ɽ¼¨¤ËÀßÄꤹ¤ë¡£
     $sqlval['update_date'] = "Now()";
@@ -127 +129 @@
     // INSERT¤Î¼Â¹Ô
     $objQuery->fast_insert("dtb_products", $sqlval);
+    if (DB_TYPE == "mysql") {
+        $product_id = $objQuery->nextval("dtb_products", "product_id");
+    }
 }
 

temp/trunk/html/admin/develop/upload_csv.php

@@ -208 +208 @@
     }
 
-// ¼«Æ°¥¤¥ó¥¯¥ê¥á¥ó¥È¤Ê¤Î¤ÇÉÔɬÍ×           
-//  $product_id = $objQuery->nextval("dtb_products", "product_id");
-//  $sqlval['product_id'] = $product_id;
+    if (DB_TYPE == "pgsql") {
+        $product_id = $objQuery->nextval("dtb_products", "product_id");
+        $sqlval['product_id'] = $product_id;
+    }
 
     $sqlval['status'] = 1;  // ɽ¼¨¤ËÀßÄꤹ¤ë¡£
@@ -224 +225 @@
     // INSERT¤Î¼Â¹Ô
     $objQuery->insert("dtb_products", $sqlval);
+    
+    if (DB_TYPE == "mysql") {
+        $product_id = $objQuery->nextval("dtb_products", "product_id"); 
+    }
     
     gfPrintLog("insert product end");

temp/trunk/html/admin/mail/index.php

@@ -377 +377 @@
     
     $dtb_send_history = array();
-//  $dtb_send_history["send_id"] = $objQuery->nextval('dtb_send_history', 'send_id');
+    if (DB_TYPE == "pgsql") {
+        $dtb_send_history["send_id"] = $objQuery->nextval('dtb_send_history', 'send_id');
+    }
     $dtb_send_history["mail_method"] = $arrData['mail_method'];
     $dtb_send_history["subject"] = $arrData['subject'];

temp/trunk/html/admin/products/bak_upload_csv.php

@@ -195 +195 @@
     }
     
+    if (DB_TYPE == "pgsql") {
+        $product_id = $objQuery->nextval("dtb_products", "product_id");
+        $sqlval['product_id'] = $product_id;
+    }
     $sqlval['status'] = 2;  // Èóɽ¼¨¤ËÀßÄꤹ¤ë¡£
     $sqlval['update_date'] = "Now()";
@@ -206 +210 @@
     $objQuery->insert("dtb_products", $sqlval);
     
-    $product_id = $objQuery->nextval("dtb_products", "product_id");
-    $sqlval['product_id'] = $product_id;
-    
+    if (DB_TYPE == "mysql") {
+        $product_id = $objQuery->nextval("dtb_products", "product_id");
+        $sqlval['product_id'] = $product_id;
+    }
 }
 

temp/trunk/html/admin/products/product.php

@@ -303 +303 @@
 
     if($arrList['product_id'] == "") {
+        if (DB_TYPE == "pgsql") {
+            $product_id = $objQuery->nextval("dtb_products", "product_id");
+            $sqlval['product_id'] = $product_id;
+        }
         // ¥«¥Æ¥´¥êÆâ¤ÇºÇÂç¤Î¥é¥ó¥¯¤ò³ä¤êÅö¤Æ¤ë
         $sqlval['rank'] = $objQuery->max("dtb_products", "rank", "category_id = ?", array($arrList['category_id'])) + 1;
@@ -308 +312 @@
         $objQuery->insert("dtb_products", $sqlval);
         
-        $product_id = $objQuery->nextval("dtb_products", "product_id");
-        $sqlval['product_id'] = $product_id;
+        if (DB_TYPE == "mysql") {
+            $product_id = $objQuery->nextval("dtb_products", "product_id");
+            $sqlval['product_id'] = $product_id;
+        }
+
     } else {
         $product_id = $arrList['product_id'];