carlosleonam

Debugging PHP with XDebug v3 inside Docker using VSCode

Assumptions / Prerequisites

• XDebug v3+ inside Docker (e.g. php:7.3-apache Docker image)
• Running Docker v20.10+
• VSCode with PHP Debug Extension (Felix Becker)
• Using Docker Compose for orchestration

Objective

carlosleonam

#!/bin/bash

ls -lad .* | grep -v "^d"

# source: https://linuxhandbook.com/display-only-hidden-files/#:~:text=To%20display%20only%20the%20hidden,%5E%20means%20%27start%20with%27.

carlosleonam

TDATAGRID - Ordenação de Coluna por Campo Relacionado

No criação do Datagrid adicionar:

$order_fk_FOR_CODIGO_FOR_NOME = new TAction(array($this, 'onReload'));
$order_fk_FOR_CODIGO_FOR_NOME->setParameter('order', 'fk_FOR_CODIGO->FOR_NOME');
$column_fk_FOR_CODIGO_FOR_NOME->setAction($order_FOR_CODIGO);

Na onReload() abaixo de:

carlosleonam

// Source: https://www.codeproject.com/Articles/1034447/Apply-CSS-Important-In-JQuery-And-CSS

$('[class="select2-disable"]').each(function () {
    this.style.setProperty('opacity', '0.5', 'important');
});

carlosleonam

/**
 * Grid 4 PHP Framework
 *
 * @author Abu Ghufran <[email protected]> - https://www.gridphp.com
 * @version 2
 * @date 20-Oct-2020
 * @license: see license.txt included in package
 */

/*

carlosleonam

Adianti Framwork - Permissions on Linux Deploy

Permissão de escrita nos diretórios da aplicação:

Write permission on application directories

Permissão nos arquivos e diretórios 775, deve ser executada em todos os arquivos do projeto.

Permission on 775 files and directories, must be set on all project files

cd /var/www/html/project/

carlosleonam

VSCODE - Resize Current Window Manually

(Stackoverflow)[https://stackoverflow.com/questions/44412233/how-to-set-window-size-and-position-in-visual-studio-code#answer-68764796]

One way I found to solve this was by using the Developer Tools Console:

Help -> Toggle Developer Tools -> Console Tab

Type:

carlosleonam

Docker - CRON - Install in running container or Dockerfile

Running Container

apt update -y
apt install -y cron
service cron start
service cron status

carlosleonam

Disable <a></a> Tag Anchor

$(document).ready(function() {
    $('a')
    .css('cursor', 'default')
    .css('text-decoration', 'none');

    $('a').on("click", function(e) {
 e.preventDefault();

carlosleonam

DROP FUNCTION IF EXISTS fn_remove_accents;
DELIMITER |
CREATE FUNCTION fn_remove_accents( textvalue VARCHAR(10000) ) RETURNS VARCHAR(10000)

BEGIN

    SET @textvalue = textvalue COLLATE utf8_general_ci;;

    -- ACCENTS
    SET @withaccents = 'ŠšŽžÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝŸÞàáâãäåæçèéêëìíîïñòóôõöøùúûüýÿþƒ';