//@utf-8
function htmlentities (string, quote_style) {
// Convert all applicable characters to HTML entities
//
// version: 909.322
// discuss at: http://phpjs.org/functions/htmlentities // + original by: Kevin van Zonneveld (http://kevin.vanzonneveld.net)
// + revised by: Kevin van Zonneveld (http://kevin.vanzonneveld.net)
// + improved by: nobbler
// + tweaked by: Jack
// + bugfixed by: Onno Marsman // + revised by: Kevin van Zonneveld (http://kevin.vanzonneveld.net)
// + bugfixed by: Brett Zamir (http://brett-zamir.me)
// + input by: Ratheous
// - depends on: get_html_translation_table
// * example 1: htmlentities('Kevin & van Zonneveld'); // * returns 1: 'Kevin & van Zonneveld'
// * example 2: htmlentities("foo'bar","ENT_QUOTES");
// * returns 2: 'foo'bar'
var hash_map = {}, symbol = '', tmp_str = '', entity = '';
tmp_str = string.toString();
if (false === (hash_map = this.get_html_translation_table('HTML_ENTITIES', quote_style))) {
return false;
}
hash_map["'"] = '''; for (symbol in hash_map) {
entity = hash_map[symbol];
tmp_str = tmp_str.split(symbol).join(entity);
}
return tmp_str;
}
function get_html_translation_table (table, quote_style) {
// Returns the internal translation table used by htmlspecialchars and htmlentities
//
// version: 909.322
// discuss at: http://phpjs.org/functions/get_html_translation_table // + original by: Philip Peterson
// + revised by: Kevin van Zonneveld (http://kevin.vanzonneveld.net)
// + bugfixed by: noname
// + bugfixed by: Alex
// + bugfixed by: Marco // + bugfixed by: madipta
// + improved by: KELAN
// + improved by: Brett Zamir (http://brett-zamir.me)
// + bugfixed by: Brett Zamir (http://brett-zamir.me)
// + input by: Frank Forte // + bugfixed by: T.Wild
// + input by: Ratheous
// % note: It has been decided that we're not going to add global
// % note: dependencies to php.js, meaning the constants are not
// % note: real constants, but strings instead. Integers are also supported if someone // % note: chooses to create the constants themselves.
// * example 1: get_html_translation_table('HTML_SPECIALCHARS');
// * returns 1: {'"': '"', '&': '&', '<': '<', '>': '>'}
var entities = {}, hash_map = {}, decimal = 0, symbol = ''; var constMappingTable = {}, constMappingQuoteStyle = {};
var useTable = {}, useQuoteStyle = {};
// Translate arguments
constMappingTable[0] = 'HTML_SPECIALCHARS'; constMappingTable[1] = 'HTML_ENTITIES';
constMappingQuoteStyle[0] = 'ENT_NOQUOTES';
constMappingQuoteStyle[2] = 'ENT_COMPAT';
constMappingQuoteStyle[3] = 'ENT_QUOTES';
useTable = !isNaN(table) ? constMappingTable[table] : table ? table.toUpperCase() : 'HTML_SPECIALCHARS';
useQuoteStyle = !isNaN(quote_style) ? constMappingQuoteStyle[quote_style] : quote_style ? quote_style.toUpperCase() : 'ENT_COMPAT';
if (useTable !== 'HTML_SPECIALCHARS' && useTable !== 'HTML_ENTITIES') {
throw new Error("Table: "+useTable+' not supported'); // return false;
}
entities['38'] = '&';
if (useTable === 'HTML_ENTITIES') { entities['160'] = ' ';
entities['161'] = '¡';
entities['162'] = '¢';
entities['163'] = '£';
entities['164'] = '¤'; entities['165'] = '¥';
entities['166'] = '¦';
entities['167'] = '§';
entities['168'] = '¨';
entities['169'] = '©'; entities['170'] = 'ª';
entities['171'] = '«';
entities['172'] = '¬';
entities['173'] = '';
entities['174'] = '®'; entities['175'] = '¯';
entities['176'] = '°';
entities['177'] = '±';
entities['178'] = '²';
entities['179'] = '³'; entities['180'] = '´';
entities['181'] = 'µ';
entities['182'] = '¶';
entities['183'] = '·';
entities['184'] = '¸'; entities['185'] = '¹';
entities['186'] = 'º';
entities['187'] = '»';
entities['188'] = '¼';
entities['189'] = '½'; entities['190'] = '¾';
entities['191'] = '¿';
entities['192'] = 'À';
entities['193'] = 'Á';
entities['194'] = 'Â'; entities['195'] = 'Ã';
entities['196'] = 'Ä';
entities['197'] = 'Å';
entities['198'] = 'Æ';
entities['199'] = 'Ç'; entities['200'] = 'È';
entities['201'] = 'É';
entities['202'] = 'Ê';
entities['203'] = 'Ë';
entities['204'] = 'Ì'; entities['205'] = 'Í';
entities['206'] = 'Î';
entities['207'] = 'Ï';
entities['208'] = 'Ð';
entities['209'] = 'Ñ'; entities['210'] = 'Ò';
entities['211'] = 'Ó';
entities['212'] = 'Ô';
entities['213'] = 'Õ';
entities['214'] = 'Ö'; entities['215'] = '×';
entities['216'] = 'Ø';
entities['217'] = 'Ù';
entities['218'] = 'Ú';
entities['219'] = 'Û'; entities['220'] = 'Ü';
entities['221'] = 'Ý';
entities['222'] = 'Þ';
entities['223'] = 'ß';
entities['224'] = 'à'; entities['225'] = 'á';
entities['226'] = 'â';
entities['227'] = 'ã';
entities['228'] = 'ä';
entities['229'] = 'å'; entities['230'] = 'æ';
entities['231'] = 'ç';
entities['232'] = 'è';
entities['233'] = 'é';
entities['234'] = 'ê'; entities['235'] = 'ë';
entities['236'] = 'ì';
entities['237'] = 'í';
entities['238'] = 'î';
entities['239'] = 'ï'; entities['240'] = 'ð';
entities['241'] = 'ñ';
entities['242'] = 'ò';
entities['243'] = 'ó';
entities['244'] = 'ô'; entities['245'] = 'õ';
entities['246'] = 'ö';
entities['247'] = '÷';
entities['248'] = 'ø';
entities['249'] = 'ù'; entities['250'] = 'ú';
entities['251'] = 'û';
entities['252'] = 'ü';
entities['253'] = 'ý';
entities['254'] = 'þ'; entities['255'] = 'ÿ';
}
if (useQuoteStyle !== 'ENT_NOQUOTES') {
entities['34'] = '"'; }
if (useQuoteStyle === 'ENT_QUOTES') {
entities['39'] = ''';
}
entities['60'] = '<'; entities['62'] = '>';
// ascii decimals to real symbols
for (decimal in entities) { symbol = String.fromCharCode(decimal);
hash_map[symbol] = entities[decimal];
}
return hash_map;
}
function utf8_decode ( str_data ) {
// Converts a UTF-8 encoded string to ISO-8859-1
//
// version: 810.1317
// discuss at: http://phpjs.org/functions/utf8_decode
// + original by: Webtoolkit.info (http://www.webtoolkit.info/)
// + input by: Aman Gupta
// + improved by: Kevin van Zonneveld (http://kevin.vanzonneveld.net)
// + improved by: Norman "zEh" Fuchs
// + bugfixed by: hitwork
// + bugfixed by: Onno Marsman
// * example 1: utf8_decode('Kevin van Zonneveld');
// * returns 1: 'Kevin van Zonneveld'
var tmp_arr = [], i = ac = c1 = c2 = c3 = 0;
str_data += '';
while ( i < str_data.length ) {
c1 = str_data.charCodeAt(i);
if (c1 < 128) {
tmp_arr[ac++] = String.fromCharCode(c1);
i++;
} else if ((c1 > 191) && (c1 < 224)) {
c2 = str_data.charCodeAt(i+1);
tmp_arr[ac++] = String.fromCharCode(((c1 & 31) << 6) | (c2 & 63));
i += 2;
} else {
c2 = str_data.charCodeAt(i+1);
c3 = str_data.charCodeAt(i+2);
tmp_arr[ac++] = String.fromCharCode(((c1 & 15) << 12) | ((c2 & 63) << 6) | (c3 & 63));
i += 3;
}
}
return tmp_arr.join('');
}
function utf8_encode ( string ) {
// Encodes an ISO-8859-1 string to UTF-8
//
// version: 812.316
// discuss at: http://phpjs.org/functions/utf8_encode
// + original by: Webtoolkit.info (http://www.webtoolkit.info/)
// + improved by: Kevin van Zonneveld (http://kevin.vanzonneveld.net)
// + improved by: sowberry
// + tweaked by: Jack
// + bugfixed by: Onno Marsman
// + improved by: Yves Sucaet
// + bugfixed by: Onno Marsman
// * example 1: utf8_encode('Tom van Mikes');
// * returns 1: 'Tom van Mikes'
string = (string+'').replace(/\r\n/g, "\n").replace(/\r/g, "\n");
var utftext = "";
var start, end;
var stringl = 0;
start = end = 0;
stringl = string.length;
for (var n = 0; n < stringl; n++) {
var c1 = string.charCodeAt(n);
var enc = null;
if (c1 < 128) {
end++;
} else if((c1 > 127) && (c1 < 2048)) {
enc = String.fromCharCode((c1 >> 6) | 192) + String.fromCharCode((c1 & 63) | 128);
} else {
enc = String.fromCharCode((c1 >> 12) | 224) + String.fromCharCode(((c1 >> 6) & 63) | 128) + String.fromCharCode((c1 & 63) | 128);
}
if (enc != null) {
if (end > start) {
utftext += string.substring(start, end);
}
utftext += enc;
start = end = n+1;
}
}
if (end > start) {
utftext += string.substring(start, string.length);
}
return utftext;
}
(function($) {
$.csv2table={
name : 'csv2table',
version : '0.02-b-2.8',
date : '2009.1.10',
update : 'http://jsgt.org/lib/jquery/plugin/csv2table/v002/update.txt',
ver : '',
charset : 'utf-8', //'iso-8859-1',
doc : 'http://jsgt.org/mt/01/',
demo : 'http://jsgt.org/lib/jquery/plugin/csv2table/v002/test.htm',
author : 'Toshiro Takahashi',
lisence : 'Public Domain',
loadImg : (new Image()).src='./img/icon-loadinfo.gif', //Dafault loading IMG
sortNImg : (new Image()).src='./img/icon-n.gif', //Dafault sort IMG N
sortDImg : (new Image()).src='./img/icon-d-green.gif', //Dafault sort IMG D
sortAImg : (new Image()).src='./img/icon-a-green.gif', //Dafault sort IMG A
setting : [],
data : [],
_rowsAry : [],
_doc : document,
err : [],
f : {
classifyByCol:function(id,colIndex,myCompAry,nolegend){
var toj=$('table',$('#'+id)),oj=$('tr > td:nth-child('+(colIndex+1)+')',toj)
if(!nolegend){
var legend=($('#csv2table-legend-'+id).length==0)?
$(''):$('#csv2table-legend-'+id);
toj.after(
legend.append(
$('')
.append($.csv2table._rowsAry[id][0][colIndex]+' ')
)
)
}
//Eg. myCompAry is [['>10','#eee'],['>30','#ddd'],['>50','#bbb']]
$.each(myCompAry,function(){
oj
.filter(':_csv2table_myComp('+this[0]+')')
.css('background',this[1])
if(!nolegend){
var hanrei=''
+' '
$('#csv2table-legend-'+id+'-'+colIndex)
.append(hanrei+this[0].split('<').join('<')+' ' )
}
})
}
}
}
$.fn.csv2table= function (url,setting){
if(!setting)var setting={};
var contents=$.fn.csv2table.el=this,id=this[0].id,
op = $.csv2table.setting[id] = $.extend({
url : url,
nowloadingImg : $.csv2table.loadImg, //Image of now loading...
nowloadingMsg : 'now loading...', //Massege of now loading...
sortNImg : $.csv2table.sortNImg, //Sort IMG N
sortDImg : $.csv2table.sortDImg, //Sort IMG D
sortAImg : $.csv2table.sortAImg, //Sort IMG A
removeDoubleQuote : true, // remove " of "hogehoge"
appendThead : null, //Array. Append a Row of Thead.(e.g. ["Name","Address"])
col_midasi : 0, //
row_sep : '\n', //Separator of rows. default '\n'
col_sep : ';', //Separator(,|\t|;) of cols. default ','
sortable : true, //col sort
select : '*', //select col lists. default '*' is all cols.
orderBy : null, //array of sort col. orderBy:[[colNo|'colName','sortType']]
where : null, //array of where : [{'ColName':'condition'}] etc.
limit : null, //array of limit : [offset,len]
col0color : true, //col[0] color sync jQchart line_strokeStyle
numArignRight : true, //Set the Number TD to "textAlign : 'right'"
onload : null, //collback function (id,op,data,ary) {}
use : null, // 'jqchart:line#canvasID'
className_div : 'csv2table-div', //className
className_table : 'csv2table-table', //className
className_table_th : 'csv2table-table-th', //className
className_table_td : 'csv2table-table-td', //className
className_hoboNum : 'csv2table-hoboNum', //className
className_sortMark : 'csv2table-sortMark', //className
className_legends : 'csv2table-legends' //className
},setting);
if(op.row_sep=='\n')op.row_sep_reg='\r\n'
if(op.use){
op.use_api = op.use.split(':')[0]
op.use_api_type = op.use.split('#')[0]
op.use_api_box = op.use.split(':')[1].split('#')[1]
}
//Custom Selectors
$.extend($.expr[":"], {
//_csv2table_hoboNum is match to number or Number-like (3 digit + comma)
//for Set the Number TD to "textAlign : 'right'"
_csv2table_hoboNum : function(a,i,m){
var b = a.textContent||a.innerText||$(a).text()||"",
c = Number(
chkThreeComma(b).split(",").join("")
);
return !isNaN(b) || !isNaN(c);
},
//
_csv2table_myComp : function(a,i,m){
var b = Number(
(a.textContent||a.innerText||$(a).text()||"")
.replace(" ","")
.replace(/,/g,'')
);
return typeof b=='number'? eval(b+m[3]):false;
}
});
$(contents).before('
'+op.nowloadingMsg+'
";
for (var k=0; k"
// + rowsAry[op.col_midasi][k];
//
// if(op.sortable)
// htm+= "![]("+sortimgsrc+")
"
// htm+= "";
//
// if(!op['th'+k])op['th'+k]=null;//memo of sortType
// } else {
// var colLien=k;
// }
}
// htm+= "
";
//data行の処理
rowMax = 10;
ColTot = Math.floor(row/rowMax)+1;
for (var i=s; i";
}
// if(j==colLogo) {
// htm+= "![](./ref/images/"
// + rowsAry[i][j]
// + ") | ";
// }
}
htm+= "";
}
var tableHtm=$.csv2table._doc.getElementById(id)
.innerHTML="";
return tableHtm;
}
////
// 並べ替え
// @parame dataAry 並べ替え対象配列
// @parame sortType 昇順A|降順D
// @parame colIndex ソート列
//
function sortwk(dataAry,sortType,colIndex){
if(!dataAry)return ;
sortType=sortType.toUpperCase();
if(sortType=="D")op['th'+colIndex]='D';
else op['th'+colIndex]='A';
var ci=colIndex,
are3comma=chkThreeComma(dataAry[0][ci]),
mved3comma=are3comma.split(",").join("");
if(!isNaN(dataAry[0][ci]) || !isNaN(mved3comma)){
var rowlen=dataAry.length;
if(are3comma != 'null'){
for(var j=0;j ""+b[ci])?-1:1):
((""+a[ci] > ""+b[ci])?1:-1);
}
)
}
return dataAry;
}
function escapeStrComma(col_sep,row_sep,oj,removeDoubleQuote){
var rdq=(removeDoubleQuote)?'':'"';
//mk dmy for comma in "
var dmy =['-###','###-'],cnt=0,r;
cnt=(function mkdmy(cnt){
if(!(
oj.indexOf((dmy[0]+'comma'+cnt+dmy[1]))==-1 ||
oj.indexOf((dmy[0]+'rn'+cnt+dmy[1]))==-1 ||
oj.indexOf((dmy[0]+'wDquote'+cnt+dmy[1]))==-1
))mkdmy( ++cnt )
else void(0)
return cnt;
})(cnt)
var reg='(["](.|(\r\n))*?(["]$|["][,('+op.row_sep_reg+')]))',
dmystr_comma=''+(dmy[0]+'comma'+cnt+dmy[1]) ,
dmystr_rn=''+(dmy[0]+'rn'+cnt+dmy[1]) ,
dmystr_wDquote=''+(dmy[0]+'wDquote'+cnt+dmy[1]) ;
escape= oj.replace('""',dmystr_wDquote);
escape= escape.replace(
new RegExp(reg,"g"),
function (after,before,index) {
after= after
.replace(/(\r\n)(?!$)/g,dmystr_rn)
.replace(/,(?!$)/g,dmystr_comma)
return after
}
)
if(op.select == '*'||op.select == ['*'])
r=$.csv2table._rowsAry[id]=mkArray(escape,op.col_sep,op.row_sep);
else r=$.csv2table._rowsAry[id]=mkSelectedArray(escape,op.col_sep,op.row_sep,op.select)
var b=[],rowlen=r.length,collen=r[0].length;
for(var i=0;i