Changeset 5551 for temp/trunk

Timestamp:

2006/09/23 21:58:44 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/system/bkup.php (modified) (5 diffs)

temp/trunk/html/admin/system/bkup.php

@@ -40 +40 @@
         
         // DB¤Ë¥Ç¡¼¥¿¹¹¿·
-        
+        lfUpdBkupData($_POST);
     }
     
@@ -95 +95 @@
     foreach($arrTableList as $key => $val){
         
-        // ¥Æ¡¼¥Ö¥ë¹½À®¤ò¼èÆÀ
-        $arrColumnList = lfGetColumnList($val);
-        
-        // ¥Æ¡¼¥Ö¥ë¹½À®¤ÎCSV½ÐÎϥǡ¼¥¿À¸À®
-        
-        
-        // Á´¥Ç¡¼¥¿¤ò¼èÆÀ
-        $arrData = $objQuery->getAll("SELECT * FROM $val");
-
-        // CSV¥Ç¡¼¥¿À¸À®
-        if (count($arrData) > 0) {
+        if ($val != "dtb_bkup") {
+            // ¥Æ¡¼¥Ö¥ë¹½À®¤ò¼èÆÀ
+            $arrColumnList = lfGetColumnList($val);
             
-            // ¥«¥é¥à¤òCSV·Á¼°¤ËÀ°¤¨¤ë
-            $arrKyes = sfGetCommaList(array_keys($arrData[0]), false);
+            // ¥Æ¡¼¥Ö¥ë¹½À®¤ÎCSV½ÐÎϥǡ¼¥¿À¸À®
             
-            // ¥Ç¡¼¥¿¤òCSV·Á¼°¤ËÀ°¤¨¤ë
-            $data = "";
-            foreach($arrData as $data_key => $data_val){
-                $data .= sfGetCSVList($arrData[$data_key]);
-            }
             
-            // CSV½ÐÎϥǡ¼¥¿À¸À®
-            $csv_data .= $val . "\n";
-            $csv_data .= $arrKyes . "\n";
-            $csv_data .= $data;
-            $csv_data .= "\n";
-        }   
+            // Á´¥Ç¡¼¥¿¤ò¼èÆÀ
+            $arrData = $objQuery->getAll("SELECT * FROM $val");
+    
+            // CSV¥Ç¡¼¥¿À¸À®
+            if (count($arrData) > 0) {
+                
+                // ¥«¥é¥à¤òCSV·Á¼°¤ËÀ°¤¨¤ë
+                $arrKyes = sfGetCommaList(array_keys($arrData[0]), false);
+                
+                // ¥Ç¡¼¥¿¤òCSV·Á¼°¤ËÀ°¤¨¤ë
+                $data = "";
+                foreach($arrData as $data_key => $data_val){
+                    $data .= sfGetCSVList($arrData[$data_key]);
+                }
+                
+                // CSV½ÐÎϥǡ¼¥¿À¸À®
+                $csv_data .= $val . "\n";
+                $csv_data .= $arrKyes . "\n";
+                $csv_data .= $data;
+                $csv_data .= "\n";
+            }   
+        }
     }
     $bkup_dir = $bkup_dir . "test" . ".csv";
@@ -131 +133 @@
     }
     
-
     if ($err) {
         $fp = fopen($bkup_dir . "test" . ".csv","w");
@@ -152 +153 @@
     
     if(DB_TYPE == "pgsql"){
-        $sql = "SELECT tablename FROM pg_tables where tableowner = ? ORDER BY tablename ; ";
+        $sql = "SELECT tablename FROM pg_tables WHERE tableowner = ? ORDER BY tablename ; ";
         $arrRet = $objQuery->getAll($sql, array(DB_USER));
         $arrRet = sfSwapArray($arrRet);
@@ -184 +185 @@
 }
 
-
+// ¥Ð¥Ã¥¯¥¢¥Ã¥×¥Æ¡¼¥Ö¥ë¤Ë¥Ç¡¼¥¿¤ò¹¹¿·¤¹¤ë
+function lfUpdBkupData($data){
+    $objQuery = new SC_Query();
+    
+    $sql = "INSERT INTO dtb_bkup (bkup_name,create_date,) values (?,now())";
+    $objQuery->query($sql, array($data['bkup_data']));
+    
+}