PHP xl_list_label函数代码示例

function generate_list_payment_category($tag_name, $list_id, $currvalue, $title, $empty_name = ' ', $class = '', $onchange = '', $PaymentType = 'insurance', $screen = 'new_payment')
{
    $s = '';
    $tag_name_esc = htmlspecialchars($tag_name, ENT_QUOTES);
    $s .= "<select name='{$tag_name_esc}' id='{$tag_name_esc}'";
    if ($class) {
        $s .= " class='{$class}'";
    }
    if ($onchange) {
        $s .= " onchange='{$onchange}'";
    }
    $selectTitle = htmlspecialchars($title, ENT_QUOTES);
    $s .= " title='{$selectTitle}'>";
    $selectEmptyName = htmlspecialchars(xl($empty_name), ENT_QUOTES);
    if ($empty_name) {
        $s .= "<option value=''>" . $selectEmptyName . "</option>";
    }
    $lres = sqlStatement("SELECT * FROM list_options " . "WHERE list_id = ? ORDER BY seq, title", array($list_id));
    $got_selected = FALSE;
    while ($lrow = sqlFetchArray($lres)) {
        $optionValue = htmlspecialchars($lrow['option_id'], ENT_QUOTES);
        $s .= "<option   id='option_" . $lrow['option_id'] . "'" . " value='{$optionValue}'";
        if (strlen($currvalue) == 0 && $lrow['is_default'] || strlen($currvalue) > 0 && $lrow['option_id'] == $currvalue || $lrow['option_id'] == 'insurance_payment' && $screen == 'new_payment') {
            $s .= " selected";
            $got_selected = TRUE;
        }
        if (($PaymentType == 'insurance' || $screen == 'new_payment') && ($lrow['option_id'] == 'family_payment' || $lrow['option_id'] == 'patient_payment')) {
            $s .= " style='background-color:#DEDEDE' ";
        }
        if ($PaymentType == 'patient' && $lrow['option_id'] == 'insurance_payment') {
            $s .= " style='background-color:#DEDEDE' ";
        }
        $optionLabel = htmlspecialchars(xl_list_label($lrow['title']), ENT_QUOTES);
        $s .= ">{$optionLabel}</option>\n";
    }
    if (!$got_selected && strlen($currvalue) > 0) {
        $currescaped = htmlspecialchars($currvalue, ENT_QUOTES);
        $s .= "<option value='{$currescaped}' selected>* {$currescaped} *</option>";
        $s .= "</select>";
        $fontTitle = htmlspecialchars(xl('Please choose a valid selection from the list.'), ENT_QUOTES);
        $fontText = htmlspecialchars(xl('Fix this'), ENT_QUOTES);
        $s .= " <font color='red' title='{$fontTitle}'>{$fontText}!</font>";
    } else {
        $s .= "</select>";
    }
    return $s;
}

function getListOptions($list_id)
{
    $options = array();
    $sql = sqlStatement("SELECT option_id, title from list_options WHERE list_id = ?", array($list_id));
    for ($iter = 0; $row = sqlFetchArray($sql); $iter++) {
        $options[] = new Option(out($row['option_id']), out(xl_list_label($row['title'])));
    }
    return $options;
}

function getListItem($listid, $value)
{
    $lrow = sqlQuery("SELECT title FROM list_options " . "WHERE list_id = ? AND option_id = ?", array($listid, $value));
    $tmp = xl_list_label($lrow['title']);
    if (empty($tmp)) {
        $tmp = "({$value})";
    }
    return $tmp;
}

  <td class='text' >
   <?php 
    echo xlt('Payment Method');
    ?>
:
  </td>
  <td colspan='2' >
  <select name="form_method" id="form_method"  class="text" onChange='CheckVisible("yes")'>
  <?php 
    $query1112 = "SELECT * FROM list_options where list_id=?  ORDER BY seq, title ";
    $bres1112 = sqlStatement($query1112, array('payment_method'));
    while ($brow1112 = sqlFetchArray($bres1112)) {
        if ($brow1112['option_id'] == 'electronic' || $brow1112['option_id'] == 'bank_draft') {
            continue;
        }
        echo "<option value='" . htmlspecialchars($brow1112['option_id'], ENT_QUOTES) . "'>" . htmlspecialchars(xl_list_label($brow1112['title']), ENT_QUOTES) . "</option>";
    }
    ?>
  </select>
  </td>
 </tr>
 
 <tr height="5"><td colspan='3'></td></tr>

 <tr>
  <td class='text' >
   <?php 
    echo xla('Check/Ref Number');
    ?>
:
  </td>

