nklatt

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
# ...
SET sql_mode=(SELECT CONCAT(@@sql_mode,',ONLY_FULL_GROUP_BY'));

nklatt

<input pattern="/^(?:(\d+\/[1-9]\d*)|(\d*(?:(\s\d+\/[1-9]\d*)|\.\d+)?))$/">
<!--
(?: => non-capturing group, EITHER
  (\d+\/[1-9]\d*) => any number of digits followed by a slash then any number of digits not beginning with 0 (fraction)
  | => OR
  (\d*(?: => zero or more digits followed by non-capturing group, EITHER
    (
      \s => a space
      \d+ => any number of digits
      \/ => a slash

nklatt

Site allows members (people) to register for programs. People belong to one or
more Accounts. Programs are divided up into Seasons.

When viewing the entity list page for Accounts, we want to be able to filter the
list based on the seasons the people within each account are registered for.
E.g., we often want to show only Accounts which have People registered for
Programs within the current Season.

Pertinent database tables and columns:
accounts: id

nklatt

$table = 'some_table';
$columns = implode(',', array(
	'title',
	'description',
	'etc...',
));
$sql = '
	INSERT INTO '.$some_table.' (product_id, '.$columns.')
	SELECT "'.$destId.'", '.$columns.'
	FROM '.$some_table.' WHERE product_id = "'.$origId->id.'"

nklatt

<?php
$status = 500; // if we don't change this then the problem is this code
$result = array();

if (empty($_FILES['file']['tmp_name'])) {
    $status = 400;
    $result['message'] = 'No file found.';
} else if (empty($_FILES['file']['name'])) {
    $status = 400;
    $result['message'] = 'No file name found.';

nklatt

I needed a way to check the value of a product attribute so whipped up this
little command line interface tool to do it. It accepts a SKU and a product
attribute code and outputs the value of that attribute for that product.

nklatt

<?php
namespace Company\Module\Console\Command;

// How to iterate through pages of products in Magento 2 (specifically tested with version 2.3.5-p2) using a
// Product CollectionFactory. This specific example is for a console command that maintains that products that
// meet a certain set of criteria are in the Clearance category. It also happens to show how to include stock
// quantity information with the products.

use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Helper\ProgressBar;

nklatt

We have a client that ships from multiple warehouses using zones to determine
pricing. They maintain the zones in a Goole Maps document. We are creating a
front end that clients can enter their address and we'll show them what their
shipping options are. We will have the client export their zones as a KML
file and we'll import it into a MySQL database and use ST_Contains to find
the shipping zone(s) customers are in. (They can only be in one zone for any
given warehouse but may be within range of multiple warehouses.)

One thing to point out is there is confusion about the order of latitude and
longitude. Mathematically, it is naturally ordered "longitude, latitude" but

nklatt

use Concrete\Core\Entity\File\File;
use Concrete\Core\File\Set\Set as FileSet;
use Concrete\Core\File\StorageLocation\StorageLocationFactory as FileStorageLocationFactory;
use Concrete\Core\Permission\Access\Entity\GroupEntity as GroupPermissionAccessEntity;
use Concrete\Core\Permission\Access\Entity\UserEntity as UserPermissionAccessEntity;
use Concrete\Core\Support\Facade\Application;
use Concrete\Core\User\Group\Group as UserGroup;

use PermissionKey;
use UserInfo;

nklatt

<?php
defined('STDIN') or die(_("Access Denied. CLI Only"));

// execute from the command line: php <path to magento root>/cli/create_attributes.php

require __DIR__.'/../app/bootstrap.php'; // assuming this file is in /cli under the root magento dir

$bootstrap = \Magento\Framework\App\Bootstrap::create(BP, $_SERVER);
$installer = $bootstrap->getObjectManager()->create('Magento\Catalog\Setup\CategorySetup');
$objectManager = $bootstrap->getObjectManager();