$query = ("
INSERT INTO `order_archive`(`id`, `user_id`, `articul_id`, `barcode`, `quantity`, `supply_id`) VALUES ($supply_id)
SELECT `id`, `user_id`, `articul_id`, `barcode`, `quantity`, " . $supply_id . " as supply_id FROM `order` WHERE `id` IN ($ids);
DELETE FROM `order` WHERE `id` IN ($ids)");@bot.message_handler(commands=['start'])
def start(message):
msg = bot.send_message(message.chat.id,'Здравствуйте, отправьте адреса кошельков что бы между адресами был пробел(запятая и перевод строки не подходят),')
bot.register_next_step_handler(msg, sender)
@bot.message_handler(func=lambda m: True)
def sender(message):
urls_list = []
price_list = []
user_id = message.from_user.id
number = (len(message.text.split(' ')))
for count in range(0,number):
addresses = message.text.split(' ')[count]
response = requests.get(url = f'https://api.debank.com/hi/user/info?id={addresses}', headers=HEADERS).text
price = response.split('"usd_value":')[1].split(',')[0].split('.')[0]
print(price)
urls_list.append('https://debank.com/profile/' + addresses)
price_list.append(price)
df = pd.DataFrame ({'urls':urls_list,'amounts':price_list})
df.to_excel(f'D:\PYTHON\DeBank\{user_id}.xlsx', sheet_name='Info', index=False)
file = open(f'D:\PYTHON\DeBank\{user_id}.xlsx','rb')
bot.send_document(message.chat.id,file)
#Здесь удали файл 'D:\PYTHON\DeBank\{user_id}.xlsx'public function updateDevMode(){
$devices_dep = "YOUR_TABLE_NAME";
$device_mode=htmlspecialchars(strip_tags($this->device_mode));
$id=htmlspecialchars(strip_tags($this->id));
$sqlQuery = "UPDATE $devices_dep SET device_mode=$device_mode WHERE id=$id";
$this->db->query($sqlQuery);
if($this->db->affected_rows > 0){
return true;
}
return false;
}class TgClient:
def __init__(self, session_file, api_id, api_hash):
...
client = TelegramClient(self.session_file, self.api_id, self.api_hash)
@client.on(events.NewMessage(incoming=True)
def handler(event):
# some action after reciving a message