<?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 = "все месяцы"; }