<?
session_start();
header('Content-Type: text/html; charset=utf-8');
include_once('db_config.inc.php');

$monthname = array("","มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฏาคม","สิงหาคม","กันยายน","ตุลาคม", "พฤศจิกายน","ธันวาคม");
$monthsname = array( "","1","2","3","4","5","6", "7","8","9","10","11","12");
$monthname_en = array( "","January","February","March","April","May","June", "July","August","September","October","November","December");



function Query1($sql){

	$result  = mysql_query($sql)or die($sql."<hr> Query Error in inc/Libary.php line " . __LINE__ ."<hr>".mysql_error());
	$rs 		= mysql_fetch_array($result);
	return $rs[0];
	
}

function QuerySet($sql){
	//global $odbc_con;// echo $sql;
	$result = mysql_query($sql);
	$rows =mysql_fetch_assoc($result); 
	return $rows;
}

function DBtoThaiDate($d){
	if($d == "00-00-0000" || $d == "") return ""; //date("dd/mm/") .  (date("Y")+543);
	$x = explode("-",$d);
	return ($x[2] . "/" . $x[1] . "/" . (intval($x[0]) + 543));
}

function ThaitoDBDate($d){
	if($d == "") return "";
	$x = explode("/",$d);
	return ((intval($x[2]) - 543) . "-" . $x[1] . "-" . $x[0]);
}

//========================================================================

function getMARC($bibid,$tag,$subfield){
	$field_data=Query1("select field_data from biblio_field where bibid='$bibid' and tag='$tag' and subfield_cd='$subfield';");
	return $field_data;
}




function coverImage($bibid,$title=""){
global $cover_path,$mylib_path;
	$cover=trim(getMARC($bibid,'902','a'));
	if ($cover > ""){
		return "$cover_path/$cover";
//	}elseif (file_exists("temp_cover/$bibid.png")){
//		return "/$mylib_path/temp_cover/$bibid.png";
//	}elseif ($title>""){
//		return "coverimg.php?title=$title&bibid=$bibid";
	}else{
		//nio gen tempcover
		//genTempCover($title,$bibid);
		//return "/$mylib_path/temp_cover/$bibid.png";
		return "$cover_path/noimage.gif";
	}
}

function showStar($n){
	for ($i=1;$i<=5;$i++){
		if ($i <= $n){
			echo "<img src='images/star.png' /> ";
		}else{
			echo "<img src='images/star_no.png' /> ";
		}
	}
}

function getStar($bibid){
	$star = 0;
	$n = Query1("select count(*) from biblio_status_hist where bibid='$bibid' and status_cd='out';");
	if ($n > 50) {
		$star = 5;
	}elseif ($n > 30){
		$star = 4;
	}elseif ($n > 20){
		$star = 3;
	}elseif ($n > 10){
		$star = 2;
	}elseif ($n > 3){
		$star = 1;
	}

	return $star;
}


//========================================================================


//=======================================================
function textSplit($s,$n){
$begin_newword = ' ,:[<&@!(-=âäãàá{$' . "\n\r";

	$s2 = "";
	$i=0;

	$k = floor($n * 0.8);

	if ($n > $k){
		$s2 = substr($s,0,$k);
		$i=$k;
	}

	while ($i < strlen($s)){
		$x = substr($s,$i,1);
		if (strstr($begin_newword,$x)){
			break;
		}
		$s2 .= $x;
		$i++;
	}

	if ($i < strlen($s)){
		$the_rest = substr($s,$i);
		return array_merge (array($s2),textSplit($the_rest,$n));
	}else if ($i > $n && $i >= strlen($s)){
		$s2 = substr($s,0,$n);
		$the_rest = substr($s,$n);
		return array_merge (array($s2),textSplit($the_rest,$n));
	}else{
		return array($s2);
	}
}



