public static function getRobotDataArray($rowSets) { $robotsData = array(); if (!empty($rowSets)) { foreach ($rowSets as $robotDataRow) { $robotDataRow['creators'] = RobotAssocsDB::getRobotAssocValuesBy('robotId', $robotDataRow['robotId'], "creatorId"); $robotData = new RobotData($robotDataRow); $robotId = $robotDataRow['robotId']; $robotData->setRobotId($robotId); array_push($robotsData, $robotData); } } return $robotsData; }
public function testInsertDuplicateRobotAssoc() { $myDB = DBMaker::create('botspacetest'); Database::clearDB(); $db = Database::getDB('botspacetest', 'C:\\xampp\\myConfig.ini'); $beforeCount = count(RobotAssocsDB::getRobotAssocsBy()); $robotAssocCopy = RobotAssocsDB::getRobotAssocsRowsBy('robotAssocId', 2); $robotAssocCopy = $robotAssocCopy[0]; $s1 = new RobotAssoc($robotAssocCopy); $dupRobotAssoc = RobotAssocsDB::addRobotAssoc($s1); $afterCount = count(RobotAssocsDB::getRobotAssocsBy()); $this->assertTrue(!empty($dupRobotAssoc->getError('robotAssocId')) && strcmp(Messages::getError('ROBOT_ASSOC_INVALID'), $s1->getError('robotAssocId')) == 0, 'It should have a robotAssocId error if the robot association is a duplicate'); $this->assertEquals($afterCount, $beforeCount, 'There should be no additional robot association entries after the insertion attempt'); }
public static function setProfileDataForUser($userId) { $retVal = false; if (empty($userId) || !is_numeric($userId)) { return $retVal; } $user = null; $userData = null; $skillAssocs = null; $userRobots = null; $users = UsersDB::getUsersBy('userId', $userId); if (count($users) > 0) { $user = $users[0]; if ($user->getErrorCount() != 0) { return $retVal; } $userDataArray = UserDataDB::getUserDataBy('userId', $userId); if (count($userDataArray) > 0) { $userData = $userDataArray[0]; } if ($userData->getErrorCount() != 0) { return $retVal; } $skillAssocs = SkillAssocsDB::getSkillAssocsBy('userDataId', $userData->getUserDataId()); foreach ($skillAssocs as $skillAssoc) { if ($skillAssoc->getErrorCount() != 0) { return $retVal; } } $robotAssocs = RobotAssocsDB::getRobotAssocsBy('creatorId', $userData->getUserDataId()); $userRobots = array(); foreach ($robotAssocs as $robotAssoc) { $robotArray = RobotDataDB::getRobotDataBy('robotId', $robotAssoc->getRobotId()); if (count($robotArray) > 0) { array_push($userRobots, $robotArray[0]); } } $_SESSION['user'] = $user; $_SESSION['userData'] = $userData; $_SESSION['skillAssocs'] = $skillAssocs; $_SESSION['userRobots'] = $userRobots; $retVal = true; } return $retVal; }
public static function getRobotAssocValuesBy($type = null, $value = null, $column) { $robotAssocsRows = RobotAssocsDB::getRobotAssocsRowsBy($type, $value); return RobotAssocsDB::getRobotAssocsValues($robotAssocsRows, $column); }
public static function newRobotData() { $robotData = null; $newRobotData = null; if ($_SERVER["REQUEST_METHOD"] == "POST") { $creatorIds = array(); foreach ($_POST['creatorNames'] as $creatorName) { $creatorArray = UserDataDB::getUserDataBy('user_name', $creatorName); if (count($creatorArray) >= 1) { $creator = $creatorArray[0]; array_push($creatorIds, $creator->getUserDataId()); } } $_POST['creators'] = $creatorIds; $robotData = new RobotData($_POST); } $_SESSION['robotData'] = $robotData; if (is_null($robotData) || $robotData->getErrorCount() != 0) { RobotDataView::showNew(); } else { $newRobotData = RobotDataDB::addRobotData($robotData); foreach ($robotData->getCreators() as $creatorId) { $robotAssoc = new RobotAssoc($robotData->getRobotId(), $creatorId); $newRobotAssoc = RobotAssocsDB::addRobotAssoc($robotAssoc); } if (!is_null($newRobotData) && $newRobotData->getErrorCount() == 0) { $_SESSION['robotData'] = $newRobotData; } HomeView::show(); } }