can help me with this Update inventory funciton, where is wrong?

[kang jia]

hi

currently i am doing this car booking website. i would like to only update our inventory one day before customer's start booking time, thus before that, i am still able to rent to other customers. E.g. if she book two month before, i can still rent this car to others within this 2 month, but one day before i need to deduct this car inventory as the next day i have to give this car to that customer.
the following is my car inventory update function. but it seems did not work in my way, as i loop through my Booking1 table to get all the start_datetime and update my inventory only if it is one day before this start_datetime. my start_datetime is in the format of "2007-12-21 17:05:05", i have changed it into seconds by using Bktime=time.mkt ime(time.strpti me(invtime,"%Y-%m-%d %H:%M:%S")). but it seems not work. can anyone help me with this. can update my car inventory only one day before the start_datetime. thanks for any kind help:)

def inventory(request):
 
    allObj=[]
    for i in Booking1.objects.all():
        #print i.booking_time
        invtime=i.start_datetime
        #t=str(invtime).split('.')[0]
        Bktime=time.mktime(time.strptime(invtime,"%Y-%m-%d %H:%M:%S"))
        #now=datetime.datetime.now()
        one_day=60*60*24
        #diff=comp_dates(t,str(now).split('.')[0])
        #print diff
        onebefore=Bktime-one_day------>>>Error,where is wrong?date type?
        if str(onebefore):
            for a in CarModel.objects.all():    
                qtyInStock=a.car_inventory
                orderQuantity = 1
                qtyLeft = int(qtyInStock) - int(orderQuantity)
                a.car_inventory=qtyLeft
                a.save()
                allObj=CarModel.objects.all()
                print allObj
                print "LLLLLLLLLLLLLLLLLL"
                return render_to_response("inventoryupdate.html", {'allObj':allObj})    
        if not str(onebefore):
            all=CarModel.objects.all()
            return render_to_response("inventory.html",{'all':all})
 

[bvdet]

hi

currently i am doing this car booking website. i would like to only update our inventory one day before customer's start booking time, thus before that, i am still able to rent to other customers. E.g. if she book two month before, i can still rent this car to others within this 2 month, but one day before i need to deduct this car inventory as the next day i have to give this car to that customer.
the following is my car inventory update function. but it seems did not work in my way, as i loop through my Booking1 table to get all the start_datetime and update my inventory only if it is one day before this start_datetime. my start_datetime is in the format of "2007-12-21 17:05:05", i have changed it into seconds by using Bktime=time.mkt ime(time.strpti me(invtime,"%Y-%m-%d %H:%M:%S")). but it seems not work. can anyone help me with this. can update my car inventory only one day before the start_datetime. thanks for any kind help:)

def inventory(request):
 
    allObj=[]
    for i in Booking1.objects.all():
        #print i.booking_time
        invtime=i.start_datetime
        #t=str(invtime).split('.')[0]
        Bktime=time.mktime(time.strptime(invtime,"%Y-%m-%d %H:%M:%S"))
        #now=datetime.datetime.now()
        one_day=60*60*24
        #diff=comp_dates(t,str(now).split('.')[0])
        #print diff
        onebefore=Bktime-one_day------>>>Error,where is wrong?date type?
        if str(onebefore):
            for a in CarModel.objects.all():    
                qtyInStock=a.car_inventory
                orderQuantity = 1
                qtyLeft = int(qtyInStock) - int(orderQuantity)
                a.car_inventory=qtyLeft
                a.save()
                allObj=CarModel.objects.all()
                print allObj
                print "LLLLLLLLLLLLLLLLLL"
                return render_to_response("inventoryupdate.html", {'allObj':allObj})    
        if not str(onebefore):
            all=CarModel.objects.all()
            return render_to_response("inventory.html",{'all':all})
 

The way you have calculated onebefore, it will always evaluate to True. I think you should calculate the difference between the date the car has been rented and the present date, and if the difference is greater than one day, keep the car in inventory, otherwise remove it.

[kang jia]

The way you have calculated onebefore, it will always evaluate to True. I think you should calculate the difference between the date the car has been rented and the present date, and if the difference is greater than one day, keep the car in inventory, otherwise remove it.

hi, thanks for it, i have done according to this logic and i feel it is correct. but it got small error. my code is in the following:

