function extend()
{
$id = addslashes($_GET['app_id']);
$acc = new App2Acc();
$apps = $acc->getWhereFromMultipleTable("ac_admin_id = '" . Account::getMyID() . "' AND ac_app_id = app_id AND ac_app_id = '{$id}' ", array("AppAccount"));
if (count($apps) < 1) {
die("hacking attempt");
} else {
$app = $apps[0];
}
if ($app->app_active < 1) {
header("Location:" . _SPPATH . "myapps");
die;
}
if ($app->app_paket_id < 2) {
die("Paket bukan paket PAID");
}
$prevPaket = new Paket();
$prevPaket->getByID($app->app_paket_id);
AppAccount::checkOwnership($app);
$paket = new Paket();
$arrPaket = $paket->getWhere("paket_active = 1 AND paket_id > 1 ORDER BY paket_id ASC");
$paket2 = new Paket();
$paket2->getByID(2);
$paket1 = new Paket();
$paket1->getByID(3);
$next = 3;
?>
<div class="container attop" style="text-align: center;" >
<div class="col-md-8 col-md-offset-2">
<div class="appear_logo_pages">
<a href="<?php
echo _SPPATH;
?>
">
<img src="<?php
echo _SPPATH;
?>
images/appear-payment.png" >
</a>
</div>
<div class="app" style="background-color: #dedede;">
<div style="background-color: #cccccc; padding: 5px; text-align: center; font-size: 15px;">
Previous Package : <?php
echo $prevPaket->paket_name;
?>
<br>
Contract End : <?php
echo date("d-m-Y", strtotime($app->app_contract_end));
?>
in <?php
echo dateDifference(date("Y-m-d", strtotime($app->app_contract_end)), date("Y-m-d"));
?>
days
</div>
<div style="background-color: #f6f6f6; padding: 5px; text-align: center; font-size: 20px;">Payment For</div>
<div class="col-md-3 " style="text-align: center; min-height: 270px; padding: 10px; background-color: #FFFFFF;">
<b >App Details</b><br><br>
<img src="<?php
echo $app->app_icon;
?>
" width="80%"><br>
<?php
echo $app->app_name;
?>
</div>
<div class="col-md-9 " style="text-align: center; padding: 10px;background-color: #dedede;">
<div style="padding-bottom: 20px; font-weight: bold;">Package Details</div>
<div class="clearfix"></div>
<?php
if ($app->app_paket_id != 5) {
?>
<div class="col-md-6 col-sm-6 col-xs-6">
<img style="cursor: pointer;" id="paket1" onclick="setPaket(1);" src="<?php
echo _SPPATH;
?>
images/paket-android-ios.png" width="100%">
<small>what you get</small>
</div>
<?php
} else {
$paket1 = new Paket();
$paket1->getByID(5);
$next = 5;
?>
<div class="col-md-6 col-sm-6 col-xs-6">
<img style="cursor: pointer;" id="paket1" onclick="setPaket(1);" src="<?php
echo _SPPATH;
?>
images/paket-android-ios.png" width="100%">
<small>what you get</small>
</div>
<?php
}
?>
<?php
if ($app->app_paket_id == 2) {
?>
<div class="col-md-6 col-sm-6 col-xs-6">
<img style="cursor: pointer;" id="paket2" onclick="setPaket(2);" src="<?php
echo _SPPATH;
?>
images/paket-android-2.png" width="100%">
<small>what you get</small>
</div>
<?php
}
?>
<div class="clearfix"></div>
<script>
var paket_selected = 3;
function setPaket(x){
if(x == 1){
$('#paket2').attr("src","<?php
echo _SPPATH;
?>
images/paket-android-2.png");
$('#paket1').attr("src","<?php
echo _SPPATH;
?>
images/paket-android-ios.png");
$('#paketprice').html("IDR <?php
echo idr($paket1->paket_price);
?>
/ year");
paket_selected = 3;
$('#paybuttonpaket3').show();
$('#paybuttonpaket2').hide();
}else{
$('#paket2').attr("src","<?php
echo _SPPATH;
?>
images/paket-android.png");
$('#paket1').attr("src","<?php
echo _SPPATH;
?>
images/paket-android-ios-2.png");
$('#paketprice').html("IDR <?php
echo idr($paket2->paket_price);
?>
/ year");
paket_selected = 2;
$('#paybuttonpaket2').show();
$('#paybuttonpaket3').hide();
}
}
</script>
</div>
<div class="clearfix"></div>
<div id="paketprice" style="background-color: #f6f6f6; padding: 5px; text-align: center; font-size: 30px;">IDR <?php
echo idr($paket1->paket_price);
?>
/ year</div>
<div style="background-color: #cccccc; padding: 5px; text-align: center; font-size: 15px;">
This will renew the contract until <?php
echo date("d-m-Y", strtotime($app->app_contract_end . " + 1 year"));
?>
</div>
</div>
<div style="padding: 20px;">
<a id="paybuttonpaket3" href="<?php
echo _SPPATH;
?>
Vp/pay?app_id=<?php
echo $app->app_id;
?>
&paket=<?php
echo $next;
?>
" class="btn btn-danger btn-lg">PAY NOW USING VERITRANS</a>
<a id="paybuttonpaket2" style="display: none;" href="<?php
echo _SPPATH;
?>
Vp/pay?app_id=<?php
echo $app->app_id;
?>
&paket=2" class="btn btn-danger btn-lg">PAY NOW USING VERITRANS</a>
<!-- <a href="--><?php
//=_SPPATH;
?>
<!--VeritransPay/pay?app_id=--><?php
//=$app->app_id;
?>
<!--" class="btn btn-danger btn-lg">PAY NOW USING VERITRANS</a>-->
</div>
<hr>
<div style="text-align: center; margin-bottom: 100px;">
<a href="<?php
echo _SPPATH;
?>
myapps">I will finish the payment later. Go back to My Apps.</a>
</div>
<?php
}
function getDateOrDifference($dt1, $dt2 = null, $max_days = -1)
{
static $gmt_offset = 999;
if ($gmt_offset == 999) {
$gmt_offset = (int) get_option('gmt_offset');
}
if ($max_days < 0) {
$max_days = get_theme_option('show_date_after', 30);
}
if ($dt2 == null) {
$dt2 = date('Y-m-d H:i:s');
}
$dt2n = strtotime($dt2) + $gmt_offset * 3600;
$dt1n = strtotime($dt1);
$diff = $dt2n - $dt1n;
$days = floor($diff / (24 * 3600));
if ($days < $max_days) {
return sprintf(__('%s ago', 'themerex'), dateDifference($dt1, $dt2));
} else {
return prepareDateForTranslation(date(get_option('date_format'), $dt1n));
}
}
$diff = mktime(0, 0, $diff_secs, 1, 1, $base_year);
return array("years" => abs(substr(date('Ymd', $d1) - date('Ymd', $d2), 0, -4)), "months_total" => (date("Y", $diff) - $base_year) * 12 + date("n", $diff) - 1, "months" => date("n", $diff) - 1, "days_total" => floor($diff_secs / (3600 * 24)), "days" => date("j", $diff) - 1, "hours_total" => floor($diff_secs / 3600), "hours" => date("G", $diff), "minutes_total" => floor($diff_secs / 60), "minutes" => (int) date("i", $diff), "seconds_total" => $diff_secs, "seconds" => (int) date("s", $diff));
}
$sql = "SELECT `id_visit` , `date` , `crawlt_ip_used` , `crawler_name`,`crawlt_error` \nFROM `crawlt_visits` CV\nINNER JOIN `crawlt_pages` CP ON CP.id_page = CV.crawlt_pages_id_page\nINNER JOIN `crawlt_crawler` CC ON CC.id_crawler = CV.crawlt_crawler_id_crawler\nWHERE CC.id_crawler\nIN (\nSELECT `id_crawler`\nFROM `crawlt_crawler` \nWHERE `crawler_name` LIKE '%google%') \nand CP.url_page = '{$url}' order by `date`\ndesc";
//echo $sql;
$result = $db->query($sql);
$k = 0;
while ($row = $result->fetch_assoc()) {
$crawldata[$k]['id'] = $k;
$crawldata[$k]['id_visit'] = $row['id_visit'];
$crawldata[$k]['date'] = $row['date'];
//compute dateDifference
if ($k == 0) {
$crawldata[$k]['datediff'] = dateDifference(date('Y-m-d h:i:s'), $crawldata[$k]['date']);
} else {
$crawldata[$k]['datediff'] = dateDifference($crawldata[$k - 1]['date'], $crawldata[$k]['date']);
}
$crawldata[$k]['crawlt_ip_used'] = $row['crawlt_ip_used'];
$crawldata[$k]['crawler_name'] = $row['crawler_name'];
$crawldata[$k]['crawlt_error'] = $row['crawlt_error'];
$k++;
}
echo '<table class="collapse"><tr class="header"><td>N°</td><td>Date</td><td>Interval</td><td>Robot</td><td >IP</td><td>Crawl Err</td></tr>';
for ($i = 0; $i < count($crawldata); $i++) {
echo '<tr>';
echo '<td class="data">' . $crawldata[$i]['id'] . '</td>';
echo '<td class="data">' . $crawldata[$i]['date'] . '</td>';
if ($crawldata[$i]['datediff']['days_total'] > 0) {
echo '<td class="data">' . $crawldata[$i]['datediff']['days_total'] . ' j</td>';
} else {
echo '<td class="data">' . $crawldata[$i]['datediff']['hours_total'] . ' h</td>';
function parse_outlookcsv($cal_file)
{
global $errormsg, $tz;
$outlookcsv_data = array();
if (!($fd = @fopen($cal_file, 'r'))) {
$errormsg .= 'Cannot read temporary file: ' . "{$cal_file}\n";
exit;
} else {
# Burn First Row of Headers
$data = fgetcsv($fd, @filesize($cal_file), ',');
while ($data = fgetcsv($fd, @filesize($cal_file))) {
$subject = addslashes($data[0]);
$start = icaldate_to_timestamp(date('Ymd\\THis', strtotime($data[1] . ' ' . $data[2])));
$end = icaldate_to_timestamp(date('Ymd\\THis', strtotime($data[3] . ' ' . $data[4])));
$all_day_event = (int) toBoolean($data[5]);
$remind_on_off = (int) toBoolean($data[6]);
$reminder = icaldate_to_timestamp(date('Ymd\\THis', strtotime($data[7] . ' ' . $data[8])));
$meeting_organizer = $data[9];
$required_attendies = $data[10];
$optional_attendies = $data[11];
$meeting_resources = $data[12];
$billing_information = $data[13];
$categories = addslashes(str_replace(';', ',', $data[14]));
$description = addslashes($data[15]);
$location = addslashes($data[16]);
$mileage = $data[17];
$priority = $data[18];
$class = (int) toBoolean($data[19]);
$sensitivity = $data[20];
$show_time_as = $data[21];
/*
* Start New Section For Outlook CSV
*/
// $tmp_data['RecordID'] = ;
$tmp_data['StartTime'] = $start;
// In seconds since 1970 (Unix Epoch)
$tmp_data['EndTime'] = $end;
// In seconds since 1970 (Unix Epoch)
$tmp_data['Summary'] = $subject;
// Summary of event (string)
$tmp_data['Duration'] = dateDifference($start, $end, 1);
// How long the event lasts (in minutes)
$tmp_data['Description'] = $description;
// Full Description (string)
$tmp_data['Location'] = $location;
// Location (string)
$tmp_data['AllDay'] = $all_day_event;
// 1 = true 0 = false
$tmp_data['Class'] = $class == 1 ? 'R' : 'P';
$tmp_data['Categories'] = get_categories_id_byname($categories);
$tmp_data['AlarmSet'] = $remind_on_off;
// 1 = true 0 = false
$tmp_data['ADate'] = $reminder;
// Date/Time of Alarm
$tmp_data['AAction'] = 'EMAIL';
// The default action
$tmp_data['CalendarType'] = 'VEVENT';
// The default type
$outlookcsv_data[] = $tmp_data;
}
// End while
fclose($fd);
}
return $outlookcsv_data;
}
function getTicketMinitsOffTicket($ticketID, $staffID)
{
$timeMins = 0;
$start_time = "";
$resReplay = "";
$sqlTicket = "SELECT dPostDate \t FROM sptbl_tickets WHERE nTicketId = '" . mysql_real_escape_string($ticketID) . "' ORDER BY nTicketId";
$resTicket = mysql_query($sqlTicket);
if (mysql_num_rows($resTicket) > 0) {
$rowTicket = mysql_fetch_array($resTicket);
$start_time = $rowTicket['dPostDate'];
}
$sqlReplay = "SELECT nReplyId , nTicketId , dDate FROM sptbl_replies REP WHERE REP.nStaffId = '" . mysql_real_escape_string($staffID) . "' AND nTicketId = '" . mysql_real_escape_string($ticketID) . "' ORDER BY nTicketId";
$resReplay = mysql_query($sqlReplay);
if (mysql_num_rows($resReplay) > 0) {
$rowReplay = mysql_fetch_array($resReplay);
$endtime = $rowReplay['dDate'];
$mins = doConvertToMin(dateDifference($start_time, $endtime));
$timeMins += $mins;
while ($rowReplay = mysql_fetch_array($resReplay)) {
$start_time = $endtime;
$endtime = $rowReplay['dDate'];
$mins = doConvertToMin(dateDifference($start_time, $endtime));
$timeMins += $mins;
}
}
// echo '<br>stf: ' .$staffID . ', tic : '.$ticketID.' , min : ' .$timeMins;
return $timeMins;
}
static function getMyApps()
{
$acc = Account::getAccountObject();
?>
<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;*/
}
#session{
margin-left: 15px; margin-right: 15px;
}
}
@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-apps.png" >
</a>
</div>
<div id="attratas">
<button id="list" onclick="$('#list').hide();$('#icons').show();$('#app_icons').hide();$('#app_lists').show();" class="btn btn-success btn-abu" style="margin: 0px;display: none;"><i class="glyphicon glyphicon-th-list"></i></button>
<button id="icons" onclick="$('#list').show();$('#icons').hide();$('#app_icons').show();$('#app_lists').hide();" class="btn btn-success btn-abu" style="margin: 0px;"><i class="glyphicon glyphicon-th"></i></button>
<button onclick="document.location='<?php
echo _SPPATH;
?>
mydashboard';" class="btn btn-success btn-abu" style="margin: 0px;">Dashboard</button>
<button onclick="document.location='<?php
echo _SPPATH;
?>
apps/makenew';" class="btn btn-success btn-abu" style="margin: 0px;">Create New Apps</button>
</div>
<?php
if (ZAppFeature::checkRemainingSession()) {
$link = _SPPATH . "apps/make";
if ($_SESSION['ZAppFeature']['app_id'] > 0) {
$link = _SPPATH . "apps/make?id=" . $_SESSION['ZAppFeature']['app_id'];
}
?>
<div id="session" class="alert alert-warning" role="alert" >
You have unsaved edit Sessions. Click <a href="<?php
echo $link;
?>
">here</a> to continue work on your app
</div>
<?php
}
?>
<?php
if (in_array("master_admin", Account::getMyRoles())) {
$acc = new AppAccount();
$apps = $acc->getAll();
//http://localhost:8888/appear/PushHome/home?st=Balance
} else {
$acc = new App2Acc();
//AND app_active = 1
$apps = $acc->getWhereFromMultipleTable("ac_admin_id = '" . Account::getMyID() . "' AND ac_app_id = app_id ", array("AppAccount"));
}
if (count($apps) > 0) {
?>
<div id="app_icons" style="display: none;">
<?php
foreach ($apps as $num => $ap) {
?>
<div class="col-md-3 col-sm-12 col-xs-12 myapp">
<div id="detail_<?php
echo $num;
?>
" class="app_detail" style="display: none;" onclick="openDetails('<?php
echo $num;
?>
');">
<div style="padding: 20px;">
<h3><?php
echo $ap->app_name;
?>
</h3>
<?php
$paket = new Paket();
if ($ap->app_paket_id > 0) {
$paket->getByID($ap->app_paket_id);
echo '<div class="app_paket">' . $paket->paket_name . '</div>';
}
?>
<?php
$status = $ap->app_active;
echo '<div class="app_status">';
if ($status == 0) {
echo "Not active";
}
if ($status == 1) {
if ($ap->app_type == 1) {
echo "pending approval";
} else {
echo "App is being created";
}
}
if ($status == 2) {
echo "Up and running";
}
echo "</div>";
?>
<?php
if ($ap->app_active > 0 && $ap->app_type == 0) {
echo '<div class="app_contract">contract ends : ' . date("d-m-Y", strtotime($ap->app_contract_end));
if ($ap->app_active == 2) {
if ($ap->app_paket_id > 1) {
?>
<br>
<a href="<?php
echo _SPPATH;
?>
PaymentWeb/extend?app_id=<?php
echo $ap->app_id;
?>
">extend</a>
<?php
} elseif ($ap->app_paket_id == 1) {
//check if tinggal sebulan
$diff = dateDifference(date("Y-m-d", strtotime($ap->app_contract_end)), date("Y-m-d"), "%a");
// echo "<br>".$diff;
if ($diff <= 30) {
?>
<br>
<a href="<?php
echo _SPPATH;
?>
PaymentWeb/extend_paket_1?app_id=<?php
echo $ap->app_id;
?>
">extend</a>
<?php
}
}
}
echo '</div>';
}
?>
<?php
if ($ap->app_active == 2) {
if ($ap->app_paket_id == 1 || $ap->app_paket_id == 2) {
?>
<a href='<?php
echo _SPPATH;
?>
PaymentWeb/upgrade?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-success">Upgrade</a>
<?php
}
?>
<a href='<?php
echo _SPPATH;
?>
pushnotif?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-success btn-abu">Push Notifications</a>
<br>
<?php
} else {
if ($ap->app_active == 0) {
?>
<!-- <a href='--><?php
//=_SPPATH;
?>
<!--MyApp/appView?id=--><?php
//=$ap->app_id;
?>
<!--' class="btn btn-danger">Payment</a>-->
<a href='<?php
echo _SPPATH;
?>
PaymentWeb/pay?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-danger">Payment</a>
<a href='<?php
echo _SPPATH;
?>
delete_app?app_id=<?php
echo $ap->app_id;
?>
' onclick="return confirm('This will delete this App?')" class="btn btn-success btn-abu">Delete</a>
<?php
}
}
?>
<a href='<?php
echo _SPPATH;
?>
apps/edit?id=<?php
echo $ap->app_id;
?>
' class="btn btn-success btn-abu">Edit</a>
<a href='<?php
echo _SPPATH;
?>
preview?id=<?php
echo $ap->app_id;
?>
' class="btn btn-success btn-abu">Preview</a>
<a href='<?php
echo _SPPATH;
?>
uploads/json/<?php
echo $ap->app_keywords;
?>
.json' target="_blank" class="btn btn-success btn-abu">JSON</a>
</div>
</div>
<div id="app_<?php
echo $num;
?>
" class="app_icon" onclick="openDetails('<?php
echo $num;
?>
');">
<img width="100%" src="<?php
echo $ap->app_icon;
?>
">
<div style="display:none;position: absolute; background-color: rgba(0,0,0,0.5); border-radius: 0px; text-align: center; font-size: 18px; padding: 10px; margin-top: -53px; margin-left:10px; z-index:1; color: #ffffff;">
<?php
echo $ap->app_name;
?>
</div>
</div>
</div>
<?php
}
?>
<script>
function openDetails(n){
$('#detail_'+n).fadeToggle( "slow", "linear" );
console.log($('#app_'+n).width());
$('#detail_'+n).css("width",$('#app_'+n).width()+'px');
$('#detail_'+n).css("height",$('#app_'+n).height()+'px');
}
</script>
<style>
.app_detail{
position: absolute;
background-color: rgba(0,0,0,0.8);
width: 100px;
height: 200px;
color: #ffffff;
text-align: center;
z-index: 10;
}
.myapp{
cursor: pointer;
}
.app_contract{
font-style: italic;
font-size: 12px;
}
.myapp a{
color: #B2DFDB;
text-decoration: underline;
}
.myapp a.btn{
text-decoration: none;
margin: 5px;
color: #ffffff;
}
.entry{
padding: 5px;
background-color: #F7F7F7;
margin: 5px;
}
.entry a.btn{
text-decoration: none;
margin: 2px;
color: #ffffff;
}
</style>
</div>
<div class="clearfix"></div>
<div id="app_lists" >
<?php
foreach ($apps as $num => $ap) {
// $paket = new Paket();
// $paket->getByID($ap->app_paket_id);
?>
<div class=" col-md-6 col-sm-12 col-xs-12">
<div class="entry">
<div class="col-md-6 col-sm-6 col-xs-6">
<img width="100%" src="<?php
echo $ap->app_icon;
?>
">
</div>
<div class="col-md-6 col-sm-6 col-xs-6" style="text-align: center;">
<h3><?php
echo $ap->app_name;
?>
</h3>
<?php
$paket = new Paket();
if ($ap->app_paket_id > 0) {
$paket->getByID($ap->app_paket_id);
echo '<div class="app_paket">' . $paket->paket_name . '</div>';
}
?>
<?php
$status = $ap->app_active;
echo '<div class="app_status">';
if ($status == 0) {
echo "Not active";
}
if ($status == 1) {
if ($ap->app_type == 1) {
echo "pending approval";
} else {
echo "App is being created";
}
}
if ($status == 2) {
echo "Up and running";
}
echo "</div>";
?>
<?php
if ($ap->app_active > 0 && $ap->app_type == 0) {
echo '<div class="app_contract">contract ends : ' . date("d-m-Y", strtotime($ap->app_contract_end));
if ($ap->app_active == 2) {
if ($ap->app_paket_id > 1) {
?>
<br>
<a href="<?php
echo _SPPATH;
?>
PaymentWeb/extend?app_id=<?php
echo $ap->app_id;
?>
">extend</a>
<?php
} elseif ($ap->app_paket_id == 1) {
//check if tinggal sebulan
$diff = dateDifference(date("Y-m-d", strtotime($ap->app_contract_end)), date("Y-m-d"), "%a");
// echo "<br>".$diff;
if ($diff <= 30) {
?>
<br>
<a href="<?php
echo _SPPATH;
?>
PaymentWeb/extend_paket_1?app_id=<?php
echo $ap->app_id;
?>
">extend</a>
<?php
}
}
}
echo '</div>';
}
?>
<?php
if ($ap->app_active == 2) {
if ($ap->app_paket_id == 1 || $ap->app_paket_id == 2) {
?>
<a href='<?php
echo _SPPATH;
?>
PaymentWeb/upgrade?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-success">Upgrade</a>
<?php
}
?>
<a href='<?php
echo _SPPATH;
?>
pushnotif?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-success btn-abu">Push Notifications</a>
<br>
<?php
} else {
if ($ap->app_active == 0) {
?>
<!-- <a href='--><?php
//=_SPPATH;
?>
<!--MyApp/appView?id=--><?php
//=$ap->app_id;
?>
<!--' class="btn btn-danger">Payment</a>-->
<a href='<?php
echo _SPPATH;
?>
PaymentWeb/pay?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-danger">Payment</a>
<a href='<?php
echo _SPPATH;
?>
delete_app?app_id=<?php
echo $ap->app_id;
?>
' onclick="return confirm('This will delete this App?')" class="btn btn-success btn-abu">Delete</a>
<?php
}
}
?>
<a href='<?php
echo _SPPATH;
?>
apps/edit?id=<?php
echo $ap->app_id;
?>
' class="btn btn-success btn-abu">Edit</a>
<a href='<?php
echo _SPPATH;
?>
preview?id=<?php
echo $ap->app_id;
?>
' class="btn btn-success btn-abu">Preview</a>
<a href='<?php
echo _SPPATH;
?>
uploads/json/<?php
echo $ap->app_keywords;
?>
.json' target="_blank" class="btn btn-success btn-abu">JSON</a>
</div>
<div class="clearfix"></div>
</div>
</div>
<?php
}
?>
</div>
<style>
.table{
background-color: white;
}
</style>
<div id="app_table" class="table-responsive" style="margin-top: 20px; display: none;">
<table class="table table-striped table-bordered">
<thead>
<tr>
<th>
No.
</th>
<th>App</th>
<th>Action</th>
<th>Paket</th>
<th>Expired Date</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
foreach ($apps as $num => $ap) {
// $paket = new Paket();
// $paket->getByID($ap->app_paket_id);
?>
<tr>
<td><?php
echo $num + 1;
?>
</td>
<td style="text-align: center;">
<div class="foto100">
<img width="100px" src="<?php
echo $ap->app_icon;
?>
">
</div>
<?php
echo $ap->app_name;
?>
</td>
<td>
<!-- <a href='--><?php
//=_SPPATH;
?>
<!--MyApp/appView?id=--><?php
//=$ap->app_id;
?>
<!--' class="btn btn-info">Edit</a>-->
<?php
if ($ap->app_active == 2) {
if ($ap->app_paket_id == 1 || $ap->app_paket_id == 2) {
?>
<a href='<?php
echo _SPPATH;
?>
PaymentWeb/upgrade?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-success">Upgrade</a>
<?php
}
?>
<a href='<?php
echo _SPPATH;
?>
pushnotif?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-success">Push Notifications</a>
<br>
<?php
} else {
if ($ap->app_active == 0) {
?>
<!-- <a href='--><?php
//=_SPPATH;
?>
<!--MyApp/appView?id=--><?php
//=$ap->app_id;
?>
<!--' class="btn btn-danger">Payment</a>-->
<a href='<?php
echo _SPPATH;
?>
PaymentWeb/pay?app_id=<?php
echo $ap->app_id;
?>
' class="btn btn-danger">Payment</a>
<a href='<?php
echo _SPPATH;
?>
delete_app?app_id=<?php
echo $ap->app_id;
?>
' onclick="return confirm('This will delete this App?')" class="btn btn-danger">Delete</a>
<?php
}
}
?>
<a href='<?php
echo _SPPATH;
?>
apps/edit?id=<?php
echo $ap->app_id;
?>
' class="btn btn-danger">Edit</a>
<a href='<?php
echo _SPPATH;
?>
preview?id=<?php
echo $ap->app_id;
?>
' class="btn btn-danger">Preview</a>
<a href='<?php
echo _SPPATH;
?>
uploads/json/<?php
echo $ap->app_keywords;
?>
.json' target="_blank" class="btn btn-danger">JSON</a>
</td>
<td>
<?php
$paket = new Paket();
if ($ap->app_paket_id > 0) {
$paket->getByID($ap->app_paket_id);
echo $paket->paket_name;
}
?>
</td>
<td>
<?php
if ($ap->app_active > 0) {
echo date("d-m-Y", strtotime($ap->app_contract_end));
if ($ap->app_active == 2) {
if ($ap->app_paket_id > 1) {
?>
<br>
<a class="btn btn-default" href="<?php
echo _SPPATH;
?>
PaymentWeb/extend?app_id=<?php
echo $ap->app_id;
?>
">extend</a>
<?php
} elseif ($ap->app_paket_id == 1) {
//check if tinggal sebulan
$diff = dateDifference(date("Y-m-d", strtotime($ap->app_contract_end)), date("Y-m-d"), "%a");
// echo "<br>".$diff;
if ($diff <= 30) {
?>
<br>
<a class="btn btn-default" href="<?php
echo _SPPATH;
?>
PaymentWeb/extend_paket_1?app_id=<?php
echo $ap->app_id;
?>
">extend</a>
<?php
}
}
}
}
?>
</td>
<td><?php
$status = $ap->app_active;
if ($status == 0) {
echo "Your App is not active";
}
if ($status == 1) {
echo "Your App is being created.<br>For Android App, it will take up to 2 working days.<br>For iOS, it will take up to 3 weeks.";
}
if ($status == 2) {
echo "Your App is up and running";
}
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<div class="clearfix" style="margin-bottom: 100px;"></div>
</div>
<?php
} else {
header("Location:" . _SPPATH . "apps/make");
exit;
}
}
</td>
<td width="5%" align="center"></td>
<td width="5%" align="left">
<?php
echo $row['first_name'];
?>
<?php
echo $row['last_name'];
?>
<br/>
</td>
<td>
<?
$current_date=date('Y-mm-dd');
$date2=$row['date_joining'];
$date_result=dateDifference($current_date,$date2);
if($date_result['years']>=15)
{
echo "YES";
}
else
{
echo "NO";
}
?>
</td>
<td> <?php
echo $d;
?>
</td>
<td>
$tmptrajet[$j]["debuttxt"] = "<span>" . affichedatetime($tmptrajet[$j]["debut"]) . "</span><br>" . $debut;
//fintxt
$tbl_info = adressegps($tmptrajet[$j]["lat2"], $tmptrajet[$j]["lon2"]);
if (is_array($tbl_info)) {
$fin = $tbl_info["adresse"] . "<br><img src=\"" . __racineweb__ . "/tpl/img/lieux/" . $tbl_info["icon"] . "\"> <span>" . $tbl_info["libelle"] . "</span>";
} else {
$fin = $tbl_info;
}
//$tmptrajet[$j]["fintxt"]=$fin;
$tmptrajet[$j]["fintxt"] = "<span>" . affichedatetime($tmptrajet[$j]["fin"]) . "</span><br>" . $fin;
$tmptrajet[$j]["km"] = round($tmptrajet[$j]["km"], 2);
$totaldistance += $tmptrajet[$j]["km"];
if ($tmptrajet[$j]["lat2"] == "" && $tmptrajet[$j]["lon2"] == "") {
$tmptrajet[$j]["lat2"] = $tmptrajet[$j]["lat1"];
$tmptrajet[$j]["lon1"] = $tmptrajet[$j]["lon1"];
$tmptrajet[$j]["fin"] = "";
$tmptrajet[$j]["fintxt"] = $tmptrajet[$j]["debuttxt"];
$tmptrajet[$j]["datediff"] = "-";
} else {
//datediff
$tmptrajet[$j]["datediff"] = dateDifference($tmptrajet[$j]["fin"], $tmptrajet[$j]["debut"], '%h H %i Min');
$totalconduite += (int) ((strtotime($tmptrajet[$j]["fin"]) - strtotime($tmptrajet[$j]["debut"])) / 60);
}
}
$trajet = $tmptrajet;
$sql = "select lc.*,tlc.libelle as lib from " . __racinebd__ . "lieu_compte lc inner join " . __racinebd__ . "type_lieu_compte tlc on lc.type_lieu_compte_id=tlc.type_lieu_compte_id where compte_id=" . $_SESSION["compte_id"] . " and lc.supprimer=0 order by lc.libelle";
$link = query($sql);
while ($tbl = fetch($link)) {
$contenttab .= "tab.push(new Array('" . $tbl["icon"] . "','" . $tbl["latitude"] . "','" . $tbl["longitude"] . "','" . $tbl["rayon"] . "'));";
}
$tbl_list_export = $trajet;
$preres = get_result("SELECT data, pretime FROM {$TABLE_PREFIX}files WHERE info_hash ='" . $id . "'", true);
foreach ($preres as $key => $value) {
$uptime = $value["data"];
$pretime = $value["pretime"];
}
$uptime = str_replace("/", "-", $uptime);
$pretime = date('Y-m-d H:i:s', $pretime);
$nopre = explode("-", $pretime);
function dateDifference($date_1, $date_2, $differenceFormat = '%y-%m-%d-%h-%i-%s')
{
$datetime1 = date_create($date_1);
$datetime2 = date_create($date_2);
$interval = date_diff($datetime1, $datetime2);
return $interval->format($differenceFormat);
}
$prediff = dateDifference($uptime, $pretime);
$prediff = explode("-", $prediff);
$prediffy = $prediff[0];
//Jahre
$prediffm = $prediff[1];
//Monate
$prediffd = $prediff[2];
//Tage
$prediffh = $prediff[3];
//Stunden
$prediffmm = $prediff[4];
// Minuten
$prediffs = $prediff[5];
// Seekunden
if ($prediffy > '0') {
$prediff = ' ' . $pretime . ' / Upload was ' . $prediffy . ' Year(s) ' . $prediffm . ' Mont(s)) ' . $prediffd . ' Day(s) ' . $prediffh . ' Hour(s) ' . $prediffmm . ' Minute(s) and ' . $prediffs . ' Second(s) after Pre';
?>
</td>
<td>
<?php
echo getDatetime($row['date_joining']);
?>
</td>
<td>
<?php
echo $total_salary_basic;
?>
</td>
<td><?
$date2 = $row['date_joining'];
$date_result = dateDifference($date_upto, $date2);
echo $date_result['years'];
?>
</td>
<td>
<?
echo round(($total_salary_basic / 26) * 15 * $date_result['years'], 2);
?>
</td>
</tr>
<?
$sno++;
}
?>
</table> </div>
</td>
function DateDifferenceFormat($date_1, $date_2)
{
$day = (int) dateDifference($date_1, $date_2, "%a");
$hour = (int) dateDifference($date_1, $date_2, "%h");
$minute = (int) dateDifference($date_1, $date_2, "%i");
$differenceFormat = "%a";
$now = (bool) false;
if ($day < 1) {
if ($hour == 0) {
if ($minute < 2) {
$minutes = "Minute";
$now = true;
} else {
$minutes = "Minutes";
}
$differenceFormat = "%i {$minutes} ago";
} else {
if ($hour < 2) {
$hours = "Hour";
} else {
$hours = "Hours";
}
$differenceFormat = "%h {$hours} ago";
}
} else {
if ($day >= 1) {
if ($day < 2) {
$days = "Day";
} else {
$days = "Days";
}
$differenceFormat = "%a {$days} ago";
}
}
if ($now) {
return " Now";
} else {
return dateDifference($date_1, $date_2, $differenceFormat);
}
}
//$fromdate = Mage::getModel('core/date')->date('Y-m-d',strtotime('-1 day'));
//$todate = Mage::getModel('core/date')->date('Y-m-d');
$filter = $_REQUEST['option'];
$product_id = $_REQUEST['product_id'];
$from = $_REQUEST['from'];
$to = $_REQUEST['to'];
function dateDifference($date_1, $date_2, $differenceFormat = '%R%a')
{
$datetime1 = date_create($date_1);
$datetime2 = date_create($date_2);
$interval = date_diff($datetime1, $datetime2);
return $interval->format($differenceFormat);
}
list($fyear, $fmonth, $fday) = split('[/.-]', $from);
list($tyear, $tmonth, $tday) = split('[/.-]', $to);
$diff = dateDifference($from, $to);
if ($product_id > 0 && checkdate($fmonth, $fday, $fyear) && checkdate($tmonth, $tday, $tyear) && $diff <= 30 && $diff > 0) {
$orders = Mage::getModel('sales/order_item')->getCollection()->addAttributeToSelect('*')->addAttributeToFilter('product_id', $product_id)->addAttributeToFilter('updated_at', array('from' => $from, 'to' => $to));
} else {
echo "Please check format";
exit;
}
//$orders = $orders->setPageSize(10)->setPage(1,10);
$orders = $orders->load()->toArray();
//header("Content-Type: application/vnd.ms-excel");
header("Content-Type: text/csv");
header("Cache-Control: no-cache, must-revalidate");
// HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");
// Date in the past
echo "product No. \t Qty Canceled \t Order No. \t Customer_id \t Bill To Name \t Billing Contact \t Ship To Name \t Shipping Contact \t Grand Total \t Status \n";
require_once 'includes/config.php';
$id = -1;
$errors = array();
$title = "Experiment Not Found";
$time = false;
$is_activity = false;
if (isset($_GET['id'])) {
$id = (int) safeString($_GET['id']);
$meta = getExperiment($id);
$is_activity = $meta['activity'] == 1;
if (count($meta) > 0) {
// Grab some meta data
$title = $meta['name'];
$ownerid = $meta['owner_id'];
$meta['create_diff'] = dateDifference(time(), strtotime($meta['timecreated']));
$meta['mod_diff'] = dateDifference(time(), strtotime($meta['timemodified']));
// Make calls to pull data from db
$fields = array();
$vises = array();
$tags = array();
$videos = array();
$images = array();
$sessions = array();
$collabs = array();
if ($is_activity) {
$fields = getFields($meta['activity_for']);
$tags = getTagsForExperiment($meta['activity_for']);
$sessions = getSessionsForExperiment($id);
$vises = getResponsesForActivity($id);
} else {
$fields = getFields($id);
</button>
-->
</div>
<div class="col-md-2" style="height:135px;border-right:solid 1px #999;text-align:center">
<span style="line-height:1.2em;display:inline-block;padding:0">
ROOM<br />
<span style="font-size:68px;font-weight:bold;line-height:1em"><?php
echo $rooms['total_room'];
?>
</span><br />
</span>
<span style="font-size:68px;font-weight:bold;line-height:1em;color:#878787">/</span>
<span style="line-height:1.2em;display:inline-block;padding:0">
NIGHTS<br />
<span style="font-size:68px;font-weight:bold;line-height:1em"><?php
echo dateDifference($reservation->checkout, $reservation->checkin);
?>
</span><br />
</span>
</div>
<div class="col-md-2" style="height:135px;border-right:solid 1px #999;text-align:center">
<span style="line-height:1.2em;display:inline-block;padding:0">
ADULTS<br />
<span style="font-size:68px;font-weight:bold;line-height:1em"><?php
echo $reservation->adults;
?>
</span><br />
</span>
<span style="font-size:68px;font-weight:bold;line-height:1em;color:#878787">/</span>
<span style="line-height:1.2em;display:inline-block;padding:0">
print $tbl["maxtime"];
*/
//recherche du km
$_POST["vehicule"] = $tbl_km["phantom_device_id"];
require "rapport-gen2.php";
$tbl_km["datediff"] = secondsToTime2($totalconduite * 60);
//$tbl_km["datediff"]=$totalconduite;
$tbl_km["km"] = round($totaldistance, 2);
$totalalldistance += $totaldistance;
$tbl_km["conso"] = $tbl_km["consotheorique"] * (int) $tbl_km["km"] / 100;
$totalallconso += $tbl_km["conso"];
$tbl_km["vitesse"] = vitessekmh($vitessemaxvehicule);
$tbl_km["mintime"] = $trajet[0]["debut"];
//print $trajet[0]["debut"];
$tbl_km["maxtime"] = $trajet[count($trajet) - 1]["fin"];
$tbl_km["amplitude"] = dateDifference($tbl_km["mintime"], $tbl_km["maxtime"], '%d Jours %h H %i Min');
/*
print strtotime($tbl_km["maxtime"])."<br>";
print strtotime($tbl_km["mintime"])."<br>";
*/
$tbl_km["maxtime"] = $tbl_km["maxtime"] == "" ? $tbl_km["mintime"] : $tbl_km["maxtime"];
$totalallarret += strtotime($tbl_km["maxtime"]) - strtotime($tbl_km["mintime"]) - $totalconduite * 60;
//print $totalarret."<br>";
$tbl_km["arret"] = secondsToTime(strtotime($tbl_km["maxtime"]) - strtotime($tbl_km["mintime"]) - $totalconduite * 60);
$totalallconduite += $totalconduite * 60;
//$totalarret+=(strtotime($tbl_km["maxtime"])-($totalconduite*60))-strtotime($tbl_km["mintime"]);
//print (strtotime($tbl_km["maxtime"])-($totalconduite*60))-strtotime($tbl_km["mintime"])."<br>";
//$tbl_km["arret"]=dateDifference($tbl_km["mintime"] , date("Y-m-j h:i:s",strtotime($tbl_km["maxtime"])-$totalconduite*60) , '%d Jours %h H %i Min' );
//$totalkm+=($tbl["kminit"]+$totaldistance+$tbl["correctifkm"]);
/*
$tbl["datediff"]=dateDifference($tbl["mintime"] , $tbl["maxtime"] , '%y Année %m Mois %d Jours %h H %i Min' );
<?php
$where = "";
$_POST["date_jour"] = $_POST["date_jour"] == "" ? date('d/m/Y') : $_POST["date_jour"];
$nottoday = dateDifference(datebdd($_POST["date_jour"]), date('Y/m/d'), '%d') == 0 ? false : true;
$_POST["date_debut"] = jourdebutmois($_POST["date_jour"]) . " 00:00:00";
$_POST["date_fin"] = jourfinmois($_POST["date_jour"]) . " 23:59:59";
require $_SERVER["DOCUMENT_ROOT"] . __racine__ . "/tpl/script/rapport-kilometrique.php";
if ($lastlat != $tblconduite["latitude"] && $lastlon != $tblconduite["longitude"]) {
if ($lastlat != 0 && $lastlon != 0) {
//print "ici2";
$distance = haversineGreatCircleDistance($lastlat, $lastlon, $tblconduite["latitude"], $tblconduite["longitude"]) / 1000;
$semaine[$tabjour[0]]["km"] += round($distance, 2);
$totaldistance += $semaine[$tabjour[0]]["km"];
}
}
$semaine[$tabjour[0]]["vitessemax"] = $semaine[$tabjour[0]]["vitessemax"] > vitessekmh($tblconduite["speed"]) ? $semaine[$tabjour[0]]["vitessemax"] : vitessekmh($tblconduite["speed"]);
// if(($lastspeed!=$tblconduite["speed"]&&$lastspeed==0)||($lastdistance!=$distance&&$lastdistance==0)){
if ($lastspeed != $tblconduite["speed"] && $lastspeed == 0 || $lastlat != round($tblconduite["latitude"], 4) && $lastlon != round($tblconduite["longitude"], 4) && !$first && $tblconduite["speed"] != 0) {
$semaine[$tabjour[0]]["debut"] = $semaine[$tabjour[0]]["debut"] == 0 ? $tblconduite["time"] : $semaine[$tabjour[0]]["debut"];
$semaine[$tabjour[0]]["fin"] = 0;
$debut = strtotime($tblconduite["time"]);
}
if ($lastspeed != $tblconduite["speed"] && $tblconduite["speed"] == 0 && $lastspeed != 0 || $lastdistance != $distance && $distance == 0 && $lastdistance != 0) {
$semaine[$tabjour[0]]["fin"] = $tblconduite["time"];
$fin = strtotime($tblconduite["time"]);
if ($semaine[$tabjour[0]]["fin"] != "" && $semaine[$tabjour[0]]["debut"] != "") {
$semaine[$tabjour[0]]["datediff"] = dateDifference($semaine[$tabjour[0]]["fin"], $semaine[$tabjour[0]]["debut"], '%h H %i Min');
$semaine[$tabjour[0]]["conduite"] += round(($fin - $debut) / 60);
}
$semaine[$tabjour[0]]["arret"] = date('h\\H i ', strtotime($semaine[$tabjour[0]]["fin"]) - strtotime($semaine[$tabjour[0]]["debut"]) - 3600 - $semaine[$tabjour[0]]["conduite"] * 60);
//$semaine[$tabjour[0]]["km"]=round($semaine[$tabjour[0]]["km"],2);
}
$lastspeed = $tblconduite["speed"];
$lastlat = $tblconduite["latitude"];
$lastlon = $tblconduite["longitude"];
$lastdistance = $distance;
}
//print_r($semaine);
<?php
include 'header.php';
$show = mysql_query("SELECT *, subscriptions.quality FROM (SELECT shows.*, episodes.aired FROM shows as shows " . "LEFT JOIN (SELECT showid, aired FROM episodes WHERE aired >= CURDATE()) as episodes " . "ON shows.id = episodes.showid " . "WHERE id IN (SELECT showid FROM subscriptions) " . "ORDER BY ISNULL(aired) ASC, aired ASC, title ASC) as final " . "JOIN subscriptions ON subscriptions.showid = final.id " . "GROUP BY id ORDER BY ISNULL(aired), aired, title");
$englang = array(it => 'Italian', en => 'English', es => 'Spanish', ro => 'Romanian', pt => 'Portuguese', fr => 'French', hu => 'Hungarian', ru => 'Russian', de => 'German', sw => 'Swedish', dk => 'Dutch', none => 'No subs');
while ($singleshow = mysql_fetch_array($show, MYSQL_ASSOC)) {
if ($singleshow['aired'] > 0) {
$difference = dateDifference($singleshow['aired']);
# Difference to now (default value)
$airingdays = floor($difference % 31);
$airingmonths = floor($difference / 31);
if ($airingmonths > 0) {
$airingtext = "{$airingmonths} months, {$airingdays} days";
} else {
$airingtext = $airingdays == 0 ? 'Today' : ($airingdays == 1 ? '1 day' : $airingdays . ' days');
}
} else {
$airingtext = "No airs";
}
$q = $singleshow['quality'];
if ($singleshow['subtitles'] != null) {
$subtitlelanguage = $englang[$singleshow['subtitles']];
} else {
$subtitlelanguage = $englang['none'];
}
if ($q == 0) {
$quality = "HDTV";
} elseif ($q == 1) {
$quality = "DVDRIP";
} elseif ($q == 2) {
$quality = "720p";
