Archive

Posts Tagged ‘contains’

Myd To Sql Converter

December 20th, 2011 Comments off

The MyISAM storage engine stores MySQL tables in three files. The .frm file contains the column names, data types, and other structural data of the table. The .MYD file contains the rows, or the actual data in that table. The .MYI file contains the index information, but that file is not important for this project.

I need a PHP script that can convert the .frm and .MYD files into SQL queries that recreate that table. The user should be able to upload those two files through a HTML form, a…

Categories: Conversion, MySQL, PHP, SQL Tags: , , , , , ,

Excel Formulas Needed

November 15th, 2011 Comments off

I need two excel formulas created for me.

The first:

If C2 contains the word “ball” print ball-earrings in D2
If C2 contains the word “clip” print clip-on-earrings in D2
If C2 contains the word “cuffs” print ear-cuffs in D2
If C2 contains the word “dangle” print dangle-earrings in D2
If C2 contains the word “jackets” print earring-jackets in D2
If C2 contains the word “hoop” print hoop-earrings in D2
If C2 contains the word “stud” print stud-earrings in D2
If C2 contains none of t…

Categories: Excel Tags: , , , , , ,

Basic Java Programming

September 16th, 2011 Comments off

Part 1

Main Method

Implement a program that reads in a user password and verifies it meets the following criteria:

Is at least 7 characters long
Contains at least 1 lower letter character
Contains at least 1 upper letter character
Contains at least 1 numeric digit
Contains at least 1 special character from the set: !#$%^&*
Does not contain the String �pass� or the String �word�

Output a string that prompts the user for a password and include the requirements above in your output.

Output a string that states valid or invalid. If invalid, state which rule above has not been met.

Utilize the following functionality:

� indexOf

Looping structure

� charAt()

� isDigit()

� isUpperCase()

� isLowerCase()

� and any additional functionality needed.

Comments are REQUIRED; flow charts and Pseudocode are NOT REQUIRED.
Proper coding style is REQUIRED.

This is a Sample of what it should look like:

Password Verifier

Enter a password that meets the following rules:
<list rules from above>
Password1

Invalid
Contains the string �word�
Missing a special character

—————————————————————–

Password Verifier

Enter a password that meets the following rules:
<list rules from above>
passWord123$

Invalid
Contains the string �pass�

—————————————————————–

Password Verifier

Enter a password that meets the following rules:
<list rules from above>
Hi

Invalid
Must be at least 7 characters long
Must contain a numeric digit
Must contain a special character

—————————————————————–

Password Verifier

Enter a password that meets the following rules:
<list rules from above>
Pa$$Word1

Valid

Part 2

Present an ORIGINAL example of the correct use of the printf method. This example must show how integers, doubles and Strings are properly formatted for display. At least one integer, one double, and one String must be printed using printf.

Show syntactically correct Java code that requests at least one number from the user. The program will store all the numbers the user provides into separate String variables, and it will use the appropriate methods from the wrapper classes to convert these Strings into numerical values. Afterwards, the program should use these numerical values to compute any mathematical formula that uses at least one method from the Math class and display the outcome with appropriate titles.

An Editing Environment For Travel Maps.

September 4th, 2011 Comments off

In this project you will develop an editing environment for travel maps. For this assignment you will develop the basic infrastructure for reading in a representation of a map, and computing distances.

