Subversion Repositories SmartDukaan

Rev

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

Rev 6547 Rev 6554
Line 116... Line 116...
116 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
 116 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
117 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
 117 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
118 
    </attributes>
 118 
    </attributes>
119 
  </connection>
 119 
  </connection>
120 
  <order>
 120 
  <order>
121 
  <hop> <from>PhysicalOrder</from><to>Append streams</to><enabled>Y</enabled> </hop>  <hop> <from>Append streams</from><to>Sort rows</to><enabled>Y</enabled> </hop>  <hop> <from>Sort rows</from><to>Table output</to><enabled>Y</enabled> </hop>  <hop> <from>DigitalOrder</from><to>Select values</to><enabled>Y</enabled> </hop>  <hop> <from>Select values</from><to>Append streams</to><enabled>Y</enabled> </hop>  </order>
 121 
  <hop> <from>PhysicalOrder</from><to>PhysicalOrderSelector</to><enabled>Y</enabled> </hop>  <hop> <from>Append streams</from><to>Sort rows</to><enabled>Y</enabled> </hop>  <hop> <from>Sort rows</from><to>Table output</to><enabled>Y</enabled> </hop>  <hop> <from>DigitalOrder</from><to>DigitalOrderSelector</to><enabled>Y</enabled> </hop>  <hop> <from>DigitalOrderSelector</from><to>Append streams</to><enabled>Y</enabled> </hop>  <hop> <from>PhysicalOrderSelector</from><to>Append streams</to><enabled>Y</enabled> </hop>  </order>
122 
  <step>
 122 
  <step>
123 
    <name>Append streams</name>
 123 
    <name>Append streams</name>
124 
    <type>Append</type>
 124 
    <type>Append</type>
125 
    <description/>
 125 
    <description/>
126 
    <distribute>Y</distribute>
 126 
    <distribute>Y</distribute>
127 
    <copies>1</copies>
 127 
    <copies>1</copies>
128 
         <partitioning>
 128 
         <partitioning>
129 
           <method>none</method>
 129 
           <method>none</method>
130 
           <schema_name/>
 130 
           <schema_name/>
131 
           </partitioning>
 131 
           </partitioning>
132 
<head_name>PhysicalOrder</head_name>
 132 
<head_name>PhysicalOrderSelector</head_name>
133 
<tail_name>Select values</tail_name>
 133 
<tail_name>DigitalOrderSelector</tail_name>
134 
     <cluster_schema/>
 134 
     <cluster_schema/>
135 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 135 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
136 
      <xloc>443</xloc>
 136 
      <xloc>463</xloc>
137 
      <yloc>208</yloc>
 137 
      <yloc>209</yloc>
138 
      <draw>Y</draw>
 138 
      <draw>Y</draw>
139 
      </GUI>
 139 
      </GUI>
140 
    </step>
 140 
    </step>
141 
 
 141 
 
142 
  <step>
 142 
  <step>
Line 155... Line 155...
155 
1 as orderType,
155 
1 as orderType,
156 
datediff(b.creationTimestamp, &apos;20101231&apos;) as dateId,
 156 
datediff(b.creationTimestamp, &apos;20101231&apos;) as dateId,
157 
0 as repeatType,
157 
0 as repeatType,
158 
0 as repeatFrequency,
158 
0 as repeatFrequency,
159 
b.transaction_id as transactionId,
159 
b.transaction_id as transactionId,
- 
 
 160 
case when b.totalAmount&lt;250 then 0 when b.totalAmount&lt;500 then 1 when b.totalAmount&lt;1000 then 2
- 
 
 161 
			 when b.totalAmount&lt;2000 then 3 when b.totalAmount &lt; 5000 then 4 when b.totalAmount &lt; 10000 then 5 when b.totalAmount &lt; 15000 then 6
160 
b.totalAmount as amount,
162 
			 when b.totalAmount &lt;20000 then 7 when b.totalAmount &lt; 50000 then 8 else 9 end as amount,
- 
 
 163 
case when b.totalAmount&lt;250 then 0 when b.totalAmount&lt;500 then 1 when b.totalAmount&lt;1000 then 2
- 
 
 164 
			 when b.totalAmount&lt;2000 then 3 when b.totalAmount &lt; 5000 then 4 when b.totalAmount &lt; 10000 then 5 when b.totalAmount &lt; 15000 then 6
161 
b.totalAmount as transferPrice,
165 
			 when b.totalAmount &lt;20000 then 7 when b.totalAmount &lt; 50000 then 8 else 9 end as transferPrice,
