Steemauto - backend improvement

GitHub1: https://github.com/mahdiyari/steemauto-backend
PR: https://github.com/mahdiyari/steemauto-backend/pull/4

GitHub2: https://github.com/mahdiyari/steemauto
PR: https://github.com/mahdiyari/steemauto/pull/32

---

Explanation:

As you know, Steemauto is written by PHP and it is hard to add more features to it!
I want to re-code Steemauto with Javascript (backend) and Angular 6 (frontend)
After re-coding Steemauto with Javascript, anyone will be able to contribute more features! Working with Javascript is easier in the Steemauto!

The backend is almost done!

---

Changes:

There were some problems (and bugs) in the backend API (this backend is not live in the production) and I just fixed all of that problems.
After developing the backend, I should test my development with Steemauto! So, I re-coded functions of curation_trail, fanbase, and schedule_post to use in the development tests then use in the production.

Also, in the coming updates, because of so many problems with steemconnect, I will change the login method in the Steemauto!
Users still will log in by steemconnect, but we will check the login information every 7 days (and not on every site refresh which causes high load on the steemconnect and sometimes requires users to login multiple times!).

---

Development:

mahdiyari/steemauto-backend:

In the MySQL SELECT EXISTS() queries, MySQL will return something like: [{someLongQuery: result(1 or 0)}]
We should select the result from that array then object:

...
let exists = await con.query(
  'SELECT EXISTS(SELECT `follower` FROM `fanbase` WHERE `fan`=? AND `follower`=?)',
  [fan, username]
)
for (let i in exists[0]) {
  exists = exists[0][i]
}
...

---

Received numbers from the post requests are in the string format ( '1212' not 1212)
I converted these variables from string to the number by Javascript Number() method:

...
weight = Number(weight)
minute = Number(minute)
enable = Number(enable)
...

---

I used to send tags of posts to the API with an array which is converted to the string by JSON.stringify()
We should convert received array-string in the server side to an array by using JSON.parse()

...
const tags = JSON.parse(req.body.tags)
...

---

mahdiyari/steemauto:

We created a main function for making post calls to the backend API and displaying result or error with notifications and reloading website.
(Since Steemauto is written by PHP, we should reload website to see changes in all variables)

function callApi(url, body){
    $('.btn').attr('disabled','true')
    const xmlhttp = new XMLHttpRequest()
    xmlhttp.onreadystatechange = function() {
        if (this.readyState == 4 && this.status == 200) {
            if (JSON.parse(this.responseText).id == 1) {
                $.notify({
                    icon: 'pe-7s-check',
                    message: JSON.parse(this.responseText).result
                },{
                    type: 'success',
                    timer: 8000
                })
                location.reload()
            } else {
                $.notify({
                    icon: 'pe-7s-attention',
                    message: JSON.parse(this.responseText).error
                },{
                    type: 'danger',
                    timer: 8000
                })
                $('.btn').removeAttr('disabled')
            }
        }
    }
    xmlhttp.open("POST", url, true)
    xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded")
    xmlhttp.send(body)

    return 1
}

---

Other functions now are simpler and some of them are even 1-2 lines!
Some examples:
Follow function:

...
function follow(user){ //follow a trail
    callApi('api/v1/dashboard/curation_trail/follow', 'trail=' + encodeURIComponent(user))
    return 1
}
...

And unfollow function:

...
function unfollow(user){ //unfollow a trail
    callApi('api/v1/dashboard/curation_trail/unfollow', 'trail=' + encodeURIComponent(user))
    return 1
}
...

---

Also, I explained enough in the commit messages or inside codes if there was anything hard to understand.

Please continue supporting Steemauto
Thanks for your great support:)

---

This post is submitted to the https://utopian.io

Regards,
2018-09-10