Skip to content

Instantly share code, notes, and snippets.

Avatar
🎯
Focusing

Debajyoti Bhaumik debajyoti-xyz

🎯
Focusing
View GitHub Profile
@debajyoti-xyz
debajyoti-xyz / bankremitter_search_findCashRemittanceDetailsForServiceAndFund.sql
Last active Jul 25, 2019
Effective sql when a BankCollectionRemitter search receipts. Please check the parameter values
View bankremitter_search_findCashRemittanceDetailsForServiceAndFund.sql
SELECT
sum(ih.instrumentamount) AS INSTRUMENTMAOUNT,
date(ch.RECEIPTDATE) AS RECEIPTDATE,
sd.NAME AS SERVICENAME,
it.TYPE AS INSTRUMENTTYPE,
fnd.name AS FUNDNAME,
dpt.name AS DEPARTMENTNAME,
fnd.code AS FUNDCODE,
dpt.code AS DEPARTMENTCODE,
us.name AS APPROVERNAME,
@debajyoti-xyz
debajyoti-xyz / bankremitter_search_findCashRemittanceDetailsForServiceAndFund.sql
Created Jul 25, 2019
Effective sql when a BankCollectionRemitter search receipts.
View bankremitter_search_findCashRemittanceDetailsForServiceAndFund.sql
SELECT
sum(ih.instrumentamount) AS INSTRUMENTMAOUNT,
date(ch.RECEIPTDATE) AS RECEIPTDATE,
sd.NAME AS SERVICENAME,
it.TYPE AS INSTRUMENTTYPE,
fnd.name AS FUNDNAME,
dpt.name AS DEPARTMENTNAME,
fnd.code AS FUNDCODE,
dpt.code AS DEPARTMENTCODE,
us.name AS APPROVERNAME,
View BillPaymentDetails-investigate.sql
select
br.billnumber,
br.billdate,
br.billamount as grossAmount ,
br.billstatus,
brm.narration
from eg_billregister br
join eg_billregistermis brm
on brm.billid = br.id
where br.billnumber='ADM/EJV/0011/2019-20';
View gogs_exception_edit_pull.log
May 27 03:58:19 xxxx.domain.xxx gogs[24049]: [Macaron] [Static] Serving /img/eyezon.jpg
May 27 03:58:19 xxxx.domain.xxx gogs[24049]: [Macaron] 2019-05-27 03:58:19: Completed GET /img/eyezon.jpg 200 OK in 3.26505ms
May 27 04:01:12 xxxx.domain.xxx gogs[24049]: [Macaron] 2019-05-27 04:01:12: Started POST /ap-maintenance/AP-MeGov-citizen-app/pulls/10/merge for 106.51.69.20
May 27 04:01:13 xxxx.domain.xxx gogs[24049]: [Macaron] 2019-05-27 04:01:13: Completed POST /ap-maintenance/AP-MeGov-citizen-app/pulls/10/merge 302 Found in 986.209243ms
May 27 04:01:13 xxxx.domain.xxx gogs[24049]: panic: runtime error: invalid memory address or nil pointer dereference
May 27 04:01:13 xxxx.domain.xxx gogs[24049]: [signal SIGSEGV: segmentation violation code=0x1 addr=0x10 pc=0xb7b966]
May 27 04:01:13 xxxx.domain.xxx gogs[24049]: goroutine 3234641 [running]:
May 27 04:01:13 xxxx.domain.xxx gogs[24049]: github.com/gogits/gogs/models.(*Repository).getOwner(0x0, 0x1740da0, 0xc420206dc0, 0xc421aa59e0, 0x36)
May 27 04:01:13 xxxx.domain
View gclone
#!/usr/bin/env python3
import sys
import os
import subprocess
GIT_ROOT=os.getenv('GIT_ROOT') or os.path.join(os.getenv('HOME'), 'code')
if __name__ == '__main__':
cloneURL = sys.argv[1]
if cloneURL.startswith('git+'):
View log_slice.sh
#!/bin/bash
DATE_TIME=$(date +%Y-%m-%d_%H-%M)
CP_FILE=server.log_${DATE_TIME}
if [[ -e $CP_FILE ]]; then
echo "$CP_FILE exists, please try in next min"
exit 1
fi
@debajyoti-xyz
debajyoti-xyz / rbt
Created Mar 19, 2019
some description
View rbt
#!/bin/bash
COPY_OR_RESTORE=$1
TARGET=$HOME/.local
src="egov-collection/src/main/resources/config/payment-gateway.properties egov-egi/src/main/resources/config/application-config.properties"
function file_exists() {
s=$1
if [[ ! -e $s ]];then
View payment-gateway.properties
#
# eGov SmartCity eGovernance suite aims to improve the internal efficiency,transparency,
# accountability and the service delivery of the government organizations.
#
# Copyright (C) 2017 eGovernments Foundation
#
# The updated version of eGov suite of products as by eGovernments Foundation
# is available at http://www.egovernments.org
#
# This program is free software: you can redistribute it and/or modify
View application-config.properties
#
# eGov SmartCity eGovernance suite aims to improve the internal efficiency,transparency,
# accountability and the service delivery of the government organizations.
#
# Copyright (C) 2017 eGovernments Foundation
#
# The updated version of eGov suite of products as by eGovernments Foundation
# is available at http://www.egovernments.org
#
# This program is free software: you can redistribute it and/or modify
View .tmux.conf
# general
set -g base-index 1
set -g pane-base-index 1
set -g renumber-windows on
set -g repeat-time 200
setw -g mode-keys emacs
# set -g mouse on
set -g default-terminal "screen-256color-bce"
set -g escape-time 10