Changeset 11949 for branches/dev/html/admin/products/trackback.php

Timestamp:

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

Author:

inoue

Message:

プロトタイプ

File:

• branches/dev/html/admin/products/trackback.php (modified) (13 diffs)

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);