2 Description
The goal of this assignment is to create a Java class to store places and routes of a travel network, and allow trip distances to be calculated. In addition, you will write a class that can read/write a map from/to a text file. The external behaviour is prescribed by interfaces we provide.
3 Map file format
The file describing a map is a series of records, structured as lines of text. The are five different type of lines to specify places, roads, starting and ending points for a trip, and comments.
3.1 Place record
place placeName xpos ypos
Where:
� place is the character string �place�.
� placeName is the name of the place, a string of characters beginning with a letter, followed by zero or more letter, digit, or underscore characters. (This is essentially the definition of �identifier� in Java.)
� xpos and ypos are integer values that give the x- and y-position of the place on the computer’s display screen. Although you will not need these values for this stage of the project, you must store and reproduce them correctly.
3.2 Road record
road firstPlace secondPlace roadName length
Where: � road stands for the character string �road�; � firstPlace is the name of the place at one end of the road; � secondPlace is the name of the place at the other end of the road;
� roadName is the name of the this road. A roadName is character string that starts with a letter, and is followed by letters or digits. The special roadName – means the road does not have a name.
1
� length is the length of this road, in kilometres. Note that a road is symmetric � it is possible to travel from a to b, and from b to a.
3.3 Start record
start placeName
Where: � start stands for the character string �start�; � placeName specifies the starting place for a trip on the map.
3.4 End record
end placeName
Where: � end stands for the character string �end�; � placeName specifies the ending place for a trip on the map.
3.5 Comment record
A line that begins with the character �#� is a comment, and is ignored by the system.
3.6 Order of records
Records can appear in any order in the file, with one restriction: a place name must have been defined via a place record before its name can be used in a road, start, or end record. When writing a file, it is conventional to write the records in the order: place, road, start, then end.
4 What we provide
We provide the following java files for you:
Map.java contains an interface specification for a class that stores a representation of a map.
Place.java contains an interface specification for a class that stores a representation of a Place.
Road.java contains an interface specification for a class that stores a representation of a Road.
MapIo.java contains an interface specification for a class that can read or write a map from a textfile.
MapFormatException.java Specifies an exception that is thrown when an error is detected while reading a map specification.
PlaceListener.java contains an interface that is used to notify listeners when a change has been made to a place.
RoadListener.java contains an interface that is used to notify listeners when a change has been made to a road.
MapListener.java contains an interface that is used to notify listeners when a change has been made to the map.
exampleMap.txt contains an example map.

5 What you must do
You must write two java classes: MapImpl.java that implements the Map interface, and contains a default constructor: public MapImpl(), and MapReaderWriter.java that implements the MapIo inteface, and contains a default constructor MapReaderWriter()

Simple Clean 5 Pages Html & Css Template

July 29th, 2011 Comments off

We’ll be offering this template to our clients.

Simple template visiually divided in three parts: Header, Body and Footer

1. Header contains a blank container for logo (NO logo required, just a blank container) with style text font and 5 buttons below (link, hover, visited style) with a slightly transparent background to blend with site background.

2. Body is vertically divided into two
- First part of the body contains single banner (no slider), banner should be divided in two (left: an image; right: heading, description below heading, and a button below description)
- Second part contains three containers with style similar to that of the right half of the banner

3. Footer simply contains copyright and facebook and twitter logo links

Other 4 pages should be standard for services, contact (one skeleton contact form required, HTML5 form appreciated), about us, products page with simple price table

Two styles of Background:
- Gradient on the top using CSS, NO image.
- Patterns (only 1 pattern needed)

Floating menu on the left that trails vertically upon scrolling up/down.

Styling should mainly be external CSS.

Excel – Vba – Pivot Table

December 9th, 2009 Comments off

Hello

I have a workbook with multiple Pivot Tables.
The name of each Pivot table contains the word “week” or the word “month”.
I need you to do a form for year, month and week selection
With this selection, you must:
1- fill a cell with selected
2- apply selection in many pivot tables. If pivot table contains the word “week”, then you must apply “week” selection, and if contains “month”, then apply month selection.
One of the sheet will contain the list of years, month and week.

The form must open with a button.
Must run in Office 2007 and XP.
I have to be able to adjust it to 2 or 3 different cases (minor changes to open source).
Scrow Payment.

Thanks

Clean Up Csv File With Php

November 24th, 2009 Comments off

I have a nice little php script that uploads a csv file to my webhost. This file will eventually be imported into a mysql database but the data needs to be “cleaned up” so the file will come in correctly. Here is what needs to be done:

