protected function execute(InputInterface $input, OutputInterface $output) { $isVerbose = $output->getVerbosity() >= OutputInterface::VERBOSITY_VERBOSE; $projectCode = $input->getOption('project-code'); $memberResource = new MemberResource($this->sourceClient); $page = 0; $perPage = 10; $maxPages = 1; $criteria = []; $data = []; while ($page < $maxPages) { $members = $memberResource->getList(++$page, $perPage, $this->getMemberCriteria(), [], [], ['project_code' => $projectCode, 'PII' => 1]); $maxPages = $members['pages']; // if no items, return if (!count($members['items']) || !$members['total']) { break; } foreach ($members['items'] as $key => $member) { if ($isVerbose) { $no = ($page - 1) * $perPage + $key + 1; $output->writeln("{$no} - Reading member #{$member['id']}"); } if ($this->checkAccept($member)) { // activate member $memberResource->setApplicantsStatus([$member['id']], 'accept', 'Accepted via API'); var_dump($member); if ($isVerbose) { $output->writeln("Accepting member #{$member['id']}"); } } } } }
protected function execute(InputInterface $input, OutputInterface $output) { $isVerbose = $output->getVerbosity() >= OutputInterface::VERBOSITY_VERBOSE; $projectCode = $input->getOption('project-code'); $enrollmentStatusCode = $input->getOption('enrollment-status-code'); $memberResource = new MemberResource($this->sourceClient); $page = 0; $perPage = 10; $maxPages = 1; $criteria = []; if ($enrollmentStatusCode) { $criteria['enrollment_status_code'] = $enrollmentStatusCode; } $data = []; while ($page < $maxPages) { $members = $memberResource->getList(++$page, $perPage, $criteria, [], [], ['project_code' => $projectCode]); $maxPages = $members['pages']; // if no items, return if (!count($members['items']) || !$members['total']) { break; } foreach ($members['items'] as $key => $member) { if ($isVerbose) { $no = ($page - 1) * $perPage + $key + 1; // $output->writeln("{$no} - Reading member #{$member['id']}"); } $data[] = ['code' => isset($member['code']) ? $member['code'] : '#' . $member['id'], 'email' => isset($member['email_within_project']) ? $member['email_within_project'] : '-', 'phone' => isset($member['phone_within_project']) ? $member['phone_within_project'] : '-', 'enrollment_status_code' => isset($member['enrollment_status_code']) ? $member['enrollment_status_code'] : '-']; } } $table = new Table($output); $table->setHeaders(['code', 'email', 'phone', 'enrollment_status_code'])->setRows($data); $table->render(); }
protected function processMessage($inData, $message) { if ($this->output->isVerbose()) { print json_encode($inData, JSON_PRETTY_PRINT) . "\n"; } $memberId = $inData->member_id; $action = $inData->action; $memberResource = new MemberResource($this->client); $response = $memberResource->setApplicantsStatus($memberId, $action); if ($this->output->isVerbose()) { print json_encode($response, JSON_PRETTY_PRINT) . "\n"; } return true; }
protected function execute(InputInterface $input, OutputInterface $output) { $projectResource = new ProjectResource($this->sourceClient); $memberResource = new MemberResource($this->sourceClient); $surveyResource = new SurveyResource($this->sourceClient); $result = $projectResource->getList(); foreach ($result['items'] as $idx => $project) { $projectCode = $project['code']; $result = $memberResource->getList(1, 1000, ['project_id' => $project['id'], 'permission_type_code' => 'owner']); $owners = implode(', ', array_map(function ($member) { return isset($member['code']) ? $member['code'] : '#' . $member['id']; }, $result['items'])); $result = $surveyResource->getList(1, 1000, ['project_id' => $project['id']]); $surveys = implode("\n", array_map(function ($survey) { return '"' . $survey['name'] . '"'; }, $result['items'])); $data[] = ['code' => $projectCode, 'owners' => $owners, 'surveys' => $surveys]; } $table = new Table($output); $table->setHeaders(['code', 'owners', 'surveys'])->setRows($data); $table->render(); }
protected function execute(InputInterface $input, OutputInterface $output) { $name = $input->getArgument('filename'); $projectResource = new ProjectResource($this->client); $userResource = new UserResource($this->client); $memberResource = new MemberResource($this->client); $reader = new \EasyCSV\Reader('new_members.csv'); while ($row = $reader->getRow()) { $project = $projectResource->getByCode($row['project_code']); // we ned that user for admins, maybe it should be separate field $user = $userResource->getOneBy(['username' => $row['username']]); if (!$user) { print "user '{$row['username']}' not found\n"; } try { $res = $memberResource->save(['code' => $row['code'], 'project_id' => $project['id'], 'user_id' => $user['id'], 'permission_type_code' => $row['permission_type_code']]); } catch (Exception $e) { print "Error importing member {$row['code']}:" . $e->getMessage() . "\n"; } } $output->writeln($text); }
protected function execute(InputInterface $input, OutputInterface $output) { $isVerbose = $output->getVerbosity() >= OutputInterface::VERBOSITY_VERBOSE; $sourceProject = $input->getOption('source-project-code'); $targetProject = $input->getOption('target-project-code'); $fromMemberResource = new MemberResource($this->sourceClient); $toMemberResource = new MemberResource($this->client); $projectResource = new ProjectResource($this->client); $userResource = new UserResource($this->client); $project = $projectResource->getOneBy(['code' => $targetProject]); if (!$project) { $output->writeln("<error>Target project {$targetProject} not found</error>"); die; } $page = 0; $perPage = 10; // $members = $fromMemberResource->getList($page, $perPage, [], [], [], ['project_code' => $sourceProject]); $maxPages = 1; while ($page < $maxPages) { $members = $fromMemberResource->getList(++$page, $perPage, [], [], [], ['project_code' => $sourceProject]); $maxPages = $members['pages']; // if no items, return if (!count($members['items']) || !$members['total']) { break; } foreach ($members['items'] as $key => $member) { if ($isVerbose) { $no = ($page - 1) * $perPage + $key + 1; $output->writeln("{$no} - Reading member #{$member['id']}"); } /* * try to find if member is already there * if yes - ignore. if not - import. * if current member doesn't have any of the $uniqueFields set * then ignore as we won't be able to find it later */ $uniqueFields = ['code', 'email_within_project', 'phone_within_project']; $findByField = false; $findByValue = false; foreach ($uniqueFields as $field) { if (isset($member[$field])) { $findByField = $field; $findByValue = $member[$field]; break; } } if ($findByField && $findByValue) { $findMember = $toMemberResource->getOneBy([$findByField => $findByValue, 'project_id' => $project['id']]); if ($findMember) { $output->writeln("<error>Member {$findByField}:{$findByValue} already exists for project {$project['code']}</error>"); continue; } } else { // ignore no-codes for now $output->writeln("<error>Member #{$member['id']} doesn't have any of the required fields: " . implode(',', $uniqueFields) . "</error>"); continue; } if (array_search($member['permission_type_code'], ['owner']) !== false) { // save admin only if user found // @todo - create user first $user = $userResource->getOneBy(['username' => $member['code']]); if (!$user) { $output->writeln("<error>Couldn't find user record for admin member {$member['code']} </error>"); continue; } $member['user_id'] = $user['id']; } $this->processMemberFields($member, $project); try { $res = $toMemberResource->save($member); if ($isVerbose) { $output->writeln("New member #{$res['id']} saved"); } } catch (\Exception $e) { $output->writeln("<error>Problem saving {$findByField}:{$findByValue}:{$e->getMessage()} </error>"); var_dump($member); } } } }
<?php require __DIR__ . '/../vendor/autoload.php'; use Survos\Client\SurvosClient; use Survos\Client\Resource\MemberResource; use Survos\Client\SurvosCriteria; $config = json_decode(file_get_contents(__DIR__ . '/config.json'), true); $client = new SurvosClient($config['endpoint']); if (!$client->authorize($config['username'], $config['password'])) { throw new \Exception('Wrong credentials!'); } $resource = new MemberResource($client); $filter = ['created_at' => '2015-09-16 18:40:23']; //OR 2015-09-16 $comparison = ['created_at' => SurvosCriteria::GREATER_THAN]; $data = $resource->getList(1, 100, $filter, $comparison); $items = $data['items'];
protected function execute(InputInterface $input, OutputInterface $output) { $filename = $input->getArgument('filename'); $serverCode = $input->getOption('server-code'); $timezoneId = $input->getOption('timezone-id'); $projectCode = $input->getOption('project-code'); $userResource = new UserResource($this->client); /** @type MemberResource $memberResource */ $memberResource = new MemberResource($this->client); $projectResource = new ProjectResource($this->client); /** @type ProjectResource $resource */ $resource = new ProjectResource($this->client); $reader = new \EasyCSV\Reader($filename, 'r', true); while ($row = $reader->getRow()) { //code,name,description,timezone_id $code = $row['code']; if ($projectCode && $code != $projectCode) { continue; } $params = []; if ($project = $resource->getOneBy(['code' => $code])) { $params['id'] = $project['id']; } try { /* $res = $resource->save( array_merge( $params, [ 'title' => $name = $row['name'], 'code' => $code, 'timezone_id' => $timezoneId, 'description' => $name." Project", 'background_server_code' => $serverCode, ] ) ); */ } catch (\Exception $e) { printf("Error saving project: %s\n", $e->getMessage()); printf("Project {$code} already exists\n"); } $project = $projectResource->getByCode($code); $res = $resource->addModule($code, 'turk'); $staffAdmins = ['tac', 'ho449']; try { foreach (array_merge([$code], $staffAdmins) as $idx => $username) { $user = $userResource->getOneBy(['username' => $username]); if (!$user) { print "user '{$username}' not found\n"; continue; } $params = ['code' => $username, 'project_id' => $project['id'], 'user_id' => $user['id'], 'permission_type_code' => 'owner', 'enrollment_status_code' => 'notenrolled']; $member = $memberResource->getOneBy(['code' => $username, 'project_id' => $project['id']]); if ($member) { $output->writeln("<error>Member '{$username}' already exists for project " . $project['code'] . "</error>"); continue; } print "Saving member '{$username}' for project " . $project['code'] . "\n"; $res = $memberResource->save($params); } } catch (Exception $e) { var_dump($params); $output->writeln("<error>Error importing member: {$e->getMessage()}</error>"); } } }
<?php require __DIR__ . '/../vendor/autoload.php'; use Survos\Client\SurvosClient; use Survos\Client\Resource\MemberResource; $config = json_decode(file_get_contents(__DIR__ . '/config.json'), true); $client = new SurvosClient($config['endpoint']); if (!$client->authorize($config['username'], $config['password'])) { throw new \Exception('Wrong credentials!'); } $resource = new MemberResource($client); $data = $resource->getList(1, 100, ['enrollment_status_code' => 'applicant']); $applicants = $data['items']; foreach ($applicants as $applicant) { $id = $applicant['id']; if (isEligible($applicant)) { $resource->setApplicantsStatus($id, 'accept', null, 'qualified by age'); } else { $resource->setApplicantsStatus($id, 'reject', null, 'Sorry, you don\'t qualify'); } } function isEligible($applicant) { return isset($applicant['submitted']) && $applicant['submitted']['age'] < 21; }
<?php require __DIR__ . '/../vendor/autoload.php'; use Survos\Client\SurvosClient; use Survos\Client\Resource\MemberResource; use Survos\Client\Resource\ProjectResource; $config = json_decode(file_get_contents(__DIR__ . '/config.json'), true); $client = new SurvosClient($config['endpoint']); if (!$client->authorize($config['username'], $config['password'])) { throw new \Exception('Wrong credentials!'); } // get all projects $userResource = new \Survos\Client\Resource\UserResource($client); //$user= $userResource->getOneBy('username', 'tac'); $pResource = new ProjectResource($client); $project = $pResource->getByCode('demo'); $resource = new MemberResource($client); $resource->save(['code' => "new_project_code5", 'phone_within_project' => '+447834274472', 'email_within_project' => '*****@*****.**', 'project_id' => $project['id']]); $res = $pResource->addModule('demo', 'field'); echo $res;