X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fcompany_db.inc;h=c9f416f0315a93888fc325e17f959afac699a321;hb=ac67fd3d7312c358ddec72393538cf4590c66f49;hp=ff04a3f34440f7bde9fad69d11805b06bee50184;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/admin/db/company_db.inc b/admin/db/company_db.inc index ff04a3f3..c9f416f0 100644 --- a/admin/db/company_db.inc +++ b/admin/db/company_db.inc @@ -1,9 +1,18 @@ . +***********************************************************************/ + +function update_company_gl_setup($retained_act, $profit_loss_act, $debtors_act, $pyt_discount_act, $creditors_act, + $freight_act, + $exchange_diff_act, $default_sales_act, $default_sales_discount_act, $default_prompt_payment_act, @@ -12,76 +21,79 @@ function update_company_gl_setup($debtors_act, $pyt_discount_act, $creditors_act $default_adj_act, $default_inv_sales_act, $default_assembly_act, - $payroll_act, $allow_negative_stock, $po_over_receive, $po_over_charge, + $accumulate_shipping, + $legal_text, $past_due_days, $default_credit_limit, $default_workorder_required, - $default_dim_required) + $default_dim_required, + $default_delivery_required) { $sql = "UPDATE ".TB_PREF."company SET - debtors_act=$debtors_act, pyt_discount_act=$pyt_discount_act, - creditors_act=$creditors_act, grn_act=$grn_act, - exchange_diff_act=$exchange_diff_act, - purch_exchange_diff_act=$purch_exchange_diff_act, - retained_earnings_act=$retained_earnings_act, - freight_act=$freight_act, - default_sales_act=$default_sales_act, - default_sales_discount_act=$default_sales_discount_act, - default_prompt_payment_act=$default_prompt_payment_act, - default_inventory_act=$default_inventory_act, - default_cogs_act=$default_cogs_act, - default_adj_act=$default_adj_act, - default_inv_sales_act=$default_inv_sales_act, - default_assembly_act=$default_assembly_act, - payroll_act=$payroll_act, + retained_earnings_act=".db_escape($retained_act).", profit_loss_year_act=".db_escape($profit_loss_act).", + debtors_act=".db_escape($debtors_act).", pyt_discount_act=".db_escape($pyt_discount_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_inventory_act=".db_escape($default_inventory_act).", + default_cogs_act=".db_escape($default_cogs_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).", allow_negative_stock=$allow_negative_stock, po_over_receive=$po_over_receive, po_over_charge=$po_over_charge, + accumulate_shipping=$accumulate_shipping, + legal_text=".db_escape($legal_text).", past_due_days=$past_due_days, default_credit_limit=$default_credit_limit, default_workorder_required=$default_workorder_required, - default_dim_required=$default_dim_required + default_dim_required=$default_dim_required, + default_delivery_required=$default_delivery_required WHERE coy_code=1"; db_query($sql, "The company gl setup could not be updated "); } -function update_company_setup($coy_name, $coy_no, $gst_no, $tax_prd, $tax_last, $postal_address, $phone, $fax, $email, - $coy_logo, $domicile, $Dimension, $custom1_name, $custom2_name, $custom3_name, - $custom1_value, $custom2_value, $custom3_value, $curr_default, $f_year) +function update_company_setup($coy_name, $coy_no, $gst_no, $tax_prd, $tax_last, + $postal_address, $phone, $fax, $email, $coy_logo, $domicile, $Dimension, + $curr_default, $f_year, $no_item_list, $no_customer_list, $no_supplier_list, + $base_sales) { if ($f_year == null) $f_year = 0; - $sql = "UPDATE ".TB_PREF."company SET coy_name='$coy_name', - coy_no = '$coy_no', - gst_no='$gst_no', + $sql = "UPDATE ".TB_PREF."company SET coy_name=".db_escape($coy_name).", + coy_no = ".db_escape($coy_no).", + gst_no=".db_escape($gst_no).", tax_prd=$tax_prd, tax_last=$tax_last, - postal_address ='$postal_address', - phone='$phone', fax='$fax', - email='$email', - coy_logo='$coy_logo', - domicile='$domicile', + postal_address =".db_escape($postal_address).", + phone=".db_escape($phone).", fax=".db_escape($fax).", + email=".db_escape($email).", + coy_logo=".db_escape($coy_logo).", + domicile=".db_escape($domicile).", use_dimension=$Dimension, - custom1_name='$custom1_name', - custom2_name='$custom2_name', - custom3_name='$custom3_name', - custom1_value='$custom1_value', - custom2_value='$custom2_value', - custom3_value='$custom3_value', - curr_default='$curr_default', - f_year=$f_year + no_item_list=$no_item_list, + no_customer_list=$no_customer_list, + no_supplier_list=$no_supplier_list, + curr_default=".db_escape($curr_default).", + f_year=$f_year, + base_sales=$base_sales WHERE coy_code=1"; db_query($sql, "The company setup could not be updated "); } -function get_company_prefs() +function get_company_prefs($tbpref = TB_PREF) { - $sql = "SELECT * FROM ".TB_PREF."company WHERE coy_code=1"; + $sql = "SELECT * FROM ".$tbpref."company WHERE coy_code=1"; + $result = db_query($sql, "The company preferences could not be retrieved"); if (db_num_rows($result) == 0) @@ -90,9 +102,9 @@ function get_company_prefs() return db_fetch($result); } -function get_company_pref($pref_name) +function get_company_pref($pref_name, $tbpref = TB_PREF) { - $prefs = get_company_prefs(); + $prefs = get_company_prefs($tbpref); return $prefs[$pref_name]; } @@ -103,17 +115,15 @@ function add_fiscalyear($from_date, $to_date, $closed) $to = date2sql($to_date); $sql = "INSERT INTO ".TB_PREF."fiscal_year (begin, end, closed) - VALUES ('$from', '$to', $closed)"; + VALUES (".db_escape($from).",".db_escape($to).", $closed)"; 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='$from'"; + WHERE id=".db_escape($id); db_query($sql, "could not update fiscal year"); } @@ -125,11 +135,9 @@ function get_all_fiscalyears() 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='$from'"; + $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE id=".db_escape($id); $result = db_query($sql, "could not get fiscal year"); @@ -147,17 +155,25 @@ function get_current_fiscalyear() 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='$from'"; + $sql="DELETE FROM ".TB_PREF."fiscal_year WHERE id=".db_escape($id); db_query($sql, "could not delete fiscal year"); commit_transaction(); } +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]; +} + ?> \ No newline at end of file