<?php

class IvtBillPositionProductModel {

    public static function create(Array $data) {
        throw new Exception("Please use IvtBillPositionProductController to create IvtBillPositionProducts");
    }

    public static function getAll() {
        $items = [];

        $db = FronkDB::singleton(IVT_DBHOST, IVT_DBUSER, IVT_DBPASS, IVT_DBNAME);

        $res = $db->select("bills_positions_products", "*", "1=1 ORDER BY id");
        if($db->num_rows($res)) {
            while($data = $db->fetch_object($res)) {
                $items[] = new IvtBillPositionProduct($data);
            }
        }
        return $items;
    }

    public static function getFirst($filter = []) {
        $db = FronkDB::singleton(IVT_DBHOST, IVT_DBUSER, IVT_DBPASS, IVT_DBNAME);

        $where = self::getSqlFilter($filter);
        $res = $db->select("bills_positions_products", "*", "$where ORDER BY id LIMIT 1");
        if($db->num_rows($res)) {
            $data = $db->fetch_object($res);
            $item = new IvtBillPositionProduct($data);
            if($item->id) {
                return $item;
            } else {
                return null;
            }
        }
        return null;
    }

    public static function getLast($filter = []) {
        $db = FronkDB::singleton(IVT_DBHOST, IVT_DBUSER, IVT_DBPASS, IVT_DBNAME);

        $where = self::getSqlFilter($filter);
        $res = $db->select("bills_positions_products", "*", "$where ORDER BY id DESC LIMIT 1");
        if($db->num_rows($res)) {
            $data = $db->fetch_object($res);
            $item = new IvtBillPositionProduct($data);
            if($item->id) {
                return $item;
            } else {
                return null;
            }
        }
        return null;
    }

    public static function search($filter, $limit = false) {
        $items = [];
        $db = FronkDB::singleton(IVT_DBHOST, IVT_DBUSER, IVT_DBPASS, IVT_DBNAME);

        $where = self::getSqlFilter($filter);
        $sql = "SELECT * FROM bills_positions_products WHERE $where ORDER by id";

        mfLoghandler::singleton()->debug($sql);
        if(is_array($limit) && count($limit)) {
            if(is_numeric($limit['start']) && is_numeric($limit['count'])) {
                $sql .= " LIMIT ".$limit['start'].", ".$limit['count'];
            } elseif(is_numeric($limit['count'])) {
                $sql .= " LIMIT ".$limit['count'];
            }
        }

        $res = $db->query($sql);
        if($db->num_rows($res)) {
            while($data = $db->fetch_object($res)) {
                $items[] = new IvtBillPositionProduct($data);
            }
        }
        return $items;
    }

    private static function getSqlFilter($filter) {
        $where = "1=1 ";

        if(array_key_exists("bid", $filter)) {
            $bid = $filter['bid'];
            if($bid) {
                $where .= " AND bid='$bid'";
            }
        }


        /*
        if(array_key_exists("status_id", $filter)) {
          $status_id = $filter['status_id'];
          if(is_numeric($status_id)) {
            $where .= " AND IvtBillPositionProduct.status_id=$status_id";
          }
        }


        if(array_key_exists("street", $filter)) {
          $street = FronkDB::singleton()->escape($filter["street"]);
          if($street) {
            $where .= " AND street like '%$street%'";
          }
        }
        */

        //var_dump($filter, $where);exit;
        return $where;
    }

}