function receipt()
{
$order_id = addslashes($_GET['order_id']);
$order = new VpTransaction();
$order->getByID($order_id);
// pr($order);
//TODO : harus dibikin
if ($order->order_acc_id != Account::getMyID() && !in_array("master_admin", Account::getMyRoles())) {
die("hacking attempt");
}
$app = new AppAccount();
$app->getByID($order->order_app_id);
if ($app->app_active == 0) {
die("App not active");
}
$acc = new Account();
$acc->getByID($app->app_client_id);
$paket = new Paket();
$paket->getByID($order->order_paket_id);
$vpData = new VpData();
$arr = $vpData->getWhere("order_id = '{$order_id}' LIMIT 0,1");
if (count($arr) > 0) {
$data = $arr[0];
} else {
$data = new VpData();
}
if ($acc->admin_marketer != "") {
$arrAg = $acc->getWhere("admin_username = '******' LIMIT 0,1");
if (count($arrAg) > 0) {
$agent = $arrAg[0];
}
}
// pr($arr);
?>
<style>
h1{
font-size: 25px;
padding-top: 30px;
}
h3{
font-size: 20px;
font-style: italic;
}
h4{
font-size: 17px;
margin-top: 20px;
margin-bottom: 30px;
}
.billings td{
padding-right: 20px;
padding-bottom: 10px;
}
@media (max-width: 768px) {
.monly {
display: initial;
}
.donly {
display: none;
}
h1{
font-size: 20px;
}
h3{
font-size: 17px;
font-style: italic;
}
h4{
font-size: 14px;
margin-bottom: 30px;
}
.billings td{
padding-bottom: 10px;
}
}
@media (min-width: 768px) {
.monly {
display: none;
}
.donly {
display: initial;
}
}
@media print {
.pure-toggle-label[data-toggle-label='left']{
display: none;
}
#printme{
display: none;
}
body{
background-color: #ffffff;
}
}
</style>
<div class="container attop" >
<div class="col-md-8 col-md-offset-2">
<div style="text-align: center; background-color: #ffffff; padding: 20px; min-height: 800px; margin-top: 20px; padding-top: 20px; padding-bottom: 20px; ">
<img src="<?php
echo _SPPATH;
?>
images/header_appear.jpg" width="100%">
<h1>PAYMENT RECEIPT</h1>
<h3>Your payment has been completed successfully</h3>
<div class="receipt" style=" margin-top: 30px;">
<h4>TRANSACTION DETAILS</h4>
<table class="billings" align="center" style="text-align: left;">
<tr>
<td>ORDER ID</td>
<td><?php
echo $order_id;
?>
</td>
</tr>
<tr>
<td>PAYMENT DATE / TIME</td>
<td><?php
echo date("F j, Y, g:i a", strtotime($order->order_date));
?>
</td>
</tr>
<tr>
<td>PACKAGE NAME</td>
<td><?php
echo $paket->paket_name;
?>
</td>
</tr>
<tr>
<td>APP ID</td>
<td><?php
echo $app->app_id;
?>
</td>
</tr>
<tr>
<td>ACCOUNT ID</td>
<td><?php
echo $acc->admin_nama_depan;
?>
</td>
</tr>
<tr>
<td>AMOUNT</td>
<td>IDR <?php
echo idr($paket->paket_price);
?>
</td>
</tr>
<tr>
<td>STATUS</td>
<td><?php
echo $data->transaction_status;
?>
</td>
</tr>
<tr>
<td>PAYMENT TYPE</td>
<td><?php
echo $data->payment_type;
?>
</td>
</tr>
<tr>
<td>BANK NAME</td>
<td><?php
echo $data->bank;
?>
</td>
</tr>
<?php
if (count($arrAg) > 0) {
?>
<tr>
<td>AGENT ID</td>
<td><?php
echo $agent->admin_username;
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
</div>
<div id="printme" style="text-align: right; margin-top: 5px; margin-bottom: 100px;" >
<a href="#" onclick="window.print();"><i class="glyphicon glyphicon-print"></i> print</a> |
<a href="<?php
echo _SPPATH;
?>
myOrders">back to my transactions</a>
</div>
</div>
</div>
<?php
}
function free()
{
$app = new AppAccount();
$arrApp = $app->getWhere("app_active = 1 AND app_type = 1 ORDER BY app_contract_start ASC");
// pr($arrApp);
?>
<h1>Free Approval Queue</h1>
<div class="table-responsive">
<table class="table table-striped">
<thead>
<tr>
<th>
App Details
</th>
<th>
Organization Details
</th>
<th>
User & Agent
</th>
<th>
Contract
</th>
<th>
Paket
</th>
<th>
Status
</th>
</tr>
</thead>
<tbody>
<?php
foreach ($arrApp as $app) {
$paket = new Paket();
$paket->getByID($app->app_paket_id);
$acc = new Account();
$acc->getByID($app->app_client_id);
$agent = new Account();
if ($acc->admin_marketer != "") {
$agent->getByUsername($acc->admin_marketer);
}
$vp = new VpTransaction();
$arrT = $vp->getWhere("order_app_id = '{$app->app_id}'");
$free = new AppFree();
$free->getByID($app->app_id);
?>
<tr>
<td>
ID :<?php
echo $app->app_id;
?>
<br>
<?php
echo $app->app_name;
?>
</td>
<td>
Apply Date : <?php
echo $free->free_date;
?>
<br>
Org Name : <?php
echo $free->free_org_name;
?>
<br>
Org Type : <?php
echo $free->free_org_type;
?>
<br>
Address : <?php
echo $free->free_address;
?>
<br>
Contact Name : <?php
echo $free->free_org_name;
?>
<br>
Phone : <?php
echo $free->free_org_name;
?>
<br>
Email : <?php
echo $free->free_org_name;
?>
<br>
Docs : <br><?php
$exp = explode(",", $free->free_org_docs);
foreach ($exp as $x) {
?>
<a href="<?php
echo _SPPATH . _PHOTOURL . "inputfiles/" . $x;
?>
" target="_blank">
<img src="<?php
echo _SPPATH . _PHOTOURL . "inputfiles/" . $x;
?>
" width="100px">
</a>
<?php
}
?>
</td>
<td>
<?php
echo $acc->admin_username;
?>
<?php
echo $acc->admin_nama_depan;
?>
<br>
<?php
echo $acc->admin_email;
?>
<br>
<?php
echo $acc->admin_phone;
?>
<hr>
Agent <br>
<?php
echo $agent->admin_username;
?>
<?php
echo $agent->admin_nama_depan;
?>
<br>
<?php
echo $agent->admin_email;
?>
<br>
<?php
echo $agent->admin_phone;
?>
</td>
<td>Start :
<?php
echo $app->app_contract_start;
?>
<br> End :
<?php
echo $app->app_contract_end;
?>
</td>
<td><?php
echo $paket->paket_name;
?>
</td>
<td>
<?php
echo $app->app_active;
?>
<br>
<button onclick="accept_free('<?php
echo $app->app_id;
?>
');" class="btn btn-default">Accept App</button><br>
<button onclick="reject_free('<?php
echo $app->app_id;
?>
');" class="btn btn-default">Reject App</button><br>
<button onclick="view_free('<?php
echo $app->app_id;
?>
');" class="btn btn-default">View App</button>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<script>
function accept_free(id){
if(confirm("this will accept the app"))
$.post("<?php
echo _SPPATH;
?>
JobBE/actionfree",{app_id:id,action : "accept"},function(data){
console.log(data);
if(data.bool){
alert("Sukses");
lwrefresh('Accept_Free_Apps');
}else{
alert("Gagal");
}
},'json');
}
function reject_free(id){
if(confirm("this will reject the app"))
$.post("<?php
echo _SPPATH;
?>
JobBE/actionfree",{app_id:id,action : "reject"},function(data){
console.log(data);
if(data.bool){
alert("Sukses");
lwrefresh('Accept_Free_Apps');
}else{
alert("Gagal");
}
},'json');
}
function view_free(id){
}
</script>
<?php
}
public static function myorderspage()
{
$arrPaymentStatus = array("1" => array("settlement", "success"), "2" => array("success", "success"), "3" => array("challenge", "failed"), "4" => array("pending", "pending"), "5" => array("deny", "denied"), "6" => array("cancel", "canceled"));
?>
<style>
@media (max-width: 768px) {
.monly {
display: initial;
}
.donly {
display: none;
}
}
@media (min-width: 768px) {
.monly {
display: none;
}
.donly {
display: initial;
}
}
</style>
<style>
.heading_earning{
font-size: 17px;
font-style: italic;
}
.heading_amount{
font-size: 40px;
}
.inside{
padding: 20px;
}
.selectMonth{
/*padding-left: 10px;*/
}
.payout{
color: #95abc2;
}
.money{
font-size: 22px;
color: #73879C;
}
.big{
font-size: 25px;
color: #73879C;
}
.rev_item{
background-color: #ffffff;
margin-top: 20px;
margin-bottom: 20px;
}
.order_id{
font-size: 20px;
color: #73879C;
}
.pdate{
color: #73879C;
font-style: italic;
}
.heading_amount{
font-size: 30px;
text-align: right;
padding-bottom: 100px;
}
.heading_amount_Sales{
font-size: 18px;
text-align: right;
/*padding-bottom: 20px;*/
}
@media (max-width: 768px) {
.monly {
display: initial;
}
.donly {
display: none;
}
.selectMonth{
padding-left: 0px;
padding-bottom: 20px;
border-bottom: 1px solid #CCCCCC;
}
.rightborder{
border-bottom: 1px solid #CCCCCC;
}
.leftborder{
border-top: 1px solid #CCCCCC;
}
.inside{
padding: 10px;
}
.tarmob{
/*text-align: right;*/
}
}
@media (min-width: 768px) {
.monly {
display: none;
}
.donly {
display: initial;
}
.leftborder{
border-left: 1px solid #CCCCCC;
min-height: 120px;
}
.rightborder{
border-right: 1px solid #CCCCCC;
}
}
</style>
<div class="container attop" >
<div class="col-md-12">
<div class="appear_logo_pages">
<a href="<?php
echo _SPPATH;
?>
">
<img src="<?php
echo _SPPATH;
?>
images/appear-order.png" >
</a>
</div>
<?php
$orders = new VpTransaction();
$arrOrder = $orders->getWhere("order_acc_id = '" . Account::getMyID() . "' ORDER BY order_date DESC");
if (count($arrOrder) > 0) {
foreach ($arrOrder as $num => $orders) {
$app = new AppAccount();
$app->getByID($orders->order_app_id);
$paket = new Paket();
$paket->getByID($orders->order_paket_id);
?>
<div class="rev_item col-md-12">
<div class="col-md-5 ">
<div class="inside">
<div class="payout col-md-6 col-sm-6 col-xs-6">
<div class="rev_details2">
<small>Order ID</small>
<div class="order_id"><?php
echo $orders->order_id;
?>
</div>
</div>
</div>
<div class="payout col-md-6 col-sm-6 col-xs-6">
<div class="rev_details">
Date : <?php
echo date("F j, Y, g:i a", strtotime($orders->order_date));
?>
</div>
<div class="rev_details">
App : <?php
echo $app->app_name;
?>
</div>
<div class="rev_details">
Paket : <?php
echo $paket->paket_name;
?>
</div>
</div>
<div class="clearfix"></div>
</div>
</div>
<div class="col-md-3 payout leftborder rightborder">
<div class="inside">
<div class="komisi tarmob">
Order Value
<div class="order_id"> IDR <?php
echo idr($orders->order_value);
?>
</div>
</div>
</div>
</div>
<div class="col-md-4 ">
<div class="inside tarmob">
<small>Status</small>
<div class="money big"><?php
echo $arrPaymentStatus[$orders->order_status][1];
?>
</div>
<?php
if ($orders->order_status == "1" || $orders->order_status == "2") {
?>
<a href="<?php
echo _SPPATH;
?>
PaymentWeb/receipt?order_id=<?php
echo $orders->order_id;
?>
">receipt</a>
<?php
}
?>
<?php
if ($orders->order_status != "1" && $orders->order_status != "2" && $orders->order_status != "4") {
if ($app->app_active == 0) {
?>
<a href="<?php
echo _SPPATH;
?>
PaymentWeb/pay?app_id=<?php
echo $app->app_id;
?>
">pay again using different method</a>
<?php
}
}
?>
</div>
</div>
<div class="clearfix"></div>
</div>
<?php
}
?>
<div class="clearfix"></div>
<?php
} else {
?>
<h1>No orders has been made yet</h1>
<?php
}
?>
</div>
</div>
<?php
}
function testDate()
{
$date = new DateTime();
$date->setDate(2016, 31, 1);
$ymd = $date->format('Y-m-d');
$ymd = "2016-01-31";
$prev_mon = date('Y-m-d', strtotime($ymd . " +1 month"));
$prev_year = date('Y-m-d', strtotime($ymd . " +4 months"));
echo " " . $prev_mon . " " . $prev_year;
$curMonth = 7;
$curYear = 2016;
if ($curMonth == 12) {
$firstDayNextMonth = mktime(0, 0, 0, 0, 0, $curYear + 1);
} else {
$firstDayNextMonth = mktime(0, 0, 0, $curMonth + 1, 1);
}
pr(date("Y-m-d", $firstDayNextMonth));
pr(getFirstDayOfNextMonth($curMonth, $curYear));
pr(getFirstDayOfNext4Month($curMonth, $curYear));
$app = new AppAccount();
$app->getByID(19);
$vpt = new VpTransaction();
$vpt->getByID("14720056041915");
$vpt->order_id = 1122;
// KomisiModel::log($app,$vpt);
$nn = new AppFree();
$nn->printColumlistAsAttributes();
}
function revenue()
{
$vp = new VpTransaction();
global $db;
$q = "SELECT SUM(order_value) as total FROM {$vp->table_name} WHERE order_status = '1' OR order_status = '2'";
$arrRev = $db->query($q, 1);
$mon = isset($_GET['mon']) ? addslashes($_GET['mon']) : date("n");
// pr($arrRev);
?>
<h1>Total Revenue</h1>
<h1>IDR <?php
echo idr($arrRev->total);
?>
</h1>
Month : <select id="mon_m">
<?php
for ($x = 1; $x < 13; $x++) {
?>
<option <?php
if ($mon == $x) {
echo "selected";
}
?>
value="<?php
echo $x;
?>
"><?php
echo $x;
?>
</option>
<?php
}
?>
</select>
<button id="change_m" class="btn btn-default">Change Month</button>
<script>
$('#change_m').click(function(){
openLw("Revenue",'<?php
echo _SPPATH;
?>
FinanceBE/revenue?mon='+$('#mon_m').val(),'fade');
});
</script>
<?php
$q = "select SUM(order_value) as total from {$vp->table_name} where month(order_date) = " . $mon . " AND (order_status = '1' OR order_status = '2')";
$arrRev = $db->query($q, 1);
?>
<hr>
<h2>Revenue This Month</h2>
<h2>IDR <?php
echo idr($arrRev->total);
?>
</h2>
<?php
$arrs = $vp->getWhere("month(order_date) = " . $mon . " AND (order_status = '1' OR order_status = '2')");
// pr($arrs);
?>
<div class="table-responsive">
<table class="table">
<thead>
<tr>
<th>order_id</th>
<th>order_app_id</th>
<th>order_acc_id</th>
<th>order_date</th>
<th>order_value</th>
<th>order_paket_id</th>
<th>order_status</th>
<th>order_message</th>
<th>order_status_from</th>
</tr>
</thead>
<tbody>
<?php
foreach ($arrs as $vp) {
?>
<tr>
<td><?php
echo $vp->order_id;
?>
</td>
<td><?php
echo $vp->order_app_id;
?>
</td>
<td><?php
echo $vp->order_acc_id;
?>
</td>
<td><?php
echo $vp->order_date;
?>
</td>
<td><?php
echo $vp->order_value;
?>
</td>
<td><?php
echo $vp->order_paket_id;
?>
</td>
<td><?php
echo $vp->order_status;
?>
</td>
<td><?php
echo $vp->order_message;
?>
</td>
<td><?php
echo $vp->order_status_from;
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
}
function error()
{
$order_id = addslashes($_GET['order_id']);
$status_code = addslashes($_GET['status_code']);
$transaction_status = addslashes($_GET['transaction_status']);
$vpt = new VpTransaction();
$vpt->getByID($order_id);
$app = new AppAccount();
$app->getByID($vpt->order_app_id);
AppAccount::checkOwnership($app);
$vpt->order_status_from = $status_code;
$vpt->save();
?>
<div class="container attop" >
<div class="col-md-8 col-md-offset-2">
<div style="text-align: center; padding: 20px;">
<a href="<?php
echo _SPPATH;
?>
">
<img src="<?php
echo _SPPATH;
?>
images/appear-icontext.png" style="max-width: 300px;">
</a>
</div>
<?php
?>
<h1>Error</h1>
<p>Your Payment Error</p>
<p>
Please <a href="<?php
echo _SPPATH;
?>
contact">contact us</a> for more details.
</p>
<a class="btn btn-default" href="<?php
echo _SPPATH;
?>
myApps">back to my Apps</a>
<?php
?>
</div>
</div>
<?php
/*
* Array
(
[url] => vp/error
[order_id] => 70872981
[status_code] => 202
[transaction_status] => deny
)
*/
}
