Changeset 107
- Timestamp:
- 11/07/06 15:19:03 (2 years ago)
- Files:
-
- branches/com_mls_events/barcodes/admin.mls_events.html.php (modified) (4 diffs)
- branches/com_mls_events/barcodes/admin.mls_events.php (modified) (2 diffs)
- branches/com_mls_events/barcodes/install/comupgrade.xml (modified) (2 diffs)
- branches/com_mls_events/barcodes/mls_events.class.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
branches/com_mls_events/barcodes/admin.mls_events.html.php
r106 r107 30 30 array_unshift($opt,mosHTML::makeOption('0', $l->m("select_event","general"))); 31 31 $ret = mosHTML::selectList($opt, 'eventid_filter', ' class="inputbox" size="1" onchange="document.adminForm.submit();"', 'value', 'text', $eventid_filter); 32 33 return $ret; 34 } 35 36 function showUserSelect($userid_filter = 0, $option, $act) { 37 global $database, $l; 38 $row = new mosMLS_events($database); 39 $database->setQuery( "SELECT `id` AS `value`, CONCAT(`name`, ' (', `username`, ')') AS `text` FROM `#__users` ORDER BY `name` ASC" ); 40 $opt = $database->loadObjectList(); 41 array_unshift($opt,mosHTML::makeOption('0', $l->m("select_user","general"))); 42 $ret = mosHTML::selectList($opt, 'userid_filter', ' class="inputbox" size="1" onchange="document.adminForm.submit();"', 'value', 'text', $userid_filter); 32 43 33 44 return $ret; … … 948 959 /** Barcodes **/ 949 960 class HTML_MLS_events_barcodes { 950 function showBarcodes( $rows, $ option) {961 function showBarcodes( $rows, $pageNav, $user_select, $search, $option, $act ) { 951 962 global $l; 952 963 $l->setBlock("barcodes"); … … 968 979 <th class="title"><?php echo $l->m("name"); ?></th> 969 980 <th class="title"><?php echo $l->m("username"); ?></th> 981 <th class="title"><?php echo $l->m("email"); ?></th> 970 982 <th class="title"><?php echo $l->m("code"); ?></th> 971 983 <th align="center" width="40"><?=$l->m("status"); ?></th> … … 985 997 <td><?php echo $row->name; ?></td> 986 998 <td><?php echo $row->username; ?></td> 999 <td><?php echo $row->email; ?></td> 987 1000 <td><?php echo $row->code; ?></td> 988 1001 <td align="center"><a href="javascript: void(0);" onClick="return listItemTask('cb<?php echo $i;?>','<?php echo $task_status;?>')"><img src="images/<?php echo $img_status;?>" width="12" height="12" border="0" alt="" /></a></td> branches/com_mls_events/barcodes/admin.mls_events.php
r105 r107 203 203 break; 204 204 } 205 break; 205 206 default: 206 207 switch($task) { … … 261 262 /** Barcodes **/ 262 263 function showMLS_events_barcodes( $option, $act ) { 263 global $database, $l; 264 global $database, $l, $mainframe; 265 $limit = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', 10 ); 266 $limitstart = $mainframe->getUserStateFromRequest( "view{$option}limitstart", 'limitstart', 0 ); 267 $search = $mainframe->getUserStateFromRequest( "search{$option}", 'search', '' ); 268 $search = $database->getEscaped( trim( strtolower( $search ) ) ); 269 $userid = $mainframe->getUserStateFromRequest( "filter_id{$option}", 'userid_filter', 0 ); 270 271 $where = ""; 272 $words = explode(" ",$search); 273 foreach($words as $word) { 274 if($word) { 275 $op = $where ? "AND" : "WHERE"; 276 $where .= " $op (u.name LIKE '%$word%' OR u.username LIKE '%$word%' OR c.code LIKE '%$word%' OR u.email LIKE '%$word%')"; 277 } 278 } 279 $op = $where ? "AND" : "WHERE"; 280 $where .= $userid ? " $op u.id = '$userid'" : ""; 281 282 // get the total number of records 283 $database->setQuery( "SELECT COUNT(*) FROM `#__mls_events_barcodes` AS `c`" 284 ."\n INNER JOIN `#__users` AS `u` ON u.id=c.userid $where" ); 285 $total = $database->loadResult(); 286 287 require_once( "includes/pageNavigation.php" ); 288 $pageNav = new mosPageNav( $total, $limitstart, $limit ); 264 289 265 290 $database->setQuery( "SELECT u.name, u.username, u.email, c.* FROM `#__mls_events_barcodes` AS `c`" 266 ."\n INNER JOIN `#__users` AS `u` ON u.id=c.userid" 267 ."\n ORDER BY u.username ASC" ); 291 ."\n INNER JOIN `#__users` AS `u` ON u.id=c.userid $where" 292 ."\n ORDER BY u.username ASC" 293 ."\n LIMIT $pageNav->limitstart, $pageNav->limit" ); 268 294 $rows = $database->loadObjectList(); 269 HTML_MLS_events_barcodes::showBarcodes( $rows, $option ); 295 296 // Select lists 297 $user_select = HTML_MLS::showUserSelect( $userid, $option, $act ); 298 299 HTML_MLS_events_barcodes::showBarcodes( $rows, $pageNav, $user_select, $search, $option, $act ); 270 300 271 301 } 272 302 273 303 function changeMLS_events_barcodes( $cid, $status, $option, $act ) { 274 global $database, $mosConfig_offset ;304 global $database, $mosConfig_offset, $l; 275 305 $time = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 ); 276 $query = "UPDATE `#__mls_events_barcodes` SET `status`='".$status."' AND`lastupdate`='".$time."' WHERE `id` = '".$cid."'";306 $query = "UPDATE `#__mls_events_barcodes` SET `status`='".$status."', `lastupdate`='".$time."' WHERE `id` = '".$cid."'"; 277 307 $database->setQuery($query); 278 308 $database->query(); 279 309 280 mosRedirect( "index2.php?option=$option& mosmsg=".urlencode($l->m("msg_status_changed","general")) );310 mosRedirect( "index2.php?option=$option&act=$act&&mosmsg=".urlencode($l->m("msg_status_changed","general")) ); 281 311 } 282 312 branches/com_mls_events/barcodes/install/comupgrade.xml
r105 r107 70 70 `id` INT( 11 ) NOT NULL AUTO_INCREMENT , 71 71 `code` SMALLINT( 12 ) UNSIGNED ZEROFILL NOT NULL , 72 `userid` MEDIUMINT( 11 ) NOT NULL ,72 `userid` BIGINT( 11 ) NOT NULL , 73 73 `status` TINYINT( 1 ) DEFAULT '1' NOT NULL , 74 74 `lastupdate` DATETIME NOT NULL , … … 158 158 `id` INT( 11 ) NOT NULL AUTO_INCREMENT , 159 159 `code` SMALLINT( 12 ) UNSIGNED ZEROFILL NOT NULL , 160 `userid` MEDIUMINT( 11 ) NOT NULL ,160 `userid` BIGINT( 11 ) NOT NULL , 161 161 `status` TINYINT( 1 ) DEFAULT '1' NOT NULL , 162 162 `lastupdate` DATETIME NOT NULL , branches/com_mls_events/barcodes/mls_events.class.php
r105 r107 346 346 $this->mosDBTable( '#__mls_events_barcodes', 'id', $db ); 347 347 } 348 }; 348 349 ?>
