We are working on office automation project , this is the project will reduce the office work with help of computer applications. There will be no need of calculating funds again and again , also no need of making paper records for the various funds transactions.
Our seniors had also tried their hands on this project and they were very close in completion. but, their were some problems in implementation of the project.
I along with my classmate Daljeet Singh Pathania again start working on this project under Dr. H.S.Rai sir's guidance.We started our journey of making project from the collection of previous work done and other details of the project available with Dr. H.S Rai sir. We both were very excited to work on this project and we goes as following:-
First we can try to run on Linux its
difficult because our seniors made this on Windows . So our main
problem is Linux is case sensitive and Windows not . So we can rename
all the files according to file name is used in other files . So we
can read all the files and modified according to need . And also make
links between the files .
Second major problem is different
version of same software a used by the our seniors and Now a we are
use different Version . So there are some Keywords which are not
support by older or new version .Some of the statement are Not
working in new Version software . So we are modified these files .
In between these problems we are also
get help from our respected teacher Dr. Hsrai sir . I was facing the
problem of using username and password use in this software . Me
used the Database username and password on that place by
misunderstanding . So I told our sir , about this problem than they
will tell to me thats username & password was not databases
username & password , its a username which are written by in
database tables .
Rai sir's guidance and motivation was always there to help and support us throughout the project.
We were facing the problem in “logging in“ in the software . We were using the database user and password in logging in the project but Rai sir suggest us the write user name and password (i.e. Which stored in the database table).
Now we are able to solve these problem and our project is on 90% worked condition.
Problems still facing
- How to add new users in the project and how to set the password for the new users.
- we also have to make amendments in the project according to the current policies of the college.
- Create the .odt file .
Now go to second Problem .
Our seniors are make this software according to that time it need , but now there are many changes which we have to change
1. Add the one new field in final reports which is generate that is " Higher Education tax" .
To add that field first we change the database TABLE NAME "amt" we can add new field that is "hedu" .
After this we can change the whole system files to display and also make calculations to add that data in TOTAL AMOUNT and change the Service TAX ,EDUCATION TAX according to need.
Thats diffcult job to read and modifly the whole system files ,but we can do it
2. The SUSPENCE REPORT is not Working for ALL the fields Which user required.
For this we can modify some programming files in which the SUSPENCE is not working .
3. In SUSPENCE REPORT we are not able to get the DATE of CHECK /DD NUMBER .
For this we first add the DATE option in which the user can add the date of CHECK / DD NUMBER , than its this date can go to database TABLE NAME suspence ,than we can retrieve the date form database than Display on the Final SUSPENCE REPORT..
4. User also want to display the extra field in SUSPENCE REPROT like TDS Amonut , Balance , Service tax and Total Amount.
so we can change this account to requirement .
5. Now the big issue is to generate the "" PROFORMA BILL REPROT"", BILL FEE REPORT" .For the addition of Proforma Bill & Bill Report we can again working with database file and add two tables PROFROBILL and BILL in database TC .After this we can add a new option in MENU.PHP ,than Create on the user interface for this field to add our data in database. Than we can retrieve the data form database tables and able to Create the report according to the user need.
6 .User also required to add the "SOIL" Field in the INSTITUTIONAL phase
7 .Problem with _POST method is working with the string value in PHP ....... This can be solved with help of Hsrai sir....... by using Inter values can be used without any quite, but string values need to be enclosed in single quote.
So Now we can working on this ...............
No comments:
Post a Comment