Fix #6494 - translations code for reports

[Pman.Admin] / Import / Core_templatestr.php

diff --git a/Import/Core_templatestr.php b/Import/Core_templatestr.php
new file mode 100644 (file)
index 0000000..9f9e773
--- /dev/null
+++ b/Import/Core_templatestr.php
@@ -0,0 +1,193 @@
+<?php
+
+/**
+ * generic import routine..
+ *
+ * - upload a file..
+ *
+ * - preview the result. / edit?
+ *
+ * - import..
+ * 
+ *
+ */
+
+
+require_once 'Pman.php';
+class Pman_Admin_Import_Core_templatestr extends Pman
+{
+    var $cli  = false;
+     
+     
+     
+    function getAuth()
+    {
+        $cli = HTML_FlexyFramework::get()->cli;
+        if ($cli) {
+            $this->cli = true;
+            return true;
+        }
+        parent::getAuth();
+        $au = $this->getAuthUser();
+        if (!$au) {
+            $this->jerrAuth();
+        }
+        return true;
+    }
+    
+    function post($base = '' )
+    {
+        
+           // should handle uploaded file..
+        if (empty($_FILES['imageUpload']['tmp_name']) || 
+            empty($_FILES['imageUpload']['name']) || 
+            empty($_FILES['imageUpload']['type'])
+        ) {
+            $this->jerr ("Missing file details");
+            exit;
+        }
+        
+        PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError'));
+    
+          
+        $this->transObj = DB_DataObject::factory('core_enum');
+        
+        $this->transObj->query('BEGIN');
+        
+        // first convert the file to a readable format..
+        //$rows = $this->readXLS("/home/alan/Downloads/oll_example.xls") ;
+        $rows = $this->readXLS($_FILES['imageUpload']['tmp_name']) ;
+        
+         //$ret = $this->processRows($rows);
+        
+         
+        $this->jok("DONE", false, array('extra'=> $rows));
+        
+    }
+    
+    /*
+    function get($base = '',  $opts = array())
+    {
+        $rows = $this->readXLS("/var/lib/php/sessions/pressrelease-translations.xls") ;
+        
+       
+        
+        $ret = $this->processRows($rows);
+         
+        $this->jdata($ret);
+        exit;
+        
+    }
+    */
+    function processRows($rows)
+    { 
+        $ret = array();
+        foreach($rows as $r) {
+            $ret[] = $this->updateTranslation($r);
+            
+        }
+        return $ret;
+    }        
+    
+    
+    var $seq = 1;
+    function updateTranslation($r)
+    {
+        //print_R($r); DB_DataObject::DebugLevel(1);
+        $tr = DB_DataObject::Factory('core_templatestr');
+        $tr->autoJoin();
+
+       
+        $tr->whereAdd("join_template_id_id.template='{$tr->escape($r['template'])}'");
+        $tr->whereAdd("join_template_id_id.view_name='{$tr->escape($r['module'])}'");
+        $tr->whereAdd("join_src_id_id.mdsum='{$tr->escape($r['code'])}'");
+        $tr->lang = $r['language'];
+        if ($tr->find(true)) {
+            $tt = DB_DataObject::Factory('core_templatestr');
+            $tt->get($tr->id);
+            $tr= clone($tt);
+            $tt->txt = $r['translation'];
+            $tt->updated = date('Y-m-d H:i:s');
+            $tt->update($tr);
+             
+            return 1;
+        }
+        return 0;
+    }
+    
+    
+    function readXLS($file) {
+        
+        require_once 'System.php';
+        $ssconvert = System::which('ssconvert');
+        if (!$ssconvert) die("ssconvert not installed");
+        $csv = $this->tempName('csv');
+        $cmd = "$ssconvert  -T Gnumeric_stf:stf_csv ". escapeshellarg($file) . ' '.$csv;
+        
+         $data= `$cmd`;
+        
+        clearstatcache();
+         if (!file_exists($csv)) {
+            $this->jerr("Failed to make file . \n".
+                        $cmd . "\n" .
+                        $data
+                        );
+            
+            
+        }
+         //echo $data;
+        $fh = fopen($csv, 'r');
+        if (!$fh) {
+            $this->jerr("file invalid");
+        }
+        $rows = array();
+        $head = false;
+        $blank = 0;
+        while (false !== ($row = fgetcsv($fh))) {
+             
+            if ($head === false) {
+                
+                $h = $row;
+                // skip header lines.
+                array_shift($h);
+                if (!strlen(implode('', $h))) {
+                    continue;
+                }
+                // how many empty rows..
+                if (count(explode(',',(rtrim(implode(',', $h), " ,")))) < 3) {
+                    continue;
+                }
+                
+                $head = array();
+                foreach($row as $i=>$c) {
+                   $c = preg_replace('/[\t \n]+/', ' ', $c);
+                   $head[$i] = strtolower(trim($c));
+                }
+                continue;
+            }
+            
+            if (!strlen(trim(implode('', $h)))) {
+                $blank++;
+                if ($blank > 3) { 
+                    break;
+                }
+                continue;
+            }
+            
+            $blank = 0;
+            $rrow = array();
+            foreach($row as $i=>$c) {
+                $c = preg_replace('/[\t \n]+/', ' ', $c);
+                $rrow[$head[$i]] = trim($c);
+            }
+           // var_dump($row);
+          //  print_r($max);
+            $rows[] = $rrow;
+        }
+        unlink($csv);
+        return $rows;
+        
+        
+    }
+    
+}
\ No newline at end of file