?> </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); // array_push($total_photo_exam_comments, $photo_exam_comments); $comment_exam_like = LikeFbCommentPost::model()->findAllByAttributes(array('ref_entity_id' => $c->cid));
public function saveGroupDocs($data, $group_id, $param) { $i = 0; $group_doc_data = $data->getProperty('data'); while ($group_doc_data->getProperty($i) != null) { $group_doc_element = $group_doc_data->getProperty($i); $group_doc = FbDoc::model()->findByPk($group_doc_element->getProperty('id')); if ($group_doc == null) { $group_doc = new FbDoc(); } $group_doc->fbdid = $group_doc_element->getProperty('id'); $group_doc->message = $group_doc_element->getProperty('message'); $group_doc->subject = $group_doc_element->getProperty('subject'); $created_datetime = DateTime::createFromFormat(DateTime::ISO8601, $group_doc_element->getProperty('created_time')); $created_datetime->add(new DateInterval('PT1H')); $o = new ReflectionObject($created_datetime); $p = $o->getProperty('date'); $created_date = $p->getValue($created_datetime); $group_doc->created_time = $created_date; $updated_datetime = DateTime::createFromFormat(DateTime::ISO8601, $group_doc_element->getProperty('updated_time')); $updated_datetime->add(new DateInterval('PT1H')); $o = new ReflectionObject($updated_datetime); $p = $o->getProperty('date'); $updated_date = $p->getValue($updated_datetime); $group_doc->updated_time = $updated_date; if ($param == 'Exam') { $group_doc->exam_group_id = $group_id; } else { $group_doc->degree_group_id = $group_id; } $this->saveMemberInfo($group_doc_element->getProperty('from')); $this->saveMember($group_doc_element->getProperty('from'), $group_id, $param); $group_doc->author_id = $group_doc_element->getProperty('from')->getProperty('id'); $group_doc->validate(); $group_doc->save(); if ($group_doc_data->getProperty('comments') != null) { $this->saveComments($group_doc_element->getProperty('comments'), $group_doc->fbdid, 'Docs', $group_id, 'Exam', $session); } $i++; } }
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 ; }