<label>Numero di foto nei post: <?php echo $n_total_photo_post_exam; ?> </label> <br> <label>Numero di foto nei commenti: <?php echo $n_total_photo_exam_comments; ?> </label> <?php } else { $ref_id = $group->eid; $exam = ExamGroup::model()->findByPk($ref_id); $posts_exam = FbPost::model()->findAllByAttributes(array('exam_group_id' => $ref_id)); $exam_member = MemberExamGroup::model()->findAllByAttributes(array('user_group_id' => $ref_id)); // array_push($total_post_exam, $posts_exam); $docs_exam = FbDoc::model()->findAllByAttributes(array('exam_group_id' => $ref_id)); $files_exam = FbFiles::model()->findAllByAttributes(array('exam_group_id' => $ref_id)); foreach ($posts_exam as $pe) { $posts_exam_like = LikeFbPost::model()->findAllByAttributes(array('ref_entity_id' => $pe->fbpid)); // array_push($total_posts_exam_like, $posts_exam_like); $n_total_post_exam_like += count($posts_exam_like); $photos_exam_post = PhotoFbPost::model()->findAllByAttributes(array('element_id' => $pe->fbpid)); // array_push($total_photo_post_exam, $photos_exam_post); $n_total_photo_post_exam += count($photos_exam_post); $comments = FbPostComment::model()->findAllByAttributes(array('ref_entity_id' => $pe->fbpid)); foreach ($comments as $c) { array_push($total_exam_post_comment, $c); $photo_exam_comments = PhotoFbCommentPost::model()->findAllByAttributes(array('element_id' => $c->cid)); $n_total_photo_exam_comments += count($photo_exam_comments);
public function saveMember($user_info, $group_id, $param) { if ($param == 'Degree') { $member = MemberDegreeGroup::model()->findByPk(array('user_id' => $user_info->getProperty('id'), 'user_group_id' => $group_id)); } else { if ($param == 'Exam') { $id = $user_info->getProperty('id'); $member = MemberExamGroup::model()->findByPk(array('user_id' => $id, 'user_group_id' => $group_id)); } } if ($member == null) { $class = new ReflectionClass('Member' . $param . 'Group'); $member = $class->newInstanceArgs(); } $member->user_id = $user_info->getProperty('id'); $member->user_group_id = $group_id; $member->validate(); $member->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 ; }