hcuTransAm.prg

<?php
  /*
   * File: hcuTransAm (TRANSlate And Maintain)
   *
   * Purpose:  Maintains the various hcuTranslate.lang files so they do not need to be
   *           edited by hand.
   *
   * NOTES:
   * 1. This file is independant of the home banking system and is used only to maintain
   *    the languange dictionary files.
   * 2. There is no need for CU files or anything. The include files are only for look and feel and
   *    to import the correct Kendo UI and JQuery files.
   * 3. SPB 10/30/2015-- Now uses monitorView.i
   *
   */

  $monLibrary= dirname(__FILE__) . "/../library";
  $sharedLibrary= dirname(__FILE__) . "/../../shared/library";
  $bankingDir = dirname(__FILE__) . "/../../banking";
  require_once("$monLibrary/cu_top.i");
  require_once("$monLibrary/ck_hticket.i");
  require_once("$monLibrary/monitorView.i");
  require_once("$sharedLibrary/hcuTranslate.i");
  require_once("$sharedLibrary/cu_func.i");

  if (!CheckPerm($link, $Hu, basename($_SERVER['SCRIPT_NAME']), $_SERVER['REMOTE_ADDR'])) {
    // ** Permissions failed
    // ** redirect to new page
    header("Location: /hcuadm/hcu_noperm.prg");
    exit;
  }

  //********** functions (more functions at end of file) ************//
  // Function for sorting the translation table keys
  function TransTableSort( $a, $b ) {
    $result = strcasecmp( $a, $b );

    if ( $result == 0 ) {
      $result = strcmp( $a, $b );
    }

    return $result;
  } // end TransTableSort
  /*
   * Local Variables
   *
   */

  // ** INSERT BUSINESS LOGIC FOR THIS FORM

  $languageAry = array("en_US"=>"English", "es_US"=>"Spanish", "pl_US"=>"Polish");
  $languageKeys = array_keys($languageAry);

  // this is a list of keys that would show up as duplicates (untranslated) to the English
  $ignoreList["es_US"] = array( "Total", "Quicken WebConnect", "PIN", "No", "Error" );
  $ignoreList["pl_US"] = array();

  try {
    // ** Import the necessary fields
    $dms_ok=array("action"=>"string", "key"=>"string", "screen" => "string",
                  "delimiter"=>"string" );
    dms_import_v2( $HB_ENV, "MY_POST", $dms_ok);

    $self = $_SERVER['SCRIPT_NAME'];
    $baseURL = $_SERVER["SCRIPT_NAME"];

    $action = $HB_ENV["MY_POST"]["action"];
    $screen = $HB_ENV["MY_POST"]["screen"];

    if ( $action == "import" &&
         $screen == "import" ) {
      // import the data and add the appropriate entries to the translation

      // check the delimiter (make sure no one messed with it)
      $delimiter = $HB_ENV["MY_POST"]["delimiter"];
      $delimiterChoices = array( ",", "|", ";", "^" );
      if ( !in_array( $delimiter, $delimiterChoices ) && $delimiter != "tab" ) {
        throw new ErrorException("Error - Invalid Delimiter");
      }

      if ( $delimiter == "tab" ) {
        $delimiter = "\t";
      }

      $uploadFile = "/tmp/hcuTransUpload.txt";

      // show the imported data
      $importLines = file( $uploadFile, FILE_IGNORE_NEW_LINES );

      $importInfo = array();
      $keyList = array();
      for ( $i = 0; $i < count( $importLines ); $i++ ) {
        $line = trim( $importLines[$i] );
        if ( substr( $line, 0, 1) == "#" ) continue;

        $lineParts = explode( $delimiter, $line );

        // save the unique keys
        if ( !in_array($lineParts[1], $keyList) ) {
          $keyList[] = $lineParts[1];
        }

        // put into array indexed by [key][lang]
        $importInfo[$lineParts[1]][$lineParts[0]] = ConvertFromUTF8( $lineParts[2] );
      }

      // now make each line have the key, lang1, lang2, ..., langN entries
      $importEntries = array();
      for ( $k = 0; $k < count( $keyList ); $k++ ) {
        $entry = array();
        $entry["key"] = $keyList[$k];

        $englishPhrase = "";
        $englishEntry = 0;
        for ( $l = 0; $l < count( $languageKeys ); $l++ ) {
          // save the english phrase in case a language is missing
          if ( $l == $englishEntry ) {
            $englishPhrase = $importInfo[$keyList[$k]][$languageKeys[$l]];
          }

          $phrase = $importInfo[$keyList[$k]][$languageKeys[$l]];
          if ( !strlen( trim( $phrase ) ) ) {
            $phrase = $englishPhrase;
          }

          $entry[$languageKeys[$l]] = $phrase;
        }

        $importEntries[] = $entry;
      }

      // for each language, get the Translation table and update/add any keys
      for ( $l = 0; $l < count( $languageKeys ); $l++ ) {
        // get the Translation table
        $transTable = new hcu_talk_base( $languageKeys[$l] );

        for ( $k = 0; $k < count( $keyList ); $k++ ) {
          $key = $keyList[$k];
          $found = false;
          // search for the phrase
          for ( $p = 0; $p < count( $importEntries ); $p++ ) {
            if ( $importEntries[$p]["key"] == $key ) {
              $phrase = trim( $importEntries[$p][$languageKeys[$l]] );
              $found = true;
              break;
            }
          }

          // add/update the key
          if ( $found ) {
            $transTable->messages[$key] = addslashes( $phrase );
          }
        }

        // sort so it is easier for humans to find the key
        uksort( $transTable->messages, "TransTableSort" );

        // update the table file
        WriteTranslationTableFile($languageKeys[$l], $transTable);
      }

      // let the user edit things
      $action = "edit";
    }

    if ( $action == "sort" ) {
      for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
        $transTable = new hcu_talk_base( $languageKeys[$i] );

        // sort so it is easier for humans to find the key
        uksort( $transTable->messages, "TransTableSort" );

        WriteTranslationTableFile( $languageKeys[$i], $transTable );
      }

      // go to the edit feature so the user can see what damage they have wrought
      $action = "edit";
    } else if ( $action == "removeEntry") {
      $key = $HB_ENV["MY_POST"]["key"];

      // get the keys
      for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
        $transTable = new hcu_talk_base( $languageKeys[$i] );

        // update/add the entry
        unset( $transTable->messages[$key] );

        // sort so it is easier for humans to find the key
        uksort( $transTable->messages, "TransTableSort" );

        WriteTranslationTableFile( $languageKeys[$i], $transTable );
      }


      header('Content-Type: application/json');
      print json_encode("");

      // leave now so no more data gets returned
      exit;
    } else if ( $action == "updateEntry") {

      $key = $HB_ENV["MY_POST"]["key"];

      // get the keys
      for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
        $transTable = new hcu_talk_base( $languageKeys[$i] );

        // update/add the entry (make sure no single quote in $key)
        $key = str_replace( "'", "", $key );
        $transTable->messages[$key] =  $_REQUEST[$languageKeys[$i]] ;

        // sort so it is easier for humans to find the key
        uksort( $transTable->messages, "TransTableSort" );

        WriteTranslationTableFile( $languageKeys[$i], $transTable );
      }


      header('Content-Type: application/json');
      print json_encode("");

      // leave now so no more data gets returned
      exit;
    }

    /*
     * ** START CONTENT
     */
    // change the header for certain actions
    $actionName = "";
    if ( $action == "edit" )
      $actionName = "(Edit)";
    else if ( $action == "check" )
      $actionName = "(Check)";
    else if ( $action == "import" )
      $actionName = "(Import)";

    // figure out the callback host because this script can be called from Monitor or Dev
    $callbackHost = trim( $_REQUEST["callback"] );
    if ( $callbackHost == "" ) $callbackHost = "www.homecu.net";

    // set the content type appropriately
    header('content-type: text/html; charset: utf-8');

    $title= "Credit Union Home Banking Settings $actionName";
    printMonitorPageTop($title, $homecuKendoVersion, $cloudfrontDomainName);
  ?>
      <style>
        body {
          font-family: Arial, Helvetica, sans-serif;
          background-color: #EFEFEF;
        }
        header {
          margin: 0 0 20px 0;
          background-color: #666;
          color: white;
          border-bottom: 5px solid #cc0000;
        }
        header .header-title {
          padding: 12px 0 5px 56px;
          font-size: 29px;
          font-weight: 100;

        }

  .configuration {
      margin: 0 0 0 15px;
      padding: 0 10px 10px 10px;
      -moz-box-shadow: 0 1px 2px rgba(0,0,0,0.5);
      -webkit-box-shadow: 0 1px 2px rgba(0,0,0,0.5);
      box-shadow: 0 1px 2px rgba(0,0,0,0.5);
      border: 1px solid rgba(255,255,255,0.2);
      -moz-border-radius: 3px;
      -webkit-border-radius: 3px;
      border-radius: 3px;
      background: -moz-linear-gradient(top,  rgba(0,0,0,0.01) 0%, rgba(0,0,0,0.07) 100%);
      background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,rgba(0,0,0,0.01)), color-stop(100%,rgba(0,0,0,0.07)));
      background: -webkit-linear-gradient(top,  rgba(0,0,0,0.01) 0%,rgba(0,0,0,0.07) 100%);
      background: -o-linear-gradient(top,  rgba(0,0,0,0.01) 0%,rgba(0,0,0,0.07) 100%);
      background: -ms-linear-gradient(top,  rgba(0,0,0,0.01) 0%,rgba(0,0,0,0.07) 100%);
      background: linear-gradient(to bottom,  rgba(0,0,0,0.01) 0%,rgba(0,0,0,0.07) 100%);
      min-width: 170px;
      max-width: 500px;
  }
  .configuration .options {
    list-style:none;
    margin: 0;
    padding: 0;
}
.configuration .options li {
  display: block;
  margin: 0;
  padding: 0.2em 0;
  zoom: 1;
}

