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