/trunk/api/js/dojo1.0/dojox/grid/tests/test_mysql_edit.html |
---|
New file |
0,0 → 1,157 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html debug="true"> |
<head> |
<title>dojox.Grid Test: Mysql Table Editing</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style> |
@import "../_grid/tundraGrid.css"; |
@import "../../../dojo/resources/dojo.css"; |
@import "../../../dijit/themes/tundra/tundra.css"; |
@import "../../../dijit/tests/css/dijitTests.css"; |
.grid { |
height: 30em; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:true, parseOnLoad: true"></script> |
<script type="text/javascript" src="../../../dijit/tests/_testCommon.js"></script> |
<!--<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojox.grid._data.dijitEditors"); |
dojo.require("dojox.grid.tests.databaseModel"); |
dojo.require("dojo.parser"); |
</script>--> |
<!-- Debugging --> |
<script type="text/javascript" src="../_grid/lib.js"></script> |
<script type="text/javascript" src="../_grid/drag.js"></script> |
<script type="text/javascript" src="../_grid/scroller.js"></script> |
<script type="text/javascript" src="../_grid/builder.js"></script> |
<script type="text/javascript" src="../_grid/cell.js"></script> |
<script type="text/javascript" src="../_grid/layout.js"></script> |
<script type="text/javascript" src="../_grid/rows.js"></script> |
<script type="text/javascript" src="../_grid/focus.js"></script> |
<script type="text/javascript" src="../_grid/selection.js"></script> |
<script type="text/javascript" src="../_grid/edit.js"></script> |
<script type="text/javascript" src="../_grid/view.js"></script> |
<script type="text/javascript" src="../_grid/views.js"></script> |
<script type="text/javascript" src="../_grid/rowbar.js"></script> |
<script type="text/javascript" src="../_grid/publicEvents.js"></script> |
<script type="text/javascript" src="../VirtualGrid.js"></script> |
<script type="text/javascript" src="../_data/fields.js"></script> |
<script type="text/javascript" src="../_data/model.js"></script> |
<script type="text/javascript" src="../_data/editors.js"></script> |
<script type="text/javascript" src="../_data/dijitEditors.js"></script> |
<script type="text/javascript" src="../Grid.js"></script> |
<script type="text/javascript" src="databaseModel.js"></script> |
<script type="text/javascript"> |
var model = new dojox.grid.data.DbTable(null, null, 'support/data.php', "test", "testtbl"); |
// simple display of row info; based on model observing. |
modelChange = function() { |
dojo.byId('rowCount').innerHTML = model.count + ' row(s)'; |
} |
model.observer(this); |
// yay, let's deal with MySql date types, at least a little bit... |
// NOTE: supports only default date formatting YYYY-MM-DD HH:MM:SS or YY-MM-DD HH:MM:SS |
mysqlDateToJsDate = function(inMysqlDateTime, inDateDelim, inTimeDelim) { |
var dt = inMysqlDateTime.split(' '), d = dt[0], t = dt[1], r; |
d = d&&d.split(inDateDelim||'-'); |
t = t&&t.split(inTimeDelim||':'); |
if (d && d.length == 3) { |
r = new Date(); |
r.setYear(d[0]); |
r.setMonth(parseInt(d[1])-1); |
r.setDate(d[2]); |
} |
if (t && t.length == 3) { |
r = r || new Date(); |
r.setHours(t[0]); |
r.setMinutes(t[1]); |
r.setSeconds(t[2]); |
} |
return r || new Date(inMysqlDateTime); |
} |
jsDateToMySqlDate = function(inDate) { |
var |
d = new Date(inDate), |
y = d.getFullYear(), |
m = dojo.string.pad(d.getMonth() + 1), |
dd = dojo.string.pad(d.getDate()) |
return dojo.string.substitute("${0}-${1}-${2}",[y, m, dd]); |
}; |
// custom simple MySql date formatter |
formatMySqlDate = function(inDatum) { |
return inDatum != dojox.grid.na ? dojo.date.locale.format(mysqlDateToJsDate(inDatum), this.constraint) : dojox.grid.na; |
} |
// custom simple MySql date editor |
dojo.declare("mySqlDateEditor", dojox.grid.editors.DateTextBox, { |
format: function(inDatum, inRowIndex){ |
inDatum = mysqlDateToJsDate(inDatum); |
return this.inherited(arguments, [inDatum, inRowIndex]); |
}, |
getValue: function(inRowIndex){ |
var v = this.editor.getValue(), fv = jsDateToMySqlDate(v); |
return fv; |
} |
}); |
var gridLayout = [ |
{ type: "dojox.GridRowView", width: "20px" }, |
{ |
defaultCell: { width: 6, editor: dojox.grid.editors.Dijit }, |
cells: [[ |
{ name: 'Id', styles: 'text-align: right;', editorClass: "dijit.form.NumberTextBox" }, |
{ name: 'Name', width: 20}, |
{ name: 'Message', styles: 'text-align: right;'}, |
{ name: 'Date', |
editor: mySqlDateEditor, |
formatter: formatMySqlDate, |
constraint: {selector: "date"}, |
width: 10, |
styles: 'text-align:right;'} |
]]} |
]; |
function waitMessage() { |
alert('Edit in progress, please wait.'); |
} |
function getDefaultRow() { |
return ['', '', '', jsDateToMySqlDate(new Date())]; |
} |
function addRow() { |
if(model.canModify()){ |
grid.addRow(getDefaultRow()); |
}else{ |
waitMessage(); |
} |
} |
function removeSelected(){ |
if(model.canModify()){ |
grid.removeSelectedRows(); |
}else{ |
waitMessage(); |
} |
} |
</script> |
</head> |
<body class="tundra"> |
<h1>dojox.Grid Test: Mysql Table Editing</h1> |
<br> |
<button onclick="addRow()">Add Row</button> |
<button onclick="removeSelected()">Remove Selected</button> |
<button onclick="grid.edit.apply()">Apply Edit</button> |
<button onclick="grid.edit.cancel()">Cancel Edit</button> |
<button onclick="grid.refresh()">Refresh</button> |
<br><br> |
<div jsId="grid" class="grid" structure="gridLayout" dojoType="dojox.Grid" model="model" singleClickEdit="true" autoWidth="true"></div> |
<div id="rowCount"></div> |
<p>Note: This test requires MySql and PHP and works with the database table available in support/testtbl.sql.</p> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/support/test_data.js |
---|
New file |
0,0 → 1,30 |
// example sample data and code |
(function(){ |
// some sample data |
// global var "data" |
data = [ |
[ "normal", false, "new", 'But are not followed by two hexadecimal', 29.91, 10, false ], |
[ "important", false, "new", 'Because a % sign always indicates', 9.33, -5, false ], |
[ "important", false, "read", 'Signs can be selectively', 19.34, 0, true ], |
[ "note", false, "read", 'However the reserved characters', 15.63, 0, true ], |
[ "normal", false, "replied", 'It is therefore necessary', 24.22, 5.50, true ], |
[ "important", false, "replied", 'To problems of corruption by', 9.12, -3, true ], |
[ "note", false, "replied", 'Which would simply be awkward in', 12.15, -4, false ] |
]; |
var rows = 100; |
for(var i=0, l=data.length; i<rows-l; i++){ |
data.push(data[i%l].slice(0)); |
} |
// global var "model" |
model = new dojox.grid.data.Table(null, data); |
// simple display of row info; based on model observation |
// global var "modelChange" |
modelChange = function(){ |
var n = dojo.byId('rowCount'); |
if(n){ |
n.innerHTML = Number(model.getRowCount()) + ' row(s)'; |
} |
} |
})(); |
/trunk/api/js/dojo1.0/dojox/grid/tests/support/proxy.php |
---|
New file |
0,0 → 1,27 |
<?php |
// Open the Curl session |
if (!$_POST['url']) |
exit; |
$session = curl_init(($_POST['url'])); |
$postvars = file_get_contents('php://input'); |
// Don't return HTTP headers. Do return the contents of the call |
curl_setopt($session, CURLOPT_HEADER, false); |
curl_setopt($session, CURLOPT_RETURNTRANSFER, true); |
// Make the call |
$response = curl_exec($session); |
//header("Content-Type: text/html; charset=utf-8"); |
header("Content-Type: application/xml;"); |
// expects a json response and filters it |
echo "/*" . $response . "*/"; |
curl_close($session); |
?> |
/trunk/api/js/dojo1.0/dojox/grid/tests/support/movies.csv |
---|
New file |
0,0 → 1,9 |
Title, Year, Producer |
City of God, 2002, Katia Lund |
Rain,, Christine Jeffs |
2001: A Space Odyssey, , Stanley Kubrick |
"This is a ""fake"" movie title", 1957, Sidney Lumet |
Alien, 1979 , Ridley Scott |
"The Sequel to ""Dances With Wolves.""", 1982, Ridley Scott |
"Caine Mutiny, The", 1954, "Dymtryk ""the King"", Edward" |
/trunk/api/js/dojo1.0/dojox/grid/tests/support/data.php |
---|
New file |
0,0 → 1,379 |
<?php |
// db settings |
$dbserver = 'localhost'; |
$dbuser = 'root'; |
$dbpassword = 'root'; |
error_reporting(E_ALL); |
/* |
Simple protocol: |
- Inputs via POST variables. |
- Output is a string that can be evaluated into a JSON |
First element of the array contains return status. |
This simplified tutorial code should not be deployed without a security review. |
*/ |
@include "json.php"; |
// set up response encoding |
header("Content-Type: text/html; charset=utf-8"); |
// util |
function getPostString($inName) { |
// make sure input strings are 'clean' |
return mysql_real_escape_string(@$_POST[$inName]); |
} |
// used for json encoding |
$json = new Services_JSON(); |
function echoJson($inData) { |
global $json; |
// delay in ms |
$delay = getPostString('delay'); |
if (!empty($delay)) |
usleep($delay * 1000); |
echo '/* ' . $json->encode($inData) . ' */'; |
} |
function error($inMessage) { |
$inMessage = str_replace('"', '\\"', $inMessage); |
error_log($inMessage); |
//echo '/* ({error: true, message: "' . $inMessage . '"}) */'; |
echoJson(array('error' => true, 'message' => $inMessage)); |
exit; |
} |
function getArray($inResult, $inArray="true") { |
$o = Array(); |
while ($row = ($inArray ? mysql_fetch_row($inResult) : mysql_fetch_object($inResult))) |
$o[] = $row; |
return $o; |
} |
// connect to DB |
mysql_connect($dbserver, $dbuser, $dbpassword); |
// select DB |
$database = getPostString("database"); |
$database = ($database ? $database : $db); |
if (!mysql_select_db($database)) |
error('failed to select db: ' . mysql_error()); |
// select table |
$table = getPostString("table"); |
$table = ($table ? $table : $dbtable); |
// cache |
$colCache = NULL; |
$pkCache = NULL; |
// set UTF8 output (MySql > 4.0) |
mysql_query("SET NAMES UTF8"); |
// server, database, table meta data |
function getDatabases() { |
$result = mysql_query("SHOW DATABASES"); |
$output = Array(); |
while ($row = mysql_fetch_row($result)) { |
$r = strtolower($row[0]); |
if ($r != 'mysql' && $r != 'information_schema') |
$output[] = $row[0]; |
} |
return $output; |
} |
function getTables() { |
global $database; |
$result = mysql_query("SHOW TABLES FROM $database"); |
$output = Array(); |
while ($row = mysql_fetch_row($result)) |
$output[] = $row[0]; |
return $output; |
} |
function getColumns() { |
global $table, $colCache; |
if (!$colCache) { |
$result = mysql_query("SHOW COLUMNS FROM `$table`"); |
return getArray($result, false); |
$colCache = getArray($result, false); |
} |
return $colCache; |
} |
// returns object: $this->name, $this->index |
function getPk() { |
global $pkCache; |
if (!$pkCache) { |
$k = ''; |
$columns = getColumns(); |
for ($i=0; $i < count($columns); $i++) { |
$c = $columns[$i]; |
if ($c->Key == 'PRI') { |
$k = $c->Field; |
break; |
} |
} |
$pkCache->index = $i; |
$pkCache->name = $k; |
} |
return $pkCache; |
} |
function getTableInfo() { |
global $table, $database; |
$c = getColumns(); |
$r = rowcount(); |
return array("count" => $r, "columns" => $c, "database" => $database, "table" => $table); |
} |
function getOldPostPkValue() { |
$pk = getPk(); |
return getPostString('_o' . $pk->index); |
} |
function getNewPostPkValue() { |
$pk = getPk(); |
return getPostString('_' . $pk->index); |
} |
function getPostColumns() { |
$columns = getColumns(); |
for ($i=0, $a=array(), $p; (($p=getPostString("_".$i)) != ''); $i++) { |
$r = new stdClass(); |
$r->name = $columns[$i]->Field; |
$r->value = $p; |
$a[] = $r; |
} |
return $a; |
} |
function getOrderBy() { |
$ob = getPostString("orderby"); |
if (is_numeric($ob)) { |
$columns = getColumns(); |
$ob = $columns[intval($ob)-1]->Field; |
} |
return $ob; |
} |
function getWhere() { |
$w = getPostString("where"); |
return ($w ? " WHERE $w" : ""); |
} |
// basic operations |
function rowcount() { |
global $table; |
$query = "SELECT COUNT(*) FROM `$table`" . getWhere(); |
$result = mysql_query($query); |
if (!$result) |
error("failed to perform query: $query. " . mysql_error()); |
if ($row = mysql_fetch_row($result)) |
return $row[0]; |
else |
return 0; |
} |
function select($inQuery = '') { |
global $table; |
// built limit clause |
$lim = (int)getPostString("limit"); |
$off = (int)getPostString("offset"); |
$limit = ($lim || $off ? " LIMIT $off, $lim" : ""); |
// build order by clause |
$desc = (boolean)getPostString("desc"); |
$ob = getOrderBy(); |
$orderby = ($ob ? " ORDER BY `" . $ob . "`" . ($desc ? " DESC" : "") : ""); |
// build query |
$query = ($inQuery ? $inQuery : "SELECT * FROM `$table`" . getWhere() . $orderby . $limit); |
// execute query |
if (!$result = mysql_query($query)) |
error("failed to perform query: $query. " . mysql_error()); |
// fetch each result row |
return getArray($result); |
} |
function reflectRow() { |
global $table; |
$pk = getPk(); |
$key = getNewPostPkValue(); |
$where = "`$pk->name`=\"$key\""; |
return select("SELECT * FROM `$table` WHERE $where LIMIT 1"); |
} |
function update() { |
// build set clause |
for ($i=0, $set = array(), $cols = getPostColumns(), $v; ($v=$cols[$i]); $i++) |
$set[] = "`$v->name` = '$v->value'"; |
$set = implode(', ', $set); |
// our table |
global $table; |
// build query |
$pk = getPk(); |
$pkValue = getOldPostPkValue(); |
$query = "UPDATE `$table` SET $set WHERE `$pk->name` = '$pkValue' LIMIT 1"; |
// execute query |
if (!mysql_query($query)) |
error("failed to perform query: [$query]. " . |
"MySql says: [" . mysql_error() ."]"); |
else { |
return reflectRow(); |
} |
} |
function insert() { |
global $table; |
// build values clause |
for ($i=0, $values = array(), $cols = getPostColumns(), $v; ($v=$cols[$i]); $i++) |
$values[] = $v->value; |
$values = '"' . implode('", "', $values) . '"'; |
// build query |
$query = "INSERT INTO `$table` VALUES($values)"; |
// execute query |
if (!mysql_query($query)) |
error("failed to perform query: [$query]. " . |
"MySql says: [" . mysql_error() ."]"); |
else { |
return reflectRow(); |
} |
} |
function delete() { |
global $table; |
// build query |
$n = getPostString("count"); |
$pk = getPk(); |
for ($i = 0, $deleted=array(); $i < $n; $i++) { |
$key = getPostString("_$i"); |
array_push($deleted, $key); |
$query = "DELETE FROM `$table` WHERE `$pk->name`=\"$key\" LIMIT 1"; |
// execute query |
if (!mysql_query($query) || mysql_affected_rows() != 1) |
error("failed to perform query: [$query]. " . |
"Affected rows: " . mysql_affected_rows() .". " . |
"MySql says: [" . mysql_error() ."]"); |
} |
return $deleted; |
} |
// find (full text search) |
function findData($inFindCol, $inFind, $inOrderBy, $inFullText) { |
global $table; |
$where = ($inFullText ? "WHERE MATCH(`$inFindCol`) AGAINST ('$inFind')" : "WHERE $inFindCol LIKE '$inFind'"); |
$query = "SELECT * FROM $table $where $inOrderBy"; |
$result = mysql_query($query); |
// return rows |
return getArray($result); |
} |
// binary search through sorted data, supports start point ($inFindFrom) and direction ($inFindForward) |
function findRow($inData, $inFindFrom=-1, $inFindForward) { |
$b = -1; |
$l = count($inData); |
if (!$inData) |
return $b; |
if (!$inFindFrom==-1 || $l < 2) |
$b = 0; |
else { |
// binary search |
$t = $l-1; |
$b = 0; |
while ($b <= $t) { |
$p = floor(($b+$t)/2); |
$d = $inData[$p][0]; |
if ($d < $inFindFrom) |
$b = $p + 1; |
else if ($d > $inFindFrom) |
$t = $p - 1; |
else { |
$b = $p; |
break; |
} |
} |
if ($inFindFrom == $inData[$b][0]) { |
// add or subtract 1 |
$b = ($inFindForward ? ($b+1 > $l-1 ? 0 : $b+1) : ($b-1 < 0 ? $l-1 : $b-1) ); |
} |
else if (!$inFindForward) |
// subtract 1 |
$b = ($b-1 < 0 ? $l-1 : $b-1); |
} |
return $inData[$b][0]; |
} |
function buildFindWhere($inFindData, $inKey, $inCol) { |
$o = Array(); |
foreach($inFindData as $row) |
$o[] = $inCol . "='" . $row[$inKey] . "'"; |
return (count($o) ? ' WHERE ' . implode(' OR ', $o) : ''); |
} |
function find($inFindCol, $inFind='', $inOb='', $inFindFrom=0, $inFindForward=true, $inFullText=true) { |
global $table; |
// build order by clause |
$desc = (boolean)getPostString("desc"); |
if (!$inOb) |
$inOb = getOrderBy(); |
if ($inOb) |
$inOb = "`" . $inOb . "`" ; |
$orderby = ($inOb ? " ORDER BY $inOb " . ($desc ? " DESC" : "") : ""); |
// update inputs from post |
if (!$inFind) |
$inFind = getPostString('findText'); |
if (!$inFindCol) |
$inFindCol = getPostString('findCol'); |
if (empty($inFindFrom)) |
$inFindFrom = getPostString('findFrom'); |
$ff = getPostString('findForward'); |
if ($ff) |
$inFindForward = (strtolower($ff) == 'true' ? true : false); |
$ft = getPostString('findFullText'); |
if ($ft) |
$inFullText = (strtolower($ft) == 'true' ? true : false); |
// get find data |
$f = findData($inFindCol, $inFind, $orderby, $inFullText); |
$pk = getPk(); |
// execute query |
$where = buildFindWhere($f, $pk->index, 'f'); |
$query = "SELECT Row, f FROM (SELECT @row := @row + 1 AS Row, $pk->name as f FROM `$table` $orderby) AS tempTable $where"; |
mysql_query('SET @row = -1;'); |
if (!$result = mysql_query($query)) |
error("failed to perform query: $query. " . mysql_error()); |
// return row number |
return findRow(getArray($result), $inFindFrom, $inFindForward); |
} |
// our command list |
$cmds = array( |
"count" => "rowcount", |
"select" => "select", |
"update" => "update", |
"insert" => "insert", |
"delete" => "delete", |
"find" => "find", |
"databases" => "getDatabases", |
"tables" => "getTables", |
"columns" => "getColumns", |
"info" => "getTableInfo" |
); |
// process input params |
$cmd = @$_POST["command"]; |
//$cmd="select"; |
// dispatch command |
$func = @$cmds[$cmd]; |
if (function_exists($func)) |
echoJson(call_user_func($func)); |
else |
error("bad command"); |
?> |
/trunk/api/js/dojo1.0/dojox/grid/tests/support/json.php |
---|
New file |
0,0 → 1,794 |
<?php |
/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */ |
/** |
* Converts to and from JSON format. |
* |
* JSON (JavaScript Object Notation) is a lightweight data-interchange |
* format. It is easy for humans to read and write. It is easy for machines |
* to parse and generate. It is based on a subset of the JavaScript |
* Programming Language, Standard ECMA-262 3rd Edition - December 1999. |
* This feature can also be found in Python. JSON is a text format that is |
* completely language independent but uses conventions that are familiar |
* to programmers of the C-family of languages, including C, C++, C#, Java, |
* JavaScript, Perl, TCL, and many others. These properties make JSON an |
* ideal data-interchange language. |
* |
* This package provides a simple encoder and decoder for JSON notation. It |
* is intended for use with client-side Javascript applications that make |
* use of HTTPRequest to perform server communication functions - data can |
* be encoded into JSON notation for use in a client-side javascript, or |
* decoded from incoming Javascript requests. JSON format is native to |
* Javascript, and can be directly eval()'ed with no further parsing |
* overhead |
* |
* All strings should be in ASCII or UTF-8 format! |
* |
* LICENSE: Redistribution and use in source and binary forms, with or |
* without modification, are permitted provided that the following |
* conditions are met: Redistributions of source code must retain the |
* above copyright notice, this list of conditions and the following |
* disclaimer. Redistributions in binary form must reproduce the above |
* copyright notice, this list of conditions and the following disclaimer |
* in the documentation and/or other materials provided with the |
* distribution. |
* |
* THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED |
* WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF |
* MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN |
* NO EVENT SHALL CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, |
* INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |
* BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS |
* OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND |
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR |
* TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE |
* USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH |
* DAMAGE. |
* |
* @category |
* @package Services_JSON |
* @author Michal Migurski <mike-json@teczno.com> |
* @author Matt Knapp <mdknapp[at]gmail[dot]com> |
* @author Brett Stimmerman <brettstimmerman[at]gmail[dot]com> |
* @copyright 2005 Michal Migurski |
* @license http://www.opensource.org/licenses/bsd-license.php |
* @link http://pear.php.net/pepr/pepr-proposal-show.php?id=198 |
*/ |
/** |
* Marker constant for Services_JSON::decode(), used to flag stack state |
*/ |
define('SERVICES_JSON_SLICE', 1); |
/** |
* Marker constant for Services_JSON::decode(), used to flag stack state |
*/ |
define('SERVICES_JSON_IN_STR', 2); |
/** |
* Marker constant for Services_JSON::decode(), used to flag stack state |
*/ |
define('SERVICES_JSON_IN_ARR', 4); |
/** |
* Marker constant for Services_JSON::decode(), used to flag stack state |
*/ |
define('SERVICES_JSON_IN_OBJ', 8); |
/** |
* Marker constant for Services_JSON::decode(), used to flag stack state |
*/ |
define('SERVICES_JSON_IN_CMT', 16); |
/** |
* Behavior switch for Services_JSON::decode() |
*/ |
define('SERVICES_JSON_LOOSE_TYPE', 10); |
/** |
* Behavior switch for Services_JSON::decode() |
*/ |
define('SERVICES_JSON_STRICT_TYPE', 11); |
/** |
* Encodings |
*/ |
define('SERVICES_JSON_ISO_8859_1', 'iso-8859-1'); |
define('SERVICES_JSON_UTF_8', 'utf-8'); |
/** |
* Converts to and from JSON format. |
* |
* Brief example of use: |
* |
* <code> |
* // create a new instance of Services_JSON |
* $json = new Services_JSON(); |
* |
* // convert a complexe value to JSON notation, and send it to the browser |
* $value = array('foo', 'bar', array(1, 2, 'baz'), array(3, array(4))); |
* $output = $json->encode($value); |
* |
* print($output); |
* // prints: ["foo","bar",[1,2,"baz"],[3,[4]]] |
* |
* // accept incoming POST data, assumed to be in JSON notation |
* $input = file_get_contents('php://input', 1000000); |
* $value = $json->decode($input); |
* </code> |
*/ |
class Services_JSON |
{ |
/** |
* constructs a new JSON instance |
* |
//>> SJM2005 |
* @param string $encoding Strings are input/output in this encoding |
* @param int $encode Encode input is expected in this character encoding |
//<< SJM2005 |
* |
* @param int $use object behavior: when encoding or decoding, |
* be loose or strict about object/array usage |
* |
* possible values: |
* - SERVICES_JSON_STRICT_TYPE: strict typing, default. |
* "{...}" syntax creates objects in decode(). |
* - SERVICES_JSON_LOOSE_TYPE: loose typing. |
* "{...}" syntax creates associative arrays in decode(). |
*/ |
function Services_JSON($encoding = SERVICES_JSON_UTF_8, $use = SERVICES_JSON_STRICT_TYPE) |
{ |
//>> SJM2005 |
$this->encoding = $encoding; |
//<< SJM2005 |
$this->use = $use; |
} |
/** |
* convert a string from one UTF-16 char to one UTF-8 char |
* |
* Normally should be handled by mb_convert_encoding, but |
* provides a slower PHP-only method for installations |
* that lack the multibye string extension. |
* |
* @param string $utf16 UTF-16 character |
* @return string UTF-8 character |
* @access private |
*/ |
function utf162utf8($utf16) |
{ |
// oh please oh please oh please oh please oh please |
if(function_exists('mb_convert_encoding')) |
return mb_convert_encoding($utf16, 'UTF-8', 'UTF-16'); |
$bytes = (ord($utf16{0}) << 8) | ord($utf16{1}); |
switch(true) { |
case ((0x7F & $bytes) == $bytes): |
// this case should never be reached, because we are in ASCII range |
// see: http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
return chr(0x7F & $bytes); |
case (0x07FF & $bytes) == $bytes: |
// return a 2-byte UTF-8 character |
// see: http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
return chr(0xC0 | (($bytes >> 6) & 0x1F)) |
. chr(0x80 | ($bytes & 0x3F)); |
case (0xFFFF & $bytes) == $bytes: |
// return a 3-byte UTF-8 character |
// see: http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
return chr(0xE0 | (($bytes >> 12) & 0x0F)) |
. chr(0x80 | (($bytes >> 6) & 0x3F)) |
. chr(0x80 | ($bytes & 0x3F)); |
} |
// ignoring UTF-32 for now, sorry |
return ''; |
} |
/** |
* convert a string from one UTF-8 char to one UTF-16 char |
* |
* Normally should be handled by mb_convert_encoding, but |
* provides a slower PHP-only method for installations |
* that lack the multibye string extension. |
* |
* @param string $utf8 UTF-8 character |
* @return string UTF-16 character |
* @access private |
*/ |
function utf82utf16($utf8) |
{ |
// oh please oh please oh please oh please oh please |
if(function_exists('mb_convert_encoding')) |
return mb_convert_encoding($utf8, 'UTF-16', 'UTF-8'); |
switch(strlen($utf8)) { |
case 1: |
// this case should never be reached, because we are in ASCII range |
// see: http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
return $ut8; |
case 2: |
// return a UTF-16 character from a 2-byte UTF-8 char |
// see: http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
return chr(0x07 & (ord($utf8{0}) >> 2)) |
. chr((0xC0 & (ord($utf8{0}) << 6)) |
| (0x3F & ord($utf8{1}))); |
case 3: |
// return a UTF-16 character from a 3-byte UTF-8 char |
// see: http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
return chr((0xF0 & (ord($utf8{0}) << 4)) |
| (0x0F & (ord($utf8{1}) >> 2))) |
. chr((0xC0 & (ord($utf8{1}) << 6)) |
| (0x7F & ord($utf8{2}))); |
} |
// ignoring UTF-32 for now, sorry |
return ''; |
} |
/** |
* encodes an arbitrary variable into JSON format |
* |
* @param mixed $var any number, boolean, string, array, or object to be encoded. |
* see argument 1 to Services_JSON() above for array-parsing behavior. |
* if var is a strng, note that encode() always expects it |
* to be in ASCII or UTF-8 format! |
* |
* @return string JSON string representation of input var |
* @access public |
*/ |
function encode($var) |
{ |
switch (gettype($var)) { |
case 'boolean': |
return $var ? 'true' : 'false'; |
case 'NULL': |
return 'null'; |
case 'integer': |
return (int) $var; |
case 'double': |
case 'float': |
return (float) $var; |
case 'string': |
//>> SJM2005 |
if ($this->encoding == SERVICES_JSON_UTF_8) |
; |
else if ($this->encoding == SERVICES_JSON_ISO_8859_1) |
$var = utf8_encode($var); |
else if (!function_exists('mb_convert_encoding')) |
die('Requested encoding requires mb_strings extension.'); |
else |
$var = mb_convert_encoding($var, "utf-8", $this->encoding); |
//<< SJM2005 |
// STRINGS ARE EXPECTED TO BE IN ASCII OR UTF-8 FORMAT |
$ascii = ''; |
$strlen_var = strlen($var); |
/* |
* Iterate over every character in the string, |
* escaping with a slash or encoding to UTF-8 where necessary |
*/ |
for ($c = 0; $c < $strlen_var; ++$c) { |
$ord_var_c = ord($var{$c}); |
switch (true) { |
case $ord_var_c == 0x08: |
$ascii .= '\b'; |
break; |
case $ord_var_c == 0x09: |
$ascii .= '\t'; |
break; |
case $ord_var_c == 0x0A: |
$ascii .= '\n'; |
break; |
case $ord_var_c == 0x0C: |
$ascii .= '\f'; |
break; |
case $ord_var_c == 0x0D: |
$ascii .= '\r'; |
break; |
case $ord_var_c == 0x22: |
case $ord_var_c == 0x2F: |
case $ord_var_c == 0x5C: |
// double quote, slash, slosh |
$ascii .= '\\'.$var{$c}; |
break; |
case (($ord_var_c >= 0x20) && ($ord_var_c <= 0x7F)): |
// characters U-00000000 - U-0000007F (same as ASCII) |
$ascii .= $var{$c}; |
break; |
case (($ord_var_c & 0xE0) == 0xC0): |
// characters U-00000080 - U-000007FF, mask 110XXXXX |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$char = pack('C*', $ord_var_c, ord($var{$c + 1})); |
$c += 1; |
$utf16 = $this->utf82utf16($char); |
$ascii .= sprintf('\u%04s', bin2hex($utf16)); |
break; |
case (($ord_var_c & 0xF0) == 0xE0): |
// characters U-00000800 - U-0000FFFF, mask 1110XXXX |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$char = pack('C*', $ord_var_c, |
ord($var{$c + 1}), |
ord($var{$c + 2})); |
$c += 2; |
$utf16 = $this->utf82utf16($char); |
$ascii .= sprintf('\u%04s', bin2hex($utf16)); |
break; |
case (($ord_var_c & 0xF8) == 0xF0): |
// characters U-00010000 - U-001FFFFF, mask 11110XXX |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$char = pack('C*', $ord_var_c, |
ord($var{$c + 1}), |
ord($var{$c + 2}), |
ord($var{$c + 3})); |
$c += 3; |
$utf16 = $this->utf82utf16($char); |
$ascii .= sprintf('\u%04s', bin2hex($utf16)); |
break; |
case (($ord_var_c & 0xFC) == 0xF8): |
// characters U-00200000 - U-03FFFFFF, mask 111110XX |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$char = pack('C*', $ord_var_c, |
ord($var{$c + 1}), |
ord($var{$c + 2}), |
ord($var{$c + 3}), |
ord($var{$c + 4})); |
$c += 4; |
$utf16 = $this->utf82utf16($char); |
$ascii .= sprintf('\u%04s', bin2hex($utf16)); |
break; |
case (($ord_var_c & 0xFE) == 0xFC): |
// characters U-04000000 - U-7FFFFFFF, mask 1111110X |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$char = pack('C*', $ord_var_c, |
ord($var{$c + 1}), |
ord($var{$c + 2}), |
ord($var{$c + 3}), |
ord($var{$c + 4}), |
ord($var{$c + 5})); |
$c += 5; |
$utf16 = $this->utf82utf16($char); |
$ascii .= sprintf('\u%04s', bin2hex($utf16)); |
break; |
} |
} |
return '"'.$ascii.'"'; |
case 'array': |
/* |
* As per JSON spec if any array key is not an integer |
* we must treat the the whole array as an object. We |
* also try to catch a sparsely populated associative |
* array with numeric keys here because some JS engines |
* will create an array with empty indexes up to |
* max_index which can cause memory issues and because |
* the keys, which may be relevant, will be remapped |
* otherwise. |
* |
* As per the ECMA and JSON specification an object may |
* have any string as a property. Unfortunately due to |
* a hole in the ECMA specification if the key is a |
* ECMA reserved word or starts with a digit the |
* parameter is only accessible using ECMAScript's |
* bracket notation. |
*/ |
// treat as a JSON object |
if (is_array($var) && count($var) && (array_keys($var) !== range(0, sizeof($var) - 1))) { |
return '{' . |
join(',', array_map(array($this, 'name_value'), |
array_keys($var), |
array_values($var))) |
. '}'; |
} |
// treat it like a regular array |
return '[' . join(',', array_map(array($this, 'encode'), $var)) . ']'; |
case 'object': |
$vars = get_object_vars($var); |
return '{' . |
join(',', array_map(array($this, 'name_value'), |
array_keys($vars), |
array_values($vars))) |
. '}'; |
default: |
return ''; |
} |
} |
/** |
* array-walking function for use in generating JSON-formatted name-value pairs |
* |
* @param string $name name of key to use |
* @param mixed $value reference to an array element to be encoded |
* |
* @return string JSON-formatted name-value pair, like '"name":value' |
* @access private |
*/ |
function name_value($name, $value) |
{ |
return $this->encode(strval($name)) . ':' . $this->encode($value); |
} |
/** |
* reduce a string by removing leading and trailing comments and whitespace |
* |
* @param $str string string value to strip of comments and whitespace |
* |
* @return string string value stripped of comments and whitespace |
* @access private |
*/ |
function reduce_string($str) |
{ |
$str = preg_replace(array( |
// eliminate single line comments in '// ...' form |
'#^\s*//(.+)$#m', |
// eliminate multi-line comments in '/* ... */' form, at start of string |
'#^\s*/\*(.+)\*/#Us', |
// eliminate multi-line comments in '/* ... */' form, at end of string |
'#/\*(.+)\*/\s*$#Us' |
), '', $str); |
// eliminate extraneous space |
return trim($str); |
} |
/** |
* decodes a JSON string into appropriate variable |
* |
* @param string $str JSON-formatted string |
* |
* @return mixed number, boolean, string, array, or object |
* corresponding to given JSON input string. |
* See argument 1 to Services_JSON() above for object-output behavior. |
* Note that decode() always returns strings |
* in ASCII or UTF-8 format! |
* @access public |
*/ |
function decode($str) |
{ |
$str = $this->reduce_string($str); |
switch (strtolower($str)) { |
case 'true': |
return true; |
case 'false': |
return false; |
case 'null': |
return null; |
default: |
if (is_numeric($str)) { |
// Lookie-loo, it's a number |
// This would work on its own, but I'm trying to be |
// good about returning integers where appropriate: |
// return (float)$str; |
// Return float or int, as appropriate |
return ((float)$str == (integer)$str) |
? (integer)$str |
: (float)$str; |
} elseif (preg_match('/^("|\').+(\1)$/s', $str, $m) && $m[1] == $m[2]) { |
// STRINGS RETURNED IN UTF-8 FORMAT |
$delim = substr($str, 0, 1); |
$chrs = substr($str, 1, -1); |
$utf8 = ''; |
$strlen_chrs = strlen($chrs); |
for ($c = 0; $c < $strlen_chrs; ++$c) { |
$substr_chrs_c_2 = substr($chrs, $c, 2); |
$ord_chrs_c = ord($chrs{$c}); |
switch (true) { |
case $substr_chrs_c_2 == '\b': |
$utf8 .= chr(0x08); |
++$c; |
break; |
case $substr_chrs_c_2 == '\t': |
$utf8 .= chr(0x09); |
++$c; |
break; |
case $substr_chrs_c_2 == '\n': |
$utf8 .= chr(0x0A); |
++$c; |
break; |
case $substr_chrs_c_2 == '\f': |
$utf8 .= chr(0x0C); |
++$c; |
break; |
case $substr_chrs_c_2 == '\r': |
$utf8 .= chr(0x0D); |
++$c; |
break; |
case $substr_chrs_c_2 == '\\"': |
case $substr_chrs_c_2 == '\\\'': |
case $substr_chrs_c_2 == '\\\\': |
case $substr_chrs_c_2 == '\\/': |
if (($delim == '"' && $substr_chrs_c_2 != '\\\'') || |
($delim == "'" && $substr_chrs_c_2 != '\\"')) { |
$utf8 .= $chrs{++$c}; |
} |
break; |
case preg_match('/\\\u[0-9A-F]{4}/i', substr($chrs, $c, 6)): |
//echo ' matching single escaped unicode character from ' . substr($chrs, $c, 6); |
// single, escaped unicode character |
$utf16 = chr(hexdec(substr($chrs, ($c + 2), 2))) |
. chr(hexdec(substr($chrs, ($c + 4), 2))); |
$utf8 .= $this->utf162utf8($utf16); |
$c += 5; |
break; |
case ($ord_chrs_c >= 0x20) && ($ord_chrs_c <= 0x7F): |
$utf8 .= $chrs{$c}; |
break; |
case ($ord_chrs_c & 0xE0) == 0xC0: |
// characters U-00000080 - U-000007FF, mask 110XXXXX |
//see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$utf8 .= substr($chrs, $c, 2); |
++$c; |
break; |
case ($ord_chrs_c & 0xF0) == 0xE0: |
// characters U-00000800 - U-0000FFFF, mask 1110XXXX |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$utf8 .= substr($chrs, $c, 3); |
$c += 2; |
break; |
case ($ord_chrs_c & 0xF8) == 0xF0: |
// characters U-00010000 - U-001FFFFF, mask 11110XXX |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$utf8 .= substr($chrs, $c, 4); |
$c += 3; |
break; |
case ($ord_chrs_c & 0xFC) == 0xF8: |
// characters U-00200000 - U-03FFFFFF, mask 111110XX |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$utf8 .= substr($chrs, $c, 5); |
$c += 4; |
break; |
case ($ord_chrs_c & 0xFE) == 0xFC: |
// characters U-04000000 - U-7FFFFFFF, mask 1111110X |
// see http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8 |
$utf8 .= substr($chrs, $c, 6); |
$c += 5; |
break; |
} |
} |
//>> SJM2005 |
if ($this->encoding == SERVICES_JSON_UTF_8) |
return $utf8; |
if ($this->encoding == SERVICES_JSON_ISO_8859_1) |
return utf8_decode($utf8); |
else if (!function_exists('mb_convert_encoding')) |
die('Requested encoding requires mb_strings extension.'); |
else |
return mb_convert_encoding($utf8, $this->encoding, SERVICES_JSON_UTF_8); |
//<< SJM2005 |
return $utf8; |
} elseif (preg_match('/^\[.*\]$/s', $str) || preg_match('/^\{.*\}$/s', $str)) { |
// array, or object notation |
if ($str{0} == '[') { |
$stk = array(SERVICES_JSON_IN_ARR); |
$arr = array(); |
} else { |
if ($this->use == SERVICES_JSON_LOOSE_TYPE) { |
$stk = array(SERVICES_JSON_IN_OBJ); |
$obj = array(); |
} else { |
$stk = array(SERVICES_JSON_IN_OBJ); |
$obj = new stdClass(); |
} |
} |
array_push($stk, array('what' => SERVICES_JSON_SLICE, |
'where' => 0, |
'delim' => false)); |
$chrs = substr($str, 1, -1); |
$chrs = $this->reduce_string($chrs); |
if ($chrs == '') { |
if (reset($stk) == SERVICES_JSON_IN_ARR) { |
return $arr; |
} else { |
return $obj; |
} |
} |
//print("\nparsing {$chrs}\n"); |
$strlen_chrs = strlen($chrs); |
for ($c = 0; $c <= $strlen_chrs; ++$c) { |
$top = end($stk); |
$substr_chrs_c_2 = substr($chrs, $c, 2); |
if (($c == $strlen_chrs) || (($chrs{$c} == ',') && ($top['what'] == SERVICES_JSON_SLICE))) { |
// found a comma that is not inside a string, array, etc., |
// OR we've reached the end of the character list |
$slice = substr($chrs, $top['where'], ($c - $top['where'])); |
array_push($stk, array('what' => SERVICES_JSON_SLICE, 'where' => ($c + 1), 'delim' => false)); |
//print("Found split at {$c}: ".substr($chrs, $top['where'], (1 + $c - $top['where']))."\n"); |
if (reset($stk) == SERVICES_JSON_IN_ARR) { |
// we are in an array, so just push an element onto the stack |
array_push($arr, $this->decode($slice)); |
} elseif (reset($stk) == SERVICES_JSON_IN_OBJ) { |
// we are in an object, so figure |
// out the property name and set an |
// element in an associative array, |
// for now |
if (preg_match('/^\s*(["\'].*[^\\\]["\'])\s*:\s*(\S.*),?$/Uis', $slice, $parts)) { |
// "name":value pair |
$key = $this->decode($parts[1]); |
$val = $this->decode($parts[2]); |
if ($this->use == SERVICES_JSON_LOOSE_TYPE) { |
$obj[$key] = $val; |
} else { |
$obj->$key = $val; |
} |
} elseif (preg_match('/^\s*(\w+)\s*:\s*(\S.*),?$/Uis', $slice, $parts)) { |
// name:value pair, where name is unquoted |
$key = $parts[1]; |
$val = $this->decode($parts[2]); |
if ($this->use == SERVICES_JSON_LOOSE_TYPE) { |
$obj[$key] = $val; |
} else { |
$obj->$key = $val; |
} |
} |
} |
} elseif ((($chrs{$c} == '"') || ($chrs{$c} == "'")) && ($top['what'] != SERVICES_JSON_IN_STR)) { |
// found a quote, and we are not inside a string |
array_push($stk, array('what' => SERVICES_JSON_IN_STR, 'where' => $c, 'delim' => $chrs{$c})); |
//print("Found start of string at {$c}\n"); |
//>> SAO2006 |
/*} elseif (($chrs{$c} == $top['delim']) && |
($top['what'] == SERVICES_JSON_IN_STR) && |
(($chrs{$c - 1} != '\\') || |
($chrs{$c - 1} == '\\' && $chrs{$c - 2} == '\\'))) {*/ |
} elseif ($chrs{$c} == $top['delim'] && |
$top['what'] == SERVICES_JSON_IN_STR) { |
//print("Found potential end of string at {$c}\n"); |
// verify quote is not escaped: it has no or an even number of \\ before it. |
for ($i=0; ($chrs{$c - ($i+1)} == '\\'); $i++); |
/*$i = 0; |
while ( $chrs{$c - ($i+1)} == '\\') |
$i++;*/ |
//print("Found {$i} \ before delim\n"); |
if ($i % 2 != 0) |
{ |
//print("delim escaped, not end of string\n"); |
continue; |
} |
//>> SAO2006 |
// found a quote, we're in a string, and it's not escaped |
array_pop($stk); |
//print("Found end of string at {$c}: ".substr($chrs, $top['where'], (1 + 1 + $c - $top['where']))."\n"); |
} elseif (($chrs{$c} == '[') && |
in_array($top['what'], array(SERVICES_JSON_SLICE, SERVICES_JSON_IN_ARR, SERVICES_JSON_IN_OBJ))) { |
// found a left-bracket, and we are in an array, object, or slice |
array_push($stk, array('what' => SERVICES_JSON_IN_ARR, 'where' => $c, 'delim' => false)); |
//print("Found start of array at {$c}\n"); |
} elseif (($chrs{$c} == ']') && ($top['what'] == SERVICES_JSON_IN_ARR)) { |
// found a right-bracket, and we're in an array |
array_pop($stk); |
//print("Found end of array at {$c}: ".substr($chrs, $top['where'], (1 + $c - $top['where']))."\n"); |
} elseif (($chrs{$c} == '{') && |
in_array($top['what'], array(SERVICES_JSON_SLICE, SERVICES_JSON_IN_ARR, SERVICES_JSON_IN_OBJ))) { |
// found a left-brace, and we are in an array, object, or slice |
array_push($stk, array('what' => SERVICES_JSON_IN_OBJ, 'where' => $c, 'delim' => false)); |
//print("Found start of object at {$c}\n"); |
} elseif (($chrs{$c} == '}') && ($top['what'] == SERVICES_JSON_IN_OBJ)) { |
// found a right-brace, and we're in an object |
array_pop($stk); |
//print("Found end of object at {$c}: ".substr($chrs, $top['where'], (1 + $c - $top['where']))."\n"); |
} elseif (($substr_chrs_c_2 == '/*') && |
in_array($top['what'], array(SERVICES_JSON_SLICE, SERVICES_JSON_IN_ARR, SERVICES_JSON_IN_OBJ))) { |
// found a comment start, and we are in an array, object, or slice |
array_push($stk, array('what' => SERVICES_JSON_IN_CMT, 'where' => $c, 'delim' => false)); |
$c++; |
//print("Found start of comment at {$c}\n"); |
} elseif (($substr_chrs_c_2 == '*/') && ($top['what'] == SERVICES_JSON_IN_CMT)) { |
// found a comment end, and we're in one now |
array_pop($stk); |
$c++; |
for ($i = $top['where']; $i <= $c; ++$i) |
$chrs = substr_replace($chrs, ' ', $i, 1); |
//print("Found end of comment at {$c}: ".substr($chrs, $top['where'], (1 + $c - $top['where']))."\n"); |
} |
} |
if (reset($stk) == SERVICES_JSON_IN_ARR) { |
return $arr; |
} elseif (reset($stk) == SERVICES_JSON_IN_OBJ) { |
return $obj; |
} |
} |
} |
} |
} |
/*function hex($s) |
{ |
$l = strlen($s); |
for ($i=0; $i < $l; $i++) |
//echo '['.(ord($s{$i})).']'; |
echo '['.bin2hex($s{$i}).']'; |
} |
//$d = '["hello world\\""]'; |
$d = '["\\\\\\"hello world,\\\\\\""]'; |
//$d = '["\\\\", "\\\\"]'; |
hex($d); |
$test = new Services_JSON(); |
echo('<pre>'); |
print_r($d . "\n"); |
print_r($test->decode($d)); |
echo('</pre>'); |
*/ |
?> |
/trunk/api/js/dojo1.0/dojox/grid/tests/support/testtbl.sql |
---|
New file |
0,0 → 1,944 |
/* |
MySQL Data Transfer |
Source Host: localhost |
Source Database: test |
Target Host: localhost |
Target Database: test |
Date: 12/14/2006 12:13:30 PM |
*/ |
SET FOREIGN_KEY_CHECKS=0; |
-- ---------------------------- |
-- Table structure for testtbl |
-- ---------------------------- |
CREATE TABLE `testtbl` ( |
`Id` int(10) unsigned NOT NULL, |
`Name` varchar(45) NOT NULL default '', |
`Message` varchar(255) default NULL, |
`Date` date default '2005-01-01', |
PRIMARY KEY (`Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 4096 kB; InnoDB free: 4096 kB; InnoDB free: 409'; |
-- ---------------------------- |
-- Records |
-- ---------------------------- |
INSERT INTO `testtbl` VALUES ('363', ' Lopez, Felipe', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('364', ' Lopez, Javy', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('365', ' Lopez, L', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('366', ' Lopez, Luis', ' 0.244', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('367', ' Lopez, Mendy', ' 0.241', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('368', ' Loretta, Mark', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('369', ' Lowell, Mike', ' 0.283', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('370', ' Lugo, Julio', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('371', ' Lunar, Fernando', ' 0.246', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('372', ' Mabry, John', ' 0.208', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('373', ' Machado, Robert', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('374', ' Macias, Jose', ' 0.268', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('375', ' Mackowiak, Rob', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('376', ' Magadan, Dave', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('377', ' Magee, Wendell', ' 0.213', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('378', ' Magruder, Chris', ' 0.172', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('379', ' Marrero, Eli', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('380', ' Martin, Al', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('381', ' Martinez, Dave', ' 0.287', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('382', ' Martinez, Edgar', ' 0.306', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('383', ' Martinez, Felix', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('384', ' Martinez, Ramon', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('385', ' Martinez, Ramone', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('386', ' Martinez, Sandy', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('387', ' Martinez, Tino', ' 0.28', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('388', ' Mateo, Henry', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('389', ' Mateo, Ruben', ' 0.248', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('390', ' Matheny, Mike', ' 0.218', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('391', ' Matos, Luis', ' 0.214', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('392', ' Mattess, Troy', ' 0.467', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('393', ' Matthews, Gary', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('394', ' Maurer, Dave', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('395', ' Maxwell, Jason', ' 0.191', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('396', ' Mayne, Brent', ' 0.285', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('397', ' McCarty, David', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('398', ' McCracken, Quinton', ' 0.219', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('399', ' McDonald, Donzell', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('400', ' McDonald, John', ' 0.091', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('401', ' McDonald, Keith', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('402', ' McEwing, Joe', ' 0.283', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('403', ' McGriff, Fred', ' 0.306', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('404', ' McGuire, Ryan', ' 0.185', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('405', ' McGwire, Mark', ' 0.187', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('406', ' McLemore, Mark', ' 0.286', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('407', ' McMillon, Billy', ' 0.217', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('408', ' McRae, Scott', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('409', ' Meares, Pat', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('410', ' Melhuse, Adam', ' 0.183', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('411', ' Mendez, Donaldo', ' 0.153', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('412', ' Menechino, Frank', ' 0.242', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('413', ' Merced, Orlando', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('414', ' Merloni, Lou', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('415', ' Meyers, Chad', ' 0.118', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('416', ' Michaels, Jason', ' 0.167', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('417', ' Mientkiewicz, Doug', ' 0.306', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('418', ' Millar, Kevin', ' 0.314', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('419', ' Miller, Corky', ' 0.184', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('420', ' Miller, Damian', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('421', ' Minor, Damion', ' 0.156', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('422', ' Minor, Ryan', ' 0.158', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('423', ' Mirabelli, Doug', ' 0.226', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('424', ' Moeller, Chad', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('425', ' Mohr, Dustan', ' 0.235', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('426', ' Molina, Ben', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('427', ' Molina, Jose', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('428', ' Mondesi, Raul', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('429', ' Monroe, Craig', ' 0.212', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('430', ' Mora, Melvin', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('431', ' Mordecai, Mike', ' 0.28', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('432', ' Morris, Warren', ' 0.204', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('433', ' Mottola, Chad', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('434', ' Mouton, James', ' 0.246', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('435', ' Mouton, Lyle', ' 0.059', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('436', ' Mueller, Bill', ' 0.295', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('437', ' Munson, Eric', ' 0.152', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('438', ' Murray, Calvin', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('439', ' Myers, Greg', ' 0.224', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('440', ' Nevin, Phil', ' 0.306', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('441', ' Newhan, David', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('442', ' Nieves, Jose', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('443', ' Nixon, Trot', ' 0.28', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('444', ' Norton, Greg', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('445', ' Nunez, Abraham', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('446', ' Ochoa, Alex', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('447', ' Offerman, Jose', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('448', ' Ojeda, Augie', ' 0.201', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('449', ' O\\\'Leary, Troy', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('450', ' Olerud, John', ' 0.302', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('451', ' Oliver, Joe', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('452', ' O\\\'Neill, Paul', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('453', ' Ordaz, Luis', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('454', ' Ordonez, Magglio', ' 0.305', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('455', ' Ordonez, Rey', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('456', ' Ortega, Bill', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('457', ' Ortiz, David', ' 0.234', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('458', ' Ortiz, Hector', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('459', ' Ortiz, Jose', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('460', ' Osik, Keith', ' 0.208', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('461', ' Overbay, Lyle', ' 0.5', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('462', ' Owens, Eric', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('463', ' Palmeiro, Orlando', ' 0.243', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('464', ' Palmeiro, Rafael', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('465', ' Palmer, Dean', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('466', ' Paquette, Craig', ' 0.282', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('467', ' Patterson, Corey', ' 0.221', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('468', ' Patterson, Jarrod', ' 0.268', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('469', ' Paul, Josh', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('470', ' Payton, Jay', ' 0.255', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('471', ' Pena, Angel', ' 0.204', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('472', ' Pena, Carlos', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('473', ' Pena, Elvis', ' 0.225', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('474', ' Perez, Eddie', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('475', ' Perez, Neifi', ' 0.279', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('476', ' Perez, Robert', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('477', ' Perez, Santiago', ' 0.198', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('478', ' Perez, Thomas', ' 0.304', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('479', ' Perez, Timoniel', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('480', ' Perry, Herbert', ' 0.256', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('481', ' Peters, Chris', ' 0.091', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('482', ' Petrick, Ben', ' 0.238', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('483', ' Phelps, Josh', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('484', ' Phillips, Jason', ' 0.143', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('485', ' Piatt, Adam', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('486', ' Piazza, Mike', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('487', ' Pickering, Calvin', ' 0.278', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('488', ' Pierre, Juan', ' 0.327', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('489', ' Pierzynski, A.J.', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('490', ' Podsednik, Scott', ' 0.167', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('491', ' Polanco, Placido', ' 0.307', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('492', ' Porter, Bo', ' 0.23', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('493', ' Posada, Jorge', ' 0.277', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('494', ' Powell, Dante', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('495', ' Pratt, Todd', ' 0.185', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('496', ' Pride, Curtis', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('497', ' Prince, Tom', ' 0.219', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('498', ' Pujols, Albert', ' 0.329', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('499', ' Punto, Nick', ' 0.4', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('500', ' Quevado, Ruben', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('501', ' Quinn, Mark', ' 0.269', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('502', ' Raines, Tim', ' 0.174', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('503', ' Raines, Tim', ' 0.303', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('504', ' Ramirez, Aramis', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('505', ' Ramirez, Julio', ' 0.081', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('506', ' Ramirez, Manny', ' 0.306', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('507', ' Randa, Joe', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('508', ' Ransom, Cody', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('509', ' Reboulet, Jeff', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('510', ' Redman, Tim', ' 0.224', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('511', ' Redmond, Mike', ' 0.312', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('512', ' Reese, Pokey', ' 0.224', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('513', ' Relaford, Desi', ' 0.302', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('514', ' Renteria, Edgar', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('515', ' Richard, Chris', ' 0.265', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('516', ' Riggs, Adam', ' 0.194', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('517', ' Rios, Armando', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('518', ' Ripken, Cal', ' 0.239', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('519', ' Rivas, Luis', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('520', ' Rivera, Juan', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('521', ' Rivera, Mike', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('522', ' Rivera, Ruben', ' 0.255', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('523', ' Roberts, Brian', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('524', ' Roberts, Dave', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('525', ' Robinson, Kerry', ' 0.285', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('526', ' Rodriguez, Alex', ' 0.318', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('527', ' Rodriguez, Henry', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('528', ' Rodriguez, Ivan', ' 0.308', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('529', ' Rolen, Scott', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('530', ' Rollins, Jimmy', ' 0.274', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('531', ' Rolls, Damian', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('532', ' Rowand, Aaron', ' 0.293', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('533', ' Ruffin, Johnny', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('534', ' Ryan, Rob', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('535', ' Sadler, Donnie', ' 0.162', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('536', ' Saenz, Olmedo', ' 0.22', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('537', ' Salmon, Tim', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('538', ' Sanchez, Alex', ' 0.206', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('539', ' Sanchez, Rey', ' 0.281', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('540', ' Sandberg, Jared', ' 0.206', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('541', ' Sanders, Anthony', ' 0.176', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('542', ' Sanders, Deion', ' 0.173', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('543', ' Sanders, Reggie', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('544', ' Santana, Pedro', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('545', ' Santangelo, F.P.', ' 0.197', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('546', ' Santiago, Benito', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('547', ' Santos, Angel', ' 0.125', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('548', ' Saturria, Luis', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('549', ' Schneider, Brian', ' 0.317', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('550', ' Schourek, Pete', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('551', ' Seabol, Scott', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('552', ' Sefcik, Kevin', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('553', ' Segui, David', ' 0.301', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('554', ' Seguignol, Fernando', ' 0.14', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('555', ' Selby, Bill', ' 0.228', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('556', ' Servais, Scott', ' 0.375', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('557', ' Sexson, Richie', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('558', ' Sheets, Andy', ' 0.196', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('559', ' Sheffield, Gary', ' 0.311', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('560', ' Sheldon, Scott', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('561', ' Shinjo, Tsuyoshi', ' 0.268', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('562', ' Shumpert, Terry', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('563', ' Sierra, Ruben', ' 0.291', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('564', ' Simmons, Brian', ' 0.178', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('565', ' Simon, Randall', ' 0.305', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('566', ' Singleton, Chris', ' 0.298', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('567', ' Smith, Bobby', ' 0.105', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('568', ' Smith, Jason', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('569', ' Smith, Mark', ' 0.242', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('570', ' Snow, J.T.', ' 0.246', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('571', ' Sojo, Luis', ' 0.165', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('572', ' Soriano, Alfonso', ' 0.268', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('573', ' Sosa, Juan', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('574', ' Sosa, Sammy', ' 0.328', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('575', ' Spencer, Shane', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('576', ' Spiers, Bill', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('577', ' Spiezio, Scott', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('578', ' Spivey, Junior', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('579', ' Sprague, Ed', ' 0.298', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('580', ' Stairs, Matt', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('581', ' Stevens, Lee', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('582', ' Stewart, Shannon', ' 0.316', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('583', ' Stinnett, Kelly', ' 0.257', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('584', ' Stynes, Chris', ' 0.28', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('585', ' Surhoff, B.J.', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('586', ' Sutton, Larry', ' 0.119', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('587', ' Suzuki, Ichiro', ' 0.35', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('588', ' Sweeney, Mark', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('589', ' Sweeney, Mike', ' 0.304', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('590', ' Tapani, Kevin', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('591', ' Tatis, Fernando', ' 0.255', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('592', ' Taubensee, Eddie', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('593', ' Taylor, Reggie', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('594', ' Tejada, Miguel', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('595', ' Thomas, Frank', ' 0.221', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('596', ' Thome, Jim', ' 0.291', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('597', ' Thompson, Ryan', ' 0.29', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('598', ' Toca, Jorge', ' 0.176', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('599', ' Torrealba, Steve', ' 0.5', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('600', ' Torrealba, Yorvit', ' 0.5', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('601', ' Tracy, Andy', ' 0.109', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('602', ' Trammell, Bubba', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('603', ' Truby, Chris', ' 0.206', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('604', ' Tucker, Michael', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('605', ' Tyner, Jason', ' 0.28', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('606', ' Uribe, Juan', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('607', ' Valdez, Mario', ' 0.278', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('608', ' Valent, Eric', ' 0.098', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('609', ' Valentin, John', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('610', ' Valentin, Jose', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('611', ' VanderWal, John', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('612', ' Varitek, Jason', ' 0.293', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('613', ' Vaughn, Greg', ' 0.233', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('614', ' Vazquez, Ramon', ' 0.229', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('615', ' Velandia, Jorge', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('616', ' Velarde, Randy', ' 0.278', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('617', ' Ventura, Robin', ' 0.237', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('618', ' Veras, Quilvio', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('619', ' Vidro, Jose', ' 0.319', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('620', ' Vina, Fernando', ' 0.303', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('621', ' Vizcaino, Jose', ' 0.277', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('622', ' Vizquel, Omar', ' 0.255', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('623', ' Wakeland, Chris', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('624', ' Walbeck, Matt', ' 1', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('625', ' Walker, Larry', ' 0.35', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('626', ' Walker, Todd', ' 0.296', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('627', ' Ward, Daryle', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('628', ' Ward, Turner', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('629', ' Wehner, John', ' 0.196', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('630', ' Wells, Vernon', ' 0.313', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('631', ' White, Devon', ' 0.277', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('632', ' White, Rondell', ' 0.307', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('633', ' Whiteside, Matt', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('634', ' Wilkerson, Brad', ' 0.205', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('635', ' Wilkins, Rick', ' 0.182', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('636', ' Williams, Bernie', ' 0.307', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('637', ' Williams, Gerald', ' 0.201', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('638', ' Williams, Matt', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('639', ' Wilson, Craig', ' 0.31', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('640', ' Wilson, Dan', ' 0.265', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('641', ' Wilson, Enrique', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('642', ' Wilson, Jack', ' 0.223', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('643', ' Wilson, Preston', ' 0.274', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('644', ' Wilson, Tom', ' 0.19', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('645', ' Wilson, Vance', ' 0.298', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('646', ' Winn, Randy', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('647', ' Witt, Kevin', ' 0.185', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('648', ' Womack, Tony', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('649', ' Woodward, Chris', ' 0.19', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('650', ' Wooten, Shawn', ' 0.312', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('651', ' Young, Dmitri', ' 0.302', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('652', ' Young, Eric', ' 0.279', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('653', ' Young, Kevin', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('654', ' Young, Mike', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('655', ' Zaun, Greg', ' 0.32', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('656', ' Zeile, Todd', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('657', ' Zuleta, Julio', ' 0.217', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('658', ' Abernathy, Brent', ' 0.242', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('659', ' Abreu, Bob', ' 0.308', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('660', ' Agbayani, Benny', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('661', ' Alcantara, Israel', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('662', ' Aldridge, Cory', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('663', ' Alfonzo, Edgardo', ' 0.308', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('664', ' Alicea, Luis', ' 0.228', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('665', ' Allen, Chad', ' 0.1', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('666', ' Allen, Luke', ' 0.143', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('667', ' Alomar, Roberto', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('668', ' Alomar, Sandy', ' 0.279', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('669', ' Alou, Moises', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('670', ' Alvarez, Tony', ' 0.308', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('671', ' Amezaga, Alfredo', ' 0.538', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('672', ' Anderson, Brady', ' 0.163', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('673', ' Anderson, Garret', ' 0.306', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('674', ' Anderson, Marlon', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('675', ' Andrews, Shane', ' 0.077', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('676', ' Arias, Alex', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('677', ' Aurilia, Rich', ' 0.257', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('678', ' Ausmus, Brad', ' 0.257', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('679', ' Aven, Bruce', ' 0.118', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('680', ' Baerga, Carlos', ' 0.286', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('681', ' Bagwell, Jeff', ' 0.291', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('682', ' Bako, Paul', ' 0.235', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('683', ' Banks, Brian', ' 0.321', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('684', ' Barajas, Rod', ' 0.234', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('685', ' Bard, Josh', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('686', ' Barker, Kevin', ' 0.158', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('687', ' Barrett, Michael', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('688', ' Batista, Tony', ' 0.244', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('689', ' Bautista, Danny', ' 0.325', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('690', ' Bell, David', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('691', ' Bell, Jay', ' 0.163', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('692', ' Belle, Albert', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('693', ' Bellhorn, Mark', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('694', ' Belliard, Ron', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('695', ' Bellinger, Clay', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('696', ' Beltran, Carlos', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('697', ' Beltre, Adrian', ' 0.257', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('698', ' Benard, Marvin', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('699', ' Benjamin, Mike', ' 0.15', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('700', ' Bennett, Gary', ' 0.265', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('701', ' Berg, David', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('702', ' Berger, Brandon', ' 0.201', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('703', ' Bergeron, Peter', ' 0.187', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('704', ' Berkman, Lance', ' 0.292', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('705', ' Berroa, Angel', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('706', ' Bigbie, Larry', ' 0.176', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('707', ' Biggio, Craig', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('708', ' Blake, Casey', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('709', ' Blalock, Hank', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('710', ' Blanco, Henry', ' 0.204', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('711', ' Bloomquist, Willie', ' 0.455', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('712', ' Blum, Geoff', ' 0.283', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('713', ' Bocachica, Hiram', ' 0.22', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('714', ' Bonds, Barry', ' 0.37', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('715', ' Boone, Aaron', ' 0.241', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('716', ' Boone, Bret', ' 0.278', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('717', ' Borchard, Joe', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('718', ' Borders, Pat', ' 0.5', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('719', ' Bordick, Mike', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('720', ' Bradley, Milton', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('721', ' Bragg, Darren', ' 0.269', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('722', ' Branyan, Russell', ' 0.228', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('723', ' Brito, Juan', ' 0.304', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('724', ' Broussard, Ben', ' 0.241', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('725', ' Brown, Adrian', ' 0.216', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('726', ' Brown, Dermal', ' 0.235', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('727', ' Brown, Kevin', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('728', ' Brown, Roosevelt', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('729', ' Buchanan, Brian', ' 0.269', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('730', ' Burks, Ellis', ' 0.301', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('731', ' Burnitz, Jeromy', ' 0.215', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('732', ' Burrell, Pat', ' 0.282', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('733', ' Burroughs, Sean', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('734', ' Bush, Homer', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('735', ' Butler, Brent', ' 0.259', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('736', ' Byrd, Marlon', ' 0.229', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('737', ' Byrnes, Eric', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('738', ' Cabrera, Jolbert', ' 0.143', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('739', ' Cabrera, Orlando', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('740', ' Cairo, Miguel', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('741', ' Cameron, Mike', ' 0.239', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('742', ' Canizaro, Jay', ' 0.214', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('743', ' Cardona, Javier', ' 0.103', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('744', ' Carroll, Jamey', ' 0.31', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('745', ' Caruso, Mike', ' 0.1', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('746', ' Casanova, Raul', ' 0.182', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('747', ' Casey, Sean', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('748', ' Cash, Kevin', ' 0.143', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('749', ' Castilla, Vinny', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('750', ' Castillo, Alberto', ' 0.135', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('751', ' Castillo, Luis', ' 0.305', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('752', ' Castro, Juan', ' 0.22', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('753', ' Castro, Ramon', ' 0.238', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('754', ' Catalanotto, Frank', ' 0.269', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('755', ' Cedeno, Roger', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('756', ' Cepicky, Matt', ' 0.216', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('757', ' Chavez, Endy', ' 0.296', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('758', ' Chavez, Eric', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('759', ' Chavez, Raul', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('760', ' Chen, Chin-Feng', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('761', ' Choi, Hee Seop', ' 0.18', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('762', ' Christensen, McKay', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('763', ' Christenson, Ryan', ' 0.155', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('764', ' Cintron, Alex', ' 0.213', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('765', ' Cirillo, Jeff', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('766', ' Clark, Brady', ' 0.192', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('767', ' Clark, Howie', ' 0.302', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('768', ' Clark, Tony', ' 0.207', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('769', ' Clayton, Royce', ' 0.251', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('770', ' Colangelo, Mike', ' 0.174', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('771', ' Colbrunn, Greg', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('772', ' Coleman, Michael', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('773', ' Collier, Lou', ' 0.091', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('774', ' Conine, Jeff', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('775', ' Conti, Jason', ' 0.257', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('776', ' Coolbaugh, Mike', ' 0.083', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('777', ' Coomer, Ron', ' 0.264', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('778', ' Cora, Alex', ' 0.291', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('779', ' Cordero, Wil', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('780', ' Cordova, Marty', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('781', ' Cota, Humberto', ' 0.294', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('782', ' Counsell, Craig', ' 0.282', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('783', ' Cox, Steve', ' 0.254', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('784', ' Crawford, Carl', ' 0.259', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('785', ' Crede, Joe', ' 0.285', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('786', ' Crespo, Cesar', ' 0.172', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('787', ' Crisp, Covelli', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('788', ' Cruz, Deivi', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('789', ' Cruz, Ivan', ' 0.357', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('790', ' Cruz, Jacob', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('791', ' Cruz, Jose', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('792', ' Cuddyer, Michael', ' 0.259', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('793', ' Cust, Jack', ' 0.169', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('794', ' Damon, Johnny', ' 0.286', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('795', ' Daubach, Brian', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('796', ' DaVanon, Jeff', ' 0.167', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('797', ' Davis, Ben', ' 0.259', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('798', ' Davis, J.J.', ' 0.1', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('799', ' Dawkins, Travis', ' 0.125', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('800', ' DeHaan, Kory', ' 0.091', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('801', ' Delgado, Carlos', ' 0.277', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('802', ' Delgado, Wilson', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('803', ' Dellucci, David', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('804', ' DeRosa, Mark', ' 0.297', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('805', ' DeShields, Delino', ' 0.192', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('806', ' Diaz, Einar', ' 0.206', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('807', ' Diaz, Juan Carlos', ' 0.286', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('808', ' DiFelice, Mike', ' 0.23', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('809', ' Donnels, Chris', ' 0.238', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('810', ' Drew, J.D.', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('811', ' Dunn, Adam', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('812', ' Dunston, Shawon', ' 0.231', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('813', ' Dunwoody, Todd', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('814', ' Durazo, Erubiel', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('815', ' Durham, Ray', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('816', ' Dye, Jermaine', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('817', ' Easley, Damion', ' 0.224', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('818', ' Echevarria, Angel', ' 0.306', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('819', ' Eckstein, David', ' 0.293', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('820', ' Edmonds, Jim', ' 0.311', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('821', ' Ellis, Mark', ' 0.272', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('822', ' Encarnacion, Juan', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('823', ' Encarnacion, Mario', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('824', ' Ensberg, Morgan', ' 0.242', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('825', ' Erstad, Darin', ' 0.283', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('826', ' Escalona, Felix', ' 0.217', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('827', ' Escobar, Alex', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('828', ' Estalella, Bobby', ' 0.205', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('829', ' Estrada, Johnny', ' 0.118', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('830', ' Everett, Adam', ' 0.193', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('831', ' Everett, Carl', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('832', ' Fabregas, Jorge', ' 0.181', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('833', ' Fasano, Sal', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('834', ' Febles, Carlos', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('835', ' Feliz, Pedro', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('836', ' Fick, Robert', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('837', ' Figgins, Chone', ' 0.167', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('838', ' Finley, Steve', ' 0.287', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('839', ' Flaherty, John', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('840', ' Fletcher, Darrin', ' 0.22', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('841', ' Flores, Jose', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('842', ' Floyd, Cliff', ' 0.288', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('843', ' Fordyce, Brook', ' 0.231', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('844', ' Fox, Andy', ' 0.251', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('845', ' Franco, Julio', ' 0.284', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('846', ' Franco, Matt', ' 0.317', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('847', ' Fryman, Travis', ' 0.217', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('848', ' Fullmer, Brad', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('849', ' Furcal, Rafael', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('850', ' Galarraga, Andres', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('851', ' Gant, Ron', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('852', ' Garcia, Jesse', ' 0.197', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('853', ' Garcia, Karim', ' 0.297', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('854', ' Garcia, Luis', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('855', ' Garciaparra, Nomar', ' 0.31', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('856', ' German, Esteban', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('857', ' Giambi, Jason', ' 0.314', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('858', ' Giambi, Jeremy', ' 0.259', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('859', ' Gibbons, Jay', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('860', ' Gil, Benji', ' 0.285', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('861', ' Gil, Geronimo', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('862', ' Giles, Brian', ' 0.298', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('863', ' Giles, Marcus', ' 0.23', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('864', ' Ginter, Keith', ' 0.235', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('865', ' Gipson, Charles', ' 0.236', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('866', ' Girardi, Joe', ' 0.226', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('867', ' Glanville, Doug', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('868', ' Glaus, Troy', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('869', ' Gload, Ross', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('870', ' Gomez, Alexis', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('871', ' Gomez, Chris', ' 0.265', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('872', ' Gonzalez, Alex', ' 0.225', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('873', ' Gonzalez, Alex', ' 0.248', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('874', ' Gonzalez, Juan', ' 0.282', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('875', ' Gonzalez, Luis', ' 0.288', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('876', ' Gonzalez, Raul', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('877', ' Gonzalez, Wiki', ' 0.22', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('878', ' Goodwin, Tom', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('879', ' Grabowski, Jason', ' 0.375', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('880', ' Grace, Mark', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('881', ' Graffanino, Tony', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('882', ' Green, Nick', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('883', ' Green, Shawn', ' 0.285', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('884', ' Greene, Todd', ' 0.268', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('885', ' Greer, Rusty', ' 0.296', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('886', ' Grieve, Ben', ' 0.251', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('887', ' Griffey, Ken', ' 0.264', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('888', ' Grissom, Marquis', ' 0.277', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('889', ' Grudzielanek, Mark', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('890', ' Guerrero, Vladimir', ' 0.336', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('891', ' Guerrero, Wilton', ' 0.221', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('892', ' Guiel, Aaron', ' 0.233', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('893', ' Guillen, Carlos', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('894', ' Guillen, Jose', ' 0.238', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('895', ' Gutierrez, Ricky', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('896', ' Guzman, Christian', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('897', ' Hafner, Travis', ' 0.242', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('898', ' Hairston, Jerry', ' 0.268', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('899', ' Hall, Bill', ' 0.194', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('900', ' Hall, Toby', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('901', ' Halter, Shane', ' 0.239', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('902', ' Hammonds, Jeffrey', ' 0.257', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('903', ' Hansen, Dave', ' 0.292', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('904', ' Harris, Lenny', ' 0.305', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('905', ' Harris, Willie', ' 0.233', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('906', ' Hart, Jason', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('907', ' Haselman, Bill', ' 0.246', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('908', ' Hatteberg, Scott', ' 0.28', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('909', ' Helms, Wes', ' 0.243', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('910', ' Helton, Todd', ' 0.329', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('911', ' Henderson, Rickey', ' 0.223', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('912', ' Henson, Drew', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('913', ' Hermansen, Chad', ' 0.207', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('914', ' Hernandez, Jose', ' 0.288', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('915', ' Hernandez, Ramon', ' 0.233', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('916', ' Hidalgo, Richard', ' 0.235', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('917', ' Higginson, Bobby', ' 0.282', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('918', ' Hill, Bobby', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('919', ' Hillenbrand, Shea', ' 0.293', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('920', ' Hinch, A.J.', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('921', ' Hinske, Eric', ' 0.279', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('922', ' Hocking, Denny', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('923', ' Hollandsworth, Todd', ' 0.284', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('924', ' Hollins, Dave', ' 0.118', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('925', ' Hoover, Paul', ' 0.176', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('926', ' Houston, Tyler', ' 0.281', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('927', ' Hubbard, Trenidad', ' 0.209', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('928', ' Huckaby, Ken', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('929', ' Hudson, Orlando', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('930', ' Huff, Aubrey', ' 0.313', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('931', ' Hundley, Todd', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('932', ' Hunter, Brian L.', ' 0.269', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('933', ' Hunter, Torii', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('934', ' Hyzdu, Adam', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('935', ' Ibanez, Raul', ' 0.294', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('936', ' Infante, Omar', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('937', ' Inge, Brandon', ' 0.202', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('938', ' Izturis, Cesar', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('939', ' Jackson, Damian', ' 0.257', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('940', ' Jackson, Ryan', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('941', ' Jenkins, Geoff', ' 0.243', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('942', ' Jensen, Marcus', ' 0.114', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('943', ' Jeter, Derek', ' 0.297', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('944', ' Jimenez, D\\\'Angelo', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('945', ' Johnson, Charles', ' 0.217', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('946', ' Johnson, Mark', ' 0.209', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('947', ' Johnson, Mark P.', ' 0.137', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('948', ' Johnson, Nick', ' 0.243', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('949', ' Johnson, Russ', ' 0.216', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('950', ' Jones, Andruw', ' 0.264', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('951', ' Jones, Chipper', ' 0.327', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('952', ' Jones, Jacque', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('953', ' Jordan, Brian', ' 0.285', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('954', ' Jose, Felix', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('955', ' Justice, David', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('956', ' Kapler, Gabe', ' 0.279', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('957', ' Karros, Eric', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('958', ' Kearns, Austin', ' 0.315', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('959', ' Kelly, Kenny', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('960', ' Kendall, Jason', ' 0.283', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('961', ' Kennedy, Adam', ' 0.312', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('962', ' Kent, Jeff', ' 0.313', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('963', ' Kielty, Bobby', ' 0.291', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('964', ' Kingsale, Eugene', ' 0.283', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('965', ' Kinkade, Mike', ' 0.38', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('966', ' Klassen, Danny', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('967', ' Klesko, Ryan', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('968', ' Knoblauch, Chuck', ' 0.21', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('969', ' Konerko, Paul', ' 0.304', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('970', ' Koskie, Corey', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('971', ' Kotsay, Mark', ' 0.292', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('972', ' Kreuter, Chad', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('973', ' Lamb, David', ' 0.1', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('974', ' Lamb, Mike', ' 0.283', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('975', ' Lampkin, Tom', ' 0.217', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('976', ' Lane, Jason', ' 0.29', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('977', ' Langerhans, Ryan', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('978', ' Lankford, Ray', ' 0.224', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('979', ' Larkin, Barry', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('980', ' LaRocca, Greg', ' 0.269', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('981', ' Larson, Brandon', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('982', ' LaRue, Jason', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('983', ' Lawrence, Joe', ' 0.18', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('984', ' Lawton, Matt', ' 0.236', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('985', ' LeCroy, Matt', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('986', ' Ledee, Ricky', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('987', ' Lee, Carlos', ' 0.264', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('988', ' Lee, Derrek', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('989', ' Lee, Travis', ' 0.265', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('990', ' Leon, Jose', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('991', ' Lesher, Brian', ' 0.132', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('992', ' Lewis, Darren', ' 0.241', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('993', ' Lieberthal, Mike', ' 0.279', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('994', ' Liefer, Jeff', ' 0.23', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('995', ' Little, Mark', ' 0.208', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('996', ' Lo Duca, Paul', ' 0.281', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('997', ' Lockhart, Keith', ' 0.216', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('998', ' Lofton, Kenny', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('999', ' Lombard, George', ' 0.241', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1000', ' Long, Terrence', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1001', ' Lopez, Felipe', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1002', ' Lopez, Javy', ' 0.233', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1003', ' Lopez, Luis', ' 0.197', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1004', ' Lopez, Mendy', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1005', ' Loretta, Mark', ' 0.304', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1006', ' Lowell, Mike', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1007', ' Ludwick, Ryan', ' 0.235', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1008', ' Lugo, Julio', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1009', ' Lunar, Fernando', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1010', ' Lunsford, Trey', ' 0.667', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1011', ' Mabry, John', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1012', ' Machado, Robert', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1013', ' Macias, Jose', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1014', ' Mackowiak, Rob', ' 0.244', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1015', ' Magee, Wendell', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1016', ' Magruder, Chris', ' 0.217', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1017', ' Mahoney, Mike', ' 0.207', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1018', ' Malloy, Marty', ' 0.12', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1019', ' Marrero, Eli', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1020', ' Martinez, Dave', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1021', ' Martinez, Edgar', ' 0.277', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1022', ' Martinez, Ramon', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1023', ' Martinez, Tino', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1024', ' Martinez, Victor', ' 0.281', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1025', ' Mateo, Henry', ' 0.174', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1026', ' Mateo, Ruben', ' 0.256', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1027', ' Matheny, Mike', ' 0.244', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1028', ' Matos, Julios', ' 0.238', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1029', ' Matos, Luis', ' 0.129', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1030', ' Matthews, Gary', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1031', ' Mayne, Brent', ' 0.236', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1032', ' McCarty, David', ' 0.136', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1033', ' McCracken, Quinton', ' 0.309', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1034', ' McDonald, Donzell', ' 0.182', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1035', ' McDonald, John', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1036', ' McEwing, Joe', ' 0.199', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1037', ' McGriff, Fred', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1038', ' McGuire, Ryan', ' 0.077', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1039', ' McKay, Cody', ' 0.667', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1040', ' McKeel, Walt', ' 0.308', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1041', ' McLemore, Mark', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1042', ' Meares, Pat', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1043', ' Meluskey, Mitch', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1044', ' Mench, Kevin', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1045', ' Menechino, Frank', ' 0.205', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1046', ' Merced, Orlando', ' 0.287', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1047', ' Merloni, Lou', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1048', ' Michaels, Jason', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1049', ' Mientkiewicz, Doug', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1050', ' Millar, Kevin', ' 0.306', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1051', ' Miller, Corky', ' 0.254', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1052', ' Miller, Damian', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1053', ' Minor, Damon', ' 0.237', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1054', ' Mirabelli, Doug', ' 0.225', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1055', ' Moeller, Chad', ' 0.286', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1056', ' Mohr, Dustan', ' 0.269', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1057', ' Molina, Ben', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1058', ' Molina, Izzy', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1059', ' Molina, Jose', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1060', ' Mondesi, Raul', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1061', ' Monroe, Craig', ' 0.12', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1062', ' Mora, Melvin', ' 0.233', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1063', ' Mordecai, Mike', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1064', ' Moriarty, Mike', ' 0.188', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1065', ' Morris, Warren', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1066', ' Mueller, Bill', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1067', ' Munson, Eric', ' 0.186', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1068', ' Murray, Calvin', ' 0.146', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1069', ' Myers, Greg', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1070', ' Nelson, Bryant', ' 0.265', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1071', ' Nevin, Phil', ' 0.285', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1072', ' Nieves, Jose', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1073', ' Nieves, Wil', ' 0.181', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1074', ' Nixon, Trot', ' 0.256', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1075', ' Norton, Greg', ' 0.22', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1076', ' Nunez, Abraham', ' 0.233', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1077', ' Nunez, Abraham', ' 0.118', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1078', ' O\\\'Leary, Troy', ' 0.286', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1079', ' Ochoa, Alex', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1080', ' Offerman, Jose', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1081', ' Ojeda, Augie', ' 0.186', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1082', ' Olerud, John', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1083', ' Olivo, Miguel', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1084', ' Ordaz, Luis', ' 0.223', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1085', ' Ordonez, Magglio', ' 0.32', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1086', ' Ordonez, Rey', ' 0.254', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1087', ' Orie, Kevin', ' 0.281', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1088', ' Ortiz, David', ' 0.272', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1089', ' Ortiz, Hector', ' 0.214', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1090', ' Ortiz, Jose', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1091', ' Osik, Keith', ' 0.16', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1092', ' Overbay, Lyle', ' 0.1', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1093', ' Owens, Eric', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1094', ' Ozuna, Pablo', ' 0.277', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1095', ' Palmeiro, Orlando', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1096', ' Palmeiro, Rafael', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1097', ' Palmer, Dean', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1098', ' Paquette, Craig', ' 0.194', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1099', ' Patterson, Corey', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1100', ' Paul, Josh', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1101', ' Payton, Jay', ' 0.303', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1102', ' Pelaez, Alex', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1103', ' Pellow, Kip', ' 0.238', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1104', ' Pena, Carlos', ' 0.242', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1105', ' Pena, Wily Mo', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1106', ' Perez, Eddie', ' 0.214', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1107', ' Perez, Eduardo', ' 0.201', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1108', ' Perez, Neifi', ' 0.236', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1109', ' Perez, Timoniel', ' 0.295', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1110', ' Perez, Tomas', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1111', ' Perry, Chan', ' 0.091', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1112', ' Perry, Herbert', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1113', ' Petrick, Ben', ' 0.211', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1114', ' Phelps, Josh', ' 0.309', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1115', ' Phillips, Brandon', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1116', ' Phillips, Jason', ' 0.368', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1117', ' Piatt, Adam', ' 0.234', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1118', ' Piazza, Mike', ' 0.28', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1119', ' Pickering, Calvin', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1120', ' Pierre, Juan', ' 0.287', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1121', ' Pierzynski, A.J.', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1122', ' Podsednik, Scott', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1123', ' Polanco, Placido', ' 0.288', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1124', ' Posada, Jorge', ' 0.268', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1125', ' Pratt, Todd', ' 0.311', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1126', ' Prince, Tom', ' 0.224', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1127', ' Pujols, Albert', ' 0.314', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1128', ' Punto, Nick', ' 0.167', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1129', ' Quinn, Mark', ' 0.237', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1130', ' Raines, Tim', ' 0.191', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1131', ' Ramirez, Aramis', ' 0.234', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1132', ' Ramirez, Julio', ' 0.281', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1133', ' Ramirez, Manny', ' 0.349', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1134', ' Randa, Joe', ' 0.282', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1135', ' Ransom, Cody', ' 0.667', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1136', ' Reboulet, Jeff', ' 0.208', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1137', ' Redmond, Mike', ' 0.305', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1138', ' Reese, Pokey', ' 0.264', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1139', ' Relaford, Desi', ' 0.267', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1140', ' Renteria, Edgar', ' 0.305', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1141', ' Restovich, Mike', ' 0.308', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1142', ' Richard, Chris', ' 0.232', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1143', ' Rios, Armando', ' 0.264', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1144', ' Rivas, Luis', ' 0.256', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1145', ' Rivera, Juan', ' 0.265', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1146', ' Rivera, Mike', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1147', ' Rivera, Ruben', ' 0.209', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1148', ' Roberts, Brian', ' 0.227', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1149', ' Roberts, Dave', ' 0.277', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1150', ' Robinson, Kerry', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1151', ' Rodriguez, Alex', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1152', ' Rodriguez, Henry', ' 0.05', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1153', ' Rodriguez, Ivan', ' 0.314', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1154', ' Rogers, Ed', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1155', ' Rolen, Scott', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1156', ' Rollins, Jimmy', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1157', ' Rolls, Damian', ' 0.292', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1158', ' Romano, Jason', ' 0.253', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1159', ' Ross, David', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1160', ' Rowand, Aaron', ' 0.258', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1161', ' Ruan, Wilken', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1162', ' Rushford, Jim', ' 0.143', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1163', ' Ryan, Mike', ' 0.091', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1164', ' Sadler, Donnie', ' 0.163', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1165', ' Saenz, Olmedo', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1166', ' Salazar, Oscar', ' 0.19', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1167', ' Salmon, Tim', ' 0.286', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1168', ' Sanchez, Alex', ' 0.289', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1169', ' Sanchez, Freddy', ' 0.188', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1170', ' Sanchez, Rey', ' 0.286', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1171', ' Sandberg, Jared', ' 0.229', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1172', ' Sanders, Reggie', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1173', ' Santiago, Benito', ' 0.278', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1174', ' Santiago, Ramon', ' 0.243', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1175', ' Schneider, Brian', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1176', ' Scutaro, Marcos', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1177', ' Sears, Todd', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1178', ' Segui, David', ' 0.263', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1179', ' Selby, Bill', ' 0.214', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1180', ' Sexson, Richie', ' 0.279', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1181', ' Sheets, Andy', ' 0.248', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1182', ' Sheffield, Gary', ' 0.307', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1183', ' Shinjo, Tsuyoshi', ' 0.238', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1184', ' Shumpert, Terry', ' 0.235', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1185', ' Sierra, Ruben', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1186', ' Simon, Randall', ' 0.301', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1187', ' Singleton, Chris', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1188', ' Smith, Bobby', ' 0.175', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1189', ' Smith, Jason', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1190', ' Snead, Esix', ' 0.308', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1191', ' Snelling, Chris', ' 0.148', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1192', ' Snow, J.T.', ' 0.246', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1193', ' Snyder, Earl', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1194', ' Soriano, Alfonso', ' 0.3', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1195', ' Sosa, Sammy', ' 0.288', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1196', ' Spencer, Shane', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1197', ' Spiezio, Scott', ' 0.285', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1198', ' Spivey, Junior', ' 0.301', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1199', ' Stairs, Matt', ' 0.244', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1200', ' Stevens, Lee', ' 0.204', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1201', ' Stewart, Shannon', ' 0.303', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1202', ' Stinnett, Kelly', ' 0.226', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1203', ' Stynes, Chris', ' 0.241', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1204', ' Surhoff, B.J.', ' 0.293', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1205', ' Sutton, Larry', ' 0.105', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1206', ' Suzuki, Ichiro', ' 0.321', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1207', ' Swann, Pedro', ' 0.083', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1208', ' Sweeney, Mark', ' 0.169', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1209', ' Sweeney, Mike', ' 0.34', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1210', ' Taguchi, So', ' 0.4', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1211', ' Tarasco, Tony', ' 0.25', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1212', ' Tatis, Fernando', ' 0.228', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1213', ' Taubensee, Eddie', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1214', ' Taylor, Reggie', ' 0.254', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1215', ' Tejada, Miguel', ' 0.308', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1216', ' Thames, Marcus', ' 0.231', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1217', ' Thomas, Frank', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1218', ' Thome, Jim', ' 0.304', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1219', ' Thompson, Ryan', ' 0.248', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1220', ' Thurston, Joe', ' 0.462', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1221', ' Toca, Jorge', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1222', ' Torcato, Tony', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1223', ' Torrealba, Steve', ' 0.059', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1224', ' Torrealba, Yorvit', ' 0.279', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1225', ' Torres, Andres', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1226', ' Trammell, Bubba', ' 0.243', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1227', ' Truby, Chris', ' 0.215', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1228', ' Tucker, Michael', ' 0.248', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1229', ' Tyner, Jason', ' 0.214', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1230', ' Ugueto, Luis', ' 0.217', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1231', ' Uribe, Juan', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1232', ' Valdez, Mario', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1233', ' Valent, Eric', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1234', ' Valentin, Javier', ' 0.5', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1235', ' Valentin, John', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1236', ' Valentin, Jose', ' 0.249', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1237', ' Vander Wal, John', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1238', ' Varitek, Jason', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1239', ' Vaughn, Greg', ' 0.163', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1240', ' Vaughn, Mo', ' 0.259', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1241', ' Vazquez, Ramon', ' 0.274', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1242', ' Velarde, Randy', ' 0.226', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1243', ' Ventura, Robin', ' 0.247', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1244', ' Vidro, Jose', ' 0.315', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1245', ' Vina, Fernando', ' 0.27', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1246', ' Vizcaino, Jose', ' 0.303', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1247', ' Vizquel, Omar', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1248', ' Walbeck, Matt', ' 0.235', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1249', ' Walker, Larry', ' 0.338', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1250', ' Walker, Todd', ' 0.299', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1251', ' Ward, Daryle', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1252', ' Wathan, Dusty', ' 0.6', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1253', ' Wells, Vernon', ' 0.275', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1254', ' Werth, Jayson', ' 0.261', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1255', ' Wesson, Barry', ' 0.2', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1256', ' White, Rondell', ' 0.24', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1257', ' Widger, Chris', ' 0.297', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1258', ' Wigginton, Ty', ' 0.302', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1259', ' Wilkerson, Brad', ' 0.266', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1260', ' Williams, Bernie', ' 0.333', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1261', ' Williams, Gerald', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1262', ' Williams, Matt', ' 0.26', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1263', ' Wilson, Craig', ' 0.264', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1264', ' Wilson, Dan', ' 0.295', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1265', ' Wilson, Enrique', ' 0.181', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1266', ' Wilson, Jack', ' 0.252', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1267', ' Wilson, Preston', ' 0.243', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1268', ' Wilson, Tom', ' 0.257', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1269', ' Wilson, Vance', ' 0.245', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1270', ' Winn, Randy', ' 0.298', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1271', ' Wise, DeWayne', ' 0.179', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1272', ' Womack, Tony', ' 0.271', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1273', ' Woodward, Chris', ' 0.276', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1274', ' Wooten, Shawn', ' 0.292', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1275', ' Wright, Ron', ' 0', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1276', ' Young, Dmitri', ' 0.284', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1277', ' Young, Eric', ' 0.28', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1278', ' Young, Kevin', ' 0.246', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1279', ' Young, Michael', ' 0.262', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1280', ' Zaun, Greg', ' 0.222', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1281', ' Zeile, Todd', ' 0.273', '2005-01-01'); |
INSERT INTO `testtbl` VALUES ('1282', ' Zinter, Alan', ' 0.136', '2005-01-01'); |
/trunk/api/js/dojo1.0/dojox/grid/tests/support/yahoo_search.js |
---|
New file |
0,0 → 1,131 |
// model that works with Yahoo Search API |
dojo.declare("dojox.grid.data.yahooSearch", dojox.grid.data.dynamic, |
function(inFields, inData) { |
this.rowsPerPage = 20; |
this.fieldNames = []; |
for (var i=0, f; (f=inFields[i]); i++) |
this.fieldNames.push(f.name); |
}, { |
clearData: function() { |
turbo.widgets.TurboGrid.data.dynamic.prototype.clearData.apply(this, arguments); |
}, |
// server send / receive |
encodeParam: function(inName, inValue) { |
return turbo.printf('&%s=%s', inName, inValue); |
}, |
getParams: function(inParams) { |
var url = this.url; |
url += '?appid=turboajax'; |
inParams = inParams || {}; |
inParams.output = 'json'; |
inParams.results = this.rowsPerPage; |
inParams.query = turbo.$('searchInput').value.replace(/ /g, '+'); |
for (var i in inParams) |
if (inParams[i] != undefined) |
url += this.encodeParam(i, inParams[i]); |
return url; |
}, |
send: function(inAsync, inParams, inOnReceive, inOnError) { |
var p = this.getParams(inParams); |
dojo.io.bind({ |
url: "support/proxy.php", |
method: "post", |
content: {url: p }, |
contentType: "application/x-www-form-urlencoded; charset=utf-8", |
mimetype: 'text/json', |
sync: !inAsync, |
load: turbo.bindArgs(this, "receive", inOnReceive, inOnError), |
error: turbo.bindArgs(this, "error", inOnError) |
}); |
this.onSend(inParams); |
}, |
receive: function(inOnReceive, inOnError, inEvt, inData) { |
try { |
inData = inData.ResultSet; |
inOnReceive(inData); |
this.onReceive(inData); |
} catch(e) { |
if (inOnError) |
inOnError(inData); |
} |
}, |
error: function(inOnError, inTyp, inErr) { |
var m = 'io error: ' + inErr.message; |
alert(m); |
if (inOnError) |
inOnError(m); |
}, |
fetchRowCount: function(inCallback) { |
this.send(true, inCallback ); |
}, |
// request data |
requestRows: function(inRowIndex, inCount) { |
inRowIndex = (inRowIndex == undefined ? 0 : inRowIndex); |
var params = { |
start: inRowIndex + 1 |
} |
this.send(true, params, turbo.bindArgs(this, this.processRows)); |
}, |
// server callbacks |
processRows: function(inData) { |
for (var i=0, l=inData.totalResultsReturned, s=inData.firstResultPosition; i<l; i++) { |
this.setRow(inData.Result[i], s - 1 + i); |
} |
// yahoo says 1000 is max results to return |
var c = Math.min(1000, inData.totalResultsAvailable); |
if (this.count != c) { |
this.setRowCount(c); |
this.allChange(); |
this.onInitializeData(inData); |
} |
}, |
getDatum: function(inRowIndex, inColIndex) { |
var row = this.getRow(inRowIndex); |
var field = this.fields.get(inColIndex); |
return (inColIndex == undefined ? row : (row ? row[field.name] : field.na)); |
}, |
// events |
onInitializeData: turbo.nop, |
onSend: turbo.nop, |
onReceive: turbo.nop |
}); |
// report |
modelChange = function() { |
var n = turbo.$('rowCount'); |
if (n) |
n.innerHTML = turbo.printf('about %s row(s)', model.count); |
} |
// some data formatters |
formatLink = function(inData, inRowIndex) { |
if (!inData[0] || !inData[1]) |
return ' '; |
return turbo.supplant('<a target="_blank" href="{href}">{text}</a>', {href: inData[0], text: inData[1] }); |
}; |
formatImage = function(inData, inRowIndex) { |
if (!inData[0] || !inData[1]) |
return ' '; |
var o = { |
href: inData[0], |
src: inData[1].Url, |
width: inData[1].Width, |
height: inData[1].Height |
} |
return turbo.supplant('<a href="{href}" target="_blank"><img border=0 src="{src}" width="{width}" height="{height}"></a>', o); |
}; |
formatDate = function(inDatum, inRowIndex) { |
if (inDatum == '') |
return ' '; |
var d = new Date(inDatum * 1000); |
return turbo.printf('%s/%s/%s', d.getMonth(), d.getDate(), d.getFullYear()); |
}; |
formatDimensions = function(inData, inRowIndex) { |
if (!inData[0] || !inData[1]) |
return ' '; |
return inData[0] + ' x ' + inData[1]; |
} |
/trunk/api/js/dojo1.0/dojox/grid/tests/yahooSearch.js |
---|
New file |
0,0 → 1,143 |
// model that works with Yahoo Search API |
dojo.declare("dojox.grid.data.yahooSearch", dojox.grid.data.dynamic, |
function(inFields, inData, inSearchNode) { |
this.rowsPerPage = 20; |
this.searchNode = inSearchNode; |
this.fieldNames = []; |
for (var i=0, f; (f=inFields[i]); i++) |
this.fieldNames.push(f.name); |
}, { |
// server send / receive |
encodeParam: function(inName, inValue) { |
return dojo.string.substitute('&${0}=${1}', [inName, inValue]); |
}, |
getQuery: function() { |
return dojo.byId(this.searchNode).value.replace(/ /g, '+'); |
}, |
getParams: function(inParams) { |
var url = this.url; |
url += '?appid=foo'; |
inParams = inParams || {}; |
inParams.output = 'json'; |
inParams.results = this.rowsPerPage; |
inParams.query = this.getQuery(); |
for (var i in inParams) |
if (inParams[i] != undefined) |
url += this.encodeParam(i, inParams[i]); |
return url; |
}, |
send: function(inAsync, inParams, inOnReceive, inOnError) { |
var |
p = this.getParams(inParams), |
d = dojo.xhrPost({ |
url: "support/proxy.php", |
content: {url: p }, |
contentType: "application/x-www-form-urlencoded; charset=utf-8", |
handleAs: 'json-comment-filtered', |
sync: !inAsync |
}); |
d.addCallbacks(dojo.hitch(this, "receive", inOnReceive, inOnError), dojo.hitch(this, "error", inOnError)); |
this.onSend(inParams); |
return d; |
}, |
receive: function(inOnReceive, inOnError, inData) { |
try { |
inData = inData.ResultSet; |
inOnReceive(inData); |
this.onReceive(inData); |
} catch(e) { |
if (inOnError) |
inOnError(inData); |
} |
}, |
error: function(inOnError, inErr) { |
var m = 'io error: ' + inErr.message; |
alert(m); |
if (inOnError) |
inOnError(m); |
}, |
fetchRowCount: function(inCallback) { |
this.send(true, inCallback ); |
}, |
// request data |
requestRows: function(inRowIndex, inCount) { |
inRowIndex = (inRowIndex == undefined ? 0 : inRowIndex); |
var params = { |
start: inRowIndex + 1 |
} |
this.send(true, params, dojo.hitch(this, this.processRows)); |
}, |
// server callbacks |
processRows: function(inData) { |
for (var i=0, l=inData.totalResultsReturned, s=inData.firstResultPosition; i<l; i++) { |
this.setRow(inData.Result[i], s - 1 + i); |
} |
// yahoo says 1000 is max results to return |
var c = Math.min(1000, inData.totalResultsAvailable); |
if (this.count != c) { |
this.setRowCount(c); |
this.allChange(); |
this.onInitializeData(inData); |
} |
}, |
getDatum: function(inRowIndex, inColIndex) { |
var row = this.getRow(inRowIndex); |
var field = this.fields.get(inColIndex); |
return (inColIndex == undefined ? row : (row ? row[field.name] : field.na)); |
}, |
// events |
onInitializeData: function() { |
}, |
onSend: function() { |
}, |
onReceive: function() { |
} |
}); |
// report |
modelChange = function() { |
var n = dojo.byId('rowCount'); |
if (n) |
n.innerHTML = dojo.string.substitute('about ${0} row(s)', [model.count]); |
} |
// some data formatters |
getCellData = function(inCell, inRowIndex, inField) { |
var m = inCell.grid.model; |
return m.getDatum(inRowIndex, inField); |
} |
formatLink = function(inData, inRowIndex) { |
if (!inData) |
return ' '; |
var text = getCellData(this, inRowIndex, this.extraField); |
return dojo.string.substitute('<a target="_blank" href="${href}">${text}</a>', {href: inData, text: text }); |
}; |
formatImage = function(inData, inRowIndex) { |
if (!inData) |
return ' '; |
var info = getCellData(this, inRowIndex, this.extraField); |
var o = { |
href: inData, |
src: info.Url, |
width: info.Width, |
height: info.Height |
} |
return dojo.string.substitute('<a href="${href}" target="_blank"><img border=0 src="${src}" width="${width}" height="${height}"></a>', o); |
}; |
formatDate = function(inDatum, inRowIndex) { |
if (!inDatum) |
return ' '; |
var d = new Date(inDatum * 1000); |
return dojo.string.substitute("${0}/${1}/${2}",[d.getMonth()+1, d.getDate(), d.getFullYear()]) |
}; |
formatDimensions = function(inData, inRowIndex) { |
if (!inData) |
return ' '; |
var w = inData, h = getCellData(this, inRowIndex, this.extraField); |
return w + ' x ' + h; |
} |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_expand.html |
---|
New file |
0,0 → 1,108 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>Test dojox.Grid Expand Rows</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
.bigHello { |
height: 110px; |
line-height: 110px; |
text-align: center; |
font-weight: bold; |
font-size: 30px; |
} |
#grid { |
border: 1px solid #333; |
height: 30em; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript"> |
// grid structure |
// a grid view is a group of columns |
// a special view providing selection feedback |
var rowBar = {type: 'dojox.GridRowView', width: '20px' }; |
// inRow is an array of subRows. we hide the summary subRow except for every nth row |
function onBeforeRow(inDataIndex, inRow) { |
inRow[1].hidden = (!this.grid || !this.grid.expandedRows || !this.grid.expandedRows[inDataIndex]); |
} |
var view = { |
onBeforeRow: onBeforeRow, |
cells: [ |
[ |
{ name: 'Whatever', width: 4.5, get: getCheck, styles: 'text-align: center;' }, |
{name: 'Column 0'}, |
{name: 'Column 1'}, |
{name: 'Column 2'}, |
{name: 'Column 3'}, |
{name: 'Column 4'} |
], |
[ { name: 'Detail', colSpan: 6, get: getDetail } ] |
] |
}; |
// a grid structure is an array of views. |
var structure = [ rowBar, view ]; |
// get can return data for each cell of the grid |
function get(inRowIndex) { |
return [this.index, inRowIndex].join(', '); |
} |
function getDetail(inRowIndex) { |
if (this.grid.expandedRows[inRowIndex]) { |
var n = (inRowIndex % 2); |
switch (n) { |
case 0: |
return 'Hello World!'; |
default: |
return '<div class="bigHello">Hello World!</div>'; |
} |
} else |
return ''; |
} |
function toggle(inIndex, inShow) { |
grid.expandedRows[inIndex] = inShow; |
grid.updateRow(inIndex); |
} |
function getCheck(inRowIndex) { |
if (!this.grid.expandedRows) |
this.grid.expandedRows = [ ]; |
var image = (this.grid.expandedRows[inRowIndex] ? 'open.gif' : 'closed.gif'); |
var show = (this.grid.expandedRows[inRowIndex] ? 'false' : 'true') |
return '<img src="images/' + image + '" onclick="toggle(' + inRowIndex + ', ' + show + ')" height="11" width="11">'; |
} |
dojo.addOnLoad(function() { |
window["grid"] = dijit.byId("grid"); |
}); |
</script> |
</head> |
<body> |
<div class="heading">dojox.Grid Expand Row Example</div> |
<div id="grid" dojoType="dojox.VirtualGrid" get="get" structure="structure" rowCount="100000" autoWidth="true"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_grid_layout.html |
---|
New file |
0,0 → 1,113 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" |
"http://www.w3.org/TR/html4/strict.dtd"> |
<html> |
<head> |
<title>dojox.Grid in Layout Demo</title> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
@import "../_grid/tundraGrid.css"; |
@import "../../../dojo/resources/dojo.css"; |
@import "../../../dijit/themes/tundra/tundra.css"; |
@import "../../../dijit/tests/css/dijitTests.css"; |
html, body{ |
width: 100%; /* make the body expand to fill the visible window */ |
height: 100%; |
padding: 0 0 0 0; |
margin: 0 0 0 0; |
overflow: hidden; |
} |
.dijitSplitPane{ |
margin: 5px; |
} |
/* make grid containers overflow hidden */ |
body .dijitContentPane { |
overflow: hidden; |
} |
#rightPane { |
margin: 0; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="parseOnLoad: true, isDebug: false"></script> |
<script type="text/javascript" src="../../../dijit/tests/_testCommon.js"></script> |
<script type="text/javascript"> |
dojo.require("dijit.layout.LayoutContainer"); |
dojo.require("dijit.layout.ContentPane"); |
dojo.require("dijit.layout.LinkPane"); |
dojo.require("dijit.layout.SplitContainer"); |
dojo.require("dijit.layout.TabContainer"); |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); // scan page for widgets and instantiate them |
</script> |
<script type="text/javascript" src="support/test_data.js"></script> |
<script type="text/javascript"> |
// a grid view is a group of columns |
var view1 = { |
cells: [[ |
{name: 'Column 0'}, {name: 'Column 1'}, {name: 'Column 2'}, {name: 'Column 3', width: "150px"}, {name: 'Column 4'} |
],[ |
{name: 'Column 5'}, {name: 'Column 6'}, {name: 'Column 7'}, {name: 'Column 8', field: 3, colSpan: 2} |
]] |
}; |
// a grid layout is an array of views. |
var layout = [ view1 ]; |
var layout2 = [ { |
cells: [[ |
{name: 'Alpha'}, {name: 'Beta'}, {name: 'Gamma'}, {name: 'Delta', width: "150px"}, {name: 'Epsilon'}, {name: 'Nexilon'}, {name: 'Zeta'}, {name: 'Eta', field: 0}, {name: 'Omega' } |
]] |
} |
]; |
// |
dojo.addOnLoad(function(){ |
dijit.byId("grid3").update(); |
}); |
</script> |
</head> |
<body class="tundra"> |
<div id="outer" dojoType="dijit.layout.LayoutContainer" |
style="width: 100%; height: 100%;"> |
<div id="topBar" dojoType="dijit.layout.ContentPane" layoutAlign="top" |
style="background-color: #274383; color: white;"> |
top bar |
</div> |
<div id="bottomBar" dojoType="dijit.layout.ContentPane" layoutAlign="bottom" |
style="background-color: #274383; color: white;"> |
bottom bar |
</div> |
<div id="horizontalSplit" dojoType="dijit.layout.SplitContainer" |
orientation="horizontal" |
sizerWidth="5" |
activeSizing="0" |
layoutAlign="client" |
> |
<div id="leftPane" dojoType="dijit.layout.ContentPane" |
sizeMin="20" sizeShare="20"> |
Left side |
</div> |
<div id="rightPane" |
dojoType="dijit.layout.SplitContainer" |
orientation="vertical" |
sizerWidth="5" |
activeSizing="0" |
sizeMin="50" sizeShare="80" |
> |
<div id="mainTabContainer" dojoType="dijit.layout.TabContainer" sizeMin="20" sizeShare="70"> |
<div id="grid1" dojoType="dojox.Grid" model="model" title="Tab 1"></div> |
<div id="grid2" dojoType="dojox.Grid" model="model" structure="layout2" title="Tab 2"></div> |
</div> |
<div id="bottomRight" dojoType="dijit.layout.ContentPane" sizeMin="20" sizeShare="30"> |
<div id="grid3" dojoType="dojox.Grid" model="model" structure="layout2"></div> |
</div> |
</div> |
</div> |
</div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_grid_tooltip_menu.html |
---|
New file |
0,0 → 1,162 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>Test dojox.Grid Basic</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
@import "../../../dojo/resources/dojo.css"; |
@import "../../../dijit/tests/css/dijitTests.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
#grid { |
border: 1px solid #333; |
width: 35em; |
height: 30em; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript" src="../../../dijit/tests/_testCommon.js"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dijit.Tooltip"); |
dojo.require("dijit.Menu"); |
dojo.require("dijit.ColorPalette"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript" src="support/test_data.js"></script> |
<script type="text/javascript"> |
// a grid view is a group of columns |
var view1 = { |
cells: [[ |
{name: 'Column 0'}, {name: 'Column 1'}, {name: 'Column 2'}, {name: 'Column 3', width: "150px"}, {name: 'Column 4'} |
],[ |
{name: 'Column 5'}, {name: 'Column 6'}, {name: 'Column 7'}, {name: 'Column 8', field: 3, colSpan: 2} |
]] |
}; |
// a grid layout is an array of views. |
var layout = [ view1 ]; |
dojo.addOnLoad(function() { |
window["grid"] = dijit.byId("grid"); |
var |
showTooltip = function(e) { |
if(gridTooltipEnabled){ |
var msg = "This is cell " + e.rowIndex + ", " + e.cellIndex; |
dijit.showTooltip(msg, e.cellNode); |
} |
}, |
hideTooltip = function(e) { |
dijit.hideTooltip(e.cellNode); |
// FIXME: make sure that pesky tooltip doesn't reappear! |
// would be nice if there were a way to hide tooltip without regard to aroundNode. |
dijit._masterTT._onDeck=null; |
} |
// cell tooltip |
dojo.connect(grid, "onCellMouseOver", showTooltip); |
dojo.connect(grid, "onCellMouseOut", hideTooltip); |
// header cell tooltip |
dojo.connect(grid, "onHeaderCellMouseOver", showTooltip); |
dojo.connect(grid, "onHeaderCellMouseOut", hideTooltip); |
// grid menu |
window["gridMenu"] = dijit.byId("gridMenu"); |
gridMenu.bindDomNode(grid.domNode); |
// prevent grid methods from killing the context menu event by implementing our own handler |
grid.onCellContextMenu = function(e) { |
cellNode = e.cellNode; |
}; |
grid.onHeaderContextMenu = function(e) { |
cellNode = e.cellNode; |
}; |
}); |
function reportCell() { |
if(cellNode){ |
alert("Cell contents: " + cellNode.innerHTML); |
cellNode = null; |
} |
} |
gridTooltipEnabled = true; |
function toggleTooltip(button){ |
gridTooltipEnabled = !gridTooltipEnabled; |
button.value = gridTooltipEnabled ? "Disable Grid Tooltip" : "Enable Grid Tooltip"; |
} |
gridMenuEnabled = true; |
function toggleMenu(button){ |
gridMenuEnabled = !gridMenuEnabled; |
button.value = gridMenuEnabled ? "Disable Grid Menu" : "Enable Grid Menu"; |
gridMenu[gridMenuEnabled ? "bindDomNode" : "unBindDomNode"](grid.domNode); |
} |
</script> |
</head> |
<body> |
<div dojoType="dijit.Menu" id="gridMenu" style="display: none;"> |
<div dojoType="dijit.MenuItem" onClick="reportCell">See cell text...</div> |
<div dojoType="dijit.MenuItem" disabled="true">Disabled Item</div> |
<div dojoType="dijit.MenuSeparator"></div> |
<div dojoType="dijit.MenuItem" iconClass="dijitEditorIcon dijitEditorIconCut" |
onClick="alert('not actually cutting anything, just a test!')">Cut</div> |
<div dojoType="dijit.MenuItem" iconClass="dijitEditorIcon dijitEditorIconCopy" |
onClick="alert('not actually copying anything, just a test!')">Copy</div> |
<div dojoType="dijit.MenuItem" iconClass="dijitEditorIcon dijitEditorIconPaste" |
onClick="alert('not actually pasting anything, just a test!')">Paste</div> |
<div dojoType="dijit.MenuSeparator"></div> |
</div> |
<div dojoType="dijit.Menu" id="submenu1" contextMenuForWindow="true" style="display: none;"> |
<div dojoType="dijit.MenuItem" onClick="alert('Hello world');">Enabled Item</div> |
<div dojoType="dijit.MenuItem" disabled="true">Disabled Item</div> |
<div dojoType="dijit.MenuSeparator"></div> |
<div dojoType="dijit.MenuItem" iconClass="dijitEditorIcon dijitEditorIconCut" |
onClick="alert('not actually cutting anything, just a test!')">Cut</div> |
<div dojoType="dijit.MenuItem" iconClass="dijitEditorIcon dijitEditorIconCopy" |
onClick="alert('not actually copying anything, just a test!')">Copy</div> |
<div dojoType="dijit.MenuItem" iconClass="dijitEditorIcon dijitEditorIconPaste" |
onClick="alert('not actually pasting anything, just a test!')">Paste</div> |
<div dojoType="dijit.MenuSeparator"></div> |
<div dojoType="dijit.PopupMenuItem"> |
<span>Enabled Submenu</span> |
<div dojoType="dijit.Menu" id="submenu2"> |
<div dojoType="dijit.MenuItem" onClick="alert('Submenu 1!')">Submenu Item One</div> |
<div dojoType="dijit.MenuItem" onClick="alert('Submenu 2!')">Submenu Item Two</div> |
<div dojoType="dijit.PopupMenuItem"> |
<span>Deeper Submenu</span> |
<div dojoType="dijit.Menu" id="submenu4""> |
<div dojoType="dijit.MenuItem" onClick="alert('Sub-submenu 1!')">Sub-sub-menu Item One</div> |
<div dojoType="dijit.MenuItem" onClick="alert('Sub-submenu 2!')">Sub-sub-menu Item Two</div> |
</div> |
</div> |
</div> |
</div> |
<div dojoType="dijit.PopupMenuItem" disabled="true"> |
<span>Disabled Submenu</span> |
<div dojoType="dijit.Menu" id="submenu3" style="display: none;"> |
<div dojoType="dijit.MenuItem" onClick="alert('Submenu 1!')">Submenu Item One</div> |
<div dojoType="dijit.MenuItem" onClick="alert('Submenu 2!')">Submenu Item Two</div> |
</div> |
</div> |
<div dojoType="dijit.PopupMenuItem"> |
<span>Different popup</span> |
<div dojoType="dijit.ColorPalette"></div> |
</div> |
</div> |
<div class="heading">dojox.Grid Basic Test</div> |
<p> |
<input type="button" onclick="toggleTooltip(this)" value="Disable Grid Tooltip"> |
<input type="button" onclick="toggleMenu(this)" value="Disable Grid Menu"> <br /> |
Note: when the grid menu is disabled, the document's dijit context menu should be shown over the grid. |
</p> |
<div id="grid" dojoType="dojox.Grid" model="model" structure="layout"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_dojo_data.html |
---|
New file |
0,0 → 1,139 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid with Dojo.Data via binding</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
body { |
font-size: 1em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
#grid { |
width: 65em; |
height: 25em; |
padding: 1px; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojo.data.ItemFileReadStore"); |
dojo.require("dojox.data.CsvStore"); |
/*dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser");*/ |
</script> |
<!-- Debugging --> |
<script type="text/javascript" src="../_grid/lib.js"></script> |
<script type="text/javascript" src="../_grid/drag.js"></script> |
<script type="text/javascript" src="../_grid/scroller.js"></script> |
<script type="text/javascript" src="../_grid/builder.js"></script> |
<script type="text/javascript" src="../_grid/cell.js"></script> |
<script type="text/javascript" src="../_grid/layout.js"></script> |
<script type="text/javascript" src="../_grid/rows.js"></script> |
<script type="text/javascript" src="../_grid/focus.js"></script> |
<script type="text/javascript" src="../_grid/selection.js"></script> |
<script type="text/javascript" src="../_grid/edit.js"></script> |
<script type="text/javascript" src="../_grid/view.js"></script> |
<script type="text/javascript" src="../_grid/views.js"></script> |
<script type="text/javascript" src="../_grid/rowbar.js"></script> |
<script type="text/javascript" src="../_grid/publicEvents.js"></script> |
<script type="text/javascript" src="../VirtualGrid.js"></script> |
<script type="text/javascript" src="../_data/fields.js"></script> |
<script type="text/javascript" src="../_data/model.js"></script> |
<script type="text/javascript" src="../_data/editors.js"></script> |
<script type="text/javascript" src="../Grid.js"></script> |
<script type="text/javascript"> |
dojox.grid.data.HashMixin = { |
getFieldName: function(inIndex){ |
var n = this.fields.get(inIndex); |
return (n)&&(n.name); |
}, |
_get: function(inRowIndex, inColIndex){ |
var row = this.data[inRowIndex]; |
var n = this.getFieldName(inColIndex); |
return (inColIndex == undefined || !n ? row : row[n]); |
}, |
getDatum: function(inRowIndex, inColIndex){ |
return this._get(inRowIndex, inColIndex); |
}, |
getRow: function(inRowIndex){ |
return this._get(inRowIndex); |
}, |
setDatum: function(inDatum, inRowIndex, inColIndex){ |
var n = this.getFieldName(inColIndex); |
if(n){ |
this.data[inRowIndex][n] = inDatum; |
} |
}, |
// get items based on field names |
createComparator: function(inField, inIndex, inSubCompare){ |
return function(a, b){ |
var c = inField.name; |
var ineq = inField.compare(a[c], b[c]); |
return (ineq ? (inIndex > 0 ? ineq : -ineq) : (inSubCompare && inSubCompare(a, b))); |
} |
}, |
makeComparator: function(inIndices){ |
var result = null; |
for(var i=inIndices.length-1, col; i>=0; i--){ |
col = Math.abs(inIndices[i]) - 1; |
if(col >= 0){ |
result = this.createComparator(this.fields.get(col), inIndices[i], result); |
} |
} |
return result; |
} |
} |
dojo.declare("dojox.grid.data.Itemhash", dojox.grid.data.table, dojox.grid.data.HashMixin); |
function getRow(inRowIndex){ |
return ' ' + inRowIndex; |
} |
var layout2 = [ |
{ type: 'dojox.GridRowView', width: '20px' }, |
{ cells: [[{ name: "Row", get: getRow, width: 5}]], noscroll: true}, |
{ cells: [[ |
{ name: "Title", field: 0 }, |
{ name: "Year", field: 1, width: 20 }, |
{ name: "Producer", field: 2, width: 'auto' } |
]]} |
]; |
updateGrid = function(inItems, inResult){ |
//var m = new dojox.grid.data.table(null, csvStore._dataArray); |
var m = new dojox.grid.data.Itemhash(); |
var f = csvStore.getAttributes(inItems[0]); |
var i = 0; |
var fields = []; |
dojo.forEach(f, function(a) { |
fields.push({name: a}); |
}); |
m.fields.set(fields); |
model = m; |
dojo.forEach(inItems, function(item) { |
var row = {}; |
dojo.forEach(fields, function(a) { |
row[a.name] = csvStore.getValue(item, a.name)||""; |
}); |
m.setRow(row, i++); |
}); |
grid.setModel(m); |
} |
dojo.addOnLoad(function(){ |
csvStore = new dojox.data.CsvStore({url:"support/movies.csv"}); |
csvStore.fetch({ onComplete: updateGrid, onError: function() { console.log(arguments)}}); |
}); |
</script> |
</head> |
<body> |
<h5>dojox.Grid using Dojo.Data stores via simple binding</h5> |
<div jsId="grid" dojoType="dojox.Grid" |
elasticView="2" structure="layout2"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_grid.html |
---|
New file |
0,0 → 1,67 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>Test dojox.Grid Basic</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
#grid { |
border: 1px solid #333; |
width: 35em; |
height: 30em; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<!--<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script>--> |
<!-- Debugging --> |
<script type="text/javascript" src="../_grid/lib.js"></script> |
<script type="text/javascript" src="../_grid/drag.js"></script> |
<script type="text/javascript" src="../_grid/scroller.js"></script> |
<script type="text/javascript" src="../_grid/builder.js"></script> |
<script type="text/javascript" src="../_grid/cell.js"></script> |
<script type="text/javascript" src="../_grid/layout.js"></script> |
<script type="text/javascript" src="../_grid/rows.js"></script> |
<script type="text/javascript" src="../_grid/focus.js"></script> |
<script type="text/javascript" src="../_grid/selection.js"></script> |
<script type="text/javascript" src="../_grid/edit.js"></script> |
<script type="text/javascript" src="../_grid/view.js"></script> |
<script type="text/javascript" src="../_grid/views.js"></script> |
<script type="text/javascript" src="../_grid/rowbar.js"></script> |
<script type="text/javascript" src="../_grid/publicEvents.js"></script> |
<script type="text/javascript" src="../VirtualGrid.js"></script> |
<script type="text/javascript" src="../_data/fields.js"></script> |
<script type="text/javascript" src="../_data/model.js"></script> |
<script type="text/javascript" src="../_data/editors.js"></script> |
<script type="text/javascript" src="../Grid.js"></script> |
<script type="text/javascript" src="support/test_data.js"></script> |
<script type="text/javascript"> |
// a grid view is a group of columns |
var view1 = { |
cells: [[ |
{name: 'Column 0'}, {name: 'Column 1'}, {name: 'Column 2'}, {name: 'Column 3', width: "150px"}, {name: 'Column 4'} |
],[ |
{name: 'Column 5'}, {name: 'Column 6'}, {name: 'Column 7'}, {name: 'Column 8', field: 3, colSpan: 2} |
]] |
}; |
// a grid layout is an array of views. |
var layout = [ view1 ]; |
</script> |
</head> |
<body> |
<div class="heading">dojox.Grid Basic Test</div> |
<div id="grid" dojoType="dojox.Grid" model="model" structure="layout"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_edit.html |
---|
New file |
0,0 → 1,150 |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
<html xmlns="http://www.w3.org/1999/xhtml"> |
<head> |
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> |
<title>Test dojox.Grid Editing</title> |
<style> |
@import "../_grid/Grid.css"; |
body { |
font-family: Tahoma, Arial, Helvetica, sans-serif; |
font-size: 11px; |
} |
.dojoxGrid-row-editing td { |
background-color: #F4FFF4; |
} |
.dojoxGrid input, .dojoxGrid select, .dojoxGrid textarea { |
margin: 0; |
padding: 0; |
border-style: none; |
width: 100%; |
font-size: 100%; |
font-family: inherit; |
} |
.dojoxGrid input { |
} |
.dojoxGrid select { |
} |
.dojoxGrid textarea { |
} |
#controls { |
padding: 6px 0; |
} |
#grid { |
width: 850px; |
height: 350px; |
border: 1px solid silver; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<!--<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script>--> |
<!-- Debugging --> |
<script type="text/javascript" src="../_grid/lib.js"></script> |
<script type="text/javascript" src="../_grid/drag.js"></script> |
<script type="text/javascript" src="../_grid/scroller.js"></script> |
<script type="text/javascript" src="../_grid/builder.js"></script> |
<script type="text/javascript" src="../_grid/cell.js"></script> |
<script type="text/javascript" src="../_grid/layout.js"></script> |
<script type="text/javascript" src="../_grid/rows.js"></script> |
<script type="text/javascript" src="../_grid/focus.js"></script> |
<script type="text/javascript" src="../_grid/selection.js"></script> |
<script type="text/javascript" src="../_grid/edit.js"></script> |
<script type="text/javascript" src="../_grid/view.js"></script> |
<script type="text/javascript" src="../_grid/views.js"></script> |
<script type="text/javascript" src="../_grid/rowbar.js"></script> |
<script type="text/javascript" src="../_grid/publicEvents.js"></script> |
<script type="text/javascript" src="../VirtualGrid.js"></script> |
<script type="text/javascript" src="../_data/fields.js"></script> |
<script type="text/javascript" src="../_data/model.js"></script> |
<script type="text/javascript" src="../_data/editors.js"></script> |
<script type="text/javascript" src="../Grid.js"></script> |
<script type="text/javascript"> |
// ========================================================================== |
// Create a data model |
// ========================================================================== |
data = [ |
[ "normal", false, "new", 'But are not followed by two hexadecimal', 29.91, 10, false ], |
[ "important", false, "new", 'Because a % sign always indicates', 9.33, -5, false ], |
[ "important", false, "read", 'Signs can be selectively', 19.34, 0, true ], |
[ "note", false, "read", 'However the reserved characters', 15.63, 0, true ], |
[ "normal", false, "replied", 'It is therefore necessary', 24.22, 5.50, true ], |
[ "important", false, "replied", 'To problems of corruption by', 9.12, -3, true ], |
[ "note", false, "replied", 'Which would simply be awkward in', 12.15, -4, false ] |
]; |
var rows = 10000; |
for(var i=0, l=data.length; i<rows-l; i++){ |
data.push(data[i%l].slice(0)); |
} |
model = new dojox.grid.data.Table(null, data); |
// ========================================================================== |
// Tie some UI to the data model |
// ========================================================================== |
model.observer(this); |
modelChange = function() { |
dojo.byId("rowCount").innerHTML = 'Row count: ' + model.count; |
} |
// ========================================================================== |
// Custom formatter |
// ========================================================================== |
formatMoney = function(inDatum) { |
return isNaN(inDatum) ? '...' : '$' + parseFloat(inDatum).toFixed(2); |
} |
// ========================================================================== |
// Grid structure |
// ========================================================================== |
statusCell = { field: 2, name: 'Status', styles: 'text-align: center;', editor: dojox.grid.editors.Select, options: [ "new", "read", "replied" ] }; |
gridLayout = [{ |
type: 'dojox.GridRowView', width: '20px' |
},{ |
defaultCell: { width: 8, editor: dojox.grid.editors.Input, styles: 'text-align: right;' }, |
rows: [[ |
{ name: 'Id', width: 3, get: function(inRowIndex) { return inRowIndex+1;} }, |
{ name: 'Priority', styles: 'text-align: center;', editor: dojox.grid.editors.Select, options: ["normal", "note", "important"]}, |
{ name: 'Mark', width: 3, styles: 'text-align: center;', editor: dojox.grid.editors.Bool }, |
statusCell, |
{ name: 'Message', styles: '', width: '100%' }, |
{ name: 'Amount', formatter: formatMoney }, |
{ name: 'Amount', field: 4, formatter: formatMoney } |
]] |
},{ |
defaultCell: { width: 4, editor: dojox.grid.editors.Input, styles: 'text-align: right;' }, |
rows: [[ |
{ name: 'Mark', width: 3, field: 1, styles: 'text-align: center;', editor: dojox.grid.editors.Bool}, |
statusCell, |
{ name: 'Amount', field: 4, formatter: formatMoney}, |
{ name: 'Detail', value: 'Detail'} |
]] |
}]; |
// ========================================================================== |
// UI Action |
// ========================================================================== |
addRow = function(){ |
grid.addRow([ "normal", false, "new", 'Now is the time for all good men to come to the aid of their party.', 99.99, 9.99, false ]); |
} |
</script> |
</head> |
<body> |
<h2> |
dojox.Grid Basic Editing test |
</h2> |
<div id="controls"> |
<button onclick="grid.refresh()">Refresh</button> |
<button onclick="grid.edit.focusEditor()">Focus Editor</button> |
<button onclick="grid.focus.next()">Next Focus</button> |
<button onclick="addRow()">Add Row</button> |
<button onclick="grid.removeSelectedRows()">Remove</button> |
<button onclick="grid.edit.apply()">Apply</button> |
<button onclick="grid.edit.cancel()">Cancel</button> |
<button onclick="grid.singleClickEdit = !grid.singleClickEdit">Toggle singleClickEdit</button> |
</div> |
<br /> |
<div id="grid" dojoType="dojox.Grid" |
jsId="grid" |
model="model" structure="gridLayout"></div> |
<br /> |
<div id="rowCount"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_grid_programmatic_layout.html |
---|
New file |
0,0 → 1,75 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" |
"http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>Test dojox.Grid Programmatic Instantiation</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/tundraGrid.css"; |
@import "../../../dojo/resources/dojo.css"; |
@import "../../../dijit/themes/tundra/tundra.css"; |
@import "../../../dijit/tests/css/dijitTests.css"; |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
#grid { |
width: 100%; |
height: 100%; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="isDebug:false, debugAtAllCosts: false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dijit.layout.TabContainer"); |
dojo.require("dijit.layout.ContentPane"); |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript" src="support/test_data.js"></script> |
<script type="text/javascript"> |
dojo.addOnLoad(function(){ |
// a grid view is a group of columns |
var view1 = { |
cells: [ |
[ |
{name: 'Column 0'}, |
{name: 'Column 1'}, |
{name: 'Column 2'}, |
{name: 'Column 3', width: "150px"}, |
{name: 'Column 4'} |
], |
[ |
{name: 'Column 5'}, |
{name: 'Column 6'}, |
{name: 'Column 7'}, |
{name: 'Column 8', field: 3, colSpan: 2} |
] |
] |
}; |
// a grid layout is an array of views. |
var layout = [ view1 ]; |
var grid = new dojox.Grid({ |
title: "tab 1", |
id: "grid", |
model: model, |
structure: layout |
}); |
dijit.byId("mainTabContainer").addChild(grid, 0); |
grid.render(); |
}); |
</script> |
</head> |
<body class="tundra"> |
<div class="heading">dojox.Grid Programmatic Instantiation Test</div> |
<div id="mainTabContainer" dojoType="dijit.layout.TabContainer" |
style="height: 300px; width: 100%;"> |
<div dojoType="dijit.layout.ContentPane" title="Tab 2"> |
... stuff ... |
</div> |
</div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_styling.html |
---|
New file |
0,0 → 1,132 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid Styling Test</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
#grid { |
border: 1px solid #333; |
width: 45em; |
height: 30em; |
} |
#grid .dojoxGrid-row { |
border: none; |
} |
#grid .dojoxGrid-row-table { |
border-collapse: collapse; |
} |
#grid .dojoxGrid-cell { |
border: none; |
padding: 10px; |
} |
.selectedRow .dojoxGrid-cell { |
background-color: #003366; |
color: white; |
} |
.specialRow .dojoxGrid-cell { |
background-color: dimgray; |
} |
.selectedRow.specialRow .dojoxGrid-cell { |
text-decoration: line-through; |
/* duplicate selection background-color so has precendence over specialRow background-color */ |
background-color: #003366; |
} |
/* in the yellow column, assign specific decoration for special rows that are selected */ |
.selectedRow.specialRow .yellowColumnData { |
text-decoration: line-through underline; |
} |
.yellowColumn { |
color: #006666; |
} |
.overRow .dojoxGrid-cell { |
text-decoration: underline; |
} |
.greenColumn { |
color: yellow; |
background-color: #006666; |
font-style: italic; |
} |
.yellowColumnData { |
background-color: yellow; |
text-decoration: underline; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript" src="support/test_data.js"></script> |
<script type="text/javascript"> |
// grid structure |
// a grid view is a group of columns |
// a view without scrollbars |
var leftView = { |
noscroll: true, |
cells: [[ |
{name: 'Column 0', width: 5, headerStyles: 'padding-bottom: 2px;', styles: 'border-bottom: 1px dashed #333; border-right: 1px dashed #333; padding: 6px;'}, |
{name: 'Column 1', width: 5, headerStyles: 'padding-bottom: 2px;', styles: 'text-align: right; border-bottom: 1px dashed #333; border-right: 1px dashed #333; padding: 6px;'} |
]]}; |
var middleView = { |
cells: [[ |
{name: 'Column 2'}, |
{name: 'Column 3', headerStyles: 'background-image: none; background-color: #003333;', classes: 'greenColumn'}, |
{name: 'Column 4', cellClasses: 'yellowColumnData', classes: 'yellowColumn', styles: 'text-align: center;' }, |
{name: 'Column 5', headerStyles: 'background-image: none; background-color: #003333;', classes: 'greenColumn'}, |
{name: 'Column 6'}, |
{name: 'Column 7'}, |
]]}; |
// a grid structure is an array of views. |
var structure = [ leftView, middleView ]; |
function onStyleRow(inRow) { |
with (inRow) { |
var i = index % 10; |
var special = (i > 2 && i < 6); |
if (odd) |
customStyles += ' color: orange;'; |
if (selected) |
customClasses += ' selectedRow'; |
if (special) |
customClasses += ' specialRow'; |
if (over) |
customClasses += ' overRow'; |
if (!over && !selected) |
dojox.Grid.prototype.onStyleRow.apply(this, arguments); |
} |
} |
dojo.addOnLoad(function() { |
window["grid"] = dijit.byId('grid'); |
}); |
</script> |
</head> |
<body> |
<div class="heading">dojox.Grid Styling Example</div> |
<div id="grid" dojoType="dojox.Grid" onStyleRow="onStyleRow" model="model" structure="structure"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_dojo_data_notification.html |
---|
New file |
0,0 → 1,116 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" |
"http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid with Dojo.Data via binding</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/tundraGrid.css"; |
@import "../../../dojo/resources/dojo.css"; |
@import "../../../dijit/themes/tundra/tundra.css"; |
@import "../../../dijit/tests/css/dijitTests.css"; |
#grid, #grid2, #grid3 { |
width: 65em; |
height: 25em; |
padding: 1px; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="isDebug: true, debugAtAllCosts: false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.editors"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojox.data.CsvStore"); |
dojo.require("dojo.data.ItemFileWriteStore"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript"> |
function getRow(inRowIndex){ |
return ' ' + inRowIndex; |
} |
var iEditor = dojox.grid.editors.Input; |
var layoutMovies = [ |
// view 0 |
{ type: 'dojox.GridRowView', width: '20px' }, |
// view 1 |
{ cells: [[{ name: "Row", get: getRow, width: 5}]], noscroll: true}, |
// view 2 |
{ cells: [[ |
{ field: "Title", editor: iEditor, width: 'auto' }, |
{ field: "Year", editor: iEditor, width: 5 }, |
{ field: "Producer", editor: iEditor, width: 20 } |
]]} |
]; |
var layoutCountries = [ |
// view 0 |
{ type: 'dojox.GridRowView', width: '20px' }, |
// view 1 |
{ cells: [[{ name: "Row", get: getRow, width: 5}]], noscroll: true}, |
// view 2 |
{ cells: [[ |
{ field: "name", name: "Name", width: 'auto' }, |
{ field: "type", name: "Type", editor: iEditor, width: 'auto' }, |
]]} |
]; |
</script> |
</head> |
<body class="tundra"> |
<h1>dojox.Grid using Dojo.Data stores via simple binding</h1> |
<!-- |
<br> |
<span dojoType="dojox.data.CsvStore" |
jsId="csvStore" url="support/movies.csv"> |
</span> |
<span dojoType="dojox.grid.data.DojoData" |
jsId="dataModel" |
store="csvStore" |
rowsPerPage="5" |
query="{ Title: '*' }" |
clientSort="true"> |
</span> |
<div id="grid" dojoType="dojox.Grid" elasticView="2" |
model="dataModel" structure="layoutMovies"> |
</div> |
--> |
<br> |
<h3>Update some of the types</h3> |
<button onclick="updateCountryTypes();">Go!</button> |
<script> |
function updateCountryTypes(){ |
// get everything starting with "A" |
jsonStore.fetch({ |
query: { name: "A*" }, |
onComplete: function(items, result){ |
// change 'em! |
dojo.forEach(items, function(item){ |
jsonStore.setValue(item, "type", "thinger"); |
// console.debug(item); |
}); |
} |
}); |
} |
</script> |
<span dojoType="dojo.data.ItemFileWriteStore" |
jsId="jsonStore" url="../../../dijit/tests/_data/countries.json"> |
</span> |
<span dojoType="dojox.grid.data.DojoData" |
jsId="dataModel2" |
rowsPerPage="20" |
store="jsonStore" |
clientSort="true" |
query="{ name : '*' }"> |
</span> |
<div id="grid2" dojoType="dojox.Grid" elasticView="2" |
model="dataModel2" structure="layoutCountries"> |
</div> |
<div id="grid3" dojoType="dojox.Grid" elasticView="2" |
model="dataModel2" structure="layoutCountries"> |
</div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_grid_programmatic.html |
---|
New file |
0,0 → 1,66 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" |
"http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>Test dojox.Grid Programmatic Instantiation</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../../../dojo/resources/dojo.css"; |
@import "../_grid/tundraGrid.css"; |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
#grid { |
border: 1px solid #333; |
width: 50em; |
height: 30em; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="isDebug:false, debugAtAllCosts: false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript" src="support/test_data.js"></script> |
<script type="text/javascript"> |
dojo.addOnLoad(function(){ |
// a grid view is a group of columns |
var view1 = { |
cells: [ |
[ |
{name: 'Column 0'}, |
{name: 'Column 1'}, |
{name: 'Column 2'}, |
{name: 'Column 3', width: "150px"}, |
{name: 'Column 4'} |
], |
[ |
{name: 'Column 5'}, |
{name: 'Column 6'}, |
{name: 'Column 7'}, |
{name: 'Column 8', field: 3, colSpan: 2} |
] |
] |
}; |
// a grid layout is an array of views. |
var layout = [ view1 ]; |
var grid = new dojox.Grid({ |
"id": "grid", |
"model": model, |
"structure": layout |
}); |
dojo.byId("gridContainer").appendChild(grid.domNode); |
grid.render(); |
}); |
</script> |
</head> |
<body class="tundra"> |
<div class="heading">dojox.Grid Programmatic Instantiation Test</div> |
<div id="gridContainer"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/databaseModel.js |
---|
New file |
0,0 → 1,337 |
if(!dojo._hasResource["dojox.grid.tests.databaseModel"]){ //_hasResource checks added by build. Do not use _hasResource directly in your code. |
dojo._hasResource["dojox.grid.tests.databaseModel"] = true; |
dojo.provide("dojox.grid.tests.databaseModel"); |
dojo.require("dojox.grid._data.model"); |
// Provides a sparse array that is also traversable inorder |
// with basic Array: |
// - iterating by index is slow for large sparse arrays |
// - for...in iteration is in order of element creation |
// maintains a secondary index for interating |
// over sparse elements inorder |
dojo.declare("dojox.grid.Sparse", null, { |
constructor: function() { |
this.clear(); |
}, |
clear: function() { |
this.indices = []; |
this.values = []; |
}, |
length: function() { |
return this.indices.length; |
}, |
set: function(inIndex, inValue) { |
for (var i=0,l=this.indices.length; i<l; i++) { |
if (this.indices[i] >= inIndex) |
break; |
} |
if (this.indices[i] != inIndex) |
this.indices.splice(i, 0, inIndex); |
this.values[inIndex] = inValue; |
}, |
get: function(inIndex) { |
return this.values[inIndex]; |
}, |
remove: function(inIndex) { |
for (var i=0,l=this.indices.length; i<l; i++) |
if (this.indices[i] == inIndex) { |
this.indices.splice(i, 1); |
break; |
} |
delete this.values[inIndex]; |
}, |
inorder: function(inFor) { |
for (var i=0,l=this.indices.length, ix; i<l; i++) { |
ix = this.indices[i]; |
if (inFor(this.values[ix], ix) === false) |
break; |
} |
} |
}); |
// sample custom model implementation that works with mysql server. |
dojo.declare("dojox.grid.data.DbTable", dojox.grid.data.Dynamic, { |
delayedInsertCommit: true, |
constructor: function(inFields, inData, inServer, inDatabase, inTable) { |
this.server = inServer; |
this.database = inDatabase; |
this.table = inTable; |
this.stateNames = ['inflight', 'inserting', 'removing', 'error']; |
this.clearStates(); |
this.clearSort(); |
}, |
clearData: function() { |
this.cache = [ ]; |
this.clearStates(); |
this.inherited(arguments); |
}, |
clearStates: function() { |
this.states = {}; |
for (var i=0, s; (s=this.stateNames[i]); i++) { |
delete this.states[s]; |
this.states[s] = new dojox.grid.Sparse(); |
} |
}, |
// row state information |
getState: function(inRowIndex) { |
for (var i=0, r={}, s; (s=this.stateNames[i]); i++) |
r[s] = this.states[s].get(inRowIndex); |
return r; |
}, |
setState: function(inRowIndex, inState, inValue) { |
this.states[inState].set(inRowIndex, inValue||true); |
}, |
clearState: function(inRowIndex, inState) { |
if (arguments.length == 1) { |
for (var i=0, s; (s=this.stateNames[i]); i++) |
this.states[s].remove(inRowIndex); |
} else { |
for (var i=1, l=arguments.length, arg; (i<l) &&((arg=arguments[i])!=undefined); i++) |
this.states[arg].remove(inRowIndex); |
} |
}, |
setStateForIndexes: function(inRowIndexes, inState, inValue) { |
for (var i=inRowIndexes.length-1, k; (i>=0) && ((k=inRowIndexes[i])!=undefined); i--) |
this.setState(k, inState, inValue); |
}, |
clearStateForIndexes: function(inRowIndexes, inState) { |
for (var i=inRowIndexes.length-1, k; (i>=0) && ((k=inRowIndexes[i])!=undefined); i--) |
this.clearState(k, inState); |
}, |
//$ Return boolean stating whether or not an operation is in progress that may change row indexing. |
isAddRemoving: function() { |
return Boolean(this.states['inserting'].length() || this.states['removing'].length()); |
}, |
isInflight: function() { |
return Boolean(this.states['inflight'].length()); |
}, |
//$ Return boolean stating if the model is currently undergoing any type of edit. |
isEditing: function() { |
for (var i=0, r={}, s; (s=this.stateNames[i]); i++) |
if (this.states[s].length()) |
return true; |
}, |
//$ Return true if ok to modify the given row. Override as needed, using model editing state information. |
canModify: function(inRowIndex) { |
return !this.getState(inRowIndex).inflight && !(this.isInflight() && this.isAddRemoving()); |
}, |
// server send / receive |
getSendParams: function(inParams) { |
var p = { |
database: this.database || '', |
table: this.table || '' |
} |
return dojo.mixin(p, inParams || {}); |
}, |
send: function(inAsync, inParams, inCallbacks) { |
//console.log('send', inParams.command); |
var p = this.getSendParams(inParams); |
var d = dojo.xhrPost({ |
url: this.server, |
content: p, |
handleAs: 'json-comment-filtered', |
contentType: "application/x-www-form-urlencoded; charset=utf-8", |
sync: !inAsync |
}); |
d.addCallbacks(dojo.hitch(this, "receive", inCallbacks), dojo.hitch(this, "receiveError", inCallbacks)); |
return d; |
}, |
_callback: function(cb, eb, data) { |
try{ cb && cb(data); } |
catch(e){ eb && eb(data, e); } |
}, |
receive: function(inCallbacks, inData) { |
inCallbacks && this._callback(inCallbacks.callback, inCallbacks.errback, inData); |
}, |
receiveError: function(inCallbacks, inErr) { |
this._callback(inCallbacks.errback, null, inErr) |
}, |
encodeRow: function(inParams, inRow, inPrefix) { |
for (var i=0, l=inRow.length; i < l; i++) |
inParams['_' + (inPrefix ? inPrefix : '') + i] = (inRow[i] ? inRow[i] : ''); |
}, |
measure: function() { |
this.send(true, { command: 'info' }, { callback: dojo.hitch(this, this.callbacks.info) }); |
}, |
fetchRowCount: function(inCallbacks) { |
this.send(true, { command: 'count' }, inCallbacks); |
}, |
// server commits |
commitEdit: function(inOldData, inNewData, inRowIndex, inCallbacks) { |
this.setState(inRowIndex, "inflight", true); |
var params = {command: 'update'}; |
this.encodeRow(params, inOldData, 'o'); |
this.encodeRow(params, inNewData); |
this.send(true, params, inCallbacks); |
}, |
commitInsert: function(inRowIndex, inNewData, inCallbacks) { |
this.setState(inRowIndex, "inflight", true); |
var params = {command: 'insert'}; |
this.encodeRow(params, inNewData); |
this.send(true, params, inCallbacks); |
}, |
// NOTE: supported only in tables with pk |
commitDelete: function(inRows, inCallbacks) { |
var params = { |
command: 'delete', |
count: inRows.length |
} |
var pk = this.getPkIndex(); |
if (pk < 0) |
return; |
for (var i=0; i < inRows.length; i++) { |
params['_' + i] = inRows[i][pk]; |
} |
this.send(true, params, inCallbacks); |
}, |
getUpdateCallbacks: function(inRowIndex) { |
return { |
callback: dojo.hitch(this, this.callbacks.update, inRowIndex), |
errback: dojo.hitch(this, this.callbacks.updateError, inRowIndex) |
}; |
}, |
// primary key from fields |
getPkIndex: function() { |
for (var i=0, l=this.fields.count(), f; (i<l) && (f=this.fields.get(i)); i++) |
if (f.Key = 'PRI') |
return i; |
return -1; |
}, |
// model implementations |
update: function(inOldData, inNewData, inRowIndex) { |
var cbs = this.getUpdateCallbacks(inRowIndex); |
if (this.getState(inRowIndex).inserting) |
this.commitInsert(inRowIndex, inNewData, cbs); |
else |
this.commitEdit(this.cache[inRowIndex] || inOldData, inNewData, inRowIndex, cbs); |
// set push data immediately to model so reflectd while committing |
this.setRow(inNewData, inRowIndex); |
}, |
insert: function(inData, inRowIndex) { |
this.setState(inRowIndex, 'inserting', true); |
if (!this.delayedInsertCommit) |
this.commitInsert(inRowIndex, inData, this.getUpdateCallbacks(inRowIndex)); |
return this.inherited(arguments); |
}, |
remove: function(inRowIndexes) { |
var rows = []; |
for (var i=0, r=0, indexes=[]; (r=inRowIndexes[i]) !== undefined; i++) |
if (!this.getState(r).inserting) { |
rows.push(this.getRow(r)); |
indexes.push(r); |
this.setState(r, 'removing'); |
} |
var cbs = { |
callback: dojo.hitch(this, this.callbacks.remove, indexes), |
errback: dojo.hitch(this, this.callbacks.removeError, indexes) |
}; |
this.commitDelete(rows, cbs); |
dojox.grid.data.Dynamic.prototype.remove.apply(this, arguments); |
}, |
cancelModifyRow: function(inRowIndex) { |
if (this.isDelayedInsert(inRowIndex)) { |
this.removeInsert(inRowIndex); |
} else |
this.finishUpdate(inRowIndex); |
}, |
finishUpdate: function(inRowIndex, inData) { |
this.clearState(inRowIndex); |
var d = (inData&&inData[0]) || this.cache[inRowIndex]; |
if (d) |
this.setRow(d, inRowIndex); |
delete this.cache[inRowIndex]; |
}, |
isDelayedInsert: function(inRowIndex) { |
return (this.delayedInsertCommit && this.getState(inRowIndex).inserting); |
}, |
removeInsert: function(inRowIndex) { |
this.clearState(inRowIndex); |
dojox.grid.data.Dynamic.prototype.remove.call(this, [inRowIndex]); |
}, |
// request data |
requestRows: function(inRowIndex, inCount) { |
var params = { |
command: 'select', |
orderby: this.sortField, |
desc: (this.sortDesc ? "true" : ''), |
offset: inRowIndex, |
limit: inCount |
} |
this.send(true, params, {callback: dojo.hitch(this, this.callbacks.rows, inRowIndex)}); |
}, |
// sorting |
canSort: function () { |
return true; |
}, |
setSort: function(inSortIndex) { |
this.sortField = this.fields.get(Math.abs(inSortIndex) - 1).name || inSortIndex; |
this.sortDesc = (inSortIndex < 0); |
}, |
sort: function(inSortIndex) { |
this.setSort(inSortIndex); |
this.clearData(); |
}, |
clearSort: function(){ |
this.sortField = ''; |
this.sortDesc = false; |
}, |
endModifyRow: function(inRowIndex){ |
var cache = this.cache[inRowIndex]; |
var m = false; |
if(cache){ |
var data = this.getRow(inRowIndex); |
if(!dojox.grid.arrayCompare(cache, data)){ |
m = true; |
this.update(cache, data, inRowIndex); |
} |
} |
if (!m) |
this.cancelModifyRow(inRowIndex); |
}, |
// server callbacks (called with this == model) |
callbacks: { |
update: function(inRowIndex, inData) { |
console.log('received update', arguments); |
if (inData.error) |
this.updateError(inData) |
else |
this.finishUpdate(inRowIndex, inData); |
}, |
updateError: function(inRowIndex) { |
this.clearState(inRowIndex, 'inflight'); |
this.setState(inRowIndex, "error", "update failed: " + inRowIndex); |
this.rowChange(this.getRow(inRowIndex), inRowIndex); |
}, |
remove: function(inRowIndexes) { |
this.clearStateForIndexes(inRowIndexes); |
}, |
removeError: function(inRowIndexes) { |
this.clearStateForIndexes(inRowIndexes); |
alert('Removal error. Please refresh.'); |
}, |
rows: function(inRowIndex, inData) { |
//this.beginUpdate(); |
for (var i=0, l=inData.length; i<l; i++) |
this.setRow(inData[i], inRowIndex + i); |
//this.endUpdate(); |
//this.allChange(); |
}, |
count: function(inRowCount) { |
this.count = Number(inRowCount); |
this.clearData(); |
}, |
info: function(inInfo) { |
this.fields.clear(); |
for (var i=0, c; (c=inInfo.columns[i]); i++) { |
c.name = c.Field; |
this.fields.set(i, c); |
} |
this.table = inInfo.table; |
this.database = inInfo.database; |
this.notify("MetaData", arguments); |
this.callbacks.count.call(this, inInfo.count); |
} |
} |
}); |
} |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_subgrid.html |
---|
New file |
0,0 → 1,180 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid Subgrid Test</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> |
</meta> |
<style> |
@import "../../../dojo/resources/dojo.css"; |
@import "../_grid/tundraGrid.css"; |
body { font-size: 1.0em; } |
#grid { |
height: 400px; |
border: 1px solid silver; |
} |
.text-oneline { |
white-space: nowrap; |
overflow: hidden; |
text-overflow: ellipsis; |
} |
.text-scrolling { |
height: 4em; |
overflow: auto; |
} |
.text-scrolling { |
width: 21.5em; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="isDebug:true, debugAtAllCosts: false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript"> |
data = [ |
[ '3 stars', 'Averagia', 'Averagia', 8.99, 'An authentic experience defined by the intense layer of frothy, real facts. This combination package includes special T DISCS that work with your system to produce a perfectly serene experience. $8.99 per package. Please choose Regular (#NS1) or Decaffeinated (#NS4).' ], |
[ '2 stars', 'Cheapy', 'Cheapy', 6.29, 'Power and subtlety intersect for an experience with real character. Imported from Europe just for you. 16 T DISCS per package. $6.29 per package. #NJ4.' ], |
[ '4 stars', 'Luxuria', 'Luxuria', 6.49, 'A bold statement from the respected European brand Luxuria, topped with delicate zanthum. Imported exclusively for you. 18 T DISCS per package. $6.49 per package. #N42.</div>' ], |
[ '5 stars', 'Ultimo', 'Ultimo', 4.59, "A rich sensation of delicious experience, brought to you by one of Europe's oldest brands. A pure indulgence. 8 T DISCS per package. $4.59 per package. #NJ0." ] |
]; |
getDetailData = function(inRowIndex) { |
var row = data[this.grid.dataRow % data.length]; |
switch (this.index) { |
case 0: |
return row[0]; //'<img src="images/sample/' + row[0] + '" width="109" height="75">'; |
case 1: |
return (100000000 + this.grid.dataRow).toString().slice(1); |
case 2: |
return row[3]; |
case 3: |
return row[1]; |
case 4: |
return row[2]; |
case 5: |
return row[4]; |
default: |
return row[this.index]; |
} |
} |
getName = function(inRowIndex) { |
var row = data[inRowIndex % data.length]; |
return row[2]; |
} |
// Main grid structure |
var gridCells = [ |
{ type: 'dojox.GridRowView', width: '20px' }, |
{ |
onBeforeRow: function(inDataIndex, inSubRows) { |
inSubRows[1].hidden = !detailRows[inDataIndex]; |
}, |
cells: [[ |
{ name: '', width: 3, get: getCheck, styles: 'text-align: center;' }, { name: 'Name', get: getName, width: 40 }, |
], [ |
{ name: '', get: getDetail, colSpan: 2, styles: 'padding: 0; margin: 0;'} |
]] |
} |
]; |
// html for the +/- cell |
function getCheck(inRowIndex) { |
var image = (detailRows[inRowIndex] ? 'open.gif' : 'closed.gif'); |
var show = (detailRows[inRowIndex] ? 'false' : 'true') |
return '<img height="11" width="11" src="images/' + image + '" onclick="toggleDetail(' + inRowIndex + ', ' + show + ')">'; |
} |
// provide html for the Detail cell in the master grid |
function getDetail(inRowIndex) { |
var cell = this; |
// we can affect styles and content here, but we have to wait to access actual nodes |
setTimeout(function() { buildSubgrid(inRowIndex, cell); }, 1); |
// look for a subgrid |
var subGrid = dijit.byId(makeSubgridId(inRowIndex)); |
var h = (subGrid ? subGrid.cacheHeight : "120") + "px"; |
// insert a placeholder |
return '<div style="height: ' + h + '; background-color: white;"></div>'; |
} |
// the Detail cell contains a subgrid which we set up below |
var subGridCells = [{ |
noscroll: true, |
cells: [ |
[{ name: "Rating", rowSpan: 2, width: 10, noresize: true, styles: 'text-align:center;' }, |
{ name: "Sku" }, |
{ name: "Price" }, |
{ name: "Vendor" }, |
{ name: "Name", width: "auto" }], |
[{ name: "Description", colSpan: 4 }] |
]}]; |
var subGridProps = { |
structure: subGridCells, |
rowCount: 1, |
autoHeight: true, |
autoRender: false, |
"get": getDetailData |
}; |
// identify subgrids by their row indices |
function makeSubgridId(inRowIndex) { |
return grid.widgetId + "_subGrid_" + inRowIndex; |
} |
// if a subgrid exists at inRowIndex, detach it from the DOM |
function detachSubgrid(inRowIndex) { |
var subGrid = dijit.byId(makeSubgridId(inRowIndex)); |
if (subGrid) |
dojox.grid.removeNode(subGrid.domNode); |
} |
// render a subgrid into inCell at inRowIndex |
function buildSubgrid(inRowIndex, inCell) { |
var n = inCell.getNode(inRowIndex).firstChild; |
var id = makeSubgridId(inRowIndex); |
var subGrid = dijit.byId(id); |
if (subGrid) { |
n.appendChild(subGrid.domNode); |
} else { |
subGridProps.dataRow = inRowIndex; |
subGridProps.widgetId = id; |
subGrid = new dojox.VirtualGrid(subGridProps, n); |
} |
if (subGrid) { |
subGrid.render(); |
subGrid.cacheHeight = subGrid.domNode.offsetHeight; |
inCell.grid.rowHeightChanged(inRowIndex); |
} |
} |
// destroy subgrid at inRowIndex |
function destroySubgrid(inRowIndex) { |
var subGrid = dijit.byId(makeSubgridId(inRowIndex)); |
if (subGrid) subGrid.destroy(); |
} |
// when user clicks the +/- |
detailRows = []; |
function toggleDetail(inIndex, inShow) { |
if (!inShow) detachSubgrid(inIndex); |
detailRows[inIndex] = inShow; |
grid.updateRow(inIndex); |
} |
dojo.addOnLoad(function() { |
window["grid"] = dijit.byId("grid"); |
dojo.connect(grid, 'rowRemoved', destroySubgrid); |
}); |
</script> |
</head> |
<body class="tundra"> |
<div style="font-weight: bold; padding-bottom: 0.25em;">dojox.Grid showing sub-grid.</div> |
<div id="grid" dojoType="dojox.VirtualGrid" structure="gridCells" rowCount="100000" autoWidth="true"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_keyboard.html |
---|
New file |
0,0 → 1,91 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>Test dojox.Grid Basic</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
#grid { |
border: 1px solid #333; |
width: 35em; |
height: 30em; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:true, parseOnLoad: true"></script> |
<!--<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script>--> |
<!-- Debugging --> |
<script type="text/javascript" src="../_grid/lib.js"></script> |
<script type="text/javascript" src="../_grid/drag.js"></script> |
<script type="text/javascript" src="../_grid/scroller.js"></script> |
<script type="text/javascript" src="../_grid/builder.js"></script> |
<script type="text/javascript" src="../_grid/cell.js"></script> |
<script type="text/javascript" src="../_grid/layout.js"></script> |
<script type="text/javascript" src="../_grid/rows.js"></script> |
<script type="text/javascript" src="../_grid/focus.js"></script> |
<script type="text/javascript" src="../_grid/selection.js"></script> |
<script type="text/javascript" src="../_grid/edit.js"></script> |
<script type="text/javascript" src="../_grid/view.js"></script> |
<script type="text/javascript" src="../_grid/views.js"></script> |
<script type="text/javascript" src="../_grid/rowbar.js"></script> |
<script type="text/javascript" src="../_grid/publicEvents.js"></script> |
<script type="text/javascript" src="../VirtualGrid.js"></script> |
<script type="text/javascript" src="../_data/fields.js"></script> |
<script type="text/javascript" src="../_data/model.js"></script> |
<script type="text/javascript" src="../_data/editors.js"></script> |
<script type="text/javascript" src="../Grid.js"></script> |
<script type="text/javascript" src="support/test_data.js"></script> |
<script type="text/javascript"> |
// a grid view is a group of columns |
var view1 = { |
cells: [[ |
{name: 'Column 0'}, {name: 'Column 1'}, {name: 'Column 2'}, {name: 'Column 3', width: "150px"}, {name: 'Column 4'}, |
{name: 'Column 5'}, {name: 'Column 6'}, {name: 'Column 7', field: 0}, {name: 'Column 8'}, |
{name: 'Column 9'}, {name: 'Column 10'}, {name: 'Column 11', field: 0}, {name: 'Column 12', width: "150px"}, {name: 'Column 13'}, |
{name: 'Column 14'}, {name: 'Column 15'}, {name: 'Column 16', field: 0}, {name: 'Column 17'} |
]] |
}; |
// a grid layout is an array of views. |
var layout = [ view1 ]; |
function keyDown(e) { |
switch(e.keyCode){ |
case dojo.keys.LEFT_ARROW: |
console.log('left arrow!'); |
break; |
case dojo.keys.RIGHT_ARROW: |
console.log('right arrow!'); |
break; |
case dojo.keys.ENTER: |
console.log('enter!'); |
break; |
} |
} |
dojo.addOnLoad(function() { |
window["grid"] = dijit.byId("grid"); |
dojo.connect(grid, "onKeyDown", keyDown); |
}); |
</script> |
</head> |
<body> |
<div class="heading">dojox.Grid Basic Test</div> |
<div id="grid" dojoType="dojox.Grid" model="model" structure="layout"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_tundra_edit.html |
---|
New file |
0,0 → 1,140 |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" |
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
<html xmlns="http://www.w3.org/1999/xhtml"> |
<head> |
<title>Test dojox.Grid Editing</title> |
<style> |
@import "../_grid/tundraGrid.css"; |
@import "../../../dojo/resources/dojo.css"; |
@import "../../../dijit/themes/tundra/tundra.css"; |
@import "../../../dijit/tests/css/dijitTests.css"; |
.dojoxGrid-row-editing td { |
background-color: #F4FFF4; |
} |
.dojoxGrid input, .dojoxGrid select, .dojoxGrid textarea { |
margin: 0; |
padding: 0; |
border-style: none; |
width: 100%; |
font-size: 100%; |
font-family: inherit; |
} |
.dojoxGrid input { |
} |
.dojoxGrid select { |
} |
.dojoxGrid textarea { |
} |
#controls { |
padding: 6px 0; |
} |
#controls button { |
margin-left: 10px; |
} |
.myGrid { |
width: 850px; |
height: 350px; |
border: 1px solid silver; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript"> |
// ========================================================================== |
// Create a data model |
// ========================================================================== |
data = [ |
[ "normal", false, "new", 'But are not followed by two hexadecimal', 29.91, 10, false ], |
[ "important", false, "new", 'Because a % sign always indicates', 9.33, -5, false ], |
[ "important", false, "read", 'Signs can be selectively', 19.34, 0, true ], |
[ "note", false, "read", 'However the reserved characters', 15.63, 0, true ], |
[ "normal", false, "replied", 'It is therefore necessary', 24.22, 5.50, true ], |
[ "important", false, "replied", 'To problems of corruption by', 9.12, -3, true ], |
[ "note", false, "replied", 'Which would simply be awkward in', 12.15, -4, false ] |
]; |
var rows = 10000; |
for(var i=0, l=data.length; i<rows-l; i++){ |
data.push(data[i%l].slice(0)); |
} |
model = new dojox.grid.data.Table(null, data); |
// ========================================================================== |
// Tie some UI to the data model |
// ========================================================================== |
model.observer(this); |
modelChange = function(){ |
dojo.byId("rowCount").innerHTML = 'Row count: ' + model.count; |
} |
// ========================================================================== |
// Custom formatter |
// ========================================================================== |
formatMoney = function(inDatum){ |
return isNaN(inDatum) ? '...' : '$' + parseFloat(inDatum).toFixed(2); |
} |
// ========================================================================== |
// Grid structure |
// ========================================================================== |
statusCell = { |
field: 2, |
name: 'Status', |
styles: 'text-align: center;', |
editor: dojox.grid.editors.Select, |
options: [ "new", "read", "replied" ] |
}; |
gridLayout = [ |
{ |
type: 'dojox.GridRowView', width: '20px' |
}, |
{ |
defaultCell: { width: 8, editor: dojox.grid.editors.Input, styles: 'text-align: right;' }, |
rows: [ |
[ |
{ name: 'Id', width: 3, get: function(inRowIndex){ return inRowIndex+1;} }, |
{ name: 'Priority', styles: 'text-align: center;', editor: dojox.grid.editors.Select, options: ["normal", "note", "important"]}, |
{ name: 'Mark', width: 3, styles: 'text-align: center;', editor: dojox.grid.editors.Bool }, |
statusCell, |
{ name: 'Message', styles: '', width: '100%' }, |
{ name: 'Amount', formatter: formatMoney } |
] |
] |
} |
]; |
// ========================================================================== |
// UI Action |
// ========================================================================== |
addRow = function() { |
grid.addRow([ "normal", false, "new", 'Now is the time for all good men to come to the aid of their party.', 99.99, 9.99, false ]); |
} |
</script> |
</head> |
<body class="tundra"> |
<h1>dojox.Grid Basic Editing test</h1> |
<br /> |
<div id="controls"> |
<button onclick="grid.refresh()">Refresh</button> |
<button onclick="grid.edit.focusEditor()">Focus Editor</button> |
<button onclick="grid.focus.next()">Next Focus</button> |
<button onclick="addRow()">Add Row</button> |
<button onclick="grid.removeSelectedRows()">Remove</button> |
<button onclick="grid.edit.apply()">Apply</button> |
<button onclick="grid.edit.cancel()">Cancel</button> |
<button onclick="grid.singleClickEdit = !grid.singleClickEdit">Toggle singleClickEdit</button> |
</div> |
<br /> |
<div jsId="grid" class="myGrid" |
dojoType="dojox.Grid" model="model" |
structure="gridLayout"></div> |
<br /> |
<div id="rowCount"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_sizing.html |
---|
New file |
0,0 → 1,154 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid Sizing Example</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../../../dojo/resources/dojo.css"; |
@import "../_grid/tundraGrid.css"; |
/* |
@import "../_grid/Grid.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
*/ |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
#container { |
width: 400px; |
height: 200px; |
border: 4px double #333; |
} |
#grid { |
border: 1px solid #333; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript"> |
data = [ |
[ "normal", false, "new", 'But are not followed by two hexadecimal', 29.91, 10, false ], |
[ "important", false, "new", 'Because a % sign always indicates', 9.33, -5, false ], |
[ "important", false, "read", 'Signs can be selectively', 19.34, 0, true ], |
[ "note", false, "read", 'However the reserved characters', 15.63, 0, true ], |
[ "normal", false, "replied", 'It is therefore necessary', 24.22, 5.50, true ], |
[ "important", false, "replied", 'To problems of corruption by', 9.12, -3, true ], |
[ "note", false, "replied", 'Which would simply be awkward in', 12.15, -4, false ] |
]; |
model = new dojox.grid.data.table(null, data); |
// grid structure |
// a grid view is a group of columns |
// a special view providing selection feedback |
var rowBar = {type: 'dojox.GridRowView', width: '20px'}; |
// a view without scrollbars |
var leftView = { |
noscroll: true, |
cells: [[ |
{name: 'Column 0'}, |
{name: 'Column 1'} |
]]}; |
var middleView = { |
cells: [[ |
{name: 'Column 2'}, |
{name: 'Column 3'}, |
{name: 'Column 4'}, |
{name: 'Column 5'}, |
{name: 'Column 6'}, |
]]}; |
// a grid structure is an array of views. |
var structure = [ rowBar, leftView, middleView]; |
// get can return data for each cell of the grid |
function get(inRowIndex) { |
return [this.index, inRowIndex].join(', '); |
} |
function resizeInfo() { |
setTimeout(function() { |
dojo.byId('gridWidth').value = grid.domNode.clientWidth; |
dojo.byId('gridHeight').value = grid.domNode.clientHeight; |
}, 1); |
} |
function resizeGrid() { |
grid.autoHeight = false; |
grid.autoWidth = false; |
var |
w = Number(dojo.byId('gridWidth').value), |
h = Number(dojo.byId('gridHeight').value); |
dojo.contentBox(grid.domNode, {w: w, h: h}); |
grid.update(); |
} |
function fitWidth() { |
grid.autoWidth = true; |
grid.autoHeight = false; |
grid.update(); |
} |
function fitHeight() { |
grid.autoWidth = false; |
grid.autoHeight = true; |
grid.update(); |
} |
function fitBoth() { |
grid.autoWidth = true; |
grid.autoHeight = true; |
grid.update(); |
} |
function sizeDefault() { |
grid.autoWidth = false; |
grid.autoHeight = false; |
grid.domNode.style.width = ''; |
grid.domNode.style.height = 0; |
grid.update(); |
} |
dojo.addOnLoad(function() { |
window["grid"] = dijit.byId("grid"); |
dojo.byId('gridWidth').value = 500; |
dojo.byId('gridHeight').value = 200; |
dojo.connect(grid, 'update', resizeInfo); |
resizeGrid(); |
window["grid1"] = dijit.byId("grid1"); |
}); |
</script> |
</head> |
<body class="tundra"> |
<div class="heading">dojox.Grid Sizing Test</div> |
Grid width: <input id="gridWidth" type="text"> |
and height: <input id="gridHeight" type="text"> |
<button onclick="resizeGrid()">Resize Grid</button><br><br> |
<button onclick="fitWidth()">Fit Data Width</button> |
<button onclick="fitHeight()">Fit Data Height</button> |
<button onclick="fitBoth()">Fit Data Width & Height</button> |
<button onclick="sizeDefault()">DefaultSize</button><br><br> |
<div id="grid" dojoType="dojox.Grid" model="model" structure="structure" elasticView="2"></div> |
<p>Grid fits to a sized container by default:</p> |
<div id="container"> |
<div id="grid1" dojoType="dojox.VirtualGrid" get="get" structure="structure" rowCount="10" elasticView="2"></div> |
</div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/images/closed.gif |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
/trunk/api/js/dojo1.0/dojox/grid/tests/images/closed.gif |
---|
New file |
Property changes: |
Added: svn:mime-type |
+application/octet-stream |
\ No newline at end of property |
/trunk/api/js/dojo1.0/dojox/grid/tests/images/open.gif |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
/trunk/api/js/dojo1.0/dojox/grid/tests/images/open.gif |
---|
New file |
Property changes: |
Added: svn:mime-type |
+application/octet-stream |
\ No newline at end of property |
/trunk/api/js/dojo1.0/dojox/grid/tests/images/flatScreen.gif |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
/trunk/api/js/dojo1.0/dojox/grid/tests/images/flatScreen.gif |
---|
New file |
Property changes: |
Added: svn:mime-type |
+application/octet-stream |
\ No newline at end of property |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_yahoo_search.html |
---|
New file |
0,0 → 1,142 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid - Yahoo Search Test</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style> |
@import "../_grid/Grid.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
.grid { |
height: 30em; |
} |
#info { |
width: 700px; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript" src="yahooSearch.js"></script> |
<script type="text/javascript"> |
webFields = [ |
{ name: 'Title', na: '' }, |
{ name: 'ModificationDate', na: ''}, |
{ name: 'Summary', na: ' ' }, |
{ name: 'Url', na: '' }, |
{ name: 'MimeType', na: ' '}, |
{ name: 'DisplayUrl', na: ' '} |
]; |
imageFields = [ |
{ name: 'Title', na: '' }, |
{ name: 'Thumbnail', na: ''}, |
{ name: 'Summary', na: '' }, |
{ name: 'Url', na: '' }, |
{ name: 'FileSize', na: ''}, |
{ name: 'Height', na: ''}, |
{ name: 'Width', na: ''} |
]; |
var model = new dojox.grid.data.yahooSearch(imageFields, null, "searchInput"); |
model.observer(this); |
// report some model send/receive status |
model.onSend = function(inParams) { |
dojo.byId('sendInfo').innerHTML = dojo.string.substitute('Request rows ${0} to ${1}.  ', [inParams.start, inParams.start + inParams.results -1] ); |
} |
model.onReceive = function(inData) { |
dojo.byId('receiveInfo').innerHTML = dojo.string.substitute('Receive rows ${0} to ${1}.  ', [inData.firstResultPosition, inData.firstResultPosition + inData.totalResultsReturned-1]); |
} |
var webLayout = [ |
{ type: 'dojox.GridRowView', width: '20px' }, |
{ noscroll: true, |
cells: [ |
[ { name: 'Row', width: 3, styles: 'text-align: center;', get: function(inRowIndex) { return inRowIndex + 1 } }] |
] |
}, |
{ cells: [ |
[ { name: 'Site', width: 30, field: 3, extraField: 0, formatter: formatLink }, { name: 'Date', width: 10, field: 1, formatter: formatDate} ], |
[ { name: 'Display Url', width: 30, field: 5, styles: 'color: green; size: small;' }, { name: 'Type', width: 10, field: 4, styles: ' font-style: italic; color: gray; size: small;'} ], |
[ { name: 'Summary', width: 40, colSpan: 2, field: 2 } ] |
]} |
]; |
// remove the height from the header image cell / row cells have a default height so there's less adjustment when thumb comes in. |
beforeImageRow = function(inRowIndex, inSubRow) { |
inSubRow[0][0].cellStyles = (inRowIndex == -1 ? '' : 'height: 100px;'); |
inSubRow[1][0].cellStyles = (inRowIndex == -1 ? '' : 'vertical-align: top; height: 75px;'); |
} |
var imageLayout = [ |
{ type: 'dojox.GridRowView', width: '20px' }, |
{ noscroll: true, |
cells: [ |
[ { name: 'Row', width: 3, styles: 'text-align: center;', get: function(inRowIndex) { return inRowIndex + 1 } }] |
] |
}, |
{ onBeforeRow: beforeImageRow, |
cells: [ |
[ { name: 'Image', cellStyles: "height: 100px;", styles: "text-align: center;", width: 13, rowSpan: 2, field: 3, extraField: 1, formatter: formatImage }, |
{ name: 'Title', cellStyles: "height: 10px;", width: 14, field: 3, extraField: 0, formatter: formatLink }, |
{ name: 'Size', width: 8, field: 4, styles: "font-style: italic; text-align: center;" }, |
{ name: 'Dimensions', width: 8, field: 6, extraField: 5, styles: "text-align: center;", formatter: formatDimensions } |
], |
[ { name: 'Summary', cellStyles: "vertical-align: top; height: 75px;", colSpan: 3, field: 2 } ] |
]} |
]; |
// execute search |
doSearch = function() { |
var web = dojo.byId('webRb').checked; |
model.setRowCount(0); |
model.clear(); |
model.fields.set(web ? webFields : imageFields); |
model.url = 'http://search.yahooapis.com/' + (web ? 'WebSearchService/V1/webSearch' : 'ImageSearchService/V1/imageSearch'); |
grid.scrollToRow(0); |
grid.setStructure(web ? webLayout : imageLayout); |
model.requestRows(); |
} |
// do search on enter... |
keypress = function(e) { |
if (e.keyCode == dojo.keys.ENTER) |
doSearch(); |
} |
dojo.addOnLoad(function() { |
dojo.byId('webRb').checked = "checked"; |
dojo.connect(dojo.byId("searchInput"), "keypress", keypress); |
doSearch(); |
}); |
</script> |
</head> |
<body> |
<div style="font-weight: bold; padding-bottom: 0.25em;">dojox.Grid - Yahoo Search Test</div> |
<div style="padding-bottom: 3px;"> |
<label><input id="webRb" type="radio" name="searchType" checked>Web</label> |
<label><input id="imageRb" type="radio" name="searchType">Images</label> |
</div> |
<input id="searchInput" type="text" value="apple"> |
<button onclick="doSearch()">Search</button><br><br> |
<div jsId="grid" class="grid" autoWidth="true" structure="webLayout" dojoType="dojox.Grid" model="model" elasticView="1"></div> |
<br> |
<div id="info"> |
<div id="rowCount" style="float: left"></div> |
<div style="float: right"> |
<div id="sendInfo" style="text-align: right"></div> |
<div id="receiveInfo" style="text-align: right"></div> |
</div> |
</div> |
<br /><br /> |
<p>Note: requires PHP for proxy.</p> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_yahoo_images.html |
---|
New file |
0,0 → 1,140 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid - Image Search Test</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style> |
@import "../_grid/Grid.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
.grid { |
height: 30em; |
width: 51em; |
border: 1px solid silver; |
} |
#info { |
width: 700px; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript" src="yahooSearch.js"></script> |
<script type="text/javascript"> |
// model fields |
imageFields = [ |
{ name: 'Title', na: '' }, |
{ name: 'Thumbnail', na: ''}, |
{ name: 'Summary', na: '' }, |
{ name: 'Url', na: '' }, |
{ name: 'FileSize', na: ''}, |
{ name: 'Height', na: ''}, |
{ name: 'Width', na: ''} |
]; |
// create data model |
var model = new dojox.grid.data.yahooSearch(imageFields, null, "searchInput"); |
model.url = 'http://search.yahooapis.com/ImageSearchService/V1/imageSearch'; |
model.observer(this); |
// report some model send/receive status |
model.onSend = function(inParams) { |
dojo.byId('sendInfo').innerHTML = dojo.string.substitute('Request rows ${0} to ${1}.  ', [inParams.start, inParams.start + inParams.results -1]); |
} |
model.onReceive = function(inData) { |
dojo.byId('receiveInfo').innerHTML = dojo.string.substitute('Receive rows ${0} to ${1}.  ', [inData.firstResultPosition, inData.firstResultPosition + inData.totalResultsReturned-1]); |
} |
// Define grid structure |
// remove the height from the header image cell / row cells have a default height so there's less adjustment when thumb comes in. |
beforeImageRow = function(inRowIndex, inSubRows) { |
inSubRows[0].hidden = (inRowIndex == -1); |
} |
var imageLayout = [ |
{ onBeforeRow: beforeImageRow, |
cells: [ |
[ { name: 'Image', cellStyles: "height: 100px;", styles: "text-align: center;", width: 12, field: 3, extraField: 1, formatter: formatImage }, |
{ name: 'Image', cellStyles: "height: 100px;", styles: "text-align: center;", width: 12, field: 3, extraField: 1, formatter: formatImage }, |
{ name: 'Image', cellStyles: "height: 100px;", styles: "text-align: center;", width: 12, field: 3, extraField: 1, formatter: formatImage }, |
{ name: 'Image', cellStyles: "height: 100px;", styles: "text-align: center;", width: 12, field: 3, extraField: 1, formatter: formatImage } |
] |
]} |
]; |
// Create grid subclass to function as we need to display images only. |
// adds indirection between model row and grid row. |
dojo.declare("dojox.ImageGrid", dojox.Grid, { |
postCreate: function() { |
this.inherited(arguments); |
this.modelDatumChange = this.modelRowChange; |
this.colCount = this.layout.cells.length; |
}, |
getDataRowIndex: function(inCell, inRowIndex) { |
var r = inCell.index + Math.floor(inRowIndex * this.colCount); |
return r; |
}, |
// called in cell context |
get: function(inRowIndex) { |
var r = this.grid.getDataRowIndex(this, inRowIndex); |
return dojox.Grid.prototype.get.call(this, r); |
}, |
modelAllChange: function(){ |
this.rowCount = Math.ceil(this.model.getRowCount() / this.colCount); |
this.updateRowCount(this.rowCount); |
}, |
modelRowChange: function(inData, inRowIndex) { |
if (inRowIndex % this.colCount == this.colCount - 1 || inRowIndex == this.model.count - 1) |
this.updateRow(Math.floor(inRowIndex / this.colCount)); |
} |
}); |
getCellData = function(inCell, inRowIndex, inField) { |
var m = inCell.grid.model, r = inCell.grid.getDataRowIndex(inCell, inRowIndex); |
return m.getDatum(r, inField); |
} |
// execute search |
doSearch = function() { |
model.clearData(); |
model.setRowCount(0); |
grid.render(); |
grid.resize(); |
model.requestRows(); |
} |
keypress = function(e) { |
if (e.keyCode == dojo.keys.ENTER) |
doSearch(); |
} |
dojo.addOnLoad(function() { |
dojo.connect(dojo.byId("searchInput"), "keypress", keypress); |
doSearch(); |
}); |
</script> |
</head> |
<body> |
<div style="font-weight: bold; padding-bottom: 0.25em;">dojox.Grid - Image Search Test</div> |
<input id="searchInput" type="text" value="apple"> |
<button onclick="doSearch()">Search</button><br> |
<br> |
<div jsId="grid" class="grid" structure="imageLayout" dojoType="dojox.ImageGrid" model="model"></div> |
<br> |
<div id="info"> |
<div id="rowCount" style="float: left"></div> |
<div style="float: right"> |
<div id="sendInfo" style="text-align: right"></div> |
<div id="receiveInfo" style="text-align: right"></div> |
</div> |
</div> |
<br /><br /> |
<p>Note: requires PHP for proxy.</p> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_dojo_data_model.html |
---|
New file |
0,0 → 1,85 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid with Dojo.Data via binding</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../../../dojo/resources/dojo.css"; |
@import "../_grid/tundraGrid.css"; |
#grid, #grid2 { |
width: 65em; |
height: 25em; |
padding: 1px; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="isDebug: true, debugAtAllCosts: false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.data.ItemFileReadStore"); |
dojo.require("dojox.data.CsvStore"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript"> |
function getRow(inRowIndex){ |
return ' ' + inRowIndex; |
} |
var layoutMovies = [ |
// view 0 |
{ type: 'dojox.GridRowView', width: '20px' }, |
// view 1 |
{ cells: [[{ name: "Row", get: getRow, width: 5}]], noscroll: true}, |
// view 2 |
{ cells: [[ |
{ field: "Title", width: 'auto' }, |
{ field: "Year", width: 5 }, |
{ field: "Producer", width: 20 } |
]]} |
]; |
var layoutCountries = [ |
// view 0 |
{ type: 'dojox.GridRowView', width: '20px' }, |
// view 1 |
{ cells: [[{ name: "Row", get: getRow, width: 5}]], noscroll: true}, |
// view 2 |
{ cells: [[ |
{ field: 0, width: 'auto' }, |
{ width: 8 } |
]]} |
]; |
</script> |
</head> |
<body class="tundra"> |
<h5>dojox.Grid using Dojo.Data stores via simple binding</h5> |
<span dojoType="dojox.data.CsvStore" |
jsId="csvStore" url="support/movies.csv"> |
</span> |
<span dojoType="dojox.grid.data.DojoData" |
jsId="dataModel" |
store="csvStore" |
rowsPerPage="5" |
query="{ Title: '*' }" |
clientSort="true"> |
</span> |
<div id="grid" dojoType="dojox.Grid" elasticView="2" |
model="dataModel" structure="layoutMovies"> |
</div> |
<span dojoType="dojo.data.ItemFileReadStore" |
jsId="jsonStore" url="../../../dijit/tests/_data/countries.json"> |
</span> |
<span dojoType="dojox.grid.data.DojoData" |
jsId="dataModel2" |
rowsPerPage="20" |
store="jsonStore" |
query="{ name : '*' }"> |
</span> |
<div id="grid2" dojoType="dojox.Grid" elasticView="2" |
model="dataModel2" structure="layoutCountries"> |
</div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_events.html |
---|
New file |
0,0 → 1,172 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>Test dojox.Grid Events</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
body,td,th { |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
#grid { |
border: 1px solid; |
border-top-color: #F6F4EB; |
border-right-color: #ACA899; |
border-bottom-color: #ACA899; |
border-left-color: #F6F4EB; |
} |
#grid { |
width: 50em; |
height: 20em; |
padding: 1px; |
overflow: hidden; |
font-size: small; |
} |
h3 { |
margin: 10px 0 2px 0; |
} |
.fade { |
/*background-image:url(images/fade.gif);*/ |
} |
.no-fade { |
/*background-image: none;*/ |
} |
#eventGrid { |
float: right; |
font-size: small; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript"> |
// events to track |
var eventRows = [ |
{ name: 'onCellClick' }, |
{ name: 'onRowClick', properties: ['rowIndex'] }, |
{ name: 'onCellDblClick' }, |
{ name: 'onRowDblClick', properties: ['rowIndex'] }, |
{ name: 'onCellMouseOver' }, |
{ name: 'onCellMouseOut' }, |
{ name: 'onRowMouseOver' }, |
{ name: 'onRowMouseOut' }, |
{ name: 'onHeaderCellClick' }, |
{ name: 'onHeaderClick', properties: ['rowIndex'] }, |
{ name: 'onHeaderCellDblClick' }, |
{ name: 'onHeaderDblClick', properties: ['rowIndex'] }, |
{ name: 'onHeaderCellMouseOver' }, |
{ name: 'onHeaderCellMouseOut' }, |
{ name: 'onHeaderMouseOver' }, |
{ name: 'onHeaderMouseOut' }, |
{ name: 'onKeyDown', properties: ['keyCode'] }, |
{ name: 'onCellContextMenu' }, |
{ name: 'onRowContextMenu', properties: ['rowIndex'] }, |
{ name: 'onHeaderCellContextMenu' }, |
{ name: 'onHeaderContextMenu', properties: ['rowIndex'] } |
]; |
getEventName = function(inRowIndex) { |
return eventRows[inRowIndex].name; |
}; |
getEventData = function(inRowIndex) { |
var d = eventRows[inRowIndex].data; |
var r = []; |
if (d) |
for (var i in d) |
r.push(d[i]); |
else |
r.push('na') |
return r.join(', '); |
} |
// grid structure for event tracking grid. |
var eventView = { |
noscroll: true, |
cells: [[ |
{ name: 'Event', get: getEventName, width: 12 }, |
{ name: 'Data', get: getEventData, width: 10 } |
]] |
} |
var eventLayout = [ eventView ]; |
var fade = function(inNode) { |
if (!inNode || !inNode.style) return; |
var c = 150, step = 5, delay = 20; |
var animate = function() { |
c = Math.min(c + step, 255); |
inNode.style.backgroundColor = "rgb(" + c + ", " + c + ", 255)"; |
if (c < 255) window.setTimeout(animate, delay); |
} |
animate(); |
} |
// setup a fade on a row. Must do this way to avoid caching of fade gif |
updateRowFade = function(inRowIndex) { |
var n = eventGrid.views.views[0].getRowNode(inRowIndex); |
fade(n); |
} |
// store data about event. By default track event.rowIndex and event.cell.index, but eventRows can specify params, which are event properties to track. |
setEventData = function(inIndex, inEvent) { |
var eRow = eventRows[inIndex]; |
eRow.data = {}; |
var properties = eRow.properties; |
if (properties) |
for (var i=0, l=properties.length, p; (p=properties[i] || i < l); i++) |
eRow.data[p] = inEvent[p]; |
else |
eRow.data = { |
row: (inEvent.rowIndex != undefined ? Number(inEvent.rowIndex) : 'na'), |
cell: (inEvent.cell && inEvent.cell.index != undefined ? inEvent.cell.index : 'na') |
} |
eventGrid.updateRow(inIndex); |
updateRowFade(inIndex); |
} |
// setup grid events for all events being tracked. |
setGridEvents = function() { |
var makeEvent = function(inIndex, inName) { |
return function(e) { |
setEventData(inIndex, e); |
dojox.VirtualGrid.prototype[inName].apply(this, arguments); |
} |
} |
for (var i=0, e; (e=eventRows[i]); i++) |
grid[e.name] = makeEvent(i, e.name); |
} |
// Grid structure |
var layout = [// array of view objects |
{ type: 'dojox.GridRowView', width: '20px' }, |
{ noscroll: true, cells: [// array of rows, a row is an array of cells |
[{ name: "Alpha", value: '<input type="checkbox"></input>', rowSpan: 2, width: 6, styles: 'text-align:center;' }, { name: "Alpha2", value: "Alpha2" }], |
[{ name: "Alpha3", value: "Alpha3" }] |
]}, |
{ cells: [ |
[{ name: "Beta", value: 'simple'}, { name: "Beta2", value: "Beta2" }, { name: "Beta3", value: "Beta3" }, { name: "Beta4", value: "Beta4" }, { name: "Beta5", value: "Beta5" }], |
[{ name: "Summary", colSpan: 5, value: 'Summary' }] |
]}, |
{ noscroll: true, cells: [ |
[{ name: "Gamma", value: "Gamma" }, { name: "Gamma2", value: "<button>Radiate</button>", styles: 'text-align:center;' }]] |
}]; |
dojo.addOnLoad(function() { |
window["grid"] = dijit.byId("grid"); |
window["eventGrid"] = dijit.byId("eventGrid"); |
grid.rows.defaultRowHeight = 4; |
setGridEvents(); |
eventGrid.updateRowCount(eventRows.length); |
dojo.debug = console.log; |
}); |
</script> |
</head> |
<body> |
<h3>dojox.Grid Event Tracking</h3> |
<div id="eventGrid" autoWidth="true" autoHeight="true" structure="eventLayout" dojoType="dojox.VirtualGrid"></div> |
<div id="grid" rowCount="100" dojoType="dojox.VirtualGrid"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_change_structure.html |
---|
New file |
0,0 → 1,125 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
<html> |
<head> |
<title>dojox.Grid Change Structure Example</title> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta> |
<style type="text/css"> |
@import "../_grid/Grid.css"; |
body { |
font-size: 0.9em; |
font-family: Geneva, Arial, Helvetica, sans-serif; |
} |
.heading { |
font-weight: bold; |
padding-bottom: 0.25em; |
} |
#grid { |
border: 1px solid #333; |
width: 48em; |
height: 30em; |
} |
#grid .dojoxGrid-cell { |
text-align: center; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" djConfig="isDebug:false, parseOnLoad: true"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojo.parser"); |
</script> |
<script type="text/javascript"> |
// get can return data for a cell of the grid |
function get(inRowIndex) { |
return [this.index, inRowIndex].join(', '); |
} |
// grid structure |
// a grid view is a group of columns |
// a special view providing selection feedback |
var rowBar = {type: 'dojox.GridRowView', width: '20px' }; |
// a view without scrollbars |
var view0 = { |
noscroll: true, |
cells: [[ |
{name: 'Alpha', value: '<input name="" type="checkbox" value="0">'}, |
{name: 'Beta', get: get, width: 4.5} |
]]}; |
var view1 = { |
cells: [[ |
{name: 'Apple', value: '<button>Apple</button>'}, |
{name: 'Banana', get: get}, |
{name: 'Beans', value: 'Happy to be grid!'}, |
{name: 'Kiwi', get: get}, |
{name: 'Orange', value: '<img src="images/flatScreen.gif" height="48" width="48">'}, |
{name: 'Pear', get: get}, |
{name: 'Tomato', width: 20, value: '<input name="" type="file">'}, |
]]}; |
var view2 = { |
noscroll: true, |
cells: [ |
[ |
{name: 'Alpha', value: '<input name="" type="checkbox" value="0">', rowSpan: 2}, |
{name: 'Beta', get: get, width: 4.5} |
], [ |
{name: 'Gamma', get: get} |
], |
[ |
{name: 'Epsilon', value: '<button>Epsilon</button>', colSpan: 2} |
] |
] |
} |
var view3 = { |
cells: [ |
[ |
{name: 'Apple', value: '<button>Apple</button>', rowSpan: 3}, |
{name: 'Banana', get: get, width: 20}, |
{name: 'Kiwi', get: get, width: 20}, |
{name: 'Pear', get: get, width: 20}, |
], |
[ |
{name: 'Beans', value: 'Happy to be grid!'}, |
{name: 'Orange', value: '<img src="images/flatScreen.gif" height="48" width="48">'}, |
{name: 'Tomato', value: '<input name="" type="file">'} |
], [ |
{name: 'Zuchini', value: '<span style="letter-spacing: 10em;">wide</span>', colSpan: 3} |
] |
]}; |
// a grid structure is an array of views. |
// By default the middle view will be 'elastic', sized to fit the remaining space left by other views |
// grid.elasticView can also be manually set |
var structure = [ rowBar, view0, view1 ]; |
var structure2 = [ rowBar, view2, view3 ]; |
var l2 = false; |
toggleStructure = function() { |
l2 = !l2; |
grid.scrollToRow(0); |
grid.setStructure(l2 ? structure2 : structure); |
} |
dojo.addOnLoad(function() { |
window["grid"] = dijit.byId("grid"); |
}); |
</script> |
</head> |
<body> |
<div class="heading">dojox.VirtualGrid Change Structure Example</div> |
<p> |
<button onclick="toggleStructure()">Change Structure</button> |
</p> |
<div id="grid" dojoType="dojox.VirtualGrid" structure="structure" rowCount="100000" elasticView="2"></div> |
</body> |
</html> |
/trunk/api/js/dojo1.0/dojox/grid/tests/test_edit_dijit.html |
---|
New file |
0,0 → 1,138 |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" |
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
<html xmlns="http://www.w3.org/1999/xhtml"> |
<head> |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
<title>Test dojox.Grid Editing</title> |
<style type="text/css"> |
@import "../_grid/tundraGrid.css"; |
@import "../../../dojo/resources/dojo.css"; |
@import "../../../dijit/themes/tundra/tundra.css"; |
@import "../../../dijit/tests/css/dijitTests.css"; |
#controls button { |
margin-left: 10px; |
} |
#grid { |
width: 850px; |
height: 350px; |
border: 1px solid silver; |
} |
</style> |
<script type="text/javascript" src="../../../dojo/dojo.js" |
djConfig="isDebug: true, parseOnLoad: true"></script> |
<script type="text/javascript" src="../../../dijit/tests/_testCommon.js"></script> |
<script type="text/javascript"> |
dojo.require("dojox.grid.Grid"); |
dojo.require("dojox.grid._data.model"); |
dojo.require("dojox.grid._data.dijitEditors"); |
dojo.require("dojo.parser"); |
// ========================================================================== |
// Create a data model |
// ========================================================================== |
s = (new Date()).getTime(); |
data = [ |
[ "normal", false, "new", 'But are not followed by two hexadecimal', 29.91, 10, false, s], |
[ "important", false, "new", 'Because a % sign always indicates', 9.33, -5, false, s ], |
[ "important", false, "read", 'Signs can be selectively', 19.34, 0, true, s ], |
[ "note", false, "read", 'However the reserved characters', 15.63, 0, true, s ], |
[ "normal", false, "replied", 'It is therefore necessary', 24.22, 5.50, true, s ], |
[ "important", false, "replied", 'To problems of corruption by', 9.12, -3, true, s ], |
[ "note", false, "replied", 'Which would simply be awkward in', 12.15, -4, false, s ] |
]; |
var rows = 100; |
for(var i=0, l=data.length; i<rows; i++){ |
data.push(data[i%l].slice(0)); |
} |
model = new dojox.grid.data.Table(null, data); |
// ========================================================================== |
// Tie some UI to the data model |
// ========================================================================== |
model.observer(this); |
modelChange = function(){ |
dojo.byId("rowCount").innerHTML = 'Row count: ' + model.count; |
} |
/* |
modelInsertion = modelDatumChange = function(a1, a2, a3){ |
console.debug(a1, a2, a3); |
} |
*/ |
// ========================================================================== |
// Custom formatters |
// ========================================================================== |
formatCurrency = function(inDatum){ |
return isNaN(inDatum) ? '...' : dojo.currency.format(inDatum, this.constraint); |
} |
formatDate = function(inDatum){ |
return dojo.date.locale.format(new Date(inDatum), this.constraint); |
} |
// ========================================================================== |
// Grid structure |
// ========================================================================== |
statusCell = { |
field: 2, name: 'Status', |
styles: 'text-align: center;', |
editor: dojox.grid.editors.Select, |
options: [ "new", "read", "replied" ] |
}; |
gridLayout = [{ |
type: 'dojox.GridRowView', width: '20px' |
},{ |
defaultCell: { width: 8, editor: dojox.grid.editors.Input, styles: 'text-align: right;' }, |
rows: [[ |
{ name: 'Id', |
get: function(inRowIndex) { return inRowIndex+1;}, |
editor: dojox.grid.editors.Dijit, |
editorClass: "dijit.form.NumberSpinner" }, |
{ name: 'Date', width: 10, field: 7, |
editor: dojox.grid.editors.DateTextBox, |
formatter: formatDate, |
constraint: {formatLength: 'long', selector: "date"}}, |
{ name: 'Priority', styles: 'text-align: center;', field: 0, |
editor: dojox.grid.editors.ComboBox, |
options: ["normal", "note", "important"], width: 10}, |
{ name: 'Mark', width: 3, styles: 'text-align: center;', |
editor: dojox.grid.editors.CheckBox}, |
statusCell, |
{ name: 'Message', styles: '', width: '100%', |
editor: dojox.grid.editors.Editor, editorToolbar: true }, |
{ name: 'Amount', formatter: formatCurrency, constraint: {currency: 'EUR'}, |
editor: dojox.grid.editors.Dijit, editorClass: "dijit.form.CurrencyTextBox" }, |
{ name: 'Amount', field: 4, formatter: formatCurrency, constraint: {currency: 'EUR'}, |
editor: dojox.grid.editors.Dijit, editorClass: "dijit.form.HorizontalSlider", width: 10} |
]] |
}]; |
// ========================================================================== |
// UI Action |
// ========================================================================== |
addRow = function(){ |
grid.addRow([ |
"normal", false, "new", |
'Now is the time for all good men to come to the aid of their party.', |
99.99, 9.99, false |
]); |
} |
</script> |
</head> |
<body> |
<h1>dojox.Grid Basic Editing test</h1> |
<br /> |
<div id="controls"> |
<button onclick="grid.refresh()">Refresh</button> |
<button onclick="grid.edit.focusEditor()">Focus Editor</button> |
<button onclick="grid.focus.next()">Next Focus</button> |
<button onclick="addRow()">Add Row</button> |
<button onclick="grid.removeSelectedRows()">Remove</button> |
<button onclick="grid.edit.apply()">Apply</button> |
<button onclick="grid.edit.cancel()">Cancel</button> |
<button onclick="grid.singleClickEdit = !grid.singleClickEdit">Toggle singleClickEdit</button> |
</div> |
<br /> |
<div id="grid" jsId="grid" dojoType="dojox.Grid" model="model" structure="gridLayout"></div> |
<br /> |
<div id="rowCount"></div> |
</body> |
</html> |