| | |
| | | [* |
| | | // 甄兰鸽 May-29-2024 (created) |
| | | for( startTime := starttime; startTime < endtime; startTime := startTime.StartOfNextWeek() ){ |
| | | time := startTime.Format( 'M/D/Y' ); |
| | | time := startTime; |
| | | if( starttime = startTime ){ |
| | | time := startTime.StartOfWeek().Format( 'M/D/Y' ); |
| | | time := startTime.StartOfWeek(); |
| | | } |
| | | column := selectobject( table, LibCal_SubscriberEventColumn, column, column.Name() = time ); |
| | | column := selectobject( table, LibCal_SubscriberEventColumn, column, column.Name() = time.Format( 'M/D/Y' ) ); |
| | | if( isnull( column ) ){ |
| | | column := table.LibCal_SubscriberEventColumn( relnew, Name := time ); |
| | | column := table.LibCal_SubscriberEventColumn( relnew, Name := time.Format( 'M/D/Y' ), Period := time.Date() ); |
| | | } |
| | | |
| | | duration := startTime.StartOfNextWeek() - startTime; |
| | | if( startTime.StartOfNextWeek() > endtime ){ |
| | | duration := endtime - startTime; |
| | | } |
| | | info( startTime, column.Name(), duration.AsQUILL(), duration.HoursAsReal() ); |
| | | // info( startTime, column.Name(), duration.AsQUILL(), duration.HoursAsReal() ); |
| | | cell := column.LibCal_SubscriberEventCell( relnew, Value := [String]duration.HoursAsReal() ); |
| | | row.LibCal_SubscriberEventCell( relinsert, cell ); |
| | | } |