<?php

class item extends _list {
    protected $entity = "ess_item";
    
    
    public function getData () {
        $id = intval($_POST['id']??'');
        $data = array();
        
        if (strlen ($id) > 0) {
            
            // Block, label, text, name
            try {
                $stmt = $this->PDO->prepare("SELECT name, label, txt, block FROM l_ess_item WHERE id=:id");
                $stmt->bindParam(':id', $id, PDO::PARAM_INT);
                $stmt->execute();

                if ($r = $stmt->fetch(PDO::FETCH_ASSOC)) {
                    $data = $r;
                }
            }
            catch (exception $ex) {
                common::except ('Err: ' .$ex .' in ' .__DIR__ .'/' .__FILE__ .':' .__LINE__);
            }
            
        }
        return $data;
    }
    
    public function listAll() {
        
        // returns an array of all
        
        try {
            $stmt = $this->PDO->prepare("SELECT id, CONCAT(name, ' (', substring(label, 1, 80), IF(LENGTH(label)>80,'...',''), ')') as name FROM l_" .$this->entity ." ORDER BY id ASC");
            $stmt->execute();
            
            if ($r = $stmt->fetchAll(PDO::FETCH_ASSOC)) {
                return $r;
            }
        }
        catch (exception $ex) {
            common::except ('Err: ' .$ex .' in ' .__DIR__ .'/' .__FILE__ .':' .__LINE__);
            return false;
        }          
    }
    
    
    
}