makePlainStaticField("vr_no", "", "Vr.No.:", 10);
makePlainTextField("vr_dt", $today, "Vr.-Date:", 10);
endRow();
makePlainTextField("party", "", $dr_cr == "C" ? "Paid To" : "Rcvd. from");
if ($vr_tp != "JV") {
makePlainTextField("chq_no", "", "Chq-No.:", 10);
}
makeTextField("remarks", "", "Narration:");
endPrettyTable();
# Start now with that second part of the story
if ($vr_tp == "DB") {
$ac_array = get_ac5_sc_array("5(1/2)", "");
} elseif ($vr_tp == "CR") {
$ac_array = get_ac5_sc_array("5(1/2)", "");
} elseif ($vr_tp == "JV") {
$ac_array = get_ac5_sc_array("5(1/2)", "");
} else {
die("Unknown Voucher-type: ({$vr_tp})");
}
beginPrettyTable("1", "I call it \"Counterbooking\"");
?>
<tr><td>AccountName</td><td>Narration</td><td>Dept</td><td>Amount</td></tr><?php
for ($i = 0; $i < $ac_count; $i++) {
startRow();
makePlainDropBox("ac_name_{$i}", $ac_array);
makePlainTextField("remarks_{$i}", "", "", 20);
makePlainDropBox("dept_{$i}", $dept_array, $edit["DEPT_ID"]);
makePlainTextField("amount_{$i}", "");
endRow();
}
$ac_count++;
}
$amount = $_POST[$field_name];
$vr_no = get_new_vrno();
# insert voucher
$query = $query_part1 . "('{$vr_no}','{$today}','CR','{$ac1}', '{$ac2}','{$ac3}','{$ac4}','{$ac5}','D','','{$amount}','','opening Balance','{$today}','')";
$result = mysql_query($query, $db);
checkMySQLError();
# insert counterbooking
$query = $query_part1 . "('{$vr_no}','{$today}','CR','0', '5','0','0','0','C','','{$amount}','','opening Balance','{$today}','')";
$result = mysql_query($query, $db);
checkMySQLError();
}
report(1, "Everything seems to be fine. Check via Bank and Cash Report!");
} else {
$db = getDBConnection();
$result = mysql_query("Select * FROM TRANS");
if (mysql_num_rows($result) != 0) {
report(0, "Sorry, opening balance can only be performed when you have no Vouchers entered");
}
$accounts_array = get_ac5_sc_array("5(1)", "B");
beginPrettyTable("2", "enter opening balances");
openForm("openingbalance", $PHP_SELF);
makeHiddenField("submitnow", 0);
foreach ($accounts_array as $ac5 => $desc) {
makeTextField("account_field_" . $ac5, "", $desc);
}
makeSpecialSubmitter("submit", "onClick='this.form.submitnow.value=\"1\"'");
closeForm();
endPrettyTable();
}
endDocument();
