4 function update_company_gl_setup($debtors_act, $pyt_discount_act, $creditors_act,
8 $default_sales_discount_act,
9 $default_prompt_payment_act,
10 $default_inventory_act,
13 $default_inv_sales_act,
14 $default_assembly_act,
15 $allow_negative_stock,
19 $default_credit_limit,
20 $default_workorder_required,
21 $default_dim_required)
23 $sql = "UPDATE ".TB_PREF."company SET
24 debtors_act=".db_escape($debtors_act).", pyt_discount_act=".db_escape($pyt_discount_act).",
25 creditors_act=".db_escape($creditors_act).",
26 freight_act=".db_escape($freight_act).",
27 exchange_diff_act=".db_escape($exchange_diff_act).",
28 default_sales_act=".db_escape($default_sales_act).",
29 default_sales_discount_act=".db_escape($default_sales_discount_act).",
30 default_prompt_payment_act=".db_escape($default_prompt_payment_act).",
31 default_inventory_act=".db_escape($default_inventory_act).",
32 default_cogs_act=".db_escape($default_cogs_act).",
33 default_adj_act=".db_escape($default_adj_act).",
34 default_inv_sales_act=".db_escape($default_inv_sales_act).",
35 default_assembly_act=".db_escape($default_assembly_act).",
36 allow_negative_stock=$allow_negative_stock,
37 po_over_receive=$po_over_receive,
38 po_over_charge=$po_over_charge,
39 past_due_days=$past_due_days,
40 default_credit_limit=$default_credit_limit,
41 default_workorder_required=$default_workorder_required,
42 default_dim_required=$default_dim_required
45 db_query($sql, "The company gl setup could not be updated ");
48 function update_company_setup($coy_name, $coy_no, $gst_no, $tax_prd, $tax_last, $postal_address, $phone, $fax, $email,
49 $coy_logo, $domicile, $Dimension, $custom1_name, $custom2_name, $custom3_name,
50 $custom1_value, $custom2_value, $custom3_value, $curr_default, $f_year, $no_item_list, $no_customer_list,
51 $no_supplier_list, $base_sales)
55 $sql = "UPDATE ".TB_PREF."company SET coy_name=".db_escape($coy_name).",
56 coy_no = ".db_escape($coy_no).",
57 gst_no=".db_escape($gst_no).",
60 postal_address =".db_escape($postal_address).",
61 phone=".db_escape($phone).", fax=".db_escape($fax).",
62 email=".db_escape($email).",
63 coy_logo=".db_escape($coy_logo).",
64 domicile=".db_escape($domicile).",
65 use_dimension=$Dimension,
66 no_item_list=$no_item_list,
67 no_customer_list=$no_customer_list,
68 no_supplier_list=$no_supplier_list,
69 custom1_name=".db_escape($custom1_name).",
70 custom2_name=".db_escape($custom2_name).",
71 custom3_name=".db_escape($custom3_name).",
72 custom1_value=".db_escape($custom1_value).",
73 custom2_value=".db_escape($custom2_value).",
74 custom3_value=".db_escape($custom3_value).",
75 curr_default=".db_escape($curr_default).",
77 base_sales=$base_sales
80 db_query($sql, "The company setup could not be updated ");
83 function get_company_prefs()
85 $sql = "SELECT * FROM ".TB_PREF."company WHERE coy_code=1";
86 $result = db_query($sql, "The company preferences could not be retrieved");
88 if (db_num_rows($result) == 0)
89 display_db_error("FATAL : Could not find company prefs", $sql);
91 return db_fetch($result);
94 function get_company_pref($pref_name)
96 $prefs = get_company_prefs();
97 return $prefs[$pref_name];
100 // fiscal year routines
101 function add_fiscalyear($from_date, $to_date, $closed)
103 $from = date2sql($from_date);
104 $to = date2sql($to_date);
106 $sql = "INSERT INTO ".TB_PREF."fiscal_year (begin, end, closed)
107 VALUES (".db_escape($from).",".db_escape($to).", $closed)";
109 db_query($sql, "could not add fiscal year");
112 function update_fiscalyear($id, $closed)
114 $sql = "UPDATE ".TB_PREF."fiscal_year SET closed=$closed
115 WHERE id=".db_escape($id);
117 db_query($sql, "could not update fiscal year");
120 function get_all_fiscalyears()
122 $sql = "SELECT * FROM ".TB_PREF."fiscal_year ORDER BY begin";
124 return db_query($sql, "could not get all fiscal years");
127 function get_fiscalyear($id)
129 $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE id=".db_escape($id);
131 $result = db_query($sql, "could not get fiscal year");
133 return db_fetch($result);
136 function get_current_fiscalyear()
138 $year = get_company_pref('f_year');
140 $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE id=$year";
142 $result = db_query($sql, "could not get current fiscal year");
144 return db_fetch($result);
147 function delete_fiscalyear($id)
151 $sql="DELETE FROM ".TB_PREF."fiscal_year WHERE id=".db_escape($id);
153 db_query($sql, "could not delete fiscal year");
155 commit_transaction();
158 function get_base_sales_type()
160 $sql = "SELECT base_sales FROM ".TB_PREF."company WHERE coy_code=1";
162 $result = db_query($sql, "could not get base sales type");
163 $myrow = db_fetch($result);