Example #1
0
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)) 
Example #2
0
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)) 
Example #3
0
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)) 
Example #4
0
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))
Example #5
0
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))
Example #6
0
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))
Example #7
0
    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  
Example #8
0
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)) 
Example #9
0
    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  
Example #10
0
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)) 
Example #11
0
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&nbsp:&nbsp' % (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&nbsp:&nbsp' \
            % (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&nbsp:&nbsp' % (obj.items_id,item_object.title)
 
            else:
                html_string += '&nbsp'

        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)) 
Example #12
0
    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
Example #13
0
    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
Example #14
0
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)) 
Example #15
0
    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 
Example #16
0
    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  
Example #17
0
 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
Example #18
0
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)) 
Example #19
0
    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
Example #20
0
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))