/** * Get all attributes for selected product. * * Each attribute has a new price. * * @param * integer idproduct * @param * integer idclient (0 by default) * @return array with attributes' product informations * @throws on error FrontendException object will be returned * @access public */ public function getAttributesForProductById($id) { $clientGroupId = Session::getActiveClientGroupid(); if (!empty($clientGroupId)) { $sql = "SELECT\n\t\t\t\t\t\tP.idproduct as id,\n\t\t\t\t\t\tPAS.stock,\n\t\t\t\t\t\tPAS.idproductattributeset,\n\t\t\t\t\t\tPAS.`value`,\n\t\t\t\t\t\tPAS.symbol,\n\t\t\t\t\t\tAT.name as availablity,\n\t\t\t\t\t\tPAS.photoid as photoid,\n\t\t\t\t\t\tPAS.symbol,\n\t\t\t\t\t\tIF(PAS.weight IS NULL, P.weight, PAS.weight) AS weight,\n\t\t\t\t\t\tPAVS.idproductattributevalueset,\n\t\t\t\t\t\tPAVS.productattributesetid AS attributesgroup,\n\t\t\t\t\t\tAPV.name AS attributename,\n\t\t\t\t\t\tAPV.idattributeproductvalue AS attributeid,\n\t\t\t\t\t\tAP.name AS attributegroupname,\n\t\t\t\t\t\tAP.idattributeproduct AS attributegroupid,\n\t\t\t\t\t\tIF(PGP.promotion = 1 AND IF(PGP.promotionstart IS NOT NULL, PGP.promotionstart <= CURDATE(), 1) AND IF(PGP.promotionend IS NOT NULL, PGP.promotionend >= CURDATE(), 1),\n\t\t\t\t\t\t\tCASE PAS.suffixtypeid\n \tWHEN 1 THEN PGP.discountprice * (PAS.value / 100)\n WHEN 2 THEN PGP.discountprice + PAS.value\n WHEN 3 THEN PGP.discountprice - PAS.value\n \tWHEN 4 THEN PAS.`value`\n END,\n\t\t\t\t\t\t\tIF(PGP.groupprice IS NULL AND P.promotion = 1 AND IF(P.promotionstart IS NOT NULL, P.promotionstart <= CURDATE(), 1) AND IF(P.promotionend IS NOT NULL, P.promotionend >= CURDATE(), 1),\n\t\t\t\t\t\t\t\tPAS.discountprice,\n\t\t\t\t\t\t\t\tIF(PGP.sellprice IS NOT NULL,\n\t\t\t\t\t\t\t\t\tCASE PAS.suffixtypeid\n\t\t \tWHEN 1 THEN PGP.sellprice * (PAS.value / 100)\n\t\t WHEN 2 THEN PGP.sellprice + PAS.value\n\t\t WHEN 3 THEN PGP.sellprice - PAS.value\n\t\t \tWHEN 4 THEN PAS.`value`\n\t \tEND,\n\t\t\t\t\t\t\t\t\tPAS.attributeprice\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t) * CR.exchangerate AS attributeprice,\n\t\t\t\t\t\t(PAS.attributeprice * CR.exchangerate) AS attributepricenettobeforepromotion,\n\t\t\t\t\t\t(PAS.attributeprice * (1 + (V.value / 100)) * CR.exchangerate) AS attributepricegrossbeforepromotion,\n\t\t\t\t\t\tIF(PGP.promotion = 1 AND IF(PGP.promotionstart IS NOT NULL, PGP.promotionstart <= CURDATE(), 1) AND IF(PGP.promotionend IS NOT NULL, PGP.promotionend >= CURDATE(), 1),\n\t\t\t\t\t\t\tCASE PAS.suffixtypeid\n \tWHEN 1 THEN PGP.discountprice * (PAS.value / 100)\n WHEN 2 THEN PGP.discountprice + PAS.value\n WHEN 3 THEN PGP.discountprice - PAS.value\n \tWHEN 4 THEN PAS.`value`\n END,\n\t\t\t\t\t\t\tIF(PGP.groupprice IS NULL AND P.promotion = 1 AND IF(P.promotionstart IS NOT NULL, P.promotionstart <= CURDATE(), 1) AND IF(P.promotionend IS NOT NULL, P.promotionend >= CURDATE(), 1),\n\t\t\t\t\t\t\t\tPAS.discountprice,\n\t\t\t\t\t\t\t\tIF(PGP.sellprice IS NOT NULL,\n\t\t\t\t\t\t\t\t\tCASE PAS.suffixtypeid\n\t\t \tWHEN 1 THEN PGP.sellprice * (PAS.value / 100)\n\t\t WHEN 2 THEN PGP.sellprice + PAS.value\n\t\t WHEN 3 THEN PGP.sellprice - PAS.value\n\t\t \tWHEN 4 THEN PAS.`value`\n\t \tEND,\n\t\t\t\t\t\t\t\t\tPAS.attributeprice\n\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t) * (1 + (V.value / 100)) * CR.exchangerate AS price\n\t FROM productattributeset AS PAS\n\t\t\t\t LEFT JOIN productattributevalueset PAVS ON PAVS.productattributesetid = PAS.idproductattributeset\n\t\t\t\t LEFT JOIN attributeproductvalue APV ON PAVS.attributeproductvalueid = APV.idattributeproductvalue\n\t\t\t\t LEFT JOIN attributeproduct AS AP ON APV.attributeproductid = AP.idattributeproduct\n\t\t\t\t LEFT JOIN availablitytranslation AT ON PAS.availablityid = AT.availablityid AND AT.languageid = :languageid\n\t\t\t\t LEFT JOIN product AS P ON PAS.productid = P.idproduct\n\t\t\t\t LEFT JOIN productgroupprice PGP ON PGP.productid = P.idproduct AND PGP.clientgroupid = :clientgroupid\n\t\t\t\t LEFT JOIN `vat` V ON P.vatid = V.idvat\n\t\t\t\t LEFT JOIN currencyrates CR ON CR.currencyfrom = P.sellcurrencyid AND CR.currencyto = :currencyto\n\t\t\t\t WHERE PAS.productid = :id AND PAS.status = 1"; } else { $sql = "SELECT\n\t\t\t\t\t\tP.idproduct as id,\n\t\t\t\t\t\tPAS.stock,\n\t\t\t\t\t\tPAS.idproductattributeset,\n\t\t\t\t\t\tPAS.`value`,\n\t\t\t\t\t\tPAS.symbol,\n\t\t\t\t\t\tAT.name as availablity,\n\t\t\t\t\t\tPAS.photoid as photoid,\n\t\t\t\t\t\tIF(PAS.weight IS NULL, P.weight, PAS.weight) AS weight,\n\t\t\t\t\t\tPAVS.idproductattributevalueset,\n\t\t\t\t\t\tPAVS.productattributesetid AS attributesgroup,\n\t\t\t\t\t\tAPV.name AS attributename,\n\t\t\t\t\t\tAPV.idattributeproductvalue AS attributeid,\n\t\t\t\t\t\tAP.name AS attributegroupname,\n\t\t\t\t\t\tAP.idattributeproduct AS attributegroupid,\n\t\t\t\t\t\tIF(P.promotion = 1 AND IF(P.promotionstart IS NOT NULL, P.promotionstart <= CURDATE(), 1) AND IF(P.promotionend IS NOT NULL, P.promotionend >= CURDATE(), 1), PAS.discountprice, PAS.attributeprice) * CR.exchangerate AS attributeprice,\n\t\t\t\t\t\tIF(P.promotion = 1 AND IF(P.promotionstart IS NOT NULL, P.promotionstart <= CURDATE(), 1) AND IF(P.promotionend IS NOT NULL, P.promotionend >= CURDATE(), 1), PAS.discountprice, PAS.attributeprice) * (1 + (V.value / 100)) * CR.exchangerate AS price,\n\t\t\t\t\t\t(PAS.attributeprice * CR.exchangerate) AS attributepricenettobeforepromotion,\n\t\t\t\t\t\t(PAS.attributeprice * (1 + (V.value / 100)) * CR.exchangerate) AS attributepricegrossbeforepromotion\n\t FROM productattributeset AS PAS\n\t\t\t\t LEFT JOIN productattributevalueset PAVS ON PAVS.productattributesetid = PAS.idproductattributeset\n\t\t\t\t LEFT JOIN attributeproductvalue APV ON PAVS.attributeproductvalueid = APV.idattributeproductvalue\n\t\t\t\t LEFT JOIN attributeproduct AS AP ON APV.attributeproductid = AP.idattributeproduct\n\t\t\t\t\tLEFT JOIN availablitytranslation AT ON PAS.availablityid = AT.availablityid AND AT.languageid = :languageid\n\t\t\t\t LEFT JOIN product AS P ON PAS.productid = P.idproduct\n\t\t\t\t LEFT JOIN `vat` V ON P.vatid = V.idvat\n\t\t\t\t LEFT JOIN currencyrates CR ON CR.currencyfrom = P.sellcurrencyid AND CR.currencyto = :currencyto\n\t\t\t\t WHERE PAS.productid = :id AND PAS.status = 1"; } $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('id', $id); $stmt->bindValue('languageid', Helper::getLanguageId()); $stmt->bindValue('currencyto', Session::getActiveCurrencyId()); if (!empty($clientGroupId)) { $stmt->bindValue('clientgroupid', $clientGroupId); } $Data = array(); try { $stmt->execute(); while ($rs = $stmt->fetch()) { $price = 0; $priceWithoutVat = 0; $attrId = $rs['idproductattributeset']; $Data[] = array('id' => $rs['id'], 'stock' => $rs['stock'], 'symbol' => $rs['symbol'], 'weight' => $rs['weight'], 'availablity' => $rs['availablity'], 'photoid' => $rs['photoid'], 'idproductattributeset' => $rs['idproductattributeset'], 'idproductattributevalueset' => $rs['idproductattributevalueset'], 'attributesgroup' => $rs['attributesgroup'], 'attributename' => $rs['attributename'], 'attributeid' => $rs['attributeid'], 'attributegroupname' => $rs['attributegroupname'], 'attributegroupid' => $rs['attributegroupid'], 'attributeprice' => $rs['attributeprice'], 'value' => $rs['value'], 'price' => $rs['price'], 'attributepricenettobeforepromotion' => $rs['attributepricenettobeforepromotion'], 'attributepricegrossbeforepromotion' => $rs['attributepricegrossbeforepromotion'], 'photos' => array('small' => (int) $rs['photoid'] > 0 ? App::getModel('gallery')->getImagePath(App::getModel('gallery')->getSmallImageById($rs['photoid'])) : '', 'normal' => (int) $rs['photoid'] > 0 ? App::getModel('gallery')->getImagePath(App::getModel('gallery')->getNormalImageById($rs['photoid'])) : '', 'large' => (int) $rs['photoid'] > 0 ? App::getModel('gallery')->getImagePath(App::getModel('gallery')->getLargeImageById($rs['photoid'])) : '', 'orginal' => (int) $rs['photoid'] > 0 ? App::getModel('gallery')->getImagePath(App::getModel('gallery')->getOrginalImageById($rs['photoid'])) : '')); } } catch (Exception $e) { throw new FrontendException($e->getMessage()); } return $Data; }
public function getMinimumOrderValue() { $sql = 'SELECT ROUND((V.minimumordervalue * CR.exchangerate) - :globalprice, 2) AS required FROM view V LEFT JOIN currencyrates CR ON CR.currencyfrom = V.currencyid AND CR.currencyto = :currencyto WHERE V.idview = :viewid'; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('globalprice', $this->getGlobalPrice()); $stmt->bindValue('currencyto', Session::getActiveCurrencyId()); $stmt->bindValue('viewid', Helper::getViewId()); $stmt->execute(); $rs = $stmt->fetch(); if ($rs) { return $rs['required']; } return 0; }
public function getDispatchmethodPriceForProduct($globalprice, $globalweight) { $Data = array(); $sql = "SELECT \n\t\t\t\t\tDP.dispatchmethodid,\n\t\t\t\t\tDP.`from`, \n\t\t\t\t\tDP.`to`, \n\t\t\t\t\tV.value, \n\t\t\t\t\tDP.iddispatchmethodprice,\n\t\t\t\t\tIF(DP.vat IS NOT NULL, ROUND(DP.dispatchmethodcost + (DP.dispatchmethodcost * (V.`value`/100)), 4), DP.dispatchmethodcost) * CR.exchangerate as dispatchmethodcost,\n\t\t\t\t\tCASE\n \t\t\t\t\t\tWHEN (`from` <> 0 AND `from` < :globalprice AND `to`= 0 AND DP.dispatchmethodcost = 0) THEN DMT.name\n \t\t\t\t\t \tWHEN (:globalprice BETWEEN `from` AND `to`) THEN DMT.name\n \t\t\t\t\t\tWHEN (`to` = 0 AND `from` < :globalprice AND DP.dispatchmethodcost <> 0) THEN DMT.name\n \t\t\t\t\t\tWHEN (`from` = 0 AND `to`=0 AND DP.dispatchmethodcost =0) THEN DMT.name\n\t\t\t\t\tEND as name\n\t\t\t\tFROM dispatchmethodprice DP\n\t\t\t\tLEFT JOIN dispatchmethod D ON D.iddispatchmethod = dispatchmethodid\n LEFT JOIN dispatchmethodtranslation DMT ON DMT.dispatchmethodid = D.iddispatchmethod AND DMT.languageid = :languageid\n\t\t\t\tLEFT JOIN vat V ON V.idvat = DP.vat\n\t\t\t\tLEFT JOIN dispatchmethodview DV ON DV.dispatchmethodid = D.iddispatchmethod\n\t\t\t\tLEFT JOIN currencyrates CR ON CR.currencyfrom = D.currencyid AND CR.currencyto = :currencyto\n\t\t\t\tWHERE DV.viewid= :viewid AND IF(D.maximumweight IS NOT NULL, D.maximumweight >= :globalweight, 1) AND D.type = 1\n\t\t\t\tORDER BY D.hierarchy ASC"; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('languageid', Helper::getLanguageId()); $stmt->bindValue('globalprice', $globalprice); $stmt->bindValue('globalweight', $globalweight); $stmt->bindValue('viewid', Helper::getViewId()); $stmt->bindValue('currencyto', Session::getActiveCurrencyId()); $stmt->execute(); while ($rs = $stmt->fetch()) { $dispatchmethodid = $rs['dispatchmethodid']; if ($rs['name'] != NULL) { $dispatchmethodcost = $rs['dispatchmethodcost']; $Data[] = array('dispatchmethodid' => $dispatchmethodid, 'name' => _($rs['name']), 'from' => $rs['from'], 'to' => $rs['to'], 'vatvalue' => $rs['value'], 'dispatchmethodcost' => $this->priceFormatParser($dispatchmethodcost)); } } $sql = "SELECT\n\t\t\t\t\tDW.dispatchmethodid, \n\t\t\t\t\tDW.`from`, \n\t\t\t\t\tDW.`to`, \n\t\t\t\t\tV.value, \n\t\t\t\t\tDW.iddispatchmethodweight,\n\t\t\t\t\tIF(DW.vat IS NOT NULL, ROUND(DW.cost+(DW.cost*(V.`value`/100)),4), DW.cost) * CR.exchangerate as dispatchmethodcost, \n\t\t\t\t\tD.freedelivery,\n\t\t\t\t\tCASE\n \t\t\t\t\t\tWHEN (`from`<>0 AND `from`<:globalweight AND `to`=0 AND DW.cost =0) THEN DMT.name\n \t\t\t\t\t \tWHEN (:globalweight BETWEEN `from` AND `to`) THEN DMT.name\n \t\t\t\t\t\tWHEN (`to` = 0 AND `from`<:globalweight AND DW.cost <> 0) THEN DMT.name\n \t\t\t\t\t\tWHEN (`from`=0 AND `to`=0 AND DW.cost = 0) THEN DMT.name\n\t\t\t\t\tEND as name\n\t\t\t\tFROM dispatchmethodweight DW\n\t\t\t\tLEFT JOIN vat V ON V.idvat = DW.vat\n\t\t\t\tLEFT JOIN dispatchmethod D ON D.iddispatchmethod = DW.dispatchmethodid\n LEFT JOIN dispatchmethodtranslation DMT ON DMT.dispatchmethodid = D.iddispatchmethod AND DMT.languageid = :languageid\n\t\t\t\tLEFT JOIN dispatchmethodview DV ON DV.dispatchmethodid = D.iddispatchmethod\n\t\t\t\tLEFT JOIN currencyrates CR ON CR.currencyfrom = D.currencyid AND CR.currencyto = :currencyto\n\t\t\t\tWHERE DV.viewid= :viewid AND D.type = 2\n\t\t\t\tORDER BY D.hierarchy ASC"; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('languageid', Helper::getLanguageId()); $stmt->bindValue('globalprice', $globalprice); $stmt->bindValue('globalweight', $globalweight); $stmt->bindValue('viewid', Helper::getViewId()); $stmt->bindValue('currencyto', Session::getActiveCurrencyId()); $stmt->execute(); while ($rs = $stmt->fetch()) { $dispatchmethodid = $rs['dispatchmethodid']; if ($rs['name'] != NULL) { if ($rs['freedelivery'] > 0 && $rs['freedelivery'] <= $globalprice) { $dispatchmethodcost = 0.0; } else { $dispatchmethodcost = $rs['dispatchmethodcost']; } $Data[] = array('dispatchmethodid' => $dispatchmethodid, 'name' => _($rs['name']), 'from' => $rs['from'], 'to' => $rs['to'], 'vatvalue' => $rs['value'], 'dispatchmethodcost' => $this->priceFormatParser($dispatchmethodcost)); } } return $Data; }
public function edit() { Event::dispatch($this, 'admin.order.checkPaymentStatus', array('id' => (int) $this->registry->core->getParam())); $rawOrderData = $this->model->getOrderById($this->registry->core->getParam()); if (isset($rawOrderData['currencyid']) && !empty($rawOrderData['currencyid'])) { $currencyid = $rawOrderData['currencyid']; } else { $currencyid = Session::getActiveShopCurrencyId(); } try { $order = $this->model->getOrderById((int) $this->registry->core->getParam()); $order['id'] = (int) $this->registry->core->getParam(); $orderNotes = $this->model->getOrderNotes($order['id']); $clientOrderHistory = $this->model->getclientOrderHistory($order['clientid']); } catch (Exception $e) { throw new CoreException($e->getMessage()); } $addNotes = new FormEngine\Elements\Form(array('name' => 'add_notes', 'class' => 'statusChange', 'action' => '', 'method' => 'post')); $addNotes->AddChild(new FormEngine\Elements\Textarea(array('name' => 'contents', 'label' => _('TXT_CONTENT'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_CONTENT')))))); $addNotes->AddChild(new FormEngine\Elements\Submit(array('name' => 'add', 'label' => _('TXT_ADD'), 'icon' => '_images_panel/icons/buttons/add.png'))); $form = new FormEngine\Elements\Form(array('name' => 'order', 'action' => '', 'class' => 'editOrder', 'method' => 'post')); $productsData = $form->AddChild(new FormEngine\Elements\Fieldset(array('name' => 'products_data', 'label' => _('TXT_EDIT_ORDER_ORDERED_PRODUCTS')))); $products = $productsData->AddChild(new FormEngine\Elements\OrderEditor(array('name' => 'products', 'label' => _('TXT_EDIT_ORDER_ORDERED_PRODUCTS'), 'advanced_editor' => true, 'repeat_min' => 1, 'repeat_max' => FormEngine\FE::INFINITE, 'clientgroupid' => (int) $rawOrderData['clientgroupid'], 'currencyid' => (int) $rawOrderData['currencyid'], 'viewid' => $rawOrderData['viewid'], 'on_change' => 'OnProductListChanged'))); $addressData = $form->AddChild(new FormEngine\Elements\Columns(array('name' => 'address_data'))); $billingData = $addressData->AddChild(new FormEngine\Elements\Fieldset(array('name' => 'billing_data', 'label' => _('TXT_EDIT_ORDER_BILLING_DATA')))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'firstname', 'label' => _('TXT_FIRSTNAME'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_FIRSTNAME')))))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'surname', 'label' => _('TXT_SURNAME'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_SURNAME')))))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'street', 'label' => _('TXT_STREET'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_STREET')))))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'streetno', 'label' => _('TXT_STREETNO'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_STREETNO')))))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'placeno', 'label' => _('TXT_PLACENO')))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'place', 'label' => _('TXT_PLACE'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_PLACE')))))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'postcode', 'label' => _('TXT_POSTCODE'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_POSTCODE')))))); $billingData->AddChild(new FormEngine\Elements\Select(array('name' => 'countryid', 'label' => _('TXT_NAME_OF_COUNTRY'), 'options' => FormEngine\Option::Make(App::getModel('countrieslist')->getCountryForSelect()), 'default' => 0, 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_NAME_OF_COUNTRY')))))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'companyname', 'label' => _('TXT_COMPANYNAME')))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'nip', 'label' => _('TXT_NIP')))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'phone', 'label' => _('TXT_PHONE'), 'rules' => array(new FormEngine\Rules\Format(_('ERR_WRONG_FORMAT'), '/^[0-9 -+]+$/'))))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'phone2', 'label' => _('TXT_ADDITIONAL_PHONE'), 'rules' => array(new FormEngine\Rules\Format(_('ERR_WRONG_FORMAT'), '/^[0-9 -+]+$/'))))); $billingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'email', 'label' => _('TXT_EMAIL'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_EMAIL')))))); $shippingData = $addressData->AddChild(new FormEngine\Elements\Fieldset(array('name' => 'shipping_data', 'label' => _('TXT_EDIT_ORDER_SHIPPING_DATA')))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'firstname', 'label' => _('TXT_FIRSTNAME'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_FIRSTNAME')))))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'surname', 'label' => _('TXT_SURNAME'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_SURNAME')))))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'street', 'label' => _('TXT_STREET'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_STREET')))))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'streetno', 'label' => _('TXT_STREETNO'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_STREETNO')))))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'placeno', 'label' => _('TXT_PLACENO')))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'place', 'label' => _('TXT_PLACE'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_PLACE')))))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'postcode', 'label' => _('TXT_POSTCODE'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_POSTCODE')))))); $shippingData->AddChild(new FormEngine\Elements\Select(array('name' => 'countryid', 'label' => _('TXT_NAME_OF_COUNTRY'), 'options' => FormEngine\Option::Make(App::getModel('countrieslist')->getCountryForSelect()), 'default' => 0, 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_NAME_OF_COUNTRY')))))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'companyname', 'label' => _('TXT_COMPANYNAME')))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'nip', 'label' => _('TXT_NIP')))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'phone', 'label' => _('TXT_PHONE'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_PHONE')), new FormEngine\Rules\Format(_('ERR_WRONG_FORMAT'), '/^[0-9 -+]+$/'))))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'phone2', 'label' => _('TXT_ADDITIONAL_PHONE'), 'rules' => array(new FormEngine\Rules\Format(_('ERR_WRONG_FORMAT'), '/^[0-9 -+]+$/'))))); $shippingData->AddChild(new FormEngine\Elements\TextField(array('name' => 'email', 'label' => _('TXT_EMAIL'), 'rules' => array(new FormEngine\Rules\Required(_('ERR_EMPTY_EMAIL')))))); $additionalData = $form->AddChild(new FormEngine\Elements\Columns(array('name' => 'additional_data'))); $paymentData = $additionalData->AddChild(new FormEngine\Elements\Fieldset(array('name' => 'payment_data', 'label' => _('TXT_EDIT_ORDER_PAYMENT_METHOD')))); $paymentData->AddChild(new FormEngine\Elements\Select(array('name' => 'payment_method', 'label' => _('TXT_EDIT_ORDER_PAYMENT_METHOD'), 'options' => FormEngine\Option::Make($this->registry->core->getDefaultValueToSelect() + $this->model->getPaymentmethodAllToSelect($this->registry->core->getParam()))))); $weight = 0; foreach ($order['products'] as $product) { $weight += $product['weight']; } $paymentData->AddChild(new FormEngine\Elements\Select(array('name' => 'delivery_method', 'label' => _('TXT_EDIT_ORDER_DELIVERY_METHOD'), 'options' => FormEngine\Option::Make($this->model->getDispatchmethodAllToSelect($order['total'], $this->registry->core->getParam(), $weight))))); $paymentData->AddChild(new FormEngine\Elements\Select(array('name' => 'rules_cart', 'label' => _('TXT_RULES_CART'), 'options' => FormEngine\Option::Make($this->model->getAllRulesForOrder($this->registry->core->getParam()))))); $paymentData->AddChild(new FormEngine\Elements\Constant(array('name' => 'currency', 'label' => _('TXT_KIND_OF_CURRENCY')))); $summaryData = $additionalData->AddChild(new FormEngine\Elements\Fieldset(array('name' => 'summary_data', 'label' => _('TXT_VIEW_ORDER_SUMMARY')))); $summaryData->AddChild(new FormEngine\Elements\Constant(array('name' => 'total_net_total', 'label' => _('TXT_NETTO_AMOUNT')))); $summaryData->AddChild(new FormEngine\Elements\Constant(array('name' => 'total_vat_value', 'label' => _('TXT_VIEW_ORDER_TAX')))); $summaryData->AddChild(new FormEngine\Elements\Constant(array('name' => 'total_delivery', 'label' => _('TXT_DELIVERERPRICE')))); $summaryData->AddChild(new FormEngine\Elements\Constant(array('name' => 'total_total', 'label' => _('TXT_VIEW_ORDER_TOTAL')))); $form->AddFilter(new FormEngine\Filters\NoCode()); $form->AddFilter(new FormEngine\Filters\Trim()); $form->AddFilter(new FormEngine\Filters\Secure()); $orderData = array('address_data' => array('billing_data' => array('firstname' => $rawOrderData['billing_address']['firstname'], 'surname' => $rawOrderData['billing_address']['surname'], 'street' => $rawOrderData['billing_address']['street'], 'streetno' => $rawOrderData['billing_address']['streetno'], 'placeno' => $rawOrderData['billing_address']['placeno'], 'place' => $rawOrderData['billing_address']['city'], 'postcode' => $rawOrderData['billing_address']['postcode'], 'countryid' => $rawOrderData['billing_address']['countryid'], 'companyname' => $rawOrderData['billing_address']['companyname'], 'nip' => $rawOrderData['billing_address']['nip'], 'phone' => $rawOrderData['billing_address']['phone'], 'phone2' => $rawOrderData['billing_address']['phone2'], 'email' => $rawOrderData['billing_address']['email']), 'shipping_data' => array('firstname' => $rawOrderData['delivery_address']['firstname'], 'surname' => $rawOrderData['delivery_address']['surname'], 'street' => $rawOrderData['delivery_address']['street'], 'streetno' => $rawOrderData['delivery_address']['streetno'], 'placeno' => $rawOrderData['delivery_address']['placeno'], 'place' => $rawOrderData['delivery_address']['city'], 'postcode' => $rawOrderData['delivery_address']['postcode'], 'countryid' => $rawOrderData['delivery_address']['countryid'], 'companyname' => $rawOrderData['delivery_address']['companyname'], 'nip' => $rawOrderData['delivery_address']['nip'], 'phone' => $rawOrderData['delivery_address']['phone'], 'phone2' => $rawOrderData['billing_address']['phone2'], 'email' => $rawOrderData['delivery_address']['email'])), 'additional_data' => array('payment_data' => array('delivery_method' => $rawOrderData['delivery_method']['dispatchmethodid'], 'payment_method' => $rawOrderData['payment_method']['paymentmethodid'], 'rules_cart' => $rawOrderData['rulescartid'], 'currency' => $rawOrderData['currencysymbol']), 'summary_data' => array('total_net_total' => 132)), 'products_data' => array('products' => $this->model->getProductsDataGrid((int) $this->registry->core->getParam()))); $form->Populate($orderData); $statusChange = new FormEngine\Elements\Form(array('name' => 'add_status_change', 'class' => 'statusChange', 'action' => '', 'method' => 'post')); $idstatus = $statusChange->AddChild(new FormEngine\Elements\Select(array('name' => 'status', 'label' => _('TXT_VIEW_ORDER_CHANGE_STATUS'), 'options' => FormEngine\Option::Make(App::getModel('orderstatus')->getOrderStatusToSelect())))); $statusChange->AddChild(new FormEngine\Elements\Textarea(array('name' => 'comment', 'label' => _('TXT_VIEW_ORDER_CHANGE_COMMENT'), 'dependencies' => array(new FormEngine\Dependency(FormEngine\Dependency::SUGGEST, $idstatus, array(App::getModel('orderstatus'), 'getDefaultComment')))))); $statusChange->AddChild(new FormEngine\Elements\Checkbox(array('name' => 'inform', 'label' => _('TXT_VIEW_ORDER_CHANGE_INFORM_CLIENT')))); $statusChange->AddChild(new FormEngine\Elements\Submit(array('name' => 'update', 'label' => _('TXT_VIEW_ORDER_CHANGE_UPDATE'), 'icon' => '_images_panel/icons/buttons/flag-green.png'))); $statusChange->Populate(array('status' => $order['current_status_id'])); $form->AddFilter(new FormEngine\Filters\Trim()); $form->AddFilter(new FormEngine\Filters\Secure()); $form->AddFilter(new FormEngine\Filters\Trim()); $form->AddFilter(new FormEngine\Filters\Secure()); if ($addNotes->Validate(FormEngine\FE::SubmittedData())) { try { $notes = $addNotes->getSubmitValues(FormEngine\Elements\Form::FORMAT_FLAT); $this->model->addOrderNotes($addNotes->getSubmitValues(FormEngine\Elements\Form::FORMAT_FLAT), $order['id']); Session::setVolatileMessage("Dodano notatkę do zamówienia {$this->id}"); App::redirect(__ADMINPANE__ . '/order/edit/' . (int) $this->registry->core->getParam()); } catch (Exception $e) { $this->registry->template->assign('error', $e->getMessage()); } } if ($statusChange->Validate(FormEngine\FE::SubmittedData())) { $this->model->addOrderHistory($statusChange->getSubmitValues(FormEngine\Elements\Form::FORMAT_FLAT), $this->registry->core->getParam()); try { $email = $statusChange->getSubmitValues(FormEngine\Elements\Form::FORMAT_FLAT); if ($email['inform'] == 1) { $this->model->notifyUser($order, $email['status']); } Session::setVolatileMessage("Zaktualizowano status zamówienia {$this->id}"); $this->model->updateOrderStatus($_POST, $this->registry->core->getParam()); App::redirect(__ADMINPANE__ . '/order/edit/' . (int) $this->registry->core->getParam()); } catch (Exception $e) { $this->registry->template->assign('error', $e->getMessage()); } } if ($form->Validate(FormEngine\FE::SubmittedData())) { try { $this->model->updateOrderById($_POST, $this->registry->core->getParam()); App::redirect(__ADMINPANE__ . '/order/'); } catch (Exception $e) { $this->registry->template->assign('error', $e->getMessage()); } } $this->registry->template->assign('viewid', Helper::getViewId()); $this->registry->xajaxInterface->registerFunction(array('CalculateDeliveryCost', $this->model, 'calculateDeliveryCostEdit')); $this->registry->xajaxInterface->registerFunction(array('GetDispatchMethodForPrice', $this->model, 'getDispatchMethodForPriceForAjaxEdit')); $this->registry->template->assign('xajax', $this->registry->xajax->getJavascript()); $this->registry->xajax->processRequest(); $this->registry->template->assign('statusChange', $statusChange->Render()); $this->registry->template->assign('addNotes', $addNotes->Render()); $this->registry->template->assign('orderNotes', $orderNotes); $this->registry->template->assign('clientOrderHistory', $clientOrderHistory); $this->registry->template->assign('order', $order); $this->registry->template->assign('currencyid', Session::getActiveCurrencyId()); $this->registry->template->assign('currencysymbol', Session::getActiveCurrencySymbol()); $this->registry->template->assign('form', $form->Render()); $this->registry->template->display($this->loadTemplate('edit.tpl')); }
public function getAllCurrenciesForView() { $shopCurrencyId = Session::getActiveCurrencyId(); if (($Data = $this->registry->cache->load('currencies')) === FALSE) { $sql = "SELECT \n\t\t\t\t\t\tC.idcurrency, \n\t\t\t\t\t\tC.currencysymbol, \n\t\t\t\t\t\tC.currencyname\n\t\t\t\t\tFROM currency C\n\t\t\t\t\tLEFT JOIN currencyview CV ON CV.currencyid = C.idcurrency\n\t\t\t\t\tWHERE CV.viewid= :viewid"; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('viewid', Helper::getViewId()); $stmt->execute(); while ($rs = $stmt->fetch()) { $id = $rs['idcurrency']; $Data[$id] = array('id' => $id, 'name' => $rs['currencysymbol'], 'selected' => 0); } $this->registry->cache->save('currencies', $Data); } $Data[$shopCurrencyId]['selected'] = 1; return $Data; }
public function getProductListIntegration() { $sql = "SELECT\n\t\t\t\t \tPC.categoryid AS id,\n\t\t\t\t \tP.idproduct,\n\t\t\t\t \tP.stock,\n\t\t\t\t \tP.weight,\n\t\t\t\t \tPT.name,\n\t\t\t\t \t(P.sellprice * (1 + (V.value / 100)) * CR.exchangerate) AS sellprice,\n\t\t\t\t \tIF(P.promotion = 1 AND IF(P.promotionstart IS NOT NULL, P.promotionstart <= CURDATE(), 1) AND IF(P.promotionend IS NOT NULL, P.promotionend >= CURDATE(), 1), P.discountprice * (1 + (V.value / 100)) * CR.exchangerate, NULL) AS discountprice,\n\t\t\t\t \tPT.shortdescription,\n\t\t\t\t \tPhoto.photoid,\n\t\t\t\t \tNC.name as domodioriginal,\n\t\t\t\t \tCN.categoryid,\n\t\t\t\t \tNC.iddomodi,\n\t\t\t\t \tCN.domodiid,\n\t\t\t\t \tPT.seo,\n\t\t\t\t\tPRT.name AS producername,\n\t\t\t\t\tP.ean\n\t\t\t\tFROM product P\n\t\t\t\tLEFT JOIN vat V ON P.vatid= V.idvat\n\t\t\t\tLEFT JOIN producttranslation PT ON PT.productid = P.idproduct AND PT.languageid=:languageid\n\t\t\t\tLEFT JOIN productcategory PC ON PC.productid = P.idproduct\n\t\t\t\tINNER JOIN viewcategory VC ON VC.categoryid = PC.categoryid AND VC.viewid = :viewid\n\t\t\t\tLEFT JOIN currencyrates CR ON CR.currencyfrom = P.sellcurrencyid AND CR.currencyto = :currencyto\n\t\t\t\tINNER JOIN productphoto Photo ON Photo.productid = P.idproduct AND Photo.mainphoto=1\n\t\t\t\tINNER JOIN categorydomodi CN ON CN.categoryid = PC.categoryid\n\t\t\t\tINNER JOIN domodi NC ON NC.idorginal = CN.domodiid\n\t\t\t\tLEFT JOIN producertranslation PRT ON PRT.producerid = P.producerid AND PRT.languageid = :languageid\n\t\t\t\tWHERE P.enable = 1\n\t GROUP BY P.idproduct"; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('viewid', Helper::getViewId()); $stmt->bindValue('languageid', Helper::getLanguageId()); $stmt->bindValue('currencyto', Session::getActiveCurrencyId()); $rs = $stmt->execute(); $Data = array(); while ($rs = $stmt->fetch()) { $Data[] = array('categoryid' => $rs['id'], 'producername' => $rs['producername'], 'ean' => $rs['ean'], 'productid' => $rs['idproduct'], 'stock' => $rs['stock'], 'avail' => $rs['stock'] > 0 ? 1 : 7, 'weight' => $rs['weight'], 'seo' => $rs['seo'], 'name' => $rs['name'], 'shortdescription' => $rs['shortdescription'], 'sellprice' => number_format(!is_null($rs['discountprice']) ? $rs['discountprice'] : $rs['sellprice'], 2, '.', ''), 'photoid' => $rs['photoid'], 'idproduct' => $rs['idproduct'], 'domodi' => $this->generateDomodiTreeByCategoryId($rs['categoryid'])); } foreach ($Data as $key => $Product) { $Image = App::getModel('gallery')->getOrginalImageById($Product['photoid']); $Data[$key]['photo'] = App::getModel('gallery')->getImagePath($Image, App::getURLAdress()); } return $Data; }
/** * Chcek cart rules. * If there is any rule, reduce global price. Otherwise return 0. * * @param * array client order * @return array discount (rulescartid, suffixtypeid, symbol, discount) or 0 * @access public */ public function getRulesCart($clientOrder) { $clientGroupId = Session::getActiveClientGroupid(); $Data = array(); $discount = array(); $check = true; $allRules = $this->getAllCartRules(); if (is_array($allRules) && !empty($allRules)) { foreach ($allRules as $rule) { $ruleid = $rule['idrulescart']; $ruleName = $rule['name']; $ruleDescription = $rule['description']; if ($clientGroupId > 0) { $sql = "SELECT \n\t\t\t\t\t\t\t\tRCCG.rulescartid, \n\t\t\t\t\t\t\t\tRCR.ruleid, \n\t\t\t\t\t\t\t\tRCR.pkid, \n\t\t\t\t\t\t\t\tRCR.pricefrom, \n\t\t\t\t\t\t\t\tRCR.priceto,\n\t\t\t\t\t\t\t\tRCCG.suffixtypeid, \n\t\t\t\t\t\t\t\tRCCG.discount, \n\t\t\t\t\t\t\t\tRCCG.freeshipping, \n\t\t\t\t\t\t\t\tS.symbol,\n\t\t\t\t\t\t\t\tRCCG.clientgroupid\n\t\t\t\t\t\t\tFROM rulescartclientgroup RCCG\n\t\t\t\t\t\t\tLEFT JOIN rulescart RC ON RCCG.rulescartid = RC.idrulescart\n\t\t\t\t\t\t\tLEFT JOIN rulescartrule RCR ON RCR.rulescartid = RC.idrulescart\n\t\t\t\t\t\t\tLEFT JOIN rulescartview RCV ON RCV.rulescartid = RC.idrulescart\n\t\t\t\t\t\t\tLEFT JOIN suffixtype S ON RCCG.suffixtypeid = S.idsuffixtype\n\t\t\t\t\t\t\tWHERE RCR.rulescartid = :ruleid\n\t\t\t\t\t\t AND RCV.viewid= :viewid\n\t\t\t\t\t\t\tAND RCCG.clientgroupid= :clientgroupid\n\t\t\t\t\t\t\tAND IF(RC.datefrom is not null, (cast(RC.datefrom as date) <= curdate()), 1)\n\t\t\t\t\t\t\tAND IF(RC.dateto is not null, (cast(RC.dateto as date)>= curdate()),1)"; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('clientgroupid', $clientGroupId); $stmt->bindValue('viewid', Helper::getViewId()); $stmt->bindValue('ruleid', $ruleid); } else { $sql = "SELECT \n\t\t\t\t\t\t\t\tRCR.rulescartid, \n\t\t\t\t\t\t\t\tRCR.ruleid, \n\t\t\t\t\t\t\t\tRCR.pkid, \n\t\t\t\t\t\t\t\tRCR.pricefrom, \n\t\t\t\t\t\t\t\tRCR.priceto,\n\t\t\t\t\t\t\t\tRC.suffixtypeid, \n\t\t\t\t\t\t\t\tRC.freeshipping, \n\t\t\t\t\t\t\t\tRC.discount, \n\t\t\t\t\t\t\t\tS.symbol,\n\t\t\t\t\t\t\t\t'clientgroupid' = NULL as clientgroupid\n\t\t\t\t\t\t\tFROM rulescart RC\n\t\t\t\t\t\t\tLEFT JOIN rulescartrule RCR ON RCR.rulescartid = RC.idrulescart\n\t\t\t\t\t\t\tLEFT JOIN rulescartview RCV ON RCV.rulescartid = RC.idrulescart\n\t\t\t\t\t\t\tLEFT JOIN suffixtype S ON RC.suffixtypeid = S.idsuffixtype\n\t\t \t\t\t\tWHERE RCR.rulescartid = :ruleid\n\t\t \tAND RC.discountforall =1\n\t\t \t\t\tAND RCV.viewid= :viewid\n\t\t \t\t\tAND IF(RC.datefrom is not null, (cast(RC.datefrom as date) <= curdate()), 1)\n\t\t\t\t\t\t\tAND IF(RC.dateto is not null, (cast(RC.dateto as date)>= curdate()),1)"; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('viewid', Helper::getViewId()); $stmt->bindValue('ruleid', $ruleid); } try { $stmt->execute(); while ($rs = $stmt->fetch()) { $ruleid = $rs['ruleid']; $rulescartid = $rs['rulescartid']; switch ($ruleid) { case 9: // delivery (dispatchmethod) if (isset($Data[$rulescartid][$ruleid]) && $Data[$rulescartid][$ruleid] == 0 || !isset($Data[$rulescartid][$ruleid])) { if (isset($clientOrder['dispatchmethod']['dispatchmethodid']) && $clientOrder['dispatchmethod']['dispatchmethodid'] == $rs['pkid']) { $Data[$rulescartid][$ruleid] = 1; } else { $Data[$rulescartid][$ruleid] = 0; } } break; case 10: // paymentmethod if (isset($Data[$rulescartid][$ruleid]) && $Data[$rulescartid][$ruleid] == 0 || !isset($Data[$rulescartid][$ruleid])) { if (isset($clientOrder['payment']['idpaymentmethod']) && $clientOrder['payment']['idpaymentmethod'] == $rs['pkid']) { $Data[$rulescartid][$ruleid] = 1; } else { $Data[$rulescartid][$ruleid] = 0; } } break; case 11: // final cart price if (isset($Data[$rulescartid][$ruleid]) && $Data[$rulescartid][$ruleid] == 0 || !isset($Data[$rulescartid][$ruleid])) { if (isset($clientOrder['globalPrice']) && $clientOrder['globalPrice'] >= $rs['pricefrom']) { $Data[$rulescartid][$ruleid] = 1; } else { $Data[$rulescartid][$ruleid] = 0; } } break; case 12: // final cart price if (isset($Data[$rulescartid][$ruleid]) && $Data[$rulescartid][$ruleid] == 0 || !isset($Data[$rulescartid][$ruleid])) { if (isset($clientOrder['globalPrice']) && $clientOrder['globalPrice'] <= $rs['priceto']) { $Data[$rulescartid][$ruleid] = 1; } else { $Data[$rulescartid][$ruleid] = 0; } } break; case 13: // final cart price with dispatch method if (isset($Data[$rulescartid][$ruleid]) && $Data[$rulescartid][$ruleid] == 0 || !isset($Data[$rulescartid][$ruleid])) { if (isset($clientOrder['priceWithDispatchMethod']) && $clientOrder['priceWithDispatchMethod'] >= $rs['pricefrom']) { $Data[$rulescartid][$ruleid] = 1; } else { $Data[$rulescartid][$ruleid] = 0; } } break; case 14: // final cart price with dispatch method if (isset($Data[$rulescartid][$ruleid]) && $Data[$rulescartid][$ruleid] == 0 || !isset($Data[$rulescartid][$ruleid])) { if ($clientOrder['priceWithDispatchMethod'] <= $rs['priceto']) { $Data[$rulescartid][$ruleid] = 1; } else { $Data[$rulescartid][$ruleid] = 0; } } break; } $discountValue = $rs['discount']; $discountSymbol = $rs['symbol']; if ($discountSymbol !== '%' && $discountValue > 0) { $shopCurrency = Session::getActiveShopCurrencyId(); $currentCurrency = Session::getActiveCurrencyId(); if ($shopCurrency != $currentCurrency) { $rate = Session::getActiveCurrencyRate(); if (!empty($rate) && $rate > 0) { $discountValue = $rate * $discountValue; } } } $discount[$rs['rulescartid']]['rulescartid'] = $rs['rulescartid']; $discount[$rs['rulescartid']]['name'] = $ruleName; $discount[$rs['rulescartid']]['description'] = $ruleDescription; $discount[$rs['rulescartid']]['suffixtypeid'] = $rs['suffixtypeid']; $discount[$rs['rulescartid']]['discount'] = $discountValue; $discount[$rs['rulescartid']]['symbol'] = $discountSymbol; $discount[$rs['rulescartid']]['freeshipping'] = $rs['freeshipping']; } } catch (Exception $e) { throw new FrontendException(_('ERR_RULES_CART')); } } // end foreach } // end if is_array rulesAll if (count($Data) > 0) { foreach ($Data as $rulescart => $rules) { foreach ($rules as $rule) { if ($rule == 0) { unset($Data[$rulescart]); } } } } foreach ($Data as $rulescart => $rules) { return $discount[$rulescart]; } }