<?php

use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;
class PHPSpreadSheetHelper
{
    private $filename;
    private $skipFirst;

    public function getTableData($filename, $skipFirst = true)
    {
        //$inputFileName = './tables/'.$filename;
        $inputFileName = $filename;
        $inputFileType = IOFactory::identify($inputFileName);
        $reader = IOFactory::createReader($inputFileType);
        $spreadsheet = $reader->load($inputFileName);

        $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);

        $data = [];
        $i = 2;
        if($skipFirst) {
            unset($sheetData[1]);
        }
        foreach ($sheetData as $k => $v){
            $id = $sheetData[$k]['A'];
            $text = $sheetData[$k]['B'];
            $media = $sheetData[$k]['C'];
            $status = $sheetData[$k]['N'];
            if($status != 'DONE'){

            if(strpos($media, ',')){
                $uploads = explode(',',$media);
                $media = [];
                foreach($uploads as $upload){
                    var_dump($upload);
                    $url = parse_url($upload, PHP_URL_PATH);
                    $urlArr = explode('/', $url);
                    $name = $urlArr[count($urlArr)-1];
                    $video = __DIR__.'../tmp/'.$name;
                    var_dump(file_put_contents(__DIR__.'/tmp/'.$name, file_get_contents($upload)));
                    $mime = mime_content_type(__DIR__.'/tmp/'.$name);
                    var_dump($mime);
                    if(strstr($mime, "video/")){
                        $datas = array('file' => __DIR__.'/tmp/'.$name, 'type' => 'video');
                    }else if(strstr($mime, "image/")){
                        $datas = array('file' => __DIR__.'/tmp/'.$name, 'type' => 'photo');
                    }

                    $media[] = $datas;

                }
                return $media;
            }else{
                $url = parse_url($media, PHP_URL_PATH);
                $urlArr = explode('/', $url);
                $name = $urlArr[count($urlArr)-1];
                $img = __DIR__.'../tmp/'.$name;
                var_dump(file_put_contents(__DIR__.'/tmp/'.$name, file_get_contents($media)));

                $datas = array('name' => $name ,'type' => 'single', 'text' => $text);
                $mime = mime_content_type(__DIR__.'/tmp/'.$name);
                if(strstr($mime, "video/")){
                    $datas['mimeType'] = "video";
                }else if(strstr($mime, "image/")){
                    $datas['mimeType'] = "image";
                }
                $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load("test.xlsx");

                //change it
                $sheet = $spreadsheet->getActiveSheet();
                $sheet->setCellValue('N'.$i, 'DONE');

                //write it again to Filesystem with the same name (=replace)
                $writer = new Xlsx($spreadsheet);
                $writer->save("test.xlsx");
                return $datas;

            }

            // Save image
            //var_dump(file_put_contents(__DIR__.'../../tmp/'.$name, file_get_contents($media)));
            }
            $i++;
        }
        return $data;
    }

}