Index: trunk/kernel/units/reviews/reviews_config.php =================================================================== diff -u -N -r8029 -r8369 --- trunk/kernel/units/reviews/reviews_config.php (.../reviews_config.php) (revision 8029) +++ trunk/kernel/units/reviews/reviews_config.php (.../reviews_config.php) (revision 8369) @@ -1,77 +1,87 @@ 'rev', + $config = Array ( + 'Prefix' => 'rev', + + 'Clones' => Array ( + 'l-rev' => Array( + 'ParentPrefix' => 'l', + 'ConfigMapping' => Array ( + 'PerPage' => 'Perpage_LinkReviews', + 'ShortListPerPage' => 'Perpage_LinkReviews', + 'DefaultSorting1Field' => 'Link_ReviewsSort', + 'DefaultSorting2Field' => 'Link_ReviewsSort2', + 'DefaultSorting1Dir' => 'Link_ReviewsOrder', + 'DefaultSorting2Dir' => 'Link_ReviewsOrder2', + ), + ), + + 'n-rev' => Array( + 'ParentPrefix' => 'n', + ), + 'bb-rev'=> Array( + 'ParentPrefix' => 'bb', + ), + /*'p-rev' => Array('ParentPrefix' => 'p'),*/ + ), + + 'ItemClass' => Array('class'=>'kDBItem','file'=>'','build_event'=>'OnItemBuild'), + 'ListClass' => Array('class'=>'kDBList','file'=>'','build_event'=>'OnListBuild'), + 'EventHandlerClass' => Array('class'=>'ReviewsEventHandler','file'=>'reviews_event_handler.php','build_event'=>'OnBuild'), + 'TagProcessorClass' => Array('class'=>'ReviewsTagProcessor','file'=>'reviews_tag_processor.php','build_event'=>'OnBuild'), + 'AutoLoad' => true, + + 'QueryString' => Array ( + 1 => 'id', + 2 => 'Page', + 3 => 'event', + 4 => 'mode', + ), + + 'ParentPrefix' => 'p', // replace all usage of rev to "p-rev" and then remove this param from here and Prefix too + + 'IDField' => 'ReviewId', + 'StatusField' => Array('Status'), // field, that is affected by Approve/Decline events + 'TableName' => TABLE_PREFIX.'ItemReview', + 'ParentTableKey' => 'ResourceId', // linked field in master table + 'ForeignKey' => 'ItemId', // linked field in subtable + + 'AutoDelete' => true, + 'AutoClone' => true, + + 'TitlePresets' => Array ( + 'reviews_edit' => Array('format' => "!la_title_Editing_Review!"), + ), + + 'FilterMenu' => Array ( + 'Groups' => Array( + Array('mode' => 'AND', 'filters' => Array('show_active','show_pending','show_disabled'), 'type' => WHERE_FILTER), + ), + 'Filters' => Array( + 'show_active' => Array('label' =>'la_Active', 'on_sql' => '', 'off_sql' => '%1$s.Status != 1' ), + 'show_pending' => Array('label' => 'la_Pending', 'on_sql' => '', 'off_sql' => '%1$s.Status != 2' ), + 'show_disabled' => Array('label' => 'la_Disabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 0' ), + ) + ), - 'Clones' => Array( - 'l-rev' => Array( - 'ParentPrefix' => 'l', - ), - 'n-rev' => Array( - 'ParentPrefix' => 'n', - ), - 'bb-rev'=> Array( - 'ParentPrefix' => 'bb', - ), - /*'p-rev' => Array('ParentPrefix' => 'p'),*/ - ), + 'CalculatedFields' => Array ( + '' => Array ( + 'ReviewedBy' => 'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )', + ), + + 'products' => Array ( + 'ReviewedBy' => 'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )', + 'ItemName' => 'pr.l1_Name', + 'ProductId' => 'pr.ProductId', + ), + + 'product' => Array ( + 'ReviewedBy' => 'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )', + 'ItemName' => 'pr.l1_Name', + 'ProductId' => 'pr.ProductId', + ), + ), - 'ItemClass' => Array('class'=>'kDBItem','file'=>'','build_event'=>'OnItemBuild'), - 'ListClass' => Array('class'=>'kDBList','file'=>'','build_event'=>'OnListBuild'), - 'EventHandlerClass' => Array('class'=>'ReviewsEventHandler','file'=>'reviews_event_handler.php','build_event'=>'OnBuild'), - 'TagProcessorClass' => Array('class'=>'ReviewsTagProcessor','file'=>'reviews_tag_processor.php','build_event'=>'OnBuild'), - 'AutoLoad' => true, - - 'QueryString' => Array( - 1 => 'id', - 2 => 'page', - 3 => 'event', - 4 => 'mode', - ), - - - 'ParentPrefix' => 'p', // replace all usage of rev to "p-rev" and then remove this param from here and Prefix too - - 'IDField' => 'ReviewId', - 'StatusField' => Array('Status'), // field, that is affected by Approve/Decline events - 'TableName' => TABLE_PREFIX.'ItemReview', - 'ParentTableKey' => 'ResourceId', // linked field in master table - 'ForeignKey' => 'ItemId', // linked field in subtable - - 'AutoDelete' => true, - 'AutoClone' => true, - - 'TitlePresets' => Array( - 'reviews_edit' => Array('format' => "!la_title_Editing_Review!"), - ), - 'FilterMenu' => Array( - 'Groups' => Array( - Array('mode' => 'AND', 'filters' => Array('show_active','show_pending','show_disabled'), 'type' => WHERE_FILTER), - ), - 'Filters' => Array( - 'show_active' => Array('label' =>'la_Active', 'on_sql' => '', 'off_sql' => '%1$s.Status != 1' ), - 'show_pending' => Array('label' => 'la_Pending', 'on_sql' => '', 'off_sql' => '%1$s.Status != 2' ), - 'show_disabled' => Array('label' => 'la_Disabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 0' ), - ) - ), - - 'CalculatedFields' => Array( - '' => Array( - 'ReviewedBy' => 'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )', - ), - 'products' => Array( - 'ReviewedBy' => 'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )', - 'ItemName' => 'pr.l1_Name', - 'ProductId' => 'pr.ProductId', - ), - 'product' => Array( - 'ReviewedBy' => 'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )', - 'ItemName' => 'pr.l1_Name', - 'ProductId' => 'pr.ProductId', - ), - - ), - // key - special, value - list select sql 'ListSQLs' => Array( ''=>'SELECT %1$s.* %2$s FROM %1$s LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById',