Changeset 4967 for temp/trunk

Timestamp:

2006/09/17 22:11:41 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin

Files:

• basis/delivery_input.php (modified) (1 diff)
• batch/daily.php (modified) (1 diff)
• contents/inquiry.php (modified) (1 diff)
• mail/index.php (modified) (2 diffs)
• products/bak_upload_csv.php (modified) (2 diffs)
• products/product.php (modified) (1 diff)
• products/upload_csv.inc (modified) (previous)
• total/index.php (modified) (1 diff)

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

@@ -96 +96 @@
     } else {
         // ÅÐÏ¿¤¹¤ëÇÛÁ÷¶È¼ÔID¤Î¼èÆÀ
-//      $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');
+
     }
     

temp/trunk/html/admin/batch/daily.php

@@ -49 +49 @@
         return;
     }
-        
+
     // ½¸·×
     for ($i = $start; $i < $term; $i++) {

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

@@ -92 +92 @@
         if ( ! is_numeric($_POST['question_id']) ){
             //ÅÐÏ¿
-//          $sql = "select nextval('dtb_question_question_id_seq');";
-//          $question_id = $conn->getOne($sql);
-            $objQuery = new SC_Query();
-            $deliv_id = $objQuery->nextval('dtb_question', 'question_id');
-            
             $value = serialize($_POST);
             $sql_val = array( $value, $_POST['title'] ,$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;
             sfReload();

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');
+//  $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'];
@@ -386 +386 @@
     $arrData['body'] = "";
     $dtb_send_history["search_data"] = serialize($arrData);
-    $conn->autoExecute("dtb_send_history", $dtb_send_history );     
+    $conn->autoExecute("dtb_send_history", $dtb_send_history ); 
     
     if ( is_array( $search_data ) ){

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

@@ -195 +195 @@
     }
     
-    $product_id = $objQuery->nextval("dtb_products", "product_id");
-    $sqlval['product_id'] = $product_id;
     $sqlval['status'] = 2;  // Èóɽ¼¨¤ËÀßÄꤹ¤ë¡£
     $sqlval['update_date'] = "Now()";
@@ -207 +205 @@
     // INSERT¤Î¼Â¹Ô
     $objQuery->insert("dtb_products", $sqlval);
+    
+    $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'] == "") {
-        $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;
         // INSERT¤Î¼Â¹Ô
         $objQuery->insert("dtb_products", $sqlval);
+        
+        $product_id = $objQuery->nextval("dtb_products", "product_id");
+        $sqlval['product_id'] = $product_id;
     } else {
         $product_id = $arrList['product_id'];

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

@@ -764 +764 @@
         $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
         
+        $objQuery->getlastquery();
+        
         // ÀÞ¤ìÀþ¥°¥é¥Õ¤ÎÀ¸À®   
         if($graph) {