Solved

php mysql

Posted on 2009-03-30
2
554 Views
Last Modified: 2013-12-12
I get the code it work but I want to modify it
the first page allow user select records that user want to delete by check box
if i select many record and then click 'Delete Selected Records'
all record that select will delete

but I do not want to delete it i want to insert those record to into mysql database

So i use command print_r($_SESSION);
 
to check what is the variable was send the result is

Array ( [project3_aol_payment_plan_searchwhere] => [project3_aol_payment_plan_psearch] => [project3_aol_payment_plan_psearchtype] => [project3_aol_payment_plan_start] => 1 [project3_aol_payment_plan_where] => [project3_aol_payment_plan_MasterFilter] => [project3_aol_payment_plan_DetailFilter] => [project3_aol_payment_plan_x_id_SessionValue] => [project3_aol_grop_bill_payment_where] => [project3_aol_grop_bill_payment_start] => 1 )

I did not under stand it I think it should send the Id that i was selected
How can i get the Id that user select
<?php
session_start(); // Initialize session data
ob_start(); // Turn on output buffering
?>
<?php include "ewcfg6.php" ?>
<?php include "ewmysql6.php" ?>
<?php include "phpfn6.php" ?>
<?php include "aol_payment_planinfo.php" ?>
<?php include "aol_grop_bill_paymentinfo.php" ?>
<?php include "userfn6.php" ?>
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified
header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1 
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
?>
<?php
 
// Define page object
$aol_payment_plan_list = new caol_payment_plan_list();
$Page =& $aol_payment_plan_list;
 
// Page init processing
$aol_payment_plan_list->Page_Init();
 
// Page main processing
$aol_payment_plan_list->Page_Main();
?>
<?php include "header.php" ?>
<?php if ($aol_payment_plan->Export == "") { ?>
<script type="text/javascript">
<!--
 
// Create page object
var aol_payment_plan_list = new ew_Page("aol_payment_plan_list");
 
// page properties
aol_payment_plan_list.PageID = "list"; // page ID
var EW_PAGE_ID = aol_payment_plan_list.PageID; // for backward compatibility
 
// extend page with Form_CustomValidate function
aol_payment_plan_list.Form_CustomValidate = 
 function(fobj) { // DO NOT CHANGE THIS LINE!
 
 	// Your custom validation code here, return false if invalid. 
 	return true;
 }
aol_payment_plan_list.SelectAllKey = function(elem) {
	ew_SelectAll(elem);
}
<?php if (EW_CLIENT_VALIDATE) { ?>
aol_payment_plan_list.ValidateRequired = true; // uses JavaScript validation
<?php } else { ?>
aol_payment_plan_list.ValidateRequired = false; // no JavaScript validation
<?php } ?>
 
//-->
</script>
<link rel="stylesheet" type="text/css" media="all" href="calendar/calendar-win2k-1.css" title="win2k-1">
<script type="text/javascript" src="calendar/calendar.js"></script>
<script type="text/javascript" src="calendar/lang/calendar-en.js"></script>
<script type="text/javascript" src="calendar/calendar-setup.js"></script>
<script type="text/javascript">
<!--
var ew_DHTMLEditors = [];
 
//-->
</script>
<script language="JavaScript" type="text/javascript">
<!--
 
// Write your client script here, no need to add script tags.
// To include another .js script, use:
// ew_ClientScriptInclude("my_javascript.js"); 
//-->
 
</script>
<?php } ?>
<?php if ($aol_payment_plan->Export == "") { ?>
<?php
$gsMasterReturnUrl = "aol_grop_bill_paymentlist.php";
if ($aol_payment_plan_list->sDbMasterFilter <> "" && $aol_payment_plan->getCurrentMasterTable() == "aol_grop_bill_payment") {
	if ($aol_payment_plan_list->bMasterRecordExists) {
		if ($aol_payment_plan->getCurrentMasterTable() == $aol_payment_plan->TableVar) $gsMasterReturnUrl .= "?" . EW_TABLE_SHOW_MASTER . "=";
?>
<?php include "aol_grop_bill_paymentmaster.php" ?>
<?php
	}
}
?>
<?php } ?>
<?php
	$bSelectLimit = ($aol_payment_plan->Export == "" && $aol_payment_plan->SelectLimit);
	if (!$bSelectLimit)
		$rs = $aol_payment_plan_list->LoadRecordset();
	$aol_payment_plan_list->lTotalRecs = ($bSelectLimit) ? $aol_payment_plan->SelectRecordCount() : $rs->RecordCount();
	$aol_payment_plan_list->lStartRec = 1;
	if ($aol_payment_plan_list->lDisplayRecs <= 0) // Display all records
		$aol_payment_plan_list->lDisplayRecs = $aol_payment_plan_list->lTotalRecs;
	if (!($aol_payment_plan->ExportAll && $aol_payment_plan->Export <> ""))
		$aol_payment_plan_list->SetUpStartRec(); // Set up start record position
	if ($bSelectLimit)
		$rs = $aol_payment_plan_list->LoadRecordset($aol_payment_plan_list->lStartRec-1, $aol_payment_plan_list->lDisplayRecs);
