示例#1
0
 function getInvIDByBarcode($barcode)
 {
     require_once PATH_ACCESS . '/DBConnect.php';
     $bookmanager = new BookManager();
     $barcode = str_replace("-", "/", $barcode);
     // replace - with /
     $barcode = preg_replace("/\\/([0-9])/", "/ \$1", $barcode);
     //add space after / when it's missing
     $barcode = str_replace("  ", " ", $barcode);
     // remove two empty spaces
     $bookData = $bookmanager->getBookDataByBarcode($barcode);
     try {
         $barcode_exploded = explode(' ', $barcode);
     } catch (Exception $e) {
     }
     if (isset($bookData["id"]) && isset($barcode_exploded[5])) {
         $query = sql_prev_inj(sprintf('book_id = %s AND year_of_purchase = %s AND exemplar = %s', $bookData["id"], $barcode_exploded[1], $barcode_exploded[5]));
         $result = parent::searchEntry($query);
         return $result['id'];
     }
 }