Laravel Cheetsheet - Jack

<?php

    public $timestamps = false;   // if dont want to timetamps
    protected $table = 'temp_interviewees';
    protected $fillable = ['greetings',''];
    protected $hidden = [    ];

    Bootstrap - buttons typs - https://getbootstrap.com/docs/4.0/components/buttons/
--------------------------- Commit transaction ---------------------------------
try{
    DB::beginTransaction();
    .....
    process your data
    ..... 
    DB::commit();
} catch (\Exception $e) {
    DB::rollback();
    return $this->sendError('Something went wrong.', [], 422);
}

---->Gmail SMTP
    -> Go to google
    -> 2 step on
    -> go to 2Step module
    -> find app password

    update env file
        MAIL_MAILER=smtp
        MAIL_HOST=smtp.gmail.com
        MAIL_PORT=465
        MAIL_USERNAME=noreply.23423423@gmail.com
        MAIL_PASSWORD=342343432c234234
        MAIL_ENCRYPTION=tls
        MAIL_FROM_ADDRESS=noreply.23423423@gmail.com
        MAIL_FROM_NAME="Jack"
--------------------------------------------------------------
----> Testing email service is working or not
    Route::get('/test-mail', function () {
        try {
            Mail::raw('Test Email!', function ($message) {
                $message->to('jatin@gmail.com')->subject('Testing mails');
            });
            echo "Sent...";
        } catch(Exception $e) {
            echo $e->getMessage();
        }
        dd('test mail');
    });     

growl("@lang('boilerplate::chatbottemplate.list.deletesuccess')", "success");
growl("@lang('boilerplate::chatbottemplate.list.deleteerror')", "error");

--------------  Making visible or hidden attributes from Eloquent temporarily ----

$users = $users->makeVisible(['address', 'phone_number']);
$users = $users->makeHidden(['address', 'phone_number']);

------------------------- update current timestamps - migration - --------
$table->timestamp('created_at')->useCurrent();
$table->timestamp('updated_at')->useCurrent()->useCurrentOnUpdate();
----------------------- Download Image from url -----------------------

var download_url = "image_url_link_paste_here.jpg";

fetch(download_url)
.then(res => res.blob())
.then(blob => {
    console.log(blob);
    var url = window.URL || window.webkitURL;
    var link =url.createObjectURL(blob);
                        var a = $("<a />");
        var file_name = download_url.split('/').pop()
                        a.attr("download", file_name);
                        a.attr("href", link);
                        $("body").append(a);
                        a[0].click();
                        $("body").remove(a);
});

------------ Datatable ordering remove/false -------

"ordering": false,

--------------------  datatable - ajax callback get -------------------------

ajax: {
    url: '{!! route('boilerplate.users.datatable') !!}',
    type: 'post',
    dataSrc: function(d){
        closeSwalWhilePageLoaded();
        return d.data;
    }
},

------------------------------
chromium Puppettier - cheet sheet
//https://stackoverflow.com/questions/59112956/cant-use-puppeteer-error-failed-to-launch-chrome

sudo apt install -y gconf-service libasound2 libatk1.0-0 libc6 libcairo2 libcups2 libdbus-1-3 libexpat1 libfontconfig1 libgcc1 libgconf-2-4 libgdk-pixbuf2.0-0 libglib2.0-0 libgtk-3-0 libnspr4 libpango-1.0-0 libpangocairo-1.0-0 libstdc++6 libx11-6 libx11-xcb1 libxcb1 libxcomposite1 libxcursor1 libxdamage1 libxext6 libxfixes3 libxi6 libxrandr2 libxrender1 libxss1 libxtst6 ca-certificates fonts-liberation libappindicator1 libnss3 lsb-release xdg-utils wget


---------------------- Cloning mysql database ----------

1>  sudo mysql -> create database new_db_name;  //create new database
2>  mysqldump old_db_name | mysql new_db_name  // single command - mysql dump and copy to new db


--------------------- mysql dump of load from existing db --------

1>  sudo mysql -> create database new_db_name;   //create new database
2>  mysql new_db_name --force < db_name.sql     //clone database from file


