ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / ticketing.nipponia.com / include / client

<div class="row">
<div class="span8">
<div><h1><?php echo __("Click on the category to browse FAQs."); ?></h1></div>
<?php
    $categories = Category::objects()
        ->exclude(Q::any(array(
            'ispublic'=>Category::VISIBILITY_PRIVATE,
            Q::all(array(
            'faqs__ispublished'=>FAQ::VISIBILITY_PRIVATE,
                    'children__ispublic' => Category::VISIBILITY_PRIVATE,
                    'children__faqs__ispublished'=>FAQ::VISIBILITY_PRIVATE,
                    ))
        )))
        //->annotate(array('faq_count'=>SqlAggregate::COUNT('faqs__ispublished')));
        ->annotate(array('faq_count' => SqlAggregate::COUNT(
                        SqlCase::N()
                        ->when(array(
                                'faqs__ispublished__gt'=> FAQ::VISIBILITY_PRIVATE), 1)
                        ->otherwise(null)
        )))
        ->annotate(array('children_faq_count' => SqlAggregate::COUNT(
                        SqlCase::N()
                        ->when(array(
                                'children__faqs__ispublished__gt'=> FAQ::VISIBILITY_PRIVATE), 1)
                        ->otherwise(null)
        )));

// ->filter(array('faq_count__gt' => 0));
    if ($categories->exists(true)) { ?>
        
        <ul id="kb">
<?php
        foreach ($categories as $C) {
            // Don't show subcategories with parents.
            if (($p=$C->parent)
                    && ($categories->findFirst(array(
                                'category_id' => $p->getId()))))
                continue;

$count = $C->faq_count + $C->children_faq_count;
            ?>
            <li><i></i>
            <div style="margin-left:45px">
            <h4><?php echo sprintf('<a href="faq.php?cid=%d">%s %s</a>',
                $C->getId(), Format::htmlchars($C->getLocalName()),
                $count ? "({$count})": ''
                ); ?></h4>
            <div class="faded" style="margin:10px 0">
                <?php echo Format::safe_html($C->getLocalDescriptionWithImages()); ?>
            </div>
<?php
            if (($subs=$C->getPublicSubCategories())) {
                echo '<p/><div style="padding-bottom:15px;">';
                foreach ($subs as $c) {
                    echo sprintf('<div><i class="icon-folder-open"></i>
                            <a href="faq.php?cid=%d">%s (%d)</a></div>',
                            $c->getId(),
                            $c->getLocalName(),
                            $c->faq_count
                            );
                }
                echo '</div>';
            }

foreach ($C->faqs
                    ->exclude(array('ispublished'=>FAQ::VISIBILITY_PRIVATE))
                    ->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">
<?php
//osta start - replaced fragmented sidebar with unified sidebar
include ROOT_DIR . 'osta/templates/sidebar-unified.inc.php';
//osta end
?>
</div>
</div>

[+] ..
[-] login.inc.php [edit]
[-] accesslink.inc.php [edit]
[-] staff.inc.php [edit]
[-] register.confirmed.inc.php [edit]
[-] faq.inc.php [edit]
[-] login.tpl.php [edit]
[-] pwreset.request.php [edit]
[-] register.inc.php [edit]
[-] open.inc.php [edit]
[-] header.inc.php [edit]
[-] register.confirm.inc.php [edit]
[-] kb-categories.inc.php [edit]
[-] faq-category.inc.php [edit]
[-] kb-search.inc.php [edit]
[-] pwreset.sent.php [edit]
[-] profile.inc.php [edit]
[-] view.inc.php [edit]
[-] pwreset.login.php [edit]
[-] knowledgebase.inc.php [edit]
[+] templates
[-] tickets.inc.php [edit]
[-] footer.inc.php [edit]
[-] edit.inc.php [edit]
[-] .htaccess.disabled [edit]