{"id":1513,"date":"2017-10-18T22:08:07","date_gmt":"2017-10-18T22:08:07","guid":{"rendered":"http:\/\/www.honobono-life.info\/wpeng\/?p=1513"},"modified":"2017-10-18T22:08:07","modified_gmt":"2017-10-18T22:08:07","slug":"angularjs-ui-grid-filter-pagination-grid-data","status":"publish","type":"post","link":"http:\/\/www.honobono-life.info\/wpeng\/angularjs-ui-grid-filter-pagination-grid-data\/","title":{"rendered":"AngularJS ui-grid filter pagination grid data"},"content":{"rendered":"<ul>\r\n<li>AngularJS : 1.6.5<\/li>\r\n<li>ui-grid : 4.0.6<\/li>\r\n<li>include file<\/li>\r\nui-grid.min.css,angular.min.js,ui-grid.min.js\r\n<\/ul>\r\n<!--more-->\r\n<link href=\"http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/css\/ui-grid-4.0.6.min.css\" rel=\"stylesheet\">\r\n<link href=\"http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/css\/grid-4.0.6.css\" rel=\"stylesheet\"><script type='text\/javascript' src='http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/js\/angular-1.6.5.min.js'><\/script><script type='text\/javascript' src='http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/js\/ui-grid-4.0.6.min.js'><\/script>\r\n<script type='text\/javascript' src='http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/js\/ui-filter.js'><\/script>\r\n<div ng-app=\"googleMapApp\" role=\"tabpanel\">\r\n  <ul class=\"nav nav-tabs\">\r\n    <li class=\"active\"><a href=\"#demo1\" data-toggle=\"tab\">demo<\/a><\/li>\r\n    <li><a href=\"#html1\" data-toggle=\"tab\">markup<\/a><\/li>\r\n    <li><a href=\"#script1\" data-toggle=\"tab\">script<\/a><\/li>\r\n    <li><a href=\"#php1\" data-toggle=\"tab\">Server PHP<\/a><\/li>\r\n  <\/ul>\r\n  <div class=\"tab-content\">\r\n    <div class=\"tab-pane active\" id=\"demo1\">\r\n\r\n<div ng-controller=\"MyCtrl\">\r\n  <div class=\"myGrid\" ui-grid=\"gridOptions\" ui-grid-pagination><\/div>\r\n<\/div>\r\n\r\n    <\/div>\r\n    <div class=\"tab-pane\" id=\"html1\">\r\n<pre>\r\n&lt;link href=\"http:\/\/www.example.com\/wp\/wp-content\/themes\/ang\/css\/ui-grid.min.css\" rel=\"stylesheet\">\r\n&lt;link href=\"http:\/\/www.example.com\/wp\/wp-content\/themes\/ang\/css\/grid.css\" rel=\"stylesheet\">\r\n&lt;script type='text\/javascript' src='http:\/\/www.example.com\/wp\/wp-content\/themes\/ang\/js\/ui-grid.min.js'>&lt;\/script>\r\n&lt;script type='text\/javascript' src='http:\/\/www.example.com\/wp\/wp-content\/themes\/ang\/js\/grid.js'>&lt;\/script>\r\n&lt;div ng-controller=\"MyCtrl\">\r\n  &lt;div class=\"myGrid\" ui-grid=\"gridOptions\" ui-grid-pagination>&lt;\/div>\r\n&lt;\/div>\r\n<\/pre>\r\n    <\/div>\r\n\r\n    <div class=\"tab-pane\" id=\"script1\">\r\n\r\n<div ng-non-bindable><pre>\r\nvar myApp = angular.module('MyApp', ['ui.grid', 'ui.grid.pagination']);\r\n\r\nmyApp.controller('MyCtrl', ['$scope', '$http', 'uiGridConstants', function ($scope, $http, uiGridConstants) {\r\n    $scope.filterOptions = {\r\n      filterText: \"\",\r\n      useExternalFilter: true\r\n    };\r\n    $scope.gridOptions = {\r\n      enableFiltering: true,\r\n      enablePaging: true,\r\n      showFooter: true,\r\n      paginationCurrentPage : 1,\r\n      paginationPageSizes: [3, 5, 8],\r\n      paginationPageSize: 3,\r\n      filterOptions: $scope.filterOptions,\r\n      columnDefs: [\r\n        {field: 'id', enableFiltering: false, width: '10%'},\r\n        {field: 'name'},\r\n        {field: 'group',\r\n         filter: {\r\n           type: uiGridConstants.filter.SELECT,\r\n           selectOptions: [ { value: 'grp-A', label: 'grp-A' },\r\n                            { value: 'grp-B', label: 'grp-B' },\r\n                            { value: 'grp-C', label: 'grp-C' },\r\n                            { value: 'grp-D', label: 'grp-D' }]}\r\n        },\r\n        {field: 'date', enableFiltering: false,},\r\n        {field: 'count',\r\n         filters: [\r\n          {condition: uiGridConstants.filter.GREATER_THAN,\r\n           placeholder: 'greater than'},\r\n          {condition: uiGridConstants.filter.LESS_THAN,\r\n           placeholder: 'less than'}\r\n         ],\r\n        }\r\n      ]\r\n    };\r\n    $http.get('..\/wp-content\/themes\/wp\/json-grid.php')\r\n      .then(function onSuccess(response) {\r\n        $scope.gridOptions.data = response.data;\r\n      });\r\n}]);\r\n\r\n(grid.css)\r\n.myGrid {\r\n  height: 300px;\r\n}\r\n<\/pre><\/div>\r\n    <\/div><!-- \/.tab-pane -->\r\n\r\n    <div class=\"tab-pane\" id=\"php1\">\r\n<pre>\r\n&lt;?php\r\nrequire(\"dbinfo.php\");\r\n$dsn = 'mysql:host=localhost;dbname='.$database.';charset=utf8';\r\ntry {\r\n  $dbh = new PDO($dsn, $username, $password,array(PDO::ATTR_EMULATE_PREPARES => false,PDO::MYSQL_ATTR_INIT_COMMAND => \"SET CHARACTER SET `utf8`\"));\r\n} catch (PDOException $e) {\r\n  exit('DB connect error'.$e->getMessage());\r\n}\r\n$st = $dbh->query(\"SELECT * FROM grid_products WHERE 1\");\r\necho json_encode($st->fetchAll(PDO::FETCH_ASSOC));\r\n\r\n?>\r\n<\/pre>\r\n    <\/div><!-- \/.tab-pane -->\r\n\r\n  <\/div><!-- \/.tab-content -->\r\n<\/div><!-- \/.tabpanel -->\r\n","protected":false},"excerpt":{"rendered":"<p>AngularJS : 1.6.5 ui-grid : 4.0.6 include file ui-grid.min.css,angular.min.js,ui-grid.min.js<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/posts\/1513"}],"collection":[{"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/comments?post=1513"}],"version-history":[{"count":1,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/posts\/1513\/revisions"}],"predecessor-version":[{"id":1514,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/posts\/1513\/revisions\/1514"}],"wp:attachment":[{"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/media?parent=1513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/categories?post=1513"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/tags?post=1513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}