Subversion Repositories SmartDukaan

<section class="wrapper">            
        <div class="row">
                <div class="col-lg-12">
                        <h3 class="page-header"><i class="icon_document_alt"></i>FRANCHISEE SALES REPORT</h3>
                        <ol class="breadcrumb">
                                <li><i class="fa fa-home"></i><a href="${rc.contextPath}/dashboard">Home</a></li>
                                <li><i class="icon_document_alt"></i>Franchisee Sales Report</li>                                                       
                        </ol>
                </div>
        </div>
                <div class="row col-lg-12"  style="float: right;">
                
                  
                 
                  From  <input type="date" id="startDate-franchisee-sales" placeholder=""   name="" value="$startDate" >
                     
                   To <input type="date" id="endDate-franchisee-sales" placeholder=""  value="$endDate">
                        
                        <button type="submit" class="download-franchisee-sales">Download Report </button>
                </div>
         
    <div class="col-lg-12">
        <table class="table table-border table-condensed table-bordered" id="focoSaleReportTable" style="width:100%">

            <thead class="row htable" style="background:#F5F5F5;">

            <tr style="color:black;">
                    <th>  Code</th> 
                    <th> Name</th>
                         <th> City</th>
                         <th> State</th>
        
                         <th>  Region</th>
                           <th>  Item Id</th>
                          <th>  Brand</th>
                           <th>  Model Name</th>
                           <th>  Model Number</th>
                            <th>  Color</th>
                            <th> Quantity</th>
                            <th>  dp</th>
                           <th> Selling_Price</th>
                       <th>   mop</th>
                          <th>  Serial Number</th>
                           <th>  Create Date</th>
                         <th> Customer Name</th>
                         <th> Customer Phone</th>
                        <th> Customer City</th>
                        <th>  Customer Pincode</th>
                   <th>  Invoice  Number</th>
                       <th> Purchase Reference</th>
                        <th> Customer Gst Number</th>
                      <th>  Cancelled Timestamp</th>
                   <th>  GRN Complete Date</th>
                      <th>  Hygiene Rating</th>
                        <th>  Rating</th>
                        <th> Status</th>
                         <th> Remark</th>
                       <th>  Created Timestamp</th>
                   <th> Disposed Timestamp</th>
                      <th>  Next Timestamp</th>
                   <th>  Activation Timestamp</th>
                     <th> Create Timestamp</th>
                       <th>Label</th>
                
            </tr>
            </thead>
            <tbody>
                #foreach($focoSaleReport in $focoSaleReportList )
               <tr>
               <td>$focoSaleReport.getCode()</td>
                <td>$focoSaleReport.getName()</td>
                 <td>$focoSaleReport.getCity()</td>
                  <td>$focoSaleReport.getState()</td>
                  
                  
                   <td>$focoSaleReport.getRegion()</td>
                    <td>$focoSaleReport.getItemId()</td>
                  <td>$focoSaleReport.getBrand()</td>
                 <td>$focoSaleReport.getModelName()</td>
                 
                  <td>$focoSaleReport.getModelNumber()</td>
                   <td>$focoSaleReport.getColor()</td>
                    <td>$focoSaleReport.getQuantity()</td>
                     <td>$focoSaleReport.getDp()</td>
                 
                  <td>$focoSaleReport.getSellingPrice()</td>
                  <td>$focoSaleReport.getMop()</td>
                  
                  #if($focoSaleReport.getSerialNumber())
                   <td>$focoSaleReport.getSerialNumber()</td>
                   #else
                   <td> -- </td>
                   #end
                    <td>$focoSaleReport.getCreateDate()</td>
                    
                     <td>$focoSaleReport.getCustomerName()</td>
                 <td>$focoSaleReport.getCustomerPhone()</td>
                  <td>$focoSaleReport.getCustomerCity()</td>
                   <td>$focoSaleReport.getCustomerPincode()</td>
                   
                    <td>$focoSaleReport.getInvoiceNumber()</td>
                 <td>$focoSaleReport.getPurchaseReference()</td>
                  <td>$focoSaleReport.getCustomerGstNumber()</td>
                  
                  #if($focoSaleReport.getCancelledTimestamp())
                   <td>$focoSaleReport.getCancelledTimestamp()</td>
                  #else
                   <td> -- </td>
                  #end
                  <td>$focoSaleReport.getGrnCompleteDate().format($datehiphenFormatter)</td>
                   #if($focoSaleReport.getHygieneRating())
                   <td>$focoSaleReport.getHygieneRating()</td>
                   #else
                   <td>0</td>
                   #end
                  #if($focoSaleReport.getRating())
                  <td>$focoSaleReport.getRating()</td>
                  #else
                  <td> --</td>
                  #end
                
                  #if($focoSaleReport.getStatus())
                  <td>$focoSaleReport.getStatus()</td>
                  #else
                  <td> -- </td>
                  #end
                  #if($focoSaleReport.getRemark())
                   <td>$focoSaleReport.getRemark()</td>
                  #else
                    <td> -- </td>
                  #end
                   
                   
                 #if($focoSaleReport.getCreatedTimestamp())
                 <td>$focoSaleReport.getCreatedTimestamp().format($datehiphenFormatter)</td>
                 
                #else
                  <td> -- </td>
                #end
                  
                #if($focoSaleReport.getDisposedTimestamp())
                  <td>$focoSaleReport.getDisposedTimestamp().format($datehiphenFormatter)</td>
                #else
                 <td> -- </td>
                #end
                #if($focoSaleReport.getNextTimestamp())
                   <td>$focoSaleReport.getNextTimestamp().format($datehiphenFormatter)</td>
                #else
                 <td> -- </td>
                #end
                #if($focoSaleReport.getActivationTimestamp())
                
                    <td>$focoSaleReport.getActivationTimestamp().format($datehiphenFormatter)</td>
                #else
                    <td> -- </td>
                #end 
                 #if($focoSaleReport.getActivationTimestamp())
                 <td>$focoSaleReport.getCreateTimestamp().format($datehiphenFormatter)</td>
                 
                 #else
                 <td> -- </td>
                 #end
                  <td>$focoSaleReport.getLabel()</td>
                 
                     
               </tr>
                #end

            </tbody>

        </table>
    </div>
        
</section>



<script>

        var dtable = $('#focoSaleReportTable').DataTable(
                {
                    "scrollX": true,
                    "bPaginate": true,
                    "bLengthChange": true,
                    "bFilter": true,
                    "bInfo": false,
                    "bAutoWidth": false,
                  
                     
     });
  
   
    
    </script>