BCS Project Manager

Every computer technician is strapped with the task of reporting time spent on projects as billable hours.
The BCS Project Manager offers relief in that allows the technician to enter information into the repository and the database object calculates the elapsed time of the identified tasks.
This calculation is shown in elapsed days, hours, minutes and seconds. An associated report is also available that shows task completed by day and week. Consequently uncompleted task are also reported in a similar format by day or week.

The heart of the BCS Project Manager is the data repository.
The MySQL schema is listed below
[codesyntax lang=”mysql”]

-- phpMyAdmin SQL Dump
-- version 4.1.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 31, 2014 at 05:46 PM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.26
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `bcswebtools`
--
-- --------------------------------------------------------
--
-- Table structure for table `pwb`
--
CREATE TABLE IF NOT EXISTS `pwb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sdes` varchar(255) NOT NULL,
  `xqt` varchar(255) NOT NULL,
  `sdir` varchar(125) NOT NULL,
  `det` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=378 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[/codesyntax]
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.