<?php
namespace App\Service;
use Symfony\Component\HttpFoundation\RequestStack;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Component\Security\Core\Security;
use Symfony\Component\HttpFoundation\Session\Session;
class EcomService
{
private $em;
private $request;
private $security;
public function __construct(EntityManagerInterface $entityManager, Security $security, RequestStack $request)
{
$this->em = $entityManager;
$this->request = $request;
$this->security = $security;
}
public function textcontent($path, $def='')
{
$content = $this->em->getRepository('App\Entity\Content')->findOneByPath($path);
if($content != null)
return $content->getBody();
else
return $def;
}
public function imagecontent($path)
{
$content = $this->em->getRepository('App\Entity\Content')->findOneByPath($path);
$contentimages = $this->em->getRepository('App\Entity\ContentImage')->findByContentId($content->getId());
if($content != null)
return array('content'=>$content, 'images'=>$contentimages);
else
return array('content'=>'', 'images'=>array());
}
public function checkphoto($photo)
{
$profilepic = file_exists('uploads/profile/' . $photo)?'uploads/profile/' . $photo:'img/profile_def.jpg';
return $profilepic;
}
public function productcategories()
{
$menu = array();
$submenu = array();
$productcategories = $this->em->getRepository('App\Entity\ProductCategory')->findByStatus(1);
return $productcategories;
}
public function menu()
{
$globalcategories = $this->em->getRepository('App\Entity\GlobalCategory')->findAll();
$menu = array();
$submenu = array();
$stylemenu = array();
foreach ($globalcategories as $gc) {
$productcategories = $this->em->getRepository('App\Entity\ProductCategory')->findByGlobalCategory($gc->getId());
$menu[] = array('id'=>$gc->getId(), 'name'=>$gc->getName(), 'type'=>'global_category');
$submenu[$gc->getId()] = array();
foreach ($productcategories as $pc) {
$submenu[$gc->getId()][] = array('id'=>$pc->getId(), 'name'=>$pc->getName(), 'type'=>'product_category');
foreach ($productcategories as $pc) {
$menu[] = array('id'=>$pc->getId(), 'name'=>$pc->getName(), 'type'=>'product_category');
$styles = $this->em->getRepository('App\Entity\Style')->findByProductCategory($pc->getId());
$stylemenu[$pc->getId()] = array();
foreach ($styles as $s) {
$stylemenu[$pc->getId()][] = array('id'=>$s->getId(), 'name'=>$s->getName(), 'type'=>'style');
}
}
}
}
return array('menu'=>$menu, 'submenu'=>$submenu, 'stylemenu'=>$stylemenu);
}
public function cartdetails()
{
$order = null;
$session = $this->request->getSession();
//$session = $this->container->get('session');
if($this->security->getUser()) {
$order = $this->em->getRepository('App\Entity\Orders')->findOneBy(['userId'=>$this->security->getUser()->getId(), 'stage'=>['Cart', 'Checkout', 'Review', 'Payment']], ['id'=>'DESC']);
if($order==null && !empty($session->get('order_id'))) {
$order = $this->em->getRepository('App\Entity\Orders')->findOneBy(['orderId'=>$session->get('order_id')]);
}
}
elseif(!empty($session->get('order_id'))) {
$order = $this->em->getRepository('App\Entity\Orders')->findOneBy(['orderId'=>$session->get('order_id')]);
}
if($order != null) {
$cartcount = $this->em->createQuery("SELECT SUM(o.quantity) FROM App\Entity\OrderItem o WHERE o.orderId=:oid")->setParameters(['oid'=>$order->getId()])->getSingleScalarResult();
$cartitems = $this->em->createQuery("SELECT li.id, li.productId, p.title, p.path, u.firstname, u.lastname, li.amount, li.quantity, li.total, pi.image, p.style, s.name stylename, v.color, c.name colorname, v.size, z.name sizename FROM App\Entity\OrderItem li, App\Entity\Product p, App\Entity\User u, App\Entity\Style s, App\Entity\Color c, App\Entity\ProductImage pi, App\Entity\ProductVariation v LEFT JOIN App\Entity\Size z WITH v.size=z.id WHERE p.id=li.productId AND v.id=li.variantId AND p.id=pi.productId AND p.createdBy=u.id AND v.color=c.id AND p.style=s.id AND li.itemType='Product' AND li.orderId=:oid GROUP BY p.id ORDER BY pi.weight")->setParameters(['oid'=>$order->getId()])->getArrayResult();
$address = $this->em->getRepository('App\Entity\Address')->find($order->getShippingAddressId());
}
else {
$cartcount = 0;
$cartitems = array();
$order = array();
}
return array('order'=>$order, 'cartcount'=>$cartcount, 'cart'=>$cartitems);
}
public function locations()
{
$countries = $this->em->getRepository('App\Entity\CountriesCountry')->findAll();
$usa_states = array("AA"=>"AA","AE"=>"AE","AP"=>"AP","AL"=>"Alabama","AK"=>"Alaska","AS"=>"American Samoa","AZ"=>"Arizona","AR"=>"Arkansas","CA"=>"California","CO"=>"Colorado","CT"=>"Connecticut","DE"=>"Delaware","DC"=>"District of Columbia","FM"=>"Federated States of Micronesia","FL"=>"Florida","GA"=>"Georgia","GU"=>"Guam","HI"=>"Hawaii","ID"=>"Idaho","IL"=>"Illinois","IN"=>"Indiana","IA"=>"Iowa","KS"=>"Kansas","KY"=>"Kentucky","LA"=>"Louisiana","ME"=>"Maine","MH"=>"Marshall Islands","MD"=>"Maryland","MA"=>"Massachusetts","MI"=>"Michigan","MN"=>"Minnesota","MS"=>"Mississippi","MO"=>"Missouri","MT"=>"Montana","NE"=>"Nebraska","NV"=>"Nevada","NH"=>"New Hampshire","NJ"=>"New Jersey","NM"=>"New Mexico","NY"=>"New York","NC"=>"North Carolina","ND"=>"North Dakota","MP"=>"Northern Mariana Islands","OH"=>"Ohio","OK"=>"Oklahoma","OR"=>"Oregon","PW"=>"Palau","PA"=>"Pennsylvania","PR"=>"Puerto Rico","RI"=>"Rhode Island","SC"=>"South Carolina","SD"=>"South Dakota","TN"=>"Tennessee","TX"=>"Texas","UT"=>"Utah","VT"=>"Vermont","VI"=>"Virgin Islands","VA"=>"Virginia","WA"=>"Washington","WV"=>"West Virginia","WI"=>"Wisconsin","WY"=>"Wyoming");
return array('countries'=>$countries, 'states'=>$usa_states);
}
public function cities()
{
$cities = $this->em->getRepository('App\Entity\City')->findByStatus(1, ['access'=>'DESC']);
return $cities;
}
}