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