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)); }