function each_line($val) { reportico_report::each_line($val); // Set the values for the fields in the record $this->results["data"][$this->line_ct] = array(); if ($this->line_ct == 0) { $qn = get_query_column("golap", $this->columns); if ($qn) { $arr = explode(",", $qn->column_value); foreach ($arr as $k => $v) { $arr1 = explode("=", $v); $this->results["displaylike"][$arr1[0]] = $arr1[1]; } } } foreach ($this->query->display_order_set["column"] as $col) { $qn = get_query_column($col->query_name, $this->columns); $coltitle = $col->derive_attribute("column_title", $col->query_name); $coltitle = str_replace("_", " ", $coltitle); $coltitle = ucwords(strtolower($coltitle)); $coltitle = sw_translate($coltitle); $disp = $col->derive_attribute("column_display", "show"); if ($disp == "hide") { continue; } $this->results["data"][$this->line_ct][$coltitle] = $qn->column_value; } $this->line_ct++; }
function each_line($val) { reportico_report::each_line($val); // Set the values for the fields in the record $record = array(); foreach ($this->query->display_order_set["column"] as $col) { $qn = get_query_column($col->query_name, $this->columns); $this->results[$qn->query_name][] = $qn->column_value; $ct = count($this->results[$qn->query_name]); } }
function each_line($val) { reportico_report::each_line($val); if ($this->page_line_count == 1) { //$this->text .="<tr class='swPrpCritLine'>"; //foreach ( $this->columns as $col ) //$this->format_column_header($col); //$this->text .="</tr>"; } $this->soapline = array(); foreach ($this->query->display_order_set["column"] as $col) { $this->format_column($col); } $this->soapdata[] = new soapval('ReportLine', 'ReportLineType', $this->soapline); }
function each_line($val) { reportico_report::each_line($val); if (session_request_item("target_style", "TABLE") == "FORM") { if (!$this->page_started) { $formpagethrow = $this->query->get_attribute("formBetweenRows"); switch ($formpagethrow) { case "newpage": if ($this->page_line_count > 0) { $formpagethrow = "swRepPageFormLine swNewPage"; } else { $formpagethrow = "swRepPageFormLine"; } break; case "blankline": $formpagethrow = "swRepPageFormBlank"; break; case "solidline": $formpagethrow = "swRepPageFormLine"; break; } $this->text .= '<TABLE class="' . $this->query->getBootstrapStyle("page") . 'swRepPage ' . $formpagethrow . '" ' . $this->get_style_tags($this->query->output_page_styles) . '>'; $this->page_started = true; } foreach ($this->query->groups as $val) { for ($i = 0; $i < count($val->headers); $i++) { $col =& $val->headers[$i]; $col =& $val->headers[$i]["GroupHeaderColumn"]; $custom = $val->headers[$i]["GroupHeaderCustom"]; $this->format_group_header($col, $custom, true); } } foreach ($this->query->display_order_set["column"] as $k => $w) { if ($w->attributes["column_display"] != "show") { continue; } $this->format_group_header($w, false, false); } $this->page_line_count++; $this->line_count++; $this->text .= '</TABLE>'; $this->page_started = false; return; } if ($this->page_line_count == 1) { //$this->text .="<tr class='swPrpCritLine'>"; //foreach ( $this->columns as $col ) //$this->format_column_header($col); //$this->text .="</tr>"; } //foreach ( $this->columns as $col ) if ($this->body_display == "show" && get_reportico_session_param("target_show_detail")) { $this->begin_line(); if (!$this->page_started) { $this->text .= '<TABLE class="' . $this->query->getBootstrapStyle("page") . 'swRepPage" ' . $this->get_style_tags($this->query->output_page_styles) . '>'; $this->page_started = true; } foreach ($this->query->display_order_set["column"] as $col) { $this->format_column($col); } $this->end_line(); } //if ( $y < $this->abs_bottom_margin ) //{ //$this->finish_page(); //$this->begin_page(); //} }
function each_line($val) { if (!$this->columns_calculated) { // Calulate position and width of column detail taking into account // Report Body and Page styles $this->calculateColumnMetrics(); $this->columns_calculated = true; } reportico_report::each_line($val); if (session_request_item("target_style", "TABLE") == "FORM") { $this->end_line(); // Throw new page if set to throw between rows $formpagethrow = $this->query->get_attribute("formBetweenRows"); if ($this->line_count > 1 && $formpagethrow == "newpage") { $this->finish_page(); $this->begin_page(); } // Throw new page if current position + number headers + line + headers > than bottom margin $ln = 0; $totheaderheight = 0; $prevheight = $this->calculated_line_height; $this->apply_style_tags("ROW", $this->query->output_before_form_row_styles); $y = $this->document->GetY(); $this->set_position($this->abs_left_margin, $y); $this->unapply_style_tags("ROW", $this->query->output_before_form_row_styles); foreach ($this->query->groups as $val) { for ($i = 0; $i < count($val->headers); $i++) { $col =& $val->headers[$i]["GroupHeaderColumn"]; $this->format_group_header($col, false); $totheaderheight += $this->calculated_line_height; } } foreach ($this->query->display_order_set["column"] as $k => $w) { if ($w->attributes["column_display"] != "show") { continue; } $ct++; $this->format_group_header($w, false); $totheaderheight += $this->calculated_line_height; } $this->calculated_line_height = $totheaderheight; $y = $this->document->GetY(); $this->check_page_overflow(); $this->calculated_line_height = $prevheight; // Between form solid line or blank line if ($formpagethrow == "blankline") { $this->end_line(); $this->end_line(); } else { $this->end_line(); $this->apply_style_tags("AFTERFORMROW", $this->query->output_after_form_row_styles); $y = $this->document->GetY(); $this->set_position($this->abs_left_margin, $y); $this->draw_cell($this->abs_right_margin - $this->abs_left_margin, $this->vsize, "RR"); // Blank cell to continue page breaking at this size $this->unapply_style_tags("AFTERFORMROW", $this->query->output_after_form_row_styles); $this->end_line(); } return; } $y = $this->document->GetY(); $this->check_graphic_fit(); $this->yjump = 0; if ($this->body_display == "show" && get_reportico_session_param("target_show_detail")) { $this->row_styles = array(); $this->apply_style_tags("EACHHEADMID", $this->mid_cell_reportbody_styles, false, false, "ROW"); $this->apply_style_tags("EACHLINEMID", $this->mid_row_page_styles, false, false, "ROW"); $this->apply_style_tags("ROW2", $this->mid_cell_row_styles, false, false, "ROW"); $this->draw_mode = "CALCULATE"; $this->no_columns_printed = 0; $this->no_columns_to_print = 0; $this->cell_row_top_addition = $this->all_page_row_styles["style_border_top"]; $this->cell_row_bottom_addition = $this->all_page_row_styles["style_border_bottom"]; foreach ($this->columns as $col) { $this->format_column($col); } $this->cell_row_top_addition = 0; $this->cell_row_bottom_addition = 0; $this->unapply_style_tags("ROW2", $this->mid_cell_row_styles); $this->unapply_style_tags("EACHLINEMID", $this->mid_row_page_styles); $this->unapply_style_tags("EACHHEADMID", $this->mid_cell_reportbody_styles); $this->draw_mode = "DRAW"; $this->check_page_overflow(); $prev_calculated_line_height = $this->calculated_line_height; $prev_current_line_height = $this->current_line_height; $prev_max_line_height = $this->max_line_height; if ($this->column_header_required) { $this->format_headers(); $this->column_header_required = false; } $this->current_line_height = $prev_current_line_height; $this->calculated_line_height = $prev_calculated_line_height; $this->max_line_height = $prev_max_line_height; // Line page wrapper $this->new_report_page_line_by_style("LINE5PAGE", $this->mid_page_reportbody_styles, false); $this->new_report_page_line_by_style("LINE2PAGE", $this->mid_page_page_styles, false); $this->new_report_page_line_by_style("LINE2PAGE", $this->all_page_row_styles, false); // Page Styles $this->apply_style_tags("EACHHEADMID", $this->mid_cell_reportbody_styles, false, false, "ROW"); $this->apply_style_tags("EACHLINEMID", $this->mid_row_page_styles, false, false, "ROW"); $this->apply_style_tags("ROW2", $this->mid_cell_row_styles, false, false, "ROW"); $this->cell_row_top_addition = $this->all_page_row_styles["style_border_top"]; $this->cell_row_bottom_addition = $this->all_page_row_styles["style_border_bottom"]; $this->no_columns_printed = 0; foreach ($this->columns as $col) { $this->format_column($col); } $this->cell_row_top_addition = 0; $this->cell_row_bottom_addition = 0; $this->page_line_count++; $this->unapply_style_tags("ROW2", $this->mid_cell_row_styles); $this->unapply_style_tags("EACHLINEMID", $this->mid_row_page_styles); $this->unapply_style_tags("EACHHEADMID", $this->mid_cell_reportbody_styles); $nextliney = $this->document->GetY() + $this->max_line_height; $this->end_line(); } }
function each_line($val) { // PDF reportico_report::each_line($val); if (session_request_item("target_style", "TABLE") == "FORM") { $this->end_line(); // Throw new page if set to throw between rows $formpagethrow = $this->query->get_attribute("formBetweenRows"); if ($this->line_count > 1 && $formpagethrow == "newpage") { $this->finish_page(); $this->begin_page(); } // Throw new page if current position + number headers + line + headers > than bottom margin $ln = 0; $totheaderheight = 0; $prevheight = $this->calculated_line_height; $this->apply_style_tags($this->query->output_before_form_row_styles); $y = $this->document->GetY(); $this->set_position($this->abs_left_margin, $y); $this->draw_cell(400, $this->vsize, ""); // Blank cell to continue page breaking at this size $this->unapply_style_tags($this->query->output_before_form_row_styles); foreach ($this->query->groups as $val) { for ($i = 0; $i < count($val->headers); $i++) { $col =& $val->headers[$i]["GroupHeaderColumn"]; $this->format_group_header($col, false); $totheaderheight += $this->calculated_line_height; } } foreach ($this->query->display_order_set["column"] as $k => $w) { if ($w->attributes["column_display"] != "show") { continue; } $ct++; $this->format_group_header($w, false); $totheaderheight += $this->calculated_line_height; } $this->calculated_line_height = $totheaderheight; $y = $this->document->GetY(); $this->check_page_overflow(); $this->calculated_line_height = $prevheight; // Between form solid line or blank line if ($formpagethrow == "blankline") { $this->end_line(); $this->end_line(); } else { $this->end_line(); $this->apply_style_tags($this->query->output_after_form_row_styles); $y = $this->document->GetY(); $this->set_position($this->abs_left_margin, $y); $this->draw_cell($this->abs_right_margin - $this->abs_left_margin, $this->vsize, ""); // Blank cell to continue page breaking at this size $this->unapply_style_tags($this->query->output_after_form_row_styles); $this->end_line(); } return; } $y = $this->document->GetY(); $this->check_graphic_fit(); $this->yjump = 0; if ($this->body_display == "show" && get_reportico_session_param("target_show_detail")) { $this->row_styles = array(); $this->apply_style_tags($this->query->output_row_styles, false, false, "ROW"); $this->draw_mode = "CALCULATE"; $this->no_columns_printed = 0; $this->no_columns_to_print = 0; foreach ($this->columns as $col) { $this->format_column($col); } $this->unapply_style_tags($this->query->output_row_styles); $this->draw_mode = "DRAW"; $this->check_page_overflow(); //$this->set_position($this->abs_left_margin, false); //$this->draw_cell($this->abs_right_margin - $this->abs_left_margin, $this->calculated_line_height, "xx", 0, 0); //$this->disable_style_tag($this->query->output_header_styles, "border-width"); $this->apply_style_tags($this->query->output_row_styles, false, false, "ROW"); $this->no_columns_printed = 0; foreach ($this->columns as $col) { $this->format_column($col); } $this->page_line_count++; $this->unapply_style_tags($this->query->output_row_styles); $nextliney = $this->document->GetY() + $this->max_line_height; $this->end_line(); $this->set_position(false, $nextliney); } //if ( $this->yjump ) //$this->set_position(false, $y + $this->yjump); //if ( $y + $this->vsize > $this->abs_bottom_margin ) //{ //$this->finish_page(); //$this->begin_page(); //} }
function each_line($val) { reportico_report::each_line($val); // Excel requires group headers are printed as the first columns in the spreadsheet against // the detail. foreach ($this->query->groups as $name => $group) { if (count($group->headers) > 0) { foreach ($group->headers as $gphk => $col) { $qn = get_query_column($col["GroupHeaderColumn"]->query_name, $this->query->columns); $padstring = $qn->column_value; echo "\"" . $padstring . "\""; echo ","; } } } //foreach ( $this->columns as $col ) foreach ($this->query->display_order_set["column"] as $col) { $this->format_column($col); } echo "\n"; }
function each_line($val) { reportico_report::each_line($val); //if ( $this->line_ct > 3 ) return; // Set the values for the fields in the record $this->results[] = array("id" => $this->line_ct, "cell" => array()); $this->results[count($this->results) - 1]["cell"][] = "options"; // Excel requires group headers are printed as the first columns in the spreadsheet against // the detail. foreach ($this->query->groups as $name => $group) { if (count($group->headers) > 0) { foreach ($group->headers as $gphk => $col) { $qn = get_query_column($col->query_name, $this->query->columns); $coltitle = $col->derive_attribute("column_title", $col->query_name); $coltitle = str_replace("_", " ", $coltitle); $coltitle = ucwords(strtolower($coltitle)); $coltitle = sw_translate($coltitle); if ($col->query_name == $this->key_column) { $this->results[count($this->results) - 1]["id"][] = $qn->column_value; } $this->results[count($this->results) - 1]["cell"][] = $qn->column_value; if ($this->line_ct == 0) { $this->colmodel[] = array("name" => $col->query_name, "index" => $col->query_name, "editable" => derive_jquerygrid_col_params($this->report_name, $col->query_name, "editable", false), "edittype" => "text", "sorttype" => "text", "jsonmap" => $col->query_name, "width" => derive_jquerygrid_col_params($this->report_name, $col->query_name, "width", "80")); // Map colname to col $this->colmap[$col->query_name] = count($this->colmodel) - 1; if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "edittype", "")) { $this->colmodel[count($this->colmodel) - 1]["edittype"] = $v; } if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "sorttype", "")) { $this->colmodel[count($this->colmodel) - 1]["sorttype"] = $v; } if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "editoptions", "")) { $this->colmodel[count($this->colmodel) - 1]["editoptions"] = $v; } if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "filtertype", "")) { if ($v == "select") { $this->colmodel[count($this->colmodel) - 1]["stype"] = "select"; if (!$this->colmodel[count($this->colmodel) - 1]["editoptions"]) { $this->colmodel[count($this->colmodel) - 1]["editoptions"] = array(); $this->colfilters[$col->query_name] = array(); $this->colmodel[count($this->colmodel) - 1]["editoptions"]["value"] = ":All"; } } } $this->colnames[] = $coltitle; } if ($this->colmodel[$this->colmap[$col->query_name]]["stype"] == "select") { if (!array_key_exists($qn->column_value, $this->colfilters[$col->query_name])) { //$this->colmodel[$this->colmap[$col->query_name]]["editoptions"][$qn->column_value] = $qn->column_value; $this->colfilters[$col->query_name][$qn->column_value] = "1"; $this->colmodel[$this->colmap[$col->query_name]]["editoptions"]["value"] .= ";" . $qn->column_value . ":" . $qn->column_value; } } } } } foreach ($this->query->display_order_set["column"] as $col) { $qn = get_query_column($col->query_name, $this->columns); $coltitle = $col->derive_attribute("column_title", $col->query_name); $coltitle = str_replace("_", " ", $coltitle); $coltitle = ucwords(strtolower($coltitle)); $coltitle = sw_translate($coltitle); if ($col->query_name == $this->key_column) { $this->results[count($this->results) - 1]["id"] = $qn->column_value; } $disp = $col->derive_attribute("column_display", "show"); if ($disp == "hide") { continue; } if ($this->line_ct == 0) { $this->colmodel[] = array("name" => $col->query_name, "index" => $col->query_name, "editable" => derive_jquerygrid_col_params($this->report_name, $col->query_name, "editable", false), "edittype" => "text", "sorttype" => "int", "jsonmap" => $col->query_name, "width" => derive_jquerygrid_col_params($this->report_name, $col->query_name, "width", "80")); // Map colname to col $this->colmap[$col->query_name] = count($this->colmodel) - 1; if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "hidden", "")) { $this->colmodel[count($this->colmodel) - 1]["hidden"] = $v; } if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "edittype", "")) { $this->colmodel[count($this->colmodel) - 1]["edittype"] = $v; } if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "sorttype", "")) { $this->colmodel[count($this->colmodel) - 1]["sorttype"] = $v; } if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "filtertype", "")) { if ($v == "select") { $this->colmodel[count($this->colmodel) - 1]["stype"] = "select"; if (!$this->colmodel[count($this->colmodel) - 1]["editoptions"]) { $this->colmodel[count($this->colmodel) - 1]["editoptions"] = array(); $this->colfilters[$col->query_name] = array(); $this->colmodel[count($this->colmodel) - 1]["editoptions"]["value"] = ":All"; } } } if ($v = derive_jquerygrid_col_params($this->report_name, $col->query_name, "editoptions", "")) { $this->colmodel[count($this->colmodel) - 1]["editoptions"] = $v; } $this->colnames[] = $coltitle; } // Add value to filter options if type is select if ($this->colmodel[$this->colmap[$col->query_name]]["stype"] == "select") { if (!array_key_exists($qn->column_value, $this->colfilters[$col->query_name])) { //$this->colmodel[$this->colmap[$col->query_name]]["editoptions"][$qn->column_value] = $qn->column_value; $this->colfilters[$col->query_name][$qn->column_value] = "1"; $this->colmodel[$this->colmap[$col->query_name]]["editoptions"]["value"] .= ";" . $qn->column_value . ":" . $qn->column_value; } } $this->results[count($this->results) - 1]["cell"][] = $qn->column_value; } // $this->results[] = $cells; $this->line_ct++; }