Web Apps Prototype

Closed

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

Skills: HTML, jQuery / Prototype, MySQL, PHP, Website Design

See more: website structure audit report, web design audit, web application logo w, update prototype, the pic group, the brown box formula, prototype website design, prototype upload, prototype update, prototype of product, prototype forms, prototype date, prototype auto, pm audit, php jquery web design, menu design web, logo refresh design, logo grup, logo design for apps, grid in php with add edit delete, grid data structure, find the operator, find operators, fields related to product design, fields auto group

Project ID: #5308492

16 freelancers are bidding on average $738 for this job

crea8ivedesign

hi thanks for consider crea8ivedesign Proposal please view following links for portfolio http://www.crea8ivedesign.com/portfolio/recent-logos/ http://www.crea8ivedesign.com/portfoliowork/web-design-work/ http:/ More

$752 USD in 10 days
(265 Reviews)
7.8
p4provider

Hello, Let me show you how we are different from others. Some of the key differentiators are: 1. An excellent team of 40 software engineers with expertise in all emerging technologies 2. Easy access on IMs l More

$1030 USD in 20 days
(105 Reviews)
7.7
ganeshbaid

Hello We are expert in web solution and our review speaks about our work, kindly have a look at our portfolio on http://bitty.in/5Qio03 or read what our client says about us at http://bitty.in/jtRV2I . Please accep More

$600 USD in 14 days
(156 Reviews)
6.9
ibapi

A proposal has not yet been provided

$773 USD in 20 days
(112 Reviews)
6.8
posspooja

Hello, I am an PHP Certified Developer with more than 7 years of experience and shall get this done in about 15 days' time. Let me know if you have any doubts / queries about my expertise, will be more than hap More

$927 USD in 15 days
(55 Reviews)
6.4
tiabrains

Dear Hiring Manager, I am ready to help you in your project I have read your project description .Expert in Graphic Design, HTML, PHP, Website Design.Please note that we are into IT industry since last 10 years and w More

$611 USD in 10 days
(57 Reviews)
6.3
codeware1

Hello, I have gone through your project’s initial requirements with the help of the job posting you have placed. And I think I have requisite experience and expertise to complete your project successfully. I am very m More

$659 USD in 20 days
(42 Reviews)
6.0
vickymudgal

Hello, Greetings from Crewbit !! As per requirement of a prototype system with some basic functionalists, we are gald to inform you that we have completed many complicated projects and worked on your all requirem More

$526 USD in 20 days
(23 Reviews)
6.0
irshadwazid

Hello, Thanks, for giving us a chance to bid on your project.We are an (ISO 9001:2008) (ISO 27001:2005) certified company which have throught 5 stars ranking and great reviews by customers from globe. We have a More

$698 USD in 10 days
(28 Reviews)
5.7
conapps

Hello, We can definitely serve you with your requirements to handle the operations of login/logout , menu,updateable grid,PDF report.These will perform the following function you mentioned. We will deliver you with More

$721 USD in 20 days
(46 Reviews)
5.7
VnBestSolutions

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$842 USD in 10 days
(40 Reviews)
5.5
fattahaabdul

i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level Please see my reviews https://www.freelancer.com/u/fattahaabdul.html Ce More

$1237 USD in 10 days
(11 Reviews)
5.3
shreeyait

Hello Sir, We have checked your job detail and as per that we are able to do your job and we have very good experience in Word Press, Joomla, Joomla component, Modules, PHP, HTML,Magento etc . As well knowledge on More

$618 USD in 18 days
(24 Reviews)
4.7
fastworkontime1

Hello! I have read your requirements carefully and I want to tell you that I have 6 years + experience in web design and development. I can easily take up your task as I have done similar kind of works before also. Let More

$721 USD in 10 days
(30 Reviews)
4.6
winexsoft

Dear Sir, I am an expert in web design and development and have more than 4 years of experience in the relevant field with expertise in Php, C#, DB Management. I have worked on a variety of web and desktop projects, More

$500 USD in 10 days
(26 Reviews)
4.6
vijaywebsol

Hello Sir, We have a team of 50+ highly skilled employee.We will give you best result with in specified time.Please give me some time for the technical discussion......... Please go through the links............ More

$824 USD in 15 days
(17 Reviews)
4.5
VRWebSolutions

Hello, We can create the Web Apps Prototype based on your requirements and timeline. I primarily work with small businesses, professional services and individuals. My goal is to provide quality web solution at More

$412 USD in 20 days
(3 Reviews)
4.2
vandyimp

I understand the requirements. I'll create this app to perform the requested operations on it. Please come on chat for further discussion, so that I can start the work right away. Features: 1. 2 months post deliv More

$309 USD in 10 days
(7 Reviews)
3.8
xgensolu

We are a dedicated team, which are highly professionals in the industry. Our development team in India comprises of Software Architects, Web Experts, Database Architects, Programmers, Web Designers and Industry Experts More

$706 USD in 15 days
(1 Review)
2.7
AutumnSoftwares

Hello Sir/Mam, We have professionally trained team of expert web designers which design user friendly web pages and websites. We use all the latest technologies for web designing. We ensure that our excelle More

$800 USD in 30 days
(0 Reviews)
0.0