Index: /temp/trunk/html/admin/products/index.php
===================================================================
--- /temp/trunk/html/admin/products/index.php	(revision 2013)
+++ /temp/trunk/html/admin/products/index.php	(revision 2145)
@@ -131,17 +131,18 @@
 			
 			switch ($key) {
-				case 'search_product_id':
+				case 'search_product_id':	// ¾¦ÉÊID
 					$where .= " AND product_id = ?";
 					$arrval[] = $val;
 					break;
-				case 'search_product_class_id':
-					$where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_class_id = ?)";
+				case 'search_product_class_id': //µ¬³Ê̾¾Î
+					//$where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_class_id = ?)";
+					$where .= " AND  product_id IN (SELECT product_id FROM dtb_products_class WHERE classcategory_id1 IN (SELECT classcategory_id FROM dtb_classcategory WHERE class_id IN (SELECT class_id FROM dtb_class WHERE name LIKE '%¥¤%'))) ";
 					$arrval[] = $val;
 					break;
-				case 'search_name':
+				case 'search_name':			// ¾¦ÉÊ̾
 					$where .= " AND name ILIKE ?";
 					$arrval[] = "%$val%";
 					break;
-				case 'search_category_id':
+				case 'search_category_id':	// ¥«¥Æ¥´¥ê¡¼
 					list($tmp_where, $tmp_arrval) = sfGetCatWhere($val);
 					if($tmp_where != "") {
@@ -150,19 +151,19 @@
 					}
 					break;
-				case 'search_product_code':
+				case 'search_product_code':	// ¾¦ÉÊ¥³¡¼¥É
 					$where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";
 					$arrval[] = "%$val%";
 					break;
-				case 'search_startyear':
+				case 'search_startyear':	// ÅÐÏ¿¹¹¿·Æü¡ÊFROM¡Ë
 					$date = sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);
 					$where.= " AND update_date >= ?";
 					$arrval[] = $date;
 					break;
-				case 'search_endyear':
+				case 'search_endyear':		// ÅÐÏ¿¹¹¿·Æü¡ÊTO¡Ë
 					$date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);
 					$where.= " AND update_date <= ?";
 					$arrval[] = $date;
 					break;
-				case 'search_product_flag':
+				case 'search_product_flag':	//¼ïÊÌ
 					global $arrSTATUS;
 					$search_product_flag = sfSearchCheckBoxes($val);
@@ -172,5 +173,5 @@
 					}
 					break;
-				case 'search_status':
+				case 'search_status':		// ¥¹¥Æ¡¼¥¿¥¹
 					$tmp_where = "";
 					foreach ($val as $element){