<?php
      require_once(__DIR__ .'/../vendor/autoload.php');
      // INCLUDE DB CONFIG
      $dbconfig = __DIR__."/config.php";
      include ($dbconfig);
      // INCLUDED DB CONFIG

      \Reportico\Engine\Builder::build()
          ->datasource()->database("mysql:host=localhost; dbname=reportico")->user($examples_user)->password($examples_password)
          ->title     ("Product Stock")
          ->description     ("Produces a list of our products")
          ->sql       ("
              SELECT  ProductID id, ProductName product, UnitsInStock in_stock, UnitsOnOrder on_order, companyname company, country, categoryname category
              FROM northwind_products 
              join northwind_suppliers on northwind_products.supplierid = northwind_suppliers.supplierid
              join northwind_categories on northwind_products.categoryid = northwind_categories.categoryid
              WHERE 1 = 1  
              ORDER BY categoryname
                ")
          ->group("category")
              ->header("category")
              ->customHeader( "Custom Header: Stock Levels for category: {category}", "height: 10; margin: 25px 0 25px 0; text-align: center; width: 100%; border-style: solid; border-color: #00f; border-width: 2px"  )
              ->customTrailer( "Custom Trailer: End of Group", "height: 10; margin: 25px 0 0 0; text-align: center; width: 100%; border-style: solid; border-color: #00f; border-width: 2px"  )
              ->throwPageBefore()
          ->page()
            ->paginate()
            //->pagetitledisplay("Off")
            //->orientation("landscape")
            ->header("{REPORT_TITLE}", "border-width: 0px 0px 1px 0px; margin: 25px 0px 0px 0px; border-color: #000000; font-size: 18; border-style: solid;padding:0px 0px 0px 0px; width: 100%; background-color: inherit; color: #000; margin-left: 0%;margin-bottom: 70px;text-align:center")
            ->header( "", "width: 100; height: 50; margin: 5px 0 0 0; background-image:assets/images/reportico100.png'"  )
            ->footer( 'Page: {PAGE} of {PAGETOTAL}', 'border-width: 1 0 0 0; top: 0px; font-size: 8pt; margin: 2px 0px 0px 0px; font-style: italic; margin-top: 30px;'  )
            ->footer( 'Time: date(\'Y-m-d H:i:s\')', 'font-size: 8pt; text-align: right; font-style: italic; width: 100%; margin-top: 30px;'  )
            ->pdfengine("chromium")
            ->pdfDownloadMethod("inline")
            ->to( "PDF" )
          ->execute();
?>