javascript – Change how the data is displayed in a graph in height chart

I create graphs with high graphics, but I have trouble understanding the data for users.

I have this query that returns 5 rows for each month:
SELECT * FROM (SELECT *, Row_Number () OVER (PARTITION PER MONTH ORDER BY month ASC) AS rn
FROM (Collaborator SELECT, MONTHNAME, Month,
ROUND (SUM (TIME_TO_SEC (TIMEDIFF / 60), 2) AS Test)
FROM raddb.Table LEFT OUTER JOIN raddb.Type ON raddb.TypeType.Id = raddb.Target.task
WHERE TaskType = & # 39; 1 & # 39;
Group by MONTHNAME, ORDER BY MONTHNAME contributor, ASC test) as Q1) AS Q2
O rn <= 5 ORDER BY 1,2

Results returned:

insert the description of the image here

It brings 5 ​​lines of June and May 2.

So now, I'm creating the graph this way:

$ query = "SELECT * FROM (SELECT *, Row_Number () OVER (PARTITION PER MONTH ORDER BY month ASC) AS rn

FROM (Collaborator SELECT, MONTHNAME, Month,

ROUND (SUM (TIME_TO_SEC (TIMEDIFF / 60), 2) AS Test)

FROM raddb.Table LEFT OUTER JOIN raddb.Type ON raddb.TypeType.Id = raddb.Target.task

WHERE TaskType = & # 39; 1 & # 39;

Group by MONTHNAME, ORDER BY MONTHNAME contributor, ASC test) as Q1) AS Q2

Where rn <= 5 ORDER BY 1,2"; 

$viewer = mysqli_query($conn,$query);
$viewer = mysqli_fetch_all($viewer,MYSQLI_ASSOC);
$arrviewer  = $viewer;
$viewer =  json_encode(array_column($viewer, 'Teste'),JSON_NUMERIC_CHECK); 

$axis = '['; 
foreach($arrviewer as $key=>$ view) {
$ axis. = "# $" View['Colaborador'].
if ($ key! = count ($ arr) -1)
$ axis. = & # 39 ;;
}
$ axis. = & # 39;]& # 39 ;;

$ (function () {
var data_viewer = ;

$ (& # 39; container & # 39;) highcharts ({
board: {
renderTo: & # 39; container & # 39;
type: column & # 39;
}
title: {
text: & # 39; Positions & # 39;
}
xAxis: {
categories: 
        }
yAxis: {
title: {
text: hour in hours & # 39;
}
}
series: [{
            name: 'Posicionamentos',
            data: data_viewer
        }]
    });
});

The result is as follows:

insert the description of the image here

In the text box, only the month and time of positioning perished and wanted the collaborator's name to appear as well.

In the XAXIS he wanted the five lines returned to appear each month instead of repeating the same month several times.

information architecture – Are the tabs and / or steps of an assistant displayed as separate areas in a sitemap diagram?

I create a sitemap for a business application.

For a section of the application, there is a calendar editing feature. Once clicked, there are three sections / or different types of calendars to configure.

  1. Start / end dates for the entire project
  2. Blocked dates (public holidays, etc.)
  3. Start / end dates for specific tasks within the project

We are currently using a step-by-step wizard to modify the calendar. The user must therefore define the dates in this order.

In my sitemap, do I map each step as a separate area or would it be in a separate user flow diagram?

Sitemap

php – Data is not displayed in the Laravel 5.8 form field

In the create.blade view, I have a field in which the data must be displayed to be selected and not displayed. This data has already been entered in another section of the corresponding database table.

The other fields display the data correctly but in Surplus, they do not appear. In addition, the Surplus field is connected to the stock because they come from the same table in the database, that is, when a surplus is selected, the inventory of the surplus must be automatically loaded. obviously I could not check it because of the problem described above.

Here I leave a picture:

enter the description of the image here
Here, I leave the create function of the controller:

public function create ()
{

$ surplus = DB :: table ('surplus' as ex)
-> join (& # 39; detailrea as drea & # 39; ex.idexcedente, & # 39; = & # 39 ;, & dquo; drea.idexcedente & # 39;)
-> join (& # 39; provider_secure as pre & # 39; address_ender & # 39; = & # 39 ;, & # 39; pre.ender & # 39;)
-> select (ex.idexcedente, "ex.number", ex.stock, & # 39; pre.number & quot;)
-> where (& # 39; ex.condicion), & # 39; = & # 39;, & # 39; 1 & # 39;)
-> where (ex.stock, & # 39;> & # 39;, & # 39; 0 & # 39;)
-> get ();

$ patientsm = DB :: table (& # 39; pmedicamentos & # 39;) -> get ();

$ lender = DB :: table (& # 39; lender_secure & # 39;) -> get ();

$ request_type = DB :: table (& # 39; request_type) -> get ();

return the view ("reaffectations.create", [
            "excedentes"=>$excedentes,
            "pacientesm"=>$pacientesm,
            "prestador"=>$prestador,
            "tiposolicitud"=>$tiposolicitud

        ])
}

And here is the field corresponding to surplus in the create.blade view: