[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 $current_user;
  13  global $adb;
  14  
  15  if(isset($_REQUEST['file']) && ($_REQUEST['file'] !=''))
  16  {
  17      require_once('modules/Users/'.$_REQUEST['file'].'.php');
  18  }
  19  if(isset($_REQUEST['orgajax']) && ($_REQUEST['orgajax'] !=''))
  20  {
  21      require_once ('modules/Users/CreateSharingRule.php');    
  22  }
  23  elseif(isset($_REQUEST['announce_save']) && ($_REQUEST['announce_save'] != ''))
  24  {
  25      $date_var = date('YmdHis');
  26      $announcement = $_REQUEST['announcement'];
  27      $title = $_REQUEST['title_announcement'];
  28      $sql="select * from vtiger_announcement where creatorid=".$current_user->id;
  29      $is_announce=$adb->query($sql);
  30      if($adb->num_rows($is_announce) > 0)
  31          $query="update vtiger_announcement set announcement=".$adb->formatString("vtiger_announcement","announcement",$announcement).",time=".$adb->formatString("vtiger_announcement","time",$date_var).",title='announcement' where creatorid=".$current_user->id;
  32      else
  33          $query="insert into vtiger_announcement values (".$current_user->id.",".$adb->formatString("vtiger_announcement","announcement",$announcement).",'announcement',".$adb->formatString("vtiger_announcement","time",$date_var).")";
  34      $result=$adb->query($query);
  35      echo $announcement;
  36  }
  37  ?>