Category Archives: Web Tools

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;

}

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

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

Rex's Personal Site

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

Category Archives: Web Tools

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:

Datatable Server Side Processing (Laravel)

Clear everything in Redis