<html>
    <head>
        <title><?php echo $b_header['title']; ?></title>
        <style>
            @media print
            {
                * {-webkit-print-color-adjust:exact;}
                @page {margin:0.15in 0.10in 0in 0in; }
                .super_container
                {
                    page-break-after: always;
                    margin-top:0.25in;
                    position:relative;
                    width:100vw;
                    height:710px;
                }
            }
            body {margin: 0.25in 0.25in 0.63in 0.25in; box-sizing:border-box;width:100vw; height:100vh;padding-bottom:0.63in;}
            *{margin:0;padding:0;font-family:calibri;}
            .clear:after{content:"";clear:both;display:block;}
            .left{float:left;}
            .right{float:right;}
            .wd-10{width:10%;}
            .wd-20{width:20%;}
            .wd-30{width:30%;}
            .wd-40{width:40%;}
            .wd-50{width:50%;}
            .wd-60{width:60%;}
            .wd-70{width:70%;}
            .wd-80{width:80%;}
            .wd-90{width:90%;}
            .wd-100{width:100%;}
            .wd-15{width:15%;}
            .wd-25{width:25%;}
            .wd-35{width:35%;}
            .wd-45{width:45%;}
            .wd-55{width:55%;}
            .wd-65{width:65%;}
            .wd-75{width:75%;}
            .wd-85{width:85%;}
            .wd-95{width:95%;}
            .wd-100{width:100%;}
            .title{font-size:35px;}
            .super_container
            {
                margin-bottom:200px;
                position:relative;
                width:100vw;
                height:710px;
            }
            .wrapper{
                border:4px transparent #18a05e;
               
                outline-offset: 5px;
                box-sizing: border-box;
                padding:5px;
            }
            .super_wrapper
            {
                position:absolute;
                top:0;
                left:0;
                width:100%;
                z-index:120;
                margin:0;
                padding:0;
            }
            /*.watermark*/
            /*{*/
            /*    height:200px;*/
            /*    width:300px;*/
            /*    margin:auto;*/
            /*    padding-top:50px;*/
            /*    padding-left:100px;*/
            /*    opacity:0.1;*/
            /*    background:url("<?php echo base_url().$b_header['logo1']; ?>");*/
            /*    background-size:100% 100%;*/
            /*}*/
            /*.watermark_wrapper*/
            /*{*/
            /*    height:470px;*/
            /*    width:100%;*/
            /*    margin-top:50px;*/
            /*    display:inline-flex;*/
            /*    display:-webkit-inline-flex;*/
            /* }*/
            .wrapper.left2{
                width: calc(90vw);
                margin-right: 20px;
                margin-left: 20px;
            }
            h1,h2,h3{
                color:#5A7BC1;
                font-family:calibri;
                text-align:center;
            }
            .boxed{color:#000000;width:80%;margin:0 auto;}
            .header{
                width:100%;
                border-bottom:4px solid #5A7BC1;            
            }
            .body{
                padding:10px;
            }
            .row{
                width:100%;
                margin: 0px auto;  
            }
            .text-center{text-align:center;}
            .bold{font-weight:bold;}
            .b-u-l{
                border-bottom: 1px solid #000;
                height:inherit;
            }
            .x-small{
                font-size: 12px;
            }
            .x-x-small{
                font-size: 9px;
            }
            .page_break{
                width: 100vw;
                height: 100vh;
                padding: 10px 0px;
                box-sizing: border-box;
            }
            .tbl1
            {
                border: 1px solid #000;
                text-align:center;
                width:100%;
                min-height:20px;
            }
            th{
                border: 1px solid #000;
                  border-right: 0px;
                border-bottom: 0px; 
                background-color:#ccccb3; 
                padding: 3px !important;
            }
            td{
                border: 1px solid #000;
                text-align: left;
                  border-right: 0px;
                border-bottom: 0px; 
                padding: 2px !important;
            }
            .normal{
                font-weight: normal !important;
            }
            .text-right{
                text-align: right !important;
            }
            .text-left{
                text-align: left !important;
            }
            .margin-a{margin: 30px auto 0px auto;}
        </style>
    </head>
    <body class="clear">
        <?php date_default_timezone_set("Asia/Karachi"); ?>
        <div class="super_container">
            <div class="page_break clear">
                <div class="watermark_wrapper">
                    <div class="watermark"></div>
                </div>
                <div class="super_wrapper">
                    <div class="wrapper left2 left">
                        <div class="header">
                            <div class="wd-100 clear">
                                <div class=" text-left left ">
                                    <img src="<?php echo base_url().$b_header['logo1']; ?>" style="width:50px;height:50px;">
                                </div>
                                <div class=" text-left right ">
                                    <img src="<?php echo base_url().$b_header['logo2']; ?>" style="width:50px;height:50px;">
                                </div>
                                <div style="">
                                    <center><h1><?php echo $b_header['title']; ?></h1></center>
                                    <center><h3 style="color:#000 !important;"><i><?php echo $b_header['tagline']; ?></i></h3></center>
                                    <center><i><h3 style="color:#000 !important;font-weight:normal;"><?php echo $b_header['short_address']; ?></h3></i></center>
                                    <center><h3 class="boxed" style="margin-top:0px !important;font-size:23px;">Advance History</h3></center>
                                </div>
                            </div>
                            <div class="wd-100 clear">
 
                                <div class="wd-20 left" style="margin-bottom:15px;margin-left:300px">
                                    <h2>Name</h2>
                                </div>
                                 <div class="wd-20 right" style="margin-bottom:15px;margin-right:200px">
                         <h3>
                         <?php 
                         if($advnc[0]['type']=="teacher")
                         {
                              $nam=$this->db->select('*')
                                            ->from('teacher')
                                            ->where('id',$advnc[0]['bothid'])
                                            ->get()->row();
                                     echo $nam->firstname.$nam->lastname;       
                         }else
                         {
                                  $nam=$this->db->select('*')
                                            ->from('staff')
                                            ->where('id',$advnc[0]['bothid'])
                                            ->get()->row();
                                     echo $nam->firstname.$nam->lastname;  
                         }
                         ?>
                         </h3>
                                </div>
                            </div>
                             <div class="wd-100 clear">
 
                                <div class="wd-20 left" style="margin-bottom:15px;margin-left:300px">
                                    <h2>Designation</h2>
                                </div>
                                 <div class="wd-20 right" style="margin-bottom:15px;margin-right:200px">
                                    <h3><?php 
                                   
                         if($advnc[0]['type']=="teacher")
                         {
                              $nam=$this->db->select('*')
                                            ->from('teacher')
                                            ->where('id',$advnc[0]['bothid'])
                                            ->get()->row();
                                     echo $nam->designation;       
                         }else
                         {
                                  $nam=$this->db->select('*')
                                            ->from('staff')
                                            ->where('id',$advnc[0]['bothid'])
                                            ->get()->row();
                                     echo $nam->designation; 
                         }
                     
                                    ?></h3>
                                </div>
                            </div>
                             <div class="wd-100 clear">
 
                                <div class="wd-20 left" style="margin-bottom:15px;margin-left:300px">
                                    <h2>Contact No</h2>
                                </div>
                                 <div class="wd-20 right" style="margin-bottom:15px;margin-right:200px">
                                    <h3><?php
                                              
                         if($advnc[0]['type']=="teacher")
                         {
                              $nam=$this->db->select('*')
                                            ->from('teacher')
                                            ->where('id',$advnc[0]['bothid'])
                                            ->get()->row();
                                     echo $nam->contact;       
                         }else
                         {
                                  $nam=$this->db->select('*')
                                            ->from('staff')
                                            ->where('id',$advnc[0]['bothid'])
                                            ->get()->row();
                                     echo $nam->contact; 
                         }
                     
                                    ?></h3>
                                </div>
                            </div>
                        </div>
                        <div class="body">
                            <table class="tbl1">
                                <thead>
                            <tr>
                            <th>#</th>
                            <th>Month</th>
                            <th>Total Amount</th>
                            <th>Received</th>
                        </tr>
                      </thead>


                      <tbody>
                    
                        <?php $i=1; foreach ($advnc as $key => $value) { ?>
                        <tr>
                     <td style="text-align:left"><?php echo $i++; ?></td>
                     <td style="text-align:left"><?php echo date('F Y', strtotime($value['month']));?></td>
                     <td style="text-align:right">
                     <?php 
                       $date_string2 = date('Y-m', strtotime('-1 month', strtotime(date($value['month']))));
                     $check_premnth=$this->db->select('monthly_advance.remaining_adv')
                                             ->from('monthly_advance')
                                             ->where('refrence',$value['type'])
                                             ->where('bothid',$value['bothid'])
                                             ->where('month',$date_string2)
                                             ->get()->row_array()['remaining_adv'];
                          if(empty($check_premnth))
                          {
                                 $check_premnth=0;
                          }else
                          {
                                 $check_premnth=$check_premnth;
                          }                
                   
                     $ptc=$value['amount']+$check_premnth;
                     echo number_format($ptc);
                     ?>
                     </td>
                     <td style="text-align:right">
                     <?php 
                     $check_slry=$this->db->select('*')
                                         ->from('salary')
                                         ->where('month',$value['month'])
                                         ->where('refrence',$value['type'])
                                         ->where('bothid',$value['bothid'])
                                         ->get()->row_array();
                          if(!empty($check_slry)) 
                          {
                              $nw_chk_mnth_tbl=$this->db->select('monthly_advance.pay_adv')
                                                        ->from('monthly_advance')
                                                        ->where('refrence',$value['type'])
                                                        ->where('bothid',$value['bothid'])
                                                        ->where('month',$value['month'])
                                                        ->get()->row_array()['pay_adv'];
                                           if(!empty($nw_chk_mnth_tbl)) 
                                           {
                                      $date_string2 = date('Y-m', strtotime('-1 month', strtotime(date($value['month']))));
                                   $check_premnth=$this->db->select('monthly_advance.remaining_adv')
                                             ->from('monthly_advance')
                                             ->where('refrence',$value['type'])
                                             ->where('bothid',$value['bothid'])
                                             ->where('month',$date_string2)
                                             ->get()->row_array()['remaining_adv'];
                                               if(empty($check_premnth))
                                                 {
                                                      $check_premnth=0;
                                                 }else
                                                 {
                                                     $check_premnth=$check_premnth;
                                                 } 
                                                    $cp=$nw_chk_mnth_tbl+$check_premnth;
                                                    echo number_format($cp);
                                           }else
                                           {
                                              $date_string2 = date('Y-m', strtotime('-1 month', strtotime(date($value['month']))));
                                            $check_premnth=$this->db->select('monthly_advance.remaining_adv')
                                             ->from('monthly_advance')
                                             ->where('refrence',$value['type'])
                                             ->where('bothid',$value['bothid'])
                                             ->where('month',$date_string2)
                                             ->get()->row_array()['remaining_adv'];
                                               if(empty($check_premnth))
                                                 {
                                                      $check_premnth=0;
                                                 }else
                                                 {
                                                     $check_premnth=$check_premnth;
                                                 } 
                                               $alsm=$value['amount']+$check_premnth;
                                               echo number_format($alsm);
                                           }            
                          }  else
                          {
                             echo "Unpaid";
                          }            
                      
                     ?>
                     </td>
                     
                        </tr>
                        <?php } ?>
                      </tbody>
                    </table>
                  </div>
                </div>
              </div>

            </div>
          </div>
        </div>
        <!-- /page content -->
      </div>
    </div>

      <script>
        window.print();
    </script>
  </body>
</html>