//print model
$regelsArr['filename_pdf'] = strtolower($regelsArr['project'] . $regelsArr['today_pf']) . '.pdf';
$regelsArr['mode'] = 9;
break;
case $MOD_GSMOFF['tbl_icon'][13]:
//budget
$query = "SELECT * FROM `" . $regelsArr['table'] . "`WHERE `rekening_type`='4' OR `rekening_type`='5' ORDER BY `" . $regelsArr['volgorde'] . "`";
$regelsArr['mode'] = 5;
break;
case $MOD_GSMOFF['tbl_icon'][16]:
//budget ok
$query = "SELECT * FROM `" . $regelsArr['table'] . "`WHERE `rekening_type`='4' OR `rekening_type`='5' ORDER BY `" . $regelsArr['volgorde'] . "`";
$results = $database->query($query);
while ($row = $results->fetchRow()) {
$hulpArr = array('budget_a' => $row['budget_b']);
$queryc = "UPDATE `" . $regelsArr['table'] . "` SET " . Gsm_parse(2, $hulpArr) . " WHERE `id`= '" . $row['id'] . "'";
if ($debug) {
$msg['bug'] .= '<br/>id ' . __LINE__ . " " . $query . '<br/>';
}
$c_results = $database->query($queryc);
}
$query = "SELECT * FROM `" . $regelsArr['table'] . "`WHERE `rekening_type`='4' OR `rekening_type`='5' ORDER BY `" . $regelsArr['volgorde'] . "`";
$regelsArr['mode'] = 5;
break;
default:
$regelsArr['mode'] = 9;
break;
}
} elseif (isset($_GET['command'])) {
switch ($_GET['command']) {
case 'view':
$hulp = explode("|", $settingArr['opzoek']);
foreach ($hulp as $key => $value) {
if (isset($hulpArr[$value])) {
$hulpArr['zoek'] .= $hulpArr[$value] . "|";
}
}
$hulpArr['zoek'] .= $regelsArr['recid'];
if ($regelsArr['record_update']) {
$query = "UPDATE `" . $regelsArr['table'] . "` SET " . Gsm_parse(2, $hulpArr) . " WHERE `id`= '" . $regelsArr['recid'] . "'";
if ($debug) {
$msg['bug'] .= __LINE__ . " " . $query . '<br/>';
}
$results = $database->query($query);
$msg['inf'] .= 'Updated' . '<br/>';
} else {
$query = "INSERT INTO `" . $regelsArr['table'] . "` " . Gsm_parse(1, $hulpArr);
if ($debug) {
$msg['bug'] .= __LINE__ . " " . $query . '<br/>';
}
$results = $database->query($query);
$msg['inf'] .= $MOD_GSMOFF['added'] . '<br/>';
}
unset($query);
$regelsArr['mode'] = 9;
break;
case $MOD_GSMOFF['tbl_icon'][6]:
// delete
$regelsArr['recid'] = $_POST['recid'];
if (!isset($_SESSION['page_h']) || $_SESSION['page_h'] != $_POST['sh']) {
$msg['err'] .= $MOD_GSMOFF['ERR0R4'] . '</br>';
unset($_POST);
}
}
$results = $database->query($query);
$msg['inf'] .= ' Betaling ' . $n0 . ' geboekt</br>';
// read record
$n0++;
}
}
}
foreach ($_POST as $key => $value) {
$posta = explode("|", $key);
if (isset($posta[2]) && $posta[2] != $value) {
$hulpdate = Gsm_eval($value, 9, $regelsArr['totenmet'], $regelsArr['vanaf']);
if ($hulpdate > $regelsArr['vanaf']) {
$hulpArr = array('booking_date' => $hulpdate);
$query = "UPDATE `" . $regelsArr['table'] . "` SET " . Gsm_parse(2, $hulpArr) . " WHERE `id`='" . $posta[1] . "'";
$results = $database->query($query);
$msg['inf'] .= $posta[2] . ' => ' . $hulpdate . ' Boekdatum aangepast</br>';
} else {
$msg['inf'] .= $posta[2] . ' => ' . $value . ' Datum --out of range--</br>';
}
}
}
// at this point the update is done and the mode and databse query are prepared database query for the relevant records prepared
if ($debug) {
Gsm_debug($regelsArr, __LINE__);
// Gsm_debug( $rekeningArr, __LINE__);
// Gsm_debug( $rekeningtypeArr, __LINE__);
// Gsm_debug( $activaArr, __LINE__);
// Gsm_debug( $offdatArr, __LINE__);
// Gsm_debug( $offsetArr, __LINE__);
$hulpArra['name'] = $value;
$Ldata = true;
}
if ($hlp[2] == 4) {
$hulpArra['value'] = $value;
$Ldata = true;
}
break;
default:
// not for the update
break;
}
}
}
if ($Ldata) {
$query = "INSERT INTO `" . CH_DBBASE . "` " . Gsm_parse(1, $hulpArra);
$msg['bug'] .= '<br/>id ' . __LINE__ . " " . $query . '<br/>';
$results = $database->query($query);
$msg['inf'] .= 'data insert</br>';
}
}
/*
* read all the records and display for edit
*/
$query = "SELECT * FROM `" . CH_DBBASE . "` ORDER BY `section`, `table`, `name`";
$message = __LINE__ . $MOD_GSMOFF['TXT_ERROR_DATABASE'] . $query . "</br>";
$results = $database->query($query);
if (!$results || $results->numRows() == 0) {
die($message);
}
while ($row = $results->fetchRow()) {
unset($query);
$regelsArr['mode'] = 9;
break;
case $MOD_GSMOFF['tbl_icon'][4]:
//opslaan
if ($debug) {
$msg['bug'] .= __LINE__ . ' access <br/>';
}
$hulpArr = array();
foreach ($fieldArr as $key => $value) {
$hulpArr[$key] = $regelsArr['x' . $key];
}
if ($debug) {
Gsm_debug($hulpArr, __LINE__);
}
$query = "UPDATE `" . $regelsArr['standen'] . "` SET " . Gsm_parse(2, $hulpArr) . " WHERE `id` = '" . $regelsArr['recid'] . "'";
$msg['inf'] .= ' entry updated<br/>';
if ($debug) {
$msg['bug'] .= __LINE__ . ' ' . $query . ' <br/>';
}
$results = $database->query($query);
unset($query);
$regelsArr['mode'] = 9;
break;
case $MOD_GSMOFF['tbl_icon'][11]:
//print
if ($debug) {
$msg['bug'] .= __LINE__ . ' access <br/>';
}
$regelsArr['filename_pdf'] = strtolower($regelsArr['project']) . '.pdf';
require_once $place_incl . 'pdf.inc';
function func_restore_zoek($Arr_in)
{
/*
* Move restore the zoek parameter
*/
global $database;
$oke = true;
$returnvalue = "";
$idArr = array();
$idArr[0] = '';
$query = "SELECT * FROM `" . $Arr_in['table_rek'] . "`";
$r_results = $database->query($query);
if ($r_results && $r_results->numRows() > 0) {
while ($r_row = $r_results->fetchRow()) {
$idArr[$r_row['id']] = $r_row['rekeningnummer'];
}
}
$query = "SELECT * FROM `" . $Arr_in['table'] . "`";
$r_results = $database->query($query);
if ($r_results && $r_results->numRows() > 0) {
while ($r_row = $r_results->fetchRow()) {
$hulpArr = array();
$zoek = sprintf('%s|%s|%s|%s|%s|%s', $r_row['project'], $idArr[$r_row['debet_id']], $idArr[$r_row['tegen1_id']], $idArr[$r_row['tegen2_id']], $r_row['debet_amount'], $r_row['id']);
if ($zoek != $r_row['zoek']) {
$hulpArr['zoek'] = $zoek;
}
if ($idArr[$r_row['debet_id']] != $r_row['debet_rekening']) {
$hulpArr['debet_rekening'] = $idArr[$r_row['debet_id']];
}
if ($idArr[$r_row['tegen1_id']] != $r_row['tegen1_rekening']) {
$hulpArr['tegen1_rekening'] = $idArr[$r_row['tegen1_id']];
}
if ($idArr[$r_row['tegen2_id']] != $r_row['tegen2_rekening']) {
$hulpArr['tegen2_rekening'] = $idArr[$r_row['tegen2_id']];
}
if (abs($r_row['tegen2_amount']) < 0.001) {
$hulpArr['tegen2_rekening'] = $idArr[0];
}
if (count($hulpArr) > 0) {
$query = "UPDATE `" . $Arr_in['table'] . "` SET " . Gsm_parse(2, $hulpArr) . " WHERE `id`='" . $r_row['id'] . "'";
$u_results = $database->query($query);
}
}
}
// ($r_results && $r_results->numRows() > 0)
return $oke;
}
}
$results = $database->query($query);
$msg['inf'] .= $MOD_GSMOFF['changed'] . '<br/>';
if ($mail_dif) {
// update login mail address
$query = "SELECT * FROM `" . $regelsArr['table'] . "` WHERE `email`= '" . $regelsArr['email'] . "'";
if ($debug) {
$msg['bug'] .= '<br/>id ' . __LINE__ . " " . $query . '<br/>';
}
$results = $database->query($query);
if ($results->numRows() == 1) {
$row = $results->fetchRow();
if ($row['email'] == $row['username']) {
$hulp2Arr['username'] = $hulp2Arr['email'];
}
$query = "UPDATE `" . $regelsArr['table'] . "` SET " . Gsm_parse(2, $hulp2Arr) . " WHERE `email`= '" . $regelsArr['email'] . "'";
if ($debug) {
$msg['bug'] .= '<br/>id ' . __LINE__ . " " . $query . '<br/>';
}
$results = $database->query($query);
$msg['inf'] .= 'Updated' . '<br/>';
}
}
}
$query = "SELECT * FROM `" . $regelsArr['adressen'] . "` WHERE `email`= '" . $regelsArr['nwemail'] . "'";
$regelsArr['mode'] = 8;
} else {
unset($query);
$regelsArr['mode'] = 9;
}
break;
