/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Dmed\Entities\Nota::truncate();
factory(\Dmed\Entities\Nota::class, 100)->create();
}
public function getNotaConferida($ano, $mes, $empresa)
{
if ($mes == 0) {
$notas = Nota::whereRaw('YEAR(data_emissao) = ? and cnpj_tomador = \'\' and cpf_tomador <> \'00000000000\' and empresa_id = ? and substituida = ? and situacao_id = 1', [$ano, $empresa, 0])->orderBy('cpf_tomador', 'ASC')->with('dependentes')->get();
} else {
$notas = Nota::whereRaw('YEAR(data_emissao) = ? and MONTH(data_emissao) = ? and cnpj_tomador = \'\' and cpf_tomador <> \'00000000000\' and empresa_id = ? and substituida = ? and situacao_id = 1', [$ano, $mes, $empresa, 0])->orderBy('cpf_tomador', 'ASC')->with('dependentes')->get();
}
return $notas;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Dmed\Entities\Nota::truncate();
}
