VtigerCRM 7.2 版本- 修复排序错误

VtigerCRM 7.2 版本出现明显的模块排序错误
任意模块排序后点击记录出现500错误
修复办法如下, 8个文件ListView.php 修改代码

modules/Calendar/models/ListView.php

206-        $orderBy = $this->get('orderby');
207-		$sortOrder = $this->get('sortorder');
206+        $orderBy = $this->getForSql('orderby');
207+		$sortOrder = $this->getForSql('sortorder');

modules/Documents/models/ListView.php

176-        $orderBy = $this->get('orderby');
177-		$sortOrder = $this->get('sortorder');
176+        $orderBy = $this->getForSql('orderby');
177+		$sortOrder = $this->getForSql('sortorder');

modules/PriceBooks/models/ListView.php

76-        $orderBy = $this->get('orderby');
77-		$sortOrder = $this->get('sortorder');
76+        $orderBy = $this->getForSql('orderby');
77+		$sortOrder = $this->getForSql('sortorder');

modules/Products/models/ListView.php

46-        $orderBy = $this->get('orderby');
47-		$sortOrder = $this->get('sortorder');
46+        $orderBy = $this->getForSql('orderby');
47+		$sortOrder = $this->getForSql('sortorder');

modules/Reports/models/ListView.php

98-		$orderBy = $this->get('orderby');
98+		$orderBy = $this->getForSql('orderby');

107-			$reportFolderModel->set('sortby', $this->get('sortorder'));
107+			$reportFolderModel->set('sortby', $this->getForSql('sortorder'));

modules/Vtiger/models/ListView.php

209-		$orderBy = $this->get('orderby');
210-		$sortOrder = $this->get('sortorder');
209+		$orderBy = $this->getForSql('orderby');
210+		$sortOrder = $this->getForSql('sortorder');

241-				$listQuery .= ' ORDER BY ? '.$sortOrder;
242-				array_push($paramArray, $queryGenerator->getOrderByColumn($orderBy));
241+				$listQuery .= ' ORDER BY '.$queryGenerator->getOrderByColumn($orderBy).' '.$sortOrder;

pkg/vtiger/modules/Import/modules/Import/models/ListView.php

65-		$orderBy = $this->get('orderby');
66-		$sortOrder = $this->get('sortorder');
65+		$orderBy = $this->getForSql('orderby');
66+		$sortOrder = $this->getForSql('sortorder');

pkg/vtiger/modules/RecycleBin/modules/RecycleBin/models/ListView.php

51-		$orderBy = $this->get('orderby');
52-		$sortOrder = $this->get('sortorder');
51+		$orderBy = $this->getForSql('orderby');
52+		$sortOrder = $this->getForSql('sortorder');

修复完成后,排序点击恢复正常