protected function processRecord($record, $columnMap, &$results, $preview = false) { $class = $this->objectClass; $title = trim($record['Title']); $item = trim($record['ListItem']); $existingList = DynamicList::get_dynamic_list($title); if (!$existingList) { $existingList = new DynamicList(); $existingList->Title = $title; $existingList->write(); } // now add the item to that list $existingItem = DataObject::get_one('DynamicListItem', '"Title"=\'' . Convert::raw2sql($item) . '\' AND "ListID" = ' . (int) $existingList->ID); if (!$existingItem) { $existingItem = new DynamicListItem(); $existingItem->Title = $item; $existingItem->ListID = $existingList->ID; $existingItem->write(); } }
public function getItemByTitle($title) { $SQL_title = Convert::raw2sql($title); $item = DataObject::get_one('DynamicListItem', "\"ListID\" = {$this->ID} AND \"Title\" = '{$SQL_title}'"); if (!$item || !$item->exists()) { // create item $item = new DynamicListItem(); $item->ListID = $this->ID; $item->Title = $title; $item->write(); } return $item; }