i have a table record like this
| empid | empname | attdate | intime | outtime |
| 1 | a | 03-01-17 | 08:45 | 18:00 |
| 1 | a | 03-02-17 | 08:40 | 18:10 |
| 2 | b | 03-01-17 | 08:47 | 18:10 |
| 3 | c | 03-01-17 | 08:50 | 18:05 |
my expected result is for a month
| empid | empname | day 1 | day 2 | day 3 |
| 1 | a | p | p | a |
| 2 | b | p | a | a |
| 3 | c | p | a | a |
| 4 | d | | | |