1. I need to delete the first column of the file which has a label of: “Bill To #”.
2. I need to delete (or ignore) the first (header) and last (footer) rows. The number of rows that the file contains will vary from day to day but there will always be a header and footer that need to be deleted (or ignored).
3. The file contains commas and dollar signs in three columns. These create havoc on my import and need to be stripped out.
4. The file contains “borders” (which are the grid boxes that are placed around each cell)so I am not sure if these will cause me problems?

I need to get this done as soon as possible. Let me know if you are interested.

Categories: MySQL, PHP Tags: , , , , , ,

Very Simple Windows Program

November 6th, 2009 Comments off

Basically there are 2 files:

o1.txt contains:
sometexthere1sometexthereetcetc

o1-r.txt contains
anothertexthere1anothertexthere

So these 2 files are the initial “pair”. I need a program that will make more “pair” files such as:

o2.txt contains:
sometexthere2sometexthereetcetc
o2-r.txt contains
anothertexthere2anothertexthere

o3.txt contains:
sometexthere2sometexthereetcetc
o3-r.txt contains
anothertexthere2anothertexthere

And so on, up to the number of files N that I wanna create. Basically the number in the text can be a parameter which will be changed. Only that parameter changes in every file.

That’s it. You should be able to do this in 1 day max (more likely in 1 hour).

Iframe Adjustment

September 24th, 2009 Comments off

Small video of affiliate page keeps coming up on wordpress page that contains an iframe. Need iframe code to be adjusted so affil video is removed. Page also contains a link to affil order page which I need to make sure contains my correct affil id. I can provide current iframe html and you can make necessary adjustments and resend corrected code.

Website With Cms

August 10th, 2009 Comments off

Hello, i need a website coded in xhtml with a cms.
I will provide the layout in PSD format. The website should be ie6,7 ff2,3 and safari browsable.
It would be nice if the cms has a nice interface – but that is not the main objective.
If you have examples cms you working with, please post me some examples or login data.
I have uploaded a small screen of the layout, just to see how it will look.

Here is the navigation structure:
Home, News, Contact, About Us, Service, Projects, H-card, Members

Some of the menus have submenus, but the content don

Website With Cms

August 4th, 2009 Comments off

Hello, i need a website coded in xhtml with a cms.
I will provide the layout in PSD format. The website should be ie6,7 ff2,3 and safari browsable.
It would be nice if the cms has a nice interface – but that is not the main objective.
If you have examples cms you working with, please post me some examples or login data.
I have uploaded a small screen of the layout, just to see how it will look.

Here is the navigation structure:
Home, News, Contact, About Us, Service, Projects, H-card

Some of the menus have submenus, but the content don

Complex Form With Validation

July 16th, 2009 Comments off

I have a fairly complex form with lots of questions. There are many required fields with script letting user know that they need to complete the specific field. The fields also have a tab order.

To URL for the form is:
https://www.innerbalancehealthcenter.com/assessment_form.htm

The layout is poor with nested tables. Initially, there were only a dozen questions but we kept adding on and it is quite messy.
The validation stopped working in IE 8.

Here is what I’m now looking for:
- Clean up overall code and eliminate erroneous tags.
- Move name/address fields to the left more. Right now they are on the right side of the main section and too much white space on the left.
- This is the main change… I would like to make the required field validation more Ajax based or at least validated where the field is located. For instance, if first name is required and the user submits the form without a First Name, then there is some text near the first name field in red italics that says something like “You must include your first name”
- Finally, there are several conditional fields I need to make required. For instance a question with a radio button has a “yes” or “no” response. If the user picks yes, then the 3 fields after are required. If they pick “no” then the next 3 fields can be left blank. An example is:
7. Have you ever been to treatment before? []no []yes
If yes, Name of program [ ], type of program[ ], dates attended from[ ] to[ ]

