[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  require_once ("include/database/PearDatabase.php");
  13  
  14  $organization_name=$_REQUEST['organization_name'];
  15  $org_name=$_REQUEST['org_name'];
  16  $organization_address=$_REQUEST['organization_address'];
  17  $organization_city=$_REQUEST['organization_city'];
  18  $organization_state=$_REQUEST['organization_state'];
  19  $organization_code=$_REQUEST['organization_code'];
  20  $organization_country=$_REQUEST['organization_country'];
  21  $organization_phone=$_REQUEST['organization_phone'];
  22  $organization_fax=$_REQUEST['organization_fax'];
  23  $organization_website=$_REQUEST['organization_website'];
  24  
  25  $sql="select * from vtiger_organizationdetails where organizationname = '".$org_name."'";
  26  $result = $adb->query($sql);
  27  $org_name = $adb->query_result($result,0,'organizationname');
  28  
  29  if($org_name=='')
  30  {
  31      $sql="insert into vtiger_organizationdetails values( '".$organization_name ."','".$organization_address."','". $organization_city."','".$organization_state."','".$organization_code."','".$organization_country."','".$organization_phone."','".$organization_fax."','".$organization_website."')";
  32  }
  33  else
  34  {
  35      $sql="update vtiger_organizationdetails set organizationname = '".$organization_name."', address = '".$organization_address."', city = '".$organization_city."', state = '".$organization_state."',  code = '".$organization_code."', country = '".$organization_country."' ,  phone = '".$organization_phone."' ,  fax = '".$organization_fax."',  website = '".$organization_website."' where organizationname = '".$org_name."'";
  36  }    
  37  
  38  
  39  $adb->query($sql);
  40  
  41  header("Location: index.php?module=Settings&action=OrganizationConfig");
  42  ?>