Subversion Repositories VORC

Rev

Rev 230 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 230 Rev 252
Line 123... Line 123...
123 
    $cathan = $internalDBH->prepare("select RCid, derby_name from official where access > 0 order by derby_name");
 123 
    $cathan = $internalDBH->prepare("select RCid, derby_name from official where access > 0 order by derby_name");
124 
    $cathan->execute();
 124 
    $cathan->execute();
125 
  } elsif ($DEPT eq "CLA") {
 125 
  } elsif ($DEPT eq "CLA") {
126 
    $cathan = $internalDBH->prepare("select RCid, derby_name from v_official where access > 0 and isnull(MVPid) = false and last_login > CURRENT_DATE - INTERVAL 365 DAY order by derby_name");
 126 
    $cathan = $internalDBH->prepare("select RCid, derby_name from v_official where access > 0 and isnull(MVPid) = false and last_login > CURRENT_DATE - INTERVAL 365 DAY order by derby_name");
127 
    $cathan->execute;
 127 
    $cathan->execute;
- 
 
 128 
  } elsif ($DEPT eq "SEM") {
- 
 
 129 
    $cathan = $internalDBH->prepare("select RCid, derby_name from v_official where access > 0 and last_login > CURRENT_DATE - INTERVAL 365 DAY order by derby_name");
- 
 
 130 
    $cathan->execute;
128 
  } elsif ($DEPT eq "EMT") {
 131 
  } elsif ($DEPT eq "EMT") {
129 
    $cathan = $internalDBH->prepare("select RCid, derby_name from v_official where access > 0 and emt_verified = true and last_login > CURRENT_DATE - INTERVAL 365 DAY order by derby_name");
 132 
    $cathan = $internalDBH->prepare("select RCid, derby_name from v_official where access > 0 and emt_verified = true and last_login > CURRENT_DATE - INTERVAL 365 DAY order by derby_name");
130 
    $cathan->execute;
 133 
    $cathan->execute;
131 
  } else {
 134 
  } else {
132 
    $cathan = $internalDBH->prepare("select RCid, derby_name from official where access > 0 and (department like ? and department not like ?) and last_login > CURRENT_DATE - INTERVAL 365 DAY order by derby_name");
 135 
    $cathan = $internalDBH->prepare("select RCid, derby_name from official where access > 0 and (department like ? and department not like ?) and last_login > CURRENT_DATE - INTERVAL 365 DAY order by derby_name");