/*
* 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;
}
