group of object operations, used for misc operation More...

Collaboration diagram for Anc_Group_Operation:

Public Member Functions
	__construct ($p_cn, $p_id=0)
	constructor More...

	add ()
	add several rows More...

	form ($p_readonly=0)
	show a form for the operation (several rows) More...

	get_from_array ($p_array)
	fill row from $_POST data More...

	save ()
	save the group of operation but only if the amount is balanced More...

	show ()
	show the form More...

Static Public Member Functions
static	test_me ()

Data Fields
	$a_operation

	$date

	$db

	$id

	$pa_id

Detailed Description

group of object operations, used for misc operation

Definition at line 30 of file anc_group_operation.class.php.

Constructor & Destructor Documentation

◆ __construct()

Anc_Group_Operation::__construct	(	$p_cn,
		$p_id = `0`
	)

constructor

Definition at line 43 of file anc_group_operation.class.php.

    {
        $this->db=$p_cn;
        $this->id=$p_id;
        $this->date=date("d.m.Y");
        $this->nMaxRow=10;
    }

References $p_id, and db.

Member Function Documentation

◆ add()

Anc_Group_Operation::add ( )

add several rows

Definition at line 51 of file anc_group_operation.class.php.

    {
 
        $amount=0;
        try
        {
            $this->db->start();
            foreach ($this->a_operation as $row)
            {
                $add=round($row->oa_amount,2);
                $add=($row->oa_debit=='t')?$add:$add*(-1);
                $amount+=round($add,2);
                $row->add();
            }
            if ( $amount != 0 ) throw new Exception (_('Operation non equilibrée'));
        }
        catch (Exception $e)
        {
              record_log($e);
            echo $e->getTrace();
            $this->db->rollback();
            throw new Exception($e);
        }
        $this->db->commit();
    }

References $amount, $e, $row, db, and record_log().

Here is the call graph for this function:

◆ form()

Anc_Group_Operation::form ( $p_readonly = 0 )

show a form for the operation (several rows)

Returns: the string containing the form but without the form tag

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

    {
        $wDate=new IDate("pdate",$this->date);
        $wDate->table=1;
        $wDate->size=10;
        $wDate->readonly=$p_readonly;
 
        $wDescription=new IText("pdesc");
        $wDescription->table=0;
        $wDescription->size=80;
        $wDescription->readonly=$p_readonly;
        // Show an existing operation
        //
        if ( isset ($this->a_operation[0]))
        {
            $wDate->value=$this->a_operation[0]->oa_date;
            $wDescription->value=$this->a_operation[0]->oa_description;
        }
 
        $ret="";
 
        $ret.='<table style="result"    >';
 
        $ret.="<TR>".td(_("Date")).td($wDate->input())."</tr>";
        $ret.='<tr><td>Description</td>'.
              '<td colspan="3">'.
              $wDescription->input()."</td></tr>";
        $Plan=new Anc_Plan($this->db);
        $aPlan=$Plan->get_list();
        $this->a_operation=(empty($this->a_operation))?[]:$this->a_operation;
        $max=(count($this->a_operation)<$this->nMaxRow)?$this->nMaxRow:count($this->a_operation);
        $ret.='</table><table  id="ago" style="width: 100%;">';
        /* show 10 rows */
        $ret.="<tr>";
        $ret.=th(_("Fiche"),'style="text-align:left"').th("");
        foreach ($aPlan as $d)
        {
            $idx=$d['id'];
            /* array of possible value for the select */
            $aPoste[$idx]=$this->db->make_array("select 0 as value,'-' as label "
                    . " union select po_id as value,".
                                                " po_name||':'||coalesce(po_description,'-') as label ".
                                                " from poste_analytique ".
                                                " where pa_id = ".$idx.
                                                " order by 2 ");
 
            $ret.="<th style=\"text-align:left\">".$d['name']."</th>";
        }
        $ret.="<th></th>".
              "<th style=\"text-align:left\">"._('Montant') ."</th>".
              "<th style=\"text-align:left\">"._("Débit")."</th>".
              "</tr>";
 
        for ($i = 0;$i < $max;$i++)
        {
            if ( $p_readonly == 1 &&   isset($this->a_operation[$i]) && $this->a_operation[$i]->po_id ==0 ) continue;
            $ret.="<tr>";
            $ret.="<td>";
            $card=new ICard("qcode$i");
            $card->set_attribute("typecard", sprintf("[sql] fd_id in (select fd_id from jnt_fic_attr where ad_id=%s)",ATTR_DEF_ACCOUNT));
            $card->set_attribute('label', "qcode{$i}_label");
            $card->setReadOnly($p_readonly);
            $card->value=(isset($this->a_operation[$i]->card))?$this->a_operation[$i]->card:"";
            $ret.=$card->input();
            $ret.=$card->search();
            
            $ret.='</td>';
            $ret.='<td>';
            $label=new ISpan("qcode{$i}_label");
            $label->style="vertical-align:top";
            $ret.=$label->input();
            $ret.='</td>';
            foreach ($aPlan as $d)
            {
                $idx=$d['id'];
                // init variable
                $wSelect=new ISelect("pop".$i."plan".$idx);
                $wSelect->value=$aPoste[$idx];
                $wSelect->size=12;
 
                $wSelect->readOnly=$p_readonly;
                if ( isset($this->a_operation[$i]))
                {
                    $wSelect->selected=$this->a_operation[$i]->po_id;
                }
                $ret.=td($wSelect->input());
            }
            $wAmount=new INum("pamount$i",0.0);
            $wAmount->size=12;
            $wAmount->table=1;
            $wAmount->javascript=" onChange=format_number(this);caod_checkTotal()";
            $wAmount->readOnly=$p_readonly;
 
            $wDebit=new ICheckBox("pdeb$i");
            $wDebit->readOnly=$p_readonly;
            $wDebit->javascript=" onChange=caod_checkTotal()";
            if ( isset ($this->a_operation[$i]))
            {
                $wSelect->selected=$this->a_operation[$i]->po_id;
                $wAmount->value=$this->a_operation[$i]->oa_amount;
                $wDebit->value=$this->a_operation[$i]->oa_debit;
                if ( $wDebit->value=='t')
                {
                    $wDebit->selected=true;
                }
 
            }
 
            // build the table
 
            $ret.="<TD></TD>";
            $ret.=$wAmount->input();
            $ret.=td($wDebit->input());
 
            $ret.="</tr>";
        }
        $ret.="</table>";
        if ( $p_readonly==false)
        {
            $add_row=new IButton('Ajouter');
            $add_row->label=_('Ajouter une ligne');
            $add_row->javascript='anc_add_row(\'ago\');';
            $ret.=HtmlInput::hidden('nbrow',$max);
 
            $ret.=$add_row->input();
        }
        return $ret;
    }

