mod

eldest entries

shows the eldest entries first

add file createda.xml → administrator/components/com_sobipro/menu/ folder

and the two basic order-files (of course only once) to the site/com_sobipro section:

order.php → sobipro/opt/listing/ and order.xsl → sobipro/usr/templates/.../listing

for styling the order headline use css h2.tagh{ } (sample in sobi-custom.css) demo

last updated

shows the last updated entries first

add file updated.xml → administrator/components/com_sobipro/menu/ folder

and the two basic order-files (of course only once) to the site/com_sobipro section:

order.php → sobipro/opt/listing/ and order.xsl → sobipro/usr/templates/.../listing

for styling the order headline use css h2.tagh{ } (sample in sobi-custom.css) demo

awaiting approve

shows new entries, which are not approved     e.g.SuperUser only

updated to check for declined entries

since Joomla 3 a lot of administration work can be done in the frontend, so I thought it would be
also useful for the administrator to see in the frontend if there are new entries awaiting approval

 

add file waiting.xml → administrator/components/com_sobipro/menu/ folder

and the two basic order-files (of course only once) to the site/com_sobipro section:

order.php → sobipro/opt/listing/ and order.xsl → sobipro/usr/templates/.../listing

for styling the order headline use css h2.tagh{ } (sample in sobi-custom.css) demo

important:

the core does no admin check, but you can simply set the menu-entry's access level

the look-back days period can be set in the order.php #line 46 by altering default value 7 for $appvdays

or update global.xlm (included) in admin/components/com_sobipro/config/ and set it in the global config.

 

approve Extras

1. for an onTop admin information you can use the little hack of the com_sobipro/lib/views/view.php file,

    which will display an info line on each page view in sobipro frontend  (  SuperUser view only :)

2. and some additional lines for the main index.php of the template to show a number inside the menu if

    there are new entries.   (it also includes a jquery to replace a def. profil menu entry with the username)

Menu addition
SobiPro addition

updated to check for declined entries

for SobiPro:  lib/views/view.php   look for public function display ( $o = 0) and replace the last line

//replace the last line:   echo "\n ....  with the following content

$appvdays = intval(Sobi::Cfg( 'list.approve_days', 7 ));    // edit def. value if updated global.xlm isn't used

if (JFactory::getUser()->authorise('core.admin') && $appvdays) {          // check for admin and enabled
$where = "oType = 'entry' and approved = 0 and  (stateExpl = '' or stateExpl IS NULL) and createdTime > Date_sub(NOW(), INTERVAL ".$appvdays." DAY)";
$result = SPFactory::db()
                             ->select( 'count(id)', 'spdb_object', $where )
                             ->loadResult();
}
if (isset($result) && !empty($result)) {                               // if enabled and any result
$appvstr = Sobi::Txt( 'VL.VIEW_TITLE_APPROVE_WAIT'.($result <> 1 ? '' : 1) );  //language def. needed!
$ulink = 'index.php?option=com_sobipro&sid='.Sobi::Section().'&task=list.order.waiting';
$approve = '<p class="tag label-info"><a href="'.$ulink.'"><span class="badge">'.$result.'</span></a> <b>
                    '.$appvstr.'</b></p>';
} else
$approve = '';  
                                               // this is the new last line
echo "\n<!-- Start of SobiPro component 1.4.x *-->\n<div id=\"SobiPro\" class=\"SobiPro {$templateName}\">\n{$approve}{$out}\n</div>\n<!-- End of SobiPro component; Copyright (C) 2011-2019 Sigsiu.NET GmbH -->\n";

* of course v1.5 has component 1.5.x in the lines (but it is not soo important :)

for the template index.php

use Joomla\CMS\Factory;
// $app = Factory::getApplication(); //uncommend if not already declared

$muser = Factory::getUser();

$appvdays = -1;  /** int - 0 means disable | set days-value here (instead -1) or by the updated global.xlm**/  

run only if admin and sobipro installed - then get the 'lookback days' and count unapproved entries
if ($muser->authorise('core.admin') && JComponentHelper::isInstalled('com_sobipro')) {         
    $db = Factory::getDBO();
    $query = $db->getQuery(true);

if ($appvdays <0) {    // if not set and not disabled above then get from sobi config
       $queryd = "SELECT sValue from #__sobipro_config WHERE sKey = 'approve_days' AND cSection = 'list'";                      $db->setQuery($queryd);
       $appvdays = $db->loadResult();
}
    if ($appvdays > 0) {  // if set and not disabled
        $query = "SELECT count(id) FROM `#__sobipro_object` WHERE oType = 'entry' and `approved` = 0
        and  (stateExpl = '' or stateExpl IS NULL) and `createdTime` > Date_sub(NOW(), INTERVAL $appvdays DAY)";
        $db->setQuery($query);
        $result = $db->loadResult();
    $bdgtxt = ($result) ? '&#8195;<span class=\"badge badge-info toapprove\">'.$result.'</span>' : '';
    } else   $bdgtxt = '';

/* IMPORTANT add classes 'sobi admi' to the used menu item, adjust #menu to your menuID or delete */

$jqapprove = ($bdgtxt) ? ' jQuery("#menu a.sobi.admi").append("'. $bdgtxt .'");' : '';
}    else $jqapprove ='';

