def operate(endtime, flowstatus, id): conn = dbinfo() try: conncur = conn.cursor() connsql = "update folder_dfs_flow SET flow_status=%s,end_time=%s where id=%s" conncur.execute(connsql, (flowstatus, endtime, id)) conn.commit() conn.close() return 1 except Exception as e: print(e)
def insert_management_configuration_dfs_api(dfs_api, domain): conn = dbinfo() try: conncur = conn.cursor() connsql = "insert INTO management_configuration(dfs_api,domain) VALUE (%s,%s)" conncur.execute(connsql, (dfs_api, domain)) conn.commit() conn.close() return True except Exception as e: return False
def del_management_configuration_dfs(): conn = dbinfo() try: conncur = conn.cursor() connsql = "update management_configuration SET dfs_group=NULL,Basic_authority=NULL,dfs_manager=NULL,AD_time=0,dfs_relation_name=NULL,dfs_relation=NULL,dfs_relation_mail=NULL" conncur.execute(connsql, ()) conn.commit() conn.close() return True except Exception as e: return False
def update_management_configuration_dfs_api(dfs_api): conn = dbinfo() try: conncur = conn.cursor() connsql = "update management_configuration SET dfs_api=%s" conncur.execute(connsql, (dfs_api)) conn.commit() conn.close() return True except Exception as e: return False
def update_management_configuration_changepwdremindertips(vaule): conn = dbinfo() try: conncur = conn.cursor() connsql = "update management_configuration SET pwdremindertips=%s" conncur.execute(connsql, (vaule)) conn.commit() conn.close() return True except Exception as e: return False
def show_level2name(level2_id): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * from folder_level2 WHERE level2_id=%s" conncur.execute(connsql, (level2_id)) level3dic = conncur.fetchone() conn.commit() conn.close() return level3dic except Exception as e: return False
def getlevel2(): conn = dbinfo() try: conncur = conn.cursor() connsql = "select * from folder_level2" conncur.execute(connsql, ()) histroycounts = conncur.fetchall() conn.commit() conn.close() return histroycounts except Exception as e: return False
def del_folder_first_choice_id(id): conn = dbinfo() try: conncur = conn.cursor() connsql = "delete from folder_first_choice WHERE id=%s" conncur.execute(connsql, (id)) histroycounts = conncur.fetchall() conn.commit() conn.close() return histroycounts except Exception as e: return False
def relationapprovaldb(relationstatus, relationtime, flowstatus, id): conn = dbinfo() try: conncur = conn.cursor() connsql = "update folder_dfs_flow SET relation_status=%s,relation_time=%s,flow_status=%s where id=%s" conncur.execute(connsql, (relationstatus, relationtime, flowstatus, id)) conn.commit() conn.close() return 1 except Exception as e: print(e)
def showlevel2byusername(username): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * FROM folder_level2 WHERE level2_manager=%s" conncur.execute(connsql, (username)) level2namelists = conncur.fetchall() conn.commit() conn.close() except Exception as e: print(e) return level2namelists
def get_management_configuration_copy(): conn = dbinfo() try: conncur = conn.cursor() connsql = "select * from management_configuration_copy limit1 " conncur.execute(connsql, ()) histroycounts = conncur.fetchone() conn.commit() conn.close() return histroycounts except Exception as e: return False
def showgroupnamebyrelation(folder_level3_id, perm_value): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * FROM manager_dfs_group WHERE folder_level3_id=%s and perm_value=%s" conncur.execute(connsql, (folder_level3_id, perm_value)) groupnames = conncur.fetchall() conn.commit() conn.close() except Exception as e: print(e) return groupnames
def directorapproval(directorstatus, directortime, flowstatus, id): conn = dbinfo() try: conncur = conn.cursor() connsql = "update folder_dfs_flow SET director_status=%s,director_time=%s,flow_status=%s where id=%s" conncur.execute(connsql, (directorstatus, directortime, flowstatus, id)) conn.commit() conn.close() return 1 except Exception as e: print(e)
def get_api(title): conn = dbinfo() try: conncur = conn.cursor() connsql = "select * from api where title=%s " conncur.execute(connsql, (title)) histroycounts = conncur.fetchone() conn.commit() conn.close() return histroycounts except Exception as e: return False
def showmyapproval(username): conn = dbinfo() try: conncur = conn.cursor() connsql = """SELECT * FROM folder_dfs_flow WHERE director_adaccount=%s AND flow_status=0""" conncur.execute(connsql, (username)) approvelists = conncur.fetchall() conn.commit() conn.close() except Exception as e: print(e) return approvelists
def checkusernameissamerelation(id, flow_status): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * FROM folder_dfs_flow where id in %(id)s and flow_status = %(flow_status)s" conncur.execute(connsql, {"id": id, "flow_status": flow_status}) username = conncur.fetchall() conn.commit() conn.close() except Exception as e: print(e) return username
def getflowbygroupandusername(username, groupname): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * FROM folder_dfs_flow WHERE username=%s and group_name=%s and flow_status=3" conncur.execute(connsql, (username, groupname)) dictflowids = conncur.fetchall() conn.commit() conn.close() return dictflowids except Exception as e: print(e) return False
def showgroupname(level3id, pervalue): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT group_name from manager_dfs_group where folder_level3_id=%s and perm_value=%s " conncur.execute(connsql, (level3id, pervalue)) groupname = conncur.fetchone() conn.commit() conn.close() return groupname except Exception as e: print(e) return False
def showlevel3(level2id): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT DISTINCT(folder_level3.LEVEL3_id),name,(folder_level3.level3_path) from folder_tree LEFT JOIN folder_level3 ON folder_level3.level3_id=folder_tree.level3_id where level2_id=%s" conncur.execute(connsql, (level2id)) level3 = conncur.fetchall() conn.commit() conn.close() return level3 except Exception as e: print(e) return False
def showlevel3name(level3id): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT name from folder_level3 WHERE level3_id=%s" conncur.execute(connsql, (level3id)) level3dic = conncur.fetchone() conn.commit() conn.close() level3name = level3dic['name'] except Exception as e: print(e) return level3name
def showlevel3names(level3_ids): conn = dbinfo() try: conncur = conn.cursor() # connsql=""SELECT name from folder_level3 where level3_id in (%s)"" % (level3_idlist) connsql = "SELECT name from folder_level3 where level3_id in %(ids)s" conncur.execute(connsql, {"ids": level3_ids}) level3_namelist = conncur.fetchall() conn.commit() conn.close() except Exception as e: print(e) return level3_namelist
def checkdiretorissamerelation(id): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * FROM folder_dfs_flow where id=%s" conncur.execute(connsql, (id)) accounts = conncur.fetchone() conn.commit() conn.close() return accounts except Exception as e: print(e) return False
def checkflow(username, groupname): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT count(folder_dfs_flow.id) as counts from folder_dfs_flow where username=%s and group_name=%s AND flow_status<'3'" conncur.execute(connsql, (username, groupname)) flowidcounts = conncur.fetchone() conn.commit() conn.close() return flowidcounts except Exception as e: print(e) return 0
def get_manager_dfs_group_from(level3_path): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * FROM manager_dfs_group WHERE level3_path=%s" conncur.execute(connsql, (level3_path)) dictflowids = conncur.fetchall() conn.commit() conn.close() return dictflowids except Exception as e: print(e) return False
def sel_folder_dfs_flow_id(id): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * FROM folder_dfs_flow where id = %s" conncur.execute(connsql, (id)) dictflowids = conncur.fetchone() conn.commit() conn.close() return dictflowids except Exception as e: print(e) return False
def showrelationadaccountemail(relation_adaccount): conn = dbinfo() try: conncur = conn.cursor() connsql = """SELECT * FROM folder_dfs_flow where relation_adaccount=%s and flow_status=1""" conncur.execute(connsql, (relation_adaccount)) approvelists = conncur.fetchall() conn.commit() conn.close() except Exception as e: print(e) return approvelists
def sel_folder_api_log(): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT * FROM folder_api_log ORDER by folder_api_log.times DESC" conncur.execute(connsql, ()) dictflowids = conncur.fetchall() conn.commit() conn.close() return dictflowids except Exception as e: print(e) return False
def showidemail(id, username): conn = dbinfo() try: conncur = conn.cursor() connsql = """SELECT * FROM folder_dfs_flow where id in %(id)s and flow_status=3 AND username = %(username)s """ conncur.execute(connsql, {"id": id, "username": username}) approvelists = conncur.fetchall() conn.commit() conn.close() except Exception as e: print(e) return approvelists
def dbinfo_select_global_configuration(): conn = dbinfo() try: conncur = conn.cursor() connsql = "select * from global_configuration " conncur.execute(connsql) histroycounts = conncur.fetchall() conn.commit() conn.close() return histroycounts except Exception as e: print(e) return False
def showtreeid(level1id, level2id, level3id): conn = dbinfo() try: conncur = conn.cursor() connsql = "SELECT tree_id from folder_tree where level1_id=%s and level2_id=%s and level3_id=%s" conncur.execute(connsql, (level1id, level2id, level3id)) treeid = conncur.fetchone() conn.commit() conn.close() return treeid except Exception as e: print(e) return False