mdb2.class.php | searchcode

/php/lib/data_manager/mdb2.class.php

https://bitbucket.org/chamilo/chamilo-app-wiki-dev/
PHP | 291 lines | 221 code | 54 blank | 16 comment | 14 complexity | d57f5515062e638a1d29572b4357cbe6 MD5 | raw file

<?php

namespace application\wiki;



use common\libraries\Mdb2Database;

use common\libraries\EqualityCondition;

use common\libraries\InCondition;

use common\libraries\Translation;

use common\libraries\ConditionTranslator;

use repository\RepositoryDataManager;

use repository\ContentObjectPublicationAttributes;

use repository\ContentObject;

use common\libraries\Session;



/**

 * @package application.lib.wiki.data_manager

 */

/**

 * This is a data manager that uses a database for storage. It was written

 * for MySQL, but should be compatible with most SQL flavors.

 *

 * @author Sven Vanpoucke & Stefan Billiet

 */



class Mdb2WikiDataManager extends Mdb2Database implements WikiDataManagerInterface

{



    function initialize()

    {

        parent :: initialize();

        $this->set_prefix('wiki_');

    }



    function create_wiki_publication($wiki_publication)

    {

        return $this->create($wiki_publication);

    }



    function update_wiki_publication($wiki_publication)

    {

        $condition = new EqualityCondition(WikiPublication :: PROPERTY_ID, $wiki_publication->get_id());

        return $this->update($wiki_publication, $condition);

    }



    function delete_wiki_publication($wiki_publication)

    {

        $condition = new EqualityCondition(WikiPublication :: PROPERTY_ID, $wiki_publication->get_id());

        return $this->delete($wiki_publication->get_table_name(), $condition);

    }



    function count_wiki_publications($condition = null)

    {

        $rpm = RepositoryDataManager :: get_instance();

        

        $publication_alias = $this->get_alias(WikiPublication :: get_table_name());

        $content_object_alias = $rpm->get_alias(ContentObject :: get_table_name());

        

        $query = 'SELECT ' . $publication_alias . '.*, ';

        $query .= $rpm->escape_column_name(ContentObject :: PROPERTY_TITLE, $content_object_alias) . ', ';

        $query .= $rpm->escape_column_name(ContentObject :: PROPERTY_DESCRIPTION, $content_object_alias);

        $query .= ' FROM ' . $this->escape_table_name(WikiPublication :: get_table_name()) . ' AS ' . $publication_alias;

        

        // join for object name - description

        $query .= ' JOIN ' . $rpm->escape_table_name(ContentObject :: get_table_name()) . ' AS ' . $rpm->get_alias(ContentObject :: get_table_name());

        $query .= ' ON ' . $this->escape_column_name(WikiPublication :: PROPERTY_CONTENT_OBJECT_ID, $publication_alias) . ' = ';

        $query .= $rpm->escape_column_name(ContentObject :: PROPERTY_ID, $rpm->get_alias(ContentObject :: get_table_name()));

        

        return $this->count_result_set($query, WikiPublication :: get_table_name(), $condition);

    }



    function retrieve_wiki_publication($id)

    {

        $condition = new EqualityCondition(WikiPublication :: PROPERTY_ID, $id);

        return $this->retrieve_object(WikiPublication :: get_table_name(), $condition, array(), WikiPublication :: CLASS_NAME);

    

     //        $object->set_default_property('content_object_id', RepositoryDataManager :: get_instance()->retrieve_content_object($object->get_default_property('content_object_id')));

    //        return $object;

    }



    function retrieve_wiki_publications($condition = null, $offset = null, $max_objects = null, $order_by = null)

    {

        $rpm = RepositoryDataManager :: get_instance();

        

        $publication_alias = $this->get_alias(WikiPublication :: get_table_name());

        $content_object_alias = $rpm->get_alias(ContentObject :: get_table_name());

        

        $query = 'SELECT ' . $publication_alias . '.*, ';

        $query .= $rpm->escape_column_name(ContentObject :: PROPERTY_TITLE, $content_object_alias) . ', ';

        $query .= $rpm->escape_column_name(ContentObject :: PROPERTY_DESCRIPTION, $content_object_alias);

        $query .= ' FROM ' . $this->escape_table_name(WikiPublication :: get_table_name()) . ' AS ' . $publication_alias;

        

        // join for object name - description

        $query .= ' JOIN ' . $rpm->escape_table_name(ContentObject :: get_table_name()) . ' AS ' . $rpm->get_alias(ContentObject :: get_table_name());

        $query .= ' ON ' . $this->escape_column_name(WikiPublication :: PROPERTY_CONTENT_OBJECT_ID, $publication_alias) . ' = ';

        $query .= $rpm->escape_column_name(ContentObject :: PROPERTY_ID, $rpm->get_alias(ContentObject :: get_table_name()));

        

        return $this->retrieve_object_set($query, WikiPublication :: get_table_name(), $condition, $offset, $max_objects, $order_by, WikiPublication :: CLASS_NAME);

    }



