Latest Login
</th>
<th>
Created On
</th>
</tr>
</thead>
<tbody>
<?php
$count = 0;
foreach ($guests as $guests) {
?>
<tr>
<td>
<?php
echo $guests['firstname'] . " " . $guests['lastname'] . " (" . UserAccessTable::accessLevelToString($guests['access']) . ")";
?>
</td>
<td>
<?php
echo $guests['property']['property_name'];
?>
</td>
<td>
<?php
echo $guests['email'];
?>
</td>
<td>
<?php
echo $guests['property']['property_phone'];
Latest Login
</th>
<th>
Created On
</th>
</tr>
</thead>
<tbody>
<?php
$count = 0;
foreach ($admins as $admin) {
?>
<tr>
<td>
<?php
echo $admin['firstname'] . " " . $admin['lastname'] . " (" . UserAccessTable::accessLevelToString($admin['access']) . ")";
?>
</td>
<td>
<?php
echo $admin['property']['property_name'];
?>
</td>
<td>
<?php
echo $admin['email'];
?>
</td>
<td>
<?php
echo $admin['property']['property_phone'];
protected function getAllProperties()
{
$propertiesModel = new \User2property();
$userId = Yii::app()->user->getState('id');
$propertiesLinks = $propertiesModel->with('property')->findAllByAttributes(array('userId' => $userId));
//Delete deleted properties
foreach ($propertiesLinks as $key => $link) {
if ($link->property->getAttribute('isdeactivated') == 1) {
unset($propertiesLinks[$key]);
}
}
//Formating data
foreach ($propertiesLinks as $key => $propertiLink) {
$this->properties[$key] = $propertiLink->getAttributes();
$this->properties[$key]['property'] = $propertiLink->property->getAttributes();
$this->properties[$key]['property']['members'] = array();
$this->properties[$key]['property']['guests'] = array();
foreach ($propertiLink->property->user2properties as $index => $link) {
if ($link->getAttribute('access') <= \UserAccessTable::BASIC_ACCESS) {
$this->properties[$key]['property']['members'][$index] = $link->getAttributes();
} else {
$this->properties[$key]['property']['guests'][$index] = $link->getAttributes();
}
}
$this->properties[$key]['property']['members_count'] = count($this->properties[$key]['property']['members']);
$this->properties[$key]['property']['guests_count'] = count($this->properties[$key]['property']['guests']);
$galleryModel = new Gallery();
$primaryImage = $galleryModel->with('file')->findByAttributes(array('propertyid' => $this->properties[$key]['property']['id']), array('order' => 't.index'));
if ($primaryImage) {
$this->properties[$key]['property']['minimage'] = basePath('propertyfile/') . $primaryImage->file->getAttribute('systempath') . '?propertyid=' . $this->properties[$key]['property']['id'] . "&thumb=true";
$this->properties[$key]['property']['image'] = basePath('propertyfile/') . $primaryImage->file->getAttribute('systempath') . '?propertyid=' . $this->properties[$key]['property']['id'];
} else {
$this->properties[$key]['property']['minimage'] = basePath('images/property-placeholder.png');
$this->properties[$key]['property']['image'] = basePath('images/property-placeholder.png');
}
$this->properties[$key]['access_name'] = UserAccessTable::accessLevelToString($this->properties[$key]['access']);
}
}
Latest Login
</th>
<th>
Created On
</th>
</tr>
</thead>
<tbody>
<?php
$count = 0;
foreach ($members as $member) {
?>
<tr>
<td>
<?php
echo $member['firstname'] . " " . $member['lastname'] . " (" . UserAccessTable::accessLevelToString($member['access']) . ")";
?>
</td>
<td>
<?php
echo $member['property']['property_name'];
?>
</td>
<td>
<?php
echo $member['email'];
?>
</td>
<td>
<?php
echo $member['property']['property_phone'];
public function actionInviteGuestEmail($email = false)
{
$testData = array('data' => array('senderFullName' => "Dart Vaider", 'propertyName' => "Dead star", 'from' => "06/06/06 060606", 'to' => "07/07/07 070707", 'access' => UserAccessTable::accessLevelToString(UserAccessTable::GUEST), 'event' => "NewYear", 'message' => "hello !", 'userFullName' => 'Ilya Mineev', 'url' => "localhost/sfsdhuifg", 'token' => 'dgdfgdfgf', 'email' => '*****@*****.**', 'password' => 'pasw'), 'userFullName' => 'Ilya Mineev', 'url' => "localhost/sfsdhuifg", 'token' => 'dgdfgdfgf', 'email' => '*****@*****.**', 'password' => 'pasw');
if ($email != false) {
$emailBody = $this->renderPartial('InviteGuestEmail', $testData, true);
MailHelper::send($emailBody, "SharedKey.com", array($email));
$this->layout = 'app';
$this->render('index', array('text' => "Letter was sent to {$email}"));
} else {
$this->renderPartial('InviteGuestEmail', $testData);
}
}
public function actionInvite()
{
$newEvents = array();
$propertyId = Yii::app()->user->getState('propertyId');
if (isset($_POST['propId'])) {
if (is_numeric($_POST['propId'])) {
$propertyId = $_POST['propId'];
}
}
if (!Yii::app()->request->isPostRequest) {
echo json_encode(array('status' => 0, 'message' => 'Only Post request are allowed.'));
die;
}
if (!UserAccessTable::checkUser2PropertyAccess(Yii::app()->user->getState('id'), $propertyId, UserAccessTable::BASIC_ACCESS)) {
echo json_encode(array('status' => 0, 'message' => 'You can not do this action.'));
die;
}
//check login
if (Yii::app()->user->isGuest) {
echo json_encode(array('status' => 0, 'message' => 'Please login.'));
die;
}
if (!UserAccessTable::checkUser2PropertyAccess(Yii::app()->user->getState('id'), $propertyId, UserAccessTable::BASIC_ACCESS)) {
echo json_encode(array('status' => 0, 'message' => 'You can not do this action.'));
die;
}
$property = Properties::model()->findByPk($propertyId);
$model = new InviteGuest();
$model->setAttributes($_POST);
//create user 2 property tables
$u2propertyes = array();
foreach ($model->emails as $key => $value) {
$u2p = new User2property();
$user = User::model()->findByAttributes(array('email' => $value));
$newUserEmailBody = "";
if ($user == null) {
//need create new user
if (!filter_var($value, FILTER_VALIDATE_EMAIL)) {
continue;
}
$user = $this->createGuestUser($value, $model->names[$key], $propertyId);
$this->layout = "emailmaster";
$newUserEmailBody = $this->renderPartial('../emails/emailInviteNewGuest', array('userFullName' => $user->getAttribute('firstname') . ' ' . $user->getAttribute('lastname'), 'senderFullName' => Yii::app()->user->getState('firstname') . ' ' . Yii::app()->user->getState('lastname'), 'propertyName' => $property->getAttribute('property_name'), 'email' => $user->getAttribute('email'), 'access' => UserAccessTable::accessLevelToString(UserAccessTable::GUEST), 'password' => $user->getAttribute('password'), 'url' => basePathByHost('/')), true);
// MailHelper::send($newUserEmailBody, "SharedKey.com - New Member Account", array($user->getAttribute('email')));
} else {
//we can use exist user
}
$checku2p = User2property::model()->findByAttributes(array('propertyId' => $propertyId, 'userId' => $user->getAttribute('id')));
if ($checku2p != null) {
echo json_encode(array('status' => 0, 'message' => 'User is already a member of this property.'));
die;
}
$u2p->propertyId = $propertyId;
$u2p->userId = $user->getAttribute('id');
$u2p->access = UserAccessTable::GUEST;
$u2p->status = UserAccessTable::STATUS_ACTIVE;
$u2p->inviteDate = date('Y-m-d h:i:s');
$fromDate = null;
if (!empty($model->from)) {
$fromDate = new DateTime($model->from);
$u2p->fromDate = $fromDate->format('Y-m-d h:i:s');
} else {
$u2p->fromDate = null;
}
$toDate = null;
if (!empty($model->to)) {
$toDate = new DateTime($model->to);
$u2p->toDate = $toDate->format('Y-m-d h:i:s');
} else {
$u2p->toDate = null;
}
$u2p->inviteUserId = Yii::app()->user->getState('id');
$u2p->color = 'type13';
$u2p->bookingName = $model->names[$key];
$u2p->save();
$this->layout = "emailmaster";
$inviteEmail = $this->render('../emails/emailInvite', array('data' => array('fromName' => Yii::app()->user->getState('firstname') . ' ' . Yii::app()->user->getState('lastname'), 'propertyName' => $property->getAttribute('property_name'), 'from' => isset($fromDate) ? $fromDate->format('F j, Y') : '-', 'to' => isset($toDate) ? $toDate->format('F j, Y') : '-', 'access' => UserAccessTable::accessLevelToString(UserAccessTable::GUEST), 'event' => $model->event, 'message' => nl2br($model->message), 'toUser' => $user->getAttribute('firstname') . ' ' . $user->getAttribute('lastname'), 'newUserBody' => $newUserEmailBody)), true);
MailHelper::send($inviteEmail, "Sharedkey.com - Invitation to " . $property->getAttribute('property_name'), array($user->getAttribute('email')), "SharedKey.com", array(Yii::app()->user->getState('email')));
$u2propertyes[$key] = $u2p;
$username = $model->names[$key];
$calendarEvent = new Calendar();
$calendarEvent->create_date = $u2p->fromDate;
$calendarEvent->end_date = $u2p->toDate;
$calendarEvent->event = $_POST['event'];
$calendarEvent->propertyid = $u2p->propertyId;
$calendarEvent->notes = $model->message;
$calendarEvent->linkid = $this->linkWithProperty->id;
$calendarEvent->isguest = true;
$calendarEvent->guestid = $u2p->userId;
$calendarEvent->guestname = $model->names[$key];
$result = $calendarEvent->save();
$outputEvent = array("result" => true, "data" => (array) $calendarEvent->getAttributes(), "event" => $calendarEvent->event);
$outputEvent['data']['link'] = (array) $u2p->getAttributes();
array_push($newEvents, $outputEvent);
}
$users = array();
foreach ($u2propertyes as $key => $u2p) {
$users[$key] = $this->createViewItem($u2p);
}
echo json_encode(array('status' => 1, 'users' => $users, 'events' => $newEvents));
die;
}
public function actionDownloadCSV()
{
$type = $_GET['type'];
$csvpath = 'csv/';
$filename = $type . '_' . date('d-m-Y') . '.csv';
$fullname = $csvpath . $filename;
$headers = array();
$data = array();
switch ($type) {
case 'administratorspermonth':
$headers = array('date', 'count');
$data = Yii::app()->db->createCommand("SELECT DATE_FORMAT(u.createdDate, '%M %Y') AS mthyr , COUNT(DISTINCT u.id) AS count FROM users u INNER JOIN user2property up ON u.id = up.userId WHERE up.access = 5 GROUP BY DATE_FORMAT(u.createdDate, '%Y-%m')")->queryAll();
break;
case 'administrators':
$headers = array('name', 'username', '# of logins', 'latest login', 'created on', 'profile name', 'phone', 'city', 'prov', 'country');
$data = Yii::app()->db->createCommand("SELECT DISTINCT CONCAT_WS(' ', u.firstname, u.lastname) AS name, u.email, u.numoflogins, u.loginDate, u.createdDate, up.propertyId, up.access FROM users u INNER JOIN user2property up ON u.id = up.userId WHERE up.access= 5")->queryAll();
foreach ($data as $key => $admin) {
$prop = Yii::app()->db->createCommand("SELECT property_name, property_phone, city, state, country FROM properties where id = " . $admin['propertyId'])->queryRow();
$data[$key] = array_merge($data[$key], $prop);
$data[$key]['name'] = $data[$key]['name'] . ' (' . UserAccessTable::accessLevelToString($data[$key]['access']) . ')';
unset($data[$key]['propertyId']);
unset($data[$key]['access']);
}
break;
case 'guestspermonth':
$headers = array('date', 'count');
$data = Yii::app()->db->createCommand("SELECT DATE_FORMAT(u.createdDate, '%M %Y') AS mthyr , COUNT(DISTINCT u.id) AS count FROM users u INNER JOIN user2property up ON u.id = up.userId WHERE up.access = 30 GROUP BY DATE_FORMAT(u.createdDate, '%Y-%m')")->queryAll();
break;
case 'guests':
$headers = array('name', 'username', '# of logins', 'latest login', 'created on', 'profile name', 'phone', 'city', 'prov', 'country');
$data = Yii::app()->db->createCommand("SELECT DISTINCT CONCAT_WS(' ', u.firstname, u.lastname) AS name, u.email, u.numoflogins, u.loginDate, u.createdDate, up.propertyId FROM users u INNER JOIN user2property up ON u.id = up.userId WHERE up.access= 30")->queryAll();
foreach ($data as $key => $guest) {
$prop = Yii::app()->db->createCommand("SELECT property_name, property_phone, city, state, country FROM properties where id = " . $guest['propertyId'])->queryRow();
$data[$key] = array_merge($data[$key], $prop);
unset($data[$key]['propertyId']);
}
break;
case 'memberspermonth':
$headers = array('date', 'count');
$data = Yii::app()->db->createCommand("SELECT DATE_FORMAT(u.createdDate, '%M %Y') AS mthyr , COUNT(DISTINCT u.id) AS count FROM users u INNER JOIN user2property up ON u.id = up.userId WHERE up.access = 10 OR up.access = 20 GROUP BY DATE_FORMAT(u.createdDate, '%Y-%m')")->queryAll();
break;
case 'members':
$headers = array('name', 'username', '# of logins', 'latest login', 'created on', 'profile name', 'phone', 'city', 'prov', 'country');
$data = Yii::app()->db->createCommand("SELECT DISTINCT CONCAT_WS(' ', u.firstname, u.lastname) AS name, u.email, u.numoflogins, u.loginDate, u.createdDate, up.propertyId FROM users u INNER JOIN user2property up ON u.id = up.userId WHERE up.access= 10 OR up.access= 20")->queryAll();
foreach ($data as $key => $member) {
$prop = Yii::app()->db->createCommand("SELECT property_name, property_phone, city, state, country FROM properties where id = " . $member['propertyId'])->queryRow();
$data[$key] = array_merge($data[$key], $prop);
unset($data[$key]['propertyId']);
}
break;
case 'propertiescountsbymonth':
$headers = array('date', 'count');
$data = Yii::app()->db->createCommand("SELECT DATE_FORMAT(edt, '%M %Y') AS mthyr, COUNT(id) AS count FROM properties GROUP BY DATE_FORMAT(edt, '%Y-%m')")->queryAll();
break;
case 'propertiescountsusers':
$headers = array('# properies', 'count');
$res = Yii::app()->db->createCommand("SELECT COUNT(id) AS count FROM user2property GROUP BY userId ORDER BY count")->queryAll();
$group1 = $group2 = $group3 = $group4 = $group5 = 0;
foreach ($res as $proprtyCount) {
switch ($proprtyCount['count']) {
case "1":
$group1++;
break;
case "2":
$group2++;
break;
case "3":
$group3++;
break;
case "4":
$group4++;
break;
default:
$group5++;
}
}
$data = array(array("1 property", $group1), array("2", $group2), array("3", $group3), array("4", $group4), array("> 4", $group5));
break;
case 'properties':
$headers = array('profile name (access type)', 'city', 'prov/state', 'country', 'created on', 'property data');
$data = Yii::app()->db->createCommand("SELECT id, property_name, city, state, country, edt, isdeactivated FROM properties")->queryAll();
foreach ($data as $key => $prop) {
$activestr = $data[$key]['isdeactivated'] == 0 ? '(INACTIVE)' : '(ACTIVE)';
$data[$key]['property_name'] = $data[$key]['property_name'] . ' ' . $activestr;
$propId = $prop['id'];
//get property users
$users = Yii::app()->db->createCommand("SELECT CONCAT_WS(' ', u.firstname, u.lastname) AS name, up.access FROM user2property up INNER JOIN users u ON u.id = up.userId WHERE up.propertyId = {$propId}")->queryAll();
foreach ($users as $idx => $user) {
$user['name'] = $user['name'] . ' (' . UserAccessTable::accessLevelToString($user['access']) . ')';
$data[$key]['property_name'] = $data[$key]['property_name'] . ' ' . $user['name'];
}
//get property data
$photos = Yii::app()->db->createCommand("SELECT count(*) FROM propertyfile p WHERE p.property_id = {$propId}")->queryScalar();
$data[$key]['property_data'] = 'Photos: ' . $photos . ' ';
$events = Yii::app()->db->createCommand("SELECT count(*) FROM calendar ca WHERE ca.propertyid = {$propId}")->queryScalar();
$data[$key]['property_data'] = $data[$key]['property_data'] . ' Events: ' . $events . ' ';
$directions = Yii::app()->db->createCommand("SELECT count(*) FROM direction di WHERE di.property_id = {$propId}")->queryScalar();
$data[$key]['property_data'] = $data[$key]['property_data'] . ' Directions: ' . $directions . ' ';
$map = Yii::app()->db->createCommand("SELECT count(*) FROM property_attachments pa WHERE pa.property_id = {$propId}")->queryScalar();
$data[$key]['property_data'] = $data[$key]['property_data'] . ' Map attach: ' . $map . ' ';
$tourist = Yii::app()->db->createCommand("SELECT count(*) FROM touristinfo ti WHERE ti.property_id = {$propId}")->queryScalar();
$data[$key]['property_data'] = $data[$key]['property_data'] . ' Tourist info: ' . $tourist . ' ';
$rules = Yii::app()->db->createCommand("SELECT count(*) FROM houserules hr WHERE hr.property_id = {$propId}")->queryScalar();
$data[$key]['property_data'] = $data[$key]['property_data'] . ' Rules: ' . $rules . ' ';
$contacts = Yii::app()->db->createCommand("SELECT count(*) FROM keycontact WHERE property_id = {$propId}")->queryScalar();
$data[$key]['property_data'] = $data[$key]['property_data'] . ' Contacts: ' . $contacts . ' ';
$notices = Yii::app()->db->createCommand("SELECT count(*) FROM noticeboard nb WHERE nb.property_id = {$propId}")->queryScalar();
$data[$key]['property_data'] = $data[$key]['property_data'] . ' Notices: ' . $notices . ' ';
$guentries = Yii::app()->db->createCommand("SELECT count(*) FROM guestbook WHERE property_id = {$propId}")->queryScalar();
$data[$key]['property_data'] = $data[$key]['property_data'] . ' GU entries: ' . $guentries;
unset($data[$key]['id']);
unset($data[$key]['isdeactivated']);
}
break;
default:
Yii::app()->request->redirect(basePath('stats/index'));
}
$fp = fopen($fullname, 'w');
fputcsv($fp, $headers);
foreach ($data as $fields) {
fputcsv($fp, $fields);
}
fclose($fp);
if (file_exists($fullname)) {
return Yii::app()->getRequest()->sendFile($filename, @file_get_contents($fullname));
}
}
private function createViewItem($u2p)
{
$user = array();
$user['color'] = $u2p->getAttribute('color');
$user['fullName'] = $u2p->user->getAttribute('firstname') . ' ' . $u2p->user->getAttribute('lastname');
$date = $u2p->user->getAttribute('loginDate');
$dateTime = '';
if (isset($date)) {
$dateTime = new DateTime($date);
}
$user['lastLogin'] = isset($date) ? 'Last login ' . $dateTime->format('M j, Y h:i A') : 'Has never logged-in';
$user['firstname'] = $u2p->user->getAttribute('firstname');
$user['lastname'] = $u2p->user->getAttribute('lastname');
$user['bookingName'] = $u2p->bookingName;
$user['access'] = UserAccessTable::accessLevelToString($u2p->getAttribute('access'));
$user['accessInt'] = $u2p->getAttribute('access');
$user['status'] = UserAccessTable::statusToString($u2p->getAttribute('status'));
$user['statusInt'] = $u2p->getAttribute('status');
$user['email'] = $u2p->user->getAttribute('email');
$user['phone'] = $u2p->user->getAttribute('phone');
$user['can_delete'] = $u2p->user->getAttribute('email') != Yii::app()->user->getState('email');
$user['id'] = $u2p->getAttribute('id');
if ($u2p->getAttribute('access') == UserAccessTable::OWNER) {
$user['can_delete'] = false;
}
return $user;
}