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,
8 $default_sales_discount_act,
9 $default_prompt_payment_act,
10 $default_inventory_act,
13 $default_inv_sales_act,
14 $default_assembly_act,
16 $allow_negative_stock,
20 $default_credit_limit,
21 $default_workorder_required,
22 $default_dim_required)
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
49 db_query($sql, "The company gl setup could not be updated ");
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, $no_item_list, $no_customer_list,
59 $sql = "UPDATE ".TB_PREF."company SET coy_name='$coy_name',
64 postal_address ='$postal_address',
65 phone='$phone', fax='$fax',
69 use_dimension=$Dimension,
70 no_item_list=$no_item_list,
71 no_customer_list=$no_customer_list,
72 no_supplier_list=$no_supplier_list,
73 custom1_name='$custom1_name',
74 custom2_name='$custom2_name',
75 custom3_name='$custom3_name',
76 custom1_value='$custom1_value',
77 custom2_value='$custom2_value',
78 custom3_value='$custom3_value',
79 curr_default='$curr_default',
83 db_query($sql, "The company setup could not be updated ");
86 function get_company_prefs()
88 $sql = "SELECT * FROM ".TB_PREF."company WHERE coy_code=1";
89 $result = db_query($sql, "The company preferences could not be retrieved");
91 if (db_num_rows($result) == 0)
92 display_db_error("FATAL : Could not find company prefs", $sql);
94 return db_fetch($result);
97 function get_company_pref($pref_name)
99 $prefs = get_company_prefs();
100 return $prefs[$pref_name];
103 // fiscal year routines
104 function add_fiscalyear($from_date, $to_date, $closed)
106 $from = date2sql($from_date);
107 $to = date2sql($to_date);
109 $sql = "INSERT INTO ".TB_PREF."fiscal_year (begin, end, closed)
110 VALUES ('$from', '$to', $closed)";
112 db_query($sql, "could not add fiscal year");
115 function update_fiscalyear($from_date, $closed)
117 $from = date2sql($from_date);
119 $sql = "UPDATE ".TB_PREF."fiscal_year SET closed=$closed
120 WHERE begin='$from'";
122 db_query($sql, "could not update fiscal year");
125 function get_all_fiscalyears()
127 $sql = "SELECT * FROM ".TB_PREF."fiscal_year ORDER BY begin";
129 return db_query($sql, "could not get all fiscal years");
132 function get_fiscalyear($from_date)
134 $from = date2sql($from_date);
136 $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE begin='$from'";
138 $result = db_query($sql, "could not get fiscal year");
140 return db_fetch($result);
143 function get_current_fiscalyear()
145 $year = get_company_pref('f_year');
147 $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE id=$year";
149 $result = db_query($sql, "could not get current fiscal year");
151 return db_fetch($result);
154 function delete_fiscalyear($from_date)
156 $from = date2sql($from_date);
159 $sql="DELETE FROM ".TB_PREF."fiscal_year WHERE begin='$from'";
161 db_query($sql, "could not delete fiscal year");
163 commit_transaction();