Monthly Archives: August 2020

Make TinyMCE Disable or Readonly

Javascript

// TinyMce instance要全部Load完才能存取
$(window).load(function(){
    if (site != 'global') {
        $('.translable.global').each(function(){
            var $this = $(this);
            if($this.find('.mce-tinymce').length > 0){
                var field_name = $this.data('name');
                //tinymce.get(field_name).getBody().setAttribute('contenteditable', false);
                tinymce.get(field_name).setMode('readonly');
            }
        });
    }
});

// TinyMce instance要全部Load完才能存取

$(window).load(function(){

if (site != 'global') {

$('.translable.global').each(function(){

var $this = $(this);

if($this.find('.mce-tinymce').length > 0){

var field_name = $this.data('name');

//tinymce.get(field_name).getBody().setAttribute('contenteditable', false);

tinymce.get(field_name).setMode('readonly');

}

});

}

});

Reference:

https://stackoverflow.com/questions/13881812/make-readonly-disable-tinymce-textarea

TinyMce Get Instance

Javascript

tinymce.init({
    selector: "textarea",
    plugins: [
        "advlist autolink lists link image charmap print preview anchor",
        "searchreplace visualblocks code fullscreen",
        "insertdatetime media table contextmenu paste"
    ],
    toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image",
	setup: function (editor) {
        editor.on('init', function () {
			 this.setContent('The init function knows on which editor its called - this is for ' + editor.id);
        });
	}
});

tinymce.init({

selector: "textarea",

plugins: [

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

"searchreplace visualblocks code fullscreen",

"insertdatetime media table contextmenu paste"

setup: function (editor) {

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

this.setContent('The init function knows on which editor its called - this is for ' + editor.id);

});

}

});

HTML

<form method="post" action="dump.php">
	<textarea class='tiny-mce' name='editor1'></textarea>
    <textarea class='tiny-mce' id='editor2'></textarea>  
</form>

</form>

Reference:

https://stackoverflow.com/questions/36383626/how-do-i-get-tinymce-editor-instance-by-the-element-selector/36386886

AES Decrypt

AES/CBC/PKCS5Padding encryption

    private function decrypt($str){
        //return $this->fake_response();
        $key = '927e88094c83c6b66487da5def1';
        //$key = hash('sha256', $key);
        //logg($key);
        $key =pack('H*', hash('sha256', $key));
        $iv = array_fill(0,16,chr(0));

        $iv1=implode('',$iv);

        $output = openssl_decrypt(
            base64_decode($str), 
            "AES-256-CBC", 
            $key, 
            OPENSSL_RAW_DATA, 
            $iv1
        );

        return $output;
    }

private function decrypt($str){

//return $this->fake_response();

$key = '927e88094c83c6b66487da5def1';

//$key = hash('sha256', $key);

//logg($key);

$key =pack('H*', hash('sha256', $key));

$iv = array_fill(0,16,chr(0));

$iv1=implode('',$iv);

$output = openssl_decrypt(

base64_decode($str),

"AES-256-CBC",

$key,

OPENSSL_RAW_DATA,

$iv1

);

return $output;

}

MD5 Digest the password(REST_API_KEY) using SHA-256
iv parameter is empty
Decrypt the encrypted contents using AES/CBC/PKCS5Padding

Laravel verifycsrftoken except not working

Path issue

Example URL: http://localhost:8000/wingpay/listener

    protected $except = [
        '/aba/listener',
        '/chipmong/return/*',
        '/chipmong/listener/*',
        '/wingpay/listener/*', // Not working
        '/wingpay/listener', // Works
        '/payments/*', 
    ];

protected $except = [

'/aba/listener',

'/chipmong/return/*',

'/chipmong/listener/*',

'/wingpay/listener/*', // Not working

'/wingpay/listener', // Works

'/payments/*',

];

Reference:

https://stackoverflow.com/questions/32751063/laravel-verifycsrftoken-exception-not-working

Javascript execute twice

iframe

<!-- This src="#" will load entire page because of unknown reason -->
<iframe src="#"></iframe>

<!-- Remove src attribute -->
<iframe ></iframe>

SQL Statements to get daily Report

select DATE_FORMAT(created_on,'%Y-%m-%d') as date_label, sum(amount) as total
from summary_orders
where status = 2
and created_on >= '2019-03-25'
and created_on <= '2019-04-13'
group by date_label
order by date_label


SELECT sum(amount) as total
FROM `summary_orders`
where `campaign_id` = '150' 
and status = 2


select count(distinct user_id) as total
from summary_orders
where status = 2
and created_on >= '2019-03-25'
and created_on <= '2019-04-13'


select DATE_FORMAT(created_on,'%Y-%m-%d') as date_label, count(distinct user_id) as total
from summary_orders
where status = 2
and created_on >= '2019-03-25'
and created_on <= '2019-04-13'
group by date_label
order by date_label

select DATE_FORMAT(created_on,'%Y-%m-%d') as date_label, sum(amount) as total

from summary_orders

where status = 2

and created_on >= '2019-03-25'

and created_on <= '2019-04-13'

group by date_label

order by date_label

SELECT sum(amount) as total

FROM `summary_orders`

where `campaign_id` = '150'

and status = 2

select count(distinct user_id) as total

from summary_orders

where status = 2

and created_on >= '2019-03-25'

and created_on <= '2019-04-13'

select DATE_FORMAT(created_on,'%Y-%m-%d') as date_label, count(distinct user_id) as total

from summary_orders

where status = 2

and created_on >= '2019-03-25'

and created_on <= '2019-04-13'

group by date_label

order by date_label

jQuery Datatable reload()

Example:

    function refresh(reset_page){
        if(typeof reset_page == 'undefined'){
            reset_page = false;
        }
        datatable.ajax.reload(null, reset_page);
    }

