<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

include "../core/autoload.php";
include "../core/modules/index/model/ProductData.php";
include "../core/modules/index/model/OperationData.php";
include "../core/modules/index/model/OperationTypeData.php";

require_once '../core/controller/PhpWord/Autoloader.php';
use PhpOffice\PhpWord\Autoloader;
use PhpOffice\PhpWord\Settings;

Autoloader::register();

$word = new  PhpOffice\PhpWord\PhpWord();
$products = ProductData::getAll();


$section1 = $word->AddSection();
$section1->addText("INVENTARIO",array("size"=>22,"bold"=>true,"align"=>"right"));


$styleTable = array('borderSize' => 6, 'borderColor' => '888888', 'cellMargin' => 40);
$styleFirstRow = array('borderBottomColor' => '0000FF', 'bgColor' => 'AAAAAA');

$table1 = $section1->addTable("table1");
$table1->addRow();
$table1->addCell()->addText("Id");
$table1->addCell()->addText("Nombre");
$table1->addCell()->addText("Por Recibir");
$table1->addCell()->addText("Disponible");
$table1->addCell()->addText("Por Entregar");
foreach($products as $product){
//    $q=OperationData::getQYesF($product->id);
	$r=OperationData::getRByStock($product->id,$_GET["stock_id"]);
	$q=OperationData::getQByStock($product->id,$_GET["stock_id"]);
	$d=OperationData::getDByStock($product->id,$_GET["stock_id"]);


$table1->addRow();
$table1->addCell(300)->addText($product->id);
$table1->addCell(11000)->addText($product->name);
$table1->addCell(500)->addText($r);
$table1->addCell(500)->addText($q);
$table1->addCell(500)->addText($d);

}

$word->addTableStyle('table1', $styleTable,$styleFirstRow);
/// datos bancarios

$filename = "inventary-".time().".docx";
#$word->setReadDataOnly(true);
$word->save($filename,"Word2007");
//chmod($filename,0444);
header("Content-Disposition: attachment; filename='$filename'");
readfile($filename); // or echo file_get_contents($filename);
unlink($filename);  // remove temp file



?>