I'll-Be-Back

179 reputation

bio	website
	location
	age
visits	member for	1 year, 6 months
	seen	Mar 17 at 10:45
stats	profile views	23

	179 reputation	bio	website		visits	member for	1 year, 6 months
5 badges		location			seen	Mar 17 at 10:45

summary answers questions tags badges favorites bounties reputation activity

45 Actions

suggestions reviews revisions comments badges posts accepts all

Oct 6	accepted	How to store formula method in the table
Oct 3	comment	How to store formula method in the table Yes @grid :) Basically something like Admin click on the formulas setting page on the website and create a formula (Choose Minus, Plus, Fields) and save it. Then go to any category and select a formula from a dropdown to apply. Do you get the idea?
Oct 3	comment	How to store formula method in the table @grid There is no need to use `eval()` function but something like that yes. Basically on the Admin site, admin select the formula setting on the site.
Oct 3	revised	How to store formula method in the table added 205 characters in body
Oct 3	comment	How to store formula method in the table For example Admin on the websute can select a formula setting on each category and save it. The formula setting could be saved in `category_formula` table but how the table should be designed.
Oct 3	comment	How to store formula method in the table Thanks for the answer. Is there alternative way to keep a list of formula records in a `category_formula` table for example? I am not sure what fields do I need but you could answer that. I would use PHP to calculate the sum.
Oct 3	comment	How to store formula method in the table categories will be subject to change however I should be able to apply same formula to many categories if I wanted to. If the formula change - I would create a new formula record and then update on existing categories records.
Oct 3	revised	How to store formula method in the table added 4 characters in body
Oct 3	asked	How to store formula method in the table
Sep 17	revised	Mobile Phone & Tariffs added 6 characters in body
Sep 17	revised	Mobile Phone & Tariffs added 377 characters in body
Sep 17	comment	Mobile Phone & Tariffs Description part into columns is a good idea and I will look into that. My question was is the relationship design between phone, tarrif, network and saleType is ok? I assume you understood from my tables design? Basically operator can select a retailer which then select Mobile Network.. then select what type of sale (eg: consumer upgrade) and then select phone with related related tariffs. Depending what tarrifs and/or phone they have selected - operator gets number of points.
Sep 17	asked	Mobile Phone & Tariffs
Mar 6	asked	Database Design - Employee Clocking In and Out System
Feb 15	comment	Generating Invoices and Tracking I have managed to translate your SQL Server example into MySQL. I went through and I understood very well now. What would `AllocationType` would be if I want to send client money? Do I need to insert into `CashPayment` table as well (let say paying them via BACS)?
Feb 15	accepted	Generating Invoices and Tracking
Feb 15	revised	Generating Invoices and Tracking deleted 7 characters in body
Feb 15	revised	Generating Invoices and Tracking added 130 characters in body
Feb 15	asked	Generating Invoices and Tracking
Feb 13	comment	Tick boxes and Dropdown `extra_id`'s (ketchup, Mayo, etc) already mapped into group (see `groups` and `groups_extras`) - so therefore use `groups_id` to apply in `items_options_extras` or `items_options_extras`