Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:modifications:googlecalendersync [2014/10/31 20:28]
swarnat
en:modifications:googlecalendersync [2014/11/01 11:15] (current)
swarnat
Line 1: Line 1:
-====== Google Calendar Sync ======+====== ​Custom ​Google Calendar Sync ======
  
-mod61.01+Tested with VtigerCRM 6.0 and 6.1!
  
-ALTER TABLE `vtiger_google_oauth` ADD `additional` TEXT NOT NULL AFTER `userid`;+To setup the Vtiger Google Calendar sync with another calendar than the default one, you could apply this modifications.
  
 +At first install latest version of my [[en:​extensions:​vtigercrm_tools|Vtiger Tools.]] **This is absolutely necessary,​** because I use this module to implement to management logic.
  
-/* modified by swarnat - mod61.01 */+You need to press the "​initialize"​ button on the management view of Vtiger Tools in the section "​Google Calendar"​
  
-At first install latest version of my [[en:extensions:​vtigercrm_tools|Vtiger Tools.]] This is absolutely necessary, because I use this module to implement to logic.+===== 1. File/​modules/​Google/​connectors/​Calendar.php =====
  
-===== File: /​modules/​Google/​connectors/​Calendar.php ===== +=== 1.Search ===
- +
-=== Search ===+
 <code php> <code php>
 $query = $calendars->​newEventQuery($query);​ $query = $calendars->​newEventQuery($query);​
Line 26: Line 25:
 </​code>​ </​code>​
  
-=== Search ===+=== 1.2 Search ===
 <code php> <code php>
 $createdEntry = $gContact->​insertEvent($entity);​ $createdEntry = $gContact->​insertEvent($entity);​
Line 46: Line 45:
 </​code>​ </​code>​
  
-=== Search (The end of this file) ===+=== 1.3 Search (The end of this file) ===
  
 <code php> <code php>
Line 74: Line 73:
 </​code>​ </​code>​
  
-===== File: /​modules/​Google/​controllers/​Calendar.php =====+===== 2. File: /​modules/​Google/​controllers/​Calendar.php =====
  
-=== Search ===+=== 2.1 Search ===
 <code php> <code php>
     public function getSourceType() {     public function getSourceType() {
Line 103: Line 102:
     }     }
     /* modified by swarnat - mod61.01 */     /* modified by swarnat - mod61.01 */
 +</​code>​
 +
 +===== 3. File: /​modules/​Google/​models/​Module.php =====
 +This file only exist in vtigerCRM 6.1, becaus 6.0 don't support remove of Sync. 
 +
 +=== 3.1 Search ===
 +<code php>
 +$db->​pquery($query,​ array($module,​ $id));
 +</​code>​
 +
 +=== Insert after ===
 +<code php>
 +
 +        /* modified by swarnat - mod61.01 */
 +        $query = "​DELETE FROM vtiger_gcal_sync WHERE user_id = ?";
 +        $db->​pquery($query,​ array($id));​
 +        /* modified by swarnat - mod61.01 */
 +</​code>​
 +
 +===== 4. File: /​modules/​Google/​views/​List.php =====
 +
 +=== 4.1 Search ===
 +<code php>
 +$controller = new Google_Calendar_Controller($user);​
 +</​code>​
 +
 +=== Insert After ===
 +<code php>
 +        /* modified by swarnat - mod61.01 */
 +        $calId = $controller->​getCalendarId();​
 +        if(empty($calId)) {
 +            $list = $controller->​getCalendarList();​
 +            $this->​viewer->​assign('​calendars',​ $list);
 +            $this->​viewer->​view('​GCalChooser.tpl',​ '​SwVtTools'​);​
 +
 +            return;
 +        }
 +        $controller->​setCalendarId($calId);​
 +        /* modified by swarnat - mod61.01 */
 </​code>​ </​code>​