--------------------Generate random token ----------------------------

$token = (string) Str::uuid();

------------------ Call another controller method --------------------------

//Calling a method that is from the OtherController.
$result = (new OtherController)->method();


---------------- date format converstion model -----------


protected $casts = [
    'purchase_order_date'  => 'date:d-m-Y',
];

--------------------- Laravel Javascipt jquery - route - with parameter generate  -----------

var url = '{{ route("admin.stocks.edit", ":id") }}';
url = url.replace(':id', stock.id);


------------ Appdend Dynmic options ------------

$(this).append($('<option>', {value: que_id, text: col_name}));

----------------- datatable - defauly length - 50 ----------
"iDisplayLength": 50,


------------index of array jquery -------------
var index = array.indexOf(item);
if (index !== -1) {
  array.splice(index, 1);
}
-------------- Get MultiCHeckbox Value -----------------

var multicheck_box_array =  document.getElementsByName("choice_ans_list_457[]");
var multicheck_boxes_length = chk_arr.length;             

for(k=0;k< multicheck_boxes_length;k++)
{
    if(multicheck_box_array[k].checked){
        console.log(multicheck_box_array[k].value);
    }
}

------------- object length find --------------------

Object.keys(found_que_info_object.data).length;

---------------- Carbon now --------------------
    Carbon::now()->format('Y-m-d H:i:s') -> 2021-12-27 00:00:00
    Carbon::now()->toTimeString()   // 12:50:30

----------------------------------- Create laravel project with version -----------------

composer create-project laravel/laravel="5.6.*" dragAndDrop  --prefer-dist


------------ check select value present or not --------------------------------------------

var exists = 0 != $('#select-box option[value='+ 5 +']').length;

--------------- Laravel Drag And Drop --------------------------

1. Datatable -> //https://www.nicesnippets.com/blog/laravel-6-drag-and-drop-datatable-rows-for-sorting-example
2. ul/li -> //https://www.nicesnippets.com/blog/drag-and-droppable-cards-using-laravel-6-jquery-ui-example

-------------------------- time replacement carbon --------------

    //greeting message time replacement
    $replace_greeting_time = Carbon::now();
    $replace_greeting_time = $replace_greeting_time->format('h:i a');

----------------- whereIn query - get result by id order maintain -----------

$ids_ordered = implode(',', $templateQuestionIds);
$chatbotQuestions = ChatbotQuestion::whereIn('id', $templateQuestionIds)
                    ->orderByRaw("FIELD(id, $ids_ordered)")   // this line is magic
                    ->with('type')
                    ->get();


------------------------ Select2 Title issue fixes - jquery UI -------------------------------

    //removem title on hover - jquery UI changes - its showing title as tooltip so
    $(document).on('mouseenter', '.select2-selection__rendered', function () {
         $(this).removeAttr('title');
    });

------------------ Datatable - DEfault Value showcase - if its null -------------------------

        "columnDefs": [{
            "defaultContent": "-",
            "targets": "_all"
        }],

-------------- updateOrCreate (first array -> match condtion -> 2nd value input) ------------------------------
        $chatbotQuestion = ChatbotQuestion::updateOrCreate([
                            'chatbot_id' => $input['chatbot_id'],
                            'question_type_id' => $input['question_type_id']
                        ], $input);
        
---------------------- Validator message change laravel validate ----------------
    
    $customMessages = [
            'url.required' => 'Url is required',
            'recovery_code' => 'required|exists:users,email_recovery_code',
            'email' => 'required|email|unique:users,email',
            // 'date.required'=>'Date is required',
    ];
    $this->validate($request, ['url' => 'required'], $customMessages);

-------------- find index from jquery array - by key name ----------------
    findWithAttr(question_type_list, 'id', 'asd');
    function findWithAttr(array, attr, value) {
        for(var i = 0; i < array.length; i += 1) {
            if(array[i][attr] === value) {
                return i;
            }
        }
        return -1;
    }


