/**
* Generates the report by processing the XML file.
* @param array $params
*/
public function generate($params)
{
$report = $this->getReport();
$reader = new XMLReader();
$reader->XML($this->xml->asXML());
while ($reader->read()) {
if ($reader->nodeType !== XMLReader::ELEMENT) {
continue;
}
switch ($reader->name) {
case "rapi:logo":
if ($_POST["hide_logo"] == 1) {
$text = new TextContent();
$text->style["flow"] = true;
$text->setText("\n\n\n\n\n\n\n\n");
$report->add($text);
} else {
$reader->moveToAttribute("class");
$class = $reader->value;
$logo = $class == '' ? new LogoContent() : new $class();
$report->add($logo);
$report->logo = $logo;
}
break;
case "rapi:text":
$text = new TextContent();
$reader->moveToAttribute("style");
switch ($reader->value) {
case "heading":
$text->style["size"] = 16;
$text->style["font"] = "Helvetica";
$text->style["bold"] = true;
$report->label = $text;
break;
default:
$text->style["size"] = $reader->moveToAttribute("size") ? $reader->value : 12;
$text->style["font"] = $reader->value ? $reader->moveToAttribute("font") : "Helvetica";
break;
}
$reader->read();
$text->setText($reader->value);
$report->add($text);
break;
case "rapi:table":
$numConcatFields = 0;
$reader->moveToAttribute("name");
$name = $reader->value;
$tableConditionsArray = array();
if ($reader->moveToAttribute("conditions")) {
$tableConditionsArray[] = $reader->value;
}
if ($this->tableConditions != '') {
$tableConditionsArray[] = $this->tableConditions;
}
$tableConditions = implode(" AND ", $tableConditionsArray);
$fields = $this->xml->xpath("/rapi:report/rapi:table[@name='{$name}']/rapi:fields/rapi:field");
$headers = $this->xml->xpath("/rapi:report/rapi:table[@name='{$name}']/rapi:fields/rapi:field[@label!='']/@label");
$dontJoins = $this->xml->xpath("/rapi:report/rapi:table[@name='{$name}']/rapi:dont_join/rapi:pair");
$ignoredFields = array();
$dataParams["total"] = array();
$hardCodedSorting = array();
$reportGroupingFields = array();
$models = array();
$fieldInfos = array();
// Generate filter conditions
$filters = array();
$filterSummaries = array();
$keyOffset = 0;
foreach ($fields as $key => $field) {
// Load the model for this field if it hasn't been
// loaded already. I have a hunch that this check
// is really not necessary since the model loader
// sort of caches loaded models now.
$modelInfo = Model::resolvePath((string) $field);
if (array_search($modelInfo["model"], array_keys($models)) === false) {
$models[$modelInfo["model"]] = Model::load($modelInfo["model"]);
}
$model = $models[$modelInfo["model"]];
$fieldInfo = $model->getFields(array($modelInfo["field"]));
$fieldInfo = $fieldInfo[0];
$fieldInfos[(string) $field] = $fieldInfo;
//Ignore fields which are not needed.
if (isset($_POST[$name . "_" . $fieldInfo["name"] . "_ignore"])) {
$ignoredFields[] = $key;
}
if (isset($field["sort"])) {
$sortField = "{$model->database}.{$fieldInfo["name"]}";
$hardCodedSorting[] = array("field" => $sortField, "type" => $field["sort"]);
}
if (isset($field["labelsField"])) {
$dynamicFields[] = (string) $field;
$dynamicHeaders[] = (string) $field["labelsField"];
$labelModelInfo = Model::resolvePath($field["labelsField"]);
$headersModel = Model::load($labelModelInfo["model"]);
$dynamicHeaderValues = $headersModel->get(array("fields" => array($labelModelInfo["field"])), SQLDataBaseModel::MODE_ARRAY);
foreach ($dynamicHeaderValues as $headerValue) {
$tableHeaders[] = $headerValue[0];
if ($field["total"] == "true") {
$dataParams["total"][] = true;
//$key + $keyOffset;
$dataParams["type"][] = "double";
}
$keyOffset++;
}
$keyOffset--;
} else {
$tableHeaders[] = (string) $field["label"];
switch ($fieldInfo["type"]) {
case "integer":
$dataParams["type"][] = "number";
break;
case "double":
$dataParams["type"][] = "double";
break;
default:
$dataParams["type"][] = "";
}
$dataParams["total"][] = $field["total"] == "true" ? true : false;
}
$fields[$key] = (string) $field;
$value = $field["value"];
$field = (string) $field;
if (array_search($model->getKeyField(), $this->referencedFields) === false || $fieldInfo["type"] == "double" || $fieldInfo["type"] == "date") {
if ($value != null) {
$filters[] = "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}='{$value}'";
continue;
}
switch ($fieldInfo["type"]) {
case "string":
case "text":
if ($_POST[$name . "_" . $fieldInfo["name"] . "_value"] != "") {
switch ($_POST[$name . "_" . $fieldInfo["name"] . "_option"]) {
case "CONTAINS":
$filterSummaries[] = "{$headers[$key]} containing {$_POST[$name . "_" . $fieldInfo["name"] . "_value"]}";
$filters[] = $models[$modelInfo["model"]]->getSearch($models[$modelInfo["model"]]->escape($_POST[$name . "_" . $fieldInfo["name"] . "_value"]), "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}");
break;
case "EXACTLY":
$filterSummaries[] = "{$headers[$key]} being exactly {$_POST[$name . "_" . $fieldInfo["name"] . "_value"]}";
$filters[] = "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}='" . $models[$modelInfo["model"]]->escape($_POST[$name . "_" . $fieldInfo["name"] . "_value"]) . "'";
break;
}
}
break;
case "integer":
case "double":
if ($_POST[$name . "_" . $fieldInfo["name"] . "_start_value"] != "") {
switch ($_POST[$name . "_" . $fieldInfo["name"] . "_option"]) {
case "EQUALS":
$filterSummaries[] = "{$headers[$key]} equals {$_POST[$name . "_" . $fieldInfo["name"] . "_start_value"]}";
$filters[] = "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}='" . $models[$modelInfo["model"]]->escape($_POST[$name . "_" . $fieldInfo["name"] . "_start_value"]) . "'";
break;
case "GREATER":
$filterSummaries[] = "{$headers[$key]} greater than {$_POST[$name . "_" . $fieldInfo["name"] . "_start_value"]}";
$filters[] = "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}>'" . $models[$modelInfo["model"]]->escape($_POST[$name . "_" . $fieldInfo["name"] . "_start_value"]) . "'";
break;
case "LESS":
$filterSummaries[] = "{$headers[$key]} less than {$_POST[$name . "_" . $fieldInfo["name"] . "_start_value"]}";
$filters[] = "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}<'" . $models[$modelInfo["model"]]->escape($_POST[$name . "_" . $fieldInfo["name"] . "_start_value"]) . "'";
break;
case "BETWEEN":
$filterSummaries[] = "{$headers[$key]} between {$_POST[$name . "_" . $fieldInfo["name"] . "_start_value"]} and {$_POST[$name . "_" . $fieldInfo["name"] . "_end_value"]}";
$filters[] = "({$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}>='" . $models[$modelInfo["model"]]->escape($_POST[$name . "_" . $fieldInfo["name"] . "_start_value"]) . "' AND {$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}<='" . $models[$modelInfo["model"]]->escape($_POST[$name . "_" . $fieldInfo["name"] . "_end_value"]) . "')";
break;
}
}
break;
case "reference":
break;
case "datetime":
case "date":
if ($_POST[$name . "_" . $fieldInfo["name"] . "_start_date"] != "") {
switch ($_POST[$name . "_" . $fieldInfo["name"] . "_option"]) {
case "EQUALS":
$filterSummaries[] = "{$headers[$key]} on {$_POST[$name . "_" . $fieldInfo["name"] . "_start_date"]}";
$filters[] = "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}='" . $models[$modelInfo["model"]]->escape(Common::stringToDatabaseDate($_POST[$name . "_" . $fieldInfo["name"] . "_start_date"])) . "'";
break;
case "GREATER":
$filterSummaries[] = "{$headers[$key]} after {$_POST[$name . "_" . $fieldInfo["name"] . "_start_date"]}";
$filters[] = "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}>'" . $models[$modelInfo["model"]]->escape(Common::stringToDatabaseDate($_POST[$name . "_" . $fieldInfo["name"] . "_start_date"])) . "'";
break;
case "LESS":
$filterSummaries[] = "{$headers[$key]} before {$_POST[$name . "_" . $fieldInfo["name"] . "_start_date"]}";
$filters[] = "{$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}<'" . $models[$modelInfo["model"]]->escape(Common::stringToDatabaseDate($_POST[$name . "_" . $fieldInfo["name"] . "_start_date"])) . "'";
break;
case "BETWEEN":
$filterSummaries[] = "{$headers[$key]} from {$_POST[$name . "_" . $fieldInfo["name"] . "_start_date"]} to {$_POST[$name . "_" . $fieldInfo["name"] . "_end_date"]}";
$filters[] = "({$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}>='" . $models[$modelInfo["model"]]->escape(Common::stringToDatabaseDate($_POST[$name . "_" . $fieldInfo["name"] . "_start_date"])) . "' AND {$models[$modelInfo["model"]]->getDatabase()}.{$fieldInfo["name"]}<='" . $models[$modelInfo["model"]]->escape(Common::stringToDatabaseDate($_POST[$name . "_" . $fieldInfo["name"] . "_end_date"])) . "')";
break;
}
}
break;
case "enum":
if (count($_POST[$name . "_" . $fieldInfo["name"] . "_value"]) >= 1 && $_POST[$name . "_" . $fieldInfo["name"] . "_value"][0] != "") {
$m = $models[$modelInfo["model"]];
if ($_POST[$name . "_" . $fieldInfo["name"] . "_option"] == "INCLUDE") {
$summary = array();
foreach ($_POST[$name . "_" . $fieldInfo["name"] . "_value"] as $value) {
$summary[] = $fieldInfo["options"][$value];
}
$filterSummaries[] = "{$headers[$key]} being " . implode(", ", $summary);
$condition = array();
foreach ($_POST[$name . "_" . $fieldInfo["name"] . "_value"] as $value) {
if ($value != "") {
$condition[] = "{$m->getDatabase()}.{$fieldInfo["name"]}='" . $m->escape($value) . "'";
}
}
} else {
if ($_POST[$name . "_" . $fieldInfo["name"] . "_option"] == "EXCLUDE") {
$summary = array();
foreach ($_POST[$name . "_" . $fieldInfo["name"] . "_value"] as $value) {
$summary[] = $fieldInfo["options"][$value];
}
$filterSummaries[] = "{$headers[$key]} excluding " . implode(", ", $summary);
$condition = array();
foreach ($_POST[$name . "_" . $fieldInfo["name"] . "_value"] as $value) {
if ($value != "") {
$condition[] = "{$m->getDatabase()}.{$fieldInfo["name"]}<>'" . $m->escape($value) . "'";
}
}
}
}
if (count($condition) > 0) {
$filters[] = "(" . implode(" OR ", $condition) . ")";
}
}
break;
}
} else {
if ($_POST[$name . "_" . $fieldInfo["name"] . "_value"] != "") {
if ($_POST[$name . "_" . $fieldInfo["name"] . "_option"] == "IS_ANY_OF") {
foreach ($_POST[$name . "_" . $fieldInfo["name"] . "_value"] as $value) {
if ($value != "") {
$condition[] = "{$model->getDatabase()}.{$fieldInfo["name"]}='" . $model->escape($value) . "'";
}
}
} else {
if ($_POST[$name . "_" . $fieldInfo["name"] . "_option"] == "IS_NONE_OF") {
foreach ($_POST[$name . "_" . $fieldInfo["name"] . "_value"] as $value) {
if ($value != "") {
$condition[] = "{$model->getDatabase()}.{$fieldInfo["name"]}<>'" . $model->escape($value) . "'";
}
}
}
}
if (count($condition) > 0) {
$filters[] = "(" . implode(" OR ", $condition) . ")";
}
}
}
}
$this->updateFilterSummaries($filterSummaries);
// Generate the various tables taking into consideration grouping
if (count($filterSummaries) > 0) {
$report->filterSummary = new TextContent(str_replace("\\n", " ", implode("\n", $filterSummaries)), array("size" => 8, "bottom_margin" => 3));
$report->filterSummary->style["flow"] = true;
$report->add($report->filterSummary);
}
$params = array("fields" => $fields, "dynamicFields" => $dynamicFields, "dynamicHeaders" => $dynamicHeaders, "conditions" => implode(" AND ", $filters), "report" => $report, "headers" => $tableHeaders, "dont_join" => array());
foreach ($dontJoins as $pair) {
$params['dont_join'][] = (string) $pair;
}
if ($tableConditions != "") {
$params["conditions"] = $params['conditions'] . ($params['conditions'] != '' ? " AND " : '') . "({$tableConditions})";
}
if ($_POST[$name . "_sorting"] != "") {
array_unshift($hardCodedSorting, array("field" => $_POST[$name . "_sorting"], "type" => $_POST[$name . "_sorting_direction"]));
}
if (is_array($_POST[$name . "_grouping"])) {
foreach ($_POST[$name . "_grouping"] as $postGrouping) {
if ($postGrouping != "") {
$groupingFields = explode(",", $postGrouping);
foreach ($groupingFields as $key => $groupingField) {
$modelInfo = Model::resolvePath($groupingField);
$model = Model::load($modelInfo["model"]);
$groupingFields[$key] = "{$model->database}.{$modelInfo["field"]}";
}
$reportGroupingFields[] = array("field" => $model->datastore->concatenate($groupingFields), "type" => "ASC");
}
}
//$reportGroupingFields = array_reverse($reportGroupingFields);
$hardCodedSorting = array_merge($reportGroupingFields, $hardCodedSorting);
}
$params["sort_field"] = $hardCodedSorting;
if ($_POST[$name . "_limit"] != '') {
$params['limit'] = $_POST[$name . "_limit"];
}
$params["no_num_formatting"] = true;
$params = $this->paramsCallback($params);
$this->reportData = ReportController::getReportData($params, SQLDatabaseModel::MODE_ARRAY);
unset($params["sort_field"]);
$wparams = $params;
$wparams["global_functions"] = array("LENGTH", "MAX");
$wparams["global_functions_set"] = true;
$this->widths = ReportController::getReportData($wparams, SQLDatabaseModel::MODE_ARRAY);
//SQLDBDataStore::getMulti($wparams,SQLDatabaseModel::MODE_ARRAY);
$this->widths = $this->widths[0];
foreach ($tableHeaders as $i => $header) {
foreach (explode("\\n", $header) as $line) {
if (strlen($line) / 2 > $this->widths[$i]) {
$this->widths[$i] = strlen($line) / 2;
}
}
}
$dataParams["widths"] = $this->widths;
$params["data_params"] = $dataParams;
if (count($ignoredFields) > 0) {
foreach ($this->reportData as $key => $row) {
foreach ($ignoredFields as $ignored) {
unset($this->reportData[$key][$ignored]);
unset($params["headers"][$ignored]);
unset($params["fields"][$ignored]);
unset($params["data_params"]["type"][$ignored]);
unset($params["data_params"]["total"][$ignored]);
unset($params["data_params"]["widths"][$ignored]);
unset($this->widths[$key]);
}
$this->reportData[$key] = array_values($this->reportData[$key]);
}
$params["headers"] = array_values($params["headers"]);
$params["fields"] = array_values($params["fields"]);
$params["data_params"]["type"] = array_values($params["data_params"]["type"]);
$params["data_params"]["total"] = array_values($params["data_params"]["total"]);
$params["data_params"]["widths"] = array_values($params["data_params"]["widths"]);
$this->widths = array_values($this->widths);
}
if ($_POST[$name . "_grouping"][0] == "") {
$total = $this->drawTable($this->reportData, $params, $params["data_params"], true, $heading);
} else {
if ($_POST[$name . "_grouping"][0] != "" && $_POST["grouping_1_summary"] == '1') {
$params["grouping_fields"] = $_POST[$name . "_grouping"];
$params["grouping_level"] = 0;
$params["previous_headings"] = array();
$params["ignored_fields"] = array();
$total = $this->generateSummaryTable($params);
} else {
$params["grouping_fields"] = $_POST[$name . "_grouping"];
$params["grouping_level"] = 0;
$params["previous_headings"] = array();
$params["ignored_fields"] = array();
$total = $this->generateTable($params);
if (is_array($total) && count($total) > 0) {
$total[0] = $total[0] == "" ? "Overall Total" : $total[0];
$dataParams["widths"] = $this->widths;
$totalTable = new TableContent($tableHeaders, null);
$totalTable->data_params = $dataParams;
$totalTable->style["totalsBox"] = true;
foreach ($total as $key => $value) {
if (is_numeric($value)) {
$total[$key] = $value;
}
}
$totalTable->setData($total);
$report->add($totalTable);
}
}
}
break;
}
}
$report->output();
//die();
}