| Line 177... |
Line 177... |
| 177 |
<connection>Prod_trans</connection>
|
177 |
<connection>Prod_trans</connection>
|
| 178 |
<sql>select b.id as orderId,
|
178 |
<sql>select b.id as orderId,
|
| 179 |
b.userId,
|
179 |
b.userId,
|
| 180 |
1 as orderType,
|
180 |
1 as orderType,
|
| 181 |
datediff(b.creationTimestamp, '20101231') as dateId,
|
181 |
datediff(b.creationTimestamp, '20101231') as dateId,
|
| - |
|
182 |
b.creationTimestamp as timestamp,
|
| 182 |
0 as repeatType,
|
183 |
0 as repeatType,
|
| 183 |
0 as repeatFrequency,
|
184 |
0 as repeatFrequency,
|
| 184 |
1000000000 + b.transaction_id as transactionId,
|
185 |
1000000000 + b.transaction_id as transactionId,
|
| 185 |
case when b.totalAmount<250 then 0 when b.totalAmount<500 then 1 when b.totalAmount<1000 then 2
|
186 |
case when b.totalAmount<250 then 0 when b.totalAmount<500 then 1 when b.totalAmount<1000 then 2
|
| 186 |
when b.totalAmount<2000 then 3 when b.totalAmount < 5000 then 4 when b.totalAmount < 10000 then 5 when b.totalAmount < 15000 then 6
|
187 |
when b.totalAmount<2000 then 3 when b.totalAmount < 5000 then 4 when b.totalAmount < 10000 then 5 when b.totalAmount < 15000 then 6
|
| Line 205... |
Line 206... |
| 205 |
<execute_each_row>N</execute_each_row>
|
206 |
<execute_each_row>N</execute_each_row>
|
| 206 |
<variables_active>N</variables_active>
|
207 |
<variables_active>N</variables_active>
|
| 207 |
<lazy_conversion_active>N</lazy_conversion_active>
|
208 |
<lazy_conversion_active>N</lazy_conversion_active>
|
| 208 |
<cluster_schema/>
|
209 |
<cluster_schema/>
|
| 209 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
210 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
| 210 |
<xloc>119</xloc>
|
211 |
<xloc>120</xloc>
|
| 211 |
<yloc>273</yloc>
|
212 |
<yloc>278</yloc>
|
| 212 |
<draw>Y</draw>
|
213 |
<draw>Y</draw>
|
| 213 |
</GUI>
|
214 |
</GUI>
|
| 214 |
</step>
|
215 |
</step>
|
| 215 |
|
216 |
|
| 216 |
<step>
|
217 |
<step>
|
| Line 226... |
Line 227... |
| 226 |
<connection>Prod_trans</connection>
|
227 |
<connection>Prod_trans</connection>
|
| 227 |
<sql>select o.id as orderId,
|
228 |
<sql>select o.id as orderId,
|
| 228 |
o.customer_id as userId,
|
229 |
o.customer_id as userId,
|
| 229 |
0 as orderType,
|
230 |
0 as orderType,
|
| 230 |
case when o.originalOrderId is null then datediff(o.created_timestamp, '20101231')
|
231 |
case when o.originalOrderId is null then datediff(o.created_timestamp, '20101231')
|
| 231 |
else datediff((select created_timestamp from `order` where id = o.originalOrderId), '20101231') end as dateId ,
|
232 |
else datediff((select created_timestamp from `order` where id = o.originalOrderId), '20101231') end as dateId ,
|
| - |
|
233 |
o.created_timestamp as timestamp,
|
| 232 |
0 as repeatType,
|
234 |
0 as repeatType,
|
| 233 |
0 as repeatFrequency,
|
235 |
0 as repeatFrequency,
|
| 234 |
o.transaction_id as transactionId,
|
236 |
o.transaction_id as transactionId,
|
| 235 |
case when total_amount<250 then 0 when total_amount<500 then 1 when total_amount<1000 then 2
|
237 |
case when total_amount<250 then 0 when total_amount<500 then 1 when total_amount<1000 then 2
|
| 236 |
when total_amount<2000 then 3 when total_amount < 5000 then 4 when total_amount < 10000 then 5 when total_amount < 15000 then 6
|
238 |
when total_amount<2000 then 3 when total_amount < 5000 then 4 when total_amount < 10000 then 5 when total_amount < 15000 then 6
|
| Line 254... |
Line 256... |
| 254 |
<variables_active>N</variables_active>
|
256 |
<variables_active>N</variables_active>
|
| 255 |
<lazy_conversion_active>N</lazy_conversion_active>
|
257 |
<lazy_conversion_active>N</lazy_conversion_active>
|
| 256 |
<cluster_schema/>
|
258 |
<cluster_schema/>
|
| 257 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
259 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
| 258 |
<xloc>126</xloc>
|
260 |
<xloc>126</xloc>
|
| 259 |
<yloc>140</yloc>
|
261 |
<yloc>145</yloc>
|
| 260 |
<draw>Y</draw>
|
262 |
<draw>Y</draw>
|
| 261 |
</GUI>
|
263 |
</GUI>
|
| 262 |
</step>
|
264 |
</step>
|
| 263 |
|
265 |
|
| 264 |
<step>
|
266 |
<step>
|