Topic: ** SMTP Alerts Based on Custom Conditions **
I don't see any requests for this, and think it would be a great addition to Tracmor.
So here's the idea. You have an option in the Admin panel that allows you to create conditions using SQL like queries. If the condition is met an SMTP email is sent to you notifying you of the condition and value of the item(s) you are monitoring. These notifications could be used to monitor assets, inventory, and shipping/receiving.
You could have a select box with predefined fields, use check-boxes, or separate input fields to build the query. I've included an example below of what one of the queries might look like.
Asset Example:
If the count of an asset reaches a given threshold an email alert is sent. This allows users to be proactive with their inventory/assets.Syntax: IF value(id) COUNT OPERATOR INT
End User: IF AssetModel(75) COUNT <= 50
Inventory Example:
Inventory is considerably more difficult as the quantity of a given model is stored in a separate location, but I would think a query similar to this wouldn't be too cumbersome for the end user.Syntax: IF location(id) value(id) COUNT OPERATOR INT
End User: IF Location(3) InventoryModel(15) COUNT <= 250
The system would become increasingly functional if you allowed the end-user to use WHERE AND OR operators making the queries more complex and granular.