Closed

Web Apps Prototype

This project received 21 bids from talented freelancers with an average bid price of $706 USD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 USD
Total Bids
21
Project Description

Need a prototype system to handle basic operation (Login/Logout, Menu, updateable Data Grid, PDF Report)

Engine : PHP, JQuery, MYSQL

PROTOTYPE SCHENARIO :

- User Login, if has access show Main Form with Menus selection

- On Menu Selection, show Related FORM for record maintenance, who do the changes identified in fields : UPDBY, UPDDT.

- Upload Image

- Report in PDF format

Detail Prototype of this application shown below :

Data & Screen Structure :

MySql Database : PROTO01

============================================

TABLES :

---------

- USRGRP (User Group) :

- GRPCOD VarChar(3) [User Group Code] ~ ADM

- GRPDES VarChar(30) [User Group Description] ~ ADMIN

- USR (Users) :

- USRCOD VarChar(3) [User Code] ~ ALS

- USRNAM VarChar(30) [User Name] ~ ALBERT L S

- USRPWD Varchar(7) * Encrypted ! [User Password] ~ 3D3D35645

- Master_Product

- PRDCOD Varchar(5) ~ PRD01

- PRDDES VarChar(30) ~ BROWN BELL

- PRDPRC Real ~ 2000

- PRDSTS Bit ~ 0 InActive, 1 Active

- PRDPIC VarChar(30) [Pic Upload Links] ~ img/upload/[url removed, login to view]

- UPDBY Varchar(3) [User who login and update record] ~ ALS

- UPDDT DateTime [Date/Time when record update] ~ 2014-01-30 01:00:01 PM

- Header_Data

- TRNCOD Varchar(10) [Transaction Code] ~ DOC0000001

- TRNDAT DateTime [Transaction Date] ~ 2014-01-20 02:22:01 AM

- TRNDES Varchar(30) [Transaction Description] ~ Null

- UPDBY Varchar(3) [User who login and update record] ~ ALS

- UPDDT DateTime [Date/Time when record update] ~ 2014-01-10 02:30:11 PM

- Detail_Data

- DETCOD Varchar(5) [Detail Transaction Auto Assignment Code] ~ AX93D

- TRNCOD VarChar(10) [Transaction Code] ~ DOC0000001

- PRDCOD Varchar(5) [Product Code] ~ PRD01

- PRDPRC Real [Product Price] ~ 2000

- PRDQTY Real [Product Quantity] ~ 5

MENU & FORMS :

--------------

-Login with CAPTCHA

-Logout

-Main Menu

*** All Maintenance Forms Equipts with Unified Classs to handle (Add, Edit, Delete, Refresh, Find, Audit - Shows who update records) ***

-User_Group

- Admins (Access All R/W)

- Operators (Access All Read only)

-Users

- Admin - User Grup is Admins

- Operator - User Group Operators

-Master_Product

- PRDCOD Text Field

- PRDDES Text Field

- PRDPRC Text Field

- PRDSTS CheckBox

- PRDPIC Button Upload Pic, Show Image

-Header_Transaction

- TRNCOD Text Field

- TRNDAT Text Field

- TRNDES Text Field

- TOTAL [Total SUM of SUB_TTL from Detail_Transaction]

Detail_Transaction

- DETCOD [Hidden, Auto Assignment Code]

- TRNCOD [Hidden]

- PRDCOD [Combo/List Box for active PRODUCT ONLY!]

- PRDPRC Text [Auto assign after selection of PRDCOD]

- PRDQTY Text

- SUB_TTL [Formula PRDPRC * PRDQTY]

-Reports [PDF format with LOGO in each report]

- Product List [Show records from Master_Product and show the Image]

- Sales [Show record from Header_Data combine with its Detail_Data, Show Total of PRDPRC * PRDQTY], Filter Report Date From and To

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online