References $card, $i, $idx, $label, $max, $p_readonly, $ret, $wDate, ATTR_DEF_ACCOUNT, db, HtmlInput\hidden(), td(), and th().

Referenced by show().

Here is the call graph for this function:

◆ get_from_array()

Anc_Group_Operation::get_from_array ( $p_array )

fill row from $_POST data

Definition at line 211 of file anc_group_operation.class.php.

    {
        $Plan=new Anc_Plan($this->db);
        $aPlan=$Plan->get_list();
 
 
        for ( $i = 0;$i <$p_array['nbrow'];$i++)
        {
            foreach ($aPlan as $d)
            {
                $idx=$d['id'];
                $p=new Anc_Operation($this->db);
                $p->oa_amount=$p_array["pamount$i"];
 
                $p->oa_description=$p_array["pdesc"];
                $p->oa_row=$i;
                $p->oa_date=$p_array['pdate'];
                $p->j_id=0;
                $p->oa_debit=(isset ($p_array["pdeb$i"]))?'t':'f';
                $p->oa_group=0;
                $p->card=(isset($p_array["qcode".$i]))?$p_array["qcode".$i]:"";
                $p->po_id=$p_array["pop$i"."plan".$idx];
                $p->pa_id=$idx;
                $this->a_operation[]=clone $p;
            }
        }
    }

References $i, $idx, $p, $p_array, and db.

◆ save()

Anc_Group_Operation::save ( )

save the group of operation but only if the amount is balanced

Definition at line 240 of file anc_group_operation.class.php.

    {
        $this->db->start();
        try
        {
            $oa_group=$this->db->get_next_seq('s_oa_group');
            for ($i=0;$i<count($this->a_operation);$i++)
            {
                if ( $this->a_operation[$i]->po_id == 0 ) continue;
                $this->a_operation[$i]->oa_group=$oa_group;
                $this->a_operation[$i]->add();
            }
        }
        catch (Exception $ex)
        {
              record_log($e);
            echo '<span class="error">'.
            'Erreur dans l\'enregistrement '.
            __FILE__.':'.__LINE__.' '.
            $ex->getMessage();
            $p_cn->rollback();
            throw new Exception("Erreur ".$ex->getMessage());
 
        }
        $this->db->commit();
    }

References $e, $ex, $i, $oa_group, db, and record_log().

Here is the call graph for this function:

◆ show()

Anc_Group_Operation::show ( )

show the form

Definition at line 267 of file anc_group_operation.class.php.

    {
        return $this->form(1);
    }

References form().

Here is the call graph for this function:

◆ test_me()

static Anc_Group_Operation::test_me ( )

static

Definition at line 271 of file anc_group_operation.class.php.

    {
        $dossier=dossier::id();
        $cn=Dossier::connect();
 
        if ( isset($_POST['go']))
        {
            $b=new Anc_Group_Operation($cn);
            $b->get_from_array($_POST);
            return;
        }
 
        $a=new Anc_Group_Operation($cn);
        echo '<form method="post">';
        echo $a->form();
        echo dossier::hidden();
        echo '<input type="submit" name="go">';
        echo '</form>';
 
    }