def do_rec(cur, cur_mysql, in_sql):
    line_id = None
    while 1:
        subject = ''
        start_date = '2000-01-01 00:00:00'
        one = cur.fetchone()
        if one != None:
            sql = in_sql
            #print(':\n-------------------------------%s' % type(one))
            cnt = len(one)
            #print one
            for i in range(cnt):
                #print i,one[i]
                if i != 0:
                    if i == 12:
                        form_appid = one[12]
                        if form_appid == None:
                            #print(">>>form_appid=%s" % str(form_appid))
                            line_id = None
                        else:
                            # 注意:针对优先办理等特权情况,无法用此方法获取line_id,因为这些form可针对所有业务
                            line_id = utils.get_lineid_by_formid(
                                cur_mysql, form_appid)
                            #print(">>>line_id=%s<<<" % line_id)
                    sql += ','
                else:
                    summary_id = one[0]
                if i == 3:
                    # 新增记录,设定法定期限为8天
                    sql += '8'
                elif i == 13:
                    # for VOUCH
                    sql += '0'
                else:
                    sql += '"' + str(one[i]) + '"'
                    if i == 2:
                        subject = str(one[i]).replace('"', '-')
                    if i == 8:
                        start_member = str(one[i])
                    if i == 6:
                        start_date = str(one[i])

        else:
            break

        # 设定岗位期限为8天
        sql += ",8,"
        if utils.is_include(cur_mysql, 'col_summary', summary_id) == 0:

            print("++++")
            # 2015-12-19: 新加入的summary没有优先办理特权
            if line_id != None:
                if "分管领导指派优先办理" in subject:
                    sql += "0,5,0)"
                else:
                    # 设置新增的申请单在 业务线的第一个(sn=0)岗位上
                    sql += "%s,1,0)" % line_id
            else:
                sql += "0,1,0)"
            print sql
            # 保存记录
            cur_mysql.execute(sql)
            # 添加流水号
            yw_sn = utils.get_sn(cur_mysql, summary_id)

            print(">>>流水号:%s<<<" % yw_sn)
            if yw_sn != None:
                rec = utils.build_ServiceObject(cur_mysql, summary_id)
                sql = 'update col_summary set yw_sn="%s",' \
                      'org_code="%s",org_name="%s",org_addr="%s",org_capital="%s",org_reg_number="%s",org_reg_addr="%s",' \
                      'legal_person="%s",legal_person_tel="%s",legal_person_cid="%s" where id="%s"' % \
                      (yw_sn,rec['bar_code'],rec['name'],rec['addr'],rec['registered_capital'],
                       rec['registeration_number'],rec['registered_addr'],
                       rec['legal_representative_name'],rec['legal_representative_tel'],rec['legal_representative_id'],summary_id)
                print sql
                cur_mysql.execute(sql)
