Skip to content

Instantly share code, notes, and snippets.

View yemrekarakas's full-sized avatar
💪
no pain, no gain

Yunus Emre Karakaş yemrekarakas

💪
no pain, no gain
View GitHub Profile
@yemrekarakas
yemrekarakas / adminer.sh
Created July 14, 2024 20:34
Docker run to connect the adminer to the db in any existing container we use.
docker run \
--rm \
--name adminer \
--link bookstack_db \
--network bookstack_default \
-p 40000:8080 \
-e ADMINER_DESIGN='nette' \
-d \
adminer
@yemrekarakas
yemrekarakas / nesneler.js
Created June 29, 2021 08:51
CPM Master - Evrak icindeki nesne adlari
var text = "";
var path = "C:\\Users\\yek\\Desktop\\";
var file = "nesneler.txt"
var i = 0;
while (i != DocObject.MainForm.ComponentCount) {
text = DocObject.MainForm.Components(i).Name;
if (text.indexOf("Child") > -1) {
writeFile(path, file, text);
}
@yemrekarakas
yemrekarakas / evrak_ajan_hucre_renklendirme.js
Created January 17, 2021 13:25
Evrak ajan hücre renklendirme
//BAŞLA
ChildEvrakAjan.GridViewMaster.SetEvent(Scripter, "OnCustomDrawCell", "ChildEvrakAjanOnCustomDrawCell", true);
//GENEL
var fieldSKod1 = null;
function ChildEvrakAjanOnCustomDrawCell(Sender, ACanvas, AViewInfo, ADone) {
if (!fieldSKod1)
fieldSKod1 = ChildEvrakAjan.GridViewMaster.GetColumnByFieldName("SKOD1");
@yemrekarakas
yemrekarakas / tsql_merkez_bankasi_doviz_kurlari.sql
Created October 12, 2020 11:19
tsql_merkez_bankasi_doviz_kurlari
SET TEXTSIZE 2147483647;
DECLARE @OBJ INT;
DECLARE @RESULT INT;
DECLARE @URL VARCHAR(1000);
SET @URL = 'https://www.tcmb.gov.tr/kurlar/today.xml';
EXEC @RESULT = sys.sp_OACreate 'MSXML2.XMLHTTP', @OBJ OUT;