def get(self, member_sid): _c = CustomerModule(self.application.dc) _page = self.get_argument('page',1) _count = self.get_argument('count', 1000) #_member, _details = _c.get_details(member_sid, _page, _count) _member, _details = _c.search_detail_from_member_sid(member_sid, _page, _count) return self.render('customer_details_low.html', member=_member, details=_details)
def get(self): _trade_no = self.get_argument('no', None) _c = CustomerModule(self.application.dc) _page = self.get_argument('page',1) _count = self.get_argument('count', 1000) _member, _details = None, [] if _trade_no: _member, _details = _c.search_detail_from_trade_no(_trade_no, _page, _count) return self.render('trade_no_search.html', member=_member, details=_details)
def get(self): try: start = self.get_argument('start', '') end = self.get_argument('end', '') if end: end = end + " 23:59:59" shop_name = self.get_argument('shop_name', None) min_money = self.get_argument('min_money', 0) if min_money: min_money = int(min_money) max_money = self.get_argument('max_money', 0) if max_money: max_money = int(max_money) last_buy = self.get_argument('last_buy', None) payment_mode = self.get_argument('payment_mode', None) if last_buy: last_buy = datetime.datetime.now() - datetime.timedelta(days=int(last_buy)+1) categories = self.get_arguments('categories', None) is_refund = self.get_argument('is_refund', '') phone = self.get_argument('mobile', None) carriers = self.get_arguments('carriers', None) if not start or not end: start = "开始日期" end = "结束日期" raise StandardError() c = CustomerModule(self.application.dc) customers = c.search_user2(start, end, shop_name, min_money, max_money, last_buy, categories, is_refund, phone, carriers, payment_mode) except: logging.info( traceback.format_exc() ) customers = [] shop_names = ["王府井店","亚运村店","五棵松店","中关村店","朝阳门店","三里河店","来广营店","回龙观店","草桥店","下沙店","笕桥店","虚拟代销DC","DC分销中心","北京门店","杭州门店"] pathfile = 'customer_'+start+'to'+end[0:10]+shop_names[0]+'.xls' if customers : wb=xlwt.Workbook() ws=wb.add_sheet('1') name_list = ['用户ID','日期','消费门店','消费总额','购买数量','消费偏好','手机号','运营商','有无退货','支付方式','会员等级'] _list = ['member_sid', 'last_buy', 'shop_names', 'sale_sum', 'sale_cnt', 'categories', 'mobile', 'carrier', 'is_refund', 'payment_modes','m_type'] for i in range(0,len(name_list)) : ws.write(0,i,str(name_list[i]).decode('utf8')) for j in range(0,len(customers)) : _value = str(customers[j][_list[i]]).decode('utf8') if _list[i] == 'shop_names' : _value = str("/".join(customers[j][_list[i]])).decode('utf8') elif _list[i] == 'categories' : _value = str("/".join(customers[j][_list[i]])).decode('utf8') elif _list[i] == 'is_refund' : _value = "有".decode('utf8') if customers[j][_list[i]] else "无".decode('utf8') ws.write(j+1,i,_value) wb.save('static/xls/'+pathfile) return self.render('customer.html', customers = customers[:1000], shop_names = shop_names, pathfile=pathfile)