X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Ftypes.inc;h=2c233be66f927b14074059665f7ca64c6388c09f;hb=9d4f2dee640cb454f90e52e44bacbb551c81f9c1;hp=cd4e3dc3d18fd055c040c9177c033dbf2634c244;hpb=0b63d898491b6577a5a5bf90e771dca0dcbbcf1f;p=fa-stable.git diff --git a/includes/types.inc b/includes/types.inc index cd4e3dc3..2c233be6 100644 --- a/includes/types.inc +++ b/includes/types.inc @@ -137,79 +137,6 @@ function payment_person_name($type, $person_id, $full=true) { } } -// -// Returns counterparty (supplier/customer) name for selected transaction. -// -function get_counterparty_name($trans_type, $trans_no, $full=true) -{ - switch($trans_type) - { - case ST_SALESORDER: - case ST_SALESQUOTE: - $sql = "SELECT order.customer_id as person_id, debtor.name as name - FROM ".TB_PREF."sales_orders order, ".TB_PREF."debtors_master debtor - WHERE order_no=".db_escape($trans_no)." AND trans_type=".db_escape($trans_type) - ." AND order.debtor_no=debtor.debtor_no"; - break; - case ST_SALESINVOICE : - case ST_CUSTCREDIT : - case ST_CUSTPAYMENT : - case ST_CUSTDELIVERY : - $sql = "SELECT trans.debtor_no as person_id, debtor.name as name - FROM ".TB_PREF."debtor_trans trans, ".TB_PREF."debtors_master debtor - WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type) - ." AND trans.debtor_no=debtor.debtor_no"; - break; - - case ST_PURCHORDER : - $sql = "SELECT order.supplier_id as person_id, supp.supp_name as name - FROM ".TB_PREF."purch_orders order, ".TB_PREF."suppliers supp - WHERE order_no=".db_escape($trans_no) - ." AND order.supplier_id=supp.supplier_id"; - break; - - case ST_SUPPINVOICE : - case ST_SUPPCREDIT : - case ST_SUPPAYMENT : - $sql = "SELECT trans.supplier_id as person_id, supp.supp_name as name - FROM ".TB_PREF."supp_trans trans, ".TB_PREF."suppliers supp - WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type) - ." AND trans.supplier_id=supp.supplier_id"; - break; - - case ST_SUPPRECEIVE : - $sql = "SELECT trans.supplier_id as person_id, supp.supp_name as name - FROM ".TB_PREF."grn_batch trans, ".TB_PREF."suppliers supp - WHERE id=".db_escape($trans_no) - ." AND trans.supplier_id=supp.supplier_id"; - break; - - case ST_JOURNAL: // FIXME - this one can have multiply counterparties of various types depending on person_type_id - - default: - /* // internal operations - case ST_WORKORDER : - case ST_INVADJUST : // GRN/DN returns ? - case ST_BANKTRANSFER : - case ST_LOCTRANSFER : - case ST_MANUISSUE : - case ST_MANURECEIVE : - case ST_COSTUPDATE : - case ST_BANKPAYMENT : // generic bank transactions - case ST_BANKDEPOSIT :*/ - return null; - } - - $result = db_query($sql, 'cannot retrieve counterparty name'); - if (db_num_rows($result)) - { - $row = db_fetch($result); - return sprintf("[%05s] %s", $row['person_id'], $row['name']); - } - - return ''; -} - function payment_person_has_items($type) { switch ($type) { @@ -259,8 +186,9 @@ define('CL_EXPENSE', 6); function get_class_type_convert($ctype) { - global $use_oldstyle_convert; - if (isset($use_oldstyle_convert) && $use_oldstyle_convert == 1) + global $SysPrefs; + + if (isset($SysPrefs->use_oldstyle_convert) && $SysPrefs->use_oldstyle_convert == 1) return (($ctype >= CL_INCOME || $ctype == CL_NONE) ? -1 : 1); else return ((($ctype >= CL_LIABILITIES && $ctype <= CL_INCOME) || $ctype == CL_NONE) ? -1 : 1); @@ -339,4 +267,3 @@ defined('ICON_SUBMIT') || define('ICON_SUBMIT', 'ok.gif'); defined('ICON_ESCAPE') || define('ICON_ESCAPE', 'escape.png'); defined('ICON_ALLOC') || define('ICON_ALLOC', 'alloc.png'); -?> \ No newline at end of file