I need to make a select in two tables and join them with union , until then, but I need to also get the name of the two so I can identify it in View . >
I have tried to use getTable() in each select , but it returns the e...
I have a cron that should be running every day in an hour.
$ schedule-> command ('inspire') -> dailyAt ('15: 00 ');
but it is not running
Code
<?php
namespace App\Units;
use Illuminate\Console\Scheduling\Schedule;
use Illuminat...
I have an Accounts Receivable table that has a relationship with the Customer Table and TWO relationships with a Chart of Accounts table
I searched the Eloquent documentation but did not find how I can do these two relationships with the sa...
I have a query in SQL Ansi:
select * from payments as P, receipts as R
where P.created_at < CURRENT_DATE AND P.updated_at < CURRENT_DATE AND R.created_at < CURRENT_DATE AND R.updated_at < CURRENT_DATE
Precious to perform the sa...
After the creation of cron (code below) a scan is made in the database behind altered data. I have to send an email with this data.
How can I do this ???
cron code:
<?php
namespace App\Console\Commands;
use Illuminate\Console\Command...
I have this select:
select
DISTINCT (clients.name) as nomeempresa,
payments.amount_paid as pagamento,
receipts.original_amount as recebimento
FROM
payments,
receipts,
receipt_status,
payment_status,
clients
WHERE
pay...
I'm using Laravel 5.2 and when I enter data it wants to return the last, but at the moment I want to insert and know if the operation was successful. My function in controller looks like this:
public function cadastrar(),
{
$cod...
The problem is the following, I have to bring from a select the permissions that a profile has, only the permissions are in a json field, and because if it is several permissions we have a data collection, I need to do this within a middleware:...