$generalSubject->save();
$generalSubjectID = $generalSubject->primaryKey;
$detailSubjectArray = array();
$detailSubjectArray = explode(':::', $_POST['detailSubjectsList']);
$detailSubjectIDs = "(-1";
// Update the GeneralDetailSubject Links
foreach ($detailSubjectArray as $key => $value) {
if ($value) {
$generalDetailSubjectLink = new GeneralDetailSubjectLink();
$generalDetailSubjectLink->detailedSubjectID = $value;
$generalDetailSubjectLink->generalSubjectID = $generalSubjectID;
// Add any Detail Subject Links that are new
if ($generalDetailSubjectLink->duplicateCheck() == 0) {
// Add the new link
try {
$generalDetailSubjectLink->save();
} catch (Exception $e) {
echo $e->getMessage();
}
}
// Build list of detailid's that are in use
$detailSubjectIDs = $detailSubjectIDs . ', ' . $value;
}
}
$detailSubjectIDs = $detailSubjectIDs . ')';
$generalDetailSubjectLink = new GeneralDetailSubjectLink();
// Delete the links that are no longer in use.
$generalDetailSubjectLink->deleteNotInuse($generalSubjectID, $detailSubjectIDs);
} catch (Exception $e) {
echo $e->getMessage();
}
<?php
$resourceSubject = new ResourceSubject();
$resourceID = $_GET['resourceID'];
$generalSubjectID = $_GET['generalSubjectID'];
$detailSubjectID = $_GET['detailSubjectID'];
if (!isset($detailSubjectID)) {
$detailSubjectID = -1;
}
if (!isset($generalSubjectID)) {
$generalSubjectID = -1;
}
$generalDetailSubjectLink = new GeneralDetailSubjectLink();
$generalDetailSubjectLinkID = $generalDetailSubjectLink->getGeneralDetailID($generalSubjectID, $detailSubjectID);
$resourceSubject->resourceID = $resourceID;
$resourceSubject->generalDetailSubjectLinkID = $generalDetailSubjectLinkID;
// Check to see if the subject has already been associated with the resouce. If not then save.
if ($resourceSubject->duplicateCheck($resourceID, $generalDetailSubjectLinkID) == 0) {
try {
$resourceSubject->save();
} catch (Exception $e) {
echo $e->getMessage();
}
}
foreach ($subjectArray as $currentSubject) {
$index = searchForShortName($currentSubject, $generalSubjectArray);
if ($index !== null) {
$generalSubjectID = $generalSubjectArray[$index]['generalSubjectID'];
} else {
if ($index === null && $currentSubject != '') {
$generalSubjectObj = new GeneralSubject();
$generalSubjectObj->shortName = $currentSubject;
$generalSubjectObj->save();
$generalSubjectID = $generalSubjectObj->primaryKey;
$generalSubjectArray = $generalSubjectObj->allAsArray();
$generalSubjectInserted++;
}
}
if ($generalSubjectID !== null) {
$generalDetailSubjectLinkObj = new GeneralDetailSubjectLink();
$generalDetailID = $generalDetailSubjectLinkObj->getGeneralDetailID($generalSubjectID, -1);
if ($generalDetailID !== -1) {
array_push($generalDetailSubjectLinkIDArray, $generalDetailID);
}
}
}
}
// Let's insert data
$resource->createLoginID = $loginID;
$resource->createDate = date('Y-m-d');
$resource->updateLoginID = '';
$resource->updateDate = '';
$resource->titleText = trim($data[$resourceTitleColumn]);
$resource->descriptionText = trim($data[$resourceDescColumn]);
$resource->resourceURL = trim($data[$resourceURLColumn]);
