Category Archives: Web Tools

Tinymce config for Laravel File Manager

function init_editor(){
    /*
    tinymce.init({
      selector: '.editor'
    });
    return;
    */
    var editor_config = {
        path_absolute : "/",
        selector: "textarea.editor",
        plugins: [
            "advlist autolink lists link image charmap print preview hr anchor pagebreak",
            "searchreplace wordcount visualblocks visualchars code fullscreen",
            "insertdatetime media nonbreaking save table contextmenu directionality",
            "emoticons template paste textcolor colorpicker textpattern"
        ],
        toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image media",
        relative_urls: false,
        height: 300, 
        file_browser_callback : function(field_name, url, type, win) {
            var x = window.innerWidth || document.documentElement.clientWidth || document.getElementsByTagName('body')[0].clientWidth;
            var y = window.innerHeight|| document.documentElement.clientHeight|| document.getElementsByTagName('body')[0].clientHeight;

            var cmsURL = editor_config.path_absolute + 'laravel-filemanager?field_name=' + field_name;
            if (type == 'image') {
              cmsURL = cmsURL + "&type=Images";
            } else {
              cmsURL = cmsURL + "&type=Files";
            }

            tinyMCE.activeEditor.windowManager.open({
              file : cmsURL,
              title : 'Filemanager',
              width : x * 0.8,
              height : y * 0.8,
              resizable : "yes",
              close_previous : "no"
            });
        },
        setup: function (editor) {
            editor.on('change', function () {
                tinymce.triggerSave();
            });
        }
    };

    tinymce.init(editor_config);
}

