tagi da eklenmis, o yuzden bu kod duplicate edildi
$jkeyno=0;
foreach ($xml->front[0]->{'article-meta'}[0]->{'abstract'}[0]->{'p'}[1]->{'boxed-text'}->list->{'list-item'} as $kp) {
$jkey='';
$jkeyno++;
foreach ($kp as $jkp) {
//$jkey = $jkey . $jkp->asXML();
$jkey = $jkey . $jkp;
}
echo $jkeyno;
echo "
" ;
echo $jkey;
echo "
" ;
$ins = mysql_query(" insert into journal_key_points (JID,KEY_NO,KEY_POINT)
VALUES ('$jid','$jkeyno','".r($jkey)."') ");
if ($ins)
{echo " journal_key_points Tablosuna Kayit Girildi
" ; }
else
{echo " journal_key_points Tablosuna Kayit Girilemedi!!!
" ; }
}
/*
//journal_key_points
// 20140420 -- Yeni XML dosyalarinda
tagi da eklenmis, o yuzden bu kod duplicate edildi
$jkeyno=0;
foreach ($xml->front[0]->{'article-meta'}[0]->{'abstract'}[0]->{'p'}[1]->{'boxed-text'}->list->{'list-item'} as $kp) {
$jkey='';
$jkeyno++;
foreach ($kp->p as $jkp) {
$jkey = $jkey . $jkp->asXML();
}
echo $jkeyno;
echo "
" ;
echo $jkey;
echo "
" ;
$ins = mysql_query(" insert into journal_key_points (JID,KEY_NO,KEY_POINT)
VALUES ('$jid','$jkeyno','".r($jkey)."') ");
if ($ins)
{echo " journal_key_points Tablosuna Kayit Girildi
" ; }
else
{echo " journal_key_points Tablosuna Kayit Girilemedi!!!
" ; }
}
*/
// journal_keywords
$kwdtitle= (string) $xml->front[0]->{'article-meta'}[0]->{'kwd-group'}[0]->{'title'};
echo $kwdtitle;
echo "
" ;
foreach($xml->front[0]->{'article-meta'}[0]->{'kwd-group'}[0]->{'kwd'} as $keywords) {
echo $keywords;
echo "
" ;
$ins = mysql_query(" insert into journal_keywords (JID,KWD_TITLE,KWD_KEYWORD)
VALUES ('$jid','".r($kwdtitle)."','".r($keywords)."') ");
if ($ins)
{echo " journal_keywords Tablosuna Kayit Girildi
" ; }
else
{echo " journal_keywords Tablosuna Kayit Girilemedi!!!
" ; }
}
//journal_counts
$figcount= (string) $xml->front[0]->{'article-meta'}[0]->counts[0]->{'fig-count'}[0]['count'];
$tablecount= (string) $xml->front[0]->{'article-meta'}[0]->counts[0]->{'table-count'}[0]['count'];
$equcount= (string) $xml->front[0]->{'article-meta'}[0]->counts[0]->{'equation-count'}[0]['count'];
$refcount= (string) $xml->front[0]->{'article-meta'}[0]->counts[0]->{'ref-count'}[0]['count'];
$pagecount= (string) $xml->front[0]->{'article-meta'}[0]->counts[0]->{'page-count'}[0]['count'];
echo "count : " . $figcount;
echo "
" ;
echo "count : " . $tablecount;
echo "
" ;
echo "count : " . $equcount;
echo "
" ;
echo "count : " . $refcount;
echo "
" ;
echo "count : " . $pagecount;
echo "
" ;
$ins = mysql_query(" insert into journal_counts (JID,FIG_COUNT,TABLE_COUNT,EQUATION_COUNT,REF_COUNT,PAGE_COUNT)
VALUES ('$jid','".r($figcount)."','".r($tablecount)."','".r($equcount)."','".r($refcount)."','".r($pagecount)."') ");
if ($ins)
{echo " journal_counts Tablosuna Kayit Girildi
" ; }
else
{echo " journal_counts Tablosuna Kayit Girilemedi!!!
" ; }
//journal_back_ack
$backack= '';
foreach ($xml->back[0]->{'ack'}[0]->p as $ba) {
$backack = $backack . $ba;
}
echo $backack ;
echo "
";
$ins = mysql_query(" insert into journal_back_ack (JID,ACKNOWLEDGEMENT)
VALUES ('$jid','".r($backack)."') ");
if ($ins)
{echo " journal_back_ack Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_ack Tablosuna Kayit Girilemedi!!!
" ; }
// references ::::::::::::::
// journal_back_refs
foreach($xml->back[0]->{'ref-list'}[0]->ref as $refs) {
$refid = $refs['id'];
$refpubtype = $refs->{'mixed-citation'}['publication-type'];
echo $refid;
echo "
" ;
echo $refpubtype;
echo "
" ;
$ins = mysql_query(" insert into journal_back_refs (JID,REF_ID,MIXED_CIT_PUB_TYPE)
VALUES ('$jid','".r($refid)."','".r($refpubtype)."') ");
if ($ins)
{echo " journal_back_refs Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_refs Tablosuna Kayit Girilemedi!!!
" ; }
}
// journal_back_refs_book ; journal_back_refs_journal ; journal_back_refs_web
foreach($xml->back[0]->{'ref-list'}[0]->ref as $refs) {
switch((string) $refs->{'mixed-citation'}['publication-type']) {
case 'journal':
//journal_refs_journal
$refid = $refs['id'];
$refpubtype = $refs->{'mixed-citation'}['publication-type'];
$year = $refs->{'mixed-citation'}->{'year'} ;
$arttitle = $refs->{'mixed-citation'}->{'article-title'} ;
$source = $refs->{'mixed-citation'}->{'source'} ;
$volume = $refs->{'mixed-citation'}->{'volume'} ;
$fpage = $refs->{'mixed-citation'}->{'fpage'} ;
$lpage = $refs->{'mixed-citation'}->{'lpage'} ;
echo $year;
echo "
" ;
echo $arttitle;
echo "
" ;
echo $source;
echo "
" ;
echo $volume;
echo "
" ;
echo $fpage;
echo "
" ;
echo $lpage;
echo "
" ;
$ins = mysql_query(" insert into journal_back_refs_journal (JID,REF_ID,MIXED_CIT_PUB_TYPE,REF_YEAR,ARTICLE_TITLE,ARTICLE_SOURCE,ARTICLE_VOLUME,ARTICLE_FPAGE,ARTICLE_LPAGE)
VALUES ('$jid','".r($refid)."','".r($refpubtype)."','".r($year)."','".r($arttitle)."','".r($source)."','".r($volume)."','".r($fpage)."','".r($lpage)."') ");
if ($ins)
{echo " journal_back_refs_journal Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_refs_journal Tablosuna Kayit Girilemedi!!!
" ; }
break;
case 'book':
$refid = $refs['id'];
$refpubtype = $refs->{'mixed-citation'}['publication-type'];
$year = $refs->{'mixed-citation'}->{'year'} ;
$arttitle = $refs->{'mixed-citation'}->{'article-title'} ;
$source = $refs->{'mixed-citation'}->{'source'} ;
$publoc = $refs->{'mixed-citation'}->{'publisher-loc'} ;
$pubname = $refs->{'mixed-citation'}->{'publisher-name'} ;
echo $year;
echo "
" ;
echo $arttitle;
echo "
" ;
echo $source;
echo "
" ;
echo $publoc;
echo "
" ;
echo $pubname;
echo "
" ;
$ins = mysql_query(" insert into journal_back_refs_book (JID,REF_ID,MIXED_CIT_PUB_TYPE,REF_YEAR,ARTICLE_SOURCE,ARTICLE_TITLE,PUBLISHER_LOC,PUBLISHER_NAME)
VALUES ('$jid','".r($refid)."','".r($refpubtype)."','".r($year)."','".r($source)."','".r($arttitle)."','".r($publoc)."','".r($pubname)."') ");
if ($ins)
{echo " journal_back_refs_book Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_refs_book Tablosuna Kayit Girilemedi!!!
" ; }
break;
// 20140420 -- book yerine BOOK olarak geldiginde de kullanilabilir
case 'BOOK':
$refid = $refs['id'];
$refpubtype = $refs->{'mixed-citation'}['publication-type'];
$year = $refs->{'mixed-citation'}->{'year'} ;
$arttitle = $refs->{'mixed-citation'}->{'article-title'} ;
$source = $refs->{'mixed-citation'}->{'source'} ;
$publoc = $refs->{'mixed-citation'}->{'publisher-loc'} ;
$pubname = $refs->{'mixed-citation'}->{'publisher-name'} ;
echo $year;
echo "
" ;
echo $arttitle;
echo "
" ;
echo $source;
echo "
" ;
echo $publoc;
echo "
" ;
echo $pubname;
echo "
" ;
$ins = mysql_query(" insert into journal_back_refs_book (JID,REF_ID,MIXED_CIT_PUB_TYPE,REF_YEAR,ARTICLE_SOURCE,ARTICLE_TITLE,PUBLISHER_LOC,PUBLISHER_NAME)
VALUES ('$jid','".r($refid)."','".r($refpubtype)."','".r($year)."','".r($source)."','".r($arttitle)."','".r($publoc)."','".r($pubname)."') ");
if ($ins)
{echo " journal_back_refs_book Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_refs_book Tablosuna Kayit Girilemedi!!!
" ; }
break;
case 'web':
$refid = $refs['id'];
$refpubtype = $refs->{'mixed-citation'}['publication-type'];
$year = $refs->{'mixed-citation'}->{'year'} ;
$source = $refs->{'mixed-citation'}->{'source'} ;
foreach ($refs->{'mixed-citation'}->{'comment'} as $c){
$extlink = $c->{'ext-link'} ;
if (strlen($extlink) <> 0) break;
}
echo $year;
echo "
" ;
echo $source;
echo "
" ;
echo $extlink;
echo "
" ;
$ins = mysql_query(" insert into journal_back_refs_web (JID,REF_ID,MIXED_CIT_PUB_TYPE,REF_YEAR,ARTICLE_SOURCE,EXT_LINK)
VALUES ('$jid','".r($refid)."','".r($refpubtype)."','".r($year)."','".r($source)."','".r($extlink)."') ");
if ($ins)
{echo " journal_back_refs_web Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_refs_web Tablosuna Kayit Girilemedi!!!
" ; }
break;
default: echo " Dikkat !!! Referanslarda web, journal ya da book haricinde yeni bir referans var : " . $refs->{'mixed-citation'}['publication-type'] . "
";
}
}
// references person groups ::::
// journal_back_refs_pg
foreach($xml->back[0]->{'ref-list'}[0]->ref as $refs) {
$refid = $refs['id'];
foreach($refs->{'mixed-citation'}->{'person-group'} as $pg) {
switch((string) $pg['person-group-type']) {
case 'author':
foreach ($pg->name as $pgn) {
$pgsurname = $pgn->{'surname'} ;
echo $pgsurname ;
echo "
" ;
$pggivennames = $pgn->{'given-names'} ;
echo $pggivennames ;
echo "
" ;
$ins = mysql_query(" insert into journal_back_refs_pg (JID,REF_ID,SURNAME,GIVEN_NAMES)
VALUES ('$jid','".r($refid)."','".r($pgsurname)."','".r($pggivennames)."') ");
if ($ins)
{echo " journal_back_refs_pg Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_refs_pg Tablosuna Kayit Girilemedi!!!
" ; }
}
break;
// 20140420 -- sadece author vardi, editor de eklendi
case 'editor':
foreach ($pg->name as $pgn) {
$pgsurname = $pgn->{'surname'} ;
echo $pgsurname ;
echo "
" ;
$pggivennames = $pgn->{'given-names'} ;
echo $pggivennames ;
echo "
" ;
$ins = mysql_query(" insert into journal_back_refs_pg (JID,REF_ID,SURNAME,GIVEN_NAMES)
VALUES ('$jid','".r($refid)."','".r($pgsurname)."','".r($pggivennames)."') ");
if ($ins)
{echo " journal_back_refs_pg Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_refs_pg Tablosuna Kayit Girilemedi!!!
" ; }
}
break;
default: echo " Dikkat !!! Referanslarda PersonGroup'larda author'dan farklı tip var !!! web, journal ya da book haricinde yeni bir referans var : " . $pg['person-group-type'] . "
";
}
}
$pgsurname = $refs->{'mixed-citation'}->{'collab'} ;
echo $pgsurname ;
echo "
" ;
$pggivennames = '' ;
echo $pggivennames ;
$ins = mysql_query(" insert into journal_back_refs_pg (JID,REF_ID,SURNAME,GIVEN_NAMES)
VALUES ('$jid','".r($refid)."','".r($pgsurname)."','".r($pggivennames)."') ");
if ($ins)
{echo " journal_back_refs_pg Tablosuna Kayit Girildi
" ; }
else
{echo " journal_back_refs_pg Tablosuna Kayit Girilemedi!!!
" ; }
}
// floats::::::::::::::
// journal_floats = fig ya da table-wrap gelebiliyor, iki asamada insert olacak :
foreach($xml->{'floats-group'}[0]->fig as $figs) {
$floattype = 'fig' ;
$figid = $figs['id'];
echo $figid;
echo "
" ;
echo $floattype;
echo "
" ;
$ins = mysql_query(" insert into journal_floats (JID,FLOAT_TYPE,FLOAT_ID)
VALUES ('$jid','".r($floattype)."','".r($figid)."') ");
if ($ins)
{echo " journal_floats Tablosuna Kayit Girildi
" ; }
else
{echo " journal_floats Tablosuna Kayit Girilemedi!!!
" ; }
}
foreach($xml->{'floats-group'}[0]->{'table-wrap'}as $tabs) {
$floattype = 'table-wrap' ;
$tabid = $tabs['id'];
echo $tabid;
echo "
" ;
echo $floattype;
echo "
" ;
$ins = mysql_query(" insert into journal_floats (JID,FLOAT_TYPE,FLOAT_ID)
VALUES ('$jid','".r($floattype)."','".r($tabid)."') ");
if ($ins)
{echo " journal_floats Tablosuna Kayit Girildi
" ; }
else
{echo " journal_floats Tablosuna Kayit Girilemedi!!!
" ; }
}
// journal_floats_fig
foreach($xml->{'floats-group'}[0]->fig as $figs) {
$figid = $figs['id'];
$figlabel= $figs->label ;
$figcaption = $figs->caption->p;
$attr = $figs->graphic->attributes('xlink',true);
$figgraphic = $attr['href'] ;
echo $figid;
echo "
" ;
echo $figlabel;
echo "
" ;
echo $figcaption;
echo "
" ;
echo $figgraphic;
echo "
" ;
$ins = mysql_query(" insert into journal_float_fig (JID,FIG_ID,FIG_LABEL,FIG_CAPTION,FIG_GRAPHIC)
VALUES ('$jid','".r($figid)."','".r($figlabel)."','".r($figcaption)."','".r($figgraphic)."') ");
if ($ins)
{echo " journal_float_fig Tablosuna Kayit Girildi
" ; }
else
{echo " journal_float_fig Tablosuna Kayit Girilemedi!!!
" ; }
}
// journal_floats_table
foreach($xml->{'floats-group'}[0]->{'table-wrap'}as $tabs) {
$tabid = $tabs['id'];
$tablabel= $tabs->label ;
$tabcaption = $tabs->caption->p;
$tabsource = $tabs->table->asXML() ;
echo $tablabel;
echo "
" ;
echo $tabcaption;
echo "
" ;
echo $tabsource;
echo "
" ;
$ins = mysql_query(" insert into journal_float_table (JID,TABLE_ID,TABLE_LABEL,TABLE_CAPTION,TABLE_SOURCE)
VALUES ('$jid','".r($tabid)."','".r($tablabel)."','".r($tabcaption)."','".r($tabsource)."') ");
if ($ins)
{echo " journal_float_table Tablosuna Kayit Girildi
" ; }
else
{echo " journal_float_table Tablosuna Kayit Girilemedi!!!
" ; }
}
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
echo "
" ;
// body ::::::::::::::::::::::::::
// journal_body
foreach($xml->{'body'}[0]->{'sec'}as $secs) {
$secparent = '' ;
$secid = $secs['id'] ;
$sectype = $secs['sec-type'] ;
$sectitle = $secs->title ;
$sectext = '';
foreach ($secs->p as $sp) {
$sectext = $sectext . $sp->asXML();
}
// deep2 :
foreach ($secs->sec as $secs2) {
$secparent2 = $secid ;
$secid2 = $secs2['id'] ;
$sectype2 = $secs2['sec-type'] ;
$sectitle2 = $secs2->title ;
$sectext2 = '';
foreach ($secs2->p as $sp2) {
$sectext2 = $sectext2 . $sp2->asXML();
}
//deep3 :
foreach ($secs2->sec as $secs3) {
$secparent3 = $secid2;
$secid3 = $secs3['id'] ;
$sectype3 = $secs3['sec-type'] ;
$sectitle3 = $secs3->title ;
$sectext3 = '';
foreach ($secs3->p as $sp3) {
$sectext3 = $sectext3 . $sp3->asXML();
}
//deep4 :
foreach ($secs3->sec as $secs4) {
$secparent4 = $secid3;
$secid4 = $secs4['id'] ;
$sectype4 = $secs4['sec-type'] ;
$sectitle4 = $secs4->title ;
$sectext4 = '';
foreach ($secs4->p as $sp4) {
$sectext4 = $sectext4 . $sp4->asXML();
}
$secparent4a = strtr($secparent4, "sec-", "111");
$secparent4a = strtr($secparent4, "sec-", "111");
$ins = mysql_query(" insert into journal_body (JID,PARENT_SECTION,SECTION_ID,SECTION_TYPE,SECTION_TITLE,SECTION_TEXT)
VALUES ('$jid','".r($secparent4a)."','".r($secid4a)."','".r($sectype4)."','".r($sectitle4)."','".r($sectext4)."') ");
if ($ins) {echo " journal_body Tablosuna Kayit Girildi
" ; } else {echo " journal_body Tablosuna Kayit Girilemedi!!!
" ; }
echo $secparent4;
echo "
" ;
echo $secid4;
echo "
" ;
echo $sectype4;
echo "
" ;
echo $sectitle4;
echo "
" ;
echo $sectext4;
echo "
" ;
}
$secparent3a = strtr($secparent3, "sec-", "1111");
$secid3a = strtr($secid3, "sec-", "1111");
$ins = mysql_query(" insert into journal_body (JID,PARENT_SECTION,SECTION_ID,SECTION_TYPE,SECTION_TITLE,SECTION_TEXT)
VALUES ('$jid','".r($secparent3a)."','".r($secid3a)."','".r($sectype3)."','".r($sectitle3)."','".r($sectext3)."') ");
if ($ins) {echo " journal_body Tablosuna Kayit Girildi
" ; } else {echo " journal_body Tablosuna Kayit Girilemedi!!!
" ; }
echo $secparent3;
echo "
" ;
echo $secid3;
echo "
" ;
echo $sectype3;
echo "
" ;
echo $sectitle3;
echo "
" ;
echo $sectext3;
echo "
" ;
}
$secparent2a = strtr($secparent2, "sec-", "1111");
$secid2a = strtr($secid2, "sec-", "1111");
$ins = mysql_query(" insert into journal_body (JID,PARENT_SECTION,SECTION_ID,SECTION_TYPE,SECTION_TITLE,SECTION_TEXT)
VALUES ('$jid','".r($secparent2a)."','".r($secid2a)."','".r($sectype2)."','".r($sectitle2)."','".r($sectext2)."') ");
if ($ins) {echo " journal_body Tablosuna Kayit Girildi
" ; } else {echo " journal_body Tablosuna Kayit Girilemedi!!!
" ; }
echo $secparent2;
echo "
" ;
echo $secid2;
echo "
" ;
echo $sectype2;
echo "
" ;
echo $sectitle2;
echo "
" ;
echo $sectext2;
echo "
" ;
}
$secparenta = strtr($secparent, "sec-", "1111");
$secida = strtr($secid, "sec-", "1111");
$ins = mysql_query(" insert into journal_body (JID,PARENT_SECTION,SECTION_ID,SECTION_TYPE,SECTION_TITLE,SECTION_TEXT)
VALUES ('$jid','".r($secparenta)."','".r($secida)."','".r($sectype)."','".r($sectitle)."','".r($sectext)."') ");
if ($ins) {echo " journal_body Tablosuna Kayit Girildi
" ; } else {echo " journal_body Tablosuna Kayit Girilemedi!!!
" ; }
echo $secparent;
echo "
" ;
echo $secid;
echo "
" ;
echo $sectype;
echo "
" ;
echo $sectitle;
echo "
" ;
echo $sectext;
echo "
" ;
}
$i= 0;
$query=mysql_query("select * from journal_contrib where JID='$jid' ORDER BY contrib_order")or die(mysql_error());
while ($result=mysql_fetch_array($query))
{
$GIVEN_NAMES=$result['GIVEN_NAMES'];
$SURNAME=$result['SURNAME'];
//ilk tırnak 0 değeri için yok :)
if ($i==0) $ad= $GIVEN_NAMES . " " . $SURNAME."" ;
else $ad= ', '.$GIVEN_NAMES . " " . $SURNAME."" ;
$isim[i]=$ad;
$uzun_isim=$uzun_isim.$isim[i];
$i++;
}
$ins2 = mysql_query(" UPDATE jssmorgf SET yazar ='$uzun_isim' WHERE JID = '$jid'");
echo 'Uzun Isim : '.$uzun_isim;
//$i= 0;
//$query=mysql_query("select * from journal_keywords where JID='$jid' ORDER BY id")or die(mysql_error());
//while ($result=mysql_fetch_array($query))
//{
//$KWD_KEYWORD=$result['KWD_KEYWORD'];
//$ad2= $KWD_KEYWORD;
//$isim2[i]=$ad2;
//$uzun_isim2=$uzun_isim2.$isim2[i];
//$i++;
//}
//$ins2232 = mysql_query(" UPDATE jssmorgf SET wkey ='$uzun_isim2' WHERE JID = '$jid'");
//echo ".$uzun_isim2, ";
//*(aşağıdakileri Reviewler ve caseler için uygula sona dikkat)
$ins3 = mysql_query("UPDATE journal_body SET `PARENT_SECTION` ='111111' WHERE `SECTION_ID` = '111111'");
$ins4 = mysql_query("UPDATE journal_body SET `PARENT_SECTION` ='111112' WHERE `SECTION_ID` = '111112'");
$ins5 = mysql_query("UPDATE journal_body SET `PARENT_SECTION` ='111113' WHERE `SECTION_ID` = '111113'");
$ins6 = mysql_query("UPDATE journal_body SET `PARENT_SECTION` ='111114' WHERE `SECTION_ID` = '111114'");
$ins7 = mysql_query("UPDATE journal_body SET `PARENT_SECTION` ='111115' WHERE `SECTION_ID` = '111115'");
$ins8 = mysql_query("UPDATE journal_body SET `PARENT_SECTION` ='111116' WHERE `SECTION_ID` = '111116'");
$ins9 = mysql_query("UPDATE journal_body SET `PARENT_SECTION` ='111117' WHERE `SECTION_ID` = '111117'");
$ins10 = mysql_query("UPDATE journal_body SET `PARENT_SECTION` ='111118' WHERE `SECTION_ID` = '111118'");
//*(aşağıdakileri başlıkları büyük harfe çevirmek için uygula )
$ins11 = mysql_query("UPDATE journal_body SET `SECTION_TITLE` ='