<?php
  if (!defined("__UT_TEMPLATE__")) {
    // TEMPLATE Version 2.0
    define("__UT_TEMPLATE_DBFIELD_CREATEDATE__", "UT_CreateDate");
    define("__UT_TEMPLATE_DBFIELD_CREATORID__", "UT_CreatorID");
    define("__UT_TEMPLATE_DBFIELD_LASTEDITDATE__", "UT_LastEditDate");
    define("__UT_TEMPLATE_DBFIELD_LASTEDITID__", "UT_LastEditID");
    define("__UT_TEMPLATE_DBFIELD_STATUS__", "UT_Status");
    define("__UT_TEMPLATE_DBFIELD_SORT__", "UT_Sort");

    define("__UT_REC_ACTIVE__", "1");
    define("__UT_REC_DELETE__", "2");

    define("__UT_MODE_NEW__", "New");
    define("__UT_MODE_VIEW__", "View");

    // TEMPLATE Version 1.0
    define("__UT_TEMPLATE__", true);
    define("DEFAULT_IMG_PATH", "http://www.unitech.hk/globalAdmin/images/");

    define("__UT_TEMPLATE_DIRECTION_DESCENDING__", -1);
    define("__UT_TEMPLATE_DIRECTION_NONE__", 0);
    define("__UT_TEMPLATE_DIRECTION_ASCENDING__", 1);

    define("__UT_TEMPLATE_LISTTYPE_SHOW__", 1);
    define("__UT_TEMPLATE_LISTTYPE_SORT__", 2);
    define("__UT_TEMPLATE_LISTTYPE_SEARCH__", 4);

    define("__UT_TEMPLATE_EDITTYPE_INPUTBOX__", 1);
    define("__UT_TEMPLATE_EDITTYPE_TEXTBOX__", 2);
    define("__UT_TEMPLATE_EDITTYPE_DATETIME__", 4);
    define("__UT_TEMPLATE_EDITTYPE_DATESTR__", 8);
    define("__UT_TEMPLATE_EDITTYPE_CHECKBOX__", 16);
    define("__UT_TEMPLATE_EDITTYPE_RADIO__", 32);
    define("__UT_TEMPLATE_EDITTYPE_SELECTION__", 64);
    define("__UT_TEMPLATE_EDITTYPE_PASSWORD__", 128);
    define("__UT_TEMPLATE_EDITTYPE_FILE__", 256);
    define("__UT_TEMPLATE_EDITTYPE_BUTTON__", 512);


    define("__UT_TEMPLATE_OPTION_PRIMARYKEY__", 1);
    define("__UT_TEMPLATE_OPTION_HIDDEN__", 2);
    define("__UT_TEMPLATE_OPTION_READONLY__", 4);
    define("__UT_TEMPLATE_OPTION_MANDATORY__", 8);
    define("__UT_TEMPLATE_OPTION_IMG__", 16);  // for File only
    define("__UT_TEMPLATE_OPTION_RELOAD__", 32);  // for Radio, Selection and CheckBox only
    define("__UT_TEMPLATE_OPTION_FOREIGNKEY__", 64);  // for Radio, Selection and CheckBox only
    define("__UT_TEMPLATE_OPTION_MD5_PASSWORD__", 128);  // for Password only
    define("__UT_TEMPLATE_OPTION_MASTERDETAIL_REF__", 256); // for Primary key only
    define("__UT_TEMPLATE_OPTION_UNIQUE__", 512); // for inputbox only
    define("__UT_TEMPLATE_OPTION_AUTOINCREMENT__", 1024); // for inputbox only, use the default value for pattern and # as the increment value
    define("__UT_TEMPLATE_OPTION_LINK__", 2048);
    define("__UT_TEMPLATE_OPTION_AUTOCOMPLETE__", 4096);


    class UT_DATABASE_TYPE {
      var $table     = "";
      var $key       = "";
      var $value     = "";
      var $refField  = "";
      var $condition = "";
      var $clickButton = "";
      var $masterField = "";

      function set_var($table, $key, $value, $refField = "", $condition = "", $clickButton = "", $masterField = "") {
        $this->table = $table;
        $this->key = $key;
        $this->value = $value;
        $this->refField = $refField;
        $this->condition = $condition;
        $this->clickButton = $clickButton;
        $this->masterField = $masterField;
      }
    }

    class UT_FieldStruct {
      var $DBField  = "";
      var $desc     = "";
      var $width    = 0;
      var $len      = 0;
      var $default  = "";
      var $listType = 0;
      var $editType = 0;
      var $option   = 0;
      var $extra    = "";
      var $cond     = "";
    }

    class UT_Template {
      var $DateFormat = "Y-m-d";
      var $Validation = "";


      function PRI_date($timestamp) {
        if (($timestamp != "" ) && ($timestamp != 0)) {
          return date($this->DateFormat, $timestamp);
        } else
          return "";
      }

      function PRI_mktime($timestr) {
        if (($timestr != "" ) && ($timestr != 0)) {

          list($date, $time) = explode(' ', $timestr);
          list($yyyy, $mm, $dd) = explode('-', $date);
          list($hr, $min, $ss) = explode(':', $time);
          return mktime(intval($hr), intval($min), intval($ss), intval($mm), intval($dd), intval($yyyy));
        } else
          return 0;
      }


      function jAlert($field, $fieldDesc){
        $output = " $('body').append(\" <div id='ALERT_dialog_message' title='Alert'><span class='ui-icon ui-icon-alert' style='float:left; margin:0 7px 20px 0;'></span>".$fieldDesc." field is a mandatory field.  Try again!</div>\");\r\n";
        $output .= " $( '#ALERT_dialog_message' ).dialog({modal: true, close: function(ev, ui) { $(this).remove(); }, buttons: {\r\n";
        $output .= " Ok: function(){\r\n";
        $output .= " $( this ).dialog( 'close' ); $('#".$field."').focus();\r\n";
        $output .= " }}\r\n";
        $output .= " });\r\n";
        return $output;
      }

      function fileImage($ext){

        $ext = strtolower($ext);
        switch($ext){
          case "jpg":
          case "gif":
          case "png":
            $tImg = " <img src='./assets/images/file/jpg.png' width=25 border=0>";
            break;
          case "pdf":
            $tImg = " <img src='./assets/images/file/pdf.png' width=25 border=0 atl='PDF File' title='PDF File'>";
            break;
          case "doc":
            $tImg = " <img src='./assets/images/file/word.png' width=25 border=0 atl='Word File' title='Word File'>";
            break;

          case "xls":
            $tImg = " <img src='./assets/images/file/excel.png' width=25 border=0 atl='Excel File' title='Excel File'>";
            break;

          default:
            $tImg = " <img src='./assets/images/file/folder.png' width=30 border=0>";
        }
        return $tImg;
      }


      function mandatoryCheck() {
        $output = $this->Validation;
        $space = "      ";

        if(is_array($this->UT_Value->desc))
          $this->UT_Value->desc = $this->UT_Value->desc[0];
        else
          $this->UT_Value->desc = $this->UT_Value->desc;

        if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_MANDATORY__) {
          switch (true) {
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_FILE__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_INPUTBOX__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_TEXTBOX__):
              $output .= $space . "if ( $('#" . $this->UT_Value->DBField . "').val()=='') {\r\n";
              $output .= $space . $this->jAlert($this->UT_Value->DBField , $this->UT_Value->desc);
              $output .= $space . "  return false;\r\n";
              $output .= $space . "}\r\n\r\n";
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_PASSWORD__):
              $output .= $space . "if (UT_INPUTFORM." . $this->UT_Value->DBField . ".value=='') {\r\n";
              $output .= $space . "  alert('*** " . $this->UT_Value->desc . " *** is a mandatory field.  Try again');\r\n";
              $output .= $space . "  UT_INPUTFORM." . $this->UT_Value->DBField . ".focus();\r\n";
              $output .= $space . "  return false;\r\n";
              $output .= $space . "}\r\n\r\n";
              
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATESTR__):// tested, ok
              $output .= $space . "if ( $('#" . $this->UT_Value->DBField . "').val()=='') {\r\n";
              $output .= $space . $this->jAlert($this->UT_Value->DBField , $this->UT_Value->desc);
              $output .= $space . "  return false;\r\n";
              $output .= $space . "}\r\n\r\n";

              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATETIME__):
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_SELECTION__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_CHECKBOX__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_RADIO__):

              $output .= $space . "if ( $('#" . $this->UT_Value->DBField . "').val()==0) {\r\n";
              $output .= $space . $this->jAlert($this->UT_Value->DBField , $this->UT_Value->desc);
              $output .= $space . "  $('#" . $this->UT_Value->DBField . "').focus();\r\n";
              $output .= $space . "  return false;\r\n";
              $output .= $space . "}\r\n\r\n";

              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_FILE__):
              break;
          }
        }

        return $output;
      }

      function PRI_extractIncrPattern($value, $pattern="#") {
        $ret = strstr($value, $pattern);

        if ($ret != str_pad("", strlen($ret), $pattern)) {
          $ret = $this->PRI_extractIncrPattern(substr($ret, 1));
        }

        return $ret;
      }

      
      function PRI_loadDBValue_selection($value) {
        $db = new DB;
        $tmpArray = array();

        $sqlCondition = "";

        if ($this->UT_Value->extra->condition != "") {
          if ($sqlCondition != "")
            $sqlCondition .= " and ";
          $sqlCondition .= $this->UT_Value->extra->condition;
        }

        // Changes for TEMPLATE Version 2.0 2013年11月5日
        if ($sqlCondition != "")
          $sqlCondition = " where " . __UT_TEMPLATE_DBFIELD_STATUS__  . "=" . __UT_REC_ACTIVE__ . " and " . $sqlCondition;
        // Changes for TEMPLATE Version 2.0 2013年11月5日

        if (is_array($this->UT_Value->extra->value)) {
          $i = 0;

          foreach($this->UT_Value->extra->value as $index => $dbValue) {
            if ($i++ == 0)
              $sqlValue = "concat(" . $dbValue;
            else
              $sqlValue .= ", ' ', " . $dbValue;
          }
          $sqlValue .= ") as UT_SELECTION_VALUE";
        }
        else {
          $sqlValue = $this->UT_Value->extra->value . " as UT_SELECTION_VALUE";
        }

        if($this->UT_Value->extra->separateLine != "") {
          $sqlValue .= ", " . $this->UT_Value->extra->separateLine;
        }

        $sqlstr = "select " . $this->UT_Value->extra->key . ", " . $sqlValue . " from " . $this->UT_Value->extra->table . $sqlCondition;
        $db->query($sqlstr);
        while($db->next_record()) {
          $tmpArray[$db->f($this->UT_Value->extra->key)] = ($this->UT_Value->extra->separateLine != "" ? $db->f($this->UT_Value->extra->separateLine) . " - " : "") . $db->f("UT_SELECTION_VALUE");
        }

        return ($tmpArray);
      }


      function PRI_constructDBValue_selection($tmpArray, $value) {
        if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__) {
          $output .= "    <td>";
        }
        else {
          $output .= "    <td><select name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . ">\r\n";

          if ($tmpArray[0] == "")
            $output .= "    <option value=0>-- " . $this->UT_Value->desc . " --</option>\r\n";
        }

        foreach($tmpArray as $i => $selection) {
          while(is_array($selection)) {
            $selection = $selection[0];
          }

          if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__) {
            if ($i == $value)
              $output .= "    " . $selection . "<input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value=" . $i . ">\r\n";
          }
          else {
            if ($i == $value)
              $output .= "    <option value=$i selected>" . $selection . "</option>\r\n";
            else
              $output .= "    <option value=$i>" . $selection . "</option>\r\n";
          }
        }
        if (!($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__))
          $output .= "</select>";

        $output .= "<div id=AA_" . $this->UT_Value->DBField . "></div>";
        $output .= "</td>\r\n";

        return ($output);
      }

      function PRI_loadDBValue_File($value) {
        $tmpArray = explode(".", $value);

        switch(strtolower($tmpArray[sizeof($tmpArray) - 1])) {
          case "jpg":
          case "gif":
            $tmpWidthDesc = "";

            list($width, $height, $type, $attr) = getimagesize($this->UT_Value->extra[0] . $value);
            if ($width > 400)
              $tmpWidthDesc = " width=400";

            $output .= "<tr><td>&nbsp;</td><td><input type=hidden name=". $this->UT_Value->DBField . "_name value='" . $value . "'>" . $value . "<BR><a href='" . $this->UT_Value->extra[0] . $value . "' target=_new><img border=1 src='" . $this->UT_Value->extra[0] . $value . "'" . $tmpWidthDesc . "></a></td>\r\n";
            $output .= "</tr>\r\n";

            break;
          case "pdf":
            $output .= "<tr><td>&nbsp;</td><td><input type=hidden name=". $this->UT_Value->DBField . "_name value='" . $value . "'>" . $value . "<BR><a href='" . $this->UT_Value->extra[0] . $value . "' target=_new><img border=1 src='http://wwwimages.adobe.com/www.adobe.com/products/acrobat/images/reader_icon_special.jpg'></a></td>\r\n";
            $output .= "</tr>\r\n";
            
            break;
          case "doc":
          case "xls":
            break;
        }
        
        return ($output);
      }

      
      // *******************************************************************
      // * New data 
      // *******************************************************************      
      
      function newDBValue() {
        $retValue = "";

        if ( !(($this->UT_Value->option & __UT_TEMPLATE_OPTION_PRIMARYKEY__) || ($this->UT_Value->option & __UT_TEMPLATE_OPTION_AUTOINCREMENT__)) &&
              (isset($_GET["UT_SCH_" . $this->UT_Value->DBField])) ) {
          $retValue = $this->loadDBValue($_GET["UT_SCH_" . $this->UT_Value->DBField]);
        }
        else {
          if (is_array($this->UT_Value->default))
            $retValue = $this->loadDBValue($this->UT_Value->default[0]);
          else
            $retValue = $this->loadDBValue($this->UT_Value->default);
        }

        return $retValue;
      }

      // *******************************************************************
      // * load data 
      // *******************************************************************

     function loadDBValue($in_value, $width = '120') {
        
        $output = "";
        $additionDesc = "";
        $value = htmlspecialchars($in_value, ENT_QUOTES);// chiu add
        if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_MANDATORY__)
          $additionDesc = "<span class='mandatory_star'>*</span>";

        if(is_array($this->UT_Value->desc))
          $this->UT_Value->desc = $this->UT_Value->desc[1];
        else
          $this->UT_Value->desc = $this->UT_Value->desc;

        switch (true) {
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_INPUTBOX__):
            switch (true) {
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_HIDDEN__):
                $output .= "<input type=hidden name=" . $this->UT_Value->DBField . $additionDesc . " id=" . $this->UT_Value->DBField . $additionDesc . " value='" . $value . "'>\r\n";
                break;
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__):
                if (is_array($this->UT_Value->default))
                  $tmp_value = sprintf($this->UT_Value->default[1], $value);
                else
                  $tmp_value = $value;

                $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . "</th>\r\n";
                $output .= "    <td>" . $tmp_value . "</td>\r\n";
                $output .= "    <input type=hidden name=" . $this->UT_Value->DBField . $additionDesc . " id=" . $this->UT_Value->DBField . $additionDesc . " value='$value'>\r\n";
                $output .= "</tr>\r\n";
                break;
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_PRIMARYKEY__):
                if ($value == "") {
                  $value = "--";
                }
                $output .= "<tr><th width=" . $width . "><span class='css_pk'>" . $this->UT_Value->desc . $additionDesc . "</span></th>\r\n";
                $output .= "    <td><span class='css_pk'>" . $value . "</span></td>\r\n";
                $output .= "    <input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='$value'>\r\n";
                $output .= "</tr>\r\n";
                break;
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_AUTOINCREMENT__):
                if ($value == "") {
                  $value = "##########";  // if no default value, use the 10 digit value
                }

                $output .= "<tr><th width=" . $width . "><span class='css_pk'>" . $this->UT_Value->desc . $additionDesc . "</span></th>\r\n";
                $output .= "    <td><span class='css_pk'>" . $value . "</span></td>\r\n";
                $output .= "    <input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='$value'>\r\n";
                $output .= "</tr>\r\n";
                break;
              default:
                if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_AUTOCOMPLETE__) {
                  $output .= "<script type='text/javascript'>\r\n";
                  $output .= "    $(function() {\r\n";
                  $output .= "      $( '#" . $this->UT_Value->DBField . "' ).autocomplete({\r\n";
                  $output .= "        source: 'search.php', minLength: 2, select: function(event,ui) {}\r\n";
                  $output .= "      });\r\n";
                  $output .= "    });\r\n";
                  $output .= "</script>\r\n";
                }

                $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
                $output .= "    <td><input type=text name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='" . $value . "' maxlength=" . $this->UT_Value->len . "><div id=AA_" . $this->UT_Value->DBField . "></div></td>\r\n";
                $output .= "</tr>\r\n";
                break;
            }
            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_TEXTBOX__):
            switch (true) {
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_HIDDEN__):
                break;
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__):
                $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
                $output .= "    <td>" . $in_value . "</td>\r\n";
                $output .= "</tr>\r\n";
                break;
              default:
                $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
                $output .= "    <td><textarea name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . ">" . $value . "</textarea></td>\r\n";
                $output .= "</tr>\r\n";
                break;
            }

            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATETIME__):
            switch (true) {
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_HIDDEN__):
                $output .= "<input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='$value'>\r\n";
                break;
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__):
                // $value = $this->PRI_date($value);

                $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
                $output .= "    <td>" . $this->PRI_date($value) . "</td>\r\n";
                $output .= "    <input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='" . $this->PRI_date($value). "'>\r\n";
                $output .= "</tr>\r\n";
                break;
              default:
                $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
                $output .= "    <td><input type=text name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='" . $this->PRI_date($value) . "' maxlength=" . $this->UT_Value->len . ">\r\n";

                $output .= "    <script language='javascript'>\r\n";
                $output .= "      $(document).ready(function(){\r\n";
                $output .= "       $( '#".$this->UT_Value->DBField."' ).datepicker({ dateFormat: 'yy-mm-dd' });\r\n";
                $output .= "      })\r\n";
                $output .= "    </script>\r\n";

                $output .= "    </td>\r\n";
                $output .= "</tr>\r\n";
                break;
            }
            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATESTR__):
            switch (true) {
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_HIDDEN__):
                $output .= "<input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='$value'>\r\n";
                break;
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__):
                if($value){
                  $date_arr = explode(' ', $value);
                }

                switch ($this->UT_Value->extra) {
                  case "DT":
                    break;
                  case "D":
                    $value = $date_arr[0];
                    break;
                  case "T":
                    $value = $date_arr[1];
                    break;
                }

                $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
                $output .= "    <td>" . $value . "</td>\r\n";
                $output .= "    <input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='" . $value . "'>\r\n";
                $output .= "</tr>\r\n";
                break;
              default:
                list($date, $time) = explode(' ', $value);

                switch ($this->UT_Value->extra) {
                  case "DT":
                    
                    $js_picker .= "var tmp_".$this->UT_Value->DBField." = $('#".$this->UT_Value->DBField."');\r\n";
                    $js_picker .= "tmp_".$this->UT_Value->DBField.".datetimepicker({ dateFormat: 'yy-mm-dd', timeFormat: 'hh:mm tt' } );\r\n";
                    break;

                  case "D":
                    $value = $date;
                    $js_picker .= "$( '#".$this->UT_Value->DBField."' ).datepicker({ dateFormat: 'yy-mm-dd' });\r\n";
                    break;

                  case "T":
                    $value = $time;
                    $js_picker .= "$( '#".$this->UT_Value->DBField."' ).timepicker({ timeFormat: 'hh:mm tt' });\r\n";
                    break;

                  default:
                    $js_picker .= "$( '#".$this->UT_Value->DBField."' ).datepicker({ dateFormat: 'yy-mm-dd' });\r\n";
                  break;

                }
                $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
                $output .= "    <td><input type=text name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='" . $value . "' maxlength=" . $this->UT_Value->len . ">\r\n";
               
                $output .= "    <script language='javascript'>\r\n";
                $output .= "      $(document).ready(function(){\r\n";

                $output .= $js_picker;
