Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 1229 | Revision 1231 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1117 lars 1 
<?php
2 
 
3 
    namespace App\Http\Controllers;
4 
 
1226 lars 5 
    use Illuminate\Foundation\Http\FormRequest;
1227 lars 6 
    use Illuminate\Http\Request;
1176 lars 7 
    use Illuminate\Support\Facades\DB;
1193 lars 8 
    use Illuminate\View\View;
1176 lars 9 
 
1117 lars 10 
    class ToolboxController extends Controller
11 
    {
1188 lars 12 
        private string $xmlDir;
13 
 
1193 lars 14 
        public function create(): View
1117 lars 15 
        {
16 
            return view( "admin/toolbox/index" );
17 
        }
1122 lars 18 
 
1228 lars 19 
        public function updateShopVersion( Request $request ): void
1226 lars 20 
        {
21 
 
1227 lars 22 
            $version = $request->version;
23 
            $shop = $request->hop;
24 
            $verz = $request->verz;
1230 lars 25 
            $server = $request->serverName;
1226 lars 26 
            $srcDir = "/usr/share/php7/webanOS/" . $version;
27 
            //trigger_error( $srcDir );
28 
            $dstDir = "/var/www/vhosts/" . $shop . "/" . $verz;
29 
            $cmd1 = "sudo ln -sfn " . $srcDir . " " . $dstDir . "/source";
30 
            $cmd2 = "sudo ln -s " . $dstDir . "/source/*.php " . $dstDir;
31 
            $cmd3 = "sudo ln -s " . $dstDir . "/source/preisagentur/*.php " . $dstDir . "/preisagentur";
32 
 
33 
            if ( $_SERVER["HTTP_HOST"] == "faltradxxs.lars-tiefland.de" )
34 
            {
35 
                //if ( $site == $site_full )
36 
                {
37 
                    $dom = "webanos." . $server;
38 
                    $sql = "SELECT
39 
                            dok_domain
40 
                        FROM
41 
                            webs
42 
                        WHERE
43 
                            domain='" . $server . "'
44 
                    ";
45 
                    $res = $GLOBALS["localDB"]->query( $sql );
46 
                    if ( !$GLOBALS["localDB"]->error )
47 
                    {
48 
                        $row = $res->fetch_assoc();
49 
                        if ( $row["dok_domain"] )
50 
                        {
51 
                            $dom = $row["dok_domain"];
52 
                        }
53 
                    }
54 
                    $cmd1 = "ssh -p910 www-data@" . $dom . " " . $cmd1;
55 
                    $cmd2 = "ssh -p910 www-data@" . $dom . " " . $cmd2;
56 
                    $cmd3 = "ssh -p910 www-data@" . $dom . " " . $cmd3;
57 
                }
58 
            }
59 
            exec( $cmd1, $out1, $ret1 );
60 
            if ( $ret1 == 0 )
61 
            {
62 
                exec( $cmd2, $out2, $ret2 );
63 
                exec( $cmd3, $out3, $ret3 );
64 
                echo "Shop-Version wurde erfolgreich umgestellt!";
65 
 
66 
 
67 
                if ( $_SERVER["HTTP_HOST"] == "faltradxxs.lars-tiefland.de" )
68 
                {
69 
                    $path = array(
70 
                        "/var/www/vhosts/" . $shop . "/dev/cache/default",
71 
                        "/var/www/vhosts/" . $shop . "/dev/cache/asset_compile",
72 
                        "/var/www/vhosts/" . $shop . "/dev/templates_c/default",
73 
                        "/var/www/vhosts/" . $shop . "/dev/templates_c/module",
74 
                        "/var/www/vhosts/" . $shop . "/dev/templates_c/reiter",
75 
                    );
76 
 
77 
                    foreach ( $path as $p )
78 
                    {
79 
                        $files = glob( $p . '/*' );
80 
                        //print_r($files);
81 
                        if ( !$files )
82 
                        {
83 
                            continue;
84 
                        }
85 
                        foreach ( $files as $file )
86 
                        {
87 
                            if ( is_file( $file ) )
88 
                            {
89 
                                unlink( $file );
90 
                            }
91 
                        }
92 
                    }
93 
                }
94 
            }
95 
        }
96 
 
1227 lars 97 
        public function readSVNLog( Request $request ): void
98 
        {
99 
            $version = $request->version;
100 
            $xmlDir = "/tmp/" . env( 'shop' ) . "/webanos/svn/";
101 
            $version = $_GET["version"];
102 
            $version = str_replace( "tags/", "", $version );
103 
            $xmlFile = $xmlDir . $version . ".xml";
104 
            $logMessage = readSvnXmlFile( $xmlFile );
105 
            echo $logMessage;
106 
        }
107 
 
1193 lars 108 
        public function changeShopVersion(): View
1122 lars 109 
        {
1159 lars 110 
            $site = env( 'shop' );
1158 lars 111 
            $site_full = "";
112 
            $webs = array();
113 
            $servers = array();
114 
            set_time_limit( 0 );
1198 lars 115 
            $versions = $this->getVersions();
1158 lars 116 
 
1164 lars 117 
            \View::share( "versions", $versions );
1158 lars 118 
            unset( $out );
119 
 
1188 lars 120 
            $this->xmlDir = "/tmp/" . $site . "/webanos/svn/";
121 
            @mkdir( $this->xmlDir, 0755, true );
1158 lars 122 
 
123 
            $sshPorts = array();
124 
            $dokDomains = array();
1165 lars 125 
            $shops = array();
1175 lars 126 
            if ( $_SERVER["HTTP_HOST"] == "faltradxxs.lars-tiefland.de" )
1158 lars 127 
            {
128 
                $sql = "SELECT
129 
                        domain,
130 
                        dok_domain,
131 
                        ssh_port
132 
                    FROM
133 
                        webs w
134 
                    JOIN
1174 lars 135 
                        web_properties wp
1158 lars 136 
                    ON
1173 lars 137 
                        wp.web_id=w.id
1158 lars 138 
                    WHERE
1173 lars 139 
                        wp.property_id=804
1158 lars 140 
                    AND
141 
                        domain!='weban.de'
142 
                    ORDER BY
143 
                        domain
144 
                ";
1159 lars 145 
                $rows = DB::connection( 'cms' )->select( $sql );
146 
                foreach ( $rows as $row )
1158 lars 147 
                {
1177 lars 148 
                    $dokDomains[] = $row->dok_domain;
1178 lars 149 
                    $servers[] = $row->domain;
1226 lars 150 
                    $sshPorts[$row->domain] = $row->ssh_port;
1158 lars 151 
                }
152 
                foreach ( $servers as $i => $server )
153 
                {
154 
                    //trigger_error( $server );
155 
 
156 
                    unset( $out );
1226 lars 157 
                    $port = $sshPorts[$server];
1158 lars 158 
                    $dom = "webanos." . $server;
1226 lars 159 
                    if ( $dokDomains[$i] )
1158 lars 160 
                    {
1226 lars 161 
                        $dom = $dokDomains[$i];
1158 lars 162 
                    }
1169 lars 163 
                    if ( $port > 22 )
1158 lars 164 
                    {
165 
                        $dom .= " -p" . $port;
166 
                    }
167 
                    $cmd = "ssh www-data@" . $dom . " sudo find -L /var/www/vhosts/" . $server . " -maxdepth 3 -name source";
1170 lars 168 
                    /*if ( $site_full != $site )
1158 lars 169 
                    {
170 
                        $cmd = "find -L /var/www/vhosts/" . $server . " -maxdepth 3 -name source";
1170 lars 171 
                    }*/
1158 lars 172 
                    exec( $cmd, $out, $ret );
173 
                    if ( $ret )
174 
                    {
1179 lars 175 
                        continue;
176 
                        //trigger_error( $dom );
1158 lars 177 
                    }
178 
                    sort( $out );
179 
                    //trigger_error( var_export( $ret, true ) );
180 
                    foreach ( $out as $id => $line )
181 
                    {
182 
                        $ex = explode( "/", $line );
183 
                        $ex2 = $ex;
1226 lars 184 
                        unset( $ex2[count( $ex ) - 1] );
1158 lars 185 
                        $sLine = implode( "/", $ex2 );
1184 lars 186 
                        $cmd = "ssh www-data@" . $dom . " file --mime-type " . $sLine . "|grep symlink -v";
1158 lars 187 
                        if ( $site != $site_full )
188 
                        {
1180 lars 189 
                            //$cmd = "file --mime-type " . $sLine . "|grep symlink -v";
1158 lars 190 
                        }
191 
                        exec( $cmd, $out2, $ret2 );
192 
                        unset( $out2 );
193 
                        if ( $ret2 == 1 )
194 
                        {
195 
                            continue;
196 
                        }
197 
                        $name = $ex[4];
198 
                        $dir = $ex[5];
1186 lars 199 
                        $cmd2 = "ssh www-data@" . $dom . " readlink -n " . $line;
1158 lars 200 
                        if ( $site_full != $site )
201 
                        {
1185 lars 202 
                            //$cmd2 = "readlink -n " . $line;
1158 lars 203 
                        }
204 
                        exec( $cmd2, $out2, $ret2 );
205 
                        $link = $out2[0];
206 
                        $version = trim( $link, "/" );
207 
                        $ex = explode( "/", $version );
1186 lars 208 
                        //trigger_error( count( $ex ) );
209 
                        //trigger_error( $link );
1226 lars 210 
                        $shops[$name][$dir] = $this->getShopVer( $link, $ex, $server );
1158 lars 211 
                        unset( $out2 );
212 
                    }
213 
                }
214 
            }
215 
            else
216 
            {
217 
                $cmd = "sudo find -L /var/www/vhosts/" . $site . " -maxdepth 3 -name source";
218 
                exec( $cmd, $out, $ret );
219 
                sort( $out );
220 
                foreach ( $out as $id => $line )
221 
                {
222 
                    $ex = explode( "/", $line );
223 
                    $ex2 = $ex;
1226 lars 224 
                    unset( $ex2[count( $ex ) - 1] );
1158 lars 225 
                    $sLine = implode( "/", $ex2 );
226 
                    if ( @is_link( $sLine ) && $site == $site_full )
227 
                    {
228 
                        continue;
229 
                    }
230 
                    $name = $ex[4];
231 
                    $dir = $ex[5];
232 
                    exec( "readlink " . $line, $ret );
233 
                    $link = $ret[0];
234 
                    unset( $ret );
235 
                    $version = trim( $link, "/" );
236 
                    $ex = explode( "/", $version );
1226 lars 237 
                    $shops[$name][$dir] = $this->getShopVer( $link, $ex );
1158 lars 238 
                }
239 
            }
240 
            ksort( $shops );
1159 lars 241 
            \View::share( "shops", $shops );
242 
            \View::share( "file", "common/changeShopVersion.tpl" );
1158 lars 243 
 
1161 lars 244 
            return view( "admin/toolbox/changeShopVersion" );
1122 lars 245 
        }
1158 lars 246 
 
1193 lars 247 
        private function getVersions(): array
1158 lars 248 
        {
1195 lars 249 
            $site = env( 'shop' );
1158 lars 250 
            $versions = array();
1193 lars 251 
            $path = "/usr/share/php7/webanOS/";
1158 lars 252 
            $cmd = "ls " . $path . "tags/";
253 
            exec( $cmd, $out, $ret );
1188 lars 254 
            $this->xmlDir = "/tmp/" . $site . "/webanos/svn/";
255 
            @mkdir( $this->xmlDir, 0755, true );
1158 lars 256 
            foreach ( $out as $version )
257 
            {
258 
                list( $datum, $zeit ) = explode( "_", $version );
259 
                if ( strlen( $zeit ) == 2 )
260 
                {
261 
                    list( $datum, $zeit ) = explode( "-", $version );
262 
                    $datum = str_replace( "_", "-", $datum );
263 
                    $zeit = str_replace( "_", ":", $zeit );
264 
                }
265 
                else
266 
                {
267 
                    $zeit = str_replace( "-", ":", $zeit );
268 
                }
269 
                $datStr = $datum . " " . $zeit;
270 
                $name = strftime( "%x %H:%M", strtotime( $datStr ) );
1226 lars 271 
                $versions["tags/" . $version] = $name;
1198 lars 272 
                $xmlFile = $this->xmlDir . $version . ".xml";
1158 lars 273 
                if ( !file_exists( $xmlFile ) )
274 
                {
275 
                    $cmd = "svn log --xml --stop-on-copy " . $path . "tags/" . $version . " > " . $xmlFile;
276 
                    exec( $cmd, $svnOut, $ret );
277 
                    unset( $svnOut );
278 
                }
279 
            }
1198 lars 280 
            $versions["trunk"] = "trunk";
281 
            $xmlFile = $this->xmlDir . "trunk.xml";
1158 lars 282 
            $cmd = "svn log --xml " . $path . "/trunk/ -rCOMMITTED > " . $xmlFile;
283 
            exec( $cmd, $svnOut, $ret );
284 
            unset( $svnOut );
285 
            return $versions;
286 
        }
287 
 
288 
        private function getShopVer( $link, $ex, $server = "localhost" ): array
289 
        {
1226 lars 290 
            if ( $ex[count( $ex ) - 1] == "trunk" )
1158 lars 291 
            {
1198 lars 292 
                $version = "trunk";
293 
                $xmlFile = $this->xmlDir . "trunk.xml";
1158 lars 294 
            }
295 
            else
296 
            {
1198 lars 297 
                $version = $ex[4] . "/" . $ex[5];
298 
                $xmlFile = $this->xmlDir . $ex[5] . ".xml";
1158 lars 299 
            }
1187 lars 300 
            $logMessage = $this->readSvnXmlFile( $xmlFile );
1158 lars 301 
            return array(
302 
                "version"    => $version,
303 
                "server"     => $server,
304 
                "logmessage" => $logMessage,
305 
            );
306 
        }
307 
 
1187 lars 308 
        private function readSvnXmlFile( $xmlFile ): string
309 
        {
1189 lars 310 
            $logMessage = "";
311 
            if ( file_exists( $xmlFile ) )
1187 lars 312 
            {
1189 lars 313 
                $cfg = json_decode( json_encode( simplexml_load_file( $xmlFile ) ), true );
314 
                $logMessage = $cfg["logentry"]["msg"];
1187 lars 315 
            }
316 
            return nl2br( $logMessage );
317 
        }
318 
 
319 
 
1117 lars 320 
    }