<script type="text/javascript">
var params=0;

$(function(){

         $( "#showhidesearch" ).button({
            icons: {
                primary: "ui-icon-search"
            },
            text: true
        });
        $('#datepicker').datepicker({ dateFormat: 'yy-mm-dd' });
        $('#datepicker2').datepicker({ dateFormat: 'yy-mm-dd' });
        $("#search").click(function(){

            loadGrid();

        });

       $("#show").click(function(){
           loadGrid();
});
        });

function loadGrid(){
              var datefrom = document.getElementById('datepicker');
              var dateto = document.getElementById('datepicker2');
              var property = document.getElementById('chproperty');

            $("#lines").GridUnload();
            jQuery("#lines").jqGrid({
            url:'<?= site_url() ?>sales/salesmanreport/getsalesmansname',
            datatype: "json",
            mtype : "post",
            colNames:['NAME','PAX','AMOUNT','PERPAXSALE'],
            postData: { datefrom: datefrom.value,dateto: dateto.value,property: property.value},
            datatype: "json",
            mtype : "post",
            colModel:[
               {name:'NAME',index:'NAME', width:300,editable:false,align:"center",editoptions:{readonly:true,size:10}},
                 {name:'PAX',index:'PAX', width:200, editable:false,align:"center",editoptions:{readonly:true,size:10}},

                {name:'AMOUNT',index:'AMOUNT', width:300,formatter:'currency', formatoptions: {thousandsSeparator:','},summaryType:'sum',editable:false,align:"right",editoptions:{readonly:true,size:10}},
                 {name:'PERPAX',index:'PERPAX', width:200,formatter:'currency', formatoptions: {thousandsSeparator:','},summaryType:'sum',editable:false,align:"right",editoptions:{readonly:true,size:10}},
                ],
shrinkToFit:false,
            rowNum:0,
          // rowList:[15,30,100000000],
            rownumbers: true,
            rownumWidth: 40,
            height: 'auto',
            autowidth:true,
//            width: 900,
            pager: '#pgtoolbar1',
            sortname: 'ID',
            viewrecords: true,
            footerrow: true,
            userDataOnFooter: true,
            sortorder: "desc",
           // multiselect: true,


            beforeSelectRow: function(rowid, e)
        {
             jQuery("#lines").jqGrid('resetSelection');
                return(true);
        },
        loadComplete: function() {
                           $("option[value=100000000]").text('All');

                          var TotaSum = jQuery('#lines').jqGrid('getCol', 'AMOUNT', false, 'sum');

                          jQuery('#lines').jqGrid('footerData', 'set',
                          {
                              'NAME': 'Total:',
                                'AMOUNT': TotaSum
                           });

                          }
        });
          $("#lines").jqGrid('navGrid', '#pgtoolbar1',{view:false, del:false, search:false, refresh:false, add:false, edit:false, excel:true})
                .navButtonAdd('#pgtoolbar1',{
                                caption:"Export to Excel",
                                buttonicon:"ui-icon-save",
                                onClickButton: function(){
                                  exportExcel();
                                },
                                position:"last"
                            });
//$("#lines").footerData('set',{PRODUCT:'Total', TOTAL:777.88});



}



 function exportExcel()
        {
            var mya=new Array();
            mya=$("#lines").getDataIDs();  // Get All IDs
            var data=$("#lines").getRowData(mya[0]);     // Get First row to get the labels
            var colNames=new Array();
            var ii=0;
            for (var i in data){colNames[ii++]=i;}    // capture col names
        var html="";
            for(k=0;k<colNames.length;k++)
            {
            html=html+colNames[k]+",";     // output each Column as tab delimited
            }
            html=html+"\n";
            for(i=0;i<mya.length;i++)
                {
                data=$("#lines").getRowData(mya[i]); // get each row
                for(j=0;j<colNames.length;j++)
                    {
                    html=html+data[colNames[j]]+","; // output each column as tab delimited
                    }
                html=html+"\n";  // output each row with end of line

                }
            html=html+"\n";  // end of line at the end

document.forms[0].exportdata.value=html;
            document.forms[0].method='POST';
            document.forms[0].action='<?php echo site_url('sales/salesmanreport/exportcsv'); ?>';  // send it to server which will open this contents in excel file
            document.forms[0].target='_blank';
            document.forms[0].submit();
            }

    $(document).ready(function() {
        $("button").button();
              loadGrid(null);
    });