//                $output .= "       $( '#".$this->UT_Value->DBField."' ).datepicker({ dateFormat: 'yy-mm-dd' });\r\n";

                $output .= "      })\r\n";
                $output .= "    </script>\r\n";

                $output .= "    </td>\r\n";
                $output .= "</tr>\r\n";

                break;
         }
         break;

          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_CHECKBOX__):
            switch (true) {
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_FOREIGNKEY__):
                $tmpArray = $this->PRI_loadDBValue_selection($value);

                break;
              default:
                $tmpArray = $this->UT_Value->extra;
                break;
            }
            $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "<input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='" . $value . "'></th>\r\n";
            $output .= "    <td>\r\n";
            $output .= "    <script language=javascript>\r\n";
            $output .= "    <!--\r\n";
            $output .= "      function UT_cal_" . $this->UT_Value->DBField . "(value, bFlag) {\r\n";
            $output .= "        var tmp=parseInt(document.forms[0]." . $this->UT_Value->DBField . ".value);\r\n";
            $output .= "        if (bFlag)\r\n";
            $output .= "          tmp = parseInt(document.forms[0]." . $this->UT_Value->DBField . ".value) + parseInt(value);\r\n";
            $output .= "        else\r\n";
            $output .= "          tmp = parseInt(document.forms[0]." . $this->UT_Value->DBField . ".value) - parseInt(value);\r\n";
            $output .= "        document.forms[0]." . $this->UT_Value->DBField . ".value = tmp;\r\n";
            if (DEBUG)
              $output .= "        alert(document.forms[0]." . $this->UT_Value->DBField . ".value);\r\n";
            $output .= "      }\r\n";
            $output .= "    //-->\r\n";
            $output .= "    </script>\r\n";

            $output .= "    <table style='border-collapse:collapse;border:0px solid #ffffff'>\r\n";
            foreach($tmpArray  as $i => $selection) {
              $tmpValue = pow(2, $i);
              if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__) {
                if ($value & $tmpValue)
                  $output .= "    <tr><td>" . $selection . "</td></tr>\r\n";
              }
              else {
                if ($value & $tmpValue)
                  $output .= "    <tr><td><input type=checkbox name=" . $this->UT_Value->DBField . $i . " value=" . $tmpValue . " checked onclick='UT_cal_" . $this->UT_Value->DBField . "(" . $tmpValue . ", document.forms[0]." . $this->UT_Value->DBField . $i . ".checked)'>" . $selection . "\r\n";
                else
                  $output .= "    <tr><td><input type=checkbox name=" . $this->UT_Value->DBField . $i . " value=" . $tmpValue . " onclick='UT_cal_" . $this->UT_Value->DBField . "(" . $tmpValue . ", document.forms[0]." . $this->UT_Value->DBField . $i . ".checked)'>" . $selection . "\r\n";
              }
            }
            $output .= "</table></td>\r\n";
            $output .= "</tr>\r\n";
            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_RADIO__):
            $output .= "<th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
            $output .= "    <td>\r\n";
            foreach($this->UT_Value->extra as $i => $selection) {
              if ($i == $value)
                $output .= "    <input type=radio name=" . $this->UT_Value->DBField . "  value=$i checked>" . $selection . "\r\n";
              else
                $output .= "    <input type=radio name=" . $this->UT_Value->DBField . "  value=$i>" . $selection . "\r\n";
            }
            $output .= "</td>\r\n";
            $output .= "</tr>\r\n";
            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_SELECTION__):
            switch (true) {
              /*******************************************************/
              /********** Selection & Master Detail (START) **********/
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_AUTOCOMPLETE__):
                $output .= "<script type='text/javascript' charset='utf-8'>\r\n";
                $output .= "  $(function(){\r\n";
                $output .= "    $( '#" . $this->UT_Value->DBField . "_autocomplete' ).autocomplete({\r\n";

                $output .= "      source: function(request, response) {\r\n";

                $output .= "        $.ajax({\r\n";
                $output .= "          url: 'SYSTEM_ajax_autocomplete.php',\r\n";
                $output .= "          dataType: 'json',\r\n";
                $output .= "          data: {\r\n";
                $output .= "            term : request.term, \r\n";
                $output .= "            currField : '" . $this->UT_Value->DBField . "', \r\n";
                $output .= "            currFile : '" . $_SERVER["SCRIPT_FILENAME"] . "' \r\n";
                $output .= "          },\r\n";
                $output .= "          success: function(data) {\r\n";
                $output .= "            response(data);\r\n";
                $output .= "          }\r\n";
                $output .= "        });\r\n";

                $output .= "      }, \r\n";
                $output .= "      minLength: 2, \r\n";
                $output .= "      select: function(event,ui) {\r\n";
                $output .= "        $( '#" . $this->UT_Value->DBField . "').val(ui.item.id).change();;\r\n";
                $output .= "      }\r\n";
                $output .= "    });\r\n";

                $output .= "  });\r\n";
                $output .= "</script>\r\n";

                $tmpArray = $this->PRI_loadDBValue_selection($value);

                break;
              /********** Selection & Master Detail (START) **********/
              /*******************************************************/


              /*******************************************************/
              /********** Selection & Master Detail (START) **********/
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_MASTERDETAIL_REF__ && $this->UT_Value->option & __UT_TEMPLATE_OPTION_FOREIGNKEY__):
                $output .= "<script type='text/javascript' charset='utf-8'>\r\n";
                $output .= "  $(function(){\r\n";

                $output .= "    function ajaxUpdateChildRec_" . $this->UT_Value->DBField . "() {\r\n";
                $output .= "      $.getJSON('./SYSTEM_ajax_select_master.php',{'currField': '" . $this->UT_Value->DBField . "', 'currID': $('#" . $this->UT_Value->extra->masterField["CSS_ID"] . "').val(), 'currFile': '" . $_SERVER["SCRIPT_FILENAME"] . "'}, function(j){\r\n";
                $output .= "        var options = '';\r\n";
              $output .= "          options += '<option value=\"0\"> -- " . $this->UT_Value->DBField . " -- </option>';\r\n";
                $output .= "        for (var i = 0; i < j.length; i++) {\r\n";
                $output .= "          options += '<option value=\"' + j[i].optionValue + '\">' + j[i].optionDisplay + '</option>';\r\n";
                $output .= "        }\r\n";
                $output .= "        $('#" . $this->UT_Value->DBField . "').html(options);\r\n";

                if ($value == "")
                  $output .= "        $('#" . $this->UT_Value->DBField . " option:first').attr('selected', 'selected');\r\n";
                else
                  $output .= "        $('#" . $this->UT_Value->DBField . " option[value=" . $value . "]').attr('selected', 'selected');\r\n";

                $output .= "      })\r\n";
                $output .= "    }\r\n";
                $output .= "    ajaxUpdateChildRec_" . $this->UT_Value->DBField . "()\r\n";
                $output .= "    $('#" . $this->UT_Value->extra->masterField["CSS_ID"] . "').change(function(){\r\n";
                $output .= "      ajaxUpdateChildRec_" . $this->UT_Value->DBField . "()\r\n";
                $output .= "    })\r\n";
                $output .= "  })\r\n";
                $output .= "</script>\r\n";

                $tmpArray = array();
                
                break;
              /********** Selection & Reload (END) **********/
              /*******************************************************/


              /*******************************************************/
              /********** Selection & Foreignkey (START) **********/
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_FOREIGNKEY__):
                $tmpArray = $this->PRI_loadDBValue_selection($value);

                break;
              /********** Selection & Foreignkey (END) **********/
              default:
                $tmpArray = $this->UT_Value->extra;
                break;
            }

            $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";

            if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_AUTOCOMPLETE__) {
                $output .= "    <td>\r\n";
                $output .= "      <input type=hidden name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='" . $value . "' maxlength=" . $this->UT_Value->len . ">\r\n";
                $output .= "      <input type=text name=" . $this->UT_Value->DBField . "_autocomplete id=" . $this->UT_Value->DBField . "_autocomplete value='" . $tmpArray[$value] . "' maxlength=" . $this->UT_Value->len . ">\r\n";
                $output .= "      <div id=AA_" . $this->UT_Value->DBField . "></div></td>\r\n";
                $output .= "</tr>\r\n";
            }
            else {
              $output .= $this->PRI_constructDBValue_selection($tmpArray, $value);
            }

            $output .= "</tr>\r\n";
            /********** Selection & NOT Readonly (END) ***********/

            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_PASSWORD__):
            if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_MD5_PASSWORD__) {
              $output .= "    <input type=hidden name=" . $this->UT_Value->DBField . "_MD5_Changed id=" . $this->UT_Value->DBField . "_MD5_Changed value=0>\r\n";

              $this->Validation .= "if( $('#". $this->UT_Value->DBField . "').val() !=  \"" . $value . "\" ){ $('#". $this->UT_Value->DBField . "_MD5_Changed').val('1'); }\r\n";// let program know it changed or not

            }
            $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
            $output .= "    <td><input type=password name=" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . " value='".$value."' size=30 maxlength=" . $this->UT_Value->len . "></td>\r\n";
            $output .= "</tr>\r\n";
            $output .= "<tr><th width=" . $width . ">Re-Type " . $this->UT_Value->desc . $additionDesc . "<span class='mandatory_star'>*</span></th>\r\n";
            $output .= "    <td><input type=password name=" . $this->UT_Value->DBField . "2 id=" . $this->UT_Value->DBField . "2 value='".$value."' size=30 maxlength=" . $this->UT_Value->len . "></td>\r\n";
            $output .= "</tr>\r\n";


            $this->Validation .= "if( ($('#". $this->UT_Value->DBField . "').val() != $('#". $this->UT_Value->DBField . "2').val() ) || $('#". $this->UT_Value->DBField . "').val()=='' ){\r\n";
            $this->Validation .= "  $('#". $this->UT_Value->DBField . "').focus();\r\n";
            $this->Validation .= "  alert('Password not match');\r\n";
            $this->Validation .= "  return false;\r\n";
            $this->Validation .= "};\r\n\r\n";


            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_FILE__):

            switch (true) {
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_IMG__):
                $tFileType = "IMAGE"; // for detect resize
                break;

              default:
                $tFileType = "FILE";

            }

            
            //$UTValue["Image"] = new UT_Template;
            //  $UTValue["Image"]->set_var("Image", "Image", 60, 100, "", 1, 256, 16, array("../uploadFolder/news/", "['jpg', 'jpeg', 'gif', 'png']", "5000000", "215", "143"));

            if($this->UT_Value->extra[1]!='')
              $tExt = $this->UT_Value->extra[1];
            else
              $tExt ="[]";

            if($this->UT_Value->extra[2]!='')
              $tSizeLimit = $this->UT_Value->extra[2];
            else
              $tSizeLimit ="0";

            $output .= "<tr><th width=" . $width . ">" . $this->UT_Value->desc . $additionDesc . "</th>\r\n";
            $output .= "  <td>";
            $output .= "    <div id='VIEW_".$this->UT_Value->DBField."'></div><br>";

            ## upload plugin here
            $output .=  "<input type='hidden' name='".$this->UT_Value->DBField."' id='".$this->UT_Value->DBField."' value='" . $value . "' maxlength=" . $this->UT_Value->len . " readonly>
                        <div id='UL_".$this->UT_Value->DBField."'>\r\n
                          <noscript>\r\n
                            <p>Please enable JavaScript to use file uploader.</p>\r\n
                          </noscript>\r\n
                        </div>\r\n
                
                        <script>
                          tValue = '".$value."';
                          if(tValue!='')
                            YCC_Ajax_File('" . $this->UT_Value->extra[0] . $value . "', '" . $this->UT_Value->DBField . "', '" . $tFileType . "');

                          var ".$this->UT_Value->DBField."_uploader = new qq.FileUploader({
                              element: document.getElementById('UL_".$this->UT_Value->DBField."'),
                              action: './SYSTEM_ajax_upload.php?ACTION=UPLOAD&currFile=" . $_SERVER["SCRIPT_FILENAME"] . "&currField=" . $this->UT_Value->DBField . "', // obj is not use yet 
                              sizeLimit: ".$tSizeLimit.",
                              debug: false,
                              allowedExtensions: ".$tExt.",
                              onSubmit: function(id, fileName){},
                              onProgress: function(id, fileName, loaded, total){},
                              onComplete: function(id, fileName, responseJSON){ 
                                if(responseJSON['realFileName']){
                                  document.getElementById('".$this->UT_Value->DBField."').value  = responseJSON['realFileName'];
                                }
                                if(responseJSON['uploadFileType']){
                                  YCC_Ajax_File('" . $this->UT_Value->extra[0] . "' + responseJSON['realFileName'], '" . $this->UT_Value->DBField . "', '" . $tFileType . "');
                                }
                              },\r\n
                              onCancel: function(id, fileName){},
                              params: {uploadFileType: '".$tFileType."', fieldName: '".$this->UT_Value->DBField."', imgW: '".$this->UT_Value->extra[3]."', imgH: '".$this->UT_Value->extra[4]."', imgTW: '".$this->UT_Value->extra[5]."', imgTH: '".$this->UT_Value->extra[6]."'}
                          });


  $(document).ready(function(){
    $('#REMOVE_" . $this->UT_Value->DBField . "').live('click', function() {
      $('body').append(\"<div id='REMOVE_dialog_confirm' title='Remove File'><span class='ui-icon ui-icon-alert' style='float:left; margin:0 7px 0px 0;'></span>Do you want to <b>REMOVE</b> this file?</div>\");

      currFileName = $('#" . $this->UT_Value->DBField  . "').val();

      $('#REMOVE_dialog_confirm').dialog({
        resizable: false,
        height:140,
        modal: true,
        close: function(ev, ui) { $(this).remove(); },
        buttons: {
          'Remove': function() {
            $.post('./SYSTEM_ajax_upload.php', { ACTION:'REMOVE', currFile:'" . $_SERVER["SCRIPT_FILENAME"] . "', currField:'" . $this->UT_Value->DBField . "', currFileName:currFileName},
              function(data) {
                if(data==1){
                  $('#VIEW_" . $this->UT_Value->DBField . "').html('');// clear image div
                  $('#" . $this->UT_Value->DBField . "').val(''); // hidden field
                  alert('File removed!');
                } else {
                  alert('Cannot remove file!');
                }
              });// end post
            $(this).remove();
          },
          Cancel: function() {
            $( this ).dialog('close');
          }
        }
      });//end dialog

    });// end remove file
  });

                      </script>\r\n";

            $output .= "  </td>\r\n";
            $output .= "</tr>\r\n";
            break;
        }

        return $output;
     }


      function searchInputBox($value) {
        $output = "";
        $output .= "<td><input type=text name=UT_SCH_" . $this->UT_Value->DBField . " id=UT_SCH_" . $this->UT_Value->DBField . " value='" . $value . "' size=20 maxlength=" . $this->UT_Value->len . "></td>\r\n";
        return $output;
      }

      function searchDate($value) {
        $output = "";

        $output .= "<td>\r\n";
        $output .= "<select name=UT_SCH_" . $this->UT_Value->DBField . "_Cond><option value=1><</option><option value=2>=</option><option value=3>></option>\r\n";
        $output .= "<input type=text name=UT_SCH_" . $this->UT_Value->DBField . " value='" . $this->PRI_date($value) . "' size=30 maxlength=" . $this->UT_Value->len . ">\r\n";
        $output .= "<script language='javascript'>\r\n";
        $output .= "<!--\r\n";
        $output .= "if (!document.layers) {\r\n";
        $output .= "  document.write(\"<input type=button onclick='showCalendar(this, UT_INPUTFORM.UT_SCH_" . $this->UT_Value->DBField . ", \\\"yyyy-mm-dd\\\",null,1)' value='select' style='font-size:11px'>\")\r\n";
        $output .= "}\r\n";
        $output .= //-->\r\n";
        $output .= "</script>\r\n";
        $output .= "</span></td>\r\n";

        return $output;
      }

      function searchSelection($value) {
        $output = "";

        if ($value == "")
          $value = $this->UT_Value->default;

        switch (true) {
          case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_MASTERDETAIL_REF__):
          case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_FOREIGNKEY__):
            $output .= "<script type='text/javascript' charset='utf-8'>\r\n";
            $output .= "  $(function(){\r\n";
            $output .= "    $('#UT_SCH_" . $this->UT_Value->extra->masterField . "').change(function(){\r\n";
            $output .= "      $.getJSON('./SYSTEM_ajax_select_master.php',{'currField': '" . $this->UT_Value->DBField . "', 'currID': $('#UT_SCH_" . $this->UT_Value->extra->masterField . "').val(), 'currFile': '" . $_SERVER["SCRIPT_FILENAME"] . "'}, function(j){\r\n";
            $output .= "        var options = '';\r\n";
            $output .= "        for (var i = 0; i < j.length; i++) {\r\n";
            $output .= "          options += '<option value=\"' + j[i].optionValue + '\">' + j[i].optionDisplay + '</option>';\r\n";
            $output .= "        }\r\n";
            $output .= "        $('#UT_SCH_" . $this->UT_Value->DBField . "').html(options);\r\n";
            $output .= "        $('#UT_SCH_" . $this->UT_Value->DBField . " option:first').attr('selected', 'selected');\r\n";
            $output .= "      })\r\n";
            $output .= "    })\r\n";
            $output .= "  })\r\n";
            $output .= "</script>\r\n";

            $tmpArray = $this->PRI_loadDBValue_selection($value);
            
            break;
          case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_FOREIGNKEY__):
            $tmpArray = $this->PRI_loadDBValue_selection($value);

            break;
          default:
            $tmpArray = $this->UT_Value->extra;
            break;
        }
            $output .= "<script type='text/javascript' charset='utf-8'>\r\n";
            $output .= "  $(function(){\r\n";
            $output .= "    $('#UT_SCH_" . $this->UT_Value->extra->masterField . "').change(function(){\r\n";
            $output .= "      $.getJSON('./SYSTEM_ajax_select_master.php',{'currField': '" . $this->UT_Value->DBField . "', 'currID': $('#UT_SCH_" . $this->UT_Value->extra->masterField . "').val(), 'currFile': '" . $_SERVER["SCRIPT_FILENAME"] . "'}, function(j){\r\n";
            $output .= "        var options = '';\r\n";
            $output .= "        for (var i = 0; i < j.length; i++) {\r\n";
            $output .= "          options += '<option value=\"' + j[i].optionValue + '\">' + j[i].optionDisplay + '</option>';\r\n";
            $output .= "        }\r\n";
            $output .= "        $('#UT_SCH_" . $this->UT_Value->DBField . "').html(options);\r\n";
            $output .= "        $('#UT_SCH_" . $this->UT_Value->DBField . " option:first').attr('selected', 'selected');\r\n";
            $output .= "      })\r\n";
            $output .= "    })\r\n";
            $output .= "  })\r\n";
            $output .= "</script>\r\n";

        $output .= "<td><select name=UT_SCH_" . $this->UT_Value->DBField . " id=" . $this->UT_Value->DBField . ">\r\n";
        if ($tmpArray[0] == "")
          $output .= "    <option value=0>-- " . $this->UT_Value->desc . " --</option>\r\n";

        foreach($tmpArray as $i => $selection) {
/*
          if ($i == $value)
            $output .= "    <option value=$i selected>" . $selection . "</option>\r\n";
          else
*/
            $output .= "    <option value=$i>" . $selection . "</option>\r\n";
        }
        $output .= "</select>\r\n";
        $output .= "</td>\r\n";

        return $output;
      }


      function listingSearch() {
        $Output = "";

        if ($this->UT_Value->listType & __UT_TEMPLATE_LISTTYPE_SEARCH__) {
          if (is_array($this->UT_Value->desc)) {
            $Output .= "<th>" . $this->UT_Value->desc[0] . " :</th>\r\n";
          }else{
            $Output .= "<th>" . $this->UT_Value->desc . " :</th>\r\n";
          }

          $value = $_GET["UT_SCH_" . $this->UT_Value->DBField];
          switch (true) {
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_INPUTBOX__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_TEXTBOX__):
              $Output .= $this->searchInputBox($value);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATETIME__):
              $Output .= $this->searchDate($value);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATESTR__):
              list($date, $time) = preg_split(' ', $value);

              switch ($this->UT_Value->extra) {
                case "DT":
                  break;
                case "D":
                  $value = $date;
                  break;
                case "T":
                  $value = $time;
                  break;
              }
              $Output .= $this->listInputBox($value);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_SELECTION__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_CHECKBOX__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_RADIO__):
              $Output .= $this->searchSelection($value);
              break;
          }
        }

        return $Output;
      }

      // *******************************************************************
      // * Searching 
      // *******************************************************************
      function listSearchValue() {
        $Output = "";

        if (($this->UT_Value->listType & __UT_TEMPLATE_LISTTYPE_SEARCH__) &&
            ($_GET["UT_SCH_" . $this->UT_Value->DBField] != "")) {
          switch (true) {
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_INPUTBOX__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_TEXTBOX__):
              if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_PRIMARYKEY__)
                $Output .=  $this->UT_Value->DBField . "=" . $_GET["UT_SCH_" . $this->UT_Value->DBField];
              else
                $Output .=  $this->UT_Value->DBField . " like '%" . $_GET["UT_SCH_" . $this->UT_Value->DBField] . "%'";
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATETIME__):
              if ($_GET["UT_SCH_" . $this->UT_Value->DBField] != "")
                $Output .=  $this->UT_Value->DBField . " like '%" . $_GET["UT_SCH_" . $this->UT_Value->DBField] . "%'";

              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATESTR__):
              list($date, $time) = preg_split(' ', $value);

              switch ($this->UT_Value->extra) {
                case "DT":
                  break;
                case "D":
                  $value = $date;
                  break;
                case "T":
                  $value = $time;
                  break;
              }
              $Output .= $this->listInputBox($value);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_SELECTION__):
              if ($this->UT_Value->editType & __UT_TEMPLATE_OPTION_FOREIGNKEY__) {
                if ($_GET["UT_SCH_" . $this->UT_Value->DBField] != 0) {
                  $Output .=  $this->UT_Value->DBField . " = '" . $_GET["UT_SCH_" . $this->UT_Value->DBField] . "'";
                }
              }
              else {
                $Output .=  $this->UT_Value->DBField . " = '" . $_GET["UT_SCH_" . $this->UT_Value->DBField] . "'";
              }
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_CHECKBOX__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_RADIO__):
              break;
          }
        }

        return $Output;
      }


      // *******************************************************************
      // * Listing 
      // *******************************************************************
      //chiu add
      function addDiv($element, $div_id){
        $tmp = "<div id='".$this->UT_Value->DBField."_".$div_id."' class='".$this->UT_Value->DBField."'>".$element."</div>";
        return $tmp;
      }

      function listInputBox($value, $div_id="") {
        if($div_id!="")
          return ("<td>" . $this->addDiv($value, $div_id) . "</td>\r\n");
        else
        return ("<td>" . $value . "</td>\r\n");
      }

      function listTextBox($value, $div_id="") {
        $value = substr($value, 0, $this->UT_Value->len);

        if($div_id!="")
          return ("<td>" . $this->addDiv($value, $div_id) . "</td>\r\n");
        else
        return ("<td>" . $value . "</td>\r\n");
      }

      function listDate($value, $div_id="") {
        $value = $this->PRI_date($value);
        
        if($div_id!="")
          return ("<td>" . $this->addDiv($value, $div_id) . "</td>\r\n");
        else
        return ("<td>" . $value  . "</td>\r\n");
      }

      function listSelection($value, $div_id="") {

        switch (true) {
          case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_FOREIGNKEY__):
            $db = new DB;

            if (is_array($this->UT_Value->extra->value)) {
              $i = 0;

              foreach($this->UT_Value->extra->value as $index => $dbValue) {
                if ($i++ == 0)
                  $sqlValue = "concat(" . $dbValue;
                else
                  $sqlValue .= ", ' ', " . $dbValue;
              }
              $sqlValue .= ") as UT_SELECTION_VALUE";
            }
            else {
              $sqlValue = $this->UT_Value->extra->value . " as UT_SELECTION_VALUE";
            }

            $tmpValue = "";
            $sqlstr = "select " . $sqlValue . " from " . $this->UT_Value->extra->table . " where " . $this->UT_Value->extra->key . "='" . htmlspecialchars($value,  ENT_QUOTES) . "'";
            $db->query($sqlstr);

            while ($db->next_record()) {
//              if ($tmpValue == "")
                $tmpValue .= $db->f("UT_SELECTION_VALUE");
//              else
//                $tmpValue .= ", " . $db->f("UT_SELECTION_VALUE");
            }

            if (($this->UT_Value->option & __UT_TEMPLATE_OPTION_LINK__) && ($this->UT_Value->extra->clickButton != "")) {
              $tmpStyle = "style a:link='color: orange'";
              $tmpValue = "<a style='color: red' href='" . $this->UT_Value->extra->clickButton . LIB_removeGETinput(array('mode', 'id'), true) . "&UT_SCH_id=" . $value . "'>" . $tmpValue . "</a>";
            }

            if($div_id!="")
               return ("<td>" . $this->addDiv($tmpValue, $div_id) . "</td>\r\n");
            else
               return ("<td>" . $tmpValue . "</td>\r\n");

            break;
          case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_RELOAD__):
          default:
            $selection = $this->UT_Value->extra[$value];
            while(is_array($selection)) {
              $selection = $selection[0];
            }

           if($div_id!="")
             return ("<td>" . $this->addDiv($selection, $div_id) . "</td>\r\n");
           else
             return ("<td>" . $selection . "</td>\r\n");
        }
      }
    
      function listCheckbox($value, $div_id="") {
        switch (true) {
          case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_FOREIGNKEY__):
            $db = new DB;

            if (is_array($this->UT_Value->extra->value)) {
              $i = 0;

              foreach($this->UT_Value->extra->value as $index => $dbValue) {
                if ($i++ == 0)
                  $sqlValue = "concat(" . $dbValue;
                else
                  $sqlValue .= ", ' ', " . $dbValue;
              }
              $sqlValue .= ") as UT_SELECTION_VALUE";
            }
            else {
              $sqlValue = $this->UT_Value->extra->value . " as UT_SELECTION_VALUE";
            }

            $tmpValue = "";
            $sqlstr = "select " . $sqlValue . " from " . $this->UT_Value->extra->table . " where pow(2," . $this->UT_Value->extra->key . ")  & '" . htmlspecialchars($value,  ENT_QUOTES) . "'";
            $db->query($sqlstr);
            
            while ($db->next_record()) {
                $tmpValue .= $db->f("UT_SELECTION_VALUE") . "<BR>";
            }

            if (($this->UT_Value->option & __UT_TEMPLATE_OPTION_LINK__) && ($this->UT_Value->extra->clickButton != "")) {
              $tmpStyle = "style a:link='color: orange'";
              $tmpValue = "<a style='color: red' href='" . $this->UT_Value->extra->clickButton . LIB_removeGETinput(array('mode', 'id'), true) . "&UT_SCH_id=" . $value . "'>" . $tmpValue . "</a>";
            }

            if($div_id!="")
               return ("<td>" . $this->addDiv($tmpValue, $div_id) . "</td>\r\n");
            else
               return ("<td>" . $tmpValue . "</td>\r\n");

            break;
          case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_RELOAD__):
          default:
            foreach($this->UT_Value->extra as $tmpID => $tmpValue) {
              if ($value & pow(2, $tmpID)) {
                $selection .= $tmpValue . "<BR>";
              }
            }
