Subversion Repositories SmartDukaan

Rev

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

Rev 3750 Rev 5157
Line 67... Line 67...
67 
  <modified_date>2011&#47;06&#47;23 16:31:56.870</modified_date>
 67 
  <modified_date>2011&#47;06&#47;23 16:31:56.870</modified_date>
68 
  </info>
 68 
  </info>
69 
  <notepads>
 69 
  <notepads>
70 
  </notepads>
 70 
  </notepads>
71 
  <connection>
 71 
  <connection>
- 
 
 72 
    <name>sales_Local</name>
- 
 
 73 
    <server>localhost</server>
- 
 
 74 
    <type>MYSQL</type>
- 
 
 75 
    <access>Native</access>
- 
 
 76 
    <database>sales</database>
- 
 
 77 
    <port>3306</port>
- 
 
 78 
    <username>root</username>
- 
 
 79 
    <password>Encrypted 2be98afc86aa7f2e4b811a1608cc2fd8a</password>
- 
 
 80 
    <servername/>
- 
 
 81 
    <data_tablespace/>
- 
 
 82 
    <index_tablespace/>
- 
 
 83 
    <attributes>
- 
 
 84 
      <attribute><code>EXTRA_OPTION_MYSQL.defaultFetchSize</code><attribute>500</attribute></attribute>
- 
 
 85 
      <attribute><code>EXTRA_OPTION_MYSQL.useCursorFetch</code><attribute>true</attribute></attribute>
- 
 
 86 
      <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
- 
 
 87 
      <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
- 
 
 88 
      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
- 
 
 89 
      <attribute><code>PORT_NUMBER</code><attribute>3306</attribute></attribute>
- 
 
 90 
      <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
- 
 
 91 
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
- 
 
 92 
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>
- 
 
 93 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
- 
 
 94 
    </attributes>
- 
 
 95 
  </connection>
- 
 
 96 
  <connection>
72 
    <name>salesDC_DW</name>
 97 
    <name>salesDC_DW</name>
73 
    <server>localhost</server>
 98 
    <server>localhost</server>
74 
    <type>MYSQL</type>
 99 
    <type>MYSQL</type>
75 
    <access>Native</access>
 100 
    <access>Native</access>
76 
    <database>sales</database>
 101 
    <database>sales</database>
Line 118... Line 143...
118 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
 143 
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
119 
    </attributes>
 144 
    </attributes>
120 
  </connection>
 145 
  </connection>
121 
  <connection>
 146 
  <connection>
122 
    <name>transactionDC_Prod</name>
 147 
    <name>transactionDC_Prod</name>
123 
    <server>192.168.190.114</server>
 148 
    <server>192.168.190.113</server>
124 
    <type>MYSQL</type>
 149 
    <type>MYSQL</type>
125 
    <access>Native</access>
 150 
    <access>Native</access>
126 
    <database>transaction</database>
 151 
    <database>transaction</database>
127 
    <port>3306</port>
 152 
    <port>3306</port>
128 
    <username>pentaho</username>
 153 
    <username>pentaho</username>
Line 171... Line 196...
171 
    <tablename_field/>
 196 
    <tablename_field/>
172 
    <tablename_in_table>Y</tablename_in_table>
 197 
    <tablename_in_table>Y</tablename_in_table>
173 
    <return_keys>N</return_keys>
 198 
    <return_keys>N</return_keys>
174 
    <return_field/>
 199 
    <return_field/>
175 
    <fields>
 200 
    <fields>
- 
 
 201 
        <field>
- 
 
 202 
          <column_name>date_id</column_name>
- 
 
 203 
          <stream_name>date_id</stream_name>
- 
 
 204 
        </field>
- 
 
 205 
        <field>
- 
 
 206 
          <column_name>logistics_provider_id</column_name>
- 
 
 207 
          <stream_name>logistics_provider_id</stream_name>
- 
 
 208 
        </field>
- 
 
 209 
        <field>
- 
 
 210 
          <column_name>customer_pincode</column_name>
- 
 
 211 
          <stream_name>customer_pincode</stream_name>
- 
 
 212 
        </field>