</script>
<!-- CUSTOMER AUTOCOMPLETE -->
<style>
    .ui-autocomplete-loading { background: white url('<?= site_url() ?>public/images/ui-anim_basic_16x16.gif') right center no-repeat; }
</style>


<div class="main content clearfix">
<div class="page-heading">
            <h2>Sale Report By Attribute</h2>
        </div>
        <table border="0" width="100%" cellpadding="0" cellspacing="0" id="content-table">
            <tr>
                <th rowspan="3" class="sized"><img src="<?= site_url() ?>images/shared/side_shadowleft.jpg" width="20" height="300" alt="" /></th>
                <th class="topleft"></th>
                <td id="tbl-border-top"></td>
                <th class="topright"></th>
                <th rowspan="3" class="sized"><img src="<?= site_url() ?>images/shared/side_shadowright.jpg" width="20" height="300" alt="" /></th>
            </tr>
            <tr>
                <td id="tbl-border-left"></td>
                <td>
                    <div id="content-table-inner">
                        <div id="table-content">
                            <?php
                            if ($this->session->flashdata('msgt') == 'E') {
                                echo '
				<div id="message-red">
				<table border="0" width="100%" cellpadding="0" cellspacing="0">
				<tr>
					<td class="red-left">' . $this->session->flashdata('msg') . '</td>
					<td class="red-right"><a class="close-red"><img src="' . site_url() . 'images/table/icon_close_red.gif"   alt="" /></a></td>
				</tr>
				</table>
				</div>
						';
                            }
                            if ($this->session->flashdata('msgt') == 'S') {
                                echo '
					<div id="message-green">
					<table border="0" width="100%" cellpadding="0" cellspacing="0">
					<tr>
						<td class="green-left">' . $this->session->flashdata('msg') . '</a></td>
						<td class="green-right"><a class="close-green"><img src="' . site_url() . 'images/table/icon_close_green.gif"   alt="" /></a></td>
					</tr>
					</table>
					</div>
					';
                            }
                            ?>
                            <!--  start product-table ..................................................................................... -->
                             <div id="toolbartop">
                            <table>
                                 <th valign="middle"><span style="color:red;"></span>Date:</th>
                                <td>
                                    <input name="datefrom" type="text" id="datepicker" value="<?php echo  date('Y-m-d') ; ?>" class="inp-form-small"/>
                                </td>
                                <th valign="middle"><span style="color:red;"></span>Date To:</th>
                                <td>
                                    <input name="dateto" type="text" id="datepicker2" class="inp-form-small"/>
                                </td>
                                   <td>   </td>
                              <td>
  Property: <select id="chproperty">
        <option value="Captian">Captain</option>
        <option value="TariffArea">Tariff</option>
	<option value="Waiter">Waiter</option>


<!--	<option value="Place">Pax</option>-->
</select>
</td>
                                <td>
<!--                                    <div id="radio">

<input type="radio" id="radio1" name="radio"  onclick="params = 1;" checked="checked" /><label for="radio1">By Category</label>
<input type="radio" id="radio2" name="radio" onclick="params = 2;" /><label for="radio2">By Warehouse</label>
<input type="radio" id="radio3" name="radio" onclick="params = 3;" /><label for="radio3">By Tariff</label>
                                       </div>-->
                                   </td>
                                <td>
                                  <span class="button-strip">
                                    <button id="show" name="show">Show</button></span>
                                </td>
                               </table>
                             </div>
                               <form method="post" action="<?php echo site_url('sales/getsalestotalregister/exportcsv'); ?>">
    <input type="hidden" name="exportdata" id="exportdata" value="" />
</form>
                            <div align="center">
                            <table id="lines"></table>
                            </div>
                            <div id="pgtoolbar1"></div>
                        </div>
                    </div>
                            </td>
                            <td id="tbl-border-right"></td>
                            </tr>
                            <tr>
                                <th class="sized bottomleft"></th>
                                <td id="tbl-border-bottom">&nbsp;</td>
                                <th class="sized bottomright"></th>
                            </tr>
                            </table>
                            </div>
