function getCodes()
{
$queryChk = "SELECT * FROM ebpls_codes_table WHERE id = 1";
$resultChk = th_query($queryChk);
/*
if(mysql_num_rows($resultChk) > 0){
$row = mysql_fetch_array($resultChk);
}
*/
// return $row;
return;
}
<tr bgcolor="#EEEEEE">
<td width=5%>No.</td>
<td width=20% align=center>Date of Renewal</td>
<td width=5% align=center>Surcharge</td>
<td width=5% align=center>Interest</td>
<td width=5% align=center>Surcharge Mode</td>
<td width=5% align=center>Due Dates Mode</td>
<td width=5% align=center>Indicator</td>
<td width=5% align=center>Status</td>
<td width=20% align=center>Action</td>
</tr>
<?php
$listmyid = "SELECT * FROM {$tbl_current} ORDER BY id DESC ";
$Dbresult = th_query($listmyid);
while ($dtarow = @mysql_fetch_array($Dbresult)) {
$valueof_remarks = substr($dtarow[remarks], 0, 22);
$myrow++;
include 'tablecolor-inc.php';
echo "<tr bgcolor={$varcolor}>";
echo "<td>{$myrow}</td>";
echo "<td align=center>{$dtarow['renewaldate']}</td>";
echo "<td align=right>{$dtarow['rateofpenalty']}</td>";
echo "<td align=right>{$dtarow['rateofinterest']}</td>";
switch ($dtarow[optsurcharge]) {
case MON:
$optSurcharge = 'Monthly';
break;
case QTR:
$optSurcharge = 'Quarterly';
/**
* updates the status of a specific mail (identified by messageid) as sent or "1"
*
* @param string/array Messageid (for multiple messageids, use array)
* @param integer New status
* @return boolean A positive resource if mail is successfully updated or 0 otherwise
* @access public
*/
function updateMailStatus($messageid, $intStatus = 1, $strTable = "E_Messages")
{
if (is_array($messageid)) {
foreach ($messageid as $value) {
$theMessageid[] = "'{$value}'";
}
$theMessageid = implode(',', $theMessageid);
} else {
$theMessageid = "'{$messageid}'";
}
$strQuery = "UPDATE {$strTable} SET\r\n\t\t\tstatus = {$intStatus}\r\n\t\t\tWHERE messageid IN({$theMessageid})\r\n\t\t\t";
$result = th_query($strQuery);
return 1;
}
if ($ThUserData[username] == $checkiff[username]) {
?>
<body onload='javascript:alert ("Cannot delete own account!!"); return false;'></body>
<?php
} else {
if ($isonline > 0) {
?>
<body onload='javascript:alert ("Cannot delete online user.\nAsk user to logout or\nkick user before deleting."); return false;'></body>
<?php
} else {
$strQuery = "DELETE FROM ebpls_user WHERE id = {$frmId}";
}
}
//echo "$intUserLevel :: $strQuery<BR> :: " . eBPLS_USER_CTC;
if ($intUserLevel >= eBPLS_USER_CTC) {
$result = th_query($strQuery);
//--- delete from the listings
delSubLevelListings($dbLink, $frmId);
} else {
$result = FALSE;
}
if ($result === FALSE) {
"<div align=\"CENTER\" class=\"thFieldTitle\">Delete Failed! Please Contact Your Administrator.</div>";
} else {
echo "<div align=\"CENTER\" class=\"thFieldTitle\">Delete Successfull!</div>";
}
} else {
// ********************** START HERE **********************
if (!empty(${$qryVar2}) || !empty($frmId)) {
require_once "lib/dbhtmltable.class.php";
$objDbTable = new DbHtmlTable($thThemeColor3, $thThemeColor4, "ARIAL,HELVETICA,SANS-SERIF", "2", "#000000", 500, 1, 2);
function getBusEstabByNature($arrDateStart, $arrDateEnd)
{
$strDbHost = "localhost";
$strDbUser = "******";
$strDbUKey = "ebpls";
$strDbName = "ebpls";
//var_dump($arrDateStart);
//var_dump($$arrDateEnd);
//$strCurrShade = ($strCurrShade == $thThemeColor3) ? $thThemeColor4 : $thThemeColor3;
dbConnect(0, $strDbHost, $strDbUser, $strDbUKey, $strDbName, $strDbLink);
//global $thThemeColor3, $thThemeColor4;
$strDisplay = "\n";
$strDisplay .= "<table width=\"1000\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" align=\"left\">";
$strDisplay .= "<tr bgcolor=" . $bgcolor . ">";
$strDisplay .= "<td width=\"100\" class=\"thFieldTitle\"><div align=\"left\">PERMIT NO.</div></td>";
$strDisplay .= "<td width=\"200\" class=\"thFieldTitle\"><div align=\"left\">BUSINESS NAME</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thFieldTitle\"><div align=\"left\">BUSINESS CATEGORY</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thFieldTitle\"><div align=\"left\">NATURE OF BUSINESS</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thFieldTitle\"><div align=\"left\">NAME OF OWNER</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thFieldTitle\"><div align=\"left\">CONTACT NO.</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thFieldTitle\"><div align=\"left\"></div>CAPITAL INVESTMENTS</td>";
$strDisplay .= "<td width=\"100\" class=\"thFieldTitle\"><div align=\"left\"></div>BARANGAY</td>";
$strDisplay .= "</tr>";
// store corporate account status in Array
$result = th_query("SELECT b.permit_code, a.business_name, d.business_category_desc, a.business_nature_code, CONCAT_WS(' ', c.owner_first_name, c.owner_middle_name, c.owner_last_name ) AS owner_name, c.owner_phone_no, a.business_capital_investment, a.business_barangay_code FROM ebpls_business_enterprise a, ebpls_transaction b, ebpls_owner c, ebpls_business_category d WHERE a.business_category_code = d.business_category_code AND a.owner_id = c.owner_id AND a.business_id = b.business_id GROUP BY a.business_barangay_code, a.business_name ORDER BY a.business_barangay_code, a.business_name");
while ($row = mysql_fetch_row($result)) {
$strDisplay .= "<tr bgcolor=" . $bgcolor . ">";
$strDisplay .= "<td width=\"100\" class=\"thText\" ><div align=\"left\" >" . $row[0] . "</div></td>";
$strDisplay .= "<td width=\"200\" class=\"thText\" ><div align=\"left\" >" . strtoupper($row[1]) . "</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thText\" ><div align=\"left\" >" . $row[2] . "</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thText\"><div align=\"left\" >" . $row[3] . "</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thText\"><div align=\"left\" >" . $row[4] . "</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thText\"><div align=\"left\" >" . $row[5] . "</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thText\"><div align=\"right\" >" . number_format($row[6], 2) . "</div></td>";
$strDisplay .= "<td width=\"100\" class=\"thText\"><div align=\"left\" >" . $row[7] . "</div></td>";
$strDisplay .= "</tr>";
}
return $strDisplay;
}
function unlockUser($userid, $strLinkName = "thDbLink")
{
$strQuery = "UPDATE ebpls_user SET lockout = null WHERE id = {$userid} LIMIT 1";
$result = th_query($strQuery, $strLinkName);
return $result;
}
</tr>
<tr>
<td width=15% valign=top>DESCRIPTION</td>
<td width=75%><input type=text name=itfodescription size=50 maxlength=80 value="<?php
echo $nitfodescription;
?>
"></td>
</tr>
<tr>
<td width=15% valign=top>TYPE</td>
<td width=75%><select name=itfotype>
<?php
$Dbtype_ = "SELECT * FROM ebpls_buss_taxfeetype ORDER BY taxfeetype ";
$Dbtyperesult = th_query($Dbtype_);
while ($dtarow = @mysql_fetch_array($Dbtyperesult)) {
if ($dtarow[typedesc] == $itfotype) {
$lec = 'selected';
} else {
$lec = '';
}
echo "<option value={$dtarow['taxfeetype']} {$lec}>{$dtarow['typedesc']}";
}
echo "<option value={$nitfotype} SELECTED>{$ntypedesc}";
?>
</select>      
<?php
if ($nitfoindicator == 1) {
//!empty($nitfoindicator) and
?>
<!--qtr4-->
<tr>
<td width=25%>Date Schedule Qtr4 :</td>
<td align=left>
<input type="text" value="<?php
echo $qtr4iMonthlyDueDates;
?>
" readonly name="qtr4iMonthlyDueDates" onclick="displayCalendar(checkid2,'mm-dd',this);">
<img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.qtr4iMonthlyDueDates,'mm-dd',this);_FRM.changeondin.value=1;">
<!--<select name=x31111>
<?php
//$tbl_current
//ebpls_buss_monthlyref
$Optiondata = "SELECT * FROM ebpls_buss_monthlyref ORDER BY id ";
$Optionresult = th_query($Optiondata);
while ($dtarow = @mysql_fetch_array($Optionresult)) {
echo "<option value={$dtarow['moid']}>{$dtarow['modesc']}";
}
echo "<option value={$x31111} SELECTED>{$x31111description}";
?>
</select> <input type=text name=x41111 size=4 maxlength=2 value="<?php
echo $x41111;
?>
"> <?php
echo $iLGURenYear;
?>
<input type=hidden name=x21111 size=4 maxlength=4 value="<?php
echo date('Y');
?>
"> <font size=2><?php
