function func_rek_moveatt($Arr_in, $year)
{
/*
* Move attachments
*/
global $database;
$oke = true;
$returnvalue = "";
$subtotals = array();
$idArr = array();
$query = "SELECT * FROM `" . $Arr_in['table'] . "`";
$r_results = $database->query($query);
if ($r_results && $r_results->numRows() > 0) {
while ($r_row = $r_results->fetchRow()) {
$idArr[$r_row['id']] = $r_row['booking_date'];
}
$fileArr = Gsm_get_files($Arr_in['dir_to_orig'], $prefix = "_" . $Arr_in['file_pre'] . "_");
foreach ($fileArr as $key => $value) {
$help = explode('_', $value);
if ($help[1] == $Arr_in['file_pre']) {
if (isset($idArr[$help[2]])) {
$help[0] = $idArr[$help[2]];
$newname = implode("_", $help);
rename($Arr_in['dir_to_orig'] . '/' . $value, $Arr_in['dir_to'] . '/' . $newname);
}
}
}
}
// ($r_results && $r_results->numRows() > 0)
return $oke;
}
}
if ($regelsArr['tvsummary'] > 1) {
$regelsArr['descr'] .= sprintf($LINETEMP[82], $MOD_GSMOFF['line_color'][2], '', ucfirst('Correctie arbeidsduur'), sprintf($ICONTEMP[23], 'tvperc', 10, $regelsArr['tvperc'], 'maanden'), '', '');
}
if ($regelsArr['tvsummary'] > 1) {
$regelsArr['descr'] .= sprintf($LINETEMP[82], $MOD_GSMOFF['line_color'][2], '', ucfirst('Correctie transactievergoeding'), sprintf($ICONTEMP[23], 'tvamtc', 12, $regelsArr['tvamtc'], 'Bedrag'), '', '');
}
if ($regelsArr['tvsummary'] > 1) {
$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']) {
//$row = $results->fetchRow()
} else {
$regelsArr['descr'] .= $MOD_GSMOFF['nodata'];
}
break;
}
//$regelsArr[ 'mode' ]
/*
* display select elements
*/
switch ($regelsArr['mode']) {
case 5:
// edit
$regelsArr['select'] .= $LINETEMP[1];
$regelsArr['select'] .= sprintf($LINETEMP[2], '', $ICONTEMP[4], $ICONTEMP[2], '', '', $ICONTEMP[5]);
$arr_files = Gsm_get_files(WB_PATH . "/" . $regelsArr['file0'] . "/" . $regelsArr['file1'], "_" . $regelsArr['file_pre'] . "_" . $populateArray['recid']);
foreach ($arr_files as $key => $value) {
$populateArray['bijlage'] .= sprintf($ICONTEMP[20], $regelsArr['file0'] . "/" . $regelsArr['file1'], $value, $value, $populateArray['recid'], substr($value, 10, 6));
if ($debug) {
$msg['bug'] .= __LINE__ . ' EN: ' . $key . "|" . $value . '</br>';
}
}
//$arr_files as $key => $value
break;
default:
// default list
$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' ]
