admin/db/company_db.inc

   1 <?php
   2
   3
   4 function update_company_gl_setup($debtors_act, $pyt_discount_act, $creditors_act, $grn_act,
   5                 $exchange_diff_act, $purch_exchange_diff_act,
   6                 $retained_earnings_act, $freight_act,
   7                 $default_sales_act,
   8                 $default_sales_discount_act,
   9                 $default_prompt_payment_act,
  10                 $default_inventory_act,
  11                 $default_cogs_act,
  12                 $default_adj_act,
  13                 $default_inv_sales_act,
  14                 $default_assembly_act,
  15                 $payroll_act,
  16                 $allow_negative_stock,
  17                 $po_over_receive,
  18                 $po_over_charge,
  19                 $past_due_days,
  20                 $default_credit_limit,
  21                 $default_workorder_required,
  22                 $default_dim_required)
  23 {
  24         $sql = "UPDATE ".TB_PREF."company SET
  25                 debtors_act=$debtors_act, pyt_discount_act=$pyt_discount_act,
  26                 creditors_act=$creditors_act, grn_act=$grn_act,
  27                 exchange_diff_act=$exchange_diff_act,
  28                 purch_exchange_diff_act=$purch_exchange_diff_act,
  29                 retained_earnings_act=$retained_earnings_act,
  30                 freight_act=$freight_act,
  31                 default_sales_act=$default_sales_act,
  32                 default_sales_discount_act=$default_sales_discount_act,
  33                 default_prompt_payment_act=$default_prompt_payment_act,
  34                 default_inventory_act=$default_inventory_act,
  35                 default_cogs_act=$default_cogs_act,
  36                 default_adj_act=$default_adj_act,
  37                 default_inv_sales_act=$default_inv_sales_act,
  38                 default_assembly_act=$default_assembly_act,
  39                 payroll_act=$payroll_act,
  40                 allow_negative_stock=$allow_negative_stock,
  41                 po_over_receive=$po_over_receive,
  42                 po_over_charge=$po_over_charge,
  43                 past_due_days=$past_due_days,
  44                 default_credit_limit=$default_credit_limit,
  45                 default_workorder_required=$default_workorder_required,
  46                 default_dim_required=$default_dim_required
  47                 WHERE coy_code=1";
  48
  49         db_query($sql, "The company gl setup could not be updated ");
  50 }
  51
  52 function update_company_setup($coy_name, $coy_no, $gst_no, $tax_prd, $tax_last, $postal_address, $phone, $fax, $email,
  53                 $coy_logo, $domicile, $Dimension, $custom1_name, $custom2_name, $custom3_name,
  54                 $custom1_value, $custom2_value, $custom3_value, $curr_default, $f_year)
  55 {
  56         if ($f_year == null)
  57                 $f_year = 0;
  58         $sql = "UPDATE ".TB_PREF."company SET coy_name='$coy_name',
  59                 coy_no = '$coy_no',
  60                 gst_no='$gst_no',
  61                 tax_prd=$tax_prd,
  62                 tax_last=$tax_last,
  63                 postal_address ='$postal_address',
  64                 phone='$phone', fax='$fax',
  65                 email='$email',
  66                 coy_logo='$coy_logo',
  67                 domicile='$domicile',
  68                 use_dimension=$Dimension,
  69         custom1_name='$custom1_name',
  70         custom2_name='$custom2_name',
  71         custom3_name='$custom3_name',
  72         custom1_value='$custom1_value',
  73         custom2_value='$custom2_value',
  74         custom3_value='$custom3_value',
  75                 curr_default='$curr_default',
  76                 f_year=$f_year
  77                 WHERE coy_code=1";
  78
  79         db_query($sql, "The company setup could not be updated ");
  80 }
  81
  82 function get_company_prefs()
  83 {
  84         $sql = "SELECT * FROM ".TB_PREF."company WHERE coy_code=1";
  85         $result = db_query($sql, "The company preferences could not be retrieved");
  86
  87         if (db_num_rows($result) == 0)
  88                 display_db_error("FATAL : Could not find company prefs", $sql);
  89
  90         return db_fetch($result);
  91 }
  92
  93 function get_company_pref($pref_name)
  94 {
  95         $prefs = get_company_prefs();
  96         return $prefs[$pref_name];
  97 }
  98
  99 // fiscal year routines
 100 function add_fiscalyear($from_date, $to_date, $closed)
 101 {
 102         $from = date2sql($from_date);
 103         $to = date2sql($to_date);
 104
 105         $sql = "INSERT INTO ".TB_PREF."fiscal_year (begin, end, closed)
 106                 VALUES ('$from', '$to', $closed)";
 107
 108         db_query($sql, "could not add fiscal year");
 109 }
 110
 111 function update_fiscalyear($from_date, $closed)
 112 {
 113         $from = date2sql($from_date);
 114
 115         $sql = "UPDATE ".TB_PREF."fiscal_year SET closed=$closed
 116                 WHERE begin='$from'";
 117
 118         db_query($sql, "could not update fiscal year");
 119 }
 120
 121 function get_all_fiscalyears()
 122 {
 123         $sql = "SELECT * FROM ".TB_PREF."fiscal_year ORDER BY begin";
 124
 125         return db_query($sql, "could not get all fiscal years");
 126 }
 127
 128 function get_fiscalyear($from_date)
 129 {
 130         $from = date2sql($from_date);
 131
 132         $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE begin='$from'";
 133
 134         $result = db_query($sql, "could not get fiscal year");
 135
 136         return db_fetch($result);
 137 }
 138
 139 function get_current_fiscalyear()
 140 {
 141         $year = get_company_pref('f_year');
 142
 143         $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE id=$year";
 144
 145         $result = db_query($sql, "could not get current fiscal year");
 146
 147         return db_fetch($result);
 148 }
 149
 150 function delete_fiscalyear($from_date)
 151 {
 152         $from = date2sql($from_date);
 153         begin_transaction();
 154
 155         $sql="DELETE FROM ".TB_PREF."fiscal_year WHERE begin='$from'";
 156
 157         db_query($sql, "could not delete fiscal year");
 158
 159         commit_transaction();
 160 }
 161
 162
 163 ?>