case "3":
$x_axis = "mesci";
$y_axis = "prisotnost";
if (!$mon) {
/*$sql = "SELECT DATE( FROM_UNIXTIME( `end` ) ) datum, DATE_FORMAT( FROM_UNIXTIME( `end` ) , '%d' ) dan, `persons`.`first` ime, `persons`.`last` priimek, person_id
FROM `work_log` , `persons`
WHERE `persons`.`id_person` = `work_log`.`person_id`
AND persons.id_person = $person_id
AND DATE_FORMAT( FROM_UNIXTIME( `end` ) , '%Y %m' ) LIKE '".$year."%'
GROUP BY datum, person_id
ORDER BY dan desc";
$result = $db->fetchAll($sql);
*/
$dal = new DAL();
$result = $dal->get_presence_graph_by_person_year($person_id, $year);
$dnipri = count($result);
$prisotnost = round($dnipri / date_work_days($year, 11, "celo leto") * 100);
$out = '<set label ="prisotnost celotna " value="' . $prisotnost . '" /> ' . "\n";
$suffix = "%";
//po mescih//
unset($pris_mesec);
$pris_mesec = array();
foreach ($result as $res) {
$datum = $res["datum"];
$datum_mesec = explode("-", $datum);
$datum_mesec = $datum_mesec[1];
$pris_mesec[$datum_mesec]++;
}
for ($x = 1; $x < 13; $x++) {
if ($x < 10) {