---------Select Onchange---------------------------

    $( "#filter_id" ).change(function() {
        console.log(this.value);
    });

---------formdata - image upload with data---------

    var formData = new FormData();
    formData.append('question_text', $('input[name=question_text]').val());

    if($('input[name=corona_image]')[0].files[0]){
          formData.append('corona_image', $('input[name=corona_image]')[0].files[0]);
    }else{
        alertify.error('Please Upload Your Corona Sample Image', 5, function(){  console.log('dismissed'); });
        return true;
    }

    $.ajax({
        type: "POST",
        url: '{{ route("boilerplate.chatbots-questions.store") }}',
        data: formData,
        processData: false,  // tell jQuery not to process the data
        contentType: false,  // tell jQuery not to set contentType,
        dataType: "json",
        success: function(data) {

        },
        error: function(xhr){
            }
    });

----------------------- Store Image to Storage ----------------------------------------

    $attachment = isset($input["image"]) ? $input["image"] : "";
    if (!empty($attachment)) {
        // $file = $input->file('corona_image');
        $attachment_name = 'sample_' . Carbon::now()->timestamp . str_random(2) . '_' . $attachment->getClientOriginalName();
        $destinationPath = storage_path('app/public');
        $attachment->move($destinationPath, $attachment_name);
        unset($input["image"]);
        //image related paths
        $filePath = url('storage/'.$attachment_name); // 127.00.00.0:8000/..../jack.jpeg
        $input['image_path'] = $attachment_name; //jack.jpeg
        $input['filepath'] = storage_path('app/public/' .$attachment_name); //var/www/html ....
    }
----------------------------------  Enter click keyboard  - click on button    ------------------------------

    $(document).on('keypress',function(e) {
        console.log(e.target);
        if(e.which == 13) {
            e.preventDefault();
            if(e.target.id == 'question_text' || e.target.id == 'question_error_text') {
                $(".save_new_question").click();
            }else if(e.target.id == 'reference_link_text'){
                $(".btn-save-reference").click();
            }
            console.log('perssed');
        }
    });
    -------------------------- add 1st column as Index number - 1,2,3..... ----------------------------------

    oTable.on( 'order.doTable search.dt', function () {
        oTable.column(0, {search:'applied', order:'applied'}).nodes().each( function (cell, i) {
            cell.innerHTML = i+1;
        } );
    } ).draw();

    -------------------------- Subquery with child table (whereHas)--------------------

    $last_sequence_number = ChatbotQuestion::where('chatbot_id', $request->chatbot_id)
                    ->whereHas('type', function ($query) {
                        $query->where('key_name', 'email_phone');
                    })->pluck('sequence_order')->toArray();

    $users = $students = User::whereHas(
            'roles', function($q){
                $q->where('name', 'company_user');
            }
        )->get();

    --------------------- Find index of column --------------------------

    $questionTypes = QuestionType::all();
    $greetingsColumnIndex = ($questionTypes->where('key_name', 'greetings')->pluck('id')->toArray())[0];


    -------------------- Javscript chat time convert like 1:24 PM, 10:40 AM ------------

        function tConvert (tim_val) {
            try {
                // Check correct time format and split into components
                time = tim_val.toString ().match (/^([01]\d|2[0-3])(:)([0-5]\d)(:[0-5]\d)?$/) || [tim_val];

                if (time.length > 1) { // If time format correct
                    time = time.slice (1);  // Remove full string match value
                    time[5] = +time[0] < 12 ? 'AM' : 'PM'; // Set AM/PM
                    time[0] = +time[0] % 12 || 12; // Adjust hours
                }
                time[3] = ' ';  // removed seconds - if want then remove this
                return time.join (''); // return adjusted time or original string
            } catch (error) {
                return time.substring(0, 5);
            }
        }

----------------------- Query Paramter Search - Javascript -----------------------

        const urlSearchParams = new URLSearchParams(window.location.search);
        const params = Object.fromEntries(urlSearchParams.entries());
        if (typeof(params.id) != 'undefined') {
            dataTableFetchRoute += '?id=' + params.id;
        }        

?>