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++; makeSpecialSubmitter("moreRows", "onClick='this.form.ac_count.value={$ac_count}'"); endPrettyTable(); makeSpecialSubmitter("submit", "onClick='this.form.submitnow.value=\"1\"'"); closeForm(); ?> </td> </table> <?php } endDocument();
if ($row["VR_TP"] == "CR") { die("Requested Voucher is a Credit-Voucher. Credit-Vouchers can't get deleted. Instead, make a Debit-Voucher and correct the mistake!"); } else { if (mysql_fetch_array($result, MYSQL_ASSOC)) { die("more than one Voucher found! Database-integrity is in Danger! Call your System-maintainer!"); } } } beginPrettyTable("1", "Do you want to Remove this Voucher ?"); printRow(array("AC_Codes", "VR_TP", "Vr_No", "VR_DT", "PARTY", "NARRATION", "AMOUNT"), "", "1,5"); $row["VR_DT"] = conv_to_hrd($row["VR_DT"]); printRow($row, "something"); openForm("removevoucher_confirm_form", $PHP_SELF); makeHiddenField("remove_confirm", 0); makeHiddenField("vr_no", $vr_no); makeSpecialSubmitter("yes, remove it!", "this.form.remove_confirm.value=1", 6); endPrettyTable(); mysql_close($db); } else { ?> <table cellpadding=5 cellspacing=0 border=0 width='100%'> <tr> <td valign=top width='15%'> <?php beginPrettyTable("1"); ?> <tr> <?php echo "<td><a href='not_existing.php'>bad link here</a></td>";
} $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", "this.form.submitnow.value=\"1\""); closeForm(); endPrettyTable(); } endDocument();
if ($row["VR_TP"] == "CR") { die("Requested Voucher is a Credit-Voucher. Credit-Vouchers can't get deleted. Instead, make a Debit-Voucher and correct the mistake!"); } else { if (mysql_fetch_array($result, MYSQL_ASSOC)) { die("more than one Voucher found! Database-integrity is in Danger! Call your System-maintainer!"); } } } beginPrettyTable("1", "Do you want to Remove this Voucher ?"); printRow(array("AC_Codes", "VR_TP", "Vr_No", "VR_DT", "PARTY", "NARRATION", "AMOUNT"), "", "1,5"); $row["VR_DT"] = conv_to_hrd($row["VR_DT"]); printRow($row, "fluct"); openForm("removevoucher_confirm_form", $PHP_SELF); makeHiddenField("remove_confirm", 0); makeHiddenField("vr_no", $vr_no); makeSpecialSubmitter("yes, remove it!", "onClick='this.form.remove_confirm.value=1'", 6); endPrettyTable(); mysql_close($db); } else { ?> <table cellpadding=5 cellspacing=0 border=0 width='100%'> <tr> <td valign=top width='15%'> <?php beginPrettyTable("1"); ?> <tr> <?php echo "<td><a href='not_existing.php'>bad link here</a></td>";