public function check_transaction($data)
{
$db = new db_core();
$where['token_transaccion'] = $data->token;
$where['preconfirmado'] = 1;
$where['confirmado'] = 1;
$where['estado'] = 1;
$consulta = $db->reg_one("SELECT * FROM inversion_proyecto WHERE token_transaccion='" . $data->token . "'");
if ($db->isExists_multi('inversion_proyecto', $where)) {
$mail = new email();
$correo = $db->reg_one("SELECT email,nombre FROM session_log INNER JOIN users ON session_log.id_user=users.id_user WHERE session_log.token='" . $_SESSION['token_user'] . "'");
$mail->mail_inversion($correo[0], $correo[1]);
$this->returnData(array("status" => 0, "id" => $consulta['id_proyecto']));
} else {
$whe['token_transaccion'] = $data->token;
$whe['preconfirmado'] = 2;
$whe['confirmado'] = 2;
if ($db->isExists_multi('inversion_proyecto', $whe)) {
$this->returnData(array("status" => 1));
} else {
$whe['token_transaccion'] = $data->token;
if (!$db->isExists_multi('inversion_proyecto', $whe)) {
$this->returnData(array("status" => 2, "id" => $consulta['id_proyecto']));
}
}
}
}
public function add_bank($opt)
{
$dbo = new db_core();
$valores['id_user'] = $this->get_user($_SESSION['token_user']);
$valores['numero_cuenta_banco'] = $opt->numero;
$valores['banco'] = $this->get_banco($opt->banco);
$valores['tipo_de_cuenta'] = $opt->tipo;
if (!$dbo->isExists_multi('cuentas_bancarias', $valores)) {
$dbo->insert('cuentas_bancarias', $valores);
$listado = array();
$bancos[0] = $dbo->db_query("SELECT * FROM cuentas_bancarias WHERE id_user='******'id_user'] . "'");
while ($bancos[1] = mysql_fetch_array($bancos[0])) {
$total = $dbo->num_one("SELECT * FROM inversion_proyecto WHERE id_cuenta_bancaria='" . $bancos[1]['id_cuenta'] . "'");
$item['id_bank'] = $bancos[1]['id_cuenta'];
$item['name'] = utf8_encode($bancos[1]['banco'] . " - Cta: " . $bancos[1]['numero_cuenta_banco'] . " (" . $total . " Invesiones activas)");
$listado[] = (object) $item;
}
$this->returnData(array("status" => 0, "data" => json_encode($listado)));
} else {
$this->returnData(array("status" => 1));
}
}
public function is_complete_acount()
{
$db = new db_core();
$where['id_user'] = $this->get_user($_SESSION['token_user']);
$where['complete'] = 1;
$datos = $db->reg_one("SELECT * FROM session_log INNER JOIN users ON session_log.id_user=users.id_user WHERE session_log.token='" . $_SESSION['token_user'] . "'");
if (!$db->isExists_multi('users', $where)) {
$this->returnData(array("status" => 0, "name" => $datos['nombre']));
} else {
$this->returnData(array("status" => 1));
}
}
