[Xrms-cvs] xrms/admin/case-types one.php, 1.12, 1.13 delete.php, 1.6, 1.7

[360team.ca <gop...@us...>]

Update of /cvsroot/xrms/xrms/admin/case-types
In directory sfp-cvsdas-3.v30.ch3.sourceforge.com:/tmp/cvs-serv14458/case-types

Modified Files:
	one.php delete.php 
Log Message:
Deleting a workflow type now results in not only deleting all its statuses but also deleting all the activity templates attached to those statuses.

Index: one.php
===================================================================
RCS file: /cvsroot/xrms/xrms/admin/case-types/one.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** one.php	5 Dec 2006 11:09:59 -0000	1.12
--- one.php	6 Dec 2010 21:56:13 -0000	1.13
***************
*** 65,69 ****
              <tr>
                  <td class=widget_label_right><?php echo _("Display HTML"); ?></td>
!                 <td class=widget_content_form_element><input type=text size=30 name=case_type_display_html value="<?php  echo $case_type_display_html; ?>"></td>
              </tr>
              <tr>
--- 65,69 ----
              <tr>
                  <td class=widget_label_right><?php echo _("Display HTML"); ?></td>
!                 <td class=widget_content_form_element><input type=text size=30 name=case_type_display_html value="<?php  echo  htmlspecialchars($case_type_display_html); ?>"></td>
              </tr>
              <tr>
***************
*** 85,90 ****
                  <tr>
                      <td class=widget_content>
!                     <?php echo _("Click the button below to permanently remove this item."); ?>
!                     <p><?php echo _("Note: This action CANNOT be undone!"); ?></p>
                      <p><input class=button type=submit value="<?php echo _("Delete"); ?>"></p>
                      </td>
--- 85,90 ----
                  <tr>
                      <td class=widget_content>
!                     <p style="color: red;"><?php echo _("Notice: Deleting this Case Type will also delete ALL Case Statuses attached to it and ALL Activity Templates attached to those Statuses."); ?></p>
!                     <p style="font-weight: bold; color: red;"><?php echo _("WARNING: This action CANNOT be undone!"); ?></p>
                      <p><input class=button type=submit value="<?php echo _("Delete"); ?>"></p>
                      </td>
***************
*** 102,105 ****
--- 102,108 ----
  /**
   * $Log$
+  * Revision 1.13  2010/12/06 21:56:13  gopherit
+  * Deleting a workflow type now results in not only deleting all its statuses but also deleting all the activity templates attached to those statuses.
+  *
   * Revision 1.12  2006/12/05 11:09:59  jnhayart
   * Add cosmetics display, and control localisation

Index: delete.php
===================================================================
RCS file: /cvsroot/xrms/xrms/admin/case-types/delete.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** delete.php	14 Dec 2006 17:41:44 -0000	1.6
--- delete.php	6 Dec 2010 21:56:13 -0000	1.7
***************
*** 15,22 ****
  $session_user_id = session_check( 'Admin' );
  
! $case_type_id = $_POST['case_type_id'];
  
  $con = get_xrms_dbconnection();
  
  $sql = "SELECT * FROM case_types WHERE case_type_id = $case_type_id";
  $rst = $con->execute($sql);
--- 15,39 ----
  $session_user_id = session_check( 'Admin' );
  
! $case_type_id = (int)$_POST['case_type_id'];
  
  $con = get_xrms_dbconnection();
  
+ // Delete all activity templates attached to this case type through
+ // the case_statuses_table
+ $sql = "UPDATE activity_templates at, case_statuses cs
+         SET at.activity_template_record_status = 'd'
+         WHERE at.on_what_table = 'case_statuses'
+         AND at.activity_template_record_status = 'a'
+         AND at.on_what_id IN (SELECT case_status_id
+                                 FROM case_statuses cs
+                                 WHERE cs.case_type_id = $case_type_id
+                                 AND cs.case_status_record_status = 'a')";
+ $rst = $con->Execute($sql);
+ 
+ // Delete the child case_statuses
+ $sql = "UPDATE case_statuses SET case_status_record_status = 'd' WHERE case_type_id = $case_type_id";
+ $rst = $con->execute($sql);
+ 
+ // And delete the case type
  $sql = "SELECT * FROM case_types WHERE case_type_id = $case_type_id";
  $rst = $con->execute($sql);
***************
*** 28,34 ****
  $con->execute($upd);
  
- // Mark the child case_statuses records as deleted
- $sql = "UPDATE case_statuses SET case_status_record_status = 'd' WHERE case_type_id = $case_type_id";
- $rst = $con->execute($sql);
  
  $con->close();
--- 45,48 ----
***************
*** 38,41 ****
--- 52,58 ----
  /**
   * $Log$
+  * Revision 1.7  2010/12/06 21:56:13  gopherit
+  * Deleting a workflow type now results in not only deleting all its statuses but also deleting all the activity templates attached to those statuses.
+  *
   * Revision 1.6  2006/12/14 17:41:44  fcrossen
   * - mark child case-status records as deleted when a case-type is deleted