Index: trunk/kernel/units/reviews/reviews_config.php =================================================================== diff -u -N -r8444 -r8481 --- trunk/kernel/units/reviews/reviews_config.php (.../reviews_config.php) (revision 8444) +++ trunk/kernel/units/reviews/reviews_config.php (.../reviews_config.php) (revision 8481) @@ -118,66 +118,71 @@ ), ), - // 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', + // 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', - 'products' => ' SELECT %1$s.* %2$s - FROM %1$s, '.TABLE_PREFIX.'Products pr - LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById', + 'products' => ' SELECT %1$s.* %2$s + FROM %1$s, '.TABLE_PREFIX.'Products pr + LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById', - 'product' => ' SELECT %1$s.* %2$s - FROM %1$s, '.TABLE_PREFIX.'Products pr - LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById', - ), + 'product' => ' SELECT %1$s.* %2$s + FROM %1$s, '.TABLE_PREFIX.'Products pr + LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById', + ), - 'ItemSQLs' => Array( ''=> 'SELECT * FROM %s'), + 'ItemSQLs' => Array ('' => 'SELECT * FROM %s'), - 'ListSortings' => Array( - '' => Array( - 'ForcedSorting' => Array('Priority' => 'desc'), - 'Sorting' => Array('CreatedOn' => 'desc'), - ) - ), + 'ListSortings' => Array ( + '' => Array( + 'ForcedSorting' => Array('Priority' => 'desc'), + 'Sorting' => Array('CreatedOn' => 'desc'), + ) + ), - 'Fields' => Array( - 'ReviewId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0), - 'CreatedOn' => Array('type' => 'int', 'formatter'=>'kDateFormatter', 'default'=>'#NOW#'), - 'ReviewText' => Array('type'=>'string','required'=>1,'not_null'=>1,'default'=>''), - 'IPAddress' => Array('type'=>'string','max_value_inc'=>15,'not_null'=>1,'default'=>''), - 'ItemId' => Array('type'=>'int','not_null'=>1,'default'=>0), - 'CreatedById' => Array('type' => 'int', 'formatter'=>'kLEFTFormatter','options'=>Array(-1=>'root',-2=>'Guest'),'left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'','left_key_field'=>'PortalUserId','left_title_field'=>'Login','required'=>1,'not_null'=>1,'default'=>-1), - 'ItemType' => Array('type'=>'int','not_null'=>1,'default'=>0), - 'Priority' => Array('type'=>'int','not_null'=>1,'default'=>0), - 'Status' => Array('type' => 'int', 'formatter'=>'kOptionsFormatter', 'use_phrases' => 1, 'options'=>Array(1=>'la_Active',2=>'la_Pending',0=>'la_Disabled'),'not_null'=>1,'default'=>2 ), - 'TextFormat' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_text', 1 => 'la_html'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 0), - 'Module' => Array('type'=>'string','not_null'=>1,'default'=>''), - ), - 'VirtualFields' => Array( - 'ReviewedBy' => Array(), - ), + 'Fields' => Array ( + 'ReviewId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0), + 'CreatedOn' => Array('type' => 'int', 'formatter'=>'kDateFormatter', 'default'=>'#NOW#'), + 'ReviewText' => Array('type'=>'string','required'=>1,'not_null'=>1,'default'=>''), + 'Rating' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'lu_None', 1 => 'lu_Rating_1', 2 => 'lu_Rating_2', 3 => 'lu_Rating_3', 4 => 'lu_Rating_4', 5 => 'lu_Rating_5'), 'use_phrases' => 1, 'min_value_inc' => 0, 'max_value_inc' => 5, 'default' => 0), + 'IPAddress' => Array('type'=>'string','max_value_inc'=>15,'not_null'=>1,'default'=>''), + 'ItemId' => Array('type'=>'int','not_null'=>1,'default'=>0), + 'CreatedById' => Array('type' => 'int', 'formatter'=>'kLEFTFormatter','options'=>Array(-1=>'root',-2=>'Guest'),'left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'','left_key_field'=>'PortalUserId','left_title_field'=>'Login','required'=>1,'not_null'=>1,'default'=>-1), + 'ItemType' => Array('type'=>'int','not_null'=>1,'default'=>0), + 'Priority' => Array('type'=>'int','not_null'=>1,'default'=>0), + 'Status' => Array('type' => 'int', 'formatter'=>'kOptionsFormatter', 'use_phrases' => 1, 'options'=>Array(1=>'la_Active',2=>'la_Pending',0=>'la_Disabled'),'not_null'=>1,'default'=>2 ), + 'TextFormat' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_text', 1 => 'la_html'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 0), + 'Module' => Array('type'=>'string','not_null'=>1,'default'=>''), + ), - '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'), - 'ReviewedBy' => Array( 'title'=>'la_col_ReviewedBy' ), - 'CreatedOn_formatted' => Array( 'title'=>'la_col_CreatedOn', 'sort_field' => 'CreatedOn' ), - 'Status' => Array( 'title'=>'la_col_Status' ), - ), + 'VirtualFields' => Array ( + 'ReviewedBy' => Array('type' => 'string', 'default' => ''), + ), - ), + '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'), + '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' ), + ), + ), - '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'), - 'ReviewedBy' => Array( 'title'=>'la_col_ReviewedBy' ), - 'CreatedOn_formatted' => Array( 'title'=>'la_col_CreatedOn', 'sort_field' => 'CreatedOn' ), - 'Status' => Array( 'title'=>'la_col_Status' ), - ), - - ), - ), + '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'), + 'ReviewedBy' => Array( 'title'=>'la_col_ReviewedBy' ), + 'CreatedOn_formatted' => Array( 'title'=>'la_col_CreatedOn', 'sort_field' => 'CreatedOn' ), + 'Status' => Array( 'title'=>'la_col_Status' ), + ), + ), + ), ); ?> \ No newline at end of file