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(); }