[Dccss-commit] SF.net SVN: dccss: [352] trunk/dccss

[<mah...@us...>]

Revision: 352
          http://svn.sourceforge.net/dccss/?rev=352&view=rev
Author:   maher_karim
Date:     2007-03-13 04:34:32 -0700 (Tue, 13 Mar 2007)

Log Message:
-----------
2007-03-13  Maher Abdel karim <mah...@do...>

	* script/create_views.sql:use different way for css_to_billing 
	view creation.
	

Modified Paths:
--------------
    trunk/dccss/changelog
    trunk/dccss/script/create_views.sql

Modified: trunk/dccss/changelog
===================================================================
--- trunk/dccss/changelog	2007-03-05 14:24:49 UTC (rev 351)
+++ trunk/dccss/changelog	2007-03-13 11:34:32 UTC (rev 352)
@@ -1,3 +1,8 @@
+2007-03-13  Maher Abdel karim <mah...@do...>
+
+	* script/create_views.sql:use different way for css_to_billing 
+	view creation.
+	
 2007-03-5  Maher Abdel karim <mah...@do...>
 
 	* script/drop_views.sql:fix sql errors.

Modified: trunk/dccss/script/create_views.sql
===================================================================
--- trunk/dccss/script/create_views.sql	2007-03-05 14:24:49 UTC (rev 351)
+++ trunk/dccss/script/create_views.sql	2007-03-13 11:34:32 UTC (rev 352)
@@ -405,13 +405,15 @@
 2666,2667,2670,2672,2674,2677
 ,2678,2680);
 
---Task force lost customers
---create or replace view taskforce_lostcustomer as 
---select deliverypoint.sequence as dpsequence,subscriber.logbooknumber,subscriber.sequence,subscriber.subsequence,
---subscriber.name,subscriber.logbookserialnumber,deliverypoint.cabinetid, grid.id from subscriber,deliverypoint,grid where
---link=0 and subscriber.hasconnectionbefore <> 1 and subscriber.note::text !~~ '%وصلة غير%'::text and 
---subscriber.geocode=deliverypoint.geocode and grid.the_geom&&deliverypoint.the_geom and 
---intersects(deliverypoint.the_geom,grid.the_geom) order by grid.id;
+---Task force lost customers
+create or replace view taskforce_lostcustomer as 
+select deliverypoint.sequence as dpsequence,subscriber.logbooknumber,
+subscriber.sequence,subscriber.subsequence,
+subscriber.name,subscriber.logbookserialnumber,deliverypoint.cabinetid,subscriber.meterlocationcode
+,grid.id from subscriber,deliverypoint,grid where
+link=0 and subscriber.hasconnectionbefore <> 1 and subscriber.note::text !~~ '%وصلة غير%'::text and 
+subscriber.geocode=deliverypoint.geocode and grid.the_geom&&deliverypoint.the_geom and 
+intersects(deliverypoint.the_geom,grid.the_geom) order by grid.id;
 
 -- CSS to billing for data transfer
 create or replace view css_to_billing as 
@@ -425,11 +427,11 @@
 and subscriber.geocode=deliverypoint.geocode
 union
 select  subscriber.id,deliverypoint.sequence as customerlocation,
-to_number(subscriber.cabinetid,99999),subscriber.paracode,subscriber.logbooknumber,
+to_number(metercabinet.id,99999),subscriber.paracode,subscriber.logbooknumber,
 subscriber.sequence,subscriber.subsequence,subscriber.name,
 subscriber.logbookserialnumber,metercabinet.routeid, metercabinet.routesequence
    FROM subscriber
-   LEFT JOIN metercabinet ON (subscriber.cabinetid = metercabinet.id)
+   LEFT JOIN metercabinet ON (subscriber.cabinetid = metercabinet.pewssaid)
    LEFT JOIN deliverypoint ON subscriber.geocode::text = deliverypoint.geocode::text
 
 where subscriber.cabinetid<>'0' and subscriber.meterlocationdeliverypointseq =0 
@@ -441,7 +443,7 @@
 subscriber.subsequence,subscriber.name,subscriber.logbookserialnumber,
 metercabinet.routeid, metercabinet.routesequence
    FROM subscriber
-   LEFT JOIN metercabinet ON (subscriber.cabinetid= metercabinet.id)
+   LEFT JOIN metercabinet ON (subscriber.cabinetid= metercabinet.pewssaid)
    LEFT JOIN deliverypoint ON (subscriber.geocode = deliverypoint.geocode)
  where subscriber.cabinetid<>'0' and 
 subscriber.meterlocationdeliverypointseq <>0 and subscriber.paracode is not null


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.