def init(my):
search = Search(Bin)
search.add_column('type')
search.add_group_by('type')
my.set_search_for_options(search, 'type', 'type')
my.add_empty_option('-- Any --')
def init(self):
search = Search(Bin)
search.add_column('type')
search.add_group_by('type')
self.set_search_for_options(search, 'type','type')
self.add_empty_option('-- Any --')
def init(self):
search = Search(Bin)
search.add_column('label')
search.add_group_by('label')
self.set_search_for_options(search, 'label', 'label')
self.add_empty_option('-- Any --')
def init(my):
search = Search(Bin)
search.add_column('label')
search.add_group_by('label')
my.set_search_for_options(search, 'label','label')
my.add_empty_option('-- Any --')
def categorize(my, widget, search_type, search):
'''categorize parents based on search_type'''
# FIXME: this should not be here. This is a general class for all
# search types, not just prod/asset
if my.get_option('read_only') != 'true':
if search_type == "prod/asset":
lib_select = FilterSelectWdg('parent_lib')
lib_select.persistence = False
search2 = Search("prod/asset_library")
lib_select.set_search_for_options(search2, "code", "title")
lib_select.add_empty_option("-- Any --")
widget.add(lib_select)
# get all of the options for this search type
parent_lib = lib_select.get_value()
if parent_lib:
search.add_filter('asset_library', parent_lib)
elif search_type == "prod/shot":
lib_select = FilterSelectWdg('parent_lib')
lib_select.persistence = False
search2 = Search("prod/sequence")
lib_select.set_search_for_options(search2, "code", "code")
lib_select.add_empty_option("-- Any --")
widget.add(lib_select)
# get all of the options for this search type
parent_lib = lib_select.get_value()
if parent_lib:
search.add_filter('sequence_code', parent_lib)
elif search_type == 'prod/texture':
lib_select = FilterSelectWdg('parent_lib')
lib_select.persistence = False
search2 = Search("prod/texture")
search2.add_column('category')
search2.add_group_by("category")
lib_select.set_search_for_options(search2, "category",
"category")
lib_select.add_empty_option("-- Any --")
widget.add(lib_select)
# get all of the options for this search type
parent_lib = lib_select.get_value()
if parent_lib:
search.add_filter('category', parent_lib)
def categorize(my, widget, search_type, search):
'''categorize parents based on search_type'''
# FIXME: this should not be here. This is a general class for all
# search types, not just prod/asset
if my.get_option('read_only') != 'true':
if search_type == "prod/asset":
lib_select = FilterSelectWdg('parent_lib')
lib_select.persistence = False
search2 = Search("prod/asset_library")
lib_select.set_search_for_options( search2, "code", "title" )
lib_select.add_empty_option("-- Any --")
widget.add(lib_select)
# get all of the options for this search type
parent_lib = lib_select.get_value()
if parent_lib:
search.add_filter('asset_library', parent_lib)
elif search_type == "prod/shot":
lib_select = FilterSelectWdg('parent_lib')
lib_select.persistence = False
search2 = Search("prod/sequence")
lib_select.set_search_for_options( search2, "code", "code" )
lib_select.add_empty_option("-- Any --")
widget.add(lib_select)
# get all of the options for this search type
parent_lib = lib_select.get_value()
if parent_lib:
search.add_filter('sequence_code', parent_lib)
elif search_type == 'prod/texture':
lib_select = FilterSelectWdg('parent_lib')
lib_select.persistence = False
search2 = Search("prod/texture")
search2.add_column('category')
search2.add_group_by("category")
lib_select.set_search_for_options( search2, "category", "category" )
lib_select.add_empty_option("-- Any --")
widget.add(lib_select)
# get all of the options for this search type
parent_lib = lib_select.get_value()
if parent_lib:
search.add_filter('category', parent_lib)
def _get_bins(self):
search = Search(Bin)
# get all the types in the Bin table
type_search = Search(Bin)
type_search.add_column('type')
type_search.add_group_by('type')
types = SObject.get_values(type_search.get_sobjects(), 'type')
select = SelectWdg('display_limit')
select.set_option('persist', 'true')
display_limit = select.get_value()
if display_limit:
self.display_limit = display_limit
# by default, get 10 for each type
joined_statements = []
for type in types:
# TODO: fix this sql to run through search
select = Search('prod/bin')
select.add_filter("type", type)
select.set_show_retired(False)
select.add_order_by("code")
select.add_limit(self.display_limit)
statement = select.get_statement()
joined_statements.append(statement)
#joined_statements.append("select * from \"bin\" where \"type\" ='%s' and (\"s_status\" != 'retired' or \"s_status\" is NULL)" \
# " order by \"code\" desc limit %s" % (type, self.display_limit))
if len(joined_statements) > 1:
joined_statements = ["(%s)"%x for x in joined_statements]
statement = ' union all '.join(joined_statements)
elif len(joined_statements) == 1:
statement = joined_statements[0]
else:
# no bins created yet
return []
#print "statement: ", statement
return Bin.get_by_statement(statement)
def _get_bins(my):
search = Search(Bin)
# get all the types in the Bin table
type_search = Search(Bin)
type_search.add_column('type')
type_search.add_group_by('type')
types = SObject.get_values(type_search.get_sobjects(), 'type')
select = SelectWdg('display_limit')
select.set_option('persist', 'true')
display_limit = select.get_value()
if display_limit:
my.display_limit = display_limit
# by default, get 10 for each type
joined_statements = []
for type in types:
# TODO: fix this sql to run through search
select = Search('prod/bin')
select.add_filter("type", type)
select.set_show_retired(False)
select.add_order_by("code")
select.add_limit(my.display_limit)
statement = select.get_statement()
joined_statements.append(statement)
#joined_statements.append("select * from \"bin\" where \"type\" ='%s' and (\"s_status\" != 'retired' or \"s_status\" is NULL)" \
# " order by \"code\" desc limit %s" % (type, my.display_limit))
if len(joined_statements) > 1:
joined_statements = ["(%s)" % x for x in joined_statements]
statement = ' union all '.join(joined_statements)
elif len(joined_statements) == 1:
statement = joined_statements[0]
else:
# no bins created yet
return []
#print "statement: ", statement
return Bin.get_by_statement(statement)
def init(my):
search = Search(CommandSObj)
search.add_column('notification_code')
search.add_group_by('notification_code')
my.set_search_for_options(search, 'notification_code','notification_code')
def init(my):
search = Search(CommandSObj)
search.add_column('notification_code')
search.add_group_by('notification_code')
my.set_search_for_options(search, 'notification_code',
'notification_code')
