public function process(Vtiger_Request $request)
{
$adb = \PearDatabase::getInstance();
if (!\SwVtTools\VtUtils::existTable('vtiger_gcal_sync')) {
$adb->query("CREATE TABLE IF NOT EXISTS `vtiger_gcal_sync` (\n `user_id` int(11) NOT NULL,\n `calendar_id` varchar(500) NOT NULL\n ) ENGINE=InnoDB;");
}
}
function checkDB()
{
$adb = \PearDatabase::getInstance();
if (!\SwVtTools\VtUtils::existTable("vtiger_tools_sidebar")) {
echo "Create table vtiger_tools_sidebar ... ok<br>";
$adb->query("CREATE TABLE IF NOT EXISTS `vtiger_tools_sidebar` (\n `id` mediumint(8) unsigned NOT NULL,\n `active` TINYINT(1) NOT NULL,\n `tabid` mediumint(8) NOT NULL,\n `content` TEXT NOT NULL,\n `title` VARCHAR(128) NOT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB;");
}
if (!\SwVtTools\VtUtils::existTable("vtiger_tools_sidebar_seq")) {
echo "Create table vtiger_tools_sidebar_seq ... ok<br>";
$adb->query("CREATE TABLE IF NOT EXISTS `vtiger_tools_sidebar_seq` (\n `id` mediumint(8) unsigned NOT NULL\n ) ENGINE=InnoDB;");
$adb->query("INSERT INTO vtiger_tools_sidebar_seq SET id = 1");
}
}
* Created by JetBrains PhpStorm.
* User: Stefan Warnat <*****@*****.**>
* Date: 31.10.14 13:06
* You must not use this file without permission.
*/
require_once 'modules/SwVtTools/lib/SwVtTools/VtUtils.php';
$adb = \PearDatabase::getInstance();
if (empty($current_language)) {
$current_language = 'en_us';
}
$app_strings = return_application_language($current_language);
$sql = 'SELECT * FROM vtiger_google_sync WHERE googlemodule = "Calendar"';
$result = $adb->query($sql);
$oldCurrentUser2 = vglobal('current_user');
$enableSharedCalendar = false;
if (\SwVtTools\VtUtils::existTable('vtiger_gcal_sync')) {
$enableSharedCalendar = true;
}
$listView = new Google_List_View();
echo 'GoogleCal Sync' . PHP_EOL;
while ($user = $adb->fetchByAssoc($result)) {
$user2 = CRMEntity::getInstance('Users');
$user2->retrieveCurrentUserInfoFromFile($user['user']);
vglobal('current_user', $user2);
$controller = new Google_Calendar_Controller($user2);
if ($enableSharedCalendar === true && method_exists($controller, 'getCalendarId')) {
$calId = $controller->getCalendarId();
$controller->setCalendarId($calId);
}
if ($enableSharedCalendar === true && !method_exists($controller, 'getCalendarId')) {
$enableSharedCalendar = false;
