[nico77Participant]

Hello Hhristo, thanks for the answer.
As a matter of fact I was asking how I can get data as json. Is my method reported with code wrong? I use it when load data in a grid and it works correctly, but if I use it to populate a local variable it doesn’t run. As I written in the previous post seems that json returned from php has a lack of information, for example it doesn’t has data about columns name, or I think so.
I’d like to have a suggestion how get correctly json data trough php and store it in var for define columns.
Thanks in advance for every.

[nico77Participant]

Hello Hristo,
thank you very much for you reply, I’ll try to clarify what I need.
i have several pc’s connected in LAN and on a pc I installed xammp (mysql,Apache, php). I have very simple pages where there are jqwidget grid, jqxcombobox,jqxcalendar. so if I browse from the same PC where I installed xammp with tha address “http://localhost/…” e verything works good, but if I try to access the site from another pc “http://computerName/…” the site doesn’t work correctly. for example:
the grid doesn’t format correct the date, in the same column some rows are showed like text and not a date;
the event change of jqxcalendar doesn’t fire;
the combo box is not rendered, so it’s showed like ul/li html tag;
the stranger thing is that if I access to the site from the pc where apache server is installed using “http://computerName/…” instead of localhost I find the same issues.
I think could be a problem regarding Javascript, it seems that if I don’t use local address javascript is not recognized so jqwidget cannot run.
Sorry, forgive my poor knowledge, what do you mean for “http-server” library?.
Thanks again for your support.

[nico77Participant]

Hi Ivailo,
thank you very much for the answer. Sorry but i’m not able to understand how i can use toolTipFormatFunction .

Could you help me please? i should put near chart the value of field ‘per’ formatted with “%” and on tooltip the value of field ‘uscite’ formatted with “€”
here is my code:

var url = "caricachart.php";
            var source =
            {
            	datatype: "json",
                datafields: [
                    { name: 'motivo', type: 'string' },
                    { name: 'uscite', type: 'string' },
                    { name: 'per', type: 'string' },
                ],

                url: url

            };
            
            
            var toolTipCustomFormatFn = function (value, itemIndex, serie, group, categoryValue, categoryAxis) {
            	
		      return  //what have i to insert here?
  };
            
            
            var dataAdapter = new $.jqx.dataAdapter(source,{ async: false, autoBind: true, loadError: function (xhr, status, error) { alert('Error loading "' + source.url + '" : ' + error); } });
			var settings = {
                title: "Riepilogo Spese",
                description: "Grafico per tipo spesa",
                enableAnimations: true,
                showLegend: true,
                showBorderLine: true,
                legendLayout: { left: 700, top: 160, width: 300, height: 200, flow: 'vertical' },
                padding: { left: 5, top: 5, right: 5, bottom: 5 },
                titlePadding: { left: 0, top: 0, right: 0, bottom: 10 },
                source: dataAdapter,
                colorScheme: 'scheme01',
                seriesGroups:
                    [
                        {
                            type: 'pie',
                            showLabels: true,
                            series:
                                [
                                    { 
                                        dataField: 'uscite',
                                        displayText: 'motivo',
                                        labelRadius: 170,
                                        initialAngle: 15,
                                        radius: 145,
                                        centerOffset: 00,
                                        toolTipFormatFunction: toolTipCustomFormatFn,

                                        //toolTipFormatSettings : { prefix: '€ ', decimalPlaces: 2},
                                        /*
                                        formatFunction: function (value) {
                                            if (isNaN(value))
                                                return value;
                                            return parseFloat(value) + '%';
                                        },*/
                                    }
                                ]
                        }
                    ]
            };

            // setup the chart	
	
	$('#chartContainer').jqxChart(settings);
	

Thank you to everyone

[nico77Participant]

here is the link for the image:
https://drive.google.com/open?id=0B-_OXqxPsh1qWGhHNEFWWXEwdUU

[nico77Participant]

i’ve resolved using this code before bind $(“#salvarifornimento”)

Thank you.

$("#salvarifornimento").unbind().click()

[Author]

Posts