$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";
