vasilii-b

select
    cae.entity_id as "Address ID",
	cae.parent_id as "Customer ID",
	c.firstname,
	c.lastname,
	c.email,
	cae.country_id,
	cae.city,
	cae.postcode,
	cae.region as "Current Address Region",

vasilii-b

select cpe_parent.entity_id as 'Parent ID', cpe_parent.sku as 'Parent Sku', count(cpe_child.entity_id) as 'Child #', cpe_child.sku as 'Child Sku'
from catalog_product_entity cpe_parent
join catalog_product_link cpl on cpe_parent.type_id = 'grouped' and cpl.link_type_id = 3 and cpe_parent.row_id = cpl.product_id
left join catalog_product_entity cpe_child on cpl.linked_product_id = cpe_child.entity_id
group by cpe_parent.sku
order by 'Child #' DESC

vasilii-b

source: https://savedlog.com/uncategorized/letsencrypt-ssl-certificate-namecheap-hosting/

The “Positive SSL” certificate I bought along with my domain is invalid with any of my subdomains and cannot be used with wildcards. One annoying thing is that namecheap doesn’t offer auto installation of free let’s encrypt certificates, even though, they are saying “Namecheap is dedicated to data security and privacy for all internet users. We believe the movement to encrypt nearly all web traffic is a positive direction. As more sites embrace HTTPS and use of security products, providers of free SSL are beginning to come online.”

Let me show you what it needs to be done in order to “encrypt nearly all web traffic”.

First, not required but it’s helpful to enable ssh access, it is not enabled by default on the base hosting plans, just go an start a live chat and request ssh access.

vasilii-b

Magepal GA4 <> Klevu Search using JS Templating

The files mentioned in the gist are supposed to be added under a custom theme (app/design/frontend/<vendor>/theme) inside the folder Klevu_Search.

Alternatively, the same could be achieved by having the files (layouts, templates) inside a custom module.

vasilii-b

df -h | grep 'mysql\|Filesystem'

vasilii-b

SELECT table_schema "Data Base Name",
    SUM( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    SUM( data_free )/ 1024 / 1024 "Free Space in MB"
    FROM information_schema.TABLES
    GROUP BY table_schema;

vasilii-b

<?php

namespace ImaginationMedia\CaspianFrontend\ViewModel;

use Magento\Framework\Pricing\PriceCurrencyInterface;
use Magento\Framework\View\Element\Block\ArgumentInterface;

/**
 * Class FormatPriceViewModel
 */

vasilii-b

bin/magento mod:st | grep SampleData | xargs -0 sh -c 'for name; do bin/magento mod:e $name; done' sh

vasilii-b

find ./ -name "*.css" -exec sh -c 'mv "$1" "${1%.css}.txt"' _ {} \;

vasilii-b

const config = await configureWebpack({
    [...]
    devServer: {
        stats: 'errors-warnings'
    }
});