/** * Retrievs list of Values by Report * * @param RM_Report_Object obReport * @return RM_Store_iRequest<RM_ReportValue_Object> **/ public function getValuesByReport(RM_Report_Object $obReport) { $query = M('Db')->createQuery($this->_tables['report2value'])->where('report_id = ?', $obReport->id()); $value_ids = array(0); foreach ($query->execute() as $row) { $value_ids[] = $row['value_id']; } //return M('ReportValue')->getValuesList(0, $obReport->getReportBricks())->filter('id IN ('.sqlBinds($value_ids).')', $value_ids); $request = call_user_func_array(array(M('ReportValue'), 'getValuesList'), array_merge(array(NULL), $obReport->getReportBricks())); $request->filter('id IN (' . sqlBinds($value_ids) . ')', $value_ids); //print_r($request->getRequest()->getQuery()->render()); return $request; }