/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$itbi = Itbi::find($id);
$cheque = Cheque::where('cheques.processo', $itbi->processo)->get();
$deposito = Deposito::where('depositos.processo', $itbi->processo)->get();
return compact('itbi', 'cheque', 'deposito');
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$getCheques = Cheque::whereRaw("cheques.ispredated = 1 AND DATE(cheques.predated) = CURDATE() AND cheques.status_id = 4")->get();
foreach ($getCheques as $cheque) {
Cheque::where('cheques.id', $cheque->id)->update(['cheques.status_id' => 1]);
}
Log::info(count($getCheques) . " Cheques foram mudados de status de pré-datado para depositar em" . date("d/m/Y"));
$this->info("Cheques foram alterados com sucesso.");
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
if (config('notary.cheques.sendmail')) {
$cheques = Cheque::getPreDates()->get();
// Loop to send configs.
foreach (config('notary.cheques.toSend') as $config) {
// Data to send
$send = ['count' => count($cheques), 'name' => $config['name'], 'email' => $config['email'], 'pdf' => config('notary.cheques.pdf')];
$data = ['cheques' => $cheques, 'name' => $config['name']];
Mail::send('mail.chequepredated', compact('data'), function ($message) use($send, $data) {
$message->subject('Existe ' . $send['count'] . ' cheques para depósito hoje.')->from('*****@*****.**', 'Sistema Notary')->to($send['email'], $send['name']);
if ($send['pdf']) {
$name = public_path() . '/uploads/mail/cheques/' . str_random() . '.pdf';
PDF::loadView('mail.chequepredated', compact('data'))->setPaper('a4')->setOrientation('landscape')->setOption('margin-bottom', 0)->save($name);
$message->attach($name);
}
});
}
}
$this->info("Messages from pre-dated checks have been successfully sent");
}
public function getChequesByStatus($type)
{
if ($type == 0) {
return Cheque::select("cheques.id", "cheques.processo", "config_bancos.code", "config_bancos.banco", "cheques.agencia", "cheques.conta", "cheques.cheque", "cheques.valor", "cheques.nome", "cheques.cpf", "cheques.ispredated", "cheques.predated", "cheques.status_id", "config_status_cheques.status", "config_motivos.mot", "config_motivos.descricao", "cheques.obs", "users.first_name", "cheques.created_at", "cheques.updated_at")->join("config_bancos", "cheques.banco", "=", "config_bancos.code")->join("config_status_cheques", "cheques.status_id", "=", "config_status_cheques.id")->join("users", "cheques.user_id", "=", "users.id")->leftJoin("config_motivos", "cheques.mot", "=", "config_motivos.mot")->orderBy('created_at')->get();
} else {
if ($type == 1) {
return Cheque::select("cheques.id", "cheques.processo", "config_bancos.code", "config_bancos.banco", "cheques.agencia", "cheques.conta", "cheques.cheque", "cheques.valor", "cheques.nome", "cheques.cpf", "cheques.ispredated", "cheques.predated", "cheques.status_id", "config_status_cheques.status", "config_motivos.mot", "config_motivos.descricao", "cheques.obs", "users.first_name", "cheques.created_at", "cheques.updated_at")->join("config_bancos", "cheques.banco", "=", "config_bancos.code")->join("config_status_cheques", "cheques.status_id", "=", "config_status_cheques.id")->join("users", "cheques.user_id", "=", "users.id")->leftJoin("config_motivos", "cheques.mot", "=", "config_motivos.mot")->whereRaw("status_id = 1 OR status_id = 4 AND DATE(cheques.predated) = CURDATE()")->orderBy('created_at')->get();
} else {
return Cheque::select("cheques.id", "cheques.processo", "config_bancos.code", "config_bancos.banco", "cheques.agencia", "cheques.conta", "cheques.cheque", "cheques.valor", "cheques.nome", "cheques.cpf", "cheques.ispredated", "cheques.predated", "cheques.status_id", "config_status_cheques.status", "config_motivos.mot", "config_motivos.descricao", "cheques.obs", "users.first_name", "cheques.created_at", "cheques.updated_at")->join("config_bancos", "cheques.banco", "=", "config_bancos.code")->join("config_status_cheques", "cheques.status_id", "=", "config_status_cheques.id")->join("users", "cheques.user_id", "=", "users.id")->leftJoin("config_motivos", "cheques.mot", "=", "config_motivos.mot")->where('status_id', $type)->orderBy('created_at')->get();
}
}
}
public function getTodayCheque()
{
return Cheque::select("cheques.id", "cheques.processo", "config_bancos.code", "config_bancos.banco", "cheques.agencia", "cheques.conta", "cheques.cheque", "cheques.valor", "cheques.nome", "cheques.ispredated", "cheques.predated", "users.first_name")->join("config_bancos", "cheques.banco", "=", "config_bancos.code")->join("users", "cheques.user_id", "=", "users.id")->whereRaw("cheques.status_id = 1 AND DATE(cheques.created_at) = CURDATE()")->get();
}
Route::get('bancos/byCode/{code}', 'Api\\Setting\\Config\\BancosController@getBancoByCode');
// Cheques
Route::resource('cheques', 'Api\\Setting\\Config\\ChequesController');
// ITBI
Route::resource('itbis', 'Api\\Setting\\Config\\ItbisController');
// Logradouros
Route::resource('logradouros', 'Api\\Setting\\Config\\LogradourosController');
// Matriculas
Route::resource('matriculas', 'Api\\Setting\\Config\\MatriculasController');
// Motivos Cheques Devolvidos
Route::resource('motivos', 'Api\\Setting\\Config\\MotivosController');
Route::get('motivos/byMot/{mot}', 'Api\\Setting\\Config\\MotivosController@getCodeByMotivo');
});
// Users Routes
Route::resource('users', 'Api\\Users\\UserController', ['only' => ['index', 'store', 'edit', 'update']]);
Route::delete('users/{id}/{user}', 'Api\\Users\\UserController@destroy');
Route::post('users/change/password', 'Api\\Users\\UserController@postChangePassword');
Route::get('users/get/permissions', 'Api\\Users\\PermissionController@index');
});
//Teste Viewers
Route::group(['prefix' => 'test'], function () {
// url/test/birthday
Route::get('birthday', function () {
return view('mail.birthday')->with(['name' => 'Teste Birthday Name']);
});
Route::get('predate', function () {
$cheques = \App\Model\Caixa\Cheque::getPreDates()->get();
$data = ['name' => 'Maria Júlia Fernandes Neves', 'cheques' => $cheques];
return view('mail.chequepredated')->with(compact('data'));
});
});
