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
