Get a Freelance Job

ONLY honest and excellent PHP coders who are available full-time should apply.

======

we need to finish a new Web MySQL/PHP app, called SMA (Service Management App) to manage all our warranty service work.

it is based on the MANTIS Bugtracker open source code because Mantis has almost all functionality we need, and we use it in-house and with SL to manage our development projects

see mantisbt.org for original Mantis app

======

BRIEF APP DESCRIPTION
(see attached full documentation)

the existing annonated SCREEN shots are NOT meant to cover EVERY form/screen used in app!! just many of most majopr forms/screen
as project goes on, we will be adding more screens and comments based on your prototype results

because of our service model, our service system functions are much more simple compared to all the functions standard Mantis has.

so a large part of this project is just to hide/disable functions we don’t need.

another major part is to amend many of the text and labels used by fields/function to suit SMA

the most critical addition to existing code is the requirement to pull data from two existing MySQL DBs (on same server) to populate some of major SMA forms

another major addition will be to amend & add additional screen & print reports function on SMA data

=====

Planned Service Procedures Overview
(please see attached flow chart and documentation for details)

NOTE: MOST OF THESE FUNCTIONS ARE ALREADY IN CODE

our existing & new enhanced service steps are something like this -

1. user phones with warranty problem

2. we use new SMA app to pull data from existing warranty db (REG) to validate warranty type & status and get warranty details, and from SMA existing data, and populate default job form (PART EXISTS)

3. we update and amend job form (PART EXISTS)

4. we assign a Service Agent by pulling & searching data from existing php app SAM (which also includes all searching & and mapping) functionality). (NEW)

see the ‘public’ mapping view of the is app here >>> nationalwarranties.com.au/sam/

(in-house ver of SAM has far more search & other functionality)

5. we save job form in SMA app and email service agent a link and login details to new job to access in SMA & print etc (PART EXISTS)

6. service agent does job and updates on-line job sheet with required details and saves job (EXISTS)

7. we later update with other details (EXISTS)

7. we close job. (EXISTS)

=======

Other functions/features

1. service agents should be able to login and see their current and past jobs (EXISTS)

2. management alerts, based on job milestones (PART EXISTS)

3. on-screen & printed management reports on jobs, warranties, service agents and warranty resellers (PART EXISTS)

4. there would be different levels of user access (EXISTS)

admin/office/service/service agent/user

they would have different levels of form access/data modification/reports/

======

MANTIS PROJECT MANAGEMENT & DOCUMENTATION

logon to our Mantis PROJECT MANAGEMENT application here >>

WWW.nationalwarranties.com.au/mantis/

login: sma_dev/=4sma

to see how normal Mantis Bugteacker looks and works, and you will also see a lot of documentation ‘attached’ for this project and Mantis for your information & assistance (see also attachments here)

THIS IS NOT REPEAT NOT SMA

======

SMA APP

logon to the prototype SMA application here >>

WWW.nationalwarranties.com.au/sma-dev/

login: TBA (i have to fix this up)

======

TIMING

we are not after some rushed half-completed job that doesn’t work very well, but a great final result. we expect total project to take a month or so.

======

BIDS

we don’t want any bid UNTIL you have looked at current prototype app and Mantis BT itself (if you haven’t used), and all attached documentation.

======

PROJECT MANAGEMENT

we work on AEST and are usually available constantly by Skype and email at least 5-7 days per week

as well as Skype & emails, the Web-based in-house MANTIS BT wil be used by you and us to do project management

======

PAYMENT

having wasted a LOT of time AND money on totally hopeless, and dishonest, coders in past, AND, because an unfinished app is completely USELESS to us, we will NOT make ANY actual payments before we have a functional prototype working in our development environment

HOWEVER we are happy to make an inital ESCROW payment/s, and substantial progressive ESCROW payments as project progresses, and we see work being done & results achieved

we usually pay a bonus for great results. but the bid itself is FINAL for the work outlined here and in documentation, but we would expect to pay extra, if there is some significant function or feature not mentioned or implied.

as mentioned, the attached screens and attached documentatioin & flow charts do NOT try to list every single little detail, but definitely outline all the functionality needed

=====

ONLY honest and excellent PHP coders who are available full-time should apply.

======

we need to finish a new Web MySQL/PHP app, called SMA (Service Management App) to manage all our warranty service work.

it is based on the MANTIS Bugtracker open source code because Mantis has almost all functionality we need, and we use it in-house and with SL to manage our development projects

see mantisbt.org for original Mantis app

======

BRIEF APP DESCRIPTION
(see attached full documentation)

the existing annonated SCREEN shots are NOT meant to cover EVERY form/screen used in app!! just many of most majopr forms/screen
as project goes on, we will be adding more screens and comments based on your prototype results

because of our service model, our service system functions are much more simple compared to all the functions standard Mantis has.

so a large part of this project is just to hide/disable functions we don’t need.

another major part is to amend many of the text and labels used by fields/function to suit SMA

