def get_timezone_value(self, value):
'''given a datetime value, try to convert to timezone specified in the widget.
If not specified, use the My Preferences time zone'''
timezone = self.get_option('timezone')
if not timezone:
timezone = PrefSetting.get_value_by_key('timezone')
if timezone in ["local", '']:
value = SPTDate.convert_to_local(value)
else:
value = SPTDate.convert_to_timezone(value, timezone)
return value
def get_timezone_value(my, value):
'''given a datetime value, try to convert to timezone specified in the widget.
If not specified, use the My Preferences time zone'''
timezone = my.get_option('timezone')
if not timezone:
timezone = PrefSetting.get_value_by_key('timezone')
if timezone in ["local", '']:
value = SPTDate.convert_to_local(value)
else:
value = SPTDate.convert_to_timezone(value, timezone)
return value
def get_format_value(my, value, format):
if format not in ['Checkbox'] and value == '':
return ''
# ------------------------------------------------
# Integer
if format == '-1234':
if not value:
# Case where value is '', 0, 0.0, -0.0 .
value = 0
value = "%0.0f" % my.convert_to_float(value)
elif format == '-1,234':
if not value:
value = 0
# Group the value into three numbers seperated by a comma.
value = my.number_format(value, places=0)
# ------------------------------------------------
# Float
elif format == '-1234.12':
if not value:
value = 0
value = "%0.2f" % my.convert_to_float(value)
elif format == '-1,234.12':
# break the value up by 3s
if not value:
value = 0
value = my.number_format(value, places=2)
# ------------------------------------------------
# Percentage
elif format == '-13%':
if not value:
value = 0
value = my.convert_to_float(value) * 100
value = "%0.0f" % my.convert_to_float(value) + "%"
elif format == '-12.95%':
if not value:
value = 0
value = my.convert_to_float(value) * 100
value = "%0.2f" % my.convert_to_float(value) + "%"
# ------------------------------------------------
# Currency
elif format == '-$1,234':
# break the value up by 3s
if not value:
value = 0
value = my.currency_format(value, grouping=True)
value = value[0:-3]
elif format == '-$1,234.00':
if not value:
value = 0
value = my.currency_format(value, grouping=True)
elif format == '-$1,234.--':
# break the value up by 3s
if not value:
value = 0
value = my.currency_format(value, grouping=True)
value = value[0:-3] + ".--"
elif format == '-$1,234.00 CAD':
# break the value up by 3s
if not value:
value = 0
value = my.currency_format(value, grouping=True, monetary=True)
# ------------------------------------------------
# Date
elif format == '31/12/99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%m/%y")
elif format == 'December 31, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%B %d, %Y")
elif format == '31/12/1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%m/%Y")
elif format == 'Dec 31, 99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%b %d, %y")
elif format == 'Dec 31, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%b %d, %Y")
elif format == '31 Dec, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d %b, %Y")
elif format == '31 December 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d %B %Y")
elif format == 'Fri, Dec 31, 99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%a, %b %d, %y")
elif format == 'Fri 31/Dec 99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%a %d/%b %y")
elif format == 'Fri, December 31, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%a, %B %d, %Y")
elif format == 'Friday, December 31, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%A, %B %d, %Y")
elif format == '12-31':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%m-%d")
elif format == '99-12-31':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%y-%m-%d")
elif format == '1999-12-31':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%Y-%m-%d")
elif format == '12-31-1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%m-%d-%Y")
elif format == '12/99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%m-%y")
elif format == '31/Dec':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%b")
elif format == 'December':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%B")
elif format == '52':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%U")
# ------------------------------------------------
# Time
elif format == '13:37':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%H:%M")
elif format == '13:37:46':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%H:%M:%S")
elif format == '01:37 PM':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%I:%M %p")
elif format == '01:37:46 PM':
if not value:
value = ''
else:
value = parser.parse(value)
from pyasm.common import SPTDate
timezone = my.get_option('timezone')
if not timezone:
pass
elif timezone == "local":
value = SPTDate.convert_to_local(value)
else:
value = SPTDate.convert_to_timezone(value, "EDT")
value = value.strftime("%I:%M:%S %p")
elif format == '31/12/99 13:37':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%m/%y %H:%M")
elif format == '31/12/99 13:37:46':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%m/%y %H:%M:%S")
elif format == 'DATETIME':
if not value:
value = ''
else:
value = parser.parse(value)
setting = ProdSetting.get_value_by_key('DATETIME')
if not setting:
setting = "%Y-%m-%d %H:%M"
value = value.strftime(setting)
elif format == 'DATE':
if not value:
value = ''
else:
value = parser.parse(value)
setting = ProdSetting.get_value_by_key('DATE')
if not setting:
setting = "%Y-%m-%d"
value = value.strftime(setting)
# ------------------------------------------------
# Scientific
elif format == '-1.23E+03':
if not value:
value = ''
else:
try:
value = "%.2e" % my.convert_to_float(value)
except:
value = "0.00"
elif format == '-1.234E+03':
if not value:
value = ''
else:
try:
value = "%.2e" % my.convert_to_float(value)
except:
value = "0.00"
# ------------------------------------------------
# Boolean
# false = 0, true = 1
elif format in ['True|False']:
if value:
value = 'True'
else:
value = 'False'
elif format in ['true|false']:
if value:
value = 'true'
else:
value = 'false'
elif format == 'Checkbox':
div = DivWdg()
div.add_class("spt_boolean_top")
from pyasm.widget import CheckboxWdg
checkbox = CheckboxWdg(my.get_name())
checkbox.set_option("value", "true")
if value:
checkbox.set_checked()
div.add(checkbox)
div.add_class('spt_format_checkbox_%s' % my.get_name())
version = my.parent_wdg.get_layout_version()
if version == "2":
pass
else:
checkbox.add_behavior({
'type':
'click_up',
'propagate_evt':
True,
'cbjs_action':
'''
var cached_data = {};
var value_wdg = bvr.src_el;
var top_el = bvr.src_el.getParent(".spt_boolean_top");
spt.dg_table.edit.widget = top_el;
var key_code = spt.kbd.special_keys_map.ENTER;
spt.dg_table.inline_edit_cell_cbk( value_wdg, cached_data );
'''
})
value = div
# ------------------------------------------------
# Timecode
elif format in [
'MM:SS.FF', 'MM:SS:FF', 'MM:SS', 'HH:MM:SS.FF', 'HH:MM:SS:FF',
'HH:MM:SS'
]:
fps = my.get_option('fps')
if not fps:
fps = 24
else:
fps = int(fps)
timecode = TimeCode(frames=value, fps=fps)
value = timecode.get_timecode(format)
# ------------------------------------------------
# Text formats
elif format in ['wiki']:
pass
return value
def get_format_value(my, value, format):
if format not in ['Checkbox'] and value == '':
return ''
# ------------------------------------------------
# Integer
if format == '-1234':
if not value:
# Case where value is '', 0, 0.0, -0.0 .
value = 0
value = "%0.0f" % my.convert_to_float(value)
elif format == '-1,234':
if not value:
value = 0
# Group the value into three numbers seperated by a comma.
value = my.number_format(value, places=0)
# ------------------------------------------------
# Float
elif format == '-1234.12':
if not value:
value = 0
value = "%0.2f" % my.convert_to_float(value)
elif format == '-1,234.12':
# break the value up by 3s
if not value:
value = 0
value = my.number_format(value, places=2)
# ------------------------------------------------
# Percentage
elif format == '-13%':
if not value:
value = 0
value = my.convert_to_float(value) * 100
value = "%0.0f" % my.convert_to_float(value) + "%"
elif format == '-12.95%':
if not value:
value = 0
value = my.convert_to_float(value) * 100
value = "%0.2f" % my.convert_to_float(value) + "%"
# ------------------------------------------------
# Currency
elif format == '-$1,234':
# break the value up by 3s
if not value:
value = 0
value = my.currency_format(value, grouping=True)
value = value[0:-3]
elif format == '-$1,234.00':
if not value:
value = 0
value = my.currency_format(value, grouping=True)
elif format == '-$1,234.--':
# break the value up by 3s
if not value:
value = 0
value = my.currency_format(value, grouping=True)
value = value[0:-3] + ".--"
elif format == '-$1,234.00 CAD':
# break the value up by 3s
if not value:
value = 0
value = my.currency_format(value, grouping=True, monetary=True)
elif format == '($1,234.00)':
# break the value up by 3s
if not value or value == "0":
value = " "
else:
value = my.currency_format(value, grouping=True)
if value.startswith("-"):
value = "<span style='color: #F00'>(%s)</span>" % value.replace("-", "")
# ------------------------------------------------
# Date
elif format == '31/12/99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%m/%y")
elif format == 'December 31, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%B %d, %Y")
elif format == '31/12/1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%m/%Y")
elif format == 'Dec 31, 99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%b %d, %y")
elif format == 'Dec 31, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%b %d, %Y")
elif format == '31 Dec, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d %b, %Y")
elif format == '31 December 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d %B %Y")
elif format == 'Fri, Dec 31, 99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%a, %b %d, %y")
elif format == 'Fri 31/Dec 99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%a %d/%b %y")
elif format == 'Fri, December 31, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%a, %B %d, %Y")
elif format == 'Friday, December 31, 1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%A, %B %d, %Y")
elif format == '12-31':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%m-%d")
elif format == '99-12-31':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%y-%m-%d")
elif format == '1999-12-31':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%Y-%m-%d")
elif format == '12-31-1999':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%m-%d-%Y")
elif format == '12/99':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%m-%y")
elif format == '31/Dec':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%b")
elif format == 'December':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%B")
elif format == '52':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%U")
# ------------------------------------------------
# Time
elif format == '13:37':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%H:%M")
elif format == '13:37:46':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%H:%M:%S")
elif format == '01:37 PM':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%I:%M %p")
elif format == '01:37:46 PM':
if not value:
value = ''
else:
value = parser.parse(value)
from pyasm.common import SPTDate
timezone = my.get_option('timezone')
if not timezone:
pass
elif timezone == "local":
value = SPTDate.convert_to_local(value)
else:
value = SPTDate.convert_to_timezone(value, "EDT")
value = value.strftime("%I:%M:%S %p")
elif format == '31/12/99 13:37':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%m/%y %H:%M")
elif format == '31/12/99 13:37:46':
if not value:
value = ''
else:
value = parser.parse(value)
value = value.strftime("%d/%m/%y %H:%M:%S")
elif format == 'DATETIME':
if not value:
value = ''
else:
value = parser.parse(value)
setting = ProdSetting.get_value_by_key('DATETIME')
if not setting:
setting = "%Y-%m-%d %H:%M"
value = value.strftime(setting)
elif format == 'DATE':
if not value:
value = ''
else:
value = parser.parse(value)
setting = ProdSetting.get_value_by_key('DATE')
if not setting:
setting = "%Y-%m-%d"
value = value.strftime(setting)
# ------------------------------------------------
# Scientific
elif format == '-1.23E+03':
if not value:
value = ''
else:
try:
value = "%.2e" % my.convert_to_float(value)
except:
value = "0.00"
elif format == '-1.234E+03':
if not value:
value = ''
else:
try:
value = "%.2e" % my.convert_to_float(value)
except:
value = "0.00"
# ------------------------------------------------
# Boolean
# false = 0, true = 1
elif format in ['True|False']:
if value:
value = 'True'
else:
value = 'False'
elif format in ['true|false']:
if value:
value = 'true'
else:
value = 'false'
elif format == 'Checkbox':
div = DivWdg()
div.add_class("spt_boolean_top")
from pyasm.widget import CheckboxWdg
checkbox = CheckboxWdg(my.get_name())
checkbox.set_option("value", "true")
if value:
checkbox.set_checked()
div.add(checkbox)
div.add_class('spt_format_checkbox_%s' % my.get_name())
version = my.parent_wdg.get_layout_version()
if version == "2":
pass
else:
checkbox.add_behavior( {
'type': 'click_up',
'propagate_evt': True,
'cbjs_action': '''
var cached_data = {};
var value_wdg = bvr.src_el;
var top_el = bvr.src_el.getParent(".spt_boolean_top");
spt.dg_table.edit.widget = top_el;
var key_code = spt.kbd.special_keys_map.ENTER;
spt.dg_table.inline_edit_cell_cbk( value_wdg, cached_data );
'''
} )
value = div
# ------------------------------------------------
# Timecode
elif format in ['MM:SS.FF','MM:SS:FF', 'MM:SS', 'HH:MM:SS.FF', 'HH:MM:SS:FF', 'HH:MM:SS']:
fps = my.get_option('fps')
if not fps:
fps = 24
else:
fps = int(fps)
timecode = TimeCode(frames=value, fps=fps)
value = timecode.get_timecode(format)
# ------------------------------------------------
# Text formats
elif format in ['wiki']:
pass
return value
