source: plugins/eventdata/class.dc.eventdata.php @ 1015

<?php
# -- BEGIN LICENSE BLOCK ----------------------------------
# This file is part of eventdata, a plugin for Dotclear 2.
#
# Copyright (c) 2009 JC Denis and contributors
# jcdenis@gdwd.com
#
# Licensed under the GPL version 2.0 license.
# A copy of this license is available in LICENSE file or at
# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
# -- END LICENSE BLOCK ------------------------------------

class dcEventdata
{
     private $core;
     private $con;
     private $table;
     
     public function __construct(&$core)
     {
          $this->core =& $core;
          $this->con =& $this->core->con;
          $this->table = $this->core->prefix.'eventdata';
     }

     public function getEventdata($type=null,$limit=null,$eventdata_start=null,$eventdata_end=null,$post_id=null,$period=null,$sort='desc')
     {
          $strReq = 'SELECT eventdata_start, eventdata_end, eventdata_type, eventdata_location, COUNT(EV.post_id) as count '.
          'FROM '.$this->table.' EV LEFT JOIN '.$this->core->prefix.'post P '.
          'ON EV.post_id = P.post_id '.
          "WHERE P.blog_id = '".$this->con->escape($this->core->blog->id)."' ";

          if ($type !== null)
               $strReq .= "AND eventdata_type = '".$this->con->escape($type)."' ";

          switch ($period) {
               case 'ongoing':
                    $op = array('<','>'); break;
               case 'outgoing':
                    $op = array('>','<'); break;
               case 'notstarted':
                    $op = array('>','!'); break;
               case 'scheduled':
                    $op = array('>','!'); break;
               case 'started':
                    $op = array('','!'); break;
               case 'notfinished':
                    $op = array('!','>'); break;
               case 'finished':
                    $op = array('!','<'); break;
               default:
                    $op = array('=','='); break;
          }

          if ($eventdata_start !== null && $op[0] != '!')
               $strReq .= "AND eventdata_start = '".$this->con->escape($eventdata_start)."' ";
          
          if ($eventdata_end !== null && $op[1] != '!')
               $strReq .= "AND eventdata_end = '".$this->con->escape($eventdata_end)."' ";

          if ($post_id !== null)
               $strReq .= 'AND P.post_id = '.(integer) $post_id.' ';
          
          if (!$this->core->auth->check('contentadmin',$this->core->blog->id)) {
               $strReq .= 'AND ((post_status = 1 ';
               
               if ($this->core->blog->without_password)
                    $strReq .= 'AND post_password IS NULL ';

               $strReq .= ') ';

               if ($this->core->auth->userID())
                    $strReq .= "OR P.user_id = '".$this->con->escape($this->core->auth->userID())."' ";

                    $strReq .= ') ';
          }
          $sort = strtoupper($sort) == 'ASC' ? 'ASC' : 'DESC';
          $strReq .= 'GROUP BY eventdata_start,eventdata_end,eventdata_type,P.blog_id ORDER BY eventdata_start '.$sort.' ';

          if ($limit)
               $strReq .= $this->con->limit($limit);

          $rs = $this->con->select($strReq);
          $rs = $rs->toStatic();
          
          while ($rs->fetch()) {
               $rs->set('start_ts',strtotime($rs->eventdata_start));
               $rs->set('end_ts',strtotime($rs->eventdata_end));
               $rs->set('start_ym',date('Ym',strtotime($rs->eventdata_start)));
               $rs->set('end_ym',date('Ym',strtotime($rs->eventdata_end)));
               $rs->set('duration_ts',(strtotime($rs->eventdata_end) - strtotime($rs->eventdata_start)));
          }

          return $rs;
     }

