コード例 #1
0
  public Receipt getReceiptDetails(int receiptId) {

    Receipt receipt = new Receipt();
    try {
      DBConnection receiptSc = (DBConnection) sc.getAttribute("dbConn");
      receiptConn = receiptSc.getDBConnection();
      receiptStmt =
          receiptConn.prepareStatement("SELECT * FROM tbl_student_fees_receipt where receipt_id=?");
      receiptStmt.setInt(1, receiptId);
      receiptRs = receiptStmt.executeQuery();
      receiptRs.next();
      receipt.setReceiptId(receiptRs.getInt("receipt_id"));
      receipt.setStudentId(receiptRs.getInt("student_id"));
      receipt.setSemester(receiptRs.getInt("semester"));
      receipt.setTotalFees(receiptRs.getDouble("total_fees"));
      receipt.setPendingFees(receiptRs.getDouble("fees_pending"));
      receipt.setStatus(receiptRs.getInt("status"));

    } catch (Exception e) {
      System.out.println("Exception in getting receipt details of Receipt controller" + e);
    } finally {
      close();
    }
    return receipt;
  }
コード例 #2
0
  public ArrayList<StudentAcademic> currentSemesterInvoice() {
    ArrayList<StudentAcademic> returnCurrentSemesterInvoices = new ArrayList<>();

    try {
      DBConnection receiptSc = (DBConnection) sc.getAttribute("dbConn");
      receiptConn = receiptSc.getDBConnection();
      receiptStmt =
          receiptConn.prepareStatement(
              "SELECT * FROM tbl_student_academic WHERE academic_status=? AND invoice_status=?");
      receiptStmt.setString(1, "N/A");
      receiptStmt.setInt(2, 1);
      receiptRs = receiptStmt.executeQuery();
      while (receiptRs.next()) {
        StudentAcademic studentInvoices = new StudentAcademic();
        studentInvoices.setStudentId(receiptRs.getInt("student_id"));
        studentInvoices.setReceipId(receiptRs.getInt("receipt_id"));
        returnCurrentSemesterInvoices.add(studentInvoices);
      }
    } catch (Exception e) {
      System.out.println("Exception in getting currentSemester invoices " + e);
    } finally {
      close();
    }
    return returnCurrentSemesterInvoices;
  }
コード例 #3
0
  public void addReceipt(String[] validStudentId, int feesTemplateId) {
    try {
      DBConnection receiptSc = (DBConnection) sc.getAttribute("dbConn");
      receiptConn = receiptSc.getDBConnection();
      int currentSemester = 0;
      // StudentRegistrationController studentRegistrationController=new
      // StudentRegistrationController();//
      StudentAcademicController studentAcademicController = new StudentAcademicController();
      StudentAcademic studentAcademic = new StudentAcademic();
      StudentAcademic studentReceipt = new StudentAcademic();
      FeesTemplateController feesTemplateController = new FeesTemplateController();
      StudentFeesHistoryController studentFeesHistory = new StudentFeesHistoryController();

      for (int i = 0; i < validStudentId.length; i++) {
        // ArrayList<StudentRegistration> studentDetails=
        // studentRegistrationController.getStudentDetails(Integer.parseInt(validStudentId[i]));
        // for(StudentRegistration studentDetail:studentDetails){
        // currentSemester=studentDetail.getSemester();
        // }

        currentSemester =
            studentAcademicController.studentCurrentSemester(Integer.parseInt(validStudentId[i]));

        double templateFees =
            (Double)
                feesTemplateController.templateDetailsFromId(feesTemplateId).get("template_fee");

        receiptStmt =
            receiptConn.prepareStatement(
                "INSERT INTO tbl_student_fees_receipt(student_id,semester,total_fees,fees_pending,created_date) values(?,?,?,?,?)",
                Statement.RETURN_GENERATED_KEYS);
        receiptStmt.setInt(1, Integer.parseInt(validStudentId[i]));
        receiptStmt.setInt(2, currentSemester);
        receiptStmt.setDouble(3, templateFees);
        receiptStmt.setDouble(4, pendingFee(templateFees, 0));
        Calendar calendar = Calendar.getInstance();
        java.util.Date createdDate = calendar.getTime();
        Timestamp createdDateTime = new Timestamp(createdDate.getTime());
        receiptStmt.setTimestamp(5, createdDateTime);
        receiptStmt.execute();
        receiptRs = receiptStmt.getGeneratedKeys();
        if (receiptRs.next()) {
          studentFeesHistory.addStudentFeesHistory(
              receiptRs.getInt(1), feesTemplateId); // adding fees histoty for student
          studentAcademic.setStudentId(Integer.parseInt(validStudentId[i]));
          studentAcademic.setInvoiceStatus(1);
          studentAcademicController.updateInvoiceStatus(studentAcademic);
          studentReceipt.setStudentId(Integer.parseInt(validStudentId[i]));
          studentReceipt.setReceipId(receiptRs.getInt(1));
          studentAcademicController.updateReceiptId(studentReceipt);
        }
      }

    } catch (Exception e) {
      System.out.println("Exception in Add Receipt " + e);
    } finally {
      close();
    }
  }
コード例 #4
0
  public ArrayList<Receipt> getAllReceiptId(int studentId) {
    ArrayList<Receipt> receiptIds = new ArrayList<>();
    try {
      DBConnection receiptSc = (DBConnection) sc.getAttribute("dbConn");
      receiptConn = receiptSc.getDBConnection();
      receiptStmt =
          receiptConn.prepareStatement(
              "SELECT receipt_id FROM tbl_student_fees_receipt where student_id=?");
      receiptStmt.setInt(1, studentId);
      receiptRs = receiptStmt.executeQuery();
      while (receiptRs.next()) {
        Receipt receipId = new Receipt();
        receipId.setReceiptId(receiptRs.getInt("receipt_id"));
        receiptIds.add(receipId);
      }
    } catch (Exception e) {
      System.out.println(
          "Exception in getting all receipt id of student in Receipt controller " + e);
    } finally {
      close();
    }

    return receiptIds;
  }