With the publication of the QR generation, some of the PHPRunner users have had the need to have a 1-dimensional barcode, Code 128, which is the one that the articles have and that stores and warehouses use to identify the item.
objective
Create 1D barcode images and store them in the file management that PHPrunner does, exactly as if we had used the application to load it into the system.
Solution
For the creation of this type of images I have used the PHP libraries at https://github.com/picqer/php-barcode-generator.
DEMO: https://fhumanes.com/barcode/
It's simple and has a huge set of 1D codes.
In the example, both in the Registration and in the Edition of the record, what it does is create a 1D barcode with the content of the "Text" field and the type of graph chosen.
The code that makes the image and saves it is:
<?php
// https://github.com/picqer/php-barcode-generator , source of Code
/*
Occurs after record was updated or added
$values - array of values has been written to the database.
To access specific field value use $values["FieldName"]
"dict" is an alternate name for this parameter.
$where - WHERE clause that points to the edited record. Example: ID=19
$oldvalues - array with replaced field values. To access specific column value use
$oldvalues["FieldName"]
$keys - array of key column values that point to the edited record. To access
specific key column use $keys["KeyFieldName"]
$inline - equals to true when the Inline Edit in process, false otherwise
$pageObject - an object of Page class representing the current page
*/
global $conn;
// Barcode "type" retrieval
$id_type = $values['prueba_barcode_type_idprueba_barcode_type'];
$sql = "SELECT Type FROM prueba_barcode_type WHERE idprueba_barcode_type = $id_type";
$rs = $conn->query($sql);
$data = $rs->fetch_assoc();
$type = $data['Type'];
// Load the barcode library classes
require_once __DIR__ . '/php-barcode-generator_2.0.1/autoload.php';
// Save it to a file
$fileName = 'Barcode_'.$values['idprueba_barcode'].'.png';
$file = substr(__DIR__, 0, -6); // root of file
$file = $file.'files/'.$fileName;
$Color = [0, 0, 0]; // Black
$generator = new Picqer\Barcode\BarcodeGeneratorPNG();
file_put_contents($file, $generator->getBarcode($values['Text'], $type, 2, 25, $Color));
/*
The getBarcode() method accepts the following parameters:
$barcode - String needed to encode in the barcode
$type - Type of barcode, use the constants defined in the class
$widthFactor - Width is based on the length of the data, with this factor you can make the barcode bars wider than default
$height - The total height of the barcode in pixels
$foregroundColor - Hex code as string, or array of RGB, of the colors of the bars (the foreground color)
*/
// Save the new file in Database
$size = filesize($file);
$fileArray = [];
$fileArray[0][name]= 'files\/'.$fileName;
$fileArray[0][usrName]= $fileName;
$fileArray[0][size]= $size;
$fileArray[0][type]= 'image\/png';
$fileArray[0][searchStr] = $fileName.',!:sStrEnd';
$fileFileSystem=my_json_encode($fileArray);
// Update in DB the file
$id_key = $values['idprueba_barcode'];
$sql="Update prueba_barcode set File = '$fileFileSystem' where idprueba_barcode = $id_key";
$res=db_exec($sql,$conn);
As always, any questions you can contact me at fernandohumanes@gmail.com
I leave you, in my portal, the files that you will need, if you want to reproduce it on your computers.
fhumanes author