.configuration .options li:after {
    content: "";
    display: block;
    clear: both;
    height: 0;
}
.configuration .configHead {
    display: block;
    font-size: 1.5em;
    font-weight: bold;
    text-indent: 0;
    margin-top: 10px;
    margin-bottom: 15px;
    border-bottom: 1px solid #999;
}
.configuration .configHead label{
  display:block;
}

#detailConfiguration fieldset legend {
  font-weight: bold;
  font-size: 1.4em;
  margin-bottom: 5px;
  margin-left: 0px;
}
#detailConfiguration label {
  display:block;
  font-size: 1.2em;
  margin: 3px 0 3px 0;
}

#detailConfiguration fieldset.language div {
  margin-left: 10px;
}

  .configuration-language {
    width: 120px;
  }
  .configuration-language .lang-select {
    display: table-cell;
    /*width: 50px;*/
    vertical-align: middle;
    border-right: 1px solid #AAA;
    padding: 10px 10px 10px 0px;
  }

  .configuration-language .lang-title {
    display: table-cell;
/*    width: 50px;*/
    vertical-align: middle;
    padding-left: 10px;

  }
  #editMenu {
    font-size: 12px;
  }
  #editMenu .menuTree {
    display: table-cell;
    min-width: 400px;
  }
  #btnAddNode {
    margin-bottom: 10px;
  }
  #editMenu .menuDetails {
    display: table-cell;
  }
  .configuration-language ul {
    list-style: none;
  }
  .configuration-language li {

  }
  #sectionLine {
    border-top:1px solid #DFDFDF;
    padding-top:5px;

  }
.sectionTitle {
    font-family: Arial, Helvetica, sans-serif;
    font-weight: normal;
}

.sectionTitle {
    left:0;
    font-size:23px;
    line-height:1.6;
    color:#4e4e4e;
}

