def add_record(request): if not request.user.is_authenticated(): return HttpResponse(content = '{"success":false,"msg":"NOT_LOGIN"}', content_type = 'application/json') item = request.POST['item'] amount,category = parse_amount(item) record = Record(user = request.user) record.category = category record.amount = amount record.added_on = request.POST['date'] record.save() record = Record.objects.get(pk = record.pk) result = {} result['success'] = True result['data'] = record.clean_object report = update_report(request.user, record.added_on) profile = request.user.get_profile() profile.account_balance = profile.account_balance + record.amount profile.save() result['report'] = report.clean_object result['balance'] = str(profile.account_balance) return HttpResponse(content = json.dumps(result), content_type = 'application/json')
def save_record(request): if request.POST: try: teacher_name = request.POST['teacher_name'] grade_no = request.POST['grade_no'] dt = request.POST['date'] dt = datetime.datetime.strptime(dt, '%m-%d-%Y') tm = request.POST['time'] tm = datetime.datetime.strptime(tm, "%I:%M%p") timestamp = str(dt.date()) + " " + str(tm.time()) comments = request.POST['comments'] user = request.user record = Record() record.user = user record.teacher_name = teacher_name record.grade = grade_no record.timestamp = timestamp record.district = user.first_name record.comments = comments record.save() messages.success(request, 'Data saved successfully!') return HttpResponseRedirect("/cal/save_record/") except Exception as err: messages.error(request, 'Error saving data ({0})'.format(str(err))) return HttpResponseRedirect("/cal/save_record/") else: query = Record.objects.filter(user=request.user).values() data = [] for i in query: obj = {} obj['teacher_name'] = i['teacher_name'] obj['grade'] = i['grade'] obj['timestamp'] = str(i['timestamp']).split('+')[0] data.append(obj) return render(request, "calendar.html", {'message': ' ', 'data': data})
def ImportAllRecords(csvFile): num = 0 with open(csvFile) as csvTextFile: csvReader = csv.reader(csvTextFile) for line in csvReader: print(line[0]) if num > 0: record = Record(EnterpriseId=int(line[0]), LastName=line[1], FirstName=line[2], MiddleName=line[3], Suffix=line[4], DOB=line[5], Gender=line[6], SSN=line[7], Address1=line[8], Address2=line[9], Zip=line[10], MothersMaidenName=line[11], MRN=line[12], City=line[13], State=line[14], Phone=line[15], Phone2=line[16], Email=line[17], Alias=line[18]) record.save() num = num + 1 return
def add_record(user, file=None, path=None): if path: get = requests.get(path) if get.status_code == 200: data = get.content f = BytesIO() f.write(data) file = InMemoryUploadedFile(f, None, path.split('/')[-1], None, len(data), None, None) new_record = Record(user=user, file=file, filename=file.name) new_record.save() process.process_classify(new_record.id, str(new_record.file)) process.process_facerecog(new_record.id, str(new_record.file)) return new_record.pk
def record(request): if request.method == 'GET': return render(request, 'app/record.html', {}) else: result_dict = {} member_id = request.session['user_id'] name = request.POST['name'] #점검자 address = request.POST['address'] #건물주소 buildingname = request.POST['buildingname'] #건물이름 own = request.POST['own'] #건물주 num1 = request.POST['num1'] num2 = request.POST['num2'] num3 = request.POST['num3'] num4 = request.POST['num4'] num5 = request.POST['num5'] num6 = request.POST['num6'] num7 = request.POST['num7'] num8 = request.POST['num8'] num9 = request.POST['num9'] num10 = request.POST['num10'] if member_id == '' or address == '' or name == '' or buildingname == '' or own == '' or num1 == '' or num2 == '' or num3 == '' or num4 == '' or num5 == '' or num6 == '' or num7 == '' or num8 == '' or num9 == '' or num10 == '': result_dict['result'] = '공백은 사용할 수 없습니다.' return JsonResponse(result_dict) else: try: record = Record( member_id=member_id, address=address, name=name, buildingname=buildingname, own=own, num1=num1, num2=num2, num3=num3, num4=num4, num5=num5, num6=num6, num7=num7, num8=num8, num9=num9, num10=num10, ) record.save() result_dict['result'] = '등록완료' except: pass return JsonResponse(result_dict)
def check_recurrence(user, request_year, request_month): from datetime import datetime now = datetime.now() if request_year != now.year or request_month != now.month: return items = Recurrence.objects.filter(user = user) import calendar,datetime start_date = datetime.date(now.year, now.month, 1) month_range = calendar.monthrange(now.year, now.month) end_date = datetime.date(now.year, now.month, month_range[1]) added = False for item in items: records = Record.objects.filter(user = user, is_recurrent = True, added_on__range = (start_date, end_date), category = item.category) if len(records) == 0 and str(request_year*100 + request_month) not in item.ignore_months: added_on = datetime.datetime(now.year, now.month, item.day, now.hour, now.minute, now.second) if added_on > item.origin_record.added_on and item.day <= now.day: added = True record = Record(user = user, is_recurrent = True, added_on = added_on, category = item.category, amount = item.amount) record.save() profile = user.get_profile() profile.account_balance = profile.account_balance + record.amount profile.save() if added: update_report(user, record.added_on)
def show_checkout(self): result_list, result_img = self.object_classification(self.cap, model=self.model) result_name = result_list[0] show = cv2.resize(result_img, (640, 480)) show = cv2.cvtColor(show, cv2.COLOR_BGR2RGB) showImage = QtGui.QImage(show.data, show.shape[1], show.shape[0], QtGui.QImage.Format_RGB888) self.label_show_picture.setPixmap(QtGui.QPixmap.fromImage(showImage)) self.timer_checkout.stop() self.removelines = [] for line in self.lines: row = self.table.rowCount() for x in range(row, 0, -1): if line[0] == self.table.item(x - 1, 0).text(): self.table.removeRow(x - 1) self.removelines.append(line) for line in self.removelines: self.lines.remove(line) self.table.cellChanged.disconnect() for name in result_name: row = self.table.rowCount() self.table.setRowCount(row + 1) name_list = { "Black_Tea": "紅茶", "Cheers": "Cheers礦泉水", "Chrunchoco": "巧克力脆片", "Coffee_Milk": "咖啡牛奶", "Family_Water": "全家礦泉水", "Green_Milk_Tea": "奶綠", "Lays": "洋芋片", "LP33": "優酪乳", "Lemon_Tea": "檸檬紅茶", "Lotte": "小熊餅乾", "LS_SoyMilk": "低糖豆漿", "Oats_Drink": "喝的燕麥", "Ocean_Spray": "蔓越莓", "Oolong_Tea": "烏龍奶茶", "Oreo": "Oreo餅乾", "Puff": "小泡芙", "Purple": "紫米燕麥米漿", "Soy_Oats": "豆漿燕麥", "Soymilk": "豆漿", "With_Kernel": "顆粒燕麥" } price_list = { "Black_Tea": "25", "Cheers": "40", "Chrunchoco": "60", "Coffee_Milk": "20", "Family_Water": "15", "Green_Milk_Tea": "25", "Lays": "30", "LP33": "30", "Lemon_Tea": "20", "Lotte": "40", "LS_SoyMilk": "20", "Oats_Drink": "40", "Ocean_Spray": "25", "Oolong_Tea": "20", "Oreo": "50", "Puff": "30", "Purple": "20", "Soy_Oats": "40", "Soymilk": "20", "With_Kernel": "40" } commodity_name = name_list[name] price = price_list[name] count = '1' self.table.setItem(row, 0, QTableWidgetItem(commodity_name)) self.table.setItem(row, 1, QTableWidgetItem(count)) self.table.setItem(row, 2, QTableWidgetItem(price)) self.lines.append([commodity_name, count, price]) msg = QtWidgets.QMessageBox.warning( self, u"商品結帳", u"商品結帳已完成。", buttons=QtWidgets.QMessageBox.Ok, defaultButton=QtWidgets.QMessageBox.Ok) print('self.lines:', self.lines) # 調用Django程序操作model pathname = os.path.dirname(os.path.abspath(__file__)) sys.path.insert(0, pathname) sys.path.insert(0, os.path.abspath(os.path.join(pathname, '..'))) os.environ.setdefault("DJANGO_SETTINGS_MODULE", "mysite.settings") django.setup() from app.models import Category, Record from django.contrib.auth.models import User username = self.signin_name user = User.objects.get(last_name=username) id = user.id for word in self.lines: name = word[0] count = word[1] price = word[2] category = Category(category=name, user_id=id) unix = time.time() date = str( datetime.datetime.fromtimestamp(unix).strftime('%Y-%m-%d')) record = Record(date=date, category=name, cash=price, cnt=count, user_id=id) category.save() record.save() self.table.cellChanged.connect(self.cellchange)
def create(): payload = request.get_json() result = Record( payload) # validate respective sections on input before saving result = result.save() return str(result)
def db_save(self, user): r = Record(username=user, time=datetime.datetime.now()) r.save()
import datetime pathname = os.path.dirname(os.path.abspath(__file__)) sys.path.insert(0, pathname) sys.path.insert(0, os.path.abspath(os.path.join(pathname, '..'))) os.environ.setdefault("DJANGO_SETTINGS_MODULE", "mysite.settings") django.setup() from app.models import Category, Record from django.contrib.auth.models import User if __name__ == "__main__": user = User.objects.create_user('john', '*****@*****.**', 'johnpassword') a = User.objects.get(username='******') b = a.id print(b) words = [['豆漿燕麥', '1', '40'], ['奶綠', '1', '25'], ['奶綠', '1', '25'], ['奶綠', '1', '25'], ['奶綠', '1', '25']] for word in words: name = word[0] count = word[1] price = word[2] c = Category(category=name, user_id=b) unix = time.time() date = str(datetime.datetime.fromtimestamp(unix).strftime('%Y-%m-%d')) d = Record(date=date, category=name, cash=price, cnt=count, user_id=b) c.save() d.save() pass