public function actionUseradmin()
{
$user_id = Yii::app()->user->id;
$model = new Lead('search');
$model->unsetAttributes();
if (isset($_POST['property_exists'])) {
echo "hello";
$user_id = Yii::app()->user->id;
$sta = 1;
$sts = 2;
$stt = 3;
$stf = 4;
$p_id = $_POST['property_exists'];
Yii::app()->SESSION['p_id'] = $_POST['property_exists'];
$data = Yii::app()->db->createCommand('select m.propert_name, s.organisation_name,s.phone_1,s.email_id,s.message,s.id,s.enquiry_source,s.status,s.first_name from tbl_lead_fields s
join tbl_lead_users mr on mr.leads_id=s.id
join tbl_propery_details m on m.id=s.property_id
where mr.user_id="' . $user_id . '" and s.status="' . $sta . '" and s.property_id="' . $p_id . '"')->queryAll();
$inst = Yii::app()->db->createCommand('select m.propert_name, s.organisation_name,s.phone_1,s.email_id,s.message,s.id,s.enquiry_source,s.status,s.first_name from tbl_lead_fields s
join tbl_lead_users mr on mr.leads_id=s.id
join tbl_propery_details m on m.id=s.property_id
where mr.user_id="' . $user_id . '" and s.status="' . $sts . '" and s.property_id="' . $p_id . '"')->queryAll();
$instbn = Yii::app()->db->createCommand('select m.propert_name, s.organisation_name,s.phone_1,s.email_id,s.message,s.id,s.enquiry_source,s.status,s.first_name from tbl_lead_fields s
join tbl_lead_users mr on mr.leads_id=s.id
join tbl_propery_details m on m.id=s.property_id
where mr.user_id="' . $user_id . '" and s.status="' . $stt . '" and s.property_id="' . $p_id . '"')->queryAll();
$sad = Yii::app()->db->createCommand('select m.propert_name, s.organisation_name,s.phone_1,s.email_id,s.message,s.id,s.enquiry_source,s.status,s.first_name from tbl_lead_fields s
join tbl_lead_users mr on mr.leads_id=s.id
join tbl_propery_details m on m.id=s.property_id
where mr.user_id="' . $user_id . '" and s.status="' . $stf . '" and s.property_id="' . $p_id . '"')->queryAll();
} else {
$user_id = Yii::app()->user->id;
$sta = 1;
$sts = 2;
$stt = 3;
$stf = 4;
$data = Yii::app()->db->createCommand('select m.propert_name, s.organisation_name,s.phone_1,s.email_id,s.message,s.id,s.enquiry_source,s.status,s.first_name from tbl_lead_fields s
join tbl_lead_users mr on mr.leads_id=s.id
join tbl_propery_details m on m.id=s.property_id
where mr.user_id="' . $user_id . '" and s.status="' . $sta . '"')->queryAll();
$inst = Yii::app()->db->createCommand('select m.propert_name, s.organisation_name,s.phone_1,s.email_id,s.message,s.id,s.enquiry_source,s.status,s.first_name from tbl_lead_fields s
join tbl_lead_users mr on mr.leads_id=s.id
join tbl_propery_details m on m.id=s.property_id
where mr.user_id="' . $user_id . '" and s.status="' . $sts . '"')->queryAll();
$instbn = Yii::app()->db->createCommand('select m.propert_name, s.organisation_name,s.phone_1,s.email_id,s.message,s.id,s.enquiry_source,s.status,s.first_name from tbl_lead_fields s
join tbl_lead_users mr on mr.leads_id=s.id
join tbl_propery_details m on m.id=s.property_id
where mr.user_id="' . $user_id . '" and s.status="' . $stt . '"')->queryAll();
$sad = Yii::app()->db->createCommand('select m.propert_name, s.organisation_name,s.phone_1,s.email_id,s.message,s.id,s.enquiry_source,s.status,s.first_name from tbl_lead_fields s
join tbl_lead_users mr on mr.leads_id=s.id
join tbl_propery_details m on m.id=s.property_id
where mr.user_id="' . $user_id . '" and s.status="' . $stf . '"')->queryAll();
}
// clear any default values
if (isset($_GET['Lead'])) {
$model->attributes = $_GET['Lead'];
}
$this->render('admin', array('model' => $model, 'datamodel' => $data, 'insts' => $inst, 'instt' => $instbn, 'sads' => $sad));
}
