public function deletepicture($post)
{
$pic_id = $post['pic_id'];
if ($pic_id != 0) {
Projectphotos::model()->deleteByPk($pic_id);
$status = array('success' => true);
$this->renderJSON($status);
}
}
public function actionJobdetails()
{
if (!Yii::app()->user->isGuest) {
$this->pageTitle = 'Handyman.com - Job Details';
$project_id = Yii::app()->Ini->v('pj_id');
//$criteria=new CDbCriteria();
//$criteria->condition = "project_id = '$project_id'";
$criteria = new CDbCriteria();
$criteria->condition = "project_id = '{$project_id}'";
$details = Projects::model()->findByAttributes(array('project_id' => $project_id));
if (count($details) > 0) {
$projectphotos = Projectphotos::model()->findAll($criteria);
$main_photo = Projectphotos::model()->findByAttributes(array('project_id' => $project_id, 'is_main' => '1'));
//$projectphotos = Projectphotos::model()->findByAttributes(array('project_id'=>$project_id));
if ($main_photo) {
$main_photo = Yii::app()->request->baseUrl . '/uploads/projectphotos/' . $main_photo->filename;
} else {
$main_photo = "http://www.justmail.in/platinum/images/work_noimage.jpg";
}
$this->render('project_details', array('project_id' => $details->project_id, 'homeowner_id' => $details->homeowner_id, 'project_type_name' => $this->getProjectTypeName($details->project_type_id), 'description' => $details->description, 'owner_name' => $this->getOwnerName($details->homeowner_id), 'start_date' => $details->start_date, 'status_for_project' => $details->status_for_project, 'time_frame' => $details->time_frame, 'owned_property' => $details->owned_property, 'date_added' => $details->date_added, 'state2' => $this->getStateByName($details->state_id), 'status_for_project' => $details->status_for_project, 'city' => $details->city, 'zipcode' => $details->zipcode, 'projectphotos' => $projectphotos, 'username' => $this->getOwnerUname($details->homeowner_id), 'main_photo' => $main_photo));
} else {
$this->redirect(Yii::app()->homeUrl . 'home/error');
}
} else {
$this->redirect(Yii::app()->homeUrl);
}
}
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;
}