def setUpClass(cls):
cls.mysql = mysql_connect.mysql_connect()
cls.time_handle = time_Handle.time_Handle()
cls.pu = public_modelu.public_modelu()
cls.sales_upMD = [] # 可以晋升的账号（行销）
cls.sales_upSL = [] # 可以晋升的账号（销售组长）
cls.sales_down = [] # 可以降级的账号
def setUpClass(cls):
cls.public_modelu = public_modelu.public_modelu()
cls.time_handle = time_Handle.time_Handle()
cls.mysql = mysql_connect.mysql_connect()
cls.jidu = 1 # 测试季度：1、2、3、4
# 设置各季度的特殊时间
cls.year = str(cls.time_handle.get_Current_Year())
cls.quarter = {
'month_3': cls.year + '-01',
'month_2': cls.year + '-02',
'month_1': cls.year + '-03'
}
cls.months_pd = {'pd_1': 11, 'pd_2': 10}
if cls.jidu == 2:
cls.quarter = {
'month_3': cls.year + '-04',
'month_2': cls.year + '-05',
'month_1': cls.year + '-06'
}
cls.months_pd = {'pd_1': 8, 'pd_2': 7}
elif cls.jidu == 3:
cls.quarter = {
'month_3': cls.year + '-07',
'month_2': cls.year + '-08',
'month_1': cls.year + '-09'
}
cls.months_pd = {'pd_1': 5, 'pd_2': 4}
elif cls.jidu == 4:
cls.quarter = {
'month_3': cls.year + '-10',
'month_2': cls.year + '-11',
'month_1': cls.year + '-12'
}
cls.months_pd = {'pd_1': 2, 'pd_2': 1}
def setUpClass(cls):
cls.mysql = mysql_connect.mysql_connect()
cls.time_handle = time_Handle.time_Handle()
cls.pu = public_modelu.public_modelu()
cls.sales_down_md1 = [] # 可降级的行销主任
cls.sales_down_md2 = [] # 可降级的高级行销主任
cls.sales_down_md3 = [] # 可降级的资深行销主任
cls.sales_down_md4 = [] # 可降级的行销经理
cls.sales_up_md2 = [] # 可晋升到高级行销主任的账号
cls.sales_up_md3 = [] # 可晋升到资深行销主任的账号
cls.sales_up_md4 = [] # 可晋升到行销经理的账号
def checkTeamData(self):
'''检查team表，确保组、部、区'''
mysql = mysql_connect.mysql_connect()
for data in orderDTDAmount_data:
mysql.sql_execute("delete from team where id =" +
str(data['team_id']))
sql_insert = "INSERT INTO `spring2017`.`team` (`id`, `name`, `parent_id`, `leader_id`, `type`, `status`, `is_delete`, `created_dt`, `updated_dt`) VALUES ('" + str(
int(data['team_id'])) + "', '" + data['name'] + "', '" + str(
int(data['parent_id'])) + "', '" + str(
int(data['leader_id'])) + "', '" + str(
int(data['type'])
) + "', '0', '0', '1502703540', '1502703540');"
mysql.sql_execute(sql_insert)
def setUpClass(cls):
cls.mysql = mysql_connect.mysql_connect()
cls.time_handle = time_Handle.time_Handle()
cls.pu = public_modelu.public_modelu()
def setUpClass(cls):
cls.mysql = mysql_connect.mysql_connect()
cls.time_handle = time_Handle.time_Handle()
cls.pu = public_modelu.public_modelu()
cls.sales_up = [] # 可以晋升的账号
cls.sales_down = [] # 可以解约的账号
def setUpClass(cls):
cls.mysql = mysql_connect.mysql_connect()
cls.time_handle = time_Handle.time_Handle()
cls.pu = public_modelu.public_modelu()
cls.keepSmSales = [] # 销售经理降级列表
cls.ssmSales = [] # 晋升列表
