Add line with sum of each column in datagrid

This topic contains 4 replies, has 2 voices, and was last updated by fred33 6 years, 10 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

Creator
Topic

June 12, 2017 at 3:12 am #29314

fred33

Participant

Hi,
all is in the title. I just want to add line, at the begining or at the end of the datagrid, who represent the sum of each column. this is the code of my datagrid

datagrid:           
    grid-visite-index:
        source:
            type: orm
            query:
                select:
                    - v.id
                    - ac.Codeclient as Code
                    - ac.name as Client
                    - ac.codeCent as Centrale
                    - v.Janvier as Janvier
                    - v.Fevrier as Fevrier
                    - v.Mars as Mars
                    - v.Avril as Avril
                    - v.Mai as Mai
                    - v.Juin as Juin
                    - v.Juillet as Juillet
                    - v.Aout as Aout
                    - v.Septembre as Septembre
                    - v.Octobre as Octobre
                    - v.Novembre as Novembre
                    - v.Decembre as Decembre
                    - v.Total as Total
                    - CONCAT(us.firstName, CONCAT(' ', us.lastName)) as VRP
                    - v.resp as Resp
                from:
                    - {table: CLAnalyseVisiteBundle:analyseVisite, alias: v}
                join:
                    inner:
                       - { join: v.account, alias: ac}
                       - { join: v.user, alias us}
                where:
                    and:
                        - (v.user = :param or v.resp = :param)
            bind_parameters:
                param: user
        columns:
            VRP:
                label: VRP
            Code:
                label: Code
            Client:
                label: Client
            Centrale: 
                label: Centrale
            Janvier:
                label: Janvier
            Fevrier:
                label: Février
            Mars:
                label: Mars
            Avril:
                label: Avril
            Mai:
                label: Mai
            Juin:
                label: Juin
            Juillet:
                label: Juillet
            Aout:
                label: Aout
            Septembre:
                Label: Septembre
            Octobre:
                label: Octobre
            Novembre:
                label: Novembre
            Decembre:
                label: Décembre
            Total:
                label: Total
                    
        sorters:
            VRP:
                data_name: VRP
            Code:
                data_name: Code
            Centrale:
                data_name: Centrale
             
        filters:
            columns:
                VRP:
                    type: string
#                    label: VRP
                    data_name: VRP
#                    options:
#                        data: @oro_user.provider.filter.user_choice_tree->getList
                Code:
                    type: string
                    data_name: ac.Codeclient
                Centrale:
                    type: string
                    data_name: ac.codeCent

datagrid:

grid-visite-index:

source:

type: orm

query:

select:

- v.id

- ac.Codeclient as Code

- ac.name as Client

- ac.codeCent as Centrale

- v.Janvier as Janvier

- v.Fevrier as Fevrier

- v.Mars as Mars

- v.Avril as Avril

- v.Mai as Mai

- v.Juin as Juin

- v.Juillet as Juillet

- v.Aout as Aout

- v.Septembre as Septembre

- v.Octobre as Octobre

- v.Novembre as Novembre

- v.Decembre as Decembre

- v.Total as Total

- CONCAT(us.firstName, CONCAT(' ', us.lastName)) as VRP

- v.resp as Resp

from:

- {table: CLAnalyseVisiteBundle:analyseVisite, alias: v}

join:

inner:

- { join: v.account, alias: ac}

- { join: v.user, alias us}

where:

and:

- (v.user = :param or v.resp = :param)

bind_parameters:

param: user

columns:

VRP:

label: VRP

Code:

label: Code

Client:

label: Client

Centrale:

label: Centrale

Janvier:

label: Janvier

Fevrier:

label: Février

Mars:

label: Mars

Avril:

label: Avril

Mai:

label: Mai

Juin:

label: Juin

Juillet:

label: Juillet

Aout:

label: Aout

Septembre:

Label: Septembre

Octobre:

label: Octobre

Novembre:

label: Novembre

Decembre:

label: Décembre

Total:

label: Total

sorters:

VRP:

data_name: VRP

Code:

data_name: Code

Centrale:

data_name: Centrale

filters:

columns:

VRP:

type: string

# label: VRP

data_name: VRP

# options:

# data: @oro_user.provider.filter.user_choice_tree->getList

Code:

type: string

data_name: ac.Codeclient

Centrale:

type: string

data_name: ac.codeCent

Thanks for any idea

Creator
Topic

Viewing 4 replies - 1 through 4 (of 4 total)

Author
Replies

June 12, 2017 at 3:33 am #29315

akhristiansen

Participant

Hello, @fred33!
I think you could do this with 2 different ways.
First way: . Just try to add

- (SUM(v.Janvier) + SUM(v.Fevrier) + SUM(v.Mars)) as 'Total'

1	- (SUM(v.Janvier) + SUM(v.Fevrier) + SUM(v.Mars)) as 'Total'

( …just add as many values to expression as you need)

Second way: Add to columns:

columns:
    total:
        label:         Total
        type:          twig
        frontend_type: html
        template:      YourBundle:FolderName/total.html.twig

columns:

total:

label: Total

type: twig

frontend_type: html

template: YourBundle:FolderName/total.html.twig

( e.g. this is representing full path, like YourBundle/Resources/views/FolderName/total.html.twig )

And in template you can do something like this ( …just add as many values to expression as you need)

{% set total = record.getValue('Janvier') + record.getValue('Fevrier') %} 
{{ total }}

1 2	{% set total = record.getValue('Janvier') + record.getValue('Fevrier') %} {{ total }}

June 12, 2017 at 5:27 am #29316

fred33

Participant

OK @akhristiansen but in my datagrid v.total is sum for each line of Janvier, Fevrier….The total value of each line is already listed in my db.
client Janvier Fevrier Mars……. Total
Cli01 2 2 2 6
cli02 1 2 1 4
TotPerMonth 3 4 3 10

The line totPerMonth is what i want to do

Thanks

June 12, 2017 at 7:02 am #29317

akhristiansen

Participant

In this case, I think you cannot do this by only datagrid`s native functionality. You could try second way ( with custom column twig template) and provide your own solution.

June 12, 2017 at 7:10 am #29318

fred33

Participant

I think you’re right, i’m trying to do that

Author
Replies

Viewing 4 replies - 1 through 4 (of 4 total)

The forum ‘OroCRM – How do I? Questions’ is closed to new topics and replies.

OroCRM Forums