m*!Pq'b9+O:J":|j؅٬ww)ՒZױc>_qTK7ŦG|oֲE{nѼ͋{dږ*U3!X+hE>Bm7އ NgdJbuԸ  Pۜ k/ݜ5Fb}RP&}tͻCK|=ʆޝL\7H~Pۜ k/ݜ5Fb}RP&}ӏ Lu$CWDEr C .Hm'sL'+5u$ݲ\1 Q4ƴM4+hLD> 4 ~۪y5Vqa7}à# y\ ﹰzCSc!1Jvcj Swوxxbz?n:)"_&}lHSc!1Jvcj Swوxxbp)q Xwjp&`wY|b_fPۜ k/ݜ5Fb}RP&}o#p¡̤ҶM8>dI8n Г.\0Vv{rZ'[,a0bDvhw8‚(EQ}tʦ@>P\y hpXOGSu$C#V+;=XR.P#$Lr1|xXRYKȂ͝]MPHQDs/y#+M?pOBdm2F WRA7%^񆕼 (`^5%o/؛܄iW\ZXa-4jm,C 0TM}uy9tC0s*j,v/_&DM1T?"EcHH <|boaЋɧ ,#mv͵0"NE,>z9>jJL2rC/K??/‘[ L] o䊜 Z,=.'I$Ay^$d[ };y柶Wʰ)]6EDžHB5Hb=\У?%?s. ɓseiIPzvZ.Hl^,NgpDẶ.rP {J\O ^V4*  GVe3hahG~aK AЇ1ї&Sxjq0Ѧg&z1+w4bjcRWTb t or:=IgR3I H2jٖ>T/J ؼ1+=?m"ZYm;tJ{򓏀 n˞'}\NQZ+8sBŕt욈Kݶ5_>y$Ęq Cf<1Cͣڭ3Na0"m~i:b&Hc#DND"A:4[{{f% O.|4K7iWC{AaBHHэ 䟕ѬJ2_gBl.a8zқtt22w\08fv}Lhz0 S˟xgrGCi$aȸ9DZ w+0^ !844jwWiԡ(%j zB3 ֍qTat}f 9k @:0)5".7PT G4Uid']."' and bookID2='$bookID2' 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 labid='".$_SESSION['labid']."' and accessionNo='$accessionNo'" ); if($bookID2==""){ $bookID2=getName( $conn, "select isnull(max(bookID2),0)+1 from bookTable" ); $query="insert into bookTable(labid,callNo,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('".$_SESSION['labid']."','$callNo','$library','$date_','$subTitle','$subAuthor','$volume','$ddc_no','$auth_mark','$remarks','$language','$keywords','$subject','$bookName','$author','$pages','$accessionNo','$isbn','$bookID2','$publicationPlace','$year_','$publisher','$edition')"; if(canSave($conn,"addBookDetail")=="0") $cur= odbc_exec( $conn, $query ); }else{ $query="update bookTable set callNo='$callNo',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='$bookID2'"; if(canUpdate($conn,"addBookDetail")=="0") $cur= odbc_exec( $conn, $query ); } $accessionNo+=1; } //echo $query; $cur= odbc_exec( $conn, "update bookTable set qty=(select count(*) from bookTable where labid='".$_SESSION['labid']."' and bookID2='$bookID2' ) where bookID='$bookID2'" ); //echo ""; if($_FILES["fileToUpload"]["tmp_name"]!=""){ $target_file = $target_dir ."$bookID2-". basename($_FILES["fileToUpload"]["name"]); //$oldPic=getName($con,"select productImage1 from products where pid='$pid' "); $oldPic="$target_dir".getName($conn,"select image from bookTable where labid='".$_SESSION['labid']."' and bookID2='$bookID2'"); if(file_exists($oldPic)) unlink($oldPic); //move_uploaded_file($_FILES["fileToUpload"]["name"],$target_dir.$newImageName); if(move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)){ $newImageName=$bookID2."-".basename($_FILES["fileToUpload"]["name"]); $query="update bookTable set image='$newImageName' where bookID2='$bookID2'"; $cur= odbc_exec( $conn, $query ); } } } $imgPath=$sor=$callNo=$year_=$keyword= "";$author= "";$publisher= ""; $isbn= "";$publicationPlace= "";$edition= "";$accessionNo= "";$qty= "";$pages= ""; $expID= "";$bookName= ""; $amount= "";$date_= "";$bookID2= "";$Department= "";$anyvalue= ""; $bookName= ""; $medicineCompany=""; $Status=0;$bookID2="";$Salary=0; $subAuthor= "";$subTitle= ""; $volume= "";$remarks= "";$keywords= "";$subject= ""; $library="1";$libraryFind=""; $date_ = date('Y-m-d',time()); $from = date('Y-m-d',time()); $to = date('Y-m-d',time()); if ((isset($_GET['editaccessionNo'])) or (isset($_GET['copyaccessionNo'])) ){ if (isset($_GET['editaccessionNo'])) $accessionNo = $_GET['editaccessionNo']; $bookID2 = $_GET['bookID']; //$query = "select * from bookTable where labid='".$_SESSION['labid']."' and accessionNo='$accessionNo'"; $query = "select * from bookTable where labid='".$_SESSION['labid']."' and bookID2='$bookID2'"; $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' ); $sor= odbc_result( $cur, 'sor' ); $accessionNo=round(odbc_result( $cur, 'accessionNo' )); $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,'callNo'); $imgPath= odbc_result( $cur,'image'); $date_= date('Y-m-d',strtotime(odbc_result( $cur,'date_'))); $qty="1";// odbc_result( $cur,'qty'); } if(isset($_GET['copyaccessionNo'])){ $accessionNo ="";// $_GET['copyaccessionNo']; $bookID2 =""; } } if(isset($_POST['find'])){ $keyword= $_POST['keyword']; $libraryFind= $_POST['library']; $library=$libraryFind; } ?> HOME
"; echo "
"; echo ""; echo "Date"; echo "LibraryMain "; /* echo "Library"; */ echo "Title"; if($imgPath!="") echo ""; else echo ""; echo "Sub Title"; echo "Author"; echo "Call Number"; echo "Publisher"; echo "Pub Place"; echo "Pub year"; echo "ISBN"; echo "Edition"; echo "Accession #"; //echo "
"; ?>
"; echo "Pages"; echo "Volume"; echo "Remarks"; echo ""; echo "Keywords"; echo "Subject"; echo "SOR"; echo ""; echo "
"; echo "Import Data"; ?>
"; echo ""; echo "
"; echo ""; echo " "; echo "
"; echo "
"; $fields="bookName,bookID2,edition,accessionNo,publicationPlace,publisher,isbn,image,author,status"; if($bookID2!=""){ $bookName=getName($conn,"select bookName from bookTable where labid='".$_SESSION['labid']."' and bookID2='$bookID2' "); $query= "select * from bookTable where labid='".$_SESSION['labid']."' and bookName='$bookName' order by accessionNo asc"; }else{ if($keyword!="") $query= "select $fields from bookTable where labid='".$_SESSION['labid']."' and library='$libraryFind' and (bookName like'%$keyword%' or author like'%$keyword%' or accessionNo like'%$keyword%') order by accessionNo asc"; elseif($libraryFind!="") $query= "select $fields from bookTable where labid='".$_SESSION['labid']."' and bookID2>0 and library='$libraryFind' order by bookID2 desc"; else $query= "select top 20 $fields from bookTable where labid='".$_SESSION['labid']."' and 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 "
#Acc #TitleAuthorPublisherPlaceEditionimgcopy"; //echo utf8_encode($text); $bookName=(odbc_result( $cur,'bookName')); $bookName=iconv("UTF-8", "CP1252",$bookName); $bookID2= 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"; if(odbc_result($cur,'status')==0) echo "$accessionNo"; else echo "$accessionNo"; echo "".($bookName)."$author$publisher$publicationPlace$edition"; echo ""; if(odbc_result($cur,'image')!="") echo ""; else echo ""; echo "copy" ; echo "" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; echo "
"; ?>