<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
}
