$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";
Beispiel #2
0
            }
            $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;