$ds->SelectCommand = "select customerNumber,customerName,phone,city from customers"; $grid = new KoolGrid("grid"); $grid->scriptFolder = $KoolControlsFolder . "/KoolGrid"; $grid->styleFolder = "sunset"; $grid->MasterTable->DataSource = $ds; $grid->MasterTable->DataKeyNames = "customerNumber"; // Need to set to get selection. $grid->Width = "655px"; $grid->AllowSelecting = true; // Allow row selecting $grid->AjaxEnabled = true; $grid->AutoGenerateColumns = true; $grid->MasterTable->Pager = new GridPrevNextAndNumericPager(); $grid->Process(); //Get selected keys after grid processing $selected_keys = $grid->GetInstanceMasterTable()->SelectedKeys; ?> <form id="form1" method="post"> <?php echo $koolajax->Render(); ?> <?php echo $grid->Render(); ?> <div style="padding-top:10px;"> <input type="submit" value = "Submit" /> </div> <div style="padding-top:10px;"> <?php
$grid_customer->Process(); $ds_order = new MySQLDataSource($db_con);//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php if(isset($_POST["customer_selected"])) { $ds_order->SelectCommand = "select orderNumber,orderDate,status,customerNumber from orders where customerNumber=".$_POST["customerNumber"]; $_SESSION["customerNumber"] = $_POST["customerNumber"]; } else { if(!$koolajax->isCallback) { $_rows = $grid_customer->GetInstanceMasterTable()->GetInstanceRows(); $_rows[0]->Selected = true; $ds_order->SelectCommand = "select orderNumber,orderDate,status,customerNumber from orders where customerNumber=".$_rows[0]->DataItem["customerNumber"]; } else { $ds_order->SelectCommand = "select orderNumber,orderDate,status,customerNumber from orders where customerNumber=".$_SESSION["customerNumber"]; } } $grid_order = new KoolGrid("grid_order"); $grid_order->scriptFolder = $KoolControlsFolder."/KoolGrid"; $grid_order->styleFolder="default"; $grid_order->Width = "655px"; $grid_order->RowAlternative = true;
$grid->AjaxLoadingImage = $KoolControlsFolder."/KoolAjax/loading/5.gif"; $grid->RowAlternative = true; $grid->AutoGenerateColumns = true; $grid->MasterTable->Pager = new GridPrevNextAndNumericPager(); $grid->Process(); if(isset($_POST["IgnorePaging"])) { $grid->ExportSettings->IgnorePaging = true; } if(isset($_POST["ExportToExcel"])) { ob_end_clean(); $grid->GetInstanceMasterTable()->ExportToExcel(); } if(isset($_POST["ExportToWord"])) { ob_end_clean(); $grid->GetInstanceMasterTable()->ExportToWord(); } if(isset($_POST["ExportToCSV"])) { ob_end_clean(); $grid->GetInstanceMasterTable()->ExportToCSV(); } if(isset($_POST["ExportToPDF"])) { ob_end_clean(); $grid->GetInstanceMasterTable()->ExportToPDF();
$grid->DataSource = $ds; $grid->Width = "655px"; //Enable Ajax Mode $grid->AjaxEnabled = true; //Add loading image $grid->AjaxLoadingImage = $KoolControlsFolder . "/KoolAjax/loading/5.gif"; $grid->RowAlternative = true; $grid->AutoGenerateColumns = true; $grid->MasterTable->Pager = new GridPrevNextAndNumericPager(); $grid->Process(); if (isset($_POST["FileName"])) { $grid->ExportSettings->FileName = $_POST["FileName"]; } if (isset($_POST["ExportToPDF"])) { ob_end_clean(); $grid->GetInstanceMasterTable()->ExportToPDF(); } ?> <form id="form1" method="post"> <?php echo $koolajax->Render(); ?> <div style="margin-bottom:10px;padding:10px;width:635px;background:#DFF3FF;border:solid 1px #C6E1F2;"> Enter filename: <br/> <input type="textbox" id="FileName" name="FileName" value="<?php echo $grid->ExportSettings->FileName; ?> "/> <br/><br/>
$grid->DataSource = $ds; $grid->AjaxEnabled = true; $grid->MasterTable->Pager = new GridPrevNextPager(); $grid->MasterTable->Pager->ShowPageInfo = false; $grid->MasterTable->RowAlternative = true; $grid->AllowSelecting = true; $grid->Width = "215px"; $column = new GridBoundColumn(); $column->DataField = "customerName"; $column->HeaderText = "Customers"; $grid->MasterTable->AddColumn($column); $grid->styleFolder = "sunset"; $grid->ClientSettings->ClientEvents["OnRowSelect"] = "Handle_OnRowSelect"; $grid->Process(); if (!$koolajax->isCallback) { $_rows = $grid->GetInstanceMasterTable()->GetInstanceRows(); $_rows[0]->Selected = true; $customerNumber = $_rows[0]->DataItem["customerNumber"]; } else { $customerNumber = isset($_POST["customerNumber"]) ? $_POST["customerNumber"] : 0; } $_axis_items = array(); $_series_items = array(); $result = mysql_query("select productName, priceEach*quantityOrdered as spent from customers,orders,orderdetails,products where customers.customerNumber=orders.customerNumber and orders.orderNumber=orderdetails.orderNumber and orderdetails.productCode=products.productCode and customers.customerNumber={$customerNumber} group by products.productCode limit 9"); while ($row = mysql_fetch_assoc($result)) { array_push($_axis_items, $row["productName"]); array_push($_series_items, round($row["spent"])); } if (count($_series_items) > 0) { $chart = new KoolChart("chart"); $chart->scriptFolder = $KoolControlsFolder . "/KoolChart";