private function groupQuery()
{
set_time_limit(0);
$exam_group = ExamGroup::model()->findByAttributes(array("update_time" => null));
$exam_groups = array($exam_group);
if (!isset($exam_group)) {
$degree_group = DegreeGroup::model()->findByAttributes(array("update_time" => null));
if (!isset($degree_group)) {
$criteria = new CDbCriteria();
$criteria->limit = 3;
$criteria->order = "update_time ASC";
$exam_groups = ExamGroup::model()->findAll($criteria);
}
}
$fbController = new FbController();
foreach ($exam_groups as $eg) {
if (isset($eg)) {
$fbController->examin_exam_group($eg->eid);
}
}
$degree_groups = array($degree_group);
if (!isset($degree_group)) {
$criteria = new CDbCriteria();
$criteria->limit = 3;
$criteria->order = "update_time ASC";
$degree_groups = DegreeGroup::model()->findAll($criteria);
}
$fbController = new FbController();
foreach ($degree_groups as $dg) {
if (isset($dg)) {
$fbController->examin_degree_group($dg->cid);
}
}
echo 'ENDED';
}
public function saveExamGroupInfo($data, $course_id)
{
$group = ExamGroup::model()->findByPk($data->getProperty('id'));
if ($group == null) {
$group = new ExamGroup();
}
$course = new Courses();
$course = Courses::model()->findByPk($course_id);
$group->eid = $data->getProperty('id');
$group->name = $data->getProperty('name');
//$datetime->add(new DateInterval('PT1H'));
$group->email = $data->getProperty('email');
if (null != $data->getProperty('owner')) {
$group->owner_id = $data->getProperty('owner')->getProperty('id');
$this->saveMemberInfo($data->getProperty('owner'));
$this->saveGroupMember($data->getProperty('owner'), $data->getProperty('id'), 'Exam');
}
$group->description = $data->getProperty('description');
$group->courses_id = $course_id;
if (isset($course)) {
$group->degree_id = $course->degree_id;
}
$degreeGroup = DegreeGroup::model()->findByAttributes(array('degree_id' => $course->degree_id));
if ($degreeGroup != null) {
$group->degree_group_id = $degreeGroup->cid;
}
$group->save();
}
$n_files_degree = 0;
$n_docs_degree = 0;
$n_post_degree = 0;
$n_member = 0;
$n_exam_group_created = 0;
$n_total_post_exam = 0;
$n_total_post_exam_like = 0;
$n_total_photo_post_exam = 0;
$n_total_exam_post_comment = 0;
$n_total_photo_exam_comments = 0;
$n_total_like_comments = 0;
$n_total_exam_files = 0;
$n_total_exam_docs = 0;
if (is_a($group, 'DegreeGroup')) {
$ref_id = $group->cid;
$find_group = DegreeGroup::model()->findByPk($group->cid);
$posts_degree = FbPost::model()->findAllByAttributes(array('degree_group_id' => $group->cid));
$docs_degree = FbDoc::model()->findAllByAttributes(array('degree_group_id' => $group->cid));
$files_degree = FbFiles::model()->findAllByAttributes(array('degree_group_id' => $group->cid));
foreach ($docs_degree as $doc) {
$docs_like = LikeFbDoc::model()->findByAttributes(array('ref_entity_id' => $doc->fbdid));
$n_total_like_docs += count($docs_like);
// array_push($total_like_docs_degree, $docs_like);
}
$exam_group_created = ExamGroup::model()->findAllByAttributes(array('degree_group_id' => $group->cid));
$member = MemberDegreeGroup::model()->findAllByAttributes(array('user_group_id' => $group->cid));
foreach ($posts_degree as $p) {
$photos = PhotoFbPost::model()->findAllByAttributes(array('element_id' => $p->fbpid));
$n_photos_posts_degree += count($photos);
// array_push($total_photos_degree_post, $photos);
$like_post_degree = LikeFbPost::model()->findAllByAttributes(array('ref_entity_id' => $p->fbpid));
public function setSecondLevelCategory($degree_group_id, $type)
{
if ($type) {
$degree_group = DegreeGroup::model()->findByPk($degree_group_id);
//$first_level_id = $this->setFirstLevelCategory($degree_group->city);
$first_level_id = $this->setFirstLevelCategory($degree_group->degree_id);
$degree = Degree::model()->findByPk($degree_group->degree_id);
} else {
$first_level_id = $this->setFirstLevelCategory($degree_group_id);
$degree = Degree::model()->findByPk($degree_group_id);
}
$category_id = qa_db_category_slug_to_id($first_level_id, $degree->name);
if (!isset($category_id)) {
$category_id = qa_db_category_create($first_level_id, $degree->name, $degree->name);
}
return $category_id;
}
public function groupInfo($id)
{
$comment_number = 0;
$like_number = 0;
$photo_number = 0;
$type_group = '';
$group = ExamGroup::model()->findByPk($id);
$criteria = new CDbCriteria();
$criteria->condition = 'created_time >= "2013-09-01 00:00:00" and created_time <= "2014-08-31 00:00:00"';
$criteria2 = new CDbCriteria();
$criteria2->condition = 'updated_time >= "2013-09-01 00:00:00" and updated_time <= "2014-08-31 00:00:00"';
if ($group == null) {
$group = DegreeGroup::model()->findByPk($id);
$type_group = 'degree';
$post = FbPost::model()->findAllByAttributes(array('degree_group_id' => $id), $criteria);
$doc = FbDoc::model()->findAllByAttributes(array('degree_group_id' => $id), $criteria);
$criteria2 = new CDbCriteria();
$criteria2->condition = 'updated_time >= "2013-09-01 00:00:00" and updated_time <= "2014-08-31 00:00:00"';
$files = FbFiles::model()->findAllByAttributes(array('degree_group_id' => $id), $criteria2);
$member = MemberDegreeGroup::model()->findAllByAttributes(array('user_group_id' => $id));
} else {
$type_group = 'exam';
$post = FbPost::model()->findAllByAttributes(array('exam_group_id' => $id), $criteria);
$doc = FbDoc::model()->findAllByAttributes(array('exam_group_id' => $id), $criteria);
$files = FbFiles::model()->findAllByAttributes(array('exam_group_id' => $id), $criteria2);
$member = MemberExamGroup::model()->findAllByAttributes(array('user_group_id' => $id));
}
$comment_like = 0;
foreach ($post as $p) {
$comment = FbPostComment::model()->findAllByAttributes(array('ref_entity_id' => $p->fbpid), $criteria);
$comment_number += count($comment);
if ($comment != null) {
foreach ($comment as $c) {
$comment_like += $c->like_count;
}
}
$photo = PhotoFbPost::model()->findAllByAttributes(array('element_id' => $p->fbpid));
$photo_number += count($photo);
$like = LikeFbPost::model()->findAllByAttributes(array('ref_entity_id' => $p->fbpid));
$like_number += count($like);
}
?>
<div class=".col-md-8" style="background-color: rgb(184, 181, 181)">
<table class="table table-bordered">
<thead>
<tr>
<th >Nome</th>
<th>N. membri</th>
<th>N. post</th>
<th>N. Like ai post</th>
<th>N. Commenti</th>
<th>N. like commenti</th>
<th>N. files</th>
<th>N. docs</th>
<th>N.photos post</th>
</tr>
</thead>
<tbody>
<tr>
<td><?php
echo $group->name;
?>
</td>
<td><?php
echo count($member);
?>
</td>
<td><?php
echo count($post);
?>
</td>
<td><?php
echo $like_number;
?>
</td>
<td><?php
echo $comment_number;
?>
</td>
<td><?php
echo $comment_like;
?>
</td>
<td><?php
echo count($files);
?>
</td>
<td><?php
echo count($doc);
?>
</td>
<td><?php
echo $photo_number;
?>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<?php
}
