# Отправка электронного письма
def send_email(message):
msg_email = MIMEMultipart()
msg_email['From'] = email_from
msg_email['To'] = email_to
msg_email['Subject'] = 'Тема'
body = 'Текст сообщения'
msg_email.attach(MIMEText(body, 'plain'))
server = smtplib.SMTP_SSL('smtp.mail.ru:465')
server.login(email_from, email_password)
text = msg_email.as_string()
server.sendmail(email_from, email_to, text)
server.quit()
def xlsx(message):
time.sleep(3)
date = datetime.now()
quantity = message
doc = openpyxl.load_workbook(filename='table.xlsx')
sheet = doc['test']
rows = (
(date, quantity),
)
for row in rows:
sheet.append(row)
doc.save('table.xlsx')
from vk_api.bot_longpoll import VkBotLongPoll, VkBotEventType
vk_session = vk_api.VkApi(token=constant.token)
vk = vk_session.get_api()
longpoll = VkBotLongPoll(vk_session, constant.group_id)
# Обработка событий ВК
for event in longpoll.listen():
# Начало беседы
if event.obj.text == 'Начать':
...
from pyrogram import Client
app = Client(
session_name="pyro",
proxy=dict(
hostname="",
port=1080,
username="",
password=""),
api_id='',
api_hash='')
app.start()
app.send_message(chat_id=123, text='привет')
app.stop()
from ldap3 import Server, Connection, SUBTREE
s = Server(ad_domain, use_ssl=True, port=636) # Адрес домена, шифрование, порт
c = Connection(s, ad_admin, ad_password)
# Поиск учётной записи в домене (Active Directory) по фамилии или логину
def search_ad(last='*', login='*'):
c.bind()
c.search('ou=Офис, dc=domain, dc=local',
'(&(objectCategory=Person)(sn={})(sAMAccountName={}))'.format(last, login), SUBTREE,
attributes=['sAMAccountName', 'givenName', 'sn', 'cn', 'whenCreated', 'lastLogon', 'pwdLastSet',
'msDS-UserPasswordExpiryTimeComputed', 'memberOf', 'ipPhone', 'lockoutTime',
'distinguishedName'])
a = c.entries
c.unbind()
return a
# Вывод информации учётной записи в домене (Active Directory)
def change_ad(cn):
c.bind()
c.search('ou=Офис, dc=domain, dc=local', '(&(objectCategory=Person)(cn={}))'.format(cn), SUBTREE,
attributes=['sAMAccountName', 'givenName', 'sn', 'cn', 'whenCreated', 'lastLogon', 'pwdLastSet',
'msDS-UserPasswordExpiryTimeComputed', 'memberOf', 'ipPhone', 'lockoutTime'])
a = c.entries
for ad_user in c.entries:
name = ad_user['givenName']
last = ad_user['sn']
login = ad_user['sAMAccountName']
# Отправка электронного письма
def send_email(message):
msg_email = MIMEMultipart()
msg_email['From'] = email_from
msg_email['To'] = email_to
msg_email['Subject'] = 'Тема'
body = 'Текст сообщения'
msg_email.attach(MIMEText(body, 'plain'))
server = smtplib.SMTP_SSL('smtp.yandex.ru:465')
server.login(email_from, email_password)
text = msg_email.as_string()
server.sendmail(email_from, email_to, text)
server.quit()
from PIL import Image
import pytesseract
pytesseract.pytesseract.tesseract_cmd = r'C:\Users\Violet\AppData\Local\Tesseract-OCR\tesseract.exe'
print(pytesseract.image_to_string(Image.open(r'img\driver_fr\777.jpg'), lang="rus"))
def uis_request_data(message):
if message.text.lower() == 'отмена':
bot.send_message(message.from_user.id, 'На нетъ и суда нетъ')
return
global domain_uis
domain_uis = message.text.lower()
send = bot.send_message(message.chat.id, 'Введiте: ФИО должность нумер')
bot.register_next_step_handler(send, create_uis)
def create_uis(message):
first = message.text.split()[1]
last = message.text.split()[0]
middle = message.text.split()[2]
phone = message.text.split()[4]
position = message.text.split()[3]
uis_login = create_nickname(first, last, middle, 'create_uis')
bot.send_message(message.chat.id, '✅ логiнъ')
uis_password = create_password()
bot.send_message(message.chat.id, '✅ шiфръ')