Guest User

Untitled

a guest
Jul 17th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.69 KB | None | 0 0
  1. <div class="col-md-12 col-xs-11">
  2. <div class="page-header">
  3. <h4 align="center"><strong>Relatório de Receitas</strong></h4>
  4. </div>
  5. <form action="<?= base_url() ?>receita/pagas" method="post">
  6. <div class="row">
  7. <div class="col-md-4 col-md-offset-5" >
  8. <label>Data do recebimento entre:</label>
  9. </div>
  10. </div>
  11. <div class="row">
  12. <div class="col-md-2 col-md-offset-4" >
  13. <div id="datepicker1" class="input-group date" data-date-format="dd-mm-yyyy">
  14. <input id="dtrecinicio" class="form-control" type="text" name="dtrecinicio" required>
  15. <span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
  16. </div>
  17. <script type="text/javascript">
  18. $(function () {
  19. $("#datepicker1").datepicker({
  20. autoclose: true,
  21. todayHighlight: true,
  22. language: "pt-BR"
  23. }).dtrecinicio('update', new Date());
  24. });
  25. </script>
  26. </div>
  27. <div class="col-md-1">
  28. <label>E</label>
  29. </div>
  30. <div class="col-md-2">
  31. <div id="datepicker2" class="input-group date" data-date-format="dd-mm-yyyy">
  32. <input id="dtrecfim" class="form-control" type="text" name="dtrecfim" required>
  33. <span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span>
  34. </div>
  35. <script type="text/javascript">
  36. $(function () {
  37. $("#datepicker2").datepicker({
  38. autoclose: true,
  39. todayHighlight: true,
  40. language: "pt-BR"
  41. }).dtrecfim('update', new Date());
  42. });
  43. </script>
  44. </div>
  45. </div>
  46. <br>
  47. <br>
  48. <div class="row">
  49. <div class="col-md-10 col-xs-12">
  50. <div class="col-md-3 col-md-offset-6">
  51. <div class="form-group">
  52. <button class="btn btn-md btn-primary btn-block" type="submit">GERAR</button>
  53. </div>
  54. </div>
  55. </div>
  56. </div>
  57. <div class="row">
  58. <div class="col-md-10 col-xs-12">
  59. <div class="col-md-3 col-md-offset-6">
  60. <div class="form-group">
  61. <a class="btn btn-md btn-default btn-block hidden-print" href="<?= base_url(); ?>">CANCELAR</a>
  62. </div>
  63. </div>
  64. </div>
  65. </div>
  66. </form>
  67. </div>
  68.  
  69. function get_receitas_like() {
  70. $inicio = $this->input->post('dtrecinicio');
  71. $fim = $this->input->post('dtrecfim');
  72. // $this->db->select('*');
  73. $this->db->select_sum("valor_receita");
  74.  
  75. $this->db->where('dtrecebimento' >= $inicio);
  76. $this->db->where('dtrecebimento' <= $fim);
  77. // $this->db->where('dtrecebimento' BETWEEN AND $dtrecebimento2');
  78. // $this->db->where('dtrecebimento', $termo);
  79. return $this->db->get('receitas')->result();
  80. }
  81.  
  82. <div class="row">
  83. <div class="col-md-12">
  84. <p align="center"><font size="3" face="helvetica"><u><strong>RELATÓRIO - RECEITAS</strong></u></font></p>
  85. </div>
  86. </div>
  87. <div class="row">
  88. <div class="col-md-5 col-md-offset-4 col-xs-12">
  89. <div class="table-responsive">
  90. <table class="table table-striped">
  91. <tr class="row">
  92. <td><strong>Valor total recebido no período selecionado:</strong> R$ <?php echo number_format($receitas[0]->valor_receita,2,",","."); ?></td>
  93. </tr>
  94. <tr class="row">
  95. <td></td>
  96. <td></td>
  97. </tr>
  98. </table>
  99. </div>
  100. </div>
  101. </div>
Add Comment
Please, Sign In to add comment