Subversion Repositories SmartDukaan

Rev

Rev 6541 | Rev 6554 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6541 Rev 6547
Line 148... Line 148...
148 
         <partitioning>
 148 
         <partitioning>
149 
           <method>none</method>
 149 
           <method>none</method>
150 
           <schema_name/>
 150 
           <schema_name/>
151 
           </partitioning>
 151 
           </partitioning>
152 
    <connection>local_tran</connection>
 152 
    <connection>local_tran</connection>
- 
 
 153 
    <sql>select b.id as orderId,
- 
 
 154 
b.userId,
- 
 
 155 
1 as orderType,
153 
    <sql>SELECT id as orderId, datediff(creationTimestamp, &apos;20101231&apos;) as dateId, userId, 1 as isDigital, totalAmount as amount FROM baseorder;</sql>
 156 
datediff(b.creationTimestamp, &apos;20101231&apos;) as dateId,
- 
 
 157 
0 as repeatType,
- 
 
 158 
0 as repeatFrequency,
- 
 
 159 
b.transaction_id as transactionId,
- 
 
 160 
b.totalAmount as amount,
- 
 
 161 
b.totalAmount as transferPrice,
- 
 
 162 
&apos;N&#47;A&apos; as pincode,
- 
 
 163 
0 as itemId,
- 
 
 164 
1 as quantity,
- 
 
 165 
1005 as status,
- 
 
 166 
0 as firstOrderType,
- 
 
 167 
0 as firstOrderDate
- 
 
 168 
from baseorder b
- 
 
 169 
join rechargeorder r on b.id = r.immediateconsumedorder_digitalorder_baseorder_id
- 
 
 170 
where r.status = 5;
- 
 
 171 
</sql>
154 
    <limit>0</limit>
 172 
    <limit>0</limit>
155 
    <lookup/>
 173 
    <lookup/>
156 
    <execute_each_row>N</execute_each_row>
 174 
    <execute_each_row>N</execute_each_row>
157 
    <variables_active>N</variables_active>
 175 
    <variables_active>N</variables_active>
158 
    <lazy_conversion_active>N</lazy_conversion_active>
 176 
    <lazy_conversion_active>N</lazy_conversion_active>
Line 177... Line 195...
177 
    <connection>local_tran</connection>
 195 
    <connection>local_tran</connection>
178 
    <sql>select o.id as orderId,
196 
    <sql>select o.id as orderId,
179 
o.customer_id as userId,
197 
o.customer_id as userId,
180 
0 as orderType,
198 
0 as orderType,
181 
case when o.originalOrderId is null then datediff(o.created_timestamp, &apos;20101231&apos;)
 199 
case when o.originalOrderId is null then datediff(o.created_timestamp, &apos;20101231&apos;)
182 
	else datediff((select created_timestamp from `order` where id = o.originalOrderId), &apos;20101231&apos;) end as dateId
200 
	else datediff((select created_timestamp from `order` where id = o.originalOrderId), &apos;20101231&apos;) end as dateId ,
183 
0 as repeatType,
201 
0 as repeatType,
184 
0 as repeatFrequency,
202 
0 as repeatFrequency,
185 
o.transaction_id as transactionId,
203 
o.transaction_id as transactionId,
186 
o.total_amount as amount,
204 
o.total_amount as amount,
187 
l.transfer_price as transferPrice,
205 
l.transfer_price as transferPrice,
188 
o.pincode,
206 
o.customer_pincode as pincode,
189 
l.item_id as itemId,
207 
l.item_id as itemId,
190 
l.quantity ,
 208 
l.quantity ,
191 
o.status,
 209 
o.status,
192 
0 as firstOrderType,
 210 
0 as firstOrderType,
193 
0 as firstOrderDate
211 
0 as firstOrderDate
Line 229... Line 247...
229 
        <encoding/>
 247 
        <encoding/>
230 
        <decimal_symbol/>
 248 
        <decimal_symbol/>
231 
        <grouping_symbol/>
 249 
        <grouping_symbol/>
232 
        <currency_symbol/>
 250 
        <currency_symbol/>
233 
        <storage_type/>
 251 
        <storage_type/>
- 
 
 252 
      </meta>      <meta>        <name>userId</name>
- 
 
 253 
        <rename>userId</rename>
- 
 
 254 
        <type>-</type>
- 
 
 255 
        <length>9</length>
- 
 
 256 
        <precision>0</precision>
- 
 
 257 
        <conversion_mask/>
- 
 
 258 
        <date_format_lenient>false</date_format_lenient>
- 
 
 259 
        <encoding/>
- 
 
 260 
        <decimal_symbol/>
- 
 
 261 
        <grouping_symbol/>
- 
 
 262 
        <currency_symbol/>
- 
 
 263 
        <storage_type/>
- 
 
 264 
      </meta>      <meta>        <name>orderType</name>
- 
 
 265 
        <rename>orderType</rename>
- 
 
 266 
        <type>-</type>
- 
 
 267 
        <length>15</length>
- 
 
 268 
        <precision>0</precision>
- 
 
 269 
        <conversion_mask/>
- 
 
 270 
        <date_format_lenient>false</date_format_lenient>
- 
 
 271 
        <encoding/>
- 
 
 272 
        <decimal_symbol/>
- 
 
 273 
        <grouping_symbol/>
- 
 
 274 
        <currency_symbol/>
- 
 
 275 
        <storage_type/>
234 
      </meta>      <meta>        <name>dateId</name>
 276 
      </meta>      <meta>        <name>dateId</name>
235 
        <rename>dateId</rename>
 277 
        <rename>dateId</rename>
236 
        <type>-</type>
 278 
        <type>-</type>
237 
        <length>15</length>
 279 
        <length>15</length>
238 
        <precision>0</precision>
 280 
        <precision>0</precision>
Line 241... Line 283...
241 
        <encoding/>
 283 
        <encoding/>
242 
        <decimal_symbol/>
 284 
        <decimal_symbol/>
243 
        <grouping_symbol/>
 285 
        <grouping_symbol/>
244 
        <currency_symbol/>
 286 
        <currency_symbol/>
245 
        <storage_type/>
 287 
        <storage_type/>
246 
      </meta>      <meta>        <name>userId</name>
 288 
      </meta>      <meta>        <name>repeatType</name>
247 
        <rename>userId</rename>
 289 
        <rename>repeatType</rename>
248 
        <type>-</type>
 290 
        <type>-</type>
249 
        <length>9</length>
 291 
        <length>15</length>
250 
        <precision>0</precision>
 292 
        <precision>0</precision>
251 
        <conversion_mask/>
 293 
        <conversion_mask/>
252 
        <date_format_lenient>false</date_format_lenient>
 294 
        <date_format_lenient>false</date_format_lenient>
253 
        <encoding/>
 295 
        <encoding/>
254 
        <decimal_symbol/>
 296 
        <decimal_symbol/>
255 
        <grouping_symbol/>
 297 
        <grouping_symbol/>
256 
        <currency_symbol/>
 298 
        <currency_symbol/>
257 
        <storage_type/>
 299 
        <storage_type/>
258 
      </meta>      <meta>        <name>isDigital</name>
 300 
      </meta>      <meta>        <name>repeatFrequency</name>
259 
        <rename>isDigital</rename>
 301 
        <rename>repeatFrequency</rename>
260 
        <type>-</type>
 302 
        <type>-</type>
261 
        <length>15</length>
 303 
        <length>15</length>
262 
        <precision>0</precision>
 304 
        <precision>0</precision>
263 
        <conversion_mask/>
 305 
        <conversion_mask/>
264 
        <date_format_lenient>false</date_format_lenient>
 306 
        <date_format_lenient>false</date_format_lenient>
265 
        <encoding/>
 307 
        <encoding/>
266 
        <decimal_symbol/>
 308 
        <decimal_symbol/>
267 
        <grouping_symbol/>
 309 
        <grouping_symbol/>
268 
        <currency_symbol/>
 310 
        <currency_symbol/>
269 
        <storage_type/>
 311 
        <storage_type/>
- 
 
 312 
      </meta>      <meta>        <name>transactionId</name>
- 
 
 313 
        <rename>transactionId</rename>
- 
 
 314 
        <type>-</type>
- 
 
 315 
        <length>9</length>
- 
 
 316 
        <precision>0</precision>
- 
 
 317 
        <conversion_mask/>
- 
 
 318 
        <date_format_lenient>false</date_format_lenient>
- 
 
 319 
        <encoding/>
- 
 
 320 
        <decimal_symbol/>
- 
 
 321 
        <grouping_symbol/>