?>
<p><span class="phpmaker" style="white-space: nowrap;">TABLE: Aol Payment Plan
</span></p>
<?php if ($aol_payment_plan->Export == "" && $aol_payment_plan->CurrentAction == "") { ?>
<a href="javascript:ew_ToggleSearchPanel(aol_payment_plan_list);" style="text-decoration: none;"><img id="aol_payment_plan_list_SearchImage" src="images/collapse.gif" alt="" width="9" height="9" border="0"></a><span class="phpmaker">&nbsp;Search</span><br>
<div id="aol_payment_plan_list_SearchPanel">
<form name="faol_payment_planlistsrch" id="faol_payment_planlistsrch" class="ewForm" action="<?php echo ew_CurrentPage() ?>">
<input type="hidden" id="t" name="t" value="aol_payment_plan">
<table class="ewBasicSearch">
	<tr>
		<td><span class="phpmaker">
			<input type="text" name="<?php echo EW_TABLE_BASIC_SEARCH ?>" id="<?php echo EW_TABLE_BASIC_SEARCH ?>" size="20" value="<?php echo ew_HtmlEncode($aol_payment_plan->getBasicSearchKeyword()) ?>">
			<input type="Submit" name="Submit" id="Submit" value="Search (*)">&nbsp;
			<a href="<?php echo $aol_payment_plan_list->PageUrl() ?>cmd=reset">Show all</a>&nbsp;
		</span></td>
	</tr>
	<tr>
	<td><span class="phpmaker"><label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value=""<?php if ($aol_payment_plan->getBasicSearchType() == "") { ?> checked="checked"<?php } ?>>Exact phrase</label>&nbsp;&nbsp;<label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value="AND"<?php if ($aol_payment_plan->getBasicSearchType() == "AND") { ?> checked="checked"<?php } ?>>All words</label>&nbsp;&nbsp;<label><input type="radio" name="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" id="<?php echo EW_TABLE_BASIC_SEARCH_TYPE ?>" value="OR"<?php if ($aol_payment_plan->getBasicSearchType() == "OR") { ?> checked="checked"<?php } ?>>Any word</label></span></td>
	</tr>
</table>
</form>
</div>
<?php } ?>
<?php $aol_payment_plan_list->ShowMessage() ?>
<br>
<table cellspacing="0" class="ewGrid"><tr><td class="ewGridContent">
<div class="ewGridMiddlePanel">
<form name="faol_payment_planlist" id="faol_payment_planlist" class="ewForm" action="" method="post">
<?php if ($aol_payment_plan_list->lTotalRecs > 0) { ?>
<table cellspacing="0" rowhighlightclass="ewTableHighlightRow" rowselectclass="ewTableSelectRow" roweditclass="ewTableEditRow" class="ewTable ewTableSeparate">
<?php
	$aol_payment_plan_list->lOptionCnt = 0;
	$aol_payment_plan_list->lOptionCnt++; // view
	$aol_payment_plan_list->lOptionCnt++; // edit
	$aol_payment_plan_list->lOptionCnt++; // copy
	$aol_payment_plan_list->lOptionCnt++; // Multi-select
	$aol_payment_plan_list->lOptionCnt += count($aol_payment_plan_list->ListOptions->Items); // Custom list options
?>
<?php echo $aol_payment_plan->TableCustomInnerHtml ?>
<thead><!-- Table header -->
	<tr class="ewTableHeader">
<?php if ($aol_payment_plan->id->Visible) { // id ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->id) == "") { ?>
		<td>Id</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->id) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Id</td><td style="width: 10px;"><?php if ($aol_payment_plan->id->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->id->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->name->Visible) { // name ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->name) == "") { ?>
		<td>Name</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->name) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Name&nbsp;(*)</td><td style="width: 10px;"><?php if ($aol_payment_plan->name->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->name->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->DateOnBill->Visible) { // DateOnBill ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->DateOnBill) == "") { ?>
		<td>Date On Bill</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->DateOnBill) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Date On Bill</td><td style="width: 10px;"><?php if ($aol_payment_plan->DateOnBill->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->DateOnBill->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->DateDUE->Visible) { // DateDUE ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->DateDUE) == "") { ?>
		<td>Date DUE</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->DateDUE) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Date DUE</td><td style="width: 10px;"><?php if ($aol_payment_plan->DateDUE->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->DateDUE->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->DateExpectToplay->Visible) { // DateExpectToplay ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->DateExpectToplay) == "") { ?>
		<td>Date Expect Toplay</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->DateExpectToplay) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Date Expect Toplay</td><td style="width: 10px;"><?php if ($aol_payment_plan->DateExpectToplay->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->DateExpectToplay->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->DATE_payment->Visible) { // DATE_payment ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->DATE_payment) == "") { ?>
		<td>DATE Payment</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->DATE_payment) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>DATE Payment</td><td style="width: 10px;"><?php if ($aol_payment_plan->DATE_payment->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->DATE_payment->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->PayMentId->Visible) { // PayMentId ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->PayMentId) == "") { ?>
		<td>Pay Ment Id</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->PayMentId) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Pay Ment Id</td><td style="width: 10px;"><?php if ($aol_payment_plan->PayMentId->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->PayMentId->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->DateArrive->Visible) { // DateArrive ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->DateArrive) == "") { ?>
		<td>Date Arrive</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->DateArrive) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Date Arrive</td><td style="width: 10px;"><?php if ($aol_payment_plan->DateArrive->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->DateArrive->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->datetimestampt->Visible) { // datetimestampt ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->datetimestampt) == "") { ?>
		<td>Datetimestampt</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->datetimestampt) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Datetimestampt</td><td style="width: 10px;"><?php if ($aol_payment_plan->datetimestampt->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->datetimestampt->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->Billno->Visible) { // Billno ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->Billno) == "") { ?>
		<td>Billno</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->Billno) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Billno&nbsp;(*)</td><td style="width: 10px;"><?php if ($aol_payment_plan->Billno->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->Billno->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->Amount->Visible) { // Amount ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->Amount) == "") { ?>
		<td>Amount</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->Amount) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Amount</td><td style="width: 10px;"><?php if ($aol_payment_plan->Amount->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->Amount->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->Remark->Visible) { // Remark ?>
	<?php if ($aol_payment_plan->SortUrl($aol_payment_plan->Remark) == "") { ?>
		<td>Remark</td>
	<?php } else { ?>
		<td class="ewPointer" onmousedown="ew_Sort(event,'<?php echo $aol_payment_plan->SortUrl($aol_payment_plan->Remark) ?>',1);">
			<table cellspacing="0" class="ewTableHeaderBtn"><tr><td>Remark&nbsp;(*)</td><td style="width: 10px;"><?php if ($aol_payment_plan->Remark->getSort() == "ASC") { ?><img src="images/sortup.gif" width="10" height="9" border="0"><?php } elseif ($aol_payment_plan->Remark->getSort() == "DESC") { ?><img src="images/sortdown.gif" width="10" height="9" border="0"><?php } ?></td></tr></table>
		</td>
	<?php } ?>
<?php } ?>		
<?php if ($aol_payment_plan->Export == "") { ?>
<td style="white-space: nowrap;">&nbsp;</td>
<td style="white-space: nowrap;">&nbsp;</td>
<td style="white-space: nowrap;">&nbsp;</td>
<td style="white-space: nowrap;"><input type="checkbox" name="key" id="key" class="phpmaker" onclick="aol_payment_plan_list.SelectAllKey(this);"></td>
<?php
 
// Custom list options
foreach ($aol_payment_plan_list->ListOptions->Items as $ListOption) {
	if ($ListOption->Visible)
		echo $ListOption->HeaderCellHtml;
}
?>
<?php } ?>
	</tr>
</thead>
<?php
if ($aol_payment_plan->ExportAll && $aol_payment_plan->Export <> "") {
	$aol_payment_plan_list->lStopRec = $aol_payment_plan_list->lTotalRecs;
} else {
	$aol_payment_plan_list->lStopRec = $aol_payment_plan_list->lStartRec + $aol_payment_plan_list->lDisplayRecs - 1; // Set the last record to display
}
$aol_payment_plan_list->lRecCount = $aol_payment_plan_list->lStartRec - 1;
if ($rs && !$rs->EOF) {
	$rs->MoveFirst();
	if (!$aol_payment_plan->SelectLimit && $aol_payment_plan_list->lStartRec > 1)
		$rs->Move($aol_payment_plan_list->lStartRec - 1);
}
$aol_payment_plan_list->lRowCnt = 0;
while (($aol_payment_plan->CurrentAction == "gridadd" || !$rs->EOF) &&
	$aol_payment_plan_list->lRecCount < $aol_payment_plan_list->lStopRec) {
	$aol_payment_plan_list->lRecCount++;
	if (intval($aol_payment_plan_list->lRecCount) >= intval($aol_payment_plan_list->lStartRec)) {
		$aol_payment_plan_list->lRowCnt++;
 
	// Init row class and style
	$aol_payment_plan->CssClass = "";
	$aol_payment_plan->CssStyle = "";
	$aol_payment_plan->RowClientEvents = "onmouseover='ew_MouseOver(event, this);' onmouseout='ew_MouseOut(event, this);' onclick='ew_Click(event, this);'";
	if ($aol_payment_plan->CurrentAction == "gridadd") {
		$aol_payment_plan_list->LoadDefaultValues(); // Load default values
	} else {
		$aol_payment_plan_list->LoadRowValues($rs); // Load row values
	}
	$aol_payment_plan->RowType = EW_ROWTYPE_VIEW; // Render view
 
	// Render row
	$aol_payment_plan_list->RenderRow();
?>
	<tr<?php echo $aol_payment_plan->RowAttributes() ?>>
	<?php if ($aol_payment_plan->id->Visible) { // id ?>
		<td<?php echo $aol_payment_plan->id->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->id->ViewAttributes() ?>><?php echo $aol_payment_plan->id->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->name->Visible) { // name ?>
		<td<?php echo $aol_payment_plan->name->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->name->ViewAttributes() ?>><?php echo $aol_payment_plan->name->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->DateOnBill->Visible) { // DateOnBill ?>
		<td<?php echo $aol_payment_plan->DateOnBill->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->DateOnBill->ViewAttributes() ?>><?php echo $aol_payment_plan->DateOnBill->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->DateDUE->Visible) { // DateDUE ?>
		<td<?php echo $aol_payment_plan->DateDUE->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->DateDUE->ViewAttributes() ?>><?php echo $aol_payment_plan->DateDUE->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->DateExpectToplay->Visible) { // DateExpectToplay ?>
		<td<?php echo $aol_payment_plan->DateExpectToplay->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->DateExpectToplay->ViewAttributes() ?>><?php echo $aol_payment_plan->DateExpectToplay->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->DATE_payment->Visible) { // DATE_payment ?>
		<td<?php echo $aol_payment_plan->DATE_payment->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->DATE_payment->ViewAttributes() ?>><?php echo $aol_payment_plan->DATE_payment->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->PayMentId->Visible) { // PayMentId ?>
		<td<?php echo $aol_payment_plan->PayMentId->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->PayMentId->ViewAttributes() ?>><?php echo $aol_payment_plan->PayMentId->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->DateArrive->Visible) { // DateArrive ?>
		<td<?php echo $aol_payment_plan->DateArrive->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->DateArrive->ViewAttributes() ?>><?php echo $aol_payment_plan->DateArrive->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->datetimestampt->Visible) { // datetimestampt ?>
		<td<?php echo $aol_payment_plan->datetimestampt->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->datetimestampt->ViewAttributes() ?>><?php echo $aol_payment_plan->datetimestampt->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->Billno->Visible) { // Billno ?>
		<td<?php echo $aol_payment_plan->Billno->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->Billno->ViewAttributes() ?>><?php echo $aol_payment_plan->Billno->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->Amount->Visible) { // Amount ?>
		<td<?php echo $aol_payment_plan->Amount->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->Amount->ViewAttributes() ?>><?php echo $aol_payment_plan->Amount->ListViewValue() ?></div>
</td>
	<?php } ?>
	<?php if ($aol_payment_plan->Remark->Visible) { // Remark ?>
		<td<?php echo $aol_payment_plan->Remark->CellAttributes() ?>>
<div<?php echo $aol_payment_plan->Remark->ViewAttributes() ?>><?php echo $aol_payment_plan->Remark->ListViewValue() ?></div>
</td>
	<?php } ?>
<?php if ($aol_payment_plan->Export == "") { ?>
<td style="white-space: nowrap;"><span class="phpmaker">
<a href="<?php echo $aol_payment_plan->ViewUrl() ?>">View</a>
</span></td>
<td style="white-space: nowrap;"><span class="phpmaker">
<a href="<?php echo $aol_payment_plan->EditUrl() ?>">Edit</a>
</span></td>
<td style="white-space: nowrap;"><span class="phpmaker">
<a href="<?php echo $aol_payment_plan->CopyUrl() ?>">Copy</a>
</span></td>
<td style="white-space: nowrap;"><span class="phpmaker">
<input type="checkbox" name="key_m[]" id="key_m[]"  value="<?php echo ew_HtmlEncode($aol_payment_plan->id->CurrentValue) ?>" class="phpmaker" onclick='ew_ClickMultiCheckbox(this);'>
</span></td>
<?php
 
// Custom list options
foreach ($aol_payment_plan_list->ListOptions->Items as $ListOption) {
	if ($ListOption->Visible)
		echo $ListOption->BodyCellHtml;
}
?>
<?php } ?>
	</tr>
<?php
	}
	if ($aol_payment_plan->CurrentAction <> "gridadd")
		$rs->MoveNext();
}
?>
</tbody>
</table>
<?php } ?>
</form>
<?php
 
