function test()
{
echo $_SERVER['SERVER_PORT'];
$user = new Axon('tbl_user');
$user->load(array("id=:id", array(":id" => 1537994726)));
$this->set('SESSION.user', $user);
$this->set('SESSION.sid', Snippets::_getRN());
}
function toggleActive()
{
$id = F3::get("PARAMS.id");
$user = new Axon('tbl_user');
$user->load(array("id=:id", array(":id" => $id)));
$user->active = $user->active == 'y' ? 'n' : 'y';
$user->save();
F3::reroute('/admin/user');
}
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 login()
{
$user = new Axon('online_user');
$username = F3::get("POST.username");
$password = F3::get("POST.password");
if ($user->found(array('username=:username and password=:password', array(':username' => $username, ':password' => $password))) == 1) {
$user->load(array('username=:username and password=:password', array(':username' => $username, ':password' => $password)));
F3::set("SESSION.onlineUser", $user->username);
F3::reroute('/user/home');
} else {
F3::set('error', 'Username or password entered is wrong !!!');
F3::set('navUser', 'userNav');
F3::set('template', 'user_login');
echo Template::serve("template/layout.html");
}
}
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);
}
/**
Authenticate against SQL database;
AUTH global array elements:
db:<SQL-database> (default:'DB'),
table:<table-name>,
id:<userID-field>,
pw:<password-field>
@return mixed
@param $id string
@param $pw string
@public
**/
static function sql($id, $pw)
{
$auth = self::$vars['AUTH'];
foreach (array('table', 'id', 'pw') as $param) {
if (!isset($auth[$param])) {
trigger_error(self::TEXT_AuthSetup);
return FALSE;
}
}
if (!isset($auth['db'])) {
$auth['db'] = self::ref('DB');
}
$axon = new Axon($auth['table'], $auth['db']);
$axon->load('{{@AUTH.id}}="' . $id . '" AND {{@AUTH.pw}}="' . $pw . '"');
return $axon->dry() ? FALSE : $axon;
}
/**
Authenticate against SQL database;
AUTH global array elements:
db:<database-id> (default:'DB'),
table:<table-name>,
id:<userID-field>,
pw:<password-field>
@return mixed
@param $id string
@param $pw string
@public
**/
static function sql($id, $pw)
{
$auth =& self::$vars['AUTH'];
foreach (array('table', 'id', 'pw') as $param) {
if (!isset($auth[$param])) {
trigger_error(self::TEXT_AuthSetup);
return FALSE;
}
}
if (!isset($auth['db'])) {
$auth['db'] = self::ref('DB');
}
$axon = new Axon($auth['table'], self::ref('AUTH.db'));
$axon->load(array(self::ref('AUTH.id') . '=:id AND ' . self::ref('AUTH.pw') . '=:pw', array(':id' => $id, ':pw' => $pw)));
return $axon->dry() ? FALSE : $axon;
}
static function getSymbolType($id)
{
$zone = new Axon("type_symbol");
$zone->load(array("id=:id", array(":id" => $id)));
return $zone->name;
}
<?php
// Reset previous error message, if any
F3::clear('message');
// Form field validation
F3::call(':common');
if (!F3::exists('message')) {
// No input errors; update record
$blog = new Axon('kul');
$blog->load('tc="{@PARAMS.tc}"');
$blog->copyFrom('REQUEST');
$blog->save();
// Return to home page
F3::reroute('/');
}
// Display the blog form again
F3::call(':editkul');
$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;
}
});
F3::input($alan = 'kizliksoyad', function ($value) use($alan) {
$ne = "Kızlık Soyadı";
if ($hata = denetle($value, array('dolu' => array(true, "{$ne} boş bırakılamaz")))) {
F3::set('error', $hata);
return;
}
});
if (!F3::exists('error')) {
$tc = F3::get('REQUEST.tc');
$kizliksoyad = F3::get('REQUEST.kizliksoyad');
$kul = new Axon('kul');
$kul->load("tc={$tc}");
if (!$kul->dry() && streq_turkish($kul->kizliksoyad, $kizliksoyad)) {
// tc no'yu oturuma gömelim ve oradan alalım
F3::set('SESSION.sorgutc', $tc);
F3::set('SESSION.sorgukizliksoyad', $kizliksoyad);
return F3::call(':sorguok');
}
F3::set('error', "Girdiğiniz bilgilere uygun bir kayıt bulunamadı. Lütfen verdiğiniz bilgileri kontrol edin.");
}
// hata var, dön başa ve tekrar sorgu al.
// error alanı dolu ve layout.htm'de görüntülenecek
F3::call(':sorgual');
if (isset($_SESSION['message'])) {
F3::set('message', $_SESSION['message']);
F3::set('extra_js', array('bootstrap-alert.js'));
unset($_SESSION['message']);
}
F3::set('extra_css', array('settings.css'));
echo Template::serve('templates/header.html');
F3::set('page', 'general_settings');
echo Template::serve('templates/settings.html');
echo Template::serve('templates/footer.html');
die;
});
F3::route('POST /settings/save', function () {
$facebook = F3::get('Facebook');
$uid = $facebook->getUser();
if (!$uid) {
_force_logout();
}
$user = new Axon('user');
$user->load(array('fb_id=:fb_id', array(':fb_id' => $uid)));
if ($user->dry()) {
_force_logout();
}
$email_opt = F3::get('POST.email_opt') == 'on' ? TRUE : False;
$user->email_opt = $email_opt;
$user->save();
$_SESSION['message'] = _create_alert_message('alert-success', 'Settings updated successfully!');
F3::reroute('/settings/');
});
/****************************************************************************/
F3::run();
<?php
if (F3::get('SESSION.user')) {
$kul = new Axon('kul');
// Delete record from database
$kul->load('tc="{@PARAMS.tc}"');
$kul->erase();
// Return to home page
F3::reroute('/');
} else {
// Render blog.htm template
F3::set('pagetitle', 'Kullanıcıyı sil');
F3::set('template', 'kul');
F3::call('render');
}
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");
}
}
/**
Custom session handler
@param $table string
@public
**/
function session($table = 'sessions')
{
$self = $this;
session_set_save_handler(function ($path, $name) use($self, $table) {
// Support these engines
$cmd = array('sqlite2?' => 'SELECT name FROM sqlite_master ' . 'WHERE type=\'table\' AND name=\'' . $table . '\';', 'mysql|mssql|sybase|dblib|pgsql' => 'SELECT table_name FROM information_schema.tables ' . 'WHERE ' . (preg_match('/pgsql/', $self->backend) ? 'table_catalog' : 'table_schema') . '=\'' . $self->dbname . '\' AND ' . 'table_name=\'' . $table . '\'');
foreach ($cmd as $backend => $val) {
if (preg_match('/' . $backend . '/', $self->backend)) {
break;
}
}
$result = $self->exec($val, NULL);
if (!$result) {
// Create SQL table
$self->exec('CREATE TABLE ' . (preg_match('/sqlite2?/', $self->backend) ? '' : $self->dbname . '.') . $table . ' (' . 'id VARCHAR(40),' . 'data LONGTEXT,' . 'stamp INTEGER' . ');');
}
register_shutdown_function('session_commit');
return TRUE;
}, function () {
return TRUE;
}, function ($id) use($table) {
$axon = new Axon($table);
$axon->load(array('id=:id', array(':id' => $id)));
return $axon->dry() ? FALSE : $axon->data;
}, function ($id, $data) use($table) {
$axon = new Axon($table);
$axon->load(array('id=:id', array(':id' => $id)));
$axon->id = $id;
$axon->data = $data;
$axon->stamp = time();
$axon->save();
return TRUE;
}, function ($id) use($table) {
$axon = new Axon($table);
$axon->erase(array('id=:id', array(':id' => $id)));
return TRUE;
}, function ($max) use($table) {
$axon = new Axon($table);
$axon->erase('stamp+' . $max . '<' . time());
return TRUE;
});
}
function dismissNamsari()
{
if (!F3::get('SESSION.asid')) {
F3::reroute("/admin");
}
$id = F3::get("PARAMS.id");
$vrs = new Axon("vehicle");
$vrs->load(array("id=:id", array(":id" => $id)));
$zone = Admin::getZone($vrs->zone_id);
$symbol = Admin::getSymbolType($vrs->vehicle_symbol_type);
$vehicleNo = $zone . $vrs->lot_number . $symbol . $vrs->number;
AdminLog::add($vehicleNo, $vrs->form_type, "dismissed");
$vrs->erase();
F3::reroute("/admin/ownershipTransfer/s");
}
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 symbol_view($id)
{
$symbol = new Axon('type_symbol');
$symbol->load(array('id=:id', array(':id' => $id)));
F3::set('symbol', $symbol->name);
// F3::set('zonecode',$color->code);
}
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;
}
}