function init_editor(){

tinymce.init({

selector: '.editor'

});

return;

var editor_config = {

path_absolute : "/",

selector: "textarea.editor",

plugins: [

"advlist autolink lists link image charmap print preview hr anchor pagebreak",

"searchreplace wordcount visualblocks visualchars code fullscreen",

"insertdatetime media nonbreaking save table contextmenu directionality",

"emoticons template paste textcolor colorpicker textpattern"

relative_urls: false,

height: 300,

file_browser_callback : function(field_name, url, type, win) {

var x = window.innerWidth || document.documentElement.clientWidth || document.getElementsByTagName('body')[0].clientWidth;

var y = window.innerHeight|| document.documentElement.clientHeight|| document.getElementsByTagName('body')[0].clientHeight;

var cmsURL = editor_config.path_absolute + 'laravel-filemanager?field_name=' + field_name;

if (type == 'image') {

cmsURL = cmsURL + "&type=Images";

} else {

cmsURL = cmsURL + "&type=Files";

}

tinyMCE.activeEditor.windowManager.open({

file : cmsURL,

title : 'Filemanager',

width : x * 0.8,

height : y * 0.8,

resizable : "yes",

close_previous : "no"

});

setup: function (editor) {

editor.on('change', function () {

tinymce.triggerSave();

});

}

};

tinymce.init(editor_config);

}

SendGrid API return 0 on dev machine

This could be SSL cert issue. Here is the solution:

Download cacert.pem
https://curl.haxx.se/docs/caextract.html
Store the file in C:\PHP
Change php.ini:
curl.cainfo = c:\php\cacert.pem
Restart web server (IIS or apache)

Reference:

https://snippets.webaware.com.au/howto/stop-turning-off-curlopt_ssl_verifypeer-and-fix-your-php-config/

VS Code Related

For PHP

[Community Open Camp] 給 PHP 開發者的 VS Code 指南 from Shengyou Fan

Phpspreadsheet memory issue

https://phpspreadsheet.readthedocs.io/en/develop/topics/memory_saving/

Redis is recommended.

Customize tinymce in Voyager

Add additional_js:

https://docs.laravelvoyager.com/customization/additional-css-js

‘js/custom.js’ => ‘public/js/custom.js’

Add callback function in additional js:

https://docs.laravelvoyager.com/customization/tinymce

Rename or copy plugin.min.js to plugin.js

TinyMCE will find plugin.js of each plugins in public\vendor\tcg\voyager\assets\js\plugins
https://www.tiny.cloud/docs/advanced/creating-a-plugin/

Example:

function tinymce_init_callback(editor)
{
      editor.remove();
      editor = null;

      tinymce.init({
        selector: 'textarea.richTextBox',
        skin: 'voyager',
        min_height: 100,
        height: 200, 
        resize: 'vertical',
        plugins: 'print preview searchreplace autolink directionality visualblocks visualchars fullscreen image link media template codesample table charmap hr pagebreak nonbreaking anchor insertdatetime advlist lists textcolor wordcount imagetools contextmenu colorpicker textpattern code',
        extended_valid_elements: 'input[id|name|value|type|class|style|required|placeholder|autocomplete|onclick]',
        file_browser_callback: function (field_name, url, type, win) {
            if (type == 'image') {
                $('#upload_file').trigger('click');
            }
        },
        toolbar: 'styleselect bold italic underline | forecolor backcolor | alignleft aligncenter alignright | bullist numlist outdent indent | link image table youtube giphy | code',
        convert_urls: false,
        image_caption: true,
        image_title: true,
        valid_elements:'div[*],p[*],span[*],ul[*],li[*],ol[*],hr,br,img[*],-b,-i,-u', 
        valid_children:'+li[span|p|div]'
    });
}

function tinymce_init_callback(editor)

{

editor.remove();

editor = null;

tinymce.init({

selector: 'textarea.richTextBox',

skin: 'voyager',

min_height: 100,

height: 200,

resize: 'vertical',

plugins: 'print preview searchreplace autolink directionality visualblocks visualchars fullscreen image link media template codesample table charmap hr pagebreak nonbreaking anchor insertdatetime advlist lists textcolor wordcount imagetools contextmenu colorpicker textpattern code',

file_browser_callback: function (field_name, url, type, win) {

if (type == 'image') {

$('#upload_file').trigger('click');

}

convert_urls: false,

image_caption: true,

image_title: true,

valid_elements:'div[*],p[*],span[*],ul[*],li[*],ol[*],hr,br,img[*],-b,-i,-u',

valid_children:'+li[span|p|div]'

});

}

Reference:

https://github.com/the-control-group/voyager/issues/1945
Remove doctype and html tags that generated by tinymce automatically: Remove fullpage plugin.
https://stackoverflow.com/questions/17829239/how-can-i-stop-tinymce-from-adding-doctype-htmlhtmlhead-headbody-to-e
https://stackoverflow.com/questions/6266487/tinymce-allow-all-html-tag
https://stackoverflow.com/questions/7744903/tinymce-allow-data-attribute

Prevent TinyMCE from removing span elements

https://stackoverflow.com/questions/14962819/prevent-tinymce-from-removing-span-elements

Show custom error messages from server side

    function init_dt(){
        datatable = $t.on('xhr.dt', function ( e, settings, json, xhr ) {
            console.log(json);
            alert(json.message);
        })
        .DataTable({
            "searching": true,
            "info": true,
            "lengthChange": true,
            "paging": true,
            'serverSide': true, 
            'processing': true, 
            "ajax": {
                'url': base_url + 'admin/ajax/' + app_key + 's',
                'data': function(d){
                    var $c = $('.buttons_panel');
                    d.exam_type = get_value('exam_type', $c);
                }
            },
            "order": [[ 7, "desc" ], [ 0, "asc" ]], 
            "columnDefs": [
                {
                    "targets": [ 0 ],
                    "visible": true,
                    "searchable": false
                }
            ], 
            "drawCallback": function( settings ) {
                var api = this.api();
                //wrap.loaded(settings);
                loaded(settings);
            }, 
            'initComplete': function(settings, json){
                //loaded(settings);
            },
            "language" : {
                "url": "/plugins/datatable_zhtw.json"
            }
        });
    }

function init_dt(){

datatable = $t.on('xhr.dt', function ( e, settings, json, xhr ) {

console.log(json);

alert(json.message);

})

.DataTable({

"searching": true,

"info": true,

"lengthChange": true,

"paging": true,

'serverSide': true,

'processing': true,

"ajax": {

'url': base_url + 'admin/ajax/' + app_key + 's',

'data': function(d){

var $c = $('.buttons_panel');

d.exam_type = get_value('exam_type', $c);

}

"order": [[ 7, "desc" ], [ 0, "asc" ]],

"columnDefs": [

{

"targets": [ 0 ],

"visible": true,

"searchable": false

}

"drawCallback": function( settings ) {

var api = this.api();

//wrap.loaded(settings);

loaded(settings);

'initComplete': function(settings, json){

//loaded(settings);

"language" : {

"url": "/plugins/datatable_zhtw.json"

}

});

}

The key is to add a listener to “xhr.dt” event before initialize datatable plugin.

Server side:

    protected function datatable_response($total, $filtered_total, $data=[], $draw=0){
        header('Content-Type: application/json');

        $out = array();
        $out['draw'] = $draw;
        $out['recordsTotal'] = $total;
        $out['recordsFiltered'] = $filtered_total;
        $out['data'] = $data;
        $out['message'] = 'test error';
     
        echo json_encode($out);
        exit();
    }

protected function datatable_response($total, $filtered_total, $data=[], $draw=0){

header('Content-Type: application/json');

$out = array();

$out['draw'] = $draw;

$out['recordsTotal'] = $total;

$out['recordsFiltered'] = $filtered_total;

$out['data'] = $data;

$out['message'] = 'test error';

echo json_encode($out);

exit();

}

Reference:

https://datatables.net/reference/event/xhr

Custom http error response in JSON

Server side (PHP):

    protected function json_response($code=200, $message='', $data=null){
        http_response_code($code);
        //Output;
        header('Cache-Control: no-cache, must-revalidate');
        header('Content-type: application/json;charset=utf-8');

        $out = array(
            'code' => $code, 
            'message' => $message, 
            'data' => $data
        );
        echo json_encode($out);
        exit();
    }

protected function json_response($code=200, $message='', $data=null){

http_response_code($code);

//Output;

header('Cache-Control: no-cache, must-revalidate');

header('Content-type: application/json;charset=utf-8');

$out = array(

'code' => $code,

'message' => $message,

'data' => $data

);

echo json_encode($out);

exit();

}

Client (with datatable):

    function init_dt(){
        datatable = $t.DataTable({
            "searching": true,
            "info": true,
            "lengthChange": true,
            "paging": true,
            'serverSide': true, 
            'processing': true, 
            "ajax": {
                'url': base_url + 'admin_ajax/products/all',
                'data': function(d){
                    var $c = $('.option_panel');
                    d.store_id = $('#store').val();
                    d.campaign_id = $('#campaign').val();
                    d.cat_id = $('#cat').val();
                }, 
                error: function (xhr, error, thrown) {
                    //error( xhr, error, thrown );
                    console.log(xhr);
                    console.log(error);
                    console.log(thrown);
                    var response = xhr.responseJSON;
                    var msg = response.message;
                    alert(msg);
                }
            },
            "order": [[ 1, "desc" ], [ 0, "asc" ]], 
            "columnDefs": [
                {
                    "targets": [ 0 ],
                    "visible": true,
                    "searchable": false
                }
            ], 
            "drawCallback": function( settings ) {
                var api = this.api();
                //wrap.loaded(settings);
                loaded(settings);
            }, 
            'initComplete': function(settings, json){
                //loaded(settings);
            },
            "language" : {
                "url": "/assets/plugins/datatable_zhtw.json"
            }
        });
    }

function init_dt(){

datatable = $t.DataTable({

"searching": true,

"info": true,

"lengthChange": true,

"paging": true,

'serverSide': true,

'processing': true,

"ajax": {

'url': base_url + 'admin_ajax/products/all',

'data': function(d){

var $c = $('.option_panel');

d.store_id = $('#store').val();

d.campaign_id = $('#campaign').val();

d.cat_id = $('#cat').val();

error: function (xhr, error, thrown) {

//error( xhr, error, thrown );

console.log(xhr);

console.log(error);

console.log(thrown);

var response = xhr.responseJSON;

var msg = response.message;

alert(msg);

}

"order": [[ 1, "desc" ], [ 0, "asc" ]],

"columnDefs": [

{

"targets": [ 0 ],

"visible": true,

"searchable": false

}

"drawCallback": function( settings ) {

var api = this.api();

//wrap.loaded(settings);

loaded(settings);

'initComplete': function(settings, json){

//loaded(settings);

"language" : {

"url": "/assets/plugins/datatable_zhtw.json"

}

});

}

Result in Chrome dev tool:

Clear cookies in Postman

Reference:

https://www.getpostman.com/docs/v6/postman/sending_api_requests/cookies

Phpspreadsheet (PHP Excel)

Phpspreadsheet: (phpexcel is deprecated):

https://github.com/PHPOffice/PhpSpreadsheet

Don’t use heading as data key:

/config/excel.php: heading => false;

Setting a cell value by column and row

// Set cell A5 with a string value
$spreadsheet->getActiveSheet()->setCellValueByColumnAndRow(1, 5, 'PhpSpreadsheet');

1 2	// Set cell A5 with a string value $spreadsheet->getActiveSheet()->setCellValueByColumnAndRow(1, 5, 'PhpSpreadsheet');

Retrieving a cell value by column and row

// Get the value from cell B5
$cellValue = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(2, 5)->getValue();

1 2	// Get the value from cell B5 $cellValue = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(2, 5)->getValue();

Reference:

https://phpspreadsheet.readthedocs.io/en/develop/topics/accessing-cells/

Export Excel

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

    public function products_export(Request $req){
        $this->check_login();

        $options = [
            'source' => $req->input('source'), 
            'keyword' => $req->input('keyword'), 
            'status' => $req->input('status'), 
            'house' => $req->input('house')
        ];
        //logg($options);

        $data = ProductM::items($options);
        //logg($data);
        $fields = Config::get('admin.product_export');
        //logg($fields);

        $file_name = 'Products.xlsx';
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        //$excel->setActiveSheetIndex(0);

        //Write headers
        $row_index = 1;
        $col_index = 1;
        foreach ($fields as $key => $field) {
            $sheet->setCellValueByColumnAndRow($col_index, $row_index, $field[1]);

            $col_index++;
        }

        //Write data
        $row_index++;
        foreach ($data as $key => $item) {
            $col_index = 1;
            foreach ($fields as $key => $field) {
                $value = val($item, $field[0]);
                $sheet->setCellValueByColumnAndRow($col_index, $row_index, $value);
                $col_index++;
            }

            $row_index++;
        }
 
        // Redirect output to a client’s web browser (Xlsx)
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment;filename="' . $file_name . '"');
        header('Cache-Control: max-age=0');
        // If you're serving to IE 9, then the following may be needed
        header('Cache-Control: max-age=1');
         
        // If you're serving to IE over SSL, then the following may be needed
        header('Expires: Mon, 26 Jul 2019 05:00:00 GMT'); // Date in the past
        header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
        header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
        header('Pragma: public'); // HTTP/1.0
         
        $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
        $writer->save('php://output');
    }

use PhpOffice\PhpSpreadsheet\IOFactory;

use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

use PhpOffice\PhpSpreadsheet\Spreadsheet;

public function products_export(Request $req){

$this->check_login();

$options = [

'source' => $req->input('source'),

'keyword' => $req->input('keyword'),

'status' => $req->input('status'),

'house' => $req->input('house')

];

//logg($options);

$data = ProductM::items($options);

//logg($data);

$fields = Config::get('admin.product_export');

//logg($fields);

$file_name = 'Products.xlsx';

$spreadsheet = new Spreadsheet();

$sheet = $spreadsheet->getActiveSheet();

//$excel->setActiveSheetIndex(0);

//Write headers

$row_index = 1;

$col_index = 1;

foreach ($fields as $key => $field) {

$sheet->setCellValueByColumnAndRow($col_index, $row_index, $field[1]);

$col_index++;

}

//Write data

$row_index++;

foreach ($data as $key => $item) {

$col_index = 1;

foreach ($fields as $key => $field) {

$value = val($item, $field[0]);

$sheet->setCellValueByColumnAndRow($col_index, $row_index, $value);

$col_index++;

}

$row_index++;

}

// Redirect output to a client’s web browser (Xlsx)

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

header('Content-Disposition: attachment;filename="' . $file_name . '"');

header('Cache-Control: max-age=0');

// If you're serving to IE 9, then the following may be needed

header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed

header('Expires: Mon, 26 Jul 2019 05:00:00 GMT'); // Date in the past

header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified

header('Cache-Control: cache, must-revalidate'); // HTTP/1.1

header('Pragma: public'); // HTTP/1.0

$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');

$writer->save('php://output');

}

Update Excel and export:

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

    public function download_upload_template(Request $req){
        $file_name = 'upload_template.xlsx';
        $tpl = storage_path('app/upload_template.xlsx');
        $excel = IOFactory::load($tpl);
        
        //Choose second sheet
        $sheet = $excel->setActiveSheetIndex(1);

        //Write sources
        $source_data = SourceM::orderBy('id')->get();
        $row_index = 2;
        foreach ($source_data as $key => $item) {
            $col_index = 1;
            $sheet->setCellValueByColumnAndRow($col_index, $row_index, $item->id);
            $sheet->setCellValueByColumnAndRow($col_index+1, $row_index, $item->name);
            $row_index++;
        }

        $excel->setActiveSheetIndex(0);

        // Redirect output to a client’s web browser (Xlsx)
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment;filename="' . $file_name . '"');
        header('Cache-Control: max-age=0');
        // If you're serving to IE 9, then the following may be needed
        header('Cache-Control: max-age=1');
         
        // If you're serving to IE over SSL, then the following may be needed
        header('Expires: Mon, 26 Jul 2019 05:00:00 GMT'); // Date in the past
        header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
        header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
        header('Pragma: public'); // HTTP/1.0
         
        $writer = IOFactory::createWriter($excel, 'Xlsx');
        $writer->save('php://output');
    }

use PhpOffice\PhpSpreadsheet\IOFactory;

use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

public function download_upload_template(Request $req){

$file_name = 'upload_template.xlsx';

$tpl = storage_path('app/upload_template.xlsx');

$excel = IOFactory::load($tpl);

//Choose second sheet

$sheet = $excel->setActiveSheetIndex(1);

//Write sources

$source_data = SourceM::orderBy('id')->get();

$row_index = 2;

foreach ($source_data as $key => $item) {

$col_index = 1;

$sheet->setCellValueByColumnAndRow($col_index, $row_index, $item->id);

$sheet->setCellValueByColumnAndRow($col_index+1, $row_index, $item->name);

$row_index++;

}

$excel->setActiveSheetIndex(0);

// Redirect output to a client’s web browser (Xlsx)

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

header('Content-Disposition: attachment;filename="' . $file_name . '"');

header('Cache-Control: max-age=0');

// If you're serving to IE 9, then the following may be needed

header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed

header('Expires: Mon, 26 Jul 2019 05:00:00 GMT'); // Date in the past

header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified

header('Cache-Control: cache, must-revalidate'); // HTTP/1.1

header('Pragma: public'); // HTTP/1.0

$writer = IOFactory::createWriter($excel, 'Xlsx');

$writer->save('php://output');

}

Import:

    //對應匯入的excel欄位
    'product_import' => [
        'A' => ['source', '來源', true, 'int'],
        'B' => ['iccid', 'ICCID', true, 'string'],
        'C' => ['phone', '電話號碼', true, 'string'],
        'D' => ['item', '品項', true, 'int'],
        'E' => ['customer', '客戶名稱', false, 'string'],
        'F' => ['house', '倉庫地點', true, 'int'],
        'G' => ['purchase_date', '進貨日', true, 'date'],
        'H' => ['ship_date', '出貨日', true, 'date'],
        'I' => ['enabled_start', '啟用開始日', true, 'date'],
        'J' => ['enabled_end', '啟用結束日', true, 'date'],
        'K' => ['enabled_end_buff', '啟用結束日回朔天數', false, 'int'],
        'L' => ['user_enabled', '客戶啟用日', false, 'date'],
        'M' => ['status', '狀態', true, 'int'],
        'N' => ['last_at', '最後使用日期', false, 'date'],
        'O' => ['note', '備註', false, 'string']
    ],

//對應匯入的excel欄位

'product_import' => [

'A' => ['source', '來源', true, 'int'],

'B' => ['iccid', 'ICCID', true, 'string'],

'C' => ['phone', '電話號碼', true, 'string'],

'D' => ['item', '品項', true, 'int'],

'E' => ['customer', '客戶名稱', false, 'string'],

'F' => ['house', '倉庫地點', true, 'int'],

'G' => ['purchase_date', '進貨日', true, 'date'],

'H' => ['ship_date', '出貨日', true, 'date'],

'I' => ['enabled_start', '啟用開始日', true, 'date'],

'J' => ['enabled_end', '啟用結束日', true, 'date'],

'K' => ['enabled_end_buff', '啟用結束日回朔天數', false, 'int'],

'L' => ['user_enabled', '客戶啟用日', false, 'date'],

'M' => ['status', '狀態', true, 'int'],

'N' => ['last_at', '最後使用日期', false, 'date'],

'O' => ['note', '備註', false, 'string']

    public function import_handler(Request $req){
        $file = $req->file('file');
        //logg($file->getClientOriginalName());
        //$this->excel_handler($target_file);

        $file_name = 'import.xlsx';
        $dest = storage_path('app');
        $file->move($dest, $file_name);
        //$path = $file->store('app/public');
        //logg($dest);

        $spreadsheet = IOFactory::load($dest . '/' . $file_name);
        $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
        //dd($sheetData);

        $fields = Config::get('admin.product_import');
        //logg($fields);

        $success = 0;
        $failed = 0;
        foreach ($sheetData as $row_index => $row) {
            if($row_index == 1) continue;
            //logg($row);
            $data = [];
            $row_errs = [];
            foreach ($fields as $key => $field) {
                $value = val($row, $key);
                //logg($value);

                if($value == false){
                    if($field[2] == true){
                        $row_errs[] = $field[1] . ' 為必填';
                        break;
                    }else{
                        continue;
                    }
                }

                //If value is date, the value will be converted to Carbon.
                if($field[3] == 'date' && $value != false){
                    $value = Carbon::parse($value)->toDateString();
                    //logg($value);
                }

                if($field[0] == 'iccid'){
                    if($value == false){
                        $row_errs[] = $field[1] . '為必填';
                    }else{
                        $current_iccid = ProductM::item_by_iccid($value);
                        if($current_iccid != false){
                            $row_errs[] = $value . '已經存在';
                        }
                    }
                }

                if($field[0] == 'enabled_end_buff'){
                    //Get index of enabled_end
                    if($data['enabled_end'] != false && $value != false && $value > 0){
                        $d = Carbon::parse($data['enabled_end']);
                        $data['enabled_end'] = $d->subDays($value)->toDateString();
                    }
                }

                $data[$field[0]] = $value;
            }
            //logg($data);

            if($row_errs == false){
                $result = ProductM::new_item($data);
                if($result == false){
                    echo '第' . ($row_index) . '列: Failed. 新增資料失敗<br/>';
                    $failed++;
                }else{
                    echo '第' . ($row_index) . '列: Success.<br/>';
                    $success++;
                }
            }else{
                echo '第' . ($row_index) . '列: Failed. ' . implode(';', $row_errs) . '<br/>';
                $failed++;
            }
        }

        echo '完成, 成功:' . $success . '筆, 失敗: ' . $failed;
    }

public function import_handler(Request $req){

$file = $req->file('file');

//logg($file->getClientOriginalName());

//$this->excel_handler($target_file);

$file_name = 'import.xlsx';

$dest = storage_path('app');

$file->move($dest, $file_name);

//$path = $file->store('app/public');

//logg($dest);

$spreadsheet = IOFactory::load($dest . '/' . $file_name);

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

//dd($sheetData);

$fields = Config::get('admin.product_import');

//logg($fields);

$success = 0;

$failed = 0;

foreach ($sheetData as $row_index => $row) {

if($row_index == 1) continue;

//logg($row);

$data = [];

$row_errs = [];

foreach ($fields as $key => $field) {

$value = val($row, $key);

//logg($value);

if($value == false){

if($field[2] == true){

$row_errs[] = $field[1] . ' 為必填';

break;

}else{

continue;

}

//If value is date, the value will be converted to Carbon.

if($field[3] == 'date' && $value != false){

$value = Carbon::parse($value)->toDateString();

//logg($value);

}

if($field[0] == 'iccid'){

if($value == false){

$row_errs[] = $field[1] . '為必填';

}else{

$current_iccid = ProductM::item_by_iccid($value);

if($current_iccid != false){

$row_errs[] = $value . '已經存在';

}

if($field[0] == 'enabled_end_buff'){

//Get index of enabled_end

if($data['enabled_end'] != false && $value != false && $value > 0){

$d = Carbon::parse($data['enabled_end']);

$data['enabled_end'] = $d->subDays($value)->toDateString();

}

$data[$field[0]] = $value;

}

//logg($data);

if($row_errs == false){

$result = ProductM::new_item($data);

if($result == false){

echo '第' . ($row_index) . '列: Failed. 新增資料失敗<br/>';

$failed++;

}else{

echo '第' . ($row_index) . '列: Success.<br/>';

$success++;

}

}else{

echo '第' . ($row_index) . '列: Failed. ' . implode(';', $row_errs) . '<br/>';

$failed++;

}

echo '完成, 成功:' . $success . '筆, 失敗: ' . $failed;

}

M	T	W	T	F	S	S
« Jul
			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

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Category Archives: Web Tools

Tinymce config for Laravel File Manager

SendGrid API return 0 on dev machine

VS Code Related

Phpspreadsheet memory issue

Customize tinymce in Voyager

Add additional_js:

Add callback function in additional js:

Rename or copy plugin.min.js to plugin.js

Example:

Prevent TinyMCE from removing span elements

Show custom error messages from server side

Custom http error response in JSON

Clear cookies in Postman

Phpspreadsheet (PHP Excel)

Setting a cell value by column and row

Retrieving a cell value by column and row

Export Excel

Update Excel and export:

Import: