PageRenderTime 31ms CodeModel.GetById 1ms RepoModel.GetById 0ms app.codeStats 0ms

/reports/ebpls_buslist_mainbusact.php

http://ebpls.googlecode.com/
PHP | 126 lines | 93 code | 24 blank | 9 comment | 1 complexity | bb850c38360d1f30c01716cc23863204 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.                                                                                                                                                                                                                                      

    7. 

  7. //--- get connection from DB

    8. 

  8. $dbLink = get_db_connection();

    9. 

  9. ?>

    10. 

  10. 

    11. 

  11. <?php

    12. 

  12. echo date("F dS Y h:i:s A");

    13. 

  13. ?>

    14. 

  14. 

    15. 

  15. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

    16. 

  16. <html>

    17. 

  17. <head>

    18. 

  18.   <meta http-equiv="Content-Type"

    19. 

  19.  content="text/html; charset=iso-8859-1">

    20. 

  20.   <title>MASTERLIST OF BUSINESS ESTABLISHMENT BY MAIN BUSINESS ACTIVITY</title>

    21. 

  21.   <meta name="Author" content=" Pagoda, Ltd. ">

    22. 

  22.   <link href="includes/eBPLS.css" rel="stylesheet" type="text/css">

    23. 

  23.   <script language="JavaScript" src="includes/eBPLS.js"></script>

    24. 

  24. </head>

    25. 

  25. <body>

    26. 

  26. 

    27. 

  27. <?php

    28. 

  28. 

    29. 

  29. 					$result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());

    30. 

  30.           $resulta=mysql_fetch_row($result);

    31. 

  31. 

    32. 

  32. ?>

    33. 

  33. 

    34. 

  34. <h4 align="center"> Republic of the Philippines </h4>

    35. 

  35. <h4 align="center"> <?php echo $resulta[1]; ?> </h4>

    36. 

  36. <h4 align="center"> <?php echo $resulta[0]; ?> </h4>

    37. 

  37. <h4 align="center"> <?php echo $resulta[2]; ?> </h4>

    38. 

  38. <h4 align="center"> MASTERLIST OF BUSINESS ESTABLISHMENT BY MAIN BUSINESS ACTIVITY </h4>

    39. 

  39. 

    40. 

  40. <hr>

    41. 

  41. 

    42. 

  42. <table border="0" cellpadding="1" cellspacing="1" width="1100">

    43. 

  43.   <tbody>

    44. 

  44.     <tr>

    45. 

  45.       <td>

    46. 

  46.       <table border="1" cellpadding="1" cellspacing="1" width="1000">

    47. 

  47.         <tbody>

    48. 

  48.           <tr>

    49. 

  49.             <td align="center" width="100"><b> Permit No. </b></td>

    50. 

  50.             <td align="center" width="100"><b> Name of Owner </b></td>

    51. 

  51.             <td align="center" width="100"><b> Business Name </b></td>

    52. 

  52.             <td align="center" width="100"><b> Type of Ownership </b></td>

    53. 

  53.             <td align="center" width="100"><b> Business Address </b></td>

    54. 

  54.             <td align="center" width="100"><b> Capital Investment </b></td>

    55. 

  55.             <td align="center" width="100"><b> Gross Sales </b></td>

    56. 

  56.             <td align="center" width="100"><b> Amount Paid </b></td>

    57. 

  57.             <td align="center" width="100"><b> O.R. No. </b></td>

    58. 

  58.             <td align="center" width="100"><b> Date of Payment </b></td>

    59. 

  59.             <td align="center" width="100"><b> Remarks </b></td>

    60. 

  60.           </tr>

    61. 

  61.           

    62. 

  62.         <?php

    63. 

  63. 				

    64. 

  64.         	// unang gawang tama

    65. 

  65. 	        $result=mysql_query("select ' ', ' ', business_name, ' ', business_street, '0.00', '0.00', '0.00', ' ', ' ', ' '

    66. 

  66. 	        from ebpls_business_enterprise") or die(mysql_error());

    67. 

  67.           while ($resulta=mysql_fetch_row($result)){ 

    68. 

  68. 	          

    69. 

  69. 	        /* sample/test ko lng

    70. 

  70. 	        $result=mysql_query("select a.owner_id, a.business_name, a.business_city_code, a.business_type_code, 

    71. 

  71.           a.business_street, a.business_capital_investment, a.business_last_yrs_dec_gross_sales, b.fee_amount,

    72. 

  72.           b.input_date from ebpls_business_enterprise a, ebpls_fees_paid b where a.owner_id = b.owner_id and 

    73. 

  73.           a.business_create_ts = '2004-12-28'") or die(mysql_error());

    74. 

  74.           while ($resulta=mysql_fetch_row($result)){  */

    75. 

  75. 	          

    76. 

  76. 					print "<tr>\n";

    77. 

  77. 					foreach ($resulta as $field )

    78. 

  78. 					print "<td>&nbsp;$field&nbsp</td>\n";

    79. 

  79. 					print "</tr>";

    80. 

  80. 				}

    81. 

  81. 				?>

    82. 

  82.              

    83. 

  83.           </tr>

    84. 

  84.         </tbody>

    85. 

  85.       </table>

    86. 

  86. 

    87. 

  87. <br>

    88. 

  88. <br>

    89. 

  89. <br>

    90. 

  90. <br>

    91. 

  91. 

    92. 

  92. <?php

    93. 

  93. 

    94. 

  94. 	$result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error());

    95. 

  95.     $resulta=mysql_fetch_row($result);

    96. 

  96. 

    97. 

  97. ?>

    98. 

  98. 

    99. 

  99. <table style="width: 1000px" border="0" cellpadding="1" cellspacing="1">

    100. 

  100. 	<tbody>

    101. 

  101. 		<tr>

    102. 

  102.     	<td align="left", width="500"><b> Approved By: <br> <br> <br> <br> <br> </b></td>

    103. 

  103.     	<td align="left", width="500"><b> Noted By: <br> <br> <br> <br> <br> </b></td>

    104. 

  104.     </tr>

    105. 

  105.     <tr>

    106. 

  106.     	<td	align="center"><u><b> <?php echo $resulta[0]; ?> </u> </b> </td>

    107. 

  107.     	<td align="center"> <u><b> <?php echo $resulta[3]; ?> </u> </b> </td>

    108. 

  108.     </tr>

    109. 

  109.     <tr>

    110. 

  110.     	<td align="center"> <?php echo $resulta[2]; ?> <br> <br> <br> <br> <br> <br> <br> <br> </td>

    111. 

  111.     	<td align="center"> <?php echo $resulta[7]; ?> <br> <br> <br> <br> <br> <br> <br> <br> </td>

    112. 

  112.     </tr>

    113. 

  113.     <tr> 

    114. 

  114.     	<td align="left"> Date printed: &nbsp; &nbsp; <?php echo date("F d Y"); ?> </td>

    115. 

  115.    </tbody>

    116. 

  116. </table>

    117. 

  117. 

    118. 

  118. <?php

    119. 

  119. 

    120. 

  120. require_once("includes/eBPLS_footer.php");

    121. 

  121. 

    122. 

  122. ?>

    123. 

  123. 

    124. 

  124. </body>

    125. 

  125. </html>

    126. 

  126. 

    127. 

  127.