 <link href="<?php echo base_url(); ?>assets/select/chosen.min.css" rel="stylesheet" media="screen">
	
		   
		   		   <script src="<?php echo base_url(); ?>assets/select/chosen.jquery.min.js"></script>
   <script>
        $(function() {
<!--             $(".datepicker").datepicker(); -->
<!--             $(".uniform_on").uniform() -->;
            $(".chzn-select").chosen();
   <!--          $('.textarea').wysihtml5(); -->

        });
        </script>

 
 <div class="row">
  
   	

   	<div class="col-md-12">

  
		

			
	<div class="widget-content nopadding table_holder table-responsive" >				
			
		 <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal">&times;</button>
        <h4 class="modal-title">Update All The VAT</h4>
      </div>
      <div class="modal-body">
      
	  <?PHP
	



 echo $this->session->flashdata('mymsg'); 
                  echo form_open('user/bulkvatpdate' , array('class' => 'form-horizontal form-groups-bordered validate',  'id' => 'signup','enctype' => 'multipart/form-data'));

		 if(validation_errors()):?>

<?php endif;?>




  
 
			  <div class="form-group">
    <label for="inputtablename" class="col-sm-2 control-label">	Type	 </label>
    <div class="col-sm-10">

	<select class="form-control" name="type"  required>
	
	<option value="" select >---Select transaction type---</option>
	<option value="All"  >Update all products</option>
	<option value="Specific"  >Update Specific products</option>


</select>
			 
				
		
		</span>
	</div>
  </div>
 
	
  
  
 
   
			
	  <div class="form-group">
    <label for="inpuoldvat" class="col-sm-4 col-lg-2 col-md-2 col-xs-4 control-label">OLD VAT</label>
    <div class="col-sm-10">
				<input type="text" name="oldvat" value="<?php echo set_value('oldvat',0); ?>"id="oldvat" class="form-control" required placeholder="Enter old VAT">
    <span class="text-danger"><?php echo form_error('oldvat'); ?></span>
   </div>
  </div>
  
   <div class="form-group">
    <label for="inputnewvat" class="col-sm-4 col-lg-2 col-md-2 col-xs-4 control-label"> NEW VAT</label>
    <div class="col-sm-10">
				<input type="text" name="newvat" value="<?php echo set_value('newvat',0); ?>"id="newid" class="form-control" required placeholder="Enter new VAT">
    <span class="text-danger"><?php echo form_error('newvat'); ?></span>
   </div>
  </div>
  
   
	 <div class="form-group">

    <div class="col-sm-offset-2 col-sm-10">
     
	         <button type="submit"  value="bulkvat" name="btn_updatevat" class="btn btn-primary"> Update Vat  in bulk </button>

    </div>
  </div>
  					<?php echo form_close();?>
			</div>							   
				
									
							
								
			<div class="modal-footer">

    

				</div>

		</div>

    <!-- Modal content-->
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal">&times;</button>
        <h4 class="modal-title">Bulk Update of User transactions</h4>
      </div>
      <div class="modal-body">
      
	  <?PHP
	



 echo $this->session->flashdata('msg'); 
                  echo form_open('user/updateaccount' , array('class' => 'form-horizontal form-groups-bordered validate',  'id' => 'signup','enctype' => 'multipart/form-data'));

		 if(validation_errors()):?>

<?php endif;?>




  
  
  
   

 
			  <div class="form-group">
    <label for="inputtablename" class="col-sm-2 control-label">	Table Name	 </label>
    <div class="col-sm-10">

	<select class="chzn-select" name="tablename" style ="width: 100%"  required>
	
	<option value=""  >---Select Receiver/Contact---</option>

	
	<?php 
					 


if(is_array($bulkupdate)) {

   foreach($bulkupdate as $bulkupdaterow){

   //echo $courserow->coursename;
    ?>
					<option value="<?=  $bulkupdaterow->table_name;   ?>"><?=  $bulkupdaterow->table_name ; ?></option>



	<?php

}} else {
    echo 'No supplier available.';
}
	
