Category Archives: Web Tools

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:

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:

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

        $file_name = 'upload_questions.xls';
        $dest = storage_path('app/uploaded');
        $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);

        $success = 0;
        $failed = 0;
        $row_index = 2;
        foreach($sheetData as $key => $row) {
            if($key == 1) continue;
            //logg($row);

            $row_errs = [];

            //Add question
            $q_data = [
                'content' => $row['A'], 
                'question_type' => $row['B'], 
                'answer_type' => $row['C']
            ];
            $q_id = Questions::new_data($q_data);
            if($q_id == false){
                $row_errs[] = '無法新增問題: ' . $row['A'];
            }

            //Add answers
            $answers = explode(';', $row['D']);
            $corrects = explode(';', $row['E']);
            foreach ($answers as $key => $answer) {
                if(in_array($key+1, $corrects) == true){
                    $is_answer = 1;
                }else{
                    $is_answer = 0;
                }

                $a_data = [
                    'question_id' => $q_id, 
                    'content' => $answer, 
                    'is_answer' => $is_answer
                ];
                $result = Answers::new_data($a_data);
                if($result == false){
                    $row_errs[] = '無法新增答案: ' . $answer;
                }
            }

            if($row_errs == false){
                echo '第' . ($row_index) . '列: Success.<br/>';
                $success++;
            }else{
                echo '第' . ($row_index) . '列: Failed. ' . implode('; ', $row_errs) . '<br/>';
                $failed++;
            }

            $row_index++;
        }

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

public function import_questions_handler(Request $req){

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

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

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

$file_name = 'upload_questions.xls';

$dest = storage_path('app/uploaded');

$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);

$success = 0;

$failed = 0;

$row_index = 2;

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

if($key == 1) continue;

//logg($row);

$row_errs = [];

//Add question

$q_data = [

'content' => $row['A'],

'question_type' => $row['B'],

'answer_type' => $row['C']

];

$q_id = Questions::new_data($q_data);

if($q_id == false){

$row_errs[] = '無法新增問題: ' . $row['A'];

}

//Add answers

$answers = explode(';', $row['D']);

$corrects = explode(';', $row['E']);

foreach ($answers as $key => $answer) {

if(in_array($key+1, $corrects) == true){

$is_answer = 1;

}else{

$is_answer = 0;

}

$a_data = [

'question_id' => $q_id,

'content' => $answer,

'is_answer' => $is_answer

];

$result = Answers::new_data($a_data);

if($result == false){

$row_errs[] = '無法新增答案: ' . $answer;

}

if($row_errs == false){

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

$success++;

}else{

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

$failed++;

}

$row_index++;

}

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

}

Datatable Server Side Processing (Laravel)

Javascript:

