Context Navigation

DBMapping.php @ 8058

Revision 8058, 89.9 KB checked in by cristiano, 11 years ago (diff)
Ticket #3403 - Incluir pesquisa por participantes em Catálogos Externos e Catálogo Pessoal

Rev	Line
[5341]	1	<?php
[7077]	2	/**
	3	*
	4	* Copyright (C) 2011 Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
	5	*
	6	* This program is free software; you can redistribute it and/or modify
	7	* it under the terms of the GNU General Public License as published by
	8	* the Free Software Foundation; either version 3 of the License, or
	9	* any later version.
	10	*
	11	* This program is distributed in the hope that it will be useful, but WITHOUT
	12	* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
	13	* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
	14	* details.
	15	*
	16	* You should have received a copy of the GNU General Public License
	17	* along with this program; if not, write to the Free Software Foundation,
	18	* Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
	19	*
	20	* You can contact Prognus Software Livre headquarters at Av. Tancredo Neves,
	21	* 6731, PTI, Edifício do Saber, 3º floor, room 306, Foz do Iguaçu - PR - Brasil
	22	* or at e-mail address prognus@prognus.com.br.
	23	*
	24	* Neste arquivo são ser implementadas regras de negócio para consistir e normalizar os dados correspondentes às operações do usuário para o ExpressoCalendar.
	25	*
	26	* @license http://www.gnu.org/copyleft/gpl.html GPL
	27	* @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
	28	* @version 1.0
	29	* @sponsor Caixa Econômica Federal
	30	* @since Arquivo disponibilizado na versão Expresso 2.4.0
	31	*/
	32
	33
[5341]	34	//Definindo Constantes
[6066]	35	require_once ROOTPATH . '/modules/calendar/constants.php';
[5341]	36
[6066]	37	require_once ROOTPATH . '/modules/calendar/interceptors/Helpers.php';
[5341]	38
[6528]	39	use prototype\api\Config as Config;
	40
[7077]	41	/**
	42	* Classe com implementações das regras de negócio para consistir e normalizar os dados correspondentes às operações do usuário para o ExpressoCalendar.
	43	*
	44	* @license http://www.gnu.org/copyleft/gpl.html GPL
	45	* @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
	46	* @sponsor Caixa Econômica Federal
	47	* @version 1.0
	48	* @since Classe disponibilizada na versão Expresso 2.4.0
	49	*/
	50