162 
&apos;N&#47;A&apos; as pincode,
166 
&apos;000000&apos; as pincode,
163 
0 as itemId,
167 
case when d.dthOperatorId is null then 100000 + m.mobileOperatorId else 100000 + d.dthOperatorId end as itemId,
164 
1 as quantity,
 168 
1 as quantity,
165 
1005 as status,
 169 
1005 as status,
166 
0 as firstOrderType,
 170 
0 as firstOrderType,
167 
0 as firstOrderDate
171 
0 as firstOrderDate
168 
from baseorder b
172 
from baseorder b
169 
join rechargeorder r on b.id = r.immediateconsumedorder_digitalorder_baseorder_id
173 
join rechargeorder r on b.id = r.immediateconsumedorder_digitalorder_baseorder_id
- 
 
 174 
left join mobilerechargeorder m on m.rechargeorder_immediateconsumedorder_digitalorder_baseorder_id = b.id
- 
 
 175 
left join dthrechargeorder d on d.rechargeorder_immediateconsumedorder_digitalorder_baseorder_id = b.id
170 
where r.status = 5;
 176 
where r.status = 5;
171 
</sql>
 177 
</sql>
172 
    <limit>0</limit>
 178 
    <limit>0</limit>
173 
    <lookup/>
 179 
    <lookup/>
174 
    <execute_each_row>N</execute_each_row>
 180 
    <execute_each_row>N</execute_each_row>
175 
    <variables_active>N</variables_active>
 181 
    <variables_active>N</variables_active>
176 
    <lazy_conversion_active>N</lazy_conversion_active>
 182 
    <lazy_conversion_active>N</lazy_conversion_active>
177 
     <cluster_schema/>
 183 
     <cluster_schema/>
178 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 184 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
179 
      <xloc>217</xloc>
 185 
      <xloc>119</xloc>
180 
      <yloc>277</yloc>
 186 
      <yloc>273</yloc>
181 
      <draw>Y</draw>
 187 
      <draw>Y</draw>
182 
      </GUI>
 188 
      </GUI>
183 
    </step>
 189 
    </step>
184 
 
 190 
 
185 
  <step>
 191 
  <step>
Line 199... Line 205...
199 
case when o.originalOrderId is null then datediff(o.created_timestamp, &apos;20101231&apos;)
 205 
case when o.originalOrderId is null then datediff(o.created_timestamp, &apos;20101231&apos;)
200 
	else datediff((select created_timestamp from `order` where id = o.originalOrderId), &apos;20101231&apos;) end as dateId ,
206 
	else datediff((select created_timestamp from `order` where id = o.originalOrderId), &apos;20101231&apos;) end as dateId ,
201 
0 as repeatType,
207 
0 as repeatType,
202 
0 as repeatFrequency,
208 
0 as repeatFrequency,
203 
o.transaction_id as transactionId,
209 
o.transaction_id as transactionId,
- 
 
 210 
case when total_amount&lt;250 then 0 when total_amount&lt;500 then 1 when total_amount&lt;1000 then 2
- 
 
 211 
			 when total_amount&lt;2000 then 3 when total_amount &lt; 5000 then 4 when total_amount &lt; 10000 then 5 when total_amount &lt; 15000 then 6
204 
o.total_amount as amount,
212 
			 when total_amount &lt;20000 then 7 when total_amount &lt; 50000 then 8 else 9 end as amount,
- 
 
 213 
case when l.transfer_price&lt;250 then 0 when l.transfer_price&lt;500 then 1 when l.transfer_price&lt;1000 then 2
- 
 
 214 
			 when l.transfer_price&lt;2000 then 3 when l.transfer_price &lt; 5000 then 4 when l.transfer_price &lt; 10000 then 5 when l.transfer_price &lt; 15000 then 6
205 
l.transfer_price as transferPrice,
215 
			 when l.transfer_price &lt;20000 then 7 when l.transfer_price &lt; 50000 then 8 else 9 end as transferPrice,
206 
o.customer_pincode as pincode,
216 
o.customer_pincode as pincode,
207 
l.item_id as itemId,
217 
l.item_id as itemId,
208 
l.quantity ,
 218 
l.quantity ,
209 
o.status,
 219 
o.status,
210 
0 as firstOrderType,
 220 
0 as firstOrderType,
Line 218... Line 228...
218 
    <execute_each_row>N</execute_each_row>
 228 
    <execute_each_row>N</execute_each_row>