    function retrieve_wiki_pub_feedback($id)

    {

        $condition = new EqualityCondition(WikiPublication :: PROPERTY_ID, $id);

        $object = $this->retrieve_object(WikiPubFeedback :: get_table_name(), $condition);

        

        return $object;

    }



    function retrieve_wiki_pub_feedbacks($condition = null, $offset = null, $max_objects = null, $order_by = null)

    {

        return $this->retrieve_objects(WikiPubFeedback :: get_table_name(), $condition, $offset, $max_objects, $order_by);

    }



    function create_wiki_pub_feedback($feedback)

    {

        return $this->create($feedback);

    }



    function update_wiki_pub_feedback($feedback)

    {

        $condition = new EqualityCondition(WikiPubFeedback :: PROPERTY_ID, $feedback->get_id());

        return $this->update($feedback, $condition);

    }



    function delete_wiki_pub_feedback($feedback)

    {

        $condition = new EqualityCondition(WikiPublication :: PROPERTY_ID, $feedback->get_id());

        return $this->delete(WikiPubFeedback :: get_table_name(), $condition);

    }



    // Publication attributes

    



    function content_object_is_published($object_id)

    {

        return $this->any_content_object_is_published(array($object_id));

    }



    function any_content_object_is_published($object_ids)

    {

        $condition = new InCondition(WikiPublication :: PROPERTY_CONTENT_OBJECT_ID, $object_ids);

        return $this->count_objects(WikiPublication :: get_table_name(), $condition) >= 1;

    }



    function get_content_object_publication_attributes($object_id, $type = null, $offset = null, $count = null, $order_properties = null)

    {

        if (isset($type))

        {

            if ($type == 'user')

            {

                $rdm = RepositoryDataManager :: get_instance();

                $co_alias = $rdm->get_alias(ContentObject :: get_table_name());

                $pub_alias = $this->get_alias(WikiPublication :: get_table_name());

                

                $query = 'SELECT ' . $pub_alias . '.*, ' . $co_alias . '.' . $this->escape_column_name(ContentObject :: PROPERTY_TITLE) . ' FROM ' . $this->escape_table_name(WikiPublication :: get_table_name()) . ' AS ' . $pub_alias . ' JOIN ' . $rdm->escape_table_name(ContentObject :: get_table_name()) . ' AS ' . $co_alias . ' ON ' . $this->escape_column_name(WikiPublication :: PROPERTY_CONTENT_OBJECT_ID, $pub_alias) . '=' . $this->escape_column_name(ContentObject :: PROPERTY_ID, $co_alias);

                

                $condition = new EqualityCondition(WikiPublication :: PROPERTY_PUBLISHER, Session :: get_user_id());

                $translator = ConditionTranslator :: factory($this);

                $query .= $translator->render_query($condition);

                

                $order = array();

                foreach ($order_properties as $order_property)

                {

                    if ($order_property->get_property() == 'application')

                    {

                    

                    }

                    elseif ($order_property->get_property() == 'location')

                    {

                    

                    }

                    elseif ($order_property->get_property() == 'title')

                    {

                        $order[] = $this->escape_column_name('title') . ' ' . ($order_property->get_direction() == SORT_DESC ? 'DESC' : 'ASC');

                    }

                    else

                    {

                        $order[] = $this->escape_column_name($order_property->get_property()) . ' ' . ($order_property->get_direction() == SORT_DESC ? 'DESC' : 'ASC');

                    }

                }

                

                if (count($order) > 0)

                    $query .= ' ORDER BY ' . implode(', ', $order);

            

            }

        }

        else

        {

            $query = 'SELECT * FROM ' . $this->escape_table_name(WikiPublication :: get_table_name());

            $condition = new EqualityCondition(WikiPublication :: PROPERTY_CONTENT_OBJECT_ID, $object_id);

            $translator = ConditionTranslator :: factory($this);

            $query .= $translator->render_query($condition);

        

        }

        

        $this->set_limit($count, $offset);

        $res = $this->query($query);

        $publication_attr = array();

        while ($record = $res->fetchRow(MDB2_FETCHMODE_ASSOC))

        {

            $info = new ContentObjectPublicationAttributes();

            $info->set_id($record[WikiPublication :: PROPERTY_ID]);

            $info->set_publisher_user_id($record[WikiPublication :: PROPERTY_PUBLISHER]);

            $info->set_publication_date($record[WikiPublication :: PROPERTY_PUBLISHED]);

            $info->set_application(WikiManager :: APPLICATION_NAME);

            //TODO: i8n location string

            $info->set_location(Translation :: get('Wiki'));

            $info->set_url('index.php?application=wiki&go=' . WikiManager :: ACTION_VIEW_WIKI . '&wiki_publication=' . $record[WikiPublication :: PROPERTY_ID]);

            $info->set_publication_object_id($record[WikiPublication :: PROPERTY_CONTENT_OBJECT_ID]);

            

            $publication_attr[] = $info;

        }

        

        $res->free();

        

        return $publication_attr;

    }



