Nikolas Demiridis nikolasd

## get_largest_file.sh
find /my/folder/subfolder/ -type f -exec du -Sh {} + | sort -rh | head -n 5

## change_client_supplier_codes.sql
UPDATE hecustomers
SET hecode = a.newcode
FROM (SELECT
  heid,
  concat(LEFT(hecode, 5), RIGHT(concat('00000000', ROW_NUMBER() OVER (ORDER BY hecode)), 8)) AS newcode
FROM hecustomers) AS a
INNER JOIN hecustomers
  ON hecustomers.heid = a.heid

UPDATE hesuppliers

## find_accounting_template_by_docseries.sql
SELECT
    ser.heCode AS DOCSERIES,
    ser.heShortcut AS DOCSERIESSHORTCUT,
    ser.heName AS DOCSERIESNAME,
    typ.heCode AS DOCTYPE,
    typ.heName AS DOCTYPENAME,
    acc.heCode AS ACCTMP,
    acc.heName AS ACCTPMNAME,
    cmp.heName AS CMP
FROM heDocSeries AS ser

## update-reference-number
-- Update sequence current value with max reference number
-- example is for HEITEMS sequence
DECLARE @refno int = (SELECT
    CAST(MAX(HEITEMS.herefnumber) AS int)
FROM HEITEMS)
DECLARE @inc int = (SELECT
    CAST(current_value AS int)
FROM sys.sequences
WHERE name LIKE 'HEITEMS%')

## multiple_dbs_backup
-- Check DBs
/*
DECLARE @pylonVer varchar(20) -- current pylon ver

-- specify current pylon version
SET @pylonVer = '170432'

SELECT
    name
FROM master.dbo.sysdatabases

## convert_str_to_datetime.js
// Convert String to DateTime with ParseExact
docEntry.SetValue("OfficialDate", DateTime.ParseExact(Convert.ToString(listDic[0]["OfficialDate"]), "yyyy-MM-dd hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture))

## sales.sql
SELECT
    DOCENTRIES.HEID,
    DOCENTRIES.HEENTRYDATE,
    DOCENTRIES.HEOFFICIALDATE,
    DOCENTRIES.HEDOCCODE,
    DOCENTRIES.HESTATUS,
    DOCENTRIES.HEDOCNUM,
    DOCENTRIES.HESOURCETYPE,
    DOCENTRIES.HEDCSRID,
    DOCENTRIES.HEDCSRTYPE,

## find_db_version.sql
SELECT
    POVALSTR
FROM POSYS
WHERE POKEY = 'Application Version'

## find_hotel_creditors.sql
SELECT
    *
FROM HECUSTOMERS
INNER JOIN HEHOTELCUSTOMERS
    ON HEHOTELCUSTOMERS.HECSTMID = HECUSTOMERS.HEID
WHERE HEHOTELCUSTOMERS.HECUSTTYPE = '1'

## find_docseries_with_scaffold.sql
SELECT
    ser.heCode AS DOCSERIES,
    ser.heShortcut AS DOCSERIESSHORTCUT,
    ser.heName AS DOCSERIESNAME,
    typ.heCode AS DOCTYPE,
    typ.heName AS DOCTYPENAME,
    acc.heCode AS ACCTMP,
    acc.heName AS ACCTPMNAME,
    cmp.heName AS CMP
FROM heDocSeries AS ser
	UPDATE hecustomers
	SET hecode = a.newcode
	FROM (SELECT
	heid,
	concat(LEFT(hecode, 5), RIGHT(concat('00000000', ROW_NUMBER() OVER (ORDER BY hecode)), 8)) AS newcode
	FROM hecustomers) AS a
	INNER JOIN hecustomers
	ON hecustomers.heid = a.heid

	UPDATE hesuppliers
	SELECT
	ser.heCode AS DOCSERIES,
	ser.heShortcut AS DOCSERIESSHORTCUT,
	ser.heName AS DOCSERIESNAME,
	typ.heCode AS DOCTYPE,
	typ.heName AS DOCTYPENAME,
	acc.heCode AS ACCTMP,
	acc.heName AS ACCTPMNAME,
	cmp.heName AS CMP
	FROM heDocSeries AS ser
	-- Update sequence current value with max reference number
	-- example is for HEITEMS sequence
	DECLARE @refno int = (SELECT
	CAST(MAX(HEITEMS.herefnumber) AS int)
	FROM HEITEMS)
	DECLARE @inc int = (SELECT
	CAST(current_value AS int)
	FROM sys.sequences
	WHERE name LIKE 'HEITEMS%')
	-- Check DBs
	/*
	DECLARE @pylonVer varchar(20) -- current pylon ver

	-- specify current pylon version
	SET @pylonVer = '170432'

	SELECT
	name
	FROM master.dbo.sysdatabases
	// Convert String to DateTime with ParseExact
	docEntry.SetValue("OfficialDate", DateTime.ParseExact(Convert.ToString(listDic[0]["OfficialDate"]), "yyyy-MM-dd hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture))
	SELECT
	DOCENTRIES.HEID,
	DOCENTRIES.HEENTRYDATE,
	DOCENTRIES.HEOFFICIALDATE,
	DOCENTRIES.HEDOCCODE,
	DOCENTRIES.HESTATUS,
	DOCENTRIES.HEDOCNUM,
	DOCENTRIES.HESOURCETYPE,
	DOCENTRIES.HEDCSRID,
	DOCENTRIES.HEDCSRTYPE,
	SELECT
	*
	FROM HECUSTOMERS
	INNER JOIN HEHOTELCUSTOMERS
	ON HEHOTELCUSTOMERS.HECSTMID = HECUSTOMERS.HEID
	WHERE HEHOTELCUSTOMERS.HECUSTTYPE = '1'