include_once($Path."/Global/Portal_Functions.inc.php");
include_once($Path."/Global/MailFunctions.inc.php");
include_once($Path."/Global/sql_ServerIMPortal.inc.php");


function PV1Reminder(){

  
  // Datenbank
  $db="Urlaub";
  $connDB = @mssql_select_db($db, $conServer); 


  // Startwerte
  //
  $ProzessNr='2502';
  $ProzessName='PV1Reminder';
  $ts_Start = mktime();


  // DB Abfrage
  $sql= "SELECT PV1_MAN, PV1_PNR, EMAIA ";
  $sql=$sql." FROM ".$db.".dbo.v_Reminder_Urlaub ";
  $sql=$sql." GROUP BY PV1_MAN, PV1_PNR, EMAIA ";
  $query=mssql_query($sql);

 

  $counter=0;
  while($daten=mssql_fetch_array($query)){
    //$Mail["Address"]=$daten["EMAIA"];
    //$Mail["Address"]="rainer.moenig@ingrammicro.de";
    //bruce mailadress for testing
    $Mail["Address"]="Bruce.Myklebust@ingrammicro.de";
    $Mail["Subject"]="Offene Anträge";
    $Mail["Header"]= $g_H_HTML.$g_H_HR;
        
    echo "

-test-".$g_H_HTML.$g_H_HR."

";