asipto / siremis

Web Admin Interface for Kamailio
http://www.siremis.org
98 stars 46 forks source link

Siremis "Chart Services" time format has a bug or is only config issue?? #22

Closed humberjol closed 6 years ago

humberjol commented 7 years ago

Hello:

I added a graphic to Siremis of my active

dialogs. But, it only shows unix time (From 1969-12-31 19:33:37 To1969-12-31 19:33:37) as Xaxis (19:33). I had version 4.2 and never saw it correctly, I just updated to version 4.4 and I see the same problem.Please see the attachment file with the graph, and my configuration files and table bellow

Thanks in advance.

My /var/www/siremis-4.4.0/siremis/modules/ser/view/xxxx.xml file

    ?xml version="1.0"
          standalone="no"?>

        <EasyView
        Name="ChartsSumdialogsView" Description="Charts"
            class="EasyView" Tab="" TemplateEngine="Smarty"
              Access="SERAdmin.Administer_Modules"
         TemplateFile="view.tpl">

             <FormReferences>

       <Reference Name="ser.cms.form.ChartsForm"/>

             </FormReferences>

            </EasyView>

My siremisCharts.xml


See bellow, the portion of the table used to build the graphic, the column "date_created" is the problem, and the format is "TIMESTAMP"

id, date_created, active_dialogs,

early_dialogs, expired_dialogs, failed_dialogs, processed_dialogs, '1', '2017-04-11 14:40:40', '220', '0', '1219', '37', '6879491' '2', '2017-04-11 14:42:02', '206', '0', '1219', '37', '6879604' '3', '2017-04-11 14:43:01', '215', '0', '1219', '37', '6879685' '4', '2017-04-11 14:44:01', '191', '0', '1220', '37', '6879744' '5', '2017-04-11 14:45:02', '203', '0', '1220', '37', '6879837' '9', '2017-04-11 14:46:01', '211', '0', '1220', '37', '6879929' '11', '2017-04-11 14:47:01', '234', '0', '1220', '37', '6880019' '12', '2017-04-11 14:48:01', '222', '0', '1220', '37', '6880087'


Graph siremis_format

miconda commented 6 years ago

Type of the column with timestamps has to be int.