public function view()
{
$sql = 'SELECT
T.name,
TD.translation
FROM translation T
LEFT JOIN translationdata TD ON T.idtranslation = TD.translationid AND TD.languageid = :languageid';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('languageid', Helper::getLanguageId());
$stmt->execute();
$xml = new SimpleXMLElement('<rows></rows>');
while ($rs = $stmt->fetch()) {
$node = $xml->addChild('row');
$name = $node->addChild('field', $rs['name']);
$name->addAttribute('name', 'name');
$translation = $node->addChild('field', htmlspecialchars($rs['translation']));
$translation->addAttribute('name', 'translation');
}
header('Content-type: text/xml; charset=utf-8');
header('Content-disposition: attachment; filename=pl_PL.xml');
header('Content-type: text/xml');
header('Cache-Control: max-age=0');
$doc = new DOMDocument('1.0', 'UTF-8');
$doc->formatOutput = true;
$domnode = dom_import_simplexml($xml);
$domnode = $doc->importNode($domnode, true);
$domnode = $doc->appendChild($domnode);
echo $doc->saveXML();
}
protected function _Check($value)
{
if ($this->_valueProcessFunction) {
$f = $this->_valueProcessFunction;
$value = $f($value);
}
$sql = "\n\t\t\tSELECT\n\t\t\t\tCOUNT(*) AS items_count\n\t\t\tFROM\n\t\t\t\t{$this->_table}\n\t\t\tWHERE\n\t\t\t\t{$this->_column} = :value\n\t\t";
if ($this->_exclude and is_array($this->_exclude)) {
if (!is_array($this->_exclude['values'])) {
$this->_exclude['values'] = array($this->_exclude['values']);
}
$excludedValues = implode(', ', $this->_exclude['values']);
$sql .= "AND NOT {$this->_exclude['column']} IN ({$excludedValues})";
}
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('value', $value);
try {
$stmt->execute();
$rs = $stmt->fetch();
if ($rs['items_count'] == 0) {
return true;
}
} catch (Exception $e) {
throw new Exception('Error while executing sql query: ' . $e->getMessage());
}
return false;
}
protected function ProductSearchStatus($productid, $status)
{
$sql = 'UPDATE productsearch SET enable = :status WHERE productid = :productid';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('status', $status);
$stmt->bindValue('productid', $productid);
try {
$stmt->execute();
} catch (Exception $e) {
throw new Exception($e->getMessage());
}
}
public function loadSettings()
{
$sql = "SELECT\n\t\t\t\t\tM.mailer,\n\t\t\t\t\tM.fromname,\n\t\t\t\t\tM.fromemail,\n\t\t\t\t\tM.server,\n\t\t\t\t\tM.port,\n\t\t\t\t\tM.smtpsecure,\n\t\t\t\t\tM.smtpauth,\n\t\t\t\t\tM.smtpusername,\n\t\t\t\t\tM.smtppassword,\n\t\t\t\t\tV.pageschemeid,\n\t\t\t\t\tPS.templatefolder,\n\t\t\t\t\tV.photoid\n\t\t\t\tFROM mailer M\n\t\t\t\tLEFT JOIN view V ON V.idview = M.viewid\n\t\t\t\tLEFT JOIN pagescheme PS ON PS.idpagescheme = V.pageschemeid\n\t\t\t\tWHERE idview=:id";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('id', $this->viewid);
$stmt->execute();
$rs = $stmt->fetch();
$Data = array();
if ($rs) {
$this->settings = array('mailer' => $rs['mailer'], 'fromname' => $rs['fromname'], 'fromemail' => $rs['fromemail'], 'server' => $rs['server'], 'port' => $rs['port'], 'smtpsecure' => $rs['smtpsecure'], 'smtpauth' => $rs['smtpauth'], 'smtpusername' => $rs['smtpusername'], 'smtppassword' => $rs['smtppassword'], 'theme' => $rs['templatefolder'], 'photoid' => $rs['photoid']);
}
}
public function getLayoutBoxJS($id)
{
$sql = "SELECT\n\t\t\t\t\tidlayoutboxjsvalue,\n\t\t\t\t\tvariable,\n\t\t\t\t\tvalue\n\t\t\t\tFROM layoutboxjsvalue\n\t\t\t\tWHERE layoutboxid = :idlayoutbox";
$Data = array();
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('idlayoutbox', $id);
$stmt->execute();
while ($rs = $stmt->fetch()) {
$Data[$rs['variable']] = $rs['value'];
}
return $Data;
}
protected static function load()
{
if ((self::$events = App::getRegistry()->cache->load('events')) === FALSE) {
$sql = 'SELECT * FROM event';
$stmt = Db::getInstance()->prepare($sql);
$stmt->execute();
while ($rs = $stmt->fetch()) {
self::$events[] = array('name' => $rs['name'], 'model' => $rs['model'], 'method' => $rs['method'], 'mode' => $rs['mode']);
}
App::getRegistry()->cache->save('events', self::$events);
}
}
public function getIntegrationWhitelist($module)
{
$sql = "SELECT \n\t\t\t\t\t* \n\t\t\t\tFROM integrationwhitelist IW\n\t\t\t\tLEFT JOIN integration I ON IW.integrationid = I.idintegration\n\t\t\t\tWHERE I.symbol = :symbol";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('symbol', $module);
$stmt->execute();
$Data = array();
while ($rs = $stmt->fetch()) {
$Data[] = $rs['ipaddress'];
}
return $Data;
}
public function getCategoriesPathById()
{
Db::getInstance()->beginTransaction();
$sql = 'TRUNCATE categorypath';
$stmt = Db::getInstance()->prepare($sql);
$stmt->execute();
$sql = 'SELECT idcategory AS id, categoryid AS parent FROM category';
$stmt = Db::getInstance()->prepare($sql);
$stmt->execute();
$Data = $stmt->fetchAll();
$parents = array();
foreach ($Data as $category) {
if ($category['parent']) {
$parents[$category['id']] = $category['parent'];
} else {
$parents[$category['id']] = null;
}
}
$alreadyAdded = array();
foreach ($parents as $category => $ancestor) {
$order = 0;
$ancestor = $category;
for ($i = 0; $i < 50; $i++) {
if (!isset($alreadyAdded[$category]) || !isset($alreadyAdded[$category][$ancestor]) || !$alreadyAdded[$category][$ancestor]) {
$sql = '
INSERT INTO categorypath
SET
categoryid = :categoryid,
ancestorcategoryid = :ancestorcategoryid,
`order` = :order
';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('categoryid', $category);
$stmt->bindValue('ancestorcategoryid', $ancestor);
$stmt->bindValue('order', $order++);
$stmt->execute();
$alreadyAdded[$category][$ancestor] = true;
}
if ($parents[$ancestor] == null) {
break;
}
$ancestor = $parents[$ancestor];
}
}
Db::getInstance()->commit();
$this->flushCache();
}
public function getMissingCart($clientid)
{
$sql = "SELECT \n\t\t\t\t\tMC.idmissingcart, \n\t\t\t\t\tMC.dispatchmethodid, \n\t\t\t\t\tMC.paymentmethodid \n\t\t\t\tFROM missingcart MC\n\t\t\t\tWHERE MC.clientid = :clientid";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('clientid', Session::getActiveClientid());
$Data = array();
try {
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
$Data = array('clientid' => $clientid, 'idmissingcart' => $rs['idmissingcart'], 'dispatchmethodid' => $rs['dispatchmethodid'], 'paymentmethodid' => $rs['paymentmethodid'], 'products' => $this->getProductFromMissingCart($idmissingcart), 'sessionid' => $this['sessionid']);
} else {
$Data = 0;
}
} catch (Exception $e) {
new Exception($e->message('Error while selecting session content from sessionhandler.'));
}
return $Data;
}
protected function getDb()
{
return \Gekosale\Db::getInstance();
}
public function reportPayment()
{
if (isset($_POST['p24_session_id']) && $_POST['p24_session_id'] != '') {
$sessionid = base64_decode($_POST['p24_session_id']);
$sql = 'SELECT
*
FROM `order`
WHERE sessionid = :crc';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('crc', base64_decode($_POST['p24_session_id']));
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
$settings = $this->registry->core->loadModuleSettings('przelewy24', $rs['viewid']);
$p24_session_id = $_POST["p24_session_id"];
$p24_order_id = $_POST["p24_order_id"];
$p24_kwota = number_format($rs['globalprice'] * 100, 0, '', '');
$P = array();
$RET = array();
$url = "https://secure.przelewy24.pl/transakcja.php";
$P[] = "p24_id_sprzedawcy=" . $settings['idsprzedawcy'];
$P[] = "p24_session_id=" . $p24_session_id;
$P[] = "p24_order_id=" . $p24_order_id;
$P[] = "p24_kwota=" . $p24_kwota;
$user_agent = "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)";
$ch = curl_init();
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, join("&", $P));
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
curl_setopt($ch, CURLOPT_USERAGENT, $user_agent);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
$result = curl_exec($ch);
curl_close($ch);
$T = explode(chr(13) . chr(10), $result);
$res = false;
foreach ($T as $line) {
$line = ereg_replace("[\n\r]", "", $line);
if ($line != "RESULT" and !$res) {
continue;
}
if ($res) {
$RET[] = $line;
} else {
$res = true;
}
}
if ($RET[0] == 'TRUE') {
$status = $settings['positiveorderstatusid'];
$comment = 'Płatność zakończona sukcesem';
$url = $this->registry->router->generate('frontend.payment', true, array('action' => 'confirm', 'param' => 'przelewy24'));
} else {
$status = $settings['negativeorderstatusid'];
$comment = 'Płatność zakończona niepowodzeniem';
$url = $this->registry->router->generate('frontend.payment', true, array('action' => 'cancel', 'param' => 'przelewy24'));
}
$sql = "UPDATE `order` SET orderstatusid = :status WHERE idorder = :idorder";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('status', $status);
$stmt->bindValue('idorder', $rs['idorder']);
$stmt->execute();
$sql = 'INSERT INTO orderhistory SET
content = :content,
orderstatusid = :status,
orderid = :idorder,
inform = 0';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('content', $comment);
$stmt->bindValue('idorder', $rs['idorder']);
$stmt->bindValue('status', $status);
$stmt->execute();
if (Session::getActivePaymentData() != NULL) {
App::redirectUrl($url);
}
}
}
}
public function checkEraty($idpaymentmethod)
{
$price = Session::getActiveglobalPriceWithDispatchmethod();
if ($price > 0) {
if ($price < 100) {
return 0;
}
} else {
$order = Session::getActiveClientOrder();
if (!isset($order['priceWithDispatchMethod']) || $order['priceWithDispatchMethod'] < 100) {
return 0;
}
}
$sql = "SELECT ES.wariantsklepu, ES.numersklepu, ES.`char`\n\t\t\t\t\tFROM eratysettings ES\n\t\t\t\t\t\tLEFT JOIN paymentmethodview PV ON ES.paymentmethodid = PV.paymentmethodid\n\t\t\t\t\tWHERE PV.viewid = :viewid\n\t\t\t\t\tAND ES.paymentmethodid = :idpaymentmethod";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('viewid', Helper::getViewId());
$stmt->bindValue('idpaymentmethod', $idpaymentmethod);
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
$Data = array('wariantsklepu' => $rs['wariantsklepu'], 'numersklepu' => $rs['numersklepu'], 'char' => $rs['char']);
return $Data;
}
return 0;
}
public function loadDynamicMethods()
{
$sql = 'SELECT method, width, height, keepproportion, staticpath FROM gallerysettings';
$stmt = Db::getInstance()->prepare($sql);
$stmt->execute();
$Data = array();
while ($rs = $stmt->fetch()) {
$Data[$rs['method']] = array('width' => $rs['width'], 'height' => $rs['height'], 'keepproportion' => $rs['keepproportion'], 'staticpath' => $rs['staticpath']);
}
return $Data;
}
public function updatePhraseAboutMostSearch($id, $counter = 0)
{
$counter = $counter + 1;
$sql = 'UPDATE mostsearch MS SET MS.textcount = :counter
WHERE MS.idmostsearch = :id';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('id', $id);
$stmt->bindValue('counter', $counter);
try {
$stmt->execute();
} catch (Exception $e) {
throw new FrontendException($e->getMessage());
}
}
public function getCurrencies()
{
$sql = 'SELECT CR.idcurrency, CR.currencyname, CR.currencysymbol
FROM currency CR
ORDER BY currencysymbol ASC';
$stmt = Db::getInstance()->prepare($sql);
$stmt->execute();
return $stmt->fetchAll();
}
protected function getSelectedRows($request)
{
$offset = isset($request['starting_from']) ? $request['starting_from'] : 0;
$limit = isset($request['limit']) ? $request['limit'] : (int) $request['n'];
list($idColumn, $groupBy, $orderBy, $orderDir, $conditionString, $conditions, $additionalConditionString, $havingString, $having) = $this->getQueryData($request);
$sql = "SELECT DISTINCT {$this->getColumnsString()} FROM {$this->queryFrom}{$conditionString}{$additionalConditionString}{$groupBy}{$havingString} ORDER BY {$orderBy} {$orderDir} LIMIT {$offset},{$limit}";
$stmt = Db::getInstance()->prepare($sql);
foreach ($conditions as $i => &$part) {
$stmt->bindValue('value' . $i, $part['value']);
}
if (preg_match('/:encryptionkey/', $sql)) {
$stmt->bindValue('encryptionkey', $this->encryptionKey);
}
if (preg_match('/:languageid/', $sql)) {
$stmt->bindValue('languageid', $this->languageId);
}
foreach ($this->sqlParams as $key => $val) {
if (preg_match('/:' . $key . '/', $sql)) {
if (is_array($val)) {
$stmt->bindValue($key, implode(',', $val));
} else {
$stmt->bindValue($key, $val);
}
}
}
if (preg_match('/:viewid/', $sql)) {
$stmt->bindValue('viewid', $this->viewId > 0 ? $this->viewId : NULL);
}
if (preg_match('/:views/', $sql)) {
$stmt->bindValue('views', implode(',', $this->viewIds));
}
$stmt->execute();
return $stmt->fetchAll();
}
public function checkPaymentStatus($event, $request)
{
$sql = "SELECT idpaymentmethod FROM paymentmethod WHERE controller = 'paybynet' AND active=1";
$stmt = Db::getInstance()->prepare($sql);
$stmt->execute();
$rs = $stmt->fetch();
if (!$rs) {
return;
}
$settings = $this->registry->core->loadModuleSettings('paybynet', Helper::getViewId());
if (empty($settings)) {
return;
}
$id = $request['id'];
$sql = "SELECT\n\t\t\t\tidorder\n\t\t\tFROM\n\t\t\t\t`order`\n\t\t\tWHERE\n\t\t\t\tidorder = :id\n\t\t\tAND\n\t\t\t\tpaymentmethodid = :paymentmethodid\n\t\t\tAND\n\t\t\t\torderstatusid = :positiveorderstatusid";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('id', $id);
$stmt->bindValue('idpaymentmethod', $rs['idpaymentmethod']);
$stmt->bindValue('positiveorderstatusid', $settings['positiveorderstatusid']);
$stmt->execute();
if ($stmt->fetch()) {
return;
}
try {
$soap = new \SoapClient(self::WSDL);
$statusCode = $soap->getStatusByPaymentID($id, $settings['id_client']);
} catch (\SoapFault $e) {
throw new CoreException('Nie można połączyć się z pbn.paybynet.com.pl');
}
$status = 0;
if ($statusCode >= 1000 && $statusCode <= 1012) {
$status = $settings['verificationrejectedorderstatusid'];
$comment = 'Weryfikacja odrzucona';
} else {
if ($statusCode == 2303) {
$status = $settings['positiveorderstatusid'];
$comment = 'Płatność zakończona sukcesem';
} else {
if ($statusCode == 2301 || $statusCode == 2302) {
$status = $settings['negativeorderstatusid'];
$comment = 'Płatność zakończona niepowodzeniem';
}
}
}
if ($status == 0) {
return;
}
$sql = "UPDATE `order` SET orderstatusid = :status WHERE idorder = :idorder";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('status', $status);
$stmt->bindValue('idorder', $id);
$stmt->execute();
$sql = 'INSERT INTO orderhistory SET
content = :content,
orderstatusid = :status,
orderid = :idorder,
inform = 0';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('content', $comment);
$stmt->bindValue('idorder', $id);
$stmt->bindValue('status', $status);
$stmt->execute();
}
public function addAttributeToGroup($attributeId, $groupId)
{
$sql = 'INSERT INTO attributegroup(attributegroupnameid, attributeproductid)
VALUES (:attributegroupnameid, :attributeproductid)';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('attributegroupnameid', $attributeId);
$stmt->bindValue('attributeproductid', $groupId);
try {
$stmt->execute();
} catch (Exception $e) {
throw new Exception(_('ERR_CATEGORY_ATTRIBUTEPRODUCT_ADD'));
}
}
public function editAttributeCategory($Data, $id)
{
DbTracker::deleteRows('categoryattributeproduct', 'attributeproductid', $id);
foreach ($Data as $key => $categoryid) {
$sql = 'INSERT INTO categoryattributeproduct(categoryid, attributeproductid) VALUES (:categoryid, :attributeproductid)';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('categoryid', $categoryid);
$stmt->bindValue('attributeproductid', $id);
try {
$stmt->execute();
} catch (Exception $e) {
throw new Exception($e->getMessage());
}
}
}
public function getUnitMeasureTranslation($id)
{
$sql = "SELECT \n\t\t\t\t\tname, \n\t\t\t\t\tlanguageid\n\t\t\t\tFROM unitmeasuretranslation\n\t\t\t\tWHERE unitmeasureid =:id";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('id', $id);
$rs = $stmt->execute();
$Data = array();
while ($rs = $stmt->fetch()) {
$Data[$rs['languageid']] = array('name' => $rs['name']);
}
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 ceneooriginal,\n\t\t\t\t \tCN.categoryid,\n\t\t\t\t \tNC.idceneo,\n\t\t\t\t \tCN.ceneoid,\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\t\tNC.path\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 categoryceneo CN ON CN.categoryid = PC.categoryid\n\t\t\t\tINNER JOIN ceneo NC ON NC.idorginal = CN.ceneoid\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', $this->registry->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'], 'ceneo' => str_replace('|', '\\', $rs['path']));
}
foreach ($Data as $key => $Product) {
$Image = App::getModel('gallery')->getOrginalImageById($Product['photoid']);
$Data[$key]['photo'] = App::getModel('gallery')->getImagePath($Image, App::getURLAdress());
}
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 changeNewsletterStatus($id)
{
$sql = "SELECT email, viewid FROM clientnewsletter WHERE idclientnewsletter = :id";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('id', $id);
try {
$stmt->execute();
} catch (Exception $e) {
throw new FrontendException($e->getMessage());
}
$rs = $stmt->fetch();
$sql = "UPDATE clientnewsletter\tSET \n\t\t\t\t\tactivelink= :activelink,\n\t\t\t\t\tactive = 1\n\t\t\t\tWHERE idclientnewsletter = :id";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('activelink', NULL);
$stmt->bindValue('id', $id);
try {
$stmt->execute();
} catch (Exception $e) {
throw new FrontendException($e->getMessage());
}
}
public function getMetadataForPage()
{
$controller = $this->registry->router->getCurrentController();
$Data = array();
$sql = "SELECT\n\t\t\t\t\tVT.keyword_title,\n\t\t\t\t\tC.description,\n\t\t\t\t\tVT.keyword,\n\t\t\t\t\tVT.keyword_description\n\t\t\t\tFROM controller C\n\t\t\t\tLEFT JOIN viewtranslation VT ON VT.viewid = :viewid\n\t\t\t\tWHERE C.name = :controller AND C.mode = 0";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('controller', $controller);
$stmt->bindValue('viewid', Helper::getViewId());
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
if ($rs['keyword_title'] == NULL || $rs['keyword_title'] == '') {
$keyword_title = $controller == 'mainside' ? Session::getActiveShopName() : _($rs['description']);
} else {
$keyword_title = $rs['keyword_title'];
}
$title = $controller == 'mainside' ? $keyword_title : _($rs['description']);
$Data = array('keyword_title' => $title, 'keyword' => $rs['keyword'], 'keyword_description' => $rs['keyword_description']);
}
return $Data;
}
public function getDispatchmethodCountries($id)
{
$sql = "SELECT \n\t\t\t\t\tcountryids\n\t\t\t\tFROM dispatchmethod\n\t\t\t\tWHERE iddispatchmethod = :id";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('id', $id);
$stmt->execute();
$rs = $stmt->fetch();
$countryids = array();
if ($rs) {
if ($rs['countryids'] != '') {
$countryids = explode(',', $rs['countryids']);
}
}
return $countryids;
}
public function checkDefault($id)
{
$sql = 'SELECT pageschemeid FROM view WHERE idview = :viewid';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('viewid', Helper::getViewId());
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
return $rs['pageschemeid'] == $id ? 1 : 0;
}
return 0;
}
public function getWarrantyByProductId($id)
{
$sql = "SELECT F.name, F.idfile\n FROM productwarranty PF\n LEFT JOIN file F ON PF.warrantyid = F.idfile\n WHERE PF.productid = :id";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('id', $id);
try {
$stmt->execute();
} catch (Exception $e) {
throw new FrontendException('Error while doing sql query.', 11, $e->getMessage());
}
return $stmt->fetchAll();
}
public function getOfflineMessage()
{
$sql = 'SELECT offlinetext FROM view WHERE idview = :viewid';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('viewid', Helper::getViewId());
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
return $rs['offlinetext'];
}
}
public function reportPayment()
{
if (in_array($_SERVER['REMOTE_ADDR'], array('195.150.9.37', '217.17.41.5')) && !empty($_POST)) {
$sql = 'SELECT
*
FROM `order`
WHERE sessionid = :crc';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('crc', base64_decode($_POST['control']));
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
$settings = $this->registry->core->loadModuleSettings('dotpay', $rs['viewid']);
$id_sprzedawcy = $_POST['id'];
$m5 = $settings['pin'] . ':' . $settings['idsprzedawcy'] . ':' . $_POST['control'] . ':' . $_POST['t_id'] . ':' . $_POST['amount'] . ':' . $_POST['email'] . ':' . $_POST['service'] . ':' . $_POST['code'] . ':' . $_POST['username'] . ':' . $_POST['password'] . ':' . $_POST['t_status'];
$status_transakcji = $_POST['t_status'];
$id_transakcji = $_POST['t_id'];
$kwota_transakcji = $_POST['amount'];
$email_klienta = $_POST['email'];
$suma_kontrolna = $_POST['md5'];
$status = 0;
if ($_POST['t_status'] == 2) {
$status = $settings['positiveorderstatusid'];
$comment = 'Płatność zakończona sukcesem';
}
if ($_POST['t_status'] == 3) {
$status = $settings['negativeorderstatusid'];
$comment = 'Płatność zakończona niepowodzeniem';
}
if ($status > 0) {
$sql = "UPDATE `order` SET orderstatusid = :status WHERE idorder = :idorder";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('status', $status);
$stmt->bindValue('idorder', $rs['idorder']);
$stmt->execute();
$sql = 'INSERT INTO orderhistory SET
content = :content,
orderstatusid = :status,
orderid = :idorder,
inform = 0';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('content', $comment);
$stmt->bindValue('idorder', $rs['idorder']);
$stmt->bindValue('status', $status);
$stmt->execute();
}
}
print "OK";
exit;
}
}
public function reportPayment()
{
if ($_SERVER['REMOTE_ADDR'] == '195.149.229.109' && !empty($_POST)) {
$id_sprzedawcy = $_POST['id'];
$status_transakcji = $_POST['tr_status'];
$id_transakcji = $_POST['tr_id'];
$kwota_transakcji = $_POST['tr_amount'];
$kwota_zaplacona = $_POST['tr_paid'];
$blad = $_POST['tr_error'];
$data_transakcji = $_POST['tr_date'];
$opis_transackji = $_POST['tr_desc'];
$ciag_pomocniczy = $_POST['tr_crc'];
$email_klienta = $_POST['tr_email'];
$suma_kontrolna = $_POST['md5sum'];
$sql = 'SELECT
viewid,
idorder
FROM `order`
WHERE sessionid = :crc';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('crc', base64_decode($ciag_pomocniczy));
$stmt->execute();
$rs = $stmt->fetch();
if ($rs) {
$settings = $this->registry->core->loadModuleSettings('transferuj', $rs['viewid']);
if ($status_transakcji == 'TRUE' && $blad == 'none') {
$status = $settings['positiveorderstatusid'];
$comment = 'Płatność zakończona sukcesem';
} else {
$status = $settings['negativeorderstatusid'];
$comment = 'Płatność zakończona niepowodzeniem';
}
$sql = "UPDATE `order` SET orderstatusid = :status WHERE idorder = :idorder";
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('status', $status);
$stmt->bindValue('idorder', $rs['idorder']);
$stmt->execute();
$sql = 'INSERT INTO orderhistory SET
content = :content,
orderstatusid = :status,
orderid = :idorder,
inform = 0';
$stmt = Db::getInstance()->prepare($sql);
$stmt->bindValue('content', $comment);
$stmt->bindValue('idorder', $rs['idorder']);
$stmt->bindValue('status', $status);
$stmt->execute();
}
echo 'TRUE';
}
}
