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";