$dataGrid->sourceXML = BADGER_ROOT . "/core/XML/getDataGridXML.php?q=Account&qp={$accountID}"; $dataGrid->headerName = array(getBadgerTranslation2('accountOverview', 'colValutaDate'), getBadgerTranslation2('accountOverview', 'colTitle'), getBadgerTranslation2('accountOverview', 'colType'), getBadgerTranslation2('accountOverview', 'colAmount'), getBadgerTranslation2('accountOverview', 'colBalance'), getBadgerTranslation2('accountOverview', 'colCategoryTitle')); $dataGrid->columnOrder = array("valutaDate", "title", "type", "amount", "balance", "concatCategoryTitle"); $dataGrid->height = "350px"; $dataGrid->headerSize = array(90, 350, 39, 80, 120, 200); $dataGrid->cellAlign = array("left", "left", "center", "right", "right", "left"); $dataGrid->deleteRefreshType = "refreshDataGrid"; $dataGrid->deleteAction = "Transaction.php?action=delete&accountID={$accountID}&ID="; $dataGrid->editAction = "Transaction.php?action=edit&accountID={$accountID}&ID="; $dataGrid->newAction = "Transaction.php?action=new&accountID={$accountID}"; $dataGrid->initDataGridJS(); $widgets->addNavigationHead(); echo $tpl->getHeader($pageTitle); // 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");
$dgResult->sourceXML = ''; //BADGER_ROOT . '/core/XML/getDataGridXML.php?q=MultipleAccounts&qp=1'; $dgResult->headerName = array(getBadgerTranslation2('statistics2', 'colAccountName'), getBadgerTranslation2('accountOverview', 'colValutaDate'), getBadgerTranslation2('accountOverview', 'colTitle'), getBadgerTranslation2('accountOverview', 'colAmount'), getBadgerTranslation2('accountOverview', 'colCategoryTitle')); $dgResult->columnOrder = array('accountTitle', 'valutaDate', 'title', 'amount', 'concatCategoryTitle'); $dgResult->height = "350px"; $dgResult->headerSize = array(200, 90, 350, 80, 200); $dgResult->cellAlign = array('left', 'left', 'left', 'right', 'left'); $dgResult->deleteRefreshType = 'refreshDataGrid'; $dgResult->discardSelectedRows = true; $dgResult->initDataGridJS(); $widgets->addNavigationHead(); $pageTitle = getBadgerTranslation2('statistics2', 'pageTitle'); $tpl->addOnLoadEvent('loadPageSettingNamesList(); loadPageSetting(true);'); echo $tpl->getHeader($pageTitle); $widgets->addToolTipLayer(); $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;'");