<html>
<head>
    <title><?php echo $b_header['title']; ?></title>
    <style>
        @media print
        {
            * {-webkit-print-color-adjust:exact;}
            @page {margin:0in 0.10in 0in 0in; }
            .super_container
            {
                page-break-after: always;
                margin-top:0.25in;
                position:relative;
                width:100vw;
                height:710px;
            }

            /*@page { size: landscape; }*/
        }
        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-5{width:5%;}
        .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,h4,p{
            color:#191970;
            font-family:calibri;
            text-align:center;
        }
        .boxed{color:#000000;width:80%;margin:0 auto;}
        .header{
            width:100%;
            border-bottom:4px solid #191970;
        }
        .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{
            font-size: 12px;
            border: 1px solid #000;
            border-right: 0px;
            border-bottom: 0px;
            background-color:#ccccb3;
            padding: 3px !important;
            text-align: left !important;
        }
        td{
            font-size:12px;
            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><h2 style="color:#000000"><?php echo $b_header['title']; ?></h2></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><h4>Contact# <?php //echo $b_header['phone_no']; ?> / <?php //echo $b_header['email']; ?></h4></center>-->
                            <center><h3 class="boxed" style="margin-top:0px !important;font-size:23px;">Report For Trial Balance 2</h3></center>
                    </div>
                    </div>

                    <div class="wd-100 clear">
                        <div class=" text-left left ">
                            <p style="font-size:18px;color: #000000;margin-right:20px "><b>Start Date: </b><?php echo date('d-m-Y', strtotime($sdate));?></p>
                            <?php
                            if(!empty($comment))
                            {
                                ?>
                                <p style = "font-size:18px;color: #000000;margin-right: 60px"><b > Comments: </b >
                                    <?php echo $comment;?>
                                </p >
                                <?php
                            }
                            ?>
                        </div>
                        <div class=" text-right right ">
                            <p style="font-size:18px;color: #000000;"><b>End Date: </b><?php echo date('d-m-Y', strtotime($enddate));?></p>
                        </div>
                    </div>




                </div>
                <div class="body">
                    <table class="tbl1">
                        <thead>
                        <tr>

                            <th width="15%">Account </th>
                            <th width="15%">Account Title</th>
                            <th width="15%">Opening Balance</th>
                            <th width="15%">Cr</th>
                            <th width="15%">Debit</th>
                             <th width="15%">Closing</th>
                        </tr>
                        </thead>
                        <tbody>
                            
                        <?php
                        $crtotal=0;
                         $cr=0;
                         $dr=0;
                        $dbtotal=0;
                        $dataopdb=0;
                        foreach($query as $val)
                        {
                        
                           
                           $datadb=0;
                           $datacr=0;
                            $amount=0;
                            ?>
                            <tr>
                                <td><strong><?php echo $val['code']?></strong></td>
                                <td><?php echo $val['name']?></td>
                               <td style='text-align:right;'><?php echo number_format($dataopdb['amount'])?></td>
                                
                                <?php
                                $branch=$this->user_model->getbranch();
                                $datadb = $this->db->query("SELECT SUM(transction.amount) as trans FROM transction where transction.has_cr=1 and transction.branch='$branch' and date>='$sdate' and date<='$enddate' and head='$val[id]' and is_delete=0")->row_array()['trans'];
                                $datacr = $this->db->query("SELECT SUM(transction.amount) as trans FROM transction where transction.has_cr=0 and transction.branch='$branch' and date>='$sdate' and date<='$enddate' and head='$val[id]' and is_delete=0")->row_array()['trans'];
                               
                               // $total= $datadb- $datacr;
                                $dataopdb = $this->db->query("SELECT * from opening_balance where opening_balance.head='$val[id]' and opening_balance.branch='$branch' and is_delete='0'")->row_array();
                                
                                if(!empty($dataopdb))
                                {
                                    if($dataopdb['has_cr']==0)
                                    {
                                        $datacr=$datacr+$dataopdb['amount'];
                                       // $total= $datadb- $datacr;
                                      //  $amount=$total-$dataopdb['amount'];

                                    }else{
                                        $datadb=$datadb+$dataopdb['amount'];
                                        //$total= $datadb- $datacr;
                                        //$amount=$total+$dataopdb['amount'];
                                    }
                                }
                                $amount=$datadb-$datacr;
                                    if($amount<0)
                                    {
                                        echo "<td style='text-align:right;'>";
                                       // $crtotal = $crtotal + $amount;
                                      $cr+=$amount;
                                        echo number_format(abs($amount));
                                        echo "</td>";
                                    }
                                    else{
                                        echo"<td style='text-align:right;'>";
                                        echo 0;
                                        echo "</td>";
                                    }
                                    if($amount>0)
                                    {
                                        echo"<td style='text-align:right;'>";
                                       // $dbtotal=$dbtotal+$amount;
                                       $dr+=$amount;
                                        echo number_format(abs($amount));
                                        echo "</td>";
                                    }
                                    else{
                                        echo"<td style='text-align:right;'>";
                                        echo 0;
                                        echo "</td>";
                                    }
                                    
                                
                                

                             //  $balan=$dbtotal-$crtotal;
                                        echo"<td style='text-align:right;'>";
                                        echo number_format($amount);
                                        echo "</td>"; 
                                    
                             
                                


                                ?>
                            </tr>
                            <?php
                        }
                        ?>

                        <tr>
                            
                            <td></td>
                            <td></td>
                            <td><strong>Total</strong></td>
                           
                            <td style='text-align:right;'><strong>
                            <?php
                            echo number_format(abs($cr));
                            ?></strong>
                            </td>
                            <td style='text-align:right;'><strong>
                            <?php  echo number_format(abs($dr));?>
                            </strong></td>
                            
                             </td>
                            <td style='text-align:right;'><strong>
                            <?php  echo number_format($amount);?></strong>
                            </td>
                            
                            
                        </tr>
                        </tbody>
                    </table>
                </div>

            </div>
        </div>

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

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