All Products Listing

8 posts by 2 authors in: Forums > CMS Builder
Last Post: April 5, 2008   (RSS)

By jposwald - March 31, 2008

Hello there, we are testing your product and really it's excellent, I have 2 questions:

Question 1:

I have a site to sell 3 Categories of Services, and each Category has 4 or 5 products, for ex:

1- Online Courses.

http://www.worldwidetrainings.net/EL_Psicologia_Clinica.php

http://www.worldwidetrainings.net/EL_Gestion_Humano.php

http://www.worldwidetrainings.net/EL_Management.php

http://www.worldwidetrainings.net/EL_Calidad.php

2- Presencial Courses.

3- Enterprise Courses.




I don't know if i'm doing the right thing so I answer you,

I've created 4 tables in the CMS to list each Products of Online Courses Category:

Is it fine? or I have to add a List Field and create only one table?

Because I want to list all Online Courses in one page, and I don't know how...

Question 2:

In each Products Category, for ex: http://www.worldwidetrainings.net/EL_Psicologia_Clinica.php I want to put 2 text links to allow website users to Sort by Date Desc or Name Desc, refreshing the records list, is it that possible?

Thank you very much, Juan.

Re: [jposwald] All Products Listing

By Dave - March 31, 2008

Hi Juan,

I'd try creating just 2 sections (tables) called Courses and Categories.

In "Categories" create a field for "Category Name" (and any other fields you need).

In "Courses" create a list field for "Category Num" and set the List Options to "Get options from database" and select your categories table, field num, and field for "category Name".

Then, when you edit your Course record you should have a pulldown for categories that you can select from.

Your course viewer (courseList.php or whatever you name it) will list all courses, and you can limit that by adding this on the url: courseList.php?categoryNum=2

Hope that makes sense. See if you can get that far and then we can work on the sorting. Let me know if you have any questions or need more explanation for that.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] All Products Listing

By jposwald - April 1, 2008

Dave, great, I did it.

I have 2 questions:

1) Inside the CMS when I go to Courses Menu that I've Created I put 6 ListPage Fields, but the Category Name Row shows me Numbers (I think it could be records num) instead of the name of the Courses from list field.

Can I fix it? and show the Category Name instead numbers.

I attached a Photo: (q1.gif)

2) I need that the full list CourseViewer (in this case: http://www.worldwidetrainings.net/EL_Listado.php) when a User hit "See more / Ver mas" link do not take them to $options['viewerUrl'] = 'EL_Listado_ver.php', I need to take them to specify URL depending the Course.

For ex: if a user clicks in Management's course "Ver Mas" link, take him to http://www.worldwidetrainings.net/EL_Management_ver.php?Curso_1-6/, not to: http://www.worldwidetrainings.net/EL_Listado_ver.php?Curso_1-6/

It's that possible? or you have any other idea? I want to make that because I want to show specifics images and links into each specify course URL, I do not how to make it in another way...

Thank you Dave,

Juan.

PS: if this enquiries requires a consulting hour charge, please do not hesitate to tell me.

Best Regards,
Attachments:

q1.gif 55K

Re: [Dave] All Products Listing

By jposwald - April 1, 2008

Dave, great I did it. Now we pass to Sort by Date and Sort by Name thing in Viewer Pages.

Re: [jposwald] All Products Listing

By Dave - April 2, 2008

Great, so to sort by date on the list viewer we'll make it so you can change the sort order by adding ?order=date or ?order=title and so on to the url. To do that add this below $options['orderBy']:

$options['orderBy'] = '...';
if (@$FORM['order'] == 'date') {
$options['orderBy'] = 'date DESC, title';
}
else if (@$FORM['order'] == 'title') {
$options['orderBy'] = 'title';
}


Then update the fieldname and orderBy values (in red) to have whatever values you want. The first (original) orderBy is the default. Then if you link to the page with ?order=date on the end it will use the new orderBy you specify below.

How that makes sense. Let me know if you need anything else. :)
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] All Products Listing

By jposwald - April 4, 2008

Dave, this CMS is excelent, still needs some features, but we are sure, you are going in right way.

We are making the first e-learning site for Central America, and also will sell courses to United States, with Saba association.

I think it going to be a huge iniciative to use your CMS to this high traffic sites, we are all going to learn from it.

My programmers are testing search scripts, so I gonna let you know which one was the best to use with this CMS.

I will have some more questions for sure, but instead so, I going to advise you when the site is finished to see it.

Best Regards.

Re: [jposwald] All Products Listing

By Dave - April 5, 2008

Sounds good! :) I've created a thread for feature requests so feel free to post any ideas or suggestions you have there.

Looking forward to seeing your site. Let us know when you need more help! :)
Dave Edis - Senior Developer
interactivetools.com