JavaScript

Re: I am using javascript to convert a large table to a pdf

26-Jan-23 8:02

Congrats?

Jeremy Falcon

RickyJudith8-Feb-23 0:24

RickyJudith

8-Feb-23 0:24

interesting

I have problem importing images of Json File on HTML Table

Member 1590151922-Jan-23 2:14

Member 15901519

22-Jan-23 2:14

Hello,

I successfully loaded the json responses into an HTML table. However, I am having a problem displaying the images of the json variables. I could only display the links. Here is the output:

Home Team 	                                              Match Date 	           Away Team
https://media-3.api-sports.io/football/teams/2939.png 	2023-01-22T20:30:00+03:00 	https://media-3.api-sports.io/football/teams/2934.png
https://media-3.api-sports.io/football/teams/2938.png 	2023-01-26T21:00:00+03:00 	https://media-3.api-sports.io/football/teams/2939.png
https://media.api-sports.io/football/teams/2931.png 	2023-02-03T17:00:00+03:00 	https://media.api-sports.io/football/teams/2939.png
https://media.api-sports.io/football/teams/2937.png 	2023-02-09T19:30:00+03:00 	https://media-3.api-sports.io/football/teams/2939.png
https://media-3.api-sports.io/football/teams/2939.png 	2023-02-17T17:00:00+03:00 	https://media-3.api-sports.io/football/teams/2936.png

Here is a sample of the json file:

<pre>array (
  'api' => 
  array (
    'results' => 10,
    'fixtures' => 
    array (
      0 => 
      array (
        'fixture_id' => 932017,
        'league_id' => 4633,
        'league' => 
        array (
          'name' => 'Pro League',
          'country' => 'Saudi-Arabia',
          'logo' => 'https://media-3.api-sports.io/football/leagues/307.png',
          'flag' => 'https://media-3.api-sports.io/flags/sa.svg',
        ),
        'event_date' => '2023-01-22T20:30:00+03:00',
        'event_timestamp' => 1674408600,
        'firstHalfStart' => NULL,
        'secondHalfStart' => NULL,
        'round' => 'Regular Season - 14',
        'status' => 'Not Started',
        'statusShort' => 'NS',
        'elapsed' => 0,
        'venue' => 'Mrsool Park',
        'referee' => NULL,
        'homeTeam' => 
        array (
          'team_id' => 2939,
          'team_name' => 'Al-Nassr',
          'logo' => 'https://media.api-sports.io/football/teams/2939.png',
        ),
        'awayTeam' => 
        array (
          'team_id' => 2934,
          'team_name' => 'Al-Ettifaq',
          'logo' => 'https://media.api-sports.io/football/teams/2934.png',
        ),
        'goalsHomeTeam' => NULL,
        'goalsAwayTeam' => NULL,
        'score' => 
        array (
          'halftime' => NULL,
          'fulltime' => NULL,
          'extratime' => NULL,
          'penalty' => NULL,
        ),
      ),

And here is the code for importing the json output into the HTML table:

JavaScript

<pre><script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">

<style>
    th{ 
        color:#fff;
            }
</style>


<table class="table table-striped">
    <tr  class="bg-info">
        <th>Home Team</th>
        <th>Match Date</th>
        <th>Away Team</th>
    </tr>

    <tbody id="myTable">
        
    </tbody>
</table>

<script>
	var myArray = []
	

	$.ajax({
		method:'GET',
		url:'https://api-football-v1.p.rapidapi.com/v2/fixtures/team/2939/next/10?rapidapi-key={API-Key}',
		success:function(response){
			myArray = response
			buildTable(myArray)
			console.log(myArray)
		}
	})



	function buildTable(data){
		var table = document.getElementById('myTable')
		for (var i = 0; i < data.api.fixtures.length; i++){
		const rm = data.api.fixtures[i];

			var row = `<tr>
					   <td>${rm.homeTeam.logo}</td>
					   <td>${rm.event_date}</td>
					   <td>${rm.awayTeam.logo}</td>
					  </tr>`
			table.innerHTML += row


		}
	}

</script>

As you can see, I need to show the images of homeTeam.logo and awayTeam.logo instead of their hyperlinks. Thanks in advance

Re: I have problem importing images of Json File on HTML Table

Jeremy Falcon24-Jan-23 4:30

Re: software access control

24-Jan-23 4:30

Looks like an old codebase using PHP and jQuery. Just FYI, rather than dump all your code, perhaps start with just the relevant bits? It shows us you put some effort into this.

Anywho, that JSON object will only have a string in it. If that string is a path to an image, you'll have to output that path in its src attribute, similar to the way you're building out that table.

JavaScript

const output = `<img src="${object.path}" />`;
element.innerHTML += output;

Note: There are better ways to go about this, but I'll save that for a different day.

Jeremy Falcon

modified 24-Jan-23 13:34pm.

software access control

Member 1589900419-Jan-23 0:51

Member 15899004

19-Jan-23 0:51

hi.
we need to make software access control using device ZKTECO.
with language java.
us possible to help.
best regards

Richard Deeming19-Jan-23 1:25

Use async function to retrieve data while looping through from another function to insert objects

19-Jan-23 1:25

1) Despite the similar names, Java and JavaScript are completely different languages. You have posted this question in the JavaScript forum, despite saying you want to use Java.

2) If you want help, then you need to describe precisely what you are trying to do, show the code you have tried, and explain what the problem is and where you are stuck. Nobody here is going to do your work for you!

3) The best place to start with questions on a specific device is to ask the device manufacturer.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Member 1589206711-Jan-23 23:35

