ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / crmleta / modules / Calendar

<?php
/*+***********************************************************************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.0
 * ("License"); You may not use this file except in compliance with the License
 * The Original Code is:  vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
 *************************************************************************************/
require_once 'vtlib/Vtiger/Utils.php';

class iCalLastImport {

var $tableName = 'vtiger_ical_import';
	var $fields = array('id', 'userid', 'entitytype', 'crmid');
	var $fieldData = array();
	
	function  __construct() {
	}

function clearRecords($userId) {
		$adb = PearDatabase::getInstance();
		if(Vtiger_Utils::CheckTable($this->tableName)) {
			$adb->pquery('DELETE FROM '.$this->tableName .' WHERE userid = ?', array($userId));
		}
	}

function setFields($data) {
		if(!empty($data)) {
			foreach($data as $name => $value) {
				$this->fieldData[$name] = $value;
			}
		}
	}

function save() {
		$adb = PearDatabase::getInstance();

if(count($this->fieldData) == 0) return;
		
		if(!Vtiger_Utils::CheckTable($this->tableName)) {
			Vtiger_Utils::CreateTable(
				$this->tableName,
				"(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
					userid INT NOT NULL,
					entitytype VARCHAR(200) NOT NULL,
					crmid INT NOT NULL)",
				true);
		}

$fieldNames = array_keys($this->fieldData);
		$fieldValues = array_values($this->fieldData);
		$adb->pquery('INSERT INTO '.$this->tableName.'('. implode(',',$fieldNames) .') VALUES ('. generateQuestionMarks($fieldValues) .')',
				array($fieldValues));
	}

function undo($moduleName, $userId) {
		$adb = PearDatabase::getInstance();
		if(Vtiger_Utils::CheckTable($this->tableName)) {
			$result = $adb->pquery('UPDATE vtiger_crmentity SET deleted=1 WHERE crmid IN
								(SELECT crmid FROM '.$this->tableName .' WHERE userid = ? AND entitytype = ?)',
						array($userId, $moduleName));
			return $adb->getAffectedRowCount($result);
		}
	}
}
?>

[+] ..
[-] RenderRelatedListUI.php [edit]
[-] SendReminder.bat [edit]
[-] iCalImport.php [edit]
[-] CalendarCommon.php [edit]
[-] Appointment.php [edit]
[+] iCal
[+] views
[-] Activity.php [edit]
[-] RepeatEvents.php [edit]
[+] actions
[-] iCalExport.php [edit]
[+] models
[-] Date.php [edit]
[-] iCalLastImport.php [edit]
[+] uitypes
[-] Calendar.php [edit]