[6066]	51	class DBMapping extends Helpers {
	52
[7377]	53
	54
	55	/*
	56	* Verificar inconsistencia no FF
	57	* */
	58	static function encodeCreateParticipant(&$uri, &$params, &$criteria, $original)
	59	{
	60	if(isset($params['delegatedFrom']) && is_array($params['delegatedFrom'])){
	61	$params['delegatedFrom'] = $params['delegatedFrom']['id'];
	62	}
	63	}
	64
	65
[6996]	66	static function encodeCreateSchedulable(&$uri, &$params, &$criteria, $original)
	67	{
[5715]	68
[7006]	69	if (isset($params['startTime']) && !is_numeric($params['startTime']))
[6996]	70	$params['startTime'] = self::parseTimeDate($params['startTime'], $params['timezone']);
[7006]	71
	72	$params['rangeStart'] = $params['startTime'];
	73
[6996]	74	if (isset($params['endTime']) && !is_numeric($params['endTime'])) {
	75	$params['endTime'] = self::parseTimeDate($params['endTime'], $params['timezone']);
[5715]	76
[6996]	77	if ($params['allDay'])
[7006]	78	$params['endTime'] = $params['endTime'] + 86400000;
	79	}
[6996]	80
[7006]	81	$params['rangeEnd'] = $params['endTime'];
	82
[6066]	83
[7680]	84	if (isset($params['due']) && $params['due'] != '' && !is_numeric($params['due'])){
[6996]	85	$params['due'] = self::parseTimeDate($params['due'], $params['timezone']);
[6190]	86
[7680]	87	if ($params['allDay'])
	88	$params['due'] = $params['due'] + 86400000;
	89	}
	90
	91
[6996]	92	///////////////////////////////////////////////////////////////////
[5592]	93
[6996]	94	$params['dtstamp'] = (isset($params['dtstamp'])) ? $params['dtstamp'] : time() . '000';
	95	$params['lastUpdate'] = (isset($params['lastUpdate'])) ? $params['lastUpdate'] : time() . '000';
	96	$params['uid'] = isset($params['uid']) ? $params['uid'] : self::_makeUid();
	97	}
[5341]	98
[6066]	99	static function parseTimeDate($time, $timezone) {
[7579]	100	return strtotime($time . ' ' . $timezone) . '000';
[6066]	101	}
[5341]	102
[6136]	103	public function encodeCreateAlarm( &$uri , &$params , &$criteria , $original ){
	104
	105	if(!isset($params['schedulable']) \|\| !isset($params['rangeStart']) \|\| !isset($params['rangeEnd']) )
	106	{
	107	$participant = Controller::read( array( 'concept' => 'participant' , 'id' => $params['participant'] ) , array('schedulable') );
[6066]	108
[6136]	109	$params['schedulable'] = $participant['schedulable'];
[6066]	110
[6136]	111	$params['type'] = self::codeAlarmType($params['type']);
[5514]	112
[6136]	113	$params['offset'] = $params['time'] * 1000;
	114
	115	switch( strtolower($params['unit']) )
	116	{
	117	case 'd': $params['offset'] *= 24;
	118	case 'h': $params['offset'] *= 60;
	119	case 'm': $params['offset'] *= 60;
	120	}
	121	}
[6066]	122	}
	123
	124	public function encodeCreateSuggestion(&$uri, &$params, &$criteria, $original) {
	125	$params['dtstamp'] = (isset($params['dtstamp'])) ? $params['dtstamp'] : time() . '000';
	126	}
	127
	128	public function encodeUpdateAlarm(&$uri, &$params, &$criteria, $original) {
	129	if (isset($params['type']))
	130	$params['type'] = self::codeAlarmType($params['type']);
[6996]	131	else{
	132	$alarm = Controller::read( array('concept' => 'alarm' , 'id' => $params['id'] ));
	133
	134	$params['unit'] = $alarm['unit'];
	135	}
	136	$params['offset'] = $params['time'] * 1000;
	137
	138
	139	switch( strtolower($params['unit']) )
	140	{
	141	case 'd': $params['offset'] *= 24;
	142	case 'h': $params['offset'] *= 60;
	143	case 'm': $params['offset'] *= 60;
	144	}
	145
[6066]	146	}
	147
	148	public function encodeCreateAttachment(&$uri, &$params, &$criteria, $original) {
	149
	150	if (!isset($params['source']))
	151	return false;
	152
	153	if (isset($_FILES[$params['source']]))
	154	if (isset($params['id']))
	155	$params = array_merge($_FILES[$params['source']], array('id' => $params['id']));
	156	else
	157	$params = $_FILES[$params['source']];
	158
	159	if (isset($params['owner']))
	160	$params['owner'] = Config::me('uidNumber');
	161	}
	162
[5341]	163	///////////////////////////////////////////////////////////////////////////////////////////////////////////////
	164
[6066]	165	public function encodeSignatureAlarmType(&$uri, &$params, &$criteria, $original) {
[7795]	166	$params['type'] = self::codeAlarmType($params['type']);
[5715]	167	}
	168
[7795]	169	public function schedulableSecurity(&$uri, &$params, &$criteria, $original)
	170	{
[7980]	171
[7932]	172	if( !isset($criteria['filter'][1]) \|\| !$criteria['filter'][1] == 'uid')
	173	{
	174	$security = 'schedulable.id = calendarToSchedulable.schedulable';
	175	$security .= ' AND calendar.id = calendarToSchedulable.calendar';
	176	$security .= ' AND calendar.id = calendarSignature.calendar';
	177	$security .= ' AND calendarSignature.user = ' . base64_encode(Config::me('uidNumber'));
[7795]	178
[7932]	179	$criteria['condition'] = $security;
	180	}
	181
[7795]	182	}
	183
	184	public function calendarSecurity(&$uri, &$params, &$criteria, $original)
	185	{
	186	$security = 'calendar.id = calendarSignature.calendar';
	187	$security .= ' AND calendarSignature.user = ' . base64_encode(Config::me('uidNumber'));
	188
	189	$criteria['condition'] = $security;
	190	}
	191
	192	public function calendarSignatureSecurity(&$uri, &$params, &$criteria, $original)
	193	{
[7954]	194	// $security = 'calendarSignature.user = ' . base64_encode(Config::me('uidNumber'));
	195	//
	196	// $criteria['condition'] = $security;
[7795]	197	}
	198
[6066]	199	public function insertOwnerLink(&$uri, &$params, &$criteria, $original) {
	200	$params['owner'] = Config::me('uidNumber');
	201	}
[5715]	202
[6066]	203	public function encodeServiceUser(&$uri, &$params, &$criteria, $original) {
	204	if (isset($params['isExternal']) && $params['isExternal'] == '1')
	205	$uri['service'] = 'PostgreSQL';
	206	}
[5798]	207
[6066]	208	public function prepareRepeat(&$uri, &$params, &$criteria, $original) {
[7590]	209	if (isset($params['startTime']) \|\| isset($params['endTime'])) {
[6066]	210
[7590]	211	if(!isset($params['schedulable']))
	212	$params = array_merge($params , Controller::read(array('concept' => 'repeat', 'id' => $params['id']), array('schedulable')));
	213
	214	$timezone = Controller::read(array('concept' => 'schedulable', 'id' => $params['schedulable']), array('timezone'));
	215
	216
	217	if ( isset($params['startTime']) && !is_numeric($params['startTime']) )
	218	$params['startTime'] = self::parseTimeDate($params['startTime'], $timezone['timezone']);
	219	if ( isset($params['endTime']) && !is_numeric($params['endTime']))
	220	$params['endTime'] = self::parseTimeDate($params['endTime'], $timezone['timezone']);
	221
	222	}
[5715]	223	}
	224
[6066]	225	public function findSchedulable(&$uri, &$params, &$criteria, $original) {
[7702]	226	if (isset($criteria['customQuery']) && $criteria['customQuery'] == '1') {
[5737]	227
[7702]	228	$sql = ' SELECT calendar_object.id as id ,calendar_object.cal_uid as "uid", calendar_object.type_id as "type", '
	229	.'calendar_object.dtstart as "startTime", calendar_object.summary as "summary", '
	230	.'calendar_object.description as "description", calendar_object.dtend as "endTime" , '
	231	.'calendar_object.priority as "priority", calendar_object.due as "due", '
	232	.'calendar_object.percentage as "percentage", calendar_object.status as "status", '
	233	.'calendar_object.location as "location", calendar_object.allday as "allDay", '
	234	.'calendar_object.transp as "transparent", calendar_object.class_id as "class", '
	235	.'calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart", '
	236	.'calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", '
	237	.'calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence", '
	238	.'calendar_object.tzid as "timezone" ,calendar_to_calendar_object.calendar_id as '
	239	.'calendar FROM calendar_to_calendar_object , calendar_object '
	240	.'WHERE ( calendar_to_calendar_object.calendar_id IN (\'' . implode('\',\'', $criteria['calendar']) . '\')) '
	241	.'AND calendar_to_calendar_object.calendar_object_id = calendar_object.id '
	242	.'AND calendar_object.id NOT IN(select calendar_object_task_id from calendar_task_to_activity_object where owner = \'' . Config::me('uidNumber') . '\') ';
[5737]	243
[7702]	244	if(isset($criteria['searchEvent']) && $criteria['searchEvent']){
	245	$where = 'AND (((upper("summary") like upper(\'%'.$criteria['filter'][1][1][2].'%\') OR upper("description") like upper(\'%'.$criteria['filter'][1][2][2].'%\')))) ORDER BY dtstart LIMIT '.$criteria['limit'].' OFFSET '.$criteria['offset'].' ';
	246	$params = Controller::service('PostgreSQL')->execResultSql($sql.$where);
[6160]	247
[7702]	248	}else{
	249	$start = $criteria['rangeStart'];
	250	$end = $criteria['rangeEnd'];
[5715]	251
[7702]	252	$ids = array();
	253	$occ = array();
[5715]	254
[7702]	255	if ($occurrences = self::checkOccurrences($start, $end, $criteria['calendar']))
	256	foreach ($occurrences as $id => $occurrence) {
	257	$ids[] = $id;
	258	$occ[] = $occurrence;
	259	}
[6190]	260
[7702]	261	$where = 'AND ((range_end >= \'' . $start . '\' AND range_end <= \'' . $end . '\') OR '
	262	.'(range_start >= \'' . $start . '\' AND range_start <= \'' . $end . '\') OR '
	263	.'(range_start <= \'' . $start . '\' AND range_end >= \'' . $end . '\')) '
	264	.(!empty($ids) ? ' ' .'AND calendar_object.id NOT IN (\'' . implode('\',\'', $ids) . '\') ' : ' ')
	265	.'AND calendar_object.dtstart NOT IN (SELECT calendar_repeat_occurrence.occurrence from calendar_repeat_occurrence, '
	266	.'calendar_repeat where (calendar_repeat_occurrence.repeat_id = calendar_repeat.id) '
	267	.'AND (calendar_repeat.object_id = calendar_object.id))';
	268
	269	$params = Controller::service('PostgreSQL')->execResultSql($sql.$where);
	270	$params = array_merge($params, $occ);
	271	}
	272
	273
	274	$params = self::deepnessFindEvent($uri, $params, $criteria, $original);
	275	return false;
	276	}
[6066]	277	}
[5715]	278
[6996]	279	public function findTask(&$uri, &$params, &$criteria, $original) {
	280
	281	if (isset($criteria['filterTasks']) && $criteria['filterTasks']) {
	282
	283	$sql = ' SELECT calendar_object.id as id ,calendar_object.cal_uid as "uid", calendar_object.type_id as "type", '
	284	.'calendar_object.dtstart as "startTime", calendar_object.summary as "summary", '
	285	.'calendar_object.description as "description", calendar_object.dtend as "endTime" , '
	286	.'calendar_object.priority as "priority", calendar_object.due as "due", '
	287	.'calendar_object.percentage as "percentage", calendar_object.status as "status", '
	288	.'calendar_object.location as "location", calendar_object.allday as "allDay", '
	289	.'calendar_object.transp as "transparent", calendar_object.class_id as "class", '
	290	.'calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart", '
	291	.'calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", '
	292	.'calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence", '
	293	.'calendar_object.tzid as "timezone" ,calendar_to_calendar_object.calendar_id as '
	294	.'calendar FROM calendar_to_calendar_object , calendar_object '
	295	.'WHERE ( calendar_to_calendar_object.calendar_id IN (\'' . implode('\',\'', $criteria['filter'][3][2]) . '\')) '
	296	.'AND calendar_to_calendar_object.calendar_object_id = calendar_object.id '
	297	.'AND calendar_to_calendar_object.calendar_object_id NOT IN (select calendar_object_activity_id from calendar_task_to_activity_object where owner = \'' . Config::me("uidNumber") . '\' ) '
	298	.'AND calendar_to_calendar_object.calendar_object_id NOT IN (select calendar_object_task_id from calendar_task_to_activity_object where owner = \'' . Config::me("uidNumber") . '\' ) ';
	299
	300	if(isset($criteria['filter'][4]))
	301	$sql .= 'AND (((upper("summary") like upper(\'%'.$criteria['filter'][4][1][2].'%\') OR upper("description") like upper(\'%'.$criteria['filter'][4][1][2].'%\'))))';
	302
	303	$sql .= 'AND (range_start >= \'' . $criteria['filter'][2][2] . '\' AND type_id <= \'' . $criteria['filter'][1][2] . '\')';
	304
	305	$params = Controller::service('PostgreSQL')->execResultSql($sql);
	306	$params = self::deepnessFindEvent($uri, $params, $criteria, $original);
	307	return false;
	308	}
	309	}
	310
[6066]	311	public function deepnessFindRepeatOccurrence(&$uri, &$result, &$criteria, $original) {
[5715]	312
[6066]	313	if (!isset($criteria['deepness']) \|\| $criteria['deepness'] == 0)
	314	return;
[5715]	315
[6066]	316	foreach ($result as $i => &$res)
	317	if (isset($res['repeat']))
	318	$res['repeat'] = Controller::read(array('concept' => 'repeat', 'id' => $res['repeat']), false, array('deepness' => intval($criteria['deepness']) - 1));
	319	}
[5715]	320
[6066]	321	public function deepnessRepeat(&$uri, &$result, &$criteria, $original) {
[5715]	322
[6066]	323	if (!isset($criteria['deepness']) \|\| $criteria['deepness'] == 0)
	324	return;
	325
	326	$result['schedulable'] = Controller::find(array('concept' => 'schedulable'), false, array('filter' => array('=', 'id', $result['schedulable']), 'deepness' => intval($criteria['deepness']) - 1));
[5715]	327	$result['schedulable'] = $result['schedulable'][0];
[6066]	328	}
[5715]	329
[6066]	330	public function saveOccurrences(&$uri, &$result, &$criteria, $original) {
	331	$ranges = Controller::find(array('concept' => 'repeatRange'), array('rangeStart', 'rangeEnd'), array('filter' => array('=', 'user', Config::me("uidNumber"))));
[5715]	332
[6066]	333	if (!is_array($ranges) \|\| !isset($ranges[0]['rangeStart']) \|\| !isset($ranges[0]['rangeEnd']))
[5715]	334	return;
	335
[6066]	336	if (isset($result['id']))
	337	$id = $result['id'];
[5715]	338	else
[6066]	339	$id = $uri['id'];
[5715]	340
[6066]	341	$repeat = Controller::read(array('concept' => 'repeat', 'id' => $id));
[5715]	342
[6066]	343	unset($repeat['id']);
[5715]	344
[5741]	345	$exceptions = array();
[5715]	346
[6066]	347	if (isset($original['properties']['exceptions'])) {
	348	$exceptions = explode(',', $original['properties']['exceptions']);
[7953]	349	$event = Controller::read(array('concept' => 'schedulable', 'id' => $repeat['schedulable']));
	350
	351	if(array_key_exists(0, $event)) $event = $event[0];
	352
	353	$date = new DateTime('now', new DateTimeZone('UTC'));
	354
	355	foreach($exceptions as &$e){
	356	$date->setTimestamp((int) ($e / 1000));
	357	$date->setTimezone( new DateTimeZone( $event['timezone'] ));
	358	$e = ($date->getTimestamp() - $date->getOffset()).'000';
	359	}
	360
	361	unset($repeat['exceptions']);
[5741]	362	}
[6011]	363
[7953]	364	unset($repeat['schedulable']);
[5715]	365
[7953]	366	$lastExceptions = Controller::find(array('concept' => 'repeatOccurrence'), array("occurrence"), array('filter' => array('AND', array('=', 'repeat', $id), array('=', 'exception', 1))));
	367
[6345]	368	//Recurepa as execeções anteriores caso exista
[6066]	369	if (isset($lastExceptions) && count($lastExceptions) && $lastExceptions)
[6533]	370	foreach ($lastExceptions as $value)
	371	array_push($exceptions, $value['occurrence']);
[6066]	372
	373	$params = array_diff(self::decodeRepeat($repeat, $ranges[0]['rangeStart'], $ranges[0]['rangeEnd']), $exceptions);
	374
	375	Controller::delete(array('concept' => 'repeatOccurrence'), false, array('filter' => array('=', 'repeat', $id)));
	376
	377	if (!empty($params))
	378	Controller::service('PostgreSQL')->execResultSql("INSERT INTO calendar_repeat_occurrence(repeat_id,exception,occurrence)VALUES('" . $id . "','0','" . implode("'),('" . $id . "','0','", $params) . "')" . ( empty($exceptions) ? "" : ",('" . $id . "','1','" . implode("'),('" . $id . "','1','", $exceptions) . "')" ));
[6533]	379	else if(!empty($exceptions))
	380	Controller::service('PostgreSQL')->execResultSql("INSERT INTO calendar_repeat_occurrence(repeat_id,exception,occurrence)VALUES ('" . $id . "','1','" . implode("'),('" . $id . "','1','", $exceptions) . "')" );
[7953]	381	}
[5715]	382
[6160]	383	public function checkOccurrences($start, $end, $calendarIds) {
[5715]	384
[6066]	385	$ranges = Controller::find(array('concept' => 'repeatRange'), array('rangeStart', 'rangeEnd'), array('filter' => array('=', 'user', Config::me("uidNumber"))));
[5715]	386	$ranges = $ranges[0];
	387
	388	$origStart = $start;
	389	$origEnd = $end;
	390
[6066]	391	if ($initialized = (isset($ranges['rangeStart']) && isset($ranges['rangeEnd']))) {
	392	if ($ranges['rangeStart'] <= $start)
[5715]	393	$start = false;
[6066]	394	if ($ranges['rangeEnd'] >= $end)
[5715]	395	$end = false;
	396	}
	397
[6160]	398	$repeats = self::findRepeats($calendarIds);
[6066]	399	if (!is_array($repeats) \|\| empty($repeats))
[5715]	400	return( false );
	401
	402	$result = array();
	403	$ids = array();
	404
[6066]	405	foreach ($repeats as $repeat) {
	406	$ids[] = $id = $repeat['id'];
	407	unset($repeat['id']);
[5715]	408
[6066]	409	if (!isset($result[$id]))
	410	$result[$id] = !$initialized ? array($repeat['startTime']) : array();
[5715]	411
[6066]	412	if (!$initialized)
	413	$result[$id] = array_merge($result[$id], self::decodeRepeat($repeat, $start, $end));
	414	else {
	415	if ($start)
	416	$result[$id] = array_merge($result[$id], self::decodeRepeat($repeat, $start, $ranges['rangeStart']));
[5715]	417
[6066]	418	if ($end)
	419	$result[$id] = array_merge($result[$id], self::decodeRepeat($repeat, $ranges['rangeEnd'], $end));
[5715]	420	}
	421
[6066]	422	if (empty($result[$id]))
	423	unset($result[$id]);
[5715]	424	}
	425
[6066]	426	if ($start \|\| $end) {
	427	Controller::begin(array('service' => 'PostgreSQL'));
[5715]	428
[6393]	429	foreach ($result as $id => $res){
[7953]	430
	431	$ocurrences = array_unique($res);
	432
	433	/*
	434	* Check current range decoded
	435	* */
	436	$current = Controller::find(array('concept' => 'repeatOccurrence'), array("occurrence"), array('filter' => array('=', 'repeat', $id)));
	437	$toDiff = array();
	438
	439	if(!empty($current))
	440	foreach($current as $c) $toDiff[] = $c['occurrence'];
	441
	442	$ocurrences = array_diff($ocurrences, $toDiff);
	443
	444	if(!empty($ocurrences))
[6393]	445	Controller::service('PostgreSQL')->execResultSql("INSERT INTO calendar_repeat_occurrence(repeat_id,occurrence)VALUES('" . $id . "','" . implode("'),('" . $id . "', '", $ocurrences) . "')");
[7953]	446
	447	}
[5715]	448	$data = array();
	449
[6066]	450	if ($start)
[5715]	451	$data['rangeStart'] = $start;
	452
[6066]	453	if ($end)
[5715]	454	$data['rangeEnd'] = $end;
	455
[6066]	456	if (!$initialized)
	457	$data['user'] = Config::me('uidNumber');
[5715]	458
[6066]	459	Controller::call(( $initialized ? 'replace' : 'create'), array('concept' => 'repeatRange'), $data, array('filter' => array('=', 'user', Config::me('uidNumber'))));
[5715]	460
[6066]	461	Controller::commit(array('service' => 'PostgreSQL'));
[5715]	462	}
	463
[5741]	464	// $return = Controller::find( array( 'concept' => 'repeatOccurrence' ), false, array( 'filter' => array( 'AND', array( '>=', 'occurrence', $origStart ), array( '<=', 'occurrence', $origEnd ), array( 'IN', 'repeat', $ids ) ), 'deepness' => $deep ) );
[5715]	465
[7953]	466	$return = Controller::service('PostgreSQL')->execResultSql('SELECT calendar_repeat_occurrence.occurrence as "occurrence", calendar_repeat.object_id as "schedulable" FROM calendar_repeat, calendar_repeat_occurrence WHERE calendar_repeat_occurrence.occurrence >= \'' . $origStart . '\' AND calendar_repeat_occurrence.occurrence <= \'' . $origEnd . '\' AND calendar_repeat_occurrence.repeat_id IN (\'' . implode('\',\'', $ids) . '\') AND calendar_repeat.id = calendar_repeat_occurrence.repeat_id AND calendar_repeat_occurrence.exception != 1 order by calendar_repeat_occurrence.occurrence');
[5741]	467
[6066]	468	if (!is_array($return))
	469	return( false );
[5715]	470
	471	$result = array();
	472	$params = array();
[7989]	473	$realResult = array();
[6066]	474	foreach ($return as $ret) {
	475	$currentId = $ret['schedulable'];
[5715]	476
[6066]	477	if (!isset($result[$currentId])) {
	478	$result[$currentId] = Controller::read(array('concept' => 'schedulable', 'id' => $currentId));
	479	$result[$currentId]['occurrences'] = array();
	480	}
	481
	482	$result[$currentId]['occurrences'][] = $ret['occurrence'];
[5715]	483	}
	484
[7989]	485	foreach($result as $i => $v)
	486	{
	487	$calendarToCalendarObj = self::schedulable2calendarToObject($v['id']);
	488	foreach($calendarToCalendarObj as $vv)
	489	{
	490	$v['calendar'] = $vv['calendar_id'];
	491	$realResult[] = $v;
	492	}
[5715]	493	}
	494
[7989]	495	return( $realResult );
	496	}
	497
[6160]	498	public static function findRepeats($ids) {
	499	return Controller::service('PostgreSQL')->execResultSql('SELECT calendar_repeat.wkst as "wkst", calendar_repeat.byweekno as "byweekno", calendar_repeat.byminute as "byminute", calendar_repeat.bysecond as "bysecond", calendar_repeat.byyearday as "byyearday", calendar_repeat.bymonthday as "bymonthday", calendar_repeat.bysetpos as "bysetpos", calendar_repeat.byday as "byday", calendar_repeat.byhour as "byhour", calendar_repeat.interval as "interval", calendar_repeat.frequency as "frequency", calendar_repeat.until as "endTime", calendar_repeat.id as "id", calendar_repeat.count as "count", calendar_repeat.dtstart as "startTime" FROM calendar_repeat, calendar_to_calendar_object WHERE calendar_repeat.object_id = calendar_to_calendar_object.calendar_object_id AND calendar_to_calendar_object.calendar_id IN (\'' . implode('\',\'', $ids) . '\')');
[5715]	500	}
[6066]	501
[5715]	502	//HELPERS
[6066]	503	public static function decodeRepeat($repeat, $start, $end) {
[5715]	504
[6066]	505	date_default_timezone_set('UTC');
[5715]	506
[6066]	507	require_once ROOTPATH . '/plugins/when/When.php';
[5715]	508
[6066]	509	$r = new When();
[5715]	510
[6066]	511	if ($repeat['frequency'] === 'none')
	512	return( array() );
	513
[6345]	514	//Nao deve ser usando o horário da repeticao pois nela contem apenas o dias,
	515	//deve se recuperar o horário do evento para um correto calculo.
[6066]	516	if (max($start, $repeat['startTime']) != $repeat['startTime']) {
	517	$time = new DateTime('@' . (int) ( $repeat['startTime'] / 1000 ), new DateTimeZone('UTC'));
	518
	519	$hoursOcurrence = new DateTime('@' . (int) ( $start / 1000 ), new DateTimeZone('UTC'));
	520	$hoursOcurrence = $hoursOcurrence->format('H');
	521
	522	$diffTime = ((($time->format('H') - $hoursOcurrence) * (3600000)) + ($time->format('i') * (60000)));
	523	$start = new DateTime('@' . (int) ( ( $start + $diffTime ) / 1000 ), new DateTimeZone('UTC'));
	524	}else
	525	$start = new DateTime('@' . (int) ( max($start, $repeat['startTime']) / 1000 ), new DateTimeZone('UTC'));
	526
	527	foreach ($repeat as $rule => $value) {
	528	if (!isset($value) \|\| !$value \|\| $value === "0")
[5715]	529	continue;
	530
[6066]	531	switch (strtolower($rule)) {
	532	case "starttime": break;
	533	case "frequency":
	534	$r->recur($start, $value);
	535	break;
	536	case "endtime":
	537	$r->until(new DateTime('@' . (int) ( $value / 1000 )));
	538	break;
	539	case "count": case "interval": case "wkst":
	540	$r->$rule($value);
	541	break;
	542	default :
	543	$r->$rule(!is_array($value) ? explode(',', $value) : $value );
	544	break;
	545	}
	546	}
[5715]	547
[6066]	548	$return = array();
[5715]	549
[6066]	550	while ($result = $r->next()) {
	551	$u = $result->format('U') * 1000;
[5715]	552
[6345]	553	if ($u > $end) //data da repetição atual maior que a data final da busca do usuario ?
[6066]	554	break;
	555
	556	$return[] = $u;
	557	}
	558
	559	return( $return );
[5715]	560	}
	561
[5341]	562	///////////////////////////////////////////////////////////////////////////////////////////////////////////////
	563
[6331]	564	public function updateCalendar(&$uri, &$params, &$criteria, $original) {
	565	if (isset($params['calendar'])) {
	566	if(isset($params['lastCalendar'])){
	567	$calendarObjects = self::referenceCalendarToObject($uri['id'], $params['lastCalendar']);
	568	$params2['calendar'] = $params['calendar'];
	569	}else{
	570	$calendarObjects = self::schedulable2calendarToObject($uri['id']);
	571	$params2['calendar'] = $params['calendar'];
	572	}
	573
	574	foreach ($calendarObjects as $calendarObject)
[6066]	575	Controller::update(array('concept' => 'calendarToSchedulable', 'id' => $calendarObject['calendar_to_calendar_object']), $params2);
	576
	577	unset($params['calendar']);
	578
	579	if (count($params) < 1)
	580	return false;
	581	}
	582	}
	583
[7590]	584	public function setLastUpdateSchedulable(&$uri, &$params, &$criteria, $original) {
	585	$params['lastUpdate'] = time() * 1000;
	586	}
	587
[7097]	588	//Encode Update
[6066]	589	public function encodeUpdateSchedulable(&$uri, &$params, &$criteria, $original) {
[7097]	590	$event = Controller::read(array('concept' => 'schedulable', 'id' => $uri['id']));
[6996]	591	if (isset($params['startTime'])) {
[5341]	592
[6996]	593	if (!is_numeric($params['startTime']))
	594	$params['startTime'] = self::parseTimeDate($params['startTime'], $event['timezone']);
[5341]	595
[6996]	596	$params['rangeStart'] = $params['startTime'];
	597	}
[6066]	598
[6996]	599	if (isset($params['endTime'])) {
[6066]	600
[6996]	601	if (!is_numeric($params['endTime'])) {
	602	$params['endTime'] = self::parseTimeDate($params['endTime'], $event['timezone']);
	603
	604	if ((isset($params['allDay']) && $params['allDay']) \|\| ( !isset($params['allDay']) && $event['allDay']))
	605	$params['endTime'] = $params['endTime'] + 86400000;
	606	}
	607	$params['rangeEnd'] = $params['endTime'];
[7680]	608
	609	if($event['type'] == '2'){
	610
	611	if(!isset($params['due']) && $params['endTime'] != $event['endTime'])
	612	$params['due'] = $params['endTime'];
	613
	614	}
[6996]	615	}
	616
[7680]	617	if (isset($params['due']) && $params['due'] != '' && !is_numeric($params['due'])){
[6996]	618	$params['due'] = self::parseTimeDate($params['due'], $event['timezone']);
	619
[7680]	620	if ((isset($params['allDay']) && $params['allDay']) \|\| ( !isset($params['allDay']) && $event['allDay']))
	621	$params['due'] = $params['due'] + 86400000;
	622	}
	623
[6996]	624	if($event['type'] == '2'){
	625	$criteria['historic'] = $params;
	626	$criteria['beforeValue'] = $event;
	627
	628	if(isset($params['startTime']) && $params['startTime'] == $event['startTime'])
	629	unset($criteria['historic']['startTime']);
	630	if(isset($params['due']) && $params['due'] == $event['due'])
	631	unset($criteria['historic']['due']);
	632
[7680]	633	//necessário para atulizar a atividade de composta pela tarefa aqui sendo atualizada
	634	if(isset($criteria['historic']['startTime']) \|\| isset($criteria['historic']['endTime'])){
[7861]	635	/*
	636	* Verify current task is built-in activity
	637	* */
[7680]	638	$taskToActivity = Controller::find(array('concept' => 'taskToActivity'), false, array('filter' => array('AND', array('=', 'task', $uri['id']), array('=', 'owner', Config::me('uidNumber'))), 'deepness' => 2));
	639	if(!empty($taskToActivity)){
	640	$activity = Controller::read(array('concept' => 'schedulable', 'id' => $taskToActivity[0]['activity']), array('startTime', 'endTime', 'rangeStart', 'rangeEnd', 'allDay'));
	641	$isAllDay = 1;
[6996]	642
[7861]	643	/*
	644	* Get all task in activity
	645	* */
	646	$taskToActivity = Controller::find(array('concept' => 'taskToActivity'), false, array('filter' => array('AND', array('=', 'activity', $taskToActivity[0]['activity']), array('=', 'owner', Config::me('uidNumber'))), 'deepness' => 2));
	647
[7680]	648	if(!empty($activity)){
	649	$start = $params['startTime'];
	650	$end = $params['endTime'];
	651	foreach($taskToActivity as $t){
[7861]	652
	653
	654	if($t['task']['id'] != $params['id']){
	655	$start = $t['task']['startTime'] < $start ? $t['task']['startTime'] : $start;
	656	$end = $t['task']['endTime'] > $end ? $t['task']['endTime'] : $end;
	657	$isAllDay = (($isAllDay == 1) && ($t['task']['allDay'] == '1')) ? 1 : 0;
	658	}
[7680]	659	}
[6996]	660
[7680]	661	if($event['allDay'] == '0' \|\| (isset($params['allDay']) && $params['allDay'] == '0'))
	662	$isAllDay = 0;
[7097]	663
[7680]	664	$toUpdate = array();
[7097]	665
[7680]	666	if($start != $activity['startTime'])
	667	$toUpdate['startTime'] = $start;
[7097]	668
[7680]	669	if($end != $activity['endTime']){
	670	$toUpdate['endTime'] = $end;
	671	$toUpdate['due'] = $end;
	672	}
[7097]	673
[7680]	674	if($isAllDay != $activity['allDay'])
	675	$toUpdate['allDay'] = $isAllDay;
[7097]	676
[7680]	677	if(!empty($toUpdate))
	678	Controller::update(array('concept' => 'schedulable', 'id' => $taskToActivity[0]['activity']), $toUpdate);
	679	}
	680	}
	681	}
[7861]	682	/*
	683	* Clean historic not used
	684	* */
[7680]	685	unset($criteria['historic']['endTime']);
	686	unset($criteria['historic']['rangeEnd']);
	687	unset($criteria['historic']['rangeStart']);
	688	unset($criteria['historic']['class']);
	689	unset($criteria['historic']['type']);
	690	unset($criteria['historic']['allDay']);
	691	unset($criteria['historic']['id']);
[6996]	692	}
[6066]	693	}
	694
	695	static function putEvent(&$uri, &$result, &$criteria, $original) {
	696	if (Config::module('useCaldav', 'expressoCalendar')) { //Ignorar Put dos eventos ja vindos do caldav
	697	require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
	698
	699	$eventID = (isset($result['id'])) ? $result['id'] : $uri['id'];
	700	$event = Controller::read(array('concept' => 'schedulable', 'id' => $eventID));
	701
	702	$participants = Controller::find(array('concept' => 'participant'), false, array('filter' => array('=', 'schedulable', $eventID)));
	703
	704	if (is_array($participants) && count($participants) > 0)
	705	foreach ($participants as $ii => $vv) {
	706	if ($vv['isExternal'] == 1)
	707	$participants[$ii]['user'] = Controller::read(array('concept' => 'user', 'id' => $vv['user'], 'service' => 'PostgreSQL'));
	708	else
	709	$participants[$ii]['user'] = Controller::read(array('concept' => 'user', 'id' => $vv['user']));
	710	}
	711
	712	$event['URI']['concept'] = 'schedulable';
	713	$event['participants'] = $participants;
	714
	715	$ical = Controller::format(array('service' => 'iCal'), array($event));
	716	$calendars = self::schedulable2calendarToObject($original['properties']['id']); //Busca os calendarios do usuario logado que contenham o evento
	717	if (is_array($calendars))
	718	foreach ($calendars as $calendar)
	719	DAViCalAdapter::putIcal($ical, array('uid' => $event['uid'], 'location' => $calendar['calendar_location']));
	720	}
	721	}
	722
[6996]	723
	724	static function prepareParticipantHistoric(&$uri, &$params, &$criteria, $original){
	725	$participant = Controller::read(array('concept' => 'participant', 'id' => $uri['id']));
	726	$schedulable = Controller::read(array('concept' => 'schedulable', 'id' => $participant['schedulable']));
	727
	728
	729	if($schedulable['type'] == '2')
	730	$criteria['historic']['participant'] = $participant;
	731	}
	732
	733	static function removeParticipantHistoric(&$uri, &$params, &$criteria, $original){
	734	if(isset($criteria['historic'])){
	735
	736	$participant = $criteria['historic']['participant'];
	737
	738	Controller::create(array('concept' => 'calendarHistoric'),
	739	array('schedulable' => $participant['schedulable'],
	740	'user' => Config::me('uidNumber'),
	741	'time' => time() . '000',
	742	'attribute' => 'participant',
	743	'beforeValue' => $participant['user'],
	744	'afterValue' => ''
	745	)
	746	);
	747
	748	}
	749
	750	}
	751
	752	static function createParticipantHistoric(&$uri, &$params, &$criteria, $original){
	753
[7405]	754	if(isset($original['properties']) && isset($original['properties']['isOrganizer']) && $original['properties']['isOrganizer'] != '1'){
[6996]	755	if(!isset($criteria['event'])){
	756	$event = Controller::read(array('concept' => 'schedulable', 'id' => $original['properties']['schedulable']));
	757	$criteria['event'] = $event;
	758	}else
	759	$event = $criteria['event'];
	760
	761	if($event['type'] == '2'){
	762	Controller::create(array('concept' => 'calendarHistoric'),
	763	array('schedulable' => $original['properties']['schedulable'],
	764	'user' => Config::me('uidNumber'),
	765	'time' => time() . '000',
	766	'attribute' => 'participant',
	767	'beforeValue' => '',
	768	'afterValue' => $original['properties']['user']
	769	)
	770	);
	771	}
	772	}
	773	}
	774
[7980]	775	static function autoImportCalendar(&$uri, &$params, &$criteria, $original){
	776	$autoCommit = Controller::service('PostgreSQL')->execResultSql('Select config_value FROM phpgw_config WHERE config_app = \'expressoCalendar\' AND config_name = \'expressoCalendar_autoImportCalendars\'');
	777
	778
	779	if(isset($autoCommit[0]) && $autoCommit[0]['config_value'] == 'true')
	780	{
	781	if(isset($original['properties']) && isset($original['properties']['user']) && isset($original['properties']['isOrganizer']) && $original['properties']['isOrganizer'] != '1')
	782	{
	783	$defaultCalendar = Controller::find(array('concept' => 'modulePreference'), array('value') , array('filter' => array( 'and' , array('=' , 'name' , 'dafaultImportCalendar') , array('=' , 'module' , 'expressoCalendar') , array('=' , 'user' , $original['properties']['user']) )) );
	784	if(isset($defaultCalendar[0]) && $defaultCalendar[0]['value'] > 0)
	785	{
	786	Controller::create(array('concept' => 'calendarToSchedulable'),
	787	array('schedulable' => $original['properties']['schedulable'],
	788	'calendar' => $defaultCalendar[0]['value']
	789	)
	790	);
	791	}
	792	}
	793	}
	794	}
	795
[6996]	796	static function createHistoric(&$uri, &$result, &$criteria, $original) {
	797
	798	if(isset($criteria['historic']) && count($criteria['historic'])){
	799	$time = time() . '000';
	800
	801	foreach($criteria['historic'] as $k => $v){
	802	Controller::create(array('concept' => 'calendarHistoric'),
	803	array('schedulable' => $uri['id'],
	804	'user' => Config::me('uidNumber'),
	805	'time' => $time,
	806	'attribute' => $k,
	807	'beforeValue' => $criteria['beforeValue'][$k],
	808	'afterValue' => $v
	809	)
	810	);
	811	}
	812	}
	813	}
	814
[5341]	815	///////////////////////////////////////////////////////////////////////////////////////////////////////////////
[6066]	816
	817	public function verifyCalendarLocation(&$uri, &$params, &$criteria, $original) {
	818	if (!isset($params['location']))
	819	$params['location'] = Config::me('uid') . '/' . $params['name'];
	820	}
	821
[5341]	822	//TODO: Remover apos suporte a ManytoMany na api
[6066]	823	public function createCalendarToSchedulable(&$uri, &$result, &$criteria, $original) {
[5341]	824
[6066]	825	Controller::create(array('concept' => 'calendarToSchedulable'), array('calendar' => $original['properties']['calendar'], 'schedulable' => $result['id']));
	826	}
[5514]	827
[6996]	828	//TODO: Remover apos suporte a ManytoMany na api
	829	public function createTasksToActivity(&$uri, &$result, &$criteria, $original) {
	830
	831	if(isset($original['properties']['taskToActivity']) && $original['properties']['taskToActivity']){
	832
	833	foreach($original['properties']['taskToActivity'] as $relational)
	834
	835	Controller::create(array('concept' => 'taskToActivity'), array('task' => $relational['task'], 'owner' => $relational['owner'], 'activity' => $result['id']));
	836
	837	}
[6066]	838	}
[5514]	839
[6996]	840	public function removeAttachmentHistoric(&$uri, &$params, &$criteria, $original) {
	841
	842	if(isset($criteria['historic'])){
	843	$attachment = $criteria['historic']['attachment'];
	844
	845	$attachment['attachment'] = Controller::read(array('concept' => 'attachment', 'id' => $attachment['attachment']), array('name'));
	846	Controller::create(array('concept' => 'calendarHistoric'),
	847	array('schedulable' => $attachment['schedulable'],
	848	'user' => Config::me('uidNumber'),
	849	'time' => time() . '000',
	850	'attribute' => 'attachment',
	851	'beforeValue' => $attachment['attachment']['name'],
	852	'afterValue' => ''
	853	)
	854	);
	855
	856	}
	857
	858	}
	859
	860	public function createAttachmentHistoric(&$uri, &$params, &$criteria, $original) {
	861	$event = Controller::read(array('concept' => 'schedulable', 'id' => $original['properties']['schedulable']));
	862
	863	if($event['type'] == '2'){
	864	$attachment = Controller::read(array('concept' => 'attachment', 'id' => $original['properties']['attachment']), array('name'));
	865
	866	Controller::create(array('concept' => 'calendarHistoric'),
	867	array('schedulable' => $original['properties']['schedulable'],
	868	'user' => Config::me('uidNumber'),
	869	'time' => time() . '000',
	870	'attribute' => 'attachment',
	871	'beforeValue' => '',
	872	'afterValue' => $attachment['name']
	873	)
	874	);
	875
	876	}
	877	}
	878
[7164]	879	public function deepnessFindCalendarShared(&$uri, &$result, &$criteria, $original) {
[7041]	880	if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != '0' && count($result) > 0) {
[6299]	881
[7041]	882	$calendarIds = array();
[7164]	883	foreach ($result as $value)
	884	$calendarIds[] = $value['calendar'];
[5592]	885
[7041]	886	$calendar = Controller::find(array('concept' => 'calendar'), false, array('filter' => array('AND', array('IN', 'id', $calendarIds))));
[5592]	887
[7041]	888	if ($calendar && count($calendar) > 0){
	889	$newResult = array();
[7164]	890	foreach ($calendar as $value) {
	891	foreach ($result as $r) {
[5804]	892
[7041]	893	if ($r['calendar'] == $value['id']) {
	894	$r['calendar'] = $value;
[7164]	895	$newResult[] = $r;
[7041]	896	}
	897	}
	898	}
[5592]	899
[7164]	900	foreach ($newResult as &$value) {
[7041]	901	if ($value['user'] != 0) {
[7164]	902	$value['user'] = Controller::read(array('concept' => 'user', 'id' => $value['user']));
[6066]	903
[7041]	904	if (!$value['user'])
[7164]	905	$value['user'] = Controller::read(array('concept' => 'group', 'id' => $value['user']));
[7041]	906	}
[7164]	907	$value['owner'] = Controller::read(array('concept' => 'user', 'id' => $value['owner']));
[7041]	908	}
	909	$result = $newResult;
	910	}else
	911	$result = '';
	912	}
[6066]	913	}
	914
