Changeset 9412

Timestamp:

2006/11/29 18:05:32 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/lib/slib.php (modified) (4 diffs)
• html/admin/products/product.php (modified) (1 diff)

temp/trunk/data/lib/slib.php

@@ -99 +99 @@
     // Àµ¾ï¤ËÀܳ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç
     if(!$objQuery->isError()) {
+        $arrRet = sfGetColumnList($table_name, $objQuery);
+        if(count($arrRet) > 0) {
+            if(!in_array($col_name, $arrRet)){
+                return true;
+            }
+        }
+
+        /*
         list($db_type) = split(":", $dsn);
         // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
@@ -118 +126 @@
             }
         }else if ($db_type == "mysql") {
-            $sql = "SHOW COLUMNS FROM $table_name";
-            $arrRet = $objQuery->getAll($sql);
+            $arrRet = sfGetColumnList($table_name, $objQuery);
             if(count($arrRet) > 0) {
                 if(!in_array($col_name, $arrRet)){
@@ -126 +133 @@
             }
         }
+        */
     }
     
@@ -135 +143 @@
     
     return false;
+}
+
+// ¥Æ¡¼¥Ö¥ë¤Î¥«¥é¥à°ìÍ÷¤ò¼èÆÀ¤¹¤ë
+function sfGetColumnList($table_name, $objQuery = ""){
+    if($objQuery == "") $objQuery = new SC_Query();
+    $arrRet = array();
+    
+    // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
+    if (DB_TYPE == "pgsql") {
+        $sql = "SELECT a.attname FROM pg_class c, pg_attribute a WHERE c.relname=? AND c.oid=a.attrelid AND a.attnum > 0 ORDER BY a.attnum";
+        $arrRet = $objQuery->getAll($sql, array($table_name));
+    }else if (DB_TYPE == "mysql") {
+        $sql = "SHOW COLUMNS FROM $table_name";
+        $arrRet = $objQuery->getAll($sql);
+    }
+    
+    return $arrRet;
 }
 

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

@@ -346 +346 @@
             $sqlval['product_id'] = $product_id;
         }
+        
+        // dtb_products_class ¤Î¥«¥é¥à¤ò¼èÆÀ
+        
+        
+        // ¥³¥Ô¡¼¾¦Éʤξì¹ç¤Ë¤Ïµ¬³Ê¤â¥³¥Ô¡¼¤¹¤ë
+        "INSERT INTO dtb_pSELECT * FROM dtb_products_class WHERE product_id = ? ORDER BY product_class_id";
+        
 
     } else {