D327.id816.diff
No OneTemporary
Actions

Subscribers

None

File Metadata

	Index: core/units/reviews/reviews_event_handler.php
	===================================================================
	--- core/units/reviews/reviews_event_handler.php
	+++ core/units/reviews/reviews_event_handler.php
	@@ -583,11 +583,13 @@

	// 1. add join to items table (for "Structure & Data" -> "Reviews" section)
	$item_table = $this->Application->getUnitOption($regs[1], 'TableName');
	+ $item_table_on = 'item_table.ResourceId = %1$s.ItemId';
	$ci_table = $this->Application->getUnitOption('ci', 'TableName');
	+ $ci_table_on = 'item_table.ResourceId = ci.ItemResourceId AND ci.PrimaryCat = 1';

	$list_sqls = $this->Application->getUnitOption($event->Prefix, 'ListSQLs');
	- $list_sqls[''] .= ' LEFT JOIN '.$item_table.' item_table ON item_table.ResourceId = %1$s.ItemId';
	- $list_sqls[''] .= ' LEFT JOIN '.$ci_table.' ci ON item_table.ResourceId = ci.ItemResourceId AND ci.PrimaryCat = 1';
	+ $list_sqls[''] .= PHP_EOL . ' LEFT JOIN ' . $item_table . ' item_table ON ' . $item_table_on;
	+ $list_sqls[''] .= PHP_EOL . ' LEFT JOIN ' . $ci_table . ' ci ON ' . $ci_table_on;
	$this->Application->setUnitOption($event->Prefix, 'ListSQLs', $list_sqls);

	// 2. add calculated field
	@@ -633,4 +635,4 @@
	$parent_prefix = $event->Application->getUnitOption($event->Prefix, 'ParentPrefix');
	$event->SetRedirectParam('pass', 'm,' . $event->getPrefixSpecial() . ',' . $parent_prefix);
	}
	- }
	\ No newline at end of file
	+ }