function getListItemTitle($list, $option)
{
    $row = sqlQuery("SELECT title FROM list_options WHERE " . "list_id = ? AND option_id = ?", array($list, $option));
    if (empty($row['title'])) {
        return $option;
    }
    return xl_list_label($row['title']);
}

  <td><span class='bold'><?php 
echo xlt('Short Description');
?>
</span></td>
<?php 
if (related_codes_are_used()) {
    ?>
  <td><span class='bold'><?php 
    echo xlt('Related');
    ?>
</span></td>
<?php 
}
$pres = sqlStatement("SELECT title FROM list_options " . "WHERE list_id = 'pricelevel' ORDER BY seq");
while ($prow = sqlFetchArray($pres)) {
    echo "  <td class='bold' align='right' nowrap>" . text(xl_list_label($prow['title'])) . "</td>\n";
}
?>
  <td></td>
  <td></td>
 </tr>
<?php 
if (isset($_REQUEST['filter'])) {
    $res = main_code_set_search($filter_key, $search, NULL, NULL, false, NULL, false, $fstart, $fend - $fstart, $filter_elements);
}
for ($i = 0; $row = sqlFetchArray($res); $i++) {
    $all[$i] = $row;
}
if (!empty($all)) {
    $count = 0;
    foreach ($all as $iter) {

    echo "<input type='checkbox' name='form_cb_prices' value='1' />\n";
    echo " " . xl('Prices') . "<br />\n";
    echo "<input type='checkbox' name='form_cb_categories' value='1' />\n";
    echo " " . xl('Document Categories') . "<br />\n";
    echo "<input type='checkbox' name='form_cb_feesheet' value='1' />\n";
    echo " " . xl('Fee Sheet Options') . "<br />\n";
    echo "<input type='checkbox' name='form_cb_lang' value='1' />\n";
    echo " " . xl('Translations') . "<br />\n";
    // Multi-select for lists.
    echo "</td><td valign='top'>\n";
    echo "<b>" . xlt('Lists') . "</b><br />\n";
    echo "<select multiple name='form_sel_lists[]' size='15'>";
    $lres = sqlStatement("SELECT option_id, title FROM list_options WHERE " . "list_id = 'lists' ORDER BY title, seq");
    while ($lrow = sqlFetchArray($lres)) {
        echo "<option value='" . attr($lrow['option_id']) . "'";
        echo ">" . text(xl_list_label($lrow['title'])) . "</option>\n";
    }
    echo "</select>\n";
    // Multi-select for layouts.
    echo "</td><td valign='top'>\n";
    echo "<b>" . xlt('Layouts') . "</b><br />\n";
    echo "<select multiple name='form_sel_layouts[]' size='15'>";
    $lres = sqlStatement("SELECT option_id, title FROM list_options WHERE " . "list_id = 'lbfnames' ORDER BY title, seq");
    while ($lrow = sqlFetchArray($lres)) {
        echo "<option value='" . attr($lrow['option_id']) . "'";
        echo ">" . text(xl_layout_label($lrow['title'])) . "</option>\n";
    }
    echo "</select>\n";
    echo "</td>\n</tr>\n</table>\n";
    echo "&nbsp;<br /><input type='submit' value='" . xl('Continue') . "' />\n";
}

function List_Look($thisData, $thisList)
{
    if ($thisList == 'occurrence') {
        if (!$thisData || $thisData == '') {
            return xl('Unknown or N/A');
        }
    }
    if ($thisData == '') {
        return '';
    }
    $fres = sqlStatement("SELECT title FROM list_options WHERE list_id = ? " . "AND option_id = ? AND activity = 1", array($thisList, $thisData));
    if ($fres) {
        $rret = sqlFetchArray($fres);
        $dispValue = xl_list_label($rret['title']);
        if ($thisList == 'occurrence' && $dispValue == '') {
            $dispValue = xl('Unknown or N/A');
        }
    } else {
        $dispValue = xl('Not Found');
    }
    return $dispValue;
}

 $category = $row['title'] ? $row['title'] : 'Uncategorized';
 $disp_category = '&nbsp';
 if ($category !== $last_category) {
     $last_category = $category;
     $disp_category = $category;
     ++$irow;
 }
 foreach ($code_types as $key => $value) {
     if ($value['id'] == $row['code_type']) {
         break;
     }
 }
 $bgcolor = $irow & 1 ? "#ffdddd" : "#ddddff";
 echo "  <tr bgcolor='{$bgcolor}'>\n";
 // Added 5-09 by BM - Translate label if applicable
 echo "   <td class='text'>" . xl_list_label($disp_category) . "</td>\n";
 echo "   <td class='text'>{$key}</td>\n";
 echo "   <td class='text'>" . $row['code'] . "</td>\n";
 echo "   <td class='text'>" . $row['modifier'] . "</td>\n";
 echo "   <td class='text'>" . $row['units'] . "</td>\n";
 echo "   <td class='text'>" . $row['code_text'] . "</td>\n";
 if (related_codes_are_used()) {
     // Show related codes.
     echo "   <td class='text'>";
     $arel = explode(';', $row['related_code']);
     foreach ($arel as $tmp) {
         list($reltype, $relcode) = explode(':', $tmp);
         $reltype = $code_types[$reltype]['id'];
         $relrow = sqlQuery("SELECT code_text FROM codes WHERE " . "code_type = '{$reltype}' AND code = '{$relcode}' LIMIT 1");
         echo $relcode . ' ' . trim($relrow['code_text']) . '<br />';
     }

</table>

<p>
<?php 
$procedure_order_type = getListOptions('order_type', array('option_id', 'title'));
?>
<select name="procedure_type_names" id="procedure_type_names">
	<?php 
foreach ($procedure_order_type as $ordered_types) {
    ?>
	<option value="<?php 
    echo attr($ordered_types['option_id']);
    ?>
" ><?php 
    echo text(xl_list_label($ordered_types['title']));
    ?>
</option>
	<?php 
}
?>
    
</select> 
<input type='button' value='<?php 
echo xla('Add Procedure');
?>
' onclick="addProcLine()" />
&nbsp;
<input type='submit' name='bn_save' value='<?php 
echo xla('Save');
?>

//
$sanitize_all_escapes = true;
$fake_register_globals = false;
require_once "../../globals.php";
require_once "{$srcdir}/formdata.inc.php";
$popup = empty($_REQUEST['popup']) ? 0 : 1;
// Generate some code based on the list of columns.
//
$colcount = 0;
$header0 = "";
$header = "";
$coljson = "";
$res = sqlStatement("SELECT option_id, title FROM list_options WHERE " . "list_id = 'ptlistcols' ORDER BY seq, title");
while ($row = sqlFetchArray($res)) {
    $colname = $row['option_id'];
    $title = xl_list_label($row['title']);
    $header .= "   <th>";
    $header .= text($title);
    $header .= "</th>\n";
    $header0 .= "   <td align='center'><input type='text' size='10' ";
    $header0 .= "value='' class='search_init' /></td>\n";
    if ($coljson) {
        $coljson .= ", ";
    }
    $coljson .= "{\"sName\": \"" . addcslashes($colname, "\t\r\n\"\\") . "\"}";
    ++$colcount;
}
?>
<html>
<head>
<?php 

 public function generatePriceLevelSelector($tagname = 'pricelevel', $disabled = false)
 {
     $s = "<select name='" . attr($tagname) . "'";
     if ($disabled) {
         $s .= " disabled";
     }
     $s .= ">";
     $pricelevel = $this->getPriceLevel();
     $plres = sqlStatement("SELECT option_id, title FROM list_options " . "WHERE list_id = 'pricelevel' AND activity = 1 ORDER BY seq");
     while ($plrow = sqlFetchArray($plres)) {
         $key = $plrow['option_id'];
         $val = $plrow['title'];
         $s .= "<option value='" . attr($key) . "'";
         if ($key == $pricelevel) {
             $s .= ' selected';
         }
         $s .= ">" . text(xl_list_label($val)) . "</option>";
     }
     $s .= "</select>";
     return $s;
 }

function load_drug_attributes($id)
{
    $res = sqlStatement("SELECT * FROM list_options WHERE list_id = '{$id}' ORDER BY seq");
    while ($row = sqlFetchArray($res)) {
        if ($row['title'] == '') {
            $arr[$row['option_id']] = ' ';
        } else {
            $arr[$row['option_id']] = xl_list_label($row['title']);
        }
    }
    return $arr;
}

function fetch_rule_txt($list_id, $option_id)
{
    $rs = sqlQuery('SELECT title, seq from list_options WHERE list_id=? AND option_id=?', array($list_id, $option_id));
    $rs['title'] = xl_list_label($rs['title']);
    return $rs;
}

 public function getListtitle($listId, $listOptionId)
 {
     $appTable = new ApplicationTable();
     $sql = "SELECT title FROM list_options WHERE list_id = ? AND option_id = ? ";
     $result = $appTable->zQuery($sql, array($listId, $listOptionId));
     $row = $result->current();
     $return = xl_list_label($row['title']);
     return $return;
 }