<tbody> <?php $not_accepted = array('WIB', 'A', 'ACDT', 'AEST', 'WITA', 'AWST'); $dateTime = 'not allowed'; $style = ''; for ($i = 0; $i < count($locations); $i++) { $id = $locations[$i]['fs_invited_location_id_pk']; $name = $locations[$i]['fs_invited_location_name']; $time1 = $locations[$i]['fs_invited_location_send_tim1']; $time2 = $locations[$i]['fs_invited_location_send_tim2']; $time3 = $locations[$i]['fs_invited_location_send_tim3']; $tz = $locations[$i]['fs_invited_location_timezone']; $date = $locations[$i]['fs_invited_location_date']; if (!in_array($tz, $not_accepted)) { $time->setTimeZoneDateTime($tz); $dateTime = $time->getTimeZoneDateTime12(); if (strpos($dateTime, 'PM') > 0) { $style = 'color:red'; } else { $style = 'color:green'; } } ?> <tr> <td><?php echo $name . ' (' . $tz . " ) [<b style='{$style}' >" . $dateTime . '</b>]'; ?> </td> <td><?php echo Time::convertTime24ToTime12($time1); ?>
$sc->get_site_last_update($url); if(mysql_query("DELETE FROM fs_test WHERE group_id NOT IN (SELECT max(id) FROM fs_test WHERE GROUP BY group_id); ")) { echo "deleted "; } else { echo "not deleted"; } echo "<div style='display:none'>"; Time::setTimeZoneDateTime('PHT'); echo 'Time' . Time::getTimeZoneDateTime12() . '<br>'; echo 'Time' . Time::getTimeZoneDateTime24() . '<br>'; echo 'Time' . Time::getTimeZoneLocation() . '<br>'; echo "date" . Time::getTimezoneDate() . '<br>'; // break; // case 'MONTREAL': // $url='http://www.timeanddate.com/worldclock/canada/montreal'; // $timezone='EST'; // break; // $location = 'BANGKOK'; // $timezone='ICT'; // $url='http://www.timeanddate.com/worldclock/thailand/bangkok'; // $b = $db->update(
public function printScrapperMenu($sc, $mc, $location, $invited_status, $totalApprovedEmail, $invited1, $database) { $invited1->_setInvitedTotals($database); /* echo 'total pending ' . $invited1->getTotalPending_() . "\n" . 'official signup ' . $invited1->getTotalOfficialSignUp_() . "\n" . 'official member' . $invited1->getTotalOfficialMember_() . "\n" . 'pending signup' . $invited1->getTotalPendingSignUp_() . "\n" . 'send sent' . $invited1->getTotalSendSent_() . "\n" ; */ // $total = $sc->get_total_results_invitedstatus();//get total results of the invited_status $topCity = $this->getTopCityArray(); // get top city // $location = 'NEW YORK'; // sorting of the location // $invited_status = '0'; // pending $invited = Database::selectV1('fs_invited', '*', "location = '{$location}' and invited_Status = 1 ORDER BY invited_id DESC limit 1"); // print_r($invited); $DateTimeSend = !empty($invited[0]['DateTimeSend']) ? $invited[0]['DateTimeSend'] : ''; $DateTimeSend1 = !empty($invited[0]['DateTimeSend1']) ? $invited[0]['DateTimeSend1'] : ''; $DateTimeSend2 = !empty($invited[0]['DateTimeSend2']) ? $invited[0]['DateTimeSend2'] : ''; $this->setTimeZone($location); Time::setTimeZoneDateTime($this->getTimeZone()); // initialized timezone $totalEmailAllowed = 200; $totalAvailable = $totalEmailAllowed - $totalApprovedEmail; ?> <tr> <td> <!-- 0 - pending 12 - Send / Sent 7 - Pending Sign Up 2 - Official Sign Up 3 - Official Member --> <select onchange="invited_person ( 'invited-person' , 'change-content' , '' , '#invited-people-sort' )" id='invited-people-sort' style='padding:10px;' > <!-- 0 - pending --> <?php if ($invited_status == 0) { ?> <option value='0' selected="selected" > pending (<?php echo $invited1->getTotalPending_(); ?> )</option> <?php } else { ?> <option value='0' > pending (<?php echo $invited1->getTotalPending_(); ?> )</option> <?php } ?> <!-- 12 - Send / Sent --> <?php if ($invited_status == 12) { ?> <option value='12' selected="selected" > Send / Sent (<?php echo $invited1->getTotalSendSent_(); ?> )</option> <?php } else { ?> <option value='12' > Send / Sent (<?php echo $invited1->getTotalSendSent_(); ?> )</option> <?php } ?> <!-- 7 - Pending Sign Up --> <?php if ($invited_status == 7) { ?> <option value='7' selected="selected" > Pending Sign Up (<?php echo $invited1->getTotalPendingSignUp_(); ?> )</option> <?php } else { ?> <option value='7' > Pending Sign Up (<?php echo $invited1->getTotalPendingSignUp_(); ?> )</option> <?php } ?> <!-- 2 - Official Sign Up --> <?php if ($invited_status == 2) { ?> <option value='2' selected="selected" > Official Sign Up (<?php echo $invited1->getTotalOfficialSignUp_(); ?> )</option> <?php } else { ?> <option value='2' > Official Sign Up (<?php echo $invited1->getTotalOfficialSignUp_(); ?> )</option> <?php } ?> <!-- 3 - Official Member --> <?php if ($invited_status == 3) { ?> <option value='3' selected="selected" > Official Member (<?php echo $invited1->getTotalOfficialMember_(); ?> )</option> <?php } else { ?> <option value='3' > Official Member (<?php echo $invited1->getTotalOfficialMember_(); ?> )</option> <?php } ?> <!-- 4 deleted !--> <?php if ($invited_status == 4) { ?> <option value='4' selected="selected" >Deleted (<?php echo $invited1->getTotalDeleted_(); ?> )</option> <?php } else { ?> <option value='4' > Deleted (<?php echo $invited1->getTotalDeleted_(); ?> )</option> <?php } ?> <!-- <?php if ($invited_status == 0) { ?> <option value='0' selected="selected" > pending (<?php echo $total['tPending']; ?> )</option> <?php } else { ?> <option value='0' > pending (<?php echo $total['tPending']; ?> )</option> <?php } ?> <?php if ($invited_status == 1) { ?> <option value='1' selected="selected" >approved (<?php echo $total['tApproved']; ?> )</option> <?php } else { ?> <option value='1' > approved (<?php echo $total['tApproved']; ?> )</option> <?php } ?> <?php if ($invited_status == 5) { ?> <option value='5' selected="selected" >need personal invite(<?php echo $total['tNeedPersonalInvite']; ?> )</option> <?php } else { ?> <option value='5' > need personal invite(<?php echo $total['tNeedPersonalInvite']; ?> )</option> <?php } ?> <?php if ($invited_status == 2) { ?> <option value='2' selected="selected" >sign-up (<?php echo $total['tSignup']; ?> )</option> <?php } else { ?> <option value='2' > sign-up (<?php echo $total['tSignup']; ?> )</option> <?php } ?> <?php if ($invited_status == 3) { ?> <option value='3' selected="selected" >officially (<?php echo $total['tOfficiallyMember']; ?> )</option> <?php } else { ?> <option value='3' > officially (<?php echo $total['tOfficiallyMember']; ?> )</option> <?php } ?> <?php if ($invited_status == 4) { ?> <option value='4' selected="selected" > deleted (<?php echo $total['tDeleted']; ?> )</option> <?php } else { ?> <option value='4' > deleted (<?php echo $total['tDeleted']; ?> )</option> <?php } ?> <?php if ($invited_status == 6) { ?> <option value='6' selected="selected" > pending but no email (<?php echo $total['tPendingButNoEmail']; ?> )</option> <?php } else { ?> <option value='6' > pending but no email (<?php echo $total['tPendingButNoEmail']; ?> )</option> <?php } ?> <?php if ($invited_status == 7) { ?> <option value='7' selected="selected" > signup from pending (<?php echo $total['tSignUpPending']; ?> )</option> <?php } else { ?> <option value='7' > signup from pending (<?php echo $total['tSignUpPending']; ?> )</option> <?php } ?> <?php if ($invited_status == 8) { ?> <option value='8' selected="selected" > signup anonymous people(<?php echo $total['tSignUpAnonymous']; ?> )</option> <?php } else { ?> <option value='8' > signup anonymous people (<?php echo $total['tSignUpAnonymous']; ?> )</option> <?php } ?> <?php if ($invited_status == 9) { ?> <option value='9' selected="selected" > signup refferal (<?php echo $total['tSignUpReferral']; ?> )</option> <?php } else { ?> <option value='9' > signup refferal (<?php echo $total['tSignUpReferral']; ?> )</option> <?php } ?> <?php if ($invited_status == 10) { ?> <option value='10' selected="selected" > signup from deleted (<?php echo $total['tSignUpDeleted']; ?> )</option> <?php } else { ?> <option value='10' > signup from deleted (<?php echo $total['tSignUpDeleted']; ?> )</option> <?php } ?> <?php if ($invited_status == 11) { ?> <option value='11' selected="selected" > signup from personal invited(<?php echo $total['tSignUpPersonalInvite']; ?> )</option> <?php } else { ?> <option value='11' > signup from personal invited(<?php echo $total['tSignUpPersonalInvite']; ?> )</option> <?php } ?> --> </select> </td> <td style="width:10" > <?php $mc->image(array('type' => 'loader', 'id' => 'invited-people-sort-loader', 'style' => 'visibility:hidden;height:10px;')); ?> </td> <td> <select onchange="invited_person ( 'invited-person' , 'change-content' , '' , '#invited-people-sort' )" id='invited-people-sort-location' > <option value="LOCATION" >LOCATION</option> <?php $response = select_v4(array('type' => 'select', 'tablename' => 'fs_invited', 'rows' => 'count(*) as total , location', 'where' => "invited_status = {$invited_status} GROUP BY location")); for ($i = 0; $i < count($response); $i++) { $locationDb = $response[$i]['location']; $totalDb = $response[$i]['total']; if ($location == $locationDb) { echo "<option value= '{$locationDb}' selected=\"selected\">{$locationDb}({$totalDb})</option>"; } else { echo "<option value= '{$locationDb}' >{$locationDb}({$totalDb})</option>"; } } ?> </select> </td> <!-- <td> <div> <?php echo " " . Time::getTimeZoneDateTime12() . ' ' . $this->getTimeZone(); ?> </div> </td> <td> <select onchange="setTimeInviteTime('<?php echo date('Y-m-d'); ?> ' , this, 'dateTime', '', '<?php echo $location; ?> ', '<?php echo $this->getTimeZone(); ?> ' )" > <option value="Time" >TIME</option> <?php foreach (Time::getTimeDbFormatArray() as $key => $value) { echo '<option value=' . $key . '>' . $value . '</option>'; } ?> </select> <?php echo "<br>" . Time::convertTimeToReadableDate($DateTimeSend); ?> </td> <td> <select onchange="setTimeInviteTime('<?php echo date('Y-m-d'); ?> ' , this, 'time', 'DateTimeSend1','<?php echo $location; ?> ', '<?php echo $this->getTimeZone(); ?> ')" > <option value="Time" >TIME</option> <?php foreach (Time::getTimeDbFormatArray() as $key => $value) { echo '<option value=' . $key . '>' . $value . '</option>'; } ?> </select> <?php echo "<br>" . Time::convertTimeToReadableDate($DateTimeSend1); ?> </td> <td> <select onchange="setTimeInviteTime('<?php echo date('Y-m-d'); ?> ' , this, 'time', 'DateTimeSend2', '<?php echo $location; ?> ', '<?php echo $this->getTimeZone(); ?> ')" > <option value="Time" >TIME</option> <?php foreach (Time::getTimeDbFormatArray() as $key => $value) { echo '<option value=' . $key . '>' . $value . '</option>'; } ?> </select> <?php echo "<br>" . Time::convertTimeToReadableDate($DateTimeSend2); ?> </td> <td> <div><?php echo $totalAvailable; ?> emails available</div> </td> --> <td> <input class="btn btn-lg btn-danger" type="button" onclick="fs_popup( 'popup-small' , 'invited-person' , '' , 'method' , 'table_id' , 'table_name' )" value="add new" > </td> <?php }