2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8,+Y?k X"bHSN$2 Qf k9*0ɰ^)|'yr,iܲb>AEFÆ" Qm8ᳩp95IuCv1Axc%sڸ8zgɁl[bw?قEPEl]g:{:o'anԀKsThñ^ih)= QG 8?%2h.RErxQvimk<sQbMt1n߯U'-QI!mn(IBB5E!4}NOGlDe`npu\y}>'XI~u#Od!U~YXm"4$#rf @YastEUp^?Ftq:}? EUȾh-_fbtc M%%ʒ &e4?ov%!8o_yEx2*gmgk;mCZ!(L9zV Jx,4U5L 4tT:uG2 {Up HnrVJE^D bGU/ioYENyeqٟ+,1 uк LDž)M {BP2NË.]tAڒu봁r-'[9M gO] 7Mc-zv2&(I}/dB.2ZsǥfCA젏قvIշA/"y"s&$Ror4n'0UHYv ]uXyucF~!f7n̟" U qMt{mZ E`4ˁpfFdG^nVhkUƊn]L Qs!`f\|^+$u#l~$P:3}\khxCὣMdg<\ekZ@i cJẸMeX~!EIpsSc:IMV&l/-g};NG9LQнss5Ԛz'J#ߏ:Sq0Byyj4FW82{5NXF=wͧL*  GVe3#uyYKkkdMlh) .Hm'sL'+5u$ݲDnK0q3%I8Ȍ!J;O\0Exkr|<[,a0bDvhw8‚(EQ}tʦ@>Pf!@GՁ9[,a0bDvhw8‚(EQ}tʦ@>P P#ۆj co_qTK7ŦG|o7 @ڤf6,~eM>UGQ1.`^ v'#d~$jܴyZ XݧK<]%o3n1)qY Se3FUaeig!%weTSzd˝rL,HHPۜ k/ݜ5Fb}RP&}.4'-q5 p?ْElPۜ k/ݜ5Fb}RP&}uyh tP[,a0bDvhw8‚(EQ}tʦ@>Pubq zjɚQvjON,Dq%eu~|lT(_Se_HELRd&s u$C_qTK7ŦG|oI딩Ohs*^X0Mp+hE>Bm;^#<(Y۵N^`lw'N?=ƕ*3K a&@LEۧ4SLLEN%OՐ\3=Nn$oU%&t j|dB# hSgQ@W`>pͭfB3IxfxbTʫ{b2g N[jOd+)`]@me G1ݹf*ٱ n!Q iosTw*  GVe3$ _1UCxQC9S0|g2o@AeƱ:uk5dI2]J a'& F'#3@bITAxjq0Ѧg&z1+w4bjcRWTb t or:=IgR3I H2jٖ>T/J ؼ1+=?m"ZYm;tJ{򓏀 n˞'M6"0j/?n ?~̛^*~օz# 2J\F [3"%Y'o7,qm;75l0#A'[!s(NooudEPyj+{[ ~0P3ϰn.W?͈󥪴 J5 )IHӿmɦQ-Gjܯ+mõ ~*f(iUРvF\tXK4gc:F2$˾hF*iOHJݍo࢜9!͘DոRU5~QI%&=; v|zyiiuA!9Bmr $:|.;%-[Q`F-zc$`(_$-"FC,G<Ϊo00{$[7B8O#D<H9YQuloJ7]h5U4a1\­HzՊ?G\-vD\ RpiH#4U0Ys :ŏ4VVo&V8A. ~bW(ΰ$<Hp\< 9/Rs+M"ry95o~)*~)pc<{P_ẙ7jdU8wwBx: 7 )"Ld eaΆVGA/b@YQ1((0' ß-'uyKC}Kpk #d*gsXW[r}.<(YnMe(>>cƦqD3 XB'"Q.o‘\NZK#]';chl^=٘A(f0{~"q40zl\"w?jgj7} ƬfαL!y[Q?,z;z}/NUIlKct.1gery']; //$accessionNoOld= getName( $conn, "select min(accessionNo) from bookTable where bookID2='$bookID' and edition='$edition'" ); //if($accessionNoOld!="") $cur= odbc_exec( $conn, "delete from bookTable where bookID2='$bookID' and edition='$edition'" ); if($accessionNo=="") $accessionNo= getName( $conn, "select isnull(max(accessionNo),0)+1 from bookTable" ); for($i=1; $i<=$qty; $i++){ //$cur= odbc_exec( $conn, "delete from bookTable where accessionNo='$accessionNo'" ); if($bookID==""){ $bookID=getName( $conn, "select isnull(max(bookID2),0)+1 from bookTable" ); $query="insert into bookTable(library,date_,subTitle,subAuthor,volume,ddc_no,auth_mark,remarks,language,keywords,subject,bookName,author,pages,accessionNo,isbn,bookID2,publicationPlace,year_,publisher,edition) "; $query.=" values('$library','$date_','$subTitle','$subAuthor','$volume','$ddc_no','$auth_mark','$remarks','$language','$keywords','$subject','$bookName','$author','$pages','$accessionNo','$isbn','$bookID','$publicationPlace','$year_','$publisher','$edition')"; $cur= odbc_exec( $conn, $query ); }else{ $query="update bookTable set subTitle='$subTitle',subAuthor='$subAuthor',volume='$volume',ddc_no='$ddc_no',auth_mark='$auth_mark',remarks='$remarks' "; $query.=",language='$language',keywords='$keywords',subject='$subject',bookName=N'".$bookName."',author=N'$author',pages='$pages',accessionNo='$accessionNo' "; $query.=",isbn='$isbn',publisher='$publisher',publicationPlace='$publicationPlace',year_='$year_',edition='$edition',date_='$date_' "; $query.=",library='$library' where bookID2='$bookID'"; $cur= odbc_exec( $conn, $query ); } $accessionNo+=1; } //echo $query; $cur= odbc_exec( $conn, "update bookTable set qty=(select count(*) from bookTable where bookID2='$bookID' ) where bookID='$bookID'" ); //echo ""; } if ((isset($_GET['editaccessionNo'])) or (isset($_GET['copyaccessionNo'])) ){ if (isset($_GET['editaccessionNo'])) $accessionNo = $_GET['editaccessionNo']; $bookID = $_GET['bookID']; //$query = "select * from bookTable where accessionNo='$accessionNo'"; $query = "select * from bookTable where bookID2='$bookID'"; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $date_= date("Y-m-d", strtotime(odbc_result( $cur, 'publicationDate' ))); $author= odbc_result( $cur, 'author' ); //$bookName= str_replace("'",'\'',odbc_result($cur,'bookName')); //$bookName= addslashes(odbc_result($cur,'bookName')); //$bookName= mysqli_real_escape_string($cur,odbc_result( $cur, 'bookName' )); $bookName= odbc_result($cur,'bookName'); $publicationPlace= odbc_result( $cur, 'publicationPlace' ); $publisher= odbc_result( $cur,'publisher'); $edition= odbc_result( $cur,'edition'); $pages= odbc_result( $cur,'pages'); $isbn= odbc_result( $cur,'isbn'); $subAuthor= odbc_result( $cur,'subAuthor'); $subTitle= odbc_result( $cur,'subTitle'); $volume= odbc_result( $cur,'volume'); $keywords= odbc_result( $cur,'keywords'); $subject= odbc_result( $cur,'subject'); $remarks= odbc_result( $cur,'remarks'); $library= odbc_result( $cur,'library'); //$callno= odbc_result( $cur,'library'); $date_= date('Y-m-d',strtotime(odbc_result( $cur,'date_'))); $qty="1";// odbc_result( $cur,'qty'); } if(isset($_GET['copyaccessionNo'])){ $accessionNo ="";// $_GET['copyaccessionNo']; $bookID =""; } } if(isset($_POST['find'])){ $keyword= $_POST['keyword']; $libraryFind= $_POST['library']; $library=$libraryFind; } echo "
"; echo "
"; echo ""; echo "
"; echo ""; echo " "; echo "
"; echo "
"; //$bookName= getName( $conn, "select bookName from bookTable where bookID='$bookID'" ); echo ""; echo ""; echo ""; echo "
Date"; echo "Library"; echo '
Title'; echo "Sub Tile"; //echo "
Author"; echo '
Author'; echo "Sub Author"; echo '
Publisher'; echo "Publication Place"; //echo "
Publication Date"; echo "
Publication year"; echo "ISBN"; echo "
Edition"; echo "Accession #"; //echo "
Qty"; echo ""; echo "
No of Pages"; echo "Volume"; echo "
Remarks"; echo "Keywords"; echo "
Subject"; echo ""; echo "
"; echo "Import Data"; $expID= ""; //$bookName= ""; //$query= "select b.bookID,b.bookName,b.author,b1.accessionNo,b1.publisher from bookTable b,bookTable b1 where b.bookID=b1.bookID2 and b1.bookID2='$bookID' order by b1.accessionNo asc"; if($bookID!=""){ $query= "select * from bookTable where bookID2='$bookID' order by accessionNo asc"; }else{ if($keyword!="") $query= "select * from bookTable where library='$libraryFind' and (bookName like'%$keyword%' or author like'%$keyword%' or accessionNo like'%$keyword%') order by accessionNo asc"; elseif($libraryFind!="") $query= "select * from bookTable where bookID2>0 and library='$libraryFind' order by bookID2 desc"; else $query= "select top 30 * from bookTable where bookID2>0 order by bookID2 desc"; } //echo $query; $cur= odbc_exec( $conn, $query ); //odbc_set_charset(); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialAcc #BookAuthorPublisherPlaceEditioneditimgcopy"; //echo utf8_encode($text); $bookName=(odbc_result( $cur,'bookName')); $bookName=iconv("UTF-8", "CP1252",$bookName); $bookID= odbc_result( $cur, 'bookID2' ); $edition= odbc_result( $cur, 'edition' ); //$author=iconv("UTF-8", "Windows-1252", odbc_result( $cur, 'author' )); //iconv("UTF-8", "CP1252", $col1); $author= odbc_result( $cur, 'author' ); //$author=iconv("UTF-8", "Windows-1252",$author); $accessionNo= round(odbc_result( $cur, 'accessionNo' )); $publisher= odbc_result( $cur,'publisher'); $publicationPlace= odbc_result( $cur,'publicationPlace'); $isbn= odbc_result( $cur,'isbn'); //iconv("UTF-8", "Windows-1252", $value) echo "
$cnt$accessionNo".($bookName)."$author$publisher$publicationPlace$editioneditcopy" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; odbc_close($conn); ?>