Php code help......

[nani_nisha06]

Hi All,

As I am a new learner and try to solve the below issue but as I failed, I wanted to ask gurus for help.


In our school I would like to develop a tool which should be a small payroll module that should generate a email & pdf format of payslip and mailed exactly to the registered recipient once on clicking generate option for that particular sure for that particulate month ...


For the above project i want to use PHP, MYSQL & HTML.


First, I want to develop a employee data & salary .......no problem I can do it....but as you all know we have 12 months in a year so how can I create a month wise data for each employee.

secondly, PHP script to generate a PDF format, mail format of payslip & mail to using MS Outlook.

third, As my accountants still do a payroll calculation in excel I want a Php page that can upload a CVS format data to my sql using CVS load data option...for bulk uploading in spite manual update.

Any suggestion please help me.

please help me on this.

Regards,
Nani

[Fou-Lu]

If this is for a fun project, then proceed ahead. If this is for a real production system, then you are in over your head; now would be the time to back out. If you cost someone their livelihood by incorrectly written software, there is a huge burden of responsibility that will come down right on you.

• That is all done with proper database design. You cannot be given suggestions without knowing the structure of the entire business rules and model that needs to be put in place.
• PHP can generate PDF files using pecl PDF extension. Mail can be set using PHPMailer, the simple mail() command or by writing your own. I would write my own or use PHPMailer.
• fgetcsv can read and parse at the same time. Just need to know the rules it was saved with for delimiting and quoting.

[nani_nisha06]

Originally Posted by Fou-Lu

If this is for a fun project, then proceed ahead. If this is for a real production system, then you are in over your head; now would be the time to back out. If you cost someone their livelihood by incorrectly written software, there is a huge burden of responsibility that will come down right on you.

• That is all done with proper database design. You cannot be given suggestions without knowing the structure of the entire business rules and model that needs to be put in place.
• PHP can generate PDF files using pecl PDF extension. Mail can be set using PHPMailer, the simple mail() command or by writing your own. I would write my own or use PHPMailer.
• fgetcsv can read and parse at the same time. Just need to know the rules it was saved with for delimiting and quoting.

Hi Fou-Lu,

First, I want to tank you for replying and on trying to reply me with your suggestions.

Coming to the project this is like a fun & learn project for me but when it come for applicability it is a more like a real project (I am not charging anyone as i am still a beginner), This software I am planning to develop for some of NGO based schools.

I wanted to work on this project to just remove a legacy way of storing the data i.e., excel where by human error so many times we have missed/cor reputed most of these files, To just avoid this errors i am planning to create a DB which can store all these details.

I want a PHP code which can using CSV comma delimited file to upload in to the Mysql so that our accountants need not rely every time on me for uploading the data.

On the second I will create a page which will project data which i have uploaded using CSV.....and beside every row I want to have a edit option & generate options available.

Edit option is for updating/changing records in the Mysql.

Generate option is to generate a Mail using MS outlook that contain a PDF attachment and HTML body of the payslip page which will be sent to the user's email ID which is registered in the DB.

Coming to business rules: As our accountants do all the calculation related to the payroll in the Excel currently, I need not to worry or plan to write a script about the formulas that need a calculation of the figures.

Please suggest me if this is a good idea or any easy Idea available please suggest me.

Regards,
nani

[Fou-Lu]

A learning project for yourself is one thing, but a production system? No, this is a terrible idea. Financial systems regardless of the level it's hooked into is not a project a novice programmer should be taking. This is a ticking liability bomb right here, and I can guarantee you that the first person that will be crucified in the event of any problem will be the developing company or person. And unless they are willing to sign of waiver after waiver, that liability will fall right on you; no company will sign liability waivers for any financial system.
If you want to learn how to do this, then that is fine. But do not even consider writing a production system of this scale until you are well beyond the level of novice.

[nani_nisha06]

Originally Posted by Fou-Lu

A learning project for yourself is one thing, but a production system? No, this is a terrible idea. Financial systems regardless of the level it's hooked into is not a project a novice programmer should be taking. This is a ticking liability bomb right here, and I can guarantee you that the first person that will be crucified in the event of any problem will be the developing company or person. And unless they are willing to sign of waiver after waiver, that liability will fall right on you; no company will sign liability waivers for any financial system.
If you want to learn how to do this, then that is fine. But do not even consider writing a production system of this scale until you are well beyond the level of novice.

Fou-Lu,

Thanks & appreciate, even I agree on your guide lines on the Idea for deploying it to production system.

So now I decided to make this as a learning project can I please request you to guide me preparing to build this project framework.

let me know the ideas where you want me to start & progress on this project.

Regards,
Nani