'3')
{
$edate=date("30-09-Y");
}
else
{
$curyr--;
$edate=date("30-09-$curyr");
}
?>
SRI ATHISAKTHI GROUPS
DEPRECIATION VIEW
";
echo "
| S.No |
Type |
Total Amt |
On 30-09-$yr |
Percentage |
Depreciation |
Year End Balance |
";
$sno=0;
$sql="SELECT SUM(amount) as tfa FROM sac.expense WHERE cmpname='$cmpname' AND type='FURNITURE EXPENSE (10%)'";
$ret = pg_query($db, $sql);
while($row = pg_fetch_assoc($ret)) {
$tfa = $row['tfa'];
$sno++;
}
$sql1="SELECT SUM(amount) as fd FROM sac.expense WHERE cmpname='$cmpname' AND type='FURNITURE EXPENSE (10%)' AND date<='$edate'";
$ret1 = pg_query($db, $sql1);
while($row1 = pg_fetch_assoc($ret1)) {
$fd = $row1['fd'];
}
$dep1=$fd/10;
$dep1=round($dep1);
$tfa=round($tfa);
$sum=$sum+$tfa;
$sum1=$sum1+$fd;
$sum2=$sum2+$dep1;
$yr1=$tfa-$dep1;
$sum3=$sum3+$yr1;
echo "| $sno | ";
echo "FURNITURE EXPENSE (10%) | ";
echo "$tfa | ";
echo "$fd | ";
echo "10% | ";
echo "$dep1 | ";
echo "$yr1 |
";
$sql="SELECT SUM(amount) as tca FROM sac.expense WHERE cmpname='$cmpname' AND type='COMPUTER PURCHASE (40%)'";
$ret = pg_query($db, $sql);
while($row = pg_fetch_assoc($ret)) {
$tca = $row['tca'];
$sno++;
}
$sql1="SELECT SUM(amount) as cd FROM sac.expense WHERE cmpname='$cmpname' AND type='COMPUTER PURCHASE (40%)' AND date<='$edate'";
$ret1 = pg_query($db, $sql1);
while($row1 = pg_fetch_assoc($ret1)) {
$cd = $row1['cd'];
}
$dep=$cd*40;
$dep=$dep/100;
$dep=round($dep);
$yr=$tca-$dep;
$tfa=round($tca);
$sum=$sum+$tca;
$sum1=$sum1+$cd;
$sum2=$sum2+$dep;
$sum3=$sum3+$yr;
echo "| $sno | ";
echo "COMPUTER PURCHASE (40%) | ";
echo "$tca | ";
echo "$cd | ";
echo "40% | ";
echo "$dep | ";
echo "$yr |
";
$sql="SELECT SUM(amount) as toffa FROM sac.expense WHERE cmpname='$cmpname' AND type='OFFICE EQUIP. PURCHASE (15%)'";
$ret = pg_query($db, $sql);
while($row = pg_fetch_assoc($ret)) {
$toffa = $row['toffa'];
$sno++;
}
$sql1="SELECT SUM(amount) as offd FROM sac.expense WHERE cmpname='$cmpname' AND type='OFFICE EQUIP. PURCHASE (15%)' AND date<='$edate'";
$ret1 = pg_query($db, $sql1);
while($row1 = pg_fetch_assoc($ret1)) {
$offd = $row1['offd'];
}
$dep2=$offd*15;
$dep2=$dep2/100;
$dep2=round($dep2);
$sum2=$sum2+$dep2;
$yr2=$toffa-$dep2;
$toffa=round($toffa);
$sum3=$sum3+$yr2;
$sum=$sum+$toffa;
$sum1=$sum1+$offd;
echo "| $sno | ";
echo "OFFICE EQUIP. PURCHASE (15%) | ";
echo "$toffa | ";
echo "$offd | ";
echo "15% | ";
echo "$dep2 | ";
echo "$yr2 |
";
echo " | ";
echo " | ";
echo "$sum.00 | ";
echo "$sum1.00 | ";
echo " | ";
echo "$sum2 | ";
echo "$sum3 |
";
echo "";
include "fetchbalance.php";
?>