public function googleAction()
{
$request = $this->getRequest();
if (trim($request->getQuery('redirect'))) {
$_SESSION['redirect'] = trim($request->getQuery('redirect'));
}
$viewModel = new ViewModel();
$viewModel->setTerminal(true);
$response = $this->getResponse();
/* @var $googleLogin \User\Service\GoogleLogin */
require_once 'Google/Client.php';
require_once 'Google/Service/Oauth2.php';
require_once 'Google/Http/REST.php';
require_once 'Google/Http/Request.php';
require_once 'Google/Service/Resource.php';
require_once 'Google/Auth/OAuth2.php';
$config = $this->getServiceLocator()->get('Config');
$clientId = $config['login']['google']['clientId'];
$clientSecret = $config['login']['google']['clientSecret'];
$url = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on' ? 'https://' : 'http://';
$url .= $_SERVER['HTTP_HOST'] . '/user/signin/google';
$client = new \Google_Client();
$client->setApplicationName('MyFirstTest');
$client->setClientId($clientId);
$client->setClientSecret($clientSecret);
$client->setRedirectUri($url);
$client->setScopes(array('https://www.googleapis.com/auth/userinfo.email', 'https://www.googleapis.com/auth/plus.me'));
$error = $this->getRequest()->getQuery('error');
if ($error) {
echo '<script>window.close()</script>';
}
$code = $this->getRequest()->getQuery('code');
if ($code) {
$client->authenticate($code);
$_SESSION['access_token'] = $client->getAccessToken();
$redirect = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
header('Location: ' . filter_var($redirect, FILTER_SANITIZE_URL));
} else {
$authUrl = $client->createAuthUrl();
return $this->redirect()->toUrl(filter_var($authUrl, FILTER_SANITIZE_URL));
}
//TODO: xoa vi cam giac dau co can
if (isset($_SESSION['access_token'])) {
$client->setAccessToken($_SESSION['access_token']);
}
if ($client->isAccessTokenExpired()) {
$authUrl = $client->createAuthUrl();
return $this->redirect()->toUrl(filter_var($authUrl, FILTER_SANITIZE_URL));
}
//End TODO
if ($client->getAccessToken()) {
$oauth2 = new \Google_Service_Oauth2($client);
$userInfoPlus = $oauth2->userinfo->get();
$_SESSION['access_token'] = $client->getAccessToken();
if (!$userInfoPlus->getEmail()) {
echo '<script>window.opener.alert("Không tồn tại thông tin Email của tài khoản trên");window.close()</script>';
}
$arrResponse = array('email' => $userInfoPlus->getEmail(), 'name' => $userInfoPlus->getName());
$user = new User();
$userMapper = $this->getServiceLocator()->get('User\\Model\\UserMapper');
$serviceUser = $this->getServiceLocator()->get('User\\Service\\User');
if (!$serviceUser->authenticateGoogle($arrResponse['email'])) {
$user->setActive('1');
$user->setEmail($arrResponse['email']);
$user->setRole(\User\Model\User::ROLE_MEMBER);
$user->setFullName($arrResponse['name']);
$user->setCreatedDate(DateBase::getCurrentDate());
$user->setCreatedDateTime(DateBase::getCurrentDateTime());
$userMapper->save($user);
// check nếu user đó đã dc mời tham gia dự án sẽ gắn luôn nó với dự án
$projectUser = new \Work\Model\ProjectUser();
$projectUser->setUserEmail($user->getEmail());
$projectUser->setUserId($user->getId());
$projectUserMapper = $this->getServiceLocator()->get('\\Work\\Model\\ProjectUserMapper');
$projectUserMapper->updateUserId($projectUser);
$this->redirect()->toUrl($url);
} else {
// check nếu user đó đã dc mời tham gia dự án sẽ gắn luôn nó với dự án
$projectUser = new \Work\Model\ProjectUser();
$projectUser->setUserEmail($serviceUser->getUser()->getEmail());
$projectUser->setUserId($serviceUser->getUser()->getId());
$projectUserMapper = $this->getServiceLocator()->get('\\Work\\Model\\ProjectUserMapper');
$projectUserMapper->updateUserId($projectUser);
if (!$_SESSION['redirect']) {
return $this->redirect()->toUrl('/');
} else {
$redirect = $_SESSION['redirect'];
unset($_SESSION['redirect']);
return $this->redirect()->toUrl($redirect);
}
}
} else {
$this->redirect()->toUrl($client->createAuthUrl());
}
return $response;
}
public function addtoprojectAction()
{
$createdById = $this->getRequest()->getQuery('createdById');
$role = $this->getRequest()->getQuery('level', \Work\Model\ProjectUser::ACCESS_LEVEL_MANAGER);
if (!$createdById) {
echo 'phải điền param createdById';
die;
}
$dbSql = $this->getServiceLocator()->get('dbSql');
$dbAdapter = $this->getServiceLocator()->get('dbAdapter');
$select = $dbSql->select(['p' => \Work\Model\ProjectMapper::TABLE_NAME]);
$select->where(['createdById' => $createdById]);
$query = $dbSql->buildSqlString($select);
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
$projectUserMapper = $this->getServiceLocator()->get('\\Work\\Model\\ProjectUserMapper');
foreach ($rows as $row) {
$row = (array) $row;
$projectUser = new \Work\Model\ProjectUser();
$projectUser->setUserId($createdById);
$projectUser->setProjectId($row['id']);
if (!$projectUserMapper->isExisted($projectUser)) {
$projectUser->setAccessLevel($role);
$projectUser->setStatus(\Work\Model\ProjectUser::STATUS_ACTIVE);
$projectUser->setCreatedById($this->user()->getIdentity());
$projectUser->setCreatedDateTime(DateBase::getCurrentDateTime());
$projectUserMapper->save($projectUser);
echo '<b>Đã thêm vào dự án: </b>' . $row['name'] . '<br/>';
}
}
}
die;
}
