jzpeepz

trait HasTablePrefix
{
    public function getTable()
    {
        return $this->getPrefix() . parent::getTable();
    }

    public function setTable($table)
    {
        if (substr($table, 0, strlen($this->getPrefix())) == $this->getPrefix()) {

jzpeepz

elseif (@$data['user_id'] && @$data['only_open'] === true) {
    $query = DiscordSupportTickets::where('user_id', '=', $data['user_id'])
        ->where('open', '=', 1);
        ->orderBy('ticket', 'DESC')
        ->get();
}

jzpeepz

<?php

namespace App\Relations;

use App\Product;
use App\Special;
use Illuminate\Support\Facades\DB;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Relations\Relation;

jzpeepz

Revert to the specific revision using git reset

The solution comes from the Revert to a commit by a SHA hash in Git? question. Here we first hard reset the state of the repository to some previous revision and then soft reset back to current state. The soft reset will keep file modifications, so it will bring old state back on top of the current state:

Careful, reset —hard will remove non-commited changes

$ git reset —hard 0682c06  # Use the SHA1 of the revision you want to revert to HEAD is now at 0682c06 G3
$ git reset —soft HEAD@{1}
$ git commit -m “Reverting to the state of the project at 0682c06”

jzpeepz

<?php declare(strict_types=1);

require __DIR__.'/vendor/autoload.php';

lambda(function (array $event) {
    return 'Hello ' . ($event['name'] ?? 'world');
});

jzpeepz

<?php

// Note: Adding 1 to the dates below accounts for
// diffences between PHP date('z') [starts at zero]
// and MySQL DAYOFYEAR [starts at 1]

// Want to use specific start and end date?
$start = date('z', strtotime('12/1/2021')) + 1;
$end = date('z', strtotime('1/30/2022')) + 1;

jzpeepz

<?php

class GoogleDoc {

    public function __construct($docId, $sheetId = 1)
    {
        $this->docId = $docId;
        $this->sheetId = $sheetId;

        $this->json = file_get_contents('https://spreadsheets.google.com/feeds/list/' . $docId . '/' . $sheetId . '/public/values?alt=json');