// Close recordset
if ($rs)
	$rs->Close();
?>
</div>
<?php if ($aol_payment_plan->Export == "") { ?>
<div class="ewGridLowerPanel">
<?php if ($aol_payment_plan->CurrentAction <> "gridadd" && $aol_payment_plan->CurrentAction <> "gridedit") { ?>
<form name="ewpagerform" id="ewpagerform" class="ewForm" action="<?php echo ew_CurrentPage() ?>">
<table border="0" cellspacing="0" cellpadding="0" class="ewPager">
	<tr>
		<td nowrap>
<?php if (!isset($aol_payment_plan_list->Pager)) $aol_payment_plan_list->Pager = new cPrevNextPager($aol_payment_plan_list->lStartRec, $aol_payment_plan_list->lDisplayRecs, $aol_payment_plan_list->lTotalRecs) ?>
<?php if ($aol_payment_plan_list->Pager->RecordCount > 0) { ?>
	<table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="phpmaker">Page&nbsp;</span></td>
<!--first page button-->
	<?php if ($aol_payment_plan_list->Pager->FirstButton->Enabled) { ?>
	<td><a href="<?php echo $aol_payment_plan_list->PageUrl() ?>start=<?php echo $aol_payment_plan_list->Pager->FirstButton->Start ?>"><img src="images/first.gif" alt="First" width="16" height="16" border="0"></a></td>
	<?php } else { ?>
	<td><img src="images/firstdisab.gif" alt="First" width="16" height="16" border="0"></td>
	<?php } ?>
<!--previous page button-->
	<?php if ($aol_payment_plan_list->Pager->PrevButton->Enabled) { ?>
	<td><a href="<?php echo $aol_payment_plan_list->PageUrl() ?>start=<?php echo $aol_payment_plan_list->Pager->PrevButton->Start ?>"><img src="images/prev.gif" alt="Previous" width="16" height="16" border="0"></a></td>
	<?php } else { ?>
	<td><img src="images/prevdisab.gif" alt="Previous" width="16" height="16" border="0"></td>
	<?php } ?>
<!--current page number-->
	<td><input type="text" name="<?php echo EW_TABLE_PAGE_NO ?>" id="<?php echo EW_TABLE_PAGE_NO ?>" value="<?php echo $aol_payment_plan_list->Pager->CurrentPage ?>" size="4"></td>
<!--next page button-->
	<?php if ($aol_payment_plan_list->Pager->NextButton->Enabled) { ?>
	<td><a href="<?php echo $aol_payment_plan_list->PageUrl() ?>start=<?php echo $aol_payment_plan_list->Pager->NextButton->Start ?>"><img src="images/next.gif" alt="Next" width="16" height="16" border="0"></a></td>	
	<?php } else { ?>
	<td><img src="images/nextdisab.gif" alt="Next" width="16" height="16" border="0"></td>
	<?php } ?>
<!--last page button-->
	<?php if ($aol_payment_plan_list->Pager->LastButton->Enabled) { ?>
	<td><a href="<?php echo $aol_payment_plan_list->PageUrl() ?>start=<?php echo $aol_payment_plan_list->Pager->LastButton->Start ?>"><img src="images/last.gif" alt="Last" width="16" height="16" border="0"></a></td>	
	<?php } else { ?>
	<td><img src="images/lastdisab.gif" alt="Last" width="16" height="16" border="0"></td>
	<?php } ?>
	<td><span class="phpmaker">&nbsp;of <?php echo $aol_payment_plan_list->Pager->PageCount ?></span></td>
	</tr></table>
	</td>	
	<td>&nbsp;&nbsp;&nbsp;&nbsp;</td>
	<td>
	<span class="phpmaker">Records <?php echo $aol_payment_plan_list->Pager->FromIndex ?> to <?php echo $aol_payment_plan_list->Pager->ToIndex ?> of <?php echo $aol_payment_plan_list->Pager->RecordCount ?></span>
<?php } else { ?>
	<?php if ($aol_payment_plan_list->sSrchWhere == "0=101") { ?>
	<span class="phpmaker">Please enter search criteria</span>
	<?php } else { ?>
	<span class="phpmaker">No records found</span>
	<?php } ?>
<?php } ?>
		</td>
	</tr>
</table>
</form>
<?php } ?>
<?php //if ($aol_payment_plan_list->lTotalRecs > 0) { ?>
<span class="phpmaker">
<a href="<?php echo $aol_payment_plan->AddUrl() ?>">Add</a>&nbsp;&nbsp;
<?php if ($aol_payment_plan_list->lTotalRecs > 0) { ?>
<a href="" onclick="if (!ew_KeySelected(document.faol_payment_planlist)) alert('No records selected'); else {document.faol_payment_planlist.action='aol_payment_plandelete1.php';document.faol_payment_planlist.encoding='application/x-www-form-urlencoded';document.faol_payment_planlist.submit();};return false;">Delete Selected Records</a>&nbsp;&nbsp;
<?php } ?>
</span>
<?php //} ?>
</div>
<?php } ?>
</td></tr></table>
<?php if ($aol_payment_plan->Export == "" && $aol_payment_plan->CurrentAction == "") { ?>
<script type="text/javascript">
<!--
 
//ew_ToggleSearchPanel(aol_payment_plan_list); // uncomment to init search panel as collapsed
//-->
 
</script>
<?php } ?>
<?php if ($aol_payment_plan->Export == "") { ?>
<script language="JavaScript" type="text/javascript">
<!--
 
// Write your table-specific startup script here
// document.write("page loaded");
//-->
 
</script>
<?php } ?>
<?php include "footer.php" ?>
<?php
 
