function xnpbookInsertItem(&$item_id)
{
// set fixed value for month and day
$_POST['publicationDateMonth'] = 1;
$_POST['publicationDateDay'] = 1;
// register BasicInformation, Index, Attachment
$item_id = 0;
$result = xnpInsertBasicInformation($item_id);
if ($result) {
$result = xnpUpdateIndex($item_id);
if ($result) {
$result = xnpUpdateAttachment($item_id, 'book_pdf');
}
if (!$result) {
xnpDeleteBasicInformation($_SESSION['XNPSID'], $item_id);
}
}
if (!$result) {
return false;
}
// limit length
$ar = _xnpbook_get_detail_request();
xnpTrimColumn($ar, 'xnpbook_item_detail', array_keys($ar), _CHARSET);
$hItemDetail =& xoonips_getormhandler('xnpbook', 'item_detail');
$oItemDetail =& $hItemDetail->create();
$oItemDetail->setVar('book_id', $item_id, true);
// not gpc
$oItemDetail->setVars($ar, true);
// not gpc
if (!$hItemDetail->insert($oItemDetail)) {
error_log('xnpbook: cannot insert item_detail - ' . implode(', ', $oItemDetail->getErrors()));
return false;
}
// insert author
$formdata =& xoonips_getutility('formdata');
$author_handler =& xoonips_getormhandler('xnpbook', 'author');
$author_objs =& $formdata->getObjectArray('post', $author_handler->getTableName(), $author_handler, false);
if (!$author_handler->updateAllObjectsByForeignKey('book_id', $item_id, $author_objs)) {
return false;
}
return true;
}
function xnpconferenceInsertItem(&$item_id)
{
global $xoopsDB;
$formdata =& xoonips_getutility('formdata');
$xnpsid = $_SESSION['XNPSID'];
// register BasicInformation, Index, Attachment
$item_id = 0;
$_POST['publicationDateYear'] = addslashes($formdata->getValue('post', 'conferenceFromYear', 'i', false));
$_POST['publicationDateMonth'] = addslashes($formdata->getValue('post', 'conferenceFromMonth', 'i', false));
$_POST['publicationDateDay'] = addslashes($formdata->getValue('post', 'conferenceFromDay', 'i', false));
$result = xnpInsertBasicInformation($item_id);
if ($result) {
$result = xnpUpdateIndex($item_id);
if ($result) {
$result = xnpUpdatePreview($item_id);
if ($result) {
$result = xnpUpdateAttachment($item_id, 'conference_file');
if ($result) {
$result = xnpUpdateAttachment($item_id, 'conference_paper');
if ($result) {
}
}
}
}
if (!$result) {
xnpDeleteBasicInformation($xnpsid, $item_id);
}
}
if (!$result) {
return false;
}
$keys = implode(',', array('attachment_dl_limit', 'attachment_dl_notify', 'presentation_type', 'conference_title', 'place', 'abstract', 'conference_from_year', 'conference_from_month', 'conference_from_mday', 'conference_to_year', 'conference_to_month', 'conference_to_mday'));
// trim strings
$ar = array('presentation_type' => $formdata->getValue('post', 'presentation_type', 's', false), 'conference_title' => $formdata->getValue('post', 'conference_title', 's', false), 'place' => $formdata->getValue('post', 'place', 's', false), 'abstract' => $formdata->getValue('post', 'abstract', 's', false));
xnpTrimColumn($ar, 'xnpconference_item_detail', array_keys($ar), _CHARSET);
$attachment_dl_limit = $formdata->getValue('post', 'attachment_dl_limit', 'i', false);
$attachment_dl_notify = $formdata->getValue('post', 'attachment_dl_notify', 'i', false);
$vals = implode('\',\'', array($attachment_dl_limit, $attachment_dl_limit ? $attachment_dl_notify : 0, addslashes($ar['presentation_type']), addslashes($ar['conference_title']), addslashes($ar['place']), addslashes($ar['abstract']), addslashes($formdata->getValue('post', 'conferenceFromYear', 'i', false)), addslashes($formdata->getValue('post', 'conferenceFromMonth', 'i', false)), addslashes($formdata->getValue('post', 'conferenceFromDay', 'i', false)), addslashes($formdata->getValue('post', 'conferenceToYear', 'i', false)), addslashes($formdata->getValue('post', 'conferenceToMonth', 'i', false)), addslashes($formdata->getValue('post', 'conferenceToDay', 'i', false))));
// register DetailInformation
$sql = 'insert into ' . $xoopsDB->prefix('xnpconference_item_detail') . " ( conference_id, {$keys} ) values ( {$item_id}, '{$vals}' ) ";
$result = $xoopsDB->queryF($sql);
if ($result == false) {
echo 'cannot insert item_detail';
return false;
}
// insert author
$author_handler =& xoonips_getormhandler('xnpconference', 'author');
$author_objs =& $formdata->getObjectArray('post', $author_handler->getTableName(), $author_handler, false);
if (!$author_handler->updateAllObjectsByForeignKey('conference_id', $item_id, $author_objs)) {
return false;
}
return true;
}
function xnppresentationInsertItem(&$item_id)
{
global $xoopsDB;
$xnpsid = $_SESSION['XNPSID'];
$formdata =& xoonips_getutility('formdata');
// retister BasicInformation, Index and Attachment
$item_id = 0;
$result = xnpInsertBasicInformation($item_id);
if ($result) {
$result = xnpUpdateIndex($item_id);
if ($result) {
$result = xnpUpdatePreview($item_id);
if ($result) {
$result = xnpUpdateAttachment($item_id, 'presentation_file');
if ($result) {
}
}
}
if (!$result) {
xnpDeleteBasicInformation($xnpsid, $item_id);
}
}
if (!$result) {
return false;
}
// register detail information
list($rights, $use_cc, $cc_commercial_use, $cc_modification) = xnpGetRights();
$myts =& MyTextSanitizer::getInstance();
// it makes string with constant length
$ar = array('presentation_type' => $formdata->getValue('post', 'presentation_type', 's', true), 'readme' => xnpGetTextFile('readme'), 'rights' => $rights);
xnpTrimColumn($ar, 'xnppresentation_item_detail', array_keys($ar), _CHARSET);
$myts =& MyTextSanitizer::getInstance();
$keys = implode(',', array('attachment_dl_limit', 'attachment_dl_notify', 'presentation_type', 'readme', 'rights', 'use_cc', 'cc_commercial_use', 'cc_modification'));
$attachment_dl_limit = $formdata->getValue('post', 'attachment_dl_limit', 'i', true);
$attachment_dl_notify = $formdata->getValue('post', 'attachment_dl_notify', 'i', true);
$vals = implode('\',\'', array($attachment_dl_limit, $attachment_dl_limit ? $attachment_dl_notify : 0, addslashes($ar['presentation_type']), addslashes($ar['readme']), addslashes($ar['rights']), $use_cc, $cc_commercial_use, $cc_modification));
$sql = 'insert into ' . $xoopsDB->prefix('xnppresentation_item_detail') . " ( presentation_id, {$keys} ) values ( {$item_id}, '{$vals}' ) ";
$result = $xoopsDB->queryF($sql);
if ($result == false) {
echo 'cannot insert item_detail';
return false;
}
// insert creator
$creator_handler =& xoonips_getormhandler('xnppresentation', 'creator');
$creator_objs =& $formdata->getObjectArray('post', $creator_handler->getTableName(), $creator_handler, false);
if (!$creator_handler->updateAllObjectsByForeignKey('presentation_id', $item_id, $creator_objs)) {
return false;
}
return true;
}
function xnpfilesInsertItem(&$item_id)
{
global $xoopsDB;
$formdata =& xoonips_getutility('formdata');
$xnpsid = $_SESSION['XNPSID'];
// register BasicInformation, Index, Attachment
$item_id = 0;
$result = xnpInsertBasicInformation($item_id);
if ($result) {
$result = xnpUpdateIndex($item_id);
if ($result) {
$result = xnpUpdatePreview($item_id);
if ($result) {
$result = xnpUpdateAttachment($item_id, 'files_file');
if ($result) {
}
}
}
if (!$result) {
xnpDeleteBasicInformation($xnpsid, $item_id);
}
}
if (!$result) {
return false;
}
// register Detail Information
$file_id = $formdata->getValue('post', 'files_fileFileID', 'i', false);
$file_handler =& xoonips_getormhandler('xoonips', 'file');
$file_obj =& $file_handler->get($file_id);
$file_name = $file_obj->get('original_file_name');
$file_mimetype = $file_obj->get('mime_type');
$file_pathinfo = pathinfo($file_name);
$file_type = $file_pathinfo['extension'];
$detail_handler =& xoonips_getormhandler('xnpfiles', 'item_detail');
$detail_obj =& $detail_handler->create();
$detail_obj->set('files_id', $item_id);
$detail_obj->set('data_file_name', $file_name);
$detail_obj->set('data_file_mimetype', $file_mimetype);
$detail_obj->set('data_file_filetype', $file_type);
if (!$detail_handler->insert($detail_obj)) {
echo 'cannot insert item_detail';
return false;
}
return true;
}
function xnppaperInsertItem(&$item_id)
{
global $xoopsDB;
$formdata =& xoonips_getutility('formdata');
$xnpsid = $_SESSION['XNPSID'];
// register BasicInformation, Index, Attachment
$item_id = 0;
$result = xnpInsertBasicInformation($item_id);
if ($result) {
$result = xnpUpdateIndex($item_id);
if ($result) {
$result = xnpUpdateAttachment($item_id, 'paper_pdf_reprint');
if ($result) {
}
}
if (!$result) {
xnpDeleteBasicInformation($xnpsid, $item_id);
}
}
if (!$result) {
return false;
}
// limit length
$journal = $formdata->getValue('post', 'journal', 's', false);
$volume = $formdata->getValue('post', 'volume', 's', false);
$number = $formdata->getValue('post', 'number', 's', false);
$page = $formdata->getValue('post', 'page', 's', false);
$abstract = $formdata->getValue('post', 'abstract', 's', false);
$pubmed_id = $formdata->getValue('post', 'pubmed_id', 's', false);
$ar = array('journal' => $journal, 'page' => $page, 'abstract' => $abstract, 'pubmed_id' => $pubmed_id);
xnpTrimColumn($ar, 'xnppaper_item_detail', array_keys($ar), _CHARSET);
$keys = implode(',', array('journal', 'volume', 'number', 'page', 'abstract', 'pubmed_id'));
$vals = implode(',', array('\'' . addslashes($ar['journal']) . '\'', strlen($volume) == 0 ? 'null' : (int) $volume, strlen($number) == 0 ? 'null' : (int) $number, strlen($page) == 0 ? 'null' : '\'' . addslashes($ar['page']) . '\'', strlen($abstract) == 0 ? 'null' : '\'' . addslashes($ar['abstract']) . '\'', strlen($pubmed_id) == 0 ? 'null' : '\'' . addslashes($ar['pubmed_id']) . '\''));
// register detail information
$sql = 'insert into ' . $xoopsDB->prefix('xnppaper_item_detail') . " ( paper_id, {$keys} ) values ( {$item_id}, {$vals} ) ";
$result = $xoopsDB->queryF($sql);
if ($result == false) {
return false;
}
// insert author
$author_handler =& xoonips_getormhandler('xnppaper', 'author');
$author_objs =& $formdata->getObjectArray('post', $author_handler->getTableName(), $author_handler, false);
if (!$author_handler->updateAllObjectsByForeignKey('paper_id', $item_id, $author_objs)) {
return false;
}
return true;
}
function xnpmemoInsertItem(&$item_id)
{
global $xoopsDB;
$formdata =& xoonips_getutility('formdata');
$xnpsid = $_SESSION['XNPSID'];
// register BasicInformation, Index, Attachment
$item_id = 0;
$result = xnpInsertBasicInformation($item_id);
if ($result) {
$result = xnpUpdateIndex($item_id);
if ($result) {
$result = xnpUpdateAttachment($item_id, 'memo_file');
if ($result) {
}
}
if (!$result) {
xnpDeleteBasicInformation($xnpsid, $item_id);
}
}
if (!$result) {
return false;
}
$ar = array('item_link' => preg_replace('/javascript:/i', '', preg_replace('/[\\x00-\\x20\\x22\\x27]/', '', $formdata->getValue('post', 'item_link', 's', false))));
xnpTrimColumn($ar, 'xnpmemo_item_detail', array_keys($ar), _CHARSET);
$escval = addslashes($ar['item_link']);
// register DetailInformation
$sql = 'insert into ' . $xoopsDB->prefix('xnpmemo_item_detail') . " ( memo_id, item_link ) values ( {$item_id}, '{$escval}' ) ";
$result = $xoopsDB->queryF($sql);
if ($result == false) {
echo 'cannot insert item_detail';
return false;
}
return true;
}
function xnpurlInsertItem(&$item_id)
{
$formdata =& xoonips_getutility('formdata');
global $xoopsDB;
$xnpsid = $_SESSION['XNPSID'];
// retister BasicInformation, Index and Attachment
$item_id = 0;
$result = xnpInsertBasicInformation($item_id);
if ($result) {
$result = xnpUpdateIndex($item_id);
if ($result) {
$result = xnpUpdateAttachment($item_id, 'url_banner_file');
if ($result) {
}
}
if (!$result) {
xnpDeleteBasicInformation($xnpsid, $item_id);
}
}
if (!$result) {
return false;
}
// limit num of chracters
$ar = array('url' => preg_replace('/javascript:/i', '', preg_replace('/[\\x00-\\x20\\x22\\x27]/', '', $formdata->getValue('post', 'url', 's', false))));
xnpTrimColumn($ar, 'xnpurl_item_detail', array_keys($ar), _CHARSET);
// register detail information
$sql = 'insert into ' . $xoopsDB->prefix('xnpurl_item_detail') . " ( url_id, url ) values ( {$item_id}, '" . addslashes($ar['url']) . '\' ) ';
$result = $xoopsDB->queryF($sql);
if ($result == false) {
echo 'cannot insert item_detail';
return false;
}
return true;
}
function xnpbinderInsertItem(&$binder_id)
{
global $xoopsDB;
// Insert BasicInformation, Index, Preview, Attachment
$binder_id = 0;
$result = xnpInsertBasicInformation($binder_id);
if ($result) {
$result = xnpUpdateIndex($binder_id);
if (!$result) {
xnpDeleteBasicInformation($_SESSION['XNPSID'], $binder_id);
}
}
if (!$result) {
return false;
}
// Insert DetailInformation
$detail_handler =& xoonips_getormhandler('xnpbinder', 'item_detail');
$detail =& $detail_handler->create();
$detail->setVar('binder_id', $binder_id, true);
if (!$detail_handler->insert($detail)) {
echo 'cannot insert item_detail';
return false;
}
$xoonips_item_id = xnpbinder_get_xoonips_item_id();
foreach ($xoonips_item_id as $iid) {
$result = $xoopsDB->queryF('insert into ' . $xoopsDB->prefix('xnpbinder_binder_item_link') . " ( binder_id, item_id ) values ( {$binder_id}, {$iid} )");
if ($result == false) {
echo 'cannot insert item_detail';
return false;
}
}
return true;
}
