Changeset 11949

Timestamp:

2007/03/22 16:40:42 (17 years ago)

Author:

inoue

Message:

プロトタイプ

Location:

branches/dev/html/admin/products

Files:

• index_csv.php (modified) (3 diffs)
• trackback.php (modified) (13 diffs)

branches/dev/html/admin/products/index_csv.php

@@ -29 +29 @@
                         );
 
+$arrTRACKBACK_CVSTITLE = array(
+                        '¾¦ÉÊ̾',
+                        '¥Ö¥í¥°Ì¾',
+                        '¥Ö¥í¥°µ­»ö¥¿¥¤¥È¥ë',
+                        '¥Ö¥í¥°µ­»öÆâÍÆ',
+                        '¾õÂÖ',
+                        'Åê¹ÆÆü'
+                        );
+
+$arrTRACKBACK_CVSCOL = array( 
+                        'B.name',
+                        'A.blog_name',
+                        'A.title',
+                        'A.excerpt',
+                        'A.status',
+                        'A.create_date'
+                        );
+
 // CSV½ÐÎϥǡ¼¥¿¤òºîÀ®¤¹¤ë¡£(¾¦ÉÊ)
 function lfGetProductsCSV($where, $option, $arrval, $arrOutputCols) {
@@ -72 +90 @@
         // ³Æ¹àÌܤòCSV½ÐÎÏÍѤËÊÑ´¹¤¹¤ë¡£
         $data .= lfMakeReviewCSV($list_data[$i]);
+    }
+    return $data;
+}
+
+// CSV½ÐÎϥǡ¼¥¿¤òºîÀ®¤¹¤ë¡£(¥È¥é¥Ã¥¯¥Ð¥Ã¥¯)
+function lfGetTrackbackCSV($where, $option, $arrval) {
+    global $arrTRACKBACK_CVSCOL;
+
+    $from = "dtb_trackback AS A INNER JOIN dtb_products AS B on A.product_id = B.product_id ";
+    $cols = sfGetCommaList($arrTRACKBACK_CVSCOL);
+    
+    $objQuery = new SC_Query();
+    $objQuery->setoption($option);
+    
+    $list_data = $objQuery->select($cols, $from, $where, $arrval);  
+
+    $max = count($list_data);
+    for($i = 0; $i < $max; $i++) {
+        // ³Æ¹àÌܤòCSV½ÐÎÏÍѤËÊÑ´¹¤¹¤ë¡£
+        $data .= lfMakeTrackbackCSV($list_data[$i]);
     }
     return $data;
@@ -139 +177 @@
 }
 
+// ³Æ¹àÌܤòCSV½ÐÎÏÍѤËÊÑ´¹¤¹¤ë¡£(¥È¥é¥Ã¥¯¥Ð¥Ã¥¯)
+function lfMakeTrackbackCSV($list) {
+    global $arrTrackBackStatus;
+    global $arrDISP;
+    
+    $line = "";
+    
+    foreach($list as $key => $val) {
+        $tmp = "";
+        switch($key) {
+            case 'status':
+                $tmp = $arrTrackBackStatus[$val];
+                break;
+            default:
+                $tmp = $val;
+                break;
+        }
+
+        $tmp = ereg_replace("[\",]", " ", $tmp);
+        $line .= "\"".$tmp."\",";
+    }
+    // ʸËö¤Î","¤òÊÑ´¹
+    $line = ereg_replace(",$", "\n", $line);
+    return $line;
+}
+
 ?>

branches/dev/html/admin/products/trackback.php

@@ -49 +49 @@
 sfIsSuccess($objSess);
 
-// ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤Î¥«¥é¥à¤Î¼èÆÀ
-$select="trackback_id, tra.product_id, tra.blog_name, tra.title, tra.url, ";
-$select.="tra.excerpt, tra.status, tra.create_date, tra.update_date, pro.name";
-$from = "dtb_trackback AS tra LEFT JOIN dtb_products AS pro ON tra.product_id = pro.product_id ";
+// ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¾ðÊó¤Î¥«¥é¥à¤Î¼èÆÀ(view¤È¤Î·ë¹ç¤Î¤¿¤á¡¢¥Æ¡¼¥Ö¥ë¤òA¤ÈÄêµÁ¤·¤Æ¤ª¤¯)
+$select = "A.trackback_id, A.product_id, A.blog_name, A.title, A.url, ";
+$select .= "A.excerpt, A.status, A.create_date, A.update_date, B.name";
+$from = "dtb_trackback AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ";
 
 // ¸¡º÷¥ï¡¼¥É¤Î°ú¤­·Ñ¤®
