MSOfficeExcel.php 3.49 KB
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<?php
/*
 * Copyright (C) 2015 Maarch
 *
 * This file is part of dependency fileSystem.
 *
 * Dependency fileSystem is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Dependency fileSystem is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with dependency fileSystem.  If not, see <http://www.gnu.org/licenses/>.
 */

namespace dependency\fileSystem\plugins;

/**
 * Class for Microsoft Excel conversion functions
 *
 * @package Dependency/fileSystem
 * @author  Arnaud PAUGET <arnaud.pauget@maarch.org>
 */
class MSOfficeExcel implements \dependency\fileSystem\conversionInterface
{
    protected $MSOconvertExecutable;

    public function __construct($MSOconvertExecutable)
    {
        $this->MSOconvertExecutable = $MSOconvertExecutable;
    }

    public function convert($srcfile, $options = null)
    {
        $outputFile = dirname($srcfile) . DIRECTORY_SEPARATOR . pathinfo($srcfile, PATHINFO_FILENAME) . "." . $options["extension"];

        $tokens = array('powershell.exe -command ". \'"' . $this->MSOconvertExecutable . '"\'; ');
        $tokens[] = "convertFileToPdf";
        $tokens[] = "'".str_replace("'", "''", $srcfile)."'";
        $tokens[] = "'".str_replace("'", "''", $outputFile)."'";
        $tokens[] = 'excel >> c:/temp/testExcel.log"';

        $command = implode(' ', $tokens);

        $output = array();
        $return = null;
        $this->errors = array();

        exec($command, $return, $output);
        
        $convertedfile = dirname($srcfile) . DIRECTORY_SEPARATOR . pathinfo($srcfile, PATHINFO_FILENAME) . "." . $options["extension"];

        if (file_exists($convertedfile)) {
            return $convertedfile;
        }

        throw new \dependency\fileSystem\Exception("error during conversion $command", $return, null, $output);
    }

    public function getSoftwareName()
    {
        return "Microsoft Excel";
    }

    public function getSoftwareVersion()
    {
        if (DIRECTORY_SEPARATOR == "/") {
            $tokens = array('"'.$this->libreOfficeExecutable.'"');
            $tokens[] = "--version";

            $command = implode(' ', $tokens);

            $output = array();
            $return = null;
            $this->errors = array();

            exec($command, $output, $return);

            if ($return === 0) {
                return explode('', $output[0])[1];
            } else {
                throw new \dependency\fileSystem\Exception("error during the recuperation of the software version", $return, null, $output);
            }

        } else {
            return "4.4.2.0";
            /*$command = 'wmic datafile where Name="'.$this->libreOfficeExecutable.'" get Version';

            $output = array();
            $return = null;
            $this->errors = array();

            exec($command, $output, $return);
            
            if (is_array($output)) {
                return $output[1];
            } else {
                throw new \dependency\fileSystem\Exception("error during the recuperation of the software version", $return, null, $output);
            }*/
        }

        
    }
}