Closed comfrey closed 10 years ago
ok, so i need to get the transactions from is4c_log.dtransactions then push them to trans_archive.transArchive201401, core_log.transarchive then take core_log.transarchive and then clear the data from core_log.dlog_15 for the days in question then import the data for the days in question
INSERT INTO trans_archive.transArchive201401
(datetime
, register_no
, emp_no
, trans_no
, upc
, description
, trans_type
, trans_subtype
, trans_status
, department
, quantity
, scale
, cost
, unitPrice
, total
, regPrice
, tax
, foodstamp
, discount
, memDiscount
, discountable
, discounttype
, voided
, percentDiscount
, ItemQtty
, volDiscType
, volume
, VolSpecial
, mixMatch
, matched
, memType
, staff
, numflag
, card_no
, trans_id
) SELECT datetime
, register_no
, emp_no
, trans_no
, upc
, description
, trans_type
, trans_subtype
, trans_status
, department
, quantity
, Scale
, cost
, unitPrice
, total
, regPrice
, tax
, foodstamp
, discount
, memDiscount
, discountable
, discounttype
, voided
, percentDiscount
, ItemQtty
, volDiscType
, volume
, VolSpecial
, mixMatch
, matched
, memType
, staff
, props
, card_no
, trans_id
FROM is4c_log.dtransactions WHERE DAY(datetime)=29 OR DAY(datetime)=30
ok, so they are imported and the data looks good to me.
need to bring in wed, thurs, and fri into trans_archive and core_log
select * from trans_archive.transArchive201401 WHERE DAY(datetime)= AND register_no = 28 lane1 = 6,254 lane2 = 0 lane3 = 1,894
29 lane1 = 2,693 lane2 = 0 lane3 = 0
30 lane1 = 960 lane2 = 0 lane3 = 0
select * from trans_archive.transArchive201401 WHERE DAY(datetime)= AND register_no = 28 lane1 = 6,254 lane2 = 0 lane3 = 1,894
29 lane1 = 2,693 lane2 = 0 lane3 = 0
30 lane1 = 960 lane2 = 0 lane3 = 0
select * from is4c_log.dtransactions WHERE DAY(datetime)= AND register_no = 28 lane1 = 5,298 lane2 = 0 lane3 = 1,894
29 lane1 = 4,566 lane2 = 0 lane3 = 4,048
30 lane1 = 3,368 lane2 = 0 lane3 = 4,127
so looks like monday is good, tuesday is good, wednesday and thursday are next.