- 
 
 213 
        <field>
- 
 
 214 
          <column_name>status</column_name>
- 
 
 215 
          <stream_name>status</stream_name>
- 
 
 216 
        </field>
- 
 
 217 
        <field>
- 
 
 218 
          <column_name>payment_method</column_name>
- 
 
 219 
          <stream_name>payment_method</stream_name>
- 
 
 220 
        </field>
- 
 
 221 
        <field>
- 
 
 222 
          <column_name>item_id</column_name>
- 
 
 223 
          <stream_name>item_id</stream_name>
- 
 
 224 
        </field>
- 
 
 225 
        <field>
- 
 
 226 
          <column_name>expected_delivery_days</column_name>
- 
 
 227 
          <stream_name>expected_delivery_days</stream_name>
- 
 
 228 
        </field>
- 
 
 229 
        <field>
- 
 
 230 
          <column_name>connected_locally</column_name>
- 
 
 231 
          <stream_name>connected_locally</stream_name>
- 
 
 232 
        </field>
- 
 
 233 
        <field>
- 
 
 234 
          <column_name>first_delivery_attempt</column_name>
- 
 
 235 
          <stream_name>first_delivery_attempt</stream_name>
- 
 
 236 
        </field>
- 
 
 237 
        <field>
- 
 
 238 
          <column_name>actual_delivery_days</column_name>
- 
 
 239 
          <stream_name>actual_delivery_days</stream_name>
- 
 
 240 
        </field>
- 
 
 241 
        <field>
- 
 
 242 
          <column_name>actual_estimate_diff</column_name>
- 
 
 243 
          <stream_name>actual_estimate_diff</stream_name>
- 
 
 244 
        </field>
- 
 
 245 
        <field>
- 
 
 246 
          <column_name>delay_reason</column_name>
- 
 
 247 
          <stream_name>delay_reason</stream_name>
- 
 
 248 
        </field>
- 
 
 249 
        <field>
- 
 
 250 
          <column_name>reached_destination_city</column_name>
- 
 
 251 
          <stream_name>reached_destination_city</stream_name>
- 
 
 252 
        </field>
176 
    </fields>
 253 
    </fields>
177 
     <cluster_schema/>
 254 
     <cluster_schema/>
178 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
 255 
 <remotesteps>   <input>   </input>   <output>   </output> </remotesteps>    <GUI>
179 
      <xloc>630</xloc>
 256 
      <xloc>630</xloc>
180 
      <yloc>161</yloc>
 257 
      <yloc>161</yloc>
Line 194... Line 271...
194 
           </partitioning>
 271 
           </partitioning>
195 
    <connection>transactionDC_Prod</connection>
 272 
    <connection>transactionDC_Prod</connection>
196 
    <sql>select datediff(o.created_timestamp, &apos;20101231&apos;) as date_id, o.logistics_provider_id, o.customer_pincode, o.status,
273 
    <sql>select datediff(o.created_timestamp, &apos;20101231&apos;) as date_id, o.logistics_provider_id, o.customer_pincode, o.status,
197 
case when pa.value is null then case when p.gatewayId = 1 then 2099 when p.gatewayId = 2 then 1099 else null end else pa.value end &apos;payment_method&apos;,
 274 
case when pa.value is null then case when p.gatewayId = 1 then 2099 when p.gatewayId = 2 then 1099 else null end else pa.value end &apos;payment_method&apos;,
198 
l.item_id, datediff(o.expected_delivery_time, o.created_timestamp) as expected_delivery_days,
275 
l.item_id, datediff(o.expected_delivery_time, o.created_timestamp) as expected_delivery_days,
- 
 
 276 
datediff(o.local_connected_timestamp, o.created_timestamp) as connected_locally,
- 
 
 277 
datediff(o.reached_destination_timestamp, o.created_timestamp) as reached_destination_city,
- 
 
 278 
