This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Область ОбработчикиСобытийФормы | |
&НаСервере | |
Процедура ПриСозданииНаСервере(Отказ, СтандартнаяОбработка) | |
Если Параметры.Свойство("АвтоТест") Тогда | |
Возврат; | |
КонецЕсли; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Область ОбработчикиСобытийФормы | |
&НаСервере | |
Процедура ПриСозданииНаСервере(Отказ, СтандартнаяОбработка) | |
Если Параметры.Свойство("АвтоТест") Тогда // Возврат при получении формы для анализа. | |
Возврат; | |
КонецЕсли; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Процедура ПриКомпоновкеРезультата(ДокументРезультат, ДанныеРасшифровки, СтандартнаяОбработка) | |
СтандартнаяОбработка = Ложь; | |
ДокументРезультат.Очистить(); | |
ВнешниеНаборыДанных = Новый Структура; | |
ВнешниеНаборыДанных.Вставить("Данные", ПолучитьТаблицуДанных()); | |
КомпоновщикМакета = Новый КомпоновщикМакетаКомпоновкиДанных; | |
МакетКомпоновки = КомпоновщикМакета.Выполнить(СхемаКомпоновкиДанных, КомпоновщикНастроек.ПолучитьНастройки(), ДанныеРасшифровки); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Функция Печать(Ссылка, Идентификатор) | |
ИсточникДанных = ПолучитьИсточникДанных(Идентификатор); | |
ОбъектыНазначения = Новый Массив; | |
ОбъектыНазначения.Добавить(Ссылка); | |
ПараметрыИсточника = Новый Структура; | |
ПараметрыИсточника.Вставить("ИдентификаторКоманды", Идентификатор); | |
ПараметрыИсточника.Вставить("ОбъектыНазначения", ОбъектыНазначения); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
@echo off | |
SET v8="C:\1CData\8.3.9.2170_x64\bin\1cv8.exe" | |
SET cf="C:\1CData\release\1Cv8_2017-05-10.cf" | |
SET db=gr-rphost-01\PLPK_K3_ERP | |
SET logFile="N:\gr\dok\Users\AppData\sitnikov.a\1CData\update.log" | |
SET sqlServer=gr-sql | |
SET backup_sql="\\uniservice.local\net\gr\dok\Users\Desktops\sitnikov.a\Рабочий стол\scripts\backup_erp.sql" | |
if not exist %cf% goto filenotfound |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
cd /D "%~dp0" | |
cscript.exe erp.js |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const Imap = require('imap'); | |
let imap = new Imap({ | |
user: 'user@mail.ru', | |
password: 'pass', | |
host: 'imap.mail.ru', | |
port: 993, | |
tls: true | |
}); | |
function imapConnect(imap) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx | |
--http://infostart.ru/public/128175/ | |
SELECT | |
migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure, | |
'CREATE INDEX [missing_index_' + CONVERT (varchar, mig.index_group_handle) + '_' + CONVERT (varchar, mid.index_handle) | |
+ '_' + LEFT (PARSENAME(mid.statement, 1), 32) + ']' | |
+ ' ON ' + mid.statement | |
+ ' (' + ISNULL (mid.equality_columns,'') | |
+ CASE WHEN mid.equality_columns IS NOT NULL AND mid.inequality_columns IS NOT NULL THEN ',' ELSE '' END |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
EXEC sp_configure 'show advanced options', 1 | |
RECONFIGURE | |
EXEC sp_configure 'xp_cmdshell', 1 | |
RECONFIGURE | |
EXEC xp_cmdshell "del /Q E:\Temp\erp.bak" | |
EXEC sp_configure 'xp_cmdshell', 0 | |
RECONFIGURE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// ==UserScript== | |
// @name ixbt | |
// @namespace http://tampermonkey.net/ | |
// @version 0.12 | |
// @description try to take over the world! | |
// @author You | |
// @match http://www.ixbt.com/* | |
// @grant none | |
// @downloadURL https://gist.githubusercontent.com/a-sitnikov/8b250eaecfb5114e35c2b1c002397daa/raw/user.js | |
// @updateURL https://gist.githubusercontent.com/a-sitnikov/8b250eaecfb5114e35c2b1c002397daa/raw/user.js |
OlderNewer