Ejemplo n.º 1
0
 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';
 }
Ejemplo n.º 2
0
 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();
 }
Ejemplo n.º 3
0
    ?>
</label> <br>				
				<label>Numero di foto nei post: <?php 
    echo $n_total_photo_post_exam;
    ?>
</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);
Ejemplo n.º 4
0
 public function actionFillDb()
 {
     set_time_limit(0);
     ini_set('mysqli.reconnect', 'on');
     ini_set('mysql.connect_timeout', 400);
     // 		foreach (glob("C:/Users/fabio/git/qea/webapp/protected/vendors/qea/qa-include/*.php") as $filename)
     // 		{
     // 			inclde $filename;
     // 		}
     $tag = "";
     $criteria = new CDbCriteria();
     $criteria->condition = "post_type_l1 like '%useful%' AND post_type_l3 like '%si%' ";
     // 			$criteria->condition = "fbpid = 143370932459708";
     $posts = FbPost::model()->findAll($criteria);
     foreach ($posts as $p) {
         $blob_id = null;
         if ($this->addFakeName($p->author_id)) {
             $qa_user_id = $this->addAuthor($p->author_id);
         }
         if (is_array($qa_user_id)) {
             $qa_user_id = $qa_user_id[0];
         }
         // 				$tag =  str_replace("_baseline", "",$p->post_type_l2);
         // 				$tag =  str_replace("_", "-",$p->post_type_l2);
         //categories
         if (isset($p->degree_group_id)) {
             $category_id = $this->setSecondLevelCategory($p->degree_group_id, 1);
         } else {
             if (isset($p->exam_group_id)) {
                 $exam_group = ExamGroup::model()->findByPk($p->exam_group_id);
                 $course = Courses::model()->findByPk($exam_group->courses_id);
                 $parent = $this->setSecondLevelCategory($course->degree_id, 0);
                 $category_id = $this->setThirdLevelCategory($course->name, $parent);
                 // 				 	$exam_group = ExamGroup::model()->findByPk($p->exam_group_id);
                 // 				 	$course = Courses::model()->findByPk($exam_group->courses_id);
                 $tag = $course->name;
                 $tag = str_replace(" ", "-", $tag);
                 // 				 	$tag = $tag.",";
             }
         }
         $photo = PhotoFbPost::model()->findByAttributes(array('element_id' => $p->fbpid));
         if (isset($photo)) {
             $photo->medium = str_replace("/" . $photo->fid . "jpeg", "", $photo->medium);
             $blob_id = qa_upload_file($photo->medium, $photo->fid . 'jpeg');
         }
         $tag_hold = "";
         $substrmessage = substr($p->message, 0, 50);
         if (is_int(strpos($substrmessage, "["))) {
             for ($i = strpos($substrmessage, "[") + 1; $i < strlen($p->message); $i++) {
                 if ($p->message[$i] == "]") {
                     break;
                 }
                 $tag_hold = $tag_hold . $p->message[$i];
             }
             if ($tag == "") {
                 $tag = str_replace(" ", "-", $tag_hold);
             } else {
                 $tag = $tag . "," . str_replace(" ", "-", $tag_hold);
             }
         }
         $title = substr($p->message, 0, 100);
         $title = $title . "...";
         //posts
         if (qa_post_check_by_fb_id($p->fbpid) == null) {
             if ($blob_id != null) {
                 $p->message = '<p><img alt="" src="http://www.universitree.com/?qa=blob&amp;qa_blobid=' . $blob_id['blobid'] . '" style="height:250px;"><br>' . $p->message . '</p>';
                 //RIVEDI
                 $question_id = qa_post_create_with_data("Q", null, $title, $p->message, 'html', $p->created_time, $category_id, $tag, $qa_user_id);
                 qa_post_set_hidden($question_id, true);
             } else {
                 $question_id = qa_post_create_with_data("Q", null, $title, $p->message, '', $p->created_time, $category_id, $tag, $qa_user_id);
             }
             qa_post_create_fb_mapping($question_id, $p->fbpid);
             $this->addLikes($p->fbpid, $question_id);
             $this->addAnswer($p->fbpid, $question_id);
             //	$this->deletePost($p->fbpid);
         }
         // 				$comments = FbPostComment::model()->findAllByAttributes(array("ref_entity_id" => $p->fbpid));
         // 				foreach ($comments as $c){
         // 					if($this->addFakeName($c->author_id))
         // 					if(!$this->addAuthor($c->author_id))
         // 						echo "problemi di inconsistenza nei commenti";
         // 				}
         //inserire qui gli unset
         unset($blob_id);
         unset($qa_user_id);
         unset($category_id);
         unset($exam_group);
         unset($course);
         unset($photo);
         $p->post_type_l1 = "ut_base";
         $p->save();
     }
     //$this->deleteUselessPost();
 }
Ejemplo n.º 5
0
 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 ;
 }