how make link in table colum

32 views
Skip to first unread message

Ashish Jha

unread,
Feb 15, 2018, 1:31:03 AM2/15/18
to Google Visualization API
<script type="text/javascript">
        google.charts.load('current', {'packages':['table']});
        google.charts.setOnLoadCallback(drawTable);
        var query, options, container;
        sendAndDraw();
        function drawTable() {
        drawToolbar();

          query = new google.visualization.Query(datasource);
          data = document.getElementById("table");
           options = {'pageSize': 10};
          var data = new google.visualization.DataTable();
          var data = google.visualization.arrayToDataTable([
                ['Ticket#','age','Created','Type','Subject','Queue','First Response Time','Solution Time','Sla','Priority','State','Owner'],
                <?php
                  while($row = pg_fetch_assoc($result)){
                    echo "['".$row["ticket_number"]."','".$row["age"]."','".$row["create_time"]."','".$row["ticket_type"]."', '".$row["subject"]."', '".$row["queue_name"]."', '".$row["response_time"]."', '".$row["solution_time"]."', '".$row["sla"]."','".$row["ticket_priority"]."','".$row["ticket_state"]."','".$row["ticket_agent"]."'],";
                  } 
 
                ?>
                ]);

          var table = new google.visualization.Table(document.getElementById('table_div'));

          table.draw(data, {page: 'enable',pageSize:'10', width: '100%'});

          google.visualization.events.addListener(table, 'select', function() {
          var row = table.getSelection()[0].row;
          alert('You selected ' + data.getValue(row, 0));
          });

          /********** function for refresh the page**************/
            setTimeout(function(){
               window.location.reload(1);
            }, 30000);
        }

        /********** function for refresh the page end**************/
        function sendAndDraw() {
          query.abort();
          var tableQueryWrapper = new TableQueryWrapper(query, container, options);
          tableQueryWrapper.sendAndDraw();
        }

        function setOption(prop, value) {
          options[prop] = value;
          sendAndDraw();
        }

      /**********************function for export csv******************/
      function drawToolbar() {
        var components = [
        ];

        var table_div = document.getElementById('toolbar_div');
        google.visualization.drawToolbar(table_div, components);
      };

          /***************function for export csv end*************/
    </script>
Reply all
Reply to author
Forward
0 new messages