.sectionTitle strong {
    color:#e26b1d;
    font-weight:normal;
}
section {
    margin: 5px 0 5px 0;
    padding: 20px 0 20px 20px;
    background-color: #fcfcfc;
    background: -webkit-gradient(linear, left top, left bottom, from(#ffffff), to(#efefef));

    background: -webkit-linear-gradient(top, #ffffff, #efefef);
    background: -moz-linear-gradient(top, #ffffff, #efefef);
    background: -o-linear-gradient(top, #ffffff, #efefef);
    background: -ms-linear-gradient(top, #ffffff, #efefef);
    background: linear-gradient(top, #ffffff, #efefef);
    -webkit-box-shadow: 0px 1px 2px #8e8e8e;
    -moz-box-shadow: 0px 1px 2px #8e8e8e;
    -o-box-shadow: 0px 1px 2px #8e8e8e;
    box-shadow: 0px 1px 2px #8e8e8e;
}


#themeWrap
{
    float: right;
    margin-top: -35px;
    font-size: .9em;
    line-height: 26px;
}

#themeWrap .get-kendoui
{
    padding: 0 10px;
    line-height: 24px;
    -moz-border-radius:3px;
    -webkit-border-radius:3px;
    border-radius:3px;
}

.k-theme-chooser,
.tc-theme,
.tc-color,
.tc-link,
.tc-theme-name
{
    text-decoration: none;
    display: inline-block;
    *display: inline;
    *zoom: 1;
}

.tc-theme-name
{
    vertical-align: middle;
    padding-right: 4px;
    width: 80px;
}

.k-theme-chooser .tc-link
{
    vertical-align: middle;
    line-height: 23px;
    padding: 0 4px 0 8px;
    -moz-border-radius: 3px;
    -webkit-border-radius: 3px;
    border-radius: 3px;
}

.tc-choose-theme
{
    vertical-align: middle;
    color: #939393;
    margin: 0 10px 0 0;
}

.tc-theme-container
{
    display: none;
    list-style-type: none;
    margin: 0 0 18px;
    padding: 0 0 18px 10px;
    border-bottom: 1px solid #dfdfdf;
   font:75% Arial,Helvetica,sans-serif;
}

.tc-color
{
    width: 23px;
    height: 23px;
    border-width: 1px;
    border-style: solid;
    border-color: rgba(0,0,0,.1) rgba(0,0,0,.1) rgba(0,0,0,.1) rgba(255,255,255,.1);
    display: inline-block;
    *display: inline;
    *zoom: 1;
}

.tc-theme
{
    margin: 0 5px;
}

.tc-theme .tc-link
{
    color: #4f4f4f;
    padding: 10px;
    border: 1px solid #fff;
}

.tc-theme .tc-link:hover
{
    border-color: #d6d6d6;
    -moz-box-shadow: 0 0 7px rgba(0,0,0,.15);
    -webkit-box-shadow: 0 0 7px rgba(0,0,0,.15);
    box-shadow: 0 0 7px rgba(0,0,0,.15);
}

.tc-theme .tc-link.active
{
    border-color: #d6d6d6;
    -moz-box-shadow: inset 0 0 7px rgba(0,0,0,.15);
    -webkit-box-shadow: inset 0 0 7px rgba(0,0,0,.15);
    box-shadow: inset 0 0 7px rgba(0,0,0,.15);
}

.tc-theme .tc-theme-name
{
    padding: 0;
    width: auto;
    display: block;
}

#themeChooser .skin-black .k-state-selected{background-color:#0070e4;color:#fff;}
#themeChooser .skin-blueopal .k-state-selected{background-color:#005c83;color:#fff;}
#themeChooser .skin-bootstrap .k-state-selected{background-color:#0044cc;color:#fff;}
#themeChooser .skin-default .k-state-selected{background-color:#f0713a;color:#fff;}
#themeChooser .skin-highcontrast .k-state-selected{background-color:#a7008f;color:#fff;}
#themeChooser .skin-metro .k-state-selected{background-color:#8ebc00;color:#fff;}
#themeChooser .skin-metroblack .k-state-selected{background-color:#00aba9;color:#fff;}
#themeChooser .skin-silver .k-state-selected{background-color:#0879C0;color:#fff;}
#themeChooser .skin-uniform .k-state-selected{background-color:#ccc;color:#666;}

        #gridProxy {
          font-size: 12px;
          width: 500px;
        }
        .k-tooltip-content { text-align: left;
                             font-size: 12px;
                             max-width: 300px;
                           }
      </style>
<?php
    printMonitorPageMiddle($title, array("REDIRECT" => array("list" => array("Monitor" => array("url" => "https://$callbackHost/monitor/mindex.html", "target" => "_top"))),
      "Check" => array("url" => "$self?action=check&callback=$callbackHost"), "Edit" => array("url" => "$self?action=edit&callback=$callbackHost"), "Re-Sort" => array("url" => "$self?action=sort&callback=$callbackHost"),
      "Import" => array("url" => "$self?action=import&callback=$callbackHost")));
    if ( $action == "edit" || $action == "" ) {
      // get the different language keys
      $languageKeysInfo = array();
      $englishEntry = 0;
      for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
        $languageKeysInfo[$i]["language"] = $languageKeys[$i];
        $languageKeysInfo[$i]["mc"] = new hcu_talk_base( $languageKeys[$i] );
        if ( $languageKeys[$i] == "en_US" ) {
          $englishEntry = $i;
        }
      }

      // set up the key values (same for all tabs)
      $baseKeys = array_keys( $languageKeysInfo[$englishEntry]["mc"]->messages );

      // get the translation for each key (note: this assumes the English list is comprehensive).
      $languageLists = array();
      for ( $k = 0; $k < count( $baseKeys ); $k++ ) {
        $entry = array();
        $entry["key"] = $baseKeys[$k];

        for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
          $entry[$languageKeys[$i]] =  $languageKeysInfo[$i]["mc"]->msg($baseKeys[$k], HCU_DISPLAY_AS_JS);
        }

        $languageLists[] = $entry;
      }

?>

        <div id="editList"></div>
        <div id="helpInfo"></div>

        <div id="progressShow" style="z-index:20000;"></div>
        <script id="popup-editor" type="text/x-kendo-template">
          <h3 style='text-align:center; width:100%;'>Edit Translation Entry</h3>
          <span>
            <label for="key" style='font-weight:bold;'>Key:</label>
            <textarea name="key"
                style="float:right; width:90%;"
                data-bind="value:key"
                data-value-field="key"
                data-text-field="key"
                id="key"
                name="key"
                cols="80"
                rows="5"></textarea>
                <div style="clear:both"></div>
          </span>
<?php
                for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
                  $lang = $languageKeys[$i];
?>
          <span>
            <label for="<?php echo $lang ?>" style='font-weight:bold;'><?php echo $lang ?>:</label>
            <textarea name="<?php echo $lang ?>"
                id="<?php echo $lang ?>"
                style="float:right; width:90%;"
                data-bind="value:<?php echo $lang ?>"
                data-value-field="<?php echo $lang ?>"
                data-text-field="<?php echo $lang ?>"
                cols="80"
                rows="5"></textarea>
                <div style="clear:both"></div>
          </span>
<?php
                }
?>
        </script>
        <script id="cmdTemplate" type="text/x-kendo-template">
        <a class="k-button" href="\#" onclick="return showHelp()">Help</a>
        </script>
        <style>
          .k-edit-form-container { width: auto; }
          .edit_label { text-align: left; font-weight: bold; font-size: larger; }
          .edit_entry { text-align: left; }
          .odd-row { background-color:lightcyan; }
          .header-row { background-color: lightsteelblue; font-weight: bold; }
          .td-detail { text-align: center; width: 33%; }
        </style>
            <script type="text/javascript">
              $(document).ready(function() {
                $("#tabstrip").kendoTabStrip({
                    animation: { open: { effects: "fadeIn"} }
                });

                var containsFilter =
                    {
                        extra : false,
                        operators : { string : { contains : "Contains"}},
                        ui : function( element )
                        {
                            var parent = element.parent();
                            while( parent.children().length > 1 )
                                $(parent.children()[0]).remove( );

                            parent.prepend( "<input data-bind=\"value:filters[0].value\" class=\"k-textbox\" type=\"text\">" );
                        }
                    }

                var phraseList = <?php echo str_replace('\\\u', '\u', json_encode( $languageLists )); ?>;
                $('#editList').kendoGrid({
                    dataSource: phraseList,
                    sortable: {
                      mode: "single",
                      allowUnsort: false
                    },
                    filterable: { contains: true },
                    editable: {
                      mode: "popup",
                      confirmation: "Are you sure you want to delete this record?",
                      template: kendo.template($("#popup-editor").html())
                    },
                    save: function(e) {
                      if (confirm("Are you sure you want to save this change?")) {
                        var that = this;
                        var postData = JSON.parse(JSON.stringify(e.model));
                        postData["action"] = "updateEntry";

                        var parameters = "";
                        $.each(postData, function( index, object ) {
                          if ( parameters.length > 0 ) parameters += "&";
                          parameters += index + "=" + encodeURIComponent(object);
                        });

                        kendo.ui.progress($('#progressShow'), true);

                        $.post( '<?php echo $baseURL ?>', parameters,
                             function (data, status, xhr) {
                                // find the document and update the changes
                                $.each(phraseList, function( index, object ) {
                                  if ( object["key"] == postData["key"] ) {
<?php
                                    for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
                                      print "object[\"{$languageKeys[$i]}\"] = postData[\"{$languageKeys[$i]}\"];\n";
                                    }
?>
                                    // since found it, stop looking
                                    return false;
                                  }
                                });

                                // signify updated
                                that.refresh();
                            })
                            .fail( function (xhr, status, error) {
                                alert('Some error happened:' + error);
                                that.cancelRow();
                            })
                            .always( function( xhr, status ) {
                                kendo.ui.progress($('#progressShow'), false);
                            });
                      } else {
                         e.preventDefault();
                      }
                    },
                    remove: removeEntry,
                    toolbar: [{ name: "create" }, { template: kendo.template($("#cmdTemplate").html()) } ],
                    columns: [
                      { command: ["edit", "destroy"], title: "&nbsp;", width: "172px"  },
                      { field: "key", title: "Key", filterable: containsFilter, width: "200px" }
<?php
                for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
                  print ",\n{ field: \"{$languageKeys[$i]}\", title: \"{$languageKeys[$i]}\", filterable: containsFilter, encoded: false }\n";
                }
  ?>
                    ]
                  });

                var wnd,
                  detailsTemplate;

                wnd = $("#helpInfo")
                        .kendoWindow({
                            title: "Character Translation",
                            modal: true,
                            visible: false,
                            resizable: false,
                            width: 300
                        }).data("kendoWindow");

              });

              function showHelp(e) {
                  var dialog = $("#helpInfo").data("kendoWindow");
                  var windowContents =
           ['<table style="width:100%">',
            '<tbody>',
            '<tr>',
            '  <th class="header-row" colspan="3">Spanish</th>',
            '</tr>',
<?php
            $transString = array("&Aacute;"=>"&amp;\#194;", "&Eacute;"=>"&amp;\#201;", "&Iacute;"=>"&amp;\#205;", "&Oacute;"=>"&amp;\#211;",
                                 "&Uacute;"=>"&amp;\#218;", "&Ntilde;"=>"&amp;\#209;", "&aacute;"=>"&amp;\#225;", "&eacute;"=>"&amp;\#233;",
                                 "&iacute;"=>"&amp;\#237;", "&oacute;"=>"&amp;\#243;", "&uacute;"=>"&amp;\#250;", "&ntilde;"=>"&amp;\#241;",
                                 "&iexcl;"=>"&amp;\#161;", "&iquest;"=>"&amp;\#191;");
            $transKeys = array_keys($transString);

            $rowBackground = "";
            for ( $i = 0; $i < count( $transKeys ); $i++ ) {
              $htmlEntity = htmlentities($transKeys[$i]);
              $hashCode = $transString[$transKeys[$i]];
?>
            '<tr class="<?php echo $rowBackground; ?>">',
            '  <td class="td-detail"><?php echo $transKeys[$i]; ?></td><td class="td-detail"><?php echo $hashCode; ?></td><td class="td-detail"><?php echo $htmlEntity; ?></td>',
            '</tr>',
<?php
              $rowBackground = ( $rowBackground == "odd-row" ) ? "" : "odd-row";
            }
?>
            '<tr>',
            '  <th class="header-row" colspan="3">Polish</th>',
            '</tr>',
<?php
            $transString = array( "&#260;"=>"&amp;\#260;", "&#261;"=>"&amp;\#261;", "&#280;"=>"&amp;\#280;", "&#281;"=>"&amp;\#281;",
                                  "&#211;"=>"&amp;\#211;", "&#243;"=>"&amp;\#243;", "&#262;"=>"&amp;\#262;", "&#263;"=>"&amp;\#263;",
                                  "&#321;"=>"&amp;\#321;", "&#322;"=>"&amp;\#322;", "&#323;"=>"&amp;\#323;", "&#324;"=>"&amp;\#324;",
                                  "&#346;"=>"&amp;\#346;", "&#347;"=>"&amp;\#347;", "&#377;"=>"&amp;\#377;", "&#378;"=>"&amp;\#378;",
                                  "&#379;"=>"&amp;\#379;", "&#380;"=>"&amp;\#380;" );
            $transKeys = array_keys($transString);

            $rowBackground = "";
            for ( $i = 0; $i < count( $transKeys ); $i++ ) {
              $htmlEntity = "&nbsp;";
              $hashCode = $transString[$transKeys[$i]];
?>
            '<tr class="<?php echo $rowBackground; ?>">',
            '  <td class="td-detail"><?php echo $transKeys[$i]; ?></td><td class="td-detail"><?php echo $hashCode; ?></td><td class="td-detail"><?php echo $htmlEntity; ?></td>',
            '</tr>',
<?php
              $rowBackground = ( $rowBackground == "odd-row" ) ? "" : "odd-row";
            }
?>
            '</tbody>',
            '</table>'].join("\n");

                dialog.content(windowContents).open().center();
              }

              function textareaEditor(container, options) {
                  $('<textarea data-bind="value: ' + options.field + '" cols="80" rows="5"></textarea>')
                      .appendTo(container);
              }

              function removeEntry(e) {
                var that = this;

                var modelData = JSON.parse(JSON.stringify(e.model));
                var postData = {};
                postData["action"] = "removeEntry";
                postData["key"] = modelData["key"];

                var parameters = "";
                $.each(postData, function( index, object ) {
                  if ( parameters.length > 0 ) parameters += "&";
                  parameters += index + "=" + encodeURIComponent(object);
                });

                kendo.ui.progress($('#progressShow'), true);

                $.post( '<?php echo $baseURL ?>', parameters,
                     function (data, status, xhr) {
                        // signify updated
                        that.refresh();
                    })
                    .fail( function (xhr, status, error) {
                        alert('Some error happened:' + error);
                        that.cancelRow();
                    })
                    .always( function( xhr, status ) {
                        kendo.ui.progress($('#progressShow'), false);
                    });
              }
            </script>
<?php
    } else if ( $action == "check" ) {
      // get the different language keys
      $languageKeysInfo = array();
      $englishEntry = 0;
      for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
        $languageKeysInfo[$i]["language"] = $languageKeys[$i];
        $languageKeysInfo[$i]["mc"] = new hcu_talk_base( $languageKeys[$i] );
        $languageKeysInfo[$i]["keys"] = array_keys( $languageKeysInfo[$i]["mc"]->messages );

        if ( $languageKeys[$i] == "en_US" ) {
          $englishEntry = $i;
        }
      }

      // see which phrases are duplicated in the others, meaning they have not been translated yet
      // NOTE: Assume the english one is correct
      $controlList = $languageKeysInfo[$englishEntry]["keys"];
      $untransList = array();
      for ( $i = 0; $i < count( $controlList ); $i++ ) {
        // get the control key (the one assumed to be right)
        $controlKey = $controlList[$i];
        $controlPhrase = stripslashes( $languageKeysInfo[$englishEntry]["mc"]->messages[$controlKey] );

        $languagePresent = array();
        for ( $t = 0; $t < count( $languageKeysInfo ); $t++ ) {

          // skip the english one
          if ( $englishEntry == $t ) continue;

          // compare the two keys
          $compareList = $languageKeysInfo[$t]["mc"];
          $comparePhrase = stripslashes( HCU_array_key_value($controlKey, $languageKeysInfo[$t]["mc"]->messages) );

          if ( $comparePhrase == $controlPhrase ) {
            // also make sure the key isn't on the ignore list
            if ( !in_array( $controlKey, $ignoreList[$languageKeysInfo[$t]["language"]] ) ) {
              $languagePresent[$languageKeysInfo[$t]["language"]] = true;
            }
          }
        }

        // only add if a duplicate was found
        if ( count( $languagePresent ) ) {
          $entry = array();
          $entry["key"] = $controlKey;
          $entry["phrase"] = $controlPhrase;
          $entry["selected"] = "";        // for user editing

          // add which languages found a duplicate
          for ( $t = 0; $t < count( $languageKeysInfo ); $t++ ) {
            // skip English
            if ( $t == $englishEntry ) continue;

            $lang = $languageKeysInfo[$t]["language"];
            if ( HCU_array_key_value($lang, $languagePresent) ) {
              $entry[$lang] = "X";
            } else {
              $entry[$lang] = "";
            }
          }

          $untransList[] = $entry;
        }
      }

      // see which entries are missing from the others
      $missingList = array();
      for ( $i = 0; $i < count( $languageKeysInfo ); $i++ ) {
        for ( $m = 0; $m < count( $languageKeysInfo ); $m++ ) {
          // skip the current one
          if ( $m == $i ) continue;

          // compare the two lists
          $controlList = $languageKeysInfo[$i]["keys"];
          $compareList = $languageKeysInfo[$m]["keys"];

          for ( $c = 0; $c < count( $controlList ); $c++ ) {
            $controlKey = $controlList[$c];

            if ( !in_array( $controlKey, $compareList ) ) {
              // see if key is in the missing list already
              $found = false;
              for ( $t = 0; $t < count( $missingList ); $t++ ) {
                if ( $missingList[$t]["key"] == $controlKey ) {
                  // add it for the language being compared
                  $missingList[$t][$languageKeysInfo[$m]["language"]] = "X";
                  $found = true;
                  break;
                }
              }
              if ( !$found ) {
                // add an entry
                $entry = array();
                $entry["key"] = $controlKey;
                $entry["phrase"] = stripslashes( HCU_array_key_value($controlKey, $languageKeysInfo[$t]["mc"]->messages) );
                $entry["selected"] = "";        // for user editing

                // add all languages and signify which was missing
                for ( $t = 0; $t < count( $languageKeysInfo ); $t++ ) {
                  $lang = $languageKeysInfo[$t]["language"];
                  // we need to flag the compare list
                  if ( $lang == $languageKeysInfo[$m]["language"] ) {
                    $entry[$lang] = "X";
                  } else {
                    $entry[$lang] = "";
                  }
                }

                $missingList[] = $entry;
              }
            }
          }
        }
      }

      // see which entries do not have phrases in the non-English translations
      // NOTE: Assume the english one is correct
      $controlList = $languageKeysInfo[$englishEntry]["keys"];
      $missingPhraseList = array();
      for ( $i = 0; $i < count( $controlList ); $i++ ) {
        // get the control key (the one assumed to be right)
        $controlKey = $controlList[$i];
        $controlPhrase = $languageKeysInfo[$englishEntry]["mc"]->messages[$controlKey];

        $missingPhrase = array();
        for ( $t = 0; $t < count( $languageKeysInfo ); $t++ ) {

          // skip the english one
          if ( $englishEntry == $t ) continue;

          // compare the two keys
          $comparePhrase = stripslashes( HCU_array_key_value($controlKey, $languageKeysInfo[$t]["mc"]->messages) );

          if ( trim( $comparePhrase ) == "" ) {
            $missingPhrase[$languageKeysInfo[$t]["language"]] = true;
          }
        }

        // only add if a duplicate was found
        if ( count( $missingPhrase ) ) {
          $entry = array();
          $entry["key"] = $controlKey;
          $entry["phrase"] = $controlPhrase;
          $entry["selected"] = "";        // for user editing

          // add which languages found a duplicate
          for ( $t = 0; $t < count( $languageKeysInfo ); $t++ ) {
            // skip English
            if ( $t == $englishEntry ) continue;

            $lang = $languageKeysInfo[$t]["language"];
            if ( HCU_array_key_value($lang, $missingPhrase) ) {
              $entry[$lang] = "X";
            } else {
              $entry[$lang] = "";
            }
          }

          $missingPhraseList[] = $entry;
        }
      }

      // search to see which entries are not in use anymore
      // NOTE: Assume the english one is correct
      // remove them from the $notUsedList as they are found
      $notUsedList = $languageKeysInfo[$englishEntry]["keys"];

      // get the list of files to search
      // NOTE: This may need to be manually maintained
      // NOTE: Don't forget the calculator files in /combin
      $searchFileList = array();
      $searchFileList[] = "$sharedLibrary/cu_data.i";
      foreach (glob("$bankingDir/scripts/*.prg") as $fileName) {
        $searchFileList[] = $fileName;
      }

      // search through the files
      for ( $i = 0; $i < count( $searchFileList ); $i++ ) {
        // open the file
        $fileTest = file_get_contents( $searchFileList[$i], FILE_USE_INCLUDE_PATH );

        // see which keys are used in this file
        for ( $t = 0; $t < count( $notUsedList ); $t++ ) {
          if ( strpos( $fileTest, HCU_array_key_value($t, $notUsedList) ) > 0 ) {
            // found, remove from unused list
             unset( $notUsedList[$t] );
             break;
          }
        }
      }

      // look in the CMS table since dictionary entries are used there
      $sql= "SELECT docs.docsdisplaytext FROM cucmsdocs docs";

      $sth = db_query( $sql, $dbh );
      $trow = 0;
      while ( $row = db_fetch_array( $sth, $trow++ ) ) {
        $phrase = $row["docsdisplaytext"];

        // see if key used
        for ( $t = 0; $t < count( $notUsedList ); $t++ ) {
          if ( !strcmp( $phrase, HCU_array_key_value($t, $notUsedList) ) ) {
            // found, remove from unused list
            unset( $notUsedList[$t] );
            break;
          }
        }
      }
      db_free_result($sth);

      // create an array for the datasource to display
      $notUsedListFinal = array();
      for ( $i = 0; $i < count( $notUsedList ); $i++ ) {
        if ( isset( $notUsedList[$i] ) ) {
          $notUsedListFinal[] = array( "key" => $notUsedList[$i], "phrase" => stripslashes( $languageKeysInfo[$englishEntry]["mc"]->messages[$notUsedList[$i]] ), "selected" => "" );
        }
      }

      // see which entries are duplicated with different case
      // NOTE: just test English
      $duplicateCase = array();
      $controlList = $languageKeysInfo[$englishEntry]["keys"];
      for ( $i = 0; $i < count( $controlList ); $i++ ) {
        $count = 0;
        for ( $m = 0; $m < count( $controlList ); $m++ ) {
          // skip the current one
          if ( $m == $i ) continue;

          // compare the two keys
          if ( !strcasecmp( $controlList[$i], $controlList[$m] ) ) {
            $count++;
          }
        }

        if ( $count > 0 ) {
          $duplicateCase[] = array( "key" => $controlList[$i], "phrase" => stripslashes( $languageKeysInfo[$englishEntry]["mc"]->messages[$controlList[$i]] ), "selected" => "" );
        }
      }

      // generate the full list of key/phrase for people to see
      $fullList = array();
      $controlList = $languageKeysInfo[$englishEntry]["keys"];
      for ( $i = 0; $i < count( $controlList ); $i++ ) {
        $fullList[] = array( "key" => $controlList[$i], "phrase" => stripslashes( $languageKeysInfo[$englishEntry]["mc"]->messages[$controlList[$i]] ), "selected" => "" );
      }

      // List of keys that have a duplicate in another language because the phrases are the same in both languages.
      // NOTE: this is the Ignore List
      $languageList = array_keys( $ignoreList );
      $ignoreExplainList = array();
      for ( $i = 0; $i < count( $languageList ); $i++ ) {
        // get the ingore keys for this language
        $ignoreListForLanguage = $ignoreList[$languageList[$i]];

        // process the keys
        for ( $k = 0; $k < count( $ignoreListForLanguage); $k++ ) {
          // get the key
          $controlKey = $ignoreListForLanguage[$k];

          // see if the entry for the key is already present
          $entryPresent = false;
          for ( $t = 0; $t < count( $ignoreExplainList ); $t++ ) {
            if ( $ignoreExplainList[$t]["key"] == $ignoreListForLanguage[$k] ) {
              $entryPresent = true;
              break;
            }
          }

          if ( $entryPresent) {
            // flag it for the current language
            $ignoreExplainList[$t][$languageList[$i]] = "X";
          } else {
            // add the key, phrase, and languages
            $entry = array();
            $entry["key"] = $controlKey;
            $entry["phrase"] = stripslashes( $languageKeysInfo[$englishEntry]["mc"]->messages[$controlKey] );
            $entry["selected"] = "";        // for user editing

            // add entries for all languages but only flag the current one
            for ( $l = 0; $l < count( $languageList ); $l++ ) {
              // flag as true if current $languageList[$i]
              $entry[$languageList[$l]] = ($l == $i) ? "X" : "";
            }

            // add it to the list
            $ignoreExplainList[] = $entry;
          }
        }
      }

?>

            <div id="tabstrip">
              <ul>
                  <li class="k-state-active"><span id="tip_untranslated">Untranslated Keys</span></li>
                  <li><span id="tip_missing_keys">Missing Keys</span></li>
                  <li><span id="tip_missing_phrases">Missing Phrases</span></li>
                  <li><span id="tip_not_in_use">Keys Not In Use</span></li>
                  <li><span id="tip_duplicate_case">Duplicate Case</span></li>
                  <li><span id="tip_full_list">Full List</span></li>
                  <li><span id="tip_ignore_list">(Ignore List)</span></li>
              </ul>
              <div>
                  <div>
                    <div id="untransList"></div>
                  </div>
              </div>
              <div>
                  <div>
                    <div id="missingList"></div>
                  </div>
              </div>
              <div>
                  <div>
                    <div id="missingPhraseList"></div>
                  </div>
              </div>
              <div>
                  <div>
                    <div id="notUsedList"></div>
                  </div>
              </div>
              <div>
                  <div>
                    <div id="duplicateCase"></div>
                  </div>
              </div>
              <div>
                  <div>
                    <div id="fullList"></div>
                  </div>
              </div>
              <div>
                  <div>
                    <div id="ignoreList"></div>
                  </div>
              </div>
            </div>

            <div id='submitWait' style='display:none;'>
              <h2><img src="https://www4.homecu.net/dash/homecu/images/busy.gif" /> Submitting data...</h2>
            </div>
            <script type="text/javascript">
              $(document).ready(function() {

                $("#tabstrip").kendoTabStrip({
                    animation: { open: { effects: "fadeIn"} }
                });

                homecuTooltip.bind({
                    tip_untranslated: "At least one language phrase is a duplicate of the English phrase.",
                    tip_missing_keys: "Keys are missing in at least one language file.",
                    tip_missing_phrases: "A language file is missing a key/phrase compared to the English keys.",
                    tip_not_in_use: "In searching script files, some keys are not found to be in use.",
                    tip_duplicate_case: "Identical keys found but with different case sensitivity.",
                    tip_full_list: "The full list of English Key/Phrase pairs.",
                    tip_ignore_list: "The list of keys that are ignored in the Untranslated List because they are the same in both languagues."
                });

                var untransList = <?php echo json_encode( $untransList ); ?>;
                var missingList = <?php echo json_encode( $missingList ); ?>;
                var missingPhraseList = <?php echo json_encode( $missingPhraseList ); ?>;
                var notUsedList = <?php echo json_encode( $notUsedListFinal ); ?>;
                var duplicateCase = <?php echo json_encode( $duplicateCase ); ?>;
                var fullList = <?php echo json_encode( $fullList ); ?>;
                var ignoreList = <?php echo json_encode( $ignoreExplainList ); ?>;

                var containsFilter =
                    {
                        extra : false,
                        operators : { string : { contains : "Contains"}},
                        ui : function( element )
                        {
                            var parent = element.parent();
                            while( parent.children().length > 1 )
                                $(parent.children()[0]).remove( );

                            parent.prepend( "<input data-bind=\"value:filters[0].value\" class=\"k-textbox\" type=\"text\">" );
                        }
                    }

                $('#untransList').kendoGrid({
                    dataSource: untransList,
                    sortable: {
                      mode: "single",
                      allowUnsort: false
                    },
                    filterable: { contains: true },
                    columns: [
                      { field: "key", title: "Key", filterable: containsFilter, width: "200px"  },
<?php
                // put in a field for each language other than englislh
                for ( $i = 0; $i < count( $languageKeysInfo ); $i++ ) {
                  // skip english
                  if ( $i == $englishEntry ) continue;
                  $fieldName = $languageKeysInfo[$i]["language"];
                  $title = $fieldName;
?>
                  { field: "<?php echo $fieldName ?>", title: "<?php echo $title ?>", width:"45px", filterable: false },
<?php
                }
?>
                      { field: "phrase", title: "Phrase", filterable: containsFilter },
                      { field: "selected", title: "Sel", filterable: containsFilter, width: "45px" }
                    ],
                    selectable: "row",
                    change: function(e) {
                      var selectedRow = this.dataItem(this.select());
                      var key = selectedRow.key;
                      var selected = selectedRow.selected == "Y" ? "" : "Y";

                      // find the entry in the data and update the change
                      $.each(untransList, function( index, object ) {
                        if ( object["key"] == key ) {
                          object["selected"] = selected;
                          // since found it, stop looking
                          return false;
                        }
                      });

                      var grid = $("#untransList").data("kendoGrid");
                      grid.dataSource.data(untransList);
                      grid.refresh();
                    },
                    dataBound: function () {
                        $("table tbody tr").hover(
                          function() {
                            $(this).toggleClass("k-state-hover");
                          }

                        );
                    }
                  });

                $('#missingList').kendoGrid({
                    dataSource: missingList,
                    sortable: {
                      mode: "single",
                      allowUnsort: false
                    },
                    filterable: { contains: true },
                    columns: [
                      { field: "key", title: "Key", filterable: containsFilter, width: "200px"  },
<?php
                // put in a field for each language
                for ( $i = 0; $i < count( $languageKeysInfo ); $i++ ) {
                  // skip english
                  if ( $i == $englishEntry ) continue;

                  $fieldName = $languageKeysInfo[$i]["language"];
                  $title = $fieldName;
?>
                  { field: "<?php echo $fieldName ?>", title: "<?php echo $title ?>", width:"45px", filterable: false },
<?php
                }
?>
                      { field: "phrase", title: "Phrase", filterable: containsFilter },
                      { field: "selected", title: "Sel", filterable: containsFilter, width: "45px" }
                    ],
                    selectable: "row",
                    change: function(e) {
                      var selectedRow = this.dataItem(this.select());
                      var key = selectedRow.key;
                      var selected = selectedRow.selected == "Y" ? "" : "Y";

                      // find the entry in the data and update the change
                      $.each(missingList, function( index, object ) {
                        if ( object["key"] == key ) {
                          object["selected"] = selected;
                          // since found it, stop looking
                          return false;
                        }
                      });

                      var grid = $("#missingList").data("kendoGrid");
                      grid.dataSource.data(missingList);
                      grid.refresh();
                    },
                    dataBound: function () {
                        $("table tbody tr").hover(
                          function() {
                            $(this).toggleClass("k-state-hover");
                          }

                        );
                    }
                  });

                $('#missingPhraseList').kendoGrid({
                    dataSource: missingPhraseList,
                    sortable: {
                      mode: "single",
                      allowUnsort: false
                    },
                    filterable: { contains: true },
                    columns: [
                      { field: "key", title: "Key", filterable: containsFilter, width: "200px"  },
<?php
                // put in a field for each language
                for ( $i = 0; $i < count( $languageKeysInfo ); $i++ ) {
                  // skip english
                  if ( $i == $englishEntry ) continue;

                  $fieldName = $languageKeysInfo[$i]["language"];
                  $title = $fieldName;
?>
                  { field: "<?php echo $fieldName ?>", title: "<?php echo $title ?>", width:"45px", filterable: false },
<?php
                }
?>
                      { field: "phrase", title: "Phrase", filterable: containsFilter },
                      { field: "selected", title: "Sel", filterable: containsFilter, width: "45px" }
                    ],
                    selectable: "row",
                    change: function(e) {
                      var selectedRow = this.dataItem(this.select());
                      var key = selectedRow.key;
                      var selected = selectedRow.selected == "Y" ? "" : "Y";

                      // find the entry in the data and update the change
                      $.each(missingPhraseList, function( index, object ) {
                        if ( object["key"] == key ) {
                          object["selected"] = selected;
                          // since found it, stop looking
                          return false;
                        }
                      });

                      var grid = $("#missingPhraseList").data("kendoGrid");
                      grid.dataSource.data(missingPhraseList);
                      grid.refresh();
                    },
                    dataBound: function () {
                        $("table tbody tr").hover(
                          function() {
                            $(this).toggleClass("k-state-hover");
                          }

                        );
                    }
                  });

                $('#notUsedList').kendoGrid({
                    dataSource: notUsedList,
                    sortable: {
                      mode: "single",
                      allowUnsort: false
                    },
                    filterable: { contains: true },
                    columns: [
                      { field: "key", title: "Key", filterable: containsFilter, width: "200px"  },
                      { field: "phrase", title: "Phrase", filterable: containsFilter  },
                      { field: "selected", title: "Sel", filterable: containsFilter, width: "45px" }
                    ],
                    selectable: "row",
                    change: function(e) {
                      var selectedRow = this.dataItem(this.select());
                      var key = selectedRow.key;
                      var selected = selectedRow.selected == "Y" ? "" : "Y";

                      // find the entry in the data and update the change
                      $.each(notUsedList, function( index, object ) {
                        if ( object["key"] == key ) {
                          object["selected"] = selected;
                          // since found it, stop looking
                          return false;
                        }
                      });

                      var grid = $("#notUsedList").data("kendoGrid");
                      grid.dataSource.data(notUsedList);
                      grid.refresh();
                    },
                    dataBound: function () {
                        $("table tbody tr").hover(
                          function() {
                            $(this).toggleClass("k-state-hover");
                          }

                        );
                    }
                  });

                $('#duplicateCase').kendoGrid({
                    dataSource: duplicateCase,
                    sortable: {
                      mode: "single",
                      allowUnsort: false
                    },
                    filterable: { contains: true },
                    columns: [
                      { field: "key", title: "Key", filterable: containsFilter, width: "200px"  },
                      { field: "phrase", title: "Phrase", filterable: containsFilter },
                      { field: "selected", title: "Sel", filterable: containsFilter, width: "45px" }
                    ],
                    selectable: "row",
                    change: function(e) {
                      var selectedRow = this.dataItem(this.select());
                      var key = selectedRow.key;
                      var selected = selectedRow.selected == "Y" ? "" : "Y";

                      // find the entry in the data and update the change
                      $.each(duplicateCase, function( index, object ) {
                        if ( object["key"] == key ) {
                          object["selected"] = selected;
                          // since found it, stop looking
                          return false;
                        }
                      });

                      var grid = $("#duplicateCase").data("kendoGrid");
                      grid.dataSource.data(duplicateCase);
                      grid.refresh();
                    },
                    dataBound: function () {
                        $("table tbody tr").hover(
                          function() {
                            $(this).toggleClass("k-state-hover");
                          }

                        );
                    }
                  });

                $('#fullList').kendoGrid({
                    dataSource: fullList,
                    sortable: {
                      mode: "single",
                      allowUnsort: false
                    },
                    filterable: { contains: true },
                    columns: [
                      { field: "key", title: "Key", filterable: containsFilter, width: "200px"  },
                      { field: "phrase", title: "Phrase", filterable: containsFilter },
                      { field: "selected", title: "Sel", filterable: containsFilter, width: "45px" }
                    ],
                    selectable: "row",
                    change: function(e) {
                      var selectedRow = this.dataItem(this.select());
                      var key = selectedRow.key;
                      var selected = selectedRow.selected == "Y" ? "" : "Y";

                      // find the entry in the data and update the change
                      $.each(fullList, function( index, object ) {
                        if ( object["key"] == key ) {
                          object["selected"] = selected;
                          // since found it, stop looking
                          return false;
                        }
                      });

                      var grid = $("#fullList").data("kendoGrid");
                      grid.dataSource.data(fullList);
                      grid.refresh();
                    },
                    dataBound: function () {
                        $("table tbody tr").hover(
                          function() {
                            $(this).toggleClass("k-state-hover");
                          }

                        );
                    }
                  });

                $('#ignoreList').kendoGrid({
                    dataSource: ignoreList,
                    sortable: {
                      mode: "single",
                      allowUnsort: false
                    },
                    filterable: { contains: true },
                    columns: [
                      { field: "key", title: "Key", filterable: containsFilter, width: "200px"  },
<?php
                // put in a field for each language
                for ( $i = 0; $i < count( $languageKeysInfo ); $i++ ) {
                  // skip english
                  if ( $i == $englishEntry ) continue;

                  $fieldName = $languageKeysInfo[$i]["language"];
                  $title = $fieldName;
?>
                  { field: "<?php echo $fieldName ?>", title: "<?php echo $title ?>", width:"45px", filterable: false },
<?php
                }
?>
                      { field: "phrase", title: "Phrase", filterable: containsFilter },
                      { field: "selected", title: "Sel", filterable: containsFilter, width: "45px" }
                    ],
                    selectable: "row",
                    change: function(e) {
                      var selectedRow = this.dataItem(this.select());
                      var key = selectedRow.key;
                      var selected = selectedRow.selected == "Y" ? "" : "Y";

                      // find the entry in the data and update the change
                      $.each(ignoreList, function( index, object ) {
                        if ( object["key"] == key ) {
                          object["selected"] = selected;
                          // since found it, stop looking
                          return false;
                        }
                      });

                      var grid = $("#ignoreList").data("kendoGrid");
                      grid.dataSource.data(ignoreList);
                      grid.refresh();
                    },
                    dataBound: function () {
                        $("table tbody tr").hover(
                          function() {
                            $(this).toggleClass("k-state-hover");
                          }

                        );
                    }
                  });

                });
            </script>
            <style scoped>
              #display-block {
                min-height:100px;
                padding: 5px 20px 5px 20px;
                width: 350px;
              }
              #content-block {
                width: 400px;
              }
              #panels
              {
                  /*margin-left: 20px;*/
                  text-align: center;

              }

              #panels li
              {
                  margin-right: 10px;
                  margin-bottom: 10px;
                  list-style: none;
                  float: left;

              }
              #panels .k-block {
                min-height: 70px;
                min-width: 200px;
              }
              #panels .k-block .k-header {
                margin-bottom:5px;
              }
              .homecu-formStatus {
                margin-bottom: 10px
              }
          </style>