def do_rec(cur, cur_mysql, in_sql):
    line_id = None
    while 1:
        subject = ''
        start_date = '2000-01-01 00:00:00'
        one = cur.fetchone()
        if one != None:
            sql = in_sql
            #print(':\n-------------------------------%s' % type(one))
            cnt = len(one)
            #print one
            for i in range(cnt):
                #print i,one[i]
                if i != 0:
                    if i == 12:
                        form_appid = one[12]
                        if form_appid == None:
                            #print(">>>form_appid=%s" % str(form_appid))
                            line_id = None
                        else:
                            # 注意:针对优先办理等特权情况,无法用此方法获取line_id,因为这些form可针对所有业务
                            line_id = utils.get_lineid_by_formid(
                                cur_mysql, form_appid)
                            #print(">>>line_id=%s<<<" % line_id)
                    sql += ','
                else:
                    summary_id = one[0]
                if i == 3:
                    # 新增记录,设定法定期限为8天
                    sql += '8'
                elif i == 13:
                    # for VOUCH
                    sql += '0'
                else:
                    sql += '"' + str(one[i]) + '"'
                    if i == 2:
                        subject = str(one[i])
                    if i == 8:
                        start_member = str(one[i])
                    if i == 6:
                        start_date = str(one[i])

        else:
            break

        # 设定岗位期限为8天
        sql += ",8,"
        if utils.is_include(cur_mysql, 'col_summary', summary_id) == 0:

            print("++++")
            # 2015-12-19: 新加入的summary没有优先办理特权
            if line_id != None:
                if "分管领导指派优先办理" in subject:
                    sql += "0,5,0)"
                else:
                    # 设置新增的申请单在 业务线的第一个(sn=0)岗位上
                    sql += "%s,1,0)" % line_id
            else:
                sql += "0,1,0)"
            print sql
            # 保存记录
            cur_mysql.execute(sql)
            # 添加流水号
            yw_sn = utils.get_sn(cur_mysql, summary_id)
            print(">>>流水号:%s<<<" % yw_sn)
            if yw_sn != None:
                sql = 'update col_summary set yw_sn="%s" where id="%s"' % (
                    yw_sn, summary_id)
                #print sql
                cur_mysql.execute(sql)
            else:
                yw_sn = ""

            #--------------------------------------------------
            # !!!若这是一个“特权”事件,则需执行其特权行为 !!!
            #
            utils.set_summary_pri(cur_mysql, summary_id, yw_sn, start_member)

            # for resent_time,用于放置 受理时间
            if (("人力资源服务许可" in subject) or ("劳务派遣" in subject) or
                ("自动发起" in subject)) and (line_id is not None):

                # 获取业务节点(受理)期限(天)
                nday = utils.get_post_deadline(cur_mysql, line_id, 1)
                if nday is not None:
                    sql = 'update col_summary set cnt="%s" where id="%s"' % (
                        nday, summary_id)
                    #print sql
                    cur_mysql.execute(sql)

                # 获取该申请的受理时间
                acc_time = utils.get_summary_feild_value(
                    cur_mysql, summary_id, "受理时间")
                #print(">>>受理时间:%s" % val )
                if acc_time is not None:
                    sql = 'update col_summary set resent_time="%s" where id="%s"' % (
                        acc_time, summary_id)
                    #print sql
                    cur_mysql.execute(sql)
                else:
                    # 若无受理时间,则认为是当前时间
                    acc_time = time.strftime("%Y-%m-%d %H:%M:%S",
                                             time.localtime(time.time()))
                    sql = 'update col_summary set resent_time="%s" where id="%s"' % (
                        acc_time, summary_id)
                    #print sql
                    cur_mysql.execute(sql)

                # 通过业务线line_id,检查申请是否带齐必要的附件
                # 如果未带齐,则发出“风险”警告
                #
                #print(">>>1<<<")
                # 2015-12-27 针对“补正”系统会自动发起新的summary记录,此时,不用判断附件情况
                #
                if ("(自动发起)" not in subject) and (not utils.chk_file(
                        cur_mysql, summary_id, line_id)):
                    #print(">>>Here!<<<")

                    user_name = utils.get_user_name(cur_mysql, start_member)

                    utils.send_alarm(cur_mysql,start_member,summary_id,line_id,yw_sn,"【数据铁笼风险提示】:%s,在受理《%s》<%s>时,提交材料存在缺失项,请知悉。" \
                        % (user_name,subject,yw_sn))

                    # 向上级汇报
                    members = utils.get_leader(cur_mysql, line_id, 0, 0)
                    members += utils.get_leader(cur_mysql, line_id, 0, 1)
                    for member in members:
                        leader_name = utils.get_user_name(cur_mysql, member)
                        #send_alarm(cur_mysql1,member,"【数据铁笼提示】:%s,好:%s在办的《%s》%s已超期,请知悉。" % (leader_name,user_name,subject,post_name))            # 负数表示超出的天数
                        utils.send_info(cur_mysql,member,"【数据铁笼风险通报】%s,好:%s在受理《%s》时,提交材料存在缺失项,请知悉。" \
                            % (leader_name,user_name,subject))

                # 检查提交时间start_date与“受理时间”acc_time之间的间隔是否超过一天?
                # 若超过,则报风险
                now_d = datetime.datetime.now()
                if acc_time == "None" or acc_time == None or acc_time == "NONE":
                    acc_time = now_d.strftime("%Y-%m-%d %H:%M:%S")
                acc_d = datetime.datetime.strptime(acc_time,
                                                   "%Y-%m-%d %H:%M:%S")

                # 时间戳(分钟计)
                now_ts = int(time.mktime(now_d.timetuple())) / 60
                acc_ts = int(time.mktime(acc_d.timetuple())) / 60

                # 记录 某人 在 该业务线节点上 处理申报所占用时间 now_ts - last_ts
                min_cnt = utils.cal_workdays(
                    cur_mysql, acc_time, now_d.strftime('%Y-%m-%d %H:%M:%S'))

                if "(自动发起)" in subject:
                    sql = 'insert into kpi_001(member,summary_id,line_id,sn,dtime,start_date) values("%s","%s",%s,%s,%d,"%s")' \
                                % (start_member,summary_id,line_id,1,min_cnt,acc_time)
                else:
                    sql = 'insert into kpi_001(member,summary_id,line_id,sn,dtime,start_date) values("%s","%s",%s,%s,%d,"%s")' \
                                % (start_member,summary_id,line_id,0,min_cnt,acc_time)

                #sql = 'insert into kpi_001(member,summary_id,line_id,sn,dtime,start_date) values("%s","%s",%s,%s,%d,"%s")' \
                #            % (start_member,summary_id,line_id,0,now_ts-acc_ts,acc_time)
                cur_mysql.execute(sql)

                # 添加 业务日志
                utils.yw_log(cur_mysql, summary_id, start_member, 0, acc_time,
                             now_d.strftime('%Y-%m-%d %H:%M:%S'), min_cnt)

                #if (now_ts>acc_ts) and ((now_ts-acc_ts)>(24*60)):
                # 工作耗时超过7.5小时
                if min_cnt >= 450:

                    # 提交日期 超过 受理日期 一天以上
                    # 风险提示

                    user_name = utils.get_user_name(cur_mysql, start_member)

                    utils.send_alarm(cur_mysql,start_member,summary_id,line_id,yw_sn,"【数据铁笼风险提示】:%s,在受理《%s》<%s>时超出一天期限,请知悉。" \
                        % (user_name,subject,yw_sn))

                    # 向上级汇报
                    members = utils.get_leader(cur_mysql, line_id, 0, 0)
                    members += utils.get_leader(cur_mysql, line_id, 0, 1)
                    for member in members:
                        leader_name = utils.get_user_name(cur_mysql, member)
                        utils.send_info(cur_mysql,member,"【数据铁笼风险通报】%s,好:%s在受理《%s》时,超出岗位工作期限,请知悉。" \
                            % (leader_name,user_name,subject))

                    # 需要根据此情况调整 deadline 的值
                    n = 8 - (now_ts - acc_ts) / (24 * 60)
                    sql = 'update col_summary set deadline=%d where id="%s"' % (
                        n, summary_id)
                    cur_mysql.execute(sql)

                # 设置第一个时间点
                # 把finish_date用于记录本节点的完成时间
                #
                now = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
                sql = 'update col_summary set finish_date="%s" where id="%s"' % (
                    now, summary_id)
                cur_mysql.execute(sql)
