$resource->archiveDate = ''; $resource->archiveLoginID = ''; } } try { $resource->save(); } catch (Exception $e) { echo $e->getMessage(); } //update resource relationship (currently code only allows parent) //first remove the existing relationship then add it back $resource->removeParentResources(); if ($_POST['parentResourcesID']) { $parentResourcesArray = json_decode($_POST['parentResourcesID']); foreach ($parentResourcesArray as $parentResource) { $resourceRelationship = new ResourceRelationship(); $resourceRelationship->resourceID = $resourceID; $resourceRelationship->relatedResourceID = $parentResource; $resourceRelationship->relationshipTypeID = '1'; //hardcoded because we're only allowing parent relationships try { $resourceRelationship->save(); } catch (Exception $e) { echo $e->getMessage(); } } } //next, delete and then re-insert the aliases $alias = new Alias(); foreach ($resource->getAliases() as $alias) { $alias->delete();
$parentResource = new Resource(); $parentResource->createLoginID = $loginID; $parentResource->createDate = date('Y-m-d'); $parentResource->titleText = $data[$_POST['parentResource']]; $parentResource->statusID = 1; $parentResource->save(); $parentID = $parentResource->resourceID; $parentInserted++; } elseif ($numberOfParents == 1) { // Else, attach the resource to its parent. $parentResource = $resourceObj->getResourceByTitle($data[$_POST['parentResource']]); $parentID = $parentResource[0]->resourceID; $parentAttached++; } if ($numberOfParents == 0 || $numberOfParents == 1) { $resourceRelationship = new ResourceRelationship(); $resourceRelationship->resourceID = $resource->resourceID; $resourceRelationship->relatedResourceID = $parentID; $resourceRelationship->relationshipTypeID = '1'; //hardcoded because we're only allowing parent relationships if (!$resourceRelationship->exists()) { $resourceRelationship->save(); } } } } $row++; } print "<h2>Results</h2>"; print "<p>" . ($row - 1) . " rows have been processed. {$inserted} rows have been inserted.</p>"; print "<p>{$parentInserted} parents have been created. {$parentAttached} resources have been attached to an existing parent.</p>";