[7861]	915	public function getCalendarTask( $task ){
	916
	917	$sql = 'select co.calendar_id as "calendar" from calendar_to_calendar_object as "co", calendar_signature as "cs" where cs.user_uidnumber = '. Config::me('uidNumber')
	918	.' AND cs.is_owner = 1 AND cs.calendar_id = co.calendar_id AND co.calendar_object_id = '. $task;
	919
	920
	921	$returns = Controller::service('PostgreSQL')->execResultSql($sql);
	922
	923	return $returns[0]['calendar'];
	924	}
	925
[5341]	926	//TODO: Remover apos suporte a deepness na api
[6996]	927	public function deepnessFindTask(&$uri, &$result, &$criteria, $original) {
[7861]	928	if (isset($criteria['deepness']) && $criteria['deepness'] != 0){
	929
	930	foreach($result as &$value){
	931
[6996]	932	$value['task'] = Controller::read(array('concept' => 'schedulable', 'id' => $value['task']));
[7861]	933	$value['task']['calendar'] = self::getCalendarTask( $value['task']['id'] );
	934	}
	935
	936	return $result;
	937	}
[6996]	938	}
	939
	940	//TODO: Remover apos suporte a deepness na api
	941	public function deepnessFindHistoric(&$uri, &$result, &$criteria, $original) {
[7861]	942	if (isset($criteria['deepness']) && $criteria['deepness'] != 0) {
[6996]	943	foreach($result as &$v){
	944	$v['user'] = Controller::read(array('concept' => 'user', 'id' => $v['user']));
	945
	946	if($v['attribute'] == 'participant'){
	947	if($v['beforeValue'] != '')
	948	$v['beforeValue'] = Controller::read(array('concept' => 'user', 'id' => $v['beforeValue']));
	949
	950	if($v['afterValue'] != '')
	951	$v['afterValue'] = Controller::read(array('concept' => 'user', 'id' => $v['afterValue']));
	952	}
	953	}
	954	}
	955	}
	956
