Category: MYSQL Projects

MYSQL Projects

Mysql Stored Procedure

Mysql Stored Procedure
Hi,

I need to have a stored procedure created where I take, on 15 minute intervals, data from a couple of tables and run them through a small formula, and update a series of records with the result.

Specifics are that two pricing tables (silver and gold) get a price update on 15 minute intervals, and those prices are “cleansed” and then applied to the relevant product records (those that are marked as either au or ag).

Thanks.

Improve Install Sql Data Perl

Improve Install Sql Data Perl
Improve install SQL data PERL

The code installs the SQL data into the database.

The host does not allow remoter SQL access.

PERL

Any code should have minimum, or better still, reduce), impact on the host server. (Shared host).

The code supplied functions with the following issues that require your fixing:-

When run the code displays aright at first but after about an hour the display goes blank, the code still runs even though the display is blank and the process finishes after about 4 hours.

The code have a lot of delays, (Perl sleep), and some disconnects, a delay, then reconnects this is done to reduce impact on the host.

The code has, (commented out #), a number for display messages to show progress during the install of the SQL data. These would stop displaying after about one hour and now a file is created as a record of progress. The code emails me when complete.

Once you fix the going blank display the progress messages would be uncommitted so that the progress may be viewed.

So your tasks are:

Stop the display going blank so that progress messages may be viewed.

Spped up and Reduce impact on the host.

Advice of I could remove the delays, (sleep), to speed up the progress while reducing impact on the host.

The code:

Prepare outside this code :Zipped SQL data are uploaded as zip files.

How the code basically works.

The uploaded zipped SQL files are uncompressed, one at a time.

The uncompressed file is read in one line at a time writing to a temporary file of 2000 lines, (reading in the whole file caused memory issues during local testing). This is done to reduce impact on the host.

The temporary file is then installed in to the SQL database using the >>>load data local infile<<< command.

This repeats until all the SQL is installed.

Web-based Emr Software (java)

Web-based Emr Software (java)
Greetings Vendors:

In an ongoing effort to provide cost-effective solutions to help doctors’ offices become technologically state-of–the-art, we, MedicEMR is taking the lead in the industry by unveiling an innovative, online, Total Practice Management™ service designed to revolutionize the doctor’s office.

MedicEMR Online combines scheduling, electronic medical records, prescription writing, letter writing, billing, and image capture functions in a single Application Service Provider (ASP) service.

This advanced approach to practice management offers doctors the ability to accelerate the note-taking or transcribing, and eliminate paper filing functions currently being used in the obsolete paper chart system.

Doctors using the online version simply log-on to their own personal, totally secure, browser-based database at the start of the workday and begin recording patient notes into the computer for each patient visit. At the completion of the visit, it is then saved and is immediately ready to be filed as an electronic claim.

To view a working sample of the technology please visit http://www.Unicharts.com) and then look for Instant Test Drive link there. Click on it and see the functinality very carefully. I need exact same look and all features as there. So plz be careful to look everything before bidding.

Also see all screenshots of the software for design and development:
http://www.unicharts.com/emr-software-screenshots/emr_screenshots.html

This new system allows doctors to provide better care for their patients with less work and cost.

Essentially, doctors can access a concise summary of all information pertaining to an individual patient’s care, including an efficient view of past hospital visits, lab test results, previous medications and much more. They can even view the length of time since a patient’s last office visit, allowing doctors to better determine the need to see a patient before refilling a prescription.
The system is tailored for the independent physician or small group of up to 12 physicians. Aside from positively impacting patient care, other goals of the service are to enable the office to become virtually paperless inside of four months, improve patient record-keeping, enhance the communication between the doctor and his patients, and eliminate the daily chores of filing, copying, data re-entry and transcribing.

Thank you,
SK

New Joomla Project

New Joomla Project
We need the following project components built in the Joomla platform. Your bid must include the cost for any associated extensions that would need to be purchased to meet the project requirements. Please bid a total amount for both phases as well as the cost to do each phase individually. The timeframe for completion of Phase 1 is 2 weeks.

Please contact us regarding any questions.

PHASE 1: Below is a list of essential components that are considered immediate needs and should be completed before the initial launch of the new website:

a. E-Giving (e-Commerce) – The new website should include the capabilities for electronic giving which will be a new feature for the website.

b. Online store (e-Commerce) – The current website consists of an online book store function which needs to be retained on the new website.

c. Interactive Calendar – The website should have a visual calendar that is interactive which will provide pop-up details about events and meetings.

d. Mobile alert notifications – The website should have an email and text alert function which will allow visitors of the site to request to be notified by email or text, about events, updates, schedule changes, etc.

e. Internal Portal – The new website should be setup with internal portal capabilities to provide a central location for church leaders and administrative staff to post information, store and maintain documents, and submit requests.

f. Security – We would like to ensure that the website has strong security implemented in the design.

g. Photo Gallery – We currently have a photo gallery and would like to ensure that the new website has a section as well. The layout can be changed and re-designed.

PHASE 2: After the initial launch of the website, there are certain items and capabilities that are desired. These items are considered short term needs (tools and functionalities that are desired 1- 6 months after the initial website launch :

a. Social networking plug-in capabilities – The new website should have a section or link where people can be directed to the approved social networking sites. Facebook, Ning, MySpace, and Twitter are some of the social network plug-ins we would need.

b. Video capabilities – The new website should have the ability to handle streaming video formats ( i.e. avi, podcasts, You tube).

c. Online member business directory – A directory is currently being developed and we would like the new website to have the ability to access this directory online. More information will be provided when the directory is completed.

d. Online registration – The desire is to have a page where people can sign up and pay for classes online.

e. Request Page – There is a need to have the functionality where people can log in to request things such as meetings.

Finally, there are long term tools and functionalities that are desired, which are considered low priority, that we would like to implement only if time and budget allows. Those items are listed below so the vendor is aware:

a. Blog Integration – We would like approved users to have the ability to create a blog.

b. Application development – We are interested in creating a mobile application where viewers can look up public organization information or get details on events. This is still in the developing stage and we would like discuss the possibilities.

c. RSS Feed – The desire is to have a feed available to distribute organization announcements and other web content.

Telebid Auction Script Problem

Telebid Auction Script Problem
I have a cakephp based Telebid auction script and the bidbutlers do not bid. Also the auctions do not close properly.

This might be related to the 4 cron jobs

curl -s -o /dev/null http://www.domain.com/daemons/bidbutler
curl -s -o /dev/null http://www.domain.com/daemons/extend
curl -s -o /dev/null http://www.domain.com/daemons/autobid
curl -s -o /dev/null http://www.domain.com/daemons/close

PM me for more info.

Website Using Drupal 2

Website Using Drupal 2
Hi,
I want to get a site done. After much researching I have concluded that doing it with Drupal will be the best option.

I need a site with the following modules:

User Groups:
One can become a member or a fan. Members request the group admin for membership and vice versa. Any User can become a fan

Blog:
Every user should have a blog.

Polls:
There should be options for users to create polls. The results should be generated in such a way like age-groups,gender,location which the user gives in his PROFILE.

Product Browser:
A Profile for products. And Product comparison.

Product Recommendation:
The user fills out a form of specifications and products relevant to that specification shows up.

User Profiles:
The users will have a profile with their blogs,photo albums. A User will also have Fans.

News & Events:
A news and events module fully controlled by the admin.

Messaging:
Groups can message its members & fans. Users can message each other. Messages are private!

I found all these modules already available in the Drupal website. So I guess All you got to do is connect them all and do some modifications wit respect to my scenario.

Please make a reasonable bid. Thanks.

Project2

Project2
we need a simple PHP script for a college project as per attached image shown.

2 basic Webforms and a display table with the relevant data displayed.
Webform 2 must generate a SKU number with the given format when saved.
The 2 MySQL tables must be created with (PK & FK) relationship and the
database script and connection must be included in the project.

server: LAMP
timeframe: ASAP

we would like to see it working on your server in demo before purchasing/transfering of funds.

Online Auction Site

Online Auction Site
I’m looking for a team to design and create a unique penny auction site. I’m not looking for a clone of existing sites like Swoopo, but a unique, custom built site designed to my specifications. You will need to show me examples of your work using PHP, MySQL, Ajax, and integration of social networking tools including real time chat boxes, instant messaging, twitter and social bookmarking integration, etc. You will be designing three unique interface: a buyer interface, a seller interface, and an admin. The site will need authorize .net, and paypal or google checkout integration. This will be a long term relationship for the right team.