[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  
  13  //5.0.2 database changes - added on 27-10-06
  14  global $adb;
  15  
  16  //Query added to show Manufacturer field in Products module
  17  $adb->query("update vtiger_field set displaytype=1,block=31 where tabid=14 and block=1");
  18  $adb->query("update vtiger_field set block=23,displaytype=1 where block=1 and displaytype=23 and tabid=10");
  19  $adb->query("update vtiger_field set block=22,displaytype=1 where block=1 and displaytype=22 and tabid=10");
  20  
  21  //Added to rearange the attachment in HelpDesk
  22  $adb->query(" update vtiger_field set block=25,sequence=12 where tabid=13 and fieldname='filename'");
  23  
  24  //Query added to as entityname,its tablename,its primarykey are saved in a table
  25  $adb->query(" CREATE TABLE `vtiger_entityname` (
  26      `tabid` int(19) NOT NULL default '0',
  27      `modulename` varchar(50) NOT NULL,
  28      `tablename` varchar(50) NOT NULL,
  29      `fieldname` varchar(150) NOT NULL,
  30      `entityidfield` varchar(150) NOT NULL,
  31      PRIMARY KEY (`tabid`),
  32      KEY `entityname_tabid_idx` (`tabid`)
  33  )");
  34  
  35  //Data Populated for the existing modules
  36  $adb->query("insert into vtiger_entityname values(7,'Leads','vtiger_leaddetails','lastname,firstname','leadid')");
  37  $adb->query("insert into vtiger_entityname values(6,'Accounts','vtiger_account','accountname','accountid')");
  38  $adb->query("insert into vtiger_entityname values(4,'Contacts','vtiger_contactdetails','lastname,firstname','contactid')");
  39  $adb->query("insert into vtiger_entityname values(2,'Potentials','vtiger_potential','potentialname','potentialid')");
  40  $adb->query("insert into vtiger_entityname values(8,'Notes','vtiger_notes','title','notesid')");
  41  $adb->query("insert into vtiger_entityname values(13,'HelpDesk','vtiger_troubletickets','title','ticketid')");
  42  $adb->query("insert into vtiger_entityname values(9,'Calendar','vtiger_activity','subject','activityid')");
  43  $adb->query("insert into vtiger_entityname values(10,'Emails','vtiger_activity','subject','activityid')");
  44  $adb->query("insert into vtiger_entityname values(14,'Products','vtiger_products','productname','productid')");
  45  $adb->query("insert into vtiger_entityname values(29,'Users','vtiger_users','last_name,first_name','id')");
  46  $adb->query("insert into vtiger_entityname values(23,'Invoice','vtiger_invoice','subject','invoiceid')");
  47  $adb->query("insert into vtiger_entityname values(20,'Quotes','vtiger_quotes','subject','quoteid')");
  48  $adb->query("insert into vtiger_entityname values(21,'PurchaseOrder','vtiger_purchaseorder','subject','purchaseorderid')");
  49  $adb->query("insert into vtiger_entityname values(22,'SalesOrder','vtiger_salesorder','subject','salesorderid')");
  50  $adb->query("insert into vtiger_entityname values(18,'Vendors','vtiger_vendor','vendorname','vendorid')");
  51  $adb->query("insert into vtiger_entityname values(19,'PriceBooks','vtiger_pricebook','bookname','pricebookid')");
  52  $adb->query("insert into vtiger_entityname values(26,'Campaigns','vtiger_campaign','campaignname','campaignid')");
  53  $adb->query("insert into vtiger_entityname values(15,'Faq','vtiger_faq','question','id')");
  54  
  55  //added quantity in stock in product default listview - All
  56  $res = $adb->query("select vtiger_cvcolumnlist.cvid from vtiger_cvcolumnlist inner join vtiger_customview on vtiger_cvcolumnlist.cvid=vtiger_customview.cvid where entitytype='Products' and viewname='All'");
  57  if($adb->num_rows != 0)
  58  {
  59      $cvid = $adb->query_result($res,0,'cvid');
  60      $adb->query("insert into vtiger_cvcolumnlist values($cvid,5,'vtiger_products:qtyinstock:qtyinstock:Products_Quantity_In_Stock:V')");
  61  }
  62  
  63  
  64  echo "<br>&nbsp; 5.0.2 Database changes has been done.<br>";
  65  
  66  
  67  ?>