def __init__(self):
     self.time_now = datetime.datetime.now()
     self.code_name = {'ts-1796606':'省油宝', 'ts-1797607':'选词王', 'ts-1817244':'淘词'}
     self.order_type = {1:'新订', 2:'续订', 3:'升级', 4:'后台赠送', 5:'后台自动续订'}
     self.support_type = {7:'7天初访', 14:'2周回访', 30:'1月回访', 90:'3月回访', \
             180:'半年回访',270:'9月回访',-3:'3天到期续签'}
     self.time_type = {u'1个月':[7,14,-3],\
             u'3个月':[7,30,-3],\
             u'6个月':[7,30,90,-3],\
             u'12个月':[7,30,180,270,-3]}
     logger.info('UserCenter init success')
Esempio n. 2
0
def daily_update_script():
    """更新user_center 并将更新导入到百会CRM"""
    logger.info('user_center update start')
    try:
        user_obj = UserCenter(['ts-1796606'])
        user_obj.collect_online_info()
        user_obj.collect_update_info()
        user_obj.write_baihui_info()
        user_obj.update_online()
    except Exception, e:
        logger.exception('user_center update error: %s', str(e))
        send_sms('13738141586', 'user_center update error: ' + str(e))
Esempio n. 3
0
def daily_update_script():
    """更新user_center 并将更新导入到百会CRM"""
    logger.info('user_center update start') 
    try:
        user_obj = UserCenter(['ts-1796606'])
        user_obj.collect_online_info()
        user_obj.collect_update_info()
        user_obj.write_baihui_info()
        user_obj.update_online()
    except Exception,e:
        logger.exception('user_center update error: %s', str(e))
        send_sms('13738141586', 'user_center update error: '+str(e))
Esempio n. 4
0
    def collect_update_worker(self):
        """更新客户客服关系"""

        for nick in self.nick_worker.keys():
            new_worker_id = self.nick_worker[nick]
            shop = self.nick_shop.get(nick, None)
            if not shop:
                #要更新的用户 并不存在
                logger.info('collect_update_worker %s not exist' % nick)
                print 'collect_update_worker %s not exist' % nick
                continue
            if shop['worker_id'] != new_worker_id:
                shop['worker_id'] = new_worker_id
                shop['update_time'] = self.time_now
                self.update_shops.append(shop)
                for article_code in self.code_name.keys():
                    key = nick + article_code
                    order = self.user_order.get(key, None)
                    if order:
                        self.add_orders.append(order)
Esempio n. 5
0
    def collect_update_worker(self):
        """更新客户客服关系"""

        for nick in self.nick_worker.keys():
            new_worker_id = self.nick_worker[nick]
            shop = self.nick_shop.get(nick, None)
            if not shop:
                #要更新的用户 并不存在
                logger.info('collect_update_worker %s not exist' % nick)
                print 'collect_update_worker %s not exist' % nick
                continue
            if shop['worker_id'] != new_worker_id:
                shop['worker_id'] = new_worker_id
                shop['update_time'] = self.time_now
                self.update_shops.append(shop)
                for article_code in self.code_name.keys():
                    key = nick+article_code
                    order = self.user_order.get(key, None)
                    if order:
                        self.add_orders.append(order)
Esempio n. 6
0
import DataMonitor.conf.settings
from CommonTools.send_tools import send_sms
from CommonTools.logger import logger
from DataMonitor.monitor.monitor_marketing_cost import monitor_marketing_cost
from DataMonitor.monitor.monitor_order_add import monitor_order_add
from DataMonitor.monitor.monitor_comment_add import monitor_comment_add

def monitor_soft_script():
    try:
        return_info = monitor_soft() 
    except Exception,e:
        logger.exception('monitor_soft error: %s', str(e))
        send_sms('13738141586', 'monitor_soft_script error: '+str(e))
    else:
        logger.info(return_info)

def monitor_soft():
    """软件监测脚本
    1.麦苗科技营销花费 定期监测
    2.省油宝新增订单数 定期监测
    3.省油宝新增评价 定期监测
    4.北斗新增评价 定期监测
    省油宝,ts-1796606
    北斗,ts-1797607
    """
    current_time = datetime.datetime.now()
    rest_hours = range(1,7)
    if current_time.hour in rest_hours:
        return None
     
    content = ''
    content += analysis_campaign_complex(syb_file, '省油宝长尾计划')
    content += analysis_campaign_complex(syb_file, '省油宝加力计划')
    content += analysis_campaign_complex(bd_file, '北斗专属计划')
    content += analysis_campaign_simple(syb_file)
    content += analysis_campaign_horizontal(syb_file)
    return content

