How does your attendance report look like?

Hi Mazmur,

What is the rule of deciding "H" or "A" from your attendance data?

Hi Mazmur,

It's not a yes or no question. I'm asking you what the rule is, how do you decide "H" or "A"?

Another question, what is the type of your attendance data source, is it CSV, Excel file or database table/view? In the case of database table/view what is the type of column "Date"? Thanks!

Hi Mazmur,

I think your case could make use of the Cube process. Let me present some sample code with a mysql table which you could modify for your case depending your database:

$this->src("mysql")
->query("select employee, day(dateField) as 'day' from myTable where month(dateField) = 1")
->pipe(new \koolreport\cube\processes\Cube([
	"row" => "employee",
	"column" => "day",
	"count" => "employee"
]))
->pipe(new \koolreport\processes\RemoveColumn(["{{all}}"]))
->pipe(new \koolreport\processes\ColumnsSort([
	"{name}" => 'asc',
	"fixedColumns" => [0]
]))
->pipe(new \koolreport\processes\Map([
	"{value}" => function($row, $meta) {
		$columns = array_keys($meta["columns"]);
		foreach ($columns as $col) {
			if ($col !== "employee") {
				if ($row[$col] === 0) $row[$col] = "A";
				else if ($row[$col] > 0) $row[$col] = "H";
			}
		}
		return $row;
	},
	"{meta}" => function($meta) {
		$columns = array_keys($meta["columns"]);
		foreach ($columns as $col) {
			$meta["columns"][$col]["type"] = "string";
		}
		return $meta;
	}
]))
->pipe($this->dataStore("attendance"));

The datastore "attendance" will have attendance data for month 1. It's similar for other months. Thanks!