import olx
import sys
import os
sys.path.append(r".\src")
import userDictionaries
## This used to be in in init.py. Why?

from olexFunctions import OlexFunctions
OV = OlexFunctions()
import htmlTools
import olexex_setup
import variableFunctions
import olex
from gui.images import GI

gui_green = OV.GetParam('gui.green')
gui_orange = OV.GetParam('gui.orange')
gui_red = OV.GetParam('gui.red')


class GeneratedGuiMaker(object):
  def __init__(self):

    ## Define buttons, actions and hints: UP, DOWN, EDIT and DELETE
    number = "%s"
    onclick="spy.move(up,SET_SNUM_METACIF_PUBL_AUTHOR_NAMES_%s)>>html.update" %number
    hint="Move author up"
    self.up = GI.get_action_button_html('up', onclick, hint)

    onclick="spy.move(down,SET_SNUM_METACIF_PUBL_AUTHOR_NAMES_%s)>>html.update" %number
    hint="Move author down"
    self.down = GI.get_action_button_html('down', onclick, hint)

    onclick="spy.move(del,SET_SNUM_METACIF_PUBL_AUTHOR_NAMES_%s)>>html.Update" %number
    hint="Remove author from paper"
    self.delete = GI.get_action_button_html('delete', onclick, hint)

    onclick="spy.gui.report.publication.EditPersonById(SET_SNUM_METACIF_%s)"
    hint="Edit author"
    self.edit_subop = GI.get_action_button_html('edit', onclick, hint)

  def currentResultFilesHtmlMaker(self, type='cif'):
    var = 'snum.current_result.%s' %type
    val = OV.GetParam(var)
    if not val:
      val = os.path.normpath(olx.file.ChangeExt(OV.FileFull(),type))

    list = (
      {'varName':str(var),
        'itemName':'%s File' %type,
        'value':val,
        'chooseFile':{
          'caption':'Choose %s file' %type,
          'filter':'.%s files|*.%s' %(type, type),
          'folder':'%s' %OV.FilePath(),
          'function':'spy.SetParam(%s,' %var
          },
        },
    )
    return htmlTools.makeHtmlTable(list)

  def absorption_correctionMetadataHtmlMaker(self, ):
    list = (
      {'varName':'_exptl_absorpt_correction_type',
       'items':"'analytical;cylinder;empirical;gaussian;integration;multi-scan;none;numerical;psi-scan;refdelf;sphere'",
       'itemName':'%Abs Type%'
       },
      {'varName':'_exptl_absorpt_process_details',
       'itemName':'%Abs Details%',
       'multiline':'multiline'
       },
      {'varName':'_exptl_absorpt_correction_T_max',
       'itemName':'%Abs T max%',
       },
      {'varName':'_exptl_absorpt_correction_T_min',
       'itemName':'%Abs T min%',
       },
    )
    return htmlTools.makeHtmlTable(list)


  def diffractionMetadataHtmlMaker(self, ):

    list = (
      {'varName':'snum.report.diffractometer',
       'itemName':'%Diffractometer%',
       'items': "'%s'" %userDictionaries.localList.getListDiffractometers(),
       'onchange':"spy.addToLocalList(html.GetValue(~name~),diffractometers)>>html.update",
       'readonly':False,
       },
    )

    if OV.GetParam('snum.report.diffractometer') != '?':
      list += (
        {'varName':'snum.report.diffractometer_definition_file',
         'itemName':'%Definition File%',
         'value':userDictionaries.localList.getDiffractometerDefinitionFile(OV.GetParam('snum.report.diffractometer')),
         'chooseFile':{
           'caption':'Choose definition file',
           'filter':'.cif files|*.cif',
           'folder':'%s/etc/site' %OV.BaseDir(),
           'function':'spy.setDiffractometerDefinitionFile(spy.GetParam(snum.report.diffractometer),'
           },
         },
      )

    list += (
      {'varName':'_diffrn_ambient_temperature',
       'itemName':'%Diffraction T% (K)'
       },
      {'varName':'_cell_measurement_temperature',
       'itemName':'%Cell Measurement T% (K)'
       },
      {'varName':'_diffrn_special_details',
       'itemName':'%Special Details%',
       'multiline':'multiline'
       },
      {'varName':'_refine_special_details',
       'itemName':'%Refine Special Details%',
       'multiline':'multiline'
       }
    )
    return htmlTools.makeHtmlTable(list)

  def crystalMetadataHtmlMaker(self):
    list = (
      {'varName':'_chemical_name_systematic',
       'itemName':'%Systematic Name%',
       'width':'100%'
       },
      {'varName':'_exptl_crystal_colour',
       'itemName':'%Colour%',
       'box1':{'varName':'_exptl_crystal_colour_lustre',
               'items':'?;.;metallic;dull;clear',
               'width':'33%'
               },
       'box2':{'varName':'_exptl_crystal_colour_modifier',
               'items':"'?;.;light;dark;whiteish;blackish;grayish;brownish;reddish;pinkish;orangish;yellowish;greenish;bluish'",
               'width':'34%'
               },
       'box3':{'varName':'_exptl_crystal_colour_primary',
               'items':"'?;colourless;white;black;gray;brown;red;pink;orange;yellow;green;blue;violet'",
               'width':'33%'
               },
       },
      {'varName':'_exptl_crystal_size',
       'itemName':'%Size% & %Shape%',
       'box1':{'varName':'_exptl_crystal_size_min',
               'width':'20%'
               },
       'box2':{'varName':'_exptl_crystal_size_mid',
               'width':'20%'
               },
       'box3':{'varName':'_exptl_crystal_size_max',
               'width':'20%'
               },
       'box4':{'varName':'_exptl_crystal_description',
               'items': "'?;block;plate;needle;prism;irregular;cube;trapezoid;rect. Prism;rhombohedral;hexagonal;octahedral;plank'",
               'width':'40%'
               },
       },

      {'varName':'_exptl_crystal_preparation',
       'itemName':'%Preparation Details%',
       'multiline':'multiline',
       'width':'100%'
       },


      {'varName':'_exptl_crystal_recrystallization_method',
       'itemName':'%Crystallisation Details%',
       'multiline':'multiline',
       'width':'100%'
  ,
       },

      {'varName':'snum.report.crystal_mounting_method',
       'itemName':'%Crystal Mounting%',
       'multiline':'multiline',
       'width':'100%'
       },
    )
    return htmlTools.makeHtmlTable(list)

  def collectionMetadataHtmlMaker(self, ):
    items = userDictionaries.people.getListPeople()
    onchange = '''spy.gui.report.publication.OnPersonChange('~name~')>>spy.SetParam('snum.report.%s',html.GetValue('~name~'))'''
    subop = ["SUBMITTER", "OPERATOR"]
    list = []

    list.append(
      {
      'varName':'snum.report.submission_original_sample_id',
       'itemName':'%Sample ID%',
      }
    )

    for tem in subop:
      authorRow = {
        'varName':'snum.report.%s' %tem.lower(),
        'ctrl_name':'SET_SNUM_METACIF_%s' %tem,
        'readonly':'readonly',
        'items': items,
        'bgcolor':"'%s'" %OV.GetParam('gui.html.table_bg_colour'),
        'onchange':onchange % tem.lower(),
        'onchangealways':'true',
      }
      authorRow.setdefault('itemName','')
      authorRow.setdefault('field1',
                           {'itemName':tem.title(),
                            'fieldWidth':'70%%',
                            'bgcolor':'#ff0000',
                            })
      _ = "%s" %(self.edit_subop)
      _ = _ %(tem)

      authorRow.setdefault('field2',{'itemName':_,
                                     'fieldWidth':'30%%',
                                     'fieldALIGN':'right'})
      list.append(authorRow)

    list.append(
      {
      'varName':'snum.report.date_submitted',
       'itemName':'%Date Submitted%',
       'type': 'date'
      }
    )
    list.append(
      {
      'varName':'snum.report.date_collected',
       'itemName':'%Date Collected%',
       'type': 'date'
      }
    )
    list.append(
      {
      'varName':'snum.report.date_completed',
       'itemName':'%Date Completed%',
       'type': 'date'
      }
    )
    return htmlTools.makeHtmlTable(list)

  def citationsMetadataHtmlMaker(self, ):
    txt = "<b>Current Citations</b>:<br>"
    ref_l = OV.get_cif_item('_publ_section_references').split('\n\n')
    if not ref_l:
      ref = "<b>_publ_section_references</b> is currently missing or empty."
    else:
      for item in ref_l:
        item = item.strip()
        if item:
          txt += "%s<br>" %item
    return txt.rstrip('<br>')

  def progressMetadataHtmlMaker(self, ):
    list = (
      {'varName':'snum.dimas.progress_status',
       'itemName':'%Status%',
       'items': "'No Entry;Aborted;Rejected;Withdrawn;Lost;In Queue;Collecting;Reduction;Solving;Refining;Pending;Processing;Finishing;Finished;Publishing;Published;Published Duplicate;Known structure'"
       },
      {'varName':'snum.dimas.progress_comment',
       'itemName':'%Comment%',
       'multiline':'multiline'
       },
    )
    return htmlTools.makeHtmlTable(list)

  def referenceMetadataHtmlMaker(self, ):
    list = (
      {'varName':'snum.dimas.reference_csd_refcode',
       'itemName':'%CSD% %Refcode%',
       },
      {'varName':'snum.dimas.reference_publ_authors',
       'itemName':'%Authors%',
       },
      {'varName':'snum.dimas.reference_journal_name',
       'itemName':'%Journal%',
       'items': "'%s'" %userDictionaries.localList.getListJournals()
       },
      {'varName':'snum.dimas.reference_journal_volume',
       'itemName':'%Volume%',
       },
      {'varName':'snum.dimas.reference_journal_pages',
       'itemName':'%Pages%',
       },
      {'varName':'snum.dimas.reference_journal_year',
       'itemName':'%Year%',
       },
      {'varName':'snum.dimas.reference_comment',
       'itemName':'%Comment%',
       'multiline':'multiline'
       },
    )
    return htmlTools.makeHtmlTable(list)

  def publicationMetadataHtmlMaker(self, ):
    listAuthors = OV.GetParam('snum.metacif.publ_author_names')
    list = [
      {'varName':'_database_code_depnum_ccdc_archive',
       'itemName':'CCDC %Number%',
       },
      {'varName':'_publ_contact_author_name',
       'itemName':'%Contact% %Author%',
       'type': 'combo',
       'items': listAuthors,
       'onchange': "spy.set_cif_item('_publ_contact_author_name', html.GetValue('~name~'))",
       }]

    if listAuthors is None:
      numberAuthors = 0
    else:
      numberAuthors = len(listAuthors.split(';'))

    for i in range(1,numberAuthors+1):
      authorRow = {
        'varName':'snum.metacif.publ_author_names',
        'ctrl_name':'SET_SNUM_METACIF_PUBL_AUTHOR_NAMES_%s' %i,
        'value':"'%s'" %listAuthors.split(';')[i-1],
        'readonly': 'true',
        'bgcolor':"'%s'" %OV.GetParam('gui.html.table_bg_colour'),
        'onclick':""
      }
      if numberAuthors == 1:
        authorRow.setdefault('itemName','')
        authorRow.setdefault('field1',{'itemName':'%Author%'})
        _ = "%s" %(self.delete)
        _ = _ %(i)
        authorRow.setdefault('field2',{'itemName':_,
                                      'fieldALIGN':'right'})

      elif i == 1:
        box = "SET_SNUM_METACIF_PUBL_AUTHOR_NAMES_%s" %i
        authorRow.setdefault('itemName','')
        authorRow.setdefault('field1',{'itemName':'Authors</td><td>'})
        _ = "%s%s" %(self.down, self.delete)
        _ = _%(i,i)

        authorRow.setdefault('field2',
                             {'itemName':_,
                              'fieldALIGN':'right'}
                             )
      elif i == numberAuthors:
        _ = "%s%s" %(self.up, self.delete)
        _ = _%(i,i)

        authorRow.setdefault('itemName',_)
        authorRow.setdefault('fieldALIGN','right')
        authorRow['bgcolor'] = OV.GetParam('gui.html.input_bg_colour')
      else:
        _ = "%s%s%s" %(self.up, self.down, self.delete)
        _ = _%(i,i,i)

        authorRow.setdefault('itemName',_)
        authorRow.setdefault('fieldALIGN','right')

      list.append(authorRow)
    if numberAuthors > 0:
      s = '_' + str(numberAuthors)
    else:
      s = None

    list.append(
      {'varName':'snum.metacif.publ_author_names',
       'ctrl_name':'ADD_PUBL_AUTHOR_NAME',
       'itemName':'%Add% %Author%',
       'type': 'button',
       'value':'Add...',
       'onclick':"spy.gui.report.publication.OnAddNameToAuthorList('~name~')",
       }
    )

    for d in list:
      d.setdefault('ctrl_name','SET_%s' %str.upper(d['varName']).replace('.','_'))
      if 'ctrl_name' in d['varName']:
        d.setdefault('onchange',"spy.SetParam('%(varName)s',html.GetValue('~name~'))>>spy.changeBoxColour('~name~','#FFDCDC')>>html.Update" %d)
      elif 'author_name' in d['varName']:
        d.setdefault('onchange','')

    list.append(
      {'varName':'_publ_requested_journal',
       'itemName':'%Requested% %Journal%',
       'items': "'%s'" %userDictionaries.localList.getListJournals(),
       'readonly':'',
       'value':'spy.get_cif_item(_publ_requested_journal)',
       'onchange':"spy.addToLocalList(html.GetValue('~name~'),'requested_journal')>>spy.changeBoxColour('~name~','#FFDCDC')",
       })


    list.append( {'varName':'snum.report.publication_style',
                  'itemName':'%Journal Style%', 'items': "general;acta",
                  'value':"spy.GetParam('snum.report.publication_style')",
                  'onchange':"spy.gui.report.publication.OnPublicationTemplateChange(html.GetValue(~name~))>>html.update",
                  }, )


    retstr = htmlTools.makeHtmlTable(list)

    retstr +="""
  <tr VALIGN="center" ALIGN="left">
    <td colspan='2'>
      <a href="spy.contactLetter()>>html.Update" target="Edit Contact Letter"><b>Contact Letter</b></a>
    </td>
  </tr>
  """
    return retstr

  def contactLetter(self, ):
    letterText = OV.get_cif_item('_publ_contact_letter','?','gui')
    if letterText is None:
      import datetime
      today = datetime.date.today()
      date = today.strftime("%x")
      journal = OV.get_cif_item('_publ_requested_journal')
      fileName = olx.FileName()
      authorList = OV.GetParam('snum.metacif.publ_author_names')
      authors = ''
      if authorList is None:
        numberAuthors = 0
      else:
        authorList = authorList.split(';')
        numberAuthors = len(authorList)
      for i in range(numberAuthors):
        author = authorList[i]
        if ',' in author:
          a = author.split(',')
          surname = a[0]
          initials = ''
          for forename in a[1].split():
            initials += '%s.' %forename[0].upper()
        else:
          a = author.split()
          surname = a[-1]
          initials = ''
          for forename in a[:-1]:
            initials += '%s.' %forename[0].upper()

        if i < numberAuthors - 2:
          authorAbbrev = initials + surname + ', '
        elif i == numberAuthors - 2:
          authorAbbrev = initials + surname + ' and '
        elif i > numberAuthors - 2:
          authorAbbrev = initials + surname
        authors += authorAbbrev
      letterText = """Date of submission %s

  The CIF file contains data for the structure %s from
  the paper 'ENTER PAPER TITLE' by
  %s.
  The paper will be submitted to %s.
  """ %(date,fileName,authors,journal)

    inputText = OV.GetUserInput(0,'_publ_contact_letter',letterText)
    if inputText is not None:
      OV.set_cif_item('_publ_contact_letter', inputText);
    return ""

  def move(self, arg,name):
    listNames = OV.GetParam('snum.metacif.publ_author_names').split(';')
    name_i = olx.html.GetValue(name)
    i = listNames.index(name_i)

    if arg.lower() == 'up':
      if i != 0:
        name_i_minus_1 = listNames[i-1]
        listNames[i] = name_i_minus_1
        listNames[i-1] = name_i
      else:
        pass

    elif arg.lower() == 'down':
      try:
        name_i_plus_1 = listNames[i+1]
        listNames[i] = name_i_plus_1
        listNames[i+1] = name_i
      except:
        pass

    elif arg in ('del','DEL'):
      del listNames[i]

    names = ';'.join(listNames)
    OV.SetParam('snum.metacif.publ_author_names', names)

    return ''

