Product Catalogs

<?php
require_once "Products.php";
$products = new Products();
$products->run()->render();
?>    

<?php
require_once "../../../load.koolreport.php";

use \koolreport\processes\Filter;

class Products extends koolreport\KoolReport
{
    function settings()
    {
        return array(
            "dataSources"=>array(
                "products"=>array(
                'filePath' => '../../../databases/products.csv',
                'fieldSeparator' => '|',
                'class' => "\koolreport\datasources\CSVDataSource"      
                ),
            )
        );
    }
    
    function setup()
    {
        $node = $this->src('products')
        ->pipe(new Filter(array(
            array('productLine', '=', 'Ships'),
        )))
        ->pipe($this->dataStore('products'));  
    }
}

<?php
use \koolreport\widgets\koolphp\Table;
use \koolreport\barcode\BarCode;
use \koolreport\barcode\QRCode;
?>
<div class="report-content">
<style type="text/css">
    a.pk
    {
        color:#333 !important;
        text-decoration:none !important;
    }
    div.thumbnail:hover
    {
        box-shadow: 0 6px 10px 0 rgba(0,0,0,.14), 0 1px 18px 0 rgba(0,0,0,.12), 0 3px 5px -1px rgba(0,0,0,.2);
    }
    div.thumbnail div.img img
    {
        width:200px;
    }
    div.thumbnail div.img
    {
        text-align:center;
        padding-top:15px;
    }    
    div.thumbnail span.price
    {
        margin-top:2px;
        font-weight:bold;
    }
    div.thumbnail .pk-info h3
    {
        text-align:center;
        margin-top: 0;
    }
    div.thumbnail .pk-info p
    {
      color: #888;
        font-size: 14px;
    }
    div.barcode {
        margin-top: 10px;
        text-align:center;
        color:#777;
        font-size:14px;
        font-weight:bold; 
        letter-spacing: 3px;
    }
    div.vendor {
      text-align: right;
      font-weight: bold;
    }
    div.kreport-title {
      // text-align: center;
    }
    div.website {
      text-align: center;
      margin-bottom: 20px;
    }
  </style>
  <div class='kreport-title'>
    <table style="width:100%;">
      <tr>
        <td style="vertical-align:bottom"><h1>Product Catalogs</h1></td>
        <td class="text-right">
          <?php
            QRCode::create(array(
            "format" => "svg",
            "value"=>"https://www.koolreport.com",
            'size' => 100
          ));
          ?>        
        </td>
      </tr>
    </table>
  </div>
  <div class='row kreport-horizontal-line-0'> </div>
  
  <?php
    // Table::create(array(
      // "dataStore"=>$this->dataStore('products'),
    // ));
  
    $data = $this->dataStore('products')->data();
    $len = count($data);
    $numRow = floor($len / 3);
    
    for ($i=0; $i<$numRow; $i++) {
      ?>
      <div class='row'>
      <?php
      for ($j=0; $j<3; $j++) {
        $index = $i * 3 + $j;
        $row = $data[$index];
        $productCode = $row['productCode'];
        $code = (string)str_replace('_', '', substr($productCode, 1));
        // echo $code;
        ?>
        <div class="col-md-4">
          <a href="#" class="pk">
            <div class="card">
              <img class="card-img-top" src="img/<?php echo $code;?>.jpg" alt="...">
              <div class='barcode'>
                <?php
                  BarCode::create(array(
                    "format" => "svg",
                    "value"=>$code,
                    "type"=>"TYPE_EAN_8"
                  ));
                  echo '<br>' . $code;
                ?>
              </div>
              <div class="card-body">
                <div class="pk-info">
                    <h3><strong><?php echo $row['productName']; ?></strong></h3>
                    <p><?php echo $row['productDescription']; ?></p>
                </div>
                <table style="width:100%;">
                  <tbody>
                    <tr>
                      <td><b><?php echo $row['productVendor']; ?></b></td>
                      <td class="text-right text-primary" style="vertical-align:bottom;"><b><?php echo '$' . $row['buyPrice']; ?></b></td>
                    </tr>
                  </tbody>
                </table>
                <div class="row">
                  <div class="col-xs-8"></div>
                  <div  ></div>
                </div>
              </div>
            </div>
          </a>
        </div>
        <?php            
      }
      ?>
      </div>
      <?php
    }
    
  ?>
  
  
  
</div>