0rz..........

真的有夠無言= =

每次發來的測試結果ppt檔

問題都一再重複

一再一再

吼!!!!!!!!!!!!!!!!

真的超北纜

明明就改了發回來的測試結果東西還在上面

任誰都會三條線

像我剛剛回的信就有三項是這樣回的

上一封信已經說刪除了
上一封信已經說修改了
上一封信已經說沒這功能

還有一項是這樣回

上封信, 上上封信說已修改

幹XD


或是ppt上說要加啥功能是當初不包含的

我覺得很誇張~~~~誇張到他根本不可能不知道這功能是他單方新增的

重點還不只一次.........真的很無言

我就回

不包含這功能

shit



而且想法也很奇怪

竟然會在A list要放B相關的欄位上去...........

我真的不知道為什麼要這樣放~~~~沒關聯呀


或是提到bug的問題

是在當初要做的功能以外的bug

我覺得以前的我應該會傻傻的幫忙改一下

可是現在我打死都不會........

除非我瘋了XD

PHP ~ get country time

如果server不是架在台灣

用date會變成server當地的時間

但想變成目前台灣的時間

date_default_timezone_set('Asia/Taipei');
print date("Y/m/d H:i:s");



reference
http://stackoverflow.com/questions/3483519/how-to-find-gmt-date-time-by-country-name

SQL Server ~ view 的應用感想XD

這次接手人家的網站

雖然人家也是先包給某家廠商後來才找我們把後面功能弄好一"一

由於人家弄得資料表有問題

例如年的欄位用varchar..........月的欄位.....數量的欄位通通都用varchar........

暈倒XD

這樣我們怎麼做查詢XD

起初我的想法是改table

可惜不給改..........沒辦法就是降子

好在張睪提供了好方法.....

用View

就是新增一個View把該table查詢出來的欄位都轉型

這樣就大功告成.......真的是方法中的方法0rz.......

此為我們新增的view~~~欄位超多所以超長XD


SELECT SN, CONVERT(datetime, Year + '-' + Month + '-01') AS date, CAST(GG1 AS int) AS GG1, CAST(GG2 AS int)
AS GG2, CAST(GG3 AS int) AS GG3, CAST(GG4 AS int) AS GG4, CAST(GG5 AS int) AS GG5,
CAST(GG6 AS int) AS GG6, CAST(GG7 AS int) AS GG7, CAST(GG8 AS int) AS GG8, CAST(GG9 AS int)
AS GG9, CAST(GG10 AS int) AS GG10, CAST(GG11 AS int) AS GG11, CAST(GG12 AS int) AS GG12,
CAST(GG13 AS int) AS GG13, CAST(GG14 AS int) AS GG14, CAST(GG15 AS int) AS GG15,
CAST(GG16 AS int) AS GG16, CAST(GG17 AS int) AS GG17, CAST(GG18 AS int) AS GG18,
CAST(GG19 AS int) AS GG19, CAST(GG20 AS int) AS GG20, CAST(GG21 AS int) AS GG21,
CAST(GG22 AS int) AS GG22, CAST(GG23 AS int) AS GG23, CAST(GG24 AS int) AS GG24,
CAST(GG25 AS int) AS GG25, CAST(GG26 AS int) AS GG26, CAST(GG27 AS int) AS GG27,
CAST(GG28 AS int) AS GG28, CAST(GG29 AS int) AS GG29, CAST(GG30 AS int) AS GG30,
CAST(GG31 AS int) AS GG31, CAST(GG32 AS int) AS GG32, CAST(GG33 AS int) AS GG33,
CAST(GG34 AS int) AS GG34, CAST(GG35 AS int) AS GG35, CAST(GG36 AS int) AS GG36,
CAST(GG37 AS int) AS GG37, CAST(GG38 AS int) AS GG38, CAST(GG39 AS int) AS GG39,
CAST(GG40 AS int) AS GG40, CAST(GG41 AS int) AS GG41, CAST(GG42 AS int) AS GG42,
CAST(GG43 AS int) AS GG43, CAST(GG44 AS int) AS GG44, CAST(GG45 AS int) AS GG45,
CAST(GG46 AS int) AS GG46
FROM dbo.Quality

PDF Sharp ~ 亂碼問題

這問題是在對方server輸出pdf

出現亂碼的問題

但由於我們都跑得很正常

所以就推估應該是字型問題

嘗試改了幾個字型確實可以working~~

遇到這問題的就試試看囉

Style style = document.Styles[StyleNames.Normal];
style.Font.Name = "微軟正黑體";

一開始的設定是

style.Font.Name = "Arial Unicode MS";

而人家的Server 2008 R2跑不出來

我們是Win7才如此推估

好在確實是這問題XD

jQuery Flot ~ set Label example

var d1 = [];
d1.push([1, 1234]);
d1.push([2, 5678]);

var stack = 0, bars = true, lines = false, steps = false;
$.plot($("#statisticsGraph"), [d1], {
series: {
lines: { show: lines, fill: true },
bars: { show: bars, barWidth: 0.8 }
}, xaxis: {

ticks: [[1, 'out hospital'], [2, 'in hospital']]

}

});


reference
http://stackoverflow.com/questions/459947/how-do-i-control-the-tick-label-size-in-flot

jQuery Flot ~ Invalid dimensions for plot

Invalid dimensions for plot, width = 893, height = 0

假如要用jQuery Flot 產生圖表

出現這問題是因為

沒有設定到指定畫圖表物件的高跟寬

加上css設定下就OK~

#statisticsResult{
height:300px;
width:300px;
}