list categories

10 posts by 3 authors in: Forums > CMS Builder
Last Post: February 8, 2010   (RSS)

By jjem - January 27, 2010

Hi,

I would like sort records the list view like following:

Category 1
Sub Category 1
Product 1
Product 2
Product 3
Sub Category 2
Product 1
Product 2
Product 3

Category 2
Sub category 1
Product 4
Product 5
Product 6

I did start to do it manually like this

<!-- Solo Records -->
<h2>Solo recording</h2>
<?php list($discographyRecords, $discographyMetaData) = getRecords(array(
'tableName' => 'discography',
'where' => 'solo_orchestral = "solo"',
)); ?>
<?php foreach ($discographyRecords as $discographyRecords): ?>
<?php echo $discographyRecords['orchestra'] ?><br/>
<?php echo $discographyRecords['conductor'] ?><br/>
<?php echo $discographyRecords['title'] ?><br/> etc
then

<!-- Orchestra Records -->
<h2>Orchestral Recordings</h2>
<?php list($discographyRecords, $discographyMetaData) = getRecords(array(
'tableName' => 'discography',
'where' => 'solo_orchestral = "orchestra"',
)); ?>
<?php foreach ($discographyRecords as $discographyRecords): ?>
<?php //echo $discographyRecords['orchestra'] ?><br/>
<?php echo $discographyRecords['conductor'] ?><br/>
<?php echo $discographyRecords['title'] ?><br/>

I cannot find anything on this forum where I could start to dynamically set this up. Any hint would be great... Thanks for your help

Re: [gkornbluth] list categories

By jjem - January 28, 2010 - edited: January 28, 2010

Thanks Jerry,

It definitely got me closer. The screenshot 1.png is what I get. Screenshot 2.png is what I try to achieve. So it is like a menu tree, but the titles of the articles have to show up directly under the categories or subcategories.

Here is the code I used:
<ul>
<li><a href="?">(All Articles)</a></li>
<?php foreach ($cd_categoriesRecords as $categoryRecord): ?>
<?php echo $categoryRecord['_listItemStart'] ?>
<?php if ($categoryRecord['_isSelected']): ?>
<b>
<?php endif ?>
<a href="?category=<?php echo $categoryRecord['num'] ?>"><?php echo $categoryRecord['name'] ?></a>
<?php if ($categoryRecord['_isSelected']): ?>
</b>
<?php endif ?>
<?php echo $categoryRecord['_listItemEnd'] ?>
<?php endforeach ?>
</ul>
<!-- content -->
<?php foreach ($discographyRecords as $record): ?>
<?php echo $record['title'] ?><br/>
<?php endforeach ?>
<?php if (!$discographyRecords): ?>
No records were found!<br/>
<br/>
<?php endif ?>
<!-- end content -->
Wondering if I could integrate the content part into the menu. I actually do not need it as a menu, it is more a tree in list view. Any hint would be great. Thanks
Attachments:

1_001.png 62K

2.png 98K

Re: [jjem] list categories

By Chris - January 29, 2010 - edited: January 29, 2010

Hi jjem,

I think the simplest way to do this would be to load all discography records at the top of the page:

<?php
list($discographyRecords, $discographyMetaData) = getRecords(array(
'tableName' => 'discography',
));
?>

...then loop over your discography records after displaying each (sub)category and skip over the ones that don't match the category: (new code in red)

<?php foreach ($cd_categoriesRecords as $categoryRecord): ?>
<?php echo $categoryRecord['_listItemStart'] ?>
<?php if ($categoryRecord['_isSelected']): ?> <b> <?php endif ?>
<a href="?category=<?php echo $categoryRecord['num'] ?>"><?php echo $categoryRecord['name'] ?></a>
<?php if ($categoryRecord['_isSelected']): ?> </b> <?php endif ?>

<?php foreach ($discographyRecords as $discographyRecord): ?>
<?php if ($discographyRecord['category'] != $categoryRecord['num']) { continue; } // skip records which aren't in this category ?>
<a href="<?php echo $discographyRecord['_link'] ?>"><?php echo $discographyRecord['title'] ?></a>
<?php endforeach ?>

<?php echo $categoryRecord['_listItemEnd'] ?>
<?php endforeach ?>

You may need to change the names of the fields above (i.e. 'category', 'title') if I haven't guessed at your configuration correctly.

