Go Back   Mosets Community > Archives > Mosets Hot Property 1.0 > Hot Property 1.0 Tips and Tricks

 
 
Thread Tools Search this Thread Display Modes
  #1  
Old 09-16-2010, 06:11 PM
jeanpaulbraud jeanpaulbraud is offline
Mosets'd
 
Join Date: Jan 2009
Posts: 16
Default Frontpage layout with all properties listed in

I want in Frontpage layout, after all types are listed, to show all properties from database. I mean to have properties listed in frontpage, after Types, like typing that in URL index.php?option=com_hotproperty&view=types

Does anybody know how can this be done?

Thank you
  #2  
Old 09-16-2010, 06:46 PM
gray gray is offline
Mosets'd
 
Join Date: Apr 2006
Posts: 901
Default

Again, it require essential hacking, but all properties could be extracted by
PHP Code:
        $db            =& MosetsFactory::getDBO();
        
$nullDate    $db->getNullDate(); 
        
$now        JFactory::getDate();
        
        
$rows $this->get('data'null, array('all', array(
            
'where'    => array(
                
'Property.approved' => 1,
                
'Property.published' => 1,
                array(
                    
'OR' => array(
                        
'Property.publish_up' => $nullDate,
                        
'Property.publish_up <=' => $now->toMySQL()
                    )
                ),
                array(
                    
'OR' => array(
                        
'Property.publish_down' => $nullDate,
                        
'Property.publish_down >=' => $now->toMySQL()
                    )
                )
            ),
            
'contain' => array(
                
'Type' => array(),
                
'Agent' => array(
                    
'contain' => array(
                        
'Company' => array()
                    )
                ),
                
'PropertyField' => array(),
                
'Photo' => array(
                    
'limit' => 1,
                    
'order' => array('Photo.ordering' => 'ASC')
                )
            ),
            
'order' => array($this->get('ordering') => $this->get('ordering_dir')),
            
'limitstart' => $this->get('limitstart'),
            
'limit' => $this->get('limit')
        )));
        
$this->assignRef('rows'$rows); 
and rendered in the template file, similar to \components\com_hotproperty\views\properties\tmpl\ _summary.php
__________________
4HP: Slideshow Module New!
www.topcomhomes.com
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Frontpage layout based on extrafield jeanpaulbraud Hot Property 1.0 Tips and Tricks 1 09-16-2010 06:35 PM
Random Featured Properties on Front Page Layout Jay Hot Property 1.0 Tips and Tricks 12 05-16-2010 06:08 AM


All times are GMT +8. The time now is 09:49 PM.

Copyright © 2005-2010 Mosets Consulting

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.