Anticipation Class Reference

Manage the anticipation of expense, sales,... More...

Collaboration diagram for Anticipation:

Public Member Functions
	__construct ($p_init, $p_id=0)
	constructor
	display ()
	Display the result of the forecast.
	getCat ()
	getForecastId ()
	getItem ()
	input_category ()
	input_form ()
	display the detail for the forecast , for modifying item, category or name
	input_title ()
	object_clone ()
	Clone completely Forecast and returns the new forecast_id.
	setCat ($cat)
	setForecastId ($forecast_id)
	setItem ($item)

Static Public Member Functions
static	div ()

Data Fields
	$cat
	$item

Private Attributes
	$cn
	$forecast_id
	forecast.f_id

Detailed Description

Manage the anticipation of expense, sales,...

See also

Forecast Forecast_Cat Forecast_Item

Definition at line 35 of file anticipation.class.php.

Constructor & Destructor Documentation

__construct()

Anticipation::__construct	(		$p_init,
			$p_id = 0 )

constructor

Parameters

$p_init

Database object

Definition at line 47 of file anticipation.class.php.

    {
        $this->cn = $p_init;
        $this->forecast_id = $p_id;
    }

References $p_id, and cn.

Member Function Documentation

display()

Anticipation::display

(

)

Display the result of the forecast.

Parameters

$p_periode

Returns

HTML String with the code

