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