Question #7 is required. If they answer “No” the related fields can be left blank. But if they answer “Yes” then they need to complete the related fields.

- finally, I need good commenting in the code. We constantly change this form with new questions, new required fields, etc. and need to be able to do this ourselves.

- the layout in the footer looks broken and shows a white background at the very bottom below the footer and should be gray. See other pages on site to see how the footer should look.

This form feeds our formtools database which we like. I’m just looking to clean up this form, improve the validation (located next to and highlights missing required fields), create conditional validation (if yes, then…), fix the layout and well commented code to facilitate future changes.

The current code shows all the required fields. However, these are the conditional fields we would like added:
6a. If 6a contains text, following 4 fields are required.
6b. If 6b contains text, following 4 fields are required.
6c. If 6c contains text, following 4 fields are required.
7. If yes, next 4 fields are required and #8 and #9
If 2nd Name of Program contains text, other 3 fields required and #10, #11
If 3rd Name of Program contains text, other 3 fields required and #12, #13
#14 if yes, 14b
#15 if yes, 15b, 15c, 15d, 15e, 15f, 15g
#16a if yes, 16b, 16c required
#17a if yes, 17b, 17c required
#19a if yes, 19b required
#20a if yes, 20b required
#21a if yes, 21b, 21c required
#22a if yes, 22b required
#23a if yes, 23b required
#39a if yes, 39b required

Open to new ways to accomplish this. Just looking for an elegant and user friendly form in the end.

Php/mysql Script For Crontab

July 13th, 2009 Comments off

**********************************************************************
!+++ this is an adult website +++! – you must be 18 or older and agree to work on an adult content website.
- no gay content, basically you be looking at adult dvd box covers.
**********************************************************************

I have a ‘products’ table in mysql that contains a memo field that contains list of actors in comma separated value format.

e.g:
John Smith, John Doe, Hank Johnson, Jason, Frank Thomas, etc

What I need is a script that I can run via shell/crontab that will make make a list of all the individual actors and dump them into a new table.

Basically ‘table1′ contains thousands of movies with the actors in that movie in a memo field in CSV format. I need the script create a list of all the actors in every movie within the table, remove any duplicates within that list, then create/add the list of actors to a new table; ‘table2′. Once the script runs again via crontab, it should compare all of the actors in table1 with table2 and add any new actors it finds. that’s it

This is what the script should do exactly:

1) do a query within that table/column and find all of the actors and break them up individually – (the comma determines a new value).

2) remove all of the duplicates it finds.

3) dumps the new actors list into a new table, since there will be multiple movies with the same actor, we only want the actors to show up once in the new table.

4) the script must be able to run via crontab/shell

5) once the script reruns via crontab, it must look at table1 and table2 and add any new actors it finds, if it doesn’t find any new actors.. it doesn’t add anymore to the list in table2.

Basically what I’m trying to do is create an index listing page for all the available actors that are on the site

Add Shopping Cart To A Website

June 23rd, 2009 Comments off

BRIEF:

A website has been designed in layers using illustrator, it has a number of layers.

MAIN TEMPLATE including NAVIGATION BUTTONS TOP AND BOTTOM
The navigation requires drop down menus

THE MENS DROP DOWN CONTAINS THE FOLLOWING

Xml Parser Php Script

June 2nd, 2009 Comments off

I need a php script to parse data from results of search requests similar to this:

http://www.popshops.com/v1/0yp0rj3hqei08nztbslkxco1m/products.xml?catalog_key=8dma5bktzb9bseed24byo2z3w&amp;keywords=ipod+16gb

The results will then be displayed on our online shopping mall website (www.ShoppingMinistry.com). It should display a list of available products and allow customer to sort by name, price etc. It should also allow them to narrow the search by available parameters.

Here are more info about available parameters etc:

Request URL

http://www.popshops.com/v1/0yp0rj3hqei08nztbslkxco1m/products.xml
Required request parameters
Field Value Description
catalog_key string Unique key identifying catalog of merchants: 8dma5bktzb9bseed24byo2z3w
keywords string

A list of keywords to search across your catalog merchants.

keywords=ipod Is a basic search for products containing the keyword ‘ipod’

keywords=ipod -case is a search for products containing the keyword ‘ipod’ and NOT containing the keyword ‘case’
Optional request parameters
Field Value Description
merchant_id integer A unique PopShops merchant_id, limiting products to a single merchant
merchant_type_id integer A unique merchant_type_id limiting products to a single merchant_type.
category_id integer A PopShops category ID, limiting products to a single merchant’s category. Category ids are currently only returned in product query responses.
brand_id integer A PopShops brand_id, limiting products to a single brand
price_min decimal
10.00,19.95, etc
Price minimum product prices should not go below
price_max decimal
10.00,19.95, etc.
Price maximum product prices should not exceed
product_sort name_asc
name_desc
price_asc
price_desc Featured (default), Name (A-Z), Name (Z-A), Lowest Price, Highest Price
product_limit 1-100 Number of products to display at a time. 100 maximum.
product_offset integer Number to offset the product results by
include_deals boolean
1 or 0
Available deals can also be included in the result set that match returned products and merchants.
url_subid string Custom subid/sid to be appended in any final affiliate product urls.
Response fields
Field Description
search_results Contains all of the query responses. Attributes:

* keywords: any keywords passed in
* product_limit: any product_limit passed in
* product_offset: any product_offset passed in
* merchant_id: any merchant_id passed in
* category_id: any category_id passed in
* brand_id: any brand_id passed in
* product_sort: any product_sort passed in
* price_min: any price_min passed in
* price_max: any price_max passed in
* merchant_type_id: any merchant_type_id passed in

products Contains products matching the query parameters. Attributes:

* total_count: Total number of products matching the query parameters

product Contains an individual product. Attributes:

* name: The name of the product
* description: The description of the product
* merchant_id: The merchant_id for the merchant the product belongs to.
* large_image_url: A url for the largest sized image available for the product.
* medium_image_url: A url for a medium sized image of the product.
* small_image_url: A url for a small sized image of the product.
* merchant_price: The price offered through the merchant. Usually corresponds to the lowest price.
* retail_price: The listed retail price of the product.

price_ranges Contains price_ranges for products matching the query parameters.
price_range Contains an individual price_range. Attributes:

* max: The max dollar value in the range
* min: The min dollar value in the range
* product_count: The number of products within this price range.

merchants Contains top merchants for products matching the query parameters. In many cases the number of merchants matching the query is too many to bring back, so this will only bring back the top 50 merchant matches by product count. You may encounter results where you get a product on a page and there is no matching merchant in the merchants node.
merchant Contains an individual merchant. Attributes:

* id: A unique id for the merchant. You can pass this in as a merchant_id to filter products to this specific merchant.
* name: The name of the merchant.
* product_count: The number of products matching the query for this specific merchant.
* logo_url: If available a logo_url will be provided which is a url to small thumbnail of a logo for the merchant.
* url: If available the url will be returned, which is a landing page for this merchant.
* merchant_type_id: If the merchant belongs to a merchant_type, this will be the id for the merchant_type. This can be used to further filter products as a merchant_type_id parameter.

merchant_types Contains top merchant_types for products matching the query parameters.
merchant_type Contains an individual merchant_type. Attributes:

* id: A unique id for the merchant_type. You can pass this in as a merchant_type_id to filter products to this specific merchant_type.
* name: The name of the merchant_type.
* product_count: The number of products matching the query for this specific merchant_type.

brands Contains top brands for products matching the query parameters.
brand Contains an individual brand. Attributes:

* id: A unique id for the brand. You can pass this in as a brand_id to filter products to this specific merchant_type.
* name: The name of the brand.
* product_count: The number of products matching the query for this specific brand.

suggested_merchants If the keywords match any merchant names, or have been tagged by PopShops as belonging to a specific merchant, this node will return any merchants that may be possible matches. This node will have child merchant nodes with attributes available on normal merchant nodes.
deals Contains deals available for products,merchants, and suggested merchants matching the query. Attributes:

* restrictions: Global restrictions that apply to any deal returned.

deal Contains an individual deal. Attributes:

* name: The name of the deal.
* description: A description of the deal.
* url: The redirect url for the deal.
* image_url: If an image is available for the deal, this will be a url for that image.
* specific: This is a boolean (true/false) indicating whether the deal is specific to a product, or applies to all products from the merchant.
* start_on: The start date the deal is valid.
* end_on: The end date the deal is no longer valid.
* code: Any associated code for the deal. This is a code that would need to be used to redeem the deal.
* deal_type_ids: The deal_type id indicating what kind of deal this is.
* restrictions: Any applicable restrictions unique to this deal or merchant.
* merchant_id: A unique id for the merchant.
* merchant_type_id: The id of the merchant_type the merchant of this deal belongs to.

Categories: MySQL, PHP, XML Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Mods To Cgi Search Script

May 28th, 2009 Comments off

Hi, thanks for looking at our project!

We are an auto classifieds web site. The web site’s search feature is run by a very simple perl script (search.cgi, attached) which queries the vehicle data that is contained in a tab-delineated, text flatfile database (not sql). The script returns results into an HTML “match template”, or a “nomatch” page if there are no results. The query is passed through the search URL. It’s very simple.

You can see an example of how this currently works by going to http://www.autopages.com/ and typing an automotive search term into the search box at the top.

Here’s what we need — we would like to to add several new capabilities to this search script:

1.) a “sort by” feature at the top of search results, that allows users to sort results by year, price, etc.

2.) Links for search results pages. In other words, if there are 32 records found in a search, and results are returned 10 per page, the results page should be able to have links to page 2 (results 11-20), page 3 (results 21-30), and page 4 (results 31-32). On any given page, the current page number should be displayed as a non-link, and the other pages should be displayed as links. This is something very typical, of course.

3.) If any vehicle in the search results contains “F” in column 11 of its record in the database, an icon should be displayed on that record in the search results. Any record that does not contain “F” in column 11 should not display this icon.

4.) Finally, we would like to have an “add to favorites” feature. Every record displayed in the search results should have a link that, when clicked, causes it to be added to a “favorites” list for that site user. We would like to do this the simple way, with cookies, NOT with a login system. There should be a “favorites” page that can be accessed through a link, and on this “favorites” page, the listings should contain links that allow them to be removed from the favorites list.

So, that’s it — those are the four things we need.

IMPORTANT NOTE:
I realize that all of this can be done easily by simply replacing the search script with a new one — there are hundreds of scripts with these features already written, and available for free. However, what we need is for OUR script to be modified with these new features. The reason for this is that, although it’s simple, our script contains many small functions that are customized to our site and very important — for example, it rewrites photo URLs, constrains overflow text, reformats prices, etc.

So, it’s important to us to retain our current script. We just want these new features added on to our current one. So please, no replacement scripts.

The attached archive (files.zip) contains the search script (search.cgi), the setup file (setup.pl), the database (database.exm) and the match template, so you can see how it all works. It’s very simple.

Please let me know if you have any questions … thanks!

Repair Script – Ad Submission

May 1st, 2009 Comments off

The project described below the ****** was completed in 2008. Errors have started to occur recently in the script and must be fixed immediately. The form that is processed by the script is http://www.newburyportmothers.com/submission.php.

Briefly, when a form containing the ad data is submitted two emails should be generated. One email is sent to the email address entered on the form with only the data from the form. This email is OK.

A second email is sent to the site owner with an attachment. This email is not being generated. This project is to debug the script to fix this problem.

