$user_first_low = str_lower($user_first); /////// //pridobi priimek prijavljenega uporabnika in spremeni sumnike v brez sumnikov $sql_temp = "SELECT last FROM persons where username='******'"; $user_last = $db->fetchOne($sql_temp); $user_last_sumniki = $user_last; $user_last = str_sumniki($user_last); $user_last_low = str_lower($user_last); /////////// //pridobi ime enote in spremeni sumnike v brez sumnikov $sql_temp = "SELECT name FROM unit, persons where unit.persons_unit=persons.unit and persons.username='******'"; $user_unit = $db->fetchOne($sql_temp); $user_unit = str_sumniki($user_unit); /////////// $message_sumnik = 'Mesečno poročilo evidence prisotnosti zaposlenih na: "' . $user_unit . '" je zaključeno http://192.168.50.2/intranet/view_user_month.php'; $message = str_sumniki(message_sumnik); // $to = '*****@*****.**'; $to = '*****@*****.**'; //'*****@*****.**'; //tega pa ne rabim vec-- . ', '; $subject = 'Porocilo ' . $mon . '/' . $year . " " . $user_unit; // message $message = ' <html> <p>Poročilo <b> </html> ' . $user_unit . '<html></b> je zaključeno! </p></html>' . '<a href="http://192.168.50.2/intranet/view_user_month.php?mon=' . $mon . "&year=" . $year . "&selunit=" . $unit . '" class="text"><b>Poročilo za mesec ' . $mon . '/' . $year . '</b></a><br> <br> <br>' . $user_first . " " . $user_last; // To send HTML mail, the Content-type header must be set $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=utf8' . "\r\n"; $headers .= 'From:' . $user_first . " " . $user_last . '<' . $user_first_low . "." . $user_last_low . '@vdcsasa.si>' . "\r\n" . 'Reply-To: admin@vdcsasa.si' . "\r\n" . ($headers .= 'Cc:' . $user_first_low . "." . $user_last_low . '@vdcsasa.si' . "\r\n"); $headers .= 'Cc: info@vdcsasa.si' . "\r\n";
} $out = '<set label =" skupaj " value="' . $whour_all . '" /> ' . "\n" . $out; } else { $sql = "SELECT * , FROM_UNIXTIME( \n\tSTART ) , FROM_UNIXTIME( \n\t\tEND ) \n\t\tFROM `work_log` \n\tWHERE `assessor_id` = {$person_id}\n\tAND DATE( FROM_UNIXTIME( \n\t\tEND ) ) like '" . $year . "-" . $mon . "%' order by start"; $result = $db->fetchAll($sql); $whour = round(working_hours_p_day($result)); $out .= '<set label =" oseba' . $person_id . ' " value="' . $whour . '" /> ' . "\n"; } $field = "applic"; break; } error_log($sql, 0); if (!$out) { $result = $db->fetchAll($sql); foreach ($result as $res) { $out .= '<set label ="' . str_sumniki($res[$field]) . ' " value="' . $res["st"] . '" /> ' . "\n"; } } error_log($out, 0); ?> <chart caption='<?php echo $title_graph; ?> ' subcaption='<?php echo $subtitle; ?> ' xAxisName='<?php echo $x_axis; ?> ' yAxisName='<?php echo $y_axis;