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