RizkiHerdaID

# Jira Helper Configuration

# Your Jira instance URL (e.g., https://yourcompany.atlassian.net)
JIRA_BASE_URL=

# Your Jira email address
JIRA_EMAIL=
JIRA_USER_EMAIL=

# Your Jira API token (generate from: https://id.atlassian.com/manage-profile/security/api-tokens)

RizkiHerdaID

	public function index() {
      $all_categories = $this->categories->get_many_by(array('CHARACTER_LENGTH(kode_kategori) <= 2'));
      $categories = $this->get_level_0($all_categories);
	}
  
	public function get_level_0($parent) {
		$results = $this->kategori_m->get_many_by(array('status' => 1)); //capture the query data inside $results variable
		$menu = array();
		foreach ($parent as $list) {

RizkiHerdaID

SELECT * 
FROM tableA 
WHERE YEAR(columnName) = YEAR(CURRENT_DATE()) AND 
      MONTH(columnName) = MONTH(CURRENT_DATE());