Ext_List_Assujetti Class Reference

Inheritance diagram for Ext_List_Assujetti:

Collaboration diagram for Ext_List_Assujetti:

Public Member Functions
	from_array ($p_array)
	display ()
	load ()
	verify ()
	insert ()
	update ()
	compute ()
	display_declaration_amount ($readonly=false)
	find_tva_code ($p_array)
	get_parameter ($p_string)
	set_parameter ($p_string, $p_value)
	get_info ()
	save ()
	blank ($p_year, $p_periode, $p_flag_quaterly)
	display_info ()
	display the information about the company More...

Static Public Member Functions
static	choose_periode ($by_year=false)

Protected Attributes
	$variable

Private Attributes
	$aChild =array()

Detailed Description

Definition at line 30 of file class_ext_list_assujetti.php.

Member Function Documentation

Ext_Tva_Gen::blank (   $p_year,   $p_periode,   $p_flag_quaterly  )

inherited

Definition at line 132 of file class_ext_tvagen.php.

References $GLOBALS, $p_year, and Ext_Tva_Gen\set_parameter().

                                                      {
    // load parameter from myown
    $own=new Own($this->db);
    $this->set_parameter("name",$own->MY_NAME);
    $this->set_parameter("num_tva",$own->MY_TVA);
    $this->set_parameter('adress',$own->MY_STREET.",".$own->MY_NUMBER);
    $this->set_parameter('country',$own->MY_COUNTRY." ".$own->MY_CP." ".$own->MY_COMMUNE);
    $this->set_parameter('flag_periode',$p_flag_quaterly);
    $this->set_parameter('periode_dec',$p_periode);
    $this->set_parameter('exercice',$p_year);

    try {
      $this->verify() ;
    } catch ( Exception $e) {
      echo $e->getMessage();
      throw $e;
    }
    // by month
    if ( $p_flag_quaterly == 1) {
      // start periode = 01 to 31, $p_periode contains the month
      $per_start="01.".$p_periode.".".$p_year;
      $day=31;
      $per_end="31".".".$p_periode.".".$p_year;
      while ( checkdate($p_periode,$day,$p_year) == false && $day > 25) {
    $day--;
    $per_end=$day.".".$p_periode.".".$p_year;
      }
      if ($day < 28 ) { echo __FILE__.__LINE__." Erreur de date $day"; exit;}
    }

    if ( $p_flag_quaterly == 2 ) {
      // compute start periode
      $per_start=$GLOBALS['quaterly_limit'][$p_periode][0].".".$p_year;
      $per_end=$GLOBALS['quaterly_limit'][$p_periode][1].".".$p_year;

    }
    if ( $p_flag_quaterly == 3 ) {
      // compute start periode
      $per_start='01.01.'.$p_year;
      $per_end='31.12.'.$p_year;
    }

    $this->set_parameter('start_periode',$per_start);
    $this->set_parameter('end_periode',$per_end);

  }

static Ext_List_Assujetti::choose_periode (   $by_year = false )

static

Definition at line 46 of file class_ext_list_assujetti.php.

References $_REQUEST, $r, $str_hidden, $str_submit, $str_year, and $year.

                                                 {

    // year
    $year = new IText('year');
    $year->size=4;
    $str_year=$year->input();


    $str_submit=HtmlInput::submit('decl',_('Afficher'));
    $str_hidden=HtmlInput::extension().dossier::hidden();
    if (isset($_REQUEST['sa']))
      $str_hidden.=HtmlInput::hidden('sa',$_REQUEST['sa']);
    $r='<form class="print" method="get">';
    $r.="Année :".$str_year;
    $r.=$str_submit;
    $r.=$str_hidden;
    $r.=HtmlInput::request_to_hidden(array('ac'));
    $r.='</form>';
    return $r;
  }

Ext_List_Assujetti::compute

(

)

Definition at line 183 of file class_ext_list_assujetti.php.

