function activewidgets_grid($name, &$data) { $row_count = @mysql_num_rows($data); $column_count = @mysql_num_fields($data); $columns = "var " . $name . "_columns = [\n"; for ($i = 0; $i < $column_count; $i++) { $columns .= "\"" . @mysql_field_name($data, $i) . "\", "; } $columns .= "\n];\n"; $rows = "var " . $name . "_data = [\n"; while ($result = @mysql_fetch_array($data)) { $rows .= "["; for ($i = 0; $i < $column_count; $i++) { $rows .= "\"" . activewidgets_html($result[$i]) . "\", "; } $rows .= "],\n"; } $rows .= "];\n"; $html = "<" . "script" . ">\n"; $html .= $columns; $html .= $rows; $html .= "try {\n"; $html .= " var {$name} = new Active.Controls.Grid;\n"; $html .= " {$name}.setRowCount({$row_count});\n"; $html .= " {$name}.setColumnCount({$column_count});\n"; $html .= " {$name}.setDataText(function(i, j){return " . $name . "_data[i][j]});\n"; $html .= " {$name}.setColumnText(function(i){return " . $name . "_columns[i]});\n"; $html .= " document.write({$name});\n"; $html .= "}\n"; $html .= "catch (error){\n"; $html .= " document.write(error.description);\n"; $html .= "}\n"; $html .= "</" . "script" . ">\n"; return $html; }
function listuser_grid($name, $column_name, $data, $filename, $sid) { $row_count = count($data); $column_count = count($column_name); $columns = "var " . $name . "_columns = [\n"; foreach ($column_name as $value) { $columns .= "\"" . $value . "\", "; } $columns .= "\n];\n"; $rows = "var " . $name . "_data = [\n"; for ($k = 0; $k < $row_count; $k++) { for ($j = 0; $j < $column_count; $j++) { if ($j == 0) { $data[$k][$j] = "<a style='cursor:hand font-size: 10px; text-decoration: none; color: #800000' href='Modules.php?modname=" . $filename . "&" . $sid . "=" . $data[$k][$j + 2] . "'><b>" . $data[$k][$j] . "</b></a>"; } } } for ($k = 0; $k < $row_count; $k++) { $rows .= "["; for ($j = 0; $j < $column_count; $j++) { if ($j == 0) { $rows .= "\"" . $data[$k][$j] . "\", "; } else { $rows .= "\"" . activewidgets_html($data[$k][$j]) . "\", "; } } $rows .= "],\n"; } $rows .= "];\n"; $html = "<style>\r\n\t\t.active-controls-grid {height: 100%; font: menu;}\r\n\t\t//.active-grid-row{background: #ffffff;}\r\n\t\t\r\n\t\t//.active-column-0 {width: 400px; background-color: #E3F1F9;}\r\n\t\t.active-column-0 {width: 400px; }\r\n\t\t.active-column-3 {width: 188px;}\r\n\t\t\r\n\t\t.active-grid-column {border-right: 1px solid threedlightshadow;}\r\n\t\t.active-grid-row {border-bottom: 1px solid threedlightshadow;}\r\n\t\t\r\n\r\n\t\t//row heighlighting\r\n\t\t.active-row-highlight {background-color: #f6f6ef}\r\n \t.active-row-highlight .active-row-cell {background-color: #f6f6ef}\r\n\r\n\t\t\r\n\t\t//column header background\r\n\t\t.active-scroll-left .active-box-item {\r\n background: green;\r\n \t}\r\n\r\n \t/* column header background */\r\n \t.active-scroll-top .active-box-item {\r\n background-image:url('images/column_header.jpg');\r\n font-weight: bold;\r\n\r\n }\r\n\r\n\t\t.active-scroll-left, .active-scroll-corner {display: none} \r\n \t.active-scroll-top, .active-scroll-data {padding-left: 0px}\r\n \t\r\n \t\r\n \t.active-scroll-data .active-column-3 {\r\n border-right: 0px double #cccccc;\r\n\t }\r\n\t\t\r\n\t\t.active-scroll-top .active-column-3 {\r\n\t border-right: 0px double #cccccc;\r\n\t\t}\r\n\r\n\r\n\r\n\r\n\t\t\r\n\r\n\r\n\r\n\r\n\t</style>\r\n"; $html .= "<" . "script" . ">\n"; $html .= $columns; $html .= $rows; $html .= "try {\n"; $html .= " var {$name} = new Active.Controls.Grid;\n"; //For Paging $html .= " \n " . $name . ".setModel(\"row\", new Active.Rows.Page); \n"; $html .= " {$name}.setProperty(\"row/count\",{$row_count});\n"; $html .= " {$name}.setProperty(\"column/count\",{$column_count});\n"; $html .= " {$name}.setProperty(\"data/text\",function(i, j){return " . $name . "_data[i][j]});\n"; $html .= " {$name}.setColumnText(function(i){return " . $name . "_columns[i]});\n"; //For Alternate row $html .= " \t\n var alternate = function(){"; $html .= " \n return this.getRowProperty('order') % 2 ? '#efefef' : '#ffffff';"; $html .= " \n }"; $html .= " \n var row = new Active.Templates.Row;"; $html .= " \n row.setStyle('background', alternate);"; $html .= " \n obj.setTemplate('row', row);"; //For Row hilighting $html .= " \n row.setEvent('onmouseover', \"mouseover(this, 'active-row-highlight')\");"; $html .= " \n row.setEvent('onmouseout', \"mouseout(this, 'active-row-highlight')\");"; $html .= " \n obj.setTemplate('row', row);"; //For Column-Header Height $html .= " \n obj.setColumnHeaderHeight(24);"; //For Paging $html .= " \n obj.setProperty(\"row/pageSize\", 50);"; $html .= " document.write({$name});\n"; $html .= "}\n"; $html .= "catch (error){\n"; $html .= " document.write(error.description);\n"; $html .= "}\n"; $html .= "</" . "script" . ">\n"; $html .= "\t<script>\r\n\tfunction goToPage(delta){\r\n\t\tvar count = obj.getProperty(\"row/pageCount\");\r\n\t\tvar number = obj.getProperty(\"row/pageNumber\");\r\n\t\tnumber += delta;\r\n\t\tif (number < 0) {number = 0}\r\n\t\tif (number > count-1) {number = count-1}\r\n\t\tdocument.getElementById('pageLabel').innerHTML = \"Page \" + (number + 1) + \" of \" + count + \" (Total No of Records: " . $row_count . ") \";\r\n\r\n\t\tobj.setProperty(\"row/pageNumber\", number);\r\n\t\tobj.refresh();\r\n\t}\r\n\r\n\tgoToPage(0);\r\n\t</script>"; return $html; }