Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Regular Coder
    Join Date
    Oct 2012
    Location
    mother land --india
    Posts
    159
    Thanks
    37
    Thanked 2 Times in 2 Posts

    Lightbulb Php code help......

    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
    Last edited by nani_nisha06; 10-07-2012 at 06:42 PM.

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,978
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    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.

  • Users who have thanked Fou-Lu for this post:

    nani_nisha06 (10-08-2012)

  • #3
    Regular Coder
    Join Date
    Oct 2012
    Location
    mother land --india
    Posts
    159
    Thanks
    37
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by Fou-Lu View Post
    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

  • #4
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,978
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    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.

  • Users who have thanked Fou-Lu for this post:

    nani_nisha06 (10-08-2012)

  • #5
    Regular Coder
    Join Date
    Oct 2012
    Location
    mother land --india
    Posts
    159
    Thanks
    37
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by Fou-Lu View Post
    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
    Last edited by nani_nisha06; 10-08-2012 at 10:34 AM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •