Archive

Posts Tagged ‘rec’

Mysql Item Report On 4 Tables 2

June 22nd, 2011 Comments off

Four Tables. Will require addition and subtracting. See attached 4 tables.

Main table = Item_List.
Table = Item Adjustment
Table = Item Received
Table = Item Sold

12 Columns

From TABLE Item_List : ItemId, ItemNum, Cost, SalesPrice, Notes.

From TABLE Item Adjustment: Adj_Loc, Adj_Q.

From TABLE Item Received: Rec_Loc, Rec_Q.

From TABLE Item Sold: Sold_Loc, Sold_Q.

The col Current will = Adj_Q + Rec_Q – Sold_Q = Current_Q

All math based on the total sum for each location in TABLES Adj+Rec-Sold and showing all Item_List.ItemID’s

Structure Example:

ItemId | ItemNum | Adj_Loc | Adj_Q | Rec_Loc | Rec_Q | Sold_Loc | Sold_Q | Current | Cost | SalesPrice | Notes

Categories: Math, MySQL, Report, SQL, Tables Tags: , , , , , ,

Mysql Item Report Base On 4 Tables

May 28th, 2011 Comments off

Four Tables. Will require addition and subtracting. See attached 4 tables.

Main table = Item_List.
Table = Item Adjustment
Table = Item Received
Table = Item Sold

12 Columns

From TABLE Item_List : ItemId, ItemNum, Cost, SalesPrice, Notes.

From TABLE Item Adjustment: Adj_Loc, Adj_Q.

From TABLE Item Received: Rec_Loc, Rec_Q.

From TABLE Item Sold: Sold_Loc, Sold_Q.

The col Current will = Adj_Q + Rec_Q – Sold_Q = Current_Q

All math based on the total sum for each location in TABLES Adj+Rec-Sold and showing all Item_List.ItemID’s

Structure Example:

ItemId | ItemNum | Adj_Loc | Adj_Q | Rec_Loc | Rec_Q | Sold_Loc | Sold_Q | Current | Cost | SalesPrice | Notes

Categories: Math, MySQL, Report, SQL, Tables Tags: , , , , , ,

Flex As3 Video Rec-streamer

February 22nd, 2010 Comments off

This is a RUSH project.

Please see the attached pdf for basic funtionality of this browser based video capture app, that has both audio and motion detection and streams video to our wowza server.

If you are not familiar with motion detaction techniques, here are a couple of samples.
http://blog.soulwire.co.uk/code/actionscript-3/webcam-motion-detection-tracking
http://www.laserpirate.com/as3edgeandmotion/

This app needs xml supplied parms for frame rates etc.

Please do not just dump your resume online. If you have a working version similar, you have priority.

Open PMB with Questions

Typing Up 50 Min. Speach Rec.

August 21st, 2009 Comments off

Hi,
I need a normal 2 person conversation, recorded in WMA, typed into a word (text) file.
This is a typing job, not programming.
The length of the recording is ca. 50min., the pace of the conversation is normal to slow speech in English.
The audio file is 35MB in size and of good understandable qualit, with one speaker being very clear and the other slightly distorted (particularly in the first few minutes) with a little mid England accent.(I realy don’t think the accent should be a problem.)
The file will be made available though a rapidshare link.
Spelling needs to be of cause correct.
Today is the 21th Aug., I would need this done in 1-2 days, ideally 1 day.

Regards,
Pajam

Categories: Writing Tags: , , , , , ,

Typing Up 50 Min. Speach Rec.

August 20th, 2009 Comments off

Hi,
I need a normal 2 person conversation, recorded in WMA, typed into a word (text) file.
This is a typing job, not programming.
The length of the recording is ca. 50min., the pace of the conversation is normal to slow speech in English. The audio file is 35MB in size and of good understandable quality.
Spelling needs to be of cause correct.
Today is the 20th Aug., I would need this done in the next 2-3 days.

Regards,
Pajam

Categories: Writing Tags: , , , , ,

Flash Bball Rec League Site

August 11th, 2009 Comments off

A friend of mine has asked me to develop a basketball league site, that allows game results to be added. The results added then can be used to display the current standings and some player points statistics.

I would normally have done this myself; however, I am working on a very large dynamic flash site that will be outsourced in the next week or two. I am using this opportunity to try outsourcing for the first time, and to hopefully establish a professional relationship with a company that will carry over onto the next project.

This project has been designed to act as a precursor to the larger project, touching on some of the smaller points that will be covered. This is why Flash was chosen as the development tool.

An expert level of Action Script 3 knowledge will be required, as well as experience in muniplulating PHP and MySQL as a backend to Flash is also a must.

The future project will require these same quailifactions, along with experience with PayPal. Paypal will not be used on this project; however, experience could effect which developer is chosen.

Attached is a FLA file that was quickly created to help describe the requirements in greater detail, along with a layout to assist in the development. This does not require a member login, only a static password authentication.

If the requirement is not easily understood, please ask.

Hunter

Stdnt Rec Rprt Prog W Sorting

May 11th, 2009 Comments off

Using struct and class data type to write a simple student records report program with sorting function
This project is an elaboration of Project 3 ( Student Records Report Program). However, it requires using selection sort algorithm to sort student records and print out student records in a certain order; and using cstrings stead of strings to store student names and SSN numbers.
Use Visual C++ to write your program.
As records secretary for Cougar High School, you have been asked by the principal to prepare a report on the grades of some of the school’s top athletes. Specifically, you must print each of the athlete’s average letter grades based on their scores from three academic courses. Input will be taken from the file stufile.txt, which is organized as follows: Each athlete in the file has four lines of information recorded – name (at most 20 characters including the comma and white space), student ID (SS#), class rank (1=Freshman, 2=Sophomore, 3=Junior, 4=Senior), and the three scores. Information for at most 15 athletes is stored in the file, but the first line of the file contains an integer showing the exact number of athletes.
Use struct data type as data representation of a student record and use separate fields for first names and last names. Then, define a class to hold an array of student records and encapsulate some member functions which will be used to do the specified reporting as described in the following. Look at the sample specification file proj2_prototype.h for the suggested data type declarations.
You can assume that all scores are integers from 0 to 100. Output should be printed out on screen. Athletes’ names ID numbers, class, ranks, and, letter grades are to be printed twice, the first time in alphabetical order by last name, with “A” students first, “B” students second, and so forth. In cases when the last names of more than one students are the same, sort the student records with the same last name in alphabetical order by first name. The second time they are to be printed in alphabetical order by last name, with freshman students first, sophomore students second, and so forth. Also sort student records by first names in cases when last names are the same. (Note the difference from Project 1.) Note that the students’ names are printed out in the format of “Lastname, Firstname”, e.g., “Zitt, Kevin”; the column of student ID numbers should be aligned at least one space beyond the maximum name length, the column of class ranks should be aligned at least one space beyond the column of student IDs, and the column of grades should be aligned at least one space beyond the column of class ranks.
A sample implementation file of the class member functions and a main function is written in file proj2_prototype.cpp. In the main function, there is an outline of the suggested steps to do the reporting job.
Turn in a print-out of the program source code and a diskette containing the header (.h) file, source code (.cpp file), and the I/O files.

Bear