public function statisticObject()
{
global $rbacsystem, $ilToolbar, $ilObjDataCache;
include_once './Services/Payment/classes/class.ilPayMethods.php';
// MINIMUM ACCESS LEVEL = 'read'
if (!$rbacsystem->checkAccess('read', $this->object->getRefId())) {
$this->ilErr->raiseError($this->lng->txt('msg_no_perm_read'), $this->ilErr->MESSAGE);
}
$ilToolbar->addButton($this->lng->txt('paya_add_customer'), $this->ctrl->getLinkTarget($this, 'showObjectSelector'));
if ($_POST['updateView'] == 1) {
$_SESSION['pay_statistics']['show_filter'] = $_POST['show_filter'];
$_SESSION['pay_statistics']['updateView'] = true;
$_SESSION['pay_statistics']['until_check'] = $_POST['until_check'];
$_SESSION['pay_statistics']['from_check'] = $_POST['from_check'];
$_SESSION['pay_statistics']['transaction_type'] = isset($_POST['transaction_type']) ? $_POST['transaction_type'] : '';
$_SESSION['pay_statistics']['transaction_value'] = isset($_POST['transaction_value']) ? $_POST['transaction_value'] : '';
$_SESSION['pay_statistics']['adm_filter_title_id'] = (int) $_POST['adm_filter_title_id'];
if ($_SESSION['pay_statistics']['from_check'] == '1') {
$_SESSION['pay_statistics']['from']['date']['d'] = $_POST['from']['date']['d'];
$_SESSION['pay_statistics']['from']['date']['m'] = $_POST['from']['date']['m'];
$_SESSION['pay_statistics']['from']['date']['y'] = $_POST['from']['date']['y'];
} else {
$_SESSION['pay_statistics']['from']['date']['d'] = '';
$_SESSION['pay_statistics']['from']['date']['m'] = '';
$_SESSION['pay_statistics']['from']['date']['y'] = '';
}
if ($_SESSION['pay_statistics']['until_check'] == '1') {
$_SESSION['pay_statistics']['til']['date']['d'] = $_POST['til']['date']['d'];
$_SESSION['pay_statistics']['til']['date']['m'] = $_POST['til']['date']['m'];
$_SESSION['pay_statistics']['til']['date']['y'] = $_POST['til']['date']['y'];
} else {
$_SESSION['pay_statistics']['til']['date']['d'] = '';
$_SESSION['pay_statistics']['til']['date']['m'] = '';
$_SESSION['pay_statistics']['til']['date']['y'] = '';
}
$_SESSION['pay_statistics']['payed'] = $_POST['payed'];
$_SESSION['pay_statistics']['access'] = $_POST['access'];
$_SESSION['pay_statistics']['pay_method'] = $_POST['pay_method'];
$_SESSION['pay_statistics']['customer'] = isset($_POST['customer']) ? $_POST['customer'] : '';
$_SESSION['pay_statistics']['vendor'] = isset($_POST['vendor']) ? $_POST['vendor'] : '';
}
$this->tpl->addBlockfile('ADM_CONTENT', 'adm_content', 'tpl.main_view.html', 'Services/Payment');
$filter_form = new ilPropertyFormGUI();
$filter_form->setFormAction($this->ctrl->getFormAction($this));
$filter_form->setTitle($this->lng->txt('pay_filter'));
$filter_form->setId('formular');
$filter_form->setTableWidth('100 %');
//filter
$o_hide_check = new ilCheckBoxInputGUI($this->lng->txt('show_filter'), 'show_filter');
$o_hide_check->setValue(1);
$o_hide_check->setChecked($_POST['show_filter'] ? 1 : 0);
$o_hidden = new ilHiddenInputGUI('updateView');
$o_hidden->setValue(1);
$o_hidden->setPostVar('updateView');
$o_hide_check->addSubItem($o_hidden);
$o_transaction_type = new ilSelectInputGUI();
$trans_option = array($this->lng->txt('pay_starting'), $this->lng->txt('pay_ending'));
$trans_value = array('0', '1');
$o_transaction_type->setTitle($this->lng->txt('paya_transaction'));
$o_transaction_type->setOptions($trans_option);
$o_transaction_type->setValue($_SESSION['pay_statistics']['transaction_type']);
$o_transaction_type->setPostVar('transaction_type');
$o_hide_check->addSubItem($o_transaction_type);
$o_transaction_val = new ilTextInputGUI();
$o_transaction_val->setValue($_SESSION['pay_statistics']['transaction_value']);
$o_transaction_val->setPostVar('transaction_value');
$o_hide_check->addSubItem($o_transaction_val);
$o_customer = new ilTextInputGUI();
$o_customer->setTitle($this->lng->txt('paya_customer'));
$o_customer->setValue($_SESSION['pay_statistics']['customer']);
$o_customer->setPostVar('customer');
$o_hide_check->addSubItem($o_customer);
$o_vendor = new ilTextInputGUI();
$o_vendor->setTitle($this->lng->txt('paya_vendor'));
$o_vendor->setValue($_SESSION['pay_statistics']['vendor']);
$o_vendor->setPostVar('vendor');
$o_hide_check->addSubItem($o_vendor);
$o_from_check = new ilCheckBoxInputGUI($this->lng->txt('pay_order_date_from'), 'from_check');
$o_from_check->setValue(1);
$o_from_check->setChecked($_SESSION['pay_statistics']['from_check'] ? 1 : 0);
$o_date_from = new ilDateTimeInputGUI();
$o_date_from->setPostVar('from');
if ($_SESSION['pay_statistics']['from_check'] == '1') {
$o_date_from->setValueByArray($_SESSION['pay_statistics']['from']);
$o_date_from->checkInput();
}
$o_from_check->addSubItem($o_date_from);
$o_hide_check->addSubItem($o_from_check);
$o_until_check = new ilCheckBoxInputGUI($this->lng->txt('pay_order_date_til'), 'until_check');
$o_until_check->setValue(1);
$o_until_check->setChecked($_SESSION['pay_statistics']['until_check'] ? 1 : 0);
$o_date_until = new ilDateTimeInputGUI();
$o_date_until->setPostVar('til');
if ($_SESSION['pay_statistics']['until_check'] == '1') {
$o_date_until->setValueByArray($_SESSION['pay_statistics']['til']);
$o_date_until->checkInput();
}
$o_until_check->addSubItem($o_date_until);
$o_hide_check->addSubItem($o_until_check);
// title filter
$this->__initBookingObject();
$title_options['all'] = $this->lng->txt('pay_all');
$unique_titles = $this->booking_obj->getUniqueTitles();
if (is_array($unique_titles) && count($unique_titles)) {
foreach ($unique_titles as $ref_id) {
$title_options[$ref_id] = $ilObjDataCache->lookupTitle($ilObjDataCache->lookupObjId($ref_id));
}
}
$o_object_title = new ilSelectInputGUI();
$o_object_title->setTitle($this->lng->txt('title'));
$o_object_title->setOptions($title_options);
$o_object_title->setValue($_SESSION["pay_statistics"]["adm_filter_title_id"]);
$o_object_title->setPostVar('adm_filter_title_id');
$o_hide_check->addSubItem($o_object_title);
$o_payed = new ilSelectInputGUI();
$payed_option = array('all' => $this->lng->txt('pay_all'), '1' => $this->lng->txt('yes'), '0' => $this->lng->txt('no'));
$o_payed->setTitle($this->lng->txt('paya_payed'));
$o_payed->setOptions($payed_option);
$o_payed->setValue($_SESSION['pay_statistics']['payed']);
$o_payed->setPostVar('payed');
$o_hide_check->addSubItem($o_payed);
$o_access = new ilSelectInputGUI();
$access_option = array('all' => $this->lng->txt('pay_all'), '1' => $this->lng->txt('yes'), '0' => $this->lng->txt('no'));
$o_access->setTitle($this->lng->txt('paya_access'));
$o_access->setOptions($access_option);
$o_access->setValue($_SESSION['pay_statistics']['access']);
$o_access->setPostVar('access');
$o_hide_check->addSubItem($o_access);
$o_paymethod = new ilSelectInputGUI();
$o_paymethod->setTitle($this->lng->txt('payment_system'));
$o_paymethod->setOptions(ilPaymethods::getPayMethodsOptions('all'));
$o_paymethod->setValue($_SESSION['pay_statistics']['pay_method']);
$o_paymethod->setPostVar('pay_method');
$o_hide_check->addSubItem($o_paymethod);
$filter_form->addCommandButton('statistic', $this->lng->txt('pay_update_view'));
$filter_form->addCommandButton('resetFilter', $this->lng->txt('pay_reset_filter'));
$filter_form->addItem($o_hide_check);
$this->tpl->setVariable('FORM', $filter_form->getHTML());
//else $filter_form->checkInput();
// STATISTICS TABLE
$this->__initBookingObject();
if (!count($bookings = $this->booking_obj->getBookings())) {
ilUtil::sendInfo($this->lng->txt('paya_no_bookings'));
return true;
}
# else
# {
# $this->__showButton('exportVendors',$this->lng->txt('excel_export'));
# }
include_once 'Services/User/classes/class.ilObjUser.php';
$object_title_cache = array();
$user_title_cache = array();
$counter = 0;
foreach ($bookings as $booking) {
if (array_key_exists($booking['ref_id'], $object_title_cache)) {
$tmp_obj = $object_title_cache[$booking['ref_id']];
} else {
$tmp_obj = ilObject::_lookupTitle(ilObject::_lookupObjId($booking['ref_id']));
$object_title_cache[$booking['ref_id']] = $tmp_obj;
}
if (array_key_exists($booking['b_vendor_id'], $user_title_cache)) {
$tmp_vendor = $user_title_cache[$booking['b_vendor_id']];
} else {
$tmp_vendor = ilObjUser::_lookupLogin($booking['b_vendor_id']);
$user_title_cache[$booking['b_vendor_id']] = $tmp_vendor;
}
if (array_key_exists($booking['customer_id'], $user_title_cache)) {
$tmp_purchaser = $user_title_cache[$booking['customer_id']];
} else {
if (ANONYMOUS_USER_ID == $booking['customer_id']) {
$tmp_purchaser = ilObjUser::_lookupLogin($booking['customer_id']);
$purchaser_name = $booking['name_extern'];
$tmp_purchaser_email = $booking['email_extern'];
} else {
$tmp_purchaser = ilObjUser::_lookupLogin($booking['customer_id']);
$tmp_purchaser_name = ilObjUser::_lookupName($booking['customer_id']);
$purchaser_name = $tmp_purchaser_name['firstname'] . ' ' . $tmp_purchaser_name['lastname'];
$tmp_purchaser_email = ilObjUser::_lookupEmail($booking['customer_id']);
}
$user_title_cache[$booking['customer_id']] = $tmp_purchaser;
}
$transaction = $booking['transaction_extern'];
$str_paymethod = ilPayMethods::getStringByPaymethod($booking['b_pay_method']);
$transaction .= $booking['transaction'] . "<br> (" . $str_paymethod . ")";
$f_result[$counter]['transaction'] = $transaction;
$f_result[$counter]['object_title'] = $tmp_obj != '' ? $tmp_obj : $this->lng->txt('object_deleted');
$f_result[$counter]['vendor'] = $tmp_vendor != '' ? '[' . $tmp_vendor . ']' : $this->lng->txt('user_deleted');
$f_result[$counter]['customer'] = $tmp_purchaser != '' ? $purchaser_name . ' [' . $tmp_purchaser . ']<br>' . $tmp_purchaser_email : $this->lng->txt('user_deleted');
$f_result[$counter]['order_date'] = ilDatePresentation::formatDate(new ilDate($booking['order_date'], IL_CAL_UNIX));
if ($booking['duration'] == 0 && $booking['access_enddate'] == NULL) {
$f_result[$counter]['duration'] = $this->lng->txt("unlimited_duration");
} else {
// if($booking['duration'] > 0 )
// {
// $f_result[$counter]['duration'] = $booking['duration'].' '.$this->lng->txt('paya_months').' / </br>';
// }
$f_result[$counter]['duration'] .= ilDatePresentation::formatDate(new ilDate($booking['access_startdate'], IL_CAL_DATETIME)) . ' - ' . ilDatePresentation::formatDate(new ilDate($booking['access_enddate'], IL_CAL_DATETIME));
}
$f_result[$counter]['price'] = $booking['price'] . ' ' . $booking['currency_unit'];
$f_result[$counter]['discount'] = $booking['discount'] != '' ? $booking['discount'] . ' ' . $booking['currency_unit'] : ' ';
$payed_access = $booking['payed'] ? $this->lng->txt('yes') : $this->lng->txt('no');
$payed_access .= '/';
$payed_access .= $booking['access_granted'] ? $this->lng->txt('yes') : $this->lng->txt('no');
$f_result[$counter]['payed_access'] = $payed_access;
$this->ctrl->setParameter($this, "booking_id", $booking['booking_id']);
$link_change = "<div class=\"il_ContainerItemCommands\"><a class=\"il_ContainerItemCommand\" href=\"" . $this->ctrl->getLinkTarget($this, "editStatistic") . "\">" . $this->lng->txt("edit") . "</a></div>";
$f_result[$counter]['edit'] = $link_change;
unset($tmp_obj);
unset($tmp_vendor);
unset($tmp_purchaser);
++$counter;
}
return $this->__showStatisticTable($f_result);
}
public function addCoupon()
{
$this->tpl->addBlockfile('ADM_CONTENT', 'adm_content', 'tpl.main_view.html', 'Services/Payment');
if (isset($_GET['coupon_id'])) {
if ($this->error == '') {
$this->coupon_obj->getCouponById($_GET['coupon_id']);
}
$this->ctrl->setParameter($this, 'coupon_id', $this->coupon_obj->getId());
$this->__showButtons();
}
$oForm = new ilPropertyFormGUI();
$oForm->setId('frm_add_coupon');
$oForm->setFormAction($this->ctrl->getFormAction($this, 'saveCouponForm'));
$oForm->setTitle($this->coupon_obj->getId() ? $this->lng->txt('paya_coupons_edit') : $this->lng->txt('paya_coupons_add'));
// Title
$oTitle = new ilTextInputGUI($this->lng->txt(paya_coupons_title), 'title');
$oTitle->setValue($this->coupon_obj->getTitle());
$oTitle->setRequired(true);
$oForm->addItem($oTitle);
// Description
$oDescription = new ilTextAreaInputGUI($this->lng->txt(paya_coupons_description), 'description');
$oDescription->setValue($this->coupon_obj->getDescription());
$oForm->addItem($oDescription);
// Type
$o_coupon_type = new ilSelectInputGUI();
$coupon_option = array('fix' => $this->lng->txt('paya_coupons_fix'), 'percent' => $this->lng->txt('paya_coupons_percentaged'));
$o_coupon_type->setTitle($this->lng->txt('coupon_type'));
$o_coupon_type->setOptions($coupon_option);
$o_coupon_type->setValue($this->coupon_obj->getType());
$o_coupon_type->setRequired(true);
$o_coupon_type->setPostVar('coupon_type');
$oForm->addItem($o_coupon_type);
// Value
$o_coupon_value = new ilNumberInputGUI($this->lng->txt('paya_coupons_value'), 'coupon_value');
$o_coupon_value->setSize(5);
$o_coupon_value->allowDecimals(true);
$o_coupon_value->setValue($this->coupon_obj->getValue());
$o_coupon_value->setRequired(true);
$oForm->addItem($o_coupon_value);
// Date Valid From
$o_from_check = new ilCheckBoxInputGUI($this->lng->txt('paya_coupons_from'), 'from_check');
$o_from_check->setValue(1);
$o_from_check->setChecked($this->coupon_obj->getFromDateEnabled() ? 1 : 0);
$o_date_from = new ilDateTimeInputGUI();
$o_date_from->setPostVar('from');
$from_date = explode('-', $this->coupon_obj->getFromDate());
$date_f['from']['date']['d'] = $from_date[2] != '00' ? $from_date[2] : '';
$date_f['from']['date']['m'] = $from_date[1] != '00' ? $from_date[1] : '';
$date_f['from']['date']['y'] = $from_date[0] != '0000' ? $from_date[0] : '';
$_POST['from'] = $date_f['from'];
if ($this->coupon_obj->getFromDateEnabled() == '1') {
$o_date_from->checkInput();
}
$o_from_check->addSubItem($o_date_from);
$oForm->addItem($o_from_check);
// Date Valid Until
$o_until_check = new ilCheckBoxInputGUI($this->lng->txt('paya_coupons_till'), 'until_check');
$o_until_check->setValue(1);
$o_until_check->setChecked($this->coupon_obj->getTillDateEnabled() ? 1 : 0);
$o_date_until = new ilDateTimeInputGUI();
$o_date_until->setPostVar('til');
$till_date = explode('-', $this->coupon_obj->getTillDate());
$date_t['til']['date']['d'] = $till_date[2] != '00' ? $till_date[2] : '';
$date_t['til']['date']['m'] = $till_date[1] != '00' ? $till_date[1] : '';
$date_t['til']['date']['y'] = $till_date[0] != '0000' ? $till_date[0] : '';
$_POST['til'] = $date_t['til'];
if ($this->coupon_obj->getTillDateEnabled() == '1') {
$o_date_until->checkInput();
}
$o_until_check->addSubItem($o_date_until);
$oForm->addItem($o_until_check);
$o_usage = new ilNumberInputGUI($this->lng->txt('paya_coupons_availability'), 'usage');
$o_usage->setSize(5);
$o_usage->setValue($this->coupon_obj->getUses());
$oForm->addItem($o_usage);
$oForm->addCommandButton('saveCouponForm', $this->lng->txt('save'));
$oForm->addCommandButton('showCoupons', $this->lng->txt('cancel'));
$this->tpl->setVariable('FORM', $oForm->getHTML());
}