?>
</select>
			 
				
		<span class="text-danger"> <?php echo form_error('module'); ?>
		
		</span>
	</div>
  </div>
 
			 	
	  <div class="form-group">
    <label for="inputoldid" class="col-sm-4 col-lg-2 col-md-2 col-xs-4 control-label"> From(Old User id)</label>
    <div class="col-sm-10">
				<input type="text" name="oldid" value="<?php echo set_value('oldid'); ?>"id="oldid" class="form-control" required placeholder="Enter old user id">
    <span class="text-danger"><?php echo form_error('oldid'); ?></span>
   </div>
  </div>
  
   <div class="form-group">
    <label for="inputnewid" class="col-sm-4 col-lg-2 col-md-2 col-xs-4 control-label"> To(New User id)</label>
    <div class="col-sm-10">
				<input type="text" name="newid" value="<?php echo set_value('newid'); ?>"id="newid" class="form-control" required placeholder="Enter new user id">
    <span class="text-danger"><?php echo form_error('newid'); ?></span>
   </div>
  </div>
  
     <div class="form-group">
    <label for="inputcolumn" class="col-sm-4 col-lg-2 col-md-2 col-xs-4 control-label"> Column Name</label>
    <div class="col-sm-10">
				<input type="text" name="column" value="userid"id="column" class="form-control" required placeholder="Enter column name to change">
    <span class="text-danger"><?php echo form_error('column'); ?></span>
   </div>
  </div>
	 <div class="form-group">

    <div class="col-sm-offset-2 col-sm-10">
     
	         <button type="submit"  value="tables" name="btn_updatetables" class="btn btn-primary"> Update User account   </button>

    </div>
  </div>
  					<?php echo form_close();?>
			</div>							   
				
									
							
								
			<div class="modal-footer">

    

				</div>

		</div>
	  						
				
				
				
				
				
				
				
				  <!-- Modal content-->
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal">&times;</button>
        <h4 class="modal-title">Update All tables  at once per user</h4>
      </div>
      <div class="modal-body">
      
	  <?PHP
	



 echo $this->session->flashdata('mymsg'); 
                  echo form_open('user/bulktableupdate' , array('class' => 'form-horizontal form-groups-bordered validate',  'id' => 'signup','enctype' => 'multipart/form-data'));

		 if(validation_errors()):?>

<?php endif;?>




  
  
  
 
   
			
	  <div class="form-group">
    <label for="inputoldid" class="col-sm-4 col-lg-2 col-md-2 col-xs-4 control-label"> From(Old User id)</label>
    <div class="col-sm-10">
				<input type="text" name="oldid" value="<?php echo set_value('oldid'); ?>"id="oldid" class="form-control" required placeholder="Enter old user id">
    <span class="text-danger"><?php echo form_error('oldid'); ?></span>
   </div>
  </div>
  
   <div class="form-group">
    <label for="inputnewid" class="col-sm-4 col-lg-2 col-md-2 col-xs-4 control-label"> To(New User id)</label>
    <div class="col-sm-10">
				<input type="text" name="newid" value="<?php echo set_value('newid'); ?>"id="newid" class="form-control" required placeholder="Enter new user id">
    <span class="text-danger"><?php echo form_error('newid'); ?></span>
   </div>
  </div>
  
     <div class="form-group">
    <label for="inputcolumn" class="col-sm-4 col-lg-2 col-md-2 col-xs-4 control-label"> Column Name</label>
    <div class="col-sm-10">
				<input type="text" name="column" value="userid"id="column" class="form-control" required placeholder="Enter column name to change">
    <span class="text-danger"><?php echo form_error('column'); ?></span>
   </div>
  </div>
	 <div class="form-group">

    <div class="col-sm-offset-2 col-sm-10">
     
	         <button type="submit"  value="bulkupdate" name="btn_updatebulktables" class="btn btn-primary"> Update User account   </button>

    </div>
  </div>
  					<?php echo form_close();?>
			</div>							   
				
									
							
								
			<div class="modal-footer">

    

				</div>

		</div>
	  			
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
			
			</div>
		</div>
								
									
									
									
							</div>
						</div>
				

			
			</div>



















