function actionfree()
{
$id = addslashes($_POST['app_id']);
$action = addslashes($_POST['action']);
$app = new AppAccount();
$app->getByID($id);
$acc = new Account();
$acc->getByID($app->app_client_id);
$agent = new Account();
if ($acc->admin_marketer != "") {
$agent->getByUsername($acc->admin_marketer);
}
$dataemail = new DataEmail();
$json['bool'] = 0;
if ($action == "accept") {
//status = 1 tetap
$app->app_type = 0;
//type = 0
//contract start n end
$app->app_contract_start = date("Y-m-d");
$app->app_contract_end = date('Y-m-d', strtotime(date("Y-m-d", mktime()) . " + 365 day"));
$app->app_paket_id = 1;
//free
$succ = $app->save();
//spy masuk ke job queue
//email ke marcel
//komisi untuk agent nya...
if ($succ) {
//notify Admins kalau ada app active
$dataemail->appBisaDibuat($app->app_name, $app->app_id, "Free App Accepted");
//notify User
$dataemail->freeAppAccepted($acc->admin_email, $acc->admin_username, $app->app_name);
$vpt = new VpTransaction();
$vpt->order_id = time();
//hitung komisi
//ini belum bener
//TODO 31 maret 2016
KomisiModel::log($app, $vpt);
$json['bool'] = $succ;
}
}
if ($action == "reject") {
//status = 0
$app->app_active = 0;
//type = 0
$app->app_type = 0;
$app->app_paket_id = 0;
$succ = $app->save();
//email ke client & agent
if ($succ) {
$dataemail->freeRequestRejected($acc->admin_email, $acc->admin_username, $app->app_name);
if ($acc->admin_marketer != "") {
$dataemail->freeRequestRejectedAgent($agent->admin_email, $acc->admin_username, $app->app_name, $agent->admin_username);
}
$json['bool'] = $succ;
}
}
echo json_encode($json);
die;
}
function testvp()
{
$str = 'O:22:"Veritrans_Notification":1:{s:8:"response";O:8:"stdClass":14:{s:11:"status_code";s:3:"200";s:14:"status_message";s:26:"Success, transaction found";s:14:"transaction_id";s:36:"a293ec21-9572-4333-9a41-640a6789b713";s:11:"masked_card";s:11:"518323-9790";s:8:"order_id";s:10:"1084599542";s:12:"gross_amount";s:8:"10000.00";s:12:"payment_type";s:11:"credit_card";s:16:"transaction_time";s:19:"2016-02-17 15:20:37";s:18:"transaction_status";s:10:"settlement";s:12:"fraud_status";s:6:"accept";s:13:"approval_code";s:6:"T08489";s:13:"signature_key";s:128:"12a2c1d52cdd03326727b1ee0cc8a9f658146dbaedac46490f269183291885772e5a31a121c94ebde9f501733c8e7802cf74c3bb839ad687188456c3bf0d45e0";s:4:"bank";s:3:"bni";s:3:"eci";s:2:"02";}} ||| {"status_code":"200","status_message":"Veritrans payment notification","transaction_id":"a293ec21-9572-4333-9a41-640a6789b713","masked_card":"518323-9790","order_id":"1084599542","gross_amount":"10000.00","payment_type":"credit_card","transaction_time":"2016-02-17 15:20:37","transaction_status":"settlement","fraud_status":"accept","approval_code":"T08489","signature_key":"12a2c1d52cdd03326727b1ee0cc8a9f658146dbaedac46490f269183291885772e5a31a121c94ebde9f501733c8e7802cf74c3bb839ad687188456c3bf0d45e0","bank":"bni","eci":"02"}';
$exp = explode(" ||| ", $str);
$obj = unserialize($exp[0]);
pr($obj);
pr($exp[1]);
$vp = new VpData();
$vp->printColumlistAsAttributes();
$tt = new VpTransaction();
$tt->printColumlistAsAttributes();
$km = new KomisiModel();
$km->printColumlistAsAttributes();
$bk = new BonusKomisi();
BonusKomisi::fillBK();
$bg = new EmailLog();
$bg->printColumlistAsAttributes();
}
public static function getMyDashboard()
{
$acc = Account::getAccountObject();
$myid = Account::getMyID();
$kom = new KomisiModel();
global $db;
// $q = "SELECT SUM(komisi_value) FROM {$kom->table_name}"
$arrKom = $kom->getWhere("komisi_acc_id = '{$myid}' ORDER BY komisi_app_date ASC");
$paid = 0;
$unpaid = 0;
$total = 0;
$free = 0;
$android = 0;
$androidios = 0;
$totalpaketbayar = 0;
$totalpaket = 0;
foreach ($arrKom as $kom) {
if ($kom->komisi_status == 1) {
$paid += $kom->komisi_value;
} else {
$unpaid += $kom->komisi_value;
}
$total += $kom->komisi_value;
if ($kom->komisi_paket_id == 1) {
//free
$free++;
}
if ($kom->komisi_paket_id == 2) {
//free
$android++;
$totalpaketbayar++;
}
if ($kom->komisi_paket_id == 3) {
//free
$androidios++;
$totalpaketbayar++;
}
$totalpaket++;
}
//get applied banner
$bm = new BannerModel();
$arrBm = $bm->getWhere("banner_interval_begin <= {$totalpaketbayar} AND banner_interval_end >= {$totalpaketbayar} AND banner_active = 1");
// pr($arrBm);
if (count($arrBm) > 0) {
$selBanner = $arrBm[0];
}
//get applied level
$lv = new LevelModel();
$arrLvl = $lv->getWhere("level_start<={$totalpaketbayar} AND level_end>={$totalpaketbayar} AND level_active = 1");
if (count($arrLvl) > 0) {
$selLvl = $arrLvl[0];
}
?>
<style>
@media (max-width: 768px) {
.monly {
display: initial;
}
.donly {
display: none;
}
.col-lg-1, .col-lg-10, .col-lg-11, .col-lg-12, .col-lg-2, .col-lg-3, .col-lg-4, .col-lg-5, .col-lg-6, .col-lg-7, .col-lg-8, .col-lg-9, .col-md-1, .col-md-10, .col-md-11, .col-md-12, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-sm-1, .col-sm-10, .col-sm-11, .col-sm-12, .col-sm-2, .col-sm-3, .col-sm-4, .col-sm-5, .col-sm-6, .col-sm-7, .col-sm-8, .col-sm-9, .col-xs-1, .col-xs-10, .col-xs-11, .col-xs-12, .col-xs-2, .col-xs-3, .col-xs-4, .col-xs-5, .col-xs-6, .col-xs-7, .col-xs-8, .col-xs-9 {
padding-left: 0px;
padding-right: 0px;
}
.container {
padding-right: 0px;
padding-left: 0px;
}
.attop{
/*padding-top: 50px;*/
}
}
@media (min-width: 768px) {
.monly {
display: none;
}
.donly {
display: initial;
}
#attratas{
margin-top: 30px;
}
#agentbanner{
padding-right: 0px;
}
.stats{
/*min-height: 250px;*/
}
.stats_text{
/*padding-top: 30px;*/
}
.stats_number_big{
/*font-size: 40px;*/
}
.stats_money{
font-weight: bold;
/*font-size: 30px;*/
}
.col-lg-1, .col-lg-10, .col-lg-11, .col-lg-12, .col-lg-2, .col-lg-3, .col-lg-4, .col-lg-5, .col-lg-6, .col-lg-7, .col-lg-8, .col-lg-9, .col-md-1, .col-md-10, .col-md-11, .col-md-12, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-sm-1, .col-sm-10, .col-sm-11, .col-sm-12, .col-sm-2, .col-sm-3, .col-sm-4, .col-sm-5, .col-sm-6, .col-sm-7, .col-sm-8, .col-sm-9, .col-xs-1, .col-xs-10, .col-xs-11, .col-xs-12, .col-xs-2, .col-xs-3, .col-xs-4, .col-xs-5, .col-xs-6, .col-xs-7, .col-xs-8, .col-xs-9 {
padding-left: 0px;
padding-right: 0px;
}
}
</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-dashboard.png" >
</a>
</div>
<div id="attratas">
<button onclick="document.location='<?php
echo _SPPATH;
?>
invite';" class="btn btn-success btn-abu" style="margin: 0px; ">Invite</button>
<button onclick="document.location='<?php
echo _SPPATH;
?>
mysales';" class="btn btn-success btn-abu" style="margin: 0px; ">Sales</button>
<button onclick="document.location='<?php
echo _SPPATH;
?>
myapps';" class="btn btn-success btn-abu" style="margin: 0px;">Apps</button>
</div>
<div class="clearfix"></div>
<div class="col-md-12" >
<?php
//halo
$sales = AppearSales::calculatePaidSalesCount(Account::getMyID(), date('n'), date('Y'));
// pr($sales);
$lastmon = getFirstDayOfLastMonth(date('n'), date('Y'), "n");
$lastyear = getFirstDayOfLastMonth(date('n'), date('Y'), "Y");
$lastmonsales = AppearSales::calculatePaidSalesCount(Account::getMyID(), $lastmon, $lastyear);
//revenue
$rev = AppearSales::calculateRevenueCount(Account::getMyID());
$target = AppearSales::calculateTarget(0);
?>
<div class="col-md-2 col-sm-6 col-xs-6 stats">
<div class="stats_text"><i class="glyphicon glyphicon-signal"></i> last month</div>
<div class="stats_number_big green"><?php
echo $lastmonsales->nr;
?>
</div>
<div class="stats_money">IDR <?php
echo idr($lastmonsales->total);
?>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-6 stats">
<div class="stats_text"><i class="glyphicon glyphicon-stats"></i> this month</div>
<div class="stats_number_big green"><?php
echo $sales->nr;
?>
</div>
<div class="stats_money">IDR <?php
echo idr($sales->total);
?>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-6 stats">
<div class="stats_text"><i class="glyphicon glyphicon-fire"></i> target</div>
<div class="stats_number_big green">+<?php
echo $target['nr'];
?>
</div>
<div class="stats_money">+IDR <?php
echo idr($target['total']);
?>
</div>
</div>
<?php
// pr($rev);
?>
<div class="col-md-2 col-sm-6 col-xs-6 stats">
<div class="stats_text"><i class="glyphicon glyphicon-scale"></i> revenue</div>
<div class="stats_number_big green"><?php
echo $rev->nr;
?>
</div>
<div class="stats_money">IDR <?php
echo idr($rev->total);
?>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-6 stats">
<div class="stats_text"><i class="glyphicon glyphicon-tag"></i> free</div>
<div class="stats_number_big green">7</div>
<div class="stats_money">9</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-6 stats">
<?php
if (count($arrLvl) > 0) {
?>
<div class="level_image"><img height="91px" src="<?php
echo _SPPATH . _PHOTOURL . $selLvl->level_img;
?>
"></div>
<div class="stats_money"><?php
echo $selLvl->level_name;
?>
</div>
<?php
}
?>
</div>
</div>
<div class="clearfix"></div>
<?php
if (count($arrBm) > 0) {
?>
<div class="col-md-4 col-sm-12 col-xs-12" >
<!-- <div style="background-color:#dedede; text-align:center; line-height: 30px; cursor: pointer; position: absolute; width: 30px; height: 30px;" onclick="$('#agentbanner').hide();">x</div>-->
<a href="<?php
echo $selBanner->banner_link_url;
?>
">
<img src="<?php
echo _SPPATH . _PHOTOURL . $selBanner->banner_img;
?>
" width="100%">
</a>
</div>
<div class="col-md-4" style="padding-left: 0px; padding-right: 0px;" >
<!-- <div style="background-color:#dedede; text-align:center; line-height: 30px; cursor: pointer; position: absolute; width: 30px; height: 30px;" onclick="$('#agentbanner').hide();">x</div>-->
<a href="<?php
echo $selBanner->banner_link_url;
?>
">
<img src="<?php
echo _SPPATH . _PHOTOURL . $selBanner->banner_img;
?>
" width="100%">
</a>
</div>
<div class="col-md-4" >
<!-- <div style="background-color:#dedede; text-align:center; line-height: 30px; cursor: pointer; position: absolute; width: 30px; height: 30px;" onclick="$('#agentbanner').hide();">x</div>-->
<a href="<?php
echo $selBanner->banner_link_url;
?>
">
<img src="<?php
echo _SPPATH . _PHOTOURL . $selBanner->banner_img;
?>
" width="100%">
</a>
</div>
<?php
}
?>
<?php
if ($acc->admin_isAgent < 1) {
?>
<div class="total_commision">
<a href="<?php
echo _SPPATH;
?>
become_agent">Please complete Agent registration, to start earning your share.</a>
</div>
<?php
}
?>
<div class="clearfix" style="margin-bottom: 100px;"></div>
</div>
</div>
<?php
}
function comissioning()
{
$komisiModel = new KomisiModel();
global $db;
$q = "SELECT SUM(komisi_sisa) as total FROM {$komisiModel->table_name} WHERE komisi_status != 4";
$arrRev = $db->query($q, 1);
$mon = isset($_GET['mon']) ? addslashes($_GET['mon']) : date("n");
$y = isset($_GET['y']) ? addslashes($_GET['y']) : date("Y");
?>
<h1>Comissioning</h1>
<h1>Total Due Commision IDR <?php
echo idr($arrRev->total);
?>
</h1>
Month : <select id="mon">
<?php
for ($x = 1; $x < 13; $x++) {
?>
<option <?php
if ($mon == $x) {
echo "selected";
}
?>
value="<?php
echo $x;
?>
"><?php
echo $x;
?>
</option>
<?php
}
?>
</select>
Year : <select id="year">
<?php
for ($x = 2016; $x < 2030; $x++) {
?>
<option <?php
if ($y == $x) {
echo "selected";
}
?>
value="<?php
echo $x;
?>
"><?php
echo $x;
?>
</option>
<?php
}
?>
</select>
<button id="change" class="btn btn-default">Change Month</button>
<script>
$('#change').click(function(){
openLw("Comissioning",'<?php
echo _SPPATH;
?>
FinanceBE/comissioning?mon='+$('#mon').val()+'&y='+$('#year').val(),'fade');
});
</script>
<?php
// echo "<br>".$_POST['mon']."<br>";
$date = new DateTime();
$date->setDate($y, $mon, 1);
$ymd = $date->format('Y-m-d');
$thismon = $mon;
$prev_mon = date('n', strtotime($ymd . " -3 months"));
$prev_year = date('Y', strtotime($ymd . " -3 months"));
echo "<br>" . $thismon . " " . $y;
echo "<br>" . $prev_mon . " {$prev_year}<br>";
$syarat_paid = "(komisi_status = 0 AND komisi_paket_id != 1 AND month(komisi_app_date) = {$thismon} AND year(komisi_app_date) = {$y})";
$syarat_free = "(komisi_status = 0 AND komisi_paket_id = 1 AND month(komisi_app_date) = {$thismon} AND year(komisi_app_date) = {$y} AND komisi_ting_tong = 1)";
$syarat_half_paid = "(komisi_status = 2 AND komisi_paket_id != 1 AND month(komisi_app_date) = {$prev_mon} AND year(komisi_app_date) = {$prev_year})";
$syarat_half_free = "(komisi_status = 2 AND komisi_paket_id = 1 AND komisi_ting_tong = 1 AND month(komisi_app_date) = {$prev_mon} AND year(komisi_app_date) = {$prev_year})";
//syarat
$dateAwal = $ymd;
$date2nd = date('Y-m-d', strtotime($ymd . " -3 months"));
$syarat_piu_paid = "(komisi_status = 0 AND komisi_paket_id != 1 AND komisi_app_date < '{$ymd}' AND komisi_app_date >= '{$date2nd}')";
$syarat_piu_free = "(komisi_status = 0 AND komisi_paket_id = 1 AND komisi_ting_tong = 1 AND komisi_app_date < '{$ymd}' AND komisi_app_date >= '{$date2nd}')";
$syarat_piu_half_paid = "(komisi_status = 0 AND komisi_paket_id != 1 AND komisi_app_date < '{$date2nd}')";
$syarat_piu_half_free = "(komisi_status = 0 AND komisi_paket_id = 1 AND komisi_ting_tong = 1 AND komisi_app_date < '{$date2nd}')";
// echo $syarat_paid."<br> OR ".$syarat_free."<br> OR ".$syarat_half;
// $arrKom = $komisiModel->getWhere($syarat_paid." OR ".$syarat_free." OR ".$syarat_half_paid." ORDER BY komisi_app_date ASC");
// echo "komisi_status = '0' AND komisi_paket_id != 1 AND (day(komisi_app_date)>24 AND month(komisi_app_date) = $prev) OR (day(komisi_app_date)<25 AND month(komisi_app_date) = $thismon)";
// pr($arrKom);
echo "batesan piutang " . $dateAwal . " " . $date2nd;
echo "<br>" . $syarat_piu_paid;
$arrKomFirstPaid = $komisiModel->getWhere($syarat_paid . " ORDER BY komisi_app_date ASC");
$arrKomFirstFree = $komisiModel->getWhere($syarat_free . " ORDER BY komisi_app_date ASC");
$arrKomSecondPaid = $komisiModel->getWhere($syarat_half_paid . " ORDER BY komisi_app_date ASC");
$arrKomSecondFree = $komisiModel->getWhere($syarat_half_free . " ORDER BY komisi_app_date ASC");
$arrPiuFirstPaid = $komisiModel->getWhere($syarat_piu_paid . " ORDER BY komisi_app_date ASC");
$arrPiuFirstFree = $komisiModel->getWhere($syarat_piu_free . " ORDER BY komisi_app_date ASC");
$arrPiuSecondPaid = $komisiModel->getWhere($syarat_piu_half_paid . " ORDER BY komisi_app_date ASC");
$arrPiuSecondFree = $komisiModel->getWhere($syarat_piu_half_free . " ORDER BY komisi_app_date ASC");
?>
<h3>Payment For <?php
echo $thismon;
?>
</h3>
<div class="table-responsive">
<table class="table table-bordered table-striped">
<thead>
<tr>
<th>Komisi ID</th>
<th>Komisi Date</th>
<th>Komisi Paket</th>
<th>Komisi Status</th>
<th>Komisi Agent Ready</th>
<th>Komisi Value</th>
</tr>
</thead>
<tbody>
<tr>
<td colspan="6">
<h1>First Paid</h1>
</td>
</tr>
<?php
$total = 0;
$totalkaliini = 0;
foreach ($arrKomFirstPaid as $kom) {
?>
<tr>
<td><?php
echo $kom->komisi_id;
?>
</td>
<td><?php
echo $kom->komisi_app_date;
?>
</td>
<td><?php
echo $kom->komisi_paket_id;
?>
</td>
<td><?php
echo $kom->komisi_status;
?>
</td>
<td><?php
$acc = new Account();
$acc->getByID($kom->komisi_acc_id);
echo $acc->admin_id . " " . $acc->admin_nama_depan;
if ($acc->admin_isAgent) {
echo " <b>agent ready</b>";
$total += $kom->komisi_bagi_pertama_value;
$totalkaliini += $kom->komisi_value;
} else {
echo " <i>not ready</i>";
}
?>
</td>
<td><?php
echo idr($kom->komisi_bagi_pertama_value);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">
<?php
echo $totalkaliini . " " . $total;
?>
<h1>First Free</h1>
</td>
</tr>
<?php
foreach ($arrKomFirstFree as $kom) {
?>
<tr>
<td><?php
echo $kom->komisi_id;
?>
</td>
<td><?php
echo $kom->komisi_app_date;
?>
</td>
<td><?php
echo $kom->komisi_paket_id;
?>
</td>
<td><?php
echo $kom->komisi_status;
?>
</td>
<td><?php
$acc = new Account();
$acc->getByID($kom->komisi_acc_id);
echo $acc->admin_id . " " . $acc->admin_nama_depan;
if ($acc->admin_isAgent) {
echo " <b>agent ready</b>";
$total += $kom->komisi_bagi_pertama_value;
$totalkaliini += $kom->komisi_value;
} else {
echo " <i>not ready</i>";
}
?>
</td>
<td><?php
echo idr($kom->komisi_bagi_pertama_value);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">
<h1>Second Paid</h1>
</td>
</tr>
<?php
foreach ($arrKomSecondPaid as $kom) {
?>
<tr>
<td><?php
echo $kom->komisi_id;
?>
</td>
<td><?php
echo $kom->komisi_app_date;
?>
</td>
<td><?php
echo $kom->komisi_paket_id;
?>
</td>
<td><?php
echo $kom->komisi_status;
?>
</td>
<td><?php
$acc = new Account();
$acc->getByID($kom->komisi_acc_id);
echo $acc->admin_id . " " . $acc->admin_nama_depan;
if ($acc->admin_isAgent) {
echo " <b>agent ready</b>";
$total += $kom->komisi_bagi_kedua_value;
$totalkaliini += $kom->komisi_value;
} else {
echo " <i>not ready</i>";
}
?>
</td>
<td><?php
echo idr($kom->komisi_bagi_kedua_value);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">
<h1>Second Free</h1>
</td>
</tr>
<?php
foreach ($arrKomSecondFree as $kom) {
?>
<tr>
<td><?php
echo $kom->komisi_id;
?>
</td>
<td><?php
echo $kom->komisi_app_date;
?>
</td>
<td><?php
echo $kom->komisi_paket_id;
?>
</td>
<td><?php
echo $kom->komisi_status;
?>
</td>
<td><?php
$acc = new Account();
$acc->getByID($kom->komisi_acc_id);
echo $acc->admin_id . " " . $acc->admin_nama_depan;
if ($acc->admin_isAgent) {
echo " <b>agent ready</b>";
$total += $kom->komisi_bagi_kedua_value;
$totalkaliini += $kom->komisi_value;
} else {
echo " <i>not ready</i>";
}
?>
</td>
<td><?php
echo idr($kom->komisi_bagi_kedua_value);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">
<h1>Piutang Paid </h1>
</td>
</tr>
<?php
foreach ($arrPiuFirstPaid as $kom) {
?>
<tr>
<td><?php
echo $kom->komisi_id;
?>
</td>
<td><?php
echo $kom->komisi_app_date;
?>
</td>
<td><?php
echo $kom->komisi_paket_id;
?>
</td>
<td><?php
echo $kom->komisi_status;
?>
</td>
<td><?php
$acc = new Account();
$acc->getByID($kom->komisi_acc_id);
echo $acc->admin_id . " " . $acc->admin_nama_depan;
if ($acc->admin_isAgent) {
echo " <b>agent ready</b>";
$total += $kom->komisi_bagi_pertama_value;
$totalkaliini += $kom->komisi_value;
} else {
echo " <i>not ready</i>";
}
?>
</td>
<td><?php
echo idr($kom->komisi_bagi_pertama_value);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">
<h1>Piutang Free </h1>
</td>
</tr>
<?php
foreach ($arrPiuFirstFree as $kom) {
?>
<tr>
<td><?php
echo $kom->komisi_id;
?>
</td>
<td><?php
echo $kom->komisi_app_date;
?>
</td>
<td><?php
echo $kom->komisi_paket_id;
?>
</td>
<td><?php
echo $kom->komisi_status;
?>
</td>
<td><?php
$acc = new Account();
$acc->getByID($kom->komisi_acc_id);
echo $acc->admin_id . " " . $acc->admin_nama_depan;
if ($acc->admin_isAgent) {
echo " <b>agent ready</b>";
$total += $kom->komisi_bagi_pertama_value;
$totalkaliini += $kom->komisi_value;
} else {
echo " <i>not ready</i>";
}
?>
</td>
<td><?php
echo idr($kom->komisi_bagi_pertama_value);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">
<h1>Piu Second Paid</h1>
</td>
</tr>
<?php
foreach ($arrPiuSecondPaid as $kom) {
?>
<tr>
<td><?php
echo $kom->komisi_id;
?>
</td>
<td><?php
echo $kom->komisi_app_date;
?>
</td>
<td><?php
echo $kom->komisi_paket_id;
?>
</td>
<td><?php
echo $kom->komisi_status;
?>
</td>
<td><?php
$acc = new Account();
$acc->getByID($kom->komisi_acc_id);
echo $acc->admin_id . " " . $acc->admin_nama_depan;
if ($acc->admin_isAgent) {
echo " <b>agent ready</b>";
$total += $kom->komisi_bagi_kedua_value;
$totalkaliini += $kom->komisi_value;
} else {
echo " <i>not ready</i>";
}
?>
</td>
<td><?php
echo idr($kom->komisi_value);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">
<h1>Piu Second Free</h1>
</td>
</tr>
<?php
foreach ($arrPiuSecondFree as $kom) {
?>
<tr>
<td><?php
echo $kom->komisi_id;
?>
</td>
<td><?php
echo $kom->komisi_app_date;
?>
</td>
<td><?php
echo $kom->komisi_paket_id;
?>
</td>
<td><?php
echo $kom->komisi_status;
?>
</td>
<td><?php
$acc = new Account();
$acc->getByID($kom->komisi_acc_id);
echo $acc->admin_id . " " . $acc->admin_nama_depan;
if ($acc->admin_isAgent) {
echo " <b>agent ready</b>";
$total += $kom->komisi_bagi_kedua_value;
$totalkaliini += $kom->komisi_value;
} else {
echo " <i>not ready</i>";
}
?>
</td>
<td><?php
echo idr($kom->komisi_value);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<h1>Total Kali ini nya : IDR <?php
echo idr($total);
?>
</h1>
<h1>Total Semuanya : IDR <?php
echo idr($totalkaliini);
?>
</h1>
Eh masih hrs ditambah yang payment kedua..oh iya trus totalnya hrs dipotong 500rb ...
Apa tanggal bisa dijadikan 1-31 dan paymentnya mundur ke tgl 10 ?
<button class="btn btn-primary">Create this month Commisions Request</button>
<?php
}
static function checkTingTong($app, $agent, $kom_id, $paket, $acc, $mode = "free")
{
$km = new KomisiModel();
if ($mode == "free") {
//cari yang paid
$arrKom = $km->getWhere("komisi_acc_id = '{$agent->admin_id}' AND (komisi_paket_id = 2 OR komisi_paket_id = 3) AND komisi_ting_tong = 0 ORDER BY komisi_app_date ASC LIMIT 0,1");
} else {
$arrKom = $km->getWhere("komisi_acc_id = '{$agent->admin_id}' AND (komisi_paket_id = 1) AND komisi_ting_tong = 0 ORDER BY komisi_app_date ASC LIMIT 0,1");
}
if (count($arrKom) > 0) {
//ada yang paid bisa ditingtong
$km = $arrKom[0];
$km->komisi_ting_tong = 1;
//tingtong
$km->komisi_tingtong_date = leap_mysqldate();
$km->save();
$pay1_date = getFirstDayOfNextMonth(date("n", strtotime($km->komisi_tingtong_date)), date("Y", strtotime($km->komisi_tingtong_date)));
$pay2_date = getFirstDayOfNext4Month(date("n", strtotime($km->komisi_tingtong_date)), date("Y", strtotime($km->komisi_tingtong_date)));
if ($km->komisi_paket_id == "1") {
$km->komisi_bagi_pertama_date = $pay1_date;
$km->komisi_bagi_kedua_date = $pay2_date;
$km->save();
}
$kmsatunya = new KomisiModel();
$kmsatunya->getByID($kom_id);
$kmsatunya->komisi_ting_tong = 1;
$kmsatunya->komisi_tingtong_date = leap_mysqldate();
$kmsatunya->save();
if ($kmsatunya->komisi_paket_id == "1") {
$kmsatunya->komisi_bagi_pertama_date = $pay1_date;
$kmsatunya->komisi_bagi_kedua_date = $pay2_date;
$kmsatunya->save();
}
//send email
//email dpt komisi
$dpt = new DataEmail();
$dpt->dapatKomisiTingTong($agent->admin_email, $paket->paket_komisi, 0, $acc->admin_nama_depan, $agent->admin_isAgent);
//nanti cari yang free dan sudah tingtong dan belum dibayarkan
//untuk dibayarkan
}
}
public static function calculateTotalSales($agent_id, $mon = "", $year = "")
{
if ($mon == "") {
$text = "";
} else {
$text = "AND month(komisi_app_date) = {$mon} AND year(komisi_app_date) = {$year}";
}
$komisiModel = new KomisiModel();
$arr = $komisiModel->getWhere("komisi_paket_id != 1 AND komisi_acc_id = '{$agent_id}' {$text}");
$pending = array();
$tingtong = array();
$free = array();
$paket = array();
foreach ($arr as $komisiModel) {
//lihat status
if ($komisiModel->komisi_status == "0") {
//blm dibayar
$free["0"][] = Crud::clean2printEinzeln($komisiModel);
}
if ($komisiModel->komisi_status == "1") {
//blm dibayar
$free["1"][] = Crud::clean2printEinzeln($komisiModel);
}
if ($komisiModel->komisi_status == "2") {
//blm dibayar
$free["2"][] = Crud::clean2printEinzeln($komisiModel);
}
if ($komisiModel->komisi_status == "3") {
//blm dibayar
$free["3"][] = Crud::clean2printEinzeln($komisiModel);
}
if ($komisiModel->komisi_status == "4") {
//blm dibayar
$free["4"][] = Crud::clean2printEinzeln($komisiModel);
}
$paket[$komisiModel->komisi_paket_id][] = Crud::clean2printEinzeln($komisiModel);
if ($komisiModel->komisi_ting_tong == "1") {
//sudah tingtong
$tingtong[] = $komisiModel;
} else {
$pending[] = $komisiModel;
}
}
$return['date'] = array("mon" => $mon, "year" => $year);
$return['total_sales'] = count($arr);
$return['status_based'] = $free;
$return['paket_based'] = $paket;
$return["tingtong"] = array("jml" => count($tingtong), "arr" => Crud::clean2print($komisiModel, $tingtong));
$return["no_tingtong"] = array("jml" => count($pending), "arr" => Crud::clean2print($komisiModel, $pending));
return $return;
}
function handling()
{
echo 1;
if ($this->isProd) {
Veritrans_Config::$isProduction = true;
}
echo 3;
Veritrans_Config::$serverKey = $this->getKeyUsed();
echo 4;
$raw_notification = "";
try {
$notif = new Veritrans_Notification();
$input_source = "php://input";
$raw_notification = file_get_contents($input_source);
} catch (Exception $e) {
echo "<h2>" . $e->getMessage() . "</h2>";
}
echo "<h1>jahahaa</h1>";
$transaction = $notif->transaction_status;
$type = $notif->payment_type;
$order_id = $notif->order_id;
$fraud = $notif->fraud_status;
$vpt = new VpTransaction();
$vpt->getByID($order_id);
//dataemail
$dataemail = new DataEmail();
if ($transaction == 'capture') {
// For credit card transaction, we need to check whether transaction is challenge by FDS or not
if ($type == 'credit_card') {
if ($fraud == 'challenge') {
// TODO set payment status in merchant's database to 'Challenge by FDS'
// TODO merchant should decide whether this transaction is authorized or not in MAP
echo "Transaction order_id: " . $order_id . " is challenged by FDS";
$vpt->order_message = "Transaction order_id: " . $order_id . " is challenged by FDS";
$vpt->order_status = 3;
$vpt->save();
//notify User
$app = new AppAccount();
$app->getByID($vpt->order_app_id);
$acc = new Account();
$acc->getByID($app->app_client_id);
$dataemail->appPaymentMode($acc->admin_email, $acc->admin_username, $app->app_name, $fraud);
} else {
// TODO set payment status in merchant's database to 'Success'
echo "Transaction order_id: " . $order_id . " successfully captured using " . $type;
$vpt->order_message = "Transaction order_id: " . $order_id . " successfully captured using " . $type;
$vpt->order_status = 2;
$vpt->save();
//notify User
//update active di app
$app = new AppAccount();
$app->getByID($vpt->order_app_id);
$app->app_contract_start = date("Y-m-d");
$app->app_contract_end = date('Y-m-d', strtotime(date("Y-m-d", mktime()) . " + 365 day"));
$app->app_active = 1;
$app->app_paket_id = $vpt->order_paket_id;
$app->save();
//notify Admins kalau ada app active
$dataemail->appBisaDibuat($app->app_name, $app->app_id, $transaction);
//notify User
$acc = new Account();
$acc->getByID($app->app_client_id);
$dataemail->appPaymentSuccess($acc->admin_email, $acc->admin_username, $app->app_name);
//hitung komisi
//ini belum bener
//TODO 31 maret 2016
KomisiModel::log($app, $vpt);
//email dapat komisi
}
}
} else {
if ($transaction == 'settlement') {
// TODO set payment status in merchant's database to 'Settlement'
echo "Transaction order_id: " . $order_id . " successfully transfered using " . $type;
$oldstatus = $vpt->order_status;
$vpt->order_message = "Transaction order_id: " . $order_id . " successfully transfered using " . $type;
$vpt->order_status = 1;
$vpt->save();
if ($oldstatus != 2) {
//update active di app
$app = new AppAccount();
$app->getByID($vpt->order_app_id);
$app->app_contract_start = date("Y-m-d");
$app->app_contract_end = date('Y-m-d', strtotime(date("Y-m-d", mktime()) . " + 365 day"));
$app->app_active = 1;
$app->app_paket_id = $vpt->order_paket_id;
$app->save();
//notify Admins kalau ada app active
$dataemail->appBisaDibuat($app->app_name, $app->app_id, $transaction);
//notify User
$acc = new Account();
$acc->getByID($app->app_client_id);
$dataemail->appPaymentSettle($acc->admin_email, $acc->admin_username, $app->app_name);
//hitung komisi
//TODO 31 maret 2016
KomisiModel::log($app, $vpt);
//email dpt komisi
}
} else {
if ($transaction == 'pending') {
// TODO set payment status in merchant's database to 'Pending'
echo "Waiting customer to finish transaction order_id: " . $order_id . " using " . $type;
$vpt->order_message = "Waiting customer to finish transaction order_id: " . $order_id . " using " . $type;
$vpt->order_status = 4;
$vpt->save();
//notify User
$app = new AppAccount();
$app->getByID($vpt->order_app_id);
$acc = new Account();
$acc->getByID($app->app_client_id);
$dataemail->appPaymentMode($acc->admin_email, $acc->admin_username, $app->app_name, $transaction);
} else {
if ($transaction == 'deny') {
// TODO set payment status in merchant's database to 'Denied'
echo "Payment using " . $type . " for transaction order_id: " . $order_id . " is denied.";
$vpt->order_message = "Payment using " . $type . " for transaction order_id: " . $order_id . " is denied.";
$vpt->order_status = 5;
$vpt->save();
//notify User
$app = new AppAccount();
$app->getByID($vpt->order_app_id);
$acc = new Account();
$acc->getByID($app->app_client_id);
$dataemail->appPaymentMode($acc->admin_email, $acc->admin_username, $app->app_name, "denied");
} else {
if ($transaction == 'cancel') {
// TODO set payment status in merchant's database to 'Denied'
echo "Payment using " . $type . " for transaction order_id: " . $order_id . " is canceled.";
$vpt->order_message = "Payment using " . $type . " for transaction order_id: " . $order_id . " is canceled.";
$vpt->order_status = 6;
$vpt->save();
//notify User
$app = new AppAccount();
$app->getByID($vpt->order_app_id);
$acc = new Account();
$acc->getByID($app->app_client_id);
$dataemail->appPaymentMode($acc->admin_email, $acc->admin_username, $app->app_name, "canceled");
}
}
}
}
}
$vp = new VpData();
$vp->vp_date = leap_mysqldate();
$vp->vp_obj = serialize($notif) . " ||| " . $raw_notification;
$vp->approval_code = $notif->approval_code;
$vp->order_id = $notif->order_id;
$vp->status_code = $notif->status_code;
$vp->transaction_status = $notif->transaction_status;
$vp->status_message = $notif->status_message;
$vp->transaction_id = $notif->transaction_id;
$vp->masked_card = $notif->masked_card;
$vp->gross_amount = $notif->gross_amount;
$vp->payment_type = $notif->payment_type;
$vp->transaction_time = $notif->transaction_time;
$vp->fraud_status = $notif->fraud_status;
$vp->approval_code = $notif->approval_code;
$vp->signature_key = $notif->signature_key;
$vp->bank = $notif->bank;
$vp->eci = $notif->eci;
$vp->save();
pr($notif);
/*
* Veritrans_Notification Object
(
[response:Veritrans_Notification:private] => stdClass Object
(
[status_code] => 200
[status_message] => Success, transaction found
[transaction_id] => a293ec21-9572-4333-9a41-640a6789b713
[masked_card] => 518323-9790
[order_id] => 1084599542
[gross_amount] => 10000.00
[payment_type] => credit_card
[transaction_time] => 2016-02-17 15:20:37
[transaction_status] => capture
[fraud_status] => accept
[approval_code] => T08489
[signature_key] => 12a2c1d52cdd03326727b1ee0cc8a9f658146dbaedac46490f269183291885772e5a31a121c94ebde9f501733c8e7802cf74c3bb839ad687188456c3bf0d45e0
[bank] => bni
[eci] => 02
)
)
*/
die;
}
public function login()
{
IMBAuth::checkOAuth();
$username = addslashes($_POST['username']);
$password = addslashes($_POST['password']);
//untuk deviceModel
$device_id = addslashes($_POST['device_id']);
$type = addslashes($_POST['type']);
$acc = new Account();
$arr = $acc->getWhere("admin_username = '******' OR admin_email ='{$username}'");
// pr($arr);
if (count($arr) > 0) {
$acc = $arr[0];
if ($password == $acc->admin_password) {
$json['status_code'] = 1;
$json['status_message'] = "Success";
$json_acc['acc_id'] = $acc->admin_id;
$json_acc['username'] = $acc->admin_username;
$json_acc['email'] = $acc->admin_email;
$json_acc['user_token'] = md5($acc->admin_email . $acc->admin_password);
$json['account'] = $json_acc;
//dashboard
$myid = $acc->admin_id;
$kom = new KomisiModel();
$arrKom = $kom->getWhere("komisi_acc_id = '{$myid}' ORDER BY komisi_app_date ASC");
$paid = 0;
$unpaid = 0;
$total = 0;
$free = 0;
$android = 0;
$androidios = 0;
$totalpaketbayar = 0;
$totalpaket = 0;
foreach ($arrKom as $kom) {
if ($kom->komisi_status == 1) {
$paid += $kom->komisi_value;
} else {
$unpaid += $kom->komisi_value;
}
$total += $kom->komisi_value;
if ($kom->komisi_paket_id == 1) {
//free
$free++;
}
if ($kom->komisi_paket_id == 2) {
//free
$android++;
$totalpaketbayar++;
}
if ($kom->komisi_paket_id == 3) {
//free
$androidios++;
$totalpaketbayar++;
}
$totalpaket++;
}
//get applied banner
$bm = new BannerModel();
$arrBm = $bm->getWhere("banner_interval_begin <= {$totalpaketbayar} AND banner_interval_end >= {$totalpaketbayar} AND banner_active = 1");
if (count($arrBm) > 0) {
$selBanner = $arrBm[0];
$json_banner['banner_img'] = _BPATH . _PHOTOURL . $selBanner->banner_img;
$json_banner['banner_link_url'] = $selBanner->banner_link_url;
}
//get applied level
$lv = new LevelModel();
$arrLvl = $lv->getWhere("level_start<={$totalpaketbayar} AND level_end>={$totalpaketbayar} AND level_active = 1");
if (count($arrLvl) > 0) {
$selLvl = $arrLvl[0];
$json_lvl['level_name'] = $selLvl->level_name;
$json_lvl['level_img'] = _BPATH . _PHOTOURL . $selLvl->level_img;
}
$dashboard['sales_total'] = $totalpaket;
$dashboard['sales_paid'] = $totalpaketbayar;
$dashboard['sales_fee'] = $free;
$dashboard['sales_android'] = $android;
$dashboard['sales_androidios'] = $androidios;
$dashboard['money_total'] = $total;
$dashboard['money_paid'] = $paid;
$dashboard['money_unpaid'] = $unpaid;
$dashboard['banner'] = $json_banner;
$dashboard['level'] = $json_lvl;
$json['dashboard'] = $dashboard;
//myapps
$app2acc = new App2Acc();
//AND app_active = 1
$apps = $app2acc->getWhereFromMultipleTable("ac_admin_id = '" . $acc->admin_id . "' AND ac_app_id = app_id ", array("AppAccount"));
if (count($apps) > 0) {
foreach ($apps as $ap) {
$rr = array();
$rr['app_id'] = $ap->app_id;
$rr['app_icon'] = $ap->app_icon;
$rr['app_name'] = $ap->app_name;
$rr['app_active'] = $ap->app_active;
$rr['app_shortdes'] = $ap->app_shortdes;
$rr['app_token'] = $ap->app_token;
$rr['app_contract_end'] = $ap->app_contract_end;
$rr['app_google_play_link'] = $ap->app_google_play_link;
$rr['app_google_version'] = $ap->app_google_version;
$rr['app_ios_link'] = $ap->app_ios_link;
$rr['app_ios_version'] = $ap->app_ios_version;
$paket = new Paket();
$paket->getByID($ap->app_paket_id);
$rr['paket']['paket_id'] = $paket->paket_id;
$rr['paket']['paket_name'] = $paket->paket_name;
$json['apps'][] = $rr;
}
} else {
$json['apps'] = array();
}
//update the device id on deviceModelCaps
$dn = new DeviceModelCapsule();
$dnquery = new DeviceModelCapsule();
// langkah 1 , device ID ada device type ada
$arrs = $dnquery->getWhere("device_id = '{$device_id}' AND device_type = '{$type}'");
$dn = $arrs[0];
if ($dn->did == "") {
$dn = new DeviceModelCapsule();
$dn->device_id = $device_id;
$dn->device_type = $type;
$dn->acc_id = $acc->admin_id;
$dn->firstlogin = leap_mysqldate();
} else {
//kalau device id ada, acc di update
$dn->load = 1;
$dn->acc_id = $acc->admin_id;
}
$dn->dev_lng = addslashes($_POST['lng']);
$dn->dev_lat = addslashes($_POST['lat']);
$dn->logindate = leap_mysqldate();
if ($dn->save()) {
$json['save_device_status'] = 1;
}
$json['powered_by_link'] = Efiwebsetting::getData("Powered_By_Link_Caps");
echo json_encode($json);
die;
} else {
$json['status_code'] = 0;
$json['status_message'] = "Password Mismatched";
echo json_encode($json);
die;
}
} else {
$json['status_code'] = 0;
$json['status_message'] = "User Not Found";
echo json_encode($json);
die;
}
}