def do_rec(cur,cur_mysql,in_sql):
    line_id = None
    while 1:
        subject = ''
        start_date = '2000-01-01 00:00:00'
        one = cur.fetchone()
        if one!=None:
            sql = in_sql
            #print(':\n-------------------------------%s' % type(one))
            cnt = len(one)
            #print one
            for i in range(cnt):
                #print i,one[i]
                if i!=0:
                    if i==12:
                        form_appid = one[12]
                        if form_appid == None:
                            #print(">>>form_appid=%s" % str(form_appid))
                            line_id = None
                        else:
                            # 注意:针对优先办理等特权情况,无法用此方法获取line_id,因为这些form可针对所有业务
                            line_id = utils.get_lineid_by_formid(cur_mysql,form_appid)
                            #print(">>>line_id=%s<<<" % line_id)
                    sql += ','
                else:
                    summary_id = one[0]
                if i==3:
                    # 新增记录,设定法定期限为8天
                    sql += '8'
                elif i==13:
                    # for VOUCH
                    sql += '0'
                else:
                    sql += '"'+str(one[i])+'"'
                    if i==2:
                        subject = str(one[i]).replace('"','-')
                    if i==8:
                        start_member = str(one[i])
                    if i==6:
                        start_date = str(one[i])

        else:
            break

        # 设定岗位期限为8天
        sql += ",8,"
        if utils.is_include(cur_mysql,'col_summary',summary_id)==0:

            print("++++")
            # 2015-12-19: 新加入的summary没有优先办理特权
            if line_id!=None:
                if "分管领导指派优先办理" in subject:
                    sql += "0,5,0)"
                else:
                    # 设置新增的申请单在 业务线的第一个(sn=0)岗位上
                    sql += "%s,1,0)" % line_id
            else:
                sql += "0,1,0)"
            print sql
            # 保存记录
            cur_mysql.execute(sql)
            # 添加流水号
            yw_sn = utils.get_sn(cur_mysql,summary_id)

            print(">>>流水号:%s<<<" % yw_sn)
            if yw_sn!=None:
                rec = utils.build_ServiceObject(cur_mysql,summary_id)
                sql = 'update col_summary set yw_sn="%s",' \
                      'org_code="%s",org_name="%s",org_addr="%s",org_capital="%s",org_reg_number="%s",org_reg_addr="%s",' \
                      'legal_person="%s",legal_person_tel="%s",legal_person_cid="%s" where id="%s"' % \
                      (yw_sn,rec['bar_code'],rec['name'],rec['addr'],rec['registered_capital'],
                       rec['registeration_number'],rec['registered_addr'],
                       rec['legal_representative_name'],rec['legal_representative_tel'],rec['legal_representative_id'],summary_id)
                print sql
                cur_mysql.execute(sql)
