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));
 }
コード例 #2
0
ファイル: voucher_ui.php プロジェクト: knjy24/FrontAccounting
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);
}