/**
* @return Product
*/
public function setDataToObject()
{
$this->object->setSku($this->getFormattedData('sku', 'string'));
$this->object->setName($this->getFormattedData('name', 'string'));
$this->object->setPicture($this->getFormattedData('picture', 'string'));
$this->object->setUrl($this->getFormattedData('url', 'string'));
$this->object->setManufacturer($this->getFormattedData('manufacturer', 'string'));
$this->object->setCategory($this->getFormattedData('category', 'string'));
$this->object->setCategoryOuterId($this->getFormattedData('categoryOuterId', 'string'));
$this->object->setIsDescription($this->getFormattedData('isDescription', 'integer'));
$this->object->setStatus($this->getFormattedData('status', 'integer'));
$this->object->setAvailableDate($this->getFormattedData('availableDate', 'date'));
$this->object->setProductCreateDate($this->getFormattedData('productCreateDate', 'date'));
parent::setDataToObject();
}
protected function execute(InputInterface $input, OutputInterface $output)
{
// use api parameters from a settings file
// Make api call to get list of products
$products = $this->getListPromotionProducts();
$productUrls = $this->array_value_recursive('productUrl', $products);
// Make api call to get the affiliate url for each product
$affiliateUrls = $this->getPromotionLinks($productUrls);
/*
* Store product feed in db
*/
// $category = new Category();
// $category->setName('Apparel');
$category = $this->getContainer()->get('doctrine')->getRepository('AppBundle:Category')->find(1);
foreach ($products as $key => $p) {
$product = new Product();
$product->setCategory($category)->setAliProductId($p['productId'])->setAliProductTitle($p['productTitle'])->setAliProductUrl($p['productUrl'])->setAliSalePrice(round(floatval(substr($p['salePrice'], 4))))->setAli30DaysCommission($p['30daysCommission'])->setAliVolume($p['volume'])->setAliCategoryId($options['categoryId'])->setAliAffiliateUrl($affiliateUrls[$key]['promotionUrl']);
$em = $this->getEntityManager('default');
$em->persist($product);
$em->persist($category);
$em->flush();
// $output->writeln($p['productTitle']);
}
echo 'just sent ' . count($products) . ' products to the db' . "\n\n";
// call get:photos command for each photo to see scrape pics from ali site
}
/**
* {@inheritDoc}
* @see \Doctrine\Common\DataFixtures\FixtureInterface::load()
*/
public function load(ObjectManager $manager)
{
// Recogemos la ubicación del proyecto symfony
$symfony_app_base_dir = $this->container->getParameter('kernel.root_dir');
// Añadimos mediante fichero .csv nuevos registros a la base de datos.
// abrimos el fichero y lo recorremos en modo lectura
$row = 0;
$fd = fopen($symfony_app_base_dir . '/Resources/data/products.csv', "r");
if ($fd) {
while (($data = fgetcsv($fd, 1000, ",")) !== false) {
$row++;
if ($row == 1) {
continue;
}
// Creamos el objeto
$product = new Product();
// Recogemos el objeto del fichero
$product->setName($data[0]);
$product->setDescription($data[1]);
$product->setCategory($this->getReference($data[2]));
$product->setPrice($data[3]);
$manager->persist($product);
// alamacenamos en la base de datos.
$manager->flush();
$this->addReference($product->getName(), $product);
}
fclose($fd);
// se cierra el fichero
}
}
protected function setObjects()
{
$this->object->setSku('');
$this->object->setName('');
$this->object->setPicture('');
$this->object->setUrl('');
$this->object->setManufacturer('');
$this->object->setCategory('');
$this->object->setProductCreateDate(new \DateTime());
$object = new ProductInformation();
$object->setInformationKey('i1');
$object->setInformationValue('v4');
$object->setProduct($this->object);
$this->informationObjects[] = $object;
$object = new ProductInformation();
$object->setInformationKey('i2');
$object->setInformationValue('v4');
$object->setProduct($this->object);
$this->informationObjects[] = $object;
}
public function load(ObjectManager $manager)
{
$faker = Factory::create();
for ($i = 0; $i < 1000; $i++) {
$product = new Product();
$product->setName(ucfirst($faker->word));
$product->setDescription(ucfirst($faker->text));
$product->setPrice(ucfirst($faker->randomFloat(2, 10, 9999)));
$product->setAmount(ucfirst($faker->numberBetween(0, 20)));
$product->setCategory($this->getReference('category-' . $faker->numberBetween(1, 100)));
$manager->persist($product);
}
$manager->flush();
}
public function createAction()
{
$category = new Category();
$category->setName('Good stuff');
$product = new Product();
$product->setName('Brown stuff');
$product->setPrice('9.99');
$product->setDescription('Coffee from Kenya');
$product->setCategory($category);
$em = $this->getDoctrine()->getManager();
$em->persist($category);
$em->persist($product);
$em->flush();
return new Response('Created product id ' . $product->getId() . ' and category id ' . $category->getId());
}
public function indexAction()
{
$categories = new Categories();
$categories->setName('Computer Peripherals');
$product = new Product();
$product->setName('Keyboard');
$product->setPrice(19.99);
$product->setDescription('Ergonomic and stylish!');
$product->setCategory($categories);
$em = $this->getDoctrine()->getManager();
$em->persist($categories);
$em->persist($product);
$em->flush();
return new Response('<html><head></head><body>Test</body></html>');
}
/**
* Relation controller.
*
* @Route("/relation")
*/
public function relationAction()
{
$category = new Category();
$category->setName('Prodotti principali');
$product = new Product();
$product->setName('Test');
$product->setPrice(19.99);
$product->setDescription('prodotto di test');
// correlare questo prodotto alla categoria
$product->setCategory($category);
$em = $this->getDoctrine()->getManager();
$em->persist($category);
$em->persist($product);
$em->flush();
return new Response('Creati prodotto con id: ' . $product->getId() . ' e categoria con id: ' . $category->getId());
}
/**
* @Route("/db/create_relationship/")
* @return Response
*/
public function createProductAction()
{
$category = new Category();
$category->setName('Main Products');
$product = new Product();
$product->setName('Foo');
$product->setPrice(19.99);
$product->setDescription('Lorem ipsum dolor');
// relate this product to the category
$product->setCategory($category);
$em = $this->getDoctrine()->getManager();
$em->persist($category);
$em->persist($product);
$em->flush();
return new Response('Created product id: ' . $product->getId() . ' and category id: ' . $category->getId());
}
public function addProduct($name, $categoryName = null)
{
$category = null;
if ($categoryName != null) {
$category = $this->addCategory($categoryName);
}
$product = $this->getProduct($name);
if ($product == null) {
$product = new Product();
$product->setName($name);
$product->setPrice(0);
$product->setCategory($category);
$this->em->persist($product);
} else {
$product->setCategory($category);
}
return $product;
}
public function createStaticAction()
{
// Creamos el objeto category y seleccionamos categoria entre 0-10 mediante random
$category = new Category();
$category->setName(sprintf("Category%d", rand(0, 10)));
// Creamos el objeto producto con todos sus atributos.
$product = new Product();
$product->setName('Arroz');
$product->setPrice('0.99');
$product->setDescription('Paquete de 1kg de arroz');
//relacionamos con categoría
$product->setCategory($category);
// recogemos el manager
$em = $this->getDoctrine()->getManager();
// persistimos
$em->persist($category);
$em->persist($product);
// alamacenamos en la base de datos.
$em->flush();
return $this->Render('product/staticProduct.html.twig', array('product' => $product));
}
/**
* @Route("{_locale}/product/create/{name}/{price}", name="product_create",
* requirements={
* "name": "[A-Za-z0-9\s-]+",
* "price" : "\d{2}(\.\d{2})?"
* })
*/
public function createParamAction($name, $price)
{
$em = $this->getDoctrine()->getManager();
$categories = $this->getDoctrine()->getRepository('AppBundle:Category')->findAll();
if (!$categories) {
$category = new Category();
$category->setName('Default Category');
$em->persist($category);
} else {
$category = $categories[rand(0, count($categories) - 1)];
}
$product = new Product();
$product->setName($name);
$product->setPrice($price);
$product->setDescription(sprintf('Description de %s', $name));
// relacionamos con categoría
$product->setCategory($category);
$em->persist($product);
$em->flush();
return $this->render('dws/message.html.twig', array('message' => sprintf("Producto %s(%d) creado!!", $product->getName(), $product->getId())));
}
public function load(ObjectManager $manager)
{
$symbonfy_base_dir = $this->container->getParameter('kernel.root_dir');
$data_dir = $symbonfy_base_dir . '/Resources/data/';
$row = 0;
if (($fd = fopen($data_dir . 'products.csv', "r")) !== FALSE) {
while (($data = fgetcsv($fd, 1000, ",")) !== FALSE) {
$row++;
if ($row == 1) {
continue;
}
//skip header
$product = new Product();
$product->setName($data[0]);
$product->setDescription($data[1]);
$product->setCategory($this->getReference($data[2]));
$product->setPrice($data[3]);
$manager->persist($product);
}
fclose($fd);
}
$manager->flush();
}
/**
* @Route("/product/new", name="new_product")
*/
public function createAction()
{
$validator = $this->get('validator');
$category = new Category();
$category->setName('Main Products');
$errors = $validator->validate($category);
if (count($errors) > 0) {
return $this->render('product/validation.html.twig', array('errors' => $errors));
}
$product = new Product();
$product->setName('');
$product->setPrice('19.99');
$product->setDescription('Lorem ipsum dolor');
$product->setCategory($category);
$errors = $validator->validate($product);
if (count($errors) > 0) {
return $this->render('product/validation.html.twig', array('errors' => $errors));
}
$em = $this->getDoctrine()->getManager();
$em->persist($category);
$em->persist($product);
$em->flush();
return new Response('Created product id: ' . $product->getId() . ' and category id: ' . $category->getId());
}
/**
* Add product
*
* @param \AppBundle\Entity\Product $product
*
* @return Category
*/
public function addProduct(Product $product)
{
$product->setCategory($this);
$this->products[] = $product;
return $this;
}
/**
* @Route("/product/createProduct", name="createProduct")
*/
public function createProductAction()
{
$category = new Category();
$category->setName('Main Products');
$product = new Product();
$product->setName('Segon');
$product->setPrice(20);
$product->setDescription('descripció');
$product->setCategory($category);
$em = $this->getDoctrine()->getManager();
$em->persist($category);
$em->persist($product);
$em->flush();
return new Response('Created product id: ' . $product->getId() . ' and category id: ' . $category->getId());
}