     public function getPostsByEventdata($params=array(),$count_only=false)
     {
          if (!isset($params['columns'])) $params['columns'] = array();
          $params['columns'][] = 'EV.eventdata_start';
          $params['columns'][] = 'EV.eventdata_end';
          $params['columns'][] = 'EV.eventdata_location';

          if (!isset($params['from'])) $params['from'] = '';
          $params['from'] .= ' LEFT OUTER JOIN '.$this->table.' EV ON P.post_id = EV.post_id ';

          if (!isset($params['sql'])) $params['sql'] = '';

          if (isset($params['period'])) {
               $ts_format = '%Y-%m-%d %H:%M:%S';
               $ts_now = "TIMESTAMP '".dt::str($ts_format)."'";
               $ts_start = 'EV.eventdata_start';
               $ts_end = 'EV.eventdata_end';

               switch($params['period']) {
                    case 'ongoing':
                    $params['sql'] .= 'AND '.$ts_start.' < '.$ts_now.' '.
                         ' AND '.$ts_end.' > '.$ts_now.' '; break;
                    case 'outgoing':
                    $params['sql'] .= 'AND '.$ts_start.' > '.$ts_now.' '.
                         ' AND '.$ts_end.' < '.$ts_now.' '; break;
                    case 'notstarted':
                    $params['sql'] .= 'AND '.$ts_start.' > '.$ts_now.' '; break;
                    case 'scheduled':
                    $params['sql'] .= 'AND '.$ts_start.' > '.$ts_now.' '; break;
                    case 'started':
                    $params['sql'] .= 'AND '.$ts_start.' < '.$ts_now.' '; break;
                    case 'notfinished':
                    $params['sql'] .= 'AND '.$ts_end.' > '.$ts_now.' '; break;
                    case 'finished':
                    $params['sql'] .= 'AND '.$ts_end.' < '.$ts_now.' '; break;
               }
               unset($params['period'],$ts_start,$ts_end,$ts_format,$ts_now);
          }
          if (!empty($params['eventdata_type'])) {
               $params['sql'] .= "AND EV.eventdata_type = '".$this->con->escape($params['eventdata_type'])."' ";
               unset($params['eventdata_type']);
          }
          if (!empty($params['eventdata_start'])) {
               $params['sql'] .= "AND EV.eventdata_start = '".$this->con->escape($params['eventdata_start'])."' ";
               unset($params['eventdata_start']);
          }
          if (!empty($params['eventdata_end'])) {
               $params['sql'] .= "AND EV.eventdata_end = '".$this->con->escape($params['eventdata_end'])."' ";
               unset($params['eventdata_end']);
          }
          if (!empty($params['eventdata_location'])) {
               $params['sql'] .= "AND EV.eventdata_location = '".$this->con->escape($params['eventdata_location'])."' ";
               unset($params['eventdata_location']);
          }

          # Metadata
          if (isset($params['meta_id'])) {
               $params['from'] .= ', '.$this->core->prefix.'meta META ';
               $params['sql'] .= 'AND META.post_id = P.post_id ';
               $params['sql'] .= "AND META.meta_id = '".$this->con->escape($params['meta_id'])."' ";
               
               if (!empty($params['meta_type'])) {
                    $params['sql'] .= "AND META.meta_type = '".$this->con->escape($params['meta_type'])."' ";
                    unset($params['meta_type']);
               }
               unset($params['meta_id']);         
          }

          return $this->core->blog->getPosts($params,$count_only);
     }

     public function setEventdata($type,$post_id,$start,$end,$location='')
     {
          $post_id = (integer) $post_id;

          $cur = $this->con->openCursor($this->table);

          $cur->post_id = (integer) $post_id;
          $cur->eventdata_type = (string) $type;
          $cur->eventdata_start = (string) $start;
          $cur->eventdata_end = (string) $end;
          $cur->eventdata_location = (string) $location;

          $cur->insert();
     }

     public function delEventdata($type,$post_id,$start=null,$end=null,$location=null)
     {
          $post_id = (integer) $post_id;

          $strReq = 'DELETE FROM '.$this->table.' '.
                    'WHERE post_id = '.$post_id.' '.
                    "AND eventdata_type = '".$this->con->escape($type)."' ";

          if ($start !== null) $strReq .= "AND eventdata_start = '".$this->con->escape($start)."' ";
          if ($end !== null) $strReq .= "AND eventdata_end = '".$this->con->escape($end)."' ";
          if ($location !== null) $strReq .= "AND eventdata_location = '".$this->con->escape($location)."' ";

          $this->con->execute($strReq);
     }
}    
?>