This project is urgent and needs to be completed by May 3. I will provide all server login info immediately upon accepting a bid.

Below are the original project requirements:

*******************************************************
GENERAL : We are developing a website for a social group that sells ads for its newsletter. After payment is approved, the ad data is submitted via a form to a mySQL database. The ad copy is an image file that may be submitted with the form to the server. Emails to the submitter and administrator are generated after form data are successfully received. To manage the data, an administrator page allows a standard data base report to be generated for a given month/year and a second report to be generated for a range of months/years.
The development project is in two parts. The workflow below is described to give programmers a better understanding of the project requirements.
Part 1 – AD SALES
The site owner will provide a draft of the ad submission page with the sales form. The programmer will modify the form as needed, create the mySQL data base, develop the data base queries and develop the email processing on the server to implement the features that follow.
1. To submit and pay for an ad the user navigates from other site pages to a landing page that displays Terms and Conditions and the user must select an “I Agree” checkbox to proceed to the submission page. The programmer will not work on this page. The user clicks Next to go the submission form. A validation check is performed on the checkbox to allow the submission page to open. Most of the data entries on the submission form will require validation before the data can be sent.
a. The submission form contains text boxes to enter the required business information. The form also contains selectors for the ad’s size and the starting date and frequency the ad will appear. The programmer will need to ensure that only allowed sizes and frequencies are chosen and that the member discount is applied for pricing of the ad.
b. The form will have a yes/no checkbox to either submit the ad copy with the form or to submit it at a later time. This yes/no data must also be passed to the database.
c. The ad is normally submitted as an attachment to the form. Ads are image files. The form will have a file selector to browse and attach the file from the local disk. The programmer will make this file selector inactive by default so that the user has to choose the yes/no option. When the yes option is selected, the file selector is activated and the user can navigate on the local disk to select the ad file. The file extension is checked to confirm it has an EPS, JPEG or PDF extension. If validation fails, an error box pops open and the form cannot be submitted until the error is corrected.
d. The user chooses the ad size from a drop down menu or radio button list on the form.
e. Ad frequencies include standard half-year (5 months) and full-year (10 month) blocks and single months. Each block or single month plan has a standard price for each ad size. For the half and full year blocks only, both consecutive and non-consecutive, multiple month blocks are a frequency option that the programmer will have to implement. Block prices will be discounted for group members so there will have to be a selector form Members (non-members will be the default).
f. A start month/year will be selected.
f. The existing form will have selectors for all of the above options, but the programmer may have to develop logic to calculate the final price of the ad. The programmer will develop logic to display the final cost of the ad. The cost display should update dynamically when the ad size and/or frequency or member/non-member status is changed.
g. The user clicks on the Pay button and is sent to Paypal with the cost data. The form data is NOT SAVED on the mySQL server UNTIL the payment in step 2 below is completed.
2. The Paypal page is pre-populated with the correct payment amount calculated on the form. After payment is completed the user is returned to the site for further processing of the ad submission.
3. The user is returned to a thank you page on the website. When the page opens the following takes place:
a. All form data are saved to a mySQL database at the web host and the attached image file (if sent) is saved to a folder on server.
b. The programmer creates a server-side script to generate two emails after the data are saved:
– A formatted thank you email is sent to the submitter showing the ad cost, size, frequency and months that the ad will be in the newsletter.
– A formatted notification email is sent to the site owner with all form data as text (field name: data), including the image file if sent.
Part 2 – REPORT GENERATION (programmer to design web page interface and all code):
1. The site administrator securely logs in to the report page.
2. On this page are 2 report generation forms.
a. General Historical Report – the administrator selects the range of month/year dates from a starting date – ending date menu and clicks on the Generate Historical Report button. An Excel style report page is generated that shows all fields for each record. The order of the columns is the same as the submission form. The administrator clicks on the Send Report button and the report is sent as a CSV file attached to an email to the administrator.

