My project is to create the Job Process System for CTK Manufacturing Inc. Job Process System provides a convenient, easy-to-use entry screen for employees. It gives them more overall visibility into their work assignments and their transactions. Job Process System provides the ability to lookup information such Jobs and Work Centers. So when an employee scans the bar code for Job Control Number from the Work Order, it will display the contents of that Job Control Number including job number, work center, work description, etc.

Job Process

I used a very simple algorithm for this program.

  • If job number is not found
    • Insert job number
  • If job number is found
    • If end time count is equal to start time count
      • Insert job number
    • If end time count is less than start time count
      • Update end time for that job number

I have added error checking to each of the required text input fields and informed the user of invalid entries on the form itself. The program also calculates the total hour for each job. Once the job process entry has been filled out correctly, it will place the information in the MySQL database. (Note that data in this screenshot are not actual data. They are used for test purpose only.)

Job Process