def analysis_campaign_script():
    today = str(datetime.date.today())
    syb_file = CURRENT_DIR+'data/report_data/syb_report' + today + '.csv'
    bd_file = CURRENT_DIR+'data/report_data/bd_report' + today + '.csv'
    if not os.path.exists(syb_file):
        logger.error('analysis_campaign error: %s not exists ' % (syb_file))
        return None
    try:
        content = analysis_campaign(syb_file, bd_file)
        #send_email_with_text('*****@*****.**', content, today+'_产品报表日常分析')
        send_email_with_text('*****@*****.**', content, today+'_产品报表日常分析')

    except Exception,e:
        logger.exception('analysis_campaign error: %s' % (str(e)))
        send_sms('13738141586', 'analysis_campaign error: %s' % (str(e)))
    else:
        logger.info('analysis_campaign ok')

if __name__ == '__main__':
    analysis_campaign_script()
    #print analysis_campaign('/home/zhoujiebing/Analysis/DataAnalysis/data/report_data/report2013-04-17.csv')

            for order in page_list:
                if order['payTime'].find(today) != -1:
                    order_nick = order['nick']
                    if order_nick.find('<font title="') != -1:
                        order_nick = order_nick.split('"')
                        order['nick'] = order_nick[1]
                    order_list.append(order)
                    flag = True
            if not flag and order['payTime'].find(str(self.yesterday)) != -1:
                break

        return order_list

def collect_order_script(_days=0):
    today = datetime.date.today() - datetime.timedelta(days=_days)
    try:
        ztc = ZtcOrderCollect(today)
        ztc.get_order()
        ztc.write_order()
    except Exception,e:
        logger.error('collect_order_script %s: %s' % (str(today), str(e)))
        send_sms('13738141586', 'collect_order_script %s: %s' % (str(today), str(e)))
    else:
        logger.info('collect_order_script %s ok', str(today))

if __name__ == '__main__':
    if len(sys.argv) == 1:
        collect_order_script()
    else:
        collect_order_script(int(sys.argv[1]))
            for order in page_list:
                if order['payTime'].find(today) != -1:
                    order_nick = order['nick']
                    if order_nick.find('<font title="') != -1:
                        order_nick = order_nick.split('"')
                        order['nick'] = order_nick[1]
                    order_list.append(order)
                    flag = True
            if not flag and order['payTime'].find(str(self.yesterday)) != -1:
                break

        return order_list

def collect_order_script(_days=0):
    today = datetime.date.today() - datetime.timedelta(days=_days)
    try:
        ztc = ZtcOrderCollect(today)
        ztc.get_order()
        ztc.write_order()
    except Exception,e:
        logger.error('collect_order_script %s: %s' % (str(today), str(e)))
        send_sms('13738141586', 'collect_order_script %s: %s' % (str(today), str(e)))
    else:
        logger.info('collect_order_script %s ok', str(today))

if __name__ == '__main__':
    if len(sys.argv) == 1:
        collect_order_script()
    else:
        collect_order_script(int(sys.argv[1]))
Esempio n. 10
0
 def collect_online_info(self):
     """获取用户数据中心信息"""
     
     logger.info('start collect_online_info')
     
     #获取所有用户
     all_shop = ShopDBService.get_all_shop_list()
     self.nick_shop = {}        
     for shop in all_shop:
         self.nick_shop[shop['nick']] = shop
     
     logger.info('finish collect shop info')
     
     #获取所有订单
     all_order = OrderDBService.get_all_orders_list()
     logger.info('finish collect order info')
     
     self.user_orders = {}
     for order in all_order:
         key = (order['nick'], order['article_code'])
         if not self.user_orders.has_key(key):    
             self.user_orders[key] = []
         self.user_orders[key].append(order)
     
     logger.info('finish arrange order info')
     
     #获取所有退款
     all_refund = RefundDBService.get_all_refunds_list()
     refund_list = [refund['order_id'] for refund in all_refund]
     
     logger.info('finish collect refund info')
     
     for key in self.user_orders.keys():
         real_orders = []
         orders = self.user_orders[key]
         orders.sort(key=lambda order:order['order_cycle_start'])
         for i in range(len(orders)):
             order = orders[i]
             if int(order['total_pay_fee']) > 500:
                 if i < len(orders) - 1:
                     next_order = orders[i+1]
                     if int(next_order['total_pay_fee']) <= 500 and next_order['biz_type'] == 2:
                         order['order_cycle_end'] = next_order['order_cycle_end']
                 real_orders.append(order)
         self.user_orders[key] = real_orders
     logger.info('finish collect_online_info')
