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 run()
{
DB::table('users')->delete();
DB::table('user_friend')->delete();
DB::table('friend_notifications')->delete();
DB::table('user_personalInfo')->delete();
DB::table('user_friendsInfo')->delete();
$user1 = User::create(array('email' => '*****@*****.**', 'password' => Hash::make('asdf123')));
$user2 = User::create(array('email' => '*****@*****.**', 'password' => Hash::make('asdf123')));
$details1 = UserPersonalInfo::create(array('user_id' => $user1->id, 'firstname' => 'Prateek', 'lastname' => 'Singh'));
$details2 = UserPersonalInfo::create(array('user_id' => $user2->id, 'firstname' => 'Member', 'lastname' => 'Singh'));
$details1->primary_email = $user1->email;
$details1->save();
$details2->primary_email = $user2->email;
$details2->save();
}
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 ;
}
$address = new \UserAddress();
$address->setField('city', 'Timisoara');
$address->setField('str', 'Borsec');
$addresses[] = $address;
$address = new \UserAddress();
$address->setField('city', 'New York');
$address->setField('str', 'Times Square');
$addresses[] = $address;
$address = new \UserAddress();
$address->setField('city', 'Munchen');
$address->setField('str', 'Leopold Strasse');
$addresses[] = $address;
$addresses->removeEntities(function ($entity) {
return $entity->getField('city') == 'Timisoara';
});
$user->setField('addresses', $addresses);
$personalInfo = new \UserPersonalInfo();
$personalInfo->setField('address', 'some fake address');
$personalInfo->setField('jobs', array('developer', 'cto'));
$credentials = new \UserCredentials();
$credentials->setField('email', '*****@*****.**');
$credentials->setField('password', $authApi->hashPassword('password'));
$user->setField('personalInfo', $personalInfo);
$user->setField('credentials', $credentials);
$newUser = $user;
$return = \UserMapper::save($user);
$newUser->setField('parentId', $return);
$newUser->setField('_id', null);
$newReturn = \UserMapper::save($newUser);
$foundUser = \UserMapper::get($newReturn->getField('_id'));
print_r($foundUser->toArray());
