*/
require_once 'modules/AOW_WorkFlow/aow_utils.php';
require_once 'modules/AOR_Reports/aor_utils.php';
#[\AllowDynamicProperties]
class AOR_ReportsViewEdit extends ViewEdit
{
public function __construct()
{
parent::__construct();
}
public function preDisplay()
{
global $app_list_strings;
echo "";
if (!is_file('cache/jsLanguage/AOR_Fields/' . $GLOBALS['current_language'] . '.js')) {
require_once('include/language/jsLanguage.php');
jsLanguage::createModuleStringsCache('AOR_Fields', $GLOBALS['current_language']);
}
echo '';
if (!is_file('cache/jsLanguage/AOR_Conditions/' . $GLOBALS['current_language'] . '.js')) {
require_once('include/language/jsLanguage.php');
jsLanguage::createModuleStringsCache('AOR_Conditions', $GLOBALS['current_language']);
}
echo '';
echo "";
$fields = $this->getFieldLines();
echo "";
$conditions = $this->getConditionLines();
echo "";
$charts = $this->getChartLines();
echo "";
parent::preDisplay();
}
private function getConditionLines()
{
if (!$this->bean->id) {
return array();
}
$sql = "SELECT id FROM aor_conditions WHERE aor_report_id = '".$this->bean->id."' AND deleted = 0 ORDER BY condition_order ASC";
$result = $this->bean->db->query($sql);
$conditions = array();
while ($row = $this->bean->db->fetchByAssoc($result)) {
$condition_name = BeanFactory::newBean('AOR_Conditions');
$condition_name->retrieve($row['id']);
if (!$condition_name->parenthesis) {
$condition_name->module_path = implode(":", unserialize(base64_decode($condition_name->module_path)));
}
if ($condition_name->value_type == 'Date') {
$condition_name->value = unserialize(base64_decode($condition_name->value));
}
$condition_item = $condition_name->toArray();
if (!$condition_name->parenthesis) {
$display = getDisplayForField($condition_name->module_path, $condition_name->field, $this->bean->report_module);
$condition_item['module_path_display'] = $display['module'];
$condition_item['field_label'] = $display['field'];
}
if (isset($conditions[$condition_item['condition_order']])) {
$conditions[] = $condition_item;
} else {
$conditions[$condition_item['condition_order']] = $condition_item;
}
}
return $conditions;
}
private function getFieldLines()
{
if (!$this->bean->id) {
return array();
}
$sql = "SELECT id FROM aor_fields WHERE aor_report_id = '".$this->bean->id."' AND deleted = 0 ORDER BY field_order ASC";
$result = $this->bean->db->query($sql);
$fields = array();
while ($row = $this->bean->db->fetchByAssoc($result)) {
$field_name = BeanFactory::newBean('AOR_Fields');
$field_name->retrieve($row['id']);
$field_name->module_path = implode(":", unserialize(base64_decode($field_name->module_path)));
$arr = $field_name->toArray();
$display = getDisplayForField($field_name->module_path, $field_name->field, $this->bean->report_module);
$arr['field_type'] = $display['type'];
$arr['module_path_display'] = $display['module'];
$arr['field_label'] = $display['field'];
$fields[] = $arr;
}
return $fields;
}
private function getChartLines()
{
$charts = array();
if (!$this->bean->id) {
return array();
}
foreach ($this->bean->get_linked_beans('aor_charts', 'AOR_Charts') as $chart) {
$charts[] = $chart->toArray();
}
return $charts;
}
}