/*
            while(is_array($selection)) {
              $selection = $selection[0];
            }
*/
           if($div_id!="")
             return ("<td>" . $this->addDiv($selection, $div_id) . "</td>\r\n");
           else
             return ("<td>" . $selection . "</td>\r\n");
        }
      }
    

      function listFile($value, $div_id="") {
        if($value){
          $path_parts = pathinfo($value);
          $tImg = $this->fileImage($path_parts['extension']);
        }

        if ($value && file_exists($this->UT_Value->extra[0] . "thumbs/" . $value) && ( $this->UT_Value->option & __UT_TEMPLATE_OPTION_IMG__ ) ){
          $tImg = "<img src='" . $this->UT_Value->extra[0] . "thumbs/" . $value . "'>";
          return ("<td><a href='" . $this->UT_Value->extra[0] . $value . "' target=blank class='jPreview'>".$tImg."</a></td>\r\n");
        }else  if ($value && file_exists($this->UT_Value->extra[0] . $value) && ( $this->UT_Value->option & __UT_TEMPLATE_OPTION_IMG__ ) ){
          return ("<td><a href='" . $this->UT_Value->extra[0] . $value . "' target=blank class='jPreview'>".$tImg."</a></td>\r\n");
        }

        if ($value && file_exists($this->UT_Value->extra[0] . $value)){
          return ("<td><a href='" . $this->UT_Value->extra[0] . $value . "' target=blank>".$tImg."</a></td>\r\n");
        }else
          return ("<td>&nbsp;</td>\r\n");
      }

      // __UT_TEMPLATE_EDITTYPE_BUTTON__
      function listButton($value, $div_id="") {
        $retVal = "";

        if ($value) {
          if ($this->UT_Value->desc != "")
            $tmpDesc = $this->UT_Value->default;
          else
            $tmpDesc = "Click";

          switch($value[1]) {
            case __UT_MODE_NEW__:
              $retVal = "<td><input  value='" . $tmpDesc . "' type='button' onclick='window.open(\"./" . $value[0] . LIB_removeGETinput(array('mode', 'id', 'abc'), true) . "&mode=" . $value[1] . "&" . $value[2] . "=" . $div_id . "\");'></td>";
              break;
            case __UT_MODE_VIEW__:
              $retVal = "<td><input  value='" . $tmpDesc . "' type='button' onclick='window.open(\"./" . $value[0] . LIB_removeGETinput(array('mode', 'id', 'abc'), true) . "&UT_SCH_" . $value[2] . "=" . $div_id . "\");'></td>";
              break;
          }

        } else {
          $retVal = "<td>&nbsp;</td>\r\n";
        }

        return ($retVal);
      }

      function listingHeader($sort, $listFile, $adminpath, $page, $order, $direction=false) {
        $Output = "";
        $neworder = __UT_TEMPLATE_DIRECTION_DESCENDING__;// -1
        if ($order == '')
          $UT_ORDER = __UT_TEMPLATE_DIRECTION_DESCENDING__;//-1

        if ($this->UT_Value->listType & __UT_TEMPLATE_LISTTYPE_SHOW__) {
          if ($direction) {
            if ($order == __UT_TEMPLATE_DIRECTION_DESCENDING__) {
              $neworder = __UT_TEMPLATE_DIRECTION_ASCENDING__;
              $tmp = " <img src='./assets/images/table/sort_down.png' border=0>";
            }
            else {
              $tmp .= " <img src='./assets/images/table/sort_up.png' border=0>";
            }
          }

          $otheInput = "";
          foreach($_GET as $i => $value) {
            if (($i != "UT_SORT") && ($i != "UT_PAGE") && ($i != "UT_ORDER")) 
              $otheInput .= "&" . $i . "=" . $value;
          }

          if (!($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_BUTTON__) || ($this->UT_Value->listType & __UT_TEMPLATE_LISTTYPE_SORT__)) {
            if(is_array($this->UT_Value->desc)){// list and edit different display
              $Output = "<th width=" . $this->UT_Value->width . "><a href='" . basename($_SERVER['SCRIPT_NAME']) . "?UT_SORT=" . $sort . "&UT_ORDER=" . $neworder . $otheInput . "'>" . $this->UT_Value->desc[0];
            }else{
              $Output = "<th width=" . $this->UT_Value->width . "><a href='" . basename($_SERVER['SCRIPT_NAME']) . "?UT_SORT=" . $sort . "&UT_ORDER=" . $neworder . $otheInput . "'>" . $this->UT_Value->desc;
            }
            $Output .= $tmp . "</a></th>\r\n";
          }
          else {
            if (is_array($this->UT_Value->desc)) 
              $Output = "<th width=" . $this->UT_Value->width . ">" . $this->UT_Value->desc[0] . "</th>";
            else
              $Output = "<th width=" . $this->UT_Value->width . ">" . $this->UT_Value->desc . "</th>";
          }

        }
        return $Output;
      }

      function listingValue($value, $div_id="") {
        $ret = "";

        if (is_array($this->UT_Value->default))
          $value = sprintf($this->UT_Value->default[1], $value);

        if ($this->UT_Value->listType & __UT_TEMPLATE_LISTTYPE_SHOW__) {
          switch (true) {
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_INPUTBOX__):
              $ret = $this->listInputBox($value, $div_id);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_TEXTBOX__):
              $ret = $this->listTextBox($value, $div_id);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATETIME__):
              $ret = $this->listDate($value, $div_id);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATESTR__):
              list($date, $time) = explode(' ', $value);

              switch ($this->UT_Value->extra) {
                case "DT":
                  break;
                case "D":
                  $value = $date;
                  break;
                case "T":
                  $value = $time;
                  break;
              }
              $ret = $this->listInputBox($value, $div_id);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_SELECTION__):
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_RADIO__):
              $ret = $this->listSelection($value, $div_id);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_CHECKBOX__):
              $ret = $this->listCheckbox($value, $div_id);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_FILE__):
              $ret = $this->listFile($value, $div_id);
              break;
            case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_BUTTON__):
              $ret = $this->listButton($value, $div_id);
              break;
          }
        }
        return ($ret);
      }

      // *******************************************************************
      // * saveDBValue 
      // *******************************************************************

      function saveDBValue($value) {
        //$value = addslashes($value);
        global $id;
        $output = "";

        switch (true) {
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_INPUTBOX__):
            $output = "'" . str_replace("'", "\'", $value) . "'";// if here addslashes,
//            $output = "'" . $value . "'";
            break;

          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_TEXTBOX__):
              $output = "'" . $value . "'";
