<?php $running_year = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description; ?>
<div class="content-w">
  <div class="os-tabs-w menu-shad">
        <div class="os-tabs-controls">
          <ul class="nav nav-tabs upper">
            <li class="nav-item">
              <a class="nav-link" href="<?php echo base_url();?>admin/attendance/"><i class="os-icon picons-thin-icon-thin-0729_student_degree_science_university_school_graduate"></i><span><?php echo get_phrase('students');?></span></a>
            </li>
            <li class="nav-item">
              <a class="nav-link" href="<?php echo base_url();?>admin/teacher_attendance/"><i class="os-icon picons-thin-icon-thin-0704_users_profile_group_couple_man_woman"></i><span><?php echo get_phrase('teachers');?></span></a>
            </li>
            <li class="nav-item">
              <a class="nav-link active" href="<?php echo base_url();?>admin/attendance_report/"><i class="os-icon picons-thin-icon-thin-0386_graph_line_chart_statistics"></i><span><?php echo get_phrase('student_attendance_report');?></span></a>
            </li>
            <li class="nav-item">
              <a class="nav-link" href="<?php echo base_url();?>admin/teacher_attendance_report/"><i class="os-icon picons-thin-icon-thin-0386_graph_line_chart_statistics"></i><span><?php echo get_phrase('teacher_attendance_report');?></span></a>
            </li>
          </ul>
        </div>
      </div>
  <div class="content-i">
    <div class="content-box">
       <div class="element-wrapper">
          <?php echo form_open(base_url() . 'admin/attendance_report_selector/', array('class' => 'form m-b')); ?>
              <div class="row">
                <div class="col-sm-4">
                  <div class="form-group"> 
                  <label class="gi" for=""><?php echo get_phrase('class');?>:</label> 
                    <select class="form-control" onchange="get_sections(this.value)" required="" name="class_id">
                      <option value=""><?php echo get_phrase('select');?></option> 
                      <?php 
                      $class = $this->db->get('class')->result_array();
                      foreach ($class as $row): ?>
                        <option value="<?php echo $row['class_id']; ?>"<?php if ($class_id == $row['class_id']) echo 'selected'; ?> ><?php echo $row['name']; ?></option>
                      <?php endforeach; ?>
                    </select> 
                  </div>
                </div>
                <div class="col-sm-3">
                  <div class="form-group"> 
                    <label class="gi" for=""><?php echo get_phrase('section');?>:</label> 
                      <select class="form-control" name="section_id" required="" id="section_holder">   
                        <option value=""><?php echo get_phrase('select');?></option>   
                        <?php 
                        $sections = $this->db->get_where('section', array('class_id' => $class_id))->result_array();
                        foreach ($sections as $row): ?>
                            <option value="<?php echo $row['section_id']; ?>"
                                    <?php if ($section_id == $row['section_id']) echo 'selected'; ?>><?php echo $row['name']; ?></option>
                        <?php endforeach; ?>
                      </select> 
                  </div>
                </div>
                <div class="col-sm-3">
                  <div class="form-group"> <label class="gi" for=""><?php echo get_phrase('month');?>:</label> 
                    <select name="month" class="form-control" id="month" onchange="show_year()">
            <?php
            for ($i = 1; $i <= 12; $i++):
                if ($i == 1)
                    $m =  get_phrase('january');
                else if ($i == 2)
                    $m = get_phrase('february');
                else if ($i == 3)
                    $m = get_phrase('march');
                else if ($i == 4)
                    $m = get_phrase('april');
                else if ($i == 5)
                    $m = get_phrase('may');
                else if ($i == 6)
                    $m = get_phrase('june');
                else if ($i == 7)
                    $m = get_phrase('july');
                else if ($i == 8)
                    $m = get_phrase('august');
                else if ($i == 9)
                    $m = get_phrase('september');
                else if ($i == 10)
                    $m = get_phrase('october');
                else if ($i == 11)
                    $m = get_phrase('november');
                else if ($i == 12)
                    $m = get_phrase('december');
                ?>
                <option value="<?php echo $i; ?>"
                      <?php if($month == $i) echo 'selected'; ?>  >
                            <?php echo $m; ?>
                </option>
                <?php
            endfor;
            ?>
        </select>
                  </div>
                </div>
                <div class="col-sm-2">
                  <div class="form-group"> <button class="btn btn-rounded btn-primary btn-upper" style="margin-top:20px" type="submit"><span><?php echo get_phrase('generate');?></span></button></div>
                </div>
              </div>
                <input type="hidden" name="year" value="<?php echo $running_year;?>">
            <?php echo form_close();?>
            <?php if ($class_id != '' && $section_id != '' && $month != ''): ?>
            <div class="element-box lined-primary shadow">
              <div class="row">
                <div class="col-7 text-left">
                  <h5 class="form-header"><?php 
                     if ($month == 1)  {$mo = get_phrase('january');}
                else if ($month == 2)  {$mo = get_phrase('february');}
                else if ($month == 3)  {$mo = get_phrase('march');}
                else if ($month == 4)  {$mo = get_phrase('april');}
                else if ($month == 5)  {$mo = get_phrase('may');}
                else if ($month == 6)  {$mo = get_phrase('june');}
                else if ($month == 7)  {$mo = get_phrase('july');}
                else if ($month == 8)  {$mo = get_phrase('august');}
                else if ($month == 9)  {$mo = get_phrase('september');}
                else if ($month == 10) {$mo = get_phrase('october');}
                else if ($month == 11) {$mo = get_phrase('november');}
                else if ($month == 12) {$mo = get_phrase('december');} echo $mo;?></h5></div>
              </div>
              <div class="table-responsive">
                <table class="table table-sm table-lightborder">
                  <thead>
                    <tr class="text-center" height="50px">
                      <th class="text-left"> <?php echo get_phrase('student');?> </th>
                      <?php
                            $year = explode('-', $running_year);
                            $days = cal_days_in_month(CAL_GREGORIAN, $month, $year[0]);
                            for ($i = 1; $i <= $days; $i++) 
                        {
                        ?>
                            <td style="text-align: center;"><?php echo $i; ?></td>
                        <?php } ?>
                    </tr>
                  </thead>
                  <tbody>
                  <?php $data = array();
                            $students = $this->db->get_where('enroll', array('class_id' => $class_id, 'year' => $running_year, 'section_id' => $section_id))->result_array();
                            foreach ($students as $row): ?>
                    <tr>
                      <td nowrap> <img alt="" src="<?php echo $this->crud_model->get_image_url('student',$row['student_id']);?>" width="20px" style="border-radius:20px;margin-right:5px;"> <?php echo $this->db->get_where('student', array('student_id' => $row['student_id']))->row()->name; ?> </td>
                        <?php
                                $status = 0;
                                for ($i = 1; $i <= $days; $i++) 
                                {
                                    $timestamps = strtotime($i . '-' . $month . '-' . $year[0]);
                                    $this->db->group_by('timestamp');
                                    $attendance = $this->db->get_where('attendance', array('section_id' => $section_id, 'class_id' => $class_id, 'year' => $running_year, 'timestamp' => $timestamps, 'student_id' => $row['student_id']))->result_array();
                                    foreach ($attendance as $row1):
                                    $month_dummy = date('d', $row1['timestamp']);
                                    if ($i == $month_dummy)
                                    $status = $row1['status']; 
                                    endforeach;?>
                           <td class="text-center">
                            <?php if ($status == 1) { ?>
                                <div class="status-pilli green" data-title="Present" data-toggle="tooltip"></div>
                            <?php  } if($status == 2)  { ?>
                                        <div class="status-pilli red" data-title="Absent" data-toggle="tooltip"></div>
                            <?php  } if($status == 3)  { ?>
                                        <div class="status-pilli yellow" data-title="Late" data-toggle="tooltip"></div>
                             <?php  } $status =0;?>
                      </td>
                      <?php } ?>
                    <?php endforeach; ?>
                    </tr>                 
                  </tbody>
                </table>
              </div>
            </div>
            <?php endif;?>
          </div>
        </div>
      </div>
    </div>

<script type="text/javascript">
       function get_sections(class_id) 
   {
      $.ajax({
            url: '<?php echo base_url();?>admin/get_class_section/' + class_id ,
            success: function(response)
            {
                jQuery('#section_holder').html(response);
            }
        });
   }
</script>