References $a, $amount, $array, $fiche, $sql, and Listing\find_tva_code().

                    {
    /* retrieve accounting customer */
    $code_customer=new Acc_Parm_Code($this->db);
    $code_customer->p_code='CUSTOMER';
    $code_customer->load();
    $a=$this->find_tva_code('ASSUJETTI');
    if (trim($a)=='') $a=-1;
    $sql=<<<EOF
      select sum(j_montant) as amount,j_qcode
      from jrnx
      where j_grpt in (select distinct j_grpt from quant_sold join jrnx using (j_id) where qs_vat_code in ($a) )
      and j_poste::text like $1||'%'
      and (j_date >= to_date($2,'DD.MM.YYYY') and j_date <= to_date($3,'DD.MM.YYYY'))
      group by j_qcode
EOF;
    // get all of them
    $all=$this->db->get_array($sql,array($code_customer->p_value,
                     $this->start_periode,
                     $this->end_periode
                     )
                  );
    $array=array();

    // retrieve missing and compute an array
    for ($i=0;$i<count($all);$i++){
      $child=new Ext_List_Assujetti_Child($this->db);


      $child->set_parameter('qcode',$all[$i]['j_qcode']);
      $fiche=new Fiche($this->db);
      $fiche->get_by_qcode($all[$i]['j_qcode'],false);
      $num_tva=$fiche->strAttribut(ATTR_DEF_NUMTVA);
      $child->set_parameter('tva_num',$num_tva);
      $sq="select sum(qs_vat) from quant_sold
where qs_client = $1 and j_id in (select distinct j_id from jrnx where  j_date >= to_date($2,'DD.MM.YYYY')
                                  and j_date <= to_date($3,'DD.MM.YYYY')
                                  )
     and qs_vat_code in ($a)
";
      // if in the same operation, we use 2 different tva code, the amount is incorrect if one of them is
      // excluded
      $exclude="select coalesce(sum(qs_price),0) from quant_sold
where qs_client = $1 and j_id in (select distinct j_id from jrnx where  j_date >= to_date($2,'DD.MM.YYYY')
                                  and j_date <= to_date($3,'DD.MM.YYYY')
                                  )
     and qs_vat_code not in ($a)
";
      $excl=$this->db->get_value($exclude,array($fiche->id,
                        $this->start_periode,
                        $this->end_periode));
      $amount_vat=$this->db->get_value($sq,array($fiche->id,
                         $this->start_periode,
                         $this->end_periode));
      $amount=$all[$i]['amount']-$amount_vat-$excl;
      $child->set_parameter('amount',$amount);
      $child->set_parameter('amount_vat',$amount_vat);

      $child->set_parameter('name_child',$fiche->strAttribut(ATTR_DEF_NAME));

      $array[]=$child;
    }//end for
    $this->aChild=$array;
  }

Ext_List_Assujetti::display

(

)

Definition at line 101 of file class_ext_list_assujetti.php.

References $_REQUEST, $r, a_id, display_declaration_amount(), Ext_Tva_Gen\display_info(), and id.

                     {
    $r= '<form class="print" id="readonly">';
    $r.=HtmlInput::request_to_hidden(array('ac'));
    $r.=$this->display_info();
    $r.=$this->display_declaration_amount(true);
    $r.='</form>';
    $js_remove=sprintf("onclick=\"if ( confirm('%s')){remove_form('%s',%d,%d,'lc');}\"",
               "Vous confirmez vouloir effacer ?",
            $_REQUEST['plugin_code'],
            dossier::id(),
            $this->a_id);
    $r.=HtmlInput::button('Effacer','Effacer',$js_remove);

    $r.= create_script("$('readonly').disable();");
    return $r;
  }

Ext_List_Assujetti::display_declaration_amount

(

$readonly = false

)

Todo:

finish it

Definition at line 249 of file class_ext_list_assujetti.php.

References $a, $amount, $r, $res, and Ext_Tva_Gen\get_parameter().