Member 15892067

11-Jan-23 23:35

Hello! I want to say that I just started working with nodejs. I used before php/laravel.

I have 2 tables, one is for posts one is for posts_actions. Every user can create a post and other users can like/comment on that post. Every action on that post (eg: like) will be stored in table posts_actions.

I'm trying to load the posts from database, loop through them to add an extra object with all the data from table posts_actions.

But at the end, when I send back the data to frontend, the data is empty, why is that and how can I solve this?

app.post("/api/loadposts", function(req, res) {
    let posts = [];
    let posts_actions = [];
    const userid = req.body.userID;

    db.query("SELECT * FROM posts ORDER BY id DESC",
    (error, result) => {
        if(error) {
            return res.status(200).send({ error: true });
        }
       
        posts = result;
    });

    for(let p; p < posts.length; p++)
    {
        db.query("SELECT * FROM posts_actions WHERE post_id = ? AND user_id = ? LIMIT 1", [posts[p].id, userid],
            (e, r) => {
                if(e) {
                    posts[p].action = [];
                }
                else if(r.length > 0) {
                    posts[p].action = r[0];
                }
                else {
                    posts[p].action = [];
                }
        });
    }

    res.status(200).send({ data: posts });
});

I know that I must use async/await/promise, I followed some topics and tried the code below, but the data I send to frontend is empty.
A little help here, what can I do to have the result I want?

async function doQuery(query, params = []) {
    function queryData(query, params) {
        return new Promise(function(resolve, reject) {
            db.query(query, params, function (err, rows, fields) {
                if (err) {
                    return reject(err);
                }
                resolve(rows);
            });
        });
    }

    queryData(query, params).then(function(v) {
        return v;
    }).catch(function(v) {
        return [];
    })

    return null;
}

async function getAllPosts(userid)
{
    try {
        let posts = await doQuery("SELECT * FROM posts ORDER BY id DESC");

        for(let p = 0; p < posts.length; p++)
        {
            let actions = await doQuery("SELECT * FROM posts_actions WHERE post_id = ? AND user_id = ? LIMIT 1", [posts[p].id, userid]);

            if(actions.length)
            {
                posts[p].actions = actions[0];
            }
            else
            {
                posts[p].actions = [];
            }
        }

        return posts;
    } catch (error) {
        return error;
    }
}

app.post("/api/loadposts", async function(req, res)
{
    let posts = await getAllPosts(req.body.userID);
    res.send({ data: posts });
});

modified 12-Jan-23 6:11am.

Re: Use async function to retrieve data while looping through from another function to insert objects

Richard Deeming12-Jan-23 0:02

Re: Use async function to retrieve data while looping through from another function to insert objects

12-Jan-23 0:02

Your doQuery function always returns null. You need to start by fixing that:

JavaScript

