예제 #1
0
 /**
  * @brief save the operation into the jrnx,jrn, ,
  *  CA and pre_def
  * @param$p_array
  *
  * \return array with [0] = false if failed otherwise true, [1] error
  * code
  */
 function save($p_array = null)
 {
     if ($p_array == null) {
         throw new Exception('save cannot use a empty array');
     }
     global $g_parameter;
     extract($p_array);
     try {
         $msg = $this->verify($p_array);
         if (!empty($msg)) {
             echo $this->display_warning($msg, _("Attention : il vaut mieux utiliser les fiches que les postes comptables "));
         }
         $this->db->start();
         $seq = $this->db->get_next_seq('s_grpt');
         $internal = $this->compute_internal_code($seq);
         $group = $this->db->get_next_seq("s_oa_group");
         $tot_amount = 0;
         $tot_deb = 0;
         $tot_cred = 0;
         $oPeriode = new Periode($this->db);
         $check_periode = $this->check_periode();
         if ($check_periode == false) {
             $oPeriode->find_periode($e_date);
         } else {
             $oPeriode->id = $period;
         }
         $count = 0;
         for ($i = 0; $i < $nb_item; $i++) {
             if (!isset(${'qc_' . $i}) && !isset(${'poste' . $i})) {
                 continue;
             }
             $acc_op = new Acc_Operation($this->db);
             $quick_code = "";
             // First we save the jrnx
             if (isset(${'qc_' . $i})) {
                 $qc = new Fiche($this->db);
                 $qc->get_by_qcode(${'qc_' . $i}, false);
                 $sposte = $qc->strAttribut(ATTR_DEF_ACCOUNT);
                 /*  if there are 2 accounts take following the deb or cred */
                 if (strpos($sposte, ',') != 0) {
                     $array = explode(",", $sposte);
                     $poste = isset(${'ck' . $i}) ? $array[0] : $array[1];
                 } else {
                     $poste = $sposte;
                     if ($poste == '') {
                         throw new Exception(sprintf(_("La fiche %s n'a pas de poste comptable"), ${"qc_" . $i}));
                     }
                 }
                 $quick_code = ${'qc_' . $i};
             } else {
                 $poste = ${'poste' . $i};
             }
             $acc_op->date = $e_date;
             // compute the periode is do not check it
             if ($check_periode == false) {
                 $acc_op->periode = $oPeriode->p_id;
             }
             $acc_op->desc = null;
             if (strlen(trim(${'ld' . $i})) != 0) {
                 $acc_op->desc = ${'ld' . $i};
             }
             $acc_op->amount = round(${'amount' . $i}, 2);
             $acc_op->grpt = $seq;
             $acc_op->poste = $poste;
             $acc_op->jrn = $this->id;
             $acc_op->type = isset(${'ck' . $i}) ? 'd' : 'c';
             $acc_op->qcode = $quick_code;
             $j_id = $acc_op->insert_jrnx();
             $tot_amount += round($acc_op->amount, 2);
             $tot_deb += $acc_op->type == 'd' ? $acc_op->amount : 0;
             $tot_cred += $acc_op->type == 'c' ? $acc_op->amount : 0;
             if ($g_parameter->MY_ANALYTIC != "nu") {
                 if (preg_match("/^[6,7]+/", $poste) == 1) {
                     // for each item, insert into operation_analytique */
                     $op = new Anc_Operation($this->db);
                     $op->oa_group = $group;
                     $op->j_id = $j_id;
                     $op->oa_date = $e_date;
                     $op->oa_debit = $acc_op->type == 'd' ? 't' : 'f';
                     $op->oa_description = $desc;
                     $op->save_form_plan($p_array, $count, $j_id);
                     $count++;
                 }
             }
         }
         // loop for each item
         $acc_end = new Acc_Operation($this->db);
         $acc_end->amount = $tot_deb;
         if ($check_periode == false) {
             $acc_end->periode = $oPeriode->p_id;
         }
         $acc_end->date = $e_date;
         $acc_end->desc = $desc;
         $acc_end->grpt = $seq;
         $acc_end->jrn = $this->id;
         $acc_end->mt = $mt;
         $jr_id = $acc_end->insert_jrn();
         $this->jr_id = $jr_id;
         if ($jr_id == false) {
             throw new Exception(_('Balance incorrecte'));
         }
         $acc_end->pj = $e_pj;
         /* if e_suggest != e_pj then do not increment sequence */
         if (strcmp($e_pj, $e_pj_suggest) == 0 && strlen(trim($e_pj)) != 0) {
             $this->inc_seq_pj();
         }
         $this->pj = $acc_end->set_pj();
         $this->db->exec_sql("update jrn set jr_internal='" . $internal . "' where " . " jr_grpt_id = " . $seq);
         $this->internal = $internal;
         // Save now the predef op
         //------------------------
         if (isset($opd_name) && trim($opd_name) != "") {
             $opd = new Pre_Op_Advanced($this->db);
             $opd->get_post();
             $opd->save();
         }
         if (isset($this->with_concerned) && $this->with_concerned == true) {
             $orap = new acc_reconciliation($this->db);
             $orap->jr_id = $jr_id;
             $orap->insert($jrn_concerned);
         }
         /**
          * Save the file is any
          */
         if (isset($_FILES["pj"])) {
             $this->db->save_upload_document($seq);
         }
     } catch (Exception $a) {
         throw $a;
     } catch (Exception $e) {
         $this->db->rollback();
         echo _('OPERATION ANNULEE ');
         echo '<hr>';
         echo __FILE__ . __LINE__ . $e->getMessage();
         exit;
     }
     $this->db->commit();
     return true;
 }
예제 #2
0
    die('Appel direct ne sont pas permis');
}
if ($g_user->check_module('PREDOP') == 0) {
    exit;
}
$name = HtmlInput::default_value_post("opd_name", "");
if (trim($name) != '') {
    $od_id = HtmlInput::default_value_post("od_id", -1);
    if ($od_id == -1 || isNumber($od_id) == 0) {
        return;
    }
    $cn->exec_sql('delete from op_predef where od_id=$1', array($od_id));
    $cn->exec_sql("delete from op_predef_detail where od_id=\$1", array($od_id));
    $jrn_type = HtmlInput::default_value_post("jrn_type", null);
    switch ($jrn_type) {
        case 'ACH':
            $operation = new Pre_op_ach($cn);
            break;
        case 'VEN':
            $operation = new Pre_op_ven($cn);
            break;
        case 'ODS':
            $operation = new Pre_Op_Advanced($cn);
            break;
        default:
            throw new Exception(_('Type de journal invalide'));
    }
    $operation->get_post();
    $operation->save();
    $cn->commit();
}