//===========================================================
function genTempCover($title,$bibid){
	//$title = "·´ÊÍºËÑÇË¹Ñ§Ê×ÍäÁè¨Ó¡Ñ´¤ÇÒÁÂÒÇ";

	//$bibid = trim($_GET[bibid]);
	$img_filename = "temp_cover/$bibid.png";

	//$title = trim($_GET[title]);
	$title = iconv("UTF-8","TIS-620",$title);

	$blank_cover= "images/blank_cover.png";
	$font = "THSarabun Bold.ttf";
	$maxx = 180;
	$starty = 50;
	$cwidth = 7; 
	$line_len = 20;
	$fontSize = 22;

	$image = ImageCreateFromPNG($blank_cover);
	$color = imagecolorallocate($image, 0xFF, 0xFF, 0xFF);
	$colorShadow = imagecolorallocate($image, 0x40, 0x40, 0x40);
	$fontRotation = "0";
	$lines = textSplit($title,$line_len);


	$y = $starty;
	$x1 = 20; $x2 = $maxx;
	imageline($image, $x1, $y, $x2, $y, $color);
	$y += 30;

	for ($i=0;$i<count($lines);$i++){
		$str = trim($lines[$i]);
		$x1 = strlen($str) ;
		$x = floor($maxx / 2) - (floor($x1 / 2) * $cwidth);

		$str = iconv("TIS-620","UTF-8",$str);
		/* Shadow */
		ImageTTFText($image, $fontSize, $fontRotation, $x+1, $y+1, $colorShadow, $font, $str);
		/* Top Level */
		ImageTTFText($image, $fontSize, $fontRotation, $x, $y, $color, $font, $str);
		
		$y += 20;
	}

	$x1 = 20; $x2 = $maxx;
	imageline($image, $x1, $y, $x2, $y, $color);

	//header("Content-Type: image/PNG");
	ImagePng ($image,$img_filename);

	imagedestroy($image);

}
//===========================================================

function mylib_add_log($action=""){
	if(!empty($_SERVER['HTTP_CLIENT_IP']))	$ip = $_SERVER['HTTP_CLIENT_IP'];
	if(!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
	$ip = ($ip > "") ? $_SERVER['REMOTE_ADDR'] . "/$ip" : $_SERVER['REMOTE_ADDR']; 

	$url = $_SERVER[PHP_SELF];
	$qry = $_SERVER[QUERY_STRING];
	$url = ($qry > "") ? "$url?$qry" : $url;

	$x = explode("/",$_SERVER[PHP_SELF]);
	$filename = trim($x[count($x)-1]);

	$mbrid = $_SESSION['mbrid'];
	$url = mysql_escape_string($url);
	$filename = mysql_escape_string($filename);
	$action = mysql_escape_string($action);

	$sql = "insert into mylib_log (logtime,mbrid,filename,action,ip,url) values(now(),'$mbrid','$filename','$action','$ip','$url');";
	@mysql_query($sql);
}
//===========================================================

function getCurrentTerm(){
	$m = date("n");
	$y = date("Y")+543;

	if ($m < 6){
		$y--;
		$term=2;
	}else{
		$term=1;
	}

	return array($term,$y);
}


function updateAllMonthlyScore(){

	$result=mysql_query("select distinct mbrid from biblio_status_hist order by mbrid;");
	while ($rs=mysql_fetch_assoc($result)){
		$mbrid= ($rs[mbrid]);
		$book_list = processBorrowList($mbrid);
		//$total_score = scoreBookList($book_list);
		$total_score = scoreMonthly($book_list,$mbrid);
	}

}


function scoreMonthly($books,$mbrid){
	$scores = array();
	foreach ($books as $barcode => $book){
		$n = count($book);
		for ($i=0;$i<$n;$i++){
			list($yy,$mm,$dd) = explode("-",$book[$i][date_begin]);
			$scores["$yy-$mm"] += intval($book[$i][score]);
		}
	}

	//add monthly score table
	$sql = "CREATE TABLE IF NOT EXISTS `mylib_score_monthly` (
  `mbrid` int(11) NOT NULL default '0',
  `yy` int(11) NOT NULL default '0',
  `mm` int(11) NOT NULL default '0',
  `score` int(11) default NULL,
  PRIMARY KEY  (`mbrid`,`yy`,`mm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
	@mysql_query($sql);

	//ÅºÍÑ¹à¡èÒ
	$sql = "delete from mylib_score_monthly where mbrid='$mbrid';";
	mysql_query($sql);

	foreach ($scores as $yymm => $score){
		list($yy,$mm) = explode("-",$yymm);
		$sql = "insert into mylib_score_monthly set mbrid='$mbrid',yy='$yy',mm='$mm',score='$score';";
		mysql_query($sql);
	}

	
}

?>戼⁲㸯㰊㹢慆慴⁬牥潲㱲戯㨾†湕慣杵瑨䔠牲牯›慃汬琠⁯湵敤楦敮⁤畦据楴湯儠敵祲敓⡴ 湩䌠尺慸灭屰瑨潤獣汜扩慲祲浜汹扩扜潯摫瑥楡⹬桰㩰㜱匊慴正琠慲散਺〣笠慭湩੽†桴潲湷椠⁮戼䌾尺慸灭屰瑨潤獣汜扩慲祲浜汹扩扜潯摫瑥楡⹬桰㱰戯‾湯氠湩⁥戼ㄾ㰷戯㰾牢⼠ਾ