/ebpls921.php
PHP | 2953 lines | 2681 code | 172 blank | 100 comment | 140 complexity | 01699b7ec78e7c8eb3acebe610722a52 MD5 | raw file
Large files files are truncated, but you can click here to view the full file
- <?php
- require_once("lib/ebpls.lib.php");
- require_once("lib/ebpls.utils.php");
- require_once("ebpls-php-lib/utils/ebpls.search.funcs.php");
- require_once("includes/eBPLS_header.php");
- require_once "includes/variables.php";
- $rpt = isset($rpt) ? $rpt : ''; //2008.5.13 RJC define undefined variables
- $sys_report = isset($sys_report) ? $sys_report : '';
- $com = isset($com) ? $com : '';
- $buss_select = isset($buss_select) ? $buss_select : '';
- $buss_report = isset($buss_report) ? $buss_report : '';
- $search = isset($search) ? $search : '';
- $bus_selecty = isset($bus_selecty) ? $bus_selecty : '';
- $report_file = isset($report_file) ? $report_file :'';
- $daytoday = date('d');
- $monthtoday = date('m');
- $yeartoday = date('Y');
- //--- get connection from DB
- //$dbLink = get_db_connection();
- ?>
- <?php
- if ($sys_report=='Add') {
- $sdup = mysql_query("select * from rpt_temp_abs where tfoid=$rpt_temp");
- $sdup = mysql_num_rows($sdup);
- if ($sdup==0){
- $saveit = mysql_query("insert into rpt_temp_abs values ('',$rpt_temp)");
- } else {
- echo "<font color=red>Duplicate Entry Found</font>";
- }
- }
- if ($com=='delete') {
- $delit = mysql_query("delete from rpt_temp_abs where rpt_id=$rpt_id");
- }
- if ($buss_select<>'' and $bus_report=='View Report' and $permit_num<>'') {
- ?>
- <body onLoad=" alert ("gggg");"> </body>
- <?php
- }
- ?>
- <script language="JavaScript" src="javascripts/default.js"></script>
- <link rel="stylesheet" href="stylesheets/calendar.css?random=20051112" media="screen"></LINK>
- <SCRIPT type="text/javascript" src="javascripts/calendar.js?random=20060118"></script>
- <script language="javascript">
- function PM(x, pn, bn, ci, gs, ol, tr, br)
- {
-
- var fr = document._FRM;
-
- if (fr.col_sel.value=='ebpls_orderpayment.php') {
- winpopup = window.open('reports/' + fr.col_sel.value + '?date_from=' + fr.checkid1.value + '&date_to=' + fr.checkid2.value + '&owner_last_name=' + fr.owner_last_name.value + '&owner_first_name=' + fr.owner_first_name.value + '&business_name=' + fr.business_name.value,'popup','height=800,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0,resizable=1');
- } else {
-
- winpopup = window.open('reports/' + fr.col_sel.value + '?date_from=' + fr.checkid1.value + '&date_to=' + fr.checkid2.value,'popup','height=800,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0,resizable=1');
- }
-
-
- }
- function AbstractColl(x)
- {
- // alert(x);
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.checkid1.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.checkid2.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid1.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid2.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.checkid1.select();
- return false;
- }
- winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function ComparativeAnnual(x)
- {
- // alert(x);
- var _FRM = document._FRM;
- //var vDateSplit1 = _FRM.checkid1.value.split("/");
- //vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- //var vDateSplit2 = _FRM.checkid2.value.split("/");
- //vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- //var getDiff = (vDate2-vDate1);
- //var today = new Date();
- //today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- //var datefrom = new Date();
- //var dateto = new Date();
- //datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- //dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- //if (datefrom > today) {
- // alert("Date Range cannot exceed current date.");
- // _FRM.checkid1.select();
- // return false;
- //}
- //if (dateto > today) {
- // alert("Date Range cannot exceed current date.");
- // _FRM.checkid2.select();
- // return false;
- //}
- //if (getDiff < 0) {
- // alert("Invalid Date Range!!");
- // _FRM.checkid1.select();
- // return false;
- //}
- winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function AuditTrail(x)
- {
- // alert(x);
- var _FRM = document._FRM;
- winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&lastn=' + _FRM.owner_last.value + '&pin=' + _FRM.pin.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function CTCIssueds(x)
- {
- // alert(x);
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.checkid1.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.checkid2.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid1.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid2.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.checkid1.select();
- return false;
- }
- winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function ComparativeQuart(x)
- {
- // alert(x);
- var _FRM = document._FRM;
- //var vDateSplit1 = _FRM.checkid1.value.split("/");
- //vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- //var vDateSplit2 = _FRM.checkid2.value.split("/");
- //vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- //var getDiff = (vDate2-vDate1);
- //var today = new Date();
- //today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- //var datefrom = new Date();
- //var dateto = new Date();
- //datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- //dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- //if (datefrom > today) {
- // alert("Date Range cannot exceed current date.");
- // _FRM.checkid1.select();
- // return false;
- //}
- //if (dateto > today) {
- // alert("Date Range cannot exceed current date.");
- // _FRM.checkid2.select();
- // return false;
- //}
- //if (getDiff < 0) {
- // alert("Invalid Date Range!!");
- // _FRM.checkid1.select();
- // return false;
- //}
- winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value + '&iQrt=' + _FRM.iQrt.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function ComparativeAnnualChart(x)
- {
- // alert(x);
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.checkid1.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.checkid2.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid1.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid2.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.checkid1.select();
- return false;
- }
- winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value );
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
- }
- function BussCollQuart(x)
- {
- // alert(x);
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.checkid1.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.checkid2.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid1.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid2.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.checkid1.select();
- return false;
- }
- winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value );
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
- }
-
- function SummaryCollect(x)
- {
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.checkid1.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.checkid2.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid1.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.checkid2.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.checkid1.select();
- return false;
- }
- winpopup = window.open('reports/' + x + '?taxtype=' + _FRM.taxtype.value + '&date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
- return true;
- }
- </script>
- <form method=post name=_FRM action='index.php?part=4&class_type=Reports&itemID_=921&busItem=Reports&permit_type=Reports&rpt=<?php echo $rpt;?>'>
- <div align="center">
- <table border=0 cellspacing=0 cellpadding=0 width='100%'>
- <tr><td colspan=2 class=header align=center width=100%>REPORTS</td></tr>
- <tr><td colspan=2 ><br></td></tr>
- <?php
- if ($rpt=='Business') {
- ?>
- <tr>
- <td align="center" valign="top" width=100% colspan=2>
- <table border=0 cellspacing=0 cellpadding=0 width='100%'>
- <tr>
- <td class='header2' colspan=2 align=center>Business Permit</td>
- </tr>
- <tr>
- <td> </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Reports </td>
- <td width=60% align=left>
- <?php
-
- echo get_select_reports($dbLink,"bus_selecty","ebpls_reports","report_id","report_desc","$bus_selecty","true","report_type='$rpt' order by report_desc asc","onchange='_FRM.submit();'",$user_id);
- if ($bus_selecty<>'') {
- include_once "class/ReportClass.php";
- $gReport=new NewReport;
- $gReport->GetReport($bus_selecty);
- $rfile=$gReport->outarray;
- $report_file=$rfile[report_file];
- $report_desc=$rfile[report_desc];
- }
- ?>
- <input type=hidden name=report_file value="<?php echo $report_file; ?>">
- <input type=hidden name=reetFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);ort_file value="<?php echo $report_file; ?>">
- <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
- </td></tr>
- <script language="javascript">
- function BusEstab()
- {
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.date_from.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.date_to.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_from.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_to.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.date_from.select();
- return false;
- }
- if(parseFloat(_FRM.cap_inv1.value) < 0 || isNaN(_FRM.cap_inv1.value) == true) {
- alert("Invalid Capital Investment Range!!");
- _FRM.cap_inv1.focus();
- _FRM.cap_inv1.select();
- return false;
- }
- if(parseFloat(_FRM.cap_inv1.value) > 999999999999.99) {
- alert("Capital Investment Exceeds Max!");
- _FRM.cap_inv1.focus();
- _FRM.cap_inv1.select();
- return false;
- }
- if (parseFloat(_FRM.cap_inv2.value) < 0 || isNaN(_FRM.cap_inv2.value) == true)
- {
- alert("Invalid Capital Investment Range!!");
- _FRM.cap_inv2.focus();
- _FRM.cap_inv2.select();
- return false;
- }
- if(parseFloat(_FRM.cap_inv2.value) > 999999999999.99) {
- alert("Capital Investment Exceeds Max!");
- _FRM.cap_inv2.focus();
- _FRM.cap_inv2.select();
- return false;
- }
- if (parseFloat(_FRM.cap_inv1.value) > parseFloat(_FRM.cap_inv2.value))
- {
- alert("Invalid Capital Investment Range!!");
- _FRM.cap_inv1.focus();
- _FRM.cap_inv1.select();
- return false;
- }
- winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&brgy_name=' + _FRM.brgy_name.value + '&owner_last=' + _FRM.owner_last.value + '&business_nature_code=' + _FRM.business_nature_code.value + '&cap_inv1=' + _FRM.cap_inv1.value + '&cap_inv2=' + _FRM.cap_inv2.value + '&trans=' + _FRM.trans.value + '&psic=' + _FRM.psic.value + '&usernm=' + _FRM.usernm.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
- }
- function BusExempt()
- {
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.date_from.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.date_to.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_from.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_to.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.date_from.select();
- return false;
- }
- winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&owner_last=' + _FRM.owner_last.value + '&business_nature_code=' + _FRM.business_nature_code.value + '&business_category=' + _FRM.business_category.value + '&option=' + _FRM.option.value + '&usernm=' + _FRM.usernm.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
- }
- function TopEstab()
- {
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.date_from.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.date_to.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_from.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_to.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.date_from.select();
- return false;
- }
- if(parseFloat(_FRM.range1.value) < 0 || isNaN(_FRM.range1.value) == true) {
- alert("Invalid Capital Investment Range!!");
- _FRM.range1.focus();
- _FRM.range1.select();
- return false;
- }
- if(parseFloat(_FRM.range1.value) > 999999999999.99) {
- alert("Capital Investment Exceeds Max!");
- _FRM.range1.focus();
- _FRM.range1.select();
- return false;
- }
- if (parseFloat(_FRM.range2.value) < 0 || isNaN(_FRM.range2.value) == true)
- {
- alert("Invalid Capital Investment Range!!");
- _FRM.range2.focus();
- _FRM.range2.select();
- return false;
- }
- if(parseFloat(_FRM.range2.value) > 999999999999.99) {
- alert("Capital Investment Exceeds Max!");
- _FRM.range2.focus();
- _FRM.range2.select();
- return false;
- }
- if (parseFloat(_FRM.range1.value) > parseFloat(_FRM.range2.value))
- {
- alert("Invalid Capital Investment Range!!");
- _FRM.range1.focus();
- _FRM.range1.select();
- return false;
- }
- if (parseFloat(_FRM.list_limit.value) <= 0 || isNaN(_FRM.list_limit.value) == true || _FRM.list_limit.value == "")
- {
- alert("Invalid Limit!");
- _FRM.list_limit.focus();
- _FRM.list_limit.select();
- return false;
- }
- if (parseFloat(_FRM.list_limit.value) > 100 )
- {
- alert("Invalid Limit!");
- _FRM.list_limit.focus();
- _FRM.list_limit.select();
- return false;
- }
- winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&brgy_name=' + _FRM.brgy_name.value + '&list_option=' + _FRM.list_option.value + '&range1=' + _FRM.range1.value + '&range2=' + _FRM.range2.value + '&list_limit=' + _FRM.list_limit.value+ '&usernm=' + _FRM.usernm.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function ListEstab()
- {
-
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.date_from.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.date_to.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_from.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_to.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.date_from.select();
- return false;
- }
- winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&brgy_name=' + _FRM.brgy_name.value + '&owner_last=' + _FRM.owner_last.value + '&paid=' + _FRM.paid.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function ListEstabW()
- {
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.date_from.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.date_to.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_from.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_to.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.date_from.select();
- return false;
- }
- winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&brgy_name=' + _FRM.brgy_name.value + '&owner_last=' + _FRM.owner_last.value + '&paid=' + _FRM.paid.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function BussPermit()
- {
- var _FRM = document._FRM;
- if (_FRM.owner_last.value == "" && _FRM.permit_num.value == "" && _FRM.bus_name.value == "" && _FRM.pin.value == "") {
- alert("Enter Owner Last Name or Permit Number or Business Name or PIN.");
- _FRM.permit_num.focus();
- return false;
- }
- winpopup = window.open('reports/ebpls_buss_permit.php?owner_last=' + _FRM.owner_last.value + '&permit_num=' + _FRM.permit_num.value + '&reportpermit=1&permit_type=Business' + '&bus_name=' + _FRM.bus_name.value + '&pin=' + _FRM.pin.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function BussPro()
- {
- var _FRM = document._FRM;
- if (_FRM.owner_last.value == "" && _FRM.bus_name.value == "" && _FRM.pin.value == "") {
- alert("Enter Owner Last Name or Business Name or PIN.");
- _FRM.owner_last.focus();
- return false;
- }
- winpopup = window.open('reports/ebpls_orderpayment.php?profile=prof&owner_last=' + _FRM.owner_last.value + '&reportpermit=1&permit_type=Business' + '&bus_name=' + _FRM.bus_name.value + '&pin=' + _FRM.pin.value);
- //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
- return true;
-
-
- }
- function Blaklist()
- {
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.date_from.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.date_to.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_from.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_to.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.date_from.select();
- return false;
- } else {
- winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&barangay=' + _FRM.brgy_name.value + '&usernm=' + _FRM.usernm.value);
- return true;
- }
- }
- function ReqDelin()
- {
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.date_from.value.split("/");
- vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
- var vDateSplit2 = _FRM.date_to.value.split("/");
- vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
- var getDiff = (vDate2-vDate1);
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
- dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
-
- if (datefrom > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_from.select();
- return false;
- }
- if (dateto > today) {
- alert("Date Range cannot exceed current date.");
- _FRM.date_to.select();
- return false;
- }
- if (getDiff < 0) {
- alert("Invalid Date Range!!");
- _FRM.date_from.select();
- return false;
- } else {
- winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&barangay=' + _FRM.brgy_name.value + '&usernm=' + _FRM.usernm.value);
- return true;
- }
- }
- function BussComp()
- {
- var _FRM = document._FRM;
- var vDateSplit1 = _FRM.date_from.value.split("/");
- var today = new Date();
- today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
- var datefrom = new Date();
- var dateto = new Date();
- datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
-
- if (datefrom > today) {
- alert("Date cannot exceed current date.");
- _FRM.date_from.select();
- return false;
- }
- winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&usernm=' + _FRM.usernm.value);
- return true;
- }
- </script>
- <?php
- if ($report_file=='ebpls_buslist_blacklist.php') {
- ?>
- <tr>
- <td width=40% align=right>
- Date: </td>
- <td align="left" valign="top" class='normal'>
-
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_from,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_to,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Barangay
- </td>
- <td width=60% align=left>
- <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
- </td>
- </tr>
- <tr>
- <td> </td>
- </tr>
- <tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript: Blaklist();">
- </td>
- </tr>
- <?php
- }
- if ($report_file=='ebpls_summary_busreq_delinquent.php') {
- ?>
- <tr>
- <td width=40% align=right>
- Date: </td>
- <td align="left" valign="top" class='normal'>
-
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_from,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_to,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Barangay
- </td>
- <td width=60% align=left>
- <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
- </td>
- </tr>
- <tr>
- <td> </td>
- </tr>
- <tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript: ReqDelin();">
- </td>
- </tr>
- <?php
- }
- if ($report_file=='ebpls_comparative_business.php') {
- ?>
- <tr>
- <td width=40% align=right>
- Date: </td>
- <td align="left" valign="top" class='normal'>
-
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_from,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
- </td>
- </tr>
- <td> </td>
- </tr>
- <tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript: BussComp();">
- </td>
- </tr>
- <?php
- }
- if ($report_file=='ebpls_buss_permit.php') {
- ?>
- <tr>
- <td width=40% align=right>
- Permit #
- </td>
- <td width=60% align=left>
- <input type=text name=permit_num>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Owner Last Name
- </td>
- <td width=60% align=left>
- <input type=text name=owner_last>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Business Name
- </td>
- <td width=60% align=left>
- <input type=text name=bus_name>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- PIN
- </td>
- <td width=60% align=left>
- <input type=text name=pin>
- </td>
- </tr>
- <tr>
- <td> </td>
- </tr>
- <tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript: BussPermit();">
- </td>
- </tr>
- <?php
- }
- if ($report_file=='ebpls_business_profile.php') {
- ?>
- <tr>
- <td width=40% align=right>
- Owner Last Name
- </td>
- <td width=60% align=left>
- <input type=text name=owner_last>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Business Name
- </td>
- <td width=60% align=left>
- <input type=text name=bus_name>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- PIN
- </td>
- <td width=60% align=left>
- <input type=text name=pin>
- </td>
- </tr>
- <tr>
- <td> </td>
- </tr>
- <tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript: BussPro();">
- </td>
- </tr>
- <?php
- }
- if ($report_file=="ebpls_bus_masterlist.php" || $report_file=='ebpls_bus_exemptedlist_full.php') {
- ?>
- <tr>
- <td width=40% align=right>
- Date: </td>
- <td align="left" valign="top" class='normal'>
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_from,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_to,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
- </td>
- </tr>
- <?php
- if ($report_file=="ebpls_bus_masterlist.php") {
- ?>
- <tr>
- <td width=40% align=right>
- Barangay
- </td>
- <td width=60% align=left>
- <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
- </td>
- </tr>
- <?php
- }
- ?>
- <tr>
- <td width=40% align=right>
- Owner Last Name
- </td>
- <td width=60% align=left>
- <input type=text name='owner_last' value='' >
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Line of Business
- </td>
- <td width=60% align=left>
- <?php
- echo get_select_brgy($dbLink,'business_nature_code','ebpls_buss_nature','natureid','naturedesc',$business_nature_code, 'true','naturestatus<>"d" order by naturedesc');
- ?>
- </td>
- </tr>
- <?php
- if ($report_file=="ebpls_bus_masterlist.php") {
- ?>
- <tr>
- <td width=40% align=right>
- <?
- if ($trans <> 'New' and $trans <> "") {
- ?>
- Gross Receipt Range
- <?
- } else {
- ?>
- Capital Investment Range
- <?
- }
- if ($trans == 'New') {
- $checkit1 = "selected";
- } elseif ($trans == 'ReNew') {
- $checkit2 = "selected";
- } elseif ($trans == 'ReNew') {
- $checkit3 = "selected";
- } elseif ($trans == 'Retire') {
- $checkit3 = "selected";
- }
- else {
- $checkit = "selected";
- }
- ?>
-
- </td>
- <td width=60% align=left>
- <input type=text name='cap_inv1' value='0' >
- to
- <input type=text name='cap_inv2' value='0' >
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Transaction </td>
- <td>
- <select name='trans' height="19" style="font-size:10" onchange="javascript: _FRM.submit();">
- <option value='' <? echo $checkit;?>>-----</option>
- <option value='New' <? echo $checkit1;?>>New</option>
- <option value='ReNew' <? echo $checkit2;?>>ReNew</option>
- <option value='Retire' <? echo $checkit3;?>>Retire</option>
- </select>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- PSIC
- </td>
- <td width=60% align=left>
- <input type=text name='psic' value='' >
- </td>
- </tr>
- <tr>
- <td> </td>
- </tr>
- <tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript:BusEstab();">
- </td>
- </tr>
- <?php
- } else {
- ?>
- <tr>
- <td width=40% align=right>
- Ownership Type
- </td>
- <td width=60% align=left>
- <?php
- if ($report_file=='ebpls_bus_exemptedlist_full.php') {
- echo get_select_brgy($dbLink,'business_category','ebpls_business_category','business_category_code','business_category_desc',$business_category, 'true','business_category_code<>"d" and tax_exemption > 0 order by business_category_desc');
- } else {
- echo get_select_brgy($dbLink,'business_category','ebpls_business_category','business_category_code','business_category_desc',$business_category, 'true','business_category_code<>"d" order by business_category_desc');
- }
- ?>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Options </td>
- <td>
- <select name='option' height="19" style="font-size:10">
- <option value='1000'>-----</option>
- <option value='99'>Partial</option>
- <option value='100'>Full</option>
- </select>
- </td>
- </tr>
- <tr>
- <td> </td>
- </tr>
- <tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript:BusExempt();">
- </td>
- </tr>
- <?php
- }
- } elseif ($report_file=="ebpls_bus_topestablishment.php") {
- ?>
- <tr>
- <td width=40% align=right>
- Date: </td>
- <td align="left" valign="top" class='normal'>
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_from,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_to,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Barangay
- </td>
- <td width=60% align=left>
- <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Option
- </td>
- <td width=60% align=left>
- <select name="list_option">
- <option value='Capital Investment'>Capital Investment</option>
- <option value='Gross Receipts'>Gross Receipts</option>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Income Range
- </td>
- <td width=60% align=left>
- <input type=text name='range1' value='0' >
- to
- <input type=text name='range2' value='0' >
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- List Limit
- </td>
- <td width=60% align=left>
- <input type=text name='list_limit' value='5' >
- </td>
- </tr>
-
- <tr>
- <td> </td>
- </tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript:TopEstab();">
- </td>
- </tr>
- <?php
- } elseif ($report_file=="ebpls_bus_wpermit.php") {
- ?>
- <tr>
- <td width=40% align=right>
- Date: </td>
- <td align="left" valign="top" class='normal'>
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_from,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
- <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.date_to,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Barangay
- </td>
- <td width=60% align=left>
- <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Owner Last Name
- </td>
- <td width=60% align=left>
- <input type=text name='owner_last' value='' >
- </td>
- </tr>
- <tr>
- <td width=40% align=right>
- Options </td>
- <td>
- <select name='paid' height="19" style="font-size:10">
- <option value=''>-----</option>
- <option value='1'>Paid</option>
- <option value='0'>UnPaid</option>
- </select>
- </td>
- </tr>
- <tr>
- <td> </td>
- </tr>
- <td colspan=2 align=center>
- <input type=button name='buss_report' value="View Report" onClick="javascript:ListEstab();">
- </td>
- </tr>
- <?php
- } elseif ($report_file=="ebpls_bus_woutpermit.php") {
- ?>
- <tr>
- <td width=40% align=right>
- Date: </td>
- <td align="left" valign="top" class='normal'>
-
- <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="display…
Large files files are truncated, but you can click here to view the full file