jQWidgets Forums

Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • in reply to: PivotGrid: Load JSON Data PivotGrid: Load JSON Data #113689

    Michael Gross
    Participant

    Hi Peter,1 more comment on the Pivot Designer: The injection of the classes for the Designer-Object has an error:
    class="jqx-rc-all jqx-widget jqx-pivotgrid <strong>jqx-designer-hostjqx-widget-content</strong>"
    jqx-designer-host and jqx-widget-content have no space in between and are not active.
    I have tried to position the Pivot Designer relative to a table cell, which didn’t work as expected:

    
    <table id'someTable><tr><td>Some Conetent</td></tr></table>
    <table class='pivotTable' id='pivotTable' width='100%' border='0'>
      <TR>    <td><div id='divPivotGridDesigner' class='pivotDesigner'></div>    </td>
        <td><div id='divPivotGrid' class='pivotGrid'></div>    </td></TR>
    </table>

    The Designer Object is placed always outside of the table cell.
    Best Regards
    Michael

    in reply to: PivotGrid: Load JSON Data PivotGrid: Load JSON Data #113672

    Michael Gross
    Participant

    Thank you Peter, this was the solution – it works just great!
    Best Regards
    Michael


    Michael Gross
    Participant

    Thank you for the reply, but the example shows only the identification of a selected item. Perhaps my explanation was not detailed enough: The Listbox has 1000 items with the values 1 – 1000. The items itself are displayed as an image through custom rendering, the value-members are the numbers. I would like to use the mobile wiping action which makes the listbox scrolling through the images without selecting any. This works fine, but in addition I have to show the current number of the image in the viewport (which is not selected, but comes into the viewport through the wiping action). How can I identify the item occurring in the viewport?


    Michael Gross
    Participant

    Hello,
    thank you for this helpful hint – I inserted “initTabContent: initWidgets” like the demo and everything works fine,
    best regards
    Mike


    Michael Gross
    Participant

    Hello,
    a few more findings:
    Grid on page 1 is loading always correct – if I change the order of the pages all three Grids are loaded correctly if they are on page 1. The grids on page 2 and 3 fire the “beforeLoad” event, but then raise the error “Uncaught TypeError: Cannot read property ‘length’ of undefined”.


    Michael Gross
    Participant

    Thank you Dimitar 🙂 it works perfect in the application!


    Michael Gross
    Participant

    I have build my own fiddle – hopefully it works 🙂 for you: http://jsfiddle.net/drmikegross/rf0rwjLs/

    Best Regards
    Michael


    Michael Gross
    Participant

    Hello Dimitar,
    sorry, the code:
    The datatable shows the data correctly after staring the app, after pressing one of the buttons, the localdata are changed. The timer fired the event correctly, but the datatable does no update:

    <!DOCTYPE html>
    <html lang=”en”>
    <head>
    <title id=’Description’>Mobile Notification Viewer</title>
    <link rel=”stylesheet” href=”/gw/stylesheets/jqx.base.css” type=”text/css” />
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/scripts/jquery-1.11.1.min.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxcore.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxvalidator.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxexpander.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxcheckbox.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxbuttons.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxmaskedinput.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxinput.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxtooltip.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxdata.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxscrollbar.js”></script>
    <script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxdatatable.js”></script>

    <script type=”text/javascript”>
    var gettimer = 0;
    var localdata = new Array();
    $(document).ready(function () {
    localStorage.actual = ‘{“msgid”:400,”feld1″:”05:33″,”feld2″:”20:40″,”feld3″:”18″}’;
    localdata = getlocaldata();
    var localsource =
    {
    datatype: “array”,
    localdata: localdata,
    datafields: [
    { name: ‘nr’, type: ‘num’ },
    { name: ‘bez’, type: ‘string’ },
    { name: ‘inhalt’, type: ‘string’ }
    ]
    };
    var localAdapter = new $.jqx.dataAdapter(localsource);
    $(“#dataTable”).jqxDataTable(
    {
    autoShowLoadElement: true,
    showHeader: false,
    columnsHeight: 20,
    width: 300,
    source: localAdapter,
    altRows: true,
    pageable: false,
    pageSize: 3,
    scrollBarSize: 0,
    columns: [
    { text: ”, dataField: ‘bez’, width: 100 },
    { text: ”, dataField: ‘inhalt’, width: 200 }
    ]
    });
    if (gettimer == 0) {
    gettimer = setInterval(function () {
    localdata = getlocaldata();
    localAdapter.dataBind();
    $(“#dataTable”).jqxDataTable(‘updateBoundData’);
    alert(‘Update done’);
    }, 10000);
    };
    $(‘#Button1’).on(‘click’, function () {
    localStorage.actual = ‘{“msgid”:401,”feld1″:”10:14″,”feld2″:”19:30″,”feld3″:”44″}’;
    });
    $(‘#Button2’).on(‘click’, function () {
    localStorage.actual = ‘{“msgid”:402,”feld1″:”10:19″,”feld2″:”19:40″,”feld3″:”60″}’;
    });
    $(‘#Button3’).on(‘click’, function () {
    localStorage.actual = ‘{“msgid”:403,”feld1″:”10:45″,”feld2″:”19:50″,”feld3″:”89″}’;
    });

    });
    function getlocaldata() {
    var records = {};
    records = JSON.parse(localStorage.actual);
    if (records !== undefined) {
    var data = new Array();
    var row = {};
    row[‘nr’] = 0;
    row[‘bez’] = ‘Feld 1’;
    row[‘inhalt’] = records[‘feld1’];
    data[0] = row;
    row = {};
    row[‘nr’] = 1;
    row[‘bez’] = ‘Feld 2’;
    row[‘inhalt’] = records[‘feld2’];
    data[1] = row;
    row = {};
    row[‘nr’] = 2;
    row[‘bez’] = ‘Feld 3’;
    row[‘inhalt’] = records[‘feld3′];
    data[2] = row;
    };
    return (data);
    };

    </script>
    </head>
    <body>

    <table bgcolor=’#FFFFFF’ border=’1′>
    <tr><td height=’380′ valign=’bottom’>
    <div id=”dataTable”>
    </div></td></tr>
    <tr><td height=’30’ style=”text-align: center;”>
    <input type=”button” value=”Update1″ id=”Button1″ />
    <input type=”button” value=”Update2″ id=”Button2″ />
    <input type=”button” value=”Update3″ id=”Button3″ /></td>
    </tr>

    </table>
    </body>

    in reply to: Grid shows not all Data Grid shows not all Data #63482

    Michael Gross
    Participant

    Hi Dimitar,
    the server call sends all 6963 records as can be verfied by calling the url directly in the browser.

    I have identified the problem: the grid in virtual mode does not care about unique values in the ‘id’ column – the grid with virtualmode = false does. After setting the ‘id’ column to the unique current number, all records where loaded and displayed in the grid.

    Thank you for your help,
    Michael

    in reply to: Grid shows not all Data Grid shows not all Data #63439

    Michael Gross
    Participant

    Hello Dimitar,
    thank you, but the real problem is, that the grid does not load all data out of the dataadapter if virtual mode is set to false. The same code with virtual mode = true loads all data 🙁

    The code is:

    ....<script type="text/javascript">
    $(document).ready(function () {
    var source =
          {
              datatype: "json",
              datafields: [
                      { name: 'lfdnr', type: 'int' },
                      { name: 'sc', type: 'string' },
                      { name: 'dep-id', type: 'int' },
                      { name: 'active', type: 'string' },
                      { name: 'code', type: 'string' },
                      { name: 'costcenter', type: 'string' },
                      { name: 'org-chart-desc', type: 'string' }
                      ],
              url: "http://85.214.117.215/portal/wa6tst.slag/getorgunitcost.p",
              id: 'dep-id',
              sortcolumn: 'dep-id',
              sortdirection: 'asc',
              data: {
                    typ: 'JSON',
                    code: '',
                    name: '',
                    sc: ''
                  }
         };
      var columns = [
        { text: 'RecID', dataField: 'lfdnr', width: 50, editable: false },
        { text: 'Country', dataField: 'code', editable: false, width: 100 },
        { text: 'Cost Center', dataField: 'costcenter', width: 100, editable: false },
        { text: 'Code', dataField: 'sc', editable: false, width: 100 },
        { text: 'Org-Unit ID', dataField: 'dep-id', editable: false, width: 100 },
        { text: 'Hierarchie Level', dataField: 'org-chart-desc', editable: false, width: 200 },
        { text: 'Active', editable: false, dataField: 'active', editable: false, checkbox: true, columntype: 'checkbox', width: 50 },
      ];
    var dataAdapter = new $.jqx.dataAdapter(source, {
      });
    $("#grid").jqxGrid(
    {
          theme: 'marlin',
          width: '800',
          autoheight: true,
          columnsresize: true,
          columnsreorder: true,
          source: dataAdapter,
          selectionmode: 'singlecell',
          sortable: true,
          filterable: true,
          filtermode: 'default',
          autorowheight: true,
          editable: false,
          autoshowcolumnsmenubutton: true,
          enablemousewheel: false,
          altrows: true,
          pageable: true,
          pagermode: 'default',
          columns: columns
    });
    
      });
    </script>
    	
    </head>
    
    <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
    <form name="selectform" action="grid_virtualmode.htm" method="POST">
    <div id='jqxWidget' style='margin-top: 0px; margin-left: 0px; float: left;'>
    <div id="grid">
    </div>
    </div>
    </form>
    </body>

    Kind regards
    Michael

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