function login()
{
$user = new Axon('tbl_user');
$id = F3::get('POST.id');
if ($user->found(array("id=:id", array(":id" => $id))) == 0) {
// Register user
$user->id = $id;
$user->username = F3::get('POST.username');
$user->email = F3::get('POST.email');
$user->fullname = F3::get('POST.fullname');
$user->image = F3::get('POST.image');
$user->save();
} else {
$user->load(array("id=:id", array(":id" => $id)));
if ($user->active == 'n') {
die(json_encode(array("message" => "hello world", "type" => "error")));
} else {
$user->username = F3::get('POST.username');
$user->email = F3::get('POST.email');
$user->fullname = F3::get('POST.fullname');
$user->image = F3::get('POST.image');
$user->save();
}
F3::set('SESSION.user', $user);
F3::set('SESSION.sid', Snippets::_getRN());
}
}
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 adminLogin()
{
$admin = new Axon('tbl_admin');
$username = F3::get('POST.usr');
$password = F3::get('POST.pwd');
if ($admin->found(array('username=:username and password=:password', array(':username' => $username, ':password' => md5($password)))) == 1) {
$admin->load(array('username=:username and password=:password', array(':username' => $username, ':password' => md5($password))));
F3::set('SESSION.admin', $admin);
F3::set('SESSION.asid', Snippets::_getRN());
echo json_encode(array('message' => "You have been logged in "));
} else {
echo json_encode(array('mes' => "Either password or usernaem is wrong"));
}
}
function transfer_feedback()
{
$id = F3::get("PARAMS.id");
$vehicle = new Axon("vehicle");
$vehicle->load(array('id=:id', array(':id' => $id)));
$zone_id = $vehicle->zone_id;
$wheeler = $vehicle->wheeler;
$dates = $vehicle->date;
$date = DB::sql("SELECT DATE_ADD( date, INTERVAL 15 DAY ) AS ds FROM vehicle WHERE id='{$id}' and date='{$dates}'");
$dt = new Form_elements();
$nepDate = $dt->dateConvertEn($date[0]["ds"]);
// var_dump($date[0]["ds"]);die;
//echo $nepDate;die;
$zone = Admin::getZone($vehicle->zone_id);
$symbol = Admin::getSymbolType($vehicle->vehicle_symbol_type);
$vehicleNo = $zone . $vehicle->lot_number . $symbol . $vehicle->number;
$zone = new Axon("zonal_office");
if ($zone->found(array('zone_id=:id and wheeler=:vid', array(':id' => $zone_id, ':vid' => $wheeler))) > 0) {
$zone->load(array('zone_id=:id and wheeler=:vid', array(':id' => $zone_id, ':vid' => $wheeler)));
$photos = new Axon("owner_photo");
if ($photos->found(array('vehicle_id =:id', array(':id' => $id)))) {
$photos->load(array('vehicle_id =:id', array(':id' => $id)));
F3::set('pic', $photos);
} else {
F3::set('pic', 'no photo available');
}
F3::set('date', $nepDate);
F3::set('refer', $id);
F3::set('vehicle', $vehicleNo);
F3::set('value', $zone->name);
F3::set('navUser', 'userNav');
F3::set('template', 'feedbacktransfer');
echo Template::serve("template/layout.html");
} else {
$photos = new Axon("owner_photo");
if ($photos->found(array('vehicle_id =:id', array(':id' => $id)))) {
$photos->load(array('vehicle_id =:id', array(':id' => $id)));
F3::set('pic', $photos);
} else {
F3::set('pic', 'no photo available');
}
F3::set('date', $nepDate);
F3::set('refer', $id);
F3::set('navUser', 'userNav');
F3::set('value', 'no office available');
F3::set('template', 'feedbacktransfer');
echo Template::serve("template/layout.html");
}
}
function register_approve()
{
$username = F3::get("POST.username");
$password = F3::get("POST.password");
$fullname = F3::get("POST.fullname");
$user = new Axon('online_user');
if (!$user->found(array('username=:username', array(':username' => $username))) == 1) {
$sql[] = "INSERT into online_user (username,password,fullname) VALUES('{$username}','{$password}','{$fullname}')";
DB::SQL($sql);
F3::set('registered', 'You have been registered ,log into your account' . " " . "<a href='{{@BASE}}' style='color:red;text-decoration:none'>login</a>");
$this->register();
} else {
F3::set('userExist', 'User already exist');
$this->register();
}
}
function register_print()
{
$id = F3::get("PARAMS.id");
$vehicle = F3::get("PARAMS.id");
$data = new Axon("vehicle");
$owner = new Axon("owner");
if ($data->found(array('id=:id', array(':id' => $id))) && $owner->found(array('vehicleid =:id', array(':id' => $id)))) {
// echo 123;
$data->load(array('id=:id', array(':id' => $vehicle)));
$owner->load(array('vehicleid =:id', array(':id' => $vehicle)));
// $namsari->load(array('vehicle_id =:id', array(':id' => $vehicle)));
$zone_code = $id->zone_view($data->zone_id);
// F3::set('code', $zone_code);
$symbol_view = $id->symbol_view($data->vehicle_symbol_type);
$owner_view = $id->owner_view($owner->owner_type);
$p_zone_id = $id->zone_view($owner->p_zone_id);
$temp_zone_id = $id->zone_view($owner->temp_zone_id);
// F3::set('zone', $p_zone_id);
//$p_district_id = $id->district_view($data->p_district_id);
// $temp_district_id = $id->district_view($data->temp_district_id);
$nabalik_district = $id->district_view($data->nabalik_district);
$creditor_district = $id->district_view($data->creditor_district);
$per_district = $id->district_view($data->per_district);
$owner->copyTo("POST");
$data->copyTo("POST");
$namsari->copyTo("POST");
F3::set('date', $date);
// F3::set('nav', 'navigation');
echo Template::serve("template/admin/registration_print.htm");
}
}
function deleteForm()
{
if (!F3::get('SESSION.onlineUser')) {
F3::reroute("/");
}
$id = F3::get("PARAMS.id");
$vehicle = new Axon('vehicle');
if ($vehicle->found(array('id =:id', array(':id' => $id)))) {
$vehicle->load(array('id =:id', array(':id' => $id)));
$vehicle->erase();
F3::reroute('/');
} else {
F3::reroute('/');
}
}
function namsari($id)
{
$namsari = new Axon("namsari");
if ($namsari->found(array("vehicle_id=:id", array(":id" => $id)))) {
$namsari->load(array("vehicle_id=:id", array(":id" => $id)));
echo 123;
die;
}
}
function viewNamsari()
{
if (!F3::get('SESSION.asid')) {
F3::reroute("/admin");
}
$id = new Form_elements();
$date = DATE('Y-m-d');
$id = new Form_elements();
$owner_type = $id->owner_type();
$zone_code = $id->zone_code();
$district_code = $id->district_code();
$date = DATE('Y-m-d');
$zone_code = $id->zone_code();
$type_symbol = $id->type_symbol();
$vehicle = F3::get("PARAMS.id");
$data = new Axon("vehicle");
$owner = new Axon("owner");
$owner_photo = new Axon("owner_photo");
$namsari = new Axon("namsari");
if ($data->found(array('id=:id', array(':id' => $vehicle))) && $owner->found(array('vehicleid =:id', array(':id' => $vehicle))) && $namsari->found(array('vehicle_id=:id', array(':id' => $vehicle))) && $owner_photo->found(array('vehicle_id=:pic', array(':pic' => $vehicle)))) {
$data->load(array('id=:id', array(':id' => $vehicle)));
$owner->load(array('vehicleid =:id', array(':id' => $vehicle)));
$namsari->load(array('vehicle_id =:id', array(':id' => $vehicle)));
$owner_photo->load(array('vehicle_id=:pic', array(':pic' => $vehicle)));
$data->copyTo("POST");
$owner->copyTo("POST");
$namsari->copyTo("POST");
$owner_photo->copyTo("POST");
F3::set('heading', 'नया सवारी धनी विवरण ');
F3::set('date', $date);
F3::set('nav', 'navigation');
F3::set('title', 'Admin - approve Namsari');
F3::set('templateAdmin', 'viewNamsari');
echo Template::serve("template/layout.html");
} else {
F3::reroute("/admin/ownershipTransfer");
}
}
if ($hata = denetle(strtolower($value), array('dolu' => array(true, "{$ne} boş bırakılamaz"), 'enaz' => array(strlen($captcha), "{$ne} çok kısa"), 'degeri' => array(strtolower($captcha), "Yanlış {$ne}")))) {
F3::set('error', $hata);
return;
}
});
// ad ve soyad şart
foreach (array('ad', 'soyad') as $alan) {
F3::input($alan, function ($value) use($alan) {
$ne = ucfirst($alan);
if ($hata = denetle($value, array('dolu' => array(true, "{$ne} boş bırakılamaz"), 'enaz' => array(2, "{$ne} çok kısa"), 'enfazla' => array(127, "{$ne} çok uzun")))) {
F3::set('error', $hata);
return;
}
F3::set("REQUEST.{$alan}", ucfirst($value));
});
}
// tc numara geçerli olmalı
F3::input($alan = 'tc', function ($value) use($alan) {
$ne = "Tc No";
if ($hata = denetle($value, array('dolu' => array(true, "{$ne} boş bırakılamaz"), 'esit' => array(11, "{$ne} 11 haneli olmalıdır"), 'tamsayi' => array(true, "{$ne} sadece rakam içermeli"), 'ozel' => array(function ($value) {
return !is_tc($value);
}, "Geçerli bir {$ne} değil")))) {
F3::set('error', $hata);
return;
}
$kul = new Axon('kul');
if ($kul->found("tc={$value}")) {
F3::set('error', "{$ne} {$value} daha önceden eklendi");
return;
}
});
function reportLog()
{
if (F3::get('SESSION.asid')) {
F3::reroute("/admin");
}
$admin = new Axon("admin_log");
// $users=$admin->afind();
$date1 = F3::get("POST.date1");
$date2 = F3::get("POST.date2");
if ($users = $admin->found()) {
// var_dump($users);die;
$users = $admin->afind("date between '" . $date1 . "' and '" . $date2 . "'");
F3::set('report', $users);
F3::set('nav', 'navigation');
F3::set('title', 'Admin - Log');
F3::set('templateAdmin', 'adminLog');
echo Template::serve("template/layout.html");
} else {
$users = array();
F3::set('report', $users);
F3::set('nav', 'navigation');
F3::set('templateAdmin', 'adminLog');
echo Template::serve("template/layout.html");
}
}
