Subversion Repositories SmartDukaan

Rev

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

Rev 5006 Rev 5011
Line 17... Line 17...
17
from email import encoders
17
from email import encoders
18
from email.mime.text import MIMEText
18
from email.mime.text import MIMEText
19
from email.mime.base import MIMEBase
19
from email.mime.base import MIMEBase
20
from email.mime.multipart import MIMEMultipart
20
from email.mime.multipart import MIMEMultipart
21
from datetime import date
21
from datetime import date
-
 
22
from datetime import datetime, timedelta
22
 
23
 
23
 
24
 
24
DB_HOST = "192.168.190.113"
25
DB_HOST = "192.168.190.113"
25
DB_USER = "root"
26
DB_USER = "root"
26
DB_PASSWORD = "shop2020"
27
DB_PASSWORD = "shop2020"
Line 102... Line 103...
102
        sendmail(subject)
103
        sendmail(subject)
103
        exit(1)
104
        exit(1)
104
        
105
        
105
    newOrderId, codFlag, prepaidFlag, paymentOK, orderStatusFlag = getOrderTableStatus(orderIdinFile)
106
    newOrderId, codFlag, prepaidFlag, paymentOK, orderStatusFlag = getOrderTableStatus(orderIdinFile)
106
    sendmailFlag = False
107
    sendmailFlag = False
-
 
108
    
-
 
109
    timeNow = datetime.now()
-
 
110
    halfHourBack = timeNow - timedelta(minutes=30)
-
 
111
    timeString = str(timeNow.time().strftime('%H:%M')) + ' and ' + str(halfHourBack.time().strftime('%H:%M'))
-
 
112
 
107
    if not prepaidFlag :
113
    if not prepaidFlag :
108
        subject = 'No prepaid orders were placed since last check'
114
        subject = 'No prepaid orders were placed between ' + timeString
109
        sendmailFlag = True
115
        sendmailFlag = True
110
    if not codFlag :
116
    if not codFlag :
111
        subject = 'No COD orders were placed since last check'
117
        subject = 'No COD orders were placed between ' + timeString
112
        sendmailFlag = True
118
        sendmailFlag = True
113
    if not paymentOK :
119
    if not paymentOK :
114
        subject = 'There were no successful payments since last check'
120
        subject = 'There were no successful payments between ' + timeString
115
        sendmailFlag = True
121
        sendmailFlag = True
116
    if not orderStatusFlag :
122
    if not orderStatusFlag :
117
        subject = 'There were no orders placed since last check whose status was other than PAYMENT_PENDING and PAYMENT_FAILED'
123
        subject = 'There were no orders placed between ' + timeString + ' whose status was other than PAYMENT_PENDING and PAYMENT_FAILED'
118
        sendmailFlag = True
124
        sendmailFlag = True
119
    if newOrderId == orderIdinFile:
125
    if newOrderId == orderIdinFile:
120
        subject = 'WARNING : No orders were placed since last check'
126
        subject = 'WARNING : No orders were placed between ' + timeString
121
        sendmailFlag = True
127
        sendmailFlag = True
122
    else :
128
    else :
123
        try :
129
        try :
124
            f = open(FILENAME, "w")
130
            f = open(FILENAME, "w")
125
            f.write(str(newOrderId))
131
            f.write(str(newOrderId))