1. PHP / Говнокод #7120

    +145

    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    6. 06
    7. 07
    8. 08
    9. 09
    10. 10
    11. 11
    12. 12
    13. 13
    14. 14
    15. 15
    16. 16
    17. 17
    18. 18
    19. 19
    20. 20
    21. 21
    22. 22
    23. 23
    24. 24
    25. 25
    26. 26
    27. 27
    28. 28
    29. 29
    30. 30
    31. 31
    32. 32
    33. 33
    34. 34
    35. 35
    36. 36
    37. 37
    38. 38
    39. 39
    40. 40
    41. 41
    42. 42
    43. 43
    44. 44
    45. 45
    46. 46
    47. 47
    48. 48
    49. 49
    50. 50
    51. 51
    52. 52
    53. 53
    54. 54
    55. 55
    56. 56
    57. 57
    58. 58
    59. 59
    60. 60
    61. 61
    62. 62
    63. 63
    64. 64
    65. 65
    66. 66
    67. 67
    68. 68
    69. 69
    70. 70
    71. 71
    72. 72
    73. 73
    74. 74
    75. 75
    76. 76
    77. 77
    78. 78
    79. 79
    80. 80
    81. 81
    82. 82
    <?php

/* {{{ index */
function creative_stat_default()
{
    $dtime = urldecode(get_param('dtime', date('d.m.Y-d.m.Y')));

    list($begin_t, $end_t) = convert_date_calendar($dtime);

    $user = User::get_instance();
    $DB = DbSimple::getDb();

    $creatives_ids = $user->get_users_ids_by_roles(array('creative'));

    // user names
    $sql = " 
        SELECT user_id AS ARRAY_KEY, {$user->sql_case_names} as name
        FROM users
        WHERE user_id IN (?a)";

    $user_names = $DB->select($sql, $creatives_ids);

    // tasks all
    $sql = "
        SELECT to_user_id AS ARRAY_KEY, count(task_id) as tasks_all
        FROM creative_tasks 
        WHERE to_user_id IN (?a) AND dtime BETWEEN ?d AND ?d
        GROUP BY to_user_id
        ";

    $tasks = $DB->select($sql, $creatives_ids, $begin_t, $end_t);

    // tasks done
    $sql = "
        SELECT to_user_id AS ARRAY_KEY, count(task_id) as tasks_done
        FROM creative_tasks
        WHERE to_user_id IN (?a) AND dtime BETWEEN ?d AND ?d AND status_id = ?d
        GROUP BY to_user_id
        ";

    $tasks_done = $DB->select($sql, $creatives_ids, $begin_t, $end_t, GOODS_STATUS_ACTIVE);

    // goods all
    $sql = "
        SELECT creatives_id AS ARRAY_KEY, count(good_id) as goods_all
        FROM goods
        WHERE creatives_id IN (?a) AND date_create BETWEEN ?d AND ?d
        GROUP BY creatives_id
        ";

    $goods_all = $DB->select($sql, $creatives_ids, $begin_t, $end_t);

    // goods active
    $sql = "
        SELECT creatives_id AS ARRAY_KEY, count(good_id) as goods_active
        FROM goods
        WHERE creatives_id IN (?a) AND date_create BETWEEN ?d AND ?d AND status_id = ?d
        GROUP BY creatives_id
        ";

    $goods_active = $DB->select($sql, $creatives_ids, $begin_t, $end_t, GOODS_STATUS_ACTIVE);

    foreach($creatives_ids as $id) {
        $stat[$id] = array_merge(
            $user_names[$id], 
            isset($tasks[$id]) ? $tasks[$id] : array('tasks_all' => 0),
            isset($tasks_done[$id]) ? $tasks_done[$id] : array('tasks_done' => 0),
            array(
                'tasks_not_ready' => (isset($tasks[$id]['tasks_all']) ? $tasks[$id]['tasks_all'] : 0) - 
                    (isset($tasks_done[$id]['tasks_done']) ? $tasks_done[$id]['tasks_done'] : 0)),
            isset($goods_all[$id]) ? $goods_all[$id] : array('goods_all' => 0),
            isset($goods_active[$id]) ? $goods_active[$id] : array('goods_active' => 0)
        );
    }

    render_tpl('creative/stat/index', array(
        'header'    => 'Статистика креатива',
        'dtime'     => $dtime,
        'stat'      => $stat
    ), 'creative#stat');
}
/* }}} */

    Собираю статистику. Каждый запрос возвращает массив с ключем = id пользователя, дальше это все клеится в один массив для отображения в табличке.

    Запостил: Nicklasos, 30 Июня 2011

    Комментарии (11) RSS

    Добавить комментарий