Index: branches/RC/core/units/reviews/reviews_config.php =================================================================== diff -u -N -r9373 -r10455 --- branches/RC/core/units/reviews/reviews_config.php (.../reviews_config.php) (revision 9373) +++ branches/RC/core/units/reviews/reviews_config.php (.../reviews_config.php) (revision 10455) @@ -125,12 +125,12 @@ LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById', 'products' => ' SELECT %1$s.* %2$s - FROM %1$s + FROM %1$s LEFT JOIN '.TABLE_PREFIX.'Products pr ON pr.ResourceId = %1$s.ItemId LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById', 'product' => ' SELECT %1$s.* %2$s - FROM %1$s + FROM %1$s LEFT JOIN '.TABLE_PREFIX.'Products pr ON pr.ResourceId = %1$s.ItemId LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById', ), @@ -161,13 +161,17 @@ 'VirtualFields' => Array ( 'ReviewedBy' => Array('type' => 'string', 'default' => ''), + + 'CatalogItemName' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''), + 'CatalogItemId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), ), 'Grids' => Array ( 'Default' => Array ( 'Icons' => Array ('default'=>'icon16_custom.gif',1=>'icon16_review.gif',2=>'icon16_review_pending.gif',0=>'icon16_review_disabled.gif'), 'Fields' => Array ( - 'ReviewText' => Array( 'title'=>'la_col_ReviewText', 'data_block' => 'reviewtext_checkbox_td'), + 'ReviewId' => Array ('title' => 'la_col_Id', 'data_block' => 'grid_checkbox_td'), + 'ReviewText' => Array( 'title'=>'la_col_ReviewText',), 'ReviewedBy' => Array( 'title'=>'la_col_ReviewedBy' ), 'CreatedOn_formatted' => Array( 'title'=>'la_col_CreatedOn', 'sort_field' => 'CreatedOn' ), 'Status' => Array( 'title'=>'la_col_Status' ), @@ -178,10 +182,12 @@ 'ReviewsSection' => Array ( 'Icons' => Array ('default'=>'icon16_custom.gif',1=>'icon16_review.gif',2=>'icon16_review_pending.gif',0=>'icon16_review_disabled.gif'), 'Fields' => Array ( - 'ReviewText' => Array( 'title'=>'la_col_ReviewText', 'data_block' => 'grid_checkbox_namelink_td'), + 'ReviewId' => Array ('title' => 'la_col_Id', 'data_block' => 'grid_checkbox_td'), + 'ReviewText' => Array( 'title'=>'la_col_ReviewText', 'data_block' => 'grid_reviewtext_td'), 'ReviewedBy' => Array( 'title'=>'la_col_ReviewedBy' ), 'CreatedOn_formatted' => Array( 'title'=>'la_col_CreatedOn', 'sort_field' => 'CreatedOn' ), 'Status' => Array( 'title'=>'la_col_Status' ), + 'Rating' => Array( 'title'=>'la_col_Rating' ), ), ), ),