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

       
       <section class="content">
          <div class="row">
            <div class="col-xs-12">
				
				<!-- ALERTS -->
				<?php if($_GET['y'] == '1') { ?>
				<div class="callout callout-success">
                    <h4><?php echo $lang['ALERT_PRODUCT_NEW']; ?></h4>
                    <p><?php echo $lang['ALERT_PRODUCT_NEW_TXT']; ?></p>
                  </div>
				<?php } ?>
				<?php if($_GET['y'] == '2') { ?>
				<div class="callout callout-success">
                    <h4><?php echo $lang['ALERT_PRODUCT_UPDATE']; ?></h4>
                    <p><?php echo $lang['ALERT_PRODUCT_UPDATE_TXT']; ?></p>
                  </div>
				<?php } ?>
				<?php if($_GET['y'] == '3') { ?>
				<div class="callout callout-success">
                    <h4><?php echo $lang['ALERT_PRODUCT_DELETE']; ?></h4>
                    <p><?php echo $lang['ALERT_PRODUCT_DELETE_TXT']; ?></p>
                  </div>
				<?php } ?>
				
              <div class="box">
                <div class="box-header">
                 <a class="btn btn-success" href="?mod=NewProduct"><?php echo $lang['NEW_BTN_PRODUCT']; ?></a>
                </div><!-- /.box-header -->
                <div class="box-body">
                  <table id="tabela" class="table table-striped table-hover">
                    <thead>
                      <tr>
                        <th><?php echo $lang['PRODUCT_NAME']; ?></th>
                        <th><?php echo $lang['PRODUCT_GROUP']; ?></th>
                        <th><?php echo $lang['PRODUCT_SERVER']; ?></th>
                        <th><?php echo $lang['PRODUCT_PRICE']; ?></th>
                        <th><?php echo $lang['PRODUCT_ACC']; ?></th>
                        <th><?php echo $lang['STATUS']; ?></th>
                        <th><?php echo $lang['ACTIONS']; ?></th>
                      </tr>
                    </thead>
                    <tbody>
					<?php
 		  			$query = mysql_query("SELECT p.*, c.name AS name, s.server AS server FROM products AS p INNER JOIN groups AS c ON p.p_group = c.id INNER JOIN servers AS s ON p.server = s.id order by p.id DESC");
 		  			while($result = mysql_fetch_array($query)){ 
				    $product = $result['id'];
					$cmd = mysql_query("SELECT * FROM invoices_tbl WHERE service = '$product'");
			        $acc_total = mysql_num_rows($cmd);
					?>

 		  							
					
		            <tr>
		            <td><?php echo $result['product']; ?></td>
		            <td><?php echo $result['name']; ?></td>
		            <td><?php echo $result['server']; ?></td>
		            <td><?php echo number_format($result['price'],2,'.',''); ?></td>
		            <td><b><?php echo $acc_total; ?></b></td>
		            <td><?php if($result['status'] == 'S') { ?> <?php echo $lang['ACTIVE']; ?> <? } else { ?> <?php echo $lang['BLOCK']; ?> <?php } ?></td>
		            <td>
					<div class="btn-group">
                      <button type="button" class="btn btn-info btn-sm"><?php echo $lang['ACTIONS']; ?></button>
                      <button type="button" class="btn btn-info btn-sm dropdown-toggle" data-toggle="dropdown">
                        <span class="caret"></span>
                        <span class="sr-only">Toggle Dropdown</span>
                      </button>
                      <ul class="dropdown-menu" role="menu">
                        <li><a href="?mod=NewProduct&id=<?php echo base64_encode($result['id']); ?>"><?php echo $lang['BTN_UPDATE']; ?></a></li>
                        <li class="divider"></li>
                        <li><a href="javascript:void(0);" onclick="javascript: if (confirm('<?php echo $lang['ALERT_BTN_DELETE']; ?>')) { window.location.href='?mod=NewProduct&id=<?php echo base64_encode($result['id']); ?>&action=delete' } else { void('') };"><?php echo $lang['BTN_DELETE']; ?></a></li>
                      </ul>
                    </div>
                    
                    </td>
		            </tr>
					<?php } ?>
					
                    </tbody>
                    <tfoot>
                      <tr>
                        <th><?php echo $lang['PRODUCT_NAME']; ?></th>
                        <th><?php echo $lang['PRODUCT_GROUP']; ?></th>
                        <th><?php echo $lang['PRODUCT_SERVER']; ?></th>
                        <th><?php echo $lang['PRODUCT_PRICE']; ?></th>
                        <th><?php echo $lang['PRODUCT_ACC']; ?></th>
                        <th><?php echo $lang['STATUS']; ?></th>
                        <th><?php echo $lang['ACTIONS']; ?></th>
                      </tr>
                    </tfoot>
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
       
           </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
       
       
        
        
      </div><!-- /.content-wrapper -->
   
   
   
   