//
// Page Class
//
class caol_payment_plan_list {
 
	// Page ID
	var $PageID = 'list';
 
	// Table Name
	var $TableName = 'aol_payment_plan';
 
	// Page Object Name
	var $PageObjName = 'aol_payment_plan_list';
 
	// Page Name
	function PageName() {
		return ew_CurrentPage();
	}
 
	// Page Url
	function PageUrl() {
		$PageUrl = ew_CurrentPage() . "?";
		global $aol_payment_plan;
		if ($aol_payment_plan->UseTokenInUrl) $PageUrl .= "t=" . $aol_payment_plan->TableVar . "&"; // add page token
		return $PageUrl;
	}
 
	// Message
	function getMessage() {
		return @$_SESSION[EW_SESSION_MESSAGE];
	}
 
	function setMessage($v) {
		if (@$_SESSION[EW_SESSION_MESSAGE] <> "") { // Append
			$_SESSION[EW_SESSION_MESSAGE] .= "<br>" . $v;
		} else {
			$_SESSION[EW_SESSION_MESSAGE] = $v;
		}
	}
 
	// Show Message
	function ShowMessage() {
		if ($this->getMessage() <> "") { // Message in Session, display
			echo "<p><span class=\"ewMessage\">" . $this->getMessage() . "</span></p>";
			$_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message in Session
		}
	}
 
	// Validate Page request
	function IsPageRequest() {
		global $objForm, $aol_payment_plan;
		if ($aol_payment_plan->UseTokenInUrl) {
 
			//IsPageRequest = False
			if ($objForm)
				return ($aol_payment_plan->TableVar == $objForm->GetValue("t"));
			if (@$_GET["t"] <> "")
				return ($aol_payment_plan->TableVar == $_GET["t"]);
		} else {
			return TRUE;
		}
	}
 
	//
	//  Class initialize
	//  - init objects
	//  - open connection
	//
	function caol_payment_plan_list() {
		global $conn;
 
		// Initialize table object
		$GLOBALS["aol_payment_plan"] = new caol_payment_plan();
 
		// Initialize other table object
		$GLOBALS['aol_grop_bill_payment'] = new caol_grop_bill_payment();
 
		// Intialize page id (for backward compatibility)
		if (!defined("EW_PAGE_ID"))
			define("EW_PAGE_ID", 'list', TRUE);
 
		// Initialize table name (for backward compatibility)
		if (!defined("EW_TABLE_NAME"))
			define("EW_TABLE_NAME", 'aol_payment_plan', TRUE);
 
		// Open connection to the database
		$conn = ew_Connect();
 
		// Initialize list options
		$this->ListOptions = new cListOptions();
	}
 
	// 
	//  Page_Init
	//
	function Page_Init() {
		global $gsExport, $gsExportFile, $aol_payment_plan;
	$aol_payment_plan->Export = @$_GET["export"]; // Get export parameter
	$gsExport = $aol_payment_plan->Export; // Get export parameter, used in header
	$gsExportFile = $aol_payment_plan->TableVar; // Get export file, used in header
 
		// Global page loading event (in userfn6.php)
		Page_Loading();
 
		// Page load event, used in current page
		$this->Page_Load();
	}
 