def inventory(request):
 
    allObj=[]
    for i in Booking1.objects.all():
        #print i.booking_time
        invtime=i.start_datetime
        now=datetime.datetime.now()
        one_day=60*60*24
        diff=comp_dates(invtime,str(now).split('.')[0])
        print diff
        print"LLLLLLLLLLLLLLLLLPPPPPPPPPPPPPPPPPJ"
        if diff < one_day:
            for a in CarModel.objects.all():    
                qtyInStock=a.car_inventory
                orderQuantity = 1
                qtyLeft = int(qtyInStock) - int(orderQuantity)
                a.car_inventory=qtyLeft
                a.save()
                allObj=CarModel.objects.all()
                print allObj
                print "LLLLLLLLLLLLLLLLLL"
                return render_to_response("inventoryupdate.html", {'allObj':allObj})    
        if not diff < one_day:
                all=CarModel.objects.all()
                return render_to_response("inventory.html",{'all':all})
 

my error is:

Request Method: GET
Request URL: http://localhost:8000/inventoryupdate/
Exception Type: TypeError
Exception Value: expected string or buffer
Exception Location: C:\Python25\lib \_strptime.py in strptime, line 328
Python Executable: C:\Python25\pyt hon.exe

i think there is some TypeError, but i am not sure where? can help me with this, thanks in advance. i believe it is just a small step to success..haha

[kang jia]

The way you have calculated onebefore, it will always evaluate to True. I think you should calculate the difference between the date the car has been rented and the present date, and if the difference is greater than one day, keep the car in inventory, otherwise remove it.

hi, thanks for it, i have done according to this logic and i feel it is correct. but it got small error. my code is in the following:

def inventory(request):
 
    allObj=[]
    for i in Booking1.objects.all():
        #print i.booking_time
        invtime=i.start_datetime
        now=datetime.datetime.now()
        one_day=60*60*24
        diff=comp_dates(invtime,str(now).split('.')[0])
        print diff
        print"LLLLLLLLLLLLLLLLLPPPPPPPPPPPPPPPPPJ"
        if diff < one_day:
            for a in CarModel.objects.all():    
                qtyInStock=a.car_inventory
                orderQuantity = 1
                qtyLeft = int(qtyInStock) - int(orderQuantity)
                a.car_inventory=qtyLeft
                a.save()
                allObj=CarModel.objects.all()
                print allObj
                print "LLLLLLLLLLLLLLLLLL"
                return render_to_response("inventoryupdate.html", {'allObj':allObj})    
        if not diff < one_day:
                all=CarModel.objects.all()
                return render_to_response("inventory.html",{'all':all})
 

my error is:

Request Method: GET
Request URL: http://localhost:8000/inventoryupdate/
Exception Type: TypeError
Exception Value: expected string or buffer
Exception Location: C:\Python25\lib \_strptime.py in strptime, line 328
Python Executable: C:\Python25\pyt hon.exe

i think there is some TypeError, but i am not sure where? can help me with this, thanks in advance. i believe it is just a small step to success..haha

[kang jia]

The way you have calculated onebefore, it will always evaluate to True. I think you should calculate the difference between the date the car has been rented and the present date, and if the difference is greater than one day, keep the car in inventory, otherwise remove it.

hi, thanks for it, i have done according to this logic and i feel it is correct. but it got small error. my code is in the following:

def inventory(request):
 
    allObj=[]
    for i in Booking1.objects.all():
        #print i.booking_time
        invtime=i.start_datetime
        now=datetime.datetime.now()
        one_day=60*60*24
        diff=comp_dates(invtime,str(now).split('.')[0])
        print diff
        print"LLLLLLLLLLLLLLLLLPPPPPPPPPPPPPPPPPJ"
        if diff < one_day:
            for a in CarModel.objects.all():    
                qtyInStock=a.car_inventory
                orderQuantity = 1
                qtyLeft = int(qtyInStock) - int(orderQuantity)
                a.car_inventory=qtyLeft
                a.save()
                allObj=CarModel.objects.all()
                print allObj
                print "LLLLLLLLLLLLLLLLLL"
                return render_to_response("inventoryupdate.html", {'allObj':allObj})    
        if not diff < one_day:
                all=CarModel.objects.all()
                return render_to_response("inventory.html",{'all':all})
 

my error is:

Request Method: GET
Request URL: http://localhost:8000/inventoryupdate/
Exception Type: TypeError
Exception Value: expected string or buffer
Exception Location: C:\Python25\lib \_strptime.py in strptime, line 328
Python Executable: C:\Python25\pyt hon.exe

