Index: branches/dev/html/admin/products/index_csv.php
===================================================================
--- branches/dev/html/admin/products/index_csv.php	(revision 211)
+++ branches/dev/html/admin/products/index_csv.php	(revision 11949)
@@ -29,4 +29,22 @@
 						);
 
+$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,4 +90,24 @@
 		// ³Æ¹àÌܤò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,3 +177,29 @@
 }
 
+// ³Æ¹àÌܤò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;
+}
+
 ?>
Index: branches/dev/html/admin/products/trackback.php
===================================================================
--- branches/dev/html/admin/products/trackback.php	(revision 11941)
+++ branches/dev/html/admin/products/trackback.php	(revision 11949)
@@ -49,8 +49,8 @@
 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,5 +63,5 @@
 // ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯¤Îºï½ü
 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,5 +69,5 @@
 	
 	//ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤¾¦Éʤò¸¡º÷
-	$where="tra.del_flg = 0 AND pro.del_flg = 0";
+	$where="A.del_flg = 0 AND B.del_flg = 0";
 	$objPage->arrForm = $_POST;
 
@@ -89,5 +89,5 @@
 					$val = ereg_replace(" ", "%", $val);
 					$val = ereg_replace("¡¡", "%", $val);
-					$where.= " AND tra.blog_name ILIKE ? ";
+					$where.= " AND A.blog_name ILIKE ? ";
 					$arrval[] = "%$val%";
 					break;
@@ -96,5 +96,5 @@
 					$val = ereg_replace(" ", "%", $val);
 					$val = ereg_replace("¡¡", "%", $val);
-					$where.= " AND tra.title ILIKE ? ";
+					$where.= " AND A.title ILIKE ? ";
 					$arrval[] = "%$val%";
 					break;
@@ -103,5 +103,5 @@
 					$val = ereg_replace(" ", "%", $val);
 					$val = ereg_replace("¡¡", "%", $val);
-					$where.= " AND tra.url ILIKE ? ";
+					$where.= " AND A.url ILIKE ? ";
 					$arrval[] = "%$val%";
 					break;
@@ -109,5 +109,5 @@
 				case 'search_status':
 					if (isset($_POST['search_status'])) {
-						$where.= " AND tra.status = ? ";
+						$where.= " AND A.status = ? ";
 						$arrval[] = $val;
 					}
@@ -117,5 +117,5 @@
 					$val = ereg_replace(" ", "%", $val);
 					$val = ereg_replace("¡¡", "%", $val);
-					$where.= " AND pro.name ILIKE ? ";
+					$where.= " AND B.name ILIKE ? ";
 					$arrval[] = "%$val%";
 					break;
@@ -124,5 +124,5 @@
 					$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,5 +131,5 @@
 					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,5 +142,5 @@
 						$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,5 +151,5 @@
 	}
 	
-	$order = "tra.create_date DESC";
+	$order = "A.create_date DESC";
 	
 	// ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
@@ -182,8 +182,8 @@
 	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);