Skip to content

Instantly share code, notes, and snippets.

View jocoonopa's full-sized avatar

jocoonopa jocoonopa

3 followers · 7 following
View GitHub Profile
@jocoonopa
jocoonopa / 庫存.sql
Last active November 17, 2015 05:39
SELECT
DISTINCT(PIS_InitialWarehouseAmount.GoodsSerNo),
PIS_Warehouse.Name AS 倉庫名稱,
PIS_Warehouse.Address AS 倉庫地址,
PIS_Warehouse.Tel AS 倉庫電話,
PIS_Goods.Name AS 商品名稱,
PIS_GoodsLargeCategory.Name AS 商品大分類,
PIS_GoodsMiddleCategory.Name AS 商品中分類,
PIS_GoodsLittleCategory.Name AS 商品小分類,
PIS_InitialWarehouseAmount.LastAmount AS 庫存量,
@jocoonopa
jocoonopa / Daily_Sale_Record_CTI.sql
Last active October 25, 2015 11:40
SELECT
LEFT(CONVERT(char(10), starttime, 112), 6) AS 月份,
RTRIM([AgentCD]) AS 人員代碼,
COUNT(DISTINCT([CustId])) AS 撥打會員數,
COUNT(TaskCD) AS 撥打通數,
SUM(DATEDIFF(second,StartTime,EndTime)) AS 撥打秒數,
COUNT(DISTINCT(day(starttime))) AS 工作日
FROM CALLCENTER.dbo.CallLog
WHERE
custId NOT LIKE 'CT.'
@jocoonopa
jocoonopa / backAndII.js
Created November 25, 2013 13:08
// 參考:http://dreamerslab.com/blog/tw/javascript-callbacks/
function do_a ( callback ) {
setTimeout( function() {
// 模擬一個需要長間的 function
console.log( '`do_a`: 這個需要的時間比 `do_b` 長' );
// 如果 callback 存在的話就執行他
callback();
}, 3000 );
}
@jocoonopa
jocoonopa / codingStyle.php
Created November 23, 2013 05:15
<?php
/********** Example1: *************/
// Original
if ( isset( $var) ) {
$var = 'test';
}
// 改成這樣->
@jocoonopa
jocoonopa / namespaceIntro.php
Created November 22, 2013 09:41
<?php
namespace com\rsumilang\common;
class Object {
// ... code ...
}
?>
@jocoonopa
jocoonopa / publicprotected.html
Last active December 29, 2015 01:39
<!doctype html>
<html lang="zh-tw">
<head>
<meta charset="UTF-8">
<title>Javascript的奇幻物件之旅</title>
<script src="//code.jquery.com/jquery-1.9.1.js"></script>
</head>
<body>
<div>公私有屬性方法簡單介紹</div>
</body>
@jocoonopa
jocoonopa / systemFunctionSimpleDemo.php
Last active December 28, 2015 22:59
<?php
echo "system<br/>";
echo "<pre>會將內容直接輸出:</pre>";
echo "<pre>";
$last_line = system('ls', $status_code);
echo "</pre>";
echo "<pre>只會有最後一行:".$last_line."</pre>";
echo "<pre>狀態碼:".$status_code."</pre>";
@jocoonopa
jocoonopa / DeferredDemo_1.html
Last active December 28, 2015 20:49
<!doctype html>
<html lang="zh-tw">
<head>
<meta charset="UTF-8">
<title>Deferred Object Simple Demo</title>
<script src="//code.jquery.com/jquery-1.9.1.js"></script>
</head>
<body>
<input type="text" value="" />
@jocoonopa
jocoonopa / jQueryOnMethodDemo.js
Created November 20, 2013 01:33
$( 'selector' ).on( event, fn);
//Its equal to
$( 'selector' ).bind( event, fn);
$( document ).on( event, 'selector', fn);
//Equal to
$( 'selector' ).live( event, fn);
@jocoonopa
jocoonopa / strangeFloatFix.js
Created November 19, 2013 08:44
Math.formatFloat = function (f, digit) {
var m = Math.pow( 10, digit);
return parseInt(f * m, 10) / m;
}
var numA = 0.1;
var numB = 0.2;
alert(Math.formatFloat( numA + numB, 1) === 0.3);