<?php 
require_once "new_table.php";
/* ВСЕ ПЕРЕПИСАТЬ ПО-человечески */
if ($_POST['stat_month_value']) {
    $array4 = implode(",", $_POST['stat_month_value']);
}
$add = $_POST['stat_month_value'] ? "Month(request.date) IN(" . $array4 . ")" : "true";
$worker = $_POST['workers_value_select'] ? "request.operatorid=" . $_POST['workers_value_select'] : "true";
//------------------------------------------------------
$iscander_docs = new Table("SELECT bookloan_value\r\nFROM `optional`\r\nLEFT JOIN `request` ON request.id = optional.requestid WHERE bookloan = 'Искандэр' AND {$add} AND {$worker}");
$docs_array[] = $iscander_docs->get_result_optional();
$kiparis_docs = new Table("SELECT bookloan_value\r\nFROM `optional`\r\nLEFT JOIN `request` ON request.id = optional.requestid WHERE bookloan = 'Кипарис' AND {$add} AND {$worker}");
$docs_array[] = $kiparis_docs->get_result_optional();
$pravovie_docs = new Table("SELECT bookloan_value\r\nFROM `optional`\r\nLEFT JOIN `request` ON request.id = optional.requestid WHERE bookloan = 'Правовые' AND {$add} AND {$worker}");
$docs_array[] = $pravovie_docs->get_result_optional();
$consultations = new Table("SELECT count( * )\r\nFROM `optional`\r\nLEFT JOIN `request` ON request.id = optional.requestid WHERE consultations!='' AND {$add} AND {$worker} ");
$docs_array[] = $consultations->get_result();
//---------------------------------------------------
$test = new Table("SELECT count( * )\r\nFROM request WHERE {$add} AND {$worker}\r\nUNION ALL\r\nSELECT count( * )\r\nFROM request\r\nWHERE authorization = 'Читательский_Билет' AND {$add} AND {$worker}\r\nUNION ALL\r\nSELECT count( * )\r\nFROM request\r\nWHERE authorization \r\nIN (\r\n'Чат', 'Skype', 'Телефон', 'Email', 'Виртуальная_Служба'\r\n) AND {$add} AND {$worker}\r\nUNION ALL\r\nSELECT count( * )\r\nFROM `source`\r\nLEFT JOIN `request`\r\nON request.id=source.requestid\r\nWHERE `source-name` = 'Консультант' AND {$add} AND {$worker}\r\nUNION ALL\r\nSELECT count( * )\r\nFROM `source`\r\nLEFT JOIN `request`\r\nON request.id=source.requestid\r\nWHERE `source-name`\r\nIN (\r\n'Гарант', 'Закон-во Москвы', 'Закон-во России'\r\n) AND {$add} AND {$worker}\r\n\r\n ");
$arrow = $test->get_result();
if ($_POST['stat_month_value']) {
    $phrase = implode(",", $_POST['stat_month_value']);
    $healthy = array("01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12");
    $yummy = array("январь", "февраль", "март", "апрель", "май", "июнь", "июль", "август", "сентябрь", "октябрь", "ноябрь", "декабрь");
    $newphrase = str_replace($healthy, $yummy, $phrase);
} else {
    $newphrase = "все месяцы";
}