|
From: <mah...@us...> - 2007-03-13 11:34:37
|
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.
|