Subversion Repositories VORC

  my $orderby = shift;

  my $orderby = shift;

  my $curpage = shift; $curpage = 1 unless $curpage;

  my $curpage = shift; $curpage = 1 unless $curpage;

  my $pagelimit = shift // "All";

  my $pagelimit = shift // "All";

  my $selected = '*';

  }

  $whereClause = scalar @{$whereClause} > 0 ? "where ".join (" and ", @{$whereClause}) : '';

  $whereClause = scalar @{$whereClause} > 0 ? "where ".join (" and ", @{$whereClause}) : '';

  if ($orderby eq "dayofweek") {

  if ($orderby eq "dayofweek") {

  } else {

  } else {

    $curpage = ($curpage - 1) * $pagelimit;

    $curpage = ($curpage - 1) * $pagelimit;

    $getMe = "select distinct * from $table $whereClause $orderby limit $curpage, $pagelimit";

    $getMe = "select distinct * from $table $whereClause $orderby limit $curpage, $pagelimit";

  }

  }

  my ($totalcount) = @{$internalDBH->selectrow_arrayref ("select distinct count(*) from $table $whereClause")};

  my ($totalcount) = @{$internalDBH->selectrow_arrayref ("select distinct count(*) from $table $whereClause")};

  my $limhan = $internalDBH->prepare($getMe);     # Get the tickets from the DB

  my $limhan = $internalDBH->prepare($getMe);     # Get the tickets from the DB

  $limhan->execute();

  $limhan->execute();

  my @results = ();

  my @results = ();

  }

  }

  # "Shift Include" shows a checkbox to include a users shifts at the top of the page

  # "Shift Include" shows a checkbox to include a users shifts at the top of the page

  my $SIChecked;

  my $SIChecked;

  if ($showMyShiftsOption) {

    my $things = $DBTABLE eq "v_class" ? "classes" : "shifts";

      $SIChecked = "Show my shifts: ".$h->input ({ type=>"checkbox", name=>"shiftinclude", value=>"true", checked=>[], onClick=>'submit();' });

      $SIChecked = "Show my $things: ".$h->input ({ type=>"checkbox", name=>"shiftinclude", value=>"true", checked=>[], onClick=>'submit();' });

      $SIChecked = "Show my shifts: ".$h->input ({ type=>"checkbox", name=>"shiftinclude", value=>"true", onClick=>'submit();' });

      $SIChecked = "Show my $things: ".$h->input ({ type=>"checkbox", name=>"shiftinclude", value=>"true", onClick=>'submit();' });

    }

    }

  }

  }