package Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet Ċ Ċ import Ġorg . apache . poi . ss . user model . Workbook Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . domain . move . Move Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . C ANCE LL ATION _ DATE Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . C ANCE LL ATION _ TIME Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . DROP _ OFF Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . LOCATION _ TYPE Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . MOVE _ DATE Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . MOVE _ ID Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . NO MIS _ PR IS ON _ ID Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . NOTES Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . P ICK _ UP Ċ import Ġuk . gov . just ice . digital . h mp ps . pec s . j pc . service . spreadsheet . Price Sheet . DataColumn . PRICE Ċ Ċ class ĠCancel led Moves Sheet ( workbook : ĠWork book , Ġheader : ĠHeader ) Ġ: ĠPrice Sheet ( ĊĠ Ġsheet Ġ= Ġworkbook . create Sheet (" Cancelled "), ĊĠ Ġheader Ġ= Ġheader , ĊĠ Ġsub heading Ġ= Ġ" CANCEL LED ĠMOV ES Ġ( includes Ġpr ison Ġto Ġpr ison Ġtransfer Ġmoves Ġthat Ġhave Ġbeen Ġcancelled Ġby Ġthe Ġpopulation Ġmanagement Ġunit Ġafter Ġ 3 pm Ġon Ġthe Ġday Ġbefore Ġthe Ġmove )", ĊĠ Ġdata Columns Ġ= ĠlistOf ( ĊĠĠĠ ĠMOVE _ ID , ĊĠĠĠ ĠP ICK _ UP , ĊĠĠĠ ĠLOC ATION _ TYPE , ĊĠĠĠ ĠDROP _ OFF , ĊĠĠĠ ĠLOC ATION _ TYPE , ĊĠĠĠ ĠMOVE _ DATE , ĊĠĠĠ ĠC ANCE LL ATION _ DATE , ĊĠĠĠ ĠC ANCE LL ATION _ TIME , ĊĠĠĠ ĠNO MIS _ PR IS ON _ ID , ĊĠĠĠ ĠPR ICE , ĊĠĠĠ ĠNOT ES ĊĠ Ġ) Ċ ) Ġ{ ĊĊĠ Ġoverride Ġfun Ġwrite Move ( move : ĠMove ) Ġ= Ġwrite Move Row ( move , Ġfalse ) ĊĊĠ Ġoverride Ġfun Ġwrite Move Row ( move : ĠMove , Ġshow Notes : ĠBoolean ) Ġ{ ĊĠĠĠ Ġval Ġrow Ġ= Ġcreate Row () ĊĠĠĠ Ġfun Ġ< T > Ġadd ( col : ĠInt , Ġvalue : ĠT ?) Ġ= Ġrow . add Cell ( col , Ġvalue , Ġfill Sh aded ) ĊĠĠĠ Ġwith ( move ) Ġ{ ĊĠĠĠĠĠ Ġadd ( 0 , Ġreference ) ĊĠĠĠĠĠ Ġadd ( 1 , Ġfrom Site Name ()) ĊĠĠĠĠĠ Ġadd ( 2 , Ġfrom Location Type ()) ĊĠĠĠĠĠ Ġadd ( 3 , Ġto Site Name ()) ĊĠĠĠĠĠ Ġadd ( 4 , Ġto Location Type ()) ĊĠĠĠĠĠ Ġadd ( 5 , Ġmove Date ()) ĊĠĠĠĠĠ Ġadd ( 6 , Ġdrop Off Or Cancelled Date ()) ĊĠĠĠĠĠ Ġadd ( 7 , Ġdrop Off Or Cancelled Time ()) ĊĠĠĠĠĠ Ġadd ( 8 , Ġperson ?. pr ison Number ) ĊĠĠĠĠĠ Ġif Ġ( has Price ()) Ġrow . add Cell ( 9 , Ġtotal In P ound s (), Ġfill Sh aded P ound ) Ġelse Ġadd ( 9 , Ġ" NOT ĠP RES ENT ") ĊĠĠĠĠĠ Ġadd ( 1 0 , Ġnotes ) ĊĠĠĠ Ġ} ĊĠ Ġ} Ċ } Ċ