def handle(self, *args, **options):
from sdk.p24 import p24
cursor = connection.cursor()
cursor.execute(
"SELECT sum(balance) FROM main_accounts WHERE currency_id=1 AND balance>0 AND balance<1000000 AND id!=353 ");
s = cursor.fetchone() * 1
if s == (None, ):
s = Decimal("0.0")
else:
(s, ) = s
cursor.execute(
"SELECT sum(amnt)*0.99 FROM main_cardp2ptransfers WHERE status in ('created','processing','processing2','auto') AND pub_date>='2015-05-08' ");
s1 = cursor.fetchone() * 1
if s1 == (None, ):
s1 = Decimal("0.0")
else:
(s1, ) = s1
D = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2, settings.P24_PASSWD2,
settings.P24MERCH_CARD2)
D1 = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID, settings.P24_PASSWD, settings.P24MERCH_CARD)
BalanceUAH = Decimal(D.balance()) + Decimal(D1.balance())
print BalanceUAH
Delta = (BalanceUAH - s - s1 + 30020)
print "Delta is %s" % Delta
if Delta < 0:
print "Delta is bad %s" % Delta
lock_global("uah_balance")
def check_uah_balance():
cursor = connection.cursor()
cursor.execute(
"SELECT sum(balance) FROM main_accounts WHERE currency_id=1 AND balance>0 AND balance<1000000 AND id!=353 "
)
s = cursor.fetchone() * 1
if s == (None, ):
s = Decimal("0.0")
else:
(s, ) = s
cursor.execute(
"SELECT sum(amnt)*0.99 FROM main_cardp2ptransfers WHERE status in ('created','processing','processing2','auto') AND pub_date>='2015-05-08' "
)
s1 = cursor.fetchone() * 1
if s1 == (None, ):
s1 = Decimal("0.0")
else:
(s1, ) = s1
D = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2,
settings.P24_PASSWD2, settings.P24MERCH_CARD2)
D1 = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID,
settings.P24_PASSWD, settings.P24MERCH_CARD)
BalanceUAH = Decimal(D.balance()) + Decimal(D1.balance())
return (BalanceUAH - s - s1 + 16200) > 0
def check_uah_balance():
cursor = connection.cursor()
cursor.execute(
"SELECT sum(balance) FROM main_accounts WHERE currency_id=1 AND balance>0 AND balance<1000000 AND id!=353 ");
s = cursor.fetchone() * 1
if s == (None, ):
s = Decimal("0.0")
else:
(s, ) = s
cursor.execute(
"SELECT sum(amnt)*0.99 FROM main_cardp2ptransfers "
"WHERE status in ('created','processing','processing2','auto')"
"AND pub_date>='2015-05-08'");
s1 = cursor.fetchone() * 1
if s1 == (None, ):
s1 = Decimal("0.0")
else:
(s1, ) = s1
D = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2, settings.P24_PASSWD2,
settings.P24MERCH_CARD2)
D1 = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID, settings.P24_PASSWD, settings.P24MERCH_CARD)
BalanceUAH = Decimal(D.balance()) + Decimal(D1.balance())
return (BalanceUAH - s - s1) > 0
def handle(self, *args, **options):
# reload(sys)
# sys.setdefaultencoding('utf-8')
D = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID, settings.P24_PASSWD, settings.P24MERCH_CARD)
# D.pay2p(200,"6762462680255004" , Decimal("10394.01"))
# D.pay2p(224,"5167982300501472" , Decimal("360"))
# D.pay2p(214,"4149497816294591" , Decimal("226.75"))
# D.pay2p(218,"5168755617294299" , Decimal("69.30"))
print D.balance()
def handle(self, *args, **options):
from sdk.p24 import p24
TradePair = TradePairs.objects.get(url_title = "p24")
D = p24()
for item in Orders.objects.filter(trade_pair = TradePair, status="wait_secure"):
Res = D.check_payment(item.id, True)
item.status = "processing2"
item.save()
if Res == 1 :
process_p24_in(item.id, D.description, D.comis )
if Res == 0:
cancel_p24_in(item.id)
for item in Orders.objects.filter(trade_pair = TradePair, status="processing"):
Res = D.check_payment(item.id, True)
item.status = "processing2"
item.save()
if Res == 1:
process_p24_in(item.id, D.description, D.comis )
if Res == 0:
cancel_p24_in(item.id )
def p24_call_back_url(Req, OrderId):
pay_call_back = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2, settings.P24_PASSWD2)
rlog_req = OutRequest(raw_text=str(Req.REQUEST), from_ip=get_client_ip(Req))
rlog_req.save()
return pay_call_back.api_callback_pay(Req.REQUEST, OrderId)
def p24_deposit(Req, Amnt):
amnt = Decimal(Amnt)
if amnt < 100:
raise TransError("pay_requirments")
pay_invoice = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2, settings.P24_PASSWD2)
return HttpResponse(pay_invoice.generate_button(Amnt))
def p24_start_pay(Req, Amnt):
pay_invoice = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2, settings.P24_PASSWD2)
if not Req.user.is_authenticated():
return denied(Req)
else:
return pay_invoice.generate_pay_request(Req.user, Amnt)
def handle(self, *args, **options):
# reload(sys)
# sys.setdefaultencoding('utf-8')
D = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID, settings.P24_PASSWD, settings.P24MERCH_CARD)
def whole_balance(request):
CurList = Currency.objects.all()
UAH = Currency.objects.get(id = 1)
CurrencyConsist = []
CurrencyLocalBalance = []
CurrencyFor = []
SaldoCor = []
cursor = connection.cursor()
## 346 mistake object
#{% for item in currency_consist %}
#<p>Сальдо {{ item.currency }} : {{ item.sum }} </p>
#{% endfor %}
MinesDec = Decimal("-1")
for cur in CurList:
Id = cur.id
cursor.execute("SELECT sum(balance) FROM main_accounts WHERE currency_id='%s' \
AND user_id not in (346, 31) AND abs(balance)>0.000000001 ", [Id])
s = cursor.fetchone()*1
if s == (None, ) :
s = Decimal("0.0")
CurrencyConsist.append({ "currency": cur.title, "sum": format_numbers_strong(s) })
##get balances of crypto without uah
for cur in Accounts.objects.filter(user_id = settings.CRYPTO_USER).exclude(currency_id = 1):
if cur.balance is None:
cur.balance = Decimal("0")
CurrencyLocalBalance.append({"currency": cur.currency.title,
"sum": format_numbers_strong(cur.balance*MinesDec) })
P24User = User.objects.get(username = p24.str_class_name() )
P24 = Accounts.objects.get(user = P24User, currency_id = 1)
LiqPayU = User.objects.get(username = liqpay.str_class_name() )
LiqPay = Accounts.objects.get(user = LiqPayU, currency_id = 1)
TradePair = TradePairs.objects.get(url_title = "p2p_transfers" )
CurrencyLocalBalance.append({"currency": "UAH",
"sum": format_numbers_strong(
MinesDec*(TradePair.transit_from.balance + LiqPay.balance + P24.balance)
) })
CurrencyFor = []
Balances = {}
for cur in CurList:
if cur.id != 1:
try:
Crypto = CryptoAccount(cur.title)
DecSum = Decimal(Crypto.getbalance() )
except :
DecSum = Decimal("0.0")
Sum = format_numbers_strong( DecSum )
Balances[ cur.title ] = DecSum
CurrencyFor.append({"currency": cur.title,
"sum": Sum })
D = p24()
BalanceUAH = Decimal(D.balance())
Balances[ "UAH" ] = BalanceUAH
CurrencyFor.append({"currency": "UAH",
"sum": format_numbers_strong(
BalanceUAH
)
})
ComisId = int(settings.COMISSION_USER)
for cur in CurList:
Id = int(cur.id)
if cur.id != 1:
cursor.execute("SELECT sum(balance) FROM main_accounts WHERE currency_id=%i\
AND user_id not in (346, %i, 31 ) AND balance>0 " % ( Id,ComisId ), [] )
(s,) = cursor.fetchone()*1
if s == None :
s = Decimal("0.0")
SaldoCor.append({ "currency": cur.title, "sum":
format_numbers_strong( Balances[cur.title] - s ) })
cursor.execute("SELECT sum(balance) FROM main_accounts WHERE currency_id=1\
AND user_id not in (346, %i, 12,31 ) AND balance>0 " % ( ComisId ), [])
(s, ) = cursor.fetchone()*1
SaldoCor.append({ "currency": "UAH", "sum":
format_numbers_strong( Balances["UAH"] - s ) })
return render_to_response('admin/main/whole_balance.html',
{'currency_consist': CurrencyConsist,
"currency_local_balance":CurrencyLocalBalance,
"currency_balance":CurrencyFor,
"saldo": SaldoCor
},
context_instance = RequestContext(request) )
def p24_deposit(Req, Amnt):
amnt = Decimal(Amnt)
if amnt<100:
raise TransError("pay_requirments")
pay_invoice = p24()
return HttpResponse( pay_invoice.generate_button(Amnt) )
def p24_start_pay(Req, Amnt):
pay_invoice = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2, settings.P24_PASSWD2)
if not Req.user.is_authenticated():
return denied(Req)
else:
return pay_invoice.generate_pay_request(Req.user, Amnt)
def handle(self, *args, **options):
D = p24()
D.balance()
def p24_call_back_url(Req, OrderId):
pay_call_back = p24()
rlog_req = OutRequest(raw_text = str(Req.REQUEST), from_ip = get_client_ip(Req) )
rlog_req.save()
return pay_call_back.api_callback_pay( Req.REQUEST, OrderId)
def p24_deposit(Req, Amnt):
amnt = Decimal(Amnt)
if amnt < 100:
raise TransError("pay_requirments")
pay_invoice = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2, settings.P24_PASSWD2)
return HttpResponse(pay_invoice.generate_button(Amnt))
def get_p24():
from sdk.p24 import p24
return p24("UAH", "https://api.privatbank.ua/", crypton.settings.P24_MERCHID, crypton.settings.P24_PASSWD)
def p24_call_back_url(Req, OrderId):
pay_call_back = p24("UAH", "https://api.privatbank.ua/", settings.P24_MERCHID2, settings.P24_PASSWD2)
rlog_req = OutRequest(raw_text=str(Req.REQUEST), from_ip=get_client_ip(Req))
rlog_req.save()
return pay_call_back.api_callback_pay(Req.REQUEST, OrderId)
def get_p24():
from sdk.p24 import p24
return p24()
def p24_start_pay(Req, Amnt):
pay_invoice = p24()
if not Req.user.is_authenticated():
return denied(Req)
else:
return pay_invoice.generate_pay_request(Req.user, Amnt)
