jQuery UI Widgets Forums Grid hoover cell not working

This topic contains 3 replies, has 2 voices, and was last updated by  Dimitar 11 years, 3 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • hoover cell not working #45481

    atomic
    Participant

    Hi,
    I have small problem with jqx grid. I use it with fresh theme set. Everything is ok for firs two columns and in third, forth and so on… when I hoover over cell they do not become grey (hoover effect), like in firs two columns. Setting for every columns in grid is the same except datafield. It is not big problem because I only noticed it.
    Thanks

    hoover cell not working #45592

    Dimitar
    Participant

    Hello atomic,

    Have you modified the CSS of the theme file in any way or have you applied custom CSS? Please provide us with a sample that demonstrates the reported issue.

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

    hoover cell not working #45600

    atomic
    Participant

    Hi Dimitar,
    No I havent modified css, I have just downloaded new jqwidgets 3.04 yesterday and it is still the same.
    I the sample I have two grids and two chart, left grid is ok, but right grid is not working correctly after 2.columnn. I have same situation on other pages.
    Thanks.
    Here is data for dataAdapter
    {“data”:[{“year”:”1990″,”Industry”:”10000.00″,”Transport”:”10000.00″,”Residential”:”10000.00″,”Commercial”:”10000.00″,”Agriculture”:””,”Fishing”:””,”Non_energy_use”:””,”Other”:””},{“year”:”2000″,”Industry”:”11000.00″,”Transport”:”11000.00″,”Residential”:”11000″,”Commercial”:”11000.00″,”Agriculture”:””,”Fishing”:””,”Non_energy_use”:””,”Other”:””},{“year”:”2010″,”Industry”:”12000.00″,”Transport”:”12000.00″,”Residential”:”12000.00″,”Commercial”:”12000.00″,”Agriculture”:””,”Fishing”:””,”Non_energy_use”:””,”Other”:””},{“year”:”2020″,”Industry”:”13000.00″,”Transport”:”13000.00″,”Residential”:”13000.00″,”Commercial”:”13000.00″,”Agriculture”:””,”Fishing”:””,”Non_energy_use”:””,”Other”:””}]}

    and data for dataAdapter2

    {“data”:[{“name”:”Industry”,”1990″:”10000.00″,”2000″:”11000.00″,”2005″:””,”2010″:”12000.00″,”2015″:””,”2020″:”13000.00″,”2025″:””,”2030″:””,”2035″:””,”2040″:””,”2045″:””,”2050″:””},{“name”:”Transport”,”1990″:”10000.00″,”2000″:”11000.00″,”2005″:””,”2010″:”12000.00″,”2015″:””,”2020″:”13000.00″,”2025″:””,”2030″:””,”2035″:””,”2040″:””,”2045″:””,”2050″:””},{“name”:”Residential”,”1990″:”10000.00″,”2000″:”11000″,”2005″:””,”2010″:”12000.00″,”2015″:””,”2020″:”13000.00″,”2025″:””,”2030″:””,”2035″:””,”2040″:””,”2045″:””,”2050″:””},{“name”:”Commercial”,”1990″:”10000.00″,”2000″:”11000.00″,”2005″:””,”2010″:”12000.00″,”2015″:””,”2020″:”13000.00″,”2025″:””,”2030″:””,”2035″:””,”2040″:””,”2045″:””,”2050″:””}]}

    and code

    <script language="JavaScript" src="scripts/loadXML.js"></script>
    <script language="JavaScript" src="scripts/getXML.js"></script>
    <script language="JavaScript" src="scripts/getYears.js"></script>
    <script language="JavaScript" src="scripts/getFuels.js"></script>
    <script language="JavaScript" src="scripts/getSectors.js"></script>
    <script language="JavaScript" src="scripts/getUnit.js"></script>
    <script type="text/javascript" src="javascript/jqwidgets/jqxchart.js"></script>
    <script type="text/javascript" src="javascript/jqwidgets/jqxscrollbar.js"></script>
    <script type="text/javascript" src="javascript/jqwidgets/jqxlistbox.js"></script>
    <script type="text/javascript" src="javascript/jqwidgets/jqxdropdownlist.js"></script>
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.js"></script>
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.edit.js"></script>
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.selection.js"></script> 
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.columnsresize.js"></script> 
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.filter.js"></script> 
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.sort.js"></script> 
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.pager.js"></script> 
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.grouping.js"></script>
    <script type="text/javascript" src="javascript/jqwidgets/jqxgrid.aggregates.js"></script>
    
    <script type="text/javascript">
        $(document).ready(function () {
            //napuni nizove za fuels secctors years
            var casename = "<?php echo $_SESSION['case']; ?>";
            getXML(casename);
            var years = getYears();
            var sectors = getSectors();
            var unit = getUnit();
            //definisi prvi data adapter za grid i chart po sektorima
            var theme = 'fresh';
            $("#jqxExpander1").jqxExpander({ width: '620px', height: '560px', theme: theme });
            $("#jqxExpander2").jqxExpander({ width: '620px', height: '560px', theme: theme });
            var myURL ='data/FED_bysectors_data.php';
        
            var source =
            {
                url: myURL,
                root: 'data',
                datatype: 'json',
                cache: false,
                datafields: [
                    { name: 'year', type: 'string' },
            		{ name: 'Industry', type: 'number' },
            		{ name: 'Transport', type: 'number' },
            		{ name: 'Residential', type: 'number' },
            		{ name: 'Commercial', type: 'number' },
                    { name: 'Agriculture', type: 'number' },
                    { name: 'Fishing', type: 'number' },
            		{ name: 'Non_energy_use', type: 'number' },
                    { name: 'Other', type: 'number' },
                    
            		]
            };   
            var dataAdapter = new $.jqx.dataAdapter(source, {
                async: false, 
                autoBind: true,
                loadComplete: function() { //kada se zavrsi load svih odataka pozvati funkciju koja ce provjeriti da li ima praznih celija i sakriti kolone,tj opcione kolone u ovom slcaju opcione sektore
                    for (var key in sectors)
                    {
                        //console.log(key);
                    var test = $('#jqxgrid').jqxGrid('getcellvalue', 0, key);
                    if (test === ''){
                        $("#jqxgrid").jqxGrid('hidecolumn', key);
                        }
                    }
                    }
                });             
            dataAdapter.dataBind();
            
            // prepare jqxChart settings
                var settings_chart = {
                    title: "Final energy demand",
                    description: "Final energy demand by sectors",
                    enableAnimations: true,
                    showLegend: true,
                    theme: theme,
                    padding: { left: 5, top: 5, right: 5, bottom: 5 },
                    titlePadding: { left: 90, top: 0, right: 0, bottom: 10 },
                    source: dataAdapter,
                    categoryAxis:
                        {
                            text: 'Category Axis',
                            textRotationAngle: 0,
                            dataField: 'year',
                            showTickMarks: true,
                            tickMarksInterval: 1,
                            tickMarksColor: '#888888',
                            unitInterval: 1,
                            showGridLines: false,
                            gridLinesInterval: 1,
                            gridLinesColor: '#888888',
                            axisSize: 'auto'
                        },
                    colorScheme: 'scheme01',
                    seriesGroups:
                        [
                            {                                                                    
                                type: 'stackedcolumn',
                                columnsGapPercent: 100,
                                seriesGapPercent: 5,
                                valueAxis:
                                {
                                    unitInterval: 500,
                                    minValue: 0,
                                    maxValue: 'auto',
                                    displayValueAxis: true,
                                    description: unit,
                                    axisSize: 'auto',
                                    tickMarksColor: '#888888'
                                },
                                series: [
                                        { dataField: 'Industry', displayText: 'Industry'},
                                		{ dataField: 'Transport', displayText: 'Transport'},
                                		{ dataField: 'Residential', displayText: 'Residential'},
                                		{ dataField: 'Commercial', displayText: 'Commercial'},
                                        { dataField: 'Agriculture', displayText: 'Agriculture'},
                                        { dataField: 'Fishing', displayText: 'Fishing'},
                                		{ dataField: 'Non_energy_use', displayText: 'Non energy use'},
                                        { dataField: 'Other', displayText: 'Other'}
                                    ]
                            }
                        ]
                }; //kraj settinga za chart
                
                // setup the chart
                $('#jqxChart').jqxChart(settings_chart);
                
                
                //settings za grid i incijalizacija
                 $("#jqxgrid").jqxGrid(
                {
                   
                    autoheight: true,
                    autorowheight: true,
                    width: '600px',
                    theme: theme,
                   // showstatusbar: true,
                   // showaggregates: true,
                    source: dataAdapter,
                    editable: true,
                    selectionmode: 'singlecell',
                    //kolone sa validacijom
                    columns: [
                      { text: unit, datafield: 'year', width: 120, pinned: true },
                      { text: 'Industry', datafield: 'Industry', width: 120, aggregates: ['sum'],cellsalign: 'right',columntype: 'numberinput', cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            },
                                                                                                        validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                      { text: 'Transport', datafield: 'Transport', width: 120, aggregates: ['sum'],cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                      { text: 'Residential', datafield: 'Residential', width: 120, aggregates: ['sum'],cellsalign: 'right',columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                      { text: 'Commercial', datafield: 'Commercial', width: 120, aggregates: ['sum'],cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            },
                     { text: 'Agriculture', datafield: 'Agriculture', width: 120, aggregates: ['sum'],cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            },
                    { text: 'Fishing', datafield: 'Fishing', width: 120, aggregates: ['sum'],cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            },
                                                                                                            
                     { text: 'Non energy use', datafield: 'Non_energy_use', width: 120, aggregates: ['sum'],cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            },
                     { text: 'Other', datafield: 'Other', width: 120, aggregates: ['sum'],cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            }
                    ]
                      
                    });//kraj inicijalizacije i settinga za grid
                    
                //nakon zavrsenog edita grida pozovi ajax za update xml file
                $("#jqxgrid").on('cellendedit', function (event) {
                    var args = event.args;
                    var sector = args.datafield;
                    var year = args.rowindex;
                    var year1 = $("#jqxgrid").jqxGrid("getcellvalue", year, "year"); 
                    var value = args.value;
                    rowdata = new Object();
                    rowdata['action'] = 'saveData';
                    rowdata['year'] = year1;
                    rowdata['sector'] = sector;
                    rowdata['value'] = value;
                     $.ajax({
    	               url: myURL,
    	               dataType: 'json',
    	               type: 'POST',
    	               data: rowdata, 
    	               complete: function (data) {
    	                   $('#jqxExpander2').jqxExpander({expanded: true });
    						dataAdapter.dataBind();
                            dataAdapter2.dataBind();
    						$('#jqxChart').jqxChart('refresh');
                            $('#jqxChart_trans').jqxChart('refresh');
    	               }
                       });  //kraj ajax-a               
    	       }); //kraj cell edit-a
           
            
         
            //drugi data adapter za transponirane vrijednosti, po godinama
          
            var myURL2 ='data/FED_bysectors_data.php?trans=1';
            var sourcetrans =
            {
                url: myURL2,
                root: 'data',
                datatype: 'json',
                cache: false,
                datafields: [
                    { name: 'name', type: 'string' },
            		{ name: '1990', type: 'number' },
            		{ name: '2000', type: 'number' },
            		{ name: '2005', type: 'number' },
                    { name: '2010', type: 'number' },
                    { name: '2015', type: 'number' },
            		{ name: '2020', type: 'number' },
                    { name: '2025', type: 'number' },
                    { name: '2030', type: 'number' },
                    { name: '2035', type: 'number' },
                    { name: '2040', type: 'number' },
                    { name: '2045', type: 'number' },
                    { name: '2050', type: 'number' },
            		]
    	       };   
               var dataAdapter2 = new $.jqx.dataAdapter(sourcetrans, {
                async: false, 
                autoBind: true,
                loadComplete: function() { //kada se zavrsi load svih odataka pozvati funkciju koja ce provjeriti da li ima praznih celija i sakriti kolone samo za opcione godine u ovom slucaju
           
                 for (var key in years)
                    {
                        //console.log(key);
                    var test = $('#jqxgrid_trans').jqxGrid('getcellvalue', 0, key);
                    if (test === ''){
                        $("#jqxgrid_trans").jqxGrid('hidecolumn', key);
                        }
                    }                
                    }
                });                   
               dataAdapter2.dataBind();
                
                
           //setting za transponirani chart
           var settings_charttrans = {
                    title: "Final energy demand",
                    description: "Final energy demand by sectors",
                    enableAnimations: true,
                    showLegend: true,
                    theme: theme,
                    padding: { left: 5, top: 5, right: 5, bottom: 5 },
                    titlePadding: { left: 90, top: 0, right: 0, bottom: 10 },
                    source: dataAdapter2,
                    categoryAxis:
                        {
                            text: 'Category Axis',
                            textRotationAngle: 0,
                            dataField: 'name',
                            showTickMarks: true,
                            tickMarksInterval: 1,
                            tickMarksColor: '#888888',
                            unitInterval: 1,
                            showGridLines: false,
                            gridLinesInterval: 1,
                            gridLinesColor: '#888888',
                            axisSize: 'auto'
                        },
                    colorScheme: 'scheme01',
                    seriesGroups:
                        [
                            {                                                                    
                                type: 'column',
                                columnsGapPercent: 10,
                                seriesGapPercent: 5,
                                valueAxis:
                                {
                                    unitInterval: 100,
                                    minValue: 0,
                                    maxValue: 'auto',
                                    displayValueAxis: true,
                                    description: unit,
                                    axisSize: 'auto',
                                    tickMarksColor: '#888888'
                                },
                                series: [
                                        { dataField: '1990', displayText: '1990'},
                                		{ dataField: '2000', displayText: '2000'},
                                        { dataField: '2005', displayText: '2005'},
                                		{ dataField: '2010', displayText: '2010'},
                                        { dataField: '2015', displayText: '2015'},
                                		{ dataField: '2020', displayText: '2020'},
                                        { dataField: '2025', displayText: '2025'},
                                        { dataField: '2030', displayText: '2030'},
                                        { dataField: '2035', displayText: '2035'},
                                        { dataField: '2040', displayText: '2040'},
                                        { dataField: '2045', displayText: '2045'},
                                        { dataField: '2050', displayText: '2050'}
                                    ]
                            }
                        ]
                }; //kraj settinga za trans chart
                // setup the chart
                $('#jqxChart_trans').jqxChart(settings_charttrans);
           
           //setting i inicijalizacija za transponirani grid po godinamma
            $("#jqxgrid_trans").jqxGrid(
                {
                    autoheight: true,
                    autorowheight: true,
                    width: '600px',
                    theme: theme,
                    source: dataAdapter2,
                    editable: true,
                    selectionmode: 'singlecell',
                    columns: [
                      { text: unit, datafield: 'name', width: 120, pinned: true },
                      { text: '1990', datafield: '1990', width: 120,cellsalign: 'right', columntype: 'numberinput', cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            },
                                                                                                        validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                      { text: '2000', datafield: '2000', width: 120,cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                      { text: '2005', datafield: '2005', width: 120,cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                      { text: '2010', datafield: '2010', width: 120,cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                      { text: '2015', datafield: '2015', width: 120,cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                      { text: '2020', datafield: '2020', width: 120, cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            },
                      { text: '2025', datafield: '2025', width: 120, columntype: 'numberinput',cellsalign: 'right',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                     { text: '2030', datafield: '2030', width: 120, cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            },
                     { text: '2035', datafield: '2035', width: 120,cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                     { text: '2040', datafield: '2040', width: 120,cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        }
                                                                                                            },
                     { text: '2045', datafield: '2045', width: 120, cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            },
                    { text: '2050', datafield: '2050', width: 120, cellsalign: 'right', columntype: 'numberinput',cellsformat: 'd2', initeditor: function (row, cellvalue, editor) 
                                                                                                            {editor.jqxNumberInput({ decimalDigits: 2 });
                                                                                                            
                                                                                                            },
                                                                                                            validation: function (cell, value) {
                                                                                                        if (value < 0) {
                                                                                                            return { result: false, message: "Value should be positive number!" };
                                                                                                        }
                                                                                                        return true;
                                                                                                        
                                                                                                            }
                                                                                                            }
                    ]
                      
                    }); //kraj inicijalizacije i settinga za trans grid
                    
                    //update za transpponirani grid
                    $("#jqxgrid_trans").on('cellendedit', function (event) {
                    var args = event.args;
                    var godina = args.datafield;
                    var sektor = args.rowindex;
                    var sektor1 = $("#jqxgrid_trans").jqxGrid("getcellvalue", sektor, "name"); 
                    var value = args.value;
                    rowdata = new Object();
                    rowdata['action'] = 'saveData';
                    rowdata['sector'] = sektor1;
                    rowdata['year'] = godina;
                    rowdata['value'] = value;
                     $.ajax({
    	               url: myURL,
    	               dataType: 'json',
    	               type: 'POST',
    	               data: rowdata, 
    	               complete: function (data) {
    	                   $('#jqxExpander1').jqxExpander({expanded: true });
    						dataAdapter.dataBind();
                            dataAdapter2.dataBind();
    						$('#jqxChart_trans').jqxChart('refresh');
                            $('#jqxChart').jqxChart('refresh');
    	               }
                       }); //krj ajaxa
                                       
    	       });//kraj cell edita
          
            });
        
        </script>
        
        <div id = "page_title">
            <p>Final energy demand-by sectors, case name:<?php if (isset($_SESSION['case']))
                                                    {
                                                        echo $_SESSION['case'];
                                                    }   
                                                 else
                                                    {
                                                        echo "Create new or edit existing case!";
                                                    }
                                                ?>
            </p>
        </div>    
    <table>
    <tr>
      <td>
       <div id='jqxExpander1'>
            <div>Final energy demand by sectors</div>
            <div>
                <div id='jqxChart' style="width:600px; height:280px;"></div>
                <div id="jqxgrid"></div>
            </div>
       </div>
       </td>
       <td>
       <div id='jqxExpander2'>
            <div>Final energy demand by years</div>
            <div>
                <div id='jqxChart_trans' style="width:600px; height:280px;"></div>
                <div id="jqxgrid_trans"></div>
            </div>
      </div>
      </td>
    </tr>
    </table>
    
    hoover cell not working #45801

    Dimitar
    Participant

    Hi atomic,

    Everything seems in order with your grids. However, you did not provide us with the references to your CSS files. It is possible the issue originates there. Please make sure you have placed the theme file under jqx.base.css.

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

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

You must be logged in to reply to this topic.