scripts/assign_initial_achievements.php - master - bear/opencorpora

scripts/assign_initial_achievements.php
204 строки7 KB
Dmitry Granovsky
require 5% for quality check (was 10%); more correct level in initial assignment
08 июн 2015, 16:45
08 июн 2015, 16:4590df410
<?php

if (php_sapi_name() == 'cli') {
    set_include_path(get_include_path().PATH_SEPARATOR.__DIR__
        .PATH_SEPARATOR.__DIR__.'/..');
    require_once("lib/header.php");
    require_once("lib/achievements_implementations.php");

    // $_SESSION['debug_mode'] = true;
    // calculating achievements & levels

    $bobr_levels = array(); // level => number of people
    $chameleon_levels = array();
    $dog_levels = array();
    $pooltypes = array();
    $maxdoge = 0;
    $maxdoge_user = 0;

    $users = sql_pe("SELECT user_id, user_reg FROM users;", array());
    foreach ($users as $row) {
        $user_id = $row['user_id'];
        $regdaysago = ceil((time() - (int)$row['user_reg']) / (60 * 60 * 24));

        print "User id {$user_id}\n";
        // bobr
        $r = sql_fetch_array(sql_query("SELECT COUNT(*) AS cnt FROM morph_annot_instances WHERE user_id = $user_id AND answer > 0"));

        $count = $r['cnt'];
        $level = 0;
        $progress = 0;
        $a = new BobrAchievement($user_id);
        $grades = $a->level_reqs;


        foreach ($grades as $level0 => $COUNT) {
            if ($count >= $COUNT) $level++;

            $check = $a->check_quality_restrictions($level);

            if ((isset($grades[$level0 + 1])
                && $count < $grades[$level0 + 1])
                || !$check) {

                $progress = ceil(
                    ($count - $COUNT) * 100 / ($grades[$level0 + 1] - $COUNT)
                );

                if ($count >= $COUNT && !$check) $level--;
                break;
            }
        }

        if ($progress < 0) $progress = 0;
        if ($progress > 100) $progress = 100;

        if (isset($bobr_levels[$level])) $bobr_levels[$level]++;
        else $bobr_levels[$level] = 1;
        $level > 20 && $level = 20;

        if ($level > 0) {
        	$r = sql_pe("INSERT INTO user_achievements
        		(user_id, achievement_type, level, progress, seen)
        		VALUES(:user, :type, :level, :progress, 0)
        		ON DUPLICATE KEY UPDATE
                level=VALUES(level), progress = VALUES(progress),
                seen=0",

        		array('user' => $user_id, 'type' => 'bobr',
        			 'level' => $level, 'progress' => $progress));
        }

        $r = (int)$r;
        print "bobr: did {$count} task(s), level {$level}, progress {$progress}\n";

        ///////////////////
        $res = sql_query("
            SELECT COUNT(instance_id)
            FROM morph_annot_instances
            LEFT JOIN morph_annot_samples
                USING (sample_id)
            LEFT JOIN morph_annot_pools
                USING (pool_id)
            WHERE user_id = $user_id
                AND answer > 0
            GROUP BY pool_type
            ORDER BY COUNT(instance_id) DESC
        ");

        $cnt = array();
        while ($r = sql_fetch_array($res))
            $cnt[] = $r[0];

        $a = new ChameleonAchievement($user_id);
        $clevels = $a->level_reqs;

        $level = 0;
        $progress = 0;
        if (!empty($cnt)) {

            $pooltypes[count($cnt)] += 1;

            foreach ($clevels as $level0 => $params) {
                list($types, $min) = $params;
                if (count($cnt) < $types) break;
                foreach (array_slice($cnt, 0, $types) as $num) {
                    if ($num < $min) break 2;
                }
                if (!$a->check_quality_restrictions($level + 1))
                    break;
                $level++;
            }

            if ($level && isset($clevels[$level])) {
            // means that next level can be achieved)
            list($types, $min) = $clevels[$level];
            $has_to_do = $min * $types;
            $did = array_sum(
                array_map(function($e) use ($min) {
                    return $e > $min ? $min : $e;
                }, array_slice($cnt, 0, $types)));

            $base_for_level = $clevels[$level - 1][0] * $clevels[$level - 1][1];
            $progress = ceil(($did - $base_for_level) * 100 / ($has_to_do - $base_for_level));
            //print "has to do $types of $min ($has_to_do), did $did, (($did - $base_for_level) * 100 / ($has_to_do - $base_for_level) = $progress%\n";
            }
        }

        if ($progress < 0) $progress = 0;
        if ($progress > 100) $progress = 100;

        if (isset($chameleon_levels[$level])) $chameleon_levels[$level]++;
        else $chameleon_levels[$level] = 1;
        $level > 20 && $level = 20;
        if ($level > 0) {
        	$r = sql_pe("INSERT INTO user_achievements
        		(user_id, achievement_type, level, progress, seen)
        		VALUES(:user, :type, :level, :progress, 0)
        		ON DUPLICATE KEY UPDATE level=VALUES(level), seen=0",

        		array('user' => $user_id, 'type' => 'chameleon',
        			 'level' => $level, 'progress' => $progress));
        }

        $r = (int)$r;
        print "chameleon: did ".count($cnt)." pool type(s), level {$level}, progress {$progress}\n";
		////////////////////////
        // doge
        if ($regdaysago < 16) continue;

        $res = sql_query("
	        SELECT MONTH(FROM_UNIXTIME(ts_finish)) AS month,
                   YEAR(FROM_UNIXTIME(ts_finish)) AS year
            FROM morph_annot_instances
            WHERE user_id=$user_id AND answer > 0
            GROUP BY year, month
	        HAVING COUNT(*) >= 50
            AND NOT (month = MONTH(NOW()) AND year = YEAR(NOW()))
	        ORDER BY year, month
	    ");
        $level = 0;
        $progress = 0;
        while ($r = sql_fetch_array($res))
            $level++;

        $res = sql_pe("
                SELECT MONTH(FROM_UNIXTIME(ts_finish)) AS month,
                   YEAR(FROM_UNIXTIME(ts_finish)) AS year, COUNT(*) as count
                FROM morph_annot_instances
                WHERE user_id=? AND answer > 0
                GROUP BY year, month
                HAVING month = MONTH(NOW()) AND year = YEAR(NOW())
                ORDER BY year, month", array($user_id));

            $res = $res[0];
            $progress = ceil($res['count'] * 100 / 50);
            if ($progress > 100) $progress = 100;

        if (isset($dog_levels[$level])) $dog_levels[$level]++;
        else $dog_levels[$level] = 1;
        $level > 20 && $level = 20;

        if ($level > 0) {
        	$r = sql_pe("INSERT INTO user_achievements
        		(user_id, achievement_type, level, progress, seen)
        		VALUES(:user, :type, :level, :progress, 0)
        		ON DUPLICATE KEY UPDATE level=VALUES(level), seen=0",

        		array('user' => $user_id, 'type' => 'dog',
        			 'level' => $level, 'progress' => $progress));
        }

        print "dog: $level month(s), level {$level}, progress {$progress}\n";
    }

    // aist
    sql_pe("insert ignore into user_achievements
        (user_id, achievement_type, level, progress, seen)
select user_id, 'aist', 0, 0, 0 from users;", array());

    // fish
    sql_pe("insert ignore into user_achievements (user_id, achievement_type, level, progress, seen)
select user_id, 'fish', 0, 0, 0 from users where user_team > 0;", array());

}