__obsolete/class_version.inc.php

<?php if(!function_exists('startedIndexPhp')) { header("location:../index.php"); exit;}
# streber - a php5 based project management system  (c) 2005 Thomas Mann / thomas@pixtur.de
# Distributed under the terms and conditions of the GPL as stated in lang/license.html

    global $version_fields;
    $version_fields=array();
    addProjectItemFields(&$version_fields);

            foreach(array(
                new FieldInternal(array(    'name'=>'id',
                    'default'=>0,
                    'in_db_object'=>1,
                    'in_db_item'=>1,
                )),
                new FieldInternal(array(    'name'=>'project',
                    'default'=>0,
                    'in_db_object'=>1,
                    'in_db_item'=>1,
                )),
                new FieldString(array(      'name'=>'name',
                    'title'=>__('Version'),
                )),

                new FieldInternal(array(    'name'=>'is_released',
                    'default'=>0,
                )),

                new FieldDatetime(array(    'name'=>'time_released',
                    'title'=> __('Time Released'),
                    'default'=>FINIT_NEVER
                )),
                new FieldText(array(        'name'=>'description',
                    'title'=>__('Description'),
                )),

            ) as $f) {
                $version_fields[$f->name]=$f;
            }




class Version extends DbProjectItem
{
    public $level;              # level if child of parent-tasks
    public $type;

    //=== constructor ================================================
    function __construct ($id_or_array=NULL)
    {
        global $version_fields;
        $this->fields= &$version_fields;

        parent::__construct($id_or_array);
        if(!$this->type) {
            $this->type= ITEM_VERSION;
        }
    }


    static function getById($id)
    {
        $e= new Version($id);
        if($e->id) {
            return $e;
        }
        return NULL;
    }


    static function getVisibleById($id)
    {
        if($e= Version::getById($id)) {
            if($p= Project::getById($e->project)) {
                if($p->validateViewItem($e)) {
                    return $e;
                }
            }
        }
        return NULL;
    }

    static function getEditableById($id)
    {
        if($e= Version::getById($id)) {
            if($p= Project::getById($e->project)) {
                if($p->validateEditItem($e)) {
                    return $e;
                }
            }
        }
        return NULL;
    }




    static function &getVersions( $args=NULL)
    {
        global $auth;
        $prefix = confGet('DB_TABLE_PREFIX');

        ### default params ###
        $project            = NULL;
        $person             = NULL;
        $order_by           = 'v.time_released DESC';
        $visible_only       = true;       # use project rights settings
        $alive_only         = true;       # ignore deleted
        $task              = NULL;       # for a parent task?
        $date_min           = NULL;
        $date_max           = NULL;


        ### filter params ###
        if($args) {
            foreach($args as $key=>$value) {
                if(!isset($$key) && !is_null($$key) && !$$key==="") {
                    trigger_error("unknown parameter",E_USER_NOTICE);
                }
                else {
                    $$key= $value;
                }
            }
        }

        $str_project= $project
            ? 'AND i.project=' . intval($project)
            : '';


        $str_project2= $project
            ? 'AND upp.project=' . intval($project)
            : '';


        $str_is_alive= $alive_only
            ? 'AND i.state=' . ITEM_STATE_OK
            : '';


        $str_date_min= $date_min
            ? "AND i.modified >= '" . asCleanString($date_min) . "'"
            : '';

        $str_date_max= $date_max
            ? "AND i.modified <= ' ". asCleanString($date_max) . "'"
            : '';


        if($visible_only) {
            $str_query=
            "SELECT DISTINCT i.*, v.* from {$prefix}item i, {$prefix}version v, {$prefix}project p, {$prefix}projectperson upp
            WHERE
                    i.type = '".ITEM_VERSION."'
                $str_project
                AND upp.person = {$auth->cur_user->id}
                $str_project2

                $str_is_alive
                AND ( i.pub_level >= upp.level_view
                      OR
                      i.created_by = {$auth->cur_user->id}
                )
                AND i.project = p.id

                AND i.id = v.id
                 $str_date_max
                 $str_date_min

            ". getOrderByString($order_by)
            ;
        }
        ### show all ###
        else {
            $str_query=
            "SELECT i.*, f.* from {$prefix}item i, {$prefix}version v, {$prefix}project p
            WHERE
                i.type = '".ITEM_VERSION."'
            $str_project
            $str_is_alive

            AND i.project = p.id

            AND i.id = v.id
             $str_date_max
             $str_date_min

            ". getOrderByString($order_by)
            ;
        }

        $dbh = new DB_Mysql;
        $sth= $dbh->prepare($str_query);

        $sth->execute("",1);
        $tmp=$sth->fetchall_assoc();
        $files=array();
        foreach($tmp as $t) {
            $version=new Version($t);
            $versions[]=$version;
        }
        return $versions;
    }



    function getProject()
    {
        require_once("db/class_project.inc.php");
        if(!$this->project) {
            #trigger_error("Task:getProject. project-id not set",E_USER_WARNING);
            return NULL;
        }
        $project= Project::getById($this->project);
        return $project;
    }


    function getProjectLink()
    {
        if($project= $this->getProject()) {
            return "<nobr>".$project->getLink().'</nobr>';
        }
        else {
            return NULL;
        }
    }
}

?>

---