Referenced by display().

                                                       {
    $res='<fieldset><legend>Listing</legend>';
    $res.= '<table id="tb_dsp" class="result" style="width:80%;">';
    $clean=new IButton('rm_b');
    $clean->label='Efface ligne';
    $clean->javascript="deleteRow('tb_dsp',this);";

    $r='';
    $r.=th('QuickCode');
    $r.=th('Name');
    $r.=th('Code Pays et numéro de TVA');
    $r.=th('montant CA');
    $r.=th('montant TVA');
    $r.=th('');
    $amount=0;$amount_vat=0;
    $res.=tr($r);
    for ($i=0;$i<count($this->aChild);$i++) {
      $a=new IText('qcode[]',$this->aChild[$i]->get_parameter('qcode'));
      $b=new IText('name_child[]',$this->aChild[$i]->get_parameter('name_child'));
      $c=new IText('tva_num_child[]',$this->aChild[$i]->get_parameter('tva_num'));
      $e=new INum('amount[]',$this->aChild[$i]->get_parameter('amount'));
      $d=new INum('amount_vat[]',$this->aChild[$i]->get_parameter('amount_vat'));

      $amount+=round($this->aChild[$i]->get_parameter('amount'),2);
      $amount_vat+=round($this->aChild[$i]->get_parameter('amount_vat'),2);
      $r=td($a->input());
      $r.=td($b->input());
      $r.=td($c->input());
      $r.=td($e->input());
      $r.=td($d->input());
     if (! $readonly) $r.=td($clean->input());
      $res.=tr($r);

    }
    if ( $readonly )
    {
        $r=td('');
        $r.=td('');
        $r.=td(hb('Total'));
        $r.=td(hb(sprintf('%.02f',$amount)));
        $r.=td(hb(sprintf('%.02f',$amount_vat)));
        $res.=tr($r);
    }

    $res.='</table>';
    $res.='</fieldset>';
    return $res;
  }

Ext_Tva_Gen::display_info ( )

inherited

display the information about the company

Definition at line 182 of file class_ext_tvagen.php.

References $exercice, $r, and $str_date.

Referenced by Ext_List_Intra\display(), display(), and Ext_Tva\display().

                         {
    $itva=new IText('num_tva',$this->num_tva);$str_tva=$itva->input();
    $iname=new IText('name',$this->tva_name); $str_name=$iname->input();
    $iadress=new IText('adress',$this->adress);$str_adress=$iadress->input();
    $icountry=new IText('country',$this->country);$str_country=$icountry->input();

    /* date */

    if (isset($this->date_decl)) { $idate=new IText('date',format_date($this->date_decl));$str_date=$idate->input();}

    /* periode */

    if ( isset($this->start_date) ){
      $str_start=format_date($this->start_date);
      $str_end=format_date($this->end_date);

    }
    $ianne=$this->exercice;
    ob_start();
    require_once('form_decl_info.php');
    $r=ob_get_contents();
    ob_end_clean();
    return $r;
  }

Listing::find_tva_code (   $p_array )

inherited

Definition at line 29 of file class_listing.php.

References $array.

Referenced by Ext_List_Intra\compute(), and compute().

    {
        $array=$this->db->make_list("
            select distinct tva_id  from tva_belge.parameter_chld
            where
            pcode=$1",
                array($p_array));

        return $array;
    }

Ext_List_Assujetti::from_array

(

$p_array

)

Definition at line 67 of file class_ext_list_assujetti.php.

References $amount, $array, and $name.

                               {
    if ( isset($p_array['name_child'])) {
      $name=$p_array['name_child'];
      $qcode=$p_array['qcode'];
      $code=$p_array['plugin_code'];
      $tva_num=$p_array['tva_num_child'];
      $amount=$p_array['amount'];
      $amount_vat=$p_array['amount_vat'];

      // retrieve missing and compute an array
      for ($i=0;$i<count($name);$i++){
    $child=new Ext_List_Assujetti_Child($this->db);
    $child->set_parameter('amount',$amount[$i]);
    $child->set_parameter('amount_vat',$amount_vat[$i]);
    $child->set_parameter('qcode',$qcode[$i]);
    $child->set_parameter('name_child',$name[$i]);
    $child->set_parameter('tva_num',$tva_num[$i]);

    $array[]=$child;
      }//end for
      $this->aChild=$array;
    } else
      $this->aChild=array();

    $this->start_periode=$p_array['start_periode'];
    $this->end_periode=$p_array['end_periode'];
    $this->flag_periode=$p_array['flag_periode'];
    $this->tva_name=$p_array['name'];
    $this->num_tva=$p_array['num_tva'];
    $this->adress=$p_array['adress'];
    $this->country=$p_array['country'];
    $this->periode_dec=$p_array['periode_dec'];
    $this->exercice=$p_array['exercice'];
  }

Ext_Tva_Gen::get_info ( )

inherited

Definition at line 72 of file class_ext_tvagen.php.

{    return var_export(self::$variable,true);  }

Ext_Tva_Gen::get_parameter (   $p_string )

inherited

Definition at line 54 of file class_ext_tvagen.php.

