| 29 | {{{ |
| 30 | create new table: tsmc |
| 31 | Put data :"GunLong" to Table: tsmc's Detail:Name |
| 32 | Put data :"01" to Table: tsmc's Detail:Locate |
| 33 | Put data :"20" to Table: tsmc's Products:P1 |
| 34 | Put data :"40" to Table: tsmc's Products:P2 |
| 35 | Put data :"30" to Table: tsmc's Products:P3 |
| 36 | Put data :"50" to Table: tsmc's Products:P4 |
| 37 | |
| 38 | Put data :"Esing" to Table: tsmc's Detail:Name |
| 39 | Put data :"02" to Table: tsmc's Detail:Locate |
| 40 | Put data :"50" to Table: tsmc's Products:P1 |
| 41 | |
| 42 | Put data :"SunDon" to Table: tsmc's Detail:Name |
| 43 | Put data :"03" to Table: tsmc's Detail:Locate |
| 44 | Put data :"40" to Table: tsmc's Products:P1 |
| 45 | Put data :"30" to Table: tsmc's Products:P2 |
| 46 | |
| 47 | Put data :"StarBucks" to Table: tsmc's Detail:Name |
| 48 | Put data :"04" to Table: tsmc's Detail:Locate |
| 49 | Put data :"50" to Table: tsmc's Products:P1 |
| 50 | Put data :"50" to Table: tsmc's Products:P2 |
| 51 | Put data :"20" to Table: tsmc's Products:P3 |
| 52 | |
| 53 | }}} |
| 54 | |
| 55 | == 2 計算單月每個品項的購買次數 == |
| 59 | {{{ |
| 60 | > scan 'tsmc' |
| 61 | ROW COLUMN+CELL |
| 62 | T01 column=Detail:Locate, timestamp=1265184360616, value=01 |
| 63 | T01 column=Detail:Name, timestamp=1265184360548, value=GunLong |
| 64 | T01 column=Products:P1, timestamp=1265184360694, value=20 |
| 65 | T01 column=Products:P2, timestamp=1265184360758, value=40 |
| 66 | T01 column=Products:P3, timestamp=1265184360815, value=30 |
| 67 | T01 column=Products:P4, timestamp=1265184360866, value=50 |
| 68 | T01 column=Turnover:P1, timestamp=1265187021528, value=1 |
| 69 | T01 column=Turnover:P2, timestamp=1265187021528, value=1 |
| 70 | T01 column=Turnover:P3, timestamp=1265187021528, value=1 |
| 71 | T01 column=Turnover:P4, timestamp=1265187021528, value=1 |
| 72 | T02 column=Detail:Locate, timestamp=1265184360951, value=02 |
| 73 | T02 column=Detail:Name, timestamp=1265184360910, value=Esing |
| 74 | T02 column=Products:P1, timestamp=1265184361051, value=50 |
| 75 | T02 column=Turnover:P1, timestamp=1265187021528, value=2 |
| 76 | T03 column=Detail:Locate, timestamp=1265184361124, value=03 |
| 77 | T03 column=Detail:Name, timestamp=1265184361098, value=SunDon |
| 78 | T03 column=Products:P1, timestamp=1265184361189, value=40 |
| 79 | T03 column=Products:P2, timestamp=1265184361259, value=30 |
| 80 | T03 column=Turnover:P1, timestamp=1265187021529, value=3 |
| 81 | T04 column=Detail:Locate, timestamp=1265184361311, value=04 |
| 82 | T04 column=Detail:Name, timestamp=1265184361287, value=StarBucks |
| 83 | T04 column=Products:P1, timestamp=1265184361343, value=50 |
| 84 | T04 column=Products:P2, timestamp=1265184361386, value=50 |
| 85 | T04 column=Products:P3, timestamp=1265184361422, value=20 |
| 86 | T04 column=Turnover:P1, timestamp=1265187021529, value=2 |
| 87 | T04 column=Turnover:P2, timestamp=1265187021529, value=1 |
| 88 | T04 column=Turnover:P3, timestamp=1265187021529, value=1 |
| 89 | 4 row(s) in 0.0310 seconds |
| 90 | |
| 91 | }}} |
| 92 | |
| 93 | == 3. 計算當天營業額 == |
| 94 | |
| 97 | {{{ |
| 98 | > scan ‘tsmc’ |
| 99 | ROW COLUMN+CELL |
| 100 | T01 column=Detail:Locate, timestamp=1265184360616, value=01 |
| 101 | T01 column=Detail:Name, timestamp=1265184360548, value=GunLong |
| 102 | T01 column=Products:P1, timestamp=1265184360694, value=20 |
| 103 | T01 column=Products:P2, timestamp=1265184360758, value=40 |
| 104 | T01 column=Products:P3, timestamp=1265184360815, value=30 |
| 105 | T01 column=Products:P4, timestamp=1265184360866, value=50 |
| 106 | T01 column=Turnover:P1, timestamp=1265187021528, value=1 |
| 107 | T01 column=Turnover:P2, timestamp=1265187021528, value=1 |
| 108 | T01 column=Turnover:P3, timestamp=1265187021528, value=1 |
| 109 | T01 column=Turnover:P4, timestamp=1265187021528, value=1 |
| 110 | T01 column=Turnover:sum, timestamp=1265190421993, value=140 |
| 111 | T02 column=Detail:Locate, timestamp=1265184360951, value=02 |
| 112 | T02 column=Detail:Name, timestamp=1265184360910, value=Esing |
| 113 | T02 column=Products:P1, timestamp=1265184361051, value=50 |
| 114 | T02 column=Turnover:P1, timestamp=1265187021528, value=2 |
| 115 | T02 column=Turnover:sum, timestamp=1265190421993, value=100 |
| 116 | T03 column=Detail:Locate, timestamp=1265184361124, value=03 |
| 117 | T03 column=Detail:Name, timestamp=1265184361098, value=SunDon |
| 118 | T03 column=Products:P1, timestamp=1265184361189, value=40 |
| 119 | T03 column=Products:P2, timestamp=1265184361259, value=30 |
| 120 | T03 column=Turnover:P1, timestamp=1265187021529, value=3 |
| 121 | T03 column=Turnover:sum, timestamp=1265190421993, value=120 |
| 122 | T04 column=Detail:Locate, timestamp=1265184361311, value=04 |
| 123 | T04 column=Detail:Name, timestamp=1265184361287, value=StarBucks |
| 124 | T04 column=Products:P1, timestamp=1265184361343, value=50 |
| 125 | T04 column=Products:P2, timestamp=1265184361386, value=50 |
| 126 | T04 column=Products:P3, timestamp=1265184361422, value=20 |
| 127 | T04 column=Turnover:P1, timestamp=1265187021529, value=2 |
| 128 | T04 column=Turnover:P2, timestamp=1265187021529, value=1 |
| 129 | T04 column=Turnover:P3, timestamp=1265187021529, value=1 |
| 130 | T04 column=Turnover:sum, timestamp=1265190421993, value=170 |
| 131 | 4 row(s) in 0.0460 seconds |
| 132 | |
| 133 | }}} |
| 134 | |
| 135 | == 4. 產生最終報表 == |
| 137 | |
| 138 | {{{ |
| 139 | > scan 'tsmc-Sum' |
| 140 | ROW COLUMN+CELL |
| 141 | 100T02 column=Turnover:Sum, timestamp=1265190782127, value=100 |
| 142 | 100T02 column=__INDEX__:ROW, timestamp=1265190782127, value=T02 |
| 143 | 120T03 column=Turnover:Sum, timestamp=1265190782128, value=120 |
| 144 | 120T03 column=__INDEX__:ROW, timestamp=1265190782128, value=T03 |
| 145 | 140T01 column=Turnover:Sum, timestamp=1265190782126, value=140 |
| 146 | 140T01 column=__INDEX__:ROW, timestamp=1265190782126, value=T01 |
| 147 | 170T04 column=Turnover:Sum, timestamp=1265190782129, value=170 |
| 148 | 170T04 column=__INDEX__:ROW, timestamp=1265190782129, value=T04 |
| 149 | 4 row(s) in 0.0140 seconds |
| 150 | |
| 151 | }}} |