reinink

select
  first_name,
  last_name
from
  users
left join
  companies on companies.id = users.company_id
where (
    companies.name like 'TERM%' or
    first_name like 'TERM%' or

reinink

<?php

namespace App\Providers;

use Illuminate\Support\Facades\View;
use Illuminate\Support\ServiceProvider;
use Illuminate\View\Factory as ViewFactory;

class AppServiceProvider extends ServiceProvider
{

reinink

/**
 * First we will load all of this project's JavaScript dependencies which
 * includes Vue and other libraries. It is a great starting point when
 * building robust, powerful web applications using Vue and Laravel.
 */

require('./bootstrap');

window.Vue = require('vue');

reinink

<?php

	// Include the phpQuery library
	// Download at http://code.google.com/p/phpquery/
	include 'phpQuery.php';

	// Load Mike Fisher's player page on thescore.com
	$ch = curl_init();
	curl_setopt($ch, CURLOPT_URL, 'http://www.thescore.com/nhl/player_profiles/859-mike-fisher');
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

reinink

<template>
    <div>
        <label v-if="label" class="form-label" :for="`date-input-${_uid}`">{{ label }}:</label>
        <input v-bind="$attrs" class="form-input" :id="`date-input-${_uid}`" :class="{ error: error }" type="text" ref="input" :value="value" @change="change" @keyup="change">
        <div v-if="error" class="form-error">{{ error }}</div>
    </div>
</template>

<script>
import pikaday from 'pikaday'

reinink

import { createSSRApp, h } from 'vue'
import { renderToString } from '@vue/server-renderer'
import { createInertiaApp } from '@inertiajs/inertia-vue3'
import { resolvePageComponent } from 'laravel-vite-plugin/inertia-helpers';
import createServer from '@inertiajs/server'

createServer(page =>
  createInertiaApp({
    page,
    render: renderToString,

reinink

<?php

TestResponse::macro('inertiaSnapshot', function (...$keys) {
    $convertPlainValueToCode = function ($value) {
        if ($value === null) {
            return 'null';
        } elseif (is_bool($value)) {
            return $value ? 'true' : 'false';
        } elseif (is_string($value)) {
            return "'".addslashes($value)."'";

reinink

<?php

use Illuminate\Database\Eloquent\Builder as EloquentBuilder;
use Illuminate\Database\Query\Builder as QueryBuilder;
use Illuminate\Database\Query\Expression;
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    public function boot()

reinink

import { Inertia } from '@inertiajs/inertia'

document.addEventListener('click', (event) => {
  if (
    event.target.tagName.toLowerCase() === 'a' &&
    event.target.hasAttribute('inertia') &&
    !event.target.isContentEditable &&
    !event.defaultPrevented &&
    !event.shiftKey &&
    !event.ctrlKey &&

reinink

<?php

$totals = DB::table('subscribers')
    ->addSelect(DB::raw('count(*) as all'))
    ->addSelect(DB::raw("sum(case when status = 'confirmed' then 1 else 0 end) as confirmed"))
    ->addSelect(DB::raw("sum(case when status = 'unconfirmed' then 1 else 0 end) as unconfirmed"))
    ->addSelect(DB::raw("sum(case when status = 'cancelled' then 1 else 0 end) as cancelled"))
    ->addSelect(DB::raw("sum(case when status = 'bounced' then 1 else 0 end) as bounced"))
    ->addSelect(DB::raw("sum(case when status = 'inactive' then 1 else 0 end) as inactive"))
    ->get();