Skip to content

Instantly share code, notes, and snippets.

Working from home

hellojinjie hellojinjie

View GitHub Profile
title description date categories slug

一. 文字聊天协议族(TCPF, Text Chatting Protocol Family)

View pom.xml
View recovery.sql
select *,from_unixtime(dateline) from ims_checkin_payment where status = 1 and tid like '20180227%' order by dateline desc;
select *,from_unixtime(dateline) from ims_checkin_payment where status = 1 and tid like '20180228%' order by dateline desc;
create table ims_checkin_payment_20180228 as select * from ims_checkin_payment;
insert into ims_checkin_payment (uid, rid, uniacid, tid, amount,dateline, status,weixin_order_id,merchant_order_id)
select uid, rid, uniacid, tid, amount,'1519783300', status,weixin_order_id,merchant_order_id
from ims_checkin_payment where status = 1 and tid like '20180227%';
select *,from_unixtime(dateline) from ims_checkin_payment where status = 1 and tid like '20180227%' and dateline='1519783300' or status = 1 and tid like '20180228%' order by dateline desc;
View oledb_create_excel.cs
var connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\ExcelWorkBook.xls;Extended Properties=Excel 8.0";
using (var excelConnection = new OleDbConnection(connectionString))
// The excel file does not need to exist, opening the connection will create the
// excel file for you
// data is an object so it works with DBNull.Value
object propertyOneValue = "cool!";
object propertyTwoValue = "testing";
hellojinjie / node-gyp.cmd
Created Dec 25, 2017
Install tools and configuration manually: Visual C++ Build Environment: Option 1: Install Visual C++ Build Tools using the Default Install option. Option 2: Install Visual Studio 2015 (or modify an existing installation) and select Common Tools for Visual C++ during setup. This also works with the free Community and Express for Desktop editions. 💡
View node-gyp.cmd
npm config set msvs_version 2015
View jquery_float.js
$.fn.smartFloat = function() {
var position = function(element) {
var top = element.position().top, pos = element.css("position");
$(window).scroll(function() {
var scrolls = $(this).scrollTop();
if (scrolls > top) {
if (window.XMLHttpRequest) {
position: "fixed",
top: 0
View using lodash template in c#.js
_.templateSettings = {
interpolate : /\{\{(.+?)\}\}/g, // print value: {{ value_name }}
evaluate : /\{%([\s\S]+?)%\}/g, // excute code: {% code_to_execute %}
escape : /\{%-([\s\S]+?)%\}/g // excape HTML: {%- <script> %} prints &lt;script&gt;
hellojinjie / Utils.cs
Last active Dec 17, 2017
C# DataTable to JSON
View Utils.cs
public class Utils
public static object DataTableToObject(DataTable dataTable)
var list = new List<object>();
foreach (DataRow row in dataTable.Rows)
var pairList = new List<KeyValuePair<string, object>>();
foreach (DataColumn column in dataTable.Columns)
View gist:54b4432fffaf0c67b176
function getTaobaoURLFromShortURL($shortURL)
$contents = file_get_contents($shortURL);
$pattern = '/d="J_Url" value=\'(.+)\'>./';
preg_match($pattern, $contents, $matches);
return urldecode($matches[1]);
function getItemIdFromURL($itemURL)
View onlineview.sql
d.parent_id, views, cdn,
from_unixtime(1405267200 + row_number * 60) as step_time
apptype_id, game_id, count(view_id) AS views, r.row_number,
sum(bytes_loaded_cdn1 + bytes_loaded_cdn2 + bytes_loaded_cdn3 + bytes_loaded_cdn4) /duration as cdn
@curRow:=@curRow + 1 AS row_number
You can’t perform that action at this time.