public function deactivate($contractor_id)
{
$criteria = new CDbCriteria();
$criteria->condition = "user_type='contractor' AND userid=" . $contractor_id;
Affiliates::model()->deleteAll($criteria);
Referral::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "owner_user_type='contractor' AND owner_id=" . $contractor_id;
Answers::model()->deleteAll($criteria);
Questions::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "user_type='contractor' AND deleted_by=" . $contractor_id;
Messagedeleted::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "from_user_type='contractor' AND from_id=" . $contractor_id;
Messages::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "to_user_type='contractor' AND to_id=" . $contractor_id;
Messages::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "viewed_user_type='contractor' AND viewed_by=" . $contractor_id;
QuestionViews::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "referred_by_type='contractor' AND referred_by=" . $contractor_id;
Referral::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "invited_id=" . $contractor_id;
ContractorTeam::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "contractor_id=" . $contractor_id;
ContractorBond::model()->deleteAll($criteria);
ContractorLicense::model()->deleteAll($criteria);
ContractorPoints::model()->deleteAll($criteria);
ContractorSocials::model()->deleteAll($criteria);
ContractorTeam::model()->deleteAll($criteria);
ContractorViews::model()->deleteAll($criteria);
Contractorphotos::model()->deleteAll($criteria);
Feedback::model()->deleteAll($criteria);
$criteria = new CDbCriteria();
$criteria->condition = "ContractorId=" . $contractor_id;
self::model()->deleteAll($criteria);
return true;
}
public function actionContractor()
{
if (!Yii::app()->user->isGuest) {
if (Yii::app()->user->role == 'contractor') {
$this->pageTitle = 'Handyman.com - Contractor Dashboard';
$this->cities = Cities::model()->findAll(array('order' => 'RAND()', 'limit' => 10));
$contractor_id = Yii::app()->user->getId();
$model = Contractors::model()->findByPk($contractor_id);
$param['page'] = "dashboard";
$param['model'] = $model;
$criteria = new CDbCriteria();
$criteria->condition = "to_id={$contractor_id} and to_user_type='contractor'";
$param['message_count'] = Messages::model()->count($criteria);
$criteria2 = new CdbCriteria();
$criteria2->condition = "contractor_id = {$contractor_id}";
$param['views_count'] = ContractorViews::model()->count($criteria2);
$oneWeekAgo = date("Y-m-d H:i:s", strtotime("-1 months"));
$criteria3 = new CdbCriteria();
$criteria3->addBetweenCondition('date_added', $oneWeekAgo, date("Y-m-d H:i:s"));
$param['latest_project_count'] = Projects::model()->count($criteria3);
$param['from'] = $oneWeekAgo;
$param['to'] = date("Y-m-d H:i:s");
$param['points'] = 0;
$points = ContractorPoints::model()->findByAttributes(array('contractor_id' => $contractor_id));
if (count($points) > 0) {
$param['points'] = $points->points;
}
$team_invites = ContractorTeam::model()->findbyAttributes(array('invited_id' => $contractor_id, 'confirmed' => 0));
$param['team_invites'] = $team_invites;
$this->render('contractor', $param);
} else {
$this->redirect(Yii::app()->homeUrl);
}
} else {
$this->redirect(Yii::app()->homeUrl);
}
}