219 
    <variables_active>N</variables_active>
 229 
    <variables_active>N</variables_active>
220 
    <lazy_conversion_active>N</lazy_conversion_active>
 230 
    <lazy_conversion_active>N</lazy_conversion_active>
221 
     <cluster_schema/>
 231 
     <cluster_schema/>
222 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 232 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
223 
      <xloc>215</xloc>
 233 
      <xloc>126</xloc>
224 
      <yloc>146</yloc>
 234 
      <yloc>140</yloc>
225 
      <draw>Y</draw>
 235 
      <draw>Y</draw>
226 
      </GUI>
 236 
      </GUI>
227 
    </step>
 237 
    </step>
228 
 
 238 
 
229 
  <step>
 239 
  <step>
230 
    <name>Select values</name>
 240 
    <name>DigitalOrderSelector</name>
231 
    <type>SelectValues</type>
 241 
    <type>SelectValues</type>
232 
    <description/>
 242 
    <description/>
233 
    <distribute>Y</distribute>
 243 
    <distribute>Y</distribute>
234 
    <copies>1</copies>
 244 
    <copies>1</copies>
235 
         <partitioning>
 245 
         <partitioning>
Line 357... Line 367...
357 
        <grouping_symbol/>
 367 
        <grouping_symbol/>
358 
        <currency_symbol/>
 368 
        <currency_symbol/>
359 
        <storage_type/>
 369 
        <storage_type/>
360 
      </meta>      <meta>        <name>itemId</name>
 370 
      </meta>      <meta>        <name>itemId</name>
361 
        <rename>itemId</rename>
 371 
        <rename>itemId</rename>
362 
        <type>-</type>
 372 
        <type>Integer</type>
363 
        <length>15</length>
 373 
        <length>9</length>
364 
        <precision>0</precision>
 374 
        <precision>0</precision>
365 
        <conversion_mask/>
 375 
        <conversion_mask/>
366 
        <date_format_lenient>false</date_format_lenient>
 376 
        <date_format_lenient>false</date_format_lenient>
367 
        <encoding/>
 377 
        <encoding/>
368 
        <decimal_symbol/>
 378 
        <decimal_symbol/>
Line 552... Line 562...
552 
      <yloc>209</yloc>
 562 
      <yloc>209</yloc>
553 
      <draw>Y</draw>
 563 
      <draw>Y</draw>
554 
      </GUI>
 564 
      </GUI>
555 
    </step>
 565 
    </step>
556 
 
 566 
 
- 
 
 567 
  <step>
- 
 
 568 
    <name>PhysicalOrderSelector</name>
- 
 
 569 
    <type>SelectValues</type>
- 
 
 570 
    <description/>
- 
 
 571 
    <distribute>Y</distribute>
- 
 
 572 
    <copies>1</copies>
- 
 
 573 
         <partitioning>
- 
 
 574 
           <method>none</method>
- 
 
 575 
           <schema_name/>
- 
 
 576 
           </partitioning>
- 
 
 577 
    <fields>        <select_unspecified>N</select_unspecified>
- 
 
 578 
      <meta>        <name>orderId</name>
- 
 
 579 
        <rename>orderId</rename>
- 
 
 580 
        <type>-</type>
- 
 
 581 
        <length>9</length>
- 
 
 582 
        <precision>0</precision>
- 
 
 583 
        <conversion_mask/>
- 
 
 584 
        <date_format_lenient>false</date_format_lenient>
- 
 
 585 
        <encoding/>
- 
 
 586 
        <decimal_symbol/>
- 
 
 587 
        <grouping_symbol/>
- 
 
 588 
        <currency_symbol/>
- 
 
 589 
        <storage_type/>
- 
 
 590 
      </meta>      <meta>        <name>userId</name>
- 
 
 591 
        <rename>userId</rename>
- 
 
 592 
        <type>-</type>
- 
 
 593 
        <length>9</length>
- 
 
 594 
        <precision>0</precision>
- 
 
 595 
        <conversion_mask/>
- 
 
 596 
        <date_format_lenient>false</date_format_lenient>
- 
 
 597 
        <encoding/>
- 
 
 598 
        <decimal_symbol/>
- 
 
 599 
        <grouping_symbol/>
- 
 
 600 
        <currency_symbol/>
- 
 
 601 
        <storage_type/>
- 
 
 602 
      </meta>      <meta>        <name>orderType</name>
- 
 
 603 
        <rename>orderType</rename>
- 
 
 604 
        <type>-</type>
- 
 
 605 
        <length>15</length>
