Пример #1
0
def main():
    runtime = datetime.datetime.now()
    bill = urfa_client('bill.nester.ru', 11758, 'init', 'init02Nit87',admin=True,crt_file=resource_path('admin.crt'))
    db = MySQLdb.connect(db = dbname,passwd = dbpass,host = dbhost, user = dbuser, charset='utf8')
    c = db.cursor()
    #Выборка платежей за предыдущие сутки
    sql = "SELECT  UNIX_TIMESTAMP(date_sub(curdate( ), INTERVAL 1 DAY)),UNIX_TIMESTAMP(curdate( ))"
    c.execute(sql)
    (stime,ftime) = c.fetchall()[0]

    sql = """
SELECT u.id,
  a.id,
  u.full_name,
  u.mobile_telephone,
  (to_days(curdate()) - if(to_days(ifnull(from_unixtime(max(bi.start_date)),uap.d1)) > to_days(uap.d1),
                        to_days(ifnull(from_unixtime(max(bi.start_date)),uap.d1)),
                        to_days(uap.d1))) div 30 as lindex
FROM users as u,
  users_accounts as ua,
  accounts as a LEFT JOIN blocks_info AS bi ON bi.account_id = a.id,
  (
    SELECT str_to_date(value,'%d/%m/%Y') as d1, userid
    FROM user_additional_params
    WHERE paramid = (SELECT paramid FROM uaddparams_desc WHERE name LIKE 'loyalty_start')
      AND  value REGEXP '^[0-9]{1,2}/[0-9]{1,2}/[0-9]{4}$'
  ) AS uap
WHERE u.id = ua.uid
    AND ua.account_id = a.id
    AND not ua.is_deleted
    AND (uap.userid = u.id  AND uap.d1)
    AND (isnull(bi.block_type) or bi.block_type = 1)
    AND NOT a.unlimited
    AND LENGTH(TRIM(u.mobile_telephone))
GROUP BY u.id
"""
    c.execute(sql)
    report = u'Обработка учетных записей абонентов, участников программы лояльности:\n'
    s = smtplib.SMTP(smtphost)
    for (uid, aid, uname, tel, lind) in c.fetchall():
        report += u"Идентификатор абонента: %s, Лицевой счет: %s Полное имя: %s, индекс лояльности: %s\n" \
                  % (uid, aid, uname, lind)
        pbonus = lindex2percent(lind)
        if not pbonus:
            continue
        pSum = 0
        pm = bill.report_payments({'user_id': uid, 'time_start': stime, 'time_end': ftime})
        for i in pm:
            pSum += pm[i]['sum']
        bonus = pbonus * pSum
        if bonus:
            report += u"Суточный платеж:%s коэфициент:%s Начислен бонус:%s" % (pSum, pbonus, bonus)
            ret = bill.rpcf_add_once_slink_ex({'user_id':uid,'account_id':aid,'service_id':bonusServiceId,'cost_coef':-bonus})
            if ret:
                report += u" ИдСервСвязки:%s \n" % (ret,)
                m = re.match(r'^(?:8|\+7)?([0-9]{10})',re.sub('-','',tel))
                if m:
                    toAddr = "*****@*****.**" % m.group(1)
                    msg = MIMEText('Ув. абонент! За участие в бонусной программе, Вам начислен бонус в размере %s %% от суммы пополнения - %s рублей.'
                                   % (pbonus*100,bonus),'plain','utf-8')
                    msg['Subject'] = 'Short message service'
                    msg['From'] = fromAddr
                    msg['To'] = toAddr
                    s.sendmail(fromAddr, [toAddr], msg.as_string())
                else:
                    report += u'ВНИМАНИЕ! ОШИБОЧНЫЙ НОМЕР МОБ. ТЕЛЕФОНА АБОНЕНТА! (%s) ОТСЫЛКА ОПОВЕЩЕНИЯ НЕВОЗМОЖНО!\n' % (tel,)
            else:
                report += u" НЕИЗВЕСТНЫЙ РЕЗУЛЬТАТ НАЧИСЛЕНИЯ БОНУСА!\n"
    msg = MIMEText(report,'plain','utf-8')
    msg['Subject'] = u'Отчет программы лояльности за %s' % (runtime.strftime('%d-%m-%Y'),)
    msg['From'] = fromAddr
    msg['To'] = reportAddr
    s.sendmail(fromAddr, [reportAddr], msg.as_string())
    s.quit()
Пример #2
0
from urfa import urfa_client
import os,sys

def resource_path(relative):
    return os.path.join(getattr(sys, '_MEIPASS', os.path.abspath(".")),relative)
uid = 5
aid = 5
bonusServiceId = 188
bonus = 1.0
bill = urfa_client('bill.nester.ru', 11758, 'init', 'init02Nit87',admin=True,crt_file=resource_path('admin.crt'))
ret = bill.rpcf_add_once_slink_ex({'user_id':uid,'account_id':aid,'service_id':bonusServiceId,'cost_coef':-bonus})
print ret
Пример #3
0
from urfa import urfa_client
import os, sys


def resource_path(relative):
    return os.path.join(getattr(sys, '_MEIPASS', os.path.abspath(".")),
                        relative)


uid = 5
aid = 5
bonusServiceId = 188
bonus = 1.0
bill = urfa_client('bill.nester.ru',
                   11758,
                   'init',
                   'init02Nit87',
                   admin=True,
                   crt_file=resource_path('admin.crt'))
ret = bill.rpcf_add_once_slink_ex({
    'user_id': uid,
    'account_id': aid,
    'service_id': bonusServiceId,
    'cost_coef': -bonus
})
print ret