Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div class="col-md-12 col-xs-11">
- <div class="page-header">
- <h4 align="center"><strong>Relatório de Receitas</strong></h4>
- </div>
- <form action="<?= base_url() ?>receita/pagas" method="post">
- <div class="row">
- <div class="col-md-4 col-md-offset-5" >
- <label>Data do recebimento entre:</label>
- </div>
- </div>
- <div class="row">
- <div class="col-md-2 col-md-offset-4" >
- <div id="datepicker1" class="input-group date" data-date-format="dd-mm-yyyy">
- <input id="dtrecinicio" class="form-control" type="text" name="dtrecinicio" required>
- <span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
- </div>
- <script type="text/javascript">
- $(function () {
- $("#datepicker1").datepicker({
- autoclose: true,
- todayHighlight: true,
- language: "pt-BR"
- }).dtrecinicio('update', new Date());
- });
- </script>
- </div>
- <div class="col-md-1">
- <label>E</label>
- </div>
- <div class="col-md-2">
- <div id="datepicker2" class="input-group date" data-date-format="dd-mm-yyyy">
- <input id="dtrecfim" class="form-control" type="text" name="dtrecfim" required>
- <span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
- </div>
- <script type="text/javascript">
- $(function () {
- $("#datepicker2").datepicker({
- autoclose: true,
- todayHighlight: true,
- language: "pt-BR"
- }).dtrecfim('update', new Date());
- });
- </script>
- </div>
- </div>
- <br>
- <br>
- <div class="row">
- <div class="col-md-10 col-xs-12">
- <div class="col-md-3 col-md-offset-6">
- <div class="form-group">
- <button class="btn btn-md btn-primary btn-block" type="submit">GERAR</button>
- </div>
- </div>
- </div>
- </div>
- <div class="row">
- <div class="col-md-10 col-xs-12">
- <div class="col-md-3 col-md-offset-6">
- <div class="form-group">
- <a class="btn btn-md btn-default btn-block hidden-print" href="<?= base_url(); ?>">CANCELAR</a>
- </div>
- </div>
- </div>
- </div>
- </form>
- </div>
- function get_receitas_like() {
- $inicio = $this->input->post('dtrecinicio');
- $fim = $this->input->post('dtrecfim');
- // $this->db->select('*');
- $this->db->select_sum("valor_receita");
- $this->db->where('dtrecebimento' >= $inicio);
- $this->db->where('dtrecebimento' <= $fim);
- // $this->db->where('dtrecebimento' BETWEEN AND $dtrecebimento2');
- // $this->db->where('dtrecebimento', $termo);
- return $this->db->get('receitas')->result();
- }
- <div class="row">
- <div class="col-md-12">
- <p align="center"><font size="3" face="helvetica"><u><strong>RELATÓRIO - RECEITAS</strong></u></font></p>
- </div>
- </div>
- <div class="row">
- <div class="col-md-5 col-md-offset-4 col-xs-12">
- <div class="table-responsive">
- <table class="table table-striped">
- <tr class="row">
- <td><strong>Valor total recebido no período selecionado:</strong> R$ <?php echo number_format($receitas[0]->valor_receita,2,",","."); ?></td>
- </tr>
- <tr class="row">
- <td></td>
- <td></td>
- </tr>
- </table>
- </div>
- </div>
- </div>
Add Comment
Please, Sign In to add comment