	//
	//  Page_Terminate
	//  - called when exit page
	//  - if URL specified, redirect to the URL
	//
	function Page_Terminate($url = "") {
		global $conn;
 
		// Page unload event, used in current page
		$this->Page_Unload();
 
		// Global page unloaded event (in userfn*.php)
		Page_Unloaded();
 
		 // Close Connection
		$conn->Close();
 
		// Go to URL if specified
		if ($url <> "") {
			ob_end_clean();
			header("Location: $url");
		}
		exit();
	}
	var $lDisplayRecs; // Number of display records
	var $lStartRec;
	var $lStopRec;
	var $lTotalRecs;
	var $lRecRange;
	var $sSrchWhere;
	var $lRecCnt;
	var $lEditRowCnt;
	var $lRowCnt;
	var $lRowIndex;
	var $lOptionCnt;
	var $lRecPerRow;
	var $lColCnt;
	var $sDeleteConfirmMsg; // Delete confirm message
	var $sDbMasterFilter;
	var $sDbDetailFilter;
	var $bMasterRecordExists;	
	var $ListOptions;
	var $sMultiSelectKey;
 
	//
	// Page main processing
	//
	function Page_Main() {
		global $objForm, $gsSearchError, $Security, $aol_payment_plan;
		$this->lDisplayRecs = 20;
		$this->lRecRange = 10;
		$this->lRecCnt = 0; // Record count
 
		// Search filters
		$sSrchAdvanced = ""; // Advanced search filter
		$sSrchBasic = ""; // Basic search filter
		$sFilter = "";
		$this->sSrchWhere = ""; // Search WHERE clause
 
		// Master/Detail
		$this->sDbMasterFilter = ""; // Master filter
		$this->sDbDetailFilter = ""; // Detail filter
		if ($this->IsPageRequest()) { // Validate request
 
			// Handle reset command
			$this->ResetCmd();
 
			// Set up master detail parameters
			$this->SetUpMasterDetail();
 
			// Get basic search criteria
			if ($gsSearchError == "")
				$sSrchBasic = $this->BasicSearchWhere();
 
			// Set Up Sorting Order
			$this->SetUpSortOrder();
		} // End Validate Request
 
		// Restore display records
		if ($aol_payment_plan->getRecordsPerPage() <> "") {
			$this->lDisplayRecs = $aol_payment_plan->getRecordsPerPage(); // Restore from Session
		} else {
			$this->lDisplayRecs = 20; // Load default
		}
 
		// Load Sorting Order
		$this->LoadSortOrder();
 
		// Build search criteria
		if ($sSrchAdvanced <> "")
			$this->sSrchWhere = ($this->sSrchWhere <> "") ? "($this->sSrchWhere) AND ($sSrchAdvanced)" : $sSrchAdvanced;
		if ($sSrchBasic <> "")
			$this->sSrchWhere = ($this->sSrchWhere <> "") ? "($this->sSrchWhere) AND ($sSrchBasic)" : $sSrchBasic;
 
		// Call Recordset_Searching event
		$aol_payment_plan->Recordset_Searching($this->sSrchWhere);
 
		// Save search criteria
		if ($this->sSrchWhere <> "") {
			if ($sSrchBasic == "")
				$this->ResetBasicSearchParms();
			$aol_payment_plan->setSearchWhere($this->sSrchWhere); // Save to Session
			$this->lStartRec = 1; // Reset start record counter
			$aol_payment_plan->setStartRecordNumber($this->lStartRec);
		} else {
			$this->RestoreSearchParms();
		}
 
		// Build filter
		$sFilter = "";
 
		// Restore master/detail filter
		$this->sDbMasterFilter = $aol_payment_plan->getMasterFilter(); // Restore master filter
		$this->sDbDetailFilter = $aol_payment_plan->getDetailFilter(); // Restore detail filter
		if ($this->sDbDetailFilter <> "")
			$sFilter = ($sFilter <> "") ? "($sFilter) AND (" . $this->sDbDetailFilter . ")" : $this->sDbDetailFilter;
		if ($this->sSrchWhere <> "")
			$sFilter = ($sFilter <> "") ? "($sFilter) AND (". $this->sSrchWhere . ")" : $this->sSrchWhere;
 
		// Load master record
		if ($aol_payment_plan->getMasterFilter() <> "" && $aol_payment_plan->getCurrentMasterTable() == "aol_grop_bill_payment") {
			global $aol_grop_bill_payment;
			$rsmaster = $aol_grop_bill_payment->LoadRs($this->sDbMasterFilter);
			$this->bMasterRecordExists = ($rsmaster && !$rsmaster->EOF);
			if (!$this->bMasterRecordExists) {
				$aol_payment_plan->setMasterFilter(""); // Clear master filter
				$aol_payment_plan->setDetailFilter(""); // Clear detail filter
				$this->setMessage("No records found"); // Set no record found
				$this->Page_Terminate($aol_payment_plan->getReturnUrl()); // Return to caller
			} else {
				$aol_grop_bill_payment->LoadListRowValues($rsmaster);
				$aol_grop_bill_payment->RowType = EW_ROWTYPE_MASTER; // Master row
				$aol_grop_bill_payment->RenderListRow();
				$rsmaster->Close();
			}
		}
 
		// Set up filter in Session
		$aol_payment_plan->setSessionWhere($sFilter);
		$aol_payment_plan->CurrentFilter = "";
	}
 
	// Return Basic Search sql
	function BasicSearchSQL($Keyword) {
		global $aol_payment_plan;
		$sKeyword = ew_AdjustSql($Keyword);
		$sql = "";
		$sql .= $aol_payment_plan->name->FldExpression . " LIKE '%" . $sKeyword . "%' OR ";
		$sql .= $aol_payment_plan->Billno->FldExpression . " LIKE '%" . $sKeyword . "%' OR ";
		$sql .= $aol_payment_plan->Remark->FldExpression . " LIKE '%" . $sKeyword . "%' OR ";
		if (substr($sql, -4) == " OR ") $sql = substr($sql, 0, strlen($sql)-4);
		return $sql;
	}
 
	// Return Basic Search Where based on search keyword and type
	function BasicSearchWhere() {
		global $Security, $aol_payment_plan;
		$sSearchStr = "";
		$sSearchKeyword = ew_StripSlashes(@$_GET[EW_TABLE_BASIC_SEARCH]);
		$sSearchType = @$_GET[EW_TABLE_BASIC_SEARCH_TYPE];
		if ($sSearchKeyword <> "") {
			$sSearch = trim($sSearchKeyword);
			if ($sSearchType <> "") {
				while (strpos($sSearch, "  ") !== FALSE)
					$sSearch = str_replace("  ", " ", $sSearch);
				$arKeyword = explode(" ", trim($sSearch));
				foreach ($arKeyword as $sKeyword) {
					if ($sSearchStr <> "") $sSearchStr .= " " . $sSearchType . " ";
					$sSearchStr .= "(" . $this->BasicSearchSQL($sKeyword) . ")";
				}
			} else {
				$sSearchStr = $this->BasicSearchSQL($sSearch);
			}
		}
		if ($sSearchKeyword <> "") {
			$aol_payment_plan->setBasicSearchKeyword($sSearchKeyword);
			$aol_payment_plan->setBasicSearchType($sSearchType);
		}
		return $sSearchStr;
	}
 