i think there is some TypeError, but i am not sure where? can help me with this, thanks in advance. i believe it is just a small step to success..haha

[bvdet]

Check the type of object returned by:

invtime=i.start_datetime

[kang jia]

Check the type of object returned by:

invtime=i.start_datetime

i have checked its datatype, it is datetime.dateti me. so i use str() to change its data type back to string and thus can compare: my change code is in the following and it works. however, i think there is an logic error, as everytime i click update inventory link, it will deduct inventory one more time. this function is mainly for admin or staff user. if one staff click this link to see the inventory in warehouse, it deduct one already, then within next second, another staff come and click again to view inventory. it deduct one again, which is wrong and inventory is not accurate. how can i solve this issue.....can kindly help me with this.....

def inventory(request):
 
    allObj=[]
    for i in Booking1.objects.all():
        #print i.booking_time
        invtime=i.start_datetime
        #start_datetime = datetime.datetime(*strptime(invtime,"%Y-%m-%dT%H:%M:%S")[0:6])
        print invtime
        print type(invtime)
        print"KKKKKKKKKKKKKKKK"
        now=datetime.datetime.now()
        one_day=60*60*24
        diff=comp_dates(str(invtime),str(now).split('.')[0])
        print diff
        print"LLLLLLLLLLLLLLLLLPPPPPPPPPPPPPPPPPJ"
 
        if diff < one_day:
            for a in CarModel.objects.all():    
                qtyInStock=a.car_inventory
                orderQuantity = 1
                qtyLeft = int(qtyInStock) - int(orderQuantity)
                a.car_inventory=qtyLeft
                a.save()
                allObj=CarModel.objects.all()
                print allObj
                print "LLLLLLLLLLLLLLLLLL"
                return render_to_response("inventoryupdate.html", {'allObj':allObj})    
        if not diff < one_day:
                all=CarModel.objects.all()
                return render_to_response("inventory.html",{'all':all})
 
 

thanks so much for your kind help.

[bvdet]

It seems to me that you need a Booking1.object attribute that can be checked to determine if it has been applied to the existing inventory.

if diff < one_day and Booking1.object.deducted_from_inventory == False:

[kang jia]

It seems to me that you need a Booking1.object attribute that can be checked to determine if it has been applied to the existing inventory.

if diff < one_day and Booking1.object.deducted_from_inventory == False:

i think i need to create one more datebase table and its type should boolean.so when it deducts, i should turn it to true. and when it does not deducts, the default setting should be false. if my understanding is not wrong, i believe this should be the correct way. i will try to do now, thanks so much for giving me this bright idea. i will try now and let you know later. :)

[kang jia]

i have tried it, in fact car inventory is in CarModel table which is separated from Booking1 table, as i have normalized the database table. Thus i edited the code in the following and i think it works.

def inventory(request):
 
    allObj=[]
    for i in Booking1.objects.all():
        invtime=i.start_datetime
        #print invtime
        #print type(invtime)
        now=datetime.datetime.now()
        one_day=60*60*24
        diff=comp_dates(str(invtime),str(now).split('.')[0])
        print diff
        print"LLLLLLLLLLLLLLLLLPPPPPPPPPPPPPPPPPJ"
 
        #if diff < one_day and CarModel.objects.filter(inventory_deduct=0):
        for a in CarModel.objects.all():
            if a.inventory_deduct==0 and diff<one_day:
                qtyInStock=a.car_inventory
                orderQuantity = 1
                qtyLeft = int(qtyInStock) - int(orderQuantity)
                a.car_inventory=qtyLeft
                a.inventory_deduct=1
                a.save()
 
                allObj=CarModel.objects.all()
                print allObj
                print "LLLLLLLLLLLLLLLLLL"
                return render_to_response("inventoryupdate.html", {'allObj':allObj})    
            if a.inventory_deduct==1 and diff < one_day:
                all=CarModel.objects.all()
                return render_to_response("inventory.html",{'all':all})
            if diff    > one_day:
                all=CarModel.objects.all()
                return render_to_response("inventory.html",{'all':all})
 
 

i have added one field called inventory_deduc t and if it is true, it is 1 else it is 0. thus as you can see in my if statement, i have covered three possible situation. this logic is correct, right?? am i lack of any scenario?