@@ -46,7 +46,7 @@ discard block |
||
| 46 | 46 | { |
| 47 | 47 | for($j = 0; $j < $rowCount; $j++) |
| 48 | 48 | { |
| 49 | - $cell = $sheat->getCellByColumnAndRow($i+2, $j+4); |
|
| 49 | + $cell = $sheat->getCellByColumnAndRow($i + 2, $j + 4); |
|
| 50 | 50 | if($cell->isInMergeRange()) |
| 51 | 51 | { |
| 52 | 52 | continue; |
@@ -113,7 +113,7 @@ discard block |
||
| 113 | 113 | $start = date_parse($str); |
| 114 | 114 | $lastShift = $shifts[$count - 1]; |
| 115 | 115 | $interval = $lastShift['endTime']->diff($shifts[0]['startTime']); |
| 116 | - $hourCount = ($interval->d*24) + $interval->h; |
|
| 116 | + $hourCount = ($interval->d * 24) + $interval->h; |
|
| 117 | 117 | $simpleHours = array(); |
| 118 | 118 | $militaryHours = array(); |
| 119 | 119 | $hour = $start['hour']; |
@@ -194,32 +194,32 @@ discard block |
||
| 194 | 194 | { |
| 195 | 195 | $i = 1; |
| 196 | 196 | $timeDiff = $originalStartTime->diff($shift['startTime']); |
| 197 | - $hoursFromStart = ($timeDiff->d*24)+$timeDiff->h; |
|
| 197 | + $hoursFromStart = ($timeDiff->d * 24) + $timeDiff->h; |
|
| 198 | 198 | $firstRow = array_search($shift['roleID'], $rows); |
| 199 | - $cell = $sheat->getCellByColumnAndRow($hoursFromStart+2, $firstRow+4); |
|
| 199 | + $cell = $sheat->getCellByColumnAndRow($hoursFromStart + 2, $firstRow + 4); |
|
| 200 | 200 | if($cell->isInMergeRange()) |
| 201 | 201 | { |
| 202 | - while($rows[$firstRow+$i] === $shift['roleID']) |
|
| 202 | + while($rows[$firstRow + $i] === $shift['roleID']) |
|
| 203 | 203 | { |
| 204 | - $cell = $sheat->getCellByColumnAndRow($hoursFromStart+2, $firstRow+4+$i); |
|
| 204 | + $cell = $sheat->getCellByColumnAndRow($hoursFromStart + 2, $firstRow + 4 + $i); |
|
| 205 | 205 | if(!$cell->isInMergeRange()) |
| 206 | 206 | { |
| 207 | 207 | break; |
| 208 | 208 | } |
| 209 | 209 | $i++; |
| 210 | 210 | } |
| 211 | - $sheat->mergeCellsByColumnAndRow($hoursFromStart+2, $firstRow+4+$i, $hoursFromStart+1+$shift['length'], $firstRow+4+$i); |
|
| 212 | - $this->setShiftNameInCell($sheat, $hoursFromStart+2, $firstRow+4+$i, $shift); |
|
| 211 | + $sheat->mergeCellsByColumnAndRow($hoursFromStart + 2, $firstRow + 4 + $i, $hoursFromStart + 1 + $shift['length'], $firstRow + 4 + $i); |
|
| 212 | + $this->setShiftNameInCell($sheat, $hoursFromStart + 2, $firstRow + 4 + $i, $shift); |
|
| 213 | 213 | } |
| 214 | 214 | else |
| 215 | 215 | { |
| 216 | - $sheat->mergeCellsByColumnAndRow($hoursFromStart+2, $firstRow+4, $hoursFromStart+1+$shift['length'], $firstRow+4); |
|
| 217 | - $this->setShiftNameInCell($sheat, $hoursFromStart+2, $firstRow+4, $shift); |
|
| 216 | + $sheat->mergeCellsByColumnAndRow($hoursFromStart + 2, $firstRow + 4, $hoursFromStart + 1 + $shift['length'], $firstRow + 4); |
|
| 217 | + $this->setShiftNameInCell($sheat, $hoursFromStart + 2, $firstRow + 4, $shift); |
|
| 218 | 218 | } |
| 219 | 219 | $shift = array_shift($shifts); |
| 220 | 220 | } |
| 221 | 221 | $rowCount = count($rows); |
| 222 | - $style = $sheat->getStyleByColumnAndRow(2, 4, 1+count($simpleHours), 3 + $rowCount); |
|
| 222 | + $style = $sheat->getStyleByColumnAndRow(2, 4, 1 + count($simpleHours), 3 + $rowCount); |
|
| 223 | 223 | $style->getBorders()->getAllBorders()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN); |
| 224 | 224 | $hourCount = count($simpleHours); |
| 225 | 225 | $this->grayOutUnused($hourCount, $rowCount, $sheat); |