Skip to content

Instantly share code, notes, and snippets.

View siteslave's full-sized avatar

Satit Rianpit siteslave

View GitHub Profile
@siteslave
siteslave / java.config
Created February 18, 2022 04:43
แก้ไขปัญหาเชื่อม MS SQL Server แล้ว error SSL version
jdk.tls.disabledAlgorithms=SSLv3, TLSv1.1, RC4, DES, MD5withRSA, \
DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, \
include jdk.disabled.namedCurves
@siteslave
siteslave / tracking_mysql_log.md
Created February 7, 2022 17:24
Tracking mysql logg

Enable MySql logging.

Check for updates in the logs. Enable logging in MySQL:

Type the following in mysql backend console.

SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';
@siteslave
siteslave / Dockerfile
Created December 15, 2021 14:36
Dockerfile for angular project
# Stage 0
FROM node:14-alpine3.12 as ngbuilder
LABEL maintainer="Satit Rianpit <[email protected]>"
WORKDIR /home/xxx
RUN apk add --upgrade --no-cache --virtual deps python3 build-base git
COPY . .
RUN npm i
RUN npm i -g @angular/cli
RUN npm run build
import { Controller, Get, Query, Res, Header, Response } from '@nestjs/common';
import { TrackingTransactionEntry } from '../entrities/tracking-transaction.entity';
import { ExportService } from '../services/export.service';
const excel = require('excel4node');
import * as moment from 'moment';
@Controller('exports')
export class ExportsController {
constructor(private exportService: ExportService) { }
version: "3"
services:
api:
image: "registry.gitlab.com/moph-training/surat/api:latest"
container_name: "api"
ports:
- 3000:3000
volumes:
- ./config/env:/home/api/config/env
restart: always
@siteslave
siteslave / mophic_sqlite_to_mysql.md
Last active October 17, 2021 14:57
Convert MOPHIC sqlite database to mysql

แก้ไขไฟล์ my.cnf

[client]  
local_infile=1

ไฟล์ script.sh

#!/usr/bin/env sh
import 'dart:math';
import 'package:flutter/material.dart';
MaterialColor generateMaterialColor(Color color) {
return MaterialColor(color.value, {
50: tintColor(color, 0.5),
100: tintColor(color, 0.4),
200: tintColor(color, 0.3),
300: tintColor(color, 0.2),
400: tintColor(color, 0.1),
version: '2'
services:
zookeeper:
image: debezium/zookeeper:1.6
ports:
- 2181:2181
- 2888:2888
- 3888:3888
kafka:
// "sweetalert2": "^11.0.17"
import Swal, { SweetAlertResult } from 'sweetalert2'
var confirm: SweetAlertResult = await Swal.fire({
title: 'ยืนยัน',
text: 'ต้องการยกเลิกการจอง ใช่หรือไม่?',
icon: 'warning',
showCancelButton: true,
confirmButtonText: 'ใช่',
var position = [
{
"position_id": 1,
"position_type_id": 1,
"position_name": "เลขาธิการสำนักงานอัยการสูงสุด (นักบริหาร)",
"status": "1"
},
{
"position_id": 2,
"position_type_id": 1,