[7702]	957	//TODO: Remover apos suporte a deepness na api
	958	public function findDeepnessOne(&$uri, &$params, &$criteria, $original){
	959
	960	if (isset($criteria['findOne']) && $criteria['findOne'] == '1') {
	961
	962	$sql = ' SELECT DISTINCT calendar_object.id as id ,calendar_object.cal_uid as "uid", calendar_object.type_id as "type", '
	963	.'calendar_object.dtstart as "startTime", calendar_object.summary as "summary", '
	964	.'calendar_object.description as "description", calendar_object.dtend as "endTime" , '
	965	.'calendar_object.priority as "priority", calendar_object.due as "due", '
	966	.'calendar_object.percentage as "percentage", calendar_object.status as "status", '
	967	.'calendar_object.location as "location", calendar_object.allday as "allDay", '
	968	.'calendar_object.transp as "transparent", calendar_object.class_id as "class", '
	969	.'calendar_object.repeat as "repeat", calendar_object.range_start as "rangeStart", '
	970	.'calendar_object.range_end as "rangeEnd", calendar_object.last_update as "lastUpdate", '
	971	.'calendar_object.dtstamp as "dtstamp", calendar_object.sequence as "sequence", '
[7861]	972	.'calendar_object.tzid as "timezone", calendar_to_calendar_object.calendar_id as "calendar" '
	973	.'FROM calendar_object, calendar_to_calendar_object '
[7973]	974	.'WHERE ( calendar_object.id = '. $criteria['schedulable'] .' AND calendar_to_calendar_object.calendar_object_id = calendar_object.id'
	975	.' AND calendar_to_calendar_object.calendar_id IN (select calendar_id from calendar_signature where calendar_signature.user_uidnumber = '. Config::me('uidNumber') .' ) )';
[7702]	976
	977	$params = Controller::service('PostgreSQL')->execResultSql($sql);
	978
[7861]	979	foreach( $params as &$event ){
	980
	981
	982	if(isset( $event['repeat'] ) && isset( $event['repeat']['id'] ) ){
	983	$occurrences = Controller::service('PostgreSQL')->execResultSql('SELECT DISTINCT occurrence FROM calendar_object as "c", calendar_repeat_occurrence as "o", calendar_repeat as "r" WHERE r.object_id = '. $event['id'] .' AND o.repeat_id = r.id ' );
	984
	985	if($occurrences){
	986	$event['occurrences'] = array();
	987
	988	foreach($occurrences as $o)
	989	$event['occurrences'][] = $o['occurrence'];
	990	}else
	991	unset( $event['occurrences'] );
	992	}
	993	}
	994
[7702]	995	$params = self::deepnessFindEvent($uri, $params, $criteria, $original);
	996	return false;
	997	}
	998	}
	999
