Society-Financial-Management :

This application Handles two kind of users

	1.) Manager
	2.) Appartment Family Member

Application Specification :

-> Appartment Manager:

	- Can able to login
	- Can able to Manage the Appartment Family :
		
			1.) Add Family 
			2.) Remove Family
			3.) Edit Family Details 
	
	- Can able to set monthly Payment with the help of simple maker

	- Can able to contact rejected pay users

	- Can able to see all the payment reports based on gien date range

-> Family Member :

	- Can able to login after creating an account with the help of Appartment Manager

	- Can See how much Monthly payment he need to pay and he can pay the bill with the help of simple checker 

	- Can able to see the payment history of that user

Automatic functionalities :

	1.) Every month day 6 to day 10 the payment alert mail will send to each user until he/she pay the bill

	2.) After day 10 un-payed user should pay the fine amount of 100-RS this will automatically updated in database

	3.) The payment delayed user deatails also automatically recorded

Technology Stack Used:

		     FrameWork -> Spring MVC 
		     Front-End -> JSP,JSTL,HTML,CSS,JavaScript(JQuery,AJAX).
		     Back-End  -> Java (Programming Language)
		     DataBase  -> MySql
		     Automatic-Functionalites -> QuartsScheduler
		     Project-Management-Tool -> Maven

DataBase Schema :

mysql> use project;
mysql> show tables;
      +-------------------+
      | Tables_in_project |
      +-------------------+
      | admin             |
      | date              |
      | main              |
      | temp              |
      | user              |
      +-------------------+

This application has Five tables :

1.) admin - to handle admin login details
2.) user  - to handle user data
3.) temp  - it contains that on-going particular month data 
4.) main  - it contains whole payment data (after every first day of the month temp data records copy to here and temp gets empty)
5.) data  - to handle automatic functionalities we need this table

To make Database-Tables DataBase Comments :

  1.) create Database :
      
        create database project;
        
      2.) create Tables :

	2.1) create admin table :
	
		create table admin(name varchar(10),pass varchar(10));

	2.2) create user tabel :

		create table user(D_no varchar(5),Fam_head varchar(20),DOJ varchar(20),noofmem varchar(20),email varchar(30),phone varchar(15),username varchar(20),pass varchar(15));

	2.3) create temp table :

		create table temp(D_no varchar(20),month_charge varchar(20),extra_charge varchar(20),fine varchar(20),pay_stage varchar(20),paid_date varchar(20));

	2.4) create main table :

		create table main(D_no varchar(20),month_charge varchar(20),extra_charge varchar(20),fine varchar(20),pay_stage varchar(20),paid_date varchar(20));

	2.5) create date table :

		create table date(day int, state varchar(10));

In proerties file I used to store DataBase deatils

Application Modules:

   -UserLogin 

   -Adminwork 

   -userwork

   -Autoupdate 

   -database

   -session

Auromatic Functionality Libaries :

- For mail we have JavaMail API in this application you no need to import any jar file,
	because I create this app using Maven so it hande package for us

- For Automatic Fucntionality Quartz Scheduler is used, here crons as a input argument 

For more about crons

Note :

The sender mail shoud be Enable signin from less secure apps in Gmail: by click this link