I hope this helps! Please let me know if you have any questions.
All the best,
Chris

Re: [chris] list categories

By jjem - February 3, 2010

Hi Chris,

Thanks for the hint. here is the full page code. I still get only the (sub)categories listed as wanted but the content (<?php echo $discographyRecord['title'] ?>) doesn't appear... I'd much appreciate another "coup de pouce" (help)...
Result of that page in the attached screenshot


<?php
require_once "/.../.../.../.../html/cmsAdmin/lib/viewer_functions.php";
list($cd_categoriesRecords, $selectedCategory) = getCategories(array(
'tableName' => 'cd_categories',
));

list($discographyRecords, $discographyMetaData) = getRecords(array(
'tableName' => 'discography',
));

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title> Discography</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link rel="stylesheet" type="text/css" href="css/360player.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<script src="http://cdn.jquerytools.org/1.1.2/full/jquery.tools.min.js"></script>
<script type="text/javascript" src="js/berniecode-animator.js"></script>
<script src="js/soundmanager2.js" language='JavaScript' type="text/javascript"></script>
<script src="js/360player.js" language='JavaScript' type="text/javascript"></script>
</head>
<body>
<?php include('includes/header.html'); ?>
<div id="contentWrapper">
<div class="pageTitle">Discography</div>
<!-- InstanceBeginEditable name="pageContent" -->
<div class="pageContent">
<ul>

<?php foreach ($cd_categoriesRecords as $categoryRecord): ?>
<?php echo $categoryRecord['_listItemStart'] ?>
<?php if ($categoryRecord['_isSelected']): ?>
<b>
<?php endif ?>
<?php echo $categoryRecord['name'] ?>
<?php if ($categoryRecord['_isSelected']): ?>
</b>
<?php endif ?>

<?php foreach ($discographyRecords as $discographyRecord): ?>
<?php if ($discographyRecord['category'] != $categoryRecord['num']) { continue; } // skip records which aren't in this category ?>
<?php echo $discographyRecord['title'] ?>
<?php endforeach ?>


<?php echo $categoryRecord['_listItemEnd'] ?>
<?php endforeach ?>
</ul>

<?php if (!$discographyRecords): ?>
No records were found!<br/>
<br/>
<?php endif ?>
</div>
</div>
</body>
</html>
Attachments:

3_001.png 45K

Re: [jjem] list categories

By Chris - February 3, 2010

Hi jjem,

I'd suggest adding some code to make sure things are what you expect. What results do you get if you add the two red lines around your inner foreach?

$categoryRecord['num'] == <?php echo $categoryRecord['num'] ?><br>
<?php foreach ($discographyRecords as $discographyRecord): ?>
$discographyRecord['category'] == <?php echo $discographyRecord['category'] ?><br>
All the best,
Chris

Re: [chris] list categories

By jjem - February 5, 2010

Hi Chris,

See attachement....
Attachments:

capture-d-cran-2010-02-05-21-48-25.png 65K

Re: [jjem] list categories

By Chris - February 5, 2010

Hi jjem,

A ha! Your category list fields are multi-value. I should have asked!

Does this change solve the problem?

<?php foreach ($discographyRecords as $discographyRecord): ?>
<?php if (strpos($discographyRecord['category'], "\t".$categoryRecord['num']."\t") === false) { continue; } // skip records which aren't in this category (multi-value) ?>
<a href="<?php echo $discographyRecord['_link'] ?>"><?php echo $discographyRecord['title'] ?></a>
<?php endforeach ?>

Please let me know if you have any questions.
All the best,
Chris

Re: [chris] list categories

By jjem - February 5, 2010

Chris thanks for the quick reply. I tested you solution which is going to to corrrect way. the isseu now is that the items are listed under each category and subcategory.

So I have all CD's listed under to top category. Then part of them are listed under the first sub-category again. Then they are listed again in the second subcategory.... see new attachement.

Sorry for the trouble...
Attachments:

capture-d-cran-2010-02-05-22-25-20.png 106K

Re: [jjem] list categories

By Chris - February 8, 2010

Hi jjem,

I think the simple solution is to change your items so they only belong to subcategories, not parent categories. Is there a reason why you need your items to be assigned to parent categories as well? Maybe it would be simpler to address the other issue.
All the best,
Chris