1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
<?php
/**
* $Header: /cvsroot/bitweaver/_bit_newsletters/BitNewsletterEdition.php,v 1.2 2005/12/10 22:39:53 spiderr Exp $
*
* Copyright (c) 2004 bitweaver.org
* All Rights Reserved. See copyright.txt for details and a complete list of authors.
* Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details
*
* $Id: BitNewsletterEdition.php,v 1.2 2005/12/10 22:39:53 spiderr Exp $
*
* Virtual base class (as much as one can have such things in PHP) for all
* derived tikiwiki classes that require database access.
* @package blogs
*
* created 2004/10/20
*
* @author drewslater <andrew@andrewslater.com>, spiderr <spider@steelsun.com>
*
* @version $Revision: 1.2 $ $Date: 2005/12/10 22:39:53 $ $Author: spiderr $
*/
/**
* required setup
*/
require_once( NEWSLETTERS_PKG_PATH.'BitNewsletter.php' );
require_once( LIBERTY_PKG_PATH.'LibertyContent.php' );
define( 'BITNEWSLETTEREDITION_CONTENT_TYPE_GUID', 'bitnewsletteredn' );
class BitNewsletterEdition extends LibertyContent {
function BitNewsletterEdition( $pEditionId=NULL, $pContentId=NULL, $pNlId=NULL ) {
parent::LibertyContent();
$this->registerContentType( BITNEWSLETTEREDITION_CONTENT_TYPE_GUID, array(
'content_type_guid' => BITNEWSLETTEREDITION_CONTENT_TYPE_GUID,
'content_description' => 'Newsletter',
'handler_class' => 'BitNewsletter',
'handler_package' => 'newsletters',
'handler_file' => 'BitNewsletter.php',
'maintainer_url' => 'http://www.bitweaver.org'
) );
$this->mEditionId = $pEditionId;
$this->mContentId = $pContentId;
$this->mContentTypeGuid = BITNEWSLETTEREDITION_CONTENT_TYPE_GUID;
$this->mNewsletter = new BitNewsletter( $pNlId );
}
function verify( &$pParamHash ) {
if( !empty( $pParamHash['nl_id'] ) ) {
$pParamHash['edition_store']["nl_id"] = $pParamHash['nl_id'];
} else {
$this->mErrors['nl_id'] = tra( 'No newsletter was selected for this edition.' );
}
return( count( $this->mErrors ) == 0 );
}
function store( $pParamHash ) {
if( $this->verify( $pParamHash ) ) {
$this->mDb->StartTrans();
if( parent::store( $pParamHash ) ) {
if( $this->mEditionId ) {
$result = $this->mDb->associateUpdate( BIT_DB_PREFIX."tiki_newsletters_editions", $pParamHash['edition_store'], array ( "name" => "edition_id", "value" => $this->mEditionId ) );
} else {
$pParamHash['edition_store']['content_id'] = $pParamHash['content_id'];
$result = $this->mDb->associateInsert( BIT_DB_PREFIX."tiki_newsletters_editions", $pParamHash['edition_store'] );
}
$this->mDb->CompleteTrans();
} else {
$this->mDb->RollbackTrans();
}
}
return( count( $this->mErrors ) == 0 );
}
function load() {
if( !empty( $this->mNlId ) || !empty( $this->mContentId ) ) {
global $gBitSystem;
$bindVars = array(); $selectSql = ''; $joinSql = ''; $whereSql = '';
$lookupColumn = !empty( $this->mNlId )? 'nl_id' : 'content_id';
$lookupId = !empty( $this->mNlId )? $this->mNlId : $this->mContentId;
array_push( $bindVars, $lookupId );
$this->getServicesSql( 'content_load_function', $selectSql, $joinSql, $whereSql, $bindVars );
$query = "SELECT *
FROM `".BIT_DB_PREFIX."tiki_newsletters_editions` tne
INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tne.`content_id`=tc.`content_id` )
WHERE `$lookupColumn`=? $whereSql";
$result = $this->mDb->query($query,$bindVars);
if ($result->numRows()) {
$this->mInfo = $result->fetchRow();
$this->mNlId = $this->mInfo['nl_id'];
$this->mContentId = $this->mInfo['content_id'];
$this->mNewsletter = new BitNewsletter( $this->mInfo['nl_id'] );
}
}
return( count( $this->mInfo ) );
}
function getList( &$pListHash ) {
$bindVars = array();
$this->prepGetList( $pListHash );
$mid = '';
if( $pListHash['find'] ) {
$findesc = '%' . $pListHash['find'] . '%';
$mid = " WHERE (tc.`title` like ? or tc.`data` like ?)";
$bindVars[] = $findesc;
$bindVars[] = $findesc;
}
$query = "SELECT `edition_id` AS `has_key`, *
FROM `".BIT_DB_PREFIX."tiki_newsletters` tn
INNER JOIN `".BIT_DB_PREFIX."tiki_content` tc ON( tc.`content_id`=tn.`content_id` )
INNER JOIN `".BIT_DB_PREFIX."tiki_newsletters_editions` tsn ON( tn.`nl_id`=tsn.`nl_id` )
$mid ORDER BY ".$this->mDb->convert_sortmode( $pListHash['sort_mode'] );
$query_cant = "select count(*) from `".BIT_DB_PREFIX."tiki_newsletters` tn, `".BIT_DB_PREFIX."tiki_newsletters_editions` tsn where tn.`nl_id`=tsn.`nl_id` $mid";
$ret = $this->mDb->getAssoc( $query, $bindVars, $pListHash['max_records'], $pListHash['offset'] );
$pListHash['total_records'] = $this->mDb->getOne( $query_cant, $bindVars );
$pListHash['block_pages'] = 5;
$pListHash['total_pages'] = ceil( $pListHash['total_records'] / $pListHash['max_records'] );
$pListHash['current_page'] = (!empty( $pListHash['offset'] ) ? floor( $pListHash['offset'] / $pListHash['max_records'] ) + 1 : 1 );
return $ret;
}
function remove_edition($edition_id) {
$query = "delete from `".BIT_DB_PREFIX."tiki_newsletters_editions` where `edition_id`=$edition_id";
$result = $this->mDb->query($query,array((int)$edition_id));
}
}
?>
|
