<?php

class InpostTracking {

    /**
     * @param $id_pack
     * @return mixed
     */
    public static function getAllPackStates($id_pack)
    {
        return Db::getInstance()->executeS('SELECT * FROM `'._DB_PREFIX_.'inpostship_pack_state` WHERE `id_pack` = '.(int)$id_pack);
    }

    /**
     * @param $id_pack
     * @param $state
     * @param $state_date
     */
    public static function addState($id_pack, $state, $state_date)
    {
        $ds = date('Y-m-d H:i:s', strtotime($state_date));
        Db::getInstance()->insert('inpostship_pack_state', array(
            'id_pack' => (int)$id_pack,
            'state' => $state,
            'date_state' => $ds,
            'date_add' => date('Y-m-d H:i:s')
        ));
    }

}