public function yearInvDetails() { $dbConn = new DBConnection(); $i = new dbHandler($dbConn, 'inv_details'); $sql = "SELECT YEAR(date) as Year FROM `inv_details` group by YEAR(date)"; $yeardetails = $i->getBySQLrekap($sql); return $yeardetails; }