Assembla home | Assembla project page
 

Changeset 120

Show
Ignore:
Timestamp:
11/10/06 11:09:13 (2 years ago)
Author:
moensch
Message:

Check if a barcode exists on checkin.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

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

    r119 r120  
    310310        global $database, $l, $mainframe, $mosConfig_absolute_path, $cnf_mls_events; 
    311311        // First, get through the user stuff 
    312         $userid = mosGetParam($_POST, 'userid', NULL); 
    313         $eventid = mosGetParam($_POST, 'eventid', NULL); 
     312        $userid = mosGetParam($_REQUEST, 'userid', NULL); 
     313        $eventid = mosGetParam($_REQUEST, 'eventid', NULL); 
    314314        $barcode = mosGetParam($_POST, 'barcode', NULL); 
    315315        $search_user = mosGetParam($_POST, 'search_user', NULL); 
    …… 
    376376        //Save barcodes 
    377377        $barcodecount = 0; 
     378        $goodcodes = array(); 
    378379        foreach($barcodes as $code) { 
    379380                if($code) { 
    380381                        $barcodecount++; 
    381                         $time = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 ); 
    382                         $query = "INSERT INTO `#__mls_events_barcodes` (`id`,`code`,`userid`,`status`,`lastupdate`) VALUES ('','".$code."','".$userid."','1','".$time."')"; 
    383                         $database->setQuery( $query ); 
    384                         $database->query(); 
    385                 } 
     382                        $database->setQuery( "SELECT COUNT(*) FROM `#__mls_events_barcodes` WHERE `code`='".$code."'" ); 
     383                        if(!$database->loadResult()) { 
     384                                $goodcodes[] = $code; 
     385                        } else { 
     386                                mosRedirect( "index2.php?option=$option&act=$act&task=search&userid=$userid&eventid=$eventid", sprintf($l->m("err_barcode_in_use","general"), $code) ); 
     387                        } 
     388                } 
     389        } 
     390         
     391        foreach($goodcodes as $code) { 
     392                $time = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 ); 
     393                $query = "INSERT INTO `#__mls_events_barcodes` (`id`,`code`,`userid`,`status`,`lastupdate`) VALUES ('','".$code."','".$userid."','1','".$time."')"; 
     394                $database->setQuery( $query ); 
     395                $database->query(); 
    386396        } 
    387397         

  • branches/com_mls_events/barcodes/lang/english.php

    r117 r120  
    5555                "msg_user_checked_out" => "The user has been checked out!", 
    5656                "msg_user_checked_out_payback" => "The user has been checked out! Please Pay %s back to user!", 
    57                 "msg_code_wrong" => "This code is not assigned to this user or does not exist in the database!"); 
     57                "msg_code_wrong" => "This code is not assigned to this user or does not exist in the database!", 
     58                "err_barcode_in_use" => "This barcode is already in use: %s"); 
    5859 
    5960$lang_data["events"] = array(