RR Ad Click Software ER Diagrams
ER diagrams Mobile Apps codes Add Clicks
Saturday, September 14, 2019
Friday, September 13, 2019
Tuesday, September 10, 2013
Java Reporting - ITEXT (sample code segment)
Reporting in Java - Itext
Document document = new Document();
PdfWriter.getInstance(document, new FileOutputStream("C:\\Users\\Rivi Rajapakse\\Desktop\\Report" + empid + ".pdf"));
document.open();
document.add(new Paragraph("-----------------------------------Thamali Super--------------------------------", FontFactory.getFont(FontFactory.TIMES_BOLD, 18, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph(new Date().toString()));
document.add(new Paragraph("----------------------------------------------------------------------------------------------------------------------------------"));
document.add(new Paragraph("Salary Sheet of Employee NO : " + empid));
document.add(new Paragraph(" Month of "+ month+", Year " + year ));
document.add(new Paragraph("_________________________________________", FontFactory.getFont(FontFactory.TIMES_BOLD, 18, Font.BOLD, BaseColor.WHITE)));
document.add(new Paragraph("Employee No : " + empid, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("Employee Name : " + empName, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("Basic Salary : " + bSal, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("Bonus : " + bonus, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("_________________________________________", FontFactory.getFont(FontFactory.TIMES_BOLD, 18, Font.BOLD, BaseColor.WHITE)));
document.add(new Paragraph("Total Salary : Rs " + tot, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("_________________________________________", FontFactory.getFont(FontFactory.TIMES_BOLD, 18, Font.BOLD, BaseColor.WHITE)));
document.add(new Paragraph("------------------------------------------------Thank you--------------------------------------------------", FontFactory.getFont(FontFactory.TIMES_BOLD, 14, Font.BOLD, BaseColor.BLACK)));
document.close();
Desktop desktop = Desktop.getDesktop();
File file = new File("C:\\Users\\Rivi Rajapakse\\Desktop\\Report" + empid + ".pdf");
desktop.open(file);
Document document = new Document();
PdfWriter.getInstance(document, new FileOutputStream("C:\\Users\\Rivi Rajapakse\\Desktop\\Report" + empid + ".pdf"));
document.open();
document.add(new Paragraph("-----------------------------------Thamali Super--------------------------------", FontFactory.getFont(FontFactory.TIMES_BOLD, 18, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph(new Date().toString()));
document.add(new Paragraph("----------------------------------------------------------------------------------------------------------------------------------"));
document.add(new Paragraph("Salary Sheet of Employee NO : " + empid));
document.add(new Paragraph(" Month of "+ month+", Year " + year ));
document.add(new Paragraph("_________________________________________", FontFactory.getFont(FontFactory.TIMES_BOLD, 18, Font.BOLD, BaseColor.WHITE)));
document.add(new Paragraph("Employee No : " + empid, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("Employee Name : " + empName, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("Basic Salary : " + bSal, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("Bonus : " + bonus, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("_________________________________________", FontFactory.getFont(FontFactory.TIMES_BOLD, 18, Font.BOLD, BaseColor.WHITE)));
document.add(new Paragraph("Total Salary : Rs " + tot, FontFactory.getFont(FontFactory.TIMES_BOLD, 12, Font.BOLD, BaseColor.BLACK)));
document.add(new Paragraph("_________________________________________", FontFactory.getFont(FontFactory.TIMES_BOLD, 18, Font.BOLD, BaseColor.WHITE)));
document.add(new Paragraph("------------------------------------------------Thank you--------------------------------------------------", FontFactory.getFont(FontFactory.TIMES_BOLD, 14, Font.BOLD, BaseColor.BLACK)));
document.close();
Desktop desktop = Desktop.getDesktop();
File file = new File("C:\\Users\\Rivi Rajapakse\\Desktop\\Report" + empid + ".pdf");
desktop.open(file);
Monday, July 29, 2013
Handling Key Events ( adding a KEYPRESS event)
== Sample Code ===
-- consider about the code in RED --
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
String name = txt_bSal.getText();
if (name.trim().isEmpty()) {
net_sal = 0 + Double.parseDouble(txt_bonus.getText());
txt_NetSal.setText(Double.toString(net_sal));
} else {
net_sal = Double.parseDouble(txt_bSal.getText()) + Double.parseDouble(txt_bonus.getText());
txt_NetSal.setText(Double.toString(net_sal));
}
}
-- consider about the code in RED --
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
String name = txt_bSal.getText();
if (name.trim().isEmpty()) {
net_sal = 0 + Double.parseDouble(txt_bonus.getText());
txt_NetSal.setText(Double.toString(net_sal));
} else {
net_sal = Double.parseDouble(txt_bSal.getText()) + Double.parseDouble(txt_bonus.getText());
txt_NetSal.setText(Double.toString(net_sal));
}
}
Wednesday, June 12, 2013
ER diagram for POS system
this is the our ER diagram for the SEP project and based on the ER diagram we planned to implement our whole system. it is very easy to implement the system after decide the basis of the system called ER diagram.
In software engineering, an entity–relationship model (ER model) is a data model for describing a database in an abstract way.
Monday, June 3, 2013
project new functions.... POS system --> Advanced POS system
As our project have some more functions and methods added here are the main categories (tables) which will be in our DB.
1. Transactions
· Cash
· Credit/Debit Card
· Cheques à only for Suppliers
2. Employee Details
· Super admin
· Sub admin
· Accountant
· Cashier
3. Department à (optional)
· Managing
· Finance etc.
4. Salary à basic, epf, etf, ot, bonus (for good employees àtrack)
5. Supplier Details à contact no and address **
6. Purchase order à many PO items and total for one supplier
· Purchase order item
7. Stock items à include expiry date and batch no **
8. Invoice (Bill) à for customers
9. Customer details
10. Credit customer details à cash exceed amount**
11. Tax à tax1, tax2, tax3, tax4 and value include % **
12. Bank Details
· Bank accounts details
13. Utility Bills à water, electricity, telephone, internet etc.
14. Assets Bills à for long term items (chairs, tables, machines, PCs etc.)
· Asset item
15. Vehicle details à transport services
16. Vehicle Finance Details (OPT)
17. Loans à employee loan (6,12,24,36 months etc.) deduct from emp salary
18. Cash handling à cash details about issuing to the cashier and balancing daily
19. Report Generating
20. Menu item à. For restaurants/ hotels
Subscribe to:
Posts (Atom)