inc/timesheet-valid.php

   1 <?php
   2   $invalid = false;
   3
   4   // Validate that they are only maintaining their own timesheets
   5   if ( is_member_of('Admin','Support') ) {
   6     // OK, they can add time onto requests :-)
   7   }
   8   else if ( is_member_of('Contractor') ) {
   9     // Build an array of the request IDs the person is trying to put time against
  10     $request_ids = array();
  11     for ( $dow = 0; $dow < 7; $dow ++ ) {
  12       while( list( $k, $v ) = each ( $tm[$dow] ) ) {
  13         if ( $v != "" ) {
  14           list( $number, $description ) = split( '/', $v, 2);
  15           $number = intval($number);
  16           if ( $number > 0 ) {
  17             $request_ids[$number] = $number;
  18           }
  19         }
  20       }
  21     }
  22     // Select the user's system_role for each such system
  23     $sql = "SELECT request.request_id, system_usr.role ";
  24     $sql .= "FROM request LEFT OUTER JOIN system_usr ON request.system_id = system_usr.system_id AND system_usr.user_no=? ";
  25     $sql .= "WHERE request_id IN (" . implode( ",", $request_ids ) . ");";
  26     $qry = new PgQuery( $sql, $session->user_no );
  27     if ( $qry->Exec("TimeSheet") ) {
  28       if ( $qry->rows > 0 ) {
  29         while( $row = $qry->Fetch() ) {
  30           $request_ids[$row->request_id] = $row->role;
  31         }
  32         foreach( $request_ids AS $r_id => $role ) {
  33           if ( $role == $r_id ) {
  34             $client_messages[] = "W/R $r_id does not exist.";
  35             $invalid = true;
  36           }
  37           else if ( $role == "" ) {
  38             $client_messages[] = "You may not assign time to W/R $r_id.";
  39             $invalid = true;
  40           }
  41         }
  42       }
  43     }
  44   }
  45   else {
  46     $client_messages[] = "You may not maintain timesheet information.";
  47     $invalid = true;
  48   }
  49
  50   if ( $invalid ) {
  51     $client_messages[] = 'Please correct and resubmit: <span style="font-size:150%;"> &nbsp; No data has been saved!</span>';
  52   }
  53   else {
  54     $session->Dbg("TimeSheet","Timesheet entry validated OK");
  55   }
  56 ?>