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 }