function doQuery(query, params = []) {
    return new Promise(function(resolve, reject) {
        db.query(query, params, function (err, rows, fields) {
            if (err) {
                reject(err);
            } else {
                resolve(rows);
            }
        });
    });
}

With that change in place, your other code should work - although you'll probably want to catch any errors thrown when you load the actions for an individual post, rather than throwing all of the posts away.

If your database supports it, you may also want to load the post actions in parallel, rather than serially:

JavaScript

async function loadPostActions(post, userid) {
    try {
        post.actions = await doQuery("SELECT * FROM posts_actions WHERE post_id = ? AND user_id = ? LIMIT 1", [post.id, userid]);
    } catch (error) {
        post.actionsError = error;
    }
}

async function getAllPosts(userid)
{
    try {
        const posts = await doQuery("SELECT * FROM posts ORDER BY id DESC");
        
        const actionPromises = [];
        for (let p = 0; p < posts.length; p++) {
            actionPromises.push(loadPostActions(posts[p], userid));
        }
        
        await Promise.all(actionPromises);
        return posts;
    } catch (error) {
        return error;
    }
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Member 1589206712-Jan-23 1:38

Member 15892067

12-Jan-23 1:38

Thank you very very much! That works perfectly!
But apparently, on postman the data I receive is good, but on frontend the action object inside data is empty and it shouldn't be.

This is what I get with postman:

{
    "data": [
        {
            "id": 2,
            "user_id": 1,
            "text": "d2222222",
            "posted_at": "1/12/2023 1:52:27 PM",
            "likes": 1,
            "comments": 0,
            "picture": "",
            "userid": 1,
            "name": "Gilbert",
            "actions": [
                {
                    "id": 1,
                    "tweet_id": 2,
                    "user_id": 1,
                    "liked": 1,
                    "retweeted": 0,
                    "replied_count": 0
                }
            ]
        }
    ]
}

And on frontend (Reactjs):

{
    "data": [
        {
            "id": 2,
            "user_id": 1,
            "text": "d2222222",
            "posted_at": "1/12/2023 1:52:27 PM",
            "likes": 1,
            "comments": 0,
            "picture": "",
            "userid": 1,
            "name": "Gilbert",
            "actions": []
        }
    ]
}

useEffect(() => {
        loadAllPosts();
    }, [])

    function loadAllPosts() {
        Axios.post('/api/loadposts', {
            userID: loginData.id
        }).then((response) => {
            console.log(response.data.data)
            setPosts(response.data.data);
        }).catch((error) => {
            console.log("Something went wrong.. We are investigating.");
        })
    }

modified 12-Jan-23 8:36am.

Re: Use async function to retrieve data while looping through from another function to insert objects

Richard Deeming12-Jan-23 2:31

Re: Use async function to retrieve data while looping through from another function to insert objects

12-Jan-23 2:31

That's odd; if it works for one, it should work for the other.

You could try loading the actions serially, in case Node has a problem with Promise.all:

JavaScript

async function getAllPosts(userid)
{
    try {
        const posts = await doQuery("SELECT * FROM posts ORDER BY id DESC");
        
        /*
        const actionPromises = [];
        for (let p = 0; p < posts.length; p++) {
            actionPromises.push(loadPostActions(posts[p], userid));
        }
        
        await Promise.all(actionPromises);
        */
        
        for (let p = 0; p < posts.length; p++) {
            await loadPostActions(posts[p], userid);
        }
        
        return posts;
    } catch (error) {
        return error;
    }
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Member 1589206712-Jan-23 3:17

Member 15892067

12-Jan-23 3:17

I solved this. I needed to put an if statment on useEffect if the user is logged (because I couldn't get his userID in the beginning to send a post request).

useEffect(() => {
        if(loginStatus === true) {
            loadAllPosts();
        }
    }, [loginStatus])

Thank you very very much @RichardDeeming for helping me out!

Btw, loading parallel in my "context" lets says, is more efficient (memory, loading time, etc) instead of serially? Or is just because using serially will throw all posts if a promise is rejected (fail)?

Re: Use async function to retrieve data while looping through from another function to insert objects

Richard Deeming12-Jan-23 3:39

Re: Use async function to retrieve data while looping through from another function to insert objects

12-Jan-23 3:39

Member 15892067 wrote:
Btw, loading parallel in my "context" lets says, is more efficient (memory, loading time, etc) instead of serially? Or is just because using serially will throw all posts if a promise is rejected (fail)?

Loading in parallel should be faster, if the database supports it. You're telling it to start loading the actions for all posts, then waiting for them all to finish, rather than waiting for it to load the actions for the first post, then waiting for it to load the actions for the second post, ...

For example, assume it took an average of 50ms to load the actions for one post, and you want to load the actions for 10 posts. Doing that serially would take around 500ms. Doing it in parallel should take around 50ms.

This article is about C#, but many of the same principals apply:
Making an Asynchronous Breakfast in .NET[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Jeremy Falcon12-Jan-23 8:44

Re: Use async function to retrieve data while looping through from another function to insert objects

12-Jan-23 8:44

Couple things to consider here. First and foremost, do not use successive round trips in an API call as your first solution. It's always a last resort. It's much quicker to doing a JOIN on you indexes to combine the data. Yes this first payload be larger, but you only need to establish the connection once and you're still using the same sized payload even if it's split up into calls. So, the proper solution is to use a query or view and return that info to the client (the client being the Express server in this instance) in one trip... you can paginate if you need to break up the payload size into several calls.

To answer your question, and I do not suggest you do that this at all, but to address it...

In your doQuery function, notice that only the reject case in returned in your closure. Not the cause of your issue, but to be consistent. Also, the function doesn't need to return an explicit promise. It's being done already under the hood. Use try/catch in your async functions to handle error conditions. The syntax is much cleaner.

JavaScript

async function doQuery(query, params = []) {
  try {
    return await new Promise((resolve, reject) => {
      db.query(query, params, (err, rows) => {
        if (err)
          reject(err);
        else
          resolve(rows);
      });
    });
  } catch {
    return [];
  }
}

If your data is still null after reworking that routine than make sure db.query is returning valid data.

Also, if you plan on making successive calls like this, you'd be much, much better off using generators . But, that is a last choice. You should be redoing your DB design and queries first.

Jeremy Falcon

Leon Scott Kennedy13-Jan-23 5:25

Leon Scott Kennedy

13-Jan-23 5:25

Now you are using SQL database with nodejs and created 2 tables to store post data.

Sometimes, SQL DB is more effective than no-SQL DBs like mongoDB but in your case, the best optimized method is using MongoDB.

By its property, mongoDB is the fittest one for your current project.

If you need to use only SQL DB, you can consider about ORM in SQL DB.

Wish your good.

Java Script

Prerna Kharbanda3-Jan-23 20:56

Prerna Kharbanda

3-Jan-23 20:56

What are the limits of HTML? Can you build anything with HTML and CSS that you can build with Java Script?

Re: Java Script

Richard MacCutchan3-Jan-23 21:33

Richard MacCutchan

3-Jan-23 21:33

Not necessarily as HTML/CSS and Javascript are totally different products.

calendar validation

Jithin P 202227-Dec-22 20:45

Jithin P 2022

27-Dec-22 20:45

how to validate date in calender 15 days before & after

Dave Kreskowiak28-Dec-22 3:59

Dave Kreskowiak

28-Dec-22 3:59

You're going to have to describe what you mean by "validate" in this context.

Like, are you using todays date and trying to get the date 15 days before that and after?

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Jithin P 202229-Dec-22 3:31

Jithin P 2022

29-Dec-22 3:31

today date

Jeremy Falcon5-Jan-23 11:13

5-Jan-23 11:13

It's been long enough, so even if this was a homework question, it was probably due already. Soooooo, here ya go. I haven't tested this, but there shouldn't be a bug. Either way, it should at least you get started.

JavaScript

const DATE_OFFSET = 1080000000; // 15 days, (24 * 60 * 60 * 1,000) * 15;

// client's timezone is being used
const someDate = Date.parse('25 Dec 2022 00:00:00');
const now = new Date();

const fifteenDaysAgo = new Date(now.getTime() - DATE_OFFSET);
const fifteenDaysFromNow = new Date(now.getTime() + DATE_OFFSET);

console.log((someDate >= fifteenDaysAgo) && (someDate <= fifteenDaysFromNow));

Jeremy Falcon

Jeremy Falcon5-Jan-23 11:17