submissions.sp

dashboard "Submissions" {

  tags = {
    service = "Hacker News"
  }

  container {
    
    text {
      width = 6
      value = <<EOT
[Home](http://${local.host}:9194/hackernews.dashboard.Home)
🞄
[People](http://${local.host}:9194/hackernews.dashboard.People)
🞄
[Posts](http://${local.host}:9194/hackernews.dashboard.Posts)
🞄
[Repos](http://${local.host}:9194/hackernews.dashboard.Repos)
🞄
[Search](http://${local.host}:9194/hackernews.dashboard.Search)
🞄
[Sources](http://${local.host}:9194/hackernews.dashboard.Sources)
🞄
Submissions
🞄
[Urls](http://${local.host}:9194/hackernews.dashboard.Urls)
      EOT
    }

  }


  container {
    width = 8

    input "hn_user" {
      width = 6
      placeholder = "search or choose user"
      title = "hn user"
      type = "select"
      sql = <<EOQ
        select distinct
          h.by as label,
          h.by as value
        from
          hn_items_all h
        order by
          by
      EOQ    
    }

  }

  container {

    table  {
      width = 8
      args = [
        self.input.hn_user.value
      ]
      query = query.submission_times
      column "id" {
        href = "https://news.ycombinator.com/item?id={{.'id'}}"
      }
    }
  
    chart  {
      width = 4
      type = "bar"
      args = [
        self.input.hn_user.value
      ]
      axes {
        x {
          title {
            value = "submissions"
          }
        }
        y {
          title {
            value = "day"
          }
        }
      }
      query = query.submission_days
    }

  }
 

}