flipandboef
Posts: 107
|
| Posted: 11/29/2006, 1:27 PM |
|
This is what I like to accomplish.
I have 3 kinds of users: Customers / Clients / Editors
Clients and editors can search our list of products, no problem there.
However, on occasion we have a customer that would like to see a list of products we have that have specific needs (for example a color)
Here come my question:
Is it possible to create a grid that can be edited by the Editors? With other words: I want the Editors to be able to select the products that the editor wants to show to a customer.
Example:
Customer asks to see a list of products that are Black and are made from steel.
The editor then logs in into our back-end maintenance of our site and enters these criteria. Searches out hwat pruduct he likes to show this customer (so not all products that are black and steel!) and selects the product numbers (unique field) that have to appear in the grid.
Then a page needs to be generated where all products that are Black and Steel show up, with only the products the Editor selected to show.
This page only(!) must be accessable by the customer who requested this.
At this moment, I constantly do it manually for all our editors by creating a grid with the correct "Where" criteria, generate the page and give them the link to it.
It would be so much nicer (and faster!) to have the editor do this, who of ocs has no CCS 3.1.
Anyone ever done something like this or perhaps anyone has an idea of how to accomplish this?
|
 |
 |
Alistair McFadyen
|
| Posted: 12/03/2006, 3:29 AM |
|
This is maybe a bit long-winded, but would work:
Create a table the includes fields for all of the criteria the editor needs to select: colour, material, size, whatever.
Create an input (record) form that allows the editor to create a custom "where" statement by selecting the appropriate criteria - use check boxes or selects to control the values that get recorded. In this way, the editor doesn't select the product ids but creates the basis for the query that will select the products.
The editor could assign a reference to the new record, which might actually be the cutsomer's name, lets say "smith", or could use the record id after it has been created.
customer accesses mysite/products/productpage.asp?customerref=smith
write some custom code that gets the smith record (it would need to be a bit more unique than that!) and parses the applicable fields into a where clause before applying it to the select query and listing your products.
I hope this is clear (as mud, probably). If you think you can use the idea and need any more info email me at amcfadyen@netfocus.biz and I'll be glad to help.
|
|
|
|
flipandboef
Posts: 107
|
| Posted: 12/04/2006, 7:20 AM |
|
Hi Alistar,
Thanks for your idea. Actually I was not aware you could create a "where" statement outside CCS, so this is absolutely a great idea. Since I'm still a "rookie user" i will get into searching this out, but I see your idea (get what your saying) and think that indeed this might work.
I appriciate for your reply and I'll let you know how it turned out.
Thanks for the help 
|
|
|
|
|
