
    <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            <?php echo $lang['TITLE_LIST_INVOICES_CANCEL']; ?>
          </h1>
          
        </section>

       
       <section class="content">
          <div class="row">
            <div class="col-xs-12">
				
			
              <div class="box">
				  
                <div class="box-header">Invoices
                
                </div><!-- /.box-header -->
                <div class="box-body">
                  <table id="tabela" class="table table-striped table-hover">
                    <thead>
                      <tr>
                        <th><?php echo $lang['INVOICE']; ?></th>
                        <th><?php echo $lang['CUSTOMER']; ?></th>
                        <th><?php echo $lang['TOTAL']; ?></th>
                        <th><?php echo $lang['PAYMENT']; ?></th>
                        <th><?php echo $lang['DATE']; ?></th>
                        <th><?php echo $lang['PAYMENT_DATE']; ?></th>
                      </tr>
                    </thead>
                    <tbody>
					<?php
 		  			$query = mysql_query("SELECT * FROM invoices WHERE status = 'canceled' order by id DESC");
 		  			while($result = mysql_fetch_array($query)){ 
						$idc = $result['customer'];
						$querycs = mysql_query("SELECT * FROM customers WHERE id = '$idc'");
 		  			    $customer = mysql_fetch_array($querycs);
					?>
		            <tr class="danger">
					
		            <td>#<?php echo $result['invoice']; ?></td>
		            <td><?php echo $customer['name']; ?></td>
		            
		            <td><?php echo number_format($result['total'],2,'.',''); ?></td>
					<td><?php echo $result['payment']; ?></td>
					<td><?php echo data_en($result['date']); ?></td>
					<td><?php echo data_en($result['payment_date']); ?></td>
					
					
		           
                    
		            </tr>
					<?php } ?>
					
                    </tbody>
                    <tfoot>
                      <tr>
                        <th><?php echo $lang['CATEGORY']; ?></th>
                        
                        <th><?php echo $lang['ACTIONS']; ?></th>
                      </tr>
                    </tfoot>
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
       
           </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
       
       
        
        
      </div><!-- /.content-wrapper -->
   
   
   
   
