meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 5 months |
| seen | Mar 17 at 10:45 | |
| stats | profile views | 23 |
|
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 |
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. |
|
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. |
|
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 13 |
comment |
Tick boxes and Dropdownextra_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 |
|
Feb 13 |
comment |
Tick boxes and Dropdown Second question: If multiple items have same options name and if I've rename the option name from the backend (eg: Donner to Donner Special) - I don't want all items that have same Option name to be replaced.. |
|
Feb 13 |
comment |
Tick boxes and Dropdown Thanks you very much for detailed response. Just two questions. items_extras and items_options_extras tables you have provided. I think you meant extra_id to be groups_id? |
|
Feb 13 |
comment |
Tick boxes and Dropdown There is no need for boolean field. Check groups_extras_options result. It apply item to the group's (item to many group's) |
|
Feb 13 |
comment |
Tick boxes and Dropdown Still no reply?! |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) @Dtest wow!! thank you very much, updating performance is very fast now :) about 200 updates a second.. I followed your instruction and it work! :) I thought adding index on 'mobile' and 'status' would help the `UPDATE' to find the record quick but that was not the case hmmmmm. Thanks again. |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) Thanks I will read more updated advice now.. I've just dropped 'status' index and ran the scripts again - it did not improve the UPDATE performance.. still a lot of queues in the mysqladmin proc. I have just updated my question with iostat, please check if that causing problem? |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) I am sorry, I meant status - yes I understand what Primary key does. |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) Would primary key take advantage over number ? |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) @ypercube it check if the number is valid or invalid from externally (API). If there is an error then return into $error but this is not an issue. |
|
Dec 21 |
comment |
Improve `Update` performance (rows locking issue) @ypercube I have updated my question, how its generated. That is good ideas about grouping but there will be like 10 different type of error texts... and also without error. How can that be archived? |
