Newer
Older
<div class="row">
<div class="span8">
<?php
$categories = Category::objects()
->exclude(Q::any(array('ispublic'=>false, 'faqs__ispublished'=>false)))
->annotate(array('faq_count'=>SqlAggregate::COUNT('faqs')))
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
->filter(array('faq_count__gt'=>0));
if ($categories->all()) { ?>
<div><?php echo __('Click on the category to browse FAQs.'); ?></div>
<ul id="kb">
<?php
foreach ($categories as $C) { ?>
<li><i></i>
<div style="margin-left:45px">
<h4><?php echo sprintf('<a href="faq.php?cid=%d">%s (%d)</a>',
$C->getId(), Format::htmlchars($C->getLocalName()), $C->faq_count); ?></h4>
<div class="faded" style="margin:10px 0">
<?php echo Format::safe_html($C->getLocalDescriptionWithImages()); ?>
</div>
<?php foreach ($C->faqs
->exclude(array('ispublished'=>false))
->order_by('-views')->limit(5) as $F) { ?>
<div class="popular-faq"><i class="icon-file-alt"></i>
<a href="faq.php?id=<?php echo $F->getId(); ?>">
<?php echo $F->getLocalQuestion() ?: $F->getQuestion(); ?>
</a></div>
<?php } ?>
</div>
</li>
<?php } ?>
</ul>
<?php
} else {
echo __('NO FAQs found');
}
?>
</div>
<div class="span4">
<div class="sidebar">
<div class="searchbar">
<form method="get" action="faq.php">
<input type="hidden" name="a" value="search"/>
<select name="topicId" style="width:100%;max-width:100%"
onchange="javascript:this.form.submit();">
<option value="">— Browse by Topic —</option>
<?php
$topics = Topic::objects()
->annotate(array('has_faqs'=>SqlAggregate::COUNT('faqs')))
->filter(array('has_faqs__gt'=>0));
foreach ($topics as $T) { ?>
<option value="<?php echo $T->getId(); ?>"><?php echo $T->getFullName();
?></option>
<?php } ?>
</select>
</form>
</div>
<br/>
<div class="content">
<section>
<div class="header"><?php echo __('Other Resources'); ?></div>
</section>
</div>
</div>
</div>
</div>