CGI-OptimalQuery

 view release on metacpan or  search on metacpan

lib/CGI/OptimalQuery/InteractiveQuery.pm  view on Meta::CPAN


#OQdataLHead { 
  background-color: #efefef; 
}

td.OQinfoName {
  width: 1%;
  font-size: 13px;
}

.OQinfoVal {
  background-color: white !important;
  font-size: 13px;
}

#OQtitle {
  width: 40%;
  padding-left: 10px !important;
}

#OQhead td {
  padding: 4px !important;
}

/* workaround: too bad 'text-align: center' does not work */
table.OQpager {
  margin-left: auto;
  margin-right: auto;
}

.OQcolHeadTitle {
  font-size: 1.1em;
  color: black;
  font-weight: bold;
}

#OQdata tr td {
  border-right: 1px solid #efefef;
}

#OQhead, #OQinfo, #OQdata {
  width: 100%;
}


#OQdoc td {
  padding: 2px 5px 2px 5px;
}


#OQhead {
  background-color: #666666;
}

#OQhead td {
  color: white;
  padding: 0px;
}

#OQdoc button {
  cursor: pointer;
  background-color: #dddddd;
  border: 1px outset #333333;
  font-size: .8em;
  color: #111111;
  padding: 0px;
}

#OQsummary {
  width: 30%
}

#OQcmds button {
  margin-right: 2px;
}

div.OQcolCmds button {
  font-size: 10px;
}
div.OQcolCmds button {
  margin-right: 1px;
}
div.OQcolCmds select {
  margin-top: 3px;
}

#OQinfo {
  background-color: #cccccc;
}

tr.OQdataRowTypeEven {
  background-color: white;
}

tr.OQdataRowTypeOdd {
  background-color: #cccccc;
}

td.OQdataRCol {
  width: 1%;
}

#OQcmds {
  text-align: right;
}

td.OQdataLCol { width: 1%; }
tr.OQupdatedRow { background-color: #ffdddd }

td.OQcolHeader { white-space: nowrap } 

.OQaddColButton, .OQsortAscButton, .OQsortDescButton, .OQfilterCol, .OQcloseButton{
  width: 15px; height: 16px; margin: 0; margin-right: 8px !important; padding: 0;
  border: 0 !important; text-indent: -1000em;
} 

.OQaddColButton { background: transparent url(/OptimalQuery/add.gif) no-repeat center top; }
.OQsortAscButton { background: transparent url(/OptimalQuery/sortDown.gif) no-repeat center top; }
.OQsortDescButton { background: transparent url(/OptimalQuery/sortUp.gif) no-repeat center top; }
.OQfilterCol { background: transparent url(/OptimalQuery/filter.gif) no-repeat center top; }
.OQcloseButton { background: transparent url(/OptimalQuery/close.gif) no-repeat center top; }

#cmdOptions {
  margin-top: 10px;
  position: absolute;
  width: 20em;
  height: 16em;
  right: 20px;
  background-color: #efefef;
  border: 4px groove #666666;
  padding-right: 8px;
  padding-left: 8px;
  padding-bottom: 8px;
  font-size: .8em;
  color: #444444;
  overflow: auto;
  display: none;
}

#cmdOptions button.closeButton {
  position: absolute;
  right: 0;
  color: black;
  font-weight: bold;
  padding: 0px;
  margin: 0px;
  background-color: white;
  border: 1px outset black;
  text-align: center;
  vertical-align: middle;
  cursor: pointer;
  font-size: .8em;
}

#cmdOptions h1 {
  color: #222222;
  margin: 0px;
  font-size: 1.2em;
  padding: 0;
}

#cmdOptions span.note {
  font-size: .7em;
}

#OQdata { border-bottom: 1px solid #666666; }

#OQkey button { margin-left: 10px; }

TILEND
}
















sub can_embed { 1 }

sub getPager {
  my $o = shift;

  my $doc = "
<center>
<table class='OQpager'>
<tr>
<td>";
  # print previous page button if user is not on first page
  $doc .= "<button type='button' class='OQprevPageButton' onclick=\"OQval('page', ".
    ($o->get_current_page() - 1)."); OQrefresh();\">previous</button>"
      if $o->get_current_page() > 1;

  $doc .= "</td>
<td>
<select class='OQrowsPagePicker' onchange=\"OQval('rows_page',this.options[this.selectedIndex].value); OQrefresh();\">";

  # print results per page picker
  foreach my $p (@{ $$o{schema}{results_per_page_picker_nums} }) {
    next if $p ne 'All' && $p > $o->get_count();
    $doc .= "<option value='$p'";
    $doc .= " selected='selected'" if $p eq $o->get_rows_page();



( run in 1.891 second using v1.01-cache-2.11-cpan-524268b4103 )