Esempio n. 11
0
    def collect_update_info(self):
        """收集更新"""

        for shop in self.nick_shop.values():
            worker_id = shop.get('worker_id', None)
            if not worker_id:
                logger.info('%s worker_id 为 none' % (shop['nick']))
                print '%s worker_id 为 none' % (shop['nick'])
                continue
            upset_flag = False
            normal_flag = False

            for article_code in self.code_name.keys():
                key = shop['nick'] + article_code
                article_status = article_code + '_status'
                article_order = article_code + '_order_id'
                article_deadline = article_code + '_deadline'

                #获取shop中关于该产品的信息
                deadline = shop.get(article_deadline, None)
                order = self.user_order.get(key, None)
                order_id = shop.get(article_order, None)
                supports = self.user_supports.get(key, [])

                if not order and order_id:
                    #新退款用户
                    shop[article_order] = None
                    shop[article_status] = '退款'
                    shop[article_code + '_deadline'] = None
                    upset_flag = True

                if order and order_id != order['order_id']:
                    #新订或续订用户
                    deadline = order['order_cycle_end']
                    shop[article_code + '_deadline'] = deadline
                    shop[article_order] = order['order_id']
                    upset_flag = True
                    #百会导入
                    self.add_orders.append(order)

                if not deadline:
                    #压根没购买过
                    continue

                if deadline < self.time_now and shop[article_status] == '使用中':
                    shop[article_status] = '到期'
                    upset_flag = True

                if deadline > self.time_now:
                    #至少有一个产品是有效的
                    normal_flag = True

                #以下是服务支持部分
                for support in supports:
                    if support['order_id'] != shop[article_order] and \
                            support['support_status'] == '未处理':
                        support['support_status'] = '无效'
                        self.update_supports.append(support)

                if order and order_id != order['order_id']:
                    #新订或续订用户
                    self.update_supports.extend(
                        self.generate_order_supports(order))

            if not normal_flag and shop['flag']:
                #没有一个有效的产品 转变为无效用户
                shop['flag'] = False
                upset_flag = True

            #收集待更新的用户数据
            if upset_flag:
                shop['update_time'] = self.time_now
                self.update_shops.append(shop)
Esempio n. 12
0

def daily_update_script():
    """更新user_center 并将更新导入到百会CRM"""
    logger.info('user_center update start')
    try:
        user_obj = UserCenter(['ts-1796606'])
        user_obj.collect_online_info()
        user_obj.collect_update_info()
        user_obj.write_baihui_info()
        user_obj.update_online()
    except Exception, e:
        logger.exception('user_center update error: %s', str(e))
        send_sms('13738141586', 'user_center update error: ' + str(e))
    else:
        logger.info('user_center update finish')


def reset_useful_support_script():
    """全量更新服务支持"""

    user_obj = UserCenter(['ts-1796606'])
    user_obj.collect_online_info()
    user_obj.collect_reset_supports()
    user_obj.update_online()


def reset_user_worker_relation():
    """重设部分客户客服关系"""

    user_obj = UserCenter(['ts-1796606'])
