function userlist()
{
if (!F3::get('SESSION.asid')) {
F3:
reroute('/admin');
}
$user = new Axon('tbl_user');
$users = array();
$user_list = $user->find();
if ($user_list != NULL) {
foreach ($user_list as $ul) {
$users[] = array($ul->email, $ul->username, '<img src="' . $ul->image . '" width="20px" height="20px" /> ' . $ul->fullname, $ul->active == 'y' ? 'Yes' : 'No', '<center><a href="#" class="blockLink" data-id="' . $ul->id . '">' . ($ul->active == 'y' ? 'Block' : 'Unblock') . '</a><br/><a href="#" class="deleteLink" data-id="' . $ul->id . '">Delete</a></center>');
}
$i = 0;
foreach ($user_list as $user) {
$user_id[] = $user_list[$i]->id;
$i++;
}
} else {
$users = 0;
$user_id = 0;
}
$this->set('identity', $user_id);
$this->set('userList', $users);
$this->set('title', 'User');
if (Snippets::_isAjax()) {
echo Template::serve("template/admin/user.htm");
} else {
$this->set('template', 'user');
echo Template::serve("template/admin/layout.htm");
}
}
function lst()
{
$user = new Axon('tbl_user');
$report = array();
$user->def("hits", "SELECT COUNT(date) FROM tbl_vote, tbl_poll WHERE date between '" . F3::get("POST.from") . "' and '" . F3::get("POST.to") . "'" . (F3::get("POST.telco") ? " and telco='" . F3::get("POST.telco") . "'" : "") . " and tbl_poll.id=tbl_vote.poll_id and tbl_poll.user_id=tbl_user.id group by tbl_user.id");
if ($user->found() > 0) {
$report_list = $user->find();
foreach ($report_list as $rl) {
$report[] = array('<img src="' . $rl->image . '" width="20px" height="20px" /> ' . $rl->fullname, $rl->hits ? $rl->hits : 0);
}
}
$this->set('report', $report);
echo Template::serve("template/admin/report_list.htm");
}
function userList()
{
//the user who login to the system
$operator = new Axon("admin");
$operators = $operator->find();
foreach ($operators as $users) {
if ($users->type == 1) {
$user[] = array($users->fullname, $users->username, $users->password, "all");
} else {
$user[] = array($users->fullname, $users->username, $users->password, $users->type == '21' ? '2' : '4');
}
}
return $user;
}
function getVdc()
{
//die(var_dump($this->get('PARAMS')));
$district_name = $this->get('PARAMS.district_id');
$content = $this->get('PARAMS.term');
$district = new Axon('district');
$district->load(array('name=:n', array(':n' => $district_name)));
$district_id = $district->id;
$vdc = new Axon('vdc_list');
$vdc_list = $vdc->find(array("district_id=:did and name regexp '{$content}'", array(':did' => $district_id)));
$return_vdcs = array();
foreach ($vdc_list as $vl) {
$return_vdcs[] = $vl->name;
}
echo json_encode($return_vdcs);
}
function all()
{
$poll = new Axon('tbl_poll');
// echo 123;die;
// $this->set('title', 'Quizzes');
$poll->def('fullname', 'SELECT fullname FROM tbl_user WHERE tbl_poll.user_id=tbl_user.id');
$poll->def('image', 'SELECT image FROM tbl_user WHERE tbl_poll.user_id=tbl_user.id');
$poll->def('hits', 'SELECT COUNT(date) FROM tbl_vote WHERE tbl_poll.id=tbl_vote.poll_id');
$q = $poll->find('published_date IS NOT NULL AND is_archive="n" AND expiry_date>now() AND private="n"');
$polls = array();
foreach ($q as $qu) {
$polls[$qu->id] = array(strtoupper($qu->keyword), $qu->question, '<img src="' . $qu->image . '" width="20px" height="20px" /> ' . $qu->fullname);
}
$this->set('title', 'All polls');
$this->set('pollList', $polls);
$this->set('template', 'all');
echo Template::serve("template/layout.htm");
}
function mypolls()
{
if (!F3::get('SESSION.sid')) {
F3::reroute('/home');
}
$tablePoll = new Axon('tbl_poll');
$mypolls = $tablePoll->find(array('is_archive="n" AND expiry_date >now() AND user_id=:uid', array(':uid' => F3::get('SESSION.user')->id)));
$polls = array();
foreach ($mypolls as $poll) {
if (!strpos($poll->question, '?')) {
$poll->question .= "?";
}
$polls[] = array(strtoupper($poll->keyword), $poll->question, $poll->id, $poll->published_date, $poll->expiry_date);
}
// var_dump($polls);die;
$date = DATE('Y-m-d');
F3::set("nowDate", $date);
F3::set('title', 'My Polls');
F3::set('myList', $polls);
F3::set('template', 'mypolls');
echo Template::serve("template/layout.htm");
}
function allPoll()
{
if (!F3::get('SESSION.asid')) {
F3:
reroute('/admin');
}
$poll = new Axon("tbl_poll");
$poll->def('fullname', 'SELECT fullname FROM tbl_user WHERE tbl_poll.user_id=tbl_user.id');
$poll->def('image', 'SELECT image FROM tbl_user WHERE tbl_poll.user_id=tbl_user.id');
$poll->def('hits', 'SELECT COUNT(date) FROM tbl_vote WHERE tbl_poll.id=tbl_vote.poll_id');
$q = $poll->find();
$users = array();
foreach ($q as $qu) {
$polls[$qu->id] = array(strtoupper($qu->keyword), $qu->question, '<img src="' . $qu->image . '" width="20px" height="20px" />' . $qu->fullname, date_create("now") >= date_create($qu->expiry_date) ? "Yes" : "No", $qu->published_date ? "Yes" : "No", $qu->published_date && date_create("now") < date_create($qu->expiry_date) && $qu->is_archive == "n" ? "Yes" : "No", $qu->private == 'y' ? "Private" : "Public", $qu->hits);
if (!in_array($qu->fullname, $users)) {
$users[] = $qu->fullname;
}
}
F3::set('pollList', $polls);
F3::set('users', $users);
F3::set('template', 'poll');
echo Template::Serve('template/admin/layout.htm');
}
<?php
// Retrieve blog entries
$kul = new Axon('kul');
F3::set('entries', $kul->find());
// Use the home.htm template
F3::set('pagetitle', 'ana sayfa');
F3::set('template', 'home');
F3::call('render');
}
try {
$newsfeed = $facebook->api('me/home', array('limit' => 50, 'filter' => 'fl_' . $user->fl_id));
} catch (FacebookApiException $e) {
F3::error('400');
}
/*
function is_relationship_story($data){
if(array_key_exists('story', $data) && preg_match('/went from being/', $data['story'])){
return true;
}
return false;
}*/
// Get number for people user follows
$followed = new Axon('followed');
$followed_count = count($followed->find(array('user_id=:user_id', array(':user_id' => $user->id))));
F3::set('followed_count', $followed_count);
// Make user a var for template use
F3::set('user', array('fb_id' => $user->fb_id, 'name' => $user->name));
F3::set('extra_css', array('dashboard.css'));
echo Template::serve('templates/header.html');
F3::set('newsfeed', $newsfeed['data']);
F3::set('page', 'newsfeed');
echo Template::serve('templates/newsfeed.html');
F3::set('extra_js', array());
echo Template::serve('templates/footer.html');
die;
});
/* Logging in and logging out ***********************************************/
F3::route('GET /login', function () {
$facebook = F3::get('Facebook');
function district_code()
{
$id = new Axon('district');
$districts = $id->find();
foreach ($districts as $district) {
$list[] = array($district->id, $district->name);
}
// var_dump($list);die;
F3::set('district_code', $list);
}
function dataNamsari()
{
$date1 = F3::get("POST.date1");
$date2 = F3::get("POST.date2");
$status = F3::get("POST.status");
// var_dump($status);die;
$user = new Axon('vehicle');
$wheeler_type = F3::get("SESSION.wheeler");
//this value is from admin session 'type
$wheeler_sql = $wheeler_type == 1 ? "" : " and wheeler='" . $wheeler_type . "'";
$wheeler = array('21' => '2', '22' => '4');
if ($user->found("date between '" . $date1 . "' and '" . $date2 . "' and form_type='namsari' {$wheeler_sql} and status='" . $status . "'") < 1) {
$data = array();
} else {
$list = $user->find("date between'" . $date1 . "' and '" . $date2 . "' and form_type='namsari' {$wheeler_sql} and status='" . $status . "'");
foreach ($list as $lists) {
$zone = $this->getZone($lists->zone_id);
$symbol = $this->getSymbolType($lists->vehicle_symbol_type);
// var_dump($symbol);die;
$vehicleNo = $zone . $lists->lot_number . $symbol . $lists->number;
// var_dump($veihcleNo);
$w_type = $wheeler[$lists->wheeler];
$data[] = array($vehicleNo, $lists->date, $lists->engine_num, $lists->chessis_num, $lists->model, $lists->ip_address, $w_type, $lists->id);
}
}
F3::set('data', $data);
F3::set('nav', 'navigation');
F3::set('title', 'Admin - Namsari');
F3::set('templateAdmin', 'namsariData');
echo Template::serve("template/layout.html");
}