GGM = GeneratedGuiMaker()
OV.registerFunction(GGM.absorption_correctionMetadataHtmlMaker)
OV.registerFunction(GGM.collectionMetadataHtmlMaker)
OV.registerFunction(GGM.contactLetter)
OV.registerFunction(GGM.crystalMetadataHtmlMaker)
OV.registerFunction(GGM.currentResultFilesHtmlMaker)
OV.registerFunction(GGM.diffractionMetadataHtmlMaker)
OV.registerFunction(GGM.progressMetadataHtmlMaker)
OV.registerFunction(GGM.publicationMetadataHtmlMaker)
OV.registerFunction(GGM.publicationMetadataHtmlMaker)
OV.registerFunction(GGM.referenceMetadataHtmlMaker)
OV.registerFunction(GGM.citationsMetadataHtmlMaker)
OV.registerFunction(GGM.move)



def restraint_builder(cmd):
  height = OV.GetParam('gui.html.combo_height')
  colspan = 3

  first_col_bg = OV.GetParam('gui.html.table_firstcol_colour')
  table_row_bg = OV.GetParam('gui.html.table_firstcol_colour')

  constraints = ["EXYZ", "EADP", "AFIX"]
  olex_conres = ["RRINGS", "TRIA", "ADPUEQ", "ADPVOL", "ANGLE", "DIANG"]

  atom_pairs =  {
    "DFIX":["name_DFIX", "var_d: ", "var_s:0.02", "help_DFIX-use-help"],
    "DANG":["name_DANG", "var_d: ", "var_s:0.04", "help_Select atom pairs"],
    "SADI":["name_SADI", "var_s:0.02", "help_SADI-use-help"],
  }

  atom_names =  {
    "SAME":["name_SAME", "var_s1:0.02", "var_s2:0.02", "help_Select any number of atoms"],
    "CHIV":["name_CHIV", "var_V:0", "var_s:0.1", "help_Select any number of atoms"],
    "FLAT":["name_FLAT", "var_s1:0.1", "help_Select at least four atoms"],
    "DELU":["name_DELU", "var_s1:0.01", "var_s2:0.01", "help_Select any number of atoms"],
    "SIMU":["name_SIMU", "var_s:0.04", "var_st:0.08", "var_dmax:1.7", "help_Select any number of atoms"],
    "RIGU":["name_RIGU", "var_s:0.004", "var_st:0.004", "help_Select any number of atoms"],
    "ISOR":["name_ISOR", "var_s:0.1", "var_st:0.2", "help_Select any number of atoms"],
    "EXYZ":["name_EXYZ", "help_exyz-htmhelp"],
    "EADP":["name_EADP", "help_eadp-htmhelp"],
    "AFIX":["name_AFIX", "var_m:6;5;10;11", "var_n:6;9", "help_AFIX-use-help"],
#    "RRINGS":["name_RRINGS", "var_d:1.39 ", "var_s1:0.02", "help_rrings-htmhelp"],
    "RRINGS":["name_RRINGS", "help_rrings-htmhelp"],
    "TRIA":["name_TRIA", "var_d: ", "var_angle: ", "help_tria-htmhelp"],
    "ADPUEQ":["name_ADPUEQ", "var_n:0.05 ", "help_adpueq-htmhelp", "cmd_restrain adp ueq"],
    "ADPVOL":["name_ADPVOL", "var_n: ", "help_adpvol-htmhelp", "cmd_restrain adp volume"],
    "ANGLE":["name_ANGLE", "var_n: ", "help_angle-htmhelp", "cmd_restrain angle"],
    "DIANG":["name_DIANG", "var_n: ", "help_diang-htmhelp", "cmd_restrain dihedral"],
  }

  if atom_pairs.has_key(cmd):
    l = atom_pairs[cmd]
  elif atom_names.has_key(cmd):
    l = atom_names[cmd]
  else:
    return "Unknow restraint/constraint"
  onclick = ""
  pre_onclick = ""
  post_onclick = ""
  html_help = "Click on the help link for more info"
  itemcount = 0
  items = None
  var = None
  ib = ""
  varcount = 0
  cmd = ""
  controls = []
  for item in l:
    itemcount += 1
    if "var" in item:
      varcount += 1
    if "cmd" in item:
      cmd = item.split("_")[1]

  for item in l:
    id, tem = item.split("_")
    val = ""
    if ":" in tem:
      var, val = tem.split(":")
    if id == "name":
      name = tem
      if not cmd:
        onclick += "%s " %name
      else:
        onclick += "%s " %cmd
    elif id == "help":
      html_help = OV.TranslatePhrase(tem)
      html_help, d = htmlTools.format_help(html_help)
    elif id == "cmd":
      cmd = val
    elif id == "var":
      ctrl_name = "%s_%s_TEXT_BOX" %(name, var)
      pre_onclick += "SetVar\(%s_value,html.GetValue\(%s))>>" %(ctrl_name,ctrl_name)
      onclick += "html.GetValue\(%s) " %ctrl_name
      if val == " ":
        val = "$GetVar(%s_value,'')" %ctrl_name
      elif ';' in val:
        items = val
        val = items.split(';')[0]
      else:
        items = None
        val = val.strip()
      width='33%'
      b_width='60%'
      if name == 'AFIX':
        width='50%'
        b_width='80%'
      d = {"ctrl_name":ctrl_name,
           "label":var,
           "valign":'center',
           "value":val,
           "width":b_width,
           "height":height,
           "bgcolor":"$GetVar('HtmlInputBgColour')"
           }
      if items:
        d.setdefault("items",items)
      if var:
        controls.append(htmlTools.makeHtmlInputBox(d))

  if name == "AFIX":
    onclick_list = onclick.strip().split(' ')
    onclick = 'AFIX strcat\(%s,%s)' %(onclick_list[1],onclick_list[2])
    post_onclick = '>>labels -a'
    mode_ondown = "mode %s" %(onclick.replace('AFIX ','HFIX '))
    mode_onup = "mode off>>sel -u"
    clear_onclick = "sel atoms where xatom.afix==strcat\(%s,%s)>>Afix 0>>labels -a" %(onclick_list[1],onclick_list[2])

  if name == "RRINGS":
    post_onclick = ">>sel -u"

  onclick = "%s%s%s" %(pre_onclick, onclick, post_onclick)
  if name == 'AFIX':
    controls.append('$spy.MakeHoverButton("button_small-clear@Afix","%s")' %clear_onclick)
    controls.append('$spy.MakeHoverButton("button_small-mode@Afix","%s")' %mode_ondown)
  controls.append('$spy.MakeHoverButton("button_small-go@%s","%s")' %(name, onclick))

  html = ""
  colw = 100/len(controls)
  for i, td in enumerate(controls):
    if (i+1) == len(controls):
      align = "right"
    else:
      align = "center"
    html += "<td width='%s%%' align='%s'>%s</td>" %(colw, align, td)
  html = ["<td><table width='100%%'><tr>%s</tr></table></td>" %html]
  #Add the help info as the last row in the table
  html.append("</tr><tr bgcolor='%s'>" %table_row_bg,)
  html.append(htmlTools.make_table_first_col(help_name=name, popout=True, help_image='normal'))
  html.append("<td bgcolor='%s' colspan='2'>%s</td></tr>" %(first_col_bg, html_help, ))
  if name in constraints:
    wFilePath = r"constraint-vars.htm"
  elif name in olex_conres:
    wFilePath = r"olex-conres-vars.htm"
  else:
    wFilePath = r"restraint-vars.htm"

  OV.write_to_olex(wFilePath, '\n'.join(html))
  OV.UpdateHtml()
  return "Done"