Esempio n. 13
0
    def collect_update_info(self):
        """收集更新"""
        
        for shop in self.nick_shop.values():
            worker_id = shop.get('worker_id', None)
            if not worker_id:
                logger.info('%s worker_id 为 none' % (shop['nick']))
                print '%s worker_id 为 none' % (shop['nick'])
                continue
            upset_flag = False
            normal_flag = False
            
            for article_code in self.code_name.keys():
                key = shop['nick'] + article_code
                article_status = article_code + '_status'
                article_order = article_code + '_order_id'
                article_deadline = article_code + '_deadline'
                
                #获取shop中关于该产品的信息
                deadline = shop.get(article_deadline, None)
                order = self.user_order.get(key, None)
                order_id = shop.get(article_order, None)
                supports = self.user_supports.get(key, [])

                if not order and order_id:
                    #新退款用户
                    shop[article_order] = None
                    shop[article_status] = '退款'
                    shop[article_code + '_deadline'] = None
                    upset_flag = True

                if order and order_id != order['order_id']:
                    #新订或续订用户
                    deadline = order['order_cycle_end']
                    shop[article_code + '_deadline'] = deadline
                    shop[article_order] = order['order_id']
                    upset_flag = True
                    #百会导入
                    self.add_orders.append(order)
                
                if not deadline:
                    #压根没购买过
                    continue

                if deadline < self.time_now and shop[article_status] == '使用中':
                    shop[article_status] = '到期'
                    upset_flag = True

                if deadline > self.time_now:
                    #至少有一个产品是有效的
                    normal_flag = True
                
                #以下是服务支持部分
                for support in supports:
                    if support['order_id'] != shop[article_order] and \
                            support['support_status'] == '未处理':
                        support['support_status'] = '无效'
                        self.update_supports.append(support)
                
                if order and order_id != order['order_id']:
                    #新订或续订用户
                    self.update_supports.extend(self.generate_order_supports(order))

            if not normal_flag and shop['flag']:
                #没有一个有效的产品 转变为无效用户
                shop['flag'] = False
                upset_flag = True

            #收集待更新的用户数据
            if upset_flag:
                shop['update_time'] = self.time_now
                self.update_shops.append(shop)
Esempio n. 14
0
        file_obj.close()

def daily_update_script():
    """更新user_center 并将更新导入到百会CRM"""
    logger.info('user_center update start') 
    try:
        user_obj = UserCenter(['ts-1796606'])
        user_obj.collect_online_info()
        user_obj.collect_update_info()
        user_obj.write_baihui_info()
        user_obj.update_online()
    except Exception,e:
        logger.exception('user_center update error: %s', str(e))
        send_sms('13738141586', 'user_center update error: '+str(e))
    else:
        logger.info('user_center update finish')

def reset_useful_support_script():
    """全量更新服务支持"""

    user_obj = UserCenter(['ts-1796606'])
    user_obj.collect_online_info()
    user_obj.collect_reset_supports()
    user_obj.update_online()

def reset_user_worker_relation():
    """重设部分客户客服关系"""
    
    user_obj = UserCenter(['ts-1796606'])
    user_obj.collect_online_info()
    user_obj.collect_update_worker()
        type_num = {}
        for key in ORDER_TYPE:
            type_num[key] = 0
        order_list = self.order_dict[id_name]
        for order in order_list:
            if not type_num.has_key(order['deadline']):
                type_num['其他'] += 1
            else:
                type_num[order['deadline']] += 1

        return type_num

def analysis_ztc_order_script():
    ToMe = '*****@*****.**'
    ToAll = '*****@*****.**'
    try:
        ztc = ZtcOrderReport()
        ztc.make_report()
        ztc.write_report()
        html = ztc.getHtml()
        #send_email_with_html(ToMe, html, str(datetime.date.today())+'__直通车软件报表内侧版')
        send_email_with_html(ToAll, html, str(datetime.date.today())+'__直通车软件报表公测版')
    except Exception,e:
        logger.exception('analysis_ztc_order_script error: %s' % (str(e)))
        send_sms('13738141586', 'analysis_ztc_order_script error: '+str(e))
    else:
        logger.info('analysis_ztc_order_script ok')

if __name__ == '__main__':
    analysis_ztc_order_script()
Esempio n. 16
0
import DataMonitor.conf.settings
from CommonTools.send_tools import send_sms
from CommonTools.logger import logger
from DataMonitor.monitor.monitor_marketing_cost import monitor_marketing_cost
from DataMonitor.monitor.monitor_order_add import monitor_order_add
from DataMonitor.monitor.monitor_comment_add import monitor_comment_add


def monitor_soft_script():
    try:
        return_info = monitor_soft()
    except Exception, e:
        logger.exception('monitor_soft error: %s', str(e))
        send_sms('13738141586', 'monitor_soft_script error: ' + str(e))
    else:
        logger.info(return_info)


def monitor_soft():
    """软件监测脚本
    1.麦苗科技营销花费 定期监测
    2.省油宝新增订单数 定期监测
    3.省油宝新增评价 定期监测
    4.北斗新增评价 定期监测
    省油宝,ts-1796606
    北斗,ts-1797607
    """
    current_time = datetime.datetime.now()
    rest_hours = range(1, 7)
    if current_time.hour in rest_hours:
        return None