def description_add(request):
session = Session()
description_type_objects = session.query(DescriptionType).all()
session.close()
if description_type_objects is None:
raise Http404
description_type_choice = [(obj.id,obj.title) for obj in description_type_objects]
initial={"description_type_choice":description_type_choice,}
if request.method == 'POST':
form = DescriptionForm(request.POST,initial=initial,auto_id=False)
if form.is_valid():
description = form.save()
data = {
'description_type_id':description.description_type_id,
'description_id':description.id,
}
return HttpResponseRedirect(reverse('description_detail_add', kwargs=data))
else:
form = DescriptionForm(initial=initial,auto_id=False)
data = {'form': form,}
return render_to_response("description/description_add.html", data, context_instance=RequestContext(request))
def description_meta_item_relation_combine_add(request,description_meta_id):
session = Session()
item_relation_objects = session.query(ItemRelation).all()
description_meta_object = session.query(DescriptionMeta).get(description_meta_id)
session.close()
if description_meta_object is None:
raise Http404
item_relation_choice = [(obj.id,obj.title) for obj in item_relation_objects]
initial={"item_relation_choice":item_relation_choice,}
if request.method == 'POST':
form = DescriptionMetaItemRelationCombinationForm(request.POST,initial=initial,auto_id=False)
if form.is_valid():
id = form.save(description_meta_id = description_meta_id)
if id is not None:
data = {'template':'description/description_meta_list.html',
'ItemClass':DescriptionMeta,
'page':1,
}
return HttpResponseRedirect(reverse('description_meta_list', kwargs=data))
else:
form = DescriptionMetaItemRelationCombinationForm(initial=initial,auto_id=False)
data = {'form': form,'description_meta_object':description_meta_object}
return render_to_response("description/description_meta_item_relation_combine_add.html", data, context_instance=RequestContext(request))
def item_relation_combine_add(request,item_relation_id):
session = Session()
item_objects = session.query(Item).all()
item_relation_object = session.query(ItemRelation).get(item_relation_id)
session.close()
if item_relation_object is None:
raise Http404
item_info_list = []
for item in item_objects:
item_info_object = ItemRelationCombinationFormInfo(item_id=item.id,item_title=item.title)
item_info_list.append(item_info_object)
initial={"item_info_list":item_info_list,}
if request.method == 'POST':
form = ItemRelationCombinationForm(request.POST,initial=initial,auto_id=False)
if form.is_valid():
id = form.save(item_relation_id = item_relation_id)
if id is not None:
data = {'template':'description/item_relation_list.html',
'ItemClass':ItemRelation,
'page':1,
}
return HttpResponseRedirect(reverse('item_relation_list', kwargs=data))
else:
form = ItemRelationCombinationForm(initial=initial,auto_id=False)
data = {'form': form,'item_relation_id':item_relation_id}
return render_to_response("description/item_relation_combine_add.html", data, context_instance=RequestContext(request))
def show_list(request, template, ItemClass, page=1):
session = Session()
objects_all = session.query(ItemClass).all()
session.close()
paginator = Paginator(objects_all, settings.METAS_PER_PAGE)
try:
objects = paginator.page(objects_all)
except (EmptyPage, InvalidPage):
objects = paginator.page(paginator.num_pages)
data = {"objects": objects}
return render_to_response(template, data,
context_instance=RequestContext(request))
def description_list(request,description_type_id , page=1):
session = Session()
description_objects = session.query(Description).\
filter(Description.description_type_id == description_type_id).\
order_by(Description.id)
session.close()
paginator = Paginator(description_objects, settings.METAS_PER_PAGE)
try:
objects = paginator.page(description_objects)
except (EmptyPage, InvalidPage):
objects = paginator.page(paginator.num_pages)
data = {"objects": objects}
return render_to_response("description/description_list.html", data,
context_instance=RequestContext(request))
def description_type_list(request, description_meta_id, page=1):
session = Session()
description_meta_object = session.query(DescriptionMeta).get(description_meta_id)
session.close()
if description_meta_object is None:
raise Http404
description_type_objects = session.query(DescriptionType).filter(DescriptionType.description_meta_id == description_meta_id)
paginator = Paginator(description_type_objects, settings.METAS_PER_PAGE)
try:
objects = paginator.page(description_type_objects)
except (EmptyPage, InvalidPage):
objects = paginator.page(paginator.num_pages)
data = {"objects": objects,"description_meta_object":description_meta_object}
return render_to_response("description/description_type_list.html", data,
context_instance=RequestContext(request))
def save(self, commit=True, update=False,item_relation_combination_id=None,item_relation_id=None,):
item_relation_combination_objects = []
choice_list = []
for item_info in self.item_info_list:
field_info_list = self.cleaned_data[item_info.title_field_name].split(',')
choice_list.append(field_info_list[0])
if field_info_list[0] == 'True' :
if field_info_list[1] != 'None' and field_info_list[2] != 'None':
item_relation_combination = ItemRelationCombination(item_id = item_info.item_id,
item_relation_id = item_relation_id,
combination_number = int(field_info_list[1]),
show_order = int(field_info_list[2]),
)
item_relation_combination_objects.append(item_relation_combination)
else:
return None
if not 'True' in choice_list:
return None
session = Session()
session.add_all(item_relation_combination_objects)
session.commit()
session.close()
return item_relation_id
def description_type_detail(request,description_type_id):
session = Session()
description_type_object = session.query(DescriptionType).get(description_type_id)
description_meta_object = session.query(DescriptionMeta).get(description_type_object.description_meta_id)
if description_type_object is None or description_meta_object is None:
raise Http404
objs_in_relation = session.query(DescriptionTypeItemRelationCombination).\
filter(DescriptionTypeItemRelationCombination.description_type_id == description_type_id).\
order_by(DescriptionTypeItemRelationCombination.show_order)
description_type_item_relation_detail_object_list = []
for obj in objs_in_relation:
item_relation_object = session.query(ItemRelation).get(obj.item_relation_id)
item_relation_detail_object = DescriptionTypeItemRelationViewDetail(item_relation_id = item_relation_object.id,
item_relation_title = item_relation_object.title,
multi_number = obj.multi_number,
show_order = obj.show_order,
)
description_type_item_relation_detail_object_list.append(item_relation_detail_object)
session.close()
data = {'description_type_object':description_type_object,
'description_meta_object':description_meta_object,
'detail_list':description_type_item_relation_detail_object_list}
return render_to_response("description/description_type_detail.html", data, context_instance=RequestContext(request))
def save(self, commit=True, update=False,description_type_id=None,):
description_type_item_relation_combination_objects = []
choice_list = []
for obj in self.form_info_list:
field_info_list = self.cleaned_data[obj.title_field_name].split(',')
choice_list.append(field_info_list[0])
if field_info_list[0] == 'True' :
if field_info_list[1] != 'None' and field_info_list[2] != 'None':
# description_type_item_relation_combination --> obj_dtitrc
obj_dtitrc = DescriptionTypeItemRelationCombination(description_type_id = description_type_id,
item_relation_id = obj.item_relation_id,
multi_number = int(field_info_list[1]),
show_order = int(field_info_list[2]),
relation_items_number = obj.relation_items_number,
)
description_type_item_relation_combination_objects.append(obj_dtitrc)
else:
return None
if not 'True' in choice_list:
return None
session = Session()
session.add_all(description_type_item_relation_combination_objects)
session.commit()
session.close()
return description_type_id
def description_type_add(request, description_meta_id):
session = Session()
description_meta_object = session.query(DescriptionMeta).get(description_meta_id)
session.close()
if description_meta_object is None:
raise Http404
if request.method == 'POST':
form = DescriptionTypeForm(request.POST)
if form.is_valid():
description_type = form.save(description_meta_id=description_meta_id)
data = {'description_type_id':description_type.id, }
return HttpResponseRedirect(reverse('description_type_item_relation_combine_add', kwargs=data))
else:
form = DescriptionTypeForm()
data = {'form': form, 'description_meta_id':description_meta_id}
return render_to_response("description/description_type_add.html", data, context_instance=RequestContext(request))
def description_show(request,description_id):
session = Session()
description_object = session.query(Description).get(description_id)
description_detail_objects = session.query(DescriptionDetail).\
filter(DescriptionDetail.description_id == description_id).\
order_by(DescriptionDetail.show_order)
if description_object is None or description_detail_objects is None:
raise Http404
relation_show_order = description_detail_objects[0].relation_show_order
item_id = description_detail_objects[0].items_id
item_object = session.query(Item).get(item_id)
html_string = '<div class="relation_show_order %s">' % (description_detail_objects[0].relation_show_order)
change_relation = False
html_string += ('<span class="group_item_id %s">%s : ' % (item_id,item_object.title)) \
+ description_detail_objects[0].content + '</span>'
for obj in description_detail_objects[1:]:
if relation_show_order != obj.relation_show_order:
relation_show_order = obj.relation_show_order
change_relation = True
item_object = session.query(Item).get(obj.items_id)
html_string += '</div><div class="relation_show_order %s"><span class="group_item_id %s">%s : ' \
% (obj.relation_show_order,obj.items_id,item_object.title)
else:
change_relation = False
if change_relation == False:
if item_id != obj.items_id:
item_object = session.query(Item).get(obj.items_id)
html_string += '</span><br /><span class="group_item_id %s">%s : ' % (obj.items_id,item_object.title)
else:
html_string += ' '
item_id = obj.items_id
html_string += ('<span class = "item_id %s">' % (item_id) ) + obj.content + '</span>'
html_string += '</div>'
session.close()
data = {"html_string":html_string}
return render_to_response("description/description_show.html", data, context_instance=RequestContext(request))
def save(self, commit=True, update=False,description_meta_id=None):
session = Session()
if update:
description_meta = session.query(DescriptionMeta).get(description_meta_id)
else:
description_meta = DescriptionMeta()
description_meta.title = self.cleaned_data['title']
if not update:
session.add(description_meta)
session.commit()
description_meta.id = description_meta.id
session.close()
return description_meta
def save(self, commit=True, update=False,item_relation_id=None):
session = Session()
if update:
item_relation = session.query(ItemRelation).get(item_relation_id)
else:
item_relation = ItemRelation()
item_relation.title = self.cleaned_data['title']
if not update:
session.add(item_relation)
session.commit()
item_relation.id = item_relation.id
session.close()
return item_relation
def description_type_item_relation_combine_add(request,description_type_id):
session = Session()
description_type_object = session.query(DescriptionType).get(description_type_id)
if description_type_object is None:
raise Http404
description_meta_id = description_type_object.description_meta_id
description_meta_object = session.query(DescriptionMeta).get(description_meta_id)
if description_meta_object is None:
raise Http404
objs_in_relation = session.query(DescriptionMetaItemRelationCombination).filter(DescriptionMetaItemRelationCombination.description_meta_id == description_meta_id)
form_info_list = []
for obj in objs_in_relation:
item_relation_object = session.query(ItemRelation).get(obj.item_relation_id)
objs_in_relation_combination = session.query(ItemRelationCombination).filter(ItemRelationCombination.item_relation_id == item_relation_object.id)
relation_items_number = 0
for o in objs_in_relation_combination:
relation_items_number += o.combination_number
form_info_obj = DescriptionMetaItemRelationCombinationFormInfo(item_relation_id = item_relation_object.id,
item_relation_title = item_relation_object.title,
relation_items_number = relation_items_number
)
form_info_list.append(form_info_obj)
session.close()
initial={"form_info_list":form_info_list,}
if request.method == 'POST':
form = DescriptionTypeItemRelationCombinationForm(request.POST,initial=initial,auto_id=False)
if form.is_valid():
id = form.save(description_type_id = description_type_id)
if id is not None:
data = {'description_meta_id':description_meta_id,'page':1}
return HttpResponseRedirect(reverse('description_type_list', kwargs=data))
else:
form = DescriptionTypeItemRelationCombinationForm(initial=initial,auto_id=False)
data = {'form': form,'description_type_id':description_type_id}
return render_to_response("description/description_type_item_relation_combine_add.html", data, context_instance=RequestContext(request))
def save(self, commit=True, update=False,):
description = Description()
description.description_type_id = self.cleaned_data['description_type']
description.title = self.cleaned_data['title']
session = Session()
session.add(description)
session.commit()
description.id = description.id
session.close()
return description
def save(self, commit=True, update=False,
description_meta_item_relation_combination_id=None,description_meta_id=None,):
description_meta_item_relation_combination_objects = []
for item_relation_id in self.cleaned_data['item_relations']:
obj_dmitrc = DescriptionMetaItemRelationCombination(description_meta_id = description_meta_id,
item_relation_id = item_relation_id,
)
description_meta_item_relation_combination_objects.append(obj_dmitrc)
session = Session()
session.add_all(description_meta_item_relation_combination_objects)
session.commit()
session.close()
return description_meta_id
def save(self, commit=True, update=False,description_type_id=None,description_id=None):
description_detail_object_list = []
for obj in self.description_detail_info_list:
content = self.cleaned_data[obj.title_field_name]
description_detail = DescriptionDetail(description_type_id = description_type_id,
description_id = description_id,
item_relation_id = obj.relation_id,
items_id = obj.item_id,
relation_show_order = obj.relation_show_order,
show_order = obj.item_show_order,
content = content,
)
description_detail_object_list.append(description_detail)
session = Session()
session.add_all(description_detail_object_list)
session.commit()
session.close()
return description_id
def item_relation_detail(request,item_relation_id):
session = Session()
item_relation_object = session.query(ItemRelation).get(item_relation_id)
items_in_relation = session.query(ItemRelationCombination).filter(ItemRelationCombination.item_relation_id == item_relation_id)
item_relation_detail_object_list = []
for i_in_relation in items_in_relation:
item_object = session.query(Item).get(i_in_relation.item_id)
item_relation_detail_object = ItemRelationViewDetail(item_id = item_object.id,
item_title=item_object.title,
combination_number = i_in_relation.combination_number,
show_order = i_in_relation.show_order,
)
item_relation_detail_object_list.append(item_relation_detail_object)
session.close()
if item_relation_object is None:
raise Http404
data = {'item_relation_object':item_relation_object,'detail_list':item_relation_detail_object_list}
return render_to_response("description/item_relation_detail.html", data, context_instance=RequestContext(request))
def save(self, commit=True, update=False,item_id=None):
session = Session()
if update:
item = session.query(Item).get(item_id)
else:
item = Item()
item.title = self.cleaned_data['title']
if not update:
session.add(item)
session.commit()
item.id = item.id
#新建一个item 自动新建一个关系 和一个组合
item_relation = ItemRelation(title = item.title)
session.add(item_relation)
session.commit()
item_relation.id = item_relation.id
item_relation_combination = ItemRelationCombination(item_id =item.id,
item_relation_id = item_relation.id,
combination_number = 1,
show_order = 1,
)
session.add(item_relation_combination)
session.commit()
session.close()
return item
def description_detail_add(request, description_type_id,description_id):
session = Session()
description_type_object = session.query(DescriptionType).get(description_type_id)
description_object = session.query(Description).get(description_id)
if description_type_object is None or description_object is None:
raise Http404
#查询出这个描述类型下的所有组合
objs_in_relation = session.query(DescriptionTypeItemRelationCombination).\
filter(DescriptionTypeItemRelationCombination.description_type_id == description_type_id).\
order_by(DescriptionTypeItemRelationCombination.show_order)
description_detail_info_list = []
item_show_number = 1
relation_show_number = 1
for obj in objs_in_relation:
#得到这个描述中的一条组合，已经按照show_order排序
item_relation_object = session.query(ItemRelation).get(obj.item_relation_id)
#得到这条组合的详细信息，按show_order排序,包括item，item个数等
item_relation_combination = session.query(ItemRelationCombination).\
filter(ItemRelationCombination.item_relation_id == item_relation_object.id).\
order_by(ItemRelationCombination.show_order)
#遍历，因为组合最终是要多选的，所以根据组合多选个数增加前缀，
for i in xrange(obj.multi_number):
#此处遍历是遍历组合中的item项
for item_in_combitition in item_relation_combination:
item = session.query(Item).get(item_in_combitition.item_id)
#由于在一个组合里面，item是可以多个的，因此根据item个数，添加item，和最终具体item的显示顺序
for j in xrange(item_in_combitition.combination_number):
detail_object = DescriptionDetailFormInfo(
relation_show_order=relation_show_number,
item_show_order= item_show_number,
item_id = item.id,
relation_id = item_relation_object.id,
relation_title = item_relation_object.title,
item_title = item.title,
)
item_show_number += 1
description_detail_info_list.append(detail_object)
#一组组合结束，组合显示顺序加1
relation_show_number += 1
session.close()
initial={"description_detail_info_list":description_detail_info_list,}
if request.method == 'POST':
form = DescriptionDetailForm(request.POST,initial=initial,auto_id=False)
if form.is_valid():
id = form.save(description_type_id = description_type_id,description_id=description_id)
if id is not None:
pass
data = {'description_type_id':description_type_id,'page':1}
return HttpResponseRedirect(reverse('description_list', kwargs=data))
else:
form = DescriptionDetailForm(initial=initial,auto_id=False)
data = {'form': form,
'description_type_id':description_type_id,
'description_id':description_id,
}
return render_to_response("description/description_detail_add.html", data, context_instance=RequestContext(request))