$msg['bug'] .= __LINE__ . " " . $query . '<br/>';
}
$results = $database->query($query);
$msg['inf'] .= $MOD_GSMOFF['added'] . '<br/>';
}
unset($query);
$regelsArr['mode'] = 9;
} else {
foreach ($_POST as $key => $value) {
// check for budget update
$budget = explode("|", $key);
if ($budget[0] == 'a') {
// budget data
if ($budget[2] != $value) {
//budget different
$hulpArr = array('budget_b' => Gsm_eval($value, 8, 10000000, 0));
$query = "UPDATE `" . $regelsArr['table'] . "` SET " . Gsm_parse(2, $hulpArr) . " WHERE `id`= '" . $budget[1] . "'";
if ($debug) {
$msg['bug'] .= '<br/>id ' . __LINE__ . " " . $query . '<br/>';
}
$results = $database->query($query);
}
}
}
$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'][5]:
//save as new
if (!isset($_SESSION['page_h']) || $_SESSION['page_h'] != $_POST['sh']) {
case 4:
// 'varchar(63)'
if (isset($_POST[$key])) {
$regelsArr['x' . $key] = Gsm_eval($_POST[$key], 1, 63, 0);
}
break;
case 5:
// 'varchar(127)'
if (isset($_POST[$key])) {
$regelsArr['x' . $key] = Gsm_eval($_POST[$key], 1, 127, 0);
}
break;
case 6:
// 'date'
if (isset($_POST[$key])) {
$regelsArr['x' . $key] = Gsm_eval($_POST[$key], 9, '2020-01-01', '1970-01-01');
}
break;
case 2:
// 'int(11)'
// 'int(11)'
case 7:
// 'int(7)'
// 'int(7)'
default:
if (isset($_POST[$key])) {
$regelsArr['x' . $key] = $_POST[$key];
}
break;
}
}
if ($debug) {
if (isset($query)) {
$msg['bug'] .= __LINE__ . $query . ' case 4111</br>';
}
}
$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__);
$msg['bug'] .= __LINE__ . ' ' . $query . ' <br/>';
}
$result = $database->query($query);
}
//$results && $results->numRows() >= 1
}
//$_POST[ 'vink' ] as $key => $value
}
//isset( $_POST[ 'vink' ][ 0 ] )
foreach ($_POST as $key => $value) {
$posta = explode("|", $key);
if ($posta[0] == "a") {
// correct type
if (isset($posta[2]) && $posta[2] != $value) {
// something changed
$hulpArr = array('datumist' => Gsm_eval($value, 9, '2020-01-01', '0000-00-00'));
$query = "UPDATE `" . $regelsArr['standen'] . "` SET " . Gsm_parse(2, $hulpArr) . " WHERE `id` = '" . $posta[1] . "'";
if ($debug) {
$msg['bug'] .= __LINE__ . ' ' . $query . ' <br/>';
}
$results = $database->query($query);
}
//isset( $posta[ 2 ] ) && $posta[ 2 ] != $value
}
//$posta[ 0 ] == "a"
}
//$_POST as $key => $value
unset($query);
// verder met betaling
// verder met betaling
case $MOD_GSMOFF['tbl_icon'][12]:
$regelsArr['nwadres'] = explode("|", $_POST['adres1'] . "|" . $_POST['adres2'] . "|" . $_POST['adres3'] . "|" . $_POST['adres4']);
$regelsArr['nwemail'] = $_POST['email1'];
$regelsArr['nwnote'] = $_POST['wijze1'];
$regelsArr['nwinfo'] = $_POST['info'];
$regelsArr['nwcontact'] = explode("|", $_POST['mob1'] . "|" . $_POST['tel1']);
$regelsArr['nwrefer'] = $_POST['refer'];
$regelsArr['nwcomp'] = $_POST['vorm1'];
$regelsArr['nwcomp_vat'] = $_POST['vat_ref'];
$regelsArr['nwcomp_kvk'] = $_POST['kvk_ref'];
$regelsArr['nwcomp_verif'] = $_POST['vat_verif'];
$regelsArr['nwbank'] = $_POST['bank'];
$regelsArr['nwmacht_ref'] = $_POST['macht_ref'];
$regelsArr['nwmacht_dat'] = Gsm_eval($_POST['macht_dat'], 9, '2030-01-01', '1900-01-01');
$regelsArr['nwgeb'] = Gsm_eval($_POST['geb'], 9, '2030-01-01', '1900-01-01');
$regelsArr['nwsinds'] = Gsm_eval($_POST['sinds'], 9, '2030-01-01', '1970-01-01');
$regelsArr['nweind'] = Gsm_eval($_POST['eind'], 9, '2030-01-01', '1970-01-01');
$regelsArr['nwaant'] = $_POST['aant'];
$hulpArr = array();
$hulp2Arr = array();
$update_ok = false;
$mail_dif = false;
// naam changed
if ($debug) {
Gsm_debug($regelsArr['naam'], __LINE__);
}
if ($debug) {
Gsm_debug($regelsArr['nwnaam'], __LINE__);
}
if (implode('|', $regelsArr['naam']) != implode('|', $regelsArr['nwnaam'])) {
$hulpArr['name'] = implode('|', $regelsArr['nwnaam']);
$hulpArr['nwname'] = '|||';
$msg['err'] .= $MOD_GSMOFF['error4'] . '</br>';
unset($_POST);
break;
}
//$_POST[ 'update_verif' ] != $row[ 'updated' ]
}
//$regelsArr[ 'save_update' ]
/*
* SIPs check done and record collected
*/
$hulpArr = array('name' => Gsm_eval($_POST['bk_name']), 'booking_date' => Gsm_eval($_POST['bk_date'], 9, $regelsArr['tyear'], $regelsArr['fyear']), 'project' => $_POST['bk_project_name'], 'debet_amount' => Gsm_eval($_POST['bk_debet_amount'], 8, 999999, -999999), 'tegen2_amount' => Gsm_eval($_POST['bk_tegen2_amount'], 8, 999999, -999999), 'tegen1_amount' => '0', 'debet_id' => $_POST['bk_debet_name'], 'tegen1_id' => $_POST['bk_tegen1_name'], 'tegen2_id' => $_POST['bk_tegen2_name'], 'debet_rekening' => Gsm_eval(substr($rekeningArray[$_POST['bk_debet_name']], 0, $regelsArr['rekening size']), 8, 9999), 'tegen1_rekening' => Gsm_eval(substr($rekeningArray[$_POST['bk_tegen1_name']], 0, $regelsArr['rekening size']), 8, 9999), 'tegen2_rekening' => Gsm_eval(substr($rekeningArray[$_POST['bk_tegen2_name']], 0, $regelsArr['rekening size']), 8, 9999), 'boekstuk' => Gsm_eval($_POST['bk_comment']), 'zoek' => '');
if ($hulpArr['booking_date'] < date("Y-m", strtotime($regelsArr['tyear'])) . "-01") {
$hulpArr['boekstuk'] = str_replace("_", "", $hulpArr['boekstuk']);
}
//$hulpArr[ 'booking_date' ] < date( "Y-m", strtotime( $regelsArr[ 'tyear' ] ) ) . "-01"
$hulpArr['tegen1_amount'] = Gsm_eval($hulpArr['debet_amount'] - $hulpArr['tegen2_amount'], 8, 999999, -999999);
$hulpArr['zoek'] = $settingArr['opzoek'];
// hoe ziet zoek eruit
foreach ($hulpArr as $key => $value) {
$hulpArr['zoek'] = str_replace($key, $value, $hulpArr['zoek']);
}
//$hulpArr as $key => $value
// arrange tables for update or insert
if ($regelsArr['save_update']) {
// save
$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'] .= $MOD_GSMOFF['save'] . ' : ' . $hulpArr['name'] . ' ' . $MOD_GSMOFF['changed'] . ' </br>';
// just strip spaces and but keep linebreaks
$hulp = nl2br(trim($_POST['matchR']));
$hulp = preg_replace('!\\s+!', ' ', $hulp);
$hulp = str_replace('<br /> ', NL, $hulp);
$hulp = str_replace('<br />', NL, $hulp);
$hulp = str_replace(NL, CH_CR, $hulp);
$regelsArr['matchR'] = $hulp;
}
if (isset($_POST['from'])) {
$regelsArr['from'] = Gsm_eval($_POST['from'], 3);
}
if (isset($_POST['wrsummary'])) {
$regelsArr['wrsummary'] = Gsm_eval($_POST['wrsummary'], 8);
}
if (isset($_POST['wrtekst'])) {
$regelsArr['wrtekst'] = Gsm_eval($_POST['wrtekst'], 8);
}
// einde input verwerking
if (strlen($regelsArr['subject']) > 6) {
$regelsArr['mode'] = 8;
}
if ($debug) {
Gsm_debug($regelsArr, __LINE__);
}
switch ($_POST['command']) {
case $MOD_GSMOFF['tbl_icon'][8]:
//controle
if (isset($_POST['selection']) && strlen($_POST['selection']) >= 2) {
$regelsArr['search'] = trim($_POST['selection']);
}
break;