- 
 
 322 
        <currency_symbol/>
- 
 
 323 
        <storage_type/>
270 
      </meta>      <meta>        <name>amount</name>
 324 
      </meta>      <meta>        <name>amount</name>
271 
        <rename>amount</rename>
 325 
        <rename>amount</rename>
272 
        <type>Number</type>
 326 
        <type>Number</type>
273 
        <length>9</length>
 327 
        <length>9</length>
274 
        <precision>0</precision>
 328 
        <precision>0</precision>
Line 277... Line 331...
277 
        <encoding/>
 331 
        <encoding/>
278 
        <decimal_symbol/>
 332 
        <decimal_symbol/>
279 
        <grouping_symbol/>
 333 
        <grouping_symbol/>
280 
        <currency_symbol/>
 334 
        <currency_symbol/>
281 
        <storage_type/>
 335 
        <storage_type/>
- 
 
 336 
      </meta>      <meta>        <name>transferPrice</name>
- 
 
 337 
        <rename>transferPrice</rename>
- 
 
 338 
        <type>Number</type>
- 
 
 339 
        <length>9</length>
- 
 
 340 
        <precision>0</precision>
- 
 
 341 
        <conversion_mask/>
- 
 
 342 
        <date_format_lenient>false</date_format_lenient>
- 
 
 343 
        <encoding/>
- 
 
 344 
        <decimal_symbol/>
- 
 
 345 
        <grouping_symbol/>
- 
 
 346 
        <currency_symbol/>
- 
 
 347 
        <storage_type/>
- 
 
 348 
      </meta>      <meta>        <name>pincode</name>
- 
 
 349 
        <rename>pincode</rename>
- 
 
 350 
        <type>-</type>
- 
 
 351 
        <length>3</length>
- 
 
 352 
        <precision>-2</precision>
- 
 
 353 
        <conversion_mask/>
- 
 
 354 
        <date_format_lenient>false</date_format_lenient>
- 
 
 355 
        <encoding/>
- 
 
 356 
        <decimal_symbol/>
- 
 
 357 
        <grouping_symbol/>
- 
 
 358 
        <currency_symbol/>
- 
 
 359 
        <storage_type/>
- 
 
 360 
      </meta>      <meta>        <name>itemId</name>
- 
 
 361 
        <rename>itemId</rename>
- 
 
 362 
        <type>-</type>
- 
 
 363 
        <length>15</length>
- 
 
 364 
        <precision>0</precision>
- 
 
 365 
        <conversion_mask/>
- 
 
 366 
        <date_format_lenient>false</date_format_lenient>
- 
 
 367 
        <encoding/>
- 
 
 368 
        <decimal_symbol/>
- 
 
 369 
        <grouping_symbol/>
- 
 
 370 
        <currency_symbol/>
- 
 
 371 
        <storage_type/>
- 
 
 372 
      </meta>      <meta>        <name>quantity</name>
- 
 
 373 
        <rename>quantity</rename>
- 
 
 374 
        <type>Number</type>
- 
 
 375 
        <length>15</length>
- 
 
 376 
        <precision>0</precision>
- 
 
 377 
        <conversion_mask/>
- 
 
 378 
        <date_format_lenient>false</date_format_lenient>
- 
 
 379 
        <encoding/>
- 
 
 380 
        <decimal_symbol/>
- 
 
 381 
        <grouping_symbol/>
- 
 
 382 
        <currency_symbol/>
- 
 
 383 
        <storage_type/>
- 
 
 384 
      </meta>      <meta>        <name>status</name>
- 
 
 385 
        <rename>status</rename>
- 
 
 386 
        <type>-</type>
- 
 
 387 
        <length>9</length>
- 
 
 388 
        <precision>0</precision>
- 
 
 389 
        <conversion_mask/>
- 
 
 390 
        <date_format_lenient>false</date_format_lenient>
- 
 
 391 
        <encoding/>
- 
 
 392 
        <decimal_symbol/>
- 
 
 393 
        <grouping_symbol/>
- 
 
 394 
        <currency_symbol/>
- 
 
 395 
        <storage_type/>
- 
 
 396 
      </meta>      <meta>        <name>firstOrderType</name>
- 
 
 397 
        <rename>firstOrderType</rename>
- 
 
 398 
        <type>-</type>
- 
 
 399 
        <length>15</length>
