Changeset 105

Timestamp:

11/07/06 14:24:46 (2 years ago)

Author:

moensch

Message:

Change in DB layout. First page to view barcodes and change the status in new admin page.

Files:

• branches/com_mls_events/barcodes/admin.mls_events.html.php (modified) (1 diff)
• 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/lang/english.php (modified) (2 diffs)
• branches/com_mls_events/barcodes/mls_events.class.php (modified) (1 diff)
• branches/com_mls_events/barcodes/mls_events.xml (modified) (1 diff)

branches/com_mls_events/barcodes/admin.mls_events.html.php

@@ -945 +945 @@
-        }
-};
+
+/** Barcodes **/
+class HTML_MLS_events_barcodes {
+        function showBarcodes( $rows, $option ) {
+                global $l;
+                $l->setBlock("barcodes");
+                ?>
+                <form action="index2.php" method="post" name="adminForm">
+                <table class="adminheading">
+                <tr>
+                        <th>myLANsite Events: <?=$l->m("barcodes"); ?></th>
+                        <td><?=$l->m("user"); ?>:</td>
+                        <td> <?php echo $user_select; ?> </td>
+                        <td><?=$l->m("search","general"); ?>:</td>
+                        <td><input type="text" name="search" value="<?php echo $search;?>" class="text_area" onChange="document.adminForm.submit();" /></td>
+                </tr>
+                </table>
+                <table class="adminlist">
+                <tr>
+                        <th width="5">#</th>
+                        <th class="title"><input type="checkbox" name="toggle" value="" onclick="checkAll(<?php echo count($rows); ?>);" /></th>
+                        <th class="title"><?php echo $l->m("name"); ?></th>
+                        <th class="title"><?php echo $l->m("username"); ?></th>
+                        <th class="title"><?php echo $l->m("code"); ?></th>
+                        <th align="center" width="40"><?=$l->m("status"); ?></th>
+                        <th class="title" width="110"><?=$l->m("lastupdate"); ?></th>
+                </tr>
+                <?php
+                $k = 0;
+                for ($i=0, $n=count($rows); $i < $n; $i++) {
+                        $row = $rows[$i];
+                        $img_status = $row->status ? 'tick.png' : 'publish_x.png';
+                        $task_status = $row->status ? 'disable' : 'enable';
+                        $row->lastupdate = $row->lastupdate > 0 ? $row->lastupdate : "";
+                        ?>
+                        <tr class="<?php echo "row$k"; ?>">
+                                <td align="center"><?php echo $i+1+$pageNav->limitstart; ?></td>
+                                <td><input type="checkbox" id="cb<?php echo $i;?>" name="cid[]" value="<?php echo $row->id; ?>" onclick="isChecked(this.checked);" /></td>
+                                <td><a href="#edit" onclick="return listItemTask('cb<?php echo $i;?>','edit')"><?php echo $row->eventname; ?></a></td>
+                                <td><?php echo $row->name; ?></td>
+                                <td><?php echo $row->username; ?></td>
+                                <td><?php echo $row->code; ?></td>
+                                <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>
+                                <td><?php echo $row->lastupdate; ?></td>
+                        </tr>
+                        <?php
+                        $k = 1 - $k;
+                }
+                ?>
+                </table>
+                <?php echo $pageNav->getListFooter(); ?>
+                <input type="hidden" name="option" value="<?php echo $option; ?>" />
+                <input type="hidden" name="act" value="<?php echo $act; ?>" />
+                <input type="hidden" name="task" value="" />
+                <input type="hidden" name="boxchecked" value="0" />
+                </form>
+                <?php
+                HTML_MLS::printFooter($option);
+        }
+}
+
-/** Configuration **/
-class HTML_MLS_events_config {

branches/com_mls_events/barcodes/admin.mls_events.php

@@ -185 +185 @@
-                }
-                break;
+        case "barcodes":
+                switch($task) {
+                        case "checkout":
+                                checkoutformMLS_events_barcodes( $option, $act );
+                                break;
+                        case "checkin":
+                                checkinformMLS_events_barcodes( $option, $act );
+                                break;
+                        case "enable":
+                                changeMLS_events_barcodes( $cid[0], 1, $option, $act );
+                                break;
+                        case "disable":
+                                changeMLS_events_barcodes( $cid[0], 0, $option, $act );
+                                break;
+                        default:
+                                showMLS_events_barcodes( $option, $act );
+                                break;
+                }
-        default:
-                switch($task) {
@@ -241 +259 @@
-}
-
+/** Barcodes **/
+function showMLS_events_barcodes( $option, $act ) {
+        global $database, $l;
+        
+        $database->setQuery( "SELECT u.name, u.username, u.email, c.* FROM `#__mls_events_barcodes` AS `c`"
+                                                                                        ."\n INNER JOIN `#__users` AS `u` ON u.id=c.userid"
+                                                                                        ."\n ORDER BY u.username ASC" );
+        $rows = $database->loadObjectList();
+        HTML_MLS_events_barcodes::showBarcodes( $rows, $option );
+        
+}
+
+function changeMLS_events_barcodes( $cid, $status, $option, $act ) {
+        global $database, $mosConfig_offset;
+        $time = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 );
+        $query = "UPDATE `#__mls_events_barcodes` SET `status`='".$status."' AND `lastupdate`='".$time."' WHERE `id` = '".$cid."'";
+        $database->setQuery($query);
+        $database->query();
+        
+        mosRedirect( "index2.php?option=$option&mosmsg=".urlencode($l->m("msg_status_changed","general")) );
+}
+
+function checkinformMLS_events_barcodes( $option ) {
+        global $database;
+}
+
+function checkoutformMLS_events_barcodes( $option ) {
+        global $database;
+}
+
+/** Events **/
-function showMLS_events($option) {
-        global $database,$mainframe;

branches/com_mls_events/barcodes/install/comupgrade.xml

@@ -64 +64 @@
-  `checkout_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `comments` MEDIUMTEXT NOT NULL,
-  `barcode` smallint(12) unsigned zerofill NOT NULL default '000000000000',
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM;</query>
+                <query>DROP TABLE IF EXISTS `#__mls_events_barcodes`</query>
+                <query>CREATE TABLE `#__mls_events_barcodes` (
+`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
+`code` SMALLINT( 12 ) UNSIGNED ZEROFILL NOT NULL ,
+`userid` MEDIUMINT( 11 ) NOT NULL ,
+`status` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
+`lastupdate` DATETIME NOT NULL ,
+PRIMARY KEY ( `id` )
+) TYPE = MYISAM;</query>
-                <query>DROP TABLE IF EXISTS `#__mls_events_reviews`</query>
-                <query>CREATE TABLE `#__mls_events_reviews` (
@@ -147 +155 @@
-                <version number="0.1.4" date="20060911" />
-                <version number="0.1.4-barcodes-RC1" date="20061107">
-
+
+
+
+
+
+
+
+
-                </version>
-        </upgrade>

branches/com_mls_events/barcodes/lang/english.php

@@ -45 +45 @@
-                "err_coupon_pending" => "This coupon is not yet active. Please try again later!",
-                "details" => "Details",
-
+
+
-
-$lang_data["events"] = array(
@@ -230 +231 @@
-                "back_to_details" => "Back to Event Details");
-
+$lang_data["barcodes"] = array(
+                "barcodes" => "Barcodes",
+                "user" => "User",
+                "search" => "Search",
+                "name" => "Name",
+                "username" => "Username",
+                "email" => "Email",
+                "code" => "Code",
+                "status" => "Status",
+                "lastupdate" => "Last Update");
+
-?>

branches/com_mls_events/barcodes/mls_events.class.php

@@ -324 +324 @@
-        }
-};
+
+/**
+* MLS Event Times table class
+*/
+class mosMLS_events_barcode extends mosDBTable {
+        /** @var int Primary key */
+        var $id=null;
+        /** @var int */
+        var $code=null;
+        /** @var int */
+        var $userid=null;
+        /** @var int */
+        var $status=null;
+        /** @var date */
+        var $lastupdate=null;
+        
+        /**
+        * @param database A database connector object
+        */
+        function mosMLS_events_barcode( &$db ) {
+                $this->mosDBTable( '#__mls_events_barcodes', 'id', $db );
+        }
-?>

branches/com_mls_events/barcodes/mls_events.xml

@@ -29 +29 @@
-                        <menu act="times">Times</menu>
-                        <menu act="coupons">Coupons</menu>
+                        <menu act="barcodes">Barcodes</menu>
-                        <menu act="configuration">Configuration</menu>
-                </submenu>