PageRenderTime 70ms 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
    

  1. <?php 
    2. 

  2. require_once("lib/ebpls.lib.php");
    3. 

  3. require_once("lib/ebpls.utils.php");                                                                                                                        
    4. 

  4. require_once("ebpls-php-lib/utils/ebpls.search.funcs.php");
    5. 

  5. require_once("includes/eBPLS_header.php");
    6. 

  6. require_once "includes/variables.php";                                                                                                                                                                                                                                     
    7. 

  7. 

  8. $rpt = isset($rpt) ? $rpt : ''; //2008.5.13 RJC define undefined variables 
    9. 

  9. $sys_report = isset($sys_report) ? $sys_report : '';
    10. 

  10. $com = isset($com) ? $com : '';
    11. 

  11. $buss_select = isset($buss_select) ? $buss_select : '';
    12. 

  12. $buss_report = isset($buss_report) ? $buss_report : '';
    13. 

  13. $search = isset($search) ? $search : '';
    14. 

  14. $bus_selecty = isset($bus_selecty) ? $bus_selecty : '';
    15. 

  15. $report_file = isset($report_file) ? $report_file :'';
    16. 

  16. 

  17. $daytoday = date('d');
    18. 

  18. $monthtoday = date('m');
    19. 

  19. $yeartoday = date('Y');
    20. 

  20. //--- get connection from DB
    21. 

  21. //$dbLink = get_db_connection();
    22. 

  22. 

  23. ?>
    24. 

  24. <?php
    25. 

  25. if ($sys_report=='Add') {
    26. 

  26. 	$sdup = mysql_query("select * from rpt_temp_abs where tfoid=$rpt_temp");
    27. 

  27. 	$sdup = mysql_num_rows($sdup);
    28. 

  28. 	if ($sdup==0){
    29. 

  29. 	$saveit = mysql_query("insert into rpt_temp_abs values ('',$rpt_temp)");
    30. 

  30. 	} else {
    31. 

  31. 	echo "<font color=red>Duplicate Entry Found</font>";
    32. 

  32. 	}
    33. 

  33. }
    34. 

  34. 

  35. if ($com=='delete') {
    36. 

  36. 	$delit = mysql_query("delete from rpt_temp_abs where rpt_id=$rpt_id");
    37. 

  37. }
    38. 

  38. 

  39. 

  40. if ($buss_select<>'' and $bus_report=='View Report' and $permit_num<>'') {
    41. 

  41. 

  42. ?>
    43. 

  43. <body onLoad=" alert ("gggg");"> </body>
    44. 

  44. <?php
    45. 

  45. }
    46. 

  46. ?>
    47. 

  47. 

  48. <script language="JavaScript" src="javascripts/default.js"></script>
    49. 

  49. <link rel="stylesheet" href="stylesheets/calendar.css?random=20051112" media="screen"></LINK>
    50. 

  50. <SCRIPT type="text/javascript" src="javascripts/calendar.js?random=20060118"></script>
    51. 

  51. <script language="javascript">
    52. 

  52. function PM(x, pn, bn, ci, gs, ol, tr, br)
    53. 

  53.         {
    54. 

  54.        
    55. 

  55.         var fr = document._FRM;
    56. 

  56.   
    57. 

  57.         	if (fr.col_sel.value=='ebpls_orderpayment.php') {
    58. 

  58. 	        	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');
    59. 

  59.     		} else {
    60. 

  60. 	
    61. 

  61.         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');
    62. 

  62.     		}
    63. 

  63.         
    64. 

  64.                                                                                                                                                             
    65. 

  65.         }
    66. 

  66. function AbstractColl(x)
    67. 

  67.         {
    68. 

  68. //		alert(x);
    69. 

  69.         var _FRM = document._FRM;
    70. 

  70. 		var vDateSplit1 = _FRM.checkid1.value.split("/");
    71. 

  71. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    72. 

  72. 		var vDateSplit2 = _FRM.checkid2.value.split("/");
    73. 

  73. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    74. 

  74. 		var getDiff = (vDate2-vDate1);
    75. 

  75. 		var today = new Date();
    76. 

  76. 		today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    77. 

  77. 		var datefrom = new Date();
    78. 

  78. 		var dateto = new Date();
    79. 

  79. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    80. 

  80. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    81. 

  81. 		
    82. 

  82. 		if (datefrom > today) {
    83. 

  83. 			alert("Date Range cannot exceed current date.");
    84. 

  84. 			_FRM.checkid1.select();
    85. 

  85. 			return false;
    86. 

  86. 		}
    87. 

  87. 		if (dateto > today) {
    88. 

  88. 			alert("Date Range cannot exceed current date.");
    89. 

  89. 			_FRM.checkid2.select();
    90. 

  90. 			return false;
    91. 

  91. 		}
    92. 

  92. 		if (getDiff < 0) {
    93. 

  93. 			alert("Invalid Date Range!!");
    94. 

  94. 			_FRM.checkid1.select();
    95. 

  95. 			return false;
    96. 

  96. 		}
    97. 

  97.         winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
    98. 

  98. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    99. 

  99.         return true;
    100. 

  100.                                                                                                  
    101. 

  101.                                                                                                  
    102. 

  102. }
    103. 

  103. function ComparativeAnnual(x)
    104. 

  104.         {
    105. 

  105. //              alert(x);
    106. 

  106.         var _FRM = document._FRM;
    107. 

  107. 		//var vDateSplit1 = _FRM.checkid1.value.split("/");
    108. 

  108. 		//vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    109. 

  109. 		//var vDateSplit2 = _FRM.checkid2.value.split("/");
    110. 

  110. 		//vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    111. 

  111. 		//var getDiff = (vDate2-vDate1);
    112. 

  112. 		//var today = new Date();
    113. 

  113. 		//today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    114. 

  114. 		//var datefrom = new Date();
    115. 

  115. 		//var dateto = new Date();
    116. 

  116. 		//datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    117. 

  117. 		//dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    118. 

  118. 		
    119. 

  119. 		//if (datefrom > today) {
    120. 

  120. 		//	alert("Date Range cannot exceed current date.");
    121. 

  121. 		//	_FRM.checkid1.select();
    122. 

  122. 		//	return false;
    123. 

  123. 		//}
    124. 

  124. 		//if (dateto > today) {
    125. 

  125. 		//	alert("Date Range cannot exceed current date.");
    126. 

  126. 		//	_FRM.checkid2.select();
    127. 

  127. 		//	return false;
    128. 

  128. 		//}
    129. 

  129. 		//if (getDiff < 0) {
    130. 

  130. 		//	alert("Invalid Date Range!!");
    131. 

  131. 		//	_FRM.checkid1.select();
    132. 

  132. 		//	return false;
    133. 

  133. 		//}
    134. 

  134.         winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
    135. 

  135. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    136. 

  136.         return true;
    137. 

  137.  
    138. 

  138.  
    139. 

  139. }        
    140. 

  140. function AuditTrail(x)
    141. 

  141.         {
    142. 

  142. //              alert(x);
    143. 

  143.         var _FRM = document._FRM;
    144. 

  144.         winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value +  '&lastn=' + _FRM.owner_last.value + '&pin=' + _FRM.pin.value);
    145. 

  145. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    146. 

  146.         return true;
    147. 

  147.  
    148. 

  148.  
    149. 

  149. }        
    150. 

  150. function CTCIssueds(x)
    151. 

  151.         {
    152. 

  152. //              alert(x);
    153. 

  153.         var _FRM = document._FRM;
    154. 

  154. 		var vDateSplit1 = _FRM.checkid1.value.split("/");
    155. 

  155. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    156. 

  156. 		var vDateSplit2 = _FRM.checkid2.value.split("/");
    157. 

  157. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    158. 

  158. 		var getDiff = (vDate2-vDate1);
    159. 

  159. 		var today = new Date();
    160. 

  160. 		today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    161. 

  161. 		var datefrom = new Date();
    162. 

  162. 		var dateto = new Date();
    163. 

  163. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    164. 

  164. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    165. 

  165. 		
    166. 

  166. 		if (datefrom > today) {
    167. 

  167. 			alert("Date Range cannot exceed current date.");
    168. 

  168. 			_FRM.checkid1.select();
    169. 

  169. 			return false;
    170. 

  170. 		}
    171. 

  171. 		if (dateto > today) {
    172. 

  172. 			alert("Date Range cannot exceed current date.");
    173. 

  173. 			_FRM.checkid2.select();
    174. 

  174. 			return false;
    175. 

  175. 		}
    176. 

  176. 		if (getDiff < 0) {
    177. 

  177. 			alert("Invalid Date Range!!");
    178. 

  178. 			_FRM.checkid1.select();
    179. 

  179. 			return false;
    180. 

  180. 		}
    181. 

  181.         winpopup = window.open('reports/' + x + '?date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value);
    182. 

  182. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    183. 

  183.         return true;
    184. 

  184.  
    185. 

  185.  
    186. 

  186. }        
    187. 

  187. function ComparativeQuart(x)
    188. 

  188.         {
    189. 

  189. //              alert(x);
    190. 

  190.         var _FRM = document._FRM;
    191. 

  191. 		//var vDateSplit1 = _FRM.checkid1.value.split("/");
    192. 

  192. 		//vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    193. 

  193. 		//var vDateSplit2 = _FRM.checkid2.value.split("/");
    194. 

  194. 		//vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    195. 

  195. 		//var getDiff = (vDate2-vDate1);
    196. 

  196. 		//var today = new Date();
    197. 

  197. 		//today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    198. 

  198. 		//var datefrom = new Date();
    199. 

  199. 		//var dateto = new Date();
    200. 

  200. 		//datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    201. 

  201. 		//dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    202. 

  202. 		
    203. 

  203. 		//if (datefrom > today) {
    204. 

  204. 		//	alert("Date Range cannot exceed current date.");
    205. 

  205. 		//	_FRM.checkid1.select();
    206. 

  206. 		//	return false;
    207. 

  207. 		//}
    208. 

  208. 		//if (dateto > today) {
    209. 

  209. 		//	alert("Date Range cannot exceed current date.");
    210. 

  210. 		//	_FRM.checkid2.select();
    211. 

  211. 		//	return false;
    212. 

  212. 		//}
    213. 

  213. 		//if (getDiff < 0) {
    214. 

  214. 		//	alert("Invalid Date Range!!");
    215. 

  215. 		//	_FRM.checkid1.select();
    216. 

  216. 		//	return false;
    217. 

  217. 		//}
    218. 

  218.         winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value + '&iQrt=' + _FRM.iQrt.value);
    219. 

  219. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    220. 

  220.         return true;
    221. 

  221.  
    222. 

  222.  
    223. 

  223. }        
    224. 

  224. function ComparativeAnnualChart(x)
    225. 

  225.         {
    226. 

  226. //              alert(x);
    227. 

  227.         var _FRM = document._FRM;
    228. 

  228. 		var vDateSplit1 = _FRM.checkid1.value.split("/");
    229. 

  229. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    230. 

  230. 		var vDateSplit2 = _FRM.checkid2.value.split("/");
    231. 

  231. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    232. 

  232. 		var getDiff = (vDate2-vDate1);
    233. 

  233. 		var today = new Date();
    234. 

  234. 		today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    235. 

  235. 		var datefrom = new Date();
    236. 

  236. 		var dateto = new Date();
    237. 

  237. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    238. 

  238. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    239. 

  239. 		
    240. 

  240. 		if (datefrom > today) {
    241. 

  241. 			alert("Date Range cannot exceed current date.");
    242. 

  242. 			_FRM.checkid1.select();
    243. 

  243. 			return false;
    244. 

  244. 		}
    245. 

  245. 		if (dateto > today) {
    246. 

  246. 			alert("Date Range cannot exceed current date.");
    247. 

  247. 			_FRM.checkid2.select();
    248. 

  248. 			return false;
    249. 

  249. 		}
    250. 

  250. 		if (getDiff < 0) {
    251. 

  251. 			alert("Invalid Date Range!!");
    252. 

  252. 			_FRM.checkid1.select();
    253. 

  253. 			return false;
    254. 

  254. 		}
    255. 

  255.         winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value );
    256. 

  256. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    257. 

  257.         return true;
    258. 

  258. 

  259. 

  260. }     
    261. 

  261. function BussCollQuart(x)
    262. 

  262.         {
    263. 

  263. //              alert(x);
    264. 

  264.         var _FRM = document._FRM;
    265. 

  265. 		var vDateSplit1 = _FRM.checkid1.value.split("/");
    266. 

  266. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    267. 

  267. 		var vDateSplit2 = _FRM.checkid2.value.split("/");
    268. 

  268. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    269. 

  269. 		var getDiff = (vDate2-vDate1);
    270. 

  270. 		var today = new Date();
    271. 

  271. 		today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    272. 

  272. 		var datefrom = new Date();
    273. 

  273. 		var dateto = new Date();
    274. 

  274. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    275. 

  275. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    276. 

  276. 		
    277. 

  277. 		if (datefrom > today) {
    278. 

  278. 			alert("Date Range cannot exceed current date.");
    279. 

  279. 			_FRM.checkid1.select();
    280. 

  280. 			return false;
    281. 

  281. 		}
    282. 

  282. 		if (dateto > today) {
    283. 

  283. 			alert("Date Range cannot exceed current date.");
    284. 

  284. 			_FRM.checkid2.select();
    285. 

  285. 			return false;
    286. 

  286. 		}
    287. 

  287. 		if (getDiff < 0) {
    288. 

  288. 			alert("Invalid Date Range!!");
    289. 

  289. 			_FRM.checkid1.select();
    290. 

  290. 			return false;
    291. 

  291. 		}
    292. 

  292.         winpopup = window.open('reports/' + x + '?owner_last=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value );
    293. 

  293. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    294. 

  294.         return true;
    295. 

  295. 

  296. 

  297. }
    298. 

  298.          
    299. 

  299. function SummaryCollect(x)
    300. 

  300. 	{
    301. 

  301. 	var _FRM = document._FRM;
    302. 

  302. 	var vDateSplit1 = _FRM.checkid1.value.split("/");
    303. 

  303. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    304. 

  304. 		var vDateSplit2 = _FRM.checkid2.value.split("/");
    305. 

  305. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    306. 

  306. 		var getDiff = (vDate2-vDate1);
    307. 

  307. 		var today = new Date();
    308. 

  308. 		today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    309. 

  309. 		var datefrom = new Date();
    310. 

  310. 		var dateto = new Date();
    311. 

  311. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    312. 

  312. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    313. 

  313. 		
    314. 

  314. 		if (datefrom > today) {
    315. 

  315. 			alert("Date Range cannot exceed current date.");
    316. 

  316. 			_FRM.checkid1.select();
    317. 

  317. 			return false;
    318. 

  318. 		}
    319. 

  319. 		if (dateto > today) {
    320. 

  320. 			alert("Date Range cannot exceed current date.");
    321. 

  321. 			_FRM.checkid2.select();
    322. 

  322. 			return false;
    323. 

  323. 		}
    324. 

  324. 		if (getDiff < 0) {
    325. 

  325. 			alert("Invalid Date Range!!");
    326. 

  326. 			_FRM.checkid1.select();
    327. 

  327. 			return false;
    328. 

  328. 		}
    329. 

  329. 	winpopup = window.open('reports/' + x + '?taxtype=' + _FRM.taxtype.value + '&date_from=' + _FRM.checkid1.value + '&date_to=' + _FRM.checkid2.value + '&usernm=' + _FRM.usernm.value);
    330. 

  330. 	return true;
    331. 

  331. }
    332. 

  332. </script>
    333. 

  333. 

  334. 

  335. 

  336. 

  337. 

  338. 

  339. 

  340. <form method=post name=_FRM action='index.php?part=4&class_type=Reports&itemID_=921&busItem=Reports&permit_type=Reports&rpt=<?php echo $rpt;?>'>
    341. 

  341. 

  342. <div align="center">
    343. 

  343. 

  344. <table border=0 cellspacing=0 cellpadding=0  width='100%'>
    345. 

  345. <tr><td colspan=2 class=header align=center width=100%>REPORTS</td></tr>
    346. 

  346. <tr><td colspan=2 ><br></td></tr>
    347. 

  347. <?php 
    348. 

  348. 		if ($rpt=='Business') {
    349. 

  349. 		?>
    350. 

  350. 			<tr>
    351. 

  351. 				<td align="center" valign="top" width=100% colspan=2>
    352. 

  352. 					<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    353. 

  353. 						<tr>
    354. 

  354. 							<td class='header2' colspan=2 align=center>Business Permit</td>
    355. 

  355. 						</tr>
    356. 

  356. 						<tr>
    357. 

  357. 							<td>&nbsp;</td>
    358. 

  358. 						</tr>
    359. 

  359. 						<tr>
    360. 

  360.                        <td width=40% align=right>
    361. 

  361.                        Reports </td>
    362. 

  362.                        <td width=60% align=left>&nbsp;
    363. 

  363. <?php
    364. 

  364. 			
    365. 

  365. 			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);
    366. 

  366. 

  367. 			if ($bus_selecty<>'') {
    368. 

  368. 			include_once "class/ReportClass.php";
    369. 

  369. 			$gReport=new NewReport;
    370. 

  370. 			$gReport->GetReport($bus_selecty);
    371. 

  371. 			$rfile=$gReport->outarray;
    372. 

  372. 			$report_file=$rfile[report_file];
    373. 

  373. 			$report_desc=$rfile[report_desc];
    374. 

  374. 			}
    375. 

  375. 

  376. ?>
    377. 

  377. <input type=hidden name=report_file value="<?php echo $report_file; ?>">
    378. 

  378. 			<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; ?>">
    379. 

  379. 			<input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    380. 

  380. 			</td></tr>
    381. 

  381. <script language="javascript">
    382. 

  382. function BusEstab()
    383. 

  383.         {
    384. 

  384. 	var _FRM = document._FRM;
    385. 

  385. 	var vDateSplit1 = _FRM.date_from.value.split("/");
    386. 

  386. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    387. 

  387. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    388. 

  388. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    389. 

  389. 		var getDiff = (vDate2-vDate1);
    390. 

  390. 		var today = new Date();
    391. 

  391. 		today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    392. 

  392. 		var datefrom = new Date();
    393. 

  393. 		var dateto = new Date();
    394. 

  394. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    395. 

  395. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    396. 

  396. 		
    397. 

  397. 		if (datefrom > today) {
    398. 

  398. 			alert("Date Range cannot exceed current date.");
    399. 

  399. 			_FRM.date_from.select();
    400. 

  400. 			return false;
    401. 

  401. 		}
    402. 

  402. 		if (dateto > today) {
    403. 

  403. 			alert("Date Range cannot exceed current date.");
    404. 

  404. 			_FRM.date_to.select();
    405. 

  405. 			return false;
    406. 

  406. 		}
    407. 

  407. 		if (getDiff < 0) {
    408. 

  408. 			alert("Invalid Date Range!!");
    409. 

  409. 			_FRM.date_from.select();
    410. 

  410. 			return false;
    411. 

  411. 		}
    412. 

  412. 		if(parseFloat(_FRM.cap_inv1.value) < 0 || isNaN(_FRM.cap_inv1.value) == true) {
    413. 

  413. 			alert("Invalid Capital Investment Range!!");
    414. 

  414. 			_FRM.cap_inv1.focus();
    415. 

  415. 			_FRM.cap_inv1.select();
    416. 

  416. 			return false;
    417. 

  417. 		}
    418. 

  418. 		if(parseFloat(_FRM.cap_inv1.value) > 999999999999.99) {
    419. 

  419. 			alert("Capital Investment Exceeds Max!");
    420. 

  420. 			_FRM.cap_inv1.focus();
    421. 

  421. 			_FRM.cap_inv1.select();
    422. 

  422. 			return false;
    423. 

  423. 		}
    424. 

  424. 		if (parseFloat(_FRM.cap_inv2.value) < 0 || isNaN(_FRM.cap_inv2.value) == true)
    425. 

  425. 		{
    426. 

  426. 			alert("Invalid Capital Investment Range!!");
    427. 

  427. 			_FRM.cap_inv2.focus();
    428. 

  428. 			_FRM.cap_inv2.select();
    429. 

  429. 			return false;
    430. 

  430. 		}
    431. 

  431. 		if(parseFloat(_FRM.cap_inv2.value) > 999999999999.99) {
    432. 

  432. 			alert("Capital Investment Exceeds Max!");
    433. 

  433. 			_FRM.cap_inv2.focus();
    434. 

  434. 			_FRM.cap_inv2.select();
    435. 

  435. 			return false;
    436. 

  436. 		}
    437. 

  437. 		if (parseFloat(_FRM.cap_inv1.value) > parseFloat(_FRM.cap_inv2.value))
    438. 

  438. 		{
    439. 

  439. 			alert("Invalid Capital Investment Range!!");
    440. 

  440. 			_FRM.cap_inv1.focus();
    441. 

  441. 			_FRM.cap_inv1.select();
    442. 

  442. 			return false;
    443. 

  443. 		}
    444. 

  444. 		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);
    445. 

  445. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    446. 

  446. 	return true;
    447. 

  447.         }
    448. 

  448. function BusExempt()
    449. 

  449.         {
    450. 

  450.         var _FRM = document._FRM;
    451. 

  451. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    452. 

  452. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    453. 

  453. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    454. 

  454. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    455. 

  455. 		var getDiff = (vDate2-vDate1);
    456. 

  456. 		var today = new Date();
    457. 

  457. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    458. 

  458. 		var datefrom = new Date();
    459. 

  459. 		var dateto = new Date();
    460. 

  460. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    461. 

  461. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    462. 

  462. 		
    463. 

  463. 		if (datefrom > today) {
    464. 

  464. 			alert("Date Range cannot exceed current date.");
    465. 

  465. 			_FRM.date_from.select();
    466. 

  466. 			return false;
    467. 

  467. 		}
    468. 

  468. 		if (dateto > today) {
    469. 

  469. 			alert("Date Range cannot exceed current date.");
    470. 

  470. 			_FRM.date_to.select();
    471. 

  471. 			return false;
    472. 

  472. 		}
    473. 

  473. 		if (getDiff < 0) {
    474. 

  474. 			alert("Invalid Date Range!!");
    475. 

  475. 			_FRM.date_from.select();
    476. 

  476. 			return false;
    477. 

  477. 		}
    478. 

  478.         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);
    479. 

  479. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    480. 

  480.         return true;
    481. 

  481.                                                                                                                                                             
    482. 

  482.         }
    483. 

  483. 

  484. 

  485. 

  486. 

  487. function TopEstab()
    488. 

  488.         {
    489. 

  489.         var _FRM = document._FRM;
    490. 

  490. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    491. 

  491. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    492. 

  492. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    493. 

  493. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    494. 

  494. 		var getDiff = (vDate2-vDate1);
    495. 

  495. 		var today = new Date();
    496. 

  496. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    497. 

  497. 		var datefrom = new Date();
    498. 

  498. 		var dateto = new Date();
    499. 

  499. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    500. 

  500. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    501. 

  501. 		
    502. 

  502. 		if (datefrom > today) {
    503. 

  503. 			alert("Date Range cannot exceed current date.");
    504. 

  504. 			_FRM.date_from.select();
    505. 

  505. 			return false;
    506. 

  506. 		}
    507. 

  507. 		if (dateto > today) {
    508. 

  508. 			alert("Date Range cannot exceed current date.");
    509. 

  509. 			_FRM.date_to.select();
    510. 

  510. 			return false;
    511. 

  511. 		}
    512. 

  512. 		if (getDiff < 0) {
    513. 

  513. 			alert("Invalid Date Range!!");
    514. 

  514. 			_FRM.date_from.select();
    515. 

  515. 			return false;
    516. 

  516. 		}
    517. 

  517. 		if(parseFloat(_FRM.range1.value) < 0  || isNaN(_FRM.range1.value) == true) {
    518. 

  518. 			alert("Invalid Capital Investment Range!!");
    519. 

  519. 			_FRM.range1.focus();
    520. 

  520. 			_FRM.range1.select();
    521. 

  521. 			return false;
    522. 

  522. 		}
    523. 

  523. 		if(parseFloat(_FRM.range1.value) > 999999999999.99) {
    524. 

  524. 			alert("Capital Investment Exceeds Max!");
    525. 

  525. 			_FRM.range1.focus();
    526. 

  526. 			_FRM.range1.select();
    527. 

  527. 			return false;
    528. 

  528. 		}
    529. 

  529. 		if (parseFloat(_FRM.range2.value) < 0 || isNaN(_FRM.range2.value) == true)
    530. 

  530. 		{
    531. 

  531. 			alert("Invalid Capital Investment Range!!");
    532. 

  532. 			_FRM.range2.focus();
    533. 

  533. 			_FRM.range2.select();
    534. 

  534. 			return false;
    535. 

  535. 		}
    536. 

  536. 		if(parseFloat(_FRM.range2.value) > 999999999999.99) {
    537. 

  537. 			alert("Capital Investment Exceeds Max!");
    538. 

  538. 			_FRM.range2.focus();
    539. 

  539. 			_FRM.range2.select();
    540. 

  540. 			return false;
    541. 

  541. 		}
    542. 

  542. 		if (parseFloat(_FRM.range1.value) > parseFloat(_FRM.range2.value))
    543. 

  543. 		{
    544. 

  544. 			alert("Invalid Capital Investment Range!!");
    545. 

  545. 			_FRM.range1.focus();
    546. 

  546. 			_FRM.range1.select();
    547. 

  547. 			return false;
    548. 

  548. 		}
    549. 

  549. 		if (parseFloat(_FRM.list_limit.value) <= 0 || isNaN(_FRM.list_limit.value) == true || _FRM.list_limit.value == "")
    550. 

  550. 		{
    551. 

  551. 			alert("Invalid Limit!");
    552. 

  552. 			_FRM.list_limit.focus();
    553. 

  553. 			_FRM.list_limit.select();
    554. 

  554. 			return false;
    555. 

  555. 		}
    556. 

  556. 		if (parseFloat(_FRM.list_limit.value) > 100 )
    557. 

  557. 		{
    558. 

  558. 			alert("Invalid Limit!");
    559. 

  559. 			_FRM.list_limit.focus();
    560. 

  560. 			_FRM.list_limit.select();
    561. 

  561. 			return false;
    562. 

  562. 		}
    563. 

  563.         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);
    564. 

  564. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    565. 

  565.         return true;
    566. 

  566.                                                                                                  
    567. 

  567.                                                                                                  
    568. 

  568.         }
    569. 

  569. function ListEstab()
    570. 

  570.         {
    571. 

  571. 			
    572. 

  572.         var _FRM = document._FRM;
    573. 

  573. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    574. 

  574. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    575. 

  575. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    576. 

  576. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    577. 

  577. 		var getDiff = (vDate2-vDate1);
    578. 

  578. 		var today = new Date();
    579. 

  579. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    580. 

  580. 		var datefrom = new Date();
    581. 

  581. 		var dateto = new Date();
    582. 

  582. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    583. 

  583. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    584. 

  584. 		
    585. 

  585. 		if (datefrom > today) {
    586. 

  586. 			alert("Date Range cannot exceed current date.");
    587. 

  587. 			_FRM.date_from.select();
    588. 

  588. 			return false;
    589. 

  589. 		}
    590. 

  590. 		if (dateto > today) {
    591. 

  591. 			alert("Date Range cannot exceed current date.");
    592. 

  592. 			_FRM.date_to.select();
    593. 

  593. 			return false;
    594. 

  594. 		}
    595. 

  595. 		if (getDiff < 0) {
    596. 

  596. 			alert("Invalid Date Range!!");
    597. 

  597. 			_FRM.date_from.select();
    598. 

  598. 			return false;
    599. 

  599. 		}
    600. 

  600.         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);
    601. 

  601. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    602. 

  602.         return true;
    603. 

  603.                                                                                                  
    604. 

  604.                                                                                                  
    605. 

  605.         }
    606. 

  606. function ListEstabW()
    607. 

  607.         {
    608. 

  608.         var _FRM = document._FRM;
    609. 

  609. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    610. 

  610. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    611. 

  611. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    612. 

  612. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    613. 

  613. 		var getDiff = (vDate2-vDate1);
    614. 

  614. 		var today = new Date();
    615. 

  615. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    616. 

  616. 		var datefrom = new Date();
    617. 

  617. 		var dateto = new Date();
    618. 

  618. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    619. 

  619. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    620. 

  620. 		
    621. 

  621. 		if (datefrom > today) {
    622. 

  622. 			alert("Date Range cannot exceed current date.");
    623. 

  623. 			_FRM.date_from.select();
    624. 

  624. 			return false;
    625. 

  625. 		}
    626. 

  626. 		if (dateto > today) {
    627. 

  627. 			alert("Date Range cannot exceed current date.");
    628. 

  628. 			_FRM.date_to.select();
    629. 

  629. 			return false;
    630. 

  630. 		}
    631. 

  631. 		if (getDiff < 0) {
    632. 

  632. 			alert("Invalid Date Range!!");
    633. 

  633. 			_FRM.date_from.select();
    634. 

  634. 			return false;
    635. 

  635. 		}
    636. 

  636.         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);
    637. 

  637. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    638. 

  638.         return true;
    639. 

  639.                                                                                                  
    640. 

  640.                                                                                                  
    641. 

  641.         }
    642. 

  642. function BussPermit()
    643. 

  643.         {
    644. 

  644.         var _FRM = document._FRM;
    645. 

  645. 		if (_FRM.owner_last.value == "" && _FRM.permit_num.value == "" && _FRM.bus_name.value == "" && _FRM.pin.value == "") {
    646. 

  646. 			alert("Enter Owner Last Name or Permit Number or Business Name or PIN.");
    647. 

  647. 			_FRM.permit_num.focus();
    648. 

  648. 			return false;
    649. 

  649. 		}
    650. 

  650.         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);
    651. 

  651. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    652. 

  652.         return true;
    653. 

  653.                                                                                                  
    654. 

  654.                                                                                                  
    655. 

  655.         }
    656. 

  656. 		function BussPro()
    657. 

  657.         {
    658. 

  658.         var _FRM = document._FRM;
    659. 

  659. 		if (_FRM.owner_last.value == "" && _FRM.bus_name.value == "" && _FRM.pin.value == "") {
    660. 

  660. 			alert("Enter Owner Last Name or Business Name or PIN.");
    661. 

  661. 			_FRM.owner_last.focus();
    662. 

  662. 			return false;
    663. 

  663. 		}
    664. 

  664.         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);
    665. 

  665. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    666. 

  666.         return true;
    667. 

  667.                                                                                                  
    668. 

  668.                                                                                                  
    669. 

  669.         }
    670. 

  670. function Blaklist()
    671. 

  671.         {
    672. 

  672.         var _FRM = document._FRM;
    673. 

  673. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    674. 

  674. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    675. 

  675. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    676. 

  676. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    677. 

  677. 		var getDiff = (vDate2-vDate1);
    678. 

  678. 		var today = new Date();
    679. 

  679. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    680. 

  680. 		var datefrom = new Date();
    681. 

  681. 		var dateto = new Date();
    682. 

  682. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    683. 

  683. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    684. 

  684. 		
    685. 

  685. 		if (datefrom > today) {
    686. 

  686. 			alert("Date Range cannot exceed current date.");
    687. 

  687. 			_FRM.date_from.select();
    688. 

  688. 			return false;
    689. 

  689. 		}
    690. 

  690. 		if (dateto > today) {
    691. 

  691. 			alert("Date Range cannot exceed current date.");
    692. 

  692. 			_FRM.date_to.select();
    693. 

  693. 			return false;
    694. 

  694. 		}
    695. 

  695. 		if (getDiff < 0) {
    696. 

  696. 			alert("Invalid Date Range!!");
    697. 

  697. 			_FRM.date_from.select();
    698. 

  698. 			return false;
    699. 

  699. 		} else {
    700. 

  700.         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);
    701. 

  701.         return true;
    702. 

  702. 		}
    703. 

  703. 		}
    704. 

  704. function ReqDelin()
    705. 

  705.         {
    706. 

  706.         var _FRM = document._FRM;
    707. 

  707. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    708. 

  708. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    709. 

  709. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    710. 

  710. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    711. 

  711. 		var getDiff = (vDate2-vDate1);
    712. 

  712. 		var today = new Date();
    713. 

  713. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    714. 

  714. 		var datefrom = new Date();
    715. 

  715. 		var dateto = new Date();
    716. 

  716. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    717. 

  717. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    718. 

  718. 		
    719. 

  719. 		if (datefrom > today) {
    720. 

  720. 			alert("Date Range cannot exceed current date.");
    721. 

  721. 			_FRM.date_from.select();
    722. 

  722. 			return false;
    723. 

  723. 		}
    724. 

  724. 		if (dateto > today) {
    725. 

  725. 			alert("Date Range cannot exceed current date.");
    726. 

  726. 			_FRM.date_to.select();
    727. 

  727. 			return false;
    728. 

  728. 		}
    729. 

  729. 		if (getDiff < 0) {
    730. 

  730. 			alert("Invalid Date Range!!");
    731. 

  731. 			_FRM.date_from.select();
    732. 

  732. 			return false;
    733. 

  733. 		} else {
    734. 

  734.         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);
    735. 

  735.         return true;
    736. 

  736. 		}
    737. 

  737. }
    738. 

  738. 		function BussComp()
    739. 

  739.         {
    740. 

  740.         var _FRM = document._FRM;
    741. 

  741. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    742. 

  742. 		var today = new Date();
    743. 

  743. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    744. 

  744. 		var datefrom = new Date();
    745. 

  745. 		var dateto = new Date();
    746. 

  746. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    747. 

  747. 		
    748. 

  748. 		if (datefrom > today) {
    749. 

  749. 			alert("Date cannot exceed current date.");
    750. 

  750. 			_FRM.date_from.select();
    751. 

  751. 			return false;
    752. 

  752. 		}
    753. 

  753. 		winpopup = window.open('reports/' + _FRM.report_file.value + '?date_from=' + _FRM.date_from.value + '&usernm=' + _FRM.usernm.value);
    754. 

  754.         return true;
    755. 

  755. 

  756. 

  757.         }                                                                                                               
    758. 

  758. </script>
    759. 

  759. 

  760. <?php
    761. 

  761. 			if ($report_file=='ebpls_buslist_blacklist.php') {
    762. 

  762. 				?>
    763. 

  763.                         <tr>
    764. 

  764.                         <td width=40% align=right>
    765. 

  765.                         Date: </td>
    766. 

  766.                         <td align="left" valign="top" class='normal'>&nbsp;
    767. 

  767.                   
    768. 

  768.         
    769. 

  769. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    770. 

  770. <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;">
    771. 

  771.  
    772. 

  772. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    773. 

  773. <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;">
    774. 

  774. 

  775.                         </td>
    776. 

  776.                         </tr>
    777. 

  777. 			<tr>
    778. 

  778.                         <td width=40% align=right>
    779. 

  779.                         Barangay&nbsp;
    780. 

  780.                         </td>
    781. 

  781.                         <td width=60% align=left>&nbsp;
    782. 

  782.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    783. 

  783.                         </td>
    784. 

  784.                         </tr>
    785. 

  785.                         <tr>
    786. 

  786.                         <td>&nbsp;</td>
    787. 

  787.                         </tr>
    788. 

  788.                         <tr>
    789. 

  789.                         <td colspan=2 align=center>
    790. 

  790.                         <input type=button name='buss_report' value="View Report" onClick="javascript: Blaklist();">
    791. 

  791.                         </td>
    792. 

  792.                         </tr>
    793. 

  793. <?php
    794. 

  794. 

  795.                         }
    796. 

  796. 						if ($report_file=='ebpls_summary_busreq_delinquent.php') {
    797. 

  797. 				?>
    798. 

  798.                         <tr>
    799. 

  799.                         <td width=40% align=right>
    800. 

  800.                         Date: </td>
    801. 

  801.                         <td align="left" valign="top" class='normal'>&nbsp;
    802. 

  802.                   
    803. 

  803.         
    804. 

  804. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    805. 

  805. <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;">
    806. 

  806.  
    807. 

  807. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    808. 

  808. <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;">
    809. 

  809. 

  810.                         </td>
    811. 

  811.                         </tr>
    812. 

  812. 			<tr>
    813. 

  813.                         <td width=40% align=right>
    814. 

  814.                         Barangay&nbsp;
    815. 

  815.                         </td>
    816. 

  816.                         <td width=60% align=left>&nbsp;
    817. 

  817.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    818. 

  818.                         </td>
    819. 

  819.                         </tr>
    820. 

  820.                         <tr>
    821. 

  821.                         <td>&nbsp;</td>
    822. 

  822.                         </tr>
    823. 

  823.                         <tr>
    824. 

  824.                         <td colspan=2 align=center>
    825. 

  825.                         <input type=button name='buss_report' value="View Report" onClick="javascript: ReqDelin();">
    826. 

  826.                         </td>
    827. 

  827.                         </tr>
    828. 

  828. <?php
    829. 

  829. 

  830.                         }
    831. 

  831. 						if ($report_file=='ebpls_comparative_business.php') {
    832. 

  832. 				?>
    833. 

  833.                         <tr>
    834. 

  834.                         <td width=40% align=right>
    835. 

  835.                         Date: </td>
    836. 

  836.                         <td align="left" valign="top" class='normal'>&nbsp;
    837. 

  837.                   
    838. 

  838.         
    839. 

  839. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    840. 

  840. <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;">
    841. 

  841.                         </td>
    842. 

  842.                         </tr>
    843. 

  843. 			            <td>&nbsp;</td>
    844. 

  844.                         </tr>
    845. 

  845.                         <tr>
    846. 

  846.                         <td colspan=2 align=center>
    847. 

  847.                         <input type=button name='buss_report' value="View Report" onClick="javascript: BussComp();">
    848. 

  848.                         </td>
    849. 

  849.                         </tr>
    850. 

  850. <?php
    851. 

  851. 

  852.                         }
    853. 

  853. 			if ($report_file=='ebpls_buss_permit.php') {
    854. 

  854. 				?>
    855. 

  855.                         <tr>
    856. 

  856.                         <td width=40% align=right>
    857. 

  857.                         Permit #&nbsp;
    858. 

  858.                         </td>
    859. 

  859.                         <td width=60% align=left>&nbsp;
    860. 

  860.                         <input type=text name=permit_num>
    861. 

  861.                         </td>
    862. 

  862.                         </tr>
    863. 

  863. 						<tr>
    864. 

  864.                         <td width=40% align=right>
    865. 

  865.                         Owner Last Name&nbsp;
    866. 

  866.                         </td>
    867. 

  867.                         <td width=60% align=left>&nbsp;
    868. 

  868.                         <input type=text name=owner_last>
    869. 

  869.                         </td>
    870. 

  870.                         </tr>
    871. 

  871. 						<tr>
    872. 

  872.                         <td width=40% align=right>
    873. 

  873.                         Business Name&nbsp;
    874. 

  874.                         </td>
    875. 

  875.                         <td width=60% align=left>&nbsp;
    876. 

  876.                         <input type=text name=bus_name>
    877. 

  877.                         </td>
    878. 

  878.                         </tr>
    879. 

  879. 						<tr>
    880. 

  880.                         <td width=40% align=right>
    881. 

  881.                         PIN&nbsp;
    882. 

  882.                         </td>
    883. 

  883.                         <td width=60% align=left>&nbsp;
    884. 

  884.                         <input type=text name=pin>
    885. 

  885.                         </td>
    886. 

  886.                         </tr>
    887. 

  887.                         <tr>
    888. 

  888.                         <td>&nbsp;</td>
    889. 

  889.                         </tr>
    890. 

  890.                         <tr>
    891. 

  891.                         <td colspan=2 align=center>
    892. 

  892.                         <input type=button name='buss_report' value="View Report" onClick="javascript: BussPermit();">
    893. 

  893.                         </td>
    894. 

  894.                         </tr>
    895. 

  895. <?php
    896. 

  896. 

  897.                         }
    898. 

  898. 						if ($report_file=='ebpls_business_profile.php') {
    899. 

  899. 				?>
    900. 

  900.                         <tr>
    901. 

  901.                         <td width=40% align=right>
    902. 

  902.                         Owner Last Name&nbsp;
    903. 

  903.                         </td>
    904. 

  904.                         <td width=60% align=left>&nbsp;
    905. 

  905.                         <input type=text name=owner_last>
    906. 

  906.                         </td>
    907. 

  907.                         </tr>
    908. 

  908. 						<tr>
    909. 

  909.                         <td width=40% align=right>
    910. 

  910.                         Business Name&nbsp;
    911. 

  911.                         </td>
    912. 

  912.                         <td width=60% align=left>&nbsp;
    913. 

  913.                         <input type=text name=bus_name>
    914. 

  914.                         </td>
    915. 

  915.                         </tr>
    916. 

  916. 						<tr>
    917. 

  917.                         <td width=40% align=right>
    918. 

  918.                         PIN&nbsp;
    919. 

  919.                         </td>
    920. 

  920.                         <td width=60% align=left>&nbsp;
    921. 

  921.                         <input type=text name=pin>
    922. 

  922.                         </td>
    923. 

  923.                         </tr>
    924. 

  924.                         <tr>
    925. 

  925.                         <td>&nbsp;</td>
    926. 

  926.                         </tr>
    927. 

  927.                         <tr>
    928. 

  928.                         <td colspan=2 align=center>
    929. 

  929.                         <input type=button name='buss_report' value="View Report" onClick="javascript: BussPro();">
    930. 

  930.                         </td>
    931. 

  931.                         </tr>
    932. 

  932. <?php
    933. 

  933. 

  934.                         }
    935. 

  935. 			if ($report_file=="ebpls_bus_masterlist.php" || $report_file=='ebpls_bus_exemptedlist_full.php') {
    936. 

  936. ?>
    937. 

  937. 			<tr>
    938. 

  938. 			<td width=40% align=right>
    939. 

  939.                         Date: </td>
    940. 

  940. 			<td align="left" valign="top" class='normal'>&nbsp;
    941. 

  941. 			        
    942. 

  942. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    943. 

  943. <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;">
    944. 

  944.  
    945. 

  945. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    946. 

  946. <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;">
    947. 

  947. 

  948. 			</td>
    949. 

  949. 			</tr>
    950. 

  950. 				<?php
    951. 

  951.                         if ($report_file=="ebpls_bus_masterlist.php") {
    952. 

  952. 				?>
    953. 

  953. 			<tr>
    954. 

  954.                         <td width=40% align=right>
    955. 

  955.                         Barangay&nbsp;
    956. 

  956.                         </td>
    957. 

  957.                         <td width=60% align=left>&nbsp;
    958. 

  958.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    959. 

  959.                         </td>
    960. 

  960.                         </tr>
    961. 

  961. <?php
    962. 

  962. 			}
    963. 

  963. ?>
    964. 

  964. 			<tr>
    965. 

  965.                         <td width=40% align=right>
    966. 

  966.                         Owner Last Name&nbsp;
    967. 

  967.                         </td>
    968. 

  968.                         <td width=60% align=left>&nbsp;
    969. 

  969.                         <input type=text name='owner_last' value='' >
    970. 

  970.                         </td>
    971. 

  971.                         </tr>
    972. 

  972. 			<tr>
    973. 

  973.                         <td width=40% align=right>
    974. 

  974.                         Line of Business&nbsp;
    975. 

  975.                         </td>
    976. 

  976.                         <td width=60% align=left>&nbsp;
    977. 

  977. <?php
    978. 

  978.                 echo get_select_brgy($dbLink,'business_nature_code','ebpls_buss_nature','natureid','naturedesc',$business_nature_code, 'true','naturestatus<>"d" order by naturedesc');
    979. 

  979.                 ?>
    980. 

  980.                         </td>
    981. 

  981.                         </tr>
    982. 

  982. <?php
    983. 

  983. 	                        if ($report_file=="ebpls_bus_masterlist.php") {
    984. 

  984. ?>
    985. 

  985. 

  986.                         <tr>
    987. 

  987.                         <td width=40% align=right>
    988. 

  988.                         <?
    989. 

  989.                         if ($trans <> 'New' and $trans <> "") {
    990. 

  990. 	                    ?>
    991. 

  991. 	                    Gross Receipt Range
    992. 

  992. 	                    <?
    993. 

  993.                     	} else {
    994. 

  994.                     	?>
    995. 

  995.                         Capital Investment Range
    996. 

  996.                         <? 
    997. 

  997.                     	}
    998. 

  998.                     	if ($trans == 'New') {
    999. 

  999. 	                    	$checkit1 = "selected";
    1000. 

  1000.                     	} elseif ($trans == 'ReNew') {
    1001. 

  1001. 	                    	$checkit2 = "selected";
    1002. 

  1002.                     	} elseif ($trans == 'ReNew') {
    1003. 

  1003. 	                    	$checkit3 = "selected";
    1004. 

  1004.                     	} elseif ($trans == 'Retire') {
    1005. 

  1005. 	                    	$checkit3 = "selected";
    1006. 

  1006.                     	}
    1007. 

  1007. 						else {
    1008. 

  1008. 	                    	$checkit = "selected";
    1009. 

  1009.                     	}
    1010. 

  1010.                     	?>
    1011. 

  1011.                         &nbsp;
    1012. 

  1012.                         </td>
    1013. 

  1013.                         <td width=60% align=left>&nbsp;
    1014. 

  1014.                         <input type=text name='cap_inv1' value='0' >
    1015. 

  1015. 			&nbsp; to &nbsp;
    1016. 

  1016.                         <input type=text name='cap_inv2' value='0' >
    1017. 

  1017.                         </td>
    1018. 

  1018.                         </tr>
    1019. 

  1019.                         <tr>
    1020. 

  1020.                         <td width=40% align=right>
    1021. 

  1021.                         Transaction&nbsp;</td>
    1022. 

  1022.                         <td>&nbsp;
    1023. 

  1023.                         <select name='trans' height="19" style="font-size:10" onchange="javascript: _FRM.submit();">
    1024. 

  1024.                         <option value='' <? echo $checkit;?>>-----</option>
    1025. 

  1025.                         <option value='New' <? echo $checkit1;?>>New</option>
    1026. 

  1026.                         <option value='ReNew' <? echo $checkit2;?>>ReNew</option>
    1027. 

  1027.                         <option value='Retire' <? echo $checkit3;?>>Retire</option>
    1028. 

  1028.                         </select>
    1029. 

  1029.                         </td>
    1030. 

  1030.                         </tr>
    1031. 

  1031. 			<tr>
    1032. 

  1032.                         <td width=40% align=right>
    1033. 

  1033.                         PSIC&nbsp;
    1034. 

  1034.                         </td>
    1035. 

  1035.                         <td width=60% align=left>&nbsp;
    1036. 

  1036.                         <input type=text name='psic' value='' >
    1037. 

  1037.                         </td>
    1038. 

  1038.                         </tr>
    1039. 

  1039. 

  1040. 	                <tr>
    1041. 

  1041.                         <td>&nbsp;</td>
    1042. 

  1042.                         </tr>
    1043. 

  1043.                         <tr>
    1044. 

  1044.                         <td colspan=2 align=center>
    1045. 

  1045.                         <input type=button name='buss_report' value="View Report" onClick="javascript:BusEstab();">
    1046. 

  1046.                         </td>
    1047. 

  1047.                         </tr>
    1048. 

  1048. <?php
    1049. 

  1049. 				} else {
    1050. 

  1050. ?>
    1051. 

  1051. 			<tr>
    1052. 

  1052.                         <td width=40% align=right>
    1053. 

  1053.                         Ownership Type&nbsp;
    1054. 

  1054.                         </td>
    1055. 

  1055.                         <td width=60% align=left>&nbsp;
    1056. 

  1056. <?php
    1057. 

  1057. 				if ($report_file=='ebpls_bus_exemptedlist_full.php') {
    1058. 

  1058. 					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');
    1059. 

  1059. 				} else {
    1060. 

  1060. 					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');
    1061. 

  1061. 				}
    1062. 

  1062.                 ?>
    1063. 

  1063.                         </td>
    1064. 

  1064.                         </tr>
    1065. 

  1065.                         <tr>
    1066. 

  1066.                         <td width=40% align=right>
    1067. 

  1067.                         Options&nbsp;</td>
    1068. 

  1068.                         <td>&nbsp;
    1069. 

  1069.                         <select name='option' height="19" style="font-size:10">
    1070. 

  1070.                         <option value='1000'>-----</option>
    1071. 

  1071.                         <option value='99'>Partial</option>
    1072. 

  1072.                         <option value='100'>Full</option>
    1073. 

  1073.                         </select>
    1074. 

  1074.                         </td>
    1075. 

  1075.                         </tr>
    1076. 

  1076. 			<tr>
    1077. 

  1077.                         <td>&nbsp;</td>
    1078. 

  1078.                         </tr>
    1079. 

  1079.                         <tr>
    1080. 

  1080.                         <td colspan=2 align=center>
    1081. 

  1081.                         <input type=button name='buss_report' value="View Report" onClick="javascript:BusExempt();">
    1082. 

  1082.                         </td>
    1083. 

  1083.                         </tr>
    1084. 

  1084. 

  1085. 

  1086. <?php
    1087. 

  1087. 				}
    1088. 

  1088. 			} elseif ($report_file=="ebpls_bus_topestablishment.php") {
    1089. 

  1089. ?>
    1090. 

  1090.                         <tr>
    1091. 

  1091.                         <td width=40% align=right>
    1092. 

  1092.                         Date: </td>
    1093. 

  1093.                         <td align="left" valign="top" class='normal'>&nbsp;
    1094. 

  1094.                                
    1095. 

  1095. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    1096. 

  1096. <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;">
    1097. 

  1097.  
    1098. 

  1098. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    1099. 

  1099. <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;">
    1100. 

  1100. 

  1101.                         </td>
    1102. 

  1102.                         </tr>
    1103. 

  1103.                         <tr>
    1104. 

  1104.                         <td width=40% align=right>
    1105. 

  1105.                         Barangay&nbsp;
    1106. 

  1106.                         </td>
    1107. 

  1107.                         <td width=60% align=left>&nbsp;
    1108. 

  1108.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    1109. 

  1109.                         </td>
    1110. 

  1110.                         </tr>
    1111. 

  1111.                         <tr>
    1112. 

  1112.                         <td width=40% align=right>
    1113. 

  1113.                         Option&nbsp;
    1114. 

  1114.                         </td>
    1115. 

  1115.                         <td width=60% align=left>&nbsp;
    1116. 

  1116. 			<select name="list_option">
    1117. 

  1117. 			<option value='Capital Investment'>Capital Investment</option>
    1118. 

  1118. 			<option value='Gross Receipts'>Gross Receipts</option>
    1119. 

  1119.                         </td>
    1120. 

  1120.                         </tr>
    1121. 

  1121.                         <tr>
    1122. 

  1122.                         <td width=40% align=right>
    1123. 

  1123.                         Income Range&nbsp;
    1124. 

  1124.                         </td>
    1125. 

  1125.                         <td width=60% align=left>&nbsp;
    1126. 

  1126.                         <input type=text name='range1' value='0' >
    1127. 

  1127. 			&nbsp; to &nbsp;
    1128. 

  1128.                         <input type=text name='range2' value='0' >
    1129. 

  1129.                         </td>
    1130. 

  1130.                         </tr>
    1131. 

  1131.                         <tr>
    1132. 

  1132.                         <td width=40% align=right>
    1133. 

  1133.                         List Limit&nbsp;
    1134. 

  1134.                         </td>
    1135. 

  1135.                         <td width=60% align=left>&nbsp;
    1136. 

  1136.                         <input type=text name='list_limit' value='5' >
    1137. 

  1137.                         </td>
    1138. 

  1138.                         </tr>
    1139. 

  1139.                                                                                                                                                                                                                                                                                                                                                                                                        
    1140. 

  1140.                         <tr>
    1141. 

  1141.                         <td>&nbsp;</td>
    1142. 

  1142.                         </tr>
    1143. 

  1143.   <td colspan=2 align=center>
    1144. 

  1144.                         <input type=button name='buss_report' value="View Report" onClick="javascript:TopEstab();">
    1145. 

  1145.                         </td>
    1146. 

  1146.                         </tr>
    1147. 

  1147. <?php
    1148. 

  1148.                         } elseif ($report_file=="ebpls_bus_wpermit.php") {
    1149. 

  1149. ?>
    1150. 

  1150.                         <tr>
    1151. 

  1151.                         <td width=40% align=right>
    1152. 

  1152.                         Date: </td>
    1153. 

  1153.                         <td align="left" valign="top" class='normal'>&nbsp;
    1154. 

  1154.                               
    1155. 

  1155. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    1156. 

  1156. <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;">
    1157. 

  1157.  
    1158. 

  1158. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    1159. 

  1159. <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;">
    1160. 

  1160. 

  1161.                         </td>
    1162. 

  1162.                         </tr>
    1163. 

  1163.                         <tr>
    1164. 

  1164.                         <td width=40% align=right>
    1165. 

  1165.                         Barangay&nbsp;
    1166. 

  1166.                         </td>
    1167. 

  1167.                         <td width=60% align=left>&nbsp;
    1168. 

  1168.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    1169. 

  1169.                         </td>
    1170. 

  1170.                         </tr>
    1171. 

  1171.                         <tr>
    1172. 

  1172.                         <td width=40% align=right>
    1173. 

  1173.                         Owner Last Name&nbsp;
    1174. 

  1174.                         </td>
    1175. 

  1175.                         <td width=60% align=left>&nbsp;
    1176. 

  1176.                         <input type=text name='owner_last' value='' >
    1177. 

  1177.                         </td>
    1178. 

  1178.                         </tr>
    1179. 

  1179. 			<tr>
    1180. 

  1180.                         <td width=40% align=right>
    1181. 

  1181.                         Options&nbsp;</td>
    1182. 

  1182.                         <td>&nbsp;
    1183. 

  1183.                         <select name='paid' height="19" style="font-size:10">
    1184. 

  1184.                         <option value=''>-----</option>
    1185. 

  1185.                         <option value='1'>Paid</option>
    1186. 

  1186.                         <option value='0'>UnPaid</option>
    1187. 

  1187.                         </select>
    1188. 

  1188.                         </td>
    1189. 

  1189.                         </tr>
    1190. 

  1190.                         <tr>
    1191. 

  1191.                         <td>&nbsp;</td>
    1192. 

  1192.                         </tr>
    1193. 

  1193.   <td colspan=2 align=center>
    1194. 

  1194.                         <input type=button name='buss_report' value="View Report" onClick="javascript:ListEstab();">
    1195. 

  1195.                         </td>
    1196. 

  1196.                         </tr>
    1197. 

  1197. <?php
    1198. 

  1198.                         } elseif ($report_file=="ebpls_bus_woutpermit.php") {
    1199. 

  1199. ?>
    1200. 

  1200.                         <tr>
    1201. 

  1201.                         <td width=40% align=right>
    1202. 

  1202.                         Date: </td>
    1203. 

  1203.                         <td align="left" valign="top" class='normal'>&nbsp;
    1204. 

  1204.                                 
    1205. 

  1205. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    1206. 

  1206. <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;">
    1207. 

  1207.  
    1208. 

  1208. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    1209. 

  1209. <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;">
    1210. 

  1210. 

  1211.                         </td>
    1212. 

  1212.                         </tr>
    1213. 

  1213.                         <tr>
    1214. 

  1214.                         <td width=40% align=right>
    1215. 

  1215.                         Barangay&nbsp;
    1216. 

  1216.                         </td>
    1217. 

  1217.                         <td width=60% align=left>&nbsp;
    1218. 

  1218.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    1219. 

  1219.                         </td>
    1220. 

  1220.                         </tr>
    1221. 

  1221.                         <tr>
    1222. 

  1222.                         <td width=40% align=right>
    1223. 

  1223.                         Owner Last Name&nbsp;
    1224. 

  1224.                         </td>
    1225. 

  1225.                         <td width=60% align=left>&nbsp;
    1226. 

  1226.                         <input type=text name='owner_last' value='' >
    1227. 

  1227.                         </td>
    1228. 

  1228.                         </tr>
    1229. 

  1229. 			<tr>
    1230. 

  1230.                         <td width=40% align=right>
    1231. 

  1231.                         Options&nbsp;</td>
    1232. 

  1232.                         <td>&nbsp;
    1233. 

  1233.                         <select name='paid' height="19" style="font-size:10">
    1234. 

  1234.                         <option value=''>-----</option>
    1235. 

  1235.                         <option value='1'>Paid</option>
    1236. 

  1236.                         <option value='0'>UnPaid</option>
    1237. 

  1237.                         </select>
    1238. 

  1238.                         </td>
    1239. 

  1239.                         </tr>
    1240. 

  1240.                         <tr>
    1241. 

  1241.                         <td>&nbsp;</td>
    1242. 

  1242.                         </tr>
    1243. 

  1243.   <td colspan=2 align=center>
    1244. 

  1244.                         <input type=button name='buss_report' value="View Report" onClick="javascript:ListEstabW();">
    1245. 

  1245.                         </td>
    1246. 

  1246.                         </tr>
    1247. 

  1247. <?php
    1248. 

  1248.                         }
    1249. 

  1249. 

  1250. ?>
    1251. 

  1251. 

  1252. 					</table>	
    1253. 

  1253. 				</td>
    1254. 

  1254. 			</tr>
    1255. 

  1255. 			<?php
    1256. 

  1256. 			} elseif ($rpt=='Motorized') {
    1257. 

  1257. 			?>
    1258. 

  1258. 			<tr>
    1259. 

  1259. 				<td align="center" valign="top" width=100% colspan=2>
    1260. 

  1260. 					<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    1261. 

  1261. 						<tr>
    1262. 

  1262. 							<td class='header2' colspan=2 align=center>Motorized Permit</td>
    1263. 

  1263. 						</tr>
    1264. 

  1264. 						<tr>
    1265. 

  1265. 							<td>&nbsp;</td>
    1266. 

  1266. 						</tr>
    1267. 

  1267. 						<tr>
    1268. 

  1268. 							<?php
    1269. 

  1269. 								//where report_desc like '%business%' or report_desc like 'business%' 
    1270. 

  1270. 								//$result = mysql_query("select report_desc, report_file from ebpls_reports order by report_desc asc") or die(mysql_error()); 
    1271. 

  1271. 								$result= mysql_query("select report_desc, report_file from ebpls_reports 
    1272. 

  1272. 								where report_type like '%motor%' or report_type like 'motor%'  order by report_desc asc") or die(mysql_error()); 
    1273. 

  1273.     							//$reports=mysql_fetch_row($result);
    1274. 

  1274.   								print "<td width=40% align=right>
    1275. 

  1275.     							Reports&nbsp</td>";
    1276. 

  1276.     							print "<td width=60% align=left>&nbsp
    1277. 

  1277.     								<select name='buss_select' onchange='javascript: _FRM.motor_select.value=_FRM.buss_select.value; _FRM.submit();'>>";
    1278. 

  1278. 									print"<option value=''>------</option>";
    1279. 

  1279.     								while ($reports=mysql_fetch_row($result)) {
    1280. 

  1280. 										if ($motor_select == $reports[1]) {
    1281. 

  1281. 		    								$isselect = 'selected';
    1282. 

  1282. 	    								} else {
    1283. 

  1283. 		    								$isselect = '';
    1284. 

  1284. 	    								}
    1285. 

  1285.     									$getlevel = mysql_query("select * from ebpls_user_sublevel where
    1286. 

  1286. 										submenu = '$reports[0]'");
    1287. 

  1287. 					$getme = mysql_fetch_assoc($getlevel);
    1288. 

  1288. 					
    1289. 

  1289. 					if ($$getme['rptvars']==1) {
    1290. 

  1290.     									print"<option value=$reports[1] $isselect>$reports[0]</option>";
    1291. 

  1291. 					}
    1292. 

  1292. 									}
    1293. 

  1293.     								print"</select></td><input type=hidden name=motor_select>";
    1294. 

  1294.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    1295. 

  1295.     						?>
    1296. 

  1296.     					</tr>
    1297. 

  1297. 						<tr>
    1298. 

  1298. 							<td>&nbsp;</td>
    1299. 

  1299. 						</tr>
    1300. 

  1300. 						<?
    1301. 

  1301. 						if ($motor_select=='ebpls_masterlist_motor.php') {
    1302. 

  1302. ?>
    1303. 

  1303.                         <tr>
    1304. 

  1304.                         <td width=40% align=right>
    1305. 

  1305.                         Date: </td>
    1306. 

  1306.                         <td align="left" valign="top" class='normal'>&nbsp;
    1307. 

  1307.                               
    1308. 

  1308. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    1309. 

  1309. <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;">
    1310. 

  1310.  
    1311. 

  1311. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    1312. 

  1312. <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;">
    1313. 

  1313. 

  1314.                         </td>
    1315. 

  1315.                         </tr>
    1316. 

  1316. 						<tr>
    1317. 

  1317.                         <td width=40% align=right>
    1318. 

  1318.                         Barangay&nbsp;
    1319. 

  1319.                         </td>
    1320. 

  1320.                         <td width=60% align=left>&nbsp;
    1321. 

  1321.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    1322. 

  1322.                         </td>
    1323. 

  1323.                         </tr>
    1324. 

  1324.                         <tr>
    1325. 

  1325.                         <td width=40% align=right>
    1326. 

  1326.                         Operator's Last Name&nbsp;
    1327. 

  1327.                         </td>
    1328. 

  1328.                         <td width=60% align=left>&nbsp;
    1329. 

  1329.                         <input name=owner_last>
    1330. 

  1330.                         </td>
    1331. 

  1331.                         </tr>
    1332. 

  1332.                         <tr>
    1333. 

  1333.                         <td width=40% align=right>
    1334. 

  1334.                         Motor Brand&nbsp;
    1335. 

  1335.                         </td>
    1336. 

  1336.                         <td width=60% align=left>&nbsp;
    1337. 

  1337.                         <input name=motor_brand>
    1338. 

  1338.                         </td>
    1339. 

  1339.                         </tr>
    1340. 

  1340.                         <tr>
    1341. 

  1341.                         <td width=40% align=right>
    1342. 

  1342.                         Body Color&nbsp;
    1343. 

  1343.                         </td>
    1344. 

  1344.                         <td width=60% align=left>&nbsp;
    1345. 

  1345.                         <input name=body_color>
    1346. 

  1346.                         </td>
    1347. 

  1347.                         </tr>
    1348. 

  1348.                         <tr>
    1349. 

  1349.                         <td width=40% align=right>
    1350. 

  1350.                         Engine Type&nbsp;
    1351. 

  1351.                         </td>
    1352. 

  1352.                         <td width=60% align=left>&nbsp;
    1353. 

  1353.                         <input name=engine_type>
    1354. 

  1354.                         </td>
    1355. 

  1355.                         </tr>
    1356. 

  1356.                         <tr>
    1357. 

  1357.                         <td>&nbsp;</td>
    1358. 

  1358.                         </tr>
    1359. 

  1359.                         <tr>
    1360. 

  1360.                         <td colspan=2 align=center>
    1361. 

  1361.                         <input type=button name='buss_report' value="View Report" onClick="javascript: Motorlist();">
    1362. 

  1362.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1363. 

  1363.                         </td>
    1364. 

  1364.                         </tr>
    1365. 

  1365. <?php
    1366. 

  1366. 

  1367.                         }
    1368. 

  1368. 						if ($motor_select=='ebpls_motor_permit.php') {
    1369. 

  1369. ?>
    1370. 

  1370.                         <tr>
    1371. 

  1371.                         <td width=40% align=right>
    1372. 

  1372.                         Owner Last Name&nbsp;
    1373. 

  1373.                         </td>
    1374. 

  1374.                         <td width=60% align=left>&nbsp;
    1375. 

  1375.                         <input name=owner_last>
    1376. 

  1376.                         </td>
    1377. 

  1377.                         </tr>
    1378. 

  1378.                         <tr>
    1379. 

  1379.                         <td width=40% align=right>
    1380. 

  1380.                         Permit #&nbsp;
    1381. 

  1381.                         </td>
    1382. 

  1382.                         <td width=60% align=left>&nbsp;
    1383. 

  1383.                         <input name=permit_num>
    1384. 

  1384.                         </td>
    1385. 

  1385.                         </tr>
    1386. 

  1386.                         <tr>
    1387. 

  1387.                         <td>&nbsp;</td>
    1388. 

  1388.                         </tr>
    1389. 

  1389.                         <tr>
    1390. 

  1390.                         <td colspan=2 align=center>
    1391. 

  1391.                         <input type=button name='buss_report' value="View Report" onClick="javascript: MotorPermit();">
    1392. 

  1392.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1393. 

  1393.                         </td>
    1394. 

  1394.                         </tr>
    1395. 

  1395. <?php
    1396. 

  1396. 

  1397.                         }
    1398. 

  1398. ?>
    1399. 

  1399. 						<!--
    1400. 

  1400. 						<tr>
    1401. 

  1401. 							<td colspan=2 align=center>
    1402. 

  1402. 								<input type=submit name='motor_report' value="View Report" class=subnavwhite> 
    1403. 

  1403. 							</td>
    1404. 

  1404. 						</tr>	-->
    1405. 

  1405. 					</table>
    1406. 

  1406. 				</td>
    1407. 

  1407. 			</tr>
    1408. 

  1408. 			<tr>
    1409. 

  1409. 				<td>&nbsp;</td>
    1410. 

  1410. 			</tr>
    1411. 

  1411. 			<tr>
    1412. 

  1412. 				<td>&nbsp;</td>
    1413. 

  1413. 			</tr>
    1414. 

  1414. 			<?php
    1415. 

  1415. 			} elseif ($rpt=='Occupational') {
    1416. 

  1416. 			?>
    1417. 

  1417. 			<tr>
    1418. 

  1418. 				<td align="center" valign="top" width=100% colspan=2>
    1419. 

  1419. 					<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    1420. 

  1420. 						<tr>
    1421. 

  1421. 							<td class='header2' colspan=2 align=center>Occupational Permit</td>
    1422. 

  1422. 						</tr>
    1423. 

  1423. 						<tr>
    1424. 

  1424. 							<td>&nbsp;</td>
    1425. 

  1425. 						</tr>
    1426. 

  1426. 						<tr>
    1427. 

  1427. 							<td>&nbsp;</td>
    1428. 

  1428. 						</tr>
    1429. 

  1429. 						<tr>
    1430. 

  1430. 							<td>&nbsp;</td>
    1431. 

  1431. 						</tr>
    1432. 

  1432. 						<tr>
    1433. 

  1433. 							<td>&nbsp;</td>
    1434. 

  1434. 						</tr>
    1435. 

  1435. 						<tr>
    1436. 

  1436. 							<?php
    1437. 

  1437. 								//where report_desc like '%business%' or report_desc like 'business%' 
    1438. 

  1438. 								//$result = mysql_query("select report_desc, report_file from ebpls_reports order by report_desc asc") or die(mysql_error()); 
    1439. 

  1439. 								$result= mysql_query("select report_desc, report_file from ebpls_reports 
    1440. 

  1440. 								where report_type like '%occ%' order by report_desc asc") or die(mysql_error()); 
    1441. 

  1441.     							//$reports=mysql_fetch_row($result);
    1442. 

  1442.   								print "<td width=40% align=right>
    1443. 

  1443.     							Reports&nbsp</td>";
    1444. 

  1444.     							print "<td width=60% align=left>&nbsp
    1445. 

  1445.     								<select name='buss_select' onchange='javascript: _FRM.occu_select.value=_FRM.buss_select.value; _FRM.submit();'>";
    1446. 

  1446.     								print"<option value=''>--------</option>";
    1447. 

  1447.     								while ($reports=mysql_fetch_row($result)) {
    1448. 

  1448. 	    								if ($occu_select == $reports[1]) {
    1449. 

  1449. 		    								$iselecty = 'selected';
    1450. 

  1450. 	    								} else {
    1451. 

  1451. 		    								$iselecty = '';
    1452. 

  1452. 	    								}
    1453. 

  1453.     									$getlevel = mysql_query("select * from ebpls_user_sublevel where
    1454. 

  1454. 										submenu = '$reports[0]'");
    1455. 

  1455. 					$getme = mysql_fetch_assoc($getlevel);
    1456. 

  1456. 					
    1457. 

  1457. 					if ($$getme['rptvars']==1) {
    1458. 

  1458.     									print"<option value=$reports[1] $iselecty>$reports[0]</option>";
    1459. 

  1459. 					}
    1460. 

  1460. 									}
    1461. 

  1461.     								print"</select><input type=hidden name='occu_select'></td>";
    1462. 

  1462.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    1463. 

  1463.     						?>
    1464. 

  1464.     					</tr>
    1465. 

  1465. 						<tr>
    1466. 

  1466. 							<td>&nbsp;</td>
    1467. 

  1467. 						</tr>
    1468. 

  1468. 						<?
    1469. 

  1469. 						if ($occu_select=='ebpls_occupational_list.php') {
    1470. 

  1470. ?>
    1471. 

  1471.                         <tr>
    1472. 

  1472.                         <td width=40% align=right>
    1473. 

  1473.                         Date: </td>
    1474. 

  1474.                         <td align="left" valign="top" class='normal'>&nbsp;
    1475. 

  1475.                                 
    1476. 

  1476. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    1477. 

  1477. <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;">
    1478. 

  1478.  
    1479. 

  1479. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    1480. 

  1480. <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;">
    1481. 

  1481. 

  1482.                         </td>
    1483. 

  1483.                         </tr>
    1484. 

  1484. 						<tr>
    1485. 

  1485.                         <td width=40% align=right>
    1486. 

  1486.                         Barangay&nbsp;
    1487. 

  1487.                         </td>
    1488. 

  1488.                         <td width=60% align=left>&nbsp;
    1489. 

  1489.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    1490. 

  1490.                         </td>
    1491. 

  1491.                         </tr>
    1492. 

  1492.                         <tr>
    1493. 

  1493.                         <td width=40% align=right>
    1494. 

  1494.                         Owner's Last Name&nbsp;
    1495. 

  1495.                         </td>
    1496. 

  1496.                         <td width=60% align=left>&nbsp;
    1497. 

  1497.                         <input name=owner_last>
    1498. 

  1498.                         </td>
    1499. 

  1499.                         </tr>
    1500. 

  1500.                         <tr>
    1501. 

  1501.                         <td width=40% align=right>
    1502. 

  1502.                         Occupation&nbsp;
    1503. 

  1503.                         </td>
    1504. 

  1504.                         <td width=60% align=left>&nbsp;
    1505. 

  1505.                         <input name=occupation>
    1506. 

  1506.                         </td>
    1507. 

  1507.                         </tr>
    1508. 

  1508.                         <tr>
    1509. 

  1509.                         <td width=40% align=right>
    1510. 

  1510.                         Gender&nbsp;
    1511. 

  1511.                         </td>
    1512. 

  1512.                         <td width=60% align=left>&nbsp;
    1513. 

  1513.                         <input name=sex>
    1514. 

  1514.                         </td>
    1515. 

  1515.                         </tr>
    1516. 

  1516.                         <tr>
    1517. 

  1517.                         <td width=40% align=right>
    1518. 

  1518.                         Employer&nbsp;
    1519. 

  1519.                         </td>
    1520. 

  1520.                         <td width=60% align=left>&nbsp;
    1521. 

  1521.                         <input name=employer>
    1522. 

  1522.                         </td>
    1523. 

  1523.                         </tr>
    1524. 

  1524. 						<!--<tr>
    1525. 

  1525.                         <td width=40% align=right>
    1526. 

  1526.                         Age&nbsp;
    1527. 

  1527.                         </td>
    1528. 

  1528.                         <td width=60% align=left>&nbsp;
    1529. 

  1529.                         Start : <input name=agefrom>&nbsp;&nbsp;End : <input name=ageto>
    1530. 

  1530.                         </td>
    1531. 

  1531.                         </tr>-->
    1532. 

  1532.                         <tr>
    1533. 

  1533.                         <td>&nbsp;</td>
    1534. 

  1534.                         </tr>
    1535. 

  1535.                         <tr>
    1536. 

  1536.                         <td colspan=2 align=center>
    1537. 

  1537.                         <input type=button name='buss_report' value="View Report" onClick="javascript: Occulist();">
    1538. 

  1538.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1539. 

  1539.                         </td>
    1540. 

  1540.                         </tr>
    1541. 

  1541. <?php
    1542. 

  1542. 

  1543.                         }if ($occu_select=='ebpls_occ_permit.php') {
    1544. 

  1544. ?>
    1545. 

  1545.                         <tr>
    1546. 

  1546.                         <td width=40% align=right>
    1547. 

  1547.                         Owner Last Name&nbsp;
    1548. 

  1548.                         </td>
    1549. 

  1549.                         <td width=60% align=left>&nbsp;
    1550. 

  1550.                         <input name=owner_last>
    1551. 

  1551.                         </td>
    1552. 

  1552.                         </tr>
    1553. 

  1553.                         <tr>
    1554. 

  1554.                         <td width=40% align=right>
    1555. 

  1555.                         Permit #&nbsp;
    1556. 

  1556.                         </td>
    1557. 

  1557.                         <td width=60% align=left>&nbsp;
    1558. 

  1558.                         <input name=permit_num>
    1559. 

  1559.                         </td>
    1560. 

  1560.                         </tr>
    1561. 

  1561.                         <tr>
    1562. 

  1562.                         <td>&nbsp;</td>
    1563. 

  1563.                         </tr>
    1564. 

  1564.                         <tr>
    1565. 

  1565.                         <td colspan=2 align=center>
    1566. 

  1566.                         <input type=button name='buss_report' value="View Report" onClick="javascript: OccuPermit();">
    1567. 

  1567.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1568. 

  1568.                         </td>
    1569. 

  1569.                         </tr>
    1570. 

  1570. <?php
    1571. 

  1571. 

  1572.                         }
    1573. 

  1573. ?>
    1574. 

  1574. 					</table>	
    1575. 

  1575. 				</td>
    1576. 

  1576. 			</tr>
    1577. 

  1577. 			<?php
    1578. 

  1578. 			} elseif ($rpt=='Franchise') {
    1579. 

  1579. 			?>
    1580. 

  1580. 			<tr>
    1581. 

  1581. 				<td align="center" valign="top" width=100% cospan=2>
    1582. 

  1582. 					<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    1583. 

  1583. 						<tr>
    1584. 

  1584. 							<td class='header2' colspan=2 align=center>Franchise Permit</td>
    1585. 

  1585. 						</tr>
    1586. 

  1586. 						<tr>
    1587. 

  1587. 							<td>&nbsp;</td>
    1588. 

  1588. 						</tr>
    1589. 

  1589. 						<tr>
    1590. 

  1590. 						<td>
    1591. 

  1591. 						
    1592. 

  1592. 						<tr>
    1593. 

  1593. 							<td>&nbsp;</td>
    1594. 

  1594. 						</tr>
    1595. 

  1595. 						<tr>
    1596. 

  1596. 							<?php
    1597. 

  1597. 								//where report_desc like '%business%' or report_desc like 'business%' 
    1598. 

  1598. 								//$result = mysql_query("select report_desc, report_file from ebpls_reports order by report_desc asc") or die(mysql_error()); 
    1599. 

  1599. 								$result= mysql_query("select report_desc, report_file from ebpls_reports 
    1600. 

  1600. 								where report_type like '%franchise%' order by report_desc asc") or die(mysql_error()); 
    1601. 

  1601.     							//$reports=mysql_fetch_row($result);
    1602. 

  1602.   								print "<td width=40% align=right>
    1603. 

  1603.     							Reports&nbsp</td>";
    1604. 

  1604.     							print "<td width=60% align=left>&nbsp
    1605. 

  1605.     								<select name='buss_select' onchange='javascript: _FRM.fran_select.value=_FRM.buss_select.value; _FRM.submit();'>";
    1606. 

  1606.     								print"<option value=''>------</option>";
    1607. 

  1607. 									while ($reports=mysql_fetch_row($result)) {
    1608. 

  1608. 	    								if ($fran_select == $reports[1]) {
    1609. 

  1609. 		    								$iselecty = 'selected';
    1610. 

  1610. 	    								} else {
    1611. 

  1611. 		    								$iselecty = '';
    1612. 

  1612. 	    								}
    1613. 

  1613. 	    								$getlevel = mysql_query("select * from ebpls_user_sublevel where
    1614. 

  1614. 										submenu = '$reports[0]'");
    1615. 

  1615. 					$getme = mysql_fetch_assoc($getlevel);
    1616. 

  1616. 					
    1617. 

  1617. 					if ($$getme['rptvars']==1) {
    1618. 

  1618.     									print"<option value=$reports[1] $iselecty>$reports[0]</option>";
    1619. 

  1619. 					}
    1620. 

  1620. 									}
    1621. 

  1621.     								print"</select>";
    1622. 

  1622.     								print"<input type=hidden name='fran_select'></td>";
    1623. 

  1623.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    1624. 

  1624.     						?>
    1625. 

  1625.     					</tr>
    1626. 

  1626.     					
    1627. 

  1627. 						<tr>
    1628. 

  1628. 							<td>&nbsp;</td>
    1629. 

  1629. 						</tr>
    1630. 

  1630. 						<?
    1631. 

  1631. 						if ($fran_select=='ebpls_franchise_list.php') {
    1632. 

  1632. ?>
    1633. 

  1633.                         <tr>
    1634. 

  1634.                         <td width=40% align=right>
    1635. 

  1635.                         Date: </td>
    1636. 

  1636.                         <td align="left" valign="top" class='normal'>&nbsp;
    1637. 

  1637.                               
    1638. 

  1638. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    1639. 

  1639. <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;">
    1640. 

  1640.  
    1641. 

  1641. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    1642. 

  1642. <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;">
    1643. 

  1643. 

  1644.                         </td>
    1645. 

  1645.                         </tr>
    1646. 

  1646. 						<tr>
    1647. 

  1647.                         <td width=40% align=right>
    1648. 

  1648.                         Barangay&nbsp;
    1649. 

  1649.                         </td>
    1650. 

  1650.                         <td width=60% align=left>&nbsp;
    1651. 

  1651.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    1652. 

  1652.                         </td>
    1653. 

  1653.                         </tr>
    1654. 

  1654.                         <tr>
    1655. 

  1655.                         <td width=40% align=right>
    1656. 

  1656.                         Operator's Last Name&nbsp;
    1657. 

  1657.                         </td>
    1658. 

  1658.                         <td width=60% align=left>&nbsp;
    1659. 

  1659.                         <input name=owner_last>
    1660. 

  1660.                         </td>
    1661. 

  1661.                         </tr>
    1662. 

  1662.                         <tr>
    1663. 

  1663.                         <td width=40% align=right>
    1664. 

  1664.                         Motor Brand&nbsp;
    1665. 

  1665.                         </td>
    1666. 

  1666.                         <td width=60% align=left>&nbsp;
    1667. 

  1667.                         <input name=motor_brand>
    1668. 

  1668.                         </td>
    1669. 

  1669.                         </tr>
    1670. 

  1670.                         <tr>
    1671. 

  1671.                         <td width=40% align=right>
    1672. 

  1672.                         Body Color&nbsp;
    1673. 

  1673.                         </td>
    1674. 

  1674.                         <td width=60% align=left>&nbsp;
    1675. 

  1675.                         <input name=body_color>
    1676. 

  1676.                         </td>
    1677. 

  1677.                         </tr>
    1678. 

  1678.                         <tr>
    1679. 

  1679.                         <td width=40% align=right>
    1680. 

  1680.                         Engine Type&nbsp;
    1681. 

  1681.                         </td>
    1682. 

  1682.                         <td width=60% align=left>&nbsp;
    1683. 

  1683.                         <input name=engine_type>
    1684. 

  1684.                         </td>
    1685. 

  1685.                         </tr>
    1686. 

  1686.                         <tr>
    1687. 

  1687.                         <td>&nbsp;</td>
    1688. 

  1688.                         </tr>
    1689. 

  1689.                         <tr>
    1690. 

  1690.                         <td colspan=2 align=center>
    1691. 

  1691.                         <input type=button name='buss_report' value="View Report" onClick="javascript: Franlist();">
    1692. 

  1692.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1693. 

  1693.                         </td>
    1694. 

  1694.                         </tr>
    1695. 

  1695. <?php
    1696. 

  1696. 

  1697.                         } if ($fran_select=='ebpls_motor_permit.php') {
    1698. 

  1698. ?>
    1699. 

  1699.                         <tr>
    1700. 

  1700.                         <td width=40% align=right>
    1701. 

  1701.                         Owner Last Name&nbsp;
    1702. 

  1702.                         </td>
    1703. 

  1703.                         <td width=60% align=left>&nbsp;
    1704. 

  1704.                         <input name=owner_last>
    1705. 

  1705.                         </td>
    1706. 

  1706.                         </tr>
    1707. 

  1707.                         <tr>
    1708. 

  1708.                         <td width=40% align=right>
    1709. 

  1709.                         Permit #&nbsp;
    1710. 

  1710.                         </td>
    1711. 

  1711.                         <td width=60% align=left>&nbsp;
    1712. 

  1712.                         <input name=permit_num>
    1713. 

  1713.                         </td>
    1714. 

  1714.                         </tr>
    1715. 

  1715.                         <tr>
    1716. 

  1716.                         <td>&nbsp;</td>
    1717. 

  1717.                         </tr>
    1718. 

  1718.                         <tr>
    1719. 

  1719.                         <td colspan=2 align=center>
    1720. 

  1720.                         <input type=button name='buss_report' value="View Report" onClick="javascript: FranchisePermit();">
    1721. 

  1721.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1722. 

  1722.                         </td>
    1723. 

  1723.                         </tr>
    1724. 

  1724. <?php
    1725. 

  1725. 

  1726.                         }
    1727. 

  1727. ?>
    1728. 

  1728. 					</table>
    1729. 

  1729. 				</td>
    1730. 

  1730. 			</tr>
    1731. 

  1731. 			<tr>
    1732. 

  1732. 				<td>&nbsp;</td>
    1733. 

  1733. 			</tr>
    1734. 

  1734. 			<tr>
    1735. 

  1735. 				<td>&nbsp;</td>
    1736. 

  1736. 			</tr>
    1737. 

  1737. 			<?php
    1738. 

  1738. 			} elseif ($rpt=='Fishery') {
    1739. 

  1739. 			?>
    1740. 

  1740. 			<tr>
    1741. 

  1741. 				<td align="center" valign="top" width=100% colspan=2>
    1742. 

  1742. 					<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    1743. 

  1743. 						<tr>
    1744. 

  1744. 							<td class='header2' colspan=2 align=center>Fishery Permit</td>
    1745. 

  1745. 						</tr>
    1746. 

  1746. 						<tr>
    1747. 

  1747. 							<td>&nbsp;</td>
    1748. 

  1748. 						</tr>
    1749. 

  1749. 						<tr>
    1750. 

  1750. 							<?php
    1751. 

  1751. 								//where report_desc like '%business%' or report_desc like 'business%' 
    1752. 

  1752. 								//$result = mysql_query("select report_desc, report_file from ebpls_reports order by report_desc asc") or die(mysql_error()); 
    1753. 

  1753. 								$result= mysql_query("select report_desc, report_file from ebpls_reports 
    1754. 

  1754. 								where report_type like '%fishery%'  order by report_desc asc") or die(mysql_error()); 
    1755. 

  1755.     							//$reports=mysql_fetch_row($result);
    1756. 

  1756.   								print "<td width=40% align=right>
    1757. 

  1757.     							Reports&nbsp</td>";
    1758. 

  1758.     							print "<td width=60% align=left>&nbsp
    1759. 

  1759.     								<select name='buss_select' onchange='javascript: _FRM.fish_select.value=_FRM.buss_select.value; _FRM.submit();'>>";
    1760. 

  1760. 									print"<option value=''>------</option>";
    1761. 

  1761.     								while ($reports=mysql_fetch_row($result)) {
    1762. 

  1762. 										if ($fish_select == $reports[1]) {
    1763. 

  1763. 		    								$iselecty = 'selected';
    1764. 

  1764. 	    								} else {
    1765. 

  1765. 		    								$iselecty = '';
    1766. 

  1766. 	    								}
    1767. 

  1767.     									$getlevel = mysql_query("select * from ebpls_user_sublevel where
    1768. 

  1768. 										submenu = '$reports[0]'");
    1769. 

  1769. 					$getme = mysql_fetch_assoc($getlevel);
    1770. 

  1770. 					
    1771. 

  1771. 					if ($$getme['rptvars']==1) {
    1772. 

  1772.     									print"<option value=$reports[1] $iselecty>$reports[0]</option>";
    1773. 

  1773. 					}
    1774. 

  1774. 									}
    1775. 

  1775.     								print"</select></td><input type=hidden name=fish_select>";
    1776. 

  1776.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    1777. 

  1777.     						?>
    1778. 

  1778.     					</tr>
    1779. 

  1779. 						<tr>
    1780. 

  1780. 						<tr>
    1781. 

  1781. 							<td>&nbsp;</td>
    1782. 

  1782. 						</tr>
    1783. 

  1783. 						<?
    1784. 

  1784. 						if ($fish_select=='ebpls_fishery_list.php') {
    1785. 

  1785. ?>
    1786. 

  1786.                         <tr>
    1787. 

  1787.                         <td width=40% align=right>
    1788. 

  1788.                         Date: </td>
    1789. 

  1789.                         <td align="left" valign="top" class='normal'>&nbsp;
    1790. 

  1790.                                 
    1791. 

  1791. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    1792. 

  1792. <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;">
    1793. 

  1793.  
    1794. 

  1794. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    1795. 

  1795. <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;">
    1796. 

  1796. 

  1797.                         </td>
    1798. 

  1798.                         </tr>
    1799. 

  1799. 						<tr>
    1800. 

  1800.                         <td width=40% align=right>
    1801. 

  1801.                         Barangay&nbsp;
    1802. 

  1802.                         </td>
    1803. 

  1803.                         <td width=60% align=left>&nbsp;
    1804. 

  1804.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    1805. 

  1805.                         </td>
    1806. 

  1806.                         </tr>
    1807. 

  1807.                         <tr>
    1808. 

  1808.                         <td>&nbsp;</td>
    1809. 

  1809.                         </tr>
    1810. 

  1810.                         <tr>
    1811. 

  1811.                         <td colspan=2 align=center>
    1812. 

  1812.                         <input type=button name='buss_report' value="View Report" onClick="javascript: Fishlist();">
    1813. 

  1813.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1814. 

  1814.                         </td>
    1815. 

  1815.                         </tr>
    1816. 

  1816. <?php
    1817. 

  1817. 

  1818.                         }if ($fish_select=='ebpls_fish_permit.php') {
    1819. 

  1819. ?>
    1820. 

  1820.                         <tr>
    1821. 

  1821.                         <td width=40% align=right>
    1822. 

  1822.                         Owner Last Name&nbsp;
    1823. 

  1823.                         </td>
    1824. 

  1824.                         <td width=60% align=left>&nbsp;
    1825. 

  1825.                         <input name=owner_last>
    1826. 

  1826.                         </td>
    1827. 

  1827.                         </tr>
    1828. 

  1828.                         <tr>
    1829. 

  1829.                         <td width=40% align=right>
    1830. 

  1830.                         Permit #&nbsp;
    1831. 

  1831.                         </td>
    1832. 

  1832.                         <td width=60% align=left>&nbsp;
    1833. 

  1833.                         <input name=permit_num>
    1834. 

  1834.                         </td>
    1835. 

  1835.                         </tr>
    1836. 

  1836.                         <tr>
    1837. 

  1837.                         <td>&nbsp;</td>
    1838. 

  1838.                         </tr>
    1839. 

  1839.                         <tr>
    1840. 

  1840.                         <td colspan=2 align=center>
    1841. 

  1841.                         <input type=button name='buss_report' value="View Report" onClick="javascript: FishPermit();">
    1842. 

  1842.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1843. 

  1843.                         </td>
    1844. 

  1844.                         </tr>
    1845. 

  1845. <?php
    1846. 

  1846. 

  1847.                         }
    1848. 

  1848. ?>
    1849. 

  1849. 					</table>	
    1850. 

  1850. 				</td>
    1851. 

  1851. 			</tr>
    1852. 

  1852. 			<?php
    1853. 

  1853. 			} elseif ($rpt=='Peddlers') {
    1854. 

  1854. 			?>
    1855. 

  1855. 			<tr>
    1856. 

  1856. 				<td align="center" valign="top" width=100% colspan=2>
    1857. 

  1857. 					<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    1858. 

  1858. 						<tr>
    1859. 

  1859. 							<td class='header2' colspan=2 align=center>Peddlers Permit</td>
    1860. 

  1860. 						</tr>
    1861. 

  1861. 						<tr>
    1862. 

  1862. 							<td>&nbsp;</td>
    1863. 

  1863. 						</tr>
    1864. 

  1864. 						<tr>
    1865. 

  1865. 							<?php
    1866. 

  1866. 								//where report_desc like '%business%' or report_desc like 'business%' 
    1867. 

  1867. 								//$result = mysql_query("select report_desc, report_file from ebpls_reports order by report_desc asc") or die(mysql_error()); 
    1868. 

  1868. 								$result= mysql_query("select report_desc, report_file from ebpls_reports 
    1869. 

  1869. 								where report_type like '%peddler%' order by report_desc asc") or die(mysql_error()); 
    1870. 

  1870.     							//$reports=mysql_fetch_row($result);
    1871. 

  1871.   								print "<td width=40% align=right>
    1872. 

  1872.     							Reports&nbsp</td>";
    1873. 

  1873.     							print "<td width=60% align=left>&nbsp
    1874. 

  1874.     								<select name='buss_select' onchange='javascript: _FRM.pedd_select.value=_FRM.buss_select.value; _FRM.submit();'>";
    1875. 

  1875.     								print"<option value=''>--------</option>";
    1876. 

  1876.     								while ($reports=mysql_fetch_row($result)) {
    1877. 

  1877. 	    								if ($pedd_select == $reports[1]) {
    1878. 

  1878. 		    								$iselecty = 'selected';
    1879. 

  1879. 	    								} else {
    1880. 

  1880. 		    								$iselecty = '';
    1881. 

  1881. 	    								}
    1882. 

  1882.     									$getlevel = mysql_query("select * from ebpls_user_sublevel where
    1883. 

  1883. 										submenu = '$reports[0]'");
    1884. 

  1884. 					$getme = mysql_fetch_assoc($getlevel);
    1885. 

  1885. 					
    1886. 

  1886. 					if ($$getme['rptvars']==1) {
    1887. 

  1887.     									print"<option value=$reports[1] $iselecty>$reports[0]</option>";
    1888. 

  1888. 					}
    1889. 

  1889. 									}
    1890. 

  1890.     								print"</select><input type=hidden name='pedd_select'></td>";
    1891. 

  1891.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    1892. 

  1892.     						?>
    1893. 

  1893.     					</tr>
    1894. 

  1894. 						<tr>
    1895. 

  1895. 						<tr>
    1896. 

  1896. 							<td>&nbsp;</td>
    1897. 

  1897. 						</tr>
    1898. 

  1898. 						<?
    1899. 

  1899. 						if ($pedd_select=='ebpls_peddler_list.php') {
    1900. 

  1900. ?>
    1901. 

  1901.                         <tr>
    1902. 

  1902.                         <td width=40% align=right>
    1903. 

  1903.                         Date: </td>
    1904. 

  1904.                         <td align="left" valign="top" class='normal'>&nbsp;
    1905. 

  1905.                               
    1906. 

  1906. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    1907. 

  1907. <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;">
    1908. 

  1908.  
    1909. 

  1909. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    1910. 

  1910. <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;">
    1911. 

  1911. 

  1912.                         </td>
    1913. 

  1913.                         </tr>
    1914. 

  1914. 						<tr>
    1915. 

  1915.                         <td width=40% align=right>
    1916. 

  1916.                         Barangay&nbsp;
    1917. 

  1917.                         </td>
    1918. 

  1918.                         <td width=60% align=left>&nbsp;
    1919. 

  1919.                         <?php echo get_select_brgy($dbLink,'brgy_name','ebpls_barangay','barangay_code','barangay_desc',$owner[6]);?>
    1920. 

  1920.                         </td>
    1921. 

  1921.                         </tr>
    1922. 

  1922.                         <tr>
    1923. 

  1923.                         <td width=40% align=right>
    1924. 

  1924.                         Owner's Last Name&nbsp;
    1925. 

  1925.                         </td>
    1926. 

  1926.                         <td width=60% align=left>&nbsp;
    1927. 

  1927.                         <input name=owner_last>
    1928. 

  1928.                         </td>
    1929. 

  1929.                         </tr>
    1930. 

  1930.                         <tr>
    1931. 

  1931.                         <td width=40% align=right>
    1932. 

  1932.                         Business Name&nbsp;
    1933. 

  1933.                         </td>
    1934. 

  1934.                         <td width=60% align=left>&nbsp;
    1935. 

  1935.                         <input name=business>
    1936. 

  1936.                         </td>
    1937. 

  1937.                         </tr>
    1938. 

  1938.                         <tr>
    1939. 

  1939.                         <td>&nbsp;</td>
    1940. 

  1940.                         </tr>
    1941. 

  1941.                         <tr>
    1942. 

  1942.                         <td colspan=2 align=center>
    1943. 

  1943.                         <input type=button name='buss_report' value="View Report" onClick="javascript: Peddlist();">
    1944. 

  1944.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1945. 

  1945.                         </td>
    1946. 

  1946.                         </tr>
    1947. 

  1947. <?php
    1948. 

  1948. 

  1949.                         }
    1950. 

  1950. 						if ($pedd_select=='ebpls_peddler_permit.php') {
    1951. 

  1951. ?>
    1952. 

  1952.                         <tr>
    1953. 

  1953.                         <td width=40% align=right>
    1954. 

  1954.                         Owner Last Name&nbsp;
    1955. 

  1955.                         </td>
    1956. 

  1956.                         <td width=60% align=left>&nbsp;
    1957. 

  1957.                         <input name=owner_last>
    1958. 

  1958.                         </td>
    1959. 

  1959.                         </tr>
    1960. 

  1960.                         <tr>
    1961. 

  1961.                         <td width=40% align=right>
    1962. 

  1962.                         Permit #&nbsp;
    1963. 

  1963.                         </td>
    1964. 

  1964.                         <td width=60% align=left>&nbsp;
    1965. 

  1965.                         <input name=permit_num>
    1966. 

  1966.                         </td>
    1967. 

  1967.                         </tr>
    1968. 

  1968.                         <tr>
    1969. 

  1969.                         <td>&nbsp;</td>
    1970. 

  1970.                         </tr>
    1971. 

  1971.                         <tr>
    1972. 

  1972.                         <td colspan=2 align=center>
    1973. 

  1973.                         <input type=button name='buss_report' value="View Report" onClick="javascript: PeddPermit();">
    1974. 

  1974.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1975. 

  1975.                         </td>
    1976. 

  1976.                         </tr>
    1977. 

  1977. <?php
    1978. 

  1978. 

  1979.                         }
    1980. 

  1980. ?>
    1981. 

  1981. 					</table>
    1982. 

  1982. 				</td>
    1983. 

  1983. 			</tr>
    1984. 

  1984. 			<tr>
    1985. 

  1985. 				<td>&nbsp;</td>
    1986. 

  1986. 			</tr>
    1987. 

  1987. 			<tr>
    1988. 

  1988. 				<td>&nbsp;</td>
    1989. 

  1989. 			</tr>
    1990. 

  1990. 			<?php
    1991. 

  1991. 			} elseif ($rpt=='CTC') {
    1992. 

  1992. 			?>
    1993. 

  1993. 			<tr>
    1994. 

  1994. 				<td align="center" valign="top" width=100% colspan=2>
    1995. 

  1995. 				<input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    1996. 

  1996. 				<script language="javascript">
    1997. 

  1997. 				function CTCIssued()
    1998. 

  1998.         {
    1999. 

  1999.         var _FRM = document._FRM;
    2000. 

  2000. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    2001. 

  2001. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    2002. 

  2002. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    2003. 

  2003. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    2004. 

  2004. 		var getDiff = (vDate2-vDate1);
    2005. 

  2005. 		var today = new Date();
    2006. 

  2006. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    2007. 

  2007. 		var datefrom = new Date();
    2008. 

  2008. 		var dateto = new Date();
    2009. 

  2009. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    2010. 

  2010. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    2011. 

  2011. 		
    2012. 

  2012. 		if (datefrom > today) {
    2013. 

  2013. 			alert("Date Range cannot exceed current date.");
    2014. 

  2014. 			_FRM.date_from.select();
    2015. 

  2015. 			return false;
    2016. 

  2016. 		}
    2017. 

  2017. 		if (dateto > today) {
    2018. 

  2018. 			alert("Date Range cannot exceed current date.");
    2019. 

  2019. 			_FRM.date_to.select();
    2020. 

  2020. 			return false;
    2021. 

  2021. 		}
    2022. 

  2022. 		if (getDiff < 0) {
    2023. 

  2023. 			alert("Invalid Date Range!!");
    2024. 

  2024. 			_FRM.date_from.select();
    2025. 

  2025. 			return false;
    2026. 

  2026. 		}
    2027. 

  2027.         winpopup = window.open('reports/' + _FRM.ctc_select.value + '?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&usern=' + _FRM.usernm.value);
    2028. 

  2028. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2029. 

  2029.         return true;
    2030. 

  2030. 

  2031. 

  2032.         }
    2033. 

  2033. 		</script>
    2034. 

  2034. 					<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2035. 

  2035. 						<tr>
    2036. 

  2036. 							<td class='header2' colspan=2 align=center>CTC</td>
    2037. 

  2037. 						</tr>
    2038. 

  2038. 						<tr>
    2039. 

  2039. 							<td>&nbsp;</td>
    2040. 

  2040. 						</tr>
    2041. 

  2041. 						<tr>
    2042. 

  2042. 							<?php
    2043. 

  2043. 								//where report_desc like '%business%' or report_desc like 'business%' 
    2044. 

  2044. 								//$result = mysql_query("select report_desc, report_file from ebpls_reports order by report_desc asc") or die(mysql_error()); 
    2045. 

  2045. 								$result= mysql_query("select report_desc, report_file from ebpls_reports 
    2046. 

  2046. 								where report_desc like '%CTC%' order by report_desc asc") or die(mysql_error()); 
    2047. 

  2047.     							//$reports=mysql_fetch_row($result);
    2048. 

  2048.   								print "<td width=40% align=right>
    2049. 

  2049.     							Reports&nbsp</td>";
    2050. 

  2050.     							print "<td width=60% align=left>&nbsp
    2051. 

  2051.     								<select name='ctc_select' onchange='javascript: _FRM.ctc1_select.value=_FRM.ctc_select.value; _FRM.submit();'>";
    2052. 

  2052.     								print"<option value=''>--------</option>";
    2053. 

  2053.     								
    2054. 

  2054.     								$ctc1_select = isset($ctc1_select) ? $ctc1_select : ''; //2008.05.13
    2055. 

  2055.     								$K = isset($K) ? $K : '';
    2056. 

  2056.     								$selected = isset($selected) ? $selected : '';
    2057. 

  2057.     								
    2058. 

  2058.     								while ($reports=mysql_fetch_row($result)) {
    2059. 

  2059. 	    								if ($ctc1_select == $reports[1]) {
    2060. 

  2060. 		    								$iselecty = 'selected';
    2061. 

  2061. 	    								} else {
    2062. 

  2062. 		    								$iselecty = '';
    2063. 

  2063. 	    								}
    2064. 

  2064. 	    								$str_selected = (! strcasecmp($K,"$selected")) ? ('selected') : ('');
    2065. 

  2065. 					$getlevel = mysql_query("select * from ebpls_user_sublevel where
    2066. 

  2066. 										submenu = '$reports[0]'");
    2067. 

  2067. 					$getme = mysql_fetch_assoc($getlevel);
    2068. 

  2068. 					
    2069. 

  2069. 					if ($$getme['rptvars']==1) {
    2070. 

  2070.     									print"<option value=$reports[1] $iselecty>$reports[0]</option>";
    2071. 

  2071. 					}
    2072. 

  2072. 									}
    2073. 

  2073.     								print"</select><input type=hidden name='ctc1_select'></td>";
    2074. 

  2074.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    2075. 

  2075.     						?>
    2076. 

  2076.     					</tr>
    2077. 

  2077. 						<tr>
    2078. 

  2078. 						<tr>
    2079. 

  2079. 							<td>&nbsp;</td>
    2080. 

  2080. 						</tr>
    2081. 

  2081. 						</table>
    2082. 

  2082. 					</td>
    2083. 

  2083. 				</tr>
    2084. 

  2084. 						<?
    2085. 

  2085. 						if ($ctc1_select=='ebpls_ctc_apply_masterlistbus.php' || $ctc1_select=='ebpls_ctc_apply_masterlist.php') {
    2086. 

  2086. ?>
    2087. 

  2087.                         <tr>
    2088. 

  2088.                         <td width=40% align=right>
    2089. 

  2089.                         Date: </td>
    2090. 

  2090.                         <td align="left" valign="top" class='normal'>&nbsp;
    2091. 

  2091.                                
    2092. 

  2092. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    2093. 

  2093. <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;">
    2094. 

  2094.  
    2095. 

  2095. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    2096. 

  2096. <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;">
    2097. 

  2097. 

  2098.                         </td>
    2099. 

  2099.                         </tr>
    2100. 

  2100.                         <tr>
    2101. 

  2101.                         <td>&nbsp;</td>
    2102. 

  2102.                         </tr>
    2103. 

  2103.                         <tr>
    2104. 

  2104.                         <td colspan=2 align=center>
    2105. 

  2105.                         <input type=button name='buss_report' value="View Report" onClick="javascript:CTCIssued();">
    2106. 

  2106.                         </td>
    2107. 

  2107.                         </tr>
    2108. 

  2108. <?php
    2109. 

  2109. 

  2110.                         }
    2111. 

  2111. 			} elseif ($rpt=='System') {
    2112. 

  2112. 			?>
    2113. 

  2113. 			<tr>
    2114. 

  2114. 				<td align="center" valign="top" colspan=2>
    2115. 

  2115. 					<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2116. 

  2116. 					
    2117. 

  2117. 						<tr>
    2118. 

  2118. 							<td class='header2' colspan=2 align=center>System</td>
    2119. 

  2119. 						</tr>
    2120. 

  2120. 						<tr>
    2121. 

  2121. 							<td>&nbsp;</td>
    2122. 

  2122. 						</tr>
    2123. 

  2123. 						<tr>
    2124. 

  2124. 							<td width=40% align=right>
    2125. 

  2125. 								Activity Log&nbsp;(Start Date)&nbsp;
    2126. 

  2126. 							</td>
    2127. 

  2127. 							<td width=60% align=left>&nbsp;
    2128. 

  2128. 								        
    2129. 

  2129. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_from" onclick="displayCalendar(date_from,'yyyy/mm/dd',this);">
    2130. 

  2130. <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;">
    2131. 

  2131.  
    2132. 

  2132. 

  2133. 							</td>
    2134. 

  2134. 						</tr>
    2135. 

  2135. 						<tr>
    2136. 

  2136. 							<td width=40% align=right>
    2137. 

  2137. 								(End Date)&nbsp;
    2138. 

  2138. 							</td>
    2139. 

  2139. 							<td width=60% align=left>&nbsp;
    2140. 

  2140. 

  2141. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="date_to" onclick="displayCalendar(date_to,'yyyy/mm/dd',this);">
    2142. 

  2142. <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;">
    2143. 

  2143. 

  2144. 							</td>
    2145. 

  2145. 						</tr>
    2146. 

  2146. 						<tr>
    2147. 

  2147. 							<td width=40% align=right>
    2148. 

  2148. 								Users&nbsp;
    2149. 

  2149. 							</td>
    2150. 

  2150. 							<td width=60% align=left>&nbsp;
    2151. 

  2151. 								<input type=text name='users' value='' >
    2152. 

  2152. 							</td>
    2153. 

  2153. 						</tr>
    2154. 

  2154. 						<tr>
    2155. 

  2155. 							<?php
    2156. 

  2156. 								$result = mysql_query("select report_desc from ebpls_reports where report_type='System' order by report_desc asc") or die(mysql_error()); 
    2157. 

  2157.     							//$reports=mysql_fetch_row($result);
    2158. 

  2158.   								print "<td width=40% align=right>";
    2159. 

  2159.     							// echo $reports;
    2160. 

  2160.     							print "Reports&nbsp</td>";
    2161. 

  2161.     							print "<td width=60% align=left>&nbsp&nbsp;\n
    2162. 

  2162. 									<select name='buss_select'>";
    2163. 

  2163.     								while ($reports=mysql_fetch_row($result)) {
    2164. 

  2164.     									$getlevel = mysql_query("select * from ebpls_user_sublevel where
    2165. 

  2165. 										submenu = '$reports[0]'");
    2166. 

  2166. 									$getme = mysql_fetch_assoc($getlevel);
    2167. 

  2167. 									
    2168. 

  2168. 									$iselecty = isset($iselecty) ? $iselecty : '';
    2169. 

  2169. 									if ($$getme['rptvars']==1) {
    2170. 

  2170.     										print"<option value=$reports[1] $iselecty>$reports[0]</option>";
    2171. 

  2171. 									}
    2172. 

  2172. 								}
    2173. 

  2173.     								print"</select></td>";
    2174. 

  2174.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    2175. 

  2175.     							print "</td>";
    2176. 

  2176.     						?>
    2177. 

  2177.     					</tr>
    2178. 

  2178. 						<tr>
    2179. 

  2179. 						<tr>
    2180. 

  2180. 							<td>&nbsp;</td>
    2181. 

  2181. 						</tr>
    2182. 

  2182. 						<tr>
    2183. 

  2183. 						<input type=hidden name=report_file value="<?php echo $report_file; ?>">
    2184. 

  2184. 			<input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    2185. 

  2185. 							<td colspan=2 align=center>
    2186. 

  2186. 								<input type=button name='sys_report' value="View Report" onclick="javascript: SysRep();"> 
    2187. 

  2187. 							</td>
    2188. 

  2188. 						</tr>
    2189. 

  2189. 					</table>	
    2190. 

  2190. 				</td>
    2191. 

  2191. 			</tr>
    2192. 

  2192. 			<?php
    2193. 

  2193. 			} elseif ($rpt=='Abstract') {
    2194. 

  2194. 			?>
    2195. 

  2195. 			  <tr>
    2196. 

  2196.                                 <td align="center" valign="top" colspan=2>
    2197. 

  2197.                                         <table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2198. 

  2198.                                                 <tr>
    2199. 

  2199.                                                         <td class='header2' colspan=2 align=center>Abstract of General Collection Template</td>
    2200. 

  2200.                                                 </tr>
    2201. 

  2201.                                                 <tr>
    2202. 

  2202.                                                         <td>&nbsp;</td>
    2203. 

  2203.                                                 </tr>
    2204. 

  2204.                                                 <tr>
    2205. 

  2205.                                                         <td width=40% align=right>
    2206. 

  2206.                                                                 Tax/Fee:
    2207. 

  2207.                                                         </td>
    2208. 

  2208.                                                         <td width=60% align=left>&nbsp;
    2209. 

  2209. 								<?php echo get_select_data_where($dbLink,'rpt_temp','ebpls_buss_tfo','tfoid','tfodesc',$owner_datarow[tfoid],'tfostatus ="A"');?>
    2210. 

  2210. 

  2211.                                                         </td>
    2212. 

  2212.                                                 </tr>
    2213. 

  2213. 						</table>
    2214. 

  2214. 					
    2215. 

  2215. 						<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2216. 

  2216. 

  2217. 						<tr>
    2218. 

  2218. 							<td>
    2219. 

  2219. 							<?php
    2220. 

  2220. 

  2221. 							$getr = mysql_query("select a.rpt_id, b.tfodesc from rpt_temp_abs a, ebpls_buss_tfo b 
    2222. 

  2222. 								where a.tfoid = b.tfoid");
    2223. 

  2223. 							?>
    2224. 

  2224. 							<table border=1 cellspacing=0 cellpadding=0  width='50%' align=center>
    2225. 

  2225. 							<tr>
    2226. 

  2226. 								<td align=center width=70%>Tax/Fee</td><td align=center width=20%>&nbsp;</td>
    2227. 

  2227. 							</tr>
    2228. 

  2228. 							<?php
    2229. 

  2229. 							while($listit = mysql_fetch_row($getr))
    2230. 

  2230. 							{
    2231. 

  2231. 							?>
    2232. 

  2232. 							<tr><td><?php echo $listit[1]; ?></td><td align=center>
    2233. 

  2233. 							<a href='index.php?part=4&class_type=Reports&itemID_=921&busItem=Reports&permit_type=Reports&com=delete&rpt_id=<?php echo $listit[0]; ?>'>Delete</a></td>		
    2234. 

  2234. 							</tr>
    2235. 

  2235. 							<?php
    2236. 

  2236. 							}
    2237. 

  2237. 							?>
    2238. 

  2238. 							</table>
    2239. 

  2239. 							</td>
    2240. 

  2240. 						</tr>
    2241. 

  2241. 						</table>
    2242. 

  2242. 

  2243. 						<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2244. 

  2244. 

  2245.                                                 <tr>
    2246. 

  2246.                                                 <tr>
    2247. 

  2247.                                                         <td>&nbsp;</td>
    2248. 

  2248.                                                 </tr>
    2249. 

  2249.                                                 <tr>
    2250. 

  2250.                                                         <td colspan=2 align=center>
    2251. 

  2251.                                                                 <input type=submit name='sys_report' value="Add">
    2252. 

  2252.                                                         </td>
    2253. 

  2253.                                                 </tr>
    2254. 

  2254.                                         </table>
    2255. 

  2255.                                 </td>
    2256. 

  2256.                         </tr>
    2257. 

  2257.                         <?php
    2258. 

  2258. 			} elseif ($rpt=='Tax/Fee') {
    2259. 

  2259. 			?>
    2260. 

  2260.                         
    2261. 

  2261.                         
    2262. 

  2262.        
    2263. 

  2263. 			 <tr>
    2264. 

  2264.                                 <td align="center" valign="top" colspan=2>
    2265. 

  2265.                                         <table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2266. 

  2266.                                                 <tr>
    2267. 

  2267. 							<td class='header2' colspan=2 align=center>Business Tax/Fee Collection Report</td>
    2268. 

  2268. 						</tr>
    2269. 

  2269. 						
    2270. 

  2270. 						<tr>
    2271. 

  2271. 							<td>&nbsp;</td>
    2272. 

  2272. 						</tr>
    2273. 

  2273. 						
    2274. 

  2274. 						
    2275. 

  2275. 						
    2276. 

  2276. 						  <tr>
    2277. 

  2277. 				        <td align=right>Previous Date:&nbsp;</td>
    2278. 

  2278. 					<td align=left>
    2279. 

  2279. 				<!--	<input type=text align=right  name=checkdate value='' size=10 readonly>-->
    2280. 

  2280. <input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="checkid1" onclick="displayCalendar(checkid1,'yyyy/mm/dd',this);">
    2281. 

  2281. <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.checkid1,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
    2282. 

  2282. 

  2283. 				        </tr>
    2284. 

  2284. 				         <tr>
    2285. 

  2285. 				        <td align=right>Current Date:&nbsp;</td>
    2286. 

  2286. 					<td align=left>
    2287. 

  2287. 				<!--	<input type=text align=right  name=checkdate value='' size=10 readonly>-->
    2288. 

  2288. 						<input type="text" value="<?php echo date('Y/m/d'); ?>" readonly name="checkid2" onclick="displayCalendar(checkid2,'yyyy/mm/dd',this);">
    2289. 

  2289. <img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a date" onclick ="displayCalendar(_FRM.checkid2,'yyyy/mm/dd',this);_FRM.changeondin.value=1;">
    2290. 

  2290.  		        </tr>
    2291. 

  2291. 				        <tr>
    2292. 

  2292. 						
    2293. 

  2293. 					
    2294. 

  2294. 						<tr>
    2295. 

  2295. 							<td>&nbsp;</td>
    2296. 

  2296. 						</tr>
    2297. 

  2297. 						
    2298. 

  2298. 						<tr>
    2299. 

  2299. 						<!--<input type=hidden name=col_sel value='<? /*2008.05.13 echo $col_sel;*/?>'>-->
    2300. 

  2300. 							<?php
    2301. 

  2301. 								//where report_desc like '%business%' or report_desc like 'business%' 
    2302. 

  2302. 								$result = mysql_query("select report_desc, report_file from ebpls_reports 
    2303. 

  2303. 									where report_type like '%colection%' or 
    2304. 

  2304. 									report_type like '%collection%'
    2305. 

  2305. 									order by report_desc asc") or die(mysql_error()); 
    2306. 

  2306.     		
    2307. 

  2307.   								print "<td width=20% align=right>
    2308. 

  2308.     							Reports&nbsp</td>";
    2309. 

  2309.     							print "<td width=20% align=left>
    2310. 

  2310.     								<select name='col_sel' onChange='javascript: submit();'>";
    2311. 

  2311.     								print"<option value='' >---------</option>";
    2312. 

  2312.     								while ($reports=mysql_fetch_row($result)) {
    2313. 

  2313.     									$col_sel = isset($col_sel) ? $col_sel : ''; //2008.05.13
    2314. 

  2314. 	    								if ($col_sel==$reports[1]) {
    2315. 

  2315. 		    								$ifselect="selected";
    2316. 

  2316. 	    								} else {
    2317. 

  2317. 		    								$ifselect="";
    2318. 

  2318. 	    								}
    2319. 

  2319.     									$getlevel = mysql_query("select * from ebpls_user_sublevel where
    2320. 

  2320. 										submenu = '$reports[0]'");
    2321. 

  2321. 									$getme = mysql_fetch_assoc($getlevel);
    2322. 

  2322. 					
    2323. 

  2323. 									if ($$getme['rptvars']==1) {
    2324. 

  2324.     										print"<option value=$reports[1] $ifselect>$reports[0]</option>";
    2325. 

  2325. 									}
    2326. 

  2326. 								}
    2327. 

  2327.     								print"</select></td>";
    2328. 

  2328.     							
    2329. 

  2329.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    2330. 

  2330.     						?>
    2331. 

  2331.     					</tr>
    2332. 

  2332.     				<?php	
    2333. 

  2333.     					if ($col_sel=='ebpls_abstractcoll.php') {
    2334. 

  2334. 			?>
    2335. 

  2335. 			  <tr>
    2336. 

  2336.                                 <td align="center" valign="top" colspan=2>
    2337. 

  2337.                                         <table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2338. 

  2338.                                                 <tr>
    2339. 

  2339.                                                         <td class='header2' colspan=2 align=center>Abstract of General Collection Template</td>
    2340. 

  2340.                                                 </tr>
    2341. 

  2341.                                                 <tr>
    2342. 

  2342.                                                         <td>&nbsp;</td>
    2343. 

  2343.                                                 </tr>
    2344. 

  2344.                                                 <tr>
    2345. 

  2345.                                                         <td width=40% align=right>
    2346. 

  2346.                                                                 Tax/Fee:
    2347. 

  2347.                                                         </td>
    2348. 

  2348.                                                         <td width=60% align=left>&nbsp;
    2349. 

  2349. 								<?php echo get_select_data_where($dbLink,'rpt_temp','ebpls_buss_tfo','tfoid','tfodesc',$owner_datarow['tfoid'],'tfostatus ="A"');?>
    2350. 

  2350. 

  2351.                                                         </td>
    2352. 

  2352.                                                 </tr>
    2353. 

  2353. 						</table>
    2354. 

  2354. 					
    2355. 

  2355. 						<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2356. 

  2356. 

  2357. 						<tr>
    2358. 

  2358. 							<td>
    2359. 

  2359. 							<?php
    2360. 

  2360. 

  2361. 							$getr = mysql_query("select a.rpt_id, b.tfodesc from rpt_temp_abs a, ebpls_buss_tfo b 
    2362. 

  2362. 								where a.tfoid = b.tfoid");
    2363. 

  2363. 							?>
    2364. 

  2364. 							<table border=1 cellspacing=0 cellpadding=0  width='50%' align=center>
    2365. 

  2365. 							<tr>
    2366. 

  2366. 								<td align=center width=70%>Tax/Fee</td><td align=center width=20%>&nbsp;</td>
    2367. 

  2367. 							</tr>
    2368. 

  2368. 							<?php
    2369. 

  2369. 							while($listit = mysql_fetch_row($getr))
    2370. 

  2370. 							{
    2371. 

  2371. 							?>
    2372. 

  2372. 							<tr><td><?php echo $listit[1]; ?></td><td align=center>
    2373. 

  2373. 							<a href='index.php?part=4&class_type=Reports&itemID_=921&busItem=Reports&permit_type=Reports&com=delete&rpt_id=<?php echo $listit[0]; ?>'>Delete</a></td>		
    2374. 

  2374. 							</tr>
    2375. 

  2375. 							<?php
    2376. 

  2376. 							}
    2377. 

  2377. 							?>
    2378. 

  2378. 							</table>
    2379. 

  2379. 							</td>
    2380. 

  2380. 						</tr>
    2381. 

  2381. 						</table>
    2382. 

  2382. 

  2383. 						<table border=0 cellspacing=0 cellpadding=0  width='100%'>
    2384. 

  2384. 

  2385.                                                 <tr>
    2386. 

  2386.                                                 <tr>
    2387. 

  2387.                                                         <td>&nbsp;</td>
    2388. 

  2388.                                                 </tr>
    2389. 

  2389.                                                 <tr>
    2390. 

  2390.                                                         <td colspan=2 align=center>
    2391. 

  2391.                                                                 <input type=submit name='sys_report' value="Add">
    2392. 

  2392.                                                         </td>
    2393. 

  2393.                                                 </tr>
    2394. 

  2394.                                         </table>
    2395. 

  2395.                                 </td>
    2396. 

  2396.                         </tr>
    2397. 

  2397.                         <?php
    2398. 

  2398. 			}
    2399. 

  2399.     					
    2400. 

  2400.     						if ($col_sel=="ebpls_ctc_issued.php") {
    2401. 

  2401. 	    					
    2402. 

  2402.     						}
    2403. 

  2403. 							if ($col_sel=="ebpls_collection_summary.php") {
    2404. 

  2404. 	    						?>
    2405. 

  2405. 	    				<tr>
    2406. 

  2406. 	    					<?php
    2407. 

  2407. 								//where report_desc like '%business%' or report_desc like 'business%' 
    2408. 

  2408. 								
    2409. 

  2409.     		
    2410. 

  2410.   								
    2411. 

  2411. 									$result1 = mysql_query("select * from ebpls_buss_taxfeetype"); 
    2412. 

  2412.     								while ($reports1 = mysql_fetch_assoc($result1)) {
    2413. 

  2413.     									/*$getlevel = mysql_query("select * from ebpls_user_sublevel where
    2414. 

  2414. 										submenu = '$reports[0]'");
    2415. 

  2415. 					$getme = mysql_fetch_assoc($getlevel);*/
    2416. 

  2416. 					
    2417. 

  2417. 					//if ($$getme['rptvars']==1) {
    2418. 

  2418. 										$temption .= "<option value=$reports1[taxfeetype] $iselecty>$reports1[typedesc]</option>";
    2419. 

  2419. 					//}
    2420. 

  2420. 									}
    2421. 

  2421. 									print "<td width=20% align=right>
    2422. 

  2422.     							Type&nbsp</td>";
    2423. 

  2423.     							print "<td width=20% align=left>
    2424. 

  2424.     								<select name='taxtype'>";
    2425. 

  2425. 									print $temption;
    2426. 

  2426.     								print"</select></td>";
    2427. 

  2427.     							
    2428. 

  2428.     							//echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);
    2429. 

  2429.     						?>
    2430. 

  2430. 	    				</tr>
    2431. 

  2431. 	    					<?
    2432. 

  2432.     						}
    2433. 

  2433. 							if ($col_sel=="ebpls_audit_trail.php") {
    2434. 

  2434. 	    						?>
    2435. 

  2435. 	    				<tr>
    2436. 

  2436.                         <td width=40% align=right>
    2437. 

  2437.                         Owner's Last Name&nbsp;
    2438. 

  2438.                         </td>
    2439. 

  2439.                         <td width=60% align=left>&nbsp;
    2440. 

  2440.                         <input name=owner_last>
    2441. 

  2441.                         </td>
    2442. 

  2442.                         </tr>
    2443. 

  2443.                         <tr>
    2444. 

  2444.                         <td width=40% align=right>
    2445. 

  2445.                         PIN&nbsp;
    2446. 

  2446.                         </td>
    2447. 

  2447.                         <td width=60% align=left>&nbsp;
    2448. 

  2448.                         <input name=pin>
    2449. 

  2449.                         </td>
    2450. 

  2450.                         </tr>
    2451. 

  2451.                         <tr>
    2452. 

  2452.                         <td>&nbsp;</td>
    2453. 

  2453.                         </tr>
    2454. 

  2454.                         
    2455. 

  2455. 	    					<?
    2456. 

  2456.     						}
    2457. 

  2457.     						?>
    2458. 

  2458. 							<?
    2459. 

  2459.     						if ($col_sel=="ebpls_orderpayment.php" or $col_sel=="ebpls_recordpayment.php" or $col_sel=="ebpls_periodicbilling.php") {
    2460. 

  2460. 	    						?>
    2461. 

  2461. 	    				<tr>
    2462. 

  2462. 	    					<td width=20% align=right>
    2463. 

  2463.     							Owner Last Name&nbsp;:</td>
    2464. 

  2464.     							<td width=20% align=left>
    2465. 

  2465.     								<input type=text name=owner_last_name>
    2466. 

  2466.     								
    2467. 

  2467. 	    				</tr>
    2468. 

  2468. 	    				<tr>
    2469. 

  2469. 	    					<td width=20% align=right>
    2470. 

  2470.     							Owner First Name&nbsp;:</td>
    2471. 

  2471.     							<td width=20% align=left>
    2472. 

  2472.     								<input type=text name=owner_first_name>
    2473. 

  2473.     								
    2474. 

  2474. 	    				</tr>
    2475. 

  2475. 						<tr>
    2476. 

  2476. 	    					<td width=20% align=right>
    2477. 

  2477.     							Business Name &nbsp;:</td>
    2478. 

  2478.     							<td width=20% align=left>
    2479. 

  2479.     								<input type=text name=business_name>
    2480. 

  2480.     								
    2481. 

  2481. 	    				</tr>
    2482. 

  2482. 	    					<?
    2483. 

  2483.     						}
    2484. 

  2484. 							if ($col_sel=="ebpls_comparative_rpts_quart.php") {
    2485. 

  2485. 	    						?>
    2486. 

  2486. 	    				<tr>
    2487. 

  2487. 	    					<td width=20% align=right>
    2488. 

  2488.     							Quarter&nbsp;:</td>
    2489. 

  2489.     							<td width=20% align=left>
    2490. 

  2490.     								<select name="iQrt">
    2491. 

  2491. 										<option value="1">1st</option>
    2492. 

  2492. 										<option value="2">2nd</option>
    2493. 

  2493. 										<option value="3">3rd</option>
    2494. 

  2494. 										<option value="4">4th</option>
    2495. 

  2495. 									</select>
    2496. 

  2496. 								</select>
    2497. 

  2497. 	    				</tr>
    2498. 

  2498. 							<?
    2499. 

  2499.     						}
    2500. 

  2500.     						?>
    2501. 

  2501. 						<tr>
    2502. 

  2502. 							<td>&nbsp;</td>
    2503. 

  2503. 						</tr>
    2504. 

  2504. 						<tr>
    2505. 

  2505. 							<td colspan=2 align=center>
    2506. 

  2506. 							<?
    2507. 

  2507. 							if ($col_sel=='ebpls_abstractcoll.php') {
    2508. 

  2508. 							?>	
    2509. 

  2509. 								<input type=button name='buss_report' value="View Report" onClick="javascript:  AbstractColl(_FRM.col_sel.value);">
    2510. 

  2510. 								<input type=hidden name='usernm' value="<?php echo $ThUserData['username'];?>">
    2511. 

  2511. 							<?
    2512. 

  2512. 							} elseif ($col_sel=='ebpls_comparative_annual.php') {
    2513. 

  2513. 				
    2514. 

  2514. 							?>
    2515. 

  2515. 							<input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    2516. 

  2516. 								<input type=button name='buss_report' value="View Report" onClick="javascript: ComparativeAnnual(_FRM.col_sel.value);">
    2517. 

  2517. 							<?
    2518. 

  2518. 							} elseif ($col_sel=='ebpls_comparative_rpts_quart.php') {
    2519. 

  2519. 				
    2520. 

  2520. 							?>
    2521. 

  2521. 								<input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    2522. 

  2522. 								<input type=button name='buss_report' value="View Report" onClick="javascript: ComparativeQuart(_FRM.col_sel.value);">
    2523. 

  2523. 							<?
    2524. 

  2524. 							} elseif ($col_sel=='ebpls_comparative_annual_chart.php') {
    2525. 

  2525.                                                         ?>
    2526. 

  2526.                                                                 <input type=button name='buss_report' value="View Report" onClick="javascript: ComparativeAnnualChart(_FRM.col_sel.value);">
    2527. 

  2527.                                                         <?
    2528. 

  2528.                                                         } elseif ($col_sel=='ebpls_bus_taxcoll_quar.php') {
    2529. 

  2529.                                                         ?>
    2530. 

  2530.                                                                 <input type=button name='buss_report' value="View Report" onClick="javascript: BussCollQuart(_FRM.col_sel.value);">
    2531. 

  2531.                                                         <?
    2532. 

  2532.                                                         } elseif ($col_sel=='ebpls_collection_summary.php') {
    2533. 

  2533. 							?>
    2534. 

  2534. 								<input type=button name='buss_report' value='View Report' onclick="javascript: SummaryCollect(_FRM.col_sel.value);">
    2535. 

  2535. 								<input type='hidden' name='usernm' value="<? echo $ThUserData['username']; ?>">
    2536. 

  2536. 							<?
    2537. 

  2537. 							} elseif  ($col_sel=='ebpls_audit_trail.php') {
    2538. 

  2538. 							?>
    2539. 

  2539. 							<tr>
    2540. 

  2540.                         <td colspan=2 align=center>
    2541. 

  2541.                         <input type=button name='buss_report' value="View Report" onClick="javascript: AuditTrail(_FRM.col_sel.value);">
    2542. 

  2542.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    2543. 

  2543.                         </td>
    2544. 

  2544.                         </tr>
    2545. 

  2545. 						<? } elseif  ($col_sel=='ebpls_ctc_issued.php') {
    2546. 

  2546. 							?>
    2547. 

  2547. 								<tr>
    2548. 

  2548.                         <td colspan=2 align=center>
    2549. 

  2549.                         <input type=button name='buss_report' value="View Report" onClick="javascript: CTCIssueds(_FRM.col_sel.value);">
    2550. 

  2550.                         <input type=hidden name=usernm value="<?php echo $ThUserData['username']; ?>">
    2551. 

  2551.                         </td>
    2552. 

  2552.                         </tr>
    2553. 

  2553. 						<? } else {
    2554. 

  2554.                                                         ?><input type=hidden name=ownname>
    2555. 

  2555.                                                         <input type=hidden name=bussname>
    2556. 

  2556.                                                         <input type=hidden name=taxtype>
    2557. 

  2557.                                                                 <input type=button name='buss_report' value="View Report" onClick="javascript:  PM();">                                                        <?
    2558. 

  2558.                                                         }
    2559. 

  2559. 

  2560. 							?>
    2561. 

  2561. </td>						 
    2562. 

  2562. 						</tr>
    2563. 

  2563. 					<?php 
    2564. 

  2564. 					}
    2565. 

  2565. 					?>
    2566. 

  2566. 

  2567. 					</table>	
    2568. 

  2568. 					</td>
    2569. 

  2569. 		</tr>
    2570. 

  2570. 

  2571. 			
    2572. 

  2572. </table>
    2573. 

  2573. 

  2574. <br>
    2575. 

  2575. <br>
    2576. 

  2576. <?php
    2577. 

  2577. 	if ($buss_report=='View Report') {
    2578. 

  2578. 		if ($buss_name<>'') {
    2579. 

  2579. 			$type=$buss_name;
    2580. 

  2580. 		} elseif ($permit_num<>'') {
    2581. 

  2581. 			$type=$permit_num;
    2582. 

  2582. 		} elseif ($brgy<>'') {
    2583. 

  2583. 			$type=$brgy;
    2584. 

  2584. 		} elseif ($cap_inv<>'') {
    2585. 

  2585. 			$type=$cap_inv;
    2586. 

  2586. 		} elseif ($gross_inc<>'') {
    2587. 

  2587. 			$type=$gross_inc;
    2588. 

  2588. 		}
    2589. 

  2589. 	}
    2590. 

  2590. ?>
    2591. 

  2591. <script language="Javascript">
    2592. 

  2592. function xs(type,array)
    2593. 

  2593. {
    2594. 

  2594. 	var trans_id
    2595. 

  2595.         var x,y,w,h
    2596. 

  2596.         trans_id =  document._FRM.trans_id.value;
    2597. 

  2597.         // center on screen
    2598. 

  2598.         //buss_name,permit_num,brgy,ci,gi
    2599. 

  2599.         if ( cmd == 'CASH' ) {
    2600. 

  2600.                 w = 400
    2601. 

  2601.                 h = screen.height - 330
    2602. 

  2602.         } else if ( cmd == 'CHECK' ) {
    2603. 

  2603.                 w = 600
    2604. 

  2604.                 h = screen.height - 230
    2605. 

  2605.         }  else if ( cmd == 'CASHVIEW' ) {
    2606. 

  2606.                 w = 400
    2607. 

  2607.                 h = screen.height - 300
    2608. 

  2608.         }  else if ( cmd == 'CHECKVIEW' ) {
    2609. 

  2609.                 w = 600
    2610. 

  2610.                 h = screen.height - 200
    2611. 

  2611.         }  else if ( cmd == 'CHECKSTATUS' ) {
    2612. 

  2612.                 w = 600
    2613. 

  2613.                 h = screen.height - 200
    2614. 

  2614.         }
    2615. 

  2615. 

  2616. 

  2617. 

  2618. 

  2619.         x = screen.width/2 - w/2
    2620. 

  2620.         y = screen.height/2 - h/2
    2621. 

  2621.         strOption = 'scrollbars=yes,status=yes,width=' + 800 + ',height=' + 600 + ',screenX=' + x + ',screenY=' + y
    2622. 

  2622.         window.open ("ebpls_buss_permit.php, cmd, strOption");
    2623. 

  2623. 

  2624. }
    2625. 

  2625. function SysRep()
    2626. 

  2626.         {
    2627. 

  2627.         var _FRM = document._FRM;
    2628. 

  2628. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    2629. 

  2629. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    2630. 

  2630. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    2631. 

  2631. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    2632. 

  2632. 		var getDiff = (vDate2-vDate1);
    2633. 

  2633. 		var today = new Date();
    2634. 

  2634. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    2635. 

  2635. 		var datefrom = new Date();
    2636. 

  2636. 		var dateto = new Date();
    2637. 

  2637. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    2638. 

  2638. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    2639. 

  2639. 		
    2640. 

  2640. 		if (datefrom > today) {
    2641. 

  2641. 			alert("Date Range cannot exceed current date.");
    2642. 

  2642. 			_FRM.date_from.select();
    2643. 

  2643. 			return false;
    2644. 

  2644. 		}
    2645. 

  2645. 		if (dateto > today) {
    2646. 

  2646. 			alert("Date Range cannot exceed current date.");
    2647. 

  2647. 			_FRM.date_to.select();
    2648. 

  2648. 			return false;
    2649. 

  2649. 		}
    2650. 

  2650. 		if (getDiff < 0) {
    2651. 

  2651. 			alert("Invalid Date Range!!");
    2652. 

  2652. 			_FRM.date_from.select();
    2653. 

  2653. 			return false;
    2654. 

  2654. 		}
    2655. 

  2655.         winpopup = window.open('reports/ebpls_activity_log.php?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&owner_last=' + _FRM.users.value);
    2656. 

  2656. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2657. 

  2657.         return true;
    2658. 

  2658.                                                                                                  
    2659. 

  2659.                                                                                                  
    2660. 

  2660.         }
    2661. 

  2661.                                                                                                                
    2662. 

  2662. function Franlist()
    2663. 

  2663.         {
    2664. 

  2664. 		var _FRM = document._FRM;
    2665. 

  2665. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    2666. 

  2666. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    2667. 

  2667. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    2668. 

  2668. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    2669. 

  2669. 		var getDiff = (vDate2-vDate1);
    2670. 

  2670. 		var today = new Date();
    2671. 

  2671. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    2672. 

  2672. 		var datefrom = new Date();
    2673. 

  2673. 		var dateto = new Date();
    2674. 

  2674. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    2675. 

  2675. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    2676. 

  2676. 		
    2677. 

  2677. 		if (datefrom > today) {
    2678. 

  2678. 			alert("Date Range cannot exceed current date.");
    2679. 

  2679. 			_FRM.date_from.select();
    2680. 

  2680. 			return false;
    2681. 

  2681. 		}
    2682. 

  2682. 		if (dateto > today) {
    2683. 

  2683. 			alert("Date Range cannot exceed current date.");
    2684. 

  2684. 			_FRM.date_to.select();
    2685. 

  2685. 			return false;
    2686. 

  2686. 		}
    2687. 

  2687. 		if (getDiff < 0) {
    2688. 

  2688. 			alert("Invalid Date Range!!");
    2689. 

  2689. 			_FRM.date_from.select();
    2690. 

  2690. 			return false;
    2691. 

  2691. 		}
    2692. 

  2692.         winpopup = window.open('reports/ebpls_franchise_list.php?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&owner_last=' + _FRM.owner_last.value + '&brgy_name=' + _FRM.brgy_name.value + '&usernm=' + _FRM.usernm.value + '&motor_brand=' + _FRM.motor_brand.value + '&body_color=' + _FRM.body_color.value);
    2693. 

  2693. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2694. 

  2694.         return true;
    2695. 

  2695.                                                                                                  
    2696. 

  2696.                                                                                                  
    2697. 

  2697.         }
    2698. 

  2698. function FranchisePermit()
    2699. 

  2699.         {
    2700. 

  2700.         var _FRM = document._FRM;
    2701. 

  2701. 		if (_FRM.owner_last.value == "" && _FRM.permit_num.value == "") {
    2702. 

  2702. 			alert("Enter Owner Last Name or Permit Number.");
    2703. 

  2703. 			_FRM.owner_last.focus();
    2704. 

  2704. 			return false;
    2705. 

  2705. 		}
    2706. 

  2706.         winpopup = window.open('reports/ebpls_motor_permit.php?owner_last=' + _FRM.owner_last.value + '&permit_num=' + _FRM.permit_num.value + '&reportpermit=1&permit_type=Franchise');
    2707. 

  2707. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2708. 

  2708.         return true;
    2709. 

  2709.                                                                                                  
    2710. 

  2710.                                                                                                  
    2711. 

  2711.         }
    2712. 

  2712. function Motorlist()
    2713. 

  2713.         {
    2714. 

  2714.         var _FRM = document._FRM;
    2715. 

  2715. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    2716. 

  2716. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    2717. 

  2717. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    2718. 

  2718. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    2719. 

  2719. 		var getDiff = (vDate2-vDate1);
    2720. 

  2720. 		var today = new Date();
    2721. 

  2721. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    2722. 

  2722. 		var datefrom = new Date();
    2723. 

  2723. 		var dateto = new Date();
    2724. 

  2724. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    2725. 

  2725. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    2726. 

  2726. 		
    2727. 

  2727. 		if (datefrom > today) {
    2728. 

  2728. 			alert("Date Range cannot exceed current date.");
    2729. 

  2729. 			_FRM.date_from.select();
    2730. 

  2730. 			return false;
    2731. 

  2731. 		}
    2732. 

  2732. 		if (dateto > today) {
    2733. 

  2733. 			alert("Date Range cannot exceed current date.");
    2734. 

  2734. 			_FRM.date_to.select();
    2735. 

  2735. 			return false;
    2736. 

  2736. 		}
    2737. 

  2737. 		if (getDiff < 0) {
    2738. 

  2738. 			alert("Invalid Date Range!!");
    2739. 

  2739. 			_FRM.date_from.select();
    2740. 

  2740. 			return false;
    2741. 

  2741. 		}
    2742. 

  2742.         winpopup = window.open('reports/ebpls_motor_list.php?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&owner_last=' + _FRM.owner_last.value + '&brgy_name=' + _FRM.brgy_name.value + '&usernm=' + _FRM.usernm.value + '&motor_brand=' + _FRM.motor_brand.value + '&body_color=' + _FRM.body_color.value);
    2743. 

  2743. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2744. 

  2744.         return true;
    2745. 

  2745.                                                                                                  
    2746. 

  2746.                                                                                                  
    2747. 

  2747.         }
    2748. 

  2748. function MotorPermit()
    2749. 

  2749.         {
    2750. 

  2750.         var _FRM = document._FRM;
    2751. 

  2751. 		if (_FRM.owner_last.value == "" && _FRM.permit_num.value == "") {
    2752. 

  2752. 			alert("Enter Owner Last Name or Permit Number.");
    2753. 

  2753. 			_FRM.owner_last.focus();
    2754. 

  2754. 			return false;
    2755. 

  2755. 		}
    2756. 

  2756.         winpopup = window.open('reports/ebpls_motor_permit.php?owner_last=' + _FRM.owner_last.value + '&permit_num=' + _FRM.permit_num.value + '&reportpermit=1&permit_type=Motorized');
    2757. 

  2757. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2758. 

  2758.         return true;
    2759. 

  2759.                                                                                                  
    2760. 

  2760.                                                                                                  
    2761. 

  2761.         }
    2762. 

  2762. function Occulist()
    2763. 

  2763.         {
    2764. 

  2764.         var _FRM = document._FRM;
    2765. 

  2765. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    2766. 

  2766. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    2767. 

  2767. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    2768. 

  2768. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    2769. 

  2769. 		var getDiff = (vDate2-vDate1);
    2770. 

  2770. 		var today = new Date();
    2771. 

  2771. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    2772. 

  2772. 		var datefrom = new Date();
    2773. 

  2773. 		var dateto = new Date();
    2774. 

  2774. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    2775. 

  2775. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    2776. 

  2776. 		
    2777. 

  2777. 		if (datefrom > today) {
    2778. 

  2778. 			alert("Date Range cannot exceed current date.");
    2779. 

  2779. 			_FRM.date_from.select();
    2780. 

  2780. 			return false;
    2781. 

  2781. 		}
    2782. 

  2782. 		if (dateto > today) {
    2783. 

  2783. 			alert("Date Range cannot exceed current date.");
    2784. 

  2784. 			_FRM.date_to.select();
    2785. 

  2785. 			return false;
    2786. 

  2786. 		}
    2787. 

  2787. 		if (getDiff < 0) {
    2788. 

  2788. 			alert("Invalid Date Range!!");
    2789. 

  2789. 			_FRM.date_from.select();
    2790. 

  2790. 			return false;
    2791. 

  2791. 		}
    2792. 

  2792. /*		if (_FRM.agefrom.value < 0 || _FRM.agefrom.value == "" || _FRM.agefrom.value > 140 || isNaN(_FRM.agefrom.value)==true) {
    2793. 

  2793. 			alert("Invalid Start Age Range!");
    2794. 

  2794. 			_FRM.agefrom.select();
    2795. 

  2795. 			return false;
    2796. 

  2796. 		}
    2797. 

  2797. 		if (_FRM.ageto.value < 0 || _FRM.ageto.value == "" || _FRM.ageto.value > 140 || isNaN(_FRM.ageto.value)==true) {
    2798. 

  2798. 			alert("Invalid End Age Range!");
    2799. 

  2799. 			_FRM.ageto.select();
    2800. 

  2800. 			return false;
    2801. 

  2801. 		}
    2802. 

  2802. 		if (_FRM.agefrom.value > _FRM.ageto.value) {
    2803. 

  2803. 			alert("Invalid Start Age Range!");
    2804. 

  2804. 			_FRM.agefrom.select();
    2805. 

  2805. 			return false;
    2806. 

  2806. 		}*/
    2807. 

  2807.         winpopup = window.open('reports/ebpls_occupational_list.php?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&owner_last=' + _FRM.owner_last.value + '&brgy_name=' + _FRM.brgy_name.value + '&usernm=' + _FRM.usernm.value + '&employer=' + _FRM.employer.value + '&occupation=' + _FRM.occupation.value + '&sex=' + _FRM.sex.value);
    2808. 

  2808. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2809. 

  2809.         return true;
    2810. 

  2810.                                                                                                  
    2811. 

  2811.                                                                                                  
    2812. 

  2812.         }
    2813. 

  2813. function OccuPermit()
    2814. 

  2814.         {
    2815. 

  2815.         var _FRM = document._FRM;
    2816. 

  2816. 		if (_FRM.owner_last.value == "" && _FRM.permit_num.value == "") {
    2817. 

  2817. 			alert("Enter Owner Last Name or Permit Number.");
    2818. 

  2818. 			_FRM.owner_last.focus();
    2819. 

  2819. 			return false;
    2820. 

  2820. 		}
    2821. 

  2821.         winpopup = window.open('reports/ebpls_occ_permit.php?owner_last=' + _FRM.owner_last.value + '&permit_num=' + _FRM.permit_num.value + '&reportpermit=1&permit_type=Motorized');
    2822. 

  2822. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2823. 

  2823.         return true;
    2824. 

  2824.                                                                                                  
    2825. 

  2825.                                                                                                  
    2826. 

  2826.         }
    2827. 

  2827. function Fishlist()
    2828. 

  2828.         {
    2829. 

  2829.         var _FRM = document._FRM;
    2830. 

  2830. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    2831. 

  2831. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    2832. 

  2832. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    2833. 

  2833. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    2834. 

  2834. 		var getDiff = (vDate2-vDate1);
    2835. 

  2835. 		var today = new Date();
    2836. 

  2836. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    2837. 

  2837. 		var datefrom = new Date();
    2838. 

  2838. 		var dateto = new Date();
    2839. 

  2839. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    2840. 

  2840. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    2841. 

  2841. 		
    2842. 

  2842. 		if (datefrom > today) {
    2843. 

  2843. 			alert("Date Range cannot exceed current date.");
    2844. 

  2844. 			_FRM.date_from.select();
    2845. 

  2845. 			return false;
    2846. 

  2846. 		}
    2847. 

  2847. 		if (dateto > today) {
    2848. 

  2848. 			alert("Date Range cannot exceed current date.");
    2849. 

  2849. 			_FRM.date_to.select();
    2850. 

  2850. 			return false;
    2851. 

  2851. 		}
    2852. 

  2852. 		if (getDiff < 0) {
    2853. 

  2853. 			alert("Invalid Date Range!!");
    2854. 

  2854. 			_FRM.date_from.select();
    2855. 

  2855. 			return false;
    2856. 

  2856. 		}
    2857. 

  2857.         winpopup = window.open('reports/ebpls_fishery_list.php?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&brgy_name=' + _FRM.brgy_name.value + '&usernm=' + _FRM.usernm.value);
    2858. 

  2858. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2859. 

  2859.         return true;
    2860. 

  2860.                                                                                                  
    2861. 

  2861.                                                                                                  
    2862. 

  2862.         }
    2863. 

  2863. function FishPermit()
    2864. 

  2864.         {
    2865. 

  2865.         var _FRM = document._FRM;
    2866. 

  2866. 		if (_FRM.owner_last.value == "" && _FRM.permit_num.value == "") {
    2867. 

  2867. 			alert("Enter Owner Last Name or Permit Number.");
    2868. 

  2868. 			_FRM.owner_last.focus();
    2869. 

  2869. 			return false;
    2870. 

  2870. 		}
    2871. 

  2871.         winpopup = window.open('reports/ebpls_fish_permit.php?owner_last=' + _FRM.owner_last.value + '&permit_num=' + _FRM.permit_num.value + '&reportpermit=1&permit_type=Fishery');
    2872. 

  2872. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2873. 

  2873.         return true;
    2874. 

  2874.                                                                                                  
    2875. 

  2875.                                                                                                  
    2876. 

  2876.         }
    2877. 

  2877. function Peddlist()
    2878. 

  2878.         {
    2879. 

  2879.         var _FRM = document._FRM;
    2880. 

  2880. 		var vDateSplit1 = _FRM.date_from.value.split("/");
    2881. 

  2881. 		vDate1 = vDateSplit1[0] + vDateSplit1[1] + vDateSplit1[2];
    2882. 

  2882. 		var vDateSplit2 = _FRM.date_to.value.split("/");
    2883. 

  2883. 		vDate2 = vDateSplit2[0] + vDateSplit2[1] + vDateSplit2[2];
    2884. 

  2884. 		var getDiff = (vDate2-vDate1);
    2885. 

  2885. 		var today = new Date();
    2886. 

  2886. 		 today.setFullYear(<? echo $yeartoday;?>,<? echo $monthtoday - 1;?>,<? echo $daytoday;?>);
    2887. 

  2887. 		var datefrom = new Date();
    2888. 

  2888. 		var dateto = new Date();
    2889. 

  2889. 		datefrom.setFullYear(vDateSplit1[0],vDateSplit1[1]-1,vDateSplit1[2]);
    2890. 

  2890. 		dateto.setFullYear(vDateSplit2[0],vDateSplit2[1]-1,vDateSplit2[2]);
    2891. 

  2891. 		
    2892. 

  2892. 		if (datefrom > today) {
    2893. 

  2893. 			alert("Date Range cannot exceed current date.");
    2894. 

  2894. 			_FRM.date_from.select();
    2895. 

  2895. 			return false;
    2896. 

  2896. 		}
    2897. 

  2897. 		if (dateto > today) {
    2898. 

  2898. 			alert("Date Range cannot exceed current date.");
    2899. 

  2899. 			_FRM.date_to.select();
    2900. 

  2900. 			return false;
    2901. 

  2901. 		}
    2902. 

  2902. 		if (getDiff < 0) {
    2903. 

  2903. 			alert("Invalid Date Range!!");
    2904. 

  2904. 			_FRM.date_from.select();
    2905. 

  2905. 			return false;
    2906. 

  2906. 		}
    2907. 

  2907.         winpopup = window.open('reports/ebpls_peddler_list.php?date_from=' + _FRM.date_from.value + '&date_to=' + _FRM.date_to.value + '&owner_last=' + _FRM.owner_last.value + '&brgy_name=' + _FRM.brgy_name.value + '&usernm=' + _FRM.usernm.value + '&business=' + _FRM.business.value);
    2908. 

  2908. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2909. 

  2909.         return true;
    2910. 

  2910.                                                                                                  
    2911. 

  2911.                                                                                                  
    2912. 

  2912.         }
    2913. 

  2913. function PeddPermit()
    2914. 

  2914.         {
    2915. 

  2915.         var _FRM = document._FRM;
    2916. 

  2916. 		if (_FRM.owner_last.value == "" && _FRM.permit_num.value == "") {
    2917. 

  2917. 			alert("Enter Owner Last Name or Permit Number.");
    2918. 

  2918. 			_FRM.owner_last.focus();
    2919. 

  2919. 			return false;
    2920. 

  2920. 		}
    2921. 

  2921.         winpopup = window.open('reports/ebpls_peddler_permit.php?owner_last=' + _FRM.owner_last.value + '&permit_num=' + _FRM.permit_num.value + '&reportpermit=1&permit_type=Motorized');
    2922. 

  2922. //,'popup','height=500,width=800,menubar=no,scrollbars=yes,status=no,screenX=100,screenY=0,left=100,top=0');
    2923. 

  2923.         return true;
    2924. 

  2924.                                                                                                  
    2925. 

  2925.                                                                                                  
    2926. 

  2926.         }
    2927. 

  2927. 

  2928. </script>
    2929. 

  2929. <?php 
    2930. 

  2930. //echo get_select_data($dbLink,'report_list','ebpls_reports','report_id','report_desc',$owner_datarow[report_id]);
    2931. 

  2931. /*    $result = mysql_query("select report_desc from ebpls_reports order by report_desc asc") or die(mysql_error()); 
    2932. 

  2932.     $reports=mysql_fetch_row($result);
    2933. 

  2933.   
    2934. 

  2934.     echo $reports;
    2935. 

  2935.     echo get_select_data($dbLink,'report_list','ebpls_reports','report_file','report_desc',$owner_datarow[report_id]);*/
    2936. 

  2936. //	echo get_select_data($dbLink,'report_list','ebpls_reports','report_file',$result,$owner_datarow[report_id]);
    2937. 

  2937.    
    2938. 

  2938. ?></div>
    2939. 

  2939. 

  2940. <?php
    2941. 

  2941. 

  2942. 		if ($search=='Search') {
    2943. 

  2943. 

  2944.         
    2945. 

  2945. }
    2946. 

  2946. ?>
    2947. 

  2947.     
    2948. 

  2948. <?php
    2949. 

  2949. 

  2950. //require_once("includes/eBPLS_footer.php");
    2951. 

  2951. 

  2952. ?>
    2953. 

  2953. 

  2954.