Skip to content

Instantly share code, notes, and snippets.

View jonatanrdsantos's full-sized avatar
🏠
Working from home

Jonatan Santos jonatanrdsantos

🏠
Working from home
View GitHub Profile
@jonatanrdsantos
jonatanrdsantos / 2019-https-localhost.md
Created July 16, 2020 02:36 — forked from cecilemuller/2019-https-localhost.md
How to create an HTTPS certificate for localhost domains

How to create an HTTPS certificate for localhost domains

This focuses on generating the certificates for loading local virtual hosts hosted on your computer, for development only.

Do not use self-signed certificates in production ! For online certificates, use Let's Encrypt instead (tutorial).

@jonatanrdsantos
jonatanrdsantos / magento-2-enabled-products.sql
Created September 26, 2019 15:19
Get all magento 2 enabled products, change 98 for the status attributes
SELECT `e`.*, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_entity_int` AS `at_status_default`
ON (`at_status_default`.`entity_id` = `e`.`entity_id`)
AND (`at_status_default`.`attribute_id` = '98')
AND `at_status_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_status`
ON (`at_status`.`entity_id` = `e`.`entity_id`)
AND (`at_status`.`attribute_id` = '98')
AND (`at_status`.`store_id` = 1)
@jonatanrdsantos
jonatanrdsantos / patch-magento.md
Created June 22, 2019 22:06
aplicar patch linux magento

aplicar patch magento

cp -ar patch/* .

@jonatanrdsantos
jonatanrdsantos / query-to-csv.sh
Last active September 3, 2019 14:55
Generate a csv from SQL query
sudo mysql -uroot -proot database_prod -e "select sku from catalog_product_entity;" | tr '\t' ',' > skus.csv
#!/bin/bash
# Generate sample data and trigger Magento2 performance toolkit jMeter test plan.
HOST="magento2.loc"
BASE_PATH="/"
USERS=100
RAMP_PERIOD=300
LOOPS=1
ADMIN_USER="magento2"
ADMIN_PASSWORD="magento2"
@jonatanrdsantos
jonatanrdsantos / php-magento-design-patterns.md
Created July 17, 2018 00:14
PHP Magento design pattern
  • Dependency Injection
  • Singleton
  • Builder
  • Abstract Factory
  • Factory Method
  • Decorator
  • Value Object
  • Composition
  • Strategy
  • CQRS(Command query responsibility segregation)
rsync -rave "ssh -i PEMKEYFILE.pem" /path/to/local/files/* ec2-user@EC2_INSTANCE_HOSTNAME:/path/to/remote/files
@jonatanrdsantos
jonatanrdsantos / diasUteis.php
Created October 30, 2017 19:32
Calculo de dias úteis em php
<?php
function getWorkingDays($startDate, $endDate) {
$begin = strtotime($startDate);
$end = strtotime($endDate);
if ($begin > $end) {
return 0;
}
else {
$holidays = array('01/01', '03/04', '21/04', '01/05', '07/09', '12/10', '02/11', '15/11', '25/12');
$weekends = 0;
@jonatanrdsantos
jonatanrdsantos / local.xml
Created October 21, 2017 16:13
sample local xml
<?xml version="1.0"?>
<!--
...
-->
<config>
<global>
<install>
<date><![CDATA[Sun, 28 Oct 2012 13:09:07 +0000]]></date>
</install>
<crypt>
@jonatanrdsantos
jonatanrdsantos / csv-to-varienObject.md
Last active October 17, 2016 14:26
Class To convert CSV data to Varien_Object

##Code

<?php
class Package_Module_Model_System_Config_Backend_ProcessCsv extends Varien_Object
{
    private $_csvFilePath;
    private $_headerIsValid;
    private $_validCsvHeader;
    private $_csvFileAsVarienFileCsv;
    private $_csvFileAsVarienObject;