?>
</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 ;
}
