From 4435da6cd3afb09be1c1567ef76f2cfdf992bb99 Mon Sep 17 00:00:00 2001 From: Kilian Saffran Date: Thu, 11 Jul 2024 08:39:11 +0200 Subject: [PATCH] v240711 --- public_html/changelog.txt | 9 + public_html/css/theme.css | 10 +- public_html/css/theme.min.css | 2 +- public_html/lib/App/Cotisations.php | 85 +- public_html/lib/App/Sepa.php | 14 +- public_html/scripts/exportsepaxml.php | 125 +- public_html/tmpl/dialogs/dlg_cotisation.php | 16 +- .../tmpl/dialogs/dlg_nextsepaexport.php | 42 + public_html/tmpl/js/app/bankaccounts.min.js | 2 +- public_html/tmpl/js/app/banks.min.js | 2 +- public_html/tmpl/js/app/comitees.min.js | 2 +- public_html/tmpl/js/app/countries.min.js | 2 +- public_html/tmpl/js/app/dataform.min.js | 2 +- public_html/tmpl/js/app/employers.min.js | 2 +- public_html/tmpl/js/app/help.min.js | 2 +- public_html/tmpl/js/app/index.min.js | 2 +- public_html/tmpl/js/app/invoicing.min.js | 2 +- public_html/tmpl/js/app/quotatypes.min.js | 2 +- public_html/tmpl/js/app/releasetypes.min.js | 2 +- public_html/tmpl/js/app/roles.min.js | 2 +- public_html/tmpl/js/app/sections.min.js | 2 +- public_html/tmpl/js/app/sectors.min.js | 2 +- public_html/tmpl/js/app/sepacodes.min.js | 2 +- public_html/tmpl/js/app/sepagroups.min.js | 2 +- public_html/tmpl/js/app/users.min.js | 2 +- public_html/tmpl/js/app/zipcodes.min.js | 2 +- public_html/tmpl/js/common/dataform.js | 2 +- public_html/tmpl/js/pages/bankaccounts.js | 16 +- public_html/tmpl/js/pages/banks.js | 4 +- public_html/tmpl/js/pages/comitees.js | 4 +- public_html/tmpl/js/pages/countries.js | 4 +- public_html/tmpl/js/pages/employers.js | 4 +- public_html/tmpl/js/pages/help.js | 4 +- public_html/tmpl/js/pages/index.js | 23 +- public_html/tmpl/js/pages/invoicing.js | 236 +- public_html/tmpl/js/pages/quotatypes.js | 4 +- public_html/tmpl/js/pages/releasetypes.js | 4 +- public_html/tmpl/js/pages/roles.js | 4 +- public_html/tmpl/js/pages/sections.js | 4 +- public_html/tmpl/js/pages/sectors.js | 4 +- public_html/tmpl/js/pages/sepacodes.js | 4 +- public_html/tmpl/js/pages/sepagroups.js | 4 +- public_html/tmpl/js/pages/users.js | 4 +- public_html/tmpl/js/pages/zipcodes.js | 4 +- public_html/tmpl/pages/invoicing.php | 13 +- .../vendor/tabulator/css/tabulator.css | 138 +- .../vendor/tabulator/css/tabulator.css.map | 2 +- .../vendor/tabulator/css/tabulator.min.css | 2 +- .../tabulator/css/tabulator.min.css.map | 2 +- .../tabulator/css/tabulator_bootstrap3.css | 148 +- .../css/tabulator_bootstrap3.css.map | 2 +- .../css/tabulator_bootstrap3.min.css | 2 +- .../css/tabulator_bootstrap3.min.css.map | 2 +- .../tabulator/css/tabulator_bootstrap4.css | 154 +- .../css/tabulator_bootstrap4.css.map | 2 +- .../css/tabulator_bootstrap4.min.css | 2 +- .../css/tabulator_bootstrap4.min.css.map | 2 +- .../tabulator/css/tabulator_bootstrap5.css | 154 +- .../css/tabulator_bootstrap5.css.map | 2 +- .../css/tabulator_bootstrap5.min.css | 2 +- .../css/tabulator_bootstrap5.min.css.map | 2 +- .../vendor/tabulator/css/tabulator_bulma.css | 160 +- .../tabulator/css/tabulator_bulma.css.map | 2 +- .../tabulator/css/tabulator_bulma.min.css | 2 +- .../tabulator/css/tabulator_bulma.min.css.map | 2 +- .../tabulator/css/tabulator_materialize.css | 153 +- .../css/tabulator_materialize.css.map | 2 +- .../css/tabulator_materialize.min.css | 2 +- .../css/tabulator_materialize.min.css.map | 2 +- .../tabulator/css/tabulator_midnight.css | 148 +- .../tabulator/css/tabulator_midnight.css.map | 2 +- .../tabulator/css/tabulator_midnight.min.css | 2 +- .../css/tabulator_midnight.min.css.map | 2 +- .../vendor/tabulator/css/tabulator_modern.css | 158 +- .../tabulator/css/tabulator_modern.css.map | 2 +- .../tabulator/css/tabulator_modern.min.css | 2 +- .../css/tabulator_modern.min.css.map | 2 +- .../tabulator/css/tabulator_semanticui.css | 150 +- .../css/tabulator_semanticui.css.map | 2 +- .../css/tabulator_semanticui.min.css | 2 +- .../css/tabulator_semanticui.min.css.map | 2 +- .../vendor/tabulator/css/tabulator_simple.css | 151 +- .../tabulator/css/tabulator_simple.css.map | 2 +- .../tabulator/css/tabulator_simple.min.css | 2 +- .../css/tabulator_simple.min.css.map | 2 +- .../vendor/tabulator/css/tabulator_site.css | 165 +- .../tabulator/css/tabulator_site.css.map | 2 +- .../tabulator/css/tabulator_site.min.css | 2 +- .../tabulator/css/tabulator_site.min.css.map | 2 +- public_html/vendor/tabulator/js/tabulator.js | 6180 +++- .../vendor/tabulator/js/tabulator.js.map | 2 +- .../vendor/tabulator/js/tabulator.min.js | 4 +- .../vendor/tabulator/js/tabulator.min.js.map | 2 +- .../vendor/tabulator/js/tabulator_esm.js | 6122 +++- .../vendor/tabulator/js/tabulator_esm.js.map | 2 +- .../vendor/tabulator/js/tabulator_esm.min.js | 4 +- .../tabulator/js/tabulator_esm.min.js.map | 2 +- tmp/tabulator-5.6.1.zip | Bin 0 -> 2230122 bytes tmp/tabulator-5.6.1/.babelrc.json | 3 + tmp/tabulator-5.6.1/.editorconfig | 6 + tmp/tabulator-5.6.1/.eslintignore | 3 + tmp/tabulator-5.6.1/.eslintrc.js | 28 + .../.github/ISSUE_TEMPLATE/bug_report.md | 58 + .../.github/ISSUE_TEMPLATE/documentation.md | 14 + .../.github/ISSUE_TEMPLATE/feature_request.md | 24 + .../.github/ISSUE_TEMPLATE/question.md | 12 + .../.github/workflows/bad-files-check.yml | 39 + .../.github/workflows/lint-and-test.yml | 31 + tmp/tabulator-5.6.1/.gitignore | 6 + tmp/tabulator-5.6.1/CODE_OF_CONDUCT.md | 46 + tmp/tabulator-5.6.1/CONTRIBUTING.md | 22 + tmp/tabulator-5.6.1/LICENSE | 21 + tmp/tabulator-5.6.1/README.md | 76 + tmp/tabulator-5.6.1/bower.json | 40 + tmp/tabulator-5.6.1/build/Bundler.js | 190 + tmp/tabulator-5.6.1/build/rollup.js | 6 + tmp/tabulator-5.6.1/dist/css/tabulator.css | 1277 + .../dist/css/tabulator.css.map | 1 + .../dist/css/tabulator.min.css | 2 + .../dist/css/tabulator.min.css.map | 1 + .../dist/css/tabulator_bootstrap3.css | 1480 + .../dist/css/tabulator_bootstrap3.css.map | 1 + .../dist/css/tabulator_bootstrap3.min.css | 2 + .../dist/css/tabulator_bootstrap3.min.css.map | 1 + .../dist/css/tabulator_bootstrap4.css | 1744 + .../dist/css/tabulator_bootstrap4.css.map | 1 + .../dist/css/tabulator_bootstrap4.min.css | 2 + .../dist/css/tabulator_bootstrap4.min.css.map | 1 + .../dist/css/tabulator_bootstrap5.css | 1771 + .../dist/css/tabulator_bootstrap5.css.map | 1 + .../dist/css/tabulator_bootstrap5.min.css | 2 + .../dist/css/tabulator_bootstrap5.min.css.map | 1 + .../dist/css/tabulator_bulma.css | 1444 + .../dist/css/tabulator_bulma.css.map | 1 + .../dist/css/tabulator_bulma.min.css | 2 + .../dist/css/tabulator_bulma.min.css.map | 1 + .../dist/css/tabulator_materialize.css | 1482 + .../dist/css/tabulator_materialize.css.map | 1 + .../dist/css/tabulator_materialize.min.css | 2 + .../css/tabulator_materialize.min.css.map | 1 + .../dist/css/tabulator_midnight.css | 1375 + .../dist/css/tabulator_midnight.css.map | 1 + .../dist/css/tabulator_midnight.min.css | 2 + .../dist/css/tabulator_midnight.min.css.map | 1 + .../dist/css/tabulator_modern.css | 1430 + .../dist/css/tabulator_modern.css.map | 1 + .../dist/css/tabulator_modern.min.css | 2 + .../dist/css/tabulator_modern.min.css.map | 1 + .../dist/css/tabulator_semanticui.css | 2102 ++ .../dist/css/tabulator_semanticui.css.map | 1 + .../dist/css/tabulator_semanticui.min.css | 2 + .../dist/css/tabulator_semanticui.min.css.map | 1 + .../dist/css/tabulator_simple.css | 1321 + .../dist/css/tabulator_simple.css.map | 1 + .../dist/css/tabulator_simple.min.css | 2 + .../dist/css/tabulator_simple.min.css.map | 1 + .../dist/css/tabulator_site.css | 1406 + .../dist/css/tabulator_site.css.map | 1 + .../dist/css/tabulator_site.min.css | 2 + .../dist/css/tabulator_site.min.css.map | 1 + tmp/tabulator-5.6.1/dist/js/jquery_wrapper.js | 63 + tmp/tabulator-5.6.1/dist/js/tabulator.js | 28005 +++++++++++++++ tmp/tabulator-5.6.1/dist/js/tabulator.js.map | 1 + tmp/tabulator-5.6.1/dist/js/tabulator.min.js | 3 + .../dist/js/tabulator.min.js.map | 1 + tmp/tabulator-5.6.1/dist/js/tabulator_esm.js | 28045 ++++++++++++++++ .../dist/js/tabulator_esm.js.map | 1 + .../dist/js/tabulator_esm.min.js | 3 + .../dist/js/tabulator_esm.min.js.map | 1 + tmp/tabulator-5.6.1/package-lock.json | 5225 +++ tmp/tabulator-5.6.1/package.json | 65 + tmp/tabulator-5.6.1/src/js/builds/esm.js | 14 + .../src/js/builds/jquery_wrapper.js | 63 + tmp/tabulator-5.6.1/src/js/builds/usd.js | 1 + .../src/js/core/ColumnManager.js | 750 + .../src/js/core/CoreFeature.js | 139 + .../src/js/core/FooterManager.js | 102 + tmp/tabulator-5.6.1/src/js/core/Module.js | 142 + tmp/tabulator-5.6.1/src/js/core/RowManager.js | 1135 + tmp/tabulator-5.6.1/src/js/core/Tabulator.js | 896 + .../src/js/core/TabulatorFull.js | 11 + tmp/tabulator-5.6.1/src/js/core/cell/Cell.js | 295 + .../src/js/core/cell/CellComponent.js | 79 + .../src/js/core/column/Column.js | 959 + .../src/js/core/column/ColumnComponent.js | 153 + .../src/js/core/column/defaults/options.js | 18 + .../src/js/core/defaults/options.js | 65 + .../src/js/core/modules/core.js | 3 + .../src/js/core/modules/optional.js | 36 + .../src/js/core/rendering/Renderer.js | 204 + .../rendering/renderers/BasicHorizontal.js | 27 + .../core/rendering/renderers/BasicVertical.js | 103 + .../renderers/VirtualDomHorizontal.js | 583 + .../rendering/renderers/VirtualDomVertical.js | 637 + .../src/js/core/row/PseudoRow.js | 47 + tmp/tabulator-5.6.1/src/js/core/row/Row.js | 463 + .../src/js/core/row/RowComponent.js | 94 + .../src/js/core/tools/Alert.js | 66 + .../js/core/tools/ComponentFunctionBinder.js | 32 + .../src/js/core/tools/DataLoader.js | 128 + .../src/js/core/tools/DeprecationAdvisor.js | 51 + .../src/js/core/tools/ExternalEventBus.js | 105 + .../src/js/core/tools/Helpers.js | 66 + .../src/js/core/tools/InteractionMonitor.js | 322 + .../src/js/core/tools/InternalEventBus.js | 162 + .../src/js/core/tools/ModuleBinder.js | 105 + .../src/js/core/tools/OptionsList.js | 45 + .../src/js/core/tools/Popup.js | 305 + .../src/js/core/tools/TableRegistry.js | 62 + .../src/js/modules/Accessor/Accessor.js | 116 + .../js/modules/Accessor/defaults/accessors.js | 1 + .../src/js/modules/Ajax/Ajax.js | 144 + .../src/js/modules/Ajax/defaults/config.js | 3 + .../Ajax/defaults/contentTypeFormatters.js | 45 + .../js/modules/Ajax/defaults/loaderPromise.js | 87 + .../js/modules/Ajax/defaults/urlGenerator.js | 44 + .../src/js/modules/Clipboard/Clipboard.js | 282 + .../Clipboard/defaults/pasteActions.js | 54 + .../Clipboard/defaults/pasteParsers.js | 130 + .../js/modules/ColumnCalcs/CalcComponent.js | 48 + .../src/js/modules/ColumnCalcs/ColumnCalcs.js | 588 + .../ColumnCalcs/defaults/calculations.js | 93 + .../src/js/modules/Comms/Comms.js | 52 + .../src/js/modules/DataTree/DataTree.js | 607 + .../src/js/modules/Download/Download.js | 149 + .../modules/Download/defaults/downloaders.js | 15 + .../Download/defaults/downloaders/csv.js | 61 + .../Download/defaults/downloaders/html.js | 5 + .../Download/defaults/downloaders/json.js | 34 + .../defaults/downloaders/jsonLines.js | 32 + .../Download/defaults/downloaders/pdf.js | 111 + .../Download/defaults/downloaders/xlsx.js | 102 + .../src/js/modules/Edit/Edit.js | 783 + .../src/js/modules/Edit/List.js | 1048 + .../src/js/modules/Edit/defaults/editors.js | 29 + .../Edit/defaults/editors/autocomplete.js | 12 + .../js/modules/Edit/defaults/editors/date.js | 138 + .../modules/Edit/defaults/editors/datetime.js | 125 + .../js/modules/Edit/defaults/editors/input.js | 77 + .../js/modules/Edit/defaults/editors/list.js | 7 + .../modules/Edit/defaults/editors/number.js | 110 + .../modules/Edit/defaults/editors/progress.js | 127 + .../js/modules/Edit/defaults/editors/range.js | 81 + .../modules/Edit/defaults/editors/select.js | 10 + .../js/modules/Edit/defaults/editors/star.js | 146 + .../modules/Edit/defaults/editors/textarea.js | 123 + .../Edit/defaults/editors/tickCross.js | 95 + .../js/modules/Edit/defaults/editors/time.js | 128 + .../src/js/modules/Edit/inputMask.js | 74 + .../src/js/modules/Export/Export.js | 646 + .../src/js/modules/Export/ExportColumn.js | 11 + .../src/js/modules/Export/ExportRow.js | 10 + .../src/js/modules/Filter/Filter.js | 904 + .../src/js/modules/Filter/defaults/filters.js | 108 + .../src/js/modules/Format/Format.js | 216 + .../js/modules/Format/defaults/formatters.js | 43 + .../Format/defaults/formatters/buttonCross.js | 3 + .../Format/defaults/formatters/buttonTick.js | 3 + .../Format/defaults/formatters/color.js | 4 + .../Format/defaults/formatters/datetime.js | 37 + .../defaults/formatters/datetimediff.js | 41 + .../Format/defaults/formatters/handle.js | 4 + .../Format/defaults/formatters/html.js | 3 + .../Format/defaults/formatters/image.js | 40 + .../Format/defaults/formatters/link.js | 82 + .../Format/defaults/formatters/lookup.js | 10 + .../Format/defaults/formatters/money.js | 44 + .../Format/defaults/formatters/plaintext.js | 3 + .../Format/defaults/formatters/progress.js | 133 + .../defaults/formatters/responsiveCollapse.js | 44 + .../defaults/formatters/rowSelection.js | 60 + .../Format/defaults/formatters/rownum.js | 14 + .../Format/defaults/formatters/star.js | 38 + .../Format/defaults/formatters/textarea.js | 4 + .../Format/defaults/formatters/tickCross.js | 22 + .../Format/defaults/formatters/traffic.js | 47 + .../js/modules/FrozenColumns/FrozenColumns.js | 300 + .../src/js/modules/FrozenRows/FrozenRows.js | 175 + .../src/js/modules/GroupRows/Group.js | 615 + .../js/modules/GroupRows/GroupComponent.js | 71 + .../src/js/modules/GroupRows/GroupRows.js | 640 + .../src/js/modules/History/History.js | 172 + .../js/modules/History/defaults/redoers.js | 31 + .../js/modules/History/defaults/undoers.js | 33 + .../HtmlTableImport/HtmlTableImport.js | 182 + .../src/js/modules/Import/Import.js | 194 + .../js/modules/Import/defaults/importers.js | 9 + .../Import/defaults/importers/array.js | 5 + .../modules/Import/defaults/importers/csv.js | 63 + .../modules/Import/defaults/importers/json.js | 8 + .../src/js/modules/Interaction/Interaction.js | 337 + .../src/js/modules/Keybindings/Keybindings.js | 173 + .../modules/Keybindings/defaults/actions.js | 156 + .../modules/Keybindings/defaults/bindings.js | 28 + .../src/js/modules/Layout/Layout.js | 60 + .../src/js/modules/Layout/defaults/modes.js | 12 + .../Layout/defaults/modes/fitColumns.js | 171 + .../modules/Layout/defaults/modes/fitData.js | 10 + .../Layout/defaults/modes/fitDataGeneral.js | 10 + .../Layout/defaults/modes/fitDataStretch.js | 40 + .../src/js/modules/Localize/Localize.js | 186 + .../src/js/modules/Localize/defaults/langs.js | 37 + .../src/js/modules/Menu/Menu.js | 304 + .../src/js/modules/MoveColumns/MoveColumns.js | 304 + .../src/js/modules/MoveRows/MoveRows.js | 636 + .../src/js/modules/Mutator/Mutator.js | 162 + .../js/modules/Mutator/defaults/mutators.js | 1 + .../src/js/modules/Page/Page.js | 881 + .../js/modules/Page/defaults/pageCounters.js | 8 + .../Page/defaults/pageCounters/pages.js | 33 + .../Page/defaults/pageCounters/rows.js | 40 + .../src/js/modules/Persistence/Persistence.js | 475 + .../modules/Persistence/defaults/readers.js | 29 + .../modules/Persistence/defaults/writers.js | 13 + .../src/js/modules/Popup/Popup.js | 231 + .../src/js/modules/Print/Print.js | 138 + .../js/modules/ReactiveData/ReactiveData.js | 408 + .../js/modules/ResizeColumns/ResizeColumns.js | 311 + .../src/js/modules/ResizeRows/ResizeRows.js | 112 + .../src/js/modules/ResizeTable/ResizeTable.js | 160 + .../ResponsiveLayout/ResponsiveLayout.js | 348 + .../src/js/modules/SelectRange/Range.js | 354 + .../js/modules/SelectRange/RangeComponent.js | 93 + .../src/js/modules/SelectRange/SelectRange.js | 870 + .../src/js/modules/SelectRow/SelectRow.js | 495 + .../src/js/modules/Sort/Sort.js | 477 + .../src/js/modules/Sort/defaults/sorters.js | 21 + .../modules/Sort/defaults/sorters/alphanum.js | 44 + .../js/modules/Sort/defaults/sorters/array.js | 54 + .../modules/Sort/defaults/sorters/boolean.js | 7 + .../js/modules/Sort/defaults/sorters/date.js | 10 + .../modules/Sort/defaults/sorters/datetime.js | 44 + .../modules/Sort/defaults/sorters/exists.js | 7 + .../modules/Sort/defaults/sorters/number.js | 40 + .../modules/Sort/defaults/sorters/string.js | 34 + .../js/modules/Sort/defaults/sorters/time.js | 10 + .../src/js/modules/Tooltip/Tooltip.js | 130 + .../src/js/modules/Validate/Validate.js | 305 + .../modules/Validate/defaults/validators.js | 150 + tmp/tabulator-5.6.1/src/scss/tabulator.scss | 1583 + .../src/scss/themes/bootstrap/functions4.scss | 118 + .../src/scss/themes/bootstrap/functions5.scss | 302 + .../bootstrap/tabulator_bootstrap3.scss | 288 + .../bootstrap/tabulator_bootstrap4.scss | 553 + .../bootstrap/tabulator_bootstrap5.scss | 585 + .../src/scss/themes/bootstrap/variables3.scss | 870 + .../src/scss/themes/bootstrap/variables4.scss | 930 + .../src/scss/themes/bootstrap/variables5.scss | 1641 + .../scss/themes/bulma/tabulator_bulma.scss | 266 + .../src/scss/themes/bulma/variables.scss | 198 + .../materialize/tabulator_materialize.scss | 275 + .../scss/themes/materialize/variables.scss | 70 + .../semanticui/tabulator_semanticui.scss | 587 + .../src/scss/themes/semanticui/variables.scss | 839 + .../themes/semanticui/variables_table.scss | 247 + .../src/scss/themes/tabulator_midnight.scss | 175 + .../src/scss/themes/tabulator_modern.scss | 248 + .../src/scss/themes/tabulator_simple.scss | 102 + .../src/scss/themes/tabulator_site.scss | 204 + tmp/tabulator-6.0.1.zip | Bin 0 -> 2622919 bytes tmp/tabulator-6.2.1.zip | Bin 0 -> 2670397 bytes 361 files changed, 128445 insertions(+), 3713 deletions(-) create mode 100644 public_html/tmpl/dialogs/dlg_nextsepaexport.php create mode 100644 tmp/tabulator-5.6.1.zip create mode 100644 tmp/tabulator-5.6.1/.babelrc.json create mode 100644 tmp/tabulator-5.6.1/.editorconfig create mode 100644 tmp/tabulator-5.6.1/.eslintignore create mode 100644 tmp/tabulator-5.6.1/.eslintrc.js create mode 100644 tmp/tabulator-5.6.1/.github/ISSUE_TEMPLATE/bug_report.md create mode 100644 tmp/tabulator-5.6.1/.github/ISSUE_TEMPLATE/documentation.md create mode 100644 tmp/tabulator-5.6.1/.github/ISSUE_TEMPLATE/feature_request.md create mode 100644 tmp/tabulator-5.6.1/.github/ISSUE_TEMPLATE/question.md create mode 100644 tmp/tabulator-5.6.1/.github/workflows/bad-files-check.yml create mode 100644 tmp/tabulator-5.6.1/.github/workflows/lint-and-test.yml create mode 100644 tmp/tabulator-5.6.1/.gitignore create mode 100644 tmp/tabulator-5.6.1/CODE_OF_CONDUCT.md create mode 100644 tmp/tabulator-5.6.1/CONTRIBUTING.md create mode 100644 tmp/tabulator-5.6.1/LICENSE create mode 100644 tmp/tabulator-5.6.1/README.md create mode 100644 tmp/tabulator-5.6.1/bower.json create mode 100644 tmp/tabulator-5.6.1/build/Bundler.js create mode 100644 tmp/tabulator-5.6.1/build/rollup.js create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap3.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap3.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap3.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap3.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap4.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap4.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap4.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap4.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap5.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap5.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap5.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bootstrap5.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bulma.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bulma.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bulma.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_bulma.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_materialize.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_materialize.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_materialize.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_materialize.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_midnight.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_midnight.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_midnight.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_midnight.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_modern.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_modern.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_modern.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_modern.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_semanticui.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_semanticui.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_semanticui.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_semanticui.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_simple.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_simple.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_simple.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_simple.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_site.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_site.css.map create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_site.min.css create mode 100644 tmp/tabulator-5.6.1/dist/css/tabulator_site.min.css.map create mode 100644 tmp/tabulator-5.6.1/dist/js/jquery_wrapper.js create mode 100644 tmp/tabulator-5.6.1/dist/js/tabulator.js create mode 100644 tmp/tabulator-5.6.1/dist/js/tabulator.js.map create mode 100644 tmp/tabulator-5.6.1/dist/js/tabulator.min.js create mode 100644 tmp/tabulator-5.6.1/dist/js/tabulator.min.js.map create mode 100644 tmp/tabulator-5.6.1/dist/js/tabulator_esm.js create mode 100644 tmp/tabulator-5.6.1/dist/js/tabulator_esm.js.map create mode 100644 tmp/tabulator-5.6.1/dist/js/tabulator_esm.min.js create mode 100644 tmp/tabulator-5.6.1/dist/js/tabulator_esm.min.js.map create mode 100644 tmp/tabulator-5.6.1/package-lock.json create mode 100644 tmp/tabulator-5.6.1/package.json create mode 100644 tmp/tabulator-5.6.1/src/js/builds/esm.js create mode 100644 tmp/tabulator-5.6.1/src/js/builds/jquery_wrapper.js create mode 100644 tmp/tabulator-5.6.1/src/js/builds/usd.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/ColumnManager.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/CoreFeature.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/FooterManager.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/Module.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/RowManager.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/Tabulator.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/TabulatorFull.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/cell/Cell.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/cell/CellComponent.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/column/Column.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/column/ColumnComponent.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/column/defaults/options.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/defaults/options.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/modules/core.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/modules/optional.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/rendering/Renderer.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/rendering/renderers/BasicHorizontal.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/rendering/renderers/BasicVertical.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/rendering/renderers/VirtualDomHorizontal.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/rendering/renderers/VirtualDomVertical.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/row/PseudoRow.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/row/Row.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/row/RowComponent.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/Alert.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/ComponentFunctionBinder.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/DataLoader.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/DeprecationAdvisor.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/ExternalEventBus.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/Helpers.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/InteractionMonitor.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/InternalEventBus.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/ModuleBinder.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/OptionsList.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/Popup.js create mode 100644 tmp/tabulator-5.6.1/src/js/core/tools/TableRegistry.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Accessor/Accessor.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Accessor/defaults/accessors.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Ajax/Ajax.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Ajax/defaults/config.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Ajax/defaults/contentTypeFormatters.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Ajax/defaults/loaderPromise.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Ajax/defaults/urlGenerator.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Clipboard/Clipboard.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Clipboard/defaults/pasteActions.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Clipboard/defaults/pasteParsers.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/ColumnCalcs/CalcComponent.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/ColumnCalcs/ColumnCalcs.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/ColumnCalcs/defaults/calculations.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Comms/Comms.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/DataTree/DataTree.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Download/Download.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Download/defaults/downloaders.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Download/defaults/downloaders/csv.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Download/defaults/downloaders/html.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Download/defaults/downloaders/json.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Download/defaults/downloaders/jsonLines.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Download/defaults/downloaders/pdf.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Download/defaults/downloaders/xlsx.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/Edit.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/List.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/autocomplete.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/date.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/datetime.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/input.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/list.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/number.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/progress.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/range.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/select.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/star.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/textarea.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/tickCross.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/defaults/editors/time.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Edit/inputMask.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Export/Export.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Export/ExportColumn.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Export/ExportRow.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Filter/Filter.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Filter/defaults/filters.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/Format.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/buttonCross.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/buttonTick.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/color.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/datetime.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/datetimediff.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/handle.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/html.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/image.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/link.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/lookup.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/money.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/plaintext.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/progress.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/responsiveCollapse.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/rowSelection.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/rownum.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/star.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/textarea.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/tickCross.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Format/defaults/formatters/traffic.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/FrozenColumns/FrozenColumns.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/FrozenRows/FrozenRows.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/GroupRows/Group.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/GroupRows/GroupComponent.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/GroupRows/GroupRows.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/History/History.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/History/defaults/redoers.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/History/defaults/undoers.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/HtmlTableImport/HtmlTableImport.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Import/Import.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Import/defaults/importers.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Import/defaults/importers/array.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Import/defaults/importers/csv.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Import/defaults/importers/json.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Interaction/Interaction.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Keybindings/Keybindings.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Keybindings/defaults/actions.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Keybindings/defaults/bindings.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Layout/Layout.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Layout/defaults/modes.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Layout/defaults/modes/fitColumns.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Layout/defaults/modes/fitData.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Layout/defaults/modes/fitDataGeneral.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Layout/defaults/modes/fitDataStretch.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Localize/Localize.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Localize/defaults/langs.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Menu/Menu.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/MoveColumns/MoveColumns.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/MoveRows/MoveRows.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Mutator/Mutator.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Mutator/defaults/mutators.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Page/Page.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Page/defaults/pageCounters.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Page/defaults/pageCounters/pages.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Page/defaults/pageCounters/rows.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Persistence/Persistence.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Persistence/defaults/readers.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Persistence/defaults/writers.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Popup/Popup.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Print/Print.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/ReactiveData/ReactiveData.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/ResizeColumns/ResizeColumns.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/ResizeRows/ResizeRows.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/ResizeTable/ResizeTable.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/ResponsiveLayout/ResponsiveLayout.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/SelectRange/Range.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/SelectRange/RangeComponent.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/SelectRange/SelectRange.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/SelectRow/SelectRow.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/Sort.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/alphanum.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/array.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/boolean.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/date.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/datetime.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/exists.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/number.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/string.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Sort/defaults/sorters/time.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Tooltip/Tooltip.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Validate/Validate.js create mode 100644 tmp/tabulator-5.6.1/src/js/modules/Validate/defaults/validators.js create mode 100644 tmp/tabulator-5.6.1/src/scss/tabulator.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bootstrap/functions4.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bootstrap/functions5.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bootstrap/tabulator_bootstrap3.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bootstrap/tabulator_bootstrap4.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bootstrap/tabulator_bootstrap5.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bootstrap/variables3.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bootstrap/variables4.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bootstrap/variables5.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bulma/tabulator_bulma.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/bulma/variables.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/materialize/tabulator_materialize.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/materialize/variables.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/semanticui/tabulator_semanticui.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/semanticui/variables.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/semanticui/variables_table.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/tabulator_midnight.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/tabulator_modern.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/tabulator_simple.scss create mode 100644 tmp/tabulator-5.6.1/src/scss/themes/tabulator_site.scss create mode 100644 tmp/tabulator-6.0.1.zip create mode 100644 tmp/tabulator-6.2.1.zip diff --git a/public_html/changelog.txt b/public_html/changelog.txt index 5a4455a..f459700 100644 --- a/public_html/changelog.txt +++ b/public_html/changelog.txt @@ -1,5 +1,14 @@ ## Changelog +#### v0.27.2 + +- Members cotisation month update (sync. membres + ajouter mois): set status to open when amount > 0 +- sepa xml-export with editable export-table (before export) + +#### v0.25.1 + +- import/export sepa files optimissations + #### v0.24.0 - add automated check for cotisation in imported bank statements data (with name of member and id of member) diff --git a/public_html/css/theme.css b/public_html/css/theme.css index b57a940..9218376 100644 --- a/public_html/css/theme.css +++ b/public_html/css/theme.css @@ -1054,4 +1054,12 @@ form { border-bottom: 1px solid #aaa; } .tabulator .tabulator-footer .tabulator-calcs-holder .tabulator-row { background: var(--color-btn1) !important; - color: #fff !important; } \ No newline at end of file + color: #fff !important; } + + .tabulator-row .tabulator-cell.tabulator-frozen { + display: inline-block; + position: sticky; + left: 0; + background-color: var(--color-btn1); + z-index: 11; + } \ No newline at end of file diff --git a/public_html/css/theme.min.css b/public_html/css/theme.min.css index 0463f32..29f8047 100644 --- a/public_html/css/theme.min.css +++ b/public_html/css/theme.min.css @@ -1 +1 @@ -html{box-sizing:border-box}*,:after,:before{box-sizing:inherit}html{-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%}body{margin:0}body,html{-webkit-user-select:none;-ms-user-select:none;user-select:none;-moz-user-select:none}article,aside,details,figcaption,figure,footer,header,main,menu,nav,section{display:block}summary{display:list-item}audio,canvas,progress,video{display:inline-block}progress{vertical-align:baseline}audio:not([controls]){display:none;height:0}[hidden],template{display:none}a{background-color:transparent}a:active,a:hover{outline-width:0}abbr[title]{border-bottom:none;text-decoration:underline;text-decoration:underline dotted}b,strong{font-weight:bolder}dfn{font-style:italic}mark{background:#ff0;color:#000}small{font-size:80%}sub,sup{font-size:75%;line-height:0;position:relative;vertical-align:baseline}sub{bottom:-.25em}sup{top:-.5em}figure{margin:1em 40px}img{border-style:none}code,kbd,pre,samp{font-family:monospace,monospace;font-size:1em}hr{box-sizing:content-box;height:0;overflow:visible}button,input,optgroup,select,textarea{font:inherit;margin:0}optgroup{font-weight:700}button,input{overflow:visible}button,select{text-transform:none}[type=button],[type=reset],[type=submit],button{-webkit-appearance:button}[type=button]::-moz-focus-inner,[type=reset]::-moz-focus-inner,[type=submit]::-moz-focus-inner,button::-moz-focus-inner{border-style:none;padding:0}[type=button]:-moz-focusring,[type=reset]:-moz-focusring,[type=submit]:-moz-focusring,button:-moz-focusring{outline:1px dotted ButtonText}fieldset{border:1px solid silver;margin:0 2px;padding:.35em .625em .75em}legend{color:inherit;display:table;max-width:100%;padding:0;white-space:normal}textarea{overflow:auto}[type=checkbox],[type=radio]{padding:0}[type=number]::-webkit-inner-spin-button,[type=number]::-webkit-outer-spin-button{height:auto}[type=search]{-webkit-appearance:textfield;outline-offset:-2px}[type=search]::-webkit-search-decoration{-webkit-appearance:none}::-webkit-file-upload-button{-webkit-appearance:button;font:inherit}:root{--color-bg1:rgba(127,175,79,1);--color-bg2:rgba(94,162,89,1);--color-bg3:rgba(39,154,200,1);--color-btn1:rgb(52, 52, 52)}body,html{font-family:Verdana,sans-serif;font-size:10pt;line-height:1.5}html{overflow-x:hidden}h1{font-size:36px}h2{font-size:30px}h3{font-size:24px}h4{font-size:20px}h5{font-size:18px}h6{font-size:16px}.serif{font-family:serif}h1,h2,h3,h4,h5,h6{font-family:"Segoe UI",Arial,sans-serif;font-weight:400;margin:0}.wide{letter-spacing:4px}hr{border:0;border-top:1px solid #eee;margin:20px 0}.img{max-width:100%;height:auto;vertical-align:middle}a{color:inherit}.table,.table-all{border-collapse:collapse;border-spacing:0;width:100%;display:table}.table-all{border:1px solid #ccc}.bordered tr,.table-all tr{border-bottom:1px solid #ddd}.striped tbody tr:nth-child(even){background-color:#f1f1f1}.table-all tr:nth-child(odd){background-color:#fff}.table-all tr:nth-child(even){background-color:#f1f1f1}.hoverable tbody tr:hover,.ul.hoverable li:hover{background-color:#ccc}.centered tr td,.centered tr th{text-align:center}.table td,.table th,.table-all td,.table-all th{padding:3px 3px;display:table-cell;text-align:left;vertical-align:top}.table td:first-child,.table th:first-child,.table-all td:first-child,.table-all th:first-child{padding-left:16px}.btn,.button{border:none;display:inline-block;padding:4px 8px;vertical-align:middle;overflow:hidden;text-decoration:none;color:inherit;background-color:inherit;text-align:center;cursor:pointer;white-space:nowrap}.btn:hover{box-shadow:0 4px 8px 0 rgba(0,0,0,.2),0 6px 20px 0 rgba(0,0,0,.19)}.btn,.button{-webkit-touch-callout:none;-webkit-user-select:none;-khtml-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none}.btn:disabled,.button:disabled,.disabled{cursor:not-allowed;background-color:#e6e6e6}.disabled *,:disabled *{pointer-events:none}.btn.disabled:hover,.btn:disabled:hover{box-shadow:none}.badge,.tag{background-color:#000;color:#fff;display:inline-block;padding-left:8px;padding-right:8px;text-align:center}.badge{border-radius:50%}.ul{list-style-type:none;padding:0;margin:0}.ul li{padding:4px 8px;border-bottom:1px solid #ddd}.ul li:last-child{border-bottom:none}.display-container,.tooltip{position:relative}.tooltip .text{display:none}.tooltip:hover .text{display:inline-block}.ripple:active{opacity:.5}.ripple{transition:opacity 0s}.input{padding:6px;display:block;border:1px solid #ccc;width:100%;background-color:#fff}.select{padding:6px;width:100%;border:1px solid #ccc;background-color:#fff;font-size:11pt}.dropdown-click,.dropdown-hover{position:relative;display:inline-block;cursor:pointer}.dropdown-hover:hover .dropdown-content{display:block}.dropdown-click:hover,.dropdown-hover:first-child{background-color:#ccc;color:#000}.dropdown-click:hover>.button:first-child,.dropdown-hover:hover>.button:first-child{background-color:#ccc;color:#000}.dropdown-content{cursor:auto;color:#000;background-color:#fff;display:none;position:absolute;min-width:160px;margin:0;padding:0;z-index:1}.check,.radio{width:24px;height:24px;position:relative;top:6px}.sidebar{height:100%;width:160px;background-color:#fff;position:fixed!important;z-index:1;overflow:auto}.bar-block .dropdown-click,.bar-block .dropdown-hover{width:100%}.bar-block .dropdown-click .dropdown-content,.bar-block .dropdown-hover .dropdown-content{min-width:100%}.bar-block .dropdown-click .button,.bar-block .dropdown-hover .button{width:100%;text-align:left;padding:4px 8px}#main,.main{transition:margin-left .4s}.modal{z-index:3;display:none;padding-top:100px;position:fixed;left:0;top:0;width:100%;height:100%;overflow:auto;background-color:#000;background-color:rgba(0,0,0,.4)}.modal-content{margin:auto;background-color:#fff;position:relative;padding:0;outline:0;width:600px}.bar{width:100%}.center .bar{display:inline-block;width:auto}.bar .bar-item{padding:4px 8px;float:left;width:auto;border:none;display:block;outline:0}.bar .dropdown-click,.bar .dropdown-hover{position:static;float:left}.bar .button{white-space:normal}.bar-block .bar-item{width:100%;display:block;padding:4px 8px;text-align:left;border:none;white-space:normal;float:none;outline:0}.bar-block.center .bar-item{text-align:center}.block{display:block;width:100%}.responsive{display:block;overflow-x:auto}.bar:after,.bar:before,.cell-row:after,.cell-row:before,.clear:after,.clear:before,.container-left:before,.container-lefte:after,.container-none:after,.container-none:before,.container-right:after,.container-right:before,.container:after,.container:before,.datapanel:after,.datapanel:before,.row-padding:after,.row-padding:before,.row:after,.row:before{content:"";display:table;clear:both}.col,.fifth,.fourfifth,.half,.quarter,.third,.threefifth,.threequarter,.twofifth,.twothird{float:left;width:100%}.col.s1{width:8.33333%}.col.s2{width:16.66666%}.col.s3{width:24.99999%}.col.s4{width:33.33333%}.col.s5{width:41.66666%}.col.s6{width:49.99999%}.col.s7{width:58.33333%}.col.s8{width:66.66666%}.col.s9{width:74.99999%}.col.s10{width:83.33333%}.col.s11{width:91.66666%}.col.s12{width:99.99999%}@media (min-width:601px){.col.m1{width:8.33333%}.col.m2{width:16.66666%}.col.m3,.quarter{width:24.99999%}.col.m4,.third{width:33.33333%}.fifth{width:20%;min-width:100px}.col.m5{width:41.66666%}.col.m6,.half{width:49.99999%}.col.m7{width:58.33333%}.col.m8,.twothird{width:66.66666%}.col.m9,.threequarter{width:74.99999%}.col.m10{width:83.33333%}.col.m11{width:91.66666%}.col.m12{width:99.99999%}.twofifth{width:40%}.threefifth{width:60%}.fourfifth{width:80%}}@media (min-width:993px){.col.l1{width:8.33333%}.col.l2{width:16.66666%}.col.l3{width:24.99999%}.col.l4{width:33.33333%}.col.l5{width:41.66666%}.col.l6{width:49.99999%}.col.l7{width:58.33333%}.col.l8{width:66.66666%}.col.l9{width:74.99999%}.col.l10{width:83.33333%}.col.l11{width:91.66666%}.col.l12{width:99.99999%}}.rest{overflow:hidden}.stretch{margin-left:-16px;margin-right:-16px}.auto,.content{margin-left:auto;margin-right:auto}.content{max-width:980px}.auto{max-width:1140px}.cell-row{display:table;width:100%}.cell{display:table-cell;vertical-align:top}.cell-top{vertical-align:top}.cell-middle{vertical-align:middle}.cell-bottom{vertical-align:bottom}.hide{display:none!important}.show,.show-block{display:block!important}.show-inline-block{display:inline-block!important}@media (max-width:1205px){.auto{max-width:95%}}@media (max-width:600px){.modal-content{margin:0 10px;width:auto!important}.modal{padding-top:30px}.dropdown-click.mobile .dropdown-content,.dropdown-hover.mobile .dropdown-content{position:relative}.hide-small{display:none!important}.mobile{display:block;width:100%!important}.bar-item.mobile,.dropdown-click.mobile,.dropdown-hover.mobile{text-align:center}.dropdown-click.mobile,.dropdown-click.mobile .btn,.dropdown-click.mobile .button,.dropdown-hover.mobile,.dropdown-hover.mobile .btn,.dropdown-hover.mobile .button{width:100%}}@media (max-width:768px){.modal-content{width:500px}.modal{padding-top:50px}}@media (min-width:993px){.modal-content{width:900px}.hide-large{display:none!important}.sidebar.collapse{display:block!important}}@media (max-width:992px) and (min-width:601px){.hide-medium{display:none!important}}@media (max-width:992px){.sidebar.collapse{display:none}.main{margin-left:0!important;margin-right:0!important}.auto{max-width:100%}}.bottom,.top{position:fixed;width:100%;z-index:1}.top{top:0}.bottom{bottom:0}.overlay{position:fixed;display:none;width:100%;height:100%;top:0;left:0;right:0;bottom:0;background-color:rgba(0,0,0,.5);z-index:2}.display-topleft{position:absolute;left:0;top:0}.display-topright{position:absolute;right:0;top:0}.display-bottomleft{position:absolute;left:0;bottom:0}.display-bottomright{position:absolute;right:0;bottom:0}.display-middle{position:absolute;top:50%;left:50%;transform:translate(-50%,-50%);-ms-transform:translate(-50%,-50%)}.display-left{position:absolute;top:50%;left:0;transform:translate(0,-50%);-ms-transform:translate(0,-50%)}.display-right{position:absolute;top:50%;right:0;transform:translate(0,-50%);-ms-transform:translate(0,-50%)}.display-topmiddle{position:absolute;left:50%;top:0;transform:translate(-50%,0);-ms-transform:translate(-50%,0)}.display-bottommiddle{position:absolute;left:50%;bottom:0;transform:translate(-50%,0);-ms-transform:translate(-50%,0)}.display-container:hover .display-hover{display:block}.display-container:hover span.display-hover{display:inline-block}.display-hover{display:none}.display-position{position:absolute}.circle{border-radius:50%}.round-small{border-radius:2px}.round,.round-medium{border-radius:4px}.round-large{border-radius:8px}.round-xlarge{border-radius:16px}.round-xxlarge{border-radius:32px}.row-padding,.row-padding>.col,.row-padding>.half,.row-padding>.quarter,.row-padding>.third,.row-padding>.threequarter,.row-padding>.twothird{padding:0 8px}.container,.datapanel{padding:.01em 8px}.datapanel{margin-top:8px;margin-bottom:8px}.container-none{padding:0}.container-right{padding:.01em 8px .01em 0}.container-left{padding:.01em 0 .01em 8px}.code,.codespan{font-family:Consolas,"courier new";font-size:16px}.code{width:auto;background-color:#fff;padding:8px 12px;border-left:4px solid #4caf50;word-wrap:break-word}.codespan{color:#dc143c;background-color:#f1f1f1;padding-left:4px;padding-right:4px;font-size:110%}.card,.card-2{box-shadow:0 2px 5px 0 rgba(0,0,0,.16)}.card-4,.hover-shadow:hover{box-shadow:0 4px 10px 0 rgba(0,0,0,.2),0 4px 20px 0 rgba(0,0,0,.19)}.spin{animation:spin 2s infinite linear}@keyframes spin{0%{transform:rotate(0)}100%{transform:rotate(359deg)}}.animate-fading{animation:fading 2s infinite}@keyframes fading{0%{opacity:0}50%{opacity:1}100%{opacity:0}}.animate-opacity{animation:opac .8s}@keyframes opac{from{opacity:0}to{opacity:1}}.animate-top{position:relative;animation:animatetop 1s}@keyframes animatetop{from{top:-300px;opacity:0}to{top:0;opacity:1}}.animate-left{position:relative;animation:animateleft .4s}@keyframes animateleft{from{left:-300px;opacity:0}to{left:0;opacity:1}}.animate-right{position:relative;animation:animateright .4s}@keyframes animateright{from{right:-300px;opacity:0}to{right:0;opacity:1}}.animate-bottom{position:relative;animation:animatebottom 1s}@keyframes animatebottom{from{bottom:-300px;opacity:0}to{bottom:0;opacity:1}}.animate-zoom{animation:animatezoom .6s}@keyframes animatezoom{from{transform:scale(0)}to{transform:scale(1)}}.animate-input{transition:width .4s ease-in-out}.animate-input:focus{width:100%!important}.hover-opacity:hover,.opacity{opacity:.6}.hover-opacity-off:hover,.opacity-off{opacity:1}.opacity-max{opacity:.25}.opacity-min{opacity:.75}.grayscale-max,.greyscale-max,.hover-grayscale:hover,.hover-greyscale:hover{filter:grayscale(100%)}.grayscale,.greyscale{filter:grayscale(75%)}.grayscale-min,.greyscale-min{filter:grayscale(50%)}.sepia{filter:sepia(75%)}.hover-sepia:hover,.sepia-max{filter:sepia(100%)}.sepia-min{filter:sepia(50%)}.tiny{font-size:10px!important}.small{font-size:12px!important}.medium{font-size:15px!important}.large{font-size:18px!important}.xlarge{font-size:24px!important}.xxlarge{font-size:36px!important}.xxxlarge{font-size:48px!important}.jumbo{font-size:64px!important}.left-align{text-align:left!important}.right-align{text-align:right!important}.justify{text-align:justify!important}.center{text-align:center!important}.border-0{border:0!important}.border{border:1px solid #ccc!important}.border-top{border-top:1px solid #ccc!important}.border-bottom{border-bottom:1px solid #ccc!important}.border-left{border-left:1px solid #ccc!important}.border-right{border-right:1px solid #ccc!important}.topbar{border-top:6px solid #ccc!important}.bottombar{border-bottom:6px solid #ccc!important}.leftbar{border-left:6px solid #ccc!important}.rightbar{border-right:6px solid #ccc!important}.code,.section{margin-top:16px!important;margin-bottom:16px!important}.margin{margin:16px!important}.margin-top{margin-top:16px!important}.margin-bottom{margin-bottom:16px!important}.margin-left{margin-left:16px!important}.margin-right{margin-right:16px!important}.padding-small{padding:4px 8px!important}.padding{padding:4px 8px!important}.padding-large{padding:12px 24px!important}.padding-16{padding-top:16px!important;padding-bottom:16px!important}.padding-24{padding-top:24px!important;padding-bottom:24px!important}.padding-32{padding-top:32px!important;padding-bottom:32px!important}.padding-48{padding-top:48px!important;padding-bottom:48px!important}.padding-64{padding-top:64px!important;padding-bottom:64px!important}.left{float:left!important}.right{float:right!important}.button:hover{color:#fff!important;background-color:#343434!important}.hover-none:hover,.transparent{background-color:transparent!important}.hover-none:hover{box-shadow:none!important}.amber,.hover-amber:hover{color:#000!important;background-color:#ffc107!important}.aqua,.hover-aqua:hover{color:#000!important;background-color:#0ff!important}.blue,.hover-blue:hover{color:#fff!important;background-color:#2196f3!important}.hover-light-blue:hover,.light-blue{color:#000!important;background-color:#87ceeb!important}.brown,.hover-brown:hover{color:#fff!important;background-color:#795548!important}.cyan,.hover-cyan:hover{color:#000!important;background-color:#00bcd4!important}.blue-grey,.hover-blue-grey:hover{color:#fff!important;background-color:#607d8b!important}.green,.hover-green:hover{color:#fff!important;background-color:#4caf50!important}.hover-light-green:hover,.light-green{color:#000!important;background-color:#8bc34a!important}.hover-indigo:hover,.indigo{color:#fff!important;background-color:#3f51b5!important}.hover-khaki:hover,.khaki{color:#000!important;background-color:khaki!important}.hover-lime:hover,.lime{color:#000!important;background-color:#cddc39!important}.hover-orange:hover,.orange{color:#000!important;background-color:#ff9800!important}.deep-orange,.hover-deep-orange:hover{color:#fff!important;background-color:#ff5722!important}.hover-pink:hover,.pink{color:#fff!important;background-color:#e91e63!important}.hover-purple:hover,.purple{color:#fff!important;background-color:#9c27b0!important}.deep-purple,.hover-deep-purple:hover{color:#fff!important;background-color:#673ab7!important}.hover-red:hover,.red{color:#fff!important;background-color:#f44336!important}.hover-sand:hover,.sand{color:#000!important;background-color:#fdf5e6!important}.hover-teal:hover,.teal{color:#fff!important;background-color:#009688!important}.hover-yellow:hover,.yellow{color:#000!important;background-color:#ffeb3b!important}.hover-white:hover,.white{color:#000!important;background-color:#fff!important}.black,.hover-black:hover{color:#fff!important;background-color:#000!important}.grey,.hover-grey:hover{color:#000!important;background-color:#9e9e9e!important}.hover-light-grey:hover,.light-grey{color:#000!important;background-color:#f1f1f1!important}.dark-grey,.hover-dark-grey:hover{color:#fff!important;background-color:#616161!important}.hover-pale-red:hover,.pale-red{color:#000!important;background-color:#ffe7e7!important}.hover-pale-green:hover,.pale-green{color:#000!important;background-color:#e7ffe7!important}.hover-pale-yellow:hover,.pale-yellow{color:#000!important;background-color:#ffffd7!important}.hover-pale-blue:hover,.pale-blue{color:#000!important;background-color:#e7ffff!important}.text-align-right{text-align:right}.hover-text-amber:hover,.text-amber{color:#ffc107!important}.hover-text-aqua:hover,.text-aqua{color:#0ff!important}.hover-text-blue:hover,.text-blue{color:#2196f3!important}.hover-text-light-blue:hover,.text-light-blue{color:#87ceeb!important}.hover-text-brown:hover,.text-brown{color:#795548!important}.hover-text-cyan:hover,.text-cyan{color:#00bcd4!important}.hover-text-blue-grey:hover,.text-blue-grey{color:#607d8b!important}.hover-text-green:hover,.text-green{color:#4caf50!important}.hover-text-light-green:hover,.text-light-green{color:#8bc34a!important}.hover-text-indigo:hover,.text-indigo{color:#3f51b5!important}.hover-text-khaki:hover,.text-khaki{color:#b4aa50!important}.hover-text-lime:hover,.text-lime{color:#cddc39!important}.hover-text-orange:hover,.text-orange{color:#ff9800!important}.hover-text-deep-orange:hover,.text-deep-orange{color:#ff5722!important}.hover-text-pink:hover,.text-pink{color:#e91e63!important}.hover-text-purple:hover,.text-purple{color:#9c27b0!important}.hover-text-deep-purple:hover,.text-deep-purple{color:#673ab7!important}.hover-text-red:hover,.text-red{color:#f44336!important}.hover-text-sand:hover,.text-sand{color:#fdf5e6!important}.hover-text-teal:hover,.text-teal{color:#009688!important}.hover-text-yellow:hover,.text-yellow{color:#d2be0e!important}.hover-text-white:hover,.text-white{color:#fff!important}.hover-text-black:hover,.text-black{color:#000!important}.hover-text-grey:hover,.text-grey{color:#757575!important}.hover-text-light-grey:hover,.text-light-grey{color:#f1f1f1!important}.hover-text-dark-grey:hover,.text-dark-grey{color:#3a3a3a!important}.border-amber,.hover-border-amber:hover{border-color:#ffc107!important}.border-aqua,.hover-border-aqua:hover{border-color:#0ff!important}.border-blue,.hover-border-blue:hover{border-color:#2196f3!important}.border-light-blue,.hover-border-light-blue:hover{border-color:#87ceeb!important}.border-brown,.hover-border-brown:hover{border-color:#795548!important}.border-cyan,.hover-border-cyan:hover{border-color:#00bcd4!important}.border-blue-grey,.hover-blue-grey:hover{border-color:#607d8b!important}.border-green,.hover-border-green:hover{border-color:#4caf50!important}.border-light-green,.hover-border-light-green:hover{border-color:#8bc34a!important}.border-indigo,.hover-border-indigo:hover{border-color:#3f51b5!important}.border-khaki,.hover-border-khaki:hover{border-color:khaki!important}.border-lime,.hover-border-lime:hover{border-color:#cddc39!important}.border-orange,.hover-border-orange:hover{border-color:#ff9800!important}.border-deep-orange,.hover-border-deep-orange:hover{border-color:#ff5722!important}.border-pink,.hover-border-pink:hover{border-color:#e91e63!important}.border-purple,.hover-border-purple:hover{border-color:#9c27b0!important}.border-deep-purple,.hover-border-deep-purple:hover{border-color:#673ab7!important}.border-red,.hover-border-red:hover{border-color:#f44336!important}.border-sand,.hover-border-sand:hover{border-color:#fdf5e6!important}.border-teal,.hover-border-teal:hover{border-color:#009688!important}.border-yellow,.hover-border-yellow:hover{border-color:#ffeb3b!important}.border-white,.hover-border-white:hover{border-color:#fff!important}.border-black,.hover-border-black:hover{border-color:#000!important}.border-grey,.hover-border-grey:hover{border-color:#9e9e9e!important}.border-light-grey,.hover-border-light-grey:hover{border-color:#f1f1f1!important}.border-dark-grey,.hover-border-dark-grey:hover{border-color:#616161!important}.border-pale-red,.hover-border-pale-red:hover{border-color:#ffe7e7!important}.border-pale-green,.hover-border-pale-green:hover{border-color:#e7ffe7!important}.border-pale-yellow,.hover-border-pale-yellow:hover{border-color:#ffffd7!important}.border-pale-blue,.hover-border-pale-blue:hover{border-color:#e7ffff!important}.theme-l5{color:#000!important;background-color:#f6f8fc!important}.theme-l4{color:#000!important;background-color:#e1e9f6!important}.theme-l3{color:#000!important;background-color:#c3d3ed!important}.theme-l2{color:#000!important;background-color:#a5bee4!important}.theme-l1{color:#fff!important;background-color:#88a8db!important}.theme-d1{color:#fff!important;background-color:#5180cb!important}.theme-d2{color:#fff!important;background-color:#3a6fc3!important}.theme-d3{color:#fff!important;background-color:#3361aa!important}.theme-d4{color:#fff!important;background-color:#2c5392!important}.theme-d5{color:#fff!important;background-color:#24457a!important}.theme-light{color:#000!important;background-color:#f6f8fc!important}.theme-dark{color:#fff!important;background-color:#24457a!important}.theme-action{color:#fff!important;background-color:#24457a!important}.theme{color:#fff!important;background-color:#6a92d3!important}.text-theme{color:#6a92d3!important}.border-theme{border-color:#6a92d3!important}.hover-theme:hover{color:#fff!important;background-color:#6a92d3!important}.hover-text-theme:hover{color:#6a92d3!important}.hover-border-theme:hover{border-color:#6a92d3!important}body{background-color:#f7f7f7}.info-panel{padding:3px;color:#ff4500;border:1px solid #ff4500;background-color:#f89774}.info-panel2{padding:3px;color:#000;border:1px solid #025788;background-color:#a6dbfa}.error-panel{padding:3px;color:red;border:1px solid red;background-color:#fcb2b2}.table{table-layout:fixed}.text-line-through{text-decoration:line-through}#snackbar{visibility:hidden;min-width:250px;margin-left:-125px;background-color:#333;color:#fff;text-align:center;padding:16px;position:fixed;z-index:1;left:50%;bottom:30px;font-size:17px}#snackbar.show{visibility:visible;-webkit-animation:fadein .5s,fadeout .5s 2.5s;animation:fadein .5s,fadeout .5s 2.5s}@-webkit-keyframes fadein{from{bottom:0;opacity:0}to{bottom:30px;opacity:1}}@keyframes fadein{from{bottom:0;opacity:0}to{bottom:30px;opacity:1}}@-webkit-keyframes fadeout{from{bottom:30px;opacity:1}to{bottom:0;opacity:0}}@keyframes fadeout{from{bottom:30px;opacity:1}to{bottom:0;opacity:0}}.tabulator-header-filter>input{background-color:#fff;border:1px solid #ccc;font-weight:400}.readonly{pointer-events:none;color:#000!important;background-color:#d3d3d3!important}.readonlybasic{pointer-events:none;color:#000!important;background-color:#efefef!important;border:0!important}.right-side-bg{background:url(../img/bg1.jpg);background-size:cover;min-height:100vh}button{background-color:#f4f4f4;border:1pt solid #ccc;font-size:10pt;color:#000;line-height:1line;text-align:center}button:hover{background-color:#343434}button:pressed{background-color:#343434}button:focus{background-color:#343434}header{background-color:#fff;box-sizing:border-box}::-webkit-input-placeholder{color:rgba(60.3922%,60.3922%,60.3922%,1)}textarea{background-color:#fff;border-top-color:rgba(80%,80%,80%,1);border-right-color:rgba(80%,80%,80%,1);border-bottom-color:rgba(80%,80%,80%,1);border-left-color:rgba(80%,80%,80%,1);border-top-style:solid;border-right-style:solid;border-bottom-style:solid;border-left-style:solid;border-top-width:1pt;border-right-width:1pt;border-bottom-width:1pt;border-left-width:1pt;font-size:11pt;color:#000;line-height:1line;text-align:left}textarea:focus{border-top-color:rgba(0%,43.9216%,81.1765%,1);border-right-color:rgba(0%,43.9216%,81.1765%,1);border-bottom-color:rgba(0%,43.9216%,81.1765%,1);border-left-color:rgba(0%,43.9216%,81.1765%,1)}textarea:placeholder{color:rgba(80%,80%,80%,1)}textarea .scrollbar_track{width:30pt;top:0;right:0;bottom:0;position:absolute;box-sizing:border-box}footer{background-color:#fff;box-sizing:border-box}button.btnNavigation{background-color:rgba(0%,0%,0%,0);font-family:-fm-font-family(Arial,Arial-BoldMT);font-weight:700;font-size:10pt;color:#fff;padding-top:0;padding-right:0;padding-bottom:0;padding-left:0}.moduletoolbar{background:linear-gradient(163deg,rgba(127,175,79,1) 7%,rgba(94,162,89,1) 38%,rgba(39,154,200,1) 100%);color:#fff}div.PageHeadTitle{font-size:18pt;color:#fff}.SubHeadTitle{font-size:13pt;color:#fff;font-weight:400}div.SubHeadTitle{font-size:13pt;color:#fff}.toolbarbtn>.icon{font-size:16px}.inforow,tr.inforow{background-color:#efefef}tr.resultrow{background-color:#484848;color:#fff!important}.resultcol,td.resultcol{width:90px!important;text-align:right!important}.labelcol,td.labelcol,th.labelcol{width:150px!important}a.bodybtn,a.toolbarbtn,button.bodybtn,button.btninverse,button.toolbarbtn{margin:2px;padding:4px 8px;background-color:#343434!important;border-radius:6px;border:.5px solid #c6c6c6!important;color:#fff}button.btninverse{background-color:#fff!important;color:#343434}a.bodybtn,a.toolbarbtn{text-align:center;text-decoration:unset;font-size:10pt!important}a.bodybtn:hover,a.toolbarbtn:hover,button.bodybtn:hover,button.btninverse:hover,button.toolbarbtn:hover{background-color:#343434!important;color:#ffe100}a.bodybtn:pressed,a.toolbarbtn:pressed,button.bodybtn:pressed,button.btninverse:pressed,button.toolbarbtn:pressed{background-color:#343434!important;color:#fff}a.bodybtn:focus,a.toolbarbtn:focus,button.bodybtn:focus,button.btninverse:focus,button.toolbarbtn:focus{border-color:#ccc!important}div.toolbar{background:linear-gradient(163deg,rgba(127,175,79,1) 7%,rgba(94,162,89,1) 38%,rgba(39,154,200,1) 100%)}::-webkit-scrollbar{-webkit-appearance:none;width:10px}::-webkit-scrollbar-track{background-color:rgba(80%,80%,80%,.5)}::-webkit-scrollbar-thumb{border-radius:0;background-color:rgba(0,0,0,.5);-webkit-box-shadow:0 0 1px rgba(255,255,255,.5)}select{display:block;color:#000;line-height:1line;text-align:left;padding:3.5px;width:100%;max-width:100%;box-sizing:border-box;margin:0;border:1px solid #ccc;border-radius:0;font-weight:400;font-size:11pt;background-color:#fff}select:focus{border:1px solid #3a6fc3;border-radius:unset}::-webkit-select-placeholder{color:#9a9a9a}div.DataFooter{background:#384462}:focus{outline:unset}input{background-color:#fff;border:1px solid #ccc;font-weight:400;font-size:11pt;color:#000;line-height:1line;text-align:left;width:100%;padding:2px;display:block;border-radius:unset}input:focus{border:1px solid #3a6fc3;border-radius:unset}input[type=number]::-webkit-inner-spin-button,input[type=number]::-webkit-outer-spin-button{-webkit-appearance:none;margin:0}input:read-only{color:#000!important;background-color:#d3d3d3}input[class=currency]{padding:2px;padding-right:12px;text-align:right;background-image:url(data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20width=%22225%22%20height=%22300%22%3E%3Cpath%20stroke=%22none%22%20d=%22m%20224.99996,16.22698%20-8.11342,36.41161%20q%20-24.14255,-19.78892%20-54.61741,-19.78892%20-41.3588,0%20-65.00658,23.74671%20-23.647774,23.7467%20-28.397115,53.23215%20l%20134.960355,0%20-5.14505,26.71508%20-132.981532,0%20-0.395848,7.71771%200.395848,18.20566%20127.242642,0%20-5.14505,26.71508%20-117.941954,0%20q%207.519719,40.17154%2032.552754,59.06997%2025.03303,18.89844%2056.49745,18.89844%2037.20302,0%2057.98149,-19.59107%20l%200,40.9631%20Q%20192.34828,300%20162.26913,300%2053.034301,300%2030.474864,189.18206%20l%20-30.474864,0%205.738751,-26.71508%2020.580475,0%20q%20-0.395708,-4.74934%20-0.395708,-17.80995%20l%200,-8.11342%20-25.923518,0%205.738751,-26.71508%2023.152999,0%20Q%2039.181988,55.21112%2076.583149,27.60556%20113.98417,0%20163.06069,0%20199.868,0%20224.99996,16.22698%20z%22%20/%3E%0A%3C/svg%3E),linear-gradient(to bottom,#fff 0,#fff 100%);background-repeat:no-repeat,repeat;background-position:right 2px top 50%,0 0;background-size:9px auto,100%}input[class=currency]:read-only{background-image:url(data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20width=%22225%22%20height=%22300%22%3E%3Cpath%20stroke=%22none%22%20d=%22m%20224.99996,16.22698%20-8.11342,36.41161%20q%20-24.14255,-19.78892%20-54.61741,-19.78892%20-41.3588,0%20-65.00658,23.74671%20-23.647774,23.7467%20-28.397115,53.23215%20l%20134.960355,0%20-5.14505,26.71508%20-132.981532,0%20-0.395848,7.71771%200.395848,18.20566%20127.242642,0%20-5.14505,26.71508%20-117.941954,0%20q%207.519719,40.17154%2032.552754,59.06997%2025.03303,18.89844%2056.49745,18.89844%2037.20302,0%2057.98149,-19.59107%20l%200,40.9631%20Q%20192.34828,300%20162.26913,300%2053.034301,300%2030.474864,189.18206%20l%20-30.474864,0%205.738751,-26.71508%2020.580475,0%20q%20-0.395708,-4.74934%20-0.395708,-17.80995%20l%200,-8.11342%20-25.923518,0%205.738751,-26.71508%2023.152999,0%20Q%2039.181988,55.21112%2076.583149,27.60556%20113.98417,0%20163.06069,0%20199.868,0%20224.99996,16.22698%20z%22%20/%3E%0A%3C/svg%3E),linear-gradient(to bottom,#d3d3d3 0,#d3d3d3 100%)}input[class=percent]{padding:2px;padding-right:12px;text-align:right;background-image:url('data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20width=%22256%22%20height=%22232%22%20version=%221.0%22%3E%3Cg%20transform=%22translate(-112.3674,-128.3649)%22%3E%3Cpath%20style=%22fill:black;fill-opacity:1;stroke:none%22%20d=%22M%20317.1674,257.53698%20C%20308.53463,257.53708%20301.73774,261.20839%20296.77671,268.55094%20C%20291.91449,275.89365%20289.48349,286.1138%20289.48368,299.2114%20C%20289.48349,312.11067%20291.91449,322.2812%20296.77671,329.72303%20C%20301.73774,337.06568%20308.53463,340.737%20317.1674,340.73698%20C%20325.60128,340.737%20332.24934,337.06568%20337.11159,329.72303%20C%20342.07258,322.2812%20344.5532,312.11067%20344.55345,299.2114%20C%20344.5532,286.21302%20342.07258,276.04249%20337.11159,268.69977%20C%20332.24934,261.25801%20325.60128,257.53708%20317.1674,257.53698%20M%20317.1674,238.63466%20C%20332.84469,238.63477%20345.29739,244.09213%20354.52554,255.00675%20C%20363.75318,265.92157%20368.36713,280.65644%20368.3674,299.2114%20C%20368.36713,317.76648%20363.70357,332.50135%20354.37671,343.41605%20C%20345.14855,354.23156%20332.74546,359.6393%20317.1674,359.63931%20C%20301.29123,359.6393%20288.7393,354.23156%20279.51159,343.41605%20C%20270.28351,332.50135%20265.66956,317.76648%20265.66973,299.2114%20C%20265.66956,280.55721%20270.28351,265.82234%20279.51159,255.00675%20C%20288.83853,244.09213%20301.39045,238.63477%20317.1674,238.63466%20M%20163.5674,147.9928%20C%20155.03401,147.993%20148.28673,151.71393%20143.32554,159.15559%20C%20138.46349,166.49841%20136.03248,176.61933%20136.03252,189.51838%20C%20136.03248,202.61621%20138.46349,212.83635%20143.32554,220.17884%20C%20148.18751,227.52161%20154.93479,231.19292%20163.5674,231.1928%20C%20172.19989,231.19292%20178.94717,227.52161%20183.80926,220.17884%20C%20188.77041,212.83635%20191.25103,202.61621%20191.25113,189.51838%20C%20191.25103,176.71856%20188.77041,166.59764%20183.80926,159.15559%20C%20178.84794,151.71393%20172.10066,147.993%20163.5674,147.9928%20M%20297.9674,129.09047%20L%20321.78136,129.09047%20L%20182.7674,359.63931%20L%20158.95345,359.63931%20L%20297.9674,129.09047%20M%20163.5674,129.09047%20C%20179.24484,129.0907%20191.74715,134.54806%20201.07438,145.46256%20C%20210.4014,156.27827%20215.06496,170.96352%20215.06508,189.51838%20C%20215.06496,208.27201%20210.4014,223.05649%20201.07438,233.87187%20C%20191.84638,244.68748%20179.34406,250.09523%20163.5674,250.09512%20C%20147.79061,250.09523%20135.28829,244.68748%20126.06043,233.87187%20C%20116.93172,222.95727%20112.36739,208.17279%20112.3674,189.51838%20C%20112.36739,171.06275%20116.98134,156.37749%20126.20926,145.46256%20C%20135.43713,134.54806%20147.88983,129.0907%20163.5674,129.09047%22%20/%3E%3C/g%3E%3C/svg%3E'),linear-gradient(to bottom,#fff 0,#fff 100%);background-repeat:no-repeat,repeat;background-position:right 2px top 50%,0 0;background-size:9px auto,100%}label{height:12.8px!important;color:#000;font-size:8pt}input[type=checkbox]{display:block;-webkit-appearance:none;height:29.66px;width:29.66px;cursor:pointer;position:relative;-webkit-transition:.15s;border-radius:unset;border:1px solid #ccc;background-color:#fff}input[type=checkbox]:checked{background-color:#fff}input[type=checkbox]:before,input[type=checkbox]:checked:before{position:absolute;top:0;left:0;width:100%;height:100%;line-height:2em;text-align:center;color:#000;content:''}input[type=checkbox]:checked:before{font-size:11pt;content:'✔'}input[type=checkbox]:hover:before{background:rgba(255,255,255,.3)}input[type=color]{-webkit-appearance:none;width:120px;height:35px}input[type=color]::-webkit-color-swatch-wrapper{padding:0}input[type=color]::-webkit-color-swatch{border:none}:focus{outline:1px solid #607d8b}.modal-content>header{background-color:var(--color-btn1);color:#fff;padding:8px!important;margin-bottom:10px}.modal-content>header>h2{font-size:13pt}.modal-content>footer{text-align:right!important;color:#000!important;background-color:#c6c6c6!important;margin-top:6px;padding-top:8px!important;padding-bottom:8px!important}.modal-content>footer:after,.modal-content>footer:before,.modal-content>header:after,.modal-content>header:before{content:"";display:table;clear:both}span[class^=icon]::after{content:"\A";white-space:pre}span[class^=icon-inline]::after{content:" "}span[class^=rowicon]::after{content:"\A";white-space:nowrap}a.inlinebtn{border:.5px solid #c6c6c6;color:red;text-align:center;text-decoration:unset;font-size:8pt!important;position:relative;height:28px;margin-top:-28px;margin-left:-20px;padding:4px 8px;border:0!important;float:right}a.inlinebtn:hover{background-color:#343434!important;color:#fff}a.inlinebtn:pressed{background-color:#343434!important;color:#fff}a.inlinebtn:focus{border-color:#ccc!important}.dspvacancynormal{color:#000}.dspvacancyill{color:red}.dspvacancyextra{color:#00f}#help_page{font-size:13pt;margin-left:30px;padding-bottom:30px!important}#help_page img{margin-left:40px}#help_page blockquote{background-color:#c5c5c5;padding:6px;border-left:5px solid red}#help_page hr{border-top:1px solid #757575}.lds-spinner{color:official;display:inline-block;position:relative;width:80px;height:80px}.lds-spinner div{transform-origin:40px 40px;animation:lds-spinner 1.2s linear infinite}.lds-spinner div:after{content:" ";display:block;position:absolute;top:3px;left:37px;width:6px;height:18px;border-radius:20%;background:#000}.lds-spinner div:nth-child(1){transform:rotate(0);animation-delay:-1.1s}.lds-spinner div:nth-child(2){transform:rotate(30deg);animation-delay:-1s}.lds-spinner div:nth-child(3){transform:rotate(60deg);animation-delay:-.9s}.lds-spinner div:nth-child(4){transform:rotate(90deg);animation-delay:-.8s}.lds-spinner div:nth-child(5){transform:rotate(120deg);animation-delay:-.7s}.lds-spinner div:nth-child(6){transform:rotate(150deg);animation-delay:-.6s}.lds-spinner div:nth-child(7){transform:rotate(180deg);animation-delay:-.5s}.lds-spinner div:nth-child(8){transform:rotate(210deg);animation-delay:-.4s}.lds-spinner div:nth-child(9){transform:rotate(240deg);animation-delay:-.3s}.lds-spinner div:nth-child(10){transform:rotate(270deg);animation-delay:-.2s}.lds-spinner div:nth-child(11){transform:rotate(300deg);animation-delay:-.1s}.lds-spinner div:nth-child(12){transform:rotate(330deg);animation-delay:0s}@keyframes lds-spinner{0%{opacity:1}100%{opacity:0}}.potcurrent{background-color:rgb(225,235,52,.5)!important}.potcurrent:hover{background-color:rgb(187,187,187,.5)!important;cursor:pointer}.tabulator-selected.potcurrent{background-color:#9abcea!important;cursor:pointer}.tabulator-selected.potcurrent:hover{background-color:rgb(154,188,234,.5)!important;cursor:pointer}.datefield{width:110px!important}.dateselect{padding:4px;text-align:center}.lbldateselect{padding-left:2px;display:block}.dtnav{height:50px;padding-left:0!important;padding-right:0!important;margin-top:2px;background-color:#394462!important;border-top:.5px solid #c6c6c6!important;border-bottom:.5px solid #c6c6c6!important}.bold{font-weight:700}form{margin-bottom:20px}.tabulator .tabulator-header .tabulator-col{background-color:var(--color-btn1)}.tabulator .tabulator-header{border-bottom:3px solid var(--color-btn1)}.tabulator .tabulator-footer{padding:5px 10px;padding-top:8px;border-top:3px solid var(--color-btn1)}.tabulator .tabulator-footer .tabulator-calcs-holder{margin:-8px -10px 8px -10px;background:var(--color-btn1)!important;border-top:none;border-bottom:1px solid #aaa}.tabulator .tabulator-footer .tabulator-calcs-holder .tabulator-row{background:var(--color-btn1)!important;color:#fff!important} \ No newline at end of file +html{box-sizing:border-box}*,:after,:before{box-sizing:inherit}html{-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%}body{margin:0}body,html{-webkit-user-select:none;-ms-user-select:none;user-select:none;-moz-user-select:none}article,aside,details,figcaption,figure,footer,header,main,menu,nav,section{display:block}summary{display:list-item}audio,canvas,progress,video{display:inline-block}progress{vertical-align:baseline}audio:not([controls]){display:none;height:0}[hidden],template{display:none}a{background-color:transparent}a:active,a:hover{outline-width:0}abbr[title]{border-bottom:none;text-decoration:underline;text-decoration:underline dotted}b,strong{font-weight:bolder}dfn{font-style:italic}mark{background:#ff0;color:#000}small{font-size:80%}sub,sup{font-size:75%;line-height:0;position:relative;vertical-align:baseline}sub{bottom:-.25em}sup{top:-.5em}figure{margin:1em 40px}img{border-style:none}code,kbd,pre,samp{font-family:monospace,monospace;font-size:1em}hr{box-sizing:content-box;height:0;overflow:visible}button,input,optgroup,select,textarea{font:inherit;margin:0}optgroup{font-weight:700}button,input{overflow:visible}button,select{text-transform:none}[type=button],[type=reset],[type=submit],button{-webkit-appearance:button}[type=button]::-moz-focus-inner,[type=reset]::-moz-focus-inner,[type=submit]::-moz-focus-inner,button::-moz-focus-inner{border-style:none;padding:0}[type=button]:-moz-focusring,[type=reset]:-moz-focusring,[type=submit]:-moz-focusring,button:-moz-focusring{outline:1px dotted ButtonText}fieldset{border:1px solid silver;margin:0 2px;padding:.35em .625em .75em}legend{color:inherit;display:table;max-width:100%;padding:0;white-space:normal}textarea{overflow:auto}[type=checkbox],[type=radio]{padding:0}[type=number]::-webkit-inner-spin-button,[type=number]::-webkit-outer-spin-button{height:auto}[type=search]{-webkit-appearance:textfield;outline-offset:-2px}[type=search]::-webkit-search-decoration{-webkit-appearance:none}::-webkit-file-upload-button{-webkit-appearance:button;font:inherit}:root{--color-bg1:rgba(127,175,79,1);--color-bg2:rgba(94,162,89,1);--color-bg3:rgba(39,154,200,1);--color-btn1:rgb(52, 52, 52)}body,html{font-family:Verdana,sans-serif;font-size:10pt;line-height:1.5}html{overflow-x:hidden}h1{font-size:36px}h2{font-size:30px}h3{font-size:24px}h4{font-size:20px}h5{font-size:18px}h6{font-size:16px}.serif{font-family:serif}h1,h2,h3,h4,h5,h6{font-family:"Segoe UI",Arial,sans-serif;font-weight:400;margin:0}.wide{letter-spacing:4px}hr{border:0;border-top:1px solid #eee;margin:20px 0}.img{max-width:100%;height:auto;vertical-align:middle}a{color:inherit}.table,.table-all{border-collapse:collapse;border-spacing:0;width:100%;display:table}.table-all{border:1px solid #ccc}.bordered tr,.table-all tr{border-bottom:1px solid #ddd}.striped tbody tr:nth-child(even){background-color:#f1f1f1}.table-all tr:nth-child(odd){background-color:#fff}.table-all tr:nth-child(even){background-color:#f1f1f1}.hoverable tbody tr:hover,.ul.hoverable li:hover{background-color:#ccc}.centered tr td,.centered tr th{text-align:center}.table td,.table th,.table-all td,.table-all th{padding:3px 3px;display:table-cell;text-align:left;vertical-align:top}.table td:first-child,.table th:first-child,.table-all td:first-child,.table-all th:first-child{padding-left:16px}.btn,.button{border:none;display:inline-block;padding:4px 8px;vertical-align:middle;overflow:hidden;text-decoration:none;color:inherit;background-color:inherit;text-align:center;cursor:pointer;white-space:nowrap}.btn:hover{box-shadow:0 4px 8px 0 rgba(0,0,0,.2),0 6px 20px 0 rgba(0,0,0,.19)}.btn,.button{-webkit-touch-callout:none;-webkit-user-select:none;-khtml-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none}.btn:disabled,.button:disabled,.disabled{cursor:not-allowed;background-color:#e6e6e6}.disabled *,:disabled *{pointer-events:none}.btn.disabled:hover,.btn:disabled:hover{box-shadow:none}.badge,.tag{background-color:#000;color:#fff;display:inline-block;padding-left:8px;padding-right:8px;text-align:center}.badge{border-radius:50%}.ul{list-style-type:none;padding:0;margin:0}.ul li{padding:4px 8px;border-bottom:1px solid #ddd}.ul li:last-child{border-bottom:none}.display-container,.tooltip{position:relative}.tooltip .text{display:none}.tooltip:hover .text{display:inline-block}.ripple:active{opacity:.5}.ripple{transition:opacity 0s}.input{padding:6px;display:block;border:1px solid #ccc;width:100%;background-color:#fff}.select{padding:6px;width:100%;border:1px solid #ccc;background-color:#fff;font-size:11pt}.dropdown-click,.dropdown-hover{position:relative;display:inline-block;cursor:pointer}.dropdown-hover:hover .dropdown-content{display:block}.dropdown-click:hover,.dropdown-hover:first-child{background-color:#ccc;color:#000}.dropdown-click:hover>.button:first-child,.dropdown-hover:hover>.button:first-child{background-color:#ccc;color:#000}.dropdown-content{cursor:auto;color:#000;background-color:#fff;display:none;position:absolute;min-width:160px;margin:0;padding:0;z-index:1}.check,.radio{width:24px;height:24px;position:relative;top:6px}.sidebar{height:100%;width:160px;background-color:#fff;position:fixed!important;z-index:1;overflow:auto}.bar-block .dropdown-click,.bar-block .dropdown-hover{width:100%}.bar-block .dropdown-click .dropdown-content,.bar-block .dropdown-hover .dropdown-content{min-width:100%}.bar-block .dropdown-click .button,.bar-block .dropdown-hover .button{width:100%;text-align:left;padding:4px 8px}#main,.main{transition:margin-left .4s}.modal{z-index:3;display:none;padding-top:100px;position:fixed;left:0;top:0;width:100%;height:100%;overflow:auto;background-color:#000;background-color:rgba(0,0,0,.4)}.modal-content{margin:auto;background-color:#fff;position:relative;padding:0;outline:0;width:600px}.bar{width:100%}.center .bar{display:inline-block;width:auto}.bar .bar-item{padding:4px 8px;float:left;width:auto;border:none;display:block;outline:0}.bar .dropdown-click,.bar .dropdown-hover{position:static;float:left}.bar .button{white-space:normal}.bar-block .bar-item{width:100%;display:block;padding:4px 8px;text-align:left;border:none;white-space:normal;float:none;outline:0}.bar-block.center .bar-item{text-align:center}.block{display:block;width:100%}.responsive{display:block;overflow-x:auto}.bar:after,.bar:before,.cell-row:after,.cell-row:before,.clear:after,.clear:before,.container-left:before,.container-lefte:after,.container-none:after,.container-none:before,.container-right:after,.container-right:before,.container:after,.container:before,.datapanel:after,.datapanel:before,.row-padding:after,.row-padding:before,.row:after,.row:before{content:"";display:table;clear:both}.col,.fifth,.fourfifth,.half,.quarter,.third,.threefifth,.threequarter,.twofifth,.twothird{float:left;width:100%}.col.s1{width:8.33333%}.col.s2{width:16.66666%}.col.s3{width:24.99999%}.col.s4{width:33.33333%}.col.s5{width:41.66666%}.col.s6{width:49.99999%}.col.s7{width:58.33333%}.col.s8{width:66.66666%}.col.s9{width:74.99999%}.col.s10{width:83.33333%}.col.s11{width:91.66666%}.col.s12{width:99.99999%}@media (min-width:601px){.col.m1{width:8.33333%}.col.m2{width:16.66666%}.col.m3,.quarter{width:24.99999%}.col.m4,.third{width:33.33333%}.fifth{width:20%;min-width:100px}.col.m5{width:41.66666%}.col.m6,.half{width:49.99999%}.col.m7{width:58.33333%}.col.m8,.twothird{width:66.66666%}.col.m9,.threequarter{width:74.99999%}.col.m10{width:83.33333%}.col.m11{width:91.66666%}.col.m12{width:99.99999%}.twofifth{width:40%}.threefifth{width:60%}.fourfifth{width:80%}}@media (min-width:993px){.col.l1{width:8.33333%}.col.l2{width:16.66666%}.col.l3{width:24.99999%}.col.l4{width:33.33333%}.col.l5{width:41.66666%}.col.l6{width:49.99999%}.col.l7{width:58.33333%}.col.l8{width:66.66666%}.col.l9{width:74.99999%}.col.l10{width:83.33333%}.col.l11{width:91.66666%}.col.l12{width:99.99999%}}.rest{overflow:hidden}.stretch{margin-left:-16px;margin-right:-16px}.auto,.content{margin-left:auto;margin-right:auto}.content{max-width:980px}.auto{max-width:1140px}.cell-row{display:table;width:100%}.cell{display:table-cell;vertical-align:top}.cell-top{vertical-align:top}.cell-middle{vertical-align:middle}.cell-bottom{vertical-align:bottom}.hide{display:none!important}.show,.show-block{display:block!important}.show-inline-block{display:inline-block!important}@media (max-width:1205px){.auto{max-width:95%}}@media (max-width:600px){.modal-content{margin:0 10px;width:auto!important}.modal{padding-top:30px}.dropdown-click.mobile .dropdown-content,.dropdown-hover.mobile .dropdown-content{position:relative}.hide-small{display:none!important}.mobile{display:block;width:100%!important}.bar-item.mobile,.dropdown-click.mobile,.dropdown-hover.mobile{text-align:center}.dropdown-click.mobile,.dropdown-click.mobile .btn,.dropdown-click.mobile .button,.dropdown-hover.mobile,.dropdown-hover.mobile .btn,.dropdown-hover.mobile .button{width:100%}}@media (max-width:768px){.modal-content{width:500px}.modal{padding-top:50px}}@media (min-width:993px){.modal-content{width:900px}.hide-large{display:none!important}.sidebar.collapse{display:block!important}}@media (max-width:992px) and (min-width:601px){.hide-medium{display:none!important}}@media (max-width:992px){.sidebar.collapse{display:none}.main{margin-left:0!important;margin-right:0!important}.auto{max-width:100%}}.bottom,.top{position:fixed;width:100%;z-index:1}.top{top:0}.bottom{bottom:0}.overlay{position:fixed;display:none;width:100%;height:100%;top:0;left:0;right:0;bottom:0;background-color:rgba(0,0,0,.5);z-index:2}.display-topleft{position:absolute;left:0;top:0}.display-topright{position:absolute;right:0;top:0}.display-bottomleft{position:absolute;left:0;bottom:0}.display-bottomright{position:absolute;right:0;bottom:0}.display-middle{position:absolute;top:50%;left:50%;transform:translate(-50%,-50%);-ms-transform:translate(-50%,-50%)}.display-left{position:absolute;top:50%;left:0;transform:translate(0,-50%);-ms-transform:translate(0,-50%)}.display-right{position:absolute;top:50%;right:0;transform:translate(0,-50%);-ms-transform:translate(0,-50%)}.display-topmiddle{position:absolute;left:50%;top:0;transform:translate(-50%,0);-ms-transform:translate(-50%,0)}.display-bottommiddle{position:absolute;left:50%;bottom:0;transform:translate(-50%,0);-ms-transform:translate(-50%,0)}.display-container:hover .display-hover{display:block}.display-container:hover span.display-hover{display:inline-block}.display-hover{display:none}.display-position{position:absolute}.circle{border-radius:50%}.round-small{border-radius:2px}.round,.round-medium{border-radius:4px}.round-large{border-radius:8px}.round-xlarge{border-radius:16px}.round-xxlarge{border-radius:32px}.row-padding,.row-padding>.col,.row-padding>.half,.row-padding>.quarter,.row-padding>.third,.row-padding>.threequarter,.row-padding>.twothird{padding:0 8px}.container,.datapanel{padding:.01em 8px}.datapanel{margin-top:8px;margin-bottom:8px}.container-none{padding:0}.container-right{padding:.01em 8px .01em 0}.container-left{padding:.01em 0 .01em 8px}.code,.codespan{font-family:Consolas,"courier new";font-size:16px}.code{width:auto;background-color:#fff;padding:8px 12px;border-left:4px solid #4caf50;word-wrap:break-word}.codespan{color:#dc143c;background-color:#f1f1f1;padding-left:4px;padding-right:4px;font-size:110%}.card,.card-2{box-shadow:0 2px 5px 0 rgba(0,0,0,.16)}.card-4,.hover-shadow:hover{box-shadow:0 4px 10px 0 rgba(0,0,0,.2),0 4px 20px 0 rgba(0,0,0,.19)}.spin{animation:spin 2s infinite linear}@keyframes spin{0%{transform:rotate(0)}100%{transform:rotate(359deg)}}.animate-fading{animation:fading 2s infinite}@keyframes fading{0%{opacity:0}50%{opacity:1}100%{opacity:0}}.animate-opacity{animation:opac .8s}@keyframes opac{from{opacity:0}to{opacity:1}}.animate-top{position:relative;animation:animatetop 1s}@keyframes animatetop{from{top:-300px;opacity:0}to{top:0;opacity:1}}.animate-left{position:relative;animation:animateleft .4s}@keyframes animateleft{from{left:-300px;opacity:0}to{left:0;opacity:1}}.animate-right{position:relative;animation:animateright .4s}@keyframes animateright{from{right:-300px;opacity:0}to{right:0;opacity:1}}.animate-bottom{position:relative;animation:animatebottom 1s}@keyframes animatebottom{from{bottom:-300px;opacity:0}to{bottom:0;opacity:1}}.animate-zoom{animation:animatezoom .6s}@keyframes animatezoom{from{transform:scale(0)}to{transform:scale(1)}}.animate-input{transition:width .4s ease-in-out}.animate-input:focus{width:100%!important}.hover-opacity:hover,.opacity{opacity:.6}.hover-opacity-off:hover,.opacity-off{opacity:1}.opacity-max{opacity:.25}.opacity-min{opacity:.75}.grayscale-max,.greyscale-max,.hover-grayscale:hover,.hover-greyscale:hover{filter:grayscale(100%)}.grayscale,.greyscale{filter:grayscale(75%)}.grayscale-min,.greyscale-min{filter:grayscale(50%)}.sepia{filter:sepia(75%)}.hover-sepia:hover,.sepia-max{filter:sepia(100%)}.sepia-min{filter:sepia(50%)}.tiny{font-size:10px!important}.small{font-size:12px!important}.medium{font-size:15px!important}.large{font-size:18px!important}.xlarge{font-size:24px!important}.xxlarge{font-size:36px!important}.xxxlarge{font-size:48px!important}.jumbo{font-size:64px!important}.left-align{text-align:left!important}.right-align{text-align:right!important}.justify{text-align:justify!important}.center{text-align:center!important}.border-0{border:0!important}.border{border:1px solid #ccc!important}.border-top{border-top:1px solid #ccc!important}.border-bottom{border-bottom:1px solid #ccc!important}.border-left{border-left:1px solid #ccc!important}.border-right{border-right:1px solid #ccc!important}.topbar{border-top:6px solid #ccc!important}.bottombar{border-bottom:6px solid #ccc!important}.leftbar{border-left:6px solid #ccc!important}.rightbar{border-right:6px solid #ccc!important}.code,.section{margin-top:16px!important;margin-bottom:16px!important}.margin{margin:16px!important}.margin-top{margin-top:16px!important}.margin-bottom{margin-bottom:16px!important}.margin-left{margin-left:16px!important}.margin-right{margin-right:16px!important}.padding-small{padding:4px 8px!important}.padding{padding:4px 8px!important}.padding-large{padding:12px 24px!important}.padding-16{padding-top:16px!important;padding-bottom:16px!important}.padding-24{padding-top:24px!important;padding-bottom:24px!important}.padding-32{padding-top:32px!important;padding-bottom:32px!important}.padding-48{padding-top:48px!important;padding-bottom:48px!important}.padding-64{padding-top:64px!important;padding-bottom:64px!important}.left{float:left!important}.right{float:right!important}.button:hover{color:#fff!important;background-color:#343434!important}.hover-none:hover,.transparent{background-color:transparent!important}.hover-none:hover{box-shadow:none!important}.amber,.hover-amber:hover{color:#000!important;background-color:#ffc107!important}.aqua,.hover-aqua:hover{color:#000!important;background-color:#0ff!important}.blue,.hover-blue:hover{color:#fff!important;background-color:#2196f3!important}.hover-light-blue:hover,.light-blue{color:#000!important;background-color:#87ceeb!important}.brown,.hover-brown:hover{color:#fff!important;background-color:#795548!important}.cyan,.hover-cyan:hover{color:#000!important;background-color:#00bcd4!important}.blue-grey,.hover-blue-grey:hover{color:#fff!important;background-color:#607d8b!important}.green,.hover-green:hover{color:#fff!important;background-color:#4caf50!important}.hover-light-green:hover,.light-green{color:#000!important;background-color:#8bc34a!important}.hover-indigo:hover,.indigo{color:#fff!important;background-color:#3f51b5!important}.hover-khaki:hover,.khaki{color:#000!important;background-color:khaki!important}.hover-lime:hover,.lime{color:#000!important;background-color:#cddc39!important}.hover-orange:hover,.orange{color:#000!important;background-color:#ff9800!important}.deep-orange,.hover-deep-orange:hover{color:#fff!important;background-color:#ff5722!important}.hover-pink:hover,.pink{color:#fff!important;background-color:#e91e63!important}.hover-purple:hover,.purple{color:#fff!important;background-color:#9c27b0!important}.deep-purple,.hover-deep-purple:hover{color:#fff!important;background-color:#673ab7!important}.hover-red:hover,.red{color:#fff!important;background-color:#f44336!important}.hover-sand:hover,.sand{color:#000!important;background-color:#fdf5e6!important}.hover-teal:hover,.teal{color:#fff!important;background-color:#009688!important}.hover-yellow:hover,.yellow{color:#000!important;background-color:#ffeb3b!important}.hover-white:hover,.white{color:#000!important;background-color:#fff!important}.black,.hover-black:hover{color:#fff!important;background-color:#000!important}.grey,.hover-grey:hover{color:#000!important;background-color:#9e9e9e!important}.hover-light-grey:hover,.light-grey{color:#000!important;background-color:#f1f1f1!important}.dark-grey,.hover-dark-grey:hover{color:#fff!important;background-color:#616161!important}.hover-pale-red:hover,.pale-red{color:#000!important;background-color:#ffe7e7!important}.hover-pale-green:hover,.pale-green{color:#000!important;background-color:#e7ffe7!important}.hover-pale-yellow:hover,.pale-yellow{color:#000!important;background-color:#ffffd7!important}.hover-pale-blue:hover,.pale-blue{color:#000!important;background-color:#e7ffff!important}.text-align-right{text-align:right}.hover-text-amber:hover,.text-amber{color:#ffc107!important}.hover-text-aqua:hover,.text-aqua{color:#0ff!important}.hover-text-blue:hover,.text-blue{color:#2196f3!important}.hover-text-light-blue:hover,.text-light-blue{color:#87ceeb!important}.hover-text-brown:hover,.text-brown{color:#795548!important}.hover-text-cyan:hover,.text-cyan{color:#00bcd4!important}.hover-text-blue-grey:hover,.text-blue-grey{color:#607d8b!important}.hover-text-green:hover,.text-green{color:#4caf50!important}.hover-text-light-green:hover,.text-light-green{color:#8bc34a!important}.hover-text-indigo:hover,.text-indigo{color:#3f51b5!important}.hover-text-khaki:hover,.text-khaki{color:#b4aa50!important}.hover-text-lime:hover,.text-lime{color:#cddc39!important}.hover-text-orange:hover,.text-orange{color:#ff9800!important}.hover-text-deep-orange:hover,.text-deep-orange{color:#ff5722!important}.hover-text-pink:hover,.text-pink{color:#e91e63!important}.hover-text-purple:hover,.text-purple{color:#9c27b0!important}.hover-text-deep-purple:hover,.text-deep-purple{color:#673ab7!important}.hover-text-red:hover,.text-red{color:#f44336!important}.hover-text-sand:hover,.text-sand{color:#fdf5e6!important}.hover-text-teal:hover,.text-teal{color:#009688!important}.hover-text-yellow:hover,.text-yellow{color:#d2be0e!important}.hover-text-white:hover,.text-white{color:#fff!important}.hover-text-black:hover,.text-black{color:#000!important}.hover-text-grey:hover,.text-grey{color:#757575!important}.hover-text-light-grey:hover,.text-light-grey{color:#f1f1f1!important}.hover-text-dark-grey:hover,.text-dark-grey{color:#3a3a3a!important}.border-amber,.hover-border-amber:hover{border-color:#ffc107!important}.border-aqua,.hover-border-aqua:hover{border-color:#0ff!important}.border-blue,.hover-border-blue:hover{border-color:#2196f3!important}.border-light-blue,.hover-border-light-blue:hover{border-color:#87ceeb!important}.border-brown,.hover-border-brown:hover{border-color:#795548!important}.border-cyan,.hover-border-cyan:hover{border-color:#00bcd4!important}.border-blue-grey,.hover-blue-grey:hover{border-color:#607d8b!important}.border-green,.hover-border-green:hover{border-color:#4caf50!important}.border-light-green,.hover-border-light-green:hover{border-color:#8bc34a!important}.border-indigo,.hover-border-indigo:hover{border-color:#3f51b5!important}.border-khaki,.hover-border-khaki:hover{border-color:khaki!important}.border-lime,.hover-border-lime:hover{border-color:#cddc39!important}.border-orange,.hover-border-orange:hover{border-color:#ff9800!important}.border-deep-orange,.hover-border-deep-orange:hover{border-color:#ff5722!important}.border-pink,.hover-border-pink:hover{border-color:#e91e63!important}.border-purple,.hover-border-purple:hover{border-color:#9c27b0!important}.border-deep-purple,.hover-border-deep-purple:hover{border-color:#673ab7!important}.border-red,.hover-border-red:hover{border-color:#f44336!important}.border-sand,.hover-border-sand:hover{border-color:#fdf5e6!important}.border-teal,.hover-border-teal:hover{border-color:#009688!important}.border-yellow,.hover-border-yellow:hover{border-color:#ffeb3b!important}.border-white,.hover-border-white:hover{border-color:#fff!important}.border-black,.hover-border-black:hover{border-color:#000!important}.border-grey,.hover-border-grey:hover{border-color:#9e9e9e!important}.border-light-grey,.hover-border-light-grey:hover{border-color:#f1f1f1!important}.border-dark-grey,.hover-border-dark-grey:hover{border-color:#616161!important}.border-pale-red,.hover-border-pale-red:hover{border-color:#ffe7e7!important}.border-pale-green,.hover-border-pale-green:hover{border-color:#e7ffe7!important}.border-pale-yellow,.hover-border-pale-yellow:hover{border-color:#ffffd7!important}.border-pale-blue,.hover-border-pale-blue:hover{border-color:#e7ffff!important}.theme-l5{color:#000!important;background-color:#f6f8fc!important}.theme-l4{color:#000!important;background-color:#e1e9f6!important}.theme-l3{color:#000!important;background-color:#c3d3ed!important}.theme-l2{color:#000!important;background-color:#a5bee4!important}.theme-l1{color:#fff!important;background-color:#88a8db!important}.theme-d1{color:#fff!important;background-color:#5180cb!important}.theme-d2{color:#fff!important;background-color:#3a6fc3!important}.theme-d3{color:#fff!important;background-color:#3361aa!important}.theme-d4{color:#fff!important;background-color:#2c5392!important}.theme-d5{color:#fff!important;background-color:#24457a!important}.theme-light{color:#000!important;background-color:#f6f8fc!important}.theme-dark{color:#fff!important;background-color:#24457a!important}.theme-action{color:#fff!important;background-color:#24457a!important}.theme{color:#fff!important;background-color:#6a92d3!important}.text-theme{color:#6a92d3!important}.border-theme{border-color:#6a92d3!important}.hover-theme:hover{color:#fff!important;background-color:#6a92d3!important}.hover-text-theme:hover{color:#6a92d3!important}.hover-border-theme:hover{border-color:#6a92d3!important}body{background-color:#f7f7f7}.info-panel{padding:3px;color:#ff4500;border:1px solid #ff4500;background-color:#f89774}.info-panel2{padding:3px;color:#000;border:1px solid #025788;background-color:#a6dbfa}.error-panel{padding:3px;color:red;border:1px solid red;background-color:#fcb2b2}.table{table-layout:fixed}.text-line-through{text-decoration:line-through}#snackbar{visibility:hidden;min-width:250px;margin-left:-125px;background-color:#333;color:#fff;text-align:center;padding:16px;position:fixed;z-index:1;left:50%;bottom:30px;font-size:17px}#snackbar.show{visibility:visible;-webkit-animation:fadein .5s,fadeout .5s 2.5s;animation:fadein .5s,fadeout .5s 2.5s}@-webkit-keyframes fadein{from{bottom:0;opacity:0}to{bottom:30px;opacity:1}}@keyframes fadein{from{bottom:0;opacity:0}to{bottom:30px;opacity:1}}@-webkit-keyframes fadeout{from{bottom:30px;opacity:1}to{bottom:0;opacity:0}}@keyframes fadeout{from{bottom:30px;opacity:1}to{bottom:0;opacity:0}}.tabulator-header-filter>input{background-color:#fff;border:1px solid #ccc;font-weight:400}.readonly{pointer-events:none;color:#000!important;background-color:#d3d3d3!important}.readonlybasic{pointer-events:none;color:#000!important;background-color:#efefef!important;border:0!important}.right-side-bg{background:url(../img/bg1.jpg);background-size:cover;min-height:100vh}button{background-color:#f4f4f4;border:1pt solid #ccc;font-size:10pt;color:#000;line-height:1line;text-align:center}button:hover{background-color:#343434}button:pressed{background-color:#343434}button:focus{background-color:#343434}header{background-color:#fff;box-sizing:border-box}::-webkit-input-placeholder{color:rgba(60.3922%,60.3922%,60.3922%,1)}textarea{background-color:#fff;border-top-color:rgba(80%,80%,80%,1);border-right-color:rgba(80%,80%,80%,1);border-bottom-color:rgba(80%,80%,80%,1);border-left-color:rgba(80%,80%,80%,1);border-top-style:solid;border-right-style:solid;border-bottom-style:solid;border-left-style:solid;border-top-width:1pt;border-right-width:1pt;border-bottom-width:1pt;border-left-width:1pt;font-size:11pt;color:#000;line-height:1line;text-align:left}textarea:focus{border-top-color:rgba(0%,43.9216%,81.1765%,1);border-right-color:rgba(0%,43.9216%,81.1765%,1);border-bottom-color:rgba(0%,43.9216%,81.1765%,1);border-left-color:rgba(0%,43.9216%,81.1765%,1)}textarea:placeholder{color:rgba(80%,80%,80%,1)}textarea .scrollbar_track{width:30pt;top:0;right:0;bottom:0;position:absolute;box-sizing:border-box}footer{background-color:#fff;box-sizing:border-box}button.btnNavigation{background-color:rgba(0%,0%,0%,0);font-family:-fm-font-family(Arial,Arial-BoldMT);font-weight:700;font-size:10pt;color:#fff;padding-top:0;padding-right:0;padding-bottom:0;padding-left:0}.moduletoolbar{background:linear-gradient(163deg,rgba(127,175,79,1) 7%,rgba(94,162,89,1) 38%,rgba(39,154,200,1) 100%);color:#fff}div.PageHeadTitle{font-size:18pt;color:#fff}.SubHeadTitle{font-size:13pt;color:#fff;font-weight:400}div.SubHeadTitle{font-size:13pt;color:#fff}.toolbarbtn>.icon{font-size:16px}.inforow,tr.inforow{background-color:#efefef}tr.resultrow{background-color:#484848;color:#fff!important}.resultcol,td.resultcol{width:90px!important;text-align:right!important}.labelcol,td.labelcol,th.labelcol{width:150px!important}a.bodybtn,a.toolbarbtn,button.bodybtn,button.btninverse,button.toolbarbtn{margin:2px;padding:4px 8px;background-color:#343434!important;border-radius:6px;border:.5px solid #c6c6c6!important;color:#fff}button.btninverse{background-color:#fff!important;color:#343434}a.bodybtn,a.toolbarbtn{text-align:center;text-decoration:unset;font-size:10pt!important}a.bodybtn:hover,a.toolbarbtn:hover,button.bodybtn:hover,button.btninverse:hover,button.toolbarbtn:hover{background-color:#343434!important;color:#ffe100}a.bodybtn:pressed,a.toolbarbtn:pressed,button.bodybtn:pressed,button.btninverse:pressed,button.toolbarbtn:pressed{background-color:#343434!important;color:#fff}a.bodybtn:focus,a.toolbarbtn:focus,button.bodybtn:focus,button.btninverse:focus,button.toolbarbtn:focus{border-color:#ccc!important}div.toolbar{background:linear-gradient(163deg,rgba(127,175,79,1) 7%,rgba(94,162,89,1) 38%,rgba(39,154,200,1) 100%)}::-webkit-scrollbar{-webkit-appearance:none;width:10px}::-webkit-scrollbar-track{background-color:rgba(80%,80%,80%,.5)}::-webkit-scrollbar-thumb{border-radius:0;background-color:rgba(0,0,0,.5);-webkit-box-shadow:0 0 1px rgba(255,255,255,.5)}select{display:block;color:#000;line-height:1line;text-align:left;padding:3.5px;width:100%;max-width:100%;box-sizing:border-box;margin:0;border:1px solid #ccc;border-radius:0;font-weight:400;font-size:11pt;background-color:#fff}select:focus{border:1px solid #3a6fc3;border-radius:unset}::-webkit-select-placeholder{color:#9a9a9a}div.DataFooter{background:#384462}:focus{outline:unset}input{background-color:#fff;border:1px solid #ccc;font-weight:400;font-size:11pt;color:#000;line-height:1line;text-align:left;width:100%;padding:2px;display:block;border-radius:unset}input:focus{border:1px solid #3a6fc3;border-radius:unset}input[type=number]::-webkit-inner-spin-button,input[type=number]::-webkit-outer-spin-button{-webkit-appearance:none;margin:0}input:read-only{color:#000!important;background-color:#d3d3d3}input[class=currency]{padding:2px;padding-right:12px;text-align:right;background-image:url(data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20width=%22225%22%20height=%22300%22%3E%3Cpath%20stroke=%22none%22%20d=%22m%20224.99996,16.22698%20-8.11342,36.41161%20q%20-24.14255,-19.78892%20-54.61741,-19.78892%20-41.3588,0%20-65.00658,23.74671%20-23.647774,23.7467%20-28.397115,53.23215%20l%20134.960355,0%20-5.14505,26.71508%20-132.981532,0%20-0.395848,7.71771%200.395848,18.20566%20127.242642,0%20-5.14505,26.71508%20-117.941954,0%20q%207.519719,40.17154%2032.552754,59.06997%2025.03303,18.89844%2056.49745,18.89844%2037.20302,0%2057.98149,-19.59107%20l%200,40.9631%20Q%20192.34828,300%20162.26913,300%2053.034301,300%2030.474864,189.18206%20l%20-30.474864,0%205.738751,-26.71508%2020.580475,0%20q%20-0.395708,-4.74934%20-0.395708,-17.80995%20l%200,-8.11342%20-25.923518,0%205.738751,-26.71508%2023.152999,0%20Q%2039.181988,55.21112%2076.583149,27.60556%20113.98417,0%20163.06069,0%20199.868,0%20224.99996,16.22698%20z%22%20/%3E%0A%3C/svg%3E),linear-gradient(to bottom,#fff 0,#fff 100%);background-repeat:no-repeat,repeat;background-position:right 2px top 50%,0 0;background-size:9px auto,100%}input[class=currency]:read-only{background-image:url(data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20width=%22225%22%20height=%22300%22%3E%3Cpath%20stroke=%22none%22%20d=%22m%20224.99996,16.22698%20-8.11342,36.41161%20q%20-24.14255,-19.78892%20-54.61741,-19.78892%20-41.3588,0%20-65.00658,23.74671%20-23.647774,23.7467%20-28.397115,53.23215%20l%20134.960355,0%20-5.14505,26.71508%20-132.981532,0%20-0.395848,7.71771%200.395848,18.20566%20127.242642,0%20-5.14505,26.71508%20-117.941954,0%20q%207.519719,40.17154%2032.552754,59.06997%2025.03303,18.89844%2056.49745,18.89844%2037.20302,0%2057.98149,-19.59107%20l%200,40.9631%20Q%20192.34828,300%20162.26913,300%2053.034301,300%2030.474864,189.18206%20l%20-30.474864,0%205.738751,-26.71508%2020.580475,0%20q%20-0.395708,-4.74934%20-0.395708,-17.80995%20l%200,-8.11342%20-25.923518,0%205.738751,-26.71508%2023.152999,0%20Q%2039.181988,55.21112%2076.583149,27.60556%20113.98417,0%20163.06069,0%20199.868,0%20224.99996,16.22698%20z%22%20/%3E%0A%3C/svg%3E),linear-gradient(to bottom,#d3d3d3 0,#d3d3d3 100%)}input[class=percent]{padding:2px;padding-right:12px;text-align:right;background-image:url('data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20width=%22256%22%20height=%22232%22%20version=%221.0%22%3E%3Cg%20transform=%22translate(-112.3674,-128.3649)%22%3E%3Cpath%20style=%22fill:black;fill-opacity:1;stroke:none%22%20d=%22M%20317.1674,257.53698%20C%20308.53463,257.53708%20301.73774,261.20839%20296.77671,268.55094%20C%20291.91449,275.89365%20289.48349,286.1138%20289.48368,299.2114%20C%20289.48349,312.11067%20291.91449,322.2812%20296.77671,329.72303%20C%20301.73774,337.06568%20308.53463,340.737%20317.1674,340.73698%20C%20325.60128,340.737%20332.24934,337.06568%20337.11159,329.72303%20C%20342.07258,322.2812%20344.5532,312.11067%20344.55345,299.2114%20C%20344.5532,286.21302%20342.07258,276.04249%20337.11159,268.69977%20C%20332.24934,261.25801%20325.60128,257.53708%20317.1674,257.53698%20M%20317.1674,238.63466%20C%20332.84469,238.63477%20345.29739,244.09213%20354.52554,255.00675%20C%20363.75318,265.92157%20368.36713,280.65644%20368.3674,299.2114%20C%20368.36713,317.76648%20363.70357,332.50135%20354.37671,343.41605%20C%20345.14855,354.23156%20332.74546,359.6393%20317.1674,359.63931%20C%20301.29123,359.6393%20288.7393,354.23156%20279.51159,343.41605%20C%20270.28351,332.50135%20265.66956,317.76648%20265.66973,299.2114%20C%20265.66956,280.55721%20270.28351,265.82234%20279.51159,255.00675%20C%20288.83853,244.09213%20301.39045,238.63477%20317.1674,238.63466%20M%20163.5674,147.9928%20C%20155.03401,147.993%20148.28673,151.71393%20143.32554,159.15559%20C%20138.46349,166.49841%20136.03248,176.61933%20136.03252,189.51838%20C%20136.03248,202.61621%20138.46349,212.83635%20143.32554,220.17884%20C%20148.18751,227.52161%20154.93479,231.19292%20163.5674,231.1928%20C%20172.19989,231.19292%20178.94717,227.52161%20183.80926,220.17884%20C%20188.77041,212.83635%20191.25103,202.61621%20191.25113,189.51838%20C%20191.25103,176.71856%20188.77041,166.59764%20183.80926,159.15559%20C%20178.84794,151.71393%20172.10066,147.993%20163.5674,147.9928%20M%20297.9674,129.09047%20L%20321.78136,129.09047%20L%20182.7674,359.63931%20L%20158.95345,359.63931%20L%20297.9674,129.09047%20M%20163.5674,129.09047%20C%20179.24484,129.0907%20191.74715,134.54806%20201.07438,145.46256%20C%20210.4014,156.27827%20215.06496,170.96352%20215.06508,189.51838%20C%20215.06496,208.27201%20210.4014,223.05649%20201.07438,233.87187%20C%20191.84638,244.68748%20179.34406,250.09523%20163.5674,250.09512%20C%20147.79061,250.09523%20135.28829,244.68748%20126.06043,233.87187%20C%20116.93172,222.95727%20112.36739,208.17279%20112.3674,189.51838%20C%20112.36739,171.06275%20116.98134,156.37749%20126.20926,145.46256%20C%20135.43713,134.54806%20147.88983,129.0907%20163.5674,129.09047%22%20/%3E%3C/g%3E%3C/svg%3E'),linear-gradient(to bottom,#fff 0,#fff 100%);background-repeat:no-repeat,repeat;background-position:right 2px top 50%,0 0;background-size:9px auto,100%}label{height:12.8px!important;color:#000;font-size:8pt}input[type=checkbox]{display:block;-webkit-appearance:none;height:29.66px;width:29.66px;cursor:pointer;position:relative;-webkit-transition:.15s;border-radius:unset;border:1px solid #ccc;background-color:#fff}input[type=checkbox]:checked{background-color:#fff}input[type=checkbox]:before,input[type=checkbox]:checked:before{position:absolute;top:0;left:0;width:100%;height:100%;line-height:2em;text-align:center;color:#000;content:''}input[type=checkbox]:checked:before{font-size:11pt;content:'✔'}input[type=checkbox]:hover:before{background:rgba(255,255,255,.3)}input[type=color]{-webkit-appearance:none;width:120px;height:35px}input[type=color]::-webkit-color-swatch-wrapper{padding:0}input[type=color]::-webkit-color-swatch{border:none}:focus{outline:1px solid #607d8b}.modal-content>header{background-color:var(--color-btn1);color:#fff;padding:8px!important;margin-bottom:10px}.modal-content>header>h2{font-size:13pt}.modal-content>footer{text-align:right!important;color:#000!important;background-color:#c6c6c6!important;margin-top:6px;padding-top:8px!important;padding-bottom:8px!important}.modal-content>footer:after,.modal-content>footer:before,.modal-content>header:after,.modal-content>header:before{content:"";display:table;clear:both}span[class^=icon]::after{content:"\A";white-space:pre}span[class^=icon-inline]::after{content:" "}span[class^=rowicon]::after{content:"\A";white-space:nowrap}a.inlinebtn{border:.5px solid #c6c6c6;color:red;text-align:center;text-decoration:unset;font-size:8pt!important;position:relative;height:28px;margin-top:-28px;margin-left:-20px;padding:4px 8px;border:0!important;float:right}a.inlinebtn:hover{background-color:#343434!important;color:#fff}a.inlinebtn:pressed{background-color:#343434!important;color:#fff}a.inlinebtn:focus{border-color:#ccc!important}.dspvacancynormal{color:#000}.dspvacancyill{color:red}.dspvacancyextra{color:#00f}#help_page{font-size:13pt;margin-left:30px;padding-bottom:30px!important}#help_page img{margin-left:40px}#help_page blockquote{background-color:#c5c5c5;padding:6px;border-left:5px solid red}#help_page hr{border-top:1px solid #757575}.lds-spinner{color:official;display:inline-block;position:relative;width:80px;height:80px}.lds-spinner div{transform-origin:40px 40px;animation:lds-spinner 1.2s linear infinite}.lds-spinner div:after{content:" ";display:block;position:absolute;top:3px;left:37px;width:6px;height:18px;border-radius:20%;background:#000}.lds-spinner div:nth-child(1){transform:rotate(0);animation-delay:-1.1s}.lds-spinner div:nth-child(2){transform:rotate(30deg);animation-delay:-1s}.lds-spinner div:nth-child(3){transform:rotate(60deg);animation-delay:-.9s}.lds-spinner div:nth-child(4){transform:rotate(90deg);animation-delay:-.8s}.lds-spinner div:nth-child(5){transform:rotate(120deg);animation-delay:-.7s}.lds-spinner div:nth-child(6){transform:rotate(150deg);animation-delay:-.6s}.lds-spinner div:nth-child(7){transform:rotate(180deg);animation-delay:-.5s}.lds-spinner div:nth-child(8){transform:rotate(210deg);animation-delay:-.4s}.lds-spinner div:nth-child(9){transform:rotate(240deg);animation-delay:-.3s}.lds-spinner div:nth-child(10){transform:rotate(270deg);animation-delay:-.2s}.lds-spinner div:nth-child(11){transform:rotate(300deg);animation-delay:-.1s}.lds-spinner div:nth-child(12){transform:rotate(330deg);animation-delay:0s}@keyframes lds-spinner{0%{opacity:1}100%{opacity:0}}.potcurrent{background-color:rgb(225,235,52,.5)!important}.potcurrent:hover{background-color:rgb(187,187,187,.5)!important;cursor:pointer}.tabulator-selected.potcurrent{background-color:#9abcea!important;cursor:pointer}.tabulator-selected.potcurrent:hover{background-color:rgb(154,188,234,.5)!important;cursor:pointer}.datefield{width:110px!important}.dateselect{padding:4px;text-align:center}.lbldateselect{padding-left:2px;display:block}.dtnav{height:50px;padding-left:0!important;padding-right:0!important;margin-top:2px;background-color:#394462!important;border-top:.5px solid #c6c6c6!important;border-bottom:.5px solid #c6c6c6!important}.bold{font-weight:700}form{margin-bottom:20px}.tabulator .tabulator-header .tabulator-col{background-color:var(--color-btn1)}.tabulator .tabulator-header{border-bottom:3px solid var(--color-btn1)}.tabulator .tabulator-footer{padding:5px 10px;padding-top:8px;border-top:3px solid var(--color-btn1)}.tabulator .tabulator-footer .tabulator-calcs-holder{margin:-8px -10px 8px -10px;background:var(--color-btn1)!important;border-top:none;border-bottom:1px solid #aaa}.tabulator .tabulator-footer .tabulator-calcs-holder .tabulator-row{background:var(--color-btn1)!important;color:#fff!important}.tabulator-row .tabulator-cell.tabulator-frozen{display:inline-block;position:sticky;left:0;background-color:var(--color-btn1);z-index:11} \ No newline at end of file diff --git a/public_html/lib/App/Cotisations.php b/public_html/lib/App/Cotisations.php index cfc5327..ab1e27c 100644 --- a/public_html/lib/App/Cotisations.php +++ b/public_html/lib/App/Cotisations.php @@ -24,7 +24,7 @@ class Cotisations extends stdClass { public function getList($monthdate){ $sql ="SELECT mc.id, mc.id_member, mc.date_month, mc.date_transaction, mc.status, mc.sepa_file_out, mc.transaction_file_in, mc.transaction_id, mc.last_sepa_code, mc.amount, mc.paymenttype, mc.created, mc.modified, -unaccent(UPPER(m.firstname)) as firstname,unaccent(UPPER(m.lastname)) as lastname FROM members_cotisation mc join members m on (m.ID_member=mc.id_member) where mc.date_month = date(".$this->dbh->value($monthdate).");"; +unaccent(UPPER(m.firstname)) as firstname,unaccent(UPPER(m.lastname)) as lastname,mc.bank_account,mc.sepa_type,mc.bank_bic FROM members_cotisation mc join members m on (m.ID_member=mc.id_member) where mc.date_month = date(".$this->dbh->value($monthdate).");"; return $this->dbh->queryarray($sql); } @@ -32,8 +32,9 @@ unaccent(UPPER(m.firstname)) as firstname,unaccent(UPPER(m.lastname)) as lastnam $sql = "SELECT mc.id, mc.id_member, mc.date_month, m.firstname,m.lastname, mc.status, mc.amount, mc.date_transaction, mc.sepa_file_out, mc.transaction_file_in, mc.transaction_id, mc.last_sepa_code, mc.paymenttype, mc.created, mc.modified,m.bankaccount,m.bankbic FROM members_cotisation mc join members m on (mc.id_member=m.ID_member) - where mc.paymenttype ='SEPA' and (mc.status is null or mc.status = 'error') and mc.amount > 0 and m.id_member not in (select ID_dependent from members_dependents md) order by mc.date_month desc;"; + where mc.paymenttype ='SEPA' and (mc.status ='open' or mc.status = 'error') and mc.amount > 0 and m.id_member not in (select ID_dependent from members_dependents md) order by mc.date_month desc;"; return $this->dbh->queryarray($sql); + //return array(); //$ } public function getUnpaidVirList($idmember){ @@ -44,10 +45,22 @@ and (mc.status != 'payed' or mc.status is null) and mc.id_member=".$this->dbh->v } public function getRowData($id){ - $sql = "SELECT id, id_member, date_month,DATE_FORMAT(date_month,'%m/%Y') as dspdate_month, date_transaction, status, sepa_file_out, transaction_file_in, transaction_id, last_sepa_code, amount, paymenttype, created, modified FROM members_cotisation where id=".$this->dbh->value($id).";"; + $sql = "SELECT id, id_member, date_month,DATE_FORMAT(date_month,'%m/%Y') as dspdate_month, date_transaction, status, sepa_file_out, transaction_file_in, transaction_id, last_sepa_code, amount, paymenttype,bank_account,bank_bic,sepa_type, created, modified FROM members_cotisation where id=".$this->dbh->value($id).";"; return $this->dbh->query($sql); } + public function getExportSepaRowData($id){ + $sql = "SELECT *,DATE_FORMAT(date_month,'%m/%Y') as dspdate_month FROM nextsepaexport where id=".$this->dbh->value($id).";"; + return $this->dbh->query($sql); + } + + public function saveExportSepaRow($id,$data){ + $updsql = $this->dbh->createUpdateDDL("saveExportSepaRow",array("id" => $id),$data); + $ret = $this->dbh->exec($updsql); + return $ret; + } + + public function saveRow($id,$data){ $updsql = $this->dbh->createUpdateDDL("members_cotisation",array("id" => $id),$data); $ret = $this->dbh->exec($updsql); @@ -60,20 +73,23 @@ unaccent(UPPER(m.firstname)) as firstname,unaccent(UPPER(m.lastname)) as lastnam return $this->dbh->queryarray($sql); } - public function addCotisationMonth(){ - //if ($monthdate == null){ + public function addCotisationMonth($monthdate){ + if ($monthdate == "latest"){ $res = $this->dbh->query("select DATE_Add(max(date_month), interval 1 month) as date_month from members_cotisation mc;"); - - $sql ="insert into members_cotisation (ID_member,date_month,amount,paymenttype) - select mx.ID_member,date(".$this->dbh->value($res["date_month"]).") as date_month,mx.quota as amount,case when mx.sepasigned = 1 and mx.datesepasigned <= date(".$this->dbh->value($res["date_month"]).") then 'SEPA' else 'VIR' end as paymenttype from members mx + $monthdate = $res["date_month"]; + } + $sql ="insert into members_cotisation (ID_member,date_month,amount,paymenttype,status,bank_account,bank_bic) + select mx.ID_member,date(".$this->dbh->value($monthdate).") as date_month,mx.quota as amount,case when mx.sepasigned = 1 and mx.datesepasigned <= date(".$this->dbh->value($monthdate).") then 'SEPA' else 'VIR' end as paymenttype, case when mx.quota > 0 then 'open' else null end as status ,m.bankaccount as bank_account, m.bankbic as bank_bic from members mx join (select m.ID_member, case when m.datein < date('2007-01-01') then date('2007-01-01') else m.datein end as datein, - case when m.daterelease is null then date(".$this->dbh->value($res["date_month"]).") else m.daterelease end as daterelease + case when m.daterelease is null then date(".$this->dbh->value($monthdate).") else m.daterelease end as daterelease from members m where m.daterelease is null or m.daterelease > date('2007-01-01') and m.ID_member not in (select ID_member from members_dependents md) - ) aa on (mx.ID_member=aa.ID_member) where date(".$this->dbh->value($res["date_month"]).") between aa.datein and aa.daterelease;"; + ) aa on (mx.ID_member=aa.ID_member) where date(".$this->dbh->value($monthdate).") between aa.datein and aa.daterelease and mx.id_member not in (select id_member from members_cotisation where date_month=date(".$this->dbh->value($monthdate)."));"; $resa = $this->dbh->exec($sql); + $sql2 = "UPDATE members_cotisation mc join members m ON (mc.id_member =m.ID_member and mc.date_month=date(".$this->dbh->value($monthdate).")) set mc.bank_account = m.bankaccount ,mc.bank_bic=m.bankbic ,mc.amount =m.quota ,mc.paymenttype=case when m.sepasigned = '1' and m.datesepasigned <= CURRENT_DATE() and mc.paymenttype != 'CAISSE' then 'SEPA' else 'VIR' end where mc.id_member =m.ID_member and mc.date_month=date(".$this->dbh->value($monthdate).");"; + $resa = $this->dbh->exec($sql2); return $resa; } @@ -93,23 +109,62 @@ unaccent(UPPER(m.firstname)) as firstname,unaccent(UPPER(m.lastname)) as lastnam return $res; } - public function checkSepaTransactions($monthdate){ + public function updateMembers($idmember){ + $res = null; + if ($idmember != null){ + $res = $this->dbh->query("select case when m.quota is null then 0 else m.quota end as amount,case when m.sepasigned ='1' then 'SEPA' else 'VIR' end as paymenttype,dx.date_month from members m join + (select id_member,date_month from ( + select id_member,DATE_Add(max(date_month), interval 1 month) as date_month from members_cotisation mc where id_member=".$this->dbh->value($idmember)." + union + select ID_member as id_member,STR_TO_DATE(CONCAT(YEAR(datein), '-', MONTH(datein), '-01'), '%Y-%m-%d') as date_month from members where ID_member=".$this->dbh->value($idmember).") dd order by date_month desc LIMIT 1) dx on (m.ID_member=dx.id_member);"); + if (isset($res["date_month"])){ + $sql = "insert into members_cotisation (ID_member,date_month,amount,paymenttype) VALUES (".$this->dbh->value($idmember).",date(".$this->dbh->value($res["date_month"])."),".$this->dbh->value($res["amount"]).",".$this->dbh->value($res["paymenttype"]).");"; + $this->dbh->exec($sql); + } + } + return $res; + } + + public function syncSepaTransactions($monthdate){ //first get all payed with success! $sql1 = "UPDATE members_cotisation mc - JOIN ( select group_concat( mq.ID_member_quota) as idmq,mq.ID_member,date(CONCAT(mq.year,'-',mq.month,'-01')) as date_month,mq.quota as amount,mq.datemovement as date_transaction,'payed' as status, mq.filexml as transaction_file_in, + JOIN ( select group_concat( mq.ID_member_quota) as idmq,mq.ID_member,date(CONCAT(mq.year,'-',mq.month,'-01')) as date_month,mq.quota as amount,mq.datemovement as date_transaction,'payed' as status, mq.filexml as transaction_file_in,mq.accountout as bank_account, mq.refxml as sepa_file_out,mq.stsid as transaction_id,mq.errorcode as last_sepa_code,count(mq.ID_member_quota) as cnt from members_quotas mq where mq.success=1 group by mq.ID_member,mq.year,mq.month ) mq ON mc.id_member =mq.ID_member AND mc.date_month=mq.date_month - SET mc.amount=mq.amount,mc.status=mq.status,mc.date_transaction=mq.date_transaction,mc.transaction_file_in=mq.transaction_file_in,mc.sepa_file_out=mq.sepa_file_out,mc.transaction_id=mq.transaction_id where mc.date_month=date(".$this->dbh->value($monthdate).");"; + SET mc.amount=mq.amount,mc.status=mq.status,mc.date_transaction=mq.date_transaction,mc.transaction_file_in=mq.transaction_file_in,mc.sepa_file_out=mq.sepa_file_out,mc.transaction_id=mq.transaction_id,mc.bank_account=mq.bank_account where mc.date_month=date(".$this->dbh->value($monthdate).");"; $this->dbh->exec($sql1); //get other (error) $sql2 = "UPDATE members_cotisation mc - JOIN ( select * from ( select max( mq.ID_member_quota) as idmq,mq.ID_member,date(CONCAT(mq.year,'-',mq.month,'-01')) as date_month,mq.quota as amount,max(mq.datemovement) as date_transaction,'open' as status, max(mq.filexml) as transaction_file_in, + JOIN ( select * from ( select max( mq.ID_member_quota) as idmq,mq.ID_member,date(CONCAT(mq.year,'-',mq.month,'-01')) as date_month,mq.quota as amount,max(mq.datemovement) as date_transaction,'open' as status, max(mq.filexml) as transaction_file_in,mq.accountout as bank_account, max(mq.refxml) as sepa_file_out,mq.stsid as transaction_id,mq.errorcode as last_sepa_code,count(mq.ID_member_quota) as cnt,sum(mq.success) as s_ok from members_quotas mq group by mq.ID_member,mq.year,mq.month) aa where aa.s_ok=0 ) mq ON mc.id_member =mq.ID_member AND mc.date_month=mq.date_month - SET mc.amount=mq.amount,mc.status=mq.status,mc.date_transaction=mq.date_transaction,mc.transaction_file_in=mq.transaction_file_in,mc.sepa_file_out=mq.sepa_file_out,mc.transaction_id=mq.transaction_id where mc.date_month=date(".$this->dbh->value($monthdate).")"; + SET mc.amount=mq.amount,mc.status=mq.status,mc.date_transaction=mq.date_transaction,mc.transaction_file_in=mq.transaction_file_in,mc.sepa_file_out=mq.sepa_file_out,mc.transaction_id=mq.transaction_id,mc.bank_account=mq.bank_account where mc.date_month=date(".$this->dbh->value($monthdate).")"; $this->dbh->exec($sql2); return 1; } + + public function getExportTable(){ + $sql = "select * from nextsepaexport;"; + return $this->dbh->queryarray($sql); + } + + public function cleanExportTable(){ + $sql = "truncate table nextsepaexport;"; + $this->dbh->exec($sql);$this->dbh->exec($sql); + return 1; + } + + public function addToExportTable($ids){ + $sql = " REPLACE INTO nextsepaexport (id,id_member,amount,date_month,sepasig_date,bic,fullname,iban,message,sepa_type) + select mc.id,m.ID_member as id_member,mc.amount,mc.date_month, m.datesepasigned as sepasig_date , b.biccode as bic,unaccent(UPPER(CONCAT(m.lastname,' ',m.firstname))) as fullname, + replace(m.bankaccount,' ','') as iban,CONCAT('NGL-SNEP ',date_format(mc.date_month,'%m/%Y')) as message,case when sum(case when mx.cntstatus > 0 then 1 else 0 end) > 0 then 'RCUR' else 'FRST' end as sepa_type + from members m + join members_cotisation mc on (m.ID_member=mc.id_member) + left join (select id_member,count(status) as cntstatus from members_cotisation where status='payed' group by id_member) mx on (mx.id_member=m.ID_member) + join banks b on (m.ID_bank=b.ID_bank) where mc.id In (".implode(",",$ids).") and m.sepasigned = 1 + group by mc.id;"; + $this->dbh->exec($sql); + } } ?> \ No newline at end of file diff --git a/public_html/lib/App/Sepa.php b/public_html/lib/App/Sepa.php index f1117f6..66e962a 100644 --- a/public_html/lib/App/Sepa.php +++ b/public_html/lib/App/Sepa.php @@ -13,7 +13,7 @@ class Sepa extends stdClass { $this->dbh = null; } - public function createSepa($debitdate,$month,$year,$unpaiddata){ + public function createSepa($debitdate){ $pp = new WorkerProcess($this->dbh,$this->cfg); $phpexe='php'; if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') { @@ -23,12 +23,12 @@ class Sepa extends stdClass { } $xmlfile=date('Ymd_his').".xml"; $params = ""; - if (isset($month) && $month>0 && isset($year) && $year> 0){ - $params .= "-m ".$month." -y ".$year." "; - } - if (isset($unpaiddata) && count($unpaiddata) > 0){ - $params .= " -ids ".implode(",",$unpaiddata); - } + // if (isset($month) && $month>0 && isset($year) && $year> 0){ + // $params .= "-m ".$month." -y ".$year." "; + // } + // if (isset($unpaiddata) && count($unpaiddata) > 0){ + // $params .= " -ids ".implode(",",$unpaiddata); + // } $pinfo = $pp->executeCli($phpexe." ".$this->cfg["scripts"]."exportsepaxml.php"." -f ".$xmlfile." -d ".$debitdate." ".$params,"exportsepa"); $pinfo["file"] = "exportsepa/".$xmlfile; return $pinfo; diff --git a/public_html/scripts/exportsepaxml.php b/public_html/scripts/exportsepaxml.php index 356bcb4..2f7b4ac 100644 --- a/public_html/scripts/exportsepaxml.php +++ b/public_html/scripts/exportsepaxml.php @@ -15,22 +15,22 @@ $i++; $p["file"] = $argv[$i]; break; - case "-m": - $i++; - $p["month"] = $argv[$i]; - break; - case "-y": - $i++; - $p["year"] = $argv[$i]; - break; + // case "-m": + // $i++; + // $p["month"] = $argv[$i]; + // break; + // case "-y": + // $i++; + // $p["year"] = $argv[$i]; + // break; case "-d": $i++; $p["debitdate"] = $argv[$i]; break; - case "-ids": - $i++; - $p["ids"] = explode(",",$argv[$i]); - break; + // case "-ids": + // $i++; + // $p["ids"] = explode(",",$argv[$i]); + // break; default: echo "arg: {$argv[$i]}\n"; } @@ -53,26 +53,27 @@ $msgid=date('Ymd_His'); $dateTime_EMCA=date('Y-m-d')."T".date('H:i:s'); $pmtinf = array(); - if (isset($p["month"]) && $p["month"]>0 && isset($p["year"]) && $p["year"]> 0){ - echo "recherche des membres pour le mois ".$p["month"]."/".$p["year"]."!\n"; - $sql = "select mc.id,m.ID_member,m.quota as memberquota, m.datesepasigned as sepasignaturedate , b.biccode as memberbic,unaccent(UPPER(CONCAT(m.lastname,' ',m.firstname))) as memberfullname, - replace(m.bankaccount,' ','') as memberiban,CONCAT('NGL-SNEP ','".str_pad($p["month"], 2, "0", STR_PAD_LEFT )."','/','".$p["year"]."') as sepamsg,case when sum(case when mx.cntstatus > 0 then 1 else 0 end) > 0 then 'RCUR' else 'FRST' end as seqtype - from members m - join members_cotisation mc on (m.ID_member=mc.id_member) - left join (select id_member,count(status) as cntstatus from members_cotisation where status is not null and status != 'error' group by id_member) mx on (mx.id_member=m.ID_member) - join banks b on (m.ID_bank=b.ID_bank) - where m.sepasigned=1 and (m.daterelease is null or m.daterelease >= date('".$p["year"]."-".str_pad($p["month"], 2, "0", STR_PAD_LEFT )."-01')) and m.id_famillycommon is null and m.ID_bank > 0 and CHAR_LENGTH(bankaccount) >= 16 - group by m.ID_member;"; + // if (isset($p["month"]) && $p["month"]>0 && isset($p["year"]) && $p["year"]> 0){ + echo "recherche des membres à exporter!\n"; + $sql = "select * from nextsepaexport;"; + // $sql = "select mc.id,m.id_member,m.quota as amount, m.datesepasigned as sepasig_date , b.biccode as bic,unaccent(UPPER(CONCAT(m.lastname,' ',m.firstname))) as fullname, + // replace(m.bankaccount,' ','') as iban,CONCAT('NGL-SNEP ','".str_pad($p["month"], 2, "0", STR_PAD_LEFT )."','/','".$p["year"]."') as message,case when sum(case when mx.cntstatus > 0 then 1 else 0 end) > 0 then 'RCUR' else 'FRST' end as seqtype + // from members m + // join members_cotisation mc on (m.id_member=mc.id_member) + // left join (select id_member,count(status) as cntstatus from members_cotisation where status is not null and status != 'error' group by id_member) mx on (mx.id_member=m.id_member) + // join banks b on (m.ID_bank=b.ID_bank) + // where m.sepasigned=1 and (m.daterelease is null or m.daterelease >= date('".$p["year"]."-".str_pad($p["month"], 2, "0", STR_PAD_LEFT )."-01')) and m.id_famillycommon is null and m.ID_bank > 0 and CHAR_LENGTH(bankaccount) >= 16 + // group by m.id_member;"; //echo $sql."\n"; - // m.ID_member not in (select ID_dependent from members_dependents md) + // m.id_member not in (select ID_dependent from members_dependents md) //and m.dateretired is null //file_put_contents($cfg["datapath"]."tmp/debug.log","SQL Export: ".$sql."\n",FILE_APPEND); $pmtinf = $db->queryarray($sql); - echo "XX:".print_r($pmtinf,true)."\n"; - echo "DB:".print_r($db,true)."\n"; + // echo "XX:".print_r($pmtinf,true)."\n"; + // echo "DB:".print_r($db,true)."\n"; $totaltx=count($pmtinf); echo "total membres: ".count($pmtinf)."\n"; - } + // } $sepaxml = "".$CrLf; $sepaxml .= " ".$CrLf; @@ -80,65 +81,65 @@ // SEPA File Header // SEPA Group header //file_put_contents("log/debug.log","Pmt_inf:\n".print_r($p["ids"],true),FILE_APPEND); - if (isset($p["ids"]) && count($p["ids"]) > 0){ + // if (isset($p["ids"]) && count($p["ids"]) > 0){ - //file_put_contents("log/debug.log","parse unpaiddata:\n",FILE_APPEND); - //foreach ($p["ids"] as $up){ + // //file_put_contents("log/debug.log","parse unpaiddata:\n",FILE_APPEND); + // //foreach ($p["ids"] as $up){ - //file_put_contents("log/debug.log","parse unpaiddata:".print_r($p["ids"],true)."\n",FILE_APPEND); - $sql = "select mc.id,m.ID_member,m.quota as memberquota, m.datesepasigned as sepasignaturedate , b.biccode as memberbic,CONCAT(m.lastname,' ',m.firstname) as memberfullname, - m.bankaccount as memberiban,CONCAT('NGL-SNEP ', DATE_FORMAT(mc.date_month,'%m/%Y')) as sepamsg,case when sum(case when mx.cntstatus > 0 then 1 else 0 end) > 0 then 'RCUR' else 'FRST' end as seqtype - from members m - join members_cotisation mc on (m.ID_member=mc.id_member) - left join (select id_member,count(status) as cntstatus from members_cotisation where status is not null and status != 'error' group by id_member) mx on (mx.id_member=m.ID_member) - join banks b on (m.ID_bank=b.ID_bank) - where mc.id in (".implode(",",$p["ids"]).") and m.ID_bank > 0 and CHAR_LENGTH(bankaccount) >= 16 - group by m.ID_member;"; - $upval = $db->queryarray($sql); - foreach ($upval as $up){ - echo "add ".print_r($up,true); - array_push($pmtinf,$up); - } + // //file_put_contents("log/debug.log","parse unpaiddata:".print_r($p["ids"],true)."\n",FILE_APPEND); + // $sql = "select mc.id,m.id_member,m.quota as amount, m.datesepasigned as sepasig_date , b.biccode as bic,CONCAT(m.lastname,' ',m.firstname) as fullname, + // m.bankaccount as iban,CONCAT('NGL-SNEP ', DATE_FORMAT(mc.date_month,'%m/%Y')) as message,case when sum(case when mx.cntstatus > 0 then 1 else 0 end) > 0 then 'RCUR' else 'FRST' end as seqtype + // from members m + // join members_cotisation mc on (m.id_member=mc.id_member) + // left join (select id_member,count(status) as cntstatus from members_cotisation where status is not null and status != 'error' group by id_member) mx on (mx.id_member=m.id_member) + // join banks b on (m.ID_bank=b.ID_bank) + // where mc.id in (".implode(",",$p["ids"]).") and m.ID_bank > 0 and CHAR_LENGTH(bankaccount) >= 16 + // group by m.id_member;"; + // $upval = $db->queryarray($sql); + // foreach ($upval as $up){ + // echo "add ".print_r($up,true); + // array_push($pmtinf,$up); + // } - $totaltx = count($pmtinf); - echo "Ajout de $upval Transaction 'nonpayé'\n"; - //} - } + // $totaltx = count($pmtinf); + // echo "Ajout de $upval Transaction 'nonpayé'\n"; + // //} + // } echo "Total Transaction fichier:".$totaltx."\n"; $sepa_pmtinf = array(); $sumall=0.00; $countall=0; $updids=array(); foreach ($pmtinf as $py){ - if (isset($py["ID_member"])){ - array_push($updids,$py["ID_member"]); + if (isset($py["id_member"])){ + array_push($updids,$py["id"]); $DrctDbtTxInf = " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; - $DrctDbtTxInf .= " ".$py["ID_member"]."".$CrLf; - $DrctDbtTxInf .= " ".$py["ID_member"]."".$CrLf; + $DrctDbtTxInf .= " ".$py["id_member"]."".$CrLf; + $DrctDbtTxInf .= " ".$py["id_member"]."".$CrLf; $DrctDbtTxInf .= " ".$CrLf; - $DrctDbtTxInf .= " ".$py["memberquota"]."".$CrLf; //15.00 + $DrctDbtTxInf .= " ".$py["amount"]."".$CrLf; //15.00 $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; - $DrctDbtTxInf .= " ".$py["ID_member"]."".$CrLf; - $DrctDbtTxInf .= " ".$py["sepasignaturedate"]."".$CrLf; // yyyy-mm-dd + $DrctDbtTxInf .= " ".$py["id_member"]."".$CrLf; + $DrctDbtTxInf .= " ".$py["sepasig_date"]."".$CrLf; // yyyy-mm-dd $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; - $DrctDbtTxInf .= " ".$py["memberbic"]."".$CrLf; + $DrctDbtTxInf .= " ".$py["bic"]."".$CrLf; $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; - $DrctDbtTxInf .= " ".strtoupper($py["memberfullname"])."".$CrLf; //surname prename + $DrctDbtTxInf .= " ".strtoupper($py["fullname"])."".$CrLf; //surname prename $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; - $DrctDbtTxInf .= " ".str_replace(' ','',$py["memberiban"])."".$CrLf; // nospaces + $DrctDbtTxInf .= " ".str_replace(' ','',$py["iban"])."".$CrLf; // nospaces $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; - $DrctDbtTxInf .= " ".$py["sepamsg"]."".$CrLf; // p.ex. NGL-SNEP 01/2024 + $DrctDbtTxInf .= " ".$py["message"]."".$CrLf; // p.ex. NGL-SNEP 01/2024 $DrctDbtTxInf .= " ".$CrLf; $DrctDbtTxInf .= " ".$CrLf; //file_put_contents($cfg["datapath"]."tmp/debug.log","Pmt_inf:\n".print_r($py,true),FILE_APPEND); @@ -146,10 +147,10 @@ $sepa_pmtinf[$py["seqtype"]] = array("DrctDbtTxInf" => array(),"CommonPmtInf" => "","sumDrctDbtTxInf" => 0.0); } array_push($sepa_pmtinf[$py["seqtype"]]["DrctDbtTxInf"],$DrctDbtTxInf); - $sepa_pmtinf[$py["seqtype"]]["sumDrctDbtTxInf"] += $py["memberquota"]; + $sepa_pmtinf[$py["seqtype"]]["sumDrctDbtTxInf"] += $py["amount"]; $countall++; #echo "Transaction ".$countall."/".$totaltx." ajoutée\n"; - $sumall+=$py["memberquota"]; + $sumall+=$py["amount"]; } } @@ -230,10 +231,10 @@ $sepaxml .= "".$CrLf; file_put_contents($cfg["datapath"]."exportsepa/".$p["file"],$sepaxml); echo "Mise à jour Status dans la base de donnée\n"; - $sql = "update members_cotisation set status='exported' WHERE id_member in (".implode(",",$updids).") and date_month=date('".$p["year"]."-".str_pad($p["month"], 2, "0", STR_PAD_LEFT )."-01');"; + $sql = "update members_cotisation set status='exported' WHERE id in (".implode(",",$updids).");"; $db->exec($sql); // foreach ($pmtinf as $py){ - // $sql="update members_cotisation SET status='exported' where id='".$py["ID_member"]."' and date_month=date('".$p["year"]."-".str_pad($p["month"], 2, "0", STR_PAD_LEFT )."-01');"; + // $sql="update members_cotisation SET status='exported' where id='".$py["id_member"]."' and date_month=date('".$p["year"]."-".str_pad($p["month"], 2, "0", STR_PAD_LEFT )."-01');"; // $db->exec($sql); // } diff --git a/public_html/tmpl/dialogs/dlg_cotisation.php b/public_html/tmpl/dialogs/dlg_cotisation.php index 8d8dc47..f794096 100644 --- a/public_html/tmpl/dialogs/dlg_cotisation.php +++ b/public_html/tmpl/dialogs/dlg_cotisation.php @@ -11,18 +11,27 @@ $dateopts=null; $typeopts = array( array("value" => "VIR","text" => "VIR"), - array("value" => "SEPA","text" => "SEPA") + array("value" => "SEPA","text" => "SEPA"), + array("value" => "CAISSE","text" => "CAISSE") ); $statusopts = array( array("value" => "","text" => ""), + array("value" => "open","text" => "ouvert"), array("value" => "exported","text" => "exporté"), array("value" => "sended","text" => "envoyé"), array("value" => "payed","text" => "payé"), + array("value" => "canceled","text" => "annulée"), array("value" => "error","text" => "erreur") ); + $sepatypeopts = array( + array("value" => "","text" => ""), + array("value" => "RCUR","text" => "RCUR"), + array("value" => "FRST","text" => "FRST") + ); $frm->hidden("cotisation","id"); $frm->hidden("cotisation","id_member"); $frm->hidden("cotisation","date_month"); + ?>
input("cotisation","dspdate_month","Mois","text",(object) array("readonly" => "1","containerClass" => "s2")); $frm->input("cotisation","date_transaction","Date Traitement","date",null); $frm->select("cotisation","status","Status",(object) array("data" => $statusopts,"containerClass" => "s2")); @@ -32,7 +41,12 @@ $frm->input("cotisation","sepa_file_out","Fichier SEPA Export","text",(object) array("readonly" => "1","containerClass" => "s6")); $frm->input("cotisation","transaction_file_in","Fichier Import","text",(object) array("readonly" => "1","containerClass" => "s6")); $frm->input("cotisation","transaction_id","Id Transaction","text",(object) array("readonly" => "1","containerClass" => "s6")); + ?>
input("cotisation","bank_account","Compte IBAN","text",(object) array("containerClass" => "s6")); + $frm->input("cotisation","bank_bic","BIC","text",(object) array("containerClass" => "s3")); + $frm->select("cotisation","sepa_type","Type Sepa",(object) array("data" => $sepatypeopts,"containerClass" => "s3")); ?> +