[Fmsystem-commits] [16592] eventplanner: delete related data

[sigurdne]

Revision: 16592
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=16592
Author:   sigurdne
Date:     2017-04-18 10:05:43 -0400 (Tue, 18 Apr 2017)
Log Message:
-----------
eventplanner: delete related data

Modified Paths:
--------------
    trunk/eventplanner/inc/class.socalendar.inc.php

Modified: trunk/eventplanner/inc/class.socalendar.inc.php
===================================================================
--- trunk/eventplanner/inc/class.socalendar.inc.php     2017-04-18 12:57:53 UTC 
(rev 16591)
+++ trunk/eventplanner/inc/class.socalendar.inc.php     2017-04-18 14:05:43 UTC 
(rev 16592)
@@ -148,8 +148,13 @@
                                        break;
 
                                case 'delete':
-                                       $sql = "DELETE FROM 
eventplanner_calendar WHERE customer_id IS NULL";
-                                       $where = 'AND';
+                                       $this->db->transaction_begin();
+                                       $sql = "DELETE FROM 
eventplanner_calendar_comment WHERE calendar_id IN(". implode(',', $ids) . ')';
+                                       
$this->db->query($sql,__LINE__,__FILE__);
+
+                                       $sql = "DELETE FROM 
eventplanner_calendar WHERE id IN(". implode(',', $ids) . ')';
+                                       
$this->db->query($sql,__LINE__,__FILE__);
+                                       return  $this->db->transaction_commit();
                                        break;
 
                                case 'disconnect':