title: How to display all the days in chart for the current month using Laravel
body: <p>Earlier I was working in how to display the data in the chart from the controller then to the front end itself. Now that I got it I need to display all the days in the current month in my graph since I can show the data in the graph because the current solution is not yet complete. </p>
  
  <p>I used the <code>created_at</code> column in my table to base the date and I formatted it. You can show in query..</p>
  
  <p>My query is like this</p>
  
  <pre><code>public function getGraph(){
      $ext = \DB::table('checkers')
          -&gt;where('remarks_id',2)
          -&gt;join('schedules','schedules.id','=','checkers.schedule_id')
          -&gt;join('teachers','schedules.teacher_id','=','teachers.id')
          -&gt;where('schedules.teacher_id',1)
          -&gt;count();
  
      $date = \DB::table('checkers')
          -&gt;where('remarks_id',2)
          -&gt;select(\DB::raw("COUNT(checkers.id) `value` "), \DB::raw("DATE_FORMAT(checkers.created_at, '%M %d, %Y') label "))
          -&gt;join('schedules','schedules.id','=','checkers.schedule_id')
          -&gt;join('teachers','schedules.teacher_id','=','teachers.id')
          -&gt;where('schedules.teacher_id',1)
          -&gt;groupBy('label')
          -&gt;get();        
  
      return response()-&gt;json([
          'count' =&gt; $ext,
          'date' =&gt; $date
      ]);
  }
  </code></pre>
  
  <p>My json is </p>
  
  <pre><code>{
    "count": 4,
    "date": [
      {
        "value": 1,
        "label": "January 21, 2020"
      },
      {
        "value": 3,
        "label": "January 23, 2020"
      }
    ]
  }
  </code></pre>
  
  <p>My graph is like this
  <a href="https://i.stack.imgur.com/rixWP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rixWP.png" alt="enter image description here"></a></p>
  
  <p>There are blank spaces in the graph. What I want to do is fill the graph with the dates with the current month based on my query. Is this possible? I used fusioncharts and vue by the way.</p>