Ir para conteúdo

wenermorais

Members
  • Total de itens

    1
  • Registro em

  • Última visita

Posts postados por wenermorais


  1. Minha necessidade é agrupar os conceitos conforme a disciplina, segue o modelo:

    inserir a descrição da imagem aqui

    Como conseguir fazer: (Não estou conseguindo agrupar em uma "disciplina", apenas. Como ficou:

    inserir a descrição da imagem aqui

     

    <?php
      function integerToRoman($integer)
      {
        $integer = intval($integer);
        $result = '';
      
        $lookup = array(
          'M'  => 1000,
          'CM' => 900,
          'D'  => 500,
          'CD' => 400,
          'C'  => 100,
          'XC' => 90,
          'L'  => 50,
          'XL' => 40,
          'X'  => 10,
          'IX' => 9,
          'V'  => 5,
          'IV' => 4,
          'I'  => 1
        );
      
        foreach($lookup as $roman => $value){
          $matches = intval($integer/$value);
          $result .= str_repeat($roman,$matches);
          $integer = $integer % $value;
        }
      
        return $result;
      }
    ?>
    
    <div id="print">
      <link rel="stylesheet" href="<?php echo base_url('assets/css/bootstrap.css'); ?>">
      <script src="assets/js/jquery-1.11.0.min.js"></script>
    
      <style>
        hr {
          display: block;
          height: 1px;
          border: 0;
          border-top: 1px solid black;
          margin: 1em 0;
          padding: 0;
        }
    
        .mt-1 {
          margin-top: 10px;
        }
    
        .border-top { border-top: 1px solid; }
        .border-left { border-left: 1px solid; }
        .border-right { border-right: 1px solid; }
        .border-bottom { border-bottom: 1px solid; }
      </style>
    
      <?php
        $class = $this->db->get_where('class', array(
          'class_id' => $class_id,
        ))->row();
        
        $section = $this->db->get_where('section', array(
          'section_id' => $section_id,
        ))->row();
    
        $teacher = $this->db->get_where('teacher', array(
          'teacher_id' => $section->teacher_id,
        ))->row();
    
        $students = $this->db->get_where('enroll', array(
          'class_id' => $class->class_id,
          'section_id' => $section->section_id,
        ))->result_array();
    
        $subjects = $this->db->get_where('subject', array(
          'section_id' => $section_id,
        ))->result_array();
    
        $signatures = $this->db->get('signatures')->result_array();
    
        $print = $this->db->get('print_settings')->row();
    
        foreach($students as $student) {
        $stu = $this->db->get_where('student', array(
          'student_id' => $student['student_id'],
        ))->row();
    
        for($i = 1; $i <= 4; $i++) {
          $exam = $this->db->get_where('exam', array(
            'exam_id' => $i,
          ))->row();
      ?>
    
      <div class="row" style="margin-top: 5px;">
        <div class="col-xs-12">
          <div class="col-xs-2" style="margin-left: 0px; padding: 0;">
            <?php
            $fName = $print->logo;
            $ext_pos = strrpos($fName, '.');
            $ext = substr($fName, $ext_pos);
            $fName = substr($fName, 0, $ext_pos);
            $fName = str_replace('.', '_', $fName) . $ext;
            $fName = preg_replace('/\s+/', '_', $fName);
            ?>
            <img src="<?= base_url('/uploads/' . $fName); ?>" width="113" height="100" /> <br />
          </div>
          <div class="col-xs-10" style="margin-left: 0px; padding: 0; line-height: 5px;">
            <p style="font-weight: 700; font-size: 1.1em;"><?= $system_name ?></p>
            <p><?= $print->name ?></p>
            <p>CNPJ: <?= $print->cnpj ?></p>
            <p>Endereço: <?= $print->address ?></p>
            <p>Bairro: <?= $print->neighborhood ?></p>
            <p>Telefone: <?= $print->phone ?> Email: <?= $print->email ?></p> <br><br>
            <p><b>Resolução</b>: <?= $print->resolution ?></p>
          </div>
        </div>
      </div>
    
      <div class="col-xs-12 mt-3">
        Professor (a): <?= $teacher->name ?>
      </div>
      <div class="col-xs-12 mt-1">
        Aluno (a): <?= $stu->name ?>
      </div>
      <div class="col-xs-4 mt-1">
        Ano/Turma: <?= $class->name ?> / <?= $section->name ?>
      </div>
      <div class="col-xs-2 mt-1">
        Ano Letivo: <?= $sessional_year ?>
      </div>
      <div class="col-xs-3 mt-1">
        Bimestre: <?= integerToRoman($i) ?>
      </div>
      <div class="col-xs-3 mt-1">
        Encerrado em: <?= $exam->comment ?>
      </div>
    
      <div class="col-xs-12">
    
        <div class="col-xs-12 text-center">
          <h4><strong><?php echo $i.'º Bimeste' ?></strong></h4>
        </div>
    
        <?php
          $curType = '';
    
          if(strpos($class->name, '1º Ano') !== false)
            $curType = '1º Ano';
          if(strpos($class->name, '2º Ano') !== false)
            $curType = '2º Ano';
    
          $conceitos = [];
    
          foreach($subjects as $subject) {
            array_push($conceitos, $this->db->get_where('learning_goals', array(
              'type' => $curType,
              'eixos' => $i.'º Bimestre',
              'subject_id' => $subject['subject_id'],
            ))->result_array());
          }
    
          $eixos = [];
          $_subjects = [];
          
          foreach($conceitos as $conceito) {
    
           if(in_array($conceito['eixos'], $eixos))
             continue;
           array_push($eixos, $conceito['eixos']);
            
                $_descs = [];
                $descs = [];
                
                foreach($subjects as $subject) {
                  array_push($_descs, $this->db->get_where('learning_goals', array(
                    'type' => $curType,                
                    'eixos' => $i.'º Bimestre',
                    'subject_id' => $subject['subject_id'],
                  ))->result_array());
                }
                  
                foreach($_descs as $_desc) {
                  foreach($_desc as $_des) {
                    array_push($descs, $_des);
                  }
                }
    
                foreach($descs as $key => $desc) {
                  $descStatus = $this->db->get_where('learning_goals_status', array(
                    'exam_id'     => $i,
                    'conceito_id' => $conceito['id'],
                    'student_id'  => $stu->student_id,
                  ))->row();
    
                  $subject = $this->db->get_where('subject', array('subject_id' => $desc['subject_id'],
                  ))->row();
    
                  $key++;
              ?>
                <div class="col-xs-11  text-center">HABILIDADES QUE A CRIANÇA DEMONSTRA EM <?= $subject->name?></div>
                <div class="col-xs-11 border-top border-bottom border-left border-right"><?= $desc['sys_id'] ?>. <?= $desc['description'] ?></div>
                <div class="col-xs-1 border-bottom border-top border-right"> <?= $descStatus->status ?></div>
            <?php
              }
            ?>
        <?php
          }
        ?>
    </div>
    
    <div class="col-xs-12 mt-3 text-center" style="padding-left: 0; padding-right: 0;">
        <div class="col-xs-6" style="margin-top: 15px">
          <hr>
          <p class="text-center"><strong><?= $teacher->name ?></strong><br>
          Professor(a)</p>
        </div>
        <div class="col-xs-6" style="margin-top: 15px">
          <hr>
          <p class="text-center"><strong><?= $signatures[2]['name'] ?></strong><br>
          <?= $signatures[2]['post'] ?></p>
        </div>
        <div class="col-xs-6" style="margin-top: 10px">
          <hr>
          <p class="text-center"><strong><?= $signatures[0]['name'] ?></strong><br>
          <?= $signatures[0]['post'] ?></p>
        </div>
        <div class="col-xs-6" style="margin-top: 10px">
          <hr>
          <p class="text-center"><strong><?php echo $this->db->get_where('parent',array('parent_id'=>$stu->parent_id))->row()->name; ?></strong><br>
          Responsável pelo(a) aluno(a)</p>
        </div>
      </div>
      <?php
        }
      }
      ?>
    </div>
    
    <script type="text/javascript">
      jQuery(document).ready(function($) {
        var elem = $('#print');
        PrintElem(elem);
        Popup(data);
    
      });
    
      function PrintElem(elem) {
        Popup($(elem).html());
      }
    
      function Popup(data) {
        var mywindow = window.open('', 'my div', 'height=400,width=600');
        mywindow.document.write('<html><head><title></title>');
        //mywindow.document.write('<link rel="stylesheet" href="assets/css/print.css" type="text/css" />');
        mywindow.document.write('</head><body >');
        //mywindow.document.write('<style>.print{border : 1px;}</style>');
        mywindow.document.write(data);
        mywindow.document.write('</body></html>');
    
        mywindow.document.close(); // necessary for IE >= 10
        mywindow.focus(); // necessary for IE >= 10
    
        mywindow.print();
        mywindow.close();
    
        return true;
      }
    </script>

     

×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.