<?php
# This form allows to enter a date. After submitting, all Bank and Cash Account-balances get
# printed seperated by Projects.
session_start();
require "accrp.php";
require "security/secure.php";
beginDocument("list Cash and Bank", $sess_user);
if ($date) {
$ac1 = get_ac_array(1);
foreach ($ac1 as $key => $prj_desc) {
$accounts = new BankAndCashAccounts_byProject($key, $date, "c");
beginPrettyTable(4, "{$prj_desc}");
printRow(array("Account", "Balance"));
while ($row = $accounts->getNext()) {
printRow(array($row["AC5_DESC"], $accounts->getActualBalance() . " "), "irgendwas");
}
printRow(array("Sum", $accounts->getSum()));
endPrettyTable();
}
} else {
openForm("enter Date", $PHP_SELF);
beginPrettyTable("2", "list bank and cash");
makeTextField("date", get_today_hrd_string(), "Date:");
makeSubmitter();
endPrettyTable();
closeForm();
}
endDocument();
} elseif ($vr_tp == "CR") {
$type_of_voucher = "Credit ";
$dr_cr = "D";
$ac_array = get_ac5_sc_array("5(1)", "B");
} elseif ($vr_tp == "JV") {
$type_of_voucher = "Journal ";
$dr_cr = "C";
$ac_array = get_ac5_sc_array("5(1)", "B");
} else {
die("Unknown Voucher-type: ({$vr_tp})");
}
$dept_array = get_dept_array();
if (!isset($ac_count)) {
$ac_count = 3;
}
$today = get_today_hrd_string();
?>
<table cellpadding=5 cellspacing=0 border=0 width='100%'>
<tr>
<td valign=top align=center width='65%'>
<?php
openForm("transaction", $PHP_SELF, "onSubmit='return checkBeforeSubmit()'");
beginPrettyTable("2", "enter {$type_of_voucher} Voucher");
makeHiddenField("ac_count", "{$ac_count}");
makeHiddenField("submitnow", "");
makeHiddenField("vr_tp", $vr_tp);
makePlainDropBox("ac_name", $ac_array, "Ac_Name");
makePlainStaticField("t_dt", $today, " ", 10);
startRow();
makePlainStaticField("dr_cr", $dr_cr, "DR./CR", 2);
$orderby = "EMP_ID3";
}
# calculate received money by Employees
$result = mysql_query("select SUM(AMOUNT),AC_ID5 from TRANS WHERE AC_ID3=30 AND DR_CR='C' GROUP BY AC_ID5 order by PARTY", $db);
checkMySQLError();
while ($row = mysql_fetch_array($result)) {
$receive_array[$row["AC_ID5"]] = $row["SUM(AMOUNT)"];
}
# calculate paid_back money
$result = mysql_query("select SUM(AMOUNT),PARTY, AC_ID5 from TRANS WHERE AC_ID3=30 AND DR_CR='D' GROUP BY PARTY order by PARTY", $db);
checkMySQLError();
while ($row = mysql_fetch_array($result)) {
if (array_key_exists($row["AC_ID5"], $receive_array)) {
$receive_array[$row["AC_ID5"]] -= $row["SUM(AMOUNT)"];
}
}
beginPrettyTable("1", "Schedule of Advance as on " . get_today_hrd_string());
if (isset($receive_array)) {
printRow(array("Code", "Employer's name", "Amount"));
foreach ($receive_array as $key => $value) {
if ($value != 0) {
printRow(array("{$key}", get_ac5_desc_of($key), 0 - $value), "something");
}
$sum += 0 - $value;
}
printRow(array("", "Sum", $sum));
} else {
printRow(array("No Advance-money at anybody!"), "");
}
endPrettyTable();
endDocument();
}
printRow(array("", "<b>total Receipts<b>", "<b>" . $transactions->getTotalReceipts() . "</b>"));
endPrettyTable();
# Payments
# generate Transaction-object
if ($ac_id1 != 0) {
$transactions = new Transactions($ac_id1, $startdate, $enddate);
} else {
$transactions = new Transactions_byProject("1", $startdate, $enddate);
}
beginPrettyTable("4", "Payments");
printRow(array("Code Number", "Description", "Amount", "VR-Type"));
while ($row = $transactions->getNextPayment()) {
printRow($row, "fluct");
}
printRow(array("", "<b>total Payments</b>", "<b>" . $transactions->getTotalPayments() . "</b>"));
printRow(array("", "<b>closing Balance:</b> ", "<b>" . $transactions->getClosingBalance() . "</b>"));
endPrettyTable();
} else {
$ac_array = get_ac_array(1);
$ac_array[0] = "ALL PROJECTS";
openForm("enter Date", $PHP_SELF);
beginPrettyTable("2", "Project Transactions");
makeDropBox("ac_id1", $ac_array, "Project");
makeTextField("startdate", get_today_hrd_string(), "Start Date:");
makeTextField("enddate", get_today_hrd_string(), "End Date:");
makeSubmitter();
endPrettyTable();
closeForm();
}
endDocument();
die("more than one Voucher found! Database-integrity is in Danger! Call your System-maintainer!");
}
if ($row["VR_TP"] != "CR") {
die("The given Voucher-No is not a CreditVoucher !");
}
for ($i = 0; $i < 2; $i++) {
?>
<div align="center">
<h1>Centre For The Rehabilitation Of The Paralysed (CRP)</h1>
crp-Chapain, Savar, Dhaka-1343<br>
Tel:7710464-5, Fax:7710069<br>
Email: info@crp-bangladesh.org<br>
<h2>MONEY RECEIPT</h2>
</div>
<div align="right">Date: <?php
echo get_today_hrd_string();
?>
</div>
<div align="left"> <?php
echo $row["VR_NO"];
?>
</div>
<div align="center"> Received with thanks an amount of Taka <?php
echo $row["AMOUNT"];
?>
<br>
( in words: <?php
echo get_number_wording($row["AMOUNT"]);
?>