    function get_content_object_publication_attribute($publication_id)

    {

        $query = 'SELECT * FROM ' . $this->escape_table_name(WikiPublication :: get_table_name()) . ' WHERE ' . $this->escape_column_name(WikiPublication :: PROPERTY_ID) . '=' . $this->quote($publication_id);

        $this->set_limit(1, 0);

        $res = $this->query($query);

        

        $publication_attr = array();

        $record = $res->fetchRow(MDB2_FETCHMODE_ASSOC);

        

        $publication_attr = new ContentObjectPublicationAttributes();

        $publication_attr->set_id($record[WikiPublication :: PROPERTY_ID]);

        $publication_attr->set_publisher_user_id($record[WikiPublication :: PROPERTY_PUBLISHER]);

        $publication_attr->set_publication_date($record[WikiPublication :: PROPERTY_PUBLISHED]);

        $publication_attr->set_application(WikiManager :: APPLICATION_NAME);

        //TODO: i8n location string

        $publication_attr->set_location(Translation :: get('Wiki'));

        $publication_attr->set_url('index.php?application=wiki&go=browse');

        $publication_attr->set_publication_object_id($record[WikiPublication :: PROPERTY_CONTENT_OBJECT_ID]);

        

        $res->free();

        

        return $publication_attr;

    }



    function count_publication_attributes($user = null, $object_id = null, $condition = null)

    {

        if (! $object_id)

        {

            $condition = new EqualityCondition(WikiPublication :: PROPERTY_PUBLISHER, $user->get_id());

        }

        else

        {

            $condition = new EqualityCondition(WikiPublication :: PROPERTY_CONTENT_OBJECT_ID, $object_id);

        }

        return $this->count_objects(WikiPublication :: get_table_name(), $condition);

    }



    function delete_content_object_publications($object_id)

    {

        $condition = new EqualityCondition(WikiPublication :: PROPERTY_CONTENT_OBJECT_ID, $object_id);

        $publications = $this->retrieve_wiki_publications($condition);

        

        $succes = true;

        

        while ($publication = $publications->next_result())

        {

            $succes &= $publication->delete();

        }

        

        return $succes;

    }



    function delete_content_object_publication($publication_id)

    {

        $condition = new EqualityCondition(WikiPublication :: PROPERTY_ID, $publication_id);

        return $this->delete(WikiPublication :: get_table_name(), $condition);

    }



    function update_content_object_publication_id($publication_attr)

    {

        $where = $this->escape_column_name(WikiPublication :: PROPERTY_ID) . '=' . $publication_attr->get_id();

        $props = array();

        $props[$this->escape_column_name(WikiPublication :: PROPERTY_CONTENT_OBJECT_ID)] = $publication_attr->get_publication_object_id();

        $this->get_connection()->loadModule('Extended');

        if ($this->get_connection()->extended->autoExecute($this->get_table_name(WikiPublication :: get_table_name()), $props, MDB2_AUTOQUERY_UPDATE, $where))

        {

            return true;

        }

        else

        {

            return false;

        }

    }

}

?>