[6996]	1000	//TODO: Remover apos suporte a deepness na api
[6066]	1001	public function deepnessFindEvent(&$uri, &$result, &$criteria, $original) {
[7861]	1002	if ((isset($criteria['deepness']) && $criteria['deepness'] != 0) ) {
[5592]	1003
[7579]	1004	$date = new DateTime('now', new DateTimeZone('UTC'));
	1005	$DayLigth = array();
[5592]	1006
[7579]	1007	foreach ($result as $i => $v) {
[6066]	1008
[7660]	1009	$currentTimezone = (isset($v['calendar']) && isset($original['criteria']['timezones'][$v['calendar']])) ? $original['criteria']['timezones'][$v['calendar']] : $v['timezone'];
[6066]	1010
[7579]	1011	$date->setTimestamp((int) ($v['startTime'] / 1000));
	1012	$date->setTimezone( new DateTimeZone( $v['timezone'] ));
	1013	$DayLigth['event']['startTime'] = ($date->getTimestamp() + $date->getOffset()).'000';
[6066]	1014
[7579]	1015	$date->setTimezone( new DateTimeZone($currentTimezone));
	1016	$DayLigth['calendar']['startTime'] = ($date->getTimestamp() + $date->getOffset()).'000';
[6066]	1017
[7579]	1018	$date->setTimestamp((int) ($v['endTime'] / 1000));
	1019	$date->setTimezone( new DateTimeZone($currentTimezone));
	1020	$DayLigth['event']['endTime'] = ($date->getTimestamp() + $date->getOffset()).'000';
[6066]	1021
[7680]	1022	if(isset($v['due']) && $v['due'] != '0'){
	1023	$date->setTimestamp((int) ($v['due'] / 1000));
	1024	$DayLigth['event']['due'] = ($date->getTimestamp() + $date->getOffset()).'000';
	1025	}else{
	1026	$DayLigth['event']['due'] = $v['due'];
	1027	}
	1028
	1029
[7579]	1030	$date->setTimezone( new DateTimeZone($currentTimezone));
	1031	$DayLigth['calendar']['endTime'] = ($date->getTimestamp() + $date->getOffset()).'000';
[6066]	1032
	1033
[7579]	1034	$result[$i]['DayLigth'] = $DayLigth;
[6996]	1035
[7579]	1036	if(((int)$v['type']) == 2){
[6996]	1037
[7579]	1038	$taskToActivity = Controller::find(array('concept' => 'taskToActivity'), false, array('filter' => array('AND', array('=', 'activity', $v['id']), array('=','owner', Config::me('uidNumber'))) , 'deepness' => 2));
[6996]	1039
[7579]	1040	if($taskToActivity)
	1041	$result[$i]['taskToActivity'] = $taskToActivity;
[6996]	1042
[7579]	1043	$result[$i]['historic'] = Controller::find(array('concept' => 'calendarHistoric'), false, array('filter' => array('=', 'schedulable', $v['id']) , 'deepness' => 2));
[6996]	1044
[7579]	1045	}
[6066]	1046
[7660]	1047	if(isset( $v['occurrences'] ) && count( $v['occurrences'] ) > 0){
	1048
[7956]	1049	$date->setTimestamp((int) ($v['startTime'] / 1000));
	1050	$date->setTimezone( new DateTimeZone( $v['timezone'] ));
	1051
[7660]	1052	foreach( $result[$i]['occurrences'] as &$o){
	1053
[7956]	1054	$o = ($o + $date->getOffset()).'000';
[7660]	1055
	1056	}
	1057	}
	1058
[7579]	1059	if (isset($v['id'])) {
	1060	$data = self::decodeParticipantsEvent($uri, $v, $criteria, $original);
[6476]	1061
[7579]	1062	$result[$i]['statusAttendees'] = isset($data['statusAttendees']) ? $data['statusAttendees'] : false;
	1063	$result[$i]['sizeAttendees'] = isset($data['sizeAttendees']) ? $data['sizeAttendees'] : false;
	1064	$result[$i]['participants'] = $data['attendees'];
[5715]	1065
[7579]	1066	$attachmentRelation = Controller::find(array('concept' => 'schedulableToAttachment'), false, array('filter' => array('=', 'schedulable', $v['id'])));
	1067	if (is_array($attachmentRelation)) {
	1068	$attachments = array();
	1069	foreach ($attachmentRelation as $key => $value)
	1070	if (isset($value['attachment']) \|\| !!$value['attachment'])
	1071	$attachments[$key] = $value['attachment'];
	1072	//Pega os anexos sem source
	1073	$result[$i]['attachments'] = Controller::find(array('concept' => 'attachment'), array('id', 'name', 'type', 'size'), array('filter' => array('IN', 'id', $attachments)));
	1074	}
[5715]	1075
[7579]	1076	$repeat = Controller::find(array('concept' => 'repeat'), false, array('filter' => array('=', 'schedulable', $v['id'])));
[5741]	1077
[7579]	1078	unset($result[$i]['repeat']);
[5592]	1079
[7579]	1080	if (is_array($repeat))
	1081	$result[$i]['repeat'] = $repeat[0];
	1082	}
	1083	}
	1084	}
	1085
	1086	return $result;
[6066]	1087	}
[7579]	1088
[6114]	1089	//TODO: Remover apos suporte a deepness na api
[7590]	1090	public static function deepnessReadParticipant( &$uri , &$result , &$criteria , $original ){
[6177]	1091
[7861]	1092	if(isset($criteria['deepness']) && $criteria['deepness'] != 0)
[6114]	1093	{
[6286]	1094	if(isset($result['id']) && isset($result['user']))
[6114]	1095	{
	1096	$result['user'] = Controller::read( array( 'concept' => 'user' , 'id' => $result['user'] , 'service' => ( $result['isExternal'] == 1 ? 'PostgreSQL' : 'OpenLDAP' ) ) );
[5341]	1097
[6114]	1098	if($result['user']['id'] == Config::me('uidNumber'))
	1099	$result['alarms'] = Controller::find( array( 'concept' => 'alarm' ) , null , array('filter' => array('=', 'participant' ,$result['id'] ) ) );
	1100	}
	1101	}
[6177]	1102
	1103
	1104
[6114]	1105	}
[6066]	1106
[6111]	1107	//TODO: Remover apos suporte a deepness na api
	1108	public function deepnessReadEvent( &$uri , &$result , &$criteria , $original ){
[6177]	1109
[6111]	1110	if(isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
	1111	{
	1112	if(isset($result['id']))
	1113	{
[6177]	1114	$result['participants'] = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=' , 'schedulable' , $result['id']), 'deepness' => $original['criteria']['deepness'] - 1) );
[5341]	1115
[6111]	1116	$repeat = Controller::find( array( 'concept' => 'repeat' ), false, array( 'filter' => array( '=', 'schedulable', $result['id'] ) ) );
[6066]	1117
[6111]	1118	if(is_array($repeat))
	1119	$result['repeat'] = $repeat[0];
[6177]	1120	}
	1121
[6111]	1122	}
[6996]	1123
	1124	if(isset($result['id']) && $result['type'] == '2'){
	1125	$result['historic'] = Controller::find( array( 'concept' => 'calendarHistoric' ), false, array( 'filter' => array( '=', 'schedulable', $result['id'] ) ) );
	1126	}
[6111]	1127	}
	1128
[5341]	1129	//TODO: Remover apos suporte a deepness na api
[7590]	1130	public static function deepnessFindParticipant( &$uri , &$result , &$criteria , $original ){
[6111]	1131	if(isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
	1132	{
	1133	foreach ($result as $i => &$v)
	1134	{
	1135	self::deepnessReadParticipant( $uri, $v, $criteria, $original );
[6177]	1136	}
	1137	}
[6111]	1138
	1139	}
[6066]	1140
[5341]	1141	//TODO: Remover apos suporte a deepness na api
[6066]	1142	public function deepnessReadCalendarSignature(&$uri, &$result, &$criteria, $original) {
[5641]	1143
[6066]	1144	if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0)
	1145	if (isset($result['calendar'])) {
	1146	$result['calendar'] = Controller::read(array('concept' => 'calendar', 'id' => $result['calendar']));
	1147	$result['defaultAlarms'] = Controller::find(array('concept' => 'calendarSignatureAlarm'), false, array('filter' => array('=', 'calendarSignature', $result['id'])));
	1148	}
	1149	}
[5592]	1150
[6066]	1151	//TODO: Remover apos suporte a deepness na api
	1152	public function deepnessFindCalendarSignature(&$uri, &$result, &$criteria, $original) {
[5641]	1153
[6066]	1154	if (isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0) {
	1155	foreach ($result as $i => $v) {
	1156	if (isset($v['calendar'])) {
	1157	$result[$i]['calendar'] = Controller::read(array('concept' => 'calendar', 'id' => $v['calendar']), false, false);
	1158	$result[$i]['defaultAlarms'] = Controller::find(array('concept' => 'calendarSignatureAlarm'), false, array('filter' => array('=', 'calendarSignature', $v['id'])));
[6345]	1159	//Caso não seja o dono da agenda retorna o objeto permission com as acls
[6066]	1160	if ($result[$i]['isOwner'] == 0) {
[7164]	1161	$permission = Controller::find(array('concept' => 'calendarToPermission'), false, array('filter' => array('AND', array('=', 'calendar', $v['calendar']), array('=', 'user', Config::me('uidNumber')), 'deepness' => 2)));
[5641]	1162
[6066]	1163	if (!is_array($permission) \|\| !$permission) {
	1164
[7164]	1165	$permission = Controller::find(array('concept' => 'calendarToPermission'), false, array('filter' => array('AND', array('=', 'calendar', $v['calendar']), array('=', 'type', '1')), 'deepness' => 2 ));
[6066]	1166	}
	1167	$result[$i]['permission'] = $permission[0];
	1168	}
	1169	}
	1170	//TODO - Padronizar retorno do deepness
[7747]	1171
	1172	if (isset($v['user']))
	1173
	1174	$user = $v['user'];
	1175	$result[$i]['user'] = Controller::read(array('concept' => 'user', 'id' => $v['user']), false, false);
[6066]	1176	}
[7747]	1177
	1178	if(empty( $result[$i]['user'] ) \|\| count( $result[$i]['user'] ) == 0 ){
	1179	$result[$i]['user'] = Controller::read(array( 'concept' => 'group', 'id' => $user) );
	1180
	1181	}
	1182
	1183
[6066]	1184	}
	1185	}
	1186
[5341]	1187	//Decode Find
[7590]	1188	// public function decodeFindConcept(&$uri, &$result, &$criteria, $original) {
	1189	// if ($result && is_array($result)) {
	1190	// $m = array_flip(self::${$uri['concept'] . 'Map'});
	1191	// $new = array();
	1192	// foreach ($result as $i => $v)
	1193	// $new[$i] = self::parseConcept($result[$i], $m);
	1194	//
	1195	//
	1196	// $result = $new;
	1197	// }
	1198	// }
[5341]	1199
[7170]	1200	public function addOwner(&$uri, &$params, &$criteria, $original) {
	1201	$owner = Controller::read( array( 'concept' => 'calendarSignature' ) , array('user') ,array( 'filter' => array('AND', array('=', 'isOwner' , '1'), array('=', 'calendar', $params['calendar']))));
	1202	$params['owner'] = $owner[0]['user'];
	1203	}
	1204
[7590]	1205	// public function decodeFindSchedulable(&$uri, &$result, &$criteria, $original) {
	1206	// if ($result && is_array($result)) {
	1207	// $m = array_flip(self::${$uri['concept'] . 'Map'});
	1208	// $m['calendar_id'] = 'calendar';
	1209	// $new = array();
	1210	// foreach ($result as $i => $v)
	1211	// $new[$i] = self::parseConcept($result[$i], $m);
	1212	//
	1213	//
	1214	// $result = $new;
	1215	// }
	1216	// }
[5341]	1217
[6066]	1218	public function decodeFindAttachment(&$uri, &$result, &$criteria, $original) {
	1219	if (isset($result))
	1220	foreach ($result as $key => &$value)
	1221	$value['source'] = base64_decode($value['source']);
[5514]	1222	}
	1223
[6066]	1224	public function decodeSignatureAlarmType(&$uri, &$result, &$criteria, $original) {
	1225	if (is_array($result))
	1226	foreach ($result as &$param)
	1227	if (isset($param['type']))
	1228	$param['type'] = self::decodeAlarmType($param['type']);
[5341]	1229	}
[6066]	1230
[5341]	1231	/////////////////////////////////////////////////////////////////////////
	1232
[6476]	1233	static function decodeParticipantsEvent( &$uri, $result, &$criteria, $original) {
	1234	$participants = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('=', 'schedulable' , $result['id']) ));
	1235
	1236	if($participants && ($size = count($participants)) < 100){
	1237	if(isset($original['criteria']['deepness']) && $original['criteria']['deepness'] != 0){
	1238	self::deepnessFindParticipant($uri, $participants, $criteria, $original);
	1239	$participants['attendees'] = $participants;
	1240	}
	1241
	1242	}else if($participants && ($size = count($participants)) > 100){
	1243	$owner = Controller::read( array( 'concept' => 'calendarSignature' ) , false ,array( 'filter' => array('AND', array('=', 'calendar' , $result['calendar']), array('=', 'isOwner', '1'))));
	1244	$owner = Controller::read( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('AND', array('=', 'schedulable' , $result['id']), array('=', 'user', $owner[0]['user'])), 'deepness' => 2));
	1245
	1246	if(is_array($owner))
	1247	$owner = $owner[0];
	1248
	1249	$reference = array_slice($participants, 0, 100);
	1250	$organizer = false;
	1251	$asOwner = false;
	1252
	1253	foreach($reference as $r => &$v){
	1254	if($v['id'] == $owner['id']){
	1255	$v = $owner;
	1256	$asOwner = true;
	1257	continue;
	1258	}
	1259
	1260	self::deepnessReadParticipant($uri, $v, $criteria, $original);
	1261
	1262	if($v['isOrganizer'] == "1" )
	1263	$organizer = $v;
	1264	}
	1265
	1266	if(!$organizer){
	1267	$organizer = Controller::find( array( 'concept' => 'participant' ) , false ,array( 'filter' => array('AND', array('=', 'schedulable' , $result['id']), array('=', 'isOrganizer', '1')), 'deepness' => 2));
	1268
	1269	array_push($reference, $organizer[0]);
	1270
	1271	}else if($organizer && ($organizer['id'] != $owner['id']))
	1272	array_merge($reference, $organizer);
	1273
	1274	if(!$asOwner)
	1275	array_push($reference, $owner);
	1276
	1277	$statusAttendees = array( 'default' => 0, 'accepted' => 0, 'tentative' => 0, 'cancelled' => 0, 'unanswered' => 0, 'delegated' => 0 );
	1278	$statusLabels = array( 'default', 'accepted', 'tentative', 'cancelled', 'unanswered', 'delegated' );
	1279
	1280	foreach($participants as $k => &$p){
	1281	if(!$organizer && $p['isOrganizer'] == "1"){
	1282	self::deepnessReadParticipant($uri, $p, $criteria, $original);
	1283	$reference = array_merge($reference, array($p));
	1284	}
	1285
	1286	$statusAttendees[$statusLabels[$p['status']]]++;
	1287	}
	1288
	1289	$participants['statusAttendees'] = $statusAttendees;
	1290	$participants['sizeAttendees'] = $size;
	1291	$participants['attendees'] = $reference;
	1292	}
	1293
	1294	return $participants;
	1295	}
	1296
	1297	static function dayAlarm( &$uri , &$params , &$criteria , $original ) {
[6111]	1298	if(isset($criteria['filter'][1]) && $criteria['filter'][1] == 'date')
	1299	{
[7696]	1300	$start = $criteria['filter'][2];
	1301	$end = $start + 86400000;
	1302	$params = array();
[5341]	1303
[7696]	1304	$select = "SELECT co.id as \"id\", co.cal_uid as \"uid\", co.type_id as \"type\", co.dtstart as \"startTime\", co.summary as \"summary\", co.description as \"description\",co.dtend as \"endTime\", co.location as \"location\", co.allday as \"allDay\", co.transp as transparent, co.class_id as class, co.range_start as \"rangeStart\", co.range_end as \"rangeEnd\", co.last_update as \"lastUpdate\", co.dtstamp as \"dtstamp\", co.sequence as \"sequence\", co.tzid as \"timezone\", CASE WHEN occ.occurrence > 0 THEN occ.occurrence - al.alarm_offset ELSE co.dtstart - al.alarm_offset END as \"sendTime\", al.unit as \"unit\",al.time as \"time\" FROM calendar_object as co INNER JOIN calendar_alarm al ON co.id = al.object_id JOIN calendar_participant part ON part.id = al.participant_id LEFT JOIN calendar_repeat rep ON rep.object_id = co.id LEFT JOIN calendar_repeat_occurrence occ ON occ.repeat_id = rep.id WHERE part.user_info_id = '".Config::me('uidNumber')."' AND al.action_id = '".ALARM_ALERT."' AND al.sent = '0' AND CASE WHEN occ.occurrence > 0 THEN occ.occurrence - al.alarm_offset ELSE co.dtstart - al.alarm_offset END BETWEEN $start AND $end ";
[5341]	1305
[7696]	1306	$al = Controller::service('PostgreSQL')->execSql($select);
[7660]	1307
	1308
[7696]	1309	if(is_array($al))
	1310	foreach( $al as $v )
	1311	$params[] = array('schedulable' => $v);
	1312	else
	1313	$params = false;
[7660]	1314
[7696]	1315	return false;
[6111]	1316	}
	1317	}
