<?php

class Opiniarbo_model extends Model {

    function Opiniarbo_model()

    {

        parent::Model();

    }

    function get_my_heads($user)

    {

        $query = $this->db->get_where('asertoj',

            array('user' => $user, 'parent' => NULL));

        return $query->result();

    }

    function get_other_heads($user)

    {

        $query = $this->db->get_where('asertoj',

            array('user !=' => $user, 'parent' => NULL));

        return $query->result();

    }

    function get_my_subasserts($parent, $user)

    {

        $query = $this->db->get_where('asertoj',

            array('user' => $user,

                  'parent' => $parent));

        return $query->result();

    }

    function get_other_subasserts($parent, $user)

    {

        $query = $this->db->get_where('asertoj',

            array('user !=' => $user,

                  'parent' => $parent));

        return $query->result();

    }

    function get_calc_value($assert, $orig_value)

    {

        $query = $this->db->get_where('asertoj',

            array('parent' => $assert));

        if ($query->num_rows() > 0)

        {

            $val = 0;

            foreach($query->result() as $row)

            {

                $val += get_calc_value($row->id, $row->value);

            }

            $query2 = $this->db->where('id', $row->id);

            $query2->update('asertoj', array(

                'calc_value' => $val));

            return $val;

        }

        return $orig_value;

    }

    function recalculate()

    {

        // Get all heads

        get_calc_value(NULL, 0);

    }

    function insert_assertion()

    {

        if (isset($_POST['parent']))

        {

            $data['parent'] = $_POST['parent'];

            $data['influence'] = $_POST['influence'];

        }

        else

        {

            $data['parent'] = NULL;

            $data['influence'] = $_POST['influence'];

        }

        $data['assert'] = $_POST['assert'];

        $data['context'] = $_POST['context'];

        $data['value'] = float($_POST['value']);

    }

}

?>