	// Clear all search parameters
	function ResetSearchParms() {
 
		// Clear search where
		global $aol_payment_plan;
		$this->sSrchWhere = "";
		$aol_payment_plan->setSearchWhere($this->sSrchWhere);
 
		// Clear basic search parameters
		$this->ResetBasicSearchParms();
	}
 
	// Clear all basic search parameters
	function ResetBasicSearchParms() {
 
		// Clear basic search parameters
		global $aol_payment_plan;
		$aol_payment_plan->setBasicSearchKeyword("");
		$aol_payment_plan->setBasicSearchType("");
	}
 
	// Restore all search parameters
	function RestoreSearchParms() {
		global $gsSearchError, $aol_payment_plan;
		$this->sSrchWhere = $aol_payment_plan->getSearchWhere();
	}
 
	// Set up Sort parameters based on Sort Links clicked
	function SetUpSortOrder() {
		global $aol_payment_plan;
 
		// Check for an Order parameter
		if (@$_GET["order"] <> "") {
			$aol_payment_plan->CurrentOrder = ew_StripSlashes(@$_GET["order"]);
			$aol_payment_plan->CurrentOrderType = @$_GET["ordertype"];
			$aol_payment_plan->UpdateSort($aol_payment_plan->id); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->name); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->DateOnBill); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->DateDUE); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->DateExpectToplay); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->DATE_payment); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->PayMentId); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->DateArrive); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->datetimestampt); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->Billno); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->Amount); // Field 
			$aol_payment_plan->UpdateSort($aol_payment_plan->Remark); // Field 
			$aol_payment_plan->setStartRecordNumber(1); // Reset start position
		}
	}
 
	// Load Sort Order parameters
	function LoadSortOrder() {
		global $aol_payment_plan;
		$sOrderBy = $aol_payment_plan->getSessionOrderBy(); // Get order by from Session
		if ($sOrderBy == "") {
			if ($aol_payment_plan->SqlOrderBy() <> "") {
				$sOrderBy = $aol_payment_plan->SqlOrderBy();
				$aol_payment_plan->setSessionOrderBy($sOrderBy);
			}
		}
	}
 
	// Reset command based on querystring parameter cmd=
	// - RESET: reset search parameters
	// - RESETALL: reset search & master/detail parameters
	// - RESETSORT: reset sort parameters
	function ResetCmd() {
		global $aol_payment_plan;
 
		// Get reset cmd
		if (@$_GET["cmd"] <> "") {
			$sCmd = $_GET["cmd"];
 
			// Reset search criteria
			if (strtolower($sCmd) == "reset" || strtolower($sCmd) == "resetall")
				$this->ResetSearchParms();
 
			// Reset master/detail keys
			if (strtolower($sCmd) == "resetall") {
				$aol_payment_plan->getCurrentMasterTable = ""; // Clear master table
				$aol_payment_plan->setMasterFilter(""); // Clear master filter
				$this->sDbMasterFilter = "";
				$aol_payment_plan->setDetailFilter(""); // Clear detail filter
				$this->sDbDetailFilter = "";
				$aol_payment_plan->id->setSessionValue("");
			}
 
			// Reset sort criteria
			if (strtolower($sCmd) == "resetsort") {
				$sOrderBy = "";
				$aol_payment_plan->setSessionOrderBy($sOrderBy);
				$aol_payment_plan->id->setSort("");
				$aol_payment_plan->name->setSort("");
				$aol_payment_plan->DateOnBill->setSort("");
				$aol_payment_plan->DateDUE->setSort("");
				$aol_payment_plan->DateExpectToplay->setSort("");
				$aol_payment_plan->DATE_payment->setSort("");
				$aol_payment_plan->PayMentId->setSort("");
				$aol_payment_plan->DateArrive->setSort("");
				$aol_payment_plan->datetimestampt->setSort("");
				$aol_payment_plan->Billno->setSort("");
				$aol_payment_plan->Amount->setSort("");
				$aol_payment_plan->Remark->setSort("");
			}
 
			// Reset start position
			$this->lStartRec = 1;
			$aol_payment_plan->setStartRecordNumber($this->lStartRec);
		}
	}
 
	// Set up Starting Record parameters based on Pager Navigation
	function SetUpStartRec() {
		global $aol_payment_plan;
		if ($this->lDisplayRecs == 0)
			return;
		if ($this->IsPageRequest()) { // Validate request			
			if (@$_GET[EW_TABLE_START_REC] <> "") { // Check for "start" parameter
				$this->lStartRec = $_GET[EW_TABLE_START_REC];
				$aol_payment_plan->setStartRecordNumber($this->lStartRec);
			} elseif (@$_GET[EW_TABLE_PAGE_NO] <> "") {
				$this->nPageNo = $_GET[EW_TABLE_PAGE_NO];
				if (is_numeric($this->nPageNo)) {
					$this->lStartRec = ($this->nPageNo-1)*$this->lDisplayRecs+1;
					if ($this->lStartRec <= 0) {
						$this->lStartRec = 1;
					} elseif ($this->lStartRec >= intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1) {
						$this->lStartRec = intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1;
					}
					$aol_payment_plan->setStartRecordNumber($this->lStartRec);
				}
			}
		}
		$this->lStartRec = $aol_payment_plan->getStartRecordNumber();
 
		// Check if correct start record counter
		if (!is_numeric($this->lStartRec) || $this->lStartRec == "") { // Avoid invalid start record counter
			$this->lStartRec = 1; // Reset start record counter
			$aol_payment_plan->setStartRecordNumber($this->lStartRec);
		} elseif (intval($this->lStartRec) > intval($this->lTotalRecs)) { // Avoid starting record > total records
			$this->lStartRec = intval(($this->lTotalRecs-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1; // Point to last page first record
			$aol_payment_plan->setStartRecordNumber($this->lStartRec);
		} elseif (($this->lStartRec-1) % $this->lDisplayRecs <> 0) {
			$this->lStartRec = intval(($this->lStartRec-1)/$this->lDisplayRecs)*$this->lDisplayRecs+1; // Point to page boundary
			$aol_payment_plan->setStartRecordNumber($this->lStartRec);
		}
	}
 
	// Load recordset
	function LoadRecordset($offset = -1, $rowcnt = -1) {
		global $conn, $aol_payment_plan;
 
		// Call Recordset Selecting event
		$aol_payment_plan->Recordset_Selecting($aol_payment_plan->CurrentFilter);
 
		// Load list page SQL
		$sSql = $aol_payment_plan->SelectSQL();
		if ($offset > -1 && $rowcnt > -1) $sSql .= " LIMIT $offset, $rowcnt";
 
		// Load recordset
		$conn->raiseErrorFn = 'ew_ErrorFn';	
		$rs = $conn->Execute($sSql);
		$conn->raiseErrorFn = '';
 
		// Call Recordset Selected event
		$aol_payment_plan->Recordset_Selected($rs);
		return $rs;
	}
 
	// Load row based on key values
	function LoadRow() {
		global $conn, $Security, $aol_payment_plan;
		$sFilter = $aol_payment_plan->KeyFilter();
 
		// Call Row Selecting event
		$aol_payment_plan->Row_Selecting($sFilter);
 
		// Load sql based on filter
		$aol_payment_plan->CurrentFilter = $sFilter;
		$sSql = $aol_payment_plan->SQL();
		if ($rs = $conn->Execute($sSql)) {
			if ($rs->EOF) {
				$LoadRow = FALSE;
			} else {
				$LoadRow = TRUE;
				$rs->MoveFirst();
				$this->LoadRowValues($rs); // Load row values
 
				// Call Row Selected event
				$aol_payment_plan->Row_Selected($rs);
			}
			$rs->Close();
		} else {
			$LoadRow = FALSE;
		}
		return $LoadRow;
	}
 
	// Load row values from recordset
	function LoadRowValues(&$rs) {
		global $aol_payment_plan;
		$aol_payment_plan->id->setDbValue($rs->fields('id'));
		$aol_payment_plan->name->setDbValue($rs->fields('name'));
		$aol_payment_plan->DateOnBill->setDbValue($rs->fields('DateOnBill'));
		$aol_payment_plan->DateDUE->setDbValue($rs->fields('DateDUE'));
		$aol_payment_plan->DateExpectToplay->setDbValue($rs->fields('DateExpectToplay'));
		$aol_payment_plan->DATE_payment->setDbValue($rs->fields('DATE_payment'));
		$aol_payment_plan->PayMentId->setDbValue($rs->fields('PayMentId'));
		$aol_payment_plan->DateArrive->setDbValue($rs->fields('DateArrive'));
		$aol_payment_plan->datetimestampt->setDbValue($rs->fields('datetimestampt'));
		$aol_payment_plan->Billno->setDbValue($rs->fields('Billno'));
		$aol_payment_plan->Amount->setDbValue($rs->fields('Amount'));
		$aol_payment_plan->Remark->setDbValue($rs->fields('Remark'));
	}
 
	// Render row values based on field settings
	function RenderRow() {
		global $conn, $Security, $aol_payment_plan;
 
		// Call Row_Rendering event
		$aol_payment_plan->Row_Rendering();
 
		// Common render codes for all row types
		// id
 
		$aol_payment_plan->id->CellCssStyle = "";
		$aol_payment_plan->id->CellCssClass = "";
 
		// name
		$aol_payment_plan->name->CellCssStyle = "";
		$aol_payment_plan->name->CellCssClass = "";
 
		// DateOnBill
		$aol_payment_plan->DateOnBill->CellCssStyle = "";
		$aol_payment_plan->DateOnBill->CellCssClass = "";
 
		// DateDUE
		$aol_payment_plan->DateDUE->CellCssStyle = "";
		$aol_payment_plan->DateDUE->CellCssClass = "";
 
		// DateExpectToplay
		$aol_payment_plan->DateExpectToplay->CellCssStyle = "";
		$aol_payment_plan->DateExpectToplay->CellCssClass = "";
 
		// DATE_payment
		$aol_payment_plan->DATE_payment->CellCssStyle = "";
		$aol_payment_plan->DATE_payment->CellCssClass = "";
 
		// PayMentId
		$aol_payment_plan->PayMentId->CellCssStyle = "";
		$aol_payment_plan->PayMentId->CellCssClass = "";
 
		// DateArrive
		$aol_payment_plan->DateArrive->CellCssStyle = "";
		$aol_payment_plan->DateArrive->CellCssClass = "";
 
		// datetimestampt
		$aol_payment_plan->datetimestampt->CellCssStyle = "";
		$aol_payment_plan->datetimestampt->CellCssClass = "";
 
		// Billno
		$aol_payment_plan->Billno->CellCssStyle = "";
		$aol_payment_plan->Billno->CellCssClass = "";
 
		// Amount
		$aol_payment_plan->Amount->CellCssStyle = "";
		$aol_payment_plan->Amount->CellCssClass = "";
 
		// Remark
		$aol_payment_plan->Remark->CellCssStyle = "";
		$aol_payment_plan->Remark->CellCssClass = "";
		if ($aol_payment_plan->RowType == EW_ROWTYPE_VIEW) { // View row
 
			// id
			$aol_payment_plan->id->ViewValue = $aol_payment_plan->id->CurrentValue;
			$aol_payment_plan->id->CssStyle = "";
			$aol_payment_plan->id->CssClass = "";
			$aol_payment_plan->id->ViewCustomAttributes = "";
 
			// name
			$aol_payment_plan->name->ViewValue = $aol_payment_plan->name->CurrentValue;
			$aol_payment_plan->name->CssStyle = "";
			$aol_payment_plan->name->CssClass = "";
			$aol_payment_plan->name->ViewCustomAttributes = "";
 
			// DateOnBill
			$aol_payment_plan->DateOnBill->ViewValue = $aol_payment_plan->DateOnBill->CurrentValue;
			$aol_payment_plan->DateOnBill->ViewValue = ew_FormatDateTime($aol_payment_plan->DateOnBill->ViewValue, 7);
			$aol_payment_plan->DateOnBill->CssStyle = "";
			$aol_payment_plan->DateOnBill->CssClass = "";
			$aol_payment_plan->DateOnBill->ViewCustomAttributes = "";
 
			// DateDUE
			$aol_payment_plan->DateDUE->ViewValue = $aol_payment_plan->DateDUE->CurrentValue;
			$aol_payment_plan->DateDUE->ViewValue = ew_FormatDateTime($aol_payment_plan->DateDUE->ViewValue, 7);
			$aol_payment_plan->DateDUE->CssStyle = "";
			$aol_payment_plan->DateDUE->CssClass = "";
			$aol_payment_plan->DateDUE->ViewCustomAttributes = "";
 
			// DateExpectToplay
			$aol_payment_plan->DateExpectToplay->ViewValue = $aol_payment_plan->DateExpectToplay->CurrentValue;
			$aol_payment_plan->DateExpectToplay->ViewValue = ew_FormatDateTime($aol_payment_plan->DateExpectToplay->ViewValue, 7);
			$aol_payment_plan->DateExpectToplay->CssStyle = "";
			$aol_payment_plan->DateExpectToplay->CssClass = "";
			$aol_payment_plan->DateExpectToplay->ViewCustomAttributes = "";
 
			// DATE_payment
			$aol_payment_plan->DATE_payment->ViewValue = $aol_payment_plan->DATE_payment->CurrentValue;
			$aol_payment_plan->DATE_payment->ViewValue = ew_FormatDateTime($aol_payment_plan->DATE_payment->ViewValue, 7);
			$aol_payment_plan->DATE_payment->CssStyle = "";
			$aol_payment_plan->DATE_payment->CssClass = "";
			$aol_payment_plan->DATE_payment->ViewCustomAttributes = "";
 
			// PayMentId
			$aol_payment_plan->PayMentId->ViewValue = $aol_payment_plan->PayMentId->CurrentValue;
			$aol_payment_plan->PayMentId->CssStyle = "";
			$aol_payment_plan->PayMentId->CssClass = "";
			$aol_payment_plan->PayMentId->ViewCustomAttributes = "";
 
			// DateArrive
			$aol_payment_plan->DateArrive->ViewValue = $aol_payment_plan->DateArrive->CurrentValue;
			$aol_payment_plan->DateArrive->ViewValue = ew_FormatDateTime($aol_payment_plan->DateArrive->ViewValue, 7);
			$aol_payment_plan->DateArrive->CssStyle = "";
			$aol_payment_plan->DateArrive->CssClass = "";
			$aol_payment_plan->DateArrive->ViewCustomAttributes = "";
 
			// datetimestampt
			$aol_payment_plan->datetimestampt->ViewValue = $aol_payment_plan->datetimestampt->CurrentValue;
			$aol_payment_plan->datetimestampt->ViewValue = ew_FormatDateTime($aol_payment_plan->datetimestampt->ViewValue, 7);
			$aol_payment_plan->datetimestampt->CssStyle = "";
			$aol_payment_plan->datetimestampt->CssClass = "";
			$aol_payment_plan->datetimestampt->ViewCustomAttributes = "";
 
			// Billno
			$aol_payment_plan->Billno->ViewValue = $aol_payment_plan->Billno->CurrentValue;
			$aol_payment_plan->Billno->CssStyle = "";
			$aol_payment_plan->Billno->CssClass = "";
			$aol_payment_plan->Billno->ViewCustomAttributes = "";
 
			// Amount
			$aol_payment_plan->Amount->ViewValue = $aol_payment_plan->Amount->CurrentValue;
			$aol_payment_plan->Amount->CssStyle = "";
			$aol_payment_plan->Amount->CssClass = "";
			$aol_payment_plan->Amount->ViewCustomAttributes = "";
 
			// Remark
			$aol_payment_plan->Remark->ViewValue = $aol_payment_plan->Remark->CurrentValue;
			$aol_payment_plan->Remark->CssStyle = "";
			$aol_payment_plan->Remark->CssClass = "";
			$aol_payment_plan->Remark->ViewCustomAttributes = "";
 
			// id
			$aol_payment_plan->id->HrefValue = "";
 
			// name
			$aol_payment_plan->name->HrefValue = "";
 
			// DateOnBill
			$aol_payment_plan->DateOnBill->HrefValue = "";
 
			// DateDUE
			$aol_payment_plan->DateDUE->HrefValue = "";
 
			// DateExpectToplay
			$aol_payment_plan->DateExpectToplay->HrefValue = "";
 
			// DATE_payment
			$aol_payment_plan->DATE_payment->HrefValue = "";
 
			// PayMentId
			$aol_payment_plan->PayMentId->HrefValue = "";
 
			// DateArrive
			$aol_payment_plan->DateArrive->HrefValue = "";
 
			// datetimestampt
			$aol_payment_plan->datetimestampt->HrefValue = "";
 
			// Billno
			$aol_payment_plan->Billno->HrefValue = "";
 
			// Amount
			$aol_payment_plan->Amount->HrefValue = "";
 
			// Remark
			$aol_payment_plan->Remark->HrefValue = "";
		}
 
		// Call Row Rendered event
		$aol_payment_plan->Row_Rendered();
	}
 
	// Set up Master Detail based on querystring parameter
	function SetUpMasterDetail() {
		global $aol_payment_plan;
		$bValidMaster = FALSE;
 
		// Get the keys for master table
		if (@$_GET[EW_TABLE_SHOW_MASTER] <> "") {
			$sMasterTblVar = $_GET[EW_TABLE_SHOW_MASTER];
			if ($sMasterTblVar == "") {
				$bValidMaster = TRUE;
				$this->sDbMasterFilter = "";
				$this->sDbDetailFilter = "";
			}
			if ($sMasterTblVar == "aol_grop_bill_payment") {
				$bValidMaster = TRUE;
				$this->sDbMasterFilter = $aol_payment_plan->SqlMasterFilter_aol_grop_bill_payment();
				$this->sDbDetailFilter = $aol_payment_plan->SqlDetailFilter_aol_grop_bill_payment();
				if (@$_GET["idlink"] <> "") {
					$GLOBALS["aol_grop_bill_payment"]->idlink->setQueryStringValue($_GET["idlink"]);
					$aol_payment_plan->id->setQueryStringValue($GLOBALS["aol_grop_bill_payment"]->idlink->QueryStringValue);
					$aol_payment_plan->id->setSessionValue($aol_payment_plan->id->QueryStringValue);
					if (!is_numeric($GLOBALS["aol_grop_bill_payment"]->idlink->QueryStringValue)) $bValidMaster = FALSE;
					$this->sDbMasterFilter = str_replace("@idlink@", ew_AdjustSql($GLOBALS["aol_grop_bill_payment"]->idlink->QueryStringValue), $this->sDbMasterFilter);
					$this->sDbDetailFilter = str_replace("@id@", ew_AdjustSql($GLOBALS["aol_grop_bill_payment"]->idlink->QueryStringValue), $this->sDbDetailFilter);
				} else {
					$bValidMaster = FALSE;
				}
			}
		}
		if ($bValidMaster) {
 
			// Save current master table
			$aol_payment_plan->setCurrentMasterTable($sMasterTblVar);
 
			// Reset start record counter (new master key)
			$this->lStartRec = 1;
			$aol_payment_plan->setStartRecordNumber($this->lStartRec);
			$aol_payment_plan->setMasterFilter($this->sDbMasterFilter); // Set up master filter
			$aol_payment_plan->setDetailFilter($this->sDbDetailFilter); // Set up detail filter
 
			// Clear previous master session values
			if ($sMasterTblVar <> "aol_grop_bill_payment") {
				if ($aol_payment_plan->id->QueryStringValue == "") $aol_payment_plan->id->setSessionValue("");
			}
		} else {
			$this->sDbMasterFilter = $aol_payment_plan->getMasterFilter(); //  Restore master filter
			$this->sDbDetailFilter = $aol_payment_plan->getDetailFilter(); // Restore detail filter
		}
	}
 
	// Page Load event
	function Page_Load() {
 
		//echo "Page Load";
	}
 
	// Page Unload event
	function Page_Unload() {
 
		//echo "Page Unload";
	}
 
	// Form Custom Validate event
	function Form_CustomValidate(&$CustomError) {
 
		// Return error message in CustomError
		return TRUE;
	}
}
?>

Open in new window

deleterecord.JPG
0
Comment
Question by:teera
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Accepted Solution

by:
bansidhar earned 300 total points
ID: 24026315
use print_r($_REQUEST) instead of print_r($_SESSION);
0
 
LVL 110

Assisted Solution

by:Ray Paseur
Ray Paseur earned 200 total points
ID: 24028660
There appear to be a few forms in the code posted above.  The forms submit information from a "form" page to an "action" script (denoted by "action=" in the <form> tag.

Forms usually submit via method="get" or method="post".  In the PHP action script, you can find the submitted information by looking at the superglobal arrays $_GET and $_POST.

HTH, ~Ray
0

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question