<!-- Main content -->
<?php
session_start();
include_once './connection_sql.php';
 
?>
  
 
<section class="content">
    <div class="box box-primary">
        <div class="box-header with-border">
            <h3 class="box-title">REP WISE QTY SALES</h3>
            <h4 style="float: right;height: 3px;"><b id="time"></b></h4>
        </div>
        <form role="form" name ="form1" class="form-horizontal" target="_blank" action="report_qtysales_print.php">
            <div class="box-body">
                <div class="form-group col-md-12">
                    <a onclick="location.reload();" class="btn btn-default">
                        <span class="fa fa-user-plus"></span> &nbsp; NEW
                    </a>   
                    <button><a onclick="print_inv();" class="btn btn-primary btn-sm">
                        <span class="fa fa-print"></span> &nbsp; VIEW REPORT
                    </a></button>
                    
                   
                </div>
                <div class="form-group"></div>
                <input type="hidden" id="uniq" class="form-control">

                <div id="msg_box"  class="span12 text-center"  >  </div>

                <!--=======================-->
                
                 
                  <div class="form-group">
                    <label class="col-sm-1 control-label" for="txt_usernm" style="text-align:left">Code</label>
                    <div class="col-sm-1">
                        <input type="text"  class="form-control input-sm  "   name="Txtcusco" id="Txtcusco">
                    </div>

                    <div class="col-sm-3">
                        <input type="text" class="form-control input-sm  " disabled="disabled" id="txtcusname" name="txtcusname" />
                    </div>
                    
                    <div class="col-sm-1">
                        <a href=""  class="btn btn-danger btn-sm " onClick="NewWindow('../serach_customer.php?stname=ret_cheque_entry', 'mywin', '800', '700', 'yes', 'center');
                                return false" onFocus="this.blur()">
                            ...
                        </a>
                    </div>
                     </div>
                <div class="form-group">
                    <label class="col-md-1 control-label  " for="txt_usernm" style="text-align:left">Date From</label>
                    <div class="col-md-3">
                        <input   id="dtfrom" name="dtfrom" value="<?php echo date('Y-m-d'); ?>" class="form-control input-sm" type="date">
                    </div> 
                    <label class="col-md-1 control-label  " for="txt_usernm" style="text-align:left">Date To</label>
                    <div class="col-md-3">
                        <input  id="dtto"  name="dtto"  value="<?php echo date('Y-m-d'); ?>" class="form-control input-sm" type="date">
                    </div> 
                </div>   
                
                <div class="form-group" hidden>
                    <label class="col-md-1 control-label  " for="txt_usernm" style="text-align:left">Company</label>
                    <div class="col-md-3">
                        <select id="company" name="company"  class="form-control input-sm"  > 
                            <option value="">ALL</option>
                            <?php   
                             $sql = "select * from s_stomas where act='1'";
                             foreach ($conn->query($sql) as $row) {
                                echo "<option value='" . $row["CODE"] . "' class=\"opt\">" . $row["DESCRIPTION"] . "</option>";
                            }
                            ?>  
                       </select>
                    </div> 
                </div>   
                 <div class="form-group">
                    <label class="col-sm-1 control-label" for="invno" style="text-align:left">Sales Ex</label>
                    <div class="col-sm-3">
                        <select id="salesrep" name="salesrep" class="form-control input-sm" >
                           
                            <?php
                if ($_SESSION["MANAGER"]!="") {
                   echo "<option value='ALL'>ALL</option>";			 						
                   $sql="select * from s_salrep where pactive='1' and manager='".$_SESSION["MANAGER"]."'order by REPCODE"; 
                   $result =mysqli_query($GLOBALS['dbinv'],$sql) ; 
                   while($row = mysqli_fetch_array($result)){
                       echo "<option value='".$row["REPCODE"]."'>".$row["REPCODE"]." ".$row["Name"]."</option>";
                   }
                }else if ($_SESSION["CURRENT_REP"]=="") {
                     
                   echo "<option value='ALL'>ALL</option>";			 						
                   $sql="select * from s_salrep where pactive='1' order by REPCODE";
                   $result =mysqli_query($GLOBALS['dbinv'],$sql) ; 
                   while($row = mysqli_fetch_array($result)){
                       echo "<option value='".$row["REPCODE"]."'>".$row["REPCODE"]." ".$row["Name"]."</option>";
                   }
		} else {
                    $sql="select * from s_salrep where pactive='1' and repcode = '" . $_SESSION["CURRENT_REP"] ."' order by REPCODE"; 
                    $result =mysqli_query($GLOBALS['dbinv'],$sql) ; 
                    while($row = mysqli_fetch_array($result)){
                    echo "<option value='".$row["REPCODE"]."'>".$row["REPCODE"]." ".$row["Name"]."</option>";
                    }
                }
                ?>
                        </select>
                    </div>
            </div> 
                
                <div class="form-group">
                    <label class="col-md-1 control-label  " for="txt_usernm" style="text-align:left">Type</label>
                    <div class="col-md-3">
                        <select id="type" name="type"  class="form-control input-sm"  > 
                            <option value="DETAIL">DETAIL</option>
                            <!--<option value="SUMMERY">SUMMERY</option>-->
                       </select>
                    </div> 
                </div>   
                
                 <!--==================================================================================================================================== -->
                  
            </div> </div> 
        </form>
    </div> 
</section> 

<script>
    

</script>

 
  