Forums

Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Forums OroCRM OroCRM – Programming Questions limit of time format

This topic contains 3 replies, has 3 voices, and was last updated by ypetrov ypetrov 1 year, 2 months ago.

  • Creator
    Topic
  • #25460
    golriz.nourani
    golriz.nourani
    Participant

    Dears

    I used time format of oro in datagrid but for all times more than 838:58:58 , data is 838:58:58
    could you help me?
    Thanks
    Golriz

Viewing 3 replies - 1 through 3 (of 3 total)
  • Author
    Replies
  • #25461
    msulima
    msulima
    Moderator

    Hi, golriz.nourani.
    Please, provide an example of data using. What type of datagrid field you use?


    #25462
    golriz.nourani
    golriz.nourani
    Participant

    Hi,msulima
    my code is below

    select:
    -TIMEDIFF(max(v.outTime),min(v.inTime) )) as totalduration
    .
    .
    .
    columns:
    totalduration:
    label: orocrm.visit.total_durattion
    frontend_type: time

    #25463
    ypetrov
    ypetrov
    Participant

    Hello golriz.nourani.
    As far doctrine don’t have much functions to works with dates, I would advice such solution:
    1)

    2)

    3)

    I leave {{ dump() }} just to show that result will be \DateInterval so you should decide what to do next, hope approach is clear.

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

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No
sso for www.magecore.comsso for oroinc.comsso for oroinc.desso for oroinc.frsso for marketplace.orocommerce.comsso for marketplace.orocrm.com