b. Monthly Report – This is a standard report for a selected month/year that is similar to the General Report but shows all ads that should run for the selected month (example: an advertiser places a 5 month ad for Jan-May. In March, the Report is run to see what ads should be included in the April newsletter, the administrator needs to see all ads that were submitted for print for that month, regardless of when the ad was originally submitted). The browser displays the report as rows of data with column headings. The administrator clicks on the Send Report button and the report data is sent to the site administrator as a CSV file attached to an email.

– Note: This a an revision of a project that was recently posted. To avoid confusion while the requirements were changing I decided to cancel and resubmit the project –

GENERAL : We are developing a website for a social group that sells ads for its newsletter. After payment is approved, the ad data is submitted via a form to a mySQL data base. The ad copy is an image file that may be submitted with the form to the server. Emails to the submitter and administrator are generated after form data are successfully received. To manage the data, an administrator page allows a standard data base report to be generated for a given month/year and a second report to be generated for a range of months/years.

The development project is in two parts. Here is the workflow we want to implement for both parts:

SALES { NOTE- A draft of the sales page form will be provided to the developer

Categories: mSQL, PHP Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Adf/xml Mod To Php Sendmail

April 22nd, 2009 Comments off

Hi there, thanks for looking at our project!

We currently have a simple script on our site called contact.php, which handles input from a form and sends an HTML email to an address specified as a hidden field in the form.

We would like to add a new function to this script. This is what we would like:

- At the top of the script, there should be a config area, where a set of email addresses will be located. Each email address should have an array that contains a SECONDARY email address. Once you have created a working example, the correct data for this section will, of course, be set up by me, the admin.

IF the script is run from the form, AND the email address specified is NOT one of the addresses in the config list, then the script should function normally, as it does now.

However, if the script is run from the form, AND the email address IS one of the ones in the config list, then the script should send the email as normal, BUT it should ALSO send a SECOND email.

The second email should be generated by using data that is passed through from these and additional hidden fields in the form. This second email should be sent to the SECONDARY email address, corresponding to the primary email address in the config part of the file.

The script should propagate this data into an email, as follows:

<code>

<adf>
<prospect>
<requestdate>2000-03-30T15:30:20-08:00</requestdate>
<vehicle>
<year>1999</year>
<make>Chevrolet</make>
<model>Blazer</model>
</vehicle>
<customer>
<contact>
<namepart=”full”>John Doe</name>
<phone>393-999-3922</phone>
<email>[customeremail]</email>
<comment>Keyless entry essential</comment>
</contact>
</customer>
<vendor>
<vendorname>Dealer A</vendorname>

List Structure

April 14th, 2009 Comments off

List structure exercise 1

Categories: C/C++ Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

List Structure

April 3rd, 2009 Comments off

List structure exercise 1

Categories: C/C++ Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Sales C++ Project

March 21st, 2009 No comments

Problem Description

1. Any compiler for C++ is fine just dont use visual c++ coding
2. One large chemical company pays its salespeople on a commission basis. The salespeople each receive $200 per week plus 9 percent of their gross sales for that week. For example, a salesperson who sells $5000 worth of chemicals in a week receives $200 plus 9 percent of $5000, or a total of $650. Develop a C++ program that uses a while statement to input each salesperson’s gross sales for last week and calculates and displays that salesperson’s earnings. Process one salesperson’s figures at a time.

3. You must create 3 separate files. The Sales.h file contains the definition of the class Sales. The Sales.cpp file contains the member-function definitions of the class Sales. The lab2.cpp file contains the main function.

Problem Requirement

a) You must create 3 separate files as stated above.

b) Your program should have one member data named grossSales.

c) Your program should have a constructor, a get and a set member function for the data.

d) The result salaries must be displayed in 2 decimal places.

e) Your program should run correctly with the same inputs and outputs as given in the sample run.

Bear