public function getBase()
{
$db = new DbQuery();
$sql = $db->select()->from('Current_Coordinate')->where('Device_Id = 1 or Device_Id=3');
echo '<br>Select ';
var_dump($sql->exec());
$sql = $db->select()->from('Organizations')->join('Organizations', 'Cities', 'City_Id');
echo '<br>Join ';
var_dump($sql->exec());
echo '<br>Delete ';
$sql_delete = $db->delete()->from('Cities')->where("Name_City = 'Альметьевск'");
var_dump($sql_delete->exec());
echo '<br>Insert ';
$sql_insert = $db->insert('Cities', array('Name_City'), array('Бугульма'));
var_dump($sql_insert->exec());
echo '<br>Update ';
$sql_set = $db->update('Cities', "Name_City='Альметьевск'")->where("Name_City='Бугульма'");
var_dump($sql_set->exec());
echo '<br><br>';
echo "This model";
$db = new DbQuery('mssql');
$sql = $db->select()->from('NavMessages')->order('Id ASC');
echo '<br>Select ';
var_dump($sql->exec());
echo "<br>Model memory : " . memory_get_usage() / 1000 . "<br>";
/**/
}
public function checkAuth()
{
$db = new Db();
$login = $this->session->getSesValue('login');
$pass = $this->session->getSesValue('password');
$sql = $db->select('*')->from('users')->where("login='******' AND password='******'")->exec();
if (count($sql) == 1) {
//return true;
}
return true;
}
public function checkAuth()
{
$db = new Db();
$login = $this->session->getSesValue('login');
$pass = $this->session->getSesValue('pass');
$sql = $db->select('*')->from('Authorization')->where("Login='******' AND Pass='******'");
$sql = $sql->exec();
if (count($sql) == 1) {
return true;
}
return false;
}
public function setAuth($login, $pass)
{
$config = new Config();
$this->cookie = new Cookie();
$table = $config->getVar('auth.table');
$table_log = $config->getVar('auth.login');
$table_pass = $config->getVar('auth.pass');
$db = new Db();
$sql = $db->select()->from($table)->where("{$table_log}='{$login}' and {$table_pass}='{$pass}'");
$sql = $sql->exec();
if (is_array($sql) && count($sql) == 1) {
$this->cookie->setCookie('login', $login);
$this->session->setSesValue('auth', 1);
} else {
$this->session->setSesValue('auth', 0);
}
}
