<?php
-function update_company_gl_setup($debtors_act, $pyt_discount_act, $creditors_act, $grn_act,
- $exchange_diff_act, $purch_exchange_diff_act,
- $retained_earnings_act, $freight_act,
+function update_company_gl_setup($debtors_act, $pyt_discount_act, $creditors_act,
+ $freight_act,
+ $exchange_diff_act,
$default_sales_act,
$default_sales_discount_act,
$default_prompt_payment_act,
$default_adj_act,
$default_inv_sales_act,
$default_assembly_act,
- $payroll_act,
$allow_negative_stock,
$po_over_receive,
$po_over_charge,
{
$sql = "UPDATE ".TB_PREF."company SET
debtors_act=".db_escape($debtors_act).", pyt_discount_act=".db_escape($pyt_discount_act).",
- creditors_act=".db_escape($creditors_act).", grn_act=".db_escape($grn_act).",
- exchange_diff_act=".db_escape($exchange_diff_act).",
- purch_exchange_diff_act=".db_escape($purch_exchange_diff_act).",
- retained_earnings_act=".db_escape($retained_earnings_act).",
+ creditors_act=".db_escape($creditors_act).",
freight_act=".db_escape($freight_act).",
+ exchange_diff_act=".db_escape($exchange_diff_act).",
default_sales_act=".db_escape($default_sales_act).",
default_sales_discount_act=".db_escape($default_sales_discount_act).",
default_prompt_payment_act=".db_escape($default_prompt_payment_act).",
default_adj_act=".db_escape($default_adj_act).",
default_inv_sales_act=".db_escape($default_inv_sales_act).",
default_assembly_act=".db_escape($default_assembly_act).",
- payroll_act=".db_escape($payroll_act).",
allow_negative_stock=$allow_negative_stock,
po_over_receive=$po_over_receive,
po_over_charge=$po_over_charge,
db_query($sql, "could not add fiscal year");
}
-function update_fiscalyear($from_date, $closed)
+function update_fiscalyear($id, $closed)
{
- $from = date2sql($from_date);
-
$sql = "UPDATE ".TB_PREF."fiscal_year SET closed=$closed
- WHERE begin=".db_escape($from);
+ WHERE id=".db_escape($id);
db_query($sql, "could not update fiscal year");
}
return db_query($sql, "could not get all fiscal years");
}
-function get_fiscalyear($from_date)
+function get_fiscalyear($id)
{
- $from = date2sql($from_date);
-
- $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE begin=".db_escape($from);
+ $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE id=".db_escape($id);
$result = db_query($sql, "could not get fiscal year");
return db_fetch($result);
}
-function delete_fiscalyear($from_date)
+function delete_fiscalyear($id)
{
- $from = date2sql($from_date);
begin_transaction();
- $sql="DELETE FROM ".TB_PREF."fiscal_year WHERE begin=".db_escape($from);
+ $sql="DELETE FROM ".TB_PREF."fiscal_year WHERE id=".db_escape($id);
db_query($sql, "could not delete fiscal year");
function get_base_sales_type()
{
$sql = "SELECT base_sales FROM ".TB_PREF."company WHERE coy_code=1";
-
+
$result = db_query($sql, "could not get base sales type");
$myrow = db_fetch($result);
return $myrow[0];