Referenced by Ext_List_Intra\display_declaration_amount(), display_declaration_amount(), Ext_Tva\display_declaration_amount(), and Ext_Tva_Gen\save().

                                           {
    if ( array_key_exists($p_string,$this->variable) ) {
      $idx=$this->variable[$p_string];
      return $this->$idx;
    }
    else
      throw new Exception (__FILE__.":".__LINE__.'Erreur attribut inexistant');
  }

Ext_List_Assujetti::insert

(

)

Definition at line 149 of file class_ext_list_assujetti.php.

References $sql, and a_id.

                    {
    $this->db->start();

    /* insert into the first table */
    $sql=<<<EOF
      INSERT INTO tva_belge.assujetti(
                      start_date, end_date,  periodicity, tva_name,
                      num_tva, adress, country,  periode_dec,exercice)
      VALUES (to_date($1,'DD.MM.YYYY'),to_date($2,'DD.MM.YYYY'),$3,$4,$5,$6,$7,$8,$9) returning a_id;
EOF;
    $this->a_id=$this->db->get_value($sql,
                     array(
                       $this->start_periode, /* 1 */
                       $this->end_periode,
                       $this->flag_periode, /* 3 */
                       $this->tva_name,
                       $this->num_tva, /* 5 */
                       $this->adress,
                       $this->country, /* 7 */
                       $this->periode_dec,
                       $this->exercice /* 9 */
                       )
                     );
    /* insert into the child table */
    for ($e=0;$e<count($this->aChild);$e++){
      $this->aChild[$e]->set_parameter('depend',$this->a_id);
      $this->aChild[$e]->insert();
    }
    $this->db->commit();

  }

Ext_List_Assujetti::load

(

)

Definition at line 117 of file class_ext_list_assujetti.php.

References $array, $res, $sql, and a_id.

                  {
    $sql="select * from tva_belge.assujetti where a_id=$1";

    $res=$this->db->get_array(
                  $sql,
                  array($this->a_id)
                  );
    if ( $this->db->count() == 0 ) return 0;
    foreach ($res[0] as $idx=>$value) { $this->$idx=$value; }
    // load child
    $sql="select * from tva_belge.assujetti_chld where a_id=$1";
    $res=$this->db->get_array(
                  $sql,
                  array($this->a_id)
                  );
    $nb=$this->db->count();
    $array=array();
    // retrieve missing and compute an array
    for ($i=0;$i<$nb;$i++){
      $child=new Ext_List_Assujetti_Child($this->db);
      foreach ($res[$i] as $idx=>$value){
    $child->$idx=$value;
      }
      $array[]=$child;
    }//end for
    $this->aChild=$array;

    return 1;
  }

Ext_Tva_Gen::save ( )

inherited

Definition at line 74 of file class_ext_tvagen.php.

References Ext_Tva_Gen\get_parameter().

                         {
  /* please adapt */
    if (  $this->get_parameter("id") == 0 )
      $this->insert();
    else
      $this->update();
  }

Ext_Tva_Gen::set_parameter (   $p_string,   $p_value  )

inherited

Definition at line 62 of file class_ext_tvagen.php.

Referenced by Ext_Tva_Gen\blank(), and Ext_Tva\compute().

                                                    {
    if ( array_key_exists($p_string,$this->variable) ) {
      $idx=$this->variable[$p_string];
      $this->$idx=$p_value;
    }
    else
      throw new Exception (__FILE__.":".__LINE__.'Erreur attribut inexistant');


  }

Ext_List_Assujetti::update

(

)

Definition at line 180 of file class_ext_list_assujetti.php.

                    {
  }

Ext_List_Assujetti::verify

(

)

Definition at line 146 of file class_ext_list_assujetti.php.

                    {
    return 0;
  }

Field Documentation

Ext_List_Assujetti::$aChild =array()

private

Definition at line 45 of file class_ext_list_assujetti.php.

Ext_List_Assujetti::$variable

protected

Initial value:

= array(
                  "id"=>"a_id",
                  "date_decl"=>"date_decl",
                  "start_periode"=>"start_periode",
                  "end_periode"=>"end_periode",
                  "xml_file"=>"xml_file",
                  "num_tva"=>"num_tva",
                  "name"=>"tva_name",
                  "adress"=>"adress",
                  "country"=>"country",
                  "flag_periode"=>"flag_periode",
                  "exercice"=>"exercice",
                  "periode_dec"=>"periode_dec"
                  )

Definition at line 31 of file class_ext_list_assujetti.php.

---

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

• tva/class_ext_list_assujetti.php