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)); } }