- 
 
 606 
        <precision>0</precision>
- 
 
 607 
        <conversion_mask/>
- 
 
 608 
        <date_format_lenient>false</date_format_lenient>
- 
 
 609 
        <encoding/>
- 
 
 610 
        <decimal_symbol/>
- 
 
 611 
        <grouping_symbol/>
- 
 
 612 
        <currency_symbol/>
- 
 
 613 
        <storage_type/>
- 
 
 614 
      </meta>      <meta>        <name>dateId</name>
- 
 
 615 
        <rename>dateId</rename>
- 
 
 616 
        <type>-</type>
- 
 
 617 
        <length>15</length>
- 
 
 618 
        <precision>0</precision>
- 
 
 619 
        <conversion_mask/>
- 
 
 620 
        <date_format_lenient>false</date_format_lenient>
- 
 
 621 
        <encoding/>
- 
 
 622 
        <decimal_symbol/>
- 
 
 623 
        <grouping_symbol/>
- 
 
 624 
        <currency_symbol/>
- 
 
 625 
        <storage_type/>
- 
 
 626 
      </meta>      <meta>        <name>repeatType</name>
- 
 
 627 
        <rename>repeatType</rename>
- 
 
 628 
        <type>-</type>
- 
 
 629 
        <length>15</length>
- 
 
 630 
        <precision>0</precision>
- 
 
 631 
        <conversion_mask/>
- 
 
 632 
        <date_format_lenient>false</date_format_lenient>
- 
 
 633 
        <encoding/>
- 
 
 634 
        <decimal_symbol/>
- 
 
 635 
        <grouping_symbol/>
- 
 
 636 
        <currency_symbol/>
- 
 
 637 
        <storage_type/>
- 
 
 638 
      </meta>      <meta>        <name>repeatFrequency</name>
- 
 
 639 
        <rename>repeatFrequency</rename>
- 
 
 640 
        <type>-</type>
- 
 
 641 
        <length>15</length>
- 
 
 642 
        <precision>0</precision>
- 
 
 643 
        <conversion_mask/>
- 
 
 644 
        <date_format_lenient>false</date_format_lenient>
- 
 
 645 
        <encoding/>
- 
 
 646 
        <decimal_symbol/>
- 
 
 647 
        <grouping_symbol/>
- 
 
 648 
        <currency_symbol/>
- 
 
 649 
        <storage_type/>
- 
 
 650 
      </meta>      <meta>        <name>transactionId</name>
- 
 
 651 
        <rename>transactionId</rename>
- 
 
 652 
        <type>-</type>
- 
 
 653 
        <length>9</length>
- 
 
 654 
        <precision>0</precision>
- 
 
 655 
        <conversion_mask/>
- 
 
 656 
        <date_format_lenient>false</date_format_lenient>
- 
 
 657 
        <encoding/>
- 
 
 658 
        <decimal_symbol/>
- 
 
 659 
        <grouping_symbol/>
- 
 
 660 
        <currency_symbol/>
- 
 
 661 
        <storage_type/>
- 
 
 662 
      </meta>      <meta>        <name>amount</name>
- 
 
 663 
        <rename>amount</rename>
- 
 
 664 
        <type>Number</type>
- 
 
 665 
        <length>9</length>
- 
 
 666 
        <precision>0</precision>
- 
 
 667 
        <conversion_mask/>
- 
 
 668 
        <date_format_lenient>false</date_format_lenient>
- 
 
 669 
        <encoding/>
- 
 
 670 
        <decimal_symbol/>
- 
 
 671 
        <grouping_symbol/>
- 
 
 672 
        <currency_symbol/>
- 
 
 673 
        <storage_type/>
- 
 
 674 
      </meta>      <meta>        <name>transferPrice</name>
- 
 
 675 
        <rename>transferPrice</rename>
- 
 
 676 
        <type>Number</type>
- 
 
 677 
        <length>9</length>
- 
 
 678 
        <precision>0</precision>
- 
 
 679 
        <conversion_mask/>
- 
 
 680 
        <date_format_lenient>false</date_format_lenient>
- 
 
 681 
        <encoding/>
- 
 
 682 
        <decimal_symbol/>
- 
 
 683 
        <grouping_symbol/>
- 
 
 684 
        <currency_symbol/>
- 
 
 685 
        <storage_type/>
- 
 
 686 
      </meta>      <meta>        <name>pincode</name>
- 
 
 687 
        <rename>pincode</rename>
- 
 
 688 
        <type>-</type>
- 
 
 689 
        <length>10</length>