the most critical addition to existing code is the requirement to pull data from two existing MySQL DBs (on same server) to populate some of major SMA forms

another major addition will be to amend & add additional screen & print reports function on SMA data

=====

Planned Service Procedures Overview
(please see attached flow chart and documentation for details)

NOTE: MOST OF THESE FUNCTIONS ARE ALREADY IN CODE

our existing & new enhanced service steps are something like this -

1. user phones with warranty problem

2. we use new SMA app to pull data from existing warranty db (REG) to validate warranty type & status and get warranty details, and from SMA existing data, and populate default job form (PART EXISTS)

3. we update and amend job form (PART EXISTS)

4. we assign a Service Agent by pulling & searching data from existing php app SAM (which also includes all searching & and mapping) functionality). (NEW)

see the ‘public’ mapping view of the is app here >>> nationalwarranties.com.au/sam/

(in-house ver of SAM has far more search & other functionality)

5. we save job form in SMA app and email service agent a link and login details to new job to access in SMA & print etc (PART EXISTS)

6. service agent does job and updates on-line job sheet with required details and saves job (EXISTS)

7. we later update with other details (EXISTS)

7. we close job. (EXISTS)

=======

Other functions/features

1. service agents should be able to login and see their current and past jobs (EXISTS)

2. management alerts, based on job milestones (PART EXISTS)

3. on-screen & printed management reports on jobs, warranties, service agents and warranty resellers (PART EXISTS)

4. there would be different levels of user access (EXISTS)

admin/office/service/service agent/user

they would have different levels of form access/data modification/reports/

======

MANTIS PROJECT MANAGEMENT & DOCUMENTATION

logon to our Mantis PROJECT MANAGEMENT application here >>

WWW.nationalwarranties.com.au/mantis/

login: sma_dev/=4sma

to see how normal Mantis Bugteacker looks and works, and you will also see a lot of documentation ‘attached’ for this project and Mantis for your information & assistance (see also attachments here)

THIS IS NOT REPEAT NOT SMA

======

SMA APP

logon to the prototype SMA application here >>

WWW.nationalwarranties.com.au/sma-dev/

login: TBA (i have to fix this up)

======

TIMING

we are not after some rushed half-completed job that doesn’t work very well, but a great final result. we expect total project to take a month or so.

======

BIDS

we don’t want any bid UNTIL you have looked at current prototype app and Mantis BT itself (if you haven’t used), and all attached documentation.

======

PROJECT MANAGEMENT

we work on AEST and are usually available constantly by Skype and email at least 5-7 days per week

as well as Skype & emails, the Web-based in-house MANTIS BT wil be used by you and us to do project management

======

PAYMENT

having wasted a LOT of time AND money on totally hopeless, and dishonest, coders in past, AND, because an unfinished app is completely USELESS to us, we will NOT make ANY actual payments before we have a functional prototype working in our development environment

HOWEVER we are happy to make an inital ESCROW payment/s, and substantial progressive ESCROW payments as project progresses, and we see work being done & results achieved

we usually pay a bonus for great results. but the bid itself is FINAL for the work outlined here and in documentation, but we would expect to pay extra, if there is some significant function or feature not mentioned or implied.

as mentioned, the attached screens and attached documentatioin & flow charts do NOT try to list every single little detail, but definitely outline all the functionality needed

=====

Looking for someone who can develop for me a web based SEO tool. Here are the features of the tool:

Inputs to be provided by the user:

1. URL (Compulsory)
2. Primary Keywords (Upto 3 – If primary keyword is not specified by the user, the first 3 keywords of the “meta keywords” fields would be extracted)
3. Competitors (Upto 3)

The following features would be included in the site analysis tool:
On-Page Factors
Page Titles
1. Whether it is as per the desired length (<65 characters)?
2. Does it includes the primary keywords?

Meta Tags
1. Whether it is as per the desired length (<250 characters)?
2. Does it includes the primary keywords?

Header Tags
1. If H1, H2 & H3 tags have been used?
2. Do they includes the primary keywords?

Image Alt Tags
1. If alt tags have been used?
2. Do they includes the primary keywords?

W3C Validation
If the design of the home has a Valid XHTML Coding (As per W3C Validation standards)

Site Load Time Check
What are the various load times of the site for various connection speeds

Blogs
If a /blog Folder exists in the site

RSS Feeds
If the site has any RSS feeds or not

XML Sitemap
Whether sitemap.xml exists or not

Robots.txt
1. Whether robots.txt exists or not
2. Which folders have been blocked through the same

Spelling Errors
Possible Spelling Errors as per US English

No of out bound links from the home page

Off-Page Factors / Competition Analysis
1. Back Links as per Google & Yahoo!
2. Link Popularity in Digg, Delicious, FaceBook, LinkedIn & Technorati
3. SERP Check (For the primary keywords)
4. Dmoz Listing & Wikipedia Links
5. Alexa Rankings
6. Google PageRank

Output
1. There will be a quality score given out on the basis of metrics defined
2. Comments will be accompanied with any errors
3. The report will be exported in Word, Excel & PDF formats

