$regelsArr['descr'] .= sprintf($LINETEMP[82], $MOD_GSMOFF['line_color'][2], '', ucfirst('Opmerking'), sprintf($ICONTEMP[26], 'comment', 4, $regelsArr['comment'], 'aanvullende gegevens'), '', '');
}
/*
* bijlages
*/
if ($regelsArr['tvsummary'] > 1 && isset($regelsArr['memored_recid']) && $regelsArr['memored_recid'] > 0) {
$regelsArr['descr'] .= sprintf($LINETEMP[81], $MOD_GSMOFF['line_color'][4], ucfirst('Bijlages'), '', '', '');
$arr_files = Gsm_get_files(WB_PATH . "/" . $regelsArr['file0'] . "/" . $regelsArr['file1'], $regelsArr['memored_recid'] . "_", 1);
foreach ($arr_files as $key => $value) {
$regelsArr['descr'] .= sprintf($LINETEMP[81], $MOD_GSMOFF['line_color'][1], '', sprintf($ICONTEMP[30], $regelsArr['file0'] . "/" . $regelsArr['file1'], $value, $value, $regelsArr['memored_recid'], $value));
if ($debug) {
$msg['bug'] .= __LINE__ . ' EN: ' . $key . "|" . $value . '</br>';
}
}
//$arr_files as $key => $value
$regelsArr['descr'] .= sprintf($LINETEMP[82], $MOD_GSMOFF['line_color'][2], '', ucfirst('Bijlage type'), sprintf($ICONTEMP[25], "atttype", '', Gsm_option($MOD_GSMOFF['trans_att'], 6)), '', '', '');
$regelsArr['descr'] .= sprintf($LINETEMP[82], $MOD_GSMOFF['line_color'][2], '', ucfirst('Extra omschrijving'), sprintf($ICONTEMP[23], 'attoms', 20, '', 'Bijlage Omschrijving'), '', '');
$regelsArr['descr'] .= sprintf($LINETEMP[82], $MOD_GSMOFF['line_color'][2], '', ucfirst('Opmerking '), sprintf($ICONTEMP[29], 'Attdoc'), '', '', '');
}
/*
* selections of existing entries
*/
if ($regelsArr['selection_block']) {
/*
* Bestaande entries zoeken
*/
$query = "SELECT * FROM `" . $regelsArr['file'] . "` WHERE `name`= '" . $regelsArr['owner_email'] . "' ORDER BY `tvstatus`, `updated` DESC";
// echo __LINE__.$query;
$results = $database->query($query);
if ($results && $results->numRows() > 0) {
$regelsArr['toegift'] .= '<table class="container" width="100%">';
$tint = false;
} else {
$hulp = "";
$tint = true;
}
$regelsArr['descr'] .= sprintf($LINETEMP[2], $hulp, $key, $value, '', '', '', '', '');
}
$tint = false;
if ($tint) {
$hulp = $MOD_GSMOFF['line_color'][2];
$tint = false;
} else {
$hulp = "";
$tint = true;
}
$regelsArr['descr'] .= sprintf($LINETEMP[2], $hulp, '<input maxlength="20" size="20" type="text" name="veld" value="" placeholder="veld" />', '<SELECT name="veld_type" >' . Gsm_option($MOD_GSMOFF['autocomplete'], '') . '</SELECT>', '', '', '', '', '');
break;
case 7:
// Update
$results = $database->query($query);
$row = $results->fetchRow();
$regelsArr['update'] = $row['updated'];
case 8:
// invoer
$regelsArr['head'] .= sprintf($LINETEMP[7], '', ucfirst($MOD_GSMOFF['tbl_label']), '', ucfirst($MOD_GSMOFF['tbl_value']), '', '', '', '', '');
foreach ($fieldArr as $key => $value) {
$h1 = isset($row[$key]) ? $row[$key] : "";
$h2 = array_search($key, $regelsArr['veldname']);
if (isset($regelsArr['veldhead'][$h2])) {
$h3 = strlen($regelsArr['veldhead'][$h2]) > 1 ? $regelsArr['veldhead'][$h2] : $key;
}
Gsm_debug($_POST, __LINE__);
}
if ($debug) {
Gsm_debug($regelsArr, __LINE__);
}
// controle rekening
if ($regelsArr['select_rek_id'] == '0') {
$regelsArr['mode'] = '9';
$msg['err'] .= $MOD_GSMOFFM['LAB_OMS'] . " : " . $MOD_GSMOFFM['error2'] . '</br>';
} else {
$regelsArr['mode'] = '1';
}
/*
* Menu
*/
$parseViewArr = array('menu' => $TEMPLATE[4], 'return' => CH_RETURN, 'module' => $regelsArr['module'], 'header' => $regelsArr['app'], 'page_id' => $page_id, 'section_id' => $section_id, 'message' => message($msg, $debug), 'rekeningen' => Gsm_option($activaArr, $regelsArr['select_rek_id']), 'vanaf' => $regelsArr['vanaf'], 'totenmet' => $regelsArr['totenmet'], 'bedragvan' => Gsm_opmaak($regelsArr['bedragvan'], 8));
$print .= $TEMPLATE[3];
foreach ($parseViewArr as $key => $value) {
$print = str_replace("{" . $key . "}", $value, $print);
}
if (isset($query)) {
unset($query);
}
$msg['bug'] = "";
/*
* some job to do
*/
if (isset($_POST['vink'])) {
$n0 = 1;
foreach ($_POST['vink'] as $key => $value) {
$query = "SELECT * FROM `" . $regelsArr['table'] . "`WHERE `id`='" . $value . "'";
if (isset($_POST['module'])) {
$tmodule = strtolower($_POST['module']);
}
if (substr($tmodule, 0, 1) != "t") {
$tmodule = "t" . $tmodule;
}
if (isset($_GET['selection'])) {
$tselection = strtolower($_GET['selection']);
}
if (isset($_POST['selection'])) {
$tselection = strtolower($_POST['selection']);
}
if (isset($_POST['setting'])) {
$tsetting = true;
}
$parseViewArray = array('return' => CH_RETURN, 'parameter' => $tselection, 'module' => Gsm_option($set_menu, $tmodule), 'add_needed' => '', 'mod' => $tmodule, 'sel' => $tselection);
$print = $TEMPLATE[0];
foreach ($parseViewArray as $key => $value) {
$print = str_replace("{" . $key . "}", $value, $print);
}
if (strlen($tmodule) > 3 && $tmodule != 'tdummy') {
if ($debug) {
$msg['bug'] .= __LINE__ . ' => ' . $tmodule . '.php<br/>';
if ($tselection) {
$msg['bug'] .= __LINE__ . ' selection: ' . $tselection . '<br/>';
}
if ($tsetting) {
$msg['bug'] .= __LINE__ . ' settings<br/>';
}
}
unset($query);
}
if (!isset($regelsArr['naam'][3])) {
$regelsArr['naam'][3] = '';
}
if (!isset($regelsArr['adres'][0])) {
$regelsArr['adres'][0] = '';
}
if (!isset($regelsArr['adres'][1])) {
$regelsArr['adres'][1] = '';
}
if (!isset($regelsArr['adres'][2])) {
$regelsArr['adres'][2] = '';
}
if (!isset($regelsArr['adres'][3])) {
$regelsArr['adres'][3] = '';
}
$parseViewArray = array('header' => $regelsArr['recid'] != "" ? $MOD_GSMOFF['lgn_edit'] : $MOD_GSMOFF['lgn_toev'], 'titel4a' => $regelsArr['recid'] != "" ? $MOD_GSMOFF['lgn_ist'] : '', 'titel4b' => $regelsArr['recid'] != "" ? $MOD_GSMOFF['lgn_soll'] : $MOD_GSMOFF['lgn_toev'], 'id' => $regelsArr['recid'] != "" ? $MOD_GSMOFF['lgn_id'] : '', 'recid' => isset($regelsArr['recid']) ? $regelsArr['recid'] : '', 'naam' => $MOD_GSMOFF['lgn_name'], 'naam1' => $regelsArr['naam'][0], 'naam2' => $regelsArr['naam'][1], 'naam3' => $regelsArr['naam'][2], 'naam4' => $regelsArr['naam'][3], 'naam1n' => isset($regelsArr['nwnaam'][0]) && strlen($regelsArr['nwnaam'][0]) > 1 ? $regelsArr['nwnaam'][0] : $regelsArr['naam'][0], 'naam2n' => isset($regelsArr['nwnaam'][1]) && strlen($regelsArr['nwnaam'][1]) > 1 ? $regelsArr['nwnaam'][1] : $regelsArr['naam'][1], 'naam3n' => isset($regelsArr['nwnaam'][2]) && strlen($regelsArr['nwnaam'][2]) > 1 ? $regelsArr['nwnaam'][2] : $regelsArr['naam'][2], 'naam4n' => isset($regelsArr['nwnaam'][3]) && strlen($regelsArr['nwnaam'][3]) > 1 ? $regelsArr['nwnaam'][3] : $regelsArr['naam'][3], 'naam1c' => $MOD_GSMOFF['lgn_name1'], 'naam2c' => $MOD_GSMOFF['lgn_name2'], 'naam3c' => $MOD_GSMOFF['lgn_name3'], 'naam4c' => $MOD_GSMOFF['lgn_name4'], 'adres' => $MOD_GSMOFF['lgn_adres'], 'adres1' => $regelsArr['adres'][0], 'adres2' => $regelsArr['adres'][1], 'adres3' => $regelsArr['adres'][2], 'adres4' => $regelsArr['adres'][3], 'adres1n' => isset($regelsArr['nwadres'][0]) && strlen($regelsArr['nwadres'][0]) > 1 ? $regelsArr['nwadres'][0] : $regelsArr['adres'][0], 'adres2n' => isset($regelsArr['nwadres'][1]) && strlen($regelsArr['nwadres'][1]) > 1 ? $regelsArr['nwadres'][1] : $regelsArr['adres'][1], 'adres3n' => isset($regelsArr['nwadres'][2]) && strlen($regelsArr['nwadres'][2]) > 1 ? $regelsArr['nwadres'][2] : $regelsArr['adres'][2], 'adres4n' => isset($regelsArr['nwadres'][3]) && strlen($regelsArr['nwadres'][3]) > 1 ? $regelsArr['nwadres'][3] : $regelsArr['adres'][3], 'adres1c' => $MOD_GSMOFF['lgn_adres1'], 'adres2c' => $MOD_GSMOFF['lgn_adres2'], 'adres3c' => $MOD_GSMOFF['lgn_adres3'], 'adres4c' => $MOD_GSMOFF['lgn_adres4'], 'e-mail' => $MOD_GSMOFF['lgn_email'], 'email1' => $regelsArr['email'], 'email1n' => isset($regelsArr['nwemail']) && strlen($regelsArr['nwemail']) > 1 ? $regelsArr['nwemail'] : $regelsArr['email'], 'email1c' => $MOD_GSMOFF['lgn_user'], 'info' => $MOD_GSMOFF['lgn_opm'], 'infon' => isset($regelsArr['info']) ? $regelsArr['info'] : '', 'infoc' => $MOD_GSMOFF['lgn_rem'], 'mobiel' => $MOD_GSMOFF['lgn_gsm'], 'mob1' => isset($regelsArr['contact'][0]) && strlen($regelsArr['contact'][0]) ? $regelsArr['contact'][0] : '', 'mob1n' => isset($regelsArr['contact'][0]) ? $regelsArr['contact'][0] : '', 'mob1c' => $MOD_GSMOFF['lgn_num'], 'telefoon' => $MOD_GSMOFF['lgn_tel'], 'tel1' => isset($regelsArr['contact'][1]) && strlen($regelsArr['contact'][1]) ? $regelsArr['contact'][1] : '', 'tel1n' => isset($regelsArr['contact'][1]) ? $regelsArr['contact'][1] : '', 'tel1c' => $MOD_GSMOFF['lgn_num'], 'Userid' => $regelsArr['username'] != "" ? "Userid" : "", 'userid' => $regelsArr['username'], 'refer' => $MOD_GSMOFF['ref'], 'referc' => $MOD_GSMOFF['ref'], 'refern' => $regelsArr['refer'], 'communicatie' => $MOD_GSMOFF['lgn_comm'], 'wijze1' => isset($MOD_GSMOFF['lgn_com'][$regelsArr['note']]) ? $MOD_GSMOFF['lgn_com'][$regelsArr['note']] : $MOD_GSMOFF['lgn_nn'], 'wijze_opt' => isset($MOD_GSMOFF['lgn_com'][$regelsArr['nwnote']]) ? Gsm_option($MOD_GSMOFF['lgn_com'], $regelsArr['nwnote']) : Gsm_option($MOD_GSMOFF['lgn_com'], 1), 'vorm' => $MOD_GSMOFF['lgn_bedrijfsvorm'], 'vorm1' => isset($regelsArr['comp']) ? Gsm_option($MOD_GSMOFF['lgn_vorm'], $regelsArr['comp']) : Gsm_option($MOD_GSMOFF['lgn_vorm'], 1), 'vorm_opt' => isset($regelsArr['comp']) ? Gsm_option($MOD_GSMOFF['lgn_vorm'], $regelsArr['nwcomp']) : Gsm_option($MOD_GSMOFF['lgn_vorm'], 1), 'kvk_ref' => $MOD_GSMOFF['lgn_kvkref'], 'kvk_refc' => $MOD_GSMOFF['lgn_kvkref'], 'kvk_refn' => $regelsArr['comp_kvk'], 'vat_ref' => $MOD_GSMOFF['lgn_vatref'], 'vat_refc' => $MOD_GSMOFF['lgn_vatref'], 'vat_refn' => $regelsArr['comp_vat'], 'vat_verif' => $MOD_GSMOFF['lgn_vatverif'], 'vat_verifc' => $MOD_GSMOFF['lgn_vatverif'], 'vat_verifn' => $regelsArr['comp_verif'], 'bank' => $MOD_GSMOFF['lgn_bank'], 'bankc' => 'IBAN', 'bankn' => $regelsArr['bank'], 'macht_ref' => $MOD_GSMOFF['lgn_macht_ref'], 'macht_refc' => 'Machtiging ref', 'macht_refn' => $regelsArr['macht_ref'] != "0000-00-00" ? $regelsArr['macht_ref'] : "", 'macht_dat' => $MOD_GSMOFF['lgn_macht_dat'], 'macht_datc' => 'yyyy-mm-dd', 'macht_datn' => $regelsArr['macht_dat'] != "0000-00-00" ? $regelsArr['macht_dat'] : "", 'geb' => $MOD_GSMOFF['lgn_geb'], 'gebc' => 'yyyy-mm-dd', 'gebn' => $regelsArr['geb'] != "0000-00-00" ? $regelsArr['geb'] : "", 'sinds' => $MOD_GSMOFF['lgn_sinds'], 'sindsc' => 'yyyy-mm-dd', 'sindsn' => $regelsArr['sinds'] != "0000-00-00" ? $regelsArr['sinds'] : "", 'eind' => $MOD_GSMOFF['lgn_eind'], 'eindc' => 'yyyy-mm-dd', 'eindn' => $regelsArr['eind'] != "0000-00-00" ? $regelsArr['eind'] : "", 'aant' => $regelsArr['syndic'] . ' ' . $MOD_GSMOFF['lgn_notitie'], 'aantc' => $regelsArr['syndic'] . ' ' . $MOD_GSMOFF['lgn_notitie'], 'aantn' => isset($regelsArr['aant']) ? $regelsArr['aant'] : '', 'page_id' => $page_id, 'section_id' => $section_id, 'kopregels' => $regelsArr['head'], 'description' => $regelsArr['descr'], 'selection' => $regelsArr['select'], 'message' => message($msg, $debug), 'module' => $xmodule, 'terug' => $MOD_GSMOFF['tbl_icon'][2], 'wijzig' => $MOD_GSMOFF['tbl_icon'][4], 'return' => CH_RETURN);
$prout .= Gsm_prout($TEMPLATE[8], $parseViewArray);
break;
default:
//list
if ($debug) {
$msg['bug'] .= __LINE__ . ' access <br/>';
}
$parseViewArray = array('header' => strtoupper($regelsArr['name']), 'return' => CH_RETURN, 'kopregels' => $regelsArr['head'], 'description' => $regelsArr['descr'], 'message' => message($msg, $debug), 'module' => $regelsArr['module'], 'page_id' => $page_id, 'section_id' => $section_id, 'selection' => $regelsArr['select'], 'searchx' => $regelsArr['search'], 'parameter' => $regelsArr['search'], 'sel' => '');
$prout .= Gsm_prout($TEMPLATE[9], $parseViewArray);
break;
}
if (strstr($set_mode, "vers")) {
$prout .= "<small>" . $regelsArr['modulen'] . $regelsArr['versie'] . "</small>";
}
$regelsArr['select'] .= $LINETEMP[1];
$regelsArr['select'] .= sprintf($LINETEMP[9], "", "", Gsm_next($regelsArr['search'], $regelsArr['n'], $regelsArr['seq'], $regelsArr['qty']), isset($regelsArr['filename_pdf']) ? sprintf($ICONTEMP[18], "", $regelsArr['filename_pdf']) : "", "");
break;
}
//$regelsArr[ 'mode' ]
/*
* the output to the screen
*/
/*
* display
*/
switch ($regelsArr['mode']) {
case 5:
// edit
$_SESSION['page_h'] = sha1(MICROTIME() . $_SERVER['HTTP_USER_AGENT']);
$parseViewArray = array('header' => strtoupper($regelsArr['project']), 'kopregels' => $regelsArr['head'], 'page_id' => $page_id, 'zoeken' => $regelsArr['search'], 'section_id' => $section_id, 'message' => message($msg, $debug), 'recid' => $populateArray['recid'], 'bk_name' => $populateArray['name'], 'bk_date' => $populateArray['booking_date'], 'bk_comment' => $populateArray['boekstuk'], 'bk_project_opt' => Gsm_option($projectArray, $populateArray['project']), 'bk_debet_opt' => Gsm_option($rekeningArray, $populateArray['debet_id']), 'bk_tegen1_opt' => Gsm_option($rekeningArray, $populateArray['tegen1_id']), 'bk_tegen2_opt' => Gsm_option($rekeningArray, $populateArray['tegen2_id']), 'bk_debet_amount' => $populateArray['debet_amount'], 'bk_tegen1_amount' => $populateArray['tegen1_amount'], 'bk_tegen2_amount' => $populateArray['tegen2_amount'], 'bk_book_doc' => $populateArray['bijlage'], 'update' => $populateArray['updated'], 'hash' => $_SESSION['page_h'], 'selection' => $regelsArr['select'], 'memory' => $regelsArr['memory'] . "|", 'toegift' => $regelsArr['toegift'], 'rapportage' => $regelsArr['rapport'], 'return' => CH_RETURN, 'mod' => $regelsArr['module'], 'module' => $regelsArr['module'], 'sel' => '');
$prout .= Gsm_prout($TEMPLATE[3] . $TEMPLATE[4], $parseViewArray);
break;
default:
// default list
$_SESSION['page_h'] = sha1(MICROTIME() . $_SERVER['HTTP_USER_AGENT']);
$parseViewArray = array('header' => strtoupper($regelsArr['project']), 'page_id' => $page_id, 'section_id' => $section_id, 'kopregels' => $regelsArr['head'], 'description' => $regelsArr['descr'], 'message' => message($msg, $debug), 'selection' => $regelsArr['select'], 'return' => CH_RETURN, 'parameter' => $regelsArr['search'], 'module' => $regelsArr['module'], 'memory' => $regelsArr['memory'] . "|", 'toegift' => $regelsArr['toegift'], 'recid' => $regelsArr['recid'], 'rapportage' => $regelsArr['rapport'], 'hash' => $_SESSION['page_h']);
$prout .= Gsm_prout($TEMPLATE[2], $parseViewArray);
break;
}
//$regelsArr[ 'mode' ]
if (strstr($set_mode, "vers")) {
$prout .= "<small>" . $regelsArr['modulen'] . $regelsArr['versie'] . "</small>";
}
?>
if ($regelsArr['wrsummary'] == 2) {
$regelsArr['descr'] .= sprintf($LINETEMP[12], $MOD_GSMOFF["line_color"][2], "BCC", '', '', '');
$hulp = sprintf("%s adressen ot %s maila ", count($AmatchArr), count($SmatchArr));
}
$regelsArr['descr'] .= sprintf($LINETEMP[12], $MOD_GSMOFF["line_color"][2], "ONDERWERP", '', '', '');
$regelsArr['descr'] .= sprintf($LINETEMP[14], sprintf($LINETEMP[88], "subject", 80, $regelsArr['subject'], "onderwerp"), '', '', '');
if ($regelsArr['wrsummary'] == 1) {
$regelsArr['descr'] .= sprintf($LINETEMP[12], $MOD_GSMOFF["line_color"][2], "ATTACHMENT", '', '', '');
$regelsArr['descr'] .= sprintf($LINETEMP[14], sprintf($LINETEMP[72], ''), '', '', '');
}
$regelsArr['descr'] .= sprintf($LINETEMP[12], $MOD_GSMOFF["line_color"][2], "INHOUD", '', '', '');
$hulp = array();
foreach ($contentArr as $key => $value) {
$hulp[$key] = $key;
}
$regelsArr['descr'] .= sprintf($LINETEMP[12], $MOD_GSMOFF['line_color'][3], ucfirst('Textselectie ') . sprintf($ICONTEMP[25], "wrtekst", '', Gsm_option($hulp, $regelsArr['wrtekst'])), '', '', '');
$regelsArr['descr'] .= sprintf($LINETEMP[12], '', $contentArr[$regelsArr['wrtekst']], '', '', '');
break;
}
//$regelsArr[ 'mode' ]
/*
* selection
*/
switch ($regelsArr['mode']) {
case 8:
// display met mail
if ($debug) {
$msg['bug'] .= __LINE__ . ' access <br/>';
}
$regelsArr['select'] .= $LINETEMP[1];
$regelsArr['select'] .= sprintf($LINETEMP[2], '', $ICONTEMP[8], '', '', '', $ICONTEMP[20]);
