public function actionProfile()
{
$username = Yii::app()->Ini->v('user');
$current_user_id = 0;
$current_user_role = 0;
$model = Homeowners::model()->findByAttributes(array('username' => $username));
if (count($model) > 0) {
if (!Yii::app()->user->isGuest) {
$current_user_id = Yii::app()->user->getId();
$current_user_role = Yii::app()->user->role;
}
$criteria = new CDbCriteria();
$criteria->condition = "homeowner_id = " . $model->homeowner_id;
$criteria->limit = 8;
$this->pageTitle = 'Handyman.com - Homeowner - ' . $model->firstname . ' ' . $model->lastname . ' Profile';
$this->render('homeowner-profile', array('model' => $model, 'projects' => Projects::model()->findAll($criteria), 'current_user_id' => $current_user_id, 'current_user_role' => $current_user_role));
//update views
if (!Yii::app()->user->isGuest) {
$userid = Yii::app()->user->getId();
$role = Yii::app()->user->role;
$views = HomeownerViews::model()->findByAttributes(array('viewed_by' => $userid, 'homeowner_id' => $model->homeowner_id, 'viewed_user_type' => $role));
if (count($views) > 0) {
} else {
$views = new HomeownerViews();
$views->homeowner_id = $model->homeowner_id;
$views->viewed_by = $userid;
$views->viewed_user_type = $role;
$views->save();
}
}
} else {
$this->redirect(Yii::app()->homeUrl . 'home/error');
}
}
public function deactivate($homeowner_id)
{
$criteria = new CDbCriteria();
$criteria->condition = "user_type='homeowner' AND userid=" . $homeowner_id;
Affiliates::model()->deleteAll($criteria);
Referral::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "owner_user_type='homeowner' AND owner_id=" . $homeowner_id;
Answers::model()->deleteAll($criteria);
Questions::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "user_type='homeowner' AND deleted_by=" . $homeowner_id;
Messagedeleted::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "from_user_type='homeowner' AND from_id=" . $homeowner_id;
Messages::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "to_user_type='homeowner' AND to_id=" . $homeowner_id;
Messages::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "project_id NOT IN (Select project_id from projects where homeowner_id = {$homeowner_id} )";
Projectphotos::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "viewed_user_type='homeowner' AND viewed_by=" . $homeowner_id;
QuestionViews::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "referred_by_type='homeowner' AND referred_by=" . $homeowner_id;
Referral::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "homeowner_id=" . $homeowner_id;
HomeownerPoints::model()->deleteAll($criteria);
Feedback::model()->deleteAll($criteria);
HomeownerViews::model()->deleteAll($criteria);
Projects::model()->deleteAll($criteria);
self::model()->deleteAll($criteria);
return true;
}