function refresh(reset_page){

if(typeof reset_page == 'undefined'){

reset_page = false;

}

datatable.ajax.reload(null, reset_page);

}

Reference:

Transaction and lock tables in Laravel

Example

        try {
            DB::beginTransaction();
            DB::raw('LOCK TABLES order WRITE, tickets WRITE');

            //logg(count($buy_tickets) > count($sell_tickets));
            if(count($buy_tickets) > count($sell_tickets)){
                //N筆買單對1筆賣單
                $this->sell_to_N($sell_tickets[0], $buy_tickets, $product);
            }else{
                //N筆賣單對1筆買單(機率應該最高)
                $this->buy_from_N($buy_tickets[0], $sell_tickets, $product);
            }

            DB::commit();
            //DB::raw('UNLOCK TABLES');

            return true;
        } catch (\Exception $e) {
            DB::rollback();
            $this->err = '撮合失敗: ' . $e->getMessage();
            return false;
        }

try {

DB::beginTransaction();

DB::raw('LOCK TABLES order WRITE, tickets WRITE');

//logg(count($buy_tickets) > count($sell_tickets));

if(count($buy_tickets) > count($sell_tickets)){

//N筆買單對1筆賣單

$this->sell_to_N($sell_tickets[0], $buy_tickets, $product);

}else{

//N筆賣單對1筆買單(機率應該最高)

$this->buy_from_N($buy_tickets[0], $sell_tickets, $product);

}

DB::commit();

//DB::raw('UNLOCK TABLES');

return true;

} catch (\Exception $e) {

DB::rollback();

$this->err = '撮合失敗: ' . $e->getMessage();

return false;

}

Reference:

Laravel Storage Extension Issue

Script

// Origin name: video1234.mp4
$file = $req->file('video');

// Result: bin
logg($file->extension());

// Result mp4
logg($file->getClientOriginalExtension());

// Origin name: video1234.mp4

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

// Result: bin

logg($file->extension());

// Result mp4

logg($file->getClientOriginalExtension());

Get correct MIME Type

$mime_type = $file->getClientMimeType();

1	$mime_type = $file->getClientMimeType();

Reference:

Read CSV File

Don’t use phpspreadsheet to read .csv file because there could be some bugs and get incorrect result.

    private function get_value($row, $index){
        $value = mb_convert_encoding($row[$index], 'UTF-8', 'Big5');
        $value = str_replace('\'', '', $value);
        $value = trim($value);
        return $value;
    }

    public function import(Request $req){
        $file = $req->file('file');
        //logg($file->getClientOriginalName());

        $file_name = 'import_shipping_orders.csv';
        $dest = storage_path('app');
        $file->move($dest, $file_name);
        $file_path = $dest . '/' . $file_name;
        //logg($dest);

        $row_index = 1;
        $debug = false;
        if (($handle = fopen($file_path, "r")) !== FALSE) {
            while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {
                if($row_index == 1){
                    if($debug == true){
                        foreach ($row as $key => $value) {
                            echo $this->get_value($row, $key) . '<br/>';
                        }
                        exit();
                    }

                    $row_index++;
                    continue;
                }

                $order_no = $this->get_value($row, 2);
                if($order_no == false){
                    echo 'Row ' . $row_index . ' has no order no.<br/>';
                    continue;
                }

                $order = OrderM::where('order_no', $order_no)->first();
                if($order == false){
                    echo 'Row ' . $row_index . ' has no matched order.<br/>';
                    continue;
                }

                $order->process_status = 1;
                $order->ship_date = $this->get_value($row, 0);
                $order->est_date = $this->get_value($row, 1);
                $order->ship_no = $this->get_value($row, 3);
                $order->ship_note = $this->get_value($row, 6);
                $order->save();
                
                echo 'Row ' . $row_index . ' is updated successfully.<br/>';
                $row_index++;
            }
            fclose($handle);
        }

        echo 'Done';
    }

private function get_value($row, $index){

$value = mb_convert_encoding($row[$index], 'UTF-8', 'Big5');

$value = str_replace('\'', '', $value);

$value = trim($value);

return $value;

}

public function import(Request $req){

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

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

$file_name = 'import_shipping_orders.csv';

$dest = storage_path('app');

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

$file_path = $dest . '/' . $file_name;

//logg($dest);

$row_index = 1;

$debug = false;

if (($handle = fopen($file_path, "r")) !== FALSE) {

while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {

if($row_index == 1){

if($debug == true){

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

echo $this->get_value($row, $key) . '<br/>';

}

exit();

}

$row_index++;

continue;

}

$order_no = $this->get_value($row, 2);

if($order_no == false){

echo 'Row ' . $row_index . ' has no order no.<br/>';

continue;

}

$order = OrderM::where('order_no', $order_no)->first();

if($order == false){

echo 'Row ' . $row_index . ' has no matched order.<br/>';

continue;

}

$order->process_status = 1;

$order->ship_date = $this->get_value($row, 0);

$order->est_date = $this->get_value($row, 1);

$order->ship_no = $this->get_value($row, 3);

$order->ship_note = $this->get_value($row, 6);

$order->save();

echo 'Row ' . $row_index . ' is updated successfully.<br/>';

$row_index++;

}

fclose($handle);

}

echo 'Done';

}

Reference:

https://www.php.net/manual/zh/function.fgetcsv

Rex's Personal Site

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

Monthly Archives: August 2020

Make TinyMCE Disable or Readonly

TinyMce Get Instance

AES Decrypt

Laravel verifycsrftoken except not working

Javascript execute twice

SQL Statements to get daily Report

jQuery Datatable reload()

Transaction and lock tables in Laravel

Laravel Storage Extension Issue

Read CSV File