SHOW:
|
|
- or go back to the newest paste.
| 1 | - | CREATE OR REPLACE TYPE REVELATION."OBJ$CAMPAIGN" AS OBJECT ( |
| 1 | + | CONSTRUCTOR FUNCTION Obj$Campaign(id NUMBER DEFAULT NULL) RETURN SELF AS RESULT AS |
| 2 | - | id NUMBER, |
| 2 | + | BEGIN |
| 3 | - | clientID NUMBER, |
| 3 | + | IF id IS NULL THEN RETURN; END IF; |
| 4 | - | objectID NUMBER, |
| 4 | + | WITH a AS ( |
| 5 | - | scriptID NUMBER, |
| 5 | + | SELECT cc.campaign_id, |
| 6 | - | scriptCode VARCHAR2(255), |
| 6 | + | cc.client_id, |
| 7 | - | channelID NUMBER, |
| 7 | + | cc.campaign_script, |
| 8 | - | type VARCHAR2(255), |
| 8 | + | cc.object_id, |
| 9 | - | status NUMBER, |
| 9 | + | cc.type_id, |
| 10 | - | code VARCHAR2(255), |
| 10 | + | cc.status_id, |
| 11 | - | startdate DATE, |
| 11 | + | oc.obj_code, |
| 12 | - | enddate DATE, |
| 12 | + | cc.campaign_code, |
| 13 | - | nextdate DATE, |
| 13 | + | cc.campaign_begin, |
| 14 | - | state VARCHAR2(20), |
| 14 | + | cc.campaign_end, |
| 15 | - | name VARCHAR2(255), |
| 15 | + | cc.campaign_next, |
| 16 | - | itemCode VARCHAR2(255), |
| 16 | + | cc.campaign_step, |
| 17 | - | itemName VARCHAR2(255), |
| 17 | + | oc.obj_title, |
| 18 | - | itemNodeID NUMBER, |
| 18 | + | cb.node_id, |
| 19 | - | itemID NUMBER, |
| 19 | + | cb.item_id, |
| 20 | cb.channel_id | |
| 21 | - | CONSTRUCTOR FUNCTION Obj$Campaign(id NUMBER DEFAULT NULL) RETURN SELF AS RESULT, |
| 21 | + | FROM client_basket cb , |
| 22 | - | MEMBER PROCEDURE save, |
| 22 | + | client_campaign cc, |
| 23 | - | MEMBER PROCEDURE stop, |
| 23 | + | object_catalogue oc |
| 24 | - | MEMBER PROCEDURE finish, |
| 24 | + | WHERE cc.object_id = cb.item_id (+) |
| 25 | - | MEMBER PROCEDURE addCall (ProductID NUMBER, |
| 25 | + | AND cc.campaign_script = oc.obj_id (+) |
| 26 | - | Subject VARCHAR2 DEFAULT 'S300.01', |
| 26 | + | AND cc.campaign_id = id |
| 27 | - | ChannelID NUMBER DEFAULT -1, |
| 27 | + | ) |
| 28 | - | SaleID NUMBER DEFAULT NULL, |
| 28 | + | SELECT a.campaign_id, |
| 29 | - | Price NUMBER DEFAULT NULL, |
| 29 | + | a.client_id, |
| 30 | - | Discount NUMBER DEFAULT NULL, |
| 30 | + | a.campaign_script, |
| 31 | - | ProductMode NUMBER DEFAULT 1), |
| 31 | + | a.object_id, |
| 32 | - | MEMBER PROCEDURE CallComplete (Subject VARCHAR2 DEFAULT 'S300.01'), |
| 32 | + | a.type_id, |
| 33 | - | MEMBER PROCEDURE CallRelease, |
| 33 | + | a.status_id, |
| 34 | - | MEMBER FUNCTION existsCall (OnlyActive BOOLEAN DEFAULT FALSE) RETURN BOOLEAN, |
| 34 | + | a.obj_code, |
| 35 | - | MEMBER FUNCTION getOrderedItems (categoryCode VARCHAR2 DEFAULT NULL) RETURN NUMBER, |
| 35 | + | a.campaign_code, |
| 36 | - | MEMBER FUNCTION getMaxSentDate (categoryCode VARCHAR2 DEFAULT NULL) RETURN DATE, |
| 36 | + | a.campaign_begin, |
| 37 | - | MEMBER FUNCTION getSubject (subjectCode VARCHAR2 DEFAULT NULL) RETURN NUMBER, |
| 37 | + | a.campaign_end, |
| 38 | - | MEMBER FUNCTION ObjectBelongsToOffer (code VARCHAR2, fl NUMBER DEFAULT 0) RETURN BOOLEAN, |
| 38 | + | a.campaign_next, |
| 39 | - | MEMBER FUNCTION getSkipREM_1 RETURN BOOLEAN, |
| 39 | + | a.campaign_step, |
| 40 | - | MEMBER FUNCTION getMaxSubjDate (subjCode VARCHAR2) RETURN DATE, |
| 40 | + | a.obj_title, |
| 41 | - | MEMBER FUNCTION getAddTMCall RETURN NUMBER, |
| 41 | + | a.node_id, |
| 42 | - | MEMBER FUNCTION getSkipREM_1_2 RETURN BOOLEAN |
| 42 | + | a.item_id, |
| 43 | a.channel_id, | |
| 44 | NVL(c.node_code,'&'||'nbsp;'), | |
| 45 | NVL(c.node_name,'&'||'nbsp;') | |
| 46 | INTO SELF.ID, | |
| 47 | SELF.clientID, | |
| 48 | SELF.scriptID, | |
| 49 | SELF.objectID, | |
| 50 | SELF.type, | |
| 51 | SELF.status, | |
| 52 | SELF.scriptCode, | |
| 53 | SELF.code, | |
| 54 | SELF.startdate, | |
| 55 | SELF.enddate, | |
| 56 | SELF.nextdate, | |
| 57 | SELF.state, | |
| 58 | SELF.name, | |
| 59 | SELF.itemNodeID, | |
| 60 | SELF.itemID, | |
| 61 | SELF.channelID, | |
| 62 | SELF.itemCode, | |
| 63 | SELF.itemName | |
| 64 | FROM a, catalogue c | |
| 65 | WHERE a.node_id = c.node_id (+); | |
| 66 | ||
| 67 | RETURN; | |
| 68 | END Obj$Campaign; |