var dt_members = function(){
    var $c = null;
    var $t = null;
    var datatable = null;

    function init(){
        $c = $(".main-content");
        $t = $c.find('#dt_members');

        $t.find('input[name="sell_id"]').on('click', function(e){
            var $this = $(this);
            if($this.prop('checked') == true){
                total += parseInt($this.data('qty'));
            }else{
                total -= parseInt($this.data('qty'));
            }

            refresh_total();
        });

        init_dt();
    }

    function init_dt(){
        datatable = $t.DataTable({
            "searching": true,
            "info": true,
            "lengthChange": true,
            "paging": true,
            'serverSide': true, 
            'processing': true, 
            "ajax": {
                'url': base_url + 'admin/ajax/members',
                'data': function(d){
                    //var $c = $('#c-tabs-1');
                    //d.keyword = get_value('keyword', $c);
                }
            },
            //"order": [[ 6, "asc" ], [ 5, "" ]], 
            "columnDefs": [
                {
                    "targets": [ 1 ],
                    "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 loaded(oSettings){
        $t.find('.action_edit').on('click', function(e){
            e.preventDefault();
            var $this = $(this);
            var member_id = $this.data('id');
            
            member_app.show(member_id, 'edit');
        });

        $t.find('.action_buy').on('click', function(e){
            e.preventDefault();
            var $this = $(this);
            var member_id = $this.data('id');
            
            ticket_app.show(member_id, 'buy');
        });

        $t.find('.action_sell').on('click', function(e){
            e.preventDefault();
            var $this = $(this);
            var member_id = $this.data('id');
            
            ticket_app.show(member_id, 'sell');
        });
    }

    function refresh(){
        //d_table.fnDestroy();
        if(datatable != null){
            datatable.destroy();
        }
        //var $t = $c.find('.datatable');
        //console.log($.fn.dataTable.isDataTable($t));
        
        init_dt();
    }

    return {
        init: init, 
        refresh: refresh
    }
}();

100

101

102

var dt_members = function(){

var $c = null;

var $t = null;

var datatable = null;

function init(){

$c = $(".main-content");

$t = $c.find('#dt_members');

$t.find('input[name="sell_id"]').on('click', function(e){

var $this = $(this);

if($this.prop('checked') == true){

total += parseInt($this.data('qty'));

}else{

total -= parseInt($this.data('qty'));

}

refresh_total();

});

init_dt();

}

function init_dt(){

datatable = $t.DataTable({

"searching": true,

"info": true,

"lengthChange": true,

"paging": true,

'serverSide': true,

'processing': true,

"ajax": {

'url': base_url + 'admin/ajax/members',

'data': function(d){

//var $c = $('#c-tabs-1');

//d.keyword = get_value('keyword', $c);

}

//"order": [[ 6, "asc" ], [ 5, "" ]],

"columnDefs": [

{

"targets": [ 1 ],

"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 loaded(oSettings){

$t.find('.action_edit').on('click', function(e){

e.preventDefault();

var $this = $(this);

var member_id = $this.data('id');

member_app.show(member_id, 'edit');

});

$t.find('.action_buy').on('click', function(e){

e.preventDefault();

var $this = $(this);

var member_id = $this.data('id');

ticket_app.show(member_id, 'buy');

});

$t.find('.action_sell').on('click', function(e){

e.preventDefault();

var $this = $(this);

var member_id = $this.data('id');

ticket_app.show(member_id, 'sell');

});

}

function refresh(){

//d_table.fnDestroy();

if(datatable != null){

datatable.destroy();

}

//var $t = $c.find('.datatable');

//console.log($.fn.dataTable.isDataTable($t));

init_dt();

}

return {

init: init,

refresh: refresh

}

}();

Config:

<?php
return [
    'member_table' => [
        'id' => ['ID', true, 'int'],
        'name' => ['姓名', true, 'int'],
        'email' => ['Email', true, 'string'],
        'phone' => ['電話', true, 'string'],
        'pid' => ['身份證', true, 'string'],
        'status' => ['狀態', true, 'int'],
        'created_time' => ['建立時間', true, 'datetime'], 
        'action' => ['動作', true, 'string']
    ], 
];

<?php

return [

'member_table' => [

'id' => ['ID', true, 'int'],

'name' => ['姓名', true, 'int'],

'email' => ['Email', true, 'string'],

'phone' => ['電話', true, 'string'],

'pid' => ['身份證', true, 'string'],

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

'created_time' => ['建立時間', true, 'datetime'],

'action' => ['動作', true, 'string']

];

Controller:

    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;
     
        echo json_encode($out);
        exit();
    }

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

        $draw = $req->input('draw');
        $start = $req->input('start');
        $length = $req->input('length');
        $search = $req->input('search');
        $keyword = $search['value'];

        //Get sorting array with column name
        $fields = Config::get('admin.member_table');
        $order = $req->input('order');
        $sorting = MemberM::datatable_sorting($fields, $order);
        //logg($sorting);

        $options = [
            'start' => $start, 
            'limit' => $length, 
            'sort' => $sorting, 
            'keyword' => $keyword
        ];
        $total = MemberM::items($options, MemberM::DT_TOTAL);
        $filtered_total = MemberM::items($options, MemberM::DT_FILTERED);
        $members = MemberM::items($options);

        $members = MemberM::datatable_data($members);

        $this->datatable_response($total, $filtered_total, $members, $draw);
    }

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;

echo json_encode($out);

exit();

}

public function members(Request $req){

$this->check_login();

$draw = $req->input('draw');

$start = $req->input('start');

$length = $req->input('length');

$search = $req->input('search');

$keyword = $search['value'];

//Get sorting array with column name

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

$order = $req->input('order');

$sorting = MemberM::datatable_sorting($fields, $order);

//logg($sorting);

$options = [

'start' => $start,

'limit' => $length,

'sort' => $sorting,

'keyword' => $keyword

];

$total = MemberM::items($options, MemberM::DT_TOTAL);

$filtered_total = MemberM::items($options, MemberM::DT_FILTERED);

$members = MemberM::items($options);

$members = MemberM::datatable_data($members);

$this->datatable_response($total, $filtered_total, $members, $draw);

}

Model:

    static function items($options, $return_type=0){
        $result = DB::table('member');

        if($return_type == self::DT_TOTAL){
            return $result->count();
        }

        $keyword = val($options, 'keyword');
        if($keyword != false){
            $result = $result->where(function($query) use ($keyword){
                $find = '%' . $keyword . '%';
                $query->orWhere('name', 'like', $find);
                $query->orWhere('email', 'like', $find);
                $query->orWhere('phone', 'like', $find);
                $query->orWhere('pid', 'like', $find);
            });
        }

        if($return_type == self::DT_FILTERED){
            return $result->count();
        }

        if(val($options, 'sort') != false){
            $sorting = val($options, 'sort');
            foreach ($sorting as $key => $value) {
                $result = $result->orderBy($key, $value);
            }
        }else{
            $result = $result->orderBy('created_time', 'desc');
        }

        $result = $result->skip($options['start'])
            ->take($options['limit'])
            ->get();

        return $result;
    }

    static function datatable_sorting($columns, $order){
        //$columns = $this->config->item('adm_page_columns');
        //$order = $this->input->get('order');
     
        $sort = array();
        foreach($order as $key => $item){
            $col_index = $item['column'];
            $dir = $item['dir'];
     
            $column = null;
            $column_key = null;
            $i = 0;
            foreach ($columns as $key => $item) {
                if($i == $col_index){
                    $column = $item;
                    $column_key = $key;
                    break;
                }
                $i++;
            }
     
            $sort[$column_key] = $dir;
        }
     
        return $sort;
    }

    static function datatable_data($data){
        $fields = Config::get('admin.member_table');

        $new_data = array();
        foreach($data as $item){
            $item_values = [];

            foreach ($fields as $key => $field) {
                $value = val($item, $key);

                if($key == 'status'){
                    $value = trans('front.member_status.' . $item->status);
                }

                if($key == 'action'){
                    $value = '<div class="dropdown">
                            <button class="btn btn-default dropdown-toggle" type="button" id="dropdownMenu1" data-toggle="dropdown" aria-haspopup="true" aria-expanded="true">
                                選擇
                                <span class="caret"></span>
                            </button>
                            <ul class="dropdown-menu" aria-labelledby="dropdownMenu1">
                                <li><a href="#" class="action_edit" data-id="' . $item->id . '">修改</a></li>
                                <li><a href="#" class="action_buy" data-id="' . $item->id . '">下買單</a></li>
                                <li><a href="#" class="action_sell" data-id="' . $item->id . '">下賣單</a></li>
                            </ul>
                        </div>';
                }

                $item_values[] = $value;
            }

            array_push($new_data, $item_values);
        }

        return $new_data;
    }

100

101

static function items($options, $return_type=0){

$result = DB::table('member');

if($return_type == self::DT_TOTAL){

return $result->count();

}

$keyword = val($options, 'keyword');

if($keyword != false){

$result = $result->where(function($query) use ($keyword){

$find = '%' . $keyword . '%';

$query->orWhere('name', 'like', $find);

$query->orWhere('email', 'like', $find);

$query->orWhere('phone', 'like', $find);

$query->orWhere('pid', 'like', $find);

});

}

if($return_type == self::DT_FILTERED){

return $result->count();

}

if(val($options, 'sort') != false){

$sorting = val($options, 'sort');

foreach ($sorting as $key => $value) {

$result = $result->orderBy($key, $value);

}

}else{

$result = $result->orderBy('created_time', 'desc');

}

$result = $result->skip($options['start'])

->take($options['limit'])

->get();

return $result;

}

static function datatable_sorting($columns, $order){

//$columns = $this->config->item('adm_page_columns');

//$order = $this->input->get('order');

$sort = array();

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

$col_index = $item['column'];

$dir = $item['dir'];

$column = null;

$column_key = null;

$i = 0;

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

if($i == $col_index){

$column = $item;

$column_key = $key;

break;

}

$i++;

}

$sort[$column_key] = $dir;

}

return $sort;

}

static function datatable_data($data){

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

$new_data = array();

foreach($data as $item){

$item_values = [];

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

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

if($key == 'status'){

$value = trans('front.member_status.' . $item->status);

}

if($key == 'action'){

$value = '<div class="dropdown">

選擇

</button>

</ul>

</div>';

}

$item_values[] = $value;

}

array_push($new_data, $item_values);

}

return $new_data;

}

Clear everything in Redis

redis-cli flushall

1	redis-cli flushall

Reference:

https://stackoverflow.com/questions/6851909/how-do-i-delete-everything-in-redis

Disable datatable warnings

//Disable datatable warnings
$.fn.dataTable.ext.errMode = 'none';

1 2	//Disable datatable warnings $.fn.dataTable.ext.errMode = 'none';

Reference:

https://datatables.net/forums/discussion/28726/how-to-disable-the-warning-message

SendGrid API Example

Doc: https://github.com/sendgrid/sendgrid-php

Complete example:
https://github.com/sendgrid/sendgrid-php/blob/master/USE_CASES.md#attachments

Example:

   public function send($subject, $msg, $contact, $attachment=null){
        $from = new SendGrid\Email($this->sender['name'], $this->sender['email']);
        $subject = $subject;
        $to = new SendGrid\Email($contact['name'], $contact['email']);
        $content = new SendGrid\Content("text/html", $msg);
        $mail = new SendGrid\Mail($from, $subject, $to, $content);

        if($attachment != false){
            $att = $this->process_attachment($attachment);
            $mail->addAttachment($att);
        }

        $apiKey = $this->sg_key;
        $sg = new \SendGrid($apiKey);

        $response = $sg->client->mail()->send()->post($mail);
        if($response->statusCode() == 202){
            return true;
        }else{
            $this->err = '寄送Email失敗: ' . $contact['email'];
            return false;
        }


        echo '<prev>';
        echo $response->statusCode();
        print_r($response->headers());
        echo $response->body();
        echo '</prev>';
    }

    public function process_attachment($file){
        $file_encoded = base64_encode(file_get_contents($file));
        $attachment = new SendGrid\Attachment();
        $attachment->setContent($file_encoded);
        $attachment->setType("application/pdf");
        $attachment->setDisposition("attachment");
        $attachment->setFilename("order.pdf");

        return $attachment;
    }

public function send($subject, $msg, $contact, $attachment=null){

$from = new SendGrid\Email($this->sender['name'], $this->sender['email']);

$subject = $subject;

$to = new SendGrid\Email($contact['name'], $contact['email']);

$content = new SendGrid\Content("text/html", $msg);

$mail = new SendGrid\Mail($from, $subject, $to, $content);

if($attachment != false){

$att = $this->process_attachment($attachment);

$mail->addAttachment($att);

}

$apiKey = $this->sg_key;

$sg = new \SendGrid($apiKey);

$response = $sg->client->mail()->send()->post($mail);

if($response->statusCode() == 202){

return true;

}else{

$this->err = '寄送Email失敗: ' . $contact['email'];

return false;

}

echo '<prev>';

echo $response->statusCode();

print_r($response->headers());

echo $response->body();

echo '</prev>';

}

public function process_attachment($file){

$file_encoded = base64_encode(file_get_contents($file));

$attachment = new SendGrid\Attachment();

$attachment->setContent($file_encoded);

$attachment->setType("application/pdf");

$attachment->setDisposition("attachment");

$attachment->setFilename("order.pdf");

return $attachment;

}

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

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

Datatable Server Side Processing (Laravel)

Clear everything in Redis

Disable datatable warnings

SendGrid API Example