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 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 get_p24(): from sdk.p24 import p24 return p24("UAH", "https://api.privatbank.ua/", crypton.settings.P24_MERCHID, crypton.settings.P24_PASSWD)
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)