\t\t\t\turl: 'city.php', \t\t\t\tdataType: 'json', \t\t\t\tdata: {q:cntryval}, \t\t\t\tsuccess : function(response) \t\t\t\t{ \t\t\t\t\tvar t=""; \t\t\t\t\tjQuery.each(response, function(i,item) { \t\t\t\t\t\tt += "<option value='"+item.id+"'>"+item.value+"</option>"; \t\t\t\t\t}); \t\t\t\t\tjQuery("#City",formid).append(t).removeAttr("disabled"); \t\t\t\t} \t\t\t}); \t\t} \t}); } INITFORM; // Enable navigator $grid->navigator = true; // Enable only editing $grid->setNavOptions('navigator', array("excel" => false, "add" => true, "edit" => true, "del" => false, "view" => false, "search" => false)); // Close the dialog after editing $grid->setNavOptions('edit', array("closeAfterEdit" => true, "editCaption" => "Update Customer", "bSubmit" => "Update", "viewPagerButtons" => false)); // Bind the before show Form event in add and edit mode. $grid->setNavEvent('edit', 'beforeShowForm', $beforeshow); $grid->setNavEvent('add', 'beforeShowForm', $beforeshow); // Bind the initialize Form event in add and edit mode. $grid->setNavEvent('edit', 'onInitializeForm', $initform); $grid->setNavEvent('add', 'onInitializeForm', $initform); // Enjoy $grid->renderGrid('#grid', '#pager', true, null, null, true, true); $conn = null;
$grid->setUrl('detail.php'); // Set some grid options $grid->setGridOptions(array("rowNum" => 10, "footerrow" => true, "userDataOnFooter" => true, "sortname" => "OrderID", "height" => 110)); // Change some property of the field(s) $grid->setColProperty("RequiredDate", array("formatter" => "date", "formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "m/d/Y"), "search" => false)); // on beforeshow form when add we get the customer id and set it for posting $beforeshow = <<<BEFORE function(formid) { var srow = jQuery("#grid").jqGrid('getGridParam','selrow'); if(srow) { \tvar gridrow = jQuery("#grid").jqGrid('getRowData',srow); \t\$("#CustomerID",formid).val(gridrow.CustomerID); } } BEFORE; // disable the CRUD buttons when we initialy load the grid $initgrid = <<<INIT jQuery("#add_detail").addClass("ui-state-disabled"); jQuery("#edit_detail").addClass("ui-state-disabled"); jQuery("#del_detail").addClass("ui-state-disabled"); INIT; $grid->setJSCode($initgrid); $grid->setColProperty("EmployeeID", array("hidden" => false, "width" => 20)); $grid->navigator = true; $grid->setNavOptions('navigator', array("excel" => true, "add" => true, "edit" => true, "del" => true, "view" => false)); $grid->setNavEvent('add', 'beforeShowForm', $beforeshow); // Enjoy $summaryrow = array("Freight" => array("Freight" => "SUM")); $grid->renderGrid("#detail", "#pgdetail", true, $summaryrow, array((int) $rowid), true, true); $conn = null;