<?php
    } else if ( $action == "import" || $action == "" ) {

      if ( $screen == "upload" || $screen == "" ) {
        // show a screen to upload the file and choose a delimiter
?>
        <h3>Pick a file to upload and specify the delimiter.</h3>
        <h5>Note: the default delimiter is a comma (',')</h5>
            <form method="post" style="width:45%">
              <input type="hidden" name="action" value="import">
              <input type="hidden" name="screen" value="confirm">
              <input name="upload_file" id="uploadFile" type="file" />
              <h3> Select Delimiter</h3>
              <p>
                <select name="delimiter">
                  <option value=','>,</option>
                  <option value='tab'>tab</option>
                  <option value=';'>;</option>
                  <option value='|'>|</option>
                  <option value='^'>^</option>
                </select>
              </p>
              <br />
              <br />
              <p>
                <input type="submit" value="Review" id="submitButton" class="k-button" style="visibility: hidden;"/>
              </p>
              <br />
              <br />
              <h3>Notes:</h3>
              <ol>
                <li>The file is in the format:<br>
                  language&lt;delim&gt;key&lt;delim&gt;phrase</li>
                <li>If the key exists then the phrase will be used with that key.</li>
                <li>If a key/phrase already exists the imported phrase will overwrite the existing.</li>
                <li>If a new key phrase's supported language is missing the English will be used.</li>
                <li>If a new key phrase is missing English, any missing phrases will be left blank.</li>
                <li>Lines starting with a '#' will be treated as comments.</li>
                <li>Any special characters need to use HTML Encoded entities.</li>
              </ol>
            </form>
            <style>
            </style>
            <script>
                $(document).ready(function() {
                    $("#uploadFile").kendoUpload({
                      localization: {
                          select: "Select File..."
                      },
                      multiple: false,
                      select: onSelect
                    });

                    function onSelect(e) {
                      $("#submitButton").css("visibility", "visible");
                    };
                });
            </script>
<?php
      } else if ( $screen == "confirm" ) {
        // show the uploaded info as delimited by the user's choice

        // make sure have a file
        $uploadFile = "";

        if ( is_uploaded_file( $_FILES["upload_file"]["tmp_name"] ) &&
            ( $_FILES["upload_file"]["size"] > 0 ) &&
            ( $_FILES["upload_file"]["error"] == 0) ) {
          $tmpName = $_FILES["upload_file"]["tmp_name"];
          $saveName = "/tmp/hcuTransUpload.txt";
          if ( move_uploaded_file($tmpName, $saveName) ) {
            // signify the upload occurred
            $uploadFile = $saveName;
          }
        }

        // check the delimiter
        $delimiterPassed = $HB_ENV["MY_POST"]["delimiter"];
        $delimiterChoices = array( ",", "|", ";", "^" );
        if ( !in_array( $delimiterPassed, $delimiterChoices ) && $delimiterPassed != "tab" ) {
          throw new ErrorException("Error - Invalid Delimiter");
        }

        if ( $delimiterPassed == "tab" ) {
          $delimiter = "\t";
        } else {
          $delimiter = $delimiterPassed;
        }

        if ( $uploadFile == "" ) {
          throw new ErrorException("Error Uploading Translation Import File");
        }

        // show the imported data
        $importLines = file( $uploadFile, FILE_IGNORE_NEW_LINES );

        $importInfo = array();
        $keyList = array();
        for ( $i = 0; $i < count( $importLines ); $i++ ) {
          $line = trim( $importLines[$i] );
          if ( substr( $line, 0, 1) == "#" ) continue;

          $lineParts = explode( $delimiter, $line );

          // save the unique keys
          if ( !in_array($lineParts[1], $keyList) ) {
            $keyList[] = $lineParts[1];
          }

          // put into array indexed by [key][lang]
          $importInfo[$lineParts[1]][$lineParts[0]] = $lineParts[2];
        }

        // now make each line have the key, lang1, lang2, ..., langN entries
        $importEntries = array();
        for ( $k = 0; $k < count( $keyList ); $k++ ) {
          $entry = array();
          $entry["key"] = $keyList[$k];

          $englishPhrase = "";
          $englishEntry = 0;
          for ( $l = 0; $l < count( $languageKeys ); $l++ ) {
            // save the english phrase in case a language is missing
            if ( $l == $englishEntry ) {
              $englishPhrase = $importInfo[$keyList[$k]][$languageKeys[$l]];
            }

            $phrase = $importInfo[$keyList[$k]][$languageKeys[$l]];
            if ( !strlen( trim( $phrase ) ) ) {
              $phrase = $englishPhrase;
            }

            $entry[$languageKeys[$l]] = ConvertFromUTF8( $phrase );
          }

          $importEntries[] = $entry;
        }
?>
        <script type="text/x-kendo-template" id="actionTemplate">
            <div class="toolbar">
              <form method='post'>
                <input type="hidden" name="action" value="import">
                <input type="hidden" name="screen" value="import">
                <input type="hidden" name="delimiter" value="<?php echo $delimiterPassed ?>">
                <button type='submit' id='upload' <?php echo (!count( $importLines ) ? "disabled='DISABLED'" : "") ?> class='k-button'>Upload</button>
              </form>
              <form method='post'>
                <input type="hidden" name="action" value="">
                <input type="hidden" name="screen" value="">
                <button type='submit' id='cancel' class='k-button'>Cancel</button>
              </form>
            </div>
        </script>

        <div id="confirmList"></div>

        <div id="progressShow" style="z-index:20000;"></div>
        <script type="text/javascript">
          $(document).ready(function() {

            var confirmList = <?php echo json_encode( $importEntries ); ?>;
            $('#confirmList').kendoGrid({
                dataSource: confirmList,
                toolbar: kendo.template($("#actionTemplate").html()),
                columns: [
                  { field: "key", title: "Key" }
<?php
                for ( $i = 0; $i < count( $languageKeys ); $i++ ) {
                  print ",\n{ field: \"{$languageKeys[$i]}\", title: \"{$languageKeys[$i]}\", encoded: false }\n";
                }
?>
                ]
              });

          });

          $("#upload").click(function() {
            kendo.ui.progress($('#progressShow'), true);
          });

          $("#cancel").click(function() {
            kendo.ui.progress($('#progressShow'), true);
          });
        </script>
        <style>
          form {
             display:inline;
             margin:0;
             padding:0;
          }
        </style>
<?php
      } else if ( $screen == "import" ) {
        // show the imported data with the existing data, allowing the user to edit and save
      } else {
        // something unexpected
        throw new ErrorException("Unsupported Import Screen");
      }
    } else {
      throw new ErrorException("Unsupported Action");
    }

    printMonitorPageBottom();
  } catch (Exception $e) {
    // ERROR CAUGHT
    /*
     *
     */
    $errorTitle= "Credit Union Home Banking Translation Table Maintenance";
    printMonitorPageTop($errorTitle, $homecuKendoVersion, $cloudfrontDomainName);
    printMonitorPageMiddle($errorTitle);
    print "<h3>{$e->getMessage()}</h3>";
    printMonitorPageBottom();
  }

  // FUNCTIONS

  // Write out the translation table to the correct file.
  function WriteTranslationTableFile( $language, $transTable ) {
    $fileWarning = "// This file is created and maintained programatically. DO NOT EDIT THIS FILE DIRECTLY.\n";
    $fileWarning .= "// The script file hcuadm/hcuTransAm is used to edit and maintain this file.\n\n";

    // re-generate the translation language-specific file
    $fileName = dirname(__FILE__) . "/../../shared/includes/hcuTranslate." . $language . ".i";

    // change the ownership
    $file = fopen($fileName, "w", true);
    if ( $file ) {
      fwrite( $file, "<?php\n" );

      fwrite( $file, $fileWarning );

      // * preserver the html_decode setting
      $jsArrayStr = "\$html_decode = {$transTable->html_decode};\n";
      fwrite($file, $jsArrayStr );

      $jsFind = $transTable->js_find;
      $arrayContents = "";
      for ( $j = 0; $j < count( $jsFind ); $j++ ) {
        if ( strlen( $arrayContents ) > 0 ) $arrayContents .= ",";
        $arrayContents .= "\"" . $jsFind[$j] . "\"";
      }

      $jsArrayStr = "\$js_find = array($arrayContents);\n";
      fwrite($file, $jsArrayStr );

      $jsReplace = $transTable->js_replace;
      $arrayContents = "";
      for ( $j = 0; $j < count( $jsFind ); $j++ ) {
        if ( strlen( $arrayContents ) > 0 ) $arrayContents .= ",";
        $arrayContents .= "\"" . $jsReplace[$j] . "\"";
      }

      $jsArrayStr = "\$js_replace = array($arrayContents);\n";
      fwrite($file, $jsArrayStr );

      // read in and form the list of lower case characters
      $lowerCharArray = $transTable->lowerChar;
      $arrayContents = "";
      for ( $j = 0; $j < count( $lowerCharArray ); $j++ ) {
        if ( strlen( $arrayContents ) > 0 ) $arrayContents .= ",";
        $arrayContents .= "\"" . $lowerCharArray[$j] . "\"";
      }

      $jsArrayStr = "\$lowerChar = array($arrayContents);\n";
      fwrite($file, $jsArrayStr );

      // read in and form the list of lower case characters
      $upperCharArray = $transTable->upperChar;
      $arrayContents = "";
      for ( $j = 0; $j < count( $lowerCharArray ); $j++ ) {
        if ( strlen( $arrayContents ) > 0 ) $arrayContents .= ",";
        $arrayContents .= "\"" . $upperCharArray[$j] . "\"";
      }

      $jsArrayStr = "\$upperChar = array($arrayContents);\n";
      fwrite($file, $jsArrayStr );

      // the $lang string
      $langStr = "\$lang = '{$language}';\n";
      fwrite($file, $langStr );

      // the $langName string
      $langNameStr = "\$langName = '{$transTable->langName}';\n";
      fwrite($file, $langNameStr );

      // the actual messages
      fwrite( $file, "\$messages = array(\n" );

      $transKeys = array_keys( $transTable->messages );
// need to sort the keys in case a new one was added
      $transString = "";
      for ( $k = 0; $k < count( $transKeys ); $k++ ) {
        if ( $k > 0 ) $transString .= ",\n";

        $findKey = $transKeys[$k];
        $newPhrase = str_replace("'", "\'", ConvertFromUTF8( $transTable->messages[$findKey]));
        $transString .= "  '{$findKey}' => '{$newPhrase}'";
      }

      $transString .= "\n);\n";

      fwrite( $file, $transString );

      fclose( $file );
    }
  }

  // Translate certain characters into the html entities.
  function TranslateLetters( $string ) {
    $before = $string;
    $transList = array(
        193 => "&Aacute",       // "�"
        201 => "&Eacute",       // "�"
        205 => "&Iacute",       // "�"
        209 => "&Ntilde",       // "�"
        211 => "&Oacute",       // "�"
        218 => "&Uacute",       // "�"
        225 => "&aacute",       // "�"
        233 => "&eacute",       // "�"
        237 => "&iacute",       // "�"
        241 => "&ntilde",       // "�"
        243 => "&oacute",       // "�"
        250 => "&uacute",       // "�"
        161 => "&iexcl",        // "�"
        191 => "&iquest"        // "�"
            );

    $strLen = strlen( $string );
    $newString = "";
print "<br> New String to translate: $string<br>";
    $chrArray = preg_split('//u',$string, -1, PREG_SPLIT_NO_EMPTY);
print_r( $chrArray );
    for ( $s = 0; $s < count( $chrArray ); $s++ ) {
      $oldChar = substr( $chrArray, $s, 1 );
      $ord = ord( $oldChar );
print "<br>found: $oldChar ($ord)";

      $newChar = $transList[$ord];

      if ( strlen( $newChar ) ) {
        print "<br>$ord, $oldChar --) $newChar";
        $transChar = $newChar;
      } else {
        $transChar = $oldChar;
      }

      $newString .= $transChar;
    }

    if ( strcmp( $newString, $string ) ) {
      print "<br>Changed: $string --) $newString";
    }

    return $newString;
  }