// DataGrid Filter
$legendFilter = getBadgerTranslation2('dataGrid', 'filterLegend');
$datagGridFilterArray = $dataGrid->getNumberFilterSelectArray();
$datagGridStringFilterArray = $dataGrid->getStringFilterSelectArray();
$datagGridDateFilterArray = $dataGrid->getDateFilterSelectArray();
$titleLabel = $widgets->createLabel("title", getBadgerTranslation2('accountTransaction', 'title'), false);
$titleField = $widgets->createField("title", 30, "", "", false, "text", "");
$titleFilterOperator = $widgets->createSelectField("titleFilter", $datagGridStringFilterArray, "", "", false, "style='width: 95px;'");
$valutaDateLabel = $widgets->createLabel("valutaDate", getBadgerTranslation2('accountTransaction', 'valutaDate'), false);
$valutaDateField = $widgets->addDateField("valutaDate", "");
$valutaDateFilterOperator = $widgets->createSelectField("valutaDateFilter", $datagGridDateFilterArray, "", "", false, "style='width: 95px;'");
$amountLabel = $widgets->createLabel("amount", getBadgerTranslation2('accountTransaction', 'amount'), false);
$amountField = $widgets->createField("amount", 14, "", "", false, "text", "");
$amountFilterOperator = $widgets->createSelectField("amountFilter", $datagGridFilterArray, "", "", false, "style='width: 95px;' regexp='BADGER_NUMBER'");
$categoryLabel = $widgets->createLabel("categoryId", getBadgerTranslation2('accountTransaction', 'category'), false, "");
$categoryField = $widgets->createSelectField("categoryId", getCategorySelectArray(true), "", "", false, "style='width: 210px;'");
//$btnFilterOkay = $widgets->createButton("btnFilterOkay", getBadgerTranslation2('dataGrid', 'setFilter'), "dataGridAccount$accountID.filter.setFilterFields(['title','amount','valutaDate','categoryId'])", "Widgets/dataGrid/filter.gif");
$btnFilterOkay = $widgets->createButton("btnFilterOkay", getBadgerTranslation2('dataGrid', 'setFilter'), "submit", "Widgets/dataGrid/filter.gif");
$btnFilterReset = $widgets->createButton("btnFilterReset", getBadgerTranslation2('dataGrid', 'resetFilter'), "dataGridAccount{$accountID}.filter.resetFilterFields(['title','amount','valutaDate','categoryId'])", "Widgets/cancel.gif");
$formAction = "javascript:dataGridAccount{$accountID}.filter.setFilterFields(['title','amount','valutaDate','categoryId'])";
eval('$filterContent = "' . $tpl->getTemplate('Account/StandardFilter') . '";');
$standardFilter = $widgets->addTwistieSection("Filter", $filterContent);
// DataGrid
$btnNewFinished = $widgets->createButton("btnNewFinished", getBadgerTranslation2('accountTransaction', 'newFinishedTrans'), "dataGridAccount{$accountID}.callNewEvent('type=finished')", "Account/finished_transaction_new.gif");
$btnNewPlanned = $widgets->createButton("btnNewPlanned", getBadgerTranslation2('accountTransaction', 'newPlannedTrans'), "dataGridAccount{$accountID}.callNewEvent('type=planned')", "Account/planned_transaction_new.gif");
$btnEdit = $widgets->createButton("btnEdit", getBadgerTranslation2('dataGrid', 'edit'), "dataGridAccount{$accountID}.callEditEvent()", "Widgets/table_edit.gif");
$btnDelete = $widgets->createButton("btnDelete", getBadgerTranslation2('dataGrid', 'delete'), "dataGridAccount{$accountID}.callDeleteEvent()", "Widgets/table_delete.gif");
$btnShowPlannedTransactions = $widgets->createButton("btnShowPlannedTransactions", getBadgerTranslation2('accountOverview', 'showPlannedTrans'), "location.href = location.href.replace(/AccountOverview\\.php/, 'AccountOverviewPlanned.php');", "Account/planned_transaction.png");
$btnGotoToday = $widgets->createButton("btnGotoToday", getBadgerTranslation2('dataGrid', 'gotoToday'), "dataGridAccount{$accountID}.gotoToday()", "Widgets/dataGrid/goto.gif");
$dgHtml = $dataGrid->writeDataGrid();
$legend = getBadgerTranslation2('dataGrid', 'legend');
while ($currentAccount = $am1->getNextAccount()) {
$account1[$currentAccount->getId()] = $currentAccount->getTitle();
}
for ($outputTransactionNumber = 0; $outputTransactionNumber < $transactionNumber; $outputTransactionNumber++) {
$matchingTransactions = array();
$disableFields = '';
if (isset($importedTransactions[$outputTransactionNumber]['similarTransactions'])) {
foreach ($importedTransactions[$outputTransactionNumber]['similarTransactions'] as $similarity => $currentTransaction) {
$matchingTransactions[$currentTransaction->getId()] = $currentTransaction->getTitle() . $similarity;
//sprintf(' (%1.1f %%)', $similarity);
}
$disableFields = ' disabled="disabled"';
}
$matchingTransactions['none'] = getBadgerTranslation2('importCsv', 'dontMatchTransaction');
$tableSelectCheckbox = "<input type=\"checkbox\" name=\"select" . $outputTransactionNumber . "\" value=\"select\" checked=\"checked\" />";
$tableSelectCategory = $widgets->createSelectField("categorySelect" . $outputTransactionNumber, getCategorySelectArray(false), $importedTransactions[$outputTransactionNumber]['categoryId'], '', false, $disableFields);
$tableValutaDate = $widgets->addDateField("valutaDate" . $outputTransactionNumber, $importedTransactions[$outputTransactionNumber]["valutaDate"]->getFormatted());
$tableTitle = $widgets->createField("title" . $outputTransactionNumber, 30, $importedTransactions[$outputTransactionNumber]["title"]);
$tableAmount = $widgets->createField("amount" . $outputTransactionNumber, 8, $importedTransactions[$outputTransactionNumber]["amount"]->getFormatted());
$tableTransactionPartner = $widgets->createField("transactionPartner" . $outputTransactionNumber, 15, $importedTransactions[$outputTransactionNumber]["transactionPartner"]);
$tableDescription = $widgets->createField("description" . $outputTransactionNumber, 12, $importedTransactions[$outputTransactionNumber]["description"]);
$tablePeriodicalCheckbox = "<input type=\"checkbox\" id =\"periodical{$outputTransactionNumber}\" name=\"periodical" . $outputTransactionNumber . "\" value=\"select\" {$disableFields}/>";
$tableExceptionalCheckbox = "<input type=\"checkbox\" id=\"exceptional{$outputTransactionNumber}\" name=\"exceptional" . $outputTransactionNumber . "\" value=\"select\" {$disableFields}/>";
$tableOutsideCheckbox = "<input type=\"checkbox\" id=\"outside{$outputTransactionNumber}\" name=\"outside" . $outputTransactionNumber . "\" value=\"select\" {$disableFields}/>";
$tableSelectAccount = $widgets->createSelectField("account2Select" . $outputTransactionNumber, $account1, $importedTransactions[$outputTransactionNumber]["accountId"], '', false, $disableFields);
$tableSelectMatchingTransaction = $widgets->createSelectField('matchingTransactionSelect' . $outputTransactionNumber, $matchingTransactions, null, '', true, 'onchange="updateDisabledFields(' . $outputTransactionNumber . ');"');
//echo ("\$tplOutput .= \"".$tpl->getTemplate("CsvImport/csvImportSelectTransactions2")."\";");
eval("\$tplOutput .= \"" . $tpl->getTemplate("CsvImport/csvImportSelectTransactions2") . "\";");
}
$hiddenField = "<input type=\"hidden\" name=\"tableRows\" value=\"" . $transactionNumber . " \">";
$hiddenAccountId = $widgets->createField('hiddenAccountId', 0, $accountId, null, false, 'hidden');
function printFrontendPlanned($AccountID, $plannedTransactionId, $finishedTransactionId = null)
{
global $pageTitle;
global $tpl;
global $am;
global $redirectPage;
$widgets = new WidgetEngine($tpl);
$widgets->addToolTipJS();
$widgets->addCalendarJS();
$widgets->addJSValMessages();
$tpl->addJavaScript("js/prototype.js");
$tpl->addJavaScript('js/Transaction.js');
$tpl->addOnLoadEvent("Form.focusFirstElement('mainform')");
$now = new Date();
$categoryExpenseJS = getCategoryExpense();
$categoryExpenseWarning = getBadgerTranslation2('accountTransaction', 'categoryExpenseWarning');
$transactionType = "planned";
if ($plannedTransactionId != "new") {
$acc = $am->getAccountById($AccountID);
$transaction = $acc->getPlannedTransactionById($plannedTransactionId);
$backToIdField = $widgets->createField('backToId', 0, $AccountID, '', false, 'hidden');
if (is_null($transaction->getTransferalTransaction())) {
$transferalAmountValue = new Amount($transaction->getAmount());
$transferalAmountValue->mul(-1);
$transferalAmountValue = $transferalAmountValue->getFormatted();
} else {
if ($transaction->getTransferalSource()) {
$transferalAmountValue = $transaction->getTransferalTransaction()->getAmount()->getFormatted();
} else {
$transferalAmountValue = $transaction->getAmount()->getFormatted();
$AccountID = $transaction->getTransferalTransaction()->getAccount()->getId();
$plannedTransactionId = $transaction->getTransferalTransaction()->getId();
$ID = $transaction->getTransferalTransaction()->getId();
$transaction = $transaction->getTransferalTransaction();
}
}
$titleValue = $transaction->getTitle();
$descriptionValue = $transaction->getDescription();
$beginDateValue = is_null($tmp = $transaction->getBeginDate()) ? '' : $tmp->getFormatted();
$endDateValue = is_null($tmp = $transaction->getEndDate()) ? '' : $tmp->getFormatted();
$amountValue = is_null($tmp = $transaction->getAmount()) ? '' : $tmp->getFormatted();
$negativeAmountValue = new Amount($tmp);
$negativeAmountValue->mul(-1);
$negativeAmountValue = $negativeAmountValue->getFormatted();
$outsideCapitalValue = is_null($tmp = $transaction->getOutsideCapital()) ? '' : $tmp;
$transactionPartnerValue = $transaction->getTransactionPartner();
$categoryValue = is_null($tmp = $transaction->getCategory()) ? '' : $tmp->getId();
$repeatUnitValue = $transaction->getRepeatUnit();
$repeatFrequencyValue = $transaction->getRepeatFrequency();
} else {
//new: empty values
$titleValue = "";
$descriptionValue = "";
$beginDateValue = $now->getFormatted();
$endDateValue = "";
$amountValue = "";
$negativeAmountValue = '';
$outsideCapitalValue = "";
$transactionPartnerValue = "";
$categoryValue = "";
$repeatUnitValue = "";
$repeatFrequencyValue = "1";
$transferalAmountValue = '';
$backToIdField = '';
}
$tpl->addHeaderTag("<script type='text/javascript'>var previousAmount = '{$negativeAmountValue}';</script>");
$widgets->addNavigationHead();
echo $tpl->getHeader($pageTitle);
echo $widgets->addToolTipLayer();
if ($plannedTransactionId == 'new' || is_null($transaction->getTransferalTransaction())) {
$transferalLabel = $widgets->createLabel('transferalEnabled', getBadgerTranslation2('accountTransaction', 'transferalEnabled'), false);
$transferalField = $widgets->createField('transferalEnabled', 30, 'on', '', false, 'checkbox', "onclick='toggleTransferal();'");
$transferalFieldStyle = 'display: none;';
$transferalDataStyle = 'style="display: none;"';
$transferalAccountField = $widgets->createSelectField('transferalAccountId', getAccountsSelectArray($AccountID), '', '', false, "style='width: 213px;'");
} else {
$transferalLabel = '';
$transferalField = '';
$transferalFieldStyle = '';
$transferalDataStyle = '';
$transferalAccountField = $transaction->getTransferalTransaction()->getAccount()->getTitle();
}
$transferalAccountLabel = $widgets->createLabel('transferalAccountId', getBadgerTranslation2('accountTransaction', 'transferalAccount'), false);
$transferalAmountLabel = $widgets->createLabel('transferalAmount', getBadgerTranslation2('accountTransaction', 'transferalAmount'), false);
$transferalAmountField = $widgets->createField('transferalAmount', 30, $transferalAmountValue, '', true, 'text', " onkeyup='adjustInputNumberClass(this);' onkeydown='adjustInputNumberClass(this);' onkeypress='adjustInputNumberClass(this);' style='width: 30ex;{$transferalFieldStyle}'");
//set vars with values
$FormAction = $_SERVER['PHP_SELF'];
$backTo = $widgets->createField('backTo', 0, isset($_GET['backTo']) ? getGPC($_GET, 'backTo') : '', null, false, 'hidden');
if ($AccountID == "choose") {
$AccountLabel = $widgets->createLabel("hiddenAccID", getBadgerTranslation2('accountTransaction', 'Account'), true);
$hiddenAccID = $widgets->createSelectField("hiddenAccID", getAccountsSelectArray(), $AccountID, "", false, "style='width: 31ex;'");
} else {
$AccountLabel = "";
$hiddenAccID = $widgets->createField("hiddenAccID", 20, $AccountID, "", false, "hidden");
}
$hiddenID = $widgets->createField("hiddenID", 20, $plannedTransactionId, "", false, "hidden");
$hiddenType = $widgets->createField("hiddenType", 20, $transactionType, "", false, "hidden");
//Fields & Labels
$titleLabel = $widgets->createLabel("title", getBadgerTranslation2('accountTransaction', 'title'), true);
$titleField = $widgets->createField("title", 30, $titleValue, "", true, "text", "style='width: 30ex;'");
$descriptionLabel = $widgets->createLabel("description", getBadgerTranslation2('accountTransaction', 'description'), false);
$descriptionField = $widgets->createTextarea("description", $descriptionValue, "", false, "style='width: 30ex; height: 4em;'");
$beginDateLabel = $widgets->createLabel("beginDate", getBadgerTranslation2('accountTransaction', 'beginDate'), true);
$beginDateField = $widgets->addDateField("beginDate", $beginDateValue);
$endDateLabel = $widgets->createLabel("endDate", getBadgerTranslation2('accountTransaction', 'endDate'), true);
$endDateField = $widgets->addDateField("endDate", $endDateValue);
$amountLabel = $widgets->createLabel("amount", getBadgerTranslation2('accountTransaction', 'amount'), true);
$amountField = $widgets->createField("amount", 30, $amountValue, "", true, "text", "onchange='updateTransferalAmount();' onkeyup='adjustInputNumberClass(this);' onkeydown='adjustInputNumberClass(this);' onkeypress='adjustInputNumberClass(this);' style='width: 30ex;'");
$transactionPartnerLabel = $widgets->createLabel("transactionPartner", getBadgerTranslation2('accountTransaction', 'transactionPartner'), false);
$transactionPartnerField = $widgets->createField("transactionPartner", 30, $transactionPartnerValue, "", false, "text", "style='width: 30ex;'");
$outsideCapitalLabel = $widgets->createLabel("outsideCapital", getBadgerTranslation2('accountTransaction', 'outsideCapital'), false);
$outsideCapitalField = $widgets->createField("outsideCapital", 30, "on", "", false, "checkbox", $outsideCapitalValue);
$outsideToolTip = $widgets->addToolTip(getBadgerTranslation2("importCsv", "outsideCapitalToolTip"));
$categoryLabel = $widgets->createLabel("category", getBadgerTranslation2('accountTransaction', 'category'), false);
$categoryField = $widgets->createSelectField("category", getCategorySelectArray(), $categoryValue, "", false, "style='width: 31ex;' onchange='updateExpenseWarning();'");
$repeatUnitLabel = $widgets->createLabel("repeatUnit", getBadgerTranslation2('accountTransaction', 'repeatFrequency'), true);
$repeatUnitField = $widgets->createSelectField("repeatUnit", getIntervalUnitsArray(), $repeatUnitValue, "", true, "style='width: 104px;'");
$everyLabel = getBadgerTranslation2('intervalUnits', 'every');
$repeatFrequencyField = $widgets->createField("repeatFrequency", 1, $repeatFrequencyValue, "", true, "text", "");
if (!is_null($finishedTransactionId) && $finishedTransactionId != 'X') {
$hiddenFinishedTransactionID = $widgets->createField('hiddenFinishedTransactionID', 20, $finishedTransactionId, '', false, 'hidden');
$rangeLabel = getBadgerTranslation2('accountTransaction', 'range');
$rangeUnit = getBadgerTranslation2('accountTransaction', 'rangeUnit');
$rangeAllField = $widgets->createField('range', null, 'all', '', false, 'radio', 'checked="checked" onclick="checkBeginEndDate();"');
$rangeAllLabel = $widgets->createLabel('range', getBadgerTranslation2('accountTransaction', 'rangeAll'));
$rangeThisField = $widgets->createField('range', null, 'this', '', false, 'radio', 'onclick="checkBeginEndDate();"');
$rangeThisLabel = $widgets->createLabel('range', getBadgerTranslation2('accountTransaction', 'rangeThis'));
$rangePreviousField = $widgets->createField('range', null, 'previous', '', false, 'radio', 'onclick="checkBeginEndDate();"');
$rangePreviousLabel = $widgets->createLabel('range', getBadgerTranslation2('accountTransaction', 'rangePrevious'));
$rangeFollowingField = $widgets->createField('range', null, 'following', '', false, 'radio', 'onclick="checkBeginEndDate();"');
$rangeFollowingLabel = $widgets->createLabel('range', getBadgerTranslation2('accountTransaction', 'rangeFollowing'));
//$deleteBtn = $widgets->createButton('deleteBtn', getBadgerTranslation2('dataGrid', 'delete'), 'submit', 'Widgets/cancel.gif', "accesskey='d'");
$deleteBtn = '';
} else {
$hiddenFinishedTransactionID = '';
$rangeLabel = '';
$rangeUnit = '';
$rangeAllField = $widgets->createField('range', 20, 'all', '', false, 'hidden');
$rangeAllLabel = '';
$rangeThisField = '';
$rangeThisLabel = '';
$rangePreviousField = '';
$rangePreviousLabel = '';
$rangeFollowingField = '';
$rangeFollowingLabel = '';
$deleteBtn = '';
}
//Buttons
$submitBtn = $widgets->createButton("submitBtn", getBadgerTranslation2('dataGrid', 'save'), "submit", "Widgets/accept.gif", "accesskey='s'");
if ($redirectPage) {
$backBtn = $widgets->createButton("backBtn", getBadgerTranslation2('dataGrid', 'back'), "location.href='{$redirectPage}';return false;", "Widgets/back.gif");
} else {
$backBtn = '';
}
//add vars to template, print site
$pageHeading = getBadgerTranslation2('accountTransaction', 'headingTransactionPlanned');
eval("echo \"" . $tpl->getTemplate("Account/PlannedTransaction") . "\";");
}
$dataGridFilterArray = DataGrid::getNumberFilterSelectArray();
$dataGridDateFilterArray = DataGrid::getDateFilterSelectArray();
$dataGridStringFilterArray = DataGrid::getStringFilterSelectArray();
$pageSettingsContent = $widgets->createSelectField('pageSettingsSelect', array(), '', '', false, 'onchange="loadPageSetting();"') . ' ' . $widgets->createButton('pageSettingSave', getBadgerTranslation2('statistics2', 'pageSettingSave'), 'savePageSetting();') . ' ' . $widgets->createButton('pageSettingDelete', getBadgerTranslation2('statistics2', 'pageSettingDelete'), 'deletePageSetting();');
$pageSettingsTwistie = $widgets->addTwistieSection(getBadgerTranslation2('statistics2', 'pageSettingsTwistieTitle'), $pageSettingsContent);
$pageSettingJS = '<script type="text/javascript">var newNamePrompt = "' . getBadgerTranslation2('statistics2', 'pageSettingNewNamePrompt') . '";</script>';
$filters['unselected'] = '';
$filters['title'] = getBadgerTranslation2('statistics2', 'titleFilter') . $widgets->createSelectField("titleOperator{$FILTER_ID_MARKER}", $dataGridStringFilterArray, "", "", false, "style='width: 95px;'") . ' ' . $widgets->createField("title{$FILTER_ID_MARKER}", 30, "", "", false, "text", "");
$filters['description'] = getBadgerTranslation2('statistics2', 'descriptionFilter') . $widgets->createSelectField("descriptionOperator{$FILTER_ID_MARKER}", $dataGridStringFilterArray, "", "", false, "style='width: 95px;'") . ' ' . $widgets->createField("description{$FILTER_ID_MARKER}", 30, "", "", false, "text", "");
$filters['valutaDate'] = getBadgerTranslation2('statistics2', 'valutaDateFilter') . $widgets->createSelectField("valutaDateOperator{$FILTER_ID_MARKER}", $dataGridDateFilterArray, "", "", false, "style='width: 95px;'") . ' ' . $widgets->addDateField("valutaDate{$FILTER_ID_MARKER}", "");
$filters['valutaDateBetween'] = getBadgerTranslation2('statistics2', 'valutaDateBetweenFilter') . $widgets->addDateField("valutaDateStart{$FILTER_ID_MARKER}", "") . getBadgerTranslation2('statistics2', 'valutaDateBetweenFilterConj') . $widgets->addDateField("valutaDateEnd{$FILTER_ID_MARKER}", "") . getBadgerTranslation2('statistics2', 'valutaDateBetweenFilterInclusive');
$filters['valutaDateAgo'] = getBadgerTranslation2('statistics2', 'valutaDateAgoFilter') . $widgets->createField("valutaDateAgo{$FILTER_ID_MARKER}", 3, "", "", false, "integer", "") . getBadgerTranslation2('statistics2', 'valutaDateAgoFilterDaysAgo');
$filters['amount'] = getBadgerTranslation2('statistics2', 'amountFilter') . $widgets->createSelectField("amountOperator{$FILTER_ID_MARKER}", $dataGridFilterArray, "", "", false, "style='width: 95px;'") . ' ' . $widgets->createField("amount{$FILTER_ID_MARKER}", 3, "", "", false, "integer", "");
$filters['outsideCapital'] = getBadgerTranslation2('statistics2', 'outsideCapitalFilter') . $widgets->createField("outsideCapital{$FILTER_ID_MARKER}", null, '1', '', false, 'radio') . $widgets->createLabel("outsideCapital{$FILTER_ID_MARKER}", getBadgerTranslation2('statistics2', 'outsideCapitalFilterOutside')) . ' ' . $widgets->createField("outsideCapital{$FILTER_ID_MARKER}", null, '0', '', false, 'radio') . $widgets->createLabel("outsideCapital{$FILTER_ID_MARKER}", getBadgerTranslation2('statistics2', 'outsideCapitalFilterInside'));
$filters['transactionPartner'] = getBadgerTranslation2('statistics2', 'transactionPartnerFilter') . $widgets->createSelectField("transactionPartnerOperator{$FILTER_ID_MARKER}", $dataGridStringFilterArray, "", "", false, "style='width: 95px;'") . ' ' . $widgets->createField("transactionPartner{$FILTER_ID_MARKER}", 30, "", "", false, "text", "");
$filters['category'] = getBadgerTranslation2('statistics2', 'categoryFilter') . $widgets->createField("categoryOp{$FILTER_ID_MARKER}", null, 'eq', '', false, 'radio') . $widgets->createLabel("categoryOp{$FILTER_ID_MARKER}", getBadgerTranslation2('statistics2', 'categoryFilterIs')) . ' ' . $widgets->createField("categoryOp{$FILTER_ID_MARKER}", null, 'ne', '', false, 'radio') . $widgets->createLabel("categoryOp{$FILTER_ID_MARKER}", getBadgerTranslation2('statistics2', 'categoryFilterIsNot')) . ' ' . $widgets->createSelectField("categoryId{$FILTER_ID_MARKER}", getCategorySelectArray(true), "", "", false, "style='width: 210px;'");
$filters['exceptional'] = getBadgerTranslation2('statistics2', 'exceptionalFilter') . $widgets->createField("exceptional{$FILTER_ID_MARKER}", null, '1', '', false, 'radio') . $widgets->createLabel("exceptional{$FILTER_ID_MARKER}", getBadgerTranslation2('statistics2', 'exceptionalFilterExceptional')) . ' ' . $widgets->createField("exceptional{$FILTER_ID_MARKER}", null, '0', '', false, 'radio') . $widgets->createLabel("exceptional{$FILTER_ID_MARKER}", getBadgerTranslation2('statistics2', 'exceptionalFilterNotExceptional'));
$filters['periodical'] = getBadgerTranslation2('statistics2', 'periodicalFilter') . $widgets->createField("periodical{$FILTER_ID_MARKER}", null, '1', '', false, 'radio') . $widgets->createLabel("periodical{$FILTER_ID_MARKER}", getBadgerTranslation2('statistics2', 'periodicalFilterPeriodical')) . ' ' . $widgets->createField("periodical{$FILTER_ID_MARKER}", null, '0', '', false, 'radio') . $widgets->createLabel("periodical{$FILTER_ID_MARKER}", getBadgerTranslation2('statistics2', 'periodicalFilterNotPeriodical'));
$availableFilters = array('unselected' => getBadgerTranslation2('statistics2', 'availableFiltersUnselected'), 'title' => getBadgerTranslation2('statistics2', 'availableFiltersTitle'), 'description' => getBadgerTranslation2('statistics2', 'availableFiltersDescription'), 'valutaDate' => getBadgerTranslation2('statistics2', 'availableFiltersValutaDate'), 'valutaDateBetween' => getBadgerTranslation2('statistics2', 'availableFiltersValutaDateBetween'), 'valutaDateAgo' => getBadgerTranslation2('statistics2', 'availableFiltersValutaDateAgo'), 'amount' => getBadgerTranslation2('statistics2', 'availableFiltersAmount'), 'outsideCapital' => getBadgerTranslation2('statistics2', 'availableFiltersOutsideCapital'), 'transactionPartner' => getBadgerTranslation2('statistics2', 'availableFiltersTransactionPartner'), 'category' => getBadgerTranslation2('statistics2', 'availableFiltersCategory'), 'exceptional' => getBadgerTranslation2('statistics2', 'availableFiltersExceptional'), 'periodical' => getBadgerTranslation2('statistics2', 'availableFiltersPeriodical'), 'delete' => getBadgerTranslation2('statistics2', 'availableFiltersDelete'));
$dateFormat = $widgets->createField('dateFormat', null, $us->getProperty('badgerDateFormat'), null, false, 'hidden');
$content = "<div style=\"float: left;\">";
$content .= $widgets->createSelectField("filterSelect{$FILTER_ID_MARKER}", $availableFilters, "", "", false, "onchange=\"setFilterContent('{$FILTER_ID_MARKER}');\"");
$content .= "</div><div id=\"filterContent{$FILTER_ID_MARKER}\"></div>";
$filterLineEmpty = "<div id='filterLineEmpty' style='display:none;'>{$content}</div>";
$filtersEmpty = '';
foreach ($filters as $currentName => $currentFilter) {
$filtersEmpty .= "<div id='{$currentName}Empty' style='display:none;'>{$currentFilter}</div>";
}
$dataGridAccounts = $dgAccounts->writeDataGrid();
$filterCaption = getBadgerTranslation2('statistics2', 'filterCaption');
$addFilterButton = $widgets->createButton('addFilter', getBadgerTranslation2('statistics2', 'addFilterButton'), 'addFilterLineX();');
function printFrontendPlanned($AccountID, $ID)
{
global $pageTitle;
global $tpl;
global $am;
global $redirectPage;
$widgets = new WidgetEngine($tpl);
$widgets->addToolTipJS();
$widgets->addCalendarJS();
$widgets->addJSValMessages();
$widgets->addNavigationHead();
echo $tpl->getHeader($pageTitle);
echo $widgets->addToolTipLayer();
$transactionType = "planned";
if ($ID != "new") {
$acc = $am->getAccountById($AccountID);
$transaction = $acc->getPlannedTransactionById($ID);
$titleValue = $transaction->getTitle();
$descriptionValue = $transaction->getDescription();
$beginDateValue = is_null($tmp = $transaction->getBeginDate()) ? '' : $tmp->getFormatted();
$endDateValue = is_null($tmp = $transaction->getEndDate()) ? '' : $tmp->getFormatted();
$amountValue = is_null($tmp = $transaction->getAmount()) ? '' : $tmp->getFormatted();
$outsideCapitalValue = is_null($tmp = $transaction->getOutsideCapital()) ? '' : $tmp;
$transactionPartnerValue = $transaction->getTransactionPartner();
$categoryValue = is_null($tmp = $transaction->getCategory()) ? '' : $tmp->getId();
$repeatUnitValue = $transaction->getRepeatUnit();
$repeatFrequencyValue = $transaction->getRepeatFrequency();
} else {
//new: empty values
$titleValue = "";
$descriptionValue = "";
$beginDateValue = "";
$endDateValue = "";
$amountValue = "";
$outsideCapitalValue = "";
$transactionPartnerValue = "";
$categoryValue = "";
$repeatUnitValue = "";
$repeatFrequencyValue = "1";
}
//set vars with values
$FormAction = $_SERVER['PHP_SELF'];
if ($AccountID == "choose") {
$AccountLabel = $widgets->createLabel("hiddenAccID", getBadgerTranslation2('accountTransaction', 'Account'), true);
$hiddenAccID = $widgets->createSelectField("hiddenAccID", getAccountsSelectArray(), $AccountID, "", false, "style='width: 213px;'");
} else {
$AccountLabel = "";
$hiddenAccID = $widgets->createField("hiddenAccID", 20, $AccountID, "", false, "hidden");
}
$hiddenID = $widgets->createField("hiddenID", 20, $ID, "", false, "hidden");
$hiddenType = $widgets->createField("hiddenType", 20, $transactionType, "", false, "hidden");
//Fields & Labels
$titleLabel = $widgets->createLabel("title", getBadgerTranslation2('accountTransaction', 'title'), true);
$titleField = $widgets->createField("title", 30, $titleValue, "", true, "text", "");
$descriptionLabel = $widgets->createLabel("description", getBadgerTranslation2('accountTransaction', 'description'), false);
$descriptionField = $widgets->createField("description", 30, $descriptionValue, "", false, "text", "");
$beginDateLabel = $widgets->createLabel("beginDate", getBadgerTranslation2('accountTransaction', 'beginDate'), true);
$beginDateField = $widgets->addDateField("beginDate", $beginDateValue);
$endDateLabel = $widgets->createLabel("endDate", getBadgerTranslation2('accountTransaction', 'endDate'), true);
$endDateField = $widgets->addDateField("endDate", $endDateValue);
$amountLabel = $widgets->createLabel("amount", getBadgerTranslation2('accountTransaction', 'amount'), true);
$amountField = $widgets->createField("amount", 30, $amountValue, "", true, "text", "");
$transactionPartnerLabel = $widgets->createLabel("transactionPartner", getBadgerTranslation2('accountTransaction', 'transactionPartner'), false);
$transactionPartnerField = $widgets->createField("transactionPartner", 30, $transactionPartnerValue, "", false, "text", "");
$outsideCapitalLabel = $widgets->createLabel("outsideCapital", getBadgerTranslation2('accountTransaction', 'outsideCapital'), false);
$outsideCapitalField = $widgets->createField("outsideCapital", 30, "on", "", false, "checkbox", $outsideCapitalValue);
$categoryLabel = $widgets->createLabel("category", getBadgerTranslation2('accountTransaction', 'category'), false);
$categoryField = $widgets->createSelectField("category", getCategorySelectArray(), $categoryValue, "", false, "style='width: 213px;'");
$repeatUnitLabel = $widgets->createLabel("repeatUnit", getBadgerTranslation2('accountTransaction', 'repeatFrequency'), true);
$repeatUnitField = $widgets->createSelectField("repeatUnit", getIntervalUnitsArray(), $repeatUnitValue, "", true, "style='width: 104px;'");
$everyLabel = getBadgerTranslation2('intervalUnits', 'every');
$repeatFrequencyField = $widgets->createField("repeatFrequency", 1, $repeatFrequencyValue, "", true, "text", "");
//Buttons
$submitBtn = $widgets->createButton("submitBtn", getBadgerTranslation2('dataGrid', 'save'), "submit", "Widgets/accept.gif", "accesskey='s'");
if ($redirectPage) {
$backBtn = $widgets->createButton("backBtn", getBadgerTranslation2('dataGrid', 'back'), "location.href='{$redirectPage}';return false;", "Widgets/back.gif");
} else {
$backBtn = "";
}
//add vars to template, print site
$pageHeading = getBadgerTranslation2('accountTransaction', 'headingTransactionPlanned');
eval("echo \"" . $tpl->getTemplate("Account/PlannedTransaction") . "\";");
}
$HeadAmountToolTip = $widgets->addToolTip(getBadgerTranslation2("importCsv", "amountToolTip"));
$tableHeadTransactionPartner = $widgets->createLabel("", getBadgerTranslation2("importCsv", "transactionPartner"), true);
$HeadTransactionPartnerToolTip = $widgets->addToolTip(getBadgerTranslation2("importCsv", "transactionPartnerToolTip"));
$tableHeadDescription = $widgets->createLabel("", getBadgerTranslation2("importCsv", "description"), true);
$HeadDescriptionToolTip = $widgets->addToolTip(getBadgerTranslation2("importCsv", "descriptionToolTip"));
$tableHeadPeriodical = $widgets->createLabel("", getBadgerTranslation2("importCsv", "periodical"), true);
$HeadPeriodicalToolTip = $widgets->addToolTip(getBadgerTranslation2("importCsv", "periodicalToolTip"));
$tableHeadExceptional = $widgets->createLabel("", getBadgerTranslation2("importCsv", "Exceptional"), true);
$HeadExceptionalToolTip = $widgets->addToolTip(getBadgerTranslation2("importCsv", "ExceptionalToolTip"));
$tableHeadOutside = $widgets->createLabel("", getBadgerTranslation2("importCsv", "outsideCapital"), true);
$HeadOutsideToolTip = $widgets->addToolTip(getBadgerTranslation2("importCsv", "outsideCapitalToolTip"));
$tableHeadAccount = $widgets->createLabel("", getBadgerTranslation2("importCsv", "account"), true);
$HeadAccountToolTip = $widgets->addToolTip(getBadgerTranslation2("importCsv", "accountToolTip"));
for ($outputTransactionNumber = 0; $outputTransactionNumber < $transactionNumber; $outputTransactionNumber++) {
$tableSelectCheckbox = "<input type=\"checkbox\" name=\"select" . $outputTransactionNumber . "\" value=\"select\" checked=\"checked\" />";
$tableSelectCategory = $widgets->createSelectField("categorySelect" . $outputTransactionNumber, getCategorySelectArray(), "");
$tableValutaDate = $widgets->addDateField("valutaDate" . $outputTransactionNumber, $importedTransactions[$outputTransactionNumber]["valutaDate"]->getFormatted());
$tableTitle = $widgets->createField("title" . $outputTransactionNumber, 30, $importedTransactions[$outputTransactionNumber]["title"]);
$tableAmount = $widgets->createField("amount" . $outputTransactionNumber, 8, $importedTransactions[$outputTransactionNumber]["amount"]->getFormatted());
$tableTransactionPartner = $widgets->createField("transactionPartner" . $outputTransactionNumber, 15, $importedTransactions[$outputTransactionNumber]["transactionPartner"]);
$tableDescription = $widgets->createField("description" . $outputTransactionNumber, 12, $importedTransactions[$outputTransactionNumber]["description"]);
$tablePeriodicalCheckbox = "<input type=\"checkbox\" name=\"periodical" . $outputTransactionNumber . "\" value=\"select\" />";
$tableExceptionalCheckbox = "<input type=\"checkbox\" name=\"exceptional" . $outputTransactionNumber . "\" value=\"select\" />";
$tableOutsideCheckbox = "<input type=\"checkbox\" name=\"outside" . $outputTransactionNumber . "\" value=\"select\" />";
//get accounts
$am1 = new AccountManager($badgerDb);
$account1 = array();
while ($currentAccount = $am1->getNextAccount()) {
$account1[$currentAccount->getId()] = $currentAccount->getTitle();
}
//get selected account