def do_rec(cur, cur_mysql, in_sql):
    line_id = None
    while 1:
        subject = ""
        start_date = "2000-01-01 00:00:00"
        one = cur.fetchone()
        if one != None:
            sql = in_sql
            # print(':\n-------------------------------%s' % type(one))
            cnt = len(one)
            # print one
            for i in range(cnt):
                # print i,one[i]
                if i != 0:
                    if i == 12:
                        form_appid = one[12]
                        if form_appid == None:
                            # print(">>>form_appid=%s" % str(form_appid))
                            line_id = None
                        else:
                            # 注意:针对优先办理等特权情况,无法用此方法获取line_id,因为这些form可针对所有业务
                            line_id = utils.get_lineid_by_formid(cur_mysql, form_appid)
                            # print(">>>line_id=%s<<<" % line_id)
                    sql += ","
                else:
                    summary_id = one[0]
                if i == 3:
                    # 新增记录,设定法定期限为8天
                    sql += "8"
                elif i == 13:
                    # for VOUCH
                    sql += "0"
                else:
                    sql += '"' + str(one[i]) + '"'
                    if i == 2:
                        subject = str(one[i])
                    if i == 8:
                        start_member = str(one[i])
                    if i == 6:
                        start_date = str(one[i])

        else:
            break

        # 设定岗位期限为8天
        sql += ",8,"
        if utils.is_include(cur_mysql, "col_summary", summary_id) == 0:

            print ("++++")
            # 2015-12-19: 新加入的summary没有优先办理特权
            if line_id != None:
                if "分管领导指派优先办理" in subject:
                    sql += "0,5,0)"
                else:
                    # 设置新增的申请单在 业务线的第一个(sn=0)岗位上
                    sql += "%s,1,0)" % line_id
            else:
                sql += "0,1,0)"
            print sql
            # 保存记录
            cur_mysql.execute(sql)
            # 添加流水号
            yw_sn = utils.get_sn(cur_mysql, summary_id)
            print (">>>流水号:%s<<<" % yw_sn)
            if yw_sn != None:
                sql = 'update col_summary set yw_sn="%s" where id="%s"' % (yw_sn, summary_id)
                # print sql
                cur_mysql.execute(sql)
            else:
                yw_sn = ""

            # --------------------------------------------------
            # !!!若这是一个“特权”事件,则需执行其特权行为 !!!
            #
            utils.set_summary_pri(cur_mysql, summary_id, yw_sn, start_member)

            # for resent_time,用于放置 受理时间
            if (("人力资源服务许可" in subject) or ("劳务派遣" in subject) or ("自动发起" in subject)) and (line_id is not None):

                # 获取业务节点(受理)期限(天)
                nday = utils.get_post_deadline(cur_mysql, line_id, 1)
                if nday is not None:
                    sql = 'update col_summary set cnt="%s" where id="%s"' % (nday, summary_id)
                    # print sql
                    cur_mysql.execute(sql)

                # 获取该申请的受理时间
                acc_time = utils.get_summary_feild_value(cur_mysql, summary_id, "受理时间")
                # print(">>>受理时间:%s" % val )
                if acc_time is not None:
                    sql = 'update col_summary set resent_time="%s" where id="%s"' % (acc_time, summary_id)
                    # print sql
                    cur_mysql.execute(sql)
                else:
                    # 若无受理时间,则认为是当前时间
                    acc_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(time.time()))
                    sql = 'update col_summary set resent_time="%s" where id="%s"' % (acc_time, summary_id)
                    # print sql
                    cur_mysql.execute(sql)

                # 通过业务线line_id,检查申请是否带齐必要的附件
                # 如果未带齐,则发出“风险”警告
                #
                # print(">>>1<<<")
                # 2015-12-27 针对“补正”系统会自动发起新的summary记录,此时,不用判断附件情况
                #
                if ("(自动发起)" not in subject) and (not utils.chk_file(cur_mysql, summary_id, line_id)):
                    # print(">>>Here!<<<")

                    user_name = utils.get_user_name(cur_mysql, start_member)

                    utils.send_alarm(
                        cur_mysql,
                        start_member,
                        summary_id,
                        line_id,
                        yw_sn,
                        "【数据铁笼风险提示】:%s,在受理《%s》<%s>时,提交材料存在缺失项,请知悉。" % (user_name, subject, yw_sn),
                    )

                    # 向上级汇报
                    members = utils.get_leader(cur_mysql, line_id, 0, 0)
                    members += utils.get_leader(cur_mysql, line_id, 0, 1)
                    for member in members:
                        leader_name = utils.get_user_name(cur_mysql, member)
                        # send_alarm(cur_mysql1,member,"【数据铁笼提示】:%s,好:%s在办的《%s》%s已超期,请知悉。" % (leader_name,user_name,subject,post_name))            # 负数表示超出的天数
                        utils.send_info(
                            cur_mysql,
                            member,
                            "【数据铁笼风险通报】%s,好:%s在受理《%s》时,提交材料存在缺失项,请知悉。" % (leader_name, user_name, subject),
                        )

                # 检查提交时间start_date与“受理时间”acc_time之间的间隔是否超过一天?
                # 若超过,则报风险
                now_d = datetime.datetime.now()
                if acc_time == "None" or acc_time == None or acc_time == "NONE":
                    acc_time = now_d.strftime("%Y-%m-%d %H:%M:%S")
                acc_d = datetime.datetime.strptime(acc_time, "%Y-%m-%d %H:%M:%S")

                # 时间戳(分钟计)
                now_ts = int(time.mktime(now_d.timetuple())) / 60
                acc_ts = int(time.mktime(acc_d.timetuple())) / 60

                # 记录 某人 在 该业务线节点上 处理申报所占用时间 now_ts - last_ts
                min_cnt = utils.cal_workdays(cur_mysql, acc_time, now_d.strftime("%Y-%m-%d %H:%M:%S"))

                if "(自动发起)" in subject:
                    sql = (
                        'insert into kpi_001(member,summary_id,line_id,sn,dtime,start_date) values("%s","%s",%s,%s,%d,"%s")'
                        % (start_member, summary_id, line_id, 1, min_cnt, acc_time)
                    )
                else:
                    sql = (
                        'insert into kpi_001(member,summary_id,line_id,sn,dtime,start_date) values("%s","%s",%s,%s,%d,"%s")'
                        % (start_member, summary_id, line_id, 0, min_cnt, acc_time)
                    )

                # sql = 'insert into kpi_001(member,summary_id,line_id,sn,dtime,start_date) values("%s","%s",%s,%s,%d,"%s")' \
                #            % (start_member,summary_id,line_id,0,now_ts-acc_ts,acc_time)
                cur_mysql.execute(sql)

                # 添加 业务日志
                utils.yw_log(
                    cur_mysql, summary_id, start_member, 0, acc_time, now_d.strftime("%Y-%m-%d %H:%M:%S"), min_cnt
                )

                # if (now_ts>acc_ts) and ((now_ts-acc_ts)>(24*60)):
                # 工作耗时超过7.5小时
                if min_cnt >= 450:

                    # 提交日期 超过 受理日期 一天以上
                    # 风险提示

                    user_name = utils.get_user_name(cur_mysql, start_member)

                    utils.send_alarm(
                        cur_mysql,
                        start_member,
                        summary_id,
                        line_id,
                        yw_sn,
                        "【数据铁笼风险提示】:%s,在受理《%s》<%s>时超出一天期限,请知悉。" % (user_name, subject, yw_sn),
                    )

                    # 向上级汇报
                    members = utils.get_leader(cur_mysql, line_id, 0, 0)
                    members += utils.get_leader(cur_mysql, line_id, 0, 1)
                    for member in members:
                        leader_name = utils.get_user_name(cur_mysql, member)
                        utils.send_info(
                            cur_mysql,
                            member,
                            "【数据铁笼风险通报】%s,好:%s在受理《%s》时,超出岗位工作期限,请知悉。" % (leader_name, user_name, subject),
                        )

                    # 需要根据此情况调整 deadline 的值
                    n = 8 - (now_ts - acc_ts) / (24 * 60)
                    sql = 'update col_summary set deadline=%d where id="%s"' % (n, summary_id)
                    cur_mysql.execute(sql)

                # 设置第一个时间点
                # 把finish_date用于记录本节点的完成时间
                #
                now = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
                sql = 'update col_summary set finish_date="%s" where id="%s"' % (now, summary_id)
                cur_mysql.execute(sql)