Location: PHPKode > projects > Time Recording System > log.txt
<?xml version="1.0" encoding="UTF-8"?>
<FORM FINAL="false" WEEKENDINGDATE="18/05/2007" RESOLUTION="0.5" STARTTIME="09:00" STOPTIME="17:30" SHOWWEEKEND="false" REFID="1">
	<STRUCT INVOICECODE="DBMAN" TASKCODE="N/A" TASKNAME="" COLOUR="rgb(255, 0, 51)">
		<CHILDNODE  DATE="17/05/2007" RATETYPE="basicRate" RATEVALUE="basicRate" HOURS="4">
			<ENTRY ID="Thursday-15-30"/>
			<ENTRY ID="Thursday-14-00"/>
			<ENTRY ID="Thursday-13-30"/>
			<ENTRY ID="Thursday-13-00"/>
			<ENTRY ID="Thursday-12-30"/>
			<ENTRY ID="Thursday-12-00"/>
			<ENTRY ID="Thursday-11-30"/>
			<ENTRY ID="Thursday-11-00"/>
		</CHILDNODE>
	</STRUCT>
	<STRUCT INVOICECODE="FINDS" TASKCODE="SRCH" TASKNAME="" COLOUR="rgb(255, 255, 51)">
		<CHILDNODE  DATE="18/05/2007" RATETYPE="basicRate" RATEVALUE="basicRate" HOURS="3.5">
			<ENTRY ID="Friday-13-30"/>
			<ENTRY ID="Friday-13-00"/>
			<ENTRY ID="Friday-12-30"/>
			<ENTRY ID="Friday-12-00"/>
			<ENTRY ID="Friday-11-30"/>
			<ENTRY ID="Friday-11-00"/>
			<ENTRY ID="Friday-10-30"/>
		</CHILDNODE>
	</STRUCT>
</FORM>
'<?xml version="1.0" encoding="UTF-8"?>
<RESPONSE>
	<STATUS>saved</STATUS>
	<REFID>1</REFID>
</RESPONSE>
'DELETE FROM tbl_office_time_sheet_entry_details WHERE officetimesheetentryrefid IN (SELECT refid FROM tbl_office_time_sheet_entry WHERE officetimesheetrefid = 1)  - 1
DELETE FROM tbl_office_time_sheet_entry WHERE officetimesheetrefid = 1 - 1
UPDATE tbl_office_time_sheet SET submitted = false, starttime = '09:00', stoptime = '17:30' WHERE refid = 1 - 1
INSERT INTO tbl_office_time_sheet_entry (refid,invoicecoderefid,taskcoderefid,officetimesheetrefid,colour) VALUES (1,'DBMAN','N/A',1,'rgb(255, 0, 51)')
INSERT INTO tbl_office_time_sheet_entry_details (refid,dateworked,officetimesheetentryrefid,ratetype,hours,ratevalue,identities) VALUES (1,'05/17/2007',1,'basicRate',4,'basicRate','{"Thursday-15-30","Thursday-14-00","Thursday-13-30","Thursday-13-00","Thursday-12-30","Thursday-12-00","Thursday-11-30","Thursday-11-00"}')
INSERT INTO tbl_office_time_sheet_entry (refid,invoicecoderefid,taskcoderefid,officetimesheetrefid,colour) VALUES (2,'FINDS','SRCH',1,'rgb(255, 255, 51)')
INSERT INTO tbl_office_time_sheet_entry_details (refid,dateworked,officetimesheetentryrefid,ratetype,hours,ratevalue,identities) VALUES (2,'05/18/2007',2,'basicRate',3.5,'basicRate','{"Friday-13-30","Friday-13-00","Friday-12-30","Friday-12-00","Friday-11-30","Friday-11-00","Friday-10-30"}')
Return current item: Time Recording System