public function readNames()
{
$member = UserPersonalInfo::model()->findAll();
foreach ($member as $m) {
$GLOBALS['Names'][strtolower(trim($m->first_name))] = ' ';
$GLOBALS['Names'][strtolower(trim($m->last_name))] = ' ';
}
}
public function saveMemberInfo($data)
{
$user_info = new Users();
$user_info = Users::model()->findByPk($data->getProperty('id'));
if ($user_info == null) {
$user_info = new Users();
$user_info->id = $data->getProperty('id');
$user_info->email = $data->getProperty('id') . '@qea.it';
$user_info->nickname = $data->getProperty('id');
$user_info->validate();
$user_info->save();
}
$user_info->usersPersonalInfo = UserPersonalInfo::model()->findByPk($data->getProperty('id'));
if ($user_info->usersPersonalInfo == null) {
$user_info->usersPersonalInfo = new UserPersonalInfo();
}
$user_info->usersPersonalInfo->user_id = $data->getProperty('id');
$names = str_word_count($data->getProperty('name'), 1);
if (count($names) > 2) {
$user_info->usersPersonalInfo->first_name = $names[0] . ' ' . $names[1];
$user_info->usersPersonalInfo->last_name = $names[2];
} else {
if (isset($names[0])) {
$user_info->usersPersonalInfo->first_name = $names[0];
}
if (isset($names[1])) {
$user_info->usersPersonalInfo->last_name = $names[1];
}
}
$user_info->usersPersonalInfo->validate();
$user_info->usersPersonalInfo->save();
}
public function deleteDegreeInfo()
{
die;
$post = FbPost::model()->findAllByAttributes(array('exam_group_id' => '123811091057378'));
foreach ($post as $p) {
$comment = FbPostComment::model()->deleteAllByAttributes(array('ref_entity_id' => $p->fbpid));
$photo = PhotoFbPost::model()->deleteAllByAttributes(array('element_id' => $p->fbpid));
$like = LikeFbPost::model()->deleteAllByAttributes(array('ref_entity_id' => $p->fbpid));
}
$doc = FbDoc::model()->deleteAllByAttributes(array('exam_group_id' => '123811091057378'));
$files = FbFiles::model()->deleteAllByAttributes(array('exam_group_id' => '123811091057378'));
$post = FbPost::model()->deleteAllByAttributes(array('exam_group_id' => '123811091057378'));
$exam_group = ExamGroup::model()->deleteAllByAttributes(array('eid' => '123811091057378'));
$connection = Yii::app()->db;
$command = $connection->createCommand("SELECT * FROM member_exam_group where user_group_id = '123811091057378' and user_id not in (select user_id from member_exam_group where user_group_id != '123811091057378')and user_id not in (select user_id from qeanalysis.member_degree_group where user_group_id != '123811091057378')");
$row = $command->queryAll();
foreach ($row as $r) {
$user_personal_info = UserPersonalInfo::model()->deleteByPk($r['user_id']);
echo $r['user_id'];
$user = User::model()->deleteByPk($r['user_id']);
$member = MemberExamGroup::model()->deleteAllByAttributes(array('user_id' => $r['user_id'], 'user_group_id' => '123811091057378'));
}
// echo ' post: '. $post . ' user '. $user. ' personal info: '. $user_personal_info. ' '.$member ;
}
