def dist(self): db = DB() if (request.method == "GET"): hostSite = db.getHostSiteByName(request.params['hostSiteName']) orderList = db.getAllOrdersByHostSite(hostSite.get('id'), request.params['sortid']) return Sale.toDistList(orderList, request.params['hostSiteName'])
def toCashSaleList(orders, hostSiteName): tableStr = "<table class=\"table\" id=\"usersTable\" style=\"background-color:white;cursor: pointer; cursor: hand; \"><thread><tr id=\"info\"><th>Pickup Site</th><th>Pickup Date</th><th>Customer</th><th>Phone</th><th>Email</th><th>No. Small</th><th>No. Large</th><th>Paid</th><th>Donation</th><th>Ordered On</th></tr></thread><tbody>" #calls to database is made to get the name of the hostsite db = DB() hostSite = db.getHostSiteByName(hostSiteName) #This for loop loops through the list of dictionaries and selects certain values to add to the table for order in orders: if str(order.get('hostsitecreated_idFK', '')) != str( hostSite.get('id')): continue tableStr += "<tr id=\"" + str(order.get('id')) + "\">" tableStr += "<td>" + hostSiteName + "</td>" tableStr += "<td>" + str(order.get('distribution_date')) + "</td>" tableStr += "<td>" + str( order.get('customer_first_name')) + " " + str( order.get('customer_last_name')) + "</td>" tableStr += "<td>" + str(order.get('customer_phone')) + "</td>" tableStr += "<td>" + str(order.get('customer_email')) if str(order.get('email_notifications')) == "1": tableStr += " (Notifications)</td>" else: tableStr += "</td>" tableStr += "<td>" + str(order.get('small_quantity')) + "</td>" tableStr += "<td>" + str(order.get('large_quantity')) + "</td>" tableStr += "<td>" + str(order.get('total_paid')) + "</td>" cost = 20.0 * float(order.get('large_quantity', 0)) + 15.0 * float( order.get('small_quantity', 0)) owe = cost - float(order.get('total_paid', 0.00)) tableStr += "<td>" + str(order.get('donation')) if str(order.get('donation_receipt')) == "1": tableStr += " (Reciept)</td>" else: tableStr += "</td>" tableStr += "<td>" + str(order.get('creation_date')) + "</td>" tableStr += "</td></tr>" tableStr += "</tbody></table>" return tableStr
def toCashSaleList(orders, hostSiteName): tableStr = "<table class=\"table\" id=\"usersTable\" style=\"background-color:white;cursor: pointer; cursor: hand; \"><thread><tr id=\"info\"><th>Pickup Site</th><th>Pickup Date</th><th>Customer</th><th>Phone</th><th>Email</th><th>No. Small</th><th>No. Large</th><th>Paid</th><th>Donation</th><th>Ordered On</th></tr></thread><tbody>" #calls to database is made to get the name of the hostsite db = DB() hostSite = db.getHostSiteByName(hostSiteName) #This for loop loops through the list of dictionaries and selects certain values to add to the table for order in orders: if str(order.get('hostsitecreated_idFK','')) != str(hostSite.get('id')): continue; tableStr += "<tr id=\"" + str(order.get('id')) + "\">" tableStr += "<td>" + hostSiteName +"</td>" tableStr += "<td>" + str(order.get('distribution_date')) +"</td>" tableStr += "<td>" + str(order.get('customer_first_name')) + " " + str(order.get('customer_last_name')) +"</td>" tableStr += "<td>" + str(order.get('customer_phone')) +"</td>" tableStr += "<td>" + str(order.get('customer_email')) if str(order.get('email_notifications')) == "1": tableStr += " (Notifications)</td>" else: tableStr += "</td>" tableStr += "<td>" + str(order.get('small_quantity')) +"</td>" tableStr += "<td>" + str(order.get('large_quantity')) +"</td>" tableStr += "<td>" + str(order.get('total_paid')) +"</td>" cost = 20.0 * float(order.get('large_quantity', 0)) + 15.0 * float(order.get('small_quantity', 0)) owe = cost - float(order.get('total_paid', 0.00)) tableStr += "<td>" + str(order.get('donation')) if str(order.get('donation_receipt')) == "1": tableStr += " (Reciept)</td>" else: tableStr += "</td>" tableStr += "<td>" + str(order.get('creation_date')) +"</td>" tableStr += "</td></tr>" tableStr += "</tbody></table>" return tableStr
def dist(self): db = DB() if request.method == "GET": hostSite = db.getHostSiteByName(request.params["hostSiteName"]) orderList = db.getAllOrdersByHostSite(hostSite.get("id"), request.params["sortid"]) return Sale.toDistList(orderList, request.params["hostSiteName"])
def toDistList(orders, hostSiteName): tableStr = "<div class=\"input-group\" style=\"padding-top: 0;margin-bottom: 5px; margin-top: 0; padding-left: 0\"><span class=\"input-group-addon\">Filter</span><input id=\"filterbox\" type=\"text\" class=\"form-control\" placeholder=\"Type here to filter the table (by sites, dates, names, etc.)\"></div>" tableStr += "<table class=\"table\" id=\"usersTable\" style=\"background-color:white;cursor: pointer; cursor: hand; \"><thread><tr id=\"info\"><th>Pickup Site</th><th>Pickup Date</th><th>Customer</th><th>Phone</th><th>Email</th><th>No. Small</th><th>No. Large</th><th>Paid</th><th>Ordered On</th><th></th></tr></thread><tbody class=\"searchable\">" #calls to database is made to get the name of the hostsite db = DB() hostSite = db.getHostSiteByName(hostSiteName) #This for loop loops through the list of dictionaries and selects certain values to add to the table for order in orders: is_not_overdue = False d_date = datetime.datetime.strptime(order.get('distribution_date'), '%Y-%m-%d') - datetime.timedelta(days=12) current_date = datetime.datetime.today() if (current_date < d_date): is_not_overdue = True # if str(order.get('hostsitepickup_idFK','')) != str(hostSite.get('id')): # continue; tableStr += "<tr id=\"" + str(order.get('id')) + "\">" tableStr += "<td>" + hostSiteName +"</td>" tableStr += "<td>" + str(order.get('distribution_date')) +"</td>" tableStr += "<td>" + str(order.get('customer_first_name')) + " " + str(order.get('customer_last_name')) +"</td>" tableStr += "<td>" + str(order.get('customer_phone')) +"</td>" tableStr += "<td>" + str(order.get('customer_email')) if str(order.get('email_notifications')) == "1": tableStr += " (Notifications)</td>" else: tableStr += "</td>" tableStr += "<td>" + str(order.get('small_quantity')) +"</td>" tableStr += "<td>" + str(order.get('large_quantity')) +"</td>" if float(order.get('total_paid')) > 0.0: isPaid = "Paid" buttonType = "success" else: isPaid = "Unpaid" if (is_not_overdue): buttonType = "primary" else: buttonType = "warning" tableStr += "<td><button id=\"paid_" + str(order.get('id')) + "\" type=\"button\" class=\"label label-"+ buttonType + "\">" + isPaid +"</td>" cost = 20.0 * float(order.get('large_quantity', 0)) + 15.0 * float(order.get('small_quantity', 0)) owe = cost - float(order.get('total_paid', 0.00)) # tableStr += "<td>" + str(owe) +"</td>" # # tableStr += "<td>" + str(order.get('donation')) if str(order.get('donation_receipt')) == "1": tableStr += " (Reciept)</td>" else: tableStr += "</td>" tableStr += "<td>" + str(order.get('creation_date')) +"</td>" tableStr += "</td>" tableStr += "<td><button id=\"delete_" + str(order.get('id')) + "\" type=\"button\" class=\"btn btn-danger\" onclick=\"deleteClicked(event);\">Delete</button></td>" tableStr += "</tr>" tableStr += "</tbody></table>" return tableStr
def __init__(self, orderId, creationDate, distributionDate, customerFirstName, customerLastName, customerEmail, customerPhone, emailNotifications, smallQuantity, largeQuantity, donation, donationReceipt, totalPaid, hostsitepickupIdFK, hostsitecreatedIdFK, customerID): values = [None,''] #basic error checking is done. If a parameter is an empty string or None it is set to a default vaule if orderId in values: self.orderId = None else: self.orderId = orderId if distributionDate in values: self.distributionDate = None else: # mm/dd/yyyy parts = distributionDate.split('-') d = datetime.date(int(parts[0]),int(parts[1]),int(parts[2])) self.distributionDate = d if creationDate in values: self.creationDate = None else: # mm/dd/yyyy parts = creationDate.split('-') d = datetime.date(int(parts[0]),int(parts[1]),int(parts[2])) self.creationDate = d if customerFirstName in values: self.customerFirstName = None else: self.customerFirstName = customerFirstName if customerLastName in values: self.customerLastName = None else: self.customerLastName = customerLastName if customerEmail in values: self.customerEmail = '' else: self.customerEmail = customerEmail if customerPhone in values: self.customerPhone = '' else: self.customerPhone = customerPhone if emailNotifications in values: self.emailNotifications = 0 else: self.emailNotifications = emailNotifications if smallQuantity in values: self.smallQuantity = 0 else: self.smallQuantity = smallQuantity if largeQuantity in values: self.largeQuantity = 0 else: self.largeQuantity = largeQuantity if donation in values: self.donation = 0 else: self.donation = donation if donationReceipt in values: self.donationReceipt = 0 else: self.donationReceipt = donationReceipt if totalPaid in values: self.totalPaid = 0 else: self.totalPaid = totalPaid if customerID in values: self.customerID = None else: self.customerID = customerID if hostsitepickupIdFK in values: self.hostsitepickupIdFK = None else: self.hostsitepickupIdFK = hostsitepickupIdFK if hostsitecreatedIdFK in values: self.hostsitecreatedIdFK = None elif hostsitecreatedIdFK == "-99": # this order was placed online db = DB() hostSite = db.getHostSiteByName("Online") self.hostsitecreatedIdFK = hostSite.get('id') else: self.hostsitecreatedIdFK = hostsitecreatedIdFK self.dict = {}
def toDistList(orders, hostSiteName): tableStr = "<div class=\"input-group\" style=\"padding-top: 0;margin-bottom: 5px; margin-top: 0; padding-left: 0\"><span class=\"input-group-addon\">Filter</span><input id=\"filterbox\" type=\"text\" class=\"form-control\" placeholder=\"Type here to filter the table (by sites, dates, names, etc.)\"></div>" tableStr += "<table class=\"table\" id=\"usersTable\" style=\"background-color:white;cursor: pointer; cursor: hand; \"><thread><tr id=\"info\"><th>Pickup Site</th><th>Pickup Date</th><th>Customer</th><th>Phone</th><th>Email</th><th>No. Small</th><th>No. Large</th><th>Paid</th><th>Ordered On</th><th></th></tr></thread><tbody class=\"searchable\">" #calls to database is made to get the name of the hostsite db = DB() hostSite = db.getHostSiteByName(hostSiteName) #This for loop loops through the list of dictionaries and selects certain values to add to the table for order in orders: is_not_overdue = False d_date = datetime.datetime.strptime( order.get('distribution_date'), '%Y-%m-%d') - datetime.timedelta(days=12) current_date = datetime.datetime.today() if (current_date < d_date): is_not_overdue = True # if str(order.get('hostsitepickup_idFK','')) != str(hostSite.get('id')): # continue; tableStr += "<tr id=\"" + str(order.get('id')) + "\">" tableStr += "<td>" + hostSiteName + "</td>" tableStr += "<td>" + str(order.get('distribution_date')) + "</td>" tableStr += "<td>" + str( order.get('customer_first_name')) + " " + str( order.get('customer_last_name')) + "</td>" tableStr += "<td>" + str(order.get('customer_phone')) + "</td>" tableStr += "<td>" + str(order.get('customer_email')) if str(order.get('email_notifications')) == "1": tableStr += " (Notifications)</td>" else: tableStr += "</td>" tableStr += "<td>" + str(order.get('small_quantity')) + "</td>" tableStr += "<td>" + str(order.get('large_quantity')) + "</td>" if float(order.get('total_paid')) > 0.0: isPaid = "Paid" buttonType = "success" else: isPaid = "Unpaid" if (is_not_overdue): buttonType = "primary" else: buttonType = "warning" tableStr += "<td><button id=\"paid_" + str( order.get('id') ) + "\" type=\"button\" class=\"label label-" + buttonType + "\">" + isPaid + "</td>" cost = 20.0 * float(order.get('large_quantity', 0)) + 15.0 * float( order.get('small_quantity', 0)) owe = cost - float(order.get('total_paid', 0.00)) # tableStr += "<td>" + str(owe) +"</td>" # # tableStr += "<td>" + str(order.get('donation')) if str(order.get('donation_receipt')) == "1": tableStr += " (Reciept)</td>" else: tableStr += "</td>" tableStr += "<td>" + str(order.get('creation_date')) + "</td>" tableStr += "</td>" tableStr += "<td><button id=\"delete_" + str( order.get('id') ) + "\" type=\"button\" class=\"btn btn-danger\" onclick=\"deleteClicked(event);\">Delete</button></td>" tableStr += "</tr>" tableStr += "</tbody></table>" return tableStr
def __init__(self, orderId, creationDate, distributionDate, customerFirstName, customerLastName, customerEmail, customerPhone, emailNotifications, smallQuantity, largeQuantity, donation, donationReceipt, totalPaid, hostsitepickupIdFK, hostsitecreatedIdFK, customerID): values = [None, ''] #basic error checking is done. If a parameter is an empty string or None it is set to a default vaule if orderId in values: self.orderId = None else: self.orderId = orderId if distributionDate in values: self.distributionDate = None else: # mm/dd/yyyy parts = distributionDate.split('-') d = datetime.date(int(parts[0]), int(parts[1]), int(parts[2])) self.distributionDate = d if creationDate in values: self.creationDate = None else: # mm/dd/yyyy parts = creationDate.split('-') d = datetime.date(int(parts[0]), int(parts[1]), int(parts[2])) self.creationDate = d if customerFirstName in values: self.customerFirstName = None else: self.customerFirstName = customerFirstName if customerLastName in values: self.customerLastName = None else: self.customerLastName = customerLastName if customerEmail in values: self.customerEmail = '' else: self.customerEmail = customerEmail if customerPhone in values: self.customerPhone = '' else: self.customerPhone = customerPhone if emailNotifications in values: self.emailNotifications = 0 else: self.emailNotifications = emailNotifications if smallQuantity in values: self.smallQuantity = 0 else: self.smallQuantity = smallQuantity if largeQuantity in values: self.largeQuantity = 0 else: self.largeQuantity = largeQuantity if donation in values: self.donation = 0 else: self.donation = donation if donationReceipt in values: self.donationReceipt = 0 else: self.donationReceipt = donationReceipt if totalPaid in values: self.totalPaid = 0 else: self.totalPaid = totalPaid if customerID in values: self.customerID = None else: self.customerID = customerID if hostsitepickupIdFK in values: self.hostsitepickupIdFK = None else: self.hostsitepickupIdFK = hostsitepickupIdFK if hostsitecreatedIdFK in values: self.hostsitecreatedIdFK = None elif hostsitecreatedIdFK == "-99": # this order was placed online db = DB() hostSite = db.getHostSiteByName("Online") self.hostsitecreatedIdFK = hostSite.get('id') else: self.hostsitecreatedIdFK = hostsitecreatedIdFK self.dict = {}