OV.registerFunction(restraint_builder)

have_found_python_error = False

def actaGuiDisplay(val=None):
  if val:
    curr_acta = olx.Ins('acta')
    if curr_acta != val:
      olex.m('delins acta')
    if val != "No ACTA":
      olex.m("addins %s" %val)

  else:
    val = olx.Ins('acta')
  if val == "n/a":
    val = "No ACTA"
  elif not val:
    val = "ACTA"

  olx.html.SetItems('REFINEMENT_ACTA','No ACTA;ACTA NOHKL;ACTA')
  olx.html.SetValue('REFINEMENT_ACTA', val)
  olx.html.SetBG('REFINEMENT_ACTA',refinement_acta_bg_colour())

OV.registerFunction(actaGuiDisplay)

def refinement_acta_bg_colour():
  olx.html.SetFG('REFINEMENT_ACTA','#000000')
  retVal = gui_red.hexadecimal
  val = olx.Ins('acta')
  if not val:
    retVal = gui_green.hexadecimal
    olx.html.SetValue('REFINEMENT_ACTA', 'ACTA')
  elif val == "n/a":
    olx.html.SetValue('REFINEMENT_ACTA', 'No ACTA')
    olx.html.SetFG('REFINEMENT_ACTA','#ffffff')
  elif val == "NOHKL":
    olx.html.SetValue('REFINEMENT_ACTA', 'ACTA NOHKL')
    retVal = gui_orange.hexadecimal
  else:
    try:
      int(val)
      retVal = gui_green.hexadecimal
      olx.html.SetValue('REFINEMENT_ACTA', 'ACTA %s' %val)
    except:
      pass
  return retVal
OV.registerFunction(refinement_acta_bg_colour)



def refineDataMaker():

  txt = """
<tr><td>R1(Fo > 4sig(Fo))</td><td>0.0511</td><td>R1(all data)</td><td>0.0690</td></tr>
<tr><td>wR2</td><td>0.1138</td><td>GooF</td><td>1.16</td></tr>
<tr><td>GooF(Restr)</td><td>1.16</td><td>Highest peak</td><td>0.32</td></tr>
<tr><td>Deepest hole</td><td>-0.32</td><td>Params</td><td>216</td></tr>
<tr><td>Refs(total)</td><td>6417</td><td>Refs(uni)</td><td>2803</td></tr>
<tr><td>Refs(Fo > 4sig(Fo))</td><td>2366</td><td>R(int)</td><td>0.061</td></tr>
<tr><td>R(sigma)</td><td>0.055</td><td>F000</td><td>364</td></tr>
<tr><td>&rho;/g*mm<sup>-3</sup></td><td>1.574</td><td>&mu;/mm<sup>-1</sup></td><td>0.140</td></tr>
"""
  OV.write_to_olex("refinedata.htm", txt)
  OV.UpdateHtml()
OV.registerFunction(refineDataMaker)