/* OPTION: username in menu     IMPORTANT: add class profilname to the menu item, adjust #menuID  */

$jquser=(!$muser->guest)? 'jQuery("#menu a.profilname > span.image-title").text(" '.$muser->username.' ");' : '';

 /** jquery to change menu entries if one of the above has value **/
 if ($jquser || $jqapprove)
 $this->addScriptDeclaration('jQuery(document).ready(function(){'.$jquser.$jqapprove.'});');
                         

Tag-List

linked list with all tags in an accordion div   aggregation_field needed 

for the tag listing we need a little hack of the components/com_sobipro/lib/views/view.php

to show the tag listing in the menu we must also edit the /usr/templates/.../common/alphamenu.xsl

remember: you can also edit all *.xsl files direct in the sobipro backend

style the tag-links with the elements listed in sobi-custom.css (use it as custom.css in your template)

working demo

in  com_sobipro/lib/views/view.php 

1. add a new declaration to the beginning of the class (after the existing declarations)

     /** @var array
     */
       protected $tagv = [];

2. add a new function (get_tags) before function alphamenu (e.g. after/before public function field() )

     /* @param
      * @return tags array
      */

       public function get_Tags()  { 

$where = "fid =(SELECT f.fid FROM #__sobipro_field f WHERE fieldType='aggregation' AND section = ".Sobi::Section().")";
       return SPFactory::db()
                                      ->select( 'optValue', 'spdb_field_option', $where, 'optValue' )
                                      ->loadResultArray();
      }

3. look for protected function alphaMenu( &$data )

replace the last line  '$data[ 'alphaMenu' ] = [ '_complex' => 1, '_data' =>...   with the following content

$tagv = $this->get_Tags();   //  call the new function added before

if ( is_array( $tagv ) && count( $tagv ) ) {    // if we have any tags
     foreach ( $tagv as $tag ) {
     $tagsalpha[] = [
                              '_complex'    => 1,
                              '_data'       => $tag,
                              '_attributes' => [ 'lang' => Sobi::Lang( false ) ],
                              ];
     unset( $tag );
     }
}                                                  // now this is the new last line

 in sobipro 1.5.x there is an additional category entry, so you must use this line:

$data[ 'alphaMenu' ] = [ '_complex' => 1, '_data' => [ 'letters' => $l, 'fields' => $extraFields, 'category' => $category, 'tags' => $tagsalpha ] ];

for v 1.4x it is just this line

$data[ 'alphaMenu' ] = [ '_complex' => 1, '_data' => [ 'letters' => $l, 'fields' => $extraFields, 'tags' => $tagsalpha ] ];

}        // attention: this (1) bracket is/stays after the last line

 

lines to be added to alphamenu.xsl  (edit-alphamenu.xsl) or updated-alphamenu_default4+5.xsl

line for the button    (at the end of: <div class="alphalist"> look for: </ul></div> new line </div></xsl:if>)

<a href="#ataglist" data-toggle="collapse" class="btn btn-xs btn-sigsiu tagtoggle"> Tag Links</a>

add tag div   after: <div id="alpha-index" class="..."><xsl:apply-templates select="letters" /></div></div>

<div id="ataglist" class="collapse">
<xsl:for-each select="tags/*">   

<xsl:variable name="talias"><xsl:value-of select="." /></xsl:variable>

<xsl:variable name="base">     
       {"sid":<xsl:value-of select="//section/@id" />,"task":"list.tag.field_tags"}
</xsl:variable>

<xsl:variable name="Url"><xsl:value-of select="php:function('SobiPro::Url', $base)" /></xsl:variable>

<xsl:element name ="a">

      <xsl:attribute name="href"><xsl:value-of select="concat($Url,'/in,',$talias)" /></xsl:attribute>

<span>

     <xsl:attribute name="class"><xsl:value-of select="concat('tag taglist ',$talias)" /></xsl:attribute>

<span class="firstl"><xsl:value-of select="substring(.,1,1)" /></span>

<xsl:value-of select="substring(.,2)" /></span>              
</xsl:element>
</xsl:for-each>
</div>