Load a grid after the user input

[sowritrpkkl]

Hi,

I want to load the grid after the user select a combo box value.

For example:

I have a month combobox, after selecting the month from the combobox depending upon the month selected the data should be displayed in the grid.

Please help me how to do this.

[steven]

That's easy.

Html code here
<select name=ComboName size=1 onChange="loadData(this.options[this.selectedIndex].value);">     <option value="" SELECTED>Choose One     <option value="1">Numbers     <option value="2">Fruit     <option value="3">Animals </select>

Javascript code here
function loadData(i){     var grid=Sigma.$grid(grid_id);     grid.loadUrl = "getData.php?index=" + i;     grid.load(); }

[sowritrpkkl]

Thanks a lot........

[sowritrpkkl]

Hi,
The grid loaded perfect, but i want to change a "grid Options". like i need to hide save button and also i need to change some column as non editable. How to do this.
Kindly help me.
I am using the below code.

function loadData(){
    var grid=Sigma.$grid(grid1);
    grid.loadUrl = "../php/projectActivity.php;
var colsOptionNonEdit = [
        {id: 'account' , header: "Account" , width :120},
    {id: 'project' , header: "Project" , width :120},
    {id: 'manager' , header: "Manager" , width :150},
     
];
   grid.gridOptions = {
         showAddTool : false,
         columns : colsOptionNonEdit
      };

    grid.load();
}

but the grid options are not working.

Kindly do the needful

[steven]

That's easy. The following gridOption will show nav and pagesize only.
grid.gridOptions = {
         toolbarContent:  'nav | pagesize'.
         columns : colsOptionNonEdit
      };

'nav | pagesize | reload | add del save | print | filter chart | info' stand for all the buttons. You can hide some of them or change their order.

[sks]

That's easy.

Html code here
<select name=ComboName size=1 onChange="loadData(this.options[this.selectedIndex].value);">     <option value="" SELECTED>Choose One     <option value="1">Numbers     <option value="2">Fruit     <option value="3">Animals </select>

Javascript code here
function loadData(i){     var grid=Sigma.$grid(grid_id);     grid.loadUrl = "getData.php?index=" + i;     grid.load(); }

Sorry? but now it's not working! in v2.1!

We may use setContent:function(data).
loadUrl may use only like:
loadURL:"http://localhost/server/getStudentsInfo.php"

[red4]

I need to do exactly as said in this post but I am not able to recover the
value of the input text might give me a hand? My loadURL:
loadURL : 'api/controler.aspx?ide' + '',

[pinkyto0o]

You can pass the value of the get variable using a parameter:

parameters : {name:"value"}

[red4]

Ok but how create it? must receive the variable without page refresh, or need to come from a static combo

thanks

Red4

[humi]

If you need to pass a dynamic variable to the controller, do this as steven said:

Example of PHP in Grid.
var gridOption={ loadURL : '/includes/Controller.php', parameters: {'client_id':"<?php echo $_GET['client_id']; ?>"}, ect...ect... };

Then in controller use the variable like this:
$userparameters = $json->{'parameters'}; $sql = "select * from `project` WHERE `client`='" . $userparameters->client_id . "'";

I don't know ASP so I cannot help with exact commands.

About the static combo:
http://www.sigmawidgets.com/products/sigma_grid2/docs/sigma_grid.html#addParameters
Something Like this maybe?
<script type="text/javascript"> function myFunction1(num1){ mygrid1.addParameters('client_id':num1); mygrid1.refresh(); } </script> <select> <option onclick=" myFunction1('1'); ">First Client</option> <option onclick=" myFunction1('2'); ">Second Client</option> <option onclick=" myFunction1('3'); ">Third Client</option> </select>

[red4]

This last example that you have to be exactly what I need but when I road it does not work.   
Actually I need to get data from a combo fix and then have it filter the xml

thanks

My code:   
The function loadurl in loaddata not pass the parameters to loadurl in gridoption

function loadData(i){     var grid=Sigma.$grid(grid_demo_id);     grid.loadUrl = 'api/controler.php?inc=port&tab=Vw_Vehicles&test=', + i; //grid.addParameters('project_id':"test"); alert(i);     grid.load(); } var gridOption={ id : grid_demo_id, loadURL : 'api/controler.php?inc=port&tab=Vw_Vehicles', width: "100%",  //"100%", // 700, height: "382",  //"100%", // 330 container : 'gridbox', replaceContainer : true, showGridMenu : false, toolbarContent : ' nav | pagesize | reload | filter | print | state', dataset : dsOption , columns : colsOption, pageSizeList : [10,30,50,10,200,500], pageSize:10,

   
If someone can help me I would be very grateful

[humi]

function loadData(i){     var grid=Sigma.$grid(grid_demo_id);     grid.loadUrl = 'api/controler.php';     grid.addParameters("test":i, "inc":"port", "tab":"Vw_Vehicles");     alert(i);     grid.load(); }

This looks better.
You will need to get the variables from the json array in the controller.

example in PHP:
$json->{'parameters'}->inc $json->{'parameters'}->test $json->{'parameters'}->tab

[red4]

Hi humi

Ok this is exactly what I need but I believe that has something wrong, you could check? Here I made a debug below:

Erro: missing ) after argument list
File Source: api/controler.php: 62, Coluna: 26
Source Code:
grid.addParameters("test":i, "inc":"port", "tab":"Vw_Vehicles");

[humi]

My syntax was wrong. Sorry.

http://www.sigmawidgets.com/products/sigma_grid2/docs/sigma_grid.html#addParameters

grid.addParameters({"test":i, "inc":"port", "tab":"Vw_Vehicles"});

[red4]

Ok thanks

ok now he is working but ...   

What I understand is the following these parameters they are not passed within the variable below, note: The JSON recover it via get or post?

_gt_json   

{"recordType":"object","pageInfo":{"pageSize":10,"pageNum":1,"totalRowNum":200,"totalPageNum":20,"startRowNum"
:1,"endRowNum":10},"columnInfo":[{"id":"dt","header":"Data","fieldName":"dt","fieldIndex":"dt","sortOrder"
:null,"hidden":false,"exportable":true,"printable":true},{"id":"prefixo","header":"Prefixo","fieldName"
:"prefixo","fieldIndex":"prefixo","sortOrder":null,"hidden":false,"exportable":true,"printable":true
},{"id":"sentido","header":"Sentido","fieldName":"sentido","fieldIndex":"sentido","sortOrder":null,"hidden"
:false,"exportable":true,"printable":true}],"sortInfo":[],"filterInfo":[],"parameters":{},"action":"load"
}