/**
* Metodo CheckUserSorteio
*
* @access public
* @param integer $user_id
* @param integer $sorteio_id
* @return integer
*/
public function CheckUserSorteio($user_id, $sorteio_id)
{
$session = new Session();
$session->StartSession();
$user = new User();
if (!$user->CheckLogin($session->data)) {
echo "<script>document.location.href='" . DIR_DOCS . "logout/'</script>";
}
$querys = new Querys();
$sql = "SELECT \n *\n FROM \n " . $this->tabela . "\n WHERE \n par_sorteios_id = '" . (int) $sorteio_id . "' AND\n par_accounts_id = '" . (int) $user_id . "'";
$query = $querys->query($sql);
return $query->num_rows;
}
/**
* Metodo CheckGanhador
*
* @access public
* @param integer $sorteio_id
* @return integer
*/
public function CheckGanhador($sorteio_id)
{
$session = new Session();
$session->StartSession();
$user = new User();
if (!$user->CheckLogin($session->data)) {
echo "<script>document.location.href='" . DIR_DOCS . "logout/'</script>";
}
$querys = new Querys();
$sql = "SELECT \n g.*,\n a.act_account_nome,\n a.act_accounts_id,\n a.act_account_sobrenome\n FROM \n " . $this->tabela . " g\n LEFT JOIN\n " . $this->tabela_accounts . " a ON (a.act_accounts_id = g.gan_accounts_id)\n WHERE \n g.gan_sorteios_id = '" . (int) $sorteio_id . "'";
$query = $querys->query($sql);
if ($query->num_rows > 0) {
return $query->row;
} else {
return $query->num_rows;
}
}
define('DIR_DOCS', DIR_BASE . 'docs/');
include 'Session.php';
include 'User.php';
include 'Querys.php';
include 'Sorteios.php';
include 'Participantes.php';
include 'Ganhadores.php';
include 'Checkout.php';
include 'Vendas.php';
include 'Cadastros.php';
include 'ProdutosInfo.php';
$querys = new Querys();
// Inicia Classe Querys
$session = new Session();
// Inicia Classe Session
$session->StartSession();
// Inicia SESSION
$user = new User();
// Inicia Classe User
$sorteios = new Sorteios();
$participantes = new Participantes();
$ganhadores = new Ganhadores();
$produtos_info = new ProdutosInfo();
$vendas = new Vendas();
if (!isset($session->data['user']['user_login']) and !isset($session->data['user']['user_cpf'])) {
$session->Destroy('user');
} else {
$user->CheckLogin($session->data);
if ($user->isLoggedUser()) {
if ($user->isConfirmed() == '0') {
$S_NotConfirmed = true;
/**
* Metodo UpdateCredit
*
* @access public
* @param int $act_accounts_id
* @param int $cnt_credit
* @return array
*/
public function UpdateCredit($act_accounts_id, $cnt_credit)
{
$session = new Session();
$session->StartSession();
$querys = new Querys();
$sql = "UPDATE \n " . $this->tabela_credit . " \n SET \n act_account_credit = '" . (int) $cnt_credit . "'\n WHERE \n act_accounts_id = '" . (int) $act_accounts_id . "'";
$query = $querys->query($sql);
return $query;
}
/**
* Metodo ConfirmSorteio
*
* @access public
* @param array $data
* @return array
*/
public function ConfirmSorteio($registro_id)
{
$session = new Session();
$session->StartSession();
$user = new User();
if (!$user->CheckLogin($session->data)) {
echo "<script>document.location.href='" . DIR_DOCS . "logout/'</script>";
}
$querys = new Querys();
$sql = "UPDATE \n " . $this->tabela . " \n SET \n sor_sorteio_status = '1'\n WHERE \n sor_sorteios_id = '" . (int) $registro_id . "'";
$query = $querys->query($sql);
return $query;
}
/**
* Metodo login logoutUser
*
* @access public
* @return void
*/
public function logoutUser()
{
$session = new Session();
$session->StartSession();
$session->Destroy('user');
$this->act_accounts_id = '';
$this->act_account_nome = '';
$this->act_account_cpf = '';
$this->act_account_email = '';
session_destroy();
}
/**
* Metodo UpdateEntregue
*
* @access public
* @param string $vnd_transaction_id
* @return array
*/
public function UpdateEntregue($vnd_transaction_id)
{
$session = new Session();
$session->StartSession();
$user = new User();
$querys = new Querys();
$sql = "UPDATE \n " . $this->tabela . " \n SET \n vnd_venda_entregue = '1'\n WHERE \n vnd_transaction_id = '" . $vnd_transaction_id . "'";
$query = $querys->query($sql);
return $query;
}
