PageRenderTime 52ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 1ms

/ebpls921.php

http://ebpls.googlecode.com/
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

  1. <?php
  2. require_once("lib/ebpls.lib.php");
  3. require_once("lib/ebpls.utils.php");
  4. require_once("ebpls-php-lib/utils/ebpls.search.funcs.php");
  5. require_once("includes/eBPLS_header.php");
  6. require_once "includes/variables.php";
  7. $rpt = isset($rpt) ? $rpt : ''; //2008.5.13 RJC define undefined variables
  8. $sys_report = isset($sys_report) ? $sys_report : '';
  9. $com = isset($com) ? $com : '';
  10. $buss_select = isset($buss_select) ? $buss_select : '';
  11. $buss_report = isset($buss_report) ? $buss_report : '';
  12. $search = isset($search) ? $search : '';
  13. $bus_selecty = isset($bus_selecty) ? $bus_selecty : '';
  14. $report_file = isset($report_file) ? $report_file :'';
  15. $daytoday = date('d');
  16. $monthtoday = date('m');
  17. $yeartoday = date('Y');
  18. //--- get connection from DB
  19. //$dbLink = get_db_connection();
  20. ?>
  21. <?php
  22. if ($sys_report=='Add') {
  23. $sdup = mysql_query("select * from rpt_temp_abs where tfoid=$rpt_temp");
  24. $sdup = mysql_num_rows($sdup);
  25. if ($sdup==0){
  26. $saveit = mysql_query("insert into rpt_temp_abs values ('',$rpt_temp)");
  27. } else {
  28. echo "<font color=red>Duplicate Entry Found</font>";
  29. }
  30. }
  31. if ($com=='delete') {
  32. $delit = mysql_query("delete from rpt_temp_abs where rpt_id=$rpt_id");
  33. }
  34. if ($buss_select<>'' and $bus_report=='View Report' and $permit_num<>'') {
  35. ?>
  36. <body onLoad=" alert ("gggg");"> </body>
  37. <?php
  38. }
  39. ?>
  40. <script language="JavaScript" src="javascripts/default.js"></script>
  41. <link rel="stylesheet" href="stylesheets/calendar.css?random=20051112" media="screen"></LINK>
  42. <SCRIPT type="text/javascript" src="javascripts/calendar.js?random=20060118"></script>
  43. <script language="javascript">
  44. function PM(x, pn, bn, ci, gs, ol, tr, br)
  45. {
  46. var fr = document._FRM;
  47. if (fr.col_sel.value=='ebpls_orderpayment.php') {
  48. 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');
  49. } else {
  50. 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');
  51. }
  52. }
  53. function AbstractColl(x)
  54. {
  55. // alert(x);
  56. var _FRM = document._FRM;
  57. var vDateSplit1 = _FRM.checkid1.value.split("/");
  58. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  59. var vDateSplit2 = _FRM.checkid2.value.split("/");
  60. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  61. var getDiff = (vDate2-vDate1);
  62. var today = new Date();
  63. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  64. var datefrom = new Date();
  65. var dateto = new Date();
  66. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  67. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  68. if (datefrom > today) {
  69. alert("Date Range cannot exceed current date.");
  70. _FRM.checkid1.select();
  71. return false;
  72. }
  73. if (dateto > today) {
  74. alert("Date Range cannot exceed current date.");
  75. _FRM.checkid2.select();
  76. return false;
  77. }
  78. if (getDiff < 0) {
  79. alert("Invalid Date Range!!");
  80. _FRM.checkid1.select();
  81. return false;
  82. }
  83. winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
  84. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  85. return true;
  86. }
  87. function ComparativeAnnual(x)
  88. {
  89. // alert(x);
  90. var _FRM = document._FRM;
  91. //var vDateSplit1 = _FRM.checkid1.value.split("/");
  92. //vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  93. //var vDateSplit2 = _FRM.checkid2.value.split("/");
  94. //vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  95. //var getDiff = (vDate2-vDate1);
  96. //var today = new Date();
  97. //today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  98. //var datefrom = new Date();
  99. //var dateto = new Date();
  100. //datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  101. //dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  102. //if (datefrom > today) {
  103. // alert("Date Range cannot exceed current date.");
  104. // _FRM.checkid1.select();
  105. // return false;
  106. //}
  107. //if (dateto > today) {
  108. // alert("Date Range cannot exceed current date.");
  109. // _FRM.checkid2.select();
  110. // return false;
  111. //}
  112. //if (getDiff < 0) {
  113. // alert("Invalid Date Range!!");
  114. // _FRM.checkid1.select();
  115. // return false;
  116. //}
  117. winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
  118. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  119. return true;
  120. }
  121. function AuditTrail(x)
  122. {
  123. // alert(x);
  124. var _FRM = document._FRM;
  125. winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&lastn=' + _FRM.owner_last.value + '&pin=' + _FRM.pin.value);
  126. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  127. return true;
  128. }
  129. function CTCIssueds(x)
  130. {
  131. // alert(x);
  132. var _FRM = document._FRM;
  133. var vDateSplit1 = _FRM.checkid1.value.split("/");
  134. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  135. var vDateSplit2 = _FRM.checkid2.value.split("/");
  136. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  137. var getDiff = (vDate2-vDate1);
  138. var today = new Date();
  139. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  140. var datefrom = new Date();
  141. var dateto = new Date();
  142. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  143. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  144. if (datefrom > today) {
  145. alert("Date Range cannot exceed current date.");
  146. _FRM.checkid1.select();
  147. return false;
  148. }
  149. if (dateto > today) {
  150. alert("Date Range cannot exceed current date.");
  151. _FRM.checkid2.select();
  152. return false;
  153. }
  154. if (getDiff < 0) {
  155. alert("Invalid Date Range!!");
  156. _FRM.checkid1.select();
  157. return false;
  158. }
  159. winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value);
  160. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  161. return true;
  162. }
  163. function ComparativeQuart(x)
  164. {
  165. // alert(x);
  166. var _FRM = document._FRM;
  167. //var vDateSplit1 = _FRM.checkid1.value.split("/");
  168. //vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  169. //var vDateSplit2 = _FRM.checkid2.value.split("/");
  170. //vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  171. //var getDiff = (vDate2-vDate1);
  172. //var today = new Date();
  173. //today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  174. //var datefrom = new Date();
  175. //var dateto = new Date();
  176. //datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  177. //dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  178. //if (datefrom > today) {
  179. // alert("Date Range cannot exceed current date.");
  180. // _FRM.checkid1.select();
  181. // return false;
  182. //}
  183. //if (dateto > today) {
  184. // alert("Date Range cannot exceed current date.");
  185. // _FRM.checkid2.select();
  186. // return false;
  187. //}
  188. //if (getDiff < 0) {
  189. // alert("Invalid Date Range!!");
  190. // _FRM.checkid1.select();
  191. // return false;
  192. //}
  193. winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value + '&iQrt=' + _FRM.iQrt.value);
  194. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  195. return true;
  196. }
  197. function ComparativeAnnualChart(x)
  198. {
  199. // alert(x);
  200. var _FRM = document._FRM;
  201. var vDateSplit1 = _FRM.checkid1.value.split("/");
  202. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  203. var vDateSplit2 = _FRM.checkid2.value.split("/");
  204. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  205. var getDiff = (vDate2-vDate1);
  206. var today = new Date();
  207. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  208. var datefrom = new Date();
  209. var dateto = new Date();
  210. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  211. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  212. if (datefrom > today) {
  213. alert("Date Range cannot exceed current date.");
  214. _FRM.checkid1.select();
  215. return false;
  216. }
  217. if (dateto > today) {
  218. alert("Date Range cannot exceed current date.");
  219. _FRM.checkid2.select();
  220. return false;
  221. }
  222. if (getDiff < 0) {
  223. alert("Invalid Date Range!!");
  224. _FRM.checkid1.select();
  225. return false;
  226. }
  227. winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value );
  228. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  229. return true;
  230. }
  231. function BussCollQuart(x)
  232. {
  233. // alert(x);
  234. var _FRM = document._FRM;
  235. var vDateSplit1 = _FRM.checkid1.value.split("/");
  236. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  237. var vDateSplit2 = _FRM.checkid2.value.split("/");
  238. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  239. var getDiff = (vDate2-vDate1);
  240. var today = new Date();
  241. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  242. var datefrom = new Date();
  243. var dateto = new Date();
  244. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  245. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  246. if (datefrom > today) {
  247. alert("Date Range cannot exceed current date.");
  248. _FRM.checkid1.select();
  249. return false;
  250. }
  251. if (dateto > today) {
  252. alert("Date Range cannot exceed current date.");
  253. _FRM.checkid2.select();
  254. return false;
  255. }
  256. if (getDiff < 0) {
  257. alert("Invalid Date Range!!");
  258. _FRM.checkid1.select();
  259. return false;
  260. }
  261. winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value );
  262. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  263. return true;
  264. }
  265. function SummaryCollect(x)
  266. {
  267. var _FRM = document._FRM;
  268. var vDateSplit1 = _FRM.checkid1.value.split("/");
  269. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  270. var vDateSplit2 = _FRM.checkid2.value.split("/");
  271. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  272. var getDiff = (vDate2-vDate1);
  273. var today = new Date();
  274. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  275. var datefrom = new Date();
  276. var dateto = new Date();
  277. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  278. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  279. if (datefrom > today) {
  280. alert("Date Range cannot exceed current date.");
  281. _FRM.checkid1.select();
  282. return false;
  283. }
  284. if (dateto > today) {
  285. alert("Date Range cannot exceed current date.");
  286. _FRM.checkid2.select();
  287. return false;
  288. }
  289. if (getDiff < 0) {
  290. alert("Invalid Date Range!!");
  291. _FRM.checkid1.select();
  292. return false;
  293. }
  294. winpopup = window.open('reports/' + x + '?taxtype=' + _FRM.taxtype.value + '&date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
  295. return true;
  296. }
  297. </script>
  298. <form method=post name=_FRM action='index.php?part=4&class_type=Reports&itemID_=921&busItem=Reports&permit_type=Reports&rpt=<?php echo $rpt;?>'>
  299. <div align="center">
  300. <table border=0 cellspacing=0 cellpadding=0 width='100%'>
  301. <tr><td colspan=2 class=header align=center width=100%>REPORTS</td></tr>
  302. <tr><td colspan=2 ><br></td></tr>
  303. <?php
  304. if ($rpt=='Business') {
  305. ?>
  306. <tr>
  307. <td align="center" valign="top" width=100% colspan=2>
  308. <table border=0 cellspacing=0 cellpadding=0 width='100%'>
  309. <tr>
  310. <td class='header2' colspan=2 align=center>Business Permit</td>
  311. </tr>
  312. <tr>
  313. <td>&nbsp;</td>
  314. </tr>
  315. <tr>
  316. <td width=40% align=right>
  317. Reports </td>
  318. <td width=60% align=left>&nbsp;
  319. <?php
  320. 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);
  321. if ($bus_selecty<>'') {
  322. include_once "class/ReportClass.php";
  323. $gReport=new NewReport;
  324. $gReport->GetReport($bus_selecty);
  325. $rfile=$gReport->outarray;
  326. $report_file=$rfile[report_file];
  327. $report_desc=$rfile[report_desc];
  328. }
  329. ?>
  330. <input type=hidden name=report_file value="<?php echo $report_file; ?>">
  331. <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; ?>">
  332. <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
  333. </td></tr>
  334. <script language="javascript">
  335. function BusEstab()
  336. {
  337. var _FRM = document._FRM;
  338. var vDateSplit1 = _FRM.date_from.value.split("/");
  339. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  340. var vDateSplit2 = _FRM.date_to.value.split("/");
  341. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  342. var getDiff = (vDate2-vDate1);
  343. var today = new Date();
  344. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  345. var datefrom = new Date();
  346. var dateto = new Date();
  347. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  348. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  349. if (datefrom > today) {
  350. alert("Date Range cannot exceed current date.");
  351. _FRM.date_from.select();
  352. return false;
  353. }
  354. if (dateto > today) {
  355. alert("Date Range cannot exceed current date.");
  356. _FRM.date_to.select();
  357. return false;
  358. }
  359. if (getDiff < 0) {
  360. alert("Invalid Date Range!!");
  361. _FRM.date_from.select();
  362. return false;
  363. }
  364. if(parseFloat(_FRM.cap_inv1.value) < 0 || isNaN(_FRM.cap_inv1.value) == true) {
  365. alert("Invalid Capital Investment Range!!");
  366. _FRM.cap_inv1.focus();
  367. _FRM.cap_inv1.select();
  368. return false;
  369. }
  370. if(parseFloat(_FRM.cap_inv1.value) > 999999999999.99) {
  371. alert("Capital Investment Exceeds Max!");
  372. _FRM.cap_inv1.focus();
  373. _FRM.cap_inv1.select();
  374. return false;
  375. }
  376. if (parseFloat(_FRM.cap_inv2.value) < 0 || isNaN(_FRM.cap_inv2.value) == true)
  377. {
  378. alert("Invalid Capital Investment Range!!");
  379. _FRM.cap_inv2.focus();
  380. _FRM.cap_inv2.select();
  381. return false;
  382. }
  383. if(parseFloat(_FRM.cap_inv2.value) > 999999999999.99) {
  384. alert("Capital Investment Exceeds Max!");
  385. _FRM.cap_inv2.focus();
  386. _FRM.cap_inv2.select();
  387. return false;
  388. }
  389. if (parseFloat(_FRM.cap_inv1.value) > parseFloat(_FRM.cap_inv2.value))
  390. {
  391. alert("Invalid Capital Investment Range!!");
  392. _FRM.cap_inv1.focus();
  393. _FRM.cap_inv1.select();
  394. return false;
  395. }
  396. 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);
  397. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  398. return true;
  399. }
  400. function BusExempt()
  401. {
  402. var _FRM = document._FRM;
  403. var vDateSplit1 = _FRM.date_from.value.split("/");
  404. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  405. var vDateSplit2 = _FRM.date_to.value.split("/");
  406. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  407. var getDiff = (vDate2-vDate1);
  408. var today = new Date();
  409. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  410. var datefrom = new Date();
  411. var dateto = new Date();
  412. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  413. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  414. if (datefrom > today) {
  415. alert("Date Range cannot exceed current date.");
  416. _FRM.date_from.select();
  417. return false;
  418. }
  419. if (dateto > today) {
  420. alert("Date Range cannot exceed current date.");
  421. _FRM.date_to.select();
  422. return false;
  423. }
  424. if (getDiff < 0) {
  425. alert("Invalid Date Range!!");
  426. _FRM.date_from.select();
  427. return false;
  428. }
  429. 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);
  430. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  431. return true;
  432. }
  433. function TopEstab()
  434. {
  435. var _FRM = document._FRM;
  436. var vDateSplit1 = _FRM.date_from.value.split("/");
  437. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  438. var vDateSplit2 = _FRM.date_to.value.split("/");
  439. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  440. var getDiff = (vDate2-vDate1);
  441. var today = new Date();
  442. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  443. var datefrom = new Date();
  444. var dateto = new Date();
  445. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  446. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  447. if (datefrom > today) {
  448. alert("Date Range cannot exceed current date.");
  449. _FRM.date_from.select();
  450. return false;
  451. }
  452. if (dateto > today) {
  453. alert("Date Range cannot exceed current date.");
  454. _FRM.date_to.select();
  455. return false;
  456. }
  457. if (getDiff < 0) {
  458. alert("Invalid Date Range!!");
  459. _FRM.date_from.select();
  460. return false;
  461. }
  462. if(parseFloat(_FRM.range1.value) < 0 || isNaN(_FRM.range1.value) == true) {
  463. alert("Invalid Capital Investment Range!!");
  464. _FRM.range1.focus();
  465. _FRM.range1.select();
  466. return false;
  467. }
  468. if(parseFloat(_FRM.range1.value) > 999999999999.99) {
  469. alert("Capital Investment Exceeds Max!");
  470. _FRM.range1.focus();
  471. _FRM.range1.select();
  472. return false;
  473. }
  474. if (parseFloat(_FRM.range2.value) < 0 || isNaN(_FRM.range2.value) == true)
  475. {
  476. alert("Invalid Capital Investment Range!!");
  477. _FRM.range2.focus();
  478. _FRM.range2.select();
  479. return false;
  480. }
  481. if(parseFloat(_FRM.range2.value) > 999999999999.99) {
  482. alert("Capital Investment Exceeds Max!");
  483. _FRM.range2.focus();
  484. _FRM.range2.select();
  485. return false;
  486. }
  487. if (parseFloat(_FRM.range1.value) > parseFloat(_FRM.range2.value))
  488. {
  489. alert("Invalid Capital Investment Range!!");
  490. _FRM.range1.focus();
  491. _FRM.range1.select();
  492. return false;
  493. }
  494. if (parseFloat(_FRM.list_limit.value) <= 0 || isNaN(_FRM.list_limit.value) == true || _FRM.list_limit.value == "")
  495. {
  496. alert("Invalid Limit!");
  497. _FRM.list_limit.focus();
  498. _FRM.list_limit.select();
  499. return false;
  500. }
  501. if (parseFloat(_FRM.list_limit.value) > 100 )
  502. {
  503. alert("Invalid Limit!");
  504. _FRM.list_limit.focus();
  505. _FRM.list_limit.select();
  506. return false;
  507. }
  508. 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);
  509. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  510. return true;
  511. }
  512. function ListEstab()
  513. {
  514. var _FRM = document._FRM;
  515. var vDateSplit1 = _FRM.date_from.value.split("/");
  516. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  517. var vDateSplit2 = _FRM.date_to.value.split("/");
  518. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  519. var getDiff = (vDate2-vDate1);
  520. var today = new Date();
  521. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  522. var datefrom = new Date();
  523. var dateto = new Date();
  524. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  525. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  526. if (datefrom > today) {
  527. alert("Date Range cannot exceed current date.");
  528. _FRM.date_from.select();
  529. return false;
  530. }
  531. if (dateto > today) {
  532. alert("Date Range cannot exceed current date.");
  533. _FRM.date_to.select();
  534. return false;
  535. }
  536. if (getDiff < 0) {
  537. alert("Invalid Date Range!!");
  538. _FRM.date_from.select();
  539. return false;
  540. }
  541. 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);
  542. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  543. return true;
  544. }
  545. function ListEstabW()
  546. {
  547. var _FRM = document._FRM;
  548. var vDateSplit1 = _FRM.date_from.value.split("/");
  549. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  550. var vDateSplit2 = _FRM.date_to.value.split("/");
  551. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  552. var getDiff = (vDate2-vDate1);
  553. var today = new Date();
  554. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  555. var datefrom = new Date();
  556. var dateto = new Date();
  557. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  558. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  559. if (datefrom > today) {
  560. alert("Date Range cannot exceed current date.");
  561. _FRM.date_from.select();
  562. return false;
  563. }
  564. if (dateto > today) {
  565. alert("Date Range cannot exceed current date.");
  566. _FRM.date_to.select();
  567. return false;
  568. }
  569. if (getDiff < 0) {
  570. alert("Invalid Date Range!!");
  571. _FRM.date_from.select();
  572. return false;
  573. }
  574. 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);
  575. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  576. return true;
  577. }
  578. function BussPermit()
  579. {
  580. var _FRM = document._FRM;
  581. if (_FRM.owner_last.value == "" && _FRM.permit_num.value == "" && _FRM.bus_name.value == "" && _FRM.pin.value == "") {
  582. alert("Enter Owner Last Name or Permit Number or Business Name or PIN.");
  583. _FRM.permit_num.focus();
  584. return false;
  585. }
  586. 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);
  587. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  588. return true;
  589. }
  590. function BussPro()
  591. {
  592. var _FRM = document._FRM;
  593. if (_FRM.owner_last.value == "" && _FRM.bus_name.value == "" && _FRM.pin.value == "") {
  594. alert("Enter Owner Last Name or Business Name or PIN.");
  595. _FRM.owner_last.focus();
  596. return false;
  597. }
  598. 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);
  599. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
  600. return true;
  601. }
  602. function Blaklist()
  603. {
  604. var _FRM = document._FRM;
  605. var vDateSplit1 = _FRM.date_from.value.split("/");
  606. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  607. var vDateSplit2 = _FRM.date_to.value.split("/");
  608. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  609. var getDiff = (vDate2-vDate1);
  610. var today = new Date();
  611. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  612. var datefrom = new Date();
  613. var dateto = new Date();
  614. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  615. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  616. if (datefrom > today) {
  617. alert("Date Range cannot exceed current date.");
  618. _FRM.date_from.select();
  619. return false;
  620. }
  621. if (dateto > today) {
  622. alert("Date Range cannot exceed current date.");
  623. _FRM.date_to.select();
  624. return false;
  625. }
  626. if (getDiff < 0) {
  627. alert("Invalid Date Range!!");
  628. _FRM.date_from.select();
  629. return false;
  630. } else {
  631. 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);
  632. return true;
  633. }
  634. }
  635. function ReqDelin()
  636. {
  637. var _FRM = document._FRM;
  638. var vDateSplit1 = _FRM.date_from.value.split("/");
  639. vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
  640. var vDateSplit2 = _FRM.date_to.value.split("/");
  641. vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
  642. var getDiff = (vDate2-vDate1);
  643. var today = new Date();
  644. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  645. var datefrom = new Date();
  646. var dateto = new Date();
  647. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  648. dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
  649. if (datefrom > today) {
  650. alert("Date Range cannot exceed current date.");
  651. _FRM.date_from.select();
  652. return false;
  653. }
  654. if (dateto > today) {
  655. alert("Date Range cannot exceed current date.");
  656. _FRM.date_to.select();
  657. return false;
  658. }
  659. if (getDiff < 0) {
  660. alert("Invalid Date Range!!");
  661. _FRM.date_from.select();
  662. return false;
  663. } else {
  664. 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);
  665. return true;
  666. }
  667. }
  668. function BussComp()
  669. {
  670. var _FRM = document._FRM;
  671. var vDateSplit1 = _FRM.date_from.value.split("/");
  672. var today = new Date();
  673. today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
  674. var datefrom = new Date();
  675. var dateto = new Date();
  676. datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
  677. if (datefrom > today) {
  678. alert("Date cannot exceed current date.");
  679. _FRM.date_from.select();
  680. return false;
  681. }
  682. winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&usernm=' + _FRM.usernm.value);
  683. return true;
  684. }
  685. </script>
  686. <?php
  687. if ($report_file=='ebpls_buslist_blacklist.php') {
  688. ?>
  689. <tr>
  690. <td width=40% align=right>
  691. Date: </td>
  692. <td align="left" valign="top" class='normal'>&nbsp;
  693. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
  694. <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;">
  695. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
  696. <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;">
  697. </td>
  698. </tr>
  699. <tr>
  700. <td width=40% align=right>
  701. Barangay&nbsp;
  702. </td>
  703. <td width=60% align=left>&nbsp;
  704. <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
  705. </td>
  706. </tr>
  707. <tr>
  708. <td>&nbsp;</td>
  709. </tr>
  710. <tr>
  711. <td colspan=2 align=center>
  712. <input type=button name='buss_report' value="View Report" onClick="javascript: Blaklist();">
  713. </td>
  714. </tr>
  715. <?php
  716. }
  717. if ($report_file=='ebpls_summary_busreq_delinquent.php') {
  718. ?>
  719. <tr>
  720. <td width=40% align=right>
  721. Date: </td>
  722. <td align="left" valign="top" class='normal'>&nbsp;
  723. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
  724. <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;">
  725. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
  726. <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;">
  727. </td>
  728. </tr>
  729. <tr>
  730. <td width=40% align=right>
  731. Barangay&nbsp;
  732. </td>
  733. <td width=60% align=left>&nbsp;
  734. <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
  735. </td>
  736. </tr>
  737. <tr>
  738. <td>&nbsp;</td>
  739. </tr>
  740. <tr>
  741. <td colspan=2 align=center>
  742. <input type=button name='buss_report' value="View Report" onClick="javascript: ReqDelin();">
  743. </td>
  744. </tr>
  745. <?php
  746. }
  747. if ($report_file=='ebpls_comparative_business.php') {
  748. ?>
  749. <tr>
  750. <td width=40% align=right>
  751. Date: </td>
  752. <td align="left" valign="top" class='normal'>&nbsp;
  753. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
  754. <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;">
  755. </td>
  756. </tr>
  757. <td>&nbsp;</td>
  758. </tr>
  759. <tr>
  760. <td colspan=2 align=center>
  761. <input type=button name='buss_report' value="View Report" onClick="javascript: BussComp();">
  762. </td>
  763. </tr>
  764. <?php
  765. }
  766. if ($report_file=='ebpls_buss_permit.php') {
  767. ?>
  768. <tr>
  769. <td width=40% align=right>
  770. Permit #&nbsp;
  771. </td>
  772. <td width=60% align=left>&nbsp;
  773. <input type=text name=permit_num>
  774. </td>
  775. </tr>
  776. <tr>
  777. <td width=40% align=right>
  778. Owner Last Name&nbsp;
  779. </td>
  780. <td width=60% align=left>&nbsp;
  781. <input type=text name=owner_last>
  782. </td>
  783. </tr>
  784. <tr>
  785. <td width=40% align=right>
  786. Business Name&nbsp;
  787. </td>
  788. <td width=60% align=left>&nbsp;
  789. <input type=text name=bus_name>
  790. </td>
  791. </tr>
  792. <tr>
  793. <td width=40% align=right>
  794. PIN&nbsp;
  795. </td>
  796. <td width=60% align=left>&nbsp;
  797. <input type=text name=pin>
  798. </td>
  799. </tr>
  800. <tr>
  801. <td>&nbsp;</td>
  802. </tr>
  803. <tr>
  804. <td colspan=2 align=center>
  805. <input type=button name='buss_report' value="View Report" onClick="javascript: BussPermit();">
  806. </td>
  807. </tr>
  808. <?php
  809. }
  810. if ($report_file=='ebpls_business_profile.php') {
  811. ?>
  812. <tr>
  813. <td width=40% align=right>
  814. Owner Last Name&nbsp;
  815. </td>
  816. <td width=60% align=left>&nbsp;
  817. <input type=text name=owner_last>
  818. </td>
  819. </tr>
  820. <tr>
  821. <td width=40% align=right>
  822. Business Name&nbsp;
  823. </td>
  824. <td width=60% align=left>&nbsp;
  825. <input type=text name=bus_name>
  826. </td>
  827. </tr>
  828. <tr>
  829. <td width=40% align=right>
  830. PIN&nbsp;
  831. </td>
  832. <td width=60% align=left>&nbsp;
  833. <input type=text name=pin>
  834. </td>
  835. </tr>
  836. <tr>
  837. <td>&nbsp;</td>
  838. </tr>
  839. <tr>
  840. <td colspan=2 align=center>
  841. <input type=button name='buss_report' value="View Report" onClick="javascript: BussPro();">
  842. </td>
  843. </tr>
  844. <?php
  845. }
  846. if ($report_file=="ebpls_bus_masterlist.php" || $report_file=='ebpls_bus_exemptedlist_full.php') {
  847. ?>
  848. <tr>
  849. <td width=40% align=right>
  850. Date: </td>
  851. <td align="left" valign="top" class='normal'>&nbsp;
  852. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
  853. <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;">
  854. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
  855. <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;">
  856. </td>
  857. </tr>
  858. <?php
  859. if ($report_file=="ebpls_bus_masterlist.php") {
  860. ?>
  861. <tr>
  862. <td width=40% align=right>
  863. Barangay&nbsp;
  864. </td>
  865. <td width=60% align=left>&nbsp;
  866. <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
  867. </td>
  868. </tr>
  869. <?php
  870. }
  871. ?>
  872. <tr>
  873. <td width=40% align=right>
  874. Owner Last Name&nbsp;
  875. </td>
  876. <td width=60% align=left>&nbsp;
  877. <input type=text name='owner_last' value='' >
  878. </td>
  879. </tr>
  880. <tr>
  881. <td width=40% align=right>
  882. Line of Business&nbsp;
  883. </td>
  884. <td width=60% align=left>&nbsp;
  885. <?php
  886. echo get_select_brgy($dbLink,'business_nature_code','ebpls_buss_nature','natureid','naturedesc',$business_nature_code, 'true','naturestatus<>"d" order by naturedesc');
  887. ?>
  888. </td>
  889. </tr>
  890. <?php
  891. if ($report_file=="ebpls_bus_masterlist.php") {
  892. ?>
  893. <tr>
  894. <td width=40% align=right>
  895. <?
  896. if ($trans <> 'New' and $trans <> "") {
  897. ?>
  898. Gross Receipt Range
  899. <?
  900. } else {
  901. ?>
  902. Capital Investment Range
  903. <?
  904. }
  905. if ($trans == 'New') {
  906. $checkit1 = "selected";
  907. } elseif ($trans == 'ReNew') {
  908. $checkit2 = "selected";
  909. } elseif ($trans == 'ReNew') {
  910. $checkit3 = "selected";
  911. } elseif ($trans == 'Retire') {
  912. $checkit3 = "selected";
  913. }
  914. else {
  915. $checkit = "selected";
  916. }
  917. ?>
  918. &nbsp;
  919. </td>
  920. <td width=60% align=left>&nbsp;
  921. <input type=text name='cap_inv1' value='0' >
  922. &nbsp; to &nbsp;
  923. <input type=text name='cap_inv2' value='0' >
  924. </td>
  925. </tr>
  926. <tr>
  927. <td width=40% align=right>
  928. Transaction&nbsp;</td>
  929. <td>&nbsp;
  930. <select name='trans' height="19" style="font-size:10" onchange="javascript: _FRM.submit();">
  931. <option value='' <? echo $checkit;?>>-----</option>
  932. <option value='New' <? echo $checkit1;?>>New</option>
  933. <option value='ReNew' <? echo $checkit2;?>>ReNew</option>
  934. <option value='Retire' <? echo $checkit3;?>>Retire</option>
  935. </select>
  936. </td>
  937. </tr>
  938. <tr>
  939. <td width=40% align=right>
  940. PSIC&nbsp;
  941. </td>
  942. <td width=60% align=left>&nbsp;
  943. <input type=text name='psic' value='' >
  944. </td>
  945. </tr>
  946. <tr>
  947. <td>&nbsp;</td>
  948. </tr>
  949. <tr>
  950. <td colspan=2 align=center>
  951. <input type=button name='buss_report' value="View Report" onClick="javascript:BusEstab();">
  952. </td>
  953. </tr>
  954. <?php
  955. } else {
  956. ?>
  957. <tr>
  958. <td width=40% align=right>
  959. Ownership Type&nbsp;
  960. </td>
  961. <td width=60% align=left>&nbsp;
  962. <?php
  963. if ($report_file=='ebpls_bus_exemptedlist_full.php') {
  964. 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');
  965. } else {
  966. 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');
  967. }
  968. ?>
  969. </td>
  970. </tr>
  971. <tr>
  972. <td width=40% align=right>
  973. Options&nbsp;</td>
  974. <td>&nbsp;
  975. <select name='option' height="19" style="font-size:10">
  976. <option value='1000'>-----</option>
  977. <option value='99'>Partial</option>
  978. <option value='100'>Full</option>
  979. </select>
  980. </td>
  981. </tr>
  982. <tr>
  983. <td>&nbsp;</td>
  984. </tr>
  985. <tr>
  986. <td colspan=2 align=center>
  987. <input type=button name='buss_report' value="View Report" onClick="javascript:BusExempt();">
  988. </td>
  989. </tr>
  990. <?php
  991. }
  992. } elseif ($report_file=="ebpls_bus_topestablishment.php") {
  993. ?>
  994. <tr>
  995. <td width=40% align=right>
  996. Date: </td>
  997. <td align="left" valign="top" class='normal'>&nbsp;
  998. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
  999. <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;">
  1000. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
  1001. <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;">
  1002. </td>
  1003. </tr>
  1004. <tr>
  1005. <td width=40% align=right>
  1006. Barangay&nbsp;
  1007. </td>
  1008. <td width=60% align=left>&nbsp;
  1009. <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
  1010. </td>
  1011. </tr>
  1012. <tr>
  1013. <td width=40% align=right>
  1014. Option&nbsp;
  1015. </td>
  1016. <td width=60% align=left>&nbsp;
  1017. <select name="list_option">
  1018. <option value='Capital Investment'>Capital Investment</option>
  1019. <option value='Gross Receipts'>Gross Receipts</option>
  1020. </td>
  1021. </tr>
  1022. <tr>
  1023. <td width=40% align=right>
  1024. Income Range&nbsp;
  1025. </td>
  1026. <td width=60% align=left>&nbsp;
  1027. <input type=text name='range1' value='0' >
  1028. &nbsp; to &nbsp;
  1029. <input type=text name='range2' value='0' >
  1030. </td>
  1031. </tr>
  1032. <tr>
  1033. <td width=40% align=right>
  1034. List Limit&nbsp;
  1035. </td>
  1036. <td width=60% align=left>&nbsp;
  1037. <input type=text name='list_limit' value='5' >
  1038. </td>
  1039. </tr>
  1040. <tr>
  1041. <td>&nbsp;</td>
  1042. </tr>
  1043. <td colspan=2 align=center>
  1044. <input type=button name='buss_report' value="View Report" onClick="javascript:TopEstab();">
  1045. </td>
  1046. </tr>
  1047. <?php
  1048. } elseif ($report_file=="ebpls_bus_wpermit.php") {
  1049. ?>
  1050. <tr>
  1051. <td width=40% align=right>
  1052. Date: </td>
  1053. <td align="left" valign="top" class='normal'>&nbsp;
  1054. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
  1055. <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;">
  1056. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
  1057. <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;">
  1058. </td>
  1059. </tr>
  1060. <tr>
  1061. <td width=40% align=right>
  1062. Barangay&nbsp;
  1063. </td>
  1064. <td width=60% align=left>&nbsp;
  1065. <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
  1066. </td>
  1067. </tr>
  1068. <tr>
  1069. <td width=40% align=right>
  1070. Owner Last Name&nbsp;
  1071. </td>
  1072. <td width=60% align=left>&nbsp;
  1073. <input type=text name='owner_last' value='' >
  1074. </td>
  1075. </tr>
  1076. <tr>
  1077. <td width=40% align=right>
  1078. Options&nbsp;</td>
  1079. <td>&nbsp;
  1080. <select name='paid' height="19" style="font-size:10">
  1081. <option value=''>-----</option>
  1082. <option value='1'>Paid</option>
  1083. <option value='0'>UnPaid</option>
  1084. </select>
  1085. </td>
  1086. </tr>
  1087. <tr>
  1088. <td>&nbsp;</td>
  1089. </tr>
  1090. <td colspan=2 align=center>
  1091. <input type=button name='buss_report' value="View Report" onClick="javascript:ListEstab();">
  1092. </td>
  1093. </tr>
  1094. <?php
  1095. } elseif ($report_file=="ebpls_bus_woutpermit.php") {
  1096. ?>
  1097. <tr>
  1098. <td width=40% align=right>
  1099. Date: </td>
  1100. <td align="left" valign="top" class='normal'>&nbsp;
  1101. <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