//              $output = "'" . str_replace("'", "\'", $value) . "'";// if here addslashes,
  //            " and ' will add addslashes,will display error
            break;

          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_PASSWORD__):
            if ($this->UT_Value->option & __UT_TEMPLATE_OPTION_MD5_PASSWORD__) {
//              echo $value . " : " . md5($value);
              if ($value == md5($value)) {
                $output = "'" . $value . "'";
              }
              else {
                $output = "'" . md5($value) . "'";
              }
            }
            else
              $output = "'" . $value . "'";
            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATESTR__):
            $output = "'" . str_replace("/", "-", $value) . "'" ;
            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_DATETIME__):
            if ($value != "") {
              switch (true) {
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_HIDDEN__):
              case ($this->UT_Value->option & __UT_TEMPLATE_OPTION_READONLY__):
                $output = $this->PRI_mktime($value);
                break;
              default:
                $output = $this->PRI_mktime($value);
                break;
              }
            }
            else
              $output = 0;
            break;
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_SELECTION__):
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_CHECKBOX__):
          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_RADIO__):
            $output = "'" . $value . "'";
            break;

          case ($this->UT_Value->editType & __UT_TEMPLATE_EDITTYPE_FILE__):
            $output = "'" . $value . "'";
            break;
        }

        return $output;
      }

      function set_var($field, $desc, $width, $len, $default, $listType, $editType, $optType="", $extra="", $cond="") {
        $this->UT_Value->DBField   = $field;
        $this->UT_Value->desc      = $desc;
        $this->UT_Value->width     = $width;
        $this->UT_Value->len       = $len;
        $this->UT_Value->default   = $default;
        $this->UT_Value->listType  = $listType;
        $this->UT_Value->editType  = $editType;
        $this->UT_Value->option    = $optType;
        $this->UT_Value->extra     = $extra;
        $this->UT_Value->cond      = $cond;
      }

      function UT_Template() {
        $UT_Value = UT_FieldStruct;
      }
    }

  }// end if 
  
  ?>