Accounting>costs listing page improvements

[killua-eu]

Step 1: Change header description

• bill number -> invoice #
• name -> supplier
• price with vat -> price+vat
• edit -> https://fontawesome.com/icons/edit?style=regular
• delete -> https://fontawesome.com/icons/trash-alt?style=regular
• put edit + delete into a single column

Step 2: Add columns

Add:

• cost id (header cost #)
• managerial_accounting.project_name (header project, concat)
• managerial_accounting.account_group (header expense_type)
• ext.svc ext.id1 ext.id2 (header ext #)
• dscr (header descr.)
• per year filtering (add a from-to datepicker next to Existing costs, default to 1.1.$currentyear till $currentdate)

Step 3: Add custom views

• Allow to add & remove coulmns ()
• Allow filtering (i.e. specific project, specific date range, etc.), multiple filters allowed
• Store views (i.e. add view name + view configuration, make it public or private)
• Assigning users specific views

Step 4: Add multiedit tool

We will need this in several places so this is gonna be a big thing. Look into>

• https://bossanova.uk/jexcel/examples/including-formulas-on-your-spreadsheet (cool, free, open)
• https://handsontable.com/examples?manual-resize&manual-move&conditional-formatting&context-menu&filters&dropdown-menu&headers (absolute top from user experience perspective) ... includes formulas (https://handsontable.com/docs/7.0.2/demo-formula-support.html#advanced-example), no commercial usage
• https://mdbootstrap.com/docs/jquery/tables/editable/
• http://js-grid.com/demos/
• many others here https://jspreadsheets.com/

[pohadkar]

step 1 - hotovo. ikony jsem nemohl dat verzi regular, protoze neni ve vendoru zkompilovana. dal jsem jen ferzi fa. a kos jsem dal fa-trash

[pohadkar]

step2:
managerial_accounting.project_name - dle pixel_id nacist z tabulky pixelu. zobrazit jen pixel id s odkazem na cely pixel a pri najeti na pixel ukazat concatnute project name v title
managerial_accounting.account_group - zase ukazat concatnute groups od vsech managerial acc. pokud prilis dlouhe, ukazat treba jen prvni a zbytek v title.
ext.svc ext.id1 ext.id2 - tyka se links. ukazat napevno jen veci z prvniho linku
dscr - ukazat jen max pocet znaku, zbytek na title
per year filtering - vybery podle roku. dotazovat datum v Taxable

[pohadkar]

tabulka pixelu je ted nove tabulka vektoru.
t_vectors
vektory se bud prebiraji konverzi jsonu z jinych tabulek (viz napr event vektory), nebo se daji zakladat nove.
https://japex.vaizard.xyz/glued/public/vectors/new

pozadovane project name bude prvni zaznam summary.data vektoru