/* * Debug data */ if ($debug) { Gsm_debug($settingArr, __LINE__); Gsm_debug($regelsArr, __LINE__); Gsm_debug($place, __LINE__); } /* * Table exists */ func_table_preload($regelsArr['table'], 1); //check precense $settingArr = array_merge($settingArr, func_table_preload($regelsArr['file'], 9, $page_id)); // Pick up settings $fieldArr = func_table_preload($regelsArr['table'], 8); // get fields // all fields collected now remove the standard fields except name unset($fieldArr['id']); unset($fieldArr['zoek']); unset($fieldArr['updated']); /* * processing settings array */ if (!isset($settingArr['mode'])) { $settingArr['mode'] = ""; } if (CH_LOC == "front") { if (strstr($settingArr['mode'], "lis")) { $regelsArr['pdf_ok'] = true; }
break; } return $returnvalue; } /* * Checking and preloading */ func_table_preload($regelsArr['table'], 1); //check precense $rekeningArray[0] = ' -- '; $rekeningArray = func_table_preload($regelsArr['table_rek'], 2, $rekeningArray); // preload data $projectArray[' '] = ''; $projectArray = func_table_preload($regelsArr['table_proj'], 3, $projectArray); // preload data $settingArr = array_merge($settingArr, func_table_preload($regelsArr['file'], 9, $page_id)); // Pick up settings /* * debug */ if ($debug) { Gsm_debug($settingArr, __LINE__); Gsm_debug($regelsArr, __LINE__); Gsm_debug($_POST, __LINE__); Gsm_debug($_GET, __LINE__); Gsm_debug($place, __LINE__); Gsm_debug($rekeningArray, __LINE__); Gsm_debug($projectArray, __LINE__); } //$debug /*
function func_rek_update($Arr_in, $year) { /* * Update rekening tabel with one year balans data from bookings * als resultaat 0 true terug gegeven anders false */ global $database; global $MOD_GSMOFF; $oke = false; $subtotals = array(); $Arr_local = array('cum_rek' => 0, 'cum_group1' => 0, 'cum_group2' => 0); $rektypeArr = func_table_preload($Arr_in['table_rek'], 4); // preload data $query = "SELECT * FROM `" . $Arr_in['table_rek'] . "` WHERE `rekening_type` = '1' OR `rekening_type` = '2' ORDER BY `rekening_type`, `rekeningnummer`"; $r_results = $database->query($query); if ($r_results && $r_results->numRows() > 0) { while ($r_row = $r_results->fetchRow()) { $Arr_local['cum_rek'] = $r_row['balans']; $query = "SELECT * FROM `" . $Arr_in['table'] . "` WHERE `booking_date` <= '" . $year . "-12-31' AND ( `debet_id`= '" . $r_row['id'] . "' OR `tegen1_id`= '" . $r_row['id'] . "' OR `tegen2_id`= '" . $r_row['id'] . "' ) ORDER BY `booking_date`, `project`"; $b_results = $database->query($query); if ($b_results && $b_results->numRows() > 0) { while ($b_row = $b_results->fetchRow()) { if ($b_row['debet_id'] == $r_row['id']) { $Arr_local['cum_rek'] += $b_row['debet_amount']; } if ($b_row['tegen1_id'] == $r_row['id']) { $Arr_local['cum_rek'] += $b_row['tegen1_amount'] * $MOD_GSMOFF['rek_type_sign'][$rektypeArr[$b_row['debet_id']]] * $MOD_GSMOFF['rek_type_sign'][$rektypeArr[$b_row['tegen1_id']]] * -1; } if ($b_row['tegen2_id'] == $r_row['id']) { $Arr_local['cum_rek'] += $b_row['tegen2_amount'] * $MOD_GSMOFF['rek_type_sign'][$rektypeArr[$b_row['debet_id']]] * $MOD_GSMOFF['rek_type_sign'][$rektypeArr[$b_row['tegen2_id']]] * -1; } } } // opslaan $year_next = $year + 1; $hulpArr = array('balans_date' => $year_next . '-01-01', 'balans' => $Arr_local['cum_rek']); $query = "UPDATE `" . $Arr_in['table_rek'] . "` SET " . Gsm_parse(2, $hulpArr) . " WHERE `id`='" . $r_row['id'] . "'"; $u_results = $database->query($query); if ($r_row['rekening_type'] == 1) { $Arr_local['cum_group1'] += $Arr_local['cum_rek']; } if ($r_row['rekening_type'] == 2) { $Arr_local['cum_group2'] += $Arr_local['cum_rek']; } $Arr_local['cum_rek'] = 0; } // test resultaat if (abs($Arr_local['cum_group1'] - $Arr_local['cum_group2']) < 0.001) { $oke = true; } } else { $returnvalue .= $MOD_GSMOFF['SUR_NDATA']; } return $oke; }
return $returnvalue; } /* * Checking and preloading */ func_table_preload($regelsArr['table'], 1); //check precense $rekeningArray[0] = ' -- '; $rekeningArray = func_table_preload($regelsArr['table_rek'], 2, $rekeningArray); // preload data $projectArray[' '] = ''; $projectArray = func_table_preload($regelsArr['table_proj'], 3, $projectArray); // preload data $settingArr = array_merge($settingArr, func_table_preload($regelsArr['file'], 9, $page_id)); // Pick up settings $bookingArray = func_table_preload($regelsArr['table'], 6, $regelsArr['xyear']); /* * Booking types */ if (isset($_GET['setting'])) { $regelsArr['vsetting'] = strtolower($_GET['setting']); } if (isset($_POST['setting'])) { $regelsArr['vsetting'] = strtolower($_POST['setting']); } if (strlen($regelsArr['vsetting']) < 2) { $regelsArr['vsetting'] = ''; } else { $regelsArr['detail'] = true; $regelsArr['setting'] = true; }