datediff(o.first_dlvyatmp_timestamp, o.created_timestamp) as first_delivery_attempt,
199 
datediff(o.delivery_timestamp, o.created_timestamp) as actual_delivery_days,
279 
datediff(o.delivery_timestamp, o.created_timestamp) as actual_delivery_days,
200 
datediff(o.delivery_timestamp, o.created_timestamp)-datediff(o.expected_delivery_time, o.created_timestamp) as actual_estimate_diff, o.delay_reason
 280 
datediff(o.delivery_timestamp, o.created_timestamp)-datediff(o.expected_delivery_time, o.created_timestamp) as actual_estimate_diff, o.delay_reason
201 
from `order` o
281 
from `order` o
202 
left join lineitem l on (o.id = l.order_id)
282 
left join lineitem l on (o.id = l.order_id)
203 
left join (select * from payment.payment order by id desc) p on (o.transaction_id = p.merchantTxnId)
283 
left join (select * from payment.payment order by id desc) p on (o.transaction_id = p.merchantTxnId)
Line 240... Line 320...
240 
        <precision>-2</precision>
 320 
        <precision>-2</precision>
241 
      </field>      <field>        <name>status</name>
 321 
      </field>      <field>        <name>status</name>
242 
        <rename/>
 322 
        <rename/>
243 
        <length>-2</length>
 323 
        <length>-2</length>
244 
        <precision>-2</precision>
 324 
        <precision>-2</precision>
- 
 
 325 
      </field>      <field>        <name>payment_method</name>
- 
 
 326 
        <rename/>
- 
 
 327 
        <length>-2</length>
- 
 
 328 
        <precision>-2</precision>
245 
      </field>      <field>        <name>item_id</name>
 329 
      </field>      <field>        <name>item_id</name>
246 
        <rename/>
 330 
        <rename/>
247 
        <length>-2</length>
 331 
        <length>-2</length>
248 
        <precision>-2</precision>
 332 
        <precision>-2</precision>
249 
      </field>      <field>        <name>expected_delivery_days</name>
 333 
      </field>      <field>        <name>expected_delivery_days</name>
250 
        <rename/>
 334 
        <rename/>
251 
        <length>-2</length>
 335 
        <length>-2</length>
252 
        <precision>-2</precision>
 336 
        <precision>-2</precision>
253 
      </field>      <field>        <name>actual_delivery_days</name>
 337 
      </field>      <field>        <name>connected_locally</name>
254 
        <rename/>
 338 
        <rename/>
255 
        <length>-2</length>
 339 
        <length>-2</length>
256 
        <precision>-2</precision>
 340 
        <precision>-2</precision>
257 
      </field>      <field>        <name>actual_estimate_diff</name>
 341 
      </field>      <field>        <name>reached_destination_city</name>
258 
        <rename/>
 342 
        <rename/>
259 
        <length>-2</length>
 343 
        <length>-2</length>
260 
        <precision>-2</precision>
 344 
        <precision>-2</precision>
261 
      </field>      <field>        <name>delay_reason</name>
 345 
      </field>      <field>        <name>first_delivery_attempt</name>
262 
        <rename/>
 346 
        <rename/>
263 
        <length>-2</length>
 347 
        <length>-2</length>
264 
        <precision>-2</precision>
 348 
        <precision>-2</precision>
- 
 
 349 
      </field>      <field>        <name>actual_delivery_days</name>
- 
 
 350 
        <rename/>
- 
 
 351 
        <length>-2</length>
- 
 
 352 
        <precision>-2</precision>
- 
 
 353 
      </field>      <field>        <name>actual_estimate_diff</name>
- 
 
 354 
        <rename/>
- 
 
 355 
        <length>-2</length>
- 
 
 356 
        <precision>-2</precision>
265 
      </field>      <field>        <name>payment_method</name>
 357 
      </field>      <field>        <name>delay_reason</name>
266 
        <rename/>
 358 
        <rename/>
267 
        <length>-2</length>
 359 
        <length>-2</length>
268 
        <precision>-2</precision>
 360 
        <precision>-2</precision>
269 
      </field>        <select_unspecified>N</select_unspecified>
 361 
      </field>        <select_unspecified>N</select_unspecified>
270 
    </fields>     <cluster_schema/>
 362 
    </fields>     <cluster_schema/>