Changeset 8122 for trunk/MagicSoft/Mars/datacenter
- Timestamp:
- 10/18/06 18:53:28 (18 years ago)
- Location:
- trunk/MagicSoft/Mars/datacenter/db
- Files:
-
- 15 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/MagicSoft/Mars/datacenter/db/culminating.php
r7974 r8122 21 21 //-------------------------------------------------- 22 22 $query0 .= " SUM(fNumEvents) as '" . $alias["SUM(fNumEvents)"] . "', "; 23 $query0 .= " COUNT(*) as ' Sequ#' ";23 $query0 .= " COUNT(*) as '# Sequ' "; 24 24 } 25 25 else -
trunk/MagicSoft/Mars/datacenter/db/datasetinfo-aio.php
r7974 r8122 22 22 if ($element==-1) 23 23 $query0 .= $key . " as '" . $alias[$key] . "' " . ", "; 24 $query0 .= " COUNT(*) as ' Dataset#' ";24 $query0 .= " COUNT(*) as '# Datasets' "; 25 25 } 26 26 else … … 33 33 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; 34 34 35 $query0 .= " count(*) as 'DataSet#'";35 $query0 .= " COUNT(*) as '# Datasets'"; 36 36 37 37 } -
trunk/MagicSoft/Mars/datacenter/db/datasetinfo.php
r7974 r8122 22 22 if ($element==-1) 23 23 $query0 .= $key . " as '" . $alias[$key] . "' " . ", "; 24 $query0 .= " COUNT(*) as ' Dataset#' ";24 $query0 .= " COUNT(*) as '# Datasets' "; 25 25 } 26 26 else … … 33 33 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; 34 34 35 $query0 .= " count(*) as 'DataSet#'";35 $query0 .= " COUNT(*) as '# Datasets'"; 36 36 37 37 } -
trunk/MagicSoft/Mars/datacenter/db/include.php
r7974 r8122 388 388 return $key; 389 389 390 if ($search=="# Runs") 391 return "NumRuns"; 392 if ($search=="# Sequ") 393 return "NumSequ"; 394 if ($search=="# Datasets") 395 return "NumDS"; 396 if ($search=="# days") 397 return "NumDays"; 390 398 return ""; 391 399 } -
trunk/MagicSoft/Mars/datacenter/db/index.php
r7974 r8122 27 27 $query0 .= " Min(fZenithDistance) as '" . $alias["Min(fZenithDistance)"] . "', "; 28 28 $query0 .= " Max(fZenithDistance) as '" . $alias["Max(fZenithDistance)"] . "', "; 29 $query0 .= " COUNT(*) as ' Runs#' ";29 $query0 .= " COUNT(*) as '# Runs' "; 30 30 } 31 31 else -
trunk/MagicSoft/Mars/datacenter/db/magicdefs.php
r8119 r8122 270 270 "Min(fZenithDistance)" => "ZdMin", 271 271 "Max(fZenithDistance)" => "ZdMax", 272 "COUNT(*)" => "Sequence",273 272 // "fArrTimeLimit" => "ArrTRms", 274 273 "fArrTimeLimit" => "ArrTime", … … 300 299 "fFailedCode" => "Err<br>Code", 301 300 "fFailedCodeAdd" => "Code<br>Add", 301 // "COUNT(*)" => "# Runs", 302 // "COUNT(*)" => "Sequence", 302 303 ); 303 304 … … 551 552 "Min(fZenithDistance)" => "'ZdMin'", 552 553 "Max(fZenithDistance)" => "'ZdMax'", 553 "COUNT(*)" => "'Sequence'",554 // "COUNT(*)" => "'Sequence'", 554 555 "fStartTime" => "fStartTime", 555 556 "fFailedTime" => "fFailedTime", … … 563 564 if (!empty($tables[$val])) 564 565 $table=$tables[$val]; 566 if ($val=="NumRuns") 567 $table="'# Runs'"; 568 if ($val=="NumSequ") 569 $table="'# Sequ'"; 570 if ($val=="NumDS") 571 $table="'# Datasets'"; 572 if ($val=="NumDays") 573 $table="'# days'"; 565 574 return $table; 566 575 } -
trunk/MagicSoft/Mars/datacenter/db/querymc.php
r7974 r8122 27 27 // $query0 .= " Min(fZenithDistance) as '" . $alias["Min(fZenithDistance)"] . "', "; 28 28 // $query0 .= " Max(fZenithDistance) as '" . $alias["Max(fZenithDistance)"] . "', "; 29 $query0 .= " COUNT(*) as ' Runs#' ";29 $query0 .= " COUNT(*) as '# Runs' "; 30 30 } 31 31 else -
trunk/MagicSoft/Mars/datacenter/db/queryseq.php
r7974 r8122 23 23 $query0 .= " Min(fZenithDistanceMin) as '" . $alias["Min(fZenithDistanceMin)"] . "', "; 24 24 $query0 .= " Max(fZenithDistanceMax) as '" . $alias["Max(fZenithDistanceMax)"] . "', "; 25 $query0 .= " COUNT(*) as ' Sequence#' ";25 $query0 .= " COUNT(*) as '# Sequ' "; 26 26 } 27 27 else -
trunk/MagicSoft/Mars/datacenter/db/runinfo-aio.php
r8044 r8122 43 43 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; 44 44 45 $query0 .= " count(*) as '# Run '";45 $query0 .= " count(*) as '# Runs'"; 46 46 47 47 } … … 173 173 { 174 174 $val=substr($_GET["fSortBy"], 0, -1); 175 // $query0 .= "---" . $val . "---"; 175 176 $query0 .= " ORDER BY " . GetTable($fromtable, $val) . " "; 176 177 if (substr($_GET["fSortBy"], -1)=="-") -
trunk/MagicSoft/Mars/datacenter/db/runinfo.php
r8044 r8122 43 43 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; 44 44 45 $query0 .= " count(*) as '# Run '";45 $query0 .= " count(*) as '# Runs'"; 46 46 47 47 } -
trunk/MagicSoft/Mars/datacenter/db/sequinfo-aio.php
r7962 r8122 28 28 $query0 .= " Min(fZenithDistanceMin) as '" . $alias["Min(fZenithDistanceMin)"] . "', "; 29 29 $query0 .= " Max(fZenithDistanceMax) as '" . $alias["Max(fZenithDistanceMax)"] . "', "; 30 $query0 .= " COUNT(*) as ' Sequence' ";30 $query0 .= " COUNT(*) as '# Sequ' "; 31 31 } 32 32 else … … 39 39 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; 40 40 41 $query0 .= " count(*) as 'Sequence'";41 $query0 .= " COUNT(*) as '# Sequ'"; 42 42 43 43 } -
trunk/MagicSoft/Mars/datacenter/db/sequinfo.php
r7974 r8122 28 28 $query0 .= " Min(fZenithDistanceMin) as '" . $alias["Min(fZenithDistanceMin)"] . "', "; 29 29 $query0 .= " Max(fZenithDistanceMax) as '" . $alias["Max(fZenithDistanceMax)"] . "', "; 30 $query0 .= " COUNT(*) as ' Sequence' ";30 $query0 .= " COUNT(*) as '# Sequ' "; 31 31 } 32 32 else … … 39 39 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; 40 40 41 $query0 .= " count(*) as 'Sequence'";41 $query0 .= " COUNT(*) as '# Sequ'"; 42 42 43 43 } -
trunk/MagicSoft/Mars/datacenter/db/statusrps.php
r7974 r8122 17 17 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $key . "', "; 18 18 19 $query0 .= " count(*) as ' Run#'";20 21 } 22 else 23 { 24 $query0 .= "fRunNumber as ' Run#' ";19 $query0 .= " count(*) as '# Runs'"; 20 21 } 22 else 23 { 24 $query0 .= "fRunNumber as '# Runs' "; 25 25 26 26 foreach ($_GET as $key => $element) -
trunk/MagicSoft/Mars/datacenter/db/statussbs.php
r7974 r8122 17 17 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; 18 18 19 $query0 .= " count(*) as '# days'";19 $query0 .= " count(*) as '# days'"; 20 20 21 21 } -
trunk/MagicSoft/Mars/datacenter/db/statussps.php
r7974 r8122 17 17 // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; 18 18 19 $query0 .= " count(*) as ' Sequence#'";19 $query0 .= " count(*) as '# Sequ'"; 20 20 21 21 }
Note:
See TracChangeset
for help on using the changeset viewer.