inventory

JavaScript avatar with items question

I'm trying to create a javascript avatar. E.G with Head Items, body items etc... I have a PHP script that queries the database and retrieves the current items the avatar/user is wearing, it's response is in a serialised array. The item/avatar images are in E.G: http://blahblahblahBlah.com/graphic/itemtype/id.png How would I create an "i...

implementing inventory application in android with sqlite database

Hi every one, I'm new to android and want to develop application to manage inventory on mobile. I can run the application "Hello world" and can communicate with database as well. But i'am having problem with navigation and forms and controls. for my application i want to store the inventory data in database and retrieve in a grid for...

Reccomendations for a Museum / Inventory management system that is web based and open source

Looking for a content management system that can be used by museum curators to keep track of inventory. Ideally there are a small set of features: Name / Description / Catalog number Searching Tools Does not need a public view. Pure internal is fine Php / Mysql backend So far the one I have found is http://www.collectiveaccess.org/ ...

Running Counter in SQL 2008

Hi all, I'm trying to establish a temp table for a running inventory demand report in SQL 2008. I can get the results that I am looking for until I hit an invoice with multiple lines. Here is the code so far: --Gather Current Order Data DECLARE @b TABLE ([Planned Shipment Date] DATE, [Order] VARCHAR(15), [Line Number] VARCHAR(15), [L...

SQL conundrum, how to select latest date for part, but only 1 row per part (unique)

I am trying to wrap my head around this one this morning. I am trying to show inventory status for parts (for our products) and this query only becomes complex if I try to return all parts. Let me lay it out: single table inventoryReport I have a distinct list of X parts I wish to display, the result of which must be X # of rows (1 r...

AS2 Attach Movie and LoadMovie

Hello, I have the following code: var theItems:String = "4 3 6 19 20 40 41 4 3 6 19 20 40 41" var titems = theItems.split(" "); var nextLine = 0; var LastSlotID = 0; var LastX = 0; var LastY = 0; var slotsM = 0; for (var i in titems){ var thisitem:Number = titems[i]; ThisSlotID = LastSlotID + 1; if(LastSlotID == 0)...

In Magento, how do you filter a product collection by the manage_stock field?

I've built an inventory update script - where I fetch a product collection in Magento, and iterate through the result set, updating product inventory (based on a separate inventory feed) as I go. I can fetch the product collection no problem. However, I only want to get products which have the "Manage Stock" field (a dropdown in the ad...

Windows hardware / device driver report / inventory

I'm trying to figure out, how to create a hardware inventory / report on Windows 7 including: All devices in / attached to a system. Driver / device information per device (Device Type, Manufacturer, Driver Version, Driver Date, Driver Provider, Driver Files, Hardware Ids) If the drivers is digitally signed (WHQL) / has a valid signat...