- 
 
 400 
        <precision>0</precision>
- 
 
 401 
        <conversion_mask/>
- 
 
 402 
        <date_format_lenient>false</date_format_lenient>
- 
 
 403 
        <encoding/>
- 
 
 404 
        <decimal_symbol/>
- 
 
 405 
        <grouping_symbol/>
- 
 
 406 
        <currency_symbol/>
- 
 
 407 
        <storage_type/>
- 
 
 408 
      </meta>      <meta>        <name>firstOrderDate</name>
- 
 
 409 
        <rename>firstOrderDate</rename>
- 
 
 410 
        <type>-</type>
- 
 
 411 
        <length>15</length>
- 
 
 412 
        <precision>0</precision>
- 
 
 413 
        <conversion_mask/>
- 
 
 414 
        <date_format_lenient>false</date_format_lenient>
- 
 
 415 
        <encoding/>
- 
 
 416 
        <decimal_symbol/>
- 
 
 417 
        <grouping_symbol/>
- 
 
 418 
        <currency_symbol/>
- 
 
 419 
        <storage_type/>
282 
      </meta>    </fields>     <cluster_schema/>
 420 
      </meta>    </fields>     <cluster_schema/>
283 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 421 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
284 
      <xloc>316</xloc>
 422 
      <xloc>316</xloc>
285 
      <yloc>278</yloc>
 423 
      <yloc>278</yloc>
286 
      <draw>Y</draw>
 424 
      <draw>Y</draw>
Line 362... Line 500...
362 
        <field>
 500 
        <field>
363 
          <column_name>dateId</column_name>
 501 
          <column_name>dateId</column_name>
364 
          <stream_name>dateId</stream_name>
 502 
          <stream_name>dateId</stream_name>
365 
        </field>
 503 
        </field>
366 
        <field>
 504 
        <field>
- 
 
 505 
          <column_name>orderType</column_name>
- 
 
 506 
          <stream_name>orderType</stream_name>
- 
 
 507 
        </field>
- 
 
 508 
        <field>
- 
 
 509 
          <column_name>repeatType</column_name>
- 
 
 510 
          <stream_name>repeatType</stream_name>
- 
 
 511 
        </field>
- 
 
 512 
        <field>
- 
 
 513 
          <column_name>repeatFrequency</column_name>
- 
 
 514 
          <stream_name>repeatFrequency</stream_name>
- 
 
 515 
        </field>
- 
 
 516 
        <field>
- 
 
 517 
          <column_name>transactionId</column_name>
- 
 
 518 
          <stream_name>transactionId</stream_name>
- 
 
 519 
        </field>
- 
 
 520 
        <field>
- 
 
 521 
          <column_name>transferPrice</column_name>
- 
 
 522 
          <stream_name>transferPrice</stream_name>
- 
 
 523 
        </field>
- 
 
 524 
        <field>
- 
 
 525 
          <column_name>pincode</column_name>
- 
 
 526 
          <stream_name>pincode</stream_name>
- 
 
 527 
        </field>
- 
 
 528 
        <field>
- 
 
 529 
          <column_name>itemId</column_name>
- 
 
 530 
          <stream_name>itemId</stream_name>
- 
 
 531 
        </field>
- 
 
 532 
        <field>
367 
          <column_name>isDigital</column_name>
 533 
          <column_name>quantity</column_name>
368 
          <stream_name>isDigital</stream_name>
 534 
          <stream_name>quantity</stream_name>
- 
 
 535 
        </field>
- 
 
 536 
        <field>
- 
 
 537 
          <column_name>status</column_name>
- 
 
 538 
          <stream_name>status</stream_name>
- 
 
 539 
        </field>
- 
 
 540 
        <field>
- 
 
 541 
          <column_name>firstOrderType</column_name>
- 
 
 542 
          <stream_name>firstOrderType</stream_name>
- 
 
 543 
        </field>
- 
 
 544 
        <field>
- 
 
 545 
          <column_name>firstOrderDate</column_name>
- 
 
 546 
          <stream_name>firstOrderDate</stream_name>
369 
        </field>
 547 
        </field>
370 
    </fields>
 548 
    </fields>
371 
     <cluster_schema/>
 549 
     <cluster_schema/>
372 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 550 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
373 
      <xloc>715</xloc>
 551 
      <xloc>715</xloc>