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);
}