Definition at line 183 of file anticipation.class.php.

    {
        bcscale(4);
        $forecast = new Forecast_SQL($this->cn, $this->forecast_id);
        $forecast->load();
        $str_name = h($forecast->getp('f_name'));
 
        $start = $forecast->getp('f_start_date');
        $end = $forecast->getp('f_end_date');
 
        if ($start == '') throw new Exception (_('Période de début non valable'));
        if ($end == '') throw new Exception (_('Période de fin non valable'));
 
        $per = new Periode($this->cn, $start);
        $str_start = format_date($per->first_day());
 
        $per = new Periode($this->cn, $end);
        $str_end = format_date($per->last_day());
 
 
        $r = "";
        $aCat = $this->cn->get_array('select fc_id,fc_desc from forecast_category where f_id=$1 order by fc_order',
                array($this->forecast_id));
        $aItem = array();
        $aReal = array();
        $poste = new Acc_Account_Ledger($this->cn, 0);
 
        $aPeriode = $this->cn->get_array("select p_id,to_char(p_start,'MM.YYYY') as myear from parm_periode
                                         where p_start >= (select p_start from parm_periode where p_id=$1)
                                         and p_end <= (select p_end from parm_periode where p_id=$2)
                                         order by p_start",[$start,$end]);
        $error = array();
        for ($j = 0; $j < count($aCat); $j++) {
            
            // Item of the category,montly estimation
            $aItem[$j] = $this->cn->get_array('select fi_account,fi_text,fi_amount,
                fi_amount_initial
                   from forecast_item where fc_id=$1  and fi_pid=0 order by fi_order ', 
                    array($aCat[$j]['fc_id']));
            
            // Item of the category,  estimation for a specific month
            $aPerMonth[$j] = $this->cn->get_array('select fi_pid,fi_account,fi_text,fi_amount
                    from forecast_item where fc_id=$1 and fi_pid !=0 order by fi_order ', 
                    array($aCat[$j]['fc_id']));
 
            /* compute the real amount for periode */
            for ($k = 0; $k < count($aItem[$j]); $k++) {
                /* for each periode */
                for ($l = 0; $l < count($aPeriode); $l++) {
                    if ($aItem[$j][$k]['fi_account'] != '') {
                       
                        $poste->id = $aItem[$j][$k]['fi_account'];
                        $aresult = Impress::parse_formula($this->cn, "OK", $poste->id, $aPeriode[$l]['p_id'], $aPeriode[$l]['p_id']);
                        $tmp_label = $aresult['desc'];
                        $amount['solde'] = $aresult['montant'];
 
                        if ($tmp_label != 'OK') { 
                            $error[] = "<li> " . $aItem[$j][$k]['fi_text'] . $poste->id . '</li>';
                        }
                    }
                    $aReal[$j][$k][$l] = $amount['solde'];
                }
            }
 
        }
        if ( DEBUGNOALYSS < 2 ) { ob_start(); }
        require_once NOALYSS_TEMPLATE . '/anticipation-display.php';
        $r .= ob_get_contents();
        if ( DEBUGNOALYSS < 2 )  { ob_end_clean(); }
        return $r;
    }

References $amount, $aPeriode, $end, $error, $forecast, $l, $per, $poste, $r, $start, $str_end, $str_name, $str_start, _, cn, format_date(), h, and Impress\parse_formula().

Here is the call graph for this function:

div()

static Anticipation::div ( )

static

Definition at line 255 of file anticipation.class.php.

    {
        $r = '<div id="div_anti" style="display:none">';
        $r .= '</div>';
        return $r;
    }

References $r.

getCat()

Anticipation::getCat

(

)

Returns

mixed

Definition at line 56 of file anticipation.class.php.

    {
        return $this->cat;
    }

References $cat.

getForecastId()

Anticipation::getForecastId

(

)

Returns

int|mixed

Definition at line 88 of file anticipation.class.php.

    {
        return $this->forecast_id;
    }

References $forecast_id.

Referenced by input_form().

getItem()

Anticipation::getItem

(

)

Returns

mixed

Definition at line 72 of file anticipation.class.php.

    {
        return $this->item;
    }

References $item.

input_category()

Anticipation::input_category

(

)

Definition at line 106 of file anticipation.class.php.

    {
        $visible=uniqid();
        echo '<h2>';
        echo _("Catégorie");
        echo '<span style="margin-left:5em;font-style:normal;font-size:150%">';
        echo Icon_Action::less($visible, "");
        echo '</span>';
        echo '</h2>';
        
        echo '<div id="anticipation_input_category" >';
        $forecast_category = Forecast_Category_MTable::build();
        $forecast_category->set_forecast_id($this->forecast_id);
        $forecast_category->display_table(" where f_id = $1"
            . " order by fc_order",
            [$this->forecast_id]);
        echo $forecast_category->create_js_script();
        echo '</div>';
        echo <<<EOF
        <script>
        var visible=true;
        var icon=document.getElementById('{$visible}');
icon.onclick=function () {
    
   if ( visible ) { visible = false; $("anticipation_input_category").hide();icon.innerHTML="&#xe824;"}
    else { visible = true;$("anticipation_input_category").show();icon.innerHTML="&#xe827;"}
    }
</script>
EOF;
 
    }

References $forecast_category, _, Forecast_Category_MTable\build(), and Icon_Action\less().

Referenced by input_form().

Here is the call graph for this function:

input_form()

Anticipation::input_form

(

)

display the detail for the forecast , for modifying item, category or name

Definition at line 142 of file anticipation.class.php.

    {
        $this->input_title();
            
        $this->input_category();
        $http=new HttpInput();
        $ac=$http->request("ac");
        echo h2(_("Eléments"));
        $forecast_item = Forecast_Item_MTable::build();
        $forecast_item->set_forecast_id($this->forecast_id);
        $forecast_item->display_table();
        echo '<hr>';
        $href="do.php?".http_build_query(array('ac'=>$ac, 'sa'=>'vw','gDossier'=>Dossier::id(),'f_id'=>$this->forecast_id));
        
        
        $form=dossier::hidden();
        $form.=HtmlInput::hidden('action', '');
        $form.=HtmlInput::hidden('f_id', $this->getForecastId());
        $form.=HtmlInput::hidden('ac', $ac);
        
        echo  '<form method="get" id="form_del" onsubmit="return confirm_box(this,content[\'47\'])" style="display:inline-block">';
        echo $form;
        echo HtmlInput::hidden("action","del");
        echo HtmlInput::submit('del_bt', _('Effacer'));
        echo '</form>';
        
        echo  '<form method="get" id="form_clone" onsubmit="return confirm_box(this,content[\'47\']) " style="display:inline-block" >';
        echo $form;
        echo HtmlInput::hidden("action","clone");
        echo HtmlInput::submit("clone_bt",_("Clone"));
        echo '</form>';
        
        echo HtmlInput::button_anchor(_("Retour"), $href);
                
    }

References $ac, $forecast_item, $form, $href, $http, _, Forecast_Item_MTable\build(), getForecastId(), h2(), input_category(), and input_title().

Here is the call graph for this function:

input_title()

Anticipation::input_title

(

)

Definition at line 101 of file anticipation.class.php.

    {
        require_once NOALYSS_TEMPLATE . "/anticipation-input_title.php";
    }

Referenced by input_form().

object_clone()

Anticipation::object_clone

(

)

Clone completely Forecast and returns the new forecast_id.

Returns

type

Definition at line 266 of file anticipation.class.php.

    {
        $this->cn->start();
        /* save into the table forecast */
        $sql = "insert into forecast(f_name,f_start_date,f_end_date) select 'clone '||f_name,f_start_date,f_end_date 
                from forecast 
                where f_id=$1 returning f_id";
        $new = $this->cn->get_value($sql, array($this->forecast_id));
 
        /* save into forecast_cat */
        $sql = "insert into forecast_category(fc_desc,f_id,fc_order) 
                select fc_desc,$1,fc_order 
                from forecast_category
                where f_id=$2 returning fc_id";
        $array = $this->cn->get_array($sql, array($new, $this->forecast_id));
 
        $old = $this->cn->get_array("select fc_id from forecast_category where f_id=$1", array($this->forecast_id));
        /* save into forecast_item */
        for ($i = 0; $i < count($array); $i++) {
            $this->cn->exec_sql("insert into forecast_item (fi_text,fi_account,fi_order,fc_id,
                           fi_amount,fi_pid) " .
                " select fi_text,fi_account,fi_order,$1,fi_amount,fi_pid " .
                " from forecast_item where fc_id=$2", array($array[$i]['fc_id'], $old[$i]['fc_id']));
        }
        $this->cn->commit();
        return $new;
    }

References $array, $i, $old, $sql, and cn.

setCat()

Anticipation::setCat

(

$cat

)

Parameters

mixed

$cat

Definition at line 64 of file anticipation.class.php.

    {
        $this->cat = $cat;
    }

References $cat.

setForecastId()

Anticipation::setForecastId

(

$forecast_id

)

Parameters

int | mixed

$forecast_id

Definition at line 96 of file anticipation.class.php.

    {
        $this->forecast_id = $forecast_id;
    }

References $forecast_id.

setItem()

Anticipation::setItem

(

$item

)

Parameters

mixed

$item

Definition at line 80 of file anticipation.class.php.

    {
        $this->item = $item;
    }

References $item.

Field Documentation

$cat

Anticipation::$cat

array of object categorie (forecast_category)

Definition at line 39 of file anticipation.class.php.

Referenced by getCat(), and setCat().

$cn

Anticipation::$cn

private

Definition at line 38 of file anticipation.class.php.

$forecast_id

Anticipation::$forecast_id

private

forecast.f_id

Definition at line 41 of file anticipation.class.php.

Referenced by getForecastId(), and setForecastId().

$item

Anticipation::$item

Definition at line 40 of file anticipation.class.php.

Referenced by getItem(), and setItem().

---

The documentation for this class was generated from the following file:

• include/class/anticipation.class.php