def get_display(my):
my.order_sk = my.kwargs.get('order_sk')
order_code = my.order_sk.split('code=')[1]
my.groups_str = None
if 'display_mode' in my.kwargs.keys():
my.disp_mode = my.kwargs.get('display_mode')
if my.disp_mode == 'Small':
my.small = True
if 'user' in my.kwargs.keys():
my.user = my.kwargs.get('user')
else:
my.user = Environment.get_user_name()
if 'groups_str' in my.kwargs.keys():
my.groups_str = my.kwargs.get('groups_str')
if my.groups_str in [None, '']:
user_group_names = Environment.get_group_names()
for mg in user_group_names:
if my.groups_str == '':
my.groups_str = mg
else:
my.groups_str = '%s,%s' % (my.groups_str, mg)
if 'is_master' in my.kwargs.keys():
my.is_master_str = my.kwargs.get('is_master')
if my.is_master_str == 'true':
my.is_master = True
else:
server = TacticServerStub.get()
main_obj = server.eval("@SOBJECT(twog/order['code','%s'])" % order_code)[0]
if main_obj.get('classification') in ['master', 'Master']:
my.is_master = True
my.is_master_str = 'true'
# Get the javascript functions
table = Table()
table.add_attr('class', 'qe_top_%s' % my.order_sk)
table.add_attr('width', '100%')
table.add_row()
type_checks_tbl = Table()
long_row = type_checks_tbl.add_row()
long_row.add_attr('width', '100%')
title_check = CustomCheckboxWdg(name='qe_titles_%s' % my.order_sk, value_field='title', checked='false',
dom_class='quick_edit_selector')
type_checks_tbl.add_cell(title_check)
type_checks_tbl.add_cell('Titles')
proj_check = CustomCheckboxWdg(name='qe_projects_%s' % my.order_sk, value_field='projects', checked='false',
dom_class='quick_edit_selector')
type_checks_tbl.add_cell(proj_check)
type_checks_tbl.add_cell('Projects')
wo_check = CustomCheckboxWdg(name='qe_work_orders_%s' % my.order_sk, value_field='work orders', checked='false',
dom_class='quick_edit_selector')
type_checks_tbl.add_cell(wo_check)
wo = type_checks_tbl.add_cell('Work Orders')
wo.add_attr('nowrap', 'nowrap')
eq_check = CustomCheckboxWdg(name='qe_equipment_%s' % my.order_sk, value_field='equipment', checked='false',
dom_class='quick_edit_selector')
type_checks_tbl.add_cell(eq_check)
type_checks_tbl.add_cell('Equipment')
group_selector = my.get_assigned_group_select(None, 'group_selector')
group_selector.add_behavior(get_select_checks_by_group_behavior(my.order_sk))
type_checks_tbl.add_cell(' ')
sbd = type_checks_tbl.add_cell('Select by Dept:')
sbd.add_attr('nowrap', 'nowrap')
type_checks_tbl.add_cell(group_selector)
tog_check = CustomCheckboxWdg(name='qe_toggler', additional_js=my.get_toggle_select_check_behavior(),
value_field='toggler', id='selection_toggler', checked='false')
last_cell = type_checks_tbl.add_cell(tog_check)
last_cell.add_attr('width', '100%')
last_cell.add_attr('align', 'right')
lc1 = type_checks_tbl.add_cell('Select/Deselect All In Table')
lc1.add_attr('width', '100%')
lc1.add_attr('align', 'right')
lc1.add_attr('nowrap', 'nowrap')
long_cell = table.add_cell(type_checks_tbl)
long_cell.add_attr('colspan', '8')
table.add_row()
table.add_cell('Platform: ')
# Get the list of platforms from the db
# Create the platform select wdg
platforms = my.server.eval("@GET(twog/platform['@ORDER_BY','name'].name)")
platform_sel = SelectWdg('platform_sel_%s' % my.order_sk)
platform_sel.append_option('--Select--', '--Select--')
for platform in platforms:
platform_sel.append_option(platform, platform)
table.add_cell(platform_sel)
# Create the territory select wdg
territories = my.territory_str.split('|')
territory_sel = SelectWdg('territory_sel_%s' % my.order_sk)
territory_sel.append_option('--Select--', '--Select--')
for territory in territories:
territory_sel.append_option(territory, territory)
table.add_cell('Territory: ')
table.add_cell(territory_sel)
# Create the languages select wdg
languages = my.language_str.split('|')
language_sel = SelectWdg('language_sel_%s' % my.order_sk)
language_sel.append_option('--Select--', '--Select--')
for language in languages:
language_sel.append_option(language, language)
table.add_cell('Language: ')
table.add_cell(language_sel)
# Create calendar input for start date
sd = table.add_cell('Start Date: ')
sd.add_attr('nowrap', 'nowrap')
start = CalendarInputWdg("qe_start_date_%s" % my.order_sk)
start.set_option('show_activator', True)
start.set_option('show_confirm', False)
start.set_option('show_text', True)
start.set_option('show_today', False)
start.set_option('read_only', False)
start.get_top().add_style('width: 150px')
start.set_persist_on_submit()
start_date = table.add_cell(start)
start_date.add_attr('nowrap', 'nowrap')
# Create calendar input for due date
dd = table.add_cell('Due Date: ')
dd.add_attr('nowrap', 'nowrap')
due = CalendarInputWdg("qe_due_date_%s" % my.order_sk)
due.set_option('show_activator', True)
due.set_option('show_confirm', False)
due.set_option('show_text', True)
due.set_option('show_today', False)
due.set_option('read_only', False)
due.get_top().add_style('width: 150px')
due.set_persist_on_submit()
due_date = table.add_cell(due)
due_date.add_attr('nowrap', 'nowrap')
table.add_cell('Priority: ')
table.add_cell('<input type="text" name="qe_priority_%s"/>' % my.order_sk)
table.add_row()
# Statuses should pull from the database soon, so I won't have to adjust this list every time a new status is
# added or removed
statuses = ['Pending', 'Ready', 'On Hold', 'Client Response', 'Fix Needed', 'Rejected', 'In Progress',
'DR In Progress', 'Amberfin01 In Progress', 'Amberfin02 In Progress', 'BATON In Progress',
'Export In Progress', 'Need Buddy Check', 'Buddy Check In Progress', 'Completed']
status_sel = SelectWdg('eq_status_%s' % my.order_sk)
status_sel.append_option('--Select--', '--Select--')
for status in statuses:
status_sel.append_option(status, status)
table.add_cell('Status: ')
table.add_cell(status_sel)
assigned_group_select = my.get_assigned_group_select(None, 'assigned_group_select')
ag = table.add_cell('Assigned Group: ')
ag.add_attr('nowrap', 'nowrap')
table.add_cell(assigned_group_select)
assigned_select = my.get_assigned_select(None)
ad = table.add_cell('Assigned: ')
ad.add_attr('nowrap', 'nowrap')
table.add_cell(assigned_select)
ewh = table.add_cell('Estimated Work Hours: ')
ewh.add_attr('nowrap', 'nowrap')
table.add_cell('<input type="text" name="qe_ewh_%s"/>' % my.order_sk)
table.add_row()
ed = table.add_cell('Expected Duration: ')
ed.add_attr('nowrap', 'nowrap')
table.add_cell('<input type="text" name="qe_ex_dur_%s"/>' % my.order_sk)
exq = table.add_cell('Expected Quantity: ')
exq.add_attr('nowrap', 'nowrap')
table.add_cell('<input type="text" name="qe_ex_quan_%s"/>' % my.order_sk)
# Submit button applies changes to everything in the order builder that is selected
submit_button = table.add_cell('<input type="button" name="submit_button" value="Apply Changes"/>')
submit_button.add_behavior(get_submit_quick_changes(my.order_sk, my.user))
# Add equipment to all work orders that are selected
add_eq_button = table.add_cell('<input type="button" name="add_eq_button" value="Edit Equipment"/>')
add_eq_button.add_behavior(get_eq_edit_behavior(my.order_sk, my.user))
last_chunk = table.add_cell(' ')
last_chunk.add_attr('width', '100%')
open_errors = table.add_cell('<u>Document Errors</u>')
open_errors.add_attr('name', 'qe_error_opener_%s' % my.order_sk)
open_errors.add_style('cursor: pointer;')
open_errors.add_behavior(get_open_errors_behavior(my.order_sk))
# Button to delete selected objects
delete_button = table.add_cell('<input type="button" name="delete_button" value="Delete Selected"/>')
delete_button.add_behavior(get_qe_delete(my.order_sk, my.user))
# This is where the scheduler can enter production errors. It is hidden until "Document Errors" is clicked
errors_row = table.add_row()
errors_row.add_attr('class', 'qe_errors_row_%s' % my.order_sk)
errors_row.add_style('display: none;')
errors_wdg = ErrorEntryWdg(order_sk=my.order_sk, code='NOCODE', user=my.user, groups_str=my.groups_str,
display_mode=my.disp_mode)
errors_cell = table.add_cell(errors_wdg)
errors_cell.add_attr('colspan', '10')
return table
def get_display(my):
login = Environment.get_login()
this_user = login.get_login()
groups = Environment.get_group_names()
my.get_stub()
show_save = False
for g in groups:
if 'qc' in g or 'edeliveries' in g:
show_save = True
if this_user == 'admin':
show_save = True
this_timestamp = str(datetime.datetime.now()).split('.')[0]
code = my.kwargs.get('code')
original_code = code
widget = DivWdg()
if 'TITLE' in code:
wos = my.server.eval("@GET(twog/work_order['title_code','%s'].code)" % code)
if len(wos) > 0:
code = wos[0]
else:
none_msg = 'THERE ARE NO WORK ORDERS IN THIS TITLE'
none_tbl = Table()
none_tbl.add_row()
none_tbl.add_cell(none_msg)
widget.add(none_tbl)
return widget
work_order = my.server.eval("@SOBJECT(twog/work_order['code','%s'])" % code)[0]
title = my.server.eval("@SOBJECT(twog/title['code','%s'])" % work_order.get('title_code'))[0]
tech_code = ''
tech = {
'code': '',
'description': '',
'timestamp': this_timestamp,
'login': this_user,
'barcode': '',
'client_code': '',
'client_name': '',
'title': title.get('title'),
'title_code': title.get('code'),
'episode': '',
'type': '',
'trt': '',
'part': '',
'label_date': '',
'capture_or_layoff': '',
'date': this_timestamp,
'order_code': work_order.get('order_code'),
'source_deck': '',
'record_deck': '',
'aspect_ratio': '',
'format': '',
'standard': '',
'timecode': '',
'text': '',
'vitc_lines': '',
'horiz_blank': '',
'active_video_lines': '',
'title_safe': '',
'error_logger': '',
'audio_ch01': '',
'audio_ch02': '',
'audio_ch03': '',
'audio_ch04': '',
'audio_ch05': '',
'audio_ch06': '',
'audio_ch07': '',
'audio_ch08': '',
'audio_ch09': '',
'audio_ch10': '',
'audio_ch11': '',
'audio_ch12': '',
'peak_ch01': '',
'peak_ch02': '',
'peak_ch03': '',
'peak_ch04': '',
'peak_ch05': '',
'peak_ch06': '',
'peak_ch07': '',
'peak_ch08': '',
'peak_ch09': '',
'peak_ch10': '',
'peak_ch11': '',
'peak_ch12': '',
'in_phase_0102': '',
'in_phase_0304': '',
'in_phase_0506': '',
'in_phase_0708': '',
'in_phase_0910': '',
'in_phase_1112': '',
'first_cut': '',
'first_cut_field': '',
'last_cut': '',
'last_cut_field': '',
'tc_verify': '',
'error_logger_messages': '',
'general_comments': '',
'operator': this_user,
'source_code': '',
'work_order_code': work_order.get('code'),
'wo_name': work_order.get('process')
}
if 'tech_code' in my.kwargs.keys():
tech_code = str(my.kwargs.get('tech_code'))
if tech_code not in [None,'']:
tech = my.server.eval("@SOBJECT(twog/tech_eval['code','%s'])" % tech_code)[0]
else:
tech_code = ''
wo_evals = my.server.eval("@SOBJECT(twog/tech_eval['work_order_code','%s']['code','!=','%s'])" % (code, tech_code))
title_evals = my.server.eval("@SOBJECT(twog/tech_eval['title_code','%s']['work_order_code','!=','%s']['code','!=','%s'])" % (work_order.get('title_code'), work_order.get('code'), tech_code))
others = Table()
others.add_style('background-color: #528B8B; width: 100%;')
cols = ['#537072', '#518A1A']
colsct = 0
if len(title_evals) > 0:
trrr = others.add_row()
trrr.add_style('background-color: #50EDA1;')
others.add_cell('<b>Other Tech Evals for Title</b>')
for t in title_evals:
click_row = others.add_row()
click_row.add_attr('tech_code', t.get('code'))
click_row.add_attr('work_order_code', t.get('work_order_code'))
click_row.set_style('cursor: pointer; background-color: %s;' % cols[colsct % 2])
click_row.add_behavior(my.get_click_row(t.get('work_order_code'), t.get('code')))
others.add_cell('<b>WO:</b> %s, <b>CODE:</b> %s' % (t.get('wo_name'), t.get('work_order_code')))
others.add_cell('<b>OPERATOR:</b> %s' % t.get('operator'))
others.add_cell('<b>DATETIME:</b> %s' % fix_date(t.get('date')))
colsct += 1
if len(wo_evals) > 0:
wrrr = others.add_row()
wrrr.add_style('background-color: #50EDA1;')
others.add_cell('<b>Other Tech Evals for Work Order</b>')
for w in wo_evals:
click_row = others.add_row()
click_row.add_attr('tech_code', w.get('code'))
click_row.add_attr('work_order_code', w.get('work_order_code'))
click_row.set_style('cursor: pointer; background-color: %s;' % cols[colsct % 2])
click_row.add_behavior(my.get_click_row(w.get('work_order_code'), w.get('code')))
others.add_cell('<b>WO:</b> %s, <b>CODE:</b> %s' % (w.get('wo_name'), w.get('work_order_code')))
others.add_cell('<b>OPERATOR:</b> %s' % w.get('operator'))
others.add_cell('<b>DATETIME:</b> %s' % fix_date(w.get('date')))
colsct += 1
widget.add_attr('class', 'big_ol_tech_wdg_%s' % code)
widget.add_attr('tech_code', tech.get('code'))
table = Table()
table.add_attr('class', 'printable_tech_form_%s' % code)
table.add_attr('tech_code', tech.get('code'))
table.add_attr('work_order_code', tech.get('work_order_code'))
table.add_style('font-family: Calibri, sans-serif;')
img_tbl = Table()
img_tbl.add_row()
i2 = Table()
i2.add_row()
i2.add_cell('<img src="/source_labels/2GLogo_small4.png"/>')
img_tbl.add_cell(i2)
ad = Table()
ad.add_row()
address = ad.add_cell('<b>2G Digital Post, Inc.</b><br/>280 E. Magnolia Blvd.<br/>Burbank, CA 91502<br/>310-840-0600<br/>www.2gdigitalpost.com')
address.add_attr('nowrap', 'nowrap')
address.add_style('font-size', '9px')
img_tbl.add_cell(ad)
rtbl = Table()
rtbl.add_row()
big = rtbl.add_cell("<b>LOAD/LAY-OFF TECH EVALUATION</b>")
big.add_attr('nowrap', 'nowrap')
big.add_attr('align', 'center')
big.add_attr('valign', 'center')
big.add_style('font-size', '40px')
rtbl.add_cell('')
toptbl = Table()
toptbl.add_row()
toptbl = Table()
toptbl.add_row()
toptbl.add_cell(img_tbl)
toptbl.add_cell(rtbl)
printtbl = Table()
printtbl.add_style('background-color: #528B8B; width: 100%;')
printtbl.add_row()
p1 = printtbl.add_cell(' ')
p1.add_style('width', '40%')
p2 = printtbl.add_cell('<u><b>Print This Report</b></u>')
p2.add_attr('nowrap','nowrap')
p2.add_style('cursor: pointer;')
p2.add_behavior(my.get_print_bvr(code, tech.get('code'), 'tech'))
p3 = printtbl.add_cell(' ')
p3.add_style('width', '40%')
qcd = CalendarInputWdg("timestamp")
qcd.set_option('show_activator', True)
qcd.set_option('show_confirm', False)
qcd.set_option('show_text', True)
qcd.set_option('show_today', False)
qcd.set_option('read_only', False)
qcd.set_option('width', '120px')
qcd.set_option('id', 'timestamp')
if tech.get('timestamp') not in [None,'']:
qcd.set_option('default', fix_date(tech.get('timestamp')))
qcd.get_top().add_attr('id','timestamp')
qcd.set_persist_on_submit()
lbld = CalendarInputWdg("label_date")
lbld.set_option('show_activator', True)
lbld.set_option('show_confirm', False)
lbld.set_option('show_text', True)
lbld.set_option('show_today', False)
lbld.set_option('read_only', False)
lbld.set_option('width', '120px')
lbld.set_option('id', 'label_date')
if tech.get('label_date') not in [None,'']:
lbld.set_option('default', fix_date(tech.get('label_date')))
lbld.get_top().add_attr('id', 'label_date')
lbld.set_persist_on_submit()
majtbl = Table()
majtbl.add_row()
mt = majtbl.add_cell('2G BARCODE')
mt.add_attr('align', 'left')
mt.add_attr('nowrap', 'nowrap')
mc = majtbl.add_cell('CLIENT')
mc.add_attr('align', 'left')
mc.add_attr('nowrap', 'nowrap')
mp = majtbl.add_cell('ENTRY DATE')
mp.add_attr('align', 'left')
mp.add_attr('nowrap', 'nowrap')
majtbl.add_row()
majtbl.add_cell('<input type="text" value="%s" class="tech_r_var" id="barcode" style="width: 240px;"/>' % tech.get('barcode'))
majtbl.add_cell('<input type="text" value="%s" class="tech_r_var" id="client_name" style="width: 340px;"/>' % tech.get('client_name'))
majtbl.add_cell(qcd)
titbl = Table()
titbl.add_row()
t1 = titbl.add_cell('TITLE')
t1.add_attr('align', 'left')
t2 = titbl.add_cell('EPISODE')
t2.add_attr('align', 'left')
titbl.add_row()
titbl.add_cell('<input type="text" value="%s" class="tech_r_var" id="title" style="width: 340px;"/>' % tech.get('title'))
titbl.add_cell('<input type="text" value="%s" class="tech_r_var" id="episode" style="width: 240px;"/>' % tech.get('episode'))
majtbl.add_row()
titc = majtbl.add_cell(titbl)
titc.add_attr('colspan', '3')
trtbl = Table()
trtbl.add_row()
tr1 = trtbl.add_cell('TYPE')
tr1.add_attr('align', 'left')
tr2 = trtbl.add_cell('TRT')
tr2.add_attr('align', 'left')
trtbl.add_row()
trtbl.add_cell('<input type="text" value="%s" class="tech_r_var" id="type" style="width: 340px;"/>' % tech.get('type'))
trtbl.add_cell('<input type="text" value="%s" class="tech_r_var" id="trt" style="width: 240px;"/>' % tech.get('trt'))
majtbl.add_row()
titr = majtbl.add_cell(trtbl)
titr.add_attr('colspan', '3')
dtbl = Table()
dtbl.add_row()
d1 = dtbl.add_cell('DESCRIPTION')
d1.add_attr('valign', 'top')
d2 = dtbl.add_cell('<textarea cols="100" rows="3" class="metadata_r_var" id="description">%s</textarea>' % tech.get('description'))
d2tbl = Table()
d2tbl.add_row()
d2tbl.add_cell('PART')
d2tbl.add_cell('<input type="text" value="%s" class="tech_r_var" id="part" style="width: 140px;"/>' % tech.get('part'))
d2tbl.add_row()
d21 = d2tbl.add_cell('LABEL DATE')
d21.add_attr('nowrap', 'nowrap')
d2tbl.add_cell(lbld)
dtbl.add_cell(d2tbl)
majtbl.add_row()
titr = majtbl.add_cell(dtbl)
titr.add_attr('colspan','3')
radio = '<form class="navbar-form pull-right"><label><input type="radio" name="capture_or_layoff" value="capture" /> Capture</label><label><input type="radio" name="sex" value="layoff" /> Layoff</label></form>'
ltbl = Table()
ltbl.add_style('background-color: #4a4a4a;')
ltbl.add_style('font-size: 15px;')
ltbl.add_row()
ltbl.add_cell(radio)
majtbl.add_row()
titr = majtbl.add_cell(ltbl)
titr.add_attr('colspan', '3')
table.add_row()
table.add_cell(toptbl)
table.add_row()
table.add_cell(majtbl)
stbl = Table()
stbl.add_row()
s1 = stbl.add_cell(' ')
s1.add_style('width: 40%s;' % '%')
s2 = stbl.add_cell('<input type="button" value="Save"/>')
s2.add_behavior(my.get_save_bvr(code, tech.get('code')))
s3 = stbl.add_cell(' ')
s3.add_style('width: 40%s;' % '%')
if tech.get('code') not in [None,'']:
s4 = stbl.add_cell('<input type="button" value="Delete This Report"/>')
s4.add_behavior(my.get_delete_eval(code, tech.get('code')))
ttbl = Table()
ttbl.add_style('background-color: #528B8B; width: 100%;')
ttbl.add_row()
tt1 = ttbl.add_cell(others)
tt1.add_attr('width','100%')
ttbl.add_row()
tt2 = ttbl.add_cell(printtbl)
tt2.add_attr('width','100%')
widget.add(ttbl)
widget.add(table)
if show_save and 'TITLE' not in original_code:
widget.add(stbl)
widget.add(table)
return widget
def get_display(my):
logine = Environment.get_login()
user_name = logine.get_login()
all_days = {}
group_days = {}
user_days = {}
tv_all_days = {}
tv_group_days = {}
tv_user_days = {}
tv_obj = my.server.eval("@SOBJECT(twog/global_resource['name','TimeVantage'])")[0]
snaps = my.server.eval("@SOBJECT(sthpw/snapshot['search_type','twog/global_resource?project=twog']['search_id','%s']['is_latest','true'])" % tv_obj.get('id'))
#print "SNAPS = %s" % snaps
file_path = my.get_snapshot_file_path(snaps[0].get('code'))
date1, date2 = my.get_dates()
if 'date1' in my.kwargs.keys():
date1 = my.kwargs.get('date1')
if 'date2' in my.kwargs.keys():
date2 = my.kwargs.get('date2')
#print "DATE1 = %s, DATE2 = %s" % (date1, date2)
#file_path = '/opt/spt/custom/graphs/tv.csv'
tv_data = my.make_TV_data_dict(file_path)
login_file = '/opt/spt/custom/graphs/login_file'
work_hour_file = '/opt/spt/custom/graphs/work_hour_file'
login_in_group_file = '/opt/spt/custom/graphs/login_in_group_file'
login_query = '/opt/spt/custom/graphs/login_query'
login_in_group_query = '/opt/spt/custom/graphs/login_in_group_query'
work_hour_query = '/opt/spt/custom/graphs/work_hour_query'
os.system('''psql -U postgres sthpw < %s > %s''' % (login_query, login_file))
os.system('''psql -U postgres sthpw < %s > %s''' % (work_hour_query, work_hour_file))
os.system('''psql -U postgres sthpw < %s > %s''' % (login_in_group_query, login_in_group_file))
login_data = my.make_data_dict(login_file, '')[0]
work_hour_data = my.make_data_dict(work_hour_file, 'hours')[1]
lig_data = my.make_data_dict(login_in_group_file, 'group')[0]
login_groups = {}
# Create login_group lookup by login name
for key, val in login_data.iteritems():
if key not in login_groups.keys():
login_groups[key] = []
for id, data in lig_data.iteritems():
if data.get('login') == key:
login_groups[key].append(data.get('login_group'))
# Match up TimeVantage names with tactic logins
# Fill user_dates dict with all matched logins
user_dates = {}
name_to_login = {}
for name, data in tv_data.iteritems():
for ld, ldata in login_data.iteritems():
lname = '%s %s' % (ldata.get('first_name').lower(), ldata.get('last_name').lower())
if name == lname:
if name not in user_dates.keys():
user_dates[name] = {'login': ldata.get('login'), 'dates': {}}
if name not in name_to_login.keys():
name_to_login[name] = ldata.get('login')
#print "TV-DATA = %s" % tv_data
group_dates = {}
all_dates = {}
for name, data in user_dates.iteritems():
tdata = tv_data[name]
tlogin = data.get('login')
ugroups = []
if tlogin in login_groups.keys():
ugroups = login_groups[tlogin]
print "TLOGIN = %s, UGROUPS = %s" % (tlogin, ugroups)
for tdate, ttime in tdata['days'].iteritems():
if tdate < date2 and tdate > date1:
if tdate not in user_dates[name]['dates'].keys():
user_dates[name]['dates'][tdate] = {'cat': tdate, 'tv': ttime, 'tactic': 0}
else:
user_dates[name]['dates'][tdate]['tv'] = user_dates[name]['dates'][tdate]['tv'] + ttime
for g in ugroups:
if g not in group_dates.keys():
group_dates[g] = {}
if tdate not in group_dates[g].keys():
group_dates[g][tdate] = {'cat': tdate, 'tv': ttime, 'tactic': 0}
else:
group_dates[g][tdate]['tv'] = group_dates[g][tdate]['tv'] + ttime
if tdate not in all_dates.keys():
all_dates[tdate] = {'cat': tdate, 'tv': ttime, 'tactic': 0}
else:
all_dates[tdate]['tv'] = all_dates[tdate]['tv'] + ttime
if tlogin in work_hour_data.keys():
for tdict in work_hour_data[tlogin]:
day = tdict.get('day')
amt = tdict.get('straight_time')
if day < date2 and day > date1:
if day not in user_dates[name]['dates'].keys():
user_dates[name]['dates'][day] = {'cat': day, 'tv': 0, 'tactic': amt}
else:
user_dates[name]['dates'][day]['tactic'] = user_dates[name]['dates'][day]['tactic'] + amt
for g in ugroups:
if g not in group_dates.keys():
group_dates[g] = {}
if day not in group_dates[g].keys():
print "DAY = %s, Group Dates Keys = %s" % (day, group_dates[g].keys())
group_dates[g][day] = {'cat': day, 'tv': 0, 'tactic': amt}
print "GROUP DATES KEYS = %s" % group_dates[g].keys()
else:
print "GROUP_DATES[%s][%s]['tactic'] = %s, amt = %s" % (g, day, group_dates[g][day]['tactic'], amt)
group_dates[g][day]['tactic'] = group_dates[g][day]['tactic'] + amt
print "GROUP_DATES[%s][%s]['tactic'] = %s" % (g, day, group_dates[g][day]['tactic'])
if day not in all_dates.keys():
all_dates[day] = {'cat': day, 'tv': 0, 'tactic': amt}
else:
all_dates[day]['tactic'] = all_dates[day]['tactic'] + amt
print "GROUP DATES = %s" % group_dates
d1s = date1.split('-')
d2s = date2.split('-')
d1 = date(int(d1s[0]),int(d1s[1]),int(d1s[2]))
d2 = date(int(d2s[0]),int(d2s[1]),int(d2s[2]))
delta = d2 - d1
dates_to_fill = []
for i in range(delta.days + 1):
dates_to_fill.append('%s' % (d1 + td(days=i)))
users = user_dates.keys()
idx = 0
for user in users:
udkeys = user_dates[user]['dates'].keys()
if len(udkeys) > 0:
for dtf in dates_to_fill:
found = False
for d, l in user_dates[user]['dates'].iteritems():
if d == dtf:
found = True
if not found:
user_dates[user]['dates'][dtf] = {'cat': dtf, 'tactic': 0, 'tv': 0}
for grp, gdata in group_dates.iteritems():
for dtf in dates_to_fill:
found = False
for d, l in group_dates[grp].iteritems():
if d == dtf:
found = True
if not found:
group_dates[grp][dtf] = {'cat': dtf, 'tactic': 0, 'tv': 0}
for dtf in dates_to_fill:
found = False
for d, l in all_dates.iteritems():
if d == dtf:
found = True
if not found:
all_dates[dtf] = {'cat': dtf, 'tactic': 0, 'tv': 0}
#print "LOGIN GROUPS = %s" % login_groups
filtbl = Table()
filtbl.add_row()
date1_el = CalendarInputWdg("wh_graph_date1")
date1_el.set_option('show_activator',True)
date1_el.set_option('show_confirm', False)
date1_el.set_option('show_text', True)
date1_el.set_option('show_today', False)
date1_el.set_option('show_value', True)
date1_el.set_option('read_only', False)
if date1 not in [None,'']:
date1_el.set_option('default', date1)
date1_el.get_top().add_style('width: 150px')
date1_el.set_persist_on_submit()
date2_el = CalendarInputWdg("wh_graph_date2")
date2_el.set_option('show_activator',True)
date2_el.set_option('show_confirm', False)
date2_el.set_option('show_text', True)
date2_el.set_option('show_today', False)
date2_el.set_option('show_value', True)
date2_el.set_option('read_only', False)
if date2 not in [None,'']:
date2_el.set_option('default', date2)
date2_el.get_top().add_style('width: 150px')
date2_el.set_persist_on_submit()
f1 = filtbl.add_cell(' ')
f11 = filtbl.add_cell(' Date 1: ')
f2 = filtbl.add_cell(date1_el)
f21 = filtbl.add_cell(' Date 2: ')
f3 = filtbl.add_cell(date2_el)
f4 = filtbl.add_cell('<input type="button" value="Load Graph" name="not_yo_date"/>')
f4.add_style('cursor: pointer;')
f4.add_behavior(my.get_load_again())
f1.add_attr('width','40%%')
f4.add_attr('width','40%%')
surrounder = Table()
surrounder.add_attr('width','100%%')
surrounder.add_attr('class','graph_surrounder')
surrounder.add_row()
surrounder.add_cell(filtbl)
table = Table()
table.add_attr('width','100%%')
table.add_attr('class','graph_top')
table.add_style('background-color: #60ca9d;')
lgroupkeys = login_groups.keys()
arr = []
# Need to show this one for elites only
# Show supervisors their department's
# Show individuals their own
# Try to implement drop-downs
for d, l in all_dates.iteritems():
arr.append(l)
if len(arr) > 0:
arr2 = sorted(arr, key=lambda k: k['cat'])
acount = 0
for a1 in arr2:
percentage = 0
tv = float(a1.get('tv'))
tc = float(a1.get('tactic'))
if tv != 0:
percentage = tc/tv * 100
pps = '%.2f' % percentage
percentage = float(pps)
if percentage > 100:
percentage = 100
a1['percentage'] = percentage
arr2[acount] = a1
acount = acount + 1
widget = DivWdg("Chart area 2")
widget.add_attr('id','chartdiv_%s'%idx)
str_data = my.make_string_dict(arr2)
widget.add_attr('datastr', str_data)
widget.add_styles('width: 100%%;height: 200px;')
my.draw_chart3(widget, idx, 'All')
table.add_row()
tc = table.add_cell(widget)
tc.add_attr('width','100%%')
tc.add_attr('title','ALL')
idx = idx + 1
groups = group_dates.keys()
for group in groups:
grptbl = Table()
grptbl.add_attr('width','100%%')
grptbl.add_style('background-color: #a1b3e6;')
#print "GROUP = %s" % group
arr = []
for d, l in group_dates[group].iteritems():
arr.append(l)
if len(arr) > 0:
arr2 = sorted(arr, key=lambda k: k['cat'])
acount = 0
for a1 in arr2:
percentage = 0
tv = float(a1.get('tv'))
tc = float(a1.get('tactic'))
if tv != 0:
percentage = tc/tv * 100
pps = '%.2f' % percentage
percentage = float(pps)
if percentage > 100:
percentage = 100
a1['percentage'] = percentage
arr2[acount] = a1
acount = acount + 1
widget = DivWdg("Chart area 2")
widget.add_attr('id','chartdiv_%s'%idx)
str_data = my.make_string_dict(arr2)
widget.add_attr('datastr', str_data)
widget.add_styles('width: 100%%;height: 200px;')
my.draw_chart3(widget, idx, group)
grptbl.add_row()
tc = grptbl.add_cell(widget)
tc.add_attr('width','100%%')
tc.add_attr('title',group)
grptbl.add_row()
opener = grptbl.add_cell('<b><u>Show Users</u></b>')
opener.add_style('cursor: pointer;')
toggle_row_behavior = my.get_toggle_row_behavior(group)
opener.add_behavior(toggle_row_behavior)
idx = idx + 1
grpusers = 0
usertbl = Table()
usertbl.add_attr('width','100%%')
usertbl.add_style('background-color: #c8d0e7;')
for user in users:
if user in name_to_login.keys():
login_name = name_to_login[user]
#print "USER = %s, LOGIN NAME = %s" % (user, login_name)
if login_name in lgroupkeys:
lgroups = []
lgroups = login_groups[login_name]
#print "GROUP = %s, USER = %s, LGROUPS = %s" % (group, user, lgroups)
#print "LOGIN GROUPS = %s" % login_groups
if group in lgroups:
arr3 = []
for d, l in user_dates[user]['dates'].iteritems():
arr3.append(l)
if len(arr) > 0:
arr4 = sorted(arr3, key=lambda k: k['cat'])
acount = 0
for a1 in arr4:
percentage = 0
tv = float(a1.get('tv'))
tc = float(a1.get('tactic'))
if tv != 0:
percentage = tc/tv * 100
pps = '%.2f' % percentage
percentage = float(pps)
if percentage > 100:
percentage = 100
a1['percentage'] = percentage
arr4[acount] = a1
acount = acount + 1
widget = DivWdg("Chart area 2")
widget.add_attr('id','chartdiv_%s'%idx)
str_data = my.make_string_dict(arr4)
widget.add_attr('datastr', str_data)
widget.add_styles('width: 100%%;height: 200px;')
my.draw_chart3(widget, idx, user)
if grpusers % 2 == 0:
usertbl.add_row()
tc = usertbl.add_cell(widget)
tc.add_attr('width','50%%')
tc.add_attr('title',user)
idx = idx + 1
grpusers = grpusers + 1
if grpusers % 2 == 1:
te = usertbl.add_cell(' ')
te.add_attr('width','50%%')
grprow = grptbl.add_row()
grprow.add_attr('id','graphs_%s_row' % group)
grprow.add_style('display: table-row;')
grptbl.add_cell(usertbl)
table.add_row()
table.add_cell(grptbl)
surrounder.add_row()
surrounder.add_cell(table)
return surrounder
def get_display(my):
my.client_code = str(my.kwargs.get('client_code'))
my.order_sk = str(my.kwargs.get('order_sk'))
my.order_sid = str(my.kwargs.get('order_sid'))
order_code = my.order_sk.split('code=')[1]
order_search = Search("twog/order")
order_search.add_filter('code',order_code)
the_order = order_search.get_sobject()
table = Table()
table.add_attr('class', 'title_adder_top_%s' % my.order_sk)
table.add_row()
table.add_cell('Title: ')
cell1 = table.add_cell('<input class="tadd_title" type="text"/>')
cell1.add_attr('colspan','5')
cell1.add_attr('align','left')
table.add_row()
empt = table.add_cell(' ')
beg = table.add_cell('Range Begin')
empt = table.add_cell(' ')
end = table.add_cell('Range End')
formatter = table.add_cell('# Formatter')
empt = table.add_cell(' ')
beg.add_attr('nowrap', 'nowrap')
beg.add_attr('valign', 'bottom')
end.add_attr('nowrap', 'nowrap')
end.add_attr('valign', 'bottom')
formatter.add_attr('nowrap', 'nowrap')
formatter.add_attr('valign', 'bottom')
beg.add_style('font-size: 50%;')
end.add_style('font-size: 50%;')
formatter.add_style('font-size: 50%;')
singl = table.add_cell('Single Episode Name, or Comma Seperated Episode Names')
singl.add_attr('valign', 'bottom')
singl.add_style('font-size: 50%;')
table.add_row()
table.add_cell('Episode: ')
table.add_cell('<input class="tadd_epi_range_1" type="text" style="width: 35px;"/>')
ctr = table.add_cell(' - ')
ctr.add_attr('align', 'center')
table.add_cell('<input class="tadd_epi_range_2" type="text" style="width: 35px;"/>')
table.add_cell('<input class="tadd_episode_format" type="text" style="width: 70px;"/>')
table.add_cell(' OR ')
table.add_cell('<input class="tadd_epi_name" type="text" style="width: 200px;"/>')
#There is no territory table in Tactic rigt now. We may want to do that in the future
territories_str = 'Afghanistan|Aland Islands|Albania|Algeria|American Samoa|Andorra|Angola|Anguilla|Antigua and Barbuda|Argentina|Armenia|Aruba|Australia|Austria|Azerbaijan|Bahamas|Bahrain|Bangladesh|Barbados|Belarus|Belgium|Belize|Benin|Bermuda|Bhutan|Bolivia|Bonaire|Bosnia and Herzegovina|Botswana|Bouvet Island|Brazil|Brunei Darussalam|Bulgaria|Burkina Faso|Burundi|Cambodia|Cameroon|Canada|Cantonese|Cape Verde|Cayman Islands|Central African Republic|Chad|Chile|China|Christmas Island|Cocos Islands|Colombia|Comoros|Congo|Dem. Rep. of Congo|Cook Islands|Costa Rica|Croatia|Cuba|Curacao|Cyprus|Czech|Denmark|Djibouti|Dominica|Dominican Republic|Ecuador|Egypt|El Salvador|English|Equatorial Guinea|Eritrea|Estonia|Ethiopia|Falkland Islands|Faroe Islands|Fiji|Finland|France|French Guiana|French Polynesia|Gabon|Gambia|Georgia|Germany|Ghana|Gibraltar|Greece|Greek|Greenland|Grenada|Guadeloupe|Guam|Guatemala|Guernsey|Guinea|Guinea-Bissau|Guyana|Haiti|Honduras|Hong Kong|Hungary|Iceland|India|Indonesia|Iran|Iraq|Ireland|Isle of Man|Israel|Italy|Ivory Coast|Jamaica|Japan|Jersey|Jordan|Kazakhstan|Kenya|Kiribati|Kuwait|Kyrgyztan|Laos|Latin America|Latin Spanish|Latvia|Lebanon|Lesotho|Liberia|Libya|Liechtenstein|Lithuania|Luzembourg|Macao|Macedonia|Madagascar|Malawi|Malaysia|Maldives|Mali|Malta|Marshall Islands|Martinique|Mauritania|Mauritius|Mayotte|Mexico|Micronesia|Moldova|Monaco|Mongolia|Montenegro|Montserrat|Morocco|Mozambique|Multi-language|Myanmar|Namibia|Nauru|Nepal|Netherlands|New Caledonia|New Zealand|Nicaragua|Niger|Nigeria|Niue|Norfolk Island|North Korea|Northern Mariana Islands|Norway|Oman|Pakistan|Palau|Palestine|Panama|Papua New Guinea|Pan-Asia|Paraguay|Peru|Philippines|Pitcairn|Poland|Portugal|Puerto Rico|Qatar|Reunion|Romania|Russia|Russian|Rwanda|St Barthelemy|St Helena|St Kitts and Nevis|St Lucia|St Martin|St Pierre and Miquelo|St Vincent and Grenadines|Samoa|San Marino|Sao Tome and Principe|Saudi Arabia|Senegal|Serbia|Seychelles|Sierra Leone|Signapore|Sint Maarten|Slovakia|Slovenia|Solomon Islands|Somalia|South Africa|South Georgia and Swch Islands|South Korea|South Sudan|Spain|Sri Lanka|Sudan|Suriname|Svalbard|Swaziland|Sweden|Switzerland|Syria|Taiwan|Tajikistan|Tanzania|Thai|Thailand|Timor-Leste|Togo|Tokelau|Tonga|Trinidad and Tobago|Tunisia|Turkey|Turkmenistan|Turks and Caicos Islands|Tuvalu|Uganda|Ukraine|UAE|United Kingdom|United States|Uruguay|Uzbekistan|Vanuatu|Various|Vatican|Venezuela|Vietnam|Virgin Islands|Wallis and Futuna|West Indies|Western Sahara|Yemen|Zambia|Zimbabwe'
territories = territories_str.split('|')
territory_sel = SelectWdg('tadd_territory')
territory_sel.append_option('--Select--', '--Select--')
for terr in territories:
territory_sel.append_option(terr, terr)
#There is no language table in Tactic. We may want to change that in the future.
language_str = 'Abkhazian|Afar|Afrikaans|Akan|Albanian|All Languages|Amharic|Arabic|Arabic - Egypt|Arabic - UAE and Lebanon|Aragonese|Aramaic|Armenian|Assamese|Avaric|Avestan|Aymara|Azerbaijani|Bahasa (Not Specified)|Bashkir|Basque|Belarusian|Bengali|Bihari languages|Bislama|Bosnian|Breton|Bulgarian|Burmese|Catalan|Catalan (Valencian)|Central Khmer|Chamorro|Chechen|Chichewa (Chewa, Nyanja)|Chinese (Cantonese)|Chinese (Mandarin - Not Specified)|Chinese (Mandarin - PRC)|Chinese (Mandarin - Taiwan)|Chinese Simplified Characters|Chinese Simplified Characters - Malaysia|Chinese Simplified Characters - PRC|Chinese Simplified Characters - Singapore|Chinese Traditional Characters|Chinese Traditional Characters - Hong Kong|Chinese Traditional Characters - Taiwan|Chuvash|Cornish|Corsican|Cree|Croatian|Czech|Danish|Dari|Divehi (Dhivehi, Maldivian)|Dutch|Dzongkha|English|English - Australian|English - British|Esperanto|Estonian|Ewe|Faroese|Farsi (Persian)|Fijian|Finnish|Flemish|French (Not Specified)|French - Canadian (Quebecois)|French - France|Fulah|Gaelic (Scottish Gaelic)|Galician|Georgian|German|German - Austrian|German - Swiss/Alsatian|Greek - Modern|Guarani|Gujarati|Haitian (Haitian Creole)|Hausa|Hawaiian|Hebrew|Herero|Hindi|Hiri Motu|Hungarian|Icelandic|Ido|Indonesian Bahasa|Interlingua (International Auxiliary Language Association)|Interlingue (Occidental)|Inuktitut|Inupiaq|Italian|Japanese|Javanese|Kalaallisut (Greenlandic)|Kannada|Kanuri|Kashmiri|Kazakh|Kikuyu (Gikuyu)|Kinyarwanda|Kirghiz (Kyrgyz)|Komi|Kongo|Korean|Kuanyama (Kwanyama)|Kurdish|Lao|Latin|Latvian|Limburgan (Limburger, Limburgish)|Lingala|Lithuanian|Luba-Katanga|Luxembourgish (Letzeburgesch)|MOS (no audio)|Macedonian|Malagasy|Malay Bahasa|Malayalam|Maltese|Maori|Marathi|Marshallese|Mauritian Creole|Mayan|Moldavian|Mongolian|Nauru|Navajo (Navaho)|Ndebele - North|Ndebele - South|Ndonga|Nepali|No Audio|Northern Sami|Norwegian|Occitan|Ojibwa|Oriya|Oromo|Ossetian (Ossetic)|Palauan|Pali|Panjabi (Punjabi)|Polish|Polynesian|Portuguese (Not Specified)|Portuguese - Brazilian|Portuguese - European|Pushto (Pashto)|Quechua|Romanian|Romanian (Moldavian)|Romansh|Rundi|Russian|Samoan|Sango|Sanskrit|Sardinian|Sepedi|Serbian|Serbo-Croatian|Setswana|Shona|Sichuan Yi (Nuosu)|Sicilian|Silent|Sindhi|Sinhala (Sinhalese)|Slavic|Slovak|Slovenian|Somali|Sotho, Sesotho|Spanish (Not Specified)|Spanish - Argentinian|Spanish - Castilian|Spanish - Latin American|Spanish - Mexican|Sudanese|Swahili|Swati|Swedish|Tagalog|Tahitian|Taiwanese (Min Nah)|Tajik|Tamil|Tatar|Telugu|Tetum|Textless|Thai|Tibetan|Tigrinya|Tok Pisin|Tongan|Tsonga|Turkish|Turkmen|Tuvaluan|Twi|Uighur (Uyghur)|Ukrainian|Unavailable|Unknown|Unknown|Urdu|Uzbek|Valencian|Venda|Vietnamese|Volapuk|Walloon|Welsh|Western Frisian|Wolof|Xhosa|Yiddish|Yoruba|Zhuang (Chuang)|Zulu'
languages = language_str.split('|')
language_sel = SelectWdg('tadd_language')
language_sel.append_option('--Select--', '--Select--')
for language in languages:
language_sel.append_option(language, language)
client_search = Search("twog/client")
client_search.add_order_by('name desc')
clients = client_search.get_sobjects()
pipe_search = Search("sthpw/pipeline")
pipe_search.add_filter('search_type', 'twog/title')
pipelines = pipe_search.get_sobjects()
client_pull = SelectWdg('tadd_client_pull')
client_name = ''
if len(clients) > 0:
client_pull.append_option('--Select--', 'NOTHINGXsXNOTHING')
for client in clients:
client_pull.append_option(client.get_value('name'), '%sXsX%s' % (client.get_value('code'),client.get_value('name')))
if client.get_value('code') == my.client_code:
client_name = client.get_value('name')
client_name_pull = '%sXsX%s' % (client.get_value('code'), client.get_value('name'))
client_pull.set_value(client_name_pull)
client_pull.add_behavior(get_client_change_behavior(my.order_sk))
platform_search = Search("twog/platform")
platform_search.add_order_by('name desc')
outlet_list = platform_search.get_sobjects()
outlet_pull = SelectWdg('tadd_outlet_pull')
outlet_pull.append_option('--Select--', 'NOTHINGXsXNOTHING')
for outlet in outlet_list:
outlet_pull.append_option(outlet.get_value('name'), outlet.get_value('name'))
pipe_pull = SelectWdg('tadd_pipe_pull')
if len(pipelines) > 0:
pipe_pull.append_option('--Select--', 'NOTHINGXsXNOTHING')
for pipe in pipelines:
if not pipe.get_value('hide'):
if pipe.get_value('code').split('_')[0] == client_name:
pipe_pull.append_option(pipe.get_value('code'), pipe.get_value('code'))
for pipe in pipelines:
if not pipe.get_value('hide'):
if pipe.get_value('code').split('_')[0] != client_name:
pipe_pull.append_option(pipe.get_value('code'), pipe.get_value('code'))
pipe_pull.add_behavior(get_pipeline_change_behavior(my.order_sk))
dlv_standard_pull = SelectWdg('tadd_deliverable_standard')
dlv_standard_pull.append_option('--Select--', 'NOTHINGXsXNOTHING')
for s in my.standards:
dlv_standard_pull.append_option(s, s)
dlv_format_pull = SelectWdg('tadd_deliverable_format')
dlv_format_pull.append_option('--Select--', 'NOTHINGXsXNOTHING')
for f in my.formats:
dlv_format_pull.append_option(f, f)
dlv_aspect_ratio_pull = SelectWdg('tadd_deliverable_aspect_ratio')
dlv_aspect_ratio_pull.append_option('--Select--', 'NOTHINGXsXNOTHING')
for a in my.aspect_ratios:
dlv_aspect_ratio_pull.append_option(a, a)
dlv_frame_rate_pull = SelectWdg('tadd_deliverable_frame_rate')
dlv_frame_rate_pull.append_option('--Select--', 'NOTHINGXsXNOTHING')
for f in my.frame_rates:
dlv_frame_rate_pull.append_option(f, f)
status_triggers_pull = SelectWdg('tadd_status_triggers')
for f in ['Yes', 'No']:
status_triggers_pull.append_option(f, f)
priority_triggers_pull = SelectWdg('tadd_priority_triggers')
for f in ['Yes', 'No']:
priority_triggers_pull.append_option(f, f)
table.add_row()
t1 = table.add_cell('Territory: ')
t2 = table.add_cell(territory_sel)
t1.add_attr('align', 'left')
t2.add_attr('colspan', '6')
t2.add_attr('align', 'left')
table.add_row()
t1 = table.add_cell('Language: ')
t2 = table.add_cell(language_sel)
t1.add_attr('align', 'left')
t2.add_attr('colspan', '6')
t2.add_attr('align', 'left')
table.add_row()
c1 = table.add_cell('Client: ')
c2 = table.add_cell(client_pull)
c1.add_attr('align', 'left')
c2.add_attr('colspan', '6')
c2.add_attr('align', 'left')
table.add_row()
o1 = table.add_cell('Platform: ')
o2 = table.add_cell(outlet_pull)
o1.add_attr('align', 'left')
o2.add_attr('colspan', '6')
o2.add_attr('align', 'left')
table.add_row()
r1 = table.add_cell('Title Id Num: ')
r2 = table.add_cell('<input type="text" class="tadd_title_id_number"/>')
r1.add_attr('align', 'left')
r2.add_attr('colspan', '6')
r2.add_attr('align', 'left')
table.add_row()
w1 = table.add_cell('Total Program Run Time: ')
w2 = table.add_cell('<input type="text" class="tadd_total_program_run_time"/>')
w1.add_attr('align', 'left')
w2.add_attr('colspan', '6')
w2.add_attr('align', 'left')
table.add_row()
z1 = table.add_cell('Total Run Time w/ Textless: ')
z2 = table.add_cell('<input type="text" class="tadd_total_run_time_with_textless"/>')
z1.add_attr('align', 'left')
z2.add_attr('colspan', '6')
z2.add_attr('align', 'left')
table.add_row()
p1 = table.add_cell('Pipeline: ')
p2 = table.add_cell(pipe_pull)
p1.add_attr('align', 'left')
p2.add_attr('colspan', '6')
p2.add_attr('align', 'left')
table.add_row()
sd = table.add_cell('Start Date: ')
sd.add_attr('nowrap', 'nowrap')
start = CalendarInputWdg("tadd_start_date")
if the_order.get_value('start_date') not in [None,'']:
start.set_option('default', fix_date(the_order.get_value('start_date')))
start.set_option('show_activator', True)
start.set_option('show_confirm', False)
start.set_option('show_text', True)
start.set_option('show_today', False)
start.set_option('read_only', False)
start.get_top().add_style('width: 150px')
start.set_persist_on_submit()
start_date = table.add_cell(start)
start_date.add_attr('colspan', '7')
start_date.add_attr('nowrap', 'nowrap')
table.add_row()
ed = table.add_cell('Due Date: ')
ed.add_attr('nowrap','nowrap')
end = CalendarInputWdg("tadd_due_date")
if the_order.get_value('due_date') not in [None,'']:
end.set_option('default', fix_date(the_order.get_value('due_date')))
end.set_option('show_activator', True)
end.set_option('show_confirm', False)
end.set_option('show_text', True)
end.set_option('show_today', False)
end.set_option('read_only', False)
end.get_top().add_style('width: 150px')
end.set_persist_on_submit()
end_date = table.add_cell(end)
end_date.add_attr('colspan', '7')
end_date.add_attr('nowrap', 'nowrap')
table.add_row()
rm = table.add_cell('Revenue Month: ')
rm.add_attr('nowrap','nowrap')
rem = CalendarInputWdg("tadd_rm_date")
if the_order.get_value('expected_delivery_date') not in [None,'']:
rem.set_option('default', fix_date(the_order.get_value('expected_delivery_date')))
rem.set_option('show_activator', True)
rem.set_option('show_confirm', False)
rem.set_option('show_text', True)
rem.set_option('show_today', False)
rem.set_option('read_only', False)
rem.get_top().add_style('width: 150px')
rem.set_persist_on_submit()
rem_date = table.add_cell(rem)
rem_date.add_attr('colspan', '7')
rem_date.add_attr('nowrap', 'nowrap')
table.add_row()
r8 = table.add_cell('Expected Price: ')
r9 = table.add_cell('<input type="text" class="tadd_expected_price"/>')
r8.add_attr('align', 'left')
r9.add_attr('colspan', '6')
r9.add_attr('align', 'left')
table.add_row()
taa = table.add_cell('Description')
taa.add_attr('valign', 'top')
ta1 = table.add_cell('<textarea cols="50" rows="10" class="tadd_description"></textarea>')
ta1.add_attr('colspan', '6')
table.add_row()
s1 = table.add_cell('Deliverable Standard: ')
s2 = table.add_cell(dlv_standard_pull)
s1.add_attr('align', 'left')
s2.add_attr('colspan', '6')
s2.add_attr('align', 'left')
table.add_row()
s1 = table.add_cell('Deliverable Aspect Ratio: ')
s2 = table.add_cell(dlv_aspect_ratio_pull)
s1.add_attr('align', 'left')
s2.add_attr('colspan', '6')
s2.add_attr('align', 'left')
table.add_row()
s1 = table.add_cell('Deliverable Frame Rate: ')
s2 = table.add_cell(dlv_frame_rate_pull)
s1.add_attr('align', 'left')
s2.add_attr('colspan', '6')
s2.add_attr('align', 'left')
table.add_row()
s1 = table.add_cell('Deliverable Format: ')
s2 = table.add_cell(dlv_format_pull)
s1.add_attr('align', 'left')
s2.add_attr('colspan', '6')
s2.add_attr('align', 'left')
table.add_row()
s1 = table.add_cell('Status Triggers?: ')
s2 = table.add_cell(status_triggers_pull)
s1.add_attr('align', 'left')
s2.add_attr('colspan', '6')
s2.add_attr('align', 'left')
table.add_row()
s1 = table.add_cell('Priority Triggers?: ')
s2 = table.add_cell(priority_triggers_pull)
s1.add_attr('align', 'left')
s2.add_attr('colspan', '6')
s2.add_attr('align', 'left')
table.add_row()
tca = table.add_cell('Deliverable Specs')
tca.add_attr('valign', 'top')
ta8 = table.add_cell('<textarea cols="50" rows="10" class="tadd_delivery_specs"></textarea>')
ta8.add_attr('colspan', '6')
table.add_row()
table.add_cell('Keywords')
ta2 = table.add_cell('<textarea cols="50" class="tadd_keywords"></textarea>')
ta2.add_attr('colspan', '6')
go_butt = ActionButtonWdg(tip='Create', title='Create')
go_butt.add_behavior(get_create_titles_behavior(my.order_sk, my.order_sid, my.user))
table.add_row()
bottom_butt = table.add_cell(go_butt)
bottom_butt.add_attr('colspan', '7')
bottom_butt.add_attr('align', 'center')
return table
