[Sommaire] [Imprimer]

   1  <?php
   2  /*********************************************************************************
   3  ** The contents of this file are subject to the vtiger CRM Public License Version 1.0
   4   * ("License"); You may not use this file except in compliance with the License
   5   * The Original Code is:  vtiger CRM Open Source
   6   * The Initial Developer of the Original Code is vtiger.
   7   * Portions created by vtiger are Copyright (C) vtiger.
   8   * All Rights Reserved.
   9  *
  10   ********************************************************************************/
  11  
  12  global $adb;
  13  $del_id =  $_REQUEST['delete_user_id'];
  14  $tran_id = $_REQUEST['transfer_user_id'];
  15  
  16  //Updating the smcreatorid,smownerid, modifiedby in vtiger_crmentity
  17  $sql1 = "update vtiger_crmentity set smcreatorid=".$tran_id." where smcreatorid=".$del_id;
  18  $adb->query($sql1);
  19  $sql2 = "update vtiger_crmentity set smownerid=".$tran_id." where smownerid=".$del_id;
  20  $adb->query($sql2);
  21  $sql3 = "update vtiger_crmentity set modifiedby=".$tran_id." where modifiedby=".$del_id;
  22  $adb->query($sql3);
  23  
  24  //deleting from vtiger_tracker
  25  $sql4 = "delete from vtiger_tracker where user_id='".$del_id."'";
  26  $adb->query($sql4);
  27  
  28  //updating created by in vtiger_lar vtiger_table
  29  $sql5 = "update vtiger_lar set createdby=".$tran_id." where createdby=".$del_id;
  30  $adb->query($sql5);
  31  
  32  //updating the vtiger_import_maps vtiger_table
  33  $sql6 ="update vtiger_import_maps set assigned_user_id='".$tran_id."' where assigned_user_id='".$del_id."'";
  34  $adb->query($sql6);
  35  
  36  //update assigned_user_id in vtiger_files
  37  $sql7 ="update vtiger_files set assigned_user_id='".$tran_id."' where assigned_user_id='".$del_id."'";
  38  $adb->query($sql7); 
  39  
  40  
  41  //update assigned_user_id in vtiger_users_last_import
  42  $sql8 = "update vtiger_users_last_import set assigned_user_id='".$tran_id."' where assigned_user_id='".$del_id."'";
  43  $adb->query($sql8);
  44  
  45  //delete from vtiger_users to group vtiger_table
  46  $sql9 = "delete from vtiger_user2role where userid=".$del_id;
  47  $adb->query($sql9);
  48  
  49  //delete from vtiger_users to vtiger_role vtiger_table
  50  $sql9 = "delete from vtiger_users2group where userid=".$del_id;
  51  $adb->query($sql9);
  52  
  53  
  54  //delete from user vtiger_table;
  55  $sql9 = "delete from vtiger_users where id=".$del_id;
  56  $adb->query($sql9);
  57  
  58  //if check to delete user from detail view
  59  if(isset($_REQUEST["ajax_delete"]) && $_REQUEST["ajax_delete"] == 'false')
  60      header("Location: index.php?action=ListView&module=Users");
  61  else
  62      header("Location: index.php?action=UsersAjax&module=Users&file=ListView&ajax=true");
  63  ?>