Subversion Repositories SmartDukaan

Rev

Rev 629 | Rev 635 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 629 Rev 631
Line 61... Line 61...
61 
            item.mop = mop
 61 
            item.mop = mop
62 
        if dp != "":
62 
        if dp != "":
63 
            item.dealerPrice = dp
 63 
            item.dealerPrice = dp
64 
        if weight != "":
64 
        if weight != "":
65 
            item.weight = weight
 65 
            item.weight = weight
- 
 
 66 
        if start_date != "":
66 
        item.startDate = datetime.datetime(*xlrd.xldate_as_tuple(start_date, workbook.datemode))
 67 
            item.startDate = datetime.datetime(*xlrd.xldate_as_tuple(start_date, workbook.datemode))
67 
        item.bestDealText = deal_text
 68 
        item.bestDealText = deal_text
- 
 
 69 
        if deal_value != "":
68 
        item.bestDealValue = deal_value
 70 
            item.bestDealValue = deal_value
69 
        item.comments = comments
 71 
        item.comments = comments
70 
        item.updatedOn = updatedOn
 72 
        item.updatedOn = updatedOn
71 
        session.commit()
 73 
        session.commit()
72
74
73 
    session.execute("UPDATE " + str(Item.table) + " SET status=" + str(status.PHASED_OUT) + ", updatedOn='"+ str(updatedOn) +"' WHERE updatedOn <> '" + str(updatedOn) + "'", mapper=Item)
 75 
    session.execute("UPDATE " + str(Item.table) + " SET status=" + str(status.PHASED_OUT) + ", updatedOn='"+ str(updatedOn) +"' WHERE updatedOn <> '" + str(updatedOn) + "'", mapper=Item)