The final source code needs to be delivered. You also need to sign an NDA and SLA.

Please PMB me if you already worked on a similar project.

This is just a quick and simple project that you can finish in a few minutes or an hour.

I just want you to add a simple validation in this form:
http://www.prcboardexamresults.com/sms/

CellNumberPre+CellNumber+alerton+email wasn’t validated if it exists in the Database.

CellNumberPre = cnp
CellNumber = cn
AlertOn = alerton
Email = email

Here’s the MySQL database table sample:
CREATE TABLE IF NOT EXISTS `sms_subscribers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default ”,
`email` varchar(255) NOT NULL default ”,
`cnp` varchar(255) NOT NULL default ”,
`cn` varchar(255) NOT NULL default ”,
`alerton` varchar(255) NOT NULL default ”,
PRIMARY KEY (`id`),
UNIQUE KEY `id_2` (`id`),
KEY `id` (`id`)
)

I just want you to validate cnp+cn+alerton+email if it exists in the database.

These are the specific validations that I want you to add in the form:
1. If CNP+CN+ALERTON+EMAIL already exists, then “You already subscribed to our SMS updates for ‘ALERTON’ “
2. If CNP+CN already exists, the “You already subscribe to our ‘ALERTON’ updates, do you wish to subscribe for another update?”
3. If EMAIL already exists, the “Your cellphone number ‘CNP+CN’ already subscribed to our ‘ALERTON” updates, please use another cellphone number”
4. All fields are required.

The HTML form is completely separated from the PHP. I don’t want any modifications in the form. I just want to add some features, like AJAX validation. The message “You already subscribed to our SMS updates for ‘ALERTON’ ” should be above the form. Just validate in an AJAX way. I know you know what I mean.

That’s it.

I have attached you the HTML and PHP wherein you can add the AJAX validation thingy.

That’s all. My project budget is around $10 to $25. Post your lowest bid and delivery time.

This is just a quick and simple project that you can finish in a few minutes or an hour.

I just want you to add a simple validation in this form:
http://www.prcboardexamresults.com/sms/

CellNumberPre+CellNumber+alerton+email wasn’t validated if it exists in the Database.

CellNumberPre = cnp
CellNumber = cn
AlertOn = alerton
Email = email

Here’s the MySQL database table sample:
CREATE TABLE IF NOT EXISTS `sms_subscribers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default ”,
`email` varchar(255) NOT NULL default ”,
`cnp` varchar(255) NOT NULL default ”,
`cn` varchar(255) NOT NULL default ”,
`alerton` varchar(255) NOT NULL default ”,
PRIMARY KEY (`id`),
UNIQUE KEY `id_2` (`id`),
KEY `id` (`id`)
)

I just want you to validate cnp+cn+alerton+email if it exists in the database.

These are the specific validations that I want you to add in the form:
1. If CNP+CN+ALERTON+EMAIL already exists, then “You already subscribed to our SMS updates for ‘ALERTON’ “
2. If CNP+CN already exists, the “You already subscribe to our ‘ALERTON’ updates, do you wish to subscribe for another update?”
3. If EMAIL already exists, the “Your cellphone number ‘CNP+CN’ already subscribed to our ‘ALERTON” updates, please use another cellphone number”
4. All fields are required.

The HTML form is completely separated from the PHP. I don’t want any modifications in the form. I just want to add some features, like AJAX validation. The message “You already subscribed to our SMS updates for ‘ALERTON’ ” should be above the form. Just validate in an AJAX way. I know you know what I mean.

That’s it.

I have attached you the HTML and PHP wherein you can add the AJAX validation thingy.

That’s all. My project budget is around $10 to $25. Post your lowest bid and delivery time.

Summary:
Another matrix to sort products. And a “universal exists in all”
I have a car part website, so I need a car selector.
CATEGORY – “steering wheels” (zen cart handles this)
MANUFACTURER – “Momo” (zen cart handles this)
CAR TYPE – “Ferrari 360 04-08″ (I need this custom option)

I would like car type to actually have 3 sections..
CAR MAKE (mercedes-benz)
CAR MODEL (s500)
CAR YEAR SPAN (00-06)

So I could then have a category-esque type of tree when navigating by CAR TYPE. I could click on mercedes-benz, and I would only see models of mercedez-benz cars etc.. Basically CAR TYPE is like having your product exist in second category except that they dynamically interact.

The system would be similar to:
www.andysautosport.com
www.bodykits.com

I would like for this to be as dynamic and clean as possible. Compatible with my customized version of Zen Cart with Easy Populate / Google base exporter but also compatible with a generic zen cart installation, so I may upload this as a contribution to the zen cart community.

“Universal Exists in All Car Types”
The second thing that I would need is a universal product exists in all Car Types.. For instance, let’s say a have a universal “air freshener” , this product can be used in any car, so I would like the products placed in the universal car type category to appear under all cars.

“sort order hack”
I need the sort property to actually sort based on sort order, this probably isn’t a huge task, but I need a professional to take a look at this.