68 lines
2.1 KiB
PHP
68 lines
2.1 KiB
PHP
|
<?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);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
?>
|