X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=fixed_assets%2Fincludes%2Ffa_classes_db.inc;h=919f053b2fe4405c44bdb3464e20880887b6659b;hb=2778621096dd6e321f75f9587a6c18b6e50669ef;hp=3c5b68cf4c749718693d881cf100e5da07b02450;hpb=fd069bba86276f15311ff6ab10b22d4a06a55513;p=fa-stable.git diff --git a/fixed_assets/includes/fa_classes_db.inc b/fixed_assets/includes/fa_classes_db.inc index 3c5b68cf..919f053b 100644 --- a/fixed_assets/includes/fa_classes_db.inc +++ b/fixed_assets/includes/fa_classes_db.inc @@ -19,28 +19,36 @@ function get_fixed_asset_classes() return $result; } -function update_fixed_asset_class($fa_class_id, $parent_id, $description, $long_description, $depreciation_method, $depreciation_rate, $depreciation_period) +function get_fixed_asset_classname($class) +{ + $sql="SELECT description FROM ".TB_PREF."stock_fa_class WHERE fa_class_id = ".db_escape($class);; + + $result = db_query($sql,"fixed asset class name could not be retrieved"); + + $row = db_fetch_row($result); + + return $row[0]; +} + +function update_fixed_asset_class($fa_class_id, $parent_id, $description, $long_description, $depreciation_rate) { $sql = "UPDATE ".TB_PREF."stock_fa_class SET parent_id=".db_escape($parent_id).", description=".db_escape($description).", long_description=".db_escape($long_description).", - depreciation_method=".db_escape($depreciation_method).", - depreciation_rate=".db_escape($depreciation_rate).", - depreciation_period=".db_escape($depreciation_period)." + depreciation_rate=".db_escape($depreciation_rate)." WHERE fa_class_id=".db_escape($fa_class_id); db_query($sql, "The fixed asset class could not be updated"); } -function add_fixed_asset_class($fa_class_id, $parent_id, $description, $long_description, $depreciation_method, $depreciation_rate, $depreciation_period) +function add_fixed_asset_class($fa_class_id, $parent_id, $description, $long_description, $depreciation_rate) { $sql = "INSERT INTO ".TB_PREF."stock_fa_class (fa_class_id, parent_id, description, long_description, - depreciation_method, depreciation_rate, depreciation_period) VALUES (" + depreciation_rate) VALUES (" .db_escape($fa_class_id).", ".db_escape($parent_id).", " - .db_escape($description).", ".db_escape($long_description).", " - .db_escape($depreciation_method).", ".db_escape($depreciation_rate).", " - .db_escape($depreciation_period).")"; + .db_escape($description).", ".db_escape($long_description).", " + .db_escape($depreciation_rate).")"; db_query($sql, "The fixed asset class could not be added"); }