 |
red1.org
Nihili est - in vita priore ego imperator romanus fui
|
| View previous topic :: View next topic |
| Author |
Message |
red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
 Posted: Thu Sep 08, 2005 7:23 pm Post subject: Little Enhancements by RED1 |
 |
|
In the x.html - Databases MetaData i have modified mecca.util.DbMetaDataModule to countRecs when u selected a table, so that u will know whether there are any or new recs without selecting cols and clicking ViewData.
The words "[table] has [noRecs] record(s)" will appear (list_columns.vm)
I have also added radio button besides the checkbox to allow OrderBy Descending, to get quickly to your latest data, rather than scrolling to the bottom all the time. Also Desc will avoid the blanks that always keep to the top. Now when u select Limit to 10 and check the Sort Desc its more useful. |
|
| Back to top |
|
 |
sbahrin
Regular
Joined: 17 Dec 2004
Posts: 81
Location: Malaysia
|
| Posted: Fri Sep 09, 2005 2:05 am Post subject: |
|
|
Yes.. i've seen the modification and they are good. Your little addition to the codes is most appreciated.
Thanks.. |
|
| Back to top |
|
|
red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
| Posted: Fri Sep 09, 2005 9:24 am Post subject: |
|
|
I am touching thruout. Such as the Get List.. to make it much easier for user to just use keyboard... we make the Get key accessible by just two <tabs> and <space>. Then going down the list is just single <tab>s.
I will do in new action scripts, so not to disturb Main Mecca. We call this Action Mecca. All screens will be duplicated to new. But there will be calls to main java components, where i may make more public methods and new args i will do as new methods.
I want to solve all the gets, intake display and remove centre_ids for cybernetics use this weekend. So for example, i will copy "vtl/sis/student_info.vm" to a new copy under action path.
Gan must identify for me also which windows need the above treatment. The modules will be tested in the y.html (x.html is Sam punya, as i agree with now that he need to fork off /x/ for his CUCM project as its safer).
I arranged the y.html file according to Khairin's settings (http://www.red1.org/barn/Cybernetics/y.html). For the bursary module, we need to establish more on the composite view part. - Gan |
|
| Back to top |
|
|
red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
| Posted: Sun Sep 18, 2005 9:37 am Post subject: |
|
|
The latest on the Payment Module:
http://red1.org/repository/Receipt.pdf
1. Please adjust:-
paper size to: 618pt x 397pt
Left & Right Margins to: 31pt
Top Margin: 17pt
2. Maintain consistency in labelling. If English then all English; If BM then all BM.
3. Replace program_code with program_abbrev.
1.Gan, pls provide in mm
Paper size to: 218mm x 140mm
Left & Right Margins to: 11mm
Top Margin: 6mm
Done. Adjustment also made to support payment for max 5 invoice lines
2.Done, easily in my IReports. How bout your IReports?
Downloaded, trying it.
3.Cant find prog_abrev field in Table>Student_Course where code is.
Look into Program Table, program_abbr field |
|
| Back to top |
|
|
red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
|
| Back to top |
|
|
red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
| Posted: Thu Oct 06, 2005 5:35 pm Post subject: |
|
|
We have incorporated IReports to do the painting of the Printouts. we download and import into Eclipse. the main class to run is it.businesslogic.ireport.gui.MainFrame.
We also upgraded JasperReports1.0.1.jar .. and amended some codes to use that.
For the ShowReceipts() which launched the receipt to print we amended WEB-INF.web.xml to forked from Sam's receipt: | Code: | <servlet-name>BillingPdfServlet</servlet-name>
<servlet-class>mecca.servlets.ReceiptsServlet</servlet-class> |
|
|
| Back to top |
|
|
red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
| Posted: Sat Oct 22, 2005 5:41 pm Post subject: |
|
|
Further things i like to do :
1) Copy function for FeeStructure, so that another Intake_Code can duplicate another Intake Session Fee Structure.
Needed Tasks:
1) CSV Export of Report Info required in various screens. Will copy from mecca.sis.registration.ReportModule
2) Billing.ReportModule - Aging Analysis to have radio button selection for choosing one of these: >0 >30 >60 >120days DONE! - red1 |
|
| Back to top |
|
|
red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
| Posted: Mon Oct 24, 2005 9:41 am Post subject: |
|
|
Overpaying in Payment Module done by
replacing totpaying with amount_payment | Code: | | Vector receiptList = ReceiptData.createReceiptList(context, receipt_no, amount_payment, paymentList, student_id); |
in RECEIPTDATA.java at end of receipt detail creation, a balance (total paid - total invoice) will result in an extra detal line:
| Code: | //red1 TODO overpaid amt results in extra receiptline "OVERPAYING AMOUNT"
if (negative_balance > 0)
{
Db db = null;
String sql = "";
try
{
db = new Db();
Statement stmt = db.getStatement();
SQLRenderer r = new SQLRenderer();
r.clear();
r.add("student_id", student_id);
r.add("receipt_no", receipt_no);
r.add("s_invoice_id", invoiceNo);
r.add("fee_id", "overpay");
r.add("amount", negative_balance);
sql = r.getSQLInsert("student_receipt_detail");
//System.out.println(sql);
stmt.executeUpdate(sql);
} finally
{
if ( db != null ) db.close();
}
} |
U must create a new record in fee_structure_program where fee_id = 'overpay' and description = 'OVERPAY - TO REFUND'
At the moment the receipt printout doesnt show even toh the receiptdetails has it (culd be the print servlet, but let the client confirm how they want to print overpay detail)
IN the REFUND LIST, as there may be extra receipts paid during a single invoice the SQL logic misses the overpayment, (temporary solved by removing sum(receipt.total_amt from BillingData.getRefundableList) and now overpayments are shown.
I also made up the REFUND LIST to show features such as Print and Process (TODO later) |
|
| Back to top |
|
|
red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
| Posted: Thu Jan 05, 2006 9:17 pm Post subject: |
|
|
WE can now copy the Fee Structure from one Intake to another Intake. Changes are done to FeeStructureModule.java and fee_structure.vm:
| Code: | else if ( "copyFeeStructure".equals(submit ))
{
Vector v = new Vector();
String intakeCopy = getParam("intakeCopy");
String intake_code = (String)context.get("intake_code");
Db db = null;
db = null;
String sql = "";
try {
// red1 go thru student table
db = new Db();
Statement stmt = db.getStatement();
SQLRenderer r = new SQLRenderer();
r.add("fee_amount");
r.add("fee_id");
r.add("fee_code");
r.add("fee_description");
r.add("period_id");
r.add("period_scheme");
r.add("priority");
r.add("program_code",program_code);
r.add("intake_code", intake_code);
sql = r.getSQLSelect("fee_structure_program");
ResultSet rs = stmt.executeQuery(sql);
while (rs.next())
{
Hashtable h = new Hashtable();
h.put("fee_amount",Db.getString(rs,"fee_amount"));
h.put("fee_id",Db.getString(rs,"fee_id"));
h.put("fee_code",Db.getString(rs,"fee_code"));
h.put("fee_description",Db.getString(rs,"fee_description"));
h.put("period_id",Db.getString(rs,"period_id"));
h.put("period_scheme",Db.getString(rs,"period_scheme"));
h.put("priority",Db.getString(rs,"priority"));
h.put("program_code",program_code);
// h.put("intake_code",Db.getString(rs,"intake_code"));
v.addElement(h);
}
{
r.clear();
r.add("intake_code",intakeCopy);
r.add("program_code",program_code);
sql = r.getSQLDelete("fee_structure_program");
stmt.execute(sql);
}
for ( int i=0; i < v.size(); i++ ) {
Hashtable line = (Hashtable) v.elementAt(i);
r.clear();
r.add("fee_amount",line.get("fee_amount"));
r.add("fee_id",line.get("fee_id"));
r.add("fee_code",line.get("fee_code"));
r.add("fee_description",line.get("fee_description"));
r.add("period_id",line.get("period_id"));
r.add("period_scheme",line.get("period_scheme"));
r.add("priority",line.get("priority"));
r.add("program_code",line.get("program_code"));
r.add("student_id",line.get("student_id"));
r.add("intake_code",intakeCopy);
sql = r.getSQLInsert("fee_structure_program");
stmt.execute(sql);
}
} finally {
if ( db != null ) db.close();
}
prepare(session);
} |
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