- 
 
 690 
        <precision>-2</precision>
- 
 
 691 
        <conversion_mask/>
- 
 
 692 
        <date_format_lenient>false</date_format_lenient>
- 
 
 693 
        <encoding/>
- 
 
 694 
        <decimal_symbol/>
- 
 
 695 
        <grouping_symbol/>
- 
 
 696 
        <currency_symbol/>
- 
 
 697 
        <storage_type/>
- 
 
 698 
      </meta>      <meta>        <name>itemId</name>
- 
 
 699 
        <rename>itemId</rename>
- 
 
 700 
        <type>Integer</type>
- 
 
 701 
        <length>9</length>
- 
 
 702 
        <precision>0</precision>
- 
 
 703 
        <conversion_mask/>
- 
 
 704 
        <date_format_lenient>false</date_format_lenient>
- 
 
 705 
        <encoding/>
- 
 
 706 
        <decimal_symbol/>
- 
 
 707 
        <grouping_symbol/>
- 
 
 708 
        <currency_symbol/>
- 
 
 709 
        <storage_type/>
- 
 
 710 
      </meta>      <meta>        <name>quantity</name>
- 
 
 711 
        <rename>quantity</rename>
- 
 
 712 
        <type>-</type>
- 
 
 713 
        <length>-2</length>
- 
 
 714 
        <precision>-2</precision>
- 
 
 715 
        <conversion_mask/>
- 
 
 716 
        <date_format_lenient>false</date_format_lenient>
- 
 
 717 
        <encoding/>
- 
 
 718 
        <decimal_symbol/>
- 
 
 719 
        <grouping_symbol/>
- 
 
 720 
        <currency_symbol/>
- 
 
 721 
        <storage_type/>
- 
 
 722 
      </meta>      <meta>        <name>status</name>
- 
 
 723 
        <rename>status</rename>
- 
 
 724 
        <type>-</type>
- 
 
 725 
        <length>9</length>
- 
 
 726 
        <precision>0</precision>
- 
 
 727 
        <conversion_mask/>
- 
 
 728 
        <date_format_lenient>false</date_format_lenient>
- 
 
 729 
        <encoding/>
- 
 
 730 
        <decimal_symbol/>
- 
 
 731 
        <grouping_symbol/>
- 
 
 732 
        <currency_symbol/>
- 
 
 733 
        <storage_type/>
- 
 
 734 
      </meta>      <meta>        <name>firstOrderType</name>
- 
 
 735 
        <rename>firstOrderType</rename>
- 
 
 736 
        <type>-</type>
- 
 
 737 
        <length>15</length>
- 
 
 738 
        <precision>0</precision>
- 
 
 739 
        <conversion_mask/>
- 
 
 740 
        <date_format_lenient>false</date_format_lenient>
- 
 
 741 
        <encoding/>
- 
 
 742 
        <decimal_symbol/>
- 
 
 743 
        <grouping_symbol/>
- 
 
 744 
        <currency_symbol/>
- 
 
 745 
        <storage_type/>
- 
 
 746 
      </meta>      <meta>        <name>firstOrderDate</name>
- 
 
 747 
        <rename>firstOrderDate</rename>
- 
 
 748 
        <type>-</type>
- 
 
 749 
        <length>15</length>
- 
 
 750 
        <precision>0</precision>
- 
 
 751 
        <conversion_mask/>
- 
 
 752 
        <date_format_lenient>false</date_format_lenient>
- 
 
 753 
        <encoding/>
- 
 
 754 
        <decimal_symbol/>
- 
 
 755 
        <grouping_symbol/>
- 
 
 756 
        <currency_symbol/>
- 
 
 757 
        <storage_type/>
- 
 
 758 
      </meta>    </fields>     <cluster_schema/>
- 
 
 759 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
- 
 
 760 
      <xloc>274</xloc>
- 
 
 761 
      <yloc>145</yloc>
- 
 
 762 
      <draw>Y</draw>
- 
 
 763 
      </GUI>
- 
 
 764 
    </step>
- 
 
 765 
 
557 
  <step_error_handling>
 766 
  <step_error_handling>
558 
  </step_error_handling>
 767 
  </step_error_handling>
559 
   <slave-step-copy-partition-distribution>
 768 
   <slave-step-copy-partition-distribution>
560 
</slave-step-copy-partition-distribution>
 769 
</slave-step-copy-partition-distribution>
561 
   <slave_transformation>N</slave_transformation>
 770 
   <slave_transformation>N</slave_transformation>