root/branch/1.5.x/plugins/jomsocial/mysms_jomsocial.php

<?php
/**
* MySMS - Simple SMS Component for Joomla
*
* Axel Sauerhoefer < mysms[at]quelloffen.com >
*
* http://www.willcodejoomlaforfood.de
*
* $Author: $
* $Rev: $
* $HeadURL: $
*
* $Id:  $
*
* All rights reserved. 
*
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* MySMS! is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*
**/

// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die( 'Restricted access' );

jimport('joomla.plugin.plugin');

$mainframe->registerEvent( 'onLoadContacts', 'plgMySMSJomSocial' );

class plgMySMSJomSocial extends JPlugin
{
        var $db;
        var $user;
        var $params;
        var $contacts;
                        
        function plgMySMSJomSocial( &$subject ) 
        {               
                parent::__construct($subject);
                
                $this->db   = &JFactory::getDBO();
                $this->user = &JFactory::getUser(); 
                
                $plugin =& JPluginHelper::getPlugin( 'mysms', 'mysms_jomsocial');
                $this->params = new JParameter( $plugin->params );      

                $obj  = &JFactory::getLanguage();                       
                $basepath = dirname(__FILE__). DS . '..' . DS . '..' . DS . 'administrator';
                $obj->load( 'plg_mysms_jomsocial', $basepath );
        }
        
        function FilterBlocked( $data )
        {                               
                $sql = 'SELECT userid FROM jos_community_blocklist WHERE blocked_userid=%s';            
                $sql = sprintf( $sql, $this->user->id );
                
                $this->db->setQuery( $sql );            
                $blocklist = $this->db->loadAssocList ();
                
                $result = array();
                
                foreach ( $data as $set )
                {
                        //-- filter out if someone else blocked me, all i blocked are filterd by the sql statment above
                        
                        $block = false;
                        
                        foreach( $blocklist as $b )
                        {
                                if( $b['userid'] == $set['id'] )
                                {
                                        $block = true;
                                        break;
                                }
                        }
                        
                        if( $block == true )
                        {
                                continue;
                        }
                        
                        array_push( $result, $set );                    
                }               
                
                return $result;
        }
        
        function FilterNoSMSNewsletterField( $data )
        {
                $NoSMSNewsletterFiled   = $this->params->get( 'NoSMSNewsletterFiled' );

                if( strlen( $NoSMSNewsletterFiled ) == 0 )
                {
                        return $data;
                }
                
                $blockVal = JText::_( 'PLG_MYSMS_JOMSOCIAL_BLOCK_NEWSLETTER_NO' );
                
                $sql = 'SELECT user_id as userid
                                FROM #__community_fields_values 
                                WHERE  field_id = ( SELECT id FROM jos_community_fields where fieldcode = \'%s\' AND UPPER( VALUE ) = UPPER( \'%s\' ) )';
                                
                $sql = sprintf( $sql, $NoSMSNewsletterFiled, $blockVal );
                
                $this->db->setQuery( $sql );
                
                $blocklist = $this->db->loadAssocList();
                $result = array();
                                
                foreach ( $data as $set )
                {
                        $block = false;
                        
                        foreach( $blocklist as $b )
                        {                                       
                                //found blocked user
                                if( $set['id'] == $b['userid'] )
                                {
                                        $block = true; 
                                        break;
                                }
                        }                       
                        
                        if( $block == true )
                        {
                                continue;
                        }
                        
                        
                        array_push( $result, $set );                    
                }       

                return $result;                 
        }
        
        
        function loadContacts()
        {
                $PhoneFiled                     = $this->params->get( 'PhoneField' );
                                                
                //Special Case, the newsletter admin is able to load all data
                //Also from blocked contacts
                if( $this->IsNewsletterAdmin() )
                {
                        $sql = 'SELECT A.user_id as id, B.username as name, A.value as number 
                                    FROM #__community_fields_values A LEFT JOIN #__users B ON ( A.user_id = B.id )
                                    WHERE  A.field_id = ( SELECT id FROM #__community_fields where fieldcode = \'%s\' ) AND
                                    B.block = 0 AND A.value != \'\''; 
                        
                         $sql = sprintf( $sql, $PhoneFiled );           
                                                                        
                }else{
                        //Default user handling respect blocked state
                        $sql = 'SELECT A.user_id as id, B.username as name, A.value as number 
                                        FROM #__community_fields_values A LEFT JOIN #__users B ON ( A.user_id = B.id )
                                        WHERE  A.field_id = ( SELECT id FROM #__community_fields where fieldcode = \'%s\' ) AND
                                        B.block = 0 AND A.value != \'\' AND
                                        A.user_id NOT IN ( SELECT blocked_userid FROM jos_community_blocklist WHERE userid = %s )';

                        $sql = sprintf( $sql, $PhoneFiled, $this->user->id  );
                }
                                                                        
                $this->db->setQuery( $sql );
                $data = $this->db->loadAssocList ();
                
                //Filter against blocked user, only ignore this filter if we are the newsletter admin           
                if( ! $this->IsNewsletterAdmin() )
                {
                        $data = $this->FilterBlocked( $data );
                }
                
                //Filter against blocked newsletter
                $this->contacts = $this->FilterNoSMSNewsletterField( $data );                           
                return $this->contacts;
        }
        
        function IsVaildContact( $id )
        {               
                if( !is_array($this->contacts))
                {
                        return false;
                }
                
                foreach( $this->contacts as $c )
                {                       
                        if( $c['id'] == $id )
                        {
                                return true;
                        }                       
                }
                
                return false;           
        }
        
        function loadGroups()
        {
                $result = array();
                
                if( false == $this->IsNewsletterAdmin() )
                {
                        return;
                }
                
                $sql = 'SELECT A.groupid, B.name  FROM #__community_groups_members A 
                                LEFT JOIN #__community_groups B ON ( A.groupid = B.ID ) WHERE memberid=%s';
                
                $sql = sprintf( $sql, $this->user->id );
                
                $this->db->setQuery( $sql );
                $groups = $this->db->loadAssocList();
                                                                                
                //special handling for all contacts
                $all    = array( 'id'     => 'plugin_1111111',
                                                 'name'   => 'newsletter',
                                             'member' => array() );     
                
                foreach( $this->contacts as $c )
                {
                        array_push( $all['member'], array( 'id' => $c['id'] ) );                        
                }
                                
                array_push( $result , $all );           
                
                foreach( $groups as $g )
                {
                        $sql = 'SELECT memberid FROM #__community_groups_members WHERE groupid=%s';
                        $sql = sprintf( $sql, $g['groupid'] );
                                                
                        $this->db->setQuery( $sql );
                        $members = $this->db->loadAssocList();
                        
                        $set = array( 'id'     => $g['groupid'],
                                                  'name'   => $g['name'],
                                                  'member' => array() );
                        
                        foreach($members as $m )
                        {
                                if( $this->IsVaildContact( $m['memberid'] ) )
                                {
                                        array_push( $set['member'], array( 'id' => $m['memberid'] ) );
                                }                               
                        }

                        //push only the group if we have more than 0 contacts, so no empty group to show
                        if( count( $set['member'] )  > 0 )
                        {
                                array_push( $result, $set );
                        }                       
                }
                                
                return $result;         
        }
        
        function onLoadContacts()
        {
                
                $this->InitMySMSUserNumber();
                /**
                 * $dummy = array( 'contacts' => array(  array( 'id'       => 1,
                                                                                                 'number'  => '1234',
                                                                                             'name'    => 'JomSocial' ),
                                                                                  array( 'id'      => 2,
                                                                                                 'number'  => '5678',
                                                                                             'name'    => 'JomSocial' ) ),
                                                                                  
                                         'groups'   => array(  array( 'id' => 1,
                                                                                                  'name' => 'TestGroup',
                                                                                          'member' => array( array( 'id' => 1 ),
                                                                                                                                 array( 'id' => 2 ) ) ),
                                                                                   )                                                                              
                                        );      
                                        
                 */                                     
                $result = array( 'contacts' => $this->loadContacts(),
                                                 'groups'       => $this->loadGroups()  );
                
                return $result;         
        }
        
        function IsNewsletterAdmin()
        {
                $NewsletterAdmin                = (int)$this->params->get( 'NewsletterAdmin' ); 
                return $this->user->id == $NewsletterAdmin;
        }
        
        function InitMySMSUserNumber()
        {       
                $sql = "SELECT number FROM #__mysms_joomlauser WHERE userid=%s";
                $sql = sprintf( $sql, $this->user->id );
                $this->db->setQuery( $sql );
                $this->db->query( $sql );
                $number = $this->db->loadResult();
                
                //a number is already setup
                if( 0 < strlen( $number ) )
                {
                        return;
                }

                $PhoneFiled = $this->params->get( 'PhoneField' );               
                $sql = 'SELECT value FROM jos_community_fields_values where user_id=%s AND field_id in ( SELECT id FROM #__community_fields WHERE fieldcode=\'%s\' )';
                $sql = sprintf( $sql, $this->user->id, $PhoneFiled );
                $this->db->setQuery( $sql );
                $this->db->query( $sql );
                $number = $this->db->loadResult();
                        
                if( 0 == strlen( $number ) ) //no number in jomsocial
                {
                        return;
                } 
                
                $sql = "UPDATE #__mysms_joomlauser SET number='%s' WHERE userid=%s LIMIT 1";
                $sql = sprintf( $sql, $number, $this->user->id );
                $this->db->setQuery( $sql );
                $this->db->query( $sql );
        }
                
}
?>