$(function(){
	
	$.get('fireworks2017.csv',function(data){
		var csv = $.csv()(data);
		count = 0;

		$("#csv_pc").append("<col width=35%><col width=10%><col width=55%>");
		$("#csv_pc").append("<tr><th>開催日時・名称・場所</th><th>打ち上げ数</th><th>備考(人出、大会の内容等)</th></tr>");
		
		$(csv).each(function(){
			
			if(this[2] === pref){
				count++;
				var insert_pc = '';
				var insert_smt = '';
				NowDate = new Date();
				/*NowDate = new Date("2015/07/25 21:30:00");*/
				CloseDate01 = new Date(this[13]);
				CloseDate02 = new Date(this[16]);
				CloseDate03 = new Date(this[19]);
				
				insert_pc += "<tr><td>"+this[2]+"・"+this[3]+"<br>"+this[5]+"<br><strong>"+this[6]+"</strong><br><small>"+this[7]+"</small></td>";
				insert_smt += "<tr><th>開催日時<br>名称<br>場所</th><td>"+this[2]+"・"+this[3]+"<br>"+this[5]+"<br><strong>"+this[6]+"</strong><br><small>"+this[7]+"</small></td></tr><tr><th>打ち上げ数</th>";
				
				if(this[9]){
					insert_pc += "<td>約"+this[9]+"発</td><td>"+this[10]+"<br><br>";
					insert_smt += "<td>約"+this[9]+"発</td></tr><tr><th>備考<span class=\"pc\">(人出、大会の内容等)</span></th><td>"+this[10]+"<br><br>";
				} else {
					insert_pc += "<td>未定</td><td>"+this[10]+"<br><br>";
					insert_smt += "<td>未定</td></tr><tr><th>備考<span class=\"pc\">(人出、大会の内容等)</span></th><td>"+this[10]+"<br><br>";
				}
				
				if((this[12])&&(Number(NowDate) < Number(CloseDate01))){
					insert_pc += "<a target='_blank' href=https://ssl.exeo-japan.co.jp/ex_schedule/reserve.php?seq="+this[12]+">★"+this[14]+"</a>";
					insert_smt += "<a target='_blank' href=https://ssl.exeo-japan.co.jp/s/schedule/reserve.php?seq="+this[12]+">★"+this[14]+"</a>";
				}
				if((this[15])&&(Number(NowDate) < Number(CloseDate02))){
					insert_pc += "<a target='_blank' href=https://ssl.exeo-japan.co.jp/ex_schedule/reserve.php?seq="+this[15]+">★"+this[17]+"</a>";
					insert_smt += "<a target='_blank' href=https://ssl.exeo-japan.co.jp/s/schedule/reserve.php?seq="+this[15]+">★"+this[17]+"</a>";
				}
				if((this[18])&&(Number(NowDate) < Number(CloseDate03))){
					insert_pc += "<a target='_blank' href=https://ssl.exeo-japan.co.jp/ex_schedule/reserve.php?seq="+this[18]+">★"+this[20]+"</a>";
					insert_smt += "<a target='_blank' href=https://ssl.exeo-japan.co.jp/s/schedule/reserve.php?seq="+this[18]+">★"+this[20]+"</a>";
				}
				
				insert_pc += "</td></tr>";
				insert_smt += "</td></tr>";
				
				$("#csv_pc").append(insert_pc);
				$("#csv_smt").append(insert_smt);
			}
			
		});
		
		$("#count").append(count);
		
		// set background-color
		$("#csv_smt tr").each(function (i) {
			if(Math.floor(i/3)%2 <= 0){
				$(this).find('td').css({'background-color':'#eaecf0'});
			}
		});
		
	});
	
});