</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));
$n_total_like_comments += $c->like_count;
public function saveGroupFiles($data, $group_id, $param)
{
$i = 0;
$files_element = $data->getProperty('data');
while ($files_element->getProperty($i) != null) {
$single_file_element = $files_element->getProperty($i);
$file = FbFiles::model()->findByPk($single_file_element->getProperty('id'));
if ($file == null) {
$file = new FbFiles();
}
$file->fbfid = $single_file_element->getProperty('id');
$file->download_link = $single_file_element->getProperty('download_link');
// $opts = array('http'=>array('header' => "User-Agent:MyAgent/1.0\r\n"));
// $context = stream_context_create($opts);
// $getted_file = file_get_contents($single_file_element->getProperty('download_link'),false,$context);
$getted_file = null;
if ($this->get_http_response_code($single_file_element->getProperty('download_link')) != "404") {
$getted_file = file_get_contents($single_file_element->getProperty('download_link'));
}
// $getted_file = file_get_contents($single_file_element->getProperty('download_link'));
$j = 0;
for ($j = strlen($file->download_link) - 1; $j >= 0; $j--) {
if ($file->download_link[$j] == '/') {
break;
}
}
$name = '';
for ($k = $j; $k < strlen($file->download_link); $k++) {
$name = $name . $file->download_link[$k];
}
$name = str_replace('/', '\\', $name);
$name = str_replace('%20', ' ', $name);
$final_path = Yii::getPathOfAlias('webroot') . '\\files_' . $param . $name;
$final_path = str_replace('/', '\\', $final_path);
if ($getted_file != null) {
file_put_contents($final_path, $getted_file);
} else {
$file->download_link = $file->download_link . ' [ROTTO]';
}
$file->local_path = $final_path;
$updated_datetime = DateTime::createFromFormat(DateTime::ISO8601, $single_file_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);
$file->updated_time = $updated_date;
if ($param == 'Exam') {
$file->exam_group_id = $group_id;
} else {
$file->degree_group_id = $group_id;
}
$this->saveMemberInfo($single_file_element->getProperty('from'));
$this->saveMember($single_file_element->getProperty('from'), $group_id, $param);
$file->author_id = $single_file_element->getProperty('from')->getProperty('id');
if ($single_file_element->getProperty('comments') != null) {
$this->saveComments($single_file_element->getProperty('comments'), $file->fbfid, 'Docs', $group_id, 'Exam', $session);
}
$file->validate();
$file->save();
$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 ;
}
