docs/datatools.php

   1 <?php
   2
   3 // can load/export all of our common data bits
   4 // SVN $Id$
   5
   6 chdir('./../');
   7 require_once('./includes/init.php');
   8
   9 // ###################################################################
  10 // list of things to export/import: array(displayname => array('table' => db table, 'rebuild' => rebuild function)
  11
  12 $THELIST = array(
  13         'usergroups' => array(
  14                 'table' => 'usergroup',
  15                 'rebuild' => 'build_usergroups'
  16         ),
  17
  18         'statuses' => array(
  19                 'table' => 'status',
  20                 'rebuild' => 'build_statuses'
  21         ),
  22
  23         'severity' => array(
  24                 'table' => 'severity',
  25                 'rebuild' => 'build_severities'
  26         ),
  27
  28         'priorities' => array(
  29                 'table' => 'priority',
  30                 'rebuild' => 'build_priorities'
  31         ),
  32
  33         'resolutions' => array(
  34                 'table' => 'resolution',
  35                 'rebuild' => 'build_resolutions'
  36         )
  37 );
  38
  39 ?>
  40
  41 <h2>Data Tools</h2>
  42
  43 Here you can either export or import the standard data tables for Bugdar. These include things such as usergroups, priorities, etc.
  44
  45 <h3>[<strong><a href="datatools.php?do=export">Export</a></strong>] [<strong><a href="datatools.php?do=import">Import</a></strong>] [<strong><a href="datatools.php?do=view">View</a></strong>]</h3>
  46
  47 <hr />
  48
  49 <pre>
  50
  51 <?php
  52
  53 // ###################################################################
  54
  55 if ($_REQUEST['do'] == 'export')
  56 {
  57         foreach ($THELIST AS $display => $data)
  58         {
  59                 $fetch = $db->query("SELECT * FROM " . TABLE_PREFIX . "$data[table] ORDER BY {$data[table]}id ASC");
  60                 while ($fitem = $db->fetch_array($fetch))
  61                 {
  62                         $exportlist["$display"][] = $fitem;
  63                 }
  64                 $db->free_result($fetch);
  65
  66                 echo "Exported $display\n";
  67         }
  68
  69         $phpfile = '<?' . 'php
  70
  71 // stores exported data data
  72 // SVN $' . 'Id: $
  73
  74 $DATASTORE = "' . addslashes(serialize($exportlist)) . '";
  75
  76 ?' . '>';
  77
  78         if ($handle = fopen('./docs/datatools_store.php', 'w'))
  79         {
  80                 if (fwrite($handle, $phpfile))
  81                 {
  82                         fclose($handle);
  83                 }
  84                 else
  85                 {
  86                         echo 'Could not write the file';
  87                         exit;
  88                 }
  89         }
  90         else
  91         {
  92                 echo 'Could not open the file with mode "w"';
  93                 exit;
  94         }
  95
  96         echo "Wrote the file\n";
  97 }
  98
  99 // ###################################################################
 100
 101 if ($_REQUEST['do'] == 'import')
 102 {
 103         require('./docs/datatools_store.php');
 104         $DATASTORE = unserialize(stripslashes($DATASTORE));
 105
 106         foreach ($THELIST AS $display => $data)
 107         {
 108                 $db->query("TRUNCATE TABLE " . TABLE_PREFIX . "$data[table]");
 109
 110                 $fields = array();
 111                 $values = array();
 112                 foreach ($DATASTORE["$display"] AS $mainarray)
 113                 {
 114                         $fields = $values = array();
 115                         foreach ($mainarray AS $field => $value)
 116                         {
 117                                 $fields[] = $field;
 118                                 $values[] = "'" . $bugsys->escape($value) . "'";
 119                         }
 120                         $query = "INSERT INTO " . TABLE_PREFIX . "$data[table] (" . implode(', ', $fields) . ") VALUES (" . implode(', ', $values) . ")";
 121                         echo str_replace(array('>', '<'), array('&gt;', '&lt;'), $query) . "\n";
 122                         $db->query($query);
 123                 }
 124
 125                 $data['rebuild']();
 126                 echo "Rebuilding $data[table]\n\n";
 127         }
 128 }
 129
 130 // ###################################################################
 131
 132 if ($_REQUEST['do'] == 'view')
 133 {
 134         require_once('./docs/datatools_store.php');
 135         $DATASTORE = unserialize(stripslashes($DATASTORE));
 136
 137         $build = '$data = array(';
 138
 139         foreach ($THELIST AS $display => $data)
 140         {
 141                 $build .= "\n\t'$data[table]' => array(";
 142                 foreach ($DATASTORE["$display"] AS $mainarray)
 143                 {
 144                         $build .= "\n\t\tarray(";
 145                         foreach ($mainarray AS $field => $value)
 146                         {
 147                                 $build .= "\n\t\t\t'" . addslashes($field) . "' => '" . addslashes($value) . "',";
 148                         }
 149                         $build = substr($build, 0, strlen($build) - 1);
 150                         $build .= "\n\t\t),";
 151                 }
 152                 $build = substr($build, 0, strlen($build) - 1);
 153                 $build .= "\n\t),";
 154         }
 155         $build = substr($build, 0, strlen($build) - 1);
 156
 157         $build .= "\n);";
 158
 159         echo '<textarea style="height: 500px; width: 100%">' . htmlspecialchars($build) . '</textarea>';
 160 }
 161
 162 ?>