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