sql/alter2.2.php

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 class fa2_2 {
  13         var $version = '2.2';   // version installed
  14         var $description = 'Version 2.2';
  15         var $sql = 'alter2.2.sql';
  16         //
  17         //      Install procedure. All additional changes
  18         //      not included in sql file should go here.
  19         //
  20         function install($pref, $force)
  21         {
  22                 global $db, $systypes_array;
  23                 // set item category dflt accounts to values from company GL setup
  24                 $prefs = get_company_prefs();
  25                 $sql = "UPDATE {$pref}stock_category SET "
  26                         ."dflt_sales_act = '" . $prefs['default_inv_sales_act'] . "',"
  27                         ."dflt_cogs_act = '". $prefs['default_cogs_act'] . "',"
  28                         ."dflt_inventory_act = '" . $prefs['default_inventory_act'] . "',"
  29                         ."dflt_adjustment_act = '" . $prefs['default_adj_act'] . "',"
  30                         ."dflt_assembly_act = '" . $prefs['default_assembly_act']."'";
  31                 if (db_query($sql)==false) {
  32                         display_error("Cannot update category default GL accounts"
  33                         .':<br>'. db_error_msg($db));
  34                         return false;
  35                 }
  36                 // add all references to refs table for easy searching via journal interface
  37                 foreach($systypes_array as $typeno => $typename) {
  38                         $info = get_systype_db_info($typeno);
  39                         if ($info == null || $info[3] == null) continue;
  40                         $tbl = str_replace(TB_PREF, $pref, $info[0]);
  41                         $sql = "SELECT {$info[2]} as id,{$info[3]} as ref FROM $tbl";
  42                         if ($info[1])
  43                                 $sql .= " WHERE {$info[1]}=$typeno";
  44                         $result = db_query($sql);
  45                         if(db_num_rows($result)) {
  46                                 while($row = db_fetch($result)) {
  47                                         $res2 = db_query("INSERT INTO {$pref}refs VALUES("
  48                                                 . $row['id'].",".$typeno.",'".$row['ref']."')");
  49                                         if (!$res2) {
  50                                                 display_error(_("Cannot copy references from $tbl")
  51                                                         .':<br>'. db_error_msg($db));
  52                                                 return false;
  53                                         }
  54                                 }
  55                         }
  56                 }
  57 /*      FIX
  58                 // add audit_trail data for all transactions
  59                 $datatbl = array ("gl_trans", "purch_orders", "sales_orders",
  60                         "workorders");
  61                 $sql = "INSERT INTO ".$pref."audit_trail"
  62                 ." (type, trans_no, user, fiscal_year, gl_date) VALUES ("
  63                 . "$type,$trans_no,$user,$year,$date)";
  64 */
  65                 return true;
  66         }
  67         //
  68         //      Checking before install
  69         //
  70         function pre_check($pref)
  71         {
  72                 return true; // true when ok, fail otherwise
  73         }
  74         //
  75         //      Test if patch was applied before.
  76         //
  77         function installed($pref) {
  78                 if (check_table($pref, 'company', 'default_delivery_required')) return false;
  79                 if (check_table($pref, 'stock_category', 'dflt_dim2')) return false;
  80                 if (check_table($pref, 'users', 'sticky_doc_date')) return false;
  81                 if (check_table($pref, 'audit_trail')) return false;
  82                         return true;
  83         }
  84 };
  85
  86 $install = new fa2_2;
  87 ?>