phpengine/src/Modules/Blank/Pages.php

<?php
/**
 * Created by PhpStorm.
 * User: Giancarlo
 * Date: 11/10/2018
 * Time: 15:25
 */

namespace Modules\Blank;

use Base;
use OpenMind\FindBox\QueueCommand;
use OpenMind\System\QueueSystem;
use OpenMind\Web\Controller;
use Template;

class Pages extends Controller
{

	/**
	 * @param Base $f3
	 */
	public function HelloWorld($f3)
	{
		$f3->set('MESSAGE', 'Hello World');
		$f3->set('CONTENT', 'message.tpl');
		echo Template::instance()->render('masterpage.tpl');
	}

	public function BlinkON(array $labels)
	{
		$qs = new QueueSystem();
		$cmd = new QueueCommand($labels);
		$cmd->setLeds(2, 1, 1000, 300, 1);
		$qs->send($cmd);
	}

	public function BlinkOFF(array $labels)
	{
		$qs = new QueueSystem();
		$cmd = new QueueCommand($labels);
		$cmd->setToBlinkOff();
		$qs->send($cmd);
	}

	public function BlinkONW(array $labels)
	{
		$qs = new QueueSystem();
		$cmd = new QueueCommand($labels);
		$cmd->setLeds(2, 1, 1000, 300, 0);
		$qs->send($cmd);
	}
	
	public function PickinglistController($f3)
	{
		header('Content-Type: application/json');

		$postData = $this->getSanitizedPostRequest();

		switch ($postData['action']) {
			case 'getData':
				echo $this->getTableData();
				return;
				break;

			case 'saveall':
				$ret = $this->SaveProduct();
				if ($ret) {
					echo $ret;
					return;
				}
				break;

			case 'edit':
				$label = new Mapper($f3->get('DB'), 'label_bindings');
				$label->load(['label_id=?', $postData['label_id']]);
				$label->takt = $postData['takt'];
				$label->save();

				$kanban = new Mapper($f3->get('DB'), 'anagraficakanbanlist');
				$kanban->load(['id=?', $postData['id']]);
				$kanban->MATNR = $postData['codArticolo'];
				$kanban->MAKTX = $postData['descrizione'];
				$kanban->LGPLA = $postData['ubicazione'];
				$kanban->save();
				$ret = $this->SaveProduct($postData['codArticolo']);
				if ($ret) {
					echo $ret;
					return;
				}
				break;

			case 'delete':
				$kanban = new Mapper($f3->get('DB'), 'anagraficakanbanlist');
				$kanban->load(['id=?', $postData['id']]);
				$kanban->erase();
				break;

		}
		echo json_encode([
			'code' => 0,
			'err' => 'Success'
		]);

	}

	private function getTableData(): string
	{
		global $f3;

		$data = $f3->get('DB')->exec("SELECT * FROM pickinglist");

		$data2 = array_map(function ($v) {
			return array_values($v);
		}, $data);

		return json_encode($data2);
	}

}