PageRenderTime 52ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 0ms

/Extra/OLD_SearchMonthlyReport.php

https://github.com/imayamraju/PayRoll
PHP | 328 lines | 266 code | 61 blank | 1 comment | 39 complexity | 16e177d313b949ee49e92ce235365e4d MD5 | raw file
  1. <html>
  2. <head>
  3. <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
  4. <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
  5. <meta name="ProgId" content="FrontPage.Editor.Document">
  6. <title>Pay Roll</title>
  7. <link rel="stylesheet" type="text/css" href="css/global.css">
  8. </head>
  9. <script>
  10. </script>
  11. <BODY>
  12. <form name = 'frmRecEntry'>
  13. <DIV ID = 'list'>
  14. <table border="0" width="1200" cellspacing="1" cellpadding="4" align = 'center'>
  15. <tr class=header>
  16. <td width="120" valign="middle" bgcolor="#C0C0C0">
  17. <p align="center">Emp Name</p>
  18. </td>
  19. <td width="200" bgcolor="#C0C0C0" valign="middle">
  20. <p align="center">DOJ</p>
  21. </td>
  22. <td width="50" bgcolor="#C0C0C0" valign="middle">
  23. <p align="center">Inc. Amt</p>
  24. </td>
  25. <td width="200" bgcolor="#C0C0C0" valign="middle">
  26. <p align="center">DOI</p>
  27. </td>
  28. <td width="60" bgcolor="#C0C0C0" valign="middle">
  29. <p align="center">Total Days</p>
  30. </td>
  31. <td width="60" bgcolor="#C0C0C0" valign="middle">
  32. <p align="center">Days present</p>
  33. </td>
  34. <td width="100" bgcolor="#C0C0C0" valign="middle">
  35. <p align="center">Basic</p>
  36. </td>
  37. <td width="100" bgcolor="#C0C0C0" valign="middle">
  38. <p align="center">DA</p>
  39. </td>
  40. <td width="100" bgcolor="#C0C0C0" valign="middle">
  41. <p align="center">HRA</p>
  42. </td>
  43. <td width="100" bgcolor="#C0C0C0" valign="middle">
  44. <p align="center">CCA</p>
  45. </td>
  46. <td width="100" bgcolor="#C0C0C0" valign="middle">
  47. <p align="center">Total Gross</p>
  48. </td>
  49. <td width="100" bgcolor="#C0C0C0" valign="middle">
  50. <p align="center">Earned Salary</p>
  51. </td>
  52. <td width='80' bgcolor='#C0C0C0' valign='middle'>
  53. <p align='center'>PF</p>
  54. </td>
  55. <td width="100" bgcolor="#C0C0C0" valign="middle">
  56. <p align="center">IT</p>
  57. </td>
  58. <td width="100" bgcolor="#C0C0C0" valign="middle">
  59. <p align="center">Others</p>
  60. </td>
  61. <td width="100" bgcolor="#C0C0C0" valign="middle">
  62. <p align="center">Pro.Tax</p>
  63. </td>
  64. <td width='80' bgcolor='#C0C0C0' valign='middle'>
  65. <p align='center'>ESI</p>
  66. </td>
  67. <td width="100" bgcolor="#C0C0C0" valign="middle">
  68. <p align="center">Adv.</p>
  69. </td>
  70. <td width="100" bgcolor="#C0C0C0" valign="middle">
  71. <p align="center">Net Salary</p>
  72. </td>
  73. <td width="100" bgcolor="#C0C0C0" valign="middle">
  74. <p align="center">A/C No.</p>
  75. </td>
  76. </tr>
  77. <?php
  78. include 'ServerDetail.php';
  79. session_start();
  80. $Company = $_SESSION['company'];
  81. $cMon = $_GET['cMon'];
  82. $cYer = $_GET['cYer'];
  83. $socket = mysql_connect('localhost', $user, $pass);
  84. if (! $socket)
  85. die ("Could not connect to MySql Server");
  86. mysql_select_db($db, $socket)
  87. or die ("Could not connect to database: $db".mysql_error() );
  88. //$DOI_Query = "select `MONTH`,`YEAR` from incrementdetails ";
  89. $query = "select * from department where COMPANY = '".$Company."'";
  90. $dept_result = mysql_query($query);
  91. while ($row = mysql_fetch_array($dept_result))
  92. {
  93. echo("<tr class = header>");
  94. if($Company == "A")echo("<td width='44' colspan = 20 bgcolor='#C0C0C0' align = 'center' valign='middle'>$row[0]</td>");
  95. echo("</tr>");
  96. if($Company == "A")
  97. {
  98. $query = "select e.DATE_OF_JOINING,i.AMOUNT,p.NAME,p.WORKING_DAYS,p.PRESENT_DAYS,p.BASIC,p.DA,p.HRA,p.CCA,p.GROSS_SALARY,p.EARNED_SALARY,p.PRO_TAX,p.PF,p.IT,p.OTHERS,p.ESI,p.ADVANCE,p.NET_SAL,e.ACNO,i.MONTH,i.YEAR from employee e,incrementdetails i, paydetails p where e.DEPT = '$row[0]' AND p.MONTH = '$cMon' AND p.YEAR = '$cYer' AND e.EMP_NO = p.EMP_NO AND e.EMP_NO = i.EMP_NO AND p.COMPANY = '$Company'";
  99. }
  100. else
  101. {
  102. $query = "select e.DATE_OF_JOINING,i.AMOUNT,p.NAME,p.WORKING_DAYS,p.PRESENT_DAYS,p.BASIC,p.DA,p.HRA,p.CCA,p.GROSS_SALARY,p.EARNED_SALARY,p.PRO_TAX,p.PF,p.IT,p.OTHERS,p.ESI,p.ADVANCE,p.NET_SAL,e.ACNO,i.MONTH,i.YEAR from employee e,incrementdetails i, paydetails p where p.MONTH = '$cMon' AND p.YEAR = '$cYer' AND e.EMP_NO = p.EMP_NO AND e.EMP_NO = i.EMP_NO AND p.COMPANY = '$Company'";
  103. }
  104. $result = mysql_query($query);
  105. if(!$result)
  106. die("No records");
  107. while ($rows = mysql_fetch_array($result))
  108. {
  109. $subyear = substr($rows[20], -2);
  110. $MonName = str_pad($rows[19] +1, 2, "0", STR_PAD_LEFT);
  111. echo("<tr class = bodytext>");
  112. echo("<td width='120' bgcolor='#C0C0C0' >$rows[2]</td>");
  113. echo("<td width='65' bgcolor='#C0C0C0' >$rows[0]</td>");
  114. if($rows[1] == 0)
  115. echo("<td width='44' bgcolor='#C0C0C0' >NIL</td>");
  116. else
  117. echo("<td width='44' bgcolor='#C0C0C0' >$rows[1]</td>");
  118. if($rows[20] == 0)
  119. echo("<td width='65' bgcolor='#C0C0C0' >NIL</td>");
  120. else
  121. echo("<td width='65' bgcolor='#C0C0C0' >01-${MonName}-${subyear}</td>");
  122. echo("<td width='44' bgcolor='#C0C0C0' >$rows[3]</td>");
  123. echo("<td width='44' bgcolor='#C0C0C0' >$rows[4]</td>");
  124. echo("<td width='44' bgcolor='#C0C0C0' >$rows[5]</td>");
  125. echo("<td width='44' bgcolor='#C0C0C0' >$rows[6]</td>");
  126. echo("<td width='44' bgcolor='#C0C0C0' >$rows[7]</td>");
  127. echo("<td width='44' bgcolor='#C0C0C0' >$rows[8]</td>");
  128. echo("<td width='44' bgcolor='#C0C0C0' >$rows[9]</td>");
  129. echo("<td width='44' bgcolor='#C0C0C0' >$rows[10]</td>");
  130. echo("<td width='44' bgcolor='#C0C0C0' >$rows[12]</td>");
  131. echo("<td width='44' bgcolor='#C0C0C0' >$rows[13]</td>");
  132. echo("<td width='44' bgcolor='#C0C0C0' >$rows[14]</td>");
  133. echo("<td width='44' bgcolor='#C0C0C0' >$rows[11]</td>");
  134. echo("<td width='44' bgcolor='#C0C0C0' >$rows[15]</td>");
  135. echo("<td width='44' bgcolor='#C0C0C0' >$rows[16]</td>");
  136. echo("<td width='44' bgcolor='#C0C0C0' >$rows[17]</td>");
  137. echo("<td width='44' bgcolor='#C0C0C0' >$rows[18]</td>");
  138. echo("</tr>");
  139. }
  140. mysql_free_result($result);
  141. if($Company == "A")
  142. {
  143. $query = "select sum(p.BASIC),sum(p.DA),sum(p.GROSS_SALARY),sum(p.EARNED_SALARY),sum(p.PF),sum(p.IT),sum(p.PRO_TAX),sum(p.ESI),sum(p.NET_SAL) from employee e, paydetails p where e.DEPT = '$row[0]' AND p.MONTH = '$cMon' AND p.YEAR = '$cYer' AND e.EMP_NO = p.EMP_NO AND p.COMPANY = '$Company'";
  144. }
  145. else
  146. {
  147. $query = "select sum(p.BASIC),sum(p.DA),sum(p.GROSS_SALARY),sum(p.EARNED_SALARY),sum(p.PF),sum(p.IT),sum(p.PRO_TAX),sum(p.ESI),sum(p.NET_SAL) from employee e, paydetails p where p.MONTH = '$cMon' AND p.YEAR = '$cYer' AND e.EMP_NO = p.EMP_NO AND p.COMPANY = '$Company'";
  148. }
  149. $result = mysql_query($query);
  150. while ($rows = mysql_fetch_array($result))
  151. {
  152. echo("<tr class = header>");
  153. echo("<td width='44' bgcolor='#C0C0C0' colspan = 6 valign='middle'>Total</td>");
  154. if($rows[0] == "") $rows[0] = 0;
  155. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[0]</td>");
  156. if($rows[1] == "") $rows[1] = 0;
  157. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[1]</td>");
  158. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  159. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  160. if($rows[2] == "") $rows[2] = 0;
  161. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[2]</td>");
  162. if($rows[3] == "") $rows[3] = 0;
  163. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[3]</td>");
  164. if($rows[4] == "") $rows[4] = 0;
  165. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[4]</td>");
  166. if($rows[5] == "") $rows[5] = 0;
  167. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[5]</td>");
  168. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  169. if($rows[6] == "") $rows[6] = 0;
  170. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[6]</td>");
  171. if($rows[7] == "") $rows[7] = 0;
  172. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[7]</td>");
  173. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  174. if($rows[8] == "") $rows[8] = 0;
  175. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[8]</td>");
  176. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  177. echo("</tr>");
  178. }
  179. mysql_free_result($result);
  180. if($Company == "M") break;
  181. }
  182. if($Company == "A")
  183. {
  184. $query = "select sum(p.BASIC),sum(p.DA),sum(p.GROSS_SALARY),sum(p.EARNED_SALARY),sum(p.PF),sum(p.IT),sum(p.PRO_TAX),sum(p.ESI),sum(p.NET_SAL) from employee e, paydetails p where p.MONTH = '$cMon' AND p.YEAR = '$cYer' AND e.EMP_NO = p.EMP_NO AND p.COMPANY = '$Company'";
  185. $result = mysql_query($query);
  186. $rows = mysql_fetch_array($result);
  187. echo("<tr class = header>");
  188. echo("<td width='44' bgcolor='#C0C0C0' colspan = 6 valign='middle'>Total</td>");
  189. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[0]</td>");
  190. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[1]</td>");
  191. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  192. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  193. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[2]</td>");
  194. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[3]</td>");
  195. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[4]</td>");
  196. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[5]</td>");
  197. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  198. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[6]</td>");
  199. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[7]</td>");
  200. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  201. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>$rows[8]</td>");
  202. echo("<td width='44' bgcolor='#C0C0C0' valign='middle'>&nbsp;</td>");
  203. echo("</tr>");
  204. }
  205. mysql_free_result($dept_result);
  206. mysql_close($socket);
  207. ?>
  208. </table>
  209. <BR><BR><BR>
  210. <?php
  211. if($Company == "A")
  212. {
  213. ?>
  214. <table border="0" width="1020" cellspacing="0" cellpadding="4" align = 'Center'>
  215. <tr>
  216. <td align = 'left' valign = 'top' width = 520>
  217. <table border="1" width="300" cellspacing="0" cellpadding="4" align = 'right'>
  218. <?php
  219. $Total12 = ceil($rows[0] + $rows[1]);
  220. $Total367 = ceil((($rows[0] + $rows[1]) * 0.0367));
  221. $Total833 = ceil((($rows[0] + $rows[1]) * 0.0833));
  222. $Total110 = ceil((($rows[0] + $rows[1]) * 0.0110));
  223. $Total050 = ceil((($rows[0] + $rows[1]) * 0.0050));
  224. $Total001 = ceil((($rows[0] + $rows[1]) * 0.0001));
  225. $Total = $Total12 + $Total367 + $Total833 +$Total110 + $Total050 + $Total001;
  226. echo("<tr class=header>");
  227. echo("<td valign='middle' bgcolor='#C0C0C0'>PF A/C No.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;12%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;Rs.$Total12</td>");
  228. echo("</tr>");
  229. echo("<tr class=header>");
  230. echo("<td valign='middle' bgcolor='#C0C0C0'>PF A/C No.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;3.67%&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;Rs.$Total367</td>");
  231. echo("</tr>");
  232. echo("<tr class=header>");
  233. echo("<td valign='middle' bgcolor='#C0C0C0'>PF A/C No.10&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;8.33%&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;Rs.$Total833</td>");
  234. echo("</tr>");
  235. echo("<tr class=header>");
  236. echo("<td valign='middle' bgcolor='#C0C0C0'>PF A/C No.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;1.10%&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;Rs.$Total110</td>");
  237. echo("</tr>");
  238. echo("<tr class=header>");
  239. echo("<td valign='middle' bgcolor='#C0C0C0'>PF A/C No.21&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;0.50%&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;Rs.$Total050</td>");
  240. echo("</tr>");
  241. echo("<tr class=header>");
  242. echo("<td valign='middle' bgcolor='#C0C0C0'>PF A/C No.22&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;0.01%&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;Rs.$Total001</td>");
  243. echo("</tr>");
  244. echo("<tr class=header>");
  245. echo("<td valign='middle' bgcolor='#C0C0C0'>Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;&nbsp;Rs.$Total</td>");
  246. echo("</tr>");
  247. echo "</table></td>";
  248. echo "<td align = 'Right' valign = 'top'><table border='1' width='300' cellspacing='0' cellpadding='4' align = 'left'>";
  249. $ESI = ceil((($rows[7] / 1.75) * 4.75));
  250. echo("<tr class=header>");
  251. echo("<td valign='middle' bgcolor='#C0C0C0'>ESI Employee's Contribution = Rs.$rows[7]</td>");
  252. echo("</tr>");
  253. echo("<tr class=header>");
  254. echo("<td valign='middle' bgcolor='#C0C0C0'>ESI Employer's Contribution = Rs.$ESI</td>");
  255. echo("</tr>");
  256. ?>
  257. </table>
  258. </td>
  259. </tr>
  260. </table>
  261. <?php
  262. }
  263. ?>
  264. </DIV>
  265. </FORM>
  266. </BODY>
  267. </HTML>