function crm_category_types_list($name, $selected_id = null, $filter = array(), $submit_on_change = true) { $sql = "SELECT id, name, type, inactive FROM " . TB_PREF . "crm_categories"; $multi = false; $groups = false; $where = array(); if (@$filter['class']) { $where[] = 'type=' . db_escape($filter['class']); } else { $groups = 'type'; } if (@$filter['subclass']) { $where[] = 'action=' . db_escape($filter['subclass']); } if (@$filter['entity']) { $where[] = 'entity_id=' . db_escape($filter['entity']); } if (@$filter['multi']) { // contact category selector for person $multi = true; } return combo_input($name, $selected_id, $sql, 'id', 'name', array('multi' => $multi, 'height' => $multi ? 5 : 1, 'category' => $groups, 'select_submit' => $submit_on_change, 'async' => true, 'where' => $where)); }
function imc_list($name, $selected_id = null, $new_item = false, $submit_on_change = false, $show_inactive = false) { $sql = "SELECT salesman_code, salesman_name, inactive FROM " . TB_PREF . "salesman"; $options = array('spec_option' => $new_item ? _("Select IMC") : false, 'spec_id' => '', 'select_submit' => $submit_on_change, 'show_inactive' => $show_inactive); return combo_input($name, $selected_id, $sql, 'salesman_code', 'salesman_name', $options); }