$hulp1 = strlen($row['name']) > 2 ? str_replace('_', ' ', $row['name']) : '';
$hulp1 .= strlen($row['boekstuk']) > 2 ? ' ==> ' . str_replace('_', ' ', $row['boekstuk']) . ' ' : '';
$hulp2 = strlen($row['project']) > 2 ? $row['project'] : '';
$col = $pagingArr['m'] % 2 == 0 ? $col = $MOD_GSMOFFM['line_color'][2] : "";
if ($row['debet_id'] == $regelsArr['recid'][1][0]) {
$regelsArr['cum_rek'] += $row['debet_amount'];
$regelsArr['descr'] .= sprintf($LINETEMP[2], $col, sprintf($ICONTEMP[26], $row['id'], $row['booking_date']), $hulp1, $hulp2, Gsm_opmaak($row['debet_amount'], 8), '');
}
if ($row['tegen1_id'] == $regelsArr['recid'][1][0]) {
$hulp_amt = $row['tegen1_amount'] * $MOD_GSMOFFM['rek_type_sign'][$rekeningtypeArr[$row['debet_id']]] * $MOD_GSMOFFM['rek_type_sign'][$rekeningtypeArr[$row['tegen1_id']]] * -1;
$regelsArr['cum_rek'] += $hulp_amt;
$regelsArr['descr'] .= sprintf($LINETEMP[2], $col, sprintf($ICONTEMP[26], $row['id'], $row['booking_date']), $hulp1, $hulp2, Gsm_opmaak($hulp_amt, 8), '');
}
if ($row['tegen2_id'] == $regelsArr['recid'][1][0]) {
$hulp_amt = 0;
if ($row['tegen2_amount'] != 0) {
$hulp_amt = $row['tegen2_amount'] * $MOD_GSMOFFM['rek_type_sign'][$rekeningtypeArr[$row['debet_id']]] * $MOD_GSMOFFM['rek_type_sign'][$rekeningtypeArr[$row['tegen2_id']]] * -1;
$regelsArr['cum_rek'] += $hulp_amt;
$regelsArr['descr'] .= sprintf($LINETEMP[2], $col, sprintf($ICONTEMP[26], $row['id'], $row['booking_date']), $hulp1, $hulp2, Gsm_opmaak($hulp_amt, 8), '');
}
}
}
$parseViewArr = array('header' => $regelsArr['app'], 'message' => message($msg, $debug), 'return' => CH_RETURN, 'module' => $regelsArr['module'], 'page_id' => $page_id, 'section_id' => $section_id, 'bkid' => $regelsArr['select_rek_id'], 'bedragvan' => Gsm_opmaak($regelsArr['bedragvan'], 8), 'bedragtot' => Gsm_opmaak($regelsArr['bedragtot'], 8), 'vanaf' => $regelsArr['vanaf'], 'totenmet' => $regelsArr['totenmet'], 'rek' => '3', 'kopregels' => $regelsArr['head'], 'description' => $regelsArr['descr']);
$print .= $TEMPLATE[6];
foreach ($parseViewArr as $key => $value) {
$print = str_replace("{" . $key . "}", $value, $print);
}
$msg['bug'] = "";
}
}
}
// default list
$regelsArr['head'] .= $LINETEMP[1];
$regelsArr['head'] .= sprintf($LINETEMP[2], $MOD_GSMOFF['line_color'][3], strtoupper($MOD_GSMOFF['LAB_DATUM']), strtoupper($MOD_GSMOFF['LAB_REK']), strtoupper($MOD_GSMOFF['LAB_REF']), strtoupper($MOD_GSMOFF['LAB_DEBET']), strtoupper($MOD_GSMOFF['LAB_CREDIT']));
$regelsArr['descr'] .= $LINETEMP[1];
$results = $database->query($query);
$i = 0;
if ($results && $results->numRows() > 0) {
while ($row = $results->fetchRow()) {
if ($row['booking_date'] < $regelsArr['xyear']) {
$i++;
$col = $i % 2 == 0 ? $MOD_GSMOFF['line_color'][2] : '';
$regelsArr['descr'] .= sprintf($LINETEMP[3], $col, $row['id'], $row['booking_date'], $row['project'], $row['name'], '', '');
$regelsArr['descr'] .= sprintf($LINETEMP[21], $col, $rekeningArray[$row['debet_id']], Gsm_opmaak($row['debet_amount'], 8));
$regelsArr['descr'] .= sprintf($LINETEMP[22], $col, $MOD_GSMOFF['AAN'] . $rekeningArray[$row['tegen1_id']], Gsm_opmaak($row['tegen1_amount'], 8));
if ($row['tegen2_amount'] != 0) {
$regelsArr['descr'] .= sprintf($LINETEMP[22], $col, $MOD_GSMOFF['AAN'] . $rekeningArray[$row['tegen2_id']], Gsm_opmaak($row['tegen2_amount'], 8));
}
}
}
//$row = $results->fetchRow()
} else {
$regelsArr['descr'] .= $MOD_GSMOFF['nodata'];
}
break;
}
//$regelsArr[ 'mode' ]
/*
* display select elements
*/
switch ($regelsArr['mode']) {
case 5:
function func_rekening($Arr_in)
{
// processing
/*
* creating balans/ resultaat relkening or een detail overzicht
*
* $Arr_in['mode'] 1= balans
* $Arr_in['mode'] 2= resultaat
* $Arr_in['mode'] 3= details
* $Arr_in['vanaf'] vanaf
* $Arr_in['totenmet'] tot en met
*/
require_once $place_incl . 'pdf.inc';
global $database;
global $MOD_GSMOFF;
global $LINETEMP;
global $ICONTEMP;
global $place;
global $msg;
$returnvalue = "";
$pdf_text = '';
$pdf_data = array();
$subtotals = array();
$Arr_local = array('n' => 0, 'm' => 0, 'text_budget' => '', 'rekeningnummer' => '', 'cum_rek' => 0, 'cum_group' => 0, 'cum_srt' => 0, 'cum_activa' => 0, 'cum_resultaat' => 0, 'cum_rek_previous' => 0, 'rekening_type' => '');
/*
* initiatie pdf before starting the normal process
*/
$pdf = new PDF();
global $title;
global $owner;
$owner = $regelsArr['owner'];
$title = $regelsArr['project'];
$run = date("Ymd_His");
$pdf->AliasNbPages();
$pdf->AddPage();
$returnvalue .= $LINETEMP[20];
// kolombreedte instelling
// end initiate pdf file
//***************************
// Heading
switch ($Arr_in['mode']) {
case 1:
// balans
$returnvalue .= sprintf($LINETEMP[7], '', 3, 3, '<strong>' . $Arr_in['document'] . '</strong>' . ' ' . '<strong>' . $Arr_in['company'] . '</strong>', 'Datum : ' . $Arr_in['totenmet']);
$returnvalue .= sprintf($LINETEMP[11], $MOD_GSMOFF['line_color'][4], '', $MOD_GSMOFF['SUR_REK'], $MOD_GSMOFF['SUR_OMS'], '', '', $MOD_GSMOFF['SUR_BEDRAG']);
$title .= sprintf(" %s %s, datum: %s", $Arr_in['document'], $Arr_in['company'], $Arr_in['totenmet']);
$pdf->ChapterTitle(1, $title);
$pdf->SetFont('Arial', '', 8);
$pdf_text .= CH_CR . $title . CH_CR;
$pdf_header = array($MOD_GSMOFF['SUR_REK'], $MOD_GSMOFF['SUR_OMS'], '', '', '', $MOD_GSMOFF['SUR_BEDRAG']);
break;
case 2:
// resultaat
$Arr_local['text_budget'] = $Arr_in['budget_exist'] ? "Budget" : "";
$returnvalue .= sprintf($LINETEMP[7], '', 3, 3, '<strong>' . $Arr_in['document'] . '</strong>' . ' ' . '<strong>' . $Arr_in['company'] . '</strong>', $MOD_GSMOFF['SUR_PER'] . $Arr_in['vanaf'] . ' - ' . $Arr_in['totenmet']);
$returnvalue .= sprintf($LINETEMP[11], $MOD_GSMOFF['line_color'][4], '', $MOD_GSMOFF['SUR_REK'], $MOD_GSMOFF['SUR_OMS'], $Arr_local['text_budget'], '', $MOD_GSMOFF['SUR_BEDRAG']);
$title = sprintf("%s %s, periode: %s - %s", $Arr_in['document'], $Arr_in['company'], $Arr_in['vanaf'], $Arr_in['totenmet']);
$pdf->ChapterTitle(1, $title);
$pdf->SetFont('Arial', '', 8);
$pdf_text .= CH_CR . $title . CH_CR;
$pdf_header = array($MOD_GSMOFF['SUR_REK'], $MOD_GSMOFF['SUR_OMS'], $Arr_local['text_budget'], '', '', $MOD_GSMOFF['SUR_BEDRAG']);
break;
case 3:
// details
$returnvalue .= sprintf($LINETEMP[7], '', 3, 3, '<strong>' . $Arr_in['document'] . '</strong>' . ' ' . '<strong>' . $Arr_in['company'] . '</strong>', $MOD_GSMOFF['SUR_PER'] . $Arr_in['vanaf'] . ' - ' . $Arr_in['totenmet']);
$returnvalue .= sprintf($LINETEMP[11], $MOD_GSMOFF['line_color'][4], ' ', $MOD_GSMOFF['SUR_REK'], $MOD_GSMOFF['SUR_OMS'], '', '', $MOD_GSMOFF['SUR_BEDRAG']);
$title = sprintf("%s %s, periode: %s - %s", $Arr_in['document'], $Arr_in['company'], $Arr_in['vanaf'], $Arr_in['totenmet']);
$pdf->ChapterTitle(1, $title);
$pdf->SetFont('Arial', '', 8);
$pdf_text .= CH_CR . $title . CH_CR;
$pdf_header = array($MOD_GSMOFF['SUR_REK'], $MOD_GSMOFF['SUR_OMS'], '', '', '', $MOD_GSMOFF['SUR_BEDRAG']);
break;
default:
// default list
break;
}
// end of heading
//***************************
// preload rekening details
$rektypeArr = func_table_preload($Arr_in['table_rek'], 4);
// preload data
//$row = $results->fetchRow()
// start processing
// loop through rekening nummers
// find associated booking records
// level1 on balans en resultaten rekening
// level2 op 1e positie van rekening nummer
// level3 op rekening nummer
//***************************
$Arr_level_L1 = array('vorig' => 0, 'count' => 0);
// for levelbreak on type
$Arr_level_L2 = array('vorig' => 0, 'count' => 0);
// for levelbreak on rekening groep
$Arr_level_L3 = array('vorig' => 0, 'count' => 0);
// for levelbreak on rekening nummer
$query = "SELECT * FROM `" . $Arr_in['table_rek'] . "` ORDER BY `rekening_type`, `rekeningnummer`";
$r_results = $database->query($query);
if ($r_results && $r_results->numRows() > 0) {
// there are records
while ($r_row = $r_results->fetchRow()) {
// loop through the records
// alleen de volgende rekening nummers doen mee
if (in_array($r_row['rekening_type'], $Arr_in['show_type'])) {
// rekening nummer is to be processed the type matches
if ($Arr_level_L2['vorig'] != substr($r_row['rekeningnummer'], 0, 1) || $Arr_level_L1['vorig'] != $r_row['rekening_type']) {
// type of group chnage
// afsluiten L2 vorige group afsluiten
if ($Arr_level_L2['count'] != 0) {
// alleen als er records geweest zijn in deze groep
$Arr_local['cum_srt'] += $Arr_local['cum_group'];
// bij type totaal voegen
if ($Arr_in['result']) {
// output onder bepaalde conditie
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '', '<b>' . $MOD_GSMOFF['grootboek'][$Arr_level_L2['vorig']] . '</b>', '', '', Gsm_opmaak($Arr_local['cum_group'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['grootboek'][$Arr_level_L2['vorig']], '', '', '', Gsm_opmaak($Arr_local['cum_group'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', '', '', '', '', '');
$pdf_data[] = explode(';', trim($pdf_line));
}
// resetten cumul values
$Arr_local['cum_group'] = 0;
// groep totaal op nul
$Arr_local['cum_rek'] = 0;
// een onderliggende rekening nummer totaal op nul zetten
if (!$Arr_in['details']) {
// blanco regel onder bepaalde conditie
// blanco regel volgt
$returnvalue .= sprintf($LINETEMP[11], '', ' ', '', '', '', '', '');
$Arr_local['m'] = 0;
// reset kleur indicatie
}
}
if ($Arr_level_L1['vorig'] != $r_row['rekening_type']) {
// moet er rekening type totaal worden gemaakt
// afsluiten L1
$subtotals[$Arr_level_L1['vorig']] = $Arr_local['cum_srt'];
// totaal van het type vasthouden
if ($Arr_level_L1['count'] != 0) {
// acties nodig // zijn er records geweest
if ($Arr_in['result']) {
// output onder bepaalde conditie
if ($Arr_level_L1['vorig'] == 2) {
// type 2 processing
$Arr_local['cum_resultaat'] = $subtotals[1] - $subtotals[2];
// bereken resultaat
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '', '<b>' . $MOD_GSMOFF['SUR_RES'] . '</b>', '', '', Gsm_opmaak($Arr_local['cum_resultaat'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_RES'], '', '', '', Gsm_opmaak($Arr_local['cum_resultaat'], 1));
$pdf_data[] = explode(';', trim($pdf_line));
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '<b>' . $MOD_GSMOFF['SUR_TOT'] . '</b>', '<strong>' . $MOD_GSMOFF['rek_type'][$Arr_local['rekening_type']] . '</strong>', '', '', Gsm_opmaak($Arr_local['cum_activa'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_TOT'] . ' ' . $MOD_GSMOFF['rek_type'][$Arr_local['rekening_type']], '', '', '', Gsm_opmaak($subtotals[1], 2));
$pdf_data[] = explode(';', trim($pdf_line));
} elseif ($Arr_level_L1['vorig'] == 5) {
// type 5 processing
$Arr_local['cum_resultaat'] = $subtotals[5] - $subtotals[4];
// bereken resultaat
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '<b>' . $MOD_GSMOFF['SUR_TOT'] . '</b>', '<strong>' . $MOD_GSMOFF['rek_type'][$Arr_local['rekening_type']] . '</strong>', '', '', Gsm_opmaak($Arr_local['cum_srt'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_TOT'] . ' ' . $MOD_GSMOFF['rek_type'][$Arr_local['rekening_type']], '', '', '', Gsm_opmaak($subtotals[4], 2));
$pdf_data[] = explode(';', trim($pdf_line));
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '', '<b>' . $MOD_GSMOFF['SUR_RES'] . '</b>', '', '', Gsm_opmaak($Arr_local['cum_resultaat'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_RES'], '', '', '', Gsm_opmaak($Arr_local['cum_resultaat'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
} else {
// niet 2 of 5 2 = einde balans 5 = einde resultaat overzicht
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '<b>' . $MOD_GSMOFF['SUR_TOT'] . '</b>', '<strong>' . $MOD_GSMOFF['rek_type'][$Arr_level_L1['vorig']] . '</strong>', '', '', Gsm_opmaak($subtotals[$Arr_level_L1['vorig']], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_TOT'] . ' ' . $MOD_GSMOFF['rek_type'][$Arr_level_L1['vorig']], '', '', '', Gsm_opmaak($subtotals[$Arr_level_L1['vorig']], 2));
$pdf_data[] = explode(';', trim($pdf_line));
// blanco regel volgt
$returnvalue .= sprintf($LINETEMP[11], '', ' ', '', '', '', '', '');
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', '', '', '', '', '');
$pdf_data[] = explode(';', trim($pdf_line));
$Arr_local['m'] = 0;
// reset kleur indicatie
}
}
$Arr_local['cum_srt'] = 0;
// soort totaal op nul voor de volgende
}
//openen L1
$Arr_level_L1['vorig'] = $r_row['rekening_type'];
// rekening type
$Arr_level_L1['count'] = 0;
// totaal voor level break uitzetten
}
//openen L2
$Arr_level_L2['vorig'] = substr($r_row['rekeningnummer'], 0, 1);
// rekening groep
$Arr_level_L2['count'] = 0;
// totaal voor level break uitzetten
}
// process details L3
// selection depending on balans rekening
$Arr_level_L3['vorig'] = isset($row['debet_id']) ? $row['debet_id'] : ' ';
// waarde key volgende cycle
$Arr_level_L3['count'] = 0;
// totaal voor level break uitzetten
// pick up openings balans van rekening rek
$Arr_local['cum_rek'] = 0;
if (abs($r_row['balans']) > 0.001 && $Arr_in['totenmet'] >= $r_row['balans_date']) {
$Arr_local['cum_rek'] = $r_row['balans'];
$Arr_level_L3['count']++;
// om een openings balans te krijgen als er geen verdere boekingen zijn
//dit kan er later uit
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][0], '', '', $r_row['balans_date'] . ' >> Openings Balans', '--', Gsm_opmaak($Arr_local['cum_rek'], 1), "");
// tot hier
}
$msql_search = $r_row['rekening_type'] == 1 || $r_row['rekening_type'] == 2 ? "`booking_date` <= '" . $Arr_in['totenmet'] . "' " : ($msql_search = "`booking_date` >= '" . $Arr_in['vanaf'] . "' AND `booking_date` <= '" . $Arr_in['totenmet'] . "' ");
$msql_search .= " AND ( `debet_id`= '" . $r_row['id'] . "' OR `tegen1_id`= '" . $r_row['id'] . "' OR `tegen2_id`= '" . $r_row['id'] . "' )";
$query = "SELECT * FROM `" . $Arr_in['table'] . "` WHERE " . $msql_search . " ORDER BY `booking_date`, `project`";
$results = $database->query($query);
if ($results && $results->numRows() > 0) {
while ($row = $results->fetchRow()) {
$hulp = sprintf('%s - %s%s', $row['booking_date'], strlen($row['name']) > 2 ? $row['name'] . ' - ' : '', strlen($row['project']) > 2 ? $row['project'] : '');
$col = $Arr_local['m'] % 2 == 0 ? $MOD_GSMOFF['line_color'][2] : "";
// data for display detail
if ($row['debet_id'] == $r_row['id']) {
$hulp_amt = $row['debet_amount'];
$Arr_local['cum_rek'] += $hulp_amt;
// display detailed lines
if ($row['booking_date'] < $Arr_in['vanaf']) {
$Arr_local['cum_rek_previous'] = $Arr_local['cum_rek'];
}
// voor een eventuele 0penings balans
if ($hulp_amt != 0 && ($Arr_in['details'] || $Arr_in['search'] == $r_row['rekeningnummer'])) {
if ($row['booking_date'] >= $Arr_in['vanaf'] && $row['booking_date'] <= $Arr_in['totenmet']) {
if (abs($Arr_local['cum_rek_previous']) > 0.001) {
// er is nog een openings balans af te drukken
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][0], '', '', ' - Openings Balans', '--', Gsm_opmaak($Arr_local['cum_rek_previous'], 1), "");
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', ' - Openings Balans', '', '--', Gsm_opmaak($Arr_local['cum_rek_previous'], 2), "");
$pdf_data[] = explode(';', trim($pdf_line));
$Arr_local['m'] = 0;
// reset kleur
$col = $Arr_local['m'] % 2 == 0 ? $MOD_GSMOFF['line_color'][2] : "";
$Arr_local['cum_rek_previous'] = 0;
//vergeet openingsbalans
}
// detailed line
$returnvalue .= sprintf($LINETEMP[12], $col, '<small>' . $row['id'] . '</small>', '', $hulp, Gsm_opmaak($hulp_amt, 1), Gsm_opmaak($Arr_local['cum_rek'], 1), '');
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $hulp, '', Gsm_opmaak($hulp_amt, 2), Gsm_opmaak($Arr_local['cum_rek'], 2), '');
$pdf_data[] = explode(';', trim($pdf_line));
}
// ($row['booking_date']>= $Arr_in['vanaf'] & $row['booking_date']<= $Arr_in['totenmet'])
}
//($hulp_amt <> 0 && ($Arr_in['details'] || $Arr_in['search'] == $r_row['rekeningnummer']))
}
if ($row['tegen1_id'] == $r_row['id']) {
$hulp_amt = $row['tegen1_amount'] * $MOD_GSMOFF['rek_type_sign'][$rektypeArr[$row['debet_id']]] * $MOD_GSMOFF['rek_type_sign'][$rektypeArr[$row['tegen1_id']]] * -1;
$Arr_local['cum_rek'] += $hulp_amt;
// display detailed lines
if ($row['booking_date'] < $Arr_in['vanaf']) {
$Arr_local['cum_rek_previous'] = $Arr_local['cum_rek'];
}
// voor een eventuele 0penings balans
if ($hulp_amt != 0 && ($Arr_in['details'] || $Arr_in['search'] == $r_row['rekeningnummer'])) {
if ($row['booking_date'] >= $Arr_in['vanaf'] && $row['booking_date'] <= $Arr_in['totenmet']) {
if (abs($Arr_local['cum_rek_previous']) > 0.001) {
// er is nog een openings balans af te drukken
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][0], '', '', $Arr_in['vanaf'] . ' - Openings Balans', '--', Gsm_opmaak($Arr_local['cum_rek_previous'], 1), "");
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $Arr_in['vanaf'] . ' - Openings Balans', '', '--', Gsm_opmaak($Arr_local['cum_rek_previous'], 2), "");
$pdf_data[] = explode(';', trim($pdf_line));
$Arr_local['m'] = 0;
// reset kleur
$col = $Arr_local['m'] % 2 == 0 ? $MOD_GSMOFF['line_color'][2] : "";
$Arr_local['cum_rek_previous'] = 0;
//vergeet openingsbalans
}
// detailed line
$returnvalue .= sprintf($LINETEMP[12], $col, '<small>' . $row['id'] . '</small>', '', $hulp, Gsm_opmaak($hulp_amt, 1), Gsm_opmaak($Arr_local['cum_rek'], 1), '');
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $hulp, '', Gsm_opmaak($hulp_amt, 2), Gsm_opmaak($Arr_local['cum_rek'], 2), '');
$pdf_data[] = explode(';', trim($pdf_line));
}
// ($row['booking_date']>= $Arr_in['vanaf'] & $row['booking_date']<= $Arr_in['totenmet'])
}
//($hulp_amt <> 0 && ($Arr_in['details'] || $Arr_in['search'] == $r_row['rekeningnummer']))
}
if ($row['tegen2_id'] == $r_row['id']) {
$hulp_amt = $row['tegen2_amount'] * $MOD_GSMOFF['rek_type_sign'][$rektypeArr[$row['debet_id']]] * $MOD_GSMOFF['rek_type_sign'][$rektypeArr[$row['tegen2_id']]] * -1;
$Arr_local['cum_rek'] += $hulp_amt;
// display detailed lines
if ($row['booking_date'] < $Arr_in['vanaf']) {
$Arr_local['cum_rek_previous'] = $Arr_local['cum_rek'];
}
// voor een eventuele 0penings balans
if ($hulp_amt != 0 && ($Arr_in['details'] || $Arr_in['search'] == $r_row['rekeningnummer'])) {
if ($row['booking_date'] >= $Arr_in['vanaf'] && $row['booking_date'] <= $Arr_in['totenmet']) {
if (abs($Arr_local['cum_rek_previous']) > 0.001) {
// er is nog een openings balans af te drukken
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][0], '', '', $Arr_in['vanaf'] . ' - Openings Balans', '--', Gsm_opmaak($Arr_local['cum_rek_previous'], 1), "");
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', '', $r_row['balans_date'] . ' - Openings Balans', '--', Gsm_opmaak($Arr_local['cum_rek_previous'], 2), "");
$pdf_data[] = explode(';', trim($pdf_line));
$Arr_local['m'] = 0;
// reset kleur
$col = $Arr_local['m'] % 2 == 0 ? $MOD_GSMOFF['line_color'][2] : "";
$Arr_local['cum_rek_previous'] = 0;
//vergeet openingsbalans
}
// detailed line
$returnvalue .= sprintf($LINETEMP[12], $col, '<small>' . $row['id'] . '</small>', '', $hulp, Gsm_opmaak($hulp_amt, 1), Gsm_opmaak($Arr_local['cum_rek'], 1), '');
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $hulp, '', Gsm_opmaak($hulp_amt, 2), Gsm_opmaak($Arr_local['cum_rek'], 2), '');
$pdf_data[] = explode(';', trim($pdf_line));
}
// ($row['booking_date']>= $Arr_in['vanaf'] & $row['booking_date']<= $Arr_in['totenmet'])
}
//($hulp_amt <> 0 && ($Arr_in['details'] || $Arr_in['search'] == $r_row['rekeningnummer']))
}
// display line
// set details for totals and levelbreak
$Arr_local['m']++;
if ($row['booking_date'] >= $Arr_in['vanaf'] && $row['booking_date'] <= $Arr_in['totenmet']) {
$Arr_level_L3['count']++;
}
}
// $row = $results->fetchRow()
}
//($results && $results->numRows() > 0)
// totaal
if ($Arr_level_L3['count'] != 0 || abs($Arr_local['cum_rek_previous']) > 0.001) {
if (abs($Arr_local['cum_rek_previous']) > 0.001) {
// er is nog een openings balans af te drukken
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][0], '', '', 'Openings Balans', '--', Gsm_opmaak($Arr_local['cum_rek_previous'], 1), "");
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', 'Openings Balans', '', '--', Gsm_opmaak($Arr_local['cum_rek_previous'], 2), "");
$pdf_data[] = explode(';', trim($pdf_line));
$Arr_local['m'] = 0;
// reset kleur
$col = $Arr_local['m'] % 2 == 0 ? $MOD_GSMOFF['line_color'][2] : "";
$Arr_local['cum_rek_previous'] = 0;
//vergeet openingsbalans
}
if ($Arr_in['budget_exist'] && $r_row['budget_a'] > 0) {
$help_b1 = Gsm_opmaak($r_row['budget_a'], 3);
$help_b2 = $Arr_local['cum_rek'] == 0 ? "" : Gsm_opmaak(100 * $Arr_local['cum_rek'] / $r_row['budget_a'], 9);
} else {
$help_b1 = "";
$help_b2 = "";
}
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][2], '', '<b>' . $r_row['rekeningnummer'] . '</b>', '<b>' . $r_row['name'] . '</b>', $help_b1, $help_b2, Gsm_opmaak($Arr_local['cum_rek'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", $r_row['rekeningnummer'], $r_row['name'], $help_b1, $help_b2, '', Gsm_opmaak($Arr_local['cum_rek'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
// blanco regel volgt
if ($Arr_in['details']) {
$returnvalue .= sprintf($LINETEMP[11], '', ' ', '', '', '', '', '');
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', '', '', '', '', '');
$pdf_data[] = explode(';', trim($pdf_line));
$Arr_local['m'] = 0;
}
$Arr_local['cum_group'] += $Arr_local['cum_rek'];
$Arr_local['cum_rek'] = 0;
$Arr_level_L3['count'] = 0;
$Arr_level_L2['count']++;
$Arr_level_L1['count']++;
}
//($Arr_level_L3['count'] != 0)
}
// (in_array($r_row['rekening_type'], $Arr_in['show_type'] ))
}
//($r_row = $r_results->fetchRow())
// afsluiten L2
if ($Arr_level_L2['count'] != 0) {
// acties nodig
$Arr_local['cum_group'] += $Arr_local['cum_rek'];
$Arr_local['cum_srt'] += $Arr_local['cum_group'];
if ($Arr_in['result']) {
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '..', '', '<b>' . $MOD_GSMOFF['grootboek'][$Arr_level_L2['vorig']] . '</b>', '', '', Gsm_opmaak($Arr_local['cum_group'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '..', $MOD_GSMOFF['grootboek'][$Arr_level_L2['vorig']], '', '', '', Gsm_opmaak($Arr_local['cum_group'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', '', '', '', '', '');
$pdf_data[] = explode(';', trim($pdf_line));
}
// resetten cumul values
$Arr_local['cum_group'] = 0;
$Arr_local['cum_rek'] = 0;
if (!$Arr_in['details']) {
// blanco regel volgt
$returnvalue .= sprintf($LINETEMP[11], '', ' ', '', '', '', '', '');
$Arr_local['m'] = 0;
}
}
// afsluiten L1
if ($Arr_level_L1['count'] != 0) {
// acties nodig
if ($Arr_in['result']) {
if ($Arr_level_L1['vorig'] == 2) {
$subtotals[2] = $Arr_local['cum_srt'];
$Arr_local['cum_resultaat'] = $subtotals[1] - $subtotals[2];
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '', '<b>' . $MOD_GSMOFF['SUR_RES'] . '</b>', '', '', Gsm_opmaak($Arr_local['cum_resultaat'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_RES'], '', '', '', Gsm_opmaak($Arr_local['cum_resultaat'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '<b>' . $MOD_GSMOFF['SUR_TOT'] . '</b>', '<strong>' . $MOD_GSMOFF['rek_type'][1] . '</strong>', '', '', Gsm_opmaak($subtotals[1], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_TOT'] . ' ' . $MOD_GSMOFF['rek_type'][1], '', '', '', Gsm_opmaak($subtotals[1], 2));
$pdf_data[] = explode(';', trim($pdf_line));
} elseif ($Arr_level_L1['vorig'] == 5) {
$subtotals[5] = $Arr_local['cum_srt'];
$Arr_local['cum_resultaat'] = $subtotals[5] - $subtotals[4];
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '<b>' . $MOD_GSMOFF['SUR_TOT'] . '</b>', '<strong>' . $MOD_GSMOFF['rek_type'][5] . '</strong>', '', '', Gsm_opmaak($Arr_local['cum_srt'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_TOT'] . ' ' . $MOD_GSMOFF['rek_type'][4], '', '', '', Gsm_opmaak($subtotals[4], 2));
$pdf_data[] = explode(';', trim($pdf_line));
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '', '<b>' . $MOD_GSMOFF['SUR_RES'] . '</b>', '', '', Gsm_opmaak($Arr_local['cum_resultaat'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_RES'], '', '', '', Gsm_opmaak($Arr_local['cum_resultaat'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
} else {
$returnvalue .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], '', '<b>' . $MOD_GSMOFF['SUR_TOT'] . '</b>', '<strong>' . $MOD_GSMOFF['rek_type'][$Arr_local['rekening_type']] . '</strong>', '1', '', Gsm_opmaak($subtotals[$Arr_level_L1['vorig']], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_TOT'] . ' ' . $MOD_GSMOFF['rek_type'][$Arr_local['rekening_type']], '', '', '', Gsm_opmaak($subtotals[$Arr_level_L1['vorig']], 2));
$pdf_data[] = explode(';', trim($pdf_line));
}
}
if (!$Arr_in['details']) {
// blanco regel volgt
$returnvalue .= sprintf($LINETEMP[11], '', ' ', '', '', '', '', '');
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', '', '', '', '', '');
$pdf_data[] = explode(';', trim($pdf_line));
$Arr_local['m'] = 0;
}
}
} else {
$returnvalue .= $MOD_GSMOFF['SUR_NDATA'];
$pdf_text .= $MOD_GSMOFF['SUR_NDATA'] . CH_CR;
}
if (isset($Arr_in['filename_pdf'])) {
/*
* the output to the pdf
*/
$pdf_cols = array(12, 85, 15, 25, 25, 25);
$pdf_text .= CH_CR . $Arr_in['company'];
$pdf_text .= CH_CR . CH_CR . $regelsArr['filename_pdf'] . CH_CR;
$pdf_text .= "Document created on : " . str_replace("_", " ", $run) . CH_CR;
if ($debug) {
$pdf_text .= CH_CR . "Version : " . $regelsArr['module'] . $regelsArr['versie'] . CH_CR;
}
if (strlen($regelsArr['search']) > 1) {
$pdf_text .= CH_CR . "Selection : " . $regelsArr['search'];
}
$pdf->DataTable($pdf_header, $pdf_data, $pdf_cols);
$pdf->ChapterBody($pdf_text);
$pdf->Output($Arr_in['dir_to'] . '/' . $Arr_in['filename_pdf'], 'F');
$msg['inf'] .= ' report created</br>';
}
//isset( $Arr_local[ 'filename_pdf' ] )
return $returnvalue;
}
$regelsArr['descr'] .= sprintf($LINETEMP[23], $MOD_GSMOFF['line_color'][3], '', '<b>' . $MOD_GSMOFF['SUR_TOT'] . '</b>', '<strong>' . $MOD_GSMOFF['rek_type'][$regelsArr['rekening_type']] . '</strong>', '', '', Gsm_opmaak($regelsArr['cum_srt'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_TOT'] . ' ' . $MOD_GSMOFF['rek_type'][$regelsArr['rekening_type']], '', '', '', Gsm_opmaak($regelsArr['cum_srt'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
$regelsArr['descr'] .= sprintf($LINETEMP[23], $MOD_GSMOFF['line_color'][3], '', '', '<b>' . $MOD_GSMOFF['SUR_RES'] . '</b>', '', '', Gsm_opmaak($regelsArr['cum_resultaat'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_RES'], '', '', '', Gsm_opmaak($regelsArr['cum_resultaat'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
}
//$regelsArr[ 'result' ]
} else {
// regel Totaal Tussenrek
if (!isset($MOD_GSMOFF['rek_type'][$regelsArr['rekening_type']])) {
$MOD_GSMOFF['rek_type'][$regelsArr['rekening_type']] = '';
}
//!isset( $MOD_GSMOFF[ 'rek_type' ][ $regelsArr[ 'rekening_type' ] ] )
$regelsArr['descr'] .= sprintf($LINETEMP[23], $MOD_GSMOFF['line_color'][3], '', '<b>' . $MOD_GSMOFF['SUR_TOT'] . '</b>', '<strong>' . $MOD_GSMOFF['rek_type'][$regelsArr['rekening_type']] . '</strong>', '', '', Gsm_opmaak($regelsArr['cum_srt'], 1));
$pdf_line = sprintf("%s;%s;%s;%s;%s;%s", '', $MOD_GSMOFF['SUR_TOT'] . ' ' . $MOD_GSMOFF['rek_type'][$regelsArr['rekening_type']], '', '', '', Gsm_opmaak($regelsArr['cum_srt'], 2));
$pdf_data[] = explode(';', trim($pdf_line));
}
} else {
$regelsArr['descr'] .= $MOD_GSMOFF['SUR_NDATA'];
$pdf_text .= $MOD_GSMOFF['SUR_NDATA'] . "n";
}
break;
}
//$regelsArr[ 'mode' ]
if (isset($regelsArr['filename_pdf'])) {
/*
* the output to the pdf
*/
$pdf_cols = array(12, 85, 15, 25, 25, 25);
$pdf->DataTable($pdf_header, $pdf_data, $pdf_cols);
