public function actionIndex()
{
$session = new CHttpSession();
$session->open();
$user = $session['login'];
$session->closeSession(true);
$sql = Yii::app()->db->createCommand("SELECT User.Num_bank_cart, Credit.Type_credit, Credit.Sum_credit, Credit.Proc_stavka, Credit.Srok, Credit.Type_credit, Calendar.Month_pay, Credit.Num_credit, Credit.Type_platezh, Credit.Oforml_credit_date, Calendar.Pay_sum, Calendar.P_sum, Calendar.P_proc, Calendar.Less_sum\nFROM (User INNER JOIN Credit ON User.id_user = Credit.id_user) INNER JOIN Calendar ON Credit.id_credit = Calendar.id_credit WHERE Num_bank_cart = {$user} ")->queryAll();
echo $this->render('index', array('variable' => $sql));
}
public function authenticate()
{
$userData = $this->username;
$password = $this->password;
$hashedPassword = md5($password);
//Client
$user = User::model()->find(array('condition' => "Num_bank_cart = '{$userData}'"));
$pass = User::model()->find(array('condition' => "Password = '******'"));
//Inspector
$insp = Inspector::model()->find(array('condition' => "Login = '******'"));
$inspPass = Inspector::model()->find(array('condition' => "Password = '******'"));
$client = !empty($user);
$inspLog = !empty($insp);
if ($client || $userData == 'admin' || $inspLog) {
$hashedPassword = md5($password);
if (!empty($pass) || $password == 'admin' || !empty($inspPass)) {
$session = new CHttpSession();
$session->open();
$session['login'] = $userData;
if ($client != "") {
$data = 'client';
} else {
if ($inspLog != "") {
$data = 'inspector';
} else {
$data = 'admin';
}
}
$session['data'] = $data;
$session->closeSession(true);
$this->errorCode = self::ERROR_NONE;
} else {
$this->errorCode = self::ERROR_PASSWORD_INVALID;
}
} else {
$this->errorCode = self::ERROR_USERNAME_INVALID;
}
return !$this->errorCode;
}