@@ -63 +63 @@
 // ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¤Îºï½ü
 if ($_POST['mode'] == "delete") {
-    $objQuery->exec("UPDATE dtb_trackback SET del_flg = 1 WHERE trackback_id=?", array($_POST['trackback_id']));
+    $objQuery->exec("UPDATE dtb_trackback SET del_flg = 1 WHERE trackback_id = ?", array($_POST['trackback_id']));
 }
     
@@ -69 +69 @@
     
     //ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤¾¦Éʤò¸¡º÷
-    $where="tra.del_flg = 0 AND pro.del_flg = 0";
+    $where="A.del_flg = 0 AND B.del_flg = 0";
     $objPage->arrForm = $_POST;
 
@@ -89 +89 @@
                     $val = ereg_replace(" ", "%", $val);
                     $val = ereg_replace("¡¡", "%", $val);
-                    $where.= " AND tra.blog_name ILIKE ? ";
+                    $where.= " AND A.blog_name ILIKE ? ";
                     $arrval[] = "%$val%";
                     break;
@@ -96 +96 @@
                     $val = ereg_replace(" ", "%", $val);
                     $val = ereg_replace("¡¡", "%", $val);
-                    $where.= " AND tra.title ILIKE ? ";
+                    $where.= " AND A.title ILIKE ? ";
                     $arrval[] = "%$val%";
                     break;
@@ -103 +103 @@
                     $val = ereg_replace(" ", "%", $val);
                     $val = ereg_replace("¡¡", "%", $val);
-                    $where.= " AND tra.url ILIKE ? ";
+                    $where.= " AND A.url ILIKE ? ";
                     $arrval[] = "%$val%";
                     break;
@@ -109 +109 @@
                 case 'search_status':
                     if (isset($_POST['search_status'])) {
-                        $where.= " AND tra.status = ? ";
+                        $where.= " AND A.status = ? ";
                         $arrval[] = $val;
                     }
@@ -117 +117 @@
                     $val = ereg_replace(" ", "%", $val);
                     $val = ereg_replace("¡¡", "%", $val);
-                    $where.= " AND pro.name ILIKE ? ";
+                    $where.= " AND B.name ILIKE ? ";
                     $arrval[] = "%$val%";
                     break;
@@ -124 +124 @@
                     $val = ereg_replace(" ", "%", $val);
                     $val = ereg_replace("¡¡", "%", $val);
-                    $where.= " AND pro.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? )";
+                    $where.= " AND B.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? )";
                     $arrval[] = "%$val%";
                     break;
@@ -131 +131 @@
                     if (isset($_POST['search_startyear']) && isset($_POST['search_startmonth']) && isset($_POST['search_startday'])) {
                         $date = sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);
-                        $where.= " AND tra.create_date >= ? ";
+                        $where.= " AND A.create_date >= ? ";
                         $arrval[] = $date;
                     }
@@ -142 +142 @@
                         $end_date = date("Y/m/d",strtotime("1 day" ,strtotime($date)));
                         
-                        $where.= " AND tra.create_date <= cast('$end_date' as date) ";
+                        $where.= " AND A.create_date <= cast('$end_date' as date) ";
                     }
                     break;
@@ -151 +151 @@
     }
     
-    $order = "tra.create_date DESC";
+    $order = "A.create_date DESC";
     
     // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
@@ -182 +182 @@
     if ($_POST['mode'] == 'csv'){
         // ¥ª¥×¥·¥ç¥ó¤Î»ØÄê
-        $option = "ORDER BY trackback_id";
+        $option = "ORDER BY A.trackback_id";
         // CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ®
-        $head = sfGetCSVList($arrREVIEW_CVSTITLE);
-        $data = lfGetReviewCSV($where, '', $arrval);
+        $head = sfGetCSVList($arrTRACKBACK_CVSTITLE);
+        $data = lfGetTrackbackCSV($where, '', $arrval);
         // CSV¤òÁ÷¿®¤¹¤ë¡£
         sfCSVDownload($head.$data);