<?php
use_class('dti', DIR_WS_CLASSES);
$class_dti = new dti();
if (isset($_POST['dti_referrers'])) {
$dti_referrers = $_POST['dti_referrers'] == '' ? null : tep_db_prepare_input($_POST['dti_referrers']);
$begin_text = tep_db_prepare_input($_POST['begin_text']);
$end_text = tep_db_prepare_input($_POST['end_text']);
if (!isset($_SESSION['dti-filters'])) {
$_SESSION['dti-filters'] = array();
}
$_SESSION['dti-filters']['dti_referrers'] = $dti_referrers;
$_SESSION['dti-filters']['begin_text'] = $begin_text;
$_SESSION['dti-filters']['end_text'] = $end_text;
} else {
if (isset($_SESSION['dti-filters']) && is_array($_SESSION['dti-filters'])) {
$dti_referrers = $_SESSION['dti-filters']['dti_referrers'];
$begin_text = $_SESSION['dti-filters']['begin_text'];
$end_text = $_SESSION['dti-filters']['end_text'];
} else {
$dti_referrers = null;
$begin_text = date('Y-m-01');
$end_text = date('Y-m-d');
}
}
$dti_ref_filter = $class_dti->drawReferrerCombo('dti_referrers', $dti_referrers, 'No Referrer Filter');
$dti_stat_filter = $class_dti->drawStatusCombo('dti_com_status', $dti_com_status, 'No Status Filter');
$begin = strtotime($begin_text);
$end = strtotime($end_text);
$commissions = $class_dti->retrieveFilteredCommissions($dti_referrers, $begin, $end, $status);
$cancels = $class_dti->retrieveFilteredCommissionsCancel($dti_referrers, $begin, $end, $status);
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('dti', DIR_WS_CLASSES);
$class_dti = new dti();
if (isset($_GET['ref']) && $_GET['ref'] != '') {
$referrer = tep_db_prepare_input($_GET['ref']);
if (isset($_GET['orders']) && $_GET['orders'] != '') {
$orderlist = tep_db_prepare_input($_GET['orders']);
$orders = explode(',', $orderlist);
foreach ($orders as $order_id) {
$genCommission = true;
$comExist = $class_dti->retrieveCommissionDetail($order_id);
if (!is_null($comExist)) {
if ($comExist['dti_referrers_id'] == '0') {
$delete = tep_db_query("DELETE FROM dti_commissions WHERE orders_id={$order_id}");
if (!$delete) {
$genCommission = false;
}
}
}
if ($genCommission) {
$class_dti->generateCommission($referrer, $order_id);
}
}
}
$result['class'] = 'unpaid';
$result['status'] = 'ORDER UNPAID';
}
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'REVIVEORDER') {
$result = '';
$order_id = tep_db_prepare_input($_POST['order_id']);
$order = $class_o->retrieveDetail($order_id);
if ($order['paid_status'] != '1') {
$result = '<h3 class="red">REVIVE FAILED!</h3><div>Order is still <strong>UNPAID</strong></div>';
} else {
$products = $class_o->retrieveProducts($order_id);
if ($order['dti_referrers_id_commission'] != '0') {
use_class('dti', DIR_WS_CLASSES);
$class_dti = new dti();
$any_deletion_failed = false;
foreach ($products as $key => $p) {
$opid = $p['orders_products_id'];
$deleted = $class_dti->deleteCommissionCancel($opid);
if (!$deleted) {
unset($products[$key]);
$any_deletion_failed = true;
}
}
}
if (count($products) == 0) {
$result = '<h3 class="red">REVIVE FAILED!</h3><div>ALL Commissions cancellation are already reported to Partner</div>';
} else {
foreach ($products as $p) {
$opid = $p['orders_products_id'];
include DIR_WS_EMAILS . $languages[2]['path'] . '/' . $email_content;
$from_email_name = FROM_EMAIL_NAME;
$from_email_address = FROM_EMAIL_ADDRESS;
$sent = tep_mail($to_name, $to_email_address, $email_subject, $email_text, $from_email_name, $from_email_address);
if ($sent) {
$result = $return_id;
$class_o->updateReturnDetail($return_id, 'email_last_sent', date('Y-m-d H:i:s'));
if ($return['return_type'] == 'C' && $return['product_received'] == '1' && $cb_detail['chargedback_status'] == '1') {
$class_o->updateReturnDetail($return_id, 'return_status', '1');
$commission_cancel = array();
$ccd = array();
$ccd['orders_products_id'] = $return['orders_products_id'];
$ccd['qty'] = $return['return_qty'];
$commission_cancel[] = $ccd;
use_class('dti', DIR_WS_CLASSES);
$class_dti = new dti();
$class_dti->generateCommissionCancel('R', $commission_cancel);
}
tep_mail(EMAIL_NAME_SERVICE, EMAIL_ADDRESS_SERVICE, $email_subject, $email_text, $from_email_name, $from_email_address);
}
}
echo utf8_encode($result);
exit;
} elseif ($_POST['me_action'] == 'SENDDELAYINFORMATION') {
$opid = tep_db_prepare_input($_POST['op_id']);
if ($class_o->isDelayInfoSent($opid)) {
$result = 'Delay Info for this product is already sent.';
} else {
//SEND NOTIFICATION "ITEM DELIVERY DELAY"
$item = $class_o->retrieveProductDetail($opid);
$order = $class_o->retrieveDetail($item['orders_id']);
<?php
if (isset($_GET['id']) && $_GET['id'] != '') {
$dtipartner_id = tep_db_prepare_input($_GET['id']);
} else {
header('Location: ?open=dti-partners');
exit;
}
use_class('dti', DIR_WS_CLASSES);
$class_dti = new dti();
//SUBMIT ACTION
if (isset($_POST)) {
if ($_POST['me_action'] == 'DTIPARTNERDELETE') {
/*
$exist_query = tep_db_query("SELECT jng_sp_id FROM jng_sp WHERE jng_sp_id=$dtipartner_id");
if(tep_db_num_rows($exist_query)>0) {
$check1_query = tep_db_query("SELECT * FROM minierp_groups_credentials WHERE dtipartners_id=$dtipartner_id");
$check1 = (tep_db_num_rows($check1_query)==0);
if($check1) {
tep_db_query("DELETE FROM jng_sp WHERE jng_sp_id=$dtipartner_id");
$messagebox->add("Module ID: <strong>$dtipartner_id</strong> is successfully deleted.");
$dtipartner_id = 'new';
} else {
$messagebox->add('<strong>Module Deletion Failed:</strong>');
if(!$check1) $messagebox->add('• Module is still connected to 1 or more group.');
}
} else {
$messagebox->add("Module ID: <strong>$dtipartner_id</strong> is not found on database.");
$dtipartner_id = 'new';
}
*/
<?php
use_class('dti', DIR_WS_CLASSES);
$class_dti = new dti();
//START TEMPLATE
$dtilists = $class_dti->retrieveReferrerList();
$parentnames = array();
$dtipartners = array();
$dtiparents = array();
$dtichilds = array();
if (count($dtilists) > 0) {
foreach ($dtilists as $row) {
if ($row['dti_parent_id'] == '0') {
$dtiparents[] = $row;
$parentnames[$row['dti_referrers_id']] = $row['dti_referrers_name'];
} else {
$parent = $row['dti_parent_id'];
if (!isset($dtichilds[$parent])) {
$dtichilds[$parent] = array();
}
$dtichilds[$parent][] = $row;
}
}
}
foreach ($dtiparents as $dtip) {
$parent_id = $dtip['dti_referrers_id'];
$dtipartners[] = $dtip;
if (isset($dtichilds[$parent_id]) && count($dtichilds[$parent_id]) > 0) {
foreach ($dtichilds[$parent_id] as $child) {
$dtipartners[] = $child;
}
<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('orders');
$class_o = new orders();
use_class('dti', DIR_WS_CLASSES);
$class_dti = new dti();
$orders = array(3615);
$products = array();
foreach ($orders as $orders_id) {
$products[$orders_id] = array();
$orders_products = $class_o->retrieveProducts($orders_id);
foreach ($orders_products as $op) {
$cd = array();
$cd['orders_products_id'] = $op['orders_products_id'];
$cd['qty'] = $op['products_quantity'];
$products[$orders_id][] = $cd;
}
}
foreach ($products as $canceldata) {
$class_dti->generateCommissionCancel('C', $canceldata);
}
tep_db_close();
<?php
use_class('dti', DIR_WS_CLASSES);
$class_dti = new dti();
if (isset($_SESSION['dti-filters']) && is_array($_SESSION['dti-filters'])) {
$begin_text = $_SESSION['dti-filters']['begin_text'];
$end_text = $_SESSION['dti-filters']['end_text'];
} else {
$begin_text = date('Y-m-01');
$end_text = date('Y-m-d');
}
$dti_referrers = null;
$begin = strtotime($begin_text);
$end = strtotime($end_text);
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'MARKCOMMISSIONASPAID') {
if (isset($_POST['refid']) && is_array($_POST['refid']) && count($_POST['refid']) > 0) {
$class_dti->updateCommissionStatus($_POST['refid'], $begin, $end, $session_userinfo['username']);
$messagebox->add("All unpaid commissions of selected Partners are set as Paid", 'green');
}
}
}
$commissions = $class_dti->retrieveFilteredCommissions($dti_referrers, $begin, $end, $status);
$cancels = $class_dti->retrieveFilteredCommissionsCancel($dti_referrers, $begin, $end, $status);
if (isset($_GET['format']) && $_GET['format'] == 'csv') {
$head = 'Period ' . date('d.m.Y', $begin) . ' - ' . date('d.m.Y', $end);
$data = $class_dti->drawCommissionPaymentOverviewTable($commissions, $cancels, 'csv');
$file_name = 'jng-dti-commissions-' . date('Ymd-Hi') . '.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"{$file_name}\"");
header("Cache-Control: cache, must-revalidate");
