def CreateOrEditTransfer_view(request, transfer_id=None):
response_data = {} # словарь для JSON-ответа
if (transfer_id == None or transfer_id == '999999'):
_transfer = Transfer()
_message = 'Заявка добавлена успешно'
else:
_transfer = get_object_or_404(Transfer, id=transfer_id)
_message = 'Заявка отредактирована успешно'
if request.method == "GET" and request.is_ajax():
# сериализуем только queryset поэтому заворчаиваем объект в [obj,]
data = serializers.serialize(
'json', [
_transfer,
],
fields=('date_departure', 'time_departure', 'place_departure',
'place_arrival', 'quantity_total', 'quantity_adult',
'quantity_member', 'status', 'status_comment'))
return _json_response(data)
if request.POST:
formTransfer = TransferForm(request.POST, instance=_transfer)
if formTransfer.is_valid():
res = formTransfer.save(commit=False)
res.user_id = auth.get_user(
request
).id #передаем ID директора , к которому привязан участник
# Если участник использует чекбокс "Свое название", то сохраняем его в базу
if ('transDepartureSelf' in request.POST) and \
request.POST['transDepartureSelf'] not in \
list(Place_departure_choices.objects.filter(user_id = auth.get_user(request)).values_list('place_name',\
flat=True)):
new_dep_place = Place_departure_choices(
user=auth.get_user(request),
place_name=request.POST['transDepartureSelf'])
new_dep_place.save()
res.place_departure = new_dep_place
if ('transArrivalSelf' in request.POST) and \
request.POST['transArrivalSelf'] not in \
list(Place_departure_choices.objects.filter(user_id = auth.get_user(request)).values_list('place_name',\
flat=True)):
new_arriv_place = Place_departure_choices(
user=auth.get_user(request),
place_name=request.POST['transArrivalSelf'])
new_arriv_place.save()
res.place_arrival = new_arriv_place
# Рассчитываем сумму заявки и сохраняем ;
res.payment = fee_transfer
formTransfer.save()
messages.add_message(request, messages.SUCCESS, _message)
return HttpResponse('ok')
else:
response_data['errors'] = u'Неправильно заполнена форма.'
response_data['formErrors'] = simplejson.dumps(formTransfer.errors)
return _json_response(response_data)
return redirect('/')
def multiple_sender(data):
""" data = {phone_num: [76027211, 76433890], code: 03944, amount: 100} """
amount = data.get("amount")
code = data.get("code")
for phone_num in data.get("phone_num"):
transfer = Transfer()
transfer.amount = amount
transfer.contact = Contact.get_or_create(phone_num)
transfer.response = u"{}".format(
send_ussd(format_str(phone_num, amount, code)).message)
transfer.save()
def submit(self, session, source, record=None, overwrite=False):
"""
Submit a job and store it in the database
"""
metadata = 'NA62 raw data file'
attemp = 1
# I am receiving further information from an existing record on the database
if record is not None:
metadata = 'NA62 raw data file, resubmitting from job_id: ' + str(record.job_id) + \
' mariadb_id: ' + str(record.id)
attemp = record.transfer_attemp + 1
try:
job_id = self.fts_instance.submit(
source.get_fts_source(),
source.get_fts_castor_destination(),
metadata,
overwrite=overwrite)
except:
self.logger.error('Cannot submit the job: ' + source.get_source())
raise
try:
# def __init__(self, file_id, file_size, dst_host_id, dst_path, job_id, attemp):
new_transfer = Transfer(
# self.host,
# source.get_dir_name(),
# source.get_base_name(),
source.get_file_id(),
source.get_size(),
9,
source.get_destination(),
job_id,
attemp)
session.add(new_transfer)
session.flush()
database_id = new_transfer.id # should be not None
session.commit()
except:
session.rollback()
self.logger.error('Error cannot add the job_id: ' + job_id +
' to the database')
raise
finally:
# release the connection to the pool
session.close()
return (job_id, database_id)
def populate(self, doc_name):
row = 7
des_col = 5
deb_col = 11 # Debit column
cre_col = 12 # Credit column
db.drop_all()
db.create_all()
info(doc_name)
self.update_state(state='PROGRESS')
sheet = doc_open(doc_name)
while parse(sheet, row, des_col):
self.update_state(state='PROGRESS')
desc = parse(sheet, row, des_col)
datetime = parse(sheet, row, 1).split(' ')
date = datetime[0]
time = datetime[1]
try:
credit = float(parse(sheet, row, cre_col))
debit = float(parse(sheet, row, deb_col))
except:
credit = float(parse(sheet, row, cre_col).replace(',', ""))
debit = float(parse(sheet, row, deb_col).replace(',', ""))
status = parse(sheet, row, stat_col)
# cashback is common on most of the parsed data denoting profit
if refine('cashback', desc):
# second most common data
if refine('ADSL', desc):
command_execute('cashback', 'NTC', desc, 'adsl', 'Topup',
credit, status, date, time)
elif refine('prepaid', desc):
command_execute('cashback', 'NTC', desc, 'prepaid', 'Topup',
credit, status, date, time)
elif refine('postpaid', desc):
command_execute('cashback', 'NTC', desc, 'postpaid', 'Topup',
credit, status, date, time)
elif refine('landline', desc):
command_execute('cashback', 'NTC', desc, 'landline', 'Topup',
credit, status, date, time)
elif refine('NT Recharge Card', desc):
command_execute('cashback', 'NTC', desc, 'recharge card',
'Recharge Card', credit, status, date, time)
elif refine('Ncell', desc):
command_execute('cashback', 'NCELL', desc, 'prepaid', 'Topup',
credit, status, date, time)
elif refine('SIM TV Payment', desc):
command_execute('cashback', 'SIMTV', desc, 'simtv', 'Topup',
credit, status, date, time)
elif refine('Worldlink', desc):
command_execute('cashback', 'WORLDLINK', desc, 'worldlink',
'Topup', credit, status, date, time)
elif refine('UTL', desc):
command_execute('cashback', 'UTL', desc, 'utl',
'recharge card', credit, status, date, time)
elif refine('Vianet', desc):
command_execute('cashback', 'VIANET', desc, 'vianet', 'Topup',
credit, status, date, time)
# Greedy Sewa cash back is assumed to be cashback of dish home
# recharge card
elif refine('eSewa', desc):
command_execute('cashback', 'DISHHOME', desc, 'recharge card',
'Topup', credit, status, date, time)
elif refine('SUBISU', desc):
command_execute('cashback', 'SUBISU', desc, 'subisu', 'Topup',
credit, status, date, time)
else:
command_execute('other', 'other', desc, 'unknown', 'Topup',
credit, status, date, time)
elif refine('sim commission', desc):
command_execute('cashback', 'SIM', desc, 'sim commission',
'Transfer', credit, status, date, time)
elif refine('WEBSURFER.COM', desc):
command_execute('payment', 'WEBSURFER', desc, 'websurfer',
'Payment', debit, status, date, time)
elif refine('Cash Back', desc):
if refine('SUBISU', desc):
command_execute('cashback', 'SUBISU', desc, 'subisu',
'Payment', credit, status, date, time)
else:
command_execute('cashback', 'WEBSURFER', desc, 'websurfer',
'Payment', credit, status, date, time)
elif refine('topup', desc):
if refine('prepaid', desc):
command_execute('payment', 'NTC', desc, 'prepaid', 'Topup',
debit, status, date, time)
elif refine('postpaid', desc):
command_execute('payment', 'NTC', desc, 'postpaid', 'Topup',
debit, status, date, time)
elif refine('adsl', desc):
command_execute('payment', 'NTC', desc, 'adsl', 'Topup', debit,
status, date, time)
elif refine('landline', desc):
command_execute('payment', 'NTC', desc, 'landline', 'Topup',
debit, status, date, time)
elif refine('7190*', desc):
command_execute('payment', 'DISHHOME', desc, 'topup', 'Topup',
debit, status, date, time)
elif refine('1000*', desc):
command_execute('payment', 'SIMTV', desc, 'simtv', 'Topup',
debit, status, date, time)
else:
command_execute('other', 'other', desc, 'unknown', 'Topup',
debit, status, date, time)
elif refine('payment', desc):
if refine('980*', desc) or refine('981*', desc):
command_execute('payment', 'NCELL', desc, 'ncell', 'Topup',
debit, status, date, time)
elif refine('subisu', desc):
command_execute('payment', 'SUBISU', desc, 'subisu', 'Payment',
debit, status, date, time)
elif refine('NEA BILL', desc):
command_execute('payment', 'NEA', desc, 'nea', 'Payment',
debit, status, date, time)
else:
command_execute('other', 'other', desc, 'unknown', 'Payment',
debit, status, date, time)
elif refine('paid', desc):
if refine('VIANET', desc):
command_execute('payment', 'VIANET', desc, 'vianet', 'Payment',
debit, status, date, time)
else:
pass
elif refine('Bought recharge', desc):
if refine('NTGSM', desc):
command_execute('payment', 'NTC', desc, 'ntcgsm',
'Recharge Card', debit, status, date, time)
elif refine('DHOME', desc):
command_execute('payment', 'DISHHOME', desc, 'recharge card',
'Recharge Card', debit, status, date, time)
elif refine('NTCDMA', desc):
command_execute('payment', 'NTC', desc, 'ntrecharge',
'Recharge Card', debit, status, date, time)
else:
command_execute('other', 'other', desc, 'unknown',
'Recharge Card', debit, status, date, time)
elif refine('Money Transfer', desc):
db.session.add(
Transfer('BANK', desc, 'received', 'Transfer', float(credit),
status, date, time,
desc.replace('Money Transferred from ', '')))
elif refine('Balance Transfer', desc):
if refine('to', desc):
db.session.add(
Transfer('PEER', desc, 'transferred', 'Transfer',
float(debit), status, date, time,
desc.replace('Balance Transferred to ', '')))
else:
db.session.add(
Transfer('PEER', desc, 'received', 'Transfer',
float(credit), status, date, time,
desc.replace('Balance Transferred by ', '')))
else:
# saving unknown transaction description to file
f = open('unknown.lst', 'r')
lines = f.readlines()
f.close()
with open('unknown.lst', 'a+') as f:
if desc + '\n' not in lines:
f.write(desc + '\n')
lines.append(desc)
else:
f.flush()
if float(credit) != 0:
db.session.add(
Other('other', desc, ' Unknown Cashback', 'cashback',
float(credit), status, date, time))
else:
db.session.add(
Other('other', desc, ' Unknown Payment', 'payment',
float(debit), status, date, time))
row += 1
db.session.commit()
return {'result': 'Task Completed'}