EVOLUTION-NINJA

Edit File: report_status_unbooked_grid.php

<?php echo view('includes/header');?>

<h1 style="text-align: center;">Status Report<small></small> </h1>
       <input type="hidden" class="form-control col-sm-8 id" name="id"  required="required"> 
        <input type="button" class="btn btn-primary pull-left" value="Back" onclick="fun_back()" style="margin-top: 50px;margin-bottom: 0px;margin-left: 19px;" >
      </section>
      <section class="content">
        <div class="" style="padding-left: 15px; padding-right: 15px;">
        <div class="row" class="regis-block">
         
        
        
          
              <div class="col-sm-12">
                <div id="jaytab3" style="margin-top:2%;" >
                    
                    <p id="total_marketing_dimension"style="color:green;"></p>
                     <p id="total_booked_dimension"  style="color:green; margin-bottom:50px;"></p>
                  <div class="grid_div"></div>
                  <table id="list13" class="table-responsive">
                  </table>
                  <div id="pager13"></div>
                  <div id="dialogSelectRow13" title="Warning" style="display:none">
                  <p>Please select row</p>
                  </div>
                </div>
              </div>
                 <div style="display:none;"><table  border="1" style="border-spacing: 0px !important;" id="status_export_table" class="status_export_table"></table></div>
                    <div style="display:none;">
                    <table  border="1" style="border-spacing: 0px !important;" id="status_print_table" class="status_print_table"></table>
          </div>
  </div>  
        
      </section> 
</div>

{

window.location.href="<?php echo site_url('reports')?>";

}
  </script>
<script type="text/javascript">
  
$(document).ready(function (){
CallGrid();

function CallGrid()
{
      $.ajax({
        type   : 'post',
        url    : '<?php echo site_url("get-total-dimension-for-unbooked-sites")?>',   
        data   : {},                        
        success:function(response)
        {
            response=jQuery.parseJSON(response);
            console.log(response);
           // alert(response);
            if(response.result == 1)
            {
                $.each(response.total_marketing,function(index,val)
                {
                    
                    $('#total_marketing_dimension').html('Total Given for Marketing : '+val.total_in_sqft);
                });
                 $.each(response.booked_sqft,function(index,val)
                {
                  
                
                 $('#total_booked_dimension').html('Booked Sites Dimension : '+val.booked_sqft);

});
               
            }
            else
            {
                $('#total_marketing_dimension').html('Total Given for Marketing : 0');
                $('#total_booked_dimension').html('Booked Sites Dimension : 0');
            }
            
           
        }
    });
   jQuery("#list13").jqGrid({

url:"<?php echo site_url('unbooked-site-report-site')?>",
            mtype : "post",      
            datatype: "json", 
            colNames:['SI','Project','Site No','Khata Status','Dimension'],
            colModel:[
            {name:'booking_id',index:'booking_id', width:75, hidden:true,editable:false,key:true},
            {name:'project_name',index:'project_name', width:150, editable:false},
            {name:'site_number',index:'site_number', width:75, editable:false},
            {name:'status',index:'status', width:75,editable:false},
              {name:'total_in_sqft',index:'total_in_sqft', width:100, editable:false},
              ],
       
             rowNum:25,
            rowTotal: 2000,
            rowList : [10,20,30,50,100,500,1000],
            rownumbers: true,
            rownumWidth: 40,
            pager:"#pager13", 
            sortname:'owner_id', 
            viewrecords: true,
            gridview: true,
            //autowidth: true,
            sortorder:"asc",
            shrinkToFit: false,

emptyrecords: 'No records to display',
            //  multiselect: true,
            // multiboxonly: true,
            loadonce:true,
            caption:"Report Status", 
             footerrow: true,
                loadComplete: function () {
                        var sumOfdimension    = jQuery("#list13").jqGrid('getCol','total_in_sqft',false,'sum');
                       
                        
                        jQuery("#list13").jqGrid('footerData', 'set', { site_number: 'Total:', total_in_sqft: sumOfdimension.toFixed(2)});  
                     
                },

});

$("#list13").jqGrid("setLabel", "rn", "SL");

$("#list13").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list13").jqGrid('navGrid','#pager13',
                    {edit:true,add:false,del:false,search:true,refreshstate:"current"},
                    { },
                    { },
                    { }, 
                    {
                    sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
                    closeOnEscape: true, 
                    multipleSearch: true, 
                    closeAfterSearch: true }
                ).navButtonAdd('#pager13',
                        {   caption:"Print", 
                            buttonicon:"ui-icon-print", 
                            onClickButton:unreg_site_print,
                            position: "last", 
                            title:"", 
                            cursor: "pointer",
                            id:"client_delete_new"
                        } 
                );  
                $("#list13").navButtonAdd('#pager13',
                        {   caption:"Export", 
                            buttonicon:"", 
                            onClickButton: unreg_site_export,
                            position: "last", 
                            title:"", 
                            cursor: "pointer",
                            id:"client_delete"
                        } 
                );

function unreg_site_print() 
                {
                        //alert();
                  
                    
                    id = jQuery("#list13").jqGrid('getDataIDs');
                    
                  
                    $.ajax({
                    url:"<?php echo site_url('unbooked-site-report-site')?>",
                    type : "GET",   
                    data   : {id:id},
                                              
                      success:function(data){
                      response=jQuery.parseJSON(data);
                     console.log(response);
                    
                            var count =1;
                          
                                var content = '';
                                content +='<thead><tr><th>Sl No</th><th>Project</th><th>Site</th><th>Khata Status</th><th>Dimension</th></tr></thead>';
                                 $.each(response,function(key,va){
                
                                
                                    
                                        content +='<tr><td>'+count+'</td><td>'+va.project_name+'</td><td>'+va.site_number+'</td><td>'+va.status+'</td><td>'+va.total_in_sqft+'</td></tr>';
                                        count++;
                            
                                });

$('.status_print_table').append(content);
                            print_page1();
                            }
                        });
                        
                        function print_page1()
                            {  
                                
                                var divToPrint=document.getElementById('status_print_table');
                                    newWin= window.open("");
                                    newWin.document.write('<html><head><title></title>');
                                    newWin.document.write('</head>');
                                    newWin.document.write(divToPrint.outerHTML);
                                    newWin.document.write('</html>');
                                    newWin.print();
                                    document.getElementById('status_print_table').style.display='';
                                    newWin.close();
                                    location.reload();
                            }
                }
                             
          }      
});

</script>

.scroll 
{
    height:12px !important;
}
#gbox_list6_251_t
{
    height:auto !important;
}

#list6
{
    width: 1050px;
height: 0px !important;
}
#gbox_list6
{

height: auto !important;
}
#gview_list6
{

height: auto !important;
}
.ui-jqgrid-ftable.ui-common-table {
    width: 558px !important;
}

@media only screen and (min-width:320px) and (max-width:641px){
            .ui-jqgrid {
    margin-left: 1px !important;
}
            #jaytab{
                margin-top: 0 !important;
                margin-left: 0 !important;
                overflow-x: scroll;
                width: 100% !important;
                padding-left: 0 !important;
            }
            
            #editmodlist6
            {
                width:90% !important;
            }
            #sData span, #cData span {
                margin-left: 0 !important;
                }
        }
        @media only screen and (min-width:641px) and (max-width:991px){
            
            .ui-jqgrid {
            margin-left: 1px !important;
            }
            #jaytab{
                margin-top: 0 !important;
                margin-left: 0 !important;
                overflow-x: scroll;
                width: 100% !important;
                padding-left:0 !important;
                padding-right:9px !important;
            }

}
        
        @media only screen and (min-width:1601px) and (max-width:1920px){
            .ui-jqgrid-hdiv {
                width: 1610px !important;
            }
            .ui-jqgrid-bdiv, .ui-jqgrid-ftable {
                width: 1610px !important;
            }
            #list13 {
                width: 1610px !important;
            }
        }
#sData span, #cData span 
{
    margin-left: 3px;
}
#sData {
    height: 29px;
}
#cData {
    height: 29px;
}

.jqgfirstrow
    {
            height: 0px !important;
    }

.payment_client_details td {
    border-bottom: 1px solid black;
    line-height:1.8;
    width: auto !important;
    border: 1px solid black;
}

.ui-jqgrid-bdiv{
    height: auto !important;
}
.ui-jqgrid .ui-jqgrid-caption {
    text-align: left;
    background: #AA0000;
    color: white;
    height: 30px;
}
#list13 td{
    font-size: 12px !important;
}
.ui-jqgrid-labels th{
    font-size: 13px !important;
}
/*.ui-state-default,.ui-jqgrid-bdiv,#gbox_list13,#gview_list13{
   width: 1858px !important; 
}*/
.ui-jqgrid-btable {
    width: 558px !important;
}
.ui-jqgrid .ui-jqgrid-hbox {
    padding-right: 0 !important;
}
#gbox_list13,#gview_list13,#pager13{
    width:auto !important;
}
.ui-jqgrid-ftable,.ui-jqgrid-sdiv,.ui-jqgrid-ftable.ui-common-table{
    width:1610px !important;
}
/*#list13_project_name{*/
/*    width: 60px !important;*/
/*}*/
/*#list13_site_number{*/
/*    width:35px !important;*/
/*}*/
/*#list13_rn{*/
/*    width:15px !important;*/
/*}*/
#gview_list13,#gbox_list13,.ui-jqgrid-hbox,#list13,.ui-jqgrid-hdiv{
    width:700px !important;
}
.ui-jqgrid-ftable, .ui-jqgrid-sdiv, .ui-jqgrid-ftable.ui-common-table {
    width: 700px !important;
}
#jaytab3 {
    overflow-x: hidden !important;
}
.ui-jqgrid .ui-jqgrid-pager .ui-paging-pager {
    margin-left: 165px !important;
}
/*.ui-pg-div .ui-icon{
    margin-left: 25px !important;
}*/
#client_delete .ui-icon{
    margin-left: 25px !important;
}
</style>   
<?php echo view('includes/footer');?>