{% include 'mfire/include/header.html' %}
   {% include 'mfire/include/topbar.html' %}
    {% include 'mfire/include/sidebar.html' %}
    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <div class="container-fluid">

                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1> Products List</h1>
                    </div>
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                            <li class="breadcrumb-item"><a href="/mfire/dashboard/">Dashboard</a></li>
                            <li class="breadcrumb-item active">Product List</li>
                        </ol>
                    </div>
                </div>
            </div><!-- /.container-fluid -->
        </section>

        <!-- Main content -->
        <section class="content">

            <!-- Default box -->
            <div class="card">
                
                <div class="card-header">
                      <form action="/mfire/get_client_month_report/" method="get">
                <div class="row">
                    <div class="col-md-3 col-sm-12">
                        <select name="empid" id="empid" class="form-control select2bs4">
                            <option value="">-- Select Operator --</option>
                            {% for i in employees %}
                            <option value="{{i.id}}">{{i.first_name}} {{i.last_name}}</option>
                            {% endfor %}
                        </select>
                    </div>
                    
                       <!-- <div class="col-md-2 col-sm-12">
                                                        <select class="form-control" name="month"> 
                                                            <option value="0">-- Select Month --</option>
                                                            <option  value="1">January</option>
                                                            <option  value="2">February</option>
                                                            <option  value="3">March</option>
                                                            <option  value="4">April</option>
                                                            <option  value="5">May</option>
                                                            <option  value="6">June</option>
                                                            <option  value="7">July</option>
                                                            <option  value="8">August</option>
                                                            <option  value="9">September</option>
                                                            <option  value="10">October</option>
                                                            <option  value="11">November</option>
                                                            <option  value="12">December</option>
                                                        </select>
                                                    </div> -->
                                                    <div class="col-md-4 col-sm-12">
                                                        <input id="reportrange" name="reportrange" class="form-control"  style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc; width: 100%">
                                                    </div>

                                                    <div class="col-md-3 col-sm-12">
                                                        <select name="prd_id" class="form-control" required>
                                                            <option value="">-- select equipment --</option>
                                                            <!--<option value='10'>Fire Extinguisher</option>-->
                                                            <option value='CO2'>CO2</option>
                                                            <option value='DCP'>DCP</option>
                                                            <option value='FE36'>FE36</option>
                                                            <option value='11'>Hydrant Point</option>
                                                        </select>
                                                    </div>
                                                    
                                                    
                                                     <div class="col-md-2">
                                                    <button type="submit" class="btn btn-primary">Get Report</button>
                                                    </div>
                                 </div>
                                 </form>
                
                </div>
                <div class="card-body" style="overflow-x: auto">
                                    <button class="btn btn-warning" id="check" onclick="checkedall()">Check All</button>
                                    <button class="btn btn-warning" id="uncheck" onclick="uncheckedall()">Uncheck All</button>
                                    <button type="button" class="btn btn-warning" onclick="monthlypdfreport()" target="__blank">PDF</button> 
                                    <button type="button" class="btn btn-warning" onclick="monthly_report_to_excel()">Excel</button>
                    
                                                 <!--10 product fire ex-->
                                         {% if product1 %}
                                            <table id="example1" class="table table-bordered table-striped">
                                                <thead>
                                                 <tr>
                                                    <th>#No.</th>
                                                    <th>Code No</th>
                                                    <th>F.E. Type</th>
                                                    <th>EXTG NO</th>
                                                    <th>Make</th>
                                                    <th>CYLINDER NO</th>
                                                    <th>MFG YEAR</th>
                                                    <th>DATE OF HT</th>
                                                    <th>HT DUE DATE</th>
                                                    {% if pid == 'DCP' %}<th>DATE OF OVERHAULING</th>{% endif %}
                                                    {% if pid == 'DCP' %}<th>DUE DATE OVERHAULING</th>{% endif %}
                                                    {% if pid == 'DCP' or pid == 'FE36' %}<th>DUE DATE DISCARD</th>{% endif %}
                                                    <th>CERTIFICATE NO</th>
                                                    <th>Capacity (KG)</th>
                                                    <th>F & S Operator Comment</th>
                                                    <th>F & S Operator Name</th>
                                                    <th>F & S Operator Image</th>
                                                    <th>F & S Officer Name</th>
                                                    <th>F & S Officer Comment</th>
                                                    <th>F & S Officer Image</th>
                                                    <th>F & S Operator Date</th>
                                                    <th>F & S Officer Date</th>
                                                    <th>Health</th>
                                                </tr>
                                                        </thead>
                                                        <tbody>
                                                            {% for i in product1 %}
                                                            <tr>
                                                                <td><input class="checkAll" name="smpid" type="checkbox" value="{{i.id}}">
                                                                <input type="hidden" name="modelno{{i.id}}" value="{{i.id}}"/>
                                                                <input type="hidden" name="pid" id="pid" value="{{pid}}"> 
                                                                <input type="hidden" name="user" id="user" value="{{i.smpid.clientid.id}}">
                                                                {{forloop.counter}}</td>   
                                                                <td>{{i.smpid.modelno}} </td>
                                                                <td>{{i.FEType}}</td>
                                                                <td>{{i.extgno}}</td>
                                                                <td>{{i.make}}</td>
                                                                <td>{{i.cylinderno}}</td>
                                                                <td>{{i.mfgyear|date:"d/m/Y"}}</td>
                                                                <td>{{i.dateofht|date:"d/m/Y"}}</td>
                                                                <td>{{i.duedateht|date:"d/m/Y"}}</td>
                                                                {% if pid == 'DCP' %}<td>{{i.dateofoverhauling|date:"d/m/Y"}}</td>{% endif %}
                                                                {% if pid == 'DCP' %}<td>{{i.duedateoverhauling|date:"d/m/Y"}}</td>{% endif %}
                                                                {% if pid == 'DCP' or pid == 'FE36' %} <td>{{i.duedatediscard|date:"d/m/Y"}}</td>{% endif %}
                                                                <td>{{i.certificateno}}</td>
                                                                <td>{{i.capacity}}</td>
                                                                <td>{{i.engg_comment}}</td>
                                                                <td>{{i.empid.first_name}} {{i.empid.last_name}}</td>
                                                                <td>{% if i.engg_image %} <a href="{{i.image.url}}" target="_blank"> <img src="{{i.engg_image.url}}" width="100px"/>  </a> {% else %} No Image {% endif %}</td>
                                                                <td>{{i.clientid.first_name}} {{i.clientid.last_name}}</td>
                                                                <td>{{i.client_comment}}</td>
                                                                <td>{% if i.client_image %} <a href="{{i.client_image.url}}" target="_blank"> <img src="{{i.client_image.url}}" width="100px" /> </a> {% else %} No Image {% endif %}</td>
                                                                <td>{{i.createdate|date:"d/m/Y"}}</td>
                                                                <td>{{i.updatedate|date:"d/m/Y"}}</td>
                                                                <td>{{i.health}}</td>
                                                            </tr>
                                                           {% endfor %}
                                                            </tbody>
                                                    </table>
                            
                                                    {% endif %}
                                                    <!--11 product hydrant-->
                                                    {% if product2 %}
                                                <table id="example1" class="table table-bordered table-striped">
                                                    <thead>
                                                        <tr>
                                                                            <th>#No.</th>
                                                                            <th>Code No</th>
                                                                            <th>Location</th>
                                                                            <th>Unit</th>
                                                                            <th>Hydrant No</th>
                                                                            <th>Size (3L)</th>
                                                                            <th>Size (4)</th>
                                                                            <th>Size (3R)</th>
                                                                            <th>Monitor</th>
                                                                            <th>LV/GV (Left Side)</th>
                                                                            <th>LV/GV (Right Side)</th>
                                                                            <th>B/V</th>
                                                                            <th>Off Site/Unit area</th>
                                                                            <th>F & S Operator Name</th>
                                                                            <th>F & S Operator Remarks</th>
                                                                            <th>F & S Operator Image</th>
                                                                            <th>F & S Officer Name</th>
                                                                            <th>F & S Officer Comment</th>
                                                                            <th>F & S Officer Image</th>
                                                                            <th>F & S Operator Date</th>
                                                                            <th>F & S Officer Date</th>
                                                                            <th>Health</th>
                                                        </tr>
                                                        
                                                    </thead>
                                                    <tbody>
                                                        {% for i in product2 %}
                                                        <tr>
                                                                <td><input class="checkAll" name="smpid" type="checkbox" value="{{i.id}}">
                                                                <input type="hidden" name="modelno{{i.id}}" value="{{i.id}}"/>
                                                                <input type="hidden" name="pid" id="pid" value="11"> 
                                                                <input type="hidden" name="user" id="user" value="{{i.smpid.clientid.id}}">
                                                                {{forloop.counter}}</td>   
                                                                <td> {{i.smpid.modelno}} </td>
                                                                <td> {{i.smpid.location}} </td>
                                                                <td> {{i.smpid.unit}} </td>
                                                                <td>{{i.hydrantno}}</td>
                                                                <td>{{i.size3}}</td>
                                                                <td>{{i.size4}}</td>
                                                                <td>{{i.size3s}}</td>
                                                                <td>{{i.monitor}}</td>
                                                                <td>{{i.leftsidelvgv}}</td>
                                                                <td>{{i.rightsidelvgv}}</td>
                                                                <td>{{i.hydrantblockvalve}}</td>
                                                                <td>{{i.offsiteunitarea}}</td>
                                                                <td>{{i.empid.first_name}} {{i.empid.last_name}}</td>
                                                                <td>{{i.engg_comment}}</td>
                                                                <td>{% if i.engg_image %} <a href="{{i.image.url}}" target="_blank"> <img src="{{i.engg_image.url}}" width="100px"/>  </a> {% else %} No Image {% endif %}</td>
                                                                <td>{{i.clientid.first_name}} {{i.clientid.last_name}}</td>
                                                                <td>{{i.client_comment}}</td>
                                                                <td>{% if i.client_image %} <a href="{{i.client_image.url}}" target="_blank"> <img src="{{i.client_image.url}}" width="100px" /> </a> {% else %} No Image {% endif %}</td>
                                                                <td>{{i.createdate|date:"d/m/Y"}}</td>
                                                                <td>{{i.updatedate|date:"d/m/Y"}}</td>
                                                                <td>{{i.health}}</td>
                                                            </tr>
                                                               {% endfor %}
                                                                </tbody>
                                                        </table>
                                
                                                    {% endif %}


                </div>
                <!-- /.card-body -->
            </div>
            <!-- /.card -->

        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->
<script>
    function clientdata(){
            var v = document.getElementById("client").value;
            console.log(v);
              $.ajax({
                url: "/loadclient/",
                method:'GET',
                data: {
                  'v': v
                },
                success: function (data) {
                  $("#location").html(data);
                  console.log(data);
                  //document.getElementById("location").value = data;
                }
             });
      }
      function pdfuserreportservice(){
          
            var a_smpid = [];
            $.each($("input[name='smpid']:checked"), function(){
                a_smpid.push($(this).val());
            });

            let modelno = '';
            for (var i = 0; i < a_smpid.length; i++) 
            {
                let n_smpid = a_smpid[i];
                modelno += $("input[name=modelno"+n_smpid+"]").val();
                pid = $("#pid").val();
                user = $("#user").val();

                if (i != a_smpid.length-1) modelno += ',';     
            }

            if (a_smpid.length == 0)
                alert('select checkbox');
            else 
                window.open("https://fireinspector.in/pdf_report_service/?pid="+pid+"&user="+user+"&model_no="+modelno, "_blank")
} 
   
   
 function getCapacity(data) 
    {
        let selectedItem = data.value;
        $('#fetype').css('display', 'none');
        
        if (selectedItem === '10'){
            $('#fetype').css('display', 'block');
        }
    }   
      
  
</script>

    {% include 'mfire/include/footer.html' %}