function _notify_url() { $db = JFactory::getDBO(); $par = JComponentHelper::getParams('com_djclassifieds'); $user = JFactory::getUser(); $id = JRequest::getInt('id', '0'); $app = JFactory::getApplication(); $itemid = JRequest::getInt("Itemid", ""); $przelewy24_info = $_POST; $przelewy24_ipn = new przelewy24_ipn(); $p24_session_id = $_POST["p24_session_id"]; $p24_order_id = $_POST["p24_order_id"]; $p24_id_sprzedawcy = $this->params["p24_id"]; $query = "SELECT p.* FROM #__djcf_payments p " . "WHERE p.id='" . $id . "' "; $db->setQuery($query); $payment = $db->loadObject(); $p24_kwota = $payment->price * 100; // $p24_kwota = WYNIK POBRANY Z TWOJEJ BAZY (w groszach) $res = $przelewy24_ipn->send_response($p24_id_sprzedawcy, $p24_session_id, $p24_order_id, $p24_kwota, $this->params); //print_R($res);die(); if ($res[0] != 'TRUE') { $message = JTExt::_('PLG_DJCFPRZELEWY24_AFTER_ERROR_MSG'); $redirect = 'index.php?option=com_djclassifieds&view=items&cid=0&Itemid=' . $itemid; $app->redirect($redirect, $message); die; } else { if ($payment) { $query = "UPDATE #__djcf_payments SET status='Completed',transaction_id='" . $p24_session_id . "' " . "WHERE id=" . $id . " AND method='djcfPrzelewy24'"; $db->setQuery($query); $db->query(); if ($payment->type == 2) { $date_sort = date("Y-m-d H:i:s"); $query = "UPDATE #__djcf_items SET date_sort='" . $date_sort . "' " . "WHERE id=" . $payment->item_id . " "; $db->setQuery($query); $db->query(); } else { if ($payment->type == 1) { $query = "SELECT p.points FROM #__djcf_points p WHERE p.id='" . $payment->item_id . "' "; $db->setQuery($query); $points = $db->loadResult(); $query = "INSERT INTO #__djcf_users_points (`user_id`,`points`,`description`) " . "VALUES ('" . $payment->user_id . "','" . $points . "','" . JText::_('COM_DJCLASSIFIEDS_POINTS_PACKAGE') . " Przelewy24 <br />" . JText::_('COM_DJCLASSIFIEDS_PAYMENT_ID') . ' ' . $payment->id . "')"; $db->setQuery($query); $db->query(); } else { $query = "SELECT c.* FROM #__djcf_items i, #__djcf_categories c " . "WHERE i.cat_id=c.id AND i.id='" . $payment->item_id . "' "; $db->setQuery($query); $cat = $db->loadObject(); $pub = 0; if ($cat->autopublish == '1' || $cat->autopublish == '0' && $par->get('autopublish') == '1') { $pub = 1; } $query = "UPDATE #__djcf_items SET payed=1, pay_type='', published='" . $pub . "' " . "WHERE id=" . $payment->item_id . " "; $db->setQuery($query); $db->query(); } } } } $message = JTExt::_('PLG_DJCFPRZELEWY24_AFTER_SUCCESSFULL_MSG'); $redirect = 'index.php?option=com_djclassifieds&view=items&cid=0&Itemid=' . $itemid; $app->redirect($redirect, $message); }
function _notify_url() { $db = JFactory::getDBO(); $par = JComponentHelper::getParams('com_djclassifieds'); $user = JFactory::getUser(); $id = JRequest::getInt('id', '0'); $app = JFactory::getApplication(); $itemid = JRequest::getInt("Itemid", ""); $przelewy24_info = $_POST; $przelewy24_ipn = new przelewy24_ipn(); $p24_session_id = $_POST["p24_session_id"]; $p24_order_id = $_POST["p24_order_id"]; $p24_id_sprzedawcy = $this->params["p24_id"]; $query = "SELECT p.* FROM #__djcf_payments p " . "WHERE p.id='" . $id . "' "; $db->setQuery($query); $payment = $db->loadObject(); $p24_kwota = $payment->price * 100; // $p24_kwota = WYNIK POBRANY Z TWOJEJ BAZY (w groszach) $res = $przelewy24_ipn->send_response($p24_id_sprzedawcy, $p24_session_id, $p24_order_id, $p24_kwota, $this->params); //print_R($res);die(); if ($res[0] != 'TRUE') { $message = JTExt::_('PLG_DJCFPRZELEWY24_AFTER_ERROR_MSG'); $redirect = 'index.php?option=com_djclassifieds&view=items&cid=0&Itemid=' . $itemid; $app->redirect($redirect, $message); die; } else { if ($payment) { $query = "UPDATE #__djcf_payments SET status='Completed',transaction_id='" . $p24_session_id . "' " . "WHERE id=" . $id . " AND method='djcfPrzelewy24'"; $db->setQuery($query); $db->query(); if ($row->type == 3) { //subscription plans $query = "SELECT p.* FROM #__djcf_plans p WHERE p.id='" . $row->item_id . "' "; $db->setQuery($query); $plan = $db->loadObject(); $registry = new JRegistry(); $registry->loadString($plan->params); $plan_params = $registry->toObject(); //echo '<pre>';print_r($plan_params);die(); $date_start = date("Y-m-d H:i:s"); $date_exp = ''; if ($plan_params->days_limit) { $date_exp_time = time() + $plan_params->days_limit * 24 * 60 * 60; $date_exp = date("Y-m-d H:i:s", $date_exp_time); } $query = "INSERT INTO #__djcf_plans_subscr (`user_id`,`plan_id`,`adverts_limit`,`adverts_available`,`date_start`,`date_exp`,`plan_params`) " . "VALUES ('" . $row->user_id . "','" . $plan->id . "','" . $plan_params->ad_limit . "','" . $plan_params->ad_limit . "','" . $date_start . "','" . $date_exp . "','" . addslashes($plan->params) . "')"; $db->setQuery($query); $db->query(); $message = JText::_('COM_DJCLASSIFIEDS_STATUS_CHANGED_SUBSCRIPTION_PLAN_ADDED'); } else { if ($payment->type == 2) { $date_sort = date("Y-m-d H:i:s"); $query = "UPDATE #__djcf_items SET date_sort='" . $date_sort . "' " . "WHERE id=" . $payment->item_id . " "; $db->setQuery($query); $db->query(); } else { if ($payment->type == 1) { $query = "SELECT p.points FROM #__djcf_points p WHERE p.id='" . $payment->item_id . "' "; $db->setQuery($query); $points = $db->loadResult(); $query = "INSERT INTO #__djcf_users_points (`user_id`,`points`,`description`) " . "VALUES ('" . $payment->user_id . "','" . $points . "','" . JText::_('COM_DJCLASSIFIEDS_POINTS_PACKAGE') . " Przelewy24 <br />" . JText::_('COM_DJCLASSIFIEDS_PAYMENT_ID') . ' ' . $payment->id . "')"; $db->setQuery($query); $db->query(); } else { $query = "SELECT c.* FROM #__djcf_items i, #__djcf_categories c " . "WHERE i.cat_id=c.id AND i.id='" . $payment->item_id . "' "; $db->setQuery($query); $cat = $db->loadObject(); $pub = 0; if ($cat->autopublish == '1' || $cat->autopublish == '0' && $par->get('autopublish') == '1') { $pub = 1; } $query = "UPDATE #__djcf_items SET payed=1, pay_type='',extra_images_to_pay='0',extra_chars_to_pay='0', published='" . $pub . "' " . "WHERE id=" . $payment->item_id . " "; $db->setQuery($query); $db->query(); if ($pub) { DJClassifiedsNotify::notifyUserPublication($payment->item_id, '1'); } } } } $payment->status = 'Completed'; $dispatcher = JDispatcher::getInstance(); $dispatcher->trigger('onAfterPaymentStatusChange', array($payment)); } } $message = JTExt::_('PLG_DJCFPRZELEWY24_AFTER_SUCCESSFULL_MSG'); $redirect = 'index.php?option=com_djclassifieds&view=items&cid=0&Itemid=' . $itemid; $app->redirect($redirect, $message); }