[6344]	1318
	1319	static private function countMyCalendarsEvent($id, $owner) {
[6996]	1320	$sig = Controller::find(array('concept' => 'calendarSignature'), array('user', 'calendar', 'isOwner'), array('filter' => array('AND', array('=', 'isOwner', '1'), array('=', 'user', $owner))));
[6344]	1321	$calendars = array();
	1322	foreach ($sig as $val)
	1323	$calendars[] = $val['calendar'];
[5341]	1324
[6344]	1325	$return = Controller::find(array('concept' => 'calendarToSchedulable'), null, array('filter' => array('AND', array('IN', 'calendar', $calendars), array('=', 'schedulable', $id))));
[5812]	1326
[6344]	1327	return (isset($return[0])) ? count($return) : 0;
	1328	}
	1329
	1330	public function deleteSchedulable(&$uri, &$params, &$criteria, $original) {
[7518]	1331
[6344]	1332	if (Config::module('useCaldav', 'expressoCalendar'))
[6066]	1333	require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
[6344]	1334
	1335	if(isset($criteria['filter']) && $criteria['filter'] && isset($criteria['filter'][1][2])){
	1336	$idSchedulable = $criteria['filter'][1][2];
[7518]	1337	$idCalendar = $criteria['filter'][2][2];
[6344]	1338	$owner = $criteria['filter'][3][2];
[6066]	1339
[6344]	1340	$qtdMyCalendars = self::countMyCalendarsEvent($idSchedulable, $owner);
[6286]	1341
[6344]	1342	$link = Controller::read(array('concept' => 'calendarToSchedulable'), false, array('filter' => array('AND', array('=','calendar',$idCalendar), array('=','schedulable',$idSchedulable))));
	1343	$link = (is_array($link) && isset($link[0])) ? $link[0] : $link;
	1344
	1345	$calendar = Controller::read(array('concept' => 'calendar'), false, array('filter' => array('=','id',$idCalendar)));
	1346	$calendar = (is_array($calendar) && isset($calendar[0])) ? $calendar[0] : $calendar;
[6331]	1347
[6344]	1348	if($isAttende = !self::ownerSchedulable($idSchedulable, $owner)){
	1349	Controller::delete(array('concept' => 'calendarToSchedulable', 'id' => $link['id']));
	1350
	1351	if($qtdMyCalendars <= 1){
[6331]	1352
[6344]	1353	$participant = Controller::read(array('concept' => 'participant'), array('id'), array('filter' =>
	1354	array('AND',
	1355	array('=', 'user', $owner),
	1356	array('=', 'schedulable', $idSchedulable)
	1357	)));
[6286]	1358
[6344]	1359	Controller::call(('update'), array('concept' => 'participant', 'id' => $participant[0]['id']), array('status' => STATUS_CANCELLED));
	1360	}
[6286]	1361
[6344]	1362	}else{
	1363	if($qtdMyCalendars > 1 )
	1364	Controller::delete(array('concept' => 'calendarToSchedulable', 'id' => $link['id']));
	1365	}
[6066]	1366
[6344]	1367	if (Config::module('useCaldav', 'expressoCalendar'))
	1368	DAViCalAdapter::deleteEvent($idSchedulable, array('location' => $calendar['location']));
[6066]	1369
[6344]	1370	if($isAttende \|\| ($qtdMyCalendars > 1))
	1371	return false;
[6066]	1372
[6344]	1373	$uri['id'] = $idSchedulable;
[7518]	1374
	1375	if(isset($criteria['type']) && $criteria['type'] == '2'){
	1376
	1377	$tasks = Controller::find(array('concept' => 'taskToActivity'), array('task'), array('filter' => array('=', 'activity', $idSchedulable)));
	1378
	1379	if(is_array( $tasks ) and count( $tasks ) > 0){
	1380	Controller::delete(array('concept' => 'taskToActivity'), null, array('filter' => array('=', 'activity', $idSchedulable)));
	1381	}
	1382
	1383	if(isset($criteria['removeTaskToActivity']) && $criteria['removeTaskToActivity']){
	1384	if(is_array( $tasks ) and count( $tasks ) > 0){
	1385
	1386	$ids = array();
	1387	foreach($tasks as $v){
	1388	$ids[] = $v['task'];
	1389	}
	1390
	1391	Controller::delete(array('concept' => 'schedulable'), false, array('filter' => array('IN','id', $ids )));
	1392	}
	1393	}
	1394	}
[6344]	1395	}
	1396
[6066]	1397	}
	1398
	1399	public function deleteCalendarToPermissionDependences(&$uri, &$params, &$criteria, $original) {
	1400	$permission = Controller::read($uri, array('user', 'calendar'));
	1401
	1402	$calendarSignature = Controller::find(array('concept' => 'calendarSignature'), array('id'), array('filter' => array('AND', array('=', 'calendar', $permission['calendar']), array('=', 'user', $permission['user']), array('=', 'isOwner', '0'))));
	1403
	1404	if ($calendarSignature)
[5812]	1405	Controller::delete(array('concept' => 'calendarSignature', 'id' => $calendarSignature[0]['id']));
	1406	}
	1407
[6066]	1408	public function deleteCalendarSignatureDependences(&$uri, &$params, &$criteria, $original) {
[7981]	1409	$signature = Controller::read($uri, array('isOwner', 'calendar','user'));
[5341]	1410
[6066]	1411	if ($signature['isOwner'] == '1') {
	1412	$calendarToSchedulables = Controller::find(array('concept' => 'calendarToSchedulable'), null, array('filter' => array('=', 'calendar', $signature['calendar'])));
[5341]	1413
[6066]	1414	$schedulables = array();
	1415	if (is_array($calendarToSchedulables))
	1416	foreach ($calendarToSchedulables as $key => $calendarToSchedulable)
	1417	$schedulables[] = $calendarToSchedulable['schedulable'];
	1418
	1419	if (!empty($schedulables))
[6096]	1420	Controller::deleteALL(array('concept' => 'schedulable'), null, array('filter' => array('IN', 'id', $schedulables)));
[6066]	1421
	1422	Controller::delete(array('concept' => 'calendar', 'id' => $signature['calendar']));
[6096]	1423
[7980]	1424	$autoCommit = Controller::service('PostgreSQL')->execResultSql('Select config_value FROM phpgw_config WHERE config_app = \'expressoCalendar\' AND config_name = \'expressoCalendar_autoImportCalendars\'');
[7981]	1425
[7980]	1426	if(isset($autoCommit[0]) && $autoCommit[0]['config_value'] == 'true')
	1427	{
[7981]	1428	$defaultCalendar = Controller::find(array('concept' => 'modulePreference'), array('value','id') , array('filter' => array( 'and' , array('=' , 'name' , 'dafaultImportCalendar') , array('=' , 'module' , 'expressoCalendar') , array('=' , 'user' , $signature['user']) )) );
	1429
	1430
[7980]	1431	if(isset($defaultCalendar[0]) && $defaultCalendar[0]['value'] == $signature['calendar'] )
	1432	{
	1433	Controller::delete(array('concept' => 'modulePreference', 'id' => $defaultCalendar[0]['id']));
	1434	}
	1435	}
	1436
	1437	$permissions = Controller::find(array('concept' => 'calendarToPermission'), array('id'), array('filter' => array('=', 'calendar', $signature['calendar'])));
	1438
[6096]	1439	if($permissions && count($permissions) > 0){
	1440	$ids = array();
	1441	foreach($permissions as $key => $value)
	1442	array_push($ids, $value['id']);
	1443
	1444	Controller::deleteALL(array('concept' => 'calendarToPermission'), null, array('filter' => array('IN', 'id', $ids)));
	1445
	1446	}
	1447
	1448
[6066]	1449	}
[5514]	1450	}
	1451
[6369]	1452	public function decodeSchedulablettachment(&$uri, &$params, &$criteria, $original) {
	1453	if (isset($original['URI']['id'])){
	1454	$schedulableAttachment = Controller::read(array('concept' => 'schedulableToAttachment'), false, array('filter' => array( '=', 'attachment' , $original['URI']['id'] )));
	1455	$uri['id'] = $schedulableAttachment[0]['id'];
[6996]	1456
	1457	$params = $schedulableAttachment[0];
	1458
	1459	$event = Controller::read(array('concept' => 'schedulable', 'id' => $params['schedulable']));
	1460	if($event['type'] == '2')
	1461	$criteria['historic']['attachment'] = $schedulableAttachment[0];
	1462
[6369]	1463	}
	1464	}
	1465
[6066]	1466	public function deleteAttachmentDependences(&$uri, &$params, &$criteria, $original) {
[6996]	1467	Controller::delete(array('concept' => 'attachment', 'id' => (isset($params['attachment']) ? $params['attachment'] : $original['URI']['id'])));
[6066]	1468	}
[6498]	1469
	1470	public function decodeDeleteCalendarSignatureAlarm(&$uri, &$params, &$criteria, $original) {
	1471	if ($original['URI']['id'] == '' && isset($original['criteria']['filter'])){
	1472	Controller::deleteAll(array('concept' => 'calendarSignatureAlarm'), null,$original['criteria']);
	1473	return false;
	1474	}
	1475	}
[6066]	1476
[6996]	1477
	1478	public function createDefaultGroup(&$uri, &$result, &$criteria, $original) {
	1479	if( $original['criteria']['filter'][1][0] == '=' &&
	1480	$original['criteria']['filter'][1][1] == 'user' &&
	1481	$original['criteria']['filter'][1][2] == $_SESSION['phpgw_session']['account_id']){
	1482
	1483	$existDefaultGroup = false;
	1484
	1485	foreach($result as $v){
	1486	if($v['type'] == 1 && $v['calendar']['type'] == 1)
	1487	$existDefaultGroup = true;
	1488	}
	1489
	1490	if(!$existDefaultGroup){
	1491
	1492	$cal = array('name' => 'Sem grupo',
	1493	'description' => 'Sem grupo',
	1494	'timezone' => (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
	1495	'dtstamp' => time() . '000',
	1496	'type' => '1'
	1497	);
	1498
	1499	$calCreated = Controller::create(array('concept' => 'calendar'), $cal);
	1500
	1501	$sig = array('user' => $_SESSION['wallet']['user']['uidNumber'],
	1502	'calendar' => $calCreated['id'],
	1503	'isOwner' => '1',
	1504	'dtstamp' => time() . '000',
	1505	'fontColor' => 'FFFFFF',
	1506	'backgroundColor' => '3366CC',
	1507	'borderColor' => '3366CC',
	1508	'type' => '1'
	1509	);
	1510
	1511	$sigCreated = Controller::create(array('concept' => 'calendarSignature'), $sig);
	1512	$sigCreated = Controller::read(array('concept' => 'calendarSignature', 'id' => $sigCreated['id']), false, array('deepness' => 2 ));
	1513
	1514	array_push($result, $sigCreated);
	1515	}
	1516
	1517	}
	1518
	1519	}
	1520
[6066]	1521	public function createDefaultSignature(&$uri, &$result, &$criteria, $original) {
	1522
[6996]	1523	if(count($result) == 0 && isset($criteria['filter'][3]) && isset($criteria['filter'][3]['isRecursion'])){
	1524	throw new Exception('It was not possible to find to calendar!');
	1525	return false;
	1526	}
	1527
[6345]	1528	//Caso uma busca não retorne nenhum resultado e foi buscado pelas assinaturas do usuario logado apenas
[5863]	1529	$isValidSignature = false;
[5947]	1530
[6345]	1531	//Veirifica pois o usuário pode ter varias assinaturas mas não ser dona de nenhuma
[6066]	1532	if (count($result) > 0) {
[6295]	1533	foreach ($result as $value) {
[6996]	1534	if (isset($value['isOwner']) && $value['isOwner'] != 0 && isset($value['type']) && $value['type'] == 0)
	1535	$isValidSignature = true;
[5863]	1536	}
	1537	}
	1538
[6066]	1539	if (!$isValidSignature &&
	1540	( $original['criteria']['filter'][1][0] == '=' &&
	1541	$original['criteria']['filter'][1][1] == 'user' &&
	1542	$original['criteria']['filter'][1][2] == $_SESSION['phpgw_session']['account_id']
	1543	)) {
[5341]	1544
[6066]	1545	if (Config::module('useCaldav', 'expressoCalendar')) {
[6996]	1546	require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
	1547	$calendario = DAViCalAdapter::findCalendars();
[6066]	1548	}
[5341]	1549
[6066]	1550	if (Config::module('useCaldav', 'expressoCalendar') && is_array($calendario) && count($calendario) > 0) {
[6996]	1551	foreach ($calendario as $i => $v) {
[6066]	1552
[6996]	1553	$urlA = explode('/', $v->url);
	1554	$name = isset($v->displayname) ? $v->displayname : $urlA[(count($urlA) - 2)];
	1555	$cal = array('name' => $name,
	1556	'description' => isset($v->description) ? $v->description : $name,
	1557	'timezone' => isset($v->timezone) ? $v->timezone : (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
	1558	'dtstamp' => time() . '000',
	1559	'location' => $urlA[(count($urlA) - 3)] . '/' . $urlA[(count($urlA) - 2)]
	1560	);
[6066]	1561
[6996]	1562	$calCreated = Controller::create(array('concept' => 'calendar'), $cal);
[6066]	1563
[6996]	1564	if(!$calCreated){
	1565	throw new Exception('Error to create calendar');
	1566	return false;
	1567	}
[6066]	1568
[6996]	1569	$sig = array('user' => $_SESSION['wallet']['user']['uidNumber'],
	1570	'calendar' => $calCreated['id'],
	1571	'isOwner' => '1',
	1572	'dtstamp' => time() . '000',
	1573	'fontColor' => 'FFFFFF',
	1574	'backgroundColor' => '3366CC',
	1575	'borderColor' => '3366CC',
	1576	);
[6066]	1577
[6996]	1578	$sigCreated = Controller::create(array('concept' => 'calendarSignature'), $sig);
[6066]	1579
[6996]	1580	if(!$sigCreated){
	1581	throw new Exception('Error to create signature');
	1582	return false;
	1583	}
[6066]	1584
[7980]	1585	if($i == 0)
	1586	{
	1587	$pref = array();
	1588	$pref['user'] = $_SESSION['wallet']['user']['uidNumber'];
	1589	$pref['value'] = $calCreated['id'];
	1590	$pref['name'] = 'dafaultImportCalendar' ;
	1591	$pref['module'] = 'expressoCalendar';
	1592	Controller::create(array('concept' => 'modulePreference'), $pref);
	1593	}
	1594
[6996]	1595	}
[6066]	1596	} else {
[6996]	1597	//Criaremos uma agenda padrão
	1598	$cal = array('name' => 'Calendario',
	1599	'description' => 'Calendario Padrão',
	1600	'timezone' => (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo',
	1601	'dtstamp' => time() . '000'
	1602	);
[6066]	1603
[6996]	1604	$calCreated = Controller::create(array('concept' => 'calendar'), $cal);
[6066]	1605
[6996]	1606	$sig = array('user' => $_SESSION['wallet']['user']['uidNumber'],
	1607	'calendar' => $calCreated['id'],
	1608	'isOwner' => '1',
	1609	'dtstamp' => time() . '000',
	1610	'fontColor' => 'FFFFFF',
	1611	'backgroundColor' => '3366CC',
	1612	'borderColor' => '3366CC',
	1613	);
[6066]	1614
[6996]	1615	$sigCreated = Controller::create(array('concept' => 'calendarSignature'), $sig);
[7980]	1616
	1617
	1618	$pref = array();
	1619	$pref['user'] = $_SESSION['wallet']['user']['uidNumber'];
	1620	$pref['value'] = $calCreated['id'];
	1621	$pref['name'] = 'dafaultImportCalendar' ;
	1622	$pref['module'] = 'expressoCalendar';
	1623	Controller::create(array('concept' => 'modulePreference'), $pref);
	1624
	1625
[6996]	1626	}
	1627
	1628	$original['criteria']['filter'][] = array('isRecursion' => true);
	1629	$result = Controller::find($original['URI'], $original['properties'] ? $original['properties'] : null, $original['criteria']);
[6066]	1630	return false;
[6996]	1631	}
[5341]	1632	}
[6066]	1633
[5850]	1634	//TODO - Criar conceito separado para participantes externos e remover o criterio notExternal
[6066]	1635	public function findExternalPaticipants(&$uri, &$result, &$criteria, $original) {
[8058]	1636	if (Config::me('uidNumber') && !isset($criteria['notExternal'])) {
	1637	$newuri['concept'] = 'user';
	1638	$newuri['service'] = 'PostgreSQL';
[5366]	1639
[8058]	1640	$newCriteria = $original['criteria'];
	1641	$valid = true;
[5366]	1642
[8058]	1643	$newCriteria['filter'] = array('AND', $newCriteria['filter'], array('=', 'owner', Config::me('uidNumber')));
	1644	$externalUsers = Controller::find($newuri, $original['properties'] ? $original['properties'] : null, $newCriteria );
[6066]	1645
[8058]	1646	if (!is_array($result))
	1647	$result = array();
[6066]	1648
[8058]	1649	if (is_array($externalUsers)) {
	1650	foreach ($externalUsers as $i => $v)
	1651	$externalUsers[$i]['isExternal'] = '1';
	1652	}
	1653	else
	1654	$externalUsers = array();
[6066]	1655
[8058]	1656	$result = array_merge($result, $externalUsers);
	1657
	1658
	1659	if(isset($original['criteria']['externalCatalogs']) && $original['criteria']['externalCatalogs'] == true)
	1660	{
	1661	$externalCatalogs = self::findExternalCatalogContacts($original['criteria']['filter'][2]);
	1662
	1663	foreach($externalCatalogs as $i => $v)
	1664	{
	1665	$exist = false;
	1666	foreach($result as $vv)
	1667	{
	1668	if($v['mail'] == $vv['mail'] )
	1669	$exist = true;
	1670	}
	1671	if(!$exist)
	1672	$result[] = $v;
	1673	}
	1674	}
	1675
	1676
	1677	if(isset($original['criteria']['personalContacts']) && $original['criteria']['personalContacts'] == true)
	1678	{
	1679	$personalContacts = self::findPersonalContacts($original['criteria']['filter'][2]);
	1680
	1681	foreach($personalContacts as $i => $v)
	1682	{
	1683	$exist = false;
	1684	foreach($result as $vv)
	1685	{
	1686	if($v['mail'] == $vv['mail'] )
	1687	$exist = true;
	1688	}
	1689	if(!$exist)
	1690	$result[] = $v;
	1691	}
	1692	}
	1693
	1694	return $result ;
	1695	}
[5341]	1696	}
	1697
[6066]	1698	public function davcalCreateCollection(&$uri, &$params, &$criteria, $original) {
[6996]	1699	if (Config::module('useCaldav', 'expressoCalendar')) {
	1700	require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
	1701	DAViCalAdapter::mkcalendar($params['location'], $params['name'], isset($params['description']) ? $params['description'] : '' );
	1702	}
[5341]	1703	}
[6066]	1704
	1705	public function davcalDeleteCollection(&$uri, &$params, &$criteria, $original) {
[6996]	1706	if (Config::module('useCaldav', 'expressoCalendar') && Config::module('onRemoveCascadeCalDav')) {
	1707	require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
	1708	$calendar = Controller::read($uri);
	1709	DAViCalAdapter::rmCalendar($calendar['location']);
	1710	}
[5341]	1711	}
[6066]	1712
	1713	public function davcalUpdateCollection(&$uri, &$params, &$criteria, $original) {
[6996]	1714	if (Config::module('useCaldav', 'expressoCalendar')) {
	1715	require_once ROOTPATH . '/modules/calendar/interceptors/DAViCalAdapter.php';
	1716	if (isset($params['location'])) {
	1717	$calendar = Controller::read($uri);
	1718	if ($calendar['location'] !== $params['location'])
	1719	DAViCalAdapter::mvcalendar($calendar['location'], $params['location']);
	1720	}
	1721	}
[5341]	1722	}
	1723
[6183]	1724	private static function _makeUid() {
[5341]	1725
[6066]	1726	$date = date('Ymd\THisT');
	1727	$unique = substr(microtime(), 2, 4);
	1728	$base = 'aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPrRsStTuUvVxXuUvVwWzZ1234567890';
	1729	$start = 0;
	1730	$end = strlen($base) - 1;
	1731	$length = 6;
	1732	$str = null;
[7655]	1733	for ($p = 0; $p < $length; ++$p)
[6066]	1734	$unique .= $base{mt_rand($start, $end)};
[5341]	1735
[6066]	1736	return $date . $unique . '@expresso-calendar';
[5341]	1737	}
[6066]	1738
	1739	private function getStatus($id) {
	1740	$a = array(
	1741	STATUS_CONFIRMED => 'CONFIRMED',
	1742	STATUS_CANCELLED => 'CANCELLED',
	1743	STATUS_TENATIVE => 'TENATIVE',
	1744	STATUS_UNANSWERED => 'NEEDS-ACTION',
	1745	STATUS_DELEGATED => 'DELEGATED'
	1746	);
	1747	return $a[$id];
[5341]	1748	}
	1749
[6066]	1750	private static function decodeAlarmType($id) {
	1751	$a = array(ALARM_ALERT => 'alert',
	1752	ALARM_MAIL => 'mail',
	1753	ALARM_SMS => 'sms');
	1754
	1755	return $a[$id];
[5341]	1756	}
	1757
[6066]	1758	private static function codeAlarmType($type) {
	1759	$a = array('alert' => ALARM_ALERT,
	1760	'mail' => ALARM_MAIL,
	1761	'sms' => ALARM_SMS);
	1762
	1763	return $a[$type];
[5341]	1764	}
[6066]	1765
	1766	private static function codeAlarmUnit($u) {
	1767	if ($u === 'd')
	1768	return 'days';
	1769	if ($u === 'm')
	1770	return 'minutes';
	1771	if ($u === 'H')
	1772	return 'hours';
[5341]	1773	}
	1774
[6331]	1775	private static function ownerSchedulable($id, $me) {
[6066]	1776
	1777	$isOwner = Controller::find(array('concept' => 'participant'), array('id'), array('filter' =>
	1778	array('AND',
	1779	array('=', 'isOrganizer', '1'),
[6331]	1780	array('=', 'user', $me),
[6066]	1781	array('=', 'schedulable', $id)
	1782	)));
	1783
	1784	return ( isset($isOwner[0]['id']) ) ? true : false;
[5341]	1785	}
[6331]	1786
	1787
	1788	private static function referenceCalendarToObject($schedulable, $calendar) {
	1789	return Controller::service('PostgreSQL')->execResultSql('SELECT calendar_to_calendar_object.id as calendar_to_calendar_Object FROM calendar_to_calendar_object'
	1790	. ' WHERE calendar_to_calendar_object.calendar_id = '. $calendar
	1791	. ' AND calendar_to_calendar_object.calendar_object_id = ' . addslashes($schedulable));
	1792	}
	1793
[6066]	1794	private static function schedulable2calendarToObject($Schedulable) {
	1795	return Controller::service('PostgreSQL')->execResultSql('SELECT calendar_to_calendar_object.id as calendar_to_calendar_Object , calendar.name as calendar_name ,calendar.location as calendar_location, calendar.id as calendar_id FROM calendar_to_calendar_object , calendar , calendar_signature'
	1796	. ' WHERE calendar_signature.user_uidnumber = ' . $_SESSION['wallet']['user']['uidNumber']
	1797	// .' AND calendar_signature.is_owner = 1'
	1798	. ' AND calendar_signature.calendar_id = calendar.id'
	1799	. ' AND calendar_to_calendar_object.calendar_id = calendar.id'
	1800	. ' AND calendar_to_calendar_object.calendar_object_id = ' . addslashes($Schedulable));
[5998]	1801	}
[6066]	1802
	1803	protected static function isAllowDeleteInCalendar($calendar) {
	1804	$f = Controller::find(array('concept' => 'calendarToPermission'), false, array('filter' => array('AND', array('=', 'user', Config::me('uidNumber')), array('=', 'calendar', $calendar))));
	1805	return (strpos($f[0]['acl'], CALENDAR_ACL_REMOVE) === false) ? false : true;
	1806	}
	1807
[7590]	1808	private static function isValidTimeStamp($timestamp)
	1809	{
	1810	return ((string) (int) $timestamp === $timestamp)
	1811	&& ($timestamp <= PHP_INT_MAX)
	1812	&& ($timestamp >= ~PHP_INT_MAX);
	1813	}
[8058]	1814
	1815	static function findExternalCatalogContacts( $search )
	1816	{
	1817	$result = array();
	1818	$external_srcs = array();
	1819	$external_mappings = array();
	1820
	1821	include_once dirname(__DIR__) .'/../../../contactcenter/setup/external_catalogs.inc.php';
	1822
	1823	$search = str_replace(' ', '*', $search) ;
	1824	$search = '' . $search . '';
	1825
	1826	foreach($external_srcs as $i => $v)
	1827	{
	1828	$con = ldap_connect($v['host']);
	1829
	1830	ldap_set_option( $con , LDAP_OPT_PROTOCOL_VERSION , 3 );
	1831
	1832	if( isset( $v['acc'] ) && isset( $v['pw'] ) )
	1833	ldap_bind( $con, $v['acc'], $v['pw'] );
	1834
	1835	$fields = array();
	1836	$fields[] = $external_mappings[$i]['contact.names_ordered'][0];
	1837	$fields[] = $external_mappings[$i]['contact.connection.typeof_connection.contact_connection_type_name']['email'][0];
	1838
	1839	$ldapFilter = '(&(objectClass='.$v['obj'].')(\|('.$fields[0].'='.$search.')('.$fields[1].'='.$search.')))';
	1840	$sr = ldap_search( $con, utf8_encode($v['dn']) , $ldapFilter , $fields );
	1841	if($sr)
	1842	{
	1843	$search = ldap_get_entries($con, $sr);
	1844
	1845	for ($j = 0; $j < $search["count"]; ++$j) {
	1846	$tmp = array();
	1847	$tmp['name'] = $search[$j][$fields[0]][0];
	1848	$tmp['mail'] = $search[$j][$fields[1]][0];
	1849	$tmp['isExternal'] = '1';
	1850
	1851	$result[] = $tmp;
	1852	}
	1853	}
	1854	}
	1855	return $result;
	1856	}
	1857
	1858	static function findPersonalContacts($search_for)
	1859	{
	1860
	1861	$query = 'select'
	1862
	1863	. ' C.id_connection,'
	1864	. ' A.id_contact,'
	1865	. ' A.names_ordered,'
	1866	. ' A.alias,'
	1867	. ' A.birthdate,'
	1868	. ' A.sex,'
	1869	. ' A.pgp_key,'
	1870	. ' A.notes,'
	1871	. ' A.web_page,'
	1872	. ' A.corporate_name,'
	1873	. ' A.job_title,'
	1874	. ' A.department,'
	1875	. ' C.connection_name,'
	1876	. ' C.connection_value,'
	1877	. ' B.id_typeof_contact_connection,'
	1878	. ' phpgw_cc_contact_addrs.id_typeof_contact_address,'
	1879	. ' phpgw_cc_addresses.address1,'
	1880	. ' phpgw_cc_addresses.address2,'
	1881	. ' phpgw_cc_addresses.complement,'
	1882	. ' phpgw_cc_addresses.postal_code,'
	1883	. ' phpgw_cc_city.city_name,'
	1884	. ' phpgw_cc_state.state_name,'
	1885	. ' phpgw_cc_addresses.id_country'
	1886	;
	1887
	1888	$query .= ' from'
	1889	. ' phpgw_cc_contact A'
	1890	. ' inner join phpgw_cc_contact_conns B on ( A.id_contact = B.id_contact )'
	1891	. ' inner join phpgw_cc_connections C on ( B.id_connection = C.id_connection )'
	1892	. ' left join phpgw_cc_contact_addrs on ( A.id_contact = phpgw_cc_contact_addrs.id_contact )'
	1893	. ' left join phpgw_cc_addresses on ( phpgw_cc_contact_addrs.id_address = phpgw_cc_addresses.id_address )'
	1894	. ' left join phpgw_cc_city on ( phpgw_cc_addresses.id_city = phpgw_cc_city.id_city )'
	1895	. ' left join phpgw_cc_state on ( phpgw_cc_addresses.id_state = phpgw_cc_state.id_state)'
	1896	;
	1897
	1898	$query .= ' where '
	1899	. 'A.id_owner=' . Config::me('uidNumber')
	1900	. ' and lower(translate(names_ordered, \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))'
	1901	. ' LIKE lower(translate(\'%' . $search_for . '%\', \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))';
	1902
	1903	//Se não existir parametro na busca, limita os usuarios no resultado da pesquisa.
	1904	if(!$search_for){
	1905	$query .= 'LIMIT 11';
	1906	}
	1907
	1908	$r = Controller::service('PostgreSQL')->execResultSql($query);
	1909
	1910
	1911	$all_contacts = array();
	1912	foreach( $r as $i => $object )
	1913	{
	1914	if ( ! array_key_exists( $object[ 'id_contact' ], $all_contacts ) )
	1915	$all_contacts[ $object[ 'id_contact' ] ] = array(
	1916	'connection_value' => '',
	1917	'telephonenumber' => '',
	1918	'mobile' => '',
	1919	'cn' => '',
	1920	'id_contact' => '',
	1921	'id_connection' => '',
	1922	'alias' => '',
	1923	'birthdate' => '',
	1924	'sex' => '',
	1925	'pgp_key' => '',
	1926	'notes' => '',
	1927	'web_page' => '',
	1928	'corporate_name' => '',
	1929	'job_title' => '',
	1930	'department' => '',
	1931	'mail' => '',
	1932	'aternative-mail' => '',
	1933	'business-phone' => '',
	1934	'business-address' => '',
	1935	'business-complement' => '',
	1936	'business-postal_code' => '',
	1937	'business-city_name' => '',
	1938	'business-state_name' => '',
	1939	'business-id_country' => '',
	1940	'business-fax' => '',
	1941	'business-pager' => '',
	1942	'business-mobile' => '',
	1943	'business-address-2' => '',
	1944	'home-phone' => '',
	1945	'home-address' => '',
	1946	'home-complement' => '',
	1947	'home-postal_code' => '',
	1948	'home-city_name' => '',
	1949	'home-state_name' => '',
	1950	'home-fax' => '',
	1951	'home-pager' => '',
	1952	'home-address-2' => ''
	1953
	1954
	1955	);
	1956
	1957	switch( $object[ 'id_typeof_contact_connection' ] )
	1958	{
	1959	case 1 :
	1960	$all_contacts[ $object[ 'id_contact' ] ][ 'connection_value' ] = $object[ 'connection_value' ];
	1961	switch ( strtolower( $object[ 'connection_name' ] ) )
	1962	{
	1963	case 'alternativo' :
	1964	$all_contacts[ $object[ 'id_contact' ] ][ 'alternative-mail' ] = $object[ 'connection_value' ];
	1965	break;
	1966	case 'principal' :
	1967	$all_contacts[ $object[ 'id_contact' ] ][ 'mail' ] = $object[ 'connection_value' ];
	1968	break;
	1969	}
	1970	break;
	1971	case 2 :
	1972	$all_contacts[ $object[ 'id_contact' ] ][ 'telephonenumber' ] = $object[ 'connection_value' ];
	1973	switch ( strtolower( $object[ 'connection_name' ] ) )
	1974	{
	1975	case 'casa' :
	1976	$all_contacts[ $object[ 'id_contact' ] ][ 'home-phone' ] = $object[ 'connection_value' ];
	1977	break;
	1978	case 'celular' :
	1979	$all_contacts[ $object[ 'id_contact' ] ][ 'mobile' ] = $object[ 'connection_value' ];
	1980	break;
	1981	case 'trabalho' :
	1982	$all_contacts[ $object[ 'id_contact' ] ][ 'business-phone' ] = $object[ 'connection_value' ];
	1983	break;
	1984	case 'fax' :
	1985	$all_contacts[ $object[ 'id_contact' ] ][ 'home-fax' ] = $object[ 'connection_value' ];
	1986	break;
	1987	case 'pager' :
	1988	$all_contacts[ $object[ 'id_contact' ] ][ 'home-pager' ] = $object[ 'connection_value' ];
	1989	break;
	1990	case 'celular corporativo' :
	1991	$all_contacts[ $object[ 'id_contact' ] ][ 'business-mobile' ] = $object[ 'connection_value' ];
	1992	break;
	1993	case 'pager corporativo' :
	1994	$all_contacts[ $object[ 'id_contact' ] ][ 'business-pager' ] = $object[ 'connection_value' ];
	1995	break;
	1996	case 'fax corporativo' :
	1997	$all_contacts[ $object[ 'id_contact' ] ][ 'business-fax' ] = $object[ 'connection_value' ];
	1998	break;
	1999	}
	2000	break;
	2001	}
	2002
	2003	$all_contacts[ $object[ 'id_contact' ] ][ 'cn' ] = utf8_encode($object[ 'names_ordered' ]);
	2004	$all_contacts[ $object[ 'id_contact' ] ][ 'id_contact' ] = $object[ 'id_contact' ];
	2005	$all_contacts[ $object[ 'id_contact' ] ][ 'id_connection' ] = $object[ 'id_connection' ];
	2006	$all_contacts[ $object[ 'id_contact' ] ][ 'alias' ] = $object[ 'alias' ];
	2007	$all_contacts[ $object[ 'id_contact' ] ][ 'birthdate' ] = $object[ 'birthdate' ];
	2008	$all_contacts[ $object[ 'id_contact' ] ][ 'sex' ] = $object[ 'sex' ];
	2009	$all_contacts[ $object[ 'id_contact' ] ][ 'pgp_key' ] = $object[ 'pgp_key' ];
	2010	$all_contacts[ $object[ 'id_contact' ] ][ 'notes' ] = $object[ 'notes' ];
	2011	$all_contacts[ $object[ 'id_contact' ] ][ 'web_page' ] = $object[ 'web_page' ];
	2012	$all_contacts[ $object[ 'id_contact' ] ][ 'corporate_name' ]= $object[ 'corporate_name' ];
	2013	$all_contacts[ $object[ 'id_contact' ] ][ 'job_title' ] = $object[ 'job_title' ];
	2014	$all_contacts[ $object[ 'id_contact' ] ][ 'department' ] = $object[ 'department' ];
	2015
	2016	switch( $object[ 'id_typeof_contact_address' ] )
	2017	{
	2018	case 1 :
	2019	$all_contacts[ $object[ 'id_contact' ] ][ 'business-address' ] = $object[ 'address1' ];
	2020	$all_contacts[ $object[ 'id_contact' ] ][ 'business-address-2' ] = $object[ 'address2' ];
	2021	$all_contacts[ $object[ 'id_contact' ] ][ 'business-complement' ] = $object[ 'complement' ];
	2022	$all_contacts[ $object[ 'id_contact' ] ][ 'business-postal_code' ] = $object[ 'postal_code' ];
	2023	$all_contacts[ $object[ 'id_contact' ] ][ 'business-city_name' ] = $object[ 'city_name' ];
	2024	$all_contacts[ $object[ 'id_contact' ] ][ 'business-state_name' ] = $object[ 'state_name' ];
	2025	$all_contacts[ $object[ 'id_contact' ] ][ 'business-id_country' ] = $object[ 'id_country' ];
	2026	break;
	2027	case 2 :
	2028	$all_contacts[ $object[ 'id_contact' ] ][ 'home-address' ] = $object[ 'address1' ];
	2029	$all_contacts[ $object[ 'id_contact' ] ][ 'home-address-2' ] = $object[ 'address2' ];
	2030	$all_contacts[ $object[ 'id_contact' ] ][ 'home-complement' ] = $object[ 'complement' ];
	2031	$all_contacts[ $object[ 'id_contact' ] ][ 'home-postal_code' ] = $object[ 'postal_code' ];
	2032	$all_contacts[ $object[ 'id_contact' ] ][ 'home-city_name' ] = $object[ 'city_name' ];
	2033	$all_contacts[ $object[ 'id_contact' ] ][ 'home-state_name' ] = $object[ 'state_name' ];
	2034	$all_contacts[ $object[ 'id_contact' ] ][ 'home-id_country' ] = $object[ 'id_country' ];
	2035	break;
	2036	}
	2037	}
	2038	$all = array_values($all_contacts);
	2039
	2040	$result = array();
	2041	foreach($all as $i => $v)
	2042	{
	2043	if(!$v['mail']) continue;
	2044
	2045	$tmp = array();
	2046	$tmp['mail'] = $v['mail'];
	2047	$tmp['name'] = $v['cn'];
	2048	$tmp['isExternal'] = '1';
	2049	$result[] = $tmp;
	2050	}
	2051
	2052	return $result;
	2053
	2054	}
[5341]	2055	}
	2056
	2057	?>

Note: See TracBrowser for help on using the repository browser.

Context Navigation

source: trunk